{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Start","IPS1","Summary","RepairFormula","Db"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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":"Start","index":0,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,6,2,8],[5,6,5,8],[8,6,8,8],[9,6,9,8],[15,4,16,4],[10,6,10,8]]}
[]
[]
[null,null,"Blankettmall version 1.01"]
[]
[]
[null,null,null,null,null,null,"BLANKETT RIPS"]
[null,null,null,null,null,null,"KVARTALSRAPPORT Pensionssparinstitut Version 11, 2014-12-30->"]
[]
[null,null,null,null,null,null,"Blanketten ska vara Statistiska centralbyrån tillhanda senast den sista bankdagen i månaden efter kvartalsskifte."]
[]
[null,null,null,null,null,null,"Blanketten lämnas in via adressen www.insamling.scb.se där ni loggar in med ert användarnamn och lösenord."]
[]
[null,null,null,null,null,null,"Antal slagna kontroller i blanketten",{"$f":"SUM('IPS1'!H42:J42)","v":2}]

{"sheet":"IPS1","index":1,"n_rows":55,"n_cols":10,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[null,"Institutets namn och adress",null,null,"KVARTALSRAPPORT","FM5001"]
[null,null,null,null,"Pensionssparinstitut"]
[]
[null,"Organisationsnummer","Institutnummer",null,"Rapportår och månad"]
[]
[null,"Handläggarens namnteckning"]
[]
[null,"Telefon (inkl riktnr)"]
[null,null,null,null,"Blanketten ska vara Statistiska centralbyrån tillhanda"]
[null,null,null,null,"senast sista bankdagen i månaden efter kvartalsskifte."]
[]
[null,"Uppgifterna samlas in med stöd av 6 kap. 9 § lagen",null,null,"Om rapportering ej kan ske elektroniskt, skall "]
[null,"(1988:1385) om Sveriges riksbank",null,null,"blanketten sändas i ett exemplar till"]
[]
[null,null,null,null,"Statistiska centralbyrån"]
[null,null,null,null,"ES/BFM - FMR"]
[null,null,null,null,"Box 24300"]
[null,null,null,null,"104 51 STOCKHOLM"]
[]
[null,null,null,null,"Uppgifterna kommer att lämnas till "]
[null,null,null,null,"Sveriges riksbank."]
[null,null,null,null,null,null,null,"KONTROLLER"]
[null,null,null,null,null,null,null,"Summerings-och rimlighetskontroller"]
[null,null,null,null,"  Antal konton","  Belopp totalt, tkr",null,"  Antal konton","  Belopp totalt, tkr","  Belopp totalt, tkr"]
[null,"1  Tillgångarnas ingående värde ............……................………………..",null,"+",null,null,null,{"$f":"IF(E25>0,\"\",\"Antal konton saknas?\")","v":"Antal konton saknas?"},{"$f":"IF(ABS(F25-(F26+F27+F28))<=10,\"\",\"Summafel\")","v":""}]
[null,"    a  Inlåning på konto .........................…….......................………………………………..",null," "]
[null,"    b  Andelar i värdepappersfonder .......……......................……………………………………….",null," "]
[null,"    c  Andra fondpapper .......................……........................………………………………..",null," "]
[null,"2  Inbetalning ....................................……......................……………...……………..",null,"+"]
[null,"3  Utbetalning ....................................……...................……………………………….",null,"-"]
[null,"4  Räntor ...........................................……...................…………………………………..",null,"+"]
[null,"5  Utdelningar ..................................……....................………………………………..",null,"+"]
[null,"6  Skatter, avgifter ............................…….....................…………………………",null,"-"]
[null,"7  Omplaceringar till/från annat pensionssparinstitut ............…",null,"+/-"]
[null,"8  Värdeförändring ...........................…….....................…………………………..",null,"+/-"]
[null,"9  Tillgångarnas utgående värde ........……...............……………………",null,"=",null,null,null,{"$f":"IF(E36>0,\"\",\"Antal konton saknas?\")","v":"Antal konton saknas?"},{"$f":"IF(ABS(F36-(F35+F34-F33+F32+F31-F30+F29+F25))<=10,\"\",\"Summafel\")","v":""},{"$f":"IF(ABS(F36-(F37+F38+F39))<=10,\"\",\"Summafel\")","v":""}]
[null,"    a  Inlåning på konto .................................................………………………………………..",null," "]
[null,"    b  Andelar i värdepappersfonder ..............................………………………………………………..",null," "]
[null,"    c  Andra fondpapper ................................................………………………………….",null," "]
[]
[]
[null,null,null,null,null,null,"Antal kontroller",{"$f":"COUNTIF(H25:H39,\"Antal konton saknas?\")","v":2},{"$f":"SUM(I25:I39)","v":0},{"$f":"SUM(J25:J39)","v":0}]
[]
[null,"Riktigheten av lämnade uppgifter i denna blankett intygas"]
[]
[null,"Datum"]
[]
[null,"Chefstjänstemans namnteckning"]
[]
[null,"Handläggande tjänstemans namnteckning"]
[]
[]
[]
[null,"Blankettutgivare","Postadress",null,"Telefon"]
[null,"SVERIGES RIKSBANK","103 37  STOCKHOLM",null,"08 - 787 00 00"]

{"sheet":"Summary","index":2,"n_rows":18,"n_cols":13,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,"Var.Värde","Variabelkod","Spec","Kolumn","Rad","Kontoslag","Löptid","Säkrehet","Land","Motpart","Valuta"]
["IPS1","$E$25",{"$f":"IF(ISBLANK(INDIRECT(CONCATENATE(\"'\",A2,\"'\",\"!\",B2))),\"\",(INDIRECT(CONCATENATE(\"'\",A2,\"'\",\"!\",B2))))","v":""},"2_X_M2S_X_X_X_5M_N31_X_X_J","IPS1","E",25,"Ej specificerat","Ej specificerad","Ej specificerad","Ofördelat","6 (S14) Hushåll","Ej specificerad"]
["IPS1","$F$25","","2_A_M2S_X_X_X_5J_N12_V_B_A","IPS1","F",25,"Tillgång","Ej specificerad","Ej specificerad","Totalt","2 (S12) Finansiella företag","Valutor, totalt"]
["IPS1","$F$26","","2_A_M2S1_X_X_X_5J_N121_V_B_A","IPS1","F",26,"Tillgång","Ej specificerad","Ej specificerad","Totalt","21 Monetära finansinstitut","Valutor, totalt"]
["IPS1","$F$27","","2_A_M2S2_X_X_X_5J_N12A_V_B_A","IPS1","F",27,"Tillgång","Ej specificerad","Ej specificerad","Totalt","216+222 Värdepappersfonder","Valutor, totalt"]
["IPS1","$F$28","","2_A_M2S3_X_X_X_5J_N12_V_B_A","IPS1","F",28,"Tillgång","Ej specificerad","Ej specificerad","Totalt","2 (S12) Finansiella företag","Valutor, totalt"]
["IPS1","$F$29","","31_A_M2S_X_X_X_5J_N31_V_B_A","IPS1","F",29,"Tillgång","Ej specificerad","Ej specificerad","Totalt","6 (S14) Hushåll","Valutor, totalt"]
["IPS1","$F$30","","32_A_M2S_X_X_X_5J_N31_V_B_A","IPS1","F",30,"Tillgång","Ej specificerad","Ej specificerad","Totalt","6 (S14) Hushåll","Valutor, totalt"]
["IPS1","$F$31","","X_X_R1_X_X_X_5J_N12_V_B_A","IPS1","F",31,"Ej specificerat","Ej specificerad","Ej specificerad","Totalt","2 (S12) Finansiella företag","Valutor, totalt"]
["IPS1","$F$32","","X_X_R2_X_X_X_5J_N12_V_B_A","IPS1","F",32,"Ej specificerat","Ej specificerad","Ej specificerad","Totalt","2 (S12) Finansiella företag","Valutor, totalt"]
["IPS1","$F$33","","X_X_R3_X_X_X_5J_N21_V_B_A","IPS1","F",33,"Ej specificerat","Ej specificerad","Ej specificerad","Totalt","3 (S1311) Staten","Valutor, totalt"]
["IPS1","$F$34","","33_A_M2S_X_X_X_5J_N1223_V_B_A","IPS1","F",34,"Tillgång","Ej specificerad","Ej specificerad","Totalt","23 (S125) Försäkringsföretag och pension","Valutor, totalt"]
["IPS1","$F$35","","4_A_M2S_X_X_X_5J_N12_V_B_A","IPS1","F",35,"Tillgång","Ej specificerad","Ej specificerad","Totalt","2 (S12) Finansiella företag","Valutor, totalt"]
["IPS1","$E$36","","5_X_M2S_X_X_X_5M_N31_X_X_J","IPS1","E",36,"Ej specificerat","Ej specificerad","Ej specificerad","Ofördelat","6 (S14) Hushåll","Ej specificerad"]
["IPS1","$F$36","","5_A_M2S_X_X_X_5J_N12_V_B_A","IPS1","F",36,"Tillgång","Ej specificerad","Ej specificerad","Totalt","2 (S12) Finansiella företag","Valutor, totalt"]
["IPS1","$F$37","","5_A_M2S1_X_X_X_5J_N121_V_B_A","IPS1","F",37,"Tillgång","Ej specificerad","Ej specificerad","Totalt","21 Monetära finansinstitut","Valutor, totalt"]
["IPS1","$F$38","","5_A_M2S2_X_X_X_5J_N12A_V_B_A","IPS1","F",38,"Tillgång","Ej specificerad","Ej specificerad","Totalt","216+222 Värdepappersfonder","Valutor, totalt"]
["IPS1","$F$39","","5_A_M2S3_X_X_X_5J_N12_V_B_A","IPS1","F",39,"Tillgång","Ej specificerad","Ej specificerad","Totalt","2 (S12) Finansiella företag","Valutor, totalt"]

{"sheet":"RepairFormula","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["IPS1","$H$25",{"$f":"IF(E25>0,\"\",\"Antal konton saknas?\")","v":"Antal konton saknas?"}]
["IPS1","$I$25",{"$f":"IF(ABS(F25-(F26+F27+F28))<=10,\"\",\"Summafel\")","v":""}]
["IPS1","$H$36",{"$f":"IF(E36>0,\"\",\"Antal konton saknas?\")","v":"Antal konton saknas?"}]
["IPS1","$I$36",{"$f":"IF(ABS(F36-(F35+F34-F33+F32+F31-F30+F29+F25))<=10,\"\",\"Summafel\")","v":""}]
["IPS1","$J$36",{"$f":"IF(ABS(F36-(F37+F38+F39))<=10,\"\",\"Summafel\")","v":""}]

{"sheet":"Db","index":4,"n_rows":17,"n_cols":7,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["IPS1","$E$25",{"$f":"IF(ISBLANK(INDIRECT(CONCATENATE(\"'\",A1,\"'\",\"!\",B1))),\"\",(INDIRECT(CONCATENATE(\"'\",A1,\"'\",\"!\",B1))))","v":""},"2_X_M2S_X_X_X_5M_N31_X_X_J","IPS1","$E$25",1000]
["IPS1","$F$25","","2_A_M2S_X_X_X_5J_N12_V_B_A","IPS1","$F$25",1000]
["IPS1","$F$26","","2_A_M2S1_X_X_X_5J_N121_V_B_A","IPS1","$F$26",1000]
["IPS1","$F$27","","2_A_M2S2_X_X_X_5J_N12A_V_B_A","IPS1","$F$27",1000]
["IPS1","$F$28","","2_A_M2S3_X_X_X_5J_N12_V_B_A","IPS1","$F$28",1000]
["IPS1","$F$29","","31_A_M2S_X_X_X_5J_N31_V_B_A","IPS1","$F$29",1000]
["IPS1","$F$30","","32_A_M2S_X_X_X_5J_N31_V_B_A","IPS1","$F$30",1000]
["IPS1","$F$31","","X_X_R1_X_X_X_5J_N12_V_B_A","IPS1","$F$31",1000]
["IPS1","$F$32","","X_X_R2_X_X_X_5J_N12_V_B_A","IPS1","$F$32",1000]
["IPS1","$F$33","","X_X_R3_X_X_X_5J_N21_V_B_A","IPS1","$F$33",1000]
["IPS1","$F$34","","33_A_M2S_X_X_X_5J_N1223_V_B_A","IPS1","$F$34",1000]
["IPS1","$F$35","","4_A_M2S_X_X_X_5J_N12_V_B_A","IPS1","$F$35",1000]
["IPS1","$E$36","","5_X_M2S_X_X_X_5M_N31_X_X_J","IPS1","$E$36",1000]
["IPS1","$F$36","","5_A_M2S_X_X_X_5J_N12_V_B_A","IPS1","$F$36",1000]
["IPS1","$F$37","","5_A_M2S1_X_X_X_5J_N121_V_B_A","IPS1","$F$37",1000]
["IPS1","$F$38","","5_A_M2S2_X_X_X_5J_N12A_V_B_A","IPS1","$F$38",1000]
["IPS1","$F$39","","5_A_M2S3_X_X_X_5J_N12_V_B_A","IPS1","$F$39",1000]