{"text_format":"3","workbook":"xlsx","n_sheets":13,"sheets":["Orientações","1. Informações Básicas","2. População","3. Avaliação Atuarial","4. Excedente-Insuficiência","5. Dívidas e + compromissos","6. Demandas Judiciais","7. Obrigações do Patrocinador","8. Reserva Matemática Final","Extra","Versões","Inconsistências","Aux"],"not_rendered":{"images":4,"macros":1,"defined_names":69},"read":"whole","date_system":"1900"}

{"sheet":"Orientações","index":0,"n_rows":41,"n_cols":1,"rows_kept":41,"merged":[[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[6,0,6,9],[7,0,7,9],[7,10,7,19],[7,20,7,29],[7,30,7,39],[7,40,7,49],[7,50,7,59],[7,60,7,69],[7,70,7,79],[7,80,7,89],[7,90,7,99],[7,100,7,109],[7,110,7,119],[7,120,7,129],[7,130,7,139],[7,140,7,149],[7,150,7,159],[7,160,7,169],[7,170,7,179],[7,180,7,189],[7,190,7,199],[7,200,7,209],[7,210,7,219],[7,220,7,229],[7,230,7,239],[7,240,7,249],[7,250,7,259],[7,260,7,269],[7,270,7,279],[7,280,7,289],[7,290,7,299],[7,300,7,309],[7,310,7,319],[7,320,7,329],[7,330,7,339],[7,340,7,349],[7,350,7,359],[7,360,7,369],[7,370,7,379],[7,380,7,389],[7,390,7,399],[7,400,7,409],[7,410,7,419],[7,420,7,429],[7,430,7,439],[7,440,7,449],[7,450,7,459],[7,460,7,469],[7,470,7,479],[7,480,7,489],[7,490,7,499],[7,500,7,509],[7,510,7,519],[7,520,7,529],[7,530,7,539],[7,540,7,549],[7,550,7,559],[7,560,7,569],[7,570,7,579],[7,580,7,589],[7,590,7,599],[7,600,7,609],[7,610,7,619],[7,620,7,629],[7,630,7,639],[7,640,7,649],[7,650,7,659],[7,660,7,669],[7,670,7,679],[7,680,7,689],[7,690,7,699],[7,700,7,709],[7,710,7,719],[7,720,7,729],[7,730,7,739],[7,740,7,749],[7,750,7,759],[7,760,7,769],[7,770,7,779],[7,780,7,789],[7,790,7,799],[7,800,7,809],[7,810,7,819],[7,820,7,829],[7,830,7,839],[7,840,7,849],[7,850,7,859],[7,860,7,869],[7,870,7,879],[7,880,7,889],[7,890,7,899],[7,900,7,909],[7,910,7,919],[7,920,7,929],[7,930,7,939],[7,940,7,949],[7,950,7,959],[7,960,7,969],[7,970,7,979],[7,980,7,989],[7,990,7,999],[7,1000,7,1009],[7,1010,7,1019],[7,1020,7,1029],[7,1030,7,1039],[7,1040,7,1049],[7,1050,7,1059],[7,1060,7,1069],[7,1070,7,1079],[7,1080,7,1089],[7,1090,7,1099],[7,1100,7,1109],[7,1110,7,1119],[7,1120,7,1129],[7,1130,7,1139],[7,1140,7,1149],[7,1150,7,1159],[7,1160,7,1169],[7,1170,7,1179],[7,1180,7,1189],[7,1190,7,1199],[7,1200,7,1209],[7,1210,7,1219],[7,1220,7,1229],[7,1230,7,1239],[7,1240,7,1249],[7,1250,7,1259],[7,1260,7,1269],[7,1270,7,1279],[7,1280,7,1289],[7,1290,7,1299],[7,1300,7,1309],[7,1310,7,1319],[7,1320,7,1329],[7,1330,7,1339],[7,1340,7,1349],[7,1350,7,1359],[7,1360,7,1369],[7,1370,7,1379],[7,1380,7,1389],[7,1390,7,1399],[7,1400,7,1409],[7,1410,7,1419],[7,1420,7,1429],[7,1430,7,1439],[7,1440,7,1449],[7,1450,7,1459],[7,1460,7,1469],[7,1470,7,1479],[7,1480,7,1489],[7,1490,7,1499],[7,1500,7,1509],[7,1510,7,1519],[7,1520,7,1529],[7,1530,7,1539],[7,1540,7,1549],[7,1550,7,1559],[7,1560,7,1569],[7,1570,7,1579],[7,1580,7,1589],[7,1590,7,1599],[7,1600,7,1609],[7,1610,7,1619],[7,1620,7,1629],[7,1630,7,1639],[7,1640,7,1649],[7,1650,7,1659],[7,1660,7,1669],[7,1670,7,1679],[7,1680,7,1689],[7,1690,7,1699],[7,1700,7,1709],[7,1710,7,1719],[7,1720,7,1729],[7,1730,7,1739],[7,1740,7,1749],[7,1750,7,1759],[7,1760,7,1769],[7,1770,7,1779],[7,1780,7,1789],[7,1790,7,1799],[7,1800,7,1809],[7,1810,7,1819],[7,1820,7,1829],[7,1830,7,1839],[7,1840,7,1849],[7,1850,7,1859],[7,1860,7,1869],[7,1870,7,1879],[7,1880,7,1889],[7,1890,7,1899],[7,1900,7,1909],[7,1910,7,1919],[7,1920,7,1929],[7,1930,7,1939],[7,1940,7,1949],[7,1950,7,1959],[7,1960,7,1969],[7,1970,7,1979],[7,1980,7,1989],[7,1990,7,1999],[7,2000,7,2009],[7,2010,7,2019],[7,2020,7,2029],[7,2030,7,2039],[7,2040,7,2049],[7,2050,7,2059],[7,2060,7,2069],[7,2070,7,2079],[7,2080,7,2089],[7,2090,7,2099],[7,2100,7,2109],[7,2110,7,2119],[7,2120,7,2129],[7,2130,7,2139],[7,2140,7,2149],[7,2150,7,2159],[7,2160,7,2169],[7,2170,7,2179],[7,2180,7,2189],[7,2190,7,2199],[7,2200,7,2209],[7,2210,7,2219],[7,2220,7,2229],[7,2230,7,2239],[7,2240,7,2249],[7,2250,7,2259],[7,2260,7,2269],[7,2270,7,2279],[7,2280,7,2289],[7,2290,7,2299],[7,2300,7,2309],[7,2310,7,2319],[7,2320,7,2329],[7,2330,7,2339],[7,2340,7,2349],[7,2350,7,2359],[7,2360,7,2369],[7,2370,7,2379],[7,2380,7,2389],[7,2390,7,2399],[7,2400,7,2409],[7,2410,7,2419],[7,2420,7,2429],[7,2430,7,2439],[7,2440,7,2449],[7,2450,7,2459],[7,2460,7,2469],[7,2470,7,2479],[7,2480,7,2489],[7,2490,7,2499],[7,2500,7,2509],[7,2510,7,2519],[7,2520,7,2529],[7,2530,7,2539],[7,2540,7,2549],[7,2550,7,2559],[7,2560,7,2569],[7,2570,7,2579],[7,2580,7,2589],[7,2590,7,2599],[7,2600,7,2609],[7,2610,7,2619],[7,2620,7,2629],[7,2630,7,2639],[7,2640,7,2649],[7,2650,7,2659],[7,2660,7,2669],[7,2670,7,2679],[7,2680,7,2689],[7,2690,7,2699],[7,2700,7,2709],[7,2710,7,2719],[7,2720,7,2729],[7,2730,7,2739],[7,2740,7,2749],[7,2750,7,2759],[7,2760,7,2769],[7,2770,7,2779],[7,2780,7,2789],[7,2790,7,2799],[7,2800,7,2809],[7,2810,7,2819],[7,2820,7,2829],[7,2830,7,2839],[7,2840,7,2849],[7,2850,7,2859],[7,2860,7,2869],[7,2870,7,2879],[7,2880,7,2889],[7,2890,7,2899],[7,2900,7,2909],[7,2910,7,2919],[7,2920,7,2929],[7,2930,7,2939],[7,2940,7,2949],[7,2950,7,2959],[7,2960,7,2969],[7,2970,7,2979],[7,2980,7,2989],[7,2990,7,2999],[7,3000,7,3009],[7,3010,7,3019],[7,3020,7,3029],[7,3030,7,3039],[7,3040,7,3049],[7,3050,7,3059],[7,3060,7,3069],[7,3070,7,3079],[7,3080,7,3089],[7,3090,7,3099],[7,3100,7,3109],[7,3110,7,3119],[7,3120,7,3129],[7,3130,7,3139],[7,3140,7,3149],[7,3150,7,3159],[7,3160,7,3169],[7,3170,7,3179],[7,3180,7,3189],[7,3190,7,3199],[7,3200,7,3209],[7,3210,7,3219],[7,3220,7,3229],[7,3230,7,3239],[7,3240,7,3249],[7,3250,7,3259],[7,3260,7,3269],[7,3270,7,3279],[7,3280,7,3289],[7,3290,7,3299],[7,3300,7,3309],[7,3310,7,3319],[7,3320,7,3329],[7,3330,7,3339],[7,3340,7,3349],[7,3350,7,3359],[7,3360,7,3369],[7,3370,7,3379],[7,3380,7,3389],[7,3390,7,3399],[7,3400,7,3409],[7,3410,7,3419],[7,3420,7,3429],[7,3430,7,3439],[7,3440,7,3449],[7,3450,7,3459],[7,3460,7,3469],[7,3470,7,3479],[7,3480,7,3489],[7,3490,7,3499],[7,3500,7,3509],[7,3510,7,3519],[7,3520,7,3529],[7,3530,7,3539],[7,3540,7,3549],[7,3550,7,3559],[7,3560,7,3569],[7,3570,7,3579],[7,3580,7,3589],[7,3590,7,3599],[7,3600,7,3609],[7,3610,7,3619],[7,3620,7,3629],[7,3630,7,3639],[7,3640,7,3649],[7,3650,7,3659],[7,3660,7,3669],[7,3670,7,3679],[7,3680,7,3689],[7,3690,7,3699],[7,3700,7,3709],[7,3710,7,3719],[7,3720,7,3729],[7,3730,7,3739],[7,3740,7,3749],[7,3750,7,3759],[7,3760,7,3769],[7,3770,7,3779],[7,3780,7,3789],[7,3790,7,3799],[7,3800,7,3809],[7,3810,7,3819],[7,3820,7,3829],[7,3830,7,3839],[7,3840,7,3849],[7,3850,7,3859],[7,3860,7,3869],[7,3870,7,3879],[7,3880,7,3889],[7,3890,7,3899],[7,3900,7,3909],[7,3910,7,3919],[7,3920,7,3929],[7,3930,7,3939],[7,3940,7,3949],[7,3950,7,3959],[7,3960,7,3969],[7,3970,7,3979],[7,3980,7,3989],[7,3990,7,3999],[7,4000,7,4009],[7,4010,7,4019],[7,4020,7,4029],[7,4030,7,4039],[7,4040,7,4049],[7,4050,7,4059],[7,4060,7,4069],[7,4070,7,4079],[7,4080,7,4089],[7,4090,7,4099],[7,4100,7,4109],[7,4110,7,4119],[7,4120,7,4129],[7,4130,7,4139],[7,4140,7,4149],[7,4150,7,4159],[7,4160,7,4169],[7,4170,7,4179],[7,4180,7,4189],[7,4190,7,4199],[7,4200,7,4209],[7,4210,7,4219],[7,4220,7,4229],[7,4230,7,4239],[7,4240,7,4249],[7,4250,7,4259],[7,4260,7,4269],[7,4270,7,4279],[7,4280,7,4289],[7,4290,7,4299],[7,4300,7,4309],[7,4310,7,4319],[7,4320,7,4329],[7,4330,7,4339],[7,4340,7,4349],[7,4350,7,4359],[7,4360,7,4369],[7,4370,7,4379],[7,4380,7,4389],[7,4390,7,4399],[7,4400,7,4409],[7,4410,7,4419],[7,4420,7,4429],[7,4430,7,4439],[7,4440,7,4449],[7,4450,7,4459],[7,4460,7,4469],[7,4470,7,4479],[7,4480,7,4489],[7,4490,7,4499],[7,4500,7,4509],[7,4510,7,4519],[7,4520,7,4529],[7,4530,7,4539],[7,4540,7,4549],[7,4550,7,4559],[7,4560,7,4569],[7,4570,7,4579],[7,4580,7,4589],[7,4590,7,4599],[7,4600,7,4609],[7,4610,7,4619],[7,4620,7,4629],[7,4630,7,4639],[7,4640,7,4649],[7,4650,7,4659],[7,4660,7,4669],[7,4670,7,4679],[7,4680,7,4689],[7,4690,7,4699],[7,4700,7,4709],[7,4710,7,4719],[7,4720,7,4729],[7,4730,7,4739],[7,4740,7,4749],[7,4750,7,4759],[7,4760,7,4769],[7,4770,7,4779],[7,4780,7,4789],[7,4790,7,4799],[7,4800,7,4809],[7,4810,7,4819],[7,4820,7,4829],[7,4830,7,4839],[7,4840,7,4849],[7,4850,7,4859],[7,4860,7,4869],[7,4870,7,4879],[7,4880,7,4889],[7,4890,7,4899],[7,4900,7,4909],[7,4910,7,4919],[7,4920,7,4929],[7,4930,7,4939],[7,4940,7,4949],[7,4950,7,4959],[7,4960,7,4969],[7,4970,7,4979],[7,4980,7,4989],[7,4990,7,4999],[7,5000,7,5009],[7,5010,7,5019],[7,5020,7,5029],[7,5030,7,5039],[7,5040,7,5049],[7,5050,7,5059],[7,5060,7,5069],[7,5070,7,5079],[7,5080,7,5089],[7,5090,7,5099],[7,5100,7,5109],[7,5110,7,5119],[7,5120,7,5129],[7,5130,7,5139],[7,5140,7,5149],[7,5150,7,5159],[7,5160,7,5169],[7,5170,7,5179],[7,5180,7,5189],[7,5190,7,5199],[7,5200,7,5209],[7,5210,7,5219],[7,5220,7,5229],[7,5230,7,5239],[7,5240,7,5249],[7,5250,7,5259],[7,5260,7,5269],[7,5270,7,5279],[7,5280,7,5289],[7,5290,7,5299],[7,5300,7,5309],[7,5310,7,5319],[7,5320,7,5329],[7,5330,7,5339],[7,5340,7,5349],[7,5350,7,5359],[7,5360,7,5369],[7,5370,7,5379],[7,5380,7,5389],[7,5390,7,5399],[7,5400,7,5409],[7,5410,7,5419],[7,5420,7,5429],[7,5430,7,5439],[7,5440,7,5449],[7,5450,7,5459],[7,5460,7,5469],[7,5470,7,5479],[7,5480,7,5489],[7,5490,7,5499],[7,5500,7,5509],[7,5510,7,5519],[7,5520,7,5529],[7,5530,7,5539],[7,5540,7,5549],[7,5550,7,5559],[7,5560,7,5569],[7,5570,7,5579],[7,5580,7,5589],[7,5590,7,5599],[7,5600,7,5609],[7,5610,7,5619],[7,5620,7,5629],[7,5630,7,5639],[7,5640,7,5649],[7,5650,7,5659],[7,5660,7,5669],[7,5670,7,5679],[7,5680,7,5689],[7,5690,7,5699],[7,5700,7,5709],[7,5710,7,5719],[7,5720,7,5729],[7,5730,7,5739],[7,5740,7,5749],[7,5750,7,5759],[7,5760,7,5769],[7,5770,7,5779],[7,5780,7,5789],[7,5790,7,5799],[7,5800,7,5809],[7,5810,7,5819],[7,5820,7,5829],[7,5830,7,5839],[7,5840,7,5849],[7,5850,7,5859],[7,5860,7,5869],[7,5870,7,5879],[7,5880,7,5889],[7,5890,7,5899],[7,5900,7,5909],[7,5910,7,5919],[7,5920,7,5929],[7,5930,7,5939],[7,5940,7,5949],[7,5950,7,5959],[7,5960,7,5969],[7,5970,7,5979],[7,5980,7,5989],[7,5990,7,5999],[7,6000,7,6009],[7,6010,7,6019],[7,6020,7,6029],[7,6030,7,6039],[7,6040,7,6049],[7,6050,7,6059],[7,6060,7,6069],[7,6070,7,6079],[7,6080,7,6089],[7,6090,7,6099],[7,6100,7,6109],[7,6110,7,6119],[7,6120,7,6129],[7,6130,7,6139],[7,6140,7,6149],[7,6150,7,6159],[7,6160,7,6169],[7,6170,7,6179],[7,6180,7,6189],[7,6190,7,6199],[7,6200,7,6209],[7,6210,7,6219],[7,6220,7,6229],[7,6230,7,6239],[7,6240,7,6249],[7,6250,7,6259],[7,6260,7,6269],[7,6270,7,6279],[7,6280,7,6289],[7,6290,7,6299],[7,6300,7,6309],[7,6310,7,6319],[7,6320,7,6329],[7,6330,7,6339],[7,6340,7,6349],[7,6350,7,6359],[7,6360,7,6369],[7,6370,7,6379],[7,6380,7,6389],[7,6390,7,6399],[7,6400,7,6409],[7,6410,7,6419],[7,6420,7,6429],[7,6430,7,6439],[7,6440,7,6449],[7,6450,7,6459],[7,6460,7,6469],[7,6470,7,6479],[7,6480,7,6489],[7,6490,7,6499],[7,6500,7,6509],[7,6510,7,6519],[7,6520,7,6529],[7,6530,7,6539],[7,6540,7,6549],[7,6550,7,6559],[7,6560,7,6569],[7,6570,7,6579],[7,6580,7,6589],[7,6590,7,6599],[7,6600,7,6609],[7,6610,7,6619],[7,6620,7,6629],[7,6630,7,6639],[7,6640,7,6649],[7,6650,7,6659],[7,6660,7,6669],[7,6670,7,6679],[7,6680,7,6689],[7,6690,7,6699],[7,6700,7,6709],[7,6710,7,6719],[7,6720,7,6729],[7,6730,7,6739],[7,6740,7,6749],[7,6750,7,6759],[7,6760,7,6769],[7,6770,7,6779],[7,6780,7,6789],[7,6790,7,6799],[7,6800,7,6809],[7,6810,7,6819],[7,6820,7,6829],[7,6830,7,6839],[7,6840,7,6849],[7,6850,7,6859],[7,6860,7,6869],[7,6870,7,6879],[7,6880,7,6889],[7,6890,7,6899],[7,6900,7,6909],[7,6910,7,6919],[7,6920,7,6929],[7,6930,7,6939],[7,6940,7,6949],[7,6950,7,6959],[7,6960,7,6969],[7,6970,7,6979],[7,6980,7,6989],[7,6990,7,6999],[7,7000,7,7009],[7,7010,7,7019],[7,7020,7,7029],[7,7030,7,7039],[7,7040,7,7049],[7,7050,7,7059],[7,7060,7,7069],[7,7070,7,7079],[7,7080,7,7089],[7,7090,7,7099],[7,7100,7,7109],[7,7110,7,7119],[7,7120,7,7129],[7,7130,7,7139],[7,7140,7,7149],[7,7150,7,7159],[7,7160,7,7169],[7,7170,7,7179],[7,7180,7,7189],[7,7190,7,7199],[7,7200,7,7209],[7,7210,7,7219],[7,7220,7,7229],[7,7230,7,7239],[7,7240,7,7249],[7,7250,7,7259],[7,7260,7,7269],[7,7270,7,7279],[7,7280,7,7289],[7,7290,7,7299],[7,7300,7,7309],[7,7310,7,7319],[7,7320,7,7329],[7,7330,7,7339],[7,7340,7,7349],[7,7350,7,7359],[7,7360,7,7369],[7,7370,7,7379],[7,7380,7,7389],[7,7390,7,7399],[7,7400,7,7409],[7,7410,7,7419],[7,7420,7,7429],[7,7430,7,7439],[7,7440,7,7449],[7,7450,7,7459],[7,7460,7,7469],[7,7470,7,7479],[7,7480,7,7489],[7,7490,7,7499],[7,7500,7,7509],[7,7510,7,7519],[7,7520,7,7529],[7,7530,7,7539],[7,7540,7,7549],[7,7550,7,7559],[7,7560,7,7569],[7,7570,7,7579],[7,7580,7,7589],[7,7590,7,7599],[7,7600,7,7609],[7,7610,7,7619],[7,7620,7,7629],[7,7630,7,7639],[7,7640,7,7649],[7,7650,7,7659],[7,7660,7,7669],[7,7670,7,7679],[7,7680,7,7689],[7,7690,7,7699],[7,7700,7,7709],[7,7710,7,7719],[7,7720,7,7729],[7,7730,7,7739],[7,7740,7,7749],[7,7750,7,7759],[7,7760,7,7769],[7,7770,7,7779],[7,7780,7,7789],[7,7790,7,7799],[7,7800,7,7809],[7,7810,7,7819],[7,7820,7,7829],[7,7830,7,7839],[7,7840,7,7849],[7,7850,7,7859],[7,7860,7,7869],[7,7870,7,7879],[7,7880,7,7889],[7,7890,7,7899],[7,7900,7,7909],[7,7910,7,7919],[7,7920,7,7929],[7,7930,7,7939],[7,7940,7,7949],[7,7950,7,7959],[7,7960,7,7969],[7,7970,7,7979],[7,7980,7,7989],[7,7990,7,7999],[7,8000,7,8009],[7,8010,7,8019],[7,8020,7,8029],[7,8030,7,8039],[7,8040,7,8049],[7,8050,7,8059],[7,8060,7,8069],[7,8070,7,8079],[7,8080,7,8089],[7,8090,7,8099],[7,8100,7,8109],[7,8110,7,8119],[7,8120,7,8129],[7,8130,7,8139],[7,8140,7,8149],[7,8150,7,8159],[7,8160,7,8169],[7,8170,7,8179],[7,8180,7,8189],[7,8190,7,8199],[7,8200,7,8209],[7,8210,7,8219],[7,8220,7,8229],[7,8230,7,8239],[7,8240,7,8249],[7,8250,7,8259],[7,8260,7,8269],[7,8270,7,8279],[7,8280,7,8289],[7,8290,7,8299],[7,8300,7,8309],[7,8310,7,8319],[7,8320,7,8329],[7,8330,7,8339],[7,8340,7,8349],[7,8350,7,8359],[7,8360,7,8369],[7,8370,7,8379],[7,8380,7,8389],[7,8390,7,8399],[7,8400,7,8409],[7,8410,7,8419],[7,8420,7,8429],[7,8430,7,8439],[7,8440,7,8449],[7,8450,7,8459],[7,8460,7,8469],[7,8470,7,8479],[7,8480,7,8489],[7,8490,7,8499],[7,8500,7,8509],[7,8510,7,8519],[7,8520,7,8529],[7,8530,7,8539],[7,8540,7,8549],[7,8550,7,8559],[7,8560,7,8569],[7,8570,7,8579],[7,8580,7,8589],[7,8590,7,8599],[7,8600,7,8609],[7,8610,7,8619],[7,8620,7,8629],[7,8630,7,8639],[7,8640,7,8649],[7,8650,7,8659],[7,8660,7,8669],[7,8670,7,8679],[7,8680,7,8689],[7,8690,7,8699],[7,8700,7,8709],[7,8710,7,8719],[7,8720,7,8729],[7,8730,7,8739],[7,8740,7,8749],[7,8750,7,8759],[7,8760,7,8769],[7,8770,7,8779],[7,8780,7,8789],[7,8790,7,8799],[7,8800,7,8809],[7,8810,7,8819],[7,8820,7,8829],[7,8830,7,8839],[7,8840,7,8849],[7,8850,7,8859],[7,8860,7,8869],[7,8870,7,8879],[7,8880,7,8889],[7,8890,7,8899],[7,8900,7,8909],[7,8910,7,8919],[7,8920,7,8929],[7,8930,7,8939],[7,8940,7,8949],[7,8950,7,8959],[7,8960,7,8969],[7,8970,7,8979],[7,8980,7,8989],[7,8990,7,8999],[7,9000,7,9009],[7,9010,7,9019],[7,9020,7,9029],[7,9030,7,9039],[7,9040,7,9049],[7,9050,7,9059],[7,9060,7,9069],[7,9070,7,9079],[7,9080,7,9089],[7,9090,7,9099],[7,9100,7,9109],[7,9110,7,9119],[7,9120,7,9129],[7,9130,7,9139],[7,9140,7,9149],[7,9150,7,9159],[7,9160,7,9169],[7,9170,7,9179],[7,9180,7,9189],[7,9190,7,9199],[7,9200,7,9209],[7,9210,7,9219],[7,9220,7,9229],[7,9230,7,9239],[7,9240,7,9249],[7,9250,7,9259],[7,9260,7,9269],[7,9270,7,9279],[7,9280,7,9289],[7,9290,7,9299],[7,9300,7,9309],[7,9310,7,9319],[7,9320,7,9329],[7,9330,7,9339],[7,9340,7,9349],[7,9350,7,9359],[7,9360,7,9369],[7,9370,7,9379],[7,9380,7,9389],[7,9390,7,9399],[7,9400,7,9409],[7,9410,7,9419],[7,9420,7,9429],[7,9430,7,9439],[7,9440,7,9449],[7,9450,7,9459],[7,9460,7,9469],[7,9470,7,9479],[7,9480,7,9489],[7,9490,7,9499],[7,9500,7,9509],[7,9510,7,9519],[7,9520,7,9529],[7,9530,7,9539],[7,9540,7,9549],[7,9550,7,9559],[7,9560,7,9569],[7,9570,7,9579],[7,9580,7,9589],[7,9590,7,9599],[7,9600,7,9609],[7,9710,7,9719],[7,9720,7,9729],[7,9730,7,9739],[7,9740,7,9749],[7,9760,7,9769],[7,9770,7,9779],[7,9780,7,9789],[7,9790,7,9799],[7,9800,7,9809],[8,0,8,9],[9,0,9,9],[10,0,10,9],[11,0,11,9],[13,0,13,9],[14,0,14,9],[15,0,15,9],[17,0,17,9],[18,0,18,9],[20,0,20,9],[21,0,21,9],[23,0,23,9],[24,0,24,9],[25,0,25,9],[26,0,26,9],[28,0,28,9],[30,0,30,9],[32,0,32,9],[33,0,33,9],[34,0,34,9],[35,0,35,9],[37,0,37,9],[38,0,38,9],[40,0,40,9],[41,0,41,9]],"merged_total":1669,"flags":["merged_cut"]}
[]
["RELATÓRIO DE RETIRADA DE PATROCÍNIO"]
["- Requerimento de Retirada Parcial -"]
[]
["ORIENTAÇÕES PARA PREENCHIMENTO E OUTRAS INFORMAÇÕES"]
["GERAL"]
["- Ao abrir o arquivo, é necessário habilitar a edição e habilitar o conteúdo, para ativar a execução de macros;"]
["- O arquivo deve ser salvo e enviado à Previc no formato \"xlsx\";"]
["- Preencher somente os campos de seleção e aqueles formatados com borda dupla;"]
["- Nos campos \"OBSERVAÇÕES ADICIONAIS\" devem ser incluídas informações adicionais ou particularidades julgadas importantes para a análise do requerimento;"]
["- Na seção \"Extra\" podem ser replicados quadros de outras seções, devidamente identificados, inclusive com informações segregadas por patrocinador ou submassa, quando julgado necessário, desde que previamente reconhecido o grupo de custeio na Demonstração Atuarial imediatamente anterior ao protocolo."]
["- Dúvidas, alertas de erros ou sugestões devem ser encaminhados para previc.cgtr@previc.gov.br."]
["1. Informações Básicas"]
["- O campo \"Motivação\" deve esclarecer as razões que levaram à decisão do patrocinador/instituidor ou da entidade, conforme o caso, para a retirada de patrocínio;"]
["- No caso de retirada por iniciativa da EFPC, o campo \"Data da Decisão\" deve ser preenchido com a data da decisão da retirada pelo órgão estatutário competente da entidade;"]
["- No caso de a lista de patrocinadores retirantes ser insuficiente, utilizar a seção \"Extra\", identificando a informação."]
["2. População"]
["- São considerados Ativos os participantes em fase contributiva com vínculo empregatício/associativo com o patrocinador/instituidor;"]
["- São considerados Cancelados os ex-participantes que tiveram sua inscrição cancelada no plano sem perda de vínculo empregatício ou que tiveram opção presumida pelo instituto do Resgate e possuem valor a restituir."]
["3. Avaliação Atuarial"]
["- No item 3.2, as colunas \"Plano\" e \"Cálculo I\" devem considerar as hipóteses, regimes financeiros e métodos de financiamento utilizados na demonstração atuarial imediatamente anterior ao do pedido de retirada de patrocínio, ou seja, considerando o plano em funcionamento;"]
["- No item 3.2, a coluna \"Cálculo II\" deve considerar os critérios definidos no art. 8º, § 2º, da Resolução CNPC nº 11/2013."]
["4. Tratamento de Excedente/Insuficiência Patrimonial"]
["- No item 4.1.1, a) a duração do passivo é do grupo em retirada;"]
["- No item 4.1.1 e no item 4.2, o período de constituição da reserva especial/déficit deve considerar o plano como um todo. Caso a reserva especial/déficit tenha surgido somente por ocasião da avaliação atuarial de retirada para o grupo em retirada, deve-se considerar o exercício corrente;"]
["- No item 4.1.1 e no item 4.2, a proporção contribuição deve considerar as contribuições normais vertidas somente por patrocinadores e participantes/assistidos do grupo em retirada;"]
["- No item 4.1.2 a entidade deve justificar a divisão do fundo entre participantes/assistidos e patrocinadores no campo \"Justificativa\", detalhando o critério adotado."]
["5. Contratos de Dívidas e Outros Compromissos dos Patrocinadores"]
["- Informar detalhes sobre o cumprimento do contrato ou obrigação no campo \"Relato sobre cumprimento\"."]
["6. Relatório de Demandas Judiciais Passivas"]
["- Registrar os valores das demandas judiciais passivas totais e contabilizadas no exigível contingencial do plano, relacionadas direta ou indiretamente com o grupo em retirada, consolidados por \"Matéria\", \"Natureza\" e \"Classificação de Risco\"."]
["7. Obrigações e Compromissos Estimados dos Patrocinadores"]
["- O campo \"Equacionamento de déficit\" representa o déficit apurado na avaliação atuarial de retirada e ainda não equacionado;"]
["- A assunção adicional de déficit corresponde à faculdade do patrocinador privado de equacionar o déficit de forma mais benéfica aos participantes e assistidos, conforme Res. CNPC nº 11/2013, art. 12, § 2º;"]
["- A garantia de sobrevida mínima aos assistidos corresponde à obrigação prevista na Res. CNPC nº 11/2013, art. 8º, § 5º;"]
["- A renúncia de excedente corresponde à faculdade do patrocinador privado de dispor parcial ou totalmente do excedente a que tem direito, em favor dos participantes e assistidos, conforme Res. CNPC nº 11/2013, art. 13, § 2º."]
["8. Reserva Matemática Final de Retirada"]
["- O compromisso de diferença a menor entre o valor de avaliação e o de realização de ativos, após a precificação a valores de mercado na data do cálculo, de que trata o art. 18 da Res. CNPC nº 11/2013, deverá ser apurado em relação a cada ativo quando de sua realização, após a data do cálculo, e distribuído proporcionalmente às reservas matemáticas individuais dos participantes e assistidos;"]
["- Os valores devidos aos Cancelados devem ser tratados de forma segregada, não lhes sendo devido qualquer excedente patrimonial."]
[]
["Versão 1.1 (2020)"]

{"sheet":"1. Informações Básicas","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"merged":[[1,0,1,9],[3,2,3,9],[4,2,4,9],[7,4,9,9],[16,8,16,9],[17,0,17,1],[17,2,17,7],[17,8,17,9],[18,0,18,1],[18,2,18,7],[18,8,18,9],[19,0,19,1],[19,2,19,7],[19,8,19,9],[20,0,20,1],[20,2,20,7],[20,8,20,9],[21,0,21,1],[21,2,21,7],[21,8,21,9],[22,0,22,1],[22,2,22,7],[22,8,22,9],[23,0,23,1],[23,2,23,7],[23,8,23,9],[24,0,24,1],[24,2,24,7],[24,8,24,9],[25,0,25,1],[25,2,25,7],[25,8,25,9],[26,0,26,1],[26,2,26,7],[26,8,26,9],[27,0,27,1],[27,2,27,7],[27,8,27,9],[28,0,28,1],[28,2,28,7],[28,8,28,9],[29,0,29,1],[29,2,29,7],[29,8,29,9],[30,0,30,1],[30,2,30,7],[30,8,30,9],[31,0,31,1],[31,2,31,7],[31,8,31,9],[32,0,32,1],[32,2,32,7],[32,8,32,9],[33,0,33,1],[33,2,33,7],[33,8,33,9],[34,0,34,1],[34,2,34,7],[34,8,34,9],[35,0,35,1],[35,2,35,7],[35,8,35,9],[36,0,36,1],[36,2,36,7],[36,8,36,9],[37,0,37,1],[37,2,37,7],[37,8,37,9],[38,0,38,1],[38,2,38,7],[38,8,38,9],[39,0,39,1],[39,2,39,7],[39,8,39,9],[40,0,40,1],[40,2,40,7],[40,8,40,9],[41,0,41,1],[41,2,41,7],[41,8,41,9],[42,0,42,1],[42,2,42,7],[42,8,42,9],[43,0,43,1],[43,2,43,7],[43,8,43,9],[44,0,44,1],[44,2,44,7],[44,8,44,9],[45,0,45,1],[45,2,45,7],[45,8,45,9],[46,0,46,1],[46,2,46,7],[46,8,46,9],[47,0,47,1],[47,2,47,7],[47,8,47,9]]}
[]
["1. INFORMAÇÕES BÁSICAS"]
[]
["EFPC:","(código)","(nome)"]
["Plano:","(CNPB)","(nome)"]
[]
[]
["Iniciativa:",null,null,"Motivação:"]
[]
[]
[]
[]
["Data-base:"]
[]
[]
["Patrocinadores/Instituidores em Retirada"]
["CNPJ",null,"Razão Social",{"$nulls":5},"Data da Notificação"]

{"sheet":"2. População","index":2,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[1,0,1,9],[3,0,4,1],[3,2,3,3],[3,4,3,5],[3,6,3,9],[4,6,4,7],[4,8,4,9],[5,0,5,1],[5,6,5,7],[5,8,5,9],[6,0,6,1],[6,6,6,7],[6,8,6,9],[7,0,7,1],[7,6,7,7],[7,8,7,9],[8,0,8,1],[8,6,8,7],[8,8,8,9],[9,0,9,1],[9,6,9,7],[9,8,9,9],[11,2,11,3],[11,4,11,5],[12,0,12,1],[12,2,12,3],[12,4,12,5],[15,0,20,9]]}
[]
["2. POPULAÇÃO"]
[]
["Categoria",null,"Quantidade",null,"Idade Média\n(em anos, 1 casa decimal)",null,"Salário de Contribuição Médio/\nBenefício Médio (em R$)"]
[null,null,"Plano","Grupo Retirante","Plano","Grupo Retirante","Plano",null,"Grupo Retirante"]
["Ativos"]
["Autopatrocinados"]
["Em BPD",{"$nulls":5},0]
["Assistidos",{"$nulls":5},0]
["Total",null,{"$f":"SUM(C6:C9)","v":0},{"$f":"SUM(D6:D9)","v":0},{"$f":"IF(C10=0,\"-\",SUMPRODUCT(E6:E9,C6:C9)/C10)","v":"-"},{"$f":"IF(D10=0,\"-\",SUMPRODUCT(F6:F9,D6:D9)/D10)","v":"-"},{"$f":"IF(C10=0,0,SUMPRODUCT(G6:G9,C6:C9)/C10)","v":0},null,{"$f":"IF(D10=0,0,SUMPRODUCT(I6:I9,D6:D9)/D10)","v":0}]
[]
[null,null,"Quantidade\n(Grupo Retirante)",null,"Valor a Restituir (R$)"]
["Cancelados"]
[]
["OBSERVAÇÕES ADICIONAIS"]

{"sheet":"3. Avaliação Atuarial","index":3,"n_rows":44,"n_cols":7,"rows_kept":44,"merged":[[1,0,1,9],[3,0,3,9],[6,2,8,9],[11,2,11,3],[11,4,11,5],[12,0,12,1],[12,2,12,3],[12,4,12,5],[13,0,13,1],[13,2,13,3],[13,4,13,5],[14,0,14,3],[14,4,14,5],[16,0,16,9],[18,0,19,1],[18,2,19,3],[18,4,18,7],[19,4,19,5],[19,6,19,7],[20,0,20,1],[20,2,20,3],[20,4,20,5],[20,6,20,7],[21,0,21,1],[21,2,21,3],[21,4,21,5],[21,6,21,7],[22,0,22,1],[22,2,22,3],[22,4,22,5],[22,6,22,7],[23,0,23,1],[23,2,23,3],[23,4,23,5],[23,6,23,7],[24,0,24,1],[24,2,24,3],[24,4,24,5],[24,6,24,7],[25,0,25,1],[25,2,25,3],[25,4,25,5],[25,6,25,7],[26,0,26,1],[26,2,26,3],[26,4,26,5],[26,6,26,7],[27,0,27,1],[27,2,27,3],[27,4,27,5],[27,6,27,7],[28,0,28,1],[28,2,28,3],[28,4,28,5],[28,6,28,7],[29,0,29,1],[29,2,29,3],[29,4,29,5],[29,6,29,7],[30,0,30,1],[30,2,30,3],[30,4,30,5],[30,6,30,7],[31,0,31,1],[31,2,31,3],[31,4,31,5],[31,6,31,7],[32,0,32,1],[32,2,32,3],[32,4,32,5],[32,6,32,7],[34,0,34,9],[36,0,36,3],[36,4,36,5],[37,0,37,3],[37,4,37,5],[38,0,38,3],[38,4,38,5],[39,0,39,3],[39,4,39,5],[40,0,40,3],[40,4,40,5],[41,0,41,3],[41,4,41,5],[44,0,49,9]]}
[]
["3. AVALIAÇÃO ATUARIAL"]
[]
["3.1. Patrimônio de Cobertura"]
[]
["Critério de Segregação:",null,1]
["Detalhamento:"]
[]
[]
[]
[]
[null,null,"Total do Plano",null,"Grupo em Retirada"]
["Valor Contábil (R$)"]
["Precificado a Mercado (R$)"]
["Diferença (+/-) (R$)",{"$nulls":3},{"$f":"E14-E13","v":{"v":0,"d":"0.00"}}]
[]
["3.2. Reservas Matemáticas (R$)"]
[]
["Item",null,"Plano",null,"Grupo em Retirada"]
[{"$nulls":4},"Cálculo I",null,"Cálculo II"]
["Benefícios Concedidos",null,{"$f":"C22+C23","v":0},null,{"$f":"E22+E23","v":0},null,{"$f":"G22+G23","v":0}]
["Contribuição Definida"]
["Benefício Definido",null,{"$f":"C24+C25","v":0},null,{"$f":"E24+E25","v":0},null,{"$f":"G24+G25","v":0}]
["Programados"]
["Não Programados"]
["Benefícios a Conceder",null,{"$f":"C27+C28","v":0},null,{"$f":"E27+E28","v":0},null,{"$f":"G27+G28","v":0}]
["Contribuição Definida"]
["Benefício Definido",null,{"$f":"C29+C30","v":0},null,{"$f":"E29+E30","v":0},null,{"$f":"G29+G30","v":0}]
["Programados"]
["Não Programados"]
["Provisões a Constituir",null,{"$f":"C32+C33","v":0},null,{"$f":"E32+E33","v":0},null,{"$f":"G32+G33","v":0}]
["Patrocinador"]
["Participantes e Assistidos"]
[]
["3.3. Resultado do Grupo em Retirada"]
[]
["Item",{"$nulls":3},"Valor (R$)"]
["Patrimônio de Cobertura",{"$nulls":3},{"$f":"E14","v":{"v":0,"d":"0.00"}}]
["Provisão Matemática de Benefícios Concedidos",{"$nulls":3},{"$f":"G21","v":{"v":0,"d":"0.00"}}]
["Provisão Matemática de Benefícios a Conceder",{"$nulls":3},{"$f":"G26","v":{"v":0,"d":"0.00"}}]
["(-) Provisões Matemáticas a Constituir",{"$nulls":3},{"$f":"-G31","v":{"v":0,"d":"0.00"}}]
["Resultado",{"$nulls":3},{"$f":"E38-SUM(E39:F41)","v":{"v":0,"d":"0.00"}}]
[]
["OBSERVAÇÕES ADICIONAIS"]

{"sheet":"4. Excedente-Insuficiência","index":4,"n_rows":132,"n_cols":7,"rows_kept":132,"merged":[[1,0,1,9],[3,0,3,9],[5,0,5,9],[9,0,9,2],[9,3,9,4],[10,0,10,2],[10,3,10,4],[11,0,11,2],[11,3,11,4],[12,0,12,2],[12,3,12,4],[13,0,13,2],[13,3,13,4],[14,0,14,2],[14,3,14,4],[20,2,20,3],[20,5,20,6],[21,0,21,1],[21,2,21,3],[21,5,21,6],[22,2,22,3],[22,5,22,6],[23,0,23,1],[23,2,23,3],[23,5,23,6],[26,0,30,9],[32,0,32,9],[34,0,34,9],[36,0,36,1],[36,2,36,9],[37,0,37,1],[37,2,38,9],[40,0,40,1],[40,2,40,3],[40,4,40,9],[41,0,41,1],[41,2,41,3],[41,4,43,9],[42,0,42,1],[42,2,42,3],[43,0,43,1],[43,2,43,3],[46,0,46,1],[46,2,46,9],[47,0,47,1],[47,2,48,9],[50,0,50,1],[50,2,50,3],[50,4,50,9],[51,0,51,1],[51,2,51,3],[51,4,53,9],[52,0,52,1],[52,2,52,3],[53,0,53,1],[53,2,53,3],[56,0,56,1],[56,2,56,9],[57,0,57,1],[57,2,58,9],[60,0,60,1],[60,2,60,3],[60,4,60,9],[61,0,61,1],[61,2,61,3],[61,4,63,9],[62,0,62,1],[62,2,62,3],[63,0,63,1],[63,2,63,3],[66,0,66,1],[66,2,66,9],[67,0,67,1],[67,2,68,9],[70,0,70,1],[70,2,70,3],[70,4,70,9],[71,0,71,1],[71,2,71,3],[71,4,73,9],[72,0,72,1],[72,2,72,3],[73,0,73,1],[73,2,73,3],[76,0,76,1],[76,2,76,9],[77,0,77,1],[77,2,78,9],[80,0,80,1],[80,2,80,3],[80,4,80,9],[81,0,81,1],[81,2,81,3],[81,4,83,9],[82,0,82,1],[82,2,82,3],[83,0,83,1],[83,2,83,3],[85,0,85,9],[87,0,87,1],[87,2,87,3],[87,4,87,9],[88,0,88,1],[88,2,88,3],[88,4,90,9],[89,0,89,1],[89,2,89,3],[90,0,90,1],[90,2,90,3],[92,0,92,9],[94,0,94,1],[94,2,94,3],[94,4,94,9],[95,0,95,1],[95,2,95,3],[95,4,97,9],[96,0,96,1],[96,2,96,3],[97,0,97,1],[97,2,97,3],[101,0,106,9],[108,0,108,9],[114,2,114,3],[114,5,114,6],[115,0,115,1],[115,2,115,3],[115,5,115,6],[116,0,116,1],[116,2,116,3],[116,5,116,6],[117,0,117,1],[117,2,117,3],[117,5,117,6],[119,0,119,9],[121,0,121,1],[121,2,121,3],[121,4,121,5],[122,0,122,1],[122,2,122,3],[122,4,122,5],[123,0,123,1],[123,2,123,3],[123,4,123,5],[124,0,124,1],[124,2,124,3],[124,4,124,5],[125,0,125,1],[125,2,125,3],[125,4,125,5],[126,0,126,1],[126,2,126,3],[126,4,126,5],[127,0,127,1],[127,2,127,3],[127,4,127,5],[128,0,128,1],[128,2,128,3],[128,4,128,5],[129,0,129,1],[129,2,129,3],[129,4,129,5],[132,0,137,9]]}
[]
["4. TRATAMENTO DE EXCEDENTE/INSUFICIÊNCIA PATRIMONIAL"]
[]
["4.1. Excedente"]
[]
["4.1.1. Reserva de Contingência e Reserva Especial"]
[]
["a) Apuração da Reserva de Contingência e Reserva Especial"]
[]
["Item",null,null,"Valor"]
["Reserva Matemática BD",null,null,{"$f":"'3. Avaliação Atuarial'!G23+'3. Avaliação Atuarial'!G28-'3. Avaliação Atuarial'!G31","v":{"v":0,"d":"R$ 0.00"}}]
["Duração do passivo (anos)"]
["Limite da Reserva de Contingência",null,null,{"$f":"MIN(10%+1%*D12,25%)","v":{"v":0.1,"d":"10.00%"}}]
["Reserva de Contingência",null,null,{"$f":"MIN(MAX('3. Avaliação Atuarial'!E42,0),D11*D13)","v":{"v":0,"d":"R$ 0.00"}}]
["Reserva Especial",null,null,{"$f":"MAX('3. Avaliação Atuarial'!E42,0)-D14","v":{"v":0,"d":"R$ 0.00"}}]
[]
["b) Proporção Contributiva do Grupo em Retirada"]
[]
["Período de Constituição da Reserva Especial (Mês/Ano):",{"$nulls":5},"a"]
[]
[null,null,"Contribuições Normais",null,"%","Reserva Especial"]
["Participantes + Assistidos",{"$nulls":3},{"$f":"IF($C$24=0,0,C22/$C$24)","v":{"v":0,"d":"0.00%"}},{"$f":"$D$15*E22","v":{"v":0,"d":"R$ 0.00"}}]
["Patrocinadores",{"$nulls":3},{"$f":"IF($C$24=0,0,C23/$C$24)","v":{"v":0,"d":"0.00%"}},{"$f":"$D$15*E23","v":{"v":0,"d":"R$ 0.00"}}]
["Total",null,{"$f":"C22+C23","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"E22+E23","v":{"v":0,"d":"0.00%"}},{"$f":"F22+F23","v":{"v":0,"d":"R$ 0.00"}}]
[]
["OBSERVAÇÕES ADICIONAIS"]
[]
[]
[]
[]
[]
[]
["4.1.2. Fundos"]
[]
["4.1.2.1. Fundos Previdenciais"]
[]
["Nome do Fundo:"]
["Finalidade:"]
[]
[]
["Destinatário",null,"Valor (R$)",null,"Justificativa"]
["Participantes + Assistidos"]
["Patrocinadores"]
["Total",null,{"$f":"C42+C43","v":0}]
[]
[]
["Nome do Fundo:"]
["Finalidade:"]
[]
[]
["Destinatário",null,"Valor (R$)",null,"Justificativa"]
["Participantes + Assistidos"]
["Patrocinadores"]
["Total",null,{"$f":"C52+C53","v":0}]
[]
[]
["Nome do Fundo:"]
["Finalidade:"]
[]
[]
["Destinatário",null,"Valor (R$)",null,"Justificativa"]
["Participantes + Assistidos"]
["Patrocinadores"]
["Total",null,{"$f":"C62+C63","v":0}]
[]
[]
["Nome do Fundo:"]
["Finalidade:"]
[]
[]
["Destinatário",null,"Valor (R$)",null,"Justificativa"]
["Participantes + Assistidos"]
["Patrocinadores"]
["Total",null,{"$f":"C72+C73","v":0}]
[]
[]
["Nome do Fundo:"]
["Finalidade:"]
[]
[]
["Destinatário",null,"Valor (R$)",null,"Justificativa"]
["Participantes + Assistidos"]
["Patrocinadores"]
["Total",null,{"$f":"C82+C83","v":0}]
[]
["4.1.2.2. Fundo Administrativo"]
[]
["Destinatário",null,"Valor (R$)",null,"Justificativa"]
["Participantes + Assistidos"]
["Patrocinadores"]
["Total",null,{"$f":"C89+C90","v":0}]
[]
["4.1.2.3. Fundos dos Investimentos"]
[]
["Destinatário",null,"Valor (R$)",null,"Justificativa"]
["Participantes + Assistidos"]
["Patrocinadores"]
["Total",null,{"$f":"C96+C97","v":0}]
[]
[]
["OBSERVAÇÕES ADICIONAIS"]
{"$rows_empty":7}
["4.2. Insuficiência"]
[]
["a) Proporção Contributiva do Grupo em Retirada"]
[]
["Período de Constituição do Déficit (Mês/Ano):",{"$nulls":4},"a"]
[]
[null,null,"Contribuições Normais",null,"%","Déficit a Equacionar"]
["Participantes + Assistidos",{"$nulls":3},{"$f":"IF($C$118=0,0,C116/$C$118)","v":{"v":0,"d":"0.00%"}},{"$f":"-MIN('3. Avaliação Atuarial'!$E$42,0)*E116","v":{"v":0,"d":"R$ 0.00"}}]
["Patrocinadores",{"$nulls":3},{"$f":"IF($C$118=0,0,C117/$C$118)","v":{"v":0,"d":"0.00%"}},{"$f":"-MIN('3. Avaliação Atuarial'!$E$42,0)*E117","v":{"v":0,"d":"R$ 0.00"}}]
["Total",null,{"$f":"SUM(C116:D117)","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"E116+E117","v":{"v":0,"d":"0.00%"}},{"$f":"F116+F117","v":{"v":0,"d":"R$ 0.00"}}]
[]
["4.3. Resumo"]
[]
["Item",null,"Participantes/Assistidos",null,"Patrocinadores"]
["Excedente",null,{"$f":"SUM(C124:D128)","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"SUM(E124:F128)","v":{"v":0,"d":"R$ 0.00"}}]
["Reserva de Contingência",null,{"$f":"reserva_contingencia","v":{"v":0,"d":"R$ 0.00"}},null,{"v":0,"d":"R$ 0.00"}]
["Reserva Especial",null,{"$f":"re_part","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"re_patr","v":{"v":0,"d":"R$ 0.00"}}]
["Fundos Previdenciais",null,{"$f":"C42+C52+C62+C72+C82","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"C43+C53+C63+C73+C83","v":{"v":0,"d":"R$ 0.00"}}]
["Fundo Administrativo",null,{"$f":"C89","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"C90","v":{"v":0,"d":"R$ 0.00"}}]
["Fundo dos Investimentos",null,{"$f":"C96","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"C97","v":{"v":0,"d":"R$ 0.00"}}]
["Insuficiência",null,{"$f":"-def_part","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"-def_patr","v":{"v":0,"d":"R$ 0.00"}}]
["Total",null,{"$f":"C123+C129","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"E123+E129","v":{"v":0,"d":"R$ 0.00"}}]
[]
["OBSERVAÇÕES ADICIONAIS"]

{"sheet":"5. Dívidas e + compromissos","index":5,"n_rows":38,"n_cols":6,"rows_kept":38,"merged":[[1,0,1,9],[3,6,3,7],[5,2,7,9],[10,6,10,7],[12,2,14,9],[17,6,17,7],[19,2,21,9],[24,6,24,7],[26,2,28,9],[31,6,31,7],[33,2,35,9],[38,0,43,9]]}
[]
["5. CONTRATOS DE DÍVIDAS E OUTROS COMPROMISSOS DOS PATROCINADORES"]
[]
["Natureza:",null,1,null,null,"Valor:"]
[]
["Relato sobre cumprimento:"]
[]
[]
[]
[]
["Natureza:",null,1,null,null,"Valor:"]
[]
["Relato sobre cumprimento:"]
[]
[]
[]
[]
["Natureza:",null,1,null,null,"Valor:"]
[]
["Relato sobre cumprimento:"]
[]
[]
[]
[]
["Natureza:",null,1,null,null,"Valor:"]
[]
["Relato sobre cumprimento:"]
[]
[]
[]
[]
["Natureza:",null,1,null,null,"Valor:"]
[]
["Relato sobre cumprimento:"]
[]
[]
[]
["OBSERVAÇÕES ADICIONAIS"]

{"sheet":"6. Demandas Judiciais","index":6,"n_rows":53,"n_cols":9,"rows_kept":53,"merged":[[1,0,1,9],[3,0,3,1],[3,2,3,3],[3,4,3,5],[3,6,3,7],[3,8,3,9],[4,0,9,1],[4,2,6,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[5,4,5,5],[5,6,5,7],[5,8,5,9],[6,4,6,5],[6,6,6,7],[6,8,6,9],[7,2,9,3],[7,4,7,5],[7,6,7,7],[7,8,7,9],[8,4,8,5],[8,6,8,7],[8,8,8,9],[9,4,9,5],[9,6,9,7],[9,8,9,9],[10,0,15,1],[10,2,12,3],[10,4,10,5],[10,6,10,7],[10,8,10,9],[11,4,11,5],[11,6,11,7],[11,8,11,9],[12,4,12,5],[12,6,12,7],[12,8,12,9],[13,2,15,3],[13,4,13,5],[13,6,13,7],[13,8,13,9],[14,4,14,5],[14,6,14,7],[14,8,14,9],[15,4,15,5],[15,6,15,7],[15,8,15,9],[16,0,21,1],[16,2,18,3],[16,4,16,5],[16,6,16,7],[16,8,16,9],[17,4,17,5],[17,6,17,7],[17,8,17,9],[18,4,18,5],[18,6,18,7],[18,8,18,9],[19,2,21,3],[19,4,19,5],[19,6,19,7],[19,8,19,9],[20,4,20,5],[20,6,20,7],[20,8,20,9],[21,4,21,5],[21,6,21,7],[21,8,21,9],[22,0,27,1],[22,2,24,3],[22,4,22,5],[22,6,22,7],[22,8,22,9],[23,4,23,5],[23,6,23,7],[23,8,23,9],[24,4,24,5],[24,6,24,7],[24,8,24,9],[25,2,27,3],[25,4,25,5],[25,6,25,7],[25,8,25,9],[26,4,26,5],[26,6,26,7],[26,8,26,9],[27,4,27,5],[27,6,27,7],[27,8,27,9],[28,0,28,5],[28,6,28,7],[28,8,28,9],[32,1,32,2],[32,5,32,9],[34,0,34,1],[34,2,34,3],[34,4,34,5],[34,6,34,7],[34,8,34,9],[35,0,35,1],[35,2,35,3],[35,4,35,5],[35,6,35,7],[35,8,35,9],[38,1,38,2],[38,5,38,9],[40,0,40,1],[40,2,40,3],[40,4,40,5],[40,6,40,7],[40,8,40,9],[41,0,41,1],[41,2,41,3],[41,4,41,5],[41,6,41,7],[41,8,41,9],[44,1,44,2],[44,5,44,9],[46,0,46,1],[46,2,46,3],[46,4,46,5],[46,6,46,7],[46,8,46,9],[47,0,47,1],[47,2,47,3],[47,4,47,5],[47,6,47,7],[47,8,47,9],[50,1,50,2],[50,5,50,9],[52,0,52,1],[52,2,52,3],[52,4,52,5],[52,6,52,7],[52,8,52,9],[53,0,53,1],[53,2,53,3],[53,4,53,5],[53,6,53,7],[53,8,53,9]]}
[]
["6. RELATÓRIO DE DEMANDAS JUDICIAIS PASSIVAS (relacionadas direta ou indiretamente com o grupo em retirada)"]
[]
["Matéria",null,"Natureza",null,"Classificação de Risco",null,"Total (R$)",null,"Contabilizadas (R$)"]
["Previdenciária",null,"Coletiva",null,"Remota"]
[{"$nulls":4},"Possível"]
[{"$nulls":4},"Provável"]
[null,null,"Individual",null,"Remota"]
[{"$nulls":4},"Possível"]
[{"$nulls":4},"Provável"]
["Tributária",null,"Coletiva",null,"Remota"]
[{"$nulls":4},"Possível"]
[{"$nulls":4},"Provável"]
[null,null,"Individual",null,"Remota"]
[{"$nulls":4},"Possível"]
[{"$nulls":4},"Provável"]
["Trabalhista",null,"Coletiva",null,"Remota"]
[{"$nulls":4},"Possível"]
[{"$nulls":4},"Provável"]
[null,null,"Individual",null,"Remota"]
[{"$nulls":4},"Possível"]
[{"$nulls":4},"Provável"]
["Outras",null,"Coletiva",null,"Remota"]
[{"$nulls":4},"Possível"]
[{"$nulls":4},"Provável"]
[null,null,"Individual",null,"Remota"]
[{"$nulls":4},"Possível"]
[{"$nulls":4},"Provável"]
["Total",{"$nulls":5},{"$f":"SUM(G5:H28)","v":{"v":0,"d":"R$ 0.00"}},null,{"$f":"SUM(I5:J28)","v":{"v":0,"d":"R$ 0.00"}}]
[]
["Relação das Principais Ações Judiciais (relacionadas direta ou indiretamente com o grupo em retirada)"]
[]
["Nr. Processo:",{"$nulls":3},"Órgão Jurisdicional:"]
[]
["Matéria",null,"Natureza",null,"Classificação de Risco",null,"Total (R$)",null,"Contabilizado (R$)"]
[]
[]
[]
["Nr. Processo:",{"$nulls":3},"Órgão Jurisdicional:"]
[]
["Matéria",null,"Natureza",null,"Classificação de Risco",null,"Total (R$)",null,"Contabilizado (R$)"]
[]
[]
[]
["Nr. Processo:",{"$nulls":3},"Órgão Jurisdicional:"]
[]
["Matéria",null,"Natureza",null,"Classificação de Risco",null,"Total (R$)",null,"Contabilizado (R$)"]
[]
[]
[]
["Nr. Processo:",{"$nulls":3},"Órgão Jurisdicional:"]
[]
["Matéria",null,"Natureza",null,"Classificação de Risco",null,"Total (R$)",null,"Contabilizado (R$)"]

{"sheet":"7. Obrigações do Patrocinador","index":7,"n_rows":13,"n_cols":5,"rows_kept":13,"merged":[[1,0,1,9],[3,0,3,3],[3,4,3,5],[4,0,4,3],[4,4,4,5],[5,0,5,3],[5,4,5,5],[6,0,6,3],[6,4,6,5],[7,0,7,3],[7,4,7,5],[8,0,8,3],[8,4,8,5],[9,0,9,3],[9,4,9,5],[10,0,10,3],[10,4,10,5],[13,0,18,9]]}
[]
["7. OBRIGAÇÕES E COMPROMISSOS ESTIMADOS DOS PATROCINADORES"]
[]
["Item",{"$nulls":3},"Valor (R$)"]
["Equacionamento de déficit",{"$nulls":3},{"$f":"'4. Excedente-Insuficiência'!F117","v":0}]
["Assunção adicional de déficit"]
["Dívidas e outros compromissos",{"$nulls":3},{"$f":"'5. Dívidas e + compromissos'!G4+'5. Dívidas e + compromissos'!G11+'5. Dívidas e + compromissos'!G18+'5. Dívidas e + compromissos'!G25+'5. Dívidas e + compromissos'!G32","v":0}]
["Despesas administrativas"]
["Garantia de sobrevida mínima aos assistidos"]
["Renúncia de excedente"]
["Total",{"$nulls":3},{"$f":"SUM(E5:F10)","v":0}]
[]
["OBSERVAÇÕES ADICIONAIS"]

{"sheet":"8. Reserva Matemática Final","index":8,"n_rows":21,"n_cols":4,"rows_kept":21,"merged":[[1,0,1,9],[3,0,3,2],[3,3,3,4],[4,0,4,2],[4,3,4,4],[5,0,5,2],[5,3,5,4],[6,0,6,2],[6,3,6,4],[7,0,7,2],[7,3,7,4],[8,0,8,2],[8,3,8,4],[9,0,9,2],[9,3,9,4],[10,0,10,2],[10,3,10,4],[11,0,11,2],[11,3,11,4],[12,0,12,2],[12,3,12,4],[13,0,13,2],[13,3,13,4],[14,0,14,2],[14,3,14,4],[15,0,15,2],[15,3,15,4],[16,0,16,2],[16,3,16,4],[17,0,17,2],[17,3,17,4],[18,0,18,2],[18,3,18,4],[21,0,26,9]]}
[]
["8. RESERVA MATEMÁTICA FINAL DE RETIRADA"]
[]
["Item",null,null,"Valor (R$)"]
["Reserva Matemática (líquida da PMaC)",null,null,{"$f":"'3. Avaliação Atuarial'!E39+'3. Avaliação Atuarial'!E40-'3. Avaliação Atuarial'!G33","v":{"v":0,"d":"0.00"}}]
["Excedente Patrimonial",null,null,{"$f":"SUM(D7:E11)","v":{"v":0,"d":"0.00"}}]
["Reserva de Contingência",null,null,{"$f":"'4. Excedente-Insuficiência'!D14","v":{"v":0,"d":"0.00"}}]
["Reserva Especial",null,null,{"$f":"'4. Excedente-Insuficiência'!F22","v":{"v":0,"d":"0.00"}}]
["Fundos Previdenciais",null,null,{"$f":"'4. Excedente-Insuficiência'!C42+'4. Excedente-Insuficiência'!C52+'4. Excedente-Insuficiência'!C62+'4. Excedente-Insuficiência'!C72+'4. Excedente-Insuficiência'!C82","v":{"v":0,"d":"0.00"}}]
["Fundo Administrativo",null,null,{"$f":"'4. Excedente-Insuficiência'!C89","v":{"v":0,"d":"0.00"}}]
["Fundo dos Investimentos",null,null,{"$f":"'4. Excedente-Insuficiência'!C96","v":{"v":0,"d":"0.00"}}]
["(-) Insuficiência Patrimonial",null,null,{"$f":"D13","v":{"v":0,"d":"0.00"}}]
["(-) Equacionamento de déficit",null,null,{"$f":"-def_part","v":{"v":0,"d":"0.00"}}]
["Compromissos obrigatórios do patrocinador",null,null,{"$f":"D15","v":{"v":0,"d":"0.00"}}]
["Garantia de sobrevida mínima aos assistidos",null,null,{"$f":"'7. Obrigações do Patrocinador'!E9","v":{"v":0,"d":"0.00"}}]
["Compromissos facultativos do patrocinador",null,null,{"$f":"SUM(D17:E18)","v":{"v":0,"d":"0.00"}}]
["Renúncia de excedente",null,null,{"$f":"'7. Obrigações do Patrocinador'!E10","v":{"v":0,"d":"0.00"}}]
["Assunção adicional de déficit",null,null,{"$f":"'7. Obrigações do Patrocinador'!E6","v":{"v":0,"d":"0.00"}}]
["Total",null,null,{"$f":"D5+D6+D12+D14+D16","v":{"v":0,"d":"0.00"}}]
[]
["OBSERVAÇÕES ADICIONAIS"]

{"sheet":"Extra","index":9,"n_rows":2,"n_cols":1,"rows_kept":2,"merged":[[1,0,1,8]]}
[]
["INFORMAÇÕES EXTRAS (apresentar quadros e informações no mesmo formato das demais seções)"]

{"sheet":"Versões","index":10,"n_rows":4,"n_cols":4,"rows_kept":4,"hidden":true}
["CONTROLE DE VERSÕES"]
[]
["Versão","Data","Autor","Mudanças realizadas"]
["1.1","2020-08-31","robson.aguiar","- Alteração em \"Orientações - GERAL\", para deixar claro que o arquivo deve ser enviado à Previc no formato xlsx;\n- Alteração em \"Orientações - 6. Relatório de Demandas Judiciais Passivas\", para ajustar à alteração realizada em \"6. Relatório de Demandas Judiciais Passivas\";\n- Alteração em \"6. Relatório de Demandas Judiciais Passivas\" para fazer constar no título que as ações que devem ser preenchidas são aquelas relacionadas direta ou indiretamente ao grupo em retirada e contemplar nas colunas de valor o total das ações e o valor contabilizado."]

{"sheet":"Inconsistências","index":11,"n_rows":4,"n_cols":1,"rows_kept":4,"merged":[[1,0,1,8],[3,0,3,8],[4,0,4,8],[5,0,5,8],[6,0,6,8],[7,0,7,8],[8,0,8,8],[9,0,9,8],[10,0,10,8],[11,0,11,8],[12,0,12,8],[13,0,13,8],[14,0,14,8],[15,0,15,8],[16,0,16,8],[17,0,17,8],[18,0,18,8],[19,0,19,8],[20,0,20,8],[21,0,21,8],[22,0,22,8],[23,0,23,8],[24,0,24,8],[25,0,25,8],[26,0,26,8],[27,0,27,8],[28,0,28,8],[29,0,29,8],[30,0,30,8],[31,0,31,8],[32,0,32,8],[33,0,33,8],[34,0,34,8],[35,0,35,8],[36,0,36,8],[37,0,37,8],[38,0,38,8],[39,0,39,8],[40,0,40,8],[41,0,41,8],[42,0,42,8],[43,0,43,8],[44,0,44,8],[45,0,45,8],[46,0,46,8],[47,0,47,8],[48,0,48,8],[49,0,49,8],[50,0,50,8],[51,0,51,8],[52,0,52,8],[53,0,53,8],[54,0,54,8],[55,0,55,8],[56,0,56,8],[57,0,57,8],[58,0,58,8],[59,0,59,8],[60,0,60,8],[61,0,61,8],[62,0,62,8],[63,0,63,8],[64,0,64,8],[65,0,65,8],[66,0,66,8],[67,0,67,8],[68,0,68,8],[69,0,69,8],[70,0,70,8],[71,0,71,8],[72,0,72,8],[73,0,73,8],[74,0,74,8],[75,0,75,8],[76,0,76,8],[77,0,77,8],[78,0,78,8],[79,0,79,8],[80,0,80,8],[81,0,81,8],[82,0,82,8],[83,0,83,8],[84,0,84,8],[85,0,85,8],[86,0,86,8],[87,0,87,8],[88,0,88,8],[89,0,89,8],[90,0,90,8],[91,0,91,8],[92,0,92,8],[93,0,93,8],[94,0,94,8],[95,0,95,8],[96,0,96,8],[97,0,97,8],[98,0,98,8],[99,0,99,8],[100,0,100,8],[101,0,101,8],[102,0,102,8],[103,0,103,8],[104,0,104,8],[105,0,105,8],[106,0,106,8],[107,0,107,8],[108,0,108,8],[109,0,109,8],[110,0,110,8],[111,0,111,8],[112,0,112,8],[113,0,113,8],[114,0,114,8],[115,0,115,8]]}
[]
["REGISTRO DE INCONSISTÊNCIAS NO PREENCHIMENTO"]
[]
["Inconsistência (clique para acessar)"]

{"sheet":"Aux","index":12,"n_rows":12,"n_cols":2,"rows_kept":12,"hidden":true}
["Critérios de Segregação Patrimonial"]
[]
[1,"Proporção das Reservas Matemáticas"]
[2,"Segregação Real"]
[3,"Outro"]
[]
["Natureza de Contratos de Dívida"]
[]
[2,"Déficit equacionado"]
[3,"Tempo de serviço passado"]
[4,"Contribuições em atraso"]
[5,"Outra"]