Completed

Project for Le T. -- 2

Hi Le T.,

You built me an excellent solution to use a central SQL database to update information in excel documents we use for cost calculations.

We would now like to consider taking this to the next level.

The goals would be to have

- an online record of every version of the costing being created.

- reporting on each costing.

- ability to have master costings pages for common clients to speed up calculations.

1.) Upload every version of the excel file to the SQL server and assign it a unique reference number. Number would be QWS version (Input Page!S2) (NL,UK,DE,FR,ES,etc) followed by a number followed by version number. As the excel file could be revised multiple times, once it has been assigned a reference number then should just be shown as revision 1, 2, 3 etc.

2.) Ability to download to excel file specific file by entering reference number.

3.) Ability to search using a web page SQL database by reference number, Project Manager(Input Page!E11), Site name(Input Page!J6) or post code(Input Page!J10). Then click on result wanted and download into excel file.

4.) Statistic page able to sort by Project Manager(Input Page!E11)/KAM (Input Page!E15) and output list of files uploaded by date range. Output to include Date uploaded, Site name, Project manager name, KAM name, Version number, value

5.) Ability to download pre created master template excel file to speed up entry. Template excel files uploaded similar to step 1, but not assigned a unique reference number.

All communication on live system will be to a URL rather than fixed IP. Test system uses IP.

1.) Upload every version of the excel file to the SQL server and assign it a unique reference number. Number would be QWS version (Input Page!S2) (NL,UK,DE,FR,ES,etc) followed by a number followed by version number. As the excel file could be revised multiple times, once it has been assigned a reference number then should just be shown as revision 1, 2, 3 etc.

2.) Ability to download to excel file specific file by entering reference number.

3.) Ability to search using a web page SQL database by reference number, Project Manager(Input Page!E11), Site name(Input Page!J6) or post code(Input Page!J10). Then click on result wanted and download into excel file.

4.) Statistic page able to sort by Project Manager(Input Page!E11)/KAM (Input Page!E15) and output list of files uploaded by date range. Output to include Date uploaded, Site name, Project manager name, KAM name, Version number, value

5.) Ability to download pre created master template excel file to speed up entry. Template excel files uploaded similar to step 1, but not assigned a unique reference number.

All communication on live system will be to a URL rather than fixed IP. Test system uses IP.

Would you be able to work on this and also let me know what you think it would cost along with time needed. Happy to wait.

Many thanks

Matt

Skills: Excel, Java, Visual Basic, Web Scraping, XML

See more: noun project icons, researchgate "activate project", researchgate project, researchgate help, free icons for commercial use, researchgate delete project, researchgate duplicate publications, how to remove project from researchgate, at&t customer service work from home, project manager m&e dubai work, imagine that you are the project manager for this initiative in the north west province outline steps you would take to ensure t, graphic designer or multimedia designer rm 2 000 work, project for opworth 2, project for opworth -- 2, project for louiejayo 2

About the Employer:
( 28 reviews ) Crowborough, United Kingdom

Project ID: #15391957

Awarded to:

kepler452tech

Hired by the Employer

$150 USD in 3 days
(9 Reviews)
3.6