Spreadsheet: 78382d1278712880-spreadsheet-layout-from-data-dump-problem-example
Sheet: Raw Data Dump

Site Designation | Area/Department | Activity description | Early start | Early finish
SITE 0 | GEN | Activity 1 | 2010-09-21 00:00:00
SITE 0 | SOU | Activity 2 | 2011-09-21 00:00:00
SITE 0 | GOV | Activity 3 | 2012-09-21 00:00:00
SITE 1 | APP | Activity 4 | 2013-09-21 00:00:00
SITE 1 | APP | Activity 5 | 2014-09-21 00:00:00
SITE 1 | APP | Activity 6 |  | 2015-09-20 00:00:00
SITE 1 | APP | Activity 7 | 22APR10A
SITE 1 | OUT | Activity 8 | 22JUN10A
SITE 1 | OUT | Activity 9 |  | 2010-09-20 00:00:00
SITE 1 | OUT | Activity 10 | 22JAN10A
SITE 1 | ACQ | Activity 11 | 25JAN10A
SITE 1 | ACQ | Activity 12 | 08FEB10A
SITE 1 | ACQ | Activity 13 | 11FEB10A
SITE 1 | ACQ | Activity 14 | 2010-08-19 00:00:00 | 2010-08-25 00:00:00
SITE 1 | ACQ | Activity 15 | 2010-08-26 00:00:00
SITE 1 | ACQ | Activity 16 | 2010-08-26 00:00:00 | 2010-09-01 00:00:00
SITE 1 | EAS | Activity 17 | 2010-09-02 00:00:00 | 2010-09-08 00:00:00
SITE 1 | EAS | Activity 18 | 2010-09-09 00:00:00 | 2010-09-10 00:00:00
SITE 1 | EAS | Activity 19 | 2010-09-13 00:00:00 | 2010-09-17 00:00:00
SITE 1 | CON | Activity 20 | 08MAR10A | 2010-07-08 00:00:00
SITE 1 | CON | Activity 21 | 2010-09-21 00:00:00
SITE 1 | CON | Activity 22 | 2010-09-28 00:00:00 | 2010-09-28 00:00:00
SITE 1 | CON | Activity 23 | 2010-09-29 00:00:00 | 2010-10-05 00:00:00
SITE 2 | APP | Activity 4 | 2010-10-06 00:00:00 | 2010-10-12 00:00:00
SITE 2 | APP | Activity 5 |  | 2010-10-26 00:00:00
SITE 2 | APP | Activity 6 | 2010-10-27 00:00:00 | 2010-11-23 00:00:00
SITE 2 | APP | Activity 7 | 2010-11-24 00:00:00 | 2010-12-21 00:00:00
SITE 2 | OUT | Activity 8 | 2010-08-31 00:00:00 | 2010-09-13 00:00:00
SITE 2 | OUT | Activity 9 | 2010-09-14 00:00:00 | 2010-09-20 00:00:00
SITE 2 | OUT | Activity 10 | 2010-09-21 00:00:00
SITE 2 | ACQ | Activity 11 |  | 2010-12-22 00:00:00
SITE 2 | ACQ | Activity 12 | 2011-01-25 00:00:00 | 2011-01-31 00:00:00
SITE 2 | ACQ | Activity 13 | 2011-02-01 00:00:00 | 2011-02-01 00:00:00
SITE 2 | ACQ | Activity 14 | 2011-02-02 00:00:00 | 2011-02-08 00:00:00
SITE 2 | ACQ | Activity 15 | 2011-02-09 00:00:00 | 2011-02-15 00:00:00
SITE 2 | ACQ | Activity 16 | 2011-02-16 00:00:00 | 2011-02-17 00:00:00
SITE 2 | EAS | Activity 17 | 2011-02-18 00:00:00 | 2011-02-24 00:00:00
SITE 2 | EAS | Activity 18 | 2010-10-26 00:00:00 | 2010-12-06 00:00:00
SITE 2 | EAS | Activity 19 | 2010-12-07 00:00:00 | 2010-12-07 00:00:00
SITE 2 | CON | Activity 20 | 2010-12-15 00:00:00 | 2010-12-15 00:00:00
SITE 2 | CON | Activity 21 | 2010-12-16 00:00:00 | 2010-12-22 00:00:00
SITE 2 | CON | Activity 22 | 2010-12-23 00:00:00 | 2010-12-29 00:00:00
SITE 2 | CON | Activity 23 | 2011-01-13 00:00:00 | 2011-01-13 00:00:00
SITE 3 | APP | Activity 4 | 2011-01-14 00:00:00 | 2011-02-10 00:00:00
SITE 3 | APP | Activity 5 | 2011-02-11 00:00:00 | 2011-03-10 00:00:00
SITE 3 | APP | Activity 6 | 2012-01-31 00:00:00 | 2012-02-06 00:00:00
SITE 3 | APP | Activity 7 | 2012-02-07 00:00:00 | 2012-02-07 00:00:00
SITE 3 | OUT | Activity 8 | 2012-02-08 00:00:00 | 2012-02-14 00:00:00
SITE 3 | OUT | Activity 9 | 2012-02-15 00:00:00 | 2012-02-21 00:00:00
SITE 3 | OUT | Activity 10 | 2012-02-22 00:00:00 | 2012-02-23 00:00:00
SITE 3 | ACQ | Activity 11 | 2012-02-24 00:00:00 | 2012-03-01 00:00:00
SITE 3 | ACQ | Activity 12 | 2011-11-01 00:00:00 | 2011-12-12 00:00:00
SITE 3 | ACQ | Activity 13 | 2011-12-13 00:00:00 | 2011-12-13 00:00:00
SITE 3 | ACQ | Activity 14 | 2011-12-21 00:00:00 | 2011-12-21 00:00:00
SITE 3 | ACQ | Activity 15 | 2011-12-22 00:00:00 | 2011-12-28 00:00:00
SITE 3 | ACQ | Activity 16 | 2011-12-29 00:00:00 | 2012-01-04 00:00:00
SITE 3 | EAS | Activity 17 | 2012-01-19 00:00:00 | 2012-01-19 00:00:00
SITE 3 | EAS | Activity 18 | 2012-01-20 00:00:00 | 2012-02-16 00:00:00
SITE 3 | EAS | Activity 19 | 2012-02-17 00:00:00 | 2012-03-15 00:00:00
SITE 3 | CON | Activity 20 | 2013-01-29 00:00:00 | 2013-02-04 00:00:00
SITE 3 | CON | Activity 21 | 2013-02-05 00:00:00 | 2013-02-05 00:00:00
SITE 3 | CON | Activity 22 | 2013-02-06 00:00:00 | 2013-02-12 00:00:00
SITE 3 | CON | Activity 23 | 2013-02-13 00:00:00 | 2013-02-19 00:00:00