Excel workbook commitроботи

I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes

I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.

I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the specific needs of this field in terms of estima...

I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs This is an urgent project and I woul...

I need an experienced PHP developer to help me with modifications to my Martfury website. The project is quite urgent, so quick action is necessary. Specific modifications I need on the Martfury website include the creation of custom reports and enhancing the overall security of the site. Key tasks include: - Developing custom reports: The reports I n...for someone who can identify vulnerabilities and provide solutions to protect the site from potential threats. Ideal skills and experience: - Proficient in PHP programming and Martfury website development. - Strong understanding of data analysis and reporting. - Previous experience in web security enhancements. The completion time for this project is ASAP, so I'm looking for a developer who can commit their full attention t...

necesito un Software punto de venta con estas caracteristicas Especificaciones • Software de escritorio • Base de datos mariadb • Control de Licencias de manera remota con servidor • Demo de presentación • Grabado de videos de su desarrollo paso a paso Menú principal • En forma de pestañas • iconos e...teléfono 6. Correo 7. Sitio web 8. País 9. Departamento 10. Ciudad 11. Creador de moneda 12. Logo foto 13. Facturas tamaño carta y recibo 14. Creación de formas de pago 15. Creador de impuesto porcentaje de uso RESPALDO DE BASE DE DATOS 1. Respaldo de base de datos manual 2. Respaldo de base de datos al cerrar programa Configuración 1. Subida y bajada de productos de forma masiva con tablas de ...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm looking for a reliable specialist in quantitative data collection for an ongoing project. Key Requirements: - Expertise in data collection: You should have a strong understanding of quantitative data collection methods. - Daily Data Collection: I requir...require daily data gathering, so punctuality is crucial. - Understanding of Data Metrics: You should be able to interpret and collect the right data metrics for analysis. Ideal Skills: - Proficiency in quantitative research - Strong analytical skills - Punctuality and reliability in data collection - Data interpretation and analysis This is an ongoing project. It's important that you're able to commit to daily data collection. If you're confident in your abilities and think you're the right fit for...

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an intermediate-level programmer with experience in Embedded C and 8051 Microcontroller. The project involves designing a system that takes input from 3 sensors and controls an actuator (motor). Key Requirements: - Design a system on 8051 Microcontroller - Program the system in Embedded C - 3 sensor inputs and motor ou...Assist in sourcing necessary components I have a strong preference for someone who has worked with 8051 Microcontroller and has experience with designing systems that integrates sensor inputs and actuator outputs. Your role will involve both programming and assisting in recommending and sourcing the necessary sensors and actuator for this project. If you're experienced in these fields and can commit to assisting with the components, I'...

I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation

I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looking forward to your proposals...

...need an Excel expert to create a comprehensive spreadsheet to track and calculate project costs, revenues, expenses, and profits. Specific calculations required include sum, average, percentage. The Excel sheet should track the following: - Project cost - Project revenue - Project expenses - Percentage of account receivable - Percentage of account paid - How the client paid after tax - Description for the costs - Percentage of the costs - Percentage of the profit before tax - Percentage of account receivable before tax - Date of payment The data presentation in the spreadsheet should be in the form of tables and graphs. Experience with financial data analysis and management is vital. Understanding of cost and profit calculations, as well as capability to implement adv...

We are looking for freelancer for technological catalogues redesign and build in adobe indesign. Freelancer should be expert in adobe indesign, photoshop, ilustrator. We provide example project templates in adobe indesign, source data in pdf and excel. Based on source data our catalogue should be created and redesigned as template project. Project should be done in adobe indesign for printing and web

...file with over 50 pages of data in mixed formats - text, numbers, and tables. The task is to accurately transfer this data into an Excel spreadsheet in a tabular format. Key requirements: - Data entry from a PDF file into an Excel spreadsheet - The data is of moderate complexity, so a good understanding of Excel is needed - The output should be a well-organized and clean Excel spreadsheet Ideal skills for this job: - Proficiency in data entry and working with large data sets - Advanced Excel skills, including the ability to work with mixed data formats - Attention to detail and accuracy to ensure the data is correctly captured - Experience with PDF to Excel data conversions would be a plus Please note that while the task is to transfer data,...

I'm in need of an experienced Ruby on Rails developer to help get our social networking app up and running as soon as possible. The app will essentially be a Facebook-like platform with key features including user profiles, timelines, messaging, chat functionality, and photo/video sharing. Ideal Skills: - Strong proficiency in Ruby and i...popular framework, Rails - Experience building social networking apps - Proficient in implementing chat and messaging features - Knowledge of photo and video sharing integrations The selected candidate will be expected to hit the ground running, working closely with me to ensure the app is launched on time while meeting the specified requirements. If you're a skilled Ruby on Rails developer and can commit to this urgent project, I'...

--- ### Job Title: Excel Sheet Creation for Job Tracking and Payment Calculation **Description:** I need a custom Excel sheet to help me track jobs completed by my installers, including details about each job, such as dates, customer information, and payments. The sheet should be able to automatically calculate the total number of jobs done and the total payment owed to each installer. **Requirements:** 1. **Job Tracking:** - Columns for the date each job was completed. - Columns for the job details including customer address and account number. - Columns for the installer assigned to the job. 2. **Payment Calculation:** - Ability to input the payment rate per job. - Automatic calculation of the total number of jobs completed by each installer. - Automat...

Just a quick bit of help needed in excel macro writing. See attached before and after showing a piece of the original data. and what i neeed the macro to achieve. WHAT IM ASKING If two adjacent cells in column b are equal, then add cells adjacent column c cells, put the result in the first column c cell and remove the duplicate row. AEE ATTACHED png. I need a tailored solution for a data manipulation task within Excel. Specifically, I am looking for an Excel macro that can accurately merge cells based on their adjacency. Essential skills and experience should include: - Expert knowledge of Excel and its macro functionality - Prior experience with data manipulation tasks such as merging cells - Understanding the rules or criteria for merging specificall...

I am looking for an expert who can as...expert who can assess and modify an existing Excel macro for compatibility with Excel for Mac 2019 or later. The current macro mainly handles formatting tasks within the Excel file. Key Requirements: - Assess the current macro's compatibility with macOS - Modify the macro to ensure compatibility with Excel for Mac 2019 or later I don't have a strict deadline for this project, so you can work on it at your own pace. However, I am looking for someone who can get this done efficiently and effectively. Feel free to ask any questions for more information. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge ...

I am looking for a skillful and remarkable resume writer who can craft a resume in a combination style. This has to be specifically targeted towards the health care industry. Key Project Details: - The project timeline is 1 week. I'm looking for someone who can commit to this timeline to create a polished, professional resume. - The resume format should be a combination style. It should highlight both skills and work experience, aligning with the multifaceted work nature in the health care industry. Ideal Skills and Experience: - Experience in resume writing, preferably for the health care industry. - Understanding of combination resume structure. - Excellent attention to detail and a strong sense of work commitment. I look forward to seeing your proposals and wor...

I have an urgent need for a Windows application to be developed. The primary goal of this application is to prevent any remote screen sharing while the application is active. Key Requirements: - The app should be compatible with Windows operating s...connected; but I DO NOT want screen to be seen by remote people until its active I need a freelancer who is well-versed in Windows application development and has strong understanding of the API, Powershell, firewall settings, services etc. Your previous experience in developing secure applications is highly desirable. This is an urgent project, so I need someone who can commit to delivering the project within a very short timeframe. Please apply if you have the necessary skillset and availability for this project.

...AI assistant with a focus on language understanding and real-time conversation support. Key Features: - Cross-Platform: The app should be developed for both iOS and Android, ensuring a wide user base. - Page Translation: Users should be able to translate live any page on their phone. - AI Assistant: The AI assistant should have the ability to provide information on various topics and should excel in language understanding, helping users with translation in real-time conversations with others. - Live Translation: The app should provide a smooth live translation experience for conversations. Ideal Skills: - Proficiency in React Native for cross-platform development. - Experience in building apps with live translation capabilities. - Strong background in AI development, specifi...

...Debugging and troubleshooting issues - Collaborating with other team members Ideal Skills: - Strong proficiency in Java, C#, and PHP - Previous experience in software maintenance and updating - Excellent problem-solving skills - Ability to work full-time and communicate effectively - Experience working in a team environment I'm looking for an individual who is reliable, skilled and able to commit to a full-time role. Please include your relevant experience, portfolio and availability in your proposal. OVERVIEW: We have created our own web-based digital dignsge content and screen management system. The cms allpws us to control the content displayed in-store TV screens. The platform can be seen here: - If you have digital signage experience this will be ideal (this

I am in need of a freelancer who can accurately convert my PDF files into Excel. The materials consist mainly of printed, electronically generated text. Given the nature of the work, the ideal candidate should: - Be proficient in both PDF and Excel formats - Have an eye for detail to ensure accuracy - Have experience dealing with extensive text documents - Possess strong typing and data entry skills Please bid if you fully understand the tasks and feel capable to deliver high-quality results. Your attention to detail and commitment to accurately completing tasks would make you an ideal candidate for this project.

...The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel report generation from SQL data - Excellent problem-solving skills and ...

I'm in need of a seasoned GSAP Javascript expert paired with a senior front-end developer for a long-term collaboration. Th...making the website more interactive and appealing. Ideal Freelancer: - Extensive experience with GSAP Javascript, particularly in implementing scroll, morphing, and SVG animations. - Proven track record of enhancing the visual appeal of websites. - Strong front-end development skills to ensure seamless integration of the GSAP animations with the existing design and functionality. - The ability to commit to a long-term collaboration and deliver high-quality results consistently. Your role will be critical in transforming our website into a visually striking and engaging platform for our users. Looking forward to welcoming a skilled and committed profess...

For my project, I'm looking for a highly detail-oriented professional with brilliant Excel skills. Key responsibilities include: - Managing and transferring both numerical and textual data in an Excel spreadsheet, ensuring the correct placement into columns marked by letters (A, B, C, etc). - You'll not be required to order the data in any specific way, just transfer into the appropriate columns. Skills & Experience: - Proven record in data entry tasks - Strong Excel skills - Ability to understand and interpret numerical and textual data Looking forward to your bids and kicking into this project soon!

I need an experienced iOS developer to urgently address specific issues that are leading to rejections during the Apple Review process. The issues we're facing include: - Functionality Issues: As reported by Apple Review, there are functionality issues that need to be fixed. - Compatibility Issues: The application is not working as expected on sp...fix the issues causing incompatibilities. Ideally, you should have: - Proven experience with iOS development and fixing issues that lead to rejection. - Proficiency in compatibility testing across different iOS versions and devices. - Ability to work quickly and efficiently to provide a fix by TONIGHT Saturday night, May 18th, 2024. Please bid if you are available to start immediately and can commit to resolving these issues on a...

I'm in need of an experienced data entry specialist who can assist in uploading 850 products onto my online store. You will be provided with the necessary product information (description, price, specifications) in the format of Excel/CSV files. Your tasks will include: - Accurate data input of all relevant product details - Verification and correction of any existing data entries - Ensuring all listings are in sync with their corresponding inventory Ideal Skills: - Experience in data entry, particularly e-commerce product listing is preferred - Proficiency in Excel - Attention to detail and accuracy are extremely essential - Fast typing speed with a keen eye for details. Please only bid if you have relevant experience, and can start work promptly.

I'm looking for a student from LUZ who can help me with a document request at Cedia Luz Maracaibo. The candidate needs to reside in Maracaibo, Venezuela. Key Requirements: - Live in Maracaibo, Venezuela - Attend LUZ - Capable of handling physical and electronic documents The ideal candidate must be able to commit to the task and complete it within a month. The task involves basic administrative work, so relevant experience in such tasks is a plus. La tarea seria retirar un fondo negro en un foto estudio que se llama Copy Alfa. Luego ir a la oficina de CEDIA en Luz Maracaibo y solicitar: 1.- Fondo Negro (uso exterior) (1 juego ) 2.- Notas Certificadas (uso exterior) (1 juego ) Una vez que tengas lo documentos, tendrías que enviármelos por MRW a Puerto La Cruz,...

I'm looking for a student from LUZ who can help me with a document request at Cedia Luz Maracaibo. The candidate needs to reside in Maracaibo, Venezuela. Key Requirements: - Live in Maracaibo, Venezuela - Attend LUZ - Capable of handling physical and electronic documents The ideal candidate must be able to commit to the task and complete it within a month. The task involves basic administrative work, so relevant experience in such tasks is a plus.

I'm looking for a professional who can assist me with the typing of my novel manuscript. Your responsibilities will include: - Accurately typing out my novel - Formatting the typed content into an e-book format The ideal freelancer for this job would be experienced in: - Typing - MS Word - Excel calculations - E-book formatting Having an RS-CIT certificate would be a major plus. The ability to pay close attention to detail and produce error-free work is paramount. Experience in typing and formatting novel manuscripts is highly preferred. Finally, quick turnaround time is necessary for the successful completion of this project.

I'm looking for an experienced freelancer who can create an Excel calculator for historical cryptocurrency prices from Binance and Luno. The calculator should also include fiat exchange rates for major currencies such as ZAR/USD bank sell rates Key Requirements: - Retrieve historical price data from Binance and Luno - Incorporate USD, and ZAR exchange rates - Organize the data and create user-friendly interface - Ensure accuracy and reliability of the calculator - Prioritizing the preservation of data privacy Ideal Skills: - Proficiency in Excel and data manipulation - Familiarity with cryptocurrency exchange APIs - Knowledge of major fiat currency exchange rates - Strong analytical and problem-solving abilities Please include your relevant experience in your applicat...

I would like to see the result statistic in %. Important, when i refresh the excel i always want to see the last 5, last 10 and last 15 results.

I have an excel file, need add product categorie on a column - budget 100€

Looking for an industrial / mechanical engineer professional who can assist in a variety of areas, from product design to overseeing the production process for skate facilities. Key Responsibilities: - Skatepark Design: You'll...process management. - Previous experience in the skatepark industry or similar outdoor sports facilities would be a significant advantage. - Strong understanding of design principles, production processes, and quality control. - Excellent project management skills to be able to oversee the entire process from design to production. This is an ongoing project, so I'm looking for someone who can commit to working with me on multiple projects in a kind of full time position. If you have the necessary skills and experience, please get in touch.

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables,...

fichier sur Excel reproduire le même identique sur Excel avec calcul automatique

Hello, I need complet the Amazon categories catalogue excel in french

I need a professional who can extract data from a website on a daily basis. Key Responsibilities: - Extracting data from a specified website - Ensuring the data is accurate and up to date - Delivering the data in a specified format Skills and Experience: - Proficient in web scraping and data extraction - Experience in ...accurate and up to date - Delivering the data in a specified format Skills and Experience: - Proficient in web scraping and data extraction - Experience in automating data extraction processes - Ability to maintain data accuracy and consistency - Knowledge of relevant data formats for delivery - Strong attention to detail and reliability This is an ongoing project, and I need someone who can commit to daily extractions. Be sure to include relevant experience in...

I'm in need of a freelancer with a high level of proficiency in Microsoft Excel to use conditional formatting over different tabs to help visualize duplications in large sets of numerical data. Ideally, you should not only be skilled in Excel, but also possess a keen eye for patterns and detail. Your job will encompass: - Applying conditional formatting across multiple tabs. - Highlighting duplications in numerical data. - Ensuring easy readability and understanding of the data presented. An understanding of data visualisation techniques would give you a competitive edge for this project. This task will require a close attention to detail and a strong understanding of Excel's conditional formatting tools.

...week reviewing VLSI papers and translating them into Python code or c++ code. Key Requirements: - Advanced expertise in Python: You should be comfortable with complex Python coding tasks. - A solid understanding of Computer Science: Your field of expertise should be Computer Science to ensure you can effectively decode and optimize relevant papers. - Dedication: I'm looking for someone who can commit a considerable amount of time each week to this project. Please note that the VLSI papers may involve a wide range of topics within the realm of Computer Science so it's essential that you can grasp and code diverse concepts. Ideal candidate should have: - A PhD in Computer Science. - Proven experience reviewing and coding academic papers. - Strong critical thinking ...

I have a small dataset of less than 1,000 rows that requires both data cleaning and formatting. Additionally, I need assistance with data analysis and visualization. This is a one-time project, and I am looking for a skilled individual to handle this for me. Ideal Skills and Experience for this project: - Proficiency in Excel is a must. - Experience with data cleaning and formatting. - Ability to perform data analysis and create visualizations. - Attention to detail and an eye for accuracy.

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issues with Excel macros.

I want to make a Incentive structure in the attached excel. I am paying incentive to my staff. I have different types of incentive policy Each Incentive calculation is starting from the month "m" It will be accumulated and the Incentives will be paid on every month of "n" The process will start again and will repeat again. This process will depend upon the value that I am putting in the cells of "m" and "n". You have to correct the formula I have given in the sample or you can make a new formula

I have a small project that requires the entry of structured text data. The project will involve: Ideal candidate would have a strong attention to detail, excellent organizational skills, and a background in data entry. Experience with structured data formats is a plus. This should be a fairly quick task, but accuracy is key. I will share you more details in via chat box. Thanks

I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.

I'm looking to hire an experienced English tutor who can conduct face-to-face lessons for beginner level teenagers. The course will run from 20th June to 20th July in Malaysia, encompassing key skills such as: -Conversation -Reading comprehension -Writing skills This intensive tutoring requires the individual to commit 15 hours per week, providing an immersive learning experience for our teens. The successful applicant should have a solid background in teaching English language skills to a similar age group, and ideally familiar with teaching those who are at the beginner level. Dedication, patience and innovative teaching methods are qualities that I hold in high regard. Excited to see how you can help our teens master English. This is a great opportunity for a dynamic E...

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: -...incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requirement. Previous experience handling numerical, categorical, and textual ...