{"text_format":"2","workbook":"xlsx","n_sheets":9,"sheets":["1.사업비 총괄(종합)","1.사업비 총괄(주관)","1차년도","2차년도","3차년도","1.사업비 총괄(공동)","1차년도 (2)","2차년도 (2)","3차년도 (2)"],"not_rendered":{"charts":0,"images":6,"macros":0,"external_links":0,"defined_names":0,"comments":0,"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":"1.사업비 총괄(종합)","index":0,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,6],[18,1,18,4],[28,1,28,4],[38,1,38,4]]}
[]
[null,"혁신기술 지원사업 사업비 기준 (단위 : 천원)"]
[null,"1) 정부지원금 75%, 민간부담금 25% "]
[null,"2) 민간 현금/현물 비율 (현금 10% 이상)",null,null,null,"소프트웨어 개발 과제여부\n(예/아니오)","아니오"]
[null,"연차","정부지원금","민간합계","민간현금","민간현물","총사업비합계"]
[null,"1차년도",{"$f":"'1.사업비 총괄(주관)'!C6+'1.사업비 총괄(공동)'!C6","v":666666},{"$f":"E6+F6","v":222223},{"$f":"'1.사업비 총괄(주관)'!E6+'1.사업비 총괄(공동)'!E6","v":22223},{"$f":"'1.사업비 총괄(주관)'!F6+'1.사업비 총괄(공동)'!F6","v":200000},{"$f":"C6+D6","v":888889}]
[null,"2차년도",{"$f":"'1.사업비 총괄(주관)'!C7+'1.사업비 총괄(공동)'!C7","v":666666},{"$f":"E7+F7","v":222222},{"$f":"'1.사업비 총괄(주관)'!E7+'1.사업비 총괄(공동)'!E7","v":22222},{"$f":"'1.사업비 총괄(주관)'!F7+'1.사업비 총괄(공동)'!F7","v":200000},{"$f":"C7+D7","v":888888}]
[null,"3차년도",{"$f":"'1.사업비 총괄(주관)'!C8+'1.사업비 총괄(공동)'!C8","v":666666},{"$f":"E8+F8","v":222222},{"$f":"'1.사업비 총괄(주관)'!E8+'1.사업비 총괄(공동)'!E8","v":22222},{"$f":"'1.사업비 총괄(주관)'!F8+'1.사업비 총괄(공동)'!F8","v":200000},{"$f":"C8+D8","v":888888}]
[null,"합계",{"$f":"SUM(C6:C8)","v":1999998},{"$f":"SUM(D6:D8)","v":666667},{"$f":"SUM(E6:E8)","v":66667},{"$f":"SUM(F6:F8)","v":600000},{"$f":"SUM(G6:G8)","v":2666665}]
[null,"%",{"$f":"C9/G9","v":0.74999971874982418},{"$f":"D9/G9","v":0.25000028125017576},{"$f":"E9/D9","v":0.100000449999775},{"$f":"F9/D9","v":0.89999955000022502}]
[{"$nulls":8},"비율"]
[{"$nulls":5},"인건비 계상비율",{"$f":"IF($G$4=\"아니오\",IF($I$12>50%,\"초과\",\"가능\"),\"가능\")","v":"가능"},"50%이내, 소프트웨어는 50%이상 가능",{"$f":"($E$21+$E$31+$E$41)/$G$9","v":0.18900011812507383}]
[null,null,"현금","현물",null,"간접비 계상비율",{"$f":"IF($I$13>10%,\"초과\",\"가능\")","v":"가능"},"10%이내, 직접비(현물 및 위탁개발비 제외)",{"$f":"(C27+C37+C47)/(SUM(C21:C24)+SUM(C31:C34)+SUM(C41:C44))","v":5.7763990582929162E-5}]
[null,"1차년도",{"$f":"SUM(C26:C27)","v":5243847},{"$f":"SUM(D26:D27)","v":25000},null,"위탁연구비 계상비율",{"$f":"IF($I$14>40%,\"초과\",\"가능\")","v":"가능"},"40%이내, 직접비(현물포함)",{"$f":"(E25+E35+E45)/(E26+E36+E46)","v":9.490282614922102E-3}]
[null,"2차년도",{"$f":"SUM(C36:C37)","v":5243847},{"$f":"SUM(D36:D37)","v":25000},null,"시제품제작비 계상비율",{"$f":"IF($I$15>50%,\"초과\",\"가능\")","v":"가능"},"50%이내, 직접비(현물포함)",{"$f":"('1차년도'!AM2+'2차년도'!AM2+'3차년도'!AM2)/(E26+E36+E46)","v":1.8980565229844205E-3}]
[null,"3차년도",{"$f":"SUM(C46:C47)","v":5243847},{"$f":"SUM(D46:D47)","v":25000},null,"외부전문기술활용비 계상비율",{"$f":"IF($I$16>40%,\"초과\",\"가능\")","v":"가능"},"40%이내, 직접비(현물포함)",{"$f":"('1차년도'!AN2+'2차년도'!AN2+'3차년도'!AN2)/(E26+E36+E46)","v":9.7996658281685627E-4}]
[null,"합계",{"$f":"SUM(C14:C16)","v":15731541},{"$f":"SUM(D14:D16)","v":75000}]
[]
[null,"1차년도"]
[null,null,"현금","현물","합"]
[null,"1.1 인건비",{"$f":"'1차년도'!D74+'1차년도 (2)'!D74","v":143000},{"$f":"'1차년도'!E74+'1차년도 (2)'!E74","v":25000},{"$f":"'1차년도'!F74+'1차년도 (2)'!F74","v":168000}]
[null,"1.3 연구장비",{"$f":"'1차년도'!D75+'1차년도 (2)'!D75","v":5000000},{"$f":"'1차년도'!E75+'1차년도 (2)'!E75","v":0},{"$f":"'1차년도'!F75+'1차년도 (2)'!F75","v":5000000}]
[null,"1.4 연구재료비",{"$f":"'1차년도'!D76+'1차년도 (2)'!D76","v":10000},{"$f":"'1차년도'!E76+'1차년도 (2)'!E76","v":0},{"$f":"'1차년도'!F76+'1차년도 (2)'!F76","v":10000}]
[null,"1.5 연구활동비",{"$f":"'1차년도'!D77+'1차년도 (2)'!D77","v":40547},{"$f":"'1차년도'!E77+'1차년도 (2)'!E77","v":0},{"$f":"'1차년도'!F77+'1차년도 (2)'!F77","v":40547}]
[null,"1.7 위탁연구개발비",{"$f":"'1차년도'!D78+'1차년도 (2)'!D78","v":50000},{"$f":"'1차년도'!E78+'1차년도 (2)'!E78","v":0},{"$f":"'1차년도'!F78+'1차년도 (2)'!F78","v":50000}]
[null,"1. 직접비",{"$f":"SUM(C21:C25)","v":5243547},{"$f":"SUM(D21:D25)","v":25000},{"$f":"SUM(E21:E25)","v":5268547}]
[null,"2. 간접비",{"$f":"'1차년도'!D80+'1차년도 (2)'!D80","v":300},{"$f":"'1차년도'!E80+'1차년도 (2)'!E80","v":0},{"$f":"'1차년도'!F80+'1차년도 (2)'!F80","v":300}]
[]
[null,"2차년도"]
[null,null,"현금","현물","합"]
[null,"1.1 인건비",{"$f":"'2차년도'!D74+'2차년도 (2)'!D74","v":143000},{"$f":"'2차년도'!E74+'2차년도 (2)'!E74","v":25000},{"$f":"'2차년도'!F74+'2차년도 (2)'!F74","v":168000}]
[null,"1.3 연구장비",{"$f":"'2차년도'!D75+'2차년도 (2)'!D75","v":5000000},{"$f":"'2차년도'!E75+'2차년도 (2)'!E75","v":0},{"$f":"'2차년도'!F75+'2차년도 (2)'!F75","v":5000000}]
[null,"1.4 연구재료비",{"$f":"'2차년도'!D76+'2차년도 (2)'!D76","v":10000},{"$f":"'2차년도'!E76+'2차년도 (2)'!E76","v":0},{"$f":"'2차년도'!F76+'2차년도 (2)'!F76","v":10000}]
[null,"1.5 연구활동비",{"$f":"'2차년도'!D77+'2차년도 (2)'!D77","v":40547},{"$f":"'2차년도'!E77+'2차년도 (2)'!E77","v":0},{"$f":"'2차년도'!F77+'2차년도 (2)'!F77","v":40547}]
[null,"1.7 위탁연구개발비",{"$f":"'2차년도'!D78+'2차년도 (2)'!D78","v":50000},{"$f":"'2차년도'!E78+'2차년도 (2)'!E78","v":0},{"$f":"'2차년도'!F78+'2차년도 (2)'!F78","v":50000}]
[null,"1. 직접비",{"$f":"SUM(C31:C35)","v":5243547},{"$f":"SUM(D31:D35)","v":25000},{"$f":"SUM(E31:E35)","v":5268547}]
[null,"2. 간접비",{"$f":"'2차년도'!D80+'2차년도 (2)'!D80","v":300},{"$f":"'2차년도'!E80+'2차년도 (2)'!E80","v":0},{"$f":"'2차년도'!F80+'2차년도 (2)'!F80","v":300}]
[]
[null,"3차년도"]
[null,null,"현금","현물","합"]
[null,"1.1 인건비",{"$f":"'3차년도'!D74+'3차년도 (2)'!D74","v":143000},{"$f":"'3차년도'!E74+'3차년도 (2)'!E74","v":25000},{"$f":"'3차년도'!F74+'3차년도 (2)'!F74","v":168000}]
[null,"1.3 연구장비",{"$f":"'3차년도'!D75+'3차년도 (2)'!D75","v":5000000},{"$f":"'3차년도'!E75+'3차년도 (2)'!E75","v":0},{"$f":"'3차년도'!F75+'3차년도 (2)'!F75","v":5000000}]
[null,"1.4 연구재료비",{"$f":"'3차년도'!D76+'3차년도 (2)'!D76","v":10000},{"$f":"'3차년도'!E76+'3차년도 (2)'!E76","v":0},{"$f":"'3차년도'!F76+'3차년도 (2)'!F76","v":10000}]
[null,"1.5 연구활동비",{"$f":"'3차년도'!D77+'3차년도 (2)'!D77","v":40547},{"$f":"'3차년도'!E77+'3차년도 (2)'!E77","v":0},{"$f":"'3차년도'!F77+'3차년도 (2)'!F77","v":40547}]
[null,"1.7 위탁연구개발비",{"$f":"'3차년도'!D78+'3차년도 (2)'!D78","v":50000},{"$f":"'3차년도'!E78+'3차년도 (2)'!E78","v":0},{"$f":"'3차년도'!F78+'3차년도 (2)'!F78","v":50000}]
[null,"1. 직접비",{"$f":"SUM(C41:C45)","v":5243547},{"$f":"SUM(D41:D45)","v":25000},{"$f":"SUM(E41:E45)","v":5268547}]
[null,"2. 간접비",{"$f":"'3차년도'!D80+'3차년도 (2)'!D80","v":300},{"$f":"'3차년도'!E80+'3차년도 (2)'!E80","v":0},{"$f":"'3차년도'!F80+'3차년도 (2)'!F80","v":300}]

{"sheet":"1.사업비 총괄(주관)","index":1,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,6],[18,1,18,4],[28,1,28,4],[38,1,38,4]]}
[]
[null,"혁신기술 지원사업 사업비 기준 (단위 : 천원)"]
[null,"1) 정부지원금 75%, 민간부담금 25% "]
[null,"2) 민간 현금/현물 비율 (현금 10% 이상)",null,null,null,"소프트웨어 개발 과제여부\n(예/아니오)","아니오"]
[null,"연차","정부지원금","민간합계","민간현금","민간현물","총사업비합계"]
[null,"1차년도",666666,{"$f":"E6+F6","v":222223},22223,200000,{"$f":"C6+D6","v":888889}]
[null,"2차년도",666666,{"$f":"E7+F7","v":222222},22222,200000,{"$f":"C7+D7","v":888888}]
[null,"3차년도",666666,{"$f":"E8+F8","v":222222},22222,200000,{"$f":"C8+D8","v":888888}]
[null,"합계",{"$f":"SUM(C6:C8)","v":1999998},{"$f":"SUM(D6:D8)","v":666667},{"$f":"SUM(E6:E8)","v":66667},{"$f":"SUM(F6:F8)","v":600000},{"$f":"SUM(G6:G8)","v":2666665}]
[null,"%",{"$f":"C9/G9","v":0.74999971874982418},{"$f":"D9/G9","v":0.25000028125017576},{"$f":"E9/D9","v":0.100000449999775},{"$f":"F9/D9","v":0.89999955000022502}]
[{"$nulls":8},"비율"]
[{"$nulls":5},"인건비 계상비율",{"$f":"IF($G$4=\"아니오\",IF($I$12>50%,\"초과\",\"가능\"),\"가능\")","v":"가능"},"50%이내, 소프트웨어는 50%이상 가능",{"$f":"($E$21+$E$31+$E$41)/$G$9","v":0.18900011812507383}]
[null,null,"현금","현물",null,"간접비 계상비율",{"$f":"IF($I$13>10%,\"초과\",\"가능\")","v":"가능"},"10%이내, 직접비(현물 및 위탁개발비 제외)",{"$f":"(C27+C37+C47)/(SUM(C21:C24)+SUM(C31:C34)+SUM(C41:C44))","v":5.7763990582929162E-5}]
[null,"1차년도",{"$f":"SUM(C26:C27)","v":5243847},{"$f":"SUM(D26:D27)","v":25000},null,"위탁연구비 계상비율",{"$f":"IF($I$14>40%,\"초과\",\"가능\")","v":"가능"},"40%이내, 직접비(현물포함)",{"$f":"(E25+E35+E45)/(E26+E36+E46)","v":9.490282614922102E-3}]
[null,"2차년도",{"$f":"SUM(C36:C37)","v":5243847},{"$f":"SUM(D36:D37)","v":25000},null,"시제품제작비 계상비율",{"$f":"IF($I$15>50%,\"초과\",\"가능\")","v":"가능"},"50%이내, 직접비(현물포함)",{"$f":"('1차년도'!AM2+'2차년도'!AM2+'3차년도'!AM2)/(E26+E36+E46)","v":1.8980565229844205E-3}]
[null,"3차년도",{"$f":"SUM(C46:C47)","v":5243847},{"$f":"SUM(D46:D47)","v":25000},null,"외부전문기술활용비 계상비율",{"$f":"IF($I$16>40%,\"초과\",\"가능\")","v":"가능"},"40%이내, 직접비(현물포함)",{"$f":"('1차년도'!AN2+'2차년도'!AN2+'3차년도'!AN2)/(E26+E36+E46)","v":9.7996658281685627E-4}]
[null,"합계",{"$f":"SUM(C14:C16)","v":15731541},{"$f":"SUM(D14:D16)","v":75000}]
[]
[null,"1차년도"]
[null,null,"현금","현물","합"]
[null,"1.1 인건비",{"$f":"'1차년도'!D74","v":143000},{"$f":"'1차년도'!E74","v":25000},{"$f":"'1차년도'!F74","v":168000}]
[null,"1.3 연구장비",{"$f":"'1차년도'!D75","v":5000000},{"$f":"'1차년도'!E75","v":0},{"$f":"'1차년도'!F75","v":5000000}]
[null,"1.4 연구재료비",{"$f":"'1차년도'!D76","v":10000},{"$f":"'1차년도'!E76","v":0},{"$f":"'1차년도'!F76","v":10000}]
[null,"1.5 연구활동비",{"$f":"'1차년도'!D77","v":40547},{"$f":"'1차년도'!E77","v":0},{"$f":"'1차년도'!F77","v":40547}]
[null,"1.7 위탁연구개발비",{"$f":"'1차년도'!D78","v":50000},{"$f":"'1차년도'!E78","v":0},{"$f":"'1차년도'!F78","v":50000}]
[null,"1. 직접비",{"$f":"SUM(C21:C25)","v":5243547},{"$f":"SUM(D21:D25)","v":25000},{"$f":"SUM(E21:E25)","v":5268547}]
[null,"2. 간접비",{"$f":"'1차년도'!J62","v":300},{"$f":"'1차년도'!K62","v":0},{"$f":"'1차년도'!L62","v":300}]
[]
[null,"2차년도"]
[null,null,"현금","현물","합"]
[null,"1.1 인건비",{"$f":"'2차년도'!D74","v":143000},{"$f":"'2차년도'!E74","v":25000},{"$f":"'2차년도'!F74","v":168000}]
[null,"1.3 연구장비",{"$f":"'2차년도'!D75","v":5000000},{"$f":"'2차년도'!E75","v":0},{"$f":"'2차년도'!F75","v":5000000}]
[null,"1.4 연구재료비",{"$f":"'2차년도'!D76","v":10000},{"$f":"'2차년도'!E76","v":0},{"$f":"'2차년도'!F76","v":10000}]
[null,"1.5 연구활동비",{"$f":"'2차년도'!D77","v":40547},{"$f":"'2차년도'!E77","v":0},{"$f":"'2차년도'!F77","v":40547}]
[null,"1.7 위탁연구개발비",{"$f":"'2차년도'!D78","v":50000},{"$f":"'2차년도'!E78","v":0},{"$f":"'2차년도'!F78","v":50000}]
[null,"1. 직접비",{"$f":"SUM(C31:C35)","v":5243547},{"$f":"SUM(D31:D35)","v":25000},{"$f":"SUM(E31:E35)","v":5268547}]
[null,"2. 간접비",{"$f":"'1차년도'!J62","v":300},{"$f":"'1차년도'!K62","v":0},{"$f":"'1차년도'!L62","v":300}]
[]
[null,"3차년도"]
[null,null,"현금","현물","합"]
[null,"1.1 인건비",{"$f":"'3차년도'!D74","v":143000},{"$f":"'3차년도'!E74","v":25000},{"$f":"'3차년도'!F74","v":168000}]
[null,"1.3 연구장비",{"$f":"'3차년도'!D75","v":5000000},{"$f":"'3차년도'!E75","v":0},{"$f":"'3차년도'!F75","v":5000000}]
[null,"1.4 연구재료비",{"$f":"'3차년도'!D76","v":10000},{"$f":"'3차년도'!E76","v":0},{"$f":"'3차년도'!F76","v":10000}]
[null,"1.5 연구활동비",{"$f":"'3차년도'!D77","v":40547},{"$f":"'3차년도'!E77","v":0},{"$f":"'3차년도'!F77","v":40547}]
[null,"1.7 위탁연구개발비",{"$f":"'3차년도'!D78","v":50000},{"$f":"'3차년도'!E78","v":0},{"$f":"'3차년도'!F78","v":50000}]
[null,"1. 직접비",{"$f":"SUM(C41:C45)","v":5243547},{"$f":"SUM(D41:D45)","v":25000},{"$f":"SUM(E41:E45)","v":5268547}]
[null,"2. 간접비",{"$f":"'3차년도'!J62","v":300},{"$f":"'3차년도'!K62","v":0},{"$f":"'3차년도'!L62","v":300}]

{"sheet":"1차년도","index":2,"n_rows":81,"n_cols":55,"rows_kept":81,"cut":false,"hidden":false,"merged":[[1,1,1,12],[58,2,60,2],[60,3,60,8],[58,1,61,1],[61,2,61,8],[38,1,51,1],[52,1,53,1],[37,2,37,8],[51,2,51,8],[53,2,53,8],[4,1,9,1],[10,1,13,1],[26,1,37,1],[16,2,16,3],[9,3,9,8],[13,3,13,8],[14,1,14,8],[17,1,25,1],[25,2,25,8],[66,1,66,8],[63,1,63,8],[73,1,73,2],[54,1,54,8],[55,1,55,8],[57,1,57,2],[64,1,64,8],[65,1,65,8]]}
[{"$nulls":38},"시작품/시제품 제작경비","외부전문기술활용비"]
[null,"국방벤처 혁신기술 사업비소요명세서 자동계산 엑셀 (단위 : 천원)",{"$nulls":36},{"$f":"SUMIF(C18:I54,\"시작품/시제품 제작경비\",J18:J54)","v":10000},{"$f":"SUMIF(C18:I54,\"외부전문기술활용비\",J18:J54)","v":5163}]
[]
[null,"구분",null,"참여인원","직위","연봉\n(직접입력)","1개월인건비","참여율\n(직접입력)","참여기간\n(직접입력)","현금(천원)","현물(천원)\n(직접입력)","합계"]
[null,"기존인력\n인건비",null,"홍길동 1","본부장",60000,{"$f":"F5/12","v":5000},0.5,12,{"$f":"L5-K5","v":5000},25000,{"$f":"G5*H5*I5","v":30000}]
[null,null,null,"홍길동 2","팀장",50000,{"$f":"F6/12","v":4166.666666666667},0.5,12,{"$f":"L6-K6","v":25000},0,{"$f":"G6*H6*I6","v":25000}]
[null,null,null,"홍길동 3","팀원",40000,3333.3333333333335,0.5,12,20000,0,20000]
[null,null,null,"홍길동 4","팀원",30000,2500,0.5,12,15000,0,15000]
[null,null,null,"홍길동 5","팀원",20000,1666.6666666666667,0.5,12,10000,0,10000,{"$nulls":39},"연구시설장비비","시약/재료구입비","지식재산 창출 활동비","인력지원비"]
[null,null,null,"기존인력 인건비합계",{"$nulls":5},{"$f":"SUM(J5:J9)","v":75000},{"$f":"SUM(K5:K9)","v":25000},{"$f":"SUM(L5:L9)","v":100000},{"$nulls":40},"시작품/시제품 제작경비","외부전문기술활용비","연구지원비"]
[null,"신규인력\n인건비",null,"홍길동 6","팀장",50000,{"$f":"F11/12","v":4166.666666666667},0.66,12,{"$f":"L11-K11","v":33000.000000000007},0,{"$f":"G11*H11*I11","v":33000.000000000007},{"$nulls":41},"회의비","성과활용지원비"]
[null,null,null,"홍길동 7","팀원",40000,3333.3333333333335,0.5,12,20000,0,{"$f":"G12*H12*I12","v":20000},{"$nulls":41},"국내여비"]
[null,null,null,"홍길동 8","팀원",30000,2500,0.5,12,15000,0,15000,{"$nulls":41},"국외여비"]
[null,null,null,"신규인력 인건비합계",{"$nulls":5},{"$f":"SUM(J11:J13)","v":68000},{"$f":"SUM(K11:K13)","v":0},{"$f":"SUM(L11:L13)","v":68000},{"$nulls":41},"소프트웨어활용비"]
[null,"인건비 전체 합계",{"$nulls":7},{"$f":"J10+J14","v":143000},{"$f":"K10+K14","v":25000},{"$f":"L10+L14","v":168000},{"$nulls":41},"사무용품"]
[{"$nulls":53},"연구인력지원비"]
[null,null,"구분",null,"내역(품명)",null,"규격","수량","단가","현금(천원)","현물(천원)","합계",{"$nulls":41},"기타"]
[null,"연구시설/장비비","연구시설장비비",{"$nulls":4},1,0,{"$f":"L18-K18","v":0},0,{"$f":"H18*I18","v":0},{"$nulls":41},"회계정산비용"]
[{"$nulls":9},{"$f":"L19-K19","v":0},0,{"$f":"H19*I19","v":0}]
[{"$nulls":9},0,0,0]
[null,null,"연구시설장비비",{"$nulls":4},1,5000000,5000000,0,5000000]
[{"$nulls":8},0,0,0,{"$f":"H22*I22","v":0}]
[{"$nulls":9},{"$f":"L23-K23","v":0},0,{"$f":"H23*I23","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":8},0,0,0,{"$f":"H25*I25","v":0}]
[null,null,"연구장비 합계",{"$nulls":6},{"$f":"SUM(J18:J25)","v":5000000},{"$f":"SUM(K18:K25)","v":0},{"$f":"SUM(L18:L25)","v":5000000}]
[null,"연구재료비","시약/재료구입비",{"$nulls":4},1,0,{"$f":"L27-K27","v":0},0,{"$f":"H27*I27","v":0}]
[null,null,"시작품/시제품 제작경비",{"$nulls":4},1,10000,10000,0,{"$f":"H28*I28","v":10000}]
[{"$nulls":9},{"$f":"L29-K29","v":0},0,{"$f":"H29*I29","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,{"$f":"H37*I37","v":0}]
[null,null,"연구재료비 합계",{"$nulls":6},{"$f":"SUM(J27:J37)","v":10000},{"$f":"SUM(K27:K37)","v":0},{"$f":"SUM(L27:L37)","v":10000}]
[null,"연구활동비","국외여비",{"$nulls":6},{"$f":"L39-K39","v":0},0,{"$f":"H39*I39","v":0}]
[null,null,"수용비 및 수수료",null,"위탁정산비용",null,"회",1,1067,{"$f":"L40-K40","v":1067},0,{"$f":"H40*I40","v":1067}]
[null,null,"외부전문기술활용비",null,"공인인증시험비",null,"회",1,{"$f":"4933+230","v":5163},{"$f":"L41-K41","v":5163},0,{"$f":"H41*I41","v":5163}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":7},1,20000,20000,0,20000]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},{"$f":"L50-K50","v":5163},0,{"$f":"H41*I41","v":5163}]
[null,null,"회계정산비용(필수)",null,"회계정산비용",null,null,1,9154,9154,0,{"$f":"H51*I51","v":9154}]
[null,null,"연구활동비 합계",{"$nulls":6},{"$f":"SUM(J39:J51)","v":40547},{"$f":"SUM(K39:K51)","v":0},{"$f":"SUM(L39:L51)","v":40547}]
[null,"위탁연구개발비","위탁연구개발비",{"$nulls":4},1,50000,{"$f":"L53-K53","v":50000},0,{"$f":"H53*I53","v":50000}]
[null,null,"위탁연구개발비 합계",{"$nulls":6},{"$f":"SUM(J53:J53)","v":50000},{"$f":"SUM(K53:K53)","v":0},{"$f":"SUM(L53:L53)","v":50000}]
[null,"연구장비, 연구재료비, 연구활동비, 위탁연구개발비 합계",{"$nulls":7},{"$f":"SUM(J26,J54,J52,J38)","v":5100547},{"$f":"SUM(K26,K54,K52,K38)","v":0},{"$f":"SUM(L26,L54,L52,L38)","v":5100547}]
[null,"직접비(인건비 포함) 합계",{"$nulls":7},{"$f":"SUM(J15+J55)","v":5243547},{"$f":"SUM(K15+K55)","v":25000},{"$f":"SUM(L15+L55)","v":5268547}]
[]
[null,"구분",null,"내역(품명)",null,null,"규격","수량","단가","현금(천원)","현물(천원)","합계"]
[null,null,"성과활용지원비",null,null,null,"회",null,200,{"$f":"L59-K59","v":200},0,{"$f":"I59","v":200}]
[{"$nulls":6},"회",null,100,100,0,{"$f":"I60","v":100}]
[null,null,null,"성과활용지원비 소계",{"$nulls":5},{"$f":"SUM(J59:J60)","v":300},{"$f":"SUM(K59:K60)","v":0},300]
[null,null,"간접비 합계",{"$nulls":6},{"$f":"J61","v":300},{"$f":"K61","v":0},{"$f":"L61","v":300}]
[]
[{"$nulls":9},"현금","현물","합계"]
[null,"직접비 합계",{"$nulls":7},{"$f":"J56","v":5243547},{"$f":"K56","v":25000},{"$f":"L56","v":5268547}]
[null,"간접비 합계",{"$nulls":7},{"$f":"J62","v":300},{"$f":"K62","v":0},{"$f":"L62","v":300}]
[null,"사업비합계",{"$nulls":7},{"$f":"SUM(J65:J66)","v":5243847},{"$f":"SUM(K65:K66)","v":25000},5268847]
[]
[]
[null,"비 목",null,"현 금","현 물","계 "]
[null,"1. 직접비",null,{"$f":"D74+D75+D76+D77+D78","v":5243547},{"$f":"E74+E75+E76+E77+E78","v":25000},{"$f":"F74+F75+F76+F77+F78","v":5268547}]
[null,"1.1 인건비","1.1.1 기존인건비",{"$f":"J10","v":75000},{"$f":"K10","v":25000},{"$f":"D72+E72","v":100000}]
[null,null,"1.1.2 신규인건비",{"$f":"J14","v":68000},{"$f":"K14","v":0},68000]
[null,"인건비소계",null,{"$f":"D72+D73","v":143000},{"$f":"E72+E73","v":25000},168000]
[null,"1.3 연구장비",null,{"$f":"J26","v":5000000},{"$f":"K26","v":0},5000000]
[null,"1.4 연구재료비",null,{"$f":"J38","v":10000},{"$f":"K38","v":0},10000]
[null,"1.5 연구활동비",null,{"$f":"J52","v":40547},{"$f":"K52","v":0},40547]
[null,"1.7 위탁연구개발비",null,{"$f":"J54","v":50000},{"$f":"K54","v":0},50000]
[null,"2. 간접비",null,{"$f":"D80","v":300},{"$f":"E80","v":0},300]
[null,"2.1 성과활용지원비",null,{"$f":"J61","v":300},{"$f":"K61","v":0},300]
[null,"사업비합계",null,{"$f":"D71+D79","v":5243847},{"$f":"E71+E79","v":25000},5268847]

{"sheet":"2차년도","index":3,"n_rows":81,"n_cols":55,"rows_kept":81,"cut":false,"hidden":false,"merged":[[73,1,73,2],[60,3,60,8],[61,2,61,8],[63,1,63,8],[64,1,64,8],[65,1,65,8],[66,1,66,8],[58,1,61,1],[58,2,60,2],[52,1,53,1],[53,2,53,8],[54,1,54,8],[55,1,55,8],[57,1,57,2],[38,1,51,1],[51,2,51,8],[1,1,1,12],[4,1,9,1],[9,3,9,8],[10,1,13,1],[13,3,13,8],[14,1,14,8],[16,2,16,3],[17,1,25,1],[25,2,25,8],[26,1,37,1],[37,2,37,8]]}
[{"$nulls":38},"시작품/시제품 제작경비","외부전문기술활용비"]
[null,"국방벤처 혁신기술 사업비소요명세서 자동계산 엑셀 (단위 : 천원)",{"$nulls":36},{"$f":"SUMIF(C18:I54,\"시작품/시제품 제작경비\",J18:J54)","v":10000},{"$f":"SUMIF(C18:I54,\"외부전문기술활용비\",J18:J54)","v":5163}]
[]
[null,"구분",null,"참여인원","직위","연봉\n(직접입력)","1개월인건비","참여율\n(직접입력)","참여기간\n(직접입력)","현금(천원)","현물(천원)\n(직접입력)","합계"]
[null,"기존인력\n인건비",null,"홍길동 1","본부장",60000,{"$f":"F5/12","v":5000},0.5,12,{"$f":"L5-K5","v":5000},25000,{"$f":"G5*H5*I5","v":30000}]
[null,null,null,"홍길동 2","팀장",50000,{"$f":"F6/12","v":4166.666666666667},0.5,12,{"$f":"L6-K6","v":25000},0,{"$f":"G6*H6*I6","v":25000}]
[null,null,null,"홍길동 3","팀원",40000,3333.3333333333335,0.5,12,20000,0,20000]
[null,null,null,"홍길동 4","팀원",30000,2500,0.5,12,15000,0,15000]
[null,null,null,"홍길동 5","팀원",20000,1666.6666666666667,0.5,12,10000,0,10000,{"$nulls":39},"연구시설장비비","시약/재료구입비","지식재산 창출 활동비","인력지원비"]
[null,null,null,"기존인력 인건비합계",{"$nulls":5},{"$f":"SUM(J5:J9)","v":75000},{"$f":"SUM(K5:K9)","v":25000},{"$f":"SUM(L5:L9)","v":100000},{"$nulls":40},"시작품/시제품 제작경비","외부전문기술활용비","연구지원비"]
[null,"신규인력\n인건비",null,"홍길동 6","팀장",50000,{"$f":"F11/12","v":4166.666666666667},0.66,12,{"$f":"L11-K11","v":33000.000000000007},0,{"$f":"G11*H11*I11","v":33000.000000000007},{"$nulls":41},"회의비","성과활용지원비"]
[null,null,null,"홍길동 7","팀원",40000,3333.3333333333335,0.5,12,20000,0,{"$f":"G12*H12*I12","v":20000},{"$nulls":41},"국내여비"]
[null,null,null,"홍길동 8","팀원",30000,2500,0.5,12,15000,0,15000,{"$nulls":41},"국외여비"]
[null,null,null,"신규인력 인건비합계",{"$nulls":5},{"$f":"SUM(J11:J13)","v":68000},{"$f":"SUM(K11:K13)","v":0},{"$f":"SUM(L11:L13)","v":68000},{"$nulls":41},"소프트웨어활용비"]
[null,"인건비 전체 합계",{"$nulls":7},{"$f":"J10+J14","v":143000},{"$f":"K10+K14","v":25000},{"$f":"L10+L14","v":168000},{"$nulls":41},"사무용품"]
[{"$nulls":53},"연구인력지원비"]
[null,null,"구분",null,"내역(품명)",null,"규격","수량","단가","현금(천원)","현물(천원)","합계",{"$nulls":41},"기타"]
[null,"연구시설/장비비","연구시설장비비",{"$nulls":4},1,0,{"$f":"L18-K18","v":0},0,{"$f":"H18*I18","v":0},{"$nulls":41},"회계정산비용"]
[{"$nulls":9},0,0,{"$f":"H19*I19","v":0}]
[{"$nulls":9},0,0,0]
[null,null,"연구시설장비비",{"$nulls":4},1,5000000,5000000,0,5000000]
[{"$nulls":8},0,0,0,{"$f":"H22*I22","v":0}]
[{"$nulls":9},0,0,{"$f":"H23*I23","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":8},0,0,0,0]
[null,null,"연구장비 합계",{"$nulls":6},{"$f":"SUM(J18:J25)","v":5000000},{"$f":"SUM(K18:K25)","v":0},{"$f":"SUM(L18:L25)","v":5000000}]
[null,"연구재료비","시약/재료구입비",{"$nulls":4},1,0,{"$f":"L27-K27","v":0},0,{"$f":"H27*I27","v":0}]
[null,null,"시작품/시제품 제작경비",{"$nulls":4},1,10000,10000,0,{"$f":"H28*I28","v":10000}]
[{"$nulls":9},0,0,{"$f":"H29*I29","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[null,null,"연구재료비 합계",{"$nulls":6},{"$f":"SUM(J27:J37)","v":10000},{"$f":"SUM(K27:K37)","v":0},{"$f":"SUM(L27:L37)","v":10000}]
[null,"연구활동비","국외여비",{"$nulls":6},{"$f":"L39-K39","v":0},0,{"$f":"H39*I39","v":0}]
[null,null,"수용비 및 수수료",null,"위탁정산비용",null,"회",1,1067,{"$f":"L40-K40","v":1067},0,{"$f":"H40*I40","v":1067}]
[null,null,"외부전문기술활용비",null,"공인인증시험비",null,"회",1,{"$f":"4933+230","v":5163},5163,0,{"$f":"H41*I41","v":5163}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":7},1,20000,20000,0,20000]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},{"$f":"L50-K50","v":5163},0,{"$f":"H41*I41","v":5163}]
[null,null,"회계정산비용(필수)",null,"회계정산비용",null,null,1,9154,9154,0,{"$f":"H51*I51","v":9154}]
[null,null,"연구활동비 합계",{"$nulls":6},{"$f":"SUM(J39:J51)","v":40547},{"$f":"SUM(K39:K51)","v":0},{"$f":"SUM(L39:L51)","v":40547}]
[null,"위탁연구개발비","위탁연구개발비",{"$nulls":4},1,50000,{"$f":"L53-K53","v":50000},0,{"$f":"H53*I53","v":50000}]
[null,null,"위탁연구개발비 합계",{"$nulls":6},{"$f":"SUM(J53:J53)","v":50000},{"$f":"SUM(K53:K53)","v":0},{"$f":"SUM(L53:L53)","v":50000}]
[null,"연구장비, 연구재료비, 연구활동비, 위탁연구개발비 합계",{"$nulls":7},{"$f":"SUM(J26,J54,J52,J38)","v":5100547},{"$f":"SUM(K26,K54,K52,K38)","v":0},{"$f":"SUM(L26,L54,L52,L38)","v":5100547}]
[null,"직접비(인건비 포함) 합계",{"$nulls":7},{"$f":"SUM(J15+J55)","v":5243547},{"$f":"SUM(K15+K55)","v":25000},{"$f":"SUM(L15+L55)","v":5268547}]
[]
[null,"구분",null,"내역(품명)",null,null,"규격","수량","단가","현금(천원)","현물(천원)","합계"]
[null,null,"성과활용지원비",null,null,null,"회",null,200,{"$f":"L59-K59","v":200},0,{"$f":"I59","v":200}]
[{"$nulls":6},"회",null,100,100,0,{"$f":"I60","v":100}]
[null,null,null,"성과활용지원비 소계",{"$nulls":5},{"$f":"SUM(J59:J60)","v":300},{"$f":"SUM(K59:K60)","v":0},300]
[null,null,"간접비 합계",{"$nulls":6},{"$f":"J61","v":300},{"$f":"K61","v":0},{"$f":"L61","v":300}]
[]
[{"$nulls":9},"현금","현물","합계"]
[null,"직접비 합계",{"$nulls":7},{"$f":"J56","v":5243547},{"$f":"K56","v":25000},{"$f":"L56","v":5268547}]
[null,"간접비 합계",{"$nulls":7},{"$f":"J62","v":300},{"$f":"K62","v":0},{"$f":"L62","v":300}]
[null,"사업비합계",{"$nulls":7},{"$f":"SUM(J65:J66)","v":5243847},{"$f":"SUM(K65:K66)","v":25000},5268847]
[]
[]
[null,"비 목",null,"현 금","현 물","계 "]
[null,"1. 직접비",null,{"$f":"D74+D75+D76+D77+D78","v":5243547},{"$f":"E74+E75+E76+E77+E78","v":25000},{"$f":"F74+F75+F76+F77+F78","v":5268547}]
[null,"1.1 인건비","1.1.1 기존인건비",{"$f":"J10","v":75000},{"$f":"K10","v":25000},{"$f":"D72+E72","v":100000}]
[null,null,"1.1.2 신규인건비",{"$f":"J14","v":68000},{"$f":"K14","v":0},68000]
[null,"인건비소계",null,{"$f":"D72+D73","v":143000},{"$f":"E72+E73","v":25000},168000]
[null,"1.3 연구장비",null,{"$f":"J26","v":5000000},{"$f":"K26","v":0},5000000]
[null,"1.4 연구재료비",null,{"$f":"J38","v":10000},{"$f":"K38","v":0},10000]
[null,"1.5 연구활동비",null,{"$f":"J52","v":40547},{"$f":"K52","v":0},40547]
[null,"1.7 위탁연구개발비",null,{"$f":"J54","v":50000},{"$f":"K54","v":0},50000]
[null,"2. 간접비",null,{"$f":"D80","v":300},{"$f":"E80","v":0},300]
[null,"2.1 성과활용지원비",null,{"$f":"J61","v":300},{"$f":"K61","v":0},{"$f":"D80+E80","v":300}]
[null,"사업비합계",null,{"$f":"D71+D79","v":5243847},{"$f":"E71+E79","v":25000},5268847]

{"sheet":"3차년도","index":4,"n_rows":81,"n_cols":55,"rows_kept":81,"cut":false,"hidden":false,"merged":[[73,1,73,2],[60,3,60,8],[61,2,61,8],[63,1,63,8],[64,1,64,8],[65,1,65,8],[66,1,66,8],[58,1,61,1],[58,2,60,2],[52,1,53,1],[53,2,53,8],[54,1,54,8],[55,1,55,8],[57,1,57,2],[38,1,51,1],[51,2,51,8],[1,1,1,12],[4,1,9,1],[9,3,9,8],[10,1,13,1],[13,3,13,8],[14,1,14,8],[16,2,16,3],[17,1,25,1],[25,2,25,8],[26,1,37,1],[37,2,37,8]]}
[{"$nulls":38},"시작품/시제품 제작경비","외부전문기술활용비"]
[null,"국방벤처 혁신기술 사업비소요명세서 자동계산 엑셀 (단위 : 천원)",{"$nulls":36},{"$f":"SUMIF(C18:I54,\"시작품/시제품 제작경비\",J18:J54)","v":10000},{"$f":"SUMIF(C18:I54,\"외부전문기술활용비\",J18:J54)","v":5163}]
[]
[null,"구분",null,"참여인원","직위","연봉\n(직접입력)","1개월인건비","참여율\n(직접입력)","참여기간\n(직접입력)","현금(천원)","현물(천원)\n(직접입력)","합계"]
[null,"기존인력\n인건비",null,"홍길동 1","본부장",60000,{"$f":"F5/12","v":5000},0.5,12,{"$f":"L5-K5","v":5000},25000,{"$f":"G5*H5*I5","v":30000}]
[null,null,null,"홍길동 2","팀장",50000,{"$f":"F6/12","v":4166.666666666667},0.5,12,{"$f":"L6-K6","v":25000},0,{"$f":"G6*H6*I6","v":25000}]
[null,null,null,"홍길동 3","팀원",40000,3333.3333333333335,0.5,12,20000,0,20000]
[null,null,null,"홍길동 4","팀원",30000,2500,0.5,12,15000,0,15000]
[null,null,null,"홍길동 5","팀원",20000,1666.6666666666667,0.5,12,10000,0,10000,{"$nulls":39},"연구시설장비비","시약/재료구입비","지식재산 창출 활동비","인력지원비"]
[null,null,null,"기존인력 인건비합계",{"$nulls":5},{"$f":"SUM(J5:J9)","v":75000},{"$f":"SUM(K5:K9)","v":25000},{"$f":"SUM(L5:L9)","v":100000},{"$nulls":40},"시작품/시제품 제작경비","외부전문기술활용비","연구지원비"]
[null,"신규인력\n인건비",null,"홍길동 6","팀장",50000,{"$f":"F11/12","v":4166.666666666667},0.66,12,{"$f":"L11-K11","v":33000.000000000007},0,{"$f":"G11*H11*I11","v":33000.000000000007},{"$nulls":41},"회의비","성과활용지원비"]
[null,null,null,"홍길동 7","팀원",40000,3333.3333333333335,0.5,12,20000,0,{"$f":"G12*H12*I12","v":20000},{"$nulls":41},"국내여비"]
[null,null,null,"홍길동 8","팀원",30000,2500,0.5,12,15000,0,15000,{"$nulls":41},"국외여비"]
[null,null,null,"신규인력 인건비합계",{"$nulls":5},{"$f":"SUM(J11:J13)","v":68000},{"$f":"SUM(K11:K13)","v":0},{"$f":"SUM(L11:L13)","v":68000},{"$nulls":41},"소프트웨어활용비"]
[null,"인건비 전체 합계",{"$nulls":7},{"$f":"J10+J14","v":143000},{"$f":"K10+K14","v":25000},{"$f":"L10+L14","v":168000},{"$nulls":41},"사무용품"]
[{"$nulls":53},"연구인력지원비"]
[null,null,"구분",null,"내역(품명)",null,"규격","수량","단가","현금(천원)","현물(천원)","합계",{"$nulls":41},"기타"]
[null,"연구시설/장비비","연구시설장비비",{"$nulls":4},1,0,{"$f":"L18-K18","v":0},0,{"$f":"H18*I18","v":0},{"$nulls":41},"회계정산비용"]
[{"$nulls":9},0,0,{"$f":"H19*I19","v":0}]
[{"$nulls":9},0,0,0]
[null,null,"연구시설장비비",{"$nulls":4},1,5000000,5000000,0,5000000]
[{"$nulls":8},0,0,0,{"$f":"H22*I22","v":0}]
[{"$nulls":9},0,0,{"$f":"H23*I23","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":8},0,0,0,0]
[null,null,"연구장비 합계",{"$nulls":6},{"$f":"SUM(J18:J25)","v":5000000},{"$f":"SUM(K18:K25)","v":0},{"$f":"SUM(L18:L25)","v":5000000}]
[null,"연구재료비","시약/재료구입비",{"$nulls":4},1,0,{"$f":"L27-K27","v":0},0,{"$f":"H27*I27","v":0}]
[null,null,"시작품/시제품 제작경비",{"$nulls":4},1,10000,10000,0,{"$f":"H28*I28","v":10000}]
[{"$nulls":9},0,0,{"$f":"H29*I29","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[null,null,"연구재료비 합계",{"$nulls":6},{"$f":"SUM(J27:J37)","v":10000},{"$f":"SUM(K27:K37)","v":0},{"$f":"SUM(L27:L37)","v":10000}]
[null,"연구활동비","국외여비",{"$nulls":6},{"$f":"L39-K39","v":0},0,{"$f":"H39*I39","v":0}]
[null,null,"수용비 및 수수료",null,"위탁정산비용",null,"회",1,1067,{"$f":"L40-K40","v":1067},0,{"$f":"H40*I40","v":1067}]
[null,null,"외부전문기술활용비",null,"공인인증시험비",null,"회",1,{"$f":"4933+230","v":5163},5163,0,{"$f":"H41*I41","v":5163}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":7},1,20000,20000,0,20000]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},{"$f":"L50-K50","v":5163},0,{"$f":"H41*I41","v":5163}]
[null,null,"회계정산비용(필수)",null,"회계정산비용",null,null,1,9154,9154,0,{"$f":"H51*I51","v":9154}]
[null,null,"연구활동비 합계",{"$nulls":6},{"$f":"SUM(J39:J51)","v":40547},{"$f":"SUM(K39:K51)","v":0},{"$f":"SUM(L39:L51)","v":40547}]
[null,"위탁연구개발비","위탁연구개발비",{"$nulls":4},1,50000,{"$f":"L53-K53","v":50000},0,{"$f":"H53*I53","v":50000}]
[null,null,"위탁연구개발비 합계",{"$nulls":6},{"$f":"SUM(J53:J53)","v":50000},{"$f":"SUM(K53:K53)","v":0},{"$f":"SUM(L53:L53)","v":50000}]
[null,"연구장비, 연구재료비, 연구활동비, 위탁연구개발비 합계",{"$nulls":7},{"$f":"SUM(J26,J54,J52,J38)","v":5100547},{"$f":"SUM(K26,K54,K52,K38)","v":0},{"$f":"SUM(L26,L54,L52,L38)","v":5100547}]
[null,"직접비(인건비 포함) 합계",{"$nulls":7},{"$f":"SUM(J15+J55)","v":5243547},{"$f":"SUM(K15+K55)","v":25000},{"$f":"SUM(L15+L55)","v":5268547}]
[]
[null,"구분",null,"내역(품명)",null,null,"규격","수량","단가","현금(천원)","현물(천원)","합계"]
[null,null,"성과활용지원비",null,null,null,"회",null,200,{"$f":"L59-K59","v":200},0,{"$f":"I59","v":200}]
[{"$nulls":6},"회",null,100,100,0,{"$f":"I60","v":100}]
[null,null,null,"성과활용지원비 소계",{"$nulls":5},{"$f":"SUM(J59:J60)","v":300},{"$f":"SUM(K59:K60)","v":0},300]
[null,null,"간접비 합계",{"$nulls":6},{"$f":"J61","v":300},{"$f":"K61","v":0},{"$f":"L61","v":300}]
[]
[{"$nulls":9},"현금","현물","합계"]
[null,"직접비 합계",{"$nulls":7},{"$f":"J56","v":5243547},{"$f":"K56","v":25000},{"$f":"L56","v":5268547}]
[null,"간접비 합계",{"$nulls":7},{"$f":"J62","v":300},{"$f":"K62","v":0},{"$f":"L62","v":300}]
[null,"사업비합계",{"$nulls":7},{"$f":"SUM(J65:J66)","v":5243847},{"$f":"SUM(K65:K66)","v":25000},5268847]
[]
[]
[null,"비 목",null,"현 금","현 물","계 "]
[null,"1. 직접비",null,{"$f":"D74+D75+D76+D77+D78","v":5243547},{"$f":"E74+E75+E76+E77+E78","v":25000},{"$f":"F74+F75+F76+F77+F78","v":5268547}]
[null,"1.1 인건비","1.1.1 기존인건비",{"$f":"J10","v":75000},{"$f":"K10","v":25000},{"$f":"D72+E72","v":100000}]
[null,null,"1.1.2 신규인건비",{"$f":"J14","v":68000},{"$f":"K14","v":0},68000]
[null,"인건비소계",null,{"$f":"D72+D73","v":143000},{"$f":"E72+E73","v":25000},168000]
[null,"1.3 연구장비",null,{"$f":"J26","v":5000000},{"$f":"K26","v":0},5000000]
[null,"1.4 연구재료비",null,{"$f":"J38","v":10000},{"$f":"K38","v":0},10000]
[null,"1.5 연구활동비",null,{"$f":"J52","v":40547},{"$f":"K52","v":0},40547]
[null,"1.7 위탁연구개발비",null,{"$f":"J54","v":50000},{"$f":"K54","v":0},50000]
[null,"2. 간접비",null,{"$f":"D80","v":300},{"$f":"E80","v":0},300]
[null,"2.1 성과활용지원비",null,{"$f":"J61","v":300},{"$f":"K61","v":0},{"$f":"D80+E80","v":300}]
[null,"사업비합계",null,{"$f":"D71+D79","v":5243847},{"$f":"E71+E79","v":25000},5268847]

{"sheet":"1.사업비 총괄(공동)","index":5,"n_rows":47,"n_cols":9,"rows_kept":47,"cut":false,"hidden":false,"merged":[[1,1,1,6],[18,1,18,4],[28,1,28,4],[38,1,38,4]]}
[]
[null,"혁신기술 지원사업 사업비 기준 (단위 : 천원)"]
[null,"1) 정부지원금 75%, 민간부담금 25% "]
[null,"2) 민간 현금/현물 비율 (현금 10% 이상)",null,null,null,"소프트웨어 개발 과제여부\n(예/아니오)","아니오"]
[null,"연차","정부지원금","민간합계","민간현금","민간현물","총사업비합계"]
[null,"1차년도",0,{"$f":"E6+F6","v":0},0,0,{"$f":"C6+D6","v":0}]
[null,"2차년도",0,{"$f":"E7+F7","v":0},0,0,{"$f":"C7+D7","v":0}]
[null,"3차년도",0,{"$f":"E8+F8","v":0},0,0,{"$f":"C8+D8","v":0}]
[null,"합계",{"$f":"SUM(C6:C8)","v":0},{"$f":"SUM(D6:D8)","v":0},{"$f":"SUM(E6:E8)","v":0},{"$f":"SUM(F6:F8)","v":0},{"$f":"SUM(G6:G8)","v":0}]
[null,"%",{"$f":"C9/G9","v":{"$error":"#DIV/0!"}},{"$f":"D9/G9","v":{"$error":"#DIV/0!"}},{"$f":"E9/D9","v":{"$error":"#DIV/0!"}},{"$f":"F9/D9","v":{"$error":"#DIV/0!"}}]
[{"$nulls":8},"비율"]
[{"$nulls":5},"인건비 계상비율",{"$f":"IF($G$4=\"아니오\",IF($I$12>50%,\"초과\",\"가능\"),\"가능\")","v":{"$error":"#DIV/0!"}},"50%이내, 소프트웨어는 50%이상 가능",{"$f":"($E$21+$E$31+$E$41)/$G$9","v":{"$error":"#DIV/0!"}}]
[null,null,"현금","현물",null,"간접비 계상비율",{"$f":"IF($I$13>10%,\"초과\",\"가능\")","v":{"$error":"#DIV/0!"}},"10%이내, 직접비(현물 및 위탁개발비 제외)",{"$f":"(C27+C37+C47)/(SUM(C21:C24)+SUM(C31:C34)+SUM(C41:C44))","v":{"$error":"#DIV/0!"}}]
[null,"1차년도",{"$f":"SUM(C26:C27)","v":0},{"$f":"SUM(D26:D27)","v":0},null,"위탁연구비 계상비율",{"$f":"IF($I$14>40%,\"초과\",\"가능\")","v":{"$error":"#DIV/0!"}},"40%이내, 직접비(현물포함)",{"$f":"(E25+E35+E45)/(E26+E36+E46)","v":{"$error":"#DIV/0!"}}]
[null,"2차년도",{"$f":"SUM(C36:C37)","v":0},{"$f":"SUM(D36:D37)","v":0},null,"시제품제작비 계상비율",{"$f":"IF($I$15>50%,\"초과\",\"가능\")","v":{"$error":"#DIV/0!"}},"50%이내, 직접비(현물포함)",{"$f":"('1차년도 (2)'!AM2+'2차년도 (2)'!AM2+'3차년도 (2)'!AM2)/(E26+E36+E46)","v":{"$error":"#DIV/0!"}}]
[null,"3차년도",{"$f":"SUM(C46:C47)","v":0},{"$f":"SUM(D46:D47)","v":0},null,"외부전문기술활용비 계상비율",{"$f":"IF($I$16>40%,\"초과\",\"가능\")","v":{"$error":"#DIV/0!"}},"40%이내, 직접비(현물포함)",{"$f":"('1차년도 (2)'!AN2+'2차년도 (2)'!AN2+'3차년도 (2)'!AN2)/(E26+E36+E46)","v":{"$error":"#DIV/0!"}}]
[null,"합계",{"$f":"SUM(C14:C16)","v":0},{"$f":"SUM(D14:D16)","v":0}]
[]
[null,"1차년도"]
[null,null,"현금","현물","합"]
[null,"1.1 인건비",{"$f":"'1차년도 (2)'!D74","v":0},{"$f":"'1차년도 (2)'!E74","v":0},{"$f":"'1차년도 (2)'!F74","v":0}]
[null,"1.3 연구장비",{"$f":"'1차년도 (2)'!D75","v":0},{"$f":"'1차년도 (2)'!E75","v":0},{"$f":"'1차년도 (2)'!F75","v":0}]
[null,"1.4 연구재료비",{"$f":"'1차년도 (2)'!D76","v":0},{"$f":"'1차년도 (2)'!E76","v":0},{"$f":"'1차년도 (2)'!F76","v":0}]
[null,"1.5 연구활동비",{"$f":"'1차년도 (2)'!D77","v":0},{"$f":"'1차년도 (2)'!E77","v":0},{"$f":"'1차년도 (2)'!F77","v":0}]
[null,"1.7 위탁연구개발비",{"$f":"'1차년도 (2)'!D78","v":0},{"$f":"'1차년도 (2)'!E78","v":0},{"$f":"'1차년도 (2)'!F78","v":0}]
[null,"1. 직접비",{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D21:D25)","v":0},{"$f":"SUM(E21:E25)","v":0}]
[null,"2. 간접비",{"$f":"'1차년도 (2)'!J62","v":0},{"$f":"'1차년도 (2)'!K62","v":0},{"$f":"'1차년도 (2)'!L62","v":0}]
[]
[null,"2차년도"]
[null,null,"현금","현물","합"]
[null,"1.1 인건비",{"$f":"'2차년도 (2)'!D74","v":0},{"$f":"'2차년도 (2)'!E74","v":0},{"$f":"'2차년도 (2)'!F74","v":0}]
[null,"1.3 연구장비",{"$f":"'2차년도 (2)'!D75","v":0},{"$f":"'2차년도 (2)'!E75","v":0},{"$f":"'2차년도 (2)'!F75","v":0}]
[null,"1.4 연구재료비",{"$f":"'2차년도 (2)'!D76","v":0},{"$f":"'2차년도 (2)'!E76","v":0},{"$f":"'2차년도 (2)'!F76","v":0}]
[null,"1.5 연구활동비",{"$f":"'2차년도 (2)'!D77","v":0},{"$f":"'2차년도 (2)'!E77","v":0},{"$f":"'2차년도 (2)'!F77","v":0}]
[null,"1.7 위탁연구개발비",{"$f":"'2차년도 (2)'!D78","v":0},{"$f":"'2차년도 (2)'!E78","v":0},{"$f":"'2차년도 (2)'!F78","v":0}]
[null,"1. 직접비",{"$f":"SUM(C31:C35)","v":0},{"$f":"SUM(D31:D35)","v":0},{"$f":"SUM(E31:E35)","v":0}]
[null,"2. 간접비",{"$f":"'1차년도 (2)'!J72","v":0},{"$f":"'1차년도 (2)'!K72","v":0},{"$f":"'1차년도 (2)'!L72","v":0}]
[]
[null,"3차년도"]
[null,null,"현금","현물","합"]
[null,"1.1 인건비",{"$f":"'3차년도 (2)'!D74","v":0},{"$f":"'3차년도 (2)'!E74","v":0},{"$f":"'3차년도 (2)'!F74","v":0}]
[null,"1.3 연구장비",{"$f":"'3차년도 (2)'!D75","v":0},{"$f":"'3차년도 (2)'!E75","v":0},{"$f":"'3차년도 (2)'!F75","v":0}]
[null,"1.4 연구재료비",{"$f":"'3차년도 (2)'!D76","v":0},{"$f":"'3차년도 (2)'!E76","v":0},{"$f":"'3차년도 (2)'!F76","v":0}]
[null,"1.5 연구활동비",{"$f":"'3차년도 (2)'!D77","v":0},{"$f":"'3차년도 (2)'!E77","v":0},{"$f":"'3차년도 (2)'!F77","v":0}]
[null,"1.7 위탁연구개발비",{"$f":"'3차년도 (2)'!D78","v":0},{"$f":"'3차년도 (2)'!E78","v":0},{"$f":"'3차년도 (2)'!F78","v":0}]
[null,"1. 직접비",{"$f":"SUM(C41:C45)","v":0},{"$f":"SUM(D41:D45)","v":0},{"$f":"SUM(E41:E45)","v":0}]
[null,"2. 간접비",{"$f":"'1차년도 (2)'!J80","v":0},{"$f":"'1차년도 (2)'!K80","v":0},{"$f":"'1차년도 (2)'!L80","v":0}]

{"sheet":"1차년도 (2)","index":6,"n_rows":81,"n_cols":55,"rows_kept":81,"cut":false,"hidden":false,"merged":[[63,1,63,8],[64,1,64,8],[65,1,65,8],[66,1,66,8],[73,1,73,2],[52,1,53,1],[53,2,53,8],[54,1,54,8],[55,1,55,8],[57,1,57,2],[58,1,61,1],[58,2,60,2],[60,3,60,8],[61,2,61,8],[16,2,16,3],[17,1,25,1],[25,2,25,8],[26,1,37,1],[37,2,37,8],[38,1,51,1],[51,2,51,8],[1,1,1,12],[4,1,9,1],[9,3,9,8],[10,1,13,1],[13,3,13,8],[14,1,14,8]]}
[{"$nulls":38},"시작품/시제품 제작경비","외부전문기술활용비"]
[null,"국방벤처 혁신기술 사업비소요명세서 자동계산 엑셀 (단위 : 천원)",{"$nulls":36},{"$f":"SUMIF(C18:I54,\"시작품/시제품 제작경비\",J18:J54)","v":0},{"$f":"SUMIF(C18:I54,\"외부전문기술활용비\",J18:J54)","v":0}]
[]
[null,"구분",null,"참여인원","직위","연봉\n(직접입력)","1개월인건비","참여율\n(직접입력)","참여기간\n(직접입력)","현금(천원)","현물(천원)\n(직접입력)","합계"]
[null,"기존인력\n인건비",null,"홍길동 1","본부장",60000,{"$f":"F5/12","v":5000},null,12,{"$f":"L5-K5","v":0},null,{"$f":"G5*H5*I5","v":0}]
[null,null,null,"홍길동 2","팀장",50000,{"$f":"F6/12","v":4166.666666666667},null,12,{"$f":"L6-K6","v":0},0,{"$f":"G6*H6*I6","v":0}]
[null,null,null,"홍길동 3","팀원",40000,3333.3333333333335,null,12,0,0,0]
[null,null,null,"홍길동 4","팀원",30000,2500,null,12,0,0,0]
[null,null,null,"홍길동 5","팀원",20000,1666.6666666666667,null,12,0,0,0,{"$nulls":39},"연구시설장비비","시약/재료구입비","지식재산 창출 활동비","인력지원비"]
[null,null,null,"기존인력 인건비합계",{"$nulls":5},{"$f":"SUM(J5:J9)","v":0},{"$f":"SUM(K5:K9)","v":0},{"$f":"SUM(L5:L9)","v":0},{"$nulls":40},"시작품/시제품 제작경비","외부전문기술활용비","연구지원비"]
[null,"신규인력\n인건비",null,"홍길동 6","팀장",50000,{"$f":"F11/12","v":4166.666666666667},null,12,{"$f":"L11-K11","v":0},0,{"$f":"G11*H11*I11","v":0},{"$nulls":41},"회의비","성과활용지원비"]
[null,null,null,"홍길동 7","팀원",40000,3333.3333333333335,null,12,0,0,{"$f":"G12*H12*I12","v":0},{"$nulls":41},"국내여비"]
[null,null,null,"홍길동 8","팀원",30000,2500,null,12,0,0,0,{"$nulls":41},"국외여비"]
[null,null,null,"신규인력 인건비합계",{"$nulls":5},{"$f":"SUM(J11:J13)","v":0},{"$f":"SUM(K11:K13)","v":0},{"$f":"SUM(L11:L13)","v":0},{"$nulls":41},"소프트웨어활용비"]
[null,"인건비 전체 합계",{"$nulls":7},{"$f":"J10+J14","v":0},{"$f":"K10+K14","v":0},{"$f":"L10+L14","v":0},{"$nulls":41},"사무용품"]
[{"$nulls":53},"연구인력지원비"]
[null,null,"구분",null,"내역(품명)",null,"규격","수량","단가","현금(천원)","현물(천원)","합계",{"$nulls":41},"기타"]
[null,"연구시설/장비비","연구시설장비비",{"$nulls":4},1,0,{"$f":"L18-K18","v":0},0,{"$f":"H18*I18","v":0},{"$nulls":41},"회계정산비용"]
[{"$nulls":9},0,0,{"$f":"H19*I19","v":0}]
[{"$nulls":9},0,0,0]
[null,null,"연구시설장비비",{"$nulls":4},1,null,0,0,0]
[{"$nulls":8},0,0,0,{"$f":"H22*I22","v":0}]
[{"$nulls":9},0,0,{"$f":"H23*I23","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":8},0,0,0,0]
[null,null,"연구장비 합계",{"$nulls":6},{"$f":"SUM(J18:J25)","v":0},{"$f":"SUM(K18:K25)","v":0},{"$f":"SUM(L18:L25)","v":0}]
[null,"연구재료비","시약/재료구입비",{"$nulls":6},{"$f":"L27-K27","v":0},0,{"$f":"H27*I27","v":0}]
[null,null,"시작품/시제품 제작경비",{"$nulls":6},0,0,{"$f":"H28*I28","v":0}]
[{"$nulls":9},0,0,{"$f":"H29*I29","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[null,null,"연구재료비 합계",{"$nulls":6},{"$f":"SUM(J27:J37)","v":0},{"$f":"SUM(K27:K37)","v":0},{"$f":"SUM(L27:L37)","v":0}]
[null,"연구활동비","국외여비",{"$nulls":6},{"$f":"L39-K39","v":0},0,{"$f":"H39*I39","v":0}]
[null,null,"수용비 및 수수료",null,"위탁정산비용",null,"회",null,null,{"$f":"L40-K40","v":0},0,{"$f":"H40*I40","v":0}]
[null,null,"외부전문기술활용비",null,"공인인증시험비",null,"회",null,null,0,0,{"$f":"H41*I41","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},{"$f":"L50-K50","v":0},0,{"$f":"H41*I41","v":0}]
[null,null,"회계정산비용(필수)",null,"회계정산비용",{"$nulls":4},0,0,{"$f":"H51*I51","v":0}]
[null,null,"연구활동비 합계",{"$nulls":6},{"$f":"SUM(J39:J51)","v":0},{"$f":"SUM(K39:K51)","v":0},{"$f":"SUM(L39:L51)","v":0}]
[null,"위탁연구개발비","위탁연구개발비",{"$nulls":6},{"$f":"L53-K53","v":0},0,{"$f":"H53*I53","v":0}]
[null,null,"위탁연구개발비 합계",{"$nulls":6},{"$f":"SUM(J53:J53)","v":0},{"$f":"SUM(K53:K53)","v":0},{"$f":"SUM(L53:L53)","v":0}]
[null,"연구장비, 연구재료비, 연구활동비, 위탁연구개발비 합계",{"$nulls":7},{"$f":"SUM(J26,J54,J52,J38)","v":0},{"$f":"SUM(K26,K54,K52,K38)","v":0},{"$f":"SUM(L26,L54,L52,L38)","v":0}]
[null,"직접비(인건비 포함) 합계",{"$nulls":7},{"$f":"SUM(J15+J55)","v":0},{"$f":"SUM(K15+K55)","v":0},{"$f":"SUM(L15+L55)","v":0}]
[]
[null,"구분",null,"내역(품명)",null,null,"규격","수량","단가","현금(천원)","현물(천원)","합계"]
[null,null,"성과활용지원비",null,null,null,"회",null,null,{"$f":"L59-K59","v":0},0,{"$f":"I59","v":0}]
[{"$nulls":6},"회",null,null,0,0,{"$f":"I60","v":0}]
[null,null,null,"성과활용지원비 소계",{"$nulls":5},{"$f":"SUM(J59:J60)","v":0},{"$f":"SUM(K59:K60)","v":0},0]
[null,null,"간접비 합계",{"$nulls":6},{"$f":"J61","v":0},{"$f":"K61","v":0},{"$f":"L61","v":0}]
[]
[{"$nulls":9},"현금","현물","합계"]
[null,"직접비 합계",{"$nulls":7},{"$f":"J56","v":0},{"$f":"K56","v":0},{"$f":"L56","v":0}]
[null,"간접비 합계",{"$nulls":7},{"$f":"J62","v":0},{"$f":"K62","v":0},{"$f":"L62","v":0}]
[null,"사업비합계",{"$nulls":7},{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":0},0]
[]
[]
[null,"비 목",null,"현 금","현 물","계 "]
[null,"1. 직접비",null,{"$f":"D74+D75+D76+D77+D78","v":0},{"$f":"E74+E75+E76+E77+E78","v":0},{"$f":"F74+F75+F76+F77+F78","v":0}]
[null,"1.1 인건비","1.1.1 기존인건비",{"$f":"J10","v":0},{"$f":"K10","v":0},{"$f":"D72+E72","v":0}]
[null,null,"1.1.2 신규인건비",{"$f":"J14","v":0},{"$f":"K14","v":0},0]
[null,"인건비소계",null,{"$f":"D72+D73","v":0},{"$f":"E72+E73","v":0},0]
[null,"1.3 연구장비",null,{"$f":"J26","v":0},{"$f":"K26","v":0},0]
[null,"1.4 연구재료비",null,{"$f":"J38","v":0},{"$f":"K38","v":0},0]
[null,"1.5 연구활동비",null,{"$f":"J52","v":0},{"$f":"K52","v":0},0]
[null,"1.7 위탁연구개발비",null,{"$f":"J54","v":0},{"$f":"K54","v":0},0]
[null,"2. 간접비",null,{"$f":"D80","v":0},{"$f":"E80","v":0},0]
[null,"2.1 성과활용지원비",null,{"$f":"J61","v":0},{"$f":"K61","v":0},0]
[null,"사업비합계",null,{"$f":"D71+D79","v":0},{"$f":"E71+E79","v":0},0]

{"sheet":"2차년도 (2)","index":7,"n_rows":81,"n_cols":55,"rows_kept":81,"cut":false,"hidden":false,"merged":[[63,1,63,8],[64,1,64,8],[65,1,65,8],[66,1,66,8],[73,1,73,2],[52,1,53,1],[53,2,53,8],[54,1,54,8],[55,1,55,8],[57,1,57,2],[58,1,61,1],[58,2,60,2],[60,3,60,8],[61,2,61,8],[16,2,16,3],[17,1,25,1],[25,2,25,8],[26,1,37,1],[37,2,37,8],[38,1,51,1],[51,2,51,8],[1,1,1,12],[4,1,9,1],[9,3,9,8],[10,1,13,1],[13,3,13,8],[14,1,14,8]]}
[{"$nulls":38},"시작품/시제품 제작경비","외부전문기술활용비"]
[null,"국방벤처 혁신기술 사업비소요명세서 자동계산 엑셀 (단위 : 천원)",{"$nulls":36},{"$f":"SUMIF(C18:I54,\"시작품/시제품 제작경비\",J18:J54)","v":0},{"$f":"SUMIF(C18:I54,\"외부전문기술활용비\",J18:J54)","v":0}]
[]
[null,"구분",null,"참여인원","직위","연봉\n(직접입력)","1개월인건비","참여율\n(직접입력)","참여기간\n(직접입력)","현금(천원)","현물(천원)\n(직접입력)","합계"]
[null,"기존인력\n인건비",null,"홍길동 1","본부장",60000,{"$f":"F5/12","v":5000},null,null,{"$f":"L5-K5","v":0},null,{"$f":"G5*H5*I5","v":0}]
[null,null,null,"홍길동 2","팀장",50000,{"$f":"F6/12","v":4166.666666666667},null,null,{"$f":"L6-K6","v":0},0,{"$f":"G6*H6*I6","v":0}]
[null,null,null,"홍길동 3","팀원",40000,3333.3333333333335,null,null,0,0,0]
[null,null,null,"홍길동 4","팀원",30000,2500,null,null,0,0,0]
[null,null,null,"홍길동 5","팀원",20000,1666.6666666666667,null,null,0,0,0,{"$nulls":39},"연구시설장비비","시약/재료구입비","지식재산 창출 활동비","인력지원비"]
[null,null,null,"기존인력 인건비합계",{"$nulls":5},{"$f":"SUM(J5:J9)","v":0},{"$f":"SUM(K5:K9)","v":0},{"$f":"SUM(L5:L9)","v":0},{"$nulls":40},"시작품/시제품 제작경비","외부전문기술활용비","연구지원비"]
[null,"신규인력\n인건비",null,"홍길동 6","팀장",50000,{"$f":"F11/12","v":4166.666666666667},null,null,{"$f":"L11-K11","v":0},0,{"$f":"G11*H11*I11","v":0},{"$nulls":41},"회의비","성과활용지원비"]
[null,null,null,"홍길동 7","팀원",40000,3333.3333333333335,null,null,0,0,{"$f":"G12*H12*I12","v":0},{"$nulls":41},"국내여비"]
[null,null,null,"홍길동 8","팀원",30000,2500,null,null,0,0,0,{"$nulls":41},"국외여비"]
[null,null,null,"신규인력 인건비합계",{"$nulls":5},{"$f":"SUM(J11:J13)","v":0},{"$f":"SUM(K11:K13)","v":0},{"$f":"SUM(L11:L13)","v":0},{"$nulls":41},"소프트웨어활용비"]
[null,"인건비 전체 합계",{"$nulls":7},{"$f":"J10+J14","v":0},{"$f":"K10+K14","v":0},{"$f":"L10+L14","v":0},{"$nulls":41},"사무용품"]
[{"$nulls":53},"연구인력지원비"]
[null,null,"구분",null,"내역(품명)",null,"규격","수량","단가","현금(천원)","현물(천원)","합계",{"$nulls":41},"기타"]
[null,"연구시설/장비비","연구시설장비비",{"$nulls":6},{"$f":"L18-K18","v":0},0,{"$f":"H18*I18","v":0},{"$nulls":41},"회계정산비용"]
[{"$nulls":9},0,0,{"$f":"H19*I19","v":0}]
[{"$nulls":9},0,0,0]
[null,null,"연구시설장비비",{"$nulls":6},0,0,0]
[{"$nulls":9},0,0,{"$f":"H22*I22","v":0}]
[{"$nulls":9},0,0,{"$f":"H23*I23","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[null,null,"연구장비 합계",{"$nulls":6},{"$f":"SUM(J18:J25)","v":0},{"$f":"SUM(K18:K25)","v":0},{"$f":"SUM(L18:L25)","v":0}]
[null,"연구재료비","시약/재료구입비",{"$nulls":6},{"$f":"L27-K27","v":0},0,{"$f":"H27*I27","v":0}]
[null,null,"시작품/시제품 제작경비",{"$nulls":6},0,0,{"$f":"H28*I28","v":0}]
[{"$nulls":9},0,0,{"$f":"H29*I29","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[null,null,"연구재료비 합계",{"$nulls":6},{"$f":"SUM(J27:J37)","v":0},{"$f":"SUM(K27:K37)","v":0},{"$f":"SUM(L27:L37)","v":0}]
[null,"연구활동비","국외여비",{"$nulls":6},{"$f":"L39-K39","v":0},0,{"$f":"H39*I39","v":0}]
[null,null,"수용비 및 수수료",null,"위탁정산비용",null,"회",null,null,{"$f":"L40-K40","v":0},0,{"$f":"H40*I40","v":0}]
[null,null,"외부전문기술활용비",null,"공인인증시험비",null,"회",null,null,0,0,{"$f":"H41*I41","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},{"$f":"L50-K50","v":0},0,{"$f":"H41*I41","v":0}]
[null,null,"회계정산비용(필수)",null,"회계정산비용",{"$nulls":4},0,0,{"$f":"H51*I51","v":0}]
[null,null,"연구활동비 합계",{"$nulls":6},{"$f":"SUM(J39:J51)","v":0},{"$f":"SUM(K39:K51)","v":0},{"$f":"SUM(L39:L51)","v":0}]
[null,"위탁연구개발비","위탁연구개발비",{"$nulls":6},{"$f":"L53-K53","v":0},0,{"$f":"H53*I53","v":0}]
[null,null,"위탁연구개발비 합계",{"$nulls":6},{"$f":"SUM(J53:J53)","v":0},{"$f":"SUM(K53:K53)","v":0},{"$f":"SUM(L53:L53)","v":0}]
[null,"연구장비, 연구재료비, 연구활동비, 위탁연구개발비 합계",{"$nulls":7},{"$f":"SUM(J26,J54,J52,J38)","v":0},{"$f":"SUM(K26,K54,K52,K38)","v":0},{"$f":"SUM(L26,L54,L52,L38)","v":0}]
[null,"직접비(인건비 포함) 합계",{"$nulls":7},{"$f":"SUM(J15+J55)","v":0},{"$f":"SUM(K15+K55)","v":0},{"$f":"SUM(L15+L55)","v":0}]
[]
[null,"구분",null,"내역(품명)",null,null,"규격","수량","단가","현금(천원)","현물(천원)","합계"]
[null,null,"성과활용지원비",null,null,null,"회",null,null,{"$f":"L59-K59","v":0},0,{"$f":"I59","v":0}]
[{"$nulls":6},"회",null,null,0,0,{"$f":"I60","v":0}]
[null,null,null,"성과활용지원비 소계",{"$nulls":5},{"$f":"SUM(J59:J60)","v":0},{"$f":"SUM(K59:K60)","v":0},0]
[null,null,"간접비 합계",{"$nulls":6},{"$f":"J61","v":0},{"$f":"K61","v":0},{"$f":"L61","v":0}]
[]
[{"$nulls":9},"현금","현물","합계"]
[null,"직접비 합계",{"$nulls":7},{"$f":"J56","v":0},{"$f":"K56","v":0},{"$f":"L56","v":0}]
[null,"간접비 합계",{"$nulls":7},{"$f":"J62","v":0},{"$f":"K62","v":0},{"$f":"L62","v":0}]
[null,"사업비합계",{"$nulls":7},{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":0},0]
[]
[]
[null,"비 목",null,"현 금","현 물","계 "]
[null,"1. 직접비",null,{"$f":"D74+D75+D76+D77+D78","v":0},{"$f":"E74+E75+E76+E77+E78","v":0},{"$f":"F74+F75+F76+F77+F78","v":0}]
[null,"1.1 인건비","1.1.1 기존인건비",{"$f":"J10","v":0},{"$f":"K10","v":0},{"$f":"D72+E72","v":0}]
[null,null,"1.1.2 신규인건비",{"$f":"J14","v":0},{"$f":"K14","v":0},0]
[null,"인건비소계",null,{"$f":"D72+D73","v":0},{"$f":"E72+E73","v":0},0]
[null,"1.3 연구장비",null,{"$f":"J26","v":0},{"$f":"K26","v":0},0]
[null,"1.4 연구재료비",null,{"$f":"J38","v":0},{"$f":"K38","v":0},0]
[null,"1.5 연구활동비",null,{"$f":"J52","v":0},{"$f":"K52","v":0},0]
[null,"1.7 위탁연구개발비",null,{"$f":"J54","v":0},{"$f":"K54","v":0},0]
[null,"2. 간접비",null,{"$f":"D80","v":0},{"$f":"E80","v":0},0]
[null,"2.1 성과활용지원비",null,{"$f":"J61","v":0},{"$f":"K61","v":0},{"$f":"D80+E80","v":0}]
[null,"사업비합계",null,{"$f":"D71+D79","v":0},{"$f":"E71+E79","v":0},0]

{"sheet":"3차년도 (2)","index":8,"n_rows":81,"n_cols":55,"rows_kept":81,"cut":false,"hidden":false,"merged":[[63,1,63,8],[64,1,64,8],[65,1,65,8],[66,1,66,8],[73,1,73,2],[52,1,53,1],[53,2,53,8],[54,1,54,8],[55,1,55,8],[57,1,57,2],[58,1,61,1],[58,2,60,2],[60,3,60,8],[61,2,61,8],[16,2,16,3],[17,1,25,1],[25,2,25,8],[26,1,37,1],[37,2,37,8],[38,1,51,1],[51,2,51,8],[1,1,1,12],[4,1,9,1],[9,3,9,8],[10,1,13,1],[13,3,13,8],[14,1,14,8]]}
[{"$nulls":38},"시작품/시제품 제작경비","외부전문기술활용비"]
[null,"국방벤처 혁신기술 사업비소요명세서 자동계산 엑셀 (단위 : 천원)",{"$nulls":36},{"$f":"SUMIF(C18:I54,\"시작품/시제품 제작경비\",J18:J54)","v":0},{"$f":"SUMIF(C18:I54,\"외부전문기술활용비\",J18:J54)","v":0}]
[]
[null,"구분",null,"참여인원","직위","연봉\n(직접입력)","1개월인건비","참여율\n(직접입력)","참여기간\n(직접입력)","현금(천원)","현물(천원)\n(직접입력)","합계"]
[null,"기존인력\n인건비",null,"홍길동 1","본부장",60000,{"$f":"F5/12","v":5000},null,null,{"$f":"L5-K5","v":0},null,{"$f":"G5*H5*I5","v":0}]
[null,null,null,"홍길동 2","팀장",50000,{"$f":"F6/12","v":4166.666666666667},null,null,{"$f":"L6-K6","v":0},0,{"$f":"G6*H6*I6","v":0}]
[null,null,null,"홍길동 3","팀원",40000,3333.3333333333335,null,null,0,0,0]
[null,null,null,"홍길동 4","팀원",30000,2500,null,null,0,0,0]
[null,null,null,"홍길동 5","팀원",20000,1666.6666666666667,null,null,0,0,0,{"$nulls":39},"연구시설장비비","시약/재료구입비","지식재산 창출 활동비","인력지원비"]
[null,null,null,"기존인력 인건비합계",{"$nulls":5},{"$f":"SUM(J5:J9)","v":0},{"$f":"SUM(K5:K9)","v":0},{"$f":"SUM(L5:L9)","v":0},{"$nulls":40},"시작품/시제품 제작경비","외부전문기술활용비","연구지원비"]
[null,"신규인력\n인건비",null,"홍길동 6","팀장",50000,{"$f":"F11/12","v":4166.666666666667},null,null,{"$f":"L11-K11","v":0},0,{"$f":"G11*H11*I11","v":0},{"$nulls":41},"회의비","성과활용지원비"]
[null,null,null,"홍길동 7","팀원",40000,3333.3333333333335,null,null,0,0,{"$f":"G12*H12*I12","v":0},{"$nulls":41},"국내여비"]
[null,null,null,"홍길동 8","팀원",30000,2500,null,null,0,0,0,{"$nulls":41},"국외여비"]
[null,null,null,"신규인력 인건비합계",{"$nulls":5},{"$f":"SUM(J11:J13)","v":0},{"$f":"SUM(K11:K13)","v":0},{"$f":"SUM(L11:L13)","v":0},{"$nulls":41},"소프트웨어활용비"]
[null,"인건비 전체 합계",{"$nulls":7},{"$f":"J10+J14","v":0},{"$f":"K10+K14","v":0},{"$f":"L10+L14","v":0},{"$nulls":41},"사무용품"]
[{"$nulls":53},"연구인력지원비"]
[null,null,"구분",null,"내역(품명)",null,"규격","수량","단가","현금(천원)","현물(천원)","합계",{"$nulls":41},"기타"]
[null,"연구시설/장비비","연구시설장비비",{"$nulls":6},{"$f":"L18-K18","v":0},0,{"$f":"H18*I18","v":0},{"$nulls":41},"회계정산비용"]
[{"$nulls":9},0,0,{"$f":"H19*I19","v":0}]
[{"$nulls":9},0,0,0]
[null,null,"연구시설장비비",{"$nulls":6},0,0,0]
[{"$nulls":9},0,0,{"$f":"H22*I22","v":0}]
[{"$nulls":9},0,0,{"$f":"H23*I23","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[null,null,"연구장비 합계",{"$nulls":6},{"$f":"SUM(J18:J25)","v":0},{"$f":"SUM(K18:K25)","v":0},{"$f":"SUM(L18:L25)","v":0}]
[null,"연구재료비","시약/재료구입비",{"$nulls":6},{"$f":"L27-K27","v":0},0,{"$f":"H27*I27","v":0}]
[null,null,"시작품/시제품 제작경비",{"$nulls":6},0,0,{"$f":"H28*I28","v":0}]
[{"$nulls":9},0,0,{"$f":"H29*I29","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[null,null,"연구재료비 합계",{"$nulls":6},{"$f":"SUM(J27:J37)","v":0},{"$f":"SUM(K27:K37)","v":0},{"$f":"SUM(L27:L37)","v":0}]
[null,"연구활동비","국외여비",{"$nulls":6},{"$f":"L39-K39","v":0},0,{"$f":"H39*I39","v":0}]
[null,null,"수용비 및 수수료",null,"위탁정산비용",null,"회",null,null,{"$f":"L40-K40","v":0},0,{"$f":"H40*I40","v":0}]
[null,null,"외부전문기술활용비",null,"공인인증시험비",null,"회",null,null,0,0,{"$f":"H41*I41","v":0}]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},0,0,0]
[{"$nulls":9},{"$f":"L50-K50","v":0},0,{"$f":"H41*I41","v":0}]
[null,null,"회계정산비용(필수)",null,"회계정산비용",{"$nulls":4},0,0,{"$f":"H51*I51","v":0}]
[null,null,"연구활동비 합계",{"$nulls":6},{"$f":"SUM(J39:J51)","v":0},{"$f":"SUM(K39:K51)","v":0},{"$f":"SUM(L39:L51)","v":0}]
[null,"위탁연구개발비","위탁연구개발비",{"$nulls":6},{"$f":"L53-K53","v":0},0,{"$f":"H53*I53","v":0}]
[null,null,"위탁연구개발비 합계",{"$nulls":6},{"$f":"SUM(J53:J53)","v":0},{"$f":"SUM(K53:K53)","v":0},{"$f":"SUM(L53:L53)","v":0}]
[null,"연구장비, 연구재료비, 연구활동비, 위탁연구개발비 합계",{"$nulls":7},{"$f":"SUM(J26,J54,J52,J38)","v":0},{"$f":"SUM(K26,K54,K52,K38)","v":0},{"$f":"SUM(L26,L54,L52,L38)","v":0}]
[null,"직접비(인건비 포함) 합계",{"$nulls":7},{"$f":"SUM(J15+J55)","v":0},{"$f":"SUM(K15+K55)","v":0},{"$f":"SUM(L15+L55)","v":0}]
[]
[null,"구분",null,"내역(품명)",null,null,"규격","수량","단가","현금(천원)","현물(천원)","합계"]
[null,null,"성과활용지원비",null,null,null,"회",null,null,{"$f":"L59-K59","v":0},0,{"$f":"I59","v":0}]
[{"$nulls":6},"회",null,null,0,0,{"$f":"I60","v":0}]
[null,null,null,"성과활용지원비 소계",{"$nulls":5},{"$f":"SUM(J59:J60)","v":0},{"$f":"SUM(K59:K60)","v":0},0]
[null,null,"간접비 합계",{"$nulls":6},{"$f":"J61","v":0},{"$f":"K61","v":0},{"$f":"L61","v":0}]
[]
[{"$nulls":9},"현금","현물","합계"]
[null,"직접비 합계",{"$nulls":7},{"$f":"J56","v":0},{"$f":"K56","v":0},{"$f":"L56","v":0}]
[null,"간접비 합계",{"$nulls":7},{"$f":"J62","v":0},{"$f":"K62","v":0},{"$f":"L62","v":0}]
[null,"사업비합계",{"$nulls":7},{"$f":"SUM(J65:J66)","v":0},{"$f":"SUM(K65:K66)","v":0},0]
[]
[]
[null,"비 목",null,"현 금","현 물","계 "]
[null,"1. 직접비",null,{"$f":"D74+D75+D76+D77+D78","v":0},{"$f":"E74+E75+E76+E77+E78","v":0},{"$f":"F74+F75+F76+F77+F78","v":0}]
[null,"1.1 인건비","1.1.1 기존인건비",{"$f":"J10","v":0},{"$f":"K10","v":0},{"$f":"D72+E72","v":0}]
[null,null,"1.1.2 신규인건비",{"$f":"J14","v":0},{"$f":"K14","v":0},0]
[null,"인건비소계",null,{"$f":"D72+D73","v":0},{"$f":"E72+E73","v":0},0]
[null,"1.3 연구장비",null,{"$f":"J26","v":0},{"$f":"K26","v":0},0]
[null,"1.4 연구재료비",null,{"$f":"J38","v":0},{"$f":"K38","v":0},0]
[null,"1.5 연구활동비",null,{"$f":"J52","v":0},{"$f":"K52","v":0},0]
[null,"1.7 위탁연구개발비",null,{"$f":"J54","v":0},{"$f":"K54","v":0},0]
[null,"2. 간접비",null,{"$f":"D80","v":0},{"$f":"E80","v":0},0]
[null,"2.1 성과활용지원비",null,{"$f":"J61","v":0},{"$f":"K61","v":0},{"$f":"D80+E80","v":0}]
[null,"사업비합계",null,{"$f":"D71+D79","v":0},{"$f":"E71+E79","v":0},0]