google docs
Moderator: TFF Mods
-
- Da Cynic
- Posts: 7462
- Joined: Thu Jan 01, 1970 12:00 am
- Location: Nice Red Uniforms and Fanatical devotion to the Pope!
-
- Da Cynic
- Posts: 7462
- Joined: Thu Jan 01, 1970 12:00 am
- Location: Nice Red Uniforms and Fanatical devotion to the Pope!
Re: google docs
Black2 is having a go, using the Zen Excel Spreadsheet (Digger's effort) as a base
Reason: ''
-
- Da Cynic
- Posts: 7462
- Joined: Thu Jan 01, 1970 12:00 am
- Location: Nice Red Uniforms and Fanatical devotion to the Pope!
- HairyPete77
- Veteran
- Posts: 249
- Joined: Wed May 22, 2013 8:25 pm
- Contact:
Re: google docs
I use GDocs for some non-BB stuff and have got some simple lists and forms on my blog done using GDocs.
Whenever I have tried to do something more substantial - which has included trying BB rosters - I've always found the formatting options to be too restrictive or cumbersome and the formulas not as easy to use as Excel. I always end up going back to what I know which is Excel.
There's no reason why it couldn't be used to share rosters or tournament/league scores etc.
I've not tried it for over a year but may give it another look myself to see if it has got easier.
Whenever I have tried to do something more substantial - which has included trying BB rosters - I've always found the formatting options to be too restrictive or cumbersome and the formulas not as easy to use as Excel. I always end up going back to what I know which is Excel.
There's no reason why it couldn't be used to share rosters or tournament/league scores etc.
I've not tried it for over a year but may give it another look myself to see if it has got easier.
Reason: ''
http://amanandhistoys.wordpress.com and https://twitter.com/amanandhistoys
TO of ExeBowl and Stunty Champion at Exiles 2014
TO of ExeBowl and Stunty Champion at Exiles 2014
- HairyPete77
- Veteran
- Posts: 249
- Joined: Wed May 22, 2013 8:25 pm
- Contact:
Re: google docs
I took a quick look at this earlier and it looks as if there's been a pretty big upgrade on the Sheets app. I imported my tournament roster (based on Halfling Scribe) and only one function didn't convert. It's a pretty big one - the population of positions and skills based on race - but I think it can be resolved with a bit more research. I'll look again later.
Reason: ''
http://amanandhistoys.wordpress.com and https://twitter.com/amanandhistoys
TO of ExeBowl and Stunty Champion at Exiles 2014
TO of ExeBowl and Stunty Champion at Exiles 2014
- BigSpud
- Rookie
- Posts: 12
- Joined: Mon Sep 29, 2003 9:24 am
- Location: Essex, England
- Contact:
Re: google docs
99% is done, unfortunately Google sheets can't do dependent drop downs. You use this to get the list of allowed players from the selected race. I have a script that should work, I'm just debugging it...
Reason: ''
Food blog at BigSpud
- Toffer
- Veteran
- Posts: 186
- Joined: Sat Oct 22, 2011 9:27 am
- Location: Blenheim, NZ
Re: google docs
I use Google docs a lot in work. not sure how easy it would be for BB stuff. think of it as a collaborative Microsoft office with less editing tools
Reason: ''
- HairyPete77
- Veteran
- Posts: 249
- Joined: Wed May 22, 2013 8:25 pm
- Contact:
Re: google docs
Black2 that was exactly my problem...but I've got it working now. PM me if you want what I've done.
I don't know how to publish what I've done etc but I'm sure we can get over that.
In theory, given that my original Excel was based on the Halfling Scribe Tournament spreadsheet, the whole of the original could be transferred to GDocs by someone. The dropdown list bit is the only issue that needs a little coding to do.
Pete
I don't know how to publish what I've done etc but I'm sure we can get over that.
In theory, given that my original Excel was based on the Halfling Scribe Tournament spreadsheet, the whole of the original could be transferred to GDocs by someone. The dropdown list bit is the only issue that needs a little coding to do.
Pete
Reason: ''
http://amanandhistoys.wordpress.com and https://twitter.com/amanandhistoys
TO of ExeBowl and Stunty Champion at Exiles 2014
TO of ExeBowl and Stunty Champion at Exiles 2014
- sann0638
- Kommissar Enthusiasmoff
- Posts: 6609
- Joined: Mon May 08, 2006 10:24 am
- Location: Swindon, England
Re: google docs
I'd be interested in seeing it.
Reason: ''
NAF Ex-President
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
Founder of SAWBBL, Swindon and Wiltshire's BB League - find us on Facebook and Discord
NAF Data wrangler
- BigSpud
- Rookie
- Posts: 12
- Joined: Mon Sep 29, 2003 9:24 am
- Location: Essex, England
- Contact:
Re: google docs
Pete has kindly shared his work with me. It's moved it on leaps and bounds. Great stuff!
I need to incorporate a little more calculation into the player value, then I think we're there. Definitely finished by the weekend.
I need to incorporate a little more calculation into the player value, then I think we're there. Definitely finished by the weekend.
Reason: ''
Food blog at BigSpud