Excel 2000 MSDE 2000
This project received 10 bids from talented freelancers with an average bid price of $ USD.Get free quotes for a project like this
Project Budget$20 - $100 USD
Objective: Create Excel 2000 macros to import/export workbook data to/from MSDE database.
1. MSDE 2000 database
[url removed, login to view] Sql script to create new database, tables, relationships
1b. Required Table ProjIssue (Field/Type/Size/Key)
1c. Required Table ProjGap (Field/Type/Size/Key)
1d. Required Table ProjActionItem (Field/Type/Size/Key)
1e. Required Table ProjCTQ (Field/Type/Size/Key)
1f. Required Table ProjAssumption (Field/Type/Size/Key)
1g. Required Table ProjResource (Field/Type/Size/Key)
1h. Required Table Project (Field/Type/Size/Key)
1i. Enhance DB Design/Schema to easily support the following reporting relationships
Project > ProjIssue
Project > ProjGap
Project > ProjCTQ
Project > ProjAssumption
Project > ProjActionItem
Project > ProjResource
ProjIssue <> ProjGap
ProjIssue <> ProjCTQ
ProjIssue <> ProjAssumption
ProjIssue <> ProjActionItem
ProjIssue <> ProjResource
ProjGap <> ProjCTQ
ProjGap <> ProjAssumption
ProjGap <> ProjActionItem
ProjGap <> ProjResource
ProjAssumption <> ProjActionItem
ProjAssumption <> ProjResource
ProjResource <> ProjActionItem
1j. Provide parameterized script option to add tables to an existing Database or (default: create new database)
2. Provide script to automatically Create MS Excel 2000/2003 compatible workbooks from database
2a. One workbook per project
2b. Separate worksheets for Issues, Gaps, Assumptions, ActionItems, Resources, CTQs
2c. First row of each workbook is column headings from database tables
2d. Resources sheet is populated from Database on workbook creation.
2e. Drop down list boxes on Issues, Gaps, Assumption, Actionitems, CTQs sheets are implemented for Owner, and RaisedBy columns.
2f. Provide ability to enter a new Resource (not in database, or list box) from the spreadsheet and have it populate the database, and refresh the Resource Sheet.
2g. Automatically enable autofilter on all sheets
3. Create Excel macros inside MS Excel worksheets to import from/export to the database.
3a. Use generic re-usaable parameterized subroutines and functions,
3b. Import option to overwrite or update changes only from worksheet to database.
3c. Import/update all worksheets within a workbook at one time to database
3d. Export option to overwrite or update changes only from database to worksheet
3e. Export/update all worksheets within a workbook at one time.
4. Produce .Net web site control panel to administer utility scripts.
4a. Create new, empty database
4b. Import to existing database
4c. Select Project to export from Datbase to workbook.
4d. Select directory/file name to create new Excel Workbook(s)
4e. Select file or directory for import/export
5. Critical To Quality:
5a. Synchronise multiple copies of project workbooks to database without error
5b. bi-directional update from database to workbook and from workbook to database
5c. Time to delivery
5e. Compatiblity with MS Excel 2000.
5f. Compatibility with Win2k and Win XP
5g. Flexible DB design for future enhancements.
5h. Parameterized scripts
5i. Table driven parameters.
5j. Simple, Easy to use interface.
5k. Must run on desktop as standalone (with command line or graphical utility) if no webserver is available.
6. Provide detailed deployment instructions for web deployment and desktop deployment ( win2k/win XP)
6a. Provide suggestions for future improvements.
6b. Provide "lessons learned"
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online