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
ExpExchHelpAsked:
Who is Participating?
 
TommySzalapskiConnect With a Mentor Commented:
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
 
TommySzalapskiConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.