I need help creating a table in excel that will count the profitability of in-house and outsourced trasport orders

Closed job

zarii 2 deals

GPT chat - search and paste data into excel.

Proposed by freelancer

31

14d

Good day, Excel covers about 100k records, for which I need an additional column of data, more precisely it looks like this: - Name - Brand - Missing data (code) So far, I have used GPT chat myself, returning one simple prompt + copy-paste column with Name and Brand. Out of 44 items sent back, the chat returned 43 items. The most important provision in the order refers to the following: The Contractor undertakes to execute the order with due diligence and in accordance with applicable regulations and requirements of correctness. Completion time: until 19.11
grucholl 6 deals

Entering car parts with translation from EN to PL - Prestashop

Proposed by freelancer

13

12d

I will outsource the input of various auto parts into a Prestashop store. I am looking for a person who has knowledge and experience of car parts and automotive and English language skills in this area. A person who knows the difference between a camshaft and a crankshaft or a stabilizer bar and a torque bar.... I have to introduce several hundred parts from the American market, which should be fully entered into the Prestashop store in Polish. I will provide part number, EAN code and product price. I will provide some catalogs where you can get information and pictures about the parts, but it may happen ( individual cases) that you will have to look for the information yourself. I ask in the offer to quote the price for running one item from the store.
Łukasz

Excel - working on a worksheet, formulas, data, etc. (sports statistics)

Proposed by freelancer

32

22d

I am looking for a person who will make me formulas from Excel data (VBA or other simple possibilities come into play). The Excel data is already prepared. In the future I will want to supplement the file with new data. In short, from the data that is already in Excel I want to flirt data according to my needs. E.g. averages/totals number of goals/cards/penalties of a team in a season, a year or in the last 5,10 games, etc., further after selecting "team" from the list I will see the statistics of a particular team. Then comparing 2 teams I add for example Arsenal vs Liverpool and it shows stats: team vs opponent from last matches, season etc. (I can choose from how many recent matches it should show). In general, I am open to suggestions, ideas and help to make this clear and functional. I will try to give more details, information or questions on priv. I am looking for a person for whom doing such things will not be a problem and maybe will offer his vision of how it can be done practically etc., because I unfortunately do not know the functionalists of Excel so as to use it 100%. Interested persons please contact me. Remuneration to be determined. In general I am open to suggestions, ideas and help to make it clear and functional.

PARTNERS SP. Z O.O. SK

Employer

Job category:

Databases

Expected budget:

Negotiable

Published: on 2024-04-11

Finished

Job description

the table is to collect data and automatically recalculate them, the difficulty is that the calculation of profitability of orders may consist of 5 to max 7 sections in which there is a loss on one section of the route and a profit on another, the orders would be finally settled in a full loop and the profit/loss of a given loop would be calculated, each section can be run by a different logistician (would like it to be visible, for example. different color for each logistician), only part of the columns would be active for logisticians, the rest would be uneditable for logiticians but editable for the manager