{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Portada","Dades generals","Descripció del projecte","Valor afegit","Inversió i Finançament","Ocupació","Poblacio"],"not_rendered":{"charts":0,"images":21,"macros":1,"external_links":0,"defined_names":6,"comments":2,"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":"Portada","index":0,"n_rows":42,"n_cols":4,"rows_kept":42,"cut":false,"hidden":false,"merged":[[3,0,3,8],[41,0,44,8],[36,0,36,8]]}
[]
[]
[]
["MEMÒRIA PUNTUABLE PROJECTES PÚBLICS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["CONVOCATÒRIA 2020"]
[]
[]
["PROJECTE PRESENTAT PER",null,null,{"$f":"IF('Dades generals'!C3=0,\"\",'Dades generals'!C3)","v":""}]
[]
[{"$f":"IF('Dades generals'!B18=0,\"\",'Dades generals'!B18)","v":""}]

{"sheet":"Dades generals","index":1,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":false,"merged":[[29,2,29,3],[29,7,29,9],[58,5,58,9],[15,0,15,9],[35,0,35,9],[37,0,37,9],[17,1,17,9],[21,2,21,9],[25,2,25,3],[25,7,25,9],[44,1,44,9],[33,1,33,9],[23,7,23,9],[41,0,41,9],[27,2,27,3],[39,0,39,9],[23,2,23,3],[27,7,27,9],[0,0,0,9],[12,2,12,9],[8,7,8,9],[10,7,10,9],[2,2,2,5],[4,2,4,9],[8,2,8,3],[10,2,10,3],[6,2,6,4]]}
["DADES GENERALS"]
[]
[null,"Nom de l'ens:",null,null,null,null,null,"NIF:"]
[]
[null,"Adreça:"]
[]
[null,"Municipi:",null,null,null,null,null,"Codi Postal:",null,{"$f":"IFERROR(VLOOKUP($C$7,Poblacio!$B$149:$F$211,3,FALSE),\"-\")","v":"-"}]
[]
[null,"Comarca:",{"$f":"IFERROR(VLOOKUP($C$7,Poblacio!$B$149:$F$211,2,FALSE),\"-\")","v":"-"},null,null,"Província:",null,{"$f":"IFERROR(VLOOKUP($C$7,Poblacio!$B$149:$F$211,5,FALSE),\"-\")","v":"-"}]
[]
[null,"Persona de contacte:",null,null,null,"Telèfon de contacte:"]
[]
[null,"Correu electrònic:"]
[]
[]
["TÍTOL DEL PROJECTE PER AL QUAL ES SOL·LICITA L'AJUT"]
[]
[]
[]
[null,"Lloc d'implantació de la inversió LEADER"]
[]
[null,"Adreça inversió:"]
[]
[null,"Nucli de població:",null,null,null,"Municipi:",null,{"$f":"IFERROR(VLOOKUP($C$24,Poblacio!$B$2:$G$144,2,FALSE),\"-\")","v":"-"}]
[]
[null,"Comarca:",{"$f":"IFERROR(VLOOKUP($C$24,Poblacio!$B$2:$G$144,3,FALSE),\"-\")","v":"-"},null,null,"Província:",null,{"$f":"IFERROR(VLOOKUP($C$24,Poblacio!$B$2:$G$144,6,FALSE),\"-\")","v":"-"}]
[]
[null,"Nº de finca:",null,null,null,"Registre de la propietat:"]
[]
[null,"Volum:",null,null,null,"Llibre:"]
[]
[]
[]
[null,"INFORMACIÓ IMPORTANT"]
[]
["Aquest document es compon de diverses fases a omplir per part del beneficiari LEADER.  \nPer accedir a la pestanya corresponent, només haureu de clicar sobre el seu nom a la llista. \nAixí mateix, per tornar a aquesta pàgina cliqueu el botó \"Inici\"."]
[]
["Les pestanyes i els apartats a omplir estan destacats amb color verd clar. La resta es calculen automàticament."]
[]
["Un cop omplertes totes les pestanyes, podeu generar un PDF fent doble clic al botó d'aquesta pàgina.\nAquest PDF s'haurà de signar digitalment al lloc reservat per la signatura i presentar-lo juntament amb la sol·licitud i aquest full de càlcul degudament omplert."]
[]
["Recordeu signar digitalment el PDF al final d'aquest full i a la pàgina \"Inversió i Finançament LEADER\"."]
[]
[]
[null,"PESTANYES A OMPLIR"]
[]
[null,"Descripció del projecte",null,"Valor afegit",null,"Inversió i Finançament",null,null,null,"Ocupació"]
[]
[]
[null,"La persona sotasignant: "]
[]
[null,null,null,null,null,null,null,"Declara haver llegit i omplert tota la informació del document:"]
[]
[null,null,null,null,null,null,null,"Es compromet a aportar la documentació complementària que es sol·liciti per a la tramitació de l'ajut:"]
[]
[null,null,null,null,null,null,null,"Dóna fe de que tota la informació introduïda s'ajusta a la realitat:"]
[]
[null,null,null,null,null,"Signatura:"]
[]
[]
["Sí"]
["No"]

{"sheet":"Descripció del projecte","index":2,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":false,"merged":[[0,0,0,12],[46,1,46,12],[28,1,28,12],[32,1,32,12],[44,5,44,12],[36,1,36,12],[6,5,6,12],[8,5,8,12],[10,5,10,6]]}
["DESCRIPCIÓ DEL PROJECTE",null,null,null,null,null,null,null,null,null,null,null,null,"Sí"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Abast de la inversió"]
[]
[null,null,null,null,"Territoris ADRCatCentral:"]
[]
[null,null,null,null,"Municipis directament beneficiats:"]
[]
[null,null,null,null,"Persones o col·lectius beneficiaris:"]
[]
[null,null,null,null,"Nombre de beneficiaris directes:"]
[]
[null,"Dades bàsiques"]
[]
[null,"Superfície que ocupa la inversió: ",null,null,null,null,"m2"]
[]
[null,"Inclou instal·lació de maquinaria?"]
[]
[null,"Inclou camins i portades de subministraments com llum, aigua i gas?"]
[]
[null,"Inclou programari informàtic per desenvolupar l'activitat? "]
[]
[null,"Inclou la creació d'una plana web amb punt de venda on-line?"]
[]
[null,"Inclou instal·lacions d'energies renovables per autoconsum?"]
[]
[null,"Antecedents històrics",null,null,null,null,null,null,null,null,null,null,"Per fer salts de línia, premi ALT + Enter"]
[]
[]
[]
[null,"Descripció de la inversió i dels objectius a assolir:",null,null,null,null,null,null,null,null,null,null,"Per fer salts de línia, premi ALT + Enter"]
[]
[]
[]
[null,"Actuacions que potenciïn l'economia local (si s'escau)",null,null,null,null,null,null,null,null,null,null,"Per fer salts de línia, premi ALT + Enter"]
[]
[]
[]
[null,"Grau de maduresa"]
[]
[null,"El projecte ha estat aprovat per l'òrgan competent de l'ens?"]
[]
[null,"El finançament del projecte està contemplat al pressupost municipal aprovat?"]
[]
[null,"Observacions (si s'escau):"]
[]
[null,"Serà imprescindible acreditar el compliment dels punts anteriors, mitjançant certificants de Secretaria o Intervenció de l'ens sol·licitant de l'ajut."]

{"sheet":"Valor afegit","index":3,"n_rows":66,"n_cols":14,"rows_kept":66,"cut":false,"hidden":false,"merged":[[0,0,0,12],[31,4,31,7],[55,1,55,13],[18,1,18,12],[21,1,21,12],[4,1,4,12],[7,1,7,12],[14,1,14,12],[11,1,11,12],[25,8,25,9],[27,5,27,12],[49,1,49,13]]}
["VALOR AFEGIT DEL PROJECTE",null,null,null,null,null,null,null,null,null,null,null,null,"Sí"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"Complementarietat  (si s'escau)"]
[]
[null,"Explicar la complementarietat amb altres projectes, ja siguin locals (amb agents del territori) o intercomarcals (promoguts per altres administracions públiques)."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Per fer salts de línia, premi ALT + Enter"]
[]
[]
[]
[null,"Significació patrimonial especial del lloc on es realitza la inversió  (si s'escau)"]
[]
[null,"Exemples: espais naturals d'interés, espais emblemàtics, edificis amb catalogació, edificis amb interès arquitectònic, bens culturals d'interès local, bens culturals d'interès nacional, bens de protecció urbanística…"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Per fer salts de línia, premi ALT + Enter"]
[]
[]
[]
[null,"Aspectes innovadors del projecte  (si s'escau)"]
[]
[null,"Es valorarà si el projecte és innovador en l'àmbit d'actuació de l'Associació o en tot el territori LEADER de Catalunya."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Per fer salts de línia, premi ALT + Enter"]
[]
[]
[]
[null,"Economia Circular"]
[]
[null,"Ha contestat l'enquesta d'economia circular (EnCercla)?"]
[]
[null,"Observacions (si s'escau):"]
[]
[null,"INSTRUCCIONS PER OMPLIR L'ENQUESTA ENCERCLA"]
[]
[null,"1. Accedeixi a l'enllaç:",null,null,"https://encercla.catcentral.cat:9443/"]
[]
[null,"2. Si ja ha fet servir l'eina anteriorment, faci clic a \"Iniciar sesión\" i salti al punt 5. Sinò, faci clic a \"Registrarse\"."]
[]
[]
[]
[null,"3. Ompli el formulari de registre."]
[]
[]
[]
[null,"4. Accedeixi al seu correu electrònic i validi el registre (és possible que entri a correu brossa)."]
[]
[]
[]
[null,"5. Iniciï sessió."]
[]
[]
[]
[null,"6. Un cop dins l'eina, premi sobre el botó \"Afegir\".\n    A la finestra que apareixerà, seleccioni l'any de la convocatòria i marqui la casella inferior."]
[]
[]
[]
[]
[]
[null,"8. Apareixerà una altra finestra emergent, amb el sistema de navegació i funcionament del formulari. \n    Un cop llegit atentament, premi \"Acceptar\"."]
[]
[null,"9. Ompli el formulari."]
[]
[]
[]
[null,"9. Un cop finalitzada l'enquesta, premi el botó \"Calcular\"."]
[]
[]
[]
[null,"10. A la finestra emergent que es mostrarà, premi \"OK\"."]

{"sheet":"Inversió i Finançament","index":4,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,7],[36,1,36,2],[25,1,25,7],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[22,1,22,5],[17,1,17,5],[18,1,18,5],[7,1,7,5],[8,1,8,5],[9,1,9,5],[10,1,10,5],[23,1,23,5],[32,2,33,6],[11,1,11,5],[12,1,12,5],[13,1,13,5],[14,1,14,5],[15,1,15,5]]}
["PLA D'INVERSIONS I FINANÇAMENT LEADER"]
[{"$f":"IF('Dades generals'!C3=0,\"\",'Dades generals'!C3)","v":""}]
[]
[null,"PLA D'INVERSIONS LEADER",null,null,null,null,"IMPORT","%"]
[null,"Honoraris tècnics",null,null,null,null,null,{"$f":"IFERROR(+G5/$G$16,\"-\")","v":"-"}]
[null,"Obra civil: despeses de construcció i paleta",null,null,null,null,null,{"$f":"IFERROR(+G6/$G$16,\"-\")","v":"-"}]
[null,"Instal·lacions",null,null,null,null,null,"-"]
[null,"Altres professionals (pintura, embelliment exterior...)",null,null,null,null,null,"-"]
[null,"Maquinària",null,null,null,null,null,"-"]
[null,"Eines i utillatges",null,null,null,null,null,"-"]
[null,"Mobiliari i atuells",null,null,null,null,null,"-"]
[null,"Equipaments i aplicacions informàtiques",null,null,null,null,null,"-"]
[null,"Plana web amb botiga on-line",null,null,null,null,null,"-"]
[null,"Transformació d'elements de transport",null,null,null,null,null,"-"]
[null,"Altres",null,null,null,null,null,"-"]
[null,"TOTAL INVERSIONS",null,null,null,null,{"$f":"SUM(G5:G15)","v":0},{"$f":"SUM(H5:H15)","v":0}]
[]
[null,"PLA DE FINANÇAMENT LEADER",null,null,null,null,"IMPORT","%"]
[null,"Recursos propis",null,null,null,null,null,{"$f":"IFERROR(+G19/$G$24,\"-\")","v":"-"}]
[null,"Crèdits i /o préstecs d'entitats bancaries",null,null,null,null,null,{"$f":"IFERROR(+G20/$G$24,\"-\")","v":"-"}]
[null,"Crèdits i /o préstecs d'entitats bancaries amb conveni de finançament LEADER",null,null,null,null,null,{"$f":"IFERROR(+G21/$G$24,\"-\")","v":"-"}]
[null,"Subvencions",null,null,null,null,null,{"$f":"IFERROR(+G22/$G$24,\"-\")","v":"-"}]
[null,"Altres ingressos",null,null,null,null,null,{"$f":"IFERROR(+G23/$G$24,\"-\")","v":"-"}]
[null,"TOTAL INVERSIONS",null,null,null,null,{"$f":"SUM(G19:G23)","v":0},{"$f":"SUM(H19:H23)","v":0}]
[]
[null,"Per acreditar el finançament de la inversió LEADER el beneficiari haurà de presentar els documents acreditatius corresponents (caldrà tenir en compte els estalvis obtinguts en el procés de licitació). Documentació que s'adjunta:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Amb la presentació d'aquest document el sotasignant acredita la veracitat de les dades aportades."]
[]
[null,null,null,null,null,"Signatura:"]
[]
[]
[]
[]
[]
[null,{"$f":"IF(G16<G24,\"P\",\"O\")","v":"O"}]

{"sheet":"Ocupació","index":5,"n_rows":32,"n_cols":13,"rows_kept":32,"cut":false,"hidden":false,"merged":[[25,1,27,3],[20,6,20,7],[20,12,21,12],[0,1,0,12],[20,9,20,11],[10,1,10,12],[2,1,2,12],[22,1,24,3]]}
[null,"PERSONAL DE L'ENS"]
[null,null,null,null,null,null,null,null,null,null,null,"Home","Dona"]
[null,"Plantilla actual"]
[null,null,null,"2019-12-30"]
[null,"Inicials","Data de naixement",null,"Gènere",null,"Data de contractació","Tipus de contracte",null,"% de jornada anual"]
["x",null,null,{"$f":"IF((TODAY()-C6)>14600,\">40\",\"<40\")","v":">40"},null,{"$f":"IF(E6=\"Dona\",\"D\",\"H\")","v":"H"},null,null,{"$f":"IF(H6=\"Temporal\",\"T\",\"F\")","v":"F"},null,{"$f":"IF(J6=0,\"X\",IF(H6=\"RETA Fix\",IF(J6<0.75,0,CONCATENATE(F6,I6,D6)),IF(H6=\"RETA Temporal\",IF(J6<0.75,0,CONCATENATE(F6,I6,D6)),CONCATENATE(F6,I6,D6))))","v":"X"}]
["x",null,null,">40",null,"H",null,null,{"$f":"IF(H7=\"Temporal\",\"T\",\"F\")","v":"F"},null,{"$f":"IF(J7=0,\"X\",IF(H7=\"RETA Fix\",IF(J7<0.75,0,CONCATENATE(F7,I7,D7)),IF(H7=\"RETA Temporal\",IF(J7<0.75,0,CONCATENATE(F7,I7,D7)),CONCATENATE(F7,I7,D7))))","v":"X"}]
[]
[]
[]
[null,"Previsió de creació de llocs de treball"]
[null,null,null,"2019-12-30"]
[null,"Inicials","Data de naixement",null,"Gènere",null,"Data de contractació","Tipus de contracte",null,"% de jornada anual"]
["y",null,null,{"$f":"IF((TODAY()-C14)>14600,\">40\",\"<40\")","v":">40"},null,{"$f":"IF(E14=\"Dona\",\"D\",\"H\")","v":"H"},null,null,{"$f":"IF(H14=\"Temporal\",\"T\",\"F\")","v":"F"},null,{"$f":"IF(J14=0,\"X\",IF(H14=\"RETA Fix\",IF(J14<0.75,0,CONCATENATE(F14,I14,D14)),IF(H14=\"RETA Temporal\",IF(J14<0.75,0,CONCATENATE(F14,I14,D14)),CONCATENATE(F14,I14,D14))))","v":"X"}]
["y",null,null,{"$f":"IF((TODAY()-C15)>14600,\">40\",\"<40\")","v":">40"},null,{"$f":"IF(E15=\"Dona\",\"D\",\"H\")","v":"H"},null,null,{"$f":"IF(H15=\"Temporal\",\"T\",\"F\")","v":"F"},null,{"$f":"IF(J15=0,\"X\",IF(H15=\"RETA Fix\",IF(J15<0.75,0,CONCATENATE(F15,I15,D15)),IF(H15=\"RETA Temporal\",IF(J15<0.75,0,CONCATENATE(F15,I15,D15)),CONCATENATE(F15,I15,D15))))","v":"X"}]
[]
[]
[]
[null,"Resum dades treballadors"]
[]
[null,null,null,null,null,null,"HOMES",null,null,"DONES",null,null,"TOTAL"]
[null,null,null,null,null,null,"< o = 40 anys","> 40 anys",null,"< o = 40 anys",null,"> 40 anys"]
[null,"Llocs de treball actual",null,null,"Fixes",null,{"$f":"SUMIF($K$6:$K$8,\"HF<40\",$J$6:$J$8)","v":0},{"$f":"SUMIF($K$6:$K$8,\"HF>40\",$J$6:$J$8)","v":0},null,{"$f":"SUMIF($K$6:$K$8,\"DF<40\",$J$6:$J$8)","v":0},null,{"$f":"SUMIF($K$6:$K$8,\"DF>40\",$J$6:$J$8)","v":0},{"$f":"SUM(G23:I23)","v":0}]
[null,null,null,null,"Temporals",null,{"$f":"SUMIF($K$6:$K$8,\"HT<40\",$J$6:$J$8)","v":0},{"$f":"SUMIF($K$6:$K$8,\"HT>40\",$J$6:$J$8)","v":0},null,{"$f":"SUMIF($K$6:$K$8,\"DT<40\",$J$6:$J$8)","v":0},null,{"$f":"SUMIF($K$6:$K$8,\"DT>40\",$J$6:$J$8)","v":0},0]
[null,null,null,null,"Subtotal",null,{"$f":"SUM(G23:G24)","v":0},{"$f":"SUM(H23:H24)","v":0},null,{"$f":"SUM(J23:J24)","v":0},null,{"$f":"SUM(L23:L24)","v":0},0]
[null,"Llocs de treball de nova creació vinculats a la inversió",null,null,"Fixes",null,{"$f":"SUMIF($K$14:$K$16,\"HF<40\",$J$14:$J$16)","v":0},{"$f":"SUMIF($K$14:$K$16,\"HF>40\",$J$14:$J$16)","v":0},null,{"$f":"SUMIF($K$14:$K$16,\"DF<40\",$J$14:$J$16)","v":0},null,{"$f":"SUMIF($K$14:$K$16,\"DF>40\",$J$14:$J$16)","v":0},0]
[null,null,null,null,"Temporals",null,{"$f":"SUMIF($K$14:$K$16,\"HT<40\",$J$14:$J$16)","v":0},{"$f":"SUMIF($K$14:$K$16,\"HT>40\",$J$14:$J$16)","v":0},null,{"$f":"SUMIF($K$14:$K$16,\"DT<40\",$J$14:$J$16)","v":0},null,{"$f":"SUMIF($K$14:$K$16,\"DT>40\",$J$14:$J$16)","v":0},0]
[null,null,null,null,"Subtotal",null,{"$f":"SUM(G26:G27)","v":0},{"$f":"SUM(H26:H27)","v":0},null,{"$f":"SUM(J26:J27)","v":0},null,{"$f":"SUM(L26:L27)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M28+M25","v":0}]
[]
[null,"Indefinit"]
[null,"Temporal"]

{"sheet":"Poblacio","index":6,"n_rows":211,"n_cols":7,"rows_kept":211,"cut":false,"hidden":true,"merged":[]}
["Codi Comarca","Població","Municipi","Comarca","Codi Postal ","INE","Província"]
[24,"Alpens","Alpens","Osona","08587","080044","Barcelona"]
[14,"Avià","Avià","Berguedà","08610","080116","Barcelona"]
[14,"Bagà","Bagà","Berguedà","08695","080168","Barcelona"]
[14,"Berga","Berga","Berguedà","08600","080229","Barcelona"]
[14,"Borredà","Borredà","Berguedà","08619","080240","Barcelona"]
[14,"Cal Marçal","Puig-reig","Berguedà","08672","081751","Barcelona"]
[14,"Cal Ramons","Gironella","Berguedà","08680","080924","Barcelona"]
[14,"Cal Riera","Puig-reig","Berguedà","08672","081751","Barcelona"]
["42","Calders","Calders","Moianès","08275","080348","Barcelona"]
[14,"Capolat","Capolat","Berguedà","08619","080459","Barcelona"]
[14,"Casserres","Casserres","Berguedà","08693","080497","Barcelona"]
[14,"Castell de l'Areny","Castell de l'Areny","Berguedà","08619","080575","Barcelona"]
["07","Castelladral","Navàs","Bages","08671","081419","Barcelona"]
[14,"Castellar de n'Hug","Castellar de n'Hug","Berguedà","08696","080522","Barcelona"]
[14,"Castellar del Riu","Castellar del Riu","Berguedà","08619","080500","Barcelona"]
["42","Castellcir","Castellcir","Moianès","08183","080556","Barcelona"]
["42","Castellterçol","Castellterçol","Moianès","08183","080641","Barcelona"]
[14,"Cercs","Cercs","Berguedà","08698","082687","Barcelona"]
[14,"Coforb","Capolat","Berguedà","08619","080459","Barcelona"]
["42","Collsuspina","Collsuspina","Moianès","08178","080706","Barcelona"]
[14,"Colònia Cal Pons","Puig-reig","Berguedà","08672","081751","Barcelona"]
[14,"Colònia Vidal","Puig-reig","Berguedà","08672","081751","Barcelona"]
[14,"Colònia Viladomiu","Puig-reig","Berguedà","08672","081751","Barcelona"]
[14,"Correà","Montmajor","Berguedà","08612","081326","Barcelona"]
[14,"El Cassó","Montclar","Berguedà","08614","081304","Barcelona"]
[14,"El Cint","L'Espunyola","Berguedà","08698","080787","Barcelona"]
["07","El Fusteret","Súria","Bages","08260","082747","Barcelona"]
[14,"El Guixaro","Casserres","Berguedà","08680","080497","Barcelona"]
["07","El Mujal","Navàs","Bages","08670","081419","Barcelona"]
["07","El Palà de Torroella","Navàs","Bages","08269","081419","Barcelona"]
["42","El Pla de Gassetes","Santa Maria d'Oló","Moianès","08273","082589","Barcelona"]
[14,"El Pujol de Planès","Montmajor","Berguedà","08612","081326","Barcelona"]
["42","El Raval de la Rovirola","Santa Maria d'Oló","Moianès","08273","082589","Barcelona"]
[24,"El Raval de Sant Feliu","Oristà","Osona","08518","081516","Barcelona"]
["42","El Raval de Santa Eulàlia","Santa Maria d'Oló","Moianès","08273","082589","Barcelona"]
["42","El raval del Prat","L'Estany","Moianès","08148","080790","Barcelona"]
["42","El Solà del Boix","Castellcir","Moianès","08183","080556","Barcelona"]
[14,"Els Bassacs","Gironella","Berguedà","08680","080924","Barcelona"]
[14,"Els Rasos de Peguera","Castellar del Riu","Berguedà","08619","080500","Barcelona"]
[14,"Els Sants Metges","L'Espunyola","Berguedà","08698","080787","Barcelona"]
[14,"Els Torrents","L'Espunyola","Berguedà","08698","080787","Barcelona"]
[14,"Espinalbet","Castellar del Riu","Berguedà","08619","080500","Barcelona"]
[14,"Fígols","Fígols","Berguedà","08698","080804","Barcelona"]
["07","Gaià","Gaià","Bages","08672","080902","Barcelona"]
["07","Galera","Gaià","Bages","08672","080902","Barcelona"]
[24,"Gallifa","Sant Boi de Lluçanès","Osona","08589","082016","Barcelona"]
[14,"Gargallà","Montmajor","Berguedà","08612","081326","Barcelona"]
[14,"Gironella","Gironella","Berguedà","08680","080924","Barcelona"]
[14,"Gisclareny","Gisclareny","Berguedà","08695","080930","Barcelona"]
[14,"Gòsol","Gósol","Berguedà",25716,251001,"Lleida"]
["42","Granera","Granera","Moianès","08183","080958","Barcelona"]
[14,"Grauges","Avià","Berguedà","08610","080116","Barcelona"]
[14,"Guardiola de Berguedà","Guardiola de Berguedà","Berguedà","08694","080996","Barcelona"]
["07","La Colònia Valls de Torroella","Navàs","Bages","08670","081419","Barcelona"]
["42","La Frau","Santa Maria d'Oló","Moianès","08723","082589","Barcelona"]
[14,"La Guàrdia","Sagàs","Berguedà","08517","081884","Barcelona"]
[14,"La Mare de Deu del Bosc","L'Espunyola","Berguedà","08698","080787","Barcelona"]
[14,"La Molina","Santa Maria de Merlès","Berguedà","08517","082554","Barcelona"]
[14,"La nou del Berguedà","La nou del Berguedà","Berguedà","08698","081424","Barcelona"]
["42","La Penyora","Castellcir","Moianès","08183","080556","Barcelona"]
[14,"La Pobla de l'Illet","La Pobla de l'Illet","Berguedà","08696","081666","Barcelona"]
[14,"La Quar","La Quar","Berguedà","08619","081770","Barcelona"]
[14,"La Rodonella","Cercs","Berguedà","08698","082687","Barcelona"]
[24,"La Torre d'Oristà","Oristà","Osona","08518","081516","Barcelona"]
[14,"L'Atmella de Casserres","Casserres","Berguedà","08693","080497","Barcelona"]
[14,"L'Atmella de Merola","Puig-reig","Berguedà","08672","081751","Barcelona"]
[14,"Les cases noves del Collet","Guardiola de Berguedà","Berguedà","08694","080996","Barcelona"]
["42","Les Casetes","Collsuspina","Moianès","08178","080706","Barcelona"]
[14,"L'Esglesiola","L'Espunyola","Berguedà","08698","080787","Barcelona"]
[14,"L'Espunyola","L'Espunyola","Berguedà","08698","080787","Barcelona"]
["42","L'Estany","L'Estany","Moianès","08148","080790","Barcelona"]
[14,"Llinars","Capolat","Berguedà","08619","080459","Barcelona"]
[14,"Llinars","Castellar del Riu","Berguedà","08619","080500","Barcelona"]
[24,"Lluçà","Lluçà","Osona","08514","081094","Barcelona"]
["42","Marfà","Castellcir","Moianès","08183","080556","Barcelona"]
["42","Moià","Moià","Moianès","08180","081385","Barcelona"]
["42","Monistrol de Calders","Monistrol de Calders","Moianès","08275","081287","Barcelona"]
[14,"Montclar","Montclar","Berguedà","08614","081304","Barcelona"]
[14,"Montmajor","Montmajor","Berguedà","08612","081326","Barcelona"]
["42","Montpicanyol","Collsuspina","Moianès","08178","08076","Barcelona"]
[24,"Muntanyola","Muntanyola","Osona","08505","081290","Barcelona"]
[24,"Múnter","Muntanyola","Osona","08505","081290","Barcelona"]
["07","Mura","Mura","Bages","08278","081398","Barcelona"]
["07","Navàs","Navàs","Bages","08670","081419","Barcelona"]
[14,"Obiols","Avià","Berguedà","08610","080116","Barcelona"]
[24,"Olost","Olost","Osona","08516","081496","Barcelona"]
[14,"Olvan","Olvan","Berguedà","08611","081445","Barcelona"]
[24,"Orís","Orís","Osona","08573","081509","Barcelona"]
[24,"Oristà","Oristà","Osona","08518","081516","Barcelona"]
[24,"Perafita","Perafita","Osona","08589","081607","Barcelona"]
[24,"Prats de Lluçanès","Prats de Lluçanès","Osona","08513","081712","Barcelona"]
[14,"Puig-Reig","Puig-reig","Berguedà","08692","081751","Barcelona"]
[14,"Rossinyol i Coforb","Capolat","Berguedà","08619","080459","Barcelona"]
[24,"Rústiques Muntanyola","Muntanyola","Osona","08505","081290","Barcelona"]
[14,"Sagàs","Sagàs","Berguedà","08517","081884","Barcelona"]
[14,"Saldes","Saldes","Berguedà","08697","081901","Barcelona"]
[24,"Sant Agustí del Lluçanès","Sant Agustí del Lluçanès","Osona","08586","081957","Barcelona"]
[14,"Sant Andreu de Farners","Capolat","Berguedà","08619","080459","Barcelona"]
[24,"Sant Bartomeu del Grau","Sant Bartomeu del Grau","Osona","08519","081995","Barcelona"]
[24,"Sant Boi de Lluçanès","Sant Boi de Lluçanès","Osona","08589","082016","Barcelona"]
[14,"Sant Corneli","Cercs","Berguedà","08698","082687","Barcelona"]
["07","Sant Cugat del Racó","Navàs","Bages","08670","081419","Barcelona"]
[14,"Sant Feliu de Lluelles","Montmajor","Berguedà","08612","081326","Barcelona"]
["07","Sant Feliu Sasserra","Sant Feliu Sasserra","Bages","08274","082129","Barcelona"]
["42","Sant Feliuet de Terrassola","Santa Maria d'Oló","Moianès","08273","082589","Barcelona"]
[14,"Sant Jaume de Frontanyà","Sant Jaume de Frontanyà","Berguedà","08619","082166","Barcelona"]
[14,"Sant Joan de Montdarn","Viver i Serrateix","Berguedà","08673","083089","Barcelona"]
["42","Sant Joan d'Oló","Santa Maria d'Oló","Moianès","08273","082589","Barcelona"]
[14,"Sant Jordi de Cercs","Cercs","Berguedà","08698","082687","Barcelona"]
[14,"Sant Julià de Cerdanyola","Sant Julià de Cerdanyola","Berguedà","08694","089030","Barcelona"]
[14,"Sant Juliá de Fréixens","Vallcebre","Berguedà","08699","082938","Barcelona"]
[24,"Sant Martí d'Albars","Sant Martí d'Albars","Osona","08515","082251","Barcelona"]
[14,"Sant Martí de Merlès","Santa Maria de Merlès","Berguedà","08517","082554","Barcelona"]
[14,"Sant Miquel de Terradelles","Santa Maria de Merlès","Berguedà","08517","082554","Barcelona"]
[14,"Sant Pau de Pinós","Santa Maria de Merlès","Berguedà","08517","082554","Barcelona"]
["42","Sant Quirze Safaja","Sant Quirze Safaja","Moianès","08189","082397","Barcelona"]
[24,"Sant Sadurní d'Osomort","Sant Sadurní d'Osomort","Osona","08519","082418","Barcelona"]
["07","Sant Salvador de Torroella","Navàs","Bages","08269","081419","Barcelona"]
["42","Sant Vicenç de Vilaressau","Santa Maria d'Oló","Moianès","08273","082589","Barcelona"]
[24,"Santa Cecilia de Voltregà","Santa Cecilia de Voltregà","Osona","08508","082439","Barcelona"]
[24,"Santa Creu del Jotglar","Olost","Osona","08515","081496","Barcelona"]
[24,"Santa Eulàlia de Puig-Oriol","Lluçà","Osona","08514","081094","Barcelona"]
[24,"Santa Eulàlia de Riuprimer","Santa Eulàlia de Riuprimer","Osona","08505","082476","Barcelona"]
[14,"Santa Maria de Merlès","Santa Maria de Merlès","Berguedà","08517","082554","Barcelona"]
["42","Santa Maria d'Oló","Santa Maria d'Oló","Moianès","08273","082589","Barcelona"]
[14,"Serrateix","Viver i Serrateix","Berguedà","08673","083089","Barcelona"]
[24,"Sobremunt","Sobremunt","Osona","08589","082711","Barcelona"]
[14,"Sorba","Montmajor","Berguedà","08612","081326","Barcelona"]
[14,"Sorribes","Gósol","Berguedà",25716,251001,"Lleida"]
["07","Súria","Súria","Bages","08260","082747","Barcelona"]
["07","Talamanca","Talamanca","Bages","08278","082779","Barcelona"]
[14,"Torregrassa","Montclar","Berguedà","08614","081304","Barcelona"]
[14,"Travil","Capolat","Berguedà","08619","080459","Barcelona"]
["42","Urbanització de la Guàrdia","Calders","Moianès","08275","080348","Barcelona"]
[14,"Vallcebre","Vallcebre","Berguedà","08699","082938","Barcelona"]
["07","Valldeperes","Navàs","Bages","08670","081419","Barcelona"]
[14,"Vilada","Vilada","Berguedà","08613","082994","Barcelona"]
[24,"Viladecans","Sant Boi de Lluçanès","Osona","08589","082016","Barcelona"]
["42","Viladecavalls de Calders","Calders","Moianès","08275","080348","Barcelona"]
[14,"Viladomiu nou","Gironella","Berguedà","08680","080924","Barcelona"]
[14,"Viladomiu vell","Gironella","Berguedà","08680","080924","Barcelona"]
[24,"Vila-rasa","Sant Boi de Lluçanès","Osona","08589","08216","Barcelona"]
[14,"Viver","Viver i Serrateix","Berguedà","08673","083089","Barcelona"]
["-","-","-","-","-","-","-"]
[]
[]
[null,"Municipi","Comarca","Codi Postal ","INE","Província"]
[null,"Alpens","Osona","08587","080044","Barcelona"]
[null,"Avià","Berguedà","08610","080116","Barcelona"]
[null,"Bagà","Berguedà","08695","080168","Barcelona"]
[null,"Berga","Berguedà","08600","080229","Barcelona"]
[null,"Borredà","Berguedà","08619","080240","Barcelona"]
[null,"Calders","Moianès","08275","080348","Barcelona"]
[null,"Capolat","Berguedà","08619","080459","Barcelona"]
[null,"Casserres","Berguedà","08693","080497","Barcelona"]
[null,"Castell de l'Areny","Berguedà","08619","080575","Barcelona"]
[null,"Castellar de n'Hug","Berguedà","08696","080522","Barcelona"]
[null,"Castellar del Riu","Berguedà","08619","080500","Barcelona"]
[null,"Castellcir","Moianès","08183","080556","Barcelona"]
[null,"Castellterçol","Moianès","08183","080641","Barcelona"]
[null,"Cercs","Berguedà","08698","082687","Barcelona"]
[null,"Collsuspina","Moianès","08178","080706","Barcelona"]
[null,"Fígols","Berguedà","08698","080804","Barcelona"]
[null,"Gaià","Bages","08672","080902","Barcelona"]
[null,"Gironella","Berguedà","08680","080924","Barcelona"]
[null,"Gisclareny","Berguedà","08695","080930","Barcelona"]
[null,"Gósol","Berguedà",25716,251001,"Lleida"]
[null,"Granera","Moianès","08183","080958","Barcelona"]
[null,"Guardiola de Berguedà","Berguedà","08694","080996","Barcelona"]
[null,"La nou del Berguedà","Berguedà","08698","081424","Barcelona"]
[null,"La Pobla de l'Illet","Berguedà","08696","081666","Barcelona"]
[null,"La Quar","Berguedà","08619","081770","Barcelona"]
[null,"L'Espunyola","Berguedà","08698","080787","Barcelona"]
[null,"L'Estany","Moianès","08148","080790","Barcelona"]
[null,"Lluçà","Osona","08514","081094","Barcelona"]
[null,"Moià","Moianès","08180","081385","Barcelona"]
[null,"Monistrol de Calders","Moianès","08275","081287","Barcelona"]
[null,"Montclar","Berguedà","08614","081304","Barcelona"]
[null,"Montmajor","Berguedà","08612","081326","Barcelona"]
[null,"Muntanyola","Osona","08505","081290","Barcelona"]
[null,"Mura","Bages","08278","081398","Barcelona"]
[null,"Navàs","Bages","08671","081419","Barcelona"]
[null,"Olost","Osona","08516","081496","Barcelona"]
[null,"Olvan","Berguedà","08611","081445","Barcelona"]
[null,"Orís","Osona","08573","081509","Barcelona"]
[null,"Oristà","Osona","08518","081516","Barcelona"]
[null,"Perafita","Osona","08589","081607","Barcelona"]
[null,"Prats de Lluçanès","Osona","08513","081712","Barcelona"]
[null,"Puig-reig","Berguedà","08672","081751","Barcelona"]
[null,"Sagàs","Berguedà","08517","081884","Barcelona"]
[null,"Saldes","Berguedà","08697","081901","Barcelona"]
[null,"Sant Agustí del Lluçanès","Osona","08586","081957","Barcelona"]
[null,"Sant Bartomeu del Grau","Osona","08519","081995","Barcelona"]
[null,"Sant Boi de Lluçanès","Osona","08589","082016","Barcelona"]
[null,"Sant Feliu Sasserra","Bages","08274","082129","Barcelona"]
[null,"Sant Jaume de Frontanyà","Berguedà","08619","082166","Barcelona"]
[null,"Sant Julià de Cerdanyola","Berguedà","08694","089030","Barcelona"]
[null,"Sant Martí d'Albars","Osona","08515","082251","Barcelona"]
[null,"Sant Quirze Safaja","Moianès","08189","082397","Barcelona"]
[null,"Sant Sadurní d'Osomort","Osona","08519","082418","Barcelona"]
[null,"Santa Cecilia de Voltregà","Osona","08508","082439","Barcelona"]
[null,"Santa Eulàlia de Riuprimer","Osona","08505","082476","Barcelona"]
[null,"Santa Maria de Merlès","Berguedà","08517","082554","Barcelona"]
[null,"Santa Maria d'Oló","Moianès","08273","082589","Barcelona"]
[null,"Sobremunt","Osona","08589","082711","Barcelona"]
[null,"Súria","Bages","08260","082747","Barcelona"]
[null,"Talamanca","Bages","08278","082779","Barcelona"]
[null,"Vallcebre","Berguedà","08699","082938","Barcelona"]
[null,"Vilada","Berguedà","08613","082994","Barcelona"]
[null,"Viver i Serrateix","Berguedà","08673","083089","Barcelona"]