Spreadsheet: 334414d1406135186-return-date-at-which-a-sum-was-reached-excel_forum-help-7-23-14-dd-validation
Sheet: Actual peaks

Preoviposition period | 0 |  | DD= | 355
[NAME] | Name | Year | Life Stage | Type | Peak | Sig.? | Obs peak | Pred. Peak | Error (pred-obs) | Obs_num of days | Pred_num of days | Error (pred-obs) | y/n
[NAME] | UTC 1 | 2012 | Adults | [NAME] | 1 | No | 2012-02-06 00:00:00 |  |  |  |  |  |  | <-----correct "Pred. Peak"
[NAME] | UTC 1 | 2012 | Adults | [NAME] | 2 | No | 2012-03-05 00:00:00 |  |  |  |  |  |  | <-----incorrect "Pred. peak", should be 3/27/12 when manually added on the other sheet (3/5/12 thru 3/27/12)
[NAME] | UTC 1 | 2012 | Adults | [NAME] | 4 | No | 2012-03-26 00:00:00
[NAME] | UTC 1 | 2012 | Eggs | Leaf | 1 | No | 2012-02-13 00:00:00
[NAME] | UTC 1 | 2012 | Eggs | Leaf | 2 | No | 2012-03-12 00:00:00
[NAME] | UTC 1 | 2012 | Nymphs | Leaf | 1 | No | 2012-02-06 00:00:00
[NAME] | UTC 1 | 2012 | Nymphs | Leaf | 2 | No | 2012-03-12 00:00:00
[NAME] | UTC 2 | 2012 | Adults | [NAME] | 1 | Yes | 2012-02-06 00:00:00
[NAME] | UTC 2 | 2012 | Adults | [NAME] | 2 | No | 2012-02-27 00:00:00
[NAME] | UTC 2 | 2012 | Adults | [NAME] | 3 | Yes | 2012-03-26 00:00:00
[NAME] | UTC 2 | 2012 | eggs | Leaf | 1 | No | 2012-02-13 00:00:00
[NAME] | UTC 2 | 2012 | eggs | Leaf | 2 | Yes | 2012-03-12 00:00:00
[NAME] | UTC 2 | 2012 | Nymphs | Leaf | 1 | No | 2012-02-27 00:00:00
[NAME] | UTC 2 | 2012 | Nymphs | Leaf | 2 | Yes | 2012-03-26 00:00:00
[NAME] | UTC 3 | 2012 | Adults | [NAME] | 1 | Yes | 2012-02-06 00:00:00
[NAME] | UTC 3 | 2012 | Adults | [NAME] | 2 | No | 2012-02-27 00:00:00
[NAME] | UTC 3 | 2012 | Eggs | Leaf | 1 | No | 2012-02-13 00:00:00
[NAME] | UTC 3 | 2012 | Eggs | Leaf | 2 | No | 2012-03-26 00:00:00
[NAME] | UTC 3 | 2012 | Nymphs | Leaf | 1 | No | 2012-02-20 00:00:00
[NAME] | UTC 3 | 2012 | Nymphs | Leaf | 3 | Yes | 2012-03-26 00:00:00
[NAME] | UTC 1 | 2013 | Adults | [NAME] | 1 | No | 2013-02-18 00:00:00
[NAME] | UTC 1 | 2013 | Adults | [NAME] | 3 | No | 2013-03-25 00:00:00
[NAME] | UTC 1 | 2013 | Eggs | Leaf | 1 | No | 2013-01-21 00:00:00
[NAME] | UTC 1 | 2013 | Eggs | Leaf | 2 | No | 2013-02-25 00:00:00
[NAME] | UTC 1 | 2013 | Nymphs | Leaf | 1 | No | 2013-02-25 00:00:00
[NAME] | UTC 2 | 2013 | Nymphs | Leaf | 1 | No | 2013-02-11 00:00:00
[NAME] | UTC 2 | 2013 | Nymphs | Leaf | 3 | yes | 2013-03-18 00:00:00
[NAME] | UTC 2 | 2013 | Nymphs | Leaf | 4 | No | 2013-04-08 00:00:00
[NAME] | UTC 2 | 2013 | Adults | [NAME] | 1 | No | 2013-02-11 00:00:00
[NAME] | UTC 2 | 2013 | Adults | [NAME] | 2 | Yes | 2013-03-18 00:00:00
[NAME] | UTC 2 | 2013 | Adults | [NAME] | 3 | No | 2013-04-08 00:00:00
[NAME] | UTC 2 | 2013 | Eggs | Leaf | 1 | No | 2013-03-11 00:00:00
[NAME] | UTC 2 | 2013 | Eggs | Leaf | 2 | No | 2013-04-08 00:00:00
[NAME] | UTC 3 | 2013 | Adults | [NAME] | 1 | No | 2013-03-18 00:00:00
[NAME] | UTC 3 | 2013 | Adults | [NAME] | 2 | No | 2013-04-15 00:00:00
[NAME] | UTC 3 | 2013 | Eggs | Leaf | 1 | No | 2013-03-04 00:00:00
[NAME] | UTC 3 | 2013 | Eggs | Leaf | 3 | No | 2013-04-01 00:00:00
[NAME] | UTC 3 | 2013 | Nymphs | Leaf | 1 | No | 2013-03-04 00:00:00
[NAME] | UTC 3 | 2013 | Nymphs | Leaf | 3 | No | 2013-04-15 00:00:00
[NAME] | UTC 1 | 2014 | Adults | [NAME] | 1 |  | 2014-02-10 00:00:00
[NAME] | UTC 1 | 2014 | Adults | [NAME] | 2 |  | 2014-03-03 00:00:00
[NAME] | UTC 1 | 2014 | Adults | [NAME] | 3 |  | 2014-04-14 00:00:00
[NAME] | UTC 1 | 2014 | Eggs | Leaf | 1 |  | 2014-02-03 00:00:00
[NAME] | UTC 1 | 2014 | Eggs | Leaf | 2 |  | 2014-02-24 00:00:00
[NAME] | UTC 1 | 2014 | Eggs | Leaf | 3 |  | 2014-03-17 00:00:00
[NAME] | UTC 1 | 2014 | Nymphs | Leaf | 1 |  | 2014-02-10 00:00:00
[NAME] | UTC 1 | 2014 | Nymphs | Leaf | 2 |  | 2014-03-03 00:00:00
[NAME] | UTC 1 | 2014 | Nymphs | Leaf | 4 |  | 2014-03-31 00:00:00
[NAME] | UTC 2 | 2014 | Adults | [NAME] | 1 |  | 2014-03-03 00:00:00
[NAME] | UTC 2 | 2014 | Adults | [NAME] | 2 |  | 2014-03-24 00:00:00
[NAME] | UTC 2 | 2014 | Adults | [NAME] | 4 |  | 2014-04-28 00:00:00
[NAME] | UTC 2 | 2014 | Eggs | Leaf | 1 |  | 2014-03-10 00:00:00
[NAME] | UTC 2 | 2014 | Eggs | Leaf | 2 |  | 2014-04-21 00:00:00
[NAME] | UTC 2 | 2014 | Nymphs | Leaf | 1 |  | 2014-03-24 00:00:00
[NAME] | UTC 2 | 2014 | Nymphs | Leaf | 2 |  | 2014-04-07 00:00:00
[NAME] | UTC 2 | 2014 | Nymphs | Leaf | 3 |  | 2014-04-21 00:00:00
[NAME] | UTC 3 | 2014 | Adults | Leaf | 1 |  | 2014-03-03 00:00:00
[NAME] | UTC 3 | 2014 | Adults | Leaf | 2 |  | 2014-04-28 00:00:00
[NAME] | UTC 3 | 2014 | Adults | Leaf | 3 |  | 2014-05-12 00:00:00
[NAME] | UTC 3 | 2014 | Eggs | Leaf | 1 |  | 2014-03-14 00:00:00
[NAME] | UTC 3 | 2014 | Eggs | Leaf | 2 |  | 2014-04-21 00:00:00
[NAME] | UTC 3 | 2014 | Nymphs | Leaf | 1 |  | 2014-03-31 00:00:00
[NAME] | UTC 3 | 2014 | Nymphs | Leaf | 2 |  | 2014-04-21 00:00:00
[NAME] | UTC 2 | 2011 | Adults | [NAME] | 1 |  | 2011-03-25 00:00:00
[NAME] | UTC 2 | 2011 | Adults | [NAME] | 2 |  | 2011-04-22 00:00:00
[NAME] | UTC 2 | 2011 | Eggs | Leaf | 1 |  | 2011-03-11 00:00:00
[NAME] | UTC 2 | 2011 | Eggs | Leaf | 2 |  | 2011-04-01 00:00:00
[NAME] | UTC 2 | 2011 | Nymphs | Leaf | 1 |  | 2011-03-04 00:00:00
[NAME] | UTC 2 | 2011 | Nymphs | Leaf | 2 |  | 2011-04-08 00:00:00
[NAME] | UTC 3 | 2011 | Adults | [NAME] | 1 |  | 2011-04-08 00:00:00
[NAME] | UTC 3 | 2011 | Eggs | Leaf | 1 |  | 2011-04-01 00:00:00
[NAME] | UTC 3 | 2011 | Nymphs | Leaf | 1 |  | 2011-03-04 00:00:00
[NAME] | UTC 3 | 2011 | Nymphs | Leaf | 2 |  | 2011-03-25 00:00:00
[NAME] | UTC 3 | 2011 | Nymphs | Leaf | 3 |  | 2011-04-15 00:00:00