@jassyo06,
@Mike.46 , @all, do appreciate the kind words and thank you all for feeding wealth of information to make the contents of the spreadsheet useful to give some insight to the fuzziness. It is becoming clearer when Audi batch cars, its based upon variant, body type and colour and are working by order of date when submitted into the system
AND filling in later orders into that batch profile. Hence the randomness.
The Factory number seems to have construct: YYWW????
YY = 29,30,31,32 (2019,2020,2021,2022)
WW = odd years ww+10, even years ww+0 eg.. for (2021 week 32 become 42) and for (2022 week 01 = 01)
???? = incrementing number from 0001 for a week? dont know.
So.. for me as an example, my order was placed on week 32 in 2021, but the Audi system acknowledged it on 33, so my order number is 3143?????, hence built in delay due to multiple handoffs before order is entered. ? Bigger the franchise longer the delay, is my take.
Anyhow, I am glad the of the contents of the spreadsheet and the pattern of events are helping us all while, forced to wait for our new toys.