176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Automate Spread Sheet
Sign in to Add to Watch List

IT & Programming > Other IT & Programming

View Change History

The client has made the following changes to the job.

Description
Date

Job awarded.

Apr 18, 2012
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Mon, Apr 16, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

I have attached a spread sheet that I would like to automatically change numbers in the Result Columns when changed in the SET section.

As an example the # 1 is the first number in Set1. It is used in Results Columns 1-10. If I were to change that 1 to the number 67 then each instance where the # 1 is used would need to be changed to the # 67.

Assuming we start out with Nulls, for all number sets, then the spread sheet would need to start assigning that number to each grouping based in the Include Set information.

I don't know if starting out with Null Values is the best way to do this but we must consider that each SET of numbers can include a MAX of 3 numbers per set.

Since Set 1 only has 2 numbers assigned to it I would think that if we used a zero (0) that would then make (Result Value for the first row look like 1-2-0-10-20-3-4-72. Zero is not applicable to this application and would only confuse the results.

The Null value would have to be truncated to make the results ...

Sign in or Register to see more

Job ID: 29925675
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Vietnam  |  
I have 10 years experience in a global company as Distribution Management System Development Manager.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29975125  |  Submitted: Apr 18, 2012 14:05 ET 
Proposal SEALED

 India  |  
Exclusive MS Access and VBA developer having completed over 150 projects in the past three years - all with 5 start ratings.
6
  |  
 5.0   |  Private   |  13 Jobs
Bid ID: 29961012  |  Submitted: Apr 18, 2012 01:54 ET 
Proposal SEALED

 United States  |  
Previously worked at companies such as Amazon,Google, Motorola, Citigroup, and Royal Bank of Scotland. Extensive Programming skills in PHP...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29958800  |  Submitted: Apr 17, 2012 23:21 ET 
Proposal SEALED

 Russia  |  
VBA programmer since 1996
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29951606  |  Submitted: Apr 17, 2012 15:00 ET 
Proposal SEALED

 United States
For the past fifteen years my primary focus has been spreadsheet development, initially with the Lotus 123 macro language, and for the past decade...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29950839  |  Submitted: Apr 17, 2012 14:26 ET 
Proposal SEALED

 India  |  
Winner
Hi I am an experienced software professional and having experience of more than 8 years in Database technologies & software testing I am...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29936859  |  Submitted: Apr 17, 2012 02:48 ET 
Delivery
Within 1 day
$20.00

 Singapore  |  
Ranked in the top 1% for Financial Statements and top 5% for Financial Analysis, I do freelance work in financial analysis and Microsoft Excel. I...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29933722  |  Submitted: Apr 16, 2012 23:34 ET 
Proposal SEALED

Over 10 years expertise in Finance and IT. Master dergee in Business Economics and IT. Former IT lecturer in Belgian High School, still lecturer...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29929384  |  Submitted: Apr 16, 2012 17:45 ET 
Proposal SEALED

 India  |  
My profile being in IT field for 8 years is now an IT manager.I assumed all roles in IT services.I believe in reliability, integrity and efficiency...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 29928496  |  Submitted: Apr 16, 2012 16:56 ET 
Proposal SEALED

 India  |  
As a Professional Developer with .NET, VSTO, Excel, Outlook and HTML5, CSS and jQuery programming with over 6+ years of experience, I can help you...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 29927965  |  Submitted: Apr 16, 2012 16:31 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »