{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["売上データ","売上レポート","在庫"],"not_rendered":{"defined_names":10,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"売上データ","index":0,"n_rows":13,"n_cols":11,"rows_kept":13}
[]
[null,"キャッシュ レジスターの日次売上"]
[]
[]
[]
[{"$nulls":10}," "]
[{"$nulls":10}," "]
[null,"日付","時刻","取引番号","SKU/製品番号","説明","売上金額","税率","消費税","合計"]
[null,"2012-02-01","10:30:00",1001,90001,{"$f":"IFERROR(IF(ISNA(VLOOKUP(売上データの表[[#This Row],[SKU/製品番号]],在庫表[],2,0)),\"\",VLOOKUP(売上データの表[[#This Row],[SKU/製品番号]],在庫表[],2,0)),\"No description found\")","v":"毛布"},{"v":7495,"d":"¥7,495"},{"v":0.05,"d":"5.00%"},{"$f":"売上データの表[[#This Row],[売上金額]]*売上データの表[[#This Row],[税率]]","v":{"v":374.75,"d":"¥375"}},{"$f":"売上データの表[[#This Row],[売上金額]]+売上データの表[[#This Row],[消費税]]","v":{"v":7869.75,"d":"¥7,870"}}]
[null,"2012-02-01","10:33:00",1002,90023,{"$f":"IFERROR(IF(ISNA(VLOOKUP(売上データの表[[#This Row],[SKU/製品番号]],在庫表[],2,0)),\"\",VLOOKUP(売上データの表[[#This Row],[SKU/製品番号]],在庫表[],2,0)),\"No description found\")","v":"テーブル クロス、6' 丸"},{"v":3499,"d":"¥3,499"},{"v":0.05,"d":"5.00%"},{"$f":"売上データの表[[#This Row],[売上金額]]*売上データの表[[#This Row],[税率]]","v":{"v":174.95000000000002,"d":"¥175"}},{"$f":"売上データの表[[#This Row],[売上金額]]+売上データの表[[#This Row],[消費税]]","v":{"v":3673.95,"d":"¥3,674"}}]
[null,"2012-02-01","10:45:00",1003,90005,{"$f":"IFERROR(IF(ISNA(VLOOKUP(売上データの表[[#This Row],[SKU/製品番号]],在庫表[],2,0)),\"\",VLOOKUP(売上データの表[[#This Row],[SKU/製品番号]],在庫表[],2,0)),\"No description found\")","v":"丸型プレート"},{"v":5595,"d":"¥5,595"},{"v":0.05,"d":"5.00%"},{"$f":"売上データの表[[#This Row],[売上金額]]*売上データの表[[#This Row],[税率]]","v":{"v":279.75,"d":"¥280"}},{"$f":"売上データの表[[#This Row],[売上金額]]+売上データの表[[#This Row],[消費税]]","v":{"v":5874.75,"d":"¥5,875"}}]
[null,"2012-02-01","10:55:00",1004,90004,{"$f":"IFERROR(IF(ISNA(VLOOKUP(売上データの表[[#This Row],[SKU/製品番号]],在庫表[],2,0)),\"\",VLOOKUP(売上データの表[[#This Row],[SKU/製品番号]],在庫表[],2,0)),\"No description found\")","v":"角型プレート"},{"v":295,"d":"¥295"},{"v":0.05,"d":"5.00%"},{"$f":"売上データの表[[#This Row],[売上金額]]*売上データの表[[#This Row],[税率]]","v":{"v":14.75,"d":"¥15"}},{"$f":"売上データの表[[#This Row],[売上金額]]+売上データの表[[#This Row],[消費税]]","v":{"v":309.75,"d":"¥310"}}]
[null,"2012-02-01","11:45:00",1005,90002,{"$f":"IFERROR(IF(ISNA(VLOOKUP(売上データの表[[#This Row],[SKU/製品番号]],在庫表[],2,0)),\"\",VLOOKUP(売上データの表[[#This Row],[SKU/製品番号]],在庫表[],2,0)),\"No description found\")","v":"枕"},{"v":1498,"d":"¥1,498"},{"v":0.05,"d":"5.00%"},{"$f":"売上データの表[[#This Row],[売上金額]]*売上データの表[[#This Row],[税率]]","v":{"v":74.9,"d":"¥75"}},{"$f":"売上データの表[[#This Row],[売上金額]]+売上データの表[[#This Row],[消費税]]","v":{"v":1572.9,"d":"¥1,573"}}]

{"sheet":"売上レポート","index":1,"n_rows":14,"n_cols":7,"rows_kept":14}
[]
[null,"キャッシュ レジスターの日次売上"]
[]
[]
[]
[]
[]
[null,"SKU/製品番号","説明","日付","売上金額 ","消費税 ","合計 "]
[null,90001,"毛布","2012-02-01",{"v":7495,"d":"¥7,495"},{"v":374.75,"d":"¥375"},{"v":7869.75,"d":"¥7,870"}]
[null,90002,"枕","2012-02-01",{"v":1498,"d":"¥1,498"},{"v":74.9,"d":"¥75"},{"v":1572.9,"d":"¥1,573"}]
[null,90004,"角型プレート","2012-02-01",{"v":295,"d":"¥295"},{"v":14.75,"d":"¥15"},{"v":309.75,"d":"¥310"}]
[null,90005,"丸型プレート","2012-02-01",{"v":5595,"d":"¥5,595"},{"v":279.75,"d":"¥280"},{"v":5874.75,"d":"¥5,875"}]
[null,90023,"テーブル クロス、6' 丸","2012-02-01",{"v":3499,"d":"¥3,499"},{"v":174.95000000000002,"d":"¥175"},{"v":3673.95,"d":"¥3,674"}]
[null,"総計",null,null,{"v":18382,"d":"¥18,382"},{"v":919.1,"d":"¥919"},{"v":19301.1,"d":"¥19,301"}]

{"sheet":"在庫","index":2,"n_rows":31,"n_cols":3,"rows_kept":31}
[]
[null,"キャッシュ レジスターの日次売上"]
[]
[]
[]
[]
[]
[null,"SKU/製品番号","説明"]
[null,90001,"毛布"]
[null,90002,"枕"]
[null,90003,"シーツ"]
[null,90004,"角型プレート"]
[null,90005,"丸型プレート"]
[null,90006,"ボウル、大"]
[null,90007,"ボウル、小"]
[null,90008,"丸型プレート、小"]
[null,90009,"フォーク、小"]
[null,90010,"フォーク、大"]
[null,90011,"スプーン、小"]
[null,90012,"スプーン、大"]
[null,90013,"バター ナイフ、小"]
[null,90014,"バター ナイフ、大"]
[null,90015,"テーブル クロス、10x5"]
[null,90016,"テーブル クロス、8x5"]
[null,90017,"テーブル クロス、8x8"]
[null,90018,"テーブル クロス、6x6"]
[null,90019,"テーブル クロス、6x4"]
[null,90020,"テーブル クロス、4x4"]
[null,90021,"テーブル クロス、10' 丸"]
[null,90022,"テーブル クロス、8' 丸"]
[null,90023,"テーブル クロス、6' 丸"]