Find Jobs
Hire Freelancers

Spreadsheets and forms on Excel

$30-250 USD

Completed
Posted over 6 years ago

$30-250 USD

Paid on delivery
I just took over a manufacturing/contracting business and need somebody who can help create some spreadsheets and worksheets which are compatible with Excel 2010 to help me manage projects and data. I need a few different aspects. 1. New Entry form- I want an input form or spreadsheet where I can input new projects and customers and include information about each project, including due dates, kind of project, etc. 2. Progress spreadsheet - I want another worksheet or spreadsheet where I can update information as the project moves along. The information would show what has been completed, what hasn't (including checkmarks if possible). This may be a view only spreadsheet. It would only show open projects. Completed projects would not show on this spreadsheet. 3. Update form/spreadsheet -- This worksheet and also allow me to update progress information and add notes for individual projects. This may be a spreadsheet which just shows open projects. This may also be combined with the Progress Spreadsheet to be one spreadsheet, or it may be a separate spreadsheet or form. This may also be combined with the New Entry form, or it may be separate. This would only include projects that have not been completed. 4. Pricing spreadsheet - on the above spreadsheets, I want to include the pricing of items for projects and some other data (like how many units, how many stitches, etc.) When projects are completed, I want to be able to look all these pricing details up on a spreadsheet. Then, on the spreadsheet, I want to be able to filter the pricing data for each individual company -- telling me how much a customer paid per unit in the past for a project. This information would come from completed projects. I also want a few additional spreadsheets: 1. Open projects and what stage each project each is at (this can be just for view or the one where I can input the information 2. Pricing spreadsheet - which shows the prices and data about each project, which I can filter to just show data for certain companies. Data that will be included in these spreadsheets, but may include more: - Company name (have multiple projects) - Project Name (and this name may be repeated, as many are re-orders) - Type of project - new, re-order - Digitizing - new, adjust, not applicable - Stages of the project - Number of units - Price per unit - Number of stitches - PO number - Invoice number - Paid or not I made some preliminary spreadsheets, but cannot figure out how to combine the worksheets and simplify the information. If you are qualified, I will send you the spreadsheets I have and what I am hoping for. I DO NOT NEED DATA ENTRY. I do not need charts or graphs. I need someone to develop the spreadsheets/worksheets for me.
Project ID: 15253265

About the project

15 proposals
Remote project
Active 7 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
Hi, I would be glad to help you with this work. If you're interested please contact me. I have a 10 years experience in IT area (did a lot of excel templates with or without the use of macro).
$60 USD in 3 days
5.0 (3 reviews)
1.9
1.9
15 freelancers are bidding on average $130 USD for this job
User Avatar
Hello, I’m an Excel VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss. Regards. Stay tuned, I'm still working on this proposal.
$250 USD in 3 days
4.9 (3 reviews)
3.5
3.5
User Avatar
Excel Expert. Capable of making multiple spreadsheets as per your requirement
$111 USD in 3 days
5.0 (1 review)
1.6
1.6
User Avatar
I have 7 years of experience in developing Excel and VBA Macros. I have developed several workflow program for renowned organization. See my profile for client reviews and similar projects. Relevant Skills and Experience Excel VBA 7 Years of Experience. Proposed Milestones $105 USD - Complete Solution I provide free post project revision and support services. Looking for your response.
$105 USD in 1 day
5.0 (1 review)
1.3
1.3
User Avatar
Excel VBA Developer Relevant Skills and Experience Excel VBA Developer Proposed Milestones $111 USD - Full Price
$111 USD in 3 days
5.0 (1 review)
0.9
0.9
User Avatar
A proposal has not yet been provided
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
13+ yrs of IT experience, have developed many complicated Excel tools with many functionality and tricks to get the desired result in professionally presented. New to Freelancer website though :-) Relevant Skills and Experience Expert Excel VBA/Macros Proposed Milestones $50 USD - Initial Pay $250 USD - After Completion I will provide you more functionality like searching, logging, authentication etc.
$300 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$30 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$111 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Habilidades y experiencia relevante VBA/Models Htos propuestos $250 USD - final delivery SO: Win or Mac?
$250 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, Thank you very much for this Spreadsheets-forms-Excel Project. I read through the job details extremely carefully and understand your required, for this I am absolutely sure that I can do the project very well. I can complete this Spreadsheets-forms-Excel project on time and within your budget. I have worked on similar Spreadsheets-forms-Excel projects, and I am confident I can exceed your expectations. Please click on Chat & reply me for see demo work or talk more details. Regards by Tanmoy Debnath See My Feedback: https://www.freelancer.com/u/tanmoyspi.html
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am an IT expert so I can do this work easily. Please give me chance to start my online career. If needed you can verify my CV in PM for the guarantee that i can easily do your work Relevant Skills and Experience Excel expert Proposed Milestones $20 USD - for half of work $35 USD - after the work is delivered to you PM me to discuss further
$55 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear client, I can develop it for you using VBA. Develop a similar but more complicated Excel sheet using VBA for a client recently. Can show you that in chat. Looking forward Relevant Skills and Experience Excel VBA Proposed Milestones $166 USD - COmplete Excel file fulfilling all the requirements
$166 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello sir, I have gone through your post and want to discuss some points regarding your requirements. Therefore, would request you to initiate the chat in order to clarify my queries/comments. Relevant Skills and Experience I would like to assist you with my strategies and shall show you my past works once we connect for discussion. Regards Jyoti Proposed Milestones $100 USD - s I will be happy to help you and hope to have work with you. References are available if asked.
$45 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have extensive experience in Excel and VBA, having developed similar worksheets for use in investment banking and private equity. I have built just this type of document in the past. Relevant Skills and Experience 12+ years of experience working in Excel, financial modeling, and business operations. Proposed Milestones $222 USD - Completion
$222 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Payment method verified
Member since Sep 25, 2017

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.