{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Group 1","Group 2","Group 3","Comparison"],"not_rendered":{"charts":11},"read":"whole","date_system":"1900"}

{"sheet":"Group 1","index":0,"n_rows":6,"n_cols":24,"rows_kept":6,"merged":[[0,0,0,23]]}
["Phase Change Lab Experiment"]
["Phases","1 min","2 min","3 min","4 min","5 min","6 min","7 min","8 min","9 min","10 min","11 min","12 min","13 min","14 min","15 min","16 min","17 min","18 min","19 min","20 min","Average Per Phase","Total Temp","Max Temp Per Phase"]
["Solid",{"$nulls":20},{"$f":"AVERAGE(B3:U3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B3:U3)","v":0},{"$f":"MAX(B3:U3)","v":0}]
["Liquid",{"$nulls":20},{"$f":"AVERAGE(B4:U4)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B4:U4)","v":0},{"$f":"MAX(B4:U4)","v":0}]
["Gas",{"$nulls":20},{"$error":"#DIV/0!"},0,0]
["Average Temp Per Minute",{"$f":"AVERAGE(B3:B5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C3:C5)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AVERAGE(Q3:Q5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(R3:R5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(S3:S5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(T3:T5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(U3:U5)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Group 2","index":1,"n_rows":6,"n_cols":24,"rows_kept":6,"merged":[[0,0,0,22]]}
["Phase Change Lab Experiment"]
["Phases","1 min","2 min","3 min","4 min","5 min","6 min","7 min","8 min","9 min","10 min","11 min","12 min","13 min","14 min","15 min","16 min","17 min","18 min","19 min","20 min","Average Per Phase","Total Temp","Max Temp Per Phase"]
["Solid",{"$nulls":20},{"$f":"AVERAGE(B3:U3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B3:U3)","v":0},{"$f":"MAX(B3:U3)","v":0}]
["Liquid",{"$nulls":20},{"$f":"AVERAGE(B4:U4)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B4:U4)","v":0},{"$f":"MAX(B4:U4)","v":0}]
["Gas",{"$nulls":20},{"$error":"#DIV/0!"},0,0]
["Average Temp Per Minute",{"$f":"AVERAGE(B3:B5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C3:C5)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AVERAGE(Q3:Q5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(R3:R5)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"AVERAGE(T3:T5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(U3:U5)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Group 3","index":2,"n_rows":6,"n_cols":24,"rows_kept":6,"merged":[[0,0,0,22]]}
["Phase Change Lab"]
["Phases","1 min","2 min","3 min","4 min","5 min","6 min","7 min","8 min","9 min","10 min","11 min","12 min","13 min","14 min","15 min","16 min","17 min","18 min","19 min","20 min","Average Per Phase","Total Temp","Max Temp Per Phase"]
["Solid",{"$nulls":20},{"$f":"AVERAGE(B3:U3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B3:U3)","v":0},{"$f":"MAX(B3:U3)","v":0}]
["Liquid",{"$nulls":20},{"$f":"AVERAGE(B4:U4)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B4:U4)","v":0},{"$f":"MAX(B4:U4)","v":0}]
["Gas",{"$nulls":20},{"$error":"#DIV/0!"},0,{"$f":"MAX(B5:U5)","v":0}]
["Average Temp Per Minute",{"$f":"AVERAGE(B3:B5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C3:C5)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"AVERAGE(Q3:Q5)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(R3:R5)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Comparison","index":3,"n_rows":5,"n_cols":8,"rows_kept":5,"merged":[[0,0,0,7]]}
["Goup Comparison"]
["Phase","Group 1","Group 2","Group 3","Average Of All Groups","Total Temp","Max Temp Per Phase","Median Temp for all Groups"]
["Average Solid Temp",{"$nulls":3},{"$f":"AVERAGE(B3:D3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B3:D3)","v":0},{"$f":"MAX(B3:D3)","v":0},{"$f":"MEDIAN(B3:D3)","v":{"$error":"#NUM!"}}]
["Average Liquid Temp",{"$nulls":3},{"$f":"AVERAGE(B4:D4)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B4:D4)","v":0},{"$f":"MAX(B4:D4)","v":0},{"$f":"MEDIAN(B4:D4)","v":{"$error":"#NUM!"}}]
["Average Gas Temp",{"$nulls":3},{"$error":"#DIV/0!"},0,0,{"$error":"#NUM!"}]