Need Excel expert

Completed Posted 7 years ago Paid on delivery
Completed

This is a task needing done asap i.e. over the next 12 hours.

I want to create a revised pricing model with the attached set of data. My hypothesis is that a number of contracts (Column C) have been under-priced given the other variables associated with the contract.

The other variables in the excel are indicators of usage of the software by company (Column B - company ID). I would like help calculating what an optimum price could have been for the different contracts to maximize revenue.

I created a regression model but it didn't seem to give me a helpful answer as it only pro-rated each contract and gave an overall net neutral contract sum. I would like to see a model that increases some of the contract values to increase the overall contract sum.

Excel Visual Basic

Project ID: #11840911

About the project

6 proposals Remote project Active 7 years ago

Awarded to:

$8 AUD / hour
(50 Reviews)
4.2

6 freelancers are bidding on average $5/hour for this job

kchas1

Hi, I would like to examine your project, and dissect it completely. I am an NYC corporate professional with thousands of solutions delivered. My bid is a simple placeholder until I fully understand your needs. I wou More

$2 AUD / hour
(6 Reviews)
3.5
shagoon2u

Dear Recruiter, I have more than 10 years of experience in financial modelling with Excel. I have bandwidth to start immediately. Thanks shakun Rastogi

$6 AUD / hour
(4 Reviews)
4.1
shivaparvathi108

Hi I have gone through the project requirements. I can complete this work in a very short time. I am good at excel VBA macros. Have total 6+ years of experience with excel VBA macros.

$3 AUD / hour
(22 Reviews)
3.8
Babystag16

I am ready to take the challenge as a part of the team. I will have to make extra effort to deliver best results on this project.

$5 AUD / hour
(0 Reviews)
0.0
kiokowilliams10

Hell, now you need to worry less about your project, as skilled personnel and an an expert in Excel (spreadsheet) and data entry, I bid to work on your projects for an excellent outcome. Thank you!!

$5 AUD / hour
(0 Reviews)
0.0
erich7

I have vast experience of Excel from developing full payroll applications to statistical analysis models. I will work with you to design the most appropriate pricing model which can then be applied to your spreadsheet.

$2 AUD / hour
(0 Reviews)
0.0