{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["1月","商品一覧表","得意先一覧表"],"not_rendered":{"defined_names":9},"read":"whole","date_system":"1900"}

{"sheet":"1月","index":0,"n_rows":33,"n_cols":10,"rows_kept":33,"merged":[[0,0,0,5],[0,6,0,9]]}
["2004 年 1 月度売上台帳",{"$nulls":5},"★色の付いていないセルに入力してください。[得意先コード]、[商品コード]、[数量] を入力すると、自動的に [得意先名]、[商品名] などが入力され、必要な計算が行われます。"]
[]
["伝票番号","注文日","得意先\nコード","得意先名","商品コード","商品名","数量","単価","売上","消費税額"]
[{"v":1,"d":"00001"},"2004-01-10",{"v":1,"d":"00001"},{"$f":"IF(C4=\"\",\"\",VLOOKUP(C4,[0]!得意先一覧,2))","v":"丸山マート"},"000-01",{"$f":"IF(E4=\"\",\"\",VLOOKUP(E4,[0]!商品一覧,2))","v":"あおのりあじさい"},25,{"$f":"IF(E4=\"\",\"\",VLOOKUP(E4,[0]!商品一覧,4))","v":{"v":250,"d":"250 "}},{"$f":"IF(G4=\"\",\"\",G4*H4)","v":{"v":6250,"d":"6,250 "}},{"$f":"IF(G4=\"\",\"\",I4*0.05)","v":{"v":312.5,"d":"313 "}}]
[{"v":2,"d":"00002"},"2004-01-19",{"v":2,"d":"00002"},{"$f":"IF(C5=\"\",\"\",VLOOKUP(C5,[0]!得意先一覧,2))","v":"西野ストアー"},"000-02",{"$f":"IF(E5=\"\",\"\",VLOOKUP(E5,[0]!商品一覧,2))","v":"朝日かまぼこ"},70,{"$f":"IF(E5=\"\",\"\",VLOOKUP(E5,[0]!商品一覧,4))","v":{"v":200,"d":"200 "}},{"v":14000,"d":"14,000 "},{"v":700,"d":"700 "}]
[{"v":3,"d":"00003"},{"$nulls":4},{"$f":"IF(E6=\"\",\"\",VLOOKUP(E6,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E6=\"\",\"\",VLOOKUP(E6,[0]!商品一覧,4))","v":""},"",""]
[{"v":4,"d":"00004"},{"$nulls":4},{"$f":"IF(E7=\"\",\"\",VLOOKUP(E7,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E7=\"\",\"\",VLOOKUP(E7,[0]!商品一覧,4))","v":""},"",""]
[{"v":5,"d":"00005"},{"$nulls":4},{"$f":"IF(E8=\"\",\"\",VLOOKUP(E8,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E8=\"\",\"\",VLOOKUP(E8,[0]!商品一覧,4))","v":""},"",""]
[{"v":6,"d":"00006"},{"$nulls":4},{"$f":"IF(E9=\"\",\"\",VLOOKUP(E9,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E9=\"\",\"\",VLOOKUP(E9,[0]!商品一覧,4))","v":""},"",""]
[{"v":7,"d":"00007"},{"$nulls":4},{"$f":"IF(E10=\"\",\"\",VLOOKUP(E10,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E10=\"\",\"\",VLOOKUP(E10,[0]!商品一覧,4))","v":""},"",""]
[{"v":8,"d":"00008"},null,null,{"$f":"IF(C11=\"\",\"\",VLOOKUP(C11,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E11=\"\",\"\",VLOOKUP(E11,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E11=\"\",\"\",VLOOKUP(E11,[0]!商品一覧,4))","v":""},"",""]
[{"v":9,"d":"00009"},null,null,{"$f":"IF(C12=\"\",\"\",VLOOKUP(C12,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E12=\"\",\"\",VLOOKUP(E12,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E12=\"\",\"\",VLOOKUP(E12,[0]!商品一覧,4))","v":""},"",""]
[{"v":10,"d":"00010"},null,null,{"$f":"IF(C13=\"\",\"\",VLOOKUP(C13,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E13=\"\",\"\",VLOOKUP(E13,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E13=\"\",\"\",VLOOKUP(E13,[0]!商品一覧,4))","v":""},"",""]
[{"v":11,"d":"00011"},null,null,{"$f":"IF(C14=\"\",\"\",VLOOKUP(C14,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E14=\"\",\"\",VLOOKUP(E14,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E14=\"\",\"\",VLOOKUP(E14,[0]!商品一覧,4))","v":""},"",""]
[{"v":12,"d":"00012"},null,null,{"$f":"IF(C15=\"\",\"\",VLOOKUP(C15,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E15=\"\",\"\",VLOOKUP(E15,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E15=\"\",\"\",VLOOKUP(E15,[0]!商品一覧,4))","v":""},"",""]
[{"v":13,"d":"00013"},null,null,{"$f":"IF(C16=\"\",\"\",VLOOKUP(C16,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E16=\"\",\"\",VLOOKUP(E16,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E16=\"\",\"\",VLOOKUP(E16,[0]!商品一覧,4))","v":""},"",""]
[{"v":14,"d":"00014"},null,null,{"$f":"IF(C17=\"\",\"\",VLOOKUP(C17,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E17=\"\",\"\",VLOOKUP(E17,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E17=\"\",\"\",VLOOKUP(E17,[0]!商品一覧,4))","v":""},"",""]
[{"v":15,"d":"00015"},null,null,{"$f":"IF(C18=\"\",\"\",VLOOKUP(C18,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E18=\"\",\"\",VLOOKUP(E18,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E18=\"\",\"\",VLOOKUP(E18,[0]!商品一覧,4))","v":""},"",""]
[{"v":16,"d":"00016"},null,null,{"$f":"IF(C19=\"\",\"\",VLOOKUP(C19,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E19=\"\",\"\",VLOOKUP(E19,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E19=\"\",\"\",VLOOKUP(E19,[0]!商品一覧,4))","v":""},"",""]
[{"v":17,"d":"00017"},null,null,{"$f":"IF(C20=\"\",\"\",VLOOKUP(C20,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E20=\"\",\"\",VLOOKUP(E20,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E20=\"\",\"\",VLOOKUP(E20,[0]!商品一覧,4))","v":""},"",""]
[{"v":18,"d":"00018"},null,null,{"$f":"IF(C21=\"\",\"\",VLOOKUP(C21,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E21=\"\",\"\",VLOOKUP(E21,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E21=\"\",\"\",VLOOKUP(E21,[0]!商品一覧,4))","v":""},"",""]
[{"v":19,"d":"00019"},null,null,{"$f":"IF(C22=\"\",\"\",VLOOKUP(C22,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E22=\"\",\"\",VLOOKUP(E22,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E22=\"\",\"\",VLOOKUP(E22,[0]!商品一覧,4))","v":""},"",""]
[{"v":20,"d":"00020"},null,null,{"$f":"IF(C23=\"\",\"\",VLOOKUP(C23,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E23=\"\",\"\",VLOOKUP(E23,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E23=\"\",\"\",VLOOKUP(E23,[0]!商品一覧,4))","v":""},"",""]
[{"v":21,"d":"00021"},null,null,{"$f":"IF(C24=\"\",\"\",VLOOKUP(C24,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E24=\"\",\"\",VLOOKUP(E24,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E24=\"\",\"\",VLOOKUP(E24,[0]!商品一覧,4))","v":""},"",""]
[{"v":22,"d":"00022"},null,null,{"$f":"IF(C25=\"\",\"\",VLOOKUP(C25,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E25=\"\",\"\",VLOOKUP(E25,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E25=\"\",\"\",VLOOKUP(E25,[0]!商品一覧,4))","v":""},"",""]
[{"v":23,"d":"00023"},null,null,{"$f":"IF(C26=\"\",\"\",VLOOKUP(C26,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E26=\"\",\"\",VLOOKUP(E26,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E26=\"\",\"\",VLOOKUP(E26,[0]!商品一覧,4))","v":""},"",""]
[{"v":24,"d":"00024"},null,null,{"$f":"IF(C27=\"\",\"\",VLOOKUP(C27,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E27=\"\",\"\",VLOOKUP(E27,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E27=\"\",\"\",VLOOKUP(E27,[0]!商品一覧,4))","v":""},"",""]
[{"v":25,"d":"00025"},null,null,{"$f":"IF(C28=\"\",\"\",VLOOKUP(C28,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E28=\"\",\"\",VLOOKUP(E28,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E28=\"\",\"\",VLOOKUP(E28,[0]!商品一覧,4))","v":""},"",""]
[{"v":26,"d":"00026"},null,null,{"$f":"IF(C29=\"\",\"\",VLOOKUP(C29,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E29=\"\",\"\",VLOOKUP(E29,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E29=\"\",\"\",VLOOKUP(E29,[0]!商品一覧,4))","v":""},"",""]
[{"v":27,"d":"00027"},null,null,{"$f":"IF(C30=\"\",\"\",VLOOKUP(C30,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E30=\"\",\"\",VLOOKUP(E30,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E30=\"\",\"\",VLOOKUP(E30,[0]!商品一覧,4))","v":""},"",""]
[{"v":28,"d":"00028"},null,null,{"$f":"IF(C31=\"\",\"\",VLOOKUP(C31,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E31=\"\",\"\",VLOOKUP(E31,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E31=\"\",\"\",VLOOKUP(E31,[0]!商品一覧,4))","v":""},"",""]
[{"v":29,"d":"00029"},null,null,{"$f":"IF(C32=\"\",\"\",VLOOKUP(C32,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E32=\"\",\"\",VLOOKUP(E32,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E32=\"\",\"\",VLOOKUP(E32,[0]!商品一覧,4))","v":""},"",""]
[{"v":30,"d":"00030"},null,null,{"$f":"IF(C33=\"\",\"\",VLOOKUP(C33,[0]!得意先一覧,2))","v":""},null,{"$f":"IF(E33=\"\",\"\",VLOOKUP(E33,[0]!商品一覧,2))","v":""},null,{"$f":"IF(E33=\"\",\"\",VLOOKUP(E33,[0]!商品一覧,4))","v":""},"",""]

{"sheet":"商品一覧表","index":1,"n_rows":3,"n_cols":6,"rows_kept":3}
[null,"商品コード","商品名","基準在庫数","単価","原価"]
[null,"000-01","あおのりあじさい",{"v":500,"d":"500 "},{"v":250,"d":"250 "},{"v":125,"d":"125 "}]
[null,"000-02","朝日かまぼこ",{"v":500,"d":"500 "},{"v":200,"d":"200 "},{"v":100,"d":"100 "}]

{"sheet":"得意先一覧表","index":2,"n_rows":21,"n_cols":5,"rows_kept":21}
[null,"得意先コード","得意先名","担当者","電話番号"]
[null,{"v":1,"d":"00001"},"丸山マート","田中","０xx－xxx－xxxx"]
[null,{"v":2,"d":"00002"},"西野ストアー","三木","０xx－xxx－xxxx"]
[null,{"v":3,"d":"00003"}]
[null,{"v":4,"d":"00004"}]
[null,{"v":5,"d":"00005"}]
[null,{"v":6,"d":"00006"}]
[null,{"v":7,"d":"00007"}]
[null,{"v":8,"d":"00008"}]
[null,{"v":9,"d":"00009"}]
[null,{"v":10,"d":"00010"}]
[null,{"v":11,"d":"00011"}]
[null,{"v":12,"d":"00012"}]
[null,{"v":13,"d":"00013"}]
[null,{"v":14,"d":"00014"}]
[null,{"v":15,"d":"00015"}]
[null,{"v":16,"d":"00016"}]
[null,{"v":17,"d":"00017"}]
[null,{"v":18,"d":"00018"}]
[null,{"v":19,"d":"00019"}]
[null,{"v":20,"d":"00020"}]