Excel Spreadsheet Enhancements

Completed Posted 4 years ago Paid on delivery
Completed Paid on delivery

Project Overview:

1. This spreadsheet already contains some vLookup formulas. Please do not alter these formulas unless it is necessary to achieve the tasks outlined herein, or if the approach used can be improved.

2. The following fields require manual inputs and should be ignored: Requestor, Event Date, Event ID, Campaign Name, Comments.

3. In essence, this spreadsheet will manage budget information.

4. The "Budget Tracking" worksheet will handle more granular/comprehensive data summarization.

5. The "Event Summary" worksheet will handle more macro-level data summarization.

6. All data values relevant to this project should be maintained in the "Source Data" worksheet.

7. Ensure that all formulas, calculations, etc., created to support this project are capabible of functioning in a web-based Office 365 operating environment.

Project Scope/Desired Results:

Task 1 - Budget Tracking Worksheet:

(a) Create dropdown list groups for column D using DVP-to-VP pairings contained in "Source Data" worksheet.

(b) Populate column D with VP's associated with DVP chosen from column A.

Task 2 - Budget Tracking Worksheet:

(a) Subtract "Event Cost" contained in column I from "Starting Budget" for each respective DVP, then show "Remaining Budget" in column K. Important! As cell I5 shows, Chris Brantman has a second event with a cost of $ 4,000. I would like the "Remaining Budget" to automatically calculate and populate for each new row based on the DVP chosen from column A.

Task 3 - Event Summary Worksheet:

Hint: As you will see, column A and B already contain appropriate linkage to "Source Data." I don't think anything needs to be changed with how I am serving this data up.

(a) Calculate the total number of events booked for each DVP based on the DVP name chosen from the select list for column A on "Budget Tracking" worksheet.

(b) Calculate the total # Planned events for each DVP based on the value chosen for column J ("Status") on "Budget Tracking" worksheet.

(b) Calculate the total # of events In Progress for each DVP based on the value chosen for column J ("Status") on "Budget Tracking" worksheet.

(c) Calculate the total # of events Completed for each DVP based on the value chosen for column J ("Status") on "Budget Tracking" worksheet.

(d) Calculate the total # of events Postponed for each DVP based on the value chosen for column J ("Status") on "Budget Tracking" worksheet.

(e) Calculate the total # of events Cancelled for each DVP based on the value chosen for column J ("Status") on "Budget Tracking" worksheet.

(f) Calculate remaining budge for each DVP based on total budget subtracted against the total sum of "Event Cost" values for each respective DVP managed on "Budget Tracking" worksheet.

Excel Office 365 Data Entry

Project ID: #23580801

About the project

32 proposals Remote project Active 4 years ago

Awarded to:

SpreadSheetHero

Simple enough ask for the project. I have taken a look at the attached file, and the tasks listed in the job description I can achieve in a very timely manner.

$30 USD in 2 days
(2 Reviews)
1.3

32 freelancers are bidding on average $21 for this job

w3saddam

Good Day. Hi, I check your project description.I'm very much interested in this project . I have good experience in Data Entry,Excel,Web Scraping,Leads,Web Search. I ensure you sir I will provide you better quality wor More

$15 USD in 1 day
(83 Reviews)
5.7
IgeS

Hi there, Need to have the nested formulas in your budget tracking Excel workbook reviewed. Also have those formulas that deemed needed improvements be modified? I found your workbook very structured, thus functions More

$30 USD in 1 day
(40 Reviews)
5.4
Monirulop

Hello, After carefully reviewing the experience requirements of the job description, I feel that I am a suitable match for the job. I would be glad to assist you in the completion of this work and can provide you with More

$30 USD in 1 day
(23 Reviews)
4.0
omargaml999

Hi sir, I can start working on your project ASAP and finish it in the next couple of hours. I am very accurate and precise as I am experienced in this type of projects. Looking forward to work with you

$15 USD in 1 day
(3 Reviews)
1.5
mkostadinovska

Hello there, In response to your open project proposal, please find this bid as a short description of my skills and knowledge. I'm an experienced user of excel worksheets and data entry, as well as with manipulation More

$20 USD in 7 days
(3 Reviews)
1.2
joshfox4

Hello, My name is Josh, I am interested in working with you on this project. Please respond and let's see if we can work together. Thanks, Josh

$20 USD in 7 days
(1 Review)
1.0
mahmoudalarby12

Hi sir , I can do everything you want and I guarantee you that you will be completely satisfied with the work and I know that there are many applicants for this work, but I hope that I will take a chance to prove to yo More

$20 USD in 7 days
(0 Reviews)
0.0
LinoG55

Greetings, I am a copy-writer and content writer who has experience in my field for 4 years. I type at a speed of 55 WPM on average, and have done various data entry jobs. Thus, I believe that hiring me will get the jo More

$20 USD in 4 days
(0 Reviews)
0.0
Limuzin

Hi. I am ready to do this job. Configured for long-term cooperation.  I work in office programs every day.

$20 USD in 7 days
(0 Reviews)
0.0
mwihechi

I promise you that I will do this work at a very high efficient and within a small time, let you try me

$25 USD in 1 day
(0 Reviews)
0.0
inderkaur2625

I am interested in doing your job and I will do this on time I read out description and I can do it prefectly

$15 USD in 5 days
(0 Reviews)
0.0
Desmondmuyukha

Hello. Am submitting my proposal for the above job. I have skills to do the work with over seven years experience in excel. Warm regards.

$20 USD in 1 day
(0 Reviews)
0.0
hakimchaouki

Hello sir; i am very interested on this project, I am an expert on excel, you execute this job fast and exactly with your recommendations. Thank you

$30 USD in 1 day
(0 Reviews)
0.0
ElizabethSrb

Hello David, I am a new freelancer on this freelance platform but had three jobs finished on UpWork till now. My first job was to make Internet Research of 1612 colleges and universities in the USA to find CDS, 32 par More

$20 USD in 7 days
(0 Reviews)
0.0
kajolm237

yes..

$25 USD in 1 day
(0 Reviews)
0.0
hosekiman

Dear client, i have read and understood the requirement of your project and i am ready to start working on it right away. please consider my bid and i assure you that you will end up being a happy client. Regards Edwar More

$20 USD in 7 days
(0 Reviews)
0.0
upadhyay999

Hi i am from India and i have 8 years experience in data entry and excel. Lookup function and vba Advanced level But need time I can complete in 5 days depend upon work Thanks Relevant Skills and Experience Excel vb More

$35 USD in 5 days
(0 Reviews)
0.0
sajankumarbgp200

I'm interested doing your work.

$15 USD in 1 day
(0 Reviews)
0.0
scarlatsorin98

Hello customer! I can work for you, because I have very good skills in using of PC, and I can start working immediatelly! Please contact me to discuss the details!

$10 USD in 1 day
(0 Reviews)
0.0
thankssomuch000

I can finish my work which time given me. I never give up my work.I will make every effort to do all I can about this work.

$13 USD in 2 days
(0 Reviews)
0.0