{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["売掛金一覧","得意先一覧","使い方"],"not_rendered":{"defined_names":3,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"売掛金一覧","index":0,"n_rows":27,"n_cols":11,"rows_kept":27,"merged":[[0,0,0,10],[1,8,1,9]]}
["得意先別売掛金一覧表"]
[{"$nulls":8},"2020-03-31",null,"現在"]
[{"$nulls":9},"消費税率設定",{"v":0.05,"d":"5%"}]
["コード","得意先","繰越残高","入金高","税抜売上高","消費税率","消費税高","税込売上高","差引売掛金残高","手形残高","売上債務合計"]
[1,{"$f":"IF(A5=\"\",\"\",IF(ISNA(VLOOKUP(A5,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A5,得意先一覧!$B$5:$C$54,2,FALSE)))","v":"安芸商店株式会社"},{"v":1240000,"d":"1,240,000 "},{"v":500000,"d":"500,000 "},{"v":1200000,"d":"1,200,000 "},{"$f":"IF(E5=\"\",\"\",$K$3)","v":{"v":0.05,"d":"5%"}},{"$f":"IF(E5=\"\",\"\",ROUNDDOWN(E5*F5,0))","v":{"v":60000,"d":"60,000 "}},{"$f":"IF(E5=\"\",\"\",E5+G5)","v":{"v":1260000,"d":"1,260,000 "}},{"$f":"IF(AND(C5=\"\",D5=\"\",E5=\"\"),\"\",IF(E5=\"\",C5-D5,C5+H5-D5))","v":{"v":2000000,"d":"2,000,000 "}},{"v":0,"d":"0 "},{"$f":"IF(AND(J5=\"\",I5=\"\"),\"\",IF(AND(I5=\"\",J5<>\"\"),J5,I5+J5))","v":{"v":2000000,"d":"2,000,000 "}}]
[2,{"$f":"IF(A6=\"\",\"\",IF(ISNA(VLOOKUP(A6,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A6,得意先一覧!$B$5:$C$54,2,FALSE)))","v":"恵比寿株式会社"},{"v":0,"d":"0 "},{"v":350000,"d":"350,000 "},{"v":120000,"d":"120,000 "},{"$f":"IF(E6=\"\",\"\",$K$3)","v":{"v":0.05,"d":"5%"}},{"$f":"IF(E6=\"\",\"\",ROUNDDOWN(E6*F6,0))","v":{"v":6000,"d":"6,000 "}},{"$f":"IF(E6=\"\",\"\",E6+G6)","v":{"v":126000,"d":"126,000 "}},{"$f":"IF(AND(C6=\"\",D6=\"\",E6=\"\"),\"\",IF(E6=\"\",C6-D6,C6+H6-D6))","v":{"v":-224000,"d":"(224,000)"}},{"v":0,"d":"0 "},{"$f":"IF(AND(J6=\"\",I6=\"\"),\"\",IF(AND(I6=\"\",J6<>\"\"),J6,I6+J6))","v":{"v":-224000,"d":"(224,000)"}}]
[3,{"$f":"IF(A7=\"\",\"\",IF(ISNA(VLOOKUP(A7,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A7,得意先一覧!$B$5:$C$54,2,FALSE)))","v":"大宮ユニオン"},{"v":540000,"d":"540,000 "},{"v":0,"d":"0 "},{"v":250000,"d":"250,000 "},{"v":0.05,"d":"5%"},{"v":12500,"d":"12,500 "},{"$f":"IF(E7=\"\",\"\",E7+G7)","v":{"v":262500,"d":"262,500 "}},{"$f":"IF(AND(C7=\"\",D7=\"\",E7=\"\"),\"\",IF(E7=\"\",C7-D7,C7+H7-D7))","v":{"v":802500,"d":"802,500 "}},{"v":320000,"d":"320,000 "},{"$f":"IF(AND(J7=\"\",I7=\"\"),\"\",IF(AND(I7=\"\",J7<>\"\"),J7,I7+J7))","v":{"v":1122500,"d":"1,122,500 "}}]
[null,{"$f":"IF(A8=\"\",\"\",IF(ISNA(VLOOKUP(A8,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A8,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","",{"$f":"IF(E8=\"\",\"\",E8+G8)","v":""},{"$f":"IF(AND(C8=\"\",D8=\"\",E8=\"\"),\"\",IF(E8=\"\",C8-D8,C8+H8-D8))","v":""},null,{"$f":"IF(AND(J8=\"\",I8=\"\"),\"\",IF(AND(I8=\"\",J8<>\"\"),J8,I8+J8))","v":""}]
[null,{"$f":"IF(A9=\"\",\"\",IF(ISNA(VLOOKUP(A9,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A9,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,{"$f":"IF(AND(J9=\"\",I9=\"\"),\"\",IF(AND(I9=\"\",J9<>\"\"),J9,I9+J9))","v":""}]
[null,{"$f":"IF(A10=\"\",\"\",IF(ISNA(VLOOKUP(A10,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A10,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A11=\"\",\"\",IF(ISNA(VLOOKUP(A11,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A11,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A12=\"\",\"\",IF(ISNA(VLOOKUP(A12,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A12,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A13=\"\",\"\",IF(ISNA(VLOOKUP(A13,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A13,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A14=\"\",\"\",IF(ISNA(VLOOKUP(A14,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A14,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A15=\"\",\"\",IF(ISNA(VLOOKUP(A15,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A15,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A16=\"\",\"\",IF(ISNA(VLOOKUP(A16,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A16,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A17=\"\",\"\",IF(ISNA(VLOOKUP(A17,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A17,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A18=\"\",\"\",IF(ISNA(VLOOKUP(A18,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A18,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A19=\"\",\"\",IF(ISNA(VLOOKUP(A19,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A19,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A20=\"\",\"\",IF(ISNA(VLOOKUP(A20,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A20,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A21=\"\",\"\",IF(ISNA(VLOOKUP(A21,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A21,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A22=\"\",\"\",IF(ISNA(VLOOKUP(A22,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A22,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A23=\"\",\"\",IF(ISNA(VLOOKUP(A23,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A23,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A24=\"\",\"\",IF(ISNA(VLOOKUP(A24,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A24,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A25=\"\",\"\",IF(ISNA(VLOOKUP(A25,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A25,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A26=\"\",\"\",IF(ISNA(VLOOKUP(A26,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A26,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A27=\"\",\"\",IF(ISNA(VLOOKUP(A27,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A27,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]

{"sheet":"得意先一覧","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[3,1,3,2]]}
[null,"※コードNOと得意先名をセルB5からセルC54に設定したコードマスターに入力してください。"]
[null,"なお、コードNOは重複しないように設定してください。"]
[]
[null,"コードマスター"]
[null,"コードNO","得意先名"]
[null,1,"安芸商店株式会社"]
[null,2,"恵比寿株式会社"]
[null,3,"大宮ユニオン"]

{"sheet":"使い方","index":2,"n_rows":27,"n_cols":11,"rows_kept":27,"merged":[[0,0,0,10],[1,8,1,9]]}
["得意先別売掛金一覧表"]
[{"$nulls":8},"2020-03-31",null,"現在"]
[{"$nulls":9},"消費税率設定",{"v":0.05,"d":"5%"}]
["コード","得意先","繰越残高","入金高","税抜売上高","消費税率","消費税高","税込売上高","差引売掛金残高","手形残高","売上債務合計"]
[1,{"$f":"IF(A5=\"\",\"\",IF(ISNA(VLOOKUP(A5,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A5,得意先一覧!$B$5:$C$54,2,FALSE)))","v":"安芸商店株式会社"},{"v":1240000,"d":"1,240,000 "},{"v":500000,"d":"500,000 "},{"v":1200000,"d":"1,200,000 "},{"$f":"IF(E5=\"\",\"\",$K$3)","v":{"v":0.05,"d":"5%"}},{"$f":"IF(E5=\"\",\"\",ROUNDDOWN(E5*F5,0))","v":{"v":60000,"d":"60,000 "}},{"$f":"IF(E5=\"\",\"\",E5+G5)","v":{"v":1260000,"d":"1,260,000 "}},{"$f":"IF(AND(C5=\"\",D5=\"\",E5=\"\"),\"\",IF(E5=\"\",C5-D5,C5+H5-D5))","v":{"v":2000000,"d":"2,000,000 "}},{"v":0,"d":"0 "},{"$f":"IF(AND(J5=\"\",I5=\"\"),\"\",IF(AND(I5=\"\",J5<>\"\"),J5,I5+J5))","v":{"v":2000000,"d":"2,000,000 "}}]
[2,{"$f":"IF(A6=\"\",\"\",IF(ISNA(VLOOKUP(A6,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A6,得意先一覧!$B$5:$C$54,2,FALSE)))","v":"恵比寿株式会社"},{"v":0,"d":"0 "},{"v":350000,"d":"350,000 "},{"v":120000,"d":"120,000 "},{"$f":"IF(E6=\"\",\"\",$K$3)","v":{"v":0.05,"d":"5%"}},{"$f":"IF(E6=\"\",\"\",ROUNDDOWN(E6*F6,0))","v":{"v":6000,"d":"6,000 "}},{"$f":"IF(E6=\"\",\"\",E6+G6)","v":{"v":126000,"d":"126,000 "}},{"$f":"IF(AND(C6=\"\",D6=\"\",E6=\"\"),\"\",IF(E6=\"\",C6-D6,C6+H6-D6))","v":{"v":-224000,"d":"(224,000)"}},{"v":0,"d":"0 "},{"v":-224000,"d":"(224,000)"}]
[3,{"$f":"IF(A7=\"\",\"\",IF(ISNA(VLOOKUP(A7,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A7,得意先一覧!$B$5:$C$54,2,FALSE)))","v":"大宮ユニオン"},{"v":540000,"d":"540,000 "},{"v":0,"d":"0 "},{"v":250000,"d":"250,000 "},{"$f":"IF(E7=\"\",\"\",$K$3)","v":{"v":0.05,"d":"5%"}},{"v":12500,"d":"12,500 "},{"$f":"IF(E7=\"\",\"\",E7+G7)","v":{"v":262500,"d":"262,500 "}},{"v":802500,"d":"802,500 "},{"v":320000,"d":"320,000 "},{"v":1122500,"d":"1,122,500 "}]
[4,{"$f":"IF(A8=\"\",\"\",IF(ISNA(VLOOKUP(A8,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A8,得意先一覧!$B$5:$C$54,2,FALSE)))","v":"未登録"},{"$nulls":3},{"$f":"IF(E8=\"\",\"\",$K$3)","v":""},"",{"$f":"IF(E8=\"\",\"\",E8+G8)","v":""},"",null,""]
[null,{"$f":"IF(A9=\"\",\"\",IF(ISNA(VLOOKUP(A9,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A9,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A10=\"\",\"\",IF(ISNA(VLOOKUP(A10,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A10,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A11=\"\",\"\",IF(ISNA(VLOOKUP(A11,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A11,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A12=\"\",\"\",IF(ISNA(VLOOKUP(A12,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A12,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A13=\"\",\"\",IF(ISNA(VLOOKUP(A13,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A13,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A14=\"\",\"\",IF(ISNA(VLOOKUP(A14,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A14,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A15=\"\",\"\",IF(ISNA(VLOOKUP(A15,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A15,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A16=\"\",\"\",IF(ISNA(VLOOKUP(A16,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A16,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A17=\"\",\"\",IF(ISNA(VLOOKUP(A17,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A17,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A18=\"\",\"\",IF(ISNA(VLOOKUP(A18,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A18,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A19=\"\",\"\",IF(ISNA(VLOOKUP(A19,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A19,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A20=\"\",\"\",IF(ISNA(VLOOKUP(A20,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A20,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A21=\"\",\"\",IF(ISNA(VLOOKUP(A21,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A21,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A22=\"\",\"\",IF(ISNA(VLOOKUP(A22,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A22,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A23=\"\",\"\",IF(ISNA(VLOOKUP(A23,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A23,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A24=\"\",\"\",IF(ISNA(VLOOKUP(A24,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A24,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A25=\"\",\"\",IF(ISNA(VLOOKUP(A25,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A25,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A26=\"\",\"\",IF(ISNA(VLOOKUP(A26,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A26,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]
[null,{"$f":"IF(A27=\"\",\"\",IF(ISNA(VLOOKUP(A27,得意先一覧!$B$5:$C$54,2,FALSE)),\"未登録\",VLOOKUP(A27,得意先一覧!$B$5:$C$54,2,FALSE)))","v":""},{"$nulls":3},"","","","",null,""]