{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["外注請求書 "],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":46,"n_cols":34,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,1,2,24],[2,27,2,29],[4,2,4,4],[4,5,4,9],[4,11,5,11],[4,12,7,13],[4,14,4,18],[4,19,5,24],[4,27,4,29],[5,2,5,4],[5,5,5,9],[5,14,5,18],[5,27,5,32],[6,2,6,4],[6,5,6,9],[6,11,7,11],[6,14,6,18],[6,19,7,24],[6,26,6,27],[8,27,8,32],[9,14,9,18],[9,26,10,26],[9,28,9,29],[10,1,12,1],[10,2,10,4],[10,5,10,7],[10,8,10,9],[10,11,11,11],[10,14,10,18],[7,1,9,1],[7,2,7,4],[7,14,7,18],[7,27,7,29],[8,2,9,4],[8,5,9,9],[8,11,9,11],[8,12,11,13],[8,14,8,18],[8,19,9,24],[12,19,13,24],[12,27,12,28],[12,30,12,32],[13,12,13,18],[13,27,13,28],[13,30,13,32],[10,19,11,24],[10,27,10,32],[11,2,12,2],[11,3,12,3],[11,4,12,4],[11,5,12,9],[11,14,11,18],[11,27,11,32],[12,11,13,11],[12,12,12,18],[24,1,24,4],[24,10,24,20],[25,5,25,8],[25,10,25,23],[25,24,27,25],[25,26,25,28],[19,30,19,32],[20,1,21,11],[20,30,20,32],[23,1,23,4],[23,5,23,11],[23,24,23,26],[23,27,23,32],[25,29,25,32],[26,1,26,4],[26,5,26,11],[26,26,27,32],[28,1,28,4],[28,5,28,20],[28,24,31,25],[28,26,31,31],[28,32,31,32],[31,1,32,5],[34,29,35,29],[34,30,35,32],[35,1,36,5],[35,6,36,11],[31,6,32,11],[31,12,31,21],[32,24,33,25],[32,26,33,28],[32,29,33,29],[32,30,33,32],[38,2,38,11],[38,12,38,17],[38,18,38,23],[38,24,38,26],[39,2,39,11],[39,12,39,17],[39,18,39,23],[39,24,39,26],[33,1,34,5],[33,6,34,11],[34,24,35,25],[34,26,35,28],[45,2,45,11],[45,12,45,17],[45,18,45,23],[45,24,45,26],[46,1,49,32],[43,12,43,17],[43,18,43,23],[43,24,43,26],[44,2,44,11],[44,12,44,17],[44,18,44,23],[44,24,44,26],[39,28,45,32],[40,2,40,11],[40,12,40,17],[40,18,40,23],[40,24,40,26],[41,2,41,11],[41,12,41,17],[41,18,41,23],[41,24,41,26],[43,2,43,11]]}
[]
[]
[null,"　今　回　請　求　額　算　定　内　訳　　　　今岡工業株式会社",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"請求日"]
[null,"当月請求額の算定",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"工事情報","請求日は20日で入力してください"]
[null,"A","工事価格",null,null,null,null,null,null,null,null,"Ｆ","前回\nまで\n累計",null,"請求額（税抜）",null,null,null,null,null,null,null,null,null,null,null,"工事番号"]
[null,"B","消費税等(A×10%)",null,null,{"$f":"IF(F5=\"\",\"\",+TRUNC(F5*10/100))","v":""},null,null,null,null,null,null,null,null,"（前回のＥの欄を転記）",null,null,null,null,null,null,null,null,null,null,null,"工事名"]
[null,"C","契約額    ( A + B )",null,null,{"$f":"IF(F5=\"\",\"\",F5+F6)","v":""},null,null,null,null,null,"Ｇ",null,null,"消費税額等",null,null,null,null,{"$f":"IF(T5=\"\",\"\",+TRUNC(T5*10/100))","v":""},null,null,null,null,null,null,"契約者情報"]
[null,"Ｄ","出来高査定日",null,null,null,"年",null,"月20日〆",null,null,null,null,null,"（出来高払はF×10%）",null,null,null,null,null,null,null,null,null,null,null,"取引先コード"]
[null,null,"累計出来高(税抜)\n(出来高内訳より転記)",null,null,null,null,null,null,null,null,"Ｈ","今回　",null,"請求額（税抜）",null,null,null,null,{"$f":"+F12-T5","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,"E","保留後金額 ",null,null,"支払保留",null,null,"あり",null,null,"Ｉ",null,null,"消費税額等",null,null,null,null,{"$f":"TRUNC(T9*10/100)","v":0}]
[null,null,"Ｄ×",90,"％",{"$f":"IF(AND(F9=F5, I11=\"なし\"), F5, IF(AND(I11=\"なし\", D12=100), F9, ROUNDDOWN(F9*D12/100,-4)))","v":0},null,null,null,null,null,null,null,null,"（出来高払はH×10%）",null,null,null,null,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":"+T9+T11","v":0},null,null,null,null,null,null,"担当部署名",null,null,"担当者"]
[null,null,"(原則90%:万単位未満切り捨て）",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,"E-mail"]
[]
[null,"以下書式への直接入力は原則登録番号の有無選択と備考のみとします",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"※請求書の作成に際しては、弊社担当者と御打合せの上、作成願います。"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"紙書式での外注契約に基づく請求用"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"外 注 契 約 請 求 書 ",null,null,null,null,null,null,null,null,null,null,"電子契約したもの/契約が無いものに対しては使用できません"]
[null,"今岡工業株式会社",null,null,null,null,null,"様",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,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(AB3=\"\"),\"\",AB3)","v":""}]
[]
[]
[null,"取引先コ－ド",null,null,null,{"$f":"IF(OR(AB8=\"\"),\"\",AB8)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"会　社　名",null,null,{"$f":"IF(OR(AB9=\"\"),\"\",AB9)","v":""}]
[null,"適格請求書発行\n事業者登録番号",null,null,null,"有",null,"無",null,"T",{"$f":"IF(OR(AB12=\"\"),\"\",AB12)","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,{"$f":"IF(OR(AC10=\"\"),\"\",AC10)","v":""}]
[null,"工事番号",null,null,null,{"$f":"IF(OR(AB5=\"\"),\"\",AB5)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB11=\"\"),\"\",AB11)","v":""}]
[]
[null,"工　事　名",null,null,null,{"$f":"IF(OR(AB6=\"\"),\"\",AB6)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"名　　称",null,{"$f":"IF(OR(AB9=\"\"),\"\",AB9)","v":""}]
[]
[]
[null,"　契約金額（消費税等抜）",null,null,null,null,{"$f":"F5","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,{"$f":"IF(OR(AB13=\"\"),\"\",AB13)","v":""},null,null,"担当者",{"$f":"IF(OR(AE13=\"\"),\"\",AE13)","v":""}]
[null,"　消費税等（税率10％）",null,null,null,null,{"$f":"ROUND(G32*0.1,0)","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,"TEL",null,{"$f":"IF(OR(AB14=\"\"),\"\",AB14)","v":""},null,null,"E-mail",{"$f":"IF(OR(AE14=\"\"),\"\",AE14)","v":""}]
[null,"　契約金額（消費税等込）",null,null,null,null,{"$f":"SUM(G32:L35)","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,"(A)","　出来高（消費税抜）",null,null,null,null,null,null,200000,null,null,{"$f":"T5","v":0},null,null,null,null,null,{"$f":"Y40-M40","v":0},null,null,null,null,null,{"$f":"F9","v":0}]
[null,"(B)","　（A）にかかる消費税等",null,null,null,null,null,null,200000,null,null,{"$f":"ROUND(M40*0.1,0)","v":0},null,null,null,null,null,{"$f":"ROUND(S40*0.1,0)","v":0},null,null,null,null,null,{"$f":"ROUND(Y40*0.1,0)","v":0}]
[null,"(C)","　（A）+（B）出来高（消費税込）",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M40:R41)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y40:AA41)","v":0}]
[]
[null,"(D)","　請求額（消費税等抜）",null,null,null,null,null,null,null,null,null,{"$f":"T5","v":0},null,null,null,null,null,{"$f":"Y44-M44","v":0},null,null,null,null,null,{"$f":"F12","v":0}]
[null,"(E)","　（D）にかかる消費税",null,null,null,null,null,null,null,null,null,{"$f":"ROUND(M44*0.1,0)","v":0},null,null,null,null,null,{"$f":"ROUND(S44*0.1,0)","v":0},null,null,null,null,null,{"$f":"ROUND(Y44*0.1,0)","v":0}]
[null,"(F)","　（D）+（E）請求額（消費税込）",null,null,null,null,null,null,null,null,null,{"$f":"SUM(M44:R45)","v":0},null,null,null,null,null,0,null,null,null,null,null,{"$f":"SUM(Y44:AA45)","v":0}]