Project Planner Worksheet, Weekday-Only Version, Crit Path Finder 8 40 12 14 9 9 9 8 4 6 10 10 10 10 10 10 10 8 20 P 1, 1,Function -1,F9.2 , 2 P 2, 1,Preconditions -1,F9.2 , 2 P 3, 1,Start -1,F9.2 , 2 P 4, 1,Duration -1,F9.2 , 2 P 5, 1,End -1,F9.2 , 2 P 6, 1,Proj Start -1,F9.2 , 2 P 7, 1,MAX[G3:G6] 1,F9.2 , 2 P 8, 1,A=24.\24./(G1-G2+.000001)\H1=%\IF [H1.GT.A0]H1=A | H1=H1 1,F7.1 , 2 P 9, 1, Crt -1,F9.2 , 2 P 10, 1, Resrc -1,F9.2 , 2 P 11, 1,A1=1.0\H=CNT[G1:G400]-3.0 1,F9.2 , 2 P 13, 1,Total Res Used -1,F9.2 , 2 P 1, 2,Name -1,F9.2 , 2 P 2, 2,(Addresses) -1,F9.2 , 2 P 3, 2,Date -1,F9.2 , 2 P 4, 2,(Days) -1,F9.2 , 2 P 5, 2,Date -1,F9.2 , 2 P 6, 2,85/09/15 -3,F9.2 , 2 P 7, 2,*U JDATE F2\A2=%-1. 1,F9.2 , 2 P 9, 2,P## 3,F3.0 , 2 P 10, 2,D=0. 1,F4.0 , 2 P 1, 3,SETUP -1,F9.2 , 2 P 2, 3,A2 -1,F9.2 , 2 P 3, 3,85/09/15 -1,F9.2 , 2 P 4, 3,5. 3,F7.1 , 2 P 5, 3,85/09/23 -1,F9.2 , 2 P 6, 3,MAX[{B3]+1.\F3=%\*U WKDIN F3,A1\F3=% 1,F8.1 , 2 P 7, 3,G3=F3\*U JTOCH G3,C3\*U WKDIN G3,D3\G3=%\*U JTOCH G3,E3\A3=G3\%=G3 1,F9.2 , 2 P 8, 3,C3=F3\E3=G3\R=P\N=G3-G$1$\S=Q 1,F8.1 , 2 P 9, 3,P## 3,F3.0 , 2 P 10, 3,2. 3,F4.0 , 2 P 11, 3,B=H$1$*(F3-G$2$)+3.\C=H$1$*(G3-G$2$)+3.\D=0.\*U XQTCM CR J3 P#%BD:P#%CD -1,F9.2 , 2 P 12, 3,IF [N0.EQ.D0]M=1. | M=I3 \I3=MAX[M0,I3]\*P@ R0,S0\*P P#8#0 \IF [M0.GT.D0] P##=M | P##=MAX[I3,P##] -1,F9.2 , 2 P 1, 4,MIDDLE A -1,F9.2 , 2 P 2, 4,A3 -1,F9.2 , 2 P 3, 4,85/09/24 -1,F9.2 , 2 P 4, 4,5. 3,F7.1 , 2 P 5, 4,85/10/01 -1,F9.2 , 2 P 6, 4,MAX[{B4]+1. 1,F8.1 , 2 P 7, 4,G4=F4\*U JTOCH G4,C4\*U WKDIN G4,D4\G4=%\*U JTOCH G4,E4\A4=G4\%=G4 1,F9.2 , 2 P 8, 4,C4=F4\E4=G4\R=P\N=G4-G$1$\S=Q 1,F8.1 , 2 P 9, 4,P## 3,F3.0 , 2 P 10, 4,2. 3,F4.0 , 2 P 11, 4,B=H$1$*(F4-G$2$)+3.\C=H$1$*(G4-G$2$)+3.\D=0.\*U XQTCM CR J4 P#%BD:P#%CD -1,F9.2 , 2 P 12, 4,IF [N0.EQ.D0]M=1. | M=I4 \I4=MAX[M0,I4]\*P@ R0,S0\*P P#8#0 \IF [M0.GT.D0] P##=M | P##=MAX[I4,P##] -1,F9.2 , 2 P 1, 5,MIDDLE B -1,F9.2 , 2 P 2, 5,A3 -1,F9.2 , 2 P 3, 5,85/09/24 -1,F9.2 , 2 P 4, 5,5. 3,F7.1 , 2 P 5, 5,85/10/01 -1,F9.2 , 2 P 6, 5,MAX[{B5]+1. 1,F8.1 , 2 P 7, 5,G5=F5\*U JTOCH G5,C5\*U WKDIN G5,D5\G5=%\*U JTOCH G5,E5\A5=G5\%=G5 1,F9.2 , 2 P 8, 5,C5=F5\E5=G5\R=P\N=G5-G$1$\S=Q 1,F8.1 , 2 P 9, 5,P## 3,F3.0 , 2 P 10, 5,2. 3,F4.0 , 2 P 11, 5,B=H$1$*(F5-G$2$)+3.\C=H$1$*(G5-G$2$)+3.\D=0.\*U XQTCM CR J5 P#%BD:P#%CD -1,F9.2 , 2 P 12, 5,IF [N0.EQ.D0]M=1. | M=I5 \I5=MAX[M0,I5]\*P@ R0,S0\*P P#8#0 \IF [M0.GT.D0] P##=M | P##=MAX[I5,P##] -1,F9.2 , 2 P 1, 6,END -1,F9.2 , 2 P 2, 6,A3:A5 -1,F9.2 , 2 P 3, 6,85/10/02 -1,F9.2 , 2 P 4, 6,5. 3,F7.1 , 2 P 5, 6,85/10/09 -1,F9.2 , 2 P 6, 6,MAX[{B6]+1. 1,F8.1 , 2 P 7, 6,G6=F6\*U JTOCH G6,C6\*U WKDIN G6,D6\G6=%\*U JTOCH G6,E6\A6=G6\%=G6 1,F9.2 , 2 P 8, 6,C6=F6\E6=G6\R=P\N=G6-G$1$\S=Q 1,F8.1 , 2 P 9, 6,P## 3,F3.0 , 2 P 10, 6,2. 3,F4.0 , 2 P 11, 6,B=H$1$*(F6-G$2$)+3.\C=H$1$*(G6-G$2$)+3.\D=0.\*U XQTCM CR J6 P#%BD:P#%CD -1,F9.2 , 2 P 12, 6,IF [N0.EQ.D0]M=1. | M=I6 \I6=MAX[M0,I6]\*P@ R0,S0\*P P#8#0 \IF [M0.GT.D0] P##=M | P##=MAX[I6,P##] -1,F9.2 , 2 P 14, 7,SUM[N3:N6] 1,F5.0 , 2 P 15, 7,SUM[O3:O6] 1,F5.0 , 2 P 16, 7,SUM[P3:P6] 1,F5.0 , 2 P 17, 7,SUM[Q3:Q6] 1,F5.0 , 2 P 18, 7,SUM[R3:R6] 1,F5.0 , 2 P 19, 7,SUM[S3:S6] 1,F5.0 , 2 P 20, 7,SUM[T3:T6] 1,F5.0 , 2 P 21, 7,SUM[U3:U6] 1,F5.0 , 2 P 22, 7,SUM[V3:V6] 1,F5.0 , 2 P 23, 7,SUM[W3:W6] 1,F5.0 , 2 P 24, 7,SUM[X3:X6] 1,F5.0 , 2 P 25, 7,SUM[Y3:Y6] 1,F5.0 , 2 P 26, 7,SUM[Z3:Z6] 1,F5.0 , 2 P 27, 7,SUM[AA3:AA6] 1,F5.0 , 2 P 28, 7,SUM[AB3:AB6] 1,F5.0 , 2 P 29, 7,SUM[AC3:AC6] 1,F5.0 , 2 P 30, 7,SUM[AD3:AD6] 1,F5.0 , 2 P 31, 7,SUM[AE3:AE6] 1,F5.0 , 2 P 32, 7,SUM[AF3:AF6] 1,F5.0 , 2 P 33, 7,SUM[AG3:AG6] 1,F5.0 , 2 P 34, 7,SUM[AH3:AH6] 1,F5.0 , 2 P 35, 7,SUM[AI3:AI6] 1,F5.0 , 2 P 36, 7,SUM[AJ3:AJ6] 1,F5.0 , 2 P 37, 7,SUM[AK3:AK6] 1,F5.0 , 2 M64001,64001, 1 2 1,F5.0 , 2 M64001,64002, 1 3 1,F5.0 , 2 M64001,64003, 1 4 1,F5.0 , 2 M64001,64004, 1 5 1,F5.0 , 2 M64001,64005, 1 6 1,F5.0 , 2 M64001,64006, 1 7 1,F5.0 , 2 M64001,64007, 1 8 1,F5.0 , 2 M64001,64008, 1 9 1,F5.0 , 2 M64001,64009, 1 10 1,F5.0 , 2 M64001,64010, 1 11 1,F5.0 , 2 M64001,64011, 1 12 1,F5.0 , 2 M64001,64012, 1 13 1,F5.0 , 2 M64001,64013, 1 14 1,F5.0 , 2 M64001,64014, 1 15 1,F5.0 , 2 M64001,64015, 1 16 1,F5.0 , 2 M64001,64016, 1 17 1,F5.0 , 2 M64001,64017, 1 18 1,F5.0 , 2 M64001,64018, 1 19 1,F5.0 , 2 M64001,64019, 1 20 1,F5.0 , 2 M64001,64020, 1 21 1,F5.0 , 2 M64002,64001, 2 2 1,F5.0 , 2 M64002,64002, 2 3 1,F5.0 , 2 M64002,64003, 2 4 1,F5.0 , 2 M64002,64004, 2 5 1,F5.0 , 2 M64002,64005, 2 6 1,F5.0 , 2 M64002,64006, 2 7 1,F5.0 , 2 M64002,64007, 2 8 1,F5.0 , 2 M64002,64008, 2 9 1,F5.0 , 2 M64002,64009, 2 10 1,F5.0 , 2 M64002,64010, 2 11 1,F5.0 , 2 M64002,64011, 2 12 1,F5.0 , 2 M64002,64012, 2 13 1,F5.0 , 2 M64002,64013, 2 14 1,F5.0 , 2 M64002,64014, 2 15 1,F5.0 , 2 M64002,64015, 2 16 1,F5.0 , 2 M64002,64016, 2 17 1,F5.0 , 2 M64002,64017, 2 18 1,F5.0 , 2 M64002,64018, 2 19 1,F5.0 , 2 M64002,64019, 2 20 1,F5.0 , 2 M64002,64020, 2 21 1,F5.0 , 2 M64003,64001, 3 2 1,F5.0 , 2 M64003,64002, 3 3 1,F5.0 , 2 M64003,64003, 3 4 1,F5.0 , 2 M64003,64004, 3 5 1,F5.0 , 2 M64003,64005, 3 6 1,F5.0 , 2 M64003,64006, 3 7 1,F5.0 , 2 M64003,64007, 3 8 1,F5.0 , 2 M64003,64008, 3 9 1,F5.0 , 2 M64003,64009, 3 10 1,F5.0 , 2 M64003,64010, 3 11 1,F5.0 , 2 M64003,64011, 3 12 1,F5.0 , 2 M64003,64012, 3 13 1,F5.0 , 2 M64003,64013, 3 14 1,F5.0 , 2 M64003,64014, 3 15 1,F5.0 , 2 M64003,64015, 3 16 1,F5.0 , 2 M64003,64016, 3 17 1,F5.0 , 2 M64003,64017, 3 18 1,F5.0 , 2 M64003,64018, 3 19 1,F5.0 , 2 M64003,64019, 3 20 1,F5.0 , 2 M64003,64020, 3 21 1,F5.0 , 2 M64004,64001, 4 2 1,F5.0 , 2 M64004,64002, 4 3 1,F5.0 , 2 M64004,64003, 4 4 1,F5.0 , 2 M64004,64004, 4 5 1,F5.0 , 2 M64004,64005, 4 6 1,F5.0 , 2 M64004,64006, 4 7 1,F5.0 , 2 M64004,64007, 4 8 1,F5.0 , 2 M64004,64008, 4 9 1,F5.0 , 2 M64004,64009, 4 10 1,F5.0 , 2 M64004,64010, 4 11 1,F5.0 , 2 M64004,64011, 4 12 1,F5.0 , 2 M64004,64012, 4 13 1,F5.0 , 2 M64004,64013, 4 14 1,F5.0 , 2 M64004,64014, 4 15 1,F5.0 , 2 M64004,64015, 4 16 1,F5.0 , 2 M64004,64016, 4 17 1,F5.0 , 2 M64004,64017, 4 18 1,F5.0 , 2 M64004,64018, 4 19 1,F5.0 , 2 M64004,64019, 4 20 1,F5.0 , 2 M64004,64020, 4 21 1,F5.0 , 2 M64005,64001, 5 2 1,F5.0 , 2 M64005,64002, 5 3 1,F5.0 , 2 M64005,64003, 5 4 1,F5.0 , 2 M64005,64004, 5 5 1,F5.0 , 2 M64005,64005, 5 6 1,F5.0 , 2 M64005,64006, 5 7 1,F5.0 , 2 M64005,64007, 5 8 1,F5.0 , 2 M64005,64008, 5 9 1,F5.0 , 2 M64005,64009, 5 10 1,F5.0 , 2 M64005,64010, 5 11 1,F5.0 , 2 M64005,64011, 5 12 1,F5.0 , 2 M64005,64012, 5 13 1,F5.0 , 2 M64005,64013, 5 14 1,F5.0 , 2 M64005,64014, 5 15 1,F5.0 , 2 M64005,64015, 5 16 1,F5.0 , 2 M64005,64016, 5 17 1,F5.0 , 2 M64005,64017, 5 18 1,F5.0 , 2 M64005,64018, 5 19 1,F5.0 , 2 M64005,64019, 5 20 1,F5.0 , 2 M64005,64020, 5 21 1,F5.0 , 2 M64006,64001, 6 2 1,F5.0 , 2 M64006,64002, 6 3 1,F5.0 , 2 M64006,64003, 6 4 1,F5.0 , 2 M64006,64004, 6 5 1,F5.0 , 2 M64006,64005, 6 6 1,F5.0 , 2 M64006,64006, 6 7 1,F5.0 , 2 M64006,64007, 6 8 1,F5.0 , 2 M64006,64008, 6 9 1,F5.0 , 2 M64006,64009, 6 10 1,F5.0 , 2 M64006,64010, 6 11 1,F5.0 , 2 M64006,64011, 6 12 1,F5.0 , 2 M64006,64012, 6 13 1,F5.0 , 2 M64006,64013, 6 14 1,F5.0 , 2 M64006,64014, 6 15 1,F5.0 , 2 M64006,64015, 6 16 1,F5.0 , 2 M64006,64016, 6 17 1,F5.0 , 2 M64006,64017, 6 18 1,F5.0 , 2 M64006,64018, 6 19 1,F5.0 , 2 M64006,64019, 6 20 1,F5.0 , 2 M64006,64020, 6 21 1,F5.0 , 2 M64007,64001, 9 2 1,F5.0 , 2 M64007,64002, 9 3 1,F5.0 , 2 M64007,64003, 9 4 1,F5.0 , 2 M64007,64004, 9 5 1,F5.0 , 2 M64007,64005, 9 6 1,F5.0 , 2 M64007,64006, 9 7 1,F5.0 , 2 M64007,64007, 9 8 1,F5.0 , 2 M64007,64008, 9 9 1,F5.0 , 2 M64007,64009, 9 10 1,F5.0 , 2 M64007,64010, 9 11 1,F5.0 , 2 M64007,64011, 9 12 1,F5.0 , 2 M64007,64012, 9 13 1,F5.0 , 2 M64007,64013, 9 14 1,F5.0 , 2 M64007,64014, 9 15 1,F5.0 , 2 M64007,64015, 9 16 1,F5.0 , 2 M64007,64016, 9 17 1,F5.0 , 2 M64007,64017, 9 18 1,F5.0 , 2 M64007,64018, 9 19 1,F5.0 , 2 M64007,64019, 9 20 1,F5.0 , 2 M64007,64020, 9 21 1,F5.0 , 2 M64008,64001, 10 2 1,F5.0 , 2 M64008,64002, 10 3 1,F5.0 , 2 M64008,64003, 10 4 1,F5.0 , 2 M64008,64004, 10 5 1,F5.0 , 2 M64008,64005, 10 6 1,F5.0 , 2 M64008,64006, 10 7 1,F5.0 , 2 M64008,64007, 10 8 1,F5.0 , 2 M64008,64008, 10 9 1,F5.0 , 2 M64008,64009, 10 10 1,F5.0 , 2 M64008,64010, 10 11 1,F5.0 , 2 M64008,64011, 10 12 1,F5.0 , 2 M64008,64012, 10 13 1,F5.0 , 2 M64008,64013, 10 14 1,F5.0 , 2 M64008,64014, 10 15 1,F5.0 , 2 M64008,64015, 10 16 1,F5.0 , 2 M64008,64016, 10 17 1,F5.0 , 2 M64008,64017, 10 18 1,F5.0 , 2 M64008,64018, 10 19 1,F5.0 , 2 M64008,64019, 10 20 1,F5.0 , 2 M64008,64020, 10 21 1,F5.0 , 2