I think I have the new Daily Dashboard pretty well dialed in at this point. For most days it appears to be coming up with accurate numbers. The only exceptions are when the plant is closed for a holiday, or maybe when the plant runs on a Saturday. It's difficult to have it account for those oddball days since I really don't know when that is going to happen ahead of time (and my insistence on automating this entirely). Holidays seem to be tricky because while they may not build new cars on a particular holiday, sometimes window stickers will be released on those days. So that creates some challenges in these calculations. But holidays like that aren't super common so its not a big deal. I think about 95% of days this dashboard is showing accurate data.
I have a new script that will run tomorrow a little after 11am. It is simply designed to find the highest VIN window sticker for each model as early as possible in the day. The goal here is to get this Daily Production dashboard populated as early as possible. Once that script is done the normal daily update will kick off.
Right now, if there is no production for any given day, that day just isn't displayed in the table. I do want to go back and make it add those days and just report 0's for the data, but its not a critical feature or anything so I'm not sure when I'll get to it.
I think for now this dashboard is pretty solid.
Site News