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
Post a Comment