please help me with the VBA code for this algorithm. NOTE: THIS IS AN ALGORITHM FOR AN ACTUATED TRAFFIC LIGHT. LOOK AT
Posted: Thu May 26, 2022 9:24 am
please help me with the VBA code for this algorithm.
NOTE: THIS IS AN ALGORITHM FOR AN ACTUATED TRAFFIC LIGHT. LOOK AT THE EXCEL SPREADSHEET I'VE UPLOADED TO SEE HOW THIS VBA SHOULD FUNCTION.
the key on the left is of the abbreviations used in the Algorithm please do try to understand them.
Key DR- Duration of the red lights AL as String DG - Duration of the green light RA -Average number of vehicles arriving at the robot throughout the duration Simulation RL - Average number of Vehicies through the robot NYF Number of Vehicles in front AL - Active light NVR - Number of vehicles at the robot when Simulation Start T - Time (sec) NO TAL, DR, DG, RA, RL, NVR IS of the robot at an Intersection 15 ≤ DR≤ 30 as Single 15 ≤ 04 ≤45, 0LRA≤2iOL RLLI Single AL :green or red as string OLNVR450 VF Integer Period = 1 to 3 > Period=1 Period = 3 Period 2 Perjed=1 NVFLO TART DR, DG, RL, RA, T as Single NVF, NVR as Integer Period as Byte Green T=T+ DG V NVF=NVF + DG (RA-RL) ✓ AL= Red ✓ Yes NVF = O + < Period=3 No NVF Period = 1 Yes ≤900 No END NVR NVF T= 0 Red or ? → Period=2 green No T2300 vyes TL 600 des --DR must be 154030 DG must be 15 to 45 RA must be o to z RL must be oto I as Singles -AL must be green or red NVR must be o toso NVF must be integer Red T= T+ DR V NvF= NVF +(DRX RA) AL- Green Period= 2
NOTE: THIS IS AN ALGORITHM FOR AN ACTUATED TRAFFIC LIGHT. LOOK AT THE EXCEL SPREADSHEET I'VE UPLOADED TO SEE HOW THIS VBA SHOULD FUNCTION.
- Please Help Me With The Vba Code For This Algorithm Note This Is An Algorithm For An Actuated Traffic Light Look At 1 (109.51 KiB) Viewed 14 times
Key DR- Duration of the red lights AL as String DG - Duration of the green light RA -Average number of vehicles arriving at the robot throughout the duration Simulation RL - Average number of Vehicies through the robot NYF Number of Vehicles in front AL - Active light NVR - Number of vehicles at the robot when Simulation Start T - Time (sec) NO TAL, DR, DG, RA, RL, NVR IS of the robot at an Intersection 15 ≤ DR≤ 30 as Single 15 ≤ 04 ≤45, 0LRA≤2iOL RLLI Single AL :green or red as string OLNVR450 VF Integer Period = 1 to 3 > Period=1 Period = 3 Period 2 Perjed=1 NVFLO TART DR, DG, RL, RA, T as Single NVF, NVR as Integer Period as Byte Green T=T+ DG V NVF=NVF + DG (RA-RL) ✓ AL= Red ✓ Yes NVF = O + < Period=3 No NVF Period = 1 Yes ≤900 No END NVR NVF T= 0 Red or ? → Period=2 green No T2300 vyes TL 600 des --DR must be 154030 DG must be 15 to 45 RA must be o to z RL must be oto I as Singles -AL must be green or red NVR must be o toso NVF must be integer Red T= T+ DR V NvF= NVF +(DRX RA) AL- Green Period= 2