Skip to content

Latest commit

 

History

History
87 lines (52 loc) · 4.18 KB

README.md

File metadata and controls

87 lines (52 loc) · 4.18 KB

English · Русский

Clear spreadsheets and practical writing

Need a tidy product list, a clearer product description or instructions your customers can follow? Here is what the finished work can look like.

Open the 3-page PDF portfolio

1. Clean up or compare spreadsheets

The task: remove exact duplicate rows, make clear dates and numbers consistent, and highlight gaps. Or compare two lists and show where they differ.

Before After
12 rows, including two exact duplicates 10 rows in the cleaned file
Unclear dates and a missing price Three values clearly marked for review
A real zero quantity The zero is kept, not treated as a blank

You receive: the finished spreadsheet, the unchanged source and a short list of changes and questions.

Download the cleanup example · Download the comparison example

Example quote: US$15 for an agreed small task with up to 500 rows and 10 columns, covering up to three simple cleanup operations. Alternatively, compare two lists with up to 500 rows in total. One correction within the agreed scope is included.

2. Write a product description

The task: turn a few product facts into clear copy for a listing.

Before: bamboo desk organizer; five compartments; 22 x 10 x 8 cm; natural color; stationery not included.

After:

Bamboo Desk Organizer, 5 Compartments

Keep pens and small stationery items in five separate compartments. The organizer is made from bamboo in a natural color.

Dimensions: 22 x 10 x 8 cm. Stationery is not included.

You receive: a title, short description and specifications based on the facts you supply.

Read the complete example and source facts

3. Make instructions easier to follow

The task: turn an informal explanation into clear steps for a customer or colleague.

Example: how to send a spreadsheet sample

  1. Make a copy of your file.
  2. Include 10-20 rows that show the problems.
  3. Replace personal information with invented details.
  4. Explain what needs fixing.
  5. Show one example of the result you want.
  6. State the file format and preferred deadline.

You receive: a short guide with an easy-to-follow sequence.

Read the complete guide and original note

Discuss a task

Book Excel/CSV cleanup on Kwork (Russian). The Kwork package has its own scope and price, listed on the service page.

  1. Send a short description and a small, anonymized sample.
  2. Agree the result, scope, price, deadline and payment method.
  3. Receive the finished materials and any notes you need to use them.

Reply through the conversation where you received this portfolio link. If you already use GitHub, you can also leave a request here.

Only post invented or anonymized examples in public. Arrange a private channel for full working files.

Writing prices depend on the source material and agreed scope. The US$15 example above applies to spreadsheet work.

All examples use invented data and were checked against the source facts. They are demonstrations, not past paid client work or testimonials.

More about the spreadsheet examples and checks

The cleanup file contains 12 original records, a result with 10 records and a log of the two exact duplicates. An ambiguous date, an invalid date and a missing price remain visible for review.

The comparison file includes eight distinct product codes: two matches and six cases to check. Missing items, missing quantities, duplicate codes and different quantities remain separate. The text codes 0001 and 1 stay distinct.

These are finished examples. Editing a source sheet does not run the cleanup again. Summary counts recalculate from the displayed results. Saved data, calculations and sheet layouts were checked; desktop Excel was not run.

Русская версия · PDF portfolio in English