Excel vba automate macro add ins일자리
...order! Are you a science journalist or scientist with a great idea still in the beginning stages? Or are you stuck closer to the finish line, unsure what you need to do to get your paper up to commercial or academic publishing standards? I can help! I am a widely published writer of nonfiction, journalism, and science research with a wide variety of publications under my belt. I especially excel in first-person investigative journalism, memoir and biography, mainstreaming science for press releases and articles, and polishing scientific papers pre-publication (especially mechanical engineering, biomedical engineering, Sports science, Ergonomics, Biomechanics). I can advise on a wide variety of styles from mass market to specialist publications and especially enjoy 'punc...
Ich benötige den Text meiner Website in Koreanisch und suche einen Koreanischen Muttersprachler, der mir diesen Text, der einige Fachausdrücke aus dem Klavierbau enthält, ins Koreanische übersetzt. Die Anzahl der Wörter ist 1496. Ich freue mich über eure Angebote. Danke! 내 웹 사이트의 텍스트가 한국어로되어 있어야하며 일부 피아노 용어가 들어있는 텍스트를 한국어로 번역하기 위해 한국어 원어민을 찾고 있습니다. 단어의 수는 1496입니다. 당신의 제안에 만족합니다. 감사합니다!
VBA 코드 구현 능력 (Excel Macro를 이용한 프로그램 개발 및 요건정의) 1) 데이터 수집/정리 유형 : 분석 데이터 수집/정리와 관련된 자동화 2) 데이터 분석 유형 : 데이터에 수식/로직 적용 관련된 자동화 3) 데이터 시각화 유형 : 분석 결과를 그래프 표현 관련된 자동화 4) 보고서 작성 유형 : 분석 결과로 요약/결과 보고서 작성 관련된 자동화
...directly (without scanning the QR code), an error message should display: “Invalid QR Code.” 3. Admin Panel and Reports • Admin will have access to a dashboard with the following features: • Generate QR codes for users/cashiers. • View feedback reports for all users or specific users. • Filter reports by: • Cashier/User ID • Rating (1-5 stars) • Date range • Export feedback data as a CSV or Excel file. 4. Submission and Data Handling • Upon submission, the following data should be saved: • Cashier/User ID • Rating (1-5 stars) • Comment • Phone number • Date and time • After submission, a completion page will display. 5. Security Features • Prevent users from returning...
I'm seeking an expert in antenna design, specifically with experience using PyAEDT software. I need a horn antenna primarily for radar systems, designed to operate within the Ku-band (12-18 GHz) frequency range, and with a linear polarization. Automate the geometry. Tune the result with different flare design configuration. Give a report for multifare design. Key Requirements: - Design of a horn antenna using PyAEDT and AEDT - Targeting the Ku-band 13.4-13.8 GHz - Linear polarization -Size 75x75x60 including flange - Multiflare configuration - Starting circular waveguide aperture is 8.1mm -Gain 20 dB -beamwdith 3dB +-45 @ 13.6 Ghz polarization Linear return loss less than -20 dB Ideal Skills: - Proficient in antenna design - Familiar with radar systems requirements - Exper...
...extracted URLs. Identify and report URLs returning 404 errors, redirects, or other HTTP issues. Provide the final report in a structured format (CSV or Excel) containing: URL HTTP Status Code Error Details (if applicable) Requirements: Proven experience with web crawling, sitemap parsing, and HTTP status checking. Proficiency in a scripting language like Python (preferred), PHP, or another suitable technology. Familiarity with tools and libraries such as requests, BeautifulSoup, or similar for parsing and requests. Ability to handle large sitemap files efficiently. Strong organizational skills and attention to detail. Deliverables: A CSV/Excel report listing all URLs with their respective HTTP status codes. Highlighted URLs that return 404 errors or other issues. Optio...
I'm in the process of constructing a Tableau dashboard to visualize Year-over-Year (YoY) growth on a monthly and yearly basis...constructing a Tableau dashboard to visualize Year-over-Year (YoY) growth on a monthly and yearly basis across various regions. The percent of YoY growth is to be derived from the same month of the previous year. Key Aspects: - Data Source: The dashboard will utilize data from Excel/CSV files. - Geographic Scope: Analysis will cover 1-5 regions. - Temporal Scope: The focus will be on the last 5 years. Ideal Skills: - Proficiency in Tableau is a must. - Strong background in data analysis and visualization. - Experience working with Excel/CSV files. - Understanding of YoY growth calculations. - Familiarity with interpreting data across different...
I need a professional web developer who can help integrate multiple ZOHO APIs with my existing WooCommerce website. The purpose of this project is to automate and streamline business processes by leveraging the capabilities of ZOHO. Ideal Skills and Experience: - Expertise in WooCommerce and ZOHO platform - Prior experience with ZOHO API integration - Proficient in PHP, JavaScript, and RESTful services - Knowledge of data synchronization and automation processes
I need a client space on my website for companies to manage their training. Each company will have personalized access to a dashboard with key KPIs, allowing the HR manag...Training Status to be Displayed: Scheduled training Ongoing training Completed training Cancelled or rescheduled training Document Management: Generate and download attendance sheets Issue training certificates Upload and access training materials Additional Requirements: Notifications (email or SMS) for scheduled sessions, cancellations, and rescheduling Export of data and reports in PDF or Excel formats Role-based access with strict data privacy (users can only see their own data) Scalable solution with technical support for deployment Please provide an estimate of the cost and timeline for this project. ...
I need a professional web developer who can help integrate multiple ZOHO APIs with my existing WooCommerce website. The purpose of this project is to automate and streamline business processes by leveraging the capabilities of ZOHO. Ideal Skills and Experience: - Expertise in WooCommerce and ZOHO platform - Prior experience with ZOHO API integration - Proficient in PHP, JavaScript, and RESTful services - Knowledge of data synchronization and automation processes
I'm looking for a freelancer who can meticulously extract a large mixed data (numerical and text) table from a statistical website and transfer it into Excel without missing any details. The ideal candidate should ensure that the data is formatted in Excel in the exact same way as it appears on the website. Skills and Experience: - Proficient in data extraction and Excel - Attention to detail to ensure no information is missed - Ability to format data in Excel as per the client's request
I am looking for an expert in Django, Python, and Google Sheets API to help automate some tasks. Key Requirements: - Task Automation: Primarily focusing on automating data processing tasks. - Data Transformation & Formatting: This will involve manipulating data into a suitable format for analysis. - Develop an automation script using Python - Utilize the Google Sheets API to synchronize data for our Django website Ideal Skills: - Proficient in Python - Extensive experience with the Google Sheets API - Strong background in automation and scripting - Understanding of data synchronization processes - Skill in Django is bonus Ideal Skills: - Proficiency in Django and Python: Essential for creating effective automatio...
I need a skilled Python programmer who can help in extracting table data from PDFs and converting it into an Excel file. The tables in the PDFs have varying structures, so your ability to handle different table layouts is essential. Key requirements: - Extract tables from multiple PDFs - Convert the data into a well-structured Excel file with 4 different formats across 2 sheets - Ensure the data is accurately represented as mixed data (both numeric and text) Ideal Skills: - Proficiency in Python, with experience in data manipulation using Pandas DataFrame - Excellent attention to detail for accurate data extraction and conversion - Prior experience in handling PDFs and Excel files With your expertise, I hope to streamline my data processing task and make it more ef...
I'm in need of a professional to install JitBIT on a cloud VM instance, write a moderately detailed document with screenshots explaining the usage of all its features, and create a shell script to automate these procedures. Ideal Skills: - Cloud VM instance installation - JitBIT software installation and configuration - Technical writing with a focus on clarity and detail - Shell scripting - Familiarity with creating documentation with screenshots Please note: - The cloud service provider and the operating system for the VM instance have not been decided yet, hence some flexibility is required. - The documentation should be of moderate detail with screenshots.
I'm seeking a seasoned Business Analyst with 3-6 years of experience, particularly in the retail sector. This remote, 3-month project entails developing and implementing brand marketing strategies to boost our brand visibility. Key Responsibilitie...case studies - Monitor and assess the impact of marketing initiatives - Analyze competitors' operations and identify their strengths and weaknesses. Desired Skills: - Strong analytical capabilities - Excellent marketing knowledge - Superb communication skills - A touch of sales experience. Ideal candidates will possess a BCA, MCA, B.E. or a relevant degree. Experience with tools like Microsoft Excel, Google Analytics, and Salesforce is a plus. Though not mandatory, a primary objective of enhancing brand recognition would be ...
I need assistance in entering mixed data, which is currently stored in digital files, into MS Word. Requirements: - Proficient in MS Word and data entry - Able to work with mixed data (text and numeric) - Experience handling digital files, particularly text files The data is sourced from various digital files including Excel, PDF and text files. Your role would primarily involve transcribing this into MS Word, so attention to detail and accuracy is crucial.
I need a freelancer to help with data scraping and organizing the information into an Excel file. The data source will be various databases. - Scope of Work: - Scraping email addresses and names/contact information from databases. - Organizing the data into an Excel file with separate columns for each data type. Ideal Skills: - Proficient in data scraping techniques. - Excel expertise, specifically in organizing and formatting data into separate columns. - Attention to detail to ensure data accuracy. - Previous experience with data scraping from databases is a plus.
I need a multi-purpose chassis designed for a heavy-duty construction vehicle primarily intended for excavation in mountainous terrains. The vehicle will face challenging conditions, so the chassis must excel in durability and flexibility. Key Requirements: - Design a chassis that can withstand tough, mountainous terrains while being able to adapt to different conditions and tasks. - The design should not prioritize being lightweight, but rather focus on durability and flexibility. - Previous experience in designing vehicle chassis, particularly for construction or heavy-duty vehicles, is highly desirable. Ideal Skills: - Mechanical Engineering - CAD Design - Experience with heavy-duty vehicle design - Knowledge of materials for durability - Creativity for flexible design
Project Title: Data Entry and Administrative Support Needed Project Description: Update a large database with accuracy and efficiency. Use Google Sheets and Excel for data entry and management. Ensure all data entries are accurate and error-free. Submit daily progress reports. Required Skills: Proven experience in data entry. Proficiency in Google Sheets and Microsoft Excel. Ability to complete tasks within deadlines and maintain accuracy. --- If your project is related to Sales & Marketing or Translation & Languages, you can modify it accordingly. Example: Project Title: Content Writing for Marketing Campaigns Project Description: Create engaging and customer-attractive content for a new product launch. Write short yet impactful copy for social med...
I am an eBay seller seeking assistance to enhance my Boost Space automation with Google Sheets. The primary goal is to streamline my shipping purchasing and automate my accounting updates while ensuring my data is properly formatted. Key Responsibilities: - Integrate Boost Space with Integromat and Google Sheets - Connect various shipping platforms, primarily eBay and possibly Pirate Ship - Update my spreadsheets with order numbers and formatting dates to a U.S. style date format Ideal Skills: - Proficient in Boost Space and eBay shipping processes - Extensive experience with Integromat and Google Sheets - Strong understanding of eBay and Pirate Ship integration - Excellent attention to detail for data formatting and accuracy Your expertise will help me significantly reduce manu...
Project Description: We require a robust and scalable Project Management System built on Microsoft Power Apps. The system should allow users to manage projects, tasks, risks, budgets, and reports efficiently. The application will integrate with Microsoft tools like SharePoint, Power Automate, and Teams for seamless collaboration and automation. Project Goals: Centralized management of projects, tasks, and related data. Improved collaboration among team members. Automation of workflows for task assignments, approvals, and notifications. Advanced reporting and analytics for project tracking and decision-making. Core Features: 1. Dashboard Overview of all projects. Visual status indicators (e.g., progress bars, charts). Quick filters (by priority, status, department). 2. Project Man...
I need assistance with data entry. The data is mixed (text and numbers) and is currently in Excel/CSV format. The primary purpose of this data entry task is to populate a database. Ideal candidate should be proficient with: - Excel/CSV - Data entry - Attention to detail Experience with database management and data handling is a plus.
Cur...incomplete information. ● Seamless Integration: Maintain and enhance existing integrations with Firebase, Twilio, and DigitalOcean, ensuring smooth interoperability with the new AI components. Goals and Objectives ● Enhance User Experience: Provide a more intuitive and engaging way for users to publish tenders, reducing the friction associated with traditional form-filling. ● Increase Efficiency: Automate data extraction and validation processes, minimizing manual errors and speeding up tender publication. ● Expand Accessibility: Support multiple languages and accents to cater to a broader user base, including non-English speakers. ● Improve Engagement: Utilize conversational AI to make interactions more natural and responsive, fostering higher user satisfaction and retention.
I’m looking to automate sending birthday promotion messages to a list of contacts via WhatsApp. Here’s what I need: What I Have: • An Excel sheet with nearly 2,000 contacts. o Each entry has: Name Contact number (with country code) Birthday date • I’ve also got 2 promotional images and a message I’d like to send. What I Need: 1. Send WhatsApp Messages (direct from excel) two images I provide. 2. Reusable for Future Months o For upcoming months, I want to just update the Excel sheet with new names, numbers, and birthdays, and then click something to send messages to the new list. 3. Extras I’d Like: o Skip duplicate numbers so no one gets spammed. o Log which messages were sent successfully and which weren’t...
I need a software developer to write a script for my website server which allows me to automate the use of my ASIC mining computers depending on the level of rooftop solar energy my house is generating. I essentially have all devices monitored & connected via various iot methods (rooftop solar monitoring, smart metre monitoring, smart plugs). I need you to automate the changes in power levels of my ASIC mining computers (can be changed easily via the Braiins OS), based on the power being generated by rooftop solar panels (solar monitored via Powersense monitor + also by inverter login/dashboard). I have illustrated the outline of what I require in a brief pdf document which I can send you. I also have more detailed plans for a small database/csv file 'fields requi...
Bullet Points: Copywriting Skills: I have extensive experience in writing articles, product descriptions, website copy, and other forms of content. SEO Copywriting: I am proficient in creating SEO-friendly content that helps improve search engine rankings. Engaging and Persuasive Writing: I excel in writing compelling content that connects with readers and enhances brand engagement. Client Communication: I understand client needs and can craft clear, persuasive copy tailored to their target audience. Portfolio Examples: I have a portfolio showcasing my work, including blog posts, website copy, and product descriptions. Full Description: I am a skilled copywriter with a passion for creating content that not only informs but also engages and motivates readers. With a strong background...
...are looking for a Python developer to help automate the extraction of data from screenshots. The project involves two key tasks: Screenshot Cropping Script: Develop a script to crop screenshots and isolate the relevant data sections, focusing on the area below the column headers. The cropping areas may vary slightly between different screenshots. OCR Data Extraction and Excel Conversion: Use OCR tools (like Tesseract) to extract text from the cropped images. Convert the extracted data into a structured format, and save it into an Excel file, with each piece of data placed into corresponding columns. Requirements: Proficiency in Python (Pillow, OpenCV, pytesseract). Experience with OCR for text extraction from images. Ability to work with Excel files using...
I need a freelancer to scrape product information from the Amazon website and deliver this data to me on a weekly basis. The data should be entered into a database. Ideal skills and experience for this job include: - Proficiency in web scraping tools and techniques - Experience with data entry into databases - Ability to automate the data collection process for efficiency
Looking to collaborate with someone to build a Mobile App Development.
We need an experienced data researcher with the following skills: 1) Experience in Internet Research 2) Good English skills 3) Knowledge of google sheets & excel 4) Attention to detail This is a long term project.
...and a complementary website that tracks whale movements in meme coins and trending tokens on platforms like Dex Screener. The Twitter page should function similarly to Whale Watch Alert () , providing real-time updates and insights into token activity. The website will serve as a centralized hub for further analytics and details. Responsibilities: 1. Develop and automate a Twitter page to track whale movements and token trends. 2. Integrate data from platforms like Dex Screener for real-time updates. 3. Design and build a website to complement the Twitter page, featuring additional analytics and tracking tools. 4. Ensure both the Twitter page and website are reliable, scalable, and user-friendly. 5. Collaborate to incorporate feedback and refine features. Skills
Excel Data Cleaning: Removing duplicates, errors, and inconsistencies for accurate analysis. Excel Data Formatting: Organizing data into a clear and professional layout. Excel Dashboards: Creating interactive and visually appealing dashboards for data visualization. Excel VBA: Automating repetitive tasks and creating custom macros to save time. Pivot Tables and Charts: Summarizing and visualizing large datasets effectively. Data Analysis: Performing advanced calculations and trend analysis for insights. Conditional Formatting: Highlighting important data with rules and color coding. Formulas and Functions: Using advanced formulas (e.g., VLOOKUP, INDEX-MATCH) for dynamic calculations. Data Validation: Ensuring data accuracy with dropdown lists and validati...
Add the word "keypad" to the existing blue and yellow 630am logo - same as you did offing "farm" a few months ago
I'm looking for an expert who can help me develop a Google add-on aimed at automating tasks in Google Docs. The primary functions of this add-on will include formatting text and creating multiple templates. Ideal Skills Include: - Proficiency in Google Apps Script - Prior experience in developing Google Workspace add-ons - Strong understanding of Google Docs functionalities - Excellent problem-solving skills - Ability to deliver on time and within budget
...seeking an experienced Power BI developer to create a comprehensive report for our sales and marketing data. The ideal candidate should have a strong background in data visualization and analysis, with a proven track record of delivering high-quality Power BI reports. **Project Requirements:** 1. **Data Integration:** - Integrate sales and marketing data from various sources (e.g., CRM, ERP, Excel files). - Ensure data accuracy and consistency. 2. **Report Design:** - Create visually appealing and interactive dashboards. - Include key metrics such as sales performance, marketing campaign effectiveness, customer segmentation, and ROI analysis. - Design reports that are easy to navigate and understand. 3. **Data Analysis:** - Perform in-depth analysis to identi...
I need a Word document transposed into an Excel file. Key Points: - The original document contains text only. - Text organization within the Excel file is not uniform. It varies and will need to be explained. Ideal Skills: - Proficient in Microsoft Excel and Word. - Good understanding of data transposition. - Detail-oriented to ensure accurate transfer of content.
I need a comprehensive Excel spreadsheet containing the top 5,000 accounts. The data should include: - Number of followers - Social handle - URL link The accounts should be ranked by the number of followers. The ideal freelancer for this project should have experience in api data collection and Excel, with a proven track record of working with social media data. Attention to detail is crucial, as is the ability to source information from reliable platforms. Please do not submit junk data, or data you have not reviewed yourself. Send an excel file or google sheet document link. Thanks
...network's efficiency. The perfect candidate will have: - Proven experience with Mighty Networks or similar platforms - Expertise in digital marketing, especially in ad creation and optimization - Strong communication skills for effective member engagement - Ability to manage administrative tasks with attention to detail I am excited to work with someone who is as passionate about helping others excel in their personal and professional lives as I am. Let's make this network a thriving community together!...
I need a freelancer to help me gather real estate property addresses from public companies' websi...addresses from public companies' websites. I will provide the list with 25 public companies with the URL to their properties. Save the list of properties for each public company in a separate Excel to avoid confusion. Please compile the data in a Microsoft Excel spreadsheet, and ensure to include the following fields for each property address: - Street Address - Address 2 (optional) - City - ZIP/Postal Code - Name (if applicable) - State - Country I will provide a sample template to help. Ideal skills and experience for this job include: - Proficiency in web research - Familiarity with Microsoft Excel - Attention to detail - Understanding of rea...
...Change the field “Nombre de la empresa (opcional)” to “DNI/RUC” and make it mandatory. • Reorder the address-related fields to follow this sequence: Departamento (Department), Provincia (Province), Distrito (District), Dirección completa (Full Address, with an example as a placeholder). A detailed Excel file with the list of departments, provinces, and districts in Peru will be provided. 2. Shipping configuration: • Adjust shipping rates based on the provided list of Peruvian locations in Excel. • For destinations within the Department of Lima and the Province of Lima: • Calculate shipping costs using the provided price table. • For destinations outside the Department of Lima and the Province of Lima: • Di...
...sheets linked by employee ID. - The summary and allocation detailed report should be in Excel format. - Total earnings is calculated as: Gross Benefit + Worker Compensation + Net Salary. Gross Benefit is the total of all benefits in the salary master file from columns R to AV, excluding Federal Income tax, California Amount, and California SDI. Option to add inclusion or exclusion without changing formula. - The bi-monthly payroll needs to be consolidated from two lines per employee to one line summary report. - Class allocation percentages should be sourced from the class columns E to VU in the class allocation sheet, and must total 100%. Ideal skills and experience for this job include: - Proficiency in Excel, especially in data analysis and manipulation. - Exp...
I'm looking for a software tool that can automate the changing of my MAC address on a Windows machine at regular intervals. The tool can have a graphical user interface (GUI), but it doesn't necessarily need to; either is acceptable. Key requirements: - Proficiency in Windows software development - Experience with network-related software tools - Ability to implement time-based automation features Please provide examples of similar projects you've completed.
hi if its possible we want programme Schneider HMISTO705 screen whit a automate zelios soft programme running this was a controle for energy 1 screen running data phase 1 XXX ampphase 2 XXX ampdélestage en cours ZONE 1 a 9 (green on RED OFF ) 2e screen ajust the max values in the automation for phase 1 and 2ajute time on and off 3e screen power history graph 4e an image of our current production 5 input 9 output they automat was programme in FDB a month would be my ideal but I can be patient I also want access to remodel in case of future modification password etc. the description is to give the general idea I am also open to other ideas for parameters I will also provide the basic fdb if you speak French it's a plus otherwise it does...
... Learn more about The Accommodation Show at: @theaccommodationshow What I'm Looking For: A clean, engaging edit of a single episode, using the existing basic edit as a starting point. Removal of unnecessary filler words (ums, ahs, etc.) to improve flow. Potential zoom-ins on the speaker to enhance engagement. No captions required for this round. If your edit stands out, you'll have the opportunity to take on ongoing work with steady projects and performance-based bonuses. Future Work & Pay Structure: I have a high volume of episodes and reels to produce, so I need to stay within budget while ensuring quality. Here's what I can offer: Podcast Episodes: Riverside
I need some expert guidance with Excel formulas for a cap table. The focus will be on equity allocation. I have created the excel file and entered the different rounds but I need help with some of the formulas. DO NOT RESPOND IF YOU DO NOT HAVE KNOWLEDGE OF HOW CAP TABLES AND DILUTION WORK. Key Requirements: - Formulas to effectively distribute equity among stakeholders - Representative display of shareholder names, number of shares held and percentage ownership Ideal Skills and Experience: - Strong proficiency in Excel, particularly with complex formulas - Experience with cap tables and understanding of equity allocation - Ability to present data in a clear and comprehensible manner
...managing leads, cases, and client services. • N8N Automation: An orchestration tool for workflow automation across all platforms. • SMS & Calling Tool: A communication solution for appointment scheduling and follow-ups. • Court Record Scraper: A data extraction tool for real-time public eviction record collection. 2. Workflow Steps Step 1: Court Records Scraping and Lead Generation Objective: Automate lead generation by scraping public court eviction records. Process: 1. Use a scraper to extract eviction case details (e.g., property address, landlord, case status). 2. Enrich extracted data by appending missing contact information (emails, phone numbers) via APIs. 3. Automatically upload leads to Ligna CRM using N8N. Output: Verified, enriched leads ready for fo...
I need a methodical and detail-oriented freelancer to assist with data entry from supplied aerial site ...images. Specific Tasks: - Using Google Maps to obtain GPS coordinates for 96 marked building locations on the aerial images. - Pasting these coordinates into a provided Excel spreadsheet template. - Manually verifying each entry to ensure accuracy. Automation is not an option for this task. Example provided for the Excel spreadsheet. Please note, only the GPS coordinates are required from Google Maps, with the building locations indicated by outlines on the aerial images. Ideal Skills: - Proficiency in using Google Maps - Excellent attention to detail - Ability to work methodically and systematically - Competency in Excel - Previous experience with similar dat...
I'm seeking an AI specialist to create an agent that drives my sales and marketing efforts across various social media platforms. Key Responsibilities: - Automate posts and handle paid advertisements on Facebook, Instagram, LinkedIn, Reddit, Telegram, Twitter/X, and YouTube. - Enhance social media engagement. - Utilize chatbots to engage prospects and convert them into registrations or sales. Ideal Skills: - Proficiency in AI and chatbot development. - Experience in social media management and paid advertising. - Strong understanding of sales and marketing strategies.
I'm seeking a dedicated freelancer to help gather data ( or share already researched data) on international students currently attending U.S. universities. The data should be comprehensive and cover a range of details about each student. Key Data Points Needed: - Student Fir...Master's) The ideal candidate will have: - Experience in data collection and research - Access to verified data - Ability to deliver in a clear and organized way Important Note: The home country of the student must not be the USA. I am open to data from any other region, and I will need this data regularly over the next few months. Delivery Format: The data should be delivered in a Spreadsheet (Excel/CSV). If you already have a database of this information, please let me know. Looking forward t...