Real time excel python jobs

...system that allows users to engage with me directly for a fee. Payment Gateway: To facilitate secure transactions, the website should be integrated with Authorize.net. This will ensure a seamless and trustworthy payment process for users accessing the gated content. User Engagement: Although not the primary focus, I am also interested in a pay-to-chat functionality. This feature will enable real-time, interactive engagement with my followers in exchange for a fee. Ideal Skills & Experience: - Proficiency in developing gated content websites, preferably for adult content. - Experience in integrating and customizing payment gateways, particularly Authorize.net. - Familiarity with user-engagement tools such as pay-to-chat features. - Strong understanding of website se...

We are looking for a detail-oriented individual to transfer data from over 2000 estimates into an Excel workbook / pricing database. The estimates and the Excel workbook are already formatted, so the main task will be to accurately input the data. This job requires strong data entry skills and attention to detail. The ideal candidate should be proficient in using Excel and have a good understanding of spreadsheets. We are looking for someone who can complete this task efficiently and accurately within 2 weeks. This will be executed in milestones to ensure the task is completed accurately and thoroughly.

...and attendance tracking in a learning school. This will be a user-friendly, touchscreen-based solution, with no requirement for integration with existing systems or databases. Key Features: - Student Registration: The application should allow for the quick and easy registration of new students. - Student Check-In: A reliable and efficient check-in system for students. - Attendance Tracking: Real-time attendance monitoring and tracking. Key Requirements: - Proficiency in Windows-based application development. - Experience in creating user-friendly and touchscreen-compatible interfaces. - Prior experience with kiosk application development is a plus. - Understanding of student management systems in an educational setting is desirable. The ideal candidate should have a k...

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I have a Python script that I would like to turn into an executable file for Windows. This script needs to be reviewed and compiled so it can run efficiently. Additionally, the current tables in the script need to be fixed. The project also involves creating a GUI with multiple buttons for different actions. The ideal freelancer for this project should have: - Experience in Python scripting and GUI creation - Knowledge of compiling scripts into executable files for Windows - Strong attention to detail to identify and fix issues in the existing tables Please note that the GUI should be user-friendly and intuitive. Also, the compiled executable file should be able to run on a computer without the need for Python or any additional dependencies. Before you bid: Ans...

For my project, the primary objective is the seamless integration of automated payment processing via Cybersource into my existing systems. Features Required: • A functionality for real-time transaction monitoring • An Automated payment processing mechanism with Cybersource Specific Integration: The system should be designed to integrate specifically with an E-commerce platform. Although I've not explicitly mentioned which platform, bidders with a proficient experience working with major platforms like Shopify, WooCommerce, and Magento will be preferable. Ideal Skills: Potential freelancers should possess high-level expertise in payment processing, APi integrations, and e-commerce platforms. Familiarity with Cybersource will be an added advantage.

I'm looking for a proficient Python developer to create a Session Initiation Protocol (SIP) client for specific platforms. This client will cater to Windows and Linux operating systems. Key Requirements: * The core capability of the Python SIP client will be to facilitate audio calling. Therefore, the developer must focus primarily on this function. * For safety and security, a basic username and password system will suffice for user authentication. Ideal Skills & Experience: * Proficiency in Python language is mandatory. * Prior experience in developing communication applications, specifically in SIP, will be beneficial. * An in-depth understanding of user authentication using basic username and password systems is required. * Familiarity with Windows and ...

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...

I am seeking a skilled Swift iOS developer who can create an innovative, user-friendly application for managing driving routes via GIS .shp files. Key Features: 1. Import GIS .shp files and convert them into driving routes. 2. Incorporate a web portal feature to assign and track drivers. 3. Real-time updates on the progress of each route. The ideal freelancer for this project should have experience with Swift, iOS development, .shp file manipulation, and incorporating real-time updates into an app. The app also needs a mobile version for drivers to access their routes; therefore, experience with mobile app development is also desired. More specifications will be provided upon selection. Looking forward to a fruitful partnership.

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

...advertising opportunities. 3. Transaction system using a virtual currency 'Coins' along with a transaction fee model. 4. Withdrawal option for users to cash out their earnings. 5. Rating system for users to rate services after completion. 6. Package customization based on desired reach, allowing users to book influencers with a cumulative following of, for example, 100k. 7. API integration for real-time tracking of followers across different platforms. 8. Communication system for users to discuss and finalize details once a service is booked. 9. Task completion and feedback features for service validation and quality assurance. 10. Home Page: List all services with a filtering system. 11. A feature for influencers to set up detailed profiles, showcasing past coll...

I'm seeking a talented Python programmer with experience in Pytorch, specifically in the areas image segmentation. I will provide you with a specific dataset of images to work with, so you should be comfortable working with image data. Your primary tasks will be to: - Create an image segmentation model to partition images into meaningful regions. Ideal candidates for this project should have: - Strong proficiency in Python and Pytorch - Extensive experience in computer vision tasks, including object detection and image segmentation - Prior experience working with image datasets

I'm looking for a Selenium expert with strong experience in Python/Java to develop comprehensive and effective Selenium tests for our web application. Key Requirements: - Proficient in Python/Java: Ideal candidate should have a strong command on Python/Java programming language. - Selenium Expertise: Demonstrable experience in creating selenium tests for web applications. - Web Application Focus: Experience with testing web applications is a must. - CI/CD Understanding: While not required, familiarity with Continuous Integration/Continuous Deployment (CI/CD) pipelines would be a plus. - Attention to Detail: Ability to meticulously craft test cases and identify and report bugs is crucial. Your responsibilities will include: - Collaborating closely with our develo...

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I'm looking to transform a static sign into an interactive game. Users will be allowed to alter the sign's text by replacing the letter "O" with an image of their choice. Key Requirements: - Users should be able to upload an image (logo, face, picture) of their choice to replace the letter "O". - The modification should be done in real time, allowing users to see the change instantly. After tgey save, their file with the changed image will be autinatically displayed in a instagram grid, so people can see all the changes. The image they take away will have a watermark The main sign will have .LIVE added to Wellington, so it reads Wellington.LIVE. - The game should be simple and intuitive, suitable for all ages. Ideal Skills: - Proficiency in...

...Fluent in both written and spoken English Able to communicate effectively with clients and team members Comfortable conducting sales presentations and negotiations in English Please note that we will be conducting interviews to assess your English proficiency. During the interview process, you will be required to demonstrate your language skills through various exercises, such as: Engaging in real-time conversations with our hiring team Completing written tasks or assessments Presenting a mock sales pitch or product demonstration We are committed to building a team of highly skilled professionals who can communicate effectively with our international clients. As such, we will be verifying English proficiency throughout the hiring process to ensure that all candidates me...

I'm seeking a talented video production expert to create real-life staged videos, aimed at promoting my app to young adults aged 18-24. The content of these videos should showcase the app's features in a manner that generates brand awareness. The Ideal Candidate Will Have: - Proficiency in creating real-life staged videos - Prior experience in producing utility app promotion videos - An understanding of the interests and preferences of young adults The Focus of The Project: - Vibrant and engaging real-life staged videos that spotlight the app’s features - Create captivating content to drive brand awareness and entice our young target audience - 3-4 videos required, showcasing different features or aspects of our app Hey! We’re a company wh...

Please Sign Up or Login to see details.

I'm in need of a WordPress developer to work in an Ongoing plugin for my website that will allow users to customize real estate signage. Developers need to be available to work on Teamviewer as well as available to Join Zoom/gmeet/ freelance Call Sessions for discussion. Key Features: - The plugin should enable users to customize real estate signage, specifically for sale signs, for rent signs, and open house signs. - The plugin will be used to create and display these customized signage on the website. Ideally, I'm looking for a developer with experience in: - WordPress plugin development - UI/UX design and customization - Real estate website development - E-commerce functionalities - Knowledge of product customization The project will be an ongoing o...

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

...application with additional features crucial to its success. This includes a user registration/login system, real-time data analytics, and payment gateway integration. The app will also require seamless integration with specific game APIs such as live casino, betting, and potentially others. Key Requirements: - Development of a web-based color prediction application - Implementation of user registration/login system - Integration of real-time data analytics - Seamless payment gateway integration - Integration with live casino and betting game APIs - Potential for additional API integrations Ideal Skills: - Web development expertise (React.js, Node.js, etc.) - Strong experience with real-time data analytics - Proficiency in payment gateway int...

I am seeking an experienced Python Django developer to take care of the back-end work for a web application intended for specific industry professionals. The required functionalities include: - User authentication and registration: Candidates should have experience implementing secure user authentication and registration systems. - Database integration and management: We need someone with proficiency in integrating and managing databases, ensuring smooth operations for user data handling. - API Integration: Expert skills in API integration are required to establish seamless communication between applications. Your primary goal is to build a strong, reliable backend for our professional web app. We need an expert who can ensure excellent function and optimal performance. Looking fo...

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

...Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amounts: Report on outstanding customer balances. o Receipts: Report on customer receipts. o Sales and Payments Reports: Generate detailed reports on customer sales and payments. Compatibility • The dashboard must be accessible via: o Web browsers (Chrome, Firefox, Safari, Edge) o Mobile devices (responsive design for smartphones and tablets) Technology Stack • Backend: PHP, Python • Frontend: JavaScript (with frameworks like React, Angular, or Vue.js) • Database: MS SQL for existing data • Others: HTML, CSS for web design; libraries for data visualization (e.g., , D3.js) Ideal Skills and Experience • Backend Development: Proficiency in PHP ...

I'm currently in search of a Python developer with specific expertise in data insert and search in vector data based on keyword * custom logic which i will brief in DM Budget 6,000 INR Day - 1 Day Task

I'm seeking a TikTok sales specialist to help us make a dynamic entry into the platform. Despite already having a successful startup, we are newbies in the TikTok world, and so, I need som...products • Promote our products directly on TikTok Ideal candidate: • Proven experience in boosting e-commerce sales using TikTok • Excellent content creation skills • Strong understanding of TikTok algorithms and trends • Expertise in TikTok account management Your role will be instrumental in our successful debut on TikTok. It's an exciting opportunity to create something new and make a real impact. Please place your bid with relevant experiences. Your bid will be more strong if you provide any strategy that you wanna implement for our business. L...

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all informati...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and the othe...

...skilled developer who can create a robust web application using Vue.js and Laravel. This application is primarily aimed at business professionals and should incorporate real-time data analytics. Key skills and requirements: - Proficiency in Vue.js and Laravel - Previous experience building web applications - Understanding of real-time data analytics - Strong problem-solving abilities - Good communication skills, as there may be a need for clarifications on the project - Ability to deliver high-quality, scalable code Your main tasks will include: - Building a user-friendly and intuitive interface using Vue.js - Implementing real-time data analytics functionalities - Ensuring the application is secure and scalable - Collaborating with me to un...

...expert to design an effective Business plan offering memorandum for my real estate business. The document will be targeted towards investors and aim to provide a clear understanding of our business model and financial health. Key Requirements - Business plan -Vacation rental industry not a must - Proven experience in drafting offering memorandums and business plans, preferably within the real estate sector. - Strong understanding of financial data presentation, particularly income statements, cash flow statements, and balance sheets. - Ability to design a document that is engaging and convincing to potential investors. The perfect candidate will demonstrate impeccable attention to detail, a solid understanding of the real estate and investment sector, and exp...

I'm looking for a skilled Python developer with experience in Blender and Rhino to create a demo of Python integration with both softwares for the purpose of creating a low poly 3D car model. Key requirements: - Proficient in Python - Experience with Blender and Rhino - Understanding of 3D modeling principles - Ability to create low poly 3D models The main goal of this project is to demonstrate the feasibility of creating a low poly 3D car model using Python in both Blender and Rhino for visualization purposes. The model needs to be detailed enough to be recognizable as a car, but does not require high levels of realism or complexity. If you have a strong command of Python, experience with Blender and Rhino, and a solid understanding of 3D modeli...

I'm looking for a Python expert who can help me with a migration process. The migration process involves getting the website to load properly. Key Responsibilities: - Identify issues during the migration process. - view attached error log

...of the project. You must also be able to incorporate LSI keywords effectively to improve the SEO value of the article. We're looking for an experienced ChatGPT professional proficient in Python and familiar with LSI (Latent Semantic Indexing) keyword extraction techniques to create a top-ranking, SEO-optimized article for our website. The ideal candidate should have experience utilizing Visual Studio Code as the development environment and be skilled at integrating ChatGPT for content generation that is engaging and optimized for search engines. Key Requirements**: - Proven experience with ChatGPT, Python programming, and Visual Studio Code. - Ability to implement LSI Keyword Extraction techniques to identify relevant keywords to enhance the article's SEO. - K...

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not on...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

...in Chat GPT SEO writing - Proficient in keyword research - Skilled in content optimization - Proven history of achieving fast Google rankings - Ability to target 5-10 keywords for content optimization - Use Python - Use Ambitious LSI Keyword Extractor - Use Visual Studio Code - use all 3 together to create a solid article in ChatGPT Please include a detailed project proposal in your application outlining your strategy and approach. Feel free to include relevant past work. I'm looking forward to working with you. I looked at a Get Ranked 1st page in 24-hour Chat GPT plan using Python, Ambitious, and Visual Studio code and was looking for someone with the skill to carry it out and do a listing for the keyword " Security Camera Installation Fort Worth. " I ...

Our call center is looking for a remote Dutch speaker operator for a customer service job . 8 hours/day, Monday - Friday. Central Europe working hours. Inbound and email customer service for an online shop. Bid with your cheap cost per 10 hours. Please write a couple of line of your self or better send a CV. Thank you

...Need complete month of resources availability for this project to fix ongoing issues and make new development I am looking to build a robust dispatching platform and need a team of skilled professionals to facilitate this process. Additionally, I need assistance to resolve customer-reported issues and add some enhancements to the platform. Key Features Required: - Real-time tracking: I need the platform to display real-time tracking information of assigned tasks. - Route optimization: An essential feature would be efficient route optimization for our tasks. - Customer notifications: I need a system that can send automated notifications to our customers. Roles required: - 1 Front-end developer: The ideal candidate should be adept at building user-friendly...

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attention to d...

I'm seeking a skilled developer to create a form for my WordPress site that allows users to add a variety of colors. This form will need to be designed to match the provided example. - User Interaction: When a user adds or subtracts a color, the form should update in real-time and count up the number of colors selected. The user should be able to see a preview of the selected colors. Furthermore, the form should dynamically adjust the color options based on the user's selections. - Data Handling: The form should send me an email with the final count and types of colors selected. - Layout and Design: It is crucial that the form matches the design of the provided image. Ideal applicants should have: - Extensive experience developing custom forms for WordPress - Prof...

I'm aiming to increase the local following on both my Facebook and Instagram accounts. The ideal number of new followers I'm targeting is between 1,000 to 5,000. Key Requirements: - Local Following: The focus is on attracting followers from a specific region or city, making it crucial for the growth to be locally targeted. - Quanti...account's following by 1,000 to 5,000 followers. Ideal Experience/Skills: - Proven Experience: Must have a solid track record of growing followers on both Facebook and Instagram. - Targeted Growth: Expertise in attracting followers based on a specific location. - Quantity Delivery: Capable of providing a significant number of followers within the desired range. - Organic Growth: Ability to generate real, organic followers and not throu...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report even i...

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Excel a...

I need a web scraping expert to gather data from the Maharera Maharashtra website. The data to be extracted includes agent names, their respective registration numbers, and contact details. The ideal candidate should: - Be proficient in web scraping techniques - Have prior experience in scraping data from government websites - Be able to deliver the project as soon as possi...Maharera Maharashtra website. The data to be extracted includes agent names, their respective registration numbers, and contact details. The ideal candidate should: - Be proficient in web scraping techniques - Have prior experience in scraping data from government websites - Be able to deliver the project as soon as possible As I need this information urgently, I'm looking to have this done as a one-time...

We have a group of accounts pertaining to vacation rental buildings. I'm searching for a social media expert who can focus primarily on Instagram and tiktok, generating reels. We could use stock videos from mexico city. We would provide the copies and visual inspiration for the videos. We need to generate 2 videos weekly for each of the 4 accounts. This offer is month by month payments

I am in search of an expert in the integration of RPLIDAR with Raspberry Pi for the purpose of navigation and obstacle avoidance in a medium-sized environment like an office building. More specifically, the freelancer is required to: - Program the Raspberry Pi to operate the RPLIDAR. - Create an algorithm or a method that can take in real-time data from the RPLIDAR and efficiently convert it into a visual, real-time map. - Use the mapped data for navigation and obstacle avoidance by the Raspberry Pi. Ideal Skills and Experience: - Proficiency in working with Raspberry Pi. - Experience in programming RPLIDAR. - Good working knowledge of obstacle avoidance algorithms. - Proven experience in navigation systems, particularly in indoor environments like offices.

I am in need of a proficient developer with experience in Android and camera driver development. The project goal is to create a camera driver for Samsung A55 Android 14 that will broadc...A55 Android 14 that will broadcast a video stream from a PC via ffmpeg, RTMP, or NDI. Key Functionalities: - The driver must be able to capture photos. - Record videos. - Adjust camera settings. - Have an internal driver for input on OTG (usb) video. Specific Requirements: - Must meet real-time video streaming requirements. Critical Experience & Skills: - Android development. - Camera driver development. - Understanding of ffmpeg, RTMP, or NDI streaming protocols. - Experience with OTG devices and real-time video streaming. Please provide your previous work samples r...

Develop a chatbot with a web chat interface using the Llama 2 7bn LLM model to assist users in resetting their passwords. The chatbot will interact with users to collect verification details (employee number, name, date of birth, boss's name, and last four digits of cell number) through a structured conversation. The system will validat...successful verification, a text message with the new password will be sent via an external API. The project will include creating APIs for future speech input/output integration, ensure response times under 1.5 seconds, handle multiple simultaneous users with unique identifiers, and provide customizable response messages. The system will be deployed on google cloud in a Docker container, written in Python, and include comprehensive logging and...

I have the information. I need someone to put it together in a book that we can have printed.

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and meticulousness a...