{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["PLANTEJAMENT","SOLUCIÓ"],"read":"whole","date_system":"1900"}

{"sheet":"PLANTEJAMENT","index":0,"n_rows":18,"n_cols":7,"rows_kept":18,"merged":[[4,5,4,6],[7,1,7,2],[8,1,8,2],[11,1,11,2]]}
[]
[null,"CÀLCUL DE GRUPS DE POBLACIÓ I TAXES"]
[null,"(només pots posar dades a les cel·les de color verd)"]
[]
[{"$nulls":3},"Treballadors",null,"Treballadors"]
[{"$nulls":3},"Total",null,"Homes","Dones"]
[null,"Població Total"]
[null,"PET"]
[null,"Actius"]
[null,null,"Ocupats"]
[null,null,"Aturats"]
[null,"Inactius"]
[null,"Població menor 16"]
[null,"Assalariats"]
[]
[null,"Per veure els resultats, cal que miris a la pàgina \"solució\"."]
[]
[null,"desbloca 888"]

{"sheet":"SOLUCIÓ","index":1,"n_rows":41,"n_cols":10,"rows_kept":41,"merged":[[5,1,6,1],[5,2,6,2],[5,4,6,4],[5,5,6,5],[5,7,6,7],[5,8,6,8],[5,9,6,9],[9,1,10,1],[9,2,10,2],[9,4,10,4],[9,5,10,5],[9,7,10,7],[9,8,10,8],[9,9,10,9],[13,1,14,1],[13,2,14,2],[13,4,14,4],[13,5,14,5],[13,7,14,7],[13,8,14,8],[13,9,14,9],[18,1,19,1],[18,2,19,2],[18,4,19,4],[18,5,19,5],[18,7,19,7],[18,8,19,8],[18,9,19,9],[22,1,23,1],[22,2,23,2],[22,4,23,4],[22,5,23,5],[22,7,23,7],[22,8,23,8],[22,9,23,9],[26,1,27,1],[26,2,27,2],[26,4,27,4],[26,5,27,5],[26,7,27,7],[26,8,27,8],[26,9,27,9],[31,1,32,1],[31,2,32,2],[31,4,32,4],[31,5,32,5],[31,7,32,7],[31,8,32,8],[31,9,32,9],[35,1,36,1],[35,2,36,2],[35,4,36,4],[35,5,36,5],[35,7,36,7],[35,8,36,8],[35,9,36,9],[39,1,40,1],[39,2,40,2],[39,4,40,4],[39,5,40,5],[39,7,40,7],[39,8,40,8],[39,9,40,9]]}
[]
[null,"desbloca 888"]
[]
[null,"POBLACIÓ TOTAL D'HOMES I DONES"]
[]
[null,"Taxa d'activitat","=","POBL. ACTIVA","x 100","=",{"$f":"PLANTEJAMENT!D9","v":0},"x 100","=",{"$f":"IF(G7=0,\"MANQUEN DADES\",G6/G7)","v":"MANQUEN DADES"}]
[{"$nulls":3},"PET",null,null,{"$f":"PLANTEJAMENT!D8","v":0}]
[]
[]
[null,"Taxa d'ocupació","=","POBL. OCUPADA","x 100","=",{"$f":"PLANTEJAMENT!D10","v":0},"x 100","=",{"$f":"IF(G11=0,\"MANQUEN DADES\",G10/G11)","v":"MANQUEN DADES"}]
[{"$nulls":3},"POBL. ACTIVA",null,null,{"$f":"PLANTEJAMENT!D9","v":0}]
[]
[]
[null,"Taxa d'atur","=","POBL. ATURADA","x 100","=",{"$f":"PLANTEJAMENT!D11","v":0},"x 100","=",{"$f":"IF(G15=0,\"MANQUEN DADES\",G14/G15)","v":"MANQUEN DADES"}]
[{"$nulls":3},"POBL. ACTIVA",null,null,{"$f":"PLANTEJAMENT!D9","v":0}]
[]
[null,"POBLACIÓ D'HOMES"]
[]
[null,"Taxa d'activitat","=","POBL. ACTIVA","x 100","=",{"$f":"PLANTEJAMENT!F9","v":0},"x 100","=",{"$f":"IF(G20=0,\"MANQUEN DADES\",G19/G20)","v":"MANQUEN DADES"}]
[{"$nulls":3},"PET",null,null,{"$f":"PLANTEJAMENT!F8","v":0}]
[]
[]
[null,"Taxa d'ocupació","=","POBL. OCUPADA","x 100","=",{"$f":"PLANTEJAMENT!F10","v":0},"x 100","=",{"$f":"IF(G24=0,\"MANQUEN DADES\",G23/G24)","v":"MANQUEN DADES"}]
[{"$nulls":3},"POBL. ACTIVA",null,null,{"$f":"PLANTEJAMENT!F9","v":0}]
[]
[]
[null,"Taxa d'atur","=","POBL. ATURADA","x 100","=",{"$f":"PLANTEJAMENT!F11","v":0},"x 100","=",{"$f":"IF(G28=0,\"MANQUEN DADES\",G27/G28)","v":"MANQUEN DADES"}]
[{"$nulls":3},"POBL. ACTIVA",null,null,{"$f":"PLANTEJAMENT!F9","v":0}]
[]
[null,"POBLACIÓ DE DONES"]
[]
[null,"Taxa d'activitat","=","POBL. ACTIVA","x 100","=",{"$f":"PLANTEJAMENT!G9","v":0},"x 100","=",{"$f":"IF(G33=0,\"MANQUEN DADES\",G32/G33)","v":"MANQUEN DADES"}]
[{"$nulls":3},"PET",null,null,{"$f":"PLANTEJAMENT!G8","v":0}]
[]
[]
[null,"Taxa d'ocupació","=","POBL. OCUPADA","x 100","=",{"$f":"PLANTEJAMENT!G10","v":0},"x 100","=",{"$f":"IF(G37=0,\"MANQUEN DADES\",G36/G37)","v":"MANQUEN DADES"}]
[{"$nulls":3},"POBL. ACTIVA",null,null,{"$f":"PLANTEJAMENT!G9","v":0}]
[]
[]
[null,"Taxa d'atur","=","POBL. ATURADA","x 100","=",{"$f":"PLANTEJAMENT!G11","v":0},"x 100","=",{"$f":"IF(G41=0,\"MANQUEN DADES\",G40/G41)","v":"MANQUEN DADES"}]
[{"$nulls":3},"POBL. ACTIVA",null,null,{"$f":"PLANTEJAMENT!G9","v":0}]