Spreadsheet: 36196d1233957381-returning-multiple-rows-based-on-date-range-danomite
Sheet: Data Set

Date | Customer | Barn # | Invoice # | Vendor Count | Customer Count | 100% Deductions | Partial Deductions | Index
2008-08-01 00:00:00 | Jurassic | 1 | TS238 | 418 | 418 | 2 | 1.5 | 0
2008-08-04 00:00:00 | Jurassic | 1 | TS239 | 452 | 451 | 10 | 5.75 | 0
2008-08-05 00:00:00 | Jurassic | 1 | TS240 | 348 | 348 | 3 | 3.25 | 0
2008-08-06 00:00:00 | Jurassic | 1 | TS241 | 392 | 390 | 6 | 7 | 0
2008-08-07 00:00:00 | Jurassic | 1 | TS242 | 399 | 400 | 4 | 4.5 | 0
2008-09-26 00:00:00 | Jurassic | 1 | TS279 | 406 | 405 | 4 | 4.75 | 1
2008-09-29 00:00:00 | Jurassic | 1 | TS280 | 426 | 426 | 12 | 5 | 2
2008-09-30 00:00:00 | Jurassic | 1 | [NAME] | 423 | 423 | 1 | 6 | 3
2008-10-01 00:00:00 | Jurassic | 1 | TS282 | 424 | 430 | 7 | 4.25 | 4
2008-10-02 00:00:00 | Jurassic | 1 | TS283 | 425 | 427 | 4 | 5.5 | 5
2008-11-21 00:00:00 | Jurassic | 1 | TS321 | 107 | 107 | 1 | 8.75 | 5
2008-11-24 00:00:00 | Jurassic | 1 | TS322 | 474 | 473 | 24 | 20.5 | 5
2008-11-25 00:00:00 | Jurassic | 1 | TS323 | 366 | 363 | 16 | 10 | 5
2008-11-26 00:00:00 | Jurassic | 1 | TS324 | 375 | 371 | 5 | 9 | 5
2008-11-27 00:00:00 | Jurassic | 1 | TS325 | 364 | 366 | 15 | 5.25 | 5
2008-11-28 00:00:00 | Jurassic | 1 | TS326 | 393 | 391 | 10 | 6.5 | 5
2009-01-20 00:00:00 | Jurassic | 1 | TS368 | 153 | 162 | 10 | 18.25 | 5
2009-01-21 00:00:00 | Jurassic | 1 | TS369 | 389 | 387 | 4 | 22.25 | 5
2009-01-22 00:00:00 | Jurassic | 1 | TS370 | 398 | 399 | 9 | 14.5 | 5
2009-01-23 00:00:00 | Jurassic | 1 | TS371 | 388 | 388 | 5 | 14.5 | 5
2009-01-26 00:00:00 | Jurassic | 1 | TS372 | 524 | 499 | 39 | 8 | 5
2009-01-27 00:00:00 | Jurassic | 1 | TS373 | 389 | 383 | 6 | 13.5 | 5
2008-07-24 00:00:00 | Jurassic | 2 | TS231 | 138 | 138 | 4 | 2.25 | 5
2008-07-25 00:00:00 | Jurassic | 2 | TS232 | 137 | 137 | 3 | 4.25 | 5
2008-07-28 00:00:00 | Jurassic | 2 | [NAME] | 367 | 364 | 9 | 7 | 5
2008-07-29 00:00:00 | Jurassic | 2 | TS235 | 409 | 407 | 3 | 3.5 | 5
2008-07-30 00:00:00 | Jurassic | 2 | [NAME] | 448 | 448 | 1 | 4.5 | 5
2008-07-31 00:00:00 | Jurassic | 2 | TS237 | 410 | 409 | 3 | 3.75 | 5
2008-09-19 00:00:00 | Jurassic | 2 | TS274 | 362 | 359 | 4 | 4.75 | 5
2008-09-22 00:00:00 | Jurassic | 2 | TS275 | 534 | 520 | 6 | 10.75 | 5
2008-09-23 00:00:00 | Jurassic | 2 | TS276 | 479 | 481 | 7 | 4 | 5
2008-09-24 00:00:00 | Jurassic | 2 | TS277 | 293 | 289 | 1 | 1 | 5
2008-09-25 00:00:00 | Jurassic | 2 | TS278 | 384 | 384 | 5 | 7 | 5
2008-11-14 00:00:00 | Jurassic | 2 | TS315 | 386 | 388 | 1 | 6.5 | 5
2008-11-17 00:00:00 | Jurassic | 2 | TS316 | 511 | 507 | 14 | 14.25 | 5
2008-11-18 00:00:00 | Jurassic | 2 | TS317 | 381 | 379 | 0 | 10.25 | 5
2008-11-19 00:00:00 | Jurassic | 2 | TS318 | 368 | 368 | 7 | 8.5 | 5
2008-11-20 00:00:00 | Jurassic | 2 | TS319 | 359 | 359 | 4 | 10.75 | 5
2008-11-21 00:00:00 | Jurassic | 2 | TS320 | 120 | 119 | 2 | 7.5 | 5
2009-01-13 00:00:00 | Jurassic | 2 | TS362 | 290 | 287 | 9 | 33.25 | 5
2009-01-14 00:00:00 | Jurassic | 2 | TS363 | 409 | 408 | 2 | 5.75 | 5
2009-01-15 00:00:00 | Jurassic | 2 | TS364 | 416 | 416 | 4 | 19.25 | 5
2009-01-16 00:00:00 | Jurassic | 2 | TS365 | 404 | 404 | 18 | 23.75 | 5
2009-01-19 00:00:00 | Jurassic | 2 | TS366 | 539 | 532 | 8 | 28.5 | 5
2009-01-20 00:00:00 | Jurassic | 2 | TS367 | 62 | 62 | 0 | 2.75 | 5
2008-07-11 00:00:00 | Jurassic | 3 | TS221 | 381 | 384 | 0 | 0.5 | 5
2008-07-14 00:00:00 | Jurassic | 3 | TS222 | 463 | 464 | 10 | 6 | 5
2008-07-15 00:00:00 | Jurassic | 3 | TS223 | 406 | 404 | 2 | 5.5 | 5
2008-07-16 00:00:00 | Jurassic | 3 | TS224 | 402 | 398 | 6 | 5.5 | 5
2008-07-17 00:00:00 | Jurassic | 3 | TS225 | 413 | 408 | 5 | 5 | 5
2008-09-05 00:00:00 | Jurassic | 3 | TS263 | 389 | 387 | 4 | 5.25 | 5
2008-09-08 00:00:00 | Jurassic | 3 | TS264 | 517 | 517 | 6 | 14 | 5
2008-09-09 00:00:00 | Jurassic | 3 | TS265 | 414 | 415 | 4 | 4.75 | 5
2008-09-10 00:00:00 | Jurassic | 3 | TS266 | 389 | 390 | 5 | 5 | 5
2008-09-11 00:00:00 | Jurassic | 3 | TS267 | 509 | 510 | 2 | 7 | 5
2008-09-12 00:00:00 | Jurassic | 3 | TS268 | 44 | 44 | 0 | 1 | 5
2008-10-31 00:00:00 | Jurassic | 3 | TS305 | 400 | 401 | 14 | 11.5 | 5
2008-11-03 00:00:00 | Jurassic | 3 | TS306 | 413 | 412 | 7 | 10.75 | 5
2008-11-04 00:00:00 | Jurassic | 3 | TS307 | 508 | 509 | 4 | 6 | 5
2008-11-05 00:00:00 | Jurassic | 3 | TS308 | 384 | 384 | 1 | 5.5 | 5
2008-11-06 00:00:00 | Jurassic | 3 | TS309 | 391 | 391 | 0 | 7.25 | 5
2008-12-30 00:00:00 | Jurassic | 3 | TS351 | 417 | 415 | 10 | 22.5 | 5
2008-12-31 00:00:00 | Jurassic | 3 | TS352 | 623 | 622 | 14 | 7 | 5
2009-01-02 00:00:00 | Jurassic | 3 | TS353 | 557 | 557 | 3 | 10.5 | 5
2009-01-05 00:00:00 | Jurassic | 3 | TS354 | 544 | 541 | 28 | 25.5 | 5
2009-01-06 00:00:00 | Jurassic | 3 | TS356 | 40 | 40 | 0 | 1.25 | 5
2008-07-18 00:00:00 | Jurassic | 4 | TS226 | 412 | 409 | 0 | 1.5 | 5
2008-07-21 00:00:00 | Jurassic | 4 | TS227 | 450 | 451 | 1 | 2.75 | 5
2008-07-22 00:00:00 | Jurassic | 4 | TS228 | 389 | 389 | 0 | 1.75 | 5
2008-07-23 00:00:00 | Jurassic | 4 | [NAME] | 418 | 416 | 0 | 4.5 | 5
2008-07-24 00:00:00 | Jurassic | 4 | TS230 | 127 | 127 | 2 | 1.5 | 5
2008-07-25 00:00:00 | Jurassic | 4 | TS233 | 180 | 177 | 2 | 0.75 | 5
2008-09-12 00:00:00 | Jurassic | 4 | TS269 | 86 | 88 | 4 | 10.25 | 5
2008-09-15 00:00:00 | Jurassic | 4 | TS270 | 459 | 463 | 14 | 13.5 | 5
2008-09-16 00:00:00 | Jurassic | 4 | TS271 | 372 | 369 | 3 | 10.25 | 5
2008-09-17 00:00:00 | Jurassic | 4 | [NAME] | 545 | 546 | 6 | 8.75 | 5
2008-09-18 00:00:00 | Jurassic | 4 | TS273 | 443 | 444 | 3 | 9 | 5
2008-11-07 00:00:00 | Jurassic | 4 | TS310 | 457 | 457 | 0 | 8.75 | 5
2008-11-10 00:00:00 | Jurassic | 4 | TS311 | 514 | 495 | 6 | 13.5 | 5
2008-11-11 00:00:00 | Jurassic | 4 | TS312 | 379 | 381 | 1 | 6 | 5
2008-11-12 00:00:00 | Jurassic | 4 | TS313 | 380 | 378 | 6 | 3.5 | 5
2008-11-13 00:00:00 | Jurassic | 4 | TS314 | 383 | 383 | 5 | 2.5 | 5
2009-01-06 00:00:00 | Jurassic | 4 | TS355 | 203 | 205 | 2 | 7.5 | 5
2009-01-07 00:00:00 | Jurassic | 4 | TS357 | 654 | 655 | 25 | 22 | 5
2009-01-08 00:00:00 | Jurassic | 4 | TS358 | 392 | 395 | 8 | 5.75 | 5
2009-01-09 00:00:00 | Jurassic | 4 | TS359 | 305 | 301 | 5 | 18.75 | 5
2009-01-12 00:00:00 | Jurassic | 4 | TS360 | 497 | 497 | 21 | 27 | 5
2009-01-13 00:00:00 | Jurassic | 4 | TS361 | 106 | 106 | 0 | 3.5 | 5
2008-08-08 00:00:00 | Jurassic | 5 | TS243 | 448 | 448 | 3 | 5.75 | 5
2008-08-11 00:00:00 | Jurassic | 5 | TS244 | 414 | 414 | 8 | 2.5 | 5
2008-08-12 00:00:00 | Jurassic | 5 | TS245 | 361 | 360 | 4 | 3.25 | 5
2008-08-13 00:00:00 | Jurassic | 5 | TS246 | 438 | 437 | 7 | 4 | 5
2008-08-14 00:00:00 | Jurassic | 5 | TS247 | 328 | 326 | 4 | 5 | 5
2008-10-03 00:00:00 | Jurassic | 5 | TS284 | 425 | 424 | 5 | 10.25 | 5
2008-10-06 00:00:00 | Jurassic | 5 | TS285 | 448 | 448 | 8 | 7.5 | 5
2008-10-07 00:00:00 | Jurassic | 5 | [NAME] | 408 | 408 | 2 | 8.5 | 5
2008-10-08 00:00:00 | Jurassic | 5 | TS287 | 397 | 397 | 4 | 6 | 5
2008-10-09 00:00:00 | Jurassic | 5 | TS288 | 400 | 401 | 2 | 4.5 | 5
2008-12-01 00:00:00 | Jurassic | 5 | TS327 | 499 | 496 | 36 | 19 | 5
2008-12-02 00:00:00 | Jurassic | 5 | TS328 | 358 | 364 | 21 | 13 | 5
2008-12-03 00:00:00 | Jurassic | 5 | TS329 | 356 | 356 | 3 | 4.75 | 5
2008-12-04 00:00:00 | Jurassic | 5 | TS330 | 385 | 384 | 3 | 6.25 | 5
2008-12-05 00:00:00 | Jurassic | 5 | TS331 | 344 | 346 | 11 | 7.75 | 5
2008-12-08 00:00:00 | Jurassic | 5 | [NAME] | 104 | 107 | 6 | 9 | 5
2009-01-28 00:00:00 | Jurassic | 5 | TS374 | 342 | 342 | 12 | 12 | 5
2009-01-29 00:00:00 | Jurassic | 5 | TS375 | 589 | 591 | 24 | 14.75 | 5
2009-01-30 00:00:00 | Jurassic | 5 | TS376 | 364 | 375 | 12 | 10.5 | 5
2008-08-15 00:00:00 | Jurassic | 6 | TS248 | 439 | 439 | 6 | 5.75 | 5
2008-08-18 00:00:00 | Jurassic | 6 | TS249 | 362 | 356 | 7 | 1.75 | 5
2008-08-19 00:00:00 | Jurassic | 6 | TS250 | 410 | 411 | 3 | 2 | 5
2008-08-20 00:00:00 | Jurassic | 6 | [NAME] | 432 | 432 | 3 | 2.75 | 5
2008-08-21 00:00:00 | Jurassic | 6 | TS252 | 443 | 446 | 3 | 2 | 5
2008-10-10 00:00:00 | Jurassic | 6 | TS289 | 400 | 399 | 1 | 4.25 | 5
2008-10-13 00:00:00 | Jurassic | 6 | TS290 | 427 | 415 | 8 | 3.25 | 5
2008-10-14 00:00:00 | Jurassic | 6 | TS291 | 427 | 428 | 3 | 1.75 | 5
2008-10-15 00:00:00 | Jurassic | 6 | TS292 | 468 | 468 | 4 | 3 | 5
2008-10-16 00:00:00 | Jurassic | 6 | TS293 | 343 | 343 | 0 | 5.25 | 5
2008-12-08 00:00:00 | Jurassic | 6 | TS333 | 238 | 242 | 25 | 7 | 5
2008-12-09 00:00:00 | Jurassic | 6 | TS334 | 380 | 380 | 7 | 4.5 | 5
2008-12-10 00:00:00 | Jurassic | 6 | TS335 | 358 | 358 | 4 | 2.75 | 5
2008-12-11 00:00:00 | Jurassic | 6 | TS336 | 399 | 399 | 8 | 6.75 | 5
2008-12-12 00:00:00 | Jurassic | 6 | TS337 | 360 | 360 | 4 | 7.25 | 5
2008-12-15 00:00:00 | Jurassic | 6 | TS338 | 333 | 334 | 27 | 10.5 | 5
2008-07-01 00:00:00 | Jurassic | 7 | TS211 | 366 | 366 | 3 | 2.5 | 5
2008-07-02 00:00:00 | Jurassic | 7 | TS212 | 346 | 345 | 4 | 2.75 | 5
2008-07-03 00:00:00 | Jurassic | 7 | [NAME] | 30 | 30 | 0 | 0.5 | 5
2008-07-04 00:00:00 | Jurassic | 7 | TS215 | 170 | 170 | 3 | 3.75 | 5
2008-08-22 00:00:00 | Jurassic | 7 | TS253 | 380 | 347 | 4 | 2.75 | 5
2008-08-25 00:00:00 | Jurassic | 7 | [NAME] | 498 | 494 | 6 | 10.75 | 5
2008-08-26 00:00:00 | Jurassic | 7 | TS255 | 337 | 338 | 6 | 2.5 | 5
2008-08-27 00:00:00 | Jurassic | 7 | TS256 | 379 | 381 | 3 | 1 | 5
2008-08-28 00:00:00 | Jurassic | 7 | TS257 | 414 | 409 | 2 | 5.75 | 5
2008-10-16 00:00:00 | Jurassic | 7 | TS294 | -66 | -66 | 2 | 0.75 | 5
2008-10-17 00:00:00 | Jurassic | 7 | TS295 | 410 | 409 | 6 | 4.25 | 5
2008-10-20 00:00:00 | Jurassic | 7 | TS296 | 411 | 399 | 10 | 5.25 | 5
2008-10-21 00:00:00 | Jurassic | 7 | TS297 | 421 | 421 | 5 | 5.75 | 5
2008-10-22 00:00:00 | Jurassic | 7 | [NAME] | 465 | 466 | 4 | 6.5 | 5
2008-10-23 00:00:00 | Jurassic | 7 | TS299 | 393 | 391 | 1 | 0.5 | 5
2008-12-15 00:00:00 | Jurassic | 7 | TS339 | 29 | 29 | 19 | 12 | 5
2008-12-16 00:00:00 | Jurassic | 7 | TS340 | 371 | 364 | 19 | 8.25 | 5
2008-12-17 00:00:00 | Jurassic | 7 | TS341 | 392 | 390 | 4 | 2 | 5
2008-12-18 00:00:00 | Jurassic | 7 | TS342 | 421 | 416 | 4 | 3.75 | 5
2008-12-19 00:00:00 | Jurassic | 7 | TS343 | 374 | 373 | 9 | 5 | 5
2008-12-22 00:00:00 | Jurassic | 7 | TS344 | 356 | 354 | 12 | 2.75 | 5
2008-07-03 00:00:00 | Jurassic | 8 | TS214 | 315 | 314 | 1 | 1.5 | 5
2008-07-04 00:00:00 | Jurassic | 8 | TS216 | 171 | 171 | 8 | 2.75 | 5
2008-07-07 00:00:00 | Jurassic | 8 | TS217 | 378 | 377 | 9 | 12.25 | 5
2008-07-08 00:00:00 | Jurassic | 8 | TS218 | 388 | 387 | 1 | 2.25 | 5
2008-07-09 00:00:00 | Jurassic | 8 | TS219 | 392 | 383 | 2 | 2.25 | 5
2008-07-10 00:00:00 | Jurassic | 8 | TS220 | 404 | 407 | 4 | 2.25 | 5
2008-08-29 00:00:00 | Jurassic | 8 | TS258 | 412 | 412 | 1 | 6.5 | 5
2008-09-01 00:00:00 | Jurassic | 8 | TS259 | 470 | 468 | 11 | 9.25 | 5
2008-09-02 00:00:00 | Jurassic | 8 | TS260 | 402 | 400 | 2 | 4.25 | 5
2008-09-03 00:00:00 | Jurassic | 8 | TS261 | 404 | 405 | 7 | 5.25 | 5
2008-09-04 00:00:00 | Jurassic | 8 | TS262 | 415 | 413 | 6 | 4.25 | 5
2008-10-24 00:00:00 | Jurassic | 8 | [NAME] | 374 | 373 | 4 | 5 | 5
2008-10-27 00:00:00 | Jurassic | 8 | TS301 | 458 | 452 | 10 | 7 | 5
2008-10-28 00:00:00 | Jurassic | 8 | [NAME] | 400 | 399 | 6 | 5.75 | 5
2008-10-29 00:00:00 | Jurassic | 8 | TS303 | 466 | 463 | 6 | 4.5 | 5
2008-10-30 00:00:00 | Jurassic | 8 | TS304 | 392 | 392 | 3 | 7.5 | 5
2008-12-22 00:00:00 | Jurassic | 8 | TS345 | 60 | 60 | 8 | 5.25 | 5
2008-12-23 00:00:00 | Jurassic | 8 | TS346 | 399 | 396 | 16 | 16.75 | 5
2008-12-24 00:00:00 | Jurassic | 8 | [NAME] | 382 | 383 | 1 | 4.5 | 5
2008-12-26 00:00:00 | Jurassic | 8 | TS348 | 478 | 481 | 1 | 10.5 | 5
2008-12-29 00:00:00 | Jurassic | 8 | [NAME] | 611 | 611 | 20 | 20.75 | 5
2008-12-30 00:00:00 | Jurassic | 8 | TS350 | 134 | 134 | 4 | 3 | 5