Switch to English?
Yes
Переключитись на українську?
Так
Переключиться на русскую?
Да
Przełączyć się na polską?
Tak

Freeelancers' best works

69
  • 20 USD

    Creating Word documents with data from Excel

    Data processing
    With the VBA based on the MS Word document template 1 for each line from the MS Excel 2 table, the MS Word 3 documents are automatically created (the template dates and prices are transferred to the required places, and the prices are formed in English and English)


  • 50 USD

    History

    Business card design
    #CorelDRW #VBAforCorelDraw #coreldraw #history #wallpaper #wall


  • 510 USD

    The Junior C# Developer

    C#
    #.net #csharp #mssql #rabbitMQ #WPF #css #vbaexcel #vba #vbscript #vbs


  • 23 USD

    Automatization of a table in Excel from the Word document text

    Application programming
    The task is to transfer a list of questions (question_1, question_2,...) in different languages (language_1, language_2,...) with the variants of answers (variant_1, variant_2,...) from the Word document to the Excel table so that different translations of one question are positioned horizontally and the variants of answers are positioned vertically under the questions.
    To automatize data transfer, a macro for Excel is created that reads a Word document, sets out the text language and text questions, answers options, and forms the final table. If it’s impossible to resolve the complex questions, the macro releases a list of problem lines that can be quickly corrected in the Word document.
    #vba #excel #vbaexcel #word


  • 74 USD

    Processing different Excel preliminaries into a single table

    Application programming
    On the basis of the Requirements of the Customer, a special Excel book with a set of macros was created, using which you can:
    - Distinguish the range in different preyles;
    to give them the titles;
    - Set the rules of their placement in a single table.
    For the convenient use of the macros, appropriate dialogue windows are developed.
    As a result, you can get a single table from the pre-lists of different structures.
    #vba #excel #vbaexcel


  • The Predictor and Parsers

    Data parsing
    The VBA (Excel)
    The program in general is the "predictor" of the results of the game for football bet.A separate module collects data on statistics and current rates sites.Based on these data, the program advises you to make certain bets.The module that collects data on statistics and current rates websites is written on the VBA for MS Excel.This is a fully functional work example.You can observe how my parser collects and analyses data from the Internet.2 methods are applied.Instructions for use are in the file.=========================================================
    Forecaster and Parser VBA for MS Excel
    Whole program is the predictor of football rates, which collects data on websites on statistics and current rates.Based on this data, the program advises you to make certain rates.This is part of the program, which collects data on websites on statistics and current rates.Based on this data, the program advises you to make certain rates

    This is a fully functional working example.You can try as my parser collects and parse data from the Internet.2 methods are applied.Instructions for use are in the file.


  • optimization of containers. The algorithms

    Application programming
    The VBA (Excel)
    Description of the task.
    Distribute the cargo (blocks) of different masses into containers.
    The containers are standard, the same size.
    Maximum weight of 28 tons (this parameter can be changed)

    The essence of the problem: it is necessary to minimize the number of containers to load the arbitrary party of blocks

    Attache - a file with a program-solution + a pair of data packages (a small test and real). Instructions for work inside. The customer received real savings (the number of containers decreased by 10-15% compared to the option used earlier).


  • Construction of the component name for radio engineering.Form

    Application programming
    The VBA (Excel)
    Task: Development of Forms
    Problems: Complex logic of displaying information
    The details:
    The designation of the dialog window "Composition of the component name" looks as follows:
    • Component names consist of a scheme suitable for each component library.
    • Improving uniformity by using the drop-down menu.
    • Increase productivity by accelerating work than creating names in the text scheme.
    The duplicates are not created.
    It doesn’t sound a little Russian, but it was made for the customer in the US. The meaning of the task in other words: it is necessary to standardize the composition of the name for the components of radiotechnical schemes from the specified sets according to certain rules and restrictions. It is these rules and limitations that complicated the logic of the project as a whole and the work of the elements of the form in particular.


  • Advertising Calculator (ActiveX Elements)

    Application programming
    The VBA (Excel)
    Calculator for a advertising company with management elements (sliping lists, etc.) It is intended for the local market.
    This is an advertising sales manager in a real advertising agency.


  • Information through the API

    Application programming
    Macro vba causes API through Python, processes information and returns the desired result.