Rules for the Contest

[MaRiNe [Q2C]]

Feb 18, 2015 2:43:29 GMT -5 Null said:

OK so I got V1 of the score sheet ready:

I have zero Excel knowledge so I can't do it myself, but can you make it so that the "Total" score is calculated automatically out of the values we put in the different categories?

[Null]

Mar 12, 2015 6:47:43 GMT -5 MaRiNe [Q2C] said:

Feb 18, 2015 2:43:29 GMT -5 Null said:

OK so I got V1 of the score sheet ready:

I have zero Excel knowledge so I can't do it myself, but can you make it so that the "Total" score is calculated automatically out of the values we put in the different categories?

Yes it's pretty simple. If you're using Excel, once you got the values filled in the other cells of that row, you click on the empty "Total" cell and Press the Auto Sum button, and hit enter, which should automatically calculate the total for you, just like in this video:

www.youtube.com/watch?v=v3Ec5GupNjA
www.youtube.com/results?search_query=excel+autosum+row

If you're using Ron's csv Editor, you can use the following app to automatically create the totals for you:
netdoo.com/wodx/files/total_score.zip



Remember to always save in Ron's Editor after editing the scores, so just before calculating the totals in the app.
Also remember to refresh in Ron's Editor after pressing the "Calculate Totals" in the above app, to see updated totals.

[Null]

Here's an updated score sheet with map names already filled in: scoresheetV2c.csv (1.35 KB)