MS Access / Excel database

Closed job

Recent jobs from category Admin support

  • no avatar
    Karol
    Excel - generate SKU combinations
    Proposed by freelancer
    21
    21d
    I urgently need someone proficient in Excel who can generate the names of goods based on rules, e.g. XX-YYY-ZZZ, where X = 1 v 2 v 3, Y = A v B v C, Z = 0 v R, i.e. I provide the logic for creating the names, and I need them generated.
  • no avatar
    Qmatch Consulting 1 deal
    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.
  • no avatar
    Łukasz
    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.
no avatar
AGREST
Employer
2 deals
Job category:
Databases
Expected budget:

Negotiable

Published:
Valid until:

Job description

Database of all products - product information i.e. name, expiration date

expiration date, batch number, SKU Wholesale, SKU Retail, wholesale price, retail price, etc.

Records in the database on our side.

Ability to simply enter records into the database

Ability to generate a file with prices (Pricelist) in XLS - records or, if possible

possible formatted ready file (for export to PDF)

Example columns: Name, Name, Inventory, Net price.

Possibility to generate a file with stock in XLS - records or

formatted ready file if possible ( for export to PDF)

Ability to generate file for label design in XLS - records: lot number

lot, expiration date SKU code, recipe, etc.

Ability to generate file for label design in XLS - records: lot number

lot number, expiration date SKU code, recipe, etc.

Ability to generate CSV file for importing product updates

Ability to develop the project further.

The job in figures:

/

Submitted offers 17

Add your offer or ask the client for more details