Reproduction of Excel tables
It is necessary to convert the catalogue of goods into a regular table.
The work is not difficult, it requires no knowledge except copying-inserting.
Lists in the catalogue are many, more than 30th.
Work is urgent, for the execution of a maximum of 3 days, and you will need to drop the intermediate results a couple of times a day. I may choose several performers at once and share the lists among all, because. Really need to be fast.
https://yadi.sk/d/Yayx96Ya4z5bQA - файлы тут.
Задание:
1. То, что находится в шапке таблицы в источнике - это отдельные столбцы - материал корпуса, производитель, страна и тд. Это будет общее для всех строк, пока не дойдете до следующей шапки.
2. Под еще несуществующие поля - заводим новый столбец - на листе "Термоголовки" - это Тmax и Длина, к примеру. При этом те, которые не используются - просто оставляем пустыми.
3. Картинку переносим так, чтобы было понятно, к каким строкам она относится. Можно изменять размер, либо ставить границу сверху-снизу.
4. В таблице не должно быть символов надстрочных и подстрочных. К примеру, значок градуса - убираем. Также единицу измерения ставим через запятую в названии столбца. Например: Tmax , C.
5. Если у одной характеристики несколько артикулов, заполняем для каждой строки идентично наименование, характеристику и прочие моменты.
6. Лист в новой таблице называем так же, как и в источнике.
7. Работаем внимательно, эти таблицы будут грузиться в 1с, как товары.
8. если у товара нет характеристики, не заполняем, я потом сама посмотрю, что туда вписывать. Это хорошо видно на вкладке с трубами.
9. https://pastenow.ru/e88f0636643667e381e6926b78057519
Жду адекватных ставок.
Client's review of cooperation with freelancer
Reproduction of Excel tablesEverything is fine, quickly, thank you very much! Responsible executive, I advise.
![]()
Freelancer's review of cooperation with client
Reproduction of Excel tablesA good, friendly customer. I recommend cooperation.
![]()
-
1696 46 0 Hello to you. Ready to perform. I work as a designer on heating, ventilation. There is understanding of products.
-
221 1 1 Ready to perform the work. Agree to the whole volume or part of it. There is experience with Exel.
-
292 5 0 There is free time to work quickly. I am a financial teacher, so I understand Excel well.
-
100 Welcome, ready to fulfill your task quickly and quality, I will be happy to cooperate.
-
12 Experienced Excel user, great experience in monotonous work. I will be happy to cooperate
-
268 15 0 Good day, there is time and desire, I will start immediately after approval of the bet.
-
596 42 0 Ready to cooperate. I can take part of my work, I have experience.
Go to turn!
-
115 9 1 1 Good day ! Ready to perform the task immediately. Discussing the details of TZ in LS. Go to turn.
-
117 Good day . Ready to fulfill your order quickly and efficiently. There is experience in this field.
-
1241 135 1 Good day .
The task is clear, ready to perform the task quickly and efficiently.
Write it.
-
462 23 0 Good day ! Profiles in Excel. Qualitatively and quickly. My contacts:
Viber: +380985124400
by Skype: hrom.ri
Email: [email protected]
-
196 11 0 Hello to Eugene!
I will convert your catalogue into a table.
The cost is 15 grams/st.
Let us collaborate!
-
661 38 2 You can create a VBA macro that processes your tables in a few seconds. (Truly, it will take a few hours or days to write a macro.)
Great experience in this direction: http://vba.valemak.com/
The price is conditional, for the exact price you need to read the Excel files themselves, not the screenshot.
-
1855 129 0 Hello to you.
The task is understandable. In a day or two I will do it carefully and carefully.
I need to clarify the details. How many fields?
The price of the line 0.8-1.5grn
-
1666 124 4 1 Ready to work on your project.
There is experience, feedback in the profile.
Examples of portfolio.
The price depends on how much for 1 product fields.
Write and discuss details
-
162 Ready to meet the conditions! We have a long experience with Microsoft Office.
-
Заинтересована в данной работе. Вышлите задачу и укажите условия оплаты
-
Current freelance projects in the category Text Editing & Proofreading
Retyping and Translation (etc)
50 USD
We’re a small freelance team looking for reliable, skilled people to help with different online tasks. It’s flexible, the pay is good, and you get paid instantly after each job — no waiting around. Copywriting, Text Editing & Proofreading ∙ 22 minutes back ∙ 4 proposals |
Digitization of textThere are about 200 pages of text with tables available. They need to be typed in MS Word. With quality structuring and formatting. An example is attached. Text Editing & Proofreading ∙ 10 hours 48 minutes back ∙ 48 proposals |
Filling in the product card on Prom.ua from a European websiteFilling in the product card on Prom.ua, translating text into Ukrainian and Russian from European websites. Transferring images and technical specifications. Category: flashlights and equipment for photo and video shooting. SEO in the product card. The work is not much, but… Advertising, Text Editing & Proofreading ∙ 1 day 2 hours back ∙ 31 proposals |
Create a document template
16 USD
Need to make copies of the document template. There is little text, few tables. No requirements, just 1 to 1. 2.5 pages. Not much work. Payment 300 UAH Text Editing & Proofreading, Technical Documentation ∙ 3 days 20 hours back ∙ 14 proposals |
Content manager for working with price lists and products on Rozetka and Epicenter
89 USD
Processing supplier price lists. Creating new product items without duplicating existing products on marketplaces. Searching and matching products by article number, barcode (EAN), name, and characteristics. Filling in characteristics, descriptions, photos, and other product… Advertising, Text Editing & Proofreading ∙ 11 days 7 hours back ∙ 9 proposals |