Excel macro to append data from multiple sheets jobs

I have a large batch of text data in PDF files that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints

I'm looking to obtain contact information, specifically email addresses and physical addresses, of local jewellery shops from multiple countries. This information will be primarily used for a marketing campaign. The ideal freelancer for this job should possess: - Proficiency in web research and data collection - Proven experience in lead generation - Knowledge about the jewellery shop industry. I'm particularly interested in local artisans, as opposed to high-end luxury shops or exclusively online retailers. Please apply if you are confident in gathering accurate and quality data from various resources.

...experienced 3D modeller who is proficient in Autodesk Revit. My project requires: The Conversion of 3D laser scans with BLK360 into high quality, detailed Revit models. The objects is the survey of information of a structure of 335m2 in plan made up of two levels, the first level consists of a structure of 6 columns that are part of a system of frames resistant to moments, on an articulated base. On the second level there are two structures to support the air coolers, in each one there are 4 fans and they are made up of 15 columns working in a system of gantries with concentric braces. The information that the survey must contain is: Geometry, profiles, connections, gas pipes, equipment or elements that may present interference in case of reinforcement. The information ...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm looking for a Python developer to create a simple Dash app that includes a PDF viewer. Key Requirements: - User can upload multiple pdf files in the app. - The user can select which pdf should be displayed in the viewer - the user can enter a text in a text box and when hit submit the app should be able to highlight those texts in the PDF. - The pdf viewer should have search feature, pages and zoom in and out.

Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook ...

I need a seasoned developer to convert my existing Swiftic app into a freestanding app that can be listed on the App Store, Google Play, and Amazon. The app is currently accessible via www.ecosmartecloud.com. Skills and Experience: - Proficiency in Swift programming language - Experience in converting existing apps to standalone apps for multiple platforms - Familiarity with submitting apps to App Store, Google Play, and Amazon - Knowledge of push notifications and user login/authentication systems The main purpose of this app is to provide a platform for communication. Key features I'd like to retain after the conversion are push notifications and user login/authentication. Please let me know your prior experience with similar projects, a...

I'm seeking an expert in Google Sheets to help me create a functional document geared towards tracking paint and repair tasks, and cleaning schedules across a busy summer camp campus. This sheet will be regularly updated by our facility maintenance team. The ideal candidate should: - Have substantial experience in creating dynamic and user-friendly Google Sheets. - Understand logistics and scheduling in a maintenance setting. Key features of the Sheet should include: - A system for recording painting/repair locations. - Fields for indicating the type of paint or repair needed. - An integrated cleaning schedule that doesn't disrupt ongoing summer camp activities. - A remark section to note if the cleaning crew has cleaned, dusted and removed furniture...

I'm looking to set up a platform where I can sell digital products. Key Requirements: - I'd like customers to be able to download their purchased products directly after they make a purchase. - The platform should support cryptocurrency payments for the purchases. Ideal Skills and Experience: - Experience in setting up online sales platforms, preferably for digital products. - Knowledge of cryptocurrency payment systems. - Understanding of user-friendly download processes for customers. Please let me know your experience in this area and how you would approach this project.

I need a skilled 3D designer to create a small, realistic airsoft grenade design. The STL file should have: - Detachable parts to add an element of realism and functionality - Multiple color patterns to mimic a genuine grenade - Realistic texture that ensures a life-like feel when handled Your proficiency in 3D designing software, understanding of airsoft replicas, and your consideration of usability in design will be beneficial for this project.

I'm seeking a skilled professional well-versed in MAXQDA software and data analysis to assist with my upcoming project. The work will involve the analysis of multiple sets of data - primarily surveys, interviews, and focus groups. Key tasks involved: • Coding data sets on MAXQDA • Analyzing coded data • Delivering insightful interpretations of results The job will involve approximately 40 surveys, 12 interviews, and 2 focus groups. It's therefore crucial that the successful individual or team is able to perform this task efficiently, maintaining high-quality data analysis throughout. Having previous experience in a similar job, and professional knowledge of Windows operating system, is highly desirable....

...knowledge and connections to secure the most competitive air freight rates while maintaining the quality of delivery services. The air-shipping rate we’re looking for is $5 per 1 kilogram. - Air-Shipping Time Duration: We’re looking for air-shipping time duration between 1-14 days. - Final Destinations: To make sure the shipping company can deliver the product from China till our clients doorsteps in GCC countries. - Efficient Handling Of Electronics & Clothes: You should be well-versed in handling electronic goods and clothes to ensure they reach their destination in optimal condition. - In-Depth Knowledge Of GCC Customs Regulations: You should be familiar with the customs regulations of Saudi Arabia, United Arab Emirates, Bahrain, Oman, ...

...on the hunt for an expert in AI voice technology who can help me bring my novel to life via an audiobook. The audiobook is on a larger scale, clocking in at about 12 hours, so durability and attention to details are crucial. Your task will involve incorporating a wide range of AI voices (more than four) to deliver a more engaging and dynamic listening experience. Furthermore, I want certain voices to have specific accents to align with the unique characters featured throughout the novel. While the accents aren't currently decided, your input and expertise here would be appreciated. The ideal candidate for this project: - Is proficient in AI voice technology, preferably with a portfolio featuring multiple voice characters. - Has a...

...experienced developer to provide long-term maintenance for my e-commerce website. The ecommerce is up and running and fully operational and we need a FULL STACK developer that can code in ALL AREAS of the webapp. - Frontend: React (JavaScript) - Backend: Node.js - Services: Python - Database: MySQL RESPONSIBILITIES: - Integration of new B2B APIs - New payment gateway integration - - Implementation of bug fixes and performance improvements. - Regular software updates and security patches. - Feature additions and enhancements. Skills and Experience: - Proven experience in maintaining e-commerce solutions. - Proficiency in React, Node.js, Python, and MySQL. - Strong problem-solving skills. - Excellent understanding of software best practices and design patterns. - Ability to...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

I'm looking for a skilled photo editor who can completely remove sun rays from an outdoor photo featuring a motorcycle and a person. Your expertise in professional photo editing and manipulation will be crucial to achieving a flawless end result. Here are my requirements: - Complete removal of sun rays from the image. - Retain the overall quality and integrity of the image while executing the task. - Experience working with outdoor photography and dealing with lighting elements. - Excellent attention to detail to ensure a natural look after removal. - The ability to work efficiently to deliver the project within the agreed timeframes.

I am in need of a professional and experienced technical recruiter who can assist in filling multiple IT Project Manager positions in my company. The role will involve conducting interviews, assessing candidates' suitability, and supporting the hiring process until the positions are successfully filled. Key Responsibilities: - Conducting thorough interviews with potential candidates for the IT Project Manager role. - Assessing candidates' qualifications, skills, and suitability for the position. - Collaborating with the hiring team to shortlist and present the most qualified candidates. - Providing feedback and recommendations on potential hires. Ideal Skills and Experience: - Proven experience as a technical recruiter, particularly in IT-related roles. - Familiar...

I'm in need of a talented individual who can ...marketing campaigns, and website banners. So, they need to be versatile and engaging. - The desired style for these GIFs is 'Cartoonish'. Therefore, experience in creating such content or a strong portfolio in cartoon-style animation is highly desired. Your responsibilities will include: - Conceptualizing and storyboarding the GIFs. - Designing and animating the cartoonish GIFs in a way that is both entertaining and fits the marketing purposes. - Ensuring the final product is of high-quality and is ready for distribution across multiple platforms. If you have a strong background in creating animated marketing content, particularly in a cartoonish style, and are ready to bring some humor and creativity int...

...lookout for a YouTube SEO specialist to boost the visibility and ranking of our high-quality content on the platform. Key Responsibilities: - Implement advanced SEO techniques to improve the ranking of our videos in search results. - Conduct comprehensive keyword research and optimize video content accordingly. - Enhance the appeal and engagement of our videos through creative thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword research tools and SEO optimization techniques specific to YouTube. - Proficiency in utilizing analyti...

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google s...

...looking for a talented designer to create a 6x9 E-Book cover for a senior fitness book. The cover should be Bold and colorful, conveying the importance of staying active and healthy in old age. Key requirements: - The cover should prominently feature an image of a senior exercising, engaging the target audience in the fitness theme - A vibrant mix of multiple colors should be used to make the cover visually striking and appealing Ideal skills and experience: - Proven experience in E-Book cover design, particularly in the health and fitness niche - Excellent knowledge of color theory and ability to create bold, colorful designs - Understanding of the target audience and ability to incorporate suitable imagery for seniors - Strong portfolio that showc...

...combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields mentioned in...

I have a photo of a medal that I would like to have converted to a svg file for printing. I want the outlines of the kings head, text and contours in black. Also the clasp with the text *1858 Gustaf V †1950 in black. The ribbon should be black also. Show examples and the best one gets the job.

I'm looking for a skilled game tester to assist in the quality assurance of my upcoming action game. The game runs on a PC, so it is crucial that you have access to a compatible system. Your main responsibility will be to identify, record, and track any bugs or glitches in the game. This will involve playing through the game multiple times, under different conditions, to ensure all potential issues are captured. It is essential that the successful candidate has: - A keen eye for detail - A methodical approach to problem-solving - Excellent communication skills to accurately report bugs Previous experience in game testing, particularly on PC, would be highly advantageous. Job is only around 15 - 30 minutes.

I am looking to establish a long-term relationship with a talented person to scrap thousands of dating profiles from popular dating websites. This person should have years of experience dealing with the various countermeasures these sites will employ to discourage scraping. The use of proxies may be needed to achieve satisfactory results. The end goal to to have a system capable of delivering 20K - 40K profiles per day.

...monitor a MySQL database on my Windows system. The app should be able to perform the following functions: - **Monitoring MySQL Database**: The application should constantly monitor my MySQL database and detect when a new record is created. - **WYSIWYG Template Management**: There should be a feature that allows me to manage various WYSIWYG templates. These templates would be used to generate dynamic PDFs based on the new records in the database. - **PDF Generation**: Upon detecting a new record, the application should automatically generate a PDF based on a selected WYSIWYG template. Naming convention based on filed in processing record. Option Password added to pdf. I would like the application to be user-friendly and easy to navigate f...

I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory....

I'm looking to create several pages for my website, with the primary focus on About and Technology. Home page for my website is already created. The specific requirements are as follows: - About Page: I already have content prepared, so this will mostly involve structuring and formatting. - Technology Page: This should highlight the technologies we work with, and ideally include a section on our technology partners. Additional page requirements include: - Career page - Development Lifecycle page - Development Methodology page - Engagement & Partnership Models page - Inquiry Form page - Technology Partners Page I also have a few other smaller tasks that need to be completed. Skills and experience necessary for this project: - Proficiency in web development and de...

I need a skilled developer to help me create a high-quality app sheet for the education industry. The main aim of this project is to increase my online visibility and generate more leads. Key Features Required: - Primarily, the app must have quizzes and assessments. Ideal Skills and Experience: - Experience developing app sheets or similar software within the education sector. - Knowledge of incorporating interactive elements like quizzes into an app. - Strong understanding of how to optimize visibility online and generate leads. As an app developer on this project, you'll take on a pivotal role in creating a valuable educational tool. If you’re passionate about development and education, I'm eager to hear from you.

I am looking for a skilled conference coordinator with a focus on speaker management. You will be responsible for coordinating and managing speakers for an upcoming conference with less than 100 attendees. Your responsibilities will include: -Speaker identi...-Speaker identification and engagement -Ensuring all speaker logistics are taken care of -Being the point of contact for speakers Skills and Experience: -3-5 years of experience in speaker management specifically. -Experience working with conferences of similar size -Strong communication and organization skills -Ability to manage multiple tasks and deadlines effectively This role requires someone who can handle all aspects of speaker management, from initial engagement to logistical coordinatio...

I'm looking for a US-based Virtual Assistant who is proficient in email marketing and skilled in data scraping. The ideal candidate should also be able to provide excellent customer support. Key Responsibilities: - Handle email marketing campaigns using Mailchimp and AWeber or something like that. - Scrape contact information from specified sources - Provide exceptional customer support as needed Ideal Skills: - Proficiency in Mailchimp and AWeber or something like that. - Experience in data scraping, particularly contact information - Excellent communication and customer support skills - Ability to handle multiple tasks efficiently - Attention to detail and accuracy in email marketing and data scraping Please only apply if yo...

...Books system for my invoicing processes. Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). - Enable and Teach me to Use Odd's OCR feature to fetch pdf data from invoice to transfer it to software Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel shee...

I need a VRBO scraper to extract property details, pricing, and availability. - The scraper should be built with Python and the output should be in CSV format. - The data points I need include property title, description, amenities, pricing, and availability. - The scraper should be able to handle multiple URLs at once. - The code should be well-structured and commented for easy maintenance. Ideal skills: - Proficiency in Python - Experience in web scraping - Understanding of VRBO website structure - Ability to handle and store data in CSV format

I'm looking for a highly efficient data entry professional to handle an important task for my project. Your primary role will include: * Entering diverse types of data (both text and images) into a spreadsheet. * The data will be quite varied, so an ability to handle multiple data types effectively is fundamental. * An eye for detail is essential considering the diverse nature of data that will be input. The ideal candidate should possess advanced MS Excel skills and have considerable experience in data entry. Your ability to manage large amounts of data, and ensure it's correctly and promptly entered into the spreadsheet, will be critical to this role. Familiarity with different types o...

As an experienced data entry professional with three years of remote work experience, I am seeking new data entry opportunities from home. My expertise primarily lies in entering customer information, a task I have performed with precision and efficiency in the past. Key Requirements: - Data Entry: Primarily focused on entering customer information. - Software Proficiency: Proficient with Google Sheets. Ideal Skills: - Exceptional attention to detail. - Strong organizational and time management skills. - Previous experience working remotely. - Familiarity with other tools or software for data entry tasks is a plus.

I'm looking for a skilled developer proficient in for front-end developme... as well as integrating a number of unique features. Key Requirements: - User Authentication - Responsive Design - Implementation of multiple pages - Working with AI APIs - Multiple backend Custom API calls - HTML Visual Editor Aesthetically speaking, I prefer a clean and minimalist design. At this time, there is no need for third-party service integrations. Ideal Skills: - Experience in - Strong understanding of API integration - Ability to incorporate responsive design - Experience with HTML Visual Editors - Ability to build interactive web apps, with interactive editors similar to that available on and Looking forward to accomplishing these tasks seamle...

We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processin...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new

I am looking for a skilled developer to create a fully tested and secure website (frontend, backend + admin panel) with no bugs or issues using the MERN Stack. The key features of the front end design include a responsive design, user-friendly navigation, and custom animations. For the backend it would be clean, and fast high quality code with comments and good organisation and readability. The ideal candidate will have experience working with tight deadlines, provide constant high quality updates and be able to deliver quality work within a short timeframe. Bids: Please provide 3 links to your recent MERN/MEAN projects and provide some documentation or proof that you were the original developer of those 3 websites please. Tech: Front-end Framework: React.js with an...

...cell records from Google Take Out that need to be converted into an easily searchable and readable format. Key points: - Data formats: Both digital and paper - Required output: PDF document - Analysis: I need you to analyze the number patterns for this data, specifically looking at numbers used once versus those repeated over multiple years. This analysis should be done thoroughly and presented in a clear, easy-to-understand manner. Ideal freelancer skills and experience: - Proficient in data conversion and organization - Skilled in creating and working with PDF documents - Experience in data analysis, especially patterns and number analysis - Ability to create visual representations, such as charts and graphs - St...

I need a desktop software designed to help me collate and manage Bible verses from the New King James Version (NKJV). Collation of 500 Most Popular Bible Verses We are developing a spreadsheet-based database of the 500 most popular New King James Version (NKJV) Bible verses and collation (into Excel or Google Sheets). The output must be in the NKJV and adhere to a strict protocol - The quotation - Source in a specified format (e.g. 2 Kings 3:2-5 - Maximum 55 words Extensive source material is available online, and we encourage the use of existing source material, with the primary emphasis on the collation/assembly into the required format. We are happy to answer relevant questions for clarification. Ideal Skills: - Native English - Familiarit...

...me dummy offers just to make the initial Contact and then ask for more money. The Project: Develop the project in NodeRed Monitoring specific "HTML div elements" from different web pages using Node-Red (different flows). Objective: Identify when there is any change in the DIV section of the webpages (every "x" seconds) and notify me of the change. It is not necessary to show what the change was. Just send the hyperlink by Telegram, including the subject of the flow. Requirements: Create a Node-Red project that can detect changes on multiple websites by creating flows. Include 2 example flows to demonstrate how the monitoring works. Provide detailed instructions on how to create a new flow for a different webpages, i...

I require a one-time data scraping project completed on multiple websites. - TASK: The task involves scraping text content from: Google searches: Commercial Real estate agency Saudi Arabia Commercial Real estate agency UAE Commercial Real estate agency Qatar Commercial Real estate agency Kuwait Commercial Real estate agency Bahrain I have made a start to the spreadsheet with a template for each of the regions which can be continued to be filled in. In the Google searches, just take the first 3 pages with the main agent listings and see what agent names/ email addresses you can find. - DATA REQUIRED: The primary data needed is text content. - TIMELINE: This is a one-time task, with no ongoing scraping requirements. Skills/Experien...

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the...

I have a large set of handwritten notes that need to be accurately transcribed into digital format. I need someone who is meticulous and has a keen eye for detail, as the work needs to be done with no errors. Key Requirements: - Type of Job: Data Entry - Data Format: Handwritten notes - Level of Accuracy: Very High (no errors acceptable) Ideal Skills: - Proficient in typing - Detail-oriented - Experience in data entry, particularly with handwritten notes - Ability to follow instructions accurately and efficiently Your task is to convert these notes into a digital format, ensuring every detail is captured accurately. Your attention to detail and commitment to producing error-free work is crucial.

As the main user of a system integrated with Google Sheets and Zapier, I'm currently grappling with some performance issues. Concretely, there's a challenge with incorrect data output from our automated data and workflow program. I'm seeking an expert to: • Conduct a thorough audit and maintenance of our data-entry automation and workflows • Identify the root cause of the inconsistent output, and provide tailored solutions • Enhance the reliability of the system overall to prevent any future issues. Presenting a solid proficiency in Google Sheets, Zapier, and workflow optimization, your skills will indeed come in handy for the successful troubleshooting, rectification and enhancement of the system. Effi...

I'm seeking an experienced interior designer to transform a 1000 sq ft office space. This project aims to follow a modern, minimalist style, with an emphasis on creating a visually pleasing and functional environment throughout the premises, including the meeting rooms, workspace area, break rooms, and the lobby. Requirements: - Proficiency in creating minimalist and modern designs. - Proven ability to design for multiple office areas. - Expertise in utilizing neutral tones – whites, grays, beiges. The successful freelancer should showcase their portfolio reflecting similar projects, and be-hands on in suggesting space planning, furniture, and decor that supports the minimalist style.

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation