Build Week Tracking Spreadsheets 📊

[markleg]

What happened to the 5-30-Group link?

Sponsored

 

[ATLbronco]

Hey @ocbucks1, would you mind creating a spreadsheet for us in the 8/22 build week group?

 

[ocbucks1]

Hey @ocbucks1, would you mind creating a spreadsheet for us in the 8/22 build week group?

You got it. I’ll post in your thread when ready. By tomorrow.

 

[ATLbronco]

You got it. I’ll post in your thread when ready. By tomorrow.

Thanks!

 

[CindySue612]

Can you start a build week of 8/8 sheet?

 

[66Fan]

Can you start a build week of 8/8 sheet?

Bronco Build Week 08-08-2022

 

[CindySue612]

Bronco Build Week 08-08-2022

Thank you, but on the data tab, it says "You are trying to edit a protected cell or object. Please contact the spreadsheet owner to remove protection if you need to edit."

 

[sniffHound]

Bronco Build Week 08-08-2022

Can you help.Docs is only letting me make this view only.

 

[66Fan]

Thank you, but on the data tab, it says "You are trying to edit a protected cell or object. Please contact the spreadsheet owner to remove protection if you need to edit."

Try again please... I accidentally restricted permissions.

 

[CindySue612]

Thank you, but on the data tab, it says "You are trying to edit a protected cell or object. Please contact the spreadsheet owner to remove protection if you need to edit."

It works now! THANK YOU!

 

[66Fan]

Hey all!
Here's the link for the build week tracker template:
Template


Recent build week sheets:
Bronco Build Week 08-01-2022
Bronco Build Week 08-08-2022
Bronco Build Week 08-15-2022
Bronco Build Week 08-22-2022
Bronco Build Week 08-29-2022
Bronco Build Week 09-05-2022
Bronco Build Week 09-12-2022
Bronco Build Week 09-19-2022
Bronco Build Week 09-26-2022

Haven't seen October Dates yet... will create as needed.

If you want to make a copy and host, that's cool.
If you want me to set it up and host, that's also fine - just send me a message.
Instructions on setup are in the README and on the "Setup for new build week" tab.
Simple stuff.

The long and short of it is that you only need to edit one field (enter the desired build week) on the Template and press a button to create a new sheet. This is done on the "Setup for new build week" tab pictured below. Put your week in the grey cell and press the "Create New Sheet" button. That will run a script in the background to create the sheet with the correct name and then clear the sample data.

Once the script completes press the Green Sheets Home icon in the upper left

Then select the newly created build week aheet and begin editing.

I'll try to preemptively create and post sheets for each week as they create threads.
Enjoy!

 

[66Fan]

Hey all!
Here's the link for the build week tracker template:
Template

****** 23Aug Update ******

Consolidated Build Week Sheet
The consolidated sheet currently displays information for Aug15 - Sep26 2022 Build Week sheets.
It is non-editable, but is replicated with the source sheets, so any changes to build week sheets below will update the consolidated sheet in real time. If data in the consolidated sheet needs updated, do that in the base build week sheet.
It is a work in progress and more meaningful charts will be added as time allows.

****** End 23Aug Update ******

Recent build week sheets (These are links to the active sheets in use in their respective threads):
Bronco Build Week 08-01-2022
Bronco Build Week 08-08-2022
Bronco Build Week 08-15-2022
Bronco Build Week 08-22-2022
Bronco Build Week 08-29-2022
Bronco Build Week 09-05-2022
Bronco Build Week 09-12-2022
Bronco Build Week 09-19-2022
Bronco Build Week 09-26-2022
Bronco Build Week 10-03-2022

Haven't seen October Dates yet... will create as needed.

If you want to make a copy and host, that's cool.
If you want me to set it up and host, that's also fine - just send me a message.
Instructions on setup are in the README and on the "Setup for new build week" tab.
Simple stuff.

The long and short of it is that you only need to edit one field (enter the desired build week) on the Template and press a button to create a new sheet. This is done on the "Setup for new build week" tab pictured below. Put your week in the grey cell and press the "Create New Sheet" button. That will run a script in the background to create the sheet with the correct name and then clear the sample data.

Once the script completes press the Green Sheets Home icon in the upper left

Then select the newly created build week aheet and begin editing.

I'll try to preemptively create and post sheets for each week as they create threads.
Enjoy!

 

[mbelding816]

Hey all!
Here's the link for the build week tracker template:
Template

****** 23Aug Update ******

Consolidated Build Week Sheet
The consolidated sheet currently displays information for Aug15 - Sep26 2022 Build Week sheets.
It is non-editable, but is replicated with the source sheets, so any changes to build week sheets below will update the consolidated sheet in real time. If data in the consolidated sheet needs updated, do that in the base build week sheet.
It is a work in progress and more meaningful charts will be added as time allows.

****** End 23Aug Update ******

Recent build week sheets (These are links to the active sheets in use in their respective threads):
Bronco Build Week 08-01-2022
Bronco Build Week 08-08-2022
Bronco Build Week 08-15-2022
Bronco Build Week 08-22-2022
Bronco Build Week 08-29-2022
Bronco Build Week 09-05-2022
Bronco Build Week 09-12-2022
Bronco Build Week 09-19-2022
Bronco Build Week 09-26-2022
Bronco Build Week 10-03-2022

Haven't seen October Dates yet... will create as needed.

If you want to make a copy and host, that's cool.
If you want me to set it up and host, that's also fine - just send me a message.
Instructions on setup are in the README and on the "Setup for new build week" tab.
Simple stuff.

The long and short of it is that you only need to edit one field (enter the desired build week) on the Template and press a button to create a new sheet. This is done on the "Setup for new build week" tab pictured below. Put your week in the grey cell and press the "Create New Sheet" button. That will run a script in the background to create the sheet with the correct name and then clear the sample data.

Once the script completes press the Green Sheets Home icon in the upper left

Then select the newly created build week aheet and begin editing.

I'll try to preemptively create and post sheets for each week as they create threads.
Enjoy!

I am having issues adding myself to the 9/12 and 9/19 build sheets. I was originally scheduled for the week of 9/12 but was bumped to 9/19 last night. Can you assist me in adding my information to the spreadsheets?

 

[66Fan]

I am having issues adding myself to the 9/12 and 9/19 build sheets. I was originally scheduled for the week of 9/12 but was bumped to 9/19 last night. Can you assist me in adding my information to the spreadsheets?

Hey Michelle,
Entry is restricted on the consolidated sheet, so if you were trying that one, you'd need to go to the actual week's sheet.
If ya still can't get it entered, reply back with your details and I will enter.
Don't know why you wouldn't be able to add... I'll look at the 09-19 spreadsheet to see if someone has jacked with permissions.

Ill need the following:
User Name, Reservation/Order Date , Original Build Week, Delivery City/State, Model, Engine, Trans, Top, Doors, Package, Sasquatch, HOSS, TOW PKG, Color


Thanks!
Tim

BTW - which dealer are you at? I'm near STL also. I ordered from Laura in Sullivan, MO.

 

[mbelding816]

Hey Michelle,
Entry is restricted on the consolidated sheet, so if you were trying that one, you'd need to go to the actual week's sheet.
If ya still can't get it entered, reply back with your details and I will enter.
Don't know why you wouldn't be able to add... I'll look at the 09-19 spreadsheet to see if someone has jacked with permissions.

Ill need the following:
User Name, Reservation/Order Date , Original Build Week, Delivery City/State, Model, Engine, Trans, Top, Doors, Package, Sasquatch, HOSS, TOW PKG, Color


Thanks!
Tim

BTW - which dealer are you at? I'm near STL also. I ordered from Laura in Sullivan, MO.

I am good to go now! I was able to add to both the 9/12 and 9/19 build week sheets.

I actually ordered from Akins Ford in Winder, GA. I have chatted with several members on BN that ordered from Laura, but are getting bumped to MY23.

Sponsored