FICTIONAL SAMPLE - Contoso Renewables, Quellmoor Ridge Wind Farm and every organisation, person, product and value in this wiki are invented. Not for operational use.
This spreadsheet is a fictional spare-parts stock snapshot for the Quellmoor Ridge O&M building as of 2026-07-21. It covers stock levels, movements, supplier lead times, and ownership information.
Key facts
- The workbook states that it is a fictional spare-parts stock snapshot for the Quellmoor Ridge O&M building dated 2026-07-21.1
- A part is below its minimum level when its On hand quantity is lower than its Minimum quantity.2
- FGT-P-22328, the HSS bearing on the generator side for FGT-3200, is a critical item below minimum stock: 0 pc on hand, minimum 1 pc, reorder quantity 2 pc, and 2 pc on order under PO-76994 for expected delivery on 2026-09-25.23
- LWS-P-30418, the 1.5 kW oil cooler fan motor, is a critical item below minimum stock: 1 pc on hand, minimum 2 pc, reorder quantity 2 pc, and 2 pc on order under PO-77102 for expected delivery on 2026-08-14.24
- PWS-320-D208 is listed as Proseware PWG 320 gear oil in a 208 L drum with a do-not-use note tied to MOC-2025-012; the stock entry shows 1 drum on hand, minimum 0, reorder quantity 0, and 0 on order.5
- The movements sheet records a 2026-03-12 issue of quantity -1 for FGT-P-22328 against WO-26-0187 for WTG-10.6
- The movements sheet records a 2026-06-24 issue of quantity -1 for LWS-P-30418 against WO-26-0398 for WTG-07.7
- The movements sheet records a 2026-07-18 issue of quantity -1 for LWS-P-51207 against WO-26-0436 for WTG-09.8
- Supplier typical lead times are 10 weeks for Fabrikam Getriebetechnik GmbH, 6 weeks for Litware Wind Systems, 3 weeks for Proseware Lubricants, and 2 weeks for Adventure Works Industrial Supply.9101112
- The owner is Tomasz Lebrecht, Stores and Spare Parts Coordinator at Contoso Renewables.13
Contents
Stock
The stock sheet is headed “Stock.”14
The stock table includes entries such as FGT-P-22328, an HSS bearing for FGT-3200 supplied by Fabrikam Getriebetechnik GmbH, and AWI-40388, oil absorbent pads supplied by Adventure Works Industrial Supply.315
The workbook defines a below-minimum part as one whose On hand quantity is lower than its Minimum quantity.2 Under that definition, FGT-P-22328 is below minimum with 0 on hand and a minimum of 1, and LWS-P-30418 is below minimum with 1 on hand and a minimum of 2.34
PWS-320-D208 is listed as Proseware PWG 320 gear oil in a 208 L drum with the note “do not use (MOC-2025-012).”5
Table t01 · sheet "Stock", rows 1–24
| Row | Part number | Description | Supplier | Category | Unit | On hand | Minimum | Reorder qty | On order | PO number | Expected delivery | Bin | Critical |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | FGT-P-22328 | HSS bearing, generator side (FGT-3200) | Fabrikam Getriebetechnik GmbH | Bearings | pc | 0 | 1 | 2 | 2 | PO-76994 | 2026-09-25 | B-04-2 | Y |
| 3 | FGT-P-22331 | HSS bearing, rotor side (FGT-3200) | Fabrikam Getriebetechnik GmbH | Bearings | pc | 1 | 1 | 1 | 0 | B-04-3 | Y | ||
| 4 | FGT-P-21904 | IMS bearing set (FGT-3200) | Fabrikam Getriebetechnik GmbH | Bearings | set | 1 | 1 | 1 | 0 | B-05-1 | Y | ||
| 5 | FGT-P-11872 | Gearbox oil filter element, 10 micron | Fabrikam Getriebetechnik GmbH | Filters | pc | 14 | 12 | 24 | 0 | F-01-1 | Y | ||
| 6 | FGT-P-11880 | Gearbox breather with desiccant | Fabrikam Getriebetechnik GmbH | Filters | pc | 9 | 6 | 12 | 0 | F-01-2 | N | ||
| 7 | FGT-P-13010 | Oil level sight glass with seal | Fabrikam Getriebetechnik GmbH | Gearbox | pc | 2 | 2 | 2 | 0 | G-02-1 | N | ||
| 8 | FGT-P-14002 | Oil sampling valve with dust cap | Fabrikam Getriebetechnik GmbH | Gearbox | pc | 6 | 4 | 6 | 0 | G-02-2 | N | ||
| 9 | LWS-P-30418 | Oil cooler fan motor 1.5 kW | Litware Wind Systems | Electrical | pc | 1 | 2 | 2 | 2 | PO-77102 | 2026-08-14 | E-02-1 | Y |
| 10 | LWS-P-30422 | Oil cooler thermostatic valve insert | Litware Wind Systems | Gearbox | pc | 3 | 2 | 2 | 0 | G-03-1 | N | ||
| 11 | LWS-P-51207 | Generator brush set (18 brushes) | Litware Wind Systems | Electrical | set | 3 | 2 | 4 | 0 | E-03-2 | N | ||
| 12 | LWS-P-55031 | Slip ring cleaning kit | Litware Wind Systems | Electrical | kit | 4 | 2 | 4 | 0 | E-03-3 | N | ||
| 13 | LWS-P-60455 | Pitch bearing bolt kit M30 10.9 (72 bolts) | Litware Wind Systems | Fasteners | kit | 2 | 1 | 2 | 0 | P-01-1 | N | ||
| 14 | LWS-P-41120 | Yaw brake pad set | Litware Wind Systems | Mechanical | set | 4 | 2 | 4 | 0 | M-02-4 | N | ||
| 15 | LWS-P-72210 | Hydraulic accumulator 4 L | Litware Wind Systems | Hydraulics | pc | 2 | 1 | 2 | 0 | H-01-1 | N | ||
| 16 | LWS-P-80031 | Ice detection sensor | Litware Wind Systems | Sensors | pc | 2 | 1 | 1 | 0 | S-01-2 | N | ||
| 17 | LWS-P-90012 | Nacelle hatch gas strut | Litware Wind Systems | Mechanical | pc | 4 | 2 | 4 | 0 | M-03-1 | N | ||
| 18 | PWS-220-D208 | Proseware PWG 220 gear oil, 208 L drum | Proseware Lubricants | Lubricants | drum | 11 | 8 | 6 | 0 | L-01 | Y | ||
| 19 | PWS-320-D208 | Proseware PWG 320 gear oil, 208 L drum - do not use (MOC-2025-012) | Proseware Lubricants | Lubricants | drum | 1 | 0 | 0 | 0 | L-02 | N | ||
| 20 | AWI-10442 | Hydraulic hose assembly DN12, 1.6 m (not stocked) | Adventure Works Industrial Supply | Hydraulics | pc | 0 | 0 | 0 | 0 | H-02-3 | N | ||
| 21 | AWI-20915 | Spill kit refill, 50 L | Adventure Works Industrial Supply | HSE | kit | 5 | 4 | 6 | 0 | HSE-01 | N | ||
| 22 | AWI-31007 | Tool tether set (10 lanyards) | Adventure Works Industrial Supply | HSE | set | 6 | 4 | 4 | 0 | HSE-02 | N | ||
| 23 | AWI-40210 | Nitrile gloves, box of 100 | Adventure Works Industrial Supply | HSE | box | 18 | 10 | 20 | 0 | HSE-03 | N | ||
| 24 | AWI-40388 | Oil absorbent pads, pack of 200 | Adventure Works Industrial Supply | HSE | pack | 7 | 4 | 6 | 0 | HSE-04 | N |
Agents can query this table as t01 with the query_table tool.
Movements
The movements sheet is headed “Movements.”16
Recorded movements include a 2026-03-12 quantity -1 movement of FGT-P-22328 for WTG-10, a 2026-06-24 quantity -1 movement of LWS-P-30418 for WTG-07, and a 2026-07-18 quantity -1 movement of LWS-P-51207 for WTG-09.678
Table t02 · sheet "Movements", rows 1–10
| Row | Date | Part number | Quantity | Reference | Turbine | By |
|---|---|---|---|---|---|---|
| 2 | 2026-03-12 | FGT-P-22328 | -1 | WO-26-0187 | WTG-10 | Tomasz Lebrecht |
| 3 | 2026-04-02 | AWI-31007 | -1 | WO-26-0203 | WTG-11 | Tomasz Lebrecht |
| 4 | 2026-04-14 | AWI-31007 | 4 | PO-76410 | Tomasz Lebrecht | |
| 5 | 2026-05-04 | LWS-P-60455 | -1 | WO-26-0301 | WTG-01 | Tomasz Lebrecht |
| 6 | 2026-06-08 | FGT-P-14002 | -1 | WO-26-0341 | WTG-01 | Tomasz Lebrecht |
| 7 | 2026-06-24 | LWS-P-30418 | -1 | WO-26-0398 | WTG-07 | Tomasz Lebrecht |
| 8 | 2026-06-30 | PWS-220-D208 | 2 | PO-76988 | Tomasz Lebrecht | |
| 9 | 2026-07-07 | AWI-40388 | -1 | WO-26-0430 | WTG-01 | Tomasz Lebrecht |
| 10 | 2026-07-18 | LWS-P-51207 | -1 | WO-26-0436 | WTG-09 | Tomasz Lebrecht |
Agents can query this table as t02 with the query_table tool.
Suppliers
The suppliers sheet is headed “Suppliers.”17
Fabrikam Getriebetechnik GmbH supplies gearbox bearings, filters, and gearbox parts with a typical lead time of 10 weeks.9 Litware Wind Systems supplies turbine spare parts and electrical parts with a typical lead time of 6 weeks.10 Proseware Lubricants supplies gear oil with a typical lead time of 3 weeks.11 Adventure Works Industrial Supply supplies consumables, hydraulic hoses, and HSE items with a typical lead time of 2 weeks.12
Table t03 · sheet "Suppliers", rows 1–5
| Row | Supplier | Supplies | Typical lead time (weeks) | Ordering e-mail |
|---|---|---|---|---|
| 2 | Fabrikam Getriebetechnik GmbH | Gearbox bearings, filters, gearbox parts | 10 | orders@fabrikam-getriebe.example |
| 3 | Litware Wind Systems | Turbine spare parts, electrical parts | 6 | spares@litware-wind.example |
| 4 | Proseware Lubricants | Gear oil | 3 | orders@contoso-renewables.example |
| 5 | Adventure Works Industrial Supply | Consumables, hydraulic hoses, HSE items | 2 | orders@contoso-renewables.example |
Agents can query this table as t03 with the query_table tool.
About
The about sheet is headed “About.”18
The workbook states that the data is fictional and not for operational use, and identifies the file as a spare-parts stock snapshot for the Quellmoor Ridge O&M building.1
The workbook states that a part is below its minimum level when On hand is lower than Minimum.2
The owner is Tomasz Lebrecht, Stores and Spare Parts Coordinator, Contoso Renewables.13
Table t04 · sheet "About", rows 1–5
| Row | FICTIONAL - NOT FOR OPERATIONAL USE |
|---|---|
| 2 | Spare parts stock of the Quellmoor Ridge O&M building, snapshot of 2026-07-21. |
| 3 | A part is below its minimum level when 'On hand' is lower than 'Minimum'. |
| 4 | Owner: Tomasz Lebrecht, Stores and Spare Parts Coordinator, Contoso Renewables. |
| 5 | FICTIONAL - NOT FOR OPERATIONAL USE |
Agents can query this table as t04 with the query_table tool.
Figures
No figures were extracted from this document.
Related
- Assets: Quellmoor Ridge O&M building, Quellmoor Ridge Wind Farm, WTG-01, WTG-07, WTG-09, WTG-10, WTG-11
- Components: gearbox, generator, generator brushes, HSS bearing, IMS bearing, oil cooler, oil cooler fan motor, oil filter element, pitch bearing, pitch bearing bolts, slip ring
- Spare parts: AWI-10442, AWI-20915, AWI-31007, AWI-40210, AWI-40388, FGT-P-11872, FGT-P-11880, FGT-P-13010, FGT-P-14002, FGT-P-21904, FGT-P-22328, FGT-P-22331, LWS-P-30418, LWS-P-30422, LWS-P-41120, LWS-P-51207, LWS-P-55031, LWS-P-60455, LWS-P-72210, LWS-P-80031, LWS-P-90012, PWS-220-D208, PWS-320-D208
- Products: Fabrikam FGT-3200, Proseware PWG 220, Proseware PWG 320
- Organisations: Adventure Works Industrial Supply, Contoso Renewables, Fabrikam Getriebetechnik GmbH, Litware Wind Systems, Proseware Lubricants
- Topics: Gearbox lubrication and oil changes, Gearbox temperature, vibration and oil analysis, Spare parts, stock levels and supply
Sources
Footnotes
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "About", row 2 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "About", row 3 · table ↩ ↩2 ↩3 ↩4 ↩5
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Stock", row 2 · table ↩ ↩2 ↩3
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Stock", row 9 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Stock", row 19 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Movements", row 2 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Movements", row 7 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Movements", row 10 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Suppliers", row 2 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Suppliers", row 3 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Suppliers", row 4 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Suppliers", row 5 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "About", row 4 · table ↩ ↩2
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Stock", row 1 · table ↩
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Stock", row 24 · table ↩
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Movements", row 1 · table ↩
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "Suppliers", row 1 · table ↩
-
Spare Parts Stock Snapshot 2026-07-21 for Quellmoor Ridge O&M Building — sheet "About", row 1 · table ↩
Provenance badgestable values parsed deterministically from the cited table rows