# 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 = "05/02" label E0 = "05/09" label F0 = "05/16" label G0 = "05/23" label H0 = "05/30" label I0 = "06/06" label J0 = "06/13" label K0 = "06/20" label L0 = "06/27" label M0 = "07/04" label N0 = "07/11" label O0 = "07/18" label P0 = "07/25" label Q0 = "08/01" label R0 = "08/08" label S0 = "08/15" label T0 = "08/22" label U0 = "08/29" label V0 = "09/05" label W0 = "09/12" label X0 = "09/19" label Y0 = "09/26" label Z0 = "10/03" label AA0 = "10/10" label AB0 = "10/17" label AC0 = "10/24" label AD0 = "10/31" label AE0 = "11/07" label AF0 = "11/14" label AG0 = "11/21" label AH0 = "11/28" label AI0 = "12/05" label AJ0 = "12/12" label AK0 = "12/19" label AL0 = "12/26" label AM0 = "01/02" label AN0 = "01/09" label AO0 = "01/16" label AP0 = "01/23" label AQ0 = "Total" label A2 = "Aragh" let B2 = 10 label C2 = "hours" let D2 = 20.7 let E2 = 10.2 let F2 = 13 let G2 = 4.1 let H2 = 23.5 let I2 = 32.1 let J2 = 32.2 let K2 = 25.7 let L2 = 21 let M2 = 23 let N2 = 22 let O2 = 22 let P2 = 10 let Q2 = 0 let R2 = 28 let S2 = 20 let T2 = 23 let U2 = 20 let V2 = 20 let W2 = 12 let X2 = 23 let Y2 = 11 let Z2 = 14 let AA2 = 16 let AB2 = 16 let AC2 = 16 let AD2 = 20.5 let AE2 = 16.5 let AF2 = 12 let AG2 = 8.5 let AH2 = 18 let AI2 = 13 let AJ2 = 8 let AK2 = 7 let AL2 = 15 let AM2 = 15 let AN2 = 15 let AO2 = 15 let AP2 = 15 let AQ2 = @sum(E2:AP2) label C3 = "speech" let D3 = 0.75 let E3 = 0.5 let F3 = 0.75 let G3 = 0.25 let H3 = 2.16 let I3 = 2.48 let J3 = 2.81 let K3 = 1.7 let L3 = 1.25 let M3 = 1.41 let N3 = 1.1 let O3 = 1.25 let P3 = 0.5 let Q3 = Q2/B2 let R3 = 1.33 let S3 = 1.54 let T3 = T2/B2 let U3 = 2.11 let V3 = 2.11 let W3 = 0.87 let X3 = 1.6 let Y3 = 1.15 let Z3 = 0.89 let AA3 = 1.8 let AB3 = 2.27 let AC3 = 1.97 let AD3 = 2.66 let AE3 = 1.83 let AF3 = 1.5 let AG3 = 1 let AH3 = 2.5 let AI3 = 2.33 let AJ3 = 0.83 let AK3 = 0.93 let AL3 = AL2/B2 let AM3 = AM2/B2 let AN3 = AN2/B2 let AO3 = AO2/B2 let AP3 = AP2/B2 let AQ3 = @sum(E3:AP3) let AQ4 = @sum(E4:AK4) label A5 = "George" let B5 = 12.5 label C5 = "hours" let D5 = 0 let E5 = 0 let F5 = 22 let G5 = 20.2 let H5 = 10.8 let I5 = 16 let J5 = 18.2 let K5 = 19 let L5 = 22 let M5 = 19 let N5 = 20 let O5 = 19 let P5 = 6 let Q5 = 16 let R5 = 23 let S5 = 7 let T5 = 15 let U5 = 16 let V5 = 16 let W5 = 18 let X5 = 21 let Y5 = 16 let Z5 = 12 let AA5 = 11 let AB5 = 21 let AC5 = 20 let AD5 = 22 let AE5 = 16.5 let AF5 = 15 let AG5 = 20.5 let AH5 = 16 let AI5 = 27.5 let AJ5 = 13 let AK5 = 12 let AL5 = 15 let AM5 = 15 let AN5 = 15 let AO5 = 15 let AP5 = 15 let AQ5 = @sum(E5:AP5) label C6 = "speech" let D6 = 0 let E6 = 0 let F6 = 0.42 let G6 = 1.08 let H6 = 0.91 let I6 = 1.49 let J6 = 2.15 let K6 = 1.33 let L6 = 0.83 let M6 = 0.83 let N6 = 1.5 let O6 = 1.16 let P6 = 0.41 let Q6 = 0.96 let R6 = 1.86 let S6 = 0.58 let T6 = 1.3 let U6 = 1.61 let V6 = 1.61 let W6 = 1.61 let X6 = 1.3 let Y6 = 1.15 let Z6 = 0.63 let AA6 = AA5/B5 let AB6 = 1.85 let AC6 = 1.33 let AD6 = 1.61 let AE6 = 1.16 let AF6 = 1 let AG6 = 1.7 let AH6 = 1.45 let AI6 = 1.98 let AJ6 = 1.33 let AK6 = 1 let AL6 = AL5/B5 let AM6 = AM5/B5 let AN6 = AN5/B5 let AO6 = AO5/B5 let AP6 = AP5/B5 let AQ6 = @sum(E6:AP6) label A8 = "Jensen/" let B8 = 12.5 label C8 = "hours" let D8 = 14.5 let E8 = 1.9 let F8 = 0 let G8 = 0 let H8 = 10.6 let I8 = 16.1 let J8 = 13 let K8 = 6 let L8 = 9 let M8 = 0 let N8 = 0 let O8 = 0 let P8 = 0 let Q8 = 0 let R8 = 0 let S8 = 0 let T8 = 8 let U8 = 12.5 let V8 = 12.5 let W8 = 13 let X8 = 18.5 let Y8 = 16 let Z8 = 11 let AA8 = 17 let AB8 = 13.5 let AC8 = 17.5 let AD8 = 20 let AE8 = 20 let AF8 = 10.5 let AG8 = 15.5 let AH8 = 10.5 let AI8 = 13.5 let AJ8 = 8 let AK8 = 29 let AL8 = 15 let AM8 = 15 let AN8 = 15 let AO8 = 15 let AP8 = 15 let AQ8 = @sum(E8:AP8) label A9 = "Foote" label C9 = "speech" let D9 = 2.5 let E9 = 0.25 let F9 = 0 let G9 = 0 let H9 = 1.24 let I9 = 1.58 let J9 = J8/B8 let K9 = 0.86 let L9 = 1.48 let M9 = 0 let N9 = 0 let O9 = O8/B8 let P9 = P8/B8 let Q9 = Q8/B8 let R9 = R8/B8 let S9 = S8/B8 let T9 = 0.4 let U9 = 0.92 let V9 = 0.92 let W9 = 0.91 let X9 = 1.1 let Y9 = 1.1 let Z9 = 0.95 let AA9 = 1.4 let AB9 = 0.85 let AC9 = 0.99 let AD9 = 1.16 let AE9 = 1.66 let AF9 = 1 let AG9 = AG8/B8 let AH9 = AH8/B8 let AI9 = 1.17 let AJ9 = 0.94 let AK9 = 3.66 let AL9 = AL8/B8 let AM9 = AM8/B8 let AN9 = AN8/B8 let AO9 = AO8/B8 let AP9 = AP8/B8 let AQ9 = @sum(E9:AP9) label A11 = "Maddox/" let B11 = 11 label C11 = "hours" let D11 = 18.5 let E11 = 7.5 let F11 = 18.2 let G11 = 18 let H11 = 14.5 let I11 = 0 let J11 = 0 let K11 = 0 let L11 = 0 let M11 = 18.5 let N11 = 16 let O11 = 18 let P11 = 18 let Q11 = 16 let R11 = 6 let S11 = 7 let T11 = 0 let U11 = 15 let V11 = 15 let W11 = 15 let X11 = 16.5 let Y11 = 17 let Z11 = 13 let AA11 = 15 let AB11 = 17.5 let AC11 = 20 let AD11 = 15 let AE11 = 19 let AF11 = 13 let AG11 = 9 let AH11 = 16.5 let AI11 = 17.5 let AJ11 = 21 let AK11 = 4.5 let AL11 = 15 let AM11 = 15 let AN11 = 15 let AO11 = 15 let AP11 = 15 let AQ11 = @sum(E11:AP11) label A12 = "Robinson" label C12 = "speech" let D12 = 1.5 let E12 = 0.75 let F12 = 1.9 let G12 = 1.6 let H12 = 1.49 let I12 = 0 let J12 = J11/B11 let K12 = K11/B11 let L12 = 0 let M12 = 1.08 let N12 = 1.08 let O12 = 1.16 let P12 = 0.91 let Q12 = 1.1 let R12 = 0.34 let S12 = 0.25 let T12 = T11/B11 let U12 = 0.73 let V12 = 0.73 let W12 = W11/B11 let X12 = 1 let Y12 = 1.05 let Z12 = 1.3 let AA12 = AA11/B11 let AB12 = 1.75 let AC12 = AC11/B11 let AD12 = 1.16 let AE12 = 1.5 let AF12 = 1 let AG12 = 0.83 let AH12 = 1.66 let AI12 = 2 let AJ12 = 2.2 let AK12 = 0.58 let AL12 = AL11/B11 let AM12 = AM11/B11 let AN12 = AN11/B11 let AO12 = AO11/B11 let AP12 = AP11/B11 let AQ12 = @sum(E12:AP12) let S13 = 0 let T13 = 0 let U13 = 0 label A14 = "Vogel" let B14 = 9 label C14 = "hours" let D14 = 0 let E14 = 0 let F14 = 0 let G14 = 0 let H14 = 0 let I14 = 14 let J14 = 20 let K14 = 18 let L14 = 17.5 let M14 = 8.5 let N14 = 23 let O14 = 24 let P14 = 21.1 let Q14 = 0 let R14 = 0 let S14 = 0 let T14 = 8 let U14 = 22.5 let V14 = 20 let W14 = 19 let X14 = 15 let Y14 = 18 let Z14 = 22 let AA14 = 11 let AB14 = 16 let AC14 = 21 let AD14 = 15 let AE14 = 15 let AF14 = 12 let AG14 = 11 let AH14 = 14 let AI14 = 18 let AJ14 = 17 let AK14 = 0 let AL14 = 0 let AM14 = 0 let AN14 = 15 let AO14 = 15 let AP14 = 15 let AQ14 = @sum(E14:AP14) label C15 = "speech" let D15 = 0 let E15 = 0 let F15 = 0 let G15 = 0 let H15 = 0 let I15 = 0.85 let J15 = 2.3 let K15 = 1.9 let L15 = 1.66 let M15 = 1.66 let N15 = 1.91 let O15 = 2.4 let P15 = 2.16 let Q15 = 0 let R15 = 0 let S15 = 0 let T15 = 0.65 let U15 = 2.3 let V15 = 2.3 let W15 = 2.2 let X15 = 1.6 let Y15 = 2.02 let Z15 = 2.2 let AA15 = 0.9 let AB15 = 1.87 let AC15 = 1.95 let AD15 = 1.61 let AE15 = 1.66 let AF15 = AF14/B14 let AG15 = 1.16 let AH15 = 2.16 let AI15 = 2.16 let AJ15 = 2.5 let AK15 = AK14/B14 let AN15 = AN14/B14 let AO15 = AO14/B14 let AP15 = AP14/B14 let AQ15 = @sum(E15:AP15) label A17 = "Lorena" let B17 = 9 label C17 = "hours" let D17 = 0 let E17 = 0 let F17 = 0 let G17 = 0 let H17 = 0 let I17 = 0 let J17 = 0 let K17 = 0 let L17 = 0 let M17 = 0 let N17 = 0 let O17 = 0 let P17 = 0 let Q17 = 0 let R17 = 0 let S17 = 0 let T17 = 0 let U17 = 0 let V17 = 0 let W17 = 0 let X17 = 0 let Y17 = 0 let Z17 = 0 let AA17 = 0 let AB17 = 0 let AC17 = 0 let AD17 = 0 let AE17 = 0 let AF17 = 6 let AG17 = 10 let AH17 = 14 let AI17 = 0 let AJ17 = 0 let AK17 = 9.5 let AL17 = 10 let AM17 = 10 let AN17 = 15 let AO17 = 15 let AP17 = 15 let AQ17 = @sum(E17:AP17) label C18 = "speech" let D18 = 0 let E18 = 0 let F18 = 0 let G18 = 0 let H18 = 0 let I18 = 0 let J18 = 0 let K18 = 0 let L18 = 0 let M18 = 0 let N18 = 0 let O18 = 0 let P18 = 0 let Q18 = 0 let R18 = 0 let S18 = 0 let T18 = 0 let U18 = 0 let V18 = 0 let W18 = 0 let X18 = 0 let Y18 = 0 let Z18 = 0 let AA18 = 0 let AB18 = 0 let AC18 = 0 let AD18 = 0 let AE18 = 0 let AF18 = 1.33 let AG18 = 1 let AH18 = 1 let AI18 = 0 let AJ18 = 0 let AK18 = 2.09 let AL18 = AL17/B17 let AM18 = AM17/B17 let AN18 = AN17/B17 let AO18 = AO17/B17 let AP18 = AP17/B17 let AQ18 = @sum(E18:AP18) leftstring A20 = "----------------" leftstring A21 = "Status:" let D21 = 1 let E21 = 1 let F21 = 1 let G21 = 1 let H21 = 1 let I21 = 1 let J21 = 1 let K21 = 1 let L21 = 1 let M21 = 1 let N21 = 1 let O21 = 1 let P21 = 1 let Q21 = 1 let R21 = 1 let S21 = 1 let T21 = 1 let U21 = 1 let V21 = 1 let W21 = 1 let X21 = 1 let Y21 = 1 let Z21 = 1 let AA21 = 1 let AB21 = 1 let AC21 = 1 let AD21 = 1 let AE21 = 1 let AF21 = 1 let AG21 = 1 let AH21 = 1 let AI21 = 1 let AJ21 = 1 let AK21 = 1 let AL21 = 1 let AM21 = 1 let AN21 = 1 let AO21 = 1 let AP21 = 1 let AQ21 = @sum(E21:AP21) leftstring A22 = " logged:" let B22 = (B2+B5+B8+B11+B14)/5 let D22 = (D2+D5+D8+D11+D14+D17)*D21 let E22 = (E2+E5+E8+E11+E14+E17)*E21 let F22 = (F2+F5+F8+F11+F14+F17)*F21 let G22 = (G2+G5+G8+G11+G14+G17)*G21 let H22 = (H2+H5+H8+H11+H14+H17)*H21 let I22 = (I2+I5+I8+I11+I14+I17)*I21 let J22 = (J2+J5+J8+J11+J14+J17)*J21 let K22 = (K2+K5+K8+K11+K14+K17)*K21 let L22 = (L2+L5+L8+L11+L14+L17)*L21 let M22 = (M2+M5+M8+M11+M14+M17)*M21 let N22 = (N2+N5+N8+N11+N14+N17)*N21 let O22 = (O2+O5+O8+O11+O14+O17)*O21 let P22 = (P2+P5+P8+P11+P14+P17)*P21 let Q22 = (Q2+Q5+Q8+Q11+Q14+Q17)*Q21 let R22 = (R2+R5+R8+R11+R14+R17)*R21 let S22 = (S2+S5+S8+S11+S14+S17)*S21 let T22 = (T2+T5+T8+T11+T14+T17)*T21 let U22 = (U2+U5+U8+U11+U14+U17)*U21 let V22 = (V2+V5+V8+V11+V14+V17)*V21 let W22 = (W2+W5+W8+W11+W14+W17)*W21 let X22 = (X2+X5+X8+X11+X14+X17)*X21 let Y22 = (Y2+Y5+Y8+Y11+Y14+Y17)*Y21 let Z22 = (Z2+Z5+Z8+Z11+Z14+Z17)*Z21 let AA22 = (AA2+AA5+AA8+AA11+AA14+AA17)*AA21 let AB22 = (AB2+AB5+AB8+AB11+AB14+AB17)*AB21 let AC22 = (AC2+AC5+AC8+AC11+AC14+AC17)*AC21 let AD22 = (AD2+AD5+AD8+AD11+AD14+AD17)*AD21 let AE22 = (AE2+AE5+AE8+AE11+AE14+AE17)*AE21 let AF22 = (AF2+AF5+AF8+AF11+AF14+AF17)*AF21 let AG22 = (AG2+AG5+AG8+AG11+AG14+AG17)*AG21 let AH22 = (AH2+AH5+AH8+AH11+AH14+AH17)*AH21 let AI22 = (AI2+AI5+AI8+AI11+AI14+AI17)*AI21 let AJ22 = (AJ2+AJ5+AJ8+AJ11+AJ14+AJ17)*AJ21 let AK22 = (AK2+AK5+AK8+AK11+AK14+AK17)*AK21 let AL22 = (AL2+AL5+AL8+AL11+AL14+AL17)*AL21 let AM22 = (AM2+AM5+AM8+AM11+AM14+AM17)*AM21 let AN22 = (AN2+AN5+AN8+AN11+AN14+AN17)*AN21 let AO22 = (AO2+AO5+AO8+AO11+AO14+AO17)*AO21 let AP22 = (AP2+AP5+AP8+AP11+AP14+AP17)*AP21 let AQ22 = @sum(E22:AP22) leftstring A23 = " speech:" let D23 = (D3+D6+D9+D12+D15+D18)*D21 let E23 = (E3+E6+E9+E12+E15+E18)*E21 let F23 = (F3+F6+F9+F12+F15+F18)*F21 let G23 = (G3+G6+G9+G12+G15+G18)*G21 let H23 = (H3+H6+H9+H12+H15+H18)*H21 let I23 = (I3+I6+I9+I12+I15+I18)*I21 let J23 = (J3+J6+J9+J12+J15+J18)*J21 let K23 = (K3+K6+K9+K12+K15+K18)*K21 let L23 = (L3+L6+L9+L12+L15+L18)*L21 let M23 = (M3+M6+M9+M12+M15+M18)*M21 let N23 = (N3+N6+N9+N12+N15+N18)*N21 let O23 = (O3+O6+O9+O12+O15+O18)*O21 let P23 = (P3+P6+P9+P12+P15+P18)*P21 let Q23 = (Q3+Q6+Q9+Q12+Q15+Q18)*Q21 let R23 = (R3+R6+R9+R12+R15+R18)*R21 let S23 = (S3+S6+S9+S12+S15+S18)*S21 let T23 = (T3+T6+T9+T12+T15+T18)*T21 let U23 = (U3+U6+U9+U12+U15+U18)*U21 let V23 = (V3+V6+V9+V12+V15+V18)*V21 let W23 = (W3+W6+W9+W12+W15+W18)*W21 let X23 = (X3+X6+X9+X12+X15+X18)*X21 let Y23 = (Y3+Y6+Y9+Y12+Y15+Y18)*Y21 let Z23 = (Z3+Z6+Z9+Z12+Z15+Z18)*Z21 let AA23 = (AA3+AA6+AA9+AA12+AA15+AA18)*AA21 let AB23 = (AB3+AB6+AB9+AB12+AB15+AB18)*AB21 let AC23 = (AC3+AC6+AC9+AC12+AC15+AC18)*AC21 let AD23 = (AD3+AD6+AD9+AD12+AD15+AD18)*AD21 let AE23 = (AE3+AE6+AE9+AE12+AE15+AE18)*AE21 let AF23 = (AF3+AF6+AF9+AF12+AF15+AF18)*AF21 let AG23 = (AG3+AG6+AG9+AG12+AG15+AG18)*AG21 let AH23 = (AH3+AH6+AH9+AH12+AH15+AH18)*AH21 let AI23 = (AI3+AI6+AI9+AI12+AI15+AI18)*AI21 let AJ23 = (AJ3+AJ6+AJ9+AJ12+AJ15+AJ18)*AJ21 let AK23 = (AK3+AK6+AK9+AK12+AK15+AK18)*AK21 let AL23 = (AL3+AL6+AL9+AL12+AL15+AL18)*AL21 let AM23 = (AM3+AM6+AM9+AM12+AM15+AM18)*AM21 let AN23 = (AN3+AN6+AN9+AN12+AN15+AN18)*AN21 let AO23 = (AO3+AO6+AO9+AO12+AO15+AO18)*AO21 let AP23 = (AP3+AP6+AP9+AP12+AP15+AP18)*AP21 let AQ23 = @sum(E23:AP23) leftstring A26 = "Data:" leftstring A27 = " hours of data:" let E27 = 242 leftstring A28 = " hours finished:" let E28 = AQ23 leftstring A29 = " hours remaining:" let E29 = E27-E28 leftstring A31 = "Staffing:" leftstring A32 = " required hours:" let E32 = E27*B22 leftstring A33 = " logged hours:" let E33 = AQ22 leftstring A34 = " remaining hours:" let E34 = E32-E33 leftstring A36 = "Projections:" leftstring A37 = " logged hours:" let E37 = AQ2+AQ5+AQ8+AQ11+AQ14 leftstring A38 = " hours of speech:" let E38 = AQ3+AQ6+AQ9+AQ12+AQ15 leftstring A39 = " surplus hours:" let E39 = (E38-E27)*B22 goto E35