{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Ergon Living Folding","Equipment A","Equipment B","Equipment C","Equipment D","Equipment E","Equipment F","Equipment G","Equipment H","Equipment I","Equipment L","Equipment M"],"not_rendered":{"images":35,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Ergon Living Folding","index":0,"n_rows":55,"n_cols":17,"rows_kept":55,"merged":[[1,5,2,14],[5,10,5,12],[6,10,6,12],[11,0,11,1],[11,2,11,4],[12,10,12,12],[13,0,13,1],[13,2,13,3],[15,0,15,1],[15,2,15,3],[17,0,17,2],[18,0,18,1],[20,0,20,1],[20,3,20,5],[22,0,22,1],[22,2,22,6],[24,0,24,1],[26,0,26,1],[26,3,26,5],[28,0,28,1],[28,3,28,8],[32,4,32,10],[34,4,34,10],[36,4,36,10],[38,4,38,10],[40,4,40,10],[42,4,42,10],[44,4,44,10],[46,4,46,10],[48,4,48,10],[50,4,50,10],[52,4,52,10],[54,0,54,16]]}
[{"$nulls":16},"MD 01.47 - Rev 0"]
[{"$nulls":5},"Measurement development calculator"]
[]
[]
[]
[{"$nulls":10},"COLOR"]
[]
[{"$nulls":11},"INPUT LFM (wall hole width)"]
[{"$nulls":10},"Minimum 1245 mm ",null,"Maximum 6550 mm"]
[]
[{"$nulls":11},"Choose the type of system"]
["Customer ref.",{"$nulls":5},"             ",{"$nulls":3},"↓","↓","↓"]
[]
["Order ref."]
[]
["Order date"]
[{"$nulls":9},"Ceiling system",{"$nulls":4},"False ceiling system"]
["OPTIONAL",{"$nulls":8},"INPUT HFM (wall hole height)",{"$nulls":4},"INPUT HC (false ceiling height)"]
["Soft Opening",{"$nulls":9},"Maximum 4092",{"$nulls":4},"Maximum 4035"]
[]
["Push & Go",{"$nulls":13},"False ceiling support height"]
[]
["Striker plate Push & Go",null,"Obligatory for the equipments B,C,E,F,G,I,M",{"$nulls":12},"mm"]
[]
["Hinges"]
[]
["Silicone gasket"]
[]
["Junction kit",null,null,{"$f":"IF(C29=\"YES\",\"Can't be used for equipment A-D-H-L\",\"\")","v":""}]
[]
[]
["LFM Min","LFM Max","EQUIPMENT","YES / NO"]
[1245,2585,"\"A\"",{"$f":"IF(L9<1245,\"\",IF(L9>2585,\"\",\"YES\"))","v":""},"Single opening - 2 folding doors"]
[]
[1910,3780,"\"B\"",{"$f":"IF(L9<1910,\"\",IF(L9>3780,\"\",\"YES\"))","v":""},"Double opening - 1 single door + 2 folding doors"]
[]
[2300,4980,"\"C\"",{"$f":"IF(L9<2300,\"\",IF(L9>4980,\"\",\"YES\"))","v":""},"Double opening - 2 folding doors + 2 folding doors"]
[]
[1990,3790,"\"D\"",{"$f":"IF(L9<1990,\"\",IF(L9>3790,\"\",\"YES\"))","v":""},"Single opening - 3 folding doors"]
[]
[2530,4980,"\"E\"",{"$f":"IF(L9<2530,\"\",IF(L9>4980,\"\",\"YES\"))","v":""},"Double opening - 1 single door + 3 folding doors"]
[]
[2925,6185,"\"F\"",{"$f":"IF(L9<2925,\"\",IF(L9>6185,\"\",\"YES\"))","v":""},"Double opening - 2 folding doors + 3 folding doors"]
[]
[3790,6550,"\"G\"",{"$f":"IF(L9<3790,\"\",IF(L9>6550,\"\",\"YES\"))","v":""},"Double opening - 3 folding doors + 3 folding doors"]
[]
[2310,4990,"\"H\"",{"$f":"IF(L9<2310,\"\",IF(L9>4990,\"\",\"YES\"))","v":""},"Single opening - 4 folding doors"]
[]
[2975,6185,"\"I\"",{"$f":"IF(L9<2975,\"\",IF(L9>6185,\"\",\"YES\"))","v":""},"Double opening - 1 single door + 4 folding doors"]
[]
[3195,6195,"\"L\"",{"$f":"IF(L9<3195,\"\",IF(L9>6195,\"\",\"YES\"))","v":""},"Single opening - 5 folding doors"]
[]
[3660,6550,"\"M\"",{"$f":"IF(L9<3660,\"\",IF(L9>6550,\"\",\"YES\"))","v":""},"Double opening - 1 single door + 5 folding doors"]
[]
["CELEGON Srl | Via G. Galilei, 6 - Z.I. | 30035 Mirano (Ve) | T +39 041 572 8404 | F +39 041 572 8522 | info@celegon.it | P.IVA 01892090273 | © copyright 2021 "]

{"sheet":"Equipment A","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[6,0,6,13],[7,0,7,1],[7,2,8,2],[7,5,8,5],[7,8,8,8],[7,10,8,10],[7,11,8,11],[7,12,8,12],[7,13,8,13],[10,1,11,1],[12,1,13,1],[14,1,15,1],[16,0,17,0],[16,1,17,1],[16,2,17,2],[18,1,19,1],[28,0,28,1]]}
[{"$nulls":4},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":4},"Minimum 1245 mm",null,"LFM","Maximum 2585 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"A\" (2 FOLDING DOOR LEAVES - SINGLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"\\","2 Folding doors","Passage width","\\","Fixed dimension","Variable dimension\nFolding doors","\\","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright  profile height","Wooden upright  profile height striker side"]
["Code","Description",null,"\"LA2\"","\"LP\"",null,"\"QF\"","\"QV\"",null,"\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AA01\",\"710AA01\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",\"Equipment kit\")","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A33,\"-\",IF(G4>='Ergon Living Folding'!A33,IF(G4<='Ergon Living Folding'!B33,(G4-185)/2,IF(G4>'Ergon Living Folding'!B33,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A33,\"-\",IF(G4>='Ergon Living Folding'!A33,IF(G4<='Ergon Living Folding'!B33,G4-306,IF(G4>'Ergon Living Folding'!B33,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A33,\"-\",IF(G4>='Ergon Living Folding'!A33,IF(G4<='Ergon Living Folding'!B33,391.5,IF(G4>'Ergon Living Folding'!B33,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A33,\"-\",IF(G4>='Ergon Living Folding'!A33,IF(G4<='Ergon Living Folding'!B33,D10-G10,IF(G4>'Ergon Living Folding'!B33,\"-\")))))","v":"-"},"\\","\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A33,\"-\",IF(G4>='Ergon Living Folding'!A33,IF(G4<='Ergon Living Folding'!B33,L3-75,IF(G4>'Ergon Living Folding'!B33,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A33,\"-\",IF(G4>='Ergon Living Folding'!A33,IF(G4<='Ergon Living Folding'!B33,L3-92,IF(G4>'Ergon Living Folding'!B33,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A33,\"-\",IF(G4>='Ergon Living Folding'!A33,IF(G4<='Ergon Living Folding'!B33,L3-90,IF(G4>'Ergon Living Folding'!B33,\"-\")))))","v":"-"},{"$f":"K10","v":"-"}]
[{"$f":"IF(B11=\"-\",\"-\",IF(G4<=3300,\"700BS01\",\"700BSL01\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!J19=\"\",\"-\",\"Track kit and horizontal frame for ceiling\")","v":"-"}]
[{"$f":"IF(B11=\"-\",\"-\",IF(G4<=3300,\"710BS01\",\"710BSL01\"))","v":"-"}]
[{"$f":"IF(B13=\"-\",\"-\",IF(G4<=3300,\"700BC01\",\"700BCL01\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!O19=\"\",\"-\",\"Track kit for false ceiling\")","v":"-"}]
[{"$f":"IF(B13=\"-\",\"-\",IF(G4<=3300,\"710BC01\",\"710BCL01\"))","v":"-"}]
[{"$f":"IF(B15=\"-\",\"-\",IF(G4<=3300,\"700TC01\",\"700TCL01\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!O19=\"\",\"-\",\"Horizontal frame kit for false ceiling\")","v":"-"}]
[{"$f":"IF(B15=\"-\",\"-\",IF(G4<=3300,\"710TC01\",\"710TCL01\"))","v":"-"}]
[{"$f":"IF(B17=\"-\",\"-\",IF('Ergon Living Folding'!O23=500,\"700SC01\",\"700SCL01\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!O23=\"\",\"-\",\"False ceiling support kit\")","v":"-"},{"$f":"IF(G4>6000,13,IF(G4>5500,12,IF(G4>5000,11,IF(G4>4500,10,IF(G4>4000,9,IF(G4>3500,8,IF(G4>3000,7,IF(G4>2500,6,IF(G4>2000,5,IF(G4<=1500,5,IF(G4<=1500,4,\"\")))))))))))","v":5}]
[]
[{"$f":"IF(B19=\"-\",\"-\",IF(L3<=2175,\"700TV01\",IF(L3>3125,\"700TVXL01\",\"700TVL01\")))","v":"-"},{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",\"Vertical frame kit\")","v":"-"}]
[{"$f":"IF(B19=\"-\",\"-\",IF(L3<=2175,\"710TV01\",IF(L3>3125,\"710TVXL01\",\"710TVL01\")))","v":"-"}]
[{"$f":"IF(L3=57,\"-\",IF(L3<=2175,\"720M101\",IF(L3>3125,\"720M1XL01\",\"720M1L01\")))","v":"-"},{"$f":"IF(L3=57.5,\"-\",\"Upright with 1 rod\")","v":"Upright with 1 rod"}]
[{"$f":"IF(B22=\"-\",\"-\",\"700S101\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C19=\"YES\",\"Soft Opening S1\",\"-\")","v":"-"},"NASCONDI"]
[{"$f":"IF(B23=\"-\",\"-\",\"700SP01\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C19=\"YES\",\"Soft Opening PLUS\",\"-\")","v":"-"},1]
[{"$f":"IF(B24=\"-\",\"-\",IF('Ergon Living Folding'!D21=\"Satin Chrome\",\"4100CSL\",IF('Ergon Living Folding'!D21=\"Polished Brass\",\"4100OLL\",IF('Ergon Living Folding'!D21=\"Polished Nickel\",\"4100NLL\",IF('Ergon Living Folding'!D21=\"Black Nickel\",\"4100NNL\",IF('Ergon Living Folding'!D21=\"Bronze Plated\",\"4100BRL\",IF('Ergon Living Folding'!D21=\"Matt White\",\"4100BOL\",IF('Ergon Living Folding'!D21=\"Matt Black\",\"4100NEOL\"))))))))","v":"-"},{"$f":"IF('Ergon Living Folding'!C21=\"YES\",\"Push & Go\nwith 250 cm cable\",\"-\")","v":"-"},"NASCONDI"]
[{"$f":"IF(A8=\"BLACK\",\"4150IN\",\"4150IA\")","v":"4150IA"},{"$f":"\"Striker plate Push & Go\"","v":"Striker plate Push & Go"},"NASCONDI"]
[{"$f":"IF(B26=\"-\",\"-\",IF(A8=\"BLACK\",\"C701000F1\",\"C721000F1\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!C25=\"YES\",\"Pair of Hinges\",\"-\")","v":"-"},1]
[{"$f":"IF(B27=\"-\",\"-\",IF('Ergon Living Folding'!D27=\"White\",\"GS68012B\",IF('Ergon Living Folding'!D27=\"Black\",\"GS68012N\",IF('Ergon Living Folding'!D27=\"Brown\",\"GS68012M\",\"-\"))))","v":"-"},{"$f":"IF('Ergon Living Folding'!C27=\"YES\",\"Gasket\",\"-\")","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"IF('Ergon Living Folding'!C29=\"YES\",\"564100\",\"-\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C29=\"YES\",\"Junction kit\",\"-\")","v":"-"},"NASCONDI"]
["Kit Junction can't be used for this Equipment"]
[]
[]
[]
[]
[{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment B","index":2,"n_rows":36,"n_cols":19,"rows_kept":36,"merged":[[0,5,0,6],[0,7,0,8],[0,10,0,11],[2,5,3,6],[2,8,3,9],[6,0,6,14],[7,0,7,2],[7,11,8,11],[7,12,8,12],[7,13,8,13],[7,14,8,14],[8,1,8,2],[9,1,9,2],[10,1,11,2],[10,5,11,6],[11,3,11,4],[12,1,13,2],[12,3,13,3],[14,1,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[14,14,15,14],[14,18,15,18],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,5,17,6],[17,3,17,4],[18,1,19,2],[18,3,19,4],[20,1,20,2],[23,1,23,2],[24,1,24,2],[27,1,27,2]]}
[{"$nulls":5},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":11},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":5},"Minimum 1910 mm",null,"LFM","Maximum 3780 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":6},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"B\" (1 SINGLE LEAF + 2 FOLDING DOOR LEAVES - DOUBLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,null,"Single door leaf","2 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA and LA2","Quote variable LA","Quote variable LA2","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
["Code","Description",null,"\"LA\"","\"LA2\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV2\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AB01\",\"710AB01\"))","v":"-"},{"$f":"'Equipment A'!B10","v":"-"},null,{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<2190,670,IF(H4<='Ergon Living Folding'!B35,(H4-180)/3,IF(H4>'Ergon Living Folding'!B35,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<2190,(H4-180-D10)/2,IF(H4<='Ergon Living Folding'!B35,(H4-180)/3,IF(H4>'Ergon Living Folding'!B35,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<='Ergon Living Folding'!B35,H4-245-(E10*2),IF(H4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<='Ergon Living Folding'!B35,H4-360,IF(H4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<='Ergon Living Folding'!B35,391.5,IF(H4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<='Ergon Living Folding'!B35,D10-H10,IF(H4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<='Ergon Living Folding'!B35,E10-H10,IF(H4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<='Ergon Living Folding'!B35,S10-65,IF(H4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<='Ergon Living Folding'!B35,M3-75,IF(H4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<='Ergon Living Folding'!B35,M3-92,IF(H4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<='Ergon Living Folding'!B35,M3-90,IF(H4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},"\\",{"$nulls":3},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A35,\"-\",IF(H4>='Ergon Living Folding'!A35,IF(H4<='Ergon Living Folding'!B35,D10+53,IF(H4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},null,{"$f":"IF(B28=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO JUNCTION KIT\",\"-\",IF(D10<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO JUNCTION KIT\",\"-\",IF(B28=\"Junction kit\",\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(D10<775,\"NO JUNCTION KIT\",\"-\")))","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"},null,null,"-"]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"},null,{"$f":"IF(E15<530,\"Decrease LA size\",IF(E15>1200,\"Increase LA size\",\"\"))","v":"Increase LA size"}]
[{"$f":"'Equipment A'!A14","v":"-"},{"$nulls":3},{"$f":"IF(E15<530,\"min 530 mm\",IF(E15>1200,\"max 1200 mm\",\"\"))","v":"max 1200 mm"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"},null,null,{"$f":"IF(D15=\"\",\"-\",E10-((D15-D10)/2))","v":"-"},{"$f":"IF(D15=\"\",\"-\",H4-245-(E15*2))","v":"-"},{"$f":"IF(D15=\"\",\"-\",G10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",391.5)","v":"-"},{"$f":"IF(D15=\"\",\"-\",D15-H15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",E15-H15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",S15-65)","v":"-"},{"$f":"IF(D15=\"\",\"-\",L10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",M10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",N10)","v":"-"},"\\",{"$nulls":3},{"$f":"IF(D15=\"\",\"-\",D15+53)","v":"-"}]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"'Equipment A'!C17:C18","v":5},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO JUNCTION KIT\",\"-\",IF(D15<670,\"-\",IF(D15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(F17=\"NO JUNCTION KIT\",\"-\",IF(B28=\"Junction kit\",\"No Soft Opening\",\"-\")))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(D15<775,\"NO JUNCTION KIT\",\"-\"))","v":"-"}]
[{"$nulls":3},"-"]
[{"$f":"'Equipment A'!A19","v":"-"},{"$f":"'Equipment A'!B19:B20","v":"-"},null,"Alternatively choose the size of the single door"]
[{"$f":"'Equipment A'!A20","v":"-"}]
[{"$f":"IF(M3=57,\"-\",IF(M3<=2175,\"720M201\",IF(M3>3125,\"720M2XL01\",\"720M2L01\")))","v":"-"},{"$f":"IF(M3=57,\"-\",\"Upright with 2 rod\")","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"},{"$f":"IF(B22=\"Soft Opening S1\",1,\"-\")","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"},{"$f":"IF(B23=\"Soft Opening PLUS\",1,\"-\")","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"4150IA"},{"$f":"'Equipment A'!B25","v":"Striker plate Push & Go"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"},1]
[{"$f":"'Equipment A'!A27","v":"-"},{"$f":"'Equipment A'!B27","v":"-"},{"$f":"IF(M10=\"-\",\"\",((C26*M10)/1000)&\" mt\")","v":""}]
[{"$f":"'Equipment A'!A28","v":"-"},{"$f":"'Equipment A'!B28","v":"-"}]
{"$rows_empty":7}
[{"$nulls":13},"<<Back to menù"]

{"sheet":"Equipment C","index":3,"n_rows":29,"n_cols":18,"rows_kept":29,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[6,0,6,13],[7,0,7,1],[7,10,8,10],[7,11,8,11],[7,12,8,12],[7,13,8,13],[10,1,11,1],[10,3,11,3],[12,1,13,1],[14,1,15,1],[16,0,17,0],[16,1,17,1],[16,2,17,2],[18,1,19,1]]}
[{"$nulls":4},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":4},"Minimum 2300 mm",null,"LFM","Maximum 4980 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"C\" (2 FOLDING DOOR LEAVES + 2 FOLDING DOOR LEAVES - DOUBLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"\\","2 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA2","\\","Quote Variable LA2","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
["Code","Description","\\","\"LA2\"","\"LP\"","\"LPD\"","\"QF\"","\\","\"QV2\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AC01\",\"710AC01\"))","v":"-"},{"$f":"'Equipment A'!B10","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,(G4-180)/4,IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,G4-301-(D10*2),IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,G4-416,IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,391.5,IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,D10-G10,IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,R10-65,IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,L3-75,IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,L3-92,IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,L3-90,IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"},"\\",null,{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,G4-78,IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"},null,{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,P10-((D10*2)+46),IF(G4>'Ergon Living Folding'!B37,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},null,{"$f":"IF(D10=\"-\",\"-\",IF(B28=\"Junction kit\",\"No Soft Opening\",\"-\"))","v":"-"},{"$nulls":11},{"$f":"IF(G4=\"\",\"-\",(P10/2))","v":{"$error":"#VALUE!"}},{"$f":"IF(G4=0,\"-\",P11)","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"}]
[{"$f":"'Equipment A'!A14","v":"-"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"}]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"'Equipment A'!C17:C18","v":5}]
[]
[{"$f":"'Equipment A'!A19","v":"-"},{"$f":"'Equipment A'!B19:B20","v":"-"}]
[{"$f":"'Equipment A'!A20","v":"-"}]
[{"$f":"'Equipment B'!A21","v":"-"},{"$f":"'Equipment B'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"},"poi nascondi"]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"},2]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"4150IA"},{"$f":"'Equipment A'!B25","v":"Striker plate Push & Go"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"},2]
[{"$f":"'Equipment A'!A27","v":"-"},{"$f":"'Equipment A'!B27","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"'Equipment A'!A28","v":"-"},{"$f":"'Equipment A'!B28","v":"-"}]
[{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment D","index":4,"n_rows":32,"n_cols":14,"rows_kept":32,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[6,0,6,13],[7,0,7,1],[7,2,8,2],[7,5,8,5],[7,8,8,8],[7,10,8,10],[7,11,8,11],[7,12,8,12],[7,13,8,13],[10,1,11,1],[10,2,11,3],[12,1,13,1],[14,1,15,1],[16,0,17,0],[16,1,17,1],[16,2,17,2],[18,1,19,1],[28,0,28,1]]}
[{"$nulls":4},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":4},"Minimum 1990 mm",null,"LFM","Maximum 3790 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"D\" (3 FOLDING DOOR LEAVES - SINGLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"\\","3 Folding doors","Passage width","\\","Fixed quote","Variable dimension\nFolding doors","\\","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright profile height","Wooden upright  profile height striker side"]
["Code","Description",null,"\"LA3\"","\"LP\"",null,"\"QF\"","\"QV\"",null,"\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AD01\",\"710AD01\"))","v":"-"},{"$f":"'Equipment A'!B10","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A39,\"-\",IF(G4>='Ergon Living Folding'!A39,IF(G4<='Ergon Living Folding'!B39,(G4-190)/3,IF(G4>'Ergon Living Folding'!B39,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A39,\"-\",IF(G4>='Ergon Living Folding'!A39,IF(G4<='Ergon Living Folding'!B39,G4-367,IF(G4>'Ergon Living Folding'!B39,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A39,\"-\",IF(G4>='Ergon Living Folding'!A39,IF(G4<='Ergon Living Folding'!B39,391.5,IF(G4>'Ergon Living Folding'!B39,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A39,\"-\",IF(G4>='Ergon Living Folding'!A39,IF(G4<='Ergon Living Folding'!B39,D10-G10,IF(G4>'Ergon Living Folding'!B39,\"-\")))))","v":"-"},"\\","\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A39,\"-\",IF(G4>='Ergon Living Folding'!A39,IF(G4<='Ergon Living Folding'!B39,L3-75,IF(G4>'Ergon Living Folding'!B39,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A39,\"-\",IF(G4>='Ergon Living Folding'!A39,IF(G4<='Ergon Living Folding'!B39,L3-92,IF(G4>'Ergon Living Folding'!B39,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A39,\"-\",IF(G4>='Ergon Living Folding'!A39,IF(G4<='Ergon Living Folding'!B39,L3-90,IF(G4>'Ergon Living Folding'!B39,\"-\")))))","v":"-"},{"$f":"K10","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},{"$f":"IF(D10>674,\"-\",\"No Soft Opening\")","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"}]
[{"$f":"'Equipment A'!A14","v":"-"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"}]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"'Equipment A'!C17:C18","v":5}]
[]
[{"$f":"'Equipment A'!A19","v":"-"},{"$f":"'Equipment A'!B19","v":"-"}]
[{"$f":"'Equipment A'!A20","v":"-"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"Upright with 1 rod"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"},"Poi nascondi"]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"},1]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"},"Poi nascondi"]
[{"$f":"'Equipment A'!A25","v":"4150IA"},{"$f":"'Equipment A'!B25","v":"Striker plate Push & Go"},"Poi nascondi"]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"},2]
[{"$f":"'Equipment A'!A27","v":"-"},{"$f":"'Equipment A'!B27","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"'Equipment A'!A28","v":"-"},{"$f":"'Equipment A'!B28","v":"-"},"Poi nascondi"]
["Kit Junction can't be used for this Equipment"]
[]
[]
[{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment E","index":5,"n_rows":31,"n_cols":19,"rows_kept":31,"merged":[[0,5,0,6],[0,7,0,8],[0,10,0,11],[2,5,3,6],[2,8,3,9],[6,0,6,14],[7,0,7,2],[7,11,8,11],[7,12,8,12],[7,13,8,13],[7,14,8,14],[8,1,8,2],[9,1,9,2],[10,1,11,2],[10,5,11,6],[11,3,11,4],[12,1,13,2],[12,3,13,3],[14,1,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[14,14,15,14],[14,18,15,18],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,5,17,6],[17,3,17,4],[18,1,19,2],[18,3,19,4],[20,1,20,2],[21,3,22,3],[23,1,23,2],[24,1,24,2],[27,1,27,2]]}
[{"$nulls":5},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":11},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":5},"Minimum 2530 mm",null,"LFM","Maximum 4980 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":6},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"E\" (1 SINGLE LEAF + 3 FOLDING DOOR LEAVES - DOUBLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,null,"Single door leaf","3 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA and LA3","Quote variable LA","Quote variable LA3","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
["Code","Description",null,"\"LA\"","\"LA3\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV3\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AE01\",\"710AE01\"))","v":"-"},{"$f":"'Equipment A'!B10","v":"-"},null,{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<2860,670,IF(H4<='Ergon Living Folding'!B41,(H4-180)/4,IF(H4>'Ergon Living Folding'!B41,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<2860,(H4-180-670)/3,IF(H4<='Ergon Living Folding'!B41,(H4-180)/4,IF(H4>'Ergon Living Folding'!B41,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<='Ergon Living Folding'!B41,H4-(91+149.5)-(E10*3+6),IF(H4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<='Ergon Living Folding'!B41,H4-417,IF(H4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<='Ergon Living Folding'!B41,391.5,IF(H4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<='Ergon Living Folding'!B41,D10-H10,IF(H4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<='Ergon Living Folding'!B41,E10-H10,IF(H4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<2860,\"670\",IF(H4<='Ergon Living Folding'!B41,S10-65,IF(H4>'Ergon Living Folding'!B41,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<='Ergon Living Folding'!B41,M3-75,IF(H4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<='Ergon Living Folding'!B41,M3-92,IF(H4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<='Ergon Living Folding'!B41,M3-90,IF(H4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},"\\",{"$nulls":3},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A41,\"-\",IF(H4>='Ergon Living Folding'!A41,IF(H4<='Ergon Living Folding'!B41,D10+53,IF(H4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},null,{"$f":"IF(B28=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO JUNCTION KIT\",\"-\",IF(D10<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO JUNCTION KIT\",\"-\",IF(B28=\"Junction kit\",IF(E10<850,\"No Soft Opening\",\"-\"),\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(D10<775,\"NO JUNCTION KIT\",\"-\")))","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"},null,null,{"$f":"IF(D10=\"-\",\"-\",IF((D10+E10)>1369.9,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\"))","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"},null,{"$f":"IF(E15<560,\"Decrease LA size\",IF(E15>1200,\"Increase LA size\",\"\"))","v":"Increase LA size"}]
[{"$f":"'Equipment A'!A14","v":"-"},{"$nulls":3},{"$f":"IF(E15<560,\"min 560 mm\",IF(E15>1200,\"max 1200 mm\",\"\"))","v":"max 1200 mm"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"},null,null,{"$f":"IF(D15=\"\",\"-\",E10-((D15-D10)/3))","v":"-"},{"$f":"IF(D15=\"\",\"-\",H4-(91+149.5)-(E15*3+6))","v":"-"},{"$f":"IF(D15=\"\",\"-\",G10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",H10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",D15-H15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",E15-H15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",S15-65)","v":"-"},{"$f":"IF(D15=\"\",\"-\",L10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",M10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",N10)","v":"-"},"\\",{"$nulls":3},{"$f":"IF(D15=\"\",\"-\",D15+53)","v":"-"}]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"'Equipment A'!C17:C18","v":5},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO JUNCTION KIT\",\"-\",IF(D15<670,\"-\",IF(D15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO JUNCTION KIT\",\"-\",IF(E15<695,\"-\",IF(E15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(D15<775,\"NO JUNCTION KIT\",IF(E15<745,\"NO JUNCTION KIT\",\"-\")))","v":"-"}]
[{"$nulls":3},{"$f":"IF(D15=\"\",\"-\",IF((D15+E15)>1369.9,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\"))","v":"-"}]
[{"$f":"'Equipment A'!A19","v":"-"},{"$f":"'Equipment A'!B19:B20","v":"-"},null,{"$f":"'Equipment B'!D19","v":"Alternatively choose the size of the single door"}]
[{"$f":"'Equipment A'!A20","v":"-"}]
[{"$f":"'Equipment B'!A21","v":"-"},{"$f":"'Equipment B'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"},{"$f":"IF(B22=\"Soft Opening S1\",1,\"-\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C19=\"YES\",\"←Choose one of the two\",\"\")","v":""}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"},{"$f":"IF(B23=\"Soft Opening PLUS\",1,\"-\")","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"4150IA"},{"$f":"'Equipment A'!B25","v":"Striker plate Push & Go"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"},2]
[{"$f":"'Equipment A'!A27","v":"-"},{"$f":"'Equipment A'!B27","v":"-"},{"$f":"IF(M10=\"-\",\"\",((C26*M10)/1000)&\" mt\")","v":""}]
[{"$f":"'Equipment A'!A28","v":"-"},{"$f":"'Equipment A'!B28","v":"-"}]
[]
[]
[{"$nulls":13},"<<Back to menù"]

{"sheet":"Equipment F","index":6,"n_rows":34,"n_cols":19,"rows_kept":34,"merged":[[0,5,0,6],[0,7,0,8],[0,10,0,11],[2,5,3,6],[2,8,3,9],[6,0,6,14],[7,0,7,2],[7,11,8,11],[7,12,8,12],[7,13,8,13],[7,14,8,14],[8,1,8,2],[9,1,9,2],[10,1,11,2],[10,5,11,6],[11,3,11,4],[12,1,13,2],[12,3,13,3],[14,1,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[14,14,15,14],[14,18,15,18],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,5,17,6],[17,3,17,4],[18,1,19,2],[18,3,19,4],[20,1,20,2],[23,1,23,2],[24,1,24,2],[27,1,27,2]]}
[{"$nulls":5},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":11},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":5},"Minimum 2925 mm",null,"LFM","Maximum 6185 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":6},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"F\" (2 FOLDING DOOR LEAVES + 3 FOLDING DOOR LEAVES - DOUBLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,null,"2 Folding doors","3 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA2 and LA3","Quote variable LA2","Quote variable LA3","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
["Code","Description",null,"\"LA2\"","\"LA3\"","\"LP\"","\"LPD\"","\"QF\"","\"QV2\"","\"QV3\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AF01\",\"710AF01\"))","v":"-"},{"$f":"'Equipment A'!B10","v":"-"},null,{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<2985,((H4-185-(E10*3))/2),IF(H4<='Ergon Living Folding'!B43,(H4-185)/5,IF(H4>'Ergon Living Folding'!B43,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4<2985,560,IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,(H4-185)/5,IF(H4>'Ergon Living Folding'!B43,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,H4-305-(E10*3),IF(H4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,H4-476,IF(H4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,391.5,IF(H4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,D10-H10,IF(H4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,D10-H10,IF(H4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,S10-65,IF(H4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,M3-75,IF(H4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,M3-92,IF(H4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,M3-90,IF(H4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},"\\",{"$nulls":3},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A43,\"-\",IF(H4>='Ergon Living Folding'!A43,IF(H4<='Ergon Living Folding'!B43,(D10*2)+53+3,IF(H4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},null,{"$f":"IF(B28=\"-\",\"-\",IF(F11=\"NO JUNCTION KIT\",\"-\",IF(D15>0,\"-\",\"No Soft Opening\")))","v":"-"},{"$f":"IF(B28=\"-\",\"-\",IF(F11=\"NO JUNCTION KIT\",\"-\",IF(D15>0,\"-\",IF(E10<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(E10<745,\"NO JUNCTION KIT\",\"-\")))","v":"-"},{"$nulls":10},{"$f":"IF(H4=\"\",\"-\",S10)","v":"-"},{"$f":"IF(H4=0,\"-\",Q10-S10)","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"},null,null,{"$f":"IF(E10>589.9,\"-\",IF(D15>0,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\"))","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"},null,{"$f":"IF(E15<560,\"Decrease LA size\",IF(E15>1200,\"Increase LA size\",\"\"))","v":"Increase LA size"}]
[{"$f":"'Equipment A'!A14","v":"-"},{"$nulls":3},{"$f":"IF(E15<560,\"min 560 mm\",IF(E15>1200,\"max 1200 mm\",\"\"))","v":"max 1200 mm"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"},null,null,{"$f":"IF(D15=\"\",\"-\",E10-(((D15-D10)*2)/3))","v":"-"},{"$f":"IF(D15=\"\",\"-\",H4-208-(E15*3+6+91))","v":"-"},{"$f":"IF(D15=\"\",\"-\",G10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",H10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",D15-H15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",E15-H15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",S15-65)","v":"-"},{"$f":"IF(D15=\"\",\"-\",L10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",M10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",N10)","v":"-"},"\\",{"$nulls":3},{"$f":"IF(D15=\"\",\"-\",(D15*2)+53+3)","v":"-"}]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"'Equipment A'!C17:C18","v":5},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO JUNCTION KIT\",\"-\",\"No Soft Opening\"))","v":"-"},{"$f":"IF(D15=\"-\",\"-\",IF(F17=\"NO JUNCTION KIT\",\"-\",IF(B28=\"Junction kit\",IF(E15<850,\"No Soft Opening\",\"-\"),\"-\")))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(E15<745,\"NO JUNCTION KIT\",\"-\"))","v":"-"},{"$nulls":10},{"$f":"IF(D15=\"\",\"-\",S15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",Q15-S15)","v":"-"}]
[{"$nulls":3},{"$f":"IF(E15>589.9,\"-\",IF(E15=\"\",\"-\",\"SOFT OPENING ON ONE SIDE ONLY\"))","v":"-"}]
[{"$f":"'Equipment A'!A19","v":"-"},{"$f":"'Equipment A'!B19:B20","v":"-"},null,"Alternatively choose the size of the 2 Folding door leaves"]
[{"$f":"'Equipment A'!A20","v":"-"}]
[{"$f":"'Equipment B'!A21","v":"-"},{"$f":"'Equipment B'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"},null,"poi nascondi"]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"},{"$f":"IF(D12=\"SOFT OPENING ON ONE SIDE ONLY\",\"1\",IF(D11=\"No soft opening\",\"1\",IF(D18=\"SOFT OPENING ON ONE SIDE ONLY\",\"1\",IF(D17=\"No soft opening\",\"1\",\"2\"))))","v":"2"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"4150IA"},{"$f":"'Equipment A'!B25","v":"Striker plate Push & Go"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"},3]
[{"$f":"'Equipment A'!A27","v":"-"},{"$f":"'Equipment A'!B27","v":"-"},{"$f":"IF(M10=\"-\",\"\",((C26*M10)/1000)&\" mt\")","v":""}]
[{"$f":"'Equipment A'!A28","v":"-"},{"$f":"'Equipment A'!B28","v":"-"}]
[]
[]
[]
[]
[]
[{"$nulls":13},"<<Back to menù"]

{"sheet":"Equipment G","index":7,"n_rows":29,"n_cols":18,"rows_kept":29,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[6,0,6,13],[7,0,7,1],[7,3,8,3],[7,7,8,7],[7,10,8,10],[7,11,8,11],[7,12,8,12],[7,13,8,13],[10,1,11,1],[10,4,11,5],[11,2,11,3],[12,1,13,1],[14,1,15,1],[16,0,17,0],[16,1,17,1],[16,2,17,2],[18,1,19,1]]}
[{"$nulls":4},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":4},"Minimum 3790 mm",null,"LFM","Maximum 6550 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"G\" (3 FOLDING DOOR LEAVES + 3 FOLDING DOOR LEAVES - DOUBLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"3 Folding doors","\\","Passage width","Double passage dimension","Fixed quote LA3","\\","Quote variable LA3","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
["Code","Description","\"LA3\"",null,"\"LP\"","\"LPD\"","\"QF\"",null,"\"QV3\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AG01\",\"710AG01\"))","v":"-"},{"$f":"'Equipment A'!B10","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,(G4-190)/6,IF(G4>'Ergon Living Folding'!B45,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,G4-364-(C10*3),IF(G4>'Ergon Living Folding'!B45,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,G4-534,IF(G4>'Ergon Living Folding'!B45,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,391.5,IF(G4>'Ergon Living Folding'!B45,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,C10-G10,IF(G4>'Ergon Living Folding'!B45,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,R10-65,IF(G4>'Ergon Living Folding'!B45,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,L3-75,IF(G4>'Ergon Living Folding'!B45,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,L3-92,IF(G4>'Ergon Living Folding'!B45,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,L3-90,IF(G4>'Ergon Living Folding'!B45,\"-\")))))","v":"-"},"\\",{"$nulls":3},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,(C10*3)+53+6,IF(G4>'Ergon Living Folding'!B45,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},{"$f":"IF(B28=\"-\",\"-\",IF(E11=\"NO JUNCTION KIT\",\"-\",IF(C10<850,\"No Soft Opening\",\"-\")))","v":"-"},"-",{"$f":"IF(C10=\"-\",\"-\",IF(C10<745,\"NO JUNCTION KIT\",\"-\"))","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"},null,{"$f":"IF(C10>684.9,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"}]
[{"$f":"'Equipment A'!A14","v":"-"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"}]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"'Equipment A'!C17:C18","v":5}]
[]
[{"$f":"'Equipment A'!A19","v":"-"},{"$f":"'Equipment A'!B19:B20","v":"-"}]
[{"$f":"'Equipment A'!A20","v":"-"}]
[{"$f":"'Equipment B'!A21","v":"-"},{"$f":"'Equipment B'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"},"poi nascondi"]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"},{"$f":"IF(C11=\"SOFT OPENING ON ONE SIDE ONLY\",\"1\",IF(C12=\"SOFT OPENING ON ONE SIDE ONLY\",\"1\",\"2\"))","v":"2"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"4150IA"},{"$f":"'Equipment A'!B25","v":"Striker plate Push & Go"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"},4]
[{"$f":"'Equipment A'!A27","v":"-"},{"$f":"'Equipment A'!B27","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"'Equipment A'!A28","v":"-"},{"$f":"'Equipment A'!B28","v":"-"}]
[{"$nulls":13},"<<Back to menù"]

{"sheet":"Equipment H","index":8,"n_rows":29,"n_cols":14,"rows_kept":29,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[6,0,6,13],[7,0,7,1],[7,5,8,5],[7,8,8,8],[7,10,8,10],[7,11,8,11],[7,12,8,12],[7,13,8,13],[10,1,11,1],[12,1,13,1],[14,1,15,1],[16,0,17,0],[16,1,17,1],[16,2,17,2],[18,1,19,1],[28,0,28,1]]}
[{"$nulls":4},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":4},"Minimum 2310 mm",null,"LFM","Maximum 4990 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"H\" (4 FOLDING DOOR LEAVES - SINGLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"\\","4 Folding doors","Passage width","\\","Fixed quote\nLA4","Quote variable LA4","\\","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright profile height","Wooden upright  profile height striker side"]
["Code","Description","\\","\"LA4\"","\"LP\"",null,"\"QF\"","\"QV4\"",null,"\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AH01\",\"710AH01\"))","v":"-"},{"$f":"'Equipment A'!B10","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A47,\"-\",IF(G4>='Ergon Living Folding'!A47,IF(G4<='Ergon Living Folding'!B47,(G4-190)/4,IF(G4>'Ergon Living Folding'!B47,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A47,\"-\",IF(G4>='Ergon Living Folding'!A47,IF(G4<='Ergon Living Folding'!B47,G4-423,IF(G4>'Ergon Living Folding'!B47,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A47,\"-\",IF(G4>='Ergon Living Folding'!A47,IF(G4<='Ergon Living Folding'!B47,391.5,IF(G4>'Ergon Living Folding'!B47,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A47,\"-\",IF(G4>='Ergon Living Folding'!A47,IF(G4<='Ergon Living Folding'!B47,D10-G10,IF(G4>'Ergon Living Folding'!B47,\"-\")))))","v":"-"},"\\","\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A47,\"-\",IF(G4>='Ergon Living Folding'!A47,IF(G4<='Ergon Living Folding'!B47,L3-75,IF(G4>'Ergon Living Folding'!B47,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A47,\"-\",IF(G4>='Ergon Living Folding'!A47,IF(G4<='Ergon Living Folding'!B47,L3-92,IF(G4>'Ergon Living Folding'!B47,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A47,\"-\",IF(G4>='Ergon Living Folding'!A47,IF(G4<='Ergon Living Folding'!B47,L3-90,IF(G4>'Ergon Living Folding'!B47,\"-\")))))","v":"-"},{"$f":"K10","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"}]
[{"$f":"'Equipment A'!A14","v":"-"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"}]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"'Equipment A'!C17:C18","v":5}]
[]
[{"$f":"'Equipment A'!A19","v":"-"},{"$f":"'Equipment A'!B19:B20","v":"-"}]
[{"$f":"'Equipment A'!A20","v":"-"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"Upright with 1 rod"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"},"Poi nascondi"]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"},1]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"},"Poi nascondi"]
[{"$f":"'Equipment A'!A25","v":"4150IA"},{"$f":"'Equipment A'!B25","v":"Striker plate Push & Go"},"Poi nascondi"]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"},3]
[{"$f":"'Equipment A'!A27","v":"-"},{"$f":"'Equipment A'!B27","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"'Equipment A'!A28","v":"-"},{"$f":"'Equipment A'!B28","v":"-"},"Poi nascondi"]
["Kit Junction can't be used for this Equipment",{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment I","index":9,"n_rows":30,"n_cols":19,"rows_kept":30,"merged":[[0,5,0,6],[0,7,0,8],[0,10,0,11],[2,5,3,6],[2,8,3,9],[6,0,6,14],[7,0,7,2],[7,11,8,11],[7,12,8,12],[7,13,8,13],[7,14,8,14],[8,1,8,2],[9,1,9,2],[10,1,11,2],[10,5,11,6],[11,3,11,4],[12,1,13,2],[12,3,13,3],[14,1,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[14,14,15,14],[14,18,15,18],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,5,17,6],[17,3,17,4],[18,1,19,2],[18,3,19,4],[20,1,20,2],[23,1,23,2],[24,1,24,2],[27,1,27,2]]}
[{"$nulls":5},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":11},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":5},"Minimum 2975 mm",null,"LFM","Maximum 6185 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":6},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"I\" (1 SINGLE LEAF + 4 FOLDING DOOR LEAVES - DOUBLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,null,"Single door leaf","4 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA1 and LA4","Quote variable LA1","Quote variable LA4","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
["Code","Description",null,"\"LA1\"","\"LA4\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV4\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AI01\",\"710AI01\"))","v":"-"},{"$f":"'Equipment A'!B10","v":"-"},null,{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<=3535,670,IF(H4<='Ergon Living Folding'!B49,(H4-185)/5,IF(H4>'Ergon Living Folding'!B49,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<3535,(H4-185-D10)/4,IF(H4<='Ergon Living Folding'!B49,(H4-185)/5,IF(H4>'Ergon Living Folding'!B49,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<='Ergon Living Folding'!B49,H4-((E10*4)+251.5),IF(H4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<='Ergon Living Folding'!B49,H4-476,IF(H4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<='Ergon Living Folding'!B49,391.5,IF(H4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<='Ergon Living Folding'!B49,D10-H10,IF(H4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<='Ergon Living Folding'!B49,E10-H10,IF(H4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<='Ergon Living Folding'!B49,S10-65,IF(H4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<='Ergon Living Folding'!B49,M3-75,IF(H4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<='Ergon Living Folding'!B49,M3-92,IF(H4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<='Ergon Living Folding'!B49,M3-90,IF(H4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},"\\",{"$nulls":3},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A49,\"-\",IF(H4>='Ergon Living Folding'!A49,IF(H4<='Ergon Living Folding'!B49,D10+53,IF(H4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},null,{"$f":"IF(B28=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO JUNCTION KIT\",\"-\",IF(D10<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO JUNCTION KIT\",\"-\",IF(B28=\"Junction kit\",\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(D10<775,\"NO JUNCTION KIT\",\"-\")))","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"},null,null,"-"]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"},null,{"$f":"IF(E15<530,\"Decrease LA size\",IF(E15>1200,\"Increase LA size\",\"\"))","v":"Increase LA size"}]
[{"$f":"'Equipment A'!A14","v":"-"},{"$nulls":3},{"$f":"IF(E15<530,\"min 530 mm\",IF(E15>1200,\"max 1200 mm\",\"\"))","v":"max 1200 mm"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"},null,null,{"$f":"IF(D15=\"\",\"-\",E10-((D15-D10)/4))","v":"-"},{"$f":"IF(D15=\"\",\"-\",H4-(91+149.5)-(E15*4+9+2))","v":"-"},{"$f":"IF(D15=\"\",\"-\",G10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",H10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",D15-H15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",E15-H15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",S15-65)","v":"-"},{"$f":"IF(D15=\"\",\"-\",L10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",M10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",N10)","v":"-"},"\\",{"$nulls":3},{"$f":"IF(D15=\"\",\"-\",D15+53)","v":"-"}]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"'Equipment A'!C17:C18","v":5},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO JUNCTION KIT\",\"-\",IF(D15<670,\"-\",IF(D15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(F17=\"NO JUNCTION KIT\",\"-\",IF(B28=\"Junction kit\",\"No Soft Opening\",\"-\")))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(D15<775,\"NO JUNCTION KIT\",\"-\"))","v":"-"}]
[{"$nulls":3},"-"]
[{"$f":"'Equipment A'!A19","v":"-"},{"$f":"'Equipment A'!B19:B20","v":"-"},null,{"$f":"'Equipment B'!D19","v":"Alternatively choose the size of the single door"}]
[{"$f":"'Equipment A'!A20","v":"-"}]
[{"$f":"'Equipment B'!A21","v":"-"},{"$f":"'Equipment B'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"},{"$f":"IF(B22=\"Soft Opening S1\",1,\"-\")","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"},{"$f":"IF(B23=\"Soft Opening PLUS\",1,\"-\")","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"4150IA"},{"$f":"'Equipment A'!B25","v":"Striker plate Push & Go"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"},3]
[{"$f":"'Equipment A'!A27","v":"-"},{"$f":"'Equipment A'!B27","v":"-"},{"$f":"IF(M10=\"-\",\"\",((C26*M10)/1000)&\" mt\")","v":""}]
[{"$f":"'Equipment A'!A28","v":"-"},{"$f":"'Equipment A'!B28","v":"-"}]
[]
[{"$nulls":14},"<<Back to menù"]

{"sheet":"Equipment L","index":10,"n_rows":29,"n_cols":14,"rows_kept":29,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[6,0,6,13],[7,0,7,1],[7,2,8,2],[7,5,8,5],[7,8,8,8],[7,10,8,10],[7,11,8,11],[7,12,8,12],[7,13,8,13],[10,1,11,1],[10,2,11,3],[12,1,13,1],[14,1,15,1],[16,0,17,0],[16,1,17,1],[16,2,17,2],[18,1,19,1],[22,14,23,14],[28,0,28,1]]}
[{"$nulls":4},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":4},"Minimum 3195 mm",null,"LFM","Maximum 6195 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"L\" (5 FOLDING DOOR LEAVES - SINGLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"\\","5 Folding doors","Passage width","\\","Fixed quote\nLA5","Quote variable LA5","\\","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright profile height","Wooden upright  profile height striker side"]
["Code","Description",null,"\"LA5\"","\"LP\"",null,"\"QF\"","\"QV5\"",null,"\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AL01\",\"710AL01\"))","v":"-"},{"$f":"'Equipment A'!B10","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A51,\"-\",IF(G4>='Ergon Living Folding'!A51,IF(G4<='Ergon Living Folding'!B51,(G4-195)/5,IF(G4>'Ergon Living Folding'!B51,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A51,\"-\",IF(G4>='Ergon Living Folding'!A51,IF(G4<='Ergon Living Folding'!B51,G4-483,IF(G4>'Ergon Living Folding'!B51,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A51,\"-\",IF(G4>='Ergon Living Folding'!A51,IF(G4<='Ergon Living Folding'!B51,391.5,IF(G4>'Ergon Living Folding'!B51,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A51,\"-\",IF(G4>='Ergon Living Folding'!A51,IF(G4<='Ergon Living Folding'!B51,D10-G10,IF(G4>'Ergon Living Folding'!B51,\"-\")))))","v":"-"},"\\","\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A51,\"-\",IF(G4>='Ergon Living Folding'!A51,IF(G4<='Ergon Living Folding'!B51,L3-75,IF(G4>'Ergon Living Folding'!B51,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A51,\"-\",IF(G4>='Ergon Living Folding'!A51,IF(G4<='Ergon Living Folding'!B51,L3-92,IF(G4>'Ergon Living Folding'!B51,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A51,\"-\",IF(G4>='Ergon Living Folding'!A51,IF(G4<='Ergon Living Folding'!B51,L3-90,IF(G4>'Ergon Living Folding'!B51,\"-\")))))","v":"-"},{"$f":"K10","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},{"$f":"IF(D10>674,\"-\",\"No Soft Opening\")","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"}]
[{"$f":"'Equipment A'!A14","v":"-"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"}]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"'Equipment A'!C17:C18","v":5}]
[]
[{"$f":"'Equipment A'!A19","v":"-"},{"$f":"'Equipment A'!B19:B20","v":"-"}]
[{"$f":"'Equipment A'!A20","v":"-"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"Upright with 1 rod"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"},"Poi nascondi"]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"},1]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"},"Poi nascondi"]
[{"$f":"'Equipment A'!A25","v":"4150IA"},{"$f":"'Equipment A'!B25","v":"Striker plate Push & Go"},"Poi nascondi"]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"},4]
[{"$f":"'Equipment A'!A27","v":"-"},{"$f":"'Equipment A'!B27","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"'Equipment A'!A28","v":"-"},{"$f":"'Equipment A'!B28","v":"-"},"Poi nascondi"]
["Kit Junction can't be used for this Equipment",{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment M","index":11,"n_rows":29,"n_cols":19,"rows_kept":29,"merged":[[0,5,0,6],[0,7,0,8],[0,10,0,11],[2,5,3,6],[2,8,3,9],[6,0,6,14],[7,0,7,2],[7,11,8,11],[7,12,8,12],[7,13,8,13],[7,14,8,14],[8,1,8,2],[9,1,9,2],[10,1,11,2],[10,5,11,6],[11,3,11,4],[12,1,13,2],[12,3,13,3],[14,1,15,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,6],[14,7,15,7],[14,8,15,8],[14,9,15,9],[14,10,15,10],[14,11,15,11],[14,12,15,12],[14,13,15,13],[14,14,15,14],[14,18,15,18],[16,0,17,0],[16,1,17,1],[16,2,17,2],[16,5,17,6],[17,3,17,4],[18,1,19,2],[18,3,19,4],[20,1,20,2],[21,3,22,3],[23,1,23,2],[24,1,24,2],[27,1,27,2]]}
[{"$nulls":5},"Customer ref.",null,{"$f":"'Ergon Living Folding'!C12","v":0},null,"Order ref.",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Order date",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":11},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Maximum 4035 mm"]
[{"$nulls":5},"Minimum 3660 mm",null,"LFM","Maximum 6550 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57,'Ergon Living Folding'!J19)","v":{"v":57,"d":"57.0"}},"Maximum 4092 mm"]
[" ",{"$nulls":6},{"$f":"'Ergon Living Folding'!L9","v":{"v":0,"d":"0.0"}},{"$nulls":6},{"$f":"'Ergon Living Folding'!Q1","v":"MD 01.47 - Rev 0"}]
[]
[]
["EQUIPMENT \"M\" (1 SINGLE LEAF + 5 FOLDING DOORS - DOUBLE OPENING)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,null,"Single door leaf","5 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA and LA5","Quote variable LA","Quote variable LA5","Push & Go striker plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
["Code","Description",null,"\"LA\"","\"LA5\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV5\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"BLACK\",\"700AM01\",\"710AM01\"))","v":"-"},{"$f":"'Equipment A'!B10","v":"-"},null,{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<=4210,670,IF(H4<='Ergon Living Folding'!B53,(H4-190)/6,IF(H4>'Ergon Living Folding'!B53,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<4210,(H4-190-670)/5,IF(H4<='Ergon Living Folding'!B53,(H4-190)/6,IF(H4>'Ergon Living Folding'!B53,\"-\"))))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<='Ergon Living Folding'!B53,H4-(91+149.5)-(E10*5+12),IF(H4>'Ergon Living Folding'!B53,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<='Ergon Living Folding'!B53,H4-149.5-385.5,IF(H4>'Ergon Living Folding'!B53,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<='Ergon Living Folding'!B53,391.5,IF(H4>'Ergon Living Folding'!B53,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<='Ergon Living Folding'!B53,D10-H10,IF(H4>'Ergon Living Folding'!B53,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<='Ergon Living Folding'!B53,E10-H10,IF(H4>'Ergon Living Folding'!B53,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<='Ergon Living Folding'!B53,S10-65,IF(H4>'Ergon Living Folding'!B53,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<='Ergon Living Folding'!B53,M3-75,IF(H4>'Ergon Living Folding'!B53,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<='Ergon Living Folding'!B53,M3-92,IF(H4>'Ergon Living Folding'!B53,\"-\")))))","v":"-"},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<='Ergon Living Folding'!B53,M3-90,IF(H4>'Ergon Living Folding'!B53,\"-\")))))","v":"-"},"\\",{"$nulls":3},{"$f":"IF(H4=\"\",\"\",IF(H4<'Ergon Living Folding'!A53,\"-\",IF(H4>='Ergon Living Folding'!A53,IF(H4<='Ergon Living Folding'!B53,D10+53,IF(H4>'Ergon Living Folding'!B53,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},null,{"$f":"IF(B28=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO JUNCTION KIT\",\"-\",IF(D10<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO JUNCTION KIT\",\"-\",IF(B28=\"Junction kit\",IF(E10<850,\"No Soft Opening\",\"-\"),\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(D10<775,\"NO JUNCTION KIT\",\"-\")))","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"},null,null,{"$f":"IF(D10=\"-\",\"-\",IF((D10+E10)>1369.9,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\"))","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"},null,{"$f":"IF(E15<560,\"Decrease LA size\",IF(E15>1200,\"Increase LA size\",\"\"))","v":"Increase LA size"}]
[{"$f":"'Equipment A'!A14","v":"-"},{"$nulls":3},{"$f":"IF(E15<560,\"min 560 mm\",IF(E15>1200,\"max 1200 mm\",\"\"))","v":"max 1200 mm"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"},null,null,{"$f":"IF(D15=\"\",\"-\",E10-((D15-D10)/5))","v":"-"},{"$f":"IF(D15=\"\",\"-\",H4-(91+149.5)-(E15*5+12))","v":"-"},{"$f":"IF(D15=\"\",\"-\",G10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",H10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",D15-H15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",E15-H15)","v":"-"},{"$f":"IF(D15=\"\",\"-\",S15-65)","v":"-"},{"$f":"IF(D15=\"\",\"-\",L10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",M10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",N10)","v":"-"},"\\",{"$nulls":3},{"$f":"IF(D15=\"\",\"-\",D15+53)","v":"-"}]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"'Equipment A'!C17:C18","v":5},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO JUNCTION KIT\",\"-\",IF(D15<670,\"-\",IF(D15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO JUNCTION KIT\",\"-\",IF(E15<700,\"-\",IF(E15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(D15<775,\"NO JUNCTION KIT\",IF(E15<745,\"NO JUNCTION KIT\",\"-\")))","v":"-"}]
[{"$nulls":3},{"$f":"IF(D15=\"\",\"-\",IF((D15+E15)>1369.9,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\"))","v":"-"}]
[{"$f":"'Equipment A'!A19","v":"-"},{"$f":"'Equipment A'!B19:B20","v":"-"},null,{"$f":"'Equipment B'!D19","v":"Alternatively choose the size of the single door"}]
[{"$f":"'Equipment A'!A20","v":"-"}]
[{"$f":"'Equipment B'!A21","v":"-"},{"$f":"'Equipment B'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"},{"$f":"IF(B22=\"Soft Opening S1\",1,\"-\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C19=\"YES\",\"←Choose one of the two\",\"\")","v":""}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"},{"$f":"IF(B23=\"Soft Opening PLUS\",1,\"-\")","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"4150IA"},{"$f":"'Equipment A'!B25","v":"Striker plate Push & Go"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"},4]
[{"$f":"'Equipment A'!A27","v":"-"},{"$f":"'Equipment A'!B27","v":"-"},{"$f":"IF(M10=\"-\",\"\",((C26*M10)/1000)&\" mt\")","v":""}]
[{"$f":"'Equipment A'!A28","v":"-"},{"$f":"'Equipment A'!B28","v":"-"}]
[{"$nulls":14},"<<Torna al menù"]