{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":43,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":19,"n_cols":34,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,25,0,30],[0,5,1,7],[2,5,2,7],[6,5,6,7],[12,5,13,11],[14,5,15,11],[16,5,17,11],[11,0,11,1],[13,0,14,2],[13,3,14,3],[15,0,15,1],[16,0,16,2],[16,3,17,3],[10,0,10,1],[0,0,1,2],[2,0,2,2],[2,3,3,3],[5,0,5,2],[9,0,9,1]]}
["Inputs",null,null,null,null,"Constraints",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculated",null,null,null,null,null,"Options for Inc or Dec of Dimensions","Options for Two Dimension Equality","Orignal Calculated Vt/Vr"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Original Volume","Final Volume","L %Change","W % Change","H %Change","Min L","Min W","Min H","Max L ","Max W","Max H","Increasing","None",{"$f":"($A19*$B19*$C19)/($A5*$B5*$C5)","v":0.80000026843269867}]
["Original Dimensions",null,null,"Reference volume (Vr)",null,"Maximum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$A5*$B5*$C5","v":500},{"$f":"$A19*$B19*$C19","v":400.00013421634935},{"$f":"((($A19-$A5)*100)/$A5)","v":-44.721354236985633},{"$f":"((($B19-$B5)*100)/$B5)","v":-44.721354236985633},{"$f":"((($C19-$C5)*100)/$C5)","v":161.80343639516636},{"$f":"IF($A8=\"Increasing\",$A5, $F9)","v":1},{"$f":"IF($B8=\"Increasing\",$B5, $G9)","v":1},{"$f":"IF($C8=\"Increasing\",$C5, $H9)","v":5},{"$f":" IF($A8=\"Decreasing\",$A5,$F5)","v":10},{"$f":" IF($B8=\"Decreasing\",$B5,$G5)","v":10},{"$f":"IF($C8=\"Decreasing\",$C5, $H5)","v":1000},"Decreasing","Length - Width"]
["Length","Width","Height",null,null,"Length","Width","Height",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Width - Height"]
[10,10,5,{"$f":"$A5*$B5*$C5","v":500},null,1000,1000,1000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Height - Length"]
["Direction of Change",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Length - Width - Height"]
["Length","Width","Height","Unit",null,"Minimum"]
["Decreasing","Decreasing","Increasing","cm",null,"Length","Width","Height"]
[null,null,null,null,null,1,1,1]
["Equal Change in Multiple Dimensions?",null,"Length - Width"]
["Desired Actual Volume Ratio (Vt/Vr)",null,0.8]
["Desired Perceived Volume Ratio (V't/Vr)",null,1]
[null,null,null,null,null,"Type Ctrl+Shift+A to run the Solver and find the optimal dimensions"]
["Outputs",null,null,"Perceived target volume (V't)"]
[null,null,null,null,null,"Type Ctrl+Shift+B to draw 3D objects in Sheet 2"]
["Final Perceived Volume Ratio (V't/Vr)",null,{"$f":"( 1 + ( ( IF($A8=\"Increasing\",1,0) * ( ( $A19 -$A5 ) /$A5 ) ) + (  IF($B8=\"Increasing\",1,0)  * ( ($B19 -$B5 ) /$B5 ) ) + (IF($C8=\"Increasing\",1,0) * ( ($C19 -$C5 ) /$C5 ) ) ) ) / ( 1 + ( ( IF($A8=\"Decreasing\",1,0) * ( ($A5 - $A19 ) / $A19 ) ) + ( IF($B8=\"Decreasing\",1,0)  * ( ($B5 -$B19 ) /$B19 ) ) + (IF($C8=\"Decreasing\",1,0) * ( ($C5 -$C19 ) /$C19 ) ) ) )","v":1.000000276139601},{"$f":"C16*D5","v":500.00013806980047}]
["Optimal Dimensions",null,null,"Actual target volume (Vt)",null,"You can only edit the cells in yellow"]
["Length","Width","Height"]
[5.5278645763014369,5.5278645763014369,13.090171819758318,{"$f":"$A19*$B19*$C19","v":400.00013421634935}]

{"sheet":"Sheet2","index":1,"n_rows":8,"n_cols":16,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,3,4],[2,8,3,11]]}
[]
[null,null,null,null,null,"unit",{"$f":"Sheet1!D8","v":"cm"},null,null,null,null,null,"unit",{"$f":"G2","v":"cm"}]
[null,"Reference Object",null,null,null,"Height",{"$f":"Sheet1!C5","v":5},null,"Target Object",null,null,null,"Height",{"$f":"Sheet1!C19","v":13.090171819758318}]
[null,null,null,null,null,"Width",{"$f":"Sheet1!B5","v":10},null,null,null,null,null,"Width",{"$f":"Sheet1!B19","v":5.5278645763014369}]
[null,null,null,null,null,"Length",{"$f":"Sheet1!A5","v":10},null,null,null,null,null,"Length",{"$f":"Sheet1!A19","v":5.5278645763014369}]
[null,null,null,null,null,"unit",{"$f":"CONCATENATE(G2,\"^3\")","v":"cm^3"},null,null,null,null,null,"unit",{"$f":"CONCATENATE(N2,\"^3\")","v":"cm^3"},"Ratio","% change"]
[null,null,null,null,null,"Actual volume",{"$f":"Sheet1!D5","v":500},null,null,null,null,null,"Actual volume",{"$f":"Sheet1!D19","v":400.00013421634935},{"$f":"Sheet1!C11","v":0.8},{"$f":"Sheet1!C11-1","v":-0.19999999999999996}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Perceived volume",{"$f":"Sheet1!D16","v":500.00013806980047},{"$f":"Sheet1!C12","v":1},{"$f":"Sheet1!C12-1","v":0}]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}