coding a spread sheet (non vba) just formulas - refueling a vehicle locatio based on range

[Rjot1234]

To whom be willing to help. In this problem I am trying to code using formulas (not VBA). Nodes (locations) on which vehicles must stop to refuel based on a 2000 mile journey. Vehicle types with associated maximum range are provided.

Table below assigns a row to each vehicle and range to nodes (cities) are depicted by columns.

Locations can be depicted by penalty value (5 minutes to refuel), or binary yes/no (for refuel location), or interger 1, 0s to id locations.

v/r
Ricrefueling vehicle locations based on range.xlsx

[6StringJazzer]

This assumes that vehicles start empty and have to fill at node 0.

[Rjot1234]

TY - very good