Task for developing an Excel spreadsheet:
22 USD The table is needed only in Microsoft Excel!
The table must work correctly on both Windows Microsoft Excel and Microsoft Excel for Mac:
General structure:
• The Excel file must have 11 separate sheets, each of which will record the total + add new ones (so the template can be added to new sheets).
• There must be a Summary Sheet that combines data from all 11 sheets and automatically updates when information changes.
• There must be a 2nd Summary Sheet that combines data from all 11 sheets and automatically updates when information changes, where only the client's name and total quantity will be displayed (Example Company and company 10 pcs * 60 = 600)
General scheme:
Date ——> Receipt ——> Balance ——> Return ——> Date ——> Shipments ——> Quantity * pcs = total ——> Percentage ——> Received ——> Percentage —→ Received minus percentage ——> Date ——> Received ——> Percentage between Shipments and Received
Fields (columns) on each sheet:
Date (light gray color) — Date of receipt.
Receipt (soft green color) — Amount of money received in the account.
**Date** (soft orange color) — Date of transaction.
Shipments (soft orange color) — Quantity of units and total related to shipments.
Quantity (light blue color) — Quantity of units involved in the transaction.
Total Amount (pale purple color) — Total amount calculated for each transaction.
Commission (light yellow color) — Amount of commission related to the transaction.
Received (after commission) (light green color) — Amount received after deducting the commission.
Percentage between Shipments and Received (light brown color) — Percentage ratio between the sent and received amounts, calculated using the formula (Received / Sent) * 100.
Colors do not have to be such that they are readable and not harsh on the eyes. Colors should combine blocks that are related to each other.
Requirements:
• Automation: The Summary Sheet must automatically update when data changes on any of the 11 separate sheets.
• Formatting: It is important to ensure color compatibility, readability, and lack of brightness so that all information is easily perceived.
• Scalability: Ability to add new sheets while maintaining all settings and automation.
Steps for implementation:
Create the structure and layout for each of the 11 sheets with the specified fields.
Apply color formatting to each of the fields.
Add a new column with the percentage calculation based on the formula (Received / Sent) * 100.
Set up automatic data updates on the Summary Sheet.
Conduct testing to verify the correctness of all functions and automatic updates.
The scheme is approximate; during execution, we may change something around (Started with a draft of the scheme, and then we will decide).
Client's review of cooperation with Yuliya Karmazina
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!
Freelancer's review of cooperation with Eugene L
Task for developing an Excel spreadsheet:Very pleasant impressions from the collaboration. I recommend this client.
-
3 days45 USD
419 13 0 3 days45 USD
Hello!
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
Hello.
I work with Excel and Google Sheets.
I am ready to help using formulas or macros (scripts).
… Connection with Telegram bot and e-mail with Google Sheets.
I will be happy to collaborate.
-
Winning proposal1 day22 USD
345 22 0 Winning proposal1 day22 USD
Hello. I have extensive work experience. I would be happy to collaborate. Please feel free to contact me.
-
2 days22 USD
127 2 days22 USD
Good day, I am ready to complete your order. We can discuss the details in the chat.
-
4 days33 USD
286 4 days33 USD
I am ready to take on the work and complete it as quickly as possible. We can discuss everything in the chat.
-
1 day22 USD
561 15 0 1 day22 USD
Good day! I will do it quickly, efficiently, and according to your wishes! Just a couple of questions: where do we get the client's name on the 2nd general sheet, from the sheet names? And on the first sheet, do we just display all transactions, or do we group them by some parameter?
-
2 days33 USD
1108 19 2 2 days33 USD
Good afternoon.
I am ready to do it.
I have familiarized myself with the terms of reference.
I have experience with similar tasks.
Deadline is 1-2 days.
…
The budget needs to be raised a bit.
-
2 days24 USD
453 3 0 2 days24 USD
Hello!
I will gladly fulfill your order. I will do it quickly and efficiently, taking into account all your wishes.
I can start working immediately after our discussion.
I have free time, so I will take it on right away.
I promise style, quality, and good emotions from our collaboration. Thank you!
Current freelance projects in the category Data Processing
Building financial models (P&L + Cash Flow)We are looking for a qualified specialist who can help organize our business finances. We need to develop and implement two key reporting forms: P&L (profit and loss statement) and Cash Flow (cash flow statement). Please provide your work experience, what you have worked on,… Accounting Services, Data Processing ∙ 3 days 15 hours back ∙ 17 proposals |
Assistant to the manager for project work in the field of science and scientific publicationsLooking for a responsible assistant to work with personal social networks, a contact database, and current projects in the field of science and scientific publications. At the first stage, the collaboration is planned for one month. The main task is to assist with basic… Information Gathering, Data Processing ∙ 4 days 7 hours back ∙ 11 proposals |
Contacts of the Northern European countries
28 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 6 days 7 hours back ∙ 21 proposals |
Search for contacts_Southern Europe (Greece, Italy, Spain, and France (south and north of the country))
22 USD
Hello everyone I need to find contacts of companies (Cleaning Company) that are engaged in cleaning in one of the niche industries - shipping. These companies deal with cleaning ships of various purposes, - cargo ships (only cleaning of ships) and the service is called - cargo… Data Processing, Information Gathering ∙ 6 days 7 hours back ∙ 19 proposals |
Search for manufacturer / contract manufacturing Ukraine
22 USD
Need to find 3 contract manufacturers of dietary supplements in the form of gummy candies in Ukraine or nearby countries (Hungary, Poland), and inquire about the terms of cooperation: - minimum order (price) - price for increased volume - number of functions they can produce?… Marketing Research, Data Processing ∙ 8 days 16 hours back ∙ 14 proposals |
Kyiv