{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Ergon Living Folding","Allestimento A","Allestimento B","Allestimento C","Allestimento D","Allestimento E","Allestimento F","Allestimento G","Allestimento H","Allestimento I","Allestimento L","Allestimento 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,11],[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},"Calcolatore sviluppo misure"]
[]
[]
[]
[{"$nulls":10},"COLORE"]
[]
[{"$nulls":11},"INPUT LFM (larghezza foro muro)"]
[{"$nulls":10},"Minimo 1245 mm ",null,"Massimo 6550 mm"]
[]
[{"$nulls":11},"Sciegliere il tipo di sistema"]
["Rif. Cliente",{"$nulls":5},"             ",{"$nulls":3},"↓","↓","↓"]
[]
["Rif. Ordine"]
[]
["Data ordine"]
[{"$nulls":9},"Sistema a soffitto",{"$nulls":4},"Sistema a controsoffitto"]
["OPTIONAL",{"$nulls":8},"INPUT HFM (altezza foro muro)",{"$nulls":4},"INPUT HC (altezza controsoffitto)"]
["Soft Opening",{"$nulls":9},"Massimo 3125",{"$nulls":4},"Massimo 3068"]
[]
["Push & Go",{"$nulls":13},"Altezza supporto controsoffitto"]
[]
["Incontro Push & Go",null,"Obbligatorio negli allestimenti B,C,E,F,G,I,M",{"$nulls":12},"mm"]
[]
["Cerniere"]
[]
["Guarnizione siliconica"]
[]
["Kit giunzione",null,null,{"$f":"IF(C29=\"SI\",\"Non applicabile agli allestimenti A-D-H-L\",\"\")","v":""}]
[]
[]
["LFM Minimo","LFM Massimo","ALLESTIMENTO","SI / NO"]
[1245,2585,"\"A\"",{"$f":"IF(L9<1245,\"\",IF(L9>2585,\"\",\"SI\"))","v":""},"Apertura singola - 2 ante pieghevoli"]
[]
[1910,3780,"\"B\"",{"$f":"IF(L9<1910,\"\",IF(L9>3780,\"\",\"SI\"))","v":""},"Apertura doppia - 1 anta singola + 2 ante pieghevoli"]
[]
[2300,4980,"\"C\"",{"$f":"IF(L9<2300,\"\",IF(L9>4980,\"\",\"SI\"))","v":""},"Apertura doppia - 2 ante pieghevoli + 2 ante pieghevoli"]
[]
[1990,3790,"\"D\"",{"$f":"IF(L9<1990,\"\",IF(L9>3790,\"\",\"SI\"))","v":""},"Apertura singola - 3 ante pieghevoli"]
[]
[2530,4980,"\"E\"",{"$f":"IF(L9<2530,\"\",IF(L9>4980,\"\",\"SI\"))","v":""},"Apertura doppia - 1 anta singola + 3 ante pieghevoli"]
[]
[2925,6185,"\"F\"",{"$f":"IF(L9<2925,\"\",IF(L9>6185,\"\",\"SI\"))","v":""},"Apertura doppia - 2 ante pieghevoli + 3 ante pieghevoli"]
[]
[3790,6550,"\"G\"",{"$f":"IF(L9<3790,\"\",IF(L9>6550,\"\",\"SI\"))","v":""},"Apertura doppia - 3 ante pieghevoli + 3 ante pieghevoli"]
[]
[2310,4990,"\"H\"",{"$f":"IF(L9<2310,\"\",IF(L9>4990,\"\",\"SI\"))","v":""},"Apertura singola - 4 ante pieghevoli"]
[]
[2975,6185,"\"I\"",{"$f":"IF(L9<2975,\"\",IF(L9>6185,\"\",\"SI\"))","v":""},"Apertura doppia - 1 anta singola + 4 ante pieghevoli"]
[]
[3195,6195,"\"L\"",{"$f":"IF(L9<3195,\"\",IF(L9>6195,\"\",\"SI\"))","v":""},"Apertura singola - 5 ante pieghevoli"]
[]
[3660,6550,"\"M\"",{"$f":"IF(L9<3660,\"\",IF(L9>6550,\"\",\"SI\"))","v":""},"Apertura doppia - 1 anta singola + 5 ante pieghevoli"]
[]
["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":"Allestimento A","index":1,"n_rows":34,"n_cols":14,"rows_kept":34,"merged":[[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":5},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"Rif. Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":4},"Minimo 1245 mm",null,"LFM","Massimo 2585 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"A\" (2 ANTE PIEGHEVOLI - APERTURA SINGOLA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"\\","2 Ante pieghevoli","Larghezza Passaggio","\\","Quota Fissa","Quota Variabile\nAnte Pieghevoli","\\","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","Altezza montante in legno lato incontro"]
["Codice","Descrizione",null,"\"LA2\"","\"LP\"",null,"\"QF\"","\"QV\"",null,"\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AA01\",\"710AA01\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",\"Kit allestimento\")","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=\"\",\"-\",\"Kit binario e telaio sup. per soffitto\")","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=\"\",\"-\",\"Kit binario per controsoffitto\")","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=\"\",\"-\",\"Kit telaio sup. controsoffitto\")","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=\"\",\"-\",\"Kit supporto controsoffitto\")","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,\"\"))))))))))","v":5}]
[]
[{"$f":"IF(B19=\"-\",\"-\",IF(L3<=2175,\"700TV01\",\"700TVL01\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",\"Kit telaio verticale\")","v":"-"}]
[{"$f":"IF(B19=\"-\",\"-\",IF(L3<=2175,\"710TV01\",\"710TVL01\"))","v":"-"}]
[{"$f":"IF(L3=57.5,\"-\",IF(L3<=2175,\"720M101\",\"720M1L01\"))","v":"-"},{"$f":"IF(L3=57.5,\"-\",\"Montante con 1 asta\")","v":"-"}]
[{"$f":"IF(B22=\"-\",\"-\",\"700S101\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C19=\"SI\",\"Soft Opening S1\",\"-\")","v":"-"},"Poi nascondi"]
[{"$f":"IF(B23=\"-\",\"-\",\"700SP01\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C19=\"SI\",\"Soft Opening PLUS\",\"-\")","v":"-"},1]
[{"$f":"IF(B24=\"-\",\"-\",IF('Ergon Living Folding'!D21=\"Cromo Satinato\",\"4100CSL\",IF('Ergon Living Folding'!D21=\"Ottone Lucido\",\"4100OLL\",IF('Ergon Living Folding'!D21=\"Nichel Lucido\",\"4100NLL\",IF('Ergon Living Folding'!D21=\"Nichel Nero\",\"4100NNL\",IF('Ergon Living Folding'!D21=\"Bronzato\",\"4100BRL\",IF('Ergon Living Folding'!D21=\"Bianco Opaco\",\"4100BOL\",IF('Ergon Living Folding'!D21=\"Nero Opaco\",\"4100NEOL\"))))))))","v":"-"},{"$f":"IF('Ergon Living Folding'!C21=\"SI\",\"Push & Go\ncon cavetto da 250 cm\",\"-\")","v":"-"}]
[{"$f":"IF(A8=\"NERO\",\"4150IN\",\"4150IA\")","v":"4150IA"},{"$f":"\"Incontro Push & Go\"","v":"Incontro Push & Go"}]
[{"$f":"IF(B26=\"-\",\"-\",IF(A8=\"NERO\",\"C701000F1\",\"C721000F1\"))","v":"-"},{"$f":"IF('Ergon Living Folding'!C25=\"SI\",\"Coppia Cerniere\",\"-\")","v":"-"},1]
[{"$f":"IF(B27=\"-\",\"-\",IF('Ergon Living Folding'!D27=\"Bianco\",\"GS68012B\",IF('Ergon Living Folding'!D27=\"Nero\",\"GS68012N\",IF('Ergon Living Folding'!D27=\"Marrone\",\"GS68012M\",\"-\"))))","v":"-"},{"$f":"IF('Ergon Living Folding'!C27=\"SI\",\"Guarnizione\",\"-\")","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"IF('Ergon Living Folding'!C29=\"SI\",\"564100\",\"-\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C29=\"SI\",\"Kit giunzione\",\"-\")","v":"-"}]
["Kit giunzione non applicabile su questo allestimento"]
[]
[]
[]
[]
[{"$nulls":12},"<<Torna al menù"]

{"sheet":"Allestimento B","index":2,"n_rows":36,"n_cols":19,"rows_kept":36,"merged":[[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],[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":6},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"N° Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":11},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":5},"Minimo 1910 mm",null,"LFM","Massimo 3780 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"B\" (1 ANTA SINGOLA + 2 ANTE PIEGHEVOLI - APERTURA DOPPIA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,null,"Anta Singola","2 Ante pieghevoli","Larghezza Passaggio","Larghezza di Passaggio Doppia","Quota Fissa\nLA e LA2","Quota Variabile LA","Quota Variabile LA2","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","\\"]
["Codice","Descrizione",null,"\"LA\"","\"LA2\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV2\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AB01\",\"710AB01\"))","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A11","v":"-"},{"$f":"'Allestimento A'!B11:B12","v":"-"},null,{"$f":"IF(B28=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO KIT GIUNZIONE\",\"-\",IF(D10<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO KIT GIUNZIONE\",\"-\",IF(B28=\"Kit giunzione\",\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(D10<775,\"NO KIT GIUNZIONE\",\"-\")))","v":"-"}]
[{"$f":"'Allestimento A'!A12","v":"-"},null,null,"-"]
[{"$f":"'Allestimento A'!A13","v":"-"},{"$f":"'Allestimento A'!B13:B14","v":"-"},null,{"$f":"IF(E15<530,\"Diminuire dimensione LA\",IF(E15>1200,\"Aumentare dimensione LA\",\"\"))","v":"Aumentare dimensione LA"}]
[{"$f":"'Allestimento A'!A14","v":"-"},{"$nulls":3},{"$f":"IF(E15<530,\"min 530 mm\",IF(E15>1200,\"max 1200 mm\",\"\"))","v":"max 1200 mm"}]
[{"$f":"'Allestimento A'!A15","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A16","v":"-"}]
[{"$f":"'Allestimento A'!A17","v":"-"},{"$f":"'Allestimento A'!B17","v":"-"},{"$f":"IF(H4>6000,13,IF(H4>5500,12,IF(H4>5000,11,IF(H4>4500,10,IF(H4>4000,9,IF(H4>3500,8,IF(H4>3000,7,IF(H4>2500,6,IF(H4>2000,5,IF(H4<=1500,5,\"\"))))))))))","v":5},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO KIT GIUNZIONE\",\"-\",IF(D15<670,\"-\",IF(D15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(F17=\"NO KIT GIUNZIONE\",\"-\",IF(B28=\"Kit giunzione\",\"No Soft Opening\",\"-\")))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(D15<775,\"NO KIT GIUNZIONE\",\"-\"))","v":"-"}]
[{"$nulls":3},"-"]
[{"$f":"'Allestimento A'!A19","v":"-"},{"$f":"'Allestimento A'!B19:B20","v":"-"},null,"In alternativa scegliere la dimensione dell'anta singola"]
[{"$f":"'Allestimento A'!A20","v":"-"}]
[{"$f":"IF(M3=57.5,\"-\",IF(M3<=2175,\"720M201\",\"720M2L01\"))","v":"-"},{"$f":"IF(M3=57.5,\"-\",\"Montante con 2 aste\")","v":"-"}]
[{"$f":"'Allestimento A'!A22","v":"-"},{"$f":"'Allestimento A'!B22","v":"-"},{"$f":"IF(B22=\"Soft Opening S1\",1,\"-\")","v":"-"}]
[{"$f":"'Allestimento A'!A23","v":"-"},{"$f":"'Allestimento A'!B23","v":"-"},{"$f":"IF(B23=\"Soft Opening PLUS\",1,\"-\")","v":"-"}]
[{"$f":"'Allestimento A'!A24","v":"-"},{"$f":"'Allestimento A'!B24","v":"-"}]
[{"$f":"'Allestimento A'!A25","v":"4150IA"},{"$f":"'Allestimento A'!B25","v":"Incontro Push & Go"}]
[{"$f":"'Allestimento A'!A26","v":"-"},{"$f":"'Allestimento A'!B26","v":"-"},1]
[{"$f":"'Allestimento A'!A27","v":"-"},{"$f":"'Allestimento A'!B27","v":"-"},{"$f":"IF(M10=\"-\",\"\",((C26*M10)/1000)&\" mt\")","v":""}]
[{"$f":"'Allestimento A'!A28","v":"-"},{"$f":"'Allestimento A'!B28","v":"-"}]
{"$rows_empty":7}
[{"$nulls":13},"<<Torna al menù"]

{"sheet":"Allestimento C","index":3,"n_rows":29,"n_cols":18,"rows_kept":29,"merged":[[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],[10,4,11,5],[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":5},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"N° Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":4},"Minimo 2300 mm",null,"LFM","Massimo 4980 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"C\" (2 ANTE PIEGHEVOLI + 2 ANTE PIEGHEVOLI - APERTURA DOPPIA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"\\","2 Ante pieghevoli","Larghezza Passaggio","Larghezza di Passaggio Doppia","Quota Fissa\nLA2","\\","Quota Variabile LA2","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","\\"]
["Codice","Descrizione","\\","\"LA2\"","\"LP\"","\"LPD\"","\"QF\"","\\","\"QV2\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AC01\",\"710AC01\"))","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A11","v":"-"},{"$f":"'Allestimento A'!B11:B12","v":"-"},null,{"$f":"IF(D10=\"-\",\"-\",IF(B28=\"Kit giunzione\",\"No Soft Opening\",\"-\"))","v":"-"}]
[{"$f":"'Allestimento A'!A12","v":"-"}]
[{"$f":"'Allestimento A'!A13","v":"-"},{"$f":"'Allestimento A'!B13:B14","v":"-"}]
[{"$f":"'Allestimento A'!A14","v":"-"}]
[{"$f":"'Allestimento A'!A15","v":"-"},{"$f":"'Allestimento A'!B15:B16","v":"-"}]
[{"$f":"'Allestimento A'!A16","v":"-"}]
[{"$f":"'Allestimento A'!A17","v":"-"},{"$f":"'Allestimento A'!B17","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,\"\"))))))))))","v":5}]
[]
[{"$f":"'Allestimento A'!A19","v":"-"},{"$f":"'Allestimento A'!B19:B20","v":"-"}]
[{"$f":"'Allestimento A'!A20","v":"-"}]
[{"$f":"'Allestimento B'!A21","v":"-"},{"$f":"'Allestimento B'!B21","v":"-"}]
[{"$f":"'Allestimento A'!A22","v":"-"},{"$f":"'Allestimento A'!B22","v":"-"}]
[{"$f":"'Allestimento A'!A23","v":"-"},{"$f":"'Allestimento A'!B23","v":"-"},2]
[{"$f":"'Allestimento A'!A24","v":"-"},{"$f":"'Allestimento A'!B24","v":"-"}]
[{"$f":"'Allestimento A'!A25","v":"4150IA"},{"$f":"'Allestimento A'!B25","v":"Incontro Push & Go"}]
[{"$f":"'Allestimento A'!A26","v":"-"},{"$f":"'Allestimento A'!B26","v":"-"},2]
[{"$f":"'Allestimento A'!A27","v":"-"},{"$f":"'Allestimento A'!B27","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"'Allestimento A'!A28","v":"-"},{"$f":"'Allestimento A'!B28","v":"-"}]
[{"$nulls":12},"<<Torna al menù"]

{"sheet":"Allestimento D","index":4,"n_rows":32,"n_cols":14,"rows_kept":32,"merged":[[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":5},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"N° Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":4},"Minimo 1990 mm",null,"LFM","Massimo 3790 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"D\" (3 ANTE PIEGHEVOLI - APERTURA SINGOLA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"\\","3 Ante pieghevoli","Larghezza Passaggio","\\","Quota Fissa","Quota Variabile\nAnte Pieghevoli","\\","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","Altezza montante in legno lato incontro"]
["Codice","Descrizione",null,"\"LA3\"","\"LP\"",null,"\"QF\"","\"QV\"",null,"\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AD01\",\"710AD01\"))","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A11","v":"-"},{"$f":"'Allestimento A'!B11:B12","v":"-"},{"$f":"IF(D10>674,\"-\",\"No Soft Opening\")","v":"-"}]
[{"$f":"'Allestimento A'!A12","v":"-"}]
[{"$f":"'Allestimento A'!A13","v":"-"},{"$f":"'Allestimento A'!B13:B14","v":"-"}]
[{"$f":"'Allestimento A'!A14","v":"-"}]
[{"$f":"'Allestimento A'!A15","v":"-"},{"$f":"'Allestimento A'!B15:B16","v":"-"}]
[{"$f":"'Allestimento A'!A16","v":"-"}]
[{"$f":"'Allestimento A'!A17","v":"-"},{"$f":"'Allestimento A'!B17","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,\"\"))))))))))","v":5}]
[]
[{"$f":"'Allestimento A'!A19","v":"-"},{"$f":"'Allestimento A'!B19","v":"-"}]
[{"$f":"'Allestimento A'!A20","v":"-"}]
[{"$f":"'Allestimento A'!A21","v":"-"},{"$f":"'Allestimento A'!B21","v":"-"}]
[{"$f":"'Allestimento A'!A22","v":"-"},{"$f":"'Allestimento A'!B22","v":"-"},"Poi nascondi"]
[{"$f":"'Allestimento A'!A23","v":"-"},{"$f":"'Allestimento A'!B23","v":"-"},1]
[{"$f":"'Allestimento A'!A24","v":"-"},{"$f":"'Allestimento A'!B24","v":"-"}]
[{"$f":"'Allestimento A'!A25","v":"4150IA"},{"$f":"'Allestimento A'!B25","v":"Incontro Push & Go"}]
[{"$f":"'Allestimento A'!A26","v":"-"},{"$f":"'Allestimento A'!B26","v":"-"},2]
[{"$f":"'Allestimento A'!A27","v":"-"},{"$f":"'Allestimento A'!B27","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"'Allestimento A'!A28","v":"-"},{"$f":"'Allestimento A'!B28","v":"-"}]
["Kit giunzione non applicabile su questo allestimento"]
[]
[]
[{"$nulls":12},"<<Torna al menù"]

{"sheet":"Allestimento E","index":5,"n_rows":31,"n_cols":29,"rows_kept":31,"merged":[[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],[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":6},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"N° Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":11},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":5},"Minimo 2530 mm",null,"LFM","Massimo 4980 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"E\" (1 ANTA SINGOLA + 3 ANTE PIEGHEVOLI - APERTURA DOPPIA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,null,"Anta Singola","3 Ante pieghevoli","Larghezza Passaggio","Larghezza di Passaggio Doppia","Quota Fissa\nLA e LA3","Quota Variabile LA","Quota Variabile LA3","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","\\"]
["Codice","Descrizione",null,"\"LA\"","\"LA3\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV3\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AE01\",\"710AE01\"))","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A11","v":"-"},{"$f":"'Allestimento A'!B11:B12","v":"-"},null,{"$f":"IF(B28=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO KIT GIUNZIONE\",\"-\",IF(D10<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO KIT GIUNZIONE\",\"-\",IF(B28=\"Kit giunzione\",IF(E10<850,\"No Soft Opening\",\"-\"),\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(D10<775,\"NO KIT GIUNZIONE\",\"-\")))","v":"-"}]
[{"$f":"'Allestimento A'!A12","v":"-"},null,null,{"$f":"IF(D10=\"-\",\"-\",IF((D10+E10)>1369.9,\"-\",\"SOFT OPENING SOLO DA UN LATO\"))","v":"-"}]
[{"$f":"'Allestimento A'!A13","v":"-"},{"$f":"'Allestimento A'!B13:B14","v":"-"},null,{"$f":"IF(E15<560,\"Diminuire dimensione LA\",IF(E15>1200,\"Aumentare dimensione LA\",\"\"))","v":"Aumentare dimensione LA"}]
[{"$f":"'Allestimento A'!A14","v":"-"},{"$nulls":3},{"$f":"IF(E15<560,\"min 560 mm\",IF(E15>1200,\"max 1200 mm\",\"\"))","v":"max 1200 mm"}]
[{"$f":"'Allestimento A'!A15","v":"-"},{"$f":"'Allestimento 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":"IF(D15=\"\",\"-\",T10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",U10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",S15-335.5)","v":"-"},{"$f":"IF(D15=\"\",\"-\",Q15-S15-(271+65))","v":"-"},{"$f":"IF(D15=\"\",\"-\",X10)","v":"-"},null,{"$f":"IF(D15=\"\",\"-\",Z10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",AA10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",AB10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",AC10)","v":"-"}]
[{"$f":"'Allestimento A'!A16","v":"-"}]
[{"$f":"'Allestimento A'!A17","v":"-"},{"$f":"'Allestimento A'!B17","v":"-"},{"$f":"IF(H4>6000,13,IF(H4>5500,12,IF(H4>5000,11,IF(H4>4500,10,IF(H4>4000,9,IF(H4>3500,8,IF(H4>3000,7,IF(H4>2500,6,IF(H4>2000,5,IF(H4<=1500,5,\"\"))))))))))","v":5},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO KIT GIUNZIONE\",\"-\",IF(D15<670,\"-\",IF(D15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO KIT GIUNZIONE\",\"-\",IF(E15<695,\"-\",IF(E15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(D15<775,\"NO KIT GIUNZIONE\",IF(E15<745,\"NO KIT GIUNZIONE\",\"-\")))","v":"-"}]
[{"$nulls":3},{"$f":"IF(D15=\"\",\"-\",IF((D15+E15)>1369.9,\"-\",\"SOFT OPENING SOLO DA UN LATO\"))","v":"-"}]
[{"$f":"'Allestimento A'!A19","v":"-"},{"$f":"'Allestimento A'!B19:B20","v":"-"},null,"In alternativa scegliere la dimensione dell'anta singola"]
[{"$f":"'Allestimento A'!A20","v":"-"}]
[{"$f":"'Allestimento B'!A21","v":"-"},{"$f":"'Allestimento B'!B21","v":"-"}]
[{"$f":"'Allestimento A'!A22","v":"-"},{"$f":"'Allestimento A'!B22","v":"-"},{"$f":"IF(B22=\"Soft Opening S1\",1,\"-\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C19=\"SI\",\"←Scegliere uno dei due\",\"\")","v":""}]
[{"$f":"'Allestimento A'!A23","v":"-"},{"$f":"'Allestimento A'!B23","v":"-"},{"$f":"IF(B23=\"Soft Opening PLUS\",1,\"-\")","v":"-"}]
[{"$f":"'Allestimento A'!A24","v":"-"},{"$f":"'Allestimento A'!B24","v":"-"}]
[{"$f":"'Allestimento A'!A25","v":"4150IA"},{"$f":"'Allestimento A'!B25","v":"Incontro Push & Go"}]
[{"$f":"'Allestimento A'!A26","v":"-"},{"$f":"'Allestimento A'!B26","v":"-"},2]
[{"$f":"'Allestimento A'!A27","v":"-"},{"$f":"'Allestimento A'!B27","v":"-"},{"$f":"IF(M10=\"-\",\"\",((C26*M10)/1000)&\" mt\")","v":""}]
[{"$f":"'Allestimento A'!A28","v":"-"},{"$f":"'Allestimento A'!B28","v":"-"}]
[]
[]
[{"$nulls":13},"<<Torna al menù"]

{"sheet":"Allestimento F","index":6,"n_rows":34,"n_cols":29,"rows_kept":34,"merged":[[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],[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":6},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"N° Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":11},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":5},"Minimo 2925 mm",null,"LFM","Massimo 6185 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"F\" (2 ANTE PIEGHEVOLI + 3 ANTE PIEGHEVOLI - APERTURA DOPPIA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,null,"2 Ante pieghevoli","3 Ante pieghevoli","Larghezza Passaggio","Larghezza di Passaggio Doppia","Quota Fissa\nLA2 e LA3","Quota Variabile LA2","Quota Variabile LA3","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","\\"]
["Codice","Descrizione",null,"\"LA2\"","\"LA3\"","\"LP\"","\"LPD\"","\"QF\"","\"QV2\"","\"QV3\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AF01\",\"710AF01\"))","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A11","v":"-"},{"$f":"'Allestimento A'!B11:B12","v":"-"},null,{"$f":"IF(B28=\"-\",\"-\",IF(F11=\"NO KIT GIUNZIONE\",\"-\",IF(D15>0,\"-\",\"No Soft Opening\")))","v":"-"},{"$f":"IF(B28=\"-\",\"-\",IF(F11=\"NO KIT GIUNZIONE\",\"-\",IF(D15>0,\"-\",IF(E10<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(E10<745,\"NO KIT GIUNZIONE\",\"-\")))","v":"-"}]
[{"$f":"'Allestimento A'!A12","v":"-"},null,null,{"$f":"IF(E10>589.9,\"-\",IF(D15>0,\"-\",\"SOFT OPENING SOLO DA UN LATO\"))","v":"-"}]
[{"$f":"'Allestimento A'!A13","v":"-"},{"$f":"'Allestimento A'!B13:B14","v":"-"},null,{"$f":"IF(E15<560,\"Diminuire dimensione LA\",IF(E15>1200,\"Aumentare dimensione LA\",\"\"))","v":"Aumentare dimensione LA"}]
[{"$f":"'Allestimento A'!A14","v":"-"},{"$nulls":3},{"$f":"IF(E15<560,\"min 560 mm\",IF(E15>1200,\"max 1200 mm\",\"\"))","v":"max 1200 mm"}]
[{"$f":"'Allestimento A'!A15","v":"-"},{"$f":"'Allestimento 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":"-"},"\\",null,{"$f":"IF(D15=\"\",\"-\",Q10)","v":"-"},null,{"$f":"IF(D15=\"\",\"-\",(D15*2)+53+3)","v":"-"},{"$f":"IF(D15=\"\",\"-\",T10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",U10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",S15-335.5)","v":"-"},{"$f":"IF(D15=\"\",\"-\",Q15-S15-(271+65))","v":"-"},{"$f":"IF(D15=\"\",\"-\",X10)","v":"-"},null,{"$f":"IF(D15=\"\",\"-\",Z10)","v":"-"},{"$f":"IF(D15=\"\",\"-\",AA10)","v":"-"},"\\",{"$f":"IF(D15=\"\",\"-\",AC10)","v":"-"}]
[{"$f":"'Allestimento A'!A16","v":"-"}]
[{"$f":"'Allestimento A'!A17","v":"-"},{"$f":"'Allestimento A'!B17","v":"-"},{"$f":"IF(H4>6000,13,IF(H4>5500,12,IF(H4>5000,11,IF(H4>4500,10,IF(H4>4000,9,IF(H4>3500,8,IF(H4>3000,7,IF(H4>2500,6,IF(H4>2000,5,IF(H4<=1500,5,\"\"))))))))))","v":5},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO KIT GIUNZIONE\",\"-\",\"No Soft Opening\"))","v":"-"},{"$f":"IF(D15=\"-\",\"-\",IF(F17=\"NO KIT GIUNZIONE\",\"-\",IF(B28=\"Kit giunzione\",IF(E15<850,\"No Soft Opening\",\"-\"),\"-\")))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(E15<745,\"NO KIT GIUNZIONE\",\"-\"))","v":"-"}]
[{"$nulls":3},{"$f":"IF(E15>589.9,\"-\",IF(E15=\"\",\"-\",\"SOFT OPENING SOLO DA UN LATO\"))","v":"-"}]
[{"$f":"'Allestimento A'!A19","v":"-"},{"$f":"'Allestimento A'!B19:B20","v":"-"},null,"In alternativa scegliere la dimensione delle 2 ante pieghevoli"]
[{"$f":"'Allestimento A'!A20","v":"-"}]
[{"$f":"'Allestimento B'!A21","v":"-"},{"$f":"'Allestimento B'!B21","v":"-"}]
[{"$f":"'Allestimento A'!A22","v":"-"},{"$f":"'Allestimento A'!B22","v":"-"}]
[{"$f":"'Allestimento A'!A23","v":"-"},{"$f":"'Allestimento A'!B23","v":"-"},{"$f":"IF(D12=\"SOFT OPENING SOLO DA UN LATO\",\"1\",IF(D11=\"No soft opening\",\"1\",IF(D18=\"SOFT OPENING SOLO DA UN LATO\",\"1\",IF(D17=\"No soft opening\",\"1\",\"2\"))))","v":"2"}]
[{"$f":"'Allestimento A'!A24","v":"-"},{"$f":"'Allestimento A'!B24","v":"-"}]
[{"$f":"'Allestimento A'!A25","v":"4150IA"},{"$f":"'Allestimento A'!B25","v":"Incontro Push & Go"}]
[{"$f":"'Allestimento A'!A26","v":"-"},{"$f":"'Allestimento A'!B26","v":"-"},3]
[{"$f":"'Allestimento A'!A27","v":"-"},{"$f":"'Allestimento A'!B27","v":"-"},{"$f":"IF(M10=\"-\",\"\",((C26*M10)/1000)&\" mt\")","v":""}]
[{"$f":"'Allestimento A'!A28","v":"-"},{"$f":"'Allestimento A'!B28","v":"-"}]
[]
[]
[]
[]
[]
[{"$nulls":13},"<<Torna al menù"]

{"sheet":"Allestimento G","index":7,"n_rows":29,"n_cols":18,"rows_kept":29,"merged":[[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":5},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"N° Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":4},"Minimo 3790 mm",null,"LFM","Massimo 6550 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"G\" (3 ANTE PIEGHEVOLI + 3 ANTE PIEGHEVOLI - APERTURA DOPPIA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"3 Ante pieghevoli","\\","Larghezza Passaggio","Larghezza di Passaggio Doppia","Quota Fissa LA3","\\","Quota Variabile LA3","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","\\"]
["Codice","Descrizione","\"LA3\"",null,"\"LP\"","\"LPD\"","\"QF\"",null,"\"QV3\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AG01\",\"710AG01\"))","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A11","v":"-"},{"$f":"'Allestimento A'!B11:B12","v":"-"},{"$f":"IF(B28=\"-\",\"-\",IF(E11=\"NO KIT GIUNZIONE\",\"-\",IF(C10<850,\"No Soft Opening\",\"-\")))","v":"-"},"\\",{"$f":"IF(C10=\"-\",\"-\",IF(C10<745,\"NO KIT GIUNZIONE\",\"-\"))","v":"-"}]
[{"$f":"'Allestimento A'!A12","v":"-"},null,{"$f":"IF(C10>684.9,\"-\",\"SOFT OPENING SOLO DA UN LATO\")","v":"-"}]
[{"$f":"'Allestimento A'!A13","v":"-"},{"$f":"'Allestimento A'!B13:B14","v":"-"}]
[{"$f":"'Allestimento A'!A14","v":"-"}]
[{"$f":"'Allestimento A'!A15","v":"-"},{"$f":"'Allestimento A'!B15:B16","v":"-"}]
[{"$f":"'Allestimento A'!A16","v":"-"}]
[{"$f":"'Allestimento A'!A17","v":"-"},{"$f":"'Allestimento A'!B17","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,\"\"))))))))))","v":5}]
[]
[{"$f":"'Allestimento A'!A19","v":"-"},{"$f":"'Allestimento A'!B19:B20","v":"-"}]
[{"$f":"'Allestimento A'!A20","v":"-"}]
[{"$f":"'Allestimento B'!A21","v":"-"},{"$f":"'Allestimento B'!B21","v":"-"}]
[{"$f":"'Allestimento A'!A22","v":"-"},{"$f":"'Allestimento A'!B22","v":"-"}]
[{"$f":"'Allestimento A'!A23","v":"-"},{"$f":"'Allestimento A'!B23","v":"-"},{"$f":"IF(C11=\"SOFT OPENING SOLO DA UN LATO\",\"1\",IF(C12=\"SOFT OPENING SOLO DA UN LATO\",\"1\",\"2\"))","v":"2"}]
[{"$f":"'Allestimento A'!A24","v":"-"},{"$f":"'Allestimento A'!B24","v":"-"}]
[{"$f":"'Allestimento A'!A25","v":"4150IA"},{"$f":"'Allestimento A'!B25","v":"Incontro Push & Go"}]
[{"$f":"'Allestimento A'!A26","v":"-"},{"$f":"'Allestimento A'!B26","v":"-"},4]
[{"$f":"'Allestimento A'!A27","v":"-"},{"$f":"'Allestimento A'!B27","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"'Allestimento A'!A28","v":"-"},{"$f":"'Allestimento A'!B28","v":"-"}]
[{"$nulls":13},"<<Torna al menù"]

{"sheet":"Allestimento H","index":8,"n_rows":29,"n_cols":14,"rows_kept":29,"merged":[[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":5},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"N° Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":4},"Minimo 2310 mm",null,"LFM","Massimo 4990 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"H\" (4 ANTE PIEGHEVOLI - APERTURA SINGOLA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"\\","4 Ante pieghevoli","Larghezza Passaggio","\\","Quota Fissa\nLA4","Quota Variabile LA4","\\","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","Altezza montante in legno lato incontro"]
["Codice","Descrizione","\\","\"LA4\"","\"LP\"",null,"\"QF\"","\"QV4\"",null,"\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AH01\",\"710AH01\"))","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A11","v":"-"},{"$f":"'Allestimento A'!B11:B12","v":"-"}]
[{"$f":"'Allestimento A'!A12","v":"-"}]
[{"$f":"'Allestimento A'!A13","v":"-"},{"$f":"'Allestimento A'!B13:B14","v":"-"}]
[{"$f":"'Allestimento A'!A14","v":"-"}]
[{"$f":"'Allestimento A'!A15","v":"-"},{"$f":"'Allestimento A'!B15:B16","v":"-"}]
[{"$f":"'Allestimento A'!A16","v":"-"}]
[{"$f":"'Allestimento A'!A17","v":"-"},{"$f":"'Allestimento A'!B17","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,\"\"))))))))))","v":5}]
[]
[{"$f":"'Allestimento A'!A19","v":"-"},{"$f":"'Allestimento A'!B19:B20","v":"-"}]
[{"$f":"'Allestimento A'!A20","v":"-"}]
[{"$f":"'Allestimento A'!A21","v":"-"},{"$f":"'Allestimento A'!B21","v":"-"}]
[{"$f":"'Allestimento A'!A22","v":"-"},{"$f":"'Allestimento A'!B22","v":"-"},"Poi nascondi"]
[{"$f":"'Allestimento A'!A23","v":"-"},{"$f":"'Allestimento A'!B23","v":"-"},1]
[{"$f":"'Allestimento A'!A24","v":"-"},{"$f":"'Allestimento A'!B24","v":"-"}]
[{"$f":"'Allestimento A'!A25","v":"4150IA"},{"$f":"'Allestimento A'!B25","v":"Incontro Push & Go"}]
[{"$f":"'Allestimento A'!A26","v":"-"},{"$f":"'Allestimento A'!B26","v":"-"},3]
[{"$f":"'Allestimento A'!A27","v":"-"},{"$f":"'Allestimento A'!B27","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"'Allestimento A'!A28","v":"-"},{"$f":"'Allestimento A'!B28","v":"-"}]
["Kit giunzione non applicabile su questo allestimento",{"$nulls":12},"<<Torna al menù"]

{"sheet":"Allestimento I","index":9,"n_rows":30,"n_cols":19,"rows_kept":30,"merged":[[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],[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":6},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"N° Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":11},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":5},"Minimo 2975 mm",null,"LFM","Massimo 6185 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"I\" (1 ANTA SINGOLA + 4 ANTE PIEGHEVOLI - APERTURA DOPPIA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,null,"Anta Singola","4 Ante pieghevoli","Larghezza Passaggio","Larghezza di Passaggio Doppia","Quota Fissa\nLA1 e LA4","Quota Variabile LA1","Quota Variabile LA4","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","\\"]
["Codice","Descrizione",null,"\"LA1\"","\"LA4\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV4\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AI01\",\"710AI01\"))","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A11","v":"-"},{"$f":"'Allestimento A'!B11:B12","v":"-"},null,{"$f":"IF(B28=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO KIT GIUNZIONE\",\"-\",IF(D10<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO KIT GIUNZIONE\",\"-\",IF(B28=\"Kit giunzione\",\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(D10<775,\"NO KIT GIUNZIONE\",\"-\")))","v":"-"}]
[{"$f":"'Allestimento A'!A12","v":"-"},null,null,"-"]
[{"$f":"'Allestimento A'!A13","v":"-"},{"$f":"'Allestimento A'!B13:B14","v":"-"},null,{"$f":"IF(E15<530,\"Diminuire dimensione LA\",IF(E15>1200,\"Aumentare dimensione LA\",\"\"))","v":"Aumentare dimensione LA"}]
[{"$f":"'Allestimento A'!A14","v":"-"},{"$nulls":3},{"$f":"IF(E15<530,\"min 530 mm\",IF(E15>1200,\"max 1200 mm\",\"\"))","v":"max 1200 mm"}]
[{"$f":"'Allestimento A'!A15","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A16","v":"-"}]
[{"$f":"'Allestimento A'!A17","v":"-"},{"$f":"'Allestimento A'!B17","v":"-"},{"$f":"IF(H4>6000,13,IF(H4>5500,12,IF(H4>5000,11,IF(H4>4500,10,IF(H4>4000,9,IF(H4>3500,8,IF(H4>3000,7,IF(H4>2500,6,IF(H4>2000,5,IF(H4<=1500,5,\"\"))))))))))","v":5},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO KIT GIUNZIONE\",\"-\",IF(D15<670,\"-\",IF(D15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(F17=\"NO KIT GIUNZIONE\",\"-\",IF(B28=\"Kit giunzione\",\"No Soft Opening\",\"-\")))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(D15<775,\"NO KIT GIUNZIONE\",\"-\"))","v":"-"}]
[{"$nulls":3},"-"]
[{"$f":"'Allestimento A'!A19","v":"-"},{"$f":"'Allestimento A'!B19:B20","v":"-"},null,"In alternativa scegliere la dimensione dell'anta singola"]
[{"$f":"'Allestimento A'!A20","v":"-"}]
[{"$f":"'Allestimento B'!A21","v":"-"},{"$f":"'Allestimento B'!B21","v":"-"}]
[{"$f":"'Allestimento A'!A22","v":"-"},{"$f":"'Allestimento A'!B22","v":"-"},{"$f":"IF(B22=\"Soft Opening S1\",1,\"-\")","v":"-"}]
[{"$f":"'Allestimento A'!A23","v":"-"},{"$f":"'Allestimento A'!B23","v":"-"},{"$f":"IF(B23=\"Soft Opening PLUS\",1,\"-\")","v":"-"}]
[{"$f":"'Allestimento A'!A24","v":"-"},{"$f":"'Allestimento A'!B24","v":"-"}]
[{"$f":"'Allestimento A'!A25","v":"4150IA"},{"$f":"'Allestimento A'!B25","v":"Incontro Push & Go"}]
[{"$f":"'Allestimento A'!A26","v":"-"},{"$f":"'Allestimento A'!B26","v":"-"},3]
[{"$f":"'Allestimento A'!A27","v":"-"},{"$f":"'Allestimento A'!B27","v":"-"},{"$f":"IF(M10=\"-\",\"\",((C26*M10)/1000)&\" mt\")","v":""}]
[{"$f":"'Allestimento A'!A28","v":"-"},{"$f":"'Allestimento A'!B28","v":"-"}]
[]
[{"$nulls":14},"<<Torna al menù"]

{"sheet":"Allestimento L","index":10,"n_rows":29,"n_cols":14,"rows_kept":29,"merged":[[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":5},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"N° Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":10},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":4},"Minimo 3195 mm",null,"LFM","Massimo 6195 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"L\" (5 ANTE PIEGHEVOLI - APERTURA SINGOLA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,"\\","5 Ante pieghevoli","Larghezza Passaggio","\\","Quota Fissa\nLA5","Quota Variabile LA5","\\","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","Altezza montante in legno lato incontro"]
["Codice","Descrizione",null,"\"LA5\"","\"LP\"",null,"\"QF\"","\"QV5\"",null,"\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AL01\",\"710AL01\"))","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A11","v":"-"},{"$f":"'Allestimento A'!B11:B12","v":"-"},{"$f":"IF(D10>674,\"-\",\"No Soft Opening\")","v":"-"}]
[{"$f":"'Allestimento A'!A12","v":"-"}]
[{"$f":"'Allestimento A'!A13","v":"-"},{"$f":"'Allestimento A'!B13:B14","v":"-"}]
[{"$f":"'Allestimento A'!A14","v":"-"}]
[{"$f":"'Allestimento A'!A15","v":"-"},{"$f":"'Allestimento A'!B15:B16","v":"-"}]
[{"$f":"'Allestimento A'!A16","v":"-"}]
[{"$f":"'Allestimento A'!A17","v":"-"},{"$f":"'Allestimento A'!B17","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,\"\"))))))))))","v":5}]
[]
[{"$f":"'Allestimento A'!A19","v":"-"},{"$f":"'Allestimento A'!B19:B20","v":"-"}]
[{"$f":"'Allestimento A'!A20","v":"-"}]
[{"$f":"'Allestimento A'!A21","v":"-"},{"$f":"'Allestimento A'!B21","v":"-"}]
[{"$f":"'Allestimento A'!A22","v":"-"},{"$f":"'Allestimento A'!B22","v":"-"},"Poi nascondi"]
[{"$f":"'Allestimento A'!A23","v":"-"},{"$f":"'Allestimento A'!B23","v":"-"},1]
[{"$f":"'Allestimento A'!A24","v":"-"},{"$f":"'Allestimento A'!B24","v":"-"}]
[{"$f":"'Allestimento A'!A25","v":"4150IA"},{"$f":"'Allestimento A'!B25","v":"Incontro Push & Go"}]
[{"$f":"'Allestimento A'!A26","v":"-"},{"$f":"'Allestimento A'!B26","v":"-"},4]
[{"$f":"'Allestimento A'!A27","v":"-"},{"$f":"'Allestimento A'!B27","v":"-"},{"$f":"IF(L10=\"-\",\"\",((C26*L10)/1000)&\" mt\")","v":""}]
[{"$f":"'Allestimento A'!A28","v":"-"},{"$f":"'Allestimento A'!B28","v":"-"}]
["Kit giunzione non applicabile su questo allestimento",{"$nulls":12},"<<Torna al menù"]

{"sheet":"Allestimento M","index":11,"n_rows":29,"n_cols":19,"rows_kept":29,"merged":[[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],[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":6},"Rif. Cliente",{"$f":"'Ergon Living Folding'!C12","v":0},null,"N° Ordine",{"$f":"'Ergon Living Folding'!C14","v":0},null,"Data ordine",{"$f":"'Ergon Living Folding'!C16","v":"00:00:00"}]
[{"$nulls":11},"HC",{"$f":"IF('Ergon Living Folding'!O19=\"\",\"\",'Ergon Living Folding'!O19)","v":""},"Massimo 3068 mm"]
[{"$nulls":5},"Minimo 3660 mm",null,"LFM","Massimo 6550 mm",null,null,"HFM",{"$f":"IF('Ergon Living Folding'!J19=0,'Ergon Living Folding'!O19+57.5,'Ergon Living Folding'!J19)","v":57.5},"Massimo 3125 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"}]
[]
[]
["ALLESTIMENTO \"M\" (1 ANTA SINGOLA + 5 ANTE PIEGHEVOLI - APERTURA DOPPIA)"]
[{"$f":"'Ergon Living Folding'!K7","v":0},null,null,"Anta Singola","5 Ante pieghevoli","Larghezza Passaggio","Larghezza di Passaggio Doppia","Quota Fissa\nLA e LA5","Quota Variabile LA","Quota Variabile LA5","Posizione piastra Push & Go","Altezza di passaggio","Altezza anta","Altezza montante in legno","\\"]
["Codice","Descrizione",null,"\"LA\"","\"LA5\"","\"LP\"","\"LPD\"","\"QF\"","\"QV1\"","\"QV5\"","\"PP\""]
[{"$f":"IF('Ergon Living Folding'!K7=\"\",\"-\",IF(A8=\"NERO\",\"700AM01\",\"710AM01\"))","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A11","v":"-"},{"$f":"'Allestimento A'!B11:B12","v":"-"},null,{"$f":"IF(B28=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO KIT GIUNZIONE\",\"-\",IF(D10<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(F11=\"NO KIT GIUNZIONE\",\"-\",IF(B28=\"Kit giunzione\",IF(E10<850,\"No Soft Opening\",\"-\"),\"-\"))))","v":"-"},{"$f":"IF(D10=\"-\",\"-\",IF(D15>0,\"-\",IF(D10<775,\"NO KIT GIUNZIONE\",\"-\")))","v":"-"}]
[{"$f":"'Allestimento A'!A12","v":"-"},null,null,{"$f":"IF(D10=\"-\",\"-\",IF((D10+E10)>1369.9,\"-\",\"SOFT OPENING SOLO DA UN LATO\"))","v":"-"}]
[{"$f":"'Allestimento A'!A13","v":"-"},{"$f":"'Allestimento A'!B13:B14","v":"-"},null,{"$f":"IF(E15<560,\"Diminuire dimensione LA\",IF(E15>1200,\"Aumentare dimensione LA\",\"\"))","v":"Aumentare dimensione LA"}]
[{"$f":"'Allestimento A'!A14","v":"-"},{"$nulls":3},{"$f":"IF(E15<560,\"min 560 mm\",IF(E15>1200,\"max 1200 mm\",\"\"))","v":"max 1200 mm"}]
[{"$f":"'Allestimento A'!A15","v":"-"},{"$f":"'Allestimento 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":"'Allestimento A'!A16","v":"-"}]
[{"$f":"'Allestimento A'!A17","v":"-"},{"$f":"'Allestimento A'!B17","v":"-"},{"$f":"IF(H4>6000,13,IF(H4>5500,12,IF(H4>5000,11,IF(H4>4500,10,IF(H4>4000,9,IF(H4>3500,8,IF(H4>3000,7,IF(H4>2500,6,IF(H4>2000,5,IF(H4<=1500,5,\"\"))))))))))","v":5},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO KIT GIUNZIONE\",\"-\",IF(D15<670,\"-\",IF(D15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(B28=\"-\",\"-\",IF(F17=\"NO KIT GIUNZIONE\",\"-\",IF(E15<700,\"-\",IF(E15<850,\"No Soft Opening\",\"-\"))))","v":"-"},{"$f":"IF(D15=\"\",\"-\",IF(D15<775,\"NO KIT GIUNZIONE\",IF(E15<745,\"NO KIT GIUNZIONE\",\"-\")))","v":"-"}]
[{"$nulls":3},{"$f":"IF(D15=\"\",\"-\",IF((D15+E15)>1369.9,\"-\",\"SOFT OPENING SOLO DA UN LATO\"))","v":"-"}]
[{"$f":"'Allestimento A'!A19","v":"-"},{"$f":"'Allestimento A'!B19:B20","v":"-"},null,"In alternativa scegliere la dimensione dell'anta singola"]
[{"$f":"'Allestimento A'!A20","v":"-"}]
[{"$f":"'Allestimento B'!A21","v":"-"},{"$f":"'Allestimento B'!B21","v":"-"}]
[{"$f":"'Allestimento A'!A22","v":"-"},{"$f":"'Allestimento A'!B22","v":"-"},{"$f":"IF(B22=\"Soft Opening S1\",1,\"-\")","v":"-"},{"$f":"IF('Ergon Living Folding'!C19=\"SI\",\"←Scegliere uno dei due\",\"\")","v":""}]
[{"$f":"'Allestimento A'!A23","v":"-"},{"$f":"'Allestimento A'!B23","v":"-"},{"$f":"IF(B23=\"Soft Opening PLUS\",1,\"-\")","v":"-"}]
[{"$f":"'Allestimento A'!A24","v":"-"},{"$f":"'Allestimento A'!B24","v":"-"}]
[{"$f":"'Allestimento A'!A25","v":"4150IA"},{"$f":"'Allestimento A'!B25","v":"Incontro Push & Go"}]
[{"$f":"'Allestimento A'!A26","v":"-"},{"$f":"'Allestimento A'!B26","v":"-"},4,4]
[{"$f":"'Allestimento A'!A27","v":"-"},{"$f":"'Allestimento A'!B27","v":"-"},{"$f":"IF(M10=\"-\",\"\",((C26*M10)/1000)&\" mt\")","v":""}]
[{"$f":"'Allestimento A'!A28","v":"-"},{"$f":"'Allestimento A'!B28","v":"-"}]
[{"$nulls":14},"<<Torna al menù"]