{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Sheet2","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Sheet2","index":0,"n_rows":32,"n_cols":5,"rows_kept":32,"cut":false,"hidden":false,"merged":[[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[30,0,30,1],[31,2,32,2],[31,0,32,1]]}
["主题数据","当前在园企业数","数据来源：统计企业库中入驻类型为“在园”的企业总数","许峰"]
[null,"当前园区面积","数据来源：载体管理->楼盘管理，新增园区时所输入的面积","许峰"]
[null,"本年度当前亩均收入强度","数据来源：1）企业库中所有企业本年度累计收入/当前园区面积\n                    2）以每次打开页面的日期统计本年度的累计收入","许峰"]
[null,"本年度当前亩均税收强度","数据来源：1）企业库中所有企业本年度累计税收/当前园区面积\n                    2）以每次打开页面的日期统计本年度的累计税收","许峰"]
[null,"本年度当前企业总收入(在方法中getTotalRevenueAndTaxation)","数据来源：1）企业库中所有企业本年度累计收入（收入数据来源于经发数据导入）\n                    2）以每次打开页面的日期统计本年度累计收入","张洮","宣萱画页面"]
[null,"本年度当前企业总税收(在方法中getTotalRevenueAndTaxation)","数据来源：1）企业库中所有企业本年度累计税收（收入数据来源于经发数据导入）\n                    2）以每次打开页面的日期统计本年度累计税收","张洮","宣萱画页面"]
["园区招商","空置面积(在方法中getTotalFreeRoomSize)","1.数据来源：招商管理->房源管理，所有状态为“空置”+“预约”的房间总面积\n2.数据{{{下钻}}}：点击“空置面积”{{{下钻}}}到\"空置面积{{{下钻}}}\"页面","张洮"]
[null,"在谈项目(在方法中getTotalRunningSaleProject)","1.数据来源：招商管理->项目管理，所有状态为“跟进中”的项目总数\n2.数据{{{下钻}}}：点击“在谈项目”{{{下钻}}}到“在谈项目{{{下钻}}}”页面","张洮"]
[null,"企业注册情况","饼图形式：\n1.数据来源：\n1）累计注册企业：查看日企业库管理中的累计企业总数\n2）各科技标签企业数量及占比：取企业标签，“科技属性”类别下相同标签的企业总数/累计注册企业总数\n2.数据{{{下钻}}}：点击饼图{{{下钻}}}到“企业注册情况饼图{{{下钻}}}”页面","许峰"]
[null,"近三年企业引进","1.数据来源：\n1）当年新引进企业：当前年企业库管理中新入库的企业总数\n2）当年新入园企业：当前年新入驻的企业数量\n3）当年实现产出企业：当前年新引进企业中有税收数据的企业总数\n4）累计注册企业：当前年企业管理中累计的企业总数（可以用上一年度累计注册企业数+当前年新引起企业数）\n5）在园企业：当前年企业管理中累计的入驻类型为“在园”的企业总数\n6）企业补贴金额（万元）：企业服务->企业补贴管理中，当前年度所有企业的补贴总金额\n2.数据{{{下钻}}}：只有企业补贴金额可以{{{下钻}}}\n1）点击企业补贴金额的数字，{{{下钻}}}到“企业补贴金额{{{下钻}}}页面”","许峰"]
["资产出租","当前应收款金额(超链接)","1.数据来源：收款管理->收款明细中，收款状态为“待收款”、“部分收款”账单的应收结余总金额\n2.数据{{{下钻}}}：点击“当前应收款金额”{{{下钻}}}到“当前应收款金额{{{下钻}}}”页面","张洮"]
[null,"近三年收款金额(超链接)","条形图形式：\n1.数据来源：收款管理->收款明细中，到账日期为当前年度的收款总金额\n2.数据{{{下钻}}}：点击每条柱子{{{下钻}}}到本年度的月份列表，详见“近三年收款金额条形图{{{下钻}}}”页面","张洮"]
[null,"近三年坏账金额(超链接)","条形图形式：\n1.数据来源：收款管理->收款明细中，收款状态为“坏账”的所有账单的应收结余总金额\n2.数据{{{下钻}}}：点击每条柱子{{{下钻}}}到本年度的月份列表，详见“近三年坏账金额条形图{{{下钻}}}”页面","张洮"]
[null,"近三年新增出租面积/协议数","1.数据来源：\n1）新增出租面积：合同管理中，签约日期为当前年的合同面积总数\n2）新增协议企业：合同管理中，签约日期为当前年合同的企业总数\n2.数据{{{下钻}}}：点击数字，{{{下钻}}}到“新增出租面积/协议企业{{{下钻}}}”页面","许峰"]
["企业服务","企业近三年产值情况-产值占比","饼图形式：\n1.数据来源：\n1）总产值：企业库->企业库管理中，当前年度所有企业的收入总金额（企业收入数据来源于经发数据）\n2）各行业企业产值占比：企业标签，“行业类型”类别下相同标签企业的产值之和/总产值\n2.数据{{{下钻}}}：点击饼图{{{下钻}}}到“企业近三年产值/税收占比饼图{{{下钻}}}”页面","张洮","宣萱画页面"]
[null,"企业近三年产值情况-税收占比","饼图形式：\n1.数据来源：\n1）总产值：企业库->企业库管理中，当前年度所有企业的税收总金额（企业税收数据来源于经发数据）\n2）各行业企业产值占比：企业标签，“行业类型”类别下相同标签企业的税收之和/总产值\n2.数据{{{下钻}}}：点击饼图{{{下钻}}}到“企业近三年产值/税收占比饼图{{{下钻}}}”页面","张洮","宣萱画页面"]
[null,"企业产值Top15","1.数据来源：企业库管理中，当前年度企业收入排名前15的企业名单（企业收入数据来源于经发数据）\n2.数据{{{下钻}}}：\n1）点击企业名称，{{{下钻}}}查看企业详情\n2）点击更多，{{{下钻}}}到“企业产值Top15更多”页面","张洮","宣萱画页面"]
[null,"企业税收Top15","1.数据来源：企业库管理中，当前年度企业税收排名前15的企业名单（企业收入数据来源于经发数据）\n2.数据{{{下钻}}}：\n1）点击企业名称，{{{下钻}}}查看企业详情\n2）点击更多，{{{下钻}}}到“企业税收Top15更多”页面","张洮","宣萱画页面"]
[null,"高成长企业Top15","1.数据来源：企业库管理中，当前年度与前一个年度对比，企业收入增长排名前15的企业名单（企业收入数据来源于经发数据）\n2.数据{{{下钻}}}：\n1）点击企业名称，{{{下钻}}}查看企业详情\n2）点击更多，{{{下钻}}}到“高成长企业Top15更多”页面","张洮","宣萱画页面"]
[null,"近三年亩均产出分析","数据来源：\n1.亩均收入：当前年度，企业库管理中所有企业收入/园区面积\n2.亩均税收：当前年度，企业库管理中所有企业税收/园区面积","许峰"]
[null,"近三年规上企业分析","数据来源：企业库->企业库管理中，当前年度收入在对应范围的企业总数","许峰"]
[null,"上市后备企业","饼图形式：\n1.数据来源：\n1）上市后备企业列表中的企业总数\n2）各行业企业数量占比：各行业企业总数/上市后备企业总数\n3）各拟上市板块企业数量占比：各拟上市板块的企业总数/上市后备企业总数\n2.数据{{{下钻}}}：点击两个饼图任意一个，{{{下钻}}}到“上市后备企业{{{下钻}}}”页面","许峰"]
[null,"重点企业","饼图形式：\n1.数据来源：重点企业列表中的企业\n1）总产值：所有重点企业查询年月的总产值\n2）行业产值占比：各行业所有重点企业查询年月总产值/所有重点企业总产值\n2.数据{{{下钻}}}：点击饼图{{{下钻}}}“重点企业{{{下钻}}}”页面","许峰"]
[null,"园区创新","数据来源：\n1.高企净增数：当前年度，企业库中企业标签为“高企”的新增企业总数\n2.高企总数：当前年度，企业库中企业标签为“高企”的企业总数\n3.雏鹰入库数：当前年度，企业库中企业标签为“雏鹰”的新增企业总数\n4.瞪羚入库数：当前年度，企业库中企业标签为“瞪羚”的新增企业总数\n5.准独角兽入库数：当前年度，企业库中企业标签为“准独角兽”的新增企业总数","许峰"]
["统计表报","超链接，点击统计报表跳转到统计报表下的第一个菜单",null,"许峰"]
[null,"超链接，点击统计报表跳转到统计报表下的第二个菜单",null,"张洮"]
["超级工作台","显示超级工作台"]
["企业库迭代",null,null,"陈凡"]
[]
[]
["超级工作台-web页面",null,"中屏统计图"]
["陈鹏鸣",null,"小宣"]

{"sheet":"Sheet1","index":1,"n_rows":82,"n_cols":4,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["当前应收款金额","post"]
[null,"http://localhost:9010/wx/WebHomepageController/getTotalCollectMoneyByYear"]
[]
[null,"year1",2023]
[null,"year2",2022]
[null,"year3",2021]
[null,"{\n    \"msg\": \"Success\",\n    \"code\": 200,\n    \"data\": {\n        \"totalCollectMoney1\": {\n            \"totalMoney\": 84.0,\n            \"yearInt\": 2023\n        },\n        \"totalCollectMoney3\": {\n            \"totalMoney\": 0.0,\n            \"yearInt\": 2023\n        },\n        \"totalNeedMoney\": 4.0,\n        \"totalCollectMoney2\": {\n            \"totalMoney\": 0.0,\n            \"yearInt\": 2023\n        }\n    },\n    \"key\": 200\n}","单位元"]
[]
[]
["近三年收款金额","http://localhost:9010/wx/WebHomepageController/getTotalHaveCollectMoneyByYear"]
[]
[null,"year",2023]
[null,"{\n    \"msg\": \"Success\",\n    \"code\": 200,\n    \"data\": [\n        {\n            \"yearInt\": 2023,\n            \"monthGroup\": 7,\n            \"totalMoney1\": 2000.0,\n            \"totalMoney2\": 0.0,\n            \"totalMoney4\": 0.0\n        }\n    ],\n    \"key\": 200\n}","单位元"]
[]
[]
[]
["近三年坏账金额","http://localhost:9010/wx/WebHomepageController/getTotalBadMoneyByYear"]
[]
[null,"year",2023]
[null,"{\n    \"msg\": \"Success\",\n    \"code\": 200,\n    \"data\": [\n        {\n            \"yearInt\": 2023,\n            \"monthGroup\": 7,\n            \"totalMoney1\": 0.0,\n            \"totalMoney2\": 0.0,\n            \"totalMoney4\": 0.0,\n            \"totalMoney5\": 1111.0\n        }\n    ],\n    \"key\": 200\n}","单位元"]
[]
["企业近三年产值情况-产值占比"]
["企业近三年产值情况-税收占比"]
[null,"http://localhost:9010/wx/WebHomepageController/getCompanyRevenueTotalYearInfo"]
[null,"year",2023]
[null,"selectQiYeChanZhiType","企业产值选择,0为产值占比,1为税收占比"]
[null,"{\n    \"msg\": \"Success\",\n    \"code\": 200,\n    \"data\": {\n        \"yearInt\": 2023,\n        \"totalRevenue\": 50557.0,\n        \"totaltTaxation\": 2317.0,\n        \"companyRevenueTotalYearInfoList\": [\n            {\n                \"yearInt\": 2023,\n                \"industry\": \"2\",\n                \"industryTotalRevenue\": 50458.0,\n                \"industryTotaltTaxation\": 2308.0\n            },\n            {\n                \"yearInt\": 2023,\n                \"industry\": \"1\",\n                \"industryTotalRevenue\": 99.0,\n                \"industryTotaltTaxation\": 9.0\n            }\n        ]\n    },\n    \"key\": 200\n}","单位万元"]
[]
["企业产值Top15","http://localhost:9010/wx/WebHomepageController/getRevenueTopCompanyMoneyInfoList","这是分页查询的接口","getRevenueTopCompanyMoneyInfoListPage"]
["企业税收Top15","http://localhost:9010/wx/WebHomepageController/getTaxationTopCompanyMoneyInfoList","这是分页查询的接口","getTaxationTopCompanyMoneyInfoListPage"]
[null,"year",2023]
[null,"{\n    \"msg\": \"Success\",\n    \"code\": 200,\n    \"data\": [\n        {\n            \"totalMoney\": 50278.0,\n            \"yearInt\": 2023,\n            \"qymc\": \"阿鲁巴\",\n            \"companyId\": \"106224969332817920\"\n        },\n        {\n            \"totalMoney\": 110.0,\n            \"yearInt\": 2023,\n            \"qymc\": \"瑞幸\",\n            \"companyId\": \"101437073937661952\"\n        },\n        {\n            \"totalMoney\": 99.0,\n            \"yearInt\": 2023,\n            \"qymc\": \"测试\",\n            \"companyId\": \"101463469288325120\"\n        },\n        {\n            \"totalMoney\": 70.0,\n            \"yearInt\": 2023,\n            \"qymc\": \"联想\",\n            \"companyId\": \"101439389143138304\"\n        }\n    ],\n    \"key\": 200\n}","单位万元"]
[]
["高成长企业Top15","http://localhost:9010/wx/WebHomepageController/getTopCompanyMoneyInfoUpList"]
[null,"year",2023]
[null,"{","单位万元"]
[null,"    \"msg\": \"Success\","]
[null,"    \"code\": 200,"]
[null,"    \"data\": ["]
[null,"        {"]
[null,"            \"yearInt1\": 2023,"]
[null,"            \"yearInt2\": 2022,"]
[null,"            \"qymc\": \"阿鲁巴\","]
[null,"            \"companyId\": \"106224969332817920\","]
[null,"            \"totalMoney1\": 50278.0,"]
[null,"            \"totalMoney2\": 517.0,"]
[null,"            \"subMoney\": 49761.0,"]
[null,"            \"rateMoney\": 0.9897171725"]
[null,"        },"]
[null,"        {"]
[null,"            \"yearInt1\": 2023,"]
[null,"            \"yearInt2\": 2022,"]
[null,"            \"qymc\": \"瑞幸\","]
[null,"            \"companyId\": \"101437073937661952\","]
[null,"            \"totalMoney1\": 110.0,"]
[null,"            \"totalMoney2\": 11.0,"]
[null,"            \"subMoney\": 99.0,"]
[null,"            \"rateMoney\": 0.9"]
[null,"        },"]
[null,"        {"]
[null,"            \"yearInt1\": 2023,"]
[null,"            \"yearInt2\": 2022,"]
[null,"            \"qymc\": \"联想\","]
[null,"            \"companyId\": \"101439389143138304\","]
[null,"            \"totalMoney1\": 70.0,"]
[null,"            \"totalMoney2\": 88.0,"]
[null,"            \"subMoney\": -18.0,"]
[null,"            \"rateMoney\": -0.2571428571"]
[null,"        },"]
[null,"        {"]
[null,"            \"yearInt1\": 2023,"]
[null,"            \"yearInt2\": 2022,"]
[null,"            \"qymc\": \"测试\","]
[null,"            \"companyId\": \"101463469288325120\","]
[null,"            \"totalMoney1\": 99.0,"]
[null,"            \"totalMoney2\": 132.0,"]
[null,"            \"subMoney\": -33.0,"]
[null,"            \"rateMoney\": -0.3333333333"]
[null,"        }"]
[null,"    ],"]
[null,"    \"key\": 200"]
[null,"}"]