VIN CREATOR

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	MUSTANG MACH-E UK VIN & CHECK DIGIT GENERATOR
2	Instructions: Some Ford Dealerships will only release the last 5 digits of your VIN number. Using this spreadsheet you can create the full VIN by selecting a model in Step 1, and then entering the 5 digit serial number in Step 2. Your check digit will be calculated as you type, providing your full VIN number below...
3
4
5	STEP 1: CHOOSE YOUR MODEL													STEP 2: ENTER YOUR 5 DIGIT SERIAL #
6			↓													↓	↓	↓	↓	↓
7			6	←	←	←	1 = UK RWD SR							#	A	0	7	3	2	1
8			↑				2 = UK RWD ER									↑	↑	↑	↑	↑
9							3 = UK AWD SR
10							4 = UK AWD ER							STEP 3: ENTER THE PRODUCTION YEAR
11							5 = UK 1ST EDITION
12							6 = UK GT								2	←	←	1 = 2021
13																		2 = 2022
14
15				MANUFACTURER ID			RESTRAINT SYSTEM	MODEL TYPE			DRIVE TRAIN	CHECK DIGIT	MODEL YEAR	ASSEMBLY PLANT	NUMERICAL SEQUENCE VEHICLE IDENTIFIER
16		VIN DIGIT		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
17		VIN IN		W	F	0	T	R	4	S	X	???	N	M	A	0	7	3	2	1
18		Translation		6	6	0	3	9	4	2	7	0	5	4	1	0	7	3	2	1
19		Weighting		8	7	6	5	4	3	2	10	0	9	8	7	6	5	4	3	2
20		Result		48	42	0	15	36	12	4	70	0	45	32	7	0	35	12	6	2
21		Product Sum		366								3
22		VIN OUT		W	F	0	T	R	4	S	X	3	N	M	A	0	7	3	2	1
23
24	→	YOUR VIN:		WF0TR4SX3NMA07321																	←
25		(Only valid when STEPS 1-3 have been fully completed)
26
27		© 2022 Wonky_Donkey
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54		Model Lookup								Year Lookup
55		1	UK RWD SR		1	R	M			1	2021	M
56		2	UK RWD ER		1	R	7			2	2022	N
57		3	UK AWD SR		3	S	S
58		4	UK AWD ER		3	S	U
59		5	UK FIRST ED		3	S	U
60		6	UK GT		4	S	X
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100