Lock part excel spreadsheet jobs

I'm looking for a professional who can help me develop a market risk model monitoring dashboard. This dashboard will primarily be used by our Fund Manager to keep tabs on our public, privet funds. Key Features of the Dashboard: - Monitor key metrics such as VaR (Value at Risk), Exposure Limits, and Liquidity Ratios. - Provide a user-friendly interface for real-time monitoring and li... Exposure Limits, and Liquidity Ratios. - Provide a user-friendly interface for real-time monitoring and limit checking. - Include any breaches in predefined risk thresholds. Ideal Skills and Experience: - Strong background in finance and risk management. - Proven experience in developing dashboards. - Prior work with public and privet funds is a plus. The dashboard should be developed using Excel...

For some reason, I'm unable to download the last 10 years of OHLC Nifty 50 data from my Fyers account. I need a professional to access my Windows computer, troubleshoot the issue, and download the data in Excel format. Key Requirements: - You must be able to remotely access a Windows computer - Proficient in using Fyers and troubleshooting data download issues - Able to download data in Excel format Ideal Skills: - Experience with financial data and stock market - Proficiency in using Excel - Good troubleshooting skills

...a Flutter WebView wrapper that opens a React.js application, and I need AWS SNS push notifications integrated into it. The requirements are as follows: - On opening the app, the device token should be detected and sent to the server for registration and saving. This will not only be done on AWS, an API will be provided for this task. - The server will handle sending notifications to SNS - this part is managed by the backend developer, so no need for you to get involved there. - Notifications should be displayed as banner notifications on both iOS and Android devices. - User interaction with the notifications is not required. Ideal candidates for this project should have a solid background in Flutter and experience with AWS SNS. Understanding of React.js will be beneficial, as y...

I am an energy systems engineer and have developed some new multi-use infrastructure that is designed for commercial projects and generates multiple revenue streams as part of its business operations model. I have developed a fairly complex multi-tabbed business proforma financial model that works well to get close to modelling the economics of operating these assets. We have added a few new revenue models that have been confirmed from a business development perspective, and I would like to add these new revenues to the model without destruction of the original proforma. The model is business intellectual property and cannot be shared so I need to have an NDA signed and be highly confidential with the sharing of the model for improvement before awarding the project. These ar...

Looking to Setup WhatsApp Business API for our e-commerce platform. Want to send notification , receive photo video with data from the vehicle info ,record data in excel, find info using number plate finder api, and generate QR and provide delivery tracking. Also need to send invoice and Any one already worked on WhatsApp Business API and understand it at deeper level should only bid for this project.

...managing client information, and removing negative items from credit reports. Specific Tasks: - Handling disputes: You'll need to negotiate on behalf of our clients and ensure their concerns are addressed. - Managing client information: Keeping track of our clients' progress and ensuring their information is up-to-date and secure is crucial. - Removing negative items from credit reports: This is a key part of your role. We need someone who can get our clients' negative items removed swiftly to help them secure approvals for cars, houses, apartments, or loans. Ideal Qualifications: - Proven experience in the credit repair industry: You must have substantial knowledge of the credit repair business. - Demonstrable results: You should be able to show actual results o...

Hello,  I'm in need of a professional translator to translate the attached document from English into Canadian French. Requirements: - Translate every part of the document, - Deliver the translation as an MS Word file. -please use the pdf file as a reference. Budget: 8 $. Deadline: within the next 10 hours. Ideal Skills: - Excellent translation skills with attention to detail. - Quick turnaround time. Please confirm if you can deliver on time?

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: * Call logging: The tracker should allow for detailed logging of calls made by representatives. * Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: * Proficiency in Excel and data analytics * Experience with creating tracking systems * Understanding of sales and call metrics

I am looking for a freelancer who can help me find an entry-level Data Analyst or Engineer role in the USA. I am particularly interested in the technology sector, but I am open to any type of technology ...am looking for a freelancer who can help me find an entry-level Data Analyst or Engineer role in the USA. I am particularly interested in the technology sector, but I am open to any type of technology company, be it a startup, medium-sized company, or a large corporation. Skills and Tools: The ideal role for me would require proficiency in Python and SQL, as well as experience with Tableau and Excel, and PowerBI. I am looking for a freelancer who is well-acquainted with the tech job market, has great networking skills, and can help me land a position that matches my skills and as...

I need a spreadsheet expert to help me analyze data related to divorces. The primary purpose of this project is data analysis. Ideal skills and experience for the job: - Proficiency in Excel or similar spreadsheet software - Experience with data analysis - Ability to identify trends, patterns and insights from data - Strong attention to detail

I'm seeking a skilled architect who can submit a comprehensive design for a 2-bedroom house with guest rooms and accompanying landscape. A crucial part of this project is the ability to produce a 2D or 3D sketch that aligns with the tender request. Please do not bid if you cannot provide these. The ideal candidate will: - Have a modern design outlook. - Be able to propose unique and creative ideas. - Have useful experience in designing layouts for a big yard. Key features of the project include: - A 2-bedroom house layout, complete with guest houses. - An open floor plan, large windows and an outdoor entertaining area. This project will kick off with the creation of a milestone after we agree on a design you propose. Further projects will be assigned to the selected particip...

...___ What We Offer • $200 per sale paid instantly upon successful payment by the referred customer. • No caps or limits – the more you refer, the more you earn. • Flexible and remote – work from anywhere, anytime. ________________________________________ Why Join Us? • Quick and easy earnings: Earn $200 for every successful referral. • No upfront costs or commitments: Simply share and earn. • Be part of an impactful campaign: Help learners worldwide achieve their educational goals while earning money. • Open to all age groups: Whether you're 18 or 80, you can participate and earn! ________________________________________ How It Works 1. Share details about the educational product/package (website details will be shared) with your...

I need an Excel-based dashboard to monitor a maximum of seven items across 17 construction contractor packages. Key Data Points: - Budget and expenses - Change orders - Weekly progress reports per contractor - Resource allocation across all packages - Schedule tracking for each contractor package - Quality control measures and results Ideal Skills and Experience: - Expertise in Excel - Experience with data visualization - Familiarity with construction project tracking The dashboard should be easy to use, visually clear, and capable of tracking the aforementioned data points efficiently. Please use charts and graphs for the visualizations. Please use bar and line charts for the visualizations. Please include data filtering features to allow users to view specific subsets o...

I'm seeking an Excel expert with a solid background in accounting to enhance and redesign my current financial dashboard. Your role will involve improving the dashboard's design for better readability, adding insightful analytics, automating processes using VBA where possible, and creating custom visualizations and interactive elements. Key Tasks: - Improve the design and layout of the dashboard - Incorporate more detailed and insightful financial analytics, with a focus on ratio analysis and cost-benefit analysis - Use your expertise in Excel to ensure automation where possible - Design and implement custom visualizations, such as graphs, charts, pivot tables, and trend indicators - Create interactive elements to enhance user engagement with the dashboard Ideal S...

I'm looking for a proficient developer to create a WebAp...output of quotes, invoices, and processing of payments. Key Functions Include: - Form entry for data collection and processing information to output on a dashboard - Basic calculation functions, primarily for freight cost estimation - Integration with Excel to allow for variable data changes - Imitation of a sample WebApp we have, with additional custom features Data to be Processed: - Customer details - Job request details - Vendor details Ideal Skills: - Proficiency in WebApp development - Experience with Odoo integration - Familiarity with Excel for variable data input - Understanding of basic freight cost calculations Please provide feedback based on this description. We can further discuss the details in...

I need an Excel-based call tracker for my medical representatives. The project involves creating a spreadsheet with functionalities for call logging and analytics/reporting. Key Requirements: - Call logging: The tracker should allow for detailed logging of calls made by representatives. - Analytics and Reporting: I need the tracker to generate insights based on call outcomes. I will be manually entering call details, so the spreadsheet should be user-friendly and intuitive. Ideal Skills: - Proficiency in Excel and data analytics - Experience with creating tracking systems - Understanding of sales and call metrics

I'm in need of a straightforward Android application to facilitate selling medicine online. It should ideally be a no-code app, as I also require a free version for market testing. Key Features: - A comprehensive product catalog, complete with a search function to help users easily find what they're looking for. - Integration of a secure online payment system, as transactions will be a crucial part of the app's functionality. User Registration: - All users should be able to register via email or mobile number. In addition to the above, the ideal freelancer for this project should have a solid background in app development, specifically for the Android platform. Experience in creating e-commerce applications will be a significant advantage. Understanding of no-code...

I have a licensed Tally installation on an AWS EC2 Windows instance. There are 7 Tally users within our organizat...Firewall rules / IP-based restrictions TDL customization (if needed, though prefer network- or OS-level solution) Security & Reliability: The solution should be robust and secure, preventing credential or device spoofing. Documentation: Need clear instructions on setup and ongoing maintenance. What I Need from You: Assess our current AWS EC2 + VPN + Tally setup. Propose and implement a method to lock down Tally access by device for each user. Ensure any changes (firewall, certificate, RDP gateway, etc.) are well-documented. Provide a short training or handover so we can manage user/device changes in the future. Prefer VPN certificate/device binding to restrict ...

I'm looking for a professional to convert my VB6 project to VB.Net. The conversion will not be a straightforward conversion; I need a thorough review of certain parts of the application to enhance functionality and performance. Key areas of focus during the conversion: - User Interface: The forms and dialogs, as well as custom controls, will need significant attention. I'm ai...each time the work to do using live video conference. I will work at the project too, so we will work at the same github repository. I am not currently looking to add any new functionalities during the conversion, but I am open to suggestions for enhancements that could improve the overall performance of the application. The pay i'm specifing is low because it will be delivered for each little ...

I'm looking for a video editor who can help me edit short mini documentary-style videos. The ideal candidate should be familiar with Korea, able to communicate effectively, and respond quickly. While experience in animation is a plus, it's not a necessity. A crucial part of the job will be researching materials and incorporating them into the video in a compelling way. Key Responsibilities: - Editing video content with a focus on storytelling, visual effects, and sound design - Researching materials and incorporating them into the video - Communicating effectively and responding quickly to feedback Ideal Skills: - Video editing - Knowledge of Korea - Research skills - Animation experience (not mandatory) - Exceptional storytelling and sound design skills.

I'm looking for a sleek, modern, minimalist design for my home page. The ideal freelancer for this project would be a designer with a strong portfolio in creating clean, uncluttered web designs. The mockup should include: - A Hero image or banner: This will be the first thing visitors see, so it should be striking yet in line with the minimalist theme. - A Feature section: This part of the page will highlight key elements or offerings. A knack for visual hierarchy and clear communication through design will be essential here. - A Testimonials section: I want to build trust with visitors through social proof, so this section should be designed to showcase client testimonials effectively. The primary goal of the home page hasn't been defined yet, but it would likely lean t...

I'm looking for a skilled Android developer to create an app with 4-5 dynamic pages. The primary purpose of this app is information delivery, specifically educational content. Key Features: - The app will need to deliver various types of educational content. - It will also need to include quizzes as part of the interactive elements. - The app should include user authentication to personalize content delivery. - Implement user progress tracking to monitor educational advancement. - Include push notifications to remind users of upcoming quizzes and new content. - Ideal Skills and Experience: - Prior experience in developing Android apps, particularly for educational content, is highly desirable. - Proficiency in designing dynamic, user-friendly interfaces. - Experience in in...

I'm looking for a data consultant to help with consolidating and analyzing a large number of Excel spreadsheets. The project involves: - Data Consolidation: Merging data from different spreadsheets into one cohesive dataset. - Pivot Tables: Utilizing pivot tables to summarize and analyze the data. - Lookups: Using lookup functions to cross-reference and find relevant data points. - Splitting of Files: Organizing and splitting data into manageable files. Ideal Skills: - Advanced Excel skills: Proficient in using Excel functions, formulas, and features. - Data Analysis experience: Previous experience in analyzing large datasets. - Attention to Detail: Ability to spot inconsistencies and errors in the data. - Time Management: Capable of working efficiently to meet ...

I'm seeking an expert in Excel who can assist with automating calculations and report generation in my bonus allocation workbook. The project requires the creation of a couple of bar and line charts, as well as help designing a tier-based system reliant on weighted project amounts determined by various financial metrics. Ideal skills and experience include: - Proficiency in Excel with a strong understanding of automation features - Experience with creating and interpreting bar and line charts - Knowledge of financial metrics and their application in project weighting - Ability to design a tier-based system. - Expertise in data visualization techniques The successful freelancer will help streamline my workbook, making it more efficient and user-friendly. The goal is t...

I'm seeking a personal assistant to help manage the bookkeeping for my stock trading account. Key responsibilities include: - Monitor trading activity for recording - Record and reconcile all transactions - Prepare trading journal and stock charts screenshoots - Ensure accurate and ti...data entry or bookkeeping, and excellent attention to detail. They should also be proficient with reading stocks price candle charts, having basic knowledge of stock trading (not mandatory), and proficient in using numerous tool for Visual illustration of trading journal, Microsoft office software with English language as these tasks may also be required. Candidates should be proficient in using Excel for financial record-keeping. The assistant will be required to handle bookkeeping tasks d...

I'm looking for a ChatGPT specialist who can integrate this AI tool into Excel for generating reports based on hospital data. The ideal freelancer for this job should have: - Proficiency in Excel and ChatGPT - Skills in AI integration - Report generation expertise Please note that the specifics of the report content have yet to be determined, so flexibility and creativity will be key to this project.

...Proficiency with procurement software and tools - While education is a plus, practical experience is what truly matters! What We Offer: - Competitive salary and benefits package - Flexible work arrangements - The chance to grow within a dynamic and expanding company - A collaborative and supportive team environment Ready to take the next step in your career? Apply today and become part of our team!...

...customer service when scheduling appointments with clients or stakeholders. - Comfortable using various digital tools and software for scheduling. Experience: - Prior experience in administrative roles is preferred, especially with scheduling tasks. - Experience with managing calendars for busy professionals is a plus. The expected volume of appointments is less than 20 per week. The role is a part-time remote position. The assistant will be required to work during standard business hours. Prefer communication to be primarily through email. The assistant should be very flexible with adjusting working hours for different time zones. The assistant will be responsible for scheduling appointments in different time zones. The assistant will be managing appointments related to con...

I'm seeking a skilled graphic designer to create a unique and vibrant logo for my business. The logo should be a combination of both text and an icon. Key requirements: - Experience in designing modern, bright and vibrant logos - Strong graphic design skills with a focus on minimalist, yet impactful designs - Ability to create a balanced and appeali...requirements in your proposal. Here's our thoughts for the logo. We're thinking having a pyramid made of stacked gold bars with a sphinx centered in front and a pharaoh's head on the sphinx. See attached files to help with understanding. Gold and shades that compliment gold bars of the pyramid and the sphinx Please use a font style of something that shows strength and elegance for the text part of the logo. C...

Source an image of 90 well known people. The list of names is provided in a spreadsheet. Photo requirements: • Minimum of 800px width (no max) • Players hands must be visible Image Editing Requirements • Put a black mask on the image except for their hands • Save two versions of the image, the original and the masked • The names of the files should be the persons ID, which is included alongside their name in the list you will be provided. The masked image should have _b at the end. • Example: o (original image) o (masked image) Important The source of the image should be added to the spreadsheet. E.g. The Times, The Guardian

I need assistance with matching two lists of brand and company names. The data is in Excel format. - The first list has 4 columns and the second list has 1 column. - The type of matching required is 'fuzzy match'. Ideal skills for this project include proficiency in Excel, experience with data analysis, and knowledge of fuzzy matching techniques. The work needs to be completed by Friday morning India time .

I'm seeking a skilled developer for a neobank system with robust fraud prevention features. Key Requirements: - The system should include an identification ID and selfie functionality. This will be pivotal for user verification and primarily for fraud prevention purposes. - The system needs to incorporate biometric verification and document verification as part of its fraud prevention features. - The ability to manage customer accounts, process payments and conduct financial analytics is also essential. Ideal Skills: - Proficiency in developing secure and efficient neobank systems. - Experience with implementing biometric and document verification systems. - Familiarity with customer account management, payment processing and financial analytics features. - Strong understand...

...it, or you create a separate source file for me that does all. The source file API should provide maximum 2 functions in main loop: ble_Init and ble_Tick to initialize and then update the ble state machine. Then I will need a function to write data to BLE service, which at the moment I think is `Cy_BLE_CSCSS_SetCharacteristicValue` (based on Infineon API) and it is potentially not needed to be part of the provided source file. The project can be done using two Infineon Evaulation boards () which you can buy at your local Embedded hardware store or online retailers. The expected maximum timeline for the project is end of February. The final test case also includes that I am able to connect with a mobile phone (BLE

I am currently in China and work as an online Brand Design AIGC Designer. I am proficient in integrating Artificial Intelligence Generated Content (AIGC) technology into brand design, creating unique and creative visual identities for brands. At present, I am doing part-time brand design work for a Chinese company, and I have accumulated certain practical experience in logo design, brand visual identity system construction, and other aspects. I am eagerly looking forward to more stable and long-term job opportunities to further demonstrate my professional skills and create greater value. If you can successfully recommend a suitable job for me, I am willing to offer 10% of my first-year salary as a reward. To give you a more comprehensive understanding of my capabilities and past exp...

I need assistance with handling customer data. Key Responsibilities: - Data entry - Data analysis - Data cleaning The ideal candidate should: - Be proficient in Excel. - Have experience with data management and analysis. - Be capable of cleaning and maintaining data integrity. Please note that tasks will be primarily focused on customer data.

I'm in need of a field verification executive for assisting in conducting residence, office, business and document verification du...cover the following locations: Rajasthan, MP, UK, UP, Delhi NCR. All visits will be supported by visit photographs with Selfee of executive and Geo tagged. Verifications will be conducted multiple times in a day. Each verification must be completed within 24 hours. Verification reports should be detailed and comprehensive. The verification reports should be delivered in the format: either on call, excel, or informed punched in our software or shared over email with photographs evidence of visit duly geo tagged. Reports should include a basic summary of findings. Verification tasks will be assigned daily. Verification tasks are expected to be betwe...

I am in need of a CAD expert to help design a choker-style ring. Ideal Skills and Experience: - Proficiency in CAD software - Experience in mechanical part design, particularly jewelry - Creative mindset with an understanding of choker aesthetics

I'm looking for a UI expert who can provide me with guidance primarily on design aesthetics for a modern style mobile interface. I have already launched the app on playstore but i need expert guidance from some ui expert to make the app's user experience, UI much better and professional looking, making it worth paying a subscription fees. You do not need to do any coding, i will do all the coding part you just have to guide me what should be done or added where. Key Requirements: - Expertise in modern mobile UI design - Strong understanding of design aesthetics - Experience in mobile platform UI design Your role will be to help refine the design to be sleek, user-friendly, and aesthetically pleasing in line with modern design principles. If you have a portfolio of succ...

I'm in need of a seasoned professional who can design a prefab steel structure for an industrial warehouse. This will be a crucial part of our operations, so the design must be top-notch. Key requirements: - The structure must be designed for warehouse and storage use. - It should incorporate temperature control features. This is vital for storing products that are sensitive to heat or cold. - It must have a heavy load-bearing capacity. We will be storing heavy items, so the design must ensure safety and durability. Ideal candidates for this project would have a strong background in industrial design, particularly with steel structures. Experience in designing for warehouses will be a significant advantage. Please include examples of relevant past work in your proposal.

...participant of the Ocean Lead calls and will enter the service delivery workflow. He'll do all the tasks assigned to him for the day and report back on the daily meeting. He needs to have proficient English, enough to be well understood and very good at writing. He needs to be willing to go the extra mile, to help us create pages, learn new softwares and technologies. Will come on board as a freelancer/part-time team member, but in the future if everything goes well, he will be brought on as a full-time member. We're looking for someone tech versed that likes the day to day, and doesn't have a personal brand. We're looking for someone honest and transparent. We're looking for someone open-minded willing to learn and very result drive - wants to get ...

I have an Excel workbook that has an error in the February tab. The daily totals are not posting in the correct cells. I need you to fix this issue and ensure that the tab matches both the layout and the formula structure of the January tab. Additionally, I need the remaining months of the workbook resized to look like the January tab. Ideal skills and experience for this job: - Proficiency in Microsoft Excel - Strong analytical skills to identify and rectify errors - Prior experience with data management and workbook formatting - Attention to detail to ensure accuracy and consistency

January Content plan final part - FR

...owner seeking a salesgirl for weekend exhibitions. The role is part-time, with the possibility of transitioning to full-time with added responsibilities. Experience certificate will be provided for more than a year association. Key Responsibilities: - Sales at weekend exhibitions from 10am to 9pm. - If full-time, additional duties include online sales, inventory management, product photography and order processing. Ideal Skills: - Knowledge of fashion jewellery - Strong sales and negotiation skills - Customer service experience is a plus Full-time Role: - In a full-time capacity, responsibilities will expand to include online marketing and inventory management. - Jewellery photography and edits. - Order processing will also be part of your duties. Online Sales Tasks:...

...has experience with Square and putting it in iOS Apps (I prefer Swift). I have quite a bit of experience but doing Square iOS stuff just frustrates me. I already have an endpoint set up to accept the payment token and all the credentials loaded. I'm just having trouble getting it to work smoothly with credit cards. And the sample app has structure for Apple Pay and I've done the certificate part but I think some code is missing to get Apple Pay to work too. I would like to get both working. Someone who knows Square already would be able to do this quickly because I can do it for web quickly - I'm just not as good with native iOS. here's the quick start iOS App I'm using:

I'm experiencing issues with Excel's conditional formatting and need an expert to help. Key issues: - Cannot copy entire conditional formatting rules across the spreadsheet. Ideal skills for this project: - Advanced Microsoft Excel expertise - Proficiency in identifying and resolving Excel-related issues - Strong understanding of conditional formatting techniques Please provide regular updates via remote. The troubleshooting will be for Excel 365.

I'm seeking an instructor to help me grasp the concept of optimization, focusing primarily on Linear Programming. As a beginner with Excel Solver, I need someone who can guide me through solving questions with various constraints. Key Requirements: - Expertise in Linear Programming. - Proficient in teaching Excel Solver. - Capable of explaining different types of constraints depending on the case study. -solve with me questions Ideal Skills: - Advanced knowledge of optimization techniques. - Strong communication and teaching skills. - Experience in using Excel Solver for complex problems. As the type of constraints we will be working with will depend on the case, I require a flexible and knowledgeable instructor who can adapt to different scenarios and explai...

I have approximately 3000 rows of data spread across three Excel 365 sheets. I need someone to extract, link, and manage this data for me. The final deliverable will be a detailed report in Excel. This report should include: - Data summaries - Trends and patterns - Comparative analysis PEASE REFER TO THE ATTACHED EXCEL FILES WHICH WILL BE USED THE SCOPE FOR THE BID IS IN THE WORD DOCUMENT There's no need for complex formulas, but the ability to identify and highlight these aspects of the data will be crucial. Your expertise in data management and proficiency in Excel will be key to the success of this project. THANK YOU FOR THE TIME TO READ AND BID

...across my website and both iOS and Android apps. - It should incorporate interactive animations, engaging users and enhancing their experience. - Various user actions should trigger these animations; earning points, redeeming rewards, and achieving milestones. There should also be animations for a spin wheel, scratch cards, and a lucky draw. - Allow users to create and customize their own avatars as part of the loyalty program. - Include options for users to share their milestones and rewards on social media platforms. - Provide personalized reward suggestions based on user behavior and preferences. - Implement different loyalty levels, with each tier unlocking special rewards and exclusive animations. - Send push notifications to users about new rewards, points status, and miles...

...can deploy it on iOS devices too. I have acquired a G4 Mac for this purpose. The MAUI app works as intended on the ios simulator and Android devices (it translated into C#/MAUI quite easily). The problem has been deploying it to AppStoreConnect so my testers can get ahold of it. This process has taken me *far* more time than anything else so far. Your mission would be to talk me through this part of the project (Setting up the the AppID's, Development & Distribution Certificates, Associated Profiles, etc) so that I can deploy it to AppStoreConnect. Fair warning: This is not as straightforward under MAUI as it would be writing a native ios app. There are things I am finding out that you would normally expect do for you that must be done "the hard way". I...

I am looking for a data operator to assist with a complex data entry project. The ideal candidate should have experience in data entry from digital files, specifically using Microsoft Excel. The work involves significant formatting and clean-up of the data. Skills and experience required: - Proficiency in Microsoft Excel - Strong attention to detail - Ability to handle complex data entry tasks - Experience in formatting and cleaning up data - Experience with creating and using Excel Macros 1 year If you are meticulous, experienced in data entry, and proficient in Microsoft Excel, please apply for this project.