Clean excel vba jobs

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations.

Please Sign Up or Login to see details.

I am in need of skilled photo editors to assist in improving my photos. Services needed will ...assist in improving my photos. Services needed will include: - Background removal and replacement - Color correction - High-end retouching The improved photos should feature solid-colored backgrounds. Ideal freelancers would possess profound skills and experience in photo editing, color correction, and proficient use of editing software. Knowledge pertaining to achieving a professional and clean finish is also a must. Although the specific color for the new backgrounds isn't chosen yet, it'd be beneficial if you could provide recommendations based on the content of the photos. Your input is encouraged! Thank you for considering my project. I eagerly look forward to transf...

Let's do it. let's do it. let's do it

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

I'm looking for an efficient data entry professional to input a variety of data into Excel for me. The required data includes: - Text data - Numeric data - Date and time data The main purpose of this data entry is to facilitate data analysis and the creation of reports. There are approximately 100-500 data entries in total. Ideal Skills: - Proficient in Microsoft Excel - Excellent attention to detail - Strong analytical skills - Previous experience with large volumes of data input

I'm looking for a skilled...Requirements: - The main purpose of the website is to inform visitors about our services and offerings. Therefore, we need a design that is both visually appealing and easy to navigate. - The style of the website should be modern and sleek, catering to the tastes of our target audience. Ideal Skills and Experience: - Strong understanding of web design principles and trends, particularly with a focus on clean and modern aesthetics. - Previous experience developing informational websites, particularly those targeted at young adults, would be highly beneficial. - Proficiency in web development tools and platforms such as HTML, CSS, and WordPress. If you're a website developer who can create a visually engaging and user-friendly website, I'...

I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.

I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.

I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.

Develop an interactive website: 1) clean structure and fast loading (who, what, how, process, product cat.) 2) data management (input and format conversion to pdf format) 3) automatic language conversion based on geographic location 4) ai chat messenger 5) Interactive design a) slider banners b) animated (wave length or video background) 6) integrate stripe gateway. All information is ready, details will be provided once confirmed and website must be finalized/deployed within June 5. Thank you!

I hope this message finds you well. We are looking to optimize our website, , for better search ...Optimization: Optimize each page of the website by incorporating the identified keywords and keyphrases. Ensure that titles, meta descriptions, headings (H1, H2, etc.), and alt texts are properly optimized. Improve the content quality by adding relevant keywords naturally and ensuring readability and engagement. Optimize URL structures for better SEO performance. Technical SEO: Ensure the website has a clean, efficient, and crawlable code. Internal Linking: Improve internal linking structures to enhance navigation and user experience. Ensure that link equity is properly distributed across the site. Thank you, and we look forward to working with you. Best regards, [Your Name]

I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. Looking forwar...

I'm in need of a skilled mobile app developer, ideally with experience in hybrid platforms such as Flutter. The app I'm looking to develop is a translation tool, not a translation engine. It needs to be compatible with both iOS and Android platforms, as well as a web appl...primary goal of the initial version of this app is to have a functioning and seamless translation service across these mediums. The translation service should be able to handle input using text, voice, and the camera interchangeably. You will need to implement the UI/UX and backend logic for the app. Please note that while the primary focus is on the translation feature, the implementation should be clean and user-friendly. I'd prefer a developer who has experience in creating engaging and intuiti...

I need a designer to create an informative and educational road layout image or infographic aimed at adult drivers. Key Points: - The purpose of the image is to educate adult drivers on: - Traffic signs and their meanings - Lane discipline and markings - I require a simple clean layout to be used for driver training. The infographic is of a particular roundabout "Bowater Roundabout" Gillingham, Kent UK - what three words location /// The layout is to educate drivers on lane discipline so layout and road markings need to be correct and clear. Using google maps will give a clear picture of the roundabout. I have attached some sample designs of other work for a guide. I have serval others to be designed too, so the winning bid will receive additional projects

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help

...and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are accurately reflected in the Excel...

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our ...variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and ...

I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes

I'm seeking a designer who can craft a visually compelling and user-friendly interface for a house hunting app running on the Android platform. The app aims to simplify the house hunting process with keen attention to detail and a seamless user experien...- Filter Options: Price, location and size are the 'big three' for property search. The interface should feature these elements centrally. - Save Listings: A feature to save and revisit properties is a necessity. Ideal skills and prior experience: Proficient in Android design guidelines, skilled in UX/UI design, and a portfolio showcasing prior app interface designs. Your ability to create a clean interface that melds simplicity with functionality will be appreciated. Successful completion of this project may lead...

...of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience in creating admin dashboards - Strong understanding of SQL databases - Ability to cr...

I'm looking to revamp my portfolio website. I have some initial ideas for the design, but I'm open to suggestions and creative input from a skilled web designer. The website's primary objective is to showcase my work and credentials. Key points for the project include: - **Design Concept**: I need a fresh and modern design to accurately represent my work. I'm looking for a design that is clean, professional, and easy to navigate. - **WordPress Implementation**: I'd like the new website to be built on WordPress, for its user-friendly interface and ease of future updates. - **Product Search and Filtering**: I need the site to have a search functionality, allowing users to easily navigate and find specific projects or categories. The ideal freelancer for th...

I'm looking for a talented designer to create a clean and minimalistic menu design for my restaurant. The final design should be modern, simple yet eye-catching, and easy to read. Key Requirements: - Design should be minimalistic - Deliver the final design in an editable source file format (e.g., PSD, AI) - Experience in designing menus or similar items is a plus Please note that the third question regarding specific features was skipped. If you have any creative ideas or suggestions for extra features that could enhance the menu design, feel free to share them in your proposal.

I'm looking for an experienced web developer to create a cross-platform e-commerce website. Key Requirements and Deliverables: - Create a user-friendly e-commerce website that functions seamlessly on both iOS and Android platforms - The website should have a clean and modern design, conducive to a positive shopping experience - Implement essential e-commerce features, such as product listings, shopping cart, secure payment gateways, and customer account management Skills and Experience: - Proven expertise in website development, particularly in e-commerce - Experienced in creating cross-platform websites for both iOS and Android - Strong understanding of user experience and responsive design principles - Familiarity with integrating payment gateways and other e-commerce func...

Please Sign Up or Login to see details.

I'm seeking a talented UX/UI designer with a strong portfolio of clean and professional designs, specifically for both desktop and mobile platforms. Key Responsibilities: - Create user-centric, intuitive designs that deliver a seamless experience on both desktop and mobile. - Ensure a clean and professional look and feel, in line with my preference. - Understand and interpret the project requirements to create visually appealing designs. Ideal Skills and Experience: - Proven experience with UX/UI design for both desktop and mobile. - A strong portfolio that showcases clean and professional designs. - Familiarity with creating user-centric designs. - Ability to interpret project requirements and translate them into visually appealing designs.

I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.

I am in search of a skilled website developer who can build a website for my Non-Governmental Organization (N...and donors about our organization, projects, and achievements. - Act as a platform to attract and engage new volunteers and donors. Specifications: - A Contact Form provision for visitors to reach us easily. - Blog/News section to keep the audience updated on our activities. - A secure and user-friendly Donation/Payment Gateway for effortless transactions. Design Preferences: - A design that is clean and minimalist. Ideal Skills: - Proficiency in web development and creating user-friendly interfaces. - Earlier experience with NGO websites would be a plus. - Knowledge in setting up secure online payment systems. - Exceptional creativity in creating minimalist yet engagin...

I am looking for a product designer to enhance the packaging of my packaged drinking water product. The primary goal of this project is to refresh the product's packaging, making it more contemporary, appealing, and user-friendly while maintaining a minimalist and clean style. Key Requirements: - Experience in packaging design, particularly in the consumer goods industry - Proven track record of creating minimalist and clean designs - Familiarity with product packaging for beverages or similar consumer goods is a plus The ideal candidate should be able to understand the essence of minimalism and apply it effectively to the water packaging design. They should also have a strong understanding of the consumer goods market and be able to create a design that stands out on ...

I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I woul...

I am looking for a website designer to create a modern, minimalistic website for my cosmetic surgery practice. The website should significantly enhance the generation of potential client leads. Key features for the website include: - An online booking system for appointments, providing an easy and convenient way for potentia...convenient way for potential clients to reach out. - A cutting-edge before and after photo gallery showcasing the results of various cosmetic procedures. - A testimonials section featuring feedback from previous patients to inspire trust and confidence in potential clients. Experience in designing healthcare or professional service websites would be ideal for this project. The design should be sleek, clean, and modern to align with the professional image of my...

Seeking a talented designer to create a modern and sophisticated coffee bag design. This project will employ a primarily black-and-white color scheme or a solid color with some gold writing, offering a clean look and feel. Key Features: - Abstract design elements to be incorporated, abstract or a simple design statement - Image should evoke a sense of simplicity and elegance, aligning with a modern aesthetic. Ideal Candidate Should Possess: - Strong experience in packaging design, particularly dealing with food products. - Ability to communicate ideas visually, verbally, and in writing. - Proven ability delivering high-quality designs supporting an upscale brand image.

I am seeking a proficient website developer to create a clean, modern website for my clinic. The primary users of this site will be our existing patients. Hence, it needs to be user-friendly and intuitive. The website should include: - An Appointment Booking System: Patients should be able to book appointments with ease. It should display available dates and time slots, provide appointment confirmation and reminders. - A Patient Registration Form: For efficient management of patient information, the website should feature a seamless online registration form. This would result in easier record-keeping and patient scheduling. - Doctors' Profiles: A dedicated section to showcase our doctors’ credentials, their specializations, and experience. This will aid patients i...

I'm in need of a skilled website developer to create an ecommerce site. The website will be focused on selling physical products and will have less than 5 product categories. Key Requirements: - The site should incorporate a clean and user-friendly interface to enhance customer experience. - I require the integration of payment gateways for credit card and bank transfer. Ideal Skills and Experience: - Proven experience in developing ecommerce websites, particularly those focused on physical products. - Proficiency in integrating payment gateways, especially for credit card and bank transfer. - Strong understanding of user interface design to create a visually appealing and easy-to-navigate site.

...some key details to consider: Company Profile Elements: - I'll provide the content, but I need a designer who can expertly lay it out and create a visually appealing profile. - The profile should include sections on our company history, product/service descriptions, and team bios. - The designer will need to ensure the design is in line with a professional and corporate aesthetic, incorporating a clean and sophisticated look. Web Design: - The website design should mirror the company profile in terms of style and theme. - It should be user-friendly, engaging, and optimized for mobile viewing. - The designer will need to have a keen eye for detail and be able to create a seamless user experience. Ideal skills and experience: - Proven experience in creating professional and...

I'm seeking a skilled developer to create a website for me. I'd like the site to have a clean and professional design, similar to examples mentioned: and Key Requirements: - Develop a website with a "Clean & Professional" design style - Ensure that the site is responsive and mobile-friendly Skills and Experience: - Proven experience in web development - Strong proficiency in front-end development languages (HTML, CSS, JavaScript) - Familiarity with popular web development frameworks and CMS (e.g. WordPress) - A good eye for design and the ability to create visually appealing websites If you have a portfolio that showcases your work on similar projects, that would be a great plus. Looking forward to seeing your bids.

I have uploaded our existing vehicle signage design. We would like to have less black and more blue and a more professional and clean design that varies from the original. I am open to a half to 3/4 wrap. I've uploaded the logo's in various formats. Please no lighting bolts! Thanks! I require a talented designer who can create an eye-catching partial van wrap design for my electrical services company. Key Deliverables: - Create a design using the company logo and contact information. The logo will be provided upon project commencement. - The color scheme of the design should predominantly include blue, black, and white. Ideal Skills: - Strong background in vehicle wrap design or similar projects - Proficient in Adobe Illustrator or similar design software - Excelle...

I'm in need of a Wix website designer to create an engaging and user-friendly online store. This platform will cater to young adults, focusing on social justice-related merchandise. It must be modern and clean and user-friendly. Key Features: - Online Store: The main purpose of the website is to sell a wide range of social justice-related products. This will encompass more than 100 items, so experience managing large inventories is a must. - Blog Section: In addition to the store, the website will have a blog section. This is essential for SEO ranking, so design experience that incorporates this is a plus. - Drop-Shipping Integration: The website should be linked to a drop-shipping company, ensuring efficient and seamless order processing. Ideal Candidate: - Proficient in Wi...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

...Tools: In-app messaging system for teams to discuss and finalize match details. Notification system to alert teams about new match requests or messages. Match Confirmation and History: System to confirm match agreements between teams. Record of past matches, including scores and feedback/rating system. Design and User Experience: The app should have an intuitive and user-friendly interface. A clean and modern design is essential to ensure that users can easily navigate and utilize all features. Technical Specifications: Platforms: iOS and Android Backend: Cloud-based server to handle user data, match schedules, and communication Frontend: Responsive design compatible with various screen sizes Database: Secure storage for user profiles, match history, and communications Proje...

I'm looking for a proficient web designer to create my online store using Wix. The store will primarily focus on selling physical products. The ideal freelancer should have considerable experience in designing Wix websites with a focus on e-commerce platforms. Here are some specifics about the project: - Design Style: I have a preference for a minimalistic design. A clean, simple, and contemporary look is what I'm going for. - Product Display: The site should be able to effectively display physical products in an easily accessible and SEO-friendly manner. - User Interface: The UI should be designed with ease-of-use in mind, streamlining the shopping experience for our customers. Skills and Experience Preferrable: - Proficiency in Wix website design - Prior experience in ...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

I have a small indoor garden space that I'm looking to completely transform. Key requirements: - I'm aiming for a modern style with this redesign. The new design should reflect a clean, minimalist aesthetic with a touch of elegance. - While the current garden is small, I'm open to other creative options to enhance the space. Skills and experience: - Proven experience with indoor garden design is crucial for this project. Previous modern garden projects in particular would be a big plus. - Creative skills to come up with innovative ideas to make the most of a small space. - Strong communication skills are important, as I'm looking for someone who can understand and translate my vision into a physical design. Please include a portfolio of your previous indoor...

Seeking a talented freelancer to design a sleek and professional portfolio website to showcase my work as a software developer. The website should have a clean, modern design with a strong emphasis on user experience and effective presentation of my projects. Key requirements include: Clean and modern design to engage visitors and highlight my work effectively. Minimalistic layout to keep the focus on my projects without distractions. A strong visual aesthetic that complements the content being showcased. Proficiency in web design tools and technologies. Previous experience in designing portfolio websites is preferred. Effective communication and collaboration throughout the design process.

I'm in need of a simple yet sophisticated design for my company's logo, XYZ Corporation. This logo will be primarily used for print materials. Key Points: - I'm looking for a minimalist style, something that's clean, timeless and professional. - The design should emphasize the name 'ZBD Corporation', possibly with a subtle, uncomplicated symbol or graphic. - The final product should translate well in printed materials, with no loss of quality or detail. Ideal Freelancer: - Graphic Designer with experience in minimalist design, especially for corporate or brand identities. - Previous projects that show a strong understanding of print design and the ability to create seamless, high-quality graphics for print. Please share your portfolio or relevant ...

Functionality: Data Collection: Retrieve historical stock data (price and volume) for a given set of stocks from a reliable financial data provider (e.g., Yahoo Finance, Alpha Vantage). Store the data in a suitable format (e.g., CSV files or a database). Data Preprocessing: Clean and preprocess the collected data, handling missing values and ensuring consistent formatting. Calculate necessary technical indicators, such as moving averages (e.g., 50-day, 200-day), Relative Strength Index (RSI), and trading volume. Technical Analysis: Implement functions to identify bullish signals based on technical indicators, such as: Moving Average Crossovers: Detect when a shorter-term moving average crosses above a longer-term moving average (e.g., golden cross). RSI Oversold: Identify s...

...on its ACT and WCAG compliance. Once evaluated, it highlights any errors and provides recommendations for improvement. The source code is provided. Key Requirements: - Recreate user input URL evaluation - ACT and WCAG compliance checking - Error highlighting - Recommendation provision Design Changes: - Redesign of the website's layout - Improvements to the user interface Design Preferences: - Clean and minimalist design - Modern and trendy elements The source code is available for reference. Ideal candidates should have a solid understanding of web development, particularly in TypeScript, JavaScript, HTML, CSS, and Python. Experience with accessibility standards, ACT, and WCAG compliance would be highly beneficial. A portfolio showcasing similar projects is preferred. A ...