I need help by setting up remicrystal : see: [login to view URL] give you a good idea on what I am trying to achieve.
My making use of this software, I want to automate the whole process of updating and converting sales data from one format to a other..
What follows will give a good idea on what I am trying to achieve, Contact me after the demo software is downloaded and you convinced that you familiar with it and will be able to configure it .
Currently Reports are generated as follows.
1. Sales data is exported out of pastel to an excel sheet
[login to view URL]
2. This Sales Data file , is then being changed, manipulated /edited to the following structure :
[login to view URL]
HERE IS A DETALED EXPLANATION that can also be seen by clicking on the link below:
[login to view URL]
Sheet1 : raw sales data out of pastel.
Step 1: Pull Sheet 1 into mysql
Step 2: Add the column price per/kg – ( Total selling / qty)
Step 3: The quantity (column E) of some of these items was recorded in units and not kg – ( You will see the price/kg for these will be outrages high) and need to be adjusted in this step.
The items relevant is indicated on a Factor sheet :
[login to view URL]
Now in step 3 : if a item does have a factor ( see link above) – this item :00201007 - Whole Birds - Fresh - 1.20-1.3 does not appear in the factor sheet but lets assume it did and the factor was 12
Then : SEE step 3 – formulas in column E: the quantity is multiplied by the factor
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive response. Thanks.
I am Data Entry, MS Word and MS Excel Expert. i am very much professional in this work i am pretty sure that you cant find a best person for this job like me so i am ready to work on your project with low rate and high quality.