{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["tarif 2015","Fixation","Fiche devis"],"not_rendered":{"macros":1,"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"tarif 2015","index":0,"n_rows":14,"n_cols":17,"rows_kept":14}
[null,"produit","Parement","Finition","Ht Isolant","Ht Chevrons","R isolant","Uc","largeur","L max","isolant","isolant","chevron",null,"panneau interieur","panneau exterieur","prix  brut"]
[{"$nulls":6},"m²K/W","W/m²K","mm","mm","type","mm","mm",null,"mm","mm","€"]
[]
[]
[null,"ISOL 1","PLATRE","PLATRE",80,100,{"v":3.5,"d":"3.50"},0.26,800,6900,"PIR",80,24,98,12.5,null,{"v":10,"d":"€ 10.00"}]
[null,"ISOL 1","PLATRE","PLATRE ERP",90,120,{"v":4,"d":"4.00"},0.23,800,6900,"PIR",90,24,120,12.5,null,{"v":15,"d":"€ 15.00"}]
[null,"ISOL 1","LAMBRIS","LAMBRIS BLANC BROSSE",180,200,{"v":8,"d":"8.00"},0.12,800,8000,"PIR",180,24,200,"12+10",null,{"v":20,"d":"€ 20.00"}]
[null,"ISOL 1","LAMBRIS","LAMBRIS LARGE",80,100,{"v":3.5,"d":"3.50"},0.26,800,8000,"PIR",80,24,98,"12+13",null,{"v":20,"d":"€ 20.00"}]
[null,"ISOL 2","PLATRE","PLATRE",95,120,{"v":4.3,"d":"4.30"},0.22,800,6900,"PIR",97,24,120,12.5,3,{"v":10,"d":"€ 10.00"}]
[null,"ISOL 2","PLATRE","PLATRE",110,130,4.85,0.19,800,6900,"PIR",109,24,132,12.5,3,{"v":12,"d":"€ 12.00"}]
[null,"ISOL 2","PLATRE","PLATRE M0",95,120,{"v":4.3,"d":"4.30"},0.22,800,8000,"PIR",97,24,120,12.5,3,{"v":15,"d":"€ 15.00"}]
[null,"ISOL 2","PARTICULES","PARTICULES",95,120,{"v":4.3,"d":"4.30"},0.22,800,8000,"PIR",97,24,120,12,3,{"v":15,"d":"€ 15.00"}]
[null,"ISOL 2","PARTICULES","PARTICULES STRIE",95,120,{"v":4.3,"d":"4.30"},0.22,800,6650,"PIR",97,24,120,12,3,{"v":20,"d":"€ 20.00"}]
[null,"ISOL 2","PARTICULES","PARTICULES DECOR BLANC",95,120,{"v":4.3,"d":"4.30"},0.22,800,6650,"PIR",97,24,120,12,3,{"v":20,"d":"€ 20.00"}]

{"sheet":"Fixation","index":1,"n_rows":5,"n_cols":2,"rows_kept":5}
["ISOL 1","ISOL 2"]
["Vis","Vis"]
["Clous","crampons"]
["Rondelles"]
["crampons"]

{"sheet":"Fiche devis","index":2,"n_rows":28,"n_cols":14,"rows_kept":28,"merged":[[0,0,1,10],[2,1,2,5],[2,8,2,10],[3,1,3,5],[3,8,3,10],[4,1,4,5],[4,8,4,10],[5,1,5,5],[5,8,5,10],[6,1,6,5],[6,8,6,10],[7,1,7,5],[8,1,8,5],[8,7,9,10],[11,0,11,1],[11,2,11,3],[11,4,11,6],[12,0,12,1],[12,2,12,3],[12,4,12,6],[13,0,13,10],[14,1,14,2],[14,4,14,5],[14,7,14,8],[14,9,14,10],[15,1,15,2],[15,4,15,5],[15,7,15,8],[15,9,15,10],[17,0,17,2],[27,8,28,10],[29,8,31,10]]}
["PROPOSITION PRIX",{"$nulls":11},"noms de champ à créer dans Tarif"]
[{"$nulls":12},"finition","=DECALER($D$5;;;NBVAL($B$5:$B$2000))"]
["Date devis",{"$nulls":6},"Contact",{"$nulls":4},"HT","=DECALER($E$5;;;NBVAL($B$5:$B$2000))"]
["Négoce",{"$nulls":6},"Secteur",{"$nulls":4},"HTChevrons","=DECALER($F$5;;;NBVAL($B$5:$B$2000))"]
["Réf Client",{"$nulls":6},"Portable",{"$nulls":4},"Parement","=DECALER($C$5;;;NBVAL($B$5:$B$2000))"]
["Réf Dossier",{"$nulls":6},"Fax",{"$nulls":4},"produit","=DECALER($B$5;;;NBVAL($B$5:$B$2000))"]
["Téléphone",{"$nulls":6},"@",{"$nulls":4},"R_isolant","=DECALER($G$5;;;NBVAL($B$5:$B$2000))"]
["Fax"]
["Destinataire"]
[]
[]
["Produit",null,"Parement",null,"Finition",null,null,"Ht\nIsolant","Ht\nChevrons","R \nIsolant","Type \nFixation"]
["ISOL 1",null,"PLATRE",null,"PLATRE ERP",null,null,90,{"$f":"INDEX(HTChevrons,MATCH(1,(produit=$A$13)*(Parement=$C$13)*(finition=$E$13)*(HT=$H$13),0))","v":120},{"$f":"INDEX(R_isolant,MATCH(1,(produit=$A$13)*(Parement=$C$13)*(finition=$E$13)*(HT=$H$13),0))","v":4}]
[]
["Largeur","L Max",{"$nulls":5},"Prix Public",null,"Prix Net"]
[2,2,null,null," ",null,null,2,null,"Prix net - remise"]
[]
["Accessoires",null,null,"Quantité","Prix Public","Prix nets","Total ligne"]
{"$rows_empty":9}
[{"$nulls":8},"Total HT"]