{"text_format":"5","workbook":"xlsx","n_sheets":1,"sheets":["산출내역계산"],"props":{"creator":"june","last_modified_by":"USER"},"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"산출내역계산","index":0,"n_rows":118,"n_cols":20,"rows_kept":118,"merged":[[1,0,1,15],[4,0,4,5],[4,6,4,7],[4,8,5,8],[4,9,5,10],[4,11,5,11],[4,12,5,13],[4,14,5,15],[5,0,6,5],[5,6,6,7],[6,9,6,11],[6,12,6,13],[6,14,6,15],[7,1,7,2],[7,3,7,5],[7,6,7,7],[7,8,7,11],[7,12,7,15],[11,3,11,6],[11,7,11,10],[11,11,11,15],[12,0,13,0],[12,3,12,6],[12,7,12,10],[12,11,12,15],[13,3,13,6],[13,7,13,10],[13,11,13,15],[13,18,13,19],[14,0,14,1],[14,3,14,6],[14,7,14,10],[14,11,14,15],[15,0,16,0],[15,3,15,6],[15,7,15,10],[15,11,15,15],[16,3,16,6],[16,7,16,10],[16,11,16,15],[17,0,17,2],[17,3,17,6],[17,7,17,10],[17,11,17,15],[19,14,19,15],[20,0,20,4],[20,6,20,7],[20,9,20,10],[20,11,20,15],[21,0,27,3],[21,6,21,7],[21,9,21,10],[21,11,21,15],[22,6,22,7],[22,9,22,10],[22,11,22,15],[23,6,23,7],[23,9,23,10],[23,11,23,15],[24,6,24,7],[24,9,24,10],[24,11,24,15],[25,6,25,7],[25,9,25,10],[25,11,25,15],[26,6,26,7],[26,9,26,10],[26,11,26,15],[27,6,27,7],[27,9,27,10],[27,11,27,15],[28,0,28,4],[28,6,28,7],[28,9,28,10],[28,11,28,15],[29,0,35,3],[29,6,29,7],[29,9,29,10],[29,11,29,15],[30,6,30,7],[30,9,30,10],[30,11,30,15],[31,6,31,7],[31,9,31,10],[31,11,31,15],[32,6,32,7],[32,9,32,10],[32,11,32,15],[33,6,33,7],[33,9,33,10],[33,11,33,15],[34,6,34,7],[34,9,34,10],[34,11,34,15],[35,6,35,7],[35,9,35,10],[35,11,35,15],[36,0,36,4],[36,6,36,7],[36,9,36,10],[36,11,36,15],[37,0,43,3],[37,6,37,7],[37,9,37,10],[37,11,37,15],[38,6,38,7],[38,9,38,10],[38,11,38,15],[39,6,39,7],[39,9,39,10],[39,11,39,15],[40,6,40,7],[40,9,40,10],[40,11,40,15],[41,6,41,7],[41,9,41,10],[41,11,41,15],[42,6,42,7],[42,9,42,10],[42,11,42,15],[43,6,43,7],[43,9,43,10],[43,11,43,15],[44,0,44,4],[44,6,44,7],[44,9,44,10],[44,11,44,15],[45,0,51,3],[45,6,45,7],[45,9,45,10],[45,11,45,15],[46,6,46,7],[46,9,46,10],[46,11,46,15],[47,6,47,7],[47,9,47,10],[47,11,47,15],[48,6,48,7],[48,9,48,10],[48,11,48,15],[49,6,49,7],[49,9,49,10],[49,11,49,15],[50,6,50,7],[50,9,50,10],[50,11,50,15],[51,6,51,7],[51,9,51,10],[51,11,51,15],[52,0,52,4],[52,6,52,7],[52,9,52,10],[52,11,52,15],[53,0,59,3],[53,6,53,7],[53,9,53,10],[53,11,53,15],[54,6,54,7],[54,9,54,10],[54,11,54,15],[55,6,55,7],[55,9,55,10],[55,11,55,15],[56,6,56,7],[56,9,56,10],[56,11,56,15],[57,6,57,7],[57,9,57,10],[57,11,57,15],[58,6,58,7],[58,9,58,10],[58,11,58,15],[59,6,59,7],[59,9,59,10],[59,11,59,15],[60,0,60,4],[60,5,60,10],[60,11,60,15],[61,0,61,3],[61,6,61,7],[61,11,61,14],[62,0,62,2],[62,3,62,4],[62,9,62,10],[62,11,62,15],[65,14,65,15],[66,0,66,4],[66,6,66,7],[66,9,66,10],[66,11,66,15],[67,0,73,3],[67,6,67,7],[67,9,67,10],[67,11,67,15],[68,6,68,7],[68,9,68,10],[68,11,68,15],[69,6,69,7],[69,9,69,10],[69,11,69,15],[70,6,70,7],[70,9,70,10],[70,11,70,15],[71,6,71,7],[71,9,71,10],[71,11,71,15],[72,6,72,7],[72,9,72,10],[72,11,72,15],[73,6,73,7],[73,9,73,10],[73,11,73,15],[74,0,74,4],[74,6,74,7],[74,9,74,10],[74,11,74,15],[75,0,81,3],[75,6,75,7],[75,9,75,10],[75,11,75,15],[76,6,76,7],[76,9,76,10],[76,11,76,15],[77,6,77,7],[77,9,77,10],[77,11,77,15],[78,6,78,7],[78,9,78,10],[78,11,78,15],[79,6,79,7],[79,9,79,10],[79,11,79,15],[80,6,80,7],[80,9,80,10],[80,11,80,15],[81,6,81,7],[81,9,81,10],[81,11,81,15],[82,0,82,4],[82,6,82,7],[82,9,82,10],[82,11,82,15],[83,0,89,3],[83,6,83,7],[83,9,83,10],[83,11,83,15],[84,6,84,7],[84,9,84,10],[84,11,84,15],[85,6,85,7],[85,9,85,10],[85,11,85,15],[86,6,86,7],[86,9,86,10],[86,11,86,15],[87,6,87,7],[87,9,87,10],[87,11,87,15],[88,6,88,7],[88,9,88,10],[88,11,88,15],[89,6,89,7],[89,9,89,10],[89,11,89,15],[90,0,90,4],[90,6,90,7],[90,9,90,10],[90,11,90,15],[91,0,97,3],[91,6,91,7],[91,9,91,10],[91,11,91,15],[92,6,92,7],[92,9,92,10],[92,11,92,15],[93,6,93,7],[93,9,93,10],[93,11,93,15],[94,6,94,7],[94,9,94,10],[94,11,94,15],[95,6,95,7],[95,9,95,10],[95,11,95,15],[96,6,96,7],[96,9,96,10],[96,11,96,15],[97,6,97,7],[97,9,97,10],[97,11,97,15],[98,0,98,4],[98,6,98,7],[98,9,98,10],[98,11,98,15],[99,0,105,3],[99,6,99,7],[99,9,99,10],[99,11,99,15],[100,6,100,7],[100,9,100,10],[100,11,100,15],[101,6,101,7],[101,9,101,10],[101,11,101,15],[102,6,102,7],[102,9,102,10],[102,11,102,15],[103,6,103,7],[103,9,103,10],[103,11,103,15],[104,6,104,7],[104,9,104,10],[104,11,104,15],[105,6,105,7],[105,9,105,10],[105,11,105,15],[106,0,106,4],[106,6,106,7],[106,9,106,10],[106,11,106,15],[107,0,107,3],[107,6,107,7],[107,11,107,14],[108,0,108,2],[108,3,108,6],[108,8,108,10],[108,11,108,15],[111,14,111,15],[112,0,112,4],[112,6,112,7],[112,9,112,10],[112,11,112,15],[113,0,113,3],[113,6,113,7],[113,9,113,10],[113,11,113,15],[114,0,114,3],[114,6,114,7],[114,9,114,10],[114,11,114,15],[115,0,115,3],[115,6,115,7],[115,9,115,10],[115,11,115,15],[116,0,116,3],[116,6,116,7],[116,9,116,10],[116,11,116,15],[117,0,117,2],[117,3,117,6],[117,8,117,10],[117,11,117,15]]}
[]
["보조신청금 산출내역서"]
[]
["사업장정보"]
["현장명",{"$nulls":5},"공사금액",null,"해체확인\n10일전",{"$f":"WORKDAY(O7,-9)","v":"2021-03-08"},null,"~","시작일",null,"2020-11-25"]
["00건설(주)/00번지 업무시설 및 근생시설 신축공사",{"$nulls":5},{"v":2500000000,"d":"2,500,000,000"}]
[{"$nulls":8},"발판장수","1,2열",null,null,"종료일",null,"2021-03-19"]
["공급업체명","00가설",null,"법인등록번호",null,null,1311110066182,null,"투  입  부  재",{"$nulls":3},"시스템비계,수직보호망"]
[]
[]
["산출내역(최종)"]
["구분","규격","면적","소요금액",{"$nulls":3},"자체금액",{"$nulls":3},"지원가능금액"]
["시스템비계","1열",{"$f":"ROUND(G63,0)","v":450}]
[null,"2열",{"$f":"ROUND(J63,0)","v":450},{"$nulls":15},"안전방망"]
["비계 합계",null,{"$f":"C13+C14","v":900},{"$f":"D13+D14","v":0},{"$nulls":3},{"$f":"H13+H14","v":0},{"$nulls":3},{"$f":"SUM(L13:P14)","v":0},{"$nulls":7},"단가"]
["안전방망","수직보호망",{"$f":"ROUND(L109,0)","v":110},{"$f":"ROUNDDOWN(D109,-3)","v":{"v":11000,"d":"11,000"}},{"$nulls":3},{"$f":"D16-L16","v":{"v":6000,"d":"6,000"}},{"$nulls":3},{"$f":"ROUNDDOWN(D16*IF(G6<300000000,0.65,IF(G6<2000000000,0.6,IF(G6<5000000000,0.5))),-3)","v":{"v":5000,"d":"5,000"}},{"$nulls":6},"수직보호망",100]
[null,"플라잉넷",{"$f":"ROUND(L118,0)","v":93},{"$f":"ROUNDDOWN(D118,-3)","v":{"v":9000,"d":"9,000"}},{"$nulls":3},{"$f":"D17-L17","v":{"v":5000,"d":"5,000"}},{"$nulls":3},{"$f":"ROUNDDOWN(D17*IF(G6<300000000,0.65,IF(G6<2000000000,0.6,IF(G6<5000000000,0.5))),-3)","v":{"v":4000,"d":"4,000"}},{"$nulls":6},"플라잉넷",100]
["총 합계",null,null,{"$f":"D15+D16+D17","v":{"v":20000,"d":"20,000"}},{"$nulls":3},{"$f":"H15+H16+H17","v":{"v":11000,"d":"11,000"}},{"$nulls":3},{"$f":"L15+L16+L17","v":{"v":9000,"d":"9,000"}}]
[]
["산출내역(상세)",{"$nulls":13},"시스템비계"]
["구간",{"$nulls":4},"구분(규격)","길이",null,"높이","높이+1",null,"계"]
["정면",{"$nulls":3},"①",1,{"v":150,"d":"150.0"},null,{"v":2,"d":"2.0"},{"$f":"IF(I22=0,0,I22+1)","v":{"v":3,"d":"3.0"}},null,{"$f":"G22*J22","v":{"v":450,"d":"450.0"}}]
[{"$nulls":4},"②",2,{"v":150,"d":"150.0"},null,{"v":2,"d":"2.0"},{"$f":"IF(I23=0,0,I23+1)","v":{"v":3,"d":"3.0"}},null,{"$f":"G23*J23","v":{"v":450,"d":"450.0"}}]
[{"$nulls":4},"③",1,{"v":1000,"d":"1000.0"},null,null,{"$f":"IF(I24=0,0,I24+1)","v":{"v":0,"d":"0.0"}},null,{"$f":"G24*J24","v":{"v":0,"d":"0.0"}}]
[{"$nulls":4},"④",{"$nulls":4},{"v":0,"d":"0.0"},null,{"$f":"G25*J25","v":{"v":0,"d":"0.0"}}]
[{"$nulls":4},"⑤",{"$nulls":4},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":4},"⑥",{"$nulls":4},{"v":0,"d":"0.0"},null,{"$f":"G27*J27","v":{"v":0,"d":"0.0"}}]
[{"$nulls":4},"⑦",{"$nulls":4},{"v":0,"d":"0.0"},null,{"$f":"G28*J28","v":{"v":0,"d":"0.0"}}]
["소계",{"$nulls":10},{"$f":"SUM(L22:O28)","v":{"v":900,"d":"900.0"}}]
["우측면",{"$nulls":8},{"v":0,"d":"0.0"},null,{"$f":"G30*J30","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G31*J31","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G32*J32","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G35*J35","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G36*J36","v":{"v":0,"d":"0.0"}}]
["소계",{"$nulls":10},{"$f":"SUM(L30:P36)","v":{"v":0,"d":"0.0"}}]
["배면",{"$nulls":8},{"v":0,"d":"0.0"},null,{"$f":"G38*J38","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G39*J39","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G40*J40","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G44*J44","v":{"v":0,"d":"0.0"}}]
["소계",{"$nulls":10},{"$f":"SUM(L38:P44)","v":{"v":0,"d":"0.0"}}]
["좌측면",{"$nulls":8},{"v":0,"d":"0.0"},null,{"$f":"G46*J46","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G47*J47","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G48*J48","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G49*J49","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G51*J51","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G52*J52","v":{"v":0,"d":"0.0"}}]
["소계",{"$nulls":10},{"$f":"SUM(L46:O52)","v":{"v":0,"d":"0.0"}}]
["기타(계단 및 옥탑)",{"$nulls":8},{"v":0,"d":"0.0"},null,{"$f":"G54*J54","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G55*J55","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G56*J56","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G58*J58","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
["소계",{"$nulls":10},{"$f":"SUM(L54:P60)","v":{"v":0,"d":"0.0"}}]
[]
["총 합계",null,null,"1열",null,null,{"$f":"SUMIF(F22:F60,1,L22:P60)","v":{"v":450,"d":"450.0"}},"+","2열",{"$f":"SUMIF(F22:F60,2,L22:P60)","v":{"v":450,"d":"450.0"}},null,{"$f":"SUM(G63,J63)","v":{"v":900,"d":"900.0"}}]
[]
[]
[{"$nulls":14},"수직보호망"]
["구간",{"$nulls":4},"구분","길이",null,"높이","높이+1",null,"계"]
["정면",{"$nulls":3},1,1,{"v":10,"d":"10.0"},null,{"v":10,"d":"10.0"},{"$f":"IF(I68=0,0,I68+1)","v":{"v":11,"d":"11.0"}},null,{"$f":"G68*J68","v":{"v":110,"d":"110.0"}}]
[{"$nulls":4},2,{"$nulls":4},{"v":0,"d":"0.0"},null,{"$f":"G69*J69","v":{"v":0,"d":"0.0"}}]
[{"$nulls":4},3,{"$nulls":4},{"v":0,"d":"0.0"},null,{"$f":"G70*J70","v":{"v":0,"d":"0.0"}}]
[{"$nulls":4},4,{"$nulls":4},{"v":0,"d":"0.0"},null,{"$f":"G71*J71","v":{"v":0,"d":"0.0"}}]
[{"$nulls":4},5,{"$nulls":4},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G73*J73","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G74*J74","v":{"v":0,"d":"0.0"}}]
["소계",{"$nulls":10},{"$f":"SUM(L68:O74)","v":{"v":110,"d":"110.0"}}]
["우측면",{"$nulls":3},6,{"$nulls":4},{"v":0,"d":"0.0"},null,{"$f":"G76*J76","v":{"v":0,"d":"0.0"}}]
[{"$nulls":4},7,{"$nulls":4},{"v":0,"d":"0.0"},null,{"$f":"G77*J77","v":{"v":0,"d":"0.0"}}]
[{"$nulls":4},8,{"$nulls":4},{"v":0,"d":"0.0"},null,{"$f":"G78*J78","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G80*J80","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G81*J81","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G82*J82","v":{"v":0,"d":"0.0"}}]
["소계",{"$nulls":10},{"$f":"SUM(L76:O82)","v":{"v":0,"d":"0.0"}}]
["배면",{"$nulls":8},{"v":0,"d":"0.0"},null,{"$f":"G84*J84","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G85*J85","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G86*J86","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G88*J88","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G90*J90","v":{"v":0,"d":"0.0"}}]
["소계",{"$nulls":10},{"$f":"SUM(L84:O90)","v":{"v":0,"d":"0.0"}}]
["좌측면",{"$nulls":8},{"v":0,"d":"0.0"},null,{"$f":"G92*J92","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G93*J93","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G94*J94","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G96*J96","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G97*J97","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G98*J98","v":{"v":0,"d":"0.0"}}]
["소계",{"$nulls":10},{"$f":"SUM(L92:P98)","v":{"v":0,"d":"0.0"}}]
["기타(계단 및 옥탑)",{"$nulls":8},{"v":0,"d":"0.0"},null,{"$f":"G100*J100","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G101*J101","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"$f":"G102*J102","v":{"v":0,"d":"0.0"}}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
[{"$nulls":9},{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"}]
["소계",{"$nulls":10},{"$f":"SUM(L100:O106)","v":{"v":0,"d":"0.0"}}]
[]
["소요금액",null,null,{"$f":"L109*T16","v":{"v":11000,"d":"₩11,000"}},{"$nulls":4},"물량산출합계",null,null,{"$f":"ROUND(L75+L83+L91+L99+L107,0)","v":110}]
[]
[]
[{"$nulls":14},"플라잉넷"]
["구간",{"$nulls":4},"구분","건물길이",null,null,"내민길이",null,"계"]
["정 면",{"$nulls":3},1,3,{"v":15.55,"d":"15.6"},null,"X",{"v":2,"d":"2.0"},null,{"$f":"G114*J114*F114","v":{"v":93.30000000000001,"d":"93.3"}}]
["우측면",{"$nulls":3},2,{"$nulls":3},"X",null,null,{"$f":"G115*J115*F115","v":{"v":0,"d":"0.0"}}]
["좌측면",{"$nulls":3},3,{"$nulls":3},"X",null,null,{"v":0,"d":"0.0"}]
["배 면",{"$nulls":3},4,{"$nulls":3},"X",null,null,{"v":0,"d":"0.0"}]
["소요금액",null,null,{"$f":"L118*T17","v":{"v":9300,"d":"₩9,300"}},{"$nulls":4},"물량산출합계",null,null,{"$f":"ROUND(L114+L115+L116+L117,0)","v":93}]