Good afternoon Community,
I have a question about Excel, in which I do not know if it is possible to make such a request. My goal is to take a plant and through a solver, place surveillance cameras at certain points of the plant to monitor the entire area (Coverage Problem).
Thisimagerepresentsoneoftheseareastomonitor.Cellshavingavalueof1representtheplacementofchambers.Thisplacementisdoneautomaticallywiththesolver,usingsomemathematicalconstraints.
WhatI'vebeentryingtodoandcannotdoismakethefieldofviewofeachcamerarepresentedbythevalue1intheadjacentgrid.
ExampleofwhatIwant:
As you can see, the squares adjacent to each camera are filled with the FOV of the corresponding camera, but I put it by hand. I would like to know if there is a method of processing my request automatically, via Visual Basic or formulas, or another method that I do not know about.
This is my masters work on the topic of resource optimization.
Any information you need to help me will be available.
Thank you.
