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