XLEngineering Excel Prelessons
Demo mode | Demo Student | variant 93d7273d1fe8
Lesson 1 Spreadsheet problem solving Unique workbook version

Turn an engineering question into a spreadsheet model.

This prelesson walks you through identifying givens, choosing equations, planning the process, and placing formulas in a workbook. Your workbook uses a student-specific layout and numbers, so your required formulas and answers are unique to you.

Download your starter workbook

Your Scenario

A lab team runs a small water treatment pump and needs to estimate processed volume and operating cost.

GivenYour valueWorkbook cell
Flow rate13 gal/minE4
Run time36 minE5
Cost rate$0.09 per LE6

Plan Before Calculating

Use the givens to compute processed volume first. Then use the processed volume to compute operating cost.

volume_L = flow_gal/min * time_min * 3.78541
cost = volume_L * cost_per_L

Your workbook must place the volume formula in B12 and the cost formula in B13.

Process Questions

Workbook Upload

Download your starter workbook, enter formulas in B12 and B13, save the `.xlsx`, then upload it here.