{"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":19,"n_cols":8,"rows_kept":19,"merged":[[0,2,0,4],[0,6,3,7],[4,1,4,7]]}
[null,"損益計算書","[月または年] 用 (終了日: [年 - 月 - 日])"]
[null,"会社名","000s で表示"]
[null,"現在の粗利益率  [L/J]",{"$f":"IFERROR(IF(Total_Gross_Profit=0,\"-\",Total_Gross_Profit/総売上収益),\"-\")","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(OperatingExpenses[前期],OperatingExpenses[経費の種類],\"販売/マーケティング\")","v":0},{"$f":"SUMIFS(OperatingExpenses[予算],OperatingExpenses[経費の種類],\"販売/マーケティング\")","v":0},{"$f":"SUMIFS(OperatingExpenses[当期],OperatingExpenses[経費の種類],\"販売/マーケティング\")","v":0},{"$f":"SUMIFS(OperatingExpenses[当期の売上率],OperatingExpenses[経費の種類],\"販売/マーケティング\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[前期からの変化率],OperatingExpenses[経費の種類],\"販売/マーケティング\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[予算からの変化率],OperatingExpenses[経費の種類],\"販売/マーケティング\")","v":{"v":0,"d":"0.00%"}}]
[null,"研究開発費合計  [N]",{"$f":"SUMIFS(OperatingExpenses[前期],OperatingExpenses[経費の種類],\"研究開発\")","v":0},{"$f":"SUMIFS(OperatingExpenses[予算],OperatingExpenses[経費の種類],\"研究開発\")","v":0},{"$f":"SUMIFS(OperatingExpenses[当期],OperatingExpenses[経費の種類],\"研究開発\")","v":0},{"$f":"SUMIFS(OperatingExpenses[当期の売上率],OperatingExpenses[経費の種類],\"研究開発\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[前期からの変化率],OperatingExpenses[経費の種類],\"研究開発\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[予算からの変化率],OperatingExpenses[経費の種類],\"研究開発\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費合計  [O]",{"$f":"SUMIFS(OperatingExpenses[前期],OperatingExpenses[経費の種類],\"一般および管理費\")","v":0},{"$f":"SUMIFS(OperatingExpenses[予算],OperatingExpenses[経費の種類],\"一般および管理費\")","v":0},{"$f":"SUMIFS(OperatingExpenses[当期],OperatingExpenses[経費の種類],\"一般および管理費\")","v":0},{"$f":"SUMIFS(OperatingExpenses[当期の売上率],OperatingExpenses[経費の種類],\"一般および管理費\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[前期からの変化率],OperatingExpenses[経費の種類],\"一般および管理費\")","v":{"v":0,"d":"0.00%"}},{"$f":"SUMIFS(OperatingExpenses[予算からの変化率],OperatingExpenses[経費の種類],\"一般および管理費\")","v":{"v":0,"d":"0.00%"}}]
[null,"その他の営業経費の合計 [P]",{"$f":"OperatingExpenses[[#Totals],[前期]]-SUM(C9:C11)","v":0},{"$f":"OperatingExpenses[[#Totals],[予算]]-SUM(D9:D11)","v":0},{"$f":"OperatingExpenses[[#Totals],[当期]]-SUM(E9:E11)","v":0},{"$f":"OperatingExpenses[[#Totals],[当期の売上率]]-SUM(F9:F11)","v":{"v":0,"d":"0.00%"}},{"$f":"OperatingExpenses[[#Totals],[前期からの変化率]]-SUM(G9:G11)","v":{"v":0,"d":"0.00%"}},{"$f":"OperatingExpenses[[#Totals],[予算からの変化率]]-SUM(H9:H11)","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(C7-C8,\"-\")","v":0},{"$f":"IFERROR(D7-D8,\"-\")","v":0},{"$f":"IFERROR(総売上収益-Total_Cost_Sales,\"-\")","v":0},{"$f":"IFERROR(IF(総売上収益=0,\"0.00%\",Total_Gross_Profit/総売上収益),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C16=Total_Gross_Profit,0,IF(Total_Gross_Profit>C16,ABS((Total_Gross_Profit/C16)-1),IF(AND(Total_Gross_Profit<C16,C16<0),-((Total_Gross_Profit/C16)-1),(Total_Gross_Profit/C16)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D16=Total_Gross_Profit,0,IF(Total_Gross_Profit>D16,ABS((Total_Gross_Profit/D16)-1),IF(AND(Total_Gross_Profit<D16,D16<0),-((Total_Gross_Profit/D16)-1),(Total_Gross_Profit/D16)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"営業経費の合計  [Q=M+N+O+P]",{"$f":"IFERROR(C9+C10+C11+C12,\"-\")","v":0},{"$f":"IFERROR(D9+D10+D11+D12,\"-\")","v":0},{"$f":"IFERROR(Total_Sales_and_Marketing+Total_Research_and_Development+Total_General_and_Administrative+Total_Other_Expenses,\"-\")","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,"事業からの利益  [R=L-Q]",{"$f":"IFERROR(C16-C17,\"-\")","v":0},{"$f":"IFERROR(D16-D17,\"-\")","v":0},{"$f":"IFERROR(Total_Gross_Profit-営業経費の合計,\"-\")","v":0},{"$f":"IFERROR(IF(総売上収益=0,\"0.00%\",Total_Income_Operations/総売上収益),\"-\")","v":"0.00%"},{"$f":"IFERROR(IF(C18=Total_Income_Operations,0,IF(Total_Income_Operations>C18,ABS((Total_Income_Operations/C18)-1),IF(AND(Total_Income_Operations<C18,C18<0),-((Total_Income_Operations/C18)-1),(Total_Income_Operations/C18)-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(D18=Total_Income_Operations,0,IF(Total_Income_Operations>D18,ABS((Total_Income_Operations/D18)-1),IF(AND(Total_Income_Operations<D18,D18<0),-((Total_Income_Operations/D18)-1),(Total_Income_Operations/D18)-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"純利益  [U=R+S-T]",{"$f":"IFERROR(C18+C13-C14,\"-\")","v":0},{"$f":"IFERROR(D18+D13-D14,\"-\")","v":0},{"$f":"Total_Income_Operations+Total_Other_Income-税合計","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%"}}]

{"sheet":"売上","index":1,"n_rows":13,"n_cols":9,"rows_kept":13,"merged":[[0,7,2,8]]}
[null,{"$f":"Workbook_Title","v":"損益計算書"}]
[null,{"$f":"会社名","v":"会社名"},"000s で表示"]
[null,"売上収益",{"$f":"IFERROR(売上_収益,\"-\")","v":0}]
[null,"収益の種類","説明","前期","予算","当期","当期の売上率","前期からの変化率","予算からの変化率"]
[null,"売上収益","製品/サービス 1",{"$nulls":3},{"$f":"IFERROR(IF(売上収益[[#Totals],[当期]]=0,\"-\",売上収益[当期]/売上_収益),\"-\")","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,\"-\",売上収益[当期]/売上_収益),\"-\")","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,\"-\",売上収益[当期]/売上_収益),\"-\")","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,\"-\",売上収益[当期]/売上_収益),\"-\")","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,\"-\",売上収益[当期]/売上_収益),\"-\")","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,\"-\",売上収益[当期]/売上_収益),\"-\")","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,\"-\",売上収益[当期]/売上_収益),\"-\")","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,\"-\",売上収益[当期]/売上_収益),\"-\")","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":"Workbook_Title","v":"損益計算書"}]
[null,{"$f":"会社名","v":"会社名"},"000s で表示"]
[null,"収入",{"$f":"IFERROR(収入[[#Totals],[当期]],\"-\")","v":0}]
[null,"収入の種類","説明","前期","予算","当期","当期の売上率","前期からの変化率","予算からの変化率"]
[null,"収入","その他の収入",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",収入[当期]/売上_収益),\"-\")","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,\"-\",収入[当期]/売上_収益),\"-\")","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":"Workbook_Title","v":"損益計算書"}]
[null,{"$f":"会社名","v":"会社名"},"000s で表示"]
[null,"営業経費",{"$f":"IFERROR(OperatingExpenses[[#Totals],[当期]],\"-\")","v":0}]
[null,"経費の種類","説明","前期","予算","当期","当期の売上率","前期からの変化率","予算からの変化率"]
[null,"販売/マーケティング","広告",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"販売/マーケティング","直接販売",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"販売/マーケティング","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"販売/マーケティング","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研究開発","技術ライセンス",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研究開発","特許 ",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研究開発","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"研究開発","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","賃金と給与",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","外部サービス",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","備品",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","食事と娯楽",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","家賃",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","電話番号",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","水道光熱費",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","減価償却費",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","保険料",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","修繕およびメンテナンス費",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"一般および管理費","その他の費用 (指定)",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",OperatingExpenses[当期]/売上_収益),\"-\")","v":"-"},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[前期]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[前期]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[前期]],OperatingExpenses[[#This Row],[前期]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[前期]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}},{"$f":"IFERROR(IF(OperatingExpenses[[#This Row],[予算]]=OperatingExpenses[[#This Row],[当期]],0,IF(OperatingExpenses[[#This Row],[当期]]>OperatingExpenses[[#This Row],[予算]],ABS((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),IF(AND(OperatingExpenses[[#This Row],[当期]]<OperatingExpenses[[#This Row],[予算]],OperatingExpenses[[#This Row],[予算]]<0),-((OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1),(OperatingExpenses[[#This Row],[当期]]/OperatingExpenses[[#This Row],[予算]])-1))),\"-\")","v":{"v":0,"d":"0.00%"}}]
[null,"営業経費の合計",null,{"$f":"SUBTOTAL(109,OperatingExpenses[前期])","v":0},{"$f":"SUBTOTAL(109,OperatingExpenses[予算])","v":0},{"$f":"SUBTOTAL(109,OperatingExpenses[当期])","v":0},{"$f":"SUBTOTAL(109,OperatingExpenses[当期の売上率])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,OperatingExpenses[前期からの変化率])","v":{"v":0,"d":"0.00%"}},{"$f":"SUBTOTAL(109,OperatingExpenses[予算からの変化率])","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":"Workbook_Title","v":"損益計算書"}]
[null,{"$f":"会社名","v":"会社名"},"000s で表示"]
[null,"税金",{"$f":"IFERROR(税金[[#Totals],[当期]],\"-\")","v":0}]
[null,"種類","説明","前期","予算","当期","当期の売上率","前期からの変化率","予算からの変化率"]
[null,"税金","法人税",{"$nulls":3},{"$f":"IFERROR(IF(売上_収益=0,\"-\",税金[当期]/売上_収益),\"-\")","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,\"-\",税金[当期]/売上_収益),\"-\")","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,\"-\",税金[当期]/売上_収益),\"-\")","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,\"-\",税金[当期]/売上_収益),\"-\")","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,\"-\",税金[当期]/売上_収益),\"-\")","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,"税金"]