{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["納品書","請求書(A4)","納品書【記入要領】","請求書【記入要領】","環境(削除不可)","宛先一覧","品名一覧","単位一覧","備考一覧"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":62,"n_cols":39,"rows_kept":62,"cut":false,"hidden":false,"merged":[[46,25,46,29],[60,1,60,2],[60,3,60,12],[60,13,60,15],[60,16,60,17],[60,18,60,21],[60,22,60,28],[60,29,60,38],[56,1,56,2],[56,3,56,12],[56,13,56,15],[56,16,56,17],[56,18,56,21],[56,22,56,28],[56,29,56,38],[57,1,57,2],[57,3,57,12],[57,13,57,15],[57,16,57,17],[57,18,57,21],[57,22,57,28],[57,29,57,38],[54,1,54,2],[54,3,54,12],[61,22,61,28],[58,1,58,2],[58,3,58,12],[58,13,58,15],[58,16,58,17],[58,18,58,21],[58,22,58,28],[58,29,58,38],[59,1,59,2],[59,3,59,12],[59,13,59,15],[59,16,59,17],[59,18,59,21],[59,22,59,28],[59,29,59,38],[54,13,54,15],[54,16,54,17],[54,18,54,21],[54,22,54,28],[54,29,54,38],[55,1,55,2],[55,3,55,12],[55,13,55,15],[55,16,55,17],[55,18,55,21],[55,22,55,28],[55,29,55,38],[50,22,50,23],[50,24,50,28],[50,29,50,30],[50,31,50,35],[51,25,51,38],[52,22,52,24],[52,25,52,38],[53,1,53,2],[53,3,53,12],[53,13,53,15],[53,16,53,17],[53,18,53,21],[53,22,53,28],[53,29,53,38],[45,1,45,12],[36,29,36,38],[37,29,37,38],[38,29,38,38],[39,29,39,38],[40,29,40,38],[41,22,41,28],[37,18,37,21],[37,3,37,12],[37,13,37,15],[38,3,38,12],[38,13,38,15],[36,1,36,2],[36,16,36,17],[36,18,36,21],[36,22,36,28],[22,30,22,31],[22,32,22,38],[23,30,23,38],[31,25,31,38],[42,16,43,23],[42,30,42,31],[42,32,42,38],[43,30,43,38],[44,34,44,35],[26,25,26,29],[24,34,24,35],[22,16,23,23],[33,29,33,38],[34,29,34,38],[34,18,34,21],[34,22,34,28],[35,22,35,28],[32,22,32,24],[32,25,32,38],[35,29,35,38],[20,22,20,28],[39,22,39,28],[40,1,40,2],[40,16,40,17],[40,18,40,21],[40,22,40,28],[39,1,39,2],[39,16,39,17],[39,18,39,21],[39,3,39,12],[39,13,39,15],[40,3,40,12],[40,13,40,15],[37,22,37,28],[38,1,38,2],[38,16,38,17],[38,18,38,21],[38,22,38,28],[37,1,37,2],[37,16,37,17],[36,3,36,12],[36,13,36,15],[34,1,34,2],[34,16,34,17],[33,1,33,2],[33,16,33,17],[33,18,33,21],[33,22,33,28],[33,3,33,12],[33,13,33,15],[34,3,34,12],[34,13,34,15],[35,3,35,12],[35,13,35,15],[35,1,35,2],[35,16,35,17],[35,18,35,21],[10,25,10,38],[19,22,19,28],[15,22,15,28],[13,22,13,28],[12,29,12,38],[13,29,13,38],[16,1,16,2],[16,16,16,17],[16,18,16,21],[16,22,16,28],[15,1,15,2],[15,16,15,17],[15,18,15,21],[19,1,19,2],[19,16,19,17],[19,18,19,21],[17,22,17,28],[18,1,18,2],[18,16,18,17],[18,18,18,21],[18,22,18,28],[17,1,17,2],[13,16,13,17],[13,18,13,21],[11,1,11,38],[17,16,17,17],[17,18,17,21],[18,13,18,15],[19,13,19,15],[12,1,12,2],[12,16,12,17],[12,18,12,21],[12,22,12,28],[14,29,14,38],[15,29,15,38],[16,29,16,38],[17,29,17,38],[18,29,18,38],[19,29,19,38],[2,34,2,35],[0,30,0,31],[0,32,0,38],[1,30,1,38],[3,1,3,12],[9,25,9,38],[0,16,1,23],[8,29,8,30],[8,31,8,35],[8,22,8,23],[8,24,8,28],[4,25,4,29],[25,1,25,12],[30,22,30,23],[30,24,30,28],[30,29,30,30],[30,31,30,35],[12,13,12,15],[13,13,13,15],[13,3,13,12],[14,3,14,12],[15,3,15,12],[16,3,16,12],[17,3,17,12],[18,3,18,12],[19,3,19,12],[12,3,12,12],[14,13,14,15],[15,13,15,15],[16,13,16,15],[17,13,17,15],[14,1,14,2],[14,16,14,17],[14,18,14,21],[14,22,14,28],[13,1,13,2]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"納 品 書",null,null,null,null,null,null,null,null,null,null,null,null,null,"No.",null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,1,"/",1]
[null,"スーパー白井",null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP(B4,宛先一覧!$B$3:$C$22,2,FALSE)","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,"273-0123　"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,null,"千葉県鎌ケ谷市東中沢2-4-6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"事業者名",null,null,null,"中沢商事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者職氏名",null,null,null,null,"代表",null,"冨澤　徹"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"℡：",null,"047-438-3456",null,null,null,null,"FAX:",null,"047-438-3456"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　","担当:冨澤　徹 (携帯:090-6543-0110)"]
[null,null,"下記のとおり納品致します。"]
[null,"記"]
[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,"油揚げ　　　　　　　　　4kg",null,null,null,null,null,null,null,null,null,160,null,null,"枚",null,60,null,null,null,{"$f":"IF(S14<>\"\",S14*N14,\"\")","v":9600},null,null,null,null,null,null,"製造：   /       ："]
[null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(S15<>\"\",S15*N15,\"\")","v":""}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(W14:AC20)","v":9600}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"納 品 書(控）",null,null,null,null,null,null,null,null,null,null,null,null,null,"No.",null,{"$f":"IF(AG1<>\"\",AG1,\"\")","v":3}]
[null,null,null,null,null,null,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":"AE2","v":"2023-05-26"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,1,"/",1]
[null,{"$f":"B4","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,{"$f":"Z$5","v":"273-0123　"}]
[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":"Z$6","v":"千葉県鎌ケ谷市東中沢2-4-6"}]
[null,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":"AA$7","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,{"$f":"AD$8","v":"冨澤　徹"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"℡：",null,{"$f":"Y$9","v":"047-438-3456"},null,null,null,null,"FAX:",null,{"$f":"AF$9","v":"047-438-3456"}]
[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":"Z$10","v":"担当:冨澤　徹 (携帯:090-6543-0110)"}]
[]
[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,{"$f":"IF(D14<>\"\",D14,\"\")","v":"油揚げ　　　　　　　　　4kg"},null,null,null,null,null,null,null,null,null,{"$f":"IF(N14<>\"\",N14,\"\")","v":160},null,null,{"$f":"IF(Q14<>\"\",Q14,\"\")","v":"枚"},null,{"$f":"IF(S14<>\"\",S14,\"\")","v":60},null,null,null,{"$f":"IF(N35<>\"\",N35*S35,\"\")","v":9600},null,null,null,null,null,null,{"$f":"IF(AD14<>\"\",AD14,\"\")","v":"製造：   /       ："}]
[null,2,null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(N15<>\"\",N15,\"\")","v":""},null,null,"",null,"",null,null,null,{"$f":"IF(N36<>\"\",N36*S36,\"\")","v":""},null,null,null,null,null,null,""]
[null,3,null,"",null,null,null,null,null,null,null,null,null,{"$f":"IF(N16<>\"\",N16,\"\")","v":""},null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[null,4,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[null,5,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[null,6,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[null,7,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,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":"SUM(W35:AC41)","v":9600}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"内 訳 書",null,null,null,null,null,null,null,null,null,null,null,null,null,"No.",null,{"$f":"IF(AG23<>\"\",AG23,\"\")","v":3}]
[null,null,null,null,null,null,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":"AE24","v":"2023-05-26"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,1,"/",1]
[null,{"$f":"B26","v":"スーパー白井"},null,null,null,null,null,null,null,null,null,null,null,"様"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z$5","v":"273-0123　"}]
[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":"Z$6","v":"千葉県鎌ケ谷市東中沢2-4-6"}]
[null,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":"AA$7","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,{"$f":"AD$8","v":"冨澤　徹"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"℡：",null,{"$f":"Y$9","v":"047-438-3456"},null,null,null,null,"FAX:",null,{"$f":"AF$9","v":"047-438-3456"}]
[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":"Z$10","v":"担当:冨澤　徹 (携帯:090-6543-0110)"}]
[]
[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,{"$f":"IF(D35<>\"\",D35,\"\")","v":"油揚げ　　　　　　　　　4kg"},null,null,null,null,null,null,null,null,null,{"$f":"IF(N35<>\"\",N35,\"\")","v":160},null,null,{"$f":"IF(Q35<>\"\",Q35,\"\")","v":"枚"},null,{"$f":"IF(S35<>\"\",S35,\"\")","v":60},null,null,null,{"$f":"IF(N55<>\"\",N55*S55,\"\")","v":9600},null,null,null,null,null,null,{"$f":"IF(AD35<>\"\",AD35,\"\")","v":"製造：   /       ："}]
[null,2,null,{"$f":"IF(D36<>\"\",D36,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(N36<>\"\",N36,\"\")","v":""},null,null,"",null,"",null,null,null,{"$f":"IF(N56<>\"\",N56*S56,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AD36<>\"\",AD36,\"\")","v":""}]
[null,3,null,{"$f":"IF(D37<>\"\",D37,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(N37<>\"\",N37,\"\")","v":""},null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[null,4,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[null,5,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[null,6,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[null,7,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,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":"SUM(W55:AC61)","v":9600}]

{"sheet":"請求書(A4)","index":1,"n_rows":30,"n_cols":29,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,15,27,27],[27,28,27,35],[28,28,28,35],[29,15,29,27],[29,28,29,35],[28,15,28,27],[25,15,25,19],[25,20,25,21],[25,22,25,27],[25,28,25,35],[25,0,25,12],[25,13,25,14],[26,15,26,19],[26,20,26,21],[26,22,26,27],[26,28,26,35],[26,0,26,12],[26,13,26,14],[23,15,23,19],[23,20,23,21],[23,22,23,27],[23,28,23,35],[23,0,23,12],[23,13,23,14],[24,15,24,19],[24,20,24,21],[24,22,24,27],[24,28,24,35],[24,0,24,12],[24,13,24,14],[21,15,21,19],[21,20,21,21],[21,22,21,27],[21,28,21,35],[21,0,21,12],[21,13,21,14],[22,15,22,19],[22,20,22,21],[22,22,22,27],[22,28,22,35],[22,0,22,12],[22,13,22,14],[19,15,19,19],[19,20,19,21],[19,22,19,27],[19,28,19,35],[19,0,19,12],[19,13,19,14],[20,15,20,19],[20,20,20,21],[20,22,20,27],[20,28,20,35],[20,0,20,12],[20,13,20,14],[18,0,18,35],[12,23,12,35],[13,18,13,19],[13,20,13,24],[13,25,13,26],[13,27,13,31],[14,21,14,34],[15,1,15,8],[15,9,15,10],[15,11,15,12],[15,14,15,15],[16,8,16,35],[11,23,11,35],[0,1,1,32],[2,26,2,35],[4,0,4,9],[7,20,7,35],[9,22,9,35],[31,4,31,5],[27,1,27,4],[27,5,27,8],[27,9,27,10],[27,11,27,14],[28,1,28,4],[28,9,28,10],[28,5,28,8],[28,11,28,14]]}
[null,"請　　求　　書"]
[]
[null,null,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":"納品書!AE24","v":"2023-05-26"}]
[]
["松戸市立病院",null,null,null,null,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":"納品書!Z27","v":"273-0123　"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,{"$f":"納品書!Z28","v":"千葉県鎌ケ谷市東中沢2-4-6"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"事業者名",null,null,null,{"$f":"納品書!AA29","v":"中沢商事"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"登録番号",null,null,null,null,"T1234567890123"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者職氏名",null,null,null,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":"納品書!AD30","v":"冨澤　徹"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"℡：",null,{"$f":"納品書!Y31","v":"047-438-3456"},null,null,null,null,"FAX:",null,{"$f":"納品書!AF31","v":"047-438-3456"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　",{"$f":"納品書!Z32","v":"担当:冨澤　徹 (携帯:090-6543-0110)"}]
[null,null,null,null,null,null,null,null,null,"令和",null,5,null,"年",5,null,"月分"]
[null,null,null,null,null,null,null,null,"病院用賄材料費として下記のとおりご請求致します。"]
[]
["記"]
["品　　　目",null,null,null,null,null,null,null,null,null,null,null,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":"IFERROR(VLOOKUP(A21,品名一覧!$B$2:$D$22,3,FALSE),\"\")","v":0.08},null,160,null,null,null,null,"枚",null,60,null,null,null,null,null,{"$f":"IF(W21<>\"\",W21*P21,\"\")","v":9600}]
["袋(中）",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A22,品名一覧!$B$2:$D$22,3,FALSE),\"\")","v":0.1},null,5,null,null,null,null,"枚",null,3,null,null,null,null,null,{"$f":"IF(W22<>\"\",W22*P22,\"\")","v":15}]
["生揚げ（１／４）",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A23,品名一覧!$B$2:$D$22,3,FALSE),\"\")","v":0.08},null,50,null,null,null,null,"枚",null,55,null,null,null,null,null,2750]
["袋(大）",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A24,品名一覧!$B$2:$D$22,3,FALSE),\"\")","v":0.1},null,170,null,null,null,null,"枚",null,5,null,null,null,null,null,850]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A25,品名一覧!$B$2:$D$22,3,FALSE),\"\")","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,{"$f":"IFERROR(VLOOKUP(A26,品名一覧!$B$2:$D$22,3,FALSE),\"\")","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,{"$f":"IFERROR(VLOOKUP(A27,品名一覧!$B$2:$D$22,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"_xlfn.UNIQUE(N21:N27,FALSE,FALSE)","v":0.08},"対象金額",null,null,null,{"$f":"SUMIF(N$21:N$27,A$28,AC$21:AC$27)","v":12350},null,null,null,"税額",null,{"$f":"ROUNDDOWN(F28*A28,0)","v":988},null,null,null,"  合 計 金 額",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC21:AJ27)","v":13215}]
[0.1,"対象金額",null,null,null,{"$f":"SUMIF(N$21:N$27,A$29,AC$21:AC$27)","v":865},null,null,null,"税額",null,{"$f":"ROUNDDOWN(F29*A29,0)","v":86},null,null,null,"  消 費 税 額",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L28:O29)","v":1074}]
["",null,null,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":"AC28+AC29","v":14289}]

{"sheet":"納品書【記入要領】","index":2,"n_rows":46,"n_cols":43,"rows_kept":46,"cut":false,"hidden":false,"merged":[[3,0,3,11],[8,21,8,22],[8,23,8,27],[8,28,8,29],[8,30,8,34],[0,15,1,22],[0,29,0,30],[0,31,0,37],[1,29,1,37],[2,33,2,34],[4,24,4,28],[9,24,9,37],[10,24,10,37],[11,0,11,37],[12,0,12,1],[12,2,12,11],[12,12,12,14],[12,15,12,16],[12,17,12,20],[12,21,12,27],[12,28,12,37],[13,28,13,37],[14,0,14,1],[14,2,14,11],[14,12,14,14],[14,15,14,16],[14,17,14,20],[14,21,14,27],[14,28,14,37],[13,0,13,1],[13,2,13,11],[13,12,13,14],[13,15,13,16],[13,17,13,20],[13,21,13,27],[15,28,15,37],[16,0,16,1],[16,2,16,11],[16,12,16,14],[16,15,16,16],[16,17,16,20],[16,21,16,27],[16,28,16,37],[15,0,15,1],[15,2,15,11],[15,12,15,14],[15,15,15,16],[15,17,15,20],[15,21,15,27],[17,28,17,37],[18,0,18,1],[18,2,18,11],[18,12,18,14],[18,15,18,16],[18,17,18,20],[18,21,18,27],[18,28,18,37],[17,0,17,1],[17,2,17,11],[17,12,17,14],[17,15,17,16],[17,17,17,20],[17,21,17,27],[28,33,28,34],[29,0,29,11],[34,21,34,22],[34,23,34,27],[34,28,34,29],[34,30,34,34],[30,24,30,28],[19,28,19,37],[20,21,20,27],[26,15,27,22],[26,29,26,30],[26,31,26,37],[27,29,27,37],[19,0,19,1],[19,2,19,11],[19,12,19,14],[19,15,19,16],[19,17,19,20],[19,21,19,27],[35,24,35,37],[36,21,36,23],[36,24,36,37],[37,0,37,1],[37,2,37,11],[37,12,37,14],[37,15,37,16],[37,17,37,20],[37,21,37,27],[37,28,37,37],[38,28,38,37],[39,0,39,1],[39,2,39,11],[39,12,39,14],[39,15,39,16],[39,17,39,20],[39,21,39,27],[39,28,39,37],[38,0,38,1],[38,2,38,11],[38,12,38,14],[38,15,38,16],[38,17,38,20],[38,21,38,27],[40,28,40,37],[41,0,41,1],[41,2,41,11],[41,12,41,14],[41,15,41,16],[41,17,41,20],[41,21,41,27],[41,28,41,37],[40,0,40,1],[40,2,40,11],[40,12,40,14],[40,15,40,16],[40,17,40,20],[40,21,40,27],[44,28,44,37],[45,21,45,27],[44,0,44,1],[44,2,44,11],[44,12,44,14],[44,15,44,16],[44,17,44,20],[44,21,44,27],[42,28,42,37],[43,0,43,1],[43,2,43,11],[43,12,43,14],[43,15,43,16],[43,17,43,20],[43,21,43,27],[43,28,43,37],[42,0,42,1],[42,2,42,11],[42,12,42,14],[42,15,42,16],[42,17,42,20],[42,21,42,27]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"納 品 書",null,null,null,null,null,null,null,null,null,null,null,null,null,"No."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-05-26"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,1,"/",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,null,null,null,null,null,null,null,null,"：必須入力"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"273-0123　",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"：任意入力"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,null,"千葉県鎌ケ谷市東中沢2-4-6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"：入力不可（自動表示の計算式あり）"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"事業者名",null,null,null,"中沢商事"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者職氏名",null,null,null,null,"代表",null,"冨澤　徹"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"℡：",null,"047-438-3456",null,null,null,null,"FAX:",null,"047-438-3456"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　","担当:冨澤　徹 (携帯:090-6543-0110)"]
[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,111,null,null,"Kg",null,2222,null,null,null,{"$f":"IF(R14<>\"\",R14*M14,\"\")","v":246642}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R15<>\"\",R15*M15,\"\")","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"SUM(V14:AB20)","v":246642}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"内 訳 書",null,null,null,null,null,null,null,null,null,null,null,null,null,"No.",null,{"$f":"IF(AF1<>\"\",AF1,\"\")","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,{"$f":"AD2","v":"2023-05-26"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Page",null,1,"/",1]
[{"$f":"A4","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,{"$f":"Y$5","v":"273-0123　"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,null,{"$f":"Y$6","v":"千葉県鎌ケ谷市東中沢2-4-6"}]
[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":"Z$7","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,{"$f":"AC$8","v":"冨澤　徹"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"℡：",null,{"$f":"X$9","v":"047-438-3456"},null,null,null,null,"FAX:",null,{"$f":"AE$9","v":"047-438-3456"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　",{"$f":"Y$10","v":"担当:冨澤　徹 (携帯:090-6543-0110)"}]
[]
["項番",null,"品　名　／　摘　要",null,null,null,null,null,null,null,null,null,"数量",null,null,"単位",null,"単価(円)",null,null,null,"金　額  (円)",null,null,null,null,null,null,"備　　　　考"]
[1,null,{"$f":"IF(C14<>\"\",C14,\"\")","v":"木綿　豆腐１"},null,null,null,null,null,null,null,null,null,{"$f":"IF(M14<>\"\",M14,\"\")","v":111},null,null,{"$f":"IF(P14<>\"\",P14,\"\")","v":"Kg"},null,{"$f":"IF(R14<>\"\",R14,\"\")","v":2222},null,null,null,{"$f":"IF(M39<>\"\",M39*R39,\"\")","v":246642},null,null,null,null,null,null,{"$f":"IF(AC14<>\"\",AC14,\"\")","v":""}]
[2,null,{"$f":"IF(C15<>\"\",C15,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(M15<>\"\",M15,\"\")","v":""},null,null,"",null,"",null,null,null,{"$f":"IF(M40<>\"\",M40*R40,\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AC15<>\"\",AC15,\"\")","v":""}]
[3,null,{"$f":"IF(C16<>\"\",C16,\"\")","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(M16<>\"\",M16,\"\")","v":""},null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[4,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[5,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[6,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,null,null,null,null,""]
[7,null,"",null,null,null,null,null,null,null,null,null,"",null,null,"",null,"",null,null,null,"",null,null,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":"SUM(V39:AB45)","v":246642}]

{"sheet":"請求書【記入要領】","index":3,"n_rows":30,"n_cols":41,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,1,27,4],[27,5,27,8],[27,9,27,10],[27,11,27,14],[28,1,28,4],[28,5,28,8],[28,9,28,10],[28,11,28,14],[11,23,11,35],[12,23,12,35],[15,1,15,8],[15,9,15,10],[15,11,15,12],[15,14,15,15],[13,18,13,19],[13,20,13,24],[13,25,13,26],[13,27,13,31],[14,21,14,34],[0,1,1,32],[2,26,2,35],[4,0,4,9],[7,20,7,35],[9,22,9,35],[21,15,21,19],[21,20,21,21],[21,22,21,27],[21,28,21,35],[21,0,21,12],[21,13,21,14],[20,15,20,19],[20,20,20,21],[20,22,20,27],[20,28,20,35],[20,0,20,12],[20,13,20,14],[23,15,23,19],[23,20,23,21],[23,22,23,27],[23,28,23,35],[23,0,23,12],[23,13,23,14],[22,15,22,19],[22,20,22,21],[22,22,22,27],[22,28,22,35],[22,0,22,12],[22,13,22,14],[25,15,25,19],[25,20,25,21],[25,22,25,27],[25,28,25,35],[25,0,25,12],[25,13,25,14],[24,15,24,19],[24,20,24,21],[24,22,24,27],[24,28,24,35],[24,0,24,12],[24,13,24,14],[26,15,26,19],[26,20,26,21],[26,22,26,27],[26,28,26,35],[26,0,26,12],[26,13,26,14],[28,28,28,35],[29,15,29,27],[29,28,29,35],[27,15,27,27],[27,28,27,35],[28,15,28,27],[16,8,16,35],[18,0,18,35],[19,15,19,19],[19,20,19,21],[19,22,19,27],[19,28,19,35],[19,0,19,12],[19,13,19,14]]}
[null,"請　　求　　書"]
[]
[null,null,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":"納品書【記入要領】!AD28","v":"2023-05-26"},null,null,null,null,null,null,null,null,null,null,null,"入力の説明"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"：必須入力"]
["松戸市立病院",null,null,null,null,null,null,null,null,null,"様",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"：任意入力"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":"納品書!Z27","v":"273-0123　"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"住所",null,{"$f":"納品書!Z28","v":"千葉県鎌ケ谷市東中沢2-4-6"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"事業者名",null,null,null,{"$f":"納品書!AA29","v":"中沢商事"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"登録番号",null,null,null,null,"T1234567890123"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"代表者職氏名",null,null,null,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":"納品書!AD30","v":"冨澤　徹"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"℡：",null,{"$f":"納品書!Y31","v":"047-438-3456"},null,null,null,null,"FAX:",null,{"$f":"納品書!AF31","v":"047-438-3456"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"　",{"$f":"納品書!Z32","v":"担当:冨澤　徹 (携帯:090-6543-0110)"}]
[null,null,null,null,null,null,null,null,null,"令和",null,5,null,"年",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,{"$f":"IFERROR(VLOOKUP(A21,品名一覧!$B$2:$D$22,3,FALSE),\"\")","v":0.08},null,160,null,null,null,null,"枚",null,60,null,null,null,null,null,{"$f":"IF(W21<>\"\",W21*P21,\"\")","v":9600}]
["袋(中）",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A22,品名一覧!$B$2:$D$22,3,FALSE),\"\")","v":0.1},null,5,null,null,null,null,"枚",null,3,null,null,null,null,null,{"$f":"IF(W22<>\"\",W22*P22,\"\")","v":15}]
["生揚げ（１／４）",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A23,品名一覧!$B$2:$D$22,3,FALSE),\"\")","v":0.08},null,50,null,null,null,null,"枚",null,55,null,null,null,null,null,2750]
["袋(大）",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A24,品名一覧!$B$2:$D$22,3,FALSE),\"\")","v":0.1},null,170,null,null,null,null,"枚",null,5,null,null,null,null,null,850]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(A25,品名一覧!$B$2:$D$22,3,FALSE),\"\")","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,{"$f":"IFERROR(VLOOKUP(A26,品名一覧!$B$2:$D$22,3,FALSE),\"\")","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,{"$f":"IFERROR(VLOOKUP(A27,品名一覧!$B$2:$D$22,3,FALSE),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"_xlfn.UNIQUE(N21:N27,FALSE,FALSE)","v":0.08},"対象金額",null,null,null,{"$f":"SUMIF(N$21:N$27,A$28,AC$21:AC$27)","v":12350},null,null,null,"税額",null,{"$f":"ROUNDDOWN(F28*A28,0)","v":988},null,null,null,"  合 計 金 額",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC21:AJ27)","v":13215}]
[0.1,"対象金額",null,null,null,{"$f":"SUMIF(N$21:N$27,A$29,AC$21:AC$27)","v":865},null,null,null,"税額",null,{"$f":"ROUNDDOWN(F29*A29,0)","v":86},null,null,null,"  消 費 税 額",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L28:O29)","v":1074}]
["",null,null,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":"AC28+AC29","v":14289}]

{"sheet":"環境(削除不可)","index":4,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["pdfファイルの出力先"]
[null,"シート名","フォルダ(事前作成要)","ご請求金額セルの列","ご請求金額セルの行"]
[null,"納品書","(pdf自動出力不可)"]
[null,"請求書(A4)","C:\\hogehoge\\test",30,29]
[]
["pdfファイルのネーミングルール"]
[null,"yyyymmdd_得意先名_請求金額.pdf"]

{"sheet":"宛先一覧","index":5,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["No","氏名","敬称","会社名","部署名","役職","郵便番号","住所1","住所2","電話番号","FAX番号"]
[]
["0001","スーパー白井","御中",null,null,null,"270-1434","千葉県白井市","大山口3-507","047-439-5811"]
["0002","船橋ドラッグストア","御中",null,null,null,"273-0866","千葉県船橋市","夏見台2-12-1","047-438-2000"]
["0003","柏食品","御中",null,null,null,"277-0941","千葉県柏市","高柳5-6-7","047-438-2001"]
["0004","松戸市立病院","御中",null,null,null,"270-2223","千葉県松戸市","秋山1-2-4","047-438-2002","047-443-0104"]
["0005","山田　信一","様",null,null,null,"272-0001","千葉県船橋市","丸山2-4-1","047-443-0005","047-443-0105"]
["0006","山田　信二","様",null,null,null,"272-0002","千葉県船橋市","丸山2-4-2","047-443-0006","047-443-0106"]
["0007","山田　信三","様",null,null,null,"272-0003","千葉県船橋市","丸山2-4-3","047-443-0007","047-443-0107"]
["0008","関口　一郎","様","株式会社　BB1","総務課","課長","271-0101","鎌ケ谷市鎌ケ谷1-2-3","セカイビル　301","047-443-0008","047-443-0108"]
["0009","関口　二郎","様","株式会社　BB2","総務課","課長","271-0102","鎌ケ谷市鎌ケ谷1-2-4","セカイビル　302","047-443-0009","047-443-0109"]
["0010","関口　三郎","様","株式会社　BB3","総務課","課長","271-0103","鎌ケ谷市鎌ケ谷1-2-5","セカイビル　303","047-443-0010","047-443-0110"]
["0011"]
["0012"]
["0013"]
["0014"]
["0015"]
["0016"]
["0017"]
["0018"]
["0019"]
["0020"]

{"sheet":"品名一覧","index":6,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["No","品名","品番","税率"]
[0]
[1,"木綿　豆腐１",{"$f":"A3","v":1},0.08]
[2,"木綿　豆腐　押し　　　　％",2,0.08]
[3,"木綿　豆腐　絞り　　　　％",3,0.08]
[4,"油揚げ",4,0.08]
[5,"油揚げ(刻み）",5,0.08]
[6,"生揚げ",6,0.08]
[7,"生揚げ（１／４）",7,0.08]
[8,"生揚げ（１／３）",8,0.08]
[9,"がんもどき",9,0.08]
[10,"油揚げ　　　　　　　　　4kg",10,0.08]
[11,"木綿　豆腐１１",11,0.08]
[12,"木綿　豆腐１２",12,0.08]
[13,"木綿　豆腐１３",13,0.08]
[14,"木綿　豆腐１４",14,0.08]
[15,"木綿　豆腐１５",15,0.08]
[16,"木綿　豆腐１６",16,0.08]
[17,"木綿　豆腐１７",17,0.08]
[18,"袋(大）",18,0.1]
[19,"袋(中）",19,0.1]
[20,"袋(小）",20,0.1]

{"sheet":"単位一覧","index":7,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["No","単位"]
[1]
[2,"Kg"]
[3,"g"]
[4,"個"]
[5,"箱"]
[6,"l"]
[7,"ml"]
[8,"枚"]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]

{"sheet":"備考一覧","index":8,"n_rows":22,"n_cols":2,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["No","備考"]
[0]
[1,"製造：   /       ："]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]