Bookbinding repair material ledger calculator

Calculate net purchase units by material and purchase packs with your own figures.

Your numbers

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

Use net purchase units by material and purchase packs to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

JSON Materials [ID,approved repair quantity per book,books,available units,units per purchase pack]
[["paper",2,5,4,10],["cloth",0.2,5,0.5,1]]
Net purchase units by material
[["paper",6],["cloth",0.5]]
Purchase packs
[["paper",1],["cloth",1]]
Work stage ledger
[["paper",5,10],["cloth",5,1]]

Try another scenario

JSON Materials [ID,approved repair quantity per book,books,available units,units per purchase pack]
[["paper",2,8,4,10],["cloth",0.2,8,0.5,1]]
Net purchase units by material
[["paper",12],["cloth",1.1]]
Purchase packs
[["paper",2],["cloth",2]]
Work stage ledger
[["paper",8,16],["cloth",8,1.6]]
Calculation method

Calculation method

Net purchase units by material

J([[r[0],max(0,r[1]*r[2]-r[3])] for r in a])

Purchase packs

J([[r[0],ceil(max(0,r[1]*r[2]-r[3])/r[4])] for r in a])

Work stage ledger

J([[r[0],r[2],r[1]*r[2]] for r in a])

Symbols and units
a
JSON Materials [ID,approved repair quantity per book,books,available units,units per purchase pack]

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

  • Ledger of externally approved repair materials; one material row per stage. No conservation/material compatibility treatment advice; units consistent within each row. Supported limits: All numeric inputs must be finite. Only the explicitly described mathematical scenario is supported.
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.