{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["財務報告","財務資料輸入","關鍵指標設定","計算"],"not_rendered":{"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"財務報告","index":0,"n_rows":40,"n_cols":14,"rows_kept":40,"merged":[[1,10,1,11],[6,9,6,11],[7,9,7,11],[8,9,8,11],[9,9,9,11],[12,3,12,7],[14,8,14,11],[15,8,15,11],[16,8,16,11],[17,8,17,11],[18,8,18,11],[19,8,19,11],[20,8,20,11],[21,8,21,11],[22,8,22,11],[23,8,23,11],[24,8,24,11],[25,8,25,11],[26,8,26,11],[27,8,27,11],[28,8,28,11],[29,8,29,11],[30,8,30,11],[31,8,31,11],[32,8,32,11],[33,8,33,11],[34,8,34,11],[35,8,35,11],[36,8,36,11],[37,8,37,11],[38,8,38,11],[39,8,39,11]]}
[]
[null,"年度財務報表",{"$nulls":8},2016,null,null,"於儲存格 L2 選取報表年份"]
[null,"公司名稱",{"$nulls":11},"若要編輯資料，請選取 財務資料輸入 工作表"]
[]
[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":{"v":5417516.4,"d":"NT$5,417,516"}},null,{"$f":"IFERROR(計算!G9,\"\")","v":{"v":2024245.5000000002,"d":"NT$2,024,246"}},null,{"$f":"IFERROR(計算!G10,\"\")","v":{"v":113684.09999999999,"d":"NT$113,684"}},null,{"$f":"IFERROR(計算!G11,\"\")","v":{"v":166406.4,"d":"NT$166,406"}},null,{"$f":"IFERROR(計算!G12,\"\")","v":{"v":2202779.7,"d":"NT$2,202,780"}}]
[null,{"$f":"計算!H8","v":{"v":3.0953753897409175E-3,"d":"0%"}},null,{"$f":"計算!H9","v":{"v":0.018148662861143583,"d":"2%"}},null,{"$f":"計算!H10","v":{"v":0.1351496270556869,"d":"14%"}},null,{"$f":"計算!H11","v":{"v":0.09440022728976682,"d":"9%"}},null,{"$f":"計算!H12","v":{"v":-0.05033560822904615,"d":"-5%"}}]
[]
[]
[]
[null,"所有指標",null,"請勿修改下列資訊。按一下以輸入財務資料"]
[]
[null,"指標",null,{"$f":"\"報表年 (\"&SelectedYear&\")\"","v":"報表年 (2016)"},null,{"$f":"\"前一年 (\"&SelectedYear-1&\")\"","v":"前一年 (2015)"},null,"變化幅度",{"$f":"CONCATENATE(Years,\" 年趨勢\")","v":"5 年趨勢"}]
[null,{"$f":"計算!B15","v":"收入"},null,{"$f":"IF($B16=\"\",\"\",計算!G15)","v":{"v":5417516.4,"d":"NT$5,417,516.40"}},null,{"$f":"IF($B16=\"\",\"\",計算!F15)","v":{"v":5400798.9,"d":"NT$5,400,798.90"}},null,{"$f":"IFERROR(D16/F16-1,\"\")","v":{"v":3.0953753897409175E-3,"d":"0%"}}]
[null,{"$f":"計算!B16","v":"營運費用"},null,{"$f":"IF($B17=\"\",\"\",計算!G16)","v":{"v":2832583.5,"d":"NT$2,832,583.50"}},null,{"$f":"IF($B17=\"\",\"\",計算!F16)","v":{"v":2426499.9,"d":"NT$2,426,499.90"}},null,{"v":0.16735364382252804,"d":"17%"}]
[null,{"$f":"計算!B17","v":"營運利潤"},null,{"$f":"IF($B18=\"\",\"\",計算!G17)","v":{"v":2202779.7,"d":"NT$2,202,779.70"}},null,{"$f":"IF($B18=\"\",\"\",計算!F17)","v":{"v":2319534.9,"d":"NT$2,319,534.90"}},null,{"v":-0.05033560822904615,"d":"-5%"}]
[null,{"$f":"計算!B18","v":"折舊"},null,{"$f":"IF($B19=\"\",\"\",計算!G18)","v":{"v":166406.4,"d":"NT$166,406.40"}},null,{"$f":"IF($B19=\"\",\"\",計算!F18)","v":{"v":152052.6,"d":"NT$152,052.60"}},null,{"v":0.09440022728976682,"d":"9%"}]
[null,{"$f":"計算!B19","v":"利息"},null,{"$f":"IF($B20=\"\",\"\",計算!G19)","v":{"v":113684.09999999999,"d":"NT$113,684.10"}},null,{"$f":"IF($B20=\"\",\"\",計算!F19)","v":{"v":100149,"d":"NT$100,149.00"}},null,{"v":0.1351496270556869,"d":"14%"}]
[null,{"$f":"計算!B20","v":"淨收益"},null,{"$f":"IF($B21=\"\",\"\",計算!G20)","v":{"v":2024245.5000000002,"d":"NT$2,024,245.50"}},null,{"$f":"IF($B21=\"\",\"\",計算!F20)","v":{"v":1988163.0000000002,"d":"NT$1,988,163.00"}},null,{"v":0.018148662861143583,"d":"2%"}]
[null,{"$f":"計算!B21","v":"稅金"},null,{"$f":"IF($B22=\"\",\"\",計算!G21)","v":{"v":942247.5,"d":"NT$942,247.50"}},null,{"$f":"IF($B22=\"\",\"\",計算!F21)","v":{"v":882735.8999999999,"d":"NT$882,735.90"}},null,{"v":0.06741721957835867,"d":"7%"}]
[null,{"$f":"計算!B22","v":"稅後淨利"},null,{"$f":"IF($B23=\"\",\"\",計算!G22)","v":{"v":1507430.4,"d":"NT$1,507,430.40"}},null,{"$f":"IF($B23=\"\",\"\",計算!F22)","v":{"v":1273146,"d":"NT$1,273,146.00"}},null,{"v":0.18402005740111504,"d":"18%"}]
[null,{"$f":"計算!B23","v":"指標 1"},null,{"$f":"IF($B24=\"\",\"\",計算!G23)","v":{"v":598.8000000000001,"d":"NT$598.80"}},null,{"$f":"IF($B24=\"\",\"\",計算!F23)","v":{"v":503.40000000000003,"d":"NT$503.40"}},null,{"v":0.18951132300357565,"d":"19%"}]
[null,{"$f":"計算!B24","v":"指標 2"},null,{"$f":"IF($B25=\"\",\"\",計算!G24)","v":{"v":780.3000000000001,"d":"NT$780.30"}},null,{"$f":"IF($B25=\"\",\"\",計算!F24)","v":{"v":655.2,"d":"NT$655.20"}},null,{"v":0.19093406593406592,"d":"19%"}]
[null,{"$f":"計算!B25","v":"指標 3"},null,{"$f":"IF($B26=\"\",\"\",計算!G25)","v":{"v":932.4,"d":"NT$932.40"}},null,{"$f":"IF($B26=\"\",\"\",計算!F25)","v":{"v":791.7,"d":"NT$791.70"}},null,{"v":0.17771883289124668,"d":"18%"}]
[null,{"$f":"計算!B26","v":"指標 4"},null,{"$f":"IF($B27=\"\",\"\",計算!G26)","v":{"v":447.6,"d":"NT$447.60"}},null,{"$f":"IF($B27=\"\",\"\",計算!F26)","v":{"v":437.7,"d":"NT$437.70"}},null,{"v":0.022618231665524346,"d":"2%"}]
[null,{"$f":"計算!B27","v":"指標 5"},null,{"$f":"IF($B28=\"\",\"\",計算!G27)","v":{"v":30.900000000000002,"d":"NT$30.90"}},null,{"$f":"IF($B28=\"\",\"\",計算!F27)","v":{"v":30,"d":"NT$30.00"}},null,{"v":0.030000000000000027,"d":"3%"}]
[null,{"$f":"計算!B28","v":"指標 6"},null,{"$f":"IF($B29=\"\",\"\",計算!G28)","v":{"v":10.200000000000001,"d":"NT$10.20"}},null,{"$f":"IF($B29=\"\",\"\",計算!F28)","v":{"v":9,"d":"NT$9.00"}},null,{"v":0.13333333333333353,"d":"13%"}]
[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}
[]
[null,"輸入您的財務資料"]
[null," 您可以定義最多 25 項關鍵指標、最長涵蓋 7 年"]
[null," 按一下以檢視財務報表"]
[null,"指標名稱",2010,2011,2012,2013,2014,2015,2016]
[null,"收入",{"v":3750000,"d":"NT$3,750,000.00"},{"v":4024123.5000000005,"d":"NT$4,024,123.50"},{"v":4281851.4,"d":"NT$4,281,851.40"},{"v":4520623.8,"d":"NT$4,520,623.80"},{"v":4951336.8,"d":"NT$4,951,336.80"},{"v":5400798.9,"d":"NT$5,400,798.90"},{"v":5417516.4,"d":"NT$5,417,516.40"}]
[null,"營運費用",{"v":1950000,"d":"NT$1,950,000.00"},{"v":2128869.3,"d":"NT$2,128,869.30"},{"v":2277745.8,"d":"NT$2,277,745.80"},{"v":2367038.1,"d":"NT$2,367,038.10"},{"v":2450231.0999999996,"d":"NT$2,450,231.10"},{"v":2426499.9,"d":"NT$2,426,499.90"},{"v":2832583.5,"d":"NT$2,832,583.50"}]
[null,"營運利潤",{"v":1800000,"d":"NT$1,800,000.00"},{"v":1926219,"d":"NT$1,926,219.00"},{"v":2065730.7000000002,"d":"NT$2,065,730.70"},{"v":2269297.5,"d":"NT$2,269,297.50"},{"v":2302657.8,"d":"NT$2,302,657.80"},{"v":2319534.9,"d":"NT$2,319,534.90"},{"v":2202779.7,"d":"NT$2,202,779.70"}]
[null,"折舊",{"v":135000,"d":"NT$135,000.00"},{"v":135533.1,"d":"NT$135,533.10"},{"v":139707.6,"d":"NT$139,707.60"},{"v":149226.3,"d":"NT$149,226.30"},{"v":150723.3,"d":"NT$150,723.30"},{"v":152052.6,"d":"NT$152,052.60"},{"v":166406.4,"d":"NT$166,406.40"}]
[null,"利息",{"v":75000,"d":"NT$75,000.00"},{"v":82374.6,"d":"NT$82,374.60"},{"v":86793.3,"d":"NT$86,793.30"},{"v":94083.59999999999,"d":"NT$94,083.60"},{"v":94455.90000000001,"d":"NT$94,455.90"},{"v":100149,"d":"NT$100,149.00"},{"v":113684.09999999999,"d":"NT$113,684.10"}]
[null,"淨收益",{"v":1620000,"d":"NT$1,620,000.00"},{"v":1642832.25,"d":"NT$1,642,832.25"},{"v":1675824.2999999998,"d":"NT$1,675,824.30"},{"v":1792438.5,"d":"NT$1,792,438.50"},{"v":1844507.7,"d":"NT$1,844,507.70"},{"v":1988163.0000000002,"d":"NT$1,988,163.00"},{"v":2024245.5000000002,"d":"NT$2,024,245.50"}]
[null,"稅金",{"v":660000,"d":"NT$660,000.00"},{"v":717616.2000000001,"d":"NT$717,616.20"},{"v":767302.2000000001,"d":"NT$767,302.20"},{"v":824965.8,"d":"NT$824,965.80"},{"v":850070.1,"d":"NT$850,070.10"},{"v":882735.8999999999,"d":"NT$882,735.90"},{"v":942247.5,"d":"NT$942,247.50"}]
[null,"稅後淨利",{"v":960000,"d":"NT$960,000.00"},{"v":1048304.7,"d":"NT$1,048,304.70"},{"v":1152555.9,"d":"NT$1,152,555.90"},{"v":1196851.5,"d":"NT$1,196,851.50"},{"v":1218231.9000000001,"d":"NT$1,218,231.90"},{"v":1273146,"d":"NT$1,273,146.00"},{"v":1507430.4,"d":"NT$1,507,430.40"}]
[null,"指標 1",{"v":384,"d":"NT$384.00"},{"v":384.3,"d":"NT$384.30"},{"v":413.4,"d":"NT$413.40"},{"v":428.7,"d":"NT$428.70"},{"v":467.1,"d":"NT$467.10"},{"v":503.40000000000003,"d":"NT$503.40"},{"v":598.8000000000001,"d":"NT$598.80"}]
[null,"指標 2",{"v":546,"d":"NT$546.00"},{"v":557.7,"d":"NT$557.70"},{"v":576.5999999999999,"d":"NT$576.60"},{"v":605.1,"d":"NT$605.10"},{"v":614.4,"d":"NT$614.40"},{"v":655.2,"d":"NT$655.20"},{"v":780.3000000000001,"d":"NT$780.30"}]
[null,"指標 3",{"v":573,"d":"NT$573.00"},{"v":616.5,"d":"NT$616.50"},{"v":656.1,"d":"NT$656.10"},{"v":695.7,"d":"NT$695.70"},{"v":740.1,"d":"NT$740.10"},{"v":791.7,"d":"NT$791.70"},{"v":932.4,"d":"NT$932.40"}]
[null,"指標 4",{"v":363,"d":"NT$363.00"},{"v":366.3,"d":"NT$366.30"},{"v":377.7,"d":"NT$377.70"},{"v":411,"d":"NT$411.00"},{"v":412.8,"d":"NT$412.80"},{"v":437.7,"d":"NT$437.70"},{"v":447.6,"d":"NT$447.60"}]
[null,"指標 5",{"v":22.5,"d":"NT$22.50"},{"v":23.700000000000003,"d":"NT$23.70"},{"v":25.5,"d":"NT$25.50"},{"v":26.7,"d":"NT$26.70"},{"v":27.3,"d":"NT$27.30"},{"v":30,"d":"NT$30.00"},{"v":30.900000000000002,"d":"NT$30.90"}]
[null,"指標 6",{"v":6.9,"d":"NT$6.90"},{"v":7.5,"d":"NT$7.50"},{"v":8.100000000000001,"d":"NT$8.10"},{"v":8.4,"d":"NT$8.40"},{"v":8.7,"d":"NT$8.70"},{"v":9,"d":"NT$9.00"},{"v":10.200000000000001,"d":"NT$10.20"}]

{"sheet":"關鍵指標設定","index":2,"n_rows":9,"n_cols":5,"rows_kept":9,"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,"hidden":true}
["此工作表用於財務報表計算，應保持隱藏。"]
[{"$nulls":3},"Position"]
[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,"Position",{"$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":4281851.4},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A8,D$6),NA())","v":4520623.8},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A8,E$6),NA())","v":4951336.8},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A8,F$6),NA())","v":5400798.9},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A8,G$6),NA())","v":5417516.4},{"$f":"IFERROR(G8/F8-1,\"\")","v":{"v":3.0953753897409175E-3,"d":"0%"}}]
[{"$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":1675824.2999999998},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A9,D$6),NA())","v":1792438.5},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A9,E$6),NA())","v":1844507.7},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A9,F$6),NA())","v":1988163.0000000002},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A9,G$6),NA())","v":2024245.5000000002},{"$f":"IFERROR(G9/F9-1,\"\")","v":{"v":0.018148662861143583,"d":"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":86793.3},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A10,D$6),NA())","v":94083.59999999999},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A10,E$6),NA())","v":94455.90000000001},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A10,F$6),NA())","v":100149},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A10,G$6),NA())","v":113684.09999999999},{"v":0.1351496270556869,"d":"14%"}]
[{"$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":139707.6},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A11,D$6),NA())","v":149226.3},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A11,E$6),NA())","v":150723.3},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A11,F$6),NA())","v":152052.6},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A11,G$6),NA())","v":166406.4},{"v":0.09440022728976682,"d":"9%"}]
[{"$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":2065730.7000000002},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A12,D$6),NA())","v":2269297.5},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A12,E$6),NA())","v":2302657.8},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A12,F$6),NA())","v":2319534.9},{"$f":"IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A12,G$6),NA())","v":2202779.7},{"v":-0.05033560822904615,"d":"-5%"}]
[]
[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":4281851.4},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A15,D$6),NA()))","v":4520623.8},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A15,E$6),NA()))","v":4951336.8},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A15,F$6),NA()))","v":5400798.9},{"$f":"IF(B15=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A15,G$6),NA()))","v":5417516.4}]
[{"$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":2277745.8},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A16,D$6),NA()))","v":2367038.1},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A16,E$6),NA()))","v":2450231.0999999996},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A16,F$6),NA()))","v":2426499.9},{"$f":"IF(B16=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A16,G$6),NA()))","v":2832583.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":2065730.7000000002},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A17,D$6),NA()))","v":2269297.5},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A17,E$6),NA()))","v":2302657.8},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A17,F$6),NA()))","v":2319534.9},{"$f":"IF(B17=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A17,G$6),NA()))","v":2202779.7}]
[{"$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":139707.6},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A18,D$6),NA()))","v":149226.3},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A18,E$6),NA()))","v":150723.3},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A18,F$6),NA()))","v":152052.6},{"$f":"IF(B18=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A18,G$6),NA()))","v":166406.4}]
[{"$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":86793.3},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A19,D$6),NA()))","v":94083.59999999999},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A19,E$6),NA()))","v":94455.90000000001},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A19,F$6),NA()))","v":100149},{"$f":"IF(B19=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A19,G$6),NA()))","v":113684.09999999999}]
[{"$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":1675824.2999999998},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A20,D$6),NA()))","v":1792438.5},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A20,E$6),NA()))","v":1844507.7},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A20,F$6),NA()))","v":1988163.0000000002},{"$f":"IF(B20=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A20,G$6),NA()))","v":2024245.5000000002}]
[{"$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":767302.2000000001},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A21,D$6),NA()))","v":824965.8},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A21,E$6),NA()))","v":850070.1},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A21,F$6),NA()))","v":882735.8999999999},{"$f":"IF(B21=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A21,G$6),NA()))","v":942247.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":1152555.9},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A22,D$6),NA()))","v":1196851.5},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A22,E$6),NA()))","v":1218231.9000000001},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A22,F$6),NA()))","v":1273146},{"$f":"IF(B22=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A22,G$6),NA()))","v":1507430.4}]
[{"$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":413.4},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A23,D$6),NA()))","v":428.7},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A23,E$6),NA()))","v":467.1},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A23,F$6),NA()))","v":503.40000000000003},{"$f":"IF(B23=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A23,G$6),NA()))","v":598.8000000000001}]
[{"$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":576.5999999999999},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A24,D$6),NA()))","v":605.1},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A24,E$6),NA()))","v":614.4},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A24,F$6),NA()))","v":655.2},{"$f":"IF(B24=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A24,G$6),NA()))","v":780.3000000000001}]
[{"$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":656.1},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A25,D$6),NA()))","v":695.7},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A25,E$6),NA()))","v":740.1},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A25,F$6),NA()))","v":791.7},{"$f":"IF(B25=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A25,G$6),NA()))","v":932.4}]
[{"$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":377.7},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A26,D$6),NA()))","v":411},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A26,E$6),NA()))","v":412.8},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A26,F$6),NA()))","v":437.7},{"$f":"IF(B26=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A26,G$6),NA()))","v":447.6}]
[{"$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":25.5},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A27,D$6),NA()))","v":26.7},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A27,E$6),NA()))","v":27.3},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A27,F$6),NA()))","v":30},{"$f":"IF(B27=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A27,G$6),NA()))","v":30.900000000000002}]
[{"$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":8.100000000000001},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A28,D$6),NA()))","v":8.4},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A28,E$6),NA()))","v":8.7},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A28,F$6),NA()))","v":9},{"$f":"IF(B28=\"\",NA(),IFERROR(INDEX(財務資料輸入!$B$6:$I$30,$A28,G$6),NA()))","v":10.200000000000001}]
[{"$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"}}]