Meter Reading Before and After Decanting.

Meter Reading for the Load.

Purchase Entry Form with Load Reading Button

New Button <Load Reading> introduced in Stock-In entry form as shown above to call new form for recording meter reading and Dip entry before and after decanting of loads. Software also alerts users to enter Load Reading on click of <Save> Button for Stock-In. When user chooses to record the Load Reading it will open the new form as shown below:

 

Dip Reading for the Selected Load

 

All user has to do is select the Gan (Goods Acceptance Note) number for the load of the day to select the load for which he/she wishes to enter the Dip and Meter Reading before and after decanting of load as shown in the above and below given image. Please note the Dip entry in above image. It allows user to enter the Dip in CM (Centimeter) as in the dip stock entry form and automatically get the Volume / Dip Stock from the Calibration Chart. Also note that as soon as you enter the Dip in CM for Opening Dip before decanting and Dip after decanting, it shows the variation if any as shown in above image.

 

Meter Reading before decanting of load

 

Please note that Meter Reading before decanting of next load and Closing Dip Entry before decanting of the next load is automatically retrieved from the next load entry if recorded. One can freely Select the load for which he/she wishes to record the reading and save them and switch from Next load to previous load to edit/update/refresh the reading from the next load. All user has to do is just delete the next load data and press enter to refresh the reading from the next load.  Also please note that user has to enter Testing manually (for now) which will be automatically retrieved from between the meter reading of the shifts.

 

View / Print Loads to generate Report

 

Just click on View/Print tab to view the load reading saved for different load/shifts. Just click on the Gan_No / Gan_Date of the load for which you wish the report to be generated. As soon as you click on the row, it will highlight in red as shown in the image above. Just click on the Print Preview button to generate the report as shown in the image below:

 

Stock Variation Gain/Loss between the Load

Advertisement

Import Meter Reading and Dip Data.

28/09/2010

Now, it is possible to Import the bulk meter reading data and dip entry data in the software without keying in manually. This is very useful particularly, in case when user intends to go online without entering data manually for past months.

Import Meter Reading Data
It is now also possible to Import Meter Reading Entry data. You will find a New Tab introduced in the Meter Reading and Dip Entry form. In the Import tab you will be asked to select the Excel File containing the Meter Reading Data / Dip Data, Click on button to select the excel file. After choosing the Excel File, user will be asked to select the Sheet containing the data for the Meter Reading/Dip Entry. By Default Excel Workbook has Sheet1, Sheet2 and Sheet3 but user may have renamed the excel sheet and therefore user will be asked to select the sheet name in which the data for the Meter Reading and Dip entry is stored. After choosing the Sheet, user has to click on the button to populate the data for the sheet in the Grid below the Populate button. If the data contained in the sheet is verified as correct then user has to click on to Import the data to the Shift Meter Reading.

Data contained in the Excel sheet should be as per the Specification given below:

Meter Reading Data

Column 1: Should contain the Shift Date, which should be in dd-MMM-yy format i.e. 01-APR-10
Column 2: Should contain the Shift_ID (1,2,3) as created in Shift Master.
Rest of the columns can contain the Meter Reading data as desired but the Column heading specification should be as given under:
e.g.
where stands for Nozzle Description as given in Nozzle Master for ULP/Petrol Nozzle Number 1 in above example. should be followed by to specify that the column contains the Meter Reading Data for the said nozzle.

Similarly for Testing data for the said nozzle you have to specify the column name as to contain the data for Petrol Nozzle 1 and so on.

Please note that the First row of the excel sheet should contain the Column Heading specifying the Data contained in the column, Second Row being the Opening Meter Reading for the First day in the sheet and third row containing the Meter closing for the first day and Meter Opening for the next day, fourth row onwards the closing meter reading data for the date in the first column and so on.

Import Dip Entry Data
Just as Import Meter Reading data mentioned above, it is now also possible to import Dip Entry data. To Import the Dip Entry data, procedure to be follow is exactly as mentioned in import meter reading data above.

1. Select the Excel File
2. Select the Excel Sheet to Import which contains the Dip Entry Data
3. Click on Button to populate the data contained in the selected sheet to preview before actually imprting data.
4. Click on Import Data button to Import the data.

Data contained in the Excel sheet should be as per the Specification given below:

Import Dip Reading Data

Column 1: Should contain the Shift Date, which should be in dd-MMM-yy format i.e. 01-APR-10
Column 2: Should contain the Shift_ID (1,2,3) as created in Shift Master.
Rest of the columns can contain the Dip Reading data as desired but the Column heading specification should be as given under:
e.g.

where stands for Tank Name as given in Tank Master for ULP/Petrol Tank in the above example. ULP should be followed by to specify that the column contains the Dip Stock Volume Data for the said Tank.

Similarly for importing the Dip Reading data for the said Tank you have to specify the column name as to contain the Dip Reading data in CM as per the calibration chart for Petrol Tank and so on.

Please note that the First row of the excel sheet should contain the Column Heading specifying the Data contained in the column, Second Row onwards being the Dip Reading data for the date in the first column and so on.