# This data file was generated by the Spreadsheet Calculator.
# You almost certainly shouldn't edit it.

set numeric
label A0 = "Week"
rightstring B0 = "xRT"
label D0 = "01/31"
label E0 = "02/07"
label F0 = "02/14"
label G0 = "02/21"
label H0 = "02/28"
label I0 = "03/07"
label J0 = "03/14"
label K0 = "03/21"
label L0 = "03/28"
label M0 = "04/04"
label N0 = "04/11"
label O0 = "04/18"
label P0 = "Total"
label A2 = "Alphonso"
let B2 = (F2/F3+G2/G3)*0.5
label C2 = "hours"
let D2 = 7.3
let E2 = 15.1
let F2 = 14
let G2 = 19.4
let H2 = 15
let I2 = 21.3
let J2 = 17.1
let K2 = 9.2
let L2 = 17.4
let M2 = 15.1
let N2 = 14.9
let O2 = 15
let P2 = @sum(D2:O2)
label C3 = "speech"
let D3 = 0.42
let E3 = 1.13
let F3 = 1.56
let G3 = 2.27
let H3 = 1.66
let I3 = 2.5
let J3 = 2.23
let K3 = 1.13
let L3 = 1.86
let M3 = 1.43
let N3 = 1.4
let O3 = O2/B2
let P3 = @sum(D3:N3)
label A5 = "Adebiyi"
let B5 = (F5/F6+G5/G6)*0.5
label C5 = "hours"
let D5 = 12.4
let E5 = 13.4
let F5 = 12.9
let G5 = 15.6
let H5 = 14.7
let I5 = 22.3
let J5 = 8.6
let K5 = 14.6
let L5 = 15.2
let M5 = 13.2
let N5 = 9.7
let O5 = 15
let P5 = @sum(D5:O5)
label C6 = "speech"
let D6 = 0.5
let E6 = 0.88
let F6 = 0.96
let G6 = 1.09
let H6 = 1.99
let I6 = 3.33
let J6 = 0.83
let K6 = 1.43
let L6 = 1.46
let M6 = 1.02
let N6 = 0.64
let O6 = O5/B5
let P6 = @sum(D6:N6)
label A8 = "Boatman"
let B8 = (F8/F9+G8/G9)*0.5
label C8 = "hours"
let D8 = 20
let E8 = 16.8
let F8 = 18.8
let G8 = 14.7
let H8 = 15.3
let I8 = 3.4
let J8 = 0
let K8 = 0
let L8 = 0
let M8 = 0
let N8 = 0
let O8 = 0
let P8 = @sum(D8:O8)
label C9 = "speech"
let D9 = 1.62
let E9 = 2.4
let F9 = 2.45
let G9 = 1.54
let H9 = 1.5
let I9 = 0.33
let J9 = J8/B8
let K9 = K8/B8
let L9 = L8/B8
let M9 = M8/B8
let N9 = N8/B8
let O9 = O8/B8
let P9 = @sum(D9:N9)
label A11 = "Brewer"
let B11 = (F11/F12+G11/G12)*0.5
label C11 = "hours"
let D11 = 20
let E11 = 19.1
let F11 = 18.8
let G11 = 19.1
let H11 = 17.9
let I11 = 26.6
let J11 = 8.2
let K11 = 0
let L11 = 0
let M11 = 0
let N11 = 0
let O11 = 0
let P11 = @sum(D11:O11)
label C12 = "speech"
let D12 = 1.48
let E12 = 1.08
let F12 = 1.12
let G12 = 0.99
let H12 = 1.5
let I12 = 2.33
let J12 = 0.67
let K12 = K11/B11
let L12 = L11/B11
let M12 = 0
let N12 = N11/B11
let O12 = O11/B11
let P12 = @sum(D12:N12)
label A14 = "Maddox"
let B14 = (F14/F15+G14/G15)*0.5
label C14 = "hours"
let D14 = 16
let E14 = 19.2
let F14 = 19.4
let G14 = 18.6
let H14 = 15.4
let I14 = 19.9
let J14 = 15.6
let K14 = 9
let L14 = 18.3
let M14 = 14.9
let N14 = 18
let O14 = 18.2
let P14 = @sum(D14:O14)
label C15 = "speech"
let D15 = 0.83
let E15 = 0.96
let F15 = 1.22
let G15 = 1.41
let H15 = 1.66
let I15 = 1.66
let J15 = 1.33
let K15 = 0.66
let L15 = 1.33
let M15 = 1.33
let N15 = 1.23
let O15 = O14/B14
let P15 = @sum(D15:N15)
label A17 = "Schulte"
let B17 = (F17/F18+G17/G18)*0.5
label C17 = "hours"
let D17 = 15
let E17 = 10.8
let F17 = 11.8
let G17 = 9.5
let H17 = 15.1
let I17 = 4
let J17 = 7.9
let K17 = 12.5
let L17 = 11.5
let M17 = 7.2
let N17 = 10.7
let O17 = 13
let P17 = @sum(D17:O17)
label C18 = "speech"
let D18 = 0.9
let E18 = 0.66
let F18 = 0.66
let G18 = 0.89
let H18 = 1.33
let I18 = 0.5
let J18 = 0.83
let K18 = 0.92
let L18 = 0.56
let M18 = 0.36
let N18 = N17/B17
let O18 = O17/B17
let P18 = @sum(D18:N18)
label A20 = "Wu"
let B20 = (E20/E21+F20/F21)*0.5
label C20 = "hours"
let D20 = 5.7
let E20 = 13.5
let F20 = 24.7
let G20 = 25.4
let H20 = 26.2
let I20 = 26.7
let J20 = 10.1
let K20 = 16.6
let L20 = 30.1
let M20 = 27
let N20 = 26
let O20 = 25
let P20 = @sum(D20:O20)
label C21 = "speech"
let D21 = 0.33
let E21 = 1.5
let F21 = 2.2
let G21 = 1.4
let H21 = 2.83
let I21 = 2.67
let J21 = J20/B20
let K21 = 1.69
let L21 = 2.8
let M21 = 2.48
let N21 = 2.7
let O21 = O20/B20
let P21 = @sum(D21:N21)
label A23 = "Zeng"
let B23 = (E23/E24+G23/G24)*0.5
label C23 = "hours"
let D23 = 20
let E23 = 20.3
let F23 = 20.3
let G23 = 20.4
let H23 = 26.6
let I23 = 30.1
let J23 = 20.2
let K23 = 20
let L23 = 6.7
let M23 = 23.2
let N23 = 19.9
let O23 = 25
let P23 = @sum(D23:O23)
label C24 = "speech"
let D24 = 2.33
let E24 = 2.13
let F24 = 0.9
let G24 = 1.7
let H24 = 2.49
let I24 = 3
let J24 = 2.17
let K24 = 1.92
let L24 = 0.44
let M24 = 1.66
let N24 = 1.7
let O24 = O23/B23
let P24 = @sum(D24:N24)
label A26 = "Zhang"
let B26 = (E26/E27+F26/F27)*0.5
label C26 = "hours"
let D26 = 13.5
let E26 = 14.9
let F26 = 20.2
let G26 = 25.3
let H26 = 25.3
let I26 = 25.5
let J26 = 23.7
let K26 = 15.5
let L26 = 11.2
let M26 = 30.3
let N26 = 26
let O26 = 25
let P26 = @sum(D26:O26)
label C27 = "speech"
let D27 = 0.42
let E27 = 1.3
let F27 = 1.93
let G27 = 0.33
let H27 = 2.49
let I27 = 2.5
let J27 = 2.33
let K27 = 1.5
let L27 = 1.51
let M27 = 2.88
let N27 = 2.75
let O27 = O26/B26
let P27 = @sum(D27:N27)
label A29 = "Zhao"
let B29 = (E29/E30+F29/F30)*0.5
label C29 = "hours"
let D29 = 7.8
let E29 = 17
let F29 = 20.7
let G29 = 24.1
let H29 = 25.3
let I29 = 26.3
let J29 = 23.9
let K29 = 15.9
let L29 = 11.2
let M29 = 26
let N29 = 26.3
let O29 = 25
let P29 = @sum(D29:O29)
label C30 = "speech"
let D30 = 0.25
let E30 = 1.31
let F30 = 1.81
let G30 = 0.78
let H30 = 2.14
let I30 = 2.14
let J30 = 2.33
let K30 = 1.98
let L30 = 1.7
let M30 = 2.39
let N30 = 2.4
let O30 = O29/B29
let P30 = @sum(D30:N30)
leftstring A31 = "----------------"
leftstring A32 = "Status:"
let D32 = 1
let E32 = 1
let F32 = 1
let G32 = 1
let H32 = 1
let I32 = 1
let J32 = 1
let K32 = 1
let L32 = 1
let M32 = 1
let N32 = 1
let O32 = 1
let P32 = @sum(D32:O32)
leftstring A33 = " logged:"
let B33 = (B2+B5+B8+B11+B14+B17+B20+B23+B26+B29)/10
let D33 = (D2+D5+D8+D11+D14+D17+D20+D23+D26+D29)*D32
let E33 = (E2+E5+E8+E11+E14+E17+E20+E23+E26+E29)*E32
let F33 = (F2+F5+F8+F11+F14+F17+F20+F23+F26+F29)*F32
let G33 = (G2+G5+G8+G11+G14+G17+G20+G23+G26+G29)*G32
let H33 = (H2+H5+H8+H11+H14+H17+H20+H23+H26+H29)*H32
let I33 = (I2+I5+I8+I11+I14+I17+I20+I23+I26+I29)*I32
let J33 = (J2+J5+J8+J11+J14+J17+J20+J23+J26+J29)*J32
let K33 = (K2+K5+K8+K11+K14+K17+K20+K23+K26+K29)*K32
let L33 = (L2+L5+L8+L11+L14+L17+L20+L23+L26+L29)*L32
let M33 = (M2+M5+M8+M11+M14+M17+M20+M23+M26+M29)*M32
let N33 = (N2+N5+N8+N11+N14+N17+N20+N23+N26+N29)*N32
let O33 = (O2+O5+O8+O11+O14+O17+O20+O23+O26+O29)*O32
let P33 = @sum(D33:O33)
leftstring A34 = " speech:"
let D34 = (D3+D6+D9+D12+D15+D18+D21+D24+D27+D30)*D32
let E34 = (E3+E6+E9+E12+E15+E18+E21+E24+E27+E30)*E32
let F34 = (F3+F6+F9+F12+F15+F18+F21+F24+F27+F30)*F32
let G34 = (G3+G6+G9+G12+G15+G18+G21+G24+G27+G30)*G32
let H34 = (H3+H6+H9+H12+H15+H18+H21+H24+H27+H30)*H32
let I34 = (I3+I6+I9+I12+I15+I18+I21+I24+I27+I30)*I32
let J34 = (J3+J6+J9+J12+J15+J18+J21+J24+J27+J30)*J32
let K34 = (K3+K6+K9+K12+K15+K18+K21+K24+K27+K30)*K32
let L34 = (L3+L6+L9+L12+L15+L18+L21+L24+L27+L30)*L32
let M34 = (M3+M6+M9+M12+M15+M18+M21+M24+M27+M30)*M32
let N34 = (N3+N6+N9+N12+N15+N18+N21+N24+N27+N30)*N32
let O34 = (O3+O6+O9+O12+O15+O18+O21+O24+O27+O30)*O32
let P34 = @sum(D34:O34)
leftstring A37 = "Data:"
leftstring A38 = " hours of data:"
let D38 = 168
leftstring A39 = " hours finished:"
let D39 = P34
leftstring A40 = " hours remaining:"
let D40 = D38-D39
leftstring A42 = "Staffing:"
leftstring A43 = " required hours:"
let D43 = D38*B33
leftstring A44 = " logged hours:"
let D44 = P33
leftstring A45 = " remaining hours:"
let D45 = D43-D44
leftstring A47 = "Projections:"
leftstring A48 = " logged hours:"
let D48 = P2+P5+P8+P11+P14+P17+P20+P23+P26+P29
leftstring A49 = " hours of speech:"
let D49 = P3+P6+P9+P12+P15+P18+P21+P24+P27+P30
leftstring A50 = " surplus hours:"
let D50 = (D49-D38)*B33
goto O30