{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["説明","４月"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"説明","index":0,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,"１．シート「４月」の１～９行目に必要事項記載してください。"]
[null,"　　セルＥ１（Ｒ１Ｃ５）、Ｈ８（Ｒ８Ｃ８）はプルダウンです。"]
[null,"　　セルＡ１（Ｒ１Ｃ１）西暦で記載してください。"]
[null,"２．このシートに戻って、下記の必要とするボタンを押してください。"]
[null,"　　※ボタンを押すと、この「説明」シートは削除されます。"]
[null,"　　　 必要に応じて、実行する前に保存等をお願いします。"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"週単位の週報を１年分作成"]
[]
[]
[]
[]
[]
[null,"３．週報化後、独自の休日を設定する場合は、「除外する時間数」欄をダブルクリックしてください。"]

{"sheet":"４月","index":1,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,0,1,5],[1,7,1,9],[20,8,20,10],[21,8,21,10],[6,0,6,2],[7,0,7,2],[13,8,13,10],[14,8,14,10],[8,3,8,6],[11,8,11,10],[12,8,12,10],[9,8,10,10],[19,8,19,10],[18,8,18,10],[31,8,31,10],[26,8,26,10],[38,8,38,10],[32,8,32,10],[33,8,33,10],[29,8,29,10],[34,8,34,10],[28,8,28,10],[36,8,36,10],[30,8,30,10],[0,0,0,3],[0,4,0,6],[9,0,10,0],[9,1,10,1],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[6,3,6,10],[9,7,10,7],[2,3,2,10],[3,3,3,10],[4,3,4,10],[5,3,5,10],[7,9,7,10],[7,3,7,6],[46,1,46,2],[46,3,46,4],[35,8,35,10],[48,0,49,10],[42,8,42,9],[37,8,37,10],[40,8,40,10],[41,8,41,10],[46,6,46,7],[45,2,45,3],[45,8,45,10],[44,0,44,10],[39,8,39,10],[42,0,42,6],[22,8,22,10],[23,8,23,10],[24,8,24,10],[27,8,27,10],[9,2,9,5],[9,6,10,6],[25,8,25,10],[15,8,15,10],[16,8,16,10],[17,8,17,10]]}
["2020年4月分",null,null,null,"委託業務従事日誌",null,null,null,{"$f":"IF($E$1=\"委託業務従事日誌\",\"契約管理番号：\",\"事業番号：\")","v":"契約管理番号："},"□□□□□□□□－□",{"$f":"IF($E$1=\"委託業務従事日誌\",\"別紙８\",\"\")","v":"別紙８"}]
["※下記業務以外のＮＥＤＯ業務従事：",null,null,null,null,null,"なし","※NEDO以外の公的資金に係る業務への従事：",null,null,"なし"]
[{"$f":"IF($E$1=\"委託業務従事日誌\",\"件名：\",\"助成事業の名称：\")","v":"件名："}]
[]
[]
[{"$f":"IF($E$1=\"委託業務従事日誌\",\"再委託等項目：\",\"委託・共同研究項目：\")","v":"再委託等項目："},null,null," "]
[{"$f":"IF($E$1=\"委託業務従事日誌\",\"委託先等名称：\",\"助成事業者名称：\")","v":"委託先等名称："}]
["従事者　所属：",null,null,null,null,null,null,"通常勤務",{"$f":"IF($E$1=\"委託業務従事日誌\",\"業務管理者\",\"主任研究者\")&\"　所属：\"","v":"業務管理者　所属："}]
[null,null,"氏名：",null,null,null,null,"印","氏名：",null,"印"]
["日","曜日","従事時間帯(２４時間制で時刻入力)",null,null,null,"除外する時間数","従事した時間数","具体的な研究内容、作業内容\n※独自の休日を設定する場合は「休日」と入力"]
[null,null,"開始時刻","終了時刻","開始時刻","終了時刻"]
[{"$f":"DATEVALUE(TEXT(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($A$1,\"元\",\"１\"),\"分\",\"\"),\"度\",\"\")&\"１日\",\"yyyy/mm/d\"))","v":"2020-04-01"},{"$f":"IF(ISERROR(TEXT(WEEKDAY($A12,1),\"aaa\"))=TRUE,\"\",PublicHoliday.PublicHoliday($A12))","v":"水"},null,null,null,null,null,{"$f":"IF((D12-C12)+(F12-E12)-G12=0,\"\",(D12-C12)+(F12-E12)-G12)","v":""}]
[{"$f":"A12+1","v":"2020-04-02"},{"$f":"IF(ISERROR(TEXT(WEEKDAY($A13,1),\"aaa\"))=TRUE,\"\",PublicHoliday.PublicHoliday($A13))","v":"木"},null,null,null,null,null,{"$f":"IF((D13-C13)+(F13-E13)-G13=0,\"\",(D13-C13)+(F13-E13)-G13)","v":""}]
["2020-04-03","金",null,null,null,null,null,{"$f":"IF((D14-C14)+(F14-E14)-G14=0,\"\",(D14-C14)+(F14-E14)-G14)","v":""}]
["2020-04-04","土",null,null,null,null,null,""]
["2020-04-05","日",null,null,null,null,null,""]
["2020-04-06","月",null,null,null,null,null,""]
["2020-04-07","火",null,null,null,null,null,""]
["2020-04-08","水",null,null,null,null,null,""]
["2020-04-09","木",null,null,null,null,null,""]
["2020-04-10","金",null,null,null,null,null,""]
["2020-04-11","土",null,null,null,null,null,""]
["2020-04-12",{"$f":"IF(ISERROR(TEXT(WEEKDAY($A23,1),\"aaa\"))=TRUE,\"\",PublicHoliday.PublicHoliday($A23))","v":"日"},null,null,null,null,null,""]
["2020-04-13","月",null,null,null,null,null,""]
["2020-04-14","火",null,null,null,null,null,""]
["2020-04-15","水",null,null,null,null,null,""]
["2020-04-16","木",null,null,null,null,null,""]
["2020-04-17","金",null,null,null,null,null,""]
["2020-04-18","土",null,null,null,null,null,""]
["2020-04-19","日",null,null,null,null,null,""]
["2020-04-20","月",null,null,null,null,null,""]
["2020-04-21","火",null,null,null,null,null,""]
["2020-04-22","水",null,null,null,null,null,""]
["2020-04-23","木",null,null,null,null,null,""]
["2020-04-24","金",null,null,null,null,null,""]
["2020-04-25","土",null,null,null,null,null,""]
["2020-04-26","日",null,null,null,null,null,""]
[{"$f":"A37+1","v":"2020-04-27"},"月",null,null,null,null,null,""]
[{"$f":"A38+1","v":"2020-04-28"},"火",null,null,null,null,null,""]
[{"$f":"IF(DAY(A39+1)<4,\"\",A39+1)","v":"2020-04-29"},"祝",null,null,null,null,null,""]
[{"$f":"IF(DAY(A39+2)<4,\"\",A39+2)","v":"2020-04-30"},"木",null,null,null,null,null,""]
[{"$f":"IF(DAY(A39+3)<4,\"\",A39+3)","v":""},"",null,null,null,null,null,""]
["合計",null,null,null,null,null,null,{"$f":"SUM(H12:H42)","v":0},"数値表示に変換した右の時間数を労務費積算書に記入",null,{"$f":"ROUNDDOWN(ROUND(H43*24*60,1)/60,2)","v":0}]
[]
["ＮＥＤＯ確認欄"]
[]
[null,"確認日",null,null,null,"所属",null,null,"氏名"]
[]
["＊事業者としてコンプライアンス（法令遵守）プログラム等を有する場合にはその責任者が、有しない場合には役員等コンプライアンスに関し責任を有する者が、併せて従事内容の確認を行ってください。\n＊具体的な研究内容・作業内容について作成頂いた研究者本人にヒアリングさせて頂くことがあります。"]