Excel Input Improvements

The spreadsheet attached is used to create quotations for producing cladding panels. The user fills in the grid input and panel input sheets, and the summary sheet can be printed to provide quotations.

The area that needs improving is columns E and G on the panel input sheet.

_How it currently works

_The user selects the number of bends in column D. A dropdown appears in column E. It contains a number of lengths (which is the number of bends plus 1). These then have to be clicked individually, then entered in a popup. The cell then contains the total of all the lengths that have been entered. You will see that it is a bit buggy and tedious to use.

The same applies for the heights in column G.

_How I want it to work

_When the user selects the number of horizontal bends, I want a popup window/form to appear in the centre of the screen. It will have labels and text boxes for each length that is required (no. of bends +1). These are then entered on the popup window instead of the drop down that was previously used. The user can tab to the next textbox to be filled. User clicks 'Ok' button when the lengths have been entered, and the total is in the appropriate cell in column E. If an error has been made, all the user should have to do is select the number of bends again for the popup window to appear.

The same will apply for bends selected in column F, popups will appear for heights and totals will be displayed in column G.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

win xp

excel xp

PHP

ID do Projeto: #3370024

Sobre o projeto