sheets_if_nest.txt

Walking (Average Speed)
Walking (Maximum Speed)
Walking Carrying Weight (Average Speed)
Walking Carrying Weight (Maximum Speed)
Horseback Hourly (Average Speed)
Horseback Hourly (Maximum Speed)
Horseback Daily Min (Average Speed)
Horseback Daily Min (Maximum Speed)
Horseback Daily Max (Average Speed)
Horseback Daily Max (Maximum Speed)
Trireme (Maximum Speed)
Chinese Junk (Maximum Speed)
Caravel Hourly (Average Speed)
Caravel Hourly (Maximum Speed)
Caravel Daily Min (Average Speed)
Caravel Daily Min (Maximum Speed)
Caravel Daily Max (Average Speed)
Caravel Daily Max (Maximum Speed)
Steamship Hourly (Average Speed)
Steamship Daily (Maximum Speed)
Kayak Hourly (Average Speed)
Kayak Hourly (Maximum Speed)
Kayak Daily (Average Speed)
Kayak Daily (Maximum Speed)
By Pigeon Hourly (Average Speed)
By Pigeon Hourly (Maximum Speed)
By Pigeon Daily (Average Speed)
By Pigeon Daily (Maximum Speed)

=== km/h ===
=IF(J3="Horseback Hourly (Average Speed)",8.04672,IF(J3="Horseback Hourly (Maximum Speed)",64.3738,IF(J3="Trireme (Maximum Speed)",13.6794,IF(J3="Chinese Junk (Maximum Speed)",25.7495,IF(J3="Caravel Hourly (Average Speed)",7.24205,IF(J3="Caravel Hourly (Maximum Speed)",14.4841,IF(J3="Steamship Hourly (Average Speed)",40.2336,IF(J3="Kayak Hourly (Average Speed)",5.6327,IF(J3="Kayak Hourly (Maximum Speed)",8.04672,IF(J3="By Pigeon Hourly (Average Speed)",80.4672,IF(J3="By Pigeon Hourly (Maximum Speed)",144.841,0)))))))))))

=== km/day ===
Walking (Average Speed)
Walking (Maximum Speed)
Walking Carrying Weight (Average Speed)
Walking Carrying Weight (Maximum Speed)
Horseback Daily Min (Average Speed)
Horseback Daily Min (Maximum Speed)
Horseback Daily Max (Average Speed)
Horseback Daily Max (Maximum Speed)
Caravel Daily Min (Average Speed)
Caravel Daily Min (Maximum Speed)
Caravel Daily Max (Average Speed)
Caravel Daily Max (Maximum Speed)
Steamship Daily (Maximum Speed)
Kayak Daily (Average Speed)
Kayak Daily (Maximum Speed)
By Pigeon Daily (Average Speed)
By Pigeon Daily (Maximum Speed)

=IF(J3="Walking (Average Speed)",32.1869,IF(J3="Walking (Maximum Speed)",48.2803,IF(J3="Walking Carrying Weight (Average Speed)",24.1402,IF(J3="Walking Carrying Weight (Maximum Speed)",40.2336,IF(J3="Horseback Daily Min (Average Speed)",32.1869,IF(J3="Horseback Daily Min (Maximum Speed)",160.934,IF(J3="Horseback Daily Max (Average Speed)",48.2803,IF(J3="Horseback Daily Max (Maximum Speed)",160.934,IF(J3="Caravel Daily Min (Average Speed)",144.841,IF(J3="Caravel Daily Min (Maximum Speed)",241.402,IF(J3="Caravel Daily Max (Average Speed)",160.934,IF(J3="Caravel Daily Max (Maximum Speed)",241.402,IF(J3="Steamship Daily (Maximum Speed)",1173.577981,IF(J3="Kayak Daily (Average Speed)",24.1402,IF(J3="Kayak Daily (Maximum Speed)",64.3738,IF(J3="By Pigeon Daily",965.606,0))))))))))))))))

=== Distance Constraints ===
=IF(x, y, IF(x, y, IF(x, y, IF(x, y, z))))

IF(AND(OR(J3="", J3="", J3="", J3=""), J7>=))

=IF(AND(OR(J3="By Pigeon Hourly (Average Speed)", J3="By Pigeon Hourly (Maximum Speed)", J3="By Pigeon Daily (Average Speed)", J3="By Pigeon Daily (Maximum Speed)"), J7>=1770.278),"! Pigeons cannot travel that far !",IF(AND(J3="Trireme (Maximum Speed)", J7>=305.775), "! Triremes cannot travel that far !", IF(AND(J3="Chinese Junk (Maximum Speed)", J7>=8046.72), "! Chinese Junks cannot travel that far !", IF(AND(OR(J3="Caravel Hourly (Average Speed)", J3="Caravel Hourly (Maximum Speed)", J3="Caravel Daily Min (Average Speed)", J3="Caravel Daily Min (Maximum Speed)", J3="Caravel Daily Max (Average Speed)", J3="Caravel Daily Max (Maximum Speed)"), J7>=8046.72), "! Caravels cannot travel that far !", IF(AND(OR(J3="Steamship Hourly (Average Speed)", J3="Steamship Daily (Maximum Speed)"), J7>=7724.851), ": Steamships must refill at least once :", "No errors")))))

=IF(AND(OR(J3="By Pigeon Hourly (Average Speed)", J3="By Pigeon Hourly (Maximum Speed)", J3="By Pigeon Daily"), J7>=1770.278),"! Pigeons cannot travel that far !",IF(AND(J3="Trireme (Maximum Speed)", J7>=305.775), "! Triremes cannot travel that far !", IF(AND(J3="Chinese Junk (Maximum Speed)", J7>=8046.72), "! Chinese Junks cannot travel that far !", IF(AND(OR(J3="Caravel Hourly (Average Speed)", J3="Caravel Hourly (Maximum Speed)", J3="Caravel Daily Min (Average Speed)", J3="Caravel Daily Min (Maximum Speed)", J3="Caravel Daily Max (Average Speed)", J3="Caravel Daily Max (Maximum Speed)"), J7>=8046.72), "! Caravels cannot travel that far !", IF(AND(OR(J3="Steamship Hourly (Average Speed)", J3="Steamship Daily (Maximum Speed)"), J7>=7724.851), ": Steamships must refill at least once :", "No errors")))))