Find Jobs
Hire Freelancers

Calendar template

$250-750 USD

Completed
Posted over 10 years ago

$250-750 USD

Paid on delivery
I am trying to build a dynamic and constantly editable “acquisition integration calendar” related to a list of tasks (or “plays”), with due dates, by business function. Needs: 1. See the attached template: a. The tasks are listed in the “All Plays” tab; this is where we will input information such as new tasks, edit tasks, add owner names, and change due dates based on the project that we are undertaking b. The goal is to create an automated bar calendar with corresponding due date bar coloring based on the inputted due date from the All Plays tab; tasks need to be grouped into [“Function” – “Sub Function”] sections; see the Calendar tab for the format and groupings I’m looking for. The black bar on the Calendar tab is the transaction close date, so the phases that are pre-close (negative due dates) are to the left of the close line, the post-close to the right 2. Chronological: within each Function-SubFucntion we need to sort from shortest due date to longest a. First are the pre-close functions, with the furthest from close (e.g. the largest negative Due Date number) shown first b. Then the shortest post-close functions, with the shortest from close (e.g. the smallest positive Due Date number) shown first (after the pre-close)…see the “Finance-Risk Management” category on the Calendar tab on the template attached as an example 3. Simple as possible macros (or even better, formulas, though I know that may not be possible): I know enough VBA to edit, just not create what I want here! 4. Dynamic: we will be adding tasks (adding rows to the All Plays listing), functions/sub-functions, changing due dates, and changing Owner names based on the project we are planning for, so this model has to be dynamic 5. Refreshable: we need to be able to refresh the Calendar tab for changes made to the inputs on the All Plays tab
Project ID: 5005081

About the project

10 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello - I am an Expert Techno-Functional Analyst in lots of arenas of IT industry including Excel Macros. I am an Engineering Graduate with an MBA degree. If you see I am among the niche bidder who has 0 failed projects because I work till the fullest satisfaction of employers and you can find the same in any of the past reviews of mine. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Thanks, Jay
$255 USD in 7 days
5.0 (17 reviews)
4.0
4.0
10 freelancers are bidding on average $344 USD for this job
User Avatar
Dear " shaneharrison" Hope you are doing well. I have reviewed the project details and would like to offer our services. We have completed many Research/Data collection/Product add/Data mining assignments on freelancer.com and have earned great reviews. We stand amongst the top notch service providers on Freelancer.com. We shall be glad to have an opportunity to work with you. Would you like to see a sample? If yes, kindly open the private chat with us and we will make a sample for your reference, the samples would allow you to assess the quality of work we can provide. Thank you and looking forward to hear from you. Regards, Toperfection
$263 USD in 4 days
4.9 (24 reviews)
5.9
5.9
User Avatar
In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$333 USD in 4 days
4.9 (48 reviews)
5.6
5.6
User Avatar
Hi shaneharrison, I have completed a number of Excel macro based projects on Freelancer. Please have a look at my job history. Had a look at the two Tabs on the attached template file. Going by your description, I can develop an Excel macro based solution to meet your requirement. I am also flexible to scope of the requirement as we progress. Looking forward to working with you on this project. Regards, Arul
$300 USD in 3 days
5.0 (72 reviews)
5.3
5.3
User Avatar
Hi, I have gone through your requirement and I am glad that I am best fit in your requirement , Please give me opportunity to work with you. Please check PM . Thanks,
$333 USD in 5 days
5.0 (15 reviews)
4.4
4.4
User Avatar
Hi my Dear, this is whqt i master a lot. I master VBA and all about Excel. I am a statistician engineer and I can do well this job for you. You can llok at my profile. Thank you
$250 USD in 3 days
5.0 (2 reviews)
3.3
3.3
User Avatar
God willing, with the experience and skills that I have, I am able to complete the work that you entrusted to me.
$525 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Shane Harrison, I am highly competent in excel and Visual Basic programming. Your description is very clear and I have almost done the job right now. lease contact me by private message (click on the enveloppe on my avatar in my offer) in order to share with you a demo version of your file. If I can make a suggestion, I have add to your file another information in the calendar, i.e. the current week . It will give you the opportunity to automatically update the action plan. Indeed, initially you planed to enter in your file only the duration, the time of completion for 1 action (example:4 weeks). But unfortunately, if you open the file 2 weeks after, the due date will be the same, but the number of remained weeks is modified. I am creative, professional, I pay a deep attention to the customer expectations and better … I am enthusiastic. I am looking forward to hearing from you. Kind regards Arno
$300 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Portland, United States
5.0
1
Payment method verified
Member since Oct 8, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.