{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["ダッシュボード","売上","収入","支出","税金","カテゴリ"],"not_rendered":{"defined_names":34},"read":"whole","date_system":"1900"}

{"sheet":"ダッシュボード","index":0,"n_rows":22,"n_cols":9,"rows_kept":22,"merged":[[5,2,5,8]]}
[]
[]
[null,null,"損益計算書",{"$nulls":4},"現在の粗利益率  [L/J]","8 月 31 日までの月"]
[null,null,"SATCOM CELLULAR",{"$nulls":4},"現在の売上利益率  [T/J]","000 で表示"]
[]
[null,null,"このワークシートのカテゴリを変更しないでください。変更すると、数式が壊れる可能性があります。[カテゴリ] ワークシートを使用して、カテゴリを追加し、対応するワークシートをエントリで更新します。このワークシートは自動的に更新されます。"]
[]
[null,null,"まとめ","前期合計","予算合計","当期合計","売上高に対する当期合計","前期からの合計変動率","予算からの合計変動率"]
[null,null,"総売上収益  [J]",{"$f":"SUMIFS(売上収益[前期],売上収益[収益の種類],\"売上収益\")","v":{"v":100,"d":"¥100.00"}},{"$f":"SUMIFS(売上収益[予算],売上収益[収益の種類],\"売上収益\")","v":{"v":101,"d":"¥101.00"}},{"$f":"SUMIFS(売上収益[当期],売上収益[収益の種類],\"売上収益\")","v":{"v":100,"d":"¥100.00"}},{"$f":"SUMIFS(売上収益[当期の売上高に対する割合],売上収益[収益の種類],\"売上収益\")","v":{"v":1,"d":"100.00%"}},{"$f":"SUMIFS(売上収益[前期からの変動率],売上収益[収益の種類],\"売上収益\")","v":{"v":-1.1102230246251565E-16,"d":"-0.00%"}},{"$f":"SUMIFS(売上収益[予算からの変動率],売上収益[収益の種類],\"売上収益\")","v":{"v":3.95,"d":"395.00%"}}]
[null,null,"売上原価合計  [K]",{"$f":"SUMIFS(売上収益[前期],売上収益[収益の種類],\"売上原価\")","v":{"v":-25,"d":"¥-25.00"}},{"$f":"SUMIFS(売上収益[予算],売上収益[収益の種類],\"売上原価\")","v":{"v":-50,"d":"¥-50.00"}},{"$f":"SUMIFS(売上収益[当期],売上収益[収益の種類],\"売上原価\")","v":{"v":-55,"d":"¥-55.00"}},{"$f":"SUMIFS(売上収益[当期の売上高に対する割合],売上収益[収益の種類],\"売上原価\")","v":{"v":-0.55,"d":"-55.00%"}},{"$f":"SUMIFS(売上収益[前期からの変動率],売上収益[収益の種類],\"売上原価\")","v":{"v":-1.2000000000000002,"d":"-120.00%"}},{"$f":"SUMIFS(売上収益[予算からの変動率],売上収益[収益の種類],\"売上原価\")","v":{"v":-0.10000000000000009,"d":"-10.00%"}}]
[null,null,"販売/マーケティング費用合計  [M]",{"$f":"SUMIFS(営業経費[前期],営業経費[経費の種類],\"販売/マーケティング\")","v":{"v":30,"d":"¥30.00"}},{"$f":"SUMIFS(営業経費[予算],営業経費[経費の種類],\"販売/マーケティング\")","v":{"v":35,"d":"¥35.00"}},{"$f":"SUMIFS(営業経費[当期],営業経費[経費の種類],\"販売/マーケティング\")","v":{"v":45,"d":"¥45.00"}},{"$f":"SUMIFS(営業経費[当期の売上高に対する割合],営業経費[経費の種類],\"販売/マーケティング\")","v":{"v":0.45,"d":"45.00%"}},{"$f":"SUMIFS(営業経費[前期からの変動率],営業経費[経費の種類],\"販売/マーケティング\")","v":{"v":0.5,"d":"50.00%"}},{"$f":"SUMIFS(営業経費[予算からの変動率],営業経費[経費の種類],\"販売/マーケティング\")","v":{"v":0.2857142857142858,"d":"28.57%"}}]
[null,null,"研究開発費合計  [N]",{"$f":"SUMIFS(営業経費[前期],営業経費[経費の種類],\"研究開発\")","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(営業経費[予算],営業経費[経費の種類],\"研究開発\")","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(営業経費[当期],営業経費[経費の種類],\"研究開発\")","v":{"v":0,"d":"¥0.00"}},{"$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,null,"一般および管理費合計  [O]",{"$f":"SUMIFS(営業経費[前期],営業経費[経費の種類],\"一般および管理費\")","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(営業経費[予算],営業経費[経費の種類],\"一般および管理費\")","v":{"v":0,"d":"¥0.00"}},{"$f":"SUMIFS(営業経費[当期],営業経費[経費の種類],\"一般および管理費\")","v":{"v":0,"d":"¥0.00"}},{"$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,null,"その他の営業経費の合計 [P]",{"$f":"営業経費[[#Totals],[前期]]-SUM(D11:D13)","v":{"v":0,"d":"¥0.00"}},{"$f":"営業経費[[#Totals],[予算]]-SUM(E11:E13)","v":{"v":0,"d":"¥0.00"}},{"$f":"営業経費[[#Totals],[当期]]-SUM(F11:F13)","v":{"v":0,"d":"¥0.00"}},{"$f":"営業経費[[#Totals],[当期の売上高に対する割合]]-SUM(G11:G13)","v":{"v":0,"d":"0.00%"}},{"$f":"営業経費[[#Totals],[前期からの変動率]]-SUM(H11:H13)","v":{"v":0,"d":"0.00%"}},{"$f":"営業経費[[#Totals],[予算からの変動率]]-SUM(I11:I13)","v":{"v":0,"d":"0.00%"}}]
[null,null,"その他の収入  [S]",{"$f":"収入[[#Totals],[前期]]","v":{"v":50,"d":"¥50.00"}},{"$f":"収入[[#Totals],[予算]]","v":{"v":60,"d":"¥60.00"}},{"$f":"収入[[#Totals],[当期]]","v":{"v":62,"d":"¥62.00"}},{"$f":"収入[[#Totals],[当期の売上高に対する割合]]","v":{"v":0.62,"d":"62.00%"}},{"$f":"収入[[#Totals],[前期からの変動率]]","v":{"v":0.24,"d":"24.00%"}},{"$f":"収入[[#Totals],[予算からの変動率]]","v":{"v":0.03333333333333344,"d":"3.33%"}}]
[null,null,"税合計  [T]",{"$f":"税金[[#Totals],[前期]]","v":{"v":10,"d":"¥10.00"}},{"$f":"税金[[#Totals],[予算]]","v":{"v":12,"d":"¥12.00"}},{"$f":"税金[[#Totals],[当期]]","v":{"v":12,"d":"¥12.00"}},{"$f":"税金[[#Totals],[当期の売上高に対する割合]]","v":{"v":0.12,"d":"12.00%"}},{"$f":"税金[[#Totals],[前期からの変動率]]","v":{"v":0.19999999999999996,"d":"20.00%"}},{"$f":"税金[[#Totals],[予算からの変動率]]","v":{"v":0,"d":"0.00%"}}]
[]
[null,null,"まとめ","前期\n合計","予算\n予算","当期\n合計","売上高に対する\n当期合計","前期からの\n合計変動率","予算からの\n合計変動率"]
[null,null,"粗利益  [L=J-K]",{"$f":"IFERROR(D9-D10,\"-\")","v":{"v":125,"d":"¥125.00"}},{"$f":"IFERROR(E9-E10,\"-\")","v":{"v":151,"d":"¥151.00"}},{"$f":"IFERROR(Total_Sales_Revenue-Total_Cost_Sales,\"-\")","v":{"v":155,"d":"¥155.00"}},{"$f":"IFERROR(IF(Total_Sales_Revenue=0,\"0.00%\",Total_Gross_Profit/Total_Sales_Revenue),\"-\")","v":{"v":1.55,"d":"155.00%"}},{"$f":"IFERROR(IF(D19=Total_Gross_Profit,0,IF(Total_Gross_Profit>D19,ABS((Total_Gross_Profit/D19)-1),IF(AND(Total_Gross_Profit<D19,D19<0),-((Total_Gross_Profit/D19)-1),(Total_Gross_Profit/D19)-1))),\"-\")","v":{"v":0.24,"d":"24.00%"}},{"$f":"IFERROR(IF(E19=Total_Gross_Profit,0,IF(Total_Gross_Profit>E19,ABS((Total_Gross_Profit/E19)-1),IF(AND(Total_Gross_Profit<E19,E19<0),-((Total_Gross_Profit/E19)-1),(Total_Gross_Profit/E19)-1))),\"-\")","v":{"v":0.026490066225165476,"d":"2.65%"}}]
[null,null,"営業経費の合計  [Q=M+N+O+P]",{"$f":"IFERROR(D11+D12+D13+D14,\"-\")","v":{"v":30,"d":"¥30.00"}},{"$f":"IFERROR(E11+E12+E13+E14,\"-\")","v":{"v":35,"d":"¥35.00"}},{"$f":"IFERROR(Total_Sales_and_Marketing+Total_Research_and_Development+Total_General_and_Administrative+Total_Other_Expenses,\"-\")","v":{"v":45,"d":"¥45.00"}},{"$f":"IFERROR(IF(Total_Sales_Revenue=0,\"0.00%\",営業経費の合計/Total_Sales_Revenue),\"-\")","v":{"v":0.45,"d":"45.00%"}},{"$f":"IFERROR(IF(D20=営業経費の合計,0,IF(営業経費の合計>D20,ABS((営業経費の合計/D20)-1),IF(AND(営業経費の合計<D20,D20<0),-((営業経費の合計/D20)-1),(営業経費の合計/D20)-1))),\"-\")","v":{"v":0.5,"d":"50.00%"}},{"$f":"IFERROR(IF(E20=営業経費の合計,0,IF(営業経費の合計>E20,ABS((営業経費の合計/E20)-1),IF(AND(営業経費の合計<E20,E20<0),-((営業経費の合計/E20)-1),(営業経費の合計/E20)-1))),\"-\")","v":{"v":0.2857142857142858,"d":"28.57%"}}]
[null,null,"事業からの利益  [R=L-Q]",{"$f":"IFERROR(D19-D20,\"-\")","v":{"v":95,"d":"¥95.00"}},{"$f":"IFERROR(E19-E20,\"-\")","v":{"v":116,"d":"¥116.00"}},{"$f":"IFERROR(Total_Gross_Profit-営業経費の合計,\"-\")","v":{"v":110,"d":"¥110.00"}},{"$f":"IFERROR(IF(Total_Sales_Revenue=0,\"0.00%\",Total_Income_Operations/Total_Sales_Revenue),\"-\")","v":{"v":1.1,"d":"110.00%"}},{"$f":"IFERROR(IF(D21=Total_Income_Operations,0,IF(Total_Income_Operations>D21,ABS((Total_Income_Operations/D21)-1),IF(AND(Total_Income_Operations<D21,D21<0),-((Total_Income_Operations/D21)-1),(Total_Income_Operations/D21)-1))),\"-\")","v":{"v":0.1578947368421053,"d":"15.79%"}},{"$f":"IFERROR(IF(E21=Total_Income_Operations,0,IF(Total_Income_Operations>E21,ABS((Total_Income_Operations/E21)-1),IF(AND(Total_Income_Operations<E21,E21<0),-((Total_Income_Operations/E21)-1),(Total_Income_Operations/E21)-1))),\"-\")","v":{"v":-0.051724137931034475,"d":"-5.17%"}}]
[null,null,"純利益  [U=R+S-T]",{"$f":"IFERROR(D21+D15-D16,\"-\")","v":{"v":135,"d":"¥135.00"}},{"$f":"IFERROR(E21+E15-E16,\"-\")","v":{"v":164,"d":"¥164.00"}},{"$f":"Total_Income_Operations+Total_Other_Income-Total_Taxes","v":{"v":160,"d":"¥160.00"}},{"$f":"IFERROR(IF(Total_Sales_Revenue=0,\"0.00%\",Net_Profit/Total_Sales_Revenue),\"-\")","v":{"v":1.6,"d":"160.00%"}},{"$f":"IFERROR(IF(D22=Net_Profit,0,IF(Net_Profit>D22,ABS((Net_Profit/D22)-1),IF(AND(Net_Profit<D22,D22<0),-((Net_Profit/D22)-1),(Net_Profit/D22)-1))),\"-\")","v":{"v":0.18518518518518512,"d":"18.52%"}},{"$f":"IFERROR(IF(E22=Net_Profit,0,IF(Net_Profit>E22,ABS((Net_Profit/E22)-1),IF(AND(Net_Profit<E22,E22<0),-((Net_Profit/E22)-1),(Net_Profit/E22)-1))),\"-\")","v":{"v":-0.024390243902439046,"d":"-2.44%"}}]

{"sheet":"売上","index":1,"n_rows":15,"n_cols":10,"rows_kept":15}
[]
[]
[null,null,{"$f":"ブック_タイトル","v":"損益計算書"},{"$nulls":5},"売上収益"]
[null,null,{"$f":"Company_Name","v":"SATCOM CELLULAR"},{"$nulls":5},"000 で表示",{"$f":"IFERROR(営業経費1,\"-\")","v":{"v":100,"d":"¥100.00"}}]
[]
[null,null,"収益の種類","内容","前期","予算","当期","当期の売上高に対する割合","前期からの変動率","予算からの変動率"]
[null,null,"売上収益","製品/サービス 1",{"v":50,"d":"¥50.00"},{"v":1,"d":"¥1.00"},{"v":5,"d":"¥5.00"},{"$f":"IFERROR(IF(売上収益[[#Totals],[当期]]=0,\"-\",売上収益[[#This Row],[当期]]/営業経費1),\"-\")","v":{"v":0.05,"d":"5.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.9,"d":"-90.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":4,"d":"400.00%"}}]
[null,null,"売上収益","製品/サービス 2",{"v":50,"d":"¥50.00"},{"v":100,"d":"¥100.00"},{"v":95,"d":"¥95.00"},{"$f":"IFERROR(IF(売上収益[[#Totals],[当期]]=0,\"-\",売上収益[[#This Row],[当期]]/営業経費1),\"-\")","v":{"v":0.95,"d":"95.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.8999999999999999,"d":"90.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.050000000000000044,"d":"-5.00%"}}]
[null,null,"売上収益","製品/サービス 3",{"$nulls":3},{"$f":"IFERROR(IF(売上収益[[#Totals],[当期]]=0,\"-\",売上収益[[#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%"}},{"$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,"売上収益","製品/サービス 4",{"$nulls":3},{"$f":"IFERROR(IF(売上収益[[#Totals],[当期]]=0,\"-\",売上収益[[#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%"}},{"$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,"売上原価","製品/サービス 1",{"v":-25,"d":"¥-25.00"},{"v":-50,"d":"¥-50.00"},{"v":-55,"d":"¥-55.00"},{"$f":"IFERROR(IF(売上収益[[#Totals],[当期]]=0,\"-\",売上収益[[#This Row],[当期]]/営業経費1),\"-\")","v":{"v":-0.55,"d":"-55.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":-1.2000000000000002,"d":"-120.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.10000000000000009,"d":"-10.00%"}}]
[null,null,"売上原価","製品/サービス 2",{"$nulls":3},{"$f":"IFERROR(IF(売上収益[[#Totals],[当期]]=0,\"-\",売上収益[[#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%"}},{"$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,"売上原価","製品/サービス 3",{"$nulls":3},{"$f":"IFERROR(IF(売上収益[[#Totals],[当期]]=0,\"-\",売上収益[[#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%"}},{"$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,"売上原価","製品/サービス 4",{"$nulls":3},{"$f":"IFERROR(IF(売上収益[[#Totals],[当期]]=0,\"-\",売上収益[[#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%"}},{"$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,"総売上収益",null,{"$f":"SUBTOTAL(109,売上収益[前期])","v":{"v":75,"d":"¥75.00"}},{"$f":"SUBTOTAL(109,売上収益[予算])","v":{"v":51,"d":"¥51.00"}},{"$f":"SUBTOTAL(109,売上収益[当期])","v":{"v":45,"d":"¥45.00"}},{"$f":"SUBTOTAL(109,売上収益[当期の売上高に対する割合])","v":{"v":0.44999999999999996,"d":"45.00%"}},{"$f":"SUBTOTAL(109,売上収益[前期からの変動率])","v":{"v":-1.2000000000000002,"d":"-120.00%"}},{"$f":"SUBTOTAL(109,売上収益[予算からの変動率])","v":{"v":3.85,"d":"385.00%"}}]

{"sheet":"収入","index":2,"n_rows":9,"n_cols":10,"rows_kept":9}
[]
[]
[null,null,{"$f":"ブック_タイトル","v":"損益計算書"},{"$nulls":5},"収入"]
[null,null,{"$f":"Company_Name","v":"SATCOM CELLULAR"},{"$nulls":5},"000 で表示",{"$f":"IFERROR(収入[[#Totals],[当期]],\"-\")","v":{"v":62,"d":"¥62.00"}}]
[]
[null,null,"収入の種類","内容","前期","予算","当期","当期の売上高に対する割合","前期からの変動率","予算からの変動率"]
[null,null,"収入","その他の収入",{"v":50,"d":"¥50.00"},{"v":60,"d":"¥60.00"},{"v":62,"d":"¥62.00"},{"$f":"IFERROR(IF(営業経費1=0,\"-\",収入[[#This Row],[当期]]/営業経費1),\"-\")","v":{"v":0.62,"d":"62.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.24,"d":"24.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.03333333333333344,"d":"3.33%"}}]
[{"$nulls":7},{"$f":"IFERROR(IF(営業経費1=0,\"-\",収入[[#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%"}},{"$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,"売上収入合計",null,{"$f":"SUBTOTAL(109,収入[前期])","v":{"v":50,"d":"¥50.00"}},{"$f":"SUBTOTAL(109,収入[予算])","v":{"v":60,"d":"¥60.00"}},{"$f":"SUBTOTAL(109,収入[当期])","v":{"v":62,"d":"¥62.00"}},{"$f":"SUBTOTAL(109,収入[当期の売上高に対する割合])","v":{"v":0.62,"d":"62.00%"}},{"$f":"SUBTOTAL(109,収入[前期からの変動率])","v":{"v":0.24,"d":"24.00%"}},{"$f":"SUBTOTAL(109,収入[予算からの変動率])","v":{"v":0.03333333333333344,"d":"3.33%"}}]

{"sheet":"支出","index":3,"n_rows":27,"n_cols":10,"rows_kept":27}
[]
[]
[null,null,{"$f":"ブック_タイトル","v":"損益計算書"},{"$nulls":5},"営業経費"]
[null,null,{"$f":"Company_Name","v":"SATCOM CELLULAR"},{"$nulls":5},"000 で表示",{"$f":"IFERROR(営業経費[[#Totals],[当期]],\"-\")","v":{"v":45,"d":"¥45.00"}}]
[]
[null,null,"経費の種類","内容","前期","予算","当期","当期の売上高に対する割合","前期からの変動率","予算からの変動率"]
[null,null,"販売/マーケティング","広告",{"v":30,"d":"¥30.00"},{"v":35,"d":"¥35.00"},{"v":45,"d":"¥45.00"},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#This Row],[当期]]/営業経費1),\"-\")","v":{"v":0.45,"d":"45.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.5,"d":"50.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.2857142857142858,"d":"28.57%"}}]
[null,null,"販売/マーケティング","直接販売",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"販売/マーケティング","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"販売/マーケティング","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"研究開発","技術ライセンス",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"研究開発","特許 ",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"研究開発","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"研究開発","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","賃金と給与",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","外部サービス",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","備品",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","食事と娯楽",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","家賃",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","電話番号",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","水道光熱費",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","減価償却費",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","保険料",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","修繕およびメンテナンス費",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"一般および管理費","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",営業経費[[#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%"}},{"$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,"営業経費の合計",null,{"$f":"SUBTOTAL(109,営業経費[前期])","v":{"v":30,"d":"¥30.00"}},{"$f":"SUBTOTAL(109,営業経費[予算])","v":{"v":35,"d":"¥35.00"}},{"$f":"SUBTOTAL(109,営業経費[当期])","v":{"v":45,"d":"¥45.00"}},{"$f":"SUBTOTAL(109,営業経費[当期の売上高に対する割合])","v":{"v":0.45,"d":"45.00%"}},{"$f":"SUBTOTAL(109,営業経費[前期からの変動率])","v":{"v":0.5,"d":"50.00%"}},{"$f":"SUBTOTAL(109,営業経費[予算からの変動率])","v":{"v":0.2857142857142858,"d":"28.57%"}}]

{"sheet":"税金","index":4,"n_rows":13,"n_cols":10,"rows_kept":13}
[]
[]
[null,null,{"$f":"ブック_タイトル","v":"損益計算書"},{"$nulls":5},"税金"]
[null,null,{"$f":"Company_Name","v":"SATCOM CELLULAR"},{"$nulls":5},"000 で表示",{"$f":"IFERROR(税金[[#Totals],[当期]],\"-\")","v":{"v":12,"d":"¥12.00"}}]
[]
[]
[null,null,"種類","内容","前期","予算","当期","当期の売上高に対する割合","前期からの変動率","予算からの変動率"]
[null,null,"税金","法人税",{"v":10,"d":"¥10.00"},{"v":12,"d":"¥12.00"},{"v":12,"d":"¥12.00"},{"$f":"IFERROR(IF(営業経費1=0,\"-\",税金[[#This Row],[当期]]/営業経費1),\"-\")","v":{"v":0.12,"d":"12.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.19999999999999996,"d":"20.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,"税金","給与税",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",税金[[#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%"}},{"$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,"税金","不動産税",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",税金[[#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%"}},{"$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,"税金","その他の税 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",税金[[#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%"}},{"$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,"税金","その他の税 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(営業経費1=0,\"-\",税金[[#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%"}},{"$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,"税合計",null,{"$f":"SUBTOTAL(109,税金[前期])","v":{"v":10,"d":"¥10.00"}},{"$f":"SUBTOTAL(109,税金[予算])","v":{"v":12,"d":"¥12.00"}},{"$f":"SUBTOTAL(109,税金[当期])","v":{"v":12,"d":"¥12.00"}},{"$f":"IFERROR(SUBTOTAL(109,税金[当期の売上高に対する割合]),\"-\")","v":{"v":0.12,"d":"12.00%"}},{"$f":"SUBTOTAL(109,税金[前期からの変動率])","v":{"v":0.19999999999999996,"d":"20.00%"}},{"$f":"SUBTOTAL(109,税金[予算からの変動率])","v":{"v":0,"d":"0.00%"}}]

{"sheet":"カテゴリ","index":5,"n_rows":13,"n_cols":3,"rows_kept":13}
[]
[]
[null,null,{"$f":"ブック_タイトル","v":"損益計算書"}]
[null,null,{"$f":"Company_Name","v":"SATCOM CELLULAR"}]
[]
[null,null,"分類項目"]
[null,null,"売上収益"]
[null,null,"売上原価"]
[null,null,"収入"]
[null,null,"販売/マーケティング"]
[null,null,"研究開発"]
[null,null,"一般および管理費"]
[null,null,"税金"]