Spreadsheet: 237352d1369197552-matching-and-moving-columns-based-on-day-number-excel-pre-manual-adjustment
Sheet: Sheet1

 |  |  | Obs |  |  |  |  |  |  | Preds
 |  | Day # Obs | Tmax | Tmin | VPD | Rainfall | Duration | Radiation | Day # Preds
1906-12-30 00:00:00 | 1906-12-29 00:00:00 | 6572 | 35 | 25.5 | 9.867658677956804 | 0 | 0 | 18000 | 6572 | 0.0734 | 0.0736 | 0.0738 | 0.0744 | 0.0753 | 0.077 | 0.0794
1906-12-31 00:00:00 | 1906-12-30 00:00:00 | 6573 | 33.5 | 24 | 6.26544602314663 | 0.017 | 0.1356403 | 19000 | 6573 | 0.0494 | 0.0495 | 0.0496 | 0.0499 | 0.0503 | 0.0511 | 0.0527
1907-01-01 00:00:00 | 1906-12-31 00:00:00 | 6574 | 33 | 24 | 5.728407792591199 | 0.0001 | 0.03211259 | 23000 | 6574 | 0.0369 | 0.037 | 0.037 | 0.0372 | 0.0376 | 0.0382 | 0.0393
1907-01-02 00:00:00 | 1907-01-01 00:00:00 | 6575 | 35.5 | 25 | 7.955098130281513 | 0.0002 | 0.03272518 | 21000 | 6575 | 0.03 | 0.0301 | 0.0301 | 0.0303 | 0.0306 | 0.0312 | 0.0322
1907-01-03 00:00:00 | 1907-01-02 00:00:00 | 6576 | 35.5 | 25 | 7.955098130281513 | 0 | 0 | 22000 | 6575.165 | 0.1862 | 0.1857 | 0.1852 | 0.1838 | 0.1814 | 0.176 | 0.1653
1907-01-04 00:00:00 | 1907-01-03 00:00:00 | 6577 | 36 | 26 | 9.172705025727296 | 0.0218 | 0.16504462 | 21000 | 6576 | 0.0768 | 0.0771 | 0.0773 | 0.078 | 0.0791 | 0.0811 | 0.0842
1907-01-05 00:00:00 | 1907-01-04 00:00:00 | 6578 | 35.5 | 25 | 7.955098130281513 | 0.0085 | 0.08357015000000001 | 21000 | 6576.0836 | 0.1634 | 0.1628 | 0.1622 | 0.1604 | 0.1573 | 0.1513 | 0.1403
1907-01-06 00:00:00 | 1907-01-05 00:00:00 | 6579 | 35.5 | 26.5 | 7.651049651443714 | 0.002 | 0.0437518 | 15000 | 6577 | 0.0695 | 0.0697 | 0.0698 | 0.0704 | 0.0712 | 0.0727 | 0.0751
1907-01-07 00:00:00 | 1907-01-06 00:00:00 | 6580 | 32.5 | 23.5 | 5.298170384457663 | 0.0162 | 0.13073958 | 13000 | 6577.0438 | 0.1002 | 0.0996 | 0.099 | 0.0974 | 0.0949 | 0.0907 | 0.0853
1907-01-08 00:00:00 | 1907-01-07 00:00:00 | 6581 | 33.5 | 24.5 | 8.196201952072379 | 0.0043 | 0.05784137 | 15000 | 6578 | 0.0546 | 0.0547 | 0.0548 | 0.055 | 0.0555 | 0.0562 | 0.0574
1907-01-09 00:00:00 | 1907-01-08 00:00:00 | 6582 | 34 | 25 | 6.303070465262365 | 0.0003 | 0.03333777 | 20000 | 6578.1307 | 0.1808 | 0.1803 | 0.1797 | 0.1781 | 0.1754 | 0.1701 | 0.159
1907-01-10 00:00:00 | 1907-01-09 00:00:00 | 6583 | 34.5 | 24.5 | 6.379090875927574 | 0.0002 | 0.03272518 | 19000 | 6579 | 0.0765 | 0.0767 | 0.0769 | 0.0775 | 0.0785 | 0.0802 | 0.083
1907-01-11 00:00:00 | 1907-01-10 00:00:00 | 6584 | 33.5 | 24.5 | 5.856466563200982 | 0 | 0 | 14000 | 6579.0578 | 0.1353 | 0.1346 | 0.1339 | 0.1318 | 0.1283 | 0.1221 | 0.1119
1907-01-12 00:00:00 | 1907-01-11 00:00:00 | 6585 | 33 | 25 | 5.447880000126261 | 0.0089 | 0.08602051 | 15000 | 6580 | 0.0634 | 0.0635 | 0.0636 | 0.064 | 0.0646 | 0.0657 | 0.0674
1907-01-13 00:00:00 | 1907-01-12 00:00:00 | 6586 | 32 | 24 | 5.191369562035774 | 0.0181 | 0.14237879 | 13000 | 6581 | 0.0453 | 0.0453 | 0.0454 | 0.0456 | 0.046 | 0.0466 | 0.0478
1907-01-14 00:00:00 | 1907-01-13 00:00:00 | 6587 | 33.5 | 24 | 5.40021776280733 | 0.0122 | 0.10623598 | 13000 | 6582 | 0.0358 | 0.0359 | 0.0359 | 0.0361 | 0.0363 | 0.0368 | 0.0378
1907-01-15 00:00:00 | 1907-01-14 00:00:00 | 6588 | 33 | 24.5 | 5.902580473147445 | 0.0115 | 0.10194785 | 12000 | 6583 | 0.0324 | 0.0324 | 0.0325 | 0.0326 | 0.0328 | 0.0331 | 0.0339
1907-01-16 00:00:00 | 1907-01-15 00:00:00 | 6589 | 33 | 26 | 7.324064669539951 | 0.0004 | 0.03395036 | 18000 | 6583.086 | 0.1515 | 0.1505 | 0.1496 | 0.1464 | 0.1413 | 0.1311 | 0.1112
1907-01-17 00:00:00 | 1907-01-16 00:00:00 | 6590 | 30.5 | 24 | 4.326141301696481 | 0.0211 | 0.16075649 | 12000 | 6584 | 0.0617 | 0.0618 | 0.0619 | 0.0622 | 0.0627 | 0.0635 | 0.0643
1907-01-18 00:00:00 | 1907-01-17 00:00:00 | 6591 | 33 | 23.5 | 5.558736141070334 | 0.0077 | 0.07866943 | 18000 | 6584.1424 | 0.1849 | 0.1844 | 0.184 | 0.1827 | 0.1804 | 0.1756 | 0.166
1907-01-19 00:00:00 | 1907-01-18 00:00:00 | 6592 | 33.5 | 23.5 | 6.079867654295683 | 0.012 | 0.1050108 | 19000 | 6585 | 0.0783 | 0.0786 | 0.0788 | 0.0794 | 0.0805 | 0.0824 | 0.0855
1907-01-20 00:00:00 | 1907-01-19 00:00:00 | 6593 | 34 | 24.5 | 6.117778719564285 | 0 | 0 | 18000 | 6585.1062 | 0.1762 | 0.1758 | 0.1753 | 0.1738 | 0.1714 | 0.1664 | 0.1569