25 bags asked for, 22 blown: the gap on an insulation record, section by section

Three figures belong to the whole record rather than to one section, because that is how a supplier's ticket, a crew's bill and a continuous blow actually arrive. Leave any of them at nothing and the per-section cells in part B stay live.

Only have one total? Enter it as the record total: one materials invoice, one labour bill, one installed count per material. The page then checks that material's sections together and leaves the per-section money and count cells blank, because it never splits a total you did not split.

One card a section, one section an area you measured separately. A card asks for the cells its own material type needs and no others: the chart row for loose-fill, the pack's two printed figures for batt, the data sheet's two for spray foam. Type the figures as printed; nothing here is derived for you and nothing here is suggested to you.

Every line is worked from the figures printed beside it. Bags, packs and sets are whole, because a chart row is read in whole units and a supplier delivers them that way; money is worked to the cent. A loose-fill row is asked for twice, once off the maximum square feet a bag may net and once off the bags a thousand square feet needs, and the quantity printed is whichever of those two asks for most, rounded up. Each division here is printed to two decimals and the rounding up is done on the division itself, not on the two decimals it is printed as, so a division printed as a whole number can still ask for one unit on top of it. A spray-foam row works its board feet at the thickness printed beside it, to two decimals, because that is the thickness the line states and the thickness a crew sprays to. No line here derives an R-value from a thickness, and none is printed.

The same arithmetic, written out for anything reading this page rather than looking at it: api.json beside this page carries every input, every output, the formula line by line, this worked record, and a list of what the calculation deliberately leaves out.

One row a section, with its own divisor and its own unit: the most square feet a bag may net for loose-fill, the square feet a pack holds for batt, the board feet a set yields for spray foam. The quantity columns carry no total, because a bag added to a pack is not a quantity of anything; the footing adds money only, and prints one subtotal a material type. A cell reading one record total, not split or one invoice, not split is a figure you hold once for the whole record, printed where it belongs instead of divided into parts you never divided. Where one count was kept for a material, the money on that material's footing line is worked on the quantity its rows asked for and not on the count you kept, because the price you typed is a price for one unit of a row and the count you kept is for the material. On those rows the Sq ft a unit cell prints a dash and no words: that figure exists once for the whole record too, and it prints on the material's own footing line, where the summed area of its sections is divided by the one count you kept.

Labour is not in that footing and is not apportioned into it. It is printed on its own line in the working above, as one figure for the whole record, because a labour bill that arrives as one number is one number.