excel tenaga kerja new

Upload: mathius-leo

Post on 27-Feb-2018

218 views

Category:

Documents


0 download

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"!/+ (!(#