Excel advanced filter copy to another sheet jobs

I have a legal document that needs to be translated from its original language to another. The document is within the range of 500-1000 words. Key Responsibilities: - Translate a legal document from a source language to target language - Ensure the translated content maintains the original meaning, format, and tone Ideal Skills: - Proficient in the source and target languages - Previous experience in translating legal documents - Attention to detail to ensure accuracy in translation Please ensure to provide your experience and background in legal translation when you bid.

I have a project that requires extracting data from approximately 10-50 PDFs and entering it into both Microsoft Excel and Google Sheets. Key requirements: - Extracting data accurately from PDFs - Organizing and entering the data into Excel and Google Sheets The ideal freelancer for this project would have: - Proficiency in data entry and working with spreadsheets - Attention to detail and accuracy in extracting data - Familiarity with Microsoft Excel and Google Sheets Your work will be crucial in helping me organize and analyze the data effectively. I'm looking for someone who can commit to delivering high-quality, accurate work in a timely manner.

I'm in need of a freelancer to enhance the User Interface (UI), User Experience (UX) and performance of my MasterStudy LMS. This is a straightforward job, so please don't bid over $200. UI/UX Enhancements: - Improved navigation: Make the LMS easier to navigate. Users should be able to find what they need quickly. - Refreshed color scheme: Enhance the aesthetic appeal of the LMS with a modern and engaging color scheme. - Simplified user interface: Streamline the user interface to make it more intuitive and user-friendly. Course Management Features Enhancements: - Advanced analytics: Integrate more advanced analytics features. This will help me track the performance of my courses and students more effectively. - Interactive assignments: A...

...materials. Currently, we're managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with Excel and the a...

Hi Taoussi B., You done one video for me. possible another similar?

...Telugu language to understand the speaker spoken lines The product is social network app It is promotional podcast video for promotion of the app and how doesn’t it work. Video needs enough animation while speaker explain about app and how does it works Il also provide podcast video footage along with app UI screen recordings I’m expecting the output to be like this I'm in need of a proficient video editor who can enhance my raw marketing and advertising footage with advanced editing techniques like special effects, motion graphics, and animation. Key Responsibilities: - Perform advanced video editing tailored towards marketing and advertising purposes - Integrate special effects and motion graphics to make the video

I need to create a small HTML file to print offers and discounts, just like the attached one. Title, Price, Product name and logo below. It is to print on a horizontal A4 sheet. I need this in html format.

I'm looking for a Virtual Assistant to grab leads, I’ll send material on how. It’s pretty simple. We'll specifically be targeting those who work in the nightlife industry and going down the research rabbit hole on Instagram. Ultimately I'm trying to sell high end social media services and night life people have access to a wealthy Rolodex so my goal is to gain a bunch of affiliates from this. Key Responsibilities: - Find mini partners (affiliates) in nightlife: vip hosts, promoters, club managers club partner companies, etc. - Inputing the above prospects info (names and emails) on a google excel sheet Skills and Experience: - Fast - Critical Thinker - Proficiency in using Instagram for business research - Experience i...

...skilled writer to create engaging blog articles tailored to working professionals between the ages of 30 and 50. The main purpose of these articles is to provide information on industry-related topics. - Excellent writing skills and experience in professional blogging are necessary. - You should be able to perform thorough research on industry-related topics and generate ideas for new content. - Experience producing copy for a working professional audience is necessary. - You should be well-versed in creating informative and engaging articles. - A deep understanding of the needs and interests of working professionals is needed. The goal here is to provide high-quality content that will resonate with this specific audience and shed light on va...

I'm seeking a creative and experienced copywriter that specializes i...creative and experienced copywriter that specializes in content for the health and wellness industry. The ideal candidate will craft engaging and informative copy that would appeal primarily to health professionals. Key Requirements: -The writing style should be clear, persuasive and informative -Relevant experience in the health and wellness industry is preferred -Understanding of the needs and interests of health professionals crucial -Ability to research and incorporate the latest industry trends into the content -Proven track record in producing quality copywriting that engage professional health audience. I'm looking forward to view your portfolio and discuss how your skill...

I'm in need of an advanced level M3 ERP trainer with specific experience in the retail industry. Your expertise and knowledge will be pivotal in aiding the efficient use of our ERP system. - Key Responsibilities - Training users on the functions of M3 ERP - Providing advanced learning techniques for M3 ERP retail applications - Helping in troubleshooting issues and solving complex M3 ERP queries Exposure to a retail environment and advanced understanding of M3 ERP will be key to provide the level of training required. The ability to adapt training to different learners and level of understanding will also be beneficial in this role.

...lookout for an adept freelance copywriter who is proficient in both German and English. Our need primarily concerns: - Crafting content for brochures and website edits - Ideally, the copy will maintain a balanced approach, merging technical specificity with more general appeal to convey our B2B software-as-a-service (SaaS) offerings to potential customers. Your ability to deliver clear, persuasive, and engaging writing optimized for a B2B audience is critical for this project. In addition, you may occasionally be tasked with creating social posts, reports, blog posts and providing translations from English to German, making bilingual proficiency a must. Our German marketing team largely focuses on our SaaS product (specifically, our learning manag...

...are seeking a skilled developer to set up and program a framework using Apache Kafka for distributed messaging. The project aims to establish an efficient and scalable messaging system that can handle high-volume message processing and filtering. Project Overview: The developer will be responsible for setting up Apache Kafka on a Windows environment and developing a master script and worker scripts to facilitate distributed messaging. The key requirement is to implement a mechanism for bulk-reviewing messages in the queues every 10 minutes to filter out unnecessary messages and optimize system performance. Responsibilities: Apache Kafka Setup: Install and configure Apache Kafka on a Windows machine. Set up the necessary Kafka topics, partition...

... The main goal is to create a functional and visually appealing, SEO friendly escort model directory website with 10-20 pages. Key responsibilities include: - Developing a custom WordPress theme with Unyson editor - Must be SEO friendly - Implementing advanced search filters for user navigation - Creating user profiles for escort models - Incorporating an online booking system (if possible) Ideal skills/experience: - Proficiency in WordPress development and custom theme creation - Strong understanding of coding - Experience with Unyson editor - Developing directory or listing websites - Knowledge of implementing advanced search filters - Any experience with online booking systems is a plus Please bid with relevant samples of your work and an outline of how you pl...

I have an extensive PDF document that needs to be typed into a Word document. I'm looking for a professional typist who can accurately type the content from the PDF into a Word document. The document is quite long, so attention to detail and commitment to accuracy are crucial. Ideal skills and experience: - Proficient in typing and data entry - Strong attention to detail - Previous experience with similar projects is a plus - Familiarity with Microsoft Word

I'm in need of a precise and efficient data entry operator to assist in entering numeric data into Microsoft Excel. The data will be provided in printed format. Key Responsibilities: - Accurately inputting numeric data into Microsoft Excel. - Ensuring data quality and consistency. - Meeting delivery deadlines. Ideal Skills and Experience: - Proficient in data entry. - Experience working with numeric data. - Advanced knowledge of Microsoft Excel. - Excellent attention to detail. - Strong time management and organizational skills. The successful candidate will be able to demonstrate a proven track record in data entry and will ensure the highest levels of accuracy and efficiency.

I'm urgently seeking a skilled data analyst with excellent writing abilities. The job entails: - **Interpreting Statistical Results:** You'll be required to take the results from statistical analysis carried out using SAS models and Excel, and interpret them into a clear, concise and comprehensive written report. The final document should be in Word format. The ideal candidate should have a strong data analysis background and experience with SAS models. Additionally, exceptional writing skills and the ability to distill complex statistical information into an easily understandable format will be pivotal for this project.

I am in immediate need of a web technician specialist p...an existing website in Spanish - with no design or content changes - and migrating it to a new hosting provider that offers better reliability. Key Tasks: - Copy and duplicate an existing website in Spanish. - Migrate the duplicated website to a new hosting provider. - Ensure no content or design changes during the migration process. Ideal Skills and Experience: - Advanced proficiency in WordPress and Elementor. - A proven track record in website migration tasks. - Strong familiarity with hosting providers and their setups. - Excellent attention to detail to ensure that no design or content changes occur during the migration. - The ability to work quickly and efficiently, as the tas...

...Requirements: - Measurement customization: The ability to create customizable patterns based on specific body measurements is crucial. - Design templates: Familiarity with creating and implementing design templates for Dirndls, Dirndl blouses, and Dirndl jackets is a must. - Pattern grading: The chosen freelancer will need to be able to adapt patterns for different sizes, ensuring consistency and accuracy in the design. Compatibility: While it's not mandatory, any experience with integrating Schnittdirektrice with other CAD software would be a bonus. Interface Complexity: I'm looking for a mid-level complexity in user interface. This may allow for a more efficient creation process without overwhelming the user with too many advanced features. I...

I need a python software that can find emails from LinkedIn Sales Navigator URLs. The emails need to be in Excel format. What I Need in Excel: - Name of the person - Email - Location - Designation Procedure: - I shall enter sales navigator ulr where multiple leads in pagination format displayes. - Software will pick each person url and find out his email (personal/professional) - Add that record along with above fields in excel sheet. Make sure software must not stuck, and i shall clear the payment after testing couple of days. Ideal Skills: - Proficiency in Python. - Experience in web scraping, particularly with LinkedIn URLs. - Familiarity with data manipulation in Excel files. This project is ideal for someone with a strong background in Py...

...marketing service, targeting small and large enterprises globally. Key Responsibilities: - Conducting outbound sales efforts to introduce our marketing service and convert leads into clients. - Strategizing and delivering effective sales pitches that highlight the unique selling points and benefits of our service, such as improved ROI, increased brand visibility, and advanced analytics and reporting capabilities. Ideal Skills and Experience: - Proven track record in SaaS sales, particularly with start up and large enterprises. - Strong understanding of digital marketing, SaaS business models, and data analytics. - Exceptional communication and negotiation skills. - Ability to work independently, manage your own sales pipeline, and meet targets within a specified ...

I'm seeking a professional to assist with integrating my python scraping script output to my personal WordPress site in real-time. Key Requirements: - The integration should be real-time and without the need for page refresh - The current output of the python script is a CSV file, but can be Json or another Ideal Freelancer: - Proficient in Python and WordPress - Experience with real-time data integration - Familiarity with data formats (CSV, JSON, etc.) - Excellent communication skills to deliver a seamless solution Looking forward to working together.

Job Post Title: "Expert Statistician Needed for Advanced Probability and Statistical Analysis Project" Job Description: We are seeking a highly skilled statistician to assist with a complex statistical analysis project. The project involves a detailed examination of discrete random variables, probability density functions, exponential processes, normal distribution analysis, and sensitivity and specificity calculations. The ideal candidate will help in solving intricate problems related to electronic device lifetimes, network flow sizes, and evaluation of lie detector test effectiveness using statistical models. Responsibilities: Analyze and compute probabilities related to medium access control protocols and network flow sizes. Develop and validate ...

I need an expert in Shopify to sort out my Collection Page. The main issues are a lack of clarity in product display, filter malfunction, and pagination problems. Key tasks: - Ensure products are correctly displayed - Fix filter functionality - Get pagination working properly Your expertise in Shopify and its Collection Page is crucial to make shopping on my website a seamless experience. Please highlight your experience with similar projects when bidding.

PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTELY. We need work to be done in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we will award it to another developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3)...

I need a python software that can find emails from LinkedIn Sales Navigator URLs. The emails need to be in Excel format. What I Need in Excel: - Name of the person - Email - Location - Designation Procedure: - I shall enter sales navigator ulr where multiple leads in pagination format displayes. - Software will pick each person url and find out his email (personal/professional) - Add that record along with above fields in excel sheet. Make sure software must not stuck, and i shall clear the payment after testing couple of days. Ideal Skills: - Proficiency in Python. - Experience in web scraping, particularly with LinkedIn URLs. - Familiarity with data manipulation in Excel files. This project is ideal for someone with a strong background in Py...

Hi Muhammad, I have another animation if you're able to do it?

I am in need of a data analyst who can dissect reports and extract n...accurately churn out meaningful information in required format. Your responsibilities include: * Analyzing various reports. * Precisely capturing key information based on pre-decided format. This project requires someone with Eye for Details, Working knowledge of MSOffice especially Ms Excel. Good English communication acumen, to understand and interpret data and derive meaningful information. Understands general market & business terminologies, Able to invest atleast 4-5 hours daily. Ideal time between 2pm to 7pm IST. Proficiency in interpreting data and a keen eye for details are highly recommended for this role. This is 100% remote opportunity, Working Laptop, Phone, powerful inte...

Good morning, The mission is to finalize the app 'Z-anatomy' () (), to set up a functional webviewer linked to a database from it. This is the first open source 3D atlas of gross anatomy and I'd like to be able to update its content autonomously. The license is CC-BY-SA and the authorship will go to 'BodyParts3D', 'Lluis Vinent' and 'Z-Anatomy'. The tools need to be set up for and be owned by the client. Profile: >3 years of experience in tailored projects in Unity Experience in the set up and use of databases Good organization and communication skills Necessary missions (estimated 100 euros): Share the project on Unity Hub Create a database containing a .csv file (...

Create PowerPoint presentations based on a Word document. Simply copy and paste the content from the Word document into the PowerPoint slides, and that’s it. See the link for the files

I need assistance with performing formulas, calculations and descriptive analysis in Ms Excel. I am specifically focused on analyzing data using measures of central tendency - mean, median and mode. - **Tasks** - Insert and calculate formulas regarding the mean, median, and mode in the data. - Conduct descriptive analysis on the dataset. Ideal freelancers for this project should have strong analytical skills and extensive experience with Excel's formula and calculation functionalities as well as knowledge of statistical analysis. An understanding of central tendency measures (mean, median, mode) is crucial.

Our organization is looking for an expert in Kubernetes to manage and optimize our existing setup. The project requires someone with a deep understanding of Kubernetes and the ability to improve our current setup in terms of performance, scalability, and security. Key Responsibilities: - Reviewing and optimizing our existing Kubernetes cluster. - Ensuring the setup is scalable and can meet future growth demands. - Implementing necessary security measures and best practices in line with industry standards. - Enhancing performance and efficiency where possible. The ideal candidate should have: - Significant experience in setting up and managing Kubernetes clusters. - A proven track record in optimizing resource usage, scaling infrastructure, and ensuring high security standar...

I have a copy of a logo that I made myself in JPG format, and I need a professional to make a high-quality logo from it. Key Requirements: - Create a professional logo in Black / White / Red / Silver color scheme , based on my existing design - Retain the essence of the design, but improve it to a high-quality, professional standard - Deliver the logo in a vector file format Ideal Skills and Experience: - Experience in logo design - Proficiency in using graphic design software - Ability to turn a low-quality image into a high-quality vector file - Understanding of branding and design principles

Seeking a proficient individual who is knowledgeable in Excel for data entry and calculation formula tasks. The project involves: - Manual data entry - Creating complex formulas - Maintaining a spreadsheet with 10-50 columns and rows Ideal skills and qualifications: - A high degree of precision and accuracy in data entry - Strong knowledge of, and experience with, Excel and its formulas. I would like my 24 month forecast converted to an excel spreadsheet so i can adjust inputs and project further.

...report on a simple set of wage data from the past five years and create ability to select which data sets to compare. Your task will be to: - Determine the average salaries over the course of these years. - Identify notable trends in wage changes over the specified time period. - Make in-depth comparisons between the various organisations in terms of wage dispersion. Ideal candidates will have significant experience working with large datasets, particularly those concerning wages and salaries. Proficiency with Excel or a similar tool is essential. Strong attention to detail is also a must as you will need to interpret complex wage data. Furthermore, previous exposure to HR analysis would be a plus, as it adds context to the data....

...talented web developer to create a dynamic and engaging event listings website for HollyBloom, a platform designed to connect/promote holistic practitioners offering group events, group workshops, group retreats, group sessions and group activities in London and across the UK. The website should be user-friendly and designed to effectively showcase a variety of group holistic events. We expect to test your work during the contest winner selection phase. The deliverables in the handover include a fully functioning website with all requirements. You may use and adapt themes, but direct copies are not permitted. Key Features Needed: 0. Menu: Home, About Us, Contact Us, Sign up your events/Sign in to manage events (Practitioners page) 1. View Events: A c...

I'm looking for an experienced Google AdWords specialist to help me increase downloads for my application. The target audience for the campaign are young adults aged 18-25. The campaign will predominantly focus on Google Search, Google Display Network, and YouTube. Key Responsibilities: - Strategizing and executing a Google AdWords campaign aimed at increasing app downloads - Developing compelling ad creatives and copy targeted at young adults aged 18-25 - Focusing on Google Search, Google Display Network, and YouTube as the primary platforms for the campaign - Regularly monitoring, analyzing, and optimizing the campaign to maximize downloads - Providing weekly/monthly reports on campaign performance and suggesting improvements Ideal Skills and Experience: - Pro...

...printed on quality scroll paper and goes to every person that enters. I have attached an example of previous years certificate. Here are some points to consider when designing: - Must include a silhouette of a good beard - Style and background needs to look like it's printed on an olden days heritage paper - The fonts/text needs to be similar style to our previous years and must be clear and easy to read, can change the text slightly if needed. - Can be either landscape or portrait layout The certificate must include the following details from the attached PDF: - Include IN RECOGNITION OF YOUR COMMITMENT TO EXCELLENT FACIAL HAIR - Include 'Ballarat Beard and Stache Logo' and change 23 to 24 in the Logo - Change...

... - **Nature Photography**: Capturing the beauty and essence of nature is another key aspect of this project. Ultimately, the photos produced from this shoot are intended for a mix of uses: - **Professional Portfolios**: The portraits will be needed for my professional portfolio. - **Promotional Material**: The images will also be used in promotional materials. - **Social Media and Personal Use**: Some of the images will be posted on social media accounts and for personal enjoyment as well. Ideal candidates for this project should have a strong portfolio that demonstrates proficiency in portrait, event, and nature photography. Previous experience in promotional work would be a significant advantage. The ability to capture diverse subject matter and produce high-quality,...

I'm looking for someone proficient in Python to convert a PDF file into a JSON format. 4 PDF and 2 excel. Ideal skills and expertise to complete this project include: - Proficiency in Python programming - Experience with PDF parsing - Knowledge of JSON formatting and structuring The project involves extracting and transforming data from a PDF file into a structured JSON format. If you're confident in your Python abilities and have experience working with PDFs and JSON, I'd love to hear from you.

I am seeking a professional and capable freelancer to create a home automation system using Arduino technology. The system should incorporate some form of MIDI control for traktor Dj software - **Expertise Required** - Strong knowledge of programming Arduino. - Prior experience in home automation design and implementation. - Proficiency in achieving interoperability between different smart home systems. - Familiarity with MIDI controls. - **Key Features** - The use of knobs, faders, and buttons on the MIDI controller to enable intuitive interaction with different systems. - Lighting control: an easy-to-use and versatile system to control various lighting fixtures around the house. Please provide examples of similar projects you have completed pr...

I require a skilled and experienced professional to assist with uploading products onto my Magento2 website. Key Responsibilities: - You will be provided with a spreadsheet containing URLs for each product. Your task will be to accurately copy these products onto our website. - This will include setting up product variants, such as sizes. On average, each product will have 1-3 variants. Additional Details: - While the products are being copied, I will need you to ensure that the images are optimized for web use. This means that they should be compressed to ensure fast loading times on the website. Skills and Requirements: - Proficiency with Magento2 is a must. Previous experience with similar product uploading tasks would be highly advantageous. - Yo...

As a business owner, I'm looking to leverage meta ads and pay-per-click (PPC) campaigns to generate leads from a specific target audience. Key Points: - My primary goal is to generate high-quality leads for my business. - Target Audience: Professionals aged 25-54. - Platforms: I'm looking to target Google Ads, Facebook Ads, and LinkedIn Ads. Your Role: - Create compelling meta ads and PPC campaigns that resonate with professionals in the specified age group. - Employ advanced targeting techniques on Google Ads, Facebook Ads, and LinkedIn Ads to maximize lead generation. - Monitor and optimize the campaigns regularly to ensure a high ROI on ad spend. Ideal Skills: - Proven experience in managing successful lead generation campai...

...comprehensive product and brand descriptions with an emphasis on particular values and ethos. Key aspects of this project include: * Crafting unique, persuasive copy that accentuates the high quality and unique aspects of products and brands. * Ensuring an engaging user experience using our brand voice and messaging. * Incorporating our key messages effectively into the content. * Appropriate levels of market research will be required to inform and support copywriting. Ideal skills for this role include: * Proven experience in copywriting * An understanding of how to portray product and brand quality persuasively * Capability to write engaging, persuasive content following a branding brief and guidelines. * Knowledge of FMCG and/or nutriti...

...entry analyst with the ability to create comprehensive data visualizations on Excel. The successful candidate will be tasked with: - Creating a variety of visualizations including charts, graphs, and dashboards from our data sets. - Visualizing key data elements like sales data, customer demographics, website traffic, and financial performance. - Updating the visualizations on a weekly basis to maintain relevance and accuracy. Ideal candidates should have a strong background in data entry and analysis, as well as exceptional proficiency in Excel and data visualization tools. Skills: - Data entry and analysis - Proficiency in Excel - Experience with data visualization tools Additional Skills: - Good understanding of charts, graphs, and dashboards - ...

'm looking for an expert developer to build a copy trade and front running bot that works on Solana. The bot needs to copy trades from a wallet that is using a custom program to buy/sell tokens. In addition to copying trades, the bot will also have to buy and sell before the target wallet. So the bot should use Gulf Stream to search on pending txs. I'm looking for an experienced programmer who has already created something similar. THIS IS IMPORTANT: If you have experience in developing such bots, when you contact me please send proof of your work (videos, transaction records) and your pricing for a project like this. See link for more info:

I'm in search of a seasoned SEO specialist with a specific strength in link building. My target audience is global and I operate in a highly competitive industry. Key Requirements: 1. Proven Experience: I need someone who can demonstrate a successful track record in the highly competitive SEO landscape. 2. Advanced Link Building: Efficiently building high-quality links from reputable sources is crucial. 3. Global Perspective: Understanding the dynamics of reaching a diverse international audience through SEO is key. Skills Needed: - Deep knowledge and experience in link building - Strong understanding of global SEO practices - Experience with handling highly competitive industries - Proven track record of successful SEO campaigns - Excellent communication and repor...

...tools like Appium/Expresso is good to have. Design and develop advanced applications for the Android platform in B2C domain. In depth understanding of Android recommended design principles, interface guidelines and coding best practices. Experience with performance and memory tuning of complex apps. Experience with Agile development methodology (preferably scrum), continuous integration and tools (GIT, JIRA etc.) used to achieve the same. Take full ownership of the solution and be responsible for translating functional requirements into a product solution or offering. Ability to work with multiple internal and external stakeholders in different geography and influence the thought process. Experience of working in Testing tools like Appium/Expresso is good ...

I need to create an Excel dashboard to visualize our inventory data. It's not a complex task and should take around 20 to 30 minutes. What I need: - Display of inventory data on the dashboard using charts and tables - The table should contain: Ideal skills for this project: - Proficiency in Excel and creating visually appealing dashboards - Understanding of inventory data and its representation in tables

...proficient 2D animator proficient in Adobe Animate to help complete a short film of approximately three minutes in length. Resources available include backgrounds, characters, and storyboards to aid in the project. Key Components: - Animation Style: I require the animator to utilize frame-by-frame animation to bring this project to life. - Animation Complexity: This short film demands advanced motion. This entails highly dynamic changes to both characters and scenes, with intricate movements expected. Ideal Candidate: The perfect freelancer for this task is someone adept in Adobe Animate, with an eye for detail and potential to generate life-like motions in animation. Experience in frame-by-frame animation and the capacity t...