{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["INICI","Consums Elèctrics","Consums Combustibles","Transport","CÀLCUL DE LA PETJADA","Taules"],"not_rendered":{"charts":6,"images":6,"macros":1,"external_links":0,"defined_names":4,"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":"INICI","index":0,"n_rows":21,"n_cols":11,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,9,21,15],[0,0,3,15],[4,3,4,13],[12,4,13,10],[6,4,6,8],[7,4,7,8],[8,4,8,8]]}
["CALCULA LA PETJADA DE CARBONI DE LA TEVA EMPRESA!!!"]
[]
[]
[]
[null,null,null,"Per calcular la petjada de carboni de la teva empresa només has de seguir les instruccions següents:"]
[]
[null,null,null,1,"Quina superfície té la teva empresa? Entra el valor aquí →",null,null,null,null,null,"m2"]
[null,null,null,2,"Quants alumnes té el centre educatiu? Entra el valor aquí →",null,null,null,null,null,"alumnes"]
[null,null,null,3,"De quin any vols calcular la teva petjada? Entra el valor aquí →"]
[null,null,null,4,"Botó Inici"]
[null,null,null,5,"Omplir cel·les en blanc"]
[null,null,null,6,"Per avançar, anar pulsant el botó següent"]
[null,null,null,7,"La pantalla final mostra la petjada de carboni total de l'empresa, la petjada per pernoctació i la petjada per superfície de l'empresa"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Eina creada per l'Associació Leader Ripollès Ges Bisaura dins el marc del Projecte \"Gestió Sostenible Rural: Cap a la consolidació de territoris Smart\""]

{"sheet":"Consums Elèctrics","index":1,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[20,4,24,5],[0,0,0,10],[2,0,2,1],[2,2,3,2],[2,3,3,3],[16,0,16,1]]}
["CONSUMS ELÈCTRICS. DESCRIPCIÓ DELS CONSUMS ELÈCTRICS"]
[]
["Període facturació",null,"Consum (kWh)","tnCO2/any"]
["Mesos","Any"]
["GENER",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B5=2013,C5*Taules!$C$2/1000000,IF(B5=2012,C5*Taules!$D$2/1000000,IF(B5=2011,C5*Taules!$E$2/1000000,IF(B5=2010,C5*Taules!$F$2/1000000,IF(B5=2009,C5*Taules!$G$2/1000000,IF(B5=2008,C5*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["FEBRER",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B6=2013,C6*Taules!$C$2/1000000,IF(B6=2012,C6*Taules!$D$2/1000000,IF(B6=2011,C6*Taules!$E$2/1000000,IF(B6=2010,C6*Taules!$F$2/1000000,IF(B6=2009,C6*Taules!$G$2/1000000,IF(B6=2008,C6*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["MARÇ",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B7=2013,C7*Taules!$C$2/1000000,IF(B7=2012,C7*Taules!$D$2/1000000,IF(B7=2011,C7*Taules!$E$2/1000000,IF(B7=2010,C7*Taules!$F$2/1000000,IF(B7=2009,C7*Taules!$G$2/1000000,IF(B7=2008,C7*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["ABRIL",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B8=2013,C8*Taules!$C$2/1000000,IF(B8=2012,C8*Taules!$D$2/1000000,IF(B8=2011,C8*Taules!$E$2/1000000,IF(B8=2010,C8*Taules!$F$2/1000000,IF(B8=2009,C8*Taules!$G$2/1000000,IF(B8=2008,C8*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["MAIG",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B9=2013,C9*Taules!$C$2/1000000,IF(B9=2012,C9*Taules!$D$2/1000000,IF(B9=2011,C9*Taules!$E$2/1000000,IF(B9=2010,C9*Taules!$F$2/1000000,IF(B9=2009,C9*Taules!$G$2/1000000,IF(B9=2008,C9*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["JUNY",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B10=2013,C10*Taules!$C$2/1000000,IF(B10=2012,C10*Taules!$D$2/1000000,IF(B10=2011,C10*Taules!$E$2/1000000,IF(B10=2010,C10*Taules!$F$2/1000000,IF(B10=2009,C10*Taules!$G$2/1000000,IF(B10=2008,C10*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["JULIOL",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B11=2013,C11*Taules!$C$2/1000000,IF(B11=2012,C11*Taules!$D$2/1000000,IF(B11=2011,C11*Taules!$E$2/1000000,IF(B11=2010,C11*Taules!$F$2/1000000,IF(B11=2009,C11*Taules!$G$2/1000000,IF(B11=2008,C11*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["AGOST",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B12=2013,C12*Taules!$C$2/1000000,IF(B12=2012,C12*Taules!$D$2/1000000,IF(B12=2011,C12*Taules!$E$2/1000000,IF(B12=2010,C12*Taules!$F$2/1000000,IF(B12=2009,C12*Taules!$G$2/1000000,IF(B12=2008,C12*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["SETEMBRE",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B13=2013,C13*Taules!$C$2/1000000,IF(B13=2012,C13*Taules!$D$2/1000000,IF(B13=2011,C13*Taules!$E$2/1000000,IF(B13=2010,C13*Taules!$F$2/1000000,IF(B13=2009,C13*Taules!$G$2/1000000,IF(B13=2008,C13*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["OCTUBRE",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B14=2013,C14*Taules!$C$2/1000000,IF(B14=2012,C14*Taules!$D$2/1000000,IF(B14=2011,C14*Taules!$E$2/1000000,IF(B14=2010,C14*Taules!$F$2/1000000,IF(B14=2009,C14*Taules!$G$2/1000000,IF(B14=2008,C14*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["NOVEMBRE",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B15=2013,C15*Taules!$C$2/1000000,IF(B15=2012,C15*Taules!$D$2/1000000,IF(B15=2011,C15*Taules!$E$2/1000000,IF(B15=2010,C15*Taules!$F$2/1000000,IF(B15=2009,C15*Taules!$G$2/1000000,IF(B15=2008,C15*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["DESEMBRE",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(B16=2013,C16*Taules!$C$2/1000000,IF(B16=2012,C16*Taules!$D$2/1000000,IF(B16=2011,C16*Taules!$E$2/1000000,IF(B16=2010,C16*Taules!$F$2/1000000,IF(B16=2009,C16*Taules!$G$2/1000000,IF(B16=2008,C16*Taules!$H$2/1000000,\"Error\"))))))","v":"Error"}]
["TOTAL",null,{"$f":"SUM(C5:C16)","v":0},{"$f":"SUM(D5:D16)","v":0}]

{"sheet":"Consums Combustibles","index":2,"n_rows":35,"n_cols":5,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,34,1],[2,0,2,1],[2,2,2,4],[38,5,42,6],[17,0,17,1],[20,3,21,3],[19,0,19,1],[19,2,19,4],[20,0,20,1],[20,2,21,2],[20,4,21,4],[0,0,0,9],[3,0,3,1],[3,2,4,2],[3,4,4,4],[3,3,4,3]]}
["CONSUM COMBUSTIBLES PER ÚS TÈRMIC"]
[]
["COMBUSTIBLE 1"]
["Període facturació",null,{"$f":"LOOKUP(C3,Taules!A2:A16,Taules!B2:B16)","v":{"$error":"#N/A"}},"gCO2/unitat","tnCO2"]
["Mesos","Any"]
["GENER",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,COMBUSTIBLE,Taules!$C$2:$C$16))","v":""},{"$f":"IF(C6=\"\",0,C6*D6/1000000)","v":0}]
["FEBRER",{"$f":"INICI!$J$9","v":0},null,{"$f":"D6","v":""},{"$f":"IF(C7=\"\",0,C7*D7/1000000)","v":0}]
["MARÇ",{"$f":"INICI!$J$9","v":0},null,{"$f":"D7","v":""},0]
["ABRIL",{"$f":"INICI!$J$9","v":0},null,"",0]
["MAIG",{"$f":"INICI!$J$9","v":0},null,"",0]
["JUNY",{"$f":"INICI!$J$9","v":0},null,"",0]
["JULIOL",{"$f":"INICI!$J$9","v":0},null,"",0]
["AGOST",{"$f":"INICI!$J$9","v":0},null,"",0]
["SETEMBRE",{"$f":"INICI!$J$9","v":0},null,"",0]
["OCTUBRE",{"$f":"INICI!$J$9","v":0},null,"",0]
["NOVEMBRE",{"$f":"INICI!$J$9","v":0},null,"",0]
["DESEMBRE",{"$f":"INICI!$J$9","v":0},null,"",0]
["TOTAL",null,{"$f":"SUM(C6:C17)","v":0},null,{"$f":"SUM(E6:E17)","v":0}]
[]
["COMBUSTIBLE 2"]
["Període facturació",null,{"$f":"LOOKUP(C20,Taules!A2:A16,Taules!B2:B16)","v":{"$error":"#N/A"}},"gCO2/unitat","tnCO2"]
["Mesos","Any"]
["GENER",{"$f":"INICI!$J$9","v":0},null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,COMBUSTIBLE,Taules!$C$2:$C$16))","v":""},{"$f":"IF(C23=\"\",0,C23*D23/1000000)","v":0}]
["FEBRER",{"$f":"INICI!$J$9","v":0},null,{"$f":"D23","v":""},{"$f":"IF(C24=\"\",0,C24*D24/1000000)","v":0}]
["MARÇ",{"$f":"INICI!$J$9","v":0},null,{"$f":"D24","v":""},0]
["ABRIL",{"$f":"INICI!$J$9","v":0},null,"",0]
["MAIG",{"$f":"INICI!$J$9","v":0},null,"",0]
["JUNY",{"$f":"INICI!$J$9","v":0},null,"",0]
["JULIOL",{"$f":"INICI!$J$9","v":0},null,"",0]
["AGOST",{"$f":"INICI!$J$9","v":0},null,"",0]
["SETEMBRE",{"$f":"INICI!$J$9","v":0},null,"",0]
["OCTUBRE",{"$f":"INICI!$J$9","v":0},null,"",0]
["NOVEMBRE",{"$f":"INICI!$J$9","v":0},null,"",0]
["DESEMBRE",{"$f":"INICI!$J$9","v":0},null,"",0]
["TOTAL",null,{"$f":"SUM(C23:C34)","v":0},null,{"$f":"SUM(E23:E34)","v":0}]

{"sheet":"Transport","index":3,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,34,1],[38,6,42,7],[3,3,4,3],[20,3,21,3],[17,0,17,1],[19,0,19,1],[19,2,19,5],[20,0,20,1],[20,2,21,2],[20,4,21,4],[20,5,21,5],[0,0,0,10],[2,0,2,1],[2,2,2,5],[3,0,3,1],[3,2,4,2],[3,4,4,4],[3,5,4,5]]}
["CONSUM COMBUSTIBLES EN TRANSPORT"]
[]
["COMBUSTIBLE 1"]
["Període facturació",null,"Litres","% (en cas de bioetanol i biodièsel)","gCO2/unitat","tnCO2"]
["Mesos","Any"]
["GENER",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},{"$f":"IF(C6=\"\",0,C6*(E6-D6*E6)/1000000)","v":0}]
["FEBRER",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},{"$f":"IF(C7=\"\",0,C7*(E7-D7*E7)/1000000)","v":0}]
["MARÇ",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},0]
["ABRIL",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},0]
["MAIG",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},0]
["JUNY",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},0]
["JULIOL",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},0]
["AGOST",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},0]
["SETEMBRE",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},0]
["OCTUBRE",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},0]
["NOVEMBRE",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},0]
["DESEMBRE",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C3=\"\",\"\",LOOKUP($C$3,Transport,Taules!$B$19:$B$23))","v":""},0]
["TOTAL",null,{"$f":"SUM(C6:C17)","v":0},null,null,{"$f":"SUM(F6:F17)","v":0}]
[]
["COMBUSTIBLE 2"]
["Període facturació",null,"Litres","% (en cas de bioetanol i biodièsel)","gCO2/unitat","tnCO2"]
["Mesos","Any"]
["GENER",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},{"$f":"IF(C23=\"\",0,C23*(E23-D23*E23)/1000000)","v":0}]
["FEBRER",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},{"$f":"IF(C24=\"\",0,C24*(E24-D24*E24)/1000000)","v":0}]
["MARÇ",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},0]
["ABRIL",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},0]
["MAIG",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},0]
["JUNY",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},0]
["JULIOL",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},0]
["AGOST",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},0]
["SETEMBRE",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},0]
["OCTUBRE",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},0]
["NOVEMBRE",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},0]
["DESEMBRE",{"$f":"INICI!$J$9","v":0},null,null,{"$f":"IF(C20=\"\",\"\",LOOKUP($C$20,Transport,Taules!$B$19:$B$23))","v":""},0]
["TOTAL",null,{"$f":"SUM(C23:C34)","v":0},null,null,{"$f":"SUM(F23:F34)","v":0}]

{"sheet":"CÀLCUL DE LA PETJADA","index":4,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,0,0,6],[29,0,29,10],[4,1,4,5],[2,1,2,5],[10,3,10,5],[12,2,12,5],[10,7,10,8],[12,7,12,8],[8,1,8,5],[6,1,6,5]]}
["PETJADA DE CARBONI TOTAL (ABAST 1 + 2)",null,null,null,null,null,null,"ANY",{"$f":"INICI!J9","v":0}]
[]
[null,"Petjada de carboni per consum elèctric",null,null,null,null,{"$f":"'Consums Elèctrics'!$D$17","v":0},"tnCO2"]
[]
[null,"Petjada de carboni per consum de combustible per ús tèrmic",null,null,null,null,{"$f":"'Consums Combustibles'!E18+'Consums Combustibles'!E35","v":0},"tnCO2"]
[]
[null,"Petjada de carboni per cunsum de combustible per transport",null,null,null,null,{"$f":"Transport!F18+Transport!F35","v":0},"tnCO2"]
[]
[null,"TOTAL PETJADA DE CARBONI",null,null,null,null,{"$f":"G3+G5+G7","v":0},"tnCO2"]
[]
[null,null,null,"PETJADA PER M2",null,null,{"$f":"G9/INICI!J7","v":{"$error":"#DIV/0!"}},"tnCO2/m2"]
[]
[null,null,"PETJADA PER ALUMNE",null,null,null,{"$f":"G9/INICI!J8","v":{"$error":"#DIV/0!"}},"tnCO2/alumne"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Eina creada per l'Associació per a la Gestió del Programa Leader Ripollès Ges Bisaura dins el marc del Projecte \"Gestió Sostenible Rural: Cap a la consolidació de territoris Smart\""]

{"sheet":"Taules","index":5,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,3,15,6]]}
["Energia tèrmica",null,"gCO2/unitat",2012,2011,2010,2009,2008]
["Electricitat peninsular","Consum kWh",248,300,267,206,297,313]
["Fuel kg","Consum kg",3050]
["Fuel kWh","Consum kWh",273.3]
["Gas butà bombones","Consum bombones",37060]
["Gas butà kg","Consum kg",2960]
["Gas butà kWh","Consum kWh",237.94]
["Gas natural kWh","Consum kWh",200.93]
["Gas natural m3","Consum m3",2150]
["Gas propà bombones","Consum bombones",102840]
["Gas propà kg","Consum kg",2940]
["Gas propà kWh","Consum kWh",229.15]
["Gasoil kWh","Consum kWh",236.84]
["Gasoil L","Consum L",2790]
["GLP kg","Consum kg",2960]
["GLP kWh","Consum kWh",234.18]
[]
["Combustibles","gCO2/litre"]
["Biodièsel",2610]
["Bioetanol",2380]
["Dièsel",2610]
["Gasolina 95",2380]
["Gasolina 98",2380]