# Excel score calculating sheet

**URL:** <https://forum.theavr.org/t/excel-score-calculating-sheet/135>\
**Category:** Competition/Game\
**Created:** [September 14, 2022, 9:13pm UTC](https://forum.theavr.org/t/excel-score-calculating-sheet/135 "2022-09-14T21:13:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mkraft](https://avatars.discourse-cdn.com/v4/letter/m/8797f3/32.png) [@mkraft](https://forum.theavr.org/u/mkraft)\
**Post date:** [September 14, 2022, 9:13pm UTC](https://forum.theavr.org/t/excel-score-calculating-sheet/135/1 "2022-09-14T21:13:23Z")

</div>

All,

Please see below for an Excel score sheet. I worked on it with Shelby Vanover. It’s helpful for scoring mock games, and also shows what each robot should be doing in each phase.

> **[Bell\_VRC\_scoresheet V3.xlsx](https://docs.google.com/spreadsheets/d/1XJ8q63LV4-yOCvHbavjas0-eDZxB3DNx/edit?usp=sharing&ouid=102591248137487519423&rtpof=true&sd=true)**
>
> Scoring
> 
> ARV,RVR,SPHEROS,TELLO
> Action,Points / Action,# of Actions Completed,Score,Action,Points / Action,# of Actions Completed,Score,Action,Points / Action,# of Actions Completed,Score,Action,Points / Action,# of Actions Completed,Score
> Phase 1,#...

The second tab called “Perfect 1-2” is filled in with a perfect score in the first two phases. Phase 3 isn’t populated, since the max score of that phase depends on how quickly you finish phase 1+2.

Please let me know if you have any questions or corrections.

---

<div class="post-metadata">

**Author:** ![DMathews\_Clariden](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.theavr.org/dmathews_clariden/32/33_2.png) [@DMathews\_Clariden](https://forum.theavr.org/u/DMathews_Clariden)\
**Post date:** [September 17, 2022, 6:17pm UTC](https://forum.theavr.org/t/excel-score-calculating-sheet/135/2 "2022-09-17T18:17:59Z")

</div>

Thank you very much for this, Michael!

I know there is some discussion around this in other threads, but it seems to me that 4 fire spread paths can be blocked for 5 points each according to 5.1.5. Would this increase the perfect score total? If so, for the RVR scoring section ‘Fire Spread paths blocked’ would seem better than ‘Debris Bags put in hole’

There is also a 5 point Support Action for parking the AVR.

---

<div class="post-metadata">

**Author:** ![svanover](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.theavr.org/svanover/32/82_2.png) [@svanover](https://forum.theavr.org/u/svanover)\
**Post date:** [September 19, 2022, 3:55pm UTC](https://forum.theavr.org/t/excel-score-calculating-sheet/135/3 "2022-09-19T15:55:51Z")

</div>

Hi David,

1. It was our understanding that only blocking the active fire spread path counted towards your score (the active fire spread path is either revealed by the Tello completing the recon path or by the field management system (fms) at the 2 minute mark). The manual wasn’t clear on how many trenches become active. We assumed it was 1.
2. We will change the language to reflect the trench being filled, as opposed to # of holes.