{"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":13},"read":"whole","date_system":"1900"}

{"sheet":"Ergon Living Folding","index":0,"n_rows":53,"n_cols":17,"rows_kept":53,"merged":[[1,5,2,13],[5,10,5,12],[6,10,6,12],[11,0,11,1],[11,2,11,3],[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],[24,0,24,1],[26,0,26,1],[26,3,26,5],[30,4,30,10],[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,0,52,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"]
[]
[]
["Customer ref.",{"$nulls":10},"Compile only one of the two systems"]
[]
["Order ref.",{"$nulls":8},"Ceiling system",{"$nulls":4},"False ceiling system"]
[]
["Order date",{"$nulls":8},"INPUT HFM (wall hole height)",{"$nulls":4},"INPUT HC (false ceiling height)"]
[{"$nulls":10},"Maximum 3125",{"$nulls":4},"Maximum 3068"]
["OPTIONAL"]
["Soft Opening",{"$nulls":13},"False ceiling support height"]
[]
["Push & Go",{"$nulls":14},"mm"]
[]
["Striker plate Push & Go"]
[]
["Hinges"]
[]
["Guarnizione siliconica"]
[]
[]
["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"]
[]
[3550,6550,"\"G\"",{"$f":"IF(L9<3550,\"\",IF(L9>6190,\"\",\"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>6190,\"\",\"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":31,"n_cols":14,"rows_kept":31,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[2,11,3,12],[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],[17,1,18,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":4},"Minimum 1245 mm",null,"LFM","Maximum 2585 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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 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(A8=\"BLACK\",\"700AA01\",\"710AA01\")","v":"710AA01"},"Equipment kit","\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A31,\"-\",IF(G4>='Ergon Living Folding'!A31,IF(G4<='Ergon Living Folding'!B31,(G4-185)/2,IF(G4>'Ergon Living Folding'!B31,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A31,\"-\",IF(G4>='Ergon Living Folding'!A31,IF(G4<='Ergon Living Folding'!B31,G4-306,IF(G4>'Ergon Living Folding'!B31,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A31,\"-\",IF(G4>='Ergon Living Folding'!A31,IF(G4<='Ergon Living Folding'!B31,391.5,IF(G4>'Ergon Living Folding'!B31,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A31,\"-\",IF(G4>='Ergon Living Folding'!A31,IF(G4<='Ergon Living Folding'!B31,D10-G10,IF(G4>'Ergon Living Folding'!B31,\"-\")))))","v":"-"},"\\","\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A31,\"-\",IF(G4>='Ergon Living Folding'!A31,IF(G4<='Ergon Living Folding'!B31,K4-75,IF(G4>'Ergon Living Folding'!B31,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A31,\"-\",IF(G4>='Ergon Living Folding'!A31,IF(G4<='Ergon Living Folding'!B31,K4-92,IF(G4>'Ergon Living Folding'!B31,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A31,\"-\",IF(G4>='Ergon Living Folding'!A31,IF(G4<='Ergon Living Folding'!B31,K4-90,IF(G4>'Ergon Living Folding'!B31,\"-\")))))","v":"-"},{"$f":"K10","v":"-"}]
[{"$f":"IF(B11=\"-\",\"-\",IF(G4<=3300,\"700BS01\",\"700BSL01\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!J17=\"\",\"-\",\"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'!O17=\"\",\"-\",\"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'!O17=\"\",\"-\",\"Horizontal frame kit for false ceiling\")","v":"-"}]
[{"$f":"IF(B15=\"-\",\"-\",IF(G4<=3300,\"710TC01\",\"710TCL01\"))","v":"-"}]
[{"$f":"IF(B17=\"-\",\"-\",IF('Ergon Living Folding'!O21=500,\"700SC01\",\"700SCL01\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!O21=\"\",\"-\",\"False ceiling support kit\")","v":"-"}]
[{"$f":"IF(B18=\"-\",\"-\",IF(K4<=2175,\"700TV01\",\"700TVL01\"))","v":"700TV01"},"Vertical frame kit"]
[{"$f":"IF(B18=\"-\",\"-\",IF(K4<=2175,\"710TV01\",\"710TVL01\"))","v":"710TV01"}]
[{"$f":"IF(K4<=2175,\"720M101\",\"720M1L01\")","v":"720M101"},"Upright with 1 rod"]
[{"$f":"IF(B21=\"-\",\"-\",\"700S101\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C19=\"YES\",\"Soft Opening S1\",\"-\")","v":"-"},"Poi nascondi"]
[{"$f":"IF(B22=\"-\",\"-\",\"700SP01\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C19=\"YES\",\"Soft Opening PLUS\",\"-\")","v":"-"}]
[{"$f":"IF(B23=\"-\",\"-\",IF('Ergon Living Folding'!D21=\"Satin Chrome\",\"4100CS\",IF('Ergon Living Folding'!D21=\"Polished Brass\",\"4100OL\",IF('Ergon Living Folding'!D21=\"Polished Nickel\",\"4100NL\",IF('Ergon Living Folding'!D21=\"Black Nickel\",\"4100NN\",IF('Ergon Living Folding'!D21=\"Bronze Plated\",\"4100BR\",IF('Ergon Living Folding'!D21=\"Matt White\",\"4100BO\",IF('Ergon Living Folding'!D21=\"Matt Black\",\"4100NEO\"))))))))","v":"-"},{"$f":"IF('Ergon Living Folding'!C21=\"YES\",\"Push & Go\",\"-\")","v":"-"}]
[{"$f":"IF(B24=\"-\",\"-\",IF(A8=\"BLACK\",\"4150IN\",\"4150IA\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!C23=\"YES\",\"Striker plate Push & Go\",\"-\")","v":"-"}]
[{"$f":"IF(B25=\"-\",\"-\",IF(A8=\"BLACK\",\"C701000F1\",\"C721000F1\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!C25=\"YES\",\"Hinges\",\"-\")","v":"-"}]
[{"$f":"IF(B26=\"-\",\"-\",IF('Ergon Living Folding'!D27=\"White\",\"GS68012B\",IF('Ergon Living Folding'!D27=\"Black\",\"GS60012N\",IF('Ergon Living Folding'!D27=\"Brown\",\"GS68012M\",\"-\"))))","v":"-"},{"$f":"IF('Ergon Living Folding'!C27=\"YES\",\"Gasket\",\"-\")","v":"-"},{"$f":"IF(L10=\"-\",\"\",\"X2\")","v":""}]
[]
[]
[]
[]
[{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment B","index":2,"n_rows":35,"n_cols":17,"rows_kept":35,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[2,11,3,12],[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,2,11,3],[12,1,13,1],[12,2,13,2],[14,1,15,1],[14,2,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],[16,2,16,3],[17,1,18,1],[18,2,19,3]]}
[{"$nulls":4},{"$f":"'Equipment A'!E1:F1","v":"Customer ref."},null,{"$f":"'Ergon Living Folding'!C12","v":0},null,{"$f":"'Equipment A'!I1","v":"Order ref."},{"$f":"'Ergon Living Folding'!C14","v":0},null,{"$f":"'Equipment A'!L1","v":"Order date"},{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[]
[{"$nulls":4},"Minimum 1910 mm",null,"LFM","Maximum 3780 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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,"Single door leaf","2 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA and LA2","Quote variable LA","Quote variable LA2","Push & Go plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
[{"$f":"'Equipment A'!A9","v":"Code"},{"$f":"'Equipment A'!B9","v":"Description"},"\"LA\"","\"LA2\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV2\"","\"PP\""]
[{"$f":"IF(A8=\"BLACK\",\"700AB01\",\"710AB01\")","v":"710AB01"},{"$f":"'Equipment A'!B10","v":"Equipment kit"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A33,\"-\",IF(G4>='Ergon Living Folding'!A33,IF(G4<2190,\"670\",IF(G4<='Ergon Living Folding'!B33,(G4-180)/3,IF(G4>'Ergon Living Folding'!B33,\"-\"))))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A33,\"-\",IF(G4>='Ergon Living Folding'!A33,IF(G4<2190,(G4-180-C10)/2,IF(G4<='Ergon Living Folding'!B33,(G4-180)/3,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-245-(D10*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-360,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,C10-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,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,Q10-65,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,K4-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,K4-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,K4-90,IF(G4>'Ergon Living Folding'!B33,\"-\")))))","v":"-"},"\\",null,null,{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A33,\"-\",IF(G4>='Ergon Living Folding'!A33,IF(G4<='Ergon Living Folding'!B33,C10+53,IF(G4>'Ergon Living Folding'!B33,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},{"$f":"IF(D10>674,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"},{"$f":"IF(D15>=530,\"\",\"Decrease LA size\")","v":""}]
[{"$f":"'Equipment A'!A14","v":"-"},null,null,{"$f":"IF(D15>=530,\"min 530 mm\",\"\")","v":"min 530 mm"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"},null,{"$f":"IF(C15=\"\",\"-\",D10-((C15-C10)/2))","v":"-"},{"$f":"IF(C15=\"\",\"-\",G4-245-(D15*2))","v":"-"},{"$f":"IF(C15=\"\",\"-\",F10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",391.5)","v":"-"},{"$f":"IF(C15=\"\",\"-\",C15-G15)","v":"-"},{"$f":"IF(C15=\"\",\"-\",D15-G15)","v":"-"},{"$f":"IF(C15=\"\",\"-\",#REF!-65)","v":"-"},{"$f":"IF(C15=\"\",\"-\",K10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",L10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",M10)","v":"-"},"\\"]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"IF(D15>674,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","v":"-"}]
[{"$f":"'Equipment A'!A18","v":"700TV01"},{"$f":"'Equipment A'!B18:B19","v":"Vertical frame kit"}]
[{"$f":"'Equipment A'!A19","v":"710TV01"},null,"Alternatively choose the size of the single door"]
[{"$f":"IF(K4<=2175,\"720M201\",\"720M2L01\")","v":"720M201"},"Upright with 2 rod"]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"-"},{"$f":"'Equipment A'!B25","v":"-"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"}]
{"$rows_empty":8}
[{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment C","index":3,"n_rows":27,"n_cols":17,"rows_kept":27,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[2,11,3,12],[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],[12,1,13,1],[14,1,15,1],[17,1,18,1]]}
[{"$nulls":4},{"$f":"'Equipment A'!E1:F1","v":"Customer ref."},null,{"$f":"'Ergon Living Folding'!C12","v":0},null,{"$f":"'Equipment A'!I1","v":"Order ref."},{"$f":"'Ergon Living Folding'!C14","v":0},null,{"$f":"'Equipment A'!L1","v":"Order date"},{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[]
[{"$nulls":4},"Minimum 2300 mm",null,"LFM","Maximum 4980 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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 plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
[{"$f":"'Equipment A'!A9","v":"Code"},{"$f":"'Equipment A'!B9","v":"Description"},"\\","\"LA2\"","\"LP\"","\"LPD\"","\"QF\"","\\","\"QV2\"","\"PP\""]
[{"$f":"IF(A8=\"BLACK\",\"700AC01\",\"710AC01\")","v":"710AC01"},{"$f":"'Equipment A'!B10","v":"Equipment kit"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,(G4-180)/4,IF(G4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,G4-301-(D10*2),IF(G4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,G4-416,IF(G4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,391.5,IF(G4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,D10-G10,IF(G4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,Q10-65,IF(G4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,K4-75,IF(G4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,K4-92,IF(G4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,K4-90,IF(G4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},"\\",null,{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,G4-78,IF(G4>'Ergon Living Folding'!B35,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A35,\"-\",IF(G4>='Ergon Living Folding'!A35,IF(G4<='Ergon Living Folding'!B35,P10-((D10*2)+46),IF(G4>'Ergon Living Folding'!B35,\"-\")))))","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'!A18","v":"700TV01"},{"$f":"'Equipment A'!B18:B19","v":"Vertical frame kit"}]
[{"$f":"'Equipment A'!A19","v":"710TV01"}]
[{"$f":"'Equipment B'!A20","v":"720M201"},{"$f":"'Equipment B'!B20","v":"Upright with 2 rod"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"-"},{"$f":"'Equipment A'!B25","v":"-"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"}]
[{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment D","index":4,"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],[2,11,3,12],[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],[17,1,18,1]]}
[{"$nulls":4},{"$f":"'Equipment A'!E1:F1","v":"Customer ref."},null,{"$f":"'Ergon Living Folding'!C12","v":0},null,{"$f":"'Equipment A'!I1","v":"Order ref."},{"$f":"'Ergon Living Folding'!C14","v":0},null,{"$f":"'Equipment A'!L1","v":"Order date"},{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[]
[{"$nulls":4},"Minimum 1990 mm",null,"LFM","Maximum 3790 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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 plate position","Passage height","Door leaf height","Wooden upright profile height","Wooden upright  profile height striker side"]
[{"$f":"'Equipment A'!A9","v":"Code"},{"$f":"'Equipment A'!B9","v":"Description"},null,"\"LA3\"","\"LP\"",null,"\"QF\"","\"QV\"",null,"\"PP\""]
[{"$f":"IF(A8=\"BLACK\",\"700AD01\",\"710AD01\")","v":"710AD01"},{"$f":"'Equipment A'!B10","v":"Equipment kit"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A37,\"-\",IF(G4>='Ergon Living Folding'!A37,IF(G4<='Ergon Living Folding'!B37,(G4-190)/3,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-367,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,K4-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,K4-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,K4-90,IF(G4>'Ergon Living Folding'!B37,\"-\")))))","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'!A18","v":"700TV01"},{"$f":"'Equipment A'!B18","v":"Vertical frame kit"}]
[{"$f":"'Equipment A'!A19","v":"710TV01"}]
[{"$f":"'Equipment A'!A20","v":"720M101"},{"$f":"'Equipment A'!B20","v":"Upright with 1 rod"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"-"},"Poi nascondi"]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"-"},{"$f":"'Equipment A'!B25","v":"-"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"}]
[]
[]
[{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment E","index":5,"n_rows":30,"n_cols":17,"rows_kept":30,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[2,11,3,12],[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,2,11,3],[12,1,13,1],[12,2,13,2],[14,1,15,1],[14,2,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],[16,2,16,3],[17,1,18,1],[18,2,19,3]]}
[{"$nulls":4},{"$f":"'Equipment A'!E1:F1","v":"Customer ref."},null,{"$f":"'Ergon Living Folding'!C12","v":0},null,{"$f":"'Equipment A'!I1","v":"Order ref."},{"$f":"'Ergon Living Folding'!C14","v":0},null,{"$f":"'Equipment A'!L1","v":"Order date"},{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[]
[{"$nulls":4},"Minimum 2530 mm",null,"LFM","Maximum 4980 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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,"Single door leaf","3 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA and LA3","Quote variable LA","Quote variable LA3","Push & Go plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
[{"$f":"'Equipment A'!A9","v":"Code"},{"$f":"'Equipment A'!B9","v":"Description"},"\"LA\"","\"LA3\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV3\"","\"PP\""]
[{"$f":"IF(A8=\"BLACK\",\"700AE01\",\"710AE01\")","v":"710AE01"},{"$f":"'Equipment A'!B10","v":"Equipment kit"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A39,\"-\",IF(G4>='Ergon Living Folding'!A39,IF(G4<2860,\"670\",IF(G4<='Ergon Living Folding'!B39,(G4-180)/4,IF(G4>'Ergon Living Folding'!B39,\"-\"))))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A39,\"-\",IF(G4>='Ergon Living Folding'!A39,IF(G4<2860,(G4-180-670)/3,IF(G4<='Ergon Living Folding'!B39,(G4-180)/4,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-(91+149.5)-(D10*3+6),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-417,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,C10-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,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<2860,\"670\",IF(G4<='Ergon Living Folding'!B39,Q10-65,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,K4-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,K4-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,K4-90,IF(G4>'Ergon Living Folding'!B39,\"-\")))))","v":"-"},"\\",null,null,{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A39,\"-\",IF(G4>='Ergon Living Folding'!A39,IF(G4<='Ergon Living Folding'!B39,C10+53,IF(G4>'Ergon Living Folding'!B39,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},{"$f":"IF(D10>674,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"},{"$f":"IF(D15>=560,\"\",\"Decrease LA size\")","v":""}]
[{"$f":"'Equipment A'!A14","v":"-"},null,null,{"$f":"IF(D15>=560,\"min 560 mm\",\"\")","v":"min 560 mm"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"},null,{"$f":"IF(C15=\"\",\"-\",D10-((C15-C10)/3))","v":"-"},{"$f":"IF(C15=\"\",\"-\",G4-(91+149.5)-(D15*3+6))","v":"-"},{"$f":"IF(C15=\"\",\"-\",F10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",G10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",C15-G15)","v":"-"},{"$f":"IF(C15=\"\",\"-\",D15-G15)","v":"-"},{"$f":"IF(C15=\"\",\"-\",#REF!-65)","v":"-"},{"$f":"IF(C15=\"\",\"-\",K10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",L10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",M10)","v":"-"},"\\"]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"IF(D15>674,\"-\",\"SOFT OPENING SOLO DA UN LATO\")","v":"-"}]
[{"$f":"'Equipment A'!A18","v":"700TV01"},{"$f":"'Equipment A'!B18:B19","v":"Vertical frame kit"}]
[{"$f":"'Equipment A'!A19","v":"710TV01"},null,{"$f":"'Equipment B'!C19:D20","v":"Alternatively choose the size of the single door"}]
[{"$f":"'Equipment B'!A20","v":"720M201"},{"$f":"'Equipment B'!B20","v":"Upright with 2 rod"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"-"},{"$f":"'Equipment A'!B25","v":"-"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"}]
[]
[]
[]
[{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment F","index":6,"n_rows":32,"n_cols":17,"rows_kept":32,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[2,11,3,12],[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,2,11,3],[12,1,13,1],[12,2,13,2],[14,1,15,1],[14,2,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],[16,2,16,3],[17,1,18,1],[18,2,19,3]]}
[{"$nulls":4},{"$f":"'Equipment A'!E1:F1","v":"Customer ref."},null,{"$f":"'Ergon Living Folding'!C12","v":0},null,{"$f":"'Equipment A'!I1","v":"Order ref."},{"$f":"'Ergon Living Folding'!C14","v":0},null,{"$f":"'Equipment A'!L1","v":"Order date"},{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[]
[{"$nulls":4},"Minimum 2925 mm",null,"LFM","Maximum 6185 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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,"2 Folding doors","3 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA2 and LA3","Quote variable LA2","Quote variable LA3","Push & Go plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
[{"$f":"'Equipment A'!A9","v":"Code"},{"$f":"'Equipment A'!B9","v":"Description"},"\"LA2\"","\"LA3\"","\"LP\"","\"LPD\"","\"QF\"","\"QV2\"","\"QV3\"","\"PP\""]
[{"$f":"IF(A8=\"BLACK\",\"700AF01\",\"710AF01\")","v":"710AF01"},{"$f":"'Equipment A'!B10","v":"Equipment kit"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<2985,((G4-185-(D10*3))/2),IF(G4<='Ergon Living Folding'!B41,(G4-185)/5,IF(G4>'Ergon Living Folding'!B41,\"-\"))))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4<2985,560,IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,(G4-185)/5,IF(G4>'Ergon Living Folding'!B41,\"-\"))))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,G4-305-(D10*3),IF(G4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,G4-476,IF(G4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,391.5,IF(G4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,C10-G10,IF(G4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,C10-G10,IF(G4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,Q10-65,IF(G4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,K4-75,IF(G4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,K4-92,IF(G4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,K4-90,IF(G4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"},"\\",null,null,{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A41,\"-\",IF(G4>='Ergon Living Folding'!A41,IF(G4<='Ergon Living Folding'!B41,(C10*2)+53+3,IF(G4>'Ergon Living Folding'!B41,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},{"$f":"IF(D10>590,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"},{"$f":"IF(D15>=530,\"\",\"Decrease LA size\")","v":""}]
[{"$f":"'Equipment A'!A14","v":"-"},null,null,{"$f":"IF(D15>=530,\"min 530 mm\",\"\")","v":"min 530 mm"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"},null,{"$f":"IF(C15=\"\",\"-\",D10-(((C15-C10)*2)/3))","v":"-"},{"$f":"IF(C15=\"\",\"-\",G4-208-(D15*3+6+91))","v":"-"},{"$f":"IF(C15=\"\",\"-\",F10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",G10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",C15-G15)","v":"-"},{"$f":"IF(C15=\"\",\"-\",D15-G15)","v":"-"},{"$f":"IF(C15=\"\",\"-\",#REF!-65)","v":"-"},{"$f":"IF(C15=\"\",\"-\",K10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",L10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",M10)","v":"-"},"\\"]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"IF(D15>590,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","v":"-"}]
[{"$f":"'Equipment A'!A18","v":"700TV01"},{"$f":"'Equipment A'!B18:B19","v":"Vertical frame kit"}]
[{"$f":"'Equipment A'!A19","v":"710TV01"},null,"Alternatively choose the size of the 2 Folding door leaves"]
[{"$f":"'Equipment B'!A20","v":"720M201"},{"$f":"'Equipment B'!B20","v":"Upright with 2 rod"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"-"},{"$f":"'Equipment A'!B25","v":"-"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"}]
[]
[]
[]
[]
[]
[{"$nulls":12},"<<Back to menù"]

{"sheet":"Equipment G","index":7,"n_rows":27,"n_cols":17,"rows_kept":27,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[2,11,3,12],[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,2,11,3],[12,1,13,1],[14,1,15,1],[17,1,18,1]]}
[{"$nulls":4},{"$f":"'Equipment A'!E1:F1","v":"Customer ref."},null,{"$f":"'Ergon Living Folding'!C12","v":0},null,{"$f":"'Equipment A'!I1","v":"Order ref."},{"$f":"'Ergon Living Folding'!C14","v":0},null,{"$f":"'Equipment A'!L1","v":"Order date"},{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[]
[{"$nulls":4},"Minimum 3550 mm",null,"LFM","Maximum 6550 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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 plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
[{"$f":"'Equipment A'!A9","v":"Code"},{"$f":"'Equipment A'!B9","v":"Description"},"\"LA3\"",null,"\"LP\"","\"LPD\"","\"QF\"",null,"\"QV3\"","\"PP\""]
[{"$f":"IF(A8=\"BLACK\",\"700AG01\",\"710AG01\")","v":"710AG01"},{"$f":"'Equipment A'!B10","v":"Equipment kit"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A43,\"-\",IF(G4>='Ergon Living Folding'!A43,IF(G4<='Ergon Living Folding'!B43,(G4-190)/6,IF(G4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A43,\"-\",IF(G4>='Ergon Living Folding'!A43,IF(G4<='Ergon Living Folding'!B43,G4-364-(C10*3),IF(G4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A43,\"-\",IF(G4>='Ergon Living Folding'!A43,IF(G4<='Ergon Living Folding'!B43,G4-534,IF(G4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A43,\"-\",IF(G4>='Ergon Living Folding'!A43,IF(G4<='Ergon Living Folding'!B43,391.5,IF(G4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A43,\"-\",IF(G4>='Ergon Living Folding'!A43,IF(G4<='Ergon Living Folding'!B43,C10-G10,IF(G4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A43,\"-\",IF(G4>='Ergon Living Folding'!A43,IF(G4<='Ergon Living Folding'!B43,Q10-65,IF(G4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A43,\"-\",IF(G4>='Ergon Living Folding'!A43,IF(G4<='Ergon Living Folding'!B43,K4-75,IF(G4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A43,\"-\",IF(G4>='Ergon Living Folding'!A43,IF(G4<='Ergon Living Folding'!B43,K4-92,IF(G4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A43,\"-\",IF(G4>='Ergon Living Folding'!A43,IF(G4<='Ergon Living Folding'!B43,K4-90,IF(G4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"},"\\",null,null,{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A43,\"-\",IF(G4>='Ergon Living Folding'!A43,IF(G4<='Ergon Living Folding'!B43,(C10*3)+53+6,IF(G4>'Ergon Living Folding'!B43,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},{"$f":"IF(C10>684.9,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","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'!A18","v":"700TV01"},{"$f":"'Equipment A'!B18:B19","v":"Vertical frame kit"}]
[{"$f":"'Equipment A'!A19","v":"710TV01"}]
[{"$f":"'Equipment B'!A20","v":"720M201"},{"$f":"'Equipment B'!B20","v":"Upright with 2 rod"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"-"},{"$f":"'Equipment A'!B25","v":"-"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"}]
[{"$nulls":13},"<<Back to menù"]

{"sheet":"Equipment H","index":8,"n_rows":26,"n_cols":14,"rows_kept":26,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[2,11,3,12],[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],[17,1,18,1]]}
[{"$nulls":4},{"$f":"'Equipment A'!E1:F1","v":"Customer ref."},null,{"$f":"'Ergon Living Folding'!C12","v":0},null,{"$f":"'Equipment A'!I1","v":"Order ref."},{"$f":"'Ergon Living Folding'!C14","v":0},null,{"$f":"'Equipment A'!L1","v":"Order date"},{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[]
[{"$nulls":4},"Minimum 2310 mm",null,"LFM","Maximum 4990 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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 plate position","Passage height","Door leaf height","Wooden upright profile height","Wooden upright  profile height striker side"]
[{"$f":"'Equipment A'!A9","v":"Code"},{"$f":"'Equipment A'!B9","v":"Description"},"\\","\"LA4\"","\"LP\"",null,"\"QF\"","\"QV4\"",null,"\"PP\""]
[{"$f":"IF(A8=\"BLACK\",\"700AH01\",\"710AH01\")","v":"710AH01"},{"$f":"'Equipment A'!B10","v":"Equipment kit"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A45,\"-\",IF(G4>='Ergon Living Folding'!A45,IF(G4<='Ergon Living Folding'!B45,(G4-190)/4,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-423,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,D10-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,K4-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,K4-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,K4-90,IF(G4>'Ergon Living Folding'!B45,\"-\")))))","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'!A18","v":"700TV01"},{"$f":"'Equipment A'!B18:B19","v":"Vertical frame kit"}]
[{"$f":"'Equipment A'!A19","v":"710TV01"}]
[{"$f":"'Equipment A'!A20","v":"720M101"},{"$f":"'Equipment A'!B20","v":"Upright with 1 rod"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"-"},"Poi nascondi"]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"-"},{"$f":"'Equipment A'!B25","v":"-"},{"$nulls":11},"<<Back to menù"]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"}]

{"sheet":"Equipment I","index":9,"n_rows":28,"n_cols":17,"rows_kept":28,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[2,11,3,12],[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,2,11,3],[12,1,13,1],[12,2,13,2],[14,1,15,1],[14,2,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],[16,2,16,3],[17,1,18,1],[18,2,19,3]]}
[{"$nulls":4},{"$f":"'Equipment A'!E1:F1","v":"Customer ref."},null,{"$f":"'Ergon Living Folding'!C12","v":0},null,{"$f":"'Equipment A'!I1","v":"Order ref."},{"$f":"'Ergon Living Folding'!C14","v":0},null,{"$f":"'Equipment A'!L1","v":"Order date"},{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[]
[{"$nulls":4},"Minimum 2975 mm",null,"LFM","Maximum 6185 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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,"Single door leaf","4 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA1 and LA4","Quote variable LA1","Quote variable LA4","Push & Go plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
[{"$f":"'Equipment A'!A9","v":"Code"},{"$f":"'Equipment A'!B9","v":"Description"},"\"LA1\"","\"LA4\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV4\"","\"PP\""]
[{"$f":"IF(A8=\"BLACK\",\"700AI01\",\"710AI01\")","v":"710AI01"},{"$f":"'Equipment A'!B10","v":"Equipment kit"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A47,\"-\",IF(G4>='Ergon Living Folding'!A47,IF(G4<=3535,\"670\",IF(G4<='Ergon Living Folding'!B47,(G4-185)/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<3535,(G4-185-C10)/4,IF(G4<='Ergon Living Folding'!B47,(G4-185)/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,G4-((D10*4)+251.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,G4-476,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,C10-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,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,Q10-65,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,K4-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,K4-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,K4-90,IF(G4>'Ergon Living Folding'!B47,\"-\")))))","v":"-"},"\\",null,null,{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A47,\"-\",IF(G4>='Ergon Living Folding'!A47,IF(G4<='Ergon Living Folding'!B47,C10+53,IF(G4>'Ergon Living Folding'!B47,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},{"$f":"IF(D10>674,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"},{"$f":"IF(D15>=560,\"\",\"Decrease LA size\")","v":""}]
[{"$f":"'Equipment A'!A14","v":"-"},null,null,{"$f":"IF(D15>=530,\"min 530 mm\",\"\")","v":"min 530 mm"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"},null,{"$f":"IF(C15=\"\",\"-\",D10-((C15-C10)/3))","v":"-"},{"$f":"IF(C15=\"\",\"-\",G4-(91+149.5)-(D15*3+6))","v":"-"},{"$f":"IF(C15=\"\",\"-\",F10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",G10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",C15-G15)","v":"-"},{"$f":"IF(C15=\"\",\"-\",D15-G15)","v":"-"},{"$f":"IF(C15=\"\",\"-\",#REF!-65)","v":"-"},{"$f":"IF(C15=\"\",\"-\",K10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",L10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",M10)","v":"-"},"\\"]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"IF(D15>674,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","v":"-"}]
[{"$f":"'Equipment A'!A18","v":"700TV01"},{"$f":"'Equipment A'!B18:B19","v":"Vertical frame kit"}]
[{"$f":"'Equipment A'!A19","v":"710TV01"},null,{"$f":"'Equipment B'!C19:D20","v":"Alternatively choose the size of the single door"}]
[{"$f":"'Equipment B'!A20","v":"720M201"},{"$f":"'Equipment B'!B20","v":"Upright with 2 rod"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"-"},{"$f":"'Equipment A'!B25","v":"-"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"}]
[]
[{"$nulls":13},"<<Back to menù"]

{"sheet":"Equipment L","index":10,"n_rows":26,"n_cols":14,"rows_kept":26,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[2,11,3,12],[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],[17,1,18,1],[21,14,22,14]]}
[{"$nulls":4},{"$f":"'Equipment A'!E1:F1","v":"Customer ref."},null,{"$f":"'Ergon Living Folding'!C12","v":0},null,{"$f":"'Equipment A'!I1","v":"Order ref."},{"$f":"'Ergon Living Folding'!C14","v":0},null,{"$f":"'Equipment A'!L1","v":"Order date"},{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[]
[{"$nulls":4},"Minimum 3195 mm",null,"LFM","Maximum 6195 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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 plate position","Passage height","Door leaf height","Wooden upright profile height","Wooden upright  profile height striker side"]
[{"$f":"'Equipment A'!A9","v":"Code"},{"$f":"'Equipment A'!B9","v":"Description"},null,"\"LA5\"","\"LP\"",null,"\"QF\"","\"QV5\"",null,"\"PP\""]
[{"$f":"IF(A8=\"BLACK\",\"700AL01\",\"710AL01\")","v":"710AL01"},{"$f":"'Equipment A'!B10","v":"Equipment kit"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A49,\"-\",IF(G4>='Ergon Living Folding'!A49,IF(G4<='Ergon Living Folding'!B49,(G4-195)/5,IF(G4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A49,\"-\",IF(G4>='Ergon Living Folding'!A49,IF(G4<='Ergon Living Folding'!B49,G4-483,IF(G4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},"\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A49,\"-\",IF(G4>='Ergon Living Folding'!A49,IF(G4<='Ergon Living Folding'!B49,391.5,IF(G4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A49,\"-\",IF(G4>='Ergon Living Folding'!A49,IF(G4<='Ergon Living Folding'!B49,D10-G10,IF(G4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},"\\","\\",{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A49,\"-\",IF(G4>='Ergon Living Folding'!A49,IF(G4<='Ergon Living Folding'!B49,K4-75,IF(G4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A49,\"-\",IF(G4>='Ergon Living Folding'!A49,IF(G4<='Ergon Living Folding'!B49,K4-92,IF(G4>'Ergon Living Folding'!B49,\"-\")))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A49,\"-\",IF(G4>='Ergon Living Folding'!A49,IF(G4<='Ergon Living Folding'!B49,K4-90,IF(G4>'Ergon Living Folding'!B49,\"-\")))))","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'!A18","v":"700TV01"},{"$f":"'Equipment A'!B18:B19","v":"Vertical frame kit"}]
[{"$f":"'Equipment A'!A19","v":"710TV01"}]
[{"$f":"'Equipment A'!A20","v":"720M101"},{"$f":"'Equipment A'!B20","v":"Upright with 1 rod"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"-"},"Poi nascondi"]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"-"},{"$f":"'Equipment A'!B25","v":"-"},{"$nulls":11},"<<Back to menù"]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"}]

{"sheet":"Equipment M","index":11,"n_rows":28,"n_cols":17,"rows_kept":28,"merged":[[0,4,0,5],[0,6,0,7],[0,9,0,10],[2,4,3,5],[2,7,3,8],[2,11,3,12],[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,2,11,3],[12,1,13,1],[12,2,13,2],[14,1,15,1],[14,2,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],[16,2,16,3],[17,1,18,1],[18,2,19,3]]}
[{"$nulls":4},{"$f":"'Equipment A'!E1:F1","v":"Customer ref."},null,{"$f":"'Ergon Living Folding'!C12","v":0},null,{"$f":"'Equipment A'!I1","v":"Order ref."},{"$f":"'Ergon Living Folding'!C14","v":0},null,{"$f":"'Equipment A'!L1","v":"Order date"},{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[]
[{"$nulls":4},"Minimum 3660 mm",null,"LFM","Maximum 6550 mm",null,null,"HFM","Maximum 3080 mm"]
[" ",{"$nulls":5},{"$f":"'Ergon Living Folding'!L9","v":0},{"$nulls":3},{"$f":"IF('Ergon Living Folding'!J17=0,'Ergon Living Folding'!O17+57.5,'Ergon Living Folding'!J17)","v":57.5},null,null,{"$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,"Single door leaf","5 Folding doors","Passage width","Double passage dimension","Fixed quote\nLA and LA5","Quote variable LA","Quote variable LA5","Push & Go plate position","Passage height","Door leaf height","Wooden upright profile height","\\"]
[{"$f":"'Equipment A'!A9","v":"Code"},{"$f":"'Equipment A'!B9","v":"Description"},"\"LA\"","\"LA5\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV5\"","\"PP\""]
[{"$f":"IF(A8=\"BLACK\",\"700AM01\",\"710AM01\")","v":"710AM01"},{"$f":"'Equipment A'!B10","v":"Equipment kit"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A51,\"-\",IF(G4>='Ergon Living Folding'!A51,IF(G4<=4210,\"670\",IF(G4<='Ergon Living Folding'!B51,(G4-190)/6,IF(G4>'Ergon Living Folding'!B51,\"-\"))))))","v":"-"},{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A51,\"-\",IF(G4>='Ergon Living Folding'!A51,IF(G4<4210,(G4-190-670)/5,IF(G4<='Ergon Living Folding'!B51,(G4-190)/6,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-(91+149.5)-(D10*5+12),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-149.5-385.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,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,C10-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,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,Q10-65,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,K4-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,K4-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,K4-90,IF(G4>'Ergon Living Folding'!B51,\"-\")))))","v":"-"},"\\",null,null,{"$f":"IF(G4=\"\",\"\",IF(G4<'Ergon Living Folding'!A51,\"-\",IF(G4>='Ergon Living Folding'!A51,IF(G4<='Ergon Living Folding'!B51,C10+53,IF(G4>'Ergon Living Folding'!B51,\"-\")))))","v":"-"}]
[{"$f":"'Equipment A'!A11","v":"-"},{"$f":"'Equipment A'!B11:B12","v":"-"},{"$f":"IF(D10>700,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","v":"-"}]
[{"$f":"'Equipment A'!A12","v":"-"}]
[{"$f":"'Equipment A'!A13","v":"-"},{"$f":"'Equipment A'!B13:B14","v":"-"},{"$f":"IF(D15>=560,\"\",\"Decrease LA size\")","v":""}]
[{"$f":"'Equipment A'!A14","v":"-"},null,null,{"$f":"IF(D15>=560,\"min 560 mm\",\"\")","v":"min 560 mm"}]
[{"$f":"'Equipment A'!A15","v":"-"},{"$f":"'Equipment A'!B15:B16","v":"-"},null,{"$f":"IF(C15=\"\",\"-\",D10-((C15-C10)/5))","v":"-"},{"$f":"IF(C15=\"\",\"-\",G4-(91+149.5)-(D15*5+12))","v":"-"},{"$f":"IF(C15=\"\",\"-\",F10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",G10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",C15-G15)","v":"-"},{"$f":"IF(C15=\"\",\"-\",D15-G15)","v":"-"},{"$f":"IF(C15=\"\",\"-\",#REF!-65)","v":"-"},{"$f":"IF(C15=\"\",\"-\",K10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",L10)","v":"-"},{"$f":"IF(C15=\"\",\"-\",M10)","v":"-"},"\\"]
[{"$f":"'Equipment A'!A16","v":"-"}]
[{"$f":"'Equipment A'!A17","v":"-"},{"$f":"'Equipment A'!B17","v":"-"},{"$f":"IF(D15>700,\"-\",\"SOFT OPENING ON ONE SIDE ONLY\")","v":"-"}]
[{"$f":"'Equipment A'!A18","v":"700TV01"},{"$f":"'Equipment A'!B18:B19","v":"Vertical frame kit"}]
[{"$f":"'Equipment A'!A19","v":"710TV01"},null,{"$f":"'Equipment B'!C19:D20","v":"Alternatively choose the size of the single door"}]
[{"$f":"'Equipment B'!A20","v":"720M201"},{"$f":"'Equipment B'!B20","v":"Upright with 2 rod"}]
[{"$f":"'Equipment A'!A21","v":"-"},{"$f":"'Equipment A'!B21","v":"-"}]
[{"$f":"'Equipment A'!A22","v":"-"},{"$f":"'Equipment A'!B22","v":"-"}]
[{"$f":"'Equipment A'!A23","v":"-"},{"$f":"'Equipment A'!B23","v":"-"}]
[{"$f":"'Equipment A'!A24","v":"-"},{"$f":"'Equipment A'!B24","v":"-"}]
[{"$f":"'Equipment A'!A25","v":"-"},{"$f":"'Equipment A'!B25","v":"-"}]
[{"$f":"'Equipment A'!A26","v":"-"},{"$f":"'Equipment A'!B26","v":"-"}]
[]
[{"$nulls":13},"<<Back to menù"]