{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["青県中書式25（経費算出基準）"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":4,"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":"青県中書式25（経費算出基準）","index":0,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,8,58,9],[58,10,58,11],[58,14,58,15],[58,16,58,17],[54,0,54,2],[54,4,54,5],[54,6,54,7],[54,8,54,11],[54,12,54,13],[54,14,54,17],[56,8,56,9],[56,10,56,11],[56,14,56,15],[56,16,56,17],[57,8,57,9],[57,10,57,11],[57,14,57,15],[57,16,57,17],[55,8,55,9],[55,10,55,11],[55,14,55,15],[55,16,55,17],[34,8,34,9],[34,10,34,11],[34,14,34,15],[34,16,34,17],[35,8,35,9],[1,0,1,5],[2,0,2,1],[2,4,2,5],[2,6,2,7],[2,8,2,11],[2,12,2,13],[35,10,35,11],[35,14,35,15],[35,16,35,17],[4,0,4,2],[4,4,4,5],[4,6,4,7],[4,8,4,11],[4,12,4,13],[4,14,4,17],[5,4,5,5],[3,4,3,5],[3,6,3,11],[5,6,5,7],[33,16,33,17],[2,14,2,17],[9,8,9,9],[9,10,9,11],[9,14,9,15],[9,16,9,17],[10,8,10,9],[10,10,10,11],[10,14,10,15],[10,16,10,17],[7,8,7,9],[7,10,7,11],[7,14,7,15],[7,16,7,17],[8,8,8,9],[8,10,8,11],[8,14,8,15],[8,16,8,17],[3,12,3,15],[3,16,3,17],[15,8,15,9],[15,10,15,11],[15,14,15,15],[15,16,15,17],[16,8,16,9],[16,10,16,11],[16,14,16,15],[16,16,16,17],[5,8,5,11],[5,12,5,13],[5,14,5,17],[6,8,6,9],[6,10,6,11],[6,14,6,15],[6,16,6,17],[12,0,12,2],[13,8,13,9],[13,10,13,11],[13,14,13,15],[13,16,13,17],[14,1,14,2],[19,8,19,9],[19,10,19,11],[19,14,19,15],[19,16,19,17],[20,8,20,9],[20,10,20,11],[20,14,20,15],[20,16,20,17],[17,8,17,9],[17,10,17,11],[17,14,17,15],[17,16,17,17],[18,8,18,9],[18,10,18,11],[18,14,18,15],[18,16,18,17],[21,10,21,11],[21,16,21,17],[22,10,22,11],[22,16,22,17],[23,0,23,2],[23,10,23,11],[23,16,23,17],[26,8,26,9],[26,10,26,11],[26,14,26,15],[26,16,26,17],[27,8,27,9],[27,10,27,11],[27,14,27,15],[27,16,27,17],[24,8,24,9],[24,10,24,11],[24,14,24,15],[24,16,24,17],[25,8,25,9],[25,10,25,11],[25,14,25,15],[25,16,25,17],[28,8,28,9],[28,10,28,11],[28,14,28,15],[28,16,28,17],[37,0,37,1],[37,4,37,5],[37,6,37,7],[37,8,37,11],[37,12,37,13],[37,14,37,17],[32,8,32,9],[32,10,32,11],[32,14,32,15],[32,16,32,17],[33,8,33,9],[33,10,33,11],[33,14,33,15],[30,0,30,2],[30,10,30,11],[30,16,30,17],[31,8,31,9],[31,10,31,11],[31,14,31,15],[31,16,31,17],[41,8,41,9],[41,10,41,11],[41,14,41,15],[41,16,41,17],[42,8,42,9],[42,10,42,11],[42,14,42,15],[42,16,42,17],[38,0,40,0],[38,1,40,2],[38,3,40,3],[38,4,38,17],[39,4,40,5],[39,6,40,7],[39,8,39,17],[40,8,40,11],[40,12,40,13],[40,14,40,17],[43,8,43,9],[43,10,43,11],[43,14,43,15],[43,16,43,17],[44,8,44,9],[44,10,44,11],[44,14,44,15],[44,16,44,17],[49,0,49,2],[49,4,49,5],[49,6,49,7],[49,8,49,11],[49,12,49,13],[49,14,49,17],[45,8,45,9],[45,10,45,11],[45,14,45,15],[45,16,45,17],[46,8,46,9],[46,10,46,11],[46,14,46,15],[46,16,46,17],[47,8,47,9],[48,8,48,9],[47,10,47,11],[48,10,48,11],[47,14,47,15],[47,16,47,17],[48,14,48,15],[48,16,48,17],[51,14,51,15],[51,16,51,17],[52,8,52,9],[52,10,52,11],[52,14,52,15],[52,16,52,17],[53,8,53,9],[53,10,53,11],[53,14,53,15],[53,16,53,17],[50,8,50,9],[50,10,50,11],[50,14,50,15],[50,16,50,17],[51,8,51,9],[51,10,51,11]]}
[]
["青県中治験書式２５"]
["経費算出基準",null,null,null,"Ａ",null,"Ｂ",null,"Ａ",null,null,null,"Ｂ",null,"Ｃ"]
[null,null,null,"締結日","～2013/9/30",null,"2019/4/1～2019/9/30",null,null,null,null,null,"2019/4/1～2019/9/30",null,null,null,"2019/10/1～"]
["１　試験の種類・各種ポイントについて",null,null,"請求日","いつでも",null,"2013/10/1～2014/3/31",null,"2019/10/1～",null,null,null,"2019/4/1～2019/9/30",null,"2019/10/1～"]
["（１）","試験の種類",null,null,"治験",null,"治験",null,"治験",null,null,null,"治験",null,"治験"]
["（２）","臨床試験研究費ポイント合計","青県中書式２２より算出",null,null,"ポイント",null,"ポイント",null,null,"ポイント",null,null,"ポイント",null,null,"ポイント"]
["（３）","人件費ポイント合計","青県中書式２４より算出",null,null,"ポイント",null,"ポイント",null,null,"ポイント",null,null,"ポイント",null,null,"ポイント"]
["（４）","契約症例数",null,null,null,"例",null,"例",null,null,"例",null,null,"例",null,null,"例"]
["（","消費税率",null,null,5,"%）",5,"%）",10,null,"%）",null,8,"%）",10,null,"%）"]
["（","ドロップアウト費用倍率","1症例当たりの研究費に右倍率を掛ける（２－（５））",null,10,"%）",10,"%）",10,null,"%）",null,10,"%）",10,null,"%）"]
[]
["２　研究費について（症例単価）"]
["（１）","臨床試験研究経費","：臨床試験研究経費ポイント合計×ポイント単価※","＝",{"$f":"IF(E7=\"\",\"\",IF(E6=\"治験\",E7*6000,E7*4200))","v":""},{"$f":"IF(E$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(G7=\"\",\"\",IF(G6=\"治験\",G7*6000,G7*4200))","v":""},{"$f":"IF(G$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(I7=\"\",\"\",IF(I6=\"治験\",I7*6000,I7*4800))","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M7=\"\",\"\",IF(M6=\"治験\",M7*6000,M7*4800))","v":""},{"$f":"IF(M$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(O7=\"\",\"\",IF(O6=\"治験\",O7*6000,O7*4800))","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円\")","v":""}]
[null,"　※治験は６，０００円、製造販売後臨床試験は４，８００円で計算"]
["（２）","管理費","：(1)   ×　０．２（２０％）","＝",{"$f":"IF(E7=\"\",\"\",E14*0.2)","v":""},{"$f":"IF(E$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(G7=\"\",\"\",G14*0.2)","v":""},{"$f":"IF(G$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(I7=\"\",\"\",I14*0.2)","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M7=\"\",\"\",M14*0.2)","v":""},{"$f":"IF(M$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(O7=\"\",\"\",O14*0.2)","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円\")","v":""}]
["（３）","間接経費","：{(1)＋(2)}　×　０．３（３０％）","＝",{"$f":"IF(E7=\"\",\"\",(E14+E16)*0.3)","v":""},"",{"$f":"IF(G7=\"\",\"\",(G14+G16)*0.3)","v":""},{"$f":"IF(G$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(I7=\"\",\"\",(I14+I16)*0.3)","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M7=\"\",\"\",(M14+M16)*0.3)","v":""},{"$f":"IF(M$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(O7=\"\",\"\",(O14+O16)*0.3)","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円\")","v":""}]
["（４）","１症例当たりの研究費","：{(1)＋(2)＋(3)}　×　消費税率","＝",{"$f":"IF(E7=\"\",\"\",ROUND((E14+E16+E17)*(1+E10/100),0))","v":""},"",{"$f":"IF(G7=\"\",\"\",ROUND((G14+G16+G17)*(1+G10/100),0))","v":""},{"$f":"IF(G$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(I7=\"\",\"\",ROUND((I14+I16+I17)*(1+I10/100),0))","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M7=\"\",\"\",ROUND((M14+M16+M17)*(1+M10/100),0))","v":""},{"$f":"IF(M$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(O7=\"\",\"\",ROUND((O14+O16+O17)*(1+O10/100),0))","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"IF(E7=\"\",\"\",E18-SUM(E14,E16,E17))","v":""},"",{"$f":"IF(G7=\"\",\"\",G18-SUM(G14,G16,G17))","v":""},{"$f":"IF(G$7=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I7=\"\",\"\",I18-SUM(I14,I16,I17))","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円)\")","v":""},null,{"$f":"IF(M7=\"\",\"\",M18-SUM(M14,M16,M17))","v":""},{"$f":"IF(M$7=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O7=\"\",\"\",O18-SUM(O14,O16,O17))","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円)\")","v":""}]
["（５）","ドロップアウト費用","：{(1)＋(2)＋(3)}　×　ドロップアウト費用倍率　×　消費税率","＝",{"$f":"IF(E7=\"\",\"\",ROUND(ROUND(SUM(E14,E16,E17)*$E11/100,0)*(1+E10/100),0))","v":""},"",{"$f":"IF(G7=\"\",\"\",ROUND(ROUND(SUM(G14,G16,G17)*$G11/100,0)*(1+G10/100),0))","v":""},{"$f":"IF(G$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(I7=\"\",\"\",ROUND(ROUND(SUM(I14,I16,I17)*$I11/100,0)*(1+I10/100),0))","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M7=\"\",\"\",ROUND(ROUND(SUM(M14,M16,M17)*$M11/100,0)*(1+M10/100),0))","v":""},{"$f":"IF(M$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(O7=\"\",\"\",ROUND(ROUND(SUM(O14,O16,O17)*$O11/100,0)*(1+O10/100),0))","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"IF(E7=\"\",\"\",E20-ROUND(SUM(E14,E16,E17)*$E11/100,0))","v":""},"",{"$f":"IF(G7=\"\",\"\",G20-ROUND(SUM(G14,G16,G17)*$G11/100,0))","v":""},{"$f":"IF(G$7=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I7=\"\",\"\",I20-ROUND(SUM(I14,I16,I17)*$I11/100,0))","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円)\")","v":""},null,{"$f":"IF(M7=\"\",\"\",M20-ROUND(SUM(M14,M16,M17)*$M11/100,0))","v":""},{"$f":"IF(M$7=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O7=\"\",\"\",O20-ROUND(SUM(O14,O16,O17)*$O11/100,0))","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円)\")","v":""}]
[]
[]
["３　人件費について（症例単価）"]
["（１） ","ポイント算出経費","：人件費ポイント合計　×　ポイント単価（６，０００円）","＝",{"$f":"IF(E8=\"\",\"\",E8*6000)","v":""},{"$f":"IF(E$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(G8=\"\",\"\",G8*6000)","v":""},{"$f":"IF(G$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(I8=\"\",\"\",I8*6000)","v":""},null,{"$f":"IF(I$8=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M8=\"\",\"\",M8*6000)","v":""},{"$f":"IF(M$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(O8=\"\",\"\",O8*6000)","v":""},null,{"$f":"IF(O$8=\"\",\"\",\"円\")","v":""}]
["（２）","管理費","：(1)   ×　０．２（２０％）","＝",{"$f":"IF(E8=\"\",\"\",E25*0.2)","v":""},{"$f":"IF(E$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(G8=\"\",\"\",G25*0.2)","v":""},{"$f":"IF(G$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(I8=\"\",\"\",I25*0.2)","v":""},null,{"$f":"IF(I$8=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M8=\"\",\"\",M25*0.2)","v":""},{"$f":"IF(M$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(O8=\"\",\"\",O25*0.2)","v":""},null,{"$f":"IF(O$8=\"\",\"\",\"円\")","v":""}]
["（３）","間接経費","：{(1)＋(2)}　×　０．３（３０％）","＝",{"$f":"IF(E8=\"\",\"\",(E25+E26)*0.3)","v":""},{"$f":"IF(E$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(G8=\"\",\"\",(G25+G26)*0.3)","v":""},{"$f":"IF(G$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(I8=\"\",\"\",(I25+I26)*0.3)","v":""},null,{"$f":"IF(I$8=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M8=\"\",\"\",(M25+M26)*0.3)","v":""},{"$f":"IF(M$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(O8=\"\",\"\",(O25+O26)*0.3)","v":""},null,{"$f":"IF(O$8=\"\",\"\",\"円\")","v":""}]
["（４）","１症例当たりの人件費","：{(1)＋(2)＋(3)}　×　消費税率","＝",{"$f":"IF(E8=\"\",\"\",ROUND((E25+E26+E27)*(1+E10/100),0))","v":""},{"$f":"IF(E$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(G8=\"\",\"\",ROUND((G25+G26+G27)*(1+G10/100),0))","v":""},{"$f":"IF(G$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(I8=\"\",\"\",ROUND((I25+I26+I27)*(1+I10/100),0))","v":""},null,{"$f":"IF(I$8=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M8=\"\",\"\",ROUND((M25+M26+M27)*(1+M10/100),0))","v":""},{"$f":"IF(M$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(O8=\"\",\"\",ROUND((O25+O26+O27)*(1+O10/100),0))","v":""},null,{"$f":"IF(O$8=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"IF(E8=\"\",\"\",E28-SUM(E25:E27))","v":""},{"$f":"IF(E$8=\"\",\"\",\"円）\")","v":""},{"$f":"IF(G8=\"\",\"\",G28-SUM(G25:G27))","v":""},{"$f":"IF(G$8=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I8=\"\",\"\",I28-SUM(I25:I27))","v":""},null,{"$f":"IF(I$8=\"\",\"\",\"円）\")","v":""},null,{"$f":"IF(M8=\"\",\"\",M28-SUM(M25:M27))","v":""},{"$f":"IF(M$8=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O8=\"\",\"\",O28-SUM(O25:O27))","v":""},null,{"$f":"IF(O$8=\"\",\"\",\"円）\")","v":""}]
[]
["４　治験準備費について"]
["（１） ","直接経費","：１８０，０００円","＝",{"$f":"IF(SUM(E7:E8)=0,\"\",180000)","v":""},{"$f":"IF(E$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(SUM(G7:G8)=0,\"\",IF(SUM(E7:E8)>0,\"\",180000))","v":""},{"$f":"IF(G$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(SUM(I7:J8)=0,\"\",IF(SUM(E7:E8,G7:G8)>0,\"\",180000))","v":""},null,{"$f":"IF(I$32=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(SUM(M7:M8)=0,\"\",IF(SUM(E7:E8,G7:G8,I7:J8)>0,\"\",180000))","v":""},{"$f":"IF(M$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(SUM(O7:P8)=0,\"\",IF(SUM(E7:E8,G7:G8,I7:J8,M7:M8)>0,\"\",180000))","v":""},null,{"$f":"IF(O$32=\"\",\"\",\"円\")","v":""}]
["（２）","管理費","：(1)   ×　０．２（２０％）","＝",{"$f":"IF(E32=\"\",\"\",E32*0.2)","v":""},{"$f":"IF(E$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(G32=\"\",\"\",G32*0.2)","v":""},{"$f":"IF(G$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(I32=\"\",\"\",I32*0.2)","v":""},null,{"$f":"IF(I$32=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M32=\"\",\"\",M32*0.2)","v":""},{"$f":"IF(M$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(O32=\"\",\"\",O32*0.2)","v":""},null,{"$f":"IF(O$32=\"\",\"\",\"円\")","v":""}]
["（３）","間接経費","：{(1)＋(2)}　×　０．３（３０％）","＝",{"$f":"IF(E32=\"\",\"\",(E32+E33)*0.3)","v":""},{"$f":"IF(E$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(G32=\"\",\"\",(G32+G33)*0.3)","v":""},{"$f":"IF(G$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(I32=\"\",\"\",(I32+I33)*0.3)","v":""},null,{"$f":"IF(I$32=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M32=\"\",\"\",(M32+M33)*0.3)","v":""},{"$f":"IF(M$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(O32=\"\",\"\",(O32+O33)*0.3)","v":""},null,{"$f":"IF(O$32=\"\",\"\",\"円\")","v":""}]
["（４）","治験準備費","：{(1)＋(2)＋(3)}　×　消費税率","＝",{"$f":"IF(E32=\"\",\"\",ROUND((E32+E33+E34)*(1+E10/100),0))","v":""},{"$f":"IF(E$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(G32=\"\",\"\",ROUND((G32+G33+G34)*(1+G10/100),0))","v":""},{"$f":"IF(G$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(I32=\"\",\"\",ROUND((I32+I33+I34)*(1+I10/100),0))","v":""},null,{"$f":"IF(I$32=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M32=\"\",\"\",ROUND((M32+M33+M34)*(1+M10/100),0))","v":""},{"$f":"IF(M$32=\"\",\"\",\"円\")","v":""},{"$f":"IF(O32=\"\",\"\",ROUND((O32+O33+O34)*(1+O10/100),0))","v":""},null,{"$f":"IF(O$32=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"IF(E32=\"\",\"\",E35-SUM(E32:E34))","v":""},{"$f":"IF(E$32=\"\",\"\",\"円）\")","v":""},{"$f":"IF(G32=\"\",\"\",G35-SUM(G32:G34))","v":""},{"$f":"IF(G$32=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I32=\"\",\"\",I35-SUM(I32:J34))","v":""},null,{"$f":"IF(I$32=\"\",\"\",\"円）\")","v":""},null,{"$f":"IF(M32=\"\",\"\",M35-SUM(M32:M34))","v":""},{"$f":"IF(M$32=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O32=\"\",\"\",O35-SUM(O32:P34))","v":""},null,{"$f":"IF(O$32=\"\",\"\",\"円）\")","v":""}]
[]
["５　各費用合計",null,null,"請求日","～2013/9/30",null,"2013/10/1～2014/3/31",null,"2014/4/1～2019/3/31",null,null,null,"2019/4/1～2019/9/30",null,"2019/10/1～"]
["※\n","各費用合計は、請求日の期間内に含まれる対象費用（Ａ～Ｃ）の合計。\nただし、請求日の期間内に費用の記載がない場合は、直前に記載された金額。",null,"対象"]
[null,null,null,null,"Ａ",null,"Ｂ"]
[null,null,null,null,null,null,null,null,"Ａ",null,null,null,"Ｂ",null,"Ｃ"]
["（１） ","研究費（症例単価）",null,null,{"$f":"E18","v":""},{"$f":"IF(E$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(G7=\"\",\"\",IF(E18=\"\",G18,$E18+G18))","v":""},{"$f":"IF(G$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(I7=\"\",\"\",IF(E18=\"\",I18,$E18+I18))","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M7=\"\",\"\",IF(E18=\"\",IF(I18=\"\",M18,I18+M18),IF(I18=\"\",E18+M18,E18+I18+M18)))","v":""},{"$f":"IF(M$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(O7=\"\",\"\",IF(E18=\"\",IF(I18=\"\",O18,I18+O18),IF(I18=\"\",E18+O18,E18+I18+O18)))","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"E19","v":""},{"$f":"IF(E$7=\"\",\"\",\"円）\")","v":""},{"$f":"IF(G7=\"\",\"\",IF(E19=\"\",G19,$E19+G19))","v":""},{"$f":"IF(G$7=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I7=\"\",\"\",IF(E19=\"\",I19,$E19+I19))","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円）\")","v":""},null,{"$f":"IF(M7=\"\",\"\",IF(E19=\"\",IF(I19=\"\",M19,I19+M19),IF(I19=\"\",E19+M19,E19+I19+M19)))","v":""},{"$f":"IF(M$7=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O7=\"\",\"\",IF(E19=\"\",IF(I19=\"\",O19,I19+O19),IF(I19=\"\",E19+O19,E19+I19+O19)))","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円）\")","v":""}]
[null,"ドロップアウト費用（症例単価）",null,null,{"$f":"E20","v":""},{"$f":"IF(E$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(G7=\"\",\"\",IF(E20=\"\",G20,$E20+G20))","v":""},{"$f":"IF(G$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(I7=\"\",\"\",IF(E20=\"\",I20,$E20+I20))","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M7=\"\",\"\",IF(E20=\"\",IF(I20=\"\",M20,I20+M20),IF(I20=\"\",E20+M20,E20+I20+M20)))","v":""},{"$f":"IF(M$7=\"\",\"\",\"円\")","v":""},{"$f":"IF(O7=\"\",\"\",IF(E20=\"\",IF(I20=\"\",O20,I20+O20),IF(I20=\"\",E20+O20,E20+I20+O20)))","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"E21","v":""},{"$f":"IF(E$7=\"\",\"\",\"円）\")","v":""},{"$f":"IF(G7=\"\",\"\",IF(E21=\"\",G21,$E21+G21))","v":""},{"$f":"IF(G$7=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I7=\"\",\"\",IF(E21=\"\",I21,$E21+I21))","v":""},null,{"$f":"IF(I$7=\"\",\"\",\"円）\")","v":""},null,{"$f":"IF(M7=\"\",\"\",IF(E21=\"\",IF(I21=\"\",M21,I21+M21),IF(I21=\"\",E21+M21,E21+I21+M21)))","v":""},{"$f":"IF(M$7=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O7=\"\",\"\",IF(E21=\"\",IF(I21=\"\",O21,I21+O21),IF(I21=\"\",E21+O21,E21+I21+O21)))","v":""},null,{"$f":"IF(O$7=\"\",\"\",\"円）\")","v":""}]
["（２）","人件費（症例単価）",null,null,{"$f":"E28","v":""},{"$f":"IF(E$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(G8=\"\",\"\",IF(E28=\"\",G28,$E28+G28))","v":""},{"$f":"IF(G$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(I8=\"\",\"\",IF(E28=\"\",I28,$E28+I28))","v":""},null,{"$f":"IF(I$8=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M8=\"\",\"\",IF(E28=\"\",IF(I28=\"\",M28,I28+M28),IF(I28=\"\",E28+M28,E28+I28+M28)))","v":""},{"$f":"IF(M$8=\"\",\"\",\"円\")","v":""},{"$f":"IF(O8=\"\",\"\",IF(E28=\"\",IF(I28=\"\",O28,I28+O28),IF(I28=\"\",E28+O28,E28+I28+O28)))","v":""},null,{"$f":"IF(O$8=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"E29","v":""},{"$f":"IF(E$8=\"\",\"\",\"円）\")","v":""},{"$f":"IF(G8=\"\",\"\",IF(E29=\"\",G29,$E29+G29))","v":""},{"$f":"IF(G$8=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I8=\"\",\"\",IF(E29=\"\",I29,$E29+I29))","v":""},null,{"$f":"IF(I$8=\"\",\"\",\"円）\")","v":""},null,{"$f":"IF(M8=\"\",\"\",IF(E29=\"\",IF(I29=\"\",M29,I29+M29),IF(I29=\"\",E29+M29,E29+I29+M29)))","v":""},{"$f":"IF(M$8=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O8=\"\",\"\",IF(E29=\"\",IF(I29=\"\",O29,I29+O29),IF(I29=\"\",E29+O29,E29+I29+O29)))","v":""},null,{"$f":"IF(O$8=\"\",\"\",\"円）\")","v":""}]
["（３）","治験準備費",null,null,{"$f":"E35","v":""},{"$f":"IF(E$48=\"\",\"\",\"円\")","v":""},{"$f":"G35","v":""},{"$f":"IF(G$48=\"\",\"\",\"円\")","v":""},{"$f":"I35","v":""},{"$f":"J35","v":0},{"$f":"IF(I$48=\"\",\"\",\"円\")","v":""},null,{"$f":"M35","v":""},{"$f":"IF(M$48=\"\",\"\",\"円\")","v":""},{"$f":"O35","v":""},{"$f":"P35","v":0},{"$f":"IF(O$48=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"E36","v":""},{"$f":"IF(E$49=\"\",\"\",\"円）\")","v":""},{"$f":"G36","v":""},{"$f":"IF(G$49=\"\",\"\",\"円）\")","v":""},{"$f":"I36","v":""},{"$f":"J36","v":0},{"$f":"IF(I$48=\"\",\"\",\"円）\")","v":""},null,{"$f":"M36","v":""},{"$f":"IF(M$49=\"\",\"\",\"円）\")","v":""},{"$f":"O36","v":""},{"$f":"P36","v":0},{"$f":"IF(O$48=\"\",\"\",\"円）\")","v":""}]
["６　治験審査委員会審査（ＩＲＢ）経費について",null,null,"審査日","～2013/9/30",null,"2013/10/1～2014/3/31",null,"2014/4/1～2019/3/31",null,null,null,"2019/4/1～2019/9/30",null,"2019/10/1～"]
["（１）","新規申請審査経費","：５５，０００円/件　×　消費税率","＝",{"$f":"IF(E$7=\"\",\"\",IF(E$7=MAX(E$7,G$7,I$7,M$7,O$7),55000*(1+E$10/100),\"\"))","v":""},{"$f":"IF(E51=\"\",\"\",\"円\")","v":""},{"$f":"IF(G$7=\"\",\"\",IF(G$7=MAX(E$7,G$7,I$7,M$7,O$7),55000*(1+G$10/100),\"\"))","v":""},{"$f":"IF(G51=\"\",\"\",\"円\")","v":""},{"$f":"IF(I$7=\"\",\"\",IF(I$7=MAX(E$7,G$7,I$7,M$7,O$7),55000*(1+I$10/100),\"\"))","v":""},null,{"$f":"IF(I51=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M$7=\"\",\"\",IF(M$7=MAX(E$7,G$7,I$7,M$7,O$7),55000*(1+M$10/100),\"\"))","v":""},{"$f":"IF(M51=\"\",\"\",\"円\")","v":""},{"$f":"IF(O$7=\"\",\"\",IF(O$7=MAX(E$7,G$7,I$7,M$7,O$7),55000*(1+O$10/100),\"\"))","v":""},null,{"$f":"IF(O51=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"IF(E51=\"\",\"\",E51-55000)","v":""},{"$f":"IF(E51=\"\",\"\",\"円）\")","v":""},{"$f":"IF(G51=\"\",\"\",G51-55000)","v":""},{"$f":"IF(G51=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I51=\"\",\"\",I51-55000)","v":""},null,{"$f":"IF(I51=\"\",\"\",\"円）\")","v":""},null,{"$f":"IF(M51=\"\",\"\",M51-55000)","v":""},{"$f":"IF(M51=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O51=\"\",\"\",O51-55000)","v":""},null,{"$f":"IF(O51=\"\",\"\",\"円）\")","v":""}]
["（２）","変更等継続審査経費","：２０，０００円/件　×　消費税率","＝",{"$f":"IF(E51=\"\",\"\",20000*(1+E$10/100))","v":""},{"$f":"IF(E51=\"\",\"\",\"円\")","v":""},{"$f":"IF(G51=\"\",\"\",20000*(1+G$10/100))","v":""},{"$f":"IF(G51=\"\",\"\",\"円\")","v":""},{"$f":"IF(I51=\"\",\"\",20000*(1+I$10/100))","v":""},null,{"$f":"IF(I51=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M51=\"\",\"\",20000*(1+M$10/100))","v":""},{"$f":"IF(M51=\"\",\"\",\"円\")","v":""},{"$f":"IF(O51=\"\",\"\",20000*(1+O$10/100))","v":""},null,{"$f":"IF(O51=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"IF(E53=\"\",\"\",E53-20000)","v":""},{"$f":"IF(E51=\"\",\"\",\"円）\")","v":""},{"$f":"IF(G53=\"\",\"\",G53-20000)","v":""},{"$f":"IF(G51=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I51=\"\",\"\",I53-20000)","v":""},null,{"$f":"IF(I51=\"\",\"\",\"円）\")","v":""},null,{"$f":"IF(M53=\"\",\"\",M53-20000)","v":""},{"$f":"IF(M51=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O51=\"\",\"\",O53-20000)","v":""},null,{"$f":"IF(O51=\"\",\"\",\"円）\")","v":""}]
["７　その他経費について",null,null,"実施日","～2013/9/30",null,"2013/10/1～2014/3/31",null,"2014/4/1～2019/3/31",null,null,null,"2019/4/1～2019/9/30",null,"2019/10/1～"]
["（１）","監査対応費","：５０，０００円/日×　消費税率","＝",{"$f":"IF(E$7=\"\",\"\",IF(E$7=MAX(E$7,G$7,I$7,M$7,O$7),50000*(1+E$10/100),\"\"))","v":""},{"$f":"IF(E56=\"\",\"\",\"円\")","v":""},{"$f":"IF(G$7=\"\",\"\",IF(G$7=MAX(E$7,G$7,I$7,M$7,O$7),50000*(1+G$10/100),\"\"))","v":""},{"$f":"IF(G56=\"\",\"\",\"円\")","v":""},{"$f":"IF(I$7=\"\",\"\",IF(I$7=MAX(E$7,G$7,I$7,M$7,O$7),50000*(1+I$10/100),\"\"))","v":""},null,{"$f":"IF(I56=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M$7=\"\",\"\",IF(M$7=MAX(E$7,G$7,I$7,M$7,O$7),50000*(1+M$10/100),\"\"))","v":""},{"$f":"IF(M56=\"\",\"\",\"円\")","v":""},{"$f":"IF(O$7=\"\",\"\",IF(O$7=MAX(E$7,G$7,I$7,M$7,O$7),50000*(1+O$10/100),\"\"))","v":""},null,{"$f":"IF(O56=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"IF(E56=\"\",\"\",E56-50000)","v":""},{"$f":"IF(E56=\"\",\"\",\"円）\")","v":""},{"$f":"IF(G56=\"\",\"\",G56-50000)","v":""},{"$f":"IF(G56=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I56=\"\",\"\",I56-50000)","v":""},null,{"$f":"IF(I56=\"\",\"\",\"円）\")","v":""},null,{"$f":"IF(M56=\"\",\"\",M56-50000)","v":""},{"$f":"IF(M56=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O56=\"\",\"\",O56-50000)","v":""},null,{"$f":"IF(O56=\"\",\"\",\"円）\")","v":""}]
["（２）","規定外来院対応費","：１５，０００円/来院１回　×　消費税率","＝",{"$f":"IF(E56=\"\",\"\",15000*(1+E$10/100))","v":""},{"$f":"IF(E56=\"\",\"\",\"円\")","v":""},{"$f":"IF(G56=\"\",\"\",15000*(1+G$10/100))","v":""},{"$f":"IF(G56=\"\",\"\",\"円\")","v":""},{"$f":"IF(I56=\"\",\"\",15000*(1+I$10/100))","v":""},null,{"$f":"IF(I56=\"\",\"\",\"円\")","v":""},null,{"$f":"IF(M56=\"\",\"\",15000*(1+M$10/100))","v":""},{"$f":"IF(M56=\"\",\"\",\"円\")","v":""},{"$f":"IF(O56=\"\",\"\",15000*(1+O$10/100))","v":""},null,{"$f":"IF(O56=\"\",\"\",\"円\")","v":""}]
[null,null,"（うち消費税額",null,{"$f":"IF(E58=\"\",\"\",E58-15000)","v":""},{"$f":"IF(E56=\"\",\"\",\"円）\")","v":""},{"$f":"IF(G58=\"\",\"\",G58-15000)","v":""},{"$f":"IF(G56=\"\",\"\",\"円）\")","v":""},{"$f":"IF(I56=\"\",\"\",I58-15000)","v":""},null,{"$f":"IF(I56=\"\",\"\",\"円）\")","v":""},null,{"$f":"IF(M58=\"\",\"\",M58-15000)","v":""},{"$f":"IF(M56=\"\",\"\",\"円）\")","v":""},{"$f":"IF(O56=\"\",\"\",O58-15000)","v":""},null,{"$f":"IF(O56=\"\",\"\",\"円）\")","v":""}]