{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["MENU","売上明細","売上元帳","月別担当別商品売上一覧","担当別月別商品売上一覧","担当別月別商品粗利一覧","月別担当売上高"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":4},"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":"MENU","index":0,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"STEP1(読み込む売上日の範囲)"]
[null,"開始日","2012-08-01"]
[]
[null,"終了日","2012/11/31",null,null,"管理帳票"]
[]
[]
[]
[]
[]
[]
[null,"読込日","2012年11月29日 13:26"]
[null,"件数",4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"手順"]
[null,"１．開始日＆終了日を入力する"]
[null,"２．活用する売上データ読込（読込日・件数が書き変わるまで暫くお待ちください）"]
[null,"３．管理帳票の帳票ボタンをクリック（MENUへ戻るときは、下部タブを選んで下さい）"]
[null,"４．終了(上書き保存)"]

{"sheet":"売上明細","index":1,"n_rows":5,"n_cols":24,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["ﾚｼｰﾄNo","行","売上日時","商分類","コード","商品名","個数","売税込単価","売税込額","預消費税","仕税込単価","売本体単価","仕粗利単価","お預り額","担当者","売上分類","領F","宛先","但し書き","DEL","売上年月","粗利額","売本体額","仕税込額"]
[1,1,"2012-11-27T15:48:00","オリジナル",112,"ココア　フレーバーL",1,99,99,null,88,95,84,null,"東京　たわあ","通常",0,null,null,null,"2012年11月",11,95,88]
[1,2,"2012-11-27T15:48:00","オリジナル",111,"EXCELPAL#5　PALPOS800",1,4800,4800,233,4000,4572,3810,5000,"東京　たわあ","通常",0,null,null,null,"2012年11月",762,4572,4000]
[2,1,"2012-11-29T13:17:00","オリジナル",112,"ココア　フレーバーL",1,99,99,null,88,95,84,null,"東京　たわあ","通常",0,null,null,null,"2012年11月",11,95,88]
[2,2,"2012-11-29T13:17:00","オリジナル",122,"バニラクリーム　フロッペターノ",1,230,230,15,200,220,191,400,"東京　たわあ","通常",0,null,null,null,"2012年11月",29,220,200]

{"sheet":"売上元帳","index":2,"n_rows":11,"n_cols":24,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["売上年月","売上日時","ﾚｼｰﾄNo","行","商分類","コード","商品名","個数","売税込単価","売税込額","預消費税","粗利額","売本体額","売本体単価","仕粗利単価","仕税込単価","仕税込額","お預り額","担当者","売上分類","領F","宛先","但し書き","DEL"]
["2012-11-01","2012-11-27T15:48:00",1,1,"オリジナル",112,"ココア　フレーバーL",1,99,99,null,11,95,95,84,88,88,null,"東京　たわあ","通常",0]
["2012-11-01","2012-11-27T15:48:00",1,2,"オリジナル",111,"EXCELPAL#5　PALPOS800",1,4800,4800,233,762,4572,4572,3810,4000,4000,5000,"東京　たわあ","通常",0]
[null,null,"1 集計",null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J2:J3)","v":4899},{"$f":"SUBTOTAL(9,K2:K3)","v":233},{"$f":"SUBTOTAL(9,L2:L3)","v":773},{"$f":"SUBTOTAL(9,M2:M3)","v":4667}]
[null,"27日 集計",null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J2:J3)","v":4899},{"$f":"SUBTOTAL(9,K2:K3)","v":233},{"$f":"SUBTOTAL(9,L2:L3)","v":773},{"$f":"SUBTOTAL(9,M2:M3)","v":4667}]
["2012-11-01","2012-11-29T13:17:00",2,1,"オリジナル",112,"ココア　フレーバーL",1,99,99,null,11,95,95,84,88,88,null,"東京　たわあ","通常",0]
["2012-11-01","2012-11-29T13:17:00",2,2,"オリジナル",122,"バニラクリーム　フロッペターノ",1,230,230,15,29,220,220,191,200,200,400,"東京　たわあ","通常",0]
[null,null,"2 集計",null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J6:J7)","v":329},{"$f":"SUBTOTAL(9,K6:K7)","v":15},{"$f":"SUBTOTAL(9,L6:L7)","v":40},{"$f":"SUBTOTAL(9,M6:M7)","v":315}]
[null,"29日 集計",null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J6:J7)","v":329},{"$f":"SUBTOTAL(9,K6:K7)","v":15},{"$f":"SUBTOTAL(9,L6:L7)","v":40},{"$f":"SUBTOTAL(9,M6:M7)","v":315}]
["2012年11月 集計",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J2:J7)","v":5228},{"$f":"SUBTOTAL(9,K2:K7)","v":248},{"$f":"SUBTOTAL(9,L2:L7)","v":813},{"$f":"SUBTOTAL(9,M2:M7)","v":4982}]
["総計",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J2:J7)","v":5228},{"$f":"SUBTOTAL(9,K2:K7)","v":248},{"$f":"SUBTOTAL(9,L2:L7)","v":813},{"$f":"SUBTOTAL(9,M2:M7)","v":4982}]

{"sheet":"月別担当別商品売上一覧","index":3,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,"売上年月"]
[null,"担当者","商品名","データ","2012年11月","総計"]
[null,"東京　たわあ","EXCELPAL#5　PALPOS800","合計 / 売本体額",4572,4572]
[null,null,null,"合計 / 粗利額",762,762]
[null,null,"ココア　フレーバーL","合計 / 売本体額",190,190]
[null,null,null,"合計 / 粗利額",22,22]
[null,null,"バニラクリーム　フロッペターノ","合計 / 売本体額",220,220]
[null,null,null,"合計 / 粗利額",29,29]
[null,"東京　たわあ 合計 / 売本体額",null,null,4982,4982]
[null,"東京　たわあ 合計 / 粗利額",null,null,813,813]
[null,"全体の 合計 / 売本体額",null,null,4982,4982]
[null,"全体の 合計 / 粗利額",null,null,813,813]

{"sheet":"担当別月別商品売上一覧","index":4,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"担当者","(すべて)"]
[]
[null,"合計 / 売本体額","商品名"]
[null,"売上年月","EXCELPAL#5　PALPOS800","ココア　フレーバーL","バニラクリーム　フロッペターノ","総計"]
[null,"2012年11月",4572,190,220,4982]
[null,"総計",4572,190,220,4982]

{"sheet":"担当別月別商品粗利一覧","index":5,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"担当者","(すべて)"]
[]
[null,"合計 / 粗利額","商品名"]
[null,"売上年月","EXCELPAL#5　PALPOS800","ココア　フレーバーL","バニラクリーム　フロッペターノ","総計"]
[null,"2012年11月",762,22,29,813]
[null,"総計",762,22,29,813]

{"sheet":"月別担当売上高","index":6,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,"合計 / 売本体額","担当者"]
[null,"売上年月","東京　たわあ","総計"]
[null,"2012年11月",4982,4982]
[null,"総計",4982,4982]