{"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日 10:38"]
[null,"件数",5]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"手順"]
[null,"１．開始日＆終了日を入力する"]
[null,"２．活用する売上データ読込（読込日・件数が書き変わるまで暫くお待ちください）"]
[null,"３．管理帳票の帳票ボタンをクリック（MENUへ戻るときは、下部タブを選んで下さい）"]
[null,"４．終了(上書き保存)"]

{"sheet":"売上明細","index":1,"n_rows":6,"n_cols":24,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["ﾚｼｰﾄNo","行","売上日時","商分類","コード","商品名","個数","売税込単価","売税込額","預消費税","仕税込単価","売本体単価","仕粗利単価","お預り額","担当者","売上分類","領F","宛先","但し書き","DEL","売上年月","粗利額","売本体額","仕税込額"]
[1,1,"2014-05-15T10:38:00","喫茶",111,"ベトナムコーヒー",1,400,400,29,300,371,278,400,"東京　一郎","通常",0]
[2,1,"2014-05-15T13:42:00","喫茶",122,"アイスカフェラテ",1,340,340,25,110,315,102,null,"東京　一郎","通常",0]
[3,1,"2014-05-15T13:42:00","喫茶",112,"グアバ・マンゴー",1,420,420,null,140,389,130,null,"東京　一郎","通常",0]
[3,2,"2014-05-15T13:42:00","喫茶",122,"アイスカフェラテ",1,340,340,null,110,315,102,null,"東京　一郎","通常",0]
[3,3,"2014-05-15T13:42:00","喫茶",113,"アセロ・グアバ",1,420,420,87,120,389,112,1200,"東京　一郎","通常",0]

{"sheet":"売上元帳","index":2,"n_rows":10,"n_cols":24,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["売上年月","売上日時","ﾚｼｰﾄNo","行","商分類","コード","商品名","個数","売税込単価","売税込額","預消費税","粗利額","売本体額","売本体単価","仕粗利単価","仕税込単価","仕税込額","お預り額","担当者","売上分類","領F","宛先","但し書き","DEL"]
["2012-11-01","2012-11-29T10:37:00",2,1,"喫茶",111,"ベトナムコーヒー",1,400,400,null,95,381,381,286,300,300,null,"東京　一郎","通常",0]
["2012-11-01","2012-11-29T10:37:00",2,2,"喫茶",112,"グアバ・マンゴー",1,420,420,null,266,400,400,134,140,140,null,"東京　一郎","通常",0]
["2012-11-01","2012-11-29T10:37:00",2,3,"喫茶",123,"１００％オレンジジュース",1,400,400,null,285,381,381,96,100,100,null,"東京　一郎","通常",0]
["2012-11-01","2012-11-29T10:37:00",2,4,"喫茶",122,"アイスカフェラテ",1,340,340,null,219,324,324,105,110,110,null,"東京　一郎","通常",0]
["2012-11-01","2012-11-29T10:37:00",2,5,"喫茶",121,"アイスコーヒ",1,380,380,92,247,362,362,115,120,120,2000,"東京　一郎","通常",0]
[null,null,"2 集計",null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J2:J6)","v":1940},{"$f":"SUBTOTAL(9,K2:K6)","v":92},{"$f":"SUBTOTAL(9,L2:L6)","v":1112},{"$f":"SUBTOTAL(9,M2:M6)","v":1848}]
[null,"29日 集計",null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J2:J6)","v":1940},{"$f":"SUBTOTAL(9,K2:K6)","v":92},{"$f":"SUBTOTAL(9,L2:L6)","v":1112},{"$f":"SUBTOTAL(9,M2:M6)","v":1848}]
["2012年11月 集計",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J2:J6)","v":1940},{"$f":"SUBTOTAL(9,K2:K6)","v":92},{"$f":"SUBTOTAL(9,L2:L6)","v":1112},{"$f":"SUBTOTAL(9,M2:M6)","v":1848}]
["総計",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J2:J6)","v":1940},{"$f":"SUBTOTAL(9,K2:K6)","v":92},{"$f":"SUBTOTAL(9,L2:L6)","v":1112},{"$f":"SUBTOTAL(9,M2:M6)","v":1848}]

{"sheet":"担当別月別商品売上一覧","index":3,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"担当者","(すべて)"]
[]
[null,"合計 / 売本体額","商品名"]
[null,"売上年月","１００％オレンジジュース","アイスカフェラテ","アイスコーヒ","グアバ・マンゴー","ベトナムコーヒー","総計"]
[null,"2012年11月",381,324,362,400,381,1848]
[null,"総計",381,324,362,400,381,1848]

{"sheet":"担当別月別商品粗利一覧","index":4,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"担当者","(すべて)"]
[]
[null,"合計 / 粗利額","商品名"]
[null,"売上年月","１００％オレンジジュース","アイスカフェラテ","アイスコーヒ","グアバ・マンゴー","ベトナムコーヒー","総計"]
[null,"2012年11月",285,219,247,266,95,1112]
[null,"総計",285,219,247,266,95,1112]

{"sheet":"月別担当別商品売上一覧","index":5,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,null,null,"売上年月"]
[null,"担当者","商品名","データ","2012年11月","総計"]
[null,"東京　一郎","１００％オレンジジュース","合計 / 売本体額",381,381]
[null,null,null,"合計 / 粗利額",285,285]
[null,null,"アイスカフェラテ","合計 / 売本体額",324,324]
[null,null,null,"合計 / 粗利額",219,219]
[null,null,"アイスコーヒ","合計 / 売本体額",362,362]
[null,null,null,"合計 / 粗利額",247,247]
[null,null,"グアバ・マンゴー","合計 / 売本体額",400,400]
[null,null,null,"合計 / 粗利額",266,266]
[null,null,"ベトナムコーヒー","合計 / 売本体額",381,381]
[null,null,null,"合計 / 粗利額",95,95]
[null,"東京　一郎 合計 / 売本体額",null,null,1848,1848]
[null,"東京　一郎 合計 / 粗利額",null,null,1112,1112]
[null,"全体の 合計 / 売本体額",null,null,1848,1848]
[null,"全体の 合計 / 粗利額",null,null,1112,1112]

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