excel tenaga kerja new
TRANSCRIPT
-
7/25/2019 Excel Tenaga Kerja New
1/59
MENGHITUNG JUMLAH TENAGA KERJA RENCANA
Lantai 1
Kolom
Volumen pengencoran = !"#$
Tenaga %er&a
'e%er&a 1!"( )H
Tu%ang *atu +!,( )H
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
'e%er&a (!$$,,-(,1# '1/!-,/(1-
T
Tu%ang *atu +!--/(#"#-" M K
Kepala Tu%ang +!+/+(,
Man.or +!"-#-1-(,
Volume 0e%iting = (-!," m
Tenaga Ker&a
'e%er&a +!"" )H = #!$/,$,
Tu%ang %a2u +!$$ )H = 1!1/-"/
%epala tu%ang +!+$$ )H = 1!1/-"/
Man.or +!+$$ )H = 1!1/-"/
'+
T
M K
Volume 'em*eian = $#+!$1%gTenaga Ker&a
'e%er&a +!+, )H = 1,!+11(,
Tu%ang 0ei +!+, )H = 1,!+11(,
%epala tu%ang +!++, )H = 1!,+11(,
Man.or +!++# )H = +!/,+/
'1-
T
M K
Lantai
Kolom
Volumen pengencoran = 1#!",$
Tenaga %er&a
'e%er&a 1!"( )H
Tu%ang *atu +!,( )H
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
'e%er&a $!#(-"$(,1#$ ' 1/!-,/(1-TTu%ang *atu +!(,"#$/-(, M K
Kepala Tu%ang +!+(-"/
m$
m$
-
7/25/2019 Excel Tenaga Kerja New
2/59
Man.or +!1,$/,/-(,1
Volume 0e%iting = +"!## m
Tenaga Ker&a
'e%er&a +!"" )H = 1/!#"#$#
Tu%ang %a2u +!$$ )H = /!,$1,1
%epala tu%ang +!+$$ )H = +!/,$1,
Man.or +!+$$ )H = +!/,$1,
'+
T
M K
Volume 'em*eian = ,"+!(%g
Tenaga Ker&a
'e%er&a +!+, )H = 1$!-+1(
Tu%ang 0ei +!+, )H = 1$!-+1(
%epala tu%ang +!++, )H = 1!$-+1(
Man.or +!++# )H = +!,--"#$
'1-
T
M K
0alo%
Volumen pengencoran = -#!/--
Tenaga %er&a
'e%er&a 1!"( )HTu%ang *atu +!,( )H
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
'e%er&a 1#+!$+ '1/!-,/(1-
T
Tu%ang *atu $!$,1, M K
Kepala Tu%ang !$,/""#
Man.or ,!+(#++#
Volume 0e%iting = (/-!+, mTenaga Ker&a
'e%er&a +!"" )H = -!1/##/
Tu%ang %a2u +!$$ )H = 1#!+/,(
%epala tu%ang +!+$$ )H = 1!#+/,(
Man.or +!+$$ )H = 1!#+/,(
'+
T
M K
Volume 'em*eian = 11,(!11%gTenaga Ker&a
'e%er&a +!+, )H = "+!-,(((
m$
-
7/25/2019 Excel Tenaga Kerja New
3/59
Tu%ang 0ei +!+, )H = "+!-,(((
%epala tu%ang +!++, )H = "!+-,(((
Man.or +!++# )H = $!#,-"+$
'1-
T
M K
'lat lantai
Volumen pengencoran = ",!+1
Tenaga %er&a
'e%er&a 1!"( )H
Tu%ang *atu +!,( )H
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
'e%er&a 11+!(""( '+
T
Tu%ang *atu 1-!#,,( M K
Kepala Tu%ang 1!-,"-
Man.or (!("1-$
Volume 0e%iting = ((-!#- m
Tenaga Ker&a
'e%er&a +!"" )H = "!$-$#
Tu%ang %a2u +!$$ )H = 1$!1"#1,
%epala tu%ang +!+$$ )H = 1!$1"#1,
Man.or +!+$$ )H = 1!$1"#1,
'+
T
M K
Volume 'em*eian = ,#$+!-/%g
Tenaga Ker&a
'e%er&a +!+, )H = $,!1(##(
Tu%ang 0ei +!+, )H = $,!1(##(
%epala tu%ang +!++, )H = $!,1(##(Man.or +!++# )H = !1$111
'1-
T
M K
Lantai$
0alo%
Volumen pengencoran = #!"1
Tenaga %er&a'e%er&a 1!"( )H
Tu%ang *atu +!,( )H
m$
m$
-
7/25/2019 Excel Tenaga Kerja New
4/59
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
'e%er&a ,+!$+"( '1/!-,/(1-
T
Tu%ang *atu 11!,1,,( M K
Kepala Tu%ang 1!1/$+-
Man.or $!($""$
Volume 0e%iting = $$#!/+ m
Tenaga Ker&a
'e%er&a +!"" )H = 1(!,--
Tu%ang %a2u +!$$ )H = ,!-/#++1
%epala tu%ang +!+$$ )H = +!,-/#
Man.or +!+$$ )H = +!,-/#
'
+
T
M K
Volume 'em*eian = ",,!+#%g
Tenaga Ker&a
'e%er&a +!+, )H = $$!-"+
Tu%ang 0ei +!+, )H = $$!-"+
%epala tu%ang +!++, )H = $!$-"+
Man.or +!++# )H = 1!/$#-"/
'1-
T
M K
'lat lantai
Volumen pengencoran = (!-#
Tenaga %er&a
'e%er&a 1!"( )H
Tu%ang *atu +!,( )H
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
'e%er&a -,!1-" '+
T
Tu%ang *atu 1#!($1 M K
Kepala Tu%ang 1!#,/(
Man.or #!$-(,
Volume 0e%iting = ##+!$, m
Tenaga Ker&a
'e%er&a +!"" )H = +!,"+$
Tu%ang %a2u +!$$ )H = 1+!$-+1(%epala tu%ang +!+$$ )H = 1!+$-+1(
Man.or +!+$$ )H = 1!+$-+1(
m$
-
7/25/2019 Excel Tenaga Kerja New
5/59
'+
T
M K
Volume 'em*eian = #-$-!--%g
Tenaga Ker&a
'e%er&a +!+, )H = #!1/##
Tu%ang 0ei +!+, )H = #!1/##
%epala tu%ang +!++, )H = !#1/##
Man.or +!++# )H = 1!$-($,
'1-
T
M K
-
7/25/2019 Excel Tenaga Kerja New
6/59
3ari
Lantai 1 Kolom'engecoran !"#$ ,
0e%iting (-!," ,
'em*eian $#+!$1# 1#
lantai
0alo%
'engecoran -#!/-- 1
0e%iting (/-!+"( 1#
'em*eian 11,(!1+/ 1#
plat
'engecoran ",!+1 1
/!-1#/0e%iting ((-!#- 1#
'em*eian ,#$+!-/ 1#
Kolom
'engecoran 1#!",$ ,
0e%iting +"!## ,
'em*eian ,"+!( 1#
Lantai $
0alo%
'engecoran #!"1 1
0e%iting $$#!-/, 1#
'em*eian ",,!+# 1#
plat
'engecoran (!-# 1
0e%iting ##+!$, 1#
'em*eian #-$-!-- 1#
1+
Uraian 'e%er&aan Volume 3ari
Lantai 1 Kolom
'engecoran !"#$ ,
0e%iting (-!," ,
'em*eian $#+!$1# 1#
Lantai
Kolom
'engecoran 1#!",$ ,
0e%iting +"!## ,
'em*eian ,"+!( 1#
1+0alo%
'engecoran -#!/-- 1
0e%iting (/-!+"( 1#
'em*eian 11,(!1+/ 1#
'lat lantai'engecoran ",!+1 10e%iting ((-!#- 1#
'em*eian ,#$+!-/ 1#
Lantai $
0alo%
'engecoran #!"1 1
0e%iting $$#!-/, 1#
'em*eian ",,!+# 1#
'lat lantai
'engecoran (!-# 1
0e%iting ##+!$, 1#
'em*eian #-$-!-- 1#
/!-1#/
-
7/25/2019 Excel Tenaga Kerja New
7/59
1+
1+
/!-1#/
1+
-
7/25/2019 Excel Tenaga Kerja New
8/59
1+
1+
1+
1+
-
7/25/2019 Excel Tenaga Kerja New
9/59
/!-1#/
1+
1+
1+
-
7/25/2019 Excel Tenaga Kerja New
10/59
1+
1+
-
7/25/2019 Excel Tenaga Kerja New
11/59
'e%er&a Man.or %epala tu%ang tu%ang Total Tenaga %er&a
+ 1 1 1+ $
+ 1 1 1+ $
1- 1 1 1+ $+
+ 1 1 1+ $
+ 1 1 1+ $
1- 1 1 1+ $+
+ 1 1 1+ $
+ 1 1 1+ $
1- 1 1 1+ $+
+ 1 1 1+ $
+ 1 1 1+ $
1- 1 1 1+ $+
+ 1 1 1+ $
+ 1 1 1+ $
1- 1 1 1+ $+
+ 1 1 1+ $
+ 1 1 1+ $
1- 1 1 1+ $+
'R)4UKTIVITA56HARI Total Tenaga %er&a pro.u%ti7ita6orang63ari$!$ $ +!1+1
$"!/, $ 1!1((
#$!+ $+ -!1+1
!1+ $ +!+""
/!#/ $ +!/
1/,!1" $+ "!(,
-#!// $ !"("
#!, $ 1!$$(
-"/!"( $+ -!/--
",!+1 $ !+/#$/!-/ $ 1!#,
($+!,- $+ 1,!"/$
#!"1 $ 1!$$
$!/ $ +!,#-
#-$!, $+ 1"!1#
(!-# $ 1!"(1
$1!#" $ +!/-$
$#(!"$ $+ 11!(1
-
7/25/2019 Excel Tenaga Kerja New
12/59
-
7/25/2019 Excel Tenaga Kerja New
13/59
-
7/25/2019 Excel Tenaga Kerja New
14/59
-
7/25/2019 Excel Tenaga Kerja New
15/59
-
7/25/2019 Excel Tenaga Kerja New
16/59
Lantai 2
pengecoran /$!#
0e%iting ,,#!-,
'em*eian 11"1!#/
Lantai 3
pengecoran #1!/1
0e%iting $$+!$
'em*eian #$+$!1
-
7/25/2019 Excel Tenaga Kerja New
17/59
-
7/25/2019 Excel Tenaga Kerja New
18/59
-
7/25/2019 Excel Tenaga Kerja New
19/59
-
7/25/2019 Excel Tenaga Kerja New
20/59
-
7/25/2019 Excel Tenaga Kerja New
21/59
Uraian 'e%er&aan Volume 3ari
Lantai 1 Kolom
'engecoran 1-!" $
0e%iting +$!/ "
'em*eian ,!#" -
Lantai
Kolom'engecoran /!"# #
0e%iting 1"!#- (
'em*eian +11!1 -
0alo%
'engecoran #+!## 1
0e%iting -,!$( -
'em*eian (((,!1$ /
'lat lantai
'engecoran #$!$ 1
0e%iting $"1!+# -
'em*eian #(/$!# /
Lantai $
0alo%
'engecoran 1-!", 1
0e%iting 1$"!" -
'em*eian "$!1# -
'lat lantai
'engecoran $!# 1
0e%iting 1/$!"$ -
'em*eian 1",+!/" ,
Uraian 'e%er&aan Volume 3ari
Lantai 1 Kolom
'engecoran !"#$ $
0e%iting (-!," "
'em*eian $#+!$1# -
Lantai
Kolom
'engecoran 1#!",$ #
0e%iting +"!## (
'em*eian ,"+!( -
0alo%
'engecoran -#!/-- 1
0e%iting (/-!+"( -
'em*eian 11,(!11 /
'lat lantai
'engecoran ",!+1 1
0e%iting ((-!#- -
'em*eian ,#$+!-/ /
Lantai $
0alo%
'engecoran #!"1 1
0e%iting $$#!-/, -
'em*eian ",,!+# -
'lat lantai
'engecoran (!-# 1
0e%iting ##+!$, -
'em*eian #-$-!-- ,
-
7/25/2019 Excel Tenaga Kerja New
22/59
Lantai
kolom
Pengecoran
18,62 31
Bekisting
203,9 6
Pembesian
2722,46 8(Kg)
Lantai
Kolom
Pengecoran
9,64 42
Bekisting
126,48 5
Pembesian
2011,12 8(Kg)
Balok
Pengecoran
40,44 1
Bekisting
287,35 8Pembesian
5557,13 9(Kg)
Plat lantai
Pengecoran
43,32 1
Bekisting
361,04 8
Pembesian
4593,24 9(Kg)
Lantai
Balok
Pengecoran
18!67 13Bekisting
136!6 8
Pembesian
2632!14 8(Kg)
Plat lantai
Pengecoran
23!24 1
Bekisting
193!63 8
Pembesian
1670!96 7(Kg)
(m3)
(m2)
(m3)
(m2)
(m3)
(m2)
(m3)
(m2)
(m3
)
(m2)
(m3)
(m2)
-
7/25/2019 Excel Tenaga Kerja New
23/59
'e%er&a Tu%ang Kepala tu%ang Man.or Total Tenaga %er&a
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
1 1
'R)4UKTIVITA56HARI pro.u%ti7ita per orang per 3ari
,!(#- 19 +!$/,
#$!1, 16 !"/(
#(!-/ 30 1#!1,"
$!""- 16 +!/
#1!-- 12 $!##1
$#(!+$1 18 1/!1"-
-#!/-- 26 $!"/
,#!,(- 20 $!,$-
1$(!,/+ 24 ("!$""
",!+1+ 26 !(,,
"/!-1+ 20 $!#/1
-(!"(# 24 $#!#+#!"1+ 23 1!-($
#1!-" 25 1!",#
-#"!(+( 23 $"!-+(
(!-#+ 23 !/,
((!+#" 25 !+
"/1!"/ 23 $+!+((
-
7/25/2019 Excel Tenaga Kerja New
24/59
11 1 1 6 19
8 1 1 6 16
19 1 1 9 30
8 1 1 6 16
6 1 1 4 12
11 1 1 5 18
20 1 1 4 26
12 1 1 6 20
15 1 1 7 24
20 1 1 4 26
12 1 1 6 20
15 1 1 7 24
17 1 1 4 23
17 1 1 6 25
14 1 1 7 23
17 1 1 4 23
17 1 1 6 25
14 1 1 7 23
-
7/25/2019 Excel Tenaga Kerja New
25/59
"#rasi "#rasi selisi$
7 3!2347142857 7!5476666667 133
7 36!965714286 43!126666667 1714 243!02242857 425!28925 75
7 2!0961428571 3!66825 75
7 29!491428571 41!288 40
14 197!16071429 345!03125 75
14 84!988 84!988 0
14 42!718928571 74!758125 75
14 869!65064286 1352!7898889 56
14 67!01 67!01 0
14 39!891428571 69!81 75
14 530!77785714 825!65444444 56
14 42!61 42!61 0
14 23!921214286 41!862125 75
14 483!71714286 846!505 75
14 52!84 52!84 0
14 31!455 55!04625 75
14 345!63428571 691!26857143 100
Pro%#kti&itas'er $ari
Pro%#kti&itas'er $ari
-
7/25/2019 Excel Tenaga Kerja New
26/59
"#rasi "#rasi elisi$
7 0!1010848214 0!397245614 /$
7 1!1551785714 2!6954166667 1$$14 8!100747619 14!176308333 ,(
7 0!0655044643 0!229265625 (+
7 0!9216071429 3!4406666667 ,$
14 6!5720238095 19!168402778 1/
1 2!655875 3!2687692308 $
14 1!3349665179 3!73790625 1-+
14 28!988354762 56!36624537 /#
1 2!0940625 2!5773076923 $
14 1!2466071429 3!4905 1-+
14 17!692595238 34!402268519 /#
1 1!3315625 1!8526086957 $/
14 0!7475379464 1!674485 1#
14 16!123904762 36!804565217 1-
1 1!65125 2!2973913043 $/
14 0!98296875 2!20185 1#
14 11!521142857 30!05515528 1"1
Pro%#k! Perorang 'er $ari
Pro%#k! Perorang 'er $ari
-
7/25/2019 Excel Tenaga Kerja New
27/59
MENGHITUNG JUMLAH TENAGA KERJA RENCANA
Lantai 1
Kolom
Volumen pengencoran = !"#
Tenaga %er&a
'e%er&a 1!"( )H
Tu%ang *atu +!,( )HKepala tu%ang +!+- )H
Man.or +!+-$ )H
'e%er&a (!$$"(,1 '1/!-,/(
T/!-1#/
Tu%ang *at +!--/#/ M K
Kepala Tu% +!+/+("
Man.or +!"-##"
Volume 0e%iting = (-!," m
Tenaga Ker&a'e%er&a +!"" )H = #!$/,$,
Tu%ang %a2u +!$$ )H = 1!1/-"/
%epala tu%ang +!+$$ )H = 1!1/-"/
Man.or +!+$$ )H = 1!1/-"/
'+
T1+
M K
Volume 'em*eian = $#+!$1 %g
Tenaga Ker&a'e%er&a +!+, )H = 1,!+11(,
Tu%ang 0ei +!+, )H = 1,!+11(,
%epala tu%ang +!++, )H = 1!,+11(,
Man.or +!++# )H = +!/,+/
'1-
T1+
M K
Lantai
Kolom
Volumen pengencoran = 1#!",
Tenaga %er&a
'e%er&a 1!"( )H
Tu%ang *atu +!,( )H
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
m$
m$
-
7/25/2019 Excel Tenaga Kerja New
28/59
'e%er&a $!#(-"$" '1/!-,/(
T/!-1#/
Tu%ang *at +!(,"#$/ M K
Kepala Tu% +!+(-"/
Man.or +!1,$/-
Volume 0e%iting = +"!## m
Tenaga Ker&a'e%er&a +!"" )H = 1/!#"#$#
Tu%ang %a2u +!$$ )H = /!,$1,1
%epala tu%ang +!+$$ )H = +!/,$1,
Man.or +!+$$ )H = +!/,$1,
'+
T1+
M K
Volume 'em*eian = "/$!1 %g
Tenaga Ker&a'e%er&a +!+, )H = 1$!#""+$
Tu%ang 0ei +!+, )H = 1$!#""+$
%epala tu%ang +!++, )H = 1!$#""+$
Man.or +!++# )H = +!,"/#-,
'1-
T1+
M K
0alo%
Volumen pengencoran = -$!1Tenaga %er&a
'e%er&a 1!"( )H
Tu%ang *atu +!,( )H
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
'e%er&a 1$,!1##, '1/!-,/(
T/!-1#/
Tu%ang *at !-(,#( M K
Kepala Tu% !$,$+#
Man.or "!-/-,/#
Volume 0e%iting = "1,!+/ m
Tenaga Ker&a
'e%er&a +!"" )H = /!+/1((
Tu%ang %a2u +!$$ )H = 1#!(#(,-
%epala tu%ang +!+$$ )H = 1!#(#(,-
Man.or +!+$$ )H = 1!#(#(,-
m$
-
7/25/2019 Excel Tenaga Kerja New
29/59
'+
T1+
M K
Volume 'em*eian = 11/,+!1 %g
Tenaga Ker&a
'e%er&a +!+, )H = (/!-(+(/
Tu%ang 0ei +!+, )H = (/!-(+(/%epala tu%ang +!++, )H = (!/-(+(/
Man.or +!++# )H = $!#++$#
'1-
T1+
M K
'lat lantai
Volumen pengencoran = ",!#+
Tenaga %er&a'e%er&a 1!"( )H
Tu%ang *atu +!,( )H
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
'e%er&a 111!1$$ '+
T1+
Tu%ang *at 1-!($((( M K
Kepala Tu% 1!--,("
Man.or (!(/#$""
Volume 0e%iting = ("+!#$ m
Tenaga Ker&a
'e%er&a +!"" )H = "!#+1
Tu%ang %a2u +!$$ )H = 1$!1+11
%epala tu%ang +!+$$ )H = 1!$1+11
Man.or +!+$$ )H = 1!$1+11
'+
T1+
M K
Volume 'em*eian = -+$+!-- %g
Tenaga Ker&a
'e%er&a +!+, )H = #+!1(##
Tu%ang 0ei +!+, )H = #+!1(##
%epala tu%ang +!++, )H = #!+1(##
Man.or +!++# )H = !/#($,
' T
m$
-
7/25/2019 Excel Tenaga Kerja New
30/59
M K
Lantai$
0alo%
Volumen pengencoran = ##!$+1#
Tenaga %er&a'e%er&a 1!"( )H
Tu%ang *atu +!,( )H
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
'e%er&a ,$!+/,$1 '1/!-,/(
T/!-1#/
Tu%ang *at 1!1--/ M K
Kepala Tu% 1!#+#$/
Man.or $!",,+1"
Volume 0e%iting = $"/!(# m
Tenaga Ker&a
'e%er&a +!"" )H = 1,!#+/#
Tu%ang %a2u +!$$ )H = -!,1+#"-
%epala tu%ang +!+$$ )H = +!-,1+#,
Man.or +!+$$ )H = +!-,1+#,
'+
T1+
M K
Volume 'em*eian = ,$/!/, %g
Tenaga Ker&a
'e%er&a +!+, )H = $"!1//-$
Tu%ang 0ei +!+, )H = $"!1//-$
%epala tu%ang +!++, )H = $!"1//-$
Man.or +!++# )H = !+"-("
'1-
T1+
M K
'lat lantai
Volumen pengencoran = ($!#"(
Tenaga %er&a
'e%er&a 1!"( )H
Tu%ang *atu +!,( )H
Kepala tu%ang +!+- )H
Man.or +!+-$ )H
m$
m$
-
7/25/2019 Excel Tenaga Kerja New
31/59
'e%er&a --!1,( '+
T1+
Tu%ang *at 1#!,+-- M K
Kepala Tu% 1!#/,+
Man.or #!#$,(/(
Volume 0e%iting = ##(!"+ mTenaga Ker&a
'e%er&a +!"" )H = 1!++""/
Tu%ang %a2u +!$$ )H = 1+!(+$$(
%epala tu%ang +!+$$ )H = 1!+(+$$(
Man.or +!+$$ )H = 1!+(+$$(
'+
T1+
M K
Volume 'em*eian = (11"!/+ %gTenaga Ker&a
'e%er&a +!+, )H = (!(-##-
Tu%ang 0ei +!+, )H = (!(-##-
%epala tu%ang +!++, )H = !((-##-
Man.or +!++# )H = 1!#"1/,
'1-
T1+
M K
-
7/25/2019 Excel Tenaga Kerja New
32/59
3ari 'e%er&a Man.or
Lantai 1 Kolom'engecoran !"# , " 1
0e%iting (-!," , #
'em*eian $#+!$1 1# 1, 1
lantai
Kolom'engecoran 1#!", , # 10e%iting +"!## , + 1
'em*eian "/$!1 1# 1# 1
*alo%
'engecoran -$!1 1 1$- ,
0e%iting "1,!+/ 1# /
'em*eian 11/,+!1 1# "+ #
plat
'engecoran ",!#+ 1 11 "
0e%iting ("+!#$ 1# ,
'em*eian -+$+!-- 1# #1 $
Lantai $
0alo%
'engecoran ##!$+ 1 ,$ #
0e%iting $"/!(# 1# 1- 1'em*eian ,$/!/, 1# $,
plat
'engecoran ($!#, 1 -/ (
0e%iting ##(!"+ 1# 1 1
'em*eian (11"!/+ 1# "
Uraian 'e%er&aan Volume 3ari 'R)4UKTIVITA56HARI
Lantai 1 Kolom'engecoran !"# , $!$0e%iting (-!," , $"!/,
'em*eian $#+!$1 1# #$!+
Lantai
Kolom
'engecoran 1#!", , !1+
0e%iting +"!## , /!#/
'em*eian "/$!1 1# 1/!$,
0alo%
'engecoran -$!1 1 -$!1
0e%iting "1,!+/ 1# ##!+-
'em*eian 11/,+!1 1# -((!+1
'lat lantai
'engecoran ",!#+ 1 ",!#+
0e%iting ("+!#$ 1# #+!+$'em*eian -+$+!-- 1# (,$!"$
Lantai $
0alo%
'engecoran ##!$+ 1 ##!$+
0e%iting $"/!(# 1# "!#+
'em*eian ,$/!/, 1# (1,!1#
'lat lantai
'engecoran ($!#, 1 ($!#,
0e%iting ##(!"+ 1# $1!-$
'em*eian (11"!/+ 1# $"(!#/
-
7/25/2019 Excel Tenaga Kerja New
33/59
-
7/25/2019 Excel Tenaga Kerja New
34/59
-
7/25/2019 Excel Tenaga Kerja New
35/59
-
7/25/2019 Excel Tenaga Kerja New
36/59
-
7/25/2019 Excel Tenaga Kerja New
37/59
%epala tu% tu%ang l Tenaga %er&a
1 1 /
1 #+
1, $, Lantai 2
1 1 , pengecoran /$!#1 1+ $ 0e%iting ,,#!-,
1# $1 'em*eian 11"1!#/
$ $ 1,1
1( #-
" "+ 1$+
1/ 1$/
1# #(
# #1 -/
1$ /
1 / / Lantai 3# $, -+ pengecoran #1!/1
1( 111 0e%iting $$+!$
1 11 $# 'em*eian #$+$!1
$ " (,
l Tenaga % ro.u%ti7ita6orang63a
/ +!$(/#+ +!/#
$, "!("-
, +!//
$ +!/
$1 "!+"
1,1 +!#-"
#- +!/1-
1$+ "!(,,
1$/ +!#-(
#( +!-/+-/ "!##(
/ +!#-
/ +!/1+
-+ "!#"#
111 +!#-
$# +!/$"
(, "!#1
-
7/25/2019 Excel Tenaga Kerja New
38/59
-
7/25/2019 Excel Tenaga Kerja New
39/59
-
7/25/2019 Excel Tenaga Kerja New
40/59
-
7/25/2019 Excel Tenaga Kerja New
41/59
-
7/25/2019 Excel Tenaga Kerja New
42/59
Uraian 'e%er&aan Volume 3ari
Lantai 1 Kolom
'engecoran !"# "
0e%iting (-!," "
'em*eian $#+!$1 1#
Lantai
Kolom
'engecoran 1#!", -
0e%iting +"!## 1+
'em*eian "/$!1 1"
0alo%
'engecoran -$!1 1
0e%iting "1,!+/ 1"
'em*eian 11/,+!1 1-
'lat lantai
'engecoran ",!#+ 1
0e%iting ("+!#$ 1"
'em*eian -+$+!-- 1-
Lantai $
0alo%
'engecoran ##!$+ 1
0e%iting $"/!(# 1"
'em*eian ,$/!/, 1"
'lat lantai
'engecoran ($!#, 1
0e%iting ##(!"+ 1"
'em*eian (11"!/+ 1#
rencana
$!$#-(,1#$
$"!/"(,1#-(,
#$!+#-(,1#
!+/"1#-(,1
/!#/1#-(,1#
1/!$,1-(,1#/
-$!11-
##!+,-1+,1#/
-((!++-#/#-
",!#+
#+!+$+"(
(,$!"$#$#(+-"
##!$+1#
"!$/($(,1#/
(1,!1#+#(/-$+1
($!#"(
$1!--$1#-"
$"(!#/((#/,1#
-
7/25/2019 Excel Tenaga Kerja New
43/59
rencana realiai
+!$" +!1//
+!/ !"/(
"!(, -!1+1
+!$+ +!11(
+!/ 1!,+"!1 /!$(1
+!#/ $!1/,
+!/ 1!/-
"!(- ,!,+/
+!#- !(/
+!-/ 1!,(1
"!#( 1-!(/+
+!#- 1!/"
+!/1 +!/#
"!#" 1/!",#+!#- !$(
+!/# 1!11#
"!#1 1(!-/1
-
7/25/2019 Excel Tenaga Kerja New
44/59
'R)4UKTIVITA56HARI pro.u%ti7ita per orang per 3ari
$!,,$ 19 +!1//
#$!1, 16 !"/(
#$!+ 30 -!1+1
1!-$# 16 +!11(
+!"## 12 1!,+
1"-!$( 18 /!$(1
-$!11- 26 $!1/,
$-!("- 20 1!/-
""(!++, 24 ,!,+/
",!#+ 26 !(/
$(!+, 20 1!,(1
##"!1"+ 24 1-!(/+
##!$+1 23 1!/"
$!+/" 25 +!/#
#(!#/- 23 1/!",#
($!#"( 23 !$(
,!-(+ 25 1!11#
$"(!#/$ 23 1(!-/1
realiai elii3
$!,,$ 1"!",
#$!1, 1"!",
#$!+ +!++
1!-$# 81!(+
+!"## 8$+!++
1"-!$( 81!(+
-$!11- +!++
$-!("- 81!(+
""(!++, 8!
",!#+ +!++
$(!+, 81!(+
##"!1"+ 8!
##!$+1 +!++
$!+/" 81!(+
#(!#/- 81!(+
($!#"( +!++
,!-(+ 81!(+
$"(!#/$ +!++
-
7/25/2019 Excel Tenaga Kerja New
45/59
8##!,#
1/1!",
$!$$
8"1!,
-"!",(+!"/
((,!"/
11+!++
$1!$+
#$#!"
/"!--
1--!#$
$++!++
1!(+
+#!$($-!"1
1/!++
1#,!-$
-
7/25/2019 Excel Tenaga Kerja New
46/59
"#rasi "#rasi selisi$
7 3!2342857143 7!5466666667 133
7 36!965714286 43!126666667 17
14 243!02242857 425!28925 75
7 2!0961428571 3!66825 757 29!491428571 41!288 40
14 192!37185714 336!65075 75
14 83!118 83!118 0
14 44!078107143 77!1366875 75
14 855!00842943 1330!0131124 56
14 67!402 67!402 0
14 40!030625 70!05359375 75
14 573!63434503 892!32009227 56
14 44!3014 44!3014 0
14 26!395357143 46!191875 75
14 517!14045983 904!9958047 75
14 53!465 53!465 0
14 31!828321429 55!6995625 75
14 365!49255497 730!98510994 100
Pro%#kti&itas'er $ari
Pro%#kti&itas'er $ari
-
7/25/2019 Excel Tenaga Kerja New
47/59
"#rasi "#rasi elisi$
7 0!1010714286 0!3971929825 /$
7 1!1551785714 2!6954166667 1$$
14 8!100747619 14!176308333 ,(
7 0!0655044643 0!229265625 (+7 0!9216071429 3!4406666667 ,$
14 6!4123952381 18!702819444 1/
1 2!5974375 3!1968461538 $
14 1!3774408482 3!856834375 1-+
14 28!500280981 55!417213018 /#
1 2!1063125 2!5923846154 $
14 1!2509570313 3!5026796875 1-+
14 19!121144834 37!180003844 /#
1 1!38441875 1!9261478261 $/
14 0!8248549107 1!847675 1#14 17!238015328 39!347643683 1-
1 1!67078125 2!3245652174 $/
14 0!9946350446 2!2279825 1#
14 12!183085166 31!781961302 1"1
Pro%#k! Perorang 'er $ari
Pro%#k! Perorang 'er $ari
-
7/25/2019 Excel Tenaga Kerja New
48/59
rencana
Uraian 'e%er&aan Volume 3ari 'e%er&a Tu%ang
Lantai 1 Kolom
'engecoran 1-!" , + 1+
0e%iting +$!/ , + 1+
'em*eian ,!#" 1# 1- 1+
Lantai
Kolom
'engecoran /!"# , + 1+
0e%iting 1"!#- , + 1+
'em*eian +11!1 1# 1- 1+
0alo%
'engecoran #+!## 1# + 1+
0e%iting -,!$( 1# + 1+
'em*eian (((,!1$ 1# 1- 1+
'lat lantai
'engecoran #$!$ 1# + 1+
0e%iting $"1!+# 1# + 1+
'em*eian #(/$!# 1# 1- 1+
Lantai $
0alo%
'engecoran 1-!", 1# + 1+
0e%iting 1$"!" 1# + 1+
'em*eian "$!1# 1# 1- 1+
'lat lantai
'engecoran $!# 1# + 1+
0e%iting 1/$!"$ 1# + 1+
'em*eian 1",+!/" 1# 1- 1+
elii3
Uraian 'e%er&aan Volume 'e%er&a Tu%ang
'engecoran 1-!" / #
-
7/25/2019 Excel Tenaga Kerja New
49/59
Lantai 1 Kolom 0e%iting +$!/ 1 #
'em*eian ,!#" 81 1
Lantai
Kolom
'engecoran /!"# 1 #
0e%iting 1"!#- 1# "
'em*eian +11!1 , (
0alo%
'engecoran #+!## + "
0e%iting -,!$( - #
'em*eian (((,!1$ $ $
'lat lantai
'engecoran #$!$ + "
0e%iting $"1!+# - #
'em*eian #(/$!# $ $
Lantai $
0alo%
'engecoran 1-!", $ "
0e%iting 1$"!" $ #
'em*eian "$!1# # $
'lat lantai
'engecoran $!# $ "
0e%iting 1/$!"$ $ #'em*eian 1",+!/" # $
-
7/25/2019 Excel Tenaga Kerja New
50/59
realiai
pala tu%a Man.or Lantai
kolom
Pengecoran
18,62 31 1 1
1 1 Bekisting
203,9 61 1
1 1 Pembesian
2722,46 81 1 (Kg)
1 1 Lantai
Kolom
Pengecoran
9,64 41 1 2
1 1 Bekisting
126,48 51 1
1 1 Pembesian
2011,12 81 1 (Kg)
1 1
Balok
Pengecoran
40,44 11 1
1 1 Bekisting
287,35 81 1
1 1 Pembesian
5557,13 91 1 (Kg)
1 1
Plat lantai
Pengecoran
43,32 1
Bekisting
361,04 8
Pembesian
4593,24 9(Kg)
Lantai
Balok
Pengecoran
18!67 13
Bekisting
136!6 8
Pembesian
2632!14 8(Kg)
Plat lantai
Pengecoran
23!24 1
Bekisting
193!63 8
Pembesian
1670!96 7(Kg)
*raian Peker+aan enis Peker+aan
"#rasi
($ari)
pala tu%a Man.or Lantai Pengecoran
7+ + 1
(m3)
(m2)
(m3)
(m2)
(m3)
(m2)
(m3)
(m2)
(m3)
(m2)
(m3)
(m2)
/ol#me
'eker+aan
22,64 m3
-
7/25/2019 Excel Tenaga Kerja New
51/59
+ +
Kolom
Bekisting
7+ +
+ + Pembesian
3402,31 kg 14+ +
+ + Lantai
Kolom
Pengecoran
7+ + 2
+ + Bekisting
7+ +
+ + Pembesian
2693,21 kg 14+ +
+ +
Balok
Pengecoran
14+ +
+ + Bekisting
14+ +
+ + Pembesian
11970,12 kg 14+ ++ +
Plat lantai
Pengecoran
14
Bekisting
14
Pembesian
8030,88 kg 14
Lantai
Balok
Pengecoran
143
Bekisting
14
Pembesian
7239,97 kg 14
Plat lantai
Pengecoran
14
Bekisting
14
Pembesian
5116,90 kg 14
258,76 m2
14,67 m3
206,44 m2
83,12 m3
617,09 m2
67,40 m3
560,43 m2
44,30 m3
369,54 m2
53,47 m3
445,60 m2
-
7/25/2019 Excel Tenaga Kerja New
52/59
elii3
pe%er&a tu%ang pe%er&a
11 1 1 6
*raian Peker+aan8 1 1 6
19 1 1 9
Lantai
Kolom
1
8 1 1 6
6 1 1 4
11 1 1 5
Lantai
Kolom
2
20 1 1 4
12 1 1 6
15 1 1 7
Balok
20 1 1 4
12 1 1 6
15 1 1 7
Plat lantai
17 1 1 4
17 1 1 6
14 1 1 7
Lantai
Balok
3
17 1 1 4
17 1 1 6
14 1 1 7
Plat lantai
-encana (.)
Peker+a an%or Ke'ala
#kang (rang)
(orang) (rang) #kang
(rang)
6 1 1 1
-
7/25/2019 Excel Tenaga Kerja New
53/59
24 2 2 12
17 1 2 17
4 1 1 1
20 1 1 10
14 1 2 14
138 7 3 23
29 2 2 15
60 4 6 60
112 6 2 19
27 2 2 14
41 3 4 41
73 4 2 13
18 1 1 9
37 2 4 37
89 5 2 15
21 1 1 11
26 2 3 26
-
7/25/2019 Excel Tenaga Kerja New
54/59
enis Peker+aan
-encana (.)
"#rasi Peker+a an%or Ke'ala
#kang (rang) total
($ari) (orang) (rang) #kang
(rang)
Pengecoran
7 5 0 0 5 10
Bekisting
7 16 1 1 6 24
Pembesian
3402,31 kg 14 2 0 1 8 7
Pengecoran
7 4 0 0 5 9
Bekisting
7 14 0 0 6 20
Pembesian
2693,21 kg 14 3 0 1 9 13
Pengecoran
14 118 6 2 19 145
Bekisting
14 17 1 1 9 28
Pembesian
11970,12 kg 14 45 3 5 53 106
Pengecoran
14 92 5 1 15 113
Bekisting
14 15 1 1 8 25
Pembesian
8030,88 kg 14 26 2 3 34 65
Pengecoran
14 56 3 1 9 69
Bekisting
14 1 0 0 3 4
Pembesian
7239,97 kg 14 23 1 3 30 57
Pengecoran
14 72 4 1 11 88
Bekisting
14 4 0 0 5 9
Pembesian
5116,90 kg 14 12 1 2 19 34
/ol#me'eker+aan
22,64 m3
258,76 m2
14,67 m3
206,44 m2
83,12 m3
617,09 m2
67,40 m3
560,43 m2
44,30 m3
369,54 m2
53,47 m3
445,60 m2
-
7/25/2019 Excel Tenaga Kerja New
55/59
-
7/25/2019 Excel Tenaga Kerja New
56/59
Volume pe%er&aan pro2e%
Lantai 1 Kolom
'engecoran !"#$
Kolom
'engecoran
0e%iting #/!-- 0e%iting
'em*eian $#-#!- 'em*eian
lantai
0alo%
'engecoran -#!,$
0alo%
'engecoran
0e%iting (/(!($ 0e%iting
'em*eian 11!- 'em*eian
plat
'engecoran ,+!$#
plat
'engecoran
0e%iting (-"!1( 0e%iting
'em*eian ,"$/!( 'em*eian
Kolom
'engecoran 1#!$#
Kolom
'engecoran
0e%iting 1/,!// 0e%iting
'em*eian /(#!," 'em*eian
Lantai $
0alo%
'engecoran #!/
0alo%
'engecoran
0e%iting $1 0e%iting
'em*eian ""//!- 'em*eian
plat
'engecoran (!""
plat
'engecoran
0e%iting #$-!-" 0e%iting
'em*eian #-#-!1 'em*eian
-
7/25/2019 Excel Tenaga Kerja New
57/59
!"# 8+!+1
(-!," $!((
$#+!$1# 8!$,
-#!/-- -$!11- 81!/+
(/-!+"( "1,!+/$( $!"
11,(!11 11/,+!1 81!//
",!+1 ",!#+ 8#!1- (!1$11+1
((-!#- ("+!#-- 8#!$/
,#$+!-/ -+$+!--1 (!1
1#!",$ !$ $
+"!## #!,
,"+!( "/$!+" 8-!-( (!(#$/1,#,-
#!"1 ##!$+1# #!,"
$$#!-/, $"/!($( 1-!##
",,!+# ,$/!/"" -!+,
(!-# ($!#"( 1!($
##+!$, ##(!(/"( 1!($
#-$-!-- (11"!-/" (!(#
*raian Peker+aan
/ol#me %ari 'roek
Bekisting 'em*eian 'engecoran
%gLantai sat# Kolom 249,88
$9#-#9- 9"#$
Lantai %#a
Plat Lantai 586,15
,"$/9( ,+9$#
Kolom 197,99 /(#9," 1#9$#
Balok (/(9($ 119- -#9,$
Lantai tiga
Plat Lantai 438,86
#-#-91 (9""
Balok 312 ""//9- #9/
m
2
m
3
-
7/25/2019 Excel Tenaga Kerja New
58/59
NE:
Lantai 1 Kolom
'engecoran !"#$
Kolom
'engecoran
0e%iting #/!-- 0e%iting
'em*eian $#-#!- 'em*eian
lantai
0alo%
'engecoran -#!,$
0alo%
'engecoran
0e%iting (/(!($ 0e%iting
'em*eian 11!- 'em*eian
plat
'engecoran ,+!$#
plat
'engecoran
0e%iting (-"!1( 0e%iting
'em*eian ,"$/!( 'em*eian
Kolom
'engecoran 1#!$#
Kolom
'engecoran
0e%iting 1/,!// 0e%iting
'em*eian /(#!," 'em*eian
Lantai $
0alo%
'engecoran #!/
0alo%
'engecoran
0e%iting $1 0e%iting
'em*eian ""//!- 'em*eian
plat
'engecoran (!""
plat
'engecoran
0e%iting #$-!-" 0e%iting
'em*eian #-#-!1 'em*eian
Volume per3itungan manual
Bekisting 'em*eian 'engecoran
%g
(-9," $9$-$9$/# 9"#$
((-9#- ,#$+9-/ ",9+1
+"9## ,"+9( 1#9",$
(/-9+"( 11,(911 -#9/--
##+9$, #-$-9-- (9-#
$$#9-/, ",,9+# #9"1
m
2
m
3
-
7/25/2019 Excel Tenaga Kerja New
59/59
5ELI5IH
!"# 8+!+1
(-!," $!((
$#+!$1 8!$,
-$!1 81!/+
"1,!+/ $!"
11/,+!1 81!//
",!#+ 8#!1-
("+!#$ 8#!$/
-+$+!-- (!1
1#!- $!$$
+"!## #!,
"/$!1 8-!-(
##!$+ #!,"
$"/!(# 1-!##
,$/!/, -!+,
($!#, 1!($
##(!"+ 1!($
(11"!/+ (!(#