ISO Needed Fire Flow Calculator

10Reference — ISO Data Tables

Transcribed from the tables carried in the source worksheet. The builders in section 3 read 330.A and 330.B directly and name the cell they used.

11Basis, Departures and Limitations

Where this tool differs from the spreadsheet it was derived from, and why.

1. Method source. ISO, Guide for Determination of Needed Fire Flow, Edition 05-2006, as reproduced in a 2011 utility screening worksheet. The tables in section 7 and the worked example are transcribed from that document. No utility branding, disclaimer or sign-off form is reproduced.
2. Limits the source worksheet omitted. The originating spreadsheet enforced only the 500 gpm floor on C. It did not cap C at 8,000 / 6,000 gpm, did not apply the one-storey 6,000 gpm cap, did not cap (X + P) at 0.60, did not cap NFF at 12,000 gpm and did not carry the wood-shingle adder. All six are enforced here, and every one that bites is named in the Limit Audit so the divergence from the source is visible rather than silent.
3. Errata in the published ISO effective-area table. The worksheet carries an effective-area table giving C directly from the construction class and the effective area. Checking the analytic turnover point of all 108 bands against the printed values shows the table and the formula agree everywhere except two narrow windows: A = 10,851–10,852 ft² in Construction Class 2, where the table prints 1,750 gpm against the formula's 2,000 gpm, and A = 63,372–63,374 ft² in Classes 3 and 4, where it prints 3,500 gpm against 3,750 gpm. Five effective-area values in total. ISO defines C by the formula and the 250 gpm rounding rule, so the formula governs and the tool says so on screen whenever an entered area falls in one of those windows.
4. Exposure factor with several exposed sides. The worked example carried in the source (Example 3) computes a charge for each exposure — 0.14 for building A, 0.17 for building B — and takes the highest as X. That is the only primary evidence available, and it is what this tool implements. Whether ISO 05-2006 instead requires the charges on separate sides to be summed has not been confirmed against the full ISO text. Confirm before relying on a multi-sided result.
5. The builders are input aids, not a second calculation path. The floor schedule, occupancy assistant and the two table pickers all write into the same four fields — A, O, X and P — that the calculator has always read. The arithmetic underneath is the one verified in Phase 1. Every lookup states the table, the band and the column it used, so a reviewer can re-read the printed table and check it without re-deriving anything.
6. Reading the Table 330.A blank-wall note. The two notes at the foot of Table 330.A sit under the heading Blank Masonry Wall, so they qualify that case, not the table as a whole. That reading is forced by the worked example: in ISO Example 3 both exposure buildings are two storeys and so is the subject, yet the charges are 0.14 and 0.17, not zero. Were the “same or lower height gives X = 0” note general, Example 3 would have to compute X = 0. The builder therefore applies the height test only to a blank wall. Where a blank wall is higher, ISO says to count only the length-height above the subject's facing wall but does not say which construction column to read for that portion; the builder asks and records your choice rather than picking one silently.
7. Occupancy in ISO Example 3 does not reconcile with its own figures. The example states cabinet making “occupies over 25 % of the total floor of the building” and assigns C-4, O = 1.15. Its stated areas give 600 ft² of cabinet making against 2,250 + 810 = 3,060 ft² of total floor area, which is 19.6 %. By the printed C-4 rule that building would be C-3, O = 1.00. The occupancy assistant applies the printed rule and shows the percentages it used; where your judgement differs, switch back to selecting the class directly. The effective-area side of the same example reconciles exactly — 2,250 + 50 % of 810 = 2,655 ft² — which is what confirms the 810 ft² second floor read off the diagram.
8. Several exposures or communications. Each is charged separately and the highest single charge governs, per ISO Example 3, which charges two exposing buildings at 0.14 and 0.17 and carries 0.17 forward. Charges are not summed across sides. The same treatment is applied to communications by extension, which the source does not demonstrate; see also note 4.
9. Wood-shingle adder, order of operations. ISO states that 500 gpm is added to the needed fire flow but does not fix whether the addition precedes or follows rounding. This tool adds it to the calculated flow before rounding, so the reported result always lands on the ISO rounding grid. Where the adder applies, the Limit Audit states the assumption.
10. Units. ISO's coefficient 18 in C = 18 F √A is dimensional — it holds only for A in ft² and C in US gpm — and the rounding rules are defined in 250 and 500 gpm steps. The SI switch converts the area input and the displayed flows; the calculation basis stays US customary. The gpm figure is the governing value; the SI conversion is shown beneath it.
11. Sprinkler path: shown alongside, not blanked. Where a sprinkler system is proposed the source worksheet stops using the ISO calculation and takes the sprinkler demand plus the outside hose allowance, with a 500 gpm floor. Its calculated-NFF cell then reports N/A. This tool applies the same governing rule but keeps the ISO figure on screen as a reference point instead of blanking it, marked as not governing. Erasing a number that was correctly computed removes the reader's ability to see how far apart the two bases are, which is exactly what a reviewer wants to know.
12. Residential shortcut. Table A applies only to 1 and 2 family dwellings not exceeding 2 storeys in height, and assigns the flow from the separation distance alone — no construction, occupancy or exposure factors, so none of their limits can bite. A higher flow requested by the fire official governs over the table where it is higher. Selecting this building type hides the full method rather than leaving both paths live, because only one of them can be the answer.
13. The 500 gpm floor on the sprinkler total. The source applies it unconditionally, so its sign-off sheet shows 500 gpm even with no sprinkler data entered at all. Here the total is withheld until an ASSF is entered, and the floor is flagged when it actually bites.
14. Duration and storage. ISO Needed Fire Flow is a flow. ISO attaches no duration to it, so no duration is assumed here — section 6 takes the figure your governing code or the authority sets and returns the volume behind it. The only duration datum in the source is the cover note that flows above 3,500 gpm may be identified for three hours; that is one data point about one utility's practice, not a rule, and it is not applied automatically.
15. No code fire-flow table is embedded. The plan for this phase was to carry an IFC Appendix B or NFPA 1 fire-flow table as a comparison column. Neither is reproduced, for two reasons. They are not in the source document this tool was built from, so transcribing them would mean taking design data from an unverified secondary source; and both are separately copyrighted by their publishers. Section 6 instead takes the figure from your governing code with its reference and resolves which demand governs. Where a licensed copy of the applicable table is available, wiring it in is a contained change.
16. Which demand governs. ISO Needed Fire Flow grades a municipal water supply for insurance rating. It is not a code requirement, and it is not a project specification. Section 6 sets the three side by side and takes the highest as governing, which is the conservative reading and the usual contractual one; where a specific code or contract says otherwise, that wording governs, not this tool.