Rental delayed-return substitute check calculator

Calculate affected bookings and substitute assignment and affected bookings lacking substitute with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Use affected bookings and substitute assignment and affected bookings lacking substitute to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Returns [asset,planned return minute,actual ready minute]; enter JSON
[["A",10,25],["B",15,20]]
Next bookings [asset,start minute,end minute]; enter JSON
[["A",20,40],["B",25,45]]
Interchangeable substitute assets (count)
1
Affected bookings and substitute assignment (JSON)
[[1,1,20,40]]
Affected bookings lacking substitute (count)
0

Try another scenario

Returns [asset,planned return minute,actual ready minute]; enter JSON
[["A",10,35],["B",15,30]]
Next bookings [asset,start minute,end minute]; enter JSON
[["A",20,45],["B",25,50],["A",50,70]]
Interchangeable substitute assets (count)
1
Affected bookings and substitute assignment (JSON)
[[1,1,20,45],[2,null,25,50]]
Affected bookings lacking substitute (count)
1
Calculation method

Calculation method

Affected bookings and substitute assignment (JSON)

A booking is affected if actual ready>start; allocate substitutes to affected fixed intervals with no overlap; output booking index,substitute,start,end.

Affected bookings lacking substitute (count)

Count null substitute assignments.

Symbols and units
a
Returns [asset,planned return minute,actual ready minute]; enter JSON
b
Next bookings [asset,start minute,end minute]; enter JSON
c
Interchangeable substitute assets (count)

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Delayed returns affect fixed subsequent same-asset bookings; substitute inventory is interchangeable and initially available throughout. Supported limits: All numeric inputs and computed intermediates must remain finite. Supported numeric input magnitude is zero or 1e-12 through 1e12 in absolute value; reject values outside this bounded range. All lists/JSON record tables are limited to 100 records unless a stricter bound is stated; reject malformed record arity and wrong member types. Unique return asset IDs; actual ready>=planned; start<end; substitute count0..20; no cascade beyond entered actual ready.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.