Spreadsheet: 839876d1692276214-find-matching-price-when-date-between-price-changes-find-relevant-price-when-month-between-price-change-months
Sheet: Sheet1

Month | Product | Company | Qty | Cost |  | Unit Cost S/be |  |  |  | Product | Company | Effective | Cost
2012-01-01 00:00:00 | Product 1 | Company 1 | 998 |  |  | 9.88 |  |  |  | Product 1 | Company 1 | 2012-01-01 00:00:00 | 9.88
2012-02-01 00:00:00 | Product 1 | Company 1 | 930 |  |  | 9.88 |  |  |  | Product 1 | Company 2 | 2012-01-01 00:00:00 | 12.1524
2012-03-01 00:00:00 | Product 1 | Company 1 | 491 |  |  | 9.88 |  |  |  | Product 1 | Company 1 | 2013-04-01 00:00:00 | 10.08
2012-04-01 00:00:00 | Product 1 | Company 1 | 179 |  |  | 9.88 |  |  |  | Product 1 | Company 2 | 2013-04-01 00:00:00 | 11.088
2012-05-01 00:00:00 | Product 1 | Company 1 | 260 |  |  | 9.88 |  |  |  | Product 1 | Company 1 | 2014-05-01 00:00:00 | 10.6848
2012-06-01 00:00:00 | Product 1 | Company 1 | 533 |  |  | 9.88 |  |  |  | Product 1 | Company 2 | 2014-05-01 00:00:00 | 12.82176
2012-07-01 00:00:00 | Product 1 | Company 1 | 443 |  |  | 9.88 |  |  |  | Product 1 | Company 1 | 2015-06-01 00:00:00 | 11.21904
2012-08-01 00:00:00 | Product 1 | Company 1 | 146 |  |  | 9.88 |  |  |  | Product 1 | Company 2 | 2015-06-01 00:00:00 | 14.584752
2012-09-01 00:00:00 | Product 1 | Company 1 | 818 |  |  | 9.88 |  |  |  | Product 1 | Company 1 | 2016-03-01 00:00:00 | 11.1068496
2012-10-01 00:00:00 | Product 1 | Company 1 | 642 |  |  | 9.88 |  |  |  | Product 1 | Company 2 | 2016-03-01 00:00:00 | 14.43890448
2012-11-01 00:00:00 | Product 1 | Company 1 | 316 |  |  | 9.88 |  |  |  | Product 1 | Company 1 | 2017-12-01 00:00:00 | 11.440055088
2012-12-01 00:00:00 | Product 1 | Company 1 | 894 |  |  | 9.88 |  |  |  | Product 1 | Company 2 | 2017-12-01 00:00:00 | 17.160082632
2013-01-01 00:00:00 | Product 1 | Company 1 | 612 |  |  | 9.88 |  |  |  | Product 1 | Company 1 | 2018-05-01 00:00:00 | 12.5840605968
2013-02-01 00:00:00 | Product 1 | Company 1 | 592 |  |  | 9.88 |  |  |  | Product 1 | Company 2 | 2018-05-01 00:00:00 | 15.10087271616
2013-03-01 00:00:00 | Product 1 | Company 1 | 163 |  |  | 9.88 |  |  |  | Product 1 | Company 1 | 2019-06-01 00:00:00 | 13.087423020672
2013-04-01 00:00:00 | Product 1 | Company 1 | 718 |  |  | 10.08 |  |  |  | Product 1 | Company 2 | 2019-06-01 00:00:00 | 14.3961653227392
2013-05-01 00:00:00 | Product 1 | Company 1 | 306 |  |  | 10.08 |  |  |  | Product 1 | Company 1 | 2020-01-01 00:00:00 | 14.3961653227392
2013-06-01 00:00:00 | Product 1 | Company 1 | 232 |  |  | 10.08 |  |  |  | Product 1 | Company 2 | 2020-01-01 00:00:00 | 21.5942479841088
2013-07-01 00:00:00 | Product 1 | Company 1 | 679 |  |  | 10.08 |  |  |  | Product 1 | Company 1 | 2021-01-01 00:00:00 | 16.1237051614679
2013-08-01 00:00:00 | Product 1 | Company 1 | 321 |  |  | 10.08 |  |  |  | Product 1 | Company 2 | 2021-01-01 00:00:00 | 19.34844619376148
2013-09-01 00:00:00 | Product 1 | Company 1 | 335 |  |  | 10.08 |  |  |  | Product 1 | Company 1 | 2022-05-01 00:00:00 | 15.31751990339451
2013-10-01 00:00:00 | Product 1 | Company 1 | 964 |  |  | 10.08 |  |  |  | Product 1 | Company 2 | 2022-05-01 00:00:00 | 22.97627985509176
2013-11-01 00:00:00 | Product 1 | Company 1 | 596 |  |  | 10.08
2013-12-01 00:00:00 | Product 1 | Company 1 | 772 |  |  | 10.08
2014-01-01 00:00:00 | Product 1 | Company 1 | 953 |  |  | 10.08
2014-02-01 00:00:00 | Product 1 | Company 1 | 607 |  |  | 10.08
2014-03-01 00:00:00 | Product 1 | Company 1 | 594 |  |  | 10.08
2014-04-01 00:00:00 | Product 1 | Company 1 | 819 |  |  | 10.08
2014-05-01 00:00:00 | Product 1 | Company 1 | 701 |  |  | 10.6848
2014-06-01 00:00:00 | Product 1 | Company 1 | 222 |  |  | 10.6848
2014-07-01 00:00:00 | Product 1 | Company 1 | 151 |  |  | 10.6848
2014-08-01 00:00:00 | Product 1 | Company 1 | 221 |  |  | 10.6848
2014-09-01 00:00:00 | Product 1 | Company 1 | 659 |  |  | 10.6848
2014-10-01 00:00:00 | Product 1 | Company 1 | 696 |  |  | 10.6848
2014-11-01 00:00:00 | Product 1 | Company 1 | 654 |  |  | 10.6848
2014-12-01 00:00:00 | Product 1 | Company 1 | 333 |  |  | 10.6848
2015-01-01 00:00:00 | Product 1 | Company 1 | 162 |  |  | 10.6848
2015-02-01 00:00:00 | Product 1 | Company 1 | 422 |  |  | 10.6848
2015-03-01 00:00:00 | Product 1 | Company 1 | 132 |  |  | 10.6848
2015-04-01 00:00:00 | Product 1 | Company 1 | 305 |  |  | 10.6848
2015-05-01 00:00:00 | Product 1 | Company 1 | 930 |  |  | 10.6848
2015-06-01 00:00:00 | Product 1 | Company 1 | 962 |  |  | 11.21904
2015-07-01 00:00:00 | Product 1 | Company 1 | 531 |  |  | 11.21904
2015-08-01 00:00:00 | Product 1 | Company 1 | 731 |  |  | 11.21904
2015-09-01 00:00:00 | Product 1 | Company 1 | 789 |  |  | 11.21904
2015-10-01 00:00:00 | Product 1 | Company 1 | 504 |  |  | 11.21904
2015-11-01 00:00:00 | Product 1 | Company 1 | 191 |  |  | 11.21904
2015-12-01 00:00:00 | Product 1 | Company 1 | 477 |  |  | 11.21904
2016-01-01 00:00:00 | Product 1 | Company 1 | 244 |  |  | 11.21904
2016-02-01 00:00:00 | Product 1 | Company 1 | 831 |  |  | 11.21904
2016-03-01 00:00:00 | Product 1 | Company 1 | 925 |  |  | 11.1068496
2016-04-01 00:00:00 | Product 1 | Company 1 | 852 |  |  | 11.1068496
2016-05-01 00:00:00 | Product 1 | Company 1 | 514 |  |  | 11.1068496
2016-06-01 00:00:00 | Product 1 | Company 1 | 929 |  |  | 11.1068496
2016-07-01 00:00:00 | Product 1 | Company 1 | 683 |  |  | 11.1068496
2016-08-01 00:00:00 | Product 1 | Company 1 | 886 |  |  | 11.1068496
2016-09-01 00:00:00 | Product 1 | Company 1 | 371 |  |  | 11.1068496
2016-10-01 00:00:00 | Product 1 | Company 1 | 385 |  |  | 11.1068496
2016-11-01 00:00:00 | Product 1 | Company 1 | 710 |  |  | 11.1068496
2016-12-01 00:00:00 | Product 1 | Company 1 | 919 |  |  | 11.1068496
2017-01-01 00:00:00 | Product 1 | Company 1 | 333 |  |  | 11.1068496
2017-02-01 00:00:00 | Product 1 | Company 1 | 133 |  |  | 11.1068496
2017-03-01 00:00:00 | Product 1 | Company 1 | 665 |  |  | 11.1068496
2017-04-01 00:00:00 | Product 1 | Company 1 | 676 |  |  | 11.1068496
2017-05-01 00:00:00 | Product 1 | Company 1 | 372 |  |  | 11.1068496
2017-06-01 00:00:00 | Product 1 | Company 1 | 834 |  |  | 11.1068496
2017-07-01 00:00:00 | Product 1 | Company 1 | 876 |  |  | 11.1068496
2017-08-01 00:00:00 | Product 1 | Company 1 | 831 |  |  | 11.1068496
2017-09-01 00:00:00 | Product 1 | Company 1 | 235 |  |  | 11.1068496
2017-10-01 00:00:00 | Product 1 | Company 1 | 694 |  |  | 11.1068496
2017-11-01 00:00:00 | Product 1 | Company 1 | 894 |  |  | 11.1068496
2017-12-01 00:00:00 | Product 1 | Company 1 | 264 |  |  | 11.440055088
2018-01-01 00:00:00 | Product 1 | Company 1 | 132 |  |  | 11.440055088
2018-02-01 00:00:00 | Product 1 | Company 1 | 664 |  |  | 11.440055088
2018-03-01 00:00:00 | Product 1 | Company 1 | 969 |  |  | 11.440055088
2018-04-01 00:00:00 | Product 1 | Company 1 | 900 |  |  | 11.440055088
2018-05-01 00:00:00 | Product 1 | Company 1 | 385 |  |  | 12.5840605968
2018-06-01 00:00:00 | Product 1 | Company 1 | 144 |  |  | 12.5840605968
2018-07-01 00:00:00 | Product 1 | Company 1 | 913 |  |  | 12.5840605968
2018-08-01 00:00:00 | Product 1 | Company 1 | 633 |  |  | 12.5840605968
2018-09-01 00:00:00 | Product 1 | Company 1 | 304 |  |  | 12.5840605968
2018-10-01 00:00:00 | Product 1 | Company 1 | 311 |  |  | 12.5840605968
2018-11-01 00:00:00 | Product 1 | Company 1 | 354 |  |  | 12.5840605968
2018-12-01 00:00:00 | Product 1 | Company 1 | 628 |  |  | 12.5840605968
2019-01-01 00:00:00 | Product 1 | Company 1 | 722 |  |  | 12.5840605968
2019-02-01 00:00:00 | Product 1 | Company 1 | 650 |  |  | 12.5840605968
2019-03-01 00:00:00 | Product 1 | Company 1 | 521 |  |  | 12.5840605968
2019-04-01 00:00:00 | Product 1 | Company 1 | 937 |  |  | 12.5840605968
2019-05-01 00:00:00 | Product 1 | Company 1 | 296 |  |  | 12.5840605968
2019-06-01 00:00:00 | Product 1 | Company 1 | 904 |  |  | 13.087423020672
2019-07-01 00:00:00 | Product 1 | Company 1 | 916 |  |  | 13.087423020672
2019-08-01 00:00:00 | Product 1 | Company 1 | 123 |  |  | 13.087423020672
2019-09-01 00:00:00 | Product 1 | Company 1 | 742 |  |  | 13.087423020672
2019-10-01 00:00:00 | Product 1 | Company 1 | 517 |  |  | 13.087423020672
2019-11-01 00:00:00 | Product 1 | Company 1 | 256 |  |  | 13.087423020672
2019-12-01 00:00:00 | Product 1 | Company 1 | 233 |  |  | 13.087423020672
2020-01-01 00:00:00 | Product 1 | Company 1 | 408 |  |  | 14.3961653227392
2020-02-01 00:00:00 | Product 1 | Company 1 | 217 |  |  | 14.3961653227392
2020-03-01 00:00:00 | Product 1 | Company 1 | 752 |  |  | 14.3961653227392
2020-04-01 00:00:00 | Product 1 | Company 1 | 806 |  |  | 14.3961653227392
2020-05-01 00:00:00 | Product 1 | Company 1 | 930 |  |  | 14.3961653227392
2020-06-01 00:00:00 | Product 1 | Company 1 | 238 |  |  | 14.3961653227392
2020-07-01 00:00:00 | Product 1 | Company 1 | 166 |  |  | 14.3961653227392
2020-08-01 00:00:00 | Product 1 | Company 1 | 223 |  |  | 14.3961653227392
2020-09-01 00:00:00 | Product 1 | Company 1 | 599 |  |  | 14.3961653227392
2020-10-01 00:00:00 | Product 1 | Company 1 | 738 |  |  | 14.3961653227392
2020-11-01 00:00:00 | Product 1 | Company 1 | 503 |  |  | 14.3961653227392
2020-12-01 00:00:00 | Product 1 | Company 1 | 675 |  |  | 14.3961653227392
2021-01-01 00:00:00 | Product 1 | Company 1 | 908 |  |  | 16.1237051614679
2021-02-01 00:00:00 | Product 1 | Company 1 | 594 |  |  | 16.1237051614679
2021-03-01 00:00:00 | Product 1 | Company 1 | 411 |  |  | 16.1237051614679
2021-04-01 00:00:00 | Product 1 | Company 1 | 315 |  |  | 16.1237051614679
2021-05-01 00:00:00 | Product 1 | Company 1 | 110 |  |  | 16.1237051614679
2021-06-01 00:00:00 | Product 1 | Company 1 | 497 |  |  | 16.1237051614679
2021-07-01 00:00:00 | Product 1 | Company 1 | 671 |  |  | 16.1237051614679
2021-08-01 00:00:00 | Product 1 | Company 1 | 513 |  |  | 16.1237051614679
2021-09-01 00:00:00 | Product 1 | Company 1 | 272 |  |  | 16.1237051614679
2021-10-01 00:00:00 | Product 1 | Company 1 | 716 |  |  | 16.1237051614679
2021-11-01 00:00:00 | Product 1 | Company 1 | 961 |  |  | 16.1237051614679
2021-12-01 00:00:00 | Product 1 | Company 1 | 423 |  |  | 16.1237051614679
2022-01-01 00:00:00 | Product 1 | Company 1 | 866 |  |  | 16.1237051614679
2022-02-01 00:00:00 | Product 1 | Company 1 | 182 |  |  | 16.1237051614679
2022-03-01 00:00:00 | Product 1 | Company 1 | 546 |  |  | 16.1237051614679
2022-04-01 00:00:00 | Product 1 | Company 1 | 816 |  |  | 16.1237051614679
2022-05-01 00:00:00 | Product 1 | Company 1 | 178 |  |  | 15.31751990339451
2022-06-01 00:00:00 | Product 1 | Company 1 | 854 |  |  | 15.31751990339451
2022-07-01 00:00:00 | Product 1 | Company 1 | 755 |  |  | 15.31751990339451
2022-08-01 00:00:00 | Product 1 | Company 1 | 740 |  |  | 15.31751990339451
2022-09-01 00:00:00 | Product 1 | Company 1 | 169 |  |  | 15.31751990339451
2022-10-01 00:00:00 | Product 1 | Company 1 | 509 |  |  | 15.31751990339451
2022-11-01 00:00:00 | Product 1 | Company 1 | 811 |  |  | 15.31751990339451
2022-12-01 00:00:00 | Product 1 | Company 1 | 691 |  |  | 15.31751990339451
2023-01-01 00:00:00 | Product 1 | Company 1 | 206 |  |  | 15.31751990339451
2023-02-01 00:00:00 | Product 1 | Company 1 | 270 |  |  | 15.31751990339451
2023-03-01 00:00:00 | Product 1 | Company 1 | 165 |  |  | 15.31751990339451
2023-04-01 00:00:00 | Product 1 | Company 1 | 471 |  |  | 15.31751990339451
2023-05-01 00:00:00 | Product 1 | Company 1 | 416 |  |  | 15.31751990339451
2023-06-01 00:00:00 | Product 1 | Company 1 | 843 |  |  | 15.31751990339451
2023-07-01 00:00:00 | Product 1 | Company 1 | 714 |  |  | 15.31751990339451
2023-08-01 00:00:00 | Product 1 | Company 1 | 135 |  |  | 15.31751990339451
2023-09-01 00:00:00 | Product 1 | Company 1 | 415 |  |  | 15.31751990339451
2023-10-01 00:00:00 | Product 1 | Company 1 | 449 |  |  | 15.31751990339451
2023-11-01 00:00:00 | Product 1 | Company 1 | 601 |  |  | 15.31751990339451
2023-12-01 00:00:00 | Product 1 | Company 1 | 655 |  |  | 15.31751990339451