XL-ian

Microsoft Excel Consultant

 

 

The XL-ian Simplified Stores System

 

 

The main screen

 

 

Clicking on the Cell opens a drop down box with a list of tradesmen.

 

Once the tradesman has been selected the date and time is recorded.

 

The “Machine” and “Part Number” cells are drop down lists. Selecting the “Part Number” automatically fills in the “Part”.

 

 

Enter the quantity of “Parts” taken from the store.

 

 

Should “Parts” be returned to the store they are entered in the “QTY RTN” cell and the “ACT QTY” (actual quantity) cell is adjusted.

 

The cost of this stores system is £100

 

Contact details

 

E-mail       ian@xl-ian.com

 

Telephone          07773731429