Quote:
Originally Posted by karomata
To calculate these values, I need to have specific data on each match, then I average the calculated values from each match that a team competed in, to attain the final value. Other than manually tracking which matches a team played in and doing the math in calculation cells, is there a way using excel that I can have it automatically identify which matches in which cells would the team have competed in, without me having to set it to do it for that specific instance? Ex. Instead of me recording all the match data from 1511s matches into the final calculation table, the program automatically identifies which matches 1511 played in, and puts it into the table for me.
Also, instead of having to type in OPRs for each team in each match, is there a way that I can have it automatically replace the team number with the OPR, getting the data from a separate table. Ex: If I type 1511 into a cell, it automatically removes the 1511 and replaces it with the OPR from a defined table.
|
I use similar techniques with our Excel scouting system. VLOOKUP will not add or average your raw match data. Pivot tables could do what you want, but you will need to organize your data in a table format – one row per robot per match. I use the SUMIF and COUNTIF to calculate the values I want instead of pivots, it just personal preference for the statistics I’m gathering from multiple worksheets.
Send me a PM if you want a copy of my scouting sheets.