Robot bill of materials and test log template (copy and paste)

Keep two sheets from day one: what you bought and what you tested. Paste the headers below into a spreadsheet (comma separated) and fill in your own prices, links and results.

Bill of materials

Item,Part number or spec,Qty,Unit price (INR),Shop,Date bought,Used in,Notes
Example: microcontroller board,(your board),1,(price you paid),(shop),(date),(subsystem),(why you chose it)
  • Record the price you actually paid, including shipping, and the shop.
  • Add a “spare” line for parts that burn out easily, such as drivers and regulators.
  • Total the sheet and compare with your budget before you order.

Test log

Date,Subsystem,Test,Setup,Expected,Measured,Pass or fail,Fix or next step
(date),(motors),(spin both wheels),(battery full),(equal speed),(your measurement),(result),(what you changed)
  • Test one subsystem at a time: power, motors, sensors, then the whole robot.
  • Write failures down in the same sheet. They become your “problems and fixes” chapter.
  • Photograph the setup so you can repeat the test.

Pin map

Signal,Board pin,Connected to,Notes
(motor A direction),(pin),(driver input),(avoid strapping pins on ESP32)

For ESP32 boards check the ESP32 pinout for robotics before you assign pins.

Report template, Viva questions, Project build sheets, Calculators.

Last reviewed: November 2026. Free to copy and adapt for your own project and college work. Keep your own measurements and results; do not copy figures from this page into a report as if you measured them.

How to set up the spreadsheet

Paste each header block into its own sheet. Add a column for the line total next to the unit price, so the sheet can add everything up. If quantity is in column C, unit price in column D and the line total in column I, row 2 uses these formulas:

I2: =C2*D2
I21: =SUM(I2:I20)
I22: =I21*0.1
I23: =I21+I22

Row 21 is the total, row 22 a contingency of 10 percent (choose your own figure), and row 23 the budget with contingency. Change the row numbers to fit your sheet.

What to record in each column

  • Part number or spec: the exact name from the seller and the key ratings, such as voltage and current.
  • Unit price: what you paid, including tax and shipping split across the items. Note the date, because prices change.
  • Used in: the subsystem it belongs to, such as drive, sensing or power. This lets you cost each part of the robot.
  • Notes: why you chose it and what you replaced, which helps in the viva.

Keeping the test log useful

Write the expected result before you run the test, then the measured result. If they differ, write a cause and the fix. Keep units in the column names or cells. Photograph or record the setup so someone else can repeat the test. A short log with real entries is worth more than a long log with vague ones.

Common mistakes

  • Leaving out shipping, spare parts and tools from the budget.
  • Writing ‘works’ in the result column without a number.
  • Losing track of which version of the code a test used. Add a column for the code version or date.