Nayr Posted July 8, 2015 Posted July 8, 2015 I was also not able to, I reckon I need some or other google sheets for dummies book[emoji6]Just download the xls file and open in Excel....works well
Heppy Posted July 8, 2015 Posted July 8, 2015 Or go to the sheets screen, right click and select open in new tab. Worked for me....
Frosty Posted July 8, 2015 Author Posted July 8, 2015 It seems that Google Spreadsheets does not allow the same permission function as MS Excel. The only reason I want to keep the READ ONLY access it to prevent accidental changes to the spreadsheet. So now it has full access to the file, but as I will be uploading this every day, if there are mistakes on the file it will be corrected every day. I hope the new ALL ACCESS means you can view your team without having to download the file.
Frosty Posted July 8, 2015 Author Posted July 8, 2015 The link will be provided on the leaderboard to open directly in Google.
Frosty Posted July 8, 2015 Author Posted July 8, 2015 I'm also not trying to safe guard any confidential information, only my limited knowledge of Excel - I have learnt many of my Excel skills online, so if you can learn something or propose an easier way...
Frosty Posted July 8, 2015 Author Posted July 8, 2015 Much appreciated. (I'm not able to type in the yellow block) You should be able to edit now.
DJ84 Posted July 8, 2015 Posted July 8, 2015 Hi Gerald, I'm not sure how much work it would be to slot the substitute riders in as an outer column,Just as a comparison so that we can see how stupid we were to not have them in our main team. Even if you could slot a single rider profile that we can select any person to use as a comparative. What would also be cool is if you could have top point scorers running down in another tab, first to last based on tally.
Frosty Posted July 8, 2015 Author Posted July 8, 2015 Hi Gerald, I'm not sure how much work it would be to slot the substitute riders in as an outer column,Just as a comparison so that we can see how stupid we were to not have them in our main team. Even if you could slot a single rider profile that we can select any person to use as a comparative. What would also be cool is if you could have top point scorers running down in another tab, first to last based on tally.Let me see what I can do... I now feel like a software developer feels when I ask questions on what I'd like to see (not complaining).
Frosty Posted July 8, 2015 Author Posted July 8, 2015 When you open the leaderboard, you will see the link to the points breakdown. Thanks Admin
DJ84 Posted July 8, 2015 Posted July 8, 2015 Let me see what I can do... I now feel like a software developer feels when I ask questions on what I'd like to see (not complaining).Haha, i know how you feel,I am the Excel person in my company (although im not that great on it)Its not essential, would just be cool to see how the points have favoured certain riders not in my own team.
Gen Posted July 8, 2015 Posted July 8, 2015 When you open the leaderboard, you will see the link to the points breakdown. Thanks Admin leaderboard.PNGNice one works 100% on mobile, I could even get my own team[emoji122] [emoji122] [emoji122]
Frosty Posted July 8, 2015 Author Posted July 8, 2015 Haha, i know how you feel,I am the Excel person in my company (although im not that great on it)Its not essential, would just be cool to see how the points have favoured certain riders not in my own team.In previous years, I could post the scoreboard in a PDF that was only a few pages. The current scoreboard with all the participants would be hundreds of pages. To do it is not difficult, and it's not that time consuming - it's just trying to find the time to do it. Work, home, bike, family, etc. - oh, and watching the actual Tour too.
jcza Posted July 8, 2015 Posted July 8, 2015 In previous years, I could post the scoreboard in a PDF that was only a few pages. The current scoreboard with all the participants would be hundreds of pages. To do it is not difficult, and it's not that time consuming - it's just trying to find the time to do it. Work, home, bike, family, etc. - oh, and watching the actual Tour too. Bike should be 1st and work last on your list.....just saying
Frosty Posted July 8, 2015 Author Posted July 8, 2015 Bike should be 1st and work last on your list.....just saying [emoji14]h34r:Bike doesn't pay the bills, it consumes what work provides Edit: the only time bike comes before work is on weekends and early week day mornings.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.