I has file that been created for path finding. My project is to design timber transportation network using VBA in microsoft excel. Currently, that file was bale to find path finding for single entry point. I decided to design for multiple point for path finding (will created multiple netwotk) for timber to the exit point.
In attachment is the file excel that I want to modified. In "Interface" sheet area to be plan for path finding. Green color represent the accessible area to create network; blue color represent obstacle for road netwrok (road network will avoid obstacle); yellow color is road netwrok (will show up when "Calculate Path" button is press). "Set Timber Point" button is for set the timber area point (represent as "T") to be extract to exit point (represent as "SE").
In this project, I only able to create one timber point (T) only. I plan to create multiple point (T, T1,T2.. etc.) to be extract/ design network to (SE). Addtional, in this excel it only able to create network direction up, down, right and left. I want to create the direction to be able select diagonal direction. I want to extarct the result from column & row into table for eg. (T>C5>D5>E5>E6>SE).
I want to:
1) Multiple starting point.
2) Diagonal direction
3) Result of pathfinding can be extract to table
Thank you. Read Less