Yuliya Karmazina
Private message
Offer work
Poltava,
Ukraine
available for hire
Rating
Skills
Programming
Design & art
Portfolio
- All works 26
- Photo Processing 5
- Online Stores & E-commerce 5
- Databases & SQL 13
- Website Development 1
- HTML & CSS 1
- Text Editing & Proofreading 1
-
7 USD Excel macro with form
Online Stores & E-commerce
The task:
Create a form with a list, data for a file to sub-download from the Excel file, the possibility of the vibration of any values and operations, after pressing the button - get the result
The result:
… - data to be downloaded from the Excel list;
You can use any elements of the list.
You can take the operation;
- after pressing the button - red the result in the text field, closed for editing;
- after pressing the "Closing" button the request for confirmation of closure, if no, then reject, if so - closure;
- after pressing the "Vidminity Viber" button cleans the Viber list, operations and result field
-
5 USD CSV file in Excel
Databases & SQL
Source data: CSV file, all in one line
TZ: divide by columns and find the sum of each role by other columns
Completed: on photo
-
Google Sheets Order Accounting
Online Stores & E-commerce
The source data.The table with the input of all the data "manual", the report for each month was made manually for each month separately (any new table each month)
TZ: Maximum all fields to automatize, create a month report from one table and each tab results for each month separately.The possibility of introducing an updated price of value and cost with the drawing of the true price depending on the date of order (e.g. 5.06 price of 100 UAH, and 10.06 price of 200 UAH, the order was 7.06, then it will be drawn 100 UAH, and if it was 12.06, then 200 UAH.completed by:
1 .Lids are imported into the document and by the phone number are drawn into the table.The price and cost of the goods are drawn by the goods and power depending on the date of order.
The monthly report is formed automatically, it is enough to make a copy of the list and indicate the appropriate month.The number of orders is counted correctly if on one date 3 orders under number 123, it is considered as one.All calculations on the report list for months are drawn up by formulas, you don’t have to insert something separately.Then separate tables were created for managers that they fill, the administrator collects data and copies them into this table, sets them additional parameters and based on the assigned parameters in the administrator table - the report is automatically filled according to the month they show (in the management tables).Algorithm: the manager fills a short version of the table (this managers are several) - the administrator copies them of these tables data into their own, assigns them certain parameters - some of them, necessary for reporting, are exported to the tables of the managers and they are formed from them.in the admin table the general report for all menagers
-
Google Sheets Price Calculator
Online Stores & E-commerce
Source data: list of manufacturers, goods, prices, size of goods
TZ: Create a drop-down list from the manufacturer to the product, draw true size of the product and price, in case of non-standard sizes the possibility of entering customer data and recounting the price according to them
Complete: the list of the manufacturer, depending on which manufacturer is selected - only its goods are drawn. From which goods are chosen, the dimensions and price are drawn. If in the name there is a "non-standard" note, then in the standard sizes is empty and the user is lighted a column and line to fill the non-standard sizes, the price of the goods is recounted.
-
24 USD Database of the Internet Store of Smartphones
Databases & SQL
Source data: text of task
TZ: Create an Internet store of smartphones in Access, with the possibility of authorization, personal office, access to site analytics, catalogue of goods, the possibility of ordering
Implementation: on the main page created: access to the personal office, after successful authorization, access to analytics and transition to the catalogue.1) The personal office:
1.1 ofpassing authorization, if successfully - transition to the possibilities of LK, otherwise - error
… If successfully fulfilled 1.1, the customer may change the personal data, view all of his orders and view orders within a certain interval of dates.Analysis of the store:
2) Possibility of adding supplies
2.2, 2.3) Delivery and sales report with further possibility of displaying data in the schedule
2.4, 2.5, 2.6) Search by dates, customer search, product search
3) Catalog of goods, where you can see the photo of the goods and its characteristics.3.1)If the customer wants to make an order, he presses "form the order" and in the form chooses his number, after which the current date is automatically entered, with the possibility to manually change the data and data of the customer that are drawn from the BD.After that, the customer selects the desired goods (automatically 1 piece, if desired, can be changed) and the amount of the goods and the total amount is calculated with regard to the discount, which is also automatically drawn from the customer's number.3.2) After completing paragraph 3.1, the customer will press "to make a order" and in the form check the data for delivery, which are drawn from the BD, with the possibility of changing the phone, delivery address, email and type of receipt.If the contract is not verified, the verification form is opened, where the customer must enter the verification code.
If verified / after verification - the order is successful.The macros were also used.
-
5 USD Formulas of Excel
Databases & SQL
Source data: text of task
TZ: Solve a task in Excel using a formula
Implementation: on photo
-
7 USD The task of optimization
Databases & SQL
Source data: task on photo
TZ: Resolve the task on a photo by the simplex method in Excel
Implementation: on photo
-
6 USD Excel + Forms
Databases & SQL
Source Data: Task
TZ: determine whether the point M belongs to the circle with centers in point C and the radius R using the VBA form
Implementation: With the help of VBA, the form is created and the code is written for the corresponding calculations. The customer enters the source data and automatically receives the result by clicking on the button.
-
5 USD Graphics of Excel
Databases & SQL
Source data: data tables
TZ: Build graphs of different types
Implementation: graphs are built by tables based on the customer's needs and according to the rules of the ratio of data types and diagrams
-
5 USD PDF to Word
Text Editing & Proofreading
Source data: PDF document
TZ: Create a Word document taking into account all formulas and formats
Implementation: a document that is formatted according to the source file has clickable formulas that can be easily edited.
The cost depends on the complexity and number of pages.
-
24 USD Bd access
Databases & SQL
The work is done in Access. It consists of 7 interconnected tables, 7 requests, 9 forms, 6 reports. The main button form is also provided, which allows you to go through sections, open the required reports/forms (which makes the program easier and more visual to use). Some requests/rapports use data from forms, which allows you, for example, to create a request from a form in which the interval of dates required for reporting is stated.
-
12 USD Testing
Databases & SQL
Source data: a list of questions with and without answers.
TZ: make a test where there are questions with a list of answers and open questions (required to enter answers). After all the questions are passed, the password will be displayed to view the result. Results on the template.
Implementation: a test with answers in the falling list is created and with the possibility of entering your answers (for the relevant questions). After all the tasks are completed, the password will be removed. The customer enters a password to remove the book structure protection, shows a list of answers and sees its result.
Replies in answers can be easily entered through the “developer’s list (tech. The list)
-
7 USD Dashboard sales
Databases & SQL
Source data: general sales table
TZ: to make a Dashboard
Completed: a summary table, built on it interconnected graphics with cuts (when choosing at least one of the parameters on the filter - information on all graphics is updated)
-
24 USD Calculator with database + report (Macro)
Databases & SQL
Source data: formula of calculation of value
TZ: create a calculator - goods check, add the data to the bd, on the individual tabs by check number output to the report template -1, 2.
Complete: the calculator in which the customer enters contact information, virin, height, from the falling lists chooses the appropriate parameters. After completion of the line of the goods, a post-release calculation and the total cost are made. If the calculation is passed, the storage button and the data from the table are exported to the bd (macros). On the 1 report tab, the customer enters the required check number and automatically receives the production report in the compiled template, and on the 2 report tab, the customer report. Each of the reports by clicking the button (macros) - we export to the pdf. Also, with the help of the macro automatically several times a day, the current currency cuts of the NBU are drawn.
-
7 USD Calculator - Price
Online Stores & E-commerce
Source data: a calculator of the organization, in which the width is manually entered, then the number of components is manually searched.
TZ: Automatize the selection of the components, depending on the width. Auto filling according to the indicated formula of the price network.
Complete: automated selection of the number of complements, depending on the input parameter. A formula is created to fill a price network, taking into account the values entered in the calculator. Lighting of the value that is active in the calculator.
Reviews and compliments on completed projects 22
13 September 2024
24 USD
Task for developing an Excel spreadsheet:
I want to express my immense gratitude to Yulia for her work on developing the Excel spreadsheet. Everything has been done at the highest level — the structure of the table, its logic, and design fully meet my expectations. You took into account all my wishes and offered excellent solutions that significantly simplify further work with the data.
Thank you for your attention to detail, professionalism, and promptness. I am very pleased to collaborate with you!
12 August 2023
14 USD
Change the formulas in Google Sheets so that everything works
It’s a pleasure to work with Julia. She is a great specialist and once you explain in detail what you need to do, she realizes it. We will continue to cooperate!
14 March 2023
12 USD
Conversion of PDF Documents into Docs
It’s not the first time I’m working with Julia. Quick and efficient implementation of the project. High contact. I recommend cooperation.
14 June 2022
10 USD
Convert pdf files to docx
timely and quality. Without any direction. High contact. I strongly recommend Julia to cooperate.
14 January 2022
8 USD
Implementing Illustrations in Microsoft Word
Julia is a very responsible and professional freelancer. Implementing complex schemes in Word quickly and efficiently. I recommend cooperation.
1 October 2021
6 USD
Correction of formula in the Excel table
Everything is great! Julia very quickly to deal with the landing formulas in the table, eliminated the bugs in a complex algorithm, to set new templates based on the old tables.
I recommend Julia as an explanatory professional in Excel, a careful and remarkable executive.
| Response feedback
19 September 2021
6 USD
Presentation of 17 slides
Thank you Julia for the quick and well-made presentation. The first part of the work (22,5%) was presented before the conditions were approved, so there was no doubt in the incorrect understanding of the task.
I was very pleased with the collaboration. I recommend it to everyone who needs a quality result.
| Response feedback
27 August 2021
6 USD
The Excel Formula
Thank you very much for the work, the work was done quickly.
| Response feedback
17 August 2021
20 USD
Editing Microsoft Access
Made well. I advise
| Response feedback
4 August 2021
12 USD
Таблица в эксель
Спасибо за работу, обращаюсь в третий раз, всем рекомендую
28 July 2021
6 USD
Эксель
Обращаюсь не в первый раз, доволен как слон, рекомендую по базам данных!
26 July 2021
8 USD
Working with macros in Excel
Enthusiastic, auditive, literary, thoughtful, I recommend!!!The !
| Response feedback
13 June 2021
19 USD
Working in MS Access
The work is done well and in time.
27 May 2021
24 USD
Course Project on Discipline Database Organization in Access
Thank you very much for the work done, everything was done quickly and efficiently.
19 May 2021
26 USD
Register the site manually on 100 sites without a car drive
Julia has done the job well. Everything is done according to TZ! A lot of thanks!
| Response feedback
3 May 2021
12 USD
Заказ 439
Рекомендую Автора, всегда прислушивается к рекомендациям, работа выполнена качественно, по требованиям и в срок.
14 April 2021
6 USD
Order of 393
I am grateful for the well done work. Fast, high quality and timely!!! I recommend it!!!The !
14 February 2021
9 USD
Complete the Excel table with the name of the photo
Julia, again, took responsibility for the work with the data. Everything is done quickly, quality and without mistakes. Thank you very much for the work! I will be contacting again!
| Response feedback
12 February 2021
9 USD
Working with Excel tables
Julia, responsible to work with the Excel file, which is a download from the database of the Opencart 3 online store. All data are properly sorted and arranged. A very responsible executive! Thank you very much for your work!
| Response feedback
30 January 2021
8 USD
Excel and Small
Very quickly and clear, despite all the difficulties with translation and databases.
I found a person with only the third attempt and very pleased.
At first, more than 20 people responded to the project, but the rest were unable to do so.
I recommend it.
27 June 2017
6 USD
Recruitment, placing content in WP
Julia is always in contact, with understanding and respect relates to work
27 June 2017
2 USD
Complete the tables
Very initiative and responsible. The work was done in time and quality.
Activity
| Recent proposals 10 | Budget | Added | Terms | Proposal | |
|---|---|---|---|---|---|
|
Creation of a financial table with margin calculation and further training on its use
24 USD
|
|||||
|
Data transfer from one Google Sheets sheet to another
24 USD
|
|||||
|
Automatically set parameter values in Google Sheets
24 USD
|
|||||
|
Google Sheets
12 USD
|
|||||
|
Creating a checklist in Google Sheets with score calculations
20 USD
|
|||||
|
Excel spreadsheet
22 USD
|
|||||
|
Creating a Google Sheets table with formulas for row calculations and output to the dashboard
96 USD
|
|||||
|
Excel help
12 USD
|
|||||
|
Macro or script for Excel
48 USD
|
|||||
|
Need to create 4 charts in Excel
12 USD
|