{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["ﾏﾆｭｱﾙ","設定","№1","№2","№3","№4","№5","№6","№7","№8","№9","№10","№11","№12","№13","№14","№15","№16","№17","№18","№19","№20","Sheet1"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":23,"comments":1,"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":64,"n_cols":4,"rows_kept":64,"cut":false,"hidden":false,"merged":[[9,1,9,3],[36,1,36,3],[1,1,1,3],[2,1,2,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3]]}
[]
[null,"           [タイムカード時間集計表A_２０人迄]の内容"]
[null,"タイムレコダーで入力したタイムカードから，最高で20人分の１ヶ月巻の就業時間を集計します。"]
[]
[null,"      　  Sheetの役割"]
[null,"<　見積　> \n見積書の原本です。シートの名称を変更しないで下さい。"]
[null,"<　№1～№20　>\n20人分のタイムカードの時間を集計する一覧表です。"]
[null,"< マニュアル >\nこのマニュアルです。"]
[]
[null,"　　　　マクロボタンの機能"]
[null,1,"○"]
[null,null,"・","設定シートの　A，B，C，D，E，F，G，Hの左にある　○　をクリックすると　　　に変化し，それぞれのマクロを実行します。"]
[null,null,null,"設定シートの　Aの１～20に左にある　○　をクリックすると　　　に変化し，各人の時間計算のシートへ移動します。"]
[null,2]
[null,null,"・","Enterキーで右へ移動します。連続して右に入力するときに使用します。"]
[null,3]
[null,null,"・","Enterキーで下へ移動します。連続して下に入力するときに使用します。"]
[null,4]
[null,null,"・","各シートで計算用に使用している列を表示します。計算式等が壊れてしまった場合にこの処理を実行し，システム部分を表示させ計算式を修正します。システム部分を隠しておかないと壊される危険性が高いので，通常はシステム部分は隠しておきます。"]
[null,5]
[null,null,"・","上記　4　で表示したシステム部分を隠します。通常は隠しておきます。"]
[null,6]
[null,null,"・","シート名を設定シートに入力した“年月””氏名”に変更します。"]
[null,7]
[null,null,"・","シート名をNo1～No２０に戻します。"]
[null,8]
[null,null,"・","設定　シートへ戻ります。"]
[null,9]
[null,null,"・","№1～№20にシートの左上にあるマクロボタンです。\nこのボタンを押すと，設定　シートへ戻ります。"]
[null,10]
[null,null,"・","№1～№20にシートだけ初期化（消去）するマクロボタンです。\n一度だけ確認しますが，慎重に選択して下さい。"]
[null,11]
[null,null,"・","次のページに移動します。"]
[null,11]
[null,null,"・","前のページに移動します。"]
[]
[null,"            操作マニュアル"]
[null,1,"設定　シートでの各種入力"]
[null,null,1,"D列，I列に従業員の氏名を入力します。"]
[null,null,2,"E列，J列に各人の所定内労働時間を入力します。"]
[null,null,3,"E15に年を，F15に月を入力します。"]
[null,null,4,"Bの　○　をクリックすると　　　になって設定年月が№1～№20にセットされます。このマクロを実行させないと，以前の設定が生きてきます。以前の設定を生かす場合は，このマクロボタンを押す必要はありません。"]
[null,null,5,"Cの　○　をクリックすると　　　になって設定した20人分の氏名が№1～№20にセットされます。このマクロを実行させないと，以前の設定が生きてきます。以前の設定を生かす場合は，このマクロボタンを押す必要はありません。"]
[null,null,6,"Dの　○　をクリックすると　　　になって設定した20人分所定内労働時間が№1～№20にセットされます。このマクロを実行させないと，以前の設定が生きてきます。以前の設定を生かす場合は，このマクロボタンを押す必要はありません。"]
[null,null,7,"Eの　〇　→　　　年月，氏名，所定内労働時間をまとめて設定する場合は，Eの　○　をクリックして　◎　にすると，３つの設定が一気に実行されます。"]
[null,null,8,"Fの　○　→　　　全シートのデータを初期化（消去）します。二度確認しますので，慎重に実行して下さい。"]
[null,null,9,"Gの　○　→　　　全シートのセルに格納されている計算式を保護して，計算式が壊されないようにします。"]
[null,null,10,"Hの　○　→　　　全シートの計算式の保護を解除します。セルに格納してある計算式は自由に変更できます。計算式を壊さないよう注意して下さい。"]
[null,2,"№1～№20での入力"]
[null,null,1,"設定シートでの設定をセットすると，年月日，曜日が自動表示されています。"]
[null,null,2,"C列に開始時間を入力します。9時であれば　9　と入力します。"]
[null,null,3,"D列に開始分を入力します。10分であれば　10　と入力します。"]
[null,null,4,"E列に終了時間を入力します。17時であれば　17　と入力します。"]
[null,null,5,"F列に終了分を入力します。30分であれば　30　と入力します。"]
[null,null,6,"G列に休憩時間を分単位で入力します。60以上でも入力できるように設定してあります。"]
[null,null,7,"開始時間より前に終了時間は入力できません。"]
[null,null,8,"開始時間は24以上は入力できません。"]
[null,null,9,"開始分，終了分は60以上は入力できません。"]
[null,null,10,"Hに定時の時間が表示されます。"]
[null,null,11,"Iに残業時間が表示されます。"]
[null,null,12,"Jに合計就労時間が表示されます。"]
[null,null,13,"36行に１ヶ月の就労時間が計算されています。"]
[null,99,"注意事項   上書き保存  →  Ctrl＋Ｓ  をマメに実行してください。"]
[null,null,null,"不正な処理をしたわけではないのに，「不正な処理をしました」と表示されることが度々あります。この表示がでた瞬間に今までのデータは消えていると思って差し支えありません。 いつ何時このような状態になるとも限りません。マメに上書き保存をしてください。"]

{"sheet":"設定","index":1,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["タイムカード時間集計表"]
[null,{"$f":"\"A\"","v":"A"},{"$f":"\"各シートへの移動\"","v":"各シートへの移動"}]
[null,null,null,{"$f":"\"氏  名\"","v":"氏  名"},{"$f":"\"所定内労働時間\"","v":"所定内労働時間"},null,null,null,null,{"$f":"E3","v":"所定内労働時間"}]
[null,1,null,"西野光則",8,null,{"$f":"B13+1","v":11},null,"浜本 睦雄",8]
[null,{"$f":"B4+1","v":2},null,"朝場 睦雄",8,null,{"$f":"G4+1","v":12},null,"臼山 国彦",9]
[null,3,null,"始沢 清",8,null,13,null,"高桑 武俊",8]
[null,4,null,"岡部 隆徳",8,null,14,null,"松海 昭彦",9]
[null,5,null,"内藤 紀子",8,null,15,null,"神林 久喜",9]
[null,6,null,"児玉 昭夫",9,null,16,null,"黒柳 修一",9]
[null,7,null,"花石 さとみ",9,null,17,null,"野山 仁",8]
[null,8,null,"山岸 正彦",9,null,18,null,"花理 恒雄",9]
[null,9,null,"原山 武夫",9,null,19,null,"堤　 哲三",9]
[null,10,null,"鳥居 隆静",10,null,20,null,"池亀 守",9]
[]
[null,{"$f":"\"B\"","v":"B"},null,{"$f":"\"年月のセット\"","v":"年月のセット"},17,8]
[null,{"$f":"\"C\"","v":"C"},null,{"$f":"\"氏名のセット\"","v":"氏名のセット"}]
[null,{"$f":"\"D\"","v":"D"},null,{"$f":"\"所定内労働時間のセット\"","v":"所定内労働時間のセット"}]
[null,{"$f":"\"E\"","v":"E"},null,{"$f":"\"年月，氏名，所定内労働時間のセット\"","v":"年月，氏名，所定内労働時間のセット"}]
[null,{"$f":"\"F\"","v":"F"},null,{"$f":"\"初期化（全データを消去します）\"","v":"初期化（全データを消去します）"}]
[null,{"$f":"\"G\"","v":"G"},null,{"$f":"\"全シートの計算式を保護します\"","v":"全シートの計算式を保護します"}]
[null,{"$f":"\"H\"","v":"H"},null,{"$f":"\"全シートの計算式保護を解除します\"","v":"全シートの計算式保護を解除します"}]

{"sheet":"№1","index":2,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!D4","v":"西野光則"},{"$f":"設定!E4","v":8}]
[null,null,"西野光則",null,null,null,null,null,8,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 西野光則"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},7,0,19,33,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":"8 時間 0 分"},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":"4 時間 33 分"},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":"12 時間 33 分"},{"$f":"TIME(C5,D5,0)","v":"07:00:00"},{"$f":"TIME(E5,F5,0)","v":"19:33:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":753},{"$f":"ROUNDDOWN(M5/60,0)","v":12},{"$f":"ROUND(M5-(N5*60),0)","v":33}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":8},{"$f":"IF(S5=$I$3,N5-S5,0)","v":4},{"$f":"IF(S5=8,O5,0)","v":33},{"$f":"T5*60+U5","v":273}]
[{"$f":"A5+1","v":"2005-08-02"},{"$f":"WEEKDAY(A6)","v":3},8,0,15,0,null,{"$f":"IF(OR($C6=\"\",$D6=\"\",$E6=\"\",$F6=\"\"),\"\",IF(S6<$I$3,N6&$P$5&O6&$Q$5,S6&$P$5&$Q$6&$Q$5))","v":"7 時間 0 分"},{"$f":"IF(OR($C6=\"\",$D6=\"\",$E6=\"\",$F6=\"\"),\"\",IF(S6<$I$3,$P$6&$P$5&$Q$6&$Q$5,T6&$P$5&O6&$Q$5))","v":"0 時間 0 分"},{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":"7 時間 0 分"},"08:00:00","15:00:00",420,{"$f":"ROUNDDOWN(M6/60,0)","v":7},{"$f":"ROUND(M6-(N6*60),0)","v":0},0,0,"00:00:00",{"$f":"IF(N6>=$I$3,$I$3,0)","v":0},{"$f":"IF(S6=$I$3,N6-S6,0)","v":0},{"$f":"IF(S6=8,O6,0)","v":0},{"$f":"T6*60+U6","v":0}]
[{"$f":"A6+1","v":"2005-08-03"},4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"",{"$f":"IF(OR($C12=\"\",$D12=\"\",$E12=\"\",$F12=\"\"),\"\",IF(S12<$I$3,$P$6&$P$5&$Q$6&$Q$5,T12&$P$5&O12&$Q$5))","v":""},"","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"15 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"4 時間 33 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"19 時間 33 分"},null,null,{"$f":"SUM(M5:M35)","v":1173},{"$f":"ROUNDDOWN(M36/60,0)","v":19},{"$f":"ROUND(M36-(N36*60),0)","v":33},null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":273},{"$f":"ROUNDDOWN(V36/60,0)","v":4},{"$f":"ROUND(V36-(W36*60),0)","v":33}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":900},{"$f":"ROUNDDOWN(V37/60,0)","v":15},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№2","index":3,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!D5","v":"朝場 睦雄"},{"$f":"設定!E5","v":8}]
[null,null,"朝場 睦雄",null,null,null,null,null,8,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 朝場 睦雄"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,30,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:30:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№3","index":4,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!D6","v":"始沢 清"},{"$f":"設定!E6","v":8}]
[null,null,"始沢 清",null,null,null,null,null,8,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 始沢 清"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,45,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:45:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№4","index":5,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!D7","v":"岡部 隆徳"},{"$f":"設定!E7","v":8}]
[null,null,"岡部 隆徳",null,null,null,null,null,8,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 岡部 隆徳"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№5","index":6,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!D8","v":"内藤 紀子"},{"$f":"設定!E8","v":8}]
[null,null,"内藤 紀子",null,null,null,null,null,8,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 内藤 紀子"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№6","index":7,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!D9","v":"児玉 昭夫"},{"$f":"設定!E9","v":9}]
[null,null,"児玉 昭夫",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 児玉 昭夫"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№7","index":8,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!D10","v":"花石 さとみ"},{"$f":"設定!E10","v":9}]
[null,null,"花石 さとみ",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 花石 さとみ"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№8","index":9,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!D11","v":"山岸 正彦"},{"$f":"設定!E11","v":9}]
[null,null,"山岸 正彦",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 山岸 正彦"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№9","index":10,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!D12","v":"原山 武夫"},{"$f":"設定!E12","v":9}]
[null,null,"原山 武夫",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 原山 武夫"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№10","index":11,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!D13","v":"鳥居 隆静"},{"$f":"設定!E13","v":10}]
[null,null,"鳥居 隆静",null,null,null,null,null,10,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 鳥居 隆静"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№11","index":12,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!I4","v":"浜本 睦雄"},{"$f":"設定!J4","v":8}]
[null,null,"浜本 睦雄",null,null,null,null,null,8,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 浜本 睦雄"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№12","index":13,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!I5","v":"臼山 国彦"},{"$f":"設定!J5","v":9}]
[null,null,"臼山 国彦",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 臼山 国彦"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№13","index":14,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!I6","v":"高桑 武俊"},{"$f":"設定!J6","v":8}]
[null,null,"高桑 武俊",null,null,null,null,null,8,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 高桑 武俊"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№14","index":15,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!I7","v":"松海 昭彦"},{"$f":"設定!J7","v":9}]
[null,null,"松海 昭彦",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 松海 昭彦"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№15","index":16,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!I8","v":"神林 久喜"},{"$f":"設定!J8","v":9}]
[null,null,"神林 久喜",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 神林 久喜"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№16","index":17,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!I9","v":"黒柳 修一"},{"$f":"設定!J9","v":9}]
[null,null,"黒柳 修一",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 黒柳 修一"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№17","index":18,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!I10","v":"野山 仁"},{"$f":"設定!J10","v":8}]
[null,null,"野山 仁",null,null,null,null,null,8,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 野山 仁"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№18","index":19,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!I11","v":"花理 恒雄"},{"$f":"設定!J11","v":9}]
[null,null,"花理 恒雄",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 花理 恒雄"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№19","index":20,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!I12","v":"堤　 哲三"},{"$f":"設定!J12","v":9}]
[null,null,"堤　 哲三",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 堤　 哲三"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"№20","index":21,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[2005,8,null,null,null,null,null,null,null,null,null,{"$f":"設定!$E$15+1988","v":2005},{"$f":"設定!$F$15","v":8},{"$f":"L1-1988","v":17}]
[{"$f":"A5","v":"2005-08-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"設定!I13","v":"池亀 守"},{"$f":"設定!J13","v":9}]
[null,null,"池亀 守",null,null,null,null,null,9,null,null,{"$f":"IF(ISERROR(\"平成\"&N1&\"年\"&M1&\"月 \"&L2),L2,\"平成\"&N1&\"年\"&M1&\"月 \"&L2)","v":"平成17年8月 池亀 守"}]
[{"$f":"\"月日\"","v":"月日"},{"$f":"\"曜日\"","v":"曜日"},{"$f":"\"開始\"","v":"開始"},null,{"$f":"\"   終了\"","v":"   終了"},null,{"$f":"\"休憩\"","v":"休憩"},{"$f":"\"定時\"","v":"定時"},{"$f":"\"残業\"","v":"残業"},{"$f":"\"就業時間\"","v":"就業時間"},null,null,null,null,null,null,null,null,null,"残業時","残業分","残業分換算"]
[{"$f":"DATE(A1,B1,1)","v":"2005-08-01"},{"$f":"WEEKDAY(A5)","v":2},null,null,null,null,null,{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,N5&$P$5&O5&$Q$5,S5&$P$5&$Q$6&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",IF(S5<$I$3,$P$6&$P$5&$Q$6&$Q$5,T5&$P$5&O5&$Q$5))","v":""},{"$f":"IF(OR($C5=\"\",$D5=\"\",$E5=\"\",$F5=\"\"),\"\",N5&$P$5&O5&$Q$5)","v":""},{"$f":"TIME(C5,D5,0)","v":"00:00:00"},{"$f":"TIME(E5,F5,0)","v":"00:00:00"},{"$f":"IF(OR(C5=\"\",D5=\"\",E5=\"\",F5=\"\"),0,(L5-K5-R5)*24*60)","v":0},{"$f":"ROUNDDOWN(M5/60,0)","v":0},{"$f":"ROUND(M5-(N5*60),0)","v":0}," 時間 "," 分",{"$f":"TIME(0,G5,0)","v":"00:00:00"},{"$f":"IF(N5>=$I$3,$I$3,0)","v":0},{"$f":"IF(S5=$I$3,N5-S5,0)","v":0},{"$f":"IF(S5=8,O5,0)","v":0},{"$f":"T5*60+U5","v":0}]
[{"$f":"A5+1","v":"2005-08-02"},3,null,null,null,null,null,"","",{"$f":"IF(OR(C6=\"\",D6=\"\",E6=\"\",F6=\"\"),\"\",N6&$P$5&O6&$Q$5)","v":""},"00:00:00","00:00:00",0,0,0,0,0,"00:00:00",0,0,0,0]
["2005-08-03",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-04",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-05",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-06",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-07",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-08",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-09",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-10",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-11",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-12",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-13",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-14",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-15",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-16",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-17",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-18",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-19",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-20",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-21",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-22",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-23",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-24",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-25",5,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-26",6,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-27",7,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-28",1,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-29",2,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-30",3,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
["2005-08-31",4,null,null,null,null,null,"","","","00:00:00","00:00:00",0,0,0,null,null,"00:00:00",0,0,0,0]
[{"$f":"\"合計\"","v":"合計"},null,null,null,null,null,null,{"$f":"W37&$P$5&X37&$Q$5","v":"0 時間 0 分"},{"$f":"W36&$P$5&X36&$Q$5","v":"0 時間 0 分"},{"$f":"N36&$P$5&O36&$Q$5","v":"0 時間 0 分"},null,null,{"$f":"SUM(M5:M35)","v":0},0,0,null,null,"00:00:00",null,null,null,{"$f":"SUM(V5:V35)","v":0},{"$f":"ROUNDDOWN(V36/60,0)","v":0},{"$f":"ROUND(V36-(W36*60),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M36-V36","v":0},{"$f":"ROUNDDOWN(V37/60,0)","v":0},{"$f":"ROUND(V37-(W37*60),0)","v":0}]

{"sheet":"Sheet1","index":22,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}