Cancelled

excel macro to try randomized data within limits

We have a growing sheet (models) in a file in xls that is 500 rows (will go to 1500) and 50 columns (could go to 65)

Most columns are numbers. What we need to do is to be able to randomize it by +/- 1 or 2% and track error creation.

We will send you the sheet with an empty 'sheet1' next to the 'models' sheet. what you do is...

1. add a button in the sheet 1 in 1st row that says 'calculate' etc. This happens on all columns that have numerical values. It does not appear on columns that have any text.

2. when the button is clicked, all cells of that column get computed and filled using following algorithm

3. Use xls functions to generate a random number between -2 to 2 for each cell instance. If you need help on this, let us know. this number=random%

4. new cell in sheet1 gets the values from sheet 'models' with that random% added (or deleted) to it. if original number was 1.0 it becomes 0.980 to 1.200

5. no non numeric value gets altered

6. macro automatically does not compute in rows that does not have anything in column a in that row

7. macro checks if value returned is correct

8. macro computes to 2 more decimals beyond what is in the original cell

any questions?

we need you to suggest approximate time needed to do this and max dollars for the quote.

Skills: Excel

See more: will do anything for 5 dollars, what does algorithm, track 1 data, excel help needed, do anything for 5 dollars, data algorithm, anything for 5 dollars, algorithm data, algorithm creation, 5 dollars to do anything, what is macro in excel, need help excel, try, try on, randomized, algorithm and data, excel random number, excel macro add, excel row column, excel macro row, generate random number, excel algorithm, excel column row, excel 2013 macro, excel 200

About the Employer:
( 160 reviews ) Cairo, Egypt

Project ID: #4608480

37 freelancers are bidding on average $68 for this job

vserv

I specialize in Excel/VBA projects. Please see you messages. Thanks

$55 USD in 3 days
(57 Reviews)
5.7
Teloquence

Consider it done. Check your PM for my bid details.

$105 USD in 1 day
(67 Reviews)
5.5
pierreho

Hello DandDSolutions, I can do that job. See my PM. Kind regards

$100 USD in 3 days
(30 Reviews)
5.3
FIBIN

Hi, I am interested to work for your project . I am an expert in excel and VBA Programming in Excel. I have experience working on lot of Excel based projects. I will make sure that I deliver you the best with 100% More

$55 USD in 2 days
(39 Reviews)
5.2
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$79 USD in 2 days
(17 Reviews)
5.0
microk

Expert Here.. Please check PM..

$35 USD in 2 days
(17 Reviews)
4.2
Gooroo

Hi Sir! Look NO further, I am your best choice! Please check my reviews and portfolio and let me help with quality and speed. Thanks in advance!

$55 USD in 1 day
(14 Reviews)
4.1
SCRdataPro

Hi, as mangement accountant and business intelligence consultant with many years of experience in MS-Office and VBA I´m the perfect match for your project. Please let me know if you´re interested. Kind Regards, Nico More

$111 USD in 3 days
(5 Reviews)
4.0
FLtowhid

Please see my PM

$45 USD in 4 days
(4 Reviews)
3.8
Solver86

Salam, please check PM. Thanks

$35 USD in 1 day
(11 Reviews)
3.7
manishadk

This looks easy. Please check PMB for more details.

$50 USD in 1 day
(10 Reviews)
3.7
buyaspreadsheet

Why pick me? Able to turn around within a few hours. Outstanding feedback on all projects without exception. I look forward to working with you. Please see PM. Kind regards, Andrew

$35 USD in 1 day
(9 Reviews)
3.6
ankurb43

I can write the required macro in next 2 hours

$35 USD in 1 day
(1 Review)
2.8
paris2785

VB and VBA expert for over a decade. Master in Information Systems.

$30 USD in 5 days
(1 Review)
2.4
thanhhungqb

Dear sir, I am ready to start immediately. Thank you very much.

$30 USD in 1 day
(6 Reviews)
2.2
geogeorge2

Interested.

$100 USD in 4 days
(1 Review)
2.0
ExtraNet

Can be implemented within the day, number of rows and columns is not a problem.

$50 USD in 1 day
(3 Reviews)
1.9
VBAExpress

I have already done this kind of projects. You will be satisfied with results of my work. Regards VBAExpress

$35 USD in 1 day
(1 Review)
1.3
toxicman

Hello,I can help you.

$30 USD in 1 day
(1 Review)
1.2
rbbahia

Hi, I can do that.I have experience fiwh VBA.

$30 USD in 3 days
(1 Review)
1.1