{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["广州市花都区政策性农业设施大棚保险承保汇总表","广州市花都区政策性农业设施大棚保险承保明细表"],"read":"whole","date_system":"1900"}

{"sheet":"广州市花都区政策性农业设施大棚保险承保汇总表","index":0,"n_rows":8,"n_cols":12,"rows_kept":8,"merged":[[0,0,0,11],[2,0,2,3],[2,7,2,11],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,4,11],[7,0,7,1]]}
["广州市花都区政策性农业设施大棚保险承保汇总表"]
[]
["统计季度： 2020 年第 1、2 季度",{"$nulls":6},"                                    单位：亩、元"]
["序号","行政区域","本季承保数量","本季投保总金额","本季投保总保费","中央财政补贴",null,"市本级财政补贴",null,"区级财政补贴",null,"备注"]
[{"$nulls":5},"补贴比例","补贴金额","补贴比例","补贴金额","补贴比例","补贴金额"]
[1,"花都区",1167.16,{"$f":"C6*3000","v":{"v":3501480,"d":"3,501,480.00"}},{"$f":"C6*180","v":{"v":210088.8,"d":"210,088.80"}},"-","-",{"v":0.24,"d":"24%"},{"$f":"E6*0.24","v":{"v":50421.312,"d":"50,421.31"}},{"v":0.36,"d":"36%"},{"$f":"E6*0.36","v":{"v":75631.968,"d":"75,631.97"}},"保险标的：简易大棚"]
[]
["全区合计",null,{"$f":"SUM(C6:C7)","v":1167.16},{"$f":"SUM(D6:D7)","v":{"v":3501480,"d":"3,501,480.00"}},{"$f":"SUM(E6:E7)","v":{"v":210088.8,"d":"210,088.80"}},"-","-",{"v":0.24,"d":"24%"},{"$f":"SUM(I6:I7)","v":{"v":50421.312,"d":"50,421.31"}},{"v":0.36,"d":"36%"},{"$f":"SUM(K6:K7)","v":{"v":75631.968,"d":"75,631.97"}},"-"]

{"sheet":"广州市花都区政策性农业设施大棚保险承保明细表","index":1,"n_rows":38,"n_cols":13,"rows_kept":38,"merged":[[0,0,0,12],[1,0,1,12],[37,0,37,2],[37,4,37,6]]}
["广州市花都区政策性农业设施大棚保险承保明细表"]
["统计日期： 2020 年第 1、2 季度                                                                                                          单位：亩、元"]
["序号","被保险人","标的名称","保险数量","标的种养地点","保险\n起始日","保险\n终止日","保险金额","总保费","中央补贴金额","市级补贴金额","区级补贴金额","农户负担金额"]
[1,"曹亮","简易大棚",37.8,"广州市花都区花东镇大东村","2020-01-10","2021-01-09",{"v":113400,"d":"113,400.00"},{"v":6804,"d":"6,804.00"},"-",{"v":1632.96,"d":"1,632.96"},{"v":2449.44,"d":"2,449.44"},{"v":2721.6,"d":"2,721.60"}]
[2,"周小平","简易大棚",26,"广州市花都区花东镇大塘村","2020-01-10","2021-01-09",{"v":78000,"d":"78,000.00"},{"v":4680,"d":"4,680.00"},"-",{"v":1123.2,"d":"1,123.20"},{"v":1684.8,"d":"1,684.80"},{"v":1872,"d":"1,872.00"}]
[3,"雷选勇","简易大棚",60,"广州市花都区花东镇高溪村","2020-01-15","2021-01-14",{"v":180000,"d":"180,000.00"},{"v":10800,"d":"10,800.00"},"-",{"v":2592,"d":"2,592.00"},{"v":3888,"d":"3,888.00"},{"v":4320,"d":"4,320.00"}]
[4,"周送平","简易大棚",9,"广州市花都区花东镇山下村","2020-01-15","2021-01-14",{"v":27000,"d":"27,000.00"},{"v":1620,"d":"1,620.00"},"-",{"v":388.8,"d":"388.80"},{"v":583.2,"d":"583.20"},{"v":648,"d":"648.00"}]
[5,"李丹","简易大棚",37.8,"广州市花都区花东镇大东村","2020-03-03","2021-03-02",{"v":113400,"d":"113,400.00"},{"v":6804,"d":"6,804.00"},"-",{"v":1632.96,"d":"1,632.96"},{"v":2449.44,"d":"2,449.44"},{"v":2721.6,"d":"2,721.60"}]
[6,"杨日娟","简易大棚",24,"广州市花都区花东镇大东村","2020-03-03","2021-03-02",{"v":72000,"d":"72,000.00"},{"v":4320,"d":"4,320.00"},"-",{"v":1036.8,"d":"1,036.80"},{"v":1555.2,"d":"1,555.20"},{"v":1728,"d":"1,728.00"}]
[7,"周仁乔","简易大棚",39.6,"广州市花都区花东镇阳升村","2020-03-03","2021-03-02",{"v":118800,"d":"118,800.00"},{"v":7128,"d":"7,128.00"},"-",{"$f":"I10*0.24","v":{"v":1710.72,"d":"1,710.72"}},{"$f":"I10*0.36","v":{"v":2566.08,"d":"2,566.08"}},{"$f":"I10*0.4","v":{"v":2851.2,"d":"2,851.20"}}]
[8,"马莲尧","简易大棚",22,"广州市花都区花东镇阳升村","2020-03-03","2021-03-02",{"v":66000,"d":"66,000.00"},{"v":3960,"d":"3,960.00"},"-",{"v":950.4,"d":"950.40"},{"v":1425.6,"d":"1,425.60"},{"v":1584,"d":"1,584.00"}]
[9,"周圣祥","简易大棚",41.5,"广州市花都区花东镇阳升村","2020-03-04","2021-03-03",{"v":124500,"d":"124,500.00"},{"v":7470,"d":"7,470.00"},"-",{"v":1792.8,"d":"1,792.80"},{"v":2689.2,"d":"2,689.20"},{"v":2988,"d":"2,988.00"}]
[10,"周贤书","简易大棚",38.6,"广州市花都区花东镇阳升村","2020-03-04","2021-03-03",{"v":115800,"d":"115,800.00"},{"v":6948,"d":"6,948.00"},"-",{"v":1667.52,"d":"1,667.52"},{"v":2501.28,"d":"2,501.28"},{"v":2779.2,"d":"2,779.20"}]
[11,"周林英","简易大棚",18,"广州市花都区花东镇九子村","2020-03-04","2021-03-03",{"v":54000,"d":"54,000.00"},{"v":3240,"d":"3,240.00"},"-",{"v":777.6,"d":"777.60"},{"v":1166.4,"d":"1,166.40"},{"v":1296,"d":"1,296.00"}]
[12,"廖园锋","简易大棚",51.5,"广州市花都区花东镇农光村","2020-03-04","2021-03-03",{"v":154500,"d":"154,500.00"},{"v":9270,"d":"9,270.00"},"-",{"v":2224.8,"d":"2,224.80"},{"v":3337.2,"d":"3,337.20"},{"v":3708,"d":"3,708.00"}]
[13,"廖孟相","简易大棚",46,"广州市花都区花东镇九子村","2020-03-04","2021-03-03",{"v":138000,"d":"138,000.00"},{"v":8280,"d":"8,280.00"},"-",{"v":1987.2,"d":"1,987.20"},{"v":2980.8,"d":"2,980.80"},{"v":3312,"d":"3,312.00"}]
[14,"胡香月","简易大棚",19,"广州市花都区花东镇珠湖村","2020-03-04","2021-03-03",{"v":57000,"d":"57,000.00"},{"v":3420,"d":"3,420.00"},"-",{"v":820.8,"d":"820.80"},{"v":1231.2,"d":"1,231.20"},{"v":1368,"d":"1,368.00"}]
[15,"廖誉函","简易大棚",43,"广州市花都区花东镇联安村","2020-03-04","2021-03-03",{"v":129000,"d":"129,000.00"},{"v":7740,"d":"7,740.00"},"-",{"v":1857.6,"d":"1,857.60"},{"v":2786.4,"d":"2,786.40"},{"v":3096,"d":"3,096.00"}]
[16,"黄兰翠","简易大棚",19,"广州市花都区花东镇联安村","2020-03-05","2021-03-04",{"v":57000,"d":"57,000.00"},{"v":3420,"d":"3,420.00"},"-",{"v":820.8,"d":"820.80"},{"v":1231.2,"d":"1,231.20"},{"v":1368,"d":"1,368.00"}]
[17,"廖孔三","简易大棚",45,"广州市花都区花东镇联安村","2020-03-05","2021-03-04",{"v":135000,"d":"135,000.00"},{"v":8100,"d":"8,100.00"},"-",{"v":1944,"d":"1,944.00"},{"v":2916,"d":"2,916.00"},{"v":3240,"d":"3,240.00"}]
[18,"曹飞","简易大棚",41.8,"广州市花都区花东镇竹湖村","2020-03-05","2021-03-04",{"v":125400,"d":"125,400.00"},{"v":7524,"d":"7,524.00"},"-",{"v":1805.76,"d":"1,805.76"},{"v":2708.64,"d":"2,708.64"},{"v":3009.6,"d":"3,009.60"}]
[19,"陈神建","简易大棚",39,"广州市花都区花东镇七星村","2020-03-05","2021-03-04",{"v":117000,"d":"117,000.00"},{"v":7020,"d":"7,020.00"},"-",{"v":1684.8,"d":"1,684.80"},{"v":2527.2,"d":"2,527.20"},{"v":2808,"d":"2,808.00"}]
[20,"廖夺艳","简易大棚",35,"广州市花都区花山镇和郁村","2020-03-05","2021-03-04",{"v":105000,"d":"105,000.00"},{"v":6300,"d":"6,300.00"},"-",{"v":1512,"d":"1,512.00"},{"v":2268,"d":"2,268.00"},{"v":2520,"d":"2,520.00"}]
[21,"罗志高","简易大棚",62,"广州市花都区花山镇和郁村","2020-03-05","2021-03-04",{"v":186000,"d":"186,000.00"},{"v":11160,"d":"11,160.00"},"-",{"v":2678.4,"d":"2,678.40"},{"v":4017.6,"d":"4,017.60"},{"v":4464,"d":"4,464.00"}]
[22,"尹旭辉","简易大棚",42.5,"广州市花都区花山镇红群村","2020-03-05","2021-03-04",{"v":127500,"d":"127,500.00"},{"v":7650,"d":"7,650.00"},"-",{"v":1836,"d":"1,836.00"},{"v":2754,"d":"2,754.00"},{"v":3060,"d":"3,060.00"}]
[23,"李庆佳","简易大棚",57.6,"广州市花都区花山镇永乐村","2020-03-05","2021-03-04",{"v":172800,"d":"172,800.00"},{"v":10368,"d":"10,368.00"},"-",{"v":2488.32,"d":"2,488.32"},{"v":3732.48,"d":"3,732.48"},{"v":4147.2,"d":"4,147.20"}]
[24,"廖孔英","简易大棚",36.8,"广州市花都区花山镇儒林村","2020-03-05","2021-03-04",{"v":110400,"d":"110,400.00"},{"v":6624,"d":"6,624.00"},"-",{"v":1589.76,"d":"1,589.76"},{"v":2384.64,"d":"2,384.64"},{"v":2649.6,"d":"2,649.60"}]
[25,"廖小香","简易大棚",23,"广州市花都区花山镇紫西村","2020-03-06","2021-03-05",{"v":69000,"d":"69,000.00"},{"v":4140,"d":"4,140.00"},"-",{"v":993.6,"d":"993.60"},{"v":1490.4,"d":"1,490.40"},{"v":1656,"d":"1,656.00"}]
[26,"廖利香","简易大棚",25,"广州市花都区花山镇紫西村","2020-03-06","2021-03-05",{"v":75000,"d":"75,000.00"},{"v":4500,"d":"4,500.00"},"-",{"v":1080,"d":"1,080.00"},{"v":1620,"d":"1,620.00"},{"v":1800,"d":"1,800.00"}]
[27,"廖万位","简易大棚",41.6,"广州市花都区花山镇紫西村","2020-03-10","2021-03-09",{"v":124800,"d":"124,800.00"},{"v":7488,"d":"7,488.00"},"-",{"v":1797.12,"d":"1,797.12"},{"v":2695.68,"d":"2,695.68"},{"v":2995.2,"d":"2,995.20"}]
[28,"廖荣朱","简易大棚",67,"广州市花都区花山镇紫西村","2020-03-10","2021-03-09",{"v":201000,"d":"201,000.00"},{"v":12060,"d":"12,060.00"},"-",{"v":2894.4,"d":"2,894.40"},{"v":4341.6,"d":"4,341.60"},{"v":4824,"d":"4,824.00"}]
[29,"廖丽美","简易大棚",21,"广州市花都区花山镇紫西村","2020-03-10","2021-03-09",{"v":63000,"d":"63,000.00"},{"v":3780,"d":"3,780.00"},"-",{"v":907.2,"d":"907.20"},{"v":1360.8,"d":"1,360.80"},{"v":1512,"d":"1,512.00"}]
[30,"廖贱荣","简易大棚",15,"广州市花都区花山镇紫西村","2020-03-10","2021-03-09",{"v":45000,"d":"45,000.00"},{"v":2700,"d":"2,700.00"},"-",{"v":648,"d":"648.00"},{"v":972,"d":"972.00"},{"v":1080,"d":"1,080.00"}]
[31,"广州市朝辉农业发展有限公司","简易大棚",51.3,"广州市花都区花山镇南村","2020-04-08","2021-04-07",{"v":153900,"d":"153,900.00"},{"v":9234,"d":"9,234.00"},"-",{"v":2216.16,"d":"2,216.16"},{"v":3324.24,"d":"3,324.24"},{"v":3693.6,"d":"3,693.60"}]
[32,"罗胜勇","简易大棚",8.84,"广州市花都区炭步镇塱头村","2020-04-29","2021-04-28",{"v":26520,"d":"26,520.00"},{"v":1591.2,"d":"1,591.20"},"-",{"v":381.888,"d":"381.89"},{"v":572.832,"d":"572.83"},636.48]
[33,"周飞涛","简易大棚",15,"广州市花都区花东镇山下村","2020-05-16","2021-05-15",{"v":45000,"d":"45,000.00"},{"v":2700,"d":"2,700.00"},"-",{"v":648,"d":"648.00"},{"v":972,"d":"972.00"},{"v":1080,"d":"1,080.00"}]
[34,"吴延平","简易大棚",6.92,"广州市花都区炭步镇塱头村","2020-05-21","2021-05-20",{"v":20760,"d":"20,760.00"},{"v":1245.6,"d":"1,245.60"},"-",298.94,448.42,498.24]
["合计",null,null,{"$f":"SUM(D4:D37)","v":1167.16},"-",null,null,{"$f":"SUM(H4:H37)","v":{"v":3501480,"d":"3,501,480.00"}},{"$f":"SUM(I4:I37)","v":{"v":210088.8,"d":"210,088.80"}},"-",{"$f":"SUM(K4:K37)","v":{"v":50421.308,"d":"50,421.31"}},{"$f":"SUM(L4:L37)","v":{"v":75631.972,"d":"75,631.97"}},{"$f":"SUM(M4:M37)","v":{"v":84035.52,"d":"84,035.52"}}]