algorithm

I need to do the following but I'm a complete Excel novice when it comes to macros. I know the logic but don't know the syntax to write the macro. I was wondering if someone would be able to help me out. -Thank you! I'm trying to calculate Variable A for M1, the # of days since the last...

First problem i post myself, and hoping some brilliant minds can help me out. I’m doing a cash balance, and need an algorithm/macro to find what sums equal to the value in question. And what is needed is the values that adds up to the change in the balance, meaning, in the Buildup below, what...

I am having trouble coming up with an algorithm for deleting columns, based on a certain set of criteria. Heres the issue, all the columns have a "1" the top of column . If that column has a cell number that's greater than or equal to 0.90 or less than or equal to -0.90 then that column gets...

Hello I am looking for some help in creating an Excel VBA solution that will create a rota/schedule allocating staff to service users using an algorithm. I believe there are already existing names for this kind of problem/algorithms but not entirely sure what to refer to it is. Here is my...

Morning, I have the following algorithm: <TBODY> N</SPAN> Y</SPAN> Y</SPAN> N</SPAN> Y</SPAN> Y</SPAN> Y</SPAN> </TBODY><COLGROUP><COL><COL><COL><COL><COL><COL><COL></COLGROUP> The part I have bolded repeats infinitely afterwards. I need to convert this into an excel formula. Where a 'Y'...

Hello Guys, I got one really challenging problem here. It is very important to solve this problem in order for our department to save millions (so sincere help is deeply appreciated). Actually we have two different columns of "grid-line data" in text form. e.g. GL 23.5-24 / G. Here 23.5 - 24...

Hi all I am trying to find out whether it is capable in MS Excel to write an algorithm or some sort of VBA code whereby excel will fill in the "blanks" of a formula to give pre-determined results. Let me try to explain myself more clearly. Say for example I had 2 equations. Equation #1: (a +...

Hi, Suppose you'd like a sequence of length n composed of random integers between 0 and x. Furthermore, the sum of the sequence must be y. Repetition within the sequence is permitted. The output should come out starting at A1 and end at An. Is there an efficient algorithm that can do this in...

OK here is the scope: I have a warehouse and it currently it is at full capacity, I can not physically add more people to pick product it is already way too congested. In this warehouse they pick from roughly 400 different products. I was given another warehouse to increase the picking...