{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["レジ","記録データ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["売上日",{"$f":"TODAY()","v":"2016-07-01"},null,null,null,null,null,null,"商品一覧表"]
[null,null,null,null,null,null,null,null,"商品番号","商品名","生産者","単価"]
["売上日","商品名","生産者","単価","商品番号","数量","合計",null,"T001","トマト","野田",110]
[{"$f":"IF(E4=\"\",\"\",日付)","v":""},{"$f":"IF(E4=\"\",\"\",VLOOKUP(E4,商品一覧,2,0))","v":""},{"$f":"IF(E4=\"\",\"\",VLOOKUP(E4,商品一覧,3,0))","v":""},{"$f":"IF(E4=\"\",0,VLOOKUP(E4,商品一覧,4,0))","v":0},null,null,{"$f":"D4*F4","v":0},null,"T002","トマト","桑田",120]
["","","",0,null,null,0,null,"K001","きゅうり","若生",100]
["","","",0,null,null,0,null,"K002","きゅうり","小野",200]
["","","",0,null,null,0,null,"S001","すいか","桑田",1500]
["","","",0,null,null,0,null,"S002","すいか","佐々木",1200]
["","","",0,null,null,0,null,"S003","すいか","若生",1000]
["","","",0,null,null,0,null,"S004","すいか","小野",2000]
["","","",0,null,null,0,null,"TM001","とうもろこし","桑田",100]
["","","",0,null,null,0,null,"N001","なす","佐々木",100]
[null,null,null,null,null,"総計",{"$f":"SUM(G4:G12)","v":0},null,"N002","なす","小野",200]
[null,null,null,null,null,"預り金",null,null,"P001","ピーマン","桑田",200]
[null,null,null,null,null,"お釣り",{"$f":"G14-G13","v":0},null,"P002","ピーマン","佐々木",200]
[null,null,null,null,null,null,null,null,"M001","メロン","佐々木",2000]
[null,null,null,null,null,null,null,null,"M002","メロン","高木",3000]

{"sheet":"記録データ","index":1,"n_rows":46,"n_cols":7,"rows_kept":46,"cut":false,"hidden":false,"merged":[]}
["売上日","商品名","生産者","単価","商品番号","数量","合計"]
["2015-06-24","メロン","佐々木",2000,"M001",1,2000]
["2015-06-24","すいか","佐々木",1200,"S002",1,1200]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["2015-06-24","トマト","野田",110,"T001",10,1100]
["2015-06-24","メロン","高木",3000,"M002",1,3000]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["2015-06-24","トマト","野田",110,"T001",13,1430]
["2015-06-24","きゅうり","若生",100,"K001",3,300]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["2015-06-24","きゅうり","若生",100,"K001",2,200]
["2015-06-24","すいか","桑田",1500,"S001",1,1500]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["2015-06-24","トマト","野田",110,"T001",8,880]
["2015-06-24","とうもろこし","桑田",100,"TM001",4,400]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]
["","","",0,null,null,0]