Excel drop list filter jobs

As a business owner, I need a proficient and efficient freelancer who can manage my company's financial data in Excel format. Key responsibilities: - Accurately entering, managing, and updating Income and Expense statements daily. - Ensuring data is correct, up-to-date, and accessible. Ideal skills: - Proficiency with Microsoft Excel - Strong attention to detail - Experience with financial data management Please note, this role requires daily work and a consistent, reliable, and professional approach. Experience in financial data entry is preferred but not mandatory.

I'm looking for a freelancer to copy data tables from an Excel spreadsheet and paste them into a provided location - no formatting or clean-up necessary. Ideal candidate should have: - Proficiency in Excel - Attention to detail - Ability to follow clear instructions - Fast and accurate data entry skills. This is a straightforward task that will require reliability, as the data is an important part of a larger project.

I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver ...

We are a leading Top Forex Brokers Review website that has recently experienced a significant drop in Google ranking following a recent algorithm update. Our platform aims to provide comprehensive and unbiased reviews of forex brokers to assist traders in making informed decisions. We are seeking an experienced SEO expert to conduct a thorough audit of our website and identify the specific issues that have led to the decline in our ranking. Additionally, we require assistance in developing an ongoing SEO strategy to recover our lost rankings and enhance our visibility in search engine results. Responsibilities: Conduct a comprehensive audit of our website to identify technical, on-page, and off-page SEO issues. Analyze our backlink profile and identify any toxic or low-quality l...

I need an expert in Excel to assist me with organizing and managing my customer information. The data will need to be updated on a weekly basis and I require the following functions to be implemented: - Sum and average calculations - Conditional formatting - Data validation rules You should have a strong attention to detail and be able to work independently and efficiently. Good communication skills are also important.

I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs

I'm need of an expert in Excel, particularly with a strength in creating complex calculation systems, for the task of data keeping. Key Tasks: - Understand and implement a data structure for holding financial data - Build a system for complex calculations within the excel sheet Qualities Needed: - Proficiency in Excel - Experience dealing with financial data - Ability to design and incorporate complex formulas for calculations - Analytical thinking The Excel sheet will specifically monitor and report Budget versus Actuals, so experience in handling these aspects are an added advantage. The goal is to have a seamless, reliable system for my financial data.

I'm in need of a skilled professional who can diligently carry out a large volume of data entry involving text, numbers, and images. The data is to be accurately entered into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Accuracy in data entry - Ability to handle large volumes of data - Familiarity with processing text, numeric, and image data The right freelancer should have substantial experience handling this type of project and able to demonstrate precision and attention to detail.

I'm seeking an experienced Brawl Stars coach who can help me elevate my gameplay to the next level. Having played on both Android and iOS platforms, I've developed a decent understanding of the game but I want to push my skills further to become a formidable competitor. **What I'm Looking For:** - **Expertise in Brawl Stars:** Someone who has a track record of high achievement in the game and can provide proof of their skills. - **Coaching Ability:** Not just a great player, but someone who can teach. You should be able to analyze my gameplay and offer actionable advice. - **Focus Areas:** Since I'm looking to generally improve my gameplay, having a broad understanding of key strategies, character usage, and gameplay mechanics is essential. **Expected Outcomes:** - ...

...company details, premium amounts, policy type and number, beneficiary information, registration number, contact numbers, email IDs, premium collected, next expiry and other insurance related parameters. - A fully functional dashboard: Capabilities include report generation, tracking of premium payments, calculation of policy expiry dates, display of policy summary, automated notifications, search/filter options, display of policy status, enabling data exports, provision of visual graphical representations, user login and access control for security purposes. The system should also be equipped with capabilities for client information management, policy tracking, automated alerts and reminders, commission calculation and provide an overview via the dashboard. The ideal candidate ...

As someone who values financial transparency and accuracy, I am seeking an expert to create a dynamic Excel sheet for my daily profit tracking. This project primarily involves: - Building an Excel sheet that efficiently organizes and computes financial data for profit tracking. - Setting up features that update and give an accurate account of profits on a daily basis. Ideal candidates for this project should: - Be proficient in Excel and Financial modeling. - Have strong attention to detail. - Have experience in financial data management and reporting. Your job will be to provide daily updates to the Excel sheet. I am looking for consistency and accuracy in these updates. Through these daily updates, I hope to clearly see how my profits are changing, whic...

...skilled web designer to create an appealing and functional e-commerce website. Key Functionalities: - Shopping Cart: A well-designed and user-friendly shopping cart system that makes it easy for customers to add and manage products. - User Registration: A seamless user registration process that ensures a smooth shopping experience and allows for customer accounts. - Product Search and Filter: A search and filter feature that enables customers to easily find products based on categories, keywords, or other relevant criteria. Other Requirements: - Multilingual Support: The website must be designed to support multiple languages to cater to a diverse customer base effectively. Ideal Skills: - Proficient in e-commerce website design, with a portfolio that showcases previous...

...approaching their designated stop. These notifications should be timely and reliable. - **Multi-Bus Tracking**: The app should allow parents to track not just one, but multiple buses. This is especially helpful for parents with multiple children attending different schools or taking different buses. -** show pickup time and drop of time in the morning and evening on driver account, parent account and admin -** qr code for every passenger so driver can scan ant the app records drop off time and pick up automaticly Ideal Skills: - Proficiency in mobile app development for both iOS and Android platforms. - Prior experience with GPS tracking applications. - Knowledge of integrating real-time tracking systems. - UI/UX design experience to ensure the app is user-friendly and ...

I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.

I am struggling with incorrect results when attempting to subtract two values in a column of clock times in Excel. My data is in a 12-hour clock format, and I signify AM and PM directly within the time cells. I require an expert in Excel to address this issue promptly. To take on this project successfully, you should have: - Proficient Excel skills - Solid understanding of the 12-hour time format and functions in Excel - Ability to troubleshoot and rectify the problem quickly

I'm looking for a skilled professional who can implement an AI into my Wordpress website. This AI will essentially be trained to generate and filter the most trending content from a set of topics, creating blog and video content to be automatically posted on LinkedIn, YouTube, and Facebook. Our website includes essential components such as a company profile section, detailing our identity as an AI startup. Our AI system is tasked with creating and publishing social media content covering a wide array of topics, including news, AI, Finance, HR, Cybersecurity, politics, and investing. Additionally, the AI undergoes training to identify the most trending news and produce approximately three blog posts daily. Among these posts, one is selected for video production, with the AI ...

Hi! Your job 1. Go to a website (url in brief) every day to every other day 2. On that website click a link to open another website. This website is NOT live/active yet. 3. Open the list of names we have (about 30 names) 4. If one of the names from our list is listed on the website then send an email to us (not to the person) 5. Allow us to add names to the list, change where the email is sent, change body of email and when the scraping starts/stops as well as frequency (daily or every other day).

...build an email verification platform like “MillionVerifier '’ and “Neverbounce” "listclean". 1. **Validate Email Addresses:** The platform should be able to cross check every submitted email address and validate them to confirm legitimacy. 2. **Spam Check:** There must be a provision to check and detect spam emails and effectively filter them out. 3. **Remove Invalid Emails:** The system should have the ability to remove invalid email addresses from any uploaded list or one-by-one input. 4. Hard Bounce. 6. Invalid Syntax 7. Toxic Domain 8. Abuse Email 9: API 10: Including All features site Accuracy is extremely vital to this project and the system is expected to give a high accuracy rate of 95-99%. The ideal freelancer for ...

I have some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cle...some duplicate data that need to be copied to different sheets. - The project entails copying the duplicate information into different sheets. - The reasoning behind organizing the data into separate sheets is so that I can perform statistical analysis on each set distinctly. This will enable me to have cleaner and clearer results, helping in decision making. Ideal Skills: - Proficient in Excel or any other data manipulation software - Experience with data entry a...

Financial Statements based on Excel template and Data - you product financial Statement with filled out excel based on data given We need an expert Freelancer to enter basic financials data to attached financial Projection in Excel and produce a profit loss statement based on this Excel attached and the data of company projected Revenues and expenses Simple if you have done it before You will send us back the filled out excel with sheet tabs including the Financial Planning Tab and Profit Loss. Budget is $200 - $300 +/- Very Simple just summarize and detail the data correctly any questions or data you need for this ( not given in attachments in zip ) we will give you You need to put all Hungarian Forint Currency Do the conversion from Euro as shown i...

I'm seeking a proficient developer to build an extensive real estate app compatible with iOS, Android, and Web-based platforms. Key Features: - Property Search: advanced filter mechanisms for property searches are essential. - Property Listing: A clear, easy-to-configure property listing feature is required. - Favorites/Save Listings: Users should be able to save favorite listings for future reference. - Live Call: An integrated feature for live-call discussions with property owners or agents. Additional Functionalities: - User Registration and Login: A secure user registration and login functionality is pivotal. - Location-Based Search: The app should have the capacity for location-based property searches. Ideal Candidate: You should have experience in developing real...

I am looking for an experienced freelancer who will assist with copying data from my Microsoft Word and Excel documents. The copied data will then be pasted into Google Sheets. Key tasks include: - Copying data accurately from existing Word and Excel documents - Pasting the data into a new Google Sheets document - Organizing the data in a clear, readable format Ideal skills and experience: - Proficiency with Excel and Google Sheets - Demonstrated experience in data entry - High level of accuracy and attention to detail.

As someone who is experiencing theme customization errors with my Shopify site, I am in need of an expert who can aid in the aspect of layout and style adjustments as well as add new site features. Specifically, I require assistance with: - Rearranging sections on my homepage. - Creating sophisticated drop-down menus for Designers. - Developing a designated Designer page. - Enabling customers to search by Designers. - Linking products to the newly set up drop-down menu. Someone with vast experience in Shopify, a good eye for UX/UI design, and coding skills will be the ideal candidate for this project. Mastery of HTML, CSS, Liquid and JavaScript would be beneficial. An understanding of the Shopify platform is crucial. Time efficiency is also essential as I need these issues...

I'm looking for a capable developer to build an application focused on tracking prices and providing price drop alerts for Indian e-commerce platforms. The app, which will be available on Android, needs to provide efficient product search capability and I would also like to include user account login functionality and push notifications. Key skills required for this project include Android app development, experience with price tracking algorithms, and a knowledge of Indian e-commerce platforms.

I have Python code on github and I just need to add a filter to it, something very simple. the code is ready just add a filter

Seeking a freelancer with expertise in Excel and PowerPoint for a project involving more than 5 Excel files. The task at hand is to assist with presentation design. Skills and Experience required: - Proficiency in Excel and PowerPoint - Strong design skills - Experience with handling multiple Excel files - Attention to detail and ability to create visually appealing presentations

I need a professional with a significant background in data management, who can assist me in streaming entire worksheets live from my desktop Excel file to my Google Sheets. The core requirement is to: - Stream the entirety of my existing Excel worksheet data into Google Sheets instantaneously and update it in real-time. The ideal freelancer should: - Be experienced in data integration across various platforms. - Possess comprehensive expertise in both Excel and Google Sheets. - Have a past track record of successfully completed data streaming related projects. - Be able to implement a solution for real-time data update.

I'm seeking a versatile individual to assist in constructing the digital framework for a groundbreaking think tank. The ideal candidate will excel in the following areas: - Website Development: You will be responsible for constructing a user-friendly platform that encompasses discussion forums, document sharing, and other essential features. - Forum Features: You'll need to design and implement efficient user profiles, thread categorization, and effective comment moderation. - Document Sharing: The platform should support the sharing and collaboration of research papers and reports. Experience or skills in the following areas are highly valuable: - Intelligence analysis and investigative journalism - Data analytics and project management - Mental health and spiritual m...

I need a searchable website that tracks product prices from Indian e-commerce platforms, providing alerts when those prices drop. Here's what the ideal candidate should do: - Implement a feature to search for products - Integrate a system to track current prices - Create an alerts system for price drops SKILLS & EXPERIENCE: A successful freelancer should have prior experience in developing price tracking tools and working with Indian e-commerce APIs. Familiarity with popular Indian e-commerce platforms and their price structure is a must. Additionally, knowledge of how to integrate a compelling alert system is crucial. This candidate must demonstrate attention to detail and possess strong data management capabilities.

...security to combat hacking attempts. I am faced with a serious breach that involves invasion and violation of my personal and financial information as well as photos, videos, and IP addresses. The specifications necessary for this task include: - Antivirus Software: Implementation of effective antivirus software to detect and prevent intrusion. - Firewalls: Configuration of a strong firewall to filter incoming data and block threats. - VPN Service: Setting up a secure VPN to protect my IP address and data transmission. I'm looking for someone experienced in digital security, specifically in antivirus software, firewalls, and VPNs. The nature of this task demands fast response and attention to detail. Previous experience in dealing with hacking issues will be advantageou...

I am looking for a detail-oriented professional who can assist in copying and pasting data for my business, BD Company. Required tasks: - Copy data provided in Excel sheets. Ideal Skills: - Proficient in Microsoft Excel - High attention to detail - Strong data entry skills Apply only BD interested person.

...certain columns of the rows that meet a specific static condition. The main functionalities of this script include: - Iterating through all the rows of a given table. - Checking each row to see if it meets a certain static condition. - If the condition is met, updating certain columns within that row. This script should be designed to handle the following requirements: - The script will be used to filter and update specific rows based on a static condition. This condition will remain unchanged. - The script needs to efficiently loop through the entire table and update only the rows that meet the specified condition. Ideal skills and experience for this job: - Proficient in PostgreSQL and SQL scripting. - Experience in writing complex queries and scripts for data manipulation. ...

Looking for a skilled developer to build a minimalist job candidate application platform. Despite its simplicity, it needs to be versatile and user-friendly. This platform will primarily focus on job search functionality, so a keen understanding of efficient and effective search structures is important. Key Project Components:...Proven background in building responsive and attractive user interfaces. - Strong understanding of job search functionalities and algorithms. Please note, the client has chosen not to include additional features such as User Registration, Resume Upload, or Job Bookmarks. So, your focus should be solely on creating an effective job search platform. The client has also not specified a salary range filter. However, we may discuss this further if the project p...

...Redirect to WhatsApp from design details page for seamless sales and support experience. Website Features: 1. User Authentication(designers and customers): Implement user registration and login functionality to enable personalized experiences and order tracking. 2. Designer Dashboard: Create a dashboard for designers to upload their designs, manage inventory, and track orders. 3. Search and Filter: Enable users to search for designs based on categories such as type of jewelry, designer, or style, and apply filters for metal type and stone preference. 4. Design Detail Pages: Develop detailed pages for each design, showcasing images, descriptions, and customization options. 5. Order Management: Develop an order management system to track orders from placement to delivery, inc...

I am looking for a developer who can design a data uploader for my website. The primary purpose of this tool is to allow me to upload different types of files such as Excel spreadsheets, CSV files and Text files into my website's backend. Key Requirements: - Support for multiple file types: The uploader should be able to accept a variety of file formats, including Excel spreadsheets, CSV files, and Text files. - Basic Data Validation: Before the data is uploaded, I need this tool to perform basic data validation. This would involve checking for field completeness to ensure that all necessary fields are populated before the upload is allowed. Ideal Skills and Experience: - Proficiency in web development: The ideal candidate should have a strong background in web develo...

...filters, columns, Actions, Editor..) and a page containing the grid and others will be dynamically rendered according to its definition class.. Other details to be discussed. This app should feature: - Drag and Drop Functionality: You should be adept at creating user-friendly drag-and-drop interfaces. - Form Builder: A key element of this app is a customizable form builder, aligned with user needs and integrations. In terms of aesthetics and functionality, an interactive design approach is sought after. Skills and Experience: - Proficiency in Angular, and understanding of drag-and-drop functionality - Demonstrable experience creating form builders - Portfolio of responsive, interactive designs - Previous work creating applications for small businesses preferred. - ...

I'm looking for an google sheets / excel guru who can construct an advanced drop-down lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel environment will b...

I would like to hire someone to assist me with setting up email accounts with forwarding to gmail and or look at possible solutions for setting up emails rather than from the hosting account, but perhaps a third party provider, one which will not have any issue with emails not coming in due to spam filter on current hosting, and where which all emails from various website domains can be viewed from the one place or folder, without having to check each inbox individually. You will need to have extensive experience with email accounts setup and forwarding and find the right long term solution for this.

I am currently struggling with a specific issue in my App Sheet. The drop-down functionality isn't functioning as expected - it's not populating the correct values. I need assistance in making it work properly. The ideal candidate for this job would be an expert in App Sheet, with experience working with drop-down functionalities and troubleshooting them. Knowledge in data entry forms and calculations and formulas is a plus. To summarise, your job would be to: - Troubleshoot and fix the drop-down functionality in my App Sheet - Ensure correct values are populating in the drop-down list - Optimize for future efficiency and user experience. Please, only apply if you can demonstrate relevant past work in this area. We will collaborate closely...

I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.

Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.

I am looking for a professional with strong data entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital document data will...

I'm looking for an experienced expert in Google Analytics 4 and Google Tag Manager to set up an enhanced tracking and reporting system on my SAAS and wordpress website. Key Requirements: - Tracking User Behavior: This includes monitoring visitor interactions, time spent on pages, the number of pages visited, drop-off points, etc. - Conversion Goals: Tracking different types of conversion goals – form submissions, button clicks, page views, registrations, and payment confirmations are crucial for this project. - Event Tracking: I want to track specific actions/events on the site such as registrations and user journey. Your role would involve: - Properly configuring Google Analytics 4 and Google Tag Manager for the website - Setting up the tracking for the specified us...

I'm in need of an experienced website developer to build an e-commerce website for my business. The site should integrate paytm as the primary payment method and have the following essential features: - Product search and filters: The website should allow customers to easily find products through a search bar and filter options. - Shopping cart: A functional shopping cart that allows users to add items, view their cart and proceed to checkout. - Customer reviews and ratings: A feature that enables customers to leave and read reviews, as well as rate products. I'm looking for a developer with a strong background in e-commerce website development, specifically with experience in integrating paytm and implementing the mentioned features. A good understanding of user experie...

I have a meticulously planned wireframe and content for my Shopify website. I'm looking for a skilled professional who can bring this vision to life. Key Requirements: - Implementing product search and filter functionality to ensure a smooth customer experience. - Integrating a payment gateway to facilitate transactions. - Implementing a feature to enlarge product images and enable vertical scroll. Key Information: - I plan to have less than 100 products on the site. - The main goal is to sell products online. Ideal Skills and Experience: - Proficiency in Shopify website development. - Experience in creating and integrating custom features. - Prior work on e-commerce websites with a focus on user experience. - Strong attention to detail to ensure the final product is an acc...

In Your proposal please mention the website names where you will be posting our article, we prefer home decor, interior design websites and must have good reputed ranking, without mention of websites , pls dont apply. I'm looking for an experienced SEO expert who can help me improve my website's search engine rankings. The primary task will be to obtain backlinks from websites with a domain authority of 70 and above. The goal is to increase the visibility of my landing pages among the general public. As such, the backlinks need to be strategically placed and relevant to the context of the content they are linking to. The ideal candidate should have: - Proven experience in SEO and link building - Familiarity with high domain authority websites - An understanding of how searc...

I need someone with specialized skills in password recovery to restore a forgotten password for an Microsoft Excel worksheet. This task requires a professional password hacker. I require one spreadsheet opened and password recovered and removed. Skills and Experience required: • Proficiency in programming languages, particularly those relevant to password recovery. • Expertise in methods of password recovery for Microsoft Excel worksheet xlsx files. • Strong ethics - the information on this spreadsheet must stay confidential. • Can deliver results within 7 days. • Will pay on successful confirmed completion only.

I require a proficient freelancer to design a distinctive Excel file that will be used for web form completion. Once the Excel file is uploaded, the system should automatically read and fill the corresponding fields. These may be a composition of dropdowns, text or checkboxes with comprehensive validation, such as numbers-only constraints, email format requirements, date format validation, dropdown list checks, value ranges among others. Ideal Skills: -Qualified in Excel -Understanding of data validation Experience: -Web development -Scripting in Excel -Web form design -Experience designing similar projects Please note that while the specific dropdown fields were not detailed, anticipate flexibility and adaptability in the code to conform to possible ...

...an intuitive application. This app is intended to utilize LangChain and OpenAI's language model in categorizing PDF files into different groups; namely invoices, HR-contracts, or MOUs and then under go different ways for each document catagory: A. in case of invoice: - extract the data inside invoice (invoice number, date, buyer name, total amount sold, and total due amount) and save them in an Excel file. B. In case of HR-contract: - simply move the file from the existing location to the HR-contract folder. C. In case of MOU: - simply move the MOU from the existing location to the MOU folder. Details: - Your responsibility is to build a desktop application that processes and accurately categorizes data from complete PDF files. - You are required to utilize LangChain for...

I require a proficient Excel expert with strong skills in data analysis and organization. The primary tasks you will handle include: - Analyzing business-related data - Organizing the analyzed data in an easy-to-understand format The purpose of these tasks is to help streamline business reporting processes. You must be adept at dissecting large volumes of data and summarizing key points to help inform business decisions. The final deliverable should be a standard Excel file that details the organized and analysed data. Relevant skills needed include data analysis, Excel proficiency, and a keen understanding of business data interpretation.