Split excel sheet into multiple files jobs
...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 operational costs. Ideal freelancers for this project are those with a strong background in finance, and business strategy with a proven record of crafting investor-attracting business plans for companies. They should know how to capture an RCM business' essence, mould it into a robust and coherent plan,...
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 have a large volume of numerical data that needs to be entered from multiple digital files. The files will be provided to you in a digital format. Key Requirements: - Data Entry: Accurately input numerical data from digital files into a specified format. - Efficiency: Handle a substantial quantity of data in a timely manner. Ideal Freelancer: - Proficient in data entry with experience in handling numerical data. - Attention to detail to ensure accuracy. - Previous experience with large-scale data entry projects is a plus.
WeI have recently completed a cross-platform app companion for a exciting new toy and I'm in need of comp...in testing game mechanics. - Graphics and Visuals: The scope of testing also includes checking the graphical output of the game. Testers with an eye for detail and a keen sense of aesthetics would be a great fit. - Multiplayer Functionality: Another key area for testing is the multiplayer functionality. The tester should be adept at inspecting the seamless connection and interaction between multiple players. Prospective testers should be proficient in cross-platform applications and have a solid track record in detecting and reporting issues that can affect end-user experience. Testing will be done in person in the Los Angeles area. Must be able to arrange transporta...
I'm looking for a skilled individual to erase logo watermarks from a collection of approximately 700 JPEG and PNG principally images. Each image contains a watermark of medium complexity that needs to be professionally and thoroughly removed without compromising the quality and integrity of the image. Key Req...principally images. Each image contains a watermark of medium complexity that needs to be professionally and thoroughly removed without compromising the quality and integrity of the image. Key Requirements: - Keen eye for detail to ensure complete logo removal - Ability to maintain the quality and integrity of the JPEG images Prior experience with similar projects will be highly beneficial. We split the project in 7 pack of 100 images to finish fastly Bid per a pac...
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
Data entry operator and my work very clear
I'm seeking an experienced AutoCAD designer to create detailed plans for an industrial HVAC system. This project involves: - Des...seeking an experienced AutoCAD designer to create detailed plans for an industrial HVAC system. This project involves: - Designing air conditioning units - Sketching ductwork and piping - Planning heating units Proficiency with AutoCAD is a must, especially in the realm of HVAC planning. Previous experience with industrial HVAC systems would be greatly beneficial. The scope of this project covers multiple jobs and varied square footages, requiring dynamic design adaptability. Please provide relevant portfolio examples when placing your bid. I look forward to working with someone who can bring efficient and effective HVAC solutions to life on dig...
... Key Features & Integrations: - Real-time group chat: Capable of supporting multiple users concurrently in a chat room. - Private messaging: One-to-one private chat functions. - Email, Payment, and Social Media integrations: The platform should seamlessly connect with these services for a holistic user experience. Supported Platforms: - The socket connections and integrations should be compatible across web browsers, iOS devices, and Android devices. Ideal Skills & Experience: - Proven experience developing real-time chat modules with P2P messaging. - Solid background in integrating email, payment gateways, and social media into web apps. - Proficient in making the functionalities compatible across multiple platforms including web, iOS, and Android devi...
I'm looking for an experienced professional in Excel to create a custom financial tracking template for me. Bonus if compatible with both google sheets and excel. Key Elements: - The template needs to include sections for tracking income and expenses. - Additionally, I need sections for debt repayment tracking and Year To Date (YTD) tracking. - The template should be designed in a way that it is easy to update monthly Ideal Skills: - Proficiency in Excel and experience in creating financial tracking templates. - Knowledge of financial principles and ability to design a user-friendly, visually appealing template. - Attention to detail and ability to customize the template to meet my specific requirements. Please include samples of similar work you've done ...
...enhance user experience but also significantly increase our conversion rates and improve overall brand perception. This will be a challenging yet rewarding task as the design will cater to two distinct yet significant target audiences - Millennials and Parents. Key Requirements: - Proficiency in creating UI/UX designs for Mobile, Web, and Desktop platforms - Prior experience in designing for multiple target audiences - A strong portfolio showcasing designs that have successfully improved conversion rates and enhanced brand perception - Understanding of Millennial and Parent demographics and their digital behaviors Ideal Skills and Experience: - Strong command of UI/UX design principles and best practices - Excellent communication skills to understand and implement client requir...
...creating beautiful and functional websites that convert visitors into leads and sales? We're looking for a talented freelance web designer to join our team on a project-by-project basis! About the Projects: Conversion Optimization: Craft high-performing lead generation pages designed to maximize conversions. Website Refresh & Redesign: Breathe new life into existing websites, from simple design tweaks to complete overhauls. Conceptualization & Build: Bring client website visions to life, from wireframing to launch. Ecommerce Development: Build user-friendly and visually appealing online stores. Your Skills: Proven experience creating websites using WordPress and front-end builders - Divi. A plus: Ability to build on multiple platforms for smooth ...
I'm seeking a developer with strengths in cryptography, blockchain, and who is proficient in Solana to help me develop a decentralized wallet application. This wallet application should have the ability to: - Create and manage multiple wallets. - Send and receive cryptocurrency. - Provide a clear and detailed transaction history. - Execute multichain swapping of digital assets. - Handle 2 custom coins designed for our ecosystem. In addition to these functionalities, the app must run on both iOS and Android operating systems. Moreover, I'd like to collaborate with someone who has a knack for developing user-friendly interfaces. Your expertise can assist us in providing a seamless and engaging user experience. Finally, if you have previous experience in ICO website deve...
Excel Chart Re-Design for University Work Allocation System We are looking for somebody to complete the development of an excel-based teaching allocation database for a relatively large university department (approx 100 teaching staff). We currently make use of an excel template that roughly cross-references university courses with teaching staff and allocated time commitments for specific tasks. This is quite a complex information array, however, with so many staff members and courses (approx. 120), especially where multiple staff members are co-teaching courses with different task responsibilities. While our current template achieves its desired information management purpose, in its present state its structure is relatively complex and not user-frien...
Looking for an expert who can bring my educational content to life with vibrant, engaging 3D animations. The animations should be a blend of character-based and abstract to maintain viewer interest. Key Requirements: - Skilled storyteller through 3D animation. - Experience in character-based and abstract animation. - Excel in conveying complex information simply and clearly, ideally within an educational setting. - Ability to work collaboratively, ensuring your creations align with my vision. Enhance your bid with relevant work samples, especially animations used for educational purposes. I am excited to see your creativity at work!
...beverages engineer who specializes in food processing to work on an exciting project in Saudi Arabia. The primary goal of the project is to assist in expanding our business by opening new branches. To do this, I need a professional who can help in the following areas: - Developing standardized recipes: The freelancer should be skilled in creating standardized recipes that can be replicated across multiple locations. These recipes should be not only delicious but also cost-effective and scalable. - Scaling up production capacity: The selected individual should have experience in increasing production capacity without compromising on the quality of the food. They should be able to design and implement production processes that can meet the demands of a growing number of locations....
I need a skilled Photoshop expert to help with retouching images and removing the background and adding a blurred greenery The job entails: - Retouching images to improve overall quality. - Removing the background from images. Touching up bruise on little girls knees and slight bruise on forehead Please note the file format of images hasn't been specified, so you mu...improve overall quality. - Removing the background from images. Touching up bruise on little girls knees and slight bruise on forehead Please note the file format of images hasn't been specified, so you must be able and ready to work with various formats. Ideal candidates have ample experience in Photoshop, specifically in image retouching and background removal. Proficiency in working with multiple fil...
I am looking for a proficient app developer to create a TV application that will function on Android TV, TizenOS (Samsung), Fire TV (Amazon), and LG Smart TV. The ideal candidate for this job should be experienced in developing apps for multiple platforms. Description We're seeking a skilled freelancer to develop a TV app for Android (v5-13), TizenOS (Samsung 2012-2024, Tizen 1-8), Fire TV, and LG platforms. Skills required: - TV app development - Android - TizenOS - Fire TV - LG - User interface design - Performance optimization - Problem-solving - Strong communication skills App Features: Responsive UI for various screen sizes Displays Live, Series, and Movie content (data from web service) User favorites list (local & online storage) Playback resume from last positio...
I am looking for an expert with an understanding of C# and C++ programming languages to integrate a C# DLL into a C++ application, predominantly for user interface integration. - **Main Task:** Establish communication between the C# DLL and the C++ application to call specific custom functions. - **Specific Functions:** The task involves calling custom functions from the DLL, which are part of a standard. - **Experience:** A successful candidate must have a deep understanding of DLL, C++, and C#; and a track record of integrating DLLs into applications. - **Skills:** DLL, C++, C#, software architecture. The main goal is to enhance the functionality of the C++ application by using this C# DLL. This project is likely to involve overcoming language limitations and potential s...
Website on Wordpress License key generator with DB API for Excel Template connecting to DB for license key validation. Dashboard for administrator enter buyer/customer account credetials. The administrator must be able to enable and disablle accounts. Update Excel Template LicenseValidation code for connectiing to API/DB. I will privide this Excel Template code file.
...audio files of Recitations in Bengali. So, I am looking for only Bengali Video creators who can understand and make it a success. Below are my requirements for each Video: 1. Video will start with the introductory music and images of the Original Author and Album with the vocalists image and name in short 1. Each video should be created with multiple royalty free sketches, paintings and images which are fit to the poem sentences/situations 2. Each video should have background music according to the theme of the recitation. 3. Audio quality should be edited through different tools like Noise reduction, Auto duck, Decibel control and studio effects. But, original voice should not be tampered. 4. Error in the audio file should be removed and maintain the pitch I have 50+ ...
I am hoping to find an expert to create a versatile chat bot for my operation. The bot will be integrated with an AliExpress API and tasked with handling customer inquiries in multiple languages. Key Features: * Answer customer questions: The chat bot must be designed to manage and respond to various customer inquiries. Not only should it offer general support, it must provide specific responses related to product offerings being sold on aliexpress * The chat bot should be able to respond with relevant products according to the inquiry that will be offered to the client via affiliate links * Multilingual Support: The bot should have the capability to handle inquiries in various languages. This feature is vital as we cater to a diverse, international market. * Interaction Styl...
I need an Excel expert to update my spreadsheet. The main tasks include: - **Formulas and Calculations:** I require formulas to be implemented for various calculations. The freelancer should possess a strong understanding of Excel functions and be able to apply them accurately. - **Formatting:** The formatting of the spreadsheet needs to be updated. This includes: - **Font Styles and Sizes:** I need the text in the spreadsheet to be consistent and visually appealing. The freelancer should have a good sense of design and layout. - **Number Formats:** Incorrectly formatted numbers need to be corrected. The freelancer must be meticulous and detail-oriented in this aspect. - **Color Changes for Expired Dates:** An important part of the project is changing the color of cel...
I have a whm server with multiple wp blogs using wp automatic, a plug-in that has had multiple backdoors over the years, the plug-in is updated but the server probably has shell scripts or malware running
I'm looking for an experienced Excel and PineScript expert to create custom Excel formulas replicating my developed PineScript indicator. The indicator performs functions for Bollingerbands and Keltner Channels. The task will be to incorporate Open, High, Low, Close prices into the Excel formulas. Please note, data collection or data visualization is not required for this project. To give your best, you should possess an advanced understanding in: - PineScript - Creating complex Excel formulas Looking forward to your informed bid.
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 information and product inventory m...
...available fields into an Excel (.xls) file. The database consists of approximately 150,000 entries. Each record includes data such as name, business name, contact information, date of foundation, etc. Ideal Skills: - Strong experience in Web Scraping - Proficiency in transferring data into .xls format - Attention to detail to ensure all available fields are captured Purpose and Deliverable: - The objective of this project is to use this information for data analysis. - The final output will be an Excel (.xls) formatted file containing each scraped database entry. Operation Specifics: - You would be required to locate and scrape the database by Zip codes. - A full export of all accessible information per entry is needed. Your expertise in internet re...
I'm in search of a meticulous data entry specialist to help with a simple text data entry task. The job is quite straightforward, involving the transfer of information from digital files to a different format. The role strictly involves data entry without the need for any form of data analysis. Key responsibilities: - Accurately entering text data from digital files into a specified format. Ideal Skills and Experience: - Proven experience with data entry. - Attention to detail. - Proficiency in working with digital files and transferring data.
...Whatssap. The core purpose of this tool will be to check if the numbers on my list are active on Whatssap. The end goal is to utilize these numbers for promoting my business. Key Features: - Bulk Phone Number Verification: The tool should be able to check multiple phone numbers at once. It should separate the active numbers from the inactive ones. - Whatssap Compatibility: The tool needs to connect with Whatssap API to confirm the activity of the numbers. Delivery: - Data Export: I require the verified numbers to be exported to an Excel spreadsheet for easy access and use or .txt file Skills & Experience: - Proven experience in API integration, specifically with Whatssap. - Strong programming and software development skills. - Experience in building phone number ...
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.
...in HTML, CSS, and JS - no frameworks. As part of this project, you will deliver a sleek and modern looking school management system. Key Responsibilities: - Given the nature of the project, an aptitude for clean and contemporary web design is crucial. - Deliver complete website code and database. - Although it wasn't specified in the project outline, it is important to cater for possibly multiple user roles. This could include Administrator, Teacher, Parent etc., each with differing access rights and features. - Despite not having mentioned specific system features, suggested must-have features include student attendance tracking, gradebook management, and a system for parental communication. Ideal Skills: - HTML, CSS, JS expertise - User-centric design experience - D...
I need an assistive hand in a data extraction task that requires sharp focus and meticulous attention to detail. The task involves: - Extracting email addresses from an Excel spreadsheet - Maintaining accuracy and precision during the data entry process, ensuring no data is missed or inaccurately entered Proficiency in Microsoft Excel is a must for this task. Previous experience in data extraction or data entry is highly desirable. You should be adept at handling large volumes of data, have a keen eye for detail, and are able to keep track of your progress systematically. Let me know your capacity per day/week as this can be an ongoing project. Please dont negotiate on the price beyond the Bid provided
Hi all, we currently have a website developed in WordPress which is very slow. i would like your reccomendation on a platform for new website to be fast and have many features: pricing specials, qty discount, subscrip...ability to modify the website, products, SEO, add pages.. Key Requirements: - Integration with PayPal, Stripe, and Square payment gateways - User-friendly interface and seamless navigation - Inventory management system - SEO optimization - Responsive design for mobile and desktop Ideal Skills and Experience: - Proficiency in E-commerce website development - Previous experience with integrating multiple payment gateways - Strong understanding of SEO best practices - Knowledge of inventory management systems - Proven track record in creating user-friendly, responsiv...
For my company, I need an expert with extensive experience in data consolidation and import to QuickBooks. - The project involves the migration of the company's financial data for the years 2022 and 2023 which is stored in Excel spreadsheets currently. - The data needs to be consolidated into a single file before importing into a new Quickbooks instance. As an ideal candidate, you should have: - Experience with Quickbooks data import - Excellent understanding of data consolidation - Proficiency with Excel spreadsheets - A keen eye for detail and the ability to maintain the integrity of financial data during the import process.
I need help crea...generating detailed contract reports and analytics. - Payments Tracking: Ability to track payments stemming from each contract. - Supplier Account Statement: Functionality to maintain and access supplier account statements. - Editing Contracts with Variables: Flexibility to modify contracts with various variables. The software is to be used by a team of 1-10 people, making it important to have multiple levels of access controls. Ideal freelancers should have experience in programming and software development, with specific skills in building contract or document management systems. A strong understanding of data security is also recommended for the storage feature. This project requires both a keen attention to detail and the ability to create an intuitive user-...
I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that ensures the privacy and integrity of the financial and customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security...
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 attached...
...receptionist (if they are busy, we will assist you right away). Panel: Receptionist sees that there is a call listening to the purchase announcement, or if she has a balance she sees that there is a call coming in. She also sees call/s queued to be received on hold if there are any. - Logged in receptionist answers the call on your landline. Panel: The receptionist sees the client's information sheet, name, phone number, comments, purchase history, balance, etc., modifiable. The purchase option also appears in case the customer wishes to purchase more balance. Here the receptionist sees the list of busy and free agents, and selects a free agent to transfer the call she is answering. - Receptionist has already transferred the call. Panel: the receptionist can see in real time...
I'm looking for a marketing expert to help me boost sales by reaching young adults between 18-34 years through various marketing channels. Key Responsibilities: - Develop and execute a comprehensive marketing strategy aimed at...between 18-34 years through various marketing channels. Key Responsibilities: - Develop and execute a comprehensive marketing strategy aimed at driving sales among young adults. - Identify and utilize the most effective marketing channels for this specific demographic. Ideal Skills: - Proven experience in marketing to young adults, preferably in a product-oriented environment. - Expertise in multiple marketing channels, particularly those that cater well to the 18-34 age group. Salary based on how much products you sell. If you sell 6 products you ...
I'm seeking a skilled Web Developer experienced in WooCommerce who can help me customize the "Add to Cart" functionality on my online store. Due to the lack of specific parameters or features on the project, you should be comfortable with uncertainty, able to think creatively, and approach challenges proactively. Responsibilities may include but are not limited to: - Add multiple size variation in same time - Custom product with module - Add to cart all product in same time
I'm seeking a talented logo designer to create a classic and traditional combination logo that will be used both online and in print. Key Requirements: - Classic and Traditional Style: The logo should evoke a sense of history and timelessness. - Combination Logo: While the logo should include both text and symbol elements, they should work together seamlessly. - Usability in Multiple Mediums: The final design should be versatile enough to be used across online platforms and in physical print. Ideal Skills and Experience: - Proven experience in designing combination logos. - Adept at creating classic and traditional logo designs. - Understanding of the nuances of designing for both online and print mediums. Please include a link to your portfolio showcasing similar work in yo...
I am currently seeking a skilled freelancer capable of developing multiple bots for the private game servers in a game called Ragnarok These bots are expected to carry out a myriad of tasks which include, but aren’t limited to; • Advanced character leveling • Detailed item farming • Skill automation Additional features essential for these bots to possess are: • Auto potion consumption: The bot should be able to intelligently consume potions whenever required • Mob detection and avoidance: Bots must have the ability to detect and evade mobs automatically • Chat filter: It should be able to interact with other users by filtering out specific keywords or phrases There is versatility in the choice of code we are willing to accommodate for thi...
I'm seeking a talented logo designer to create a classic and traditional combination logo that will be used both online and in print. Key Requirements: - Classic and Traditional Style: The logo should evoke a sense of history and timelessness. - Combination Logo: While the logo should include both text and symbol elements, they should work together seamlessly. - Usability in Multiple Mediums: The final design should be versatile enough to be used across online platforms and in physical print. Ideal Skills and Experience: - Proven experience in designing combination logos. - Adept at creating classic and traditional logo designs. - Understanding of the nuances of designing for both online and print mediums. Please include a link to your portfolio showcasing similar work in yo...
I'm in need of a skilled and reliable individual that can help me estimate costs for 3 different construction projects. These projects are distinct and require a thorough understanding of the construction industry and its associated costs. Key Re...market. Ideal Skills and Experience: - Proven experience in construction cost estimation - Proficiency in estimating various materials such as concrete, electrical work, plumbing, carpentry, painting, general labor and roof tiling - Understanding of construction labor costs - Strong analytical skills and attention to detail. If you have a background in construction estimation and can handle multiple estimations simultaneously, I'd love to hear from you. Please provide evidence of your past work in this field to help me make a...
I need a skilled content creator to help me produce 1-minute long TikTok videos that have a suspenseful tone and target young adults. The videos will revolve around mystery quizzes. Key Project Details: - Video Content: The content will be centered aroun...around mystery quizzes. Think of questions like 'who murdered who', and similar themes. - Target Audience: The videos should appeal primarily to young adults. - Tone: The tone of the videos should be suspenseful to keep viewers engaged. Content Requirements: - Video Length: Each video should be approximately 1 minute long. - Quiz Format: The mystery quizzes should be designed in multiple formats, including multiple choice, true or false, and open-ended questions. Example: I need 30 videos/month
We are a group of developers. We need a webRTC expert to give us guide and assistance of how to integrate our AI model into the Odoo 16 webRTC. We have already build the AI model, the webservice and endpoint to commnicate with it and everything related to the AI. So far we have a module that connects with our AI server, everytime an odoo channel is created it reviews the messages, sends it to the AI and creates a new message in the channel that acts as a reply To achieve this we follow the next structure: 1) redefine create on 2) send message body to IA 3) get message and post a message on the channel So far this works on internal chats, but we want this to work on live chat sessions, the idea behind this is that the clients communicate with the IA With the current code we
I am in immediate need of a professional with proven experience in writing legal Partnership Agreements. Specifically: - Proficiency in drafting Partnership Agreements is crucial. - The agreement must excel in providing measures for protecting sensitive information. - Understanding of confidentiality and data protection is mandatory. I am expecting work that is thorough, legally sound and protects my interests optimally. It is not about just getting it done but getting it done right. Previous experience with such documentation is a solid advantage. Kindly share your portfolio when applying. Accuracy, attention to detail, and understanding complex legal terminology are the skills that I am looking for. NB: Experience with sensitive information protection will be a bonus.
I'm in need of an experienced developer who can create an Android application that incorporates face recognition technology. Key Project Details: - The app should be compatible with smartphones and tablets. - The face recognition feature should provide high accuracy. Ideal Skills and Experience: - Proficiency in Android app development. - Experience with integrating face recognit...recognition technology. Key Project Details: - The app should be compatible with smartphones and tablets. - The face recognition feature should provide high accuracy. Ideal Skills and Experience: - Proficiency in Android app development. - Experience with integrating face recognition technology. - Understanding of secure and accurate data handling. - Previous work with apps compatible with multip...
I have excel file where I want to clean. Merge columns and make it simple. You have to be able to fix it within 30 min not more
