{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["入力シート","伝票"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":52,"n_cols":58,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["例","○",2021,4,1,"株式会社　青森","代表取締役　青森太郎",101,"普通",1234567,100000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,"↓ クリック ↓"]
["№","印刷","年","月","日","氏名１","氏名２","店番号","科目","口座番号","金額","店番",null,null,null,"桁数","口座番号",7,6,5,4,3,2,1,"桁数","金額",11,10,9,8,7,6,5,4,3,2,1,"お預け入れ",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,{"$f":"IF(H3=\"\",\"\",+H3+1000)","v":""},{"$f":"MID($L3,2,1)","v":""},{"$f":"MID($L3,3,1)","v":""},{"$f":"MID($L3,4,1)","v":""},{"$f":"IF(J3=\"\",\"\",LEN(J3))","v":""},{"$f":"IF(J3=\"\",\"\",+J3+10000000)","v":""},{"$f":"IF(P3<$R$2,\"\",MID($Q3,2,1))","v":""},{"$f":"IF(P3<$S$2,\"\",MID($Q3,3,1))","v":""},{"$f":"IF(P3<$T$2,\"\",MID($Q3,4,1))","v":""},{"$f":"IF(P3<$U$2,\"\",MID($Q3,5,1))","v":""},{"$f":"IF(P3<$V$2,\"\",MID($Q3,6,1))","v":""},{"$f":"IF(P3<$W$2,\"\",MID($Q3,7,1))","v":""},{"$f":"MID($Q3,8,1)","v":""},{"$f":"IF(K3=\"\",\"\",LEN(K3)+1)","v":""},{"$f":"IF(K3=\"\",\"\",+K3+10000000000)","v":""},{"$f":"IF($Y3=AA$2,\"￥\",IF($Y3<AA$2,\"\",MID($Z3,AA$1,1)))","v":""},"","","","","","","","","",{"$f":"IF($Y3=AK$2,\"\",IF($Y3<AK$2,\"\",MID($Z3,AK$1,1)))","v":""}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H4=\"\",\"\",+H4+1000)","v":""},"","","",{"$f":"IF(J4=\"\",\"\",LEN(J4))","v":""},{"$f":"IF(J4=\"\",\"\",+J4+10000000)","v":""},{"$f":"IF(P4<$R$2,\"\",MID($Q4,2,1))","v":""},{"$f":"IF(P4<$S$2,\"\",MID($Q4,3,1))","v":""},{"$f":"IF(P4<$T$2,\"\",MID($Q4,4,1))","v":""},{"$f":"IF(P4<$U$2,\"\",MID($Q4,5,1))","v":""},{"$f":"IF(P4<$V$2,\"\",MID($Q4,6,1))","v":""},{"$f":"IF(P4<$W$2,\"\",MID($Q4,7,1))","v":""},"",{"$f":"IF(K4=\"\",\"\",LEN(K4)+1)","v":""},{"$f":"IF(K4=\"\",\"\",+K4+10000000000)","v":""},{"$f":"IF($Y4=AA$2,\"￥\",IF($Y4<AA$2,\"\",MID($Z4,AA$1,1)))","v":""},"","","","","","","","","",{"$f":"IF($Y4=AK$2,\"\",IF($Y4<AK$2,\"\",MID($Z4,AK$1,1)))","v":""}]
[3,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[4,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[5,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[6,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[7,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[8,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[9,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[10,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[11,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[12,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[13,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[14,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[15,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[16,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[17,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[18,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","",{"$f":"IF($Y20=AA$2,\"￥\",IF($Y20<AA$2,\"\",MID($Z20,AA$1,1)))","v":""},"","","","","","","","","",""]
[19,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[20,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[21,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[22,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[23,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[24,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[25,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[26,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[27,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[28,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[29,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[30,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[31,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[32,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[33,null,null,null,null,null,null,null,null,null,null,"",{"$f":"MID($L35,2,1)","v":""},{"$f":"MID($L35,3,1)","v":""},{"$f":"MID($L35,4,1)","v":""},"","","","","","","","",{"$f":"MID($Q35,8,1)","v":""},"","","","","","","","","","","","",""]
[34,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[35,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[36,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[37,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[38,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[39,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[40,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[41,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[42,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[43,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","",{"$f":"IF($Y45=AF$2,\"￥\",IF($Y45<AF$2,\"\",MID($Z45,AF$1,1)))","v":""},"","","","",""]
[44,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[45,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[46,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[47,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[48,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[49,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[50,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","","","","","","","","","","","","","","","","",""]

{"sheet":"伝票","index":1,"n_rows":11,"n_cols":62,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,1],[4,2,5,2],[4,1,5,1],[7,1,8,1],[7,2,8,2],[1,6,3,16],[4,27,5,29],[4,6,6,16]]}
[{"$f":"IF(ISERROR(AB3),\"\",AB3)","v":""},null,{"$f":"IF(ISERROR(AC3),\"\",AC3)","v":""},{"$f":"IF(ISERROR(AD3),\"\",AD3)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37]
[null,null,null,null,null,null,{"$f":"IF(AB5=\"お預け入れ\",IF(ISERROR(AE3),\"\",AE3),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"年","月","日","氏名１","氏名２","店番号","科目","口座番号","金額","1+店番",null,null,null,"桁数","1+口座番号",null,null,null,null,null,null,null,"有効桁数","1+金額",11,10,9,8,7,6,5,4,3,2,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,{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AB1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AB1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AC1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AC1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AD1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AD1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AE1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AE1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AF1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AF1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AG1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AG1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AH1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AH1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AI1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AI1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AJ1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AJ1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AK1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AK1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AL1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AL1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AM1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AM1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AN1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AN1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AO1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AO1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AP1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AP1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AQ1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AQ1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AR1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AR1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AS1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AS1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AT1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AT1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AU1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AU1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AV1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AV1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AW1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AW1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AX1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AX1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AY1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AY1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AZ1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,AZ1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BA1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BA1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BB1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BB1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BC1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BC1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BD1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BD1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BE1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BE1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BF1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BF1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BG1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BG1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BH1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BH1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BI1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BI1,1))","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BJ1,1)=0,\"\",VLOOKUP($AA$3,入力シート!$A$3:$AK$52,BJ1,1))","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"IF(ISERROR(AH3),\"\",IF(AH3=\"普通\",\"■\",\"\"))","v":""},{"$f":"IF(ISERROR(AH3),\"\",IF(AH3=\"貯蓄\",\"■\",\"\"))","v":""},null,null,null,{"$f":"IF(AB5=\"お預け入れ\",IF(ISERROR(AF3),\"\",AF3),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"入力シート!AL2","v":"お預け入れ"}]
[]
[]
[null,{"$f":"IF(AB5=\"お預け入れ\",IF(ISERROR(AH3),\"\",IF(AH3=\"当座\",\"■\",\"\")),\"\")","v":""},{"$f":"IF(AB5=\"お引出し（払戻請求書）\",IF(ISERROR(AH3),\"\",IF(AH3=\"当座\",\"■\",\"\")),\"\")","v":""}]
[]
[]
[null,{"$f":"IF(ISERROR(AL3),\"\",AL3)","v":""},{"$f":"IF(ISERROR(AM3),\"\",AM3)","v":""},"",null,null,{"$f":"IF(ISERROR(AQ3),\"\",AQ3)","v":""},{"$f":"IF(ISERROR(AR3),\"\",AR3)","v":""},"","","","","",null,{"$f":"IF(ISERROR(AZ3),\"\",AZ3)","v":""},"","","","","","","","","",""]