{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["QUOTATION","DATA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"QUOTATION","index":0,"n_rows":70,"n_cols":12,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,1,69,5],[34,1,34,3],[50,1,50,3],[4,2,4,3],[46,1,46,3],[60,1,60,3],[67,1,67,5],[68,1,68,5],[6,1,6,5]]}
["□","공급 면적",34,"평"]
["□","확장 유무",null,null,null,null,null,2]
["□","천정 높이",2.4,"m"]
["□","살림 유무",null,null,null,null,null,2]
["□","벽지 선택",null,null,null,null,null,1]
["□","시공 방법",null,null,null,null,null,1]
[null,"고급도배 : 벽지제거후 부직포, 운용지등으로 기초작업후 정배를 하는 것을 말함.\n일반도배 : 벽지제거를 최소화 한후 네바리 작업후 정배를 하는 것을 말함. "]
["□","시공 장소 선택"]
[null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,10,false,{"$f":"$G$10/($G$10+$G$11)%","v":40},null,{"$f":"IF(H10, I10,0)","v":0}]
[null,null,null,null,null,null,15,false,{"$f":"$G$11/($G$10+$G$11)%","v":60},null,{"$f":"IF(H11, I11,0)","v":0}]
[null,null,null,null,null,null,40,false,{"$f":"$G$12*$G$10/($G$10+$G$11)","v":16},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$12*$G$11/($G$10+$G$11)","v":24},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$12*$G$11/($G$10+$G$11)/4","v":6},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$12*$G$11/($G$10+$G$11)/2","v":12},null,0]
[null,null,null,null,null,null,24,false,{"$f":"$G$16*$G$10/($G$10+$G$11)","v":9.6},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$16*$G$11/($G$10+$G$11)","v":14.4},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$16*$G$11/($G$10+$G$11)/4","v":3.6},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$16*$G$11/($G$10+$G$11)/2","v":7.2},null,0]
[null,null,null,null,null,null,18,false,{"$f":"$G$20*$G$10/($G$10+$G$11)","v":7.2},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$20*$G$11/($G$10+$G$11)","v":10.8},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$20*$G$11/($G$10+$G$11)/4","v":2.7},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$20*$G$11/($G$10+$G$11)/2","v":5.4},null,0]
[null,null,null,null,null,null,18,false,{"$f":"$G$24*$G$10/($G$10+$G$11)","v":7.2},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$24*$G$11/($G$10+$G$11)","v":10.8},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$24*$G$11/($G$10+$G$11)/4","v":2.7},null,0]
[null,null,null,null,null,null,null,false,{"$f":"$G$24*$G$11/($G$10+$G$11)/2","v":5.4},null,0]
[null,null,null,null,null,null,null,null,null,"천정",{"$f":"K10 + K12+K16+K20+K24","v":0},{"$f":"K11 +SUM(K13:K15) + SUM(K17:K19) + SUM(K21:K23) + SUM(K25:K27)","v":0}]
[]
["□","도배 면적"]
[null,"천정",{"$f":"IF(H2=1,C1,C1*DATA!$B$4)","v":28.9},"평",{"$f":"C31*DATA!$B$2","v":95.36999999999999},"㎡"]
[null,"벽",{"$f":"C31*C3*DATA!$B$7","v":52.019999999999996},"평",{"$f":"C32*DATA!$B$2","v":171.66599999999997},"㎡"]
[null,"합",{"$f":"C31+C32","v":80.919999999999987},"평",{"$f":"E31+E32","v":267.03599999999994},"㎡"]
[]
["□","벽지 수량 및 주재료비"]
[null,"위   치","수   량","단  위","단  가","가  격"]
[null,"천정",{"$f":"ROUNDUP(C31/DATA!$B$3,0)","v":6},"롤",{"$f":"IF($H$5=1,DATA!$B$41, IF($H$5=2,DATA!$B$42,0))","v":6000},{"$f":"C37*E37*5","v":180000},null,3,{"$f":"H37*E37*5","v":90000}]
[null,"벽",{"$f":"ROUNDUP(C32/DATA!$B$3,0)","v":11},"롤",{"$f":"IF($H$5=1,DATA!$B$41, IF($H$5=2,DATA!$B$42,0))","v":6000},{"$f":"C38*E38*5","v":330000}]
[null,"소 계",{"$f":"SUM(C37:C38)","v":17},"롤",{"$f":"SUM(E37:E38)","v":12000},{"$f":"SUM(F37:F38)","v":510000}]
[]
[null,"1인 1일 기본 작업량",{"$f":"IF(H5=1,DATA!$B$19, IF(H5=2,DATA!$B$20, \"벽지를 선택\"))","v":6},"롤",{"$f":"C41*DATA!$B$2","v":19.799999999999997},"㎡"]
[null,"살림집 효과",{"$f":"C41*DATA!$B$9","v":3.5999999999999996},"롤",{"$f":"C42*DATA!$B$2","v":11.879999999999999},"㎡"]
[null,"고급도배 효과",{"$f":"C41*DATA!$B$10","v":4.8000000000000007},"롤",{"$f":"C43*DATA!$B$2","v":15.840000000000002},"㎡"]
[null,"살림집과 고급도배 효과",{"$f":"C41*DATA!$B$9*DATA!$B$10","v":2.88},"롤",{"$f":"C44*DATA!$B$2","v":9.5039999999999996},"㎡"]
[null,"높이에 따른 시공 효과",{"$f":"IF((C3>DATA!$B$6), C41*DATA!$B$6/C3, C41)","v":6},"롤",{"$f":"C45*DATA!$B$2","v":19.799999999999997},"㎡"]
[]
["□","인건비"]
[null,"도배기술자",{"$f":"IF(AND($H$4=1,$H$6=1),ROUNDUP(C39/$C$43,0),(IF(AND($H$4=2,$H$6=1),ROUNDUP(C39/$C$44,0),IF(AND($H$4=2,$H$6=1),ROUNDUP(C39/$C$42,0),ROUNDUP(C39/$C$41,0) ))))","v":6},"명",{"$f":"DATA!$B$51","v":250000},{"$f":"C48*E48","v":1500000}]
[null,"소 계",null,null,null,{"$f":"F48","v":1500000}]
[]
["□","부자재"]
[null,"위   치","수   량","단  위","단  가","가  격"]
[null,{"$f":"DATA!$A$31","v":"부직포[109mm]"},{"$f":"IF($H$6=1, ROUNDUP(C33/30,0), 0)","v":3},"롤",{"$f":"DATA!$B$31","v":35000},{"$f":"C53*E53","v":105000}]
[null,{"$f":"DATA!$A$32","v":"운용지"},{"$f":"IF($H$6=1, C1*3, 0)","v":102},"m",{"$f":"DATA!$B$32","v":150},{"$f":"C54*E54","v":15300}]
[null,{"$f":"DATA!$A$33","v":"풀[20Kg]"},{"$f":"IF(C5=DATA!$A15,ROUNDUP(C39/DATA!$B$19,0)+1,ROUNDUP(C39/DATA!$B$20,0)+1)","v":6},"EA",{"$f":"DATA!$B$33","v":10000},60000]
[null,{"$f":"DATA!$A$34","v":"본드"},{"$f":"ROUNDUP($C$1/3, 0)","v":12},"EA",{"$f":"DATA!$B$34","v":1500},18000]
[null,{"$f":"DATA!$A$35","v":"실리콘[도배용]"},{"$f":"ROUNDUP($C$1/3, 0)","v":12},"EA",{"$f":"DATA!$B$35","v":1500},18000]
[null,{"$f":"DATA!$A36","v":"네바리"},{"$f":"ROUNDUP(C1/10,0)","v":4},"EA",{"$f":"DATA!$B$36","v":5000},20000]
[null,"소 계",null,null,null,{"$f":"SUM(F53:F58)","v":236300}]
[]
["□","기타"]
[null,"간접비용",null,null,null,{"$f":"(F39+F49+F59)*3%","v":67389}]
[null,"기업이윤",null,null,null,{"$f":"(F39+F59)*10%","v":74630}]
[null,"소 계",null,null,null,{"$f":"SUM(F62:F63)","v":142019}]
[]
[null,"합 계",null,null,null,{"$f":"F39+F49+F59+F64","v":2388319},null,{"$f":"F66*I12/100","v":382131.04}]
["□","면책 사항"]
[1,"현장 사항을 고려하지 않는 단순 견적, 이로 인한 발생하는 손익은 당사자들에게 모든 책임이 있다."]
[2,"현장사항을 확인 완료 검토하여 진행한다."]
[3,"모든 단가와 견적 계산 방법은 다를 수 있다. "]

{"sheet":"DATA","index":1,"n_rows":73,"n_cols":4,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["기본값"]
["PY2SQUAREM",3.3,"PY/㎡"]
["면적/롤",5,"PY/Roll"]
["확장비확장비율",0.85]
["천장에대한벽비율",1.8]
["기본벽높이",2.4,"m"]
["벽높이에따른비율",{"$f":"$B$5/$B$6","v":0.75}]
[]
["살림집효과비율",0.6]
["고급도배비율",0.8]
[]
[]
[]
["벽지를 선택하세요"]
["합지벽지"]
["실크벽지"]
[]
["롤/박스"]
["합지벽지",6,"롤"]
["실크벽지",4,"롤"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["부자재"]
["부직포[109mm]",35000,"원"]
["운용지",150,"원"]
["풀[20Kg]",10000,"원"]
["본드",1500,"원"]
["실리콘[도배용]",1500,"원"]
["네바리",5000,"원"]
["바인더",3000,"원"]
["각대",3000,"원"]
[]
["벽지 단가[3.3㎡]"]
["합지벽지",6000,"원"]
["실크벽지",11000,"원"]
[]
[]
[]
[]
[]
[]
[]
["인건비"]
["도배기술자",250000,"원","지역, 업체마다 상이"]
[]
[]
[]
[]
[]
[]
[]
[]
["시공장소"]
["전체시공"]
["전체 천정만 시공"]
["전체 벽만 시공"]
["거실 시공"]
["거실천정 시공"]
["거실벽 시공"]
["안방 시공"]
["안방천정 시공"]
["안방벽 시공"]
["방1 시공"]
["방2 시공"]
["방3 시공"]
["방4 시공"]