Find Jobs
Hire Freelancers

Build multi-tab Spreadsheet Template that will be converted into web-based app later on.

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
This is multi-stage project. On the Stage 1 I need to Create a pricing spreadsheet template with 3 tabs. Tab1 will be a summary tab that will pull out some key-field values from Tab 2. Tab2 will be data-entry sheet (about 100 lines) with some basic formulas/lookups. Tab3 will have some static data (about 100 lines) used for calculations/looksups in Tab2. Users should be allowed to enter data only in specific fields on Tab2 and Print/Email Summary Report from Tab1. Admin will be allowed to edit data in Tab3. Fields in Tabs 1 and 2 will need to have extensive formatting to make them user friendly and to protect from accidental deleting/modifying by Users. Would like to use Google Spreadsheets if possible. The spreadsheet should be easy to add/modify by admin. I'm looking for help with the first stage right now. The info below is just to give you an idea what is the next stage will be. ================================= Stage 2. Add about 6 more Tabs (much smaller than Tab2, 20-50 lines). Convert this spreadsheet to dynamic web-based application. Stage 3. Continue adding more functionalities and updating the existing ones.
Project ID: 12709622

About the project

21 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
Hello, I already built many spreadsheets with similar specifications and converted them to Google web app. I can show you some samples. Regards.
$222 USD in 10 days
5.0 (12 reviews)
4.7
4.7
21 freelancers are bidding on average $122 USD for this job
User Avatar
Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. . I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi
$100 USD in 2 days
5.0 (216 reviews)
7.0
7.0
User Avatar
Hi there. My name is Daniel and I would be glad to help you out with this project. I would much rather work using Excel as it has much more features to deliver a better user experience interface. I would make sure that the fields available for editing by the user are clearly specified, and the rest of them wont allow changes unless password is provided. Hope to hear back from you soon. Thanks
$199 USD in 3 days
4.8 (93 reviews)
6.9
6.9
User Avatar
I am experienced VBA coder with long years experience. I can create also advanced V/H lookup functions and all necessary configurations listed in the request.
$150 USD in 3 days
5.0 (9 reviews)
5.6
5.6
User Avatar
Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Waiting to hear from you. with thanks and regards
$99 USD in 2 days
4.7 (50 reviews)
5.8
5.8
User Avatar
Hello there i am a professional and have extensive experience, please have a look at my profile, i deliver 100%... thanks! Regards
$112 USD in 3 days
4.9 (24 reviews)
5.0
5.0
User Avatar
I am knowledgeable in Excel and VBA for data processing and analysis, If Excel is acceptable to you I can provide the solution in excel. I am also able to provide a dynamic web based solution as required. We can discuss more in chat if you are interested.
$88 USD in 3 days
4.8 (41 reviews)
5.1
5.1
User Avatar
A proposal has not yet been provided
$100 USD in 4 days
4.7 (25 reviews)
5.0
5.0
User Avatar
Hi, I am a native English speaking Finance professional with over 15 years experience using Excel. I have built pricing models, budget forecasts and forms in the past that have protected fields and data entry fields. I would propose to work on your project by firstly locking all of the cells in the spreadsheet, then opening up the ones that allow user entry (password protected). I would normally also shade these a different colour & different font. I would propose to allow Admin to edit data in Tab3 by setting a password to allow fields to be entered, or by hiding the sheet and password protecting the spreadsheet structure so that only Admin can access. I would work with you on passwords to assign. I normally use Excel, but I have also found that Google Sheets does allow the same functionality as Excel - so I am comfortable to set it up in Google Sheets. I welcome the opportunity to discuss further and to work with you. Regards Melanie
$160 USD in 4 days
5.0 (12 reviews)
4.4
4.4
User Avatar
I am 9+ Years of Experienced Software Developer. ASP .Net , C# , VB .Net , Visual Basic, Excel VBA , MS SQL Server , MYSQL , Oracle , MS Access, Crystal Report, Telerik , Bootstrap , HTML 5 , CSS , Java Script are my working domain. I am confident to complete the project.
$150 USD in 5 days
4.9 (8 reviews)
3.6
3.6
User Avatar
Hi give me chance to do your project i have much experience in data entry and online works i have done many projects of excel but new user here i can give you best quality of work please consider me for your project Thanks & Regards MOID
$45 USD in 2 days
5.0 (10 reviews)
3.2
3.2
User Avatar
I can definitely help you with this. Please see my profile page for more information about me. Thank you.
$88 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've experienced in price spreadsheet related works. because I'm an estimation engineer. And also can work with excel very well. if required you can talk to me. please contact me via Skype: mohamedmatheen or whatsapp: 3014 3246. good luck for you job. thanks. Matheen
$166 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
First project so offering at lower cost Good spreadsheet design and excellent communication will be provided on this job
$130 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Englewood, United States
3.2
1
Payment method verified
Member since Feb 4, 2014

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.