{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Read me","Register","Dashboard","Validation"],"not_rendered":{"charts":6,"external_links":1,"defined_names":10},"read":"whole","date_system":"1900"}

{"sheet":"Read me","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"merged":[[0,0,4,11],[8,0,8,11],[11,0,12,11],[15,0,16,11],[19,0,21,11]]}
["Read Me"]
[]
[]
[]
[]
[]
[]
["1)"]
["Dear User, thank you for using my template. Please remove sample entries from the register"]
[]
["2)"]
["Usually only cells on the sheet \"Register\" require data-entry. Cells containing formulas or functions are protected, the password is blank should you wish to modify anything."]
[]
[]
["3)"]
["To avoid typing mistakes resulting in incorrect filter results, some entries in different columns of the register are restricted. To modify acceptable values change entries on the sheet \"Validation\"."]
[]
[]
["4)"]
["The register is made for 500 data sets, however can be easily extended.\nThe charts are made in a way that only a period of 48 month is covered. This limitation as well can be adjusted and was only implemented for formatting reasons."]

{"sheet":"Register","index":1,"n_rows":21,"n_cols":80,"rows_kept":21,"merged":[[440,51,440,54],[440,55,440,56],[440,57,440,59],[440,60,440,62],[440,63,440,68],[440,69,440,74],[440,75,440,78],[440,79,440,89],[441,0,441,1],[441,2,441,4],[441,5,441,10],[441,11,441,16],[441,17,441,20],[441,79,441,89],[442,0,442,1],[442,2,442,4],[442,5,442,10],[442,11,442,16],[442,17,442,20],[442,21,442,25],[442,26,442,32],[442,33,442,39],[442,40,442,50],[442,51,442,54],[442,55,442,56],[442,57,442,59],[442,60,442,62],[442,63,442,68],[442,69,442,74],[442,75,442,78],[442,79,442,89],[443,0,443,1],[443,2,443,4],[443,5,443,10],[443,11,443,16],[443,17,443,20],[443,21,443,25],[443,26,443,32],[443,33,443,39],[443,40,443,50],[443,51,443,54],[443,55,443,56],[443,57,443,59],[443,60,443,62],[443,63,443,68],[443,69,443,74],[443,75,443,78],[443,79,443,89],[444,0,444,1],[444,2,444,4],[444,5,444,10],[444,11,444,16],[444,17,444,20],[444,21,444,25],[444,26,444,32],[444,33,444,39],[444,40,444,50],[444,51,444,54],[444,55,444,56],[444,57,444,59],[444,60,444,62],[444,63,444,68],[444,69,444,74],[444,75,444,78],[444,79,444,89],[445,0,445,1],[445,2,445,4],[445,5,445,10],[445,11,445,16],[445,17,445,20],[445,21,445,25],[445,26,445,32],[445,33,445,39],[445,40,445,50],[445,51,445,54],[445,55,445,56],[445,57,445,59],[445,60,445,62],[445,63,445,68],[445,69,445,74],[445,75,445,78],[445,79,445,89],[446,0,446,1],[446,2,446,4],[446,5,446,10],[446,11,446,16],[446,17,446,20],[446,21,446,25],[446,26,446,32],[446,33,446,39],[446,40,446,50],[446,51,446,54],[446,55,446,56],[446,57,446,59],[446,60,446,62],[446,63,446,68],[446,69,446,74],[446,75,446,78],[446,79,446,89],[447,0,447,1],[447,2,447,4],[447,5,447,10],[447,11,447,16],[447,17,447,20],[447,21,447,25],[447,26,447,32],[447,33,447,39],[447,40,447,50],[447,51,447,54],[447,55,447,56],[447,57,447,59],[447,60,447,62],[447,63,447,68],[447,69,447,74],[447,75,447,78],[447,79,447,89],[448,0,448,1],[448,2,448,4],[448,5,448,10],[448,11,448,16],[448,17,448,20],[448,21,448,25],[448,26,448,32],[448,33,448,39],[448,40,448,50],[448,51,448,54],[448,55,448,56],[448,57,448,59],[448,60,448,62],[448,63,448,68],[448,69,448,74],[448,75,448,78],[448,79,448,89],[449,0,449,1],[449,2,449,4],[449,5,449,10],[449,11,449,16],[449,17,449,20],[449,21,449,25],[449,26,449,32],[449,33,449,39],[449,40,449,50],[449,51,449,54],[449,55,449,56],[449,57,449,59],[449,60,449,62],[449,63,449,68],[449,69,449,74],[449,75,449,78],[449,79,449,89],[450,0,450,1],[450,2,450,4],[450,5,450,10],[450,11,450,16],[450,17,450,20],[450,21,450,25],[450,26,450,32],[450,33,450,39],[450,40,450,50],[450,51,450,54],[450,55,450,56],[450,57,450,59],[450,60,450,62],[450,63,450,68],[450,69,450,74],[450,75,450,78],[450,79,450,89],[451,0,451,1],[451,2,451,4],[451,5,451,10],[451,11,451,16],[451,17,451,20],[451,21,451,25],[451,26,451,32],[451,33,451,39],[451,40,451,50],[451,51,451,54],[451,55,451,56],[451,57,451,59],[451,60,451,62],[451,63,451,68],[451,69,451,74],[451,75,451,78],[451,79,451,89],[452,0,452,1],[452,2,452,4],[452,5,452,10],[452,11,452,16],[452,17,452,20],[452,21,452,25],[452,26,452,32],[452,33,452,39],[452,40,452,50],[452,51,452,54],[452,55,452,56],[452,57,452,59],[452,60,452,62],[452,63,452,68],[452,69,452,74],[452,75,452,78],[452,79,452,89],[453,0,453,1],[453,2,453,4],[453,5,453,10],[453,11,453,16],[453,17,453,20],[453,21,453,25],[453,26,453,32],[453,33,453,39],[453,40,453,50],[453,51,453,54],[453,55,453,56],[453,57,453,59],[453,60,453,62],[453,63,453,68],[453,69,453,74],[453,75,453,78],[453,79,453,89],[454,0,454,1],[454,2,454,4],[454,5,454,10],[454,11,454,16],[454,17,454,20],[454,21,454,25],[454,26,454,32],[454,33,454,39],[454,40,454,50],[454,51,454,54],[454,55,454,56],[454,57,454,59],[454,60,454,62],[454,63,454,68],[454,69,454,74],[454,75,454,78],[454,79,454,89],[455,0,455,1],[455,2,455,4],[455,5,455,10],[455,11,455,16],[455,17,455,20],[455,21,455,25],[455,26,455,32],[455,33,455,39],[455,40,455,50],[455,51,455,54],[455,55,455,56],[455,57,455,59],[455,60,455,62],[455,63,455,68],[455,69,455,74],[455,75,455,78],[455,79,455,89],[456,0,456,1],[456,2,456,4],[456,5,456,10],[456,11,456,16],[456,17,456,20],[456,21,456,25],[456,26,456,32],[456,33,456,39],[456,40,456,50],[456,51,456,54],[456,55,456,56],[456,57,456,59],[456,60,456,62],[456,63,456,68],[456,69,456,74],[456,75,456,78],[456,79,456,89],[457,0,457,1],[457,2,457,4],[457,5,457,10],[457,11,457,16],[457,17,457,20],[457,21,457,25],[457,26,457,32],[457,33,457,39],[457,40,457,50],[457,51,457,54],[457,55,457,56],[457,57,457,59],[457,60,457,62],[457,63,457,68],[457,69,457,74],[457,75,457,78],[457,79,457,89],[458,0,458,1],[458,2,458,4],[458,5,458,10],[458,11,458,16],[458,17,458,20],[458,21,458,25],[458,26,458,32],[458,33,458,39],[458,40,458,50],[458,51,458,54],[458,55,458,56],[458,57,458,59],[458,60,458,62],[458,63,458,68],[458,69,458,74],[458,75,458,78],[458,79,458,89],[459,0,459,1],[459,2,459,4],[459,5,459,10],[459,11,459,16],[459,17,459,20],[459,21,459,25],[459,26,459,32],[459,33,459,39],[459,40,459,50],[459,51,459,54],[459,55,459,56],[459,57,459,59],[459,60,459,62],[459,63,459,68],[459,69,459,74],[459,75,459,78],[459,79,459,89],[460,0,460,1],[460,2,460,4],[460,5,460,10],[460,11,460,16],[460,17,460,20],[460,21,460,25],[460,26,460,32],[460,33,460,39],[460,40,460,50],[460,51,460,54],[460,55,460,56],[460,57,460,59],[460,60,460,62],[460,63,460,68],[460,69,460,74],[460,75,460,78],[460,79,460,89],[461,0,461,1],[461,2,461,4],[461,5,461,10],[461,11,461,16],[461,17,461,20],[461,21,461,25],[461,26,461,32],[461,33,461,39],[461,40,461,50],[461,51,461,54],[461,55,461,56],[461,57,461,59],[461,60,461,62],[461,63,461,68],[461,69,461,74],[461,75,461,78],[461,79,461,89],[462,0,462,1],[462,2,462,4],[462,5,462,10],[462,11,462,16],[462,17,462,20],[462,21,462,25],[462,26,462,32],[462,33,462,39],[462,40,462,50],[462,51,462,54],[462,55,462,56],[462,57,462,59],[462,60,462,62],[462,63,462,68],[462,69,462,74],[462,75,462,78],[462,79,462,89],[463,0,463,1],[463,2,463,4],[463,5,463,10],[463,11,463,16],[463,17,463,20],[463,21,463,25],[463,26,463,32],[463,33,463,39],[463,40,463,50],[463,51,463,54],[463,55,463,56],[463,57,463,59],[463,60,463,62],[463,63,463,68],[463,69,463,74],[463,75,463,78],[463,79,463,89],[464,0,464,1],[464,2,464,4],[464,5,464,10],[464,11,464,16],[464,17,464,20],[464,21,464,25],[464,26,464,32],[464,33,464,39],[464,40,464,50],[464,51,464,54],[464,55,464,56],[464,57,464,59],[464,60,464,62],[464,63,464,68],[464,69,464,74],[464,75,464,78],[464,79,464,89],[465,0,465,1],[465,2,465,4],[465,5,465,10],[465,11,465,16],[465,17,465,20],[465,21,465,25],[465,26,465,32],[465,33,465,39],[465,40,465,50],[465,51,465,54],[465,55,465,56],[465,57,465,59],[465,60,465,62],[465,63,465,68],[465,69,465,74],[465,75,465,78],[465,79,465,89],[466,0,466,1],[466,2,466,4],[466,5,466,10],[466,11,466,16],[466,17,466,20],[466,21,466,25],[466,26,466,32],[466,33,466,39],[466,40,466,50],[466,51,466,54],[466,55,466,56],[466,57,466,59],[466,60,466,62],[466,63,466,68],[466,69,466,74],[466,75,466,78],[466,79,466,89],[467,0,467,1],[467,2,467,4],[467,5,467,10],[467,11,467,16],[467,17,467,20],[467,21,467,25],[467,26,467,32],[467,33,467,39],[467,40,467,50],[467,51,467,54],[467,55,467,56],[467,57,467,59],[467,60,467,62],[467,63,467,68],[467,69,467,74],[467,75,467,78],[467,79,467,89],[468,0,468,1],[468,2,468,4],[468,5,468,10],[468,11,468,16],[468,17,468,20],[468,21,468,25],[468,26,468,32],[468,33,468,39],[468,40,468,50],[468,51,468,54],[468,55,468,56],[468,57,468,59],[468,60,468,62],[468,63,468,68],[468,69,468,74],[468,75,468,78],[468,79,468,89],[469,0,469,1],[469,2,469,4],[469,5,469,10],[469,11,469,16],[469,17,469,20],[469,21,469,25],[469,26,469,32],[469,33,469,39],[469,40,469,50],[469,51,469,54],[469,55,469,56],[469,57,469,59],[469,60,469,62],[469,63,469,68],[469,69,469,74],[469,75,469,78],[469,79,469,89],[470,0,470,1],[470,2,470,4],[470,5,470,10],[470,11,470,16],[470,17,470,20],[470,21,470,25],[470,26,470,32],[470,33,470,39],[470,40,470,50],[470,51,470,54],[470,55,470,56],[470,57,470,59],[470,60,470,62],[470,63,470,68],[470,69,470,74],[470,75,470,78],[470,79,470,89],[471,0,471,1],[471,2,471,4],[471,5,471,10],[471,11,471,16],[471,17,471,20],[471,21,471,25],[471,26,471,32],[471,33,471,39],[471,40,471,50],[471,51,471,54],[471,55,471,56],[471,57,471,59],[471,60,471,62],[471,63,471,68],[471,69,471,74],[471,75,471,78],[471,79,471,89],[472,0,472,1],[472,2,472,4],[472,5,472,10],[472,11,472,16],[472,17,472,20],[472,21,472,25],[472,26,472,32],[472,33,472,39],[472,40,472,50],[472,51,472,54],[472,55,472,56],[472,57,472,59],[472,60,472,62],[472,63,472,68],[472,69,472,74],[472,75,472,78],[472,79,472,89],[473,0,473,1],[473,2,473,4],[473,5,473,10],[473,11,473,16],[473,17,473,20],[473,21,473,25],[473,26,473,32],[473,33,473,39],[473,40,473,50],[473,51,473,54],[473,55,473,56],[473,57,473,59],[473,60,473,62],[473,63,473,68],[473,69,473,74],[473,75,473,78],[473,79,473,89],[474,0,474,1],[474,2,474,4],[474,5,474,10],[474,11,474,16],[474,17,474,20],[474,21,474,25],[474,26,474,32],[474,33,474,39],[474,40,474,50],[474,51,474,54],[474,55,474,56],[474,57,474,59],[474,60,474,62],[474,63,474,68],[474,69,474,74],[474,75,474,78],[474,79,474,89],[475,0,475,1],[475,2,475,4],[475,5,475,10],[475,11,475,16],[475,17,475,20],[475,21,475,25],[475,26,475,32],[475,33,475,39],[475,40,475,50],[475,51,475,54],[475,55,475,56],[475,57,475,59],[475,60,475,62],[475,63,475,68],[475,69,475,74],[475,75,475,78],[475,79,475,89],[476,0,476,1],[476,2,476,4],[476,5,476,10],[476,11,476,16],[476,17,476,20],[476,21,476,25],[476,26,476,32],[476,33,476,39],[476,40,476,50],[476,51,476,54],[476,55,476,56],[476,57,476,59],[476,60,476,62],[476,63,476,68],[476,69,476,74],[476,75,476,78],[476,79,476,89],[477,0,477,1],[477,2,477,4],[477,5,477,10],[477,11,477,16],[477,17,477,20],[477,21,477,25],[477,26,477,32],[477,33,477,39],[477,40,477,50],[477,51,477,54],[477,55,477,56],[477,57,477,59],[477,60,477,62],[477,63,477,68],[477,69,477,74],[477,75,477,78],[477,79,477,89],[478,0,478,1],[478,2,478,4],[478,5,478,10],[478,11,478,16],[478,17,478,20],[478,21,478,25],[478,26,478,32],[478,33,478,39],[478,40,478,50],[478,51,478,54],[478,55,478,56],[478,57,478,59],[478,60,478,62],[478,63,478,68],[478,69,478,74],[478,75,478,78],[478,79,478,89],[479,0,479,1],[479,2,479,4],[479,5,479,10],[479,11,479,16],[479,17,479,20],[479,21,479,25],[479,26,479,32],[479,33,479,39],[479,40,479,50],[479,51,479,54],[479,55,479,56],[479,57,479,59],[479,60,479,62],[479,63,479,68],[479,69,479,74],[479,75,479,78],[479,79,479,89],[480,0,480,1],[480,2,480,4],[480,5,480,10],[480,11,480,16],[480,17,480,20],[480,21,480,25],[480,26,480,32],[480,33,480,39],[480,40,480,50],[480,51,480,54],[480,55,480,56],[480,57,480,59],[480,60,480,62],[480,63,480,68],[480,69,480,74],[480,75,480,78],[480,79,480,89],[481,0,481,1],[481,2,481,4],[481,5,481,10],[481,11,481,16],[481,17,481,20],[481,21,481,25],[481,26,481,32],[481,33,481,39],[481,40,481,50],[481,51,481,54],[481,55,481,56],[481,57,481,59],[481,60,481,62],[481,63,481,68],[481,69,481,74],[481,75,481,78],[481,79,481,89],[482,0,482,1],[482,2,482,4],[482,5,482,10],[482,11,482,16],[482,17,482,20],[482,21,482,25],[482,26,482,32],[482,33,482,39],[482,40,482,50],[482,51,482,54],[482,55,482,56],[482,57,482,59],[482,60,482,62],[482,63,482,68],[482,69,482,74],[482,75,482,78],[482,79,482,89],[483,0,483,1],[483,2,483,4],[483,5,483,10],[483,11,483,16],[483,17,483,20],[483,21,483,25],[483,26,483,32],[483,33,483,39],[483,40,483,50],[483,51,483,54],[483,55,483,56],[483,57,483,59],[483,60,483,62],[483,63,483,68],[483,69,483,74],[483,75,483,78],[483,79,483,89],[484,0,484,1],[484,2,484,4],[484,5,484,10],[484,11,484,16],[484,17,484,20],[484,21,484,25],[484,26,484,32],[484,33,484,39],[484,40,484,50],[484,51,484,54],[484,55,484,56],[484,57,484,59],[484,60,484,62],[484,63,484,68],[484,69,484,74],[484,75,484,78],[484,79,484,89],[485,0,485,1],[485,2,485,4],[485,5,485,10],[485,11,485,16],[485,17,485,20],[485,21,485,25],[485,26,485,32],[485,33,485,39],[485,40,485,50],[485,51,485,54],[485,55,485,56],[485,57,485,59],[485,60,485,62],[485,63,485,68],[485,69,485,74],[485,75,485,78],[485,79,485,89],[486,0,486,1],[486,2,486,4],[486,5,486,10],[486,11,486,16],[486,17,486,20],[486,21,486,25],[486,26,486,32],[486,33,486,39],[486,40,486,50],[486,51,486,54],[486,55,486,56],[486,57,486,59],[486,60,486,62],[486,63,486,68],[486,69,486,74],[486,75,486,78],[486,79,486,89],[487,0,487,1],[487,2,487,4],[487,5,487,10],[487,11,487,16],[487,17,487,20],[487,21,487,25],[487,26,487,32],[487,33,487,39],[487,40,487,50],[487,51,487,54],[487,55,487,56],[487,57,487,59],[487,60,487,62],[487,63,487,68],[487,69,487,74],[487,75,487,78],[487,79,487,89],[488,0,488,1],[488,2,488,4],[488,5,488,10],[488,11,488,16],[488,17,488,20],[488,21,488,25],[488,26,488,32],[488,33,488,39],[488,40,488,50],[488,51,488,54],[488,55,488,56],[488,57,488,59],[488,60,488,62],[488,63,488,68],[488,69,488,74],[488,75,488,78],[488,79,488,89],[489,0,489,1],[489,2,489,4],[489,5,489,10],[489,11,489,16],[489,17,489,20],[489,21,489,25],[489,26,489,32],[489,33,489,39],[489,40,489,50],[489,51,489,54],[489,55,489,56],[489,57,489,59],[489,60,489,62],[489,63,489,68],[489,69,489,74],[489,75,489,78],[489,79,489,89],[490,0,490,1],[490,2,490,4],[490,5,490,10],[490,11,490,16],[490,17,490,20],[490,21,490,25],[490,26,490,32],[490,33,490,39],[490,40,490,50],[490,51,490,54],[490,55,490,56],[490,57,490,59],[490,60,490,62],[490,63,490,68],[490,69,490,74],[490,75,490,78],[490,79,490,89],[491,0,491,1],[491,2,491,4],[491,5,491,10],[491,11,491,16],[491,17,491,20],[491,21,491,25],[491,26,491,32],[491,33,491,39],[491,40,491,50],[491,51,491,54],[491,55,491,56],[491,57,491,59],[491,60,491,62],[491,63,491,68],[491,69,491,74],[491,75,491,78],[491,79,491,89],[492,0,492,1],[492,2,492,4],[492,5,492,10],[492,11,492,16],[492,17,492,20],[492,21,492,25],[492,26,492,32],[492,33,492,39],[492,40,492,50],[492,51,492,54],[492,55,492,56],[492,57,492,59],[492,60,492,62],[492,63,492,68],[492,69,492,74],[492,75,492,78],[492,79,492,89],[493,0,493,1],[493,2,493,4],[493,5,493,10],[493,11,493,16],[493,17,493,20],[493,21,493,25],[493,26,493,32],[493,33,493,39],[493,40,493,50],[493,51,493,54],[493,55,493,56],[493,57,493,59],[493,60,493,62],[493,63,493,68],[493,69,493,74],[493,75,493,78],[493,79,493,89],[494,0,494,1],[494,2,494,4],[494,5,494,10],[494,11,494,16],[494,17,494,20],[494,21,494,25],[494,26,494,32],[494,33,494,39],[494,40,494,50],[494,51,494,54],[494,55,494,56],[494,57,494,59],[494,60,494,62],[494,63,494,68],[494,69,494,74],[494,75,494,78],[494,79,494,89],[495,0,495,1],[495,2,495,4],[495,5,495,10],[495,11,495,16],[495,17,495,20],[495,21,495,25],[495,26,495,32],[495,33,495,39],[495,40,495,50],[495,51,495,54],[495,55,495,56],[495,57,495,59],[495,60,495,62],[495,63,495,68],[495,69,495,74],[495,75,495,78],[495,79,495,89],[496,0,496,1],[496,2,496,4],[496,5,496,10],[496,11,496,16],[496,17,496,20],[496,21,496,25],[496,26,496,32],[496,33,496,39],[496,40,496,50],[496,51,496,54],[496,55,496,56],[496,57,496,59],[496,60,496,62],[496,63,496,68],[496,69,496,74],[496,75,496,78],[496,79,496,89],[497,0,497,1],[497,2,497,4],[497,5,497,10],[497,11,497,16],[497,17,497,20],[497,21,497,25],[497,26,497,32],[497,33,497,39],[497,40,497,50],[497,51,497,54],[497,55,497,56],[497,57,497,59],[497,60,497,62],[497,63,497,68],[497,69,497,74],[497,75,497,78],[497,79,497,89],[498,0,498,1],[498,2,498,4],[498,5,498,10],[498,11,498,16],[498,17,498,20],[498,21,498,25],[498,26,498,32],[498,33,498,39],[498,40,498,50],[498,51,498,54],[498,55,498,56],[498,57,498,59],[498,60,498,62],[498,63,498,68],[498,69,498,74],[498,75,498,78],[498,79,498,89],[499,0,499,1],[499,2,499,4],[499,5,499,10],[499,11,499,16],[499,17,499,20],[499,21,499,25],[499,26,499,32],[499,33,499,39],[499,40,499,50],[499,51,499,54],[499,55,499,56],[499,57,499,59],[499,60,499,62],[499,63,499,68],[499,69,499,74],[499,75,499,78],[499,79,499,89]],"merged_total":8409,"flags":["merged_cut"]}
["Project:",{"$nulls":6},"[Project Name]",{"$nulls":37},"Non-Conformance Register"]
["Sub-Project or Phase:",{"$nulls":6},"[Sub-Project or Phase]"]
["Client:",{"$nulls":6},"[Client]",{"$nulls":37},"Project Mngr.:",{"$nulls":6},"[Proj. Mngr.]",{"$nulls":15},"Printed on",{"$nulls":6},{"$f":"TODAY()","v":"2015-03-12"}]
["Client's Representative:",{"$nulls":6},"[Client's Representative]",{"$nulls":37},"QA/QC Mngr.:",{"$nulls":6},"[QA/QC Mngr.]"]
["Contractor:",{"$nulls":6},"[Contractor]"]
[{"$nulls":45},"Ref.-No.:",{"$nulls":6},"[ref.number]"]
["ID",{"$nulls":4},"NCR Issued",{"$nulls":15},"Trade",{"$nulls":4},"Location",{"$nulls":6},"Item",{"$nulls":6},"NCR Reference No.",{"$nulls":10},"Close-out Date",{"$nulls":3},"Days Open",null,"Root Cause",{"$nulls":5},"Corrective Action",{"$nulls":11},"Associated Cost of Quality",{"$nulls":3},"Corrective Action Report No."]
[{"$nulls":5},"By",{"$nulls":5},"To",{"$nulls":5},"Date",{"$nulls":39},"Major",null,null,"Secondary",null,null,"Action 1",{"$nulls":5},"Action 2"]
["A",null,"B",null,null,"C",{"$nulls":5},"D",{"$nulls":5},"E",{"$nulls":3},"F",{"$nulls":4},"G",{"$nulls":6},"H",{"$nulls":6},"I",{"$nulls":10},"J",{"$nulls":3},"K",null,"L",null,null,"M",null,null,"N",{"$nulls":5},"O",{"$nulls":5},"P",{"$nulls":3},"Q"]
[{"v":1,"d":"0001"},null,"issued",null,null,"Client",{"$nulls":5},"Party 1",{"$nulls":5},"2014-08-01",{"$nulls":3},"Architectural",{"$nulls":4},"Location 1",{"$nulls":6},"Item 1",{"$nulls":17},"2014-08-28",{"$nulls":3},{"$f":"IF(R10=\"\",\"\",IF(AND(R10>0,AZ10=\"\"),TODAY()-R10,AZ10-R10))","v":27},null,"Man",{"$nulls":5},"rework",{"$nulls":5},"training",{"$nulls":5},{"v":10000,"d":"10,000"}]
[{"v":2,"d":"0002"},null,"issued",null,null,"Client",{"$nulls":5},"Party 2",{"$nulls":5},"2014-08-12",{"$nulls":3},"Electrical",{"$nulls":4},"Location 2",{"$nulls":6},"Item 3",{"$nulls":17},"2014-10-22",{"$nulls":3},{"$f":"IF(R11=\"\",\"\",IF(AND(R11>0,AZ11=\"\"),TODAY()-R11,AZ11-R11))","v":71},null,"Method",null,null,"Man",null,null,"rework",{"$nulls":11},{"v":1000,"d":"1,000"}]
[{"v":3,"d":"0003"},null,"issued",null,null,"Consultant",{"$nulls":5},"Party 3",{"$nulls":5},"2014-10-22",{"$nulls":3},"Fire Systems",{"$nulls":4},"Location 3",{"$nulls":6},"Item 3",{"$nulls":17},"2014-10-29",{"$nulls":3},{"$f":"IF(R12=\"\",\"\",IF(AND(R12>0,AZ12=\"\"),TODAY()-R12,AZ12-R12))","v":7},null,"Material",{"$nulls":5},"rework",{"$nulls":11},500]
[{"v":4,"d":"0004"},null,"received",null,null,"Main Contr.",{"$nulls":5},"Party 4",{"$nulls":5},"2014-10-23",{"$nulls":3},"HVAC",{"$nulls":4},"Location 5",{"$nulls":6},"Item 4",{"$nulls":17},"2014-11-01",{"$nulls":3},{"$f":"IF(R13=\"\",\"\",IF(AND(R13>0,AZ13=\"\"),TODAY()-R13,AZ13-R13))","v":9},null,"Man",{"$nulls":5},"rework"]
[{"v":5,"d":"0005"},null,"received",null,null,"Client",{"$nulls":5},"Party 5",{"$nulls":5},"2015-01-20",{"$nulls":3},"Landscaping",{"$nulls":4},"Location 5",{"$nulls":6},"Item 5",{"$nulls":23},"Man",{"$nulls":5},"rework",{"$nulls":11},{"v":1100,"d":"1,100"}]
[{"v":6,"d":"0006"},null,"received",null,null,"Main Contr.",{"$nulls":5},"Party 6",{"$nulls":5},"2015-02-20",{"$nulls":3},"Mechanical",{"$nulls":4},"Location 6",{"$nulls":6},"Item 6",{"$nulls":23},"Man",{"$nulls":5},"rework",{"$nulls":11},{"v":1200,"d":"1,200"}]
[{"v":7,"d":"0007"},null,"received",null,null,"Main Contr.",{"$nulls":5},"Party 7",{"$nulls":5},"2015-02-21",{"$nulls":3},"Plumbing",{"$nulls":4},"Location 7",{"$nulls":6},"Item 7",{"$nulls":23},"Man",{"$nulls":5},"rework",{"$nulls":11},{"v":1300,"d":"1,300"}]
[{"v":8,"d":"0008"},null,"received",null,null,"Main Contr.",{"$nulls":5},"Party 8",{"$nulls":5},"2015-03-20",{"$nulls":3},"Safety",{"$nulls":4},"Location 8",{"$nulls":6},"Item 8",{"$nulls":23},"Man",{"$nulls":5},"rework",{"$nulls":11},{"v":1400,"d":"1,400"}]
[{"v":9,"d":"0009"},null,"received",null,null,"Main Contr.",{"$nulls":5},"Party 9",{"$nulls":5},"2015-03-21",{"$nulls":3},"Structural",{"$nulls":4},"Location 9",{"$nulls":6},"Item 9",{"$nulls":23},"Man",{"$nulls":5},"rework",{"$nulls":11},{"v":1500,"d":"1,500"}]
[{"v":10,"d":"0010"},null,"received",null,null,"Main Contr.",{"$nulls":5},"Party 10",{"$nulls":5},"2015-03-21",{"$nulls":3},"Others",{"$nulls":4},"Location 10",{"$nulls":6},"Item 10",{"$nulls":23},"Man",{"$nulls":5},"rework",{"$nulls":11},{"v":1600,"d":"1,600"}]
[{"v":11,"d":"0011"},null,"received",null,null,"Main Contr.",{"$nulls":5},"Party 1",{"$nulls":5},"2015-04-01",{"$nulls":3},"Architectural",{"$nulls":4},"Location 1",{"$nulls":6},"Item 11",{"$nulls":23},"Man",{"$nulls":5},"rework",{"$nulls":11},{"v":1700,"d":"1,700"}]
[{"v":12,"d":"0012"},null,"received",null,null,"Main Contr.",{"$nulls":5},"Party 1",{"$nulls":5},"2015-04-02",{"$nulls":3},"Architectural",{"$nulls":4},"Location 2",{"$nulls":6},"Item 12"]

{"sheet":"Dashboard","index":2,"n_rows":56,"n_cols":48,"rows_kept":56,"merged":[[0,0,0,62],[1,0,1,4],[1,5,1,7],[2,0,2,4],[2,5,2,7],[3,0,3,4],[3,5,3,7]]}
[]
["Total NCR",{"$nulls":4},{"$f":"COUNT(Register!A10:A1048576)","v":12},{"$nulls":27},{"$f":"IF(Validation!$C2=0,\"\",Validation!$C2)","v":"Party 1"},{"$f":"IF(Validation!$C3=0,\"\",Validation!$C3)","v":"Party 2"},{"$f":"IF(Validation!$C4=0,\"\",Validation!$C4)","v":"Party 3"},{"$f":"IF(Validation!$C5=0,\"\",Validation!$C5)","v":"Party 4"},{"$f":"IF(Validation!$C6=0,\"\",Validation!$C6)","v":"Party 5"},{"$f":"IF(Validation!$C7=0,\"\",Validation!$C7)","v":"Party 6"},{"$f":"IF(Validation!$C8=0,\"\",Validation!$C8)","v":"Party 7"},{"$f":"IF(Validation!$C9=0,\"\",Validation!$C9)","v":"Party 8"},{"$f":"IF(Validation!$C10=0,\"\",Validation!$C10)","v":"Party 9"},{"$f":"IF(Validation!$C11=0,\"\",Validation!$C11)","v":"Party 10"}]
["Total closed",{"$nulls":4},{"$f":"COUNTIF(Register!AZ10:AZ1048576,\">0\")","v":4},{"$nulls":27},{"$f":"IF(AH$2=\"\",\"\",COUNTIF(Register!$L$10:$L$1048576,AH$2))","v":3},{"$f":"IF(AI$2=\"\",\"\",COUNTIF(Register!$L$10:$L$1048576,AI$2))","v":1},{"$f":"IF(AJ$2=\"\",\"\",COUNTIF(Register!$L$10:$L$1048576,AJ$2))","v":1},{"$f":"IF(AK$2=\"\",\"\",COUNTIF(Register!$L$10:$L$1048576,AK$2))","v":1},{"$f":"IF(AL$2=\"\",\"\",COUNTIF(Register!$L$10:$L$1048576,AL$2))","v":1},{"$f":"IF(AM$2=\"\",\"\",COUNTIF(Register!$L$10:$L$1048576,AM$2))","v":1},{"$f":"IF(AN$2=\"\",\"\",COUNTIF(Register!$L$10:$L$1048576,AN$2))","v":1},{"$f":"IF(AO$2=\"\",\"\",COUNTIF(Register!$L$10:$L$1048576,AO$2))","v":1},{"$f":"IF(AP$2=\"\",\"\",COUNTIF(Register!$L$10:$L$1048576,AP$2))","v":1},{"$f":"IF(AQ$2=\"\",\"\",COUNTIF(Register!$L$10:$L$1048576,AQ$2))","v":1}]
["Total open",{"$nulls":4},{"$f":"F2-F3","v":8}]
{"$rows_empty":14}
[{"$f":"IF(Validation!$E2=0,\"\",Validation!$E2)","v":"Architectural"},{"$f":"IF(Validation!$E3=0,\"\",Validation!$E3)","v":"Electrical"},{"$f":"IF(Validation!$E4=0,\"\",Validation!$E4)","v":"Fire Systems"},{"$f":"IF(Validation!$E5=0,\"\",Validation!$E5)","v":"HVAC"},{"$f":"IF(Validation!$E6=0,\"\",Validation!$E6)","v":"Landscaping"},{"$f":"IF(Validation!$E7=0,\"\",Validation!$E7)","v":"Mechanical"},{"$f":"IF(Validation!$E8=0,\"\",Validation!$E8)","v":"Plumbing"},{"$f":"IF(Validation!$E9=0,\"\",Validation!$E9)","v":"Safety"},{"$f":"IF(Validation!$E10=0,\"\",Validation!$E10)","v":"Structural"},{"$f":"IF(Validation!$E11=0,\"\",Validation!$E11)","v":"Others"},{"$nulls":23},{"$f":"IF(Validation!$K2=0,\"\",Validation!$K2)","v":"Man"},{"$f":"IF(Validation!$K3=0,\"\",Validation!$K3)","v":"Method"},{"$f":"IF(Validation!$K4=0,\"\",Validation!$K4)","v":"Material"},{"$f":"IF(Validation!$K5=0,\"\",Validation!$K5)","v":"Machine"}]
[{"$f":"IF(A$19=\"\",\"\",COUNTIF(Register!$V$10:$V$1048576,A$19))","v":3},{"$f":"IF(B$19=\"\",\"\",COUNTIF(Register!$V$10:$V$1048576,B$19))","v":1},{"$f":"IF(C$19=\"\",\"\",COUNTIF(Register!$V$10:$V$1048576,C$19))","v":1},{"$f":"IF(D$19=\"\",\"\",COUNTIF(Register!$V$10:$V$1048576,D$19))","v":1},{"$f":"IF(E$19=\"\",\"\",COUNTIF(Register!$V$10:$V$1048576,E$19))","v":1},{"$f":"IF(F$19=\"\",\"\",COUNTIF(Register!$V$10:$V$1048576,F$19))","v":1},{"$f":"IF(G$19=\"\",\"\",COUNTIF(Register!$V$10:$V$1048576,G$19))","v":1},{"$f":"IF(H$19=\"\",\"\",COUNTIF(Register!$V$10:$V$1048576,H$19))","v":1},{"$f":"IF(I$19=\"\",\"\",COUNTIF(Register!$V$10:$V$1048576,I$19))","v":1},{"$f":"IF(J$19=\"\",\"\",COUNTIF(Register!$V$10:$V$1048576,J$19))","v":1},{"$nulls":23},{"$f":"IF(AH$19=\"\",\"\",COUNTIF(Register!$BF$10:$BF$1048576,AH$19))","v":9},{"$f":"IF(AI$19=\"\",\"\",COUNTIF(Register!$BF$10:$BF$1048576,AI$19))","v":1},{"$f":"IF(AJ$19=\"\",\"\",COUNTIF(Register!$BF$10:$BF$1048576,AJ$19))","v":1},{"$f":"IF(AK$19=\"\",\"\",COUNTIF(Register!$BF$10:$BF$1048576,AK$19))","v":0}]
{"$rows_empty":15}
[{"$f":"EOMONTH(Register!R10,-1)+1","v":"2014-08-01"},{"$f":"EDATE(A36,1)","v":"2014-09-01"},{"$f":"EDATE(B36,1)","v":"2014-10-01"},"2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01"]
[{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&A$36,Register!$R$10:$R$1048576,\"<\"&EDATE(A$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&A$36,Register!$R$10:$R$1048576,\"<\"&EDATE(A$36,1)))","v":2},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&B$36,Register!$R$10:$R$1048576,\"<\"&EDATE(B$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&B$36,Register!$R$10:$R$1048576,\"<\"&EDATE(B$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&C$36,Register!$R$10:$R$1048576,\"<\"&EDATE(C$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&C$36,Register!$R$10:$R$1048576,\"<\"&EDATE(C$36,1)))","v":2},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&D$36,Register!$R$10:$R$1048576,\"<\"&EDATE(D$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&D$36,Register!$R$10:$R$1048576,\"<\"&EDATE(D$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&E$36,Register!$R$10:$R$1048576,\"<\"&EDATE(E$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&E$36,Register!$R$10:$R$1048576,\"<\"&EDATE(E$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&F$36,Register!$R$10:$R$1048576,\"<\"&EDATE(F$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&F$36,Register!$R$10:$R$1048576,\"<\"&EDATE(F$36,1)))","v":1},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&G$36,Register!$R$10:$R$1048576,\"<\"&EDATE(G$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&G$36,Register!$R$10:$R$1048576,\"<\"&EDATE(G$36,1)))","v":2},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&H$36,Register!$R$10:$R$1048576,\"<\"&EDATE(H$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&H$36,Register!$R$10:$R$1048576,\"<\"&EDATE(H$36,1)))","v":3},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&I$36,Register!$R$10:$R$1048576,\"<\"&EDATE(I$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&I$36,Register!$R$10:$R$1048576,\"<\"&EDATE(I$36,1)))","v":2},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&J$36,Register!$R$10:$R$1048576,\"<\"&EDATE(J$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&J$36,Register!$R$10:$R$1048576,\"<\"&EDATE(J$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&K$36,Register!$R$10:$R$1048576,\"<\"&EDATE(K$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&K$36,Register!$R$10:$R$1048576,\"<\"&EDATE(K$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&L$36,Register!$R$10:$R$1048576,\"<\"&EDATE(L$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&L$36,Register!$R$10:$R$1048576,\"<\"&EDATE(L$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&M$36,Register!$R$10:$R$1048576,\"<\"&EDATE(M$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&M$36,Register!$R$10:$R$1048576,\"<\"&EDATE(M$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&N$36,Register!$R$10:$R$1048576,\"<\"&EDATE(N$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&N$36,Register!$R$10:$R$1048576,\"<\"&EDATE(N$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&O$36,Register!$R$10:$R$1048576,\"<\"&EDATE(O$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&O$36,Register!$R$10:$R$1048576,\"<\"&EDATE(O$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&P$36,Register!$R$10:$R$1048576,\"<\"&EDATE(P$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&P$36,Register!$R$10:$R$1048576,\"<\"&EDATE(P$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&Q$36,Register!$R$10:$R$1048576,\"<\"&EDATE(Q$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&Q$36,Register!$R$10:$R$1048576,\"<\"&EDATE(Q$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&R$36,Register!$R$10:$R$1048576,\"<\"&EDATE(R$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&R$36,Register!$R$10:$R$1048576,\"<\"&EDATE(R$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&S$36,Register!$R$10:$R$1048576,\"<\"&EDATE(S$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&S$36,Register!$R$10:$R$1048576,\"<\"&EDATE(S$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&T$36,Register!$R$10:$R$1048576,\"<\"&EDATE(T$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&T$36,Register!$R$10:$R$1048576,\"<\"&EDATE(T$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&U$36,Register!$R$10:$R$1048576,\"<\"&EDATE(U$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&U$36,Register!$R$10:$R$1048576,\"<\"&EDATE(U$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&V$36,Register!$R$10:$R$1048576,\"<\"&EDATE(V$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&V$36,Register!$R$10:$R$1048576,\"<\"&EDATE(V$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&W$36,Register!$R$10:$R$1048576,\"<\"&EDATE(W$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&W$36,Register!$R$10:$R$1048576,\"<\"&EDATE(W$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&X$36,Register!$R$10:$R$1048576,\"<\"&EDATE(X$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&X$36,Register!$R$10:$R$1048576,\"<\"&EDATE(X$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&Y$36,Register!$R$10:$R$1048576,\"<\"&EDATE(Y$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&Y$36,Register!$R$10:$R$1048576,\"<\"&EDATE(Y$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&Z$36,Register!$R$10:$R$1048576,\"<\"&EDATE(Z$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&Z$36,Register!$R$10:$R$1048576,\"<\"&EDATE(Z$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AA$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AA$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AA$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AA$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AB$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AB$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AB$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AB$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AC$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AC$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AC$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AC$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AD$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AD$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AD$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AD$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AE$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AE$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AE$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AE$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AF$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AF$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AF$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AF$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AG$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AG$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AG$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AG$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AH$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AH$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AH$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AH$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AI$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AI$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AI$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AI$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AJ$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AJ$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AJ$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AJ$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AK$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AK$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AK$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AK$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AL$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AL$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AL$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AL$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AM$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AM$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AM$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AM$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AN$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AN$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AN$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AN$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AO$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AO$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AO$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AO$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AP$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AP$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AP$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AP$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AQ$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AQ$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AQ$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AQ$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AR$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AR$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AR$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AR$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AS$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AS$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AS$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AS$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AT$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AT$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AT$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AT$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AU$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AU$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AU$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AU$36,1)))","v":0},{"$f":"IF(COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AV$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AV$36,1))=0,0,COUNTIFS(Register!$R$10:$R$1048576,\">=\"&AV$36,Register!$R$10:$R$1048576,\"<\"&EDATE(AV$36,1)))","v":0}]
[{"$f":"AVERAGE($A$37:A$37)","v":2},{"$f":"AVERAGE($A$37:B$37)","v":1},{"$f":"AVERAGE($A$37:C$37)","v":{"v":1.3333333333333333,"d":"1"}},{"$f":"AVERAGE($A$37:D$37)","v":1},{"$f":"AVERAGE($A$37:E$37)","v":{"v":0.8,"d":"1"}},{"$f":"AVERAGE($A$37:F$37)","v":{"v":0.8333333333333334,"d":"1"}},{"$f":"AVERAGE($A$37:G$37)","v":1},{"$f":"AVERAGE($A$37:H$37)","v":{"v":1.25,"d":"1"}},{"$f":"AVERAGE($A$37:I$37)","v":{"v":1.3333333333333333,"d":"1"}},{"$f":"AVERAGE($A$37:J$37)","v":{"v":1.2,"d":"1"}},{"$f":"AVERAGE($A$37:K$37)","v":{"v":1.0909090909090908,"d":"1"}},{"$f":"AVERAGE($A$37:L$37)","v":1},{"$f":"AVERAGE($A$37:M$37)","v":{"v":0.9230769230769231,"d":"1"}},{"$f":"AVERAGE($A$37:N$37)","v":{"v":0.8571428571428571,"d":"1"}},{"$f":"AVERAGE($A$37:O$37)","v":{"v":0.8,"d":"1"}},{"$f":"AVERAGE($A$37:P$37)","v":{"v":0.75,"d":"1"}},{"$f":"AVERAGE($A$37:Q$37)","v":{"v":0.7058823529411765,"d":"1"}},{"$f":"AVERAGE($A$37:R$37)","v":{"v":0.6666666666666666,"d":"1"}},{"$f":"AVERAGE($A$37:S$37)","v":{"v":0.631578947368421,"d":"1"}},{"$f":"AVERAGE($A$37:T$37)","v":{"v":0.6,"d":"1"}},{"$f":"AVERAGE($A$37:U$37)","v":{"v":0.5714285714285714,"d":"1"}},{"$f":"AVERAGE($A$37:V$37)","v":{"v":0.5454545454545454,"d":"1"}},{"$f":"AVERAGE($A$37:W$37)","v":{"v":0.5217391304347826,"d":"1"}},{"$f":"AVERAGE($A$37:X$37)","v":{"v":0.5,"d":"1"}},{"$f":"AVERAGE($A$37:Y$37)","v":{"v":0.48,"d":"0"}},{"$f":"AVERAGE($A$37:Z$37)","v":{"v":0.46153846153846156,"d":"0"}},{"$f":"AVERAGE($A$37:AA$37)","v":{"v":0.4444444444444444,"d":"0"}},{"$f":"AVERAGE($A$37:AB$37)","v":{"v":0.42857142857142855,"d":"0"}},{"$f":"AVERAGE($A$37:AC$37)","v":{"v":0.41379310344827586,"d":"0"}},{"$f":"AVERAGE($A$37:AD$37)","v":{"v":0.4,"d":"0"}},{"$f":"AVERAGE($A$37:AE$37)","v":{"v":0.3870967741935484,"d":"0"}},{"$f":"AVERAGE($A$37:AF$37)","v":{"v":0.375,"d":"0"}},{"$f":"AVERAGE($A$37:AG$37)","v":{"v":0.36363636363636365,"d":"0"}},{"$f":"AVERAGE($A$37:AH$37)","v":{"v":0.35294117647058826,"d":"0"}},{"$f":"AVERAGE($A$37:AI$37)","v":{"v":0.34285714285714286,"d":"0"}},{"$f":"AVERAGE($A$37:AJ$37)","v":{"v":0.3333333333333333,"d":"0"}},{"$f":"AVERAGE($A$37:AK$37)","v":{"v":0.32432432432432434,"d":"0"}},{"$f":"AVERAGE($A$37:AL$37)","v":{"v":0.3157894736842105,"d":"0"}},{"$f":"AVERAGE($A$37:AM$37)","v":{"v":0.3076923076923077,"d":"0"}},{"$f":"AVERAGE($A$37:AN$37)","v":{"v":0.3,"d":"0"}},{"$f":"AVERAGE($A$37:AO$37)","v":{"v":0.2926829268292683,"d":"0"}},{"$f":"AVERAGE($A$37:AP$37)","v":{"v":0.2857142857142857,"d":"0"}},{"$f":"AVERAGE($A$37:AQ$37)","v":{"v":0.27906976744186046,"d":"0"}},{"$f":"AVERAGE($A$37:AR$37)","v":{"v":0.2727272727272727,"d":"0"}},{"$f":"AVERAGE($A$37:AS$37)","v":{"v":0.26666666666666666,"d":"0"}},{"$f":"AVERAGE($A$37:AT$37)","v":{"v":0.2608695652173913,"d":"0"}},{"$f":"AVERAGE($A$37:AU$37)","v":{"v":0.2553191489361702,"d":"0"}},{"$f":"AVERAGE($A$37:AV$37)","v":{"v":0.25,"d":"0"}}]
{"$rows_empty":14}
[{"$f":"A36","v":"2014-08-01"},{"$f":"EDATE(A53,1)","v":"2014-09-01"},{"$f":"EDATE(B53,1)","v":"2014-10-01"},"2014-11-01","2014-12-01","2015-01-01","2015-02-01","2015-03-01","2015-04-01","2015-05-01","2015-06-01","2015-07-01","2015-08-01","2015-09-01","2015-10-01","2015-11-01","2015-12-01","2016-01-01","2016-02-01","2016-03-01","2016-04-01","2016-05-01","2016-06-01","2016-07-01","2016-08-01","2016-09-01","2016-10-01","2016-11-01","2016-12-01","2017-01-01","2017-02-01","2017-03-01","2017-04-01","2017-05-01","2017-06-01","2017-07-01","2017-08-01","2017-09-01","2017-10-01","2017-11-01","2017-12-01","2018-01-01","2018-02-01","2018-03-01","2018-04-01","2018-05-01","2018-06-01","2018-07-01"]
[{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&A$53,Register!$R$10:$R$1048576,\"<\"&EDATE(A$53,1))","v":11000},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&B$53,Register!$R$10:$R$1048576,\"<\"&EDATE(B$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&C$53,Register!$R$10:$R$1048576,\"<\"&EDATE(C$53,1))","v":500},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&D$53,Register!$R$10:$R$1048576,\"<\"&EDATE(D$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&E$53,Register!$R$10:$R$1048576,\"<\"&EDATE(E$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&F$53,Register!$R$10:$R$1048576,\"<\"&EDATE(F$53,1))","v":1100},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&G$53,Register!$R$10:$R$1048576,\"<\"&EDATE(G$53,1))","v":2500},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&H$53,Register!$R$10:$R$1048576,\"<\"&EDATE(H$53,1))","v":4500},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&I$53,Register!$R$10:$R$1048576,\"<\"&EDATE(I$53,1))","v":1700},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&J$53,Register!$R$10:$R$1048576,\"<\"&EDATE(J$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&K$53,Register!$R$10:$R$1048576,\"<\"&EDATE(K$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&L$53,Register!$R$10:$R$1048576,\"<\"&EDATE(L$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&M$53,Register!$R$10:$R$1048576,\"<\"&EDATE(M$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&N$53,Register!$R$10:$R$1048576,\"<\"&EDATE(N$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&O$53,Register!$R$10:$R$1048576,\"<\"&EDATE(O$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&P$53,Register!$R$10:$R$1048576,\"<\"&EDATE(P$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&Q$53,Register!$R$10:$R$1048576,\"<\"&EDATE(Q$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&R$53,Register!$R$10:$R$1048576,\"<\"&EDATE(R$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&S$53,Register!$R$10:$R$1048576,\"<\"&EDATE(S$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&T$53,Register!$R$10:$R$1048576,\"<\"&EDATE(T$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&U$53,Register!$R$10:$R$1048576,\"<\"&EDATE(U$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&V$53,Register!$R$10:$R$1048576,\"<\"&EDATE(V$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&W$53,Register!$R$10:$R$1048576,\"<\"&EDATE(W$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&X$53,Register!$R$10:$R$1048576,\"<\"&EDATE(X$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&Y$53,Register!$R$10:$R$1048576,\"<\"&EDATE(Y$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&Z$53,Register!$R$10:$R$1048576,\"<\"&EDATE(Z$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AA$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AA$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AB$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AB$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AC$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AC$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AD$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AD$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AE$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AE$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AF$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AF$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AG$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AG$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AH$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AH$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AI$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AI$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AJ$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AJ$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AK$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AK$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AL$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AL$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AM$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AM$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AN$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AN$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AO$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AO$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AP$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AP$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AQ$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AQ$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AR$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AR$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AS$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AS$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AT$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AT$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AU$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AU$53,1))","v":0},{"$f":"SUMIFS(Register!$BX$10:$BX$1048576,Register!$R$10:$R$1048576,\">=\"&AV$53,Register!$R$10:$R$1048576,\"<\"&EDATE(AV$53,1))","v":0}]
[{"$f":"AVERAGE($A$54:A$54)","v":11000},{"$f":"AVERAGE($A$54:B$54)","v":5500},{"$f":"AVERAGE($A$54:C$54)","v":{"v":3833.3333333333335,"d":"3833"}},{"$f":"AVERAGE($A$54:D$54)","v":2875},{"$f":"AVERAGE($A$54:E$54)","v":2300},{"$f":"AVERAGE($A$54:F$54)","v":2100},{"$f":"AVERAGE($A$54:G$54)","v":{"v":2157.1428571428573,"d":"2157"}},{"$f":"AVERAGE($A$54:H$54)","v":2450},{"$f":"AVERAGE($A$54:I$54)","v":{"v":2366.6666666666665,"d":"2367"}},{"$f":"AVERAGE($A$54:J$54)","v":2130},{"$f":"AVERAGE($A$54:K$54)","v":{"v":1936.3636363636363,"d":"1936"}},{"$f":"AVERAGE($A$54:L$54)","v":1775},{"$f":"AVERAGE($A$54:M$54)","v":{"v":1638.4615384615386,"d":"1638"}},{"$f":"AVERAGE($A$54:N$54)","v":{"v":1521.4285714285713,"d":"1521"}},{"$f":"AVERAGE($A$54:O$54)","v":1420},{"$f":"AVERAGE($A$54:P$54)","v":{"v":1331.25,"d":"1331"}},{"$f":"AVERAGE($A$54:Q$54)","v":{"v":1252.9411764705883,"d":"1253"}},{"$f":"AVERAGE($A$54:R$54)","v":{"v":1183.3333333333333,"d":"1183"}},{"$f":"AVERAGE($A$54:S$54)","v":{"v":1121.0526315789473,"d":"1121"}},{"$f":"AVERAGE($A$54:T$54)","v":1065},{"$f":"AVERAGE($A$54:U$54)","v":{"v":1014.2857142857143,"d":"1014"}},{"$f":"AVERAGE($A$54:V$54)","v":{"v":968.1818181818181,"d":"968"}},{"$f":"AVERAGE($A$54:W$54)","v":{"v":926.0869565217391,"d":"926"}},{"$f":"AVERAGE($A$54:X$54)","v":{"v":887.5,"d":"888"}},{"$f":"AVERAGE($A$54:Y$54)","v":852},{"$f":"AVERAGE($A$54:Z$54)","v":{"v":819.2307692307693,"d":"819"}},{"$f":"AVERAGE($A$54:AA$54)","v":{"v":788.8888888888889,"d":"789"}},{"$f":"AVERAGE($A$54:AB$54)","v":{"v":760.7142857142857,"d":"761"}},{"$f":"AVERAGE($A$54:AC$54)","v":{"v":734.4827586206897,"d":"734"}},{"$f":"AVERAGE($A$54:AD$54)","v":710},{"$f":"AVERAGE($A$54:AE$54)","v":{"v":687.0967741935484,"d":"687"}},{"$f":"AVERAGE($A$54:AF$54)","v":{"v":665.625,"d":"666"}},{"$f":"AVERAGE($A$54:AG$54)","v":{"v":645.4545454545455,"d":"645"}},{"$f":"AVERAGE($A$54:AH$54)","v":{"v":626.4705882352941,"d":"626"}},{"$f":"AVERAGE($A$54:AI$54)","v":{"v":608.5714285714286,"d":"609"}},{"$f":"AVERAGE($A$54:AJ$54)","v":{"v":591.6666666666666,"d":"592"}},{"$f":"AVERAGE($A$54:AK$54)","v":{"v":575.6756756756756,"d":"576"}},{"$f":"AVERAGE($A$54:AL$54)","v":{"v":560.5263157894736,"d":"561"}},{"$f":"AVERAGE($A$54:AM$54)","v":{"v":546.1538461538462,"d":"546"}},{"$f":"AVERAGE($A$54:AN$54)","v":{"v":532.5,"d":"533"}},{"$f":"AVERAGE($A$54:AO$54)","v":{"v":519.5121951219512,"d":"520"}},{"$f":"AVERAGE($A$54:AP$54)","v":{"v":507.14285714285717,"d":"507"}},{"$f":"AVERAGE($A$54:AQ$54)","v":{"v":495.3488372093023,"d":"495"}},{"$f":"AVERAGE($A$54:AR$54)","v":{"v":484.09090909090907,"d":"484"}},{"$f":"AVERAGE($A$54:AS$54)","v":{"v":473.3333333333333,"d":"473"}},{"$f":"AVERAGE($A$54:AT$54)","v":{"v":463.04347826086956,"d":"463"}},{"$f":"AVERAGE($A$54:AU$54)","v":{"v":453.1914893617021,"d":"453"}},{"$f":"AVERAGE($A$54:AV$54)","v":{"v":443.75,"d":"444"}}]
[{"$f":"A54","v":11000},{"$f":"A56+B54","v":11000},{"$f":"B56+C54","v":11500},11500,11500,12600,15100,19600,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300,21300]

{"sheet":"Validation","index":3,"n_rows":31,"n_cols":11,"rows_kept":31}
["Issued by…",null,"Received by…",null,"Trade",null,"Loccation",null,"Item",null,"Root Cause"]
["Client",null,"Party 1",null,"Architectural",null,"Location 1",null,"Item 1",null,"Man"]
["Consultant",null,"Party 2",null,"Electrical",null,"Location 2",null,"Item 2",null,"Method"]
["Main Contr.",null,"Party 3",null,"Fire Systems",null,"Location 3",null,"Item 3",null,"Material"]
[null,null,"Party 4",null,"HVAC",null,"Location 4",null,"Item 4",null,"Machine"]
[null,null,"Party 5",null,"Landscaping",null,"Location 5",null,"Item 5"]
[null,null,"Party 6",null,"Mechanical",null,"Location 6",null,"Item 6"]
[null,null,"Party 7",null,"Plumbing",null,"Location 7",null,"Item 7"]
[null,null,"Party 8",null,"Safety",null,"Location 8",null,"Item 8"]
[null,null,"Party 9",null,"Structural",null,"Location 9",null,"Item 9"]
[null,null,"Party 10",null,"Others",null,"Location 10",null,"Item 10"]
[{"$nulls":6},"Location 11",null,"Item 11"]
[{"$nulls":6},"Location 12",null,"Item 12"]
[{"$nulls":6},"Location 13",null,"Item 13"]
[{"$nulls":6},"Location 14",null,"Item 14"]
[{"$nulls":6},"Location 15",null,"Item 15"]
[{"$nulls":6},"Location 16",null,"Item 16"]
[{"$nulls":6},"Location 17",null,"Item 17"]
[{"$nulls":6},"Location 18",null,"Item 18"]
[{"$nulls":6},"Location 19",null,"Item 19"]
[{"$nulls":6},"Location 20",null,"Item 20"]
[{"$nulls":6},"Location 21",null,"Item 21"]
[{"$nulls":6},"Location 22",null,"Item 22"]
[{"$nulls":6},"Location 23",null,"Item 23"]
[{"$nulls":6},"Location 24",null,"Item 24"]
[{"$nulls":6},"Location 25",null,"Item 25"]
[{"$nulls":6},"Location 26",null,"Item 26"]
[{"$nulls":6},"Location 27",null,"Item 27"]
[{"$nulls":6},"Location 28",null,"Item 28"]
[{"$nulls":6},"Location 29",null,"Item 29"]
[{"$nulls":6},"Location 30",null,"Item 30"]