Spreadsheet: 94308d1294159576-is-there-a-find-function-in-excel-example
Sheet: Alternative

Date/Time | Lead Time | Hindcast 1 (m3/s) | [NAME] (m3/s) | Difference (m3/s) |  |  | Lead Time | [NAME] | Hindcast 1 (m3/s) | [NAME] (m3/s) | % Difference
2009-02-09 03:00:00 | 0 | 1.03598821163177 | 0.953 | 0.08298821163177006 |  |  | 0 | 0.1290376424789399 | 1.52096235752106 | 1.65 | 0.6499999999999999
2009-02-09 03:00:00 | 3 | 1.04496014118195 | 0.907 | 0.13796014118195 |  |  | 3 | 0.2932821657708702 | 1.40328216577087 | 1.11 | 0.1100000000000001
2009-02-09 03:00:00 | 6 | 1.04409444332123 | 0.885 | 0.15909444332123 |  |  | 6 | 1.144138803743803 | 2.404138803743803 | 1.26 | 0.26
2009-02-09 03:00:00 | 9 | 1.1040313243866 | 0.902 | 0.2020313243866 |  |  | 9 | 2.359216750271877 | 3.769216750271877 | 1.41 | 0.4099999999999999
2009-02-09 03:00:00 | 12 | 1.33832359313965 | 1.01 | 0.32832359313965 |  |  | 12 | 3.639387949705121 | 5.249387949705121 | 1.61 | 0.6100000000000001
2009-02-09 03:00:00 | 15 | 1.839565992628841 | 1.11 | 0.7295659926288405 |  |  | 15 | 4.351901082992554 | 6.071901082992554 | 1.72 | 0.72
2009-02-09 03:00:00 | 18 | 2.85755848918489 | 1.26 | 1.59755848918489 |  |  | 18 | 4.8758823633194 | 6.525882363319401 | 1.65 | 0.6499999999999999
2009-02-09 03:00:00 | 21 | 4.366462404112097 | 1.41 | 2.956462404112097 |  |  | 21 | 4.98254276752472 | 6.59254276752472 | 1.61 | 0.6100000000000001
2009-02-09 03:00:00 | 24 | 6.046868443489074 | 1.61 | 4.436868443489073 |  |  | 24 | 4.90542027473449 | 6.43542027473449 | 1.53 | 0.53
2009-02-09 03:00:00 | 30 | 4.88838648796081 | 1.65 | 3.23838648796081 |  |  | 30 | 3.590469961762427 | 5.100469961762427 | 1.51 | 0.51
2009-02-09 03:00:00 | 36 | 3.630108296871187 | 1.53 | 2.100108296871187 |  |  | 36 | 2.22495092515011 | 3.70495092515011 | 1.48 | 0.48
2009-02-09 03:00:00 | 42 | 2.32694077015913 | 1.51 | 0.8169407701591298 |  |  | 42 | 0.8248615262719872 | 2.324861526271987 | 1.5 | 0.5
2009-02-09 03:00:00 | 48 | 0.9988072514534 | 1.48 | 0.4811927485466 |  |  | 48 | 0.5588066078724913 | 0.9511933921275088 | 1.51 | 0.51
2009-02-09 09:00:00 | 0 | 0.980744302272797 | 0.885 | 0.09574430227279696
2009-02-09 09:00:00 | 3 | 1.04041790962219 | 0.902 | 0.1384179096221899
2009-02-09 09:00:00 | 6 | 1.21754324436188 | 1.01 | 0.2075432443618801
2009-02-09 09:00:00 | 9 | 1.566233873553514 | 1.11 | 0.4562338735535134
2009-02-09 09:00:00 | 12 | 2.28782343882641 | 1.26 | 1.02782343882641
2009-02-09 09:00:00 | 15 | 3.064080000241297 | 1.41 | 1.654080000241297
2009-02-09 09:00:00 | 18 | 4.219994085069634 | 1.61 | 2.609994085069633
2009-02-09 09:00:00 | 21 | 4.937440484762194 | 1.72 | 3.217440484762194
2009-02-09 09:00:00 | 24 | 5.29844880104065 | 1.65 | 3.64844880104065
2009-02-09 09:00:00 | 30 | 4.277258723974223 | 1.53 | 2.747258723974223
2009-02-09 09:00:00 | 36 | 3.181795791588232 | 1.51 | 1.671795791588232
2009-02-09 09:00:00 | 42 | 2.05372858047485 | 1.48 | 0.57372858047485
2009-02-09 09:00:00 | 48 | 0.9628606434894403 | 1.5 | 0.5371393565105597
2009-02-09 15:00:00 | 0 | 1.0643789768219 | 1.01 | 0.05437897682190007
2009-02-09 15:00:00 | 3 | 1.40328216577087 | 1.11 | 0.2932821657708702
2009-02-09 15:00:00 | 6 | 2.404138803743803 | 1.26 | 1.144138803743803
2009-02-09 15:00:00 | 9 | 3.769216750271877 | 1.41 | 2.359216750271877
2009-02-09 15:00:00 | 12 | 5.249387949705121 | 1.61 | 3.639387949705121
2009-02-09 15:00:00 | 15 | 6.071901082992554 | 1.72 | 4.351901082992554
2009-02-09 15:00:00 | 18 | 6.525882363319401 | 1.65 | 4.8758823633194
2009-02-09 15:00:00 | 21 | 6.59254276752472 | 1.61 | 4.98254276752472
2009-02-09 15:00:00 | 24 | 6.43542027473449 | 1.53 | 4.90542027473449
2009-02-09 15:00:00 | 30 | 5.100469961762427 | 1.51 | 3.590469961762427
2009-02-09 15:00:00 | 36 | 3.70495092515011 | 1.48 | 2.22495092515011
2009-02-09 15:00:00 | 42 | 2.324861526271987 | 1.5 | 0.8248615262719872
2009-02-09 15:00:00 | 48 | 0.971374392220923 | 1.51 | 0.538625607779077
2009-02-09 21:00:00 | 0 | 1.2396913766861 | 1.26 | 0.02030862331390004
2009-02-09 21:00:00 | 3 | 1.62728190436391 | 1.41 | 0.2172819043639098
2009-02-09 21:00:00 | 6 | 2.175318956564396 | 1.61 | 0.5653189565643959
2009-02-09 21:00:00 | 9 | 2.823945760917656 | 1.72 | 1.103945760917656
2009-02-09 21:00:00 | 12 | 3.378123521936633 | 1.65 | 1.728123521936633
2009-02-09 21:00:00 | 15 | 3.764596909471947 | 1.61 | 2.154596909471947
2009-02-09 21:00:00 | 18 | 3.865611032385455 | 1.53 | 2.335611032385455
2009-02-09 21:00:00 | 21 | 3.795057550333698 | 1.54 | 2.255057550333698
2009-02-09 21:00:00 | 24 | 3.669090642821739 | 1.51 | 2.159090642821739
2009-02-09 21:00:00 | 30 | 2.99931406974793 | 1.48 | 1.51931406974793
2009-02-09 21:00:00 | 36 | 2.3149950504303 | 1.5 | 0.8149950504303001
2009-02-09 21:00:00 | 42 | 1.632911562806183 | 1.51 | 0.1229115628061828
2009-02-09 21:00:00 | 48 | 0.9511933921275088 | 1.51 | 0.5588066078724913
2009-02-10 03:00:00 | 0 | 1.50411331653595 | 1.61 | 0.1058866834640502
2009-02-10 03:00:00 | 3 | 1.66960608959198 | 1.72 | 0.05039391040801999
2009-02-10 03:00:00 | 6 | 1.82769346237183 | 1.65 | 0.17769346237183
2009-02-10 03:00:00 | 9 | 2.02006149291992 | 1.61 | 0.41006149291992
2009-02-10 03:00:00 | 12 | 2.07930397987366 | 1.53 | 0.5493039798736599
2009-02-10 03:00:00 | 15 | 2.05977749824524 | 1.54 | 0.5197774982452401
2009-02-10 03:00:00 | 18 | 2.00585746765137 | 1.51 | 0.4958574676513698
2009-02-10 03:00:00 | 21 | 1.93902575969696 | 1.47 | 0.46902575969696
2009-02-10 03:00:00 | 24 | 1.86963510513306 | 1.48 | 0.38963510513306
2009-02-10 03:00:00 | 30 | 1.63554239273071 | 1.5 | 0.13554239273071
2009-02-10 03:00:00 | 36 | 1.39992213249207 | 1.51 | 0.1100778675079299
2009-02-10 03:00:00 | 42 | 1.16344511508942 | 1.51 | 0.34655488491058
2009-02-10 03:00:00 | 48 | 0.934577703475952 | 1.48 | 0.545422296524048
2009-02-10 09:00:00 | 0 | 1.52096235752106 | 1.65 | 0.1290376424789399
2009-02-10 09:00:00 | 3 | 1.523393034935 | 1.61 | 0.0866069650650001
2009-02-10 09:00:00 | 6 | 1.49070775508881 | 1.53 | 0.0392922449111901
2009-02-10 09:00:00 | 9 | 1.44165730476379 | 1.54 | 0.09834269523621009
2009-02-10 09:00:00 | 12 | 1.38782179355621 | 1.51 | 0.12217820644379
2009-02-10 09:00:00 | 15 | 1.33387196063995 | 1.47 | 0.1361280393600499
2009-02-10 09:00:00 | 18 | 1.2818078994751 | 1.48 | 0.1981921005248999
2009-02-10 09:00:00 | 21 | 1.23176503181458 | 1.47 | 0.2382349681854199
2009-02-10 09:00:00 | 24 | 1.18488657474518 | 1.5 | 0.31511342525482
2009-02-10 09:00:00 | 30 | 1.12008059024811 | 1.51 | 0.3899194097518901
2009-02-10 09:00:00 | 36 | 1.05657625198364 | 1.51 | 0.4534237480163601
2009-02-10 09:00:00 | 42 | 0.993112027645111 | 1.48 | 0.486887972354889
2009-02-10 09:00:00 | 48 | 0.933759570121765 | 1.47 | 0.536240429878235
2009-02-10 15:00:00 | 0 | 1.44490802288055 | 1.53 | 0.08509197711945005
2009-02-10 15:00:00 | 3 | 1.39926064014435 | 1.54 | 0.1407393598556501
2009-02-10 15:00:00 | 6 | 1.34584677219391 | 1.51 | 0.16415322780609
2009-02-10 15:00:00 | 9 | 1.29161024093628 | 1.47 | 0.17838975906372
2009-02-10 15:00:00 | 12 | 1.23976004123688 | 1.48 | 0.2402399587631199
2009-02-10 15:00:00 | 15 | 1.18981492519379 | 1.47 | 0.28018507480621
2009-02-10 15:00:00 | 18 | 1.14371347427368 | 1.5 | 0.3562865257263199
2009-02-10 15:00:00 | 21 | 1.09976351261139 | 1.51 | 0.41023648738861
2009-02-10 15:00:00 | 24 | 1.11108136177063 | 1.51 | 0.3989186382293699
2009-02-10 15:00:00 | 30 | 1.06544303894043 | 1.51 | 0.4445569610595701
2009-02-10 15:00:00 | 36 | 1.0193874835968 | 1.48 | 0.4606125164032
2009-02-10 15:00:00 | 42 | 0.973440170288086 | 1.47 | 0.4965598297119139
2009-02-10 15:00:00 | 48 | 0.933452546596527 | 1.42 | 0.4865474534034729
2009-02-10 21:00:00 | 0 | 1.42093288898468 | 1.51 | 0.08906711101532006
2009-02-10 21:00:00 | 3 | 1.36742746829987 | 1.47 | 0.10257253170013
2009-02-10 21:00:00 | 6 | 1.31486248970032 | 1.48 | 0.1651375102996799
2009-02-10 21:00:00 | 9 | 1.26489388942719 | 1.47 | 0.20510611057281
2009-02-10 21:00:00 | 12 | 1.21775078773499 | 1.5 | 0.28224921226501
2009-02-10 21:00:00 | 15 | 1.17419278621674 | 1.51 | 0.33580721378326
2009-02-10 21:00:00 | 18 | 1.26064574718475 | 1.51 | 0.2493542528152499
2009-02-10 21:00:00 | 21 | 1.36357510089874 | 1.51 | 0.14642489910126
2009-02-10 21:00:00 | 24 | 1.39727938175201 | 1.51 | 0.1127206182479901
2009-02-10 21:00:00 | 30 | 1.28351938724518 | 1.48 | 0.19648061275482
2009-02-10 21:00:00 | 36 | 1.16492331027985 | 1.47 | 0.30507668972015
2009-02-10 21:00:00 | 42 | 1.04655778408051 | 1.42 | 0.3734422159194899
2009-02-10 21:00:00 | 48 | 0.930575788021088 | 1.37 | 0.4394242119789121