Convert excel work book to database website

Ukończone Opublikowano Jun 4, 2008 Płatność przy odbiorze
Ukończone Płatność przy odbiorze

I have a complicated excel spreadsheet that tracks Profit and loss and goals for small business. I need it to be taken out of excel and converted into some form of database and have a? website built that will be set up to accept charge cards for monthly users.

## Deliverables

ProfitXcelerator: Functionality specifications: This Goal and profit tracking tool is designed for any service industry. (Businesses that sell labor and parts) It needs to be built with a basic template that will handle most vertical markets. The only change between industries will be the vernacular and the key point indicators. 1) Take ProfitXcelerator out of an Excel work book and convert it to a web based subscription. a) 1st page will be a home page. b) 2nd page will be a demonstration page were the goals sheet will be displayed as a working calculator for the potential customer to input their P&L statement see a working goal be projected. They will not be able to save the data they entered. c) 3rd page will be an instruction sheet. d) 4th being an on-line dictionary/glossary of all the financial names and terms used in ProfitX. e) 5th page will be an income analysis sheet that is used for first time customers input their last years P&L statement they will click on the process data button and the information is transferred into the Goals sheet. ProfitX bookkeepers will be able to input the customers information if they choose to pay the set up fee. f) 6th page (most important page) is the main Goal setting sheet; everything is tied and tracked on a daily basis to these goal figures. g) 7th page is the Data sheet were all month end data is automatically taken out of the tracking pages and transferred into this data sheet and customers P&L statement is manual entered at month end. Maintains totals by month and year. At the end of the year a button will be clicked that clears the fields, extrapolates the data and puts it into the correct places in the Data sheet( if this could be done automatically at the end of the year that would be ideal) h) 8th page is the year to date progress sheet that goes off the last end of month entry in the data page. i) 9th page would be the daily performance tracking sheet were the previous days transactions are entered into this page. This input sheet will feed all the other pages with the previous day’s sales figures. At the end of the month a button will be clicked that clears the fields, (it will also clear the monthly pages since they were originally combined with the summary sheet) extrapolates the data and puts it into the correct places in the Data sheet( if this could be done automatically at the end of the month that would be ideal) j) 10th page is the technicians page, were technicians previous work day hours and billed hours are entered; this will include charting of year to date and month to date records of the technicians. This input sheet will feed all other pages. (This page is a combination of the technician sheet and the individual technician’s time card sheets.) The individual technician’s time sheets are going to need four compensation plan templates. Flat rate, hourly, Salary and custom. Production bonus column should have multiple formulas for different user needs. SEE #25 D for further details k) 11th page would be the monthly tracking sheet, were the months goals are displayed along with the daily goals. The user will be able to toggle between two versions of this screen. ProfitX lite and ProfitX power user. The profitX PR will show all the figures and the lite version will only show the most important 6-10key point indicator numbers. l) 12th page will be a Yearly tracking sheet were the months goals are displayed along with the daily goals. The user will be able to toggle between two versions of this screen. ProfitX lite and ProfitX power user. The profitX PR will show all the figures and the lite version will only show the most important 6-10key point. m) 13th page will be an administrative page that calculates the different pay schedules for office help. n) 14th page will be an on-line calendar for users to book their appointment for phone consultation. The user will be able to see which days and times are available and book appointments; they will get an automatic E-mail reminding them when their consultation time is. 2) SUMMARY SHEET WILL NOT BE USED ON WEBSITE; IT HAS BEEN SPLIT INTO THREE OTHER PAGES (TECHNICIAN, YEARLY PR, AND MONTHLY PR) THAT ARE ACCESSING THE FORMULAS, SO THE PAGE COULD NOT BE DELETED IN THIS EXCEL WORKBOOK. 3) Technicians or office administration employee’s time sheets will need to be easily added (as new employees are hired) and incorporated in the program. 4) Being able to perform credit card transaction on line and automatically bill the user on a monthly basis. Keep track of each customers account. 5) All formulas secure, no outside sources can gain access. Web site designer will be able to change the text and outward appearance with no access to the back end program or formulas. 6) Data base can handle up to 5000 customers 7) Easy for the end user to input their data and interpret the results. Cannot look like an excel spreadsheet 8) Must be able to compare last years figures by year or month using charts and graphs able to drill down any time frame in report form like Quick Books Pro can do. 9) Have shopping cart to sell Marketing items, such as newsletters, flyers, preventive maintenance check out sheets. 10) Have three different levels of ProfitX to offer the end user. a) Level #1 the basic profitX, b) Level #2 ProfitX with on hour per month of phone consultation and access to marketing ROI spreadsheet. c) Level#3 ProfitX with one hour phone consultation weekly, access to marketing ROI, business projection, 401k, personal savings, retirement calculators. 11) The host has access to all the users’ information and is able to gather and compile the data into a comparison of all users. 12) The system will easily be able to be expanded and updated on a quarterly basis. 13) Hyperlink, so when mouse pointer is over financial name it will show brief meaning. 14) Be able to import data from different shop management systems. At the end of day when users closes out their shop management system the data should automatically be transferred into ProfitX. 15) Different levels of employee access. The ability for the shop owner to lock out P&L statement that has sensitive data about their salary or other personal data they do not want other employees with access to profitX seeing. 16) Copy right showing on every page and when printed show at the bottom of printed page. 17) Have tolerance reporting (conditional formatting) on reporting calculations. Use red, yellow or green light or thumbs up down, etc… ProfitX administrators will be able to change conditional formatting of numbers 18) Tip of the week displayed 19) suggestion box 20) (Future) blog 21) (Future) link for referrals from other sites. 22) (future) Advertising spaces 23) Have the capability to bulk-send e-mails to users, have the ability to send individual E-mails for customers if their subscription is running out or payment was declined. 24) Post news articles 25) Able to log in to customers data while they are looking at it to consult with them live time and change data to help them run different scenarios. 26) Have programmer thoroughly document the work they do. 27) Pages that need to be modified: a) On daily tracking sheet, spelled out days of the week next to numerical days of the month. b) Since the goal sheet has been modified the income analysis is not inserting the correct information into the goals sheet. c) In December the target gross sales in the monthly column cannot change. d) Technician time sheets need four compensation plan templates. Flat rate, hourly, Salary and custom. When flat rate pay is used, guarantee pay will also be active. When hourly pay is used, guarantee pay is inactive. When salary is used guarantee pay is inactive. When commission and custom is used guarantee pay is active. e) Administration needs bonus section added

Inżynieria MySQL PHP Zarządzanie projektem Architektura oprogramowania Testowanie oprogramowania Usługi hostingowe Administracja serwisami WWW Testowanie serwisów WWW

Numer ID Projektu: #3959112

O projekcie

14 ofert Zdalny projekt Aktywny Aug 14, 2008

Przyznany użytkownikowi:

metaxpert

See private message.

$11375 USD w ciągu 442 dni
(10 ocen)
7.8

14 freelancerów złożyło ofertę za $10260 w tym projekcie

LeadSoft

See private message.

$10200 USD w ciągu 442 dni
(32 Oceny)
7.9
GenuisDeveloper

See private message.

$8500 USD w ciągu 442 dni
(4 Oceny)
6.5
trustedcoder

See private message.

$5100 USD w ciągu 442 dni
(85 Oceny)
6.1
yonohesido

See private message.

$14365 USD w ciągu 442 dni
(1 Ocena)
2.7
lahorigroup

See private message.

$5100 USD w ciągu 442 dni
(2 Oceny)
2.2
vw1723858vw

See private message.

$42500 USD w ciągu 442 dni
(2 Oceny)
1.9
blazesoftvw

See private message.

$4675 USD w ciągu 442 dni
(0 Oceny)
0.0
ncstudio

See private message.

$6375 USD w ciągu 442 dni
(0 Oceny)
0.0
galileng

See private message.

$8500 USD w ciągu 442 dni
(0 Oceny)
0.0
pinkygosai

See private message.

$4250 USD w ciągu 442 dni
(0 Oceny)
0.0
vdomainsvw

See private message.

$12750 USD w ciągu 442 dni
(0 Oceny)
0.0
knowledgewell

See private message.

$5525 USD w ciągu 442 dni
(0 Oceny)
0.0
vw2086673vw

See private message.

$4420 USD w ciągu 442 dni
(0 Oceny)
0.0