{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["問１","問２","問３","問４","問５","問６","問7","問8"],"not_rendered":{"charts":0,"images":15,"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":63,"n_cols":7,"rows_kept":63,"cut":false,"hidden":false,"merged":[[5,0,5,6],[44,0,44,6]]}
[]
[]
[]
[]
[]
["支店対抗ゴルフコンペ"]
[]
["エントリNo.","名前","アウト","イン","グロス","ハンディ","ネット"]
[null,"江口正治",60,55,null,30]
[null,"天野淳也",54,49,null,25]
[null,"中川智紀",46,39,null,12]
[null,"北野孝司",64,69,null,36]
[null,"稲垣智也",70,65,null,40]
[null,"松岡学",42,46,null,8]
[null,"仲井孝司",55,51,null,22]
[null,"土井真弓",47,50,null,20]
[null,"中山幸一",45,47,null,10]
[null,"渡辺陽子",68,63,null,36]
[null,"森真澄",57,58,null,24]
[null,"新城賢治",58,58,null,28]
[null,"長瀬晴彦",53,48,null,16]
[null,"吉本沙織",62,61,null,30]
[null,"松本剛",51,60,null,33]
[null,"木内哲也",56,45,null,18]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["支店対抗ゴルフコンペ"]
[]
["エントリNo.","名前","アウト","イン","グロス","ハンディ","ネット"]
[1,"江口正治",60,55,{"$f":"C48+D48","v":115},30,{"$f":"E48-F48","v":85}]
[2,"天野淳也",54,49,{"$f":"C49+D49","v":103},25,{"$f":"E49-F49","v":78}]
[3,"中川智紀",46,39,85,12,73]
[4,"北野孝司",64,69,133,36,97]
[5,"稲垣智也",70,65,135,40,95]
[6,"松岡学",42,46,88,8,80]
[7,"仲井孝司",55,51,106,22,84]
[8,"土井真弓",47,50,97,20,77]
[9,"中山幸一",45,47,92,10,82]
[10,"渡辺陽子",68,63,131,36,95]
[11,"森真澄",57,58,115,24,91]
[12,"新城賢治",58,58,116,28,88]
[13,"長瀬晴彦",53,48,101,16,85]
[14,"吉本沙織",62,61,123,30,93]
[15,"松本剛",51,60,111,33,78]
[16,"木内哲也",56,45,{"$f":"C63+D63","v":101},18,{"$f":"E63-F63","v":83}]

{"sheet":"問２","index":1,"n_rows":54,"n_cols":4,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["今期売上実績"]
[null,null,null,"単位(百万円）"]
[null,"関東","関西","全国"]
["冷蔵庫",1936,2869]
["洗濯機",2569,2697]
["電子レンジ",1569,1036]
["炊飯器",1036,2569]
["テレビ",3698,2569]
["オーディオ",2036,1936]
["上半期計"]
["冷蔵庫",2638,2869]
["洗濯機",2569,2697]
["電子レンジ",2869,1036]
["炊飯器",2369,2456]
["テレビ",1036,3987]
["オーディオ",2036,1936]
["下半期計"]
["今期合計"]
[]
[]
["薄緑色のセルに合計を求める数式を入力してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"関東","関西","全国"]
["冷蔵庫",1936,2869,{"$f":"SUM(B40:C40)","v":4805}]
["洗濯機",2569,2697,5266]
["電子レンジ",1569,1036,2605]
["炊飯器",1036,2569,3605]
["テレビ",3698,2569,6267]
["オーディオ",2036,1936,3972]
["上半期計",{"$f":"SUM(B40:B45)","v":12844},{"$f":"SUM(C40:C45)","v":13676},{"$f":"SUM(D40:D45)","v":26520}]
["冷蔵庫",2638,2869,{"$f":"SUM(B47:C47)","v":5507}]
["洗濯機",2569,2697,5266]
["電子レンジ",2869,1036,3905]
["炊飯器",2369,2456,4825]
["テレビ",1036,3987,5023]
["オーディオ",2036,1936,3972]
["下半期計",{"$f":"SUM(B47:B52)","v":13517},{"$f":"SUM(C47:C52)","v":14981},{"$f":"SUM(D47:D52)","v":28498}]
["今期合計",{"$f":"B46+B53","v":26361},{"$f":"C46+C53","v":28657},{"$f":"D46+D53","v":55018}]

{"sheet":"問３","index":2,"n_rows":246,"n_cols":12,"rows_kept":246,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["日付","支店","担当者","取引先","商品名","数量","単価","売上金額"]
["1999-01-10","本社","田村","竹芝商事","パソコン",15,200000]
["1999-01-12","京都","山田","竹芝商事","携帯電話",20,15000]
["1999-01-23","大阪","北村","尾林貿易","プリンタ",5,120000]
["1999-01-23","横浜","沖田","福丸物産","スキャナ",5,50000,null,"問題"]
["1999-01-24","大阪","山本","福丸物産","スキャナ",8,50000]
["1999-01-24","横浜","原","福丸物産","ファクシミリ",10,38000,null,null,"色の部分に計算式をいれてください"]
["1999-01-29","本社","荒木","尾林貿易","パソコン",10,200000]
["1999-01-30","京都","澤辺","竹芝商事","パソコン",5,200000]
["1999-02-05","横浜","佐々木","福丸物産","携帯電話",25,15000]
["1999-02-05","横浜","佐々木","竹芝商事","スキャナ",5,50000]
["1999-02-10","本社","荒木","尾林貿易","ファクシミリ",13,38000]
["1999-02-15","本社","田村","尾林貿易","ファクシミリ",6,38000]
["1999-02-18","横浜","沖田","竹芝商事","プリンタ",8,120000]
["1999-02-19","京都","澤辺","福丸物産","パソコン",5,200000]
["1999-02-22","横浜","原","尾林貿易","プリンタ",10,120000]
["1999-02-22","大阪","山本","尾林貿易","携帯電話",30,15000]
["1999-02-22","本社","田村","竹芝商事","スキャナ",5,50000]
["1999-02-25","大阪","北村","尾林貿易","プリンタ",8,120000]
["1999-03-03","大阪","山本","竹芝商事","スキャナ",2,50000]
["1999-03-05","京都","山田","竹芝商事","携帯電話",20,15000]
["1999-03-06","本社","田村","竹芝商事","プリンタ",5,120000]
["1999-03-08","大阪","北村","福丸物産","パソコン",15,200000]
["1999-03-08","京都","山田","竹芝商事","ファクシミリ",5,38000]
["1999-03-08","横浜","原","竹芝商事","スキャナ",5,50000]
["1999-03-14","本社","荒木","竹芝商事","ファクシミリ",8,38000]
["1999-03-25","横浜","沖田","尾林貿易","スキャナ",5,50000]
["1999-04-01","横浜","沖田","尾林貿易","ファクシミリ",5,38000]
["1999-04-03","大阪","山本","福丸物産","パソコン",15,200000]
["1999-04-12","京都","澤辺","尾林貿易","スキャナ",5,50000]
["1999-04-12","本社","荒木","尾林貿易","パソコン",10,200000]
["1999-04-13","大阪","山本","竹芝商事","プリンタ",5,120000]
["1999-04-18","京都","澤辺","竹芝商事","携帯電話",20,15000]
["1999-04-20","横浜","原","福丸物産","パソコン",10,200000]
["1999-04-20","大阪","北村","竹芝商事","携帯電話",10,15000]
["1999-04-25","京都","山田","尾林貿易","ファクシミリ",5,38000]
["1999-04-30","大阪","北村","福丸物産","プリンタ",6,120000]
["1999-05-03","横浜","佐々木","竹芝商事","スキャナ",3,50000]
["1999-05-03","本社","荒木","尾林貿易","パソコン",5,200000]
["1999-05-04","大阪","山本","福丸物産","携帯電話",10,15000]
["1999-05-04","大阪","北村","尾林貿易","スキャナ",5,50000]
["1999-05-05","横浜","佐々木","福丸物産","パソコン",20,200000]
["1999-05-06","本社","荒木","福丸物産","スキャナ",6,50000]
["1999-05-06","本社","荒木","竹芝商事","プリンタ",3,120000]
["1999-05-20","京都","山田","尾林貿易","プリンタ",7,120000]
["1999-05-25","大阪","山本","福丸物産","プリンタ",3,120000]
["1999-06-01","本社","荒木","福丸物産","スキャナ",4,50000]
["1999-06-01","横浜","佐々木","竹芝商事","携帯電話",30,15000]
["1999-06-05","大阪","北村","尾林貿易","パソコン",8,200000]
["1999-06-12","大阪","山本","竹芝商事","ファクシミリ",5,38000]
["1999-06-18","横浜","沖田","竹芝商事","ファクシミリ",5,38000]
["1999-06-18","本社","荒木","福丸物産","携帯電話",10,15000]
["1999-06-22","横浜","佐々木","福丸物産","プリンタ",5,120000]
["1999-06-23","大阪","北村","尾林貿易","スキャナ",8,50000]
["1999-06-23","大阪","北村","竹芝商事","ファクシミリ",5,38000]
["1999-06-25","京都","澤辺","尾林貿易","ファクシミリ",5,38000]
["1999-06-29","大阪","山本","竹芝商事","携帯電話",30,15000]
["1999-06-29","本社","荒木","竹芝商事","ファクシミリ",5,38000]
["1999-06-30","横浜","沖田","福丸物産","携帯電話",20,15000]
["1999-07-10","本社","田村","竹芝商事","パソコン",5,200000]
["1999-07-12","京都","山田","竹芝商事","携帯電話",15,15000]
["1999-07-13","大阪","北村","尾林貿易","プリンタ",5,120000]
["1999-07-23","横浜","沖田","福丸物産","スキャナ",8,50000]
["1999-07-24","大阪","山本","福丸物産","スキャナ",8,50000]
["1999-07-24","横浜","原","福丸物産","ファクシミリ",6,38000]
["1999-07-29","本社","荒木","尾林貿易","パソコン",10,200000]
["1999-07-30","京都","澤辺","竹芝商事","パソコン",7,200000]
["1999-08-06","横浜","佐々木","福丸物産","携帯電話",20,15000]
["1999-08-07","横浜","佐々木","竹芝商事","スキャナ",5,50000]
["1999-08-08","本社","荒木","尾林貿易","ファクシミリ",7,38000]
["1999-08-09","本社","田村","尾林貿易","ファクシミリ",6,38000]
["1999-08-10","横浜","沖田","竹芝商事","プリンタ",30,120000]
["1999-08-20","京都","澤辺","福丸物産","パソコン",5,200000]
["1999-08-20","横浜","原","尾林貿易","プリンタ",20,120000]
["1999-08-20","大阪","山本","尾林貿易","携帯電話",30,15000]
["1999-08-25","本社","田村","竹芝商事","スキャナ",6,50000]
["1999-08-26","大阪","北村","尾林貿易","プリンタ",8,120000]
["1999-09-03","大阪","山本","竹芝商事","スキャナ",2,50000]
["1999-09-04","京都","山田","竹芝商事","携帯電話",20,15000]
["1999-09-15","本社","田村","竹芝商事","プリンタ",5,120000]
["1999-09-18","大阪","北村","福丸物産","パソコン",15,200000]
["1999-09-19","京都","山田","竹芝商事","ファクシミリ",5,38000]
["1999-09-20","横浜","原","竹芝商事","スキャナ",5,50000]
["1999-09-27","本社","荒木","竹芝商事","ファクシミリ",8,38000]
["1999-09-28","横浜","沖田","尾林貿易","スキャナ",5,50000]
["1999-10-01","横浜","沖田","尾林貿易","ファクシミリ",5,38000]
["1999-10-02","大阪","山本","福丸物産","パソコン",15,200000]
["1999-10-12","京都","澤辺","尾林貿易","スキャナ",5,50000]
["1999-10-15","本社","荒木","尾林貿易","パソコン",10,200000]
["1999-10-16","大阪","山本","竹芝商事","プリンタ",5,120000]
["1999-10-17","京都","澤辺","竹芝商事","携帯電話",20,15000]
["1999-10-20","横浜","原","福丸物産","パソコン",10,200000]
["1999-10-20","大阪","北村","竹芝商事","携帯電話",10,15000]
["1999-10-21","京都","山田","尾林貿易","ファクシミリ",5,38000]
["1999-10-22","大阪","北村","福丸物産","プリンタ",6,120000]
["1999-11-03","横浜","佐々木","竹芝商事","スキャナ",3,50000]
["1999-11-04","本社","荒木","尾林貿易","パソコン",5,200000]
["1999-11-06","大阪","山本","福丸物産","携帯電話",10,15000]
["1999-11-07","大阪","北村","尾林貿易","スキャナ",5,50000]
["1999-11-12","横浜","佐々木","福丸物産","パソコン",10,200000]
["1999-11-15","本社","荒木","福丸物産","スキャナ",6,50000]
["1999-11-16","本社","荒木","竹芝商事","プリンタ",3,120000]
["1999-11-17","京都","山田","尾林貿易","プリンタ",7,120000]
["1999-11-18","大阪","山本","福丸物産","プリンタ",3,120000]
["1999-12-01","本社","荒木","福丸物産","スキャナ",4,50000]
["1999-12-01","横浜","佐々木","竹芝商事","携帯電話",10,15000]
["1999-12-04","大阪","山本","竹芝商事","ファクシミリ",5,38000]
["1999-12-05","横浜","沖田","竹芝商事","ファクシミリ",5,38000]
["1999-12-05","本社","荒木","福丸物産","携帯電話",10,15000]
["1999-12-20","横浜","佐々木","福丸物産","プリンタ",5,120000]
["1999-12-20","大阪","北村","尾林貿易","スキャナ",8,50000]
["1999-12-30","大阪","北村","竹芝商事","ファクシミリ",5,38000]
[]
[null,null,null,null,"合計"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["日付","支店","担当者","取引先","商品名","数量","単価","売上金額"]
["1999-01-10","本社","田村","竹芝商事","パソコン",15,200000,{"$f":"F134*G134","v":3000000}]
["1999-01-12","京都","山田","竹芝商事","携帯電話",20,15000,{"$f":"F135*G135","v":300000}]
["1999-01-23","大阪","北村","尾林貿易","プリンタ",5,120000,600000]
["1999-01-23","横浜","沖田","福丸物産","スキャナ",5,50000,250000,null,"問題",null,"色の部分に計算式をいれてください"]
["1999-01-24","大阪","山本","福丸物産","スキャナ",8,50000,400000]
["1999-01-24","横浜","原","福丸物産","ファクシミリ",10,38000,380000]
["1999-01-29","本社","荒木","尾林貿易","パソコン",10,200000,2000000]
["1999-01-30","京都","澤辺","竹芝商事","パソコン",5,200000,1000000]
["1999-02-05","横浜","佐々木","福丸物産","携帯電話",25,15000,375000]
["1999-02-05","横浜","佐々木","竹芝商事","スキャナ",5,50000,250000]
["1999-02-10","本社","荒木","尾林貿易","ファクシミリ",13,38000,494000]
["1999-02-15","本社","田村","尾林貿易","ファクシミリ",6,38000,228000]
["1999-02-18","横浜","沖田","竹芝商事","プリンタ",8,120000,960000]
["1999-02-19","京都","澤辺","福丸物産","パソコン",5,200000,1000000]
["1999-02-22","横浜","原","尾林貿易","プリンタ",10,120000,1200000]
["1999-02-22","大阪","山本","尾林貿易","携帯電話",30,15000,450000]
["1999-02-22","本社","田村","竹芝商事","スキャナ",5,50000,250000]
["1999-02-25","大阪","北村","尾林貿易","プリンタ",8,120000,960000]
["1999-03-03","大阪","山本","竹芝商事","スキャナ",2,50000,100000]
["1999-03-05","京都","山田","竹芝商事","携帯電話",20,15000,300000]
["1999-03-06","本社","田村","竹芝商事","プリンタ",5,120000,600000]
["1999-03-08","大阪","北村","福丸物産","パソコン",15,200000,3000000]
["1999-03-08","京都","山田","竹芝商事","ファクシミリ",5,38000,190000]
["1999-03-08","横浜","原","竹芝商事","スキャナ",5,50000,250000]
["1999-03-14","本社","荒木","竹芝商事","ファクシミリ",8,38000,304000]
["1999-03-25","横浜","沖田","尾林貿易","スキャナ",5,50000,250000]
["1999-04-01","横浜","沖田","尾林貿易","ファクシミリ",5,38000,190000]
["1999-04-03","大阪","山本","福丸物産","パソコン",15,200000,3000000]
["1999-04-12","京都","澤辺","尾林貿易","スキャナ",5,50000,250000]
["1999-04-12","本社","荒木","尾林貿易","パソコン",10,200000,2000000]
["1999-04-13","大阪","山本","竹芝商事","プリンタ",5,120000,600000]
["1999-04-18","京都","澤辺","竹芝商事","携帯電話",20,15000,300000]
["1999-04-20","横浜","原","福丸物産","パソコン",10,200000,2000000]
["1999-04-20","大阪","北村","竹芝商事","携帯電話",10,15000,150000]
["1999-04-25","京都","山田","尾林貿易","ファクシミリ",5,38000,190000]
["1999-04-30","大阪","北村","福丸物産","プリンタ",6,120000,720000]
["1999-05-03","横浜","佐々木","竹芝商事","スキャナ",3,50000,150000]
["1999-05-03","本社","荒木","尾林貿易","パソコン",5,200000,1000000]
["1999-05-04","大阪","山本","福丸物産","携帯電話",10,15000,150000]
["1999-05-04","大阪","北村","尾林貿易","スキャナ",5,50000,250000]
["1999-05-05","横浜","佐々木","福丸物産","パソコン",20,200000,4000000]
["1999-05-06","本社","荒木","福丸物産","スキャナ",6,50000,300000]
["1999-05-06","本社","荒木","竹芝商事","プリンタ",3,120000,360000]
["1999-05-20","京都","山田","尾林貿易","プリンタ",7,120000,840000]
["1999-05-25","大阪","山本","福丸物産","プリンタ",3,120000,360000]
["1999-06-01","本社","荒木","福丸物産","スキャナ",4,50000,200000]
["1999-06-01","横浜","佐々木","竹芝商事","携帯電話",30,15000,450000]
["1999-06-05","大阪","北村","尾林貿易","パソコン",8,200000,1600000]
["1999-06-12","大阪","山本","竹芝商事","ファクシミリ",5,38000,190000]
["1999-06-18","横浜","沖田","竹芝商事","ファクシミリ",5,38000,190000]
["1999-06-18","本社","荒木","福丸物産","携帯電話",10,15000,150000]
["1999-06-22","横浜","佐々木","福丸物産","プリンタ",5,120000,600000]
["1999-06-23","大阪","北村","尾林貿易","スキャナ",8,50000,400000]
["1999-06-23","大阪","北村","竹芝商事","ファクシミリ",5,38000,190000]
["1999-06-25","京都","澤辺","尾林貿易","ファクシミリ",5,38000,190000]
["1999-06-29","大阪","山本","竹芝商事","携帯電話",30,15000,450000]
["1999-06-29","本社","荒木","竹芝商事","ファクシミリ",5,38000,190000]
["1999-06-30","横浜","沖田","福丸物産","携帯電話",20,15000,300000]
["1999-07-10","本社","田村","竹芝商事","パソコン",5,200000,1000000]
["1999-07-12","京都","山田","竹芝商事","携帯電話",15,15000,225000]
["1999-07-13","大阪","北村","尾林貿易","プリンタ",5,120000,600000]
["1999-07-23","横浜","沖田","福丸物産","スキャナ",8,50000,400000]
["1999-07-24","大阪","山本","福丸物産","スキャナ",8,50000,400000]
["1999-07-24","横浜","原","福丸物産","ファクシミリ",6,38000,228000]
["1999-07-29","本社","荒木","尾林貿易","パソコン",10,200000,2000000]
["1999-07-30","京都","澤辺","竹芝商事","パソコン",7,200000,{"$f":"F199*G199","v":1400000}]
["1999-08-06","横浜","佐々木","福丸物産","携帯電話",20,15000,300000]
["1999-08-07","横浜","佐々木","竹芝商事","スキャナ",5,50000,250000]
["1999-08-08","本社","荒木","尾林貿易","ファクシミリ",7,38000,266000]
["1999-08-09","本社","田村","尾林貿易","ファクシミリ",6,38000,228000]
["1999-08-10","横浜","沖田","竹芝商事","プリンタ",30,120000,3600000]
["1999-08-20","京都","澤辺","福丸物産","パソコン",5,200000,1000000]
["1999-08-20","横浜","原","尾林貿易","プリンタ",20,120000,2400000]
["1999-08-20","大阪","山本","尾林貿易","携帯電話",30,15000,450000]
["1999-08-25","本社","田村","竹芝商事","スキャナ",6,50000,300000]
["1999-08-26","大阪","北村","尾林貿易","プリンタ",8,120000,960000]
["1999-09-03","大阪","山本","竹芝商事","スキャナ",2,50000,100000]
["1999-09-04","京都","山田","竹芝商事","携帯電話",20,15000,300000]
["1999-09-15","本社","田村","竹芝商事","プリンタ",5,120000,600000]
["1999-09-18","大阪","北村","福丸物産","パソコン",15,200000,3000000]
["1999-09-19","京都","山田","竹芝商事","ファクシミリ",5,38000,190000]
["1999-09-20","横浜","原","竹芝商事","スキャナ",5,50000,250000]
["1999-09-27","本社","荒木","竹芝商事","ファクシミリ",8,38000,304000]
["1999-09-28","横浜","沖田","尾林貿易","スキャナ",5,50000,250000]
["1999-10-01","横浜","沖田","尾林貿易","ファクシミリ",5,38000,190000]
["1999-10-02","大阪","山本","福丸物産","パソコン",15,200000,3000000]
["1999-10-12","京都","澤辺","尾林貿易","スキャナ",5,50000,250000]
["1999-10-15","本社","荒木","尾林貿易","パソコン",10,200000,2000000]
["1999-10-16","大阪","山本","竹芝商事","プリンタ",5,120000,600000]
["1999-10-17","京都","澤辺","竹芝商事","携帯電話",20,15000,300000]
["1999-10-20","横浜","原","福丸物産","パソコン",10,200000,2000000]
["1999-10-20","大阪","北村","竹芝商事","携帯電話",10,15000,150000]
["1999-10-21","京都","山田","尾林貿易","ファクシミリ",5,38000,190000]
["1999-10-22","大阪","北村","福丸物産","プリンタ",6,120000,720000]
["1999-11-03","横浜","佐々木","竹芝商事","スキャナ",3,50000,150000]
["1999-11-04","本社","荒木","尾林貿易","パソコン",5,200000,1000000]
["1999-11-06","大阪","山本","福丸物産","携帯電話",10,15000,150000]
["1999-11-07","大阪","北村","尾林貿易","スキャナ",5,50000,250000]
["1999-11-12","横浜","佐々木","福丸物産","パソコン",10,200000,2000000]
["1999-11-15","本社","荒木","福丸物産","スキャナ",6,50000,300000]
["1999-11-16","本社","荒木","竹芝商事","プリンタ",3,120000,360000]
["1999-11-17","京都","山田","尾林貿易","プリンタ",7,120000,840000]
["1999-11-18","大阪","山本","福丸物産","プリンタ",3,120000,360000]
["1999-12-01","本社","荒木","福丸物産","スキャナ",4,50000,200000]
["1999-12-01","横浜","佐々木","竹芝商事","携帯電話",10,15000,150000]
["1999-12-04","大阪","山本","竹芝商事","ファクシミリ",5,38000,190000]
["1999-12-05","横浜","沖田","竹芝商事","ファクシミリ",5,38000,190000]
["1999-12-05","本社","荒木","福丸物産","携帯電話",10,15000,150000]
["1999-12-20","横浜","佐々木","福丸物産","プリンタ",5,120000,600000]
["1999-12-20","大阪","北村","尾林貿易","スキャナ",8,50000,400000]
["1999-12-30","大阪","北村","竹芝商事","ファクシミリ",5,38000,190000]
[]
[null,null,null,null,"合計",{"$f":"SUM(F134:F244)","v":1012},null,{"$f":"SUM(H134:H244)","v":78882000}]

{"sheet":"問４","index":3,"n_rows":59,"n_cols":9,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,"海外旅行ツアー参加人数集計表"]
[null,"2003年度"]
[null,"コース名","旅行日数","申込数（人）","ｷｬﾝｾﾙ数（人）","参加数（人）",null,"問題"]
[null,"ワイキキ","８日間",479,38,null,null,null,"色の部分に計算式をいれてください"]
[null,"ラスベガス","７日間",350,23]
[null,"ホノルル","５日間",609,49]
[null,"バリ島","６日間",183,32]
[null,"パリ・ロンドン","８日間",249,31]
[null,"ニューヨーク","６日間",250,28]
[null,"ニュージーランド","７日間",134,32]
[null,"フロリダ","９日間",428,31]
[null,"タヒチ","１０日間",106,6]
[null,"スペイン","８日間",139,5]
[null,"シンガポール","５日間",275,36]
[null,"ジャマイカ","８日間",85,5]
[null,"ギリシャ","８日間",94,3]
[null,"カナダ","１０日間",123,21]
[null,"オーストラリア","６日間",387,26]
[null,"イタリア","９日間",178,28]
[null,"総合計"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"海外旅行ツアー参加人数集計表"]
[null,"99年度"]
[null,"コース名","旅行日数","申込数（人）","ｷｬﾝｾﾙ数（人）","参加数（人）"]
[null,"ワイキキ","８日間",479,38,{"$f":"D43-E43","v":441}]
[null,"ラスベガス","７日間",350,23,{"$f":"D44-E44","v":327}]
[null,"ホノルル","５日間",609,49,560]
[null,"バリ島","６日間",183,32,151]
[null,"パリ・ロンドン","８日間",249,31,218]
[null,"ニューヨーク","６日間",250,28,222]
[null,"ニュージーランド","７日間",134,32,102]
[null,"フロリダ","９日間",428,31,397]
[null,"タヒチ","１０日間",106,6,100]
[null,"スペイン","８日間",139,5,134]
[null,"シンガポール","５日間",275,36,239]
[null,"ジャマイカ","８日間",85,5,80]
[null,"ギリシャ","８日間",94,3,91]
[null,"カナダ","１０日間",123,21,102]
[null,"オーストラリア","６日間",387,26,361]
[null,"イタリア","９日間",178,28,150]
[null,"総合計",null,{"$f":"SUM(D43:D58)","v":4069},{"$f":"SUM(E43:E58)","v":394},{"$f":"SUM(F43:F58)","v":3675}]

{"sheet":"問５","index":4,"n_rows":103,"n_cols":6,"rows_kept":103,"cut":false,"hidden":false,"merged":[[8,0,8,2],[13,0,13,5],[67,0,67,2],[72,0,72,5]]}
[]
[null,null,null,null,null,"Tel.03-１１１１－１１１１"]
[null,null,null,null,null,"Fax.03-２２２２－２２２２"]
["請求書",null,null,null,"発行日","2016-07-08"]
[null,null,null,null,"伝票番号",2006]
[null,null,null,null,null,"担当:松本"]
[]
[]
["株式会社 岡田商会御中"]
[]
[]
[]
[]
["日頃はたいへんお世話になっております。\nさて、先月分の請求金額は下記のとおりです。\n下記期限までにお振込み頂きます様よろしくお願い申し上げます。"]
[]
[]
[null,"9月分請求合計"]
[]
["請求明細"]
["商品番号","商品名","内容","単価","数量","金額"]
["S1001","パソコンはじめてセット","セット１",350000,35]
["N1002","バイオス ノート","PCC-C1",250000,30]
["N1003","メブウス ノート","MN-600",280000,30]
["N1004","チンクパッド ノート","IVM-500",260000,20]
["D1005","液晶ディスプレイ","15インチ",150000,15]
["D1006","液晶ディスプレイ","14インチ",120000,20]
["M2002","増設メモリ","64MB×２",15000,30]
["M2003","増設メモリ","128MB×２",28000,10]
[null,null,null,null,"小計"]
[null,null,null,null,"消費税(8%)"]
[null,null,null,null,"総計"]
[]
[]
[]
[]
[]
[]
["お振込口座"]
[]
[null,"西京銀行　赤坂支店　普通1000000"]
[null,"(株)なんばショップ"]
[]
["お振込期限"]
[null,"今月末日"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Tel.03-１１１１－１１１１"]
[null,null,null,null,null,"Fax.03-２２２２－２２２２"]
["請求書",null,null,null,"発行日","2003-10-05"]
[null,null,null,null,"伝票番号",2006]
[null,null,null,null,null,"担当:松本"]
[]
[]
["株式会社 岡田商会御中"]
[]
[]
[]
[]
["日頃はたいへんお世話になっております。さて、先月分の請求金額は下記のとおりです。下記期限までにお振込み頂きます様よろしくお願い申し上げます。"]
[]
[]
[null,"9月分請求合計"]
[]
["請求明細"]
["商品番号","商品名","内容","単価","数量","金額"]
["S1001","パソコンはじめてセット","セット１",350000,35,{"$f":"D80*E80","v":12250000}]
["N1002","バイオス ノート","PCC-C1",250000,30,{"$f":"D81*E81","v":7500000}]
["N1003","メブウス ノート","MN-600",280000,30,8400000]
["N1004","チンクパッド ノート","IVM-500",260000,20,5200000]
["D1005","液晶ディスプレイ","15インチ",150000,15,2250000]
["D1006","液晶ディスプレイ","14インチ",120000,20,2400000]
["M2002","増設メモリ","64MB×２",15000,30,450000]
["M2003","増設メモリ","128MB×２",28000,10,280000]
[null,null,null,null,"小計",{"$f":"SUM(F80:F87)","v":38730000}]
[null,null,null,null,"消費税(5%)",{"$f":"F88*8%","v":3098400}]
[null,null,null,null,"総計",{"$f":"SUM(F88:F89)","v":41828400}]
[]
[]
[]
[]
[]
[]
["お振込口座"]
[]
[null,"西京銀行　赤坂支店　普通1000000"]
[null,"(株)なんばショップ"]
[]
["お振込期限"]
[null,"今月末日"]

{"sheet":"問６","index":5,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["時間外勤務管理表"]
[]
["社員番号","氏名","所属","基本給","精勤手当","残業単価","残業時間","超勤手当","合計"]
[101,"小野  美子","営業課",480000,20000,3000,6.5]
[102,"斉藤  裕行","営業課",336400,25000,2000,3.5]
[103,"神田  一郎","経理課",268900,25000,2000,3]
[104,"佐藤  純子","経理課",209500,10000,1500,10.5]
[105,"市川  陽子","総務課",216100,10000,1500,0]
[106,"中村　光昭","総務課",191800,10000,1500,5]
[107,"池田  ゆかり","営業課",217700,20000,1500,0]
[108,"土井  浩一","営業課",268700,10000,2000,8.5]
[109,"小川　佳枝","営業課",209200,10000,1500,6]
[110,"玉田　光恵","営業課",196300,20000,1500,0]
["合計"]
[]
[]
[]
[null,null,null,"色のセルに数式を設定してください。"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["時間外勤務管理表"]
[]
["社員番号","氏名","所属","基本給","精勤手当","残業単価","残業時間","超勤手当","合計"]
[101,"小野  美子","営業課",480000,20000,3000,6.5,{"$f":"F43*G43","v":19500},{"$f":"D43+E43+H43","v":519500}]
[102,"斉藤  裕行","営業課",336400,25000,2000,3.5,{"$f":"F44*G44","v":7000},{"$f":"D44+E44+H44","v":368400}]
[103,"神田  一郎","経理課",268900,25000,2000,3,6000,299900]
[104,"佐藤  純子","経理課",209500,10000,1500,10.5,15750,235250]
[105,"市川  陽子","総務課",216100,10000,1500,0,0,226100]
[106,"中村　光昭","総務課",191800,10000,1500,5,7500,209300]
[107,"池田  ゆかり","営業課",217700,20000,1500,0,0,237700]
[108,"土井  浩一","営業課",268700,10000,2000,8.5,17000,295700]
[109,"小川　佳枝","営業課",209200,10000,1500,6,9000,228200]
[110,"玉田　光恵","営業課",196300,20000,1500,0,0,216300]
["合計",null,null,{"$f":"SUM(D43:D52)","v":2594600},{"$f":"SUM(E43:E52)","v":160000},null,{"$f":"SUM(G43:G52)","v":43},{"$f":"SUM(H43:H52)","v":81750},{"$f":"SUM(I43:I52)","v":2836350}]

{"sheet":"問7","index":6,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
["パート勤務表"]
[]
[null,"氏名","斎藤政子"]
["日","出勤時間","退勤時間","休憩時間","実働時間","支給金額","時給"]
[2,9,17,1,null,null,870]
[4,9,17,1,null,null,870]
[5,13,18,null,null,null,870]
[8,9,17,1,null,null,870]
[10,13,18,null,null,null,870]
[11,9,17,1,null,null,870]
[15,8,16,1,null,null,870]
[16,8,16,1,null,null,870]
[20,9,17,1,null,null,870]
[25,9,17,1,null,null,870]
[26,13,18,null,null,null,870]
[28,8,18,1,null,null,870]
[null,null,"実動日数",{"$f":"COUNT(A5:A16)","v":12},"合計",{"$f":"SUM(F5:F16)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["パート勤務表"]
[]
[null,"氏名","斎藤政子"]
["日","出勤時間","退勤時間","休憩時間","実働時間","支給金額","時給"]
[2,9,17,1,{"$f":"C45-B45-D45","v":7},{"$f":"E45*G45","v":6090},870]
[4,9,17,1,{"$f":"C46-B46-D46","v":7},{"$f":"E46*G46","v":6090},870]
[5,13,18,null,5,4350,870]
[8,9,17,1,7,6090,870]
[10,13,18,null,5,4350,870]
[11,9,17,1,7,6090,870]
[15,8,16,1,7,6090,870]
[16,8,16,1,7,6090,870]
[20,9,17,1,7,6090,870]
[25,9,17,1,7,6090,870]
[26,13,18,null,5,4350,870]
[28,8,18,1,9,7830,870]
[null,null,"実動日数",{"$f":"COUNT(A45:A56)","v":12},"合計",{"$f":"SUM(F45:F56)","v":69600}]

{"sheet":"問8","index":7,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["商品名","単価","数量","計"]
["荻窪ラーメン",1500,30,{"$f":"B5*C5","v":45000}]
["讃岐うどん",2000,25,{"$f":"B6*C6","v":50000}]
["札幌ラーメン",1500,16,{"$f":"B7*C7","v":24000}]
["名古屋きしめん",2500,24,{"$f":"B8*C8","v":60000}]
[null,null,"小計"]
[null,null,"消費税"]
[null,null,"合計"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["商品名","単価","数量","計"]
["荻窪ラーメン",1500,30,{"$f":"B44*C44","v":45000}]
["讃岐うどん",2000,25,{"$f":"B45*C45","v":50000}]
["札幌ラーメン",1500,16,{"$f":"B46*C46","v":24000}]
["名古屋きしめん",2500,24,{"$f":"B47*C47","v":60000}]
[null,null,"小計",{"$f":"SUM(D44:D47)","v":179000}]
[null,null,"消費税",{"$f":"D48*8%","v":14320}]
[null,null,"合計",{"$f":"SUM(D48:D49)","v":193320}]