Section 9- Using the Calendar Formulas

Manufacturing Corner on

Saturday, November 26, 2022

  Using the Calendar Formulas

The formulas for calculating the job stop time through the calendar, that we developed in section 6, works just as well on days

as it does on hours, so it can be applied to the Julian calendar like this:

Not only can you reference the calendar if it is on another worksheet, but it can also be in another workbook.

Try this experiment:

- open a new workbook  (File|New|Workbook)

- make two windows (Window|Arrage|Horizontal)

- click on the tab of Section 8 and drag the worksheet into the new  

   workbook

- now look at the calendar formulas, and see how they have "followed" 

  the calendar to  its  new workbook

- save the new workbook as "Calendar" in another folder on your hard drive, or 

  elsewhere on your network, and close it

- the formulas establish a link to the calendar, which includes the full path to the 

   workbook

- you can confirm this with Edit|Links

This can be useful if you want several schedules to share the same calendar, but the calculation speed is quicker if the

calendar is in the same workbook.

As with the schedules in Section3 and 4, you can change the hours, or the start of the first job, or the sequence numbers and sort to re-sequence, and see how the calculations respond.

If you try and start before the calendar begins, or you drop off the end of the calendar, the formulas will return errors.

Labels: Scheduling Excel Basic

Thanks for reading Section 9- Using the Calendar Formulas. Please share...!