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

ubuntu - PHP script to find files of certain extensions in a directory, returns populated array when run in browser, but empty array when run from terminal -

php - How can i create a user dashboard -

javascript - How to detect toggling of the fullscreen-toolbar in jQuery Mobile? -