Completed

Convert Spread spreadsheet into Database (Access) or Webbased

I have a spreadsheet that has around 10 Tabs

Tab 1(Opportunity Data) - is data I import so with this new database I need an easy way where I can simply upload or import this data, and it simply adds to the list

Tab 2 (Lead Data)- same as above

Tab 3(Commissions Data) - same as above

Tab 4- Is Reps Targets, so this needs to be a section with in the data base that we are able to edit for every month of the year and keep adding to it

Tab 5-is an Opportunity overview-This takes the data from Tab 1 and presents it IE shows how many Opportunities each rep has and at what stages they are at, It also uses look ups to cross reference against Tab 2 and Tab 3 to provide an over view of what has happened to the Opportunity

Tab 6-Is a Lead over view again same as above

Tab 7-is a commissions overview it essentially looks at Tab 8 and tells me if the commissions has been paid so it is looking up an order and if its been paid it tells me

Tab 8 this is a manual page where I enter all the details of the order, this is used to track all the sales.

So essentially I need it to work like a program doing what the spreadsheet does,

I will provide the spreadsheet to the winner.

Please take the time to read this , and if you are a great programmer/Database designer and have a great understanding of excel this will be an easy task, excel is not overly complicated formuals currently used a basic formulas. the key for me is the importing needs to be easy, and the over view and data entry needs to be easy.

I would even prefer if it had a web front end to make it look sexier, and also give us the ability to access it anywhere.

Skills: Excel, Excel Macros, Microsoft Access, PHP, SQL

See more: convert a spreadsheet into a microsoft access database, convert excel spreadsheet database ipad, convert access form access web database, convert excel to web application free, how to create a web based excel sheet, interactive excel spreadsheet on website, convert excel to website, convert spreadsheet to web application, convert excel to standalone application, how to turn an excel spreadsheet into a sophisticated web app, convert excel to web application open source, php, sql, excel, database administration, database development, database programming, microsoft access, convert visual foxpro database access, convert visual foxpro database access format

About the Employer:
( 1 review ) Kings Park, Australia

Project ID: #15056754

Awarded to:

virals2583

Hello, I understood your project and can build nice, user-friendly dashboard for you where you can login, upload your spread-sheet and system will read and import it into database as per your need. I have done many More

$350 AUD in 30 days
(42 Reviews)
6.8

45 freelancers are bidding on average $613 for this job

meet2amitvw

Let's discuss more about project to finalise the proper scope with estimated cost and time so ping me over the freelancer chat.....I will share some demo as well for recent works if you want to check. Relevant Skills More

$721 AUD in 10 days
(153 Reviews)
9.3
rajeshsonisl

Hello! Bid is for web app, that can be accessed from anywhere. Need to see the current spreadsheet with detailed explanation. With 98% to 99% completion rate, 1000+ successfully completed projects, and a 4.99 rep More

$1000 AUD in 10 days
(875 Reviews)
8.4
jaylancer43

Hello, My name is Jay and I am Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (https://www.freelancer.com/community/articles/jay-patkar-freelancer-success-st More

$500 AUD in 3 days
(543 Reviews)
8.1
WebInfoSolutions

can we discuss more in details about each tab?

$787 AUD in 20 days
(185 Reviews)
7.8
EliteSolution8

Let's go together for your project. How are you today? I am a full stack developer who has over 5 years experience in app development. I am here to help you get your idea implemented and working with my team. More

$555 AUD in 10 days
(26 Reviews)
7.8
auroramedia06

Hi, We are extremely experienced web developers. We have carefully studied your project details. Firstly, we thank you for a very well described project requirement. It make comprehension and assessment so much easie More

$715 AUD in 15 days
(48 Reviews)
7.5
schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I have the 5 years of More

$750 AUD in 5 days
(234 Reviews)
7.3
augurstech

Hi Sir, we will convert the spreadsheet into web based application with all features mentioned in [login to view URL] me via freelancer chat box for complete discussion Relevant Skills and Experience we have huge experience More

$888 AUD in 15 days
(96 Reviews)
7.4
BitLabs

Hi there - My name is Farid. I’ve read your brief about "Convert Spread spreadsheet into Database (Access) or Webbased". I have 6 years experience in (Excel, Excel Macros, Microsoft Access, PHP, SQL). I am highly quali More

$606 AUD in 365 days
(113 Reviews)
6.7
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database from an existing Excel spreadsheet. Relevant Skills and Experience I have 7 years experience in designing and developing More

$500 AUD in 5 days
(153 Reviews)
6.8
jhaynes75

I'm a designer/programmer professionally and a large portion of the jobs are converting Excel workbooks to MS Access or websites. I'm more than qualified to build the right solution for you. Relevant Skills and Exper More

$444 AUD in 10 days
(31 Reviews)
6.1
raiakanksha49

Hello sir/ma'am.. I have gone through your project domain..and i want to complete your project. I have 7 years of experience and i can complete your project within your budget.. Kindly offer me this project.. Eager More

$660 AUD in 10 days
(46 Reviews)
6.0
MakhijaRavi

I read your description and we can develop a perfect database for all 8 tabs with the awesome front end as per your needs. We are a team of developers and would love to talk to you in detail. Relevant Skills and Exper More

$470 AUD in 10 days
(48 Reviews)
6.5
zu02

Hi, in my view the better way to make Ms Access GUI with Excel automation. Relevant Skills and Experience vba, Excel, sql, ado, Access Proposed Milestones $750 AUD - default

$750 AUD in 10 days
(46 Reviews)
6.1
workerbee1974

My passion is building Custom Access Databases. I have built well over 250 custom databases in the past 16 years. I have taken all classes from beginner to expert 97 to 2013. I have screen shot samples and more reviews More

$715 AUD in 10 days
(30 Reviews)
5.8
furqanorpiv

Hello, I am furkan , a CERTIFIED Excel, Excel Macros, Microsoft Access, PHP, SQL expert. I would love to provide you QUALITY Program THAT PERFORMS THE SAME TASK what the spreadsheet with around 10 Tabs does, as More

$250 AUD in 1 day
(34 Reviews)
5.8
fuentro

To convert your spreasheet into an MS Access applicaton. Relevant Skills and Experience MS Access VBA SQL Excel Proposed Milestones $150 AUD - Initial Milestone upon acceptance of the project $350 AUD - Final milesto More

$500 AUD in 7 days
(29 Reviews)
6.0
alaeddindhahri

Hi, I'm a professional databases developer. I have read your project description and I'd like to help you create both access and web frontend. We'll use sql server to manage data respectively. Relevant Skills and Expe More

$833 AUD in 10 days
(50 Reviews)
5.3
$555 AUD in 10 days
(7 Reviews)
5.4
ludiac

Hi, we have reviewed and understood the requirements of the project. Relevant Skills and Experience We have expertise in web development and can share our portfolio with you in chat. Proposed Milestones $627 AUD - Pr More

$627 AUD in 10 days
(15 Reviews)
5.5