{"text_format":"1","workbook":"xlsx","n_sheets":34,"sheets":["練習1","練習2","練習3","練習4","練習5","練習6","練習7","練習8","練習9","練習10","練習11","練習12","練習13","練習14","練習15","練習15_回答","練習16","練習16_マスタ","練習17","練習18","練習19","練習20","練習21","練習22","練習23","練習23_データ","練習24","練習25","練習26","練習27","練習28","練習29","練習30","練習31"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"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":"練習1","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["日付","売上","客数","客単価"]
["2012-01-01",8030,81]
["2012-01-02",3039,66]
["2012-01-03",489,51]
["2012-01-04",4326,91]
["2012-01-05",526,91]
["2012-01-06",4570,51]
["2012-01-07",4688,14]
["2012-01-08",549,15]
["2012-01-09",6948,51]
["2012-01-10",6512,83]

{"sheet":"練習2","index":1,"n_rows":52,"n_cols":4,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["日付","数量","単価","金額"]
["2013-01-01",26,304]
["2013-01-02",68,305]
["2013-01-03",84,972]
["2013-01-04",53,684]
["2013-01-05",34,703]
["2013-01-06",56,628]
["2013-01-07",12,619]
["2013-01-08",92,356]
["2013-01-09",31,949]
["2013-01-10",19,229]
["2013-01-11",54,507]
["2013-01-12",35,666]
["2013-01-13",83,728]
["2013-01-14",68,272]
["2013-01-15",78,236]
["2013-01-16",87,334]
["2013-01-17",34,490]
["2013-01-18",32,650]
["2013-01-19",68,348]
["2013-01-20",98,744]
["2013-01-21",64,300]
["2013-01-22",65,148]
["2013-01-23",72,815]
["2013-01-24",80,509]
["2013-01-25",87,999]
["2013-01-26",89,205]
["2013-01-27",74,954]
["2013-01-28",69,114]
["2013-01-29",20,779]
["2013-01-30",58,751]
["2013-01-31",48,843]
["2013-02-01",95,338]
["2013-02-02",37,857]
["2013-02-03",48,676]
["2013-02-04",87,974]
["2013-02-05",81,210]
["2013-02-06",66,331]
["2013-02-07",58,259]
["2013-02-08",97,760]
["2013-02-09",32,646]
["2013-02-10",84,822]
["2013-02-11",60,426]
["2013-02-12",28,266]
["2013-02-13",63,768]
["2013-02-14",12,961]
["2013-02-15",94,906]
["2013-02-16",22,184]
["2013-02-17",64,971]
["2013-02-18",48,744]
["2013-02-19",14,864]
["2013-02-20",43,625]

{"sheet":"練習3","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,5,6,1,9,10,2,3,4,7,8]
[8]
[3]
[4]
[5]
[9]
[10]
[1]
[2]
[6]
[7]

{"sheet":"練習4","index":3,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["日付","納品数","入数","箱数","バラ数"]
["商品1",15,12]
["商品2",95,6]
["商品3",49,24]
["商品4",96,10]
["商品5",5,16]
["商品6",36,8]
["商品7",93,8]
["商品8",78,24]
["商品9",95,36]
["商品10",93,20]
["商品11",82,10]
["商品12",10,15]
["商品13",9,16]
["商品14",9,6]
["商品15",28,14]
["商品16",98,18]
["商品17",30,5]
["商品18",92,22]
["商品19",7,26]
["商品20",88,12]

{"sheet":"練習5","index":4,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["日付","昨年売上","今年売上","昨年比","記号"]
["2012-01-01",304,323]
["2012-01-02",305,279]
["2012-01-03",972,970]
["2012-01-04",684,631]
["2012-01-05",703,689]
["2012-01-06",628,653]
["2012-01-07",619,648]
["2012-01-08",366,324]
["2012-01-09",949,917]
["2012-01-10",229,245]
["2012-01-11",507,525]
["2012-01-12",666,673]
["2012-01-13",728,793]
["2012-01-14",272,288]
["2012-01-15",236,217]
["2012-01-16",334,367]
["2012-01-17",490,458]
["2012-01-18",655,589]
["2012-01-19",348,359]
["2012-01-20",744,687]

{"sheet":"練習6","index":5,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["日付","数量","単価","金額"]
["2013-01-01",26,304]
["2013-01-02",68,305]
["2013-01-03",84,972]
["2013-01-04",53,684]
["2013-01-05",34,703]
["2013-01-06",56,628]
["2013-01-07",12,619]
["2013-01-08",92,356]
["2013-01-09",31,949]
["2013-01-10",19,229]
["2013-01-11",54,507]
["2013-01-12",35,666]
["2013-01-13",83,728]
["2013-01-14",68,272]
["2013-01-15",78,236]
["2013-01-16",87,334]
["2013-01-17",34,490]
["2013-01-18",32,650]
["2013-01-19",68,348]
["2013-01-20",98,744]

{"sheet":"練習7","index":6,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["日付","数量","単価","金額"]
["2012-01-01",26,304]
["2012-01-02",68,305]
["2012-01-03",84,972]
["2012-01-04",53,684]
["2012-01-05",34,703]
["2012-01-06",56,628]
["2012-01-07",12,619]
["2012-01-08",92,356]
["2012-01-09",31,949]
["2012-01-10",19,229]
["2012-01-11",54,507]
["2012-01-12",35,666]
["2012-01-13",83,728]
["2012-01-14",68,272]
["2012-01-15",78,236]
["2012-01-16",87,334]
["2012-01-17",34,490]
["2012-01-18",32,650]
["2012-01-19",68,348]
["2012-01-20",98,744]

{"sheet":"練習8","index":7,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["日付","数量","単価","金額"]
["2014-01-01",26,304]
["2014-01-02",68,305]
["2014-01-03",84,972]
["2014-01-04",53,684]
["2014-01-05",34,703]
["2014-01-06",56,628]
["2014-01-07",12,619]
["2014-01-08",92,356]
["2014-01-09",31,949]
["2014-01-10",19,229]
["2014-01-11",54,507]
["2014-01-12",35,666]
["2014-01-13",83,728]
["2014-01-14",68,272]
["2014-01-15",78,236]
["2014-01-16",87,334]
["2014-01-17",34,490]
["2014-01-18",32,650]
["2014-01-19",68,348]
["2014-01-20",98,744]

{"sheet":"練習9","index":8,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["日付","昨年売上","今年売上","昨年比"]
["2012-01-01",304,323]
["2012-01-02",305,279]
["2012-01-03",972,970]
["2012-01-04",684,631]
["2012-01-05",703,689]
["2012-01-06",628,653]
["2012-01-07",619,648]
["2012-01-08",366,324]
["2012-01-09",949,917]
["2012-01-10",229,245]
["2012-01-11",507,525]
["2012-01-12",666,673]
["2012-01-13",728,793]
["2012-01-14",272,288]
["2012-01-15",236,217]
["2012-01-16",334,367]
["2012-01-17",490,458]
["2012-01-18",655,589]
["2012-01-19",348,359]
["2012-01-20",744,687]

{"sheet":"練習10","index":9,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["日付","売上","客数","客単価",null,"完成イメージ","日付","売上","客数","客単価"]
["2012-01-01",8030,81,99.135802469135797,null,null,"2012-01-01",8030,81,{"$f":"H2/I2","v":99.135802469135797}]
["2012-01-02",3039,66,46.045454545454547,null,null,"2012-01-02",3039,66,{"$f":"H3/I3","v":46.045454545454547}]
["2012-01-03",489,51,9.5882352941176467,null,null,"2012-01-03",489,51,9.5882352941176467]
["2012-01-04",4326,91,47.53846153846154,null,null,"2012-01-04",4326,91,47.53846153846154]
["2012-01-05",526,91,5.7802197802197801,null,null,"2012-01-05",526,91,5.7802197802197801]
["2012-01-06",4570,51,89.607843137254903,null,null,"2012-01-06",4570,51,89.607843137254903]
["2012-01-07",4688,14,334.85714285714283,null,null,"2012-01-07",4688,14,334.85714285714283]
["2012-01-08",549,15,36.6,null,null,"2012-01-08",549,15,36.6]
["2012-01-09",6948,51,136.23529411764707,null,null,"2012-01-09",6948,51,136.23529411764707]
["2012-01-10",6512,83,78.4578313253012,null,null,"2012-01-10",6512,83,78.4578313253012]

{"sheet":"練習11","index":10,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["見出し1","見出し2"]
[1,"A"]
[2,"B"]
[3,"C"]
[4,"D"]
[5,"E"]

{"sheet":"練習12","index":11,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["年","月","日","売上",null,"曜日","売上合計","日数","平均売上"]
[2012,1,1,72778,null,"月"]
[2012,1,2,50131,null,"火"]
[2012,1,3,53199,null,"水"]
[2012,1,4,19689,null,"木"]
[2012,1,5,51958,null,"金"]
[2012,1,6,47925,null,"土"]
[2012,1,7,59398,null,"日"]
[2012,1,8,90072]
[2012,1,9,34529]
[2012,1,10,31438]
[2012,1,11,68503]
[2012,1,12,50072]
[2012,1,13,79666]
[2012,1,14,65678]
[2012,1,15,54750]
[2012,1,16,10675]
[2012,1,17,69021]
[2012,1,18,83697]
[2012,1,19,85693]
[2012,1,20,61482]
[2012,1,21,33488]
[2012,1,22,30215]
[2012,1,23,38957]
[2012,1,24,28897]
[2012,1,25,84546]
[2012,1,26,99548]
[2012,1,27,20791]
[2012,1,28,41829]
[2012,1,29,53036]
[2012,1,30,78958]
[2012,1,31,61127]
[2012,2,1,84110]
[2012,2,2,10899]
[2012,2,3,75030]
[2012,2,4,21923]
[2012,2,5,26074]
[2012,2,6,82228]
[2012,2,7,32832]
[2012,2,8,10172]
[2012,2,9,34976]
[2012,2,10,56789]
[2012,2,11,13350]
[2012,2,12,32685]
[2012,2,13,12884]
[2012,2,14,48129]
[2012,2,15,21450]
[2012,2,16,64164]
[2012,2,17,88569]
[2012,2,18,98465]
[2012,2,19,23664]
[2012,2,20,67282]

{"sheet":"練習13","index":12,"n_rows":48,"n_cols":3,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["都道府県名","県庁所在地","都道府県名（県庁所在地）"]
["北海道(ほっかいどう)","札幌(さっぽろ)"]
["青森県(あおもり)","青森(あおもり)"]
["岩手県(いわて)","盛岡(もりおか)"]
["宮城県(みやぎ)","仙台(せんだい)"]
["秋田県(あきた)","秋田(あきた)"]
["山形県(やまがた)","山形(やまがた)"]
["福島県(ふくしま)","福島(ふくしま)"]
["茨城県(いばらき)","水戸(みと)"]
["栃木県(とちぎ)","宇都宮(うつのみや)"]
["群馬県(ぐんま)","前橋(まえばし)"]
["埼玉県(さいたま)","さいたま"]
["千葉県(ちば)","千葉(ちば)"]
["東京都(とうきょう)","東京(とうきょう)"]
["神奈川県(かながわ)","横浜(よこはま)"]
["新潟県(にいがた)","新潟(にいがた)"]
["富山県(とやま)","富山(とやま)"]
["石川県(いしかわ)","金沢(かなざわ)"]
["福井県(ふくい)","福井(ふくい)"]
["山梨県(やまなし)","甲府(こうふ)"]
["長野県(ながの)","長野(ながの)"]
["岐阜県(ぎふ)","岐阜(ぎふ)"]
["静岡県(しずおか)","静岡(しずおか)"]
["愛知県(あいち)","名古屋(なごや)"]
["三重県(みえ)","津(つ)"]
["滋賀県(しが)","大津(おおつ)"]
["京都府(きょうと)","京都(きょうと)"]
["大阪府(おおさか)","大阪(おおさか)"]
["兵庫県(ひょうご)","神戸(こうべ)"]
["奈良県(なら)","奈良(なら)"]
["和歌山県(わかやま)","和歌山(わかやま)"]
["鳥取県(とっとり)","鳥取(とっとり)"]
["島根県(しまね)","松江(まつえ)"]
["岡山県(おかやま)","岡山(おかやま)"]
["広島県(ひろしま)","広島(ひろしま)"]
["山口県(やまぐち)","山口(やまぐち)"]
["徳島県(とくしま)","徳島(とくしま)"]
["香川県(かがわ)","高松(たかまつ)"]
["愛媛県(えひめ)","松山(まつやま)"]
["高知県(こうち)","高知(こうち)"]
["福岡県(ふくおか)","福岡(ふくおか)"]
["佐賀県(さが)","佐賀(さが)"]
["長崎県(ながさき)","長崎(ながさき)"]
["熊本県(くまもと)","熊本(くまもと)"]
["大分県(おおいた)","大分(おおいた)"]
["宮崎県(みやざき)","宮崎(みやざき)"]
["鹿児島県(かごしま)","鹿児島(かごしま)"]
["沖縄県(おきなわ)","那覇(なは)"]

{"sheet":"練習14","index":13,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["区分","№"]
[null,1]
["D",2]
["I",3]
[null,4]
[null,5]
["D",6]
["D",7]
[null,8]
["I",9]
[null,10]
["D",11]
["I",12]
[null,13]
[null,14]
["I",15]
["I",16]
[null,17]
["D",18]
[null,19]
[null,20]

{"sheet":"練習15","index":14,"n_rows":190,"n_cols":3,"rows_kept":190,"cut":false,"hidden":false,"merged":[]}
["支店","分類","売上"]
["支店C","合成清酒",1001006]
["支店B","清酒",1172205]
["支店C","その他の発泡性酒類",1136914]
["支店D","果実酒",455111]
["支店D","ビール",1231967]
["支店C","その他の醸造酒",1404305]
["支店D","その他の発泡性酒類",1298529]
["支店D","その他の醸造酒",1448124]
["支店D","甘味果実酒",1071423]
["支店A","粉末酒",1249380]
["支店B","連続式蒸留しようちゆう",536416]
["支店A","ロ　みりん",1301359]
["支店C","果実酒",344570]
["支店A","原料用アルコール",1044944]
["支店D","粉末酒",1297892]
["支店B","ビール",669421]
["支店C","ビール",362744]
["支店D","スピリッツ",1025051]
["支店B","スピリッツ",1178844]
["支店B","甘味果実酒",388836]
["支店A","その他の発泡性酒類",624830]
["支店A","発泡酒",1325292]
["支店A","ビール",412933]
["支店C","ウイスキー　　",1027750]
["支店C","ロ　みりん",454220]
["支店D","発泡酒",1291931]
["支店C","単式蒸留しようちゆう",233416]
["支店B","粉末酒",1214563]
["支店B","リキュール",979057]
["支店B","果実酒",1158538]
["支店A","合成清酒",294283]
["支店D","雑酒",939082]
["支店D","ウイスキー　　",571864]
["支店A","単式蒸留しようちゆう",339300]
["支店A","その他の醸造酒",1102462]
["支店A","果実酒",966168]
["支店A","ウイスキー　　",78108]
["支店D","清酒",650958]
["支店D","連続式蒸留しようちゆう",395529]
["支店B","原料用アルコール",439710]
["支店B","ブランデー",533839]
["支店D","原料用アルコール",495471]
["支店C","甘味果実酒",69984]
["支店D","リキュール",532207]
["支店D","ロ　みりん",1034702]
["支店C","粉末酒",145124]
["支店B","合成清酒",1043182]
["支店B","雑酒",888437]
["支店A","甘味果実酒",194900]
["支店C","原料用アルコール",146405]
["支店D","合成清酒",439935]
["支店C","清酒",377624]
["支店C","スピリッツ",558986]
["支店D","単式蒸留しようちゆう",1261683]
["支店A","連続式蒸留しようちゆう",540594]
["支店A","清酒",471054]
["支店B","その他の醸造酒",310432]
["支店C","リキュール",1212549]
["支店B","発泡酒",232262]
["支店B","ウイスキー　　",663430]
["支店B","ロ　みりん",490343]
["支店B","単式蒸留しようちゆう",1367145]
["支店C","発泡酒",329948]
["支店D","ブランデー",891014]
["支店A","ブランデー",1043717]
["支店C","連続式蒸留しようちゆう",673570]
["支店C","ブランデー",779012]
["支店C","雑酒",93826]
["支店A","スピリッツ",1253814]
["支店B","その他の発泡性酒類",526029]
["支店A","リキュール",1441814]
["支店A","雑酒",1210891]
["支店C","合成清酒",56880]
["支店B","清酒",1157992]
["支店C","その他の発泡性酒類",1141592]
["支店D","果実酒",1454335]
["支店D","ビール",135035]
["支店C","その他の醸造酒",668001]
["支店D","その他の発泡性酒類",991113]
["支店D","その他の醸造酒",967935]
["支店D","甘味果実酒",400010]
["支店A","粉末酒",1162674]
["支店B","連続式蒸留しようちゆう",1199299]
["支店A","ロ　みりん",440938]
["支店C","果実酒",601575]
["支店A","原料用アルコール",1109947]
["支店D","粉末酒",60734]
["支店B","ビール",567092]
["支店C","ビール",488883]
["支店D","スピリッツ",406451]
["支店B","スピリッツ",1074086]
["支店B","甘味果実酒",608881]
["支店A","その他の発泡性酒類",366384]
["支店A","発泡酒",80285]
["支店A","ビール",409771]
["支店C","ウイスキー　　",602353]
["支店C","ロ　みりん",523270]
["支店D","発泡酒",754901]
["支店C","単式蒸留しようちゆう",157183]
["支店B","粉末酒",327405]
["支店B","リキュール",478140]
["支店B","果実酒",1044214]
["支店A","合成清酒",320601]
["支店D","雑酒",662632]
["支店D","ウイスキー　　",504202]
["支店A","単式蒸留しようちゆう",1103739]
["支店A","その他の醸造酒",1078830]
["支店A","果実酒",1308749]
["支店A","ウイスキー　　",907246]
["支店D","清酒",496522]
["支店D","連続式蒸留しようちゆう",787874]
["支店B","原料用アルコール",865983]
["支店B","ブランデー",1446692]
["支店D","原料用アルコール",111860]
["支店C","甘味果実酒",1198192]
["支店D","リキュール",770600]
["支店D","ロ　みりん",796002]
["支店C","粉末酒",858488]
["支店B","合成清酒",1479498]
["支店B","雑酒",644502]
["支店A","甘味果実酒",388873]
["支店C","原料用アルコール",649876]
["支店D","合成清酒",1351602]
["支店C","清酒",521042]
["支店C","スピリッツ",408558]
["支店D","単式蒸留しようちゆう",1268368]
["支店A","連続式蒸留しようちゆう",208250]
["支店A","清酒",283322]
["支店B","その他の醸造酒",149931]
["支店C","リキュール",595659]
["支店B","発泡酒",123437]
["支店B","ウイスキー　　",533389]
["支店B","ロ　みりん",1233804]
["支店B","単式蒸留しようちゆう",782049]
["支店C","発泡酒",111567]
["支店D","ブランデー",840835]
["支店A","ブランデー",442345]
["支店C","連続式蒸留しようちゆう",474321]
["支店C","ブランデー",923999]
["支店C","雑酒",944450]
["支店A","スピリッツ",1369381]
["支店B","その他の発泡性酒類",55438]
["支店A","リキュール",784134]
["支店A","雑酒",1125338]
["支店B","連続式蒸留しようちゆう",240716]
["支店A","ロ　みりん",306777]
["支店C","果実酒",1327018]
["支店A","原料用アルコール",444335]
["支店D","粉末酒",365650]
["支店B","ビール",484170]
["支店C","ビール",126944]
["支店D","スピリッツ",1393990]
["支店B","スピリッツ",470088]
["支店B","甘味果実酒",61850]
["支店A","その他の発泡性酒類",1130446]
["支店A","発泡酒",630255]
["支店A","ビール",120791]
["支店C","ウイスキー　　",1435654]
["支店C","ロ　みりん",1291615]
["支店D","発泡酒",952385]
["支店C","単式蒸留しようちゆう",694294]
["支店B","粉末酒",56705]
["支店B","リキュール",1167586]
["支店B","果実酒",494309]
["支店A","合成清酒",97617]
["支店D","雑酒",94165]
["支店D","ウイスキー　　",1199899]
["支店A","単式蒸留しようちゆう",392822]
["支店A","その他の醸造酒",976822]
["支店A","果実酒",388638]
["支店A","ウイスキー　　",1413481]
["支店D","清酒",736967]
["支店D","連続式蒸留しようちゆう",103871]
["支店B","原料用アルコール",651914]
["支店B","ブランデー",620825]
["支店D","原料用アルコール",1194135]
["支店C","甘味果実酒",110981]
["支店D","リキュール",354213]
["支店D","ロ　みりん",1135044]
["支店C","粉末酒",411649]
["支店B","合成清酒",1215873]
["支店B","雑酒",637486]
["支店A","甘味果実酒",1090798]
["支店C","原料用アルコール",187735]
["支店D","合成清酒",1093935]
["支店C","清酒",148829]
["支店C","スピリッツ",1150820]
["支店D","単式蒸留しようちゆう",793480]
["支店A","連続式蒸留しようちゆう",1249634]

{"sheet":"練習15_回答","index":15,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"支店A","支店B","支店C","支店D"]
["ビール"]
["発泡酒"]
["その他の発泡性酒類"]
["清酒"]
["果実酒"]
["その他の醸造酒"]
["連続式蒸留しようちゆう"]
["単式蒸留しようちゆう"]
["ウイスキー　　"]
["ブランデー"]
["原料用アルコール"]
["スピリッツ"]
["合成清酒"]
["ロ　みりん"]
["甘味果実酒"]
["リキュール"]
["粉末酒"]
["雑酒"]

{"sheet":"練習16","index":16,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["行","商品番号","商品名","単価","数量","金額"]
[1,"A06",null,null,3]
[2,"A07",null,null,2]
[3,"A02",null,null,4]
[4,"A08",null,null,5]
[5,"A01",null,null,6]
[6,"A03",null,null,1]
[7,"A04",null,null,4]
[8,"A09",null,null,3]
[9,"A10",null,null,7]
[10,"A05",null,null,2]
[null,null,null,null,"合計"]

{"sheet":"練習16_マスタ","index":17,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["商品番号","商品名","単価"]
["A01","商品△１",1100]
["A02","商品△２",1200]
["A03","商品△３",1300]
["A05","商品△５",1500]
["A07","商品△７",1700]
["A08","商品△８",1800]
["A09","商品△９",1900]
["A10","商品△１０",2000]

{"sheet":"練習17","index":18,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["パス","ブック名",null,"完成イメージ"]
["C:\\User","Book1.xls"]
["C:\\User","サンプル.xls"]
["C:\\User","test.xls"]

{"sheet":"練習18","index":19,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["C:\\User"]
["ブック名","シート名1","シート名2","シート名3","シート名4","シート名5","シート名6","シート名7"]

{"sheet":"練習19","index":20,"n_rows":20,"n_cols":10,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,4,0],[5,0,8,0],[9,0,12,0],[13,0,16,0],[17,0,19,0]]}
[null,"月曜日","火曜日","水曜日","木曜日","金曜日","土曜日","日曜日","合計","合計"]
["第１週","日付","2017-01-30","2017-01-31","2017-02-01","2017-02-02","2017-02-03","2017-02-04","2017-02-05"]
[null,"売上",74233,51133,55347,19689,56239,49860,61796]
[null,"客数",81,71,49,90,88,51,14]
[null,"客単価"]
["第２週","日付","2017-02-06","2017-02-07","2017-02-08","2017-02-09","2017-02-10","2017-02-11","2017-02-12"]
[null,"売上",75717,54261,57582,20892,55137,47925,59398]
[null,"客数",80,67,51,91,91,49,15]
[null,"客単価"]
["第３週","日付","2017-02-13","2017-02-14","2017-02-15","2017-02-16","2017-02-17","2017-02-18","2017-02-19"]
[null,"売上",77231,52155,53199,20082,51958,50857,63031]
[null,"客数",83,66,50,89,90,50,13]
[null,"客単価"]
["第４週","日付","2017-02-20","2017-02-21","2017-02-22","2017-02-23","2017-02-24","2017-02-25","2017-02-26"]
[null,"売上",72778,53198,56453,20483,52997,48883,60585]
[null,"客数",79,69,52,92,92,51,14]
[null,"客単価"]
["合計","売上"]
[null,"客数"]
[null,"客単価"]

{"sheet":"練習20","index":21,"n_rows":60,"n_cols":7,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
["日付","売上",null,null,"出来上がりサンプル","2012-01-01",72778]
["2012-01-01",72778,null,null,null,"2012-01-02",50131]
["2012-01-02",50131,null,null,null,"・・・"]
["2012-01-03",53199,null,null,null,"2012-01-31",61127]
["2012-01-04",19689,null,null,null,"1月合計",1711746]
["2012-01-05",51958,null,null,null,"2012-02-01",84110]
["2012-01-06",47925,null,null,null,"・・・"]
["2012-01-07",59398,null,null,null,"2012-02-28",30215]
["2012-01-08",90072,null,null,null,"2月合計",1320526]
["2012-01-09",34529]
["2012-01-10",31438]
["2012-01-11",68503]
["2012-01-12",50072]
["2012-01-13",79666]
["2012-01-14",65678]
["2012-01-15",54750]
["2012-01-16",10675]
["2012-01-17",69021]
["2012-01-18",83697]
["2012-01-19",85693]
["2012-01-20",61482]
["2012-01-21",33488]
["2012-01-22",30215]
["2012-01-23",38957]
["2012-01-24",28897]
["2012-01-25",84546]
["2012-01-26",99548]
["2012-01-27",20791]
["2012-01-28",41829]
["2012-01-29",53036]
["2012-01-30",78958]
["2012-01-31",61127]
["2012-02-01",84110]
["2012-02-02",10899]
["2012-02-03",75030]
["2012-02-04",21923]
["2012-02-05",26074]
["2012-02-06",82228]
["2012-02-07",32832]
["2012-02-08",10172]
["2012-02-09",34976]
["2012-02-10",56789]
["2012-02-11",13350]
["2012-02-12",32685]
["2012-02-13",12884]
["2012-02-14",48129]
["2012-02-15",21450]
["2012-02-16",64164]
["2012-02-17",88569]
["2012-02-18",98465]
["2012-02-19",23664]
["2012-02-20",67282]
["2012-02-21",34529]
["2012-02-22",31438]
["2012-02-23",68503]
["2012-02-24",50072]
["2012-02-25",79666]
["2012-02-26",65678]
["2012-02-27",54750]
["2012-02-28",30215]

{"sheet":"練習21","index":22,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["都道府県","売上",null,"都道府県","合計売上"]
["茨城県",72778]
["栃木県",50131]
["群馬県",53199]
["埼玉県",19689]
["千葉県",51958]
["東京都",47925]
["神奈川県",59398]
["茨城県",90072]
["栃木県",34529]
["群馬県",31438]
["埼玉県",68503]
["千葉県",50072]
["東京都",79666]
["神奈川県",65678]
["千葉県",54750]
["東京都",10675]
["神奈川県",69021]
["茨城県",83697]
["栃木県",85693]
["群馬県",61482]
["埼玉県",33488]
["千葉県",30215]
["東京都",38957]
["神奈川県",28897]
["埼玉県",84546]
["千葉県",99548]
["東京都",20791]
["神奈川県",41829]
["千葉県",53036]

{"sheet":"練習22","index":23,"n_rows":13,"n_cols":19,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["伝票番号","商品1","数量1","単価1","商品2","数量2","単価2","商品3","数量3","単価3","商品4","数量4","単価4","商品5","数量5","単価5","商品6","数量6","単価6"]
[1,"バジル　",9,254,"イタリアンパセリ　",10,56,"セルフィーユ",11,158]
[2,"スペアミント　",5,230,"オレガノ　",12,237,"ローズマリー　",10,297,"タイム　",1,204,"セージ　",2,180,"ディル　",11,277]
[3,"タラゴン　",12,266,"木の芽",12,269,"エシャレット",5,232]
[4,"小菊　",9,89]
[5,"穂じそ　",7,185,"紅たて　",16,182,"アンティーブ（チコリ）",1,171,"辛味大根",16,186]
[6,"トレビス",7,294,"ししとう",5,117,"にんにく",15,248]
[7,"プチニンニク",16,223,"にんにく ",17,258]
[8,"黄金の里生姜",9,191,"ぎんなん",10,90,"ゆりね",8,135,"にんにくのめ",5,138]
[9,"近江生姜",10,297,"大葉",16,104,"みょうが",17,199]
[10,"ゆず",3,129,"すだち",12,177,"かぼす",4,137,"サンチエ（パオ菜）",18,185,"パセリ",13,283]
[]
[null,"完成イメージ"]

{"sheet":"練習23","index":24,"n_rows":4,"n_cols":3,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["日付","名前"]
[]
[]
["日付","名前","売上"]

{"sheet":"練習23_データ","index":25,"n_rows":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["日付","名前","売上"]
["2012-02-01","佐藤",60401]
["2012-02-01","鈴木",52356]
["2012-02-01","高橋",63710]
["2012-02-01","田中",31031]
["2012-02-01","渡辺",91167]
["2012-02-01","伊藤",35587]
["2012-02-01","山本",13380]
["2012-02-01","中村",10568]
["2012-02-01","小林",16088]
["2012-02-01","斎藤",48431]
["2012-02-02","佐藤",74483]
["2012-02-02","鈴木",37145]
["2012-02-02","高橋",25299]
["2012-02-02","田中",40721]
["2012-02-02","渡辺",74643]
["2012-02-02","伊藤",38452]
["2012-02-02","山本",26336]
["2012-02-02","中村",68897]
["2012-02-02","小林",54442]
["2012-02-02","斎藤",48827]
["2012-02-03","佐藤",73344]
["2012-02-03","鈴木",99534]
["2012-02-03","高橋",38550]
["2012-02-03","田中",47101]
["2012-02-03","渡辺",50946]
["2012-02-03","伊藤",88662]
["2012-02-03","山本",80139]
["2012-02-03","中村",83470]
["2012-02-03","小林",63135]
["2012-02-03","斎藤",51899]
["2012-02-04","佐藤",53329]
["2012-02-04","鈴木",50511]
["2012-02-04","高橋",62527]
["2012-02-04","田中",58765]
["2012-02-04","渡辺",20835]
["2012-02-04","伊藤",64537]
["2012-02-04","山本",57450]
["2012-02-04","中村",99263]
["2012-02-04","小林",70988]
["2012-02-04","斎藤",59704]
["2012-02-05","佐藤",98885]
["2012-02-05","鈴木",78962]
["2012-02-05","高橋",16117]
["2012-02-05","田中",44974]
["2012-02-05","渡辺",78055]
["2012-02-05","伊藤",51420]
["2012-02-05","山本",63214]
["2012-02-05","中村",35803]
["2012-02-05","小林",58097]
["2012-02-05","斎藤",38558]

{"sheet":"練習24","index":26,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["分類A","分類B","分類C","分類D"]
["項目A1","項目B1","項目C1","項目D1"]
["項目A2","項目B2","項目C2","項目D2"]
["項目A3","項目B3","項目C3","項目D3"]
["項目A4",null,"項目C4","項目D4"]
["項目A5",null,"項目C5","項目D5"]
["項目A6",null,"項目C6"]
["項目A7"]
["項目A8"]

{"sheet":"練習25","index":27,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["課題","元データ","回答"]
["\"VBA\"を\"vba\"に変換","Excelマクロ(VBA)練習"]
["括弧()内の文字のみ取り出す","Excelマクロ(VBA)練習"]
["拡張子を取り出す","マクロ.セミナー.xls"]
["ひらがなをカタカナに変換","まくろVBA練習"]
["全て小文字に変換","ExcelVba"]
["半角のみならOK、全角含む場合はNG","ExcelＶba"]
["日付データに変換",20130410]
["曜日を求める","2013-04-10"]
["10日後の日付を求める","2013-04-10"]
["月末日を求める","2013-04-10"]
["先頭の数値を取り出す","350ML"]
["整数にする",352.5]
["小数以下1桁に四捨五入する",352.45]
["ピリオド(.)の数を数える","192.168.101.255"]
["前後の余分な空白を取り除く","　V　B　A　"]

{"sheet":"練習26","index":28,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["問題"]
[]
["現在のブックの先頭に新規シートを追加し、"]
["既存シートのシート名一覧をハイパーリンク付きで作成して下さい。"]
[]
["データはありません。"]

{"sheet":"練習27","index":29,"n_rows":21,"n_cols":2,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["担当","支店"]
["担当者1","支店B"]
["担当者2","支店C"]
["担当者3","支店A"]
["担当者4","支店B"]
["担当者5","支店C"]
["担当者6","支店C"]
["担当者7","支店A"]
["担当者8","支店B"]
["担当者9","支店C"]
["担当者10","支店A"]
["担当者11","支店B"]
["担当者12","支店A"]
["担当者13","支店B"]
["担当者14","支店A"]
["担当者15","支店B"]
["担当者16","支店C"]
["担当者17","支店A"]
["担当者18","支店B"]
["担当者19","支店C"]
["担当者20","支店C"]

{"sheet":"練習28","index":30,"n_rows":9,"n_cols":1,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["問題"]
[]
["アクティブブックにはシートが複数（Sheet1,Sheet2,Sheet3）あります、"]
[]
["Sheet1だけを別ブックにして、計算式を抜き（値だけにする）にしてから保存して下さい。"]
[]
["作成したブックの保存先は、アクティブブックと同一フォルダとし、ブック名はシート名と同一にして下さい。"]
[]
["データはありません。"]

{"sheet":"練習29","index":31,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["注文番号","注文数",null,"ロット番号","入荷数","出荷数",null,"注文番号","注文数","ロット番号","出荷数"]
["B0001",1100,null,"A0001",200]
["B0002",900,null,"A0002",180]
["B0003",1200,null,"A0003",200]
["B0004",1000,null,"A0004",200]
[null,null,null,"A0005",180]
[null,null,null,"A0006",190]
[null,null,null,"A0007",250]
[null,null,null,"A0008",250]
[null,null,null,"A0009",170]
[null,null,null,"A0010",180]
[null,null,null,"A0011",250]
[null,null,null,"A0012",200]
[null,null,null,"A0013",220]
[null,null,null,"A0014",250]
[null,null,null,"A0015",250]
[null,null,null,"A0016",190]
[null,null,null,"A0017",200]
[null,null,null,"A0018",250]
[null,null,null,"A0019",250]
[null,null,null,"A0020",200]
[null,null,null,"A0021",250]
[null,null,null,"A0022",200]
[null,null,null,"A0023",220]
[null,null,null,"A0024",250]
[null,null,null,"A0025",250]

{"sheet":"練習30","index":32,"n_rows":8,"n_cols":11,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,8,0,10],[2,0,3,0],[4,0,5,0],[6,0,7,0],[0,2,0,4],[0,5,0,7]]}
[null,null,"A支店",null,null,"B支店",null,null,"C支店"]
[null,null,"売上","仕入","仕入比","売上","仕入","仕入比","売上","仕入","仕入比"]
["2017年","実績",1419,752,0.52995066948555325,2167,1235,0.56991232118135671,1828,1169,0.63949671772428884]
[null,"予算",1079,517,0.47914735866543096,1160,730,0.62931034482758619,1653,909,0.54990925589836659]
["2018年","売上",1328,717,0.53990963855421692,1666,949,0.56962785114045622,1932,1120,0.57971014492753625]
[null,"仕入",1305,835,0.63984674329501912,2705,1406,0.51977818853974123,1538,922,0.59947984395318599]
["2019年","売上",1097,658,0.59981768459434825,2093,1318,0.62971810797897754,1518,819,0.53952569169960474]
[null,"仕入",1385,803,0.57978339350180508,2599,1273,0.48980377068103115,2247,1325,0.58967512238540276]

{"sheet":"練習31","index":33,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,3,2,4],[3,2,7,2],[4,4,5,6]]}
[]
[null,"B2","C2","D2","E2","F2","G2","H2"]
[null,"B3","C3","D3",null,"F3","G3","H3"]
[null,"B4","C4","D4","E4","F4","G4","H4"]
[null,"B5",null,"D5","E5",null,null,"H5"]
[null,"B6",null,"D6",null,null,null,"H6"]
[null,"B7",null,"D7","E7","F7","G7","H7"]
[null,"B8",null,"D8","E8","F8","G8","H8"]
[null,"B9","C9","D9","E9","F9","G9","H9"]