엑셀 자동화 업무 프로그램, 문서 및 양식

단가산출서 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 산 출 근 거 재료비 노무비 경 비 계 비고 제001호 상차 및 운반 (백호우0.7㎥ + 덤프15t), L=10Km 　 　 　 　 　 　 　 　 　 　 　 　 　 상차(백호우 0.7㎥) 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 q = 0.7 　 k = 0.9 　 f = 0.8 　 　 　 　 　 　 　 　 　 　 E = 0.65 　 Cm = 21 초 ( 135 ) 　 　 　 　 　 　 　 　 　 　 Q = 3600 * q * k * f * E / Cm 　 　 　 　 　 　 　 　 　 = 3600 * 0.7 * 0.9 * 0.8 * 0.65 / 21 = 56.16 　 　 　 　 　 　 재료비 =       17,788 / Q = 316 　 　 　 　             316 　 　             316 　 　 노무비 =       30,961 / Q = 551 　 　 　 　 　             551 　             551 　 　 경  비 =       18,961 / Q = 337 　 　 　 　 　 　             337             337 　 　 소  계 　 　 　 　 　 　 　 　 　 　 　 　             316             551             337           1,204 　 　 운반비(15Ton덤프) L=10Km 　 　 　 　 　 　 　 　 　 　 　 　 　 　 　 Rt = 1.6 　 f = 0.8 　 L = 1.25 　 　 　 　 　 　 　 　 　 　 E = 0.9 　 Cms = 21 　 Eo = 0.65 　 　 　 　 　 　 　 　 　 　 q = 15 / Rt * = 11.72 V = 40 Km 　 　 　 　 　 　 　 　 　 n = q / (0.7 * 0.9) = 18.6 회 　 　 　 　 　 　 　 　 　 　 　 t1 = Cms * n / (60 *Eo) = 10.015385