Irina Lavrik
Private message
Offer work
Kyiv,
Ukraine
7 years back
temporarily not working
10 years back
1 client
on the service 12 years
Rating
Successful projects
Average rating
Portfolio
-
Exporting MS Access to Ecxel with formating
Desktop Apps
Those who tried to use the built-in feature of exporting multi-level reports from Access to Ecxel, know that it results in a wicked and unreadable "lens" that is completely deprived of any formatting.
To export a report to Ecxel 1-in-1, a vba module was written, run by a MS Access button.
-
200 USD Collection and analysis of call reports
Desktop Apps
The organization receives daily reports of calls made by managers, in files in the formats xls, xlsx, csv. The program opens the files, extract the necessary information from them, collects in a single base and provides the possibility of analysis, search, viewing by managers, teams, projects, categories, samples about arbitrary criteria, graph building, etc.
-
CRM Psychological Center
Databases & SQL
Visitor cards, reception journal, statistics and reporting in the required forms.
-
CRM for a legal firm (specialization - DTP)
Databases & SQL
It allows to enter and systematize all the necessary information about the customer, the vehicle, the accident, the participants of the accident, the insurance company, the defendant, etc.automatically generate the necessary documents (claims, notifications, acts, contracts, letters, claim, etc.to keep information about all the actions, the periods of control of performance, the next stage, payment, completion of the work with the customer.
-
BD accounting of working hours and tables
Databases & SQL
Calculation of the time worked by employees, in the series of projects, objects and activities, with the conclusion of any combination of parameters for each period (months) and the arbitrary interval of dates.
-
10 USD Macro adding images to Excel file
Desktop Apps
On the entrance: specify the location of the Excel file in which images should be inserted, specify the sheet and range where the "key words" are to search for images; the location of the map with images.
Result: For each keyword, the macro searches for all the images with the name containing that word. If at least one image is found - a separate sheet with the same name is created, a hyperlink to that sheet is entered in the cell, and a hyperlink to the cell is entered in the sheet; the sheet to the left to the right in one line are entered all the images found; one of the images is also added to the outgoing note to the outgoing cell.
-
ARM manager for the sale of cars on order.
Databases & SQL
Part 1 - Catalogue
The catalogue contains all the necessary information about the car offered for sale, starting from the description of the model standard and its photographs and the list of the manufacturing modifications (combinations of the engine/CPC/wheel base and nick.The Dr.parameters), up to the list of options on order: possible colours, options of saloon sections, the baking of additional equipment, services and options.For each parameter, the price is indicated.The price of modifications replaces the price of the basic model, the price of options is summarized to the price of the model.Some options have additional restrictions.For example, some are incompatible with each other, and others, on the contrary, the second cannot be performed without the first pre-install; some options are not suitable for all modifications, etc.All these conditions are described in the database and visible to the manager when making the order, which reduces errors due to the manager's inexperience (for the implementation of ARMA the manager should either remember all of these features on the ground, or in the presence of the customer to read the technical documentation)
… (Continuation is followed)
-
24 USD “Objects of Unfinished Construction”
Student Course "Development of the database of the Agency for the Management and Sales of Unfinished Construction Objects"
The base is designed to be delivered as a student coursework, meets the given topic, the requirements of methodological instructions for the performance of the work, and contains all the required in the curriculum varieties of requests, forms, reports and macros.
… The work was done in a short time and was delivered by the student on "excellent".
Note: I don’t write any descriptions. 2400 were paid only for the development of the base. And it was worth it 100%.
-
The Palace of Water Sports
Databases & SQL
Another course work on MS Access. The base complies with the given topic, the requirements of methodological instructions for the performance of the work, and contains all the required in the curriculum varieties of requests, forms, reports and macros. The work was delivered by a student to “excellent”.
-
Import and processing of data from entering Exell reports
Desktop Apps
- receives the required data columns from the Excel file (the file structure may change);
Filtering unnecessary information;
- identify customers that are possible at all (families are indicated without errors or there is the only pretty close option) ;
- provides the user with a comfortable way to identify the other customers (configurable drop-box, with the input of each symbol, the number of options is reduced);
… By pressing the button, the data is stored in the base.
- data about the sales of each customer and displayed in a convenient form with the possibility to see from the first glance the substantial, with the system of flexible search for the necessary information and submission of results
- Customer reports are printed or in Excel;
- Customer results are grouped by managers and the corresponding final reports are printed in and in Excel;
By pressing the button, the reporting period is closed.
Backups are automatically created with the specified frequency.
-
51 USD Calculation of works and materials
Databases & SQL
Calculation of the works and materials of the construction firm, accounting of contracts, printing of documents, forming orders to suppliers on the basis of price comparison.
Database for the preparation of calculations, sending them by e-mail, after agreement -
forming a contract, printing the entire package of necessary documents (contract, amounts, accounts, cash orders, acts of performed works), forming an order for the delivery of materials to suppliers, taking into account the conditions of the contract, payments, the work of the brigades and their earnings.
…
A convenient entry of the supplier prices is provided, when the order is made (on the desire of the program) or the automatic choice of the supplier offering the best price for the product, or the choice of all possible suppliers manually (prices and availability information is provided for comparison).
It is automated to send outgoing messages to customers.
-
41 USD Organizer-memory based on customer base
Databases & SQL
ARM Manager for Working with Customers: Task Reminder + Customer Base + Communication History + Mail Server
It allows to account customers with the list of services that the customer uses, remind the manager of the payment deadlines and the approaching end of the service, the dates of the customer's birth, etc.
… There is a concept of contact with the customer (such as when with someone about what, what agreed at the end). There are also reminders about the need to call / write. It is possible to send email to the customer directly from the program.
Short instructions for operation directly on the picture.
-
Import of goods data from external files
Databases & SQL
The task of "knowing together" of various data about the goods coming from external sources (in this case - in the Exel table format) is solved, and in different input documents the same position may have different names. It was necessary by pressing the button to open the file, to compare the positions in it with the positions in the reference base, and to transfer the quantity and price data to the corresponding column of the resulting table; to save the information about the date of each such transfer, the lines of the resulting table to group by two independent parameters (group and category).
-
50 USD Reporting of experiments
Databases & SQL
A database of experimental accounts, including descriptions and inserted materials (photos, tables, etc.). Search for the name of the job, manager, dates or duration, organization, direction, section, state. View the description, adding investments.
The interface is convenient and intuitively understandable, the search is very flexible, all the lists and search results are prepared and deformed for printing on the printer, pdf file, Exel, etc.
… Execution period - 1-2 working days, the price of the question 50U / 400 UAH / 1600 r
-
50 USD Execution of entering documents for Autodora
Databases & SQL
Database for the accounting of receiving applications, their distribution by departments, the appointment of the deadline of execution, responsible and further control of the execution of applications, the ability to make a sample on arbitrary request.
The deadline of execution is automatically determined when the application is entered into the base, from the entering date according to the norms for this type of application, and can be corrected manually within the limits of this period, and increased above the norm - only for those types of documents for which the manual prescribes that this is permitted.
… Date and time of actual execution is fixed. The main form of the list allows one click to pick up all unfulfilled requests, delayed (not fulfilled + deadline passed), fulfilled in time, fulfilled with a deadline breach.
Search for applications by arbitrary criteria, as well as reporting is carried out in the "Search" menu.
Reviews and compliments on completed projects 1
16 June 2015
1800 USD
Development of a database in Access
Quality
Professionalism
Cost
Contactability
Deadlines
I thank the programming director Irina for the work done.
In addition to the written approach to the performance of the work itself, a quality brief was carried out.
This programmer clarified all the necessary information and thus, during the discussion, this programmer pointed out possible errors in my task that we discussed and corrected.
The professionalism of this programmer allows you to perform tasks of any difficulty. If someone is interested, I can confirm Irina’s qualification by showing an example of her work. My contact: Vitaly 8-964-767-00-01.
Thank you again for the quick and quick solution.
Profile deleted
| Response review
Activity
| Latest proposals 10 | Budget | Added | Deadlines | Proposal | |
|---|---|---|---|---|---|
|
Development of a database in Access
1800 USD
|
|||||
|
База данных "Закупки. Прайс. Технические характеристики"
226 USD
|
|||||
|
Доработать Excel
200 USD
|
|||||
|
Создание таблицы для учета заказов на предприятии
150 USD
|
|||||
|
База данных оборудования на складе
300 USD
|
|||||
|
Доработка базы данных Access
40 USD
|
|||||
|
Applications in Windows
125 USD
|
|||||
|
Базы данных для строительных смет и заявок
113 USD
|
|||||
|
Написать несложную программку склад под windows.
2 USD
|
|||||
|
Customer base sales department
9 USD
|
