Analysis Exports
Contents
The generation and preview of Project Analysis reports automatically generates an export of the data in excel format. An example of the format of the data is
ID |
SEG - Client |
SITE |
OWNER |
BID Reg# |
DESCRIPTION |
JOBTYPE |
SITENAME |
STARTDATE |
COMPDATE |
HANDOVER |
TORIGINAL |
TVARIATIONS |
TALLOWANCE |
TFORECAST |
TVARIANCE |
TORDERVAL |
TEXPENSE |
TRECEIVED |
MASTER WORKBILL |
TEMPLA WB TOTAL |
TEMPLA POSTED |
12994 |
Ambulance NSW |
BANKSTOWN AMBULANCE - SPECIAL OPERATIONS |
MAURICEP |
Ambulance NSW |
Bankstown Ambulance - Split Capacitor AC Unit |
Project Work Other (PWO) |
Bankstown Ambulance - Special Operations (Swr) |
09.02.2018 |
09.04.2018 |
|
504 |
0 |
504 |
420 |
84 |
420 |
420 |
|
180740 |
504 |
Y |
13144 |
Ambulance NSW |
BANKSTOWN AMBULANCE - SPECIAL OPERATIONS |
MAURICEP |
71314 |
Bankstown Ambulance Station - Lighting Upgrades |
Project Work Other (PWO) |
Bankstown Ambulance - Special Operations (Swr) |
19.02.2018 |
19.04.2018 |
|
2585 |
0 |
2585 |
651.27 |
1933.73 |
|
651.27 |
|
181308 |
2585 |
Y |
13154 |
Ambulance NSW |
BANKSTOWN AMBULANCE - SPECIAL OPERATIONS |
MAURICEP |
71504 |
Bankstown Ambulance Station -Maintenance to lights |
Project Work Other (PWO) |
Bankstown Ambulance - Special Operations (Swr) |
19.02.2018 |
19.04.2018 |
|
1350 |
0 |
1350 |
896.84 |
453.16 |
0 |
896.84 |
|
181309 |
1350 |
Y |
14744 |
Ambulance NSW |
BANKSTOWN AMBULANCE - SPECIAL OPERATIONS |
MAURICEP |
83884 |
Bankstown Ambulance - Air Conditioner in office |
Project Work Other (PWO) |
Bankstown Ambulance - Special Operations (Swr) |
29.05.2018 |
29.07.2018 |
|
3795.68 |
0 |
3795.68 |
3389 |
406.68 |
3389 |
3343.68 |
|
196492 |
3795.68 |
Y |
The export file is in .CSV format and named:
•Project Analysis ACTIVE - YYYY-M-D-HH-MM-SS.csv
•Project Analysis OWNER [NAME] - YYYY-M-D-HH-MM-SS.csv
•Project Analysis SUPERVISOR [NAME] - YYYY-M-D-HH-MM-SS.csv
•Project Analysis POSTED - YYYY-M-D-HH-MM-SS.csv
Thes files are generated in the Export Folder (see Preferences).