Excel for Industry Economics 4

What's inside

Excel for Industry Economics 4: 12 courses, 240 hands-on lessons, with a full solutions appendix.

Learn by doing. Every lesson starts with a clear goal and a short explanation, shows the worksheet cell by cell, and gives you tasks to solve on your own computer in Excel, LibreOffice Calc or Google Sheets. When you are done, check your formulas against the solutions and hints in the appendix and correct your sheet.

• 12 complete courses, 240 lessons, 240 exam questions with answers
• Worksheets with row and column labels – easy to type in
• Tasks with exact solutions and hints in the appendix
• All figures are fictional practice data

Every course is also available as an interactive course on tabellab.com, where each cell is checked instantly.

Courses in this book

• Industrial Automation Math: Analog Signal Scaling, Live-Zero Inputs, Tank Levels, Totalisers, Conveyor Speeds & Alarm Limits with Hysteresis
• Sheet Metal Fabrication Quoting: Flat Blanks & Bend Allowance, Nesting & Material Utilisation, Laser Cut Time, Press Brake Time & Batch Pricing
• Waste & Recycling Economics: Collection Routes, Gate Fees, Sorting Recovery Rates, Material Prices, Residue Costs & Cost per Tonne
• Job Sequencing & Shop Scheduling by Hand: FCFS, SPT, EDD, Critical Ratio, Weighted Rules, Johnson's Rule & Changeover Matrices
• Quoting Signs & Large-Format Print: Areas, Roll Media Yield, Ink & Laminate Use, Board Sheets, Machine & Finishing Time, Installation and Job Margins
• Tolerance Stack-Ups & Geometric Tolerancing by the Numbers: Limits & Fits, Loop Diagrams, Worst Case vs Statistical, Position Tolerances, Bonus Tolerance & Allocation
• PLC Logic by Hand: Contacts & Coils, Seal-In Circuits, the Scan Cycle, Edge Detection, Timers, Counters, Step Sequences & Alarm Handling
• Machine Design by Hand: Stress Transformation & Mohr's Circle, Combined Shaft Loads, Von Mises, Fatigue & the Goodman Line, Shaft Sizing, Bearing Life, Gear Forces, Springs & Bolt Preload
• Electric Motors & Transformers by Hand: Turns Ratios, Equivalent Circuits, Voltage Regulation, Efficiency, DC Motor Speed & Torque, Induction Motor Slip, Power Flow & Motor Energy Costs
• Finite Elements by Hand: Spring and Bar Elements, Stiffness Tables, Assembly, Boundary Conditions, Solving by Elimination, Truss Elements, Mesh Refinement & Result Checks
• Land Surveying by the Numbers: Angles & Bearings, Distance Reductions, Closed Traverses, Misclosure & the Bowditch Adjustment, Coordinates, Levelling Runs & Setting Out
• Pneumatics by the Numbers: Cylinder Forces, Air Consumption, Valve Flow, Demand Profiles, Compressor & Receiver Sizing, Pressure Drop, Condensate and the Cost of Compressed Air

Details

Format	PDF, US Letter (8.5 × 11 in)
Language	English
Pages	666
Series	The Tabellab Workbook, volume 4
Author	Babala Özdemir
Delivery	Instant download after payment