Freelance projects

Freelance projects

Creating a directory of companies from a database in Excel

Databases & SQL, Desktop Apps — incorrectly specified categories?

3512 USD

Project translated automatically. Log in or register, to view the original

Project Description (Technical Task)

Description:

This project is the second part of a document that should have two versions:

Print version
PDF version with clickable links (website, email, LinkedIn, page number).

The project includes several types of work:
- writing formulas in Excel, summarizing in a table
- visualization on the map - data output on the map
- creating company cards from a database
- preparing for printing

If some individual items cannot be completed, but the overall task is feasible, we can discuss it and omit some items.

Translation of the text written in English:

Document Requirements:

Page numbering:
- Numbering should start from a specified page number.
- The document should end with an alphabetical index of companies with page numbers indicated.
Document content:
- The document should start with a summary report of all companies plotted on a map.
- Next, companies should be classified by categories and subcategories.
- Each category section should start with a category summary.
- Companies within a subcategory can be arranged in any order.
- The next subcategory should start on a new page.
- There will be a total of 8 categories with the possibility of adding new ones.
- Each category will contain several subcategories.
Database:
- The database will contain up to 500 companies.
- Information will be regularly updated.
- Only selected companies (marked in column E) will be included in the summary catalog for print/PDF.
Page format:
- Each page should accommodate two companies.
- Page margins should consider space for binding (on the left side).
Document storage:
- Documents will be stored and used in OneDrive, with integration into Teams.

This technical task defines the main requirements and structure of the document. It should ensure usability in both printed and electronic versions, with the ability to quickly update information and add new data.

Proposals 4 Withdrawn 1

Aleksandr Visalchyuk

0 0

Projects -
Rating -
Rating 42

Budget: 100 EUR Deadline: 1 day

Hello, I will help you. Please write, I will be able to help you.

Artem K.

35 0

Budget: 150 EUR Deadline: 7 days

Good day, I will complete the full scope of work, offer an automated solution. Contact me, I have experience.

Mykhailo Pavlov

60 0

Budget: 650 EUR Deadline: 10 days

Good day!

Ready to create a catalog of enterprises from a database in Excel.

I have experience in developing similar projects.

I will be glad to cooperate!

The list does not show proposals concealed by the client or freelancer with a Plus profile, as well as proposals violating rules

Oleksandra Titarenko
Kyiv, Ukraine

Projects 2
Rating -
Rating 256

Creating a directory of companies from a database in Excel

Project Description (Technical Task)

Description:

Document Requirements:

Aleksandr Visalchyuk

Artem K.

Mykhailo Pavlov

Proposals are currently absent

Proposals concealed

Current freelance projects in the category Databases & SQL

Automation of the entry of income invoices in 1C 8.3 via the API of the document recognition service

Senior AI Systems Architect (Project Lead) Needed to Complete an Existing Unfinished Global Service

Development of the CRM module "Requests" in custom 1C (bus center)

Support for Samotur and its servers

Cleaning the client database in SIMLA CRM: phones, duplicates, cities