Excel find replace data jobs

Please see attached pictures. I need the banners to say: - 3X Champions (not 5X) - Replace the "Pittsburgh Penguins" text and Penguin logo with "Rain City Bitch Pigeons" and use the attached logo - Change the year from 2017 to 2024 - Change the years 1991 1992 2009 2016 2017 to 2019 2023 2024

I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...

I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.

I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...

...blogs and one for the marketplace - The website landing page should contain: A story about Kalataru, with a sage (our mascot: Rishi Kalapada) Banner links to our marketplace/shop (Shop: Kalataru Haat) and blogs (Blogs: Humara Akhbaar) Our newest arrivals (our newest collection) Offers if any Our newest blogs Policies Some icons to mention: COD, Shipping partner, Handcrafted with love, Returns and Replace policy - The blogs landing page should contain: A menu bar: Blogs button (to route the user back to the /blogs page), shop button (to route to /shops), About us (to route to /about-us), A search bar to search through the blogs and present the ones matching, also to include suggestions Preset filters based on hashtags on each blog and a dropdown to look into more List of blogs in...

Please read the job listing below before creating something. I need a logo designer who could give my logo a sleek revamp. It currently contains a truck, which needs to be replaced with a car trailer. Here's what the job entails: - Remove the existing truck element from the logo - Replace it with a single car trailer - Modify the existing text to fit my new business - Update the phone number as required Nicely's Trailer rental LLC 304-673-7378 Do not change to colors, font, or layout. The ideal candidate will have a keen eye for design, experience in typography, and a knack for transforming an idea into a visual. Your ability to work with different colors, layouts and elements will be vital in this project. Understanding my brand and channeling it into the redesi...

I'm in need of a freelancer capable of efficient and precise textual data entry into Microsoft Excel. This project requires a keen eye for detail, a high level of accuracy, and excellent organizational skills. You should be fluent in English and proficient in using Excel. To make an informed bid, freelancers should include the following: - Examples of past work related to data entry, particularly with Microsoft Excel. Stats that display the accuracy and efficiency of your work would be a huge plus. - Any relevant experience in data entry or related fields. Please note, attention to detail and Excel proficiency are paramount to this project.

I'm searching for a well-versed Excel professional to create a mark sheet with Alphabetic grades input. The worksheet should have: • Only a single grading scale. • The ability to perform average calculations. The successful bidder should have extensive experience in Excel, with strong knowledge of creating custom functions for alphabetic grade calculations. Furthermore, understanding of academic grading systems will be a plus.

For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.

Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.

I'm looking for a freelancer who can create a modern and minimalistic logo along with a corresponding YouTube banner. The primary objective of these designs is for brand recognition. We want our logo to not only be visually appealing, but to also be memorable and representative of our brand and what we stand for...visit our channel. Ideal skills and experience for this job would include: - Proficiency in logo and graphic design - A good understanding of branding and the principles of good design - Experience in creating YouTube banners - A portfolio that demonstrates modern and minimalistic designs. It's also important that you're able to take on board feedback and work collaboratively, as I'm looking to find a designer who can truly understand and bring to...

I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention to detai...

I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.

...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...

...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for th...

I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.

As a data enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. ...

In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...

...spreadsheet that are considered a duplicate. I don't need any help determining a duplicate, that has already been determined. What I need is for someone to go through the rows in the duplicates sheet, and find those rows in the municipalities sheet, and highlight them. You can see an example of what I mean in the two images attached here. the 'duplicates_examples' image shows a series of duplicate lines, and the municipalities_duplicated image shows those lines highlighted in yellow. That is exactly what I am looking for here - take all of the rows in duplicates sheet, find them in municipalities sheet, and highlight them in yellow in municipalities sheet As you see in the title, this is an urgent request - I need this done by 5pm EST ...

...need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely ...

Currently, our website faces two main obstacles—outdated design and poor user experience. - Outdated Design: Our website needs a modern, sleek makeover. Anyone who is up-to-date with the latest industry trends to give our website a well-deserved refreshing look, is encouraged to apply. - User Experience Upgrade: We're seeking a professional who can improve the layout and navigation of our website. A revamp that would turn website interaction into an engaging and hassle-free experience. We do not have specifics relating to any user experience issues except for a need for an improved layout and navigation. So, a broad understanding of potential UX pitfalls and user-friendly design savvy is crucial. The perfect candidate will have a background in the latest design trends, UX/...

...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for th...

...Key Responsibilities: - Managing Email Communication: You'll be required to handle my inbox efficiently, prioritizing messages, drafting responses, and flagging important correspondence. - Scheduling Appointments: You'll handle my calendar, scheduling meetings, calls, and appointments as needed. - Researching Information: I often require quick, reliable research on various topics. Your ability to find accurate and relevant information will be crucial. Other Requirements: - Daily Availability: I need someone who can assist me daily, so please only apply if this suits your schedule. - Communication Tools: I prefer to communicate through email, instant messaging apps, and sometimes video calls, so proficiency in these tools is essential. Ideal candidates for this role w...

I need an expert to migrate my products from an Excel file to my WooCommerce store. Key Requirements: - Migrate products from an Excel file to WooCommerce - Use attributes to define variations within a single product - Update existing product descriptions during the migration Ideal Skills and Experience: - Strong experience with WooCommerce and product migration - Proficiency in handling product variations using attributes - Attention to detail for updating and modifying product descriptions - Excellent knowledge of data import/export and product management on WooCommerce. - Ability to ensure a smooth and error-free migration process.

We're looking for a talented graphic designer to create a unique and compelling logo for BWC Senior Living Placement, a company that specializes in helping seniors find the perfect living arrangements. Our aim is to make the search for senior housing feel caring, compassionate, and warm, adding a touch of sweetness to this significant life transition. Project Details: Business Name: BWC Senior Living Placement Colors: Black, Yellow, and White, reflecting a classic and sophisticated look. Design Elements: Bumble bee We’d like to incorporate a bumble bee into the logo. This is part of our marketing campaign to create a "buzz" about our services. Additionally, we're tying this in with a Cheerios cereal giveaway, capitalizing on its recognition and nostalgia...

I have a significant amount of text that needs to be typed into Excel quickly. The data is in a simple text format, no complex formatting required. Key requirements: - Proficient in Excel and typing - Attention to detail - Ability to work under tight deadlines The data is straightforward text and requires no specific formatting or analysis. The ideal freelancer will be skilled in data entry and be able to commit to a quick turnaround time.

As a client with emphasis on quality, I need the support of an experienced Python programmer who can take charge of the frontend aspect of my web development project. At the core of this project are the following requirements: - Full proficiency in Python as the main programming language for the task - Demonstrated experience in frontend web development using Python - Familiarity with the best practices in Python programming - Capacity to effectively communicate, provide regular updates and accept feedback The missing response for the third question won't be an issue — I am more interested in a Python programmer who can bring their own unique ideas and solutions. You are encouraged to showcase your creative problem-solving skills. Apply if you have the necessary skills and ...

I am seeking an Excel expert who can meticulously enter extensive amounts of text, numeric, and alphanumeric data into my spreadsheet. The task involves entering names, contact details, sales information, and inventory data. The size of the task is quite substantial, with up to 1,048,576 rows and 16,384 columns involved. The role requires a keen eye for detail, accuracy, and dedication. If you are efficient in Excel and possess experience with handling large data sets, your skills will be highly valuable for this project.

I need a reliable freelancer to assist with data input. Here's a breakdown of the project: - **Task:** Your primary job will be to input data from online forms into either Microsoft Excel or Google Sheets. - **Experience Required:** It is necessary for you to have prior experience with both of these tools. This will ensure you're able to work efficiently and accurately. - **Attention to Detail:** Given the nature of the task, it's crucial that you have excellent attention to detail. Even the smallest mistake can have significant implications. If you have the experience and skills mentioned above, I would love to hear from you.

...problematic error with my Excel sheet. An error message keeps popping up and the sheet becomes protected every time I enter a price. Ideally, instead of locking the entire sheet, only specific columns should be locked when a password is triggered by clicking a button. Key issues: - Error message arising upon entering a price - Automatic sheet protection following action Work Required: - Identify and fix the error triggering the message pop-up - Adjust VBA codes to lock specific columns upon password entry: - Columns A to L - Columns Y, Z to AK - Columns CW to DH - Columns DO to DS - Columns DT, DV, DX, DZ, EB, ED For this task, I need a freelancer proficient in VBA and Excel, specifically with experience with sheet protection issues. A thorough understanding...

I'm looking for a skilled C++ developer to create a CAD software primarily focused on 3D modeling, compatible with Windows OS. Key Features: - Primarily 3D Modeling: The software should excel in 3D modeling capabilities, providing robust tools and functionalities for creating and editing 3D designs. - Compatibility: The software should be specifically designed to run seamlessly on Windows operating system, ensuring optimal performance and user experience. - File Format Support: The software should support importing and exporting of DWG files, for compatibility with AutoCAD files. Ideal Skills and Experience: - Proficient in C++: Extensive experience in C++ development, with a strong understanding of software architecture and design patterns. - CAD Software De...

Scope of work, SureCart (high level). SureCart, SureTrigger, and S...networking, collaboration, and growth opportunities for SMB- and large corporations, investors, and professional consultants. Mission: Our mission is to empower entrepreneurs, investors, and consultants by providing a platform that fosters collaboration, facilitates meaningful connections, and accelerates business growth. Vision: We envision a vibrant ecosystem where startups thrive, investors find promising opportunities, and consultants contribute their expertise to drive collective success. By implementing the above scope of work, Improve Growth Platform will offer a comprehensive solution for startups, scaleups, investors, and professional consultants to connect, collaborate, and grow their businesses eff...

Firstly, I want to know if what I am asking can actually be created in Excel 365 and used in Excel 365 Online. Please dont reply to this post without replying that it can or can't be done. If not, an alternative solution would be greatly appreciated. I need help creating an excel spreadsheet to track student progress in a course using 5 different options that also includes the date the option was selected. I can create the drop down list with the submission options, and apply color rules but I can not work out how to make the cell below change to the same color as the option selected and the date it was selected appear in the same cell. I need to include the date the option was selected selected and because you can't have two formulas in conditional form...

I am in need of a proficient Excel expert who can create a custom spreadsheet for me. This spreadsheet will help in calculating the overtime rates for my 6 employees on a monthly basis. Key Requirements: - The Excel sheet should calculate 3 types of overtime rates: standard (1x), holiday (2x), and evening/weekend (1.5x) - The formulae should be designed to take into account that an employee works a 40 hour basic week with typical overtime of between 1-20 hours. - The sheet should take into account that the employees are not paid for 30mins of travel time to and from work, the employees tell me what time they left home, arrived at site, left site and arrived home. - Standard hours are 08.30-17.00 Mon-Fri with a 0.5hour unpaid break and a 0.5 hour unpaid break if working over ...

More details: What type of data do you need to type into the Excel sheet? Text What is the source of the data that will be typed into the Excel sheet? PDF documents Will the data need any kind of formatting or should it be entered as is in the source document? Enter as is

I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.

I'm seeking an expert in MS Power Automate, well-versed in implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertis...implementing unique flows using different AI Chat APIs - particularly Chat GPT API and Cohere AI API. The primary task is to create a power flow capable of running batches of prompts effectively. Key expectations are: - Expertise in MS Power Automate, API integration, and AI-oriented applications. - Background in working with Chat GPT API and Cohere AI API. - Ability to deliver results on a web excel sheet. Please note that an understanding of additional AI Chat APIs is highly valuable fo...

We're looking for multiple competent native English editors to help us improve English language usage in a big batch of Excel-related tutorials. No testing of tutorials has to be done as the technical aspect of the articles is fine but they've been put together by non-native speakers. Starting with a paid trial.

I have several thousands PDFs that need to be read, interpreted and transcribed into a supplied spreadsheet format. It is important that you: 1) Have an existing team to help with a task that is estimated to take 2 weeks 2) Proficiency in PDF to Excel transcription 3) Ability to complete the task efficiently Applicants based in India only.

...accounting to import customers orders and convert to invoices. We also link / interface to Ideal skills for this project would include: - Proficiency in Opencart system development - Strong UI/UX design capabilities, especially in mobile responsiveness - Experience in developing and implementing referral programs in e-commerce systems - A good understanding of security features to ensure customers' data is protected - Excellent communication skills to understand and deliver on the specific requirements Please note that I'm open to any suggestions or proposals that you may have to enhance this project further. I look forward to seeing how your skills and expertise can bring these ideas to life. I have prepared a document I can send with work we require, as this is...

I'm looking for a skilled Python developer who is well-versed in machine learning and GANs to implement a conditional GAN primarily for image generation as a part of my school project. Key Responsibilities: - Utilize Python to develop a conditional GAN. - Find an academic paper from the last 5 years that enhances the vanilla conditional GAN using a simple approach and use this incorporate their approach to this one. - Find a dataset suitable for the task. It's up to you to choose one. Requirements: - Proficiency in Python. Experience using PyTorch machine learning library. - Understanding of GANs and how they can be applied to image generation.

I have three separate Excel documents that need to be merged into a single, optimized sheet. In this new file, we should only pull specific data columns including Defect ID, Defect Type, Date Opened, Priority, Description, Reproduction Steps, Actual Result, Date Closed, Assigned To, and Comments. These columns must be combined while maintaining clarity and structure. After this task, a dynamic dashboard that displays the current state of the project is required. This dashboard should offer a variety of visualizations. We are particularly interested in bar charts, pie charts, and line charts to present the data in a clear and digestible manner. Ideal candidates for this project are those with: - In-depth expertise in Excel data management - Experience in...

As a forward-thinking business, we're looking to have a replacement app developed for our Shopify store. This app will replace our current Tapcart app, providing our customers with a sleek, user-friendly, seamless mobile shopping experience. Key Features: - Product Catalog: The app should showcase our entire range of products, with easy-to-navigate categories, filters, and search functions. - Shopping Cart: A seamless and secure shopping cart is essential, facilitating worry-free transactions. - Push Notifications: Ability to send targeted push notifications, informing our customers about our latest offers and updates. - Integrations: The app needs to smoothly integrate with Wishlist, loyalty schemes, and various social media channels. Platforms: The replacement app needs t...

...stakeholders will find the following information most valuable: - **Market Trends and Analysis**: This will help them understand the external factors that may influence our business and its competitiveness. - **Competitor Analysis**: Insights into our competitors are crucial for making strategic decisions and staying ahead in the market. - **Customer Insights and Preferences**: Understanding customers and their preferences will help tailor our strategies and offerings to meet their needs effectively. The ideal freelancer for this project should have: - **Business Analysis Experience**: They should have a proven track record in conducting business analysis and creating comprehensive reports. - **Market Research Skills**: Experience in gathering and analyzing market data,...

Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish

...- Ensure search results are accurate and efficiently displayed. 4. **Forum Section**: - Create a forum section where users can discuss various topics related to auto parts, repairs, and vehicle maintenance. - Implement user registration, post creation, and commenting functionalities. 5. **Local Car Rental Search**: - Integrate a local car rental search feature allowing users to find nearby car rental services. - Utilize APIs or databases to provide accurate and up-to-date rental options. 6. **Classified Page**: - Develop a classified page where users can post advertisements for buying or selling vehicles, parts, or related services. - Include features such as image uploads, description fields, and contact information. 7. **Responsive Design**: ...

I require a freelancer who will revamp my powerpoint presentation (attached) in Canva. Here's what I'm looking for: - An expert capable of unifying both fonts and colours to give my presentation a consistent, professional look. - A talented graphic designer with a knack for creating realistic, handmade graphics to replace the existing internet-sourced images. Ideal freelancers should have extensive experience with Canva and strong design abilities. Drawn and digital graphic creation will be a distinct advantage. I need this done in Canva so that I can modify it in the future. Please quote for the whole job and if you are planning to change the price after we start chatting, don't waste your time and mine.

I am looking for a skillful freelancer who can assist me in converting an Excel spreadsheet into a daily calendar schedule like this: Key Requirements: - You must have a firm understanding of Excel and calendar scheduling. - You must be capable of adjusting the Excel data to fit into a daily calendar layout. All data will be uploaded by an excel spreadsheet or .csv file

...specifically GST and TDS filing for my 11-20 clients. - Responsibilities: - Filing GST returns - Filing TDS returns - Periodic accounting in tally for selected clients - Income tax return filing - Coordinating with clients on monthly basis for the documents The majority of my clients have less than 70 transactions per month and I use tally software, thus a good grasp of tally software and excel is necessary to handle the above tasks. - Skills and Experience: - Gst return filing experience - Proficient in tally software - Experience with handling multiple clients simultaneously - Knowledge of GST and TDS filing systems appeciated. This is an ongoing project and I am looking for a dedicated and reliable partner in this area as this will be an ongoing and lon...