{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Template","テンプレート作成","工数管理 (全試験合計)"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":73,"n_cols":6,"rows_kept":73,"cut":false,"hidden":true,"merged":[[36,11,36,12]]}
[]
[null,null,null,"試験名"]
[null,null,null,"試験期間（開始月）"]
[null,null,null,"組入れ開始月"]
[null,null,null,"試験期間（終了月）"]
[null,null,null,"例数"]
[]
["【入力欄】ひと月あたりの来院数"]
[null,null,"No.","基準計画用"]
[null,null,1]
[]
[null,null,null,"基準計画Total",{"$f":"SUM(E10:E11)","v":0},{"$f":"SUM(F10:F11)","v":0}]
[null,null,null,"必要工数（計画時）",{"$f":"E12/$E$48","v":0},{"$f":"F12/$E$48","v":0}]
[]
[null,"脱落","No.","実績更新用",{"$f":"IF(E9<>\"\",E9,\"\")","v":""},{"$f":"IF(F9<>\"\",F9,\"\")","v":""}]
[null,null,1]
[]
[null,null,null,"実績更新Total",{"$f":"SUM(E16:E17)","v":0},{"$f":"SUM(F16:F17)","v":0}]
[null,null,null,"必要工数（実績込）",{"$f":"E18/$E$48","v":0},{"$f":"F18/$E$48","v":0}]
[null,"↓あとで非表示"]
[null,null,"No.","基準計画用",{"$f":"IF(E9<>\"\",E9,\"\")","v":""},{"$f":"IF(F9<>\"\",F9,\"\")","v":""}]
[null,null,1,null,{"$f":"IF(E10<>\"\",1,\"\")","v":""},{"$f":"IF(F10<>\"\",1,IF(COUNT($E10:F10)<>0,1,\"\"))","v":""}]
[null,null,null,null,{"$f":"IF(E11<>\"\",1,\"\")","v":""},{"$f":"IF(F11<>\"\",1,IF(COUNT($E11:F11)<>0,1,\"\"))","v":""}]
[null,"↓あとで非表示"]
[null,null,"No.","実績更新用",{"$f":"IF(E9<>\"\",E9,\"\")","v":""},{"$f":"IF(F9<>\"\",F9,\"\")","v":""}]
[null,null,1,null,{"$f":"IF($B16=\"○\",\"\",IF(E16<>\"\",1,\"\"))","v":""},{"$f":"IF($B16=\"○\",\"\",IF(F16<>\"\",1,IF(COUNT($E16:F16)<>0,1,\"\")))","v":""}]
[null,null,null,null,{"$f":"IF($B17=\"○\",\"\",IF(E17<>\"\",1,\"\"))","v":""},{"$f":"IF($B17=\"○\",\"\",IF(F17<>\"\",1,IF(COUNT($E17:F17)<>0,1,\"\")))","v":""}]
[]
[null,null,null,"症例登録状況",{"$f":"IF(E9<>\"\",E9,\"\")","v":""},{"$f":"IF(F9<>\"\",F9,\"\")","v":""}]
[null,null,null,"目標被験者数",{"$f":"SUM(E22:E23)","v":0},{"$f":"SUM(F22:F23)","v":0}]
[null,null,null,"登録被験者数（赤：目標例数を超過）",{"$f":"SUM(E26:E27)","v":0},{"$f":"SUM(F26:F27)","v":0}]
[]
[null,null,null,"マイルストン"]
[null,null,null,"初回IRB月","2013-08-01"]
[null,null,null,"組入れ開始月",{"$f":"E4","v":"00:00:00"}]
[null,null,null,"被験者最終来院月","2014-04-24"]
[]
[null,null,null,"期間"]
[null,null,null,"手続き期間（ヶ月）",3]
[null,null,null,"カルテスクリーニング期間（ヶ月）",1]
[null,null,null,"組入れ可能期間（ヶ月）",4]
[null,null,null,"被験者対応期間（ヶ月）","マイルストンより概算"]
[null,null,null,"終了期間(治験薬、必須文書SDV等)（ヶ月）",1]
[]
[null,null,null,"パラメーター"]
[null,null,null,"来院回数(回/月）",2]
[null,null,null,"脱落率（％）",0.1]
[null,null,null,"ひと月あたり1CRCが対応できる来院数（回）",12]
[null,null,null,"治験難易度（高：1.2倍・中：1倍、低：0.9倍）",1.2]
[null,null,null,"CRC経験値（高：0.9倍、中：１倍、低：1.1倍）",1]
[]
[null,null,null,"基準工数","CRC基準工数","事務局基準工数"]
[null,null,null,"手続き期間（ヶ月）",0.2,0.2]
[null,null,null,"組入れ可能期間",0.3,"-"]
[null,null,null,"被験者対応期間（ヶ月）","来院数より概算",0.1]
[null,null,null,"終了期間(治験薬、必須文書SDV等)（ヶ月）",0.1,0.1]
[]
[null,null,"↓あとで非表示"]
[null,null,null,"工数"]
[null,null,null,"CRC被験者に紐づく工数",{"$f":"IF(ISERROR(HLOOKUP(E$59,15:19,$C$19+1,0)),\"\",HLOOKUP(E$59,15:19,$C$19+1,0))","v":""},{"$f":"IF(ISERROR(HLOOKUP(F$59,15:19,$C$19+1,0)),\"\",HLOOKUP(F$59,15:19,$C$19+1,0))","v":""}]
[null,null,null,"CRC被験者外工数（手続き）",{"$f":"IF(AND(E$59>EDATE($E$34,-$E$39),E$59<=$E$34),$E$53,\"\")","v":""},{"$f":"IF(AND(F$59>EDATE($E$34,-$E$39),F$59<=$E$34),$E$53,\"\")","v":""}]
[null,null,null,"CRC被験者外工数（スクリーニング）",{"$f":"IF($E$40=\"\",\"\",IF(AND(E$59>=EDATE($E$35,-$E$40),E$59<$E$35),$E$54/(1-$E$47)/2/$E$40,\"\"))","v":{"$error":"#NUM!"}},{"$f":"IF($E$40=\"\",\"\",IF(AND(F$59>=EDATE($E$35,-$E$40),F$59<$E$35),$E$54/(1-$E$47)/2/$E$40,\"\"))","v":{"$error":"#NUM!"}}]
[null,null,null,"CRC被験者外工数（組み入れ期間）",{"$f":"IF($E$40=\"\",IF(AND(E$59>=$E$35,E$59<EDATE($E$35,$E$41)),$E$54/(1-$E$47)/$E$41,\"\"),IF(AND(E$59>=$E$35,E$59<EDATE($E$35,$E$41)),$E$54/(1-$E$47)/2/$E$41,\"\"))","v":4.1666666666666664E-2},{"$f":"IF($E$40=\"\",IF(AND(F$59>=$E$35,F$59<EDATE($E$35,$E$41)),$E$54/(1-$E$47)/$E$41,\"\"),IF(AND(F$59>=$E$35,F$59<EDATE($E$35,$E$41)),$E$54/(1-$E$47)/2/$E$41,\"\"))","v":4.1666666666666664E-2}]
[null,null,null,"CRC被験者外工数（終了期間）",{"$f":"IF(E$59>$E$36,$E$56,\"\")","v":""},{"$f":"IF(F$59>$E$36,$E$56,\"\")","v":""}]
[null,null,null,"CRC工数",{"$f":"SUM(E60:E64)","v":{"$error":"#NUM!"}},{"$f":"SUM(F60:F64)","v":{"$error":"#NUM!"}}]
[null,null,null,"事務局工数（手続き）",{"$f":"IF(AND(E$59>EDATE($E$34,-$E$39),E$59<=$E$34),$F$53,\"\")","v":""},{"$f":"IF(AND(F$59>EDATE($E$34,-$E$39),F$59<=$E$34),$F$53,\"\")","v":""}]
[null,null,null,"事務局工数（組み入れ期間）",{"$f":"IF(AND(E$59>=EDATE($E$34,1),E$59<$E$36),$F$55,\"\")","v":""},{"$f":"IF(AND(F$59>=EDATE($E$34,1),F$59<$E$36),$F$55,\"\")","v":""}]
[null,null,null,"事務局工数（終了期間）",{"$f":"IF(E$59>$E$36,$F$56,\"\")","v":""},{"$f":"IF(F59>$E$36,$F$56,\"\")","v":""}]
[null,null,null,"CRC工数（補正後）",{"$f":"E$65*$E$49*$E$50","v":{"$error":"#NUM!"}},{"$f":"F$65*$E$49*$E$50","v":{"$error":"#NUM!"}}]
[null,null,null,"事務局工数合計",{"$f":"SUM(E66:E68)","v":0},{"$f":"SUM(F66:F68)","v":0}]
[null,null,null,"合計",{"$f":"SUM(E69:E69)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"}]
[]
[null,null,null,"【出力グラフ】"]

{"sheet":"テンプレート作成","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"工数管理 (全試験合計)","index":2,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":false,"merged":[[4,9,4,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"工数"]
[null,"CRC工数合計（補正後）"]
[null,"事務局工数合計"]
[null,"CRC工数（全試験合計）"]
[null,"事務局工数（全試験合計）"]