How Do I Convert These Excel Functions Correctly Into Functions In A C Program?

Question

0.00/5 (No votes)

See more:

i have this excel file (represents the MM1 queue simulation)

i have a hard time figuring out what's wrong because each part works well on its own i've marked the places that are wrong
i'm working with floats ,and done 3/4 of the program correctly except for few parts

these excel functions that i'm having problems with
i created a function to return max of 2 floats and another to count the cells in an array that are more than a certain value
but the result is not right it isn't changing always 0 1 1 after 1 1 2
function in excel =MAX(J5-(COUNTIF($I$5:$I$34,">="&C5) - COUNTIF($I$5:$I$34,">="&C6)),0)
# in QueueBefore=bfinq

function in excel =IF(((COUNTIF($I$5:$I$34,">="&C5) - COUNTIF($I$5:$I$34,">="&C6))=L5), 0,1)
# in ServerBefore=bfins

depends on the top 2 so it isn't working
# in QueueAfter =afinq

Posted 16-Dec-14 0:28am

Duaa07

Updated 16-Dec-14 3:48am

v5

Add a Solution

Comments

CPallini 16-Dec-14 6:49am

I see out of array bounds in your code. By the why, you should post the code here.

Duaa07 16-Dec-14 9:48am

Thnaks!

Duaa07 16-Dec-14 6:52am

umm although all the arrays are of size 34 i though something is wrong with using floats .
okay i'll

Jochen Arndt 16-Dec-14 8:46am

As already noted by CPallini, you access array items out of bounds.

With array sizes of 34 items, the allowed indices are 0 to 33.
You are not only using loops generating indices of 34 but also access items inside the loops using the index plus one resulting in indices of 35!.

As a result you are passing undefined values to your max() and count() functions.

Duaa07 16-Dec-14 9:47am

Thank you so much!
i fixed that and it is working now :)!

Jochen Arndt 16-Dec-14 9:50am

Fine that it is working now.

I will post my comment as solution so that your question gets out of the list of unanswered ones.

TheRealSteveJudge 16-Dec-14 9:50am

You should post your comments as solution!
You deserve the points!

Jochen Arndt 16-Dec-14 10:06am

Thank you.
We had the same thought at the the same time.

TheRealSteveJudge 16-Dec-14 10:12am

You're welcome!

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Accepted Answer · 2014-12-16T03:52:00

As already noted by CPallini, you access array items out of bounds.

With array sizes of 34 items, the allowed indices are 0 to 33.
You are not only using loops generating indices of 34 but also access items inside the loops using the index plus one resulting in indices of 35.

As a result you are passing undefined values to your max and count functions.