Spreadsheet: 273901d1382961707-autofill-rules-id-contract-file-tracker-sample
Sheet: SUMMARY

 |  |  | Contract File Master Summary
 |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00
 |  |  |  |  |  |  |  |  | Totals
 |  |  |  |  |  |  |  |  | Revenue | Material | Labour | Profit
 |  |  |  |  |  |  | Contract Files |  | Revenue | Material | Labour | Profit |  |  | Revenue | Material | Labour | Profit |  |  | Revenue | Material | Labour | Profit
Master Month Trackers |  |  |  |  |  |  | CF-00 Job Trackers
Month | Revenue | Material | Labour | Profit | Margin |  | CF001
2013-01-01 00:00:00 |  |  |  |  |  |  | [NAME]
2013-02-01 00:00:00 |  |  |  |  |  |  | CF003
2013-03-01 00:00:00 |  |  |  |  |  |  | CF004
2013-04-01 00:00:00 |  |  |  |  |  |  | CF005
2013-05-01 00:00:00 |  |  |  |  |  |  | CF006
2013-06-01 00:00:00 |  |  |  |  |  |  | CF007
2013-07-01 00:00:00 |  |  |  |  |  |  | CF008
2013-08-01 00:00:00 |  |  |  |  |  |  | CF009
2013-09-01 00:00:00 |  |  |  |  |  |  | CF010
2013-10-01 00:00:00 |  |  |  |  |  |  | CF011
2013-11-01 00:00:00 |  |  |  |  |  |  | CF012
2013-12-01 00:00:00 |  |  |  |  |  |  | CF013
2014-01-01 00:00:00 |  |  |  |  |  |  | CF014
2014-02-01 00:00:00 |  |  |  |  |  |  | [NAME]
2014-03-01 00:00:00 |  |  |  |  |  |  | CF016
2014-04-01 00:00:00 |  |  |  |  |  |  | CF017
2014-05-01 00:00:00 |  |  |  |  |  |  | CF018
2014-06-01 00:00:00 |  |  |  |  |  |  | CF019
2014-07-01 00:00:00 |  |  |  |  |  |  | CF020
2014-08-01 00:00:00 |  |  |  |  |  |  | CF021
2014-09-01 00:00:00 |  |  |  |  |  |  | CF022
 |  |  |  |  |  |  | CF023
 |  |  |  |  |  |  | CF024
 |  |  |  |  |  |  | CF025
 |  |  |  |  |  |  | CF026
 |  |  |  |  |  |  | CF027
 |  |  |  |  |  |  | CF028
 |  |  |  |  |  |  | CF029
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF031
 |  |  |  |  |  |  | CF032
 |  |  |  |  |  |  | CF033
 |  |  |  |  |  |  | CF034
 |  |  |  |  |  |  | CF035
 |  |  |  |  |  |  | CF036
 |  |  |  |  |  |  | CF037
 |  |  |  |  |  |  | CF038
 |  |  |  |  |  |  | CF039
 |  |  |  |  |  |  | CF040
 |  |  |  |  |  |  | CF041
 |  |  |  |  |  |  | CF042
 |  |  |  |  |  |  | CF043
 |  |  |  |  |  |  | CF044
 |  |  |  |  |  |  | CF045
 |  |  |  |  |  |  | CF046
 |  |  |  |  |  |  | CF047
 |  |  |  |  |  |  | CF048
 |  |  |  |  |  |  | CF049
 |  |  |  |  |  |  | CF050
 |  |  |  |  |  |  | CF051
 |  |  |  |  |  |  | CF052
 |  |  |  |  |  |  | CF053
 |  |  |  |  |  |  | CF054
 |  |  |  |  |  |  | CF055
 |  |  |  |  |  |  | CF056
 |  |  |  |  |  |  | CF057
 |  |  |  |  |  |  | CF058
 |  |  |  |  |  |  | CF059
 |  |  |  |  |  |  | CF060
 |  |  |  |  |  |  | CF061
 |  |  |  |  |  |  | CF062
 |  |  |  |  |  |  | CF063
 |  |  |  |  |  |  | CF064
 |  |  |  |  |  |  | CF065
 |  |  |  |  |  |  | CF066
 |  |  |  |  |  |  | CF067
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF069
 |  |  |  |  |  |  | CF070
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF072
 |  |  |  |  |  |  | CF073
 |  |  |  |  |  |  | CF074
 |  |  |  |  |  |  | CF075
 |  |  |  |  |  |  | CF076
 |  |  |  |  |  |  | CF077
 |  |  |  |  |  |  | CF078
 |  |  |  |  |  |  | CF079
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF082
 |  |  |  |  |  |  | CF083
 |  |  |  |  |  |  | CF084
 |  |  |  |  |  |  | CF085
 |  |  |  |  |  |  | CF086
 |  |  |  |  |  |  | CF087
 |  |  |  |  |  |  | CF088
 |  |  |  |  |  |  | CF089
 |  |  |  |  |  |  | CF090
 |  |  |  |  |  |  | CF091
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF093
 |  |  |  |  |  |  | CF094
 |  |  |  |  |  |  | CF095
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF098
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF100
 |  |  |  |  |  |  | CF101
 |  |  |  |  |  |  | CF102
 |  |  |  |  |  |  | CF103
 |  |  |  |  |  |  | CF104
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF106
 |  |  |  |  |  |  | CF107
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF109
 |  |  |  |  |  |  | CF110
 |  |  |  |  |  |  | CF111
 |  |  |  |  |  |  | CF112
 |  |  |  |  |  |  | CF113
 |  |  |  |  |  |  | CF114
 |  |  |  |  |  |  | CF115
 |  |  |  |  |  |  | CF116
 |  |  |  |  |  |  | CF117
 |  |  |  |  |  |  | CF118
 |  |  |  |  |  |  | CF119
 |  |  |  |  |  |  | CF120
 |  |  |  |  |  |  | CF121
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF123
 |  |  |  |  |  |  | CF124
 |  |  |  |  |  |  | CF125
 |  |  |  |  |  |  | CF126
 |  |  |  |  |  |  | CF127
 |  |  |  |  |  |  | CF128
 |  |  |  |  |  |  | CF129
 |  |  |  |  |  |  | CF130
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF132
 |  |  |  |  |  |  | CF133
 |  |  |  |  |  |  | CF134
 |  |  |  |  |  |  | CF135
 |  |  |  |  |  |  | CF136
 |  |  |  |  |  |  | CF137
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF139
 |  |  |  |  |  |  | CF140
 |  |  |  |  |  |  | CF141
 |  |  |  |  |  |  | CF142
 |  |  |  |  |  |  | CF143
 |  |  |  |  |  |  | CF144
 |  |  |  |  |  |  | CF145
 |  |  |  |  |  |  | CF146
 |  |  |  |  |  |  | CF147
 |  |  |  |  |  |  | CF148
 |  |  |  |  |  |  | CF149
 |  |  |  |  |  |  | CF150
 |  |  |  |  |  |  | CF151
 |  |  |  |  |  |  | CF152
 |  |  |  |  |  |  | CF153
 |  |  |  |  |  |  | CF154
 |  |  |  |  |  |  | CF155
 |  |  |  |  |  |  | CF156
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF158
 |  |  |  |  |  |  | CF159
 |  |  |  |  |  |  | CF160
 |  |  |  |  |  |  | CF161
 |  |  |  |  |  |  | CF162
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF164
 |  |  |  |  |  |  | CF165
 |  |  |  |  |  |  | CF166
 |  |  |  |  |  |  | CF167
 |  |  |  |  |  |  | CF168
 |  |  |  |  |  |  | CF169
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF171
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF173
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF175
 |  |  |  |  |  |  | CF176
 |  |  |  |  |  |  | CF177
 |  |  |  |  |  |  | CF178
 |  |  |  |  |  |  | CF179
 |  |  |  |  |  |  | CF180
 |  |  |  |  |  |  | CF181
 |  |  |  |  |  |  | CF182
 |  |  |  |  |  |  | CF183
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF185
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF187
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF189
 |  |  |  |  |  |  | CF190
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF192
 |  |  |  |  |  |  | CF193
 |  |  |  |  |  |  | CF194
 |  |  |  |  |  |  | CF195
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF197
 |  |  |  |  |  |  | CF198
 |  |  |  |  |  |  | CF199
 |  |  |  |  |  |  | CF200
 |  |  |  |  |  |  | CF201
 |  |  |  |  |  |  | CF202
 |  |  |  |  |  |  | CF203
 |  |  |  |  |  |  | CF204
 |  |  |  |  |  |  | CF205
 |  |  |  |  |  |  | CF206
 |  |  |  |  |  |  | CF207
 |  |  |  |  |  |  | CF208
 |  |  |  |  |  |  | CF209
 |  |  |  |  |  |  | CF210
 |  |  |  |  |  |  | CF211
 |  |  |  |  |  |  | CF212
 |  |  |  |  |  |  | CF213
 |  |  |  |  |  |  | CF214
 |  |  |  |  |  |  | CF215
 |  |  |  |  |  |  | CF216
 |  |  |  |  |  |  | CF217
 |  |  |  |  |  |  | CF218
 |  |  |  |  |  |  | CF219
 |  |  |  |  |  |  | CF220
 |  |  |  |  |  |  | CF221
 |  |  |  |  |  |  | CF222
 |  |  |  |  |  |  | CF223
 |  |  |  |  |  |  | CF224
 |  |  |  |  |  |  | CF225
 |  |  |  |  |  |  | CF226
 |  |  |  |  |  |  | CF227
 |  |  |  |  |  |  | CF228
 |  |  |  |  |  |  | CF229
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF232
 |  |  |  |  |  |  | CF233
 |  |  |  |  |  |  | CF234
 |  |  |  |  |  |  | CF235
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF237
 |  |  |  |  |  |  | CF238
 |  |  |  |  |  |  | CF239
 |  |  |  |  |  |  | CF240
 |  |  |  |  |  |  | CF241
 |  |  |  |  |  |  | CF242
 |  |  |  |  |  |  | CF243
 |  |  |  |  |  |  | CF244
 |  |  |  |  |  |  | CF245
 |  |  |  |  |  |  | CF246
 |  |  |  |  |  |  | CF247
 |  |  |  |  |  |  | CF248
 |  |  |  |  |  |  | CF249
 |  |  |  |  |  |  | CF250
 |  |  |  |  |  |  | CF251
 |  |  |  |  |  |  | CF252
 |  |  |  |  |  |  | CF253
 |  |  |  |  |  |  | CF254
 |  |  |  |  |  |  | CF255
 |  |  |  |  |  |  | CF256
 |  |  |  |  |  |  | CF257
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF259
 |  |  |  |  |  |  | CF260
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF262
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF264
 |  |  |  |  |  |  | CF265
 |  |  |  |  |  |  | CF266
 |  |  |  |  |  |  | CF267
 |  |  |  |  |  |  | CF268
 |  |  |  |  |  |  | CF269
 |  |  |  |  |  |  | CF270
 |  |  |  |  |  |  | CF271
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF274
 |  |  |  |  |  |  | CF275
 |  |  |  |  |  |  | CF276
 |  |  |  |  |  |  | CF277
 |  |  |  |  |  |  | CF278
 |  |  |  |  |  |  | CF279
 |  |  |  |  |  |  | CF280
 |  |  |  |  |  |  | CF281
 |  |  |  |  |  |  | CF282
 |  |  |  |  |  |  | CF283
 |  |  |  |  |  |  | CF284
 |  |  |  |  |  |  | CF285
 |  |  |  |  |  |  | CF286
 |  |  |  |  |  |  | CF287
 |  |  |  |  |  |  | CF288
 |  |  |  |  |  |  | CF289
 |  |  |  |  |  |  | CF290
 |  |  |  |  |  |  | CF291
 |  |  |  |  |  |  | CF292
 |  |  |  |  |  |  | CF293
 |  |  |  |  |  |  | CF294
 |  |  |  |  |  |  | CF295
 |  |  |  |  |  |  | CF296
 |  |  |  |  |  |  | CF297
 |  |  |  |  |  |  | CF298
 |  |  |  |  |  |  | CF299
 |  |  |  |  |  |  | CF300
 |  |  |  |  |  |  | CF301
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF303
 |  |  |  |  |  |  | CF304
 |  |  |  |  |  |  | CF305
 |  |  |  |  |  |  | CF306
 |  |  |  |  |  |  | CF307
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF309
 |  |  |  |  |  |  | CF310
 |  |  |  |  |  |  | CF311
 |  |  |  |  |  |  | CF312
 |  |  |  |  |  |  | CF313
 |  |  |  |  |  |  | CF314
 |  |  |  |  |  |  | CF315
 |  |  |  |  |  |  | CF316
 |  |  |  |  |  |  | CF317
 |  |  |  |  |  |  | CF318
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF320
 |  |  |  |  |  |  | CF321
 |  |  |  |  |  |  | CF322
 |  |  |  |  |  |  | CF323
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF325
 |  |  |  |  |  |  | CF326
 |  |  |  |  |  |  | CF327
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF329
 |  |  |  |  |  |  | CF330
 |  |  |  |  |  |  | CF331
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF333
 |  |  |  |  |  |  | CF334
 |  |  |  |  |  |  | CF335
 |  |  |  |  |  |  | CF336
 |  |  |  |  |  |  | CF337
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF339
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | CF341
 |  |  |  |  |  |  | CF342
 |  |  |  |  |  |  | CF343
 |  |  |  |  |  |  | CF344
 |  |  |  |  |  |  | CF345
 |  |  |  |  |  |  | CF346
 |  |  |  |  |  |  | CF347
 |  |  |  |  |  |  | CF348