Spreadsheet: 52255d1251968915-finding-a-value-without-a-specific-cell-location-cant-use-hlookup
Sheet: Sheet 2

policyno | docid | AppPeriod | AgState | Series29 | indexed | routed | timespent | rework | onhold | Days1 | [NAME] | Days3 | Days4 | Days5 | Days6 | Days6Plus
185454 | 8321312 | 200909 | WA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 61 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185455 | 8321313 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 642 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185456 | 8321314 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 439 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185457 | 8321315 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 505 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185458 | 8321316 | 200909 | QLD | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 370 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185459 | 8321317 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 722 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185460 | 8321318 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 822 | 0 | 263 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185461 | 8321319 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 828 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185462 | 8321320 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 251 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185463 | 8321321 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 369 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185464 | 8321322 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 246 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185465 | 8321323 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 222 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185466 | 8321324 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 574 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185467 | 8321325 | 200909 | WA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 344 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185468 | 8321326 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 466 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185469 | 8321327 | 200909 | WA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 387 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185470 | 8321328 | 200909 | WA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 398 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185471 | 8321329 | 200909 | QLD | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 165 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185472 | 8321330 | 200909 | WA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 776 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185473 | 8321331 | 200909 | WA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 404 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185474 | 8321332 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 653 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185475 | 8321333 | 200909 | NSW | 1 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 129 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185476 | 8321334 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 430 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185477 | 8321335 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 433 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185478 | 8321336 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 278 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185479 | 8321337 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 278 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185480 | 8321338 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 278 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185481 | 8321339 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 643 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185482 | 8321340 | 200909 | WA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 461 | 0 | 66 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185483 | 8321341 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 596 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185484 | 8321342 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 418 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185485 | 8321343 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 609 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185486 | 8321344 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 418 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185487 | 8321345 | 200909 | QLD | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 559 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185488 | 8321346 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 978 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
185489 | 8321347 | 200909 | QLD | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 99 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185490 | 8321348 | 200909 | QLD | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 269 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185491 | 8321349 | 200909 | WA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 105 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185492 | 8321350 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 534 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185493 | 8321351 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 511 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
185494 | 8321352 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 126 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185495 | 8321353 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 123 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185496 | 8321354 | 200909 | VIC | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 112 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185497 | 8321355 | 200909 | SA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 153 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185498 | 8321356 | 200909 | SA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 157 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185499 | 8321357 | 200909 | NSW | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 223 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
185500 | 8321358 | 200909 | SA | 0 | Sep  2 2009 12:07:00:733PM | Sep  2 2009 12:07:00:733PM | 400 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | SUMMARY AREA
 | 1 day | 2 days | 3 days | 4 days | 5 days | 6 days | >6 days
 | 68.09% | 29.79% | 2.13% | 0.00% | 0.00% | 0.00% | 0.00%