Hiring someone perth wa for doing excel spread sheet jobs

I need an experienced Virtual Assistant to handle daily data processing tasks in Excel 2019. Ideal Skills and Experience: - Proficient in Excel 2019 - Strong data entry, data cleaning, and data analysis skills - Prior experience in a similar role - Ability to work in a timely manner Tasks: - Daily data entry: You'll be required to input new data into the Excel spreadsheet. - Data Cleaning: Ensuring data is free of errors or duplicates. - Data Analysis: Performing necessary analysis on data entered. The ideal candidate will be detail-oriented, have excellent communication skills, and be able to work independently.

I’m seeking a seasoned Excel macro expert with an efficient approach to task automation specifically for performing calculations. Key Requirements: - Expert-developed Excel macros that automate repetitive tasks, making my workload more manageable. - The macros created should focus on performing calculations, thus, speed and precision are of the essence. - Due to the nature of the project, potential contractors must understand Excel inside out, especially on how to configure and troubleshoot macros. No specific type of calculation was specified, therefore experience with a wide range of calculations from basic arithmetic to complex equations is integral. Your problem-solving skill will be a plus point as the ability to understand and improve current ...

Create a consolidated financial statement for a transportation sector group. The tasks include: - Translating and reclassifying financial statements from Italian and Romanian to English. - Aggregating financial statements from various group companies to form a single consolidated financial statement. - Paying particular attention to intercompany transactions, as 98% of the branch's revenue comes from the mother company. - Ensuring that intercompany transactions are correctly accounted for in the appropriate fiscal years. - Carefully handling different currencies (RON and EUR) present within the branch. - Producing the final result in English, using Euros as the currency, and in Excel format with notes on intercompany transactions regularized in the correct fiscal...

I'm looking for someone to help me organize and input my personal finance data into an Excel sheet. The Excel sheet is intended to be a combination of both summary and itemized details. This means that your work will involve both categorizing transactions, and summarizing them by month or year. This project requires a good understanding of personal finance, as well as data entry experience. The ideal candidate should be able to work with sensitive financial information and must be able to keep this data confidential. If you have experience in personal finance or accounting, and can handle this kind of detailed data entry, I'd love to hear from you.

I'm looking for assistance with a large data entry project. The task primarily involves inputting text and numeric data into an Excel spreadsheet. Key tasks include: - Data Entry: You would be required to input data across multiple columns and rows. This data consists of a mix of text and numbers. - Basic Arithmetic: In addition to the data entry, I will need some basic calculations added to the spreadsheet. This includes performing simple arithmetic like sum and average calculations across different columns. Ideal skills: - Proficient in Excel: You should have a strong understanding of Excel functions and formulas. - Attention to Detail: As this is a large dataset, precision and accuracy in data entry is key. - Basic Arithmetic: Familiarity with common ...

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.

Seeking talented kid singers, aged between 8-12 years old, for an animated song in ENGLISH promoting unity and support for children in war zones. Specific roles include A GIRL lead singer, A BOY lead singer, AND A CHORUS. This exciting project requires natural, gifted singers with a great ear for music, and ideally previous experience or comfort in a recording studio setting. Requirements: - Singing experience preferred. - Ability to convey emotion through vocals. - Access to recording equipment/studio. - Able to take direction well - Remote collaboration and adherence to timelines required. Details: - Professionally composed melody and track available. - Selected singers will record vocals over the track. - Final product: animated music video spreading hope to war-...

I'm in search of a talented project manager to oversee the development of a m...will appreciate your guidance on this decision. Your role will encompass guidance on the hiring of a developer that meets my needs, as well as guidance of the developer and me throughout the project. Your goal is to ensure the project stays on track, meets deadlines and remains within budget. An ideal candidate would have: - Proven experience in managing mobile app development projects - Strong communication and organizational skills - A keen eye for detail and quality assurance, to ensure the MVP is user-friendly and represents our target audience well. - Previous experience developing mobile apps Please provide examples of previous projects you've managed, with a focus on mobile a...

Hi there. I need a quick page created (for iOS in Swift) that displays one letter from the Alphabet at a time with next and previous buttons that move through the rest of the Alphabet (which can be hard coded). I also need a specific function made in the 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...

I am reaching out to ...around 3-4 positions to fill each month. We are seeking a reliable recruitment partner who can assist us in sourcing and hiring candidates across various channels. Your role would involve leveraging your access to different sources to identify and recruit suitable candidates for our clients' vacancies. In return for your recruitment services, we are prepared to offer a competitive compensation package of 25% of the monthly salary of each successfully placed candidate. We believe that establishing a collaborative partnership could greatly benefit both parties involved. Your expertise in recruitment coupled with our client base and requirements can lead to fruitful outcomes for all. If you are interested in exploring this opportuni...

I'm looking for a professional to help me launch a YouTube channel dedicated to sharing my ministry's sermons and teachings. I need full video production and editing assistance in order to make this happen. Key tasks include: - Collaborating on content creation: I need someone who can work alongside me to ensure the content we're producing is engaging and relevant. - Daily video production: I'm aiming to post a new video every day, so the capacity and availability to turn around content quickly is crucial. - Editing: The videos need to be polished and professional. This involves not only basic editing but also adding engaging visuals and any necessary graphics to make the content stand out. - Adding text: Helping me add subtitles to the videos, f...

As a director, I am in need of a highly...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 eager to find t...

...website and are hiring a front end dev to craft pages based on html / css / js so we can give to our backend dev to built out the project. We will use place holder images that we will have re designed but for now just go with that. We are building a new case battles website called case gone wild () and the two websites want you to use for our project is : 1 - 2- Our colours will be dark themed and the cases will be based on games such as 1- csgo and csgo2 2- Fortnite 3- cod This Project is paid per page and we want the following pages designed: 1- new homepage 2- battle lobby page 3- example battle page (4 player placement) and we want the items to be made as an editable animation that we can use for live battles Total budget for this ...

Greetings! Hope you are doing well. As per our discussion, I would kindly request you to set an assessment, regarding the candidature for QA role, with a final price of $15. Please send the instructions and details with the assessment link. Hoping to hear from you soon. Thanks!

I'm looking to capture the essence of Berlin in a grunge-style photoshoot for personal use Preferably: - shoot in 2-4 locations around the city, maybe train stations or cool graffiti spots. I provided some inspo pics for what I want the pics to be like, the shoot is not meant to be serious, primarly just to capture myself in a city I’ve lived in for a few years before I leave ! :) I’d prefer someone with experience doing portrait photography, but honestly I’m up for experimentation

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, including the interpretation and manipulation of complex datasets. -...

...operating system and Apache web server. The primary task is to configure and implement a Letsencrypt SSL certificate. Key Project Deliverables: - Install and configure Letsencrypt SSL certificate on my Linux server running Apache - Implement automatic renewal for the Letsencrypt certificate - Provide guidance on manual renewal of the certificate in documentation - document on how you installed as well Note: see attached screenshot on what we did to try to install. It shows SSL is there when you go to browser and access SSL. However, when doing payment with Stripe I get error of invalid SSL. Would be good to know why. Ideal Skills and Experience: - Strong background in Linux system administration - Proficiency in configuring and managing Apache web server - Prior exper...

Hello Binder. I have a batch of 27 photos to retouch. Would you be interested in doing them for 215$?

I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link

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 ...

...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 analyze the extracted data - Develop...

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.

...The objective of the case is to increase EBITDA margin . The P&L statement, Balance sheet and Cash flow statement will be given along with more information to prepare forecast and analysis. It will require to use necessary assumptions to solve the objective of the case. Case will be required to be completed by 12th May, Sunday, Time : 11 AM London Time (GMT +1) Key Requirements: - Industry Knowledge: A deep understanding of the retail sector and its financial intricacies is essential. - Advanced Expertise: I require a finance professional with advanced skills in financial statement analysis. - Critical Thinking: The ability to think critically and provide insightful financial perspectives is crucial for this task. Please provide a brief explanation of your releva...

I'm in need of an expert to design a site plan for a Level 2 EV chargers. Key Requirements: - Analyze existing property blueprints and create ev charger plan with load balancing for 20 chargers. - Ev charger plan must include: Cover Sheet, site plan, electrical site plan, parking layout and details, single line diagram, schedules and Notes and T24 compliance forms. Experience: - Experience in EV charging station design. - Experience in load balancing for multiple chargers

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.

...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 nee...

...design, as well as content improvement of a completely new CV from scratch. This new CV should be specifically tailored to highlight my skills and experience for management roles. Key aspects I am looking for are: - A clear, professional layout that meets standard formatting expectations for management roles. - Strong, compelling content that effectively showcases my achievements and capabilities. Content should be powerful yet succinct. - Solid understanding of what hiring managers in the management sector are looking for in potential candidates. In an ideal world, the freelancer should have strong experience in developing CVs for clients targeting management roles. A proven track record in creating successful CVs that demonstrate a clear a...

...information I will be querying could be spread across a range of resources. - The queries the bot will be handling will be full-text. This means the bot should be able to understand and respond to complex, multi-sentence questions, and not just simple keyword-based ones. Ideal Skills and Experience: - Experience in developing chatbots and familiarity with ChatGPT. - Proficiency in creating and implementing systems for data retrieval from PDF documents. - A strong understanding of natural language processing and the ability to create systems capable of understanding and generating complex, full-text responses. I need the bot to be able to provide accurate and relevant responses, so it's important that the freelancer who works on this project has a keen eye for...

...software developer to create a robust recruitment agency software with advanced features. Key Features: - Candidate tracking: The software needs to efficiently manage candidate profiles, applications, and communication. - Job posting: A user-friendly interface for posting job listings, including editing and removing listings as needed. - Resume parsing: Ability to automatically parse and extract key information from resumes to streamline the recruitment process. - ATS: Incorporation of an Applicant Tracking System (ATS) to manage the hiring process from initial application to final placement. Platform and Integration: - The primary platform is desktop, so experience with desktop application development is essential. - While I haven't specified integration needs, exp...

I have a level sensor which is currently sending data to a local Wi-Fi network, accessible through a web brows...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...

...need a smart attendance system for College Student , main focus is Attendance on Different subject like DBMS , PYTHON , JAVA , Etc which utilizes facial recognition technology. Like I want to take Attendance for all the subjects, so in take attendance there should be a option or drop down for the list of Subjects You want take the Attendance Key Elements: - On the main page/home page I need user to register with there Name, Id ,Phone number - And then a Button to take attendance on different subjects using Facial Recognition , in which there should be a option or drop down for the list of subjects - And one main Feature is to show a Pie chart which represents how many students has attended DBMS class , Python class etc - Attendance should be saved in XL...

...authentication and authorization systems. - Knowledge of implementing role-based access control. 1 Registration Screen for Admin & User UserID Password Confirm Password FirstName MiddleName LastName Email Phone Sex Company Date Created Date Updated 2 Forgot Password Email 3 Change Password Old Pass New Pass Confirm Pass 4 Admin Dashboard Screen to manage 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 & Can...

...project plans. I want to work with expert on a shared screen to help me to learn as we go. I need someone fluent in English - I have a 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 hav...

I'm searching for an experienced accountant with a strong understanding of Generally Accepted Accounting Principles (GAAP). The ideal candidate should be able to: - Prepare financial statements including Income statement, Balance sheet, and Cash flow statement. - Produce Auditor reports. - Work on an annual reporting period. Demonstrated experience in stock broking related accounting would be highly beneficial. Efficient, accurate, and dependable individuals, please apply.

*** US CANDIDATES ONLY *** I'm seeking a virtual assistant with a strong finance 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. P...

I'm in need of a skilled video shooter to create a short promotional video for our hospital. Person must be from Delhi. The purpose of this video is to engage our audience and communicate the essence of our hospital. I am looking for an engaging, high quality video resolution.

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'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 consisten...

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 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 sales with your help!

Please Sign Up or Login to see details.

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.

I need an expert to conduct a color analysis on an apparel website. Your task involves studying product images a...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...

...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 excel sheet...

Urgently required: a skilled WordPress developer proficient in theme customization and plugin development, who can help improve website optimization. Key Duties: - Customizing my existing theme based on specific requirements which will be given after hiring - Developing a custom plugin with a core functionality of e-commerce integration - Working on website optimization to provide a seamless user experience Desired Skills and Experience: - Sound knowledge of WordPress framework - Expertise in PHP and JavaScript for customizing themes - Experience in developing complex WordPress plugins - Familiarity with implementing e-commerce elements into plugins - Experience in website optimization This project demands full dedication and efficiency. A portfolio of previous WordPres...

...and a history log Ensuring alarms 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 ...

...if short-listed we'd conduct a short phone interview. We're looking for assistance in fashion curation, to curate outfits from brands like Shein and Fashion Nova. You’d create themed outfits for men, and women (including plus size), and contribute to our weekly publication. You should have a keen eye for trends, outfit color matching, and the ability to work independently. An example task would be where you’ll be given a headline (Island Chic: 15 Budget-Friendly Tropical Spring Trends) and a fashion brief detailing the desired vision, objectives, and brands for the Curation project. In short - You'll read the brief and based on the headline and details you will copy and paste links, sizes, and pricing (into a Google sheet)...

In need of a skilled developer who can streamline my website's flow by integrating the HTML form into Google Sheets. Key Details: - The form details to be moved to the Google sheet include the user's name, email, phone number, and message. - The trigger for this integration is when the form is submitted. Understanding of form submission handling and triggers is a must. - There are no specifics on how the data should be organized in the Google Sheet, but after the form submission, it needs to redirect to a ' Custom Thank You' page. Experience with redirecting and website navigation is desired. Note: you need to do the project sharing my screen My project budget is $5 My website where the form is installed:

I require a professional web scraper to collect both text (data points) and images from a long list of web pages about hotels and destinations. - The project involves sa...points) and images from a long list of web pages about hotels and destinations. - The project involves saving the actual images of destinations/hotels —not just their URLs—from every webpage. - As for the text content, I'm particularly interested in several points - The extracted data and saved images should be meticulously organized in an Excel sheet for easy review and reference. Ideally, I'm seeking someone with an extensive background in web scraping and data extraction. Being proficient in Excel would be a significant plus. Accuracy, attention to ...

I'm searching for a skilled web developer to create an exceptional attendance system. Duty based attendance, For a given date and for a given duty you will be having only one employee working We should be able to add new duties. For given day you will be having fixed duties….we fill employee names into those duties….there will be some optional duties….we might assign it or not. Kitchen duties assignment form, and restaurant duties assignment form…..word formats of these forms are attached. Duty type – full or half Employee table – name, role, salary type, salary, and other personal details, Based on the duties assignment we should calculate summary reports…head count reports…..cost incurred report&hell...

I need a sophisticated Excel spreadsheet designed and developed for tracking key performance aspects of my dumper truck and excavator rental company. The spreadsheet needs to be well-organized, easy to navigate, and detail-oriented, focusing on the following elements: - Expenses: Detailed tracking of an array of expenses. The ability to enter itemized costs is a must, and other daily expenses (office, car fuel..). Also monthly expenses like rent, salaries, bonuses and truck or excavator maintenance ect. - Income: This should include a breakdown of different revenue sources. - Employee tracking: A system to input and manage each employee's work hours. - Machine rental: Documentation of the equipment rented, including the duration of rental. - Fuel consumption: Dedicated...