Spreadsheet: 96213d1295623832-summing-values-from-different-dates-for-monthly-total-emergent-example
Sheet: Emergent

Date | Work Group | Daily Emergent Dose-2010
2010-01-07 00:00:00 | FIN | 0.004
2010-01-08 00:00:00 | FIN | 0.012
2010-01-08 00:00:00 | FIN | 0.02
2010-01-08 00:00:00 | RXS | 0.069
2010-01-16 00:00:00 | OPS | 0.091
2010-01-16 00:00:00 | MMD | 1.951
2010-01-16 00:00:00 | EMD | 0.152
2010-01-16 00:00:00 | IMD | 0.009
2010-01-16 00:00:00 | RP | 0.08
2010-01-16 00:00:00 | Des. Eng | 0.002
2010-01-16 00:00:00 | CHEM | 0.001
2010-01-16 00:00:00 | MISC | 0.394
2010-01-16 00:00:00 | Plant Eng. | 0.138
2010-01-17 00:00:00 | OPS | 0.001
2010-01-17 00:00:00 | MMD | 0.552
2010-01-17 00:00:00 | EMD | 0.053
2010-01-17 00:00:00 | RP | 0.009
2010-01-17 00:00:00 | MISC | 0.233
2010-01-22 00:00:00 | EMD | 0.006
2010-01-23 00:00:00 | RP | 0.023
2010-01-23 00:00:00 | OPS | 0.008
2010-01-28 00:00:00 | MMD | 0.034
2010-01-28 00:00:00 | RP | 0.037
Jan
Feb
2010-03-07 00:00:00 | FIN | 0.148
2010-03-07 00:00:00 | MMD | 0.183
2010-03-07 00:00:00 | RP | 0.003
2010-03-08 00:00:00 | FIN | 0.256
2010-03-08 00:00:00 | OPS | 0.045
2010-03-08 00:00:00 | RP | 0.104
2010-03-09 00:00:00 | FIN | 0.135
2010-03-09 00:00:00 | OPS | 0.155
2010-03-10 00:00:00 | OPS | 0.059
2010-03-10 00:00:00 | FIN | 0.006
2010-03-10 00:00:00 | FIN | 0.018
2010-03-12 00:00:00 | MISC | 0.012
2010-03-12 00:00:00 | RP | 0.019
2010-03-14 00:00:00 | OPS
2010-03-16 00:00:00 | RP | 0.005
2010-03-17 00:00:00 | PSA | 0.149
2010-03-18 00:00:00 | OPS | 0.015
2010-03-24 00:00:00 | OPS | 0.118
2010-03-24 00:00:00 | RP | 0.019
2010-03-25 00:00:00 | RP | 0.01
2010-03-25 00:00:00 | RP | 0.005
2010-03-28 00:00:00 | OPS | 0.005
2010-03-31 00:00:00 | FIN | 0.022
Mar
2010-04-01 00:00:00 | FIN | 0.175
2010-04-01 00:00:00 | OPS | 0.015
2010-04-06 00:00:00 | FIN | 0.012
2010-04-09 00:00:00 | RP | 0.021
2010-04-09 00:00:00 | Plant Eng. | 0.045
2010-04-12 00:00:00 | IMD | 0.16
2010-04-14 00:00:00 | PSA | 0.004
2010-04-14 00:00:00 | FIN | 0.064
2010-04-14 00:00:00 | EMD | 0.011
2010-04-18 00:00:00 | OPS | 0.001
2010-04-19 00:00:00 | FIN | 0.003
2010-04-19 00:00:00 | FIN | 0.032
2010-04-21 00:00:00 | PSA | 0.083
Apr
2010-05-04 00:00:00 | FIN | 0.033
2010-05-05 00:00:00 | FIN | 0.028
2010-05-05 00:00:00 | FIN | 0.015
2010-05-05 00:00:00 | OPS | 0.023
2010-05-06 00:00:00 | OPS | 0.029
2010-05-06 00:00:00 | RP | 0.025
2010-05-07 00:00:00 | FIN | 0.002
2010-05-07 00:00:00 | IMD | 0.004
2010-05-07 00:00:00 | IMD | 0.003
2010-05-11 00:00:00 | EMD | 0.004
2010-05-11 00:00:00 | MMD | 0.004
2010-05-12 00:00:00 | MMD | 0.003
2010-05-12 00:00:00 | MMD | 0.016
2010-05-13 00:00:00 | RXS | 0.011
2010-05-13 00:00:00 | MMD | 0.019
2010-05-14 00:00:00 | MMD | 0.009
2010-05-14 00:00:00 | RXS | 0.002
2010-05-17 00:00:00 | MMD | 0.016
2010-05-18 00:00:00 | MMD | 0.034
2010-05-19 00:00:00 | FIN | 0.004
2010-05-19 00:00:00 | MMD | 0.01
2010-05-19 00:00:00 | MMD | 0.041
2010-05-20 00:00:00 | MMD | 0.018
2010-05-20 00:00:00 | MMD | 0.004
2010-05-20 00:00:00 | OPS | 0.003
2010-05-23 00:00:00 | MMD | 0.701
2010-05-24 00:00:00 | Plant Eng. | 0.011
2010-05-24 00:00:00 | PSA | 0.024
2010-05-26 00:00:00 | FIN | 0.006
2010-05-26 00:00:00 | FIN | 0.003
2010-05-28 00:00:00 | FIN | 0.005
2010-05-30 00:00:00 | FIN | 0.002
2010-05-30 00:00:00 | IMD | 0.121
2010-05-30 00:00:00 | MMD | 0.056
2010-05-30 00:00:00 | OPS | 0.002
2010-05-30 00:00:00 | RP | 0.001
2010-05-31 00:00:00 | EMD | 0.021
May
2010-06-01 00:00:00 | Energy Sol. | 0.031
2010-06-02 00:00:00 | FIN | 0.017
2010-06-02 00:00:00 | FIN | 0.166
2010-06-03 00:00:00 | FIN | 0.05
2010-06-03 00:00:00 | RP | 0.004
2010-06-03 00:00:00 | MMD | 0.019
2010-06-04 00:00:00 | MISC | 0.067
2010-06-04 00:00:00 | RP | 0.025
2010-06-05 00:00:00 | MMD | 0.029
2010-06-05 00:00:00 | RP | 0.007
2010-06-05 00:00:00 | PSA | 0.021
2010-06-06 00:00:00 | OPS | 0.037
2010-06-08 00:00:00 | OPS | 0.085
2010-06-08 00:00:00 | Plant Eng. | 0.006
2010-06-11 00:00:00 | FIN | 0.017
2010-06-14 00:00:00 | PSA | 0.024
2010-06-14 00:00:00 | MMD | 0.005
2010-06-15 00:00:00 | CHEM | 0.014
2010-06-15 00:00:00 | MMD | 0.006
2010-06-15 00:00:00 | MMD | 0.002
2010-06-15 00:00:00 | Security | 0.003
2010-06-16 00:00:00 | MMD | 0.005
2010-06-16 00:00:00 | MMD | 0.005
2010-06-16 00:00:00 | MMD | 0.021
2010-06-17 00:00:00 | MMD | 0.077
2010-06-17 00:00:00 | OPS | 0.107
2010-06-18 00:00:00 | MMD | 0.073
2010-06-18 00:00:00 | Plant Eng. | 0.009
2010-06-18 00:00:00 | RP | 0.005
2010-06-18 00:00:00 | OPS | 0.031
2010-06-21 00:00:00 | PSA | 0.008
2010-06-21 00:00:00 | OPS | 0.005
2010-06-21 00:00:00 | MMD | 0.069
2010-06-23 00:00:00 | FIN | 0.017
2010-06-23 00:00:00 | PSA | 0.027
2010-06-23 00:00:00 | MMD | 0.057
2010-06-23 00:00:00 | MMD | 0.021
2010-06-24 00:00:00 | EMD | 0.017
2010-06-24 00:00:00 | MMD | 0.032
2010-06-24 00:00:00 | FIN | 0.008
2010-06-24 00:00:00 | PSA | 0.011
2010-06-25 00:00:00 | FIN | 0.017
2010-06-26 00:00:00 | EMD | 0.017
2010-06-26 00:00:00 | MMD | 0.054
2010-06-28 00:00:00 | MMD | 0.01
2010-06-28 00:00:00 | MMD | 0.08
2010-06-28 00:00:00 | Plant Eng. | 0.003
2010-06-29 00:00:00 | OPS | 0.07
2010-06-30 00:00:00 | FIN | 0.015
2010-06-30 00:00:00 | RP | 0.015
2010-06-30 00:00:00 | OPS | 0.129
2010-06-30 00:00:00 | MMD | 0.004
2010-06-30 00:00:00 | Plant Eng. | 0.012
2010-06-30 00:00:00 | MISC | 0.008
2010-06-30 00:00:00 | IMD | 0.018
2010-06-30 00:00:00 | CHEM | 0.006
Jun
2010-07-01 00:00:00 | PSA | 0.057
2010-07-01 00:00:00 | RXS | 0.035
2010-07-02 00:00:00 | MMD | 0.044
2010-07-02 00:00:00 | IMD | 0.018
2010-07-04 00:00:00 | MMD | 0.005
2010-07-05 00:00:00 | MMD | 0.011
2010-07-05 00:00:00 | PSA | 0.116
2010-07-05 00:00:00 | RP | 0.054
2010-07-06 00:00:00 | MMD | 0.009
2010-07-06 00:00:00 | MISC | 0.01
2010-07-07 00:00:00 | MMD | 0.004
2010-07-07 00:00:00 | RP | 0.002
2010-07-07 00:00:00 | MISC | 0.016
2010-07-08 00:00:00 | MISC | 0.011
2010-07-09 00:00:00 | MMD | 0.001
2010-07-09 00:00:00 | MISC | 0.023
2010-07-10 00:00:00 | MMD | 0.012
2010-07-10 00:00:00 | RP | 0.001
2010-07-10 00:00:00 | MISC | 0.009
2010-07-11 00:00:00 | MMD | 0.008
2010-07-11 00:00:00 | RP | 0.001
2010-07-11 00:00:00 | MISC | 0.009
2010-07-12 00:00:00 | MMD | 0.01
2010-07-12 00:00:00 | MISC | 0.006
2010-07-12 00:00:00 | OPS | 0.077
2010-07-13 00:00:00 | FIN | 0.091
2010-07-13 00:00:00 | FIN | 0.01
2010-07-13 00:00:00 | MISC | 0.005
2010-07-13 00:00:00 | MMD | 0.011
2010-07-15 00:00:00 | PSA | 0
2010-07-16 00:00:00 | MMD | 0.027
2010-07-19 00:00:00 | FIN | 0.062
2010-07-19 00:00:00 | MISC | 0.001
2010-07-19 00:00:00 | IMD | 0.001
2010-07-21 00:00:00 | Security | 0.003
2010-07-22 00:00:00 | Security | 0.001
2010-07-22 00:00:00 | EMD | 0.01
2010-07-23 00:00:00 | EMD | 0.005
2010-07-23 00:00:00 | FIN | 0.01
2010-07-23 00:00:00 | RP | 0.065
2010-07-26 00:00:00 | Security | 0.003
2010-07-27 00:00:00 | Security | 0.002
2010-07-28 00:00:00 | Security | 0.002
2010-07-28 00:00:00 | FIN | 0.007
2010-07-30 00:00:00 | FIN | 0.11
Jul
2010-08-02 00:00:00 | FIN | 0.005
2010-08-04 00:00:00 | MMD | 0.005
2010-08-04 00:00:00 | EMD | 0.066
2010-08-04 00:00:00 | IMD | 0.026
2010-08-05 00:00:00 | Plant Eng. | 0.007
2010-08-07 00:00:00 | IMD | 0.024
2010-08-10 00:00:00 | MMD | 0.111
2010-08-10 00:00:00 | RP | 0.003
2010-08-10 00:00:00 | Plant Eng. | 0.005
2010-08-10 00:00:00 | IMD | 0.012
2010-08-11 00:00:00 | OPS | 0.008
2010-08-11 00:00:00 | Energy Sol. | 0.013
2010-08-11 00:00:00 | MMD | 0.021
2010-08-12 00:00:00 | Plant Eng. | 0.005
2010-08-12 00:00:00 | MISC | 0.01
2010-08-12 00:00:00 | OPS | 0.009
2010-08-12 00:00:00 | FIN | 0.125
2010-08-12 00:00:00 | RP | 0.167
2010-08-14 00:00:00 | MMD | 0.028
2010-08-16 00:00:00 | FIN | 0.001
2010-08-18 00:00:00 | OPS | 0.02
2010-08-18 00:00:00 | OPS | 0.005
2010-08-20 00:00:00 | FIN | 0.007
2010-08-22 00:00:00 | OPS | 0.011
2010-08-22 00:00:00 | RP | 0.005
2010-08-23 00:00:00 | OPS | 0.011
2010-08-24 00:00:00 | SHAW | 0.018
2010-08-24 00:00:00 | SHAW | 0.03
2010-08-25 00:00:00 | OPS | 0.015
2010-08-26 00:00:00 | OPS | 0.004
2010-08-26 00:00:00 | MMD | 0.259
2010-08-26 00:00:00 | EMD | 0.023
2010-08-26 00:00:00 | IMD | 0.003
2010-08-26 00:00:00 | RP | 0.056
2010-08-26 00:00:00 | Misc | 0.039
2010-08-26 00:00:00 | Plant Eng. | 0.004
2010-08-26 00:00:00 | Energy Sol. | 0.006
2010-08-26 00:00:00 | SHAW | 0.018
2010-08-23 00:00:00 | OPS | 0.019
2010-08-23 00:00:00 | OPS | 0.005
2010-08-23 00:00:00 | OPS | 0.032
2010-08-23 00:00:00 | OPS | 0.011
2010-08-31 00:00:00 | FIN | 0.013
2010-08-31 00:00:00 | FIN | 0.001
Aug
2010-09-01 00:00:00 | Energy Sol. | 0.012
2010-09-02 00:00:00 | fin | 0.112
2010-09-02 00:00:00 | ops | 0.021
2010-09-02 00:00:00 | rp | 0.019
2010-09-02 00:00:00 | rp | 0.023
2010-09-08 00:00:00 | FIN | 0.013
2010-09-09 00:00:00 | FIN | 0.026
2010-09-09 00:00:00 | PSA Lab | 0.013
2010-09-15 00:00:00 | FIN | 0.011
2010-09-15 00:00:00 | IMD | 0.004
2010-09-17 00:00:00 | PSA Lab | 0.013
2010-09-17 00:00:00 | rp | 0.014
2010-09-20 00:00:00 | FIN | 0.004
2010-09-24 00:00:00 | FIN | 0.017
2010-09-24 00:00:00 | FIN | 0.011
Sep
2010-10-01 00:00:00 | IMD | 0.035
2010-10-04 00:00:00 | FIN | 0.008
2010-10-05 00:00:00 | OPS | 0.005
2010-10-06 00:00:00 | FIN | 0.012
2010-10-07 00:00:00 | FIN | 0.018
2010-10-08 00:00:00 | FIN | 0.027
2010-10-12 00:00:00 | EMD | 0.01
2010-10-14 00:00:00 | IMD | 0.085
2010-10-14 00:00:00 | RP | 0.043
2010-10-21 00:00:00 | FIN | 0.282
2010-10-21 00:00:00 | RP | 0.048
2010-10-22 00:00:00 | FIN | 0.158
2010-10-22 00:00:00 | OPS | 0.003
2010-10-25 00:00:00 | Prog. Eng. | 0.01
2010-10-27 00:00:00 | RP | 0.026
2010-10-27 00:00:00 | IMD | 0.036
2010-10-27 00:00:00 | EMD | 0.009
2010-10-29 00:00:00 | RP | 0.017
2010-10-29 00:00:00 | IMD | 0.039
Oct
2010-11-01 00:00:00 | IMD | 0.031
2010-11-02 00:00:00 | EMD | 0.007
2010-11-03 00:00:00 | EMD | 0.023
2010-11-03 00:00:00 | EMD | 0.007
2010-11-04 00:00:00 | FIN | 0.013
2010-11-04 00:00:00 | EMD | 0.014
2010-11-04 00:00:00 | MMD | 0.196
2010-11-04 00:00:00 | RP | 0.005
2010-11-05 00:00:00 | MMD | 0.348
2010-11-05 00:00:00 | RP | 0.013
2010-11-08 00:00:00 | RP | 0.012
2010-11-08 00:00:00 | MMD | 0.041
2010-11-08 00:00:00 | RP | 0.016
2010-11-09 00:00:00 | MMD | 0.079
2010-11-09 00:00:00 | RP | 0.013
2010-11-10 00:00:00 | MMD | 0.317
2010-11-10 00:00:00 | RP | 0.017
2010-11-10 00:00:00 | EMD | 0.014
2010-11-11 00:00:00 | FIN | 0.006
2010-11-11 00:00:00 | FIN | 0.014
2010-11-11 00:00:00 | MMD | 0.279
2010-11-11 00:00:00 | RP | 0.01
2010-11-12 00:00:00 | MMD | 0.165
2010-11-12 00:00:00 | EMD | 0.06
2010-11-12 00:00:00 | IMD | 0.031
2010-11-12 00:00:00 | RP | 0.019
2010-11-12 00:00:00 | FIN | 0.04
2010-11-15 00:00:00 | MMD | 0.005
2010-11-15 00:00:00 | EMD | 0.084
2010-11-16 00:00:00 | MMD | 0.032
2010-11-16 00:00:00 | MMD | 0.028
2010-11-17 00:00:00 | FIN | 1.014
2010-11-17 00:00:00 | RP | 0.024
2010-11-17 00:00:00 | OPS | 0.069
2010-11-17 00:00:00 | EMD | 0.016
2010-11-17 00:00:00 | RP | 0.024
2010-11-17 00:00:00 | OPS | 0.025
2010-11-18 00:00:00 | OPS | 0.02
2010-11-18 00:00:00 | Plant Eng. | 0.007
2010-11-18 00:00:00 | MMD | 0.015
2010-11-18 00:00:00 | RP | 0.009
2010-11-19 00:00:00 | OPS | 0.042
2010-11-19 00:00:00 | Energy Sol. | 0.026
2010-11-21 00:00:00 | OPS | 0.018
2010-11-22 00:00:00 | OPS | 0.012
2010-11-22 00:00:00 | FIN | 0.006
2010-11-23 00:00:00 | OPS | 0.074
2010-11-23 00:00:00 | Plant Eng. | 0.005
2010-11-23 00:00:00 | RP | 0.004
2010-11-24 00:00:00 | FIN | 0.02
2010-11-30 00:00:00 | MMD | 0.031
Nov
2010-12-10 00:00:00 | RP | 0.044
2010-12-12 00:00:00 | OPS | 0.023
2010-12-13 00:00:00 | FIN | 0.009
2010-12-15 00:00:00 | PSA | 0.012
2010-12-15 00:00:00 | RXS | 0.004
2010-12-15 00:00:00 | RP | 0.004
2010-12-16 00:00:00 | FIN | 0.035
2010-12-17 00:00:00 | FIN | 0.12
2010-12-20 00:00:00 | IMD | 0.027
2010-12-20 00:00:00 | MMD | 0.02
2010-12-20 00:00:00 | RP | 0.005
2010-12-21 00:00:00 | FIN | 0.14
2010-12-21 00:00:00 | OPS | 0.053
2010-12-21 00:00:00 | IMD | 0.005
2010-12-28 00:00:00 | MMD | 0.01
2010-12-30 00:00:00 | SHAW | 0.874
Dec
2011-01-04 00:00:00 | FIN | 0.086
2011-01-04 00:00:00 | FIN | 0.003
2011-01-04 00:00:00 | RP | 0.026
2011-01-04 00:00:00 | PSA | 0.034
2011-01-05 00:00:00 | FIN | 0.027
2011-01-05 00:00:00 | RP | 0.012
2011-01-06 00:00:00 | FIN | 0.001
2011-01-06 00:00:00 | EMD | 0.006
2011-01-10 00:00:00 | FIN | 0.004
2011-01-13 00:00:00 | FIN | 0.033
2011-01-13 00:00:00 | ops | 0.008
2011-01-13 00:00:00 | rp | 0.014