excel - Solution to log benchmarking results and update them easily, including adding new attributes for comparison -


i'm benchmarking set of programs running on gpu , cpu, logging time spent on different parts of program , other data google sheet. there 30 tests, each of has rows dedicated sub test cases of running test on cpu , gpu , columns log time taken etc. looks like,

--------------------------------- test1|time(s)|gpu compute(%)|speedup cpu  |   1   |      0       |=a2/a2 gpu  |  .3   |      75      |=a3/a2 test2|time(s)|gpu compute(%)|speedup cpu  |   2   |      0       |=a5/a5 gpu  |  .6   |      75      |=a6/a5 test3|... ... 

i'm finding difficult add new rows or columns across tests.

the best solution have been have 3 dimensional sheet, 2 dimensions dedicated rows , columns describing 1 of benchmarks , 3rd dimension store each benchmark.

i'm looking forward suggestions can ease adding more sub test cases (e.g. hybrid cpu gpu or fpga) , attributes describe test runs, facility assign formulas attributes. it'd helpful if upload data , view on platforms google drive, onedrive etc.


Comments

Popular posts from this blog

python - Operations inside variables -

Generic Map Parameter java -

arrays - What causes a java.lang.ArrayIndexOutOfBoundsException and how do I prevent it? -