Order to automate the import of customer order data into an Excel database

Closed job

Decoretti

Active PDF prints with counting option

Proposed by freelancer

3

29d

I need to make some active PDF prints, with the option to conveniently fill in and count fields.
Qmatch Consulting 1 deal

Creating the company's budget - financial analyst / controlling

Proposed by freelancer

6

26d

Good morning. I represent a consulting company for the SME sector. We are looking for a finance/controlling specialist for a project in the field of budget preparation for our clients, consulting in the area of controlling (including analysis of the statement of sales and balances, recommendation of sales segments, recommendation of coverage margin account, analysis of other fixed costs, creation of budget stucture, creation of controlling and reporting tool and processes). In the plan for long-term cooperation on specific projects, the first project to start "right now". If interested, please send me a private message. The ability to implement the budget independently is key.
Aleksandra46 1 deal

Statistical calculations from surveys located in Excel

Proposed by freelancer

7

16d

Hello, I need help in working out some statistical calculations for a paper. It is not required to work out the entire results of the study. Do any of you have a deadline and access to a statistical program ? A few statistical calculations are required to confirm the hypotheses, among others. It is not required to elaborate all 45 columns, it is just that the principal wished that in the work there should be "come some statistical calculations".
PARTNERS SP. Z O.O. SK

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

Proposed by freelancer

12

11d

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
AndrzejTW

Support make.com or zapier.com - setting up automation

Proposed by freelancer

10

3d

We are looking for a person who has experience with zapier.com, make.com or similar tools. It is about setting up and connecting databases and automating activities.

Łukasz Nowakowski

Employer

Job category:

Databases

Expected budget:

Negotiable

Published: on 2024-04-08

Valid until: on 2024-05-08

Job description

I will outsource the task of automating the import of customer order data into an existing Excel database and assigning the appropriate data for new items from orders based on the existing database.

Details:

1. downloading the data from a csv file that will be updated once a day and uploaded to an FTP server from the client.

2. Putting the data into an Excel "Database" file by searching for a unique commodity code and assigning individual values to it from the following columns: order number, quantity ordered, date, place of delivery and price.

(3) The rest of the information assigned in the database for new items and the individual commodity code (ITEMID) should be invariable such as packing patterns, pallet dimension, number of pieces per pallet, labels, etc. and taken from this database.

4) Each new order should add itself as a new line in the file, without deleting previously added orders with the same item.

and more