{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["산업체","산업체_위탁"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":2,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":30,"n_cols":24,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,23,10,23],[23,10,23,16],[14,2,14,4],[17,10,17,14],[18,3,18,4],[18,10,18,14],[12,10,12,14],[13,10,13,14],[15,12,15,14],[16,12,16,14],[14,6,14,16],[4,6,4,16],[10,6,10,16],[6,2,6,3],[1,20,1,22],[11,10,11,14],[7,2,7,3],[8,2,8,3],[5,2,5,3],[10,1,10,4],[11,2,13,2],[11,1,23,1],[5,1,9,1],[9,2,9,3],[2,0,2,1],[2,2,2,4],[2,11,2,12],[3,0,3,16],[4,0,4,1],[4,2,4,4],[0,0,0,17],[5,0,25,0],[24,1,24,4],[25,1,25,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[20,10,20,14],[21,12,21,14],[23,2,23,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[25,6,25,16],[2,13,2,15],[2,6,2,10],[29,0,29,4],[29,6,29,16],[30,0,30,13],[27,0,27,4],[27,6,27,16],[28,0,28,4],[28,6,28,16],[26,6,26,16],[19,12,19,14],[24,6,24,16],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,6,22,16],[22,2,22,4],[26,0,26,2],[15,2,21,2]]}
["산업체 연구과제 예산내역서"]
[{"$nulls":20},"충남대 인건비 단가 기준"]
["예산금액 : ",null,13750000,null,null,"원        (금 ",{"$f":"NUMBERSTRING(C3,1)","v":"일천삼백칠십오만"},{"$nulls":4},"원정)",null,"(VAT포함)",{"$nulls":6},"구분","금액(원, 월 단가)","연구수당 상한액\n(원, 월 단가)","비고"]
["(단위 : 원, %)",{"$nulls":19},"교수",9000000,{"$f":"V4*0.5","v":4500000},"원 소속기관 급여를 받는 경우 연구수당으로 산정\n(월 단가*참여월*최대 50%이내(연구외 용역은 80%))"]
["비목명",null,"세목명",null,null,"금 액","산출내역",{"$nulls":10},"적용금액",null,null,"부교수",8000000,{"$f":"V5*0.5","v":4000000}]
["직접비","인건비","책임연구원급",null,"지급",6000000,{"$f":"VLOOKUP(C6,U$3:V$11,2,FALSE)","v":7000000},"원 ×",null,"월 ×",null,"명 ×",null,"%","=",{"$f":"G6*I6*K6*M6/100","v":0},"원",{"$f":"ROUNDDOWN(P6,-1)","v":0},{"$f":"IF(R6-P6=0,\"적정계상\",\nIF(R6-P6>0,TEXT((R6-P6),\"0,0\")&\"원 \"&\"미반영\",TEXT((P6-R6),\"0,0\")&\"원 \"&\"초과됨\") )","v":"적정계상"},null,"조교수",6000000,3000000]
[null,null,"선임연구원급",null,"지급",{"$f":"IF(R7=0,\"\",IF(R7>P7,\"초과\",IF(R7=\"\",\"\",IF(E7=\"미지급\",\"( \"&TEXT(R7,\"0,000\")&\")\",R7))))","v":""},{"$f":"VLOOKUP(C7,U$3:V$11,2,FALSE)","v":6000000},"원 ×",null,"월 ×",null,"명 ×",null,"%","=",{"$f":"G7*I7*K7*M7/100","v":0},"원",{"$f":"ROUNDDOWN(P7,-1)","v":0},{"$f":"IF(R7-P7=0,\"적정계상\",\nIF(R7-P7>0,TEXT((R7-P7),\"0,0\")&\"원 \"&\"미반영\",TEXT((P7-R7),\"0,0\")&\"원 \"&\"초과됨\") )","v":"적정계상"},null,"책임연구원급",7000000,3500000]
[null,null,"주임연구원급",null,"지급","",3000000,"원 ×",null,"월 ×",null,"명 ×",null,"%","=",{"$f":"G8*I8*K8*M8/100","v":0},"원",{"$f":"ROUNDDOWN(P8,-1)","v":0},{"$f":"IF(R8-P8=0,\"적정계상\",\nIF(R8-P8>0,TEXT((R8-P8),\"0,0\")&\"원 \"&\"미반영\",TEXT((P8-R8),\"0,0\")&\"원 \"&\"초과됨\") )","v":"적정계상"},null,"선임연구원급",6000000,3000000]
[null,null,"연구원급",null,"지급","",2200000,"원 ×",null,"월 ×",null,"명 ×",null,"%","=",0,"원",0,"적정계상",null,"주임연구원급",3000000,1500000]
[null,null,"연구보조원급",null,"지급","",1300000,"원 ×",null,"월 ×",null,"명 ×",null,"%","=",0,"원",0,"적정계상",null,"연구원급",2200000,1100000]
[null,"인건비 소계(A)",null,null,null,{"$f":"SUM(F6:F10)","v":6000000},{"$nulls":11},{"$f":"SUM(R6:R10)","v":0},null,null,"연구보조원급",1300000,650000]
[null,"경비","연구장비·재료비","장비구입비",null,{"$f":"R12","v":""},null,"원 ×",null,"회","=",{"$nulls":4},{"$f":"IF(G12*I12=0,\"\",G12*I12)","v":""},"원",{"$f":"IF(P12=\"\",\"\",ROUNDDOWN(P12,-1))","v":""},{"$f":"IF(G12*I12-F12=0,\"적정계상\",\nIF(G12*I12-F12>0,TEXT((G12*I12-F12),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G12*I12-F12)),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"시약 및 재료비 등",null,3000000,null,"원 ×",null,"회","=",{"$nulls":4},{"$f":"IF(G13*I13=0,\"\",G13*I13)","v":""},"원",{"$f":"IF(P13=\"\",\"\",ROUNDDOWN(P13,-1))","v":""},{"$f":"IF(G13*I13-F13=0,\"적정계상\",\nIF(G13*I13-F13>0,TEXT((G13*I13-F13),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G13*I13-F13)),\"0,0\")&\"원 \"&\"초과됨\") )","v":"3,000,000원 초과됨"}]
[null,null,null,"시제(작)품 제작비",null,{"$f":"R14","v":""},null,"원 ×",null,"회","=",{"$nulls":4},"","원","",{"$f":"IF(G14*I14-F14=0,\"적정계상\",\nIF(G14*I14-F14>0,TEXT((G14*I14-F14),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G14*I14-F14)),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,"소계",null,null,{"$f":"SUM(F12:F14)","v":3000000}]
[null,null,"연구활동비","국외여비",null,{"$f":"R16","v":""},null,"원 ×",null,"명 ×",null,"회","=",null,null,{"$f":"IF(G16*I16*K16=0,\"\",G16*I16*K16)","v":""},"원",{"$f":"IF(P16=\"\",\"\",ROUNDDOWN(P16,-1))","v":""},{"$f":"IF(G16*I16*K16-F16=0,\"적정계상\",\nIF(G16*I16*K16-F16>0,TEXT((G16*I16*K16-F16),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS(G16*I16*K16-F16),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"전문가활용비",null,{"$f":"R17","v":""},null,"원 ×",null,"명 ×",null,"회","=",null,null,{"$f":"IF(G17*I17*K17=0,\"\",G17*I17*K17)","v":""},"원","",{"$f":"IF(G17*I17*K17-F17=0,\"적정계상\",\nIF(G17*I17*K17-F17>0,TEXT((G17*I17*K17-F17),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS(G17*I17*K17-F17),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"인쇄 및 복사비",null,"",null,"원 ×",null,"회","=",{"$nulls":4},{"$f":"IF(G18*I18=0,\"\",G18*I18)","v":""},"원","",{"$f":"IF(G18*I18-F18=0,\"적정계상\",\nIF(G18*I18-F18>0,TEXT((G18*I18-F18),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G18*I18-F18)),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"공공요금 등 수수료",null,"",null,"원 ×",null,"회","=",{"$nulls":4},"","원","",{"$f":"IF(G19*I19-F19=0,\"적정계상\",\nIF(G19*I19-F19>0,TEXT((G19*I19-F19),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G19*I19-F19)),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"국내여비",null,{"$f":"R20","v":""},null,"원 ×",null,"명 ×",null,"회","=",null,null,{"$f":"IF(G20*I20*K20=0,\"\",G20*I20*K20)","v":""},"원",{"$f":"IF(P20=\"\",\"\",ROUNDDOWN(P20,-1))","v":""},{"$f":"IF(G20*I20*K20-F20=0,\"적정계상\",\nIF(G20*I20*K20-F20>0,TEXT((G20*I20*K20-F20),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS(G20*I20*K20-F20),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"사무용품비",null,{"$f":"R21","v":""},null,"원 ×",null,"회","=",{"$nulls":4},{"$f":"IF(G21*I21=0,\"\",G21*I21)","v":""},"원","",{"$f":"IF(G21*I21-F21=0,\"적정계상\",\nIF(G21*I21-F21>0,TEXT((G21*I21-F21),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G21*I21-F21)),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null," 회의비 ",null,"",30000,"원 ×",null,"명 ×",null,"회","=",null,null,{"$f":"IF(G22*I22*K22=0,\"\",G22*I22*K22)","v":""},"원","",{"$f":"IF(G22*I22*K22-F22=0,\"적정계상\",\nIF(G22*I22*K22-F22>0,TEXT((G22*I22*K22-F22),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS(G22*I22*K22-F22),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,"소계",null,null,{"$f":"SUM(F16:F22)","v":0}]
[null,null,"연구수당",null,null,1000000,null,"원 ×",null,"월",{"$nulls":7},{"$f":"IF(G24*I24=\"\",\"\",ROUNDDOWN(G24*I24,-1))","v":0},{"$f":"IF(#REF!*I24*K24-F24=0,\"적정계상\",\nIF(#REF!*I24*K24-F24>0,TEXT((#REF!*I24*K24-F24),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS(#REF!*I24*K24-F24),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#REF!"}}]
[null,"경비 소계(B)",null,null,null,{"$f":"F15+F23+F24","v":4000000}]
[null,"직접비 소계(A+B)",null,null,null,{"$f":"F25+F11","v":10000000},{"$f":"IF(F28-F27-F26=0,\"\",IF(F28-F27-F26>0,TEXT(F28-F27-F26,\"0,0\"&\"원이 예산에 미적용되었음\"),TEXT(ABS(F28-F27-F26),\"0,0\"&\"원이 예산 초과되었음\")))","v":""}]
["간접비( C ) [총액의",null,null,20,"%]",{"$f":"F28-ROUNDUP(F28*(1-D27/100),-1)","v":2500000},{"$f":"\"연구비(부가세 제외)의 \"&D27&\"%\"","v":"연구비(부가세 제외)의 20%"}]
["공급가액(D=A+B+C)",{"$nulls":4},{"$f":"ROUND(F30/1.1,0)","v":12500000},"공급가액"]
["부가가치세(E)",{"$nulls":4},{"$f":"ROUND(F30/11,0)","v":1250000},"부가세(공급가액의 10%)"]
["예산금액(D+E)",{"$nulls":4},{"$f":"IF(N3=\"(VAT별도)\",C3*1.1,C3)","v":13750000},"부가세포함"]

{"sheet":"산업체_위탁","index":1,"n_rows":31,"n_cols":24,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,17],[1,20,1,22],[2,0,2,1],[2,2,2,4],[2,6,2,10],[2,11,2,12],[2,13,2,15],[3,0,3,16],[3,23,10,23],[4,0,4,1],[4,2,4,4],[4,6,4,16],[5,0,26,0],[5,1,9,1],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,1,10,4],[10,6,10,16],[11,1,23,1],[11,2,13,2],[11,3,11,4],[11,10,11,14],[12,3,12,4],[12,10,12,14],[20,3,20,4],[20,10,20,14],[13,3,13,4],[13,10,13,14],[14,2,14,4],[14,6,14,16],[15,2,21,2],[15,3,15,4],[15,12,15,14],[16,3,16,4],[16,12,16,14],[17,3,17,4],[17,10,17,14],[18,3,18,4],[18,10,18,14],[19,3,19,4],[19,12,19,14],[21,3,21,4],[21,12,21,14],[22,2,22,4],[22,6,22,16],[23,2,23,4],[23,10,23,16],[24,1,24,4],[24,6,24,16],[26,1,26,4],[26,6,26,16],[27,0,27,2],[27,6,27,16],[31,0,31,13],[25,1,25,4],[28,0,28,4],[28,6,28,16],[29,0,29,4],[29,6,29,16],[30,0,30,4],[30,6,30,16]]}
["산업체 연구과제 예산내역서"]
[{"$nulls":20},"충남대 인건비 단가 기준"]
["예산금액 : ",{"$nulls":4},"원        (금 ",{"$f":"NUMBERSTRING(C3,1)","v":"영"},{"$nulls":4},"원정)",null,"(VAT포함)",{"$nulls":6},"구분","금액(원, 월 단가)","연구수당 상한액\n(원, 월 단가)","비고"]
["(단위 : 원, %)",{"$nulls":19},"교수",9000000,{"$f":"V4*0.5","v":4500000},"원 소속기관 급여를 받는 경우 연구수당으로 산정\n(월 단가*참여월*최대 50%이내(연구외 용역은 80%))"]
["비목명",null,"세목명",null,null,"금 액","산출내역",{"$nulls":10},"적용금액",null,null,"부교수",8000000,{"$f":"V5*0.5","v":4000000}]
["직접비","인건비","책임연구원급",null,"지급",null,{"$f":"VLOOKUP(C6,U$3:V$11,2,FALSE)","v":7000000},"원 ×",null,"월 ×",null,"명 ×",null,"%","=",{"$f":"G6*I6*K6*M6/100","v":0},"원",{"$f":"ROUNDDOWN(P6,-1)","v":0},{"$f":"IF(R6-P6=0,\"적정계상\",\nIF(R6-P6>0,TEXT((R6-P6),\"0,0\")&\"원 \"&\"미반영\",TEXT((P6-R6),\"0,0\")&\"원 \"&\"초과됨\") )","v":"적정계상"},null,"조교수",6000000,3000000]
[null,null,"선임연구원급",null,"지급",{"$f":"IF(R7=0,\"\",IF(R7>P7,\"초과\",IF(R7=\"\",\"\",IF(E7=\"미지급\",\"( \"&TEXT(R7,\"0,000\")&\")\",R7))))","v":""},{"$f":"VLOOKUP(C7,U$3:V$11,2,FALSE)","v":6000000},"원 ×",null,"월 ×",null,"명 ×",null,"%","=",{"$f":"G7*I7*K7*M7/100","v":0},"원",{"$f":"ROUNDDOWN(P7,-1)","v":0},{"$f":"IF(R7-P7=0,\"적정계상\",\nIF(R7-P7>0,TEXT((R7-P7),\"0,0\")&\"원 \"&\"미반영\",TEXT((P7-R7),\"0,0\")&\"원 \"&\"초과됨\") )","v":"적정계상"},null,"책임연구원급",7000000,3500000]
[null,null,"주임연구원급",null,"지급","",3000000,"원 ×",null,"월 ×",null,"명 ×",null,"%","=",{"$f":"G8*I8*K8*M8/100","v":0},"원",{"$f":"ROUNDDOWN(P8,-1)","v":0},{"$f":"IF(R8-P8=0,\"적정계상\",\nIF(R8-P8>0,TEXT((R8-P8),\"0,0\")&\"원 \"&\"미반영\",TEXT((P8-R8),\"0,0\")&\"원 \"&\"초과됨\") )","v":"적정계상"},null,"선임연구원급",6000000,3000000]
[null,null,"연구원급",null,"지급","",2200000,"원 ×",null,"월 ×",null,"명 ×",null,"%","=",0,"원",0,"적정계상",null,"주임연구원급",3000000,1500000]
[null,null,"연구보조원급",null,"지급","",1300000,"원 ×",null,"월 ×",null,"명 ×",null,"%","=",0,"원",0,"적정계상",null,"연구원급",2200000,1100000]
[null,"인건비 소계(A)",null,null,null,{"$f":"SUM(F6:F10)","v":0},{"$nulls":11},{"$f":"SUM(R6:R10)","v":0},null,null,"연구보조원급",1300000,650000]
[null,"경비","연구장비·재료비","장비구입비",null,null,null,"원 ×",null,"회","=",{"$nulls":4},{"$f":"IF(G12*I12=0,\"\",G12*I12)","v":""},"원",{"$f":"IF(P12=\"\",\"\",ROUNDDOWN(P12,-1))","v":""},{"$f":"IF(G12*I12-F12=0,\"적정계상\",\nIF(G12*I12-F12>0,TEXT((G12*I12-F12),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G12*I12-F12)),\"0,0\")&\"원 \"&\"초과됨\") )","v":"적정계상"}]
[null,null,null,"시약 및 재료비 등",null,{"$f":"R13","v":""},null,"원 ×",null,"회","=",{"$nulls":4},{"$f":"IF(G13*I13=0,\"\",G13*I13)","v":""},"원",{"$f":"IF(P13=\"\",\"\",ROUNDDOWN(P13,-1))","v":""},{"$f":"IF(G13*I13-F13=0,\"적정계상\",\nIF(G13*I13-F13>0,TEXT((G13*I13-F13),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G13*I13-F13)),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"시제(작)품 제작비",null,"",null,"원 ×",null,"회","=",{"$nulls":4},"","원","",{"$f":"IF(G14*I14-F14=0,\"적정계상\",\nIF(G14*I14-F14>0,TEXT((G14*I14-F14),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G14*I14-F14)),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,"소계",null,null,{"$f":"SUM(F12:F14)","v":0}]
[null,null,"연구활동비","국외여비",null,{"$f":"R16","v":""},null,"원 ×",null,"명 ×",null,"회","=",null,null,{"$f":"IF(G16*I16*K16=0,\"\",G16*I16*K16)","v":""},"원",{"$f":"IF(P16=\"\",\"\",ROUNDDOWN(P16,-1))","v":""},{"$f":"IF(G16*I16*K16-F16=0,\"적정계상\",\nIF(G16*I16*K16-F16>0,TEXT((G16*I16*K16-F16),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS(G16*I16*K16-F16),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"전문가활용비",null,{"$f":"R17","v":""},null,"원 ×",null,"명 ×",null,"회","=",null,null,{"$f":"IF(G17*I17*K17=0,\"\",G17*I17*K17)","v":""},"원","",{"$f":"IF(G17*I17*K17-F17=0,\"적정계상\",\nIF(G17*I17*K17-F17>0,TEXT((G17*I17*K17-F17),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS(G17*I17*K17-F17),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"인쇄 및 복사비",null,"",null,"원 ×",null,"회","=",{"$nulls":4},{"$f":"IF(G18*I18=0,\"\",G18*I18)","v":""},"원","",{"$f":"IF(G18*I18-F18=0,\"적정계상\",\nIF(G18*I18-F18>0,TEXT((G18*I18-F18),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G18*I18-F18)),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"공공요금 등 수수료",null,"",null,"원 ×",null,"회","=",{"$nulls":4},"","원","",{"$f":"IF(G19*I19-F19=0,\"적정계상\",\nIF(G19*I19-F19>0,TEXT((G19*I19-F19),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G19*I19-F19)),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"국내여비",null,{"$f":"R20","v":""},null,"원 ×",null,"명 ×",null,"회","=",null,null,{"$f":"IF(G20*I20*K20=0,\"\",G20*I20*K20)","v":""},"원","",{"$f":"IF(G20*I20*K20-F20=0,\"적정계상\",\nIF(G20*I20*K20-F20>0,TEXT((G20*I20*K20-F20),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS(G20*I20*K20-F20),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null,"사무용품비",null,{"$f":"R21","v":""},null,"원 ×",null,"회","=",{"$nulls":4},{"$f":"IF(G21*I21=0,\"\",G21*I21)","v":""},"원","",{"$f":"IF(G21*I21-F21=0,\"적정계상\",\nIF(G21*I21-F21>0,TEXT((G21*I21-F21),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS((G21*I21-F21)),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,null," 회의비 ",null,"",30000,"원 ×",null,"명 ×",null,"회","=",null,null,{"$f":"IF(G22*I22*K22=0,\"\",G22*I22*K22)","v":""},"원","",{"$f":"IF(G22*I22*K22-F22=0,\"적정계상\",\nIF(G22*I22*K22-F22>0,TEXT((G22*I22*K22-F22),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS(G22*I22*K22-F22),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#VALUE!"}}]
[null,null,"소계",null,null,{"$f":"SUM(F16:F22)","v":0}]
[null,null,"연구수당",null,null,{"$f":"SUM(R24)","v":0},null,"원 ×",null,"월",{"$nulls":7},{"$f":"IF(G24*I24=\"\",\"\",ROUNDDOWN(G24*I24,-1))","v":0},{"$f":"IF(#REF!*I24*K24-F24=0,\"적정계상\",\nIF(#REF!*I24*K24-F24>0,TEXT((#REF!*I24*K24-F24),\"0,0\")&\"원 \"&\"감액함\",TEXT(ABS(#REF!*I24*K24-F24),\"0,0\")&\"원 \"&\"초과됨\") )","v":{"$error":"#REF!"}}]
[null,"경비 소계(B)",null,null,null,{"$f":"F15+F23+F24","v":0}]
[null,"위탁연구개발비©"]
[null,"직접비 소계(A+B+C)",null,null,null,{"$f":"F25+F11+F26","v":0}]
["간접비( A+B ) [총액의",null,null,20,"%]",{"$f":"SUM(F11+F25)*20%","v":0},{"$f":"\"연구비(부가세, 위탁연구비 제외)의 \"&D28&\"%\"","v":"연구비(부가세, 위탁연구비 제외)의 20%"}]
["공급가액(D=A+B+C)",{"$nulls":4},{"$f":"ROUND(F31/1.1,0)","v":0},"공급가액"]
["부가가치세(E)",{"$nulls":4},{"$f":"ROUND(F31/11,0)","v":0},"부가세(공급가액의 10%)"]
["예산금액(D+E)",{"$nulls":4},{"$f":"IF(N3=\"(VAT별도)\",C3*1.1,C3)","v":0},"부가세포함"]