{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["はじめに","説明","伝票作成","出納簿","期間別試算表","科目細分類表","現金照合表","手書き領収書フォーム"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":52,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"はじめに","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"説明","index":1,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[[9,2,10,5],[11,2,12,5],[9,8,11,11],[3,2,4,5],[5,2,6,5],[18,12,19,17],[24,12,25,17],[22,12,23,17],[4,8,4,11],[16,8,17,11],[21,8,22,11],[56,12,57,17],[23,2,23,3],[52,12,53,17],[29,12,30,17],[32,12,35,17],[39,12,41,17],[36,12,37,17],[42,12,44,17],[27,12,28,17],[44,2,44,5],[45,12,46,17],[24,8,25,11],[26,8,26,11],[29,8,30,11]]}
[null,"会計帳簿システムの使用手順",null,null,null,null,null,null,null,null,null,null,"４．補足Q&A"]
[null,null,null,null,null,null,null,null,null,null,null,null,"4-<1>バックアップ処理のイメージは？"]
[null,"１．年度初めの準備",null,null,null,null,null,"２.PCの動きが重くて伝票を削除したいとき。",null,null,null,null,"→バックアップには、A B C Dの4種類があります。"]
[null,null,"前年度から引き継ぐものは、このシステムとしては「会計帳簿.xlsm」だけです。",null,null,null,null,"基本的には年度初めの対応とほぼ同じです。"]
[null,null,null,null,null,null,null,"2-<1>","最初に、バックアップファイルCを作成します。"]
[null,"1-<1>","最初に、バックアップファイルCを作成します（同じフォルダ内）。"]
[]
[null,null,null,null,null,null,null,"2-<2>","伝票を削除します。"]
[null,null,null,null,null,null,null,null,"1-<2>だけ行います。"]
[null,"1-<2>","前年度の伝票を削除します（処理が軽ければ削除しなくてもOK）。",null,null,null,null,null,"ここへ削除したい範囲（基本的には期間計算の単位で、例えば2021/4/1~2021/6/30など）を入力して、伝票削除を実行してください。"]
[]
[null,null,"前年度の年度開始日を削除開始日へ、年度終了日を削除終了日へ入れるのが基本です。"]
[]
[null,null,null,null,null,null,null,"３．伝票入力と月次の処理"]
[null,null,"削除開始日","削除終了日",null,null,null,"3-<1>","現金及び預金の動きの全てを伝票処理します。"]
[null,null,null,null,null,null,null,null,"伝票を作ってから出納簿に記録するのではなく、"]
[null,null,"伝票の削除を実行します。",null,null,null,null,null,"出納簿（兼仕訳帳）に記録してから、伝票を印刷する順番にしています。"]
[]
[null,null,null,null,null,null,null,null,"作業方法は、出納簿の解説をお読みください。",null,null,null,"各月のEXCELマクロファイル(xlsm)を用意するのではなく、バックアップが各月の結果となります。"]
[null,null,"間違えて伝票を削除した場合"]
[null,null,"→補足4-<5>を行ってください。",null,null,null,null,"3-<2>","毎月末（期間末）に、試算表を作成します。"]
[null,null,null,null,null,null,null,null,"1)期間計算をクリック（期間別試算表の各期間の上段にボタン）",null,null,null,"4-<2>月次の処理が終わらないと、翌月の伝票を入れられないのか？"]
[null,"1-<3>-1","団体名を入れてください（一度入れればOK)。",null,null,null,null,null,null,null,null,null,"→伝票を入れるのは、いつでもOKです。但し、伝票Noは順番を守ってください。"]
[null,null,"A自治会_特別会計",null,null,null,null,null,"2)細分類をハンド記入"]
[null,"1-<3>-2","年度初めの設定をします。",null,null,null,null,null,"3)出納簿の印刷（　当該の期間を入力、科目は空欄にする。PDFで確認後印刷。）",null,null,null,"月次処理は全データから、当該期間のデータを拾い上げるため、他の期間のデータがあっても影響ありません。"]
[null,null,null,2021,"年度"]
[null,"1-<3>-3","期間別試算表の期間設定を行います。",null,null,null,null,null,"4）実績のある科目について、元帳を印刷"]
[null,null,null,"開始日","終了日",null,null,null,"5)現金と預金の残高照合",null,null,null,"4-<3>PCが高性能で、何も重くならないのに、過去の伝票を削除する必要があるのか？"]
[null,null,"前年度末",null,"2021-03-31"]
[null,null,"期間計算1","2021-04-01","2022-03-31",null,null,"3-<3>","バックアップBを作成します。（期間別試算表の各期間の上段にボタン）",null,null,null,"→サクサク動くのなら、年度を超えても伝票削除は不要です。但し年度初めは、1-<3>は必ず行ってください。"]
[null,null,"期間計算2"]
[null,null,"期間計算3"]
[null,null,"期間計算4",null,null,null,null,null,null,null,null,null,"4-<4>バックアップファイルなどファイルを開いたとき、「コンテンツの有効化」、を問われた場合は、そこをクリックして有効化してから、一度、保存してください。再度、開くときは、この問いは出てこないはずです。"]
[null,null,"期間計算5"]
[null,null,"期間計算6",null,null,null,null,null,"以上です。"]
[null,null,"期間計算7"]
[null,null,"期間計算8",null,null,null,null,null,null,null,null,null,"4-<5>間違えて伝票削除を実行した場合(削除をし過ぎた場合）、復元の仕方は？"]
[null,null,"期間計算9"]
[null,null,"期間計算10",null,null,null,null,null,null,null,null,null,"→慎重に行う必要があります。"]
[null,null,"期間計算11",null,null,null,null,null,null,null,null,null,"1) 同じフォルダの中に、バックアップCファイル「XXXXXXC_会計帳簿.xlsm」が作られているはずです。これを開いて、間違えて削除した伝票が残っていることを確認してください。"]
[null,null,"期間計算12"]
[]
[null,null,"通期期間",{"$f":"MIN(D30:D41)","v":"2021-04-01"},{"$f":"MAX(E30:E41)","v":"2022-03-31"},null,null,null,null,null,null,null,"2) 今、「会計帳簿.xlsm」と「XXXXXXC_会計帳簿.xlsm」の２つのファイルが開かれているはずです。「会計帳簿.xlsm」を閉じてください。"]
[]
[null,"1-<3>-4","前年度末の資産負債の残高を登録します。"]
[null,null,{"$f":"科目細分類[[#Headers],[現金]]","v":"現金"},null,"円",null,null,null,null,null,null,null,"3)「XXXXXXC_会計帳簿.xlsm」ファイルの「説明」シートのこの位置から、以下のバックアップDを実行ください。"]
[null,null,{"$f":"科目細分類[[#Headers],[普通預金(準備金移動前）]]","v":"普通預金(準備金移動前）"},null,"円"]
[null,null,{"$f":"科目細分類[[#Headers],[A準備金]]","v":"A準備金"},6300000,"円"]
[null,null,{"$f":"科目細分類[[#Headers],[B準備金]]","v":"B準備金"},null,"円"]
[null,null,{"$f":"科目細分類[[#Headers],[C準備金]]","v":"C準備金"},null,"円"]
[null,null,{"$f":"科目細分類[[#Headers],[固定資産]]","v":"固定資産"},61300000,"円",null,null,null,null,null,null,null,"4)「XXXXXXC_会計帳簿.xlsm」を閉じてください。"]
[null,null,{"$f":"科目細分類[[#Headers],[その他資産]]","v":"その他資産"},null,"円",null,null,null,null,null,null,null,"5)「会計帳簿.xlsm」を削除してください。"]
[null,null,{"$f":"科目細分類[[#Headers],[銀行借入金]]","v":"銀行借入金"},null,"円",null,null,null,null,null,null,null,"6)「XXXXXXC_会計帳簿.xlsm」の名前を「会計帳簿.xlsm」へ変更してください。"]
[null,null,{"$f":"科目細分類[[#Headers],[その他負債]]","v":"その他負債"},null,"円"]
[null,null,null,null,null,null,null,null,null,null,null,null,"7)1-<1>または2-<1>を再度行って下さい。"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"4-<6>使い始めた後で、科目名や細分類名を変更することが出来ますか？"]
[]
[null,"1-<3>-5","バックアップファイルAを作成します。",null,null,null,null,null,null,null,null,null,"→できます。科目細分類表」シートに手順があります。"]
[]
[]
[null,"年度初めの準備は以上です。"]

{"sheet":"伝票作成","index":2,"n_rows":32,"n_cols":32,"rows_kept":32,"cut":false,"hidden":false,"merged":[[32,1,39,10],[28,3,28,8],[29,3,29,8],[25,9,25,10],[26,9,26,10],[27,9,27,10],[28,9,28,10],[29,9,29,10],[25,3,25,8],[26,3,26,8],[27,3,27,8],[21,3,21,5],[21,8,21,10],[22,8,22,10],[22,3,22,5],[4,1,4,3],[6,1,6,3],[18,8,18,10],[19,8,19,10],[20,8,20,10],[8,1,8,5],[8,6,8,10],[18,3,18,5],[19,3,19,5],[20,3,20,5]]}
[null,{"$f":"IF(F16 <> K16,\"記入にエラーがあります。訂正してからPDF作成してください。\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,"伝票入力は出納簿で行います。ここでは伝票Noだけを入力します。"]
[null,null,null,{"$f":"説明!C24","v":"A自治会_特別会計"},null,null,"特別会計伝票"]
[null,{"$f":"説明!D26","v":2021},null,"年度",null,null,null,null,null,"会長印","会計印"]
[null,"伝票No",null,null,1]
[null,null,null,null,{"$f":"IF(AND(E7>=start_date,E7<=end_date),\"\",\"この伝票Noは古い年度で使われたままです！\")","v":""}]
[null,"計上日",null,null,{"$f":"INDEX(debit_allitems,MATCH(slip_no,debit_slip_no,0),1)","v":"2021-10-05"}]
[]
[null,"借　方",null,null,null,null,"貸　方"]
[null,"行番","No番号","科目G","科　目","金額(円)","行番","No番号","科目G","科　目","金額(円)"]
[null,1,{"$f":"slip_no&B11","v":"11"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C11,debit_chain,0),1),\"\")","v":"特会資産"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C11,debit_chain,0),2),\"\")","v":"普通預金(準備金移動前）"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C11,debit_chain,0),4),\"\")","v":27},1,{"$f":"slip_no&G11","v":"11"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H11,debit_chain,0),1),\"\")","v":"特会収入"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H11,debit_chain,0),2),\"\")","v":"その他収入    "},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H11,debit_chain,0),4),\"\")","v":27}]
[null,2,{"$f":"slip_no&B12","v":"12"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C12,debit_chain,0),1),\"\")","v":"特会資産"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C12,debit_chain,0),2),\"\")","v":"A準備金"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C12,debit_chain,0),4),\"\")","v":27},2,{"$f":"slip_no&G12","v":"12"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H12,debit_chain,0),1),\"\")","v":"特会資産"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H12,debit_chain,0),2),\"\")","v":"普通預金(準備金移動前）"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H12,debit_chain,0),4),\"\")","v":27}]
[null,3,{"$f":"slip_no&B13","v":"13"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C13,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C13,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C13,debit_chain,0),4),\"\")","v":""},3,{"$f":"slip_no&G13","v":"13"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H13,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H13,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H13,debit_chain,0),4),\"\")","v":""}]
[null,4,{"$f":"slip_no&B14","v":"14"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C14,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C14,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C14,debit_chain,0),4),\"\")","v":""},4,{"$f":"slip_no&G14","v":"14"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H14,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H14,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H14,debit_chain,0),4),\"\")","v":""}]
[null,5,{"$f":"slip_no&B15","v":"15"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C15,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C15,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C15,debit_chain,0),4),\"\")","v":""},5,{"$f":"slip_no&G15","v":"15"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H15,debit_chain,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H15,debit_chain,0),2),\"\")","v":""},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H15,debit_chain,0),4),\"\")","v":""}]
[null,null,null,null,"計",{"$f":"SUM(F11:F15)","v":54},null,null,null,"計",{"$f":"SUM(K11:K15)","v":54}]
[]
[null,null,null,"借方細分類",null,null,null,null,"貸方細分類"]
[null,1,{"$f":"C11","v":"11"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C19,debit_chain,0),3),\"\")","v":"-"},null,null,1,{"$f":"H11","v":"11"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H19,debit_chain,0),3),\"\")","v":"普通預金利子"}]
[null,2,{"$f":"C12","v":"12"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C20,debit_chain,0),3),\"\")","v":"-"},null,null,2,{"$f":"H12","v":"12"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H20,debit_chain,0),3),\"\")","v":"-"}]
[null,3,{"$f":"C13","v":"13"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C21,debit_chain,0),3),\"\")","v":""},null,null,3,{"$f":"H13","v":"13"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H21,debit_chain,0),3),\"\")","v":""}]
[null,4,{"$f":"C14","v":"14"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C22,debit_chain,0),3),\"\")","v":""},null,null,4,{"$f":"H14","v":"14"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H22,debit_chain,0),3),\"\")","v":""}]
[null,5,{"$f":"C15","v":"15"},{"$f":"IFERROR(INDEX(debit_all_items,MATCH(C23,debit_chain,0),3),\"\")","v":""},null,null,5,{"$f":"H15","v":"15"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(H23,debit_chain,0),3),\"\")","v":""}]
[]
[null,"摘要"]
[null,1,{"$f":"slip_no&B26","v":"11"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C26,debit_chain,0),5),\"\")","v":"9/13 3/15~9/12までの預金利息　税引き後利息　0041647、特別会計へ算入"},null,null,null,null,null,{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C26,debit_chain,0),6),\"\")","v":0}]
[null,2,{"$f":"slip_no&B27","v":"12"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C27,debit_chain,0),5),\"\")","v":"一旦、A準備金で受け入れ"},null,null,null,null,null,{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C27,debit_chain,0),6),\"\")","v":0}]
[null,3,{"$f":"slip_no&B28","v":"13"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C28,debit_chain,0),5),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C28,debit_chain,0),6),\"\")","v":""}]
[null,4,{"$f":"slip_no&B29","v":"14"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C29,debit_chain,0),5),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C29,debit_chain,0),6),\"\")","v":""}]
[null,5,{"$f":"slip_no&B30","v":"15"},{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C30,debit_chain,0),5),\"\")","v":""},null,null,null,null,null,{"$f":"IFERROR(INDEX(credit_all_items,MATCH(C30,debit_chain,0),6),\"\")","v":""}]
[]
[null,"説明/備考"]

{"sheet":"出納簿","index":3,"n_rows":54,"n_cols":55,"rows_kept":54,"cut":false,"hidden":false,"merged":[[0,42,0,46],[2,18,6,18],[2,19,6,19],[2,20,6,20],[2,24,6,24],[2,25,6,25],[1,30,6,30],[2,26,6,26],[2,27,6,27],[2,28,6,28],[2,23,6,23],[0,16,0,29],[4,42,4,46],[3,38,6,38],[3,39,6,39],[4,47,4,52],[4,0,6,0],[4,3,4,7],[4,8,4,13],[2,29,6,29],[2,16,6,16],[2,17,6,17],[2,21,6,21],[2,22,6,22]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"解説↗",null,null,"コントロールデータ",null,null,null,null,null,null,null,null,null,null,null,null,null,"合計金額表示方法判定フラグ",2,null,"借方対象期間合計金額","借方対象科目合計金額","貸方対象期間合計金額","貸方対象科目合計金額","伝票削除フラグ"]
[{"$f":"説明!C24","v":"A自治会_特別会計"},null,null,null,"出納簿兼仕訳帳",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"選択2 選択3-1",null,null,null,"選択3-2 選択5",null,null,"選択4",null,"選択1",null,"合計判定フラグに対応する合計額の結果","伝票データ入力",1,0,0,0,0,null,"削除開始日","削除終了日",{"$f":"説明!C24","v":"A自治会_特別会計"},null,null,null,"出納簿　兼　総勘定元帳",null,{"$f":"B3","v":2021},"年度",null,null,null,null,null,{"$f":"TODAY()","v":"2022-03-10"}]
[null,{"$f":"説明!D26","v":2021},"年度",null,"期間","2021-04-01",null,"2022-03-31",null,null,null,null,null,null,null,null,"借方チェーン番号","貸方チェーン番号","印刷行の指定\nA+B+C+D","対象期間全科目 A","借方と貸方が同じ B","科目が借方科目に一致、但し科目が空欄の場合はN  C","科目が貸方科目に一致,但し科目が空欄の場合はN  D","対象科目が借方または貸方に一致","対象期間対象科目借方金額合計","対象期間対象科目貸方金額合計","a 処理日が範囲内はA、範囲外はB、未入力はC","b 伝票Noが最大の行に1マークが入る。","aがAかつbが1の場合はY、そうでない場合でaがCならY、違う場合N","借方科目または貸方科目が空欄",null,"対象期間全科目",2,{"$f":"SUMIF(print_judge_date,\"=Y\",debit_sum_2)","v":16520054},0,{"$f":"SUMIF(print_judge_date,\"=Y\",credit_sum_2)","v":16520054},0,null,{"$f":"IF(説明!C16=\"\",\"\",説明!C16)","v":""},{"$f":"IF(説明!D16=\"\",\"\",説明!D16)","v":""},null,null,"対象期間",null,{"$f":"IF(from_date_2<>\"\",from_date_2,\"\")","v":"2021-04-01"},"〜",{"$f":"IF(to_date_2<>\"\",to_date_2,\"\")","v":"2022-03-31"}]
[null,null,null,"科目G",null,{"$f":"IFERROR(VLOOKUP(H4,g_kamoku,2,FALSE),\"\")","v":""},"科目",null,null,null,null,null,"借方-貸方=",{"$f":"G7-M7","v":0},"円",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"対象期間対象科目",3,0,{"$f":"SUMIFS(debit_sum_2,print_judge_date,\"Y\",debit_select,\"Y\")","v":0},0,{"$f":"SUMIFS(credit_sum_2,print_judge_date,\"Y\",credit_select,\"Y\")","v":0},null,null,null,null,null,null,"科目G",{"$f":"list_kamoku_2","v":""},"科目",{"$f":"H4","v":0},null,null,null,null,"借方-貸方=",{"$f":"N4","v":0},"円"]
["使用可",null,null,"借方",null,null,null,null,"貸方",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"全期間全科目",4,{"$f":"SUMIF(process_date,\"=Y\",debit_sum_2)","v":0},0,{"$f":"SUMIF(process_date,\"=Y\",credit_sum_2)","v":0},0,null,null,null,null,null,"借　方",null,null,null,null,"貸　方"]
[null,null,null,null,null,"期間合計金額",{"$f":"IFERROR(VLOOKUP(total_judge,sum_judge_table,2,FALSE),\"\")","v":16520054},"円",null,null,"期間合計金額",null,{"$f":"IFERROR(VLOOKUP(total_judge,sum_judge_table,4,FALSE),\"\")","v":16520054},"円",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"全期間対象科目",5,{"$f":"SUMIF(process_date,\"=Y\",debit_sum_2)","v":0},{"$f":"SUMIF(debit_select,\"=Y\",debit_sum_2)","v":0},{"$f":"SUMIF(process_date,\"=Y\",credit_sum_2)","v":0},{"$f":"SUMIF(credit_select,\"=Y\",credit_sum_2)","v":0},null,null,null,null,null,null,null,"期間合計金額",{"$f":"G6","v":16520054},"円",null,null,null,"期間合計金額",{"$f":"M6","v":16520054},"円"]
[null,null,null,null,null,"科目合計金額",{"$f":"IFERROR(VLOOKUP(total_judge,sum_judge_table,3,FALSE),\"\")","v":0},"円",null,null,"科目合計金額",null,{"$f":"IFERROR(VLOOKUP(total_judge,sum_judge_table,5,FALSE),\"\")","v":0},"円",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,"科目合計金額",{"$f":"G7","v":0},"円",null,null,null,"科目合計金額",{"$f":"M7","v":0},"円",null,"（複）複式 (連）連記式"]
[null,"計上日","伝No","行No","科目G","科目名（選択）","細分類（選択）","金額(円)","伝No","行No","科目G","科目名（選択）","細分類（選択）","金額(円)","摘要","補足","&","&",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"計上日","伝票No.","行番","科目G","科目名","細分類","金額","伝票No.","行番","科目G","科目名","細分類","金額","摘要","補足"]
[{"$f":"IF(AND(_xlfn.ISFORMULA(K9),_xlfn.ISFORMULA(E9),_xlfn.ISFORMULA(I9:J9),_xlfn.ISFORMULA(Q9:AD9),_xlfn.ISFORMULA(AL9),_xlfn.ISFORMULA(AO9:BC9)),\"可\",\"不可\")","v":"可"},"2021-10-05",1,1,{"$f":"IFERROR(VLOOKUP(F9,g_kamoku,2,FALSE),\"\")","v":"特会資産"},"普通預金(準備金移動前）","-",27,{"$f":"C9","v":1},{"$f":"D9","v":1},{"$f":"IFERROR(VLOOKUP(L9,g_kamoku,2,FALSE),\"\")","v":"特会収入"},"その他収入    ","普通預金利子",27,"9/13 3/15~9/12までの預金利息　税引き後利息　0041647、特別会計へ算入",null,{"$f":"C9&D9","v":"11"},{"$f":"I9&J9","v":"11"},{"$f":"T9&U9&V9&W9","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B9,to_date_2>=B9),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F9=L9,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F9=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L9=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V9=\"Y\",W9=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X9=\"Y\",V9=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X9=\"Y\",W9=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B9>=start_date,B9<=end_date),\"A\",IF(B9=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C9,0),\"\")","v":""},{"$f":"IF(AND(AA9=\"A\",AB9<>\"\"),\"Y\",IF(AA9=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F9=\"\",L9=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,{"$f":"IF(OR(delete_start_date=\"\",delete_end_date=\"\"),\"\",IF(AND(B9>=delete_start_date,B9<=delete_end_date),\"1\",\"\"))","v":""},null,null,{"$f":"B9","v":"2021-10-05"},{"$f":"C9","v":1},{"$f":"D9","v":1},{"$f":"E9","v":"特会資産"},{"$f":"F9","v":"普通預金(準備金移動前）"},{"$f":"G9","v":"-"},{"$f":"H9","v":27},{"$f":"I9","v":1},{"$f":"J9","v":1},{"$f":"K9","v":"特会収入"},{"$f":"L9","v":"その他収入    "},{"$f":"M9","v":"普通預金利子"},{"$f":"N9","v":27},{"$f":"O9","v":"9/13 3/15~9/12までの預金利息　税引き後利息　0041647、特別会計へ算入"},{"$f":"P9","v":0}]
["可","2021-10-05",1,2,"特会資産","A準備金","-",27,1,2,"特会資産","普通預金(準備金移動前）","-",27,"一旦、A準備金で受け入れ",null,{"$f":"C10&D10","v":"12"},{"$f":"I10&J10","v":"12"},{"$f":"T10&U10&V10&W10","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B10,to_date_2>=B10),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F10=L10,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F10=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L10=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V10=\"Y\",W10=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X10=\"Y\",V10=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X10=\"Y\",W10=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B10>=start_date,B10<=end_date),\"A\",IF(B10=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C10,0),\"\")","v":""},{"$f":"IF(AND(AA10=\"A\",AB10<>\"\"),\"Y\",IF(AA10=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F10=\"\",L10=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B10","v":"2021-10-05"},{"$f":"C10","v":1},{"$f":"D10","v":2},{"$f":"E10","v":"特会資産"},{"$f":"F10","v":"A準備金"},{"$f":"G10","v":"-"},{"$f":"H10","v":27},{"$f":"I10","v":1},{"$f":"J10","v":2},{"$f":"K10","v":"特会資産"},{"$f":"L10","v":"普通預金(準備金移動前）"},{"$f":"M10","v":"-"},{"$f":"N10","v":27},{"$f":"O10","v":"一旦、A準備金で受け入れ"},{"$f":"P10","v":0}]
["可","2021-11-01",2,1,"特会費用","減価償却費","建物",560000,2,1,"特会資産","固定資産","建物",560000,"40,000,000円　法定47年　均等償却　月70,000円　4~11月　8カ月*70,000=560,000円",null,{"$f":"C11&D11","v":"21"},{"$f":"I11&J11","v":"21"},{"$f":"T11&U11&V11&W11","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B11,to_date_2>=B11),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F11=L11,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F11=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L11=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V11=\"Y\",W11=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X11=\"Y\",V11=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X11=\"Y\",W11=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B11>=start_date,B11<=end_date),\"A\",IF(B11=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C11,0),\"\")","v":""},{"$f":"IF(AND(AA11=\"A\",AB11<>\"\"),\"Y\",IF(AA11=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F11=\"\",L11=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B11","v":"2021-11-01"},{"$f":"C11","v":2},{"$f":"D11","v":1},{"$f":"E11","v":"特会費用"},{"$f":"F11","v":"減価償却費"},{"$f":"G11","v":"建物"},{"$f":"H11","v":560000},{"$f":"I11","v":2},{"$f":"J11","v":1},{"$f":"K11","v":"特会資産"},{"$f":"L11","v":"固定資産"},{"$f":"M11","v":"建物"},{"$f":"N11","v":560000},{"$f":"O11","v":"40,000,000円　法定47年　均等償却　月70,000円　4~11月　8カ月*70,000=560,000円"},{"$f":"P11","v":0}]
["可","2021-11-30",3,1,"特会資産","普通預金(準備金移動前）","-",2000000,3,1,"特会収入","自治会一般会計","-",2000000,"2020年度一般会計剰余金の特別会計への繰入れ",null,{"$f":"C12&D12","v":"31"},{"$f":"I12&J12","v":"31"},{"$f":"T12&U12&V12&W12","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B12,to_date_2>=B12),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F12=L12,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F12=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L12=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V12=\"Y\",W12=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X12=\"Y\",V12=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X12=\"Y\",W12=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B12>=start_date,B12<=end_date),\"A\",IF(B12=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C12,0),\"\")","v":""},{"$f":"IF(AND(AA12=\"A\",AB12<>\"\"),\"Y\",IF(AA12=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F12=\"\",L12=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B12","v":"2021-11-30"},{"$f":"C12","v":3},{"$f":"D12","v":1},{"$f":"E12","v":"特会資産"},{"$f":"F12","v":"普通預金(準備金移動前）"},{"$f":"G12","v":"-"},{"$f":"H12","v":2000000},{"$f":"I12","v":3},{"$f":"J12","v":1},{"$f":"K12","v":"特会収入"},{"$f":"L12","v":"自治会一般会計"},{"$f":"M12","v":"-"},{"$f":"N12","v":2000000},{"$f":"O12","v":"2020年度一般会計剰余金の特別会計への繰入れ"},{"$f":"P12","v":0}]
["可","2021-11-30",3,2,"特会資産","A準備金","-",2000000,3,2,"特会資産","普通預金(準備金移動前）","-",2000000,"一旦、公民館補修工事等準備金で受け入れ",null,{"$f":"C13&D13","v":"32"},{"$f":"I13&J13","v":"32"},{"$f":"T13&U13&V13&W13","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B13,to_date_2>=B13),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F13=L13,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F13=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L13=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V13=\"Y\",W13=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X13=\"Y\",V13=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X13=\"Y\",W13=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B13>=start_date,B13<=end_date),\"A\",IF(B13=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C13,0),\"\")","v":""},{"$f":"IF(AND(AA13=\"A\",AB13<>\"\"),\"Y\",IF(AA13=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F13=\"\",L13=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B13","v":"2021-11-30"},{"$f":"C13","v":3},{"$f":"D13","v":2},{"$f":"E13","v":"特会資産"},{"$f":"F13","v":"A準備金"},{"$f":"G13","v":"-"},{"$f":"H13","v":2000000},{"$f":"I13","v":3},{"$f":"J13","v":2},{"$f":"K13","v":"特会資産"},{"$f":"L13","v":"普通預金(準備金移動前）"},{"$f":"M13","v":"-"},{"$f":"N13","v":2000000},{"$f":"O13","v":"一旦、公民館補修工事等準備金で受け入れ"},{"$f":"P13","v":0}]
["可","2021-12-01",4,1,"特会資産","B準備金","-",7200000,4,1,"","公民館補修準備金","-",7200000,"公民館建築準備金へ組替え　2021年度末の初期設定額",null,{"$f":"C14&D14","v":"41"},{"$f":"I14&J14","v":"41"},{"$f":"T14&U14&V14&W14","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B14,to_date_2>=B14),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F14=L14,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F14=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L14=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V14=\"Y\",W14=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X14=\"Y\",V14=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X14=\"Y\",W14=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B14>=start_date,B14<=end_date),\"A\",IF(B14=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C14,0),\"\")","v":""},{"$f":"IF(AND(AA14=\"A\",AB14<>\"\"),\"Y\",IF(AA14=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F14=\"\",L14=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B14","v":"2021-12-01"},{"$f":"C14","v":4},{"$f":"D14","v":1},{"$f":"E14","v":"特会資産"},{"$f":"F14","v":"B準備金"},{"$f":"G14","v":"-"},{"$f":"H14","v":7200000},{"$f":"I14","v":4},{"$f":"J14","v":1},{"$f":"K14","v":""},{"$f":"L14","v":"公民館補修準備金"},{"$f":"M14","v":"-"},{"$f":"N14","v":7200000},{"$f":"O14","v":"公民館建築準備金へ組替え　2021年度末の初期設定額"},{"$f":"P14","v":0}]
["可","2021-12-31",5,1,"特会費用","修繕費","建物",600000,5,1,"","公民館補修準備金","-",600000,"（見込み）　公民館屋根天井補修工事",null,{"$f":"C15&D15","v":"51"},{"$f":"I15&J15","v":"51"},{"$f":"T15&U15&V15&W15","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B15,to_date_2>=B15),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F15=L15,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F15=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L15=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V15=\"Y\",W15=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X15=\"Y\",V15=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X15=\"Y\",W15=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B15>=start_date,B15<=end_date),\"A\",IF(B15=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C15,0),\"\")","v":""},{"$f":"IF(AND(AA15=\"A\",AB15<>\"\"),\"Y\",IF(AA15=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F15=\"\",L15=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B15","v":"2021-12-31"},{"$f":"C15","v":5},{"$f":"D15","v":1},{"$f":"E15","v":"特会費用"},{"$f":"F15","v":"修繕費"},{"$f":"G15","v":"建物"},{"$f":"H15","v":600000},{"$f":"I15","v":5},{"$f":"J15","v":1},{"$f":"K15","v":""},{"$f":"L15","v":"公民館補修準備金"},{"$f":"M15","v":"-"},{"$f":"N15","v":600000},{"$f":"O15","v":"（見込み）　公民館屋根天井補修工事"},{"$f":"P15","v":0}]
["可","2022-02-28",6,1,"特会費用","その他費用1","AAA負担金",600000,6,1,"","生活支援等準備金","-",600000,"(見込み）AAA負担金",null,{"$f":"C16&D16","v":"61"},{"$f":"I16&J16","v":"61"},{"$f":"T16&U16&V16&W16","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B16,to_date_2>=B16),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F16=L16,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F16=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L16=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V16=\"Y\",W16=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X16=\"Y\",V16=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X16=\"Y\",W16=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B16>=start_date,B16<=end_date),\"A\",IF(B16=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C16,0),\"\")","v":""},{"$f":"IF(AND(AA16=\"A\",AB16<>\"\"),\"Y\",IF(AA16=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F16=\"\",L16=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B16","v":"2022-02-28"},{"$f":"C16","v":6},{"$f":"D16","v":1},{"$f":"E16","v":"特会費用"},{"$f":"F16","v":"その他費用1"},{"$f":"G16","v":"AAA負担金"},{"$f":"H16","v":600000},{"$f":"I16","v":6},{"$f":"J16","v":1},{"$f":"K16","v":""},{"$f":"L16","v":"生活支援等準備金"},{"$f":"M16","v":"-"},{"$f":"N16","v":600000},{"$f":"O16","v":"(見込み）AAA負担金"},{"$f":"P16","v":0}]
["可","2022-03-01",7,1,"特会費用","減価償却費","建物減価償却費",560000,7,1,"特会資産","固定資産","建物",560000,"12~3月　建物減価償却費 月140,000円 x 4カ月",null,{"$f":"C17&D17","v":"71"},{"$f":"I17&J17","v":"71"},{"$f":"T17&U17&V17&W17","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B17,to_date_2>=B17),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F17=L17,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F17=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L17=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V17=\"Y\",W17=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X17=\"Y\",V17=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X17=\"Y\",W17=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B17>=start_date,B17<=end_date),\"A\",IF(B17=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C17,0),\"\")","v":""},{"$f":"IF(AND(AA17=\"A\",AB17<>\"\"),\"Y\",IF(AA17=\"C\",\"Y\",\"N\"))","v":"N"},{"$f":"IF(OR(F17=\"\",L17=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B17","v":"2022-03-01"},{"$f":"C17","v":7},{"$f":"D17","v":1},{"$f":"E17","v":"特会費用"},{"$f":"F17","v":"減価償却費"},{"$f":"G17","v":"建物減価償却費"},{"$f":"H17","v":560000},{"$f":"I17","v":7},{"$f":"J17","v":1},{"$f":"K17","v":"特会資産"},{"$f":"L17","v":"固定資産"},{"$f":"M17","v":"建物"},{"$f":"N17","v":560000},{"$f":"O17","v":"12~3月　建物減価償却費 月140,000円 x 4カ月"},{"$f":"P17","v":0}]
["可","2022-03-31",8,1,"特会資産","普通預金(準備金移動前）","-",1500000,8,1,"特会収入","自治会一般会計","-",1500000,"(見込み）2021年度　一般会計よりの剰余金",null,{"$f":"C18&D18","v":"81"},{"$f":"I18&J18","v":"81"},{"$f":"T18&U18&V18&W18","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B18,to_date_2>=B18),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F18=L18,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F18=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L18=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V18=\"Y\",W18=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X18=\"Y\",V18=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X18=\"Y\",W18=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B18>=start_date,B18<=end_date),\"A\",IF(B18=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C18,0),\"\")","v":1},{"$f":"IF(AND(AA18=\"A\",AB18<>\"\"),\"Y\",IF(AA18=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F18=\"\",L18=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B18","v":"2022-03-31"},{"$f":"C18","v":8},{"$f":"D18","v":1},{"$f":"E18","v":"特会資産"},{"$f":"F18","v":"普通預金(準備金移動前）"},{"$f":"G18","v":"-"},{"$f":"H18","v":1500000},{"$f":"I18","v":8},{"$f":"J18","v":1},{"$f":"K18","v":"特会収入"},{"$f":"L18","v":"自治会一般会計"},{"$f":"M18","v":"-"},{"$f":"N18","v":1500000},{"$f":"O18","v":"(見込み）2021年度　一般会計よりの剰余金"},{"$f":"P18","v":0}]
["可","2022-03-31",8,2,"特会資産","A準備金","-",200000,8,2,"特会資産","普通預金(準備金移動前）","-",200000,"(見込み）2021年度　A準備金　追加",null,{"$f":"C19&D19","v":"82"},{"$f":"I19&J19","v":"82"},{"$f":"T19&U19&V19&W19","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B19,to_date_2>=B19),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F19=L19,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F19=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L19=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V19=\"Y\",W19=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X19=\"Y\",V19=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X19=\"Y\",W19=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B19>=start_date,B19<=end_date),\"A\",IF(B19=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C19,0),\"\")","v":1},{"$f":"IF(AND(AA19=\"A\",AB19<>\"\"),\"Y\",IF(AA19=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F19=\"\",L19=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B19","v":"2022-03-31"},{"$f":"C19","v":8},{"$f":"D19","v":2},{"$f":"E19","v":"特会資産"},{"$f":"F19","v":"A準備金"},{"$f":"G19","v":"-"},{"$f":"H19","v":200000},{"$f":"I19","v":8},{"$f":"J19","v":2},{"$f":"K19","v":"特会資産"},{"$f":"L19","v":"普通預金(準備金移動前）"},{"$f":"M19","v":"-"},{"$f":"N19","v":200000},{"$f":"O19","v":"(見込み）2021年度　A準備金　追加"},{"$f":"P19","v":0}]
["可","2022-03-31",8,3,"特会資産","C準備金","-",1300000,8,3,"特会資産","普通預金(準備金移動前）","-",1300000,"(見込み）2021年度　C準備金　追加",null,{"$f":"C20&D20","v":"83"},{"$f":"I20&J20","v":"83"},{"$f":"T20&U20&V20&W20","v":"YNNN"},{"$f":"IF(AND(from_date_2<=B20,to_date_2>=B20),\"Y\",\"N\")","v":"Y"},{"$f":"IF(F20=L20,\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",F20=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L20=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V20=\"Y\",W20=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X20=\"Y\",V20=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X20=\"Y\",W20=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B20>=start_date,B20<=end_date),\"A\",IF(B20=\"\",\"C\",\"B\"))","v":"A"},{"$f":"IFERROR(MATCH(MAX(slip),C20,0),\"\")","v":1},{"$f":"IF(AND(AA20=\"A\",AB20<>\"\"),\"Y\",IF(AA20=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F20=\"\",L20=\"\"),\"Y\",\"N\")","v":"N"},null,null,null,null,null,null,null,"",null,null,{"$f":"B20","v":"2022-03-31"},{"$f":"C20","v":8},{"$f":"D20","v":3},{"$f":"E20","v":"特会資産"},{"$f":"F20","v":"C準備金"},{"$f":"G20","v":"-"},{"$f":"H20","v":1300000},{"$f":"I20","v":8},{"$f":"J20","v":3},{"$f":"K20","v":"特会資産"},{"$f":"L20","v":"普通預金(準備金移動前）"},{"$f":"M20","v":"-"},{"$f":"N20","v":1300000},{"$f":"O20","v":"(見込み）2021年度　C準備金　追加"},{"$f":"P20","v":0}]
["可",null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,{"$f":"C21&D21","v":""},{"$f":"I21&J21","v":"00"},{"$f":"T21&U21&V21&W21","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B21,to_date_2>=B21),\"Y\",\"N\")","v":"N"},{"$f":"IF(F21=L21,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(kamoku_name<>\"\",F21=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L21=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V21=\"Y\",W21=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X21=\"Y\",V21=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X21=\"Y\",W21=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B21>=start_date,B21<=end_date),\"A\",IF(B21=\"\",\"C\",\"B\"))","v":"C"},{"$f":"IFERROR(MATCH(MAX(slip),C21,0),\"\")","v":""},{"$f":"IF(AND(AA21=\"A\",AB21<>\"\"),\"Y\",IF(AA21=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F21=\"\",L21=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,{"$f":"B21","v":"00:00:00"},{"$f":"C21","v":0},{"$f":"D21","v":0},{"$f":"E21","v":""},{"$f":"F21","v":0},{"$f":"G21","v":0},{"$f":"H21","v":0},{"$f":"I21","v":0},{"$f":"J21","v":0},{"$f":"K21","v":""},{"$f":"L21","v":0},{"$f":"M21","v":0},{"$f":"N21","v":0},{"$f":"O21","v":0},{"$f":"P21","v":0}]
[{"$f":"IF(AND(_xlfn.ISFORMULA(K22),_xlfn.ISFORMULA(E22),_xlfn.ISFORMULA(Q22:AD22),_xlfn.ISFORMULA(AL22),_xlfn.ISFORMULA(AO22:BC22)),\"可\",\"不可\")","v":"可"},null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,{"$f":"C22&D22","v":""},{"$f":"I22&J22","v":"00"},{"$f":"T22&U22&V22&W22","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B22,to_date_2>=B22),\"Y\",\"N\")","v":"N"},{"$f":"IF(F22=L22,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(kamoku_name<>\"\",F22=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(kamoku_name<>\"\",L22=kamoku_name),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V22=\"Y\",W22=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X22=\"Y\",V22=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X22=\"Y\",W22=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(B22>=start_date,B22<=end_date),\"A\",IF(B22=\"\",\"C\",\"B\"))","v":"C"},{"$f":"IFERROR(MATCH(MAX(slip),C22,0),\"\")","v":""},{"$f":"IF(AND(AA22=\"A\",AB22<>\"\"),\"Y\",IF(AA22=\"C\",\"Y\",\"N\"))","v":"Y"},{"$f":"IF(OR(F22=\"\",L22=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,{"$f":"B22","v":"00:00:00"},{"$f":"C22","v":0},{"$f":"D22","v":0},{"$f":"E22","v":""},{"$f":"F22","v":0},{"$f":"G22","v":0},{"$f":"H22","v":0},{"$f":"I22","v":0},{"$f":"J22","v":0},{"$f":"K22","v":""},{"$f":"L22","v":0},{"$f":"M22","v":0},{"$f":"N22","v":0},{"$f":"O22","v":0},{"$f":"P22","v":0}]
["可",null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,"","00","NYNN","N","Y","N","N","N","N","N",{"$f":"IF(ISBLANK(B23),\"N\",\"Y\")","v":"N"},"",{"$f":"IF(OR(AA23=\"N\",AB23<>\"\"),\"Y\",\"N\")","v":"Y"},"Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",0,0,0,0,0]
["可",null,null,null,{"$f":"IFERROR(VLOOKUP(F24,g_kamoku,2,FALSE),\"\")","v":""},null,null,null,0,0,{"$f":"IFERROR(VLOOKUP(L24,g_kamoku,2,FALSE),\"\")","v":""},null,null,null,null,null,"","00","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",0,0,0,0,0]
["可",null,null,null,"",null,null,null,0,0,"",null,null,null,null,null,"","00","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",0,0,0,0,0]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","",{"$f":"T26&U26&V26&W26","v":"NYNN"},{"$f":"IF(AND(from_date_2<=B26,to_date_2>=B26),\"Y\",\"N\")","v":"N"},{"$f":"IF(E26=K26,\"Y\",\"N\")","v":"Y"},{"$f":"IF(AND(list_kamoku_2<>\"\",E26=list_kamoku_2),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(list_kamoku_2<>\"\",K26=list_kamoku_2),\"Y\",\"N\")","v":"N"},{"$f":"IF(OR(V26=\"Y\",W26=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X26=\"Y\",V26=\"Y\"),\"Y\",\"N\")","v":"N"},{"$f":"IF(AND(X26=\"Y\",W26=\"Y\"),\"Y\",\"N\")","v":"N"},"N",{"$f":"IFERROR(MATCH(MAX(slip),C26,0),\"\")","v":""},"Y",{"$f":"IF(OR(F26=\"\",L26=\"\"),\"Y\",\"N\")","v":"Y"},null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",0,0,0,0,0]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",0,0,0,0,0]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",0,0,0,0,0]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",0,0,0,0,0]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",0,0,0,0,0]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",0,0,0,0,0]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",0,0,0,0,0]
["可",null,null,null,"",null,null,null,null,null,"",null,null,null,null,null,"","","NYNN","N","Y","N","N","N","N","N","N","","Y","Y",null,null,null,null,null,null,null,"",null,null,"00:00:00",0,0,"",0,0,0,0,0,"",{"$f":"L33","v":0},{"$f":"M33","v":0},{"$f":"N33","v":0},0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B34","v":"00:00:00"},{"$f":"IF(V34=\"Y\",C34,\"\")","v":""},{"$f":"IF(V34=\"Y\",D34,\"\")","v":""},{"$f":"IF(V34=\"Y\",E34,\"\")","v":""},{"$f":"IF(V34=\"Y\",F34,\"\")","v":""},{"$f":"IF(V34=\"Y\",G34,\"\")","v":""},{"$f":"IF(V34=\"Y\",H34,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"00:00:00","","","","","",""]

{"sheet":"期間別試算表","index":4,"n_rows":88,"n_cols":65,"rows_kept":88,"cut":false,"hidden":false,"merged":[[0,0,0,4],[28,19,28,20],[28,21,28,22],[28,23,28,24],[28,25,28,26],[28,27,28,28],[28,29,28,30],[3,25,3,26],[3,29,3,30],[4,15,4,16],[4,17,4,18],[4,19,4,20],[4,21,4,22],[4,23,4,24],[4,25,4,26],[4,27,4,28],[4,29,4,30],[3,17,3,18],[3,21,3,22],[4,11,4,12],[4,13,4,14],[2,7,2,8],[2,9,2,10],[3,9,3,10],[71,3,71,4],[75,3,75,4],[3,33,3,34],[4,31,4,32],[4,33,4,34],[23,3,23,4],[26,2,26,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[6,3,6,4],[7,3,7,4],[16,3,16,4],[25,3,25,4],[24,3,24,4],[17,2,17,4],[3,5,3,6],[4,5,4,6],[4,2,5,4],[22,3,22,4],[11,3,11,4],[12,3,12,4],[14,3,14,4],[15,3,15,4],[3,2,3,3],[1,2,1,4],[2,2,2,4],[6,2,13,2],[13,3,13,4],[14,2,16,2],[20,3,20,4],[18,2,20,2],[21,2,25,2],[18,3,18,4],[19,3,19,4],[4,7,4,8],[4,9,4,10],[31,3,31,4],[39,3,39,4],[47,3,47,4],[51,3,51,4],[21,3,21,4],[55,3,55,4],[63,3,63,4],[3,53,3,54],[4,51,4,52],[4,53,4,54],[3,45,3,46],[4,43,4,44],[4,45,4,46],[3,49,3,50],[4,47,4,48],[4,49,4,50],[3,41,3,42],[4,39,4,40],[4,41,4,42],[3,37,3,38],[4,35,4,36],[4,37,4,38],[2,11,2,12],[2,13,2,14],[28,37,28,38],[3,13,3,14],[28,39,28,40],[28,41,28,42],[28,43,28,44],[28,45,28,46],[28,47,28,48],[83,3,83,4],[87,3,87,4],[28,5,28,6],[28,7,28,8],[28,9,28,10],[28,11,28,12],[28,13,28,14],[28,15,28,16],[28,17,28,18],[29,5,29,6],[29,7,29,8],[29,9,29,10],[29,11,29,12],[29,13,29,14],[29,15,29,16],[29,17,29,18],[35,3,35,4],[43,3,43,4],[59,3,59,4],[79,3,79,4],[67,3,67,4],[28,49,28,50],[28,51,28,52],[28,53,28,54],[29,19,29,20],[29,21,29,22],[29,23,29,24],[29,25,29,26],[29,27,29,28],[29,29,29,30],[29,31,29,32],[29,33,29,34],[29,35,29,36],[29,37,29,38],[29,39,29,40],[29,41,29,42],[29,43,29,44],[29,45,29,46],[29,47,29,48],[29,49,29,50],[29,51,29,52],[29,53,29,54],[28,31,28,32],[28,33,28,34],[28,35,28,36]]}
["計算期間は「説明」シートへ登録ください。\n"]
[null,null,{"$f":"説明!C24","v":"A自治会_特別会計"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"BE4","v":2021},"年度","予実績比較表"]
[null,null,"試算表",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"単位：円"]
[null,null,{"$f":"説明!D26","v":2021},null,"年度",{"$f":"説明!E29","v":"2021-03-31"},null,{"$f":"IF(説明!D30=\"\",\"\",説明!D30)","v":"2021-04-01"},"～",{"$f":"説明!E30","v":"2022-03-31"},null,{"$f":"IF(説明!D31=\"\",\"\",説明!D31)","v":""},"～",{"$f":"IF(説明!E31=\"\",\"\",説明!E31)","v":""},null,{"$f":"IF(説明!D32=\"\",\"\",説明!D32)","v":""},"～",{"$f":"IF(説明!E32=\"\",\"\",説明!E32)","v":""},null,{"$f":"IF(説明!D33=\"\",\"\",説明!D33)","v":""},"～",{"$f":"IF(説明!E33=\"\",\"\",説明!E33)","v":""},null,{"$f":"IF(説明!D34=\"\",\"\",説明!D34)","v":""},"～",{"$f":"IF(説明!E34=\"\",\"\",説明!E34)","v":""},null,{"$f":"IF(説明!D35=\"\",\"\",説明!D35)","v":""},"～",{"$f":"IF(説明!E35=\"\",\"\",説明!E35)","v":""},null,{"$f":"IF(説明!D36=\"\",\"\",説明!D36)","v":""},"～",{"$f":"IF(説明!E36=\"\",\"\",説明!E36)","v":""},null,{"$f":"IF(説明!D37=\"\",\"\",説明!D37)","v":""},"～",{"$f":"IF(説明!E37=\"\",\"\",説明!E37)","v":""},null,{"$f":"IF(説明!D38=\"\",\"\",説明!D38)","v":""},"～",{"$f":"IF(説明!E38=\"\",\"\",説明!E38)","v":""},null,{"$f":"IF(説明!D39=\"\",\"\",説明!D39)","v":""},"～",{"$f":"IF(説明!E39=\"\",\"\",説明!E39)","v":""},null,{"$f":"IF(説明!D40=\"\",\"\",説明!D40)","v":""},"～",{"$f":"IF(説明!E40=\"\",\"\",説明!E40)","v":""},null,{"$f":"IF(説明!D41=\"\",\"\",説明!D41)","v":""},"～",{"$f":"IF(説明!E41=\"\",\"\",説明!E41)","v":""},null,null,{"$f":"説明!D26","v":2021},"年度予算",null,null,"2019実績","2020実績","年間予算<1>","累計実績<2>","差異<1>-<2>"]
[null,null,"単位：円",null,null,"繰越残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,null,null,null,null,"期首繰越現金",null,null,{"$f":"F7","v":0},{"$f":"F7","v":0},{"$f":"BK5-BL5","v":0}]
[null,null,null,null,null,"借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方",null,"借方","貸方",null,"期首繰越普通預金1",null,null,{"$f":"F8","v":0},{"$f":"F8","v":0},0]
[{"$f":"科目細分類表!E4","v":"特会資産"},null,"資産",{"$f":"科目細分類表!E5","v":"現金"},null,{"$f":"説明!D46","v":0},null,0,0,{"$f":"F7+H7-I7","v":0},null,null,null,{"$f":"J7+L7-M7","v":0},null,null,null,{"$f":"N7+P7-Q7","v":0},null,null,null,{"$f":"R7+T7-U7","v":0},null,null,null,{"$f":"V7+X7-Y7","v":0},null,null,null,{"$f":"Z7+AB7-AC7","v":0},null,null,null,{"$f":"AD7+AF7-AG7","v":0},null,null,null,{"$f":"AH7+AJ7-AK7","v":0},null,null,null,{"$f":"AL7+AN7-AO7","v":0},null,null,null,{"$f":"AP7+AR7-AS7","v":0},null,null,null,{"$f":"AT7+AV7-AW7","v":0},null,null,null,{"$f":"AX7+AZ7-BA7","v":0},null,null,{"$f":"説明!D46","v":0},null,null,"期末現金（繰越含む）",null,null,{"$f":"BE7","v":0},{"$f":"BB7","v":0},0]
[{"$f":"科目細分類表!F4","v":"特会資産"},null,null,{"$f":"科目細分類表!F5","v":"普通預金(準備金移動前）"},null,{"$f":"説明!D47","v":0},null,3425423,3425423,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,"期末普通預金（繰越含む）",null,null,{"$f":"BE8","v":0},{"$f":"BB8","v":0},0]
[{"$f":"科目細分類表!G4","v":"特会資産"},null,null,{"$f":"科目細分類表!G5","v":"A準備金"},null,{"$f":"説明!D48","v":6300000},null,2125423,7800000,625423,null,null,null,625423,null,null,null,625423,null,null,null,625423,null,null,null,625423,null,null,null,625423,null,null,null,625423,null,null,null,625423,null,null,null,625423,null,null,null,625423,null,null,null,625423,null,null,null,625423,null,null,null,null,null,{"$f":"D9","v":"A準備金"},null,null,{"$f":"BE9","v":0},{"$f":"BC9","v":0},0]
[{"$f":"科目細分類表!H4","v":"特会資産"},null,null,{"$f":"科目細分類表!H5","v":"B準備金"},null,{"$f":"説明!D49","v":0},null,7200000,0,7200000,null,null,null,7200000,null,null,null,7200000,null,null,null,7200000,null,null,null,7200000,null,null,null,7200000,null,null,null,7200000,null,null,null,7200000,null,null,null,7200000,null,null,null,7200000,null,null,null,7200000,null,null,null,7200000,null,null,null,null,null,"B準備金",null,null,{"$f":"BE10","v":0},{"$f":"BB10","v":7200000},-7200000]
[{"$f":"科目細分類表!I4","v":"特会資産"},null,null,{"$f":"科目細分類表!I5","v":"C準備金"},null,{"$f":"説明!D50","v":0},null,1300000,600000,700000,null,null,null,700000,null,null,null,700000,null,null,null,700000,null,null,null,700000,null,null,null,700000,null,null,null,700000,null,null,null,700000,null,null,null,700000,null,null,null,700000,null,null,null,700000,null,null,null,700000,null,null,null,null,null,"C準備金",null,null,{"$f":"BF11","v":0},{"$f":"BC11","v":0},0]
[{"$f":"科目細分類表!J4","v":"特会資産"},null,null,{"$f":"科目細分類表!J5","v":"固定資産"},null,{"$f":"説明!D51","v":61300000},null,0,1680000,59620000,null,null,null,59620000,null,null,null,59620000,null,null,null,59620000,null,null,null,59620000,null,null,null,59620000,null,null,null,59620000,null,null,null,59620000,null,null,null,59620000,null,null,null,59620000,null,null,null,59620000,null,null,null,59620000,null,null,null,null,null,"固定資産",null,null,{"$f":"BE12","v":0},{"$f":"BC12","v":0},0]
[{"$f":"科目細分類表!K4","v":"特会資産"},null,null,{"$f":"科目細分類表!K5","v":"その他資産"},null,{"$f":"説明!D52","v":0},null,0,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,{"$f":"D13","v":"その他資産"},null,null,{"$f":"BF13","v":0},{"$f":"BC13","v":0},0]
[null,null,null,"資産計",null,{"$f":"SUM(F7:F13)","v":67600000},null,{"$f":"SUM(H7:H13)","v":14050846},{"$f":"SUM(I7:I13)","v":13505423},{"$f":"SUM(J7:J13)","v":68145423},null,{"$f":"SUM(L7:L13)","v":0},{"$f":"SUM(M7:M13)","v":0},{"$f":"SUM(N7:N13)","v":68145423},null,{"$f":"SUM(P7:P13)","v":0},{"$f":"SUM(Q7:Q13)","v":0},{"$f":"SUM(R7:R13)","v":68145423},null,{"$f":"SUM(T7:T13)","v":0},{"$f":"SUM(U7:U13)","v":0},{"$f":"SUM(V7:V13)","v":68145423},null,{"$f":"SUM(X7:X13)","v":0},{"$f":"SUM(Y7:Y13)","v":0},{"$f":"SUM(Z7:Z13)","v":68145423},null,{"$f":"SUM(AB7:AB13)","v":0},{"$f":"SUM(AC7:AC13)","v":0},{"$f":"SUM(AD7:AD13)","v":68145423},null,{"$f":"SUM(AF7:AF13)","v":0},{"$f":"SUM(AG7:AG13)","v":0},{"$f":"SUM(AH7:AH13)","v":68145423},null,{"$f":"SUM(AJ7:AJ13)","v":0},{"$f":"SUM(AK7:AK13)","v":0},{"$f":"SUM(AL7:AL13)","v":68145423},null,{"$f":"SUM(AN7:AN13)","v":0},{"$f":"SUM(AO7:AO13)","v":0},{"$f":"SUM(AP7:AP13)","v":68145423},null,{"$f":"SUM(AR7:AR13)","v":0},{"$f":"SUM(AS7:AS13)","v":0},{"$f":"SUM(AT7:AT13)","v":68145423},null,{"$f":"SUM(AV7:AV13)","v":0},{"$f":"SUM(AW7:AW13)","v":0},{"$f":"SUM(AX7:AX13)","v":68145423},null,{"$f":"SUM(AZ7:AZ13)","v":0},{"$f":"SUM(BA7:BA13)","v":0},{"$f":"SUM(BB7:BB13)","v":68145423}]
[{"$f":"科目細分類表!L4","v":"特会負債"},null,"負債",{"$f":"科目細分類表!L5","v":"銀行借入金"},null,null,{"$f":"説明!D53","v":0},0,0,null,{"$f":"G15+I15-H15","v":0},null,null,null,{"$f":"K15+M15-L15","v":0},null,null,null,{"$f":"O15+Q15-P15","v":0},null,null,null,{"$f":"S15+U15-T15","v":0},null,null,null,{"$f":"W15+Y15-X15","v":0},null,null,null,{"$f":"AA15+AC15-AB15","v":0},null,null,null,{"$f":"AE15+AG15-AF15","v":0},null,null,null,{"$f":"AI15+AK15-AJ15","v":0},null,null,null,{"$f":"AM15+AO15-AN15","v":0},null,null,null,{"$f":"AQ15+AS15-AR15","v":0},null,null,null,{"$f":"AU15+AW15-AV15","v":0},null,null,null,{"$f":"AY15+BA15-AZ15","v":0},null,null,null,null,"銀行借入金",null,null,{"$f":"BF15","v":0},{"$f":"BC15","v":0},0]
[{"$f":"科目細分類表!M4","v":"特会負債"},null,null,{"$f":"科目細分類表!M5","v":"その他負債"},null,null,{"$f":"説明!D54","v":0},0,0,null,{"$f":"G16+I16-H16","v":0},null,null,null,{"$f":"K16+M16-L16","v":0},null,null,null,{"$f":"O16+Q16-P16","v":0},null,null,null,{"$f":"S16+U16-T16","v":0},null,null,null,{"$f":"W16+Y16-X16","v":0},null,null,null,{"$f":"AA16+AC16-AB16","v":0},null,null,null,{"$f":"AE16+AG16-AF16","v":0},null,null,null,{"$f":"AI16+AK16-AJ16","v":0},null,null,null,{"$f":"AM16+AO16-AN16","v":0},null,null,null,{"$f":"AQ16+AS16-AR16","v":0},null,null,null,{"$f":"AU16+AW16-AV16","v":0},null,null,null,{"$f":"AY16+BA16-AZ16","v":0},null,null,null,null,"その他負債",null,null,{"$f":"BF16","v":0},{"$f":"BC16","v":0},0]
[null,null,null,"負債計",null,null,{"$f":"SUM(G15:G16)","v":0},{"$f":"SUM(H15:H16)","v":0},{"$f":"SUM(I15:I16)","v":0},null,{"$f":"SUM(K15:K16)","v":0},{"$f":"SUM(L15:L16)","v":0},{"$f":"SUM(M15:M16)","v":0},null,{"$f":"SUM(O15:O16)","v":0},{"$f":"SUM(P15:P16)","v":0},{"$f":"SUM(Q15:Q16)","v":0},null,{"$f":"SUM(S15:S16)","v":0},{"$f":"SUM(T15:T16)","v":0},{"$f":"SUM(U15:U16)","v":0},null,{"$f":"SUM(W15:W16)","v":0},{"$f":"SUM(X15:X16)","v":0},{"$f":"SUM(Y15:Y16)","v":0},null,{"$f":"SUM(AA15:AA16)","v":0},{"$f":"SUM(AB15:AB16)","v":0},{"$f":"SUM(AC15:AC16)","v":0},null,{"$f":"SUM(AE15:AE16)","v":0},{"$f":"SUM(AF15:AF16)","v":0},{"$f":"SUM(AG15:AG16)","v":0},null,{"$f":"SUM(AI15:AI16)","v":0},{"$f":"SUM(AJ15:AJ16)","v":0},{"$f":"SUM(AK15:AK16)","v":0},null,{"$f":"SUM(AM15:AM16)","v":0},{"$f":"SUM(AN15:AN16)","v":0},{"$f":"SUM(AO15:AO16)","v":0},null,{"$f":"SUM(AQ15:AQ16)","v":0},{"$f":"SUM(AR15:AR16)","v":0},{"$f":"SUM(AS15:AS16)","v":0},null,{"$f":"SUM(AU15:AU16)","v":0},{"$f":"SUM(AV15:AV16)","v":0},{"$f":"SUM(AW15:AW16)","v":0},null,{"$f":"SUM(AY15:AY16)","v":0},{"$f":"SUM(AZ15:AZ16)","v":0},{"$f":"SUM(BA15:BA16)","v":0},null,{"$f":"SUM(BC15:BC16)","v":0},null,null,{"$f":"SUM(BF13:BF16)","v":0},null,{"$f":"D17","v":"負債計"},{"$f":"SUM(BI13:BI16)","v":0},{"$f":"SUM(BJ13:BJ16)","v":0},0,0,0]
[null,null,"資産ー負債",null,null,null,{"$f":"F14-G17","v":67600000},0,{"$f":"H14-I14","v":545423},null,{"$f":"J14-K17","v":68145423},0,{"$f":"L14-M14","v":0},null,{"$f":"N14-O17","v":68145423},0,{"$f":"P14-Q14","v":0},null,{"$f":"R14-S17","v":68145423},0,{"$f":"T14-U14","v":0},null,{"$f":"V14-W17","v":68145423},0,{"$f":"X14-Y14","v":0},null,{"$f":"Z14-AA17","v":68145423},0,{"$f":"AB14-AC14","v":0},null,{"$f":"AD14-AE17","v":68145423},0,{"$f":"AF14-AG14","v":0},null,{"$f":"AH14-AI17","v":68145423},0,{"$f":"AJ14-AK14","v":0},null,{"$f":"AL14-AM17","v":68145423},0,{"$f":"AN14-AO14","v":0},null,{"$f":"AP14-AQ17","v":68145423},0,{"$f":"AR14-AS14","v":0},null,{"$f":"AT14-AU17","v":68145423},0,{"$f":"AV14-AW14","v":0},null,{"$f":"AX14-AY17","v":68145423},0,{"$f":"AZ14-BA14","v":0},null,{"$f":"BB14-BC17","v":68145423}]
[{"$f":"科目細分類表!N4","v":"特会収入"},null,"収入",{"$f":"科目細分類表!N5","v":"自治会一般会計"},null,null,null,0,3425396,null,{"$f":"G19+I19-H19","v":3425396},null,null,null,{"$f":"K19+M19-L19","v":3425396},null,null,null,{"$f":"O19+Q19-P19","v":3425396},null,null,null,{"$f":"S19+U19-T19","v":3425396},null,null,null,{"$f":"W19+Y19-X19","v":3425396},null,null,null,{"$f":"AA19+AC19-AB19","v":3425396},null,null,null,{"$f":"AE19+AG19-AF19","v":3425396},null,null,null,{"$f":"AI19+AK19-AJ19","v":3425396},null,null,null,{"$f":"AM19+AO19-AN19","v":3425396},null,null,null,{"$f":"AQ19+AS19-AR19","v":3425396},null,null,null,{"$f":"AU19+AW19-AV19","v":3425396},null,null,null,{"$f":"AY19+BA19-AZ19","v":3425396},null,null,null,null,"自治会一般会計",null,null,0,{"$f":"BB19","v":0},0]
[{"$f":"科目細分類表!O4","v":"特会収入"},null,null,{"$f":"科目細分類表!O5","v":"その他収入    "},null,null,null,0,27,null,{"$f":"G20+I20-H20","v":27},null,null,null,{"$f":"K20+M20-L20","v":27},null,null,null,{"$f":"O20+Q20-P20","v":27},null,null,null,{"$f":"S20+U20-T20","v":27},null,null,null,{"$f":"W20+Y20-X20","v":27},null,null,null,{"$f":"AA20+AC20-AB20","v":27},null,null,null,{"$f":"AE20+AG20-AF20","v":27},null,null,null,{"$f":"AI20+AK20-AJ20","v":27},null,null,null,{"$f":"AM20+AO20-AN20","v":27},null,null,null,{"$f":"AQ20+AS20-AR20","v":27},null,null,null,{"$f":"AU20+AW20-AV20","v":27},null,null,null,{"$f":"AY20+BA20-AZ20","v":27},null,null,null,null,"その他収入    ",null,null,0,0,0]
[null,null,null,"収入計",null,null,{"$f":"SUM(G19:G20)","v":0},0,3425423,0,3425423,0,0,0,3425423,0,0,0,3425423,0,0,0,3425423,0,0,0,3425423,0,0,0,3425423,0,0,0,3425423,0,0,0,{"$f":"SUM(AM19:AM20)","v":3425423},0,0,0,3425423,0,0,0,3425423,0,0,0,3425423,0,0,0,3425423]
[{"$f":"科目細分類表!P4","v":"特会費用"},null,"費用",{"$f":"科目細分類表!P5","v":"修繕費"},null,null,null,600000,0,{"$f":"F22+H22-I22","v":600000},null,null,null,{"$f":"J22+L22-M22","v":600000},null,null,null,{"$f":"N22+P22-Q22","v":600000},null,null,null,{"$f":"R22+T22-U22","v":600000},null,null,null,{"$f":"V22+X22-Y22","v":600000},null,null,null,{"$f":"Z22+AB22-AC22","v":600000},null,null,null,{"$f":"AD22+AF22-AG22","v":600000},null,null,null,{"$f":"AH22+AJ22-AK22","v":600000},null,null,null,{"$f":"AL22+AN22-AO22","v":600000},null,null,null,{"$f":"AP22+AR22-AS22","v":600000},null,null,null,{"$f":"AT22+AV22-AW22","v":600000},null,null,null,{"$f":"AX22+AZ22-BA22","v":600000},null,null,null,null,null,"修繕費",null,null,0,600000,-600000]
[{"$f":"科目細分類表!Q4","v":"特会費用"},null,null,{"$f":"科目細分類表!Q5","v":"減価償却費"},null,null,null,1680000,0,1680000,null,null,null,1680000,null,null,null,1680000,null,null,null,1680000,null,null,null,1680000,null,null,null,1680000,null,null,null,1680000,null,null,null,1680000,null,null,null,1680000,null,null,null,1680000,null,null,null,1680000,null,null,null,1680000,null,null,null,null,null,"減価償却費",null,null,0,1680000,-1680000]
[{"$f":"科目細分類表!R4","v":"特会費用"},null,null,{"$f":"科目細分類表!R5","v":"その他費用1"},null,null,null,600000,0,600000,null,null,null,600000,null,null,null,600000,null,null,null,600000,null,null,null,600000,null,null,null,600000,null,null,null,600000,null,null,null,600000,null,null,null,600000,null,null,null,600000,null,null,null,600000,null,null,null,600000,null,null,null,null,null,"その他費用1",null,null,0,600000,-600000]
[{"$f":"科目細分類表!S4","v":"特会費用"},null,null,{"$f":"科目細分類表!S5","v":"その他費用2"},null,null,null,0,0,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,0,null,null,null,null,null,{"$f":"D25","v":"その他費用2"},null,null,0]
[null,null,null,"費用計",null,null,null,{"$f":"SUM(H22:H25)","v":2880000},{"$f":"SUM(I22:I25)","v":0},{"$f":"SUM(J19:J25)","v":2880000},null,{"$f":"SUM(L22:L25)","v":0},{"$f":"SUM(M22:M25)","v":0},{"$f":"SUM(N19:N25)","v":2880000},null,{"$f":"SUM(P22:P25)","v":0},{"$f":"SUM(Q22:Q25)","v":0},{"$f":"SUM(R19:R25)","v":2880000},null,{"$f":"SUM(T22:T25)","v":0},{"$f":"SUM(U22:U25)","v":0},{"$f":"SUM(V19:V25)","v":2880000},null,{"$f":"SUM(X22:X25)","v":0},{"$f":"SUM(Y22:Y25)","v":0},{"$f":"SUM(Z19:Z25)","v":2880000},null,{"$f":"SUM(AB22:AB25)","v":0},{"$f":"SUM(AC22:AC25)","v":0},{"$f":"SUM(AD19:AD25)","v":2880000},null,{"$f":"SUM(AF22:AF25)","v":0},{"$f":"SUM(AG22:AG25)","v":0},{"$f":"SUM(AH19:AH25)","v":2880000},null,{"$f":"SUM(AJ22:AJ25)","v":0},{"$f":"SUM(AK22:AK25)","v":0},{"$f":"SUM(AL19:AL25)","v":2880000},null,{"$f":"SUM(AN22:AN25)","v":0},{"$f":"SUM(AO22:AO25)","v":0},{"$f":"SUM(AP19:AP25)","v":2880000},null,{"$f":"SUM(AR22:AR25)","v":0},{"$f":"SUM(AS22:AS25)","v":0},{"$f":"SUM(AT19:AT25)","v":2880000},null,{"$f":"SUM(AV22:AV25)","v":0},{"$f":"SUM(AW22:AW25)","v":0},{"$f":"SUM(AX19:AX25)","v":2880000},null,{"$f":"SUM(AZ22:AZ25)","v":0},{"$f":"SUM(BA22:BA25)","v":0},{"$f":"SUM(BB19:BB25)","v":2880000},null,null,{"$f":"SUM(BE19:BE25)","v":0},null,null,"支出<C>",{"$f":"SUM(BI12:BI24)","v":0},{"$f":"SUM(BJ12:BJ24)","v":0},0,2880000,{"$f":"BK26-BL26","v":-2880000}]
[null,null,"収入ー費用",null,null,null,null,{"$f":"I21-H26","v":545423},null,{"$f":"F27+H27","v":545423},{"$f":"G27+I27","v":0},{"$f":"M21-L26","v":0},null,{"$f":"J27+L27","v":545423},{"$f":"K27+M27","v":0},{"$f":"Q21-P26","v":0},null,{"$f":"N27+P27","v":545423},{"$f":"O27+Q27","v":0},{"$f":"U21-T26","v":0},null,{"$f":"R27+T27","v":545423},{"$f":"S27+U27","v":0},{"$f":"Y21-X26","v":0},null,{"$f":"V27+X27","v":545423},{"$f":"W27+Y27","v":0},{"$f":"AC21-AB26","v":0},null,{"$f":"Z27+AB27","v":545423},{"$f":"AA27+AC27","v":0},{"$f":"AG21-AF26","v":0},null,{"$f":"AD27+AF27","v":545423},{"$f":"AE27+AG27","v":0},{"$f":"AK21-AJ26","v":0},null,{"$f":"AH27+AJ27","v":545423},{"$f":"AI27+AK27","v":0},{"$f":"AO21-AN26","v":0},null,{"$f":"AL27+AN27","v":545423},{"$f":"AM27+AO27","v":0},{"$f":"AS21-AR26","v":0},null,{"$f":"AP27+AR27","v":545423},{"$f":"AQ27+AS27","v":0},{"$f":"AW21-AV26","v":0},null,{"$f":"AT27+AV27","v":545423},{"$f":"AU27+AW27","v":0},{"$f":"BA21-AZ26","v":0},null,{"$f":"AX27+AZ27","v":545423},{"$f":"AY27+BA27","v":0},null,{"$f":"BF17-BE26","v":0},null,null,"収益",{"$f":"BI17-BI26","v":0},{"$f":"BJ17-BJ26","v":0},0,-2880000,2880000]
[]
[null,null,null,null,null,{"$f":"F4","v":"2021-03-31"},null,{"$f":"H4","v":"2021-04-01"},null,{"$f":"J4","v":"2022-03-31"},null,{"$f":"L4","v":""},null,{"$f":"N4","v":""},null,{"$f":"P4","v":""},null,{"$f":"R4","v":""},null,{"$f":"T4","v":""},null,{"$f":"V4","v":""},null,{"$f":"X4","v":""},null,{"$f":"Z4","v":""},null,{"$f":"AB4","v":""},null,{"$f":"AD4","v":""},null,{"$f":"AF4","v":""},null,{"$f":"AH4","v":""},null,{"$f":"AJ4","v":""},null,{"$f":"AL4","v":""},null,{"$f":"AN4","v":""},null,{"$f":"AP4","v":""},null,{"$f":"AR4","v":""},null,{"$f":"AT4","v":""},null,{"$f":"AV4","v":""},null,{"$f":"AX4","v":""},null,{"$f":"AZ4","v":""},null,{"$f":"BB4","v":""},null,null,{"$f":"BE4","v":2021},"年度予算"]
[null,null,null,null,null,"繰越残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高",null,"発生",null,"残高"]
[null,null,null,"細分類",null,"借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方","借方","貸方",null,"借方","貸方"]
[null,null,null,{"$f":"D7","v":"現金"},null,{"$f":"F7","v":0},0,0,0,0,0,{"$f":"L7","v":0},0,0,0,{"$f":"P7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"BE7","v":0},{"$f":"BF7","v":0}]
[]
[]
[]
[null,null,null,{"$f":"D8","v":"普通預金(準備金移動前）"},null,{"$f":"F8","v":0},0,3425423,3425423,0,0,{"$f":"L8","v":0},0,0,0,{"$f":"P8","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"BE8","v":0},{"$f":"BF8","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"F37+H37-I37","v":0},null,null,null,{"$f":"J37+L37-M37","v":0},null,null,null,{"$f":"N37+P37-Q37","v":0},null,null,null,{"$f":"R37+T37-U37","v":0},null,null,null,{"$f":"V37+X37-Y37","v":0},null,null,null,{"$f":"Z37+AB37-AC37","v":0},null,null,null,{"$f":"AD37+AF37-AG37","v":0},null,null,null,{"$f":"AH37+AJ37-AK37","v":0},null,null,null,{"$f":"AL37+AN37-AO37","v":0},null,null,null,{"$f":"AP37+AR37-AS37","v":0},null,null,null,{"$f":"AT37+AV37-AW37","v":0},null,null,null,{"$f":"AX37+AZ37-BA37","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"F38+H38-I38","v":0},null,null,null,{"$f":"J38+L38-M38","v":0},null,null,null,{"$f":"N38+P38-Q38","v":0},null,null,null,{"$f":"R38+T38-U38","v":0},null,null,null,{"$f":"V38+X38-Y38","v":0},null,null,null,{"$f":"Z38+AB38-AC38","v":0},null,null,null,{"$f":"AD38+AF38-AG38","v":0},null,null,null,{"$f":"AH38+AJ38-AK38","v":0},null,null,null,{"$f":"AL38+AN38-AO38","v":0},null,null,null,{"$f":"AP38+AR38-AS38","v":0},null,null,null,{"$f":"AT38+AV38-AW38","v":0},null,null,null,{"$f":"AX38+AZ38-BA38","v":0}]
[]
[null,null,null,{"$f":"D9","v":"A準備金"},null,{"$f":"F9","v":6300000},0,2125423,7800000,625423,0,{"$f":"L9","v":0},0,625423,0,{"$f":"P9","v":0},0,625423,0,0,0,625423,0,0,0,625423,0,0,0,625423,0,0,0,625423,0,0,0,625423,0,0,0,625423,0,0,0,625423,0,0,0,625423,0,0,0,625423,0,null,0,0]
[]
[]
[]
[null,null,null,{"$f":"D10","v":"B準備金"},null,{"$f":"F10","v":0},0,7200000,0,7200000,0,{"$f":"L10","v":0},0,7200000,0,{"$f":"P10","v":0},0,7200000,0,0,0,7200000,0,0,0,7200000,0,0,0,7200000,0,0,0,7200000,0,0,0,7200000,0,0,0,7200000,0,0,0,7200000,0,0,0,7200000,0,0,0,7200000,0,null,{"$f":"BE10","v":0},{"$f":"BF10","v":0}]
[]
[]
[]
[null,null,null,{"$f":"D11","v":"C準備金"},null,{"$f":"F11","v":0},{"$f":"G11","v":0},{"$f":"H11","v":1300000},600000,700000,0,{"$f":"L11","v":0},0,700000,0,{"$f":"P11","v":0},0,700000,0,0,0,700000,0,0,0,700000,0,0,0,700000,0,0,0,700000,0,0,0,700000,0,0,0,700000,0,0,0,700000,0,0,0,700000,0,0,0,700000,0,null,{"$f":"BE11","v":0},{"$f":"BF11","v":0}]
[]
[]
[]
[null,null,null,{"$f":"D12","v":"固定資産"},null,{"$f":"F12","v":61300000},{"$f":"G12","v":0},0,1680000,59620000,0,{"$f":"L12","v":0},0,59620000,0,{"$f":"P12","v":0},0,59620000,0,0,0,59620000,0,0,0,59620000,0,0,0,59620000,0,0,0,59620000,0,0,0,59620000,0,0,0,59620000,0,0,0,59620000,0,0,0,59620000,0,0,0,59620000,0,null,{"$f":"BE12","v":0},{"$f":"BF12","v":0}]
[]
[]
[]
[null,null,null,{"$f":"D13","v":"その他資産"},null,{"$f":"F13","v":0},0,0,0,0,0,{"$f":"L13","v":0},0,0,0,{"$f":"P13","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"BE13","v":0},{"$f":"BF13","v":0}]
[]
[]
[]
[null,null,null,{"$f":"D15","v":"銀行借入金"},null,{"$f":"F15","v":0},{"$f":"G15","v":0},0,0,0,0,{"$f":"L15","v":0},0,0,0,{"$f":"P15","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"BE15","v":0},{"$f":"BF15","v":0}]
[]
[]
[]
[null,null,null,{"$f":"D16","v":"その他負債"},null,{"$f":"F16","v":0},{"$f":"G16","v":0},0,0,0,0,{"$f":"L16","v":0},0,0,0,{"$f":"P16","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,{"$f":"BE16","v":0},{"$f":"BF16","v":0}]
[]
[]
[]
[null,null,null,{"$f":"D19","v":"自治会一般会計"},null,{"$f":"F19","v":0},{"$f":"G19","v":0},0,3425396,0,3425396,{"$f":"L19","v":0},0,0,3425396,{"$f":"P19","v":0},0,0,3425396,0,0,0,3425396,0,0,0,3425396,0,0,0,3425396,0,0,0,3425396,0,0,0,3425396,0,0,0,3425396,0,0,0,3425396,0,0,0,3425396,0,0,0,3425396,null,{"$f":"BE19","v":0},{"$f":"BF19","v":0}]
[]
[]
[]
[null,null,null,{"$f":"D20","v":"その他収入    "},null,{"$f":"F20","v":0},{"$f":"G20","v":0},0,27,0,27,{"$f":"L20","v":0},0,0,27,{"$f":"P20","v":0},0,0,27,0,0,0,27,0,0,0,27,0,0,0,27,0,0,0,27,0,0,0,27,0,0,0,27,0,0,0,27,0,0,0,27,0,0,0,27,null,{"$f":"BE20","v":0},0]
[null,null,null,null,"普通預金利子"]
[]
[]
[null,null,null,{"$f":"D22","v":"修繕費"},null,{"$f":"F22","v":0},{"$f":"G22","v":0},600000,0,600000,0,{"$f":"L22","v":0},0,600000,0,{"$f":"P22","v":0},0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,null,{"$f":"BE22","v":0},0]
[null,null,null,null,"建物"]
[]
[]
[null,null,null,{"$f":"D23","v":"減価償却費"},null,{"$f":"F23","v":0},{"$f":"G23","v":0},1680000,0,1680000,0,{"$f":"L23","v":0},0,1680000,0,{"$f":"P23","v":0},0,1680000,0,0,0,1680000,0,0,0,1680000,0,0,0,1680000,0,0,0,1680000,0,0,0,1680000,0,0,0,1680000,0,0,0,1680000,0,0,0,1680000,0,0,0,1680000,0,null,{"$f":"BE23","v":0},0]
[null,null,null,null,"建物"]
[]
[]
[null,null,null,{"$f":"D24","v":"その他費用1"},null,{"$f":"F24","v":0},{"$f":"G24","v":0},600000,0,600000,0,{"$f":"L24","v":0},0,600000,0,{"$f":"P24","v":0},0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,0,0,600000,0,null,{"$f":"BE24","v":0},0]
[null,null,null,null,"AAA負担金"]
[]
[]
[null,null,null,{"$f":"D25","v":"その他費用2"},null,{"$f":"F25","v":0},{"$f":"G25","v":0},0,0,0,0,{"$f":"L25","v":0},0,0,0,{"$f":"P25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,0,0]

{"sheet":"科目細分類表","index":5,"n_rows":23,"n_cols":19,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,3,2],[0,0,0,2],[0,6,0,18],[2,4,2,7],[2,8,2,9],[2,10,2,12],[2,13,2,18]]}
["この３列は触らないでください。",null,null,"科目細分類表",null,null,"下の操作を行うと、科目名及び科目グループ名（セル内で完全一致した）を置き換えます(処理としては、置き換え前に、時刻付きのバックアップEを作成します）。"]
[null,null,null,null,null,null,"文字列","現金","を","現金","へ置き換えます。→"]
[null,null,null,null,"資産４項目を固定（借方残）",null,null,null,"負債2項目を固定（貸方残）",null,"収入3項目を固定（貸方残）",null,null,"費用6項目を固定"]
[null,"逆引き",null,"科目グループ→","特会資産","特会資産","特会資産","特会資産","特会資産","特会資産","特会資産","特会負債","特会負債","特会収入","特会収入","特会費用","特会費用","特会費用","特会費用"]
[{"$f":"E4","v":"特会資産"},{"$f":"科目細分類[[#Headers],[現金]]","v":"現金"},{"$f":"E4","v":"特会資産"},"科目名→\n細分類↓","現金","普通預金(準備金移動前）","A準備金","B準備金","C準備金","固定資産","その他資産","銀行借入金","その他負債","自治会一般会計","その他収入    ","修繕費","減価償却費","その他費用1","その他費用2"]
[{"$f":"F4","v":"特会資産"},{"$f":"科目細分類[[#Headers],[普通預金(準備金移動前）]]","v":"普通預金(準備金移動前）"},{"$f":"F4","v":"特会資産"},"a","-","-","-","-","-","建物","-","-","-","-","普通預金利子","建物","建物","AAA負担金"]
[{"$f":"G4","v":"特会資産"},{"$f":"科目細分類[[#Headers],[A準備金]]","v":"A準備金"},{"$f":"G4","v":"特会資産"},"b",null,null,null,null,null,"-"]
[{"$f":"H4","v":"特会資産"},{"$f":"科目細分類[[#Headers],[B準備金]]","v":"B準備金"},{"$f":"H4","v":"特会資産"},"c",null,null,null,null,null,"-"]
[{"$f":"I4","v":"特会資産"},{"$f":"科目細分類[[#Headers],[C準備金]]","v":"C準備金"},{"$f":"I4","v":"特会資産"},"d","-",null,null,null,null,"-"]
[{"$f":"J4","v":"特会資産"},{"$f":"科目細分類[[#Headers],[固定資産]]","v":"固定資産"},{"$f":"J4","v":"特会資産"},"e","-",null,null,null,"-","-"]
[{"$f":"K4","v":"特会資産"},{"$f":"科目細分類[[#Headers],[その他資産]]","v":"その他資産"},{"$f":"K4","v":"特会資産"},"f","-",null,"-",null,"-","-"]
[{"$f":"L4","v":"特会負債"},{"$f":"科目細分類[[#Headers],[銀行借入金]]","v":"銀行借入金"},{"$f":"L4","v":"特会負債"},"g","-",null,"-",null,"-","-"]
[{"$f":"M4","v":"特会負債"},{"$f":"科目細分類[[#Headers],[その他負債]]","v":"その他負債"},{"$f":"M4","v":"特会負債"},"h","-",null,"-",null,"-","-"]
[{"$f":"N4","v":"特会収入"},{"$f":"科目細分類[[#Headers],[自治会一般会計]]","v":"自治会一般会計"},{"$f":"N4","v":"特会収入"},"i","-","-","-",null,"-","-"]
[{"$f":"O4","v":"特会収入"},{"$f":"科目細分類[[#Headers],[その他収入    ]]","v":"その他収入    "},{"$f":"O4","v":"特会収入"},"j","-","-","-","-","-","-"]
[{"$f":"P4","v":"特会費用"},{"$f":"科目細分類[[#Headers],[修繕費]]","v":"修繕費"},{"$f":"P4","v":"特会費用"},"k","-","-","-","-","-","-"]
[{"$f":"Q4","v":"特会費用"},{"$f":"科目細分類[[#Headers],[減価償却費]]","v":"減価償却費"},{"$f":"Q4","v":"特会費用"},"l","-","-","-","-","-","-"]
[{"$f":"R4","v":"特会費用"},{"$f":"科目細分類[[#Headers],[その他費用1]]","v":"その他費用1"},{"$f":"R4","v":"特会費用"},"m","-","-","-","-","-","-"]
[{"$f":"S4","v":"特会費用"},{"$f":"科目細分類[[#Headers],[その他費用2]]","v":"その他費用2"},{"$f":"S4","v":"特会費用"},"n","-","-","-","-","-","-"]
[null,null,null,"o","-","-","-","-","-","-"]
[null,null,null,"p","-","-","-","-","-","-"]
[null,null,null,"q","-","-","-","-","-","-"]
[null,null,null,"r","-","-","-","-","-","-"]

{"sheet":"現金照合表","index":6,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,3],[6,1,6,2],[6,4,6,5],[18,1,18,3],[2,1,2,9],[4,2,4,4],[3,7,3,8]]}
[]
[null,{"$f":"説明!C24","v":"A自治会_特別会計"}]
[null,"現　金　照　合　表"]
[null,null,null,null,null,null,"会計",null,null,"㊞"]
[null,"日付","2021-09-30"]
[]
[null,"金種",null,"枚数","金額",null,null,"帳簿残高",null,"円"]
[null,10000,"円",null,{"$f":"B8*D8","v":0},"円",null,"実際有高",{"$f":"E19","v":0},"円"]
[null,5000,"円",null,{"$f":"B9*D9","v":0},"円",null,"現金過不足",{"$f":"I8-I7","v":0},"円"]
[null,2000,"円",null,0,"円"]
[null,1000,"円",null,0,"円"]
[null,500,"円",null,0,"円"]
[null,100,"円",null,0,"円"]
[null,50,"円",null,0,"円"]
[null,10,"円",null,0,"円"]
[null,5,"円",null,0,"円"]
[null,1,"円",null,0,"円"]
[null,"商品券",null,null,null,"円"]
[null,"現金残高",null,null,{"$f":"SUM(E8:E18)","v":0},"円"]

{"sheet":"手書き領収書フォーム","index":7,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[[22,4,22,5],[2,1,2,2],[11,1,11,2],[13,4,13,5],[4,4,4,5],[20,1,20,2],[2,4,2,5],[11,4,11,5],[20,4,20,5]]}
[]
[]
[null,"領収証",null,null,{"$f":"説明!C24","v":"A自治会_特別会計"},null,"様"]
[]
[null,null,null,null,150000,null,"円也"]
[]
[null,"令和3年　　　月　　　日　上記正に領収いたしました。"]
[]
[null,null,null,null,null,null,"㊞"]
[]
[]
[null,"領収証",null,null,{"$f":"E3","v":"A自治会_特別会計"},null,"様"]
[]
[null,null,null,null,100000,null,"円也"]
[]
[null,"令和3年　　　月　　　日　上記正に領収いたしました。"]
[]
[null,null,null,null,null,null,"㊞"]
[]
[]
[null,"領収証",null,null,{"$f":"E3","v":"A自治会_特別会計"},null,"様"]
[]
[null,null,null,null,null,null,"円也"]
[]
[null,"令和3年　　　月　　　日　上記正に領収いたしました。"]
[]
[null,null,null,null,null,null,"㊞"]