# 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