Job Order Generator v2.0

Step 1 — Import BOM Excel

📂

Click to browse or drag & drop your Excel BOM file

Reads Part Number · Description · Qty to Order · Highlight colour → FAB / STD / FAS

Step 2 — Job Details

Job IDMaster→Col B · Order→Col B

Project CodeMaster→Col A (auto-detected)

Job DescriptionMaster→Col C

MO#Master→Col D

SubMaster→Col E

RequesterMaster→Col F

Release DateMaster→Col G

Required DateMaster→Col H

Status – Job Order ListMaster→Col L

Job Master List Preview

APROJECT CODE	BJOB ID	CJOB DESCRIPTION	DMO#	ESUB	FREQUESTER	GRELEASE DATE	HREQUIRED DATE	I	J	K	LSTATUS – JOB ORDER LIST

Copies data rows only · tab-separated · paste directly into SharePoint

Job Order List Preview

A	BJOB ID	C	DPART NUMBER	EDESCRIPTION	FPLANNED QUANTITY	G	H	I	J	K	L	MCATEGORY	NREQUESTER

Single file · exact column layout A–M · Job Master List + Job Order List