In Progress

Excel Calculation Tool

In an effort to try and explain this easier, I’m going to simplify the project so it is easier to understand. Conceptually, the real project is exactly the same.

We have a large number of different buckets

Each bucket contains a DIFFERENT mixture (percentage) of apples, oranges, bananas, pears, etc.

BUCKET001 could have 5% apples, 10% oranges, 25% bananas, etc. which would total 100%

BUCKET002 could have 10% apples, 4% oranges, 40% bananas, etc. ….

Based on the buckets available to us, we need to create a Custom Bucket that contains a certain % of each fruit.

To accomplish that goal, we may need to have 10% of BUCKET001, 15% of BUCKET002, etc.

Since it will be VERY hard to get the %’s perfect, some fruit will be more important than others. For example, to get as close as possible to the correct Custom Bucket, we may need to say that Apples are more important than Bananas.

We currently have an access database that contains all the buckets and %’s (which could always be put in Excel).

In Excel, we need to be able to:

1. Tell the system what % of each fruit the Custom Buckets should have in them

2. Tell the system what Buckets are available for it to make its calculation (maybe 15 of 20,000 buckets)

3. Click a button and the system will tell us what % of each Bucket we need

The data is in a simple format:

Unique Bucket ID, % of Apples, % of Oranges, % of Bananas, etc.

Each column is a different fruit

Adding the fruit columns up will equal 1 (or 100%).

Please let me know if you have any questions. Once I narrow down the qualified developers, I will show you a sample of the data before you sign off on the project.

Thanks!!

Skills: Excel, Microsoft Access, Visual Basic

See more: excel developers, developers visual basic, custom number format excel, access database developers, excel calculation, apples, excel database visual basic, visual basic goal database, sample visual basic excel, excel unique, excel custom number format, visual tool basic, excel custom number, excel create certain format, excel number custom, excel format percentage, simple visual access project, excel sample project database, excel create access database, database available excel, visual basic excel database, access tool, create access database excel, simple system excel, excel simple system

About the Employer:
( 91 reviews ) Lenexa, United States

Project ID: #5366415

Awarded to:

MDavidCrompton

Hi. This looked so interesting that I did it for fun. Hence I have reduced my bid and time in the hope that I will be awarded. I am randomly choosing 15 out of 600 "buckets" from which to select a percentage. Then More

$250 USD in 1 day
(33 Reviews)
5.6

82 freelancers are bidding on average $371 for this job

priyal1997

Dear Sir/Madam I'm happy to help you on this I'm an expert in advanced excel modeling You can visit my profile to see my reliability If you are comfortable, I'm happy to discuss the more details I assure you that, More

$400 USD in 3 days
(87 Reviews)
6.0
maverick44000

Hi Rheide. Your project requires simple mathematics to calculate the right combination of fruits/baskets, connecting Excel with Access and a user friendly interface to give input and get output. I have been doing very More

$295 USD in 3 days
(40 Reviews)
6.0
deepbluetech

Hi rheide, Seems to be an interesting and challenging project. I also foresee more than one solution to a requirement. There would a number of linear equations which needs to be formulated to get the optimum solu More

$300 USD in 3 days
(126 Reviews)
5.9
zExcel

Hi, Looking forward to receiving the sample file ------------------------------------------------------------------------------------------

$250 USD in 2 days
(57 Reviews)
5.9
finecodervw

Hi, I am very keen to look at the sample data. In case you are online we can have a quick discussion on the requirement. Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, More

$330 USD in 10 days
(96 Reviews)
6.0
wsh2

Summary: Highly experienced MsAccess/MsExcel/VB Business programming expert with strong math/statistics and concise Report Writing knowledge and skills. Greetings from the USA.. {smile} Highly experienced (20+ y More

$294 USD in 10 days
(33 Reviews)
5.8
mhmhz

Hi It's interesting project. I can provide a desktop application in C# that do the requirements. I assume that there will much combinations that the application will try to find the solution. Real sample wi More

$526 USD in 10 days
(55 Reviews)
5.6
pkcyber

See the sample below which are using excel at back end. Front end is user friendly interface. http://www.youtube.com/watch?v=sc27UF_aAQw https://www.dropbox.com/s/aoh3u881r9m0vqs/PORTAL.docx I am looking to de More

$500 USD in 3 days
(27 Reviews)
5.5
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% ac More

$250 USD in 5 days
(50 Reviews)
5.4
jaylancer43

Hello - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche More

$333 USD in 10 days
(54 Reviews)
5.4
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at http://bit.ly/Lta2EN Looking for further discussions in this matter. with than More

$289 USD in 10 days
(33 Reviews)
5.4
best4best

I think the tool can be designed using Solver. I am an Excel expert. Please take a look at my reviews for Excel project and consider me positively to share the sample data so I can start work on it.

$277 USD in 3 days
(76 Reviews)
5.3
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

$388 USD in 20 days
(36 Reviews)
5.2
javed1705

I am an ACCA , APA and Mcom finance having full command over advance excel Your project has caught my attention as i know that this is my favorite topic and i am highly interested with due concern... I am full More

$250 USD in 1 day
(32 Reviews)
5.2
shanki161

Hello Sir>>>>>>Genuine and Reliable<<<<<<<< I am ready to start.Have read all the information.We have a team of 6 peoples.We guarantee you we will deliver under the deadline. Waiting for your positive response. Thanks More

$332 USD in 10 days
(23 Reviews)
5.1
VBAWhizz

Hi, I work a lot with percentages and calculations in Excel and in Access. I have recently completed a system for a company here in South Africa that sends containers to various parts of Africa - in each container the More

$600 USD in 10 days
(10 Reviews)
5.0
expertatwork

hey Rheide, we need more information definitely, please reply when you are online, thank you :-)

$250 USD in 6 days
(69 Reviews)
4.9
SteveP495

Hi, I build robust, strategic business solutions period. My closest work to this was an Excel COM Monte Carlo addin for a mid tier US Investment Bank...Steve. PEDIGREE / PREVIOUS WORK My pedigree includes thes More

$515 USD in 14 days
(5 Reviews)
4.8
CARLOSHUGGINS

I'm your best choice, a 12 year experienced VBA developer with plenty of work developed around different fields, form finance, accounting,human resource and POS solutions. I will deliver high quality results in record More

$250 USD in 4 days
(12 Reviews)
4.8
Pichart

Dear rheide, First, let me introduce myself a little here. I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years. I love to work with excel, always comf More

$388 USD in 3 days
(23 Reviews)
4.7