{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["基本データ","指定請求書","出来高内訳書","【入力例】基本データ","【入力例・契約】指定請求書","【入力例・非契約】指定請求書","【入力例1】出来高内訳書","【入力例2】出来高内訳書"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["工事情報"]
["工事名"]
["注文書契約の有無",null,null,"→注文書・請書のやり取りをしていれば「あり」を選択してください。"]
["（ありの場合）注文書番号",null,null,"→注文書に記載されている注文番号の上6桁を入力してください。"]
["（あり請負の場合）保留金",null,null,"→注文書に記載されている出来高の保留割合を入力してください。通常「0」か「10」です。"]
["工事番号",null,null,"→作業所長にお問い合わせください。"]
["手形比率",null,null,"→ご不明な場合は作業所長にお問い合わせください。"]
[]
["今回締日",null,null,"→曜日に関係なく月末日を入力してください。"]
[]
["業者情報"]
["住所",null,null,null,"指定請求書と出来高内訳をクリアします↑"]
["会社名"]
["代表者職氏名"]
["電話番号"]
["ファックス番号"]
["適格請求書登録番号",null,null,"→（例）T2345678901234"]
[]
["口座情報"]
["《振込銀行口座》",null,null,"《でんさい口座》"]
["金融機関名",null,null,"でんさい利用者番号"]
["店名",null,null,"金融機関名"]
["口座種別",null,null,"支店名"]
["口座番号",null,null,"口座種別"]
["口座名義ﾌﾘｶﾞﾅ",null,null,"口座番号"]
["口座名義",null,null,"口座名義ﾌﾘｶﾞﾅ"]
[null,null,null,"口座名義"]

{"sheet":"指定請求書","index":1,"n_rows":56,"n_cols":66,"rows_kept":56,"cut":false,"hidden":false,"merged":[[45,24,46,30],[45,31,46,37],[45,38,46,44],[45,17,46,23],[49,24,50,30],[51,24,52,30],[53,24,54,30],[49,1,50,7],[53,1,54,7],[55,1,56,7],[45,8,46,14],[47,8,48,14],[49,8,50,14],[53,8,54,14],[55,8,56,14],[45,1,46,7],[47,1,48,7],[51,1,52,7],[51,8,52,14],[48,64,49,67],[50,48,54,51],[50,52,54,55],[50,56,54,59],[50,64,54,67],[49,17,50,23],[51,17,52,23],[53,17,54,23],[55,17,56,23],[49,38,50,44],[51,38,52,44],[53,38,54,44],[55,38,56,44],[47,38,48,44],[48,48,49,51],[47,24,48,30],[47,31,48,37],[55,24,56,30],[49,31,50,37],[51,31,52,37],[53,31,54,37],[55,31,56,37],[36,8,37,24],[43,1,44,7],[39,8,40,14],[41,8,42,14],[43,8,44,14],[43,17,44,23],[39,24,40,30],[39,31,40,37],[39,38,40,44],[43,24,44,30],[43,31,44,37],[36,1,37,4],[36,5,37,7],[36,32,37,36],[36,28,37,31],[36,25,37,27],[41,17,42,23],[41,24,42,30],[39,1,40,7],[41,1,42,7],[43,38,44,44],[36,37,37,43],[41,31,42,37],[41,38,42,44],[30,1,31,4],[28,1,29,4],[28,8,29,24],[30,8,31,24],[32,8,33,24],[34,8,35,24],[34,44,35,44],[32,1,33,4],[34,1,35,4],[20,1,21,4],[26,1,27,4],[24,1,25,4],[20,8,21,24],[22,8,23,24],[24,8,25,24],[26,8,27,24],[22,1,23,4],[17,1,18,4],[17,5,18,9],[17,10,18,13],[17,14,18,18],[17,19,18,22],[17,23,18,25],[20,5,21,7],[20,25,21,27],[17,26,18,26],[14,28,15,31],[14,32,15,35],[14,36,15,39],[18,54,19,67],[12,1,15,5],[12,6,15,26],[8,65,9,66],[6,1,7,14],[10,41,11,46],[10,48,11,62],[8,1,10,7],[8,8,10,26],[14,41,15,46],[12,51,13,57],[12,61,13,67],[12,58,13,60],[12,48,13,50],[14,48,15,67],[3,2,4,14],[3,16,4,18],[3,24,5,39],[6,41,7,46],[6,48,7,62],[8,41,9,46],[8,48,9,62],[3,56,4,67],[50,60,54,63],[18,48,19,53],[20,48,21,53],[22,48,23,53],[24,48,25,53],[26,48,27,53],[28,48,29,53],[34,48,35,53],[36,48,37,53],[38,48,39,53],[40,48,41,53],[42,48,43,53],[44,48,45,53],[32,48,33,53],[34,54,35,67],[36,54,37,67],[38,54,39,67],[40,54,41,67],[42,54,43,67],[44,54,45,67],[30,47,31,52],[16,47,17,52],[22,32,23,36],[24,32,25,36],[26,32,27,36],[28,32,29,36],[30,32,31,36],[32,32,33,36],[34,32,35,36],[20,54,21,67],[22,54,23,67],[24,54,25,67],[26,54,27,67],[28,54,29,67],[32,54,33,67],[28,44,29,44],[30,44,31,44],[32,44,33,44],[36,44,37,44],[18,37,19,44],[26,28,27,31],[28,28,29,31],[30,28,31,31],[32,28,33,31],[34,28,35,31],[22,5,23,7],[24,5,25,7],[26,5,27,7],[28,5,29,7],[30,5,31,7],[32,5,33,7],[34,5,35,7],[20,28,21,31],[20,32,21,36],[20,37,21,43],[48,52,49,63],[20,44,21,44],[22,44,23,44],[24,44,25,44],[26,44,27,44],[22,25,23,27],[24,25,25,27],[26,25,27,27],[22,37,23,43],[24,37,25,43],[26,37,27,43],[28,37,29,43],[30,37,31,43],[32,37,33,43],[34,37,35,43],[28,25,29,27],[30,25,31,27],[32,25,33,27],[34,25,35,27],[22,28,23,31],[24,28,25,31]]}
[]
[]
[]
[null,null,"中林建設株式会社",null,null,null,null,null,null,null,null,null,null,null,null,null,"御中",null,null,null,null,null,null,null,"請求書",null,null,null,null,null,null,null,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":"IF(基本データ!B9=\"\",\"年　　月　　日締請求\",基本データ!B9)","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,"住所",null,null,null,null,null,null,{"$f":"IF(基本データ!B12=\"\",\"\",基本データ!B12)","v":""}]
[]
[null,"請求金額",null,null,null,null,null,null,{"$f":"SUM(AM42:AS47)","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,null,null,null,null,"会社名",null,null,null,null,null,null,{"$f":"IF(基本データ!B13=\"\",\"\",基本データ!B13)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者職氏名",null,null,null,null,null,null,{"$f":"IF(基本データ!B14=\"\",\"\",基本データ!B14)","v":""}]
[]
[null,"工事名称",null,null,null,null,{"$f":"IF(基本データ!B2=\"\",\"\",基本データ!B2)","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,null,"TEL",null,null,{"$f":"IF(基本データ!B15=\"\",\"\",基本データ!B15)","v":""},null,null,null,null,null,null,"FAX",null,null,{"$f":"IF(基本データ!B16=\"\",\"\",基本データ!B16)","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,null,null,null,null,{"$f":"LEFT(基本データ!B17,2)&\" - \"&MID(基本データ!B17,3,4)&\" - \"&MID(基本データ!B17,7,4)&\" - \"&RIGHT(基本データ!B17,4)","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,null,null,null,null,null,null,null,"【振込銀行口座】"]
[null,"注文番号",null,null,null,{"$f":"IF(OR(基本データ!B3=\"なし\",基本データ!B3=\"\"),\"\",基本データ!B4)","v":""},null,null,null,null,"工事番号",null,null,null,{"$f":"IF(基本データ!B6=\"\",\"\",基本データ!B6)","v":""},null,null,null,null,"手形比率",null,null,null,{"$f":"基本データ!B7","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,null,null,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":"IF(基本データ!B21=\"\",\"\",基本データ!B21)","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,"店名",null,null,null,null,null,{"$f":"IF(基本データ!B22=\"\",\"\",基本データ!B22)","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,null,null,null,null,null,null,null,null,"預金種目",null,null,null,null,null,{"$f":"IF(基本データ!B23=\"\",\"\",基本データ!B23)","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,null,null,null,null,null,null,null,null,"口座番号",null,null,null,null,null,{"$f":"IF(基本データ!B24=\"\",\"\",基本データ!B24)","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,null,null,null,null,null,null,null,null,"フリガナ",null,null,null,null,null,{"$f":"IF(基本データ!B25=\"\",\"\",基本データ!B25)","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,null,null,null,null,null,null,null,null,"口座名義",null,null,null,null,null,{"$f":"IF(基本データ!B26=\"\",\"\",基本データ!B26)","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,null,null,null,null,null,null,null,"【でんさい口座】"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(基本データ!E21=\"\",\"\",基本データ!E21)","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,null,null,null,null,null,null,null,null,"金融機関名",null,null,null,null,null,{"$f":"IF(基本データ!E22=\"\",\"\",基本データ!E22)","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,null,null,null,null,null,null,null,null,"店名",null,null,null,null,null,{"$f":"IF(基本データ!E23=\"\",\"\",基本データ!E23)","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,null,null,null,null,null,null,null,null,"預金種目",null,null,null,null,null,{"$f":"IF(基本データ!E24=\"\",\"\",基本データ!E24)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(基本データ!E25=\"\",\"\",基本データ!E25)","v":""}]
[null,"前月迄出来高",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"当月課税10％対象",null,null,null,null,null,null,{"$f":"SUMIF(AS23:AS38,\"\",AL23:AR38)-I50+I52","v":0},null,null,null,null,null,null,{"$f":"ROUND(Y42*0.1,0)+AF54","v":0},null,null,null,null,null,null,{"$f":"SUM(Y42:AL43)","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,null,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":"IF(基本データ!E26=\"\",\"\",基本データ!E26)","v":""}]
[null,"当月出来高",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"当月課税 8％対象",null,null,null,null,null,null,{"$f":"SUMIF(AS23:AS38,\"※\",AL23:AR38)","v":0},null,null,null,null,null,null,{"$f":"ROUND(Y44*0.08,0)","v":0},null,null,null,null,null,null,{"$f":"SUM(Y44:AL45)","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,null,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":"IF(基本データ!E27=\"\",\"\",基本データ!E27)","v":""}]
[null,"出来高累計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"非・不課税",null,null,null,null,null,null,{"$f":"SUMIF(AS23:AS38,\"非\",AL23:AR38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y46:AL47)","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,null,"当月",null,null,null,null,null,null,"当月迄"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"部署長",null,null,null,"施工担当部",null,null,null,null,null,null,null,null,null,null,null,"所長"]
[null,"当月保留金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(基本データ!B3=\"なし\",\"\",I44-I50+I52)","v":0},null,null,null,null,null,null,null,null,"消費税額調整額"]
[]
[null,"支払残",null,null,null,null,null,null,{"$f":"IF(OR(基本データ!B3=\"あり（単価契約）\",基本データ!B3=\"なし\"),\"\",I40-Y50-AF50)","v":0},null,null,null,null,null,null,null,null,"税込支払金額"]

{"sheet":"出来高内訳書","index":2,"n_rows":6,"n_cols":16,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,13,1,15],[2,10,2,11],[0,2,0,15]]}
[null,null,"①契約内容を入力してください。各項目ごとに集計する場合は、費目欄に「小計」と入力し、小計の列を含めNo.欄に数字を入力してください。\n　最後に費目欄に「合計」の入力もお願いします（【入力例1】参照）。合計のみの場合はNo.欄に数字を入力しないでください（【入力例2】参照）。\n　金額欄は「計算」ボタンを押せば自動で計算します。\n②今月が2回目以降の請求であれば、「月を更新」ボタンを押してください。\n③出来高累計欄（非契約の場合は当月出来高欄）の数量を入力してください。一式の項目は、金額も入力してください。\n④「計算」ボタンを押してください。入力漏れがなければ、「印刷」ボタンを押してください。\n※注意※　一度ボタンを押すと元に戻すことができません！"]
[null,null,null,null,null,"出来高内訳書",null,null,null,null,null,null,null,{"$f":"基本データ!B9","v":"00:00:00"}]
[null,"工事名称",{"$f":"基本データ!B2","v":0},null,null,null,null,null,null,null,"協力業者名",null,{"$f":"基本データ!B13","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,"契約残額"]
["No.","費目","細目","単位","単価","数量","金額","数量","金額","数量","金額","数量","金額","数量","金額","※"]

{"sheet":"【入力例】基本データ","index":3,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["工事情報"]
["工事名","○○○○○工事"]
["注文書契約の有無","あり（請負）",null,"→注文書・請書のやり取りをしていれば「あり」を選択してください。"]
["（ありの場合）注文書番号","B23601",null,"→注文書に記載されている注文番号の上6桁を入力してください。"]
["（あり請負の場合）保留金","10%",null,"→注文書に記載されている出来高の保留割合を入力してください。通常「0」か「10」です。"]
["工事番号","B236",null,"→作業所長にお問い合わせください。"]
["手形比率",60,null,"→ご不明な場合は作業所長にお問い合わせください。"]
[]
["今回締日","2023-06-30",null,"→曜日に関係なく月末日を入力してください。"]
[]
["業者情報"]
["住所","大阪市浪速区大国2-1-19",null,null,"指定請求書と出来高内訳をクリアします↑"]
["会社名","中林建設株式会社"]
["代表者職氏名","代表取締役社長　中林浩之"]
["電話番号","06-6647-7583"]
["ファックス番号","06-6636-5775"]
["適格請求書登録番号","T2120001039288",null,"→（例）T2345678901234"]
[]
["口座情報"]
["《振込銀行口座》",null,null,"《でんさい口座》"]
["金融機関名","りそな銀行",null,"でんさい利用者番号","00000aaaa"]
["店名","難波支店",null,"金融機関名","りそな銀行"]
["口座種別","当座",null,"支店名","難波支店"]
["口座番号","0123456",null,"口座種別","当座"]
["口座名義ﾌﾘｶﾞﾅ","ﾅｶﾊﾞﾔｼｹﾝｾﾂ.ｶ",null,"口座番号","0123456"]
["口座名義","中林建設株式会社",null,"口座名義ﾌﾘｶﾞﾅ","ﾅｶﾊﾞﾔｼｹﾝｾﾂ.ｶ"]
[null,null,null,"口座名義","中林建設株式会社"]

{"sheet":"【入力例・契約】指定請求書","index":4,"n_rows":56,"n_cols":66,"rows_kept":56,"cut":false,"hidden":false,"merged":[[51,38,52,44],[53,1,54,7],[55,38,56,44],[53,8,54,14],[53,17,54,23],[53,24,54,30],[53,31,54,37],[53,38,54,44],[55,1,56,7],[55,8,56,14],[55,17,56,23],[55,24,56,30],[55,31,56,37],[48,52,49,63],[48,64,49,67],[49,1,50,7],[49,8,50,14],[49,17,50,23],[49,24,50,30],[49,31,50,37],[49,38,50,44],[50,48,54,51],[50,52,54,55],[47,1,48,7],[47,8,48,14],[47,24,48,30],[47,31,48,37],[47,38,48,44],[48,48,49,51],[50,56,54,59],[50,60,54,63],[50,64,54,67],[51,1,52,7],[51,8,52,14],[51,17,52,23],[51,24,52,30],[51,31,52,37],[45,1,46,7],[45,8,46,14],[45,17,46,23],[45,24,46,30],[45,31,46,37],[45,38,46,44],[42,48,43,53],[42,54,43,67],[43,1,44,7],[43,8,44,14],[43,17,44,23],[43,24,44,30],[43,31,44,37],[43,38,44,44],[44,48,45,53],[44,54,45,67],[41,1,42,7],[41,8,42,14],[41,17,42,23],[41,24,42,30],[41,31,42,37],[41,38,42,44],[36,54,37,67],[38,48,39,53],[38,54,39,67],[39,1,40,7],[39,8,40,14],[39,24,40,30],[39,31,40,37],[39,38,40,44],[40,48,41,53],[40,54,41,67],[36,1,37,4],[36,5,37,7],[36,8,37,24],[36,25,37,27],[36,28,37,31],[36,32,37,36],[36,37,37,43],[36,44,37,44],[36,48,37,53],[32,54,33,67],[34,1,35,4],[34,5,35,7],[34,8,35,24],[34,25,35,27],[34,28,35,31],[34,32,35,36],[34,37,35,43],[34,44,35,44],[34,48,35,53],[34,54,35,67],[32,1,33,4],[32,5,33,7],[32,8,33,24],[32,25,33,27],[32,28,33,31],[32,32,33,36],[32,37,33,43],[32,44,33,44],[32,48,33,53],[28,54,29,67],[30,1,31,4],[30,5,31,7],[30,8,31,24],[30,25,31,27],[30,28,31,31],[30,32,31,36],[30,37,31,43],[30,44,31,44],[30,47,31,52],[28,1,29,4],[28,5,29,7],[28,8,29,24],[28,25,29,27],[28,28,29,31],[28,32,29,36],[28,37,29,43],[28,44,29,44],[28,48,29,53],[24,54,25,67],[26,1,27,4],[26,5,27,7],[26,8,27,24],[26,25,27,27],[26,28,27,31],[26,32,27,36],[26,37,27,43],[26,44,27,44],[26,48,27,53],[26,54,27,67],[24,1,25,4],[24,5,25,7],[24,8,25,24],[24,25,25,27],[24,28,25,31],[24,32,25,36],[24,37,25,43],[24,44,25,44],[24,48,25,53],[20,54,21,67],[22,1,23,4],[22,5,23,7],[22,8,23,24],[22,25,23,27],[22,28,23,31],[22,32,23,36],[22,37,23,43],[22,44,23,44],[22,48,23,53],[22,54,23,67],[20,1,21,4],[20,5,21,7],[20,8,21,24],[20,25,21,27],[20,28,21,31],[20,32,21,36],[20,37,21,43],[20,44,21,44],[20,48,21,53],[14,48,15,67],[16,47,17,52],[17,1,18,4],[17,5,18,9],[17,10,18,13],[17,14,18,18],[17,19,18,22],[17,23,18,25],[17,26,18,26],[18,37,19,44],[12,1,15,5],[12,6,15,26],[12,48,13,50],[12,51,13,57],[12,58,13,60],[12,61,13,67],[14,28,15,31],[14,32,15,35],[14,36,15,39],[14,41,15,46],[18,48,19,53],[18,54,19,67],[8,1,10,7],[8,8,10,26],[8,41,9,46],[8,48,9,62],[8,65,9,66],[10,41,11,46],[10,48,11,62],[3,2,4,14],[3,16,4,18],[3,24,5,39],[3,56,4,67],[6,1,7,14],[6,41,7,46],[6,48,7,62]]}
[]
[]
[]
[null,null,"中林建設株式会社",null,null,null,null,null,null,null,null,null,null,null,null,null,"御中",null,null,null,null,null,null,null,"請求書",null,null,null,null,null,null,null,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":"【入力例】基本データ!B9","v":"2023-06-30"}]
[]
[]
[null,"下記の通り請求致します。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"【入力例】基本データ!B12","v":"大阪市浪速区大国2-1-19"}]
[]
[null,"請求金額",null,null,null,null,null,null,{"$f":"SUM(AM42:AS47)","v":330000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"【入力例】基本データ!B13","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者職氏名",null,null,null,null,null,null,{"$f":"【入力例】基本データ!B14","v":"代表取締役社長　中林浩之"}]
[]
[null,"工事名称",null,null,null,null,{"$f":"【入力例】基本データ!B2","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,null,"TEL",null,null,{"$f":"【入力例】基本データ!B15","v":"06-6647-7583"},null,null,null,null,null,null,"FAX",null,null,{"$f":"【入力例】基本データ!B16","v":"06-6636-5775"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"LEFT(【入力例】基本データ!B17,2)&\" - \"&MID(【入力例】基本データ!B17,3,4)&\" - \"&MID(【入力例】基本データ!B17,7,4)&\" - \"&RIGHT(【入力例】基本データ!B17,4)","v":"T2 - 1200 - 0103 - 9288"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!B3=\"なし\",\"\",【入力例】基本データ!B4)","v":"B23601"},null,null,null,null,"工事番号",null,null,null,{"$f":"【入力例】基本データ!B6","v":"B236"},null,null,null,null,"手形比率",null,null,null,{"$f":"【入力例】基本データ!B7","v":60},null,null,"％"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"【入力例】基本データ!B21","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,"店名",null,null,null,null,null,{"$f":"【入力例】基本データ!B22","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,1,null,null,null,null,null,null,null,null,300000,null,null,null,null,null,null,null,null,null,null,"預金種目",null,null,null,null,null,{"$f":"【入力例】基本データ!B23","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,null,null,null,null,null,null,null,null,"口座番号",null,null,null,null,null,{"$f":"【入力例】基本データ!B24","v":"0123456"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"【入力例】基本データ!B25","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,null,null,null,null,null,null,null,null,"口座名義",null,null,null,null,null,{"$f":"【入力例】基本データ!B26","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,null,null,null,null,null,null,null,"【でんさい口座】"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!E21=\"\",\"\",【入力例】基本データ!E21)","v":"00000aaaa"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!E22=\"\",\"\",【入力例】基本データ!E22)","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,null,null,null,null,null,null,null,null,"店名",null,null,null,null,null,{"$f":"IF(【入力例】基本データ!E23=\"\",\"\",【入力例】基本データ!E23)","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,null,null,null,null,null,null,null,null,"預金種目",null,null,null,null,null,{"$f":"IF(【入力例】基本データ!E24=\"\",\"\",【入力例】基本データ!E24)","v":"当座"}]
[null,"契約金額",null,null,null,null,null,null,660000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"税抜金額",null,null,null,null,null,null,"消費税額",null,null,null,null,null,null,"税込金額"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!E25=\"\",\"\",【入力例】基本データ!E25)","v":"0123456"}]
[null,"前月迄出来高",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"当月課税10％対象",null,null,null,null,null,null,{"$f":"SUMIF(AS23:AS38,\"\",AL23:AR38)-I50+I52","v":300000},null,null,null,null,null,null,{"$f":"ROUND(Y42*0.1,0)+AF54","v":30000},null,null,null,null,null,null,{"$f":"SUM(Y42:AL43)","v":330000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!E26=\"\",\"\",【入力例】基本データ!E26)","v":"ﾅｶﾊﾞﾔｼｹﾝｾﾂ.ｶ"}]
[null,"当月出来高",null,null,null,null,null,null,300000,null,null,null,null,null,null,null,null,"当月課税 8％対象",null,null,null,null,null,null,{"$f":"SUMIF(AS23:AS38,\"※\",AL23:AR38)","v":0},null,null,null,null,null,null,{"$f":"ROUND(Y44*0.08,0)","v":0},null,null,null,null,null,null,{"$f":"SUM(Y44:AL45)","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,null,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":"IF(【入力例】基本データ!E27=\"\",\"\",【入力例】基本データ!E27)","v":"中林建設株式会社"}]
[null,"出来高累計",null,null,null,null,null,null,300000,null,null,null,null,null,null,null,null,"非・不課税",null,null,null,null,null,null,{"$f":"SUMIF(AS23:AS38,\"非\",AL23:AR38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y46:AL47)","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,null,"当月",null,null,null,null,null,null,"当月迄"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"部署長",null,null,null,"施工担当部",null,null,null,null,null,null,null,null,null,null,null,"所長"]
[null,"当月保留金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"税抜支払金額",null,null,null,null,null,null,null,null,null,null,null,null,null,300000,null,null,null,null,null,null,300000]
[]
[null,"当月保留金解除額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"消費税額",null,null,null,null,null,null,null,null,null,null,null,null,null,30000,null,null,null,null,null,null,30000]
[]
[null,"当月支払金額",null,null,null,null,null,null,{"$f":"IF(【入力例】基本データ!B3=\"なし\",\"\",I44-I50+I52)","v":300000},null,null,null,null,null,null,null,null,"消費税額調整額",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,"支払残",null,null,null,null,null,null,{"$f":"IF(OR(【入力例】基本データ!B3=\"あり（単価契約）\",【入力例】基本データ!B3=\"なし\"),\"\",I40-Y50-AF50)","v":360000},null,null,null,null,null,null,null,null,"税込支払金額",null,null,null,null,null,null,null,null,null,null,null,null,null,330000,null,null,null,null,null,null,330000]

{"sheet":"【入力例・非契約】指定請求書","index":5,"n_rows":56,"n_cols":66,"rows_kept":56,"cut":false,"hidden":false,"merged":[[51,38,52,44],[53,1,54,7],[55,38,56,44],[53,8,54,14],[53,17,54,23],[53,24,54,30],[53,31,54,37],[53,38,54,44],[55,1,56,7],[55,8,56,14],[55,17,56,23],[55,24,56,30],[55,31,56,37],[48,52,49,63],[48,64,49,67],[49,1,50,7],[49,8,50,14],[49,17,50,23],[49,24,50,30],[49,31,50,37],[49,38,50,44],[50,48,54,51],[50,52,54,55],[47,1,48,7],[47,8,48,14],[47,24,48,30],[47,31,48,37],[47,38,48,44],[48,48,49,51],[50,56,54,59],[50,60,54,63],[50,64,54,67],[51,1,52,7],[51,8,52,14],[51,17,52,23],[51,24,52,30],[51,31,52,37],[45,1,46,7],[45,8,46,14],[45,17,46,23],[45,24,46,30],[45,31,46,37],[45,38,46,44],[42,48,43,53],[42,54,43,67],[43,1,44,7],[43,8,44,14],[43,17,44,23],[43,24,44,30],[43,31,44,37],[43,38,44,44],[44,48,45,53],[44,54,45,67],[41,1,42,7],[41,8,42,14],[41,17,42,23],[41,24,42,30],[41,31,42,37],[41,38,42,44],[36,54,37,67],[38,48,39,53],[38,54,39,67],[39,1,40,7],[39,8,40,14],[39,24,40,30],[39,31,40,37],[39,38,40,44],[40,48,41,53],[40,54,41,67],[36,1,37,4],[36,5,37,7],[36,8,37,24],[36,25,37,27],[36,28,37,31],[36,32,37,36],[36,37,37,43],[36,44,37,44],[36,48,37,53],[32,54,33,67],[34,1,35,4],[34,5,35,7],[34,8,35,24],[34,25,35,27],[34,28,35,31],[34,32,35,36],[34,37,35,43],[34,44,35,44],[34,48,35,53],[34,54,35,67],[32,1,33,4],[32,5,33,7],[32,8,33,24],[32,25,33,27],[32,28,33,31],[32,32,33,36],[32,37,33,43],[32,44,33,44],[32,48,33,53],[28,54,29,67],[30,1,31,4],[30,5,31,7],[30,8,31,24],[30,25,31,27],[30,28,31,31],[30,32,31,36],[30,37,31,43],[30,44,31,44],[30,47,31,52],[28,1,29,4],[28,5,29,7],[28,8,29,24],[28,25,29,27],[28,28,29,31],[28,32,29,36],[28,37,29,43],[28,44,29,44],[28,48,29,53],[24,54,25,67],[26,1,27,4],[26,5,27,7],[26,8,27,24],[26,25,27,27],[26,28,27,31],[26,32,27,36],[26,37,27,43],[26,44,27,44],[26,48,27,53],[26,54,27,67],[24,1,25,4],[24,5,25,7],[24,8,25,24],[24,25,25,27],[24,28,25,31],[24,32,25,36],[24,37,25,43],[24,44,25,44],[24,48,25,53],[20,54,21,67],[22,1,23,4],[22,5,23,7],[22,8,23,24],[22,25,23,27],[22,28,23,31],[22,32,23,36],[22,37,23,43],[22,44,23,44],[22,48,23,53],[22,54,23,67],[20,1,21,4],[20,5,21,7],[20,8,21,24],[20,25,21,27],[20,28,21,31],[20,32,21,36],[20,37,21,43],[20,44,21,44],[20,48,21,53],[14,48,15,67],[16,47,17,52],[17,1,18,4],[17,5,18,9],[17,10,18,13],[17,14,18,18],[17,19,18,22],[17,23,18,25],[17,26,18,26],[18,37,19,44],[12,1,15,5],[12,6,15,26],[12,48,13,50],[12,51,13,57],[12,58,13,60],[12,61,13,67],[14,28,15,31],[14,32,15,35],[14,36,15,39],[14,41,15,46],[18,48,19,53],[18,54,19,67],[8,1,10,7],[8,8,10,26],[8,41,9,46],[8,48,9,62],[8,65,9,66],[10,41,11,46],[10,48,11,62],[3,2,4,14],[3,16,4,18],[3,24,5,39],[3,56,4,67],[6,1,7,14],[6,41,7,46],[6,48,7,62]]}
[]
[]
[]
[null,null,"中林建設株式会社",null,null,null,null,null,null,null,null,null,null,null,null,null,"御中",null,null,null,null,null,null,null,"請求書",null,null,null,null,null,null,null,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":"【入力例】基本データ!B9","v":"2023-06-30"}]
[]
[]
[null,"下記の通り請求致します。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"【入力例】基本データ!B12","v":"大阪市浪速区大国2-1-19"}]
[]
[null,"請求金額",null,null,null,null,null,null,{"$f":"SUM(AM42:AS47)","v":184000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"【入力例】基本データ!B13","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者職氏名",null,null,null,null,null,null,{"$f":"【入力例】基本データ!B14","v":"代表取締役社長　中林浩之"}]
[]
[null,"工事名称",null,null,null,null,{"$f":"【入力例】基本データ!B2","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,null,"TEL",null,null,{"$f":"【入力例】基本データ!B15","v":"06-6647-7583"},null,null,null,null,null,null,"FAX",null,null,{"$f":"【入力例】基本データ!B16","v":"06-6636-5775"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"LEFT(【入力例】基本データ!B17,2)&\" - \"&MID(【入力例】基本データ!B17,3,4)&\" - \"&MID(【入力例】基本データ!B17,7,4)&\" - \"&RIGHT(【入力例】基本データ!B17,4)","v":"T2 - 1200 - 0103 - 9288"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!B3=\"なし\",\"\",【入力例】基本データ!B4)","v":"B23601"},null,null,null,null,"工事番号",null,null,null,{"$f":"【入力例】基本データ!B6","v":"B236"},null,null,null,null,"手形比率",null,null,null,{"$f":"【入力例】基本データ!B7","v":60},null,null,"％"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"【入力例】基本データ!B21","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,"店名",null,null,null,null,null,{"$f":"【入力例】基本データ!B22","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,1,null,null,null,null,null,null,null,null,100100,null,null,null,null,null,null,null,null,null,null,"預金種目",null,null,null,null,null,{"$f":"【入力例】基本データ!B23","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,1,null,null,null,null,null,null,null,null,50000,null,null,null,null,null,null,"※",null,null,null,"口座番号",null,null,null,null,null,{"$f":"【入力例】基本データ!B24","v":"0123456"}]
[]
[null,null,null,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,null,null,null,null,null,null,null,20000,null,null,null,null,null,null,"非",null,null,null,"フリガナ",null,null,null,null,null,{"$f":"【入力例】基本データ!B25","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,1,null,null,null,null,null,null,null,null,-100,null,null,null,null,null,null,null,null,null,null,"口座名義",null,null,null,null,null,{"$f":"【入力例】基本データ!B26","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,null,null,null,null,null,null,null,"【でんさい口座】"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!E21=\"\",\"\",【入力例】基本データ!E21)","v":"00000aaaa"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!E22=\"\",\"\",【入力例】基本データ!E22)","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,null,null,null,null,null,null,null,null,"店名",null,null,null,null,null,{"$f":"IF(【入力例】基本データ!E23=\"\",\"\",【入力例】基本データ!E23)","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,null,null,null,null,null,null,null,null,"預金種目",null,null,null,null,null,{"$f":"IF(【入力例】基本データ!E24=\"\",\"\",【入力例】基本データ!E24)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!E25=\"\",\"\",【入力例】基本データ!E25)","v":"0123456"}]
[null,"前月迄出来高",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"当月課税10％対象",null,null,null,null,null,null,{"$f":"SUMIF(AS23:AS38,\"\",AL23:AR38)-I50+I52","v":100000},null,null,null,null,null,null,{"$f":"ROUND(Y42*0.1,0)+AF54","v":10000},null,null,null,null,null,null,{"$f":"SUM(Y42:AL43)","v":110000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!E26=\"\",\"\",【入力例】基本データ!E26)","v":"ﾅｶﾊﾞﾔｼｹﾝｾﾂ.ｶ"}]
[null,"当月出来高",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"当月課税 8％対象",null,null,null,null,null,null,{"$f":"SUMIF(AS23:AS38,\"※\",AL23:AR38)","v":50000},null,null,null,null,null,null,{"$f":"ROUND(Y44*0.08,0)","v":4000},null,null,null,null,null,null,{"$f":"SUM(Y44:AL45)","v":54000}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"IF(【入力例】基本データ!E27=\"\",\"\",【入力例】基本データ!E27)","v":"中林建設株式会社"}]
[null,"出来高累計",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"非・不課税",null,null,null,null,null,null,{"$f":"SUMIF(AS23:AS38,\"非\",AL23:AR38)","v":20000},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y46:AL47)","v":20000}]
[]
[null,"前月迄保留金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"前月迄",null,null,null,null,null,null,"当月",null,null,null,null,null,null,"当月迄"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"部署長",null,null,null,"施工担当部",null,null,null,null,null,null,null,null,null,null,null,"所長"]
[null,"当月保留金",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"税抜支払金額"]
[]
[null,"当月保留金解除額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"消費税額"]
[]
[null,"当月支払金額",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"消費税額調整額"]
[]
[null,"支払残",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"税込支払金額"]

{"sheet":"【入力例1】出来高内訳書","index":6,"n_rows":23,"n_cols":16,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,2,0,15],[1,13,1,15],[2,10,2,11]]}
[null,null,"①契約内容を入力してください。各項目ごとに集計する場合は、費目欄に「小計」と入力し、小計の列を含めNo.欄に数字を入力してください。\n　最後に費目欄に「合計」の入力もお願いします（【入力例1】参照）。合計のみの場合はNo.欄に数字を入力しないでください（【入力例2】参照）。\n　金額欄は「計算」ボタンを押せば自動で計算します。\n②今月が2回目以降の請求であれば、「月を更新」ボタンを押してください。\n③出来高累計欄（非契約の場合は当月出来高欄）の数量を入力してください。一式の項目は、金額も入力してください。\n④「計算」ボタンを押してください。入力漏れがなければ、「印刷」ボタンを押してください。\n※注意※　一度ボタンを押すと元に戻すことができません！"]
[null,null,null,null,null,"出来高内訳書",null,null,null,null,null,null,null,{"$f":"【入力例】基本データ!B9","v":"2023-06-30"}]
[null,"工事名称",{"$f":"【入力例】基本データ!B2","v":"○○○○○工事"},null,null,null,null,null,null,null,"協力業者名",null,{"$f":"【入力例】基本データ!B13","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,"契約残額"]
["No.","費目","細目","単位","単価","数量","金額","数量","金額","数量","金額","数量","金額","数量","金額","※"]
[1,"土工事"]
[1,"○",null,"ｍ3",1000,150.4,150400,null,null,50,50000,50,50000,100.4,100400]
[1,"○",null,"ｍ3",1500,60.8,91200,null,null,30.8,46200,30.8,46200,29.999999999999996,45000]
[1,"○",null,"ｍ3",2000,10.220000000000001,20440,null,null,5.91,11820,5.91,11820,4.3100000000000005,8620]
[1,"値引",null,"式",-2040,1,-2040,null,null,1,-20,1,-20,1,-2020]
[1,"小計",null,null,null,null,260000,null,null,null,108000,null,108000,null,152000]
[]
[2,"舗装工事"]
[2,"□",null,"ｍ2",1200,400,480000,null,null,200,240000,200,240000,200,240000]
[2,"□",null,"ｍ2",1500,600,900000,null,null,300,450000,300,450000,300,450000]
[2,"□",null,"ｍ2",3500,24,84000,null,null,24,84000,24,84000,0,0]
[2,"現場管理費",null,"式",580000,1,580000,null,null,1,300000,1,300000,1,280000]
[2,"法定福利費",null,"式",100000,1,100000,null,null,1,60000,1,60000,1,40000]
[2,"値引",null,"式",-4000,1,-4000,null,null,1,-4000,1,-4000,0,0]
[2,"小計",null,null,null,null,2140000,null,null,null,1130000,null,1130000,null,1010000]
[]
[null,"合計",null,null,null,null,2400000,null,null,null,1238000,null,1238000,null,1162000]

{"sheet":"【入力例2】出来高内訳書","index":7,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,2,0,15],[1,13,1,15],[2,10,2,11]]}
[null,null,"①契約内容を入力してください。各項目ごとに集計する場合は、費目欄に「小計」と入力し、小計の列を含めNo.欄に数字を入力してください。\n　最後に費目欄に「合計」の入力もお願いします（【入力例1】参照）。合計のみの場合はNo.欄に数字を入力しないでください（【入力例2】参照）。\n　金額欄は「計算」ボタンを押せば自動で計算します。\n②今月が2回目以降の請求であれば、「月を更新」ボタンを押してください。\n③出来高累計欄（非契約の場合は当月出来高欄）の数量を入力してください。一式の項目は、金額も入力してください。\n④「計算」ボタンを押してください。入力漏れがなければ、「印刷」ボタンを押してください。\n※注意※　一度ボタンを押すと元に戻すことができません！"]
[null,null,null,null,null,"出来高内訳書",null,null,null,null,null,null,null,{"$f":"【入力例】基本データ!B9","v":"2023-06-30"}]
[null,"工事名称",{"$f":"【入力例】基本データ!B2","v":"○○○○○工事"},null,null,null,null,null,null,null,"協力業者名",null,{"$f":"【入力例】基本データ!B13","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,"契約残額"]
["No.","費目","細目","単位","単価","数量","金額","数量","金額","数量","金額","数量","金額","数量","金額","※"]
[null,"土工事"]
[null,"○",null,"ｍ3",1000,150.4,150400,null,null,50,50000,50,50000,100.4,100400]
[null,"○",null,"ｍ3",1500,60.8,91200,null,null,30.8,46200,30.8,46200,29.999999999999996,45000]
[null,"○",null,"ｍ3",2000,10.220000000000001,20440,null,null,5.91,11820,5.91,11820,4.3100000000000005,8620]
[null,"○",null,"ｍ3",500,100,50000,null,null,50,25000,50,25000,50,25000]
[null,"諸経費",null,"式",300000,1,300000,null,null,1,140000,1,140000,1,160000]
[null,"法定福利費",null,"式",50000,1,50000,null,null,1,27000,1,27000,1,23000]
[null,"値引",null,"式",-2040,1,-2040,null,null,1,-20,1,-20,1,-2020]
[]
[null,"合計",null,null,null,null,{"$f":"SUM(G7:G15)","v":660000},null,null,null,{"$f":"SUM(K7:K15)","v":300000},null,{"$f":"SUM(M7:M15)","v":300000},null,{"$f":"SUM(O7:O15)","v":360000}]