Excel Jobs

I have a substantial Excel spreadsheet that requires competent attention. I'm on the lookout for someone who's proficient in: - Data entry - Data cleaning Your role will primarily involve entering various types of data that's currently on an Excel spreadsheet. Despite the data being available, it's in a raw unclean format that needs some cleaning. The ideal freelancer is someone who's used to working with Excel and recognizing inconsistencies, errors, and redundancies. Additionally, anyone versed in: - Proficient in Excel usage - Strong attention to detail - Experience in data cleaning - Strong data entry skills would be extremely helpful in achieving the goals of this project.

I need a proficient Excel specialist to develop a spreadsheet that will calculate gross pay based on clock in and clock out times. Some work-shifts will start on one calendar day and not clock out until the next calendar day (example- clock in May 1 at 3:30pm - clock out May 2 at 12:30am). It should also factor in specific overtime rules for the workplace, including: - Weekly overtime after 40 hours. -All hours on any given workday shall be paid at the straight time rate of pay unless forty (40) hours have already been worked at straight time. No matter the length of route: example- a driver's bid/scheduled route may be 10.8 hours, as long as the employee does not work any additional hours other than those bid/scheduled, they will be compensated at straight time rate of pay unless for...

I'm looking for a personal assistant to help with various online tasks, primarily data entry, research, and email management. Key Responsibilities: - Data Entry: This involves copying and pasting data, as well as cleaning and organizing it. Furthermore, I need assistance with data analysis and reporting. The ideal candidate should be comfortable with working in spreadsheets, and have a good eye for detail. - Research: The research tasks will include market research, competitor analysis, and product research. You should be able to gather and synthesize data from various sources to help me make informed decisions. A background in a related field is a plus. Skills: - Proficient in using spreadsheets - Strong attention to detail - Excellent research skills - Ability to work independ...

I'm in need of a meticulous professional to clean a mixed set of data contained in an Excel file. I am specifically struggling with duplicate values and missing entries. To effectively accomplish this: - You should possess excellent skills in data analysis and data management. - Previous experience with Excel-based data cleaning is preferable. - Profound knowledge of dealing with duplicate entries and filling in missing data is required. - A keen eye for detail and ability to spot and correct errors is essential. In summary, my ideal candidate would be someone with significant experience in data cleaning, particularly with mixed data in Excel files. It would be a bonus if you've previously resolved issues related to duplication and missing entries in datasets.

I have a set of handwritten notes with relevant numeric data that I need entering into an online database. The task involves transcribing the numerical information with a high degree of accuracy. Key Requirements: - Enter numeric data from handwritten notes into an online database - Ensure high accuracy in data entry - Abide by project deadlines - Maintain confidentiality of data Skills Required: - Proficiency in data entry - Attention to detail - Experience with online databases - Fast and efficient work ethic - Ability to maintain data confidentiality

I am in need of a detail-oriented individual to help with a data entry project. This involves manually entering alphabets into an Excel spreadsheet to create a comprehensive database. For this task, you should have: - Excellent attention to detail, as the entered alphabets should be strictly in lowercase. - Proficiency in Excel, as the data will be used to compile an Excel spreadsheet database. - Ability to work diligently on a potentially repetitive task. Your primary responsibility will be to manually input the alphabets into the spreadsheet with absolute accuracy. As it's vital that each data entry is correct, having strong attention to detail is paramount for this job. Experience in data entry and Excel is a must.

I have an Excel file that is corrupted and won't open. The latest version has over 5000 columns which I need retrieved. I have a previous version of the Excel file with over 4500 columns. The Excel file was last saved on a USB and I am using Excel 2016. I do have a backup copy of the corrupted file. Key Tasks: - Recover the latest version of the Excel file with over 5000 columns. - Integrate the data from the previous version (4500 columns) into the latest version. - Ensure all data is intact and functional. Skills and Experience: - Expertise in data recovery and Excel. - Proficiency in Excel 2016. - Attention to detail and thoroughness to ensure that all 5000+ columns of data are successfully retrieved and integrated. Please bid with a specific plan on how you will tackle this iss...

I'm urgently seeking someone with expertise in Microsoft Word and PowerPoint. As the core tasks involve: - Formatting documents: Revamping and structuring multiple existing ones with professional formatting. - Creating templates: Building clean, easy-to-navigate custom Word and PowerPoint templates for future use. - Designing presentations: Enhancing PowerPoint presentations with engaging design. Ideal professionals would be quick responders, experienced in advanced functionalities of Microsoft Office, and possess creative design skills to make presentations visually engaging. As the project needs to be completed ASAP, please apply only if you can commit to a fast-paced timeline.

I'm in need of someone to assist with creating daily/weekly journal entries in our Zoho Books accounting software. Key Responsibilities: - Record a Journal for each business day that summarizs the payment transactions of the day (cash, credit card, bank transfer etc) Ideal Candidate: - Proficient in Zoho Books software. - Strong understanding of basic accounting principles. - Experience with creating journal entries. - Reliable and able to deliver entries on a weekly basis.

I'm looking for a skilled individual who can create a pivot dashboard for my business. This dashboard needs to be updated daily and needs to include comprehensive sales data, material costs, labour costs, and profit and loss. Ideal Skills: - Data management - Ability to create and maintain pivot dashboards - An in-depth understanding of business financials. The main users of this dashboard will be the Management Team. Therefore, it needs to be designed in a user-friendly manner and should meet the needs of a strategic managerial perspective. The ultimate goal is to help us make more informed and data-driven decisions. Your expertise in data handling and visualization is much needed for this project. If you've created similar dashboards in the past, we would love to hear ab...

I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding of Excel func...

Hola, necesito de tu trabajo para crear un mapa de calor, mediante Power BI, Tableu o Qgis. Mediante un archivo XLS, con estos datos se debe colorear las zonas de acuerdo a los codigos postales y el porcentaje que tiene cada codigo postal. necesito poder visualizar los datos geograficos para analizar la distribucion de los valores a lo largo de las regiones.

I'm looking for an experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...

I'm in need of an Excel expert who can help me compile a detailed file for the merger of PVR and INOX. The document should contain two main sections: - Financial Data: - I require you to list the revenue, expenses, and profit/loss figures. These should be clearly presented in a way that allows easy comparison. - Merger Details: - You will also need to include specific merger details. This includes the merger date, the terms of the merger, and the name of the merged company. The ideal candidate for this project is an experienced Excel user, with a proven track record in data analysis and a keen eye for detail. You should be comfortable working with financial data and able to present complex information in a clear and insightful manner. Experience in mergers and acquisiti...

I'm in need of someone to send invoices to my clients via email. The invoices must contain the following details: - Client name and contact information. - An itemized list of products/services. - Payment terms and due dates. I don't have any specific format or template in mind, so you'll have the creative freedom to design the invoice layout as you wish. Ideal candidates for this job should be detail-oriented, have good communication skills, and be reliable in sending the invoices on time. Previous experience with invoicing or basic accounting would be a valuable asset.

**PLEASE SEE AND READ THE ATTACHED PDF WEB DEMO ACCOUNT A report is required with the following information: Report where it marks the maximum fuel level value (load) in this case it is 20,000 liters The report must have the condition to take the load point if it was kept at a high level for more than 10 minutes, it has not moved and the value did not change, let's say 5000,10000,15000,20000lts, it will mark it as load, when it is stopped for 10 minutes and begins to detect discharge movement of more than 2000 liters, it will take the last largest value as the discharge. • The report must be generated in the same place where they are currently generated (image 1). The PDF, HTML and XLS format is required, such as those for Fuel fillings and Fuel thefts. • What we want t...

I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of information.

I want all funeral directorss email addresses scraped from All send on a spreadsheet with Names, phone number, city and email address Price for all contacts from the site PLEASE PROVIDE PRICE TO COMPLETE THE JOB. DO NOT MESSAGE FOR A CHAT DO NOT BID A PRICE THEN ASK FOR A HIGHER PRICE Feedback will be left according to quality of work.

I am in need of a versatile individual to assist in listing products on my website. The type of products and quantity to be listed was not specified. The platform on which the website is built wasn't mentioned. The ideal candidate should: - Have experience in product listing across various platforms. - Be flexible to work with different types of products. - Have strong attention to details to ensure all product information is accurate and appealing. - Be able to perform tasks with minimal supervision. Payment is per item listed. Please send price per 100 listings

I'm in need of an experienced data entry specialist who is proficient with Excel and has a good attention to detail. The project is small scale, requiring less than 100 entries of numeric and text data to be input accurately. Requirements: - Skilled in data entry - Experience with Excel - Attention to detail - Efficient work pace The ideal candidate would have ample time to complete the project quickly. Make sure the entered data has to have no errors and is accurate since the output will be used for further analysis. Final format: Data should be delivered in an organized Excel spreadsheet.

I am seeking a talented individual to assist with a Power BI Data Visualization project, focused on displaying sales data. Your expertise will aid in the creation of comprehensive monthly summaries that will aid decision-making processes. Key Requirements: - Proficiency in Power BI for data visualization - Experience with sales data analysis - Ability to create detailed monthly summaries The perfect candidate would be a seasoned Power BI user, who has had previous experience aiding businesses in making use of their sales data. The successful freelancer will help transform our raw data into easily interpretable monthly summaries.

Trace radio base station plot (latitude, length), height tower, azimuth from an excel file to Google earth using Mapinfo

We need a list of all stores in US & Canada that fall under any of the following categories/keywords: Watch Store Watch Repair Shop Jewelry Store Jewelry Repair Shop Fashion Boutique Outdoor Goods Store Sporting Goods Store Electronics Store Mobile Phone Repair Shop You will have to scrape these websites: Yelp, Yellow Pages, Google Maps I have provided an Excel template to follow.

I'm in need of a highly skilled data entry operator to assist with my Tally entries and MS Excel billing work. The ideal candidate should be well-versed in both Tally and MS Excel, as well as have a strong attention to detail and a high level of accuracy. Key responsibilities include: - Data entry: You will be responsible for entering a wide variety of data into Tally, including processing of invoices, bank statements, and other financial records. - Account reconciliation: Regular reconciliation of Tally entries against bank statements and other financial records is crucial to ensure accuracy in our financial data. - Inventory management: Tracking and updating inventory records in Tally is another essential task that needs to be performed regularly. For the MS Excel billing work:...

I'm looking for a proficient Excel expert to create a comprehensive, automated meeting minutes template for Excel 2016. Key Features: - Auto-fill dates and participant names - Automatic calculation of meeting duration - Dynamic agenda item addition - 15 task owners fields - Core areas discussed: Process, People, Technology, System Ideal Skills: - Advanced Excel skills - Strong knowledge of Excel 2016 - Experience in creating automated templates - Eye for detail to ensure the tool works flawlessly The goal is to streamline our meeting minute creation process and ensure accuracy in documenting key points discussed and task assignments. Delivering a user-friendly tool that requires minimal manual input is key.

We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has ...

I seek a professional experienced in handling Word documents effectively to execute a data copying project. Key Job responsibilities include: - Copying a collection of Word documents. - Applying simplified formatting to the copied documents, eliminating any surplus details while retaining crucial information. The ideal freelancer should have: - Proficient skills in Microsoft Word, with a special emphasis on formatting. - An eye for detail and an understanding of simplifying documents without missing out on vital data. - An ability to work meticulously and deliver within a determined timeframe.

I'm in need of a proficient PowerBI analyst who can effectively connect to different data sources: Excel spreadsheets, SQL database, and CSV files. Your tasks involve creating detailed reports and conducting: - Sales performance analysis - Financial dashboards - Customer segmentation I have a preference for Bar and Pie charts in the visualization of these reports. Ideal applicants should have valuable experience in these fields and have an innate knack for making data comprehensible. Excellence in the mentioned chart formats is paramount. Having a solid background in Excel, SQL and CSV data manipulation will be a plus.

I need someone in Singapore to buy the latest print copy of Grazia Singapore for me and send it to the UK as soon as possible. The task involves: - Buying the magazine from a local store - Shipping the magazine to the UK via standard shipping - Providing tracking information for the shipment Ideal candidate: - Located in Singapore - Able to quickly purchase and ship the magazine - Experienced in international shipping Please note that time is of the essence, so I'm looking for someone who can complete this task promptly.

As a personal project, I'm seeking a skilled developer who can assist in creating a custom project management dashboard. Key Features: - Task Tracking: I intend to have a platform that allows me to track my tasks efficiently. - Team Collaboration: As I might need to work with others in the future, it'd be great if the dashboard can accommodate collaboration. - Progress Visualization: I envision a system that can help me visualize my progress and take necessary actions based on that data. Main Objective: The main goal of this project is to enhance communication. I need a system that allows me to communicate effectively, not only with myself but potentially with a team in the future. Ideal Freelancer: The ideal freelancer for this project should have expertise in dashboard deve...

I'm seeking an Excel expert to provide a comprehensive training session for my team of 11-20 individuals. We're at a beginner level and need someone capable of teaching us the basics and showing us how to optimally utilize data analysis and reporting features. - The training should cover: - Basic Excel functions and formulas - Data analysis - Reporting techniques The perfect fit for this project would be someone with an extensive background in Excel, ideally as a trainer or educator. Experience with teaching groups is a must, and the ability to break down complex topics into digestible, understandable parts is essential. Our goal is to increase our productivity and data handling capabilities through this training, so if you have a track record of achieving simila...

I'm looking for an Excel expert who can create an automated template for a financial renewal analysis dashboard. The dashboard should include basic descriptive statistics functions such as mean, median, mode, standard deviation, correlation, and regression. Key Requirements: - The dashboard needs to focus on the renewal status of our products/services. - It should be able to track the renewal status by product/service type. - The dashboard should be able to automatically update renewal statuses. Ideal Skills and Experience: - Proficiency in Excel and its advanced functions. - Experience in creating automated dashboards. - Understanding of financial data analysis, particularly in the context of renewals. - Strong communication skills to understand our specific needs and provide a sol...

Hi, we are a nonprofit based in Brazil. I am seeking a freelancer with outstanding research and data management skills to compile a list of geographical location of (environment and social) projects supported by a set list of 300 UK foundations (attached). Key Responsibilities: - I am only interested Foundations that provided grants to Brazilian organizations in the past 3 years (so the final list will be considerably shorter) - For these, I would need to know what are the themes covered by the foundation (for those grants but also beyond) - For some of these (that we will select later), I would need the email of the grants manager in charge (process wise, if it is easier to get te email of this entire subset, that’s ok) If a list of themes can be provided before hand, we can...

I'm seeking proficient data entry specialists for the purpose of converting alphanumeric data from physical documents into digital format. Key Responsibilities: - Accurately enter alphanumeric data from physical documents - Cross-checking entries for accuracy - Maintain the confidentiality and integrity of the data Ideal Skills and Experience: - Proven experience in data entry - Fast and accurate typing skills - Proficient in English - Ability to decipher handwritten data - Detail-oriented with a focus on data accuracy - Experience in working with physical documents is beneficial. Prioritize those who maintain a professional attitude towards time efficiency and document confidentiality.

I am seeking a technically proficient freelancer to help streamline the process of importing products - including their names, descriptions, and prices - from Shoptet (XML format) to our current Shopify site. The project will also entail exporting data (comprising of product name, SKU, price, descriptions, image URLs, category, and quantity) from the website in CSV format. Key tasks include: - Mapping shoptet fields to those on Shopify to facilitate a seamless bulk import. Ideal Freelancer Profile: * Proficiency in XML and CSV formats * Expertise with Shopify's data organization * Experience with Shoptet data handling * Mastery of data mapping techniques.

I have a project that involves the entry of data from Excel into a new system. The data entries are in Excel format, and I estimate the total number of entries required to be between 100-500. The task will involve a mix of text and numeric data. Ideal Skills: - Proficiency in Excel - Strong attention to detail - Efficient, accurate data entry - Previous experience with data entry projects of similar scale This is a straightforward task that requires someone who can work accurately and efficiently. Meeting the estimated entry count and maintaining data quality are key.

I need someone with meticulous attention to detail to manually type the text from a PDF file into Word while applying a new format. Your task will involve: - Reading the text in the PDF file and typing it in a Word document. - Applying a totally new formatting scheme that I'll provide. - Ensuring that the text still makes sense after the reformatting. The ideal person for this job should have: - Strong typing skills. - Familiarity with Word formatting tools. - A keen eye for detail to ensure that everything is copied accurately. - The ability to reformat the text in an organized and pleasant way. The purpose of this task is to both edit the content of the file and extract specific information, so your ability to stay on task is essential.

Need an extremely competent financial modeler in Excel who is capable of working with a lot of date math in formulas. You need to work on a working model template. NOTE: Do not apply if you are not genuinely capable of working with complex models. I am looking for help because I'm busy, not because I'm not capable! I make huge financial model templates on topics people don't model. I made a model on "ESOP" (Ownership structures for startups). ISSUE A client input dates in a way I didn't test and I realized I built in circular references I wasn't aware of. TASK Remove circular references (Need to change logic a bit to do it, which is not simple) Ideally break test to see how I messed up date math when dates are similar so won't be issues with inpu...

I'm seeking a proficient typist to carry out a data entry project in English. The ideal candidate will seamlessly enter textual data ensuring its accuracy and completeness. - PRIMARY PURPOSE: Data entry - LANGUAGE SPECIFICATIONS: Must be proficient in English - DATA ENTRY TYPE: Textual With a keen eye for detail and quick typing speed, the appointed candidate will significantly contribute to the project's successful completion. Previous experience in similar roles is preferred.

I'm looking for a diligent freelancer to help me with a straightforward data entry task. The task involves: - Collecting text data from various websites - Organizing and inputting the data into Word documents. The ideal candidate should be: - Skilled at conducting online research - Proficient in Microsoft Word - Detail-oriented and able to maintain accuracy - Good at time management to ensure timely completion of the task. Your role will be pivotal in creating a structured, comprehensive database from the web content I provide.

Kami telah menyusun deskripsi proyek dari jawaban Anda. Tambahkan detail tambahan apa pun yang Anda ingin pekerja lepas ketahui sebelum melanjutkan ke langkah berikutnya Deskripsi Proyek Saya mencari seorang treelancer untuk membantu saya mengumpulkan data kuantitatif untuk penelitian akademis. Saya memiliki daftar sumber spesifik yang saya ingin datanya dikumpulkan Kemampuan dan pengalaman: - Pengeluaran dalam bentuk pengumpulan dan analisis data penelitian akademis

I need a professional to clean my text data. The primary goal is to standardize the formatting of the data. - Your main task will be to format the text data in a consistent and uniform way, ensuring that all the text data is correctly and uniformly structured. - You should be proficient in text data cleaning with experience in standardizing the formatting of textual content. - The data is currently stored in plain text files, so experience working with this type of data storage is necessary.

I need help with data entry into spreadsheets. Key Responsibilities: - Efficiently and accurately transfer data into spreadsheet format Ideal Skills: - Proficient in spreadsheet software - Experience with data entry The project involves basic data entry tasks. The data is mainly in digital format. Your primary responsibility will be to ensure all data is accurately entered into the spreadsheet.

I need a professional who can help me extract photos from various websites for data analysis purpose. Key Requirements: - Image Extraction: The main task is to extract photos from a multitude of websites. The photos will be used for data analysis, so accuracy and completeness in this task is vital. Ideal Freelancer: - Data Extraction Expert: The ideal candidate would have experience in extracting data from websites. - Web Scraping Proficiency: Knowledge of web scraping tools and techniques would be highly beneficial. - Attention to Detail: The successful candidate will be diligent in ensuring all relevant photos are extracted. If you are confident in your ability to deliver a high-quality image extraction service, please submit your bid.

I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.

I'm in need of a seasoned credit analyst to assess the creditworthiness of loan applicants, review and analyze financial statements, and make loan approval or rejection decisions. Key Responsibilities: - Assess the creditworthiness of loan applicants based on their financial background, credit history, and loan application information - Review and analyze financial statements to identify key financial indicators that may impact the loan decision - Make informed loan approval or rejection decisions based on the applicant's creditworthiness Applicant Requirements: - Experience: Mid-level. I am looking for someone who has a proven track record in credit analysis, with a minimum of 2-3 years of relevant experience in the financial industry. - Software Proficiency: The ideal candid...

I need someone organized and careful to make a portfolio for 61 projects I've finished. Everything will be in Google Docs. It has to be done perfectly, exactly how I want it. After it's done, I want to apply for a job on freelancer.com. Tasks: Collect Project Details: You'll need to ask for files related to each project and make sure they're organized properly in Google Docs. Short Project Descriptions: Use ChatGPT to write brief, 1-2 sentence descriptions for each project. Keep it short and simple so the client won't have to read long pages. Portfolio Design: Use Canva to create a visually appealing portfolio layout that showcases the projects effectively. Organization: Keep everything neat and organized within Google Docs, making it easy for the client to navig...

I'm in need of a reliable data entry operator who can help me with data entry and data processing tasks. The data will be provided in physical paper form, and the expected outcome is database creation. Key Responsibilities: - Accurately inputting data from physical papers into a digital format - Processing the data as per the project requirements - Ensuring the created database is structured and easily navigable Ideal Candidate: - Proven experience in data entry and data processing - Proficient in using tools like Excel or Google Sheets - Attention to detail and accuracy in data entry - Ability to understand and follow specific data processing instructions Your work will be crucial in enabling me to organize and analyze this data effectively. I am looking for someone who can take...

I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.

I'm seeking a reliable individual with strong skills in research and data entry. The project includes: - Researching and entering text data specifically related to names, addresses, email addresses, phone numbers, and social media handles. - I expect 2000 or more total entries to be found and logged. Skills and experience necessary for this task include: - Attention to detail. - Proven data entry skills. - Familiarity with various research methods. - Ability to maintain confidentiality and data privacy.