Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 212
  • Last Modified:

Constraint modeling in MS-Excel

At this time, I'm familiarizing myself with modeling "constraints".  

Attached is a simple scenario (including constraints) that illustrates the process.  If doable, I'd like to use Excel for establishing a basic framework on this model/algorithm.

Does anyone have a suggestion/idea for developing the function/model in Excel?

Thanks in advance,
EEH
Modeling-process-in-Excel.docx
0
ExpExchHelp
Asked:
ExpExchHelp
  • 2
  • 2
2 Solutions
 
TommySzalapskiCommented:
It seems that Excel might not be the best tool in the long run for this type of project. Excel does not model objects well. You could probably have more success with a formal language like C++ or something like MATLAB.

What kind of project is this for? Is it just a college course or is this a long term project?
0
 
ExpExchHelpAuthor Commented:
TommySzalapski:

Thanks, I appreciate the recommendation.   Unfortunately, I don't have access to MATLAB at this time.

This is basic on some concept development (work-wise).   More research at this time vs. developing any applications.    Just needed to demonstrate something to colleagues before going forward on further developing an idea.

Again, thanks!
EEH
0
 
TommySzalapskiCommented:
Well, I certainly would say Excel is a good tool for quick demonstrations and research.

I see you're getting some good help with your circle calculations, what "model" are you wanting to build? I see the design document about targeting from a sub, but what specifically do you want from this question?

What do you get from the signal, angle and distance? So you get two signals and can determine speed and direction? How do you think signal quality will play in to the calculation? Add a measure of uncertainty?
0
 
ExpExchHelpAuthor Commented:
TommyS:

I need to build other constraints into the model.    I think I'll hold off for now until I get more clarification from my colleagues.

If needed (and if you won't mind), I'll post a follow-up question here in the next couple of days.    For now, I think I'm ok.

EEH
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now