Create program to automate calculation of profit of sales

$10-30 AUD

Cerrado

Publicado

hace más de 5 años

$10-30 AUD

Pagado a la entrega

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

Excel

MySQL

PHP

Software Architecture

Visual Basic

ID del proyecto: 18263713

Información sobre el proyecto

8 propuestas

Proyecto remoto

Activo hace 5 años

¿Buscas ganar dinero?

Dirección de email

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto

Cobra por tu trabajo

Describe tu propuesta

Es gratis registrarse y presentar ofertas en los trabajos

8 freelancers están ofertando un promedio de $109 AUD por este trabajo

@schoudhary1553

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 en 5 días

4,9

(330 comentarios)

7,8

@surekash7096

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 en 1 día

4,6

(69 comentarios)

5,4

@EtherealCode

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 en 6 días

5,0

(2 comentarios)

3,9

@dataexplorer

"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 en 3 días

4,9

(17 comentarios)

3,9

@MasterKym

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 en 10 días

4,8

(5 comentarios)

2,9

@JadavSaikrishna

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 en 3 días

4,7

(2 comentarios)

1,3

@Ravbot

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 en 1 día