{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["儀表板","銷售","收入","支出","稅金","類別"],"not_rendered":{"images":1,"defined_names":34},"read":"whole","date_system":"1900"}

{"sheet":"儀表板","index":0,"n_rows":20,"n_cols":8,"rows_kept":20,"merged":[[0,2,0,4],[0,6,3,7],[5,1,5,7]]}
[null,"損益表","[月或年] 截至 [月-日-年]"]
[null,"公司名稱","單位：千元"]
[null,"目前毛利率  [L/J]",{"$f":"IFERROR(IF(總計_毛_利=0,\"-\",總計_毛_利/總計_銷售_營收),\"-\")","v":"-"}]
[null,"目前銷售收益  [T/J]",{"$f":"IFERROR(IF(淨_利=0,\"-\",淨_利/總計_銷售_營收),\"-\")","v":"-"}]
[]
[null,"請勿在此工作表中修改類別，否則可能會造成公式無法執行。請使用 [類別] 工作表來新增類別和更新含有項目的相對應工作表。此工作表會自動更新。"]
[null,"摘要","前期總計","預算總計","本期\n總計","本期佔銷售的百分比總計","以前期為基礎的變更百分比總計","以預算為基礎的變更百分比總計"]
[null,"銷售營收總計  [J]",{"$f":"SUMIFS(銷售營收[前期],銷售營收[營收類型],\"銷售營收\")","v":0},{"$f":"SUMIFS(銷售營收[預算],銷售營收[營收類型],\"銷售營收\")","v":0},{"$f":"SUMIFS(銷售營收[本期],銷售營收[營收類型],\"銷售營收\")","v":0},{"$f":"SUMIFS(銷售營收[本期佔銷售的百分比],銷售營收[營收類型],\"銷售營收\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(銷售營收[以前期為基礎的變更百分比],銷售營收[營收類型],\"銷售營收\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(銷售營收[以預算為基礎的變更百分比],銷售營收[營收類型],\"銷售營收\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售成本總計  [K]",{"$f":"SUMIFS(銷售營收[前期],銷售營收[營收類型],\"銷售成本\")","v":0},{"$f":"SUMIFS(銷售營收[預算],銷售營收[營收類型],\"銷售成本\")","v":0},{"$f":"SUMIFS(銷售營收[本期],銷售營收[營收類型],\"銷售成本\")","v":0},{"$f":"SUMIFS(銷售營收[本期佔銷售的百分比],銷售營收[營收類型],\"銷售成本\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(銷售營收[以前期為基礎的變更百分比],銷售營收[營收類型],\"銷售成本\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(銷售營收[以預算為基礎的變更百分比],銷售營收[營收類型],\"銷售成本\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售和行銷支出總計  [M]",{"$f":"SUMIFS(營運支出[前期],營運支出[支出類型],\"銷售和行銷\")","v":0},{"$f":"SUMIFS(營運支出[預算],營運支出[支出類型],\"銷售和行銷\")","v":0},{"$f":"SUMIFS(營運支出[本期],營運支出[支出類型],\"銷售和行銷\")","v":0},{"$f":"SUMIFS(營運支出[本期佔銷售的百分比],營運支出[支出類型],\"銷售和行銷\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(營運支出[以前期為基礎的變更百分比],營運支出[支出類型],\"銷售和行銷\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(營運支出[以預算為基礎的變更百分比],營運支出[支出類型],\"銷售和行銷\")","v":{"v":0,"d":"0.00%"}}]
[null,"研究和開發支出總計  [N]",{"$f":"SUMIFS(營運支出[前期],營運支出[支出類型],\"研究和開發\")","v":0},{"$f":"SUMIFS(營運支出[預算],營運支出[支出類型],\"研究和開發\")","v":0},{"$f":"SUMIFS(營運支出[本期],營運支出[支出類型],\"研究和開發\")","v":0},{"$f":"SUMIFS(營運支出[本期佔銷售的百分比],營運支出[支出類型],\"研究和開發\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(營運支出[以前期為基礎的變更百分比],營運支出[支出類型],\"研究和開發\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(營運支出[以預算為基礎的變更百分比],營運支出[支出類型],\"研究和開發\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政支出總計  [O]",{"$f":"SUMIFS(營運支出[前期],營運支出[支出類型],\"一般行政\")","v":0},{"$f":"SUMIFS(營運支出[預算],營運支出[支出類型],\"一般行政\")","v":0},{"$f":"SUMIFS(營運支出[本期],營運支出[支出類型],\"一般行政\")","v":0},{"$f":"SUMIFS(營運支出[本期佔銷售的百分比],營運支出[支出類型],\"一般行政\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(營運支出[以前期為基礎的變更百分比],營運支出[支出類型],\"一般行政\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(營運支出[以預算為基礎的變更百分比],營運支出[支出類型],\"一般行政\")","v":{"v":0,"d":"0.00%"}}]
[null,"其他營運支出總計  [P]",{"$f":"營運支出[[#Totals],[前期]]-SUM(C10:C12)","v":0},{"$f":"營運支出[[#Totals],[預算]]-SUM(D10:D12)","v":0},{"$f":"營運支出[[#Totals],[本期]]-SUM(E10:E12)","v":0},{"$f":"營運支出[[#Totals],[本期佔銷售的百分比]]-SUM(F10:F12)","v":{"v":0,"d":"0.00%"}},{"$f":"營運支出[[#Totals],[以前期為基礎的變更百分比]]-SUM(G10:G12)","v":{"v":0,"d":"0.00%"}},{"$f":"營運支出[[#Totals],[以預算為基礎的變更百分比]]-SUM(H10:H12)","v":{"v":0,"d":"0.00%"}}]
[null,"其他收入  [S]",{"$f":"收入[[#Totals],[前期]]","v":0},{"$f":"收入[[#Totals],[預算]]","v":0},{"$f":"收入[[#Totals],[本期]]","v":0},{"$f":"收入[[#Totals],[本期佔銷售的百分比]]","v":{"v":0,"d":"0.00%"}},{"$f":"收入[[#Totals],[以前期為基礎的變更百分比]]","v":{"v":0,"d":"0.00%"}},{"$f":"收入[[#Totals],[以預算為基礎的變更百分比]]","v":{"v":0,"d":"0.00%"}}]
[null,"稅金總計  [T]",{"$f":"稅金[[#Totals],[前期]]","v":0},{"$f":"稅金[[#Totals],[預算]]","v":0},{"$f":"稅金[[#Totals],[本期]]","v":0},{"$f":"稅金[[#Totals],[本期佔銷售的百分比]]","v":{"v":0,"d":"0.00%"}},{"$f":"稅金[[#Totals],[以前期為基礎的變更百分比]]","v":{"v":0,"d":"0.00%"}},{"$f":"稅金[[#Totals],[以預算為基礎的變更百分比]]","v":{"v":0,"d":"0.00%"}}]
[]
[null,"毛利  [L=J-K]",{"$f":"IFERROR(C8-C9,\"-\")","v":0},{"$f":"IFERROR(D8-D9,\"-\")","v":0},{"$f":"IFERROR(總計_銷售_營收-總計_銷售_成本,\"-\")","v":0},{"$f":"IFERROR(IF(總計_銷售_營收=0,\"0.00%\",總計_毛_利/總計_銷售_營收),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C17=總計_毛_利,0,IF(總計_毛_利>C17,ABS((總計_毛_利/C17)-1),IF(AND(總計_毛_利<C17,C17<0),-((總計_毛_利/C17)-1),(總計_毛_利/C17)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D17=總計_毛_利,0,IF(總計_毛_利>D17,ABS((總計_毛_利/D17)-1),IF(AND(總計_毛_利<D17,D17<0),-((總計_毛_利/D17)-1),(總計_毛_利/D17)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"營運支出總計  [Q=M+N+O+P]",{"$f":"IFERROR(C10+C11+C12+C13,\"-\")","v":0},{"$f":"IFERROR(D10+D11+D12+D13,\"-\")","v":0},{"$f":"IFERROR(總計_銷售_和_行銷+總計_研究_和_開發+總計_一般_行政+總計_其他_支出,\"-\")","v":0},{"$f":"IFERROR(IF(總計_銷售_營收=0,\"0.00%\",總計_營運_支出/總計_銷售_營收),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C18=總計_營運_支出,0,IF(總計_營運_支出>C18,ABS((總計_營運_支出/C18)-1),IF(AND(總計_營運_支出<C18,C18<0),-((總計_營運_支出/C18)-1),(總計_營運_支出/C18)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D18=總計_營運_支出,0,IF(總計_營運_支出>D18,ABS((總計_營運_支出/D18)-1),IF(AND(總計_營運_支出<D18,D18<0),-((總計_營運_支出/D18)-1),(總計_營運_支出/D18)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"來自營運的收入  [R=L-Q]",{"$f":"IFERROR(C17-C18,\"-\")","v":0},{"$f":"IFERROR(D17-D18,\"-\")","v":0},{"$f":"IFERROR(總計_毛_利-總計_營運_支出,\"-\")","v":0},{"$f":"IFERROR(IF(總計_銷售_營收=0,\"0.00%\",總計_收入_營運/總計_銷售_營收),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C19=總計_收入_營運,0,IF(總計_收入_營運>C19,ABS((總計_收入_營運/C19)-1),IF(AND(總計_收入_營運<C19,C19<0),-((總計_收入_營運/C19)-1),(總計_收入_營運/C19)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D19=總計_收入_營運,0,IF(總計_收入_營運>D19,ABS((總計_收入_營運/D19)-1),IF(AND(總計_收入_營運<D19,D19<0),-((總計_收入_營運/D19)-1),(總計_收入_營運/D19)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"淨利  [U=R+S-T]",{"$f":"IFERROR(C19+C14-C15,\"-\")","v":0},{"$f":"IFERROR(D19+D14-D15,\"-\")","v":0},{"$f":"總計_收入_營運+總計_其他_收入-總計_稅金","v":0},{"$f":"IFERROR(IF(總計_銷售_營收=0,\"0.00%\",淨_利/總計_銷售_營收),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C20=淨_利,0,IF(淨_利>C20,ABS((淨_利/C20)-1),IF(AND(淨_利<C20,C20<0),-((淨_利/C20)-1),(淨_利/C20)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D20=淨_利,0,IF(淨_利>D20,ABS((淨_利/D20)-1),IF(AND(淨_利<D20,D20<0),-((淨_利/D20)-1),(淨_利/D20)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]

{"sheet":"銷售","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"merged":[[0,7,2,8]]}
[null,{"$f":"活頁簿_標題","v":"損益表"}]
[null,{"$f":"公司_名稱","v":"公司名稱"},"單位：千元"]
[null,"銷售營收",{"$f":"IFERROR(銷售_營收,\"-\")","v":0}]
[null,"營收類型","描述","前期","預算","本期","本期佔銷售的百分比","以前期為基礎的變更百分比","以預算為基礎的變更百分比"]
[null,"銷售營收","產品/服務 1",{"$nulls":3},{"$f":"IFERROR(IF(銷售營收[[#Totals],[本期]]=0,\"-\",銷售營收[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(銷售營收[[#This Row],[前期]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[前期]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[前期]],銷售營收[[#This Row],[前期]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(銷售營收[[#This Row],[預算]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[預算]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[預算]],銷售營收[[#This Row],[預算]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售營收","產品/服務 2",{"$nulls":3},{"$f":"IFERROR(IF(銷售營收[[#Totals],[本期]]=0,\"-\",銷售營收[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(銷售營收[[#This Row],[前期]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[前期]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[前期]],銷售營收[[#This Row],[前期]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(銷售營收[[#This Row],[預算]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[預算]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[預算]],銷售營收[[#This Row],[預算]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售營收","產品/服務 3",{"$nulls":3},{"$f":"IFERROR(IF(銷售營收[[#Totals],[本期]]=0,\"-\",銷售營收[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(銷售營收[[#This Row],[前期]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[前期]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[前期]],銷售營收[[#This Row],[前期]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(銷售營收[[#This Row],[預算]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[預算]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[預算]],銷售營收[[#This Row],[預算]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售營收","產品/服務 4",{"$nulls":3},{"$f":"IFERROR(IF(銷售營收[[#Totals],[本期]]=0,\"-\",銷售營收[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(銷售營收[[#This Row],[前期]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[前期]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[前期]],銷售營收[[#This Row],[前期]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(銷售營收[[#This Row],[預算]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[預算]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[預算]],銷售營收[[#This Row],[預算]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售成本","產品/服務 1",{"$nulls":3},{"$f":"IFERROR(IF(銷售營收[[#Totals],[本期]]=0,\"-\",銷售營收[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(銷售營收[[#This Row],[前期]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[前期]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[前期]],銷售營收[[#This Row],[前期]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(銷售營收[[#This Row],[預算]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[預算]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[預算]],銷售營收[[#This Row],[預算]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售成本","產品/服務 2",{"$nulls":3},{"$f":"IFERROR(IF(銷售營收[[#Totals],[本期]]=0,\"-\",銷售營收[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(銷售營收[[#This Row],[前期]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[前期]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[前期]],銷售營收[[#This Row],[前期]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(銷售營收[[#This Row],[預算]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[預算]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[預算]],銷售營收[[#This Row],[預算]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售成本","產品/服務 3",{"$nulls":3},{"$f":"IFERROR(IF(銷售營收[[#Totals],[本期]]=0,\"-\",銷售營收[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(銷售營收[[#This Row],[前期]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[前期]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[前期]],銷售營收[[#This Row],[前期]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(銷售營收[[#This Row],[預算]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[預算]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[預算]],銷售營收[[#This Row],[預算]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售成本","產品/服務 4",{"$nulls":3},{"$f":"IFERROR(IF(銷售營收[[#Totals],[本期]]=0,\"-\",銷售營收[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(銷售營收[[#This Row],[前期]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[前期]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[前期]],銷售營收[[#This Row],[前期]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(銷售營收[[#This Row],[預算]]=銷售營收[[#This Row],[本期]],0,IF(銷售營收[[#This Row],[本期]]>銷售營收[[#This Row],[預算]],ABS((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),IF(AND(銷售營收[[#This Row],[本期]]<銷售營收[[#This Row],[預算]],銷售營收[[#This Row],[預算]]<0),-((銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1),(銷售營收[[#This Row],[本期]]/銷售營收[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售營收總計",null,{"$f":"SUBTOTAL(109,銷售營收[前期])","v":0},{"$f":"SUBTOTAL(109,銷售營收[預算])","v":0},{"$f":"SUBTOTAL(109,銷售營收[本期])","v":0},{"$f":"SUBTOTAL(109,銷售營收[本期佔銷售的百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,銷售營收[以前期為基礎的變更百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,銷售營收[以預算為基礎的變更百分比])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"收入","index":2,"n_rows":7,"n_cols":9,"rows_kept":7,"merged":[[0,7,2,8]]}
[null,{"$f":"活頁簿_標題","v":"損益表"}]
[null,{"$f":"公司_名稱","v":"公司名稱"},"單位：千元"]
[null,"收入",{"$f":"IFERROR(收入[[#Totals],[本期]],\"-\")","v":0}]
[null,"收入類型","描述","前期","預算","本期","本期佔銷售的百分比","以前期為基礎的變更百分比","以預算為基礎的變更百分比"]
[null,"收入","其他收入",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",收入[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(收入[[#This Row],[前期]]=收入[[#This Row],[本期]],0,IF(收入[[#This Row],[本期]]>收入[[#This Row],[前期]],ABS((收入[[#This Row],[本期]]/收入[[#This Row],[前期]])-1),IF(AND(收入[[#This Row],[本期]]<收入[[#This Row],[前期]],收入[[#This Row],[前期]]<0),-((收入[[#This Row],[本期]]/收入[[#This Row],[前期]])-1),(收入[[#This Row],[本期]]/收入[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(收入[[#This Row],[預算]]=收入[[#This Row],[本期]],0,IF(收入[[#This Row],[本期]]>收入[[#This Row],[預算]],ABS((收入[[#This Row],[本期]]/收入[[#This Row],[預算]])-1),IF(AND(收入[[#This Row],[本期]]<收入[[#This Row],[預算]],收入[[#This Row],[預算]]<0),-((收入[[#This Row],[本期]]/收入[[#This Row],[預算]])-1),(收入[[#This Row],[本期]]/收入[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[{"$nulls":6},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",收入[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(收入[[#This Row],[前期]]=收入[[#This Row],[本期]],0,IF(收入[[#This Row],[本期]]>收入[[#This Row],[前期]],ABS((收入[[#This Row],[本期]]/收入[[#This Row],[前期]])-1),IF(AND(收入[[#This Row],[本期]]<收入[[#This Row],[前期]],收入[[#This Row],[前期]]<0),-((收入[[#This Row],[本期]]/收入[[#This Row],[前期]])-1),(收入[[#This Row],[本期]]/收入[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(收入[[#This Row],[預算]]=收入[[#This Row],[本期]],0,IF(收入[[#This Row],[本期]]>收入[[#This Row],[預算]],ABS((收入[[#This Row],[本期]]/收入[[#This Row],[預算]])-1),IF(AND(收入[[#This Row],[本期]]<收入[[#This Row],[預算]],收入[[#This Row],[預算]]<0),-((收入[[#This Row],[本期]]/收入[[#This Row],[預算]])-1),(收入[[#This Row],[本期]]/收入[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售收入總計",null,{"$f":"SUBTOTAL(109,收入[前期])","v":0},{"$f":"SUBTOTAL(109,收入[預算])","v":0},{"$f":"SUBTOTAL(109,收入[本期])","v":0},{"$f":"SUBTOTAL(109,收入[本期佔銷售的百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,收入[以前期為基礎的變更百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,收入[以預算為基礎的變更百分比])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"支出","index":3,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[0,7,2,8]]}
[null,{"$f":"活頁簿_標題","v":"損益表"}]
[null,{"$f":"公司_名稱","v":"公司名稱"},"單位：千元"]
[null,"運總支出",{"$f":"IFERROR(營運支出[[#Totals],[本期]],\"-\")","v":0}]
[null,"支出類型","描述","前期","預算","本期","本期佔銷售的百分比","以前期為基礎的變更百分比","以預算為基礎的變更百分比"]
[null,"銷售和行銷","廣告",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售和行銷","直接行銷",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售和行銷","其他支出 (請載明)",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"銷售和行銷","其他支出 (請載明)",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研究和開發","技術授權",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研究和開發","專利權 ",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研究和開發","其他支出 (請載明)",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研究和開發","其他支出 (請載明)",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","工資和薪水",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","外部服務",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","用品",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","餐點和娛樂",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","房租",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","電話",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","公用事業費用",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","折舊",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","保險",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","修繕和維護",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","其他支出 (請載明)",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般行政","其他支出 (請載明)",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",營運支出[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(營運支出[[#This Row],[前期]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[前期]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[前期]],營運支出[[#This Row],[前期]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(營運支出[[#This Row],[預算]]=營運支出[[#This Row],[本期]],0,IF(營運支出[[#This Row],[本期]]>營運支出[[#This Row],[預算]],ABS((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),IF(AND(營運支出[[#This Row],[本期]]<營運支出[[#This Row],[預算]],營運支出[[#This Row],[預算]]<0),-((營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1),(營運支出[[#This Row],[本期]]/營運支出[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"營運支出總計",null,{"$f":"SUBTOTAL(109,營運支出[前期])","v":0},{"$f":"SUBTOTAL(109,營運支出[預算])","v":0},{"$f":"SUBTOTAL(109,營運支出[本期])","v":0},{"$f":"SUBTOTAL(109,營運支出[本期佔銷售的百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,營運支出[以前期為基礎的變更百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,營運支出[以預算為基礎的變更百分比])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"稅金","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[0,7,2,8]]}
[null,{"$f":"活頁簿_標題","v":"損益表"}]
[null,{"$f":"公司_名稱","v":"公司名稱"},"單位：千元"]
[null,"稅金",{"$f":"IFERROR(稅金[[#Totals],[本期]],\"-\")","v":0}]
[null,"類型","描述","前期","預算","本期","本期佔銷售的百分比","以前期為基礎的變更百分比","以預算為基礎的變更百分比"]
[null,"稅金","所得稅",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",稅金[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(稅金[[#This Row],[前期]]=稅金[[#This Row],[本期]],0,IF(稅金[[#This Row],[本期]]>稅金[[#This Row],[前期]],ABS((稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1),IF(AND(稅金[[#This Row],[本期]]<稅金[[#This Row],[前期]],稅金[[#This Row],[前期]]<0),-((稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1),(稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(稅金[[#This Row],[預算]]=稅金[[#This Row],[本期]],0,IF(稅金[[#This Row],[本期]]>稅金[[#This Row],[預算]],ABS((稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1),IF(AND(稅金[[#This Row],[本期]]<稅金[[#This Row],[預算]],稅金[[#This Row],[預算]]<0),-((稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1),(稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"稅金","薪資稅",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",稅金[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(稅金[[#This Row],[前期]]=稅金[[#This Row],[本期]],0,IF(稅金[[#This Row],[本期]]>稅金[[#This Row],[前期]],ABS((稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1),IF(AND(稅金[[#This Row],[本期]]<稅金[[#This Row],[前期]],稅金[[#This Row],[前期]]<0),-((稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1),(稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(稅金[[#This Row],[預算]]=稅金[[#This Row],[本期]],0,IF(稅金[[#This Row],[本期]]>稅金[[#This Row],[預算]],ABS((稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1),IF(AND(稅金[[#This Row],[本期]]<稅金[[#This Row],[預算]],稅金[[#This Row],[預算]]<0),-((稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1),(稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"稅金","不動產稅",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",稅金[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(稅金[[#This Row],[前期]]=稅金[[#This Row],[本期]],0,IF(稅金[[#This Row],[本期]]>稅金[[#This Row],[前期]],ABS((稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1),IF(AND(稅金[[#This Row],[本期]]<稅金[[#This Row],[前期]],稅金[[#This Row],[前期]]<0),-((稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1),(稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(稅金[[#This Row],[預算]]=稅金[[#This Row],[本期]],0,IF(稅金[[#This Row],[本期]]>稅金[[#This Row],[預算]],ABS((稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1),IF(AND(稅金[[#This Row],[本期]]<稅金[[#This Row],[預算]],稅金[[#This Row],[預算]]<0),-((稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1),(稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"稅金","其他稅金 (請載明)",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",稅金[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(稅金[[#This Row],[前期]]=稅金[[#This Row],[本期]],0,IF(稅金[[#This Row],[本期]]>稅金[[#This Row],[前期]],ABS((稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1),IF(AND(稅金[[#This Row],[本期]]<稅金[[#This Row],[前期]],稅金[[#This Row],[前期]]<0),-((稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1),(稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(稅金[[#This Row],[預算]]=稅金[[#This Row],[本期]],0,IF(稅金[[#This Row],[本期]]>稅金[[#This Row],[預算]],ABS((稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1),IF(AND(稅金[[#This Row],[本期]]<稅金[[#This Row],[預算]],稅金[[#This Row],[預算]]<0),-((稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1),(稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"稅金","其他稅金 (請載明)",{"$nulls":3},{"$f":"IFERROR(IF(銷售_營收=0,\"-\",稅金[[#This Row],[本期]]/銷售_營收),\"-\")","v":"-"},{"$f":"IFERROR(IF(稅金[[#This Row],[前期]]=稅金[[#This Row],[本期]],0,IF(稅金[[#This Row],[本期]]>稅金[[#This Row],[前期]],ABS((稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1),IF(AND(稅金[[#This Row],[本期]]<稅金[[#This Row],[前期]],稅金[[#This Row],[前期]]<0),-((稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1),(稅金[[#This Row],[本期]]/稅金[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(稅金[[#This Row],[預算]]=稅金[[#This Row],[本期]],0,IF(稅金[[#This Row],[本期]]>稅金[[#This Row],[預算]],ABS((稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1),IF(AND(稅金[[#This Row],[本期]]<稅金[[#This Row],[預算]],稅金[[#This Row],[預算]]<0),-((稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1),(稅金[[#This Row],[本期]]/稅金[[#This Row],[預算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"稅金總計",null,{"$f":"SUBTOTAL(109,稅金[前期])","v":0},{"$f":"SUBTOTAL(109,稅金[預算])","v":0},{"$f":"SUBTOTAL(109,稅金[本期])","v":0},{"$f":"IFERROR(SUBTOTAL(109,稅金[本期佔銷售的百分比]),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,稅金[以前期為基礎的變更百分比])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,稅金[以預算為基礎的變更百分比])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"類別","index":5,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"類別"]
[null,"銷售營收"]
[null,"銷售成本"]
[null,"收入"]
[null,"銷售和行銷"]
[null,"研究和開發"]
[null,"一般行政"]
[null,"稅金"]