{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Define","收入","含民生支出"],"not_rendered":{"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Define","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"hidden":true,"flags":["formulas_cached_only"]}
[]
["ZBMBOOKDIR_S=","D:\\总会\\历年日常\\2020年工作\\6月\\分析"]
["ZBMBOOKDIR_O=","D:\\总会\\历年日常\\2020年工作\\6月\\分析"]
["ZBMBOOK_S=","2006收支竖表.xls"]
["ZBMBOOK_O=","2006收支竖表.xls"]
["ZBMSHEET_S=","含民生支出"]
["ZBMSHEET_O=","含民生支出"]
["ZBM_ZBMCOLUMN_S=",18]
["ZBM_ZBMCOLUMN_O=",17]
["ZBM_CALCCOLUMNS_S=","t"]
["ZBM_CALCCOLUMNS_O=","j"]

{"sheet":"收入","index":1,"n_rows":38,"n_cols":14,"rows_kept":38,"merged":[[0,0,0,10]],"flags":["formulas_cached_only"]}
["阎良区地方财政收入执行情况表",{"$nulls":11},"月份",6]
[{"$nulls":6},"2020-06-01",{"$nulls":3},"单位：万元"]
["项　目","年初预算","调整预算","本月执行","同期当月","当月增幅","累计完成","上年同期","完成年初%","完成调整%","同比增减","上月数","序时任务","序时差距"]
["一般公共预算收入合计",74350,50460,3477,1070,{"v":2.249532710280374,"d":"225.0%"},33020,34707,{"v":0.4441156691324815,"d":"44.4%"},{"v":0.654379706698375,"d":"65.4%"},{"v":-0.04860690926902356,"d":"-4.9%"},29543,{"v":37175,"d":"37,175"},{"v":-4155,"d":"-4,155"}]
["一、税收收入",56510,37320,2322,813,{"v":1.8560885608856088,"d":"185.6%"},25121,29059,{"v":0.44454078924084234,"d":"44.5%"},{"v":0.6731243301178993,"d":"67.3%"},{"v":-0.1355173956433463,"d":"-13.6%"},22799,{"v":28255,"d":"28,255"},{"v":-3134,"d":"-3,134"}]
["1、工商税收",46890,26650,1983,1620,{"v":0.2240740740740741,"d":"22.4%"},22724,25255,{"v":0.48462358711878867,"d":"48.5%"},{"v":0.8526829268292683,"d":"85.3%"},{"v":-0.10021777865769155,"d":"-10.0%"},20741,{"v":23445,"d":"23,445"},-721]
["　增值税",23000,2090,1132,742,{"v":0.5256064690026954,"d":"52.6%"},11111,12009,{"v":0.4830869565217391,"d":"48.3%"},{"v":5.316267942583732,"d":"531.6%"},{"v":-0.07477725039553673,"d":"-7.5%"},9979,{"v":11500,"d":"11,500"},-389]
["　营业税",0,11950,0,0,{"$error":"#DIV/0!"},0,0,null,{"v":0,"d":"0.0%"},null,0,0,0]
["　企业所得税",4800,2710,304,37,{"v":7.216216216216216,"d":"721.6%"},2500,3087,{"v":0.5208333333333334,"d":"52.1%"},{"v":0.922509225092251,"d":"92.3%"},{"v":-0.1901522513767412,"d":"-19.0%"},2196,{"v":2400,"d":"2,400"},100]
["　企业所得税退税",null,null,0,0,{"$error":"#DIV/0!"},{"$nulls":6},0,0]
["　个人所得税",3300,2300,91,166,{"v":-0.4518072289156626,"d":"-45.2%"},1957,2064,{"v":0.593030303030303,"d":"59.3%"},{"v":0.8508695652173913,"d":"85.1%"},{"v":-0.05184108527131781,"d":"-5.2%"},1866,{"v":1650,"d":"1,650"},307]
["　城市维护建设税",3000,1840,155,184,{"v":-0.15760869565217395,"d":"-15.8%"},1720,1610,{"v":0.5733333333333334,"d":"57.3%"},{"v":0.9347826086956522,"d":"93.5%"},{"v":0.06832298136645965,"d":"6.8%"},1565,{"v":1500,"d":"1,500"},220]
["　房产税",4400,2360,6,115,{"v":-0.9478260869565217,"d":"-94.8%"},2145,2348,{"v":0.4875,"d":"48.8%"},{"v":0.9088983050847458,"d":"90.9%"},{"v":-0.08645655877342417,"d":"-8.6%"},2139,{"v":2200,"d":"2,200"},-55]
["　印花税",1500,750,78,43,{"v":0.8139534883720929,"d":"81.4%"},651,693,{"v":0.434,"d":"43.4%"},{"v":0.868,"d":"86.8%"},{"v":-0.06060606060606055,"d":"-6.1%"},573,750,-99]
["　城镇土地使用税",2800,1500,1,91,{"v":-0.989010989010989,"d":"-98.9%"},919,1526,{"v":0.32821428571428574,"d":"32.8%"},{"v":0.6126666666666667,"d":"61.3%"},{"v":-0.3977719528178244,"d":"-39.8%"},918,{"v":1400,"d":"1,400"},-481]
["　土地增值税",1800,800,29,89,{"v":-0.6741573033707865,"d":"-67.4%"},509,958,{"v":0.2827777777777778,"d":"28.3%"},{"v":0.63625,"d":"63.6%"},{"v":-0.4686847599164927,"d":"-46.9%"},480,900,-391]
["　车船税",2000,350,187,153,{"v":0.22222222222222232,"d":"22.2%"},1212,958,{"v":0.606,"d":"60.6%"},{"v":3.462857142857143,"d":"346.3%"},{"v":0.2651356993736953,"d":"26.5%"},1025,{"v":1000,"d":"1,000"},212]
["  其他税收",290,350,0,0,{"$error":"#DIV/0!"},0,2,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},null,0,145,-145]
["2、耕占税和契税",9620,10670,339,-807,{"v":-1.420074349442379,"d":"-142.0%"},2397,3804,{"v":0.24916839916839917,"d":"24.9%"},{"v":0.2246485473289597,"d":"22.5%"},{"v":-0.36987381703470035,"d":"-37.0%"},2058,{"v":4810,"d":"4,810"},{"v":-2413,"d":"-2,413"}]
["　耕地占用税",5180,7010,0,0,{"$error":"#DIV/0!"},0,949,{"v":0,"d":"0.0%"},{"v":0,"d":"0.0%"},{"v":-1,"d":"-100.0%"},0,{"v":2590,"d":"2,590"},{"v":-2590,"d":"-2,590"}]
["　契税",4440,3660,339,-807,{"v":-1.420074349442379,"d":"-142.0%"},2397,2855,{"v":0.5398648648648648,"d":"54.0%"},{"v":0.6549180327868852,"d":"65.5%"},{"v":-0.1604203152364273,"d":"-16.0%"},2058,{"v":2220,"d":"2,220"},177]
["二、非税收入",17840,13140,1155,257,{"v":3.4941634241245136,"d":"349.4%"},7899,5648,{"v":0.44276905829596414,"d":"44.3%"},{"v":0.6011415525114155,"d":"60.1%"},{"v":0.39854815864022664,"d":"39.9%"},6744,{"v":8920,"d":"8,920"},{"v":-1021,"d":"-1,021"}]
["  教育及附加",1640,450,87,104,{"v":-0.16346153846153844,"d":"-16.3%"},984,897,{"v":0.6,"d":"60.0%"},{"v":2.1866666666666665,"d":"218.7%"},{"v":0.09698996655518388,"d":"9.7%"},897,820,164]
["　地方教育费附加",0,null,0,26,{"v":-1,"d":"-100.0%"},0,0,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},0,0,0]
["　行政事业性收费",2980,1430,976,113,{"v":7.63716814159292,"d":"763.7%"},2262,1125,{"v":0.7590604026845638,"d":"75.9%"},{"v":1.5818181818181818,"d":"158.2%"},{"v":1.0106666666666668,"d":"101.1%"},1286,{"v":1490,"d":"1,490"},772]
["　罚没收入",2000,820,65,13,{"v":4,"d":"400.0%"},508,469,{"v":0.254,"d":"25.4%"},{"v":0.6195121951219512,"d":"62.0%"},{"v":0.08315565031982941,"d":"8.3%"},443,{"v":1000,"d":"1,000"},-492]
["  教育资金收入",2845,820,0,13,{"v":-1,"d":"-100.0%"},1940,450,{"v":0.6818980667838312,"d":"68.2%"},{"v":2.3658536585365852,"d":"236.6%"},{"v":3.311111111111111,"d":"331.1%"},1940,{"v":1422.5,"d":"1,423"},{"v":517.5,"d":"518"}]
["  农田水利资金收入",2845,820,0,13,{"v":-1,"d":"-100.0%"},1940,450,{"v":0.6818980667838312,"d":"68.2%"},{"v":2.3658536585365852,"d":"236.6%"},{"v":3.311111111111111,"d":"331.1%"},1940,{"v":1422.5,"d":"1,423"},{"v":517.5,"d":"518"}]
["  国资有偿使用收入",5530,820,27,13,{"v":1.076923076923077,"d":"107.7%"},265,296,{"v":0.04792043399638336,"d":"4.8%"},{"v":0.3231707317073171,"d":"32.3%"},{"v":-0.10472972972972971,"d":"-10.5%"},238,0,265]
["　其他收入",0,7980,0,27,{"v":-1,"d":"-100.0%"},0,1961,{"$error":"#DIV/0!"},{"v":0,"d":"0.0%"},{"v":-1,"d":"-100.0%"},0,0,0]
["政府性基金收入合计",58150,3220,596,1382,{"v":-0.5687409551374819,"d":"-56.9%"},15682,9358,{"v":0.26968185726569216,"d":"27.0%"},{"v":4.8701863354037265,"d":"487.0%"},{"v":0.6757854242359478,"d":"67.6%"},15086,{"v":29075,"d":"29,075"},{"v":-13393,"d":"-13,393"}]
["国土收益",51790,3100,0,0,{"$error":"#DIV/0!"},10570,6600,{"v":0.20409345433481368,"d":"20.4%"},{"v":3.4096774193548387,"d":"341.0%"},null,10570,{"v":25895,"d":"25,895"},{"v":-15325,"d":"-15,325"}]
["配套费",6360,60,596,{"v":1365,"d":"1,365"},{"v":-0.5633699633699634,"d":"-56.3%"},5005,2640,{"v":0.7869496855345912,"d":"78.7%"},null,{"v":0.8958333333333333,"d":"89.6%"},4409,{"$error":"#REF!"},{"$error":"#REF!"}]
["污水处理费收入",0,60,0,{"v":1365,"d":"1,365"},{"v":-1,"d":"-100.0%"},107,99,{"$error":"#DIV/0!"},null,{"v":0.08080808080808088,"d":"8.1%"},107,0,107]
["其他收入",null,null,0,17,{"v":-1,"d":"-100.0%"},0,19,{"$nulls":3},0,0,0]
["国有资本经营收入合计",10000,0,3000,0,0,3000,0,0.3,0,{"$error":"#DIV/0!"},0,5000,{"v":-2000,"d":"-2,000"}]
["国有资本经营收入",10000,null,{"v":3000,"d":"3,000"},null,null,3000,0,{"v":0.3,"d":"30.0%"},null,{"$error":"#DIV/0!"},null,{"v":5000,"d":"5,000"},{"v":-2000,"d":"-2,000"}]
["地方收入预算合计",142500,53680,7073,2452,{"v":1.884584013050571,"d":"188.5%"},51702,44065,{"v":0.36282105263157893,"d":"36.3%"},{"v":0.9631520119225038,"d":"96.3%"},{"v":0.17331215250198562,"d":"17.3%"},44629,{"v":71250,"d":"71,250"},{"v":-19548,"d":"-19,548"}]

{"sheet":"含民生支出","index":2,"n_rows":48,"n_cols":16,"rows_kept":48,"merged":[[0,0,0,13],[45,0,45,14],[47,0,47,14]],"flags":["formulas_cached_only"]}
["阎良区地方财政支出执行情况表"]
[{"$nulls":9},"2020-06-01",{"$nulls":3},"单位：万元"]
["项　目","年初预算","调整预算","本月执行","转移支付",null,null,"同期当月","当月增幅","累计完成","上年同期","完成年初%","完成调整%","同比增减","上月数","备注"]
["一般公共预算支出合计",154960,72381,17842,0,0,0,19741,{"v":-0.09619573476520948,"d":"-9.6%"},{"v":88646,"d":"88,646"},{"v":87295,"d":"87,295"},{"v":0.5720573051109964,"d":"57.2%"},{"v":1.2247136679515342,"d":"122.5%"},{"v":0.015476258663153608,"d":"1.5%"},70804]
["★一般公共服务",25212,9300,1131,{"$nulls":3},1791,{"v":-0.3685092127303182,"d":"-36.9%"},11622,9591,{"v":0.4609709662065683,"d":"46.1%"},{"v":1.2496774193548388,"d":"125.0%"},{"v":0.2117610259618392,"d":"21.2%"},10491]
["★公共安全",12138,4587,1055,{"$nulls":3},2318,{"v":-0.5448662640207075,"d":"-54.5%"},5695,4113,{"v":0.469187675070028,"d":"46.9%"},{"v":1.2415522127752343,"d":"124.2%"},{"v":0.38463408704108915,"d":"38.5%"},4640]
["★教育☆",39586,18624,3223,{"$nulls":3},348,{"v":8.261494252873563,"d":"826.1%"},15689,24389,{"v":0.39632698428737434,"d":"39.6%"},{"v":0.8424076460481099,"d":"84.2%"},{"v":-0.356718192627824,"d":"-35.7%"},12466]
["★科学技术☆",128,761,3,{"$nulls":3},396,{"v":-0.9924242424242424,"d":"-99.2%"},13,37,{"v":0.1015625,"d":"10.2%"},{"v":0.017082785808147174,"d":"1.7%"},{"v":-0.6486486486486487,"d":"-64.9%"},10]
["文化体育与传媒☆",972,803,212,{"$nulls":3},115,{"v":0.8434782608695652,"d":"84.3%"},516,509,{"v":0.5308641975308642,"d":"53.1%"},{"v":0.6425902864259029,"d":"64.3%"},{"v":0.013752455795677854,"d":"1.4%"},304]
["★社会保障和就业☆",30359,9757,3279,{"$nulls":3},1959,{"v":0.6738131699846861,"d":"67.4%"},15091,16771,{"v":0.4970848842188478,"d":"49.7%"},{"v":1.5466844316900688,"d":"154.7%"},{"v":-0.10017291753622326,"d":"-10.0%"},11812]
["★卫生健康支出☆",16815,5700,1370,{"$nulls":3},1669,{"v":-0.17914919113241456,"d":"-17.9%"},8490,13619,{"v":0.5049063336306869,"d":"50.5%"},{"v":1.4894736842105263,"d":"148.9%"},{"v":-0.3766062119098319,"d":"-37.7%"},7120]
["★节能环保☆",369,572,894,{"$nulls":3},607,{"v":0.472817133443163,"d":"47.3%"},2079,544,{"v":5.634146341463414,"d":"563.4%"},{"v":3.6346153846153846,"d":"363.5%"},{"v":2.8216911764705883,"d":"282.2%"},1185]
["★城乡社区支出☆",7278,6967,3610,{"$nulls":3},7474,{"v":-0.516992239764517,"d":"-51.7%"},14504,10659,{"v":1.992855179994504,"d":"199.3%"},{"v":2.0818142672599396,"d":"208.2%"},{"v":0.36072802326672293,"d":"36.1%"},10894]
["农林水支出☆",10811,6214,939,{"$nulls":3},2309,{"v":-0.5933304460805544,"d":"-59.3%"},2881,2606,{"v":0.2664878364628619,"d":"26.6%"},{"v":0.46363051174766656,"d":"46.4%"},{"v":0.10552570990023025,"d":"10.6%"},1942]
["交通运输☆",1396,1450,57,{"$nulls":3},133,{"v":-0.5714285714285714,"d":"-57.1%"},600,917,{"v":0.4297994269340974,"d":"43.0%"},{"v":0.41379310344827586,"d":"41.4%"},{"v":-0.3456924754634678,"d":"-34.6%"},543]
["资源勘探信息等支出",1848,2200,1587,{"$nulls":3},380,{"v":3.1763157894736844,"d":"317.6%"},8586,2039,{"v":4.646103896103896,"d":"464.6%"},{"v":3.902727272727273,"d":"390.3%"},{"v":3.2108876900441397,"d":"321.1%"},6999]
["商业服务业等支出☆",214,950,51,{"$nulls":3},143,{"v":-0.6433566433566433,"d":"-64.3%"},205,374,{"v":0.9579439252336449,"d":"95.8%"},{"v":0.21578947368421053,"d":"21.6%"},{"v":-0.4518716577540107,"d":"-45.2%"},154]
["金融支出",208,null,13,{"$nulls":3},42,{"v":-0.6904761904761905,"d":"-69.0%"},83,80,{"v":0.39903846153846156,"d":"39.9%"},null,{"v":0.03750000000000009,"d":"3.8%"},70]
["国土海洋气象等支出☆",1373,160,89,{"$nulls":3},44,{"v":1.022727272727273,"d":"102.3%"},698,678,{"v":0.5083758193736344,"d":"50.8%"},{"v":4.3625,"d":"436.3%"},{"v":0.029498525073746285,"d":"2.9%"},609]
["住房保障支出☆",null,100,0,{"$nulls":3},0,{"$error":"#DIV/0!"},0,0,{"$error":"#DIV/0!"},{"v":0,"d":"0.0%"},{"$error":"#DIV/0!"},0]
["粮油物资储备事务☆",211,200,26,{"$nulls":3},12,{"v":1.1666666666666665,"d":"116.7%"},92,180,{"v":0.43601895734597157,"d":"43.6%"},{"v":0.46,"d":"46.0%"},{"v":-0.48888888888888893,"d":"-48.9%"},66]
["灾害防治及应急管理支出",422,null,1,{"$nulls":4},{"$error":"#DIV/0!"},254,61,{"v":0.6018957345971564,"d":"60.2%"},null,{"v":3.163934426229508,"d":"316.4%"},253,"新科目"]
["债务付息支出",4000,null,300,{"$nulls":3},0,{"$error":"#DIV/0!"},1539,0,{"v":0.38475,"d":"38.5%"},null,{"$error":"#DIV/0!"},1239]
["预备费",1600,800,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["其他支出",20,3236,2,{"$nulls":3},1,{"v":1,"d":"100.0%"},9,128,{"$nulls":3},7]
["政府性基金支出合计",14294,3160,231,{"v":1969,"d":"1,969"},0,0,{"v":2523,"d":"2,523"},{"v":-0.9084423305588585,"d":"-90.8%"},{"v":16613,"d":"16,613"},{"v":4585,"d":"4,585"},{"v":1.1622359031761578,"d":"116.22%"},{"v":5.2572784810126585,"d":"525.7%"},{"v":2.623336968375136,"d":"262.3%"},{"v":16382,"d":"16,382"}]
["一般公共服务",null,null,0,150,null,null,0,{"$error":"#DIV/0!"}]
["教育",null,null,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["文化体育与传媒",null,null,10,35,null,null,0,{"$error":"#DIV/0!"},10]
["社会保障和就业",null,null,0,7,null,null,150,{"v":-1,"d":"-100.0%"},66,{"$nulls":4},66]
["城乡社区支出",12360,3100,221,1591,null,null,39,{"v":4.666666666666667,"d":"466.7%"},2351,4583,{"v":0.19021035598705502,"d":"19.02%"},{"v":0.19021035598705502,"d":"19.0%"},{"v":-0.4870172376172812,"d":"-48.7%"},2130]
["农林水支出",null,null,0,186,null,null,0,{"$error":"#DIV/0!"}]
["交通运输",null,null,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["资源勘探信息等支出",null,60,0,{"$nulls":3},0,{"$error":"#DIV/0!"},{"$nulls":3},{"v":0,"d":"0.0%"},{"$error":"#DIV/0!"}]
["粮油及金融等支出",null,null,0,{"$nulls":3},0,{"$error":"#DIV/0!"}]
["其他支出",797,null,0,{"$nulls":3},2334,{"v":-1,"d":"-100.0%"},14186,2,{"$nulls":3},14186]
["债务付息支出",1137,null,0,{"$nulls":3},2334,{"v":-1,"d":"-100.0%"},0,0,{"$nulls":3},0]
["国有资本经营支出合计",5000,0,0,0,0,0,0,0,44,0,0.0088,0,{"$error":"#DIV/0!"},44]
["国有资本经营支出",5000,null,0,{"$nulls":5},44,null,{"v":0.0088,"d":"0.9%"},null,{"$error":"#DIV/0!"},44]
["地方财政支出合计",174254,75541,18073,1969,0,0,22264,{"v":-0.18824110671936756,"d":"-18.8%"},105303,{"v":91880,"d":"91,880"},{"v":0.6043075051361805,"d":"60.4%"},{"v":0.6043075051361805,"d":"60.4%"},{"v":0.1460927296473662,"d":"14.6%"},87230]
[{"$nulls":14},0]
["八项支出合计",73183,4587,"八项占比",0,0,0,null,null,{"v":0.8255646052839384,"d":"82.6%"},"同期及增减",79723,{"v":79723,"d":"7972300.0%"},{"v":-0.08203404287344929,"d":"-8.2%"},0]
["民生支出合计",60858,18624,"民生占比",35,0,0,null,null,{"v":0.6865284389594567,"d":"68.7%"},"同期及增减",71283,{"v":71283,"d":"7128300.0%"},{"v":-0.14624805353310044,"d":"-14.6%"},0]
[{"$nulls":14},0]
["备注：其中★为八项支出项目，☆为民生支出项目",{"$nulls":13},0]
[0]
[]
[0]