Hands-on AI-Assisted Development, Mechanical and Electrical track, Day 3 handout data

When you extract the ZIP, you get 2 folders: data and tools.
Move both of them directly into the tpro-work folder on your desktop.
Keep the files you made on Day 2. Do not delete them.
Then open tpro-work in VS Code with File > Open Folder.

■ data

equipment-data_2026Q3.xlsx
  3 months of data for the 24 machines at Plant 2. It has 3 sheets: Operations, Inspections and Defects.
  It is not in a form you can aggregate as is.

equipment-data_2026Q1.xlsx
  Another quarter from the same plant. Use it in the afternoon when you repeat the morning's work on your own.

quality-inspection_2026H1.csv
maintenance-records_2026H1.csv
  Quality inspection and maintenance records for the first half of the year. If you have time left, load them into tools/02_data-export_skeleton.html to turn the CSV back into xlsx.

records/
  daily-inspection_2026-07.md   Inspection records written as is on the shop floor
  fault-history_2026H1.md       Records of equipment stoppages
  handover-memo_2026-07.txt     A memo written when the assignee changed
  phone-memo_fault-report.txt   Notes taken during a phone call

drawings/
  conveyor-roller-shaft_DRW-2026-042.png             The current revision of the drawing
  conveyor-roller-shaft_DRW-2026-042_old-rev-A.png   The previous revision
  _svg/                                              The same 2 drawings written as text. Have the AI read these
  bom_conveyor-roller-unit-RL-300.md                 The bill of materials for this drawing
  procurement-request_2026-09.md                     A request passed on from the shop floor

■ tools

01_data-loader.html            A tool that opens xlsx in the browser and turns the contents into text
02_data-export_skeleton.html   The outer frame of an export tool. For those with time left
lib/                           Components used by the 2 tools above. If you move only the HTML elsewhere, it stops working

■ Notes

- If you open the xlsx in Excel and save over it, the mess used in the exercises disappears. View the contents with tools/01_data-loader.html.
- If you give the xlsx to GitHub Copilot as is, it asks for permission to run Python and stops. Turn it into text first, then give it to Copilot.
- The tools do not connect to the network. No data leaves the company.
- This data was made for training. It is not related to any real equipment, products or people.
