# Casting Pattern Allowance Worksheet: Shrink and Machining Stock per Feature > Source: https://netray.co/tools/casting-pattern-allowance-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Compute pattern dimensions from finished size, machining stock per side and shrink percent, feature by feature, and export the table to Excel. ## Category engineering-plm ## Industry Foundry ## Audience - Pattern maker - Tooling engineer - Design engineer - Foundry engineer ## Tool **Kind:** worksheet **Mode:** editable **Columns:** #### Feature **Key:** feature **Type:** text #### Type **Key:** type **Type:** select **Options:** - Outside - Bore / inside - Height - Boss - Flange #### Finished size (mm) **Key:** finished **Type:** number **Format:** decimal #### Machining stock per side (mm) **Key:** stock **Type:** number **Format:** decimal #### Machined sides **Key:** sides **Type:** number #### Shrink (%) **Key:** shrink **Type:** number **Format:** decimal #### As-cast size (mm) **Key:** cast_size **Type:** number **Expr:** finished + stock * sides **Format:** decimal #### Pattern size (mm) **Key:** pattern **Type:** number **Expr:** (finished + stock * sides) * (1 + shrink / 100) **Format:** decimal #### Pattern minus finished (mm) **Key:** diff **Type:** number **Expr:** (finished + stock * sides) * (1 + shrink / 100) - finished **Format:** decimal **Rows:** **Feature:** Overall length **Type:** Outside **Finished:** 420 **Stock:** 3 **Sides:** 2 **Shrink:** 1 **Feature:** Overall width **Type:** Outside **Finished:** 210 **Stock:** 3 **Sides:** 2 **Shrink:** 1 **Feature:** Flange thickness **Type:** Flange **Finished:** 25 **Stock:** 3 **Sides:** 1 **Shrink:** 1 **Feature:** Housing height **Type:** Height **Finished:** 180 **Stock:** 4 **Sides:** 1 **Shrink:** 1 **Feature:** Pump bore (cored) **Type:** Bore / inside **Finished:** 96 **Stock:** 0 **Sides:** 0 **Shrink:** 1 **Totals:** #### Largest pattern size (mm) **Key:** pattern **Agg:** max **Format:** decimal #### Total pattern growth (mm) **Key:** diff **Agg:** sum **Format:** decimal **Summary:** #### Average growth per feature (mm) **Key:** avg_growth **Expr:** sum_diff / count **Format:** decimal **Notes:** Enter finished size as drawn. For bores formed by cores, an inside dimension shrinks the opposite way so the core box needs the allowance reversed in practice; confirm with your pattern shop. Add draft angles, rapping allowance and distortion allowance separately. ## Content **Intro:** A pattern is larger than the finished part because the metal shrinks on cooling and the casting needs stock for machining. This worksheet applies both to every feature, so you can send a clear pattern dimension table to the pattern shop. **Sections:** #### How to use the worksheet **Body:** List each feature to be controlled on the pattern, such as overall length, flange thickness and boss height. Enter the finished size from the drawing, the machining stock per side, how many sides are machined, and the shrink percent for the alloy. The sheet calculates as-cast size and pattern size. Use the shrinkage table linked here for typical percentages, and replace them with your foundry's own rule. #### The calculation **Body:** As-cast size equals finished size plus machining stock multiplied by the number of machined sides. Pattern size equals as-cast size times one plus shrink divided by 100. The order matters, because the machining stock is metal that must exist in the casting after shrinkage. Applying shrink to the finished size alone leaves the casting too small on machined faces. The last column shows how much larger the pattern is than the finished part. **Bullets:** - Machining stock first, then shrink - Count machined sides, not machined faces in total - Use one shrink value per direction if the casting is restrained #### Other allowances to record **Body:** Draft is added to vertical faces so the pattern withdraws cleanly. Rapping allowance slightly reduces pattern size on faces parallel to the draw direction and compensates for mold enlargement when the pattern is rapped loose. Distortion allowance counters known warping in long thin castings. Machining stock grows with casting size and with the roughness of the process, so large steel castings carry much more than small investment castings. Record these separately from this sheet. #### Common mistakes and ERP notes **Body:** Common mistakes are mixing finished and as-cast dimensions in the same column, using a shrink rule from a different alloy or foundry, and not recording the revision. Pattern equipment is an asset: in the ERP it should link to the item, the drawing revision and the foundry that holds it. A changed shrink factor or machining stock is an engineering change, not just a note on a sheet. **Cta:** If tooling revisions and casting drawings are not tied to items in your ERP, we can help set up a simple link so changes are controlled. **Faq:** #### Do I apply shrinkage before or after machining stock? **Answer:** Add machining stock to the finished size first, then apply the shrink allowance to the total. That ensures the casting still has the intended stock after it contracts. #### How much machining stock should I use? **Answer:** It depends on casting size, alloy and process. Small precision castings may use 1 to 2 mm, while large sand castings often use several millimetres or more per side. Follow your foundry guidance or the applicable casting standard. #### Does the sheet include draft angle? **Answer:** No. Draft is a geometry feature added to faces parallel to the pattern draw. Record it separately on the pattern drawing, or add extra rows with the average added size. #### Can I export this to the pattern shop? **Answer:** Yes. Export to Excel, CSV or PDF and attach it to the pattern request. Make sure the drawing revision and shrink value used are written on the sheet. ## Search terms pattern allowance worksheet, casting pattern dimension calculator, machining allowance and shrinkage casting, pattern making allowances, casting design allowances excel, shrink and machine stock pattern size, foundry pattern drawing calculation, casting drawing allowance sheet --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json