Syncing Between Computers

[Ed Law]

Originally Posted by Johnny_5

We plan to use 8 computers on the regional wifi to scout. Thanks to Team 2834 for the scouting spreadsheet.

We want to know how some teams go about using the excel spreadsheet and syncing all of the computers together into the same file.

We have 6 students at a time on rotations to scout every team of every match on paper. Then one students enter them into a spreadsheet. They would either email me if there is internet access at the venue or write it out to a flash drive every few matches. I process the data in my spreadsheet on my laptop near the pit and copy the results to the computer in the pit for the drive team to use. It works out quite well.

If you have the luxury to have 8 computers and internet access, you can try use Google doc so everybody can type into the document at the same time. Then write it out to an excel file every few matches and then import the data into the scouting spreadsheet.

If you are using my spreadsheet, I would assume you have customized it for your team's use. To update match and standing data and to calculate overall OPR and individual OPR of hybrid, bridge, tele and coop, you just have to press Cntr-Shift-P. I hope the spreadsheet helps. My team is competing in an event this weekend also so I won't be able to help. Good luck to you at your event.