Find Jobs
Hire Freelancers

UPH Planning Tool

$250-750 USD

Closed
Posted 6 months ago

$250-750 USD

Paid on delivery
I am looking for an excel based planning tool. In current state, it will have 4 tabs. Three tabs are data pastes. One from an email attachment (csv) for planned units via route summary for near term planning (1-4 days; a 2nd email paste which will detail loaded units for the day; and the 3rd is a copy / paste from an online sharepoint for long term planning detailing 2-8 weeks out. The planning tabs which are pasted are serving more as "network" planning volume. What is the network planning the site to? The two pasted tabs will be used to populate data on a dashboard tab that will also serve as a more granular site specific planning tool. Also on the dashboard tab, the site should see what the network is planning them to; however, they should also have the opportunity to see what they are planning themselves to in comparison to the network. Finally, there should be report out on the delta.
Project ID: 37432991

About the project

39 proposals
Remote project
Active 5 mos 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
39 freelancers are bidding on average $477 USD for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$500 USD in 7 days
4.9 (531 reviews)
8.4
8.4
User Avatar
Hello Sir, I have had a look at the sheet. What exactly are you trying to achieve in this project. Do you wish to automate the process of fetching data from the Email and SharePoint or do you need further data processing to be automated. Please invite for a discussion and share exact requirements. Thank you, Usman
$500 USD in 6 days
5.0 (78 reviews)
7.3
7.3
User Avatar
Dear Sir, Are you looking for an Excel-based planning tool to help with near-term (1-4 days) and long-term (2-8 weeks) planning? I am confident that I can provide you with a solution that meets your needs. I am experienced in Excel, Microsoft Office and Sharepoint, and I can develop a tool that will have four tabs - three of which will be data pastes from email attachments, and the fourth tab will be a dashboard that serves as a more granular site-specific planning tool. The dashboard tab will also show the network planning volume and the site's own planning, and the tool will have a report out feature for the delta. If awarded the project, I will work closely with you to ensure that the solution meets your needs. I am confident that I can deliver a solution that meets your expectations. I am also happy to provide you with a free demonstration of the solution even before the project is awarded. Please let me know if you have any questions or require any additional information. I look forward to hearing from you. Sincerely, Smith
$500 USD in 7 days
4.9 (74 reviews)
7.0
7.0
User Avatar
Hi There Nice to know your requirement. I have delivered more than Two Hundred Excel Automation Projects in the past five years. Can discuss and work with you to get this task done. Thank you. Durai
$500 USD in 7 days
5.0 (184 reviews)
7.0
7.0
User Avatar
Hi. I have written many automation Excel projects. Ready to write your project. Will complete within 2 days
$320 USD in 1 day
4.9 (257 reviews)
6.8
6.8
User Avatar
Hi there! Creating an Excel-based planning tool with multiple data pastes and a dashboard for granular site-specific planning alongside network planning comparisons requires meticulous structuring. I'd commence by establishing clear data connections from the email attachments and SharePoint to streamline information input. The dashboard design will focus on presenting network planning versus site planning, emphasizing deltas for insightful reporting. Precision in formula implementation and data visualization methods will ensure a user-friendly interface, providing an in-depth view of planning comparisons while facilitating effective decision-making for the end user. I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. Send me a message so I can show you my previous work and we can discuss more. Respectfully, Giovanni.
$250 USD in 1 day
4.9 (58 reviews)
6.9
6.9
User Avatar
Hey, I hope you're doing well. I review your requirements and I can do this work. I have worked with Microsoft technologies for 9+ years and helped clients get the most out of SharePoint, PowerApps, Power Automate, PowerBI, Nintex, Microsoft Teams .NET, and Office365 platforms. I will demonstrate my work once we connect. Regards, Hina
$700 USD in 7 days
4.8 (50 reviews)
6.6
6.6
User Avatar
Hi, I will do microsoft excel spreadsheet, google sheets work using vba, macro, formulas and script Services: Customized Automated excel spreadsheet with Formulas, Tables or Graphs. Customized Automated Google Sheets with Formulas, Tables or Graphs. Create Customized Automated Dashboard in excel or google sheets Excel/Google Sheets Formulas Microsoft Excel VBA/macro Excel Charts or Graphs Invoices/Pay Slips Financial Budgeting / Investment Calculators Buttons, Drop-down lists, menu, forms. Conditional Formatting Pivot tables automated dynamic excel dashboard large data analysis Apply formulas/Advance Filter Vlookup/Hlookup, Index-Match Spreadsheet Excel data entry and formatting
$500 USD in 7 days
5.0 (18 reviews)
5.8
5.8
User Avatar
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
$250 USD in 4 days
5.0 (33 reviews)
5.2
5.2
User Avatar
I am a highly experienced industrial project manager with 12+ years of experience in planning, scheduling, and reporting. I have a proven track record of delivering complex projects on time and within budget.
$250 USD in 2 days
5.0 (2 reviews)
5.1
5.1
User Avatar
I am writing to express my interest in creating the UPH Planning Tool, leveraging my extensive experience in using MS Excel to automate processes and my proficiency in network planning. With a robust background in clinical research spanning more than 10 years, I understand the critical importance of efficient planning tools in streamlining processes and ensuring successful project management. MS Excel Automation - I have a proven track record of utilizing MS Excel to automate various processes, enhancing efficiency and accuracy in data management. I am excited about the prospect of creating a customized UPH Planning Tool that aligns with your vision. The tool will feature: Near-Term Planning (1-4 Days): Capability to use pasted data from email attachments (CSV) for planned units via route summary, ensuring real-time, granular planning. Long-Term Planning (2-8 Weeks): Ability to copy/paste data from an online SharePoint, providing a comprehensive overview for strategic planning. Network Activities: Inclusion of functionalities to plan network activities Dashboard Integration: A user-friendly dashboard providing a site-specific planning tool, enhancing accessibility and usability. Delta Reporting: Robust reporting capabilities to highlight the delta between user-planned activities and network activities. I am eager to discuss your specific requirements in more detail and provide insights into how my skills and experience align with the goals of the UPH Planning Tool.
$350 USD in 5 days
5.0 (5 reviews)
3.4
3.4
User Avatar
With an with extensive experience in Excel and other related applications. I could offer you a database driven solution like a small ep for your needs in light of understanding that you are looking for an excel-based planning tool that you are looking for. I believe I am the perfect fit for this project due to my versatility and skillset. From content writing to content optimization to content strategy, I have the knowledge, expertise and skills necessary to bring your vision to life effectively and efficiently. I would be delighted to discuss further any further requirements or project requirements you may have. Please feel free to contact me if you would like to discuss further or need any assistance with ODOO.
$1,000 USD in 15 days
5.0 (3 reviews)
3.3
3.3
User Avatar
Hello, my name is Saravanan and I am an experienced full-stack developer with 8 years of professional expertise in designing, developing, and maintaining high-performance Web applications. I have worked on projects that use PHP and Java frameworks to deliver scalable and robust solutions. I understand that you are looking for an excel-based planning tool that will have 4 tabs: data pastes from an email attachment for planned units via route summary for near term planning (1-4 days), a second email paste which will detail loaded units for the day, and a copy / paste from an online sharepoint for long term planning detailing 2-8 weeks out. I believe that my skillset makes me the perfect fit for this project. With my experience in agile development environments and version control systems, along with version control integration with team members, I am confident that I can provide reliable solutions in both the short and long terms. I look forward to hearing more about this project and helping you bring your vision for an improved UPH planning tool to reality!
$250 USD in 1 day
5.0 (1 review)
1.7
1.7
User Avatar
Hello there! I'm Nikunj and I'm excited to help you create the perfect excel-based planning tool. With over 12 years of experience in the content writing industry, I have the skills necessary to create a tool that will meet all of your needs. First and foremost, I know how important it is to have a planning tool that can quickly collect data from multiple sources and load it into a separate tab for more complex analysis later on. As such, my pasted tabs will serve as network planning volume rather than actual site planning. However, this doesn't mean you won't be able to use my tool for your own specific needs; instead, I'd be happy to provide you with a report out showing the delta between what you are planning yourself vs. what the network is planning you to. I believe I am the perfect fit for this project because of my extensive experience in Excel and ability to code well. If you're interested in learning more about my skills or how we can work together to create the perfect planng tool please don't hesitate to reach out with any further questions or inquiries!
$250 USD in 1 day
5.0 (2 reviews)
1.1
1.1
User Avatar
I bring 7 years of expertise in Microsoft Office and SharePoint, making me the ideal candidate for your excel-based planning tool project. Leveraging my skills, I propose a solution tailored to meet your planning needs effectively. Proposal Overview: Introducing a four-tab planning tool: Near-Term Planning (1-4 days): Imports CSV data from email attachments for planned units via route summaries. Daily Loaded Units: Extracts loaded unit information from a second email paste for the day. Long-Term Planning (2-8 weeks): Copies data from an online SharePoint source for extensive long-term planning. Dashboard: Integrates tab data into a visually intuitive dashboard. Provides granular site-specific planning. Displays network vs. site plans for easy comparison. Generates detailed reports on planning discrepancies (delta). Benefits: Enhanced Visibility: Clear visualization of near and long-term planning data. Granular insights into site-specific planning. Comparative Analysis: Side-by-side comparison of network and site plans. Identification of planning disparities for proactive decision-making. Efficiency: Streamlined data import from email and SharePoint. Automated calculations reduce manual effort. I welcome the opportunity to discuss the project further, providing a more accurate cost estimate and project timeline. Regards, Imtiyaz
$750 USD in 7 days
1.4 (1 review)
2.9
2.9
User Avatar
Hello, my name is Asep Saepul and I am an experienced Excel user with data entry, analysis, processing and transcription experiences. I understand that you are looking for an excel based planning tool with 4 tabs - three tabs are data pastes that will be used to populate data on a dashboard tab that will also serve as a more granular site specific planning tool. On the dashboard tab, users should have the ability to see what they are planning themselves to in comparison to the network. There should also be a report out showing the delta between what they are planning and what the network is planning them to. I believe that I would be the best fit for this project due to my extensive experience in Excel and other Microsoft Office products as well as data entry, analysis, processing and transcription. This combination of skills makes me well-suited to creating a reliable and user-friendly excel based planning tool that can meet your needs exactly how you want it.
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
"It seems like I can handle it. I'm experienced in data processing using Microsoft Word and Excel, as well as converting PDFs to various file types. You can trust me for satisfactory results and the security of your documents."
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hi i'm An Ik i can do work with you i m a profesonal worker i wil work for you you can give a work thank you
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am Gautam and I have the ability to do your work and I will complete your work give you the work on right time and I also have good skills for your project.
$500 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi! I specialize in creating Excel-based planning tools. I understand the need for three data pastes from email attachments and SharePoint, focusing on short and long-term planning. I'll design a dashboard tab to consolidate this data, providing both network-wide and site-specific insights. Users will easily compare planned units from the network with their own, highlighting any variations for efficient decision-making.
$600 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Garner, United States
0.0
0
Payment method verified
Member since Nov 15, 2023

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.