Vba macro excel update inventory pricing jobs

I need a skilled programmer for a crucial task: changing all website links and references from . to .au. The project is intended for an existing business site. Additionally, we will require the professional to update SEO settings in all lines of code to reflect the .au domain replacing . Key Responsibilities: - Convert all references of . to .au throughout the entire website - Update SEO settings to accommodate the new domain - Ensure smooth transition without any loss of data or functionality Ideal Candidate: - Proficient in web development and coding - Extensive experience with SEO and domain migration - Attention to detail to ensure no broken links or missing references - Excellent communication skills to provide updates and seek clarification - Familiarity with the

...sending/receiving data packets, and handling socket errors. Additionally, I need help in creating a small WooCommerce database interface. The specific requirements: - Socket Programming: You will be responsible for establishing a server connection, sending and receiving data packets, and managing socket errors. - WooCommerce Database Interface: We will be integrating a small interface to manage product inventory. In this case, we are looking for basic integration - primarily focused on reading product data. The ideal candidate should have: - Proven experience in C# programming, particularly with a strong understanding of socket programming. - Prior experience working with WooCommerce or similar e-commerce platforms for database interface design. - Ability to deliver precise a...

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...

Hey there, I’m interested in building a kind of niche product, basically a coloring app framework for iOS and Android, but the app would use my own artwork. I’d like to be able to reskin it, update it, and add more images as I wanted - so maybe a template with placeholders that I could reskin? I did some basic coding long ago and I’ve bumped around in Swift a bit, so I think if placeholders were inserted I’d be okay doing the reskinning. Functionality that I’d be looking for: - iOS and Android both (maybe quote for each individually, in case we’d have to do one at a time due to cost?) - splashscreen while itloads, then on to the main screen - thumbnails of images, divided into themes - when the user clicks an image it’d take them to the col...

...searching for a freelancer to enhance my local search rankings by creating and managing map citations on Google My Business to reach the top 3 positions with guaranteed results. If you cannot provide a guarantee, please do not apply for this job. Key Responsibilities: - Create high-quality Google Map Citations for my business - Ensure all information is up-to-date and accurate - Regularly monitor and update the citations to maintain their effectiveness Ideal Candidate: - Experience in local SEO and Google My Business - Proven track record in improving local search rankings through map citations - Detail-oriented and a stickler for accuracy - Capable of managing and updating the citations on an ongoing basis - Strong communication skills for reporting and discussing the progress...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accurate and efficient data arra...

...our intranet. Here are the specifics: IA definition: (below you can see my own) - We need the inventory management, manufacturing, service contracts and human resources management features to be properly configured. - The system must be set up for 1-10 users to access on our intranet. Customizations and integrations: - We may require custom reports or dashboards, although the specifics for these are not yet entirely defined. - There may be other custom integrations needed as the project progresses. Ideal Skills and Experience: - Proficient in Dolibarr installation and configuration - Previous experience in setting up Dolibarr for small businesses - Strong understanding of inventory management and HRM - Able to propose and implement customizations as they...

...Create preliminary design of the engine layout (drawings or sketches) - Develop preliminary design/placement of key components (e.g., pipe, valves, evaporator, condenser) Deliverables: First 10 hours: - Design Report (5-10 pages): - Overview of the design concept - Thermodynamic cycle analysis (calculations and spreadsheet; Excel/OpenOffice Calc) - Heat transfer calculations and assumptions (calculations and spreadsheet; Excel/OpenOffice Calc) - Fluid flow, power, and pressure drop (calculations) - Summary of Findings (1-2 pages) Second 10 hours: -CAD Drawings (2D or 3D): - Engine layout design - Key component designs (e.g., evaporator, condenser, piston) -Design Summary (2-3 pages): - Overview of the preliminar...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I am currently having issues updating my pages with Elementor, and I'm not receiving any error messages. Additionally, I've noticed that my website's performance is slow and could benefit from more memory. Key Requirements: - Troubleshoot and resolve the issue of Elementor not updating pages without error messages. - Optimize the website's performance to improve its speed. Ideal Skills and Experience: - Proficient in WordPress and Elementor. - Experience in troubleshooting and resolving plugin compatibility issues. - Demonstrable experience in website optimization for speed and performance enhancement. Your bid should address these points specifically. Please provide examples of similar work you've completed in the past.

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 need a React developer to build a frontend for a Student Management System. Key Project Details: - Two Types of Users: The system will have both admin and normal user functionalities. - Entities: The project involves five main entities: students, admin, class, exam, hall, and scheduling. - CRUD Operations: The system should allow for Create, Read, Update, and Delete operations for the mentioned entities. Admin User Features: - Access Control: The admin user should have the ability to control user access and manage permissions. - Reports Generation: The system should be able to generate exam scheduling reports. I will provide you with the Swaggy API list for this project. The deadline for this project is Saturday night. Ideal skills and experience: - Proficiency in React - ...

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.

...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 to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the ch...

I'm the owner of a WordPress website and have administrative access. I'm looking for a skilled developer to help me change the admin email without altering the username, password, or other settings. The primary reason for this change is to ensure that the contact information displayed is up-to-date. Key requirements include: - Updating the admin email: The new email address will be provided to the selected freelancer. - Maintaining username and password: It's crucial that these details remain unchanged. - Preserving other settings: The current configurations, including security measures and other account settings, should not be affected. Ideal skills and experience for this job: - Proficiency in WordPress: The ideal candidate should have a strong background in WordPress d...

French-speaking candidates only! My organization is currently leveraging several Zoho applications including CRM, Books, Inventory, People, Recruit, Shifts, Project, Survey, and Forms. I am seeking a skilled freelancer who can effectively integrate these applications with our existing ERP system. Key project aims include: - Customer data synchronization: Ensuring consistent, accurate customer information across platforms. - Order management integration: Streamlining order processes for increased business efficiency. - Inventory management synchronization: Maintaining real-time, synchronized inventory data between Zoho and ERP. With 11-50 users expected to utilize this integrated system, the ideal freelancer should not only possess strong experience with Zo...

...Research key topics or areas of interest and presenting options for the next steps. -> googling 2. Executing next steps and promptly executing action items from discussions. -> take instructions and act fast 3. Propose options from research as requested -> more googling 4. Be able to advise proactively on details including step by step documents where needed -> simple ppt stuff 5. Maintain and update the status of various tasks with regular updates 6. Be able to present information clearly in English, not getting too bogged down by confusing details (clear communication) Expectations: 1. Self-driven and motivated to quickly achieve OUTCOMES. 2. Must be available from 6am MST to 11:30pm MST (mountain standard time) for calls - calls to connect will vary day...

I'm in need of a skilled and experienced freelancer to create a WordPress website for my jewelry brand. Key Requirements: - E-commerce Functionality: I want the website to have a smooth and secure checkout process, with the ability to add products, categorize them, and manage inventory. - Responsive Design: The website should be mobile-friendly, given that a significant portion of my target audience falls within the 25-45 years old age group, who are likely to access the site through their smartphones and tablets. Design and Layout: I don't have a specific design in mind, so I'm looking for a professional who can understand my brand and create a visually appealing, user-friendly website. Copywriting: Additionally, I'll need assistance with the copywriting ...

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.

More details: What is the purpose of the astrology website? Offer astrology-related services What elements should it contain to make the content engaging for the readers? Infographics, Short on-site videos, want to give youtube Chanel videos .need a way to regularly update new videos How would you like the website to showcase the YouTube channel videos? Displaying video thumbnails with links to YouTube. want it to be seo compatible

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 WordPress expert who can help me resolve an Error 500 issue that's...cause of the issue - Good communication to explain the issue and recommended solutions in a way that's easy for me to understand. More details: Warning: Found outdated nextend-smart-slider3-pro inside: ./wp-content/plugins/nextend-smart-slider3-pro/ - Version: 3.5.1.21- Please update asap. New Version: 3.5.1.23 Warning: Found outdated advanced-custom-fields-pro inside: ./wp-content/plugins/advanced-custom-fields-pro/ - Version: 6.2.9- Please update asap. New Version: 6.2.10 -------------------------------- Out of date software is the most common cause of website compromise. It's highly recommended to get that updated as soon as you can. Can this above be the problem...

More details: What is the purpose of the astrology website? Offer astrology-related services What elements should it contain to make the content engaging for the readers? Infographics, Short on-site videos, want to give youtube Chanel videos .need a way to regularly update new videos How would you like the website to showcase the YouTube channel videos? Displaying video thumbnails with links to YouTube

I'm in need of a professional who can update config which utilized ESRI's cloud builder tool on Azure. Specifically, the role requires assisting in configuring the ArcWeb server, transforming a site created in IIS to be public-facing. This includes making the site accessible from the internet with a basic level of security, such as HTTPS. Key Responsibilities: - Configure ESRI Cloud Builder tool on Azure - Make existing IIS site on ArcWeb server public-facing - Implement basic security measures (e.g., HTTPS) Required Skills and Experience: - Proficiency in ESRI/ArcGIS platform - Experience with ESRI's cloud builder tool - Familiarity with Azure cloud services - Strong knowledge of web server configurations, particularly IIS - Prior experience in setting up public-f...

We're a dynamic agency specializing in helping businesses stand out on YouTube. We're currently on the 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 techniq...techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfect opportunity to apply your SEO exp...

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

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 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...

I'm looking to develop ...requirements include: - Integration of Credit Card payment method: I want to provide a seamless shopping experience for the customers and to do so, I need to integrate credit card payment method. This will be the primary payment gateway for the website. - Product Management: I need to be able to easily add, edit and manage products through an intuitive interface. I'd like some simple features like inventory tracking and discount codes, but I'm open to suggestions on how to best manage the products. The ideal freelancer should have: - Proven experience in E-commerce website development - Expertise in integrating credit card payment systems - Understanding of product management systems - Good communication skills and ability to suggest idea...

...skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell. The excel file has 5 columns: 1st columns is for Brand 2nd column is for Model 3rd column is for Color 4th column is for Price 5th colums is for Quantity in Stock We want to realize a simple php page with a form to send an email with the chosen products. We need that someone just fill the database wkth the data we have in excel file (about 350 lines) To access the page we need a login page. We need 2 levels: 1 level: administrator 2nd level: agents One administrator is sufficient More agentes are...

...users (online) When uploading database to web from Local MS Access, have to options. Update (update only changes. Overwrite records in web database), or Replace database on web (delete database on web and reupload from Access). Administrator must be able to import from Excel files into MS Access database (voters). When importing from excel to MS Access database (locally) then ms access database must be updated with the following rules: 1. When a record doesn’t exist in Access, but exist in Excel, create it 2. When a record exist in Excel and Access (based on field: EL_NO, UPDATED ALL FIELDS FROM EXCEL AND OVERWRITE ACCESS FIELDS except THOSE FIELDS IN Access starting with FINAL_ and user data entries. 3. In excel files there ...

Please Sign Up or Login to see details.

We need an experienced Magento developer to assist with updating third-party extensions when conflicts arise due to newer php/mysql versions. Timeline: Start on the first project on 20th May using remote desktop tools like UltraViewer or AnyDesk for real-time collaboration. Bidders must be highly proficient in Magento 2.4x.

...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. - Strong attention to detail and accuracy are highly valued. - Understanding of basic financial jargon will be beneficial. This role requires someone who is organized, reliable and able to work independently. The workload will be part-time with flex...

...experience in integrating online stores with various marketplaces and who preferably has worked with Trendyol before. Key Requirements: - Product Synchronization - Order Management - Inventory Updates - Implementing Special Price Rules for the Marketplace Sales: Specifically, I would like a price increment for certain items. Ideal Skills and Experience: - Strong experience with Prestashop, especially versions 1.7.8 and 1.8 - Prior experience with Trendyol integration is a huge plus - Proficiency in managing product synchronization, inventory updates, and order management - Extensive experience in setting up special pricing rules in e-commerce platforms, particularly price increment strategies Please only apply if you have demonstrable experience in similar proje...

...mirroring the successful desktop version's layout. Next, there's a glitch with the content display on my mobile homepage. It seems to be displaying content incorrectly, and I need you to rectify this. Essentially, your role here will be to fix any errors that cause incorrect content display on mobile, making sure all elements appear as they should. Lastly, there is a problem with the automatic update of monthly posts on the homepage. It's visible only when you click ‘read more’ whereas it should appear readily on the homepage. I’m looking for a way around this, so viewers do not have to take the extra step of clicking 'read more' to see the recent posts. Skills and Experience Required: - Experience with WordPress AND GoDaddy platform ...

I'm looking for a ready-made ERP cloud accounting system like that offers these key features: - Inventory Management - Sales and Purchase Tracking - Financial Reporting I'm specifically seeking a system that has a: - Modern and sleek design I plan to integrate this ERP system with other software via API. Ideal Skills and Experience: - Experience with ERP cloud accounting system development - Proficiency in UI/UX designing - Proven ability in API integration with other tools - Familiarity with inventory management, sales tracking, and financial reporting systems. I want similar to

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

Please Sign Up or Login to see details.

...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...

...I'm unable to reflect image updates across the server. Key Requirements: - Troubleshoot IIS : You should be experienced with IIS and capable of identifying and resolving server-related issues. - Server Configuration: The problem may be related to server settings, so a deep understanding of IIS configuration and management is desirable. - File Management: The issue seems to be related to file update. You should have expertise in managing files on Windows servers and diagnosing related issues. - Image Handling: The problem specifically pertains to image updating. You should be well-versed in how servers handle image uploads and updates. Your task will involve: 1. Diagnosing the issue: Understand why new image uploads on the server are not being reflected. 2. Resolving the ...

I'll provide you a link to one webpage where the HTML is available that I need to be made responsive across all devices. This means that the layout and content on the site should adjust automatically to the screen size of the device being used. Show me what you did including the new CSS and I should be able to update more pages myself using what you did as a guide. I do not want anything to look much different on a computer/PC screen than it does now. Just make it also work on cellphones, tablets, etc. I'll test your work on the website and ask a few friends to test on their devices then pay you. But I may need more help later which I'll also pay you using Freelancer if needed. Thank you

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 freelancer who is looking for a 5-star review.

...EHRs and wearable devices. - User Interface: A user-friendly app interface for both patients and healthcare providers. - Testing Reports: Documentation of clinical validation and technical testing results. - Security and Compliance Documentation: Evidence of data security measures and regulatory compliance. - Deployment Plan: Strategy for deploying the app and AI models. - Maintenance and Update Plan: Ongoing support and improvement strategy. Specific Tasks for the AI Builder/Programmer 1. Requirement Analysis and Planning Understand Objectives: Collaborate with stakeholders to understand the specific requirements and objectives of the AI app. Technical Specifications: Develop detailed technical specifications and project timelines. 2. Data Collection and Preparatio...

I'm looking for an expert to create a web-based CRM database aimed at efficiently storing and managing information. The data I intend to keep include: - Customer contact details - Sales history - Communication logs - Course details - Course Refresher notifications This project also requires the creation of functionalities to: - Add new contacts - Update existing contact information - Track sales performance Ideal freelancers should have substantial experience in CRM database development, with knowledge of implementing web-based solutions. Familiarity with training or course-based entities would be a bonus. Your expertise ought to allow seamless additions, updates, and performance tracking of stored information. Demonstrable success in similar projects will be advantageous. ...

...seamless and efficient dropshipping automation system. Key Responsibilities: - Develop a system for order processing and tracking to ensure smooth operations - Implement inventory management solutions to prevent stockouts or overstocking - Enable price monitoring and adjustment features to stay competitive Ideal Skills and Experience: - Previous experience in setting up Amazon dropshipping businesses - Proficiency in automation tools and software - Solid understanding of ecommerce and dropshipping best practices - Strong analytical skills for monitoring and adjusting prices - Excellent problem-solving abilities to manage inventory effectively If you're a proactive, detail-oriented freelancer with a talent for automation and a strong grasp of the Amazon dropshipping...

...developer to optimize the loading times of my web application. Key Points: - The main issue with the current site seems to be the product pages, which need to have their loading times significantly improved. - Additionally, I suspect that large images or media files, inefficient code or algorithms, and server response times are also contributing to the overall slow performance. - Moreover, I need to update application packages, currently I am using nextjs 9.2.0 and some depreciated libraries. Ideal Candidate: - Proficient in React and to be able to efficiently refactor the code and optimize the loading times. - Experience with image and media optimization, as well as knowledge of best practices to ensure efficient image loading. - A strong understanding of server-side rende...

I need to install a new WordPress template, whilst keeping all my data. The primary aim is to update the functionality of my e-commerce site. - **Data Preservation**: It's crucial that all existing data is retained during the template change. - **Functional Overhaul**: The new e-commerce theme should come with enhancements, particularly in terms of the product review system.

...be the centerpiece of the affiliates page, showing all sister radio station locations globally. - A static map design with clickable markers is preferred, enabling users to easily navigate through different stations. - Search Functionality: - A search bar is necessary to allow users to find a specific station by entering either its name or location's zip code. This feature should filter and update the markers on the map accordingly. - Station Information: - For each radio station, the page should display: - Station Name: This is the primary identification of the station. - Location Address: The physical address of the station. - Contact Information: Details such as email, phone number, or website link for users to connect with the stations. I am seeking ...

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/Experience: - Proficiency in web scraping, especially fro...