Vba excel import update data jobs

Please Sign Up or Login to see details.

I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.

Hi there. I ...page that allows me to say IF somevariable = current displayed letter, then move to next. Basically, the function would help me create a way to automatically change the letter to the next letter IF some condition exists, which I will handle myself and assign to the variable you create. IF $somevariable = $current_letter THEN move to next letter I would like you to use auto-layout, so I can import this into the App I want to and use it for iPhones or iPads. I'm using XCode 15.3, so I need to be able to run the App in that. Thanks! And, I need this asap. Then I need you to show some images/layers IF the $somevariable function is correct and other images IF the $somevariable is incorrect (see attached images). It's sort of like a simple Learning Exercis...

...ideal candidate will have proven experience in WordPress and a portfolio demonstrating business websites, preferably in the technology and energy sectors. This fast-paced project requires completion within one week, so immediate availability is essential. Responsibilities Design a WordPress business website that showcases our energy storage technologies through interactive and dynamic elements. Update and optimize existing materials on the website. Integrate essential functionalities such as contact forms into the design. Ensure the website is mobile-responsive, SEO-optimized, and adheres to web accessibility standards. Deliverables A fully functional, tested, and live WordPress website. Work Details Content Provision: All text content and images will be provided by our compan...

...ideal candidate will have proven experience in WordPress and a portfolio demonstrating business websites, preferably in the technology and energy sectors. This fast-paced project requires completion within one week, so immediate availability is essential. Responsibilities Design a WordPress business website that showcases our energy storage technologies through interactive and dynamic elements. Update and optimize existing materials on the website. Integrate essential functionalities such as contact forms into the design. Ensure the website is mobile-responsive, SEO-optimized, and adheres to web accessibility standards. Deliverables A fully functional, tested, and live WordPress website. Work Details Content Provision: All text content and images will be provided by our compan...

I'm looking for a skilled developer to update an existing capacitorjs plugin to version 5 and introduce Android compatibility. I am looking for a Geofence plugin. I have a good starting point with a public plugin, but it needs updating. Here is the source repository: Please reference it, and add updates to it for capacitor version 5, update any of the swift or Objective C code that may be out of date, add corresponding support for Android. Key Requirements: - The main focus of this project is to enhance the plugin's compatibility with various platforms, particularly iOS and Android. - The plugin should be updated to Capacitorjs v5 to ensure it's leveraging the latest features and security patches.. Ideal Skills and Experience: - Proficient

I'm looking for a Zoho expert who can help me with improving my inventory management, streamlining sales and customer relationship management, and increasing overall efficiency and productivity. Looking to build a template platform that will be recreated across multiple companies. Key Responsibilities: - Assist with data import/export in Zoho Inventory - Customize fields and layouts in both Zoho Inventory and CRM - Integrate Zoho Inventory with my existing CRM system and sales tracking system Ideal Candidate: - Proven experience with Zoho Inventory and CRM - Strong understanding of inventory management principles - Experience in customization and integration of Zoho systems - Excellent communication and problem-solving skills Your assistance will significantly help me...

I'm looking for a talented designer to help me refresh my current logo by incorporating new lettering. Change 1) Paasulntt Hill to Pleasant Hill, CA 2)Cub Sclt to CUB SCOUT 3) Jeap to 405 Ideal candidates should have: - Proven experience in logo design - Strong graphic design skills - Ability to create modern and appealing lettering - A portfolio that showcases previous logo design work - Experience with designing for print and digital platforms

...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...

...high-quality standards, top ratings, and good reviews (4.5 and above), and with the lowest price and the shortest delivery time frame to the UK (4 to 7 days). 2. Once you have identified the best products, import them into Dser and edit them before importing them into Shopify. It is crucial not to push products to Shopify without first editing them on Dser, including the SEO-optimised content in each product description. Add videos to the products for better customer engagement. Additionally, balance the different brands and avoid populating a category with mainly one brand. 3. Import reviews and optimise SEO, as these are essential. 4. Avoid listing products with non-English language descriptions, images, or videos. 5. Also, do not list products with suppliers like Al...

I am in need of a react-native whizz who can figure out and solve the error messages plaguing my project post SDK upgrade. ...solve the error messages plaguing my project post SDK upgrade. Detail-oriented and aggressive troubleshooting skills are a must for this job. Since upgrading my SDK from version 50 to 51, my project has been inundated with errors. My dependencies are up-to-date and compatible with the new SDK version, but a solution remains elusive. The errors appearing are related to syntax issues and styles import (hermes) Ideal Skills: - Extensive experience in react-native - Comprehensive understanding of SDKs and upgrading processes - Excellent debugging capabilities Nobody likes bugs, so let's squish this one fast. Looking forward to working with an enthusiastic ...

I am looking for a skilled modder who can reskin two characters from Total War: Three Kingdoms - Lu Bu and Diaochan. The work involves the following specifics: - Complete reskin of both characters with existing texture and model files - Import of model and texture files that are already available - Making sure that .pack file (mod) is applied to correct characters Ideally, this project should not take more than a day to complete, and it requires basic knowledge of modeling for the successful import of the model and texture files. Total War: Three Kingdoms Character Reskin Mod for the game in "pack" format, suitable for the game and fully functional for the game and compatible with other mods. made for last version for the game. I will provide files for both char...

I am seeking an experienced professional who can resolve challenges that occurred after my website was affected by malware and a WordPress update. The issues I need addressed are: - Broken links and images - Distorted website layout - Install SSL These complications are experienced on Google Chrome, Mozilla Firefox, and Safari browsers. Despite clearing the cache, these issues persist. Therefore, prospective freelancers need to be proficient in WordPress and have in-depth knowledge in troubleshooting browser and malware-related issues. Your expertise will be well-appreciated.

I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, inclu...

My Wordpress site's dropdown menus are malfunctioning. This has been a problematic issue that's affecting all the pages on my website. I've been utilizing the WordPress default menu manager to handle the menus. This problem is hindering my ability to update and manage the content effectively. I am seeking a proficient Wordpress developer who can: - Diagnose why the dropdown menus aren't functioning properly. I believe it is has something to do with the theme I'm using (Roosevelt) because when I switch themes the dropdowns start working. This started when I updated to the newest version of Wordpress. - Use their extensive knowledge of Wordpress and its default menu manager to rectify this issue swiftly. - Provide a guideline on how to avoid this in the fut...

I'm in search of a competent individual or team to manage my multiple websites - a mix of e-commerce, blogging, and corporate sites. We need a web manager to manage our 5 websites for a month milestone of 35 USD. Must be a wordpress expert Must be dedicated and have to make sure all websites are live Must be available to update the websites at all times when needed Must protect the websites from malware and virus Must frequently take backup of all files.

Hello, Thank you for your interested. I'm in need of a proficient InDesign user to update business cards for multiple staff members. The business card has already been designed. This is only updating cards for other staff members. The task includes: - Updating each card with the new staff member's name, title, and contact details. - Implementing minor design tweaks to update staff member's photo on the card There are more than 6-8 business cards that require updating. Upon completion, I will need print-ready PDFs for each business card. Ideal candidates for this job should have a strong command of InDesign, as well as a good eye for design details. Previous experience with business card design and print-ready file preparation is a plus. Please note that ...

I'm dealing with a persistent virus and malware issue on my WordPress website. Despite running a security plugin, some issues still linger. To clarify, the tasks I need assistance with are: - Detect and eliminate the remaining virus/malware threats - Ensure the removal is comprehensive, with no residual issues - Update the outdated newspaper theme of the website () Help reinstalling/updating plugins - Sabai Business Directory (keeping existing categories and businesses in the directory) - The ideal freelancer for this job would have

...a timeline with text showing what the interviewer and interviewee are saying in text, add the name of the next person to be interviewed/coming up to keep viewers engaged. 4. Weekly task - Add animations or text to highlight moments to engage the viewer. 5. Weekly task - Edit the short snack trailer, approx 7/14 seconds showing all the people we will interview in this weeks HOTLINE. (30 mins to update each week) 6. Weekly task - Add a 10 sec airoplane exit segment that is allready created. We will share. 7. Weekly task - Break up and produce each interview, put the intro and exit on each interview and provide a short 3 to 7 sec snack of one of the best questions and responses as a trailor for the interview (20 mins each). Weekly tasks You upload to our Wellington live you tube ...

I need someone who can research the regulations for importing and selling industrial RFID reader in Hong Kong. A brief report needs to be made with the following information: 1) Regulations related to the import of RFID reader ・ Approval and license that importer and distributor are obliged to obtain prior to the import and selling of RFID reader (such as OFTA license) ・ Related laws and regulatory authorities 2) Regulations and standards related to the sale of RFID reader, such as Quality standards or quality requirements, Environmental requirements (RoHS etc.) that need to be satisfied (if any) ・ Regulations regarding labels (labeling requirements, if any) ・ Each report needs to be made in English and will be of about 4 sheets of A4 paper (about 2,000 words). I want the ...

I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyz...

I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.

I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.

I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos To find all the state outlines, you will need to Googl...

...predictive analytics, and automated scheduling to optimize the allocation of available during periods of scarcity Problem Definition: The issue of electricity shortages has always been an issue in Zimbabwe, there has always been a gross imbalance between the electricity available and the demand for it. Due to the depressed local power generation coupled by increased electricity demand as well as power import constraints, it means that the country will not be able to meet the demand for electricity Requirements or Objectives: - User Registration and Login: The website should allow users to create accounts and log in securely. - Schedule Display and Updates: It should display the scheduled power outages in different areas. - Notification Alerts: Users should receive timely notifi...

...predictive analytics, and automated scheduling to optimize the allocation of available during periods of scarcity Problem Definition: The issue of electricity shortages has always been an issue in Zimbabwe, there has always been a gross imbalance between the electricity available and the demand for it. Due to the depressed local power generation coupled by increased electricity demand as well as power import constraints, it means that the country will not be able to meet the demand for electricity Requirements or Objectives: - User Registration and Login: The website should allow users to create accounts and log in securely. - Schedule Display and Updates: It should display the scheduled power outages in different areas. - Notification Alerts: Users should receive timely notifi...

I've got the UI/UX ready for my import-export services website, now I need an expert WordPress developer to bring it to life. The key features I'm looking for include: - E-commerce functionality: My website should be able to support the import-export business model, allowing for buying and selling of products. - I'm specifically looking for a site that caters to import-export services, so experience in this area would be a plus. - Other functionalities that might be crucial and can be discussed with the freelancer include real-time shipment tracking, online payment gateway, and multilingual support. Ideal skills and experience for this project: - Proficiency in WordPress, including e-commerce plugins and themes. - Experience in creating websites with ...

I have a level sensor which is currently sending data to a local Wi-Fi network, accessible through a web browser using the sensor's IP. I'm seeking assistance to automate this process and have the following requirements: 1. Data Fetching: The sensor is measuring liquid levels. This specific information needs to be fetched and transferred directly to an Excel sheet. 2. Data Update Frequency: The data should refresh in the Excel sheet every minute. 3. End Goal: The collected data will be used to generate a chart in Excel. Ideal skills for this project would include extensive experience with automation, proficiency in Excel, and understanding of level sensor operations. Knowledge of networking would be a plus....

...Users and User Roles a. Admin User have permission to create an another user. Page #1 can be used. b. View of Users and Assign Roles, Permission. Status, Last Login, Date Created/Updated/Deleted. 5 Logs - Admin to view the logs of all the users - like when they logged in , what actions they did for audit purpose. Just a view and search screen 1. Registration & Cancellation & View & Update 2. Configure Mail Communication email IDs. 3. Optional SMS functionality based on Company Radio or Yes/No selection. 4. Ensure all necessary fields from the initial idea to customer engagement are included. 5. Real time machine availability with color coding on calendar. Red: Busy - This time slot is unavailable for meetings or appointments. Amber: Tentative - Th...

...little hearing loss Key responsibilities will involve: -Building SMARTSHEET plans -- Linking to External data (i.e. Excel) that will be used in updating the SMARTSHEET plans. - Utilizing SMARTSHEET Functions: Proficient use of formulas and calculations is essential for this project. - Building Reports and Dashboards: Experience in creating comprehensive and visually appealing reports and dashboards is necessary. The primary goal for this project is to efficiently and accurately track the progress of different projects within the Smartsheet and create Dashboards for multiple audiences. Ideal candidates should have: - Expertise in Smartsheet - linking Smartsheet plans to external data - Linking Multiple Smartsheet project plans that share tassks - Proficiency in...

I am currently in need of a professional with deep expertise in website maintenance. My website requires not just routine maintenance but also significant improvements which include: - Content Updates: It is necessary to keep the website content fresh and relevant. - Security Updates: I have security measures in place relying on regular backups. However, a security update by an expert to further safeguard the website is needed. - Bug Fixes: The website has been experiencing loading error issues which urgently need to be addressed. - SEO Optimization: The visibility of my website on search engines needs to be improved. The professional I need should have ample experience in website maintenance, cybersecurity, and SEO optimization. Further, understanding the importance of keeping...

*** US CANDIDATES ON...background to manage various tasks. Key Responsibilities: - Budgeting: You'll be responsible for creating and monitoring budgets to ensure financial health. - Expense Tracking: Accurately log and keep track of expenses to maintain a clear financial picture. - Invoicing: Prepare and send invoices to vendors and clients in a timely manner. Your Experience: - Proficiency in Excel: Since I currently handle finance using Excel, it is essential that you are comfortable with this software. - Previous Finance Management: Experience in budgeting, expense tracking, and invoicing is a must. - Strong Communication: Being able to keep me updated and informed on financial matters is key. Please highlight your relevant experience and how you can support me in ...

I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.

I need a professional and engaging website that will effectively promote my brand to home owners looking to renovate or update their spaces. The purpose is not primarily commercial but to create awareness, build brand image and provide relevant information to the potential customer base. The website should be designed in such a way as to encourage the visitor to request for more information. -Skills and Experience Ideally, the freelancer should possess excellent skills in: * Web Design and Development * Information Architecture * Effective Brand Promotion techniques * User Experience design * Everything Squarespace An understanding of what appeals to the public and the ability to creatively conceptualize that into the website layout design will be invaluable. The capability to c...

I'm looking for an expert in Excel to build a comprehensive 'Team Scorecard' for my team. This sheet will be used to track a range of tasks and behaviors to ensure the team is performing at their best. Key Features: - The project involves tracking various tasks and behaviors including daily reports, client communication, social media postings, timekeeping, invoicing, and meeting attendance. - I need the sheet to calculate total and average points automatically. This will be based on the tasks completed and the quality of those tasks. - It should also include conditional formatting to highlight outstanding performances. This will help us recognize and reward exceptional work. - Data validation is important to ensure accuracy and consistency in point entries. ...

...deploying and managing applications on a Kubernetes cluster. Key project details: - **Deployment & Management**: Your main focus will be on assisting with deploying applications on Kubernetes and ensuring smooth management of these applications. - **Scalability**: Although the scale of the project is relatively small, it's crucial that the setup is scalable to accommodate future growth. - **Update Handling**: The applications will require manual updates with specific scheduling. You'll need to ensure that the process is seamless and can be executed efficiently. Ideal skills and experience: - Proficiency in Google Cloud Platform (GCP) DevOps - Deep understanding of Kubernetes and hands-on experience in deploying applications - Experience in manual updates and sc...

I'm in need of an experienced sales agent who will work as a representative for my travel consulting services, focusing on individual clients. Key Responsibilities: - Promoting and selling my consulting services - Establishing new relationships with indiv...for my travel consulting services, focusing on individual clients. Key Responsibilities: - Promoting and selling my consulting services - Establishing new relationships with individual clients - Providing expert advice on travel solutions You're a great fit if you: - From Taiwan - Have prior experience in sales, especially in the field of consulting - Understand the travel solutions market - Excel at building customer relationships over diverse clientele. I look forward to boosting my travel consultancy service s...

Run tasks repeatedly to upload products file to Amazon.

...create a Network Management System (NMS) website that can be deployed on any cloud or local hosting. Main Functionalities: 1. Loginpage login (create user/password in the backend) 2. Dashbord one - prints rows of a table (buttons to add/delete/update table rows) 3. Dashboard two will have 6 tables, each of the table entries will have few configurable(will be configured through pop up window) , stats, logs , status 4. One of the table could have a flow table just for read only 5. THere should be back end persistent DB which saves all the data 6. THere should be method to bring down this and powered back any time Acceptance criteria 1. NDA signing 2. Web page working conditions and exceptions taken care on AWS/ local machine 4. UI page design will ...

Please Sign Up or Login to see details.

All the requirements that are mentioned with red indications update logos and other minor issues. If any issue comes up based on these requirements I will take the responsibility.

I am looking for an experienced Scala developer to implement a specific functionality in a data processing environment. The aim is to process text data more efficiently. Key Requirements: - Deep knowledge of Scala and spark - Proven experience in data processing, notably with excel, json and text data - Ability to deliver clean and efficient code The ideal candidate should be able to show previous projects where they successfully implemented or improved similar functionalities.

...store. I have exported the data to an Excel CSV file which includes: - Product names and descriptions - Product images - Product prices - Product options and variants - Product skus Given the format, an Excel specialist with thorough experience in CSV file formatting would be particularly suited to this project. Experience with Shopify's product listing format will also be immensely valuable. The task at hand is to modify the CSV file accordingly so it's compatible with Shopify's import method. - Key Skills: Excel, CSV file formatting, Knowledge of Wix and Shopify's product data structure - Ideal Experience: Previous product data migration between CMS platforms I'm expecting an effectively structured and form...

I need an expert to conduct a color analysis on an apparel website. Your task involves studying product images and employing Adobe Illustrator's eye dropper tool to identify the hexcodes for each. Main objectives include: - Identifying hexcodes for main colors using Adobe Illustrator - Organizing the hexcodes by clothing type - Completing the provided Excel Sheet Your role is critical as the information will be utilized in color trend analysis for apparel. Therefore, a proven background in graphic design, color profiling, knowledge of Adobe Illustrator and an eye for fashion would be ideal. My budget for this project is 100 USD. Please, proficient users of the English language only for accurate communication.

...to make strategic improvements to my website. The project involves a mix of SEO tweaks and backend work to enhance user experience. Key Deliverables: SEO work will include (PDF can be provided): changing hreflang, changing url page names, adding meta descriptions, changing headings, replacing text, creating breadcrumbs, Schema Mark Up, adding image alt text, reviewing and removing excess code, update sitemap. Adding additoinal pages: Updating the main menu to add additional pages Creating additional pages Uploading text and images, which will be provided Ensure consistent layout across all pages Ideal Skills: - Proven experience with Webflow - Strong understanding of SEO best practices - Ability to implement and optimize meta tags, URLs, Hreflang, and headings - Experience wi...

...an online system to replace the use of Excel sheets for data storage and calculations. The system will need to have: - Data Entry and Storage: It should be able to handle both numerical and textual data effectively and efficiently. - Automated Calculations: The system should be designed to automatically handle basic calculations such as summations and subtractions. To ensure the system is user-friendly and can handle our basic data management needs, you must have a solid understanding of relational databases and be proficient in web application development. Experience in designing systems with automated calculations is a big plus. A keen eye for user experience and the ability to follow design guidelines is also appreciated. We have an example e...

...project details such as customer information, project specifications, deadlines, etc. 2. **Requisition to Store:** - Enable users to create requisitions for materials needed for a specific project. - Include details such as quantity, description, project reference, etc. 3. **Store Confirmation:** - Once the store receives the requisition, confirm the availability of requested items. - Update inventory levels accordingly. 4. **Stock Management:** - Implement a robust stock management system to track inventory levels of materials used for door manufacturing. - Include features such as adding new stock, updating quantities, tracking stock movements, etc. 5. **Requisition to Purchaser:** - If certain materials are not available in the inventory, allow users t...

Need to update isometric illustrations vector files colors to match the branding.

...persist until acknowledged Crafting a user-friendly web admin panel for app management Using cloud functions to create an HTTP endpoint for JSON data reception Developing a device management page, including adding devices, assigning properties, and linking them to client profiles Creating and managing client and user profiles, including assigning users to clients or groups In essence, the app should allow for the creation of client profiles with customizable fields. JSON data received from devices in alarm states should be stored in Firebase, linked to client profiles via device ID, and trigger alarm notifications on the user's app until acknowledged. To excel in this project, you should possess: Strong proficiency in Firebase and Flutterflow, along with clou...

I'm looking for a skilled and experienced developer to help update and optimize our existing app for our business. Contact Number 7999978O355 Key Goals: - Optimize the performance of our current app - Maintain its high standard of quality and usability Ideal Skills and Experience: - Proven experience in PHP and/or Android development - Ability to effectively optimize app performance - Understanding of business app requirements and best practices For this project, the primary focus will be on performance enhancement. This will require a diligent and detail-oriented approach to ensure that the app continues to work seamlessly for our customers. The successful candidate will not only have a strong technical background but also an ability to understand and work within an existi...