{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["information","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"information","index":0,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,0,7,1],[14,3,14,7],[0,5,1,6],[3,5,4,5],[3,6,4,6],[9,2,9,4]]}
[null,null,null,null,null,"ENTER VALUE HERE"]
[]
[null,null,"Length","Breadth","Height","Total ROW","TOTAL weight","CALCULATION"]
[null,{"$f":"(C4/100)*(D4/100)*(E4/100)","v":0.27875250000000001},90,65,47.65,287,80,{"$f":"B4*F4","v":80.001967500000006},null," =B4*F4"]
[null,null,{"$f":"LEFT(C4,5)","v":"90"},{"$f":"LEFT(D4,5)","v":"65"},{"$f":"LEFT(E4,5)","v":"47.65"},null,null,{"$f":"G4-H4","v":-1.9675000000063392E-3}]
[]
[null,null," =(C4/100)*(D4/100)*(E4/100)"]
[null,null,null,null,null,null,null," =G4-H4"]
[]
[null,null,"Enter Number of Cartons / Rows"]
[]
[]
[]
[]
[null,null,null,"FOURMULA WILL BE SHOWS IN THIS COLOUR"]
[]
[]
[null,null,"what I am looking for"]
[null,1,"After updating the total \"CBM\" and \"Total Row/cartons\" macro suppose to calculate \"length, Breadth, & height."]
[null,2,"There will +/-0.005 kgs."]
[null,3,"Not showing a excel sheet only userform"]
[]
[null,null,"ration for L B & H is 60, 40,  & 20"]
[null,null,"I was doing manually. it can be possible automated?"]

{"sheet":"Sheet1","index":1,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[[3,6,4,6],[3,7,4,7],[0,6,1,7],[9,3,9,5]]}
[null,null,null,null,null,null,"ENTER VALUE HERE"]
[]
[null,null,null,"Length","Breadth","Height","Total ROW","TOTAL weight","CALCULATION"]
[null,null,{"$f":"(D4/100)*(E4/100)*(F4/100)","v":0.227712},80,60,47.44,800,80,{"$f":"C4*G4","v":182.1696}]
[null,"TEXT FORMAT",null,{"$f":"LEFT(D4,5)","v":"80"},{"$f":"LEFT(E4,5)","v":"60"},{"$f":"LEFT(F4,5)","v":"47.44"},null,null,{"$f":"+H4-I4","v":-102.1696},"DIFFERENCE"]
[]
[]
[]
[]
[null,null,null,"Enter Number of Cartons / Rows",null,null,null,null,"Total CBM as per Bill of Lading"]