{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["請求書1枚目","続き(2枚目)","続き(3枚目)","説明シート"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":4,"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":"請求書1枚目","index":0,"n_rows":143,"n_cols":22,"rows_kept":143,"cut":false,"hidden":false,"merged":[[59,14,59,15],[131,0,131,2],[126,3,127,3],[118,3,119,3],[116,4,117,4],[116,5,117,5],[136,8,136,9],[136,10,136,15],[136,1,136,2],[136,3,136,4],[130,0,130,2],[126,12,127,16],[128,5,129,5],[128,6,129,9],[126,5,127,5],[126,6,127,9],[126,10,127,11],[124,5,125,5],[120,3,121,3],[124,0,124,2],[120,0,120,2],[119,0,119,2],[132,0,132,2],[131,6,131,9],[100,8,100,16],[98,4,98,7],[91,0,91,2],[124,12,125,16],[124,6,125,9],[124,10,125,11],[122,10,123,11],[120,10,121,11],[108,15,109,15],[109,1,110,3],[94,13,94,16],[118,0,118,2],[123,0,123,2],[116,0,116,2],[112,3,113,3],[108,0,110,0],[112,0,112,2],[113,0,113,2],[108,1,108,3],[112,12,113,16],[120,12,121,16],[118,12,119,16],[112,4,113,4],[112,6,113,10],[121,0,121,2],[122,0,122,2],[117,0,117,2],[116,6,117,9],[114,5,115,5],[114,6,115,9],[116,3,117,3],[118,4,119,4],[124,3,125,3],[112,5,113,5],[122,3,123,3],[122,4,123,4],[122,5,123,5],[60,1,60,3],[83,6,83,9],[82,3,82,5],[76,6,77,9],[69,0,69,2],[82,0,82,2],[75,0,75,2],[76,0,76,2],[77,0,77,2],[71,0,71,2],[73,0,73,2],[74,0,74,2],[64,6,65,10],[67,0,67,2],[61,1,62,3],[64,5,65,5],[68,4,69,4],[68,0,68,2],[66,3,67,3],[66,4,67,4],[66,6,67,9],[70,3,71,3],[79,0,79,2],[83,0,83,2],[65,0,65,2],[66,0,66,2],[109,4,110,7],[17,19,18,19],[31,19,32,19],[17,18,18,18],[19,18,20,18],[21,18,22,18],[29,17,30,17],[31,17,32,17],[31,18,32,18],[27,12,28,16],[38,10,38,15],[25,19,26,19],[29,18,30,18],[17,17,18,17],[19,17,20,17],[21,17,22,17],[23,17,24,17],[27,17,28,17],[64,0,64,2],[60,0,62,0],[23,18,24,18],[27,18,28,18],[84,3,84,5],[68,3,69,3],[78,3,79,3],[74,4,75,4],[88,10,88,15],[88,5,88,7],[88,8,88,9],[31,6,32,9],[66,12,67,16],[80,5,81,5],[80,6,81,9],[76,5,77,5],[68,12,69,16],[56,7,56,8],[37,8,37,9],[37,10,37,15],[49,3,49,8],[56,1,56,3],[50,4,50,7],[84,0,84,2],[88,1,88,2],[88,3,88,4],[35,6,35,9],[31,4,32,4],[142,13,142,16],[132,6,132,9],[132,12,132,16],[130,6,130,9],[139,3,139,5],[128,3,129,3],[128,4,129,4],[130,3,130,5],[130,12,130,16],[131,12,131,16],[128,10,129,11],[128,12,129,16],[132,3,132,5],[139,0,139,2],[134,10,134,15],[135,1,135,2],[135,3,135,4],[135,5,135,7],[135,8,135,9],[135,10,135,15],[134,1,134,2],[134,3,134,4],[134,5,134,7],[134,8,134,9],[136,5,136,7],[114,12,115,16],[122,6,123,9],[114,3,115,3],[122,12,123,16],[120,4,121,4],[120,5,121,5],[118,10,119,11],[116,10,117,11],[114,10,115,11],[126,4,127,4],[124,4,125,4],[126,0,126,2],[127,0,127,2],[129,0,129,2],[128,0,128,2],[120,6,121,9],[125,0,125,2],[114,0,114,2],[115,0,115,2],[23,3,24,3],[25,5,26,5],[27,3,28,3],[116,12,117,16],[114,4,115,4],[118,5,119,5],[118,6,119,9],[29,0,29,2],[30,0,30,2],[55,1,55,3],[53,1,53,3],[35,3,35,5],[33,3,33,5],[32,0,32,2],[35,0,35,2],[37,1,37,2],[37,3,37,4],[31,3,32,3],[38,1,38,2],[38,3,38,4],[38,5,38,7],[37,5,37,7],[29,12,30,16],[108,12,109,12],[21,5,22,5],[21,6,22,9],[27,5,28,5],[27,6,28,9],[23,5,24,5],[31,5,32,5],[29,4,30,4],[25,4,26,4],[25,6,26,9],[29,6,30,9],[23,6,24,9],[0,3,0,8],[17,4,18,4],[19,4,20,4],[11,1,11,3],[12,1,13,3],[17,5,18,5],[5,8,5,16],[1,4,1,7],[15,0,15,2],[4,8,4,16],[15,4,16,4],[15,5,16,5],[17,3,18,3],[19,3,20,3],[6,1,6,3],[19,5,20,5],[19,6,20,9],[12,4,13,8],[16,0,16,2],[11,0,13,0],[17,0,17,2],[18,0,18,2],[3,8,3,11],[15,3,16,3],[55,0,56,0],[66,5,67,5],[58,12,58,16],[55,8,55,16],[1,15,1,16],[41,15,41,16],[7,1,7,3],[6,0,7,0],[15,12,16,16],[23,12,24,16],[15,6,16,10],[4,1,4,3],[60,12,61,12],[6,8,6,16],[21,4,22,4],[23,4,24,4],[27,4,28,4],[17,6,18,9],[7,7,7,8],[17,12,18,16],[19,12,20,16],[21,12,22,16],[64,3,65,3],[64,4,65,4],[19,19,20,19],[21,19,22,19],[23,19,24,19],[27,19,28,19],[29,19,30,19],[74,5,75,5],[68,5,69,5],[35,12,35,16],[50,15,50,16],[74,12,75,16],[74,6,75,9],[70,12,71,16],[72,12,73,16],[70,6,71,9],[64,12,65,16],[38,8,38,9],[70,5,71,5],[72,6,73,9],[25,18,26,18],[25,17,26,17],[33,6,33,9],[34,6,34,9],[68,6,69,9],[29,5,30,5],[72,3,73,3],[80,0,80,2],[81,0,81,2],[80,4,81,4],[76,3,77,3],[76,4,77,4],[78,4,79,4],[106,8,106,10],[70,4,71,4],[74,3,75,3],[72,4,73,4],[86,1,86,2],[86,3,86,4],[86,5,86,7],[86,8,86,9],[86,10,86,15],[87,1,87,2],[87,3,87,4],[87,5,87,7],[87,8,87,9],[87,10,87,15],[104,7,104,8],[83,12,83,16],[78,0,78,2],[34,0,34,2],[58,8,58,10],[53,8,53,16],[54,8,54,15],[91,3,91,5],[106,12,106,16],[102,8,102,15],[25,12,26,16],[31,12,32,16],[34,12,34,16],[84,12,84,16],[97,3,97,8],[101,1,101,3],[101,8,101,16],[61,4,62,7],[28,0,28,2],[103,0,104,0],[103,1,103,3],[80,12,81,16],[78,5,79,5],[78,6,79,9],[72,0,72,2],[70,0,70,2],[72,5,73,5],[17,10,18,11],[19,10,20,11],[39,1,39,2],[39,3,39,4],[39,5,39,7],[39,10,39,15],[21,10,22,11],[35,10,35,11],[34,10,34,11],[33,10,33,11],[31,10,32,11],[29,10,30,11],[27,10,28,11],[25,10,26,11],[23,10,24,11],[26,0,26,2],[25,3,26,3],[27,0,27,2],[25,0,25,2],[19,0,19,2],[20,0,20,2],[21,0,21,2],[23,0,23,2],[22,0,22,2],[21,3,22,3],[104,1,104,3],[103,8,103,16],[80,3,81,3],[98,15,98,16],[82,12,82,16],[76,12,77,16],[84,6,84,9],[82,6,82,9],[78,12,79,16],[29,3,30,3],[68,10,69,11],[66,10,67,11],[80,10,81,11],[78,10,79,11],[76,10,77,11],[74,10,75,11],[72,10,73,11],[70,10,71,11],[24,0,24,2],[39,8,39,9],[33,12,33,13],[33,0,33,2],[31,0,31,2]]}
["　（請求元保管）",null,null," 請　求　書　（控) ",null,null,null,null,null,null,null,null,null,null,null,"No.",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,null,null,null,null,"適格請求書\n発行事業者登録番号",null,"T",null,"-",null,"-",null,"-"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
["下記のとおり請求いたします。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8%（軽減税率対象）"]
["金　額","円",null,null,{"$f":"IF(E13=\"\",\"\",\"適格請求書発行事業者の方は登録番号の入力をお願いいたします。\")","v":"適格請求書発行事業者の方は登録番号の入力をお願いいたします。"},null,null,null,null,null,null,null,null,null,null,null,null,"非課税"]
[null,{"$f":"+F39+F40+K39+K40","v":0},null,null,{"$f":"IF(K8=\"\",\"※\",\"\")","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":"ROUND(E18*F18,0)","v":0},null,null,null,{"$f":"+IF(R18=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R18=\"8%（軽減税率対象）\",8%,R18)","v":0},{"$f":"IF(OR(R18=\"非課税\",S18=\"不課税\"),G18*0,G18*S18)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E20*F20,0)","v":0},null,null,null,{"$f":"+IF(R20=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R20=\"8%（軽減税率対象）\",8%,R20)","v":0},{"$f":"IF(OR(R20=\"非課税\",S20=\"不課税\"),G20*0,G20*S20)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E22*F22,0)","v":0},null,null,null,{"$f":"+IF(R22=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R22=\"8%（軽減税率対象）\",8%,R22)","v":0},{"$f":"IF(OR(R22=\"非課税\",S22=\"不課税\"),G22*0,G22*S22)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E24*F24,0)","v":0},null,null,null,{"$f":"+IF(R24=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R24=\"8%（軽減税率対象）\",8%,R24)","v":0},{"$f":"IF(OR(R24=\"非課税\",S24=\"不課税\"),G24*0,G24*S24)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E26*F26,0)","v":0},null,null,null,{"$f":"+IF(R26=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R26=\"8%（軽減税率対象）\",8%,R26)","v":0},{"$f":"IF(OR(R26=\"非課税\",S26=\"不課税\"),G26*0,G26*S26)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E28*F28,0)","v":0},null,null,null,{"$f":"+IF(R28=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R28=\"8%（軽減税率対象）\",8%,R28)","v":0},{"$f":"IF(OR(R28=\"非課税\",S28=\"不課税\"),G28*0,G28*S28)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E30*F30,0)","v":0},null,null,null,{"$f":"+IF(R30=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R30=\"8%（軽減税率対象）\",8%,R30)","v":0},{"$f":"IF(OR(R30=\"非課税\",S30=\"不課税\"),G30*0,G30*S30)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E32*F32,0)","v":0},null,null,null,{"$f":"+IF(R32=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R32=\"8%（軽減税率対象）\",8%,R32)","v":0},{"$f":"IF(OR(R32=\"非課税\",S32=\"不課税\"),G32*0,G32*S32)","v":0}]
[]
["品代計",null,null,null,null,null,{"$f":"IF(SUM(G18:J33)=0,\"\",IF(SUM('続き(2枚目)'!G13:J38)=0,SUM(G18:J33),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T18:T33)","v":0}]
[{"$f":"+D38","v":"消費税相当額"},null,null,null,null,null,{"$f":"IF(G34=\"\",\"\",D39+D40)","v":""}]
["合　　計",null,null,null,null,null,{"$f":"IF(G34=\"\",\"\",G34+G35)","v":""}]
[]
[null,"本体",null,{"$f":"IF(K8=\"\",\"消費税相当額\",\"消費税\")","v":"消費税相当額"},null,{"$f":"IF(K8=\"\",\"合計\",\"税込\")","v":"合計"},null,null,null,null,"本体"]
["10％対象",{"$f":"SUMIF($R$18:$R$33,R10,$G$18:$J$33)+SUMIF('続き(2枚目)'!$R$13:$R$38,'続き(2枚目)'!R154,'続き(2枚目)'!G13:J38)+SUMIF('続き(3枚目)'!$R$13:$R$38,'続き(3枚目)'!R154,'続き(3枚目)'!G13:J38)","v":0},null,{"$f":"IF(B39=\"\",0,ROUND(B39*10/100,0))","v":0},null,{"$f":"+B39+D39","v":0},null,null,"非課税対象",null,{"$f":"SUMIF($R$18:$R$33,R12,$G$18:$J$33)+SUMIF('続き(2枚目)'!$R$13:$R$38,'続き(2枚目)'!$R$156,'続き(2枚目)'!$G$13:$J$38)+SUMIF('続き(3枚目)'!$R$13:$R$38,'続き(3枚目)'!$R$156,'続き(3枚目)'!$G$13:$J$38)","v":0}]
["＊8％対象",{"$f":"SUMIF($R$18:$R$33,R11,$G$18:$J$33)+SUMIF('続き(2枚目)'!$R$13:$R$38,'続き(2枚目)'!$R$155,'続き(2枚目)'!$G$13:$J$38)+SUMIF('続き(3枚目)'!$R$13:$R$38,'続き(3枚目)'!$R$155,'続き(3枚目)'!$G$13:$J$38)","v":0},null,{"$f":"IF(B40=\"\",0,ROUND(B40*8/100,0))","v":0},null,{"$f":"+B40+D40","v":0},null,null,"不課税対象",null,{"$f":"SUMIF($R$18:$R$33,R13,$G$18:$J$33)+SUMIF('続き(2枚目)'!$R$13:$R$38,'続き(2枚目)'!$R$157,'続き(2枚目)'!$G$13:J38)+SUMIF('続き(3枚目)'!$R$13:$R$38,'続き(3枚目)'!$R$157,'続き(3枚目)'!$G$13:J38)","v":0}]
[]
["＊印は軽減税率(8％)適用商品"]
[]
[]
[]
[]
[]
[]
[]
["　（工場・営業部門控）",null,null," 請　　　求　　　書 ",null,null,null,null,null,null,null,null,null,null,null,"No.",{"$f":"$Q$1","v":1}]
[null,null,null,null,{"$f":"$E$2","v":"00:00:00"}]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒",{"$f":"$I$4","v":0}]
["納入場所",{"$f":"$B$5","v":0},null,null,null,null,null,"住所",{"$f":"$I$5","v":0}]
[null,null,null,null,null,null,null,"社名",{"$f":"$I$6","v":0}]
[{"$f":"$A$7","v":0},{"$f":"$B$7","v":"00:00:00"},null,null,null,null,null,"電話",{"$f":"$I$7","v":0}]
[null,{"$f":"$B$8","v":"00:00:00"},null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,{"$f":"$J$8","v":"T"},{"$f":"+K8","v":0},"-",{"$f":"+M8","v":0},"-",{"$f":"+O8","v":0},"-",{"$f":"+Q8","v":0},null,null,null,null,{"$f":"$V$61","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,{"$f":"$B$13","v":0},null,null,{"$f":"+E13","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,"摘　　　　要"]
["（形状・寸法）"]
[{"$f":"$A$18","v":0},null,null,{"$f":"$D$18","v":0},{"$f":"$E$18","v":0},{"$f":"$F$18","v":0},{"$f":"$G$18","v":0},null,null,null,{"$f":"$K$18","v":0},null,{"$f":"$M$18","v":0}]
[{"$f":"$A$19","v":0}]
[{"$f":"$A$20","v":0},null,null,{"$f":"$D$20","v":0},{"$f":"$E$20","v":0},{"$f":"$F$20","v":0},{"$f":"$G$20","v":0},null,null,null,{"$f":"$K$20","v":0},null,{"$f":"$M$20","v":0}]
[{"$f":"$A$21","v":0}]
[{"$f":"$A$22","v":0},null,null,{"$f":"$D$22","v":0},{"$f":"$E$22","v":0},{"$f":"$F$22","v":0},{"$f":"$G$22","v":0},null,null,null,{"$f":"$K$22","v":0},null,{"$f":"$M$22","v":0}]
[{"$f":"$A$23","v":0}]
[{"$f":"$A$24","v":0},null,null,{"$f":"$D$24","v":0},{"$f":"$E$24","v":0},{"$f":"$F$24","v":0},{"$f":"$G$24","v":0},null,null,null,{"$f":"$K$24","v":0},null,{"$f":"$M$24","v":0}]
[{"$f":"$A$25","v":0}]
[{"$f":"$A$26","v":0},null,null,{"$f":"$D$26","v":0},{"$f":"$E$26","v":0},{"$f":"$F$26","v":0},{"$f":"$G$26","v":0},null,null,null,{"$f":"$K$26","v":0},null,{"$f":"$M$26","v":0}]
[{"$f":"$A$27","v":0}]
[{"$f":"$A$28","v":0},null,null,{"$f":"$D$28","v":0},{"$f":"$E$28","v":0},{"$f":"$F$28","v":0},{"$f":"$G$28","v":0},null,null,null,{"$f":"$K$28","v":0},null,{"$f":"$M$28","v":0}]
[{"$f":"$A$29","v":0}]
[{"$f":"$A$30","v":0},null,null,{"$f":"$D$30","v":0},{"$f":"$E$30","v":0},{"$f":"$F$30","v":0},{"$f":"$G$30","v":0},null,null,null,{"$f":"$K$30","v":0},null,{"$f":"$M$30","v":0}]
[{"$f":"$A$31","v":0}]
[{"$f":"$A$32","v":0},null,null,{"$f":"$D$32","v":0},{"$f":"$E$32","v":0},{"$f":"$F$32","v":0},{"$f":"$G$32","v":0},null,null,null,{"$f":"$K$32","v":0},null,{"$f":"$M$32","v":0}]
[{"$f":"$A$33","v":0}]
[{"$f":"$A$34","v":"品代計"},null,null,null,null,null,{"$f":"$G$34","v":""}]
[{"$f":"$A$35","v":"消費税相当額"},null,null,null,null,null,{"$f":"$G$35","v":""}]
[{"$f":"$A$36","v":"合　　計"},null,null,{"$f":"$E$36","v":0},null,null,{"$f":"$G$36","v":""}]
[]
[null,"本体",null,{"$f":"+D38","v":"消費税相当額"},null,{"$f":"+F38","v":"合計"},null,null,null,null,"本体"]
["10％対象",{"$f":"$B$39","v":0},null,{"$f":"$D$39","v":0},null,{"$f":"$F$39","v":0},null,null,"非課税対象",null,{"$f":"+K39","v":0}]
["＊8％対象",{"$f":"+B40","v":0},null,{"$f":"+D40","v":0},null,{"$f":"+F40","v":0},null,null,"不課税対象",null,{"$f":"+K40","v":0}]
["＊印は軽減税率(8％)適用商品"]
[]
["経　　　理　　　部",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,null,null,null,null,null,null,null,null,null,null,"No.",{"$f":"$Q$1","v":1}]
[null,null,null,null,{"$f":"$E$2","v":"00:00:00"}]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒",{"$f":"$I$4","v":0}]
["納入場所",{"$f":"$B$5","v":0},null,null,null,null,null,"住所",{"$f":"$I$5","v":0}]
[null,null,null,null,null,null,null,"社名",{"$f":"$I$6","v":0},null,null,null,null,null,null,null,"印"]
[{"$f":"$A$7","v":0},{"$f":"$B$7","v":"00:00:00"},null,null,null,null,null,"電話",{"$f":"$I$7","v":0}]
[null,{"$f":"$B$8","v":"00:00:00"},null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,{"$f":"$J$8","v":"T"},{"$f":"+K57","v":0},"-",{"$f":"+M57","v":0},"-",{"$f":"+O57","v":0},"-",{"$f":"+Q57","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,{"$f":"$B$13","v":0},null,null,{"$f":"+E62","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,"摘　　　　要"]
["（形状・寸法）"]
[{"$f":"$A$18","v":0},null,null,{"$f":"$D$18","v":0},{"$f":"$E$18","v":0},{"$f":"$F$18","v":0},{"$f":"$G$18","v":0},null,null,null,{"$f":"$K$18","v":0},null,{"$f":"$M$18","v":0}]
[{"$f":"$A$19","v":0}]
[{"$f":"$A$20","v":0},null,null,{"$f":"$D$20","v":0},{"$f":"$E$20","v":0},{"$f":"$F$20","v":0},{"$f":"$G$20","v":0},null,null,null,{"$f":"$K$20","v":0},null,{"$f":"$M$20","v":0}]
[{"$f":"$A$21","v":0}]
[{"$f":"$A$22","v":0},null,null,{"$f":"$D$22","v":0},{"$f":"$E$22","v":0},{"$f":"$F$22","v":0},{"$f":"$G$22","v":0},null,null,null,{"$f":"$K$22","v":0},null,{"$f":"$M$22","v":0}]
[{"$f":"$A$23","v":0}]
[{"$f":"$A$24","v":0},null,null,{"$f":"$D$24","v":0},{"$f":"$E$24","v":0},{"$f":"$F$24","v":0},{"$f":"$G$24","v":0},null,null,null,{"$f":"$K$24","v":0},null,{"$f":"$M$24","v":0}]
[{"$f":"$A$25","v":0}]
[{"$f":"$A$26","v":0},null,null,{"$f":"$D$26","v":0},{"$f":"$E$26","v":0},{"$f":"$F$26","v":0},{"$f":"$G$26","v":0},null,null,null,{"$f":"$K$26","v":0},null,{"$f":"$M$26","v":0}]
[{"$f":"$A$27","v":0}]
[{"$f":"$A$28","v":0},null,null,{"$f":"$D$28","v":0},{"$f":"$E$28","v":0},{"$f":"$F$28","v":0},{"$f":"$G$28","v":0},null,null,null,{"$f":"$K$28","v":0},null,{"$f":"$M$28","v":0}]
[{"$f":"$A$29","v":0}]
[{"$f":"$A$30","v":0},null,null,{"$f":"$D$30","v":0},{"$f":"$E$30","v":0},{"$f":"$F$30","v":0},{"$f":"$G$30","v":0},null,null,null,{"$f":"$K$30","v":0},null,{"$f":"$M$30","v":0}]
[{"$f":"$A$31","v":0}]
[{"$f":"$A$32","v":0},null,null,{"$f":"$D$32","v":0},{"$f":"$E$32","v":0},{"$f":"$F$32","v":0},{"$f":"$G$32","v":0},null,null,null,{"$f":"$K$32","v":0},null,{"$f":"$M$32","v":0}]
[{"$f":"$A$33","v":0}]
[{"$f":"$A$34","v":"品代計"},null,null,null,null,null,{"$f":"$G$34","v":""}]
[{"$f":"$A$35","v":"消費税相当額"},null,null,null,null,null,{"$f":"$G$35","v":""}]
[{"$f":"$A$36","v":"合　　計"},null,null,{"$f":"$E$36","v":0},null,null,{"$f":"$G$36","v":""}]
[]
[null,"本体",null,{"$f":"+D87","v":"消費税相当額"},null,{"$f":"+F87","v":"合計"},null,null,null,null,"本体"]
["10％対象",{"$f":"$B$39","v":0},null,{"$f":"$D$39","v":0},null,{"$f":"$F$39","v":0},null,null,"非課税対象",null,{"$f":"+K39","v":0}]
["＊8％対象",{"$f":"+B40","v":0},null,{"$f":"+D40","v":0},null,{"$f":"+F40","v":0},null,null,"不課税対象",null,{"$f":"+K40","v":0}]
["＊印は軽減税率(8％)適用商品"]
[]
["経　　　理　　　部",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":"続き(2枚目)","index":1,"n_rows":157,"n_cols":20,"rows_kept":157,"cut":false,"hidden":false,"merged":[[155,0,156,0],[155,1,155,3],[156,1,156,3],[156,4,156,8],[5,8,5,16],[6,0,7,0],[6,1,6,3],[6,8,6,16],[7,1,7,3],[7,7,7,8],[18,0,18,2],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,9],[30,10,31,11],[30,12,31,16],[34,10,35,11],[34,12,35,16],[36,12,37,16],[49,3,49,8],[50,4,50,7],[50,15,50,16],[53,1,53,3],[0,3,0,8],[1,4,1,7],[1,15,1,16],[3,8,3,11],[4,1,4,3],[4,8,4,16],[10,12,11,16],[11,0,11,2],[12,0,12,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,9],[12,10,13,11],[12,12,13,16],[10,0,10,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,10],[12,17,13,17],[12,18,13,18],[12,19,13,19],[13,0,13,2],[14,0,14,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,9],[14,10,15,11],[14,12,15,16],[14,17,15,17],[14,18,15,18],[14,19,15,19],[15,0,15,2],[30,17,31,17],[30,18,31,18],[30,19,31,19],[31,0,31,2],[28,12,29,16],[28,17,29,17],[28,18,29,18],[28,19,29,19],[29,0,29,2],[30,0,30,2],[30,3,31,3],[30,4,31,4],[30,5,31,5],[30,6,31,9],[28,0,28,2],[28,3,29,3],[28,4,29,4],[28,5,29,5],[28,6,29,9],[28,10,29,11],[34,17,35,17],[34,18,35,18],[34,19,35,19],[35,0,35,2],[32,12,33,16],[32,17,33,17],[32,18,33,18],[32,19,33,19],[33,0,33,2],[34,0,34,2],[34,3,35,3],[34,4,35,4],[34,5,35,5],[34,6,35,9],[32,0,32,2],[32,3,33,3],[32,4,33,4],[32,5,33,5],[32,6,33,9],[32,10,33,11],[36,17,37,17],[36,18,37,18],[36,19,37,19],[37,0,37,2],[38,0,38,2],[38,3,38,5],[38,6,38,9],[38,10,38,11],[38,12,38,13],[36,0,36,2],[36,3,37,3],[36,4,37,4],[36,5,37,5],[36,6,37,9],[36,10,37,11],[53,8,53,16],[54,8,54,15],[39,0,39,2],[39,6,39,9],[39,10,39,11],[39,12,39,16],[40,0,40,2],[40,3,40,5],[40,6,40,9],[40,10,40,11],[40,12,40,16],[59,0,59,2],[59,3,60,3],[59,4,60,4],[59,5,60,5],[59,6,60,10],[59,12,60,16],[60,0,60,2],[55,0,56,0],[55,1,55,3],[55,8,55,16],[56,1,56,3],[56,7,56,8],[61,12,62,16],[62,0,62,2],[63,0,63,2],[63,3,64,3],[63,4,64,4],[63,5,64,5],[63,6,64,9],[63,10,64,11],[63,12,64,16],[64,0,64,2],[61,0,61,2],[61,3,62,3],[61,4,62,4],[61,5,62,5],[61,6,62,9],[61,10,62,11],[65,12,66,16],[66,0,66,2],[67,0,67,2],[67,3,68,3],[67,4,68,4],[67,5,68,5],[67,6,68,9],[67,10,68,11],[67,12,68,16],[68,0,68,2],[65,0,65,2],[65,3,66,3],[65,4,66,4],[65,5,66,5],[65,6,66,9],[65,10,66,11],[69,12,70,16],[70,0,70,2],[71,0,71,2],[71,3,72,3],[71,4,72,4],[71,5,72,5],[71,6,72,9],[71,10,72,11],[71,12,72,16],[72,0,72,2],[69,0,69,2],[69,3,70,3],[69,4,70,4],[69,5,70,5],[69,6,70,9],[69,10,70,11],[87,0,87,2],[87,3,87,5],[87,6,87,9],[87,12,87,16],[88,0,88,2],[88,6,88,9],[88,12,88,16],[83,12,84,16],[84,0,84,2],[85,0,85,2],[85,3,86,3],[85,4,86,4],[85,5,86,5],[85,6,86,9],[85,10,86,11],[85,12,86,16],[86,0,86,2],[83,0,83,2],[83,3,84,3],[83,4,84,4],[83,5,84,5],[83,6,84,9],[83,10,84,11],[92,0,92,2],[92,3,92,5],[95,13,95,16],[98,3,98,8],[99,4,99,7],[99,15,99,16],[89,0,89,2],[89,3,89,5],[89,6,89,9],[89,12,89,16],[108,0,108,2],[108,3,109,3],[108,4,109,4],[108,5,109,5],[108,6,109,10],[108,12,109,16],[109,0,109,2],[101,8,101,16],[102,1,102,3],[102,8,102,16],[103,8,103,15],[104,0,105,0],[104,1,104,3],[104,8,104,16],[105,1,105,3],[105,7,105,8],[110,12,111,16],[111,0,111,2],[112,0,112,2],[112,3,113,3],[112,4,113,4],[112,5,113,5],[112,6,113,9],[112,10,113,11],[112,12,113,16],[113,0,113,2],[110,0,110,2],[110,3,111,3],[110,4,111,4],[110,5,111,5],[110,6,111,9],[110,10,111,11],[116,6,117,9],[116,10,117,11],[116,12,117,16],[117,0,117,2],[114,0,114,2],[114,3,115,3],[114,4,115,4],[114,5,115,5],[114,6,115,9],[114,10,115,11],[130,0,130,2],[130,3,131,3],[130,4,131,4],[130,5,131,5],[130,6,131,9],[130,10,131,11],[130,12,131,16],[131,0,131,2],[118,0,118,2],[118,3,119,3],[118,4,119,4],[118,5,119,5],[118,6,119,9],[118,10,119,11],[122,12,123,16],[123,0,123,2],[124,0,124,2],[124,3,125,3],[124,4,125,4],[124,5,125,5],[124,6,125,9],[124,10,125,11],[124,12,125,16],[125,0,125,2],[134,3,135,3],[134,4,135,4],[134,5,135,5],[134,6,135,9],[134,10,135,11],[134,12,135,16],[135,0,135,2],[132,0,132,2],[132,3,133,3],[132,4,133,4],[132,5,133,5],[132,6,133,9],[132,10,133,11],[140,0,140,2],[140,3,140,5],[143,13,143,16],[16,0,16,2],[16,3,17,3],[16,4,17,4],[16,5,17,5],[16,6,17,9],[16,10,17,11],[16,12,17,16],[138,0,138,2],[138,3,138,5],[138,6,138,9],[138,12,138,16],[136,0,136,2],[136,3,136,5],[136,6,136,9],[136,12,136,16],[137,0,137,2],[137,6,137,9],[137,12,137,16],[132,12,133,16],[133,0,133,2],[134,0,134,2],[16,17,17,17],[16,18,17,18],[16,19,17,19],[17,0,17,2],[24,0,24,2],[24,3,25,3],[24,4,25,4],[24,5,25,5],[24,6,25,9],[24,10,25,11],[18,10,19,11],[18,12,19,16],[18,17,19,17],[18,18,19,18],[18,19,19,19],[19,0,19,2],[22,10,23,11],[22,12,23,16],[22,17,23,17],[22,18,23,18],[22,19,23,19],[23,0,23,2],[20,12,21,16],[20,17,21,17],[26,10,27,11],[26,12,27,16],[26,17,27,17],[26,18,27,18],[26,19,27,19],[27,0,27,2],[24,12,25,16],[24,17,25,17],[24,18,25,18],[24,19,25,19],[25,0,25,2],[26,0,26,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,9],[20,18,21,18],[20,19,21,19],[21,0,21,2],[22,0,22,2],[22,3,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,9],[20,0,20,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,9],[20,10,21,11],[73,12,74,16],[74,0,74,2],[75,0,75,2],[75,3,76,3],[75,4,76,4],[75,5,76,5],[75,6,76,9],[75,10,76,11],[75,12,76,16],[76,0,76,2],[73,0,73,2],[73,3,74,3],[73,4,74,4],[73,5,74,5],[73,6,74,9],[73,10,74,11],[77,12,78,16],[78,0,78,2],[79,0,79,2],[79,3,80,3],[79,4,80,4],[79,5,80,5],[79,6,80,9],[79,10,80,11],[79,12,80,16],[80,0,80,2],[77,0,77,2],[77,3,78,3],[77,4,78,4],[77,5,78,5],[77,6,78,9],[77,10,78,11],[81,12,82,16],[82,0,82,2],[120,0,120,2],[120,3,121,3],[120,4,121,4],[120,5,121,5],[120,6,121,9],[120,10,121,11],[120,12,121,16],[121,0,121,2],[81,0,81,2],[81,3,82,3],[81,4,82,4],[81,5,82,5],[81,6,82,9],[81,10,82,11],[118,12,119,16],[119,0,119,2],[114,12,115,16],[115,0,115,2],[116,0,116,2],[116,3,117,3],[116,4,117,4],[116,5,117,5],[122,0,122,2],[122,3,123,3],[122,4,123,4],[122,5,123,5],[122,6,123,9],[122,10,123,11],[126,12,127,16],[127,0,127,2],[128,0,128,2],[128,3,129,3],[128,4,129,4],[128,5,129,5],[128,6,129,9],[128,10,129,11],[128,12,129,16],[129,0,129,2],[126,0,126,2],[126,3,127,3],[126,4,127,4],[126,5,127,5],[126,6,127,9],[126,10,127,11]]}
["　（請求元保管）",null,null," 請　求　書　（控) ",null,null,null,null,null,null,null,null,null,null,null,"No.",2]
[null,null,null,null,{"$f":"+請求書1枚目!E2","v":"00:00:00"}]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒",{"$f":"+請求書1枚目!I4","v":0}]
["納入場所",{"$f":"+請求書1枚目!B5","v":0},null,null,null,null,null,"住所",{"$f":"+請求書1枚目!I5","v":0}]
[null,null,null,null,null,null,null,"社名",{"$f":"+請求書1枚目!I6","v":0}]
[{"$f":"+請求書1枚目!A7","v":0},{"$f":"+請求書1枚目!B7","v":"00:00:00"},null,null,null,null,null,"電話",{"$f":"+請求書1枚目!I7","v":0}]
[null,{"$f":"+請求書1枚目!B8","v":"00:00:00"},null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,"T",{"$f":"+請求書1枚目!K8","v":0},"-",{"$f":"+請求書1枚目!M8","v":0},"-",{"$f":"+請求書1枚目!O8","v":0},"-",{"$f":"+請求書1枚目!Q8","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,{"$f":"ROUND(E13*F13,0)","v":0},null,null,null,{"$f":"+IF(R13=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R13=\"8%（軽減税率対象）\",8%,R13)","v":0},{"$f":"IF(OR(R13=\"非課税\",S13=\"不課税\"),G13*0,G13*S13)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E15*F15,0)","v":0},null,null,null,{"$f":"+IF(R15=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R15=\"8%（軽減税率対象）\",8%,R15)","v":0},{"$f":"IF(OR(R15=\"非課税\",S15=\"不課税\"),G15*0,G15*S15)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E17*F17,0)","v":0},null,null,null,{"$f":"+IF(R17=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R17=\"8%（軽減税率対象）\",8%,R17)","v":0},{"$f":"IF(OR(R17=\"非課税\",S17=\"不課税\"),G17*0,G17*S17)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E19*F19,0)","v":0},null,null,null,{"$f":"+IF(R19=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R19=\"8%（軽減税率対象）\",8%,R19)","v":0},{"$f":"IF(OR(R19=\"非課税\",S19=\"不課税\"),G19*0,G19*S19)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E21*F21,0)","v":0},null,null,null,{"$f":"+IF(R21=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R21=\"8%（軽減税率対象）\",8%,R21)","v":0},{"$f":"IF(OR(R21=\"非課税\",S21=\"不課税\"),G21*0,G21*S21)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E23*F23,0)","v":0},null,null,null,{"$f":"+IF(R23=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R23=\"8%（軽減税率対象）\",8%,R23)","v":0},{"$f":"IF(OR(R23=\"非課税\",S23=\"不課税\"),G23*0,G23*S23)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E25*F25,0)","v":0},null,null,null,{"$f":"+IF(R25=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R25=\"8%（軽減税率対象）\",8%,R25)","v":0},{"$f":"IF(OR(R25=\"非課税\",S25=\"不課税\"),G25*0,G25*S25)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E27*F27,0)","v":0},null,null,null,{"$f":"+IF(R27=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R27=\"8%（軽減税率対象）\",8%,R27)","v":0},{"$f":"IF(OR(R27=\"非課税\",S27=\"不課税\"),G27*0,G27*S27)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E29*F29,0)","v":0},null,null,null,{"$f":"+IF(R29=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R29=\"8%（軽減税率対象）\",8%,R29)","v":0},{"$f":"IF(OR(R29=\"非課税\",S29=\"不課税\"),G29*0,G29*S29)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E31*F31,0)","v":0},null,null,null,{"$f":"+IF(R31=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R31=\"8%（軽減税率対象）\",8%,R31)","v":0},{"$f":"IF(OR(R31=\"非課税\",S31=\"不課税\"),G31*0,G31*S31)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E33*F33,0)","v":0},null,null,null,{"$f":"+IF(R33=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R33=\"8%（軽減税率対象）\",8%,R33)","v":0},{"$f":"IF(OR(R33=\"非課税\",S33=\"不課税\"),G33*0,G33*S33)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E35*F35,0)","v":0},null,null,null,{"$f":"+IF(R35=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R35=\"8%（軽減税率対象）\",8%,R35)","v":0},{"$f":"IF(OR(R35=\"非課税\",S35=\"不課税\"),G35*0,G35*S35)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E37*F37,0)","v":0},null,null,null,{"$f":"+IF(R37=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R37=\"8%（軽減税率対象）\",8%,R37)","v":0},{"$f":"IF(OR(R37=\"非課税\",S37=\"不課税\"),G37*0,G37*S37)","v":0}]
[]
["品代計",null,null,null,null,null,{"$f":"IF(SUM(G13:J38)=0,\"\",IF(SUM('続き(3枚目)'!G13:J38)=0,SUM(請求書1枚目!G18:J33)+SUM('続き(2枚目)'!G13:J38),\"\"))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T13:T38)","v":0}]
[{"$f":"+請求書1枚目!A35","v":"消費税相当額"},null,null,null,null,null,{"$f":"IF(G39=\"\",\"\",請求書1枚目!D39+請求書1枚目!D40)","v":""}]
["合　　計",null,null,null,null,null,{"$f":"IF(G39=\"\",\"\",G39+G40)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
["　（工場・営業部門控）",null,null," 請　　　求　　　書 ",null,null,null,null,null,null,null,null,null,null,null,"No.",{"$f":"$Q$1","v":2}]
[null,null,null,null,{"$f":"$E$2","v":"00:00:00"}]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒",{"$f":"$I$4","v":0}]
["納入場所",{"$f":"$B$5","v":0},null,null,null,null,null,"住所",{"$f":"$I$5","v":0}]
[null,null,null,null,null,null,null,"社名",{"$f":"$I$6","v":0}]
[{"$f":"$A$7","v":0},{"$f":"$B$7","v":"00:00:00"},null,null,null,null,null,"電話",{"$f":"$I$7","v":0}]
[null,{"$f":"$B$8","v":"00:00:00"},null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,{"$f":"$J$8","v":"T"},{"$f":"+K8","v":0},"-",{"$f":"+M8","v":0},"-",{"$f":"+O8","v":0},"-",{"$f":"+Q8","v":0}]
[]
[]
["品　　　　　　　　　名",null,null,"単位","数量","単価","金　　　　額",null,null,null,null,null,"摘　　　　要"]
["（形状・寸法）"]
[{"$f":"+$A$13","v":0},null,null,{"$f":"+D13","v":0},{"$f":"$E$13","v":0},{"$f":"$F$13","v":0},{"$f":"+G13","v":0},null,null,null,{"$f":"+K13","v":0},null,{"$f":"+M13","v":0}]
[{"$f":"+A14","v":0}]
[0,null,null,{"$f":"+D15","v":0},{"$f":"+E15","v":0},{"$f":"+F15","v":0},{"$f":"+G15","v":0},null,null,null,{"$f":"+K15","v":0},null,{"$f":"+M15","v":0}]
[0]
[0,null,null,{"$f":"+D17","v":0},{"$f":"+E17","v":0},{"$f":"+F17","v":0},{"$f":"+G17","v":0},null,null,null,{"$f":"+K17","v":0},null,{"$f":"+M17","v":0}]
[0]
[0,null,null,{"$f":"+D19","v":0},{"$f":"+E19","v":0},{"$f":"+F19","v":0},{"$f":"+G19","v":0},null,null,null,{"$f":"+K19","v":0},null,{"$f":"+M19","v":0}]
[0]
[0,null,null,{"$f":"+D21","v":0},{"$f":"+E21","v":0},{"$f":"+F21","v":0},{"$f":"+G21","v":0},null,null,null,{"$f":"+K21","v":0},null,{"$f":"+M21","v":0}]
[0]
[0,null,null,{"$f":"+D23","v":0},{"$f":"+E23","v":0},{"$f":"+F23","v":0},{"$f":"+G23","v":0},null,null,null,{"$f":"+K23","v":0},null,{"$f":"+M23","v":0}]
[0]
[0,null,null,{"$f":"+D25","v":0},{"$f":"+E25","v":0},{"$f":"+F25","v":0},{"$f":"+G25","v":0},null,null,null,{"$f":"+K25","v":0},null,{"$f":"+M25","v":0}]
[0]
[0,null,null,{"$f":"+D27","v":0},{"$f":"+E27","v":0},{"$f":"+F27","v":0},{"$f":"+G27","v":0},null,null,null,{"$f":"+K27","v":0},null,{"$f":"+M27","v":0}]
[0]
[0,null,null,{"$f":"+D29","v":0},{"$f":"+E29","v":0},{"$f":"+F29","v":0},{"$f":"+G29","v":0},null,null,null,{"$f":"+K29","v":0},null,{"$f":"+M29","v":0}]
[0]
[0,null,null,{"$f":"+D31","v":0},{"$f":"+E31","v":0},{"$f":"+F31","v":0},{"$f":"+G31","v":0},null,null,null,{"$f":"+K31","v":0},null,{"$f":"+M31","v":0}]
[0]
[0,null,null,{"$f":"+D33","v":0},{"$f":"+E33","v":0},{"$f":"+F33","v":0},{"$f":"+G33","v":0},null,null,null,{"$f":"+K33","v":0},null,{"$f":"+M33","v":0}]
[0]
[0,null,null,{"$f":"+D35","v":0},{"$f":"+E35","v":0},{"$f":"+F35","v":0},{"$f":"+G35","v":0},null,null,null,{"$f":"+K35","v":0},null,{"$f":"+M35","v":0}]
[0]
[0,null,null,{"$f":"$D$37","v":0},{"$f":"+E37","v":0},{"$f":"+F37","v":0},{"$f":"+G37","v":0},null,null,null,{"$f":"+K37","v":0},null,{"$f":"+M37","v":0}]
[0]
[{"$f":"$A$39","v":"品代計"},null,null,null,null,null,{"$f":"+G39","v":""}]
[{"$f":"$A$40","v":"消費税相当額"},null,null,null,null,null,{"$f":"+G40","v":""}]
[{"$f":"$A$41","v":"合　　計"},null,null,{"$f":"$E$41","v":0},null,null,{"$f":"+G41","v":""}]
[]
[]
["経　　　理　　　部",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,null,null,null,null,null,null,null,null,null,null,"No.",{"$f":"$Q$1","v":2}]
[null,null,null,null,{"$f":"$E$2","v":"00:00:00"}]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒",{"$f":"$I$4","v":0}]
["納入場所",{"$f":"$B$5","v":0},null,null,null,null,null,"住所",{"$f":"$I$5","v":0}]
[null,null,null,null,null,null,null,"社名",{"$f":"$I$6","v":0}]
[{"$f":"$A$7","v":0},{"$f":"$B$7","v":"00:00:00"},null,null,null,null,null,"電話",{"$f":"$I$7","v":0}]
[null,{"$f":"$B$8","v":"00:00:00"},null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,{"$f":"$J$8","v":"T"},{"$f":"+K57","v":0},"-",{"$f":"+M57","v":0},"-",{"$f":"+O57","v":0},"-",{"$f":"+Q57","v":0}]
[]
[]
["品　　　　　　　　　名",null,null,"単位","数量","単価","金　　　　額",null,null,null,null,null,"摘　　　　要"]
["（形状・寸法）"]
[{"$f":"+A13","v":0},null,null,{"$f":"+D13","v":0},{"$f":"$E$13","v":0},{"$f":"$F$13","v":0},{"$f":"+G13","v":0},null,null,null,{"$f":"+K13","v":0},null,{"$f":"+M13","v":0}]
[0]
[0,null,null,{"$f":"+D15","v":0},{"$f":"+E64","v":0},{"$f":"+F64","v":0},{"$f":"+G15","v":0},null,null,null,{"$f":"+K15","v":0},null,{"$f":"+M15","v":0}]
[0]
[0,null,null,{"$f":"+D17","v":0},{"$f":"+E66","v":0},{"$f":"+F66","v":0},{"$f":"+G17","v":0},null,null,null,{"$f":"+K17","v":0},null,{"$f":"+M17","v":0}]
[0]
[0,null,null,{"$f":"+D19","v":0},{"$f":"+E68","v":0},{"$f":"+F68","v":0},{"$f":"+G19","v":0},null,null,null,{"$f":"+K19","v":0},null,{"$f":"+M19","v":0}]
[0]
[0,null,null,{"$f":"+D21","v":0},{"$f":"+E70","v":0},{"$f":"+F70","v":0},{"$f":"+G21","v":0},null,null,null,{"$f":"+K21","v":0},null,{"$f":"+M21","v":0}]
[0]
[0,null,null,{"$f":"+D23","v":0},{"$f":"+E72","v":0},{"$f":"+F72","v":0},{"$f":"+G23","v":0},null,null,null,{"$f":"+K23","v":0},null,{"$f":"+M23","v":0}]
[0]
[0,null,null,{"$f":"+D25","v":0},{"$f":"+E74","v":0},{"$f":"+F74","v":0},{"$f":"+G25","v":0},null,null,null,{"$f":"+K25","v":0},null,{"$f":"+M25","v":0}]
[0]
[0,null,null,{"$f":"+D27","v":0},{"$f":"+E76","v":0},{"$f":"+F76","v":0},{"$f":"+G27","v":0},null,null,null,{"$f":"+K27","v":0},null,{"$f":"+M27","v":0}]
[0]
[0,null,null,{"$f":"+D29","v":0},{"$f":"+E78","v":0},{"$f":"+F78","v":0},{"$f":"+G29","v":0},null,null,null,{"$f":"+K29","v":0},null,{"$f":"+M29","v":0}]
[0]
[0,null,null,{"$f":"+D31","v":0},{"$f":"+E80","v":0},{"$f":"+F80","v":0},{"$f":"+G31","v":0},null,null,null,{"$f":"+K31","v":0},null,{"$f":"+M31","v":0}]
[0]
[0,null,null,{"$f":"+D33","v":0},{"$f":"+E82","v":0},{"$f":"+F82","v":0},{"$f":"+G33","v":0},null,null,null,{"$f":"+K33","v":0},null,{"$f":"+M33","v":0}]
[0]
[0,null,null,{"$f":"+D35","v":0},{"$f":"+E84","v":0},{"$f":"+F84","v":0},{"$f":"+G35","v":0},null,null,null,{"$f":"+K35","v":0},null,{"$f":"+M35","v":0}]
[0]
[0,null,null,{"$f":"+D37","v":0},{"$f":"+E86","v":0},{"$f":"+F86","v":0},{"$f":"+G37","v":0},null,null,null,{"$f":"+K37","v":0},null,{"$f":"+M37","v":0}]
[0]
[{"$f":"$A$39","v":"品代計"},null,null,null,null,null,{"$f":"+G39","v":""}]
[{"$f":"$A$40","v":"消費税相当額"},null,null,null,null,null,{"$f":"+G40","v":""}]
[{"$f":"$A$41","v":"合　　計"},null,null,{"$f":"$E$41","v":0},null,null,{"$f":"+G41","v":""}]
[]
["経　　　理　　　部",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8%（軽減税率対象）"]
[null,null,null,null,null,null,null,null,null,null,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":"続き(3枚目)","index":2,"n_rows":157,"n_cols":20,"rows_kept":157,"cut":false,"hidden":false,"merged":[[140,0,140,2],[140,3,140,5],[143,13,143,16],[155,0,156,0],[155,1,155,3],[156,1,156,3],[156,4,156,8],[137,0,137,2],[137,6,137,9],[137,12,137,16],[138,0,138,2],[138,3,138,5],[138,6,138,9],[138,12,138,16],[134,12,135,16],[135,0,135,2],[136,0,136,2],[136,3,136,5],[136,6,136,9],[136,12,136,16],[134,0,134,2],[134,3,135,3],[134,4,135,4],[134,5,135,5],[134,6,135,9],[134,10,135,11],[130,12,131,16],[131,0,131,2],[132,0,132,2],[132,3,133,3],[132,4,133,4],[132,5,133,5],[132,6,133,9],[132,10,133,11],[132,12,133,16],[133,0,133,2],[130,0,130,2],[130,3,131,3],[130,4,131,4],[130,5,131,5],[130,6,131,9],[130,10,131,11],[126,12,127,16],[127,0,127,2],[128,0,128,2],[128,3,129,3],[128,4,129,4],[128,5,129,5],[128,6,129,9],[128,10,129,11],[128,12,129,16],[129,0,129,2],[126,0,126,2],[126,3,127,3],[126,4,127,4],[126,5,127,5],[126,6,127,9],[126,10,127,11],[122,12,123,16],[123,0,123,2],[124,0,124,2],[124,3,125,3],[124,4,125,4],[124,5,125,5],[124,6,125,9],[124,10,125,11],[124,12,125,16],[125,0,125,2],[122,0,122,2],[122,3,123,3],[122,4,123,4],[122,5,123,5],[122,6,123,9],[122,10,123,11],[118,12,119,16],[119,0,119,2],[120,0,120,2],[120,3,121,3],[120,4,121,4],[120,5,121,5],[120,6,121,9],[120,10,121,11],[120,12,121,16],[121,0,121,2],[118,0,118,2],[118,3,119,3],[118,4,119,4],[118,5,119,5],[118,6,119,9],[118,10,119,11],[114,12,115,16],[115,0,115,2],[116,0,116,2],[116,3,117,3],[116,4,117,4],[116,5,117,5],[116,6,117,9],[116,10,117,11],[116,12,117,16],[117,0,117,2],[114,0,114,2],[114,3,115,3],[114,4,115,4],[114,5,115,5],[114,6,115,9],[114,10,115,11],[110,12,111,16],[111,0,111,2],[112,0,112,2],[112,3,113,3],[112,4,113,4],[112,5,113,5],[112,6,113,9],[112,10,113,11],[112,12,113,16],[113,0,113,2],[110,0,110,2],[110,3,111,3],[110,4,111,4],[110,5,111,5],[110,6,111,9],[110,10,111,11],[108,0,108,2],[108,3,109,3],[108,4,109,4],[108,5,109,5],[108,6,109,10],[108,12,109,16],[109,0,109,2],[103,8,103,15],[104,0,105,0],[104,1,104,3],[104,8,104,16],[105,1,105,3],[105,7,105,8],[95,13,95,16],[98,3,98,8],[99,4,99,7],[99,15,99,16],[101,8,101,16],[102,1,102,3],[102,8,102,16],[89,0,89,2],[89,3,89,5],[89,6,89,9],[89,12,89,16],[92,0,92,2],[92,3,92,5],[87,0,87,2],[87,3,87,5],[87,6,87,9],[87,12,87,16],[88,0,88,2],[88,6,88,9],[88,12,88,16],[83,12,84,16],[84,0,84,2],[85,0,85,2],[85,3,86,3],[85,4,86,4],[85,5,86,5],[85,6,86,9],[85,10,86,11],[85,12,86,16],[86,0,86,2],[83,0,83,2],[83,3,84,3],[83,4,84,4],[83,5,84,5],[83,6,84,9],[83,10,84,11],[79,12,80,16],[80,0,80,2],[81,0,81,2],[81,3,82,3],[81,4,82,4],[81,5,82,5],[81,6,82,9],[81,10,82,11],[81,12,82,16],[82,0,82,2],[79,0,79,2],[79,3,80,3],[79,4,80,4],[79,5,80,5],[79,6,80,9],[79,10,80,11],[75,12,76,16],[76,0,76,2],[77,0,77,2],[77,3,78,3],[77,4,78,4],[77,5,78,5],[77,6,78,9],[77,10,78,11],[77,12,78,16],[78,0,78,2],[75,0,75,2],[75,3,76,3],[75,4,76,4],[75,5,76,5],[75,6,76,9],[75,10,76,11],[71,12,72,16],[72,0,72,2],[73,0,73,2],[73,3,74,3],[73,4,74,4],[73,5,74,5],[73,6,74,9],[73,10,74,11],[73,12,74,16],[74,0,74,2],[71,0,71,2],[71,3,72,3],[71,4,72,4],[71,5,72,5],[71,6,72,9],[71,10,72,11],[67,12,68,16],[68,0,68,2],[69,0,69,2],[69,3,70,3],[69,4,70,4],[69,5,70,5],[69,6,70,9],[69,10,70,11],[69,12,70,16],[70,0,70,2],[67,0,67,2],[67,3,68,3],[67,4,68,4],[67,5,68,5],[67,6,68,9],[67,10,68,11],[65,0,65,2],[65,3,66,3],[65,4,66,4],[65,5,66,5],[65,6,66,9],[65,10,66,11],[65,12,66,16],[66,0,66,2],[63,0,63,2],[63,3,64,3],[63,4,64,4],[63,5,64,5],[63,6,64,9],[63,10,64,11],[61,0,61,2],[61,3,62,3],[61,4,62,4],[61,5,62,5],[61,6,62,9],[61,10,62,11],[61,12,62,16],[62,0,62,2],[63,12,64,16],[64,0,64,2],[55,0,56,0],[55,1,55,3],[55,8,55,16],[56,1,56,3],[56,7,56,8],[59,0,59,2],[59,3,60,3],[59,4,60,4],[59,5,60,5],[59,6,60,10],[59,12,60,16],[60,0,60,2],[49,3,49,8],[50,4,50,7],[50,15,50,16],[53,1,53,3],[53,8,53,16],[54,8,54,15],[39,0,39,2],[39,6,39,9],[39,10,39,11],[39,12,39,16],[40,0,40,2],[40,3,40,5],[40,6,40,9],[40,10,40,11],[40,12,40,16],[36,12,37,16],[36,17,37,17],[36,18,37,18],[36,19,37,19],[37,0,37,2],[38,0,38,2],[38,3,38,5],[38,6,38,9],[38,10,38,11],[38,12,38,13],[36,0,36,2],[36,3,37,3],[36,4,37,4],[36,5,37,5],[36,6,37,9],[36,10,37,11],[34,10,35,11],[34,12,35,16],[34,17,35,17],[34,18,35,18],[34,19,35,19],[35,0,35,2],[32,12,33,16],[32,17,33,17],[32,18,33,18],[32,19,33,19],[33,0,33,2],[34,0,34,2],[34,3,35,3],[34,4,35,4],[34,5,35,5],[34,6,35,9],[32,0,32,2],[32,3,33,3],[32,4,33,4],[32,5,33,5],[32,6,33,9],[32,10,33,11],[30,10,31,11],[30,12,31,16],[30,17,31,17],[30,18,31,18],[30,19,31,19],[31,0,31,2],[28,12,29,16],[28,17,29,17],[28,18,29,18],[28,19,29,19],[29,0,29,2],[30,0,30,2],[30,3,31,3],[30,4,31,4],[30,5,31,5],[30,6,31,9],[28,0,28,2],[28,3,29,3],[28,4,29,4],[28,5,29,5],[28,6,29,9],[28,10,29,11],[26,10,27,11],[26,12,27,16],[26,17,27,17],[26,18,27,18],[26,19,27,19],[27,0,27,2],[24,12,25,16],[24,17,25,17],[24,18,25,18],[24,19,25,19],[25,0,25,2],[26,0,26,2],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,9],[24,0,24,2],[24,3,25,3],[24,4,25,4],[24,5,25,5],[24,6,25,9],[24,10,25,11],[22,10,23,11],[22,12,23,16],[22,17,23,17],[22,18,23,18],[22,19,23,19],[23,0,23,2],[20,12,21,16],[20,17,21,17],[20,18,21,18],[20,19,21,19],[21,0,21,2],[22,0,22,2],[22,3,23,3],[22,4,23,4],[22,5,23,5],[22,6,23,9],[20,0,20,2],[20,3,21,3],[20,4,21,4],[20,5,21,5],[20,6,21,9],[20,10,21,11],[18,10,19,11],[18,12,19,16],[18,17,19,17],[18,18,19,18],[18,19,19,19],[19,0,19,2],[16,12,17,16],[16,17,17,17],[16,18,17,18],[16,19,17,19],[17,0,17,2],[18,0,18,2],[18,3,19,3],[18,4,19,4],[18,5,19,5],[18,6,19,9],[16,0,16,2],[16,3,17,3],[16,4,17,4],[16,5,17,5],[16,6,17,9],[16,10,17,11],[14,10,15,11],[14,12,15,16],[14,17,15,17],[14,18,15,18],[14,19,15,19],[15,0,15,2],[12,12,13,16],[12,17,13,17],[12,18,13,18],[12,19,13,19],[13,0,13,2],[14,0,14,2],[14,3,15,3],[14,4,15,4],[14,5,15,5],[14,6,15,9],[12,0,12,2],[12,3,13,3],[12,4,13,4],[12,5,13,5],[12,6,13,9],[12,10,13,11],[0,3,0,8],[1,4,1,7],[1,15,1,16],[3,8,3,11],[4,1,4,3],[4,8,4,16],[10,0,10,2],[10,3,11,3],[10,4,11,4],[10,5,11,5],[10,6,11,10],[10,12,11,16],[11,0,11,2],[5,8,5,16],[6,0,7,0],[6,1,6,3],[6,8,6,16],[7,1,7,3],[7,7,7,8]]}
["　（請求元保管）",null,null," 請　求　書　（控) ",null,null,null,null,null,null,null,null,null,null,null,"No.",3]
[null,null,null,null,{"$f":"+請求書1枚目!E2","v":"00:00:00"}]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒",{"$f":"+請求書1枚目!I4","v":0}]
["納入場所",{"$f":"+請求書1枚目!B5","v":0},null,null,null,null,null,"住所",{"$f":"+請求書1枚目!I5","v":0}]
[null,null,null,null,null,null,null,"社名",{"$f":"+請求書1枚目!I6","v":0}]
[{"$f":"+請求書1枚目!A7","v":0},{"$f":"+請求書1枚目!B7","v":"00:00:00"},null,null,null,null,null,"電話",{"$f":"+請求書1枚目!I7","v":0}]
[null,{"$f":"+請求書1枚目!B8","v":"00:00:00"},null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,"T",{"$f":"+請求書1枚目!K8","v":0},"-",{"$f":"+請求書1枚目!M8","v":0},"-",{"$f":"+請求書1枚目!O8","v":0},"-",{"$f":"+請求書1枚目!Q8","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,{"$f":"ROUND(E13*F13,0)","v":0},null,null,null,{"$f":"+IF(R13=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R13=\"8%（軽減税率対象）\",8%,R13)","v":0},{"$f":"IF(OR(R13=\"非課税\",S13=\"不課税\"),G13*0,G13*S13)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E15*F15,0)","v":0},null,null,null,{"$f":"+IF(R15=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R15=\"8%（軽減税率対象）\",8%,R15)","v":0},{"$f":"IF(OR(R15=\"非課税\",S15=\"不課税\"),G15*0,G15*S15)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E17*F17,0)","v":0},null,null,null,{"$f":"+IF(R17=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R17=\"8%（軽減税率対象）\",8%,R17)","v":0},{"$f":"IF(OR(R17=\"非課税\",S17=\"不課税\"),G17*0,G17*S17)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E19*F19,0)","v":0},null,null,null,{"$f":"+IF(R19=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R19=\"8%（軽減税率対象）\",8%,R19)","v":0},{"$f":"IF(OR(R19=\"非課税\",S19=\"不課税\"),G19*0,G19*S19)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E21*F21,0)","v":0},null,null,null,{"$f":"+IF(R21=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R21=\"8%（軽減税率対象）\",8%,R21)","v":0},{"$f":"IF(OR(R21=\"非課税\",S21=\"不課税\"),G21*0,G21*S21)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E23*F23,0)","v":0},null,null,null,{"$f":"+IF(R23=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R23=\"8%（軽減税率対象）\",8%,R23)","v":0},{"$f":"IF(OR(R23=\"非課税\",S23=\"不課税\"),G23*0,G23*S23)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E25*F25,0)","v":0},null,null,null,{"$f":"+IF(R25=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R25=\"8%（軽減税率対象）\",8%,R25)","v":0},{"$f":"IF(OR(R25=\"非課税\",S25=\"不課税\"),G25*0,G25*S25)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E27*F27,0)","v":0},null,null,null,{"$f":"+IF(R27=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R27=\"8%（軽減税率対象）\",8%,R27)","v":0},{"$f":"IF(OR(R27=\"非課税\",S27=\"不課税\"),G27*0,G27*S27)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E29*F29,0)","v":0},null,null,null,{"$f":"+IF(R29=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R29=\"8%（軽減税率対象）\",8%,R29)","v":0},{"$f":"IF(OR(R29=\"非課税\",S29=\"不課税\"),G29*0,G29*S29)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E31*F31,0)","v":0},null,null,null,{"$f":"+IF(R31=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R31=\"8%（軽減税率対象）\",8%,R31)","v":0},{"$f":"IF(OR(R31=\"非課税\",S31=\"不課税\"),G31*0,G31*S31)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E33*F33,0)","v":0},null,null,null,{"$f":"+IF(R33=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R33=\"8%（軽減税率対象）\",8%,R33)","v":0},{"$f":"IF(OR(R33=\"非課税\",S33=\"不課税\"),G33*0,G33*S33)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E35*F35,0)","v":0},null,null,null,{"$f":"+IF(R35=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R35=\"8%（軽減税率対象）\",8%,R35)","v":0},{"$f":"IF(OR(R35=\"非課税\",S35=\"不課税\"),G35*0,G35*S35)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E37*F37,0)","v":0},null,null,null,{"$f":"+IF(R37=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R37=\"8%（軽減税率対象）\",8%,R37)","v":0},{"$f":"IF(OR(R37=\"非課税\",S37=\"不課税\"),G37*0,G37*S37)","v":0}]
[]
["品代計",null,null,null,null,null,{"$f":"IF(SUM(G13:J38)=0,\"\",SUM(請求書1枚目!G18:J33)+SUM('続き(2枚目)'!G13:J38)+SUM('続き(3枚目)'!G13:J38))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T13:T38)","v":0}]
[{"$f":"+請求書1枚目!A35","v":"消費税相当額"},null,null,null,null,null,{"$f":"IF(G39=\"\",\"\",請求書1枚目!D39+請求書1枚目!D40)","v":""}]
["合　　計",null,null,null,null,null,{"$f":"IF(G39=\"\",\"\",G39+G40)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
["　（工場・営業部門控）",null,null," 請　　　求　　　書 ",null,null,null,null,null,null,null,null,null,null,null,"No.",{"$f":"$Q$1","v":3}]
[null,null,null,null,{"$f":"$E$2","v":"00:00:00"}]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒",{"$f":"$I$4","v":0}]
["納入場所",{"$f":"$B$5","v":0},null,null,null,null,null,"住所",{"$f":"$I$5","v":0}]
[null,null,null,null,null,null,null,"社名",{"$f":"$I$6","v":0}]
[{"$f":"$A$7","v":0},{"$f":"$B$7","v":"00:00:00"},null,null,null,null,null,"電話",{"$f":"$I$7","v":0}]
[null,{"$f":"$B$8","v":"00:00:00"},null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,{"$f":"$J$8","v":"T"},{"$f":"+K8","v":0},"-",{"$f":"+M8","v":0},"-",{"$f":"+O8","v":0},"-",{"$f":"+Q8","v":0}]
[]
[]
["品　　　　　　　　　名",null,null,"単位","数量","単価","金　　　　額",null,null,null,null,null,"摘　　　　要"]
["（形状・寸法）"]
[{"$f":"+$A$13","v":0},null,null,{"$f":"+D13","v":0},{"$f":"$E$13","v":0},{"$f":"$F$13","v":0},{"$f":"+G13","v":0},null,null,null,{"$f":"+K13","v":0},null,{"$f":"+M13","v":0}]
[{"$f":"+A14","v":0}]
[0,null,null,{"$f":"+D15","v":0},{"$f":"+E15","v":0},{"$f":"+F15","v":0},{"$f":"+G15","v":0},null,null,null,{"$f":"+K15","v":0},null,{"$f":"+M15","v":0}]
[0]
[0,null,null,{"$f":"+D17","v":0},{"$f":"+E17","v":0},{"$f":"+F17","v":0},{"$f":"+G17","v":0},null,null,null,{"$f":"+K17","v":0},null,{"$f":"+M17","v":0}]
[0]
[0,null,null,{"$f":"+D19","v":0},{"$f":"+E19","v":0},{"$f":"+F19","v":0},{"$f":"+G19","v":0},null,null,null,{"$f":"+K19","v":0},null,{"$f":"+M19","v":0}]
[0]
[0,null,null,{"$f":"+D21","v":0},{"$f":"+E21","v":0},{"$f":"+F21","v":0},{"$f":"+G21","v":0},null,null,null,{"$f":"+K21","v":0},null,{"$f":"+M21","v":0}]
[0]
[0,null,null,{"$f":"+D23","v":0},{"$f":"+E23","v":0},{"$f":"+F23","v":0},{"$f":"+G23","v":0},null,null,null,{"$f":"+K23","v":0},null,{"$f":"+M23","v":0}]
[0]
[0,null,null,{"$f":"+D25","v":0},{"$f":"+E25","v":0},{"$f":"+F25","v":0},{"$f":"+G25","v":0},null,null,null,{"$f":"+K25","v":0},null,{"$f":"+M25","v":0}]
[0]
[0,null,null,{"$f":"+D27","v":0},{"$f":"+E27","v":0},{"$f":"+F27","v":0},{"$f":"+G27","v":0},null,null,null,{"$f":"+K27","v":0},null,{"$f":"+M27","v":0}]
[0]
[0,null,null,{"$f":"+D29","v":0},{"$f":"+E29","v":0},{"$f":"+F29","v":0},{"$f":"+G29","v":0},null,null,null,{"$f":"+K29","v":0},null,{"$f":"+M29","v":0}]
[0]
[0,null,null,{"$f":"+D31","v":0},{"$f":"+E31","v":0},{"$f":"+F31","v":0},{"$f":"+G31","v":0},null,null,null,{"$f":"+K31","v":0},null,{"$f":"+M31","v":0}]
[0]
[0,null,null,{"$f":"+D33","v":0},{"$f":"+E33","v":0},{"$f":"+F33","v":0},{"$f":"+G33","v":0},null,null,null,{"$f":"+K33","v":0},null,{"$f":"+M33","v":0}]
[0]
[0,null,null,{"$f":"+D35","v":0},{"$f":"+E35","v":0},{"$f":"+F35","v":0},{"$f":"+G35","v":0},null,null,null,{"$f":"+K35","v":0},null,{"$f":"+M35","v":0}]
[0]
[0,null,null,{"$f":"$D$37","v":0},{"$f":"+E37","v":0},{"$f":"+F37","v":0},{"$f":"+G37","v":0},null,null,null,{"$f":"+K37","v":0},null,{"$f":"+M37","v":0}]
[0]
[{"$f":"$A$39","v":"品代計"},null,null,null,null,null,{"$f":"+G39","v":""}]
[{"$f":"$A$40","v":"消費税相当額"},null,null,null,null,null,{"$f":"+G40","v":""}]
[{"$f":"$A$41","v":"合　　計"},null,null,{"$f":"$E$41","v":0},null,null,{"$f":"+G41","v":""}]
[]
[]
["経　　　理　　　部",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,null,null,null,null,null,null,null,null,null,null,"No.",{"$f":"$Q$1","v":3}]
[null,null,null,null,{"$f":"$E$2","v":"00:00:00"}]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒",{"$f":"$I$4","v":0}]
["納入場所",{"$f":"$B$5","v":0},null,null,null,null,null,"住所",{"$f":"$I$5","v":0}]
[null,null,null,null,null,null,null,"社名",{"$f":"$I$6","v":0}]
[{"$f":"$A$7","v":0},{"$f":"$B$7","v":"00:00:00"},null,null,null,null,null,"電話",{"$f":"$I$7","v":0}]
[null,{"$f":"$B$8","v":"00:00:00"},null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,{"$f":"$J$8","v":"T"},{"$f":"+K57","v":0},"-",{"$f":"+M57","v":0},"-",{"$f":"+O57","v":0},"-",{"$f":"+Q57","v":0}]
[]
[]
["品　　　　　　　　　名",null,null,"単位","数量","単価","金　　　　額",null,null,null,null,null,"摘　　　　要"]
["（形状・寸法）"]
[{"$f":"+A13","v":0},null,null,{"$f":"+D13","v":0},{"$f":"$E$13","v":0},{"$f":"$F$13","v":0},{"$f":"+G13","v":0},null,null,null,{"$f":"+K13","v":0},null,{"$f":"+M13","v":0}]
[0]
[0,null,null,{"$f":"+D15","v":0},{"$f":"+E64","v":0},{"$f":"+F64","v":0},{"$f":"+G15","v":0},null,null,null,{"$f":"+K15","v":0},null,{"$f":"+M15","v":0}]
[0]
[0,null,null,{"$f":"+D17","v":0},{"$f":"+E66","v":0},{"$f":"+F66","v":0},{"$f":"+G17","v":0},null,null,null,{"$f":"+K17","v":0},null,{"$f":"+M17","v":0}]
[0]
[0,null,null,{"$f":"+D19","v":0},{"$f":"+E68","v":0},{"$f":"+F68","v":0},{"$f":"+G19","v":0},null,null,null,{"$f":"+K19","v":0},null,{"$f":"+M19","v":0}]
[0]
[0,null,null,{"$f":"+D21","v":0},{"$f":"+E70","v":0},{"$f":"+F70","v":0},{"$f":"+G21","v":0},null,null,null,{"$f":"+K21","v":0},null,{"$f":"+M21","v":0}]
[0]
[0,null,null,{"$f":"+D23","v":0},{"$f":"+E72","v":0},{"$f":"+F72","v":0},{"$f":"+G23","v":0},null,null,null,{"$f":"+K23","v":0},null,{"$f":"+M23","v":0}]
[0]
[0,null,null,{"$f":"+D25","v":0},{"$f":"+E74","v":0},{"$f":"+F74","v":0},{"$f":"+G25","v":0},null,null,null,{"$f":"+K25","v":0},null,{"$f":"+M25","v":0}]
[0]
[0,null,null,{"$f":"+D27","v":0},{"$f":"+E76","v":0},{"$f":"+F76","v":0},{"$f":"+G27","v":0},null,null,null,{"$f":"+K27","v":0},null,{"$f":"+M27","v":0}]
[0]
[0,null,null,{"$f":"+D29","v":0},{"$f":"+E78","v":0},{"$f":"+F78","v":0},{"$f":"+G29","v":0},null,null,null,{"$f":"+K29","v":0},null,{"$f":"+M29","v":0}]
[0]
[0,null,null,{"$f":"+D31","v":0},{"$f":"+E80","v":0},{"$f":"+F80","v":0},{"$f":"+G31","v":0},null,null,null,{"$f":"+K31","v":0},null,{"$f":"+M31","v":0}]
[0]
[0,null,null,{"$f":"+D33","v":0},{"$f":"+E82","v":0},{"$f":"+F82","v":0},{"$f":"+G33","v":0},null,null,null,{"$f":"+K33","v":0},null,{"$f":"+M33","v":0}]
[0]
[0,null,null,{"$f":"+D35","v":0},{"$f":"+E84","v":0},{"$f":"+F84","v":0},{"$f":"+G35","v":0},null,null,null,{"$f":"+K35","v":0},null,{"$f":"+M35","v":0}]
[0]
[0,null,null,{"$f":"+D37","v":0},{"$f":"+E86","v":0},{"$f":"+F86","v":0},{"$f":"+G37","v":0},null,null,null,{"$f":"+K37","v":0},null,{"$f":"+M37","v":0}]
[0]
[{"$f":"$A$39","v":"品代計"},null,null,null,null,null,{"$f":"+G39","v":""}]
[{"$f":"$A$40","v":"消費税相当額"},null,null,null,null,null,{"$f":"+G40","v":""}]
[{"$f":"$A$41","v":"合　　計"},null,null,{"$f":"$E$41","v":0},null,null,{"$f":"+G41","v":""}]
[]
["経　　　理　　　部",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8%（軽減税率対象）"]
[null,null,null,null,null,null,null,null,null,null,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":"説明シート","index":3,"n_rows":143,"n_cols":20,"rows_kept":143,"cut":false,"hidden":false,"merged":[[139,0,139,2],[139,3,139,5],[142,13,142,16],[135,1,135,2],[135,3,135,4],[135,5,135,7],[135,8,135,9],[135,10,135,15],[136,1,136,2],[136,3,136,4],[136,5,136,7],[136,8,136,9],[136,10,136,15],[132,0,132,2],[132,3,132,5],[132,6,132,9],[132,12,132,16],[134,1,134,2],[134,3,134,4],[134,5,134,7],[134,8,134,9],[134,10,134,15],[130,0,130,2],[130,3,130,5],[130,6,130,9],[130,12,130,16],[131,0,131,2],[131,6,131,9],[131,12,131,16],[126,12,127,16],[127,0,127,2],[128,0,128,2],[128,3,129,3],[128,4,129,4],[128,5,129,5],[128,6,129,9],[128,10,129,11],[128,12,129,16],[129,0,129,2],[126,0,126,2],[126,3,127,3],[126,4,127,4],[126,5,127,5],[126,6,127,9],[126,10,127,11],[122,12,123,16],[123,0,123,2],[124,0,124,2],[124,3,125,3],[124,4,125,4],[124,5,125,5],[124,6,125,9],[124,10,125,11],[124,12,125,16],[125,0,125,2],[122,0,122,2],[122,3,123,3],[122,4,123,4],[122,5,123,5],[122,6,123,9],[122,10,123,11],[118,12,119,16],[119,0,119,2],[120,0,120,2],[120,3,121,3],[120,4,121,4],[120,5,121,5],[120,6,121,9],[120,10,121,11],[120,12,121,16],[121,0,121,2],[118,0,118,2],[118,3,119,3],[118,4,119,4],[118,5,119,5],[118,6,119,9],[118,10,119,11],[114,12,115,16],[115,0,115,2],[116,0,116,2],[116,3,117,3],[116,4,117,4],[116,5,117,5],[116,6,117,9],[116,10,117,11],[116,12,117,16],[117,0,117,2],[114,0,114,2],[114,3,115,3],[114,4,115,4],[114,5,115,5],[114,6,115,9],[114,10,115,11],[112,0,112,2],[112,3,113,3],[112,4,113,4],[112,5,113,5],[112,6,113,10],[112,12,113,16],[113,0,113,2],[106,8,106,10],[106,12,106,16],[108,0,110,0],[108,1,108,3],[108,12,109,12],[108,15,109,15],[109,1,110,3],[109,4,110,7],[100,8,100,16],[101,1,101,3],[101,8,101,16],[102,8,102,15],[103,0,104,0],[103,1,103,3],[103,8,103,16],[104,1,104,3],[104,7,104,8],[91,0,91,2],[91,3,91,5],[94,13,94,16],[97,3,97,8],[98,4,98,7],[98,15,98,16],[87,1,87,2],[87,3,87,4],[87,5,87,7],[87,8,87,9],[87,10,87,15],[88,1,88,2],[88,3,88,4],[88,5,88,7],[88,8,88,9],[88,10,88,15],[84,0,84,2],[84,3,84,5],[84,6,84,9],[84,12,84,16],[86,1,86,2],[86,3,86,4],[86,5,86,7],[86,8,86,9],[86,10,86,15],[82,0,82,2],[82,3,82,5],[82,6,82,9],[82,12,82,16],[83,0,83,2],[83,6,83,9],[83,12,83,16],[78,12,79,16],[79,0,79,2],[80,0,80,2],[80,3,81,3],[80,4,81,4],[80,5,81,5],[80,6,81,9],[80,10,81,11],[80,12,81,16],[81,0,81,2],[78,0,78,2],[78,3,79,3],[78,4,79,4],[78,5,79,5],[78,6,79,9],[78,10,79,11],[74,12,75,16],[75,0,75,2],[76,0,76,2],[76,3,77,3],[76,4,77,4],[76,5,77,5],[76,6,77,9],[76,10,77,11],[76,12,77,16],[77,0,77,2],[74,0,74,2],[74,3,75,3],[74,4,75,4],[74,5,75,5],[74,6,75,9],[74,10,75,11],[70,12,71,16],[71,0,71,2],[72,0,72,2],[72,3,73,3],[72,4,73,4],[72,5,73,5],[72,6,73,9],[72,10,73,11],[72,12,73,16],[73,0,73,2],[70,0,70,2],[70,3,71,3],[70,4,71,4],[70,5,71,5],[70,6,71,9],[70,10,71,11],[66,12,67,16],[67,0,67,2],[68,0,68,2],[68,3,69,3],[68,4,69,4],[68,5,69,5],[68,6,69,9],[68,10,69,11],[68,12,69,16],[69,0,69,2],[66,0,66,2],[66,3,67,3],[66,4,67,4],[66,5,67,5],[66,6,67,9],[66,10,67,11],[64,0,64,2],[64,3,65,3],[64,4,65,4],[64,5,65,5],[64,6,65,10],[64,12,65,16],[65,0,65,2],[60,0,62,0],[60,1,60,3],[60,12,61,12],[60,15,61,15],[61,1,62,3],[61,4,62,7],[55,0,56,0],[55,1,55,3],[55,8,55,16],[56,1,56,3],[56,7,56,8],[58,8,58,10],[58,12,58,16],[49,3,49,8],[50,4,50,7],[50,15,50,16],[53,1,53,3],[53,8,53,16],[54,8,54,15],[39,1,39,2],[39,3,39,4],[39,5,39,7],[39,8,39,9],[39,10,39,15],[41,15,41,16],[37,1,37,2],[37,3,37,4],[37,5,37,7],[37,8,37,9],[37,10,37,15],[38,1,38,2],[38,3,38,4],[38,5,38,7],[38,8,38,9],[38,10,38,15],[34,0,34,2],[34,6,34,9],[34,10,34,11],[34,12,34,16],[35,0,35,2],[35,3,35,5],[35,6,35,9],[35,10,35,11],[35,12,35,16],[31,12,32,16],[31,17,32,17],[31,18,32,18],[31,19,32,19],[32,0,32,2],[33,0,33,2],[33,3,33,5],[33,6,33,9],[33,10,33,11],[33,12,33,13],[31,0,31,2],[31,3,32,3],[31,4,32,4],[31,5,32,5],[31,6,32,9],[31,10,32,11],[29,10,30,11],[29,12,30,16],[29,17,30,17],[29,18,30,18],[29,19,30,19],[30,0,30,2],[27,12,28,16],[27,17,28,17],[27,18,28,18],[27,19,28,19],[28,0,28,2],[29,0,29,2],[29,3,30,3],[29,4,30,4],[29,5,30,5],[29,6,30,9],[27,0,27,2],[27,3,28,3],[27,4,28,4],[27,5,28,5],[27,6,28,9],[27,10,28,11],[25,10,26,11],[25,12,26,16],[25,17,26,17],[25,18,26,18],[25,19,26,19],[26,0,26,2],[23,12,24,16],[23,17,24,17],[23,18,24,18],[23,19,24,19],[24,0,24,2],[25,0,25,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[25,6,26,9],[23,0,23,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,6,24,9],[23,10,24,11],[21,10,22,11],[21,12,22,16],[21,17,22,17],[21,18,22,18],[21,19,22,19],[22,0,22,2],[19,12,20,16],[19,17,20,17],[19,18,20,18],[19,19,20,19],[20,0,20,2],[21,0,21,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[21,6,22,9],[17,17,18,17],[17,18,18,18],[17,19,18,19],[18,0,18,2],[19,0,19,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[19,6,20,9],[19,10,20,11],[15,12,16,16],[16,0,16,2],[17,0,17,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[17,6,18,9],[17,10,18,11],[17,12,18,16],[11,0,13,0],[11,1,11,3],[12,1,13,3],[12,4,13,8],[15,0,15,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,10],[5,8,5,16],[6,0,7,0],[6,1,6,3],[6,8,6,16],[7,1,7,3],[7,7,7,8],[0,3,0,8],[1,4,1,7],[1,15,1,16],[3,8,3,11],[4,1,4,3],[4,8,4,16]]}
["　（請求元保管）",null,null," 請　求　書　（控) ",null,null,null,null,null,null,null,null,null,null,null,"No.",1]
[null,null,null,null,"2023-10-31"]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒","350-1305"]
["納入場所","狭山市○○現場",null,null,null,null,null,"住所","埼玉県狭山市入間川〇丁目〇番〇号"]
[null,null,null,null,null,null,null,"社名","〇〇建材株式会社"]
[10,"2023-10-01",null,null,null,null,null,"電話","04-1111-11111"]
[null,"2023-10-31",null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,"T",4,"-",1234,"-",5678,"-",9123]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.1]
["下記のとおり請求いたします。",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8%（軽減税率対象）"]
["金　額","円",null,null,{"$f":"IF(E13=\"\",\"\",\"適格請求書発行事業者の方は登録番号の入力をお願いいたします。\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,"非課税"]
[null,{"$f":"+G36","v":285415},null,null,{"$f":"IF(K8=\"\",\"※消費税　免税事業者\",\"\")","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,"選択","税率","消費税額"]
["砕石2005",null,null,"t",120,2000,{"$f":"ROUND(E18*F18,0)","v":240000},null,null,null,{"$f":"+IF(R18=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,0.1,{"$f":"IF(R18=\"8%（軽減税率対象）\",8%,R18)","v":0.1},{"$f":"IF(OR(R18=\"非課税\",S18=\"不課税\"),G18*0,G18*S18)","v":24000}]
[1212]
["軽油",null,null,"ℓ",59.5,100,{"$f":"ROUND(E20*F20,0)","v":5950},null,null,null,{"$f":"+IF(R20=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,0.1,{"$f":"IF(R20=\"8%（軽減税率対象）\",8%,R20)","v":0.1},{"$f":"IF(OR(R20=\"非課税\",S20=\"不課税\"),G20*0,G20*S20)","v":595}]
[]
["軽油引取税",null,null,"ℓ",59.5,32.1,{"$f":"ROUND(E22*F22,0)","v":1910},null,null,null,{"$f":"+IF(R22=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,"不課税",{"$f":"IF(R22=\"8%（軽減税率対象）\",8%,R22)","v":"不課税"},{"$f":"IF(OR(R22=\"非課税\",S22=\"不課税\"),G22*0,G22*S22)","v":0}]
[]
["購読料",null,null,"月",12,1000,{"$f":"ROUND(E24*F24,0)","v":12000},null,null,null,{"$f":"+IF(R24=\"8%（軽減税率対象）\",\"＊\", )","v":"＊"},null,null,null,null,null,null,"8%（軽減税率対象）",{"$f":"IF(R24=\"8%（軽減税率対象）\",8%,R24)","v":0.08},{"$f":"IF(OR(R24=\"非課税\",S24=\"不課税\"),G24*0,G24*S24)","v":960}]
["2023.10-2024.9"]
[null,null,null,null,null,null,{"$f":"ROUND(E26*F26,0)","v":0},null,null,null,{"$f":"+IF(R26=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R26=\"8%（軽減税率対象）\",8%,R26)","v":0},{"$f":"IF(OR(R26=\"非課税\",S26=\"不課税\"),G26*0,G26*S26)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(R28=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R28=\"8%（軽減税率対象）\",8%,R28)","v":0},{"$f":"IF(OR(R28=\"非課税\",S28=\"不課税\"),G28*0,G28*S28)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(R30=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R30=\"8%（軽減税率対象）\",8%,R30)","v":0},{"$f":"IF(OR(R30=\"非課税\",S30=\"不課税\"),G30*0,G30*S30)","v":0}]
[]
[null,null,null,null,null,null,{"$f":"ROUND(E32*F32,0)","v":0},null,null,null,{"$f":"+IF(R32=\"8%（軽減税率対象）\",\"＊\", )","v":0},null,null,null,null,null,null,null,{"$f":"IF(R32=\"8%（軽減税率対象）\",8%,R32)","v":0},{"$f":"IF(OR(R32=\"非課税\",S32=\"不課税\"),G32*0,G32*S32)","v":0}]
[]
["品代計",null,null,null,null,null,{"$f":"SUM(G18:J33)","v":259860},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T18:T33)","v":25555}]
[{"$f":"+D38","v":"消費税"},null,null,null,null,null,{"$f":"SUM(D39:E40)","v":25555}]
["合　　計",null,null,null,null,null,{"$f":"+G34+G35","v":285415}]
[]
[null,"本体",null,{"$f":"IF(K8=\"\",\"消費税相当額\",\"消費税\")","v":"消費税"},null,{"$f":"IF(K8=\"\",\"合計\",\"税込\")","v":"税込"},null,null,null,null,"本体"]
["10％対象",{"$f":"SUMIF($R$18:$R$33,R10,$G$18:$J$33)","v":245950},null,{"$f":"IF(B39=\"\",0,ROUND(B39*10/100,0))","v":24595},null,{"$f":"+B39+D39","v":270545},null,null,"非課税対象",null,{"$f":"SUMIF($R$18:$R$33,R12,$G$18:$J$33)","v":0}]
["＊8％対象",{"$f":"SUMIF($R$18:$R$33,R11,$G$18:$J$33)","v":12000},null,{"$f":"IF(B40=\"\",0,ROUND(B40*8/100,0))","v":960},null,{"$f":"+B40+D40","v":12960},null,null,"不課税対象",null,{"$f":"SUMIF($R$18:$R$33,R13,$G$18:$J$33)","v":1910}]
[]
["＊印は軽減税率(8％)適用商品"]
[]
[]
[]
[]
[]
[]
[]
["　（工場・営業部門控）",null,null," 請　　　求　　　書 ",null,null,null,null,null,null,null,null,null,null,null,"No.",{"$f":"$Q$1","v":1}]
[null,null,null,null,{"$f":"$E$2","v":"2023-10-31"}]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒",{"$f":"$I$4","v":"350-1305"}]
["納入場所",{"$f":"$B$5","v":"狭山市○○現場"},null,null,null,null,null,"住所",{"$f":"$I$5","v":"埼玉県狭山市入間川〇丁目〇番〇号"}]
[null,null,null,null,null,null,null,"社名",{"$f":"$I$6","v":"〇〇建材株式会社"}]
[{"$f":"$A$7","v":10},{"$f":"$B$7","v":"2023-10-01"},null,null,null,null,null,"電話",{"$f":"$I$7","v":"04-1111-11111"}]
[null,{"$f":"$B$8","v":"2023-10-31"},null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,{"$f":"$J$8","v":"T"},{"$f":"+K8","v":4},"-",{"$f":"+M8","v":1234},"-",{"$f":"+O8","v":5678},"-",{"$f":"+Q8","v":9123}]
[]
[null,null,null,null,null,null,null,null,"支　　払　　日",null,null,null,"支払条件"]
["下記のとおり請求いたします。",null,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":"$B$13","v":285415},null,null,{"$f":"+E13","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,"摘　　　　要"]
["（形状・寸法）"]
[{"$f":"$A$18","v":"砕石2005"},null,null,{"$f":"$D$18","v":"t"},{"$f":"$E$18","v":120},{"$f":"$F$18","v":2000},{"$f":"$G$18","v":240000},null,null,null,{"$f":"$K$18","v":0},null,{"$f":"$M$18","v":0}]
[{"$f":"$A$19","v":1212}]
[{"$f":"$A$20","v":"軽油"},null,null,{"$f":"$D$20","v":"ℓ"},{"$f":"$E$20","v":59.5},{"$f":"$F$20","v":100},{"$f":"$G$20","v":5950},null,null,null,{"$f":"$K$20","v":0},null,{"$f":"$M$20","v":0}]
[{"$f":"$A$21","v":0}]
[{"$f":"$A$22","v":"軽油引取税"},null,null,{"$f":"$D$22","v":"ℓ"},{"$f":"$E$22","v":59.5},{"$f":"$F$22","v":32.1},{"$f":"$G$22","v":1910},null,null,null,{"$f":"$K$22","v":0},null,{"$f":"$M$22","v":0}]
[{"$f":"$A$23","v":0}]
[{"$f":"$A$24","v":"購読料"},null,null,{"$f":"$D$24","v":"月"},{"$f":"$E$24","v":12},{"$f":"$F$24","v":1000},{"$f":"$G$24","v":12000},null,null,null,{"$f":"$K$24","v":"＊"},null,{"$f":"$M$24","v":0}]
[{"$f":"$A$25","v":"2023.10-2024.9"}]
[{"$f":"$A$26","v":0},null,null,{"$f":"$D$26","v":0},{"$f":"$E$26","v":0},{"$f":"$F$26","v":0},{"$f":"$G$26","v":0},null,null,null,{"$f":"$K$26","v":0},null,{"$f":"$M$26","v":0}]
[{"$f":"$A$27","v":0}]
[{"$f":"$A$28","v":0},null,null,{"$f":"$D$28","v":0},{"$f":"$E$28","v":0},{"$f":"$F$28","v":0},{"$f":"$G$28","v":0},null,null,null,{"$f":"$K$28","v":0},null,{"$f":"$M$28","v":0}]
[{"$f":"$A$29","v":0}]
[{"$f":"$A$30","v":0},null,null,{"$f":"$D$30","v":0},{"$f":"$E$30","v":0},{"$f":"$F$30","v":0},{"$f":"$G$30","v":0},null,null,null,{"$f":"$K$30","v":0},null,{"$f":"$M$30","v":0}]
[{"$f":"$A$31","v":0}]
[{"$f":"$A$32","v":0},null,null,{"$f":"$D$32","v":0},{"$f":"$E$32","v":0},{"$f":"$F$32","v":0},{"$f":"$G$32","v":0},null,null,null,{"$f":"$K$32","v":0},null,{"$f":"$M$32","v":0}]
[{"$f":"$A$33","v":0}]
[{"$f":"$A$34","v":"品代計"},null,null,null,null,null,{"$f":"$G$34","v":259860}]
[{"$f":"$A$35","v":"消費税"},null,null,null,null,null,{"$f":"$G$35","v":25555}]
[{"$f":"$A$36","v":"合　　計"},null,null,{"$f":"$E$36","v":0},null,null,{"$f":"$G$36","v":285415}]
[]
[null,"本体",null,{"$f":"+D38","v":"消費税"},null,{"$f":"+F38","v":"税込"},null,null,null,null,"本体"]
["10％対象",{"$f":"$B$39","v":245950},null,{"$f":"$D$39","v":24595},null,{"$f":"$F$39","v":270545},null,null,"非課税対象",null,{"$f":"+K39","v":0}]
["＊8％対象",{"$f":"+B40","v":12000},null,{"$f":"+D40","v":960},null,{"$f":"+F40","v":12960},null,null,"不課税対象",null,{"$f":"+K40","v":1910}]
["＊印は軽減税率(8％)適用商品"]
[]
["経　　　理　　　部",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,null,null,null,null,null,null,null,null,null,null,"No.",{"$f":"$Q$1","v":1}]
[null,null,null,null,{"$f":"$E$2","v":"2023-10-31"}]
["ＳＫマテリアル株式会社　御中"]
[null,null,null,null,null,null,null,"〒",{"$f":"$I$4","v":"350-1305"}]
["納入場所",{"$f":"$B$5","v":"狭山市○○現場"},null,null,null,null,null,"住所",{"$f":"$I$5","v":"埼玉県狭山市入間川〇丁目〇番〇号"}]
[null,null,null,null,null,null,null,"社名",{"$f":"$I$6","v":"〇〇建材株式会社"},null,null,null,null,null,null,null,"印"]
[{"$f":"$A$7","v":10},{"$f":"$B$7","v":"2023-10-01"},null,null,null,null,null,"電話",{"$f":"$I$7","v":"04-1111-11111"}]
[null,{"$f":"$B$8","v":"2023-10-31"},null,null,null,null,null,"適格請求書\n発行事業者登録番号",null,{"$f":"$J$8","v":"T"},{"$f":"+K57","v":4},"-",{"$f":"+M57","v":1234},"-",{"$f":"+O57","v":5678},"-",{"$f":"+Q57","v":9123}]
[]
[null,null,null,null,null,null,null,null,"支　　払　　日",null,null,null,"支払条件"]
["下記のとおり請求いたします。",null,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":"$B$13","v":285415},null,null,{"$f":"+E62","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,"摘　　　　要"]
["（形状・寸法）"]
[{"$f":"$A$18","v":"砕石2005"},null,null,{"$f":"$D$18","v":"t"},{"$f":"$E$18","v":120},{"$f":"$F$18","v":2000},{"$f":"$G$18","v":240000},null,null,null,{"$f":"$K$18","v":0},null,{"$f":"$M$18","v":0}]
[{"$f":"$A$19","v":1212}]
[{"$f":"$A$20","v":"軽油"},null,null,{"$f":"$D$20","v":"ℓ"},{"$f":"$E$20","v":59.5},{"$f":"$F$20","v":100},{"$f":"$G$20","v":5950},null,null,null,{"$f":"$K$20","v":0},null,{"$f":"$M$20","v":0}]
[{"$f":"$A$21","v":0}]
[{"$f":"$A$22","v":"軽油引取税"},null,null,{"$f":"$D$22","v":"ℓ"},{"$f":"$E$22","v":59.5},{"$f":"$F$22","v":32.1},{"$f":"$G$22","v":1910},null,null,null,{"$f":"$K$22","v":0},null,{"$f":"$M$22","v":0}]
[{"$f":"$A$23","v":0}]
[{"$f":"$A$24","v":"購読料"},null,null,{"$f":"$D$24","v":"月"},{"$f":"$E$24","v":12},{"$f":"$F$24","v":1000},{"$f":"$G$24","v":12000},null,null,null,{"$f":"$K$24","v":"＊"},null,{"$f":"$M$24","v":0}]
[{"$f":"$A$25","v":"2023.10-2024.9"}]
[{"$f":"$A$26","v":0},null,null,{"$f":"$D$26","v":0},{"$f":"$E$26","v":0},{"$f":"$F$26","v":0},{"$f":"$G$26","v":0},null,null,null,{"$f":"$K$26","v":0},null,{"$f":"$M$26","v":0}]
[{"$f":"$A$27","v":0}]
[{"$f":"$A$28","v":0},null,null,{"$f":"$D$28","v":0},{"$f":"$E$28","v":0},{"$f":"$F$28","v":0},{"$f":"$G$28","v":0},null,null,null,{"$f":"$K$28","v":0},null,{"$f":"$M$28","v":0}]
[{"$f":"$A$29","v":0}]
[{"$f":"$A$30","v":0},null,null,{"$f":"$D$30","v":0},{"$f":"$E$30","v":0},{"$f":"$F$30","v":0},{"$f":"$G$30","v":0},null,null,null,{"$f":"$K$30","v":0},null,{"$f":"$M$30","v":0}]
[{"$f":"$A$31","v":0}]
[{"$f":"$A$32","v":0},null,null,{"$f":"$D$32","v":0},{"$f":"$E$32","v":0},{"$f":"$F$32","v":0},{"$f":"$G$32","v":0},null,null,null,{"$f":"$K$32","v":0},null,{"$f":"$M$32","v":0}]
[{"$f":"$A$33","v":0}]
[{"$f":"$A$34","v":"品代計"},null,null,null,null,null,{"$f":"$G$34","v":259860}]
[{"$f":"$A$35","v":"消費税"},null,null,null,null,null,{"$f":"$G$35","v":25555}]
[{"$f":"$A$36","v":"合　　計"},null,null,{"$f":"$E$36","v":0},null,null,{"$f":"$G$36","v":285415}]
[]
[null,"本体",null,{"$f":"+D87","v":"消費税"},null,{"$f":"+F87","v":"税込"},null,null,null,null,"本体"]
["10％対象",{"$f":"$B$39","v":245950},null,{"$f":"$D$39","v":24595},null,{"$f":"$F$39","v":270545},null,null,"非課税対象",null,{"$f":"+K39","v":0}]
["＊8％対象",{"$f":"+B40","v":12000},null,{"$f":"+D40","v":960},null,{"$f":"+F40","v":12960},null,null,"不課税対象",null,{"$f":"+K40","v":1910}]
["＊印は軽減税率(8％)適用商品"]
[]
["経　　　理　　　部",null,null,"担当部",null,null,"     　　部  ・  事業部",null,null,null,null,null,null,"  工        場"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"工事稟議No"]