{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["売上データ","売上入力","顧客","商品","請求書","Sheet1"],"not_rendered":{"charts":0,"images":7,"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":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,3,2,4]]}
[null,null,null,null,null,null,null,"日付","日付","顧客名"]
[null,null,"年/月","顧客名",null,null,null,">=2016/02/10","<=2016/03/09","ラネックス"]
["入力してください",null,"2016-02-10","ラネックス"]
[]
["ID","伝票NO","日付","顧客ID","顧客名","商品ID","商品名","単価","数量","金額","備考"]
[1,2,"2016-03-02","A001","SK北海道システム","B005","ジェットプリンタ BJC-240JII",56000,2,112000,""]
[2,2,"2016-03-02","A001","SK北海道システム","B005","ジェットプリンタ BJC-240JII",56000,2,112000,""]
[3,2,"2016-03-02","A001","SK北海道システム","A006","ThinkPad600B",430000,1,430000,""]
[4,2,"2016-03-02","A001","SK北海道システム","A006","ThinkPad600B",430000,1,430000,""]
[5,2,"2016-03-02","A001","SK北海道システム","C001","ディスプレイ MT-8615B",54000,1,54000,""]
[11,3,"2016-03-05","A006","ラネックス","C004","ディスプレイ MT-8617BS",135000,1,135000,"部品B"]
[7,3,"2016-03-05","A006","ラネックス","A002","PC-9831Xa14",248000,2,496000,""]
[8,4,"2016-03-10","A005","日本興行通信","A005","ThinkPad500A",378000,2,756000,""]
[9,4,"2016-03-10","A005","日本興行通信","D006","光ディスク MOS-S640PF",98000,3,294000,""]
[10,4,"2016-03-10","A005","日本興行通信","A002","PC-9831Xa14",248000,1,248000,"123456789"]
[11,5,"2016-03-11","A004","ソリマチ技術研究所","B005","ジェットプリンタ BJC-240JII",56000,2,112000,"456789"]
[12,5,"2016-03-11","A004","ソリマチ技術研究所","C003","ディスプレイ MT-8617B",87000,2,174000,""]
[13,4,"2016-03-12","A005","日本興行通信","A001","PC-9831Xa13",158000,1,158000,""]
[14,5,"2016-03-13","A004","ソリマチ技術研究所","A002","PC-9831Xa14",248000,1,248000,""]
[15,6,"2016-03-14","A002","ビーコンシステムエンジニア","B001","レーザープリンタ LBP-150",105000,1,105000,""]
[16,6,"2016-03-14","A002","ビーコンシステムエンジニア","B005","ジェットプリンタ BJC-240JII",56000,1,56000,""]
[17,7,"2016-03-21","A001","SK北海道システム","C001","ディスプレイ MT-8615B",54000,1,54000,""]
[18,7,"2016-03-21","A001","SK北海道システム","C002","ディスプレイ MT-8615BS",73000,1,73000,""]
[24,8,"2016-04-08","A006","ラネックス","C005","ディスプレイ MT-8621B",298000,1,298000,""]
[20,8,"2016-04-08","A006","ラネックス","C006","液晶ディスプレイ LP-1000",347000,2,694000,""]
[25,8,"2016-04-08","A006","ラネックス","B004","レーザープリンタ LBP-450",265000,1,265000,""]
[26,8,"2016-04-08","A006","ラネックス","B005","ジェットプリンタ BJC-240JII",56000,1,56000,""]
[27,9,"2016-02-29","A006","ラネックス","B005","ジェットプリンタ BJC-240JII",56000,1,56000,""]
[29,10,"2018-08-22","A006","ラネックス","A001","PC-9831Xa13",158000,4,632000,""]

{"sheet":"売上入力","index":1,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,"売　上　入　力"]
[]
[null,"伝票No",null,null,"日付"]
[]
[null,"顧客",null,"","顧客名",""]
[]
[null,"枝","商品","商品名","単価","数量","金額","備考"]
[null,1,"","","","","",""]
[null,2,"","","","","",""]
[null,3,"","","","","",""]
[null,4,"","","","","",""]
[null,5,"","","","","",""]
[null,6,"","","","","",""]
[null,7,"","","","","",""]
[null,8,"","","","","",""]
[null,null,null,null,"税抜金額",null,null,0]
[null,null,null,null,"消費税"]
[null,null,null,null,"売上金額"]

{"sheet":"顧客","index":2,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["コード","顧客名","よみがな","〒","住所","TEL","FAX"]
["A001","SK北海道システム",{"$f":"PHONETIC(B2)","v":"エスケイホッカイドウシステム"},"004-0015","北海道札幌市厚別区下野テクノパーク","011-809-XXXX","011-809-XXXX"]
["A002","ビーコンシステムエンジニア","ビーコンシステムエンジニア","981-3100","宮城県仙台市泉区中央X-X-X","022-371-XXXX","022-371-XXXX"]
["A003","日本電子開発","ニホンデンシカイハツ","980-0811 ","宮城県仙台市青葉区一番町X-XX","022-272-XXXX","022-272-XXXX"]
["A004","ソリマチ技術研究所","ソリマチギジュツケンキュウショ","940-0094","新潟県長岡市中島X-X-XX","0258-37-XXXX","0258-37-XXXX"]
["A005","日本興行通信","ニホンコウギョウツウシン","030-0145","青森県青森市金浜XX-XX","0256-55-XXXX","0256-55-XXXX"]
["A006","ラネックス","ラネックス","990-2435","山形県山形市青田XX-XX","0248-36-XXXX","0248-36-XXXX"]
["A007","PCサイエンス","ピーシーサイエンス","960-1108","福島県福島市成川XX-XX","0249-16-XXXX","0249-16-XXXX"]
["B001","コペルシステム","コペルシステム","108-0014","東京都港区芝X-XX-X","03-3454-XXXX","03-3454-XXXX"]
["B002","MEC情報システム","エムイーシージョウホウシステム","153-0064","東京都目黒区下目黒X-XX-X","03-5731-XXXX","03-5731-XXXX"]
["B003","さくら情報事業部","サクラジョウホウジギョウブ","275-0024","千葉県習志野市茜浜X-XX-X","0474-54-XXXX","0474-54-XXXX"]
["B004","四谷商事","ヨツヤショウジ","210-0024","神奈川県川崎市川崎区日進町X-X","044-246-XXXX","044-246-XXXX"]
["B005","富士通パソコンラボ","フジツウパソコンラボ","331-0852","埼玉県大宮市桜木町X-X-X","048-645-XXXX","048-645-XXXX"]
["B006","リョーサン","リョーサン","311-4141","茨城県水戸市赤塚XX-XX","0489-49-XXXX","0489-49-XXXX"]
["B007","安金電算機器","アガネデンサンキキ","213-0012","神奈川県川崎市高津区坂戸X-X-X","044-812-XXXX","044-812-XXXX"]
["C001","富士システムクリニック","フジシステムクリニック","416-0906","静岡県富士市本市場XX　カノウビル","0545-63-XXXX","0545-63-XXXX"]
["C002","パーパスPC事業部","パーパスピーシージギョウブ","386-1211","長野県上田市大字下之郷乙XXXX-XX","0268-38-XXXX","0268-38-XXXX"]
["C003","富士バイオ商事","フジバイオショウジ","604-0905","京都府京都市中京区蝶薬通烏丸XXX","075-211-XXXX","075-211-XXXX"]
["C004","井出倉庫","イデソウコ","400-0035","山梨県甲府市飯田X-X-X","0552-20-XXXX","0552-20-XXXX"]
["C005","南紀コンサルティング","ナンキコンサルティング","644-0041","和歌山県日高郡美浜町XX-X","0762-98-XXXX","0762-98-XXXX"]
["C006","関西MECソフト","カンサイエムイーシーソフト","570-0083","大阪府守口市京坂本通X-X-X","06-994-XXXX","06-994-XXXX"]
["C007","名鉄システムサービス","メイテツシステムサービス","450-0002","愛知県名古屋市中村区名駅南X-XX-X","052-589-XXXX","052-589-XXXX"]
["D001","荻原電機","オギワラデンキ","730-0017","広島県広島市中区鉄砲町X-XX","082-211-XXXX","082-211-XXXX"]
["D002","松下ソフト開発","マツシタソフトカイハツ","770-0831","徳島県徳島市寺島本町西X-X-X","0886-25-XXXX","0886-25-XXXX"]
["D003","日本商事","ニホンショウジ","700-0942","岡山県岡山市豊成X-X-X","086-264-XXXX","086-264-XXXX"]
["D004","ジャパンハイソフト","ジャパンハイソフト","680-0201","鳥取県岩美郡国府町雨滝XX-XX","0889-63-XXXX","0889-63-XXXX"]
["D005","カーネルジャパン","カーネルジャパン","754-0896","山口県山口市江崎XXX-XX","0892-46-XXXX","0892-46-XXXX"]
["D006","高木産業","タカギサンギョウ","791-8076","愛媛県松山市会津町X-XX","0887-55-XXXX","0887-55-XXXX"]
["D007","クレオ","クレオ","781-0111","高知県高知市池XX-XX","0888-26-XXXX","0888-26-XXXX"]
["E001","システムアスコム","システムアスコム","812-0011","福岡県福岡市博多区博多駅前X-XX","092-481-XXXX","092-481-XXXX"]
["E002","福岡コンサルティング","フクオカコンサルティング","812-0011","福岡県福岡市博多区博多駅前X-X","092-482-XXXX","092-482-XXXX"]
["E003","シャープビジネス","シャープビジネス","880-0125","宮崎県宮崎市広原XX-XXX","094-263-XXXX","094-263-XXXX"]
["E004","那覇通信","ナハツウシン","890-0075","鹿児島県鹿児島市桜ヶ丘7丁目X-X","093-545-XXXX","093-545-XXXX"]
["E005","三洋機械ソフトウェア","サンヨウキカイソフトウェア","870-0278","大分県大分市青崎XX-XX","094-482-XXXX","094-482-XXXX"]
["E006","パソコンアイランド鹿児島","パソコンアイランドカゴシマ","861-2104","熊本県熊本市秋津町XX-X","095-336-XXXX","095-336-XXXX"]
["E007","オンラインシステムズ","オンラインシステムズ","851-1122","長崎県長崎市相川町XX-XXX","094-522-XXXX","094-522-XXXX"]

{"sheet":"商品","index":3,"n_rows":36,"n_cols":3,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["コード","商品名","売上単価"]
["A001","PC-9831Xa13",158000]
["A002","PC-9831Xa14",248000]
["A003","PC-9831Xa15",318000]
["A004","PC-9831Xa16",368000]
["A005","ThinkPad500A",378000]
["A006","ThinkPad600B",430000]
["A007","ThinkPad700C",590000]
["B001","レーザープリンタ LBP-150",105000]
["B002","レーザープリンタ LBP-250",148000]
["B003","レーザープリンタ LBP-350",205000]
["B004","レーザープリンタ LBP-450",265000]
["B005","ジェットプリンタ BJC-240JII",56000]
["B006","ジェットプリンタ BJC-340JW",87000]
["B007","ジェットプリンタ BJC-650JS",143000]
["C001","ディスプレイ MT-8615B",54000]
["C002","ディスプレイ MT-8615BS",73000]
["C003","ディスプレイ MT-8617B",87000]
["C004","ディスプレイ MT-8617BS",135000]
["C005","ディスプレイ MT-8621B",298000]
["C006","液晶ディスプレイ LP-1000",347000]
["C007","液晶ディスプレイ LP-2000",485000]
["D001","ZIP LJD-100V",29800]
["D002","ZIP LZD-100V2",49800]
["D003","PD LPD-650SA",55000]
["D004","光ディスク MON-S230PF",54000]
["D005","光ディスク MON-D230",67000]
["D006","光ディスク MOS-S640PF",98000]
["D007","光ディスク MOS-D640",102000]
["E001","ページスキャナ LSC-300CL",108000]
["E002","ページスキャナ LSC-300CX",137000]
["E003","フィルムスキャナ LPR-150CL",79800]
["E004","グラフィック WGP-VG2DX",24000]
["E005","グラフィック WGP-VG4DX",45000]
["E006","CCDカメラ CVU-T25",90000]
["E007","スピーカ TGP-VR4",180000]

{"sheet":"請求書","index":4,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["請 求 書"]
["ラネックス"]
["2016-02-10",null,"請求金額",687000]
[]
["日付","伝票NO","商品ID","商品名","単価","数量","金額"]
["2016-03-05",3,"C004","ディスプレイ MT-8617BS",135000,1,135000]
["2016-03-05",3,"A002","PC-9831Xa14",248000,2,496000]
["2016-02-29",9,"B005","ジェットプリンタ BJC-240JII",56000,1,56000]
[null,null,null,"合計",null,null,687000]

{"sheet":"Sheet1","index":5,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["ID","伝票NO","日付","顧客ID","顧客名","商品ID","商品名","単価","数量","金額","備考"]
[2,2,"2016-03-02","A001","SK北海道システム","A006","ThinkPad600B",430000,1,430000,""]
[3,2,"2016-03-02","A001","SK北海道システム","B005","ジェットプリンタ BJC-240JII",56000,2,112000,""]
[4,2,"2016-03-02","A001","SK北海道システム","B005","ジェットプリンタ BJC-240JII",56000,2,112000,""]
[5,2,"2016-03-02","A001","SK北海道システム","A006","ThinkPad600B",430000,1,430000,""]
[6,2,"2016-03-02","A001","SK北海道システム","B005","ジェットプリンタ BJC-240JII",56000,10,560000,""]
[7,2,"2016-03-02","A001","SK北海道システム","C001","ディスプレイ MT-8615B",54000,1,54000,""]
[8,3,"2016-03-05","A006","ラネックス","C003","ディスプレイ MT-8617B",87000,2,174000,"部品ABC"]
[9,3,"2016-03-05","A006","ラネックス","C004","ディスプレイ MT-8617BS",135000,1,135000,"部品B"]
[10,3,"2016-03-05","A006","ラネックス","A002","PC-9831Xa14",248000,2,496000,""]
[11,4,"2016-03-10","A005","日本興行通信","A002","PC-9831Xa14",248000,1,248000,"123456789"]
[12,4,"2016-03-10","A005","日本興行通信","A005","ThinkPad500A",378000,2,756000,""]
[13,4,"2016-03-10","A005","日本興行通信","D006","光ディスク MOS-S640PF",98000,3,294000,""]
[14,5,"2016-03-11","A004","ソリマチ技術研究所","B005","ジェットプリンタ BJC-240JII",56000,2,112000,"456789"]
[15,5,"2016-03-11","A004","ソリマチ技術研究所","C003","ディスプレイ MT-8617B",87000,2,174000,""]
[16,4,"2016-03-12","A005","日本興行通信","A001","PC-9831Xa13",158000,1,158000,""]
[17,5,"2016-03-13","A004","ソリマチ技術研究所","A002","PC-9831Xa14",248000,1,248000,""]
[18,6,"2016-03-14","A002","ビーコンシステムエンジニア","B001","レーザープリンタ LBP-150",105000,1,105000,""]
[19,6,"2016-03-14","A002","ビーコンシステムエンジニア","B005","ジェットプリンタ BJC-240JII",56000,1,56000,""]