algorithm

Digging into Stock enhancement with Excel and GoogleFinance within Sheets and looking for some help to find the most efficient way to build a formula that will take a specific ticker (currently have ~500) and I want to get a BOOL type of response that confirms if the stock had a run up (spiked)...

Hello, I am struggling to write a VBA algorithm. Input: list of users (name and country) List of historical pair of users (month, Person 1 and his country, Person 2 and his country) Output: combination of possible pair of users. Condition two users composing a pair should not have the...

Hi, I need an solution in VBA to find Best combination of sum value or Nearest to sum value from the list of data. For ex: in A column A1 = 10 A2 = 20 A3 = 35 A4 = 50 A5 = 60 Given sum value B1 = 100 B2 = 85 Expected output from macro A1 = 10 B2 A2 = 20 B2 A3 = 35 B1 A4 = 50 B2 A5 =...

Good afternoon! I have been poking around trying to find something that might help me and I have tried a few things and I am not having any luck. I would like to create a list for myself to help route deliveries. Each driver will do the same route a little differently based on their own...

I need help automating an algorithm, where A is the Nr., that is freely inserted (i.e.: 12, 500, 175, 4, ...). Cell C should recognize the number (as <100 to >5.000) from cell A, and the risk level accordingly on cell B, from No to High and present the result on cell C. There is a second table...

To whom might be able to help. In the example above location 1 fulfill their 50000 lbs delivery with the first two assets. Would like to modify algorithm so that location 2 is fulfilled with the next available asset (right now starts again with the same assets) and on to the next location so...

Hi, I have a bit of a problem. Usually I manage to find answers and solutions in the older threads (thanks to everyone for posting answers on the site), but this time I was forced to register and post my issue :). I m designing an algorithm for a football game, the issue is statistics. It would...

I am looking for an xl formula to calculate the check digit for a MERS MIN. They tell me it is a MOD 10 Weight 2 Algorithm.

Dear All, I have one query in VBA. I have attended interview. they ask "what kind of algorithm you have used in VBA". I have written VBA for automate the Pivot table , Saving the report from pivottable . Now what kind of answer i have to give. what are the Algorithm available in VBA. Please...

Hi i have two set of data,one for training and another set is testing. Can i use this data for k-nn algorithm on this?If yes , can u let me know how to do this?? training data <colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody> timestamp c1 c2 c3 c4 c5 c6...

This is my data: 300, 300, 300, 300, 300, 20300, 20300 Looking at it, I would say the last two values, 20300, are outliers. However, following this method...

I have an occurrence matrix made from a set of sample data. The data represents a series of stores, and a series of items held at each store. There are over 6000 unique store locations, and around 400 unique items. The occurrence matrix maps whether the item is at the store. In the sample...

Hello, I'm running a knapsack type of problem with my data located in multiple columns (i.e., A2:A10, B2:B:10, etc.) and can't figure out the correct argument to use that references the value in a cell for the algorithm to analyze and select or leave out. As currently configured, I can get the...

I have this code to get the smallest number that can find and his column in each row of the matrix and write it in cells(column where it was found, row) This is the matrix at the beginning https://i.stack.imgur.com/Ufn5V.jpg I execute the code and this is what happens...

(i) Develop an algorithm to determine whether a graph represented by a node-node incidence matrix is connected or not. Provide a clear algorithm statement. (ii) Code your algorithm in any programming language you prefer, run your code on the node-node adjacency...

Hello , i have an array A with element, i need to sort that array ( the lenght of array depend on n - cellB2)by taking element and putting it into the right place, by doing a loop it should give me an ordered list in column D. Can someone please tell me if my code is close to the correct code...

i have range of cells sheet1.range ("E12:E19") containing numbers like 510,411,300,100,80. Sheet1.cell("O6") contains the maximum a number can be say 100. what i want to do is , Divide the numbers in Sheet1.range("E12:E19") into equalish whole parts such that none of the resulting number is...

Hi everyone, I am facing a problem in Excel. First, I need to use VBA because it is impossible to add a row in excel without using VBA (of what I know...). The problem I am facing is that I have a data structure with thousands of lines in a tree type within the same column: BASIC COLUMN C1...

Hello everyone. The Problem ========== I am working on a speed date project. The "who meets whom" part is already solved, and the output of that is a full list with all the pairs that will be meeting that day. The actual speed dating day will consist of **N rounds**, and will have **P...

Hi All, I have tried and tried to work my head around making lists of all unique permutations of a list of values that equal x but no luck. If any one has any idea I would apprecate it. Its like a brute force algorithm for passwords I guess but i cant work out how to only use each value once...