Excel vbs find string variables jobber

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 for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable. I cu...

I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.

I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations.

una pagina web que...seran enviados a su correo y whatapp, tambien tendran la opcion de cambiar su clave o recuperar su clave; los socios podran ver el historial de ventas, comisiones, pagos realizados, saldo, estadisticas, la informacion sera enviada a su correo y whatapp, tambien tendran la opcion de cambiar su clave y recuperar su clave. todo tiene que ser almacenado en una base de datos que se pueda exportar a excel, la pagina web tiene que ser amigable y podra visualizarse desde una computadora, tablet y telefono celular. la pagina web debe estar en idioma español y tener la opcion de cambiar a idioma ingles, el proyecto incluye el codigo fuente el proyecto debe tener la opcion de ofertar varias promociones a los clientes, estas promociones se deben visualizar al inicio ...

Vennligst Registrer deg eller Logg inn for å se detaljer.

Let's do it. let's do it. let's do it

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.

...Transform Your Study Experience: Engage with your study materials like never before. Simplify content, create custom presentations, generate tests, and get expert writing support—all in one place. ===The other 4 designs represent the following 4 services: 1 - Interact with your study materials: Engage in interactive conversations with your study materials. Ask question, get simplified summaries and find relevant points with ease. 2- Simplify and Present Content: Simplify content for easy understanding and create customized presentations to suit your learning needs. 3 - Test & Quiz Creation: Generate tests and quizzes from your study materials for easy self-assessment and interactive learning. 4- Writing Assistance: Access personalized support in crafting articles, ...

I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel

I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.

I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.

I'm seeking a seasoned professional who can help me sell my productivity app on platforms like Flippa. My primary goal is to find a passionate buyer who can truly appreciate the value of my product. Key Requirements: - Proven track record in selling apps or digital products - Familiarity with Flippa and other similar platforms - Experience in targeting and attracting the right audience for a digital product - Knowledge of the productivity app market Your responsibilities will include but not limited to: - Developing a solid sales strategy - Crafting compelling product descriptions - Managing communications and negotiations with potential buyers - Ensuring a smooth and secure transaction The ideal candidate should be a strategic thinker, a great communicator, and a tech-savv...

Active Directory Expert to create a Python script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, AD RMS (Rights management Services) group policy GPO etc. and export to a MS Excel File. More information attached.

I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.

I am seeking a talented machine learning engineer or data scientist to create an automaton for recognising handwritten digits specifically within mathematical problems. Responsibilities: - Develop a machine learning algorithm capable of recognising handwritten digits - The primary focus will be on mathematical prob...practical, efficient, and accurate automaton that simplifies the process of converting handwritten mathematical problems into digital numbers. I am looking for someone who can attentively listen to my specifications and implement them accurately. I value open communication and regular updates. you need to develop the first part (phase initiale) and the project number 18 - but the problem is to find a way to make a link between first part and (phase applicatif projet ...

...and in parser class (INTENSITY, ((), 0)); The problem is sometimes the Api giving the color value as string not as interger but only on on checkbox config we add and this already defined in java if(checkVariant is true) then consider it string and parse it what i have to do to fix my code based on that condition so i can parse the string value this way: updateProperties("color", ((), )); how i can solve this issue so in case checkVariant is true then parse it as string otherwise leave it as it is now which integer. can i do that only on parser or i need to change the Pojo class as well (colorWsDTO) who can do it in summery and short let em know

I need a skilled SPSS expert to help me analyze a dataset and draw conclusions for my research report. Key Requirements: - Data Analysis: I need assistance in analyzing the data, which includes variables like Gender, Education level, pro-environmental behaviour, individual differences, and psychological factors. - Prediction: The primary objective of my research is to predict one variable based on others, so your expertise in predictive analytics is crucial. - Experience: I'm looking for someone with a strong background in data analysis and research, specifically using SPSS. Knowledge of psychology, or sociology is needed. Please note: - The study involves 155 participants, so you should be comfortable working with datasets of this size. - Clear communication is important; ...

What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. these links may help

...and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the realistic bid price per Job. Your responsibility would be to ensure that the scanned files and photos are accurately reflected in the Excel...

We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our ...variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and ...

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

...fresh and modern design to accurately represent my work. I'm looking for a design that is clean, professional, and easy to navigate. - **WordPress Implementation**: I'd like the new website to be built on WordPress, for its user-friendly interface and ease of future updates. - **Product Search and Filtering**: I need the site to have a search functionality, allowing users to easily navigate and find specific projects or categories. The ideal freelancer for this project should have: - Proven experience in web design, particularly in portfolio websites. - Proficient in WordPress and familiar with its best practices. - A strong portfolio showcasing previous works of high quality and professionalism. If you're creative, experienced and can bring my portfolio to l...

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 am in need of a skilled freelancer to develop a cloud-based document management system...to develop a cloud-based document management system. This system will be used within my small team, which consists of less than 10 users. Key Features: - File Storage and Organization: The system needs to allow us to securely store and categorize our text documents. - Document Indexing and Search: It should have an efficient indexing system with a powerful search capability, so we can quickly find and access the necessary files. Ideal Skills and Experience: - Proficiency in cloud-based technologies - Experience in developing document management software - Familiarity with creating systems optimized for small teams Please let me know your relevant experience and how you plan to approach thi...

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

looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from Site Tools ->...

...reach businesses effectively and persuasively through these channels. I look forward to seeing how your skills can align with my project objectives. We are an AI-enabled Global Private Capital Market Platform matching Issuers Investors, Advisors and Broker-Dealers and their deals. Our pioneering Investor Discovery Solution, removes barriers enabling Issuers (private companies and funds) to find the perfect investor match within seconds. Investors can now source the most exciting opportunities whether they are private companies, funds or even other Investors, for their primary and secondary share sales. Financial Advisors and Broker-Dealers can now gain access to issuers and investors from anywhere in the world who are unknown to them, to close their deals faster, o...

...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 en cuadricula con entorno agradable con iconos y animaciones DATOS DE PRODUCTOS 1. Código de barras 2. Código de proveedor 3. Foto 4. Estatus 5. Descripción/nombre 6. Iva tasa 7. Precio de compra 8. Cuatro precios variables de venta 9. Tipo de producto: articulo, kit, servicio, membresia 10. Categoría 11. Marca 12. Proveedor 13. Elaboración y vencimiento LISTADO DE CRÉDITOS 1. Ver créditos pendientes de pago 2. Ver créditos pagados 3. Crear notas de credito LISTADO DE USUARIOS 1. Modificar usuario 2. C...

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

...with an exciting project idea for a mobile app focused on cricket match scheduling. As a cricket enthusiast, I have often faced the challenge of finding available teams to play matches against on short notice. To address this issue, I envision an app that can connect teams and simplify the process of organizing cricket matches. Project Overview: The primary goal of the app is to help cricket teams find and schedule matches with each other. Teams can mark their availability for matches, view other available teams, and communicate directly to arrange matches. Core Features: User Registration and Profiles: Teams and individual players can create profiles. Profile information includes team name, location, contact details, skill level, and availability. Match Availability: Teams ...

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 seeking an experienced developer to create an Android app for my e-commerce business. The app should possess a minimalist design, aiming for simplicity yet effectiveness in terms of user experience. Key Features: - Product Search and Filtering: To help users find and sort products with ease. Ideal Skills: - Expertise in Android App Development, specifically in building e-commerce applications. - Strong understanding and experience in creating minimalist designed apps. - Skills in implementing useful product search and filtering features. The end product should deliver an easy-to-use platform for shoppers with a clean and minimalistic aesthetic. Experience in e-commerce app development with a focus on product search and filtering will be highly appreciated.

...system: An integrated messaging system will permit players to converse, coordinate, and plan games. Experience in developing seamless communication tools is beneficial. 3. Game scheduling/calendar: A calendar feature for easy game scheduling is crucial. I expect your prowess in creating intuitive date-time functionalities to shine through here. 4. Field locator/map: Leveraging mapping APIs to find nearby playing fields will be a valuable element. The ideal candidate will have experience using mapping technologies. Finally, users should be able to sign up with their email and password. Therefore, experience in user authentication techniques is highly desired. With these in place, we'll ensure a convenient and easy-to-use platform for soccer enthusiasts, promoting engagemen...

A project is to find a better script or an idea to overcome ozforensics. Facial LivenessDetection Biometric verification without the presence of the person concerned

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

--- ### 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 find myself in need of a highly skilled individual capable of assisting with numerous projects across a variety of areas. Given the breadth of tasks, a versatile set of skills is vital. Specifics haven't been decided yet, but your experience may help mould these into reality. Key skills and experiences: - Website development - Mobile app development - Graphic design Tasks may include, but are not limited to: - Designing user interfaces - Developing backend functionality - Implementing payment gateways While I don't have a concrete vision for design, flexibility and a keen eye for aesthetics are beneficial. Whether it's a minimalistic, bold and colorful, or clean and professional look, the ability to adapt to different styles is key. Your input, initiative...

I'm in need of an expert who can establish an effective indoor wayfinding system for specific rooms and departments in commercial spaces, including stores, galleries, theaters, parking lots, casinos, etc. This will encompass: - Designing a clear and intuitive pathway using physical signs, specifically directions with arrows. - Creating directions to defined variables in the commercial space. - Being able to visualize the user journey through our indoor space and mapping it out logically. Ideal skills and experience: - Proven experience in wayfinding system design, specifically for indoor spaces. - Excellent design skills with a keen eye for intuitive visual communication. - A good understanding of space utilization in a building environment.

...to accomplish two specific tasks for my impending project that involves a deep-dive into financial econometrics using R: 1. Regression Analysis: Applying my real-world data, there's a need to execute an efficient regression analysis. The aim isn't to predict future values but to identify significant variables inherent in the dataset. 2. Model Evaluation: Post regression analysis, your expertise will be needed for a thorough model evaluation, ensuring the accuracy of the identified variables and assessing the overall performance of the model. Ideal applicants should possess robust experience in R, financial econometrics, regression analysis, and model evaluation. Familiarity with real-world finance data would be an added advantage. The goal is to unlock the po...

I'm looking for a data sourcing and CRM expert to hel...HubSpot CRM. Project Goals The goal of this project is to establish a foundation for targeted email marketing campaigns. This will be achieved by: • Creating a targeted lead list based on my ICP. • Uploading the lead list into HubSpot for easy campaign management. Your Responsibilities • Collaborate with me to define my Ideal Customer Profile (ICP). • Identify and utilise appropriate data sources to find relevant leads. • Source contact information (emails and phone numbers) for potential customers aligned with the ICP. • Cleanse and validate the sourced data for accuracy. • Upload the final, clean lead list into my HubSpot CRM. • Provide guidance on best practices for data hygiene i...

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

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.