| Macro10 | Auto_Open |
| =WORKBOOK.SELECT("Full Schedule") | =ERROR(2,Recover) |
| =SELECT("R4C1:R173C1,R4C3:R173C5,R4C11:R173C11,R4C13:R173C16") | =WORKBOOK.SELECT("Full Schedule") |
| =RUN("Macro2") | =WINDOW.RESTORE() |
| =SELECT("R4C2:R173C2,R4C19:R173C20") | =WINDOW.SIZE(82.5,42.75) |
| =RUN("Macro3") | =WORKBOOK.HIDE("Macro1",TRUE) |
| =SELECT("R4C6:R173C6,R4C9:R173C10,R4C12:R173C12") | =EDIT.COLOR(1,0,0,0) |
| =RUN("Macro4") | =EDIT.COLOR(3,255,0,0) |
| =SELECT("R4C7:R173C8") | =EDIT.COLOR(6,255,255,181) |
| =RUN("Macro5") | =EDIT.COLOR(5,204,204,204) |
| =SELECT("R4C17:R173C18,R4C21:R173C22") | =EDIT.COLOR(4,212,212,212) |
| =RUN("Macro6") | =EDIT.COLOR(2,255,255,255) |
| =SELECT("R4C7:R173C7,R4C8:R173C8") | =RUN("Macro1") |
| =FORMAT.NUMBER("#####################################0") | =RUN("Macro10") |
| =SELECT("R4C6:R173C6,R4C9:R173C9,R4C10:R173C10") | =DELETE.NAME("Auto_Open") |
| =FORMAT.NUMBER("####0") | =WORKBOOK.SELECT("Full Schedule") |
| =SELECT("R4C12:R173C12") | =SELECT("R1:R65536") |
| =FORMAT.NUMBER("##.00") | =COLUMN.WIDTH(,,,3) |
| =SELECT("R4C13:R173C13,R4C14:R173C14") | =ROW.HEIGHT(,,,3) |
| =FORMAT.NUMBER("mmm-dd") | =SELECT("R1C1") |
| =SELECT("R1C1:R1C5,R3C1,R3C3:R3C6,R3C9:R3C12,R3C15:R3C22") | =WINDOW.MAXIMIZE() |
| =RUN("Macro7") | =RETURN() |
| =SELECT("R3C2,R3C13:R3C14") | |
| =RUN("Macro8") | |
| =SELECT("R3C7:R3C8") | |
| =RUN("Macro9") | |
| =RETURN() | |
| Macro2 | |
| =ALIGNMENT(2,FALSE,1,0,FALSE) | |
| =BORDER(0,0,0,0,0,0,0,0,0,0,0) | |
| =PATTERNS(1,0,2,TRUE) | |
| =FORMAT.FONT("Arial",8,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE) | |
| =RETURN() | |
| Macro3 | |
| =ALIGNMENT(2,FALSE,2,0,FALSE) | |
| =BORDER(0,0,0,0,0,0,0,0,0,0,0) | |
| =PATTERNS(1,0,2,TRUE) | |
| =FORMAT.FONT("Arial",8,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE) | |
| =RETURN() | |
| Macro4 | |
| =ALIGNMENT(4,FALSE,1,0,FALSE) | |
| =BORDER(0,0,0,0,0,0,0,0,0,0,0) | |
| =PATTERNS(1,0,2,TRUE) | |
| =FORMAT.FONT("Arial",8,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE) | |
| =RETURN() | |
| Macro5 | |
| =ALIGNMENT(4,FALSE,1,0,FALSE) | |
| =BORDER(0,0,0,0,0,0,0,0,0,0,0) | |
| =PATTERNS(1,0,6,TRUE) | |
| =FORMAT.FONT("Arial",8,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE) | |
| =RETURN() | |
| Macro6 | |
| =ALIGNMENT(4,FALSE,2,0,FALSE) | |
| =BORDER(0,0,0,0,0,0,0,0,0,0,0) | |
| =PATTERNS(1,0,2,TRUE) | |
| =FORMAT.FONT("Arial",8,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE) | |
| =RETURN() | |
| Macro7 | |
| =ALIGNMENT(2,FALSE,2,0,FALSE) | |
| =BORDER(0,0,0,0,0,0,0,0,0,0,0) | |
| =PATTERNS(1,0,5,TRUE) | |
| =FORMAT.FONT("Arial",9,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE) | |
| =RETURN() | |
| Macro8 | |
| =ALIGNMENT(3,TRUE,2,0,FALSE) | |
| =BORDER(0,0,0,0,0,0,0,0,0,0,0) | |
| =PATTERNS(1,0,5,TRUE) | |
| =FORMAT.FONT("Arial",9,TRUE,FALSE,FALSE,FALSE,1,FALSE,FALSE) | |
| =RETURN() | |
| Macro9 | |
| =ALIGNMENT(2,TRUE,2,0,FALSE) | |
| =BORDER(0,0,0,0,0,0,0,0,0,0,0) | |
| =PATTERNS(1,0,6,TRUE) | |
| =FORMAT.FONT("Arial",9,FALSE,FALSE,FALSE,FALSE,1,FALSE,FALSE) | |
| =RETURN() | |
| Recover | |
| =GOTO(ABSREF("R[1]C[0]",LAST.ERROR())) | |
| =RETURN() | |
| Macro1 | |
| =WORKBOOK.SELECT("Full Schedule") | |
| =SELECT("R4C7") | |
| =FORMULA("=RC[-1]-RC[1]") | |
| =FILL.AUTO("RC:R[169]C",4) | |
| =SELECT("R4C7") | |
| =RETURN() | |