Allocate Tile Boxes and Grout Packages Across Rooms

Allocate original tile boxes and grout packages separately for each room,then total matching products while retaining both full reports and the tile checkpoint.

• Choose room,tile,length,width CSV/TSV;rectangular dimensions m,1-20rooms/10columns/64KiB. Existing tile grid/spares/box calculation runs first. Actual native tile sides/joint convert m to mm;room length*width supplies grout area. No purchased/spare-tile area substitution. Enter common grout depth,density,waste,package kg and literal label. Original per-room tile boxes/grout packages sum by exact kind+product;no offcut/leftover pooling. Eight-column checkpoint keeps both full reports,actual grout arguments and ENTIRE first tile checkpoint;40rows/5MiB. Download raw room source separately. Unsupported derived values/grout settings retain the first checkpoint. Approximate grout model has no perimeter/roughness correction or installation guarantee. No product lookup/material certification. Full source/reports unredacted. Narrow preview may wrap numeric text;CSV tokens stay exact.
• Unchanged B30 tile roster source:UTF8 CSV/TSV64KiB,1-20rooms,max10cols/210cells,required room,tile,length,width;literal room256/product128 one-line labels,numeric source text128. Common original tile dimensions,joint,orientation,spares,box and suppliedprice controls unchanged. Raw source remains separately downloadable. No room dimensions inferred from area. Existing spreadsheet source/BOM and B30/B35/B39 lessons reused.
• Unchanged actual tile-room-allocations.csv/.tsv4columns product,room,units,native_report_json,20rows/4cols84cells/5MiB. Each complete16-field original tile report retained,units equals actual original boxes. New finite consumer inspects exact known filename/header/resource/facts and full report fields/count ranges/canonical compact JSON+LF;no BOM on this producer-emitted checkpoint. Owned profile may require each fixed-shape original tile report<=4096bytes,well above the source-proved fixed16-scalar output bound;no original engine cap changed. Labels/rows/numerical fields stay literal.
• Read actual complete original tile report. New original grout arguments length=String(actual tileLengthM*1000),width=String(actual tileWidthM*1000),joint=String(actual groutM*1000),area=String(actual roomLengthM*roomWidthM);explicit binary64 conversions/rectangle area use actual native numbers,not reconstructed original lexical decimals. Depth,density,waste,pack supplied common strings. Record every actual derived argument and full original report. No rounding,clamp,synthesized geometry,temperature/material lookup or source-token equivalence claim. Original tile orientation retained;grout formula uses the physical rectangle sides symmetrically.
• Original positive tileL/tileW/fillDepthmm1e-12..1e12,nonnegative jointmm/aream2/density0..1e12,waste0..100,positivepackagekg1e-12..1e12. Exact rational per-area=(L+W)/(L*W)*depth*joint*density,requiredMass=perArea*area*(1+waste/100),packages=ceil(requiredMass/pack),0..1e9. Original Number(n)/Number(d) nominalKgPerM2/requiredKg,nominalKg=nominalPerArea*area andpurchasedKg=packages*pack binary64 fields preserved. Full13-field report remains. Out-of-range derivedarea/mm/quantity or invalid downstream settings keeps complete first tile checkpoint/refuses grout;no partial grout checkpoint on late room failure or Cancel.
• Existing tile producer defaults .6m/.3m,3mmjoint,normalorientation,10%spares,8tiles/box,supplied20price/box unchanged. New grout common depth8mm,density1.6kg/L,waste10%,pack5kg match original standalone values;label Grout A explicit own group label. One common grout product/profile across rooms;no density lookup/recommendation. All three steps share original comma/tab/semicolon/pipe enum.
• tile-grout-room-purchase-counts.csv/.tsv8columns:product_unit,room,units,tile_report_json,grout_report_json,grout_arguments_json,tile_checkpoint_text,tile_checkpoint_filename. Emit two rows perroom:Tile boxes: +actual tile product with originalboxes,Grout packages: +supplied literal groutlabel with originalpackages. Every row retains both entire nativeJSON+LF files,the actual all-string groutargs+LF,and the ENTIRE incoming first checkpoint text and filename,so first intermediate data survives later checkpoint replacement. Original raw source remains native source download. Quote-all CRLF/protectfalse;5MiB/40rows8cols328cells,atomic budget failure. No ZIP/binary disguising or supplementary-file loss.
• Unchanged original grouper keycolumn1/valuecolumn3/protecttrue/shared delimiter returns complete group,count,sum,min,max in first-seen order. Both kinds are whole0..1b perroom so native decimal lexical contract always fits without rounding;up to20b total perproduct. Allocate whole tile boxes and grout packages separately for each room before summing;no offcut/spare/leftover sharing. All first tile price/cost and other tile/grout descriptive values remain in full report cells;final summarizes purchase counts only.
• Rectangular room/aligned original tile grid only,original orientation/spares/joint rules. Original grout formula is approximate mass model without perimeter/surface-roughness corrections or installation guarantee. User supplies fill depth,density,package size,label and tile parameters,not product selections. No manufacturer/fire/acoustic/installation certification or universal material recommendation. Actual native binary64 dimensions converted to mm/area;new consumer range/whole-package bounds may refuse an otherwise valid tile CP,which remains downloadable. Complete raw source and all reports unredacted;no Excel typed-cell,authenticity or secure-erasure guarantee. Existing narrow mobile numeric preview wrapping documentedB39 may apply;shared renderer unchanged. Original30s perroom workers,owned90s grout stage/singleflight/Cancel/reset;max20 sequential grout runs,atomic late errors.