{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["お客様リスト解説","VBA問題","VBA解答","お客様リスト解説 (3)"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"現在の会員数",null,{"$f":"TODAY()","v":"2017-08-16"},"現在"]
[]
["会員№","氏　名","フリガナ","入会日","継続月数","地区コード","地区","担当"]
[1010,"小野田　奈緒",null,"2007-09-30",null,30]
[1011,"新谷　理江",null,"2007-12-30",null,50]
[1012,"辻井　夏帆",null,"2008-02-10",null,10]
[1013,"今村　まゆ",null,"2008-06-01",null,20]
[1014,"松村　文代",null,"2008-01-30",null,40]
[1015,"岩本　好江",null,"2010-05-03",null,50]
[1016,"高田　みゆき",null,"2011-04-24",null,50]
[1017,"舟木　香奈子",null,"2012-03-21",null,40]
[1018,"鈴木　明子",null,"2013-10-05",null,30]
[1019,"岡山　奈津",null,"2014-05-09",null,20]
[]
["地区コード表"]
[]
["地区コード",10,20,30,40,50]
["地区","中区","北区","南区","東区","西区"]
["担当","米山","平田","飯田","宮元","沢木"]
[]
[]
[]
[]
[]
[]
[]
["完成表"]
["会員№","氏　名","フリガナ","入会日","継続月数","地区コード","地区","担当"]
[1010,"小野田　奈緒",{"$f":"PHONETIC(B34)","v":"オノダ　ナオ"},"2007-09-30",{"$f":"DATEDIF(D34,$D$6,\"m\")","v":118},30,{"$f":"HLOOKUP($F34,$A$22:$F$24,2,FALSE)","v":"南区"},{"$f":"HLOOKUP($F34,$A$22:$F$24,3,FALSE)","v":"飯田"}]
[1011,"新谷　理江",{"$f":"PHONETIC(B35)","v":"シンタニ　リエ"},"2007-12-30",{"$f":"DATEDIF(D35,$D$6,\"m\")","v":115},50,"西区","沢木"]
[1012,"辻井　夏帆","ツジイ　カホ","2008-02-10",114,10,"中区","米山"]
[1013,"今村　まゆ","イマムラ　マユ","2008-06-01",110,20,"北区","平田"]
[1014,"松村　文代","マツムラ　フミヨ","2008-01-30",114,40,"東区","宮元"]
[1015,"岩本　好江","イワモト　ヨシエ","2010-05-03",87,50,"西区","沢木"]
[1016,"高田　みゆき","タカダ　ミユキ","2011-04-24",75,50,"西区","沢木"]
[1017,"舟木　香奈子","フナキ　カナコ","2012-03-21",64,40,"東区","宮元"]
[1018,"鈴木　明子","スズキ　アキコ","2013-10-05",46,30,"南区","飯田"]
[1019,"岡山　奈津","オカヤマ　ナツ","2014-05-09",39,20,"北区","平田"]

{"sheet":"VBA問題","index":1,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"現在の会員数",10,{"$f":"TODAY()","v":"2017-08-16"},"現在"]
[]
["会員№","氏　名","フリガナ","入会日","継続月数","地区コード","地区","担当",null,"地区コード","地区","担当"]
[1010,"小野田　奈緒",{"$f":"PHONETIC(B9)","v":"オノダ　ナオ"},"2012-01-01",60,10,null,null,null,10,"中区","米山"]
[1011,"新谷　理江",{"$f":"PHONETIC(B10)","v":"シンタニ　リエ"},"2007-12-30",109,20,null,null,null,20,"北区","平田"]
[1012,"辻井　夏帆","ツジイ　カホ","2008-02-10",107,30,null,null,null,30,"南区","飯田"]
[1013,"今村　まゆ","イマムラ　マユ","2014-01-01",36,10,null,null,null,40,"東区","宮元"]
[1014,"松村　文代","マツムラ　フミヨ","2008-01-30",108,30,null,null,null,50,"西区","沢木"]
[1015,"岩本　好江","イワモト　ヨシエ","2007-12-20",109,40,null,null,null,60,"中央区","吉田"]
[1016,"高田　みゆき","タカダ　ミユキ","2007-12-22",109,50]
[1017,"舟木　香奈子","フナキ　カナコ","2006-01-05",132,30]
[1018,"鈴木　明子","スズキ　アキコ","2006-01-10",132,10]
[1019,"岡山　奈津","オカヤマ　ナツ","2000-01-01",204,20]
[]
["地区コード表"]
[]
["地区コード",10,20,30,40,50]
["地区","中区","北区","南区","東区","西区"]
["担当","米山","平田","飯田","宮元","沢木"]

{"sheet":"VBA解答","index":2,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"現在の会員数",10,{"$f":"TODAY()","v":"2017-08-16"},"現在"]
[]
["会員№","氏　名","フリガナ","入会日","継続月数","地区コード","地区","担当",null,"地区コード","地区","担当"]
[1010,"小野田　奈緒",{"$f":"PHONETIC(B9)","v":"オノダ　ナオ"},"2000-05-03",207,10,"中区","米山",null,10,"中区","米山"]
[1011,"新谷　理江",{"$f":"PHONETIC(B10)","v":"シンタニ　リエ"},"2007-12-30",116,20,"北区","平田",null,20,"北区","平田"]
[1012,"辻井　夏帆","ツジイ　カホ","2008-02-10",114,30,"南区","飯田",null,30,"南区","飯田"]
[1013,"今村　まゆ","イマムラ　マユ","2014-01-01",43,null,null,null,null,40,"東区","宮元"]
[1014,"松村　文代","マツムラ　フミヨ","2008-01-30",115,null,null,null,null,50,"西区","沢木"]
[1015,"岩本　好江","イワモト　ヨシエ","2007-12-20",116,null,null,null,null,60,"中央区","吉田"]
[1016,"高田　みゆき","タカダ　ミユキ","2007-12-22",116]
[1017,"舟木　香奈子","フナキ　カナコ","2006-01-05",139]
[1018,"鈴木　明子","スズキ　アキコ","2006-01-10",139]
[1019,"岡山　奈津","オカヤマ　ナツ","2000-01-01",211]
[]
["地区コード表"]
[]
["地区コード",10,20,30,40,50]
["地区","中区","北区","南区","東区","西区"]
["担当","米山","平田","飯田","宮元","沢木"]

{"sheet":"お客様リスト解説 (3)","index":3,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,"現在の会員数",12,{"$f":"TODAY()","v":"2017-08-16"},"現在"]
[]
["会員№","氏　名","フリガナ","入会日","継続月数","地区コード","地区","担当",null,"地区コード","地区","担当"]
[1010,"小野田　奈緒",{"$f":"PHONETIC(B9)","v":"オノダ　ナオ"},"2014-01-02",43,20,"北区","平田",null,10,"中区","米山"]
[1011,"新谷　理江",{"$f":"PHONETIC(B10)","v":"シンタニ　リエ"},"2012-10-01",58,30,"南区","飯田",null,20,"北区","平田"]
[1012,"辻井　夏帆","ツジイ　カホ","2000-08-01",204,30,"東区","宮元",null,30,"南区","飯田"]
[1013,"今村　まゆ","イマムラ　マユ","2003-05-10",171,20,"北区","平田",null,40,"東区","宮元"]
[1014,"松村　文代","マツムラ　フミヨ","2014-02-03",42,30,"北区","平田",null,50,"西区","沢木"]
[1015,"岩本　好江","イワモト　ヨシエ","2011-10-05",70,60,"中央区","吉田",null,60,"中央区","吉田"]
[1016,"高田　みゆき","タカダ　ミユキ","2014-03-10",41,30,"南区","飯田"]
[1017,"舟木　香奈子","フナキ　カナコ","2013-04-05",52,20,"北区","平田"]
[1018,"鈴木　明子","スズキ　アキコ","2000-12-01",200,10,"中区","米山"]
[1019,"岡山　奈津","オカヤマ　ナツ","2000-11-01",201,60,"中央区","吉田"]
[1020,"田中　真紀子",{"$f":"PHONETIC(B19)","v":"タナカ　マキコ"},"2014-07-01",37,10,"中区","米山"]
[1021,"吉田　幸子",{"$f":"PHONETIC(B20)","v":"ヨシダ　サチコ"},"2014-08-01",36,20,"北区","平田"]