{"text_format":"1","workbook":"xlsx","n_sheets":28,"sheets":["Modules","Résumé","Buch","Rés Bûcheronnage","CableMob","Rés Câble-Grue Mobile","CableConv","Rés Câble Conventionnel","Helico","Rés Hélicoptère","Porteur","Rés Porteur","Recol","Rés Récolteuse","StockPl","Validation_lists","StockBrut","Chaud","Chaud_R","Rés Chaudière","Dech","Rés Déchiquetage","Rés StockageBrut","Rés StockagePl","Tract","Rés Tracteur","Trans","Rés Transport"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":15,"defined_names":376,"comments":11,"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":"Modules","index":0,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Etape","Module"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]

{"sheet":"Résumé","index":1,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Etape","Module","Volume","Unité","CHF/m3","CHF",null,null,null,null,"unité"]
[null,1,"Récolteuse (1)",100,"[m3 bois]",26.505974976942866,2650.5974976942866,null,null,"Volume final total",100,"[m3 bois]"]
[null,2,null,null,null,null,null,null,null,"Coût total pour ce volume",2650.5974976942866,"[CHF]"]
[null,3,null,null,null,null,null,null,null,"Coût au m3",26.505974976942866,"[CHF/m3 bois]"]
[null,4]
[null,5,null,null,null,null,null,null,null,"Si plaquette et module chaudière"]
[null,6,null,null,null,null,null,null,null,"Energie"]
[null,7,null,null,null,null,null,null,null,"Coût au kWh"]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[]
[null,null,null,null,null,"Total",{"$f":"SUM(G3:G14)","v":2650.5974976942866}]

{"sheet":"Buch","index":2,"n_rows":38,"n_cols":9,"rows_kept":38,"cut":false,"hidden":true,"merged":[[0,2,0,5],[31,2,31,5],[13,2,13,5],[16,2,16,5],[20,2,20,5],[27,2,27,5],[26,2,26,5],[29,2,29,5],[1,2,1,5],[23,2,23,5],[25,2,25,5],[24,2,24,5],[9,2,9,5],[4,2,4,5],[21,2,21,5],[22,2,22,5],[28,2,28,5],[36,2,36,5],[37,2,37,5],[30,2,30,5],[32,2,32,5],[33,2,33,5],[34,2,34,5],[35,2,35,5]]}
[null,"Paramètres du chantier"]
[null,"Peuplement"]
[null,"Essence","Feuillu","Epicéa","Pin/mélèze","Sapin"]
[null,"Volume de bois abattu par essence [m3 en écorce]",0,0,0,0]
[null,"Volume de bois abattu total [m3 en écorce]",{"$f":"SUM(C4:F4)","v":0}]
[null,"Volume moyen des troncs [m3 en écorce]",0.5,0.5,0.5,0.5]
[null,"Part abattue avec treuil manuel [%]",0,0,0,0]
[null,"Part écorcé à la main [%]",0,0,0,0]
[null,"Longueur de cime [%]"]
[null,"Assortiment"]
[null,"Part dédiée au bois de service [%]",100,100,100,100,null,"Remarque:","La somme des parts doit être égale à 100% pour chaque essence (chaque colonne)!"]
[null,"Longueur des grumes [m]"]
[null,"Parrer pied [oui/non]"]
[]
[null,"Part dédiée au bois industrie [%]",0,0,0,0]
[null,"Longueur des tiges [m]"]
[null,null,null,null,null,null,null,{"$f":"IF(C11+C15+C18<>100,\"ATTENTION: La somme des pourcentages de la colonne Feuillu n'est pas égale à cent!\", \"\")","v":""}]
[null,"Part dédiée au bois énergie [%]",0,0,0,0,null,{"$f":"IF(D11+D15+D18<>100,\"ATTENTION: La somme des pourcentages de la colonne Epicéa n'est pas égale à cent!\", \"\")","v":""}]
[null,"Longueur des tiges [m]",null,null,null,null,null,{"$f":"IF(E11+E15+E18<>100,\"ATTENTION: La somme des pourcentages de la colonne Pin/mélèze n'est pas égale à cent!\", \"\")","v":""}]
[null,"Part fendu [%]",0,0,0,0,null,{"$f":"IF(F11+F15+F18<>100,\"ATTENTION: La somme des pourcentages de la colonne Sapin n'est pas égale à cent!\", \"\")","v":""}]
[null,"Terrain"]
[null,"Pente [%]"]
[null,"Obstacles"]
[null,"Paramètres de travail"]
[null,"Tarifs"]
[null,"Personnel [CHF/h]",60]
[null,"Tronçonneuse [CHF/h]",15]
[null,"Ecorceuse manuelle [CHF/h]",0.5]
[null,"Temps de déplacement et de pause payé"]
[null,"Temps de travail journalier [min]",540]
[null,"dont déplacement et pause payé [min]",60]
[null,"Autres"]
[null,"Frais déplacement [CHF]",0]
[null,"Autres dépenses [CHF]",0]
[null,"Administration"]
[null,"Frais administratifs [% du coût total du chantier]",10]
[null,"Facteur de correction"]
[null,"Pourcentage - ou + sur coût total [%]",0]

{"sheet":"Rés Bûcheronnage","index":3,"n_rows":46,"n_cols":14,"rows_kept":46,"cut":false,"hidden":true,"merged":[[0,2,0,3],[0,0,1,0],[12,0,13,0],[0,1,1,1],[12,1,13,1],[12,2,12,3],[24,0,25,0],[24,1,25,1],[36,0,37,0],[36,2,36,3],[36,1,37,1],[24,2,24,3],[12,5,13,5],[0,5,1,5],[12,6,13,6],[0,12,0,13],[0,11,1,11],[12,7,12,8],[0,10,1,10],[0,7,0,8],[0,6,1,6]]}
["Feuillu","Temps [h]","Coûts [CHF]",null,null,"Feuillu","Temps [h]","Coûts [CHF]",null,null,"Total","Temps [h]","Coûts [CHF]"]
[null,null,"par m3 bois","Total",null,null,null,"par m3 bois","Total",null,null,null,"par m3 bois","Total"]
["Personnel",null,null,null,null,"Personnel",null,null,null,null,"Personnel"]
["Tronçonneuse",null,null,null,null,"Tronçonneuse",null,null,null,null,"Tronçonneuse"]
["Fer à écorcer",null,null,null,null,"Fer à écorcer",null,null,null,null,"Fer à écorcer"]
[]
["Déplacement",null,null,null,null,"Déplacement",null,null,null,null,"Déplacement"]
["Autres dépenses",null,null,null,null,"Autres dépenses",null,null,null,null,"Autres dépenses"]
["Frais Administratifs",null,null,null,null,"Frais Administratifs",null,null,null,null,"Frais Administratifs"]
["Total",null,null,null,null,"Total",null,null,null,null,"Total"]
[]
[]
["Epicéa","Temps [h]","Coûts [CHF]",null,null,"Résineux","Temps [h]","Coûts [CHF]"]
[null,null,"par m3 bois","Total",null,null,null,"par m3 bois","Total"]
["Personnel",null,null,null,null,"Personnel"]
["Tronçonneuse",null,null,null,null,"Tronçonneuse"]
["Fer à écorcer",null,null,null,null,"Fer à écorcer"]
[]
["Déplacement",null,null,null,null,"Déplacement"]
["Autres dépenses",null,null,null,null,"Autres dépenses"]
["Frais Administratifs",null,null,null,null,"Frais Administratifs"]
["Total",null,null,null,null,"Total"]
[]
[]
["Pin/mélèze","Temps [h]","Coûts [CHF]"]
[null,null,"par m3 bois","Total"]
["Personnel"]
["Tronçonneuse"]
["Fer à écorcer"]
[]
["Déplacement"]
["Autres dépenses"]
["Frais Administratifs"]
["Total"]
[]
[]
["Sapin","Temps [h]","Coûts [CHF]"]
[null,null,"par m3 bois","Total"]
["Personnel"]
["Tronçonneuse"]
["Fer à écorcer"]
[]
["Déplacement"]
["Autres dépenses"]
["Frais Administratifs"]
["Total"]

{"sheet":"CableMob","index":4,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":true,"merged":[[36,2,36,5],[34,1,34,2]]}
[null,"Paramètres du chantier"]
[null,"Peuplement"]
[null,"Volume de bois débardé [m3]",0,"Pourcentage Feuillu [%]"]
[null,"Volume moyen des tiges débardées [m3]",0.5]
[null,"Ligne de câble"]
[null,"Piquetage de ligne sans projet [oui/non]"]
[null,"Longueur de la ligne [m]"]
[null,"Distance moyenne de débardage [m]"]
[null,"Distance latérale moyenne à la ligne [m]"]
[null,"Difficulté de tirage jusqu'à la ligne"]
[null,"Système de câblage"]
[null,"Emplacement de la grue"]
[null,"Nombre de mâts",null,"Hauteur pour chaque mât [m]"]
[null,"Mât terminal",null,"Hauteur [m]"]
[]
[null,"Paramètres de travail"]
[null,"Tarifs"]
[null,"Personnel Planification [CHF/h]",72]
[null,"Personnel Installation [CHF/h]",72]
[null,"Personnel Câblage [CHF/h]",72]
[null,"Personnel Place à bois [CHF/h]",72]
[null,"Câble-grue mobile [CHF/h]",140]
[null,"Grue [CHF/h]",110,"Temps de fct (% du temps de câblage)",75]
[null,"Nombre de personnes"]
[null,"Planification",2]
[null,"Installation",3]
[null,"Câblage",3]
[null,"Place à bois",1,"Temps investi (% du temps de câblage)",100]
[null,"Temps de déplacement et de pause payé"]
[null,"Temps de travail journalier [min]",540]
[null,"dont déplacement et pause payé [min]",60]
[null,"Autres"]
[null,"Déplacement de la grue [CHF]",0]
[null,"Autres dépenses [CHF]",0]
[null,"Administration"]
[null,"Frais administratifs [% du coût total du chantier]",10]
[null,"Facteur de correction"]
[null,"Pourcentage - ou + sur coût total [%]",0]

{"sheet":"Rés Câble-Grue Mobile","index":5,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":true,"merged":[[1,8,1,9],[1,1,2,1],[1,3,1,4],[1,2,2,2],[1,7,2,7],[13,1,14,1],[13,2,14,2],[13,3,13,4],[1,6,2,6]]}
[]
[null,"Feuillu","Temps [h]","Coûts [CHF]",null,null,"Total","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3","Total",null,null,null,"par m3","Total"]
[null,"Personnel",null,null,null,null,"Personnel"]
[null,"Câble-grue mobile",null,null,null,null,"Câble-grue mobile"]
[null,"Véhicule de grue",null,null,null,null,"Véhicule de grue"]
[]
[null,"Déplacement véhicule de grue",null,null,null,null,"Déplacement véhicule de grue"]
[null,"Autres dépenses",null,null,null,null,"Autres dépenses"]
[null,"Frais Administratifs",null,null,null,null,"Frais Administratifs"]
[null,"Total",null,null,null,null,"Total"]
[]
[]
[null,"Résineux","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3","Total"]
[null,"Personnel"]
[null,"Câble-grue mobile"]
[null,"Véhicule de grue"]
[]
[null,"Déplacement véhicule de grue"]
[null,"Autres dépenses"]
[null,"Frais Administratifs"]
[null,"Total"]

{"sheet":"CableConv","index":6,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":true,"merged":[[53,2,53,5],[51,1,51,2]]}
[null,"Paramètres du chantier"]
[null,"Peuplement"]
[null,"Volume de bois débardé [m3]",0,"Pourcentage Feuillu [%]"]
[null,"Volume moyen des tiges débardées [m3]",0.5]
[null,"Longueur des tiges [m]",0]
[null,"Type d'intervention"]
[null,"Tiges câblées depuis:"]
[null,"Terrain"]
[null,"Pente [%]"]
[null,"Obstacles"]
[null,"Ligne de câble"]
[null,"Piquetage de ligne sans projet"]
[null,"Longueur de la ligne [m]",0]
[null,"Direction débardage"]
[null,"Distance moyenne de débardage [m]",0]
[null,"Distance latérale moyenne à la ligne [m]",0]
[null,"Nombre de mâts",0]
[null,"Nombre de mâts terminaux",0]
[null,"Hauteur moyenne du câble dans le peuplement [m]",0]
[null,"Hauteur de câble à l'arrivée [m]",0]
[null,"Montage"]
[null,"Réutilisation du câble dans le même chantier"]
[null,"Type de transport du treuil",null,"si non"]
[null,"Distance de transport du treuil [m]",null,"si non"]
[null,"Emplacement du treuil",null,"si oui"]
[null,"Démontage"]
[null,"Réutilisation du câble dans le même chantier"]
[null,"Type de transport du treuil",null,"si non"]
[null,"Distance de transport du treuil [m]",null,"si non"]
[null,"Emplacement du treuil",null,"si oui"]
[]
[null,"Paramètres de travail"]
[null,"Tarifs"]
[null,"Personnel planification [CHF/h]",72]
[null,"Personnel montage [CHF/h]",72]
[null,"Personnel câblage [CHF/h]",72]
[null,"Personnel démontage [CHF/h]",72]
[null,"Personnel place à bois [CHF/h]",72]
[null,"Câble et treuil [CHF/h]",70]
[null,"Grue [CHF/h]",80,"Temps de fct (% du temps de câblage)",80]
[null,"Nombre de personnes"]
[null,"Montage",3]
[null,"Câblage",3]
[null,"Démontage",3]
[null,"Place à bois",1,"Temps investi (% du temps de câblage)",100]
[null,"Temps de déplacement et de pause payé"]
[null,"Temps de travail journalier [min]",540]
[null,"dont déplacement et pause payé [min]",60]
[null,"Autres"]
[null,"Déplacement de la grue [CHF]",0]
[null,"Autres dépenses [CHF]",0]
[null,"Administration"]
[null,"Frais administratifs [% du coût total du chantier]",10]
[null,"Facteur de correction"]
[null,"Pourcentage - ou + sur coût total [%]",0]

{"sheet":"Rés Câble Conventionnel","index":7,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":true,"merged":[[0,7,0,8],[0,0,1,0],[0,2,0,3],[0,1,1,1],[0,6,1,6],[12,0,13,0],[12,1,13,1],[12,2,12,3],[0,5,1,5]]}
["Feuillu","Temps [h]","Coûts [CHF]",null,null,"Total","Temps [h]","Coûts [CHF]"]
[null,null,"par m3 bois","Total",null,null,null,"par m3 bois","Total"]
["Personnel",null,null,null,null,"Personnel"]
["Câble conventionnel",null,null,null,null,"Câble conventionnel"]
["Véhicule de grue",null,null,null,null,"Véhicule de grue"]
[]
["Déplacement véhicule de grue",null,null,null,null,"Déplacement véhicule de grue"]
["Autres dépenses",null,null,null,null,"Autres dépenses"]
["Frais Administratifs",null,null,null,null,"Frais Administratifs"]
["Total",null,null,null,null,"Total"]
[]
[]
["Résineux","Temps [h]","Coûts [CHF]"]
[null,null,"par m3 bois","Total"]
["Personnel"]
["Câble conventionnel"]
["Véhicule de grue"]
[]
["Déplacement véhicule de grue"]
["Autres dépenses"]
["Frais Administratifs"]
["Total"]

{"sheet":"Helico","index":8,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":true,"merged":[[15,2,15,5],[14,2,14,5],[12,2,12,5],[5,2,5,5],[11,2,11,5],[6,2,6,5],[10,2,10,5],[0,2,0,5],[4,2,4,5],[9,2,9,5],[1,2,1,5],[7,2,7,5],[8,2,8,5],[30,2,30,5],[13,2,13,5],[28,2,28,5],[21,2,21,5],[19,2,19,5],[23,2,23,5],[18,2,18,5],[17,2,17,5],[29,2,29,5],[16,2,16,5],[27,2,27,5],[24,2,24,5],[22,2,22,5],[20,2,20,5],[25,2,25,5],[26,1,26,5]]}
[null,"Paramètres du chantier"]
[null,"Peuplement"]
[null,"Essence","Feuillu","Epicéa","Pin/mélèze","Sapin"]
[null,"Volume de bois par essence [m3]",0,0,0,0]
[null,"Volume de bois total [m3]",{"$f":"SUM(C4:F4)","v":0}]
[null,"Type d'assortiment lors de l'héliportage"]
[null,"Temps entre abattage et l'héliportage [sem]"]
[null,"Distance d'héliportage horizontale [m]",0]
[null,"Distance d'héliportage verticale [m]",0]
[null,"Paramètres de travail"]
[null,"Entreprise de l'hélicoptère"]
[null,"Coût de l'hélicoptère [CHF/Min]",60]
[null,"Coûts fixe par chantier (transport, préparation, etc.) [CHF]",500]
[null,"Classe de l'hélicoptère"]
[null,"Volume de charge [m3]"]
[null,"Exploitation forestière"]
[null,"Personnel au sol lors de l'héliportage (nombre)",2]
[null,"Coût Personnel [CHF/h]",60]
[null,"Coût Tronçonneuse [CHF/h]",15]
[null,"Coût Grue [CHF/h]",110]
[null,"Temps de déplacement et de pause payé"]
[null,"Temps de travail journalier [min]",540]
[null,"dont déplacement et pause payés [min]",60]
[null,"Autres"]
[null,"Frais déplacement grue [CHF]",0]
[null,"Autres dépenses [CHF]",0]
[null,"Administration"]
[null,"Frais administratifs [% du coût total du chantier]",10]
[null,"Inclure dans le calcul le travail à la place de dépôt"]
[null,"Facteur de correction"]
[null,"Pourcentage - ou + sur coût total [%]",0]

{"sheet":"Rés Hélicoptère","index":9,"n_rows":48,"n_cols":15,"rows_kept":48,"cut":false,"hidden":true,"merged":[[13,3,13,4],[25,3,25,4],[37,2,38,2],[13,2,14,2],[25,2,26,2],[1,2,2,2],[25,1,26,1],[37,1,38,1],[1,6,2,6],[37,3,37,4],[1,1,2,1],[1,3,1,4],[13,1,14,1],[1,13,1,14],[13,6,14,6],[13,7,14,7],[13,8,13,9],[1,11,2,11],[1,7,2,7],[1,12,2,12],[1,8,1,9]]}
[]
[null,"Feuillu","Temps [h]","Coûts [CHF]",null,null,"Feuillu","Temps [h]","Coûts [CHF]",null,null,"Total","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3","Total",null,null,null,"par m3","Total",null,null,null,"par m3","Total"]
[null,"Hélicoptère",null,null,null,null,"Hélicoptère",null,null,null,null,"Hélicoptère"]
[null,"Personnel",null,null,null,null,"Personnel",null,null,null,null,"Personnel"]
[null,"Tronçonneuse",null,null,null,null,"Tronçonneuse",null,null,null,null,"Tronçonneuse"]
[null,"Véhicule grue",null,null,null,null,"Véhicule grue",null,null,null,null,"Véhicule grue"]
[]
[null,"Dépl. véhicule grue",null,null,null,null,"Dépl. véhicule grue",null,null,null,null,"Dépl. véhicule grue"]
[null,"Autres dépenses",null,null,null,null,"Autres dépenses",null,null,null,null,"Autres dépenses"]
[null,"Frais Administratifs",null,null,null,null,"Frais Administratifs",null,null,null,null,"Frais Administratifs"]
[null,"Total",null,null,null,null,"Total",null,null,null,null,"Total"]
[]
[null,"Epicéa","Temps [h]","Coûts [CHF]",null,null,"Résineux","Temps [h]","Coûts [CHF]",null,null,"Nombre de rotation"]
[null,null,null,"par m3","Total",null,null,null,"par m3","Total",null,"Coût par rotation"]
[null,"Hélicoptère",null,null,null,null,"Hélicoptère"]
[null,"Personnel",null,null,null,null,"Personnel"]
[null,"Tronçonneuse",null,null,null,null,"Tronçonneuse"]
[null,"Véhicule grue",null,null,null,null,"Véhicule grue"]
[]
[null,"Dépl. véhicule grue",null,null,null,null,"Dépl. véhicule grue"]
[null,"Autres dépenses",null,null,null,null,"Autres dépenses"]
[null,"Frais Administratifs",null,null,null,null,"Frais Administratifs"]
[null,"Total",null,null,null,null,"Total"]
[]
[null,"Sapin","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3","Total"]
[null,"Hélicoptère"]
[null,"Personnel"]
[null,"Tronçonneuse"]
[null,"Véhicule grue"]
[]
[null,"Dépl. véhicule grue"]
[null,"Autres dépenses"]
[null,"Frais Administratifs"]
[null,"Total"]
[]
[null,"Pin/mélèze","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3","Total"]
[null,"Hélicoptère"]
[null,"Personnel"]
[null,"Tronçonneuse"]
[null,"Véhicule grue"]
[]
[null,"Dépl. véhicule grue"]
[null,"Autres dépenses"]
[null,"Frais Administratifs"]
[null,"Total"]

{"sheet":"Porteur","index":10,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":true,"merged":[[46,2,46,5],[44,1,44,2]]}
[null,"Paramètres du chantier"]
[null,"Peuplement"]
[null,"Pourcentage de feuillu [%]"]
[null,"Volume de bois débardé [m3]",0]
[null,"DHP moyen [m]",0.3]
[null,"Longueur moyenne des tiges [m]"]
[null,"Nombre moyen d'assortiment par rotation",1.5]
[null,"Nombre d'assortiments"]
[null,"Pourcentage tordu [%]"]
[null,"Paramètre débardage layons/desserte"]
[null,"Disance moyenne: lieu de chargement - dépôt"]
[null,"Sur layons de débardage (jusqu'à la desserte) [m]"]
[null,"Pourcentage en montée [%]"]
[null,"Pourcentage en descente [%]"]
[null,"Pourcentage à plat [%]"]
[]
[null,"Sur desserte (jusqu'à zone dépôt de bois) [m]"]
[null,"Pourcentage en montée [%]"]
[null,"Pourcentage en descente [%]"]
[null,"Pourcentage à plat [%]"]
[null,"Détail débardage"]
[null,"Bois sur un côté\nLongueur sur laquelle se trouve le bois"]
[null,"Layons de débardage [m]"]
[null,"Desserte [m]"]
[null,"Bois sur les 2 côtés\nLongueur sur laquelle se trouve le bois"]
[null,"Layons de débardage [m]"]
[null,"Desserte [m]"]
[null,"Layons de débardage"]
[null,"Obstacles"]
[null,"Pente moyenne des layons de débardage [%]"]
[]
[null,"Paramètres de travail"]
[null,"Tarifs"]
[null,"Machiniste [CHF/h]",60]
[null,"Porteur [CHF/h]",110]
[null,"Porteur"]
[null,"Type"]
[null,"Surface de chargement transversale [m2]"]
[null,"Temps de déplacement et de pause payé"]
[null,"Temps de travail journalier [min]",540]
[null,"dont déplacement et pause payé [min]",60]
[null,"Autres"]
[null,"Déplacement du porteur [CHF]",0]
[null,"Autres dépenses [CHF]",0]
[null,"Administration"]
[null,"Frais administratifs [% du coût total du chantier]",10]
[null,"Facteur de correction"]
[null,"Pourcentage - ou + sur coût total [%]",0]

{"sheet":"Rés Porteur","index":11,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,8,1,9],[1,1,2,1],[1,3,1,4],[1,2,2,2],[1,7,2,7],[11,1,12,1],[11,2,12,2],[11,3,11,4],[1,6,2,6]]}
[]
[null,"Feuillu","Temps [h]","Coûts [CHF]",null,null,"Total","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3","Total",null,null,null,"par m3","Total"]
[null,"Personnel",null,null,null,null,"Personnel"]
[null,"Porteur",null,null,null,null,"Porteur"]
[]
[null,"Déplacement Porteur",null,null,null,null,"Déplacement Porteur"]
[null,"Autres dépenses",null,null,null,null,"Autres dépenses"]
[null,"Frais Administratifs",null,null,null,null,"Frais Administratifs"]
[null,"Total",null,null,null,null,"Total"]
[]
[null,"Résineux","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3","Total"]
[null,"Personnel"]
[null,"Porteur"]
[]
[null,"Déplacement Porteur"]
[null,"Autres dépenses"]
[null,"Frais Administratifs"]
[null,"Total"]

{"sheet":"Recol","index":12,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":true,"merged":[[21,2,21,5],[22,2,22,3],[17,2,17,3],[20,2,20,3],[18,2,18,3],[19,1,19,3],[4,2,4,3],[16,2,16,3],[8,2,8,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[12,2,12,3],[9,2,9,3],[10,2,10,3],[11,2,11,3]]}
[null,"Paramètres du chantier"]
[null,"Peuplement"]
[null,"Essence","Epicéa/Sapin","Pin/mélèze"]
[null,"Volume de bois  [m3]",0,0]
[null,"Volume Total [m3]",{"$f":"SUM(C4:D4)","v":0}]
[null,"Volume moyen des tiges [m3]",0.5,0.5]
[]
[null,"Paramètres de travail"]
[null,"Tarifs"]
[null,"Machiniste [CHF/h]",60]
[null,"Récolteuse [CHF/h]",370]
[null,"Récolteuse"]
[null,"Type de récolteuse"]
[null,"Temps de déplacement et de pause payé"]
[null,"Temps de travail journalier [min]",540]
[null,"dont déplacement et pause payé [min]",60]
[null,"Autres"]
[null,"Déplacement de la récolteuse [CHF]",0]
[null,"Autres dépenses [CHF]",0]
[null,"Administration"]
[null,"Frais administratifs [% du coût total du chantier]",10]
[null,"Facteur de correction"]
[null,"Pourcentage - ou + sur coût total [%]",0]

{"sheet":"Rés Récolteuse","index":13,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,7,2,7],[1,8,1,9],[11,1,12,1],[11,2,12,2],[11,3,11,4],[1,1,2,1],[1,3,1,4],[1,2,2,2],[1,6,2,6]]}
[]
[null,"Epicéa","Temps [h]","Coûts [CHF]",null,null,"Total","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3","Total",null,null,null,"par m3","Total"]
[null,"Personnel",null,null,null,null,"Personnel"]
[null,"Récolteuse",null,null,null,null,"Récolteuse"]
[]
[null,"Déplacement Récolteuse",null,null,null,null,"Déplacement Récolteuse"]
[null,"Autres dépenses",null,null,null,null,"Autres dépenses"]
[null,"Frais Administratifs",null,null,null,null,"Frais Administratifs"]
[null,"Total",null,null,null,null,"Total"]
[]
[null,"Pin/Mélèze","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3","Total"]
[null,"Personnel"]
[null,"Récolteuse"]
[]
[null,"Déplacement Récolteuse"]
[null,"Autres dépenses"]
[null,"Frais Administratifs"]
[null,"Total"]

{"sheet":"StockPl","index":14,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[[10,2,10,4],[1,2,1,4],[8,2,8,4],[7,2,7,4],[9,2,9,4],[4,2,4,4]]}
[null,"Stockage Plaquettes"]
[null,"Paramètres chantier"]
[null,"Plaquettes issues de:","Grume","Branche","Cime"]
[null,"Volume stocké [m3 pl]",0,0,0]
[null,"Volume total stocké [m3 pl]",{"$f":"SUM(C4:E4)","v":0}]
[null,"Pourcentage feuillu [%]"]
[null,"Teneur en eau à la sortie [%]"]
[]
[null,"Paramètres de l'entrepôt"]
[null,"Volume de stockage de l'entrepôt [m3]"]
[null,"Volume de transit annuel [m3 pl]"]

{"sheet":"Validation_lists","index":15,"n_rows":115,"n_cols":9,"rows_kept":115,"cut":false,"hidden":true,"merged":[]}
["Parcours"]
["ParcModule"]
[]
["Bûcheronnage"]
["Débardage (Câble-Grue Mobile)"]
["Débardage (Câble Conventionnel)"]
["Débardage (Hélicoptère)"]
["Débardage (Tracteur)"]
["Débardage (Porteur)"]
["Débardage (Récolteuse)"]
["Transport"]
["Déchiquetage"]
["Stockage (Plaquette)"]
["Stockage (Brut: Grume/Branche/Cime)"]
["Chaudière (Calcul cts/kWh)"]
[]
[]
[]
[]
[]
["Bûcheronnage"]
["BuchCime","BuchSer","BuchOuiNon","BuchInd","BuchEne","BuchPente","BuchObs"]
["< 33%","< 4m","oui","< 7m","1m","0 - 30%","aucun"]
["33% - 50%","4 - 6m","non","> 7m","2m","31 - 50%","faible"]
["51% - 66%","6 - 10m",null,null,null,"51 - 70%","modéré"]
["67% - 90%","> 10m",null,null,null,"> 70%","difficile"]
["> 90%"]
[]
[]
["Câble-grue mobile"]
["MobOuiNon","MobDiff","MobCable","MobDir"]
["oui","facile","1 câble de traction","aval"]
["non","difficile","2 ou + câbles de traction","amont"]
[]
[]
[]
["Câble conventionnel"]
["ConvInterv","ConvTirage","ConvObs","ConvTrans","ConvLieu","ConvOuiNon","ConvDir"]
["Eclaircie","Zone de coupe","Normal","Aucun transport par air","Reste","oui","amont"]
["Mise en lumière","Tas","Difficile","Par lui-même en amont","Change","non","aval"]
["Coupe définitive",null,"Extrême","Par lui-même en aval"]
[null,null,null,"Avec hélicoptère"]
[]
["Hélicoptère"]
["HelAss","HelSech","HelTyp","HelOuiNon"]
["Arbre entier","< 8 semaines","Léger","oui"]
["Par assortiment","> 8 semaines","Moyen","non"]
[null,null,"Lourd"]
[]
["Porteur"]
["PorAss","PorInc","PorTyp","PorOuiNon","PorObs"]
[1,"< 10%","petit","oui","Aucun"]
[2,"10 - 20%","moyen","non","Peu nombreux"]
[3,"> 20%",null,null,"Nombreux"]
[4,null,null,null,"Très nombreux"]
[]
[]
["Transport + chargement/déchargement"]
["TransOuiNon","TransType"]
["oui","Billons"]
["non","Plaquettes"]
[null,"Branches/cimes en vrac"]
[]
[]
["Déchiquetage"]
["DechLieu"]
["sur chantier (route forestière)"]
["sur grande place de dépôt"]
[]
[]
[]
["StockagePl"]
["StockPlVol"]
[500]
[1000]
[2000]
[4000]
[8000]
[]
[]
["Récolteuse"]
["RecTyp"]
["Machine Standard - moyenne",null,null,null,"Standardwert - mittel"]
["ÖSA SuperEVA - FMG 746"]
["Silvatec 854 TH - Silvatec 235"]
["Timberjack 870 - Timberjack 743"]
["Timberjack 870B - TJ 743C"]
["Valmet 901/4 - Valmet 948"]
["Valmet 901/6 - Valmet 942"]
[]
["Machine Standard - grosse",null,null,null,"Standardwert - gross"]
["FMG 990 Lokomo - FMG 746"]
["Hemek 880 - Woodking 550"]
["Herma 2010 - SP 550"]
["Ponsse Ergo HS 16 - Ponsse H60"]
["Silvatec 866 TH - Silvatec 445 MD 50"]
["Skogsjan 687 XL - Skogsjan 601 XL"]
["Timberjack 1270 - FMG"]
["Timberjack 1270B - TJ 755"]
["Valmet 911 - PAN 728"]
[]
[]
["Tracteur"]
["TraRang","TraAss","TraDes","TraLay","TraOuiNon","TraDiff","TraAide","TraTyp","TraDeb"]
["moins de 1/4 des tiges mal orientées","< 4","< 200m","< 20m","oui","très facile","Inconnu","Tracteur forestier de débardage (sans grue)","zone de coupe --> layon"]
["plus de 1/4 des tiges mal orientées","4 - 6","200 - 400m","20 - 30m","non","facile","1 - 25%","Tracteur forestier avec grue","layon --> place à bois"]
[null,"> 6","> 400m","30 - 40m",null,"moyenne","26 - 50%","Autre","zone de coupe --> place à bois"]
[null,null,null,"> 40m",null,"difficile","51 - 75%"]
[null,null,null,null,null,"très difficile","76 - 100%"]
[]
[]
["Stockage Brut"]
["StockBrLieu"]
["Stockage intermédiare"]
["Stockage dépôt"]

{"sheet":"StockBrut","index":16,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":true,"merged":[[1,2,1,4],[8,2,8,4],[2,2,2,4],[5,3,5,4]]}
[null,"Stockage Matière Brut"]
[null,"Paramètres chantier"]
[null,"Lieu de stockage"]
[null,"Matière stockée","Grume (billon)","Branche","Cime"]
[null,"Volume stocké [m3]",0,0,0]
[null,"Volume total stocké [m3]",{"$f":"C5","v":0},{"$f":"SUM(D5:E5)","v":0}]
[null,"Pourcentage feuillu [%]"]
[null,"Teneur en eau à la sortie [%]"]

{"sheet":"Chaud","index":17,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":true,"merged":[[4,2,4,7],[5,2,5,3],[5,4,5,5],[5,6,5,7]]}
[null,"Chaudière"]
[]
[null,"Rendement Chaudière [%] PCli",80]
[]
[null,"Plaquettes"]
[null,"Type de matière dont proviennent les plaquettes","Grume",null,"Branche",null,"Cime"]
[null,"Essence","Feuillu","Résineux","Feuillu","Résineux","Feuillu","Résineux"]
[null,"Volume [m3 pl]",0,0,0,0,0,0]
[null,"Teneur en eau [%]"]
[null,"Coût au m3 [CHF/m3 pl]"]

{"sheet":"Chaud_R","index":18,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[[4,2,4,7],[5,2,5,3],[5,4,5,5],[5,6,5,7]]}
[null,"Chaudière"]
[]
[null,"Rendement Chaudière [%] PCli",80]

{"sheet":"Rés Chaudière","index":19,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[null,"Chaudière"]
[null,"Volume [m3 pl]"]
[null,"Coût moyen [CHF/m3 pl]"]
[null,"Quantité d'énergie fournie [kWh]"]
[null,"Coût moyen [cts/kWh]"]

{"sheet":"Dech","index":20,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[[10,2,10,4],[2,2,2,4],[1,2,1,4],[5,3,5,4],[9,2,9,4]]}
[null,"Déchiquetage"]
[null,"Paramètres du chantier"]
[null,"Lieu de déchiquetage"]
[null,"Type de matière dont est issu le bois","Grume","Branche","cime"]
[null,"Volume de matière déchiquetée [m3]",0,0,0]
[null,"Volume total déchiqueté [m3]",{"$f":"C5","v":0},{"$f":"SUM(D5:E5)","v":0}]
[null,"Pourcentage feuillu [%]"]
[null,"Teneur en eau [%]"]
[]
[null,"Paramètres de travail"]
[null,"Coût déplacement de la déchiqueteuse [CHF]"]

{"sheet":"Rés Déchiquetage","index":21,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[null,"Déchiquetage"]
[null,null,"[m3 pl]"]
[null,"Volumes"]
[]
[null,null,"[CHF/m3 pl]","Total [CHF]"]
[null,"Coût total déchiquetage"]

{"sheet":"Rés StockageBrut","index":22,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[null,"Stockage Plaquette"]
[null,null,"[m3 bois]","[m3 en tas]","[m3 en tas]"]
[null,null,"Grume","Branche","Cime"]
[null,"Volumes"]
[]
[null,null,"[CHF/m3 bois]","[CHF/m3 en tas]","[CHF/m3 en tas]"]
[null,null,"Grume","Branche","Cime"]
[null,"Coût de stockage"]
[null,"Total [CHF]"]

{"sheet":"Rés StockagePl","index":23,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[null,"Stockage Plaquette"]
[null,null,"[m3 pl]"]
[null,"Volumes"]
[]
[null,null,"[CHF/m3 pl]","Total [CHF]"]
[null,"Coût de stockage"]

{"sheet":"Tract","index":24,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":true,"merged":[[28,2,28,5],[26,1,26,2]]}
[null,"Paramètres du chantier"]
[null,"Peuplement"]
[null,"Volume de bois débardé [m3]",0,"Pourcentage Feuillu [%]"]
[null,"Volume moyen des tiges débardées [m3]",0.5]
[null,"Nombre d'assortiments"]
[null,"Transport"]
[null,"Direction d'abattage des tiges de plus de 10m"]
[null,"Distance moyenne \"tige abattue - chargement\" [m]"]
[null,"Distance moyenne \"chargement - place à bois\" [m]"]
[null,"Trajet de débardage"]
[null,"Débardage en sève"]
[null,"Difficulté"]
[]
[null,"Paramètres de travail"]
[null,"Tarifs"]
[null,"Machiniste [CHF/h]",60]
[null,"Aide au débardage"]
[null,"Personnel Aide au débardage [CHF/h]",50,"Pourcentage d'engagement [%]"]
[null,"Tracteur [CHF/h]",90]
[null,"Type de tracteur"]
[null,"Temps de déplacement et de pause payé"]
[null,"Temps de travail journalier [min]",540]
[null,"dont déplacement et pause payé [min]",60]
[null,"Autres"]
[null,"Déplacement du tracteur [CHF]",0]
[null,"Autres dépenses [CHF]",0]
[null,"Administration"]
[null,"Frais administratifs [% du coût total du chantier]",10]
[null,"Facteur de correction"]
[null,"Pourcentage - ou + sur coût total [%]",0]

{"sheet":"Rés Tracteur","index":25,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":true,"merged":[[1,8,1,9],[1,1,2,1],[1,3,1,4],[1,2,2,2],[1,7,2,7],[11,1,12,1],[11,2,12,2],[11,3,11,4],[1,6,2,6]]}
[]
[null,"Feuillu","Temps [h]","Coûts [CHF]",null,null,"Total","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3 bois","Total",null,null,null,"par m3 bois","Total"]
[null,"Personnel",null,null,null,null,"Personnel"]
[null,"Tracteur",null,null,null,null,"Tracteur"]
[]
[null,"Déplacement tracteur",null,null,null,null,"Déplacement tracteur"]
[null,"Autres dépenses",null,null,null,null,"Autres dépenses"]
[null,"Frais Administratifs",null,null,null,null,"Frais Administratifs"]
[null,"Total",null,null,null,null,"Total"]
[]
[null,"Résineux","Temps [h]","Coûts [CHF]"]
[null,null,null,"par m3 bois","Total"]
[null,"Personnel"]
[null,"Tracteur"]
[]
[null,"Déplacement tracteur"]
[null,"Autres dépenses"]
[null,"Frais Administratifs"]
[null,"Total"]

{"sheet":"Trans","index":26,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":true,"merged":[[1,2,1,4],[8,2,8,4],[9,2,9,4],[2,2,2,4],[5,2,5,4],[7,2,7,4],[25,2,25,4],[12,2,12,4],[13,2,13,4],[18,2,18,4],[20,2,20,4],[19,2,19,4],[22,2,22,4],[24,2,24,4],[21,2,21,4],[23,2,23,4],[10,2,10,4],[14,2,14,4],[16,2,16,4],[17,2,17,4],[11,2,11,4],[15,2,15,4],[31,2,31,4],[29,2,29,4],[30,2,30,4],[26,2,26,4],[28,2,28,4],[27,2,27,4]]}
[null,"Transport + chargement/déchargement"]
[null,"Paramètres du chantier"]
[null,"Type de matière transportée"]
[null,"Matière transportée issue de:","Grume","Branche","Cime"]
[null,"Volume transporté [m3]"]
[null,"Volume Total [m3]",{"$f":"SUM(C5:E5)","v":0}]
[null,"Pourcentage de feuillu [% Volume]"]
[null,"Teneur en eau du bois [%]"]
[]
[null,"Paramètres techniques"]
[null,"Volume max de chargement [m3]"]
[null,"Masse max autorisée du véhicule (véhicule + charge) [kg]"]
[null,"Masse max de la charge [kg]"]
[null,"Temps de chargement par camion [min]"]
[null,"Temps de déchargement par camion [min]"]
[]
[null,"Paramètres de parcours (seulement aller)"]
[null,"sur route forestière pentue [km]"]
[null,"sur route forestière plate [km]"]
[null,"sur route de montagne [km]"]
[null,"sur route en localité [km]"]
[null,"sur route hors localité [km]"]
[null,"sur autoroute [km]"]
[null,"Restriction de transport (Tonnage) [to]",40,null,null,"     si aucune restriction: tonnage max (40 tonnes)"]
[]
[null,"Tarifs"]
[null,"Prix horaire du camion (chauffeur + TVA incl.) [CHF/h]",180]
[null,"Prix supplémentaire au km [CHF/km]",0]
[null,"Machiniste sur lieu charg/décharg [oui/non]",null,null,null,"Temps investi par rotation [min]"]
[null,"Prix horaire du machiniste (TVA incl.) [CHF/h]",72]
[null,"Grue/trax/etc. suppl. sur lieu charg/décharg  [oui/non]",null,null,null,"Temps de fonctionnement par rotation [min]"]
[null,"Prix horaire de la machine (TVA incl.) [CHF/h]",110]

{"sheet":"Rés Transport","index":27,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,"Résultats techniques"]
[null,"Nombre de rotation"]
[null,"Tonnage limitant"]
[null,"Facteur limitant pour chargement max"]
[null,"Volume apparent maximal transporté par chargement [m3]"]
[null,"Volume apparent moyen transporté par chargement [m3]"]
[null,"Masse maximal transportée par chargement [to]"]
[null,"Masse moyenne transportée par chargement [to]"]
[null,"Distance par trajet (aller-retour) [km]"]
[null,"Temps par trajet [min]"]
[null,"Temps pour Charg/Décharg [min]"]
[null,"Temps par rotation [min]"]
[]
[]
[null,"Coûts","[CHF/rotation]","Total [CHF]"]
[null,"Coût machiniste "]
[null,"Coût grue/tracks/etc. "]
[null,"Coût véhicule transport"]
[null,"Coût Total"]
[]
[null,"Coût par m3 [CHF/m3]"]