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

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

Waterfall Plot

I am looking to represent the divergence of a set of Beta probability distributions over time in some sort of waterfall plot in R, something along these lines: http://cloud.originlab.com/www/products/images/WaterfallWithHighlightSeries...

  • Fixed Price Project
  • $25-$75
  • 1 day, 8 hours 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

Graph Theory, Planar Embedding -- 2

Need java applet where user can draw graph (vertices and edges) using mouse. There should be an option available to check whether the graph is planar or not and if it is, construct planar embedding. PM me and I'll send you pdf file with more instructions...

Skills Required: Algorithm , Java , Mathematics
  • Fixed Price Project
  • $30-$250
  • 5 days, 21 hours left

Automatic Image Segmentation

automatic image segmentation. when an input image is given it has to be segmented into regions and separate into blobs. algorithms preffered are Ncut, fuzzy clustering, fast, little modified or new one. the datasets are natural images from famous datasets like caltech, wang, pascal...

  • Fixed Price Project
  • $10-$30
  • 6 days left

Job Details

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