Completed

Excel Expert. Need scripts written for calculation and reporting

I need an excel expert to help write some code for the attached excel sheet

1. Imp Plan - Consolidated tab: Write a script to calculate both the start and end date and time based on the duration in Column D

2. In New Sheet, display completion of tasks in Milestone tab in Graphical format (10% complete, 20% complete, etc and total completion)

3. In New Sheet, display completion of tasks in Backout High Level tab in Graphical format (10% complete, 20% complete, etc and total completion)

4. Display status graph so that it is easy to copy and paste into an email for easy sending

Skills: Data Processing, Excel, PHP, Software Architecture, Visual Basic

See more: need excel expert, need someone help write book, help write code catalog mysql php, data entry, php, excel, visual basic for apps, microsoft excel, need urgent help fix code, excel expert need simple solution, copy paste email list word excel, need someone help write book ghostwriting, need someone help write, need writer help write book, need excel expert match columns, need excel expert create macro, i need a blog write, i need a good excel expert in singapore, i need an excel expert to come to my office, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s

About the Employer:
( 13 reviews ) Pittsburgh, United States

Project ID: #17328468

Awarded to:

lherreraz

Hi there! I read the project's description and I'm sure that I can help you with this. I have a large experience working with advanced Excel, using formulas, functions, graphs, pivot tables and Macros using VBA. I a More

$50 USD in 1 day
(15 Reviews)
3.8

42 freelancers are bidding on average $117 for this job

rinsadsl

Hi There, I am good in Excel functions development and also I can write macros to complete task. I can do the calculation on the attached sheet. looking forward Thanks

$222 USD in 3 days
(1048 Reviews)
8.8
jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( More

$222 USD in 3 days
(643 Reviews)
8.3
schoudhary1553

Hello, I can help with you in your project Excel Expert. Need scripts written for calculation and reporting. I have more than 5 years of experience in Data Processing, Excel, PHP, Software Architecture, Visual Basic More

$160 USD in 3 days
(317 Reviews)
7.7
esalem

Hello, I am interested in your project and like to submit my bid for it. Let us talk about the details of it. Regards, Iyad

$155 USD in 3 days
(39 Reviews)
7.3
$65 USD in 2 days
(393 Reviews)
7.3
paris2785

Hi, there. My name's Paris and I'm really interested in your project. I opened the attached spreadsheet and everything's clear to me. I can integrate the required formulas for finding the duration or depending on th More

$200 USD in 7 days
(169 Reviews)
6.9
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can make macro excel like your project description :) please give me this job and im able to start working today :) THank You Sincerely Galih AP

$100 USD in 3 days
(324 Reviews)
7.0
$100 USD in 3 days
(247 Reviews)
6.7
TonmoyRoy111

Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$100 USD in 2 days
(268 Reviews)
6.5
rostovsoft

I can develop VBA application of any complexity. I have more than 10 years of professional software development. Recently I’ve successfully finished large VBA application https://www.freelancer.com/projects/php/exce More

$160 USD in 3 days
(114 Reviews)
6.3
rengrish

Hi I went through the requirement. I have understood most of the overall requirement. I would like to discuss with you more . Kindly ping back. I can complete this job within hour or two. I have 10+ years of experienc More

$90 USD in 1 day
(147 Reviews)
5.9
satishtl

- Went through the Implemenation plan. - Can get the End date time calculated based on the Duration and the start date. - Show the percentage completion in graphical format based on the actual time utilized. Simil More

$140 USD in 4 days
(54 Reviews)
6.1
periyannas

Ok Sure

$155 USD in 3 days
(69 Reviews)
5.7
$155 USD in 3 days
(7 Reviews)
5.4
carlosperezit

Hi there My name is Carlos and I'm an expert in .Net and sql server. I have been working in software developement for the last 20 years. I have many experience in desktop and web development. Regards

$155 USD in 10 days
(52 Reviews)
5.4
royalcalif

Please pm me for more information and sample as well. Hi Mr. Employer, Glad to contact with you. I can do this project through effective manner with 100% accuracy fulfilled your requirements. I assured that i have pro More

$30 USD in 1 day
(80 Reviews)
5.4
vaidyag

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in I More

$155 USD in 3 days
(15 Reviews)
5.2
sloker18

I am proficient with excel macro/VBA development, I can write the output macro to generate graph and calculationas per your specification, if you are interested feel free to message me, looking forward to chat further More

$100 USD in 3 days
(46 Reviews)
4.9
itoasis1

Hi. I have review your project description. I have full experiences in Development. I am very interested in your project and also ready to start work immediately. Hoping for your soon Reply. Thank You Regard.

$100 USD in 3 days
(21 Reviews)
4.7
nelumindralal

Hello, I went thru the description and opened the excel I have done similar projects and see the below link for some images of it [login to view URL]!AtCZd2sWox0MsGr-4aij-N41VM69 You may see my previous pro More

$166 USD in 5 days
(24 Reviews)
4.3