Data sheet design setsJobb

Hi! I have a simple WebApp script that, via Webhook in WooCommerce, retrieves information about an order when it is created and inserts values into a new row in a Google Sheet. I would like to modify the script so that everything is not just added to a row, but the values that are retrieved are entered into specific cells of my choice (and updated in the same cell each time new information is retrieved). Thanks.

excel vba programming convert excel sheet function into VBA

Jag behöver hjälp med att lägga till attributes och attribute sets till Se bifogade bilder

I need an efficient and experienced professional who has a good understanding of Google Sheets and data analysis and entry. Specifically, I need: - Creation of PLP by Copying-Paste Data entry. - Searching a Google sheet for specific products that should be on that PLP - Manually adding each product to that specific PLP based on the results from the sheet A full and detailed brief is available.

...Worksheet is run, it writes a date in a database worksheet 2) There are 2 worksheets for Input: a. Customer Main Input Screen - worksheet (90% of the application runs off data from this worksheet i. The information from this worksheet is utilized for all 8 other reports (worksheets it produces). ii. It uses a “What is your current yearly revenue” number and pulls against an array (worksheet) – For the 8 other reports, it pulls data from the column in the array to produce reports. b. Customer EBITDA and P&L – Some data from the array is utilized here, and this being a customer input screen, also needs to save its data to a database worksheet. 3) To Purchase the MSP Business Evaluator and Accelerator, you need to go through man...

...& Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messaging - Capable of implementing and managing information resources The main functionalities of the bot are: - Sending automated messages: The bot should be able to send pre-determined messages at set intervals. - Receiving user input: It should be able to interact with users and receive text input from them. - Providing information based on user queries: The bot needs to be able to present content from our company's internal library which will be provided upon Bot design by using MENU BUILDER. All content contains: - Documents and presentations - Training materials - Policies and procedures Your design should ensure the bot is user-friendl...

...expert who can help me create a bidirectional data transfer system in Google Sheets. - The task involves transferring ALL data from one main sheet to multiple other sheets. - The data should be copied as well as linked to the other sheets. - The script should work bidirectionally, meaning any changes made in the source sheet should be reflected accurately in all the other sheets and vice versa. Ideal Skills and Experience: - Proficiency in Google Sheets scripting, specifically working with data transfer and bidirectional systems. - Knowledge of how to copy and link data between sheets. - Experience in creating and maintaining bi-directional data systems. - Ability to ensure that the script performs seamlessly even when handling a...

...Implementation:** 1. **User Registration and Profile Creation:** - Players sign up and create profiles. - Each player is assigned a unique identifier (UUID) for tracking. 2. **Scenario Generation:** - At the start of a session, the backend sends a request to the ChatGPT API. - The API returns a scenario that sets the context for the game. 3. **Task Generation:** - Based on the scenario, the backend formulates tasks for each player. - Tasks are personalized using player data and are kept secret. 4. **Task Distribution:** - Players receive tasks through the frontend interface. - The backend ensures tasks are only visible to the assigned player. 5. **Gameplay Interaction:** - Players complete tasks and submit results. - The backend tracks th...

...Implementation:** 1. **User Registration and Profile Creation:** - Players sign up and create profiles. - Each player is assigned a unique identifier (UUID) for tracking. 2. **Scenario Generation:** - At the start of a session, the backend sends a request to the ChatGPT API. - The API returns a scenario that sets the context for the game. 3. **Task Generation:** - Based on the scenario, the backend formulates tasks for each player. - Tasks are personalized using player data and are kept secret. 4. **Task Distribution:** - Players receive tasks through the frontend interface. - The backend ensures tasks are only visible to the assigned player. 5. **Gameplay Interaction:** - Players complete tasks and submit results. - The backend tracks th...

Google sheet data entry Need experience Have basic english.

I'm in need of a skilled Python/Java developer who can help me build a full-stack accounting web application. Key aspects of this project include: - **Main Feature:** The most crucial aspect of this accounting web application is its financial reporting capabilities. The financial data will be taken from Excel and XML. There will be financial reports (P&L, Balance Sheet, Cash Flow) and graphs to show the financial status. - **Technology Stack:** I require the project to be developed using Python/Java as the primary programming language. - **Database:** The application should be built using MongoDB for its databases. Ideal candidates should have: - Proficiency in Python/Java and MongoDB. - Experience in developing accounting or financial applications that include ...

...Implementation:** 1. **User Registration and Profile Creation:** - Players sign up and create profiles. - Each player is assigned a unique identifier (UUID) for tracking. 2. **Scenario Generation:** - At the start of a session, the backend sends a request to the ChatGPT API. - The API returns a scenario that sets the context for the game. 3. **Task Generation:** - Based on the scenario, the backend formulates tasks for each player. - Tasks are personalized using player data and are kept secret. 4. **Task Distribution:** - Players receive tasks through the frontend interface. - The backend ensures tasks are only visible to the assigned player. 5. **Gameplay Interaction:** - Players complete tasks and submit results. - The backend tracks th...

I'm in need of an Excel Spreadshee...few key tasks: - Revamp the Weight Loss Tracking Sheet: The current formula isn't functioning as intended. Your job will be to troubleshoot and fix the problem. - Nutrition Plan Integration: Blend the Weight Loss Tracking Sheet with a separate nutrition plan in the same Excel document. The two should have a uniform look, with consistent colours and my branding. - Branding Adjustments: Remove branding from the Weight Loss Tracking Sheet and ensure it matches the nutrition plan in terms of aesthetics. Your expertise in Excel formulas and formatting, as well as design skills will be key in completing this project successfully. Also please make a copy of the tracking sheets below so I have master copies and don&rs...

...forms via a wizard or questionnaire that will ask the user for answers to specific questions for the form (e.g., placeholders in a form template: name, date, etc.) and an ability to share these generated pdfs from the share sheet - batch adding a set of reminders to a specific reminder list using EventKit (and being able to edit this list of reminders from a settings page in the app where multiple reminders can be listed for adding with one tap on the reminders view) - generating pdfs of some of the views (tables and lists) and being able to share them from the share sheet - general tidy up of the visuals of the app (to match Apple human interface guidelines - it should be very simple looking) - commenting functions for clarity and my own learning You will need to be inde...

I have a 3.5-page handwritten sign-in sheet that I need transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highlighting of specific de...

...proficient PHP developer to construct a PDF data sheet generator for products from a database. Key Project Objectives: - Create section generator user input screen to enter named sections which can be used across different products. - Have the ability to adjust sort order of sections are rendered when the PDF is generated. - Incorporate re-usable generic sections within the generated PDFs to maximize efficiency. - Use links to insert pictures for diagrams and product image. Ideal Skills and Experience: - Proficient in PHP Development - Proficient with a PDF generation library, (ideally TCPDF) - Experience in working with databases - Experience in image handling and manipulation for the chosen PDF library. The final product should generate data sheets that are b...

I'm looking for a freelancer who can create a custom Excel sheet to track the daily attendance of my employees. The sheet should: - Be user-friendly and easy to navigate - Allow for automated calculation of total attendance - Be able to handle multiple employees at once - Have the capacity to expand for future growth I'm not looking for anything too complex, just a simple, efficient tracker that can help me keep tabs on my employees' attendance on a daily basis. Ideal Skills: - Proficiency in Excel, including advanced formulas and functions - Experience in developing user-friendly, automated spreadsheets - Strong organizational and communication skills to ensure the tracker meets my needs and is easy to understand and use.

I need an expe...Sales Report, Financial Report, and Activity Report - The Sales Report should include Revenue, Quantity Sold, and Top-Selling Products - The Financial Report should be a recreation of a Profit and Loss Statement, Balance Sheet, and Cash Flow Statement from our previous data in Sage Ideal Skills and Experience: - Proficiency in PowerBI tools - Previous experience with migrating reports from Sage to Business Central would be a huge advantage - Strong analytical skills to ensure the reports are accurate and comprehensive Please note that we can provide you with the necessary data and previous reports from Sage to facilitate your work. I'm looking forward to receiving your proposals. I have also attached a couple of sage reports that we are after i...

I am in need of an experienced Tally TDL developer who can assist me in customizing my financial reports, particularly the balance sheet. Key Responsibilities: - Customize the Balance Sheet in Tally software to meet my specific business needs. Ideal Skills and Experience: - Proficiency in Tally TDL (Tally Definition Language) programming. - Prior experience in customizing financial reports in Tally, particularly the Balance Sheet. - Strong understanding of accounting principles and financial reporting.

I am looking for a person who can do data mining for contact details including the whatsapp number of ielts institutes own which are located in Haryana, Punjab, and Gujarat Job Responsibilities 1 you have to update daily google sheet 2 it is upto you how you do data mining, by calling or by some software 3 the contact details you will deliver were used by our telecaller team 4 we want to contact the owner regarding to our ielts product I will create and release milestones on every Saturday, please bid your weekly milestone budget not monthly

...it'll to fetch rest row and column data from sheet. Check attachment. I'll enter only order number. This will involve: - Implementing a User Authentication system. Note that no specific features like social media authentication, two-step verification, or forgot password functionality are required. Just a simple log-in/log-out system will suffice. - Data validation will be key in this project. Each entry must be checked to ensure that it meets certain criteria before being stored in the sheet. - Real-time data synchronization between the app and Google Sheets. This means that any changes made in the app should be instantly reflected in the sheet, and vice versa. As far as the data types are concerned, we will be dealing with ...

I need a tool that can search multiple sheets in an Excel workbook and copy specific rows to a new sheet based on manual selection. The core requirements of the tool are: - Searching across multiple sheets to find specific data. - Allowing me to manually select a specific number of rows from the search results for copying. Given these criteria, the ideal tool would be: - Capable of working with Excel files. - Providing a user-friendly interface for easy manual selection. If you have experience with these requirements, please reach out.

...especially with the misleading nature of the statement of profit loss. I am in need of an expert in the following areas: - Understanding and interpreting AASB 1058 - Nonprofit financial reporting - Ability to simplify complex financial data The ideal candidate should have prior experience in helping nonprofits navigate regulatory requirements and clarify financial data. Your role will be to assess our current reporting practices, highlight areas of potential confusion, and suggest clear, compliant and understandable ways of presenting our financial data. Your assistance will greatly contribute to our transparency and ability to serve our community more effectively. write report Board Report: Addressing Challenges of Adopting AASB 1058 in Financial Reporting for...

I require a highly skilled professional to transform an existing NPV/ROI spreadsheet into a high-quality, professional document. While the specific design elements have been left open-ended, taking initiative with the organization and aesthetics of the spreadsheet is crucial. There are 2 tabs in this sheet. Ideal candidates for this job are proficient in Excel and have a keen eye for organization and layout. A background or clear understanding in financial data is required. Please articulate how you would approach this task in your proposal. Add '67890' to your proposal so I know you've read this. Spreadsheet:

I have Excel sheet in the are all products added with all the categories in it. I will also share a word file in which I will add that specific category and you have to take out the data from sheet and create the image in Photoshop. I will also give you product images with it's specific name. You have to only remove background and add text and image according to the data. The person must have latest Photoshop and have to create one sample image. You have to leave the space also for the main video and have to choose a shape or space according to the data Here are the links to sample: My budget is Rs.50 per image. There are 10-11 images which you have to create and I need it by today. This

...au/explore/find-an-architect There are 566 architect contacts for Sydney, NSW, Australia within 100km. I requirements: - Extracting: I require the following contact information to be extracted: Business Name, Email, Phone number, Full address separated by suburb, postcode and state. - Formatting: All extracted data should be structured and organized into an Excel spreadsheet. Ideal Skills: - Web Scraping: Proficiency in web scraping tools and techniques is essential. - Data Entry: Experience with data entry and extraction. - Attention to Detail: Accuracy in capturing and organizing contact details is crucial. - Excel Proficiency: Ability to create and format an Excel spreadsheet effectively. - Communication: Regular communication and updates on the progress of...

As I venture into a data science project, I'm seeking an experienced Stata user who has a strong understanding of databasing and spreadsheets. No specific task was defined, hence your role could range from data cleaning and preprocessing, data analysis and visualization to building machine learning models. Deep knowledge in handling structured data and working with databases and spreadsheets is essential in this project. Ideal Skills and Experience: - Strong Stata programming and data handling skills - Experience in data preprocessing and cleaning - Familiarity with data analysis and visualization techniques - Knowledge in machine learning model development is a plus - Previous experience working with structured data sets...

I need a talented designer to create a captivating marketing flyer that'll promote our existing high performance sports wash (detergent). It’s a DL flyer - will be used for a direct mail letter box drop. I can provide our digital assets and style guide to support you. The design should uniquely highlight the features of our service which sets us apart from the competition. To include a call to action via our website - Specifically, every customer I talk to knows the problem, the conversation goes like: So tell me about Zeroda Adam? Answer-so you workout and unless you get your clothes in the washing machine straight away, they sit in a bag or the sink and when you’re able to wash them, they stink. You give them a wash, they seem clean, you then wear them...

...Ability for Gm (All hail Mattie) to generate pokemon and trainer npcs for simplistic and quick Preset modifiers for training/orders along with preset inputs for items and food Page List of pokemon within a town or route? Make a missed player box,for keeping track of items/xp for players who have missed sessions Team info page. Tik box for training and orders above the pokemon sheets On combat sheet,in boxes separate Shift, at will, Eot, scene,daily’s Ability to turn on and off additional content separate from the core rules/eratered content Pokedex separated by region to allow for region looked campaigns, easier search and marking system A move creator for making custom moves and adjusting The right candidate should have a strong portfolio in similar work and a sol...

I need an expert in Google Sheets to create a spreadsheet that will help me with data storage and organization, calculation and analysis, as well as collaboration and sharing. - You will be working with 1-5 sheets, and you should be able to help me set up the data in a logical and user-friendly way. - I would require some basic formulas to be implemented, so knowledge of formulas like SUM and AVERAGE is a must. - Lastly, I need to ensure that the sharing and collaboration aspects of the sheet are secure and work smoothly. - Previous experience with similar projects is a plus.

I'm seeking a talented designer to create a custom logo for my business that is tailored towards enhancing brand recognition. Key Project Details: - The primary purpose of the logo is to establish my brand identity and improve its recognition amongst my target audience. Therefore, the design should be impactful and memorable. - I'm looking for a unique, custom style that sets my logo apart from the competition. The design should be fresh, innovative and reflect the essence of my business. - The color scheme I have in mind for the logo includes blue, silver, black, red, and white. These colors should be integrated in a way that enhances the overall visual appeal and aligns with the purpose of brand recognition. Ideal Skills and Qualifications: - Proven exp...

Looking for an experienced web developer to spearhead the creation of a robust travel booking platform from the ground up. The envisioned website aims to serve a diverse clientele, offering seamle...Furthermore, the platform will provide valuable lounge access information, enhancing the overall travel experience for users. Successful candidates will possess a wealth of expertise in full-stack web development, with a keen eye for UI/UX design principles. Proficiency in platform integration is a must, including in-depth knowledge of GDS and the ability to seamlessly integrate Amadeus and Sabre APIs. Experience in mobile wallet integration for both Android and iOS devices is highly desirable. Join us in creating an innovative, user-centric travel solution that sets new standards...

...needs to: 1. Emphasize on * Standard Business Model: Clearly articulate the traditional and consistent business operations that my RCM enterprise adopts. 2. Include Key Components * Income Statement: A detailed income statement highlighting the revenue and expenses over a specific period. * Cash Flow: A cash flow statement displaying how changes in balance sheet accounts and income affect cash. * Balance Sheet: A report that summarizes my firm's financial standing in terms of assets, liabilities, and shareholders' equity. * Revenue Breakdown: Thorough analysis of different streams from where the business is generating its revenue. * Cost Breakdowns: An explanation of how much the firm is spending on its employees among other operation...

I'm seeking a google sheets expert to design and set up a customized sales and expense tracking system for my start-up smoothie/juice outlet. - The system will primarily track weekly sales - The expense tracking should be moderately detailed, breaking down expenses into categories such as ingredients and utilities. - The ideal sheet will include forecasting models, particularly incorporating seasonal adjustments and growth rate calculations for sales. The freelancer should have: - Proficiency in Google Sheets, particularly in setting up automated calculations and formatting for ease of use and understanding. - Experience in financial modeling and projection, with specific experience in the food/beverage sector being a plus. I'm looking for a system that can ...

I need emails from these companies of CEO ot anyone else working in financials, sales, or partnerships. Data scraping from rocketreach of the emails of the people that you can find with relevance from these companies in the image. Excel sheet with company name in the rows and in the 3 columns full name, email and position in the company

...the travel industry. They should walk away envisioning how KeptChain revolutionises the entire game. Key points include: - Financial Prospect - KeptChain isn't just another token. It's the safest, most transparent, and reliable cryptocurrency out there. That's a promise. - Technological Advantage - This doesn't just include it being the first crypto in the travel industry. Let's highlight how it sets the benchmark. Target Audience: - Potential investors - they want to see figures that impress. - Travel industry professionals - Convince them how introducing KeptChain can be a gamechanger. Skills: - PowerPoint Expert - Financial analysis - Understanding of the Crypto market - Convincing storytelling - Market research - Business savvy Experience: - Prove...

I'm looking to create a detailed list in Excel from the website AND filtered by clicking on 'Hardware' under 'Products' which is on ...'Hardware' under 'Products' which is on the left side in the 'Filter' section. The list should have two columns - the first for the Company Name and the second for the Description available on the website. Key Requirements: - Copy the Company Name into Column 1 and the Description into Column 2 of the Excel sheet. - Description should be directly copied from the provided URL. Ideal Skills and Experience: - Proficient in Excel and web scraping. - Attention to detail to ensure accurate data transfer. - Previous experience with similar projects would be advantageous.

I need a data analyst or researcher to provide data on how much the price of electricity and gas have increased by in the UK from the year 2014 - 2024. This research will be used to predict the percentage increase year on year for our customers moving forward. Specific Data Points: - Historical electricity prices - Historical gas prices - Percentage increase year on year Report Format: The final data analysis report should be in a spreadsheet format, preferably Excel. The main points should be supported with a PDF Data Segmentation: The data should be segmented by consumer type, specifically domestic consumers. Ideal Skills and Experience: - Strong background in data analysis and research - Proficiency in handling and analyzing large ...

I need help with an Excel sheet that will be used for data analysis, specifically sales distribution. The sheet will include a mix of sales data, customer information, and product inventory. Key tasks: - Organizing and inputting the provided data correctly - Creating a system for sorting and analyzing the data - Developing a system for tracking sales distribution effectively - Potentially applying necessary calculations and formulas to enhance the data analysis Ideal Skills: - Proficient in Excel, including data analysis and financial functions - Experience with sales data and distribution analysis - Strong attention to detail and organizational skills - Ability to create formulas and calculations - Familiarity with customer ...

I'm looking for a freelancer with excellent attention to detail and proficiency in Microsoft Excel and Word. As part of this project, you will be required to manually enter data from Excel files into a Word document. Key Requirements: - Strong Microsoft Excel and Word skills - Proven experience in accurate, manual data entry - Ability to work with robust data sets Deliverables: A Word document with the data accurately entered from the provided Excel files. Your ability to deliver clean, accurately transcribed data is essential for the success of this job. Attention to detail is paramount. I look forward to working with detailed and skilled freelancers.

I have a college assignment where I need to perform a data analysis task using Python. I have a specific dataset that I will provide. Key requirements: - Data Analysis: The task involves in-depth data analysis - not just basic statistical analysis but also some intermediate data processing and visualization. - Python Proficiency: You must be skilled in Python for this project. Experience in using Python for data analysis is a definite plus. - Dataset: I will provide the dataset which you will be working with, so you should be comfortable working with provided data. this is the question : In this question, you will use the dataset made available to the public by: S. Moro, R. Laureano and P. Cortez. Using Data Mining for Bank Direct M...

...) Elements: - Include easy to read TikTok/Instagram style captions - Use the End Card CTA provided Other: - Colour-correct the clips so that they all look great together - Use royalty-free music and edit to the beat - Make sure you pay attention to Instagram Stories/Reels "Safe Zones" --------- We are looking for people who have really great technical and storytelling skill sets in video editing :) As a full-time editor with us, you would be: Please follow the comprehensive brief below for more details before starting your edit. As a full-time editor with Venture Beyond, you will be: - Crafting and editing ads using Adobe Premiere Pro and After Effects - Collaborating with our UK-based team - Constantly learning and upskilling to produce effective ads - Followin...

I'm in need of a fitness expert who can develop a comprehensive personal training program sheet for my clients. The ideal candidate would have a strong understanding of exercise physiology and program design, as well as extensive experience in personal training. The program should cater for three main fitness goals: - Weight loss - Muscle building - Endurance training It should also cater to two levels of fitness experience: - Beginners - Intermediate The training frequency may vary, though it typically falls between 3-5 days a week. I need the program to be versatile and adjustable according to the individual's schedule. Include - Nutrition - Graph for progress (weight, fat percentage, habit tracking, calories/steps calculator) whether fitness watch can be a...

...and available balance of minutes. - The customer balance system would consist of minutes that would be automatically deducted when speaking with agents (not receptionists). The client's balance would be indicated by a voiceover at the beginning of the call. The way to buy balance would be through the IVR gateway, during the call through the receptionists, or through a php script to which the OK data from the banking web gateway would be sent. - Among the minimum necessary options there would be a panel for editing/information on clients, agents, receptionists, call and payment history, as well as reports on minutes per agent, reports on last purchases, minutes per client, etc. - Receptionists, agents and clients could have Spanish or international numbers of up to 20 digits....

Project Title: Premium Gift Concept Development for Live Streaming App Project Description: We are developing a live streaming application with a diamond-based gifting system, where users can buy and send virtual gifts to live streamers and purchase avatar frames. We are looking for a creative freelancer to design and describe a collection of virtual gift concepts. Project Requirements: Gift Sets: Develop 5 distinct gift sets, each containing 10 gifts. Each gift should have a unique theme and pricing based on perceived value. Description: A brief description of the gift. Psychological Meaning: What the gift symbolizes and conveys to the receiver. Animation Concept: Describe how the gift should appear in an animated form (brief storyline). 1-5 seconds Creativity an...

I have a small set of textual data that needs to be typed into an Excel sheet. The purpose of this project is to prepare the data for analysis. Key responsibilities: - Type less than 100 rows of textual data into an Excel sheet. - Ensure data accuracy and consistency. Ideal skills for this project include: - Experience with data entry. - Proficiency in Excel. - Attention to detail to avoid errors. The successful freelancer will need to deliver the Excel sheet with the data accurately typed within the given timeframe.

...setup and ongoing analytics. Creative design firm. The ideal candidate should have plenty of experience in this space including analytics, an eye and understanding of creative, effective targeting and wider strategy. A understanding of service based businesses, ideally creative fields, would be a huge bonus. We are currently running video ads and have tested static ads, some more successful than others. This engagement is for the following:- - A video meeting for us to show you what we're doing and how we have approached things to date - Your review of our campaigns to date, your assessment of these and recommendations for how to relaunch the next tranche - Assistance (via video) helping us set up and structure the new campaign across campaign, ad sets and ads plus ...

Looking to create 3 pages in Figma with High tech design to replicate 1. complete multi step form 2. 3. a new webpage having 3 search box to get user input, and a button at the bttom to show an iframe. this is for certificate validate purpose, we show A4 sheet in iframe, all 3 webpage should be responsive in nature, so design should be provided for all 3.

We operate a Google Sheet that fetches information from another spreadsheet identified in cell C1. Users mark checkboxes in Row A and click "Build Documents." When a user picks multiple checkboxes to generate documents, the Google Script halts after 300 seconds due to an overload. 1. The objective is to devise a systematic workaround to finish processing the document batch without additional manual intervention. For example, here's a replica of the spreadsheet you can use to test your code. The documents created all appear here: In the Spreadsheet App Sscript: In "Rahul's Code". 2. Add a line of code

I posted this job again because I didn't find suitable developer. I'm in need of a skilled professional with experience in both Google Ads and Meta Ads. I want to implement similar script on Meta Ads. ht...developer. I'm in need of a skilled professional with experience in both Google Ads and Meta Ads. I want to implement similar script on Meta Ads. And I want to use the this api instead of OpenWeatherMeta API to get weather data. Please apply if you have a rich experience in integration between Google Sheet and Meta Ads/Google Ads Script. Please provide a quote when applying.