Quick Excel Macro In Excel 2003

I am using Excel 2003. Occasionally, I have a spreadsheet where I need to solve a value. There are unique provider numbers which take up a single row in the spreadsheet. Each provider number belongs to a geozip, has a number of beds, and a Charge1 value. There is a final column to the right called "Selection" which is unpopulated. This column needs to be populated with a provider number that is not the same provider number in column A. Here is the logic to populate this field: (1) Select a provider number within the same geozip; (2) Select a provider number with the highest number of beds; (3) If criteria (1)(2) yield a value, but the Charge1 is identical, then select another provider number with the next highest number of beds; (4) if there are no geozips that meet the criteria, then go to the next geozip+1, geozip-1, geozip+2, geozip-2, geozip+3, geozip-3, until a suitable value is found.

This macro needs to be written to I can use it on other spreadsheets with the same field structures in columns A-D.

I am attaching a sample file, in which the first 12 rows have been completed.

Search All Jobs:

MATLAB Coursework

this is a matlab coursework about iterated maps ad logistic maps. there are three questions with several parts. It requires some matlab programming and then questions based on your findings.

  • Fixed Price Project
  • £20-£250
  • Job Expired

Code Conversion - Repost

The project involves the conversion of a algorithms code written in C/C++ into MATLAB. I can supply the C/C++ code. The coder should be an expert of c/c++ and matlab.

  • Fixed Price Project
  • £20-£250
  • 5 days, 4 hours left

Programming (cache Coherence Protocols) 5

I need someone to implement a snooping and directories. I have complete details wihich i can share with you. I have done the baseline of code also i have some paper which contains more than 80% of the code. You must be very good with writing algorithms to complete this project. THanks

Skills Required: Algorithm , Java , Software Architecture
  • Fixed Price Project
  • $30-$250
  • Job Expired

Simple Data Structure Algorithm Academic Assignment

I have a simple Data Structure Algorithm academic assignment for an expert. Place your bid and I will send you the details.

  • Fixed Price Project
  • $10-$20
  • Job Expired

Crypting File Service

Hi, I have a my own app file which is detected by virus companies.I want to crypt it.So looking for good cryptor. Thanks

  • Fixed Price Project
  • $10-$30
  • 2 minutes left

Webform Auto Play Script - Data Capture And Submit

I'm looking for a simple auto play script to place bet on the website in the attached text document. The script needs to be able to detect a win and a loss and be able to increase/decrease the bet size based on a very simple formula. We would like to set our stake size e.g...

Skills Required: Algorithm , PHP , Visual Basic , Web Scraping
  • Fixed Price Project
  • $30-$250
  • 18 hours, 35 minutes left

Matlab Recognition Of Characters Using Matlab Built In Functions

attached is an assignment of character recognition we need to enhance image and then extract the characters to be displayed on console using any OCR mat lab built in function ALSO I NEED A FLOW CHART OF THE ALGORITHM USED AND THIS IS IMPORTANT TOO

Skills Required: Algorithm , Matlab & Mathematica
  • Fixed Price Project
  • $30-$250
  • 2 days, 6 hours left

Assistance With Math

: Logic, Sets and Matrices, or we could refer to them as: the Algebra of Logic, the Algebra of Sets and the Algebra of Matrices Have a exam due looking for some help

Skills Required: Algorithm , Mathematics
  • Fixed Price Project
  • $30-$250
  • 4 days, 8 hours left

Mathematician Needed -- 2

I require a skilled mathematician to help me create a series of lottery syndicates for use in my shop. The tickets will be accross 3 separate lotteries and be made up of various combinations depending on the amount of players involved. Budget is $150

  • Fixed Price Project
  • $30-$250
  • 4 days, 15 hours left

Write A Mathematical Model Of An Algorithm

We have an algorithm description in text, and want someone to write it in pseudo-code format and mathematical proof. It is extremely short.

  • Fixed Price Project
  • $10-$50
  • 5 days, 5 hours left

Job Details

  • Job Type
  • Fixed Price Job
  • Budget
  • $30-$250
  • Start Date
  • 01/23/2012 08:20:49 AM
  • Job Status
  • Job Expired