展示会の詳細: 開催日: 2024年5月15日（水）・16日（木） 時間: 9:00 ~ 18:00 (昼休憩1時間あり) 所在地: 東京ビッグサイト 西展示棟１・２ホール（東京都江東区有明3-11-1） 仕事の内容: ● 顧客からの問い合わせを翻訳して整理する ● 接客補助やブース案内のお手伝い ● 収集された情報の処理を支援する ● 展示ブースの資料作成のお手伝い 経歴経験: ● 高等学位以上の在学中または卒業生で、一定の工学的背景があることが望ましい ● 日本語を母国語とします。 優れた英語または北京語または広東語、優れた対人スキルとコミュニケーションスキルを備えていること ● 前向きで楽観的な性格で、積極的に提案し、積極的に解決策を模索する方
業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.
業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.
業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.
業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.
業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.
業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.
業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.
業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.
業内容 簡単なツールを使ってインターネットから取得したデータをエクセルに入力して下さい。 入力したエクセルの結果からテキストファイルを作成して下さい。 エクセルファイルとテキストファイルを提出して下さい。 簡単な作業です。 詳細は採用後にお知らせいたします。 Enter data obtained from original easy tool to spread sheet in our format. From the result of Excel sheet and original tool, make text data. Submit Excel file and Text file to me. It is very easy task. I will let you know after hiring.
I am currently experiencing an "Internal Server Error" on my Apache server and urgently require professional assistance...could potentially involve tasks such as updating the .htaccess file, modifying the Apache configuration file or adjusting permissions for my web directory. This job demands expertise in Apache server maintenance and problem-solving skills as it needs to be completed as soon as possible. Familiarity with best practices for handling server errors would also be ideal. This is the error: In the error log it states that the PHP script did not return a valid set of HTTP headers before the script finished execution. Upon checking the fpm logs I noticed the error, "[19-Apr-2024 06:18:36] WARNING: [pool www] server reached pm.max_children setting (60), con...
We're experiencing an issue with our Laravel website. The login works intermittently for regular users, and I've noticed this issue on Google Chrome. The problem seems to happen randomly without any specific pattern. When it fails, after login, php log says the user has logged in. But in the website, it shows that the user is still in unlogged in mode. It seems the login state is not properly for the website either in the cookie, or somewhere in the webpage Key Points: - Occurring for regular users on Google Chrome - Random failures without a pattern I'm looking for a skilled Laravel developer who can help me diagnose and resolve this issue. Ideal Skills and Experience: - Strong proficiency with Laravel PHP framework - In-depth understanding of backend/frontend sy...
...purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 29 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 29 bottles must be labeled in a manner that correlates with the entered data, ensuring no discrepancies. - **Shipping Coordination:** Prepare the samples for shipping. The process for this will be comm...
...purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 4 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 4 bottles must be labeled in a manner that correlates with the entered data, ensuring no discrepancies. - **Shipping Coordination:** Prepare the samples for shipping. The process for this will be commun...
I'm in need of a skilled Machine Learning Engineer who can develop modules to help analyze the real-time electricity consumption for a variety of devices in our system. Backend: Key Points: - Devices to be analyzed include air conditioners, lights, and simple motors and other simple devices. - The analysis should cover both the collective consumption of groups of devices and the individual consumption patterns of each device. Ideal Experience: - Strong background in Machine Learning, ideally with experience in real-time data analysis. - Previous work in energy consumption analysis or similar fields would be a huge plus. - Proven track record in developing ML models for group and individual level analysis. The ML analysis we are looking for includes: - Identifying ...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
I currently use Hawksoft CMS and Marketing 360 CRM. My project requires a platform that integrates these systems with a document signer and a calculator. Key Features: - A user-friendly log in system with multiple users. - Integration of Hawksoft CMS and Marketing 360 CRM into the platform. - A document signer with the ability for electronic signatures and document tracking. - A calculator that includes formulas for interest and payment schedules. Ideal Skills: - Proficiency in CMS and CRM integration, particularly with Hawksoft CMS and Marketing 360 CRM. - Experience in developing document signing features with elements such as electronic signatures and document tracking. - Strong background in building calculators with advanced financial formulas, particularly t...
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
I require assistance with building financial reports specifically targeting balance sheets within SAGE Intacct. The perfect freelancer for this project would possess the following skills and experience: - Deep understanding of SAGE Intacct software, - Proficiency in designing financial reports, - Solid knowledge in standard balance sheets creation. The final product should be a standard balance sheet report that can integrate seamlessly into my workflow. Individuals with keen attention to detail are highly preferred.
I'm in need of a ...application should be geared towards triggering real-time dispatch of event data on items/products inventory to a webhook like Zapier. Below are the specific requirements: - Dispatching of Item Names, Quantities, and Prices: The application should be able to send all item/product data particularly item names, quantities, and prices from QuickBooks to Zapier. - Real-Time Data Dispatch: The application should be able to dispatch this data in real-time to ensure high responsiveness and accuracy of data. Ideal skills and experience: - Demonstrable experience in creating QuickBooks integrations - Familiarity with Zapier webhooks - Knowledge of inventory data management - Strong coding skills with a keen eye for detail - Experience in creating rea...
Mail server is getting attacked, I need to create a windows service constantly checking a .txt log file for preset keywords like "Failed SMTP login" or "Relay attempt" to auto block IP's. This service should auto add/delete a new entry to a existing "inbound windows firewall rule" with the hacker's IP for a specific period of time. A good example or a similar concept could be found here: Some of the settings that I need to control: – Duration to ban ip address (min) – Number of failed login attempts before ban – Whitelist of comma separated ip addresses to never ban – Blacklist of comma separated ip addresses to always ban – Custom keywords, XPath and Regex to parse logs for failed login attempt...
...* Where: Script '/home/beemo/dev/flutter/packages/flutter_tools/gradle/src/main/groovy/' line: 1419 * What went wrong: Execution failed for task ':app:compileFlutterBuildDebug'. > Process 'command '/home/beemo/dev/flutter/bin/flutter'' finished with non-zero exit value 1 * Try: > Run with --stacktrace option to get the stack trace. > Run with --info or --debug option to get more log output. > Run with --scan to get full insights. * Get more help at BUILD FAILED in 20s Running Gradle task 'assembleDebug'... 21.0s Error: Gradle task assembleDebug failed with exit code 1...
I'm in need of a talented illustrator to create some cartoon stickers for me. These illustrations are going to be used for my small business. - The style I'm looking for is a fun, engaging cartoon style. - The stickers will be printed on sheets, so I don't need them to be in a specific shape. - It's crucial that the illustrations are vibrant, eye-catching and cute. I don’t have a big budget so please keep this in mind:) The ideal candidate for this job is someone with experience in creating high-quality, engaging cartoon illustrations. Experience in designing for print. Please provide samples of your previous work in a similar style.
I'm seeking a seasoned developer well-versed in C# and Selenium to create a bot to facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Faceboo...
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be required to create and manipulate pivot...
I'm looking for a professional who can complete an online OSHA 30 course as soon as possible. I will provide a log-in and you will sit for and successfully complete a course. I have already completed this 3 times in my career but the refresher is a requirement for me. Key requirements include: - Expertise in OSHA 30 training. Please bid only if you're confident in delivering a quality, timely service in accordance with the OSHA 30 course curriculum.
I want a simple platform using APIs and web sockets to collect real time data and calculate the values and show in the form of heatmap using plotly heatmaps. I need 4 features. Liquidation heatmap, order book, net position heatmap and liquidation level. Please read attached requirements before sending a bid. And please quote actual amount
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...task involves parsing a large Excel sheet containing student data, splitting it into smaller sheets based on schools, and sending each school's data to the corresponding coordinator's WhatsApp number. The main tasks include: Data Parsing: The freelancer will need to parse the provided Excel sheet containing student data. The data includes student names, grades, schools, coordinator names, coordinator WhatsApp numbers, and student codes. Data Splitting: The freelancer will develop a Python script to split the large Excel sheet into smaller sheets based on schools. Each smaller sheet should contain data for students from a single school. WhatsApp Integration: The freelancer will integrate Twilio's WhatsApp API into the script to s...
I need an expert to help me select the most suitable all in 1 programming langua...can make mobile apps in JS using react & angular. But in javascript will code be exactly same for all platforms ? 4. Another option is Flutter (Dart). 5. Which is better out of these 2 ? or can you suggest any other option apart of these 2 6. As of now I want to develop a web app for visual DBMS quite similar to ms access. It will look like a spreadsheet but will have capabilities of both Google sheets / MS excel & a DBMS (DataBase Management System) 7. I am very familiar with C & C++. So I would prefer to use similar syntax. 8. Can C++ be answer to my 1 & 2 point ? You should have: - Profound understanding of various programming languages - Significant experience in building app...
I have an Excel sheet with construction project data that I'd like to convert into a Power BI report. This sheet includes data from various projects of different types in a mix-use development setting. Key requirements: - Convert the Excel sheet data to a visually appealing and informative Power BI report - Create a Power BI report that can be easily updated with new data and link with Excel sheets - Ensure the report is user-friendly and can be navigated easily - Internal Links within Power BI to enhance user interaction Ideal skills and experience: - Proficient in Power BI, with a portfolio that showcases similar projects - Experience in working with construction project data, preferably mix-use developments - Excellent data visualization and report ...
...currently in need of a hotel booking module to be developed for both Android and iOS platforms using Flutter. -We will provide the Api -Company have design the same and integrate the API Key Functionalities: - User Registration: The module should allow users to create accounts and log in securely. - Hotel Search and Filtering: It should provide users with the ability to search for hotels and filter results based on various criteria like price, location, and amenities. - Booking Confirmation: Once a user selects a hotel and submits booking details, the module should display a confirmation message. Skills and Experience: - Proficiency in Flutter for cross-platform mobile app development
I need a reliable person to help me with a project that involves voting on a website. I'm looking for someone who can use automation tools to do the voting. Key requirements include: - Expertise in using automation tools for website voting - Ability to work consistently until the project deadline - Proficient in setting up and using a real-time dashboard to track the voting progress I'm not exactly sure about the security measures involved. If you have experience in bypassing common security measures like CAPTCHAs or IP rate limits to automate voting, it would definitely be a plus. Please reach out if you have the required skills and are available to help me until Sunday 11:59pm.
I am looking for a Shopify + Wordpress developer with specific expertise in custom theme development. The ideal candidate will have experience in the US time zone and be available for full-time work. Specific requirements for this project include: - Custom theme development for Shopify - Familiarity with app development for Shopify - Store setup and configuration Industry experience is not a requirement for this project, any industry experience is acceptable. In order to separate spammers from real candidates, if you agree with this statement please write it on top of your bid: "I am available to work in the US time zone and have X hours left available TODAY!" - where "X" is the amount of hours you have available for work today immediately. Th...
...choose a souvenir they'd like. Challenge them to calculate the cost with tax and see if it fits within their budget created earlier. This reinforces practical math skills and responsible spending habits. Planting the Seeds of Organization and Time Management: Mission: Museum Master: Before your visit, encourage pre-teens to research the museum's collection and exhibits. Let them create a list of "must-see" items and plan a route to maximize their time. This fosters organizational skills, time management, and goal setting. Exhibit Exploration Log: Help pre-teens create a logbook for their museum visit. This can be a simple notebook or a digital document. Encourage them to take notes about the exhibits, sketch interesting artifacts...
As part of my project, I need an expert in Excel to type data from various digital files into a spreadsheet, ensuring accuracy and efficiency. This data will be utilized for basic data analysis purposes, so it's important that the freelancer is comfortable with working on this type of data. Key Requirements: - Converting data from various digital files (PDF, Word, etc.) into an Excel sheet. - Proficient in using basic Excel formulas and functions to manipulate data for analysis. - Attention to detail and accuracy are critical for this task. Ideal Skills and Experience: - Proficiency in Excel - should be able to work with basic formulas and functions. - Prior experience in data entry or data analysis is a plus. - Strong attention to detail to ensure accurate data entry. - Abil...
Please read the attached instruction sheet along with below details before you bid Kindly bid if you are experienced in image editing...set in pixel -900 X 700+save to .png format and webp format The sample of the requirement is attached for your reference.... your quote will be considered for 1000 products images. All the images is for grocery shop 1) All products should be cropped individually from the brochure or image or website link, The same shall be shared to you as per the required data. Any visible imperfections need to be painstakingly cleared off. Each picture will have to be improved in terms of lighting and contrast to make it more visually appealing. 2) the Size of the image should be 900 X 700 (Sample attached for your reference) 3) No Duplicates images should be c...
am looking for a writer/journalist who can produce news articles based on trending topics we provide. The ideal candidate will have experience in producing multiple stories per day on incoming news. Skills and Experience: - Strong writing skills - Knowledge of current events and ability to research and gather information - Ability to write in a neutral and unbiased manner - Experience in writing news articles - Ability to meet deadlines and produce high-quality work consistently
I'm looking for a mobile app developer to create a cross-platform service app similar to URBAN CLAP. The app should be available on both Android and iOS devices. Key Features: - User Registration: Users should be able to create accounts and log in securely. - Service Provider Registration: A feature that allows service providers to register and offer their services on the app. - Service Booking: Users should be able to browse available services, select, and book them. - Payment Integration: A secure payment gateway should be implemented to facilitate transactions between users and service providers. Ideal Skills and Experience: - Proficient in cross-platform app development - Knowledge of creating user-friendly and engaging interfaces - Experience in integrating secure paymen...
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I'm seeking an Excel expert to help me with data analysis, formulas, and pivot tables. I work with Excel 2019. Key Responsibilities: - I want to see the mode of payment according to date wise in report sheet according to datewise Ideal skills and experience: - Proficient in Excel 2019. - Expertise in data analysis, formulas, and pivot tables. - Experience in creating automated reports or dashboards (desirable but not mandatory). - Excellent communication and problem-solving skills.
Creation of Design Sheets for Martial Arts School **Project Description:** We are seeking a talented graphic designer to create three professional presentation sheets for our martial arts school. These sheets will be used in sales conversations to visually convey the specific benefits of our training program to potential members. **Objective:** Each sheet should visually highlight a specific benefit of our training program: 1. Boosting Self-Confidence 2. Development of Defense Skills 3. Physical and Mental Balance **Format and Software:** - Size: 20x30 cm - Software: Photoshop or PowerPoint - The final files should be editable to allow later insertion of photos. **Design Requirements for Each Sheet:** **Sheet 1: Boosting Self-Confidence** - Ti...
I'm in need of a native Italian-speaker for a part-time customer support role, working cca 1-2 hours a day. Work description and inhouse communication is in English, so you have to understand and be able to communicate with us in English as well. The calls you'll have to make to our customers will be in Italian only. Responsibilities will primarily include: - Managing customer interactions through both email and phone. - Responding within a three-hour window from the time of customer contact. - Primarily handling billing inquiries. The most suited for this role are those with: - Proficiency in Italian - Excellent customer service skills - Experience with billing inquiries - A fast yet detailed approach to their work. Experience in a similar role will be favora...
I need help with scraping specific information from urls (we will provide). The key details I need are the company name and contact information. Website Phone Email Brand Country Of Origin Total Entries: 1704 No research required, you just need to copy paste information from the fields onto a google sheet.
I'm looking for an experienced developer to integrate Typesense search functionality with my web application. My site primarily uses JavaScript, and I want to make the product listings searchable t...primarily uses JavaScript, and I want to make the product listings searchable through Typesense. Key Requirements: - Integrate Typesense search with my existing web application that is built in JavaScript. - Implement real-time search capabilities for product listings. Ideal skills: - Strong experience in JavaScript - Previous work with Typesense or similar search engines - Understanding of real-time search functionality This is a critical project as real-time updates are key for my product listings. Please provide examples of your previous work with Typesense or ...
I'm seeking a talented developer to construct a standalone Google Sheets module, specifically designed for the intuitive verification of GSTIN numbers. Key Responsibilities: - Crafting a module capable of validating GSTIN numbers to ensure they're correct. - Enabling lookup functionality to fetch respective company details using provided GSTIN numbers. - Designing formulae for automatic GST amounts calculation according to the obtained details. What I'm Looking for in the Proposals: - A comprehensive and detailed project approach indicating complete understanding of the module requirements and successful execution plan. Ideal Freelancer: - Proficient in Google Sheets, with substantial experience in building custom modules. - Basic understanding of GSTIN pri...
...looking for a skilled developer to create a simple SaaS tool specifically targeted at small business owners. The primary goal of this tool is to provide real-time cash flow updates to the users. Key Functionalities: - Real-time Cash Flow Updates: The tool should be able to provide real-time monitoring and reporting of cash flow changes. User Data Input: - Integrating with Accounting Software: The tool should allow users to input their financial data by directly integrating with their existing accounting software like quickbooks. Ideal Skills: - Proficiency in SaaS tool development using a no code tool flutterflow - Experience with real-time data processing - Previous work on financial reporting tools - Familiarity with integrating systems with accountin...
...users to create accounts and log in securely, with options to save their preferences and order histories. - Restaurant Selection and Menu Browsing: Users should be able to browse through a list of restaurants, view their menus, and select items for their orders. - Order Tracking and Delivery Status Updates: The app must provide real-time order tracking and push notifications for delivery status updates, ensuring transparency and convenience for the users. Ideal Skills and Experience: - Proficiency in cross-platform mobile app development, with a strong portfolio of similar projects. - Expertise in integrating user authentication and account management systems. - Experience in developing e-commerce or online delivery apps, with a focus on user experience and real-time...
Have two parameters: one for sheet ID and and one for collection. When you run the script, it extracts all data from that collection and puts it into a sheet tab with DateTime as tab name.
Project Title: Experienced Translator Needed: Translate Italian Company Balance Sheet to English Project Description: I am seeking an experienced translator to translate the balance sheet of my company from Italian to English. The balance sheet contains important financial information that needs to be accurately translated for business purposes. Project Details: Document Length: The balance sheet consists of 38 pages. Deadline: The translation must be completed by next week, asap. Expertise Required: I prefer a translator who has experience in financial or business translation, particularly with balance sheets. Technical Terminology: The balance sheet may contain technical financial terminology, so familiarity with such terminology is essential...
