Task for developing an Excel spreadsheet
22 USD Technical assignment for the development of an Excel spreadsheet for transaction accounting
General structure:
• The Excel file must have 11 separate sheets, each of which will record transactions.
• There must be a Summary Sheet that consolidates data from all 11 sheets and automatically updates when information changes.
Fields (columns) on each sheet:
Date (light gray color) — Date of the transaction.
Income (soft green color) — Amount of money received in the account.
Sent (soft orange color) — Quantity and amount related to the sending.
Quantity (light blue color) — Number of units involved in the transaction.
Total Amount (pale purple color) — Total amount calculated for each transaction.
Fee (light yellow color) — Amount of the fee associated with the transaction.
Received (after fee) (light green color) — Amount received after deducting the fee.
Percentage between Sent and Received (light brown color) — Percentage ratio between the sent and received amounts, calculated using the formula (Received / Sent) * 100.
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 perceivable.
• 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.
-
1 day22 USD
1 day22 USD
Hello, I have extensive experience working with Excel, I know conditional formatting very well.
I am waiting for you in private messages.
-
2 days22 USD
2 days22 USD
Good day, Yevhenii. I am interested in your project and will do everything according to the specifications. I would be very happy if you consider my candidacy for completing your order.
-
1 day22 USD
561 15 0 1 day22 USD
Good day! I will do it today, with quality and according to your wishes! I already have similar experience with new sheets and automation, so I know how to implement the task. Feel free to reach out!
-
1 day33 USD
1134 38 0 1 day33 USD
I can do it
________________________________________________________________________________
-
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.
-
2 days22 USD
412 2 days22 USD
Good afternoon. To implement the ability to add new sheets while preserving all settings and automation, it will be necessary to use macros and a template sheet. We will agree on the color scheme :)
You might be interested in the option of organizing it in Google Sheets (one or several - a summary + sheets for each performer, if the sheets are intended for accounting operations of different employees) — we can discuss optimization taking into account the clarified input data.
-
14 days33 USD
957 19 0 14 days33 USD
Good day!
I have significant experience in developing effective and user-friendly business spreadsheets. My projects are characterized by functionality and automation, which helps streamline workflows.
I will create a spreadsheet with the described tabs and columns, with possible automatic data pulling, dropdown lists, and formulas.
All data from 11 tabs will be automatically pulled into the main one upon any changes.
If necessary, it can be divided into 11 different files, if the managers require it, they will not see each other's tables and the main one. But all data will be pulled into the main spreadsheet.
I will implement a convenient design and practical conditional formatting.
Here is an example of execution, this is a link to a template overview:
https://docs.google.com/document/d/1XUzRCkXTpgBZaWgB9ycw7plCmcjSFur_O7OTAslgrNc
… In the future, I will assist you with your spreadsheet in maintenance and improvement.
Write to me and we will discuss all the nuances of cooperation.
-
3 days22 USD
643 10 1 3 days22 USD
Hello!
I will be happy to help you prepare the table.
I have been involved in international marketing for over 10 years and manage full-fledged teams. I work with countries in the USA, Europe, and Latin America.
I have excellent experience in implementing automated databases in table format.
Additionally, I can offer marketing support during our collaboration.
-
2 days22 USD
2242 35 0 2 days22 USD
Good day, I constantly do similar projects. I will suggest the optimal solution. Feel free to reach out.
-
2 days22 USD
964 17 0 2 days22 USD
Good day!
Please reach out, I will create such a structure, set it up and explain how it works) If anything - you can contact me if you need to expand the functionality.
-
1 day22 USD
2937 73 4 2 1 day22 USD
Good day! I have a lot of experience working with ET, so I will complete the assigned task with high quality! Feel free to reach out, I can start right now!
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 ∙ 4 days 4 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 20 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 20 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 20 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 ∙ 9 days 5 hours back ∙ 14 proposals |
Kyiv