Find Jobs
Hire Freelancers

Create program to automate calculation of profit of sales

$10-30 AUD

Closed
Posted over 5 years ago

$10-30 AUD

Paid on delivery
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
Project ID: 18263713

About the project

8 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
8 freelancers are bidding on average $109 AUD for this job
User Avatar
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, Software Architecture, Visual Basic. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$200 AUD in 5 days
4.9 (330 reviews)
7.8
7.8
User Avatar
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.
$30 AUD in 1 day
4.6 (69 reviews)
5.4
5.4
User Avatar
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 to positive response. Thanks & regards Tapesh
$250 AUD in 6 days
5.0 (2 reviews)
3.9
3.9
User Avatar
"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 you that I can fulfill all of your requirements which you stated in your current project. I have a reliable and stable internet connection. I’m able to start now. It would be appreciated if you consider me for the job. I will try my level best to complete your project. Regards"
$50 AUD in 3 days
4.9 (17 reviews)
3.9
3.9
User Avatar
Hello, I am a statistician and R programmer. I have read your project description and here is an approach I can suggest for you. So since the sales data is present on the website, it is possible to twist things. It is better not to keep downloading the file each time and running the program just to get the profits. What I suggest is that you web embed a file/program that does that. And the program will be updated regularly without you touching it. For example this could be achieved using power Bi. The power Bi dashboard would have access to the data and would do calculations and produce charts. When you log in to the websitebthat contains the charts, you will for example see a line chart of the sales and a daily total, a weekly total and a monthly total. Other charts could be used too. This method makes it very easy honestly but it is quite lengthy and hard, but I am pretty sure if you share further details about the data the website produces I can help you. Please share with me some of the data, not all of it if you don't want to. By seeing the data I can tell how I can do this. Thank you, looking forward to hear from you.
$166 AUD in 10 days
4.8 (5 reviews)
2.9
2.9
User Avatar
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 Technologies for making user-friendly applications for their requirements i.e. 1) Extraction of data from Database and website for presentation. 2) Automated Email notifications with calculations. 3) Adding buttons for a specific function/requirement. 4) Comparing the cells with their data. 5) Formatting the spreadsheet and sending automated emails. 6) Searching, sorting, copy and pasting the data appropriately. 7) Changes to the old macros by standardizing the code. 8) Adding Add-Ins. 9) SQL procedures for automated functions and more... I can write VBA code for your requirement. Please let me know if more information is required from my side. Thank you.
$50 AUD in 3 days
4.7 (2 reviews)
1.3
1.3
User Avatar
Hello Sir... Hope you doing well, I read your project description so please come for technical discussion and we understand the negotiate cost, timeline then we move proceed further, also i show my past work during discussion.... Thanks..
$25 AUD in 1 day
2.2 (3 reviews)
0.9
0.9

About the client

Flag of MALAYSIA
Selangor, Malaysia
4.9
30
Payment method verified
Member since Aug 7, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.