daveallan81 Posted March 3, 2013 Report Share Posted March 3, 2013 I've been working on a full series Excel workbook for the GP and to check it all works I ran it for the 2012 season. All the rounds are on YouTube so I was able to fill the results in 'real-time' and after not a little jiggery-pokery everything seems in order so I should have the 2013 one ready shortly. In the meantime if you'd like to take a look via the link in my signature, then navigate to the Speedway Grand Prix folder, you'll find the completed Excel workbook and a PDF file compiled from the finished workbook pages. The Excel sheet is read-only just to show the layout and formatting. All comments/opinions welcomed although I will add that the layout of the sheets are directly related to producing the PDF file or printout so the sizes have to remain as they are. And it's best viewed in 'full-screen' mode especially if you have a widescreen monitor. 1 Quote Link to comment Share on other sites More sharing options...
daveallan81 Posted March 4, 2013 Author Report Share Posted March 4, 2013 The 2013 workbook is now available along with a tutorial for completing it. Enjoy Quote Link to comment Share on other sites More sharing options...
kiwi Posted March 4, 2013 Report Share Posted March 4, 2013 looks real good, only 1 criticism who is Craig Holder 2 Quote Link to comment Share on other sites More sharing options...
Soul Crew Posted March 4, 2013 Report Share Posted March 4, 2013 There is a guy somewhere in Manchester who will be getting very excited.... 2 Quote Link to comment Share on other sites More sharing options...
daveallan81 Posted March 4, 2013 Author Report Share Posted March 4, 2013 (edited) looks real good, only 1 criticism who is Craig Holder He's Chris's evil twin... Thanks Kiwi, I'll fix that ASAP. Edit: Fixed Edited March 4, 2013 by daveallan81 Quote Link to comment Share on other sites More sharing options...
waiheke1 Posted March 5, 2013 Report Share Posted March 5, 2013 The leaderboard now no longer picks up Chris Holder - possibly it's trying to look up "Craig" Holder and not finding any data? Quote Link to comment Share on other sites More sharing options...
daveallan81 Posted March 5, 2013 Author Report Share Posted March 5, 2013 Thanks - yes missed a bit of the coding. Should be sorted now. Appreciate the testing, anything looks wrong at all keep letting me know (although hopeful that's it sorted). Started on a SWC workbook as well, thought it might come in handy. Quote Link to comment Share on other sites More sharing options...
21st century heathen Posted March 5, 2013 Report Share Posted March 5, 2013 Please note new thread for all SGP and SWC race cards. Thanks. http://www.speedway-forum.co.uk/forums/index.php?showtopic=72860 1 Quote Link to comment Share on other sites More sharing options...
Losthammer Posted March 5, 2013 Report Share Posted March 5, 2013 Thanks - yes missed a bit of the coding. Should be sorted now. Appreciate the testing, anything looks wrong at all keep letting me know (although hopeful that's it sorted). Started on a SWC workbook as well, thought it might come in handy. I've just downloaded the GP 2013 spreadsheet and the UK 15 heat spreadsheet to Dropbox and it's asking for a password for opening both. Is this something you've just added? Was going to try and see if it worked on my iPad. Thanks... Quote Link to comment Share on other sites More sharing options...
daveallan81 Posted March 5, 2013 Author Report Share Posted March 5, 2013 Interesting. There should be no password required to open and use the files. I've just downloaded both and haven't received any password request. Can I just confirm that this is as you are double-clicking the file to open? Quote Link to comment Share on other sites More sharing options...
willstaxi Posted March 5, 2013 Report Share Posted March 5, 2013 I've just downloaded the GP 2013 spreadsheet and the UK 15 heat spreadsheet to Dropbox and it's asking for a password for opening both. Is this something you've just added? Was going to try and see if it worked on my iPad. Thanks... Interesting. There should be no password required to open and use the files. I've just downloaded both and haven't received any password request. Can I just confirm that this is as you are double-clicking the file to open? I am having the same problem on my I Pad, works fine on my desktop I have tried my Dropbox and I Pad passwords but they do not work What a fantastic bit of work,many thanks Quote Link to comment Share on other sites More sharing options...
daveallan81 Posted March 5, 2013 Author Report Share Posted March 5, 2013 I am having the same problem on my I Pad, works fine on my desktop I have tried my Dropbox and I Pad passwords but they do not work What a fantastic bit of work,many thanks From the quickfire reading I've done this seems to be an Excel/Mac/iPad conflict. I'm seeing an app called 'Numbers' being touted as the closest thing to MS Excel. Quote Link to comment Share on other sites More sharing options...
Losthammer Posted March 5, 2013 Report Share Posted March 5, 2013 Interesting. There should be no password required to open and use the files. I've just downloaded both and haven't received any password request. Can I just confirm that this is as you are double-clicking the file to open? I'm logged into Dropbox using Skyfire on my iPad. It can't directly download so I am saving them into Dropbox and then trying to open them in my Dropbox app. It is at this point that I am asked for a password. Will try on Android and see what happens. Quote Link to comment Share on other sites More sharing options...
Losthammer Posted March 5, 2013 Report Share Posted March 5, 2013 I'm logged into Dropbox using Skyfire on my iPad. It can't directly download so I am saving them into Dropbox and then trying to open them in my Dropbox app. It is at this point that I am asked for a password. Will try on Android and see what happens. Done some testing on my Android tablet. The EL interactive spreadsheet works perfectly as far as I can make out using Kingsoft Office. Opens but doesn't work in QuickOffice. A third office app tries to open it but requests a password like my iPad does. Will try the GP file tomorrow, but really chuffed that the EL one works on a tablet. Will post my findings on here for you :-) Quote Link to comment Share on other sites More sharing options...
Losthammer Posted March 5, 2013 Report Share Posted March 5, 2013 Have now found an excellent app that works on iPad and Android (including smartphones) which reproduces Microsoft Office brilliantly. Called CloudOn it links to Dropbox and all the speedway files I've tried work perfectly. Useful information for others perhaps? The GP app in particular is superb, will be using it this season for sure! Quote Link to comment Share on other sites More sharing options...
daveallan81 Posted March 5, 2013 Author Report Share Posted March 5, 2013 (edited) Have now found an excellent app that works on iPad and Android (including smartphones) which reproduces Microsoft Office brilliantly. Called CloudOn it links to Dropbox and all the speedway files I've tried work perfectly. Useful information for others perhaps? The GP app in particular is superb, will be using it this season for sure! Losthammer, thanks for all that information. I'll post a note on my Dropbox page shortly to bring it to folks attention. Thanks for your comments and very much appreciate your input Edit: You may want to re-download a fresh EL file - it was pointed out to me that the Coin Toss cell was locked out so have upped fresh file Edited March 6, 2013 by daveallan81 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.