{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Liste de débit","Devis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Liste de débit","index":0,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,18,1,18],[0,12,0,13],[0,14,1,14],[0,15,1,15],[0,16,1,16],[0,17,1,17],[0,6,1,6],[0,7,1,7],[0,8,1,9],[0,2,1,2],[0,11,1,11],[6,0,9,0],[2,0,3,0],[0,3,0,5],[0,0,1,0],[0,1,1,1],[25,0,39,0],[11,8,15,8],[11,7,15,7],[18,7,22,7],[18,8,22,8],[25,7,27,7],[25,8,27,8],[30,7,31,7],[30,8,31,8],[34,8,35,8],[34,7,35,7],[38,7,39,7],[38,8,39,8],[11,0,22,0],[6,9,9,9],[2,9,3,9],[11,9,22,9],[25,9,39,9],[2,8,3,8]]}
["Section brute","Désignation","Qt","Dimensions rabotées",null,null,"Long. +","Long.\nScierie","Qt ",null,null,"Désignation","section ",null,"Lg","Qt.","Vol.","P.U HT","Montant HT"]
[null,null,null,"larg.","Haut","Long.",null,null,null,null,null,null,"Hauteur","Largeur"]
["30 x 190","Bandeau droit",4,21,180,2.5230000000000001,{"$f":"F3+0.15","v":2.673},5.5,null,4,null,null,"  [mm]","[mm]","[m]","[u]","[m3]","[€/m3]","[€]"]
[null,"Bandeau gch",4,21,180,2.5230000000000001,{"$f":"F4+0.15","v":2.673},5.5,null,null,null,"Douglas",30,190,5.5,4,{"$f":"P4*O4*N4*M4/1000000","v":0.12540000000000001},580,{"$f":"R4*Q4","v":72.732000000000014}]
[null,"optimisation",4,null,null,null,5.4,null,null,null,null,"Douglas",60,170,5,4,0.20399999999999999,580,118.32]
[null,null,null,null,null,null,null,null,null,null,null,"Douglas",70,90,5.5,8,0.2772,580,160.77600000000001]
["60 x 170","Entrait 1/2 ferme",4,50,160,2.0569999999999999,{"$f":"F7+0.15","v":2.2069999999999999},5,{"$f":"Repart(G7,H7,C7)","v":2},4,null,"Douglas",100,190,5.5,14,1.4630000000000001,550,804.65000000000009]
[null,null,2,null,null,null,4.4000000000000004,null,null,null,null,"Douglas",170,170,3,1,8.6699999999999999E-2,550,47.685000000000002]
[null,null,null,null,null,null,null,null,null,null,null,"Douglas",210,210,3,4,0.5292,550,291.06]
[null,"Entrait",2,50,160,4.4000000000000004,{"$f":"F10+0.15","v":4.5500000000000007},5,{"$f":"Repart(G10,H7,C10)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,"Transport",null,null,null,1,null,null,100]
["70 x 90","Chevron droit",4,60,80,1.546,{"$f":"F12+0.1","v":1.6460000000000001},5.5,{"$f":"Repart(G12+G13+G14+G15+G16,H12,C12)","v":4},8]
[null,"Empan. brisis droit",4,60,80,0.60699999999999998,{"$f":"F13+0.1","v":0.70699999999999996},null,null,null,null,"Bois de charpente, brut de sciage, vive arête"]
[null,"Empan. court droit",4,60,80,0.47099999999999997,{"$f":"F14+0.1","v":0.57099999999999995}]
[null,"Empan. long droit",4,60,80,1.3959999999999999,{"$f":"F15+0.1","v":1.496},null,null,null,null,null,null,null,null,null,null,"Volume total [m3]",{"$f":"Q8+Q9+Q7+Q5+Q4+Q6","v":2.6855000000000002}]
[null,"Empan. moyen droit",4,60,80,0.93400000000000005,{"$f":"F16+0.1","v":1.034},null,null,null,null,null,null,null,null,null,null,"Total H.T.",{"$f":"S8+S9+S7+S5+S4+S6","v":1495.223}]
[null,null,4,null,null,null,{"$f":"G12+G13+G14+G15+G16","v":5.4539999999999997},null,null,null,null,null,null,null,null,null,null,"Total T.V.A.",{"$f":"S16*0.196","v":293.06370800000002}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net à payer",{"$f":"S16+S17","v":1788.2867080000001}]
[null,"Chevron gch",4,60,80,1.546,{"$f":"F19+0.1","v":1.6460000000000001},5.5,{"$f":"Repart(G19+G20+G21+G22+G23,H19,C19)","v":4}]
[null,"Empan. brisis gch",4,60,80,0.60699999999999998,{"$f":"F20+0.1","v":0.70699999999999996}]
[null,"Empan. court gch",4,60,80,0.47099999999999997,{"$f":"F21+0.1","v":0.57099999999999995}]
[null,"Empan. long gch",4,60,80,1.3959999999999999,{"$f":"F22+0.1","v":1.496}]
[null,"Empan. moyen gch",4,60,80,0.93400000000000005,{"$f":"F23+0.1","v":1.034}]
[null,null,4,null,null,null,{"$f":"G19+G20+G21+G22+G23","v":5.4539999999999997}]
[]
["100 x 190","Fourrure coyau",4,90,127,2.5760000000000001,{"$f":"F26+0.15","v":2.726},5.5,{"$f":"Repart(G26+G27+G28,H26,C26)","v":4},14]
[null,"1/2 panne haute",4,80,180,1.2549999999999999,{"$f":"F27+0.15","v":1.4049999999999998}]
[null,"Panne brisis",4,80,180,1.214,{"$f":"F28+0.15","v":1.3639999999999999}]
[null,null,4,null,null,null,{"$f":"G28+G27+G26","v":5.4949999999999992}]
[]
[null,"Panne porteuse",4,80,180,3.2589999999999999,{"$f":"F31+0.15","v":3.4089999999999998},5.5,{"$f":"Repart(G31+G32,H31,C31)","v":4}]
[null,"1/2 panne basse",4,80,180,1.9850000000000001,{"$f":"F32+0.15","v":2.1350000000000002}]
[null,null,4,null,null,null,{"$f":"G31+G32","v":5.5440000000000005}]
[]
[null,"Coyau",4,90,160,2.093,{"$f":"F35+0.15","v":2.2429999999999999},5.5,{"$f":"Repart(G35+G36,H35,C35)","v":4}]
[null,"Arbalétrier",4,90,180,2.7290000000000001,{"$f":"F36+0.15","v":2.879}]
[null,null,4,null,null,null,{"$f":"G35+G36","v":5.1219999999999999}]
[]
[null,"Fourrure arba",4,90,145,1.34,{"$f":"F39+0.15","v":1.49},5.5,{"$f":"Repart(G39+G40,H39,C39)","v":2}]
[null,"Contrefiche",4,70,120,0.79400000000000004,{"$f":"F40+0.15","v":0.94400000000000006}]
[null,null,4,null,null,null,{"$f":"G40+G39","v":2.4340000000000002}]
[]
["170 x 170","Poinçon",1,160,160,1.3420000000000001,{"$f":"F43+0.15","v":1.492},3,null,1]
[]
["210 x 210","Poteau",4,200,200,2.698,{"$f":"F45+0.15","v":2.8479999999999999},3,null,4]
[]
[null,"Semelle",2,50,160,0.4,{"$f":"F47+0.15","v":0.55000000000000004},3,null,1]

{"sheet":"Devis","index":1,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,5,1,5],[0,7,1,7],[0,1,0,2],[0,3,1,3],[0,4,1,4],[0,6,1,6]]}
["Désignation","section ",null,"Lg","Qt.","Vol.","P.U HT","Montant HT"]
[null,"Hauteur","Largeur"]
[null,"  [mm]","[mm]","[m]","[u]","[m3]","[€/m3]","[€]"]
["Douglas",30,190,5.5,4,{"$f":"E4*D4*C4*B4/1000000","v":0.12540000000000001},580,{"$f":"G4*F4","v":72.732000000000014}]
["Douglas",60,170,5,4,0.20399999999999999,580,118.32]
["Douglas",70,90,5.5,8,0.2772,580,160.77600000000001]
["Douglas",100,190,5.5,14,1.4630000000000001,550,804.65000000000009]
["Douglas",170,170,3,1,8.6699999999999999E-2,550,47.685000000000002]
["Douglas",210,210,3,4,0.5292,550,291.06]
[]
["Transport",null,null,null,1,null,null,100]
[]
["Bois de charpente, brut de sciage, vive arête"]
[]
[null,null,null,null,null,null,"Volume total [m3]",{"$f":"F8+F9+F7+F5+F4+F6","v":2.6855000000000002}]
[null,null,null,null,null,null,"Total H.T.",{"$f":"H8+H9+H7+H5+H4+H6","v":1495.223}]
[null,null,null,null,null,null,"Total T.V.A.",{"$f":"H16*0.196","v":293.06370800000002}]
[null,null,null,null,null,null,"Net à payer",{"$f":"H16+H17","v":1788.2867080000001}]