{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["APLICATIU","Xarxa pluviòmetres","Esquema cloració","Esquema UV","Dades meteorològiques","Aigua recollida","Pluviometres_CAT","Balanç anual","Consum","Necessitats de reg","Tarifes","Pressupost","Formularis"],"not_rendered":{"charts":0,"images":28,"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":"APLICATIU","index":0,"n_rows":36,"n_cols":32,"rows_kept":36,"cut":false,"hidden":false,"merged":[[15,22,15,27],[16,22,18,25],[19,22,20,25],[24,22,25,25],[16,26,18,27],[19,26,20,27],[30,31,31,32],[30,9,30,10],[29,26,30,27],[29,22,30,24],[31,22,32,24],[31,25,32,27],[27,22,28,23],[33,22,34,25],[33,26,34,27],[30,17,31,17],[32,14,32,16],[33,14,33,16],[21,22,23,25],[21,26,23,27],[24,26,25,27],[30,14,31,16],[27,14,27,15],[24,14,24,15],[23,14,23,15],[21,14,22,15],[28,14,29,14],[25,16,26,16],[27,26,28,27],[34,7,34,8],[34,9,34,11],[23,7,23,11],[24,7,24,11],[25,7,25,11],[33,9,33,10],[32,9,32,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[32,7,32,8],[33,7,33,8],[2,10,3,11],[16,7,17,10],[18,7,19,10],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[20,7,20,10],[15,7,15,10],[6,7,6,8],[7,7,7,8],[8,7,8,8],[6,9,6,10],[7,9,7,10],[8,9,8,10],[21,7,21,11],[2,7,3,7],[3,8,3,9],[1,21,1,28],[3,24,3,27],[4,24,4,27],[5,24,6,27],[9,24,11,27],[9,22,11,23],[7,22,8,23],[7,24,8,27],[34,1,34,2],[34,3,34,5],[1,14,1,18],[3,14,3,18],[10,15,11,15],[3,2,3,4],[15,2,15,4],[1,1,1,5],[32,1,32,2],[33,1,33,2],[17,2,18,2],[17,4,18,4],[32,3,32,5],[1,7,1,11],[33,3,33,5],[34,14,34,15],[4,14,4,15],[4,16,4,18],[20,17,20,18],[25,14,26,15],[20,14,20,16],[25,17,26,18],[23,17,24,17],[8,16,8,18],[11,16,11,18],[12,16,12,18],[13,16,13,18],[14,16,14,18],[23,18,24,18],[10,16,10,18],[12,14,15,14],[10,14,11,14],[9,16,9,18],[21,18,22,18],[21,17,22,17],[12,15,15,15],[18,14,18,18],[15,16,15,18],[19,15,19,16],[21,16,22,16]]}
[]
[null,"DEMANDA A COBRIR",null,null,null,null,null,"DISPONIBILITAT D'AIGUA",null,null,null,null,null,null,"DESINFECCIÓ",null,null,null,null,null,null,"ESTALVI D'AIGUA"]
[null,null,null,null,null,null,null,"PLUVIOMETRE",null,null,"Veure plànol pluviòmetres"]
[null,null,"DOMÈSTICA",null,null,null,null,null,"Sant Andreu",null,null,null,null,null,"DESINFECCIÓ AMB HIPOCLORIT"]
[null,null,null,"RESIDENTS",null,null,null,null,null,null,null,null,null,null,"Veure esquema de desinfecció amb hipoclorit",null,"Veure esquema de desinfecció per rajos UV",null,null,null,null,null,null,null,"DEMANDA "]
[null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,"CAPACITAT",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(I4,'Balanç anual'!AN6:AS7,3,FALSE)+VLOOKUP(I4,'Balanç anual'!AN6:AS7,4,FALSE)","v":123.86507342465754}]
[null,null,null,"OCUPACIÓ MITJANA ANUAL",null,null,null,"PRECIPITACIÓ",null,"SUPERFÍCIE DE RECOLLIDA",null,null,null,null,null,{"$f":"D10/2","v":161}]
[null,null,null,1,null,null,null,{"$f":"IF(I4=\"Personalitzat\",'Dades meteorològiques'!O7,IF(J22=0,(VLOOKUP(I4,'Aigua recollida'!P6:Q23,2,FALSE)),APLICATIU!J22))","v":677},null,70,null,null,null,null,null,"litres",null,null,null,null,null,null,"ESTALVI D'AIGUA",null,"VOLUM D'AIGUA ESTALVIAT"]
[null,null,null,"CONSUM\nFins a",null,null,null,"mm/any",null,"m² coberta",null,null,null,null,"VOLUM ESCOLLIT",{"$f":"IF(AND(P7=0,P7=0),0,IF(AND(P7>0,P7<=43),43,IF(AND(P7>43,P7<=94),94,IF(AND(P7>94,P7<=190),190,IF(AND(P7>190,P7<=297),297,IF(AND(P7>297,P7<=486),486,IF(AND(P7>486,P7<=905),905,IF(AND(P7>905,P7<=1002),1002,IF(AND(P7>1002,P7<=1050),1050,IF(AND(P7>1050,P7<=100000000000),1050))))))))))","v":190}]
[null,null,null,{"$f":"IF(D12=0,Consum!C16*D6,D12)","v":322},null,null,null,null,null,null,null,null,null,null,"TEMPS DE CONTACTE (hores)",{"$f":"(P9/D10)*24","v":14.161490683229815},"CABAL DE RECIRCULACIÓ",null,null,null,null,null,{"$f":"IFERROR(Y10/Y6,\"-\")","v":0.36368605575809071},null,{"$f":"IFERROR(VLOOKUP(I4,'Balanç anual'!AN6:AS7,6,FALSE),\"-\")","v":45.048000000000002}]
[null,null,null,"litres/dia",null,null,null,null,null,null,null,null,null,null,"DOSIFICACIÓ DE CLOR",0.5,{"$f":"J29/24","v":0.15833333333333335}]
[null,null,"Personalitzat",0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONCENTRACIÓ HIPOCLORIT",40]
[]
[]
[null,null,"REG",null,null,null,null,"VOLUM RECOLLIT (Eficiència 80%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PRESSUPOST"]
[null,null,"VEGETACIÓ","TIPUS DE REG","SUPERFÍCIE",null,null,"MITJÀ",null,null,null,null,null,null,"DOSI HIPOCLORIT",{"$f":"P9*P11/P13","v":2.375},null,null,null,null,null,null,"RECOL·LECCIÓ I EMMAGATZEMATGE D'AIGÜES PLUVIALS",null,null,null,{"$f":"IFERROR(Pressupost!C69,0)","v":865.6}]
[null,null,"Plantes de zona àrida",null,0]
[null,null,null,"Mànega",null,null,null,{"$f":"IF(J22=0,(VLOOKUP(I4,'Aigua recollida'!P6:R23,3,FALSE)),H8/365*J8*0.8)","v":103.86849315068493},null,null,null,null,null,null,"GRUP DE PRESSIÓ"]
[null,null,"Fruites","Mànega",0,null,null,null,null,null,null,null,null,null,null,"PLANTES EDIFICI",null,1,null,null,null,null,{"$f":"Pressupost!B70","v":"CLORACIÓ"},null,null,null,{"$f":"Pressupost!C70","v":1223.27}]
[null,null,"Arbres","Mànega",0,null,null,"litres/dia",null,null,null,null,null,null,"BANYS",null,null,"CUINA"]
[null,null,"Arbustos","Mànega",0,null,null,"Personalitzar dades meteorològiques",null,null,null,null,null,null,"De quants lavabos disposa l'habitatge?",null,1,"Quantes piques hi ha a l'habitatge?",1,null,null,null,"GRUP DE PRESSIÓ",null,null,null,{"$f":"Pressupost!C71","v":1623.5}]
[]
[null,null,"Flors","Mànega",0,null,null,"CAPACITAT DEL DIPÒSIT",null,null,null,null,null,null,"Quantes dutxes hi ha a l'habitatge?",null,0,"Es disposa de rentavaixelles? Quants?",0]
[null,null,"Gespa","Aspersió",5,null,null,"DIMENSIONAR PER",null,null,null,null,null,null,"Tens alguna banyera petita (menys de 1,40 m)? ",null,0,null,null,null,null,null,"CANONADES, VÀLVULES I ACCESSORIS",null,null,null,{"$f":"Pressupost!C72","v":230.23000000000002}]
[null,null,"Horta","Mànega",0,null,null,{"$f":"IF(D34>H19,\"DISPONIBILITAT\",\"DEMANDA\")","v":"DISPONIBILITAT"},null,null,null,null,null,null,"Tens alguna banyera gran (igual o més de 1,40 m)? ",null,0,"ALTRES"]
[]
[null,null,null,"SUPERFÍCIE","CONSUM\nFins a",null,null,null,null,"VOLUM",null,null,null,null,"Quants bidets hi ha a l'habitatge?",null,0,"Hi ha algun safareig a l'habitatge?",1,null,null,null,"MÀ D'OBRA",null,null,null,{"$f":"Pressupost!C73","v":400}]
[null,null,null,{"$f":"IF(D31=0,SUM(E18:E26),D31)","v":5},{"$f":"IF(D31=0,Consum!K19,D31*Consum!K2)","v":31.617204301075272},null,null,null,null,{"$f":"IF(J35=0,IF(H26=\"DISPONIBILITAT\",ROUNDUP(H19*'Aigua recollida'!H2/1000*1.2,1),IF(H26=\"DEMANDA\",IF(D34<=H19,ROUNDUP(D34*'Aigua recollida'!H2/1000*1.2,1),\"-\"),\"-\")),J35)","v":3.8000000000000003},null,null,null,null,"De quants inodors disposa l'habitatge? Son amb cisterna o amb fluxor?","Cisterna",1,"Quantes rentadores tens?",0]
[null,null,null,"m²","litres/dia",null,null,null,null,"PRECIPITACIÓ UTLITZADA",null,null,null,null,null,"Fluxor",0,"L'habitatge disposa d'alguna aixeta aïllada (jardí, garatge…)?",1,null,null,null,"TOTAL INSTAL·LACIÓ",null,null,null,{"$f":"IFERROR(Pressupost!C74,0)","v":4342.6000000000004}]
[null,null,"Personalitzat",0,null,null,null,null,null,{"$f":"IF(AND(J29=\"-\",0),0,IF(AND('Balanç anual'!AQ8>'Balanç anual'!AQ9),'Balanç anual'!AQ9/'Balanç anual'!AQ8,IF(AND('Balanç anual'!AQ9>'Balanç anual'!AQ8),\"100\",\"-\")))","v":0.10019435697744913},null,null,null,null,"CABAL A IMPULSAR",null,null,"PRESSIÓ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Desenvolupat per:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"IVA 21%",null,null,{"$f":"IFERROR(Pressupost!C75,0)","v":911.94600000000003}]
[null,null,null,"DEMANDA",null,null,null,"DEMANDA COBERTA",null,"DIES DE RESERVA AL JULIOL",null,null,null,null,{"$f":"Consum!H20","v":1.6530710189124076},null,null,{"$f":"IF(1.2*(15+(R20*3)/0.8)<50,1.2*(15+(R20*3)/0.8),50)","v":22.5}]
[null,null,null,{"$f":"D10+E29","v":353.61720430107528},null,null,null,{"$f":"IFERROR(Y10/Y6,\"-\")","v":0.36368605575809071},null,{"$f":"'Balanç anual'!AP11","v":3.1672667120755085},null,null,null,null,"m³/h",null,null,"m.c.a",null,null,null,null,"TOTAL INSTAL·LACIÓ IVA INCLÓS",null,null,null,{"$f":"IFERROR(Pressupost!C76,0)","v":5254.5460000000003}]
[null,null,null,"litres/dia",null,null,null,"Personalitzat",null,0,null,null,null,null,"CANONADA PROPOSADA",null,null,{"$f":"CONCATENATE(\"PE40 DN\",VLOOKUP(1,Consum!F25:H30,3,FALSE),\" PN10\")","v":"PE40 DN25 PN10"}]
[null,null,null,null,null,null,null,null,null,8]

{"sheet":"Xarxa pluviòmetres","index":1,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,2,7],[1,9,2,10]]}
[]
["XARXA DE PLUVIÒMETRES DEL PARC DEL MONTNEGRE I CORREDOR",null,null,null,null,null,null,null,null,"Torna a l'aplicatiu"]

{"sheet":"Esquema cloració","index":2,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,3,5],[1,6,3,7]]}
[]
["ESQUEMA DEL SISTEMA D'APROFITAMENT D'AIGÜES PLUVIALS AMB DESINFECCIÓ PER CLORACIÓ",null,null,null,null,null,"Torna a l'aplicatiu"]

{"sheet":"Esquema UV","index":3,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,0,3,5],[1,6,3,7]]}
[]
["ESQUEMA DEL SISTEMA D'APROFITAMENT D'AIGÜES PLUVIALS AMB DESINFECCIÓ PER RAJOS UV",null,null,null,null,null,"Torna a l'aplicatiu"]

{"sheet":"Dades meteorològiques","index":4,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,2,7],[1,13,2,14]]}
[]
[null,"DADES METEOROLÒGIQUES",null,null,null,null,null,null,null,null,null,null,null,"Torna a l'aplicatiu"]
[]
[]
[null,"Dades de precipitació"]
[null,"Mes","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre","Total"]
[null,"Pluviometria (mm)",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C7:N7)","v":0}]
[]
[null,"Dades d'evapotranspiració"]
[null,"Mes","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre","Total"]
[null,"Eto mitjana (mm/mes)",0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C11:N11)","v":0}]

{"sheet":"Aigua recollida","index":5,"n_rows":213,"n_cols":19,"rows_kept":213,"cut":false,"hidden":true,"merged":[[1,5,1,6]]}
[]
["Superfície coberta",{"$f":"APLICATIU!J8","v":70},null,null,null,"Dies de període sec",null,30]
["Eficiència de recollida",0.8]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PLUVIOMETRE","PLUVIOMETRIA (mm)","AIGUA RECOLLIDA (l/dia)","AIGUA RECOLLIDA (m³/any)"]
["Personalitzat",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A13","v":"Sant Andreu"},{"$f":"N16","v":677},{"$f":"N18","v":103.86849315068493},{"$f":"N17","v":37.911999999999999}]
[null,31,28,31,30,31,30,31,31,30,31,30,31,365,null,{"$f":"A6","v":"Personalitzat"},{"$f":"N9","v":0},{"$f":"N11","v":0},{"$f":"N10","v":0}]
["Mes","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre","Total"]
["Pluviometria (mm)",{"$f":"'Dades meteorològiques'!C7","v":0},{"$f":"'Dades meteorològiques'!D7","v":0},{"$f":"'Dades meteorològiques'!E7","v":0},{"$f":"'Dades meteorològiques'!F7","v":0},{"$f":"'Dades meteorològiques'!G7","v":0},{"$f":"'Dades meteorològiques'!H7","v":0},{"$f":"'Dades meteorològiques'!I7","v":0},{"$f":"'Dades meteorològiques'!J7","v":0},{"$f":"'Dades meteorològiques'!K7","v":0},{"$f":"'Dades meteorològiques'!L7","v":0},{"$f":"'Dades meteorològiques'!M7","v":0},{"$f":"'Dades meteorològiques'!N7","v":0},{"$f":"SUM(B9:M9)","v":0}]
["Aigua recollida (m³)",{"$f":"B9*$B$2*$B$3/1000","v":0},{"$f":"C9*$B$2*$B$3/1000","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B10:M10)","v":0}]
[null,{"$f":"B10*1000/B7","v":0},{"$f":"C10*1000/C7","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"APLICATIU!I4","v":"Sant Andreu"}]
[null,31,28,31,30,31,30,31,31,30,31,30,31,365]
["Mes","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre","Total"]
["Pluviometria (mm)",{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,2,FALSE)","v":58},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,3,FALSE)","v":63},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,4,FALSE)","v":56},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,5,FALSE)","v":59},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,6,FALSE)","v":54},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,7,FALSE)","v":30},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,8,FALSE)","v":20},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,9,FALSE)","v":46},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,10,FALSE)","v":86},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,11,FALSE)","v":91},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,12,FALSE)","v":56},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,13,FALSE)","v":58},{"$f":"SUM(B16:M16)","v":677}]
["Aigua recollida (m³)",{"$f":"B16*$B$2*$B$3/1000","v":3.2480000000000002},{"$f":"C16*$B$2*$B$3/1000","v":3.528},3.1360000000000001,3.3039999999999998,3.024,1.68,1.1200000000000001,2.5760000000000001,4.8159999999999998,5.0960000000000001,3.1360000000000001,3.2480000000000002,{"$f":"SUM(B17:M17)","v":37.911999999999999}]
[null,{"$f":"B17*1000/B14","v":104.7741935483871},{"$f":"C17*1000/C14","v":126},101.16129032258064,110.13333333333334,97.548387096774192,56,36.12903225806452,83.096774193548384,160.53333333333333,164.38709677419354,104.53333333333333,104.7741935483871,103.86849315068493]
[]
[]
["PLUVIOMETRIA","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre"]
["Sant Andreu",58,63,56,59,54,30,20,46,86,91,56,58]
["El Trull",74.61363636363636,49.613636363636367,45.18181818181818,56.622727272727275,54.604545454545452,38.18181818181818,28.90909090909091,38.136363636363633,62.227272727272727,100.63636363636364,67.36363636363636,61.772727272727273]
["Can Xerrac",48.045454545454547,38.5,41.090909090909093,60.772727272727273,37.636363636363633,28.454545454545453,23.318181818181817,32.409090909090907,69.590909090909093,73.13636363636364,50.363636363636367,45.68181818181818]
["Serra de l'Esquirol",64.015151515151516,54.454545454545453,59.772727272727273,63.636363636363633,56.772727272727273,38.31818181818182,24.045454545454547,43.954545454545453,84.090909090909093,85.272727272727266,68.454545454545453,43.863636363636367]
["Ca l'Agustí",71.531818181818181,45.377272727272725,59.136363636363633,62.5,53.227272727272727,36.136363636363633,20.045454545454547,38.81818181818182,70.409090909090907,109.27272727272727,61.272727272727273,65.63636363636364]
["Can Preses",76.63636363636364,52.727272727272727,68.045454545454547,74.409090909090907,61.5,41.409090909090907,20,46.31818181818182,77.818181818181813,99,82.86363636363636,56.090909090909093]
["----------------------------"]
["Personalitzat",{"$f":"'Dades meteorològiques'!C7","v":0},{"$f":"'Dades meteorològiques'!D7","v":0},{"$f":"'Dades meteorològiques'!E7","v":0},{"$f":"'Dades meteorològiques'!F7","v":0},{"$f":"'Dades meteorològiques'!G7","v":0},{"$f":"'Dades meteorològiques'!H7","v":0},{"$f":"'Dades meteorològiques'!I7","v":0},{"$f":"'Dades meteorològiques'!J7","v":0},{"$f":"'Dades meteorològiques'!K7","v":0},{"$f":"'Dades meteorològiques'!L7","v":0},{"$f":"'Dades meteorològiques'!M7","v":0},{"$f":"'Dades meteorològiques'!N7","v":0}]
["----------------------------"]
["AltCamp_VY_Nulles",16.7,85.6,32.6,80.5,35.700000000000003,22.2,2.5,42.2,37.1,220.5,48.3,7.7]
["AltCamp_DQ_Vila-rodona",23.5,72.2,45.2,90.4,81.099999999999994,40.4,4.2,41.8,38.4,198.3,51.8,6.5]
["Alt Emporda_U1_Cabanes",24.4,67.7,41.6,132.80000000000001,54.7,56,11.9,18.100000000000001,25.8,251.7,162,18.2]
["Alt Emporda_W1_Castelló d'Empúries",19.8,43.5,44.1,74.5,57.1,32.4,12.4,29.6,4.0999999999999996,202.2,125.9,12.7]
["Alt Emporda_vz_Espolia",53.6,46.5,41.9,109.8,82.1,59.7,21.4,31.6,17.7,190.4,177.4,15]
["Alt Emporda_Y5_Navata",38.9,87.1,31.9,128.9,110.5,97.3,35.1,22.8,36.4,209.1,265.5,15.1]
["Alt Emporda_J5_Panta de Darnius - Boadella",57,81.099999999999994,40.799999999999997,152.5,102.9,68.3,39.299999999999997,27.7,34.700000000000003,297.89999999999998,272.8,16.3]
["Alt Emporda_D6_Portbou",17.7,58.7,68.900000000000006,75.599999999999994,24.1,28,40.200000000000003,60.8,24.2,231.8,64.5,29.8]
["Alt Emporda_D4_Roses",21.8,44.3,48.9,63.3,33.1,25.2,22.4,70.7,2.2999999999999998,222.1,81.3,20.5]
["Alt Emporda_U2_ Sant Pere Pescador",25.6,61.1,40.299999999999997,79.599999999999994,44.5,45.5,38.200000000000003,49.2,8.6,211.5,112.6,21.7]
["Alt Emporda_xz_Torroella de Fluvia",34,67.8,43.4,71.599999999999994,62.9,46.6,38.5,18,6.3,191.3,114.5,20.2]
["Alt Penedes_WP_Canaletes",63.3,117.8,72.8,90.3,96.3,55.3,11.2,25.6,41.9,185.8,72.599999999999994,2.5]
["Alt Penedes_DI_Font-rubí",63.4,121.3,65.900000000000006,110.3,88.9,36.299999999999997,0.9,26.2,36.4,222.8,61.8,4.8]
["Alt Penedes_W4_la Granada",61.5,130.6,60.9,88.7,48.4,47.1,13.9,46.9,31.2,214.2,94,3.6]
["Alt Penedes_U3_Sant Martí Sarroca",57,130.1,48.3,83.7,39.700000000000003,29.7,9.4,48,38.700000000000003,252,60.7,4.5]
["Alt Penedes_WY_Sant Sadurní d'Anoia",50.3,96.1,70.3,82.7,82.5,47,10.8,49.8,67.900000000000006,181,92,3.3]
["Alt Urgell_Y4_ Alinya",91.7,131.5,129.69999999999999,132.9,169,95.8,26.8,119.9,43,250.6,84.5,6.6]
["Alt Urgell_CD_la Seu d'Urgell - Bellestar",58.9,73.7,55.4,96.7,143.69999999999999,40.799999999999997,51,33.799999999999997,63,125.7,52,6]
["Alt Urgell_W5_Oliana",56.4,137.5,109.1,140.5,161.6,52.9,21.7,74.7,25.5,169.5,90.5,10.3]
["Alt Urgell_CJ_Organya",66.5,90.3,82,107.1,185.4,112.9,15.3,78.400000000000006,84.6,155.5,65.5,6.8]
["Alta Ribagorça_Z2_Boí (2.535 m)",113.6,183,229.8,254.9,179.9,104.3,42.5,148.69999999999999,212.3,181,99,8.4]
["Alta Ribagorça_CT_el Pont de Suert",46.4,103.7,130.69999999999999,231.2,202.7,88.7,44.6,64.900000000000006,112.5,145.19999999999999,91.3,12.8]
["Anoia_CE_els Hostalets de Pierola",69.099999999999994,87.3,56.3,92.7,79,94.7,7.3,27.6,76,187.2,108.5,2.2999999999999998]
["Anoia_XB_la Llacuna",53.2,129.80000000000001,63.1,129,123.6,63.3,2.7,19.3,33.299999999999997,263.5,79.3,3.8]
["Anoia_XA_la Panadella",42.4,60.6,59.5,88.7,66.8,44,27.3,98.2,38.299999999999997,196.2,63.6,5.8]
["Anoia_H1_ ódena",65.3,100.5,45.6,78.8,68.599999999999994,82.5,13.9,91.5,41.2,191.8,74.599999999999994,4.3]
["Bages_WW_Artés",85.7,85.9,67.400000000000006,70.5,194.7,84.6,12.4,93.1,9.6,181.2,88,5.4]
["Bages_MQ_Cardona",76.8,84.9,59.6,84,71.7,37,71.400000000000006,64.900000000000006,42,170.2,88,6.1]
["Bages_U4_ Castellnou de Bages",83.8,88,54.1,66.099999999999994,113.6,98,29.8,80.599999999999994,24,172.6,89.6,7]
["Bages_R1_el Pont de Vilomara",68.2,87.8,63.2,84.6,183.7,57.4,10.4,20.5,17.5,162,116.1,4]
["Bages_WN_Montserrat - Sant Dimes",80.3,80.400000000000006,67.2,106.3,124.8,69.8,26.4,44.2,56.9,171.8,145.69999999999999,3.6]
["Bages_CL_Sant Salvador de Guardiola",84,110.1,58.4,90.1,118.6,43.2,20.9,34.200000000000003,52,194.7,129.30000000000001,3.1]
["Baix Camp_YF_Mont-roig del Camp",10.8,116.6,22.5,61,15.2,17.8,6.9,27.4,71.599999999999994,197.1,70.400000000000006,3.9]
["Baix Camp_XR_Prades",52.4,100.7,67.599999999999994,155.6,127.4,17.5,5.7,25.6,46.7,314.39999999999998,93.1,14]
["Baix Camp_W6_Riudoms",16.5,101.4,32.5,64.8,55.8,10.7,5.2,102.2,26.2,287.8,69.7,4.9000000000000004]
["Baix Camp_U6_ Vinyolsi els Ares",12,88.3,19.7,62.3,19.8,9.3000000000000007,5.2,100.1,29.8,275.60000000000002,55.3,5.0999999999999996]
["Baix Ebre_U7_Aldover",9.8000000000000007,42.4,25.8,58.8,25.2,7.3,35.200000000000003,91.6,42.5,234.6,115.4,8.1999999999999993]
["Baix Ebre_DB_el Perelló",11.8,59.1,18.3,45.3,52.1,3.5,18.7,21.3,41.9,190.2,59,6.2]
["Baix Ebre_U9_l'Aldea",10.7,53.5,22.4,39.799999999999997,106.5,9.1,14.1,15,28.5,226.8,164.7,8]
["Baix Ebre_UA_l'Amet llade Mar",9.6,68.900000000000006,27,44.3,50,5.5,12.8,14.9,61.5,220.3,52.8,7.5]
["Baix Ebre_X5_PN deis Ports",71.400000000000006,67.7,45,158.1,89.1,51.8,51.3,50.7,82.9,462.4,301.10000000000002,51]
["Baix Emporda_DO_Castell d'Aro",24.8,64.599999999999994,38.4,118.2,55.1,47.7,22.6,18.5,3.5,221.9,149.19999999999999,11.6]
["Baix Emporda_DF_la Bisbal d'Emporda",35.200000000000003,77,47,129.1,61.4,10.7,51.2,17.2,5.6,189.7,327.3,15]
["Baix Emporda_UB_la Tallada d'Emporda",25.5,72.3,52.6,86.4,46.4,17.899999999999999,47.8,23.4,16.899999999999999,158.9,232.9,14.7]
["Baix Emporda_uc_Monells",31.2,72.3,44.1,114.3,46.6,28.7,60,27.2,11,161,293.7,15.4]
["Baix Emporda_UE_Torroella de Montgrí",50,71.599999999999994,61.8,71.5,53.6,24.7,46.2,15.6,15,161.6,56.6,27.2]
["Baix Llobregat_XL_el Pral de Llobregat",52.2,117,89.8,53.2,36.9,37.200000000000003,9.4,85,87.1,171.1,132.5,4.4000000000000004]
["Baix Llobregat_UF_PN del Garraf - el Rascler",46.9,154,64.900000000000006,47.6,25.9,73.2,6,60.5,115.6,173.7,96.3,7]
["Baix Llobregat_Y9_Port de Barcelona - ZAL Prat",48.2,96.4,74.2,39,36.1,32.6,19,85.4,82.3,184.6,97.5,4.5]
["Baix Llobregat_D3_Vallirana",101.5,169.2,93.9,83.7,31.6,99.1,20.2,123.7,56.9,180.1,174.2,3.8]
["Baix Llobregat_UG_Viladecans",48.6,139.19999999999999,63.2,41.3,41.4,43.2,5.9,83.5,47.5,145.80000000000001,176.9,4.0999999999999996]
["Baix Penedés_WZ_Cunit",43.5,125.2,44.1,41.1,14.3,42.9,2.4,113.5,108.3,250.8,69.599999999999994,3.9]
["Baix Penedés_UH_el Montmell",36.200000000000003,118.1,73.900000000000006,103.6,67.900000000000006,38.5,1.9,76.3,34.5,328.6,70.2,6.1]
["Baix Penedés_D9_el Vendrell",26.7,111.2,42.5,66.599999999999994,19.2,32.799999999999997,28.4,89.9,96.8,239.8,71.900000000000006,4.2]
["Baix Penedés_WO_la Bisbal del Penedés",19.2,98.6,45.1,76.099999999999994,21.7,47.8,9,60.5,65.599999999999994,247.8,59.6,4.5]
["Barcelonés_WU_Badalona - Museu",71.7,82.7,75.8,34.1,40.799999999999997,34,57.1,30.9,116.2,151.19999999999999,108.6,3.3]
["Barcelonés_X4_Barcelona - el Raval",55.4,89.6,79.099999999999994,48.6,87.6,12.9,24.7,96.2,154.80000000000001,187.9,168.8,4.5999999999999996]
["Barcelonés_D5_Barcelona - Observatori Fabra",62.5,104,113.5,58.6,53.6,52.7,51.4,36.200000000000003,43.6,195.6,207.6,4.9000000000000004]
["Barcelonés_X8_Barcelona - Zona Universitaria",55.6,108.7,104.3,53.8,41.8,52.5,12.4,47.3,93.9,217.1,128,4.4000000000000004]
["Bergueda_MS_Castellar de n'Hug - el Clot del Moro",74.599999999999994,111.7,85.2,163.19999999999999,152.6,71.2,133.69999999999999,265.89999999999998,72.2,311.60000000000002,88.6,8.6]
["Bergueda_UI_Gisclareny",119.1,145.9,124.9,184.8,220.7,132.30000000000001,106.8,192.8,108.9,321.39999999999998,97.1,12.7]
["Bergueda_WV_Guardiola de Bergueda",86.8,132.69999999999999,70.900000000000006,136.80000000000001,169.6,102.4,122.6,201.6,44.1,277.60000000000002,95.9,11.3]
["Bergueda_CR_laQuar",92.6,142.19999999999999,59.2,107.1,189.1,82.5,73.599999999999994,194.3,79.099999999999994,206.5,71.5,5.7]
["Bergueda_WM_Santuari de Queralt",95.9,151.80000000000001,86.8,105.3,128.5,89,57.4,172.6,71.599999999999994,241.7,86.2,8.8000000000000007]
["Cerdanya_z9_Cadí Nord (2.143 m) - Prat d'Aguiló",151.5,153.6,159.19999999999999,206.7,178,144.19999999999999,94.7,219.3,115.9,345.7,106.3,11.5]
["Cerdanya_DP_Das - Aerodrom",66.599999999999994,65.3,38,109.4,83.5,81.8,71.3,85.7,33.4,177.7,49.2,7.9]
["Cerdanya_Z3_Malniu (2.230 m)",146,157.4,89.8,107.3,142.5,115.4,133.5,142.80000000000001,99.9,204.8,71.900000000000006,15.8]
["Cerdanya_YA_Puigcerdil",69.7,80,43,104.6,107.7,37.4,75.2,75.3,44.6,141.6,39.9,9.1999999999999993]
["Conca de B._W8_Blancafort",22,68.900000000000006,65.400000000000006,103.1,93.5,16.7,5.3,27.7,23.2,246.9,117.9,8.1999999999999993]
["Conca de B._CW_l'Espluga de Francolí",33.299999999999997,94.5,48.8,186.6,108.6,13.6,3.6,35.700000000000003,9.3000000000000007,212.9,87,9.6]
["Conca de B._UJ_Santa Coloma de Queralt",46.8,67.099999999999994,84.3,81.7,71.599999999999994,54.4,5.9,42.4,10.1,206,63.4,5.8]
["Garraf_XU_Canyelles",43,139.6,62.6,75.5,21.7,56.4,6.6,67.900000000000006,74.8,222.4,84.1,4.5999999999999996]
["Garraf_UK_Sant Pere de Ribes - PN del Garraf",47.4,131,71.900000000000006,66.400000000000006,21.9,119.4,6.3,67.900000000000006,77.099999999999994,235.4,71.3,4.9000000000000004]
["Garrigues_UM_la Granadella",29.9,42,38.5,48.3,61.2,10.5,12,19.8,8.6999999999999993,145.69999999999999,98.3,9.6999999999999993]
["Garrigues_VD_les Borges Blanques",37.4,48.2,41.6,74.099999999999994,55.8,3,30.6,14.8,15.5,129.5,68.8,16]
["Garrotxa_W9_la Vall d'en Bas",66.900000000000006,152.4,44.2,161.9,140.19999999999999,69.5,99.3,65.400000000000006,85.2,230,156.80000000000001,7.5]
["Garrotxa_YB_Olot",53.8,137.9,45.8,160.5,139.1,83.4,62.5,64.5,67,209.5,130,6.8]
["Girones_UN_Cassa de la Selva",38.799999999999997,61.5,69.400000000000006,135.1,60.2,27.5,23.3,67.3,19,155.6,257.39999999999998,19.100000000000001]
["Girones_uo_Fornells de la Selva",32.4,75.3,49.9,100.4,78.8,42.1,70.5,107.1,7,278.3,141.1,13.2]
["Girones_XJ_Girona",33.5,78,44.9,133.9,93.8,39.799999999999997,94.7,100.3,37.4,214.1,135.4,13]
["Maresme_UP_Cabrils",73,71.400000000000006,63.5,75.7,88.5,50.2,33.799999999999997,73.099999999999994,78.099999999999994,216.2,97.9,2.1]
["Maresme_UQ_Dosrius - PN Montnegre Corredor",86.1,92.6,58.9,104.6,66.099999999999994,15.7,15.2,44.6,54,293.8,160.80000000000001,5]
["Maresme_WT_Malgrat de Mar",28,64.599999999999994,28.6,64.099999999999994,65.599999999999994,35,12,24.7,20.5,154,223.4,6.5]
["Montsia_US_Alcanar",14.5,51.2,18.100000000000001,38.299999999999997,28.2,66.8,9.8000000000000007,22.9,72.2,340.1,94.9,10.3]
["Montsia_UU_Amposta",7.8,49.7,15.8,40.5,35.4,15.8,11.9,23.7,67.5,198.6,91.6,6.2]
["Montsia_UW_els Alfacs",12.2,59,15.3,31.8,11.7,43.2,6.4,16.8,73.5,258,44,5.7]
["Montsia_DL_lila de Buda",15,89.4,13.5,15.5,18,26.5,10.7,36.700000000000003,83,158.1,47.9,4.5999999999999996]
["Montsia_C9_Mas de Barberans",12.6,48.8,22.5,61.7,41,46.1,38.4,20.100000000000001,81.599999999999994,298.5,226.5,7.6]
["Montsia_UX_Ulldecona - els Valentins",11.8,39.5,18.899999999999999,52.3,44.3,45,23.7,27.4,102.4,287.39999999999998,192.1,8.8000000000000007]
["Noguera_WB_Albesa",27.8,35.299999999999997,48.4,82.5,72.099999999999994,8.6,8.5,22.7,1.2,135.1,74.5,14.4]
["Noguera_WG_Algerri",31,35.1,48.2,78.599999999999994,83,9.6999999999999993,16.5,20.6,0.3,130.1,69.5,13.4]
["Noguera_X6_Baldomar",33.200000000000003,98.1,77.099999999999994,121.7,129.6,13,10.5,76.8,12.9,118.4,84.5,9.3000000000000007]
["Noguera_WX_Camarasa",33.299999999999997,75.400000000000006,63.7,117.5,138.80000000000001,20.399999999999999,7.9,31.7,7.2,168.6,70.8,11.5]
["Noguera_WA_Oliola",30.8,80.8,71.2,104.9,95,11.8,7.8,43.5,5.3,107.7,91.7,11.9]
["Noguera_UY_Os de Balaguer - el Monestir d'Avellanes",36.9,97.2,71.7,124.6,159.1,34.5,9.4,52.7,2.4,170.1,74.8,13.9]
["Noguera_V1_Vallfogona de Balaguer",29.4,56.6,55.4,105.1,101.7,13.3,4.4000000000000004,10.7,0.3,130.19999999999999,54.6,12.6]
["Noguera_CQ_Vilanova de Meia",45.7,158.80000000000001,113.9,166.6,194.5,66.8,18.399999999999999,117.9,13.6,152.19999999999999,107.5,7.7]
["Osona_V3_Gurb",63.8,106.2,39.6,82.2,152.30000000000001,87.3,54.9,249.8,68.3,201.2,78.8,8.4]
["Osona_V4_Montesquiu",82.2,131.1,44.5,119.6,154.5,84.8,87.9,201.5,82.9,226.2,89.2,6.1]
["Osona_CY_Muntanyola",80.8,125.2,66.599999999999994,110.8,135.4,57.9,41.8,112,10.8,246,83.6,6.9]
["Osona_ce_Orís",64.099999999999994,123.3,42.7,109.4,132,69.099999999999994,91.8,198.4,190.8,231.1,81.3,6.3]
["Osona_KE_Panta de Sau",56.9,108.5,31.4,93.1,141,41,79.599999999999994,142,51.9,222.7,103.3,8.4]
["Osona_V5_Perafita",73.599999999999994,92,45.6,131,89,65.2,92.8,156.30000000000001,57.1,180.8,69.599999999999994,7.9]
["Osona_xo_Vic",69.5,118.6,44.2,86.8,157.80000000000001,69.900000000000006,40.700000000000003,232,58.8,167.9,85.6,7.6]
["Osona_WS_Viladrau",91.4,187.1,81.7,185.7,144.4,56.3,45.1,122.1,17.399999999999999,430.7,200.2,10.3]
["Pallars Jussà_YC_la Pobla de Segur",28.4,85,86.2,144.1,124.5,76,23.3,86.9,52.6,148.80000000000001,88.7,10.199999999999999]
["Pallars Jussà_WQ_Montsec d'Ares (1.572 m)",54.3,104.9,123.7,157.30000000000001,149.80000000000001,110.9,10.8,70,57.2,170.7,86.3,10.199999999999999]
["Pallars Jussà_CP_Sant Roma d'Abella",41.2,80,68.099999999999994,114,131.80000000000001,116.3,15.4,66,27.2,131.69999999999999,81.7,7.1]
["Pallars Jussà_XQ_Tremp",33,90.6,79.400000000000006,115,121.4,57.3,16.3,64.5,56.6,122.6,69.400000000000006,15.4]
["Pallars Sobira_Z1_Bonaigua (2.266 m)",197.1,204.1,163.4,276.39999999999998,186.6,103.2,70.599999999999994,80.2,69,219.9,79.8,31.4]
["Pallars Sobira_Z5_Certascan (2.400 m)",229.4,295.39999999999998,157.30000000000001,118.2,298,133.80000000000001,61.6,119.1,93.8,157.1,81.099999999999994,61.9]
["Pallars Sobira_Z7_Espot (2.519 m)",160.19999999999999,193.5,289.7,322.3,177.9,91.4,113.2,295.89999999999998,109.5,229.1,124.6,24.7]
["Pallars Sobira_ZB_Salória (2.451 m)",143.1,115.6,152.6,167.3,120.5,61.1,82.8,150.1,41.6,234.6,113.7,13.6]
["Pallars Sobira_XH_Sort",47.4,67.900000000000006,81.900000000000006,113.8,114.9,79.8,83.1,112.2,74.3,107.6,68.099999999999994,10.1]
["Pla de l'Estany_DJ_Banyoles",56,79.099999999999994,27,139.6,112.3,93.3,49.4,77.900000000000006,57.1,240.4,231.6,12.5]
["Pla d'Urgell_C6_Castellnou de Seana",29.9,44.8,51.8,103.2,59.5,3.9,12.1,6.7,0.7,126.4,58.8,14]
["Pla d'Urgell_V8_el Poal",32,43.3,44.8,74.5,80.099999999999994,4.3,10,11.4,0.2,124.2,66.599999999999994,14.2]
["Pla d'Urgell_WC_Golmés",25.6,46.1,48.3,87,53.9,3.7,14.8,7.7,0.6,117.6,62,16.100000000000001]
["Pla d'Urgell_XI_Mollerussa",27.2,44,48.5,77.2,53.8,3,21.3,11.6,0.9,132.1,70.3,16.5]
["Priorat_WJ_el Masroig",15.5,41.1,33.299999999999997,55.4,92.1,1.9,7.2,15.5,3.6,178,59,7.3]
["Priorat_X1_Falset",21.7,87.9,41.6,88.1,131.6,2.2999999999999998,9.3000000000000007,43.7,12.8,243,137.9,7.9]
["Priorat_D1_Margalef",47.1,49.5,39.4,100.8,70.8,1.2,5.0999999999999996,18.100000000000001,28.6,194.1,82.7,8.3000000000000007]
["Priorat_MR_Panta de Siurana",28.2,78.8,52.7,106.6,116,17.5,6.8,36.4,65.400000000000006,230.9,80.099999999999994,6]
["Priorat_WR_Torroja del Priorat",25.8,61.4,45.4,85,97.2,38.200000000000003,17.8,15.8,18.8,185.8,101.5,6.6]
["Priorat_XD_Ulldemolins",44.9,60.7,66.599999999999994,108.7,137.5,22.3,10.1,31.9,58.4,224.3,75.8,8.6999999999999993]
["Ribera d'Ebre_VA_Aseó",35.6,37.9,32.1,82.3,100.6,2.4,8.8000000000000007,7.3,3.3,164.3,72.599999999999994,10.1]
["Ribera d'Ebre_VB_Benissanet",15.1,38.1,30.1,50,87,3.5,7.4,5.5,10.3,201.1,69.8,11.6]
["Ribera d'Ebre_ve_Panta de Riba-roja",26.9,31.7,23.8,55,52.3,5.9,11.4,4.0999999999999996,13.1,137.9,50.5,9.5]
["Ribera d'Ebre_Y6_Tivissa",20.100000000000001,69.2,40,73.3,165.9,2.8,11.2,83.7,26.7,257.39999999999998,97,12]
["Ribera d'Ebre_D7_Vinebre",24,42.8,26,74.2,71.599999999999994,2.1,9.6999999999999993,16.2,4.7,149,67.599999999999994,7.9]
["Ripolles_CG_Molió- Fabert",86.4,122.8,61.8,192.9,102.2,110.6,134.69999999999999,169.2,125.8,350.4,134.1,7.3]
["Ripolles_DG_Núria (1.971 m)",110.5,150.19999999999999,127.1,193.4,174.6,62.1,75.599999999999994,133.6,56.6,369.1,121.6,14.2]
["Ripolles_M6_Sant Joan de les Abadesses",62.6,123,43.2,109.5,126.1,72.599999999999994,153.69999999999999,180.1,88.3,275.89999999999998,94.9,6]
["Ripolles_CI_Sant Pau de Segúries",87.1,144.6,54.1,173.7,159.6,114.1,97.6,114.7,165.3,321.89999999999998,151.69999999999999,4.8]
["Ripolles_zc_Ulldeter (2.41O m)",154.80000000000001,168.2,150.1,191.7,171.1,53.8,104.2,113.9,61.2,309.5,73.099999999999994,18]
["Segarra_C8_Cervera",31.6,28.4,68.900000000000006,51,100,33,7.1,35.700000000000003,42.1,123.9,60.3,7.3]
["Segarra_VD_el Canós",28.9,32,57.6,72,82.2,13.7,16.2,34.5,12.8,104.9,71.099999999999994,9.8000000000000007]
["Segarra_YE_Massoteres",44.9,52.5,75.099999999999994,77,122.6,31.5,6.4,28.7,18.899999999999999,137.4,81.599999999999994,12]
["Segria_VE_Aitona",23.4,37.1,32.200000000000003,61,58.6,5.5,21.7,4.2,2.2000000000000002,109.1,52.1,12.9]
["Segria_XY_Alcarras",26.5,44.9,36.9,83.7,66.7,28.1,36.4,18.899999999999999,13.3,135.80000000000001,81.400000000000006,16.3]
["Segria_WK_Alfarras",29.9,43.2,54.3,97.7,71.099999999999994,28.2,8.6,51.8,0.9,136,63.5,17.3]
["Segria_X3_Alguaire",25.5,32.1,51.6,86.4,67,7.4,12.1,46.6,1.6,141,65.2,16.2]
["Segria_XM_els Alamús",33.299999999999997,38,46.3,64.8,61.8,3.9,19.3,34.9,3,129.80000000000001,68,17.2]
["Segria_VH_Gimenells",22.9,22.3,32.200000000000003,78.599999999999994,60,12.8,23,33.700000000000003,19.3,98.8,44.2,13.1]
["Segria_WI_Maials",27.1,45.1,41,85.1,38.299999999999997,9.8000000000000007,33.5,6.9,3.3,114.5,62,11.7]
["Segria_VK_Raimat",21.3,27.3,43.9,91.4,48.3,16.5,27.8,23,6.9,108.8,55.4,14.4]
["Segria_XN_Seros",26.7,39,31.2,58.9,48.9,6.1,14.5,6.9,1.5,102.7,44.9,10.5]
["Segria_X7_Torres de Segre",18.100000000000001,34.200000000000003,26.5,66.900000000000006,42,5.3,30.2,7.5,32.5,91.5,53.6,13.5]
["Segria_VM_Vilanova de Segria",22.5,35.4,36.700000000000003,79.3,60.8,10.4,15.6,51.7,3.3,134.4,61.9,16.5]
["Selva_DN_Angles",32.4,133.80000000000001,50.7,142.9,163.19999999999999,76,80.2,70,33.4,309,188.1,8.3000000000000007]
["Selva_KP_Fogars de la Selva",40.200000000000003,98,44.3,80.2,75,37.299999999999997,53.8,59.7,53.6,241.7,232.4,10.7]
["Selva_xs_Santa Coloma de Farners",32.799999999999997,108.2,65.400000000000006,95.7,104.5,45.2,79.7,72.8,10.199999999999999,270.7,161.9,9.6999999999999993]
["Selva_VN_Vilobí d'Onyar",35.9,95.3,64,100.2,80.599999999999994,22.7,39.6,49.8,5.7,200.4,168.6,9.6999999999999993]
["Solsones_Z8_el Port del Comte (2.316 m)",67.8,138.30000000000001,189.2,176.3,201.9,137.19999999999999,40.299999999999997,209.2,78.8,258.89999999999998,132.30000000000001,25.7]
["Solsones_MV_Guixers - Valls",95.9,120,105.7,119.5,147.4,74.8,30.1,136.80000000000001,36.299999999999997,238.7,75.7,8.5]
["Solsones_vo_Lladurs",56.1,89.9,86,106.6,136.30000000000001,98.6,16.8,98.2,38.799999999999997,191.3,96.7,10.4]
["Solsones_MW_Naves",84.6,108,71,103.8,123,32.799999999999997,47,111.2,25.9,167.9,82.7,8.6]
["Solsones_VP_Pinós",84.8,89.8,65.099999999999994,99.5,78.599999999999994,86.4,28.3,47.3,24.7,184.7,100.7,8.6999999999999993]
["Solsones_XT_Solsona",75.5,97.2,85,98.5,111.9,35.4,29.6,62.4,50.8,241.4,108.7,6.1]
["Tarragones_VQ_Constantí",13.5,94.2,28.3,67.3,40.1,6.9,4.7,94.6,87.3,336.5,67.099999999999994,7.9]
["Tarragones_XE_Tarragona - Complex Educatiu",18.100000000000001,83.1,22.4,45.6,3,9.3000000000000007,2,77.5,44.1,386.5,66,5.2]
["Tarragones_DK_Torredembarra",17.899999999999999,102.3,40.799999999999997,45.5,9.3000000000000007,13.6,5.6,120.6,74.099999999999994,200,42.2,5.8]
["Terra Alta_WD_Batea",39.4,36.4,32,67.5,60,11.2,26.4,1.5,20.3,166.9,63.5,12.3]
["Terra Alta_XP_Gandesa",26.2,46.6,33.200000000000003,64.3,48,12,11,8.6,7.7,161.30000000000001,71.099999999999994,11.4]
["Terra Alta_D8_Horta de Sant Joan",114.1,43,37.799999999999997,79.099999999999994,62.8,16.3,29.6,6.9,2.2000000000000002,231.1,80.7,12.4]
["Urgell_WL_Sant Martí de Riucorb",26.1,28.1,55,88.1,41.5,14.6,13.4,3.8,4.8,123.9,51.9,12.8]
["Urgell_C7_Tarrega",30.1,34.5,70.3,79.599999999999994,82.1,21.6,16.899999999999999,19,14.9,103.5,65.8,13.5]
["Urgell_XX_Tornabous",26.7,34.6,59.5,86.1,45.9,8.4,10,7.1,6,108.7,62.1,12.5]
["Val d'Aran_vs_Lac Redan (2.247 m)",197,351.4,191.4,107.6,255.9,104.7,93,125.9,93.1,192,86.7,83.8]
["Val d'Aran_Z6_ Sasseuva (2.228 m)",133.1,206.1,123.9,92.4,188.9,82.7,141.69999999999999,31.9,47.9,116.5,51.9,44.8]
["Val d'Aran_cu_Vielha",123,192.3,112.7,160.30000000000001,155.4,83.9,58.7,96.8,67.8,116.1,43,37.1]
["Valles Occ._XC_Castellbisbal",86.3,106.4,100,85.5,27.8,98.2,41.4,75.2,70.400000000000006,150.30000000000001,228.4,2.8]
["Valles Occ._vu_Rellinars",81.099999999999994,101.6,83.9,113.9,78.7,80.400000000000006,29.7,41.5,28.7,178.3,129.80000000000001,5.0999999999999996]
["Valles Occ._XF_Sabadell - Pare Agrari",72.7,85.5,86.1,91.2,44.9,70.5,37.6,77.5,39.4,154.6,156.19999999999999,3.2]
["Valles Occ._XV_Sant Cugat del Valles - CAR",70.400000000000006,89,89,77.400000000000006,44.2,61.4,24.6,35.1,31.3,174.5,158.19999999999999,3.8]
["Valles Occ._vv_Sant Llorenç Savall",99.7,109.2,107.7,132.80000000000001,136.9,63.1,22.1,39.799999999999997,21.6,210.6,139.30000000000001,5.8]
["Valles Occ._D2_Vacarisses",67.3,106.8,85.4,101.9,76,89.5,28.5,40.1,58.3,157,159,2.4]
["Valles Oriental_X9_Caldes de Montbui",73.8,91.1,74.599999999999994,77.099999999999994,52.4,43.6,18.5,26.2,41.5,142.30000000000001,106.3,6.9]
["Valles Oriental_KX_la Roca del Valles - ETAP Cardedeu",77.8,76.099999999999994,65.2,128.4,75.5,23.7,40,26.4,73.400000000000006,227.4,125.3,4.5999999999999996]
["Valles Oriental_XG_Parets del Valles",75.2,77.2,84.3,68.5,37,109.4,10.1,23.1,31.7,146.80000000000001,102.9,4.5999999999999996]
["Valles Oriental_XK_Puig Sesolles (1.668m)",87.9,122.9,122.7,160.9,147.4,74.599999999999994,57.5,96.7,22.8,378.6,190.3,5.0999999999999996]
["Valles Oriental_VX_Tagamanent - PN del Montseny",87.8,102.9,80.400000000000006,153.1,121,35.200000000000003,13.5,81.5,3.8,253.1,110.8,5.7]
["Valles Oriental_WE_Vilanova del Valles",99.7,79.7,94.5,88.4,75.7,20.399999999999999,14.1,22.6,28.3,219.7,181.5,8.9]

{"sheet":"Pluviometres_CAT","index":6,"n_rows":184,"n_cols":17,"rows_kept":184,"cut":false,"hidden":true,"merged":[]}
["COMARCA","CODI","Població","Nom per llista","GEN","FEB","MAR","ABR","MAi","JUN","JUL","AGO","SET","OCT","NOV","DES","ANY"]
["AltCamp","VY","Nulles","AltCamp_VY_Nulles",16.7,85.6,32.6,80.5,35.700000000000003,22.2,2.5,42.2,37.1,220.5,48.3,7.7,631.6]
["AltCamp","DQ","Vila-rodona","AltCamp_DQ_Vila-rodona",23.5,72.2,45.2,90.4,81.099999999999994,40.4,4.2,41.8,38.4,198.3,51.8,6.5,693.8]
["Alt Emporda","U1","Cabanes","Alt Emporda_U1_Cabanes",24.4,67.7,41.6,132.80000000000001,54.7,56,11.9,18.100000000000001,25.8,251.7,162,18.2,864.9]
["Alt Emporda","W1","Castelló d'Empúries","Alt Emporda_W1_Castelló d'Empúries",19.8,43.5,44.1,74.5,57.1,32.4,12.4,29.6,4.0999999999999996,202.2,125.9,12.7,658.3]
["Alt Emporda","vz","Espolia","Alt Emporda_vz_Espolia",53.6,46.5,41.9,109.8,82.1,59.7,21.4,31.6,17.7,190.4,177.4,15,847.1]
["Alt Emporda","Y5","Navata","Alt Emporda_Y5_Navata",38.9,87.1,31.9,128.9,110.5,97.3,35.1,22.8,36.4,209.1,265.5,15.1,1078.5999999999999]
["Alt Emporda","J5","Panta de Darnius - Boadella","Alt Emporda_J5_Panta de Darnius - Boadella",57,81.099999999999994,40.799999999999997,152.5,102.9,68.3,39.299999999999997,27.7,34.700000000000003,297.89999999999998,272.8,16.3,1191.3]
["Alt Emporda","D6","Portbou","Alt Emporda_D6_Portbou",17.7,58.7,68.900000000000006,75.599999999999994,24.1,28,40.200000000000003,60.8,24.2,231.8,64.5,29.8,724.3]
["Alt Emporda","D4","Roses","Alt Emporda_D4_Roses",21.8,44.3,48.9,63.3,33.1,25.2,22.4,70.7,2.2999999999999998,222.1,81.3,20.5,655.9]
["Alt Emporda","U2"," Sant Pere Pescador","Alt Emporda_U2_ Sant Pere Pescador",25.6,61.1,40.299999999999997,79.599999999999994,44.5,45.5,38.200000000000003,49.2,8.6,211.5,112.6,21.7,738.4]
["Alt Emporda","xz","Torroella de Fluvia","Alt Emporda_xz_Torroella de Fluvia",34,67.8,43.4,71.599999999999994,62.9,46.6,38.5,18,6.3,191.3,114.5,20.2,715.1]
["Alt Penedes","WP","Canaletes","Alt Penedes_WP_Canaletes",63.3,117.8,72.8,90.3,96.3,55.3,11.2,25.6,41.9,185.8,72.599999999999994,2.5,835.4]
["Alt Penedes","DI","Font-rubí","Alt Penedes_DI_Font-rubí",63.4,121.3,65.900000000000006,110.3,88.9,36.299999999999997,0.9,26.2,36.4,222.8,61.8,4.8,839]
["Alt Penedes","W4","la Granada","Alt Penedes_W4_la Granada",61.5,130.6,60.9,88.7,48.4,47.1,13.9,46.9,31.2,214.2,94,3.6,841]
["Alt Penedes","U3","Sant Martí Sarroca","Alt Penedes_U3_Sant Martí Sarroca",57,130.1,48.3,83.7,39.700000000000003,29.7,9.4,48,38.700000000000003,252,60.7,4.5,801.8]
["Alt Penedes","WY","Sant Sadurní d'Anoia","Alt Penedes_WY_Sant Sadurní d'Anoia",50.3,96.1,70.3,82.7,82.5,47,10.8,49.8,67.900000000000006,181,92,3.3,833.7]
["Alt Urgell","Y4"," Alinya","Alt Urgell_Y4_ Alinya",91.7,131.5,129.69999999999999,132.9,169,95.8,26.8,119.9,43,250.6,84.5,6.6,1282]
["Alt Urgell","CD","la Seu d'Urgell - Bellestar","Alt Urgell_CD_la Seu d'Urgell - Bellestar",58.9,73.7,55.4,96.7,143.69999999999999,40.799999999999997,51,33.799999999999997,63,125.7,52,6,800.7]
["Alt Urgell","W5","Oliana","Alt Urgell_W5_Oliana",56.4,137.5,109.1,140.5,161.6,52.9,21.7,74.7,25.5,169.5,90.5,10.3,1050.2]
["Alt Urgell","CJ","Organya","Alt Urgell_CJ_Organya",66.5,90.3,82,107.1,185.4,112.9,15.3,78.400000000000006,84.6,155.5,65.5,6.8,1050.3]
["Alta Ribagorça","Z2","Boí (2.535 m)","Alta Ribagorça_Z2_Boí (2.535 m)",113.6,183,229.8,254.9,179.9,104.3,42.5,148.69999999999999,212.3,181,99,8.4,1757.4]
["Alta Ribagorça","CT","el Pont de Suert","Alta Ribagorça_CT_el Pont de Suert",46.4,103.7,130.69999999999999,231.2,202.7,88.7,44.6,64.900000000000006,112.5,145.19999999999999,91.3,12.8,1274.7]
["Anoia","CE","els Hostalets de Pierola","Anoia_CE_els Hostalets de Pierola",69.099999999999994,87.3,56.3,92.7,79,94.7,7.3,27.6,76,187.2,108.5,2.2999999999999998,888]
["Anoia","XB","la Llacuna","Anoia_XB_la Llacuna",53.2,129.80000000000001,63.1,129,123.6,63.3,2.7,19.3,33.299999999999997,263.5,79.3,3.8,963.9]
["Anoia","XA","la Panadella","Anoia_XA_la Panadella",42.4,60.6,59.5,88.7,66.8,44,27.3,98.2,38.299999999999997,196.2,63.6,5.8,791.4]
["Anoia","H1"," ódena","Anoia_H1_ ódena",65.3,100.5,45.6,78.8,68.599999999999994,82.5,13.9,91.5,41.2,191.8,74.599999999999994,4.3,858.6]
["Bages","WW","Artés","Bages_WW_Artés",85.7,85.9,67.400000000000006,70.5,194.7,84.6,12.4,93.1,9.6,181.2,88,5.4,978.5]
["Bages","MQ","Cardona","Bages_MQ_Cardona",76.8,84.9,59.6,84,71.7,37,71.400000000000006,64.900000000000006,42,170.2,88,6.1,856.6]
["Bages","U4"," Castellnou de Bages","Bages_U4_ Castellnou de Bages",83.8,88,54.1,66.099999999999994,113.6,98,29.8,80.599999999999994,24,172.6,89.6,7,907.2]
["Bages","R1","el Pont de Vilomara","Bages_R1_el Pont de Vilomara",68.2,87.8,63.2,84.6,183.7,57.4,10.4,20.5,17.5,162,116.1,4,875.4]
["Bages","WN","Montserrat - Sant Dimes","Bages_WN_Montserrat - Sant Dimes",80.3,80.400000000000006,67.2,106.3,124.8,69.8,26.4,44.2,56.9,171.8,145.69999999999999,3.6,977.4]
["Bages","CL","Sant Salvador de Guardiola","Bages_CL_Sant Salvador de Guardiola",84,110.1,58.4,90.1,118.6,43.2,20.9,34.200000000000003,52,194.7,129.30000000000001,3.1,938.6]
["Baix Camp","YF","Mont-roig del Camp","Baix Camp_YF_Mont-roig del Camp",10.8,116.6,22.5,61,15.2,17.8,6.9,27.4,71.599999999999994,197.1,70.400000000000006,3.9,621.20000000000005]
["Baix Camp","XR","Prades","Baix Camp_XR_Prades",52.4,100.7,67.599999999999994,155.6,127.4,17.5,5.7,25.6,46.7,314.39999999999998,93.1,14,1020.7]
["Baix Camp","W6","Riudoms","Baix Camp_W6_Riudoms",16.5,101.4,32.5,64.8,55.8,10.7,5.2,102.2,26.2,287.8,69.7,4.9000000000000004,777.7]
["Baix Camp","U6"," Vinyolsi els Ares","Baix Camp_U6_ Vinyolsi els Ares",12,88.3,19.7,62.3,19.8,9.3000000000000007,5.2,100.1,29.8,275.60000000000002,55.3,5.0999999999999996,682.5]
["Baix Ebre","U7","Aldover","Baix Ebre_U7_Aldover",9.8000000000000007,42.4,25.8,58.8,25.2,7.3,35.200000000000003,91.6,42.5,234.6,115.4,8.1999999999999993,696.8]
["Baix Ebre","DB","el Perelló","Baix Ebre_DB_el Perelló",11.8,59.1,18.3,45.3,52.1,3.5,18.7,21.3,41.9,190.2,59,6.2,527.4]
["Baix Ebre","U9","l'Aldea","Baix Ebre_U9_l'Aldea",10.7,53.5,22.4,39.799999999999997,106.5,9.1,14.1,15,28.5,226.8,164.7,8,699.1]
["Baix Ebre","UA","l'Amet llade Mar","Baix Ebre_UA_l'Amet llade Mar",9.6,68.900000000000006,27,44.3,50,5.5,12.8,14.9,61.5,220.3,52.8,7.5,575.1]
["Baix Ebre","X5","PN deis Ports","Baix Ebre_X5_PN deis Ports",71.400000000000006,67.7,45,158.1,89.1,51.8,51.3,50.7,82.9,462.4,301.10000000000002,51,1482.5]
["Baix Emporda","DO","Castell d'Aro","Baix Emporda_DO_Castell d'Aro",24.8,64.599999999999994,38.4,118.2,55.1,47.7,22.6,18.5,3.5,221.9,149.19999999999999,11.6,776.1]
["Baix Emporda","DF","la Bisbal d'Emporda","Baix Emporda_DF_la Bisbal d'Emporda",35.200000000000003,77,47,129.1,61.4,10.7,51.2,17.2,5.6,189.7,327.3,15,966.4]
["Baix Emporda","UB","la Tallada d'Emporda","Baix Emporda_UB_la Tallada d'Emporda",25.5,72.3,52.6,86.4,46.4,17.899999999999999,47.8,23.4,16.899999999999999,158.9,232.9,14.7,795.7]
["Baix Emporda","uc","Monells","Baix Emporda_uc_Monells",31.2,72.3,44.1,114.3,46.6,28.7,60,27.2,11,161,293.7,15.4,905.5]
["Baix Emporda","UE","Torroella de Montgrí","Baix Emporda_UE_Torroella de Montgrí",50,71.599999999999994,61.8,71.5,53.6,24.7,46.2,15.6,15,161.6,56.6,27.2,655.4]
["Baix Llobregat","XL","el Pral de Llobregat","Baix Llobregat_XL_el Pral de Llobregat",52.2,117,89.8,53.2,36.9,37.200000000000003,9.4,85,87.1,171.1,132.5,4.4000000000000004,875.8]
["Baix Llobregat","UF","PN del Garraf - el Rascler","Baix Llobregat_UF_PN del Garraf - el Rascler",46.9,154,64.900000000000006,47.6,25.9,73.2,6,60.5,115.6,173.7,96.3,7,871.6]
["Baix Llobregat","Y9","Port de Barcelona - ZAL Prat","Baix Llobregat_Y9_Port de Barcelona - ZAL Prat",48.2,96.4,74.2,39,36.1,32.6,19,85.4,82.3,184.6,97.5,4.5,799.8]
["Baix Llobregat","D3","Vallirana","Baix Llobregat_D3_Vallirana",101.5,169.2,93.9,83.7,31.6,99.1,20.2,123.7,56.9,180.1,174.2,3.8,1137.9000000000001]
["Baix Llobregat","UG","Viladecans","Baix Llobregat_UG_Viladecans",48.6,139.19999999999999,63.2,41.3,41.4,43.2,5.9,83.5,47.5,145.80000000000001,176.9,4.0999999999999996,840.6]
["Baix Penedés","WZ","Cunit","Baix Penedés_WZ_Cunit",43.5,125.2,44.1,41.1,14.3,42.9,2.4,113.5,108.3,250.8,69.599999999999994,3.9,859.6]
["Baix Penedés","UH","el Montmell","Baix Penedés_UH_el Montmell",36.200000000000003,118.1,73.900000000000006,103.6,67.900000000000006,38.5,1.9,76.3,34.5,328.6,70.2,6.1,955.8]
["Baix Penedés","D9","el Vendrell","Baix Penedés_D9_el Vendrell",26.7,111.2,42.5,66.599999999999994,19.2,32.799999999999997,28.4,89.9,96.8,239.8,71.900000000000006,4.2,830]
["Baix Penedés","WO","la Bisbal del Penedés","Baix Penedés_WO_la Bisbal del Penedés",19.2,98.6,45.1,76.099999999999994,21.7,47.8,9,60.5,65.599999999999994,247.8,59.6,4.5,755.5]
["Barcelonés","WU","Badalona - Museu","Barcelonés_WU_Badalona - Museu",71.7,82.7,75.8,34.1,40.799999999999997,34,57.1,30.9,116.2,151.19999999999999,108.6,3.3,806.4]
["Barcelonés","X4","Barcelona - el Raval","Barcelonés_X4_Barcelona - el Raval",55.4,89.6,79.099999999999994,48.6,87.6,12.9,24.7,96.2,154.80000000000001,187.9,168.8,4.5999999999999996,1010.2]
["Barcelonés","D5","Barcelona - Observatori Fabra","Barcelonés_D5_Barcelona - Observatori Fabra",62.5,104,113.5,58.6,53.6,52.7,51.4,36.200000000000003,43.6,195.6,207.6,4.9000000000000004,984.2]
["Barcelonés","X8","Barcelona - Zona Universitaria","Barcelonés_X8_Barcelona - Zona Universitaria",55.6,108.7,104.3,53.8,41.8,52.5,12.4,47.3,93.9,217.1,128,4.4000000000000004,919.8]
["Bergueda","MS","Castellar de n'Hug - el Clot del Moro","Bergueda_MS_Castellar de n'Hug - el Clot del Moro",74.599999999999994,111.7,85.2,163.19999999999999,152.6,71.2,133.69999999999999,265.89999999999998,72.2,311.60000000000002,88.6,8.6,1539.1]
["Bergueda","UI","Gisclareny","Bergueda_UI_Gisclareny",119.1,145.9,124.9,184.8,220.7,132.30000000000001,106.8,192.8,108.9,321.39999999999998,97.1,12.7,1767.4]
["Bergueda","WV","Guardiola de Bergueda","Bergueda_WV_Guardiola de Bergueda",86.8,132.69999999999999,70.900000000000006,136.80000000000001,169.6,102.4,122.6,201.6,44.1,277.60000000000002,95.9,11.3,1452.3]
["Bergueda","CR","laQuar","Bergueda_CR_laQuar",92.6,142.19999999999999,59.2,107.1,189.1,82.5,73.599999999999994,194.3,79.099999999999994,206.5,71.5,5.7,1303.4000000000001]
["Bergueda","WM","Santuari de Queralt","Bergueda_WM_Santuari de Queralt",95.9,151.80000000000001,86.8,105.3,128.5,89,57.4,172.6,71.599999999999994,241.7,86.2,8.8000000000000007,1295.5999999999999]
["Cerdanya","z9","Cadí Nord (2.143 m) - Prat d'Aguiló","Cerdanya_z9_Cadí Nord (2.143 m) - Prat d'Aguiló",151.5,153.6,159.19999999999999,206.7,178,144.19999999999999,94.7,219.3,115.9,345.7,106.3,11.5,1886.6]
["Cerdanya","DP","Das - Aerodrom","Cerdanya_DP_Das - Aerodrom",66.599999999999994,65.3,38,109.4,83.5,81.8,71.3,85.7,33.4,177.7,49.2,7.9,869.8]
["Cerdanya","Z3","Malniu (2.230 m)","Cerdanya_Z3_Malniu (2.230 m)",146,157.4,89.8,107.3,142.5,115.4,133.5,142.80000000000001,99.9,204.8,71.900000000000006,15.8,1427.1]
["Cerdanya","YA","Puigcerdil","Cerdanya_YA_Puigcerdil",69.7,80,43,104.6,107.7,37.4,75.2,75.3,44.6,141.6,39.9,9.1999999999999993,828.2]
["Conca de B.","W8","Blancafort","Conca de B._W8_Blancafort",22,68.900000000000006,65.400000000000006,103.1,93.5,16.7,5.3,27.7,23.2,246.9,117.9,8.1999999999999993,798.8]
["Conca de B.","CW","l'Espluga de Francolí","Conca de B._CW_l'Espluga de Francolí",33.299999999999997,94.5,48.8,186.6,108.6,13.6,3.6,35.700000000000003,9.3000000000000007,212.9,87,9.6,843.5]
["Conca de B.","UJ","Santa Coloma de Queralt","Conca de B._UJ_Santa Coloma de Queralt",46.8,67.099999999999994,84.3,81.7,71.599999999999994,54.4,5.9,42.4,10.1,206,63.4,5.8,739.5]
["Garraf","XU","Canyelles","Garraf_XU_Canyelles",43,139.6,62.6,75.5,21.7,56.4,6.6,67.900000000000006,74.8,222.4,84.1,4.5999999999999996,859.2]
["Garraf","UK","Sant Pere de Ribes - PN del Garraf","Garraf_UK_Sant Pere de Ribes - PN del Garraf",47.4,131,71.900000000000006,66.400000000000006,21.9,119.4,6.3,67.900000000000006,77.099999999999994,235.4,71.3,4.9000000000000004,920.9]
["Garrigues","UM","la Granadella","Garrigues_UM_la Granadella",29.9,42,38.5,48.3,61.2,10.5,12,19.8,8.6999999999999993,145.69999999999999,98.3,9.6999999999999993,524.6]
["Garrigues","VD","les Borges Blanques","Garrigues_VD_les Borges Blanques",37.4,48.2,41.6,74.099999999999994,55.8,3,30.6,14.8,15.5,129.5,68.8,16,535.29999999999995]
["Garrotxa","W9","la Vall d'en Bas","Garrotxa_W9_la Vall d'en Bas",66.900000000000006,152.4,44.2,161.9,140.19999999999999,69.5,99.3,65.400000000000006,85.2,230,156.80000000000001,7.5,1279.3]
["Garrotxa","YB","Olot","Garrotxa_YB_Olot",53.8,137.9,45.8,160.5,139.1,83.4,62.5,64.5,67,209.5,130,6.8,1160.8]
["Girones","UN","Cassa de la Selva","Girones_UN_Cassa de la Selva",38.799999999999997,61.5,69.400000000000006,135.1,60.2,27.5,23.3,67.3,19,155.6,257.39999999999998,19.100000000000001,934.2]
["Girones","uo","Fornells de la Selva","Girones_uo_Fornells de la Selva",32.4,75.3,49.9,100.4,78.8,42.1,70.5,107.1,7,278.3,141.1,13.2,996.1]
["Girones","XJ","Girona","Girones_XJ_Girona",33.5,78,44.9,133.9,93.8,39.799999999999997,94.7,100.3,37.4,214.1,135.4,13,1018.8]
["Maresme","UP","Cabrils","Maresme_UP_Cabrils",73,71.400000000000006,63.5,75.7,88.5,50.2,33.799999999999997,73.099999999999994,78.099999999999994,216.2,97.9,2.1,923.5]
["Maresme","UQ","Dosrius - PN Montnegre Corredor","Maresme_UQ_Dosrius - PN Montnegre Corredor",86.1,92.6,58.9,104.6,66.099999999999994,15.7,15.2,44.6,54,293.8,160.80000000000001,5,997.4]
["Maresme","WT","Malgrat de Mar","Maresme_WT_Malgrat de Mar",28,64.599999999999994,28.6,64.099999999999994,65.599999999999994,35,12,24.7,20.5,154,223.4,6.5,727]
["Montsia","US","Alcanar","Montsia_US_Alcanar",14.5,51.2,18.100000000000001,38.299999999999997,28.2,66.8,9.8000000000000007,22.9,72.2,340.1,94.9,10.3,767.3]
["Montsia","UU","Amposta","Montsia_UU_Amposta",7.8,49.7,15.8,40.5,35.4,15.8,11.9,23.7,67.5,198.6,91.6,6.2,564.5]
["Montsia","UW","els Alfacs","Montsia_UW_els Alfacs",12.2,59,15.3,31.8,11.7,43.2,6.4,16.8,73.5,258,44,5.7,577.6]
["Montsia","DL","lila de Buda","Montsia_DL_lila de Buda",15,89.4,13.5,15.5,18,26.5,10.7,36.700000000000003,83,158.1,47.9,4.5999999999999996,518.9]
["Montsia","C9","Mas de Barberans","Montsia_C9_Mas de Barberans",12.6,48.8,22.5,61.7,41,46.1,38.4,20.100000000000001,81.599999999999994,298.5,226.5,7.6,905.4]
["Montsia","UX","Ulldecona - els Valentins","Montsia_UX_Ulldecona - els Valentins",11.8,39.5,18.899999999999999,52.3,44.3,45,23.7,27.4,102.4,287.39999999999998,192.1,8.8000000000000007,853.6]
["Noguera","WB","Albesa","Noguera_WB_Albesa",27.8,35.299999999999997,48.4,82.5,72.099999999999994,8.6,8.5,22.7,1.2,135.1,74.5,14.4,531.1]
["Noguera","WG","Algerri","Noguera_WG_Algerri",31,35.1,48.2,78.599999999999994,83,9.6999999999999993,16.5,20.6,0.3,130.1,69.5,13.4,536]
["Noguera","X6","Baldomar","Noguera_X6_Baldomar",33.200000000000003,98.1,77.099999999999994,121.7,129.6,13,10.5,76.8,12.9,118.4,84.5,9.3000000000000007,785.1]
["Noguera","WX","Camarasa","Noguera_WX_Camarasa",33.299999999999997,75.400000000000006,63.7,117.5,138.80000000000001,20.399999999999999,7.9,31.7,7.2,168.6,70.8,11.5,746.8]
["Noguera","WA","Oliola","Noguera_WA_Oliola",30.8,80.8,71.2,104.9,95,11.8,7.8,43.5,5.3,107.7,91.7,11.9,662.4]
["Noguera","UY","Os de Balaguer - el Monestir d'Avellanes","Noguera_UY_Os de Balaguer - el Monestir d'Avellanes",36.9,97.2,71.7,124.6,159.1,34.5,9.4,52.7,2.4,170.1,74.8,13.9,847.3]
["Noguera","V1","Vallfogona de Balaguer","Noguera_V1_Vallfogona de Balaguer",29.4,56.6,55.4,105.1,101.7,13.3,4.4000000000000004,10.7,0.3,130.19999999999999,54.6,12.6,574.29999999999995]
["Noguera","CQ","Vilanova de Meia","Noguera_CQ_Vilanova de Meia",45.7,158.80000000000001,113.9,166.6,194.5,66.8,18.399999999999999,117.9,13.6,152.19999999999999,107.5,7.7,1163.5999999999999]
["Osona","V3","Gurb","Osona_V3_Gurb",63.8,106.2,39.6,82.2,152.30000000000001,87.3,54.9,249.8,68.3,201.2,78.8,8.4,1192.8]
["Osona","V4","Montesquiu","Osona_V4_Montesquiu",82.2,131.1,44.5,119.6,154.5,84.8,87.9,201.5,82.9,226.2,89.2,6.1,1310.5]
["Osona","CY","Muntanyola","Osona_CY_Muntanyola",80.8,125.2,66.599999999999994,110.8,135.4,57.9,41.8,112,10.8,246,83.6,6.9,1077.8]
["Osona","ce","Orís","Osona_ce_Orís",64.099999999999994,123.3,42.7,109.4,132,69.099999999999994,91.8,198.4,190.8,231.1,81.3,6.3,1340.3]
["Osona","KE","Panta de Sau","Osona_KE_Panta de Sau",56.9,108.5,31.4,93.1,141,41,79.599999999999994,142,51.9,222.7,103.3,8.4,1079.8]
["Osona","V5","Perafita","Osona_V5_Perafita",73.599999999999994,92,45.6,131,89,65.2,92.8,156.30000000000001,57.1,180.8,69.599999999999994,7.9,1060.9000000000001]
["Osona","xo","Vic","Osona_xo_Vic",69.5,118.6,44.2,86.8,157.80000000000001,69.900000000000006,40.700000000000003,232,58.8,167.9,85.6,7.6,1139.4000000000001]
["Osona","WS","Viladrau","Osona_WS_Viladrau",91.4,187.1,81.7,185.7,144.4,56.3,45.1,122.1,17.399999999999999,430.7,200.2,10.3,1572.4]
["Pallars Jussà","YC","la Pobla de Segur","Pallars Jussà_YC_la Pobla de Segur",28.4,85,86.2,144.1,124.5,76,23.3,86.9,52.6,148.80000000000001,88.7,10.199999999999999,954.7]
["Pallars Jussà","WQ","Montsec d'Ares (1.572 m)","Pallars Jussà_WQ_Montsec d'Ares (1.572 m)",54.3,104.9,123.7,157.30000000000001,149.80000000000001,110.9,10.8,70,57.2,170.7,86.3,10.199999999999999,1106.0999999999999]
["Pallars Jussà","CP","Sant Roma d'Abella","Pallars Jussà_CP_Sant Roma d'Abella",41.2,80,68.099999999999994,114,131.80000000000001,116.3,15.4,66,27.2,131.69999999999999,81.7,7.1,880.5]
["Pallars Jussà","XQ","Tremp","Pallars Jussà_XQ_Tremp",33,90.6,79.400000000000006,115,121.4,57.3,16.3,64.5,56.6,122.6,69.400000000000006,15.4,841.5]
["Pallars Sobira","Z1","Bonaigua (2.266 m)","Pallars Sobira_Z1_Bonaigua (2.266 m)",197.1,204.1,163.4,276.39999999999998,186.6,103.2,70.599999999999994,80.2,69,219.9,79.8,31.4,1681.7]
["Pallars Sobira","Z5","Certascan (2.400 m)","Pallars Sobira_Z5_Certascan (2.400 m)",229.4,295.39999999999998,157.30000000000001,118.2,298,133.80000000000001,61.6,119.1,93.8,157.1,81.099999999999994,61.9,1806.7]
["Pallars Sobira","Z7","Espot (2.519 m)","Pallars Sobira_Z7_Espot (2.519 m)",160.19999999999999,193.5,289.7,322.3,177.9,91.4,113.2,295.89999999999998,109.5,229.1,124.6,24.7,2132]
["Pallars Sobira","ZB","Salória (2.451 m)","Pallars Sobira_ZB_Salória (2.451 m)",143.1,115.6,152.6,167.3,120.5,61.1,82.8,150.1,41.6,234.6,113.7,13.6,1396.6]
["Pallars Sobira","XH","Sort","Pallars Sobira_XH_Sort",47.4,67.900000000000006,81.900000000000006,113.8,114.9,79.8,83.1,112.2,74.3,107.6,68.099999999999994,10.1,961.1]
["Pla de l'Estany","DJ","Banyoles","Pla de l'Estany_DJ_Banyoles",56,79.099999999999994,27,139.6,112.3,93.3,49.4,77.900000000000006,57.1,240.4,231.6,12.5,1176.2]
["Pla d'Urgell","C6","Castellnou de Seana","Pla d'Urgell_C6_Castellnou de Seana",29.9,44.8,51.8,103.2,59.5,3.9,12.1,6.7,0.7,126.4,58.8,14,511.8]
["Pla d'Urgell","V8","el Poal","Pla d'Urgell_V8_el Poal",32,43.3,44.8,74.5,80.099999999999994,4.3,10,11.4,0.2,124.2,66.599999999999994,14.2,505.6]
["Pla d'Urgell","WC","Golmés","Pla d'Urgell_WC_Golmés",25.6,46.1,48.3,87,53.9,3.7,14.8,7.7,0.6,117.6,62,16.100000000000001,483.4]
["Pla d'Urgell","XI","Mollerussa","Pla d'Urgell_XI_Mollerussa",27.2,44,48.5,77.2,53.8,3,21.3,11.6,0.9,132.1,70.3,16.5,506.4]
["Priorat","WJ","el Masroig","Priorat_WJ_el Masroig",15.5,41.1,33.299999999999997,55.4,92.1,1.9,7.2,15.5,3.6,178,59,7.3,509.9]
["Priorat","X1","Falset","Priorat_X1_Falset",21.7,87.9,41.6,88.1,131.6,2.2999999999999998,9.3000000000000007,43.7,12.8,243,137.9,7.9,827.8]
["Priorat","D1","Margalef","Priorat_D1_Margalef",47.1,49.5,39.4,100.8,70.8,1.2,5.0999999999999996,18.100000000000001,28.6,194.1,82.7,8.3000000000000007,645.70000000000005]
["Priorat","MR","Panta de Siurana","Priorat_MR_Panta de Siurana",28.2,78.8,52.7,106.6,116,17.5,6.8,36.4,65.400000000000006,230.9,80.099999999999994,6,825.4]
["Priorat","WR","Torroja del Priorat","Priorat_WR_Torroja del Priorat",25.8,61.4,45.4,85,97.2,38.200000000000003,17.8,15.8,18.8,185.8,101.5,6.6,699.3]
["Priorat","XD","Ulldemolins","Priorat_XD_Ulldemolins",44.9,60.7,66.599999999999994,108.7,137.5,22.3,10.1,31.9,58.4,224.3,75.8,8.6999999999999993,849.9]
["Ribera d'Ebre","VA","Aseó","Ribera d'Ebre_VA_Aseó",35.6,37.9,32.1,82.3,100.6,2.4,8.8000000000000007,7.3,3.3,164.3,72.599999999999994,10.1,557.29999999999995]
["Ribera d'Ebre","VB","Benissanet","Ribera d'Ebre_VB_Benissanet",15.1,38.1,30.1,50,87,3.5,7.4,5.5,10.3,201.1,69.8,11.6,529.5]
["Ribera d'Ebre","ve","Panta de Riba-roja","Ribera d'Ebre_ve_Panta de Riba-roja",26.9,31.7,23.8,55,52.3,5.9,11.4,4.0999999999999996,13.1,137.9,50.5,9.5,422.1]
["Ribera d'Ebre","Y6","Tivissa","Ribera d'Ebre_Y6_Tivissa",20.100000000000001,69.2,40,73.3,165.9,2.8,11.2,83.7,26.7,257.39999999999998,97,12,859.3]
["Ribera d'Ebre","D7","Vinebre","Ribera d'Ebre_D7_Vinebre",24,42.8,26,74.2,71.599999999999994,2.1,9.6999999999999993,16.2,4.7,149,67.599999999999994,7.9,495.8]
["Ripolles","CG","Molió- Fabert","Ripolles_CG_Molió- Fabert",86.4,122.8,61.8,192.9,102.2,110.6,134.69999999999999,169.2,125.8,350.4,134.1,7.3,1598.2]
["Ripolles","DG","Núria (1.971 m)","Ripolles_DG_Núria (1.971 m)",110.5,150.19999999999999,127.1,193.4,174.6,62.1,75.599999999999994,133.6,56.6,369.1,121.6,14.2,1588.6]
["Ripolles","M6","Sant Joan de les Abadesses","Ripolles_M6_Sant Joan de les Abadesses",62.6,123,43.2,109.5,126.1,72.599999999999994,153.69999999999999,180.1,88.3,275.89999999999998,94.9,6,1335.9]
["Ripolles","CI","Sant Pau de Segúries","Ripolles_CI_Sant Pau de Segúries",87.1,144.6,54.1,173.7,159.6,114.1,97.6,114.7,165.3,321.89999999999998,151.69999999999999,4.8,1589.2]
["Ripolles","zc","Ulldeter (2.41O m)","Ripolles_zc_Ulldeter (2.41O m)",154.80000000000001,168.2,150.1,191.7,171.1,53.8,104.2,113.9,61.2,309.5,73.099999999999994,18,1569.6]
["Segarra","C8","Cervera","Segarra_C8_Cervera",31.6,28.4,68.900000000000006,51,100,33,7.1,35.700000000000003,42.1,123.9,60.3,7.3,589.29999999999995]
["Segarra","VD","el Canós","Segarra_VD_el Canós",28.9,32,57.6,72,82.2,13.7,16.2,34.5,12.8,104.9,71.099999999999994,9.8000000000000007,535.70000000000005]
["Segarra","YE","Massoteres","Segarra_YE_Massoteres",44.9,52.5,75.099999999999994,77,122.6,31.5,6.4,28.7,18.899999999999999,137.4,81.599999999999994,12,688.6]
["Segria","VE","Aitona","Segria_VE_Aitona",23.4,37.1,32.200000000000003,61,58.6,5.5,21.7,4.2,2.2000000000000002,109.1,52.1,12.9,420]
["Segria","XY","Alcarras","Segria_XY_Alcarras",26.5,44.9,36.9,83.7,66.7,28.1,36.4,18.899999999999999,13.3,135.80000000000001,81.400000000000006,16.3,588.9]
["Segria","WK","Alfarras","Segria_WK_Alfarras",29.9,43.2,54.3,97.7,71.099999999999994,28.2,8.6,51.8,0.9,136,63.5,17.3,602.5]
["Segria","X3","Alguaire","Segria_X3_Alguaire",25.5,32.1,51.6,86.4,67,7.4,12.1,46.6,1.6,141,65.2,16.2,552.70000000000005]
["Segria","XM","els Alamús","Segria_XM_els Alamús",33.299999999999997,38,46.3,64.8,61.8,3.9,19.3,34.9,3,129.80000000000001,68,17.2,520.29999999999995]
["Segria","VH","Gimenells","Segria_VH_Gimenells",22.9,22.3,32.200000000000003,78.599999999999994,60,12.8,23,33.700000000000003,19.3,98.8,44.2,13.1,460.9]
["Segria","WI","Maials","Segria_WI_Maials",27.1,45.1,41,85.1,38.299999999999997,9.8000000000000007,33.5,6.9,3.3,114.5,62,11.7,478.3]
["Segria","VK","Raimat","Segria_VK_Raimat",21.3,27.3,43.9,91.4,48.3,16.5,27.8,23,6.9,108.8,55.4,14.4,485]
["Segria","XN","Seros","Segria_XN_Seros",26.7,39,31.2,58.9,48.9,6.1,14.5,6.9,1.5,102.7,44.9,10.5,391.8]
["Segria","X7","Torres de Segre","Segria_X7_Torres de Segre",18.100000000000001,34.200000000000003,26.5,66.900000000000006,42,5.3,30.2,7.5,32.5,91.5,53.6,13.5,421.8]
["Segria","VM","Vilanova de Segria","Segria_VM_Vilanova de Segria",22.5,35.4,36.700000000000003,79.3,60.8,10.4,15.6,51.7,3.3,134.4,61.9,16.5,528.5]
["Selva","DN","Angles","Selva_DN_Angles",32.4,133.80000000000001,50.7,142.9,163.19999999999999,76,80.2,70,33.4,309,188.1,8.3000000000000007,1288]
["Selva","KP","Fogars de la Selva","Selva_KP_Fogars de la Selva",40.200000000000003,98,44.3,80.2,75,37.299999999999997,53.8,59.7,53.6,241.7,232.4,10.7,1026.9000000000001]
["Selva","xs","Santa Coloma de Farners","Selva_xs_Santa Coloma de Farners",32.799999999999997,108.2,65.400000000000006,95.7,104.5,45.2,79.7,72.8,10.199999999999999,270.7,161.9,9.6999999999999993,1056.8]
["Selva","VN","Vilobí d'Onyar","Selva_VN_Vilobí d'Onyar",35.9,95.3,64,100.2,80.599999999999994,22.7,39.6,49.8,5.7,200.4,168.6,9.6999999999999993,872.5]
["Solsones","Z8","el Port del Comte (2.316 m)","Solsones_Z8_el Port del Comte (2.316 m)",67.8,138.30000000000001,189.2,176.3,201.9,137.19999999999999,40.299999999999997,209.2,78.8,258.89999999999998,132.30000000000001,25.7,1655.9]
["Solsones","MV","Guixers - Valls","Solsones_MV_Guixers - Valls",95.9,120,105.7,119.5,147.4,74.8,30.1,136.80000000000001,36.299999999999997,238.7,75.7,8.5,1189.4000000000001]
["Solsones","vo","Lladurs","Solsones_vo_Lladurs",56.1,89.9,86,106.6,136.30000000000001,98.6,16.8,98.2,38.799999999999997,191.3,96.7,10.4,1025.7]
["Solsones","MW","Naves","Solsones_MW_Naves",84.6,108,71,103.8,123,32.799999999999997,47,111.2,25.9,167.9,82.7,8.6,966.5]
["Solsones","VP","Pinós","Solsones_VP_Pinós",84.8,89.8,65.099999999999994,99.5,78.599999999999994,86.4,28.3,47.3,24.7,184.7,100.7,8.6999999999999993,898.6]
["Solsones","XT","Solsona","Solsones_XT_Solsona",75.5,97.2,85,98.5,111.9,35.4,29.6,62.4,50.8,241.4,108.7,6.1,1002.5]
["Tarragones","VQ","Constantí","Tarragones_VQ_Constantí",13.5,94.2,28.3,67.3,40.1,6.9,4.7,94.6,87.3,336.5,67.099999999999994,7.9,848.4]
["Tarragones","XE","Tarragona - Complex Educatiu","Tarragones_XE_Tarragona - Complex Educatiu",18.100000000000001,83.1,22.4,45.6,3,9.3000000000000007,2,77.5,44.1,386.5,66,5.2,762.8]
["Tarragones","DK","Torredembarra","Tarragones_DK_Torredembarra",17.899999999999999,102.3,40.799999999999997,45.5,9.3000000000000007,13.6,5.6,120.6,74.099999999999994,200,42.2,5.8,677.7]
["Terra Alta","WD","Batea","Terra Alta_WD_Batea",39.4,36.4,32,67.5,60,11.2,26.4,1.5,20.3,166.9,63.5,12.3,537.4]
["Terra Alta","XP","Gandesa","Terra Alta_XP_Gandesa",26.2,46.6,33.200000000000003,64.3,48,12,11,8.6,7.7,161.30000000000001,71.099999999999994,11.4,501.4]
["Terra Alta","D8","Horta de Sant Joan","Terra Alta_D8_Horta de Sant Joan",114.1,43,37.799999999999997,79.099999999999994,62.8,16.3,29.6,6.9,2.2000000000000002,231.1,80.7,12.4,716]
["Urgell","WL","Sant Martí de Riucorb","Urgell_WL_Sant Martí de Riucorb",26.1,28.1,55,88.1,41.5,14.6,13.4,3.8,4.8,123.9,51.9,12.8,464]
["Urgell","C7","Tarrega","Urgell_C7_Tarrega",30.1,34.5,70.3,79.599999999999994,82.1,21.6,16.899999999999999,19,14.9,103.5,65.8,13.5,551.79999999999995]
["Urgell","XX","Tornabous","Urgell_XX_Tornabous",26.7,34.6,59.5,86.1,45.9,8.4,10,7.1,6,108.7,62.1,12.5,467.6]
["Val d'Aran","vs","Lac Redan (2.247 m)","Val d'Aran_vs_Lac Redan (2.247 m)",197,351.4,191.4,107.6,255.9,104.7,93,125.9,93.1,192,86.7,83.8,1882.5]
["Val d'Aran","Z6"," Sasseuva (2.228 m)","Val d'Aran_Z6_ Sasseuva (2.228 m)",133.1,206.1,123.9,92.4,188.9,82.7,141.69999999999999,31.9,47.9,116.5,51.9,44.8,1261.8]
["Val d'Aran","cu","Vielha","Val d'Aran_cu_Vielha",123,192.3,112.7,160.30000000000001,155.4,83.9,58.7,96.8,67.8,116.1,43,37.1,1247.0999999999999]
["Valles Occ.","XC","Castellbisbal","Valles Occ._XC_Castellbisbal",86.3,106.4,100,85.5,27.8,98.2,41.4,75.2,70.400000000000006,150.30000000000001,228.4,2.8,1072.7]
["Valles Occ.","vu","Rellinars","Valles Occ._vu_Rellinars",81.099999999999994,101.6,83.9,113.9,78.7,80.400000000000006,29.7,41.5,28.7,178.3,129.80000000000001,5.0999999999999996,952.7]
["Valles Occ.","XF","Sabadell - Pare Agrari","Valles Occ._XF_Sabadell - Pare Agrari",72.7,85.5,86.1,91.2,44.9,70.5,37.6,77.5,39.4,154.6,156.19999999999999,3.2,919.4]
["Valles Occ.","XV","Sant Cugat del Valles - CAR","Valles Occ._XV_Sant Cugat del Valles - CAR",70.400000000000006,89,89,77.400000000000006,44.2,61.4,24.6,35.1,31.3,174.5,158.19999999999999,3.8,858.9]
["Valles Occ.","vv","Sant Llorenç Savall","Valles Occ._vv_Sant Llorenç Savall",99.7,109.2,107.7,132.80000000000001,136.9,63.1,22.1,39.799999999999997,21.6,210.6,139.30000000000001,5.8,1088.5999999999999]
["Valles Occ.","D2","Vacarisses","Valles Occ._D2_Vacarisses",67.3,106.8,85.4,101.9,76,89.5,28.5,40.1,58.3,157,159,2.4,972.2]
["Valles Oriental","X9","Caldes de Montbui","Valles Oriental_X9_Caldes de Montbui",73.8,91.1,74.599999999999994,77.099999999999994,52.4,43.6,18.5,26.2,41.5,142.30000000000001,106.3,6.9,754.3]
["Valles Oriental","KX","la Roca del Valles - ETAP Cardedeu","Valles Oriental_KX_la Roca del Valles - ETAP Cardedeu",77.8,76.099999999999994,65.2,128.4,75.5,23.7,40,26.4,73.400000000000006,227.4,125.3,4.5999999999999996,943.8]
["Valles Oriental","XG","Parets del Valles","Valles Oriental_XG_Parets del Valles",75.2,77.2,84.3,68.5,37,109.4,10.1,23.1,31.7,146.80000000000001,102.9,4.5999999999999996,770.8]
["Valles Oriental","XK","Puig Sesolles (1.668m)","Valles Oriental_XK_Puig Sesolles (1.668m)",87.9,122.9,122.7,160.9,147.4,74.599999999999994,57.5,96.7,22.8,378.6,190.3,5.0999999999999996,1467.4]
["Valles Oriental","VX","Tagamanent - PN del Montseny","Valles Oriental_VX_Tagamanent - PN del Montseny",87.8,102.9,80.400000000000006,153.1,121,35.200000000000003,13.5,81.5,3.8,253.1,110.8,5.7,1048.8]
["Valles Oriental","WE","Vilanova del Valles","Valles Oriental_WE_Vilanova del Valles",99.7,79.7,94.5,88.4,75.7,20.399999999999999,14.1,22.6,28.3,219.7,181.5,8.9,933.5]

{"sheet":"Balanç anual","index":7,"n_rows":30,"n_cols":46,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
["Superfície coberta",{"$f":"APLICATIU!J8","v":70}]
["Eficiència de recollida",0.8,null,null,null,null,null,null,null,null,null,null,null,null,null,"Volum dipòsit (l)",{"$f":"APLICATIU!J29*1000","v":3800.0000000000005}]
[]
[{"$f":"'Aigua recollida'!A13","v":"Sant Andreu"},31,28,31,30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31]
["Mes","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre","TOTAL",null,"Pluviòmetre","Aigua recollida (m³/any)","Demanda domèstica (m³/any)","Demanda reg (m³/any)","Demanda total (m³/any)","Volum estalviat","Demanda reg (l/dia)"]
["Pluviometria (mm)",{"$f":"'Aigua recollida'!B16","v":58},{"$f":"'Aigua recollida'!C16","v":63},{"$f":"'Aigua recollida'!D16","v":56},{"$f":"'Aigua recollida'!E16","v":59},{"$f":"'Aigua recollida'!F16","v":54},{"$f":"'Aigua recollida'!G16","v":30},{"$f":"'Aigua recollida'!H16","v":20},{"$f":"'Aigua recollida'!I16","v":46},{"$f":"'Aigua recollida'!J16","v":86},{"$f":"'Aigua recollida'!K16","v":91},{"$f":"'Aigua recollida'!L16","v":56},{"$f":"'Aigua recollida'!M16","v":58},{"$f":"'Aigua recollida'!B16","v":58},{"$f":"'Aigua recollida'!C16","v":63},{"$f":"'Aigua recollida'!D16","v":56},{"$f":"'Aigua recollida'!E16","v":59},{"$f":"'Aigua recollida'!F16","v":54},{"$f":"'Aigua recollida'!G16","v":30},{"$f":"'Aigua recollida'!H16","v":20},{"$f":"'Aigua recollida'!I16","v":46},{"$f":"'Aigua recollida'!J16","v":86},{"$f":"'Aigua recollida'!K16","v":91},{"$f":"'Aigua recollida'!L16","v":56},{"$f":"'Aigua recollida'!M16","v":58},{"$f":"'Aigua recollida'!B16","v":58},{"$f":"'Aigua recollida'!C16","v":63},{"$f":"'Aigua recollida'!D16","v":56},{"$f":"'Aigua recollida'!E16","v":59},{"$f":"'Aigua recollida'!F16","v":54},{"$f":"'Aigua recollida'!G16","v":30},{"$f":"'Aigua recollida'!H16","v":20},{"$f":"'Aigua recollida'!I16","v":46},{"$f":"'Aigua recollida'!J16","v":86},{"$f":"'Aigua recollida'!K16","v":91},{"$f":"'Aigua recollida'!L16","v":56},{"$f":"'Aigua recollida'!M16","v":58},null,null,{"$f":"A4","v":"Sant Andreu"},{"$f":"AL7","v":1236.248},{"$f":"AL10","v":117.53},{"$f":"AL11","v":6.3350734246575335},{"$f":"AL12","v":123.86507342465754},{"$f":"AL15","v":45.048000000000002}]
["Aigua recollida (m³/mes)",{"$f":"'Aigua recollida'!B17","v":3.2480000000000002},{"$f":"'Aigua recollida'!C17","v":3.528},{"$f":"'Aigua recollida'!D17","v":3.1360000000000001},{"$f":"'Aigua recollida'!E17","v":3.3039999999999998},{"$f":"'Aigua recollida'!F17","v":3.024},{"$f":"'Aigua recollida'!G17","v":1.68},{"$f":"'Aigua recollida'!H17","v":1.1200000000000001},{"$f":"'Aigua recollida'!I17","v":2.5760000000000001},{"$f":"'Aigua recollida'!J17","v":4.8159999999999998},{"$f":"'Aigua recollida'!K17","v":5.0960000000000001},{"$f":"'Aigua recollida'!L17","v":3.1360000000000001},{"$f":"'Aigua recollida'!M17","v":3.2480000000000002},{"$f":"'Aigua recollida'!B17","v":3.2480000000000002},{"$f":"'Aigua recollida'!C17","v":3.528},{"$f":"'Aigua recollida'!D17","v":3.1360000000000001},{"$f":"'Aigua recollida'!E17","v":3.3039999999999998},{"$f":"'Aigua recollida'!F17","v":3.024},{"$f":"'Aigua recollida'!G17","v":1.68},{"$f":"'Aigua recollida'!H17","v":1.1200000000000001},{"$f":"'Aigua recollida'!I17","v":2.5760000000000001},{"$f":"'Aigua recollida'!J17","v":4.8159999999999998},{"$f":"'Aigua recollida'!K17","v":5.0960000000000001},{"$f":"'Aigua recollida'!L17","v":3.1360000000000001},{"$f":"'Aigua recollida'!M17","v":3.2480000000000002},{"$f":"'Aigua recollida'!B17","v":3.2480000000000002},{"$f":"'Aigua recollida'!D16","v":56},{"$f":"'Aigua recollida'!E16","v":59},{"$f":"'Aigua recollida'!F16","v":54},{"$f":"'Aigua recollida'!G16","v":30},{"$f":"'Aigua recollida'!H16","v":20},{"$f":"'Aigua recollida'!I16","v":46},{"$f":"'Aigua recollida'!J16","v":86},{"$f":"'Aigua recollida'!K16","v":91},{"$f":"'Aigua recollida'!L16","v":56},{"$f":"'Aigua recollida'!M16","v":58},{"$f":"'Aigua recollida'!N16","v":677},{"$f":"SUM(Z7:AK7)","v":1236.248},"m³/any","Personalitzat",{"$f":"AL22","v":0},{"$f":"AL25","v":117.53},{"$f":"AL26","v":6.3350734246575335},{"$f":"AL27","v":123.86507342465754},{"$f":"AL30","v":0}]
["Aigua recollida (l/mes)",{"$f":"B7*1000","v":3248},{"$f":"C7*1000","v":3528},3136,3304,3024,1680,1120,2576,4816,5096,3136,3248,3248,3528,3136,3304,3024,1680,1120,2576,4816,5096,3136,3248,3248,56000,59000,54000,30000,20000,46000,86000,91000,56000,58000,677000,null,null,null,null,"Aigua recollida",{"$f":"VLOOKUP(APLICATIU!I4,'Balanç anual'!AN6:AO7,2,FALSE)","v":1236.248}]
["Reserva d'aigua (l)",{"$f":"MIN(Q2,B8)","v":3248},{"$f":"MIN($Q$2,IF(B13<0,C8,IF(B13=0,B14+C8)))","v":3528},{"$f":"MIN($Q$2,IF(C13<0,D8,IF(C13=0,C14+D8)))","v":3136},3304,3024,1680,1120,{"$f":"MIN($Q$2,IF(H13<0,I8,IF(H13=0,H14+I8)))","v":2576},{"$f":"MIN($Q$2,IF(I13<0,J8,IF(I13=0,I14+J8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(J13<0,K8,IF(J13=0,J14+K8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(K13<0,L8,IF(K13=0,K14+L8)))","v":3136},{"$f":"MIN($Q$2,IF(L13<0,M8,IF(L13=0,L14+M8)))","v":3248},{"$f":"MIN($Q$2,IF(M13<0,N8,IF(M13=0,M14+N8)))","v":3248},3528,{"$f":"MIN($Q$2,IF(O13<0,P8,IF(O13=0,O14+P8)))","v":3136},{"$f":"MIN($Q$2,IF(P13<0,Q8,IF(P13=0,P14+Q8)))","v":3304},{"$f":"MIN($Q$2,IF(Q13<0,R8,IF(Q13=0,Q14+R8)))","v":3024},{"$f":"MIN($Q$2,IF(R13<0,S8,IF(R13=0,R14+S8)))","v":1680},{"$f":"MIN($Q$2,IF(S13<0,T8,IF(S13=0,S14+T8)))","v":1120},2576,{"$f":"MIN($Q$2,IF(U13<0,V8,IF(U13=0,U14+V8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(V13<0,W8,IF(V13=0,V14+W8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(W13<0,X8,IF(W13=0,W14+X8)))","v":3136},{"$f":"MIN($Q$2,IF(X13<0,Y8,IF(X13=0,X14+Y8)))","v":3248},{"$f":"MIN($Q$2,IF(Y13<0,Z8,IF(Y13=0,Y14+Z8)))","v":3248},3800.0000000000005,{"$f":"MIN($Q$2,IF(AA13<0,AB8,IF(AA13=0,AA14+AB8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(AB13<0,AC8,IF(AB13=0,AB14+AC8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(AC13<0,AD8,IF(AC13=0,AC14+AD8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(AD13<0,AE8,IF(AD13=0,AD14+AE8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(AE13<0,AF8,IF(AE13=0,AE14+AF8)))","v":3800.0000000000005},3800.0000000000005,{"$f":"MIN($Q$2,IF(AG13<0,AH8,IF(AG13=0,AG14+AH8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(AH13<0,AI8,IF(AH13=0,AH14+AI8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(AI13<0,AJ8,IF(AI13=0,AI14+AJ8)))","v":3800.0000000000005},{"$f":"MIN($Q$2,IF(AJ13<0,AK8,IF(AJ13=0,AJ14+AK8)))","v":3800.0000000000005},null,null,null,null,"Demanda total",{"$f":"VLOOKUP(APLICATIU!I4,'Balanç anual'!AN6:AR7,5,FALSE)","v":123.86507342465754}]
["Demanda domèstica (l/mes)",{"$f":"Consum!$C$19*B4","v":9982},{"$f":"Consum!$C$19*C4","v":9016},{"$f":"Consum!$C$19*D4","v":9982},{"$f":"Consum!$C$19*E4","v":9660},{"$f":"Consum!$C$19*F4","v":9982},{"$f":"Consum!$C$19*G4","v":9660},{"$f":"Consum!$C$19*H4","v":9982},{"$f":"Consum!$C$19*I4","v":9982},{"$f":"Consum!$C$19*J4","v":9660},{"$f":"Consum!$C$19*K4","v":9982},{"$f":"Consum!$C$19*L4","v":9660},{"$f":"Consum!$C$19*M4","v":9982},{"$f":"Consum!$C$19*N4","v":9982},{"$f":"Consum!$C$19*O4","v":9016},{"$f":"Consum!$C$19*P4","v":9982},{"$f":"Consum!$C$19*Q4","v":9660},{"$f":"Consum!$C$19*R4","v":9982},{"$f":"Consum!$C$19*S4","v":9660},{"$f":"Consum!$C$19*T4","v":9982},{"$f":"Consum!$C$19*U4","v":9982},{"$f":"Consum!$C$19*V4","v":9660},{"$f":"Consum!$C$19*W4","v":9982},{"$f":"Consum!$C$19*X4","v":9660},{"$f":"Consum!$C$19*Y4","v":9982},{"$f":"Consum!$C$19*Z4","v":9982},{"$f":"Consum!$C$19*AA4","v":9016},{"$f":"Consum!$C$19*AB4","v":9982},{"$f":"Consum!$C$19*AC4","v":9660},{"$f":"Consum!$C$19*AD4","v":9982},{"$f":"Consum!$C$19*AE4","v":9660},{"$f":"Consum!$C$19*AF4","v":9982},{"$f":"Consum!$C$19*AG4","v":9982},{"$f":"Consum!$C$19*AH4","v":9660},{"$f":"Consum!$C$19*AI4","v":9982},{"$f":"Consum!$C$19*AJ4","v":9660},{"$f":"Consum!$C$19*AK4","v":9982},{"$f":"(SUM(Z10:AK10)/1000)","v":117.53},"m³/any","RESERVA JULIOL"]
["Demanda de reg (l/mes)",{"$f":"'Necessitats de reg'!B77*B4","v":180.6255707762557},{"$f":"'Necessitats de reg'!C77*C4","v":249.551598173516},{"$f":"'Necessitats de reg'!D77*D4","v":429.88675799086764},{"$f":"'Necessitats de reg'!E77*E4","v":558.93881278538811},{"$f":"'Necessitats de reg'!F77*F4","v":732.78958904109584},{"$f":"'Necessitats de reg'!G77*G4","v":886.20000000000016},{"$f":"'Necessitats de reg'!H77*H4","v":980.13333333333344},{"$f":"'Necessitats de reg'!I77*I4","v":901.06666666666661},{"$f":"'Necessitats de reg'!J77*J4","v":625.45205479452056},{"$f":"'Necessitats de reg'!K77*K4","v":406.17972602739724},{"$f":"'Necessitats de reg'!L77*L4","v":223.6904109589041},{"$f":"'Necessitats de reg'!M77*M4","v":160.55890410958909},{"$f":"'Necessitats de reg'!B77*N4","v":180.6255707762557},{"$f":"'Necessitats de reg'!C77*O4","v":249.551598173516},{"$f":"'Necessitats de reg'!D77*P4","v":429.88675799086764},{"$f":"'Necessitats de reg'!E77*Q4","v":558.93881278538811},{"$f":"'Necessitats de reg'!F77*R4","v":732.78958904109584},{"$f":"'Necessitats de reg'!G77*S4","v":886.20000000000016},{"$f":"'Necessitats de reg'!H77*T4","v":980.13333333333344},{"$f":"'Necessitats de reg'!I77*U4","v":901.06666666666661},{"$f":"'Necessitats de reg'!J77*V4","v":625.45205479452056},{"$f":"'Necessitats de reg'!K77*W4","v":406.17972602739724},{"$f":"'Necessitats de reg'!L77*X4","v":223.6904109589041},{"$f":"'Necessitats de reg'!M77*Y4","v":160.55890410958909},{"$f":"'Necessitats de reg'!B77*Z4","v":180.6255707762557},{"$f":"'Necessitats de reg'!C77*AA4","v":249.551598173516},{"$f":"'Necessitats de reg'!D77*AB4","v":429.88675799086764},{"$f":"'Necessitats de reg'!E77*AC4","v":558.93881278538811},{"$f":"'Necessitats de reg'!F77*AD4","v":732.78958904109584},{"$f":"'Necessitats de reg'!G77*AE4","v":886.20000000000016},{"$f":"'Necessitats de reg'!H77*AF4","v":980.13333333333344},{"$f":"'Necessitats de reg'!I77*AG4","v":901.06666666666661},{"$f":"'Necessitats de reg'!J77*AH4","v":625.45205479452056},{"$f":"'Necessitats de reg'!K77*AI4","v":406.17972602739724},{"$f":"'Necessitats de reg'!L77*AJ4","v":223.6904109589041},{"$f":"'Necessitats de reg'!M77*AK4","v":160.55890410958909},{"$f":"(SUM(Z11:AK11)/1000)","v":6.3350734246575335},"m³/any","Sant Andreu",{"$f":"T9","v":1120},{"$f":"AO11/APLICATIU!$D$34","v":3.1672667120755085}]
["Demanda total (l/mes)",{"$f":"B11+B10","v":10162.625570776256},{"$f":"C11+C10","v":9265.5515981735152},10411.886757990867,10218.938812785389,10714.789589041096,10546.2,10962.133333333333,10883.066666666666,10285.452054794521,10388.179726027398,9883.690410958905,10142.558904109588,{"$f":"N11+N10","v":10162.625570776256},{"$f":"O11+O10","v":9265.5515981735152},10411.886757990867,10218.938812785389,10714.789589041096,10546.2,10962.133333333333,10883.066666666666,10285.452054794521,10388.179726027398,9883.690410958905,10142.558904109588,{"$f":"Z11+Z10","v":10162.625570776256},{"$f":"AA11+AA10","v":9265.5515981735152},10411.886757990867,10218.938812785389,10714.789589041096,10546.2,10962.133333333333,10883.066666666666,10285.452054794521,10388.179726027398,9883.690410958905,10142.558904109588,{"$f":"(SUM(Z12:AK12)/1000)","v":123.86507342465754},"m³/any"]
["Dèficit aigua (l/mes)",{"$f":"IF(B9-B12<0,B9-B12,0)","v":-6914.6255707762557},{"$f":"IF(C9-C12<0,C9-C12,0)","v":-5737.5515981735152},-7275.8867579908674,-6914.938812785389,-7690.7895890410964,-8866.2000000000007,-9842.1333333333332,-8307.0666666666657,-6485.4520547945212,-6588.1797260273979,-6747.690410958905,-6894.5589041095882,{"$f":"IF(N9-N12<0,N9-N12,0)","v":-6914.6255707762557},{"$f":"IF(O9-O12<0,O9-O12,0)","v":-5737.5515981735152},-7275.8867579908674,-6914.938812785389,-7690.7895890410964,-8866.2000000000007,-9842.1333333333332,-8307.0666666666657,-6485.4520547945212,-6588.1797260273979,-6747.690410958905,-6894.5589041095882,{"$f":"IF(Z9-Z12<0,Z9-Z12,0)","v":-6914.6255707762557},{"$f":"IF(AA9-AA12<0,AA9-AA12,0)","v":-5465.5515981735152},-6611.8867579908674,-6418.938812785389,-6914.7895890410964,-6746.2000000000007,-7162.1333333333332,-7083.0666666666657,-6485.4520547945212,-6588.1797260273979,-6083.690410958905,-6342.5589041095882,{"$f":"(SUM(Z13:AK13)/1000)","v":-78.817073424657551},"m³/any"]
["Sobrant aigua (l/mes)",{"$f":"IF(B9-B12>0,B9-B12,0)","v":0},{"$f":"IF(C9-C12>0,C9-C12,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(N9-N12>0,N9-N12,0)","v":0},{"$f":"IF(O9-O12>0,O9-O12,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Z9-Z12>0,Z9-Z12,0)","v":0},{"$f":"IF(AA9-AA12>0,AA9-AA12,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"(SUM(Z14:AK14)/1000)","v":0},"m³/any"]
["Volum estalviat",{"$f":"B9-B14","v":3248},{"$f":"C9-C14","v":3528},3136,{"$f":"E9-E14","v":3304},{"$f":"F9-F14","v":3024},{"$f":"G9-G14","v":1680},{"$f":"H9-H14","v":1120},2576,3800.0000000000005,3800.0000000000005,3136,3248,{"$f":"N9-N14","v":3248},{"$f":"O9-O14","v":3528},{"$f":"P9-P14","v":3136},{"$f":"Q9-Q14","v":3304},3024,1680,1120,2576,{"$f":"V9-V14","v":3800.0000000000005},{"$f":"W9-W14","v":3800.0000000000005},{"$f":"X9-X14","v":3136},{"$f":"Y9-Y14","v":3248},{"$f":"Z9-Z14","v":3248},{"$f":"AA9-AA14","v":3800.0000000000005},{"$f":"AB9-AB14","v":3800.0000000000005},{"$f":"AC9-AC14","v":3800.0000000000005},{"$f":"AD9-AD14","v":3800.0000000000005},{"$f":"AE9-AE14","v":3800.0000000000005},{"$f":"AF9-AF14","v":3800.0000000000005},{"$f":"AG9-AG14","v":3800.0000000000005},3800.0000000000005,3800.0000000000005,{"$f":"AJ9-AJ14","v":3800.0000000000005},{"$f":"AK9-AK14","v":3800.0000000000005},{"$f":"(SUM(Z15:AK15))/1000","v":45.048000000000002},"m³/any",{"$f":"IF(AL7<AL12,100,((AL12*100)/AL7))","v":10.019435697744912}]
[null,{"$f":"B11/B4","v":5.8266313153630866},{"$f":"C11/C4","v":8.9125570776255714},13.867314773898956,18.631293759512936,23.638373840035349,29.540000000000006,31.617204301075272,29.066666666666666,20.848401826484018,13.102571807335394,7.4563470319634702,5.1793194874060999,{"$f":"(SUM(B16:M16))/12","v":17.307223490613904}]
[]
[]
["Personalitzat",31,28,31,30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31,31,28,31,30,31,30,31,31,30,31,30,31]
["Mes","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre","Novembre","Desembre","TOTAL"]
["Pluviometria (mm)",{"$f":"'Aigua recollida'!B9","v":0},{"$f":"'Aigua recollida'!C9","v":0},{"$f":"'Aigua recollida'!D9","v":0},{"$f":"'Aigua recollida'!E9","v":0},{"$f":"'Aigua recollida'!F9","v":0},{"$f":"'Aigua recollida'!G9","v":0},{"$f":"'Aigua recollida'!H9","v":0},{"$f":"'Aigua recollida'!I9","v":0},{"$f":"'Aigua recollida'!J9","v":0},{"$f":"'Aigua recollida'!K9","v":0},{"$f":"'Aigua recollida'!L9","v":0},{"$f":"'Aigua recollida'!M9","v":0},{"$f":"'Aigua recollida'!B9","v":0},{"$f":"'Aigua recollida'!C9","v":0},{"$f":"'Aigua recollida'!D9","v":0},{"$f":"'Aigua recollida'!E9","v":0},{"$f":"'Aigua recollida'!F9","v":0},{"$f":"'Aigua recollida'!G9","v":0},{"$f":"'Aigua recollida'!H9","v":0},{"$f":"'Aigua recollida'!I9","v":0},{"$f":"'Aigua recollida'!J9","v":0},{"$f":"'Aigua recollida'!K9","v":0},{"$f":"'Aigua recollida'!L9","v":0},{"$f":"'Aigua recollida'!M9","v":0},{"$f":"'Aigua recollida'!B9","v":0},{"$f":"'Aigua recollida'!C9","v":0},{"$f":"'Aigua recollida'!D9","v":0},{"$f":"'Aigua recollida'!E9","v":0},{"$f":"'Aigua recollida'!F9","v":0},{"$f":"'Aigua recollida'!G9","v":0},{"$f":"'Aigua recollida'!H9","v":0},{"$f":"'Aigua recollida'!I9","v":0},{"$f":"'Aigua recollida'!J9","v":0},{"$f":"'Aigua recollida'!K9","v":0},{"$f":"'Aigua recollida'!L9","v":0},{"$f":"'Aigua recollida'!M9","v":0}]
["Aigua recollida (m³)",{"$f":"'Aigua recollida'!B10","v":0},{"$f":"'Aigua recollida'!C10","v":0},{"$f":"'Aigua recollida'!D10","v":0},{"$f":"'Aigua recollida'!E10","v":0},{"$f":"'Aigua recollida'!F10","v":0},{"$f":"'Aigua recollida'!G10","v":0},{"$f":"'Aigua recollida'!H10","v":0},{"$f":"'Aigua recollida'!I10","v":0},{"$f":"'Aigua recollida'!J10","v":0},{"$f":"'Aigua recollida'!K10","v":0},{"$f":"'Aigua recollida'!L10","v":0},{"$f":"'Aigua recollida'!M10","v":0},{"$f":"'Aigua recollida'!B10","v":0},{"$f":"'Aigua recollida'!C10","v":0},{"$f":"'Aigua recollida'!D10","v":0},{"$f":"'Aigua recollida'!E10","v":0},{"$f":"'Aigua recollida'!F10","v":0},{"$f":"'Aigua recollida'!G10","v":0},{"$f":"'Aigua recollida'!H10","v":0},{"$f":"'Aigua recollida'!I10","v":0},{"$f":"'Aigua recollida'!J10","v":0},{"$f":"'Aigua recollida'!K10","v":0},{"$f":"'Aigua recollida'!L10","v":0},{"$f":"'Aigua recollida'!M10","v":0},{"$f":"'Aigua recollida'!B10","v":0},{"$f":"'Aigua recollida'!C10","v":0},{"$f":"'Aigua recollida'!D10","v":0},{"$f":"'Aigua recollida'!E10","v":0},{"$f":"'Aigua recollida'!F10","v":0},{"$f":"'Aigua recollida'!G10","v":0},{"$f":"'Aigua recollida'!H10","v":0},{"$f":"'Aigua recollida'!I10","v":0},{"$f":"'Aigua recollida'!J10","v":0},{"$f":"'Aigua recollida'!K10","v":0},{"$f":"'Aigua recollida'!L10","v":0},{"$f":"'Aigua recollida'!M10","v":0},{"$f":"SUM(Z22:AK22)","v":0},"m³/any"]
["Aigua recollida (l/d)",{"$f":"B22*1000","v":0},{"$f":"C22*1000","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Reserva d'aigua (l)",{"$f":"B23","v":0},{"$f":"MIN($Q$2,IF(B28<0,C23,IF(B28=0,B29+C23)))","v":0},{"$f":"MIN($Q$2,IF(C28<0,D23,IF(C28=0,C29+D23)))","v":0},{"$f":"MIN($Q$2,IF(D28<0,E23,IF(D28=0,D29+E23)))","v":0},{"$f":"MIN($Q$2,IF(E28<0,F23,IF(E28=0,E29+F23)))","v":0},{"$f":"MIN($Q$2,IF(F28<0,G23,IF(F28=0,F29+G23)))","v":0},{"$f":"MIN($Q$2,IF(G28<0,H23,IF(G28=0,G29+H23)))","v":0},{"$f":"MIN($Q$2,IF(H28<0,I23,IF(H28=0,H29+I23)))","v":0},{"$f":"MIN($Q$2,IF(I28<0,J23,IF(I28=0,I29+J23)))","v":0},{"$f":"MIN($Q$2,IF(J28<0,K23,IF(J28=0,J29+K23)))","v":0},{"$f":"MIN($Q$2,IF(K28<0,L23,IF(K28=0,K29+L23)))","v":0},{"$f":"MIN($Q$2,IF(L28<0,M23,IF(L28=0,L29+M23)))","v":0},{"$f":"MIN($Q$2,IF(M28<0,N23,IF(M28=0,M29+N23)))","v":0},{"$f":"MIN($Q$2,IF(N28<0,O23,IF(N28=0,N29+O23)))","v":0},{"$f":"MIN($Q$2,IF(O28<0,P23,IF(O28=0,O29+P23)))","v":0},{"$f":"MIN($Q$2,IF(P28<0,Q23,IF(P28=0,P29+Q23)))","v":0},{"$f":"MIN($Q$2,IF(Q28<0,R23,IF(Q28=0,Q29+R23)))","v":0},{"$f":"MIN($Q$2,IF(R28<0,S23,IF(R28=0,R29+S23)))","v":0},{"$f":"MIN($Q$2,IF(S28<0,T23,IF(S28=0,S29+T23)))","v":0},{"$f":"MIN($Q$2,IF(T28<0,U23,IF(T28=0,T29+U23)))","v":0},{"$f":"MIN($Q$2,IF(U28<0,V23,IF(U28=0,U29+V23)))","v":0},{"$f":"MIN($Q$2,IF(V28<0,W23,IF(V28=0,V29+W23)))","v":0},{"$f":"MIN($Q$2,IF(W28<0,X23,IF(W28=0,W29+X23)))","v":0},{"$f":"MIN($Q$2,IF(X28<0,Y23,IF(X28=0,X29+Y23)))","v":0},{"$f":"MIN($Q$2,IF(Y28<0,Z23,IF(Y28=0,Y29+Z23)))","v":0},{"$f":"MIN($Q$2,IF(Z28<0,AA23,IF(Z28=0,Z29+AA23)))","v":0},{"$f":"MIN($Q$2,IF(AA28<0,AB23,IF(AA28=0,AA29+AB23)))","v":0},{"$f":"MIN($Q$2,IF(AB28<0,AC23,IF(AB28=0,AB29+AC23)))","v":0},{"$f":"MIN($Q$2,IF(AC28<0,AD23,IF(AC28=0,AC29+AD23)))","v":0},{"$f":"MIN($Q$2,IF(AD28<0,AE23,IF(AD28=0,AD29+AE23)))","v":0},{"$f":"MIN($Q$2,IF(AE28<0,AF23,IF(AE28=0,AE29+AF23)))","v":0},{"$f":"MIN($Q$2,IF(AF28<0,AG23,IF(AF28=0,AF29+AG23)))","v":0},{"$f":"MIN($Q$2,IF(AG28<0,AH23,IF(AG28=0,AG29+AH23)))","v":0},{"$f":"MIN($Q$2,IF(AH28<0,AI23,IF(AH28=0,AH29+AI23)))","v":0},{"$f":"MIN($Q$2,IF(AI28<0,AJ23,IF(AI28=0,AI29+AJ23)))","v":0},{"$f":"MIN($Q$2,IF(AJ28<0,AK23,IF(AJ28=0,AJ29+AK23)))","v":0}]
["Demanda domèstica (l/d)",{"$f":"Consum!$C$19*B19","v":9982},{"$f":"Consum!$C$19*C19","v":9016},{"$f":"Consum!$C$19*D19","v":9982},{"$f":"Consum!$C$19*E19","v":9660},{"$f":"Consum!$C$19*F19","v":9982},{"$f":"Consum!$C$19*G19","v":9660},{"$f":"Consum!$C$19*H19","v":9982},{"$f":"Consum!$C$19*I19","v":9982},{"$f":"Consum!$C$19*J19","v":9660},{"$f":"Consum!$C$19*K19","v":9982},{"$f":"Consum!$C$19*L19","v":9660},{"$f":"Consum!$C$19*M19","v":9982},{"$f":"Consum!$C$19*N19","v":9982},{"$f":"Consum!$C$19*O19","v":9016},{"$f":"Consum!$C$19*P19","v":9982},{"$f":"Consum!$C$19*Q19","v":9660},{"$f":"Consum!$C$19*R19","v":9982},{"$f":"Consum!$C$19*S19","v":9660},{"$f":"Consum!$C$19*T19","v":9982},{"$f":"Consum!$C$19*U19","v":9982},{"$f":"Consum!$C$19*V19","v":9660},{"$f":"Consum!$C$19*W19","v":9982},{"$f":"Consum!$C$19*X19","v":9660},{"$f":"Consum!$C$19*Y19","v":9982},{"$f":"Consum!$C$19*Z19","v":9982},{"$f":"Consum!$C$19*AA19","v":9016},{"$f":"Consum!$C$19*AB19","v":9982},{"$f":"Consum!$C$19*AC19","v":9660},{"$f":"Consum!$C$19*AD19","v":9982},{"$f":"Consum!$C$19*AE19","v":9660},{"$f":"Consum!$C$19*AF19","v":9982},{"$f":"Consum!$C$19*AG19","v":9982},{"$f":"Consum!$C$19*AH19","v":9660},{"$f":"Consum!$C$19*AI19","v":9982},{"$f":"Consum!$C$19*AJ19","v":9660},{"$f":"Consum!$C$19*AK19","v":9982},{"$f":"(SUM(Z25:AK25)/1000)","v":117.53},"m³/any"]
["Demanda de reg (l/d)",{"$f":"'Necessitats de reg'!B77*B19","v":180.6255707762557},{"$f":"'Necessitats de reg'!C77*C19","v":249.551598173516},{"$f":"'Necessitats de reg'!D77*D19","v":429.88675799086764},{"$f":"'Necessitats de reg'!E77*E19","v":558.93881278538811},{"$f":"'Necessitats de reg'!F77*F19","v":732.78958904109584},{"$f":"'Necessitats de reg'!G77*G19","v":886.20000000000016},{"$f":"'Necessitats de reg'!H77*H19","v":980.13333333333344},{"$f":"'Necessitats de reg'!I77*I19","v":901.06666666666661},{"$f":"'Necessitats de reg'!J77*J19","v":625.45205479452056},{"$f":"'Necessitats de reg'!K77*K19","v":406.17972602739724},{"$f":"'Necessitats de reg'!L77*L19","v":223.6904109589041},{"$f":"'Necessitats de reg'!M77*M19","v":160.55890410958909},{"$f":"'Necessitats de reg'!B77*N19","v":180.6255707762557},{"$f":"'Necessitats de reg'!C77*O19","v":249.551598173516},{"$f":"'Necessitats de reg'!D77*P19","v":429.88675799086764},{"$f":"'Necessitats de reg'!E77*Q19","v":558.93881278538811},{"$f":"'Necessitats de reg'!F77*R19","v":732.78958904109584},{"$f":"'Necessitats de reg'!G77*S19","v":886.20000000000016},{"$f":"'Necessitats de reg'!H77*T19","v":980.13333333333344},{"$f":"'Necessitats de reg'!I77*U19","v":901.06666666666661},{"$f":"'Necessitats de reg'!J77*V19","v":625.45205479452056},{"$f":"'Necessitats de reg'!K77*W19","v":406.17972602739724},{"$f":"'Necessitats de reg'!L77*X19","v":223.6904109589041},{"$f":"'Necessitats de reg'!M77*Y19","v":160.55890410958909},{"$f":"'Necessitats de reg'!B77*Z19","v":180.6255707762557},{"$f":"'Necessitats de reg'!C77*AA19","v":249.551598173516},{"$f":"'Necessitats de reg'!D77*AB19","v":429.88675799086764},{"$f":"'Necessitats de reg'!E77*AC19","v":558.93881278538811},{"$f":"'Necessitats de reg'!F77*AD19","v":732.78958904109584},{"$f":"'Necessitats de reg'!G77*AE19","v":886.20000000000016},{"$f":"'Necessitats de reg'!H77*AF19","v":980.13333333333344},{"$f":"'Necessitats de reg'!I77*AG19","v":901.06666666666661},{"$f":"'Necessitats de reg'!J77*AH19","v":625.45205479452056},{"$f":"'Necessitats de reg'!K77*AI19","v":406.17972602739724},{"$f":"'Necessitats de reg'!L77*AJ19","v":223.6904109589041},{"$f":"'Necessitats de reg'!M77*AK19","v":160.55890410958909},{"$f":"(SUM(Z26:AK26)/1000)","v":6.3350734246575335},"m³/any"]
["Demanda total",{"$f":"B26+B25","v":10162.625570776256},{"$f":"C26+C25","v":9265.5515981735152},10411.886757990867,10218.938812785389,10714.789589041096,10546.2,10962.133333333333,10883.066666666666,10285.452054794521,10388.179726027398,9883.690410958905,10142.558904109588,{"$f":"N26+N25","v":10162.625570776256},{"$f":"O26+O25","v":9265.5515981735152},10411.886757990867,10218.938812785389,10714.789589041096,10546.2,10962.133333333333,10883.066666666666,10285.452054794521,10388.179726027398,9883.690410958905,10142.558904109588,{"$f":"Z26+Z25","v":10162.625570776256},{"$f":"AA26+AA25","v":9265.5515981735152},10411.886757990867,10218.938812785389,10714.789589041096,10546.2,10962.133333333333,10883.066666666666,10285.452054794521,10388.179726027398,9883.690410958905,10142.558904109588,{"$f":"(SUM(Z27:AK27)/1000)","v":123.86507342465754},"m³/any"]
["Dèficit aigua (l)",{"$f":"IF(B24-B27<0,B24-B27,0)","v":-10162.625570776256},{"$f":"IF(C24-C27<0,C24-C27,0)","v":-9265.5515981735152},-10411.886757990867,-10218.938812785389,-10714.789589041096,-10546.2,-10962.133333333333,-10883.066666666666,-10285.452054794521,-10388.179726027398,-9883.690410958905,-10142.558904109588,{"$f":"IF(N24-N27<0,N24-N27,0)","v":-10162.625570776256},{"$f":"IF(O24-O27<0,O24-O27,0)","v":-9265.5515981735152},-10411.886757990867,-10218.938812785389,-10714.789589041096,-10546.2,-10962.133333333333,-10883.066666666666,-10285.452054794521,-10388.179726027398,-9883.690410958905,-10142.558904109588,{"$f":"IF(Z24-Z27<0,Z24-Z27,0)","v":-10162.625570776256},{"$f":"IF(AA24-AA27<0,AA24-AA27,0)","v":-9265.5515981735152},-10411.886757990867,-10218.938812785389,-10714.789589041096,-10546.2,-10962.133333333333,-10883.066666666666,-10285.452054794521,-10388.179726027398,-9883.690410958905,-10142.558904109588,{"$f":"(SUM(Z28:AK28)/1000)","v":-123.86507342465754},"m³/any"]
["Sobrant aigua (l)",{"$f":"IF(B24-B27>0,B24-B27,0)","v":0},{"$f":"IF(C24-C27>0,C24-C27,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(N24-N27>0,N24-N27,0)","v":0},{"$f":"IF(O24-O27>0,O24-O27,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"IF(Z24-Z27>0,Z24-Z27,0)","v":0},{"$f":"IF(AA24-AA27>0,AA24-AA27,0)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"(SUM(Z29:AK29)/1000)","v":0},"m³/any"]
["Volum estalviat",{"$f":"B24-B29","v":0},{"$f":"C24-C29","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"(SUM(Z30:AK30))/1000","v":0},"m³/any"]

{"sheet":"Consum","index":8,"n_rows":31,"n_cols":11,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Dotacions","lpd",null,null,"Consum instantani","l/s",null,null,"Dotació mitjana (l/m³/dia)",3]
[null,"Dutxa",{"$f":"IF(C11=0,43,19.35)","v":43},{"$f":"IF(Formularis!C3=TRUE(),1,0)","v":1},null,"Rentamans",0.05]
[null,"Inodor (WC)",{"$f":"IF(C12=0,27,0)","v":27},{"$f":"IF(Formularis!C4=TRUE(),1,0)","v":1},null,"Lavabo",0.1,{"$f":"APLICATIU!Q22","v":1},null,"Tipus de planta","Coef. cultiu"]
[null,"Lavabo",{"$f":"IF(C10=0,23,11.5)","v":23},{"$f":"IF(Formularis!C5=TRUE(),1,0)","v":1},null,"Dutxa",0.2,{"$f":"APLICATIU!Q24","v":0},null,"Plantes de zona àrida",0.3]
[null,"Aixetes",{"$f":"IF(C10=0,47,23.5)","v":47},{"$f":"IF(Formularis!C6=TRUE(),1,0)","v":1},null,"Banyera ≥ 1,40 m",0.3,{"$f":"APLICATIU!Q26","v":0},null,"Fruites",0.7]
[null,"Rentadora",16,{"$f":"IF(Formularis!C7=TRUE(),1,0)","v":1},null,"Banyera < 1,40 m",0.2,{"$f":"APLICATIU!Q25","v":0},null,"Arbres",0.8]
[null,"Cuina",5,{"$f":"IF(Formularis!C8=TRUE(),1,0)","v":1},null,"Bidet",0.1,{"$f":"APLICATIU!Q28","v":0},null,"Arbustos",0.8]
[null,"Rentavaixelles",7,{"$f":"IF(Formularis!C9=TRUE(),1,0)","v":0},null,"Inodor amb cisterna",0.1,{"$f":"APLICATIU!Q29","v":1},null,"Flors",1]
[null,"Airejadors",{"$f":"IF(Formularis!C11=TRUE(),1,0)","v":0},null,null,"Inodor amb fluxor",1.25,{"$f":"APLICATIU!Q30","v":0},null,"Gespa",1]
[null,"Reguladors",{"$f":"IF(Formularis!C12=TRUE(),1,0)","v":0},null,null,"Pica",0.2,{"$f":"APLICATIU!S22","v":1},null,"Horta",1]
[null,"Inodors secs",{"$f":"IF(Formularis!C13=TRUE(),1,0)","v":0},null,null,"Rentavaixelles",0.15,{"$f":"APLICATIU!S24","v":0}]
[null,null,null,null,null,"Safareig",0.2,{"$f":"APLICATIU!S28","v":1},null,"Sistema de reg","Eficiència"]
[null,null,null,null,null,"Rentadora",0.2,{"$f":"APLICATIU!S29","v":0},null,"Mànega",0.65]
[null,null,null,null,null,"Aixeta aïllada",0.15,{"$f":"APLICATIU!S30","v":1},null,"Aspersió",0.75]
[null,"Dotació domèstica",{"$f":"SUMPRODUCT(C3:C9,D3:D9)","v":161},null,null,null,null,null,null,"Degoteig",0.8]
[null,"Residents",{"$f":"APLICATIU!D6","v":2}]
[null,"Grau d'ocupació",{"$f":"APLICATIU!D8","v":1},null,null,null,"Consum total",{"$f":"SUMPRODUCT(G4:G15,H4:H15)","v":0.75000000000000011}]
[null,"Dotació mitjana",{"$f":"C16*C17*C18","v":322},null,null,null,"Consum simultani",{"$f":"IF(H10=0,0.682*H18^0.45-0.14,1.7*H18^0.21-0.7)","v":0.45918639414233542},null,"Dotació mitjana reg",{"$f":"'Necessitats de reg'!N77","v":31.617204301075272}]
[null,null,null,null,null,null,null,{"$f":"H19*3.6","v":1.6530710189124076}]
[null,null,null,null,null,null,"Diàmetre necessari",{"$f":"SQRT(4*(H20/3600)/(2*PI()))*1000","v":17.097576954445451}]
[]
[]
[null,null,null,null,null,null,"Dint","DN"]
[null,null,null,null,null,{"$f":"IF(H21<=G25,1,0)","v":0},14,20]
[null,null,null,null,null,{"$f":"IF(AND($H$21<=G26,$H$21>G25),1,0)","v":1},18,25]
[null,null,null,null,null,{"$f":"IF(AND($H$21<=G27,$H$21>G26),1,0)","v":0},23.2,32]
[null,null,null,null,null,0,29,40]
[null,null,null,null,null,0,36.200000000000003,50]
[null,null,null,null,null,0,45.8,63]
[null,null,null,null,null,0,55.4,75]

{"sheet":"Necessitats de reg","index":9,"n_rows":77,"n_cols":19,"rows_kept":77,"cut":false,"hidden":true,"merged":[[15,18,16,18],[10,15,12,15],[15,15,16,15],[10,16,12,16],[10,17,12,17],[10,18,12,18],[15,16,16,16],[15,17,16,17]]}
[]
[null,31,28,31,30,31,30,31,31,30,31,30,31]
["Mes","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre ","Novembre","Desembre"]
["Eto mitjana (mm/mes)",29.68,39.97,66.98,84.35,110.4,132.93,147.02000000000001,135.16,94.56,62.55,35.97,26.67,null,null,"Sistema de reg","Eficiència"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mànega",0.65]
["Plantes zona àrida",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aspersió",0.75]
["Coeficient cultiu",0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,0.3,null,null,"Degoteig",0.8]
["Demanda de reg",{"$f":"B7*(IF('Dades meteorològiques'!C11=0,'Necessitats de reg'!B4,'Dades meteorològiques'!C11))","v":8.9039999999999999},{"$f":"C7*(IF('Dades meteorològiques'!D11=0,'Necessitats de reg'!C4,'Dades meteorològiques'!D11))","v":11.991},{"$f":"D7*(IF('Dades meteorològiques'!E11=0,'Necessitats de reg'!D4,'Dades meteorològiques'!E11))","v":20.094000000000001},{"$f":"E7*(IF('Dades meteorològiques'!F11=0,'Necessitats de reg'!E4,'Dades meteorològiques'!F11))","v":25.304999999999996},{"$f":"F7*(IF('Dades meteorològiques'!G11=0,'Necessitats de reg'!F4,'Dades meteorològiques'!G11))","v":33.119999999999997},{"$f":"G7*(IF('Dades meteorològiques'!H11=0,'Necessitats de reg'!G4,'Dades meteorològiques'!H11))","v":39.878999999999998},{"$f":"H7*(IF('Dades meteorològiques'!I11=0,'Necessitats de reg'!H4,'Dades meteorològiques'!I11))","v":44.106000000000002},{"$f":"I7*(IF('Dades meteorològiques'!J11=0,'Necessitats de reg'!I4,'Dades meteorològiques'!J11))","v":40.547999999999995},{"$f":"J7*(IF('Dades meteorològiques'!K11=0,'Necessitats de reg'!J4,'Dades meteorològiques'!K11))","v":28.367999999999999},{"$f":"K7*(IF('Dades meteorològiques'!L11=0,'Necessitats de reg'!K4,'Dades meteorològiques'!L11))","v":18.764999999999997},{"$f":"L7*(IF('Dades meteorològiques'!M11=0,'Necessitats de reg'!L4,'Dades meteorològiques'!M11))","v":10.790999999999999},{"$f":"M7*(IF('Dades meteorològiques'!N11=0,'Necessitats de reg'!M4,'Dades meteorològiques'!N11))","v":8.0009999999999994},null,null,0,0]
["Demanda de reg (l/mes)",{"$f":"APLICATIU!$E$18*B8","v":0},{"$f":"APLICATIU!$E$18*C8","v":0},{"$f":"APLICATIU!$E$18*D8","v":0},{"$f":"APLICATIU!$E$18*E8","v":0},{"$f":"APLICATIU!$E$18*F8","v":0},{"$f":"APLICATIU!$E$18*G8","v":0},{"$f":"APLICATIU!$E$18*H8","v":0},{"$f":"APLICATIU!$E$18*I8","v":0},{"$f":"APLICATIU!$E$18*J8","v":0},{"$f":"APLICATIU!$E$18*K8","v":0},{"$f":"APLICATIU!$E$18*L8","v":0},{"$f":"APLICATIU!$E$18*M8","v":0}]
["Demanda de reg (l/dia)",{"$f":"B9/B2","v":0},0,0,0,0,0,0,0,0,0,0,0,null,null,"Vegetació","Superfície (m²)","Sistema de reg ","Eficiència"]
["Demanda segons sistema reg (l/dia)",{"$f":"B10/$S$11","v":0},{"$f":"C10/$S$11","v":0},0,0,0,0,0,0,0,0,0,0,null,null,"Plantes de zona àrida",{"$f":"APLICATIU!$E$18","v":0},{"$f":"APLICATIU!D19","v":"Mànega"},{"$f":"VLOOKUP(R11,$P$5:$Q$8,2,FALSE)","v":0.65}]
[]
["Fruites"]
["Coeficient cultiu",0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,0.7,null,null,"Fruites",{"$f":"APLICATIU!$E$20","v":0},{"$f":"APLICATIU!D20","v":"Mànega"},{"$f":"VLOOKUP(R14,$P$5:$Q$8,2,FALSE)","v":0.65}]
["Demanda de reg",{"$f":"B14*(IF('Dades meteorològiques'!C11=0,'Necessitats de reg'!B4,'Dades meteorològiques'!C11))","v":20.776},{"$f":"C14*(IF('Dades meteorològiques'!D11=0,'Necessitats de reg'!C4,'Dades meteorològiques'!D11))","v":27.978999999999999},{"$f":"D14*(IF('Dades meteorològiques'!E11=0,'Necessitats de reg'!D4,'Dades meteorològiques'!E11))","v":46.886000000000003},{"$f":"E14*(IF('Dades meteorològiques'!F11=0,'Necessitats de reg'!E4,'Dades meteorològiques'!F11))","v":59.044999999999995},{"$f":"F14*(IF('Dades meteorològiques'!G11=0,'Necessitats de reg'!F4,'Dades meteorològiques'!G11))","v":77.28},{"$f":"G14*(IF('Dades meteorològiques'!H11=0,'Necessitats de reg'!G4,'Dades meteorològiques'!H11))","v":93.051000000000002},{"$f":"H14*(IF('Dades meteorològiques'!I11=0,'Necessitats de reg'!H4,'Dades meteorològiques'!I11))","v":102.914},{"$f":"I14*(IF('Dades meteorològiques'!J11=0,'Necessitats de reg'!I4,'Dades meteorològiques'!J11))","v":94.611999999999995},{"$f":"J14*(IF('Dades meteorològiques'!K11=0,'Necessitats de reg'!J4,'Dades meteorològiques'!K11))","v":66.191999999999993},{"$f":"K14*(IF('Dades meteorològiques'!L11=0,'Necessitats de reg'!K4,'Dades meteorològiques'!L11))","v":43.784999999999997},{"$f":"L14*(IF('Dades meteorològiques'!M11=0,'Necessitats de reg'!L4,'Dades meteorològiques'!M11))","v":25.178999999999998},{"$f":"M14*(IF('Dades meteorològiques'!N11=0,'Necessitats de reg'!M4,'Dades meteorològiques'!N11))","v":18.669},null,null,"Arbres",{"$f":"APLICATIU!$E$21","v":0},{"$f":"APLICATIU!D21","v":"Mànega"},{"$f":"VLOOKUP(R15,$P$5:$Q$8,2,FALSE)","v":0.65}]
["Demanda de reg (l/mes)",{"$f":"APLICATIU!$E$20*B15","v":0},{"$f":"APLICATIU!$E$20*C15","v":0},{"$f":"APLICATIU!$E$20*D15","v":0},{"$f":"APLICATIU!$E$20*E15","v":0},{"$f":"APLICATIU!$E$20*F15","v":0},{"$f":"APLICATIU!$E$20*G15","v":0},{"$f":"APLICATIU!$E$20*H15","v":0},{"$f":"APLICATIU!$E$20*I15","v":0},{"$f":"APLICATIU!$E$20*J15","v":0},{"$f":"APLICATIU!$E$20*K15","v":0},{"$f":"APLICATIU!$E$20*L15","v":0},{"$f":"APLICATIU!$E$20*M15","v":0},null,null,"Arbustos",{"$f":"APLICATIU!$E$22","v":0},{"$f":"APLICATIU!D22","v":"Mànega"},{"$f":"VLOOKUP(R16,$P$5:$Q$8,2,FALSE)","v":0.65}]
["Demanda de reg (l/dia)",{"$f":"B16/B2","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Demanda segons sistema reg (l/dia)",{"$f":"B17/$S$14","v":0},{"$f":"C17/$S$14","v":0},0,0,0,0,0,0,0,0,0,0,null,null,"Flors",{"$f":"APLICATIU!$E$24","v":0},{"$f":"APLICATIU!D24","v":"Mànega"},{"$f":"VLOOKUP(R18,$P$5:$Q$8,2,FALSE)","v":0.65}]
[]
["Arbres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gespa",{"$f":"APLICATIU!$E$25","v":5},{"$f":"APLICATIU!D25","v":"Aspersió"},{"$f":"VLOOKUP(R20,$P$5:$Q$7,2,FALSE)","v":0.75}]
["Coeficient cultiu",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,null,null,"Horta",{"$f":"APLICATIU!$E$26","v":0},{"$f":"APLICATIU!D26","v":"Mànega"},{"$f":"VLOOKUP(R21,$P$5:$Q$8,2,FALSE)","v":0.65}]
["Demanda de reg",{"$f":"B21*(IF('Dades meteorològiques'!C11=0,'Necessitats de reg'!B4,'Dades meteorològiques'!C11))","v":23.744},{"$f":"C21*(IF('Dades meteorològiques'!D11=0,'Necessitats de reg'!C4,'Dades meteorològiques'!D11))","v":31.975999999999999},{"$f":"D21*(IF('Dades meteorològiques'!E11=0,'Necessitats de reg'!D4,'Dades meteorològiques'!E11))","v":53.584000000000003},{"$f":"E21*(IF('Dades meteorològiques'!F11=0,'Necessitats de reg'!E4,'Dades meteorològiques'!F11))","v":67.48},{"$f":"F21*(IF('Dades meteorològiques'!G11=0,'Necessitats de reg'!F4,'Dades meteorològiques'!G11))","v":88.320000000000007},{"$f":"G21*(IF('Dades meteorològiques'!H11=0,'Necessitats de reg'!G4,'Dades meteorològiques'!H11))","v":106.34400000000001},{"$f":"H21*(IF('Dades meteorològiques'!I11=0,'Necessitats de reg'!H4,'Dades meteorològiques'!I11))","v":117.61600000000001},{"$f":"I21*(IF('Dades meteorològiques'!J11=0,'Necessitats de reg'!I4,'Dades meteorològiques'!J11))","v":108.128},{"$f":"J21*(IF('Dades meteorològiques'!K11=0,'Necessitats de reg'!J4,'Dades meteorològiques'!K11))","v":75.64800000000001},{"$f":"K21*(IF('Dades meteorològiques'!L11=0,'Necessitats de reg'!K4,'Dades meteorològiques'!L11))","v":50.04},{"$f":"L21*(IF('Dades meteorològiques'!M11=0,'Necessitats de reg'!L4,'Dades meteorològiques'!M11))","v":28.776},{"$f":"M21*(IF('Dades meteorològiques'!N11=0,'Necessitats de reg'!M4,'Dades meteorològiques'!N11))","v":21.336000000000002},null,null,"Total",{"$f":"SUM(Q11:Q21)","v":5}]
["Demanda de reg (l/mes)",{"$f":"APLICATIU!$E$21*B22","v":0},{"$f":"APLICATIU!$E$21*C22","v":0},{"$f":"APLICATIU!$E$21*D22","v":0},{"$f":"APLICATIU!$E$21*E22","v":0},{"$f":"APLICATIU!$E$21*F22","v":0},{"$f":"APLICATIU!$E$21*G22","v":0},{"$f":"APLICATIU!$E$21*H22","v":0},{"$f":"APLICATIU!$E$21*I22","v":0},{"$f":"APLICATIU!$E$21*J22","v":0},{"$f":"APLICATIU!$E$21*K22","v":0},{"$f":"APLICATIU!$E$21*L22","v":0},{"$f":"APLICATIU!$E$21*M22","v":0}]
["Demanda de reg (l/dia)",{"$f":"B23/B2","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Demanda segons sistema reg (l/dia)",{"$f":"B24/$S$15","v":0},{"$f":"C24/$S$15","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Arbustos"]
["Coeficient cultiu",0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8,0.8]
["Demanda de reg",{"$f":"B28*(IF('Dades meteorològiques'!C11=0,'Necessitats de reg'!B4,'Dades meteorològiques'!C11))","v":23.744},{"$f":"C28*(IF('Dades meteorològiques'!D11=0,'Necessitats de reg'!C4,'Dades meteorològiques'!D11))","v":31.975999999999999},{"$f":"D28*(IF('Dades meteorològiques'!E11=0,'Necessitats de reg'!D4,'Dades meteorològiques'!E11))","v":53.584000000000003},{"$f":"E28*(IF('Dades meteorològiques'!F11=0,'Necessitats de reg'!E4,'Dades meteorològiques'!F11))","v":67.48},{"$f":"F28*(IF('Dades meteorològiques'!G11=0,'Necessitats de reg'!F4,'Dades meteorològiques'!G11))","v":88.320000000000007},{"$f":"G28*(IF('Dades meteorològiques'!H11=0,'Necessitats de reg'!G4,'Dades meteorològiques'!H11))","v":106.34400000000001},{"$f":"H28*(IF('Dades meteorològiques'!I11=0,'Necessitats de reg'!H4,'Dades meteorològiques'!I11))","v":117.61600000000001},{"$f":"I28*(IF('Dades meteorològiques'!J11=0,'Necessitats de reg'!I4,'Dades meteorològiques'!J11))","v":108.128},{"$f":"J28*(IF('Dades meteorològiques'!K11=0,'Necessitats de reg'!J4,'Dades meteorològiques'!K11))","v":75.64800000000001},{"$f":"K28*(IF('Dades meteorològiques'!L11=0,'Necessitats de reg'!K4,'Dades meteorològiques'!L11))","v":50.04},{"$f":"L28*(IF('Dades meteorològiques'!M11=0,'Necessitats de reg'!L4,'Dades meteorològiques'!M11))","v":28.776},{"$f":"M28*(IF('Dades meteorològiques'!N11=0,'Necessitats de reg'!M4,'Dades meteorològiques'!N11))","v":21.336000000000002}]
["Demanda de reg (l/mes)",{"$f":"APLICATIU!$E$22*B29","v":0},{"$f":"APLICATIU!$E$22*C29","v":0},{"$f":"APLICATIU!$E$22*D29","v":0},{"$f":"APLICATIU!$E$22*E29","v":0},{"$f":"APLICATIU!$E$22*F29","v":0},{"$f":"APLICATIU!$E$22*G29","v":0},{"$f":"APLICATIU!$E$22*H29","v":0},{"$f":"APLICATIU!$E$22*I29","v":0},{"$f":"APLICATIU!$E$22*J29","v":0},{"$f":"APLICATIU!$E$22*K29","v":0},{"$f":"APLICATIU!$E$22*L29","v":0},{"$f":"APLICATIU!$E$22*M29","v":0}]
["Demanda de reg (l/dia)",{"$f":"B30/B2","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Demanda segons sistema reg (l/dia)",{"$f":"B31/$S$16","v":0},{"$f":"C31/$S$16","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Flors"]
["Coeficient cultiu",1,1,1,1,1,1,1,1,1,1,1,1]
["Demanda de reg",{"$f":"B35*(IF('Dades meteorològiques'!C11=0,'Necessitats de reg'!B4,'Dades meteorològiques'!C11))","v":29.68},{"$f":"C35*(IF('Dades meteorològiques'!D11=0,'Necessitats de reg'!C4,'Dades meteorològiques'!D11))","v":39.97},{"$f":"D35*(IF('Dades meteorològiques'!E11=0,'Necessitats de reg'!D4,'Dades meteorològiques'!E11))","v":66.98},{"$f":"E35*(IF('Dades meteorològiques'!F11=0,'Necessitats de reg'!E4,'Dades meteorològiques'!F11))","v":84.35},{"$f":"F35*(IF('Dades meteorològiques'!G11=0,'Necessitats de reg'!F4,'Dades meteorològiques'!G11))","v":110.4},{"$f":"G35*(IF('Dades meteorològiques'!H11=0,'Necessitats de reg'!G4,'Dades meteorològiques'!H11))","v":132.93},{"$f":"H35*(IF('Dades meteorològiques'!I11=0,'Necessitats de reg'!H4,'Dades meteorològiques'!I11))","v":147.02000000000001},{"$f":"I35*(IF('Dades meteorològiques'!J11=0,'Necessitats de reg'!I4,'Dades meteorològiques'!J11))","v":135.16},{"$f":"J35*(IF('Dades meteorològiques'!K11=0,'Necessitats de reg'!J4,'Dades meteorològiques'!K11))","v":94.56},{"$f":"K35*(IF('Dades meteorològiques'!L11=0,'Necessitats de reg'!K4,'Dades meteorològiques'!L11))","v":62.55},{"$f":"L35*(IF('Dades meteorològiques'!M11=0,'Necessitats de reg'!L4,'Dades meteorològiques'!M11))","v":35.97},{"$f":"M35*(IF('Dades meteorològiques'!N11=0,'Necessitats de reg'!M4,'Dades meteorològiques'!N11))","v":26.67}]
["Demanda de reg (l/mes)",{"$f":"APLICATIU!$E$24*B36","v":0},{"$f":"APLICATIU!$E$24*C36","v":0},{"$f":"APLICATIU!$E$24*D36","v":0},{"$f":"APLICATIU!$E$24*E36","v":0},{"$f":"APLICATIU!$E$24*F36","v":0},{"$f":"APLICATIU!$E$24*G36","v":0},{"$f":"APLICATIU!$E$24*H36","v":0},{"$f":"APLICATIU!$E$24*I36","v":0},{"$f":"APLICATIU!$E$24*J36","v":0},{"$f":"APLICATIU!$E$24*K36","v":0},{"$f":"APLICATIU!$E$24*L36","v":0},{"$f":"APLICATIU!$E$24*M36","v":0}]
["Demanda de reg (l/dia)",{"$f":"B37/B2","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Demanda segons sistema reg (l/dia)",{"$f":"B38/$S$18","v":0},{"$f":"C38/$S$18","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Gespa"]
["Coeficient cultiu",1,1,1,1,1,1,1,1,1,1,1,1]
["Demanda de reg",{"$f":"B42*(IF('Dades meteorològiques'!C11=0,'Necessitats de reg'!B4,'Dades meteorològiques'!C11))","v":29.68},{"$f":"C42*(IF('Dades meteorològiques'!D11=0,'Necessitats de reg'!C4,'Dades meteorològiques'!D11))","v":39.97},{"$f":"D42*(IF('Dades meteorològiques'!E11=0,'Necessitats de reg'!D4,'Dades meteorològiques'!E11))","v":66.98},{"$f":"E42*(IF('Dades meteorològiques'!F11=0,'Necessitats de reg'!E4,'Dades meteorològiques'!F11))","v":84.35},{"$f":"F42*(IF('Dades meteorològiques'!G11=0,'Necessitats de reg'!F4,'Dades meteorològiques'!G11))","v":110.4},{"$f":"G42*(IF('Dades meteorològiques'!H11=0,'Necessitats de reg'!G4,'Dades meteorològiques'!H11))","v":132.93},{"$f":"H42*(IF('Dades meteorològiques'!I11=0,'Necessitats de reg'!H4,'Dades meteorològiques'!I11))","v":147.02000000000001},{"$f":"I42*(IF('Dades meteorològiques'!J11=0,'Necessitats de reg'!I4,'Dades meteorològiques'!J11))","v":135.16},{"$f":"J42*(IF('Dades meteorològiques'!K11=0,'Necessitats de reg'!J4,'Dades meteorològiques'!K11))","v":94.56},{"$f":"K42*(IF('Dades meteorològiques'!L11=0,'Necessitats de reg'!K4,'Dades meteorològiques'!L11))","v":62.55},{"$f":"L42*(IF('Dades meteorològiques'!M11=0,'Necessitats de reg'!L4,'Dades meteorològiques'!M11))","v":35.97},{"$f":"M42*(IF('Dades meteorològiques'!N11=0,'Necessitats de reg'!M4,'Dades meteorològiques'!N11))","v":26.67}]
["Demanda de reg (l/mes)",{"$f":"APLICATIU!$E$25*B43","v":148.4},{"$f":"APLICATIU!$E$25*C43","v":199.85},{"$f":"APLICATIU!$E$25*D43","v":334.90000000000003},{"$f":"APLICATIU!$E$25*E43","v":421.75},{"$f":"APLICATIU!$E$25*F43","v":552},{"$f":"APLICATIU!$E$25*G43","v":664.65000000000009},{"$f":"APLICATIU!$E$25*H43","v":735.1},{"$f":"APLICATIU!$E$25*I43","v":675.8},{"$f":"APLICATIU!$E$25*J43","v":472.8},{"$f":"APLICATIU!$E$25*K43","v":312.75},{"$f":"APLICATIU!$E$25*L43","v":179.85},{"$f":"APLICATIU!$E$25*M43","v":133.35000000000002}]
["Demanda de reg (l/dia)",{"$f":"B44/B2","v":4.7870967741935484},7.1375000000000002,10.803225806451614,14.058333333333334,17.806451612903224,22.155000000000005,23.712903225806453,21.799999999999997,15.76,10.088709677419354,5.9950000000000001,4.3016129032258075]
["Demanda segons sistema reg (l/dia)",{"$f":"B45/$S$20","v":6.3827956989247312},{"$f":"C45/$S$20","v":9.5166666666666675},14.404301075268819,18.744444444444444,23.741935483870964,29.540000000000006,31.617204301075272,29.066666666666663,21.013333333333332,13.451612903225806,7.9933333333333332,5.7354838709677436]
[]
["Horta"]
["Coeficient cultiu",1,1,1,1,1,1,1,1,1,1,1,1]
["Demanda de reg",{"$f":"B49*(IF('Dades meteorològiques'!C11=0,'Necessitats de reg'!B4,'Dades meteorològiques'!C11))","v":29.68},{"$f":"C49*(IF('Dades meteorològiques'!D11=0,'Necessitats de reg'!C4,'Dades meteorològiques'!D11))","v":39.97},{"$f":"D49*(IF('Dades meteorològiques'!E11=0,'Necessitats de reg'!D4,'Dades meteorològiques'!E11))","v":66.98},{"$f":"E49*(IF('Dades meteorològiques'!F11=0,'Necessitats de reg'!E4,'Dades meteorològiques'!F11))","v":84.35},{"$f":"F49*(IF('Dades meteorològiques'!G11=0,'Necessitats de reg'!F4,'Dades meteorològiques'!G11))","v":110.4},{"$f":"G49*(IF('Dades meteorològiques'!H11=0,'Necessitats de reg'!G4,'Dades meteorològiques'!H11))","v":132.93},{"$f":"H49*(IF('Dades meteorològiques'!I11=0,'Necessitats de reg'!H4,'Dades meteorològiques'!I11))","v":147.02000000000001},{"$f":"I49*(IF('Dades meteorològiques'!J11=0,'Necessitats de reg'!I4,'Dades meteorològiques'!J11))","v":135.16},{"$f":"J49*(IF('Dades meteorològiques'!K11=0,'Necessitats de reg'!J4,'Dades meteorològiques'!K11))","v":94.56},{"$f":"K49*(IF('Dades meteorològiques'!L11=0,'Necessitats de reg'!K4,'Dades meteorològiques'!L11))","v":62.55},{"$f":"L49*(IF('Dades meteorològiques'!M11=0,'Necessitats de reg'!L4,'Dades meteorològiques'!M11))","v":35.97},{"$f":"M49*(IF('Dades meteorològiques'!N11=0,'Necessitats de reg'!M4,'Dades meteorològiques'!N11))","v":26.67}]
["Demanda de reg (l/mes)",{"$f":"APLICATIU!$E$26*B50","v":0},{"$f":"APLICATIU!$E$26*C50","v":0},{"$f":"APLICATIU!$E$26*D50","v":0},{"$f":"APLICATIU!$E$26*E50","v":0},{"$f":"APLICATIU!$E$26*F50","v":0},{"$f":"APLICATIU!$E$26*G50","v":0},{"$f":"APLICATIU!$E$26*H50","v":0},{"$f":"APLICATIU!$E$26*I50","v":0},{"$f":"APLICATIU!$E$26*J50","v":0},{"$f":"APLICATIU!$E$26*K50","v":0},{"$f":"APLICATIU!$E$26*L50","v":0},{"$f":"APLICATIU!$E$26*M50","v":0}]
["Demanda de reg (l/dia)",{"$f":"B51/B2","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Demanda segons sistema reg (l/dia)",{"$f":"B52/$S$21","v":0},{"$f":"C52/$S$21","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[]
[{"$f":"APLICATIU!I4","v":"Sant Andreu"},31,28,31,30,31,30,31,31,30,31,30,31]
["Mes","Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre ","Novembre","Desembre"]
["Pluviometria (mm)",{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,2,FALSE)","v":58},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,3,FALSE)","v":63},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,4,FALSE)","v":56},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,5,FALSE)","v":59},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,6,FALSE)","v":54},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,7,FALSE)","v":30},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,8,FALSE)","v":20},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,9,FALSE)","v":46},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,10,FALSE)","v":86},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,11,FALSE)","v":91},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,12,FALSE)","v":56},{"$f":"VLOOKUP(APLICATIU!$I$4,'Aigua recollida'!$A$22:$M$213,13,FALSE)","v":58}]
["Pluja útil (%)",100,100,100,20,20,0,0,0,20,40,100,100]
["Plúja útil (l/m²)",{"$f":"(B58*B59)/100","v":58},{"$f":"(C58*C59)/100","v":63},56,11.8,10.8,{"$f":"(G58*G59)/100","v":0},{"$f":"(H58*H59)/100","v":0},{"$f":"(I58*I59)/100","v":0},17.2,{"$f":"(K58*K59)/100","v":36.4},{"$f":"(L58*L59)/100","v":56},{"$f":"(M58*M59)/100","v":58}]
["Infiltració (%)",70,70,70,70,70,70,70,70,70,70,70,70]
["Pluja infiltrada (l/m²/mes) ",{"$f":"(B60*B61)/100","v":40.6},{"$f":"(C60*C61)/100","v":44.1},39.200000000000003,8.26,7.56,0,0,0,12.04,25.48,39.200000000000003,40.6]
["Pluja infiltrada (l/m²/dia)",{"$f":"B62/365","v":0.11123287671232877},{"$f":"C62/365","v":0.12082191780821919},0.10739726027397262,2.2630136986301369E-2,2.0712328767123287E-2,0,0,0,3.2986301369863011E-2,6.9808219178082193E-2,0.10739726027397262,0.11123287671232877]
[]
[]
[null,"Gener","Febrer","Març","Abril","Maig","Juny","Juliol","Agost","Setembre","Octubre ","Novembre","Desembre"]
["Plantes zona àrida",{"$f":"B11","v":0},{"$f":"C11","v":0},0,0,0,0,0,0,0,0,0,0]
["Fruites",{"$f":"B18","v":0},{"$f":"C18","v":0},0,0,0,0,0,0,0,0,0,0]
["Arbres",{"$f":"B25","v":0},{"$f":"C25","v":0},0,0,0,0,0,0,0,0,0,0]
["Arbustos",{"$f":"B32","v":0},{"$f":"C32","v":0},0,0,0,0,0,0,0,0,0,0]
["Flors",{"$f":"B39","v":0},{"$f":"C39","v":0},0,0,0,0,0,0,0,0,0,0]
["Gespa",{"$f":"B46","v":6.3827956989247312},{"$f":"C46","v":9.5166666666666675},14.404301075268819,18.744444444444444,23.741935483870964,29.540000000000006,31.617204301075272,29.066666666666663,21.013333333333332,13.451612903225806,7.9933333333333332,5.7354838709677436]
["Horta",{"$f":"B53","v":0},{"$f":"C52","v":0},0,0,0,0,0,0,0,0,0,0]
["Total demanda diaria (l/dia)",{"$f":"SUM(B67:B73)","v":6.3827956989247312},{"$f":"SUM(C67:C73)","v":9.5166666666666675},{"$f":"SUM(D67:D73)","v":14.404301075268819},18.744444444444444,23.741935483870964,29.540000000000006,31.617204301075272,29.066666666666663,21.013333333333332,13.451612903225806,7.9933333333333332,5.7354838709677436]
["Pluja infiltrada diària (l)",{"$f":"B63*$Q$22","v":0.55616438356164388},{"$f":"C63*$Q$22","v":0.60410958904109591},0.53698630136986303,0.11315068493150685,0.10356164383561643,0,0,0,0.16493150684931507,0.34904109589041099,{"$f":"L63*$Q$22","v":0.53698630136986303},0.55616438356164388]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Màxim"]
["Demanda diària (l/dia) ",{"$f":"B74-B75","v":5.8266313153630875},{"$f":"C74-C75","v":8.9125570776255714},13.867314773898956,18.631293759512936,23.638373840035349,29.540000000000006,31.617204301075272,29.066666666666663,20.848401826484018,13.102571807335394,7.4563470319634702,5.1793194874060999,{"$f":"MAX(B77:M77)","v":31.617204301075272}]

{"sheet":"Tarifes","index":10,"n_rows":32,"n_cols":27,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[null,"CANONADES PE40 PN10",null,null,"BAIXANTS PVC",null,null,"DIPÒSITS",null,null,"DIPÒSITS CLORACIÓ",null,null,null,null,null,null,"FILTRE",null,null,"GRUP PRESSIÓ"]
[null,"DN","Preu",null,"DN","Preu",null,"Volum","Preu",null,"Volum","Dipòsit","Tapa","Total","Caseta","Preu",null,"Superfície","Preu",null,"Pressió","Cabal","Potència","Preu"]
[null,20,1.77,{"$f":"IF(#REF!<=B4,1,0)","v":{"$error":"#REF!"}},75,4.7300000000000004,null,1.3,245,null,43,69.94,18.510000000000002,{"$f":"L4+M4","v":88.45},"1,28x1,96x0,94",249,null,80,25.5,null,34,4.2,0.65,358]
[null,25,2.7,{"$f":"IF(AND($H$21<=B5,$H$21>B4),1,0)","v":0},null,null,null,2.6,570,null,94,83.31,21.6,{"$f":"L5+M5","v":104.91},"1,28x1,96x0,94",249,null,160,{"$f":"S4+25.5","v":51},null,45,4.2,0.77,370.8]
[null,32,4.45,{"$f":"IF(AND($H$21<=B6,$H$21>B5),1,0)","v":0},"Coef. accessoris",0.5,null,3.2,755,null,190,159.41999999999999,26.74,186.16,"1,28x1,96x0,94",249,null,240,{"$f":"S5+25.5","v":76.5},null,58,4.2,1.01,392.7,null,"Cabal",{"$f":"APLICATIU!O33","v":1.6530710189124076}]
[null,40,6.9,0,null,null,null,3.9,825,null,297,171.76,31.88,203.64,"1,86x2,26x1,25",399,null,320,102,null,35,7.2,0.78,443,null,"Pressió",{"$f":"APLICATIU!R33","v":22.5}]
[null,50,10.66,0,null,null,null,4.8,1150,null,486,212.9,42.17,255.07,"1,86x2,26x1,25",399,null,400,127.5,null,47,7.2,1.07,448.4,null,"Cabal 4,20",{"$f":"IF(AND(AA6<=V4,AA7<=U4),X4,IF(AND(AA6<=V5,AA7<=U5),X5,IF(AND(AA6<=V6,AA7<=U6),X6,FALSE)))","v":358}]
[null,63,16.649999999999999,0,null,null,null,6.4,1540,null,905,338.38,48.34,386.72,"1,85x2,26x1,83",545,null,null,null,null,59,7.2,1.31,532.5,null,"Cabal 7,20",{"$f":"IF(AND(AA6<=V7,AA7<=U7),X7,IF(AND(AA6<=V8,AA7<=U8),X8,IF(AND(AA6<=V9,AA7<=U9),X9,FALSE)))","v":443}]
[null,75,23.85,0,null,null,null,9,2800,null,1002,370.26,48.34,418.6,"1,85x2,26x1,83",545,null,"Aixeta",10.199999999999999,null,null,null,null,null,null,"Cabal màxim",{"$f":"IF(AA6<=V4,V4,V7)","v":4.2}]
[null,null,null,null,null,null,null,null,null,null,1050,397,91.54,488.54,"1,85x2,26x1,83",545,null,null,null,null,"Regulador",110]
[null,"Coef. accessoris",8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sobreeixidor",2.4500000000000002,null,null,null,null,null,null,"Preu",{"$f":"IF(AA10=7.2,AA9,AA8)","v":358}]
[null,null,null,null,null,null,null,null,null,null,"Dosificador",685.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"BOIA"]
[null,null,null,null,null,null,null,"CASETA",null,null,"COMPTADOR EMISSOR D'IMPULSOS",null,null,null,null,null,null,"Diàmetre","Preu",null,"mm","Polzades"]
[null,"Diàmetre canonada",{"$f":"VLOOKUP(1,Consum!F25:H30,3,FALSE)","v":25},null,null,null,null,"Dimensions","Preu",null,"Diàmetre","Preu",null,null,null,null,null,0.375,44.38,null,20,0.75]
[null,"Preu",{"$f":"VLOOKUP(C16,B4:C10,2,FALSE)","v":2.7},null,null,null,null,"1,28x1,96x0,94",249,null,0.5,144,null,null,null,null,null,0.5,50.87,null,25,1]
[null,null,null,null,null,null,null,"1,86x2,26x1,25",399,null,0.75,152.5,null,null,null,null,null,0.75,76.510000000000005,null,32,1.25]
[null,null,null,null,null,null,null,"1,85x2,26x1,83",545,null,1,265.5,null,null,null,null,null,1,102.71,null,40,1.5]
[null,null,null,null,null,null,null,null,null,null,1.25,302.89999999999998,null,null,null,null,null,1.25,145.81,null,50,2]
[null,null,null,null,null,null,null,null,null,null,1.5,474.5,null,null,null,null,null,1.5,183.94,null,63,2.5]
[null,null,null,null,null,null,null,null,null,null,2,890.3,null,null,null,null,null,2,264.92,null,75,3]
[]
[null,null,null,null,null,null,null,null,null,null,"Diàm. Comptador",{"$f":"VLOOKUP(C16,U16:V22,2,FALSE)","v":1},null,null,null,null,null,"Polzades boia",{"$f":"VLOOKUP(C16,U16:V22,2,FALSE)","v":1}]
[]
[null,"RAJOS UV",null,null,null,"Recanvis"]
[null,"Cabal","Làmpada UV","Bomba",null,"Cabal","Làmpada","Tub quars"]
[null,0.2,120.1,506,null,0.2,38.4,12.9]
[null,0.6,184.3,440,null,0.6,71.599999999999994,59.8]
[null,1.4,504.1,484,null,1.4,105.6,52.8]
[]
[null,"Cabal recirculació",{"$f":"IF(AND(APLICATIU!Q11>0,APLICATIU!Q11<=0.2),0.2,IF(AND(APLICATIU!Q11>0.2,APLICATIU!Q11<=0.6),0.6,IF(AND(APLICATIU!Q11>0.6,APLICATIU!Q11<=1.4),1.4,IF(AND(APLICATIU!Q11>1.4,APLICATIU!Q11<=400),1.4,FALSE))))","v":0.2}]

{"sheet":"Pressupost","index":11,"n_rows":82,"n_cols":6,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
[]
[]
["RECOL·LECCIÓ I EMMAGATZEMATGE D'AIGÜES PLUVIALS"]
[]
[]
["Codi","Concepte","Preu unitari","Amidament","Import (sense IVA)"]
[1,"Dipòsit",{"$f":"VLOOKUP(F7,Tarifes!H4:I10,2,FALSE)","v":825},1,{"$f":"C7*D7","v":825},{"$f":"IF(AND(APLICATIU!J29>0,APLICATIU!J29<=1.3),1.3,IF(AND(APLICATIU!J29>1.3,APLICATIU!J29<=2.6),2.6,IF(AND(APLICATIU!J29>2.6,APLICATIU!J29<=3.2),3.2,IF(AND(APLICATIU!J29>3.2,APLICATIU!J29<=3.9),3.9,IF(AND(APLICATIU!J29>3.9,APLICATIU!J29<=4.8),4.8,IF(AND(APLICATIU!J29>4.8,APLICATIU!J29<=6.4),6.4,IF(AND(APLICATIU!J29>6.4,APLICATIU!J29<=9),9,IF(AND(APLICATIU!J29>9,APLICATIU!J29<=10000000),9))))))))","v":3.9}]
[2,"Filtre",{"$f":"VLOOKUP(F8,Tarifes!R4:S8,2,FALSE)","v":25.5},1,{"$f":"C8*D8","v":25.5},{"$f":"IF(AND(APLICATIU!J8>0,APLICATIU!J8<=80),80,IF(AND(APLICATIU!J8>80,APLICATIU!J8<=160),160,IF(AND(APLICATIU!J8>160,APLICATIU!J8<=240),240,IF(AND(APLICATIU!J8>240,APLICATIU!J8<=320),320,IF(AND(APLICATIU!J8>320,APLICATIU!J8<=400),400,FALSE)))))","v":80}]
[3,"Aixeta",{"$f":"Tarifes!S10","v":10.199999999999999},1,10.199999999999999]
[4,"Sobreeixidor d'emergència,",{"$f":"Tarifes!S12","v":2.4500000000000002},2,{"$f":"C10*D10","v":4.9000000000000004}]
[null,"TOTAL RECOL·LECCIÓ I EMMAGATZEMATGE D'AIGÜES PLUVIALS",null,null,{"$f":"SUM(E7:E10)","v":865.6}]
[]
[]
["CLORACIÓ"]
[]
[]
["Codi","Concepte","Preu unitari","Amidament","Import (sense IVA)"]
[1,"Dipòsit rectangular per aigua potable",{"$f":"VLOOKUP(APLICATIU!P9,Tarifes!K4:O11,4,FALSE)","v":186.16},1,{"$f":"C18*D18","v":186.16}]
[2,"Vàlvula de flotador",{"$f":"VLOOKUP(Tarifes!S24,Tarifes!R16:S22,2,FALSE)","v":102.71},1,{"$f":"D19*C19","v":102.71}]
[3,"Bomba dosificadora d'hipoclorit sòdic",{"$f":"Tarifes!L13","v":685.4},1,{"$f":"C20*D20","v":685.4}]
[4,"Caseta de resina per allotjament d'equips",{"$f":"VLOOKUP(C18,Tarifes!N4:P11,3,FALSE)","v":249},1,{"$f":"C21*D21","v":249}]
[null,"TOTAL CLORACIÓ",null,null,{"$f":"IF(APLICATIU!D10=0,\"0,00 €\",SUM(E18:E21))","v":1223.27}]
[]
[]
["GRUP DE PRESSIÓ"]
[]
[]
["Codi","Concepte","Preu unitari","Amidament","Import (sense IVA)"]
[1,"Grup de pressió amb regulador",{"$f":"Tarifes!AA12","v":358},1,{"$f":"D29*C29","v":358}]
[2,"Comptador d'aigua amb emissor d'impulsos",{"$f":"VLOOKUP(Tarifes!L24,Tarifes!K17:L22,2,FALSE)","v":265.5},1,{"$f":"C30*D30","v":265.5}]
[3,"Quadre elèctric per control del grup de pressió i el dosificador de clor",1000,1,{"$f":"D31*C31","v":1000}]
[null,"TOTAL GRUP DE PRESSIÓ",null,null,{"$f":"SUM(E29:E31)","v":1623.5}]
[]
[]
["CANONADES, VÀLVULES I ACCESSORIS"]
[]
[]
["Codi","Concepte","Preu unitari","Amidament","Import (sense IVA)"]
[1,"Canonada PVC gris per pluvials DN75.",{"$f":"Tarifes!F4","v":4.7300000000000004},10,{"$f":"D39*C39","v":47.300000000000004}]
[2,"Accessoris baixants",{"$f":"C39*Tarifes!F6","v":2.3650000000000002},2,{"$f":"C40*D40","v":4.7300000000000004}]
[6,"Canonada PE40",{"$f":"Tarifes!C17","v":2.7},10,{"$f":"C41*D41","v":27}]
[7,"Accessoris canonada pressió",{"$f":"C41*Tarifes!C12","v":21.6},7,{"$f":"C42*D42","v":151.20000000000002}]
[null,"TOTAL CANONADES, VÀLVULES I ACCESSORIS",null,null,{"$f":"SUM(E39:E42)","v":230.23000000000002}]
[]
[]
["MÀ D'OBRA"]
[]
[]
["Codi","Concepte","Preu unitari","Amidament","Import (sense IVA)"]
[1,"Mà d'obra de tècnic especialista en lampisteria i fontaneria. Import per hores amb desplaçament inclòs",40,10,400]
[null,"TOTAL MÀ D'OBRA",null,null,400]
[]
[]
["RAJOS UV"]
[]
[]
["Codi","Concepte","Preu unitari","Amidament","Import (sense IVA)"]
[null,"Làmpada UV",{"$f":"VLOOKUP(Tarifes!C32,Tarifes!B28:C30,2,FALSE)","v":120.1},1,{"$f":"C58*D58","v":120.1}]
[null,"Bomba de recirculació",{"$f":"VLOOKUP(Tarifes!C32,Tarifes!B28:D30,3,FALSE)","v":506},1,{"$f":"C59*D59","v":506}]
[null,"Recanvi làmpada",{"$f":"VLOOKUP(Tarifes!C32,Tarifes!F28:G30,2,FALSE)","v":38.4},1,{"$f":"C60*D60","v":38.4}]
[null,"Recanvi tub quars",{"$f":"VLOOKUP(Tarifes!C32,Tarifes!F28:H30,3,FALSE)","v":12.9},1,{"$f":"C61*D61","v":12.9}]
[null,"Caseta de resina per allotjament d'equips",{"$f":"Tarifes!I17","v":249},1,{"$f":"C62*D62","v":249}]
[null,"TOTAL DESINFECCIÓ PER RAJOS UV",null,null,{"$f":"IF(APLICATIU!D10=0,\"0,00 €\",SUM(E58:E62))","v":926.4}]
[]
[]
[]
[]
[null,"RESUM DE PRESSUPOST PLANTA PILOT"]
[null,"RECOL·LECCIÓ I EMMAGATZEMATGE D'AIGÜES PLUVIALS",{"$f":"E11","v":865.6}]
[null,{"$f":"VLOOKUP(APLICATIU!O4,A81:B82,2,FALSE)","v":"CLORACIÓ"},{"$f":"IF(B70=\"RAJOS UV\",E63,E22)","v":1223.27}]
[null,"GRUP DE PRESSIÓ",{"$f":"E32","v":1623.5}]
[null,"CANONADES, VÀLVULES I ACCESSORIS",{"$f":"E43","v":230.23000000000002}]
[null,"MÀ D'OBRA",{"$f":"E51","v":400}]
[null,"TOTAL PLANTA PILOT",{"$f":"SUM(C69:C73)","v":4342.6000000000004}]
[null,"IVA 21%",{"$f":"C74*0.21","v":911.94600000000003}]
[null,"TOTAL PLANTA PILOT IVA INCLÒS",{"$f":"C74+C75","v":5254.5460000000003}]
[]
[]
[]
["DESINFECCIÓ"]
["DESINFECCIÓ AMB HIPOCLORIT","CLORACIÓ",{"$f":"E22","v":1223.27}]
["DESINFECCIÓ PER RAJOS UV","RAJOS UV",{"$f":"E63","v":926.4}]

{"sheet":"Formularis","index":12,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Dutxa",true,null,"DISPONIBILITAT"]
[null,"Inodor (WC)",true,null,"DEMANDA"]
[null,"Lavabo",true]
[null,"Aixetes",true]
[null,"Rentadora",true,null,"DESINFECCIÓ AMB HIPOCLORIT","CLORACIÓ"]
[null,"Cuina",true,null,"DESINFECCIÓ PER RAJOS UV","RAJOS UV"]
[null,"Rentavaixelles",false]
[null,null,null,null,"Cisterna"]
[null,null,null,null,"Fluxor"]