{"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":1,"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":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[15,4,15,7],[1,1,1,7],[2,1,2,7],[3,2,3,4],[5,2,5,4],[7,2,7,5],[53,4,53,8],[55,4,55,8],[58,1,58,7],[19,4,19,6],[19,7,19,8],[21,4,22,7],[21,8,22,8],[49,4,49,8],[50,4,50,8]]}
[]
[null,"Motorhome Payload Weight Distribution Estimator"]
[null,"This estimator is for guidance purposes only. Each vehicle should be checked on a weighbridge to verify the actual loading. It is the responsibility of the motorhome owner to ensure that their vehicle complies with the law and is not overloaded."]
[null,"Customer:","Your name",null,null,null,"Sales Order No:","???"]
[]
[null,"Chassis Manufacturer:  ","Fiat / Iveco / Mercedes"]
[]
[null,"Motorhome Make & Model:","e.g. Chic model "]
[]
[null,"From Chassis Manufacturers Plate"]
[null,"Maximum Permitted Mass",4500,"kg"]
[null,"Maximum Permitted Front Axle",2100,"kg"]
[null,"Maximum Permitted Rear Axle 1",2250,"kg"]
[null,"Maximum Permitted Rear Axle 2",null,"kg"]
[]
[null,"Wheelbase",4000,"mm"]
[]
[null,"Mass in Running Order",3850,"kg"]
[]
[null,"From Weighbridge  - before additions"]
[null,"Actual Mass FRONT axle",1850,"kg"]
[null,"Actual Mass REAR axle 1",2000,"kg",{"$f":"IF(SUM(C21:C23)=C18,\" \",\"CAUTION!  Total axles do NOT agree with Mass in Running Order\")","v":" "}]
[null,"Actual Mass REAR axle 2",null,"kg"]
[]
[null,"Description of Additional Payload","Mass          kg","Position      metres       ","add FRONT axle kg","add   REAR axle/s kg"," "]
[null,"Carried forward from previous sheet",0," see note -->",0,0]
[null,"85 litres diesel",85,1.5,{"$f":"C27-F27","v":53.125},{"$f":"C27*(D27*1000)/$C$16","v":31.875}]
[null,null,null,null,{"$f":"C28-F28","v":0},{"$f":"C28*(D28*1000)/$C$16","v":0}]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,null,null,null,0,0]
[null,"Totals",{"$f":"SUM(C26:C47)","v":85},null,{"$f":"SUM(E26:E47)","v":53.125},{"$f":"SUM(F26:F47)","v":31.875}]
[null,"Estimated Mass with above additions"]
[null,"Revised Mass Front Axle",{"$f":"C21+E48","v":1903.125},"kg",{"$f":"IF(C50>C12,\"WARNING! - FRONT axle overloaded\",\" \")","v":" "}]
[null,"Revised Mass Rear Axle 1",{"$f":"IF(C14>0,C22+(F48/2),C22+F48)","v":2031.875},"kg",{"$f":"IF((C51+C52)>(C13+C14),\"WARNING! - REAR axle/s Overloaded\",\" \")","v":" "}]
[null,"Revised Mass Rear Axle 2",{"$f":"IF(C14>0,C23+(F48/2),0)","v":0},"kg"]
[]
[null,"Revised Mass in Running Order",{"$f":"SUM(C50:C52)","v":3935},"kg",{"$f":"IF(C54>C11,\"WARNING! - Mass exceeds permitted Maximum\",\" \")","v":" "}]
[]
[null,"Remaining Available Payload",{"$f":"C11-C54","v":565},"kg",{"$f":"IF(C56<50,\" ALERT Payload Margin\",\" \")","v":" "}]

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

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