{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","W&B FORM","OO-DKM"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Introduction","index":0,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[4,4,4,5],[6,2,6,3]]}
[]
[]
[]
[]
["remarks? tony.opsomer@gmail.com",null,null,null,"version 2016-10-07"]
[]
[null,null,"PA-28-181 OO-DKM"]
[]
[null,null,"Weight and balance form"]

{"sheet":"W&B FORM","index":1,"n_rows":45,"n_cols":24,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,4,3,6],[5,12,5,15],[7,14,12,15],[12,5,12,6],[9,5,9,6],[8,5,8,6],[7,5,7,6],[10,5,10,6],[32,26,32,28],[32,29,32,30],[32,31,33,31],[44,1,44,15],[4,12,4,15],[24,19,24,21],[13,12,13,15],[6,19,6,20],[15,12,15,15],[14,12,14,15],[11,5,11,6]]}
[null,{"$f":"Introduction!A5","v":"remarks? tony.opsomer@gmail.com"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Introduction!E5","v":"version 2016-10-07"}]
[null,"Weight and Balance form PA-28-181 OO-DKM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculations"]
[]
[]
[null,null,null,null,null,null,null,"Fuel quantity","Weight ","Arm","Moment",null,"Form validity checker"]
[null,null,null," ",null,null,null,"[l]","[kg]","[in]","[in.lbs]",null,"Don't forget: always do a manual check on your data!!"]
[null,"Basic empty weight (includes engine oil and unusable fuel)",null,null,null,null,null,null,{"$f":"'OO-DKM'!C10","v":715.31142999999997},88.25,{"$f":"'OO-DKM'!E12","v":139176.32000000001}]
[null,"Usable fuel ",null,"mean arm:",95,"in",null,null,{"$f":"H8*0.72","v":0},{"$f":"E8","v":95},{"$f":"I8*2.20462262185*J8","v":0},null,{"$f":"IF(H8=\"\",\"COMPLETE THE FORM\",IF(H8>'OO-DKM'!E4,\"FUEL TANK OVERFLOW\",\"FUEL QUANTITY WITHIN LIMIT\"))","v":"COMPLETE THE FORM"},null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\"),\"COMPLETE THE FORM\",IF(SUM(I7:I13)>'OO-DKM'!C15,\"TOO MUCH USEFUL LOAD\",IF(SUM(I7:I13)>'OO-DKM'!C16,\"TOTAL USEFUL LOAD WITHIN NORMAL CATEGORY LIMIT\",\"TOTAL USEFUL LOAD WITHIN UTILITY CATEGORY\")))","v":"COMPLETE THE FORM"}]
[null,"Pilot",null,"mean arm:",80.5,"in",null,null,null,{"$f":"E9","v":80.5},{"$f":"I9*2.20462262185*J9","v":0}]
[null,"Front passenger",null,"mean arm:",80.5,"in",null,null,null,{"$f":"E10","v":80.5},0]
[null,"Rear passenger 1",null,"mean arm:",118.1,"in",null,null,null,118.1,0]
[null,"Rear passenger 2",null,"mean arm:",118.1,"in",null,null,null,118.1,0]
[null,"Baggage area 1",null,"mean arm:",142.80000000000001,"in",null,null,null,142.80000000000001,0,null,{"$f":"IF(OR(I13=\"\"),\"COMPLETE THE FORM\",IF(I13>'OO-DKM'!C19,\"TOO MUCH BAGGAGE\",\"BAGGAGE WEIGHT WITHIN LIMITS\"))","v":"COMPLETE THE FORM"}]
[null,"TAKEOFF WEIGHT AND MOMENT",null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\"),\"COMPLETE THE FORM\",SUM(I7:I13))","v":"COMPLETE THE FORM"},{"$f":"IF(I14=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",K14/U14)","v":"COMPLETE THE FORM"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\"),\"COMPLETE THE FORM\",SUM(K7:K13))","v":"COMPLETE THE FORM"},null,{"$f":"IF(I14=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",\"CHECK RESULTS IN GRAPH BELOW\")","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"takeoff weight [lbs]",{"$f":"I14*2.20462262185","v":{"$error":"#VALUE!"}}]
[null,"Total trip time",null,null,null,"hh:mm",null,{"$f":"(HOUR(E15)*60+MINUTE(E15))/60*'OO-DKM'!E6","v":0},{"$f":"H15*0.72","v":0},{"$f":"E8","v":95},{"$f":"I15*2.20462262185*J15","v":0},null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",E15=\"\"),\"COMPLETE THE FORM\",IF((H15)>H8,\"NOT ENOUGH FUEL TO COMPLETE THE TRIP\",IF((H15)>(H8-'OO-DKM'!E6/60*45),\"DANGER! DANGER! FUEL RESERVE LESS THAN 45 MIN\",\"TRIP TIME WITHIN LIMIT\")))","v":"COMPLETE THE FORM"}]
[null,"LANDING WEIGHT AND MOMENT",null,null,null,null,null,null,{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",E15=\"\"),\"COMPLETE THE FORM\",IF(M15=\"TRIP TIME TOO BIG\",\"CHECK TRIP TIME\",I14-I15))","v":"COMPLETE THE FORM"},{"$f":"IF(I16=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(I16=\"CHECK TRIP TIME\",\"CHECK TRIP TIME\",K16/U16))","v":"COMPLETE THE FORM"},{"$f":"IF(OR(H8=\"\",I9=\"\",I10=\"\",I11=\"\",,I12=\"\",I13=\"\",E15=\"\"),\"COMPLETE THE FORM\",IF(M15=\"TRIP TIME TOO BIG\",\"CHECK TRIP TIME\",K14-K15))","v":"COMPLETE THE FORM"},null,{"$f":"IF(I16=\"COMPLETE THE FORM\",\"COMPLETE THE FORM\",IF(I16=\"CHECK TRIP TIME\",\"\",\"CHECK RESULTS IN GRAPH BELOW\"))","v":"COMPLETE THE FORM"},null,null,null,null,null,null,"landing weight [lbs]",{"$f":"I16*2.20462262185","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"conversion minutes  to hh:mm notation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hh","mm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"total minutes",null,null,{"$f":"TRUNC(U27/60,0)","v":0},{"$f":"ROUND((U27/60-TRUNC(U27/60))*60,0)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hh:mm",{"$f":"TIME(W27,X27,)","v":"00:00:00"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This document is provided for secondary flightplanning and navigation only. It is the user/pilot's sole responsibility to verify the correctness of all  information provided by this sheet. "]

{"sheet":"OO-DKM","index":2,"n_rows":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,1,2,5],[21,1,21,2],[29,3,29,4]]}
[]
[null,"DATA OO-DKM"]
[null,"LONG-RANGE FUEL TANKS"]
[null,"Max usable fuel quantity",48,"US Gal",{"$f":"C4*3.785412","v":181.69977599999999},"l"]
[null,"Unusable fuel",2,"US Gal",{"$f":"C5*3.785412","v":7.570824},"l"]
[null,"Max. Fuel flow",10.5,"US Gal/hr",{"$f":"C6*3.785412","v":39.746825999999999},"l/u"]
[null,"Max. endurance:",{"$f":"E4/E6","v":4.5714285714285712},"uur",{"$f":"INT(C7)&\":\"&ROUND((C7-INT(C7))*60,0)","v":"4:34"}]
[]
[null,"W&B DATA",null,null,null,null,null,"BASED ON"]
[null,"Empty Weight",{"$f":"E10*0.45359","v":715.31142999999997},"kg",1577,"lbs"]
[null,"Arm",null,null,88.25,"in"]
[null,"Moment ",null,null,139176.32000000001,"in.lbs"]
[]
[null,"Max weight"]
[null,"normal category",{"$f":"E15*0.45359","v":1156.6544999999999},"kg",2550,"lbs"]
[null,"utility category",{"$f":"E16*0.45359","v":966.14670000000001},"kg",2130,"lbs"]
[]
[null,"Max weight baggage areas"]
[null,"Baggage compartment",{"$f":"E19*0.45359","v":90.718000000000004},"kg",200,"lbs"]
[]
[null,"W&B Center of Gravity limits graph"]
[null,"NORMAL CATEGORY",null,"UTILITY CATEGORY"]
[null,"arm [in]","weight [lbs]","arm [in]","weight [lbs]"]
[null,82,0,82,0]
[null,82,2050,82,2050]
[null,88.6,2550,83,2130]
[null,93,2550,93,2130]
[null,93,0,93,0]
[]
[null,null,null,"in  utility category the rear seats must not be occupied and the baggage compartment must be empty"]