{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["基本データ","指定請求書","出来高内訳書","【入力例】基本データ","【入力例・契約】指定請求書","【入力例・非契約】指定請求書","【入力例1】出来高内訳書","【入力例2】出来高内訳書"],"not_rendered":{"macros":1,"defined_names":3},"read":"whole","date_system":"1900"}

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

{"sheet":"指定請求書","index":1,"n_rows":56,"n_cols":66,"rows_kept":56,"merged":[[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],[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],[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],[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],[18,48,19,53],[18,54,19,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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[41,1,42,7],[41,8,42,14],[41,17,42,23],[41,24,42,30],[41,31,42,37],[41,38,42,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],[45,1,46,7],[45,8,46,14],[45,17,46,23],[45,24,46,30],[45,31,46,37],[45,38,46,44],[47,1,48,7],[47,8,48,14],[47,24,48,30],[47,31,48,37],[47,38,48,44],[48,48,49,51],[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],[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],[51,38,52,44],[53,1,54,7],[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],[55,38,56,44]]}
[]
[]
[]
[null,null,"株式会社ＮＳフォスター",{"$nulls":13},"御中",{"$nulls":7},"請求書",{"$nulls":31},{"$f":"IF(基本データ!B9=\"\",\"年　　月　　日締請求\",基本データ!B9)","v":"年　　月　　日締請求"}]
[]
[]
[null,"下記の通り請求致します。",{"$nulls":39},"住所",{"$nulls":6},{"$f":"IF(基本データ!B12=\"\",\"\",基本データ!B12)","v":""}]
[]
[null,"請求金額",{"$nulls":6},{"$f":"SUM(AM42:AS47)","v":{"v":0,"d":"¥0.-"}},{"$nulls":32},"会社名",{"$nulls":6},{"$f":"IF(基本データ!B13=\"\",\"\",基本データ!B13)","v":""},{"$nulls":16},"印"]
[]
[{"$nulls":41},"代表者職氏名",{"$nulls":6},{"$f":"IF(基本データ!B14=\"\",\"\",基本データ!B14)","v":""}]
[]
[null,"工事名称",{"$nulls":4},{"$f":"IF(基本データ!B2=\"\",\"\",基本データ!B2)","v":""},{"$nulls":41},"TEL",null,null,{"$f":"IF(基本データ!B15=\"\",\"\",基本データ!B15)","v":""},{"$nulls":6},"FAX",null,null,{"$f":"IF(基本データ!B16=\"\",\"\",基本データ!B16)","v":""}]
[]
[{"$nulls":28},"契　約",{"$nulls":3},"非契約",{"$nulls":3},"単価契約",{"$nulls":4},"登録番号",{"$nulls":6},{"$f":"LEFT(基本データ!B17,2)&\" - \"&MID(基本データ!B17,3,4)&\" - \"&MID(基本データ!B17,7,4)&\" - \"&RIGHT(基本データ!B17,4)","v":" -  -  - "}]
[]
[{"$nulls":47},"【振込銀行口座】"]
[null,"注文番号",{"$nulls":3},{"$f":"IF(OR(基本データ!B3=\"なし\",基本データ!B3=\"\"),\"\",基本データ!B4)","v":""},{"$nulls":4},"工事番号",{"$nulls":3},{"$f":"IF(基本データ!B6=\"\",\"\",基本データ!B6)","v":""},{"$nulls":4},"手形比率",{"$nulls":3},{"$f":"基本データ!B7","v":0},null,null,"％"]
[{"$nulls":37},"※は軽減税率対象",{"$nulls":10},"金融機関名",{"$nulls":5},{"$f":"IF(基本データ!B21=\"\",\"\",基本データ!B21)","v":""}]
[]
[null,"工種ｺｰﾄﾞ",{"$nulls":3},"日付",null,null,"品名等",{"$nulls":16},"単位",null,null,"数量",{"$nulls":3},"単価",{"$nulls":4},"税抜金額",{"$nulls":6},"※",{"$nulls":3},"店名",{"$nulls":5},{"$f":"IF(基本データ!B22=\"\",\"\",基本データ!B22)","v":""}]
[]
[{"$nulls":48},"預金種目",{"$nulls":5},{"$f":"IF(基本データ!B23=\"\",\"\",基本データ!B23)","v":""}]
[]
[{"$nulls":48},"口座番号",{"$nulls":5},{"$f":"IF(基本データ!B24=\"\",\"\",基本データ!B24)","v":""}]
[]
[{"$nulls":48},"フリガナ",{"$nulls":5},{"$f":"IF(基本データ!B25=\"\",\"\",基本データ!B25)","v":""}]
[]
[{"$nulls":48},"口座名義",{"$nulls":5},{"$f":"IF(基本データ!B26=\"\",\"\",基本データ!B26)","v":""}]
[]
[{"$nulls":47},"【でんさい口座】"]
[]
[{"$nulls":48},"でんさい利用者番号",{"$nulls":5},{"$f":"IF(基本データ!E21=\"\",\"\",基本データ!E21)","v":""}]
[]
[{"$nulls":48},"金融機関名",{"$nulls":5},{"$f":"IF(基本データ!E22=\"\",\"\",基本データ!E22)","v":""}]
[]
[{"$nulls":48},"店名",{"$nulls":5},{"$f":"IF(基本データ!E23=\"\",\"\",基本データ!E23)","v":""}]
[]
[{"$nulls":48},"預金種目",{"$nulls":5},{"$f":"IF(基本データ!E24=\"\",\"\",基本データ!E24)","v":""}]
[null,"契約金額",{"$nulls":22},"税抜金額",{"$nulls":6},"消費税額",{"$nulls":6},"税込金額"]
[{"$nulls":48},"口座番号",{"$nulls":5},{"$f":"IF(基本データ!E25=\"\",\"\",基本データ!E25)","v":""}]
[null,"前月迄出来高",{"$nulls":15},"当月課税10％対象",{"$nulls":6},{"$f":"SUMIF(AS23:AS38,\"\",AL23:AR38)-I50+I52","v":{"v":0,"d":"0 "}},{"$nulls":6},{"$f":"ROUND(Y42*0.1,0)+AF54","v":{"v":0,"d":"0 "}},{"$nulls":6},{"$f":"SUM(Y42:AL43)","v":{"v":0,"d":"0 "}}]
[{"$nulls":48},"フリガナ",{"$nulls":5},{"$f":"IF(基本データ!E26=\"\",\"\",基本データ!E26)","v":""}]
[null,"当月出来高",{"$nulls":15},"当月課税 8％対象",{"$nulls":6},{"$f":"SUMIF(AS23:AS38,\"※\",AL23:AR38)","v":{"v":0,"d":"0 "}},{"$nulls":6},{"$f":"ROUND(Y44*0.08,0)","v":{"v":0,"d":"0 "}},{"$nulls":6},{"$f":"SUM(Y44:AL45)","v":{"v":0,"d":"0 "}}]
[{"$nulls":48},"口座名義",{"$nulls":5},{"$f":"IF(基本データ!E27=\"\",\"\",基本データ!E27)","v":""}]
[null,"出来高累計",{"$nulls":15},"非・不課税",{"$nulls":6},{"$f":"SUMIF(AS23:AS38,\"非\",AL23:AR38)","v":{"v":0,"d":"0 "}},{"$nulls":13},{"$f":"SUM(Y46:AL47)","v":{"v":0,"d":"0 "}}]
[]
[null,"前月迄保留金",{"$nulls":22},"前月迄",{"$nulls":6},"当月",{"$nulls":6},"当月迄"]
[{"$nulls":48},"部署長",{"$nulls":3},"施工担当部",{"$nulls":11},"所長"]
[null,"当月保留金",{"$nulls":15},"税抜支払金額"]
[]
[null,"当月保留金解除額",{"$nulls":15},"消費税額"]
[]
[null,"当月支払金額",{"$nulls":6},{"$f":"IF(基本データ!B3=\"なし\",\"\",I44-I50+I52)","v":{"v":0,"d":"0 "}},{"$nulls":8},"消費税額調整額"]
[]
[null,"支払残",{"$nulls":6},{"$f":"IF(OR(基本データ!B3=\"あり（単価契約）\",基本データ!B3=\"なし\"),\"\",I40-Y50-AF50)","v":{"v":0,"d":"0 "}},{"$nulls":8},"税込支払金額"]

{"sheet":"出来高内訳書","index":2,"n_rows":6,"n_cols":16,"rows_kept":6,"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※注意※　一度ボタンを押すと元に戻すことができません！"]
[{"$nulls":5},"出来高内訳書",{"$nulls":7},{"$f":"基本データ!B9","v":"00:00:00"}]
[null,"工事名称",{"$f":"基本データ!B2","v":0},{"$nulls":7},"協力業者名",null,{"$f":"基本データ!B13","v":0}]
[{"$nulls":15},"※は軽減税率対象"]
[{"$nulls":4},"契約金額",null,null,"前月迄出来高",null,"当月出来高",null,"出来高累計",null,"契約残額"]
["No.","費目","細目","単位","単価","数量","金額","数量","金額","数量","金額","数量","金額","数量","金額","※"]

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

{"sheet":"【入力例・契約】指定請求書","index":4,"n_rows":56,"n_cols":66,"rows_kept":56,"merged":[[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],[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],[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],[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],[18,48,19,53],[18,54,19,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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[41,1,42,7],[41,8,42,14],[41,17,42,23],[41,24,42,30],[41,31,42,37],[41,38,42,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],[45,1,46,7],[45,8,46,14],[45,17,46,23],[45,24,46,30],[45,31,46,37],[45,38,46,44],[47,1,48,7],[47,8,48,14],[47,24,48,30],[47,31,48,37],[47,38,48,44],[48,48,49,51],[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],[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],[51,38,52,44],[53,1,54,7],[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],[55,38,56,44]]}
[]
[]
[]
[null,null,"株式会社ＮＳフォスター",{"$nulls":13},"御中",{"$nulls":7},"請求書",{"$nulls":31},{"$f":"【入力例】基本データ!B9","v":"2023-06-30"}]
[]
[]
[null,"下記の通り請求致します。",{"$nulls":39},"住所",{"$nulls":6},{"$f":"【入力例】基本データ!B12","v":"大阪市浪速区大国2-1-19"}]
[]
[null,"請求金額",{"$nulls":6},{"$f":"SUM(AM42:AS47)","v":{"v":330000,"d":"¥330,000.-"}},{"$nulls":32},"会社名",{"$nulls":6},{"$f":"【入力例】基本データ!B13","v":"○○株式会社"},{"$nulls":16},"印"]
[]
[{"$nulls":41},"代表者職氏名",{"$nulls":6},{"$f":"【入力例】基本データ!B14","v":"代表取締役　○○○○"}]
[]
[null,"工事名称",{"$nulls":4},{"$f":"【入力例】基本データ!B2","v":"○○○○○工事"},{"$nulls":41},"TEL",null,null,{"$f":"【入力例】基本データ!B15","v":"06-1111-1111"},{"$nulls":6},"FAX",null,null,{"$f":"【入力例】基本データ!B16","v":"06-2222-2222"}]
[]
[{"$nulls":28},"契　約",{"$nulls":3},"非契約",{"$nulls":3},"単価契約",{"$nulls":4},"登録番号",{"$nulls":6},{"$f":"LEFT(【入力例】基本データ!B17,2)&\" - \"&MID(【入力例】基本データ!B17,3,4)&\" - \"&MID(【入力例】基本データ!B17,7,4)&\" - \"&RIGHT(【入力例】基本データ!B17,4)","v":"T1 - 2345 - 6789 - 0123"}]
[]
[{"$nulls":47},"【振込銀行口座】"]
[null,"注文番号",{"$nulls":3},{"$f":"IF(【入力例】基本データ!B3=\"なし\",\"\",【入力例】基本データ!B4)","v":"B23601"},{"$nulls":4},"工事番号",{"$nulls":3},{"$f":"【入力例】基本データ!B6","v":"B236"},{"$nulls":4},"手形比率",{"$nulls":3},{"$f":"【入力例】基本データ!B7","v":60},null,null,"％"]
[{"$nulls":37},"※は軽減税率対象",{"$nulls":10},"金融機関名",{"$nulls":5},{"$f":"【入力例】基本データ!B21","v":"A銀行"}]
[]
[null,"工種ｺｰﾄﾞ",{"$nulls":3},"日付",null,null,"品名等",{"$nulls":16},"単位",null,null,"数量",{"$nulls":3},"単価",{"$nulls":4},"税抜金額",{"$nulls":6},"※",{"$nulls":3},"店名",{"$nulls":5},{"$f":"【入力例】基本データ!B22","v":"B支店"}]
[]
[{"$nulls":8},"土工事",{"$nulls":16},"式",null,null,{"v":1,"d":"1 "},{"$nulls":8},{"v":300000,"d":"300,000 "},{"$nulls":10},"預金種目",{"$nulls":5},{"$f":"【入力例】基本データ!B23","v":"当座"}]
[]
[{"$nulls":48},"口座番号",{"$nulls":5},{"$f":"【入力例】基本データ!B24","v":"1234567"}]
[]
[{"$nulls":48},"フリガナ",{"$nulls":5},{"$f":"【入力例】基本データ!B25","v":"ﾏﾙﾏﾙ.ｶ"}]
[]
[{"$nulls":48},"口座名義",{"$nulls":5},{"$f":"【入力例】基本データ!B26","v":"○○株式会社"}]
[]
[{"$nulls":47},"【でんさい口座】"]
[]
[{"$nulls":48},"でんさい利用者番号",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E21=\"\",\"\",【入力例】基本データ!E21)","v":"00000aaaa"}]
[]
[{"$nulls":48},"金融機関名",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E22=\"\",\"\",【入力例】基本データ!E22)","v":"A銀行"}]
[]
[{"$nulls":48},"店名",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E23=\"\",\"\",【入力例】基本データ!E23)","v":"B支店"}]
[]
[{"$nulls":48},"預金種目",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E24=\"\",\"\",【入力例】基本データ!E24)","v":"当座"}]
[null,"契約金額",{"$nulls":6},{"v":660000,"d":"660,000 "},{"$nulls":15},"税抜金額",{"$nulls":6},"消費税額",{"$nulls":6},"税込金額"]
[{"$nulls":48},"口座番号",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E25=\"\",\"\",【入力例】基本データ!E25)","v":"1234567"}]
[null,"前月迄出来高",{"$nulls":15},"当月課税10％対象",{"$nulls":6},{"$f":"SUMIF(AS23:AS38,\"\",AL23:AR38)-I50+I52","v":{"v":300000,"d":"300,000 "}},{"$nulls":6},{"$f":"ROUND(Y42*0.1,0)+AF54","v":{"v":30000,"d":"30,000 "}},{"$nulls":6},{"$f":"SUM(Y42:AL43)","v":{"v":330000,"d":"330,000 "}}]
[{"$nulls":48},"フリガナ",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E26=\"\",\"\",【入力例】基本データ!E26)","v":"ﾏﾙﾏﾙ.ｶ"}]
[null,"当月出来高",{"$nulls":6},{"v":300000,"d":"300,000 "},{"$nulls":8},"当月課税 8％対象",{"$nulls":6},{"$f":"SUMIF(AS23:AS38,\"※\",AL23:AR38)","v":{"v":0,"d":"0 "}},{"$nulls":6},{"$f":"ROUND(Y44*0.08,0)","v":{"v":0,"d":"0 "}},{"$nulls":6},{"$f":"SUM(Y44:AL45)","v":{"v":0,"d":"0 "}}]
[{"$nulls":48},"口座名義",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E27=\"\",\"\",【入力例】基本データ!E27)","v":"○○株式会社"}]
[null,"出来高累計",{"$nulls":6},{"v":300000,"d":"300,000 "},{"$nulls":8},"非・不課税",{"$nulls":6},{"$f":"SUMIF(AS23:AS38,\"非\",AL23:AR38)","v":{"v":0,"d":"0 "}},{"$nulls":13},{"$f":"SUM(Y46:AL47)","v":{"v":0,"d":"0 "}}]
[]
[null,"前月迄保留金",{"$nulls":22},"前月迄",{"$nulls":6},"当月",{"$nulls":6},"当月迄"]
[{"$nulls":48},"部署長",{"$nulls":3},"施工担当部",{"$nulls":11},"所長"]
[null,"当月保留金",{"$nulls":15},"税抜支払金額",{"$nulls":13},{"v":300000,"d":"300,000 "},{"$nulls":6},{"v":300000,"d":"300,000 "}]
[]
[null,"当月保留金解除額",{"$nulls":15},"消費税額",{"$nulls":13},{"v":30000,"d":"30,000 "},{"$nulls":6},{"v":30000,"d":"30,000 "}]
[]
[null,"当月支払金額",{"$nulls":6},{"$f":"IF(【入力例】基本データ!B3=\"なし\",\"\",I44-I50+I52)","v":{"v":300000,"d":"300,000 "}},{"$nulls":8},"消費税額調整額",{"$nulls":13},{"v":0,"d":"0 "}]
[]
[null,"支払残",{"$nulls":6},{"$f":"IF(OR(【入力例】基本データ!B3=\"あり（単価契約）\",【入力例】基本データ!B3=\"なし\"),\"\",I40-Y50-AF50)","v":{"v":360000,"d":"360,000 "}},{"$nulls":8},"税込支払金額",{"$nulls":13},{"v":330000,"d":"330,000 "},{"$nulls":6},{"v":330000,"d":"330,000 "}]

{"sheet":"【入力例・非契約】指定請求書","index":5,"n_rows":56,"n_cols":66,"rows_kept":56,"merged":[[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],[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],[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],[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],[18,48,19,53],[18,54,19,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],[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],[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],[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],[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],[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],[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],[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],[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],[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],[41,1,42,7],[41,8,42,14],[41,17,42,23],[41,24,42,30],[41,31,42,37],[41,38,42,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],[45,1,46,7],[45,8,46,14],[45,17,46,23],[45,24,46,30],[45,31,46,37],[45,38,46,44],[47,1,48,7],[47,8,48,14],[47,24,48,30],[47,31,48,37],[47,38,48,44],[48,48,49,51],[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],[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],[51,38,52,44],[53,1,54,7],[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],[55,38,56,44]]}
[]
[]
[]
[null,null,"株式会社ＮＳフォスター",{"$nulls":13},"御中",{"$nulls":7},"請求書",{"$nulls":31},{"$f":"【入力例】基本データ!B9","v":"2023-06-30"}]
[]
[]
[null,"下記の通り請求致します。",{"$nulls":39},"住所",{"$nulls":6},{"$f":"【入力例】基本データ!B12","v":"大阪市浪速区大国2-1-19"}]
[]
[null,"請求金額",{"$nulls":6},{"$f":"SUM(AM42:AS47)","v":{"v":184000,"d":"¥184,000.-"}},{"$nulls":32},"会社名",{"$nulls":6},{"$f":"【入力例】基本データ!B13","v":"○○株式会社"},{"$nulls":16},"印"]
[]
[{"$nulls":41},"代表者職氏名",{"$nulls":6},{"$f":"【入力例】基本データ!B14","v":"代表取締役　○○○○"}]
[]
[null,"工事名称",{"$nulls":4},{"$f":"【入力例】基本データ!B2","v":"○○○○○工事"},{"$nulls":41},"TEL",null,null,{"$f":"【入力例】基本データ!B15","v":"06-1111-1111"},{"$nulls":6},"FAX",null,null,{"$f":"【入力例】基本データ!B16","v":"06-2222-2222"}]
[]
[{"$nulls":28},"契　約",{"$nulls":3},"非契約",{"$nulls":3},"単価契約",{"$nulls":4},"登録番号",{"$nulls":6},{"$f":"LEFT(【入力例】基本データ!B17,2)&\" - \"&MID(【入力例】基本データ!B17,3,4)&\" - \"&MID(【入力例】基本データ!B17,7,4)&\" - \"&RIGHT(【入力例】基本データ!B17,4)","v":"T1 - 2345 - 6789 - 0123"}]
[]
[{"$nulls":47},"【振込銀行口座】"]
[null,"注文番号",{"$nulls":3},{"$f":"IF(【入力例】基本データ!B3=\"なし\",\"\",【入力例】基本データ!B4)","v":"B23601"},{"$nulls":4},"工事番号",{"$nulls":3},{"$f":"【入力例】基本データ!B6","v":"B236"},{"$nulls":4},"手形比率",{"$nulls":3},{"$f":"【入力例】基本データ!B7","v":60},null,null,"％"]
[{"$nulls":37},"※は軽減税率対象",{"$nulls":10},"金融機関名",{"$nulls":5},{"$f":"【入力例】基本データ!B21","v":"A銀行"}]
[]
[null,"工種ｺｰﾄﾞ",{"$nulls":3},"日付",null,null,"品名等",{"$nulls":16},"単位",null,null,"数量",{"$nulls":3},"単価",{"$nulls":4},"税抜金額",{"$nulls":6},"※",{"$nulls":3},"店名",{"$nulls":5},{"$f":"【入力例】基本データ!B22","v":"B支店"}]
[]
[{"$nulls":8},"別紙明細書通り",{"$nulls":16},"式",null,null,{"v":1,"d":"1 "},{"$nulls":8},{"v":100100,"d":"100,100 "},{"$nulls":10},"預金種目",{"$nulls":5},{"$f":"【入力例】基本データ!B23","v":"当座"}]
[]
[{"$nulls":25},"式",null,null,{"v":1,"d":"1 "},{"$nulls":8},{"v":50000,"d":"50,000 "},{"$nulls":6},"※",{"$nulls":3},"口座番号",{"$nulls":5},{"$f":"【入力例】基本データ!B24","v":"1234567"}]
[]
[{"$nulls":25},"式",null,null,{"v":1,"d":"1 "},{"$nulls":8},{"v":20000,"d":"20,000 "},{"$nulls":6},"非",{"$nulls":3},"フリガナ",{"$nulls":5},{"$f":"【入力例】基本データ!B25","v":"ﾏﾙﾏﾙ.ｶ"}]
[]
[{"$nulls":8},"値引",{"$nulls":16},"式",null,null,{"v":1,"d":"1 "},{"$nulls":8},{"v":-100,"d":"(100)"},{"$nulls":10},"口座名義",{"$nulls":5},{"$f":"【入力例】基本データ!B26","v":"○○株式会社"}]
[]
[{"$nulls":47},"【でんさい口座】"]
[]
[{"$nulls":48},"でんさい利用者番号",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E21=\"\",\"\",【入力例】基本データ!E21)","v":"00000aaaa"}]
[]
[{"$nulls":48},"金融機関名",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E22=\"\",\"\",【入力例】基本データ!E22)","v":"A銀行"}]
[]
[{"$nulls":48},"店名",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E23=\"\",\"\",【入力例】基本データ!E23)","v":"B支店"}]
[]
[{"$nulls":48},"預金種目",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E24=\"\",\"\",【入力例】基本データ!E24)","v":"当座"}]
[null,"契約金額",{"$nulls":22},"税抜金額",{"$nulls":6},"消費税額",{"$nulls":6},"税込金額"]
[{"$nulls":48},"口座番号",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E25=\"\",\"\",【入力例】基本データ!E25)","v":"1234567"}]
[null,"前月迄出来高",{"$nulls":15},"当月課税10％対象",{"$nulls":6},{"$f":"SUMIF(AS23:AS38,\"\",AL23:AR38)-I50+I52","v":{"v":100000,"d":"100,000 "}},{"$nulls":6},{"$f":"ROUND(Y42*0.1,0)+AF54","v":{"v":10000,"d":"10,000 "}},{"$nulls":6},{"$f":"SUM(Y42:AL43)","v":{"v":110000,"d":"110,000 "}}]
[{"$nulls":48},"フリガナ",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E26=\"\",\"\",【入力例】基本データ!E26)","v":"ﾏﾙﾏﾙ.ｶ"}]
[null,"当月出来高",{"$nulls":15},"当月課税 8％対象",{"$nulls":6},{"$f":"SUMIF(AS23:AS38,\"※\",AL23:AR38)","v":{"v":50000,"d":"50,000 "}},{"$nulls":6},{"$f":"ROUND(Y44*0.08,0)","v":{"v":4000,"d":"4,000 "}},{"$nulls":6},{"$f":"SUM(Y44:AL45)","v":{"v":54000,"d":"54,000 "}}]
[{"$nulls":48},"口座名義",{"$nulls":5},{"$f":"IF(【入力例】基本データ!E27=\"\",\"\",【入力例】基本データ!E27)","v":"○○株式会社"}]
[null,"出来高累計",{"$nulls":15},"非・不課税",{"$nulls":6},{"$f":"SUMIF(AS23:AS38,\"非\",AL23:AR38)","v":{"v":20000,"d":"20,000 "}},{"$nulls":13},{"$f":"SUM(Y46:AL47)","v":{"v":20000,"d":"20,000 "}}]
[]
[null,"前月迄保留金",{"$nulls":22},"前月迄",{"$nulls":6},"当月",{"$nulls":6},"当月迄"]
[{"$nulls":48},"部署長",{"$nulls":3},"施工担当部",{"$nulls":11},"所長"]
[null,"当月保留金",{"$nulls":15},"税抜支払金額"]
[]
[null,"当月保留金解除額",{"$nulls":15},"消費税額"]
[]
[null,"当月支払金額",{"$nulls":15},"消費税額調整額"]
[]
[null,"支払残",{"$nulls":15},"税込支払金額"]

{"sheet":"【入力例1】出来高内訳書","index":6,"n_rows":23,"n_cols":16,"rows_kept":23,"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※注意※　一度ボタンを押すと元に戻すことができません！"]
[{"$nulls":5},"出来高内訳書",{"$nulls":7},{"$f":"【入力例】基本データ!B9","v":"2023-06-30"}]
[null,"工事名称",{"$f":"【入力例】基本データ!B2","v":"○○○○○工事"},{"$nulls":7},"協力業者名",null,{"$f":"【入力例】基本データ!B13","v":"○○株式会社"}]
[{"$nulls":15},"※は軽減税率対象"]
[{"$nulls":4},"契約金額",null,null,"前月迄出来高",null,"当月出来高",null,"出来高累計",null,"契約残額"]
["No.","費目","細目","単位","単価","数量","金額","数量","金額","数量","金額","数量","金額","数量","金額","※"]
[1,"土工事"]
[1,"○",null,"ｍ3",{"v":1000,"d":"1,000 "},150.4,{"v":150400,"d":"150,400 "},null,null,50,{"v":50000,"d":"50,000 "},50,{"v":50000,"d":"50,000 "},100.4,{"v":100400,"d":"100,400 "}]
[1,"○",null,"ｍ3",{"v":1500,"d":"1,500 "},60.8,{"v":91200,"d":"91,200 "},null,null,30.8,{"v":46200,"d":"46,200 "},30.8,{"v":46200,"d":"46,200 "},29.999999999999996,{"v":45000,"d":"45,000 "}]
[1,"○",null,"ｍ3",{"v":2000,"d":"2,000 "},10.22,{"v":20440,"d":"20,440 "},null,null,5.91,{"v":11820,"d":"11,820 "},5.91,{"v":11820,"d":"11,820 "},4.3100000000000005,{"v":8620,"d":"8,620 "}]
[1,"値引",null,"式",{"v":-2040,"d":"(2,040)"},1,{"v":-2040,"d":"(2,040)"},null,null,1,{"v":-20,"d":"(20)"},1,{"v":-20,"d":"(20)"},1,{"v":-2020,"d":"(2,020)"}]
[1,"小計",{"$nulls":4},{"v":260000,"d":"260,000 "},{"$nulls":3},{"v":108000,"d":"108,000 "},null,{"v":108000,"d":"108,000 "},null,{"v":152000,"d":"152,000 "}]
[]
[2,"舗装工事"]
[2,"□",null,"ｍ2",{"v":1200,"d":"1,200 "},400,{"v":480000,"d":"480,000 "},null,null,200,{"v":240000,"d":"240,000 "},200,{"v":240000,"d":"240,000 "},200,{"v":240000,"d":"240,000 "}]
[2,"□",null,"ｍ2",{"v":1500,"d":"1,500 "},600,{"v":900000,"d":"900,000 "},null,null,300,{"v":450000,"d":"450,000 "},300,{"v":450000,"d":"450,000 "},300,{"v":450000,"d":"450,000 "}]
[2,"□",null,"ｍ2",{"v":3500,"d":"3,500 "},24,{"v":84000,"d":"84,000 "},null,null,24,{"v":84000,"d":"84,000 "},24,{"v":84000,"d":"84,000 "},0,{"v":0,"d":"0 "}]
[2,"現場管理費",null,"式",{"v":580000,"d":"580,000 "},1,{"v":580000,"d":"580,000 "},null,null,1,{"v":300000,"d":"300,000 "},1,{"v":300000,"d":"300,000 "},1,{"v":280000,"d":"280,000 "}]
[2,"法定福利費",null,"式",{"v":100000,"d":"100,000 "},1,{"v":100000,"d":"100,000 "},null,null,1,{"v":60000,"d":"60,000 "},1,{"v":60000,"d":"60,000 "},1,{"v":40000,"d":"40,000 "}]
[2,"値引",null,"式",{"v":-4000,"d":"(4,000)"},1,{"v":-4000,"d":"(4,000)"},null,null,1,{"v":-4000,"d":"(4,000)"},1,{"v":-4000,"d":"(4,000)"},0,{"v":0,"d":"0 "}]
[2,"小計",{"$nulls":4},{"v":2140000,"d":"2,140,000 "},{"$nulls":3},{"v":1130000,"d":"1,130,000 "},null,{"v":1130000,"d":"1,130,000 "},null,{"v":1010000,"d":"1,010,000 "}]
[]
[null,"合計",{"$nulls":4},{"v":2400000,"d":"2,400,000 "},{"$nulls":3},{"v":1238000,"d":"1,238,000 "},null,{"v":1238000,"d":"1,238,000 "},null,{"v":1162000,"d":"1,162,000 "}]

{"sheet":"【入力例2】出来高内訳書","index":7,"n_rows":16,"n_cols":16,"rows_kept":16,"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※注意※　一度ボタンを押すと元に戻すことができません！"]
[{"$nulls":5},"出来高内訳書",{"$nulls":7},{"$f":"【入力例】基本データ!B9","v":"2023-06-30"}]
[null,"工事名称",{"$f":"【入力例】基本データ!B2","v":"○○○○○工事"},{"$nulls":7},"協力業者名",null,{"$f":"【入力例】基本データ!B13","v":"○○株式会社"}]
[{"$nulls":15},"※は軽減税率対象"]
[{"$nulls":4},"契約金額",null,null,"前月迄出来高",null,"当月出来高",null,"出来高累計",null,"契約残額"]
["No.","費目","細目","単位","単価","数量","金額","数量","金額","数量","金額","数量","金額","数量","金額","※"]
[null,"土工事"]
[null,"○",null,"ｍ3",{"v":1000,"d":"1,000 "},150.4,{"v":150400,"d":"150,400 "},null,null,50,{"v":50000,"d":"50,000 "},50,{"v":50000,"d":"50,000 "},100.4,{"v":100400,"d":"100,400 "}]
[null,"○",null,"ｍ3",{"v":1500,"d":"1,500 "},60.8,{"v":91200,"d":"91,200 "},null,null,30.8,{"v":46200,"d":"46,200 "},30.8,{"v":46200,"d":"46,200 "},29.999999999999996,{"v":45000,"d":"45,000 "}]
[null,"○",null,"ｍ3",{"v":2000,"d":"2,000 "},10.22,{"v":20440,"d":"20,440 "},null,null,5.91,{"v":11820,"d":"11,820 "},5.91,{"v":11820,"d":"11,820 "},4.3100000000000005,{"v":8620,"d":"8,620 "}]
[null,"○",null,"ｍ3",{"v":500,"d":"500 "},100,{"v":50000,"d":"50,000 "},null,null,50,{"v":25000,"d":"25,000 "},50,{"v":25000,"d":"25,000 "},50,{"v":25000,"d":"25,000 "}]
[null,"諸経費",null,"式",{"v":300000,"d":"300,000 "},1,{"v":300000,"d":"300,000 "},null,null,1,{"v":140000,"d":"140,000 "},1,{"v":140000,"d":"140,000 "},1,{"v":160000,"d":"160,000 "}]
[null,"法定福利費",null,"式",{"v":50000,"d":"50,000 "},1,{"v":50000,"d":"50,000 "},null,null,1,{"v":27000,"d":"27,000 "},1,{"v":27000,"d":"27,000 "},1,{"v":23000,"d":"23,000 "}]
[null,"値引",null,"式",{"v":-2040,"d":"(2,040)"},1,{"v":-2040,"d":"(2,040)"},null,null,1,{"v":-20,"d":"(20)"},1,{"v":-20,"d":"(20)"},1,{"v":-2020,"d":"(2,020)"}]
[]
[null,"合計",{"$nulls":4},{"$f":"SUM(G7:G15)","v":{"v":660000,"d":"660,000 "}},{"$nulls":3},{"$f":"SUM(K7:K15)","v":{"v":300000,"d":"300,000 "}},null,{"$f":"SUM(M7:M15)","v":{"v":300000,"d":"300,000 "}},null,{"$f":"SUM(O7:O15)","v":{"v":360000,"d":"360,000 "}}]