Create program to automate calculation of profit of sales
$10-30 AUD
Thanh toán khi bàn giao
Requirement :
Please download the files to understand the project , there is a video file to explain my requirement
[login to view URL]
You can also watch the video via youtube
[login to view URL]
I need a program to automate the calculation of my profit for website I am selling on.
website Shopee
In shopee , I am able to download file of orders (refer order file folder)
I need the program to calculate the profit by performing the following
[login to view URL] the Total Released Amount – from the settlement file (settlement file folder, column K value(there should be somewhere I can change the column in case the website changed the Total Released Amount to another column)
[login to view URL] the total order cost –
- Program has to have an excel database (refer to database folder) that stores which value to refer to in the [login to view URL] in order to calculate the total order cost
Example of the program interface
The program will first go to database to match the the product name and product variation to see if value has been set , if not found then will prompt screen for buyer to select the matching value in the [login to view URL] to set.
[login to view URL] gross profit and net profit
THERE SHOULD BE BE SOMEWHERE I CAN CHANGE THE COLUMN TO REFER TO AS SHOPEE CHANGES THE COLUMN POSITION NOW AND THEN
Gross Profit= Products' Price Paid by Buyer (MYR) (Column G)-Total Order Cost (Column AC)
Nett Profit =Total Released Amount(Column AB)-Total Order Cost(Column AC)
The columns of Products' Price Paid by Buyer (MYR) ,Total Order Cost,Total Released Amount,Total Order Cost- The columns location may change , please have a file/somewhere where I can change the column variable
ID dự án: #18263713
Về dự án
8 freelancer chào giá trung bình$109 cho công việc này
Hello, Hope you are doing well. I can help with you in your project Create program to automate calculation of profit of sales. I can assure you the quality job. I have good experience in Excel, MySQL, PHP, Sof Thêm
I have the expertise in Excel and the experience in creating applications using macros. I can build the spreadsheet as per your requirements quickly and accurately as per your requirements.
Hello.. How are you? I am an expert developer and able to do this work, I checked the video and read the job details carefully. I am sure I will do it. Can you please share more details for it. Looking forward Thêm
"Hi Dear, I’m an efficient data entry worker. I’m familiar with Google docs spreadsheet and I’ve experienced about collecting data from websites and enter into Excel and Google docs spreadsheet. I would love to tell Thêm
Hi, I can do this project easily because I have been developing and making the changes in Excel applications using VBA and SQL from last 6 years. I got appreciations from clients like British Petroleum and Wipro T Thêm