GPRM: Strategy for calculating top groups?
Posted: Tue Apr 11, 2017 9:34 am
So we recently had our District Pinewood Derby. One of the awards that we have is a "District Cup" in which the top performing Pack gets their name engraved onto a large cup.
The way that we calculate scores for the District Cup is as follows:
Each Pack can send one car in each of the following categories: Tiger, Wolf, Bear, Web I, Web II, Appearance, Siblings, Adults, Den Chiefs.
For the purposes of calculating the District Cup scores, we ignore Appearance, Siblings, Adults and Den Chiefs.
For each Pack, we take the cumulative time run for each rank in the regular rounds of racing. Then, we drop the highest time, so that only four of the five ranks are tallied. This is so that Packs that were not quite able to send a full roster can still have a shot at the cup.
Cumulative times from the remaining four ranks are tallied for each Pack, and the Pack with the lowest overall takes the cup.
Now, my question is: How can we best get data from GPRM to help us easily calculate this? We were using GPRM 14, and we ended up doing a report to show cumulative times by rank. We exported this as an Excel document and then, after doing a lot of de-merging and column removal on the result, we had something we were able to to walk through reasonably easily...though we still had to do a lot of manual calculations.
Is there a better way to do this? Ideally, it would have been great to get a CSV export that I could just feed to a Python script that would munch through it and spit the result out. Does the latest version of GPRM offer any better export functionality?
The way that we calculate scores for the District Cup is as follows:
Each Pack can send one car in each of the following categories: Tiger, Wolf, Bear, Web I, Web II, Appearance, Siblings, Adults, Den Chiefs.
For the purposes of calculating the District Cup scores, we ignore Appearance, Siblings, Adults and Den Chiefs.
For each Pack, we take the cumulative time run for each rank in the regular rounds of racing. Then, we drop the highest time, so that only four of the five ranks are tallied. This is so that Packs that were not quite able to send a full roster can still have a shot at the cup.
Cumulative times from the remaining four ranks are tallied for each Pack, and the Pack with the lowest overall takes the cup.
Now, my question is: How can we best get data from GPRM to help us easily calculate this? We were using GPRM 14, and we ended up doing a report to show cumulative times by rank. We exported this as an Excel document and then, after doing a lot of de-merging and column removal on the result, we had something we were able to to walk through reasonably easily...though we still had to do a lot of manual calculations.
Is there a better way to do this? Ideally, it would have been great to get a CSV export that I could just feed to a Python script that would munch through it and spit the result out. Does the latest version of GPRM offer any better export functionality?