Spreadsheet: 697969d1601648958-finding-last-non-blank-cell-for-a-formula-reference-root729-formula-sheet
Sheet: SALES

OrderID | Order Date | Item cost | Sale Price | Ebay fee | Ebay promo | Paypal fee | Post | Total cost | profit | Cash in | Profit % |  | Day Sales | Day Cost | Day Profit | Day Profit % | Week Sales | Week Cost | Week Profit | Week Profit %
31350 | 2020-09-29 00:00:00 | 0.22 | 2.5 | 0.3 | 0 | 0.3725 | 0.8
31351 | 2020-09-29 00:00:00 | 1.1 | 3.99 | 0.4788 | 0.04788000000000001 | 0.41571 | 0.8
31352 | 2020-09-29 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0 | 0.4305 | 0.8
31353 | 2020-09-29 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0 | 0.4305 | 0.8
31354 | 2020-09-29 00:00:00 | 0.285 | 2.35 | 0.282 | 0 | 0.36815 | 0.8
31355 | 2020-09-29 00:00:00 | 9 | 21.99 | 2.6388 | 0 | 0.93771 | 0.8
31356 | 2020-09-29 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0.054 | 0.4305 | 0.8
31357 | 2020-09-29 00:00:00 | 1.358467634647021 | 13.17 | 1.5804 | 0 | 0.6819299999999999 | 0.8
31358 | 2020-09-29 00:00:00 | 0.8750000000000002 | 3.99 | 0.4788 | 0 | 0.41571 | 0.8
31359 | 2020-09-29 00:00:00 | 9 | 21.99 | 2.6388 | 0.2638799999999999 | 0.93771 | 0.8
31360 | 2020-09-29 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0 | 0.4305 | 0.8
31361 | 2020-09-29 00:00:00 | 3.3 | 13.99 | 1.6788 | 0 | 0.77566 | 4
31362 | 2020-09-29 00:00:00 | 5.942691531332069 | 13.49 | 1.6188 | 0 | 0.69121 | 3.2
31363 | 2020-09-29 00:00:00 | 1.132056362205851 | 17.09 | 2.0508 | 0 | 0.88106 | 9
31364 | 2020-09-29 00:00:00 | 1.132056362205851 | 8.1 | 0.972 | 0.0972 | 0.5348999999999999 | 0.8
31365 | 2020-09-29 00:00:00 | 7 | 21.99 | 2.6388 | 0 | 0.93771 | 3.2
31366 | 2020-09-29 00:00:00 | 2.338036008796041 | 14.98 | 1.7976 | 0.17976 | 0.80932 | 9
31367 | 2020-09-29 00:00:00 | 1.132056362205851 | 13.49 | 1.6188 | 0.16188 | 0.7586600000000001 | 9
31368 | 2020-09-29 00:00:00 | 1.1 | 3.99 | 0.4788 | 0 | 0.41571 | 2.4
31369 | 2020-09-29 00:00:00 | 0.2 | 3.88 | 0.4656 | 0 | 0.41252 | 0.8
31370 | 2020-09-29 00:00:00 | 1.1 | 7.34 | 0.8807999999999999 | 0.08808 | 0.51286 | 0.8
31371 | 2020-09-29 00:00:00 | 5.942691531332069 | 25.9 | 3.108 | 0 | 1.0511 | 0.8
31372 | 2020-09-29 00:00:00 | 9 | 53.48 | 6.417599999999999 | 0 | 2.11832 | 4
31373 | 2020-09-29 00:00:00 | 5.942691531332069 | 25.9 | 3.108 | 0 | 1.0511 | 0.8
31374 | 2020-09-29 00:00:00 | 1.46 | 1.99 | 0.2388 | 0 | 0.35771 | 0.8
31375 | 2020-09-29 00:00:00 | 1.68 | 3.99 | 0.4788 | 0 | 0.41571 | 0.8
31376 | 2020-09-29 00:00:00 | 7 | 21.99 | 2.6388 | 0 | 0.93771 | 0.8
31377 | 2020-09-29 00:00:00 | 0.9781200000000001 | 7.562100000000001 | 0.907452 | 0 | 0.5571114 | 4
31378 | 2020-09-29 00:00:00 | 9 | 25.49 | 3.0588 | 0 | 1.16666 | 4
31379 | 2020-09-29 00:00:00 | 0.57 | 3.99 | 0.4788 | 0 | 0.41571 | 0.8
31380 | 2020-09-29 00:00:00 | 9 | 28.49 | 3.4188 | 0.34188 | 1.26866 | 4
31381 | 2020-09-29 00:00:00 | 0 | 13.98 | 1.6776 | 0 | 0.77532 | 4
31382 | 2020-09-30 00:00:00 | 5.942691531332069 | 13.49 | 1.6188 | 0 | 0.69121 | 0.8
31383 | 2020-09-30 00:00:00 | 0 | 162.96 | 19.5552 | 0 | 5.84064 | 4
31384 | 2020-09-30 00:00:00 | 26.18229312354999 | 0 | 0 | 0 | 0 | 0
31385 | 2020-09-30 00:00:00 | 31.43597694110442 | 0 | 0 | 0 | 0 | 0
31386 | 2020-09-30 00:00:00 | 2.2 | 5.99 | 0.7188 | 0 | 0.47371 | 0.8
31387 | 2020-09-30 00:00:00 | 1.358467634647021 | 4.99 | 0.5988 | 0 | 0.44471 | 0.8
31388 | 2020-09-30 00:00:00 | 0 | 19.44 | 2.3328 | 0 | 0.8637600000000001 | 0.8
31389 | 2020-09-30 00:00:00 | 4.3 | 0 | 0 | 0 | 0 | 0
31390 | 2020-09-30 00:00:00 | 4.75 | 0 | 0 | 0 | 0 | 0
31391 | 2020-09-30 00:00:00 | 13.60790234710822 | 26.99 | 3.2388 | 0 | 1.08271 | 0.8
31392 | 2020-09-30 00:00:00 | 0.4375000000000001 | 6.2608 | 0.751296 | 0 | 0.5128672 | 4
31393 | 2020-09-30 00:00:00 | 13.60790234710822 | 51.58 | 6.1896 | 0 | 1.79582 | 1.5
31394 | 2020-09-30 00:00:00 | 0.56 | 5.98 | 0.7176 | 0 | 0.47342 | 0.8
31395 | 2020-09-30 00:00:00 | 9.04322624333141 | 27.98 | 3.3576 | 0 | 1.25132 | 9
31396 | 2020-09-30 00:00:00 | 9 | 21.99 | 2.6388 | 0 | 0.93771 | 3.2
31397 | 2020-09-30 00:00:00 | 3.9 | 15.49 | 1.8588 | 0 | 0.82666 | 4
31398 | 2020-09-30 00:00:00 | 7 | 21.99 | 2.6388 | 0 | 0.93771 | 0.8
31399 | 2020-09-30 00:00:00 | 4.3 | 9.45 | 1.134 | 0 | 0.57405 | 0.8
31400 | 2020-09-30 00:00:00 | 0.75 | 5.68 | 0.6816 | 0 | 0.46472 | 0.8
31401 | 2020-09-30 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0.054 | 0.4305 | 0.8
31402 | 2020-09-30 00:00:00 | 7 | 58.3128 | 6.997536 | 0 | 2.2826352 | 4
31403 | 2020-09-30 00:00:00 | 9.352144035184166 | 14.99 | 1.7988 | 0.17988 | 0.73471 | 0.8
31404 | 2020-09-30 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0.054 | 0.4305 | 0.8
31405 | 2020-09-30 00:00:00 | 2.2 | 5.99 | 0.7188 | 0 | 0.47371 | 0.8
31406 | 2020-10-01 00:00:00 | 9.352144035184166 | 14.99 | 1.7988 | 0 | 0.73471 | 0.8
31407 | 2020-10-01 00:00:00 | 5.942691531332069 | 13.49 | 1.6188 | 0 | 0.69121 | 0.8
31408 | 2020-10-01 00:00:00 | 0.75 | 2.99 | 0.3588 | 0 | 0.38671 | 3.2
31409 | 2020-10-01 00:00:00 | 1.1 | 5 | 0.6 | 0 | 0.445 | 0.8
31410 | 2020-10-01 00:00:00 | 1.1 | 3.99 | 0.4788 | 0 | 0.41571 | 2.4
31411 | 2020-10-01 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0.054 | 0.4305 | 0.8
31412 | 2020-10-01 00:00:00 | 7 | 21.99 | 2.6388 | 0 | 0.93771 | 0.8
31413 | 2020-10-01 00:00:00 | 3.65 | 8.99 | 1.0788 | 0 | 0.56071 | 0.8
31414 | 2020-10-01 00:00:00 | 4.4 | 9.99 | 1.1988 | 0.11988 | 0.58971 | 0.8
31415 | 2020-10-01 00:00:00 | 1.4 | 4.99 | 0.5988 | 0 | 0.44471 | 0.8
31416 | 2020-10-01 00:00:00 | 1.1 | 3.99 | 0.4788 | 0 | 0.41571 | 0.8
31417 | 2020-10-01 00:00:00 | 7 | 58.3128 | 6.997536 | 0 | 2.2826352 | 4
31418 | 2020-10-01 00:00:00 | 2.2 | 5.99 | 0.7188 | 0 | 0.47371 | 0.8
31419 | 2020-10-01 00:00:00 | 5.626941964285715 | 19.7379 | 2.368548 | 0 | 0.9710886000000001 | 4
31420 | 2020-10-01 00:00:00 | 1.1 | 3.99 | 0.4788 | 0.04788000000000001 | 0.41571 | 0.8
31421 | 2020-10-01 00:00:00 | 0.69 | 3.75 | 0.45 | 0 | 0.40875 | 0.8
31422 | 2020-10-01 00:00:00 | 1.358467634647021 | 4.99 | 0.5988 | 0 | 0.44471 | 0.8
31423 | 2020-10-01 00:00:00 | 2.2 | 5.99 | 0.7188 | 0 | 0.47371 | 0.8
31424 | 2020-10-01 00:00:00 | 9.8 | 20.99 | 2.5188 | 0 | 0.9087099999999999 | 0.8
31425 | 2020-10-01 00:00:00 | 1.358467634647021 | 4.99 | 0.5988 | 0 | 0.44471 | 0.8
31426 | 2020-10-01 00:00:00 | 1.402821605277625 | 8.48 | 1.0176 | 0 | 0.54592 | 0.8
31427 | 2020-10-02 00:00:00 | 9 | 21.99 | 2.6388 | 0 | 0.93771 | 3.2
31428 | 2020-10-02 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0 | 0.4305 | 3.2
31429 | 2020-10-02 00:00:00 | 8.526470457998187 | 17.29 | 2.0748 | 0 | 0.80141 | 1.5
31430 | 2020-10-02 00:00:00 | 1.1 | 3.99 | 0.4788 | 0.04788000000000001 | 0.41571 | 0.8
31431 | 2020-10-02 00:00:00 | 24.89040366021693 | 46.49 | 5.5788 | 0 | 1.88066 | 4
31432 | 2020-10-02 00:00:00 | 9 | 0 | 0 | 0 | 0.3 | 4
31433 | 2020-10-02 00:00:00 | 5.942691531332069 | 13.99 | 1.6788 | 0 | 0.7057100000000001 | 0.8
31434 | 2020-10-02 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0.054 | 0.4305 | 0.8
31435 | 2020-10-02 00:00:00 | 0.280564321055525 | 13.96 | 1.6752 | 0 | 0.77464 | 9
31436 | 2020-10-02 00:00:00 | 9 | 21.99 | 2.6388 | 0 | 0.93771 | 0.8
31437 | 2020-10-02 00:00:00 | 4.375000000000001 | 20.98 | 2.5176 | 0 | 1.01332 | 9
31438 | 2020-10-02 00:00:00 | 1.1 | 3.99 | 0.4788 | 0 | 0.41571 | 0.8
31439 | 2020-10-02 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0 | 0.4305 | 0.8
31440 | 2020-10-02 00:00:00 | 7 | 21.99 | 2.6388 | 0.2638799999999999 | 0.93771 | 0.8
31441 | 2020-10-02 00:00:00 | 13.60790234710822 | 230.76 | 27.6912 | 2.76912 | 6.99204 | 0.8
31442 | 2020-10-02 00:00:00 | 1.132056362205851 | 4.9 | 0.588 | 0.0588 | 0.4421 | 1.5
31443 | 2020-10-02 00:00:00 | 15.33042163155229 | 28.99 | 3.4788 | 0.34788 | 1.14071 | 0.8
31444 | 2020-10-02 00:00:00 | 1.402821605277625 | 4.99 | 0.5988 | 0 | 0.44471 | 0.8
31445 | 2020-10-02 00:00:00 | 0.3653858418367347 | 2.49 | 0.2988 | 0 | 0.37221 | 0.8
31446 | 2020-10-02 00:00:00 | 1.72 | 2.9 | 0.348 | 0.0348 | 0.3841 | 0.8
31447 | 2020-10-02 00:00:00 | 13.60790234710822 | 34.98 | 4.1976 | 0 | 1.48932 | 9
31448 | 2020-10-02 00:00:00 | 2.2 | 9.7006 | 1.164072 | 0 | 0.6298204000000001 | 4
31449 | 2020-10-02 00:00:00 | 8.526470457998187 | 22.1858 | 2.662296 | 0 | 1.0543172 | 4
31450 | 2020-10-02 00:00:00 | 26.18229312354999 | 54.98 | 6.597599999999999 | 0 | 2.16932 | 4
31451 | 2020-10-02 00:00:00 | 1.15 | 4.99 | 0.5988 | 0.05988 | 0.44471 | 0.8
31452 | 2020-10-02 00:00:00 | 5.942691531332069 | 26.86 | 3.2232 | 0 | 1.07894 | 2.4
31453 | 2020-10-02 00:00:00 | 13.60790234710822 | 26.99 | 3.2388 | 0.3238799999999999 | 1.08271 | 0.8
31454 | 2020-10-02 00:00:00 | 0.55 | 3.75 | 0.45 | 0 | 0.40875 | 0.8
31455 | 2020-10-02 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0 | 0.4305 | 0.8
31456 | 2020-10-02 00:00:00 | 2.2 | 8.5 | 1.02 | 0 | 0.5465 | 0.8
31457 | 2020-10-02 00:00:00 | 1.1 | 3.99 | 0.4788 | 0 | 0.41571 | 0.8
31458 | 2020-10-03 00:00:00 | 5.942691531332069 | 13.49 | 1.6188 | 0.16188 | 0.69121 | 3.2
31459 | 2020-10-03 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0.054 | 0.4305 | 0.8
31460 | 2020-10-03 00:00:00 | 14.46916198933026 | 26.5 | 3.18 | 0 | 1.0685 | 0.8
31461 | 2020-10-03 00:00:00 | 1.132056362205851 | 8.1 | 0.972 | 0 | 0.5348999999999999 | 3.2
31462 | 2020-10-03 00:00:00 | 8.526470457998187 | 21.9856 | 2.638272 | 0 | 1.0475104 | 4
31463 | 2020-10-03 00:00:00 | 15.33042163155229 | 36.98 | 4.4376 | 0 | 1.55732 | 9
31464 | 2020-10-03 00:00:00 | 0.26 | 3.96 | 0.4752 | 0 | 0.41484 | 0.8
31465 | 2020-10-03 00:00:00 | 1.358467634647021 | 4.99 | 0.5988 | 0 | 0.44471 | 0.8
31466 | 2020-10-03 00:00:00 | 0.11 | 0.99 | 0.1188 | 0 | 0.32871 | 0.8
31467 | 2020-10-03 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0.054 | 0.4305 | 0.8
31468 | 2020-10-03 00:00:00 | 1.132056362205851 | 4.5 | 0.54 | 0 | 0.4305 | 0.8
31469 | 2020-10-03 00:00:00 | 9.352144035184166 | 14.99 | 1.7988 | 0.17988 | 0.73471 | 0.8
31470 | 2020-10-03 00:00:00 | 18 | 78.38 | 9.4056 | 0.9405599999999998 | 2.57302 | 0.8
31471 | 2020-10-03 00:00:00 | 0.9642750000000001 | 6.3427 | 0.7611239999999999 | 0 | 0.5156518 | 4
31472 | 2020-10-03 00:00:00 | 5.942691531332069 | 13.99 | 1.6788 | 0 | 0.7057100000000001 | 0.8
31473 | 2020-10-04 00:00:00 | 0.28 | 12.5 | 1.5 | 0 | 0.7250000000000001 | 4
31474 | 2020-10-04 00:00:00 | 2.80564321055525 | 9.99 | 1.1988 | 0 | 0.63966 | 4
31475 | 2020-10-04 00:00:00 | 2.2 | 5.99 | 0.7188 | 0 | 0.47371 | 0.8
31476 | 2020-10-04 00:00:00 | 15.33042163155229 | 31.98 | 3.8376 | 0 | 1.38732 | 4
31477 | 2020-10-04 00:00:00 | 0.56 | 3.39 | 0.4068 | 0 | 0.39831 | 1.5
31478 | 2020-10-04 00:00:00 | 1.4 | 4.99 | 0.5988 | 0.05988 | 0.44471 | 0.8
31479 | 2020-10-04 00:00:00 | 9 | 21.99 | 2.6388 | 0 | 0.93771 | 0.8
31480 | 2020-10-04 00:00:00 | 7 | 21.99 | 2.6388 | 0.2638799999999999 | 0.93771 | 0.8
31481 | 2020-10-04 00:00:00 | 9.04322624333141 | 69.88 | 8.385599999999998 | 0.83856 | 2.32652 | 2.07
31482 | 2020-10-04 00:00:00 | 0.3288472576530613 | 5.49 | 0.6588 | 0 | 0.48666 | 4
31483 | 2020-10-04 00:00:00 | 2.2 | 5.99 | 0.7188 | 0 | 0.47371 | 0.8
31484 | 2020-10-04 00:00:00 | 2.2 | 5.99 | 0.7188 | 0 | 0.47371 | 0.8
31485 | 2020-10-04 00:00:00 | 9.04322624333141 | 18.99 | 2.2788 | 0.22788 | 0.8507100000000001 | 0.8
31486 | 2020-10-04 00:00:00 | 0.95 | 4.5 | 0.54 | 0 | 0.4305 | 0.8
31487 | 2020-10-04 00:00:00 | 24.89040366021693 | 42.99 | 5.1588 | 0 | 1.54671 | 0.8
31488 | 2020-10-04 00:00:00 | 13.60790234710822 | 26.99 | 3.2388 | 0 | 1.08271 | 0.8