{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["财务报表","财务数据输入","关键指标设置","计算"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"comments":0,"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":"财务报表","index":0,"n_rows":40,"n_cols":14,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,8,39,11],[34,8,34,11],[35,8,35,11],[36,8,36,11],[37,8,37,11],[38,8,38,11],[1,10,1,11],[8,9,8,11],[7,9,7,11],[9,9,9,11],[6,9,6,11],[33,8,33,11],[19,8,19,11],[20,8,20,11],[26,8,26,11],[27,8,27,11],[28,8,28,11],[21,8,21,11],[22,8,22,11],[23,8,23,11],[24,8,24,11],[25,8,25,11],[12,3,12,7],[29,8,29,11],[30,8,30,11],[31,8,31,11],[32,8,32,11],[14,8,14,11],[15,8,15,11],[16,8,16,11],[17,8,17,11],[18,8,18,11]]}
[]
[null,"年度财务报表",null,null,null,null,null,null,null,null,2016,null,null,"选择单元格 L2 中的报表年份"]
[null,"你的公司名称",null,null,null,null,null,null,null,null,null,null,null,"若要编辑数据，请选择财务数据输入工作表"]
[]
[null,"关键指标",null,"单击以更改报表关键指标"]
[]
[null,{"$f":"计算!B8","v":"收入"},null,{"$f":"计算!B9","v":"净利润"},null,{"$f":"计算!B10","v":"利息"},null,{"$f":"计算!B11","v":"折旧值"},null,{"$f":"计算!B12","v":"营业利润"}]
[null,{"$f":"IFERROR(计算!G8,\"\")","v":1805838.8},null,{"$f":"IFERROR(计算!G9,\"\")","v":674748.5},null,{"$f":"IFERROR(计算!G10,\"\")","v":37894.699999999997},null,{"$f":"IFERROR(计算!G11,\"\")","v":55468.800000000003},null,{"$f":"IFERROR(计算!G12,\"\")","v":734259.9}]
[null,{"$f":"计算!H8","v":3.0953753897409175E-3},null,{"$f":"计算!H9","v":1.8148662861143583E-2},null,{"$f":"计算!H10","v":0.13514962705568689},null,{"$f":"计算!H11","v":9.4400227289767047E-2},null,{"$f":"计算!H12","v":-5.0335608229046258E-2}]
[]
[]
[]
[null,"全部指标",null,"不要修改以下信息。单击以输入财务数据"]
[]
[null,"指标",null,{"$f":"\"报表年 (\"&SelectedYear&\")\"","v":"报表年 (2016)"},null,{"$f":"\"去年 (\"&SelectedYear-1&\")\"","v":"去年 (2015)"},null,"更改百分比",{"$f":"CONCATENATE(年数,\" 年趋势\")","v":"5 年趋势"}]
[null,{"$f":"计算!B15","v":"收入"},null,{"$f":"IF($B16=\"\",\"\",计算!G15)","v":1805838.8},null,{"$f":"IF($B16=\"\",\"\",计算!F15)","v":1800266.3},null,{"$f":"IFERROR(D16/F16-1,\"\")","v":3.0953753897409175E-3}]
[null,{"$f":"计算!B16","v":"运营开支"},null,{"$f":"IF($B17=\"\",\"\",计算!G16)","v":944194.5},null,{"$f":"IF($B17=\"\",\"\",计算!F16)","v":808833.3},null,0.16735364382252804]
[null,{"$f":"计算!B17","v":"营业利润"},null,{"$f":"IF($B18=\"\",\"\",计算!G17)","v":734259.9},null,{"$f":"IF($B18=\"\",\"\",计算!F17)","v":773178.3},null,-5.0335608229046258E-2]
[null,{"$f":"计算!B18","v":"折旧值"},null,{"$f":"IF($B19=\"\",\"\",计算!G18)","v":55468.800000000003},null,{"$f":"IF($B19=\"\",\"\",计算!F18)","v":50684.2},null,9.4400227289767047E-2]
[null,{"$f":"计算!B19","v":"利息"},null,{"$f":"IF($B20=\"\",\"\",计算!G19)","v":37894.699999999997},null,{"$f":"IF($B20=\"\",\"\",计算!F19)","v":33383},null,0.13514962705568689]
[null,{"$f":"计算!B20","v":"净利润"},null,{"$f":"IF($B21=\"\",\"\",计算!G20)","v":674748.5},null,{"$f":"IF($B21=\"\",\"\",计算!F20)","v":662721},null,1.8148662861143583E-2]
[null,{"$f":"计算!B21","v":"税费"},null,{"$f":"IF($B22=\"\",\"\",计算!G21)","v":314082.5},null,{"$f":"IF($B22=\"\",\"\",计算!F21)","v":294245.3},null,6.7417219578358667E-2]
[null,{"$f":"计算!B22","v":"税后利润"},null,{"$f":"IF($B23=\"\",\"\",计算!G22)","v":502476.79999999999},null,{"$f":"IF($B23=\"\",\"\",计算!F22)","v":424382},null,0.18402005740111504]
[null,{"$f":"计算!B23","v":"指标 1"},null,{"$f":"IF($B24=\"\",\"\",计算!G23)","v":199.60000000000002},null,{"$f":"IF($B24=\"\",\"\",计算!F23)","v":167.8},null,0.18951132300357565]
[null,{"$f":"计算!B24","v":"指标 2"},null,{"$f":"IF($B25=\"\",\"\",计算!G24)","v":260.10000000000002},null,{"$f":"IF($B25=\"\",\"\",计算!F24)","v":218.4},null,0.19093406593406592]
[null,{"$f":"计算!B25","v":"指标 3"},null,{"$f":"IF($B26=\"\",\"\",计算!G25)","v":310.79999999999995},null,{"$f":"IF($B26=\"\",\"\",计算!F25)","v":263.89999999999998},null,0.17771883289124668]
[null,{"$f":"计算!B26","v":"指标 4"},null,{"$f":"IF($B27=\"\",\"\",计算!G26)","v":149.19999999999999},null,{"$f":"IF($B27=\"\",\"\",计算!F26)","v":145.9},null,2.2618231665524124E-2]
[null,{"$f":"计算!B27","v":"指标 5"},null,{"$f":"IF($B28=\"\",\"\",计算!G27)","v":10.3},null,{"$f":"IF($B28=\"\",\"\",计算!F27)","v":10},null,3.0000000000000027E-2]
[null,{"$f":"计算!B28","v":"指标 6"},null,{"$f":"IF($B29=\"\",\"\",计算!G28)","v":3.4000000000000004},null,{"$f":"IF($B29=\"\",\"\",计算!F28)","v":3},null,0.13333333333333353]
[null,{"$f":"计算!B29","v":""},null,{"$f":"IF($B30=\"\",\"\",计算!G29)","v":""},null,{"$f":"IF($B30=\"\",\"\",计算!F29)","v":""},null,""]
[null,{"$f":"计算!B30","v":""},null,{"$f":"IF($B31=\"\",\"\",计算!G30)","v":""},null,{"$f":"IF($B31=\"\",\"\",计算!F30)","v":""},null,""]
[null,{"$f":"计算!B31","v":""},null,{"$f":"IF($B32=\"\",\"\",计算!G31)","v":""},null,{"$f":"IF($B32=\"\",\"\",计算!F31)","v":""},null,""]
[null,{"$f":"计算!B32","v":""},null,{"$f":"IF($B33=\"\",\"\",计算!G32)","v":""},null,{"$f":"IF($B33=\"\",\"\",计算!F32)","v":""},null,""]
[null,{"$f":"计算!B33","v":""},null,{"$f":"IF($B34=\"\",\"\",计算!G33)","v":""},null,{"$f":"IF($B34=\"\",\"\",计算!F33)","v":""},null,""]
[null,{"$f":"计算!B34","v":""},null,{"$f":"IF($B35=\"\",\"\",计算!G34)","v":""},null,{"$f":"IF($B35=\"\",\"\",计算!F34)","v":""},null,""]
[null,{"$f":"计算!B35","v":""},null,{"$f":"IF($B36=\"\",\"\",计算!G35)","v":""},null,{"$f":"IF($B36=\"\",\"\",计算!F35)","v":""},null,""]
[null,{"$f":"计算!B36","v":""},null,{"$f":"IF($B37=\"\",\"\",计算!G36)","v":""},null,{"$f":"IF($B37=\"\",\"\",计算!F36)","v":""},null,""]
[null,{"$f":"计算!B37","v":""},null,{"$f":"IF($B38=\"\",\"\",计算!G37)","v":""},null,{"$f":"IF($B38=\"\",\"\",计算!F37)","v":""},null,""]
[null,{"$f":"计算!B38","v":""},null,{"$f":"IF($B39=\"\",\"\",计算!G38)","v":""},null,{"$f":"IF($B39=\"\",\"\",计算!F38)","v":""},null,""]
[null,{"$f":"计算!B39","v":""},null,{"$f":"IF($B40=\"\",\"\",计算!G39)","v":""},null,{"$f":"IF($B40=\"\",\"\",计算!F39)","v":""},null,""]

{"sheet":"财务数据输入","index":1,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"输入你的财务数据"]
[null," 可定义针对 7 年的多达 25 个关键指标"]
[null," 单击以查看财务报表"]
[null,"指标名称",2010,2011,2012,2013,2014,2015,2016]
[null,"收入",1250000,1341374.5,1427283.8,1506874.5999999999,1650445.6,1800266.3,1805838.8]
[null,"运营开支",650000,709623.1,759248.6,789012.70000000007,816743.7,808833.3,944194.5]
[null,"营业利润",600000,642073,688576.9,756432.5,767552.6,773178.3,734259.9]
[null,"折旧值",45000,45177.700000000004,46569.2,49742.1,50241.1,50684.2,55468.800000000003]
[null,"利息",25000,27458.2,28931.100000000002,31361.199999999997,31485.300000000003,33383,37894.699999999997]
[null,"净利润",540000,547610.75,558608.1,597479.5,614835.89999999991,662721,674748.5]
[null,"税费",220000,239205.40000000002,255767.40000000002,274988.59999999998,283356.69999999995,294245.3,314082.5]
[null,"税后利润",320000,349434.89999999997,384185.3,398950.5,406077.30000000005,424382,502476.79999999999]
[null,"指标 1",128,128.1,137.79999999999998,142.89999999999998,155.69999999999999,167.8,199.60000000000002]
[null,"指标 2",182,185.9,192.2,201.70000000000002,204.8,218.4,260.10000000000002]
[null,"指标 3",191,205.5,218.70000000000002,231.9,246.70000000000002,263.89999999999998,310.79999999999995]
[null,"指标 4",121,122.10000000000001,125.9,137,137.6,145.9,149.19999999999999]
[null,"指标 5",7.5,7.9,8.5,8.9,9.1,10,10.3]
[null,"指标 6",2.3000000000000003,2.5,2.7,2.8000000000000003,2.9,3,3.4000000000000004]

{"sheet":"关键指标设置","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[]
[null,"在此处定义关键指标"]
[null," 最多选择 5 个要在报表顶部显示的关键指标"]
[null,"  单击以查看财务报表"]
[null,1,"收入",null,{"$f":"IF(ISBLANK(C5),\"← 请从下拉列表中选择一个值\",IF(COUNTIF($C$5:C5,C5)>1,\"你已多次选中 \"&C5&\"。\",\"\"))","v":""}]
[null,2,"净利润",null,{"$f":"IF(ISBLANK(C6),\"← 请从下拉列表中选择一个值\",IF(COUNTIF($C$5:C6,C6)>1,\"你已多次选中 \"&C6&\"。\",\"\"))","v":""}]
[null,3,"利息",null,{"$f":"IF(ISBLANK(C7),\"← 请从下拉列表中选择一个值\",IF(COUNTIF($C$5:C7,C7)>1,\"你已多次选中 \"&C7&\"。\",\"\"))","v":""}]
[null,4,"折旧值",null,{"$f":"IF(ISBLANK(C8),\"← 请从下拉列表中选择一个值\",IF(COUNTIF($C$5:C8,C8)>1,\"你已多次选中 \"&C8&\"。\",\"\"))","v":""}]
[null,5,"营业利润",null,{"$f":"IF(ISBLANK(C9),\"← 请从下拉列表中选择一个值\",IF(COUNTIF($C$5:C9,C9)>1,\"你已多次选中 \"&C9&\"。\",\"\"))","v":""}]

{"sheet":"计算","index":3,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["此工作表用于财务报表计算且应保持隐藏状态。"]
[null,null,null,"位置"]
[null,"今年",{"$f":"SelectedYear","v":2016},{"$f":"MATCH(C3,lstYears,0)+1","v":8}]
[null,"去年",{"$f":"C3-1","v":2015},{"$f":"MATCH(C4,lstYears,0)+1","v":7}]
[]
[null,"位置",{"$f":"MATCH(C7,lstYears,0)+1","v":4},{"$f":"MATCH(D7,lstYears,0)+1","v":5},{"$f":"MATCH(E7,lstYears,0)+1","v":6},{"$f":"MATCH(F7,lstYears,0)+1","v":7},{"$f":"MATCH(G7,lstYears,0)+1","v":8},null,{"$f":"COUNT(C6:G6)","v":5}]
[null,"关键指标",{"$f":"D7-1","v":2012},{"$f":"E7-1","v":2013},{"$f":"F7-1","v":2014},{"$f":"G7-1","v":2015},{"$f":"C3","v":2016}]
[{"$f":"MATCH(B8,财务数据输入!$B$6:$B$30,0)","v":1},{"$f":"IF(关键指标设置!C5=\"\",\"\",关键指标设置!C5)","v":"收入"},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A8,C$6),NA())","v":1427283.8},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A8,D$6),NA())","v":1506874.5999999999},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A8,E$6),NA())","v":1650445.6},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A8,F$6),NA())","v":1800266.3},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A8,G$6),NA())","v":1805838.8},{"$f":"IFERROR(G8/F8-1,\"\")","v":3.0953753897409175E-3}]
[{"$f":"MATCH(B9,财务数据输入!$B$6:$B$30,0)","v":6},{"$f":"IF(关键指标设置!C6=\"\",\"\",关键指标设置!C6)","v":"净利润"},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A9,C$6),NA())","v":558608.1},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A9,D$6),NA())","v":597479.5},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A9,E$6),NA())","v":614835.89999999991},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A9,F$6),NA())","v":662721},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A9,G$6),NA())","v":674748.5},{"$f":"IFERROR(G9/F9-1,\"\")","v":1.8148662861143583E-2}]
[{"$f":"MATCH(B10,财务数据输入!$B$6:$B$30,0)","v":5},{"$f":"IF(关键指标设置!C7=\"\",\"\",关键指标设置!C7)","v":"利息"},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A10,C$6),NA())","v":28931.100000000002},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A10,D$6),NA())","v":31361.199999999997},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A10,E$6),NA())","v":31485.300000000003},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A10,F$6),NA())","v":33383},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A10,G$6),NA())","v":37894.699999999997},0.13514962705568689]
[{"$f":"MATCH(B11,财务数据输入!$B$6:$B$30,0)","v":4},{"$f":"IF(关键指标设置!C8=\"\",\"\",关键指标设置!C8)","v":"折旧值"},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A11,C$6),NA())","v":46569.2},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A11,D$6),NA())","v":49742.1},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A11,E$6),NA())","v":50241.1},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A11,F$6),NA())","v":50684.2},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A11,G$6),NA())","v":55468.800000000003},9.4400227289767047E-2]
[{"$f":"MATCH(B12,财务数据输入!$B$6:$B$30,0)","v":3},{"$f":"IF(关键指标设置!C9=\"\",\"\",关键指标设置!C9)","v":"营业利润"},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A12,C$6),NA())","v":688576.9},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A12,D$6),NA())","v":756432.5},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A12,E$6),NA())","v":767552.6},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A12,F$6),NA())","v":773178.3},{"$f":"IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A12,G$6),NA())","v":734259.9},-5.0335608229046258E-2]
[]
[null,"全部指标（多达 25 个指标）"]
[{"$f":"ROWS($B$15:B15)","v":1},{"$f":"IF(财务数据输入!B6=0,\"\",财务数据输入!B6)","v":"收入"},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A15,C$6),NA()))","v":1427283.8},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A15,D$6),NA()))","v":1506874.5999999999},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A15,E$6),NA()))","v":1650445.6},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A15,F$6),NA()))","v":1800266.3},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A15,G$6),NA()))","v":1805838.8}]
[{"$f":"ROWS($B$15:B16)","v":2},{"$f":"IF(财务数据输入!B7=0,\"\",财务数据输入!B7)","v":"运营开支"},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A16,C$6),NA()))","v":759248.6},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A16,D$6),NA()))","v":789012.70000000007},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A16,E$6),NA()))","v":816743.7},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A16,F$6),NA()))","v":808833.3},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A16,G$6),NA()))","v":944194.5}]
[{"$f":"ROWS($B$15:B17)","v":3},{"$f":"IF(财务数据输入!B8=0,\"\",财务数据输入!B8)","v":"营业利润"},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A17,C$6),NA()))","v":688576.9},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A17,D$6),NA()))","v":756432.5},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A17,E$6),NA()))","v":767552.6},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A17,F$6),NA()))","v":773178.3},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A17,G$6),NA()))","v":734259.9}]
[{"$f":"ROWS($B$15:B18)","v":4},{"$f":"IF(财务数据输入!B9=0,\"\",财务数据输入!B9)","v":"折旧值"},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A18,C$6),NA()))","v":46569.2},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A18,D$6),NA()))","v":49742.1},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A18,E$6),NA()))","v":50241.1},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A18,F$6),NA()))","v":50684.2},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A18,G$6),NA()))","v":55468.800000000003}]
[{"$f":"ROWS($B$15:B19)","v":5},{"$f":"IF(财务数据输入!B10=0,\"\",财务数据输入!B10)","v":"利息"},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A19,C$6),NA()))","v":28931.100000000002},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A19,D$6),NA()))","v":31361.199999999997},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A19,E$6),NA()))","v":31485.300000000003},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A19,F$6),NA()))","v":33383},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A19,G$6),NA()))","v":37894.699999999997}]
[{"$f":"ROWS($B$15:B20)","v":6},{"$f":"IF(财务数据输入!B11=0,\"\",财务数据输入!B11)","v":"净利润"},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A20,C$6),NA()))","v":558608.1},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A20,D$6),NA()))","v":597479.5},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A20,E$6),NA()))","v":614835.89999999991},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A20,F$6),NA()))","v":662721},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A20,G$6),NA()))","v":674748.5}]
[{"$f":"ROWS($B$15:B21)","v":7},{"$f":"IF(财务数据输入!B12=0,\"\",财务数据输入!B12)","v":"税费"},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A21,C$6),NA()))","v":255767.40000000002},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A21,D$6),NA()))","v":274988.59999999998},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A21,E$6),NA()))","v":283356.69999999995},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A21,F$6),NA()))","v":294245.3},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A21,G$6),NA()))","v":314082.5}]
[{"$f":"ROWS($B$15:B22)","v":8},{"$f":"IF(财务数据输入!B13=0,\"\",财务数据输入!B13)","v":"税后利润"},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A22,C$6),NA()))","v":384185.3},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A22,D$6),NA()))","v":398950.5},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A22,E$6),NA()))","v":406077.30000000005},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A22,F$6),NA()))","v":424382},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A22,G$6),NA()))","v":502476.79999999999}]
[{"$f":"ROWS($B$15:B23)","v":9},{"$f":"IF(财务数据输入!B14=0,\"\",财务数据输入!B14)","v":"指标 1"},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A23,C$6),NA()))","v":137.79999999999998},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A23,D$6),NA()))","v":142.89999999999998},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A23,E$6),NA()))","v":155.69999999999999},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A23,F$6),NA()))","v":167.8},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A23,G$6),NA()))","v":199.60000000000002}]
[{"$f":"ROWS($B$15:B24)","v":10},{"$f":"IF(财务数据输入!B15=0,\"\",财务数据输入!B15)","v":"指标 2"},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A24,C$6),NA()))","v":192.2},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A24,D$6),NA()))","v":201.70000000000002},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A24,E$6),NA()))","v":204.8},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A24,F$6),NA()))","v":218.4},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A24,G$6),NA()))","v":260.10000000000002}]
[{"$f":"ROWS($B$15:B25)","v":11},{"$f":"IF(财务数据输入!B16=0,\"\",财务数据输入!B16)","v":"指标 3"},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A25,C$6),NA()))","v":218.70000000000002},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A25,D$6),NA()))","v":231.9},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A25,E$6),NA()))","v":246.70000000000002},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A25,F$6),NA()))","v":263.89999999999998},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A25,G$6),NA()))","v":310.79999999999995}]
[{"$f":"ROWS($B$15:B26)","v":12},{"$f":"IF(财务数据输入!B17=0,\"\",财务数据输入!B17)","v":"指标 4"},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A26,C$6),NA()))","v":125.9},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A26,D$6),NA()))","v":137},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A26,E$6),NA()))","v":137.6},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A26,F$6),NA()))","v":145.9},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A26,G$6),NA()))","v":149.19999999999999}]
[{"$f":"ROWS($B$15:B27)","v":13},{"$f":"IF(财务数据输入!B18=0,\"\",财务数据输入!B18)","v":"指标 5"},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A27,C$6),NA()))","v":8.5},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A27,D$6),NA()))","v":8.9},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A27,E$6),NA()))","v":9.1},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A27,F$6),NA()))","v":10},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A27,G$6),NA()))","v":10.3}]
[{"$f":"ROWS($B$15:B28)","v":14},{"$f":"IF(财务数据输入!B19=0,\"\",财务数据输入!B19)","v":"指标 6"},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A28,C$6),NA()))","v":2.7},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A28,D$6),NA()))","v":2.8000000000000003},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A28,E$6),NA()))","v":2.9},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A28,F$6),NA()))","v":3},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A28,G$6),NA()))","v":3.4000000000000004}]
[{"$f":"ROWS($B$15:B29)","v":15},{"$f":"IF(财务数据输入!B20=0,\"\",财务数据输入!B20)","v":""},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A29,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A29,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A29,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A29,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B29=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A29,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B30)","v":16},{"$f":"IF(财务数据输入!B21=0,\"\",财务数据输入!B21)","v":""},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A30,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A30,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A30,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A30,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B30=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A30,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B31)","v":17},{"$f":"IF(财务数据输入!B22=0,\"\",财务数据输入!B22)","v":""},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A31,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A31,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A31,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A31,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B31=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A31,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B32)","v":18},{"$f":"IF(财务数据输入!B23=0,\"\",财务数据输入!B23)","v":""},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A32,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A32,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A32,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A32,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B32=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A32,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B33)","v":19},{"$f":"IF(财务数据输入!B24=0,\"\",财务数据输入!B24)","v":""},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A33,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A33,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A33,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A33,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B33=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A33,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B34)","v":20},{"$f":"IF(财务数据输入!B25=0,\"\",财务数据输入!B25)","v":""},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A34,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A34,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A34,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A34,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B34=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A34,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B35)","v":21},{"$f":"IF(财务数据输入!B26=0,\"\",财务数据输入!B26)","v":""},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A35,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A35,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A35,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A35,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B35=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A35,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B36)","v":22},{"$f":"IF(财务数据输入!B27=0,\"\",财务数据输入!B27)","v":""},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A36,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A36,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A36,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A36,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B36=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A36,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B37)","v":23},{"$f":"IF(财务数据输入!B28=0,\"\",财务数据输入!B28)","v":""},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A37,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A37,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A37,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A37,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B37=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A37,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B38)","v":24},{"$f":"IF(财务数据输入!B29=0,\"\",财务数据输入!B29)","v":""},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A38,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A38,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A38,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A38,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B38=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A38,G$6),NA()))","v":{"$error":"#N/A"}}]
[{"$f":"ROWS($B$15:B39)","v":25},{"$f":"IF(财务数据输入!B30=0,\"\",财务数据输入!B30)","v":""},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A39,C$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A39,D$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A39,E$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A39,F$6),NA()))","v":{"$error":"#N/A"}},{"$f":"IF(B39=\"\",NA(),IFERROR(INDEX(财务数据输入!$B$6:$I$30,$A39,G$6),NA()))","v":{"$error":"#N/A"}}]