{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Read Me","OOCFC","FGVUN","OORAQ","Sheet1"],"not_rendered":{"charts":3,"images":2,"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":"Read Me","index":0,"n_rows":69,"n_cols":4,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[]
[null,"AUTOMATIC VERIFICATION OF CG LOCATION"]
[]
[null,"This application contains a function which will check of the resulting CG is  located within the CG envelope."]
[null,"In order to have this function working properly, you are to click 'ENABLE' upon the EXCEL notification "]
[null,"concerning the presence of a macro coded function."]
[]
[null,"If you do not get this notification after loading the application, then you need to change a setting in"]
[null,"EXCEL options as follows:"]
[]
[null,"1: Go to FILE > OPTIONS > Select TRUST CENTER > Trust Center Settings:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"2: Go to MACRO SETTINGS and select 'DISABLE VBA MACROS WITH NOTIFICATION', close screen with OK"]
[null,null,null,"b"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Thereafter reload the application and click 'ENABLE' when prompted regarding macros,"]

{"sheet":"OOCFC","index":1,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,3,24,5],[25,3,25,5],[26,3,26,5],[1,6,1,7],[6,1,7,1],[6,3,7,3],[6,4,6,5]]}
[]
["This application is no replacement for weight & balance calculation foreseen\n in the Aircraft Flight Manual, it is only intended to be a friendly assistance tool.  \nThe Aircraft Flight Manual & weighing report remain the only reference documents.","PIPER TOMAHAWK PA-38",null,null,null,null,"OO-CFC"]
[null,"Max TakeOff weight",null,null,757,"Kg"]
[null,"Max Landing weight",null,null,757,"Kg"]
[null,"Fuel tanks max usable capacity",null,null,30,"USG"]
[]
[null,"Item",null,"Max weight","Weight",null,"Arm","Moment"]
[null,null,null,null,"Kgs","Lbs","(Inch)","(In/Lbs)"]
[null,"Empty weight",null,null,{"$f":"Sheet1!D12","v":544},{"$f":"Sheet1!E12","v":1199.3132799999998},{"$f":"Sheet1!F12","v":74.599999999999994},{"$f":"Sheet1!G12","v":89388.6}]
[]
[null,"Pilot",null,null,75,{"$f":"Sheet1!E13","v":165.34649999999999},{"$f":"Sheet1!F13","v":85.5},{"$f":"Sheet1!G13","v":14137.125749999999}]
[null,"Front seat pax",null,null,75,{"$f":"Sheet1!E14","v":165.34649999999999},{"$f":"Sheet1!F14","v":85.5},{"$f":"Sheet1!G14","v":14137.125749999999}]
[]
[]
[]
[null,"Bagage area",null,45,5,{"$f":"Sheet1!E17","v":11.023099999999999},{"$f":"Sheet1!F17","v":115},{"$f":"Sheet1!G17","v":1267.6565000000001}]
[null,"Fuel tanks (%)",0.75,82,{"$f":"Sheet1!D18","v":60.982955100000005},{"$f":"Sheet1!E18","v":134.444242472562},{"$f":"Sheet1!F18","v":75.400000000000006},{"$f":"Sheet1!G18","v":10137.095882431175}]
[null,"Equals:",{"$f":"CONCATENATE(ROUND(Sheet1!C36,0),\" Lit\")","v":"85 Lit"},{"$f":"CONCATENATE(ROUND(Sheet1!C35,0),\" Lit\")","v":"81 Lit"},"= Max usable fuel amount"]
[null,"TakeOff weight",null,{"$f":"E3","v":757},{"$f":"Sheet1!D19","v":759.98295510000003},{"$f":"Sheet1!E19","v":1675.4736224725621},{"$f":"Sheet1!F19","v":77.033503930644443},{"$f":"Sheet1!G19","v":129067.6038824312}]
[null,"Fuel burn",20,"Lit",{"$f":"Sheet1!D20","v":-14.32},{"$f":"Sheet1!E20","v":-31.570158399999997},{"$f":"Sheet1!F20","v":75.400000000000006},{"$f":"Sheet1!G20","v":-2380.38994336}]
[null,"Landing weight",null,{"$f":"E4","v":757},{"$f":"Sheet1!D21","v":745.66295509999998},{"$f":"Sheet1!E21","v":1643.903464072562},{"$f":"Sheet1!F21","v":77.064874372379336},{"$f":"Sheet1!G21","v":126687.2139390712}]
[]
[]
[null,"Validation:"]
[null,"Max takeoff weight",null,{"$f":"IF(NOT(Sheet1!F53),\"OK\",CONCATENATE(\"Exceeded by \",ROUND(Sheet1!G53,2),\" kg\"))","v":"Exceeded by 2,98 kg"},null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(L25),TRUE,FALSE)","v":false}]
[null,"Max landing weight",null,{"$f":"IF(NOT(Sheet1!F54),\"OK\",CONCATENATE(\"Exceeded by \",ROUND(Sheet1!G54,2),\" kg\"))","v":"OK"}]
[null,"CG location in envelope",null,{"$f":"IF(NOT(Sheet1!F55),\"OK\",\"OUTSIDE envelope\")","v":{"$error":"#NAME?"}}]
[]
[null,"Notes:",{"$f":"Sheet1!B57","v":"Envelope check inactive, verify location CG in graphic"}]
[]
["(X-axis= CG location in inches from datum / Y-axis= weight in lbs)",null,null,null,null,null,null,{"$f":"Sheet1!B7","v":"PVHA 12/2023"}]
["POH Sect 2-Limitations: CG envelope for NORMAL & UTILITY operation are identical"]

{"sheet":"FGVUN","index":2,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,6,1,7],[28,2,28,7],[6,1,7,1],[6,3,7,3],[6,4,6,5],[24,3,24,5],[25,3,25,5],[26,3,26,5]]}
[]
["This application is no replacement for weight & balance calculation foreseen\n in the Aircraft Flight Manual, it is only intended to be a friendly assistance tool.  \nThe Aircraft Flight Manual & weighing report remain the only reference documents.","GRUMMAN AG5B",null,null,null,null,"F-GVUN"]
[null,"Max TakeOff weight",null,null,1088,"Kg"]
[null,"Max Landing weight",null,null,1088,"Kg"]
[null,"Fuel tanks max usable capacity",null,null,51,"Usg"]
[]
[null,"Item",null,"Max weight","Weight",null,"Arm","Moment"]
[null,null,null,null,"Kgs","Lbs","(m)","(m/kg)"]
[null,"Empty weight",null,null,{"$f":"Sheet1!L12","v":707.32},{"$f":"Sheet1!M12","v":1559.3718183999999},{"$f":"Sheet1!N12","v":2.1080000000000001},{"$f":"Sheet1!O12","v":1490.7950000000001}]
[]
[null,"Pilot",null,null,75,{"$f":"Sheet1!M13","v":165.34649999999999},{"$f":"Sheet1!N13","v":2.3010000000000002},{"$f":"Sheet1!O13","v":172.57500000000002}]
[null,"Front seat pax",null,null,65,{"$f":"Sheet1!M14","v":143.30029999999999},{"$f":"Sheet1!N14","v":2.3010000000000002},{"$f":"Sheet1!O14","v":149.565}]
[null,"Rear seat pax 1",null,null,75,{"$f":"Sheet1!M15","v":165.34649999999999},{"$f":"Sheet1!N15","v":3.2},{"$f":"Sheet1!O15","v":240}]
[null,"Rear seat pax 2",null,null,70,{"$f":"Sheet1!M16","v":154.32339999999999},{"$f":"Sheet1!N16","v":3.2},{"$f":"Sheet1!O16","v":224}]
[]
[null,"Bagage area",null,{"$f":"Sheet1!K17","v":54},5,{"$f":"Sheet1!M17","v":11.023099999999999},{"$f":"Sheet1!N17","v":3.7589999999999999},{"$f":"Sheet1!O17","v":18.794999999999998}]
[null,"Fuel tanks (%)",0.6,null,{"$f":"Sheet1!L18","v":82.936818935999995},{"$f":"Sheet1!M18","v":182.84416976268429},{"$f":"Sheet1!N18","v":2.4079999999999999},{"$f":"Sheet1!O18","v":199.71185999788798}]
[null,"Equals",{"$f":"CONCATENATE(ROUND(Sheet1!K36,0),\" Lit\")","v":"116 Lit"},{"$f":"CONCATENATE(ROUND(Sheet1!J35,0),\" Lit\")","v":"193 Lit"},"= Max usable fuel amount"]
[null,"TakeOff weight",null,{"$f":"E3","v":1088},{"$f":"Sheet1!L19","v":1080.2568189359999},{"$f":"Sheet1!M19","v":2381.5557881626846},{"$f":"Sheet1!N19","v":2.3100449969441308},{"$f":"Sheet1!O19","v":2495.4418599978885}]
[null,"Fuel burn",30,"Lit",{"$f":"Sheet1!L20","v":-21.48},{"$f":"Sheet1!M20","v":-47.355237599999995},{"$f":"Sheet1!N20","v":2.4079999999999999},{"$f":"Sheet1!O20","v":-51.723840000000003}]
[null,"Landing weight",null,{"$f":"E4","v":1088},{"$f":"Sheet1!L21","v":1058.7768189359999},{"$f":"Sheet1!M21","v":2334.2005505626848},{"$f":"Sheet1!N21","v":2.308057728779576},{"$f":"Sheet1!O21","v":2443.7180199978884}]
[]
[]
[null,"Validation:"]
[null,"Max takeoff weight",null,{"$f":"IF(NOT(Sheet1!N53),\"OK\",CONCATENATE(\"Exceeded by \",ROUND(Sheet1!O53,2),\" kg\"))","v":"OK"}]
[null,"Max landing weight",null,{"$f":"IF(NOT(Sheet1!N54),\"OK\",CONCATENATE(\"Exceeded by \",ROUND(Sheet1!O54,2),\" kg\"))","v":"OK"}]
[null,"CG location in envelope",null,{"$f":"IF(NOT(Sheet1!N55),\"OK\",\"OUTSIDE envelope\")","v":{"$error":"#NAME?"}}]
[]
[null,"Notes:",{"$f":"Sheet1!J57","v":"Fuel up to the TAB's equals 72% or 139 lit usable (36,4 Usg)\nEnvelope check inactive, verify location CG in graphic"}]
[]
["(X-axis= CG location in m from datum / Y-axis= weight in kg)",null,null,null,null,null,null,{"$f":"Sheet1!B7","v":"PVHA 12/2023"}]

{"sheet":"OORAQ","index":3,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,6,1,7],[28,2,28,7],[6,3,7,3],[6,4,6,5],[6,1,7,1],[24,3,24,5],[25,3,25,5],[26,3,26,5],[13,1,14,2]]}
[]
["This application is no replacement for weight & balance calculation foreseen\n in the Aircraft Flight Manual, it is only intended to be a friendly assistance tool.  \nThe Aircraft Flight Manual & weighing report remain the only reference documents.","CESSNA 172",null,null,null,null,"OO-RAQ"]
[null,"Max TakeOff weight",null,null,1043,"Kg"]
[null,"Max Landing weight",null,null,1043,"Kg"]
[null,"Fuel tanks max usable capacity",null,null,38,"Usg"]
[]
[null,"Item",null,"Max weight","Weight",null,"Arm","Moment"]
[null,null,null,null,"Kgs","Lbs","(cm)","(cm/kg)"]
[null,"Empty weight",null,null,{"$f":"Sheet1!T12","v":669.04954139999995},{"$f":"Sheet1!U12","v":1475},{"$f":"Sheet1!V12","v":97.002600000000001},{"$f":"Sheet1!W12","v":64899.545044607636}]
[]
[null,"Pilot",null,null,77,{"$f":"Sheet1!U13","v":169.75573999999997},{"$f":"Sheet1!V14","v":93.695499999999996},{"$f":"Sheet1!W13","v":7214.5535}]
[null,"Front seat pax",null,null,77,{"$f":"Sheet1!U14","v":169.75573999999997},{"$f":"Sheet1!V14","v":93.695499999999996},{"$f":"Sheet1!W14","v":7214.5535}]
[null,"Rear seat pax 1",null,null,77,{"$f":"Sheet1!U15","v":169.75573999999997},{"$f":"Sheet1!V15","v":187.39099999999999},{"$f":"Sheet1!W15","v":14429.107}]
[null,"DO NOT LOAD MORE\nTHAN 1 PAX IN THE REAR"]
[]
[null,"Bagage area",null,54,5,{"$f":"Sheet1!U17","v":11.023099999999999},{"$f":"Sheet1!V17","v":239.43661969999999},{"$f":"Sheet1!W17","v":1197.1830984999999}]
[null,"Fuel tanks (%)",0.8,{"$f":"Sheet1!S35","v":102.99343528},{"$f":"Sheet1!T18","v":82.394748224000011},{"$f":"Sheet1!U18","v":181.64910982959489},{"$f":"Sheet1!V18","v":105.83329999999999},{"$f":"Sheet1!W18","v":8720.1081072150591}]
[null,"Equals",{"$f":"CONCATENATE(ROUND(Sheet1!S36,0),\" Lit\")","v":"115 Lit"},{"$f":"CONCATENATE(ROUND(Sheet1!R35,0),\" Lit\")","v":"144 Lit"},"= Max usable fuel amount"]
[null,"TakeOff weight",null,{"$f":"E3","v":1043},{"$f":"Sheet1!T19","v":987.44428962400002},{"$f":"Sheet1!U19","v":2176.9394298295952},{"$f":"Sheet1!V19","v":104.99331591638469},{"$f":"Sheet1!W19","v":103675.05025032269}]
[null,"Fuel burn",30,"Lit",{"$f":"Sheet1!T20","v":-21.48},{"$f":"Sheet1!U20","v":-47.355237599999995},{"$f":"Sheet1!V20","v":105.83329999999999},{"$f":"Sheet1!W20","v":-2273.2992839999997}]
[null,"Landing weight",null,{"$f":"E4","v":1043},{"$f":"Sheet1!T21","v":965.964289624},{"$f":"Sheet1!U21","v":2129.5841922295954},{"$f":"Sheet1!V21","v":104.97463731893563},{"$f":"Sheet1!W21","v":101401.7509663227}]
[]
[]
[null,"Validation:"]
[null,"Max takeoff weight",null,{"$f":"IF(NOT(Sheet1!V53),\"OK\",CONCATENATE(\"Exceeded by \",ROUND(Sheet1!W53,2),\" kg\"))","v":"OK"}]
[null,"Max landing weight",null,{"$f":"IF(NOT(Sheet1!V54),\"OK\",CONCATENATE(\"Exceeded by \",ROUND(Sheet1!W54,2),\" kg\"))","v":"OK"}]
[null,"CG location in envelope",null,{"$f":"IF(NOT(Sheet1!V55),\"OK\",\"OUTSIDE envelope\")","v":{"$error":"#NAME?"}}]
[]
[null,"Notes:",{"$f":"Sheet1!R57","v":"Envelope check inactive, verify location CG in graphic"}]
[]
["(X-axis= CG location in cm from datum / Y-axis= weight in kg)",null,null,null,null,null,null,{"$f":"Sheet1!B7","v":"PVHA 12/2023"}]

{"sheet":"Sheet1","index":4,"n_rows":57,"n_cols":23,"rows_kept":57,"cut":false,"hidden":true,"merged":[[56,1,56,4],[56,9,56,12],[56,17,56,20],[9,19,9,22],[11,17,11,18],[39,17,39,18],[39,19,39,20],[12,18,13,18],[9,3,9,6],[11,1,11,2],[9,11,9,14],[11,9,11,10],[39,1,39,2],[39,3,39,4],[39,9,39,10],[39,11,39,12]]}
["Calculation"]
[null,"AVGAS 100LL","Kg/Lit",0.71599999999999997]
[null,"USG to","Liter",3.7854100000000002]
[null,"Kg to","Lbs",2.2046199999999998]
[]
["Entries from POH(Sect 6) and weight report (shaded blue)"]
["Updated","PVHA 12/2023"]
[]
[]
["OOCFC",null,null,"Total",null,null,null,null,"FGVUN",null,null,"Total",null,null,null,null,"OORAQ",null,null,"Total"]
["Weight & CG","Liters","Max","KgWeight","LbWeight","CG","Moment",null,"Weight & CG","Liters","Max","KgWeight","LbWeight","CG","Moment",null,"Weight & CG","Liters","Max","KgWeight","LbWeight","CG","Moment"]
["Empty","(From weight report >)",null,544,{"$f":"D12*$D$4","v":1199.3132799999998},74.599999999999994,89388.6,null,"Empty","(From weight report >)",null,707.32,{"$f":"L12*$D$4","v":1559.3718183999999},2.1080000000000001,1490.7950000000001,null,"Empty","(From weight report >)",null,669.04954139999995,1475,97.002600000000001,{"$f":"T12*V12","v":64899.545044607636}]
["Pilot",null,null,{"$f":"INDIRECT(A$10&\"!$E$11\")","v":75},165.34649999999999,85.5,{"$f":"E13*F13","v":14137.125749999999},null,"Pilot",null,null,{"$f":"INDIRECT(I$10&\"!$E$11\")","v":75},165.34649999999999,2.3010000000000002,{"$f":"L13*N13","v":172.57500000000002},null,"Pilot",null,181.43716380000001,{"$f":"INDIRECT(Q$10&\"!$E$11\")","v":77},{"$f":"T13*$D$4","v":169.75573999999997},93.695499999999996,{"$f":"T13*V13","v":7214.5535}]
["CoPilot",null,null,{"$f":"INDIRECT(A$10&\"!E12\")","v":75},165.34649999999999,85.5,{"$f":"E14*F14","v":14137.125749999999},null,"CoPilot",null,null,{"$f":"INDIRECT(I$10&\"!E12\")","v":65},143.30029999999999,2.3010000000000002,{"$f":"L14*N14","v":149.565},null,"CoPilot",null,null,{"$f":"INDIRECT(Q$10&\"!E12\")","v":77},169.75573999999997,93.695499999999996,{"$f":"T14*V14","v":7214.5535}]
["Rear1 pax",null,null,{"$f":"INDIRECT(A$10&\"!E13\")","v":0},0,0,0,null,"Rear1 pax",null,null,{"$f":"INDIRECT(I$10&\"!E13\")","v":75},165.34649999999999,3.2,240,null,"Rear1 pax",null,181.43716380000001,{"$f":"INDIRECT(Q$10&\"!E13\")","v":77},169.75573999999997,187.39099999999999,14429.107]
["Rear2 pax",null,null,{"$f":"INDIRECT(A$10&\"!E14\")","v":0},0,0,0,null,"Rear2 pax",null,null,{"$f":"INDIRECT(I$10&\"!E14\")","v":70},154.32339999999999,3.2,224,null,"Rear2 pax",null,null,{"$f":"INDIRECT(Q$10&\"!E14\")","v":0},0,0,0]
["Bags",null,45,{"$f":"INDIRECT(A$10&\"!E16\")","v":5},11.023099999999999,115,1267.6565000000001,null,"Bags",null,54,{"$f":"INDIRECT(I$10&\"!E16\")","v":5},11.023099999999999,3.7589999999999999,18.794999999999998,null,"Bags",null,45,{"$f":"INDIRECT(Q$10&\"!E16\")","v":5},11.023099999999999,239.43661969999999,1197.1830984999999]
["Fuel",{"$f":"C36","v":85.171725000000009},null,{"$f":"D36","v":60.982955100000005},134.444242472562,75.400000000000006,10137.095882431175,null,"Fuel",{"$f":"K36","v":115.833546},null,{"$f":"L36","v":82.936818935999995},182.84416976268429,2.4079999999999999,199.71185999788798,null,"Fuel",{"$f":"S36","v":115.07646400000002},null,{"$f":"T36","v":82.394748224000011},181.64910982959489,105.83329999999999,8720.1081072150591]
["TOW",null,{"$f":"INDIRECT(A$10&\"!E3\")","v":757},{"$f":"SUM(D12:D18)","v":759.98295510000003},{"$f":"SUM(E12:E18)","v":1675.4736224725621},{"$f":"G19/E19","v":77.033503930644443},{"$f":"SUM(G12:G18)","v":129067.6038824312},null,"TOW",null,{"$f":"INDIRECT(I$10&\"!E3\")","v":1088},{"$f":"SUM(L12:L18)","v":1080.2568189359999},{"$f":"SUM(M12:M18)","v":2381.5557881626846},{"$f":"O19/L19","v":2.3100449969441308},{"$f":"SUM(O12:O18)","v":2495.4418599978885},null,"TOW",null,{"$f":"INDIRECT(Q$10&\"!E3\")","v":1043},{"$f":"SUM(T12:T18)","v":987.44428962400002},{"$f":"SUM(U12:U18)","v":2176.9394298295952},{"$f":"W19/T19","v":104.99331591638469},{"$f":"SUM(W12:W18)","v":103675.05025032269}]
["Burn",{"$f":"INDIRECT(A$10&\"!C20\")","v":20},null,{"$f":"D37","v":-14.32},{"$f":"D20*$D$4","v":-31.570158399999997},75.400000000000006,{"$f":"E20*F20","v":-2380.38994336},null,"Burn",{"$f":"INDIRECT(I$10&\"!C20\")","v":30},null,{"$f":"L37","v":-21.48},{"$f":"L20*$D$4","v":-47.355237599999995},2.4079999999999999,-51.723840000000003,null,"Burn",{"$f":"INDIRECT(Q$10&\"!C20\")","v":30},null,{"$f":"T37","v":-21.48},{"$f":"T20*$D$4","v":-47.355237599999995},105.83329999999999,{"$f":"T20*V20","v":-2273.2992839999997}]
["LW",null,{"$f":"INDIRECT(A$10&\"!E4\")","v":757},{"$f":"SUM(D19,D20)","v":745.66295509999998},{"$f":"SUM(E19,E20)","v":1643.903464072562},{"$f":"G21/E21","v":77.064874372379336},{"$f":"SUM(G19:G20)","v":126687.2139390712},null,"LW",null,{"$f":"INDIRECT(I$10&\"!E4\")","v":1088},{"$f":"SUM(L19,L20)","v":1058.7768189359999},{"$f":"SUM(M19,M20)","v":2334.2005505626848},{"$f":"O21/L21","v":2.308057728779576},{"$f":"SUM(O19:O20)","v":2443.7180199978884},null,"LW",null,{"$f":"INDIRECT(Q$10&\"!E4\")","v":1043},{"$f":"SUM(T19,T20)","v":965.964289624},{"$f":"SUM(U19,U20)","v":2129.5841922295954},{"$f":"W21/T21","v":104.97463731893563},{"$f":"SUM(W19:W20)","v":101401.7509663227}]
[]
["Graphic",null,null,{"$f":"D12","v":544},{"$f":"E12","v":1199.3132799999998},{"$f":"F12","v":74.599999999999994},{"$f":"G12","v":89388.6},null,"Graphic",null,null,{"$f":"L12","v":707.32},{"$f":"M12","v":1559.3718183999999},{"$f":"N12","v":2.1080000000000001},{"$f":"O12","v":1490.7950000000001},null,"Graphic",null,null,{"$f":"T12","v":669.04954139999995},{"$f":"U12","v":1475},{"$f":"V12","v":97.002600000000001},{"$f":"W12","v":64899.545044607636}]
["Pilot",null,null,{"$f":"E24/D$4","v":619},{"$f":"E23+E13","v":1364.65978},{"$f":"G24/E24","v":75.861930766362889},{"$f":"G23+G13","v":103525.72575000001},null,"Pilot",null,null,{"$f":"L23+L13","v":782.32},{"$f":"L24*$D$4","v":1724.7183184},{"$f":"O24/L24","v":2.1262015543511605},{"$f":"O23+O13","v":1663.3700000000001},null,"Pilot",null,null,{"$f":"T23+T13","v":746.04954139999995},{"$f":"T24*$D$4","v":1644.7557399612676},{"$f":"W24/T24","v":96.661273203495114},{"$f":"W23+W13","v":72114.098544607637}]
["CoPilot",null,null,694.00000000000011,{"$f":"E24+E14","v":1530.0062800000001},{"$f":"G25/E25","v":76.903508853571509},{"$f":"G24+G14","v":117662.85150000002},null,"CoPilot",null,null,{"$f":"L24+L14","v":847.32},{"$f":"L25*$D$4","v":1868.0186183999999},{"$f":"O25/L25","v":2.1396107727895011},{"$f":"O24+O14","v":1812.9350000000002},null,"CoPilot",null,null,{"$f":"T24+T14","v":823.04954139999995},{"$f":"T25*$D$4","v":1814.5114799612677},{"$f":"W25/T25","v":96.383811732244325},{"$f":"W24+W14","v":79328.652044607632}]
["Rear1 pax",null,null,694.00000000000011,{"$f":"E25+E15","v":1530.0062800000001},{"$f":"G26/E26","v":76.903508853571509},{"$f":"G25+G15","v":117662.85150000002},null,"Rear1 pax",null,null,{"$f":"L25+L15","v":922.32},2033.3651184,2.2258381039118746,{"$f":"O25+O15","v":2052.9350000000004},null,"Rear1 pax",null,null,{"$f":"T25+T15","v":900.04954139999995},1984.2672199612678,104.16955371008829,{"$f":"W25+W15","v":93757.759044607636}]
["Rear2 pax",null,null,694.00000000000011,1530.0062800000001,76.903508853571509,117662.85150000002,null,"Rear2 pax",null,null,992.32,2187.6885183999998,2.2945571992905518,2276.9350000000004,null,"Rear2 pax",null,null,900.04954139999995,1984.2672199612678,104.16955371008829,93757.759044607636]
["Bags",null,null,699,1541.0293799999999,77.176015943317068,118930.50800000002,null,"Bags",null,null,997.32,2198.7116184000001,2.3018990895600213,2295.7300000000005,null,"Bags",null,null,905.04954139999995,1995.2903199612676,104.91684465827589,94954.942143107633]
["Fuel",null,null,759.98295510000014,1675.4736224725621,77.033503930644443,129067.6038824312,null,"Fuel",null,null,1080.2568189359999,2381.5557881626842,2.3100449969441308,2495.4418599978885,null,"Fuel",null,null,987.44428962400002,2176.9394297908625,104.99331591638469,103675.05025032269]
["TOW",null,{"$f":"C19","v":757},759.98295510000014,{"$f":"E29","v":1675.4736224725621},{"$f":"F29","v":77.033503930644443},129067.6038824312,null,"TOW",null,{"$f":"K19","v":1088},{"$f":"L29","v":1080.2568189359999},2381.5557881626842,2.3100449969441308,{"$f":"O29","v":2495.4418599978885},null,"TOW",null,{"$f":"S19","v":1043},{"$f":"T29","v":987.44428962400002},2176.9394297908625,104.99331591638469,{"$f":"W29","v":103675.05025032269}]
["Burn",null,null,745.66295510000009,{"$f":"E30+E20","v":1643.903464072562},{"$f":"G31/E31","v":77.064874372379336},{"$f":"G30+G20","v":126687.2139390712},null,"Burn",null,null,{"$f":"L30+L20","v":1058.7768189359999},2334.2005505626839,2.308057728779576,{"$f":"O30+O20","v":2443.7180199978884},null,"Burn",null,null,{"$f":"T30+T20","v":965.964289624},2129.5841921908627,104.97463731893563,{"$f":"W30+W20","v":101401.7509663227}]
["LW",null,{"$f":"C21","v":757},745.66295510000009,{"$f":"E31","v":1643.903464072562},{"$f":"F31","v":77.064874372379336},{"$f":"G31","v":126687.2139390712},null,"LW",null,{"$f":"K21","v":1088},{"$f":"L31","v":1058.7768189359999},2334.2005505626839,2.308057728779576,{"$f":"O31","v":2443.7180199978884},null,"LW",null,{"$f":"S21","v":1043},{"$f":"T31","v":965.964289624},2129.5841921908627,104.97463731893563,{"$f":"W31","v":101401.7509663227}]
[]
["Fuel",null,null,null,null,null,null,null,"Fuel",null,null,null,null,null,null,null,"Fuel"]
["Tank max",{"$f":"OOCFC!E5*Sheet1!D3","v":113.56230000000001},{"$f":"B35*$D$2","v":81.310606800000002},null,null,null,null,null,"Tank max",{"$f":"INDIRECT(I10&\"!E5\")*D$3","v":193.05591000000001},{"$f":"J35*$D$2","v":138.22803156000001},null,null,null,null,null,"Tank max",{"$f":"INDIRECT(Q10&\"!E5\")*$D$3","v":143.84558000000001},{"$f":"R35*$D$2","v":102.99343528}]
["Tank %/Lit",{"$f":"INDIRECT(A$10&\"!C17\")","v":0.75},{"$f":"B35*B36","v":85.171725000000009},{"$f":"C36*D$2","v":60.982955100000005},"Kg",null,null,null,"Tank %/Lit",{"$f":"INDIRECT(I$10&\"!C17\")","v":0.6},{"$f":"J35*J36","v":115.833546},{"$f":"K36*$D$2","v":82.936818935999995},"Kg",null,null,null,"Tank %/Lit",{"$f":"INDIRECT(Q$10&\"!C17\")","v":0.8},{"$f":"R35*R36","v":115.07646400000002},{"$f":"S36*$D$2","v":82.394748224000011},"Kg"]
["Burn",{"$f":"B20","v":20},null,{"$f":"-(B37*D$2)","v":-14.32},"Kg",null,null,null,"Burn",{"$f":"J20","v":30},null,{"$f":"-(J37*$D$2)","v":-21.48},"Kg",null,null,null,"Burn",{"$f":"R20","v":30},null,{"$f":"-(R37*$D$2)","v":-21.48},"Kg"]
[]
["Envelope",null,null,null,null,null,null,null,"Envelope",null,null,null,null,null,null,null,"Envelope"]
["Contour","Total contour",null,"Utility contour",null,null,null,null,"Contour","Total contour",null,"Utility contour",null,null,null,null,"Contour","Total contour",null,"Utility contour"]
[null,"Weight","CG","Weight","CG",null,null,null,null,"Weight","CG","Weight","CG",null,null,null,null,"Weight","CG","Weight","CG"]
["Pt1",1100,72.400000000000006,1100,72.400000000000006,null,null,null,"Pt1",700,2.0569999999999999,700,2.0569999999999999,null,null,null,"Pt1",600,89,600,89]
["Pt2",1300,72.400000000000006,1300,72.400000000000006,null,null,null,"Pt2",870,2.0569999999999999,870,2.0569999999999999,null,null,null,"Pt2",884.50617339999997,89,884.50620000000004,89]
["Pt3",1670,73.7,1670,73.7,null,null,null,"Pt3",1088,2.2599999999999998,929,2.1120000000000001,null,null,null,"Pt3",1043.2619999999999,98,907.18470000000002,90]
["Pt4",1670,78.5,1670,78.5,null,null,null,"Pt4",1088,2.3490000000000002,929,2.1669999999999998,null,null,null,"Pt4",1043.2619999999999,120,907.18470000000002,103]
["Pt5",1100,78.5,1100,78.5,null,null,null,"Pt5",700,2.3490000000000002,700,2.1669999999999998,null,null,null,"Pt5",600,120,600,103]
["Pt6",1100,72.400000000000006,1100,72.400000000000006,null,null,null,"Pt6",700,2.0569999999999999,700,2.0569999999999999,null,null,null,"Pt6",600,89,600,89]
["Pt7",null,null,null,null,null,null,null,"Pt7",null,null,null,null,null,null,null,"Pt7"]
["Pt8",null,null,null,null,null,"(False = within env)",null,"Pt8",null,null,null,null,null,"(False = within env)",null,"Pt8",null,null,null,null,null,"(False = within env)"]
["Envelope score",null,{"$f":"MAX(C42:C47)","v":78.5},"(Max right CG)",null,"CG  in envelope check",{"$f":"IF(PtInPoly(E19,F19,B42:C47),FALSE,TRUE)","v":{"$error":"#NAME?"}},null,"Envelope score",null,{"$f":"MAX(K42:K47)","v":2.3490000000000002},"(Max right CG)",null,"CG  in envelope check",{"$f":"IF(PtInPoly(L19,N19,J42:K47),FALSE,TRUE)","v":{"$error":"#NAME?"}},null,"Envelope score",null,{"$f":"MAX(S42:S47)","v":120},"(Max right CG)",null,"CG  in envelope check",{"$f":"IF(PtInPoly(T19,V19,R42:S47),FALSE,TRUE)","v":{"$error":"#NAME?"}}]
[]
["Alerts",null,null,null,null,"(False = ok)",null,null,"Alerts",null,null,null,null,"(False = ok)",null,null,"Alerts",null,null,null,null,"(False = ok)"]
["Over MTOW",null,null,null,null,{"$f":"IF(D19>C19,TRUE)","v":true},{"$f":"D19-C19","v":2.9829551000000265},null,"Over MTOW",null,null,null,null,{"$f":"IF(L19>K19,TRUE)","v":false},{"$f":"L19-K19","v":-7.7431810640000549},null,"Over MTOW",null,null,null,null,{"$f":"IF(T19>S19,TRUE)","v":false},{"$f":"T19-S19","v":-55.555710375999979}]
["Over MLW",null,null,null,null,{"$f":"IF(D21>C21,TRUE)","v":false},{"$f":"D21-C21","v":-11.337044900000024},null,"Over MLW",null,null,null,null,{"$f":"IF(L21>K21,TRUE)","v":false},{"$f":"L21-K21","v":-29.223181064000073},null,"Over MLW",null,null,null,null,{"$f":"IF(T21>S21,TRUE)","v":false},{"$f":"T21-S21","v":-77.035710375999997}]
["Outside envelope",null,null,null,null,{"$f":"G50","v":{"$error":"#NAME?"}},null,null,"Outside envelope",null,null,null,null,{"$f":"O50","v":{"$error":"#NAME?"}},null,null,"Outside envelope",null,null,null,null,{"$f":"W50","v":{"$error":"#NAME?"}}]
["Poligon check inactive",null,null,null,null,{"$f":"IF(ISERROR(F55),TRUE,FALSE)","v":true},null,null,"Poligon check inactive",null,null,null,null,{"$f":"IF(ISERROR(N55),TRUE,FALSE)","v":true},null,null,"Poligon check inactive",null,null,null,null,{"$f":"IF(ISERROR(V55),TRUE,FALSE)","v":true}]
["Notes",{"$f":"IF(F56,\"Envelope check inactive, verify location CG in graphic\",\"(Nil)\")","v":"Envelope check inactive, verify location CG in graphic"},null,null,null,null,null,null,"Notes",{"$f":"IF(N56,CONCATENATE(\"Fuel up to the TAB's equals 72% or 139 lit usable (36,4 Usg)\",CHAR(10),\"Envelope check inactive, verify location CG in graphic\"),\"Fuel up to the TAB's equals 72% or 139 lit usable (36,4 Usg)\")","v":"Fuel up to the TAB's equals 72% or 139 lit usable (36,4 Usg)\nEnvelope check inactive, verify location CG in graphic"},null,null,null,null,null,null,"Notes",{"$f":"IF(V56,\"Envelope check inactive, verify location CG in graphic\",\"(Nil)\")","v":"Envelope check inactive, verify location CG in graphic"}]