Excel combine rows with same value jobs
I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the project further.
I require a professional freelancer with expertise in graphic design to create a custom label for my candles. The design should reflect a modern aesthetic. The key elements to include in the design are: - A unique logo that effectively represents the brand - Detailed product information - Artistic illustrations that enhance the overall aesthetics of the label - An inspiring affirmation to engage the end customer The ideal freelancer for this task will have a strong portfolio showcasing their ability to combine these elements into a coherent and visually compelling label design. A background in packaging design or prior experience in creating candle labels will be considered a major advantage. A keen attention to detail and a creative flair are essential for success in this...
Hello our company has built an online open banking payment gateway. I need people that have Lloyds, HSBC, NatWest, Barclays, Standard bank accounts. I will create a link for you with 12GBP value , i would like you to record a video of the full procedure while you are paying it and what difficulties and describe what difficulties did you face. You will get paid 25GBP for your work , (12 of your payment + 13 for your 3 precius minutes)
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights should guide our strategies in terms ...
...document with those who are shortlisted for this project. You must mention "Dell" in the proposal in order to be noticed. Here is a brief for List of Features. 1. Invoice Currency Conversion using API and storing conversion rate in the database with date 2. Storing invoice value in base currency that is calculated based on conversion rate in the database so the total revenue is correct. 3. Invoice Custom Field Behavior changing, width of dropdown, custom field value and description 4. Invoice Total in Words in Customer Currency and Base Currency 5. Testing possibility to integrate Amazon S3 for file storage on Perfex CRM 6. Project Overview Screen, Task Details, Billing Calculations Customization. 7. Notifications Screen Customization for M...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
I want you create similar logo , to the attached one . More modern and clean Design: Combine the runes Fehu and Sowilo in a stylized lighthouse design. could be designed so that the structure itself takes the shape of the Fehu rune, while the light of the lhouse represents the Sowilo rune. • Colors: Use blue and gray tones for the lighthouse to symbolize professionalism and trust, with a bold yellow or gold for the light, radiating warmth and success. • Font: Choose a modern, clear font for the company name, placed below or beside the company
I am starting a new business selling cards with qr codes. I want to create a web app with following functionality would it be possible, 1. Landing page where public can view my products. To buy them they must sign up and fill out their details along with customisation to the physical card. physical card contains a qr code which will not change so i want it to be a redirect site so that user can change the link which the card points to. Something along the lines of this site kzilla.xyz. i don't need the front end just need the functionality of customisation of the link. Its open source so you can refer their github repo. When anyone scans the qr code on the card they would be taken to a page where it says a thank you for using this card you will be redirected ...
...– Project oriented This project is ideal for students and entry-level professionals. Involves assisting with product photography and videography for my new online store opening. If you have a knack for capturing stunning, unique images and are ready to bring your creative flair to my product range, I want to hear from you! Responsibilities: • Assist in setting up photography scenes with limited props, a trip(s) to purchase necessary items will likely be involved. • Provide guidance on lighting techniques, photography methods, and tips to capture the best images of various products. • Photograph and video a range of products, predominantly jewelry and candles, with additional apparel, bags, and miscellaneous items....
I need a skilled cameraman equipped for studio-style shooting of a leadership and management course. Ideally, you have experience in educational or instructional video capture, with a strong understanding of the balance between value content and compelling presentation. Here's what I’m looking for: - Filming in a studio interview-style setting - Utilizing a 4K camera for a high definition recording - Equipped with professional audio equipment for clear & crisp sound - Able to provide lighting setups for interviews would be a plus You may need to assist with scene setup to ensure the final output encapsulates a professional and conducive learning environment. Knowledge of teleprompter operation is beneficial though not mandatory. Your ability to...
I am searching for a professional, capable of accessing and securing contact details of a policy advisor in the Prime Minister's Office. If you have extensive experience and sound connections within governmental institutions, your expertise would be of great value. Key responsibilities include: - Information gathering, particularly contact details - Networking within the Prime Minister's Office The ideal person for this job must have: - Proven experience in governmental networking and information gathering - Credible connections within the Prime Minister's Office - A track record that demonstrates discretion and professionalism Please note that this task requires strict confidentiality and adherence to all relevant laws and regulations.
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and in-depth anal...
I am looking for a talented and experienced claymation artist to design a unique, realistic, and engaging human-like character, primarily for entertainment purposes. Key Responsibilities: - Design and create a claymation character that mirrors human characteristics and features - Render the character in a realistic fashion, with attention to detail and accuracy - Should possess an exceptional creative flair, keeping the entertainment value high Ideal Candidate: - Proven expertise in claymation - Strong portfolio demonstrating a focus on realism and detailed work - Exceptional creativity and innovation - Experience in entertainment-centric projects would be favourable Looking forward to witnessing your unique vision for this project!
...on future performance. - Valuation: A comprehensive evaluation of the company's worth. - Business summary: A concise overview of the company's operations and key strengths. - Risks: Identification and analysis of potential risks the company faces. - Industry analysis: Understanding the company's position and performance in the context of its industry. - Reach format report with 10k words, charts and infographics. - Excel modeling and native file is part of the deliverable. Ideal candidate would have: - Proven track record in financial analysis - Strong understanding of financial principles and methodologies - Previous experience in company valuation - Ability to present findings in a clear, concise and actionable format - Attention to detail and high anal...
I'm in need of a proficient Pinescript coder with experience in TradingView platform. The project entails developing a trading strategy. This task aims to establish a system with basic simple rules, thus, previous exposure to similar projects is a plus. Fundamental skills required include: - Proficient in TradingView Pinescript coding - Ability to create simple, straightforward scripts As the selected freelancer, you'll be expected to produce a script with a user-friendly interface that works flawlessly on the TradingView platform and setup the stock indicators below the chart. I want the scan results calculated using a one hour period and one month time range to pinpoint when the PPO line is about to cross or has just crossed the PPO signal line and the +...
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
I am looking for a skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behind in My e...
...(10%) Project Details: Project Description: We are seeking a skilled freelancer to assist with a project that involves in-depth research and document analysis. The project entails working on specific tasks outlined in the provided files and research documents. Project Phases: Step 1: The project will be divided into two steps. The first progress update is expected within 15 hours of commencement. This initial milestone should aim to have 80% of the work completed, as we are working towards a tight deadline. Requirements: Proficiency in research and document analysis. Ability to meet tight deadlines. Strong communication skills for progress updates. Deliverables: Progress update within 15 hours with 80% completion. Final project completion within the specified deadline. Ho...
...servers need to run AWS Linux, Java 21, node js 12, and datadog agent. We will start with 1 EC2 instance but as I said I want to be able to change that value and scale up (or down as needed). - The EC2 instances need to upload a config file for Datadog agent, part of this we need to supply the datadog api_key, which will be supplied in the command line via variables. The script needs to update that key in the datadog config file. - There are also a few directories which need to be created under /etc/datadog-agent/conf.d/ and files which need to be added into these. For the purpose of this create the directory /etc/datadog-agent/conf.d/mysql.d/ and add under it a file called . The file will be in the same directory as terraform script. - After configuring datadog...
I'm looking for a proficient sales representative to sell my services. Mandatory Skills: - Exceptional customer service - In-depth technical knowledge - Superior negotiation skills - Perfect English and Spanish is a must! Compensation Strategy: The chosen representative will be paid on an hourly basis. Experience in selling services is a must, as they will need to convincingly communicate the value of our offerings. The ideal candidate should be able and ready to handle client inquiries effectively and meet the sales objectives. You must be able to thrive in customer service, possess technical knowledge, and have leading negotiation skills. Your experience will reflect your understanding of client needs and help meet our business goals.
...This could include flow diagrams to show the movement of fluids through the diptube. Component Layout: Develop a layout of the individual components within the diptube assembly. This will help visualize how everything fits together and identify any potential issues with spacing or accessibility. Mechanical Drawings: Produce detailed drawings of each component, highlighting dimensions, tolerances, and material specifications. These drawings will serve as the basis for creating the 3D model in AutoCAD. Assembly Drawings: Combine the individual component drawings into assembly drawings that show how they come together to form the complete diptube structure. Prototype Blueprints: Translate the design into preliminary blueprints using AutoCAD. These blueprints should provid...
...from investors, businesses, and governments around the world. The value of Bitcoin has soared from mere cents to thousands of dollars per coin, making early adopters and investors incredibly wealthy in the process. Its decentralized nature and limited supply (capped at 21 million coins) have contributed to its status as a digital gold and a hedge against inflation and economic instability. Challenges and Criticisms Despite its widespread popularity, Bitcoin faces several challenges and criticisms. Its volatility and speculative nature have led to concerns about its suitability as a medium of exchange and store of value. Moreover, its decentralized nature has made it a target for regulatory scrutiny and government intervention, with some countries imposing restricti...
...from investors, businesses, and governments around the world. The value of Bitcoin has soared from mere cents to thousands of dollars per coin, making early adopters and investors incredibly wealthy in the process. Its decentralized nature and limited supply (capped at 21 million coins) have contributed to its status as a digital gold and a hedge against inflation and economic instability. Challenges and Criticisms Despite its widespread popularity, Bitcoin faces several challenges and criticisms. Its volatility and speculative nature have led to concerns about its suitability as a medium of exchange and store of value. Moreover, its decentralized nature has made it a target for regulatory scrutiny and government intervention, with some countries imposing restricti...
...Barcode for Tipping on the placard. This feature is designed to make the tipping process easier, which can be appealing to travelers who value efficiency and convenience. Overall, the wording of these placards should be compelling, concise and designed to resonate with the needs of business travelers. The goal is to increase their trust in our services and, in turn, boost direct bookings. I wanted to share something with you that's been on my mind lately. Unfortunately, I recently lost my job, and as a result, I've been relying on driving for Uber to make ends meet. However, I've found that Uber takes a significant portion of the earnings, leaving me with very little. So, I've been brainstorming ways to make the most of my rides and en...
...are mainly empathy. We share compassion, understanding, and care through our interactions with each customer and you need to share the same values and energy in your sales calls. We are looking for an experienced High ticket closer on a commission-based and a base salary. It will be a 12% commission on coaching programs of $7200 or higher commissions of %15 for a high closing rate above 25% We have a complete 12 months coaching and mentorship program and we already have a high ticket closer at the moment and we are looking to expand our team. All the leads come from a video sales letter that shows the value of our program and how it can shortcut their career to cybersecurity. I will provide you with the complete sales script, all the objection handling we...
We're seeking a talented 3D artist capable of producing captivating photorealistic renders and videos for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE ...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and fu...
As someone needing assistance with managing data in an Excel sheet, my ideal freelancer would be highly proficient in Excel and able to work accurately and efficiently. The role includes: - Adding new entries to the Excel sheet including the fields: Name, Email, and Phone number - Updating existing entries with the same data fields - Removing any outdated entries The data should be organized into separate columns for each field for straightforward visibility and access. Besides Excel work, this role involves effective email management related to this data. The ability to multitask while maintaining a sharp eye for detail will be vital for this project. Experience in data management and email handling will be advantageous.
As discussed in chat I am ready to make changes in exam result of students As you want some fixes and some new rows with student division and grades and averages and need to calculate whether the student is passed or not.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex data set...
...relationships with existing clients and ensure their ongoing satisfaction with our services. Recognize and reward individuals who refer new clients to our company. What We Offer: Global Transportation Solutions: We provide comprehensive transportation services, including sea freight, air freight, and road freight, catering to clients worldwide. Customs Clearance: Our team specializes in handling customs clearance procedures, ensuring seamless import and export processes for our clients. Documentation Services: We offer a full suite of import/export documentation services, streamlining the paperwork required for international shipments. Customs Bonded Warehouse: Benefit from our secure customs bonded warehouse facilities, providing a convenient storage solution for your go...
I need a skilled designer to create a versatile logo for my brand, which should combine text with a visually appealing icon. Additionally, I require a minimalist style website, with an included blog section. Key Requirements: - Create a unique and versatile logo design - Design a minimalist style website - Implement a user-friendly blog section -Develop visuals and generate content for social platforms, while overseeing marketing initiatives and trials. Ideal Skills: - Proficient in logo and web design - Experienced in creating minimalist aesthetics - Familiarity with user-friendly blog integration - Strong portfolio demonstrating past logo and website projects, particularly those with a minimalist style. - Strong proficiency in content writing and So...
I am in need of an experienced full stack developer who is well-versed in .NET and Angular to assist with the backend and frontend development of my project. Essential Tasks: - Involvement in both backend and frontend development processes - Providing valuable insights during project reviews Key Skills: - Strong competence in .NET and Angular - Proven experience in full stack development - A strong grasp of cloud technologies is advantageous - Excellent communication skills, as understanding and following project requirements are crucial Project Timeline: - There is no strict time frame for completion of this project. We value quality deliverability and careful attention to detail above speed. Ideally, you have a portfolio of previous projects to demonstrate your com...
As a website focusing on the fashion industry with a target audience of men, I am looking for a skilled and experienced professional who can assist me in building high-authority backlinks. Key Requirements: - Thematic Alignment: The backlinks must be from sites with a strong thematic alignment with the fashion industry. - Authority: The sites must be well-known brands or sites with high domain authority. - Audience: The backlinks should be placed in a way that would appeal to male readers and customers. Ideal Skills and Experience: - SEO Expertise: The candidate should have a strong understanding of SEO principles and the fashion industry. - Backlink Building: Experience in acquiring high-authority backlinks in the fashion or related industries. - Content Mar...
...Objective: Adjust program to upload and transmit attachments with .csv Deliverables: - Updated program with ability to transmit attachments in csv - Documentation of all changes with code (unrestricted) - Format attachments as: o Insurance-patient’s last name-patient’s first name o ID- patient’s last name-patient’s first name Attachments: The HTML, relevant Javascript and PHP script I did not include the balance of the program that is not relevant to this project Additional Information: If you require any further details or access to specific files or systems, please don't hesitate to ask. Deadline: I am looking to have this issue resolved within 3 days. Timing is critical Budget: Partial work or incomplete outcomes have no value...
I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the n...
...about adapting the scenes by recutting the image in which both people can be seen at the table so that - the person speaking is always shown and - the reaction of the interviewee is briefly shown in the case of special reactions The overall result is that these interview sequences should be prepared for YouTube Shorts/TikTok in a high quality, in which the conversation has a high entertainment value and the images are correspondingly attractive for the viewer. All 37 videos can be viewed in the attached YouTube list. To edit the videos, please use the original files, which I provide via WeTransfer 12.49GB. I also expect the videos back in HD. Please send the videos back to me via WeTransfer. Here are the rules for submitting the final files: - Only transfer the finished v...
I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the ...
Our office, based in Poland, is looking for an experienced AML compliance professio...team of 1-5 members. As our MLRO/AML checks officer, we are dedicated to: - Identifying and preventing money-laundering activities - Conducting thorough due diligence on clients and transactions - Ensuring compliance with various regulatory requirements We need support in the following areas: - Routine transaction monitoring - Preparation of regulatory reports - Risk assessments and audits Ideal candidates should have experience in the aforementioned areas, be detail-oriented, and have a strong understanding of the latest AML laws and regulations. We value team players who can work efficiently and effectively in a fast-paced environment. Polish language skills are desirable b...
I'm looking for a talented vid...enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling, even though I've not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, this could be a...
