{"text_format":"3","workbook":"xlsx","n_sheets":18,"sheets":["coverSheet","Worksheet 1","Worksheet 1b builder's plate","Worksheet 2","Worksheet 3","Worksheet 3a Overview","Worksheet 3b Overview","Worksheet 4","Worksheet 5","Worksheet 6a","Worksheet 6b","Worksheet 10","Worksheet 11","Worksheet 12","Worksheet 13","Worksheet 14","Worksheet 15","Worksheet 16"],"not_rendered":{"charts":2,"images":15,"defined_names":21,"comments":3},"read":"whole","date_system":"1900"}

{"sheet":"coverSheet","index":0,"n_rows":35,"n_cols":2,"rows_kept":35,"merged":[[2,0,2,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[11,1,11,5],[13,0,13,5],[14,0,14,5],[16,0,16,1],[17,0,17,1],[19,0,20,5],[22,0,22,5],[24,0,24,5],[26,0,26,5],[28,0,28,5],[30,0,30,5],[32,0,32,5],[34,0,34,5]]}
[]
[]
["ISO 12217-2:2017     SAILING BOATS OF LENGTH GREATER THAN OR EQUAL TO 6m"]
[null,"For Multihulls only, for Monohulls see other template"]
["Manufacturer:"]
["Signatory, Name:"]
["Signatory, Title:"]
["Phone:"]
["Email:"]
["WWW:"]
["CIN Model Year:"]
["Model Name:"]
[]
["This calculation sheet is provided by IMCI \"as is\" and any express or implied warranties, including, but not limited to, the implied warranties of fitness for a particular purpose are disclaimed."]
[]
[]
["blue cells are derived values"]
["yellow cells require data input"]
[]
["Please make sure to set your signature on the summary! (worksheet 16)\neither digitally or print summary, sign and attach scan"]
[]
[]
["  - most worksheets have additional comments / remarks / other calculations beside the printout area; please take into account."]
[]
["  - If curves or righting moments are required, please fill in worksheets 6a and 6b or attach curve of righting moments for both loading conditions  to the documentation."]
[]
["  - For boats with quick-draining cockpit the cockpit calculation according to ISO 11812 shall be enclosed to the documentation."]
[]
["- Some worksheets (just valid for Monohulls) are deleted from this template for a better overview, please don't mind the numbering of the sheets still according to ISO 12217-2:2017 "]
[]
["  - Please attach other detailed information as appropriate, e.g. photos, sketches etc. for sill height, openings, companion way doors, location of flooding points, practical tests etc."]
[]
["-  When entering data, please use the correct separator for your Excel version, many application problems are the result of incorrect separators ( , or . )"]
[]
["- Please be aware that there is NO technical difference between the requirements of ISO 12217-2:2015 and ISO 12217-2:2017; change of the name is just because of the harmonisation process; for FDIS ISO 12217-2:2020 the main change is exclusion of optional equipment from the maximum load and the result of the \"maximum recommended load for builder's plate\" (With ISO 14945 and ISO 14946 renamed to \"maximum load for the builder's plate, mMBP\") which exludes OB engine weights and the optional equipment."]

{"sheet":"Worksheet 1","index":1,"n_rows":50,"n_cols":53,"rows_kept":50,"merged":[[0,0,0,9],[0,11,0,12],[2,0,2,9],[3,0,3,9],[5,0,5,9],[8,0,8,5],[13,8,14,8],[13,11,15,24],[39,11,39,28],[44,0,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[44,14,44,32],[48,6,48,7],[49,0,49,9],[60,11,62,16]]}
[{"$nulls":11},"Comments"]
[{"$nulls":12},"Derived values"]
["ISO 12217-2:2017   SAILING BOATS OF LENGTH GREATER THAN OR EQUAL TO 6m",{"$nulls":11},"Input values"]
["CALCULATION WORKSHEET No. 1"]
["ISO 12217-2:2017-Multihull en220801"]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[]
["Design Category intended:",{"$nulls":4},"Monohull / multihull:",null,"Multihull"]
["Item",{"$nulls":5},"Symbol","Unit","Value","Ref.",{"$nulls":41},"list:","list:"]
["Length of hull as in ISO 8666",{"$nulls":5},"LH","m",null,"3.4.1",{"$nulls":41},"A","Monohull"]
["Length of waterline in loaded arrival condition",{"$nulls":5},"Lwl","m",null,"3.4.2",{"$nulls":41},"B","Multihull"]
["Empty Craft condition mass",{"$nulls":5},"mEC","kg",null,"3.5.1",{"$nulls":41},"C"]
[null,"standard equipment",{"$nulls":5},"kg",null,"3.6.12",null,"Please be aware that 3.6.12 is including OB engines weights and the essential safety equipment (as listed in 3.6.5*)",{"$nulls":39},"D"]
[null,"water ballast in tanks which are notified in the owner's",{"$nulls":5},"kg",null,"3.5.2",null,"* 3.6.5 requires the mass of the liferaft only for design cat. A&B. The RCD requires a storage place for the liferaft also for design cat C&D boats longer than 6m!\nTherefore IMCI (in accordance with ERFU 118) recommends to take the mass of the liferaft into account for cat C&D boats >6m also; please add to the essential safety equipment."]
[null,"manual to be filled when the boat is afloat",{"$nulls":24},"mLC +75 for wind stiffness test"]
["Light craft condition mass",{"$nulls":5},"mLC","kg",{"$f":"I12+I13+I14","v":{"v":0,"d":"0.0"}},"3.5.2",{"$nulls":16},{"$f":"I16+75","v":{"v":75,"d":"75.0"}}]
["Mass of:",{"$nulls":9},"ATTENTION"]
["Desired crew limit",{"$nulls":5},"CL"," ----",null,"3.6.3","Please insert here 100 % of the masses of the fluids (in kg)."]
["Mass of:",{"$nulls":9},"For the calculation of the maximum load (mL) each fluid mass will be factored, see clause 3.5.4"]
[null,"desired crew limit at 75 kg each",{"$nulls":5},"kg",{"$f":"I18*75","v":{"v":0,"d":"0.0"}},"'3.5.4"]
[null,"provisions + personal effects",{"$nulls":5},"kg",null,"'3.5.4"]
[null,"drinking water",{"$nulls":5},"kg",{"$f":"K22*0.95","v":{"v":0,"d":"0.0"}},"'3.5.4"]
[null,"fuel",{"$nulls":5},"kg",{"$f":"K23*0.95","v":{"v":0,"d":"0.0"}},"'3.5.4"]
[null,"lubricating and hydraulic oils",{"$nulls":5},"kg",{"v":0,"d":"0.0"},"'3.5.4"]
[null,"black water",{"$nulls":5},"kg",{"v":0,"d":"0.0"},"'3.5.4"]
[null,"grey water",{"$nulls":5},"kg",{"v":0,"d":"0.0"},"'3.5.4"]
[null,"water ballast",{"$nulls":5},"kg",{"$f":"K27","v":{"v":0,"d":"0.0"}},"'3.5.4"]
[null,"other fluids carried aboard",{"$nulls":5},"kg",{"$f":"0.95*K28","v":{"v":0,"d":"0.0"}},"'3.5.4"]
[null,"stores, spare gear and cargo (if any)",{"$nulls":5},"kg",null,"'3.5.4"]
[null,"inflatable life raft(s) in excess of essential safety equipment",{"$nulls":5},"kg",null,"'3.5.4"]
[null,"other small boats carried aboard",{"$nulls":5},"kg",null,"'3.5.4",null,"Please be aware that for specific reasons the value 'margin for future addtions' is deleted, if necessary please add a future margin to optional equipment"]
[null,"Maximum load = sum of masses (FDIS ISO 12217-1:2020)",{"$nulls":4},"mL","kg",{"$f":"SUM(I20:I31)","v":{"v":0,"d":"0.0"}},"'3.5.4",null,"New upcoming standard version FDIS ISO 12217-2:2020 will exclude the optional equipment from the maxium load (and therefore from the maximum load for the builder's plate)"]
[null,"optional equipment and fittings not included in basic outfit",{"$nulls":5},"kg",null,"'3.5.4"]
["Maximum load = sum of above masses using ISO 12217-1:2017",{"$nulls":5},"mL","kg",{"$f":"I32+I33","v":{"v":0,"d":"0.0"}},"'3.5.4"]
["Maximum Load condition mass",{"$nulls":5},"mLDC","kg",{"$f":"I16+I34","v":{"v":0,"d":"0.0"}},"'3.5.5"]
["mass to be removed for loaded arrival condition",{"$nulls":6},"kg",null,"'3.5.6"]
["Loaded Arrival condition mass",{"$nulls":5},"mLA","kg",{"$f":"I35-I36","v":{"v":0,"d":"0.0"}},"'3.5.6",null,null,"maximum value:",{"$f":"I34+I16-0.85*100/95*(I22+I23+I24)","v":{"v":0,"d":"0.0"}},null,"minimum value:",{"$f":"I34+I16-0.85*100/95*(I22+I23+I24)-0.9*I21","v":{"v":0,"d":"0.0"}},"pending on mass of edible stores included in provisions + personal effects"]
["Mass of:"]
[null,"minimum number of crew according to 3.5.3",{"$nulls":5},"kg",{"$f":"IF(I10>24,\"ERROR\",IF(I10=\"\",\"\",IF(I10<=8,75,IF(I10<=16,150,225))))","v":""},"3.5.3a)",null,"75 kg where LH ≤ 8 m, 150 kg where 8 m < LH ≤ 16 m, 225 kg where 16 m < LH ≤ 24 m"]
[null,"non-consumable stores and equipment normally aboard",{"$nulls":5},"kg",null,"3.5.3b)"]
[null,"inflatable life raft",{"$nulls":5},"kg",null,"'3.5.3"]
["Load to be included in Minimum Operating Condition",{"$nulls":5},"m'L","kg",{"$f":"SUM(I39:I41)","v":{"v":0,"d":"0.0"}},"'3.5.3"]
["Light craft condition mass",{"$nulls":5},"mLC","kg",{"$f":"I16","v":{"v":0,"d":"0.0"}},"'3.5.2"]
["Mass in the Minimum Operating Condition",{"$nulls":5},"mMO","kg",{"$f":"SUM(I42:I43)","v":{"v":0,"d":"0.0"}},"'3.5.3"]
["Maximum load for the builder's plate using EN ISO 14945:2021 and  \nEN ISO 14946:2021 (if manually reduced on Worksheet 1b the reduced value is shown)",{"$nulls":5},"mMBP","kg",{"$f":"IF('Worksheet 1b builder''s plate'!S6=\"\",\"\",IF('Worksheet 1b builder''s plate'!I24=\"\",'Worksheet 1b builder''s plate'!S6,IF('Worksheet 1b builder''s plate'!I24>'Worksheet 1b builder''s plate'!S6,'Worksheet 1b builder''s plate'!S6,'Worksheet 1b builder''s plate'!I24)))","v":{"v":0,"d":"0.0"}},"ISO 14945"]
[{"$nulls":9},"ISO 14946"]
["Is boat sail or non-sail?      nominal sail area",{"$nulls":5},"AS","m2",null,"'3.4.8"]
["sail area / displacement ratio = AS / (mLDC)2/3",{"$nulls":6}," -----",{"$f":"I47/(I35)^(2/3)","v":{"$error":"#DIV/0!"}},"3.1.2",{"$nulls":41},"SAIL"]
["CLASSIFIED AS [non-sail if AS / (mLDC)2/3 < 0.07]",{"$nulls":5},"SAIL/NON-SAIL ?",null,{"$f":"IF(I47=\"\",\"\",IF(I47/I35^(2/3)<0.07,\"NON-SAIL\",\"SAIL\"))","v":""},"3.1.2",{"$nulls":41},"NON-SAIL"]
["NB If SAIL, continue using these worksheets, if NON-SAIL, use ISO 12217-1"]

{"sheet":"Worksheet 1b builder's plate","index":2,"n_rows":47,"n_cols":21,"rows_kept":47,"merged":[[0,14,0,15],[1,0,1,10],[3,0,3,10],[3,17,3,24],[3,25,3,32],[3,33,3,40],[3,41,3,48],[3,49,3,56],[3,57,3,64],[3,65,3,72],[3,73,3,80],[3,81,3,88],[3,89,3,96],[3,97,3,104],[3,105,3,112],[3,113,3,120],[3,121,3,128],[3,129,3,136],[3,137,3,144],[3,145,3,152],[3,153,3,160],[3,161,3,168],[3,169,3,176],[3,177,3,184],[3,185,3,192],[3,193,3,200],[3,201,3,208],[3,209,3,216],[3,217,3,224],[3,225,3,232],[3,233,3,240],[3,241,3,248],[3,249,3,256],[5,0,20,10],[6,23,7,23],[6,24,7,25],[6,26,7,27],[8,24,8,25],[8,26,8,27],[22,0,22,7],[23,0,23,7],[24,0,24,7],[25,0,25,7],[34,3,35,9],[35,23,36,23],[35,24,36,25],[35,26,36,27],[36,3,36,9],[37,3,38,9],[37,24,37,25],[37,26,37,27],[39,1,41,2],[41,3,42,3],[41,6,42,7],[41,8,42,8],[46,6,46,7]]}
[{"$nulls":14},"Comments"]
["ISO 12217-2:2017 / ISO 14945:2021   CALCULATION WORKSHEET No.1b  Builder's plate ",{"$nulls":14},"Derived values"]
[{"$nulls":15},"Input values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"   \",coverSheet!B12)","v":"   "}]
[]
["Since 2021-12-09 EN ISO 14945:2021 and EN ISO 14946:2021 are harmonised!\nThe formely 'Maximum recommended load for builder's plate' became  'Maximum load for the builder's plate', mMBP.  \nmMBP does not include the optinonal equipment anymore; also the weight of outboard engines is excluded from mMBP and can be shown in a seperated line on the plate.\nBelow you find an examples for the builder's plate with the maxium value for mMBP calcuated from the stability calculation on worksheet 1.\nFor portable tanks, please change the default 'yes' on the right side in 'no, portable tank'; the weight of the tank will be included in mMBP\nPlease be aware that ISO 14946:2021 allowes in clause 6 that the maximum recommended load can be downrated or limited by the manufacturer at any time. Therefore you find a extra cell to enter a manual reduced value for the maximum load for the builder's plate.\n\nPlease be also aware that the design of these plates is just a proposal from EN ISO 14945, the manufacturer is free to change the design as long all requirements of the standard are fulfilled.",{"$nulls":16},"maximum load for the builder's plate acc. to EN ISO 14945:2021:",{"$f":"'Worksheet 1'!I20+'Worksheet 1'!I21+'Worksheet 1'!I29+'Worksheet 1'!I30+'Worksheet 1'!I31+T16","v":0},"kg"]
[]
[]
[{"$nulls":17},"water in fixed tank(s)?","Yes",{"$f":"IF(S9=\"Yes\",\"\",'Worksheet 1'!I22)","v":""},"kg"]
[{"$nulls":17},"fuel in fixed tank(s)?","Yes",{"$f":"IF(S10=\"Yes\",\"\",'Worksheet 1'!I23)","v":""},"kg"]
[{"$nulls":17},"oils in fixed tank(s)?","Yes",{"$f":"IF(S11=\"Yes\",\"\",'Worksheet 1'!I24)","v":""},"kg"]
[{"$nulls":17},"black water in fixed tank(s)?","Yes",{"$f":"IF(S12=\"Yes\",\"\",'Worksheet 1'!I25)","v":""},"kg"]
[{"$nulls":17},"grey water in fixed tank(s)?","Yes",{"$f":"IF(S13=\"Yes\",\"\",'Worksheet 1'!I26)","v":""},"kg"]
[{"$nulls":17},"water ballast in fixed tank(s)?","Yes",{"$f":"IF(S14=\"Yes\",\"\",'Worksheet 1'!I27)","v":""},"kg"]
[{"$nulls":17},"other fluids in fixed tank(s)?","Yes",{"$f":"IF(S15=\"Yes\",\"\",'Worksheet 1'!I28)","v":""},"kg"]
[{"$nulls":18},"mass of portable tanks to be included in mMBP",{"$f":"SUM(T9:T15)","v":0},"kg"]
[]
[]
[]
[]
[]
[]
["Item",{"$nulls":7},"Value","Unit","Ref."]
["Manually reduced value for the 'Maximum load for the builder's plate mMBP",{"$nulls":8},"kg","EN ISO 14945, cl. 6,\n note 2"]
["Maximum engine power of a single engine",{"$nulls":8},"kW"]
["number of engines"]
[]
["Please see builder's plate example with values calculated from worksheet 1 entries on next page:"]
[]
[]
[]
["Builder’s plate information for craft powered by inboard or sterndrive engines"]
[]
[]
[{"$nulls":3},{"$f":"IF(coverSheet!B5=\"\",\"\",coverSheet!B5)","v":""}]
[]
[{"$nulls":3},"Contact Address",{"$nulls":7},"This is not to be used as a builder's plate template!"]
[null,null,"     0609",{"$f":"IF(coverSheet!B12=\"\",\"\",coverSheet!B12)","v":""},{"$nulls":7},"Please be aware that EN ISO 14945:2021 has requirements for the size of letters and piktogramms"]
[]
[null,{"$f":"IF('Worksheet 1'!$D$8=\"\",\"\",'Worksheet 1'!$D$8)","v":""}]
[]
[{"$nulls":3},{"$f":"'Worksheet 1'!$I$18","v":0},null,null,{"$f":"IF(I24=\"\",S6,IF(I24>S6,S6,I24))","v":0},null,"kg"]
[]
[]
[]
[]
[{"$nulls":4},"  max.",null,{"$f":"I25*I26","v":0},null,"kW"]

{"sheet":"Worksheet 2","index":3,"n_rows":55,"n_cols":53,"rows_kept":55,"merged":[[0,11,0,12],[2,0,2,9],[2,11,2,12],[2,14,2,21],[2,22,2,29],[2,30,2,37],[2,38,2,45],[2,46,2,53],[2,54,2,61],[2,62,2,69],[2,70,2,77],[2,78,2,85],[2,86,2,93],[2,94,2,101],[2,102,2,109],[2,110,2,117],[2,118,2,125],[2,126,2,133],[2,134,2,141],[2,142,2,149],[2,150,2,157],[2,158,2,165],[2,166,2,173],[2,174,2,181],[2,182,2,189],[2,190,2,197],[2,198,2,205],[2,206,2,213],[2,214,2,221],[2,222,2,229],[2,230,2,237],[2,238,2,245],[2,246,2,253],[4,0,4,9],[6,0,6,5],[8,0,8,5],[9,0,9,9],[10,0,10,5],[11,0,11,5],[12,0,12,5],[13,0,13,5],[14,0,14,9],[15,0,15,5],[16,0,16,5],[20,0,20,1],[21,0,21,1],[21,4,22,9],[22,0,22,1],[23,0,23,1],[24,0,24,1],[24,4,25,9],[25,0,25,1],[26,0,27,0],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[33,0,33,1],[34,0,34,1],[35,0,35,1],[36,0,36,1],[37,0,37,1],[38,0,38,1],[39,0,39,1],[40,0,40,1],[41,0,41,1],[44,0,44,9],[48,2,48,7]]}
[]
[]
["ISO 12217-2:2017     CALCULATION WORKSHEET No.2  TESTS TO BE APPLIED",{"$nulls":10},"Comments"]
[{"$nulls":12},"Derived values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "},{"$nulls":11},"Input values"]
[]
["Question",{"$nulls":5},"Symbol","Unit","Answer","Ref."]
["Is boat fully enclosed?         (see definition in ref.)              ",{"$nulls":6},"Yes / No",null,"3.1.8",null,{"$f":"IF(I8=\"Yes\",\"please add cockpit calculation according to ISO 11812 to the stability sheets\",\"\")","v":""},{"$nulls":38},"list:"]
["Is boat a catamaran or trimaran? ",{"$nulls":8},"3.1.3, 3.1.4",{"$nulls":40},"Yes"]
["If NO, choose from options 1 to 7, ISO 12217-2 Monohull worksheets",{"$nulls":49},"No"]
["Length of hull",{"$nulls":5},"LH","m",{"$f":"'Worksheet 1'!I10","v":{"v":0,"d":"0.00"}},"3.4.1"]
["Beam of Hull",{"$nulls":5},"BH",null,null,"3.4.3",null,"ISO 8666:2018 cl. 4.3.3",{"$nulls":38},"catamaran"]
["If boat is a multihull: Beam between centres of buoyancy of sidehulls",{"$nulls":5},"BCB","m",null,"3.4.5",null,"For multihulls, BH shall be measured as the beam across the outer hulls.",{"$nulls":38},"trimaran"]
["Is ratio LH /BCB > 5",{"$nulls":6},"Yes / No",{"$f":"IF(I13=\"\",\"\",IF('Worksheet 1'!I10/'Worksheet 2'!I13>5,\"YES\",\"NO\"))","v":""},"7.1",{"$nulls":40},"other"]
["If YES, treat the boat as a monohull, and choose from options 1 to 7. Please use Monohull-template in this case. If NO, use option 8",{"$nulls":49},"Monohull"]
["Mass in the minimum operating condition",{"$nulls":5},"mMO","kg",{"$f":"'Worksheet 1'!I44","v":0},"3.5.3"]
["Mass in the loaded arrival condition",{"$nulls":5},"mLA","kg",{"$f":"'Worksheet 1'!I37","v":0},"3.5.6"]
[]
["Choose any ONE of the following options and use all the worksheets indicated for that option. *"]
[]
[null,null,"Multih.","Multih."]
["Option",null,8,"/","worksheets 1 and 2 should be filled in in any case",{"$nulls":44},"xx","A1",{"$f":"CONCATENATE('Worksheet 1'!D8,'Worksheet 2'!E47)","v":"8"},{"$f":"COUNTIF(AY22:AY39,AZ22)","v":0}]
["categories possible",null,"A – D","C, D",{"$nulls":45},"xx","B1"]
["decking or covering",null,"see note a  ","any",{"$nulls":45},"xx","C2"]
["downflooding openings",null,3,null,"the second coulum is added for boats of design cat C or D using clause 7.1.1 b)",{"$nulls":44},"xx","C3"]
["downflooding angle",{"$nulls":48},"xx","C4"]
["downflooding \nheight test","all boats",3,{"$nulls":46},"xx","C5"]
[null,"full method",4,{"$nulls":46},"xx","C6"]
["recess size",null,"5d",{"$nulls":46},"xx","C7"]
["minimum energy",{"$nulls":48},"xx","D2"]
["angle of vanishing stability",{"$nulls":48},"xx","D3"]
["stability index",{"$nulls":48},"xx","D4"]
["knockdown-recovery test",{"$nulls":49},"D5"]
["wind stiffness test",{"$nulls":49},"D6"]
["flotation requirement",null,"10e     ",{"$nulls":47},"D7"]
["capsize recovery test",null,null,11,{"$nulls":46},"A8"]
["bare poles speed",null,12,{"$nulls":47},"B8"]
["wind speed limits",null,13,{"$nulls":47},"C8"]
["stability requirements",null,14,{"$nulls":47},"D8"]
["habitable multihulls, escape after inversion",null,"14e      "]
["detection & removal of water",null,15,15]
["SUMMARY",null,16,16]
["a   Fully enclosed if category A or B, otherwise any amount."]
["d   Applicable for category A, B and boats of design category C that are fully enclosed"]
["e   Only applicable if boat is defined as habitable according to 3.1.9, and is deemed to be vulnerable to inversion when used \n   in design category – see 7.11.2 & 7.11.3."]
[{"$nulls":51},"list:"]
[null,null,"Option selected",null,8,{"$nulls":45},{"$f":"G47","v":0},1]
[{"$nulls":50},{"$f":"CONCATENATE('Worksheet 1'!D8,'Worksheet 2'!AY47)","v":"0"},2]
[null,null,{"$f":"IF(OR($E$47=\"\",'Worksheet 1'!$D$8=\"\"),\"\",IF('Worksheet 2'!$BA$22=1,\"\",\"impossible combination of design category and option\"))","v":""},{"$nulls":48},3]
[{"$nulls":51},4]
[{"$nulls":51},5]
[{"$nulls":51},6]
[{"$nulls":51},7]
[{"$nulls":51},8]
[{"$nulls":51},"/"]

{"sheet":"Worksheet 3","index":4,"n_rows":44,"n_cols":63,"rows_kept":44,"merged":[[0,13,0,14],[2,0,2,8],[4,0,4,8],[7,0,7,6],[13,7,14,7],[13,8,14,8],[18,0,18,6],[19,0,19,6],[20,0,20,6],[21,0,21,6],[22,0,22,7],[23,0,23,6],[24,0,24,6],[25,0,25,6],[26,0,26,6],[27,0,27,7],[28,0,28,6],[29,0,29,7],[32,0,32,4],[32,5,32,6],[32,7,32,8],[33,0,33,4],[33,5,33,6],[33,7,33,8],[34,0,34,4],[34,5,34,6],[34,7,34,8],[35,0,35,4],[35,5,35,6],[35,7,35,8],[36,0,36,4],[36,5,36,8],[37,0,40,0],[37,1,37,2],[37,5,37,6],[37,7,37,8],[38,1,38,2],[38,5,38,6],[38,7,38,8],[39,1,39,2],[39,5,39,6],[39,7,39,8],[40,1,40,2],[40,5,40,6],[40,7,40,8],[41,0,41,2],[41,3,41,4],[41,5,41,6],[41,7,41,8],[42,0,42,4],[42,5,42,6],[42,7,42,8],[43,0,43,7]]}
[{"$nulls":13},"Comments"]
[{"$nulls":14},"Derived values"]
["ISO 12217-2:2017    CALCULATION WORKSHEET No. 3   DOWNFLOODING",{"$nulls":13},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[]
["Downflooding Openings (ref. to cl 7.2):"]
["Question",{"$nulls":6},"Answer","Ref."]
["Have all appropriate downflooding openings been identified?",{"$nulls":7},"6.2.1",{"$nulls":42},{"$f":"IF(H9=\"Yes\",1,0)","v":0},"list:"]
["Have potential downflooding openings within the boat been identified?",{"$nulls":7},"6.2.1.4",{"$nulls":42},{"$f":"IF(H10=\"Yes\",1,0)","v":0},"Yes"]
["Do all closing appliances satisfy ISO 12216?",{"$nulls":7},"6.2.1.1",{"$nulls":42},0,"No"]
["Hatches or opening type appliances are not fitted below minimum height above waterline?",{"$nulls":7},"6.2.1.2",{"$nulls":42},0]
["Seacocks comply with requirements?",{"$nulls":7},"6.2.1.3",{"$nulls":42},0]
["Are all openings on design category A or B boats fitted with closing appliances?",{"$nulls":7},"6.2.1.5",{"$nulls":42},0]
["(Except openings for ventilation and engine combustion)",{"$nulls":50},{"$f":"SUM(AZ9:AZ14)","v":0},null,"Abfrage nach Design Kategorie"]
["Categories possible: A or B if all are YES, C or D if first five are YES",{"$nulls":6},{"$f":"IF(AZ15=6,\"A\",IF(AND(AZ15=5,H14<>\"Yes\"),\"C\",\"Fail\"))","v":"Fail"},"6.2.1",{"$nulls":44},{"$f":"IF(H16=\"A\",1,IF(H16=\"C\",3))","v":false},"mögliche Kategorie downflooding"]
[{"$nulls":53},{"$f":"IF('Worksheet 1'!D8=\"A\",1,IF('Worksheet 1'!D8=\"B\",2,IF('Worksheet 1'!D8=\"C\",3,4)))","v":4},"applied for"]
["Exemptions Downflooding Openings (ref. to 7.2) :"]
["Question",{"$nulls":6},"Answer","Ref.",null,"If questions are not applicable, just leave the cells empty",{"$nulls":42},{"$f":"IF(BB17>=BB16,\"ok\",\"fail\")","v":"fail"}]
["Drains from quick-draining recesses or watertight recesses acc. to cl. 6.1.1.6 b) are either:"]
["1)   freeing ports with non-return flaps which are watertight from the exterior (degree 3)       or",{"$nulls":7},"6.2.1.6 b)",{"$nulls":42},{"$f":"IF(AND(H21=\"\",H22=\"\"),0,IF(OR(H21=\"Yes\",H22=\"Yes\"),1,10))","v":0},null,{"$f":"AZ21+AZ25+AZ29","v":0}]
["2)   have a drainage area smaller than three times the minimum area required of ISO 11812",{"$nulls":7},"6.2.1.6 b)",{"$nulls":44},{"$f":"IF(BB21=0,\"n.a.\",IF(BB21>9,\"poss. downfl.\",\"PASS\"))","v":"n.a."}]
[{"$f":"IF(AND(H21=\"\",H22=\"\"),\"\",IF(OR(H21=\"Yes\",H22=\"Yes\"),\"\",\"ATTENTION, openings to be considered as possible downflooding openings !\"))","v":""},{"$nulls":7},"6.2.1.6 b)"]
["Opening appliances (e.g. side doors) in the topsides which comply with ISO 12216 are"]
["1)   referenced in the owner’s manual as watertight closure to be kept shut when under way, and",{"$nulls":7},"6.2.1.6 d)",{"$nulls":42},{"$f":"IF(AND(H25=\"\",H26=\"\",H27=\"\"),0,IF(AND(H25=\"Yes\",H26=\"Yes\",H27=\"Yes\"),1,10))","v":0}]
["2)   marked inboard with “KEEP SHUT WHEN ...\" in upper case letters not less than 4,8 mm high, and",{"$nulls":7},"6.2.1.6 d)"]
["3)   the hight above waterline of the lowest part is > 50% of required downflooding height ",{"$nulls":7},"6.2.1.6 d)"]
[{"$f":"IF(AND(H25=\"\",H26=\"\",H27=\"\",H30=\"\"),\"\",IF(AND(H25=\"Yes\",H26=\"Yes\",H27=\"Yes\"),\"\",\"ATTENTION, openings to be considered as possible downflooding openings !\"))","v":""},{"$nulls":7},"6.2.1.6 d)"]
["All other exemtions of cl. 6.2.1.6 checked and requirements fullfilled?",{"$nulls":7},"6.2.1.6",{"$nulls":42},{"$f":"IF(H29=\"\",0,IF(H29=\"yes\",1,10))","v":0}]
[{"$f":"IF(H29=\"\",\"\",IF(H29=\"Yes\",\"\",\"ATTENTION, openings to be considered as possible downflooding openings !\"))","v":""},{"$nulls":7},"6.2.1.6"]
[]
["Downflooding Height:"]
["Requirement",{"$nulls":4},"Basic requirement",null,"Reduced value for small openings",{"$nulls":44},"list"]
["Applicable to",{"$nulls":4},"options 1-3, 5 and 8",null,"options 1-3,5 and 8, but only if fig. 2 is used",{"$nulls":44},"fig. 2"]
["Ref.",{"$nulls":4},"6.1.2.2 a)",null,"6.1.2.2 d)",{"$nulls":44},"annex A"]
["obtained from Fig. 2 or annex A?",{"$nulls":6}," = basic x 0.75"]
["Maximum area of small openings (50LH2) (mm2) =",{"$nulls":4},{"$f":"50*'Worksheet 1'!I10^2","v":0},{"$nulls":46},"cat C only",{"$nulls":7},"worksheet 3 abfrage gesamt"]
["Required downflooding height \nhD(R)","Fig. 2 / ann. A",null,"Category","A",{"$f":"IF('Worksheet 1'!D8=\"A\",IF(F36=\"annex A\",\"see worksheet 4\",IF(F36=\"fig. 2\",MAX(0.5,'Worksheet 1'!I10/17),\"\")),\"\")","v":""},null,{"$f":"IF(F38=\"\",\"\",IF($F$36=\"fig. 2\",F38*0.75,\"\"))","v":""},{"$nulls":49},1,"A",null,{"$f":"IF(F43=\"A\",1,IF(F43=\"B\",2,IF(F43=\"C\",3,IF(F43=\"D\",4,IF(F43=\"Fail\",99)))))","v":false},null,{"$f":"IF(H43=\"A\",1,IF(H43=\"B\",2,IF(H43=\"C\",3,IF(H43=\"D\",4,IF(H43=\"Fail\",99)))))","v":false}]
[null,"Fig. 2 / ann. A",null,"Category","B",{"$f":"IF('Worksheet 1'!D8=\"B\",IF(F36=\"annex A\",\"see worksheet 4\",IF(F36=\"fig. 2\",MAX(0.4,'Worksheet 1'!I10/17),\"\")),\"\")","v":""},null,{"$f":"IF(F39=\"\",\"\",IF($F$36=\"fig. 2\",F39*0.75,\"\"))","v":""},{"$nulls":49},2,"B"]
[null,"Fig. 2 / ann. A",null,"Category","C",{"$f":"IF('Worksheet 1'!D8=\"C\",IF(F36=\"annex A\",\"see worksheet 4\",IF(F36=\"fig. 2\",MIN(0.75,'Worksheet 1'!I10/17),\"\")),\"\")","v":""},null,"",{"$nulls":49},3,"C"]
[null,"Fig. 2 / ann. A",null,"Category","D",{"$f":"IF('Worksheet 1'!D8=\"D\",IF(F36=\"annex A\",\"see worksheet 4\",IF(F36=\"fig. 2\",MIN(0.4,'Worksheet 1'!I10/17),\"\")),\"\")","v":""},null,"",{"$nulls":49},4,"D"]
["Actual Downflooding Height hD ",null,null,"Ref. 6.2.2.1"]
["Design Category possible",{"$nulls":4},{"$f":"IF(F36=\"annex A\",'Worksheet 4'!H42,IF(F42>=MAX(F38:G41),'Worksheet 1'!D8,\"Fail\"))","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(F36=\"annex A\",'Worksheet 4'!H42,IF(H42>=MAX(H38:I41),'Worksheet 1'!D8,\"Fail\"))","v":{"v":0,"d":"0.00"}},null,null,"in case of error messages like #NV or no sense entries like 0,00, please check insert design category and choosen option in worksheet one and two"]
["Design Category possible on Downflooding Height = lowest of above",{"$nulls":7},{"$f":"IF((BI38+BK38)>8,\"Fail\",F43)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Worksheet 3a Overview","index":5,"n_rows":56,"n_cols":27,"rows_kept":56,"merged":[[0,13,0,14],[1,0,1,7],[3,0,3,7],[9,8,12,11],[55,0,57,6]]}
[{"$nulls":13},"Comments"]
["ISO 12217-2:2017   CALCULATION WORKSHEET No.3a   DOWNFLOODING OPENINGS / \nCLOSING APPLIANCES",{"$nulls":13},"Derived values"]
[{"$nulls":14},"Input values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[]
["General overview downflooding openings and closing appliances",{"$nulls":25},"list"]
[]
["NOTE: All drawings are not blocked by a password, so please replace with own drawings if at hand."]
["NOTE: See X,Y, Z coordinates for worksheet 3b as illustrated below"]
[{"$nulls":8},"Please drag numbered labels to appropriate position\nPlease use same numbers only for the same opening",{"$nulls":17},"downflooding opening"]
["Top View",{"$nulls":25},"non pre-fabricated closing appliances"]
[{"$nulls":26},"pre-fabricated closing appliances"]
[{"$nulls":26},"seacock"]
[{"$nulls":26},"other devices"]
{"$rows_empty":9}
["Side View Starboard"]
{"$rows_empty":13}
["Side View Port"]
{"$rows_empty":17}
["Please insert a short describtion and measurements of downflooding openings and closing appliances under the corresponding number on worksheet 3b"]

{"sheet":"Worksheet 3b Overview","index":6,"n_rows":35,"n_cols":55,"rows_kept":35,"merged":[[0,10,0,11],[1,0,1,8],[3,0,3,8],[7,0,7,8],[9,0,9,1],[9,7,9,8],[10,0,10,1],[10,7,10,8],[11,0,11,1],[11,7,11,8],[12,0,12,1],[12,7,12,8],[13,0,13,1],[13,7,13,8],[14,0,14,1],[14,7,14,8],[15,0,15,1],[15,7,15,8],[16,0,16,1],[16,7,16,8],[17,0,17,1],[17,7,17,8],[18,0,18,1],[18,7,18,8],[19,0,19,1],[19,7,19,8],[20,0,20,1],[20,7,20,8],[21,0,21,1],[21,7,21,8],[22,0,22,1],[22,7,22,8],[23,0,23,1],[23,7,23,8],[24,0,24,1],[24,7,24,8],[25,0,25,1],[25,7,25,8],[26,0,26,1],[26,7,26,8],[27,0,27,1],[27,7,27,8],[28,0,28,1],[28,7,28,8],[29,0,29,1],[29,7,29,8],[30,0,30,1],[30,7,30,8],[31,0,31,1],[31,7,31,8],[33,0,33,8],[34,0,34,8]]}
[{"$nulls":10},"Comments"]
["ISO 12217-2:2017   CALCULATION WORKSHEET No.3b   DOWNFLOODING OPENINGS",{"$nulls":10},"Derived values"]
[{"$nulls":11},"Input values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[]
["General overview downflooding openings and closing appliances",{"$nulls":26},"list"]
[]
["NOTE: Please submit for every pre-fabricated closing appliance a declaration of conformity (DoC) of the product. \nPlease submit for every non pre-fabricated closing appliance a calculation acc. to ISO 12216 (see IMCI template). \nFor both a watertightness test must be done!"]
[]
["Description of the downflooding opening / \nclosing appliance",null,"Nr.","X(a)\n[m]","Y\n[m]","Z (=hD)\n[m]","watertighness test done?","opening type(b)",{"$nulls":19},"downflooding opening",{"$nulls":25},"number closing appliance",{"$f":"COUNTIF(H11:I32,\"non pre-fabricated closing appliances\")+COUNTIF(H11:I32,\"pre-fabricated closing appliances\")","v":0}]
[null,null,1,{"$nulls":7},"if necessary please submit a picture or a technical drawing of the opening or closing appliance ",{"$nulls":16},"non pre-fabricated closing appliances",{"$nulls":25},"free cells downflooding openings",{"$f":"COUNTIF(A11:A32,\"\")","v":22}]
[null,null,2,{"$nulls":24},"pre-fabricated closing appliances",{"$nulls":25},"number cells watertightness test passed",{"$f":"COUNTIF(G11:G32,\"test passed\")","v":0}]
[null,null,3,{"$nulls":24},"other devices",{"$nulls":25},"Check watertightness",{"$f":"IF(BC12>22-BC11,\"wrong entry\",IF(BC11=22,\"n.a.\",IF(BC12=BC10,\"Pass\",\"Fail\")))","v":"n.a."}]
[null,null,4]
[null,null,5]
[null,null,6]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[null,null,11]
[null,null,12]
[null,null,13]
[null,null,14]
[null,null,15]
[null,null,16]
[null,null,17]
[null,null,18]
[null,null,19]
[null,null,20]
[null,null,21]
[null,null,22]
[]
["(a) Please be aware that X is measured from the aft end of LH. \nIn Annex A calculations xD is measured from the bow or stern, whichever is nearest"]
["(b) opening typs are: normal downflooding openings without any opening appliances; pre-fabricated opening appliances; non-pre-fabricated opening appliances and other devices"]

{"sheet":"Worksheet 4","index":7,"n_rows":42,"n_cols":57,"rows_kept":42,"merged":[[0,13,0,14],[2,0,2,7],[4,0,4,7],[8,0,8,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[14,0,14,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,18,6],[17,7,18,7],[20,0,20,1],[21,0,21,1],[21,4,21,7],[22,0,22,1],[24,2,26,2],[24,3,26,3],[24,4,26,4],[24,5,26,5],[24,6,26,6],[24,7,26,7],[28,4,28,7],[29,4,29,7],[29,9,30,12],[30,4,30,7],[32,2,33,2],[32,3,33,3],[32,4,33,7],[35,0,38,0]]}
[{"$nulls":13},"Comments"]
[{"$nulls":14},"Derived values"]
["ISO 12217-2:2017      CALCULATION WORKSHEET No.4     DOWNFLOODING HEIGHT",{"$nulls":13},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[]
["Calculation using normativ annex A (options 1-3, 5 and 8 only)"]
[]
["Item",null,"Symbol","Unit","Opening \n1","Opening \n2","Opening \n3","Opening \n4"]
["Position of openings"]
["Least longitudinal distance from bow/stern",null,"x","m"]
["Least travers distance from gunwale",null,"y","m"]
["F1 = greater of (1 - x/LH) or (1 - y/BH) ",null,"F1"," ----",{"$f":"IF(E11=\"\",1,MAX(1-E12/'Worksheet 2'!$I$12,1-E11/'Worksheet 1'!$I$10,0.5))","v":{"v":1,"d":"1.00"}},{"$f":"IF(F11=\"\",1,MAX(1-F12/'Worksheet 2'!$I$12,1-F11/'Worksheet 1'!$I$10,0.5))","v":{"v":1,"d":"1.00"}},{"$f":"IF(G11=\"\",1,MAX(1-G12/'Worksheet 2'!$I$12,1-G11/'Worksheet 1'!$I$10,0.5))","v":{"v":1,"d":"1.00"}},{"$f":"IF(H11=\"\",1,MAX(1-H12/'Worksheet 2'!$I$12,1-H11/'Worksheet 1'!$I$10,0.5))","v":{"v":1,"d":"1.00"}}]
["Size of openings:"]
["Combined area of openings to top of any down-flooding opening",null,"a","mm2"]
["Longitudinal distance of opening from tip of bow",null,"x'D","m"]
["Limiting value of a = (30LH)2",null,null,"mm2",{"$f":"(30*'Worksheet 1'!I10)^2","v":0},{"$f":"(30*'Worksheet 1'!I10)^2","v":0},{"$f":"(30*'Worksheet 1'!I10)^2","v":0},{"$f":"(30*'Worksheet 1'!I10)^2","v":0}]
["If a ≥ (30LH)2, F2 = 1,0",null,"F2"," ----",{"$f":"IF(E15=\"\",1,IF(E15>E17,1,1+E16/'Worksheet 1'!$I$10*(SQRT('Worksheet 4'!E15)/75/'Worksheet 1'!$I$10-0.4)))","v":{"v":1,"d":"1.00"}},{"$f":"IF(F15=\"\",1,IF(F15>F17,1,1+F16/'Worksheet 1'!$I$10*(SQRT('Worksheet 4'!F15)/75/'Worksheet 1'!$I$10-0.4)))","v":{"v":1,"d":"1.00"}},{"$f":"IF(G15=\"\",1,IF(G15>G17,1,1+G16/'Worksheet 1'!$I$10*(SQRT('Worksheet 4'!G15)/75/'Worksheet 1'!$I$10-0.4)))","v":{"v":1,"d":"1.00"}},{"$f":"IF(H15=\"\",1,IF(H15>H17,1,1+H16/'Worksheet 1'!$I$10*(SQRT('Worksheet 4'!H15)/75/'Worksheet 1'!$I$10-0.4)))","v":{"v":1,"d":"1.00"}}]
["      If a < (30LH)2, F2 = "]
["Size of recesses:"]
["Volume of recesses which are not self-draining in accordance with ISO 11812",null,"VR","m3"]
["Freeboard amidships (see 3.4.6)",null,"FM","m"]
["Is opening not a recess? Is cockpit quickdraining? Is cockpit not quickdraining?",{"$nulls":50},"list:","opening not a recess"]
["k = VR/(LHBHFM)",null,"k"," ----",{"$f":"IF(OR(E21=\"\",$E$22=\"\"),\"\",E21/'Worksheet 2'!$I$11/'Worksheet 2'!$I$12/$E$22)","v":""},{"$f":"IF(OR(F21=\"\",$E$22=\"\"),\"\",F21/'Worksheet 2'!$I$11/'Worksheet 2'!$I$12/$E$22)","v":""},{"$f":"IF(OR(G21=\"\",$E$22=\"\"),\"\",G21/'Worksheet 2'!$I$11/'Worksheet 2'!$I$12/$E$22)","v":""},{"$f":"IF(OR(H21=\"\",$E$22=\"\"),\"\",H21/'Worksheet 2'!$I$11/'Worksheet 2'!$I$12/$E$22)","v":""},{"$nulls":44},"quick- draining"]
["If opening is not a recess,","F3 = 1","F3"," ----",{"$f":"IF(E23=\"quick- draining\",0.7,IF(E23=\"not quick- draining\",MIN(1.2,0.7+E24^0.5),IF(E23=\"\",1.2,1)))","v":{"v":1.2,"d":"1.20"}},{"$f":"IF(F23=\"quick- draining\",0.7,IF(F23=\"not quick- draining\",MIN(1.2,0.7+F24^0.5),IF(F23=\"\",1.2,1)))","v":{"v":1.2,"d":"1.20"}},{"$f":"IF(G23=\"quick- draining\",0.7,IF(G23=\"not quick- draining\",MIN(1.2,0.7+G24^0.5),IF(G23=\"\",1.2,1)))","v":{"v":1.2,"d":"1.20"}},{"v":1.2,"d":"1.20"},{"$nulls":44},"not quick- draining"]
["If recess is quickdraining,     ","F3 = 0.7"]
["If recess is not quick draining,","F3 = (0.7 + k0.5)",{"$nulls":11},"F3 is the recess size factor, greater than 0,7 but never to be taken as greater than 1,2:\n\n "]
["Displacement:"]
["Loaded displacement volume (see 3.5.7)",null,"VD","m3",{"$f":"'Worksheet 1'!I35/1025","v":{"v":0,"d":"0.00"}}]
["B =  BWL for multihulls",null,"BWL","m",{"$nulls":5},"!! Attention !! BWL is the sum of the maximum waterline beams of\neach of the hulls."]
["F4 = [(10 VD)/(LH B2)]1/3",null,"F4"," ----",{"$f":"(10*E29/('Worksheet 1'!I10*'Worksheet 4'!E30*'Worksheet 4'!E30))^(1/3)","v":{"$error":"#DIV/0!"}}]
["Flotation:"]
["For boats using option 4 or 6, F5 = 0.8",null,"F5"," ----",{"$f":"IF('Worksheet 2'!E47=4,0.8,IF('Worksheet 2'!E47=6,0.8,1))","v":1}]
["For all other boats,                F5 = 1.0",{"$nulls":51},"sAbfragetabelle"]
["Required calculation height: = F1F2F3F4F5LH/15",null,"hD(R)","m",{"$f":"IF(OR('Worksheet 1'!$D$8=\"A\",'Worksheet 1'!$D$8=\"B\"),MIN(E13*E18*E25*$E$31*$E$33*'Worksheet 1'!$I$10/15,1.41),IF('Worksheet 1'!$D$8=\"C\",MIN(E13*E18*E25*$E$31*$E$33*'Worksheet 1'!$I$10/15,0.75),IF('Worksheet 1'!$D$8=\"D\",MIN(E13*E18*E25*$E$31*$E$33*'Worksheet 1'!$I$10/15,0.4),\"\")))","v":""},{"$f":"IF(OR('Worksheet 1'!$D$8=\"A\",'Worksheet 1'!$D$8=\"B\"),MIN(F13*F18*F25*$E$31*$E$33*'Worksheet 1'!$I$10/15,1.41),IF('Worksheet 1'!$D$8=\"C\",MIN(F13*F18*F25*$E$31*$E$33*'Worksheet 1'!$I$10/15,0.75),IF('Worksheet 1'!$D$8=\"D\",MIN(F13*F18*F25*$E$31*$E$33*'Worksheet 1'!$I$10/15,0.4),\"\")))","v":""},{"$f":"IF(OR('Worksheet 1'!$D$8=\"A\",'Worksheet 1'!$D$8=\"B\"),MIN(G13*G18*G25*$E$31*$E$33*'Worksheet 1'!$I$10/15,1.41),IF('Worksheet 1'!$D$8=\"C\",MIN(G13*G18*G25*$E$31*$E$33*'Worksheet 1'!$I$10/15,0.75),IF('Worksheet 1'!$D$8=\"D\",MIN(G13*G18*G25*$E$31*$E$33*'Worksheet 1'!$I$10/15,0.4),\"\")))","v":""},{"$f":"IF(OR('Worksheet 1'!$D$8=\"A\",'Worksheet 1'!$D$8=\"B\"),MIN(H13*H18*H25*$E$31*$E$33*'Worksheet 1'!$I$10/15,1.41),IF('Worksheet 1'!$D$8=\"C\",MIN(H13*H18*H25*$E$31*$E$33*'Worksheet 1'!$I$10/15,0.75),IF('Worksheet 1'!$D$8=\"D\",MIN(H13*H18*H25*$E$31*$E$33*'Worksheet 1'!$I$10/15,0.4),\"\")))","v":""},null,"limited to max value row 2 table A.1",{"$nulls":3},"Table A.1 — Limits on required downflooding height",{"$nulls":38},"Table A.1 — Limits on required downflooding height"]
["Required downfooding height with limits applied\n(see annex A, Table A.1)","Category A","hD(R)","m",{"$f":"IF('Worksheet 1'!$D$8=\"A\",0.5,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"A\",0.5,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"A\",0.5,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"A\",0.5,\"\")","v":""},{"$nulls":5},"Design category","A","B","C","D",{"$nulls":32},{"$f":"MAX(E35:E39)","v":{"v":0,"d":"0.00"}},null,"Design category","A","B","C","D"]
[null,"Category B","hD(R)","m",{"$f":"IF('Worksheet 1'!$D$8=\"B\",0.4,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"B\",0.4,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"B\",0.4,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"B\",0.4,\"\")","v":""}]
[null,"Category C","hD(R)","m",{"$f":"IF('Worksheet 1'!$D$8=\"C\",0.3,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"C\",0.3,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"C\",0.3,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"C\",0.3,\"\")","v":""},{"$nulls":5},"hD(R)shall be not less than",0.5,0.4,0.3,0.2,{"$nulls":34},"hD(R)shall be not less than",0.5,0.4,0.4,0.3]
[null,"Category D","hD(R)","m",{"$f":"IF('Worksheet 1'!$D$8=\"D\",0.2,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"D\",0.2,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"D\",0.2,\"\")","v":""},{"$f":"IF('Worksheet 1'!$D$8=\"D\",0.2,\"\")","v":""},{"$nulls":5},"hD(R)shall be not more than",1.41,1.41,0.75,0.4,{"$nulls":34},"hD(R)shall be not more than",1.41,1.41,1.41,0.75]
["Measured Downflooding Height:",null,"hD","m"]
[{"$nulls":3},"Design Category possible:",{"$f":"IF(E40=\"\",\"\",IF(E40>MAX(E35:E39),'Worksheet 1'!$D$8,\"Fail\"))","v":""},{"$f":"IF(F40=\"\",\"\",IF(F40>MAX(F35:F39),'Worksheet 1'!$D$8,\"Fail\"))","v":""},{"$f":"IF(G40=\"\",\"\",IF(G40>MAX(G35:G39),'Worksheet 1'!$D$8,\"Fail\"))","v":""},{"$f":"IF(H40=\"\",\"\",IF(H40>MAX(H35:H39),'Worksheet 1'!$D$8,\"Fail\"))","v":""}]
[{"$nulls":6},"Lowest of above = ",{"$f":"IF(BA42>0,\"Fail\",'Worksheet 1'!D8)","v":"Fail"},{"$nulls":44},{"$f":"IF(E40=\"\",\"\",COUNTIF(E41:H41,\"Fail\"))","v":""}]

{"sheet":"Worksheet 5","index":8,"n_rows":93,"n_cols":53,"rows_kept":93,"merged":[[0,8,0,9],[2,0,2,6],[4,0,4,6],[6,2,6,6],[9,0,9,1],[9,2,9,3],[9,4,9,5],[10,0,11,1],[10,2,11,3],[10,4,11,5],[10,6,11,6],[12,0,13,1],[12,2,13,3],[12,4,13,5],[12,6,13,6],[14,0,14,1],[14,2,14,3],[14,4,14,5],[15,2,15,3],[15,4,15,5],[16,0,16,1],[16,2,16,3],[16,4,16,5],[17,0,17,1],[17,2,18,3],[17,4,18,5],[17,6,18,6],[18,0,18,1],[19,0,19,1],[19,2,19,3],[19,4,19,5],[20,0,20,1],[20,2,20,3],[20,4,20,5],[21,0,21,1],[21,2,21,3],[21,4,21,5],[23,1,23,3],[27,0,28,0],[27,1,28,1],[27,2,28,3],[27,4,27,5],[27,6,28,6],[28,4,28,5],[29,0,29,6],[30,2,30,3],[30,4,30,5],[30,52,31,52],[31,2,31,3],[31,4,31,5],[32,2,32,3],[32,4,32,5],[32,52,33,52],[33,2,33,3],[33,4,33,5],[34,2,34,3],[34,4,34,5],[34,52,35,52],[35,2,35,3],[35,4,35,5],[36,2,36,3],[36,4,36,5],[38,0,38,6],[38,8,38,16],[39,8,39,16],[54,1,55,1],[54,2,55,3],[54,4,54,5],[54,6,55,6],[54,13,54,14],[55,4,55,5],[56,1,57,1],[56,2,57,3],[56,4,57,5],[56,6,57,6],[58,0,58,2],[58,3,59,3],[58,4,59,5],[58,6,59,6],[59,0,59,2],[60,0,60,2],[60,3,61,3],[60,4,61,5],[60,6,61,6],[61,0,61,2],[62,0,62,2],[62,3,63,3],[62,4,63,5],[62,6,63,6],[63,0,63,2],[65,0,65,3],[65,4,65,5],[66,0,66,3],[66,4,66,5],[67,1,67,2],[67,4,67,5],[68,1,68,2],[68,4,68,5],[69,0,69,3],[69,4,71,5],[69,6,71,6],[70,0,70,3],[71,0,71,3],[72,0,72,3],[72,4,72,5],[73,1,73,2],[73,4,73,5],[74,1,74,2],[74,4,74,5],[75,0,75,3],[75,4,77,5],[75,6,77,6],[76,0,76,3],[77,0,77,3],[78,0,78,3],[78,4,78,5],[79,0,80,1],[79,2,80,2],[79,3,80,3],[79,4,80,5],[79,6,80,6],[81,0,82,1],[81,2,82,2],[81,3,82,3],[81,4,82,5],[81,6,82,6],[83,0,84,3],[83,4,84,5],[83,6,84,6],[86,0,86,3],[86,4,86,5],[88,0,88,3],[88,4,88,5],[89,0,89,3],[89,4,89,5],[90,0,90,2],[90,4,90,5],[91,0,91,2],[91,4,91,5],[92,0,92,3],[92,4,92,5]]}
[{"$nulls":8},"Comments"]
[{"$nulls":9},"Derived values"]
["ISO 12217-2:2017  CALCULATION WORKSHEET No. 5        RECESS SIZE                              ",{"$nulls":8},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[]
["NB: This sheet is to be completed for the Loaded Arrival Condition.",null,{"$f":"IF(AND('Worksheet 2'!E47=8,'Worksheet 1'!D8=\"D\"),\"calculation not applicable\",IF(AND('Worksheet 2'!E47=8,'Worksheet 1'!D8=\"C\",'Worksheet 2'!I8=\"No\"), \"calculation not applicable\",IF('Worksheet 2'!E47=\"\",\"\",\"calculation required\")))","v":"calculation required"},{"$nulls":5},"for option 8: This requirement only applies to boats of design category A,B and cat C boats which are fully enclosed."]
[]
["Further exemptions according to 6.5.1"]
["Angle of vanishing stability > 90° ?                                               ",null,"YES/NO",{"$nulls":3},"6.3.1a)",{"$nulls":45},"list:"]
["Over at least 35% of the periphery is the depth of the recess less than 3% of the max. breadth of the recess (e.g. toe rails, low bulwarks)",null,"YES/NO",{"$nulls":3},"6.3.1b)",{"$nulls":45},"Yes"]
[{"$nulls":52},"No"]
["At least 5% of the bulwark area positioned within the lowest 25% of the bulwark height drains overboard and the bulwark height is less than 12,5% of the  maximum breadth of the recess\n(attention, req. 1) and 2) below must get also a \"Yes\" to fullfill all requirements)",null,"YES/NO",{"$nulls":3},"6.3.1c)"]
[{"$nulls":52},"lowest 25%"]
["Unobstructed drainage area from the recess on each side of the boat centreline",null,"m²",{"$nulls":3},"6.3.1d)",{"$nulls":45},"lowest 50%"]
["Volume of the recess to the recess retention level",null,"m³",{"$nulls":49},"full depth"]
["Drainage area per side (m²) divided by recess volume (m³)",{"$nulls":3},{"$f":"IF(OR(E15=\"\",E16=\"\"),\"\",E15/E16)","v":""},null,"6.3.1d)",null,"meets requirements if result is >",null,"0,09 where the drainage openings are within the lowest 25 % of the recess depth"]
["Height position of drainage area ",{"$nulls":5},"6.3.1d)",{"$nulls":3},"0,16 where the drainage openings are within the lowest 50 % of the recess depth"]
["(lowest 25% / lowest 50% / full depth)",{"$nulls":9},"0,30 where the drainage openings are the full depth of the recess"]
["Requirements of 6.3.1.d) fullfilled? (attention, req. 1) and 2) below must get also a \"Yes\")",null,"YES/NO",null,{"$f":"IF(E17=\"\",\"\",IF(AND(E18=\"lowest 25%\",E17>0.09),\"yes\",IF(AND(E18=\"lowest 50%\",E17>0.16),\"Yes\",IF(AND(E18=\"full depth\",E17>0.3),\"Yes\",\"No\"))))","v":""},null,"6.3.1d)",null,"AND if req 1) and req 2) of 6.3.1 are fulfilled"]
["1) the lower edge of the drainage openings are not more than 10 mm above recess sole\nheight for at least 70 % of the width of each opening?",null,"YES/NO",{"$nulls":3},"6.3.1 c) & d)"]
["2) If drainage area is provided by an open or partially open transom, are the openings extend to the outboard sides of the recess sole on both sides?",null,"YES/NO",{"$nulls":3},"6.3.1 c) & d)"]
[]
["Is recess exempt from size limit?     If \"yes\", no further calculation required.",{"$f":"IF(C7=\"\",\"\",IF(C7=\"calculation not applicable\",\"\",IF(OR(E10=\"Yes\",E11=\"Yes\",AND(E13=\"Yes\",E21=\"Yes\",E22=\"Yes\"),AND(E20=\"Yes\",E21=\"Yes\",E22=\"Yes\")),\"Yes\",\"calculation required\")))","v":"calculation required"},{"$nulls":4},"6.3.1"]
[]
[]
["Calculation methods:"]
["Item","Symbol","Unit",null,"Value",null,"Ref."]
[{"$nulls":4},{"$f":"CONCATENATE(E9,F9)","v":""}]
["SIMPLIFIED METHOD: Use 1), 2) or 3) below."]
["Average freeboard to loaded waterline at aft end of recess","FA","m",{"$nulls":3},"6.3.2.1",{"$nulls":45},"A"]
["Average freeboard to loaded waterline at sides of recess","FS","m",{"$nulls":3},"6.3.2.1"]
["Average freeboard to loaded waterline at forward end of recess","FF","m",{"$nulls":3},"6.3.2.1",{"$nulls":45},"B"]
["Waterline length at mLA","LWL","m"]
["Maximum beam waterline at mLA","BWL max","m",{"$nulls":3},"ISO 8666 4.3.5",null,"!! Attention, please don't use the BWL value (which is the sum of the waterline of each hull)",{"$nulls":43},"C"]
["Maximum length of recess at the retention level (see 3.5.11)","l","m",{"$nulls":3},"6.3.2.4",null,"length of the recess to be measured in length direction of the boat! See drawing below also."]
["Maximum breadth of recess at the retention level (see 3.5.11)","b","m",{"$nulls":3},"6.3.2.4",null,"breadth of the recess to be measured in the direction of the width of the boat! See drawing."]
[]
[" - In case of assymetric recesses (e.g. bowrider, centercockpits,….), please insert length and breadth of each area below; this allows a more exact calculation using simplified method 1) or 2)",{"$nulls":7},"In case of assymetric recesses (see example) calculating with max beam and max length of the recess is giving adverse results."]
[null,"max. length","max. breadth","Unit","% loss GMT\n(method 1)","% loss GMT\n(method 2)","Ref.",null,"In this case using method 1) or 2) one can calculate the calculated percentage loss in metacentric height for every single part of the recess and add the results. Please be aware that this way of calculation is NOT possible for method 3) !"]
["Maximum length and breadth of recess part A",null,null,"m",{"$f":"IF($E$69=\"\",\"\",IF(B41=\"\",\"\",IF(C41=\"\",\"\",102500*B41*C41^3/12/$E$69/'Worksheet 1'!$I$37)))","v":""},{"$f":"IF(OR(B41=\"\",C41=\"\"),\"\",(B41*C41^3/12)*245/$E$75)","v":""},"6.3.2.2/3"]
["Maximum length and breadth of recess part B",null,null,"m",{"$f":"IF($E$69=\"\",\"\",IF(B42=\"\",\"\",IF(C42=\"\",\"\",102500*B42*C42^3/12/$E$69/'Worksheet 1'!$I$37)))","v":""},{"$f":"IF(OR(B42=\"\",C42=\"\"),\"\",(B42*C42^3/12)*245/$E$75)","v":""},"6.3.2.2/3"]
["Maximum length and breadth of recess part C",null,null,"m",{"$f":"IF($E$69=\"\",\"\",IF(B43=\"\",\"\",IF(C43=\"\",\"\",102500*B43*C43^3/12/$E$69/'Worksheet 1'!$I$37)))","v":""},"","6.3.2.2/3"]
["Maximum length and breadth of recess part D",null,null,"m",{"$f":"IF($E$69=\"\",\"\",IF(B44=\"\",\"\",IF(C44=\"\",\"\",102500*B44*C44^3/12/$E$69/'Worksheet 1'!$I$37)))","v":""},"","6.3.2.2/3"]
["Maximum length and breadth of recess part E",null,null,"m",{"$f":"IF($E$69=\"\",\"\",IF(B45=\"\",\"\",IF(C45=\"\",\"\",102500*B45*C45^3/12/$E$69/'Worksheet 1'!$I$37)))","v":""},"","6.3.2.2/3"]
["Maximum length and breadth of recess part F",null,null,"m",{"$f":"IF($E$69=\"\",\"\",IF(B46=\"\",\"\",IF(C46=\"\",\"\",102500*B46*C46^3/12/$E$69/'Worksheet 1'!$I$37)))","v":""},"","6.3.2.2/3"]
["Maximum length and breadth of recess part G",null,null,"m",{"$f":"IF($E$69=\"\",\"\",IF(B47=\"\",\"\",IF(C47=\"\",\"\",102500*B47*C47^3/12/$E$69/'Worksheet 1'!$I$37)))","v":""},"","6.3.2.2/3"]
["Maximum length and breadth of recess part H",null,null,"m",{"$f":"IF($E$69=\"\",\"\",IF(B48=\"\",\"\",IF(C48=\"\",\"\",102500*B48*C48^3/12/$E$69/'Worksheet 1'!$I$37)))","v":""},"","6.3.2.2/3"]
["Maximum length and breadth of recess part I",null,null,"m",{"$f":"IF($E$69=\"\",\"\",IF(B49=\"\",\"\",IF(C49=\"\",\"\",102500*B49*C49^3/12/$E$69/'Worksheet 1'!$I$37)))","v":""},"","6.3.2.2/3",null,"e.g. simplified recess areas (with side decks, …)"]
["to be continued on page 2"]
[]
[]
[]
["page 2"]
[null,"Symbol","Unit",null,"Value",null,"Ref."]
[{"$nulls":4},{"$f":"CONCATENATE(E9,F9)","v":""}]
["Average freeboard to recess periphery ","FR","m",null,{"$f":"(E31+E32*2+E33)/4","v":0},null,"6.3.2.1"]
["= (FA + 2FS + FF) / 4"]
["Category A permitted percentage loss in metacentric height ",{"$nulls":3},{"$f":"IF('Worksheet 1'!D8=\"A\",250*E57/'Worksheet 1'!I10,\"n.a.\")","v":"n.a."},null,"6.3.2.1"]
["(GMT) = 250 FR / LH"]
["Category B permitted percentage loss in metacentric height ",{"$nulls":3},{"$f":"IF('Worksheet 1'!D8=\"B\",550*E57/'Worksheet 1'!I10,\"n.a.\")","v":"n.a."},null,"6.3.2.1"]
["(GMT) = 550 FR / LH"]
["Category C permitted percentage loss in metacentric height ",{"$nulls":3},{"$f":"IF('Worksheet 1'!D8=\"C\",1200*E57/'Worksheet 1'!I10,\"n.a.\")","v":"n.a."},null,"6.3.2.1"]
["(GMT) = 1 200 FR / LH"]
[]
["SIMPLIFIED METHOD: Use 1), 2) or 3) below.",{"$nulls":3},{"$f":"CONCATENATE(E9,F9)","v":""}]
["1) Loss of GMT used?    ",{"$nulls":5},"6.3.2.2"]
["Second moment of area of free-surface of recess ","SMARECESS",null,"m4",{"$f":"IF(AND(B41<>\"\",C41<>\"\"),\"Calc of different areas\",E80*E82^3/12)","v":0},null,"6.3.2.2"]
["Metacentric height of boat at mLA","GMT",null,"m",null,null,"6.3.2.2",null,"SMARECESS = l * b³ / 12",null,null,"theor.:"]
[{"$nulls":4},{"$f":"IF(AND(B41<>\"\",C41<>\"\"),SUM(E41:E49),IF(E69=\"\",\"\",IF(E80=\"\",\"\",IF(E82=\"\",\"\",102500*E68/E69/'Worksheet 1'!I37))))","v":""},null,"6.3.2.2"]
["Calculated percentage loss in metacentric height                                                (GMT) = "]
[]
["2) Second moment of areas used?         ",{"$nulls":5},"6.3.2.3"]
["Second moment of area of free-surface of recess ","SMARECESS",null,"m4",{"$f":"IF(AND(B41<>\"\",C41<>\"\"),\"Calc of different areas\",E80*E82^3/12)","v":0},null,"6.3.2.3"]
["Second moment of area of waterplane of boat at mLA","SMAWP",null,"m4",{"$f":"E34*E35^3/M77","v":0},null,"6.3.2.3"]
[{"$nulls":4},{"$f":"IF(OR(E34=\"\",E35=\"\"),\"\",IF(AND(B41<>\"\",C41<>\"\"),SUM(F41:F49),IF(E36=\"\",\"\",IF(E37=\"\",\"\",245*E74/E75))))","v":""},null,"6.3.2.3",null,"SMAWP = LWL * BWLmax³ / k",null,null,"where k should be between 13 and 18 for Multihulls (to be discussed with the ISO 12217 stability group)"]
["Calculated percentage loss in metacentric height                                            (GMT) = ",{"$nulls":10},"k = ",17]
[]
["3) Recess dimensions used?   ",{"$nulls":5},"6.3.2.1*",null,"*6.3.2.1 excludes this method for multihulls"]
["Maximum length of recess at the retention level (see 3.6.11)",null,"l","m",{"$f":"E36","v":0},null,"6.3.2.4"]
[]
["Maximum breadth of recess at the retention level (see 3.6.11)",null,"b","m",{"$f":"E37","v":0},null,"6.3.2.4"]
[]
["Calculated percentage loss in metacentric height                                                        (GMT) = ",{"$nulls":3},{"$f":"IF(OR(E36=\"\",E37=\"\"),\"\",IF('Worksheet 1'!I10=\"\",\"\",IF('Worksheet 2'!I12=\"\",\"\",270*(E80*E82^3/'Worksheet 1'!I10/'Worksheet 2'!I12^3)^0.7)))","v":""},null,"6.3.2.4"]
[]
[]
["Requirement: from results above, applied design category possible?",{"$nulls":3},{"$f":"IF(OR(C7=\"\",C7=\"calculation not applicable\"),\"n.a.\",IF(OR(E76<MAX(E59:F64),E70<MAX(E59:F64)),\"Yes\",\"Fail\"))","v":"Fail"},null,"6.3.2.1"]
[]
["DIRECT CALCULATION METHOD used? ",{"$nulls":5},"6.3.3"]
["Percentage full of water = 60 – 240 F/LH",{"$nulls":3},{"$f":"IF('Worksheet 1'!I10=\"\",\"\",IF(E31=\"\",\"\",60-240*MIN(E31:F33)/'Worksheet 1'!I10))","v":""},null,"6.3.3a)"]
["Actual residual righting moment up to ϕD, ϕV or 90° whichever is least",null,null,"N∙m",null,null,"6.3.3b)"]
["Required residual righting moment up to ϕD, ϕV or 90° whichever is least",null,null,"N∙m",{"$f":"IF('Worksheet 1'!D8=\"A\",3.6*'Worksheet 1'!I37,IF('Worksheet 1'!D8=\"B\",2.6*'Worksheet 1'!I37,2.1*'Worksheet 1'!I37))","v":0},null,"6.3.3b)"]
["Striven design category possible ?",{"$nulls":3},{"$f":"IF(E91>E92,\"Yes\",\"no\")","v":"no"},{"$nulls":10},"l"]

{"sheet":"Worksheet 6a","index":9,"n_rows":186,"n_cols":62,"rows_kept":186,"merged":[[0,14,0,15],[2,0,2,10],[4,0,4,10],[175,0,175,1],[175,3,175,4],[176,0,176,1],[176,3,176,4]]}
[{"$nulls":14},"Comments"]
[{"$nulls":15},"Derived values"]
["ISO 12217-2:2017   CALCULATION WORKSHEET No. 6a    curve of righting moment mMO",{"$nulls":14},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[{"$nulls":48},"list:"]
["insert curve of righting moment in 5° steps in one of following units:",{"$nulls":47},"MW1"]
[null,"N m","kg m","m",{"$nulls":44},"MW2"]
[]
["chosen unit"]
[]
[]
["heeling angle[°]","insert Heeling Arm/Moment [Nm, kg m, m]","Heeling Moment [Nm]","Heeling Moment \n[kg m]","Arm Gz \n[m]","Diff(B-A/5)","Basis",{"$nulls":46},"heeling angle[°]","Arm\n[m]","Check > 0",null,"Flächenberechnung",null,null,"Arm [m]"]
[0,null,{"$f":"D14*9.806","v":{"$error":"#VALUE!"}},{"$f":"E14*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B14/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B14/'Worksheet 1'!$I$44,IF($B$10=\"m\",B14,\"error\")))","v":"error"},{"$f":"(E19-E14)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},0,{"$f":"E14","v":"error"},{"$f":"IF(BC14>=0,\"X\",\"\")","v":"X"},{"$f":"IF(AND(BD14=\"X\",BD15=\"\"),BB14,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(BB14<=$BC$177,BD14=\"X\"),E14,\"\")","v":{"$error":"#VALUE!"}},null,0,{"$f":"IF(E14>=0,E14,\"\")","v":"error"},{"$f":"IF(BI14>=0,\"X\",\"\")","v":"X"}]
[1,null,{"$error":"#VALUE!"},{"$f":"E15*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E14+F14","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},1,{"$error":"#VALUE!"},{"$f":"IF(BC15>0,\"X\",\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(AND(BB15<=$BC$177,BD15=\"X\"),E15,\"\")","v":{"$error":"#VALUE!"}},null,1,{"$f":"IF(E15>=0,E15,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[2,null,{"$error":"#VALUE!"},{"$f":"E16*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E15+F14","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,2,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[3,null,{"$error":"#VALUE!"},{"$f":"E17*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E16+F14","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,null,{"$error":"#VALUE!"},{"$f":"E18*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E17+F14","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,null,{"$error":"#VALUE!"},{"$f":"E19*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B19/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B19/'Worksheet 1'!$I$44,IF($B$10=\"m\",B19,\"error\")))","v":"error"},{"$f":"(E24-E19)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},5,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,5,"error","X"]
[6,null,{"$error":"#VALUE!"},{"$f":"E20*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E19+F19","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},6,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,6,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[7,null,{"$error":"#VALUE!"},{"$f":"E21*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E20+F19","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},7,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[8,null,{"$error":"#VALUE!"},{"$f":"E22*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E21+F19","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},8,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,8,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[9,null,{"$error":"#VALUE!"},{"$f":"E23*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E22+F19","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},9,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,9,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[10,null,{"$error":"#VALUE!"},{"$f":"E24*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B24/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B24/'Worksheet 1'!$I$44,IF($B$10=\"m\",B24,\"error\")))","v":"error"},{"$f":"(E29-E24)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},10,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,10,"error","X"]
[11,null,{"$error":"#VALUE!"},{"$f":"E25*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E24+F24","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},11,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,11,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[12,null,{"$error":"#VALUE!"},{"$f":"E26*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E25+F24","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},12,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,12,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[13,null,{"$error":"#VALUE!"},{"$f":"E27*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E26+F24","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},13,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,13,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[14,null,{"$error":"#VALUE!"},{"$f":"E28*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E27+F24","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},14,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,14,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[15,null,{"$error":"#VALUE!"},{"$f":"E29*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B29/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B29/'Worksheet 1'!$I$44,IF($B$10=\"m\",B29,\"error\")))","v":"error"},{"$f":"(E34-E29)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},15,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,15,"error","X"]
[16,null,{"$error":"#VALUE!"},{"$f":"E30*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E29+F29","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},16,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,16,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[17,null,{"$error":"#VALUE!"},{"$f":"E31*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E30+F29","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},17,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,17,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[18,null,{"$error":"#VALUE!"},{"$f":"E32*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E31+F29","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},18,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,18,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[19,null,{"$error":"#VALUE!"},{"$f":"E33*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E32+F29","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},19,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,19,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[20,null,{"$error":"#VALUE!"},{"$f":"E34*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B34/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B34/'Worksheet 1'!$I$44,IF($B$10=\"m\",B34,\"error\")))","v":"error"},{"$f":"(E39-E34)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},20,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,20,"error","X"]
[21,null,{"$error":"#VALUE!"},{"$f":"E35*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E34+F34","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},21,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,21,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[22,null,{"$error":"#VALUE!"},{"$f":"E36*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E35+F34","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},22,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,22,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[23,null,{"$error":"#VALUE!"},{"$f":"E37*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E36+F34","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},23,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,23,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[24,null,{"$error":"#VALUE!"},{"$f":"E38*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E37+F34","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},24,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,24,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[25,null,{"$error":"#VALUE!"},{"$f":"E39*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B39/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B39/'Worksheet 1'!$I$44,IF($B$10=\"m\",B39,\"error\")))","v":"error"},{"$f":"(E44-E39)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},25,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,25,"error","X"]
[26,null,{"$error":"#VALUE!"},{"$f":"E40*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E39+F39","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},26,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,26,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[27,null,{"$error":"#VALUE!"},{"$f":"E41*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E40+F39","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},27,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,27,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[28,null,{"$error":"#VALUE!"},{"$f":"E42*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E41+F39","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[29,null,{"$error":"#VALUE!"},{"$f":"E43*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E42+F39","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},29,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,29,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[30,null,{"$error":"#VALUE!"},{"$f":"E44*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B44/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B44/'Worksheet 1'!$I$44,IF($B$10=\"m\",B44,\"error\")))","v":"error"},{"$f":"(E49-E44)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},30,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,30,"error","X"]
[31,null,{"$error":"#VALUE!"},{"$f":"E45*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E44+F44","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[32,null,{"$error":"#VALUE!"},{"$f":"E46*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E45+F44","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},32,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,32,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[33,null,{"$error":"#VALUE!"},{"$f":"E47*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E46+F44","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},33,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,33,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[34,null,{"$error":"#VALUE!"},{"$f":"E48*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E47+F44","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},34,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,34,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[35,null,{"$error":"#VALUE!"},{"$f":"E49*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B49/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B49/'Worksheet 1'!$I$44,IF($B$10=\"m\",B49,\"error\")))","v":"error"},{"$f":"(E54-E49)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},35,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,35,"error","X"]
[36,null,{"$error":"#VALUE!"},{"$f":"E50*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E49+F49","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},36,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,36,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[37,null,{"$error":"#VALUE!"},{"$f":"E51*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E50+F49","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},37,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,37,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[38,null,{"$error":"#VALUE!"},{"$f":"E52*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E51+F49","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},38,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,38,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[39,null,{"$error":"#VALUE!"},{"$f":"E53*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E52+F49","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},39,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,39,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[40,null,{"$error":"#VALUE!"},{"$f":"E54*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B54/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B54/'Worksheet 1'!$I$44,IF($B$10=\"m\",B54,\"error\")))","v":"error"},{"$f":"(E59-E54)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},40,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,40,"error","X"]
[41,null,{"$error":"#VALUE!"},{"$f":"E55*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E54+F54","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},41,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,41,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[42,null,{"$error":"#VALUE!"},{"$f":"E56*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E55+F54","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},42,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,42,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[43,null,{"$error":"#VALUE!"},{"$f":"E57*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E56+F54","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},43,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,43,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[44,null,{"$error":"#VALUE!"},{"$f":"E58*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E57+F54","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},44,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,44,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[45,null,{"$error":"#VALUE!"},{"$f":"E59*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B59/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B59/'Worksheet 1'!$I$44,IF($B$10=\"m\",B59,\"error\")))","v":"error"},{"$f":"(E64-E59)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},45,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,45,"error","X"]
[46,null,{"$error":"#VALUE!"},{"$f":"E60*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E59+F59","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},46,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,46,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[47,null,{"$error":"#VALUE!"},{"$f":"E61*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E60+F59","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},47,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,47,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[48,null,{"$error":"#VALUE!"},{"$f":"E62*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E61+F59","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},48,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,48,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[49,null,{"$error":"#VALUE!"},{"$f":"E63*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E62+F59","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},49,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,49,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[50,null,{"$error":"#VALUE!"},{"$f":"E64*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B64/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B64/'Worksheet 1'!$I$44,IF($B$10=\"m\",B64,\"error\")))","v":"error"},{"$f":"(E69-E64)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},50,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,50,"error","X"]
[51,null,{"$error":"#VALUE!"},{"$f":"E65*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E64+F64","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},51,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,51,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[52,null,{"$error":"#VALUE!"},{"$f":"E66*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E65+F64","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},52,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,52,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[53,null,{"$error":"#VALUE!"},{"$f":"E67*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E66+F64","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},53,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,53,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[54,null,{"$error":"#VALUE!"},{"$f":"E68*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E67+F64","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},54,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,54,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[55,null,{"$error":"#VALUE!"},{"$f":"E69*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B69/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B69/'Worksheet 1'!$I$44,IF($B$10=\"m\",B69,\"error\")))","v":"error"},{"$f":"(E74-E69)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},55,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,55,"error","X"]
[56,null,{"$error":"#VALUE!"},{"$f":"E70*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E69+F69","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},56,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,56,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[57,null,{"$error":"#VALUE!"},{"$f":"E71*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E70+F69","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},57,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,57,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[58,null,{"$error":"#VALUE!"},{"$f":"E72*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E71+F69","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},58,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,58,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[59,null,{"$error":"#VALUE!"},{"$f":"E73*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E72+F69","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},59,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,59,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[60,null,{"$error":"#VALUE!"},{"$f":"E74*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B74/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B74/'Worksheet 1'!$I$44,IF($B$10=\"m\",B74,\"error\")))","v":"error"},{"$f":"(E79-E74)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},60,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,60,"error","X"]
[61,null,{"$error":"#VALUE!"},{"$f":"E75*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E74+F74","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},61,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,61,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[62,null,{"$error":"#VALUE!"},{"$f":"E76*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E75+F74","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},62,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,62,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[63,null,{"$error":"#VALUE!"},{"$f":"E77*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E76+F74","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},63,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,63,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[64,null,{"$f":"D78*9.806","v":{"$error":"#VALUE!"}},{"$f":"E78*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E77+F74","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},64,{"$f":"E78","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(AND(BD78=\"X\",BD79=\"\"),BB78,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,64,{"$error":"#VALUE!"},{"$f":"IF(BI78>=0,\"X\",\"\")","v":{"$error":"#VALUE!"}}]
[65,null,{"$error":"#VALUE!"},{"$f":"E79*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B79/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B79/'Worksheet 1'!$I$44,IF($B$10=\"m\",B79,\"error\")))","v":"error"},{"$f":"(E84-E79)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},65,"error",{"$f":"IF(BC79>0,\"X\",\"\")","v":"X"},{"$error":"#VALUE!"},{"$f":"IF(AND(BB79<=$BC$177,BD79=\"X\"),E79,\"\")","v":{"$error":"#VALUE!"}},null,65,{"$f":"IF(E79>=0,E79,\"\")","v":"error"},"X"]
[66,null,{"$error":"#VALUE!"},{"$f":"E80*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E79+F79","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},66,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,66,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[67,null,{"$error":"#VALUE!"},{"$f":"E81*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E80+F79","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},67,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,67,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[68,null,{"$error":"#VALUE!"},{"$f":"E82*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E81+F79","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},68,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,68,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[69,null,{"$error":"#VALUE!"},{"$f":"E83*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E82+F79","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},69,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,69,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[70,null,{"$error":"#VALUE!"},{"$f":"E84*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B84/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B84/'Worksheet 1'!$I$44,IF($B$10=\"m\",B84,\"error\")))","v":"error"},{"$f":"(E89-E84)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},70,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,70,"error","X"]
[71,null,{"$error":"#VALUE!"},{"$f":"E85*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E84+F84","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},71,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,71,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[72,null,{"$error":"#VALUE!"},{"$f":"E86*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E85+F84","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},72,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,72,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[73,null,{"$error":"#VALUE!"},{"$f":"E87*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E86+F84","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},73,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,73,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[74,null,{"$error":"#VALUE!"},{"$f":"E88*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E87+F84","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},74,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,74,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[75,null,{"$error":"#VALUE!"},{"$f":"E89*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B89/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B89/'Worksheet 1'!$I$44,IF($B$10=\"m\",B89,\"error\")))","v":"error"},{"$f":"(E94-E89)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},75,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,75,"error","X"]
[76,null,{"$error":"#VALUE!"},{"$f":"E90*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E89+F89","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},76,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,76,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[77,null,{"$error":"#VALUE!"},{"$f":"E91*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E90+F89","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},77,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,77,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[78,null,{"$error":"#VALUE!"},{"$f":"E92*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E91+F89","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},78,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,78,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[79,null,{"$error":"#VALUE!"},{"$f":"E93*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E92+F89","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},79,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,79,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[80,null,{"$error":"#VALUE!"},{"$f":"E94*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B94/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B94/'Worksheet 1'!$I$44,IF($B$10=\"m\",B94,\"error\")))","v":"error"},{"$f":"(E99-E94)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},80,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,80,"error","X"]
[81,null,{"$error":"#VALUE!"},{"$f":"E95*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E94+F94","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},81,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,81,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[82,null,{"$error":"#VALUE!"},{"$f":"E96*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E95+F94","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},82,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,82,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[83,null,{"$error":"#VALUE!"},{"$f":"E97*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E96+F94","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},83,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,83,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[84,null,{"$error":"#VALUE!"},{"$f":"E98*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E97+F94","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},84,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,84,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[85,null,{"$error":"#VALUE!"},{"$f":"E99*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B99/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B99/'Worksheet 1'!$I$44,IF($B$10=\"m\",B99,\"error\")))","v":"error"},{"$f":"(E104-E99)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},85,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,85,"error","X"]
[86,null,{"$error":"#VALUE!"},{"$f":"E100*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E99+F99","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},86,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,86,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[87,null,{"$error":"#VALUE!"},{"$f":"E101*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E100+F99","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},87,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,87,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[88,null,{"$error":"#VALUE!"},{"$f":"E102*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E101+F99","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},88,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,88,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[89,null,{"$error":"#VALUE!"},{"$f":"E103*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E102+F99","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},89,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,89,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[90,null,{"$error":"#VALUE!"},{"$f":"E104*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B104/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B104/'Worksheet 1'!$I$44,IF($B$10=\"m\",B104,\"error\")))","v":"error"},{"$f":"(E109-E104)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},90,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,90,"error","X"]
[91,null,{"$error":"#VALUE!"},{"$f":"E105*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E104+F104","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},91,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,91,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[92,null,{"$error":"#VALUE!"},{"$f":"E106*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E105+F104","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},92,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,92,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[93,null,{"$error":"#VALUE!"},{"$f":"E107*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E106+F104","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},93,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,93,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[94,null,{"$error":"#VALUE!"},{"$f":"E108*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E107+F104","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},94,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,94,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[95,null,{"$error":"#VALUE!"},{"$f":"E109*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B109/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B109/'Worksheet 1'!$I$44,IF($B$10=\"m\",B109,\"error\")))","v":"error"},{"$f":"(E114-E109)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},95,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,95,"error","X"]
[96,null,{"$error":"#VALUE!"},{"$f":"E110*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E109+F109","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},96,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,96,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[97,null,{"$error":"#VALUE!"},{"$f":"E111*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E110+F109","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},97,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,97,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[98,null,{"$error":"#VALUE!"},{"$f":"E112*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E111+F109","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},98,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,98,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[99,null,{"$error":"#VALUE!"},{"$f":"E113*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E112+F109","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},99,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,99,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[100,null,{"$error":"#VALUE!"},{"$f":"E114*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B114/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B114/'Worksheet 1'!$I$44,IF($B$10=\"m\",B114,\"error\")))","v":"error"},{"$f":"(E119-E114)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},100,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,100,"error","X"]
[101,null,{"$error":"#VALUE!"},{"$f":"E115*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E114+F114","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},101,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,101,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[102,null,{"$error":"#VALUE!"},{"$f":"E116*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E115+F114","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},102,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,102,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[103,null,{"$error":"#VALUE!"},{"$f":"E117*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E116+F114","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},103,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,103,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[104,null,{"$error":"#VALUE!"},{"$f":"E118*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E117+F114","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},104,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,104,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[105,null,{"$error":"#VALUE!"},{"$f":"E119*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B119/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B119/'Worksheet 1'!$I$44,IF($B$10=\"m\",B119,\"error\")))","v":"error"},{"$f":"(E124-E119)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},105,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,105,"error","X"]
[106,null,{"$error":"#VALUE!"},{"$f":"E120*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E119+F119","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},106,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,106,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[107,null,{"$error":"#VALUE!"},{"$f":"E121*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E120+F119","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},107,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,107,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[108,null,{"$error":"#VALUE!"},{"$f":"E122*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E121+F119","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},108,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,108,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[109,null,{"$error":"#VALUE!"},{"$f":"E123*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E122+F119","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},109,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,109,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[110,null,{"$error":"#VALUE!"},{"$f":"E124*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B124/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B124/'Worksheet 1'!$I$44,IF($B$10=\"m\",B124,\"error\")))","v":"error"},{"$f":"(E129-E124)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},110,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,110,"error","X"]
[111,null,{"$error":"#VALUE!"},{"$f":"E125*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E124+F124","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},111,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,111,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[112,null,{"$error":"#VALUE!"},{"$f":"E126*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E125+F124","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},112,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,112,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[113,null,{"$error":"#VALUE!"},{"$f":"E127*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E126+F124","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},113,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,113,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[114,null,{"$error":"#VALUE!"},{"$f":"E128*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E127+F124","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},114,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,114,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[115,null,{"$error":"#VALUE!"},{"$f":"E129*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B129/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B129/'Worksheet 1'!$I$44,IF($B$10=\"m\",B129,\"error\")))","v":"error"},{"$f":"(E134-E129)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},115,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,115,"error","X"]
[116,null,{"$error":"#VALUE!"},{"$f":"E130*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E129+F129","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},116,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,116,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[117,null,{"$error":"#VALUE!"},{"$f":"E131*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E130+F129","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},117,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,117,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[118,null,{"$error":"#VALUE!"},{"$f":"E132*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E131+F129","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},118,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,118,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[119,null,{"$error":"#VALUE!"},{"$f":"E133*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E132+F129","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},119,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,119,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[120,null,{"$error":"#VALUE!"},{"$f":"E134*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B134/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B134/'Worksheet 1'!$I$44,IF($B$10=\"m\",B134,\"error\")))","v":"error"},{"$f":"(E139-E134)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},120,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,120,"error","X"]
[121,null,{"$error":"#VALUE!"},{"$f":"E135*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E134+F134","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},121,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,121,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[122,null,{"$error":"#VALUE!"},{"$f":"E136*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E135+F134","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},122,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,122,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[123,null,{"$error":"#VALUE!"},{"$f":"E137*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E136+F134","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},123,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,123,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[124,null,{"$error":"#VALUE!"},{"$f":"E138*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E137+F134","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},124,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,124,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[125,null,{"$error":"#VALUE!"},{"$f":"E139*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B139/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B139/'Worksheet 1'!$I$44,IF($B$10=\"m\",B139,\"error\")))","v":"error"},{"$f":"(E144-E139)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},125,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,125,"error","X"]
[126,null,{"$error":"#VALUE!"},{"$f":"E140*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E139+F139","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},126,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,126,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[127,null,{"$error":"#VALUE!"},{"$f":"E141*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E140+F139","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},127,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,127,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[128,null,{"$f":"D142*9.806","v":{"$error":"#VALUE!"}},{"$f":"E142*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E141+F139","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},128,{"$f":"E142","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(AND(BD142=\"X\",BD143=\"\"),BB142,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,128,{"$error":"#VALUE!"},{"$f":"IF(BI142>=0,\"X\",\"\")","v":{"$error":"#VALUE!"}}]
[129,null,{"$error":"#VALUE!"},{"$f":"E143*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E142+F139","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},129,{"$error":"#VALUE!"},{"$f":"IF(BC143>0,\"X\",\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(AND(BB143<=$BC$177,BD143=\"X\"),E143,\"\")","v":{"$error":"#VALUE!"}},null,129,{"$f":"IF(E143>=0,E143,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[130,null,{"$error":"#VALUE!"},{"$f":"E144*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B144/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B144/'Worksheet 1'!$I$44,IF($B$10=\"m\",B144,\"error\")))","v":"error"},{"$f":"(E149-E144)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},130,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,130,"error","X"]
[131,null,{"$error":"#VALUE!"},{"$f":"E145*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E144+F144","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},131,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,131,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[132,null,{"$error":"#VALUE!"},{"$f":"E146*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E145+F144","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},132,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,132,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[133,null,{"$error":"#VALUE!"},{"$f":"E147*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E146+F144","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},133,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,133,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[134,null,{"$error":"#VALUE!"},{"$f":"E148*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E147+F144","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},134,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,134,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[135,null,{"$error":"#VALUE!"},{"$f":"E149*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B149/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B149/'Worksheet 1'!$I$44,IF($B$10=\"m\",B149,\"error\")))","v":"error"},{"$f":"(E154-E149)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},135,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,135,"error","X"]
[136,null,{"$error":"#VALUE!"},{"$f":"E150*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E149+F149","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},136,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,136,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[137,null,{"$error":"#VALUE!"},{"$f":"E151*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E150+F149","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},137,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,137,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[138,null,{"$error":"#VALUE!"},{"$f":"E152*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E151+F149","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},138,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,138,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[139,null,{"$error":"#VALUE!"},{"$f":"E153*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E152+F149","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},139,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,139,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[140,null,{"$error":"#VALUE!"},{"$f":"E154*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B154/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B154/'Worksheet 1'!$I$44,IF($B$10=\"m\",B154,\"error\")))","v":"error"},{"$f":"(E159-E154)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},140,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,140,"error","X"]
[141,null,{"$error":"#VALUE!"},{"$f":"E155*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E154+F154","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},141,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,141,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[142,null,{"$error":"#VALUE!"},{"$f":"E156*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E155+F154","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},142,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,142,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[143,null,{"$error":"#VALUE!"},{"$f":"E157*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E156+F154","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},143,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,143,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[144,null,{"$error":"#VALUE!"},{"$f":"E158*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E157+F154","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},144,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,144,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[145,null,{"$error":"#VALUE!"},{"$f":"E159*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B159/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B159/'Worksheet 1'!$I$44,IF($B$10=\"m\",B159,\"error\")))","v":"error"},{"$f":"(E164-E159)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},145,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,145,"error","X"]
[146,null,{"$error":"#VALUE!"},{"$f":"E160*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E159+F159","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},146,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,146,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[147,null,{"$error":"#VALUE!"},{"$f":"E161*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E160+F159","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},147,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,147,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[148,null,{"$error":"#VALUE!"},{"$f":"E162*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E161+F159","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},148,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,148,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[149,null,{"$error":"#VALUE!"},{"$f":"E163*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E162+F159","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},149,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,149,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[150,null,{"$error":"#VALUE!"},{"$f":"E164*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B164/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B164/'Worksheet 1'!$I$44,IF($B$10=\"m\",B164,\"error\")))","v":"error"},{"$f":"(E169-E164)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},150,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,150,"error","X"]
[151,null,{"$error":"#VALUE!"},{"$f":"E165*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E164+F164","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},151,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,151,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[152,null,{"$error":"#VALUE!"},{"$f":"E166*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E165+F164","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},152,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,152,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[153,null,{"$error":"#VALUE!"},{"$f":"E167*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E166+F164","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},153,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,153,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[154,null,{"$error":"#VALUE!"},{"$f":"E168*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E167+F164","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},154,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,154,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[155,null,{"$error":"#VALUE!"},{"$f":"E169*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B169/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B169/'Worksheet 1'!$I$44,IF($B$10=\"m\",B169,\"error\")))","v":"error"},{"$f":"(E174-E169)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},155,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,155,"error","X"]
[156,null,{"$error":"#VALUE!"},{"$f":"E170*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E169+F169","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},156,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,156,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[157,null,{"$error":"#VALUE!"},{"$f":"E171*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E170+F169","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},157,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,157,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[158,null,{"$error":"#VALUE!"},{"$f":"E172*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E171+F169","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},158,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,158,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[159,null,{"$error":"#VALUE!"},{"$f":"E173*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"E172+F169","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},159,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,159,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[160,null,{"$error":"#VALUE!"},{"$f":"E174*'Worksheet 1'!$I$44","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B174/9.806/'Worksheet 1'!$I$44,IF($B$10=\"kg m\",B174/'Worksheet 1'!$I$44,IF($B$10=\"m\",B174,\"error\")))","v":"error"},{"$f":"(E179-E174)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},160,"error",{"$f":"IF(BC174>0,\"X\",\"\")","v":"X"},160,{"$error":"#VALUE!"},null,160,{"$f":"IF(E174=\"\",\"\",IF(E174>=0,E174,\"\"))","v":"error"},"X"]
[]
["Angle of vanishing stability",null,null,"Area under GZ curve",{"$nulls":50},"Bestimmung Phi V",null,null,"Fläche"]
[{"$f":"BC186","v":{"$error":"#VALUE!"}},null,"degrees",{"$f":"BF177","v":{"$error":"#VALUE!"}},{"$nulls":3},"m deg",{"$nulls":46},{"$f":"MAX(BE14:BE174)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(BC177,$BB$14:$BB$174,$BC$14:$BC$174)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(BF14:BF174)","v":{"$error":"#VALUE!"}}]
[{"$nulls":54},{"$f":"BC177+1","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(BC178,$BB$14:$BB$174,$BC$14:$BC$174)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[{"$nulls":54},"Nachkommastelle Phi V"]
[{"$nulls":54},{"$f":"(-1)*BD177/((-1)*BD177+BD178)","v":{"$error":"#VALUE!"}}]
[]
[{"$nulls":54},"Phi V"]
[{"$nulls":54},{"$f":"BC177+BC183","v":{"$error":"#VALUE!"}}]

{"sheet":"Worksheet 6b","index":10,"n_rows":186,"n_cols":62,"rows_kept":186,"merged":[[0,14,0,15],[2,0,2,10],[4,0,4,10],[175,0,175,1],[175,3,175,4],[176,0,176,1],[176,3,176,4]]}
[{"$nulls":14},"Comments"]
[{"$nulls":15},"Derived values"]
["ISO 12217-2:2017   CALCULATION WORKSHEET No. 6b    curve of righting moment mLA",{"$nulls":14},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[{"$nulls":48},"list:"]
["insert curve of righting moment in 5° steps in one of following units:",{"$nulls":47},"MW1"]
[null,"N m","kg m","m",{"$nulls":44},"MW2"]
[]
["chosen unit"]
[]
[]
["heeling angle[°]","insert Heeling Arm/Moment [Nm, kg m, m]","Heeling Moment [Nm]","Heeling Moment \n[kg m]","Arm Gz \n[m]","Diff(B-A/5)","Basis",{"$nulls":46},"heeling angle[°]","Arm\n[m]","Check > 0",null,"Flächenberechnung",null,null,"Arm [m]"]
[0,null,{"$f":"D14*9.806","v":{"$error":"#VALUE!"}},{"$f":"E14*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B14/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B14/'Worksheet 1'!$I$37,IF($B$10=\"m\",B14,\"error\")))","v":"error"},{"$f":"(E19-E14)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},0,{"$f":"E14","v":"error"},{"$f":"IF(BC14>=0,\"X\",\"\")","v":"X"},{"$f":"IF(AND(BD14=\"X\",BD15=\"\"),BB14,\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(BB14<=$BC$177,BD14=\"X\"),E14,\"\")","v":{"$error":"#VALUE!"}},null,0,{"$f":"IF(E14>=0,E14,\"\")","v":"error"},{"$f":"IF(BI14>=0,\"X\",\"\")","v":"X"}]
[1,null,{"$error":"#VALUE!"},{"$f":"E15*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E14+F14","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},1,{"$error":"#VALUE!"},{"$f":"IF(BC15>0,\"X\",\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$f":"IF(AND(BB15<=$BC$177,BD15=\"X\"),E15,\"\")","v":{"$error":"#VALUE!"}},null,1,{"$f":"IF(E15>=0,E15,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[2,null,{"$error":"#VALUE!"},{"$f":"E16*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E15+F14","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},2,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,2,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[3,null,{"$error":"#VALUE!"},{"$f":"E17*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E16+F14","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},3,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[4,null,{"$error":"#VALUE!"},{"$f":"E18*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E17+F14","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},4,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[5,null,{"$error":"#VALUE!"},{"$f":"E19*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B19/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B19/'Worksheet 1'!$I$37,IF($B$10=\"m\",B19,\"error\")))","v":"error"},{"$f":"(E24-E19)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},5,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,5,"error","X"]
[6,null,{"$error":"#VALUE!"},{"$f":"E20*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E19+F19","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},6,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,6,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[7,null,{"$error":"#VALUE!"},{"$f":"E21*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E20+F19","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},7,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[8,null,{"$error":"#VALUE!"},{"$f":"E22*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E21+F19","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},8,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,8,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[9,null,{"$error":"#VALUE!"},{"$f":"E23*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E22+F19","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},9,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,9,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[10,null,{"$error":"#VALUE!"},{"$f":"E24*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B24/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B24/'Worksheet 1'!$I$37,IF($B$10=\"m\",B24,\"error\")))","v":"error"},{"$f":"(E29-E24)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},10,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,10,"error","X"]
[11,null,{"$error":"#VALUE!"},{"$f":"E25*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E24+F24","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},11,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,11,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[12,null,{"$error":"#VALUE!"},{"$f":"E26*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E25+F24","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},12,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,12,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[13,null,{"$error":"#VALUE!"},{"$f":"E27*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E26+F24","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},13,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,13,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[14,null,{"$error":"#VALUE!"},{"$f":"E28*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E27+F24","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},14,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,14,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[15,null,{"$error":"#VALUE!"},{"$f":"E29*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B29/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B29/'Worksheet 1'!$I$37,IF($B$10=\"m\",B29,\"error\")))","v":"error"},{"$f":"(E34-E29)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},15,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,15,"error","X"]
[16,null,{"$error":"#VALUE!"},{"$f":"E30*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E29+F29","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},16,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,16,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[17,null,{"$error":"#VALUE!"},{"$f":"E31*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E30+F29","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},17,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,17,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[18,null,{"$error":"#VALUE!"},{"$f":"E32*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E31+F29","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},18,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,18,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[19,null,{"$error":"#VALUE!"},{"$f":"E33*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E32+F29","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},19,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,19,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[20,null,{"$error":"#VALUE!"},{"$f":"E34*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B34/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B34/'Worksheet 1'!$I$37,IF($B$10=\"m\",B34,\"error\")))","v":"error"},{"$f":"(E39-E34)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},20,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,20,"error","X"]
[21,null,{"$error":"#VALUE!"},{"$f":"E35*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E34+F34","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},21,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,21,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[22,null,{"$error":"#VALUE!"},{"$f":"E36*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E35+F34","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},22,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,22,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[23,null,{"$error":"#VALUE!"},{"$f":"E37*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E36+F34","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},23,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,23,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[24,null,{"$error":"#VALUE!"},{"$f":"E38*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E37+F34","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},24,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,24,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[25,null,{"$error":"#VALUE!"},{"$f":"E39*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B39/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B39/'Worksheet 1'!$I$37,IF($B$10=\"m\",B39,\"error\")))","v":"error"},{"$f":"(E44-E39)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},25,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,25,"error","X"]
[26,null,{"$error":"#VALUE!"},{"$f":"E40*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E39+F39","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},26,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,26,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[27,null,{"$error":"#VALUE!"},{"$f":"E41*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E40+F39","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},27,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,27,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[28,null,{"$error":"#VALUE!"},{"$f":"E42*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E41+F39","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[29,null,{"$error":"#VALUE!"},{"$f":"E43*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E42+F39","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},29,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,29,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[30,null,{"$error":"#VALUE!"},{"$f":"E44*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B44/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B44/'Worksheet 1'!$I$37,IF($B$10=\"m\",B44,\"error\")))","v":"error"},{"$f":"(E49-E44)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},30,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,30,"error","X"]
[31,null,{"$error":"#VALUE!"},{"$f":"E45*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E44+F44","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[32,null,{"$error":"#VALUE!"},{"$f":"E46*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E45+F44","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},32,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,32,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[33,null,{"$error":"#VALUE!"},{"$f":"E47*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E46+F44","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},33,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,33,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[34,null,{"$error":"#VALUE!"},{"$f":"E48*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E47+F44","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},34,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,34,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[35,null,{"$error":"#VALUE!"},{"$f":"E49*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B49/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B49/'Worksheet 1'!$I$37,IF($B$10=\"m\",B49,\"error\")))","v":"error"},{"$f":"(E54-E49)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},35,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,35,"error","X"]
[36,null,{"$error":"#VALUE!"},{"$f":"E50*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E49+F49","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},36,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,36,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[37,null,{"$error":"#VALUE!"},{"$f":"E51*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E50+F49","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},37,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,37,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[38,null,{"$error":"#VALUE!"},{"$f":"E52*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E51+F49","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},38,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,38,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[39,null,{"$error":"#VALUE!"},{"$f":"E53*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E52+F49","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},39,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,39,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[40,null,{"$f":"D54*9.806","v":{"$error":"#VALUE!"}},{"$f":"E54*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B54/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B54/'Worksheet 1'!$I$37,IF($B$10=\"m\",B54,\"error\")))","v":"error"},{"$f":"(E59-E54)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},40,{"$f":"E54","v":"error"},"X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,40,"error","X"]
[41,null,{"$error":"#VALUE!"},{"$f":"E55*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E54+F54","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},41,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,41,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[42,null,{"$error":"#VALUE!"},{"$f":"E56*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E55+F54","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},42,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,42,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[43,null,{"$error":"#VALUE!"},{"$f":"E57*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E56+F54","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},43,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,43,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[44,null,{"$error":"#VALUE!"},{"$f":"E58*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E57+F54","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},44,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,44,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[45,null,{"$error":"#VALUE!"},{"$f":"E59*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B59/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B59/'Worksheet 1'!$I$37,IF($B$10=\"m\",B59,\"error\")))","v":"error"},{"$f":"(E64-E59)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},45,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,45,"error","X"]
[46,null,{"$error":"#VALUE!"},{"$f":"E60*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E59+F59","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},46,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,46,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[47,null,{"$error":"#VALUE!"},{"$f":"E61*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E60+F59","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},47,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,47,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[48,null,{"$error":"#VALUE!"},{"$f":"E62*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E61+F59","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},48,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,48,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[49,null,{"$error":"#VALUE!"},{"$f":"E63*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E62+F59","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},49,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,49,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[50,null,{"$error":"#VALUE!"},{"$f":"E64*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B64/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B64/'Worksheet 1'!$I$37,IF($B$10=\"m\",B64,\"error\")))","v":"error"},{"$f":"(E69-E64)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},50,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,50,"error","X"]
[51,null,{"$error":"#VALUE!"},{"$f":"E65*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E64+F64","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},51,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,51,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[52,null,{"$error":"#VALUE!"},{"$f":"E66*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E65+F64","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},52,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,52,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[53,null,{"$error":"#VALUE!"},{"$f":"E67*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E66+F64","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},53,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,53,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[54,null,{"$error":"#VALUE!"},{"$f":"E68*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E67+F64","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},54,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,54,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[55,null,{"$error":"#VALUE!"},{"$f":"E69*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B69/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B69/'Worksheet 1'!$I$37,IF($B$10=\"m\",B69,\"error\")))","v":"error"},{"$f":"(E74-E69)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},55,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,55,"error","X"]
[56,null,{"$error":"#VALUE!"},{"$f":"E70*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E69+F69","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},56,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,56,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[57,null,{"$error":"#VALUE!"},{"$f":"E71*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E70+F69","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},57,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,57,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[58,null,{"$error":"#VALUE!"},{"$f":"E72*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E71+F69","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},58,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,58,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[59,null,{"$error":"#VALUE!"},{"$f":"E73*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E72+F69","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},59,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,59,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[60,null,{"$error":"#VALUE!"},{"$f":"E74*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B74/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B74/'Worksheet 1'!$I$37,IF($B$10=\"m\",B74,\"error\")))","v":"error"},{"$f":"(E79-E74)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},60,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,60,"error","X"]
[61,null,{"$error":"#VALUE!"},{"$f":"E75*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E74+F74","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},61,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,61,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[62,null,{"$error":"#VALUE!"},{"$f":"E76*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E75+F74","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},62,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,62,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[63,null,{"$error":"#VALUE!"},{"$f":"E77*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E76+F74","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},63,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,63,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[64,null,{"$error":"#VALUE!"},{"$f":"E78*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E77+F74","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},64,{"$error":"#VALUE!"},{"$f":"IF(BC78>0,\"X\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(BD78=\"X\",BD79=\"\"),BB78,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,64,{"$error":"#VALUE!"},{"$f":"IF(BI78>=0,\"X\",\"\")","v":{"$error":"#VALUE!"}}]
[65,null,{"$error":"#VALUE!"},{"$f":"E79*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B79/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B79/'Worksheet 1'!$I$37,IF($B$10=\"m\",B79,\"error\")))","v":"error"},{"$f":"(E84-E79)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},65,"error","X",{"$error":"#VALUE!"},{"$f":"IF(AND(BB79<=$BC$177,BD79=\"X\"),E79,\"\")","v":{"$error":"#VALUE!"}},null,65,{"$f":"IF(E79>=0,E79,\"\")","v":"error"},"X"]
[66,null,{"$error":"#VALUE!"},{"$f":"E80*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E79+F79","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},66,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,66,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[67,null,{"$error":"#VALUE!"},{"$f":"E81*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E80+F79","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},67,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,67,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[68,null,{"$error":"#VALUE!"},{"$f":"E82*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E81+F79","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},68,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,68,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[69,null,{"$error":"#VALUE!"},{"$f":"E83*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E82+F79","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},69,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,69,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[70,null,{"$error":"#VALUE!"},{"$f":"E84*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B84/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B84/'Worksheet 1'!$I$37,IF($B$10=\"m\",B84,\"error\")))","v":"error"},{"$f":"(E89-E84)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},70,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,70,"error","X"]
[71,null,{"$f":"D85*9.806","v":{"$error":"#VALUE!"}},{"$f":"E85*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E84+F84","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},71,{"$f":"E85","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,71,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[72,null,{"$error":"#VALUE!"},{"$f":"E86*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E85+F84","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},72,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,72,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[73,null,{"$error":"#VALUE!"},{"$f":"E87*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E86+F84","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},73,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,73,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[74,null,{"$error":"#VALUE!"},{"$f":"E88*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E87+F84","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},74,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,74,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[75,null,{"$f":"D89*9.806","v":{"$error":"#VALUE!"}},{"$f":"E89*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B89/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B89/'Worksheet 1'!$I$37,IF($B$10=\"m\",B89,\"error\")))","v":"error"},{"$f":"(E94-E89)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},75,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,75,"error","X"]
[76,null,{"$error":"#VALUE!"},{"$f":"E90*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E89+F89","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},76,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,76,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[77,null,{"$error":"#VALUE!"},{"$f":"E91*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E90+F89","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},77,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,77,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[78,null,{"$error":"#VALUE!"},{"$f":"E92*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E91+F89","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},78,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,78,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[79,null,{"$error":"#VALUE!"},{"$f":"E93*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E92+F89","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},79,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,79,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[80,null,{"$error":"#VALUE!"},{"$f":"E94*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B94/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B94/'Worksheet 1'!$I$37,IF($B$10=\"m\",B94,\"error\")))","v":"error"},{"$f":"(E99-E94)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},80,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,80,"error","X"]
[81,null,{"$error":"#VALUE!"},{"$f":"E95*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E94+F94","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},81,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,81,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[82,null,{"$error":"#VALUE!"},{"$f":"E96*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E95+F94","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},82,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,82,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[83,null,{"$error":"#VALUE!"},{"$f":"E97*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E96+F94","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},83,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,83,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[84,null,{"$error":"#VALUE!"},{"$f":"E98*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E97+F94","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},84,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,84,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[85,null,{"$f":"D99*9.806","v":{"$error":"#VALUE!"}},{"$f":"E99*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B99/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B99/'Worksheet 1'!$I$37,IF($B$10=\"m\",B99,\"error\")))","v":"error"},{"$f":"(E104-E99)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},85,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,85,"error","X"]
[86,null,{"$error":"#VALUE!"},{"$f":"E100*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E99+F99","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},86,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,86,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[87,null,{"$error":"#VALUE!"},{"$f":"E101*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E100+F99","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},87,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,87,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[88,null,{"$error":"#VALUE!"},{"$f":"E102*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E101+F99","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},88,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,88,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[89,null,{"$error":"#VALUE!"},{"$f":"E103*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E102+F99","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},89,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,89,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[90,null,{"$error":"#VALUE!"},{"$f":"E104*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B104/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B104/'Worksheet 1'!$I$37,IF($B$10=\"m\",B104,\"error\")))","v":"error"},{"$f":"(E109-E104)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},90,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,90,"error","X"]
[91,null,{"$error":"#VALUE!"},{"$f":"E105*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E104+F104","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},91,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,91,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[92,null,{"$error":"#VALUE!"},{"$f":"E106*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E105+F104","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},92,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,92,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[93,null,{"$error":"#VALUE!"},{"$f":"E107*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E106+F104","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},93,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,93,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[94,null,{"$error":"#VALUE!"},{"$f":"E108*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E107+F104","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},94,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,94,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[95,null,{"$error":"#VALUE!"},{"$f":"E109*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B109/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B109/'Worksheet 1'!$I$37,IF($B$10=\"m\",B109,\"error\")))","v":"error"},{"$f":"(E114-E109)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},95,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,95,"error","X"]
[96,null,{"$error":"#VALUE!"},{"$f":"E110*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E109+F109","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},96,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,96,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[97,null,{"$error":"#VALUE!"},{"$f":"E111*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E110+F109","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},97,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,97,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[98,null,{"$error":"#VALUE!"},{"$f":"E112*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E111+F109","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},98,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,98,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[99,null,{"$error":"#VALUE!"},{"$f":"E113*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E112+F109","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},99,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,99,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[100,null,{"$error":"#VALUE!"},{"$f":"E114*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B114/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B114/'Worksheet 1'!$I$37,IF($B$10=\"m\",B114,\"error\")))","v":"error"},{"$f":"(E119-E114)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},100,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,100,"error","X"]
[101,null,{"$error":"#VALUE!"},{"$f":"E115*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E114+F114","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},101,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,101,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[102,null,{"$error":"#VALUE!"},{"$f":"E116*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E115+F114","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},102,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,102,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[103,null,{"$error":"#VALUE!"},{"$f":"E117*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E116+F114","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},103,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,103,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[104,null,{"$error":"#VALUE!"},{"$f":"E118*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E117+F114","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},104,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,104,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[105,null,{"$f":"D119*9.806","v":{"$error":"#VALUE!"}},{"$f":"E119*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B119/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B119/'Worksheet 1'!$I$37,IF($B$10=\"m\",B119,\"error\")))","v":"error"},{"$f":"(E124-E119)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},105,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,105,"error","X"]
[106,null,{"$error":"#VALUE!"},{"$f":"E120*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E119+F119","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},106,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,106,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[107,null,{"$error":"#VALUE!"},{"$f":"E121*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E120+F119","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},107,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,107,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[108,null,{"$error":"#VALUE!"},{"$f":"E122*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E121+F119","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},108,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,108,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[109,null,{"$error":"#VALUE!"},{"$f":"E123*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E122+F119","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},109,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,109,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[110,null,{"$f":"D124*9.806","v":{"$error":"#VALUE!"}},{"$f":"E124*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B124/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B124/'Worksheet 1'!$I$37,IF($B$10=\"m\",B124,\"error\")))","v":"error"},{"$f":"(E129-E124)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},110,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,110,"error","X"]
[111,null,{"$error":"#VALUE!"},{"$f":"E125*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E124+F124","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},111,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,111,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[112,null,{"$error":"#VALUE!"},{"$f":"E126*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E125+F124","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},112,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,112,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[113,null,{"$error":"#VALUE!"},{"$f":"E127*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E126+F124","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},113,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,113,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[114,null,{"$error":"#VALUE!"},{"$f":"E128*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E127+F124","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},114,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,114,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[115,null,{"$error":"#VALUE!"},{"$f":"E129*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B129/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B129/'Worksheet 1'!$I$37,IF($B$10=\"m\",B129,\"error\")))","v":"error"},{"$f":"(E134-E129)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},115,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,115,"error","X"]
[116,null,{"$error":"#VALUE!"},{"$f":"E130*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E129+F129","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},116,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,116,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[117,null,{"$error":"#VALUE!"},{"$f":"E131*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E130+F129","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},117,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,117,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[118,null,{"$error":"#VALUE!"},{"$f":"E132*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E131+F129","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},118,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,118,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[119,null,{"$error":"#VALUE!"},{"$f":"E133*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E132+F129","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},119,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,119,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[120,null,{"$error":"#VALUE!"},{"$f":"E134*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B134/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B134/'Worksheet 1'!$I$37,IF($B$10=\"m\",B134,\"error\")))","v":"error"},{"$f":"(E139-E134)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},120,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,120,"error","X"]
[121,null,{"$error":"#VALUE!"},{"$f":"E135*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E134+F134","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},121,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,121,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[122,null,{"$error":"#VALUE!"},{"$f":"E136*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E135+F134","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},122,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,122,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[123,null,{"$error":"#VALUE!"},{"$f":"E137*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E136+F134","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},123,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,123,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[124,null,{"$error":"#VALUE!"},{"$f":"E138*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E137+F134","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},124,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,124,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[125,null,{"$error":"#VALUE!"},{"$f":"E139*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B139/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B139/'Worksheet 1'!$I$37,IF($B$10=\"m\",B139,\"error\")))","v":"error"},{"$f":"(E144-E139)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},125,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,125,"error","X"]
[126,null,{"$error":"#VALUE!"},{"$f":"E140*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E139+F139","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},126,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,126,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[127,null,{"$error":"#VALUE!"},{"$f":"E141*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E140+F139","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},127,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,127,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[128,null,{"$error":"#VALUE!"},{"$f":"E142*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E141+F139","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},128,{"$error":"#VALUE!"},{"$f":"IF(BC142>0,\"X\",\"\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(BD142=\"X\",BD143=\"\"),BB142,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},null,128,{"$error":"#VALUE!"},{"$f":"IF(BI142>=0,\"X\",\"\")","v":{"$error":"#VALUE!"}}]
[129,null,{"$error":"#VALUE!"},{"$f":"E143*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E142+F139","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},129,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(AND(BB143<=$BC$177,BD143=\"X\"),E143,\"\")","v":{"$error":"#VALUE!"}},null,129,{"$f":"IF(E143>=0,E143,\"\")","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"}]
[130,null,{"$error":"#VALUE!"},{"$f":"E144*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B144/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B144/'Worksheet 1'!$I$37,IF($B$10=\"m\",B144,\"error\")))","v":"error"},{"$f":"(E149-E144)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},130,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,130,"error","X"]
[131,null,{"$error":"#VALUE!"},{"$f":"E145*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E144+F144","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},131,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,131,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[132,null,{"$error":"#VALUE!"},{"$f":"E146*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E145+F144","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},132,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,132,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[133,null,{"$error":"#VALUE!"},{"$f":"E147*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E146+F144","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},133,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,133,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[134,null,{"$error":"#VALUE!"},{"$f":"E148*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E147+F144","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},134,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,134,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[135,null,{"$error":"#VALUE!"},{"$f":"E149*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B149/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B149/'Worksheet 1'!$I$37,IF($B$10=\"m\",B149,\"error\")))","v":"error"},{"$f":"(E154-E149)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},135,{"$f":"E149","v":"error"},"X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,135,"error","X"]
[136,null,{"$error":"#VALUE!"},{"$f":"E150*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E149+F149","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},136,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,136,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[137,null,{"$error":"#VALUE!"},{"$f":"E151*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E150+F149","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},137,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,137,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[138,null,{"$error":"#VALUE!"},{"$f":"E152*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E151+F149","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},138,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,138,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[139,null,{"$error":"#VALUE!"},{"$f":"E153*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E152+F149","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},139,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,139,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[140,null,{"$error":"#VALUE!"},{"$f":"E154*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B154/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B154/'Worksheet 1'!$I$37,IF($B$10=\"m\",B154,\"error\")))","v":"error"},{"$f":"(E159-E154)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},140,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,140,"error","X"]
[141,null,{"$error":"#VALUE!"},{"$f":"E155*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E154+F154","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},141,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,141,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[142,null,{"$error":"#VALUE!"},{"$f":"E156*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E155+F154","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},142,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,142,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[143,null,{"$error":"#VALUE!"},{"$f":"E157*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E156+F154","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},143,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,143,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[144,null,{"$error":"#VALUE!"},{"$f":"E158*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E157+F154","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},144,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,144,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[145,null,{"$error":"#VALUE!"},{"$f":"E159*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B159/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B159/'Worksheet 1'!$I$37,IF($B$10=\"m\",B159,\"error\")))","v":"error"},{"$f":"(E164-E159)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},145,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,145,"error","X"]
[146,null,{"$error":"#VALUE!"},{"$f":"E160*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E159+F159","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},146,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,146,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[147,null,{"$error":"#VALUE!"},{"$f":"E161*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E160+F159","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},147,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,147,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[148,null,{"$error":"#VALUE!"},{"$f":"E162*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E161+F159","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},148,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,148,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[149,null,{"$error":"#VALUE!"},{"$f":"E163*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E162+F159","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},149,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,149,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[150,null,{"$error":"#VALUE!"},{"$f":"E164*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B164/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B164/'Worksheet 1'!$I$37,IF($B$10=\"m\",B164,\"error\")))","v":"error"},{"$f":"(E169-E164)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},150,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,150,"error","X"]
[151,null,{"$error":"#VALUE!"},{"$f":"E165*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E164+F164","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},151,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,151,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[152,null,{"$error":"#VALUE!"},{"$f":"E166*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E165+F164","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},152,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,152,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[153,null,{"$error":"#VALUE!"},{"$f":"E167*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E166+F164","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},153,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,153,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[154,null,{"$error":"#VALUE!"},{"$f":"E168*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E167+F164","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},154,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,154,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[155,null,{"$error":"#VALUE!"},{"$f":"E169*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B169/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B169/'Worksheet 1'!$I$37,IF($B$10=\"m\",B169,\"error\")))","v":"error"},{"$f":"(E174-E169)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},155,"error","X",{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,155,"error","X"]
[156,null,{"$error":"#VALUE!"},{"$f":"E170*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E169+F169","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},156,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,156,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[157,null,{"$error":"#VALUE!"},{"$f":"E171*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E170+F169","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},157,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,157,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[158,null,{"$error":"#VALUE!"},{"$f":"E172*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E171+F169","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},158,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,158,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[159,null,{"$error":"#VALUE!"},{"$f":"E173*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"E172+F169","v":{"$error":"#VALUE!"}},null,0,{"$nulls":46},159,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,159,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[160,null,{"$error":"#VALUE!"},{"$f":"E174*'Worksheet 1'!$I$37","v":{"$error":"#VALUE!"}},{"$f":"IF($B$10=\"N m\",B174/9.806/'Worksheet 1'!$I$37,IF($B$10=\"kg m\",B174/'Worksheet 1'!$I$37,IF($B$10=\"m\",B174,\"error\")))","v":"error"},{"$f":"(E179-E174)/5","v":{"$error":"#VALUE!"}},0,{"$nulls":46},160,"error",{"$f":"IF(BC174>0,\"X\",\"\")","v":"X"},{"$f":"IF(AND(BD174=\"X\",BD175=\"\"),BB174,\"\")","v":160},{"$error":"#VALUE!"},null,160,{"$f":"IF(E174=\"\",\"\",IF(E174>=0,E174,\"\"))","v":"error"},"X"]
[]
["Angle of vanishing stability",null,null,"Area under GZ curve",{"$nulls":50},"Bestimmung Phi V",null,null,"Fläche"]
[{"$f":"BC186","v":{"$error":"#VALUE!"}},null,"degrees",{"$f":"BF177","v":{"$error":"#VALUE!"}},{"$nulls":3},"m deg",{"$nulls":46},{"$f":"MAX(BE14:BE174)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(BC177,$BB$14:$BB$174,$BC$14:$BC$174)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(BF14:BF174)","v":{"$error":"#VALUE!"}}]
[{"$nulls":54},{"$f":"BC177+1","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP(BC178,$BB$14:$BB$174,$BC$14:$BC$174)","v":{"$error":"#VALUE!"}}]
[]
[{"$nulls":54},"Nachkommastelle Phi V"]
[]
[]
[{"$nulls":54},{"$f":"(-1)*BD177/((-1)*BD177+BD178)","v":{"$error":"#VALUE!"}}]
[]
[{"$nulls":54},"Phi V"]
[{"$nulls":54},{"$f":"BC177+BC183","v":{"$error":"#VALUE!"}}]

{"sheet":"Worksheet 10","index":11,"n_rows":41,"n_cols":8,"rows_kept":41,"merged":[[0,6,0,7],[2,0,2,4],[4,0,4,4],[7,0,7,4],[31,0,31,2],[32,0,32,2],[33,0,33,2],[34,0,34,2],[35,0,35,2],[37,0,37,2],[39,0,39,2],[40,0,40,2]]}
[{"$nulls":6},"Comments"]
[{"$nulls":7}," Derived values"]
["ISO 12217-2:2017  CALCULATION  WORKSHEET  No. 10 FLOTATION  REQUIREMENT ",{"$nulls":6}," Input values"]
[{"$nulls":7}," Default values, but alterable"]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[null,"only required if multihull is vulnerabel to inversion, see cl. 7.11"]
["Annex D"]
["Objective: to show that the buoyancy available from the hull structure, fittings and flotation elements equals or exceeds that required to support the loaded boat."]
[]
["Item","Mass","Density","Volume","Ref."]
[null,"[kg]","[kg/m³]","[m³]"]
["Hull structure"]
["GRP Laminate",null,1500,{"$f":"IF(B13=\"\",\"\",IF(C13=\"\",\"\",B13/C13))","v":""},"Table D.1"]
["Foam core materials",null,80,{"$f":"IF(B14=\"\",\"\",IF(C14=\"\",\"\",B14/C14))","v":""},"Table D.1"]
["B alsa core materials",null,150,"","Table D.1"]
["Plywood",null,600,"","Table D.1"]
["Other timber",null,600,"","Table D.1"]
["Permanent balast",null,7800,"","Table D.1"]
["Fastenings and other metalwork",null,5000,"","Table D.1"]
["Windows",null,2300,"","Table D.1"]
["Engines and other fittings an equipment",null,null,{"$f":"IF(B21<>\"\",ROUND(B21/C21,3),\"\")","v":""}]
["Diesel engines",null,5000,{"$f":"IF(B22=\"\",\"\",IF(C22=\"\",\"\",B22/C22))","v":""},"Table D.1"]
["Petrol engines",null,4000,"","Table D.1"]
["Outboard engines",null,3000,"","Table D.1"]
["Sail-drive or stern-drive",null,4000,"","Table D.1"]
["Mast(s) and Spar(s)",null,2700,"","Table D.1"]
["Stowed sails and ropes",null,1200,"","Table D.1"]
["Food and other stores",null,2000,"","Table D.1"]
["Miscellaneous equipment",null,2000,"","Table D.1"]
["Non-integral fuel tanks",null,null,"","Table D.1"]
["Non-integral water tanks",null,null,"","Table D.1"]
["Gross volumes of fixed tanks and air containers",{"$nulls":3},"D.2.2"]
["Fuel tanks",{"$nulls":3},"D.2.2","unit is m³ !"]
["Water tanks",{"$nulls":3},"D.2.2","please don't fill in in liter"]
["Other tanks",{"$nulls":3},"D.2.2"]
["Air tanks or container meeting the requirement of annex E",{"$nulls":3},"D.2.2"]
[]
["Total volume of hull, fittings and equipment, VB   Sum ",null,null,{"$f":"SUM(D13:D36)","v":0}]
["Mass in the maximum load condition","mLDC","kg",{"$f":"'Worksheet 1'!I35","v":0},"3.5.5"]
["calculate ratio mLDC / VB    .",null,null,{"$f":"IF(D39=0,\"\",D39/D38)","v":""}]
["For option 8     mLDC / VB < 850 ?",null,null,{"$f":"IF(D40<850,\"Pass\",\"Fail\")","v":"Fail"}]

{"sheet":"Worksheet 11","index":12,"n_rows":23,"n_cols":27,"rows_kept":23,"merged":[[0,6,0,7],[2,0,2,4],[4,0,4,4],[6,0,6,4],[8,0,8,4],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,1,19,4],[20,1,20,4],[21,1,21,3],[22,0,22,1],[22,2,22,3]]}
[{"$nulls":6},"Comments"]
[{"$nulls":7}," Derived values",{"$nulls":18},"List:"]
["ISO 12217-2:2017 CALCULATION  WORKSHEET No.11         CAPSIZE-RECOVERY TEST",{"$nulls":6}," Input values",{"$nulls":18},"Yes"]
[{"$nulls":26},"No"]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[{"$nulls":26},"Water"]
["Design Categories C and D only",{"$nulls":25},"Weights"]
[]
["Objective: to demonstrate that a boat can be returned to the upright after a capsize by the actions of the crew using their body action and/or righting devices purposely designed and permanently fitted to the boat, that it will subsequently float, and to verify that the recommended minimum crew mass is sufficient for the recovery method used.",{"$nulls":25},"experimental"]
[{"$nulls":26},"theoretical"]
["Item",null,"Unit","Value","Ref."]
["Minimum number of crewrequired",null,"---",null,"6.10.7"]
["Minimum mass of crew required",null,"kg",null,"6.10.7"]
["Is boat prepared as in 6.10.2 to 6.10.5 ?                                                ",null,"Yes / No",null,"6.10.2-5"]
["Does boat float for > 5 min when fully capsized ?                                  ",null,"Yes / No",null,"6.10.6"]
["Time required to right the boat (least time of 1 to 3 attempts)",null,"minutes",null,"6.10.8"]
["Is this time less than 5 min?",null,"Yes / No",null,"6.10.8"]
["With one 75 kg person aboard, boat floats so it can be pumped or bailed out ?",null,"Yes / No",null,"6.10.10"]
["With full Crew Limit aboard, without bailing, boat floats approx. level with at least 2/3 periphery showing, for more than 5 min ?                                        ",null,"Yes / No",null,"6.10.11"]
["INFORMATION FOR OWNER'S MANUAL:\nLikelihood of capsize occuring in normal use:"]
["Righting technique which is most successful:"]
["Minimum number of crew required?                      ","Minimum mass of crew required (kg):"]
["Design category recommended by the builder:  ",null,{"$f":"'Worksheet 1'!D8","v":0}]

{"sheet":"Worksheet 12","index":13,"n_rows":62,"n_cols":14,"rows_kept":62,"merged":[[0,8,0,9],[2,0,2,6],[4,0,4,6],[8,7,10,9],[12,4,13,7],[18,1,18,3],[18,4,18,6],[19,0,21,1],[19,4,21,4],[22,0,24,1],[22,4,24,4],[25,0,27,1],[25,4,27,4],[28,0,30,1],[28,4,30,4],[31,0,33,1],[31,4,33,4],[34,0,36,1],[34,4,36,4],[37,0,39,1],[37,4,39,4],[40,0,40,2],[42,0,44,1],[42,4,44,4],[45,0,47,1],[45,4,47,4],[48,0,50,1],[48,4,50,4],[52,0,52,2],[52,4,52,5],[54,0,56,1],[54,4,56,4],[58,2,59,2],[58,5,59,5],[61,0,61,2]]}
[{"$nulls":8},"Comments"]
[{"$nulls":9}," Derived values"]
["ISO 12217-2:2017   CALCULATION  WORKSHEET  No. 12                      BARE POLES FACTOR",{"$nulls":8}," Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[{"$nulls":7},"ΦGzmax","will be calulated for Cats",null,"Trimarans must use the value"]
["Mass of boat in minimum operating condition","mMO","kg",{"$f":"'Worksheet 1'!I44","v":0},{"$nulls":3},"If at hand, please overwrite with actual value",null,null,"from a righting moments curve"]
["Length","LH","m",{"$f":"'Worksheet 1'!I10","v":{"v":0,"d":"0.00"}},{"$nulls":3},"from curve of righting moments."]
["Lenght of waterline in mMO","LWL (MO)","m",{"$nulls":4},"!! Attention !! BWL is the sum of the maximum waterline beams of\neach of the hulls."]
["Beam of waterline","BWL","m"]
["Beam between centres of buoyancy of hulls","BCB","m",{"$f":"'Worksheet 2'!I13","v":{"v":0,"d":"0.00"}},{"$nulls":6},"Limiting trim angle",null,"ΘL"]
["Height of CG above bottom of canoe body","VCG","m",{"$nulls":7},"may be estimated by 1,4 * arc tan (FS / (R + LB)"]
["Limiting trim angle","ΘL","°",null,{"$f":"IF(D13=\"\",\"\",IF(D13>20,\"limiting trim angle (degrees), being the lesser of 20° or the angle of immersion of the weather deck at the stem\",\"\"))","v":""}]
["Estimated angle of heel of maximum GZ","ΦGzmax","°",{"$f":"IF('Worksheet 2'!I9=\"Catamaran\",DEGREES(ATAN(D7/(254*D9*D10*D11))),\"value req\")","v":"value req"},{"$nulls":6},"m",null,"FS","vertical freeboard from waterline to intersection of line of foredeck and outer stem;"]
["Limiting moment Transverse","LMT","Nm",{"$f":"9.4*D7*((0.5*D11*COS(PI()*D14/180))-(D12*SIN(PI()*D14/180)))","v":{"$error":"#VALUE!"}},{"$nulls":3},"LMT","in Nm !!!!!",null,"m",null,"R","bow rake, i.e. the longitudinal distance from intersection of line of weather deck and outer stem to forward end of waterline;"]
["Limiting moment Longitudinal","LML","Nm",{"$f":"D13*D10*(D8+D9)^3/3","v":0},{"$nulls":3},"LML","in Nm !!!!!",null,"m",null,"LB","longitudinal distance from longitudinal centre of buoyancy of immersed hulls at design trim to forward end of waterline"]
[]
[{"$nulls":10},"degrees",{"$f":"1.4*DEGREES(ATAN(L14/(L15+L16)))","v":{"$error":"#DIV/0!"}},"ΘL","Limiting trim angle"]
[null,"Transverse",null,null,"Longitudinal"]
["Hull",null,"area (m²)",null,{"$f":"A20","v":"Hull"},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D20*D21","v":0},null,"moment",{"$f":"G20*G21","v":0}]
["Mast No. 1",null,"area (m²)",null,{"$f":"A23","v":"Mast No. 1"},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D23*D24","v":0},null,"moment",{"$f":"G23*G24","v":0}]
["Boom No. 1",null,"area (m²)",null,{"$f":"A26","v":"Boom No. 1"},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D26*D27","v":0},null,"moment",{"$f":"G26*G27","v":0}]
["Mast No. 2",null,"area (m²)",null,{"$f":"A29","v":"Mast No. 2"},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D29*D30","v":0},null,"moment",{"$f":"G29*G30","v":0}]
["Boom No. 2",null,"area (m²)",null,{"$f":"A32","v":"Boom No. 2"},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D32*D33","v":0},null,"moment",{"$f":"G32*G33","v":0}]
["Antennae with area greater than 0,01m²",null,"area (m²)",null,{"$f":"A35","v":"Antennae with area greater than 0,01m²"},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D35*D36","v":0},null,"moment",{"$f":"G35*G36","v":0}]
["Standard rigging",null,"area (m²)",null,{"$f":"A38","v":"Standard rigging"},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D38*D39","v":0},null,"moment",{"$f":"G38*G39","v":0}]
["Total hull & rig moments of area  ΣAH hH",null,null,{"$f":"D22+D25+D28+D31+D34+D37+D40","v":0},"Total m. of area  ΣAH hH",null,{"$f":"G22+G25+G28+G31+G34+G37+G40","v":0}]
[]
["Sail stowed on boom No.1",null,"area (m²)",null,{"$f":"A43","v":"Sail stowed on boom No.1"},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D43*D44","v":0},null,"moment",{"$f":"G43*G44","v":0}]
["Roller furled sail No. 1\n(excluding in-mast furling)",null,"area (m²)",null,"Roller furled sail No. 1\n(excluding in-mast furling)","area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D46*D47","v":0},null,"moment",{"$f":"G46*G47","v":0}]
["Roller furled sail No. 2\n(excluding in-mast furling)",null,"area (m²)",null,"Roller furled sail No. 2\n(excluding in-mast furling)","area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D49*D50","v":0},null,"moment",{"$f":"G49*G50","v":0}]
[]
["Total bare pole moments of area ΣABP hBP",null,null,{"$f":"D41+D45+D48+D51","v":0}," ΣABP hBP",null,{"$f":"G41+G45+G48+G51","v":0}]
[]
["Wing mast",null,"area (m²)",null,{"$f":"A55","v":"Wing mast"},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D55*D56","v":0},null,"moment",{"$f":"G55*G56","v":0}]
[]
[null,"Bare Pole speed trans.",{"$f":"($D$15/(0.8*D53+D57))^0.5*1.85","v":{"$error":"#VALUE!"}},null,"Bare Pole speed long.",{"$f":"1.85*($D$16/(0.8*G53+G57))^0.5","v":{"$error":"#DIV/0!"}}]
[null,"vBP",null,null,"vBP"]
[]
["Lesser value of vBP in roll and pitch= ",null,null,{"$f":"MIN(C59,F59)","v":{"$error":"#VALUE!"}}]

{"sheet":"Worksheet 13","index":14,"n_rows":366,"n_cols":10,"rows_kept":366,"merged":[[0,8,0,9],[2,0,2,6],[4,0,4,6],[6,5,6,6],[18,2,18,3],[18,5,18,6],[19,0,21,0],[19,1,21,1],[19,4,21,4],[22,0,24,0],[22,1,24,1],[22,4,24,4],[25,0,27,0],[25,1,27,1],[25,4,27,4],[28,0,30,0],[28,1,30,1],[28,4,30,4],[31,0,33,0],[31,1,33,1],[31,4,33,4],[34,0,36,0],[34,1,36,1],[34,4,36,4],[37,0,39,0],[37,1,39,1],[37,4,39,4],[40,0,42,0],[40,1,42,1],[40,4,42,4],[48,1,49,1],[48,5,49,5],[51,0,51,6],[54,2,54,3],[54,5,54,6],[55,0,57,0],[55,1,57,1],[55,4,57,4],[58,0,60,0],[58,1,60,1],[58,4,60,4],[61,0,63,0],[61,1,63,1],[61,4,63,4],[64,0,66,0],[64,1,66,1],[64,4,66,4],[67,0,69,0],[67,1,69,1],[67,4,69,4],[70,0,72,0],[70,1,72,1],[70,4,72,4],[73,0,75,0],[73,1,75,1],[73,4,75,4],[76,0,78,0],[76,1,78,1],[76,4,78,4],[84,1,85,1],[84,5,85,5],[88,2,88,3],[88,5,88,6],[89,0,91,0],[89,1,91,1],[89,4,91,4],[92,0,94,0],[92,1,94,1],[92,4,94,4],[95,0,97,0],[95,1,97,1],[95,4,97,4],[98,0,100,0],[98,1,100,1],[98,4,100,4],[101,0,103,0],[101,1,103,1],[101,4,103,4],[104,0,106,0],[104,1,106,1],[104,4,106,4],[107,0,109,0],[107,1,109,1],[107,4,109,4],[110,0,112,0],[110,1,112,1],[110,4,112,4],[118,1,119,1],[118,5,119,5],[121,0,121,6],[124,2,124,3],[124,5,124,6],[125,0,127,0],[125,1,127,1],[125,4,127,4],[128,0,130,0],[128,1,130,1],[128,4,130,4],[131,0,133,0],[131,1,133,1],[131,4,133,4],[134,0,136,0],[134,1,136,1],[134,4,136,4],[137,0,139,0],[137,1,139,1],[137,4,139,4],[140,0,142,0],[140,1,142,1],[140,4,142,4],[143,0,145,0],[143,1,145,1],[143,4,145,4],[146,0,148,0],[146,1,148,1],[146,4,148,4],[154,1,155,1],[154,5,155,5],[158,2,158,3],[158,5,158,6],[159,0,161,0],[159,1,161,1],[159,4,161,4],[162,0,164,0],[162,1,164,1],[162,4,164,4],[165,0,167,0],[165,1,167,1],[165,4,167,4],[168,0,170,0],[168,1,170,1],[168,4,170,4],[171,0,173,0],[171,1,173,1],[171,4,173,4],[174,0,176,0],[174,1,176,1],[174,4,176,4],[177,0,179,0],[177,1,179,1],[177,4,179,4],[180,0,182,0],[180,1,182,1],[180,4,182,4],[188,1,189,1],[188,5,189,5],[191,0,191,6],[194,2,194,3],[194,5,194,6],[195,0,197,0],[195,1,197,1],[195,4,197,4],[198,0,200,0],[198,1,200,1],[198,4,200,4],[201,0,203,0],[201,1,203,1],[201,4,203,4],[204,0,206,0],[204,1,206,1],[204,4,206,4],[207,0,209,0],[207,1,209,1],[207,4,209,4],[210,0,212,0],[210,1,212,1],[210,4,212,4],[213,0,215,0],[213,1,215,1],[213,4,215,4],[216,0,218,0],[216,1,218,1],[216,4,218,4],[224,1,225,1],[224,5,225,5],[228,2,228,3],[228,5,228,6],[229,0,231,0],[229,1,231,1],[229,4,231,4],[232,0,234,0],[232,1,234,1],[232,4,234,4],[235,0,237,0],[235,1,237,1],[235,4,237,4],[238,0,240,0],[238,1,240,1],[238,4,240,4],[241,0,243,0],[241,1,243,1],[241,4,243,4],[244,0,246,0],[244,1,246,1],[244,4,246,4],[247,0,249,0],[247,1,249,1],[247,4,249,4],[250,0,252,0],[250,1,252,1],[250,4,252,4],[258,1,259,1],[258,5,259,5],[261,0,261,6],[264,2,264,3],[264,5,264,6],[265,0,267,0],[265,1,267,1],[265,4,267,4],[268,0,270,0],[268,1,270,1],[268,4,270,4],[271,0,273,0],[271,1,273,1],[271,4,273,4],[274,0,276,0],[274,1,276,1],[274,4,276,4],[277,0,279,0],[277,1,279,1],[277,4,279,4],[280,0,282,0],[280,1,282,1],[280,4,282,4],[283,0,285,0],[283,1,285,1],[283,4,285,4],[286,0,288,0],[286,1,288,1],[286,4,288,4],[294,1,295,1],[294,5,295,5],[298,2,298,3],[298,5,298,6],[299,0,301,0],[299,1,301,1],[299,4,301,4],[302,0,304,0],[302,1,304,1],[302,4,304,4],[305,0,307,0],[305,1,307,1],[305,4,307,4],[308,0,310,0],[308,1,310,1],[308,4,310,4],[311,0,313,0],[311,1,313,1],[311,4,313,4],[314,0,316,0],[314,1,316,1],[314,4,316,4],[317,0,319,0],[317,1,319,1],[317,4,319,4],[320,0,322,0],[320,1,322,1],[320,4,322,4],[328,1,329,1],[328,5,329,5],[331,0,331,6],[334,2,334,3],[334,5,334,6],[335,0,337,0],[335,1,337,1],[335,4,337,4],[338,0,340,0],[338,1,340,1],[338,4,340,4],[341,0,343,0],[341,1,343,1],[341,4,343,4],[344,0,346,0],[344,1,346,1],[344,4,346,4],[347,0,349,0],[347,1,349,1],[347,4,349,4],[350,0,352,0],[350,1,352,1],[350,4,352,4],[353,0,355,0],[353,1,355,1],[353,4,355,4],[356,0,358,0],[356,1,358,1],[356,4,358,4],[364,1,365,1],[364,5,365,5]]}
[{"$nulls":8},"Comments"]
[{"$nulls":9},"Derived values"]
["ISO 12217-2:2017   CALCULATION  WORKSHEET  No. 13                     WIND SPEED LIMITS",{"$nulls":8},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "},{"$nulls":7},"Please fill in for every possible sail combination"]
[]
["Mass of boat in minimum operating condition","mMO","kg",{"$f":"'Worksheet 1'!I44","v":0},null,"acc. to Annex G",null,null,"please check if printout of all pages is necessary"]
["Length","LH","m",{"$f":"'Worksheet 1'!I10","v":{"v":0,"d":"0.00"}}]
["Lenght of waterline in mMO","LWL (MO)","m",{"$f":"'Worksheet 12'!D9","v":{"v":0,"d":"0.00"}},{"$nulls":4},"This information can be calculated using Annex G (which includes a margin for gusts), or"]
["Beam of waterline","BWL","m",{"$f":"'Worksheet 12'!D10","v":0},{"$nulls":4},"alternatively be derived from sailing trials. The method of determination shall be stated."]
["Beam between centres of buoyancy of hulls","BCB","m",{"$f":"'Worksheet 2'!I13","v":{"v":0,"d":"0.00"}},{"$nulls":4},"If derived from sailing trials, the wind strength quoted in the owner’s manual shall correspond to a"]
["Height of CG above bottom of canoe body","VCG","m",{"$f":"'Worksheet 12'!D12","v":0},{"$nulls":4},"wind speed of not greater than 70 % of that required to"]
["Limiting trim angle","ΘL","°",{"$f":"'Worksheet 12'!D13","v":0},{"$nulls":4},"1) lift the windward hull of catamarans out of the water, or"]
["Estimated angle of heel of maximum GZ","ΦGzmax","°",{"$f":"'Worksheet 12'!D14","v":"value req"},{"$nulls":4},"2) lift the main hull of trimarans out of the water, or submerge the leeward sidehull, whichever"]
["Limiting moment Transverse","LMT","Nm",{"$f":"9.4*D7*((0.5*D11*COS(PI()*D14/180))-(D12*SIN(PI()*D14/180)))","v":{"$error":"#VALUE!"}},{"$nulls":4},"occurs sooner, or"]
["Limiting moment Longitudinal","LML","Nm",{"$f":"D13*D10*(D8+D9)^3/3","v":0},{"$nulls":4},"3) for form-stable monohulls, heel the boat to the angle at which the righting moment is maximum."]
[]
["Wind speed moments (sail combination 1)"]
[null,"sail","Transverse",null,"sail","Longitudinal"]
["Sail Nr 1",null,"area (m²)",null,{"$f":"IF(B20=\"\",\"\",B20)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D20*D21","v":0},null,"moment",{"$f":"G20*G21","v":0}]
["Sail Nr 2",null,"area (m²)",null,{"$f":"IF(B23=\"\",\"\",B23)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D23*D24","v":0},null,"moment",{"$f":"G23*G24","v":0}]
["Sail Nr 3",null,"area (m²)",null,{"$f":"IF(B26=\"\",\"\",B26)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D26*D27","v":0},null,"moment",{"$f":"G26*G27","v":0}]
["Sail Nr 4",null,"area (m²)",null,{"$f":"IF(B29=\"\",\"\",B29)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D29*D30","v":0},null,"moment",{"$f":"G29*G30","v":0}]
["Sail stowed on boom 5",null,"area (m²)",null,{"$f":"IF(B32=\"\",\"\",B32)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D32*D33","v":0},null,"moment",{"$f":"G32*G33","v":0}]
["Sail stowed on boom 6",null,"area (m²)",null,{"$f":"IF(B35=\"\",\"\",B35)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D35*D36","v":0},null,"moment",{"$f":"G35*G36","v":0}]
["Roller furled sail 7",null,"area (m²)",null,{"$f":"IF(B38=\"\",\"\",B38)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D38*D39","v":0},null,"moment",{"$f":"G38*G39","v":0}]
["Roller furled sail 8",null,"area (m²)",null,{"$f":"IF(B41=\"\",\"\",B41)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D41*D42","v":0},null,"moment",{"$f":"G41*G42","v":0}]
[]
[null,null,"Total sail moments of area ΣAS hS",{"$f":"D22+D25+D28+D31+D34+D37+D40+D43","v":0},null,"ΣAS hS",{"$f":"G22+G25+G28+G31+G34+G37+G40+G43","v":0}]
[]
[null,null,"Total hull & rig moments of area  ΣAH hH",{"$f":"'Worksheet 12'!$D$41","v":0},null,"ΣAH hH",{"$f":"'Worksheet 12'!$G$41","v":0}]
[]
["Wind speed limit transversal    .",{"$f":"1.85*($D$15/(0.8*D47+D45))^0.5","v":{"$error":"#VALUE!"}},null,null,"Wind speed limit longitudinal   .",{"$f":"1.85*($D$16/(0.8*G47+G45))^0.5","v":{"$error":"#DIV/0!"}}]
["vW (knots)      .",{"$nulls":3},"vW (knots)     ."]
[]
[{"$f":"A5","v":"          "}]
[]
["Wind speed moments (sail combination 2)"]
[null,"sail","Transverse",null,"sail","Longitudinal"]
["Sail Nr 1",null,"area (m²)",null,{"$f":"IF(B56=\"\",\"\",B56)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D56*D57","v":0},null,"moment",{"$f":"G56*G57","v":0}]
["Sail Nr 2",null,"area (m²)",null,{"$f":"IF(B59=\"\",\"\",B59)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D59*D60","v":0},null,"moment",{"$f":"G59*G60","v":0}]
["Sail Nr 3",null,"area (m²)",null,{"$f":"IF(B62=\"\",\"\",B62)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D62*D63","v":0},null,"moment",{"$f":"G62*G63","v":0}]
["Sail Nr 4",null,"area (m²)",null,{"$f":"IF(B65=\"\",\"\",B65)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D65*D66","v":0},null,"moment",{"$f":"G65*G66","v":0}]
["Sail stowed on boom 5",null,"area (m²)",null,{"$f":"IF(B68=\"\",\"\",B68)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D68*D69","v":0},null,"moment",{"$f":"G68*G69","v":0}]
["Sail stowed on boom 6",null,"area (m²)",null,{"$f":"IF(B71=\"\",\"\",B71)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D71*D72","v":0},null,"moment",{"$f":"G71*G72","v":0}]
["Roller furled sail 7",null,"area (m²)",null,{"$f":"IF(B74=\"\",\"\",B74)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D74*D75","v":0},null,"moment",{"$f":"G74*G75","v":0}]
["Roller furled sail 8",null,"area (m²)",null,{"$f":"IF(B77=\"\",\"\",B77)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D77*D78","v":0},null,"moment",{"$f":"G77*G78","v":0}]
[]
[null,null,"Total sail moments of area ΣAS hS",{"$f":"D58+D61+D64+D67+D70+D73+D76+D79","v":0},null,"ΣAS hS",{"$f":"G58+G61+G64+G67+G70+G73+G76+G79","v":0}]
[]
[null,null,"Total hull & rig moments of area  ΣAH hH",{"$f":"'Worksheet 12'!$D$41","v":0},null,"ΣAH hH",{"$f":"'Worksheet 12'!$G$41","v":0}]
[]
["Wind speed limit transversal    .",{"$f":"1.85*($D$15/(0.8*D83+D81))^0.5","v":{"$error":"#VALUE!"}},null,null,"Wind speed limit longitudinal   .",{"$f":"1.85*($D$16/(0.8*G83+G81))^0.5","v":{"$error":"#DIV/0!"}}]
["vW (knots)      .",{"$nulls":3},"vW (knots)     ."]
[]
["Wind speed moments (sail combination 3)"]
[null,"sail","Transverse",null,"sail","Longitudinal"]
["Sail Nr 1",null,"area (m²)",null,{"$f":"IF(B90=\"\",\"\",B90)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D90*D91","v":0},null,"moment",{"$f":"G90*G91","v":0}]
["Sail Nr 2",null,"area (m²)",null,{"$f":"IF(B93=\"\",\"\",B93)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D93*D94","v":0},null,"moment",{"$f":"G93*G94","v":0}]
["Sail Nr 3",null,"area (m²)",null,{"$f":"IF(B96=\"\",\"\",B96)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D96*D97","v":0},null,"moment",{"$f":"G96*G97","v":0}]
["Sail Nr 4",null,"area (m²)",null,{"$f":"IF(B99=\"\",\"\",B99)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D99*D100","v":0},null,"moment",{"$f":"G99*G100","v":0}]
["Sail stowed on boom 5",null,"area (m²)",null,{"$f":"IF(B102=\"\",\"\",B102)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D102*D103","v":0},null,"moment",{"$f":"G102*G103","v":0}]
["Sail stowed on boom 6",null,"area (m²)",null,{"$f":"IF(B105=\"\",\"\",B105)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D105*D106","v":0},null,"moment",{"$f":"G105*G106","v":0}]
["Roller furled sail 7",null,"area (m²)",null,{"$f":"IF(B108=\"\",\"\",B108)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D108*D109","v":0},null,"moment",{"$f":"G108*G109","v":0}]
["Roller furled sail 8",null,"area (m²)",null,{"$f":"IF(B111=\"\",\"\",B111)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D111*D112","v":0},null,"moment",{"$f":"G111*G112","v":0}]
[]
[null,null,"Total sail moments of area ΣAS hS",{"$f":"D92+D95+D98+D101+D104+D107+D110+D113","v":0},null,"ΣAS hS",{"$f":"G92+G95+G98+G101+G104+G107+G110+G113","v":0}]
[]
[null,null,"Total hull & rig moments of area  ΣAH hH",{"$f":"'Worksheet 12'!$D$41","v":0},null,"ΣAH hH",{"$f":"'Worksheet 12'!$G$41","v":0}]
[]
["Wind speed limit transversal    .",{"$f":"1.85*($D$15/(0.8*D117+D115))^0.5","v":{"$error":"#VALUE!"}},null,null,"Wind speed limit longitudinal   .",{"$f":"1.85*($D$16/(0.8*G117+G115))^0.5","v":{"$error":"#DIV/0!"}}]
["vW (knots)      .",{"$nulls":3},"vW (knots)     ."]
[]
[{"$f":"A5","v":"          "}]
[]
["Wind speed moments (sail combination 4)"]
[null,"sail","Transverse",null,"sail","Longitudinal"]
["Sail Nr 1",null,"area (m²)",null,{"$f":"IF(B126=\"\",\"\",B126)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D126*D127","v":0},null,"moment",{"$f":"G126*G127","v":0}]
["Sail Nr 2",null,"area (m²)",null,{"$f":"IF(B129=\"\",\"\",B129)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D129*D130","v":0},null,"moment",{"$f":"G129*G130","v":0}]
["Sail Nr 3",null,"area (m²)",null,{"$f":"IF(B132=\"\",\"\",B132)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D132*D133","v":0},null,"moment",{"$f":"G132*G133","v":0}]
["Sail Nr 4",null,"area (m²)",null,{"$f":"IF(B135=\"\",\"\",B135)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D135*D136","v":0},null,"moment",{"$f":"G135*G136","v":0}]
["Sail stowed on boom 5",null,"area (m²)",null,{"$f":"IF(B138=\"\",\"\",B138)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D138*D139","v":0},null,"moment",{"$f":"G138*G139","v":0}]
["Sail stowed on boom 6",null,"area (m²)",null,{"$f":"IF(B141=\"\",\"\",B141)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D141*D142","v":0},null,"moment",{"$f":"G141*G142","v":0}]
["Roller furled sail 7",null,"area (m²)",null,{"$f":"IF(B144=\"\",\"\",B144)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D144*D145","v":0},null,"moment",{"$f":"G144*G145","v":0}]
["Roller furled sail 8",null,"area (m²)",null,{"$f":"IF(B147=\"\",\"\",B147)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D147*D148","v":0},null,"moment",{"$f":"G147*G148","v":0}]
[]
[null,null,"Total sail moments of area ΣAS hS",{"$f":"D128+D131+D134+D137+D140+D143+D146+D149","v":0},null,"ΣAS hS",{"$f":"G128+G131+G134+G137+G140+G143+G146+G149","v":0}]
[]
[null,null,"Total hull & rig moments of area  ΣAH hH",{"$f":"'Worksheet 12'!$D$41","v":0},null,"ΣAH hH",{"$f":"'Worksheet 12'!$G$41","v":0}]
[]
["Wind speed limit transversal    .",{"$f":"1.85*($D$15/(0.8*D153+D151))^0.5","v":{"$error":"#VALUE!"}},null,null,"Wind speed limit longitudinal   .",{"$f":"1.85*($D$16/(0.8*G153+G151))^0.5","v":{"$error":"#DIV/0!"}}]
["vW (knots)      .",{"$nulls":3},"vW (knots)     ."]
[]
["Wind speed moments (sail combination 5)"]
[null,"sail","Transverse",null,"sail","Longitudinal"]
["Sail Nr 1",null,"area (m²)",null,{"$f":"IF(B160=\"\",\"\",B160)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D160*D161","v":0},null,"moment",{"$f":"G160*G161","v":0}]
["Sail Nr 2",null,"area (m²)",null,{"$f":"IF(B163=\"\",\"\",B163)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D163*D164","v":0},null,"moment",{"$f":"G163*G164","v":0}]
["Sail Nr 3",null,"area (m²)",null,{"$f":"IF(B166=\"\",\"\",B166)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D166*D167","v":0},null,"moment",{"$f":"G166*G167","v":0}]
["Sail Nr 4",null,"area (m²)",null,{"$f":"IF(B169=\"\",\"\",B169)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D169*D170","v":0},null,"moment",{"$f":"G169*G170","v":0}]
["Sail stowed on boom 5",null,"area (m²)",null,{"$f":"IF(B172=\"\",\"\",B172)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D172*D173","v":0},null,"moment",{"$f":"G172*G173","v":0}]
["Sail stowed on boom 6",null,"area (m²)",null,{"$f":"IF(B175=\"\",\"\",B175)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D175*D176","v":0},null,"moment",{"$f":"G175*G176","v":0}]
["Roller furled sail 7",null,"area (m²)",null,{"$f":"IF(B178=\"\",\"\",B178)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D178*D179","v":0},null,"moment",{"$f":"G178*G179","v":0}]
["Roller furled sail 8",null,"area (m²)",null,{"$f":"IF(B181=\"\",\"\",B181)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D181*D182","v":0},null,"moment",{"$f":"G181*G182","v":0}]
[]
[null,null,"Total sail moments of area ΣAS hS",{"$f":"D162+D165+D168+D171+D174+D177+D180+D183","v":0},null,"ΣAS hS",{"$f":"G162+G165+G168+G171+G174+G177+G180+G183","v":0}]
[]
[null,null,"Total hull & rig moments of area  ΣAH hH",{"$f":"'Worksheet 12'!$D$41","v":0},null,"ΣAH hH",{"$f":"'Worksheet 12'!$G$41","v":0}]
[]
["Wind speed limit transversal    .",{"$f":"1.85*($D$15/(0.8*D187+D185))^0.5","v":{"$error":"#VALUE!"}},null,null,"Wind speed limit longitudinal   .",{"$f":"1.85*($D$16/(0.8*G187+G185))^0.5","v":{"$error":"#DIV/0!"}}]
["vW (knots)      .",{"$nulls":3},"vW (knots)     ."]
[]
[{"$f":"$A$5","v":"          "}]
[]
["Wind speed moments (sail combination 6)"]
[null,"sail","Transverse",null,"sail","Longitudinal"]
["Sail Nr 1",null,"area (m²)",null,{"$f":"IF(B196=\"\",\"\",B196)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D196*D197","v":0},null,"moment",{"$f":"G196*G197","v":0}]
["Sail Nr 2",null,"area (m²)",null,{"$f":"IF(B199=\"\",\"\",B199)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D199*D200","v":0},null,"moment",{"$f":"G199*G200","v":0}]
["Sail Nr 3",null,"area (m²)",null,{"$f":"IF(B202=\"\",\"\",B202)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D202*D203","v":0},null,"moment",{"$f":"G202*G203","v":0}]
["Sail Nr 4",null,"area (m²)",null,{"$f":"IF(B205=\"\",\"\",B205)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D205*D206","v":0},null,"moment",{"$f":"G205*G206","v":0}]
["Sail stowed on boom 5",null,"area (m²)",null,{"$f":"IF(B208=\"\",\"\",B208)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D208*D209","v":0},null,"moment",{"$f":"G208*G209","v":0}]
["Sail stowed on boom 6",null,"area (m²)",null,{"$f":"IF(B211=\"\",\"\",B211)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D211*D212","v":0},null,"moment",{"$f":"G211*G212","v":0}]
["Roller furled sail 7",null,"area (m²)",null,{"$f":"IF(B214=\"\",\"\",B214)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D214*D215","v":0},null,"moment",{"$f":"G214*G215","v":0}]
["Roller furled sail 8",null,"area (m²)",null,{"$f":"IF(B217=\"\",\"\",B217)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D217*D218","v":0},null,"moment",{"$f":"G217*G218","v":0}]
[]
[null,null,"Total sail moments of area ΣAS hS",{"$f":"D198+D201+D204+D207+D210+D213+D216+D219","v":0},null,"ΣAS hS",{"$f":"G198+G201+G204+G207+G210+G213+G216+G219","v":0}]
[]
[null,null,"Total hull & rig moments of area  ΣAH hH",{"$f":"'Worksheet 12'!$D$41","v":0},null,"ΣAH hH",{"$f":"'Worksheet 12'!$G$41","v":0}]
[]
["Wind speed limit transversal    .",{"$f":"1.85*($D$15/(0.8*D223+D221))^0.5","v":{"$error":"#VALUE!"}},null,null,"Wind speed limit longitudinal   .",{"$f":"1.85*($D$16/(0.8*G223+G221))^0.5","v":{"$error":"#DIV/0!"}}]
["vW (knots)      .",{"$nulls":3},"vW (knots)     ."]
[]
["Wind speed moments (sail combination 7)"]
[null,"sail","Transverse",null,"sail","Longitudinal"]
["Sail Nr 1",null,"area (m²)",null,{"$f":"IF(B230=\"\",\"\",B230)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D230*D231","v":0},null,"moment",{"$f":"G230*G231","v":0}]
["Sail Nr 2",null,"area (m²)",null,{"$f":"IF(B233=\"\",\"\",B233)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D233*D234","v":0},null,"moment",{"$f":"G233*G234","v":0}]
["Sail Nr 3",null,"area (m²)",null,{"$f":"IF(B236=\"\",\"\",B236)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D236*D237","v":0},null,"moment",{"$f":"G236*G237","v":0}]
["Sail Nr 4",null,"area (m²)",null,{"$f":"IF(B239=\"\",\"\",B239)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D239*D240","v":0},null,"moment",{"$f":"G239*G240","v":0}]
["Sail stowed on boom 5",null,"area (m²)",null,{"$f":"IF(B242=\"\",\"\",B242)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D242*D243","v":0},null,"moment",{"$f":"G242*G243","v":0}]
["Sail stowed on boom 6",null,"area (m²)",null,{"$f":"IF(B245=\"\",\"\",B245)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D245*D246","v":0},null,"moment",{"$f":"G245*G246","v":0}]
["Roller furled sail 7",null,"area (m²)",null,{"$f":"IF(B248=\"\",\"\",B248)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D248*D249","v":0},null,"moment",{"$f":"G248*G249","v":0}]
["Roller furled sail 8",null,"area (m²)",null,{"$f":"IF(B251=\"\",\"\",B251)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D251*D252","v":0},null,"moment",{"$f":"G251*G252","v":0}]
[]
[null,null,"Total sail moments of area ΣAS hS",{"$f":"D232+D235+D238+D241+D244+D247+D250+D253","v":0},null,"ΣAS hS",{"$f":"G232+G235+G238+G241+G244+G247+G250+G253","v":0}]
[]
[null,null,"Total hull & rig moments of area  ΣAH hH",{"$f":"'Worksheet 12'!$D$41","v":0},null,"ΣAH hH",{"$f":"'Worksheet 12'!$G$41","v":0}]
[]
["Wind speed limit transversal    .",{"$f":"1.85*($D$15/(0.8*D257+D255))^0.5","v":{"$error":"#VALUE!"}},null,null,"Wind speed limit longitudinal   .",{"$f":"1.85*($D$16/(0.8*G257+G255))^0.5","v":{"$error":"#DIV/0!"}}]
["vW (knots)      .",{"$nulls":3},"vW (knots)     ."]
[]
[{"$f":"$A$5","v":"          "}]
[]
["Wind speed moments (sail combination 8)"]
[null,"sail","Transverse",null,"sail","Longitudinal"]
["Sail Nr 1",null,"area (m²)",null,{"$f":"IF(B266=\"\",\"\",B266)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D266*D267","v":0},null,"moment",{"$f":"G266*G267","v":0}]
["Sail Nr 2",null,"area (m²)",null,{"$f":"IF(B269=\"\",\"\",B269)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D269*D270","v":0},null,"moment",{"$f":"G269*G270","v":0}]
["Sail Nr 3",null,"area (m²)",null,{"$f":"IF(B272=\"\",\"\",B272)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D272*D273","v":0},null,"moment",{"$f":"G272*G273","v":0}]
["Sail Nr 4",null,"area (m²)",null,{"$f":"IF(B275=\"\",\"\",B275)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D275*D276","v":0},null,"moment",{"$f":"G275*G276","v":0}]
["Sail stowed on boom 5",null,"area (m²)",null,{"$f":"IF(B278=\"\",\"\",B278)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D278*D279","v":0},null,"moment",{"$f":"G278*G279","v":0}]
["Sail stowed on boom 6",null,"area (m²)",null,{"$f":"IF(B281=\"\",\"\",B281)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D281*D282","v":0},null,"moment",{"$f":"G281*G282","v":0}]
["Roller furled sail 7",null,"area (m²)",null,{"$f":"IF(B284=\"\",\"\",B284)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D284*D285","v":0},null,"moment",{"$f":"G284*G285","v":0}]
["Roller furled sail 8",null,"area (m²)",null,{"$f":"IF(B287=\"\",\"\",B287)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D287*D288","v":0},null,"moment",{"$f":"G287*G288","v":0}]
[]
[null,null,"Total sail moments of area ΣAS hS",{"$f":"D268+D271+D274+D277+D280+D283+D286+D289","v":0},null,"ΣAS hS",{"$f":"G268+G271+G274+G277+G280+G283+G286+G289","v":0}]
[]
[null,null,"Total hull & rig moments of area  ΣAH hH",{"$f":"'Worksheet 12'!$D$41","v":0},null,"ΣAH hH",{"$f":"'Worksheet 12'!$G$41","v":0}]
[]
["Wind speed limit transversal    .",{"$f":"1.85*($D$15/(0.8*D293+D291))^0.5","v":{"$error":"#VALUE!"}},null,null,"Wind speed limit longitudinal   .",{"$f":"1.85*($D$16/(0.8*G293+G291))^0.5","v":{"$error":"#DIV/0!"}}]
["vW (knots)      .",{"$nulls":3},"vW (knots)     ."]
[]
["Wind speed moments (sail combination 9)"]
[null,"sail","Transverse",null,"sail","Longitudinal"]
["Sail Nr 1",null,"area (m²)",null,{"$f":"IF(B300=\"\",\"\",B300)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D300*D301","v":0},null,"moment",{"$f":"G300*G301","v":0}]
["Sail Nr 2",null,"area (m²)",null,{"$f":"IF(B303=\"\",\"\",B303)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D303*D304","v":0},null,"moment",{"$f":"G303*G304","v":0}]
["Sail Nr 3",null,"area (m²)",null,{"$f":"IF(B306=\"\",\"\",B306)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D306*D307","v":0},null,"moment",{"$f":"G306*G307","v":0}]
["Sail Nr 4",null,"area (m²)",null,{"$f":"IF(B309=\"\",\"\",B309)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D309*D310","v":0},null,"moment",{"$f":"G309*G310","v":0}]
["Sail stowed on boom 5",null,"area (m²)",null,{"$f":"IF(B312=\"\",\"\",B312)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D312*D313","v":0},null,"moment",{"$f":"G312*G313","v":0}]
["Sail stowed on boom 6",null,"area (m²)",null,{"$f":"IF(B315=\"\",\"\",B315)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D315*D316","v":0},null,"moment",{"$f":"G315*G316","v":0}]
["Roller furled sail 7",null,"area (m²)",null,{"$f":"IF(B318=\"\",\"\",B318)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D318*D319","v":0},null,"moment",{"$f":"G318*G319","v":0}]
["Roller furled sail 8",null,"area (m²)",null,{"$f":"IF(B321=\"\",\"\",B321)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D321*D322","v":0},null,"moment",{"$f":"G321*G322","v":0}]
[]
[null,null,"Total sail moments of area ΣAS hS",{"$f":"D302+D305+D308+D311+D314+D317+D320+D323","v":0},null,"ΣAS hS",{"$f":"G302+G305+G308+G311+G314+G317+G320+G323","v":0}]
[]
[null,null,"Total hull & rig moments of area  ΣAH hH",{"$f":"'Worksheet 12'!$D$41","v":0},null,"ΣAH hH",{"$f":"'Worksheet 12'!$G$41","v":0}]
[]
["Wind speed limit transversal    .",{"$f":"1.85*($D$15/(0.8*D327+D325))^0.5","v":{"$error":"#VALUE!"}},null,null,"Wind speed limit longitudinal   .",{"$f":"1.85*($D$16/(0.8*G327+G325))^0.5","v":{"$error":"#DIV/0!"}}]
["vW (knots)      .",{"$nulls":3},"vW (knots)     ."]
[]
[{"$f":"$A$5","v":"          "}]
[]
["Wind speed moments (sail combination 10)"]
[null,"sail","Transverse",null,"sail","Longitudinal"]
["Sail Nr 1",null,"area (m²)",null,{"$f":"IF(B336=\"\",\"\",B336)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D336*D337","v":0},null,"moment",{"$f":"G336*G337","v":0}]
["Sail Nr 2",null,"area (m²)",null,{"$f":"IF(B339=\"\",\"\",B339)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D339*D340","v":0},null,"moment",{"$f":"G339*G340","v":0}]
["Sail Nr 3",null,"area (m²)",null,{"$f":"IF(B342=\"\",\"\",B342)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D342*D343","v":0},null,"moment",{"$f":"G342*G343","v":0}]
["Sail Nr 4",null,"area (m²)",null,{"$f":"IF(B345=\"\",\"\",B345)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D345*D346","v":0},null,"moment",{"$f":"G345*G346","v":0}]
["Sail stowed on boom 5",null,"area (m²)",null,{"$f":"IF(B348=\"\",\"\",B348)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D348*D349","v":0},null,"moment",{"$f":"G348*G349","v":0}]
["Sail stowed on boom 6",null,"area (m²)",null,{"$f":"IF(B351=\"\",\"\",B351)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D351*D352","v":0},null,"moment",{"$f":"G351*G352","v":0}]
["Roller furled sail 7",null,"area (m²)",null,{"$f":"IF(B354=\"\",\"\",B354)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D354*D355","v":0},null,"moment",{"$f":"G354*G355","v":0}]
["Roller furled sail 8",null,"area (m²)",null,{"$f":"IF(B357=\"\",\"\",B357)","v":""},"area (m²)"]
[null,null,"lever (m)",null,null,"lever (m)"]
[null,null,"moment",{"$f":"D357*D358","v":0},null,"moment",{"$f":"G357*G358","v":0}]
[]
[null,null,"Total sail moments of area ΣAS hS",{"$f":"D338+D341+D344+D347+D350+D353+D356+D359","v":0},null,"ΣAS hS",{"$f":"G338+G341+G344+G347+G350+G353+G356+G359","v":0}]
[]
[null,null,"Total hull & rig moments of area  ΣAH hH",{"$f":"'Worksheet 12'!$D$41","v":0},null,"ΣAH hH",{"$f":"'Worksheet 12'!$G$41","v":0}]
[]
["Wind speed limit transversal    .",{"$f":"1.85*($D$15/(0.8*D363+D361))^0.5","v":{"$error":"#VALUE!"}},null,null,"Wind speed limit longitudinal   .",{"$f":"1.85*($D$16/(0.8*G363+G361))^0.5","v":{"$error":"#DIV/0!"}}]
["vW (knots)      .",{"$nulls":3},"vW (knots)     ."]

{"sheet":"Worksheet 14","index":15,"n_rows":43,"n_cols":53,"rows_kept":43,"merged":[[0,0,0,6],[0,12,0,13],[1,0,1,6],[3,0,3,6],[4,0,4,6],[5,1,5,2],[5,3,5,5],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,7,5],[7,6,8,6],[10,3,10,5],[11,1,12,1],[11,2,12,2],[11,3,12,5],[11,6,12,6],[12,26,12,32],[14,0,14,6],[16,3,16,5],[17,1,17,2],[20,4,20,5],[21,0,21,6],[21,26,21,32],[22,0,22,1],[23,0,23,1],[23,3,23,5],[24,0,24,1],[26,0,26,1],[28,0,28,6],[29,0,29,1],[30,0,30,1],[30,3,30,4],[31,0,31,1],[31,3,31,4],[32,0,32,1],[34,0,34,1],[34,5,34,6],[35,0,35,2],[35,4,35,5],[36,0,36,2],[36,4,36,5],[37,0,37,2],[37,4,37,5],[38,0,38,2],[38,4,38,5],[39,0,39,2],[39,4,39,5],[40,0,40,6],[41,0,41,2],[41,4,41,5],[42,0,42,2],[42,4,42,5],[43,1,43,2],[43,4,43,5]]}
[{"$nulls":12},"Comments"]
["ISO 12217-2:2017  CALCULATION WORKSHEET No. 14      STABILITY REQUIREMENTS",{"$nulls":12},"Derived values"]
[{"$nulls":13},"Input values"]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[{"$nulls":52},"list:"]
["Boat is a catamaran / trimaran: ",null,null,"Intended design category:",null,null,{"$f":"'Worksheet 1'!D8","v":0},{"$nulls":45},"Yes"]
[{"$nulls":52},"No"]
["Item","Symbol","Unit","Value",null,null,"ref."]
[{"$nulls":3},"cat A","cat B","cat C"]
["Bare poles factor",{"$nulls":51},"cat"]
["Bare poles wind speed (see worksheet 12)","VBP","knots",{"$f":"'Worksheet 12'!D62","v":{"$error":"#VALUE!"}},null,null,"7.7",{"$nulls":45},"tri"]
["Barepoles factor = (vBP / 70)0,4  where vBP < 70","BPF","-",{"$f":"IF(D11>70,1,(D11/70)^0.4)","v":{"$error":"#VALUE!"}},null,null,"7.7 b)"]
["Barepoles factor = 1  where vBP  ≥ 70",{"$nulls":25},"Rolling in bracking waves",{"$nulls":25},"7.11.2.a"]
[{"$nulls":26},"clause 7.8 Table 8",{"$nulls":25},"7.11.2.b"]
["Rolling in bracking waves",{"$nulls":25},"A","B","C",{"$nulls":23},"7.11.2.c"]
["Required maximum transverse righting lever","GZ","m",{"$f":"IF($B$6=\"cat\",1.85/$D$12,2.9/$D$12)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$6=\"cat\",1.3/$D$12,2.2/$D$12)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$6=\"cat\",0.7/$D$12,1.5/$D$12)","v":{"$error":"#VALUE!"}},"Table 8",{"$nulls":19},{"$f":"IF($B$6=\"cat\",1.85*$D$12,2.9*$D$12)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$6=\"cat\",1.3*$D$12,2.2*$D$12)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$6=\"cat\",0.7*$D$12,1.5*$D$12)","v":{"$error":"#VALUE!"}},{"$nulls":23},"7.11.3.a"]
["Actual maximum transverse righting lever","GZmax","m",{"$nulls":49},"7.11.3.b"]
["Design category possible for rolling in breaking waves","Yes / No",null,{"$f":"IF(D17>=D16,\"Yes\",\"No\")","v":{"$error":"#VALUE!"}},{"$f":"IF(D17>=E16,\"Yes\",\"No\")","v":{"$error":"#VALUE!"}},{"$f":"IF(D17>=F16,\"Yes\",\"No\")","v":{"$error":"#VALUE!"}},"7.8",{"$nulls":45},"7.11.3.c"]
["Ratio actual / required",null,null,{"$f":"D17/D16","v":{"$error":"#VALUE!"}},{"$f":"D17/E16","v":{"$error":"#VALUE!"}},{"$f":"D17/F16","v":{"$error":"#VALUE!"}},"7.11.2-3"]
["Does ratio exceed required value for \n'not vulnerable to inversion'?",null,null,{"$f":"IF($B$6=\"cat\",IF(D19>=1.35,\"Yes\",\"No\"),IF($B$6=\"tri\",IF(D19>=1.8,\"yes\",\"No\")))","v":false},false,{"$f":"IF($B$6=\"cat\",IF(F19>=1.35,\"Yes\",\"No\"),IF($B$6=\"tri\",IF(F19>=1.8,\"yes\",\"No\")))","v":false},"7.11.2-3"]
[]
["Pitchpoling",{"$nulls":25},"Pitchpoling"]
["Required minimum longitudinal righting moment area",null,"kNm rad",{"$f":"20/$D$12","v":{"$error":"#VALUE!"}},{"$f":"7/$D$12","v":{"$error":"#VALUE!"}},{"$f":"2/$D$12","v":{"$error":"#VALUE!"}},"Table 9",{"$nulls":19},"clause 7.9 Table 9"]
["Actual minimum longitudinal righting moment area",null,"kNm rad",{"$nulls":23},"A","B","C"]
["Design category possible on pitchpoling",null,"Yes / No",{"$f":"IF(D24>=D23,\"Yes\",\"No\")","v":{"$error":"#VALUE!"}},{"$f":"IF(D24>=E23,\"Yes\",\"No\")","v":{"$error":"#VALUE!"}},{"$f":"IF(D24>=F23,\"Yes\",\"No\")","v":{"$error":"#VALUE!"}},"7.9",{"$nulls":19},{"$f":"20*$D$12","v":{"$error":"#VALUE!"}},{"$f":"7*$D$12","v":{"$error":"#VALUE!"}},{"$f":"2*$D$12","v":{"$error":"#VALUE!"}}]
["Ratio actual / required",null,null,{"$f":"D24/D23","v":{"$error":"#VALUE!"}},{"$f":"D24/E23","v":{"$error":"#VALUE!"}},{"$f":"D24/F23","v":{"$error":"#VALUE!"}},"7.11.2-3"]
["Does ratio exceed required value for \n'not vulnerable to inversion'?",null,"Yes / No",{"$f":"IF($B$6=\"cat\",IF(D26>=1.35,\"Yes\",\"No\"),IF($B$6=\"tri\",IF(D26>=1.8,\"yes\",\"No\")))","v":false},false,{"$f":"IF($B$6=\"cat\",IF(F26>=1.35,\"Yes\",\"No\"),IF($B$6=\"tri\",IF(F26>=1.8,\"yes\",\"No\")))","v":false},"7.11.2-3"]
[]
["Diagonal Stability"]
["Required transverse righting moment for 1° heel",null,"Nm",{"$f":"MAX(5000,1.1*'Worksheet 1'!I44)","v":5000},1500,"n.a.","7.10"]
["Bow-down actual transverse righting moment for 1° heel",null,"Nm",null,null,"n.a.","7.10"]
["Stern-down actual transverse righting moment for 1° heel",null,"Nm",null,null,"n.a.","7.10"]
["Design category possible on diagonal stability?",null,"Yes / No",{"$f":"IF(MIN(D31,D32)>D30,\"Yes\",\"No\")","v":"No"},{"$f":"IF(MIN(D31,D32)>E30,\"Yes\",\"No\")","v":"No"},"n.a.","7.10"]
[]
["Design category possible: rolling, pitchpoling & diag. stability?",null,"Yes / No",{"$f":"IF(AND(D18=\"yes\",D25=\"yes\",D33=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(E18=\"yes\",E25=\"yes\",E33=\"Yes\"),\"Yes\",\"No\")","v":{"$error":"#VALUE!"}}]
[]
["Habitable boats",null,null,"Unit","Answer",null,"Ref",null,"7.11.2 for catamaran, 7.11.3 for trimaran"]
["Is boat habitable?",null,null,"Yes / No",null,null,"3.1.9",null,"a) maximum transverse righting lever for the boat in the minimum operating condition is less than 135 % (180% for Trimaran) of the minimum requirement for the design category "]
["Is boat vulnerable to inversion when used in design category?",null,null,"Yes / No",null,null,"7.11.2-3",null,"b) the longitudinal righting moment area for the boat in the minimum operating condition is less than 135 % (180% for Trimaran) of the minimum requirement for the design category"]
["Clause(s) of standard that apply ref. Vulnerability to inversion",null,null,"clause",null,null,"7.11.2-3",null,"c) the wind speed at which the standard sail area is required to be reefed according to calculations performed in accordance with Annex G is less than"]
["If both the above responses with Yes, then:",{"$nulls":8},"25 kn cat A. 22kn cat B., 19kn cat C, 16 kn cat D"]
["Does boat comply with inverted buoyancy requirements?",null,null,"Yes / No",null,null,"7.12"]
["Does boat comply with viable  means of escape requirements?",null,null,"Yes / No",null,null,"7.13"]

{"sheet":"Worksheet 15","index":16,"n_rows":17,"n_cols":53,"rows_kept":17,"merged":[[0,13,0,14],[2,0,2,8],[4,0,4,8],[6,0,6,6],[7,0,7,6],[8,0,8,6],[9,0,9,6],[10,0,10,6],[11,0,11,6],[12,0,12,6],[13,0,13,6],[14,0,14,6],[15,0,15,6],[16,0,16,6]]}
[{"$nulls":13},"Comments"]
[{"$nulls":14},"Derived values"]
["ISO 12217-2:2017 CALCULATION WORKSHEET No. 15                                      DETECTION + REMOVAL OF WATER",{"$nulls":13},"Input values"]
[]
[{"$f":"CONCATENATE(coverSheet!B5,\"          \",coverSheet!B12)","v":"          "}]
[{"$nulls":52},"list:"]
["Item",{"$nulls":6},"response","Ref.",{"$nulls":43},"Yes"]
["The internal arrangement facilitates the drainage of water to bilge suction point(s), to a location from which it can be bailed rapidly, or directly overboard?                                      ",{"$nulls":7},"6.11.1",{"$nulls":43},"No"]
["Is boat provided with a means of removing water from the bilges in accordance with 15083?",{"$nulls":7},"6.11.2"]
["Table 2 option used for assessment:",{"$nulls":7},"6.11.3"]
["Can water in boat be detected from helm position?",{"$nulls":7},"6.11.3"]
["For boats in design cat C using option 3,5 or 7:                                         option (see worksheet 2):",{"$nulls":6},{"$f":"IF(OR('Worksheet 2'!E47=3,'Worksheet 2'!E47=5,'Worksheet 2'!E47=7),'Worksheet 2'!E47,\"n.a.\")","v":"n.a."},"6.11.4"]
["Methods used:                                                                                            direct visual inspection",{"$nulls":7},"6.11.3"]
["                                                                  transparent inspection panels",{"$nulls":7},"6.11.3"]
["                                                                                           bilge alarms",{"$nulls":7},"6.11.3"]
["                                  indication of the operation of automatic bilge pumps",{"$nulls":7},"6.11.3"]
["other means (specify):",{"$nulls":7},"6.11.3"]

{"sheet":"Worksheet 16","index":17,"n_rows":60,"n_cols":53,"rows_kept":60,"merged":[[0,14,0,15],[2,0,2,9],[4,2,4,9],[7,1,7,5],[7,7,7,8],[8,0,17,0],[8,7,8,8],[9,7,9,8],[10,7,10,8],[11,7,11,8],[12,7,12,8],[13,7,13,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[18,7,18,8],[20,0,20,3],[20,4,20,5],[20,7,20,8],[21,0,23,0],[21,1,23,2],[21,3,21,8],[23,3,23,8],[24,0,26,0],[24,3,24,7],[25,4,25,5],[26,4,26,5],[27,0,30,0],[27,1,27,8],[28,4,28,5],[28,7,28,8],[29,1,30,3],[29,4,30,5],[29,6,30,6],[29,7,30,8],[29,9,30,9],[31,0,32,0],[31,1,31,2],[31,3,32,5],[31,6,32,6],[31,7,32,8],[31,9,32,9],[33,0,34,0],[33,1,33,2],[33,7,33,8],[34,1,34,6],[34,7,34,8],[35,1,35,6],[35,7,35,8],[36,0,36,3],[36,4,36,5],[36,7,36,8],[37,0,40,0],[37,1,37,3],[37,4,37,5],[38,1,38,3],[38,4,38,5],[39,1,40,2],[39,4,39,5],[40,4,40,5],[41,0,46,0],[41,1,41,9],[42,1,42,6],[42,7,42,8],[43,7,43,8],[44,1,44,9],[45,1,45,6],[45,7,45,8],[46,1,46,6],[46,7,46,8],[47,1,47,6],[47,7,47,8],[48,0,50,9],[51,0,51,1],[51,4,51,9],[53,0,53,4]]}
[{"$nulls":14},"Comments"]
[{"$nulls":15},"Derived values"]
["ISO 12217-2:2017  Multihull en210801             CALCULATION WORKSHEET No.16                                              SUMMARY",{"$nulls":14},"Input values"]
[{"$nulls":26},"Yes"]
["Design Description:",null,{"$f":"coverSheet!B12","v":0},{"$nulls":23},"No"]
["Design Category intended:      ",null,{"$f":"'Worksheet 1'!D8","v":0},"Crew Limit: ",{"$f":"'Worksheet 1'!I18","v":0},null,"Date: ",{"$f":"TODAY()","v":"2022-07-28"},{"$nulls":3},"cell date will always show actual date; please overwrite if necessary"]
[]
["Sheet","Item",{"$nulls":4},"Symbol","Unit",null,"Value"]
[1,"Length of hull: (as in ISO 8666)",{"$nulls":4},"LH","m",null,{"$f":"'Worksheet 1'!I10","v":{"v":0,"d":"0.00"}}]
[null,"Length of waterline",{"$nulls":4},"LWL","m",null,{"$f":"'Worksheet 1'!I11","v":{"v":0,"d":"0.00"}}]
[null,"Mass:"]
[null,"Empty craft mass",{"$nulls":4},"mEC","kg",null,{"$f":"'Worksheet 1'!I12","v":0}]
[null,"Maximum load",{"$nulls":4},"mL","kg",null,{"$f":"'Worksheet 1'!I34","v":0}]
[null,"Maximum recommended load for builder's plate",{"$nulls":5},"kg",null,{"$f":"'Worksheet 1'!I45","v":0}]
[null,"Light craft condition mass",{"$nulls":4},"mLC","kg",null,{"$f":"'Worksheet 1'!I16","v":0}]
[null,"Maximum Loaded condition mass = mLC + mML",{"$nulls":4},"mLDC","kg",null,{"$f":"'Worksheet 1'!I35","v":0}]
[null,"Loaded arival condition mass ",{"$nulls":4},"mLA","kg",null,{"$f":"'Worksheet 1'!I37","v":0}]
[null,"Minimum operating condition mass",{"$nulls":4},"mMO","kg",null,{"$f":"'Worksheet 1'!I44","v":0}]
[1,"Is boat sail or non-sail?",{"$nulls":5},"SAIL/NON-SAIL",null,{"$f":"'Worksheet 1'!I49","v":""}]
[2,"Option selected:",{"$nulls":7},{"$f":"'Worksheet 2'!E47","v":8}]
[{"$nulls":4},"Unit",null,"Required","Actual",null,"Pass/Fail"]
[3,"Downflooding openings:",null,"Are all requirements met?",{"$nulls":5},{"$f":"IF(L22=\"Please fill in worksheet 3a and 3b; otherwise you will receive a fail in J22\",\"Fail\",IF(AND(OR('Worksheet 1'!D8=\"A\",'Worksheet 1'!D8=\"B\"),'Worksheet 3'!AZ15=6),\"Pass\",IF(AND(OR('Worksheet 1'!D8=\"C\",'Worksheet 1'!D8=\"D\"),'Worksheet 3'!AZ15>=5),\"Pass\",\"Fail\")))","v":"Fail"},null,{"$f":"IF('Worksheet 3b Overview'!A11=\"\",\"Please fill in worksheet 3a and 3b; otherwise you will receive a fail in J22\",\"\")","v":"Please fill in worksheet 3a and 3b; otherwise you will receive a fail in J22"}]
[{"$nulls":3},"Watertighness test for closing appliances done successful?",{"$nulls":5},{"$f":"'Worksheet 3b Overview'!BC13","v":"n.a."}]
[{"$nulls":3},"Exemptions ok or openings considered as possible downflooding openings?",{"$nulls":5},{"$f":"'Worksheet 3'!BB22","v":"n.a."},{"$nulls":42},"List:"]
["3 & 4","Downflooding height:",null,"Worksheet employed for basic height",{"$nulls":48},"Yes"]
[null,"basic requirement",null,null,"m",null,{"$f":"IF('Worksheet 3'!F36=\"annex A\",'Worksheet 4'!AY36,LOOKUP('Worksheet 1'!D8,'Worksheet 3'!E38:E41,'Worksheet 3'!F38:F41))","v":{"$error":"#N/A"}},null,{"$f":"'Worksheet 3'!F42","v":{"v":0,"d":"0.00"}},{"$f":"IF(I26>'Worksheet 16'!G26,\"Pass\",\"Fail\")","v":{"$error":"#N/A"}},{"$nulls":42},"No"]
[null,"reduced height for small openings (only using figures)",null,null,"m",null,{"$f":"IF('Worksheet 3'!F36=\"annex A\",\"n.a.\",LOOKUP('Worksheet 1'!D8,'Worksheet 3'!E38:E41,'Worksheet 3'!H38:H41))","v":{"$error":"#N/A"}},null,{"$f":"'Worksheet 3'!H42","v":{"v":0,"d":"0.00"}},{"$f":"IF(G27=\"n.a.\",\"n.a.\",IF('Worksheet 3'!F36=\"fig. 2\",IF(I27>=G27,\"Pass\",\"Fail\")))","v":{"$error":"#N/A"}}]
[5,"Recess size: ",{"$nulls":50},"A"]
[null,"Simplified method: max reduction in GMT",null,null,"%",null,{"$f":"CONCATENATE(\"≤\",\"   \",MAX('Worksheet 5'!E59:F64))","v":"≤   0"},{"$f":"IF(AND('Worksheet 5'!E70=\"\",'Worksheet 5'!E76=\"\",'Worksheet 5'!E84=\"\"),\"not used\",MIN('Worksheet 5'!E70,'Worksheet 5'!E76,'Worksheet 5'!E84))","v":"not used"},null,{"$f":"IF(J30=\"Pass\",\"n.a.\",IF('Worksheet 2'!E47=\"/\",\"n.a.\",IF('Worksheet 5'!C7=\"calculation not applicable\",\"n.a.\",IF('Worksheet 5'!B24=\"Yes\",\"n.a.\",'Worksheet 5'!E87))))","v":"Fail"},{"$nulls":42},"B"]
[null,"Direct calculation: margin righting moment over heeling moment",null,null,"N m",null,{"$f":"CONCATENATE(\"≥\",\"    \",'Worksheet 5'!E92)","v":"≥    0"},{"$f":"IF('Worksheet 5'!E89=\"Yes\",'Worksheet 5'!E91,\"\")","v":""},null,{"$f":"IF('Worksheet 5'!E89=\"Yes\",IF('Worksheet 5'!E93=\"Yes\",\"Pass\",\"Fail\"),\"n.a.\")","v":"n.a."},{"$nulls":42},"C"]
[{"$nulls":52},"D"]
[10,"Flotation requirement: ",null,"ratio mLDC/VB",null,null,"< 850",{"$f":"IF('Worksheet 2'!E47,'Worksheet 10'!D40,\"\")","v":""},null,{"$f":"IF(J44=\"No\",\"n.a.\",'Worksheet 10'!D41)","v":"Fail"}]
[null,"options 8 "]
[11,"Capsisze recovery test:",null,"(option 7only)","are all requirements met?",{"$nulls":4},{"$f":"IF('Worksheet 2'!E47=7,IF(COUNTIF('Worksheet 11'!D14:D19,\"Yes\")=5,\"Pass\",\"Fail\"),\"n.a.\")","v":"n.a."}]
[null,"Design category recommended by the builder",{"$nulls":5},{"$f":"'Worksheet 1'!D8","v":0}]
["12 & 13","Stability information: (opt. 1 6.5.2 and multihulls only) info supplied like Table F.1. ?",{"$nulls":5},"Yes / No"]
[{"$nulls":4},"Unit",null,"Required","Actual",null,"Pass/Fail"]
[14,"Rolling in breaking waves max. transverse righting lever",null,null,"m",null,{"$f":"IF('Worksheet 1'!D8=\"D\",\"n.a\",LOOKUP('Worksheet 1'!D8,'Worksheet 14'!AA15:AC15,'Worksheet 14'!AA16:AC16))","v":{"$error":"#N/A"}},{"$f":"'Worksheet 14'!D17","v":0},null,{"$f":"IF(H38=0,\"\",IF(H38>G38,\"Pass\",\"Fail\"))","v":""}]
[null,"Pitchpoling longitudinal righting moment area",null,null,"kN m rad",null,{"$f":"IF('Worksheet 1'!D8=\"D\",\"n.a\",LOOKUP('Worksheet 1'!D8,'Worksheet 14'!AA24:AC24,'Worksheet 14'!AA25:AC25))","v":{"$error":"#N/A"}},{"$f":"'Worksheet 14'!D24","v":0},null,{"$f":"IF(H39=0,\"\",IF(H39>G39,\"Pass\",\"Fail\"))","v":""}]
[null,"Diagonal stability: transverse righting moment for 1° heel",null,"bow down","kg m",null,{"$f":"IF(OR('Worksheet 1'!D8=\"D\",'Worksheet 1'!D8=\"C\"),\"n.a.\",IF('Worksheet 1'!D8=\"A\",'Worksheet 14'!D30,IF('Worksheet 1'!D8=\"\",\"\",'Worksheet 14'!E30)))","v":""},{"$f":"'Worksheet 14'!D31","v":0},null,{"$f":"IF(G40=\"n.a.\",\"n.a.\",IF(H40=0,\"\",IF(H40>G40,\"Pass\",\"Fail\")))","v":""}]
[{"$nulls":3},"stern down","kg m",null,{"$f":"IF(OR('Worksheet 1'!D8=\"D\",'Worksheet 1'!D8=\"C\"),\"n.a.\",IF('Worksheet 1'!D8=\"A\",'Worksheet 14'!D30,IF('Worksheet 1'!D8=\"\",\"\",'Worksheet 14'!E30)))","v":""},{"$f":"'Worksheet 14'!D32","v":0},null,{"$f":"IF(G41=\"n.a.\",\"n.a.\",IF(H41=0,\"\",IF(H41>G41,\"Pass\",\"Fail\")))","v":""}]
[14,"Habitable boats"]
[null,"Is boat habitable?",{"$nulls":5},"Yes / No",null,{"$f":"IF('Worksheet 14'!E38=\"\",\"\",'Worksheet 14'!E38)","v":""}]
[null,"Is boat vulnerable to inversion when used in design category ?",{"$nulls":5},"Yes / No",null,{"$f":"IF('Worksheet 14'!E39=\"\",\"\",'Worksheet 14'!E39)","v":""}]
[null,"If both the above responses are Yes, then:"]
[null,"Complies with  inverted buoyancy requirements?",{"$nulls":5},"Yes / No",null,{"$f":"IF(AND(J43=\"Yes\",J44=\"Yes\"),'Worksheet 14'!E42,\"\")","v":""}]
[null,"Complies with viable means of escape requirements?",{"$nulls":5},"Yes / No",null,{"$f":"IF(AND(J43=\"Yes\",J44=\"Yes\"),'Worksheet 14'!E43,\"\")","v":""}]
[15,"Detection & removal of water: Are all requirements satisfied?",{"$nulls":5},"Yes / No"]
["NB: Boat must pass all requirements applicable to selected option to be given intended \nDesign Category."]
[]
[]
["Design Category given:",null,null,"Assessed by:"]
[]
["Documentation of downflooding opening / closing appliance attached?"]
[]
["If applicable, cockpit calculation according to ISO 11812 attached ?"]
[]
["If applicable, curve of righting moments in mMO and mLA attached ?",{"$nulls":6},"Signature :"]
[]
["Appropriate add. information attached (e.g. photos, drawings,…) ?"]