Excel forms vba create jobs

I am looking for a skilled developer to create a system that can manage and sell chatbots with AI. The main components include: Control Panel Features: Ability to activate or deactivate chatbots Update chatbots with new responses or features Manage clients and their chatbots effectively Display statistics about chatbots usage Provide access to chatbots' configurations Include a client database with their contact information The system should enable me to sell, update, and manage chatbots with ease. On the flip side, my clients should be able to access their chatbots through a login and utilize them effectively in both English and Spanish. Additionally, it is essential that the chatbot can integrate and be used on social media platforms like Facebook, Instagram, or WhatsApp. It...

I am in n...an experienced Social Media Manager who has a commanding expertise in Instagram and TikTok platforms. Your role will primarily revolve around: - Community Engagement: You should be able to constructively engage with our Gen Z audience base (aged 18-24), fostering a sense of community and encouraging active participation. - Monitoring and Moderation: A key part of your job will be to keep any forms of harassment at bay - we want our platforms to be a safe, positive space for every user. Ideal applicants should have a proven deep understanding of Gen Z trends, interests, and communication styles on Instagram and TikTok. Previous experience in handling social media for this age group will be a crucial advantage. Looking forward to attracted, informed bids from suitable c...

I need a competent developer to create a sales funnel for my digital product. This should be integrated with a WordPress site and designed to attract leads primarily through registration forms. Key Requirements: - Develop a sales funnel for a digital product - WordPress site integration - Registration form based lead capture Ideal Skills: - Proficient in WordPress - Experience in sales funnel development - Understanding of lead generation through registration forms Please bid if you have experience in creating effective sales funnels, specifically for digital products, and can integrate it seamlessly into a WordPress site. We have a website made, we need to turn it into a funnel and optimize it

I am in need of an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Ass...applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your assistance would be greatly ap...

Create a Professional Branding FB Banner for instant authority. It is a FB Banner for a FB profile that will be used to sell Digital Marketing Services to Vegan/Plant based Nutritionists, Health coaches, Wellness coaches. DIRECTIONS: Please create a FB Banner with the quality of a $1Million company. It should be on the same level as this quality: The words on it will be “Grow Your Nutrition Business Organically and Get Clients On Autopilot” Should Look Organic, fruits, vegetables, health, sunlight, plants, Nature-like, It can have any of those elements. It should be plant/nutrition based - 100% NO Animal Food Products. Yellow/Orange: #FFC022 Dark Teal: #00606e Magic Teal: #00CCCC Pale Yellow: #FFFF5B

I require a clean and professional logo for my project management consulting business, Let’s Sort This Out, LLC. There isn't any specific imagery I am tried to, perhaps incorporate a pen, clipboard or excel style doc - I am 100% open to creative suggestions! Ideal designers will be experienced in corporate branding and able to present a portfolio of similar work.

I'm in a rush and need a skilled designe...detailed design phase. I need you to take concepts and transform them into detailed plans, elevations, and sections. There's a deadline to be mindful of, as the completion is needed as soon as possible. Key responsibilities include: - Translating architectural concepts into detailed designs - Creating detailed plans, elevations, and sections - Ensuring the design meets all necessary standards To excel in this project, you should have: - Proficiency in AutoCAD and 3D Max - A deep understanding of architectural design principles - Experience in detailed architectural design - The ability to work efficiently under pressure and meet tight deadlines If you're confident in your skills and can deliver high-quality work quickly, I...

I need an automation expert to streamline my data entry process on Google Sheets through app script. Key Requirements: - The automation is triggered when the number is input in the cell. - The data source for this automation will be online forms. - we have three google sheets. and the same scenario where we need to triggered a message via Twilio. Ideal Skills and Experience: - must be able to show the demo. - Proficiency in Google Sheets and App Script. - Experience in automating data entry processes. - Knowledge of Twilio and Whatsapp API is a plus.

Create a logo for a technology and industrial machinery supplier company. Please view the name of the company are attached on the .txt (i dont need slogan) I preffer the colors red and blue.

I need an Android or PC based application for creating quotations, generating invoices, and tax receipts. It should support offline functionality, with essential features available without an internet connection. Key Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Ed...

I'm looking for an experienced individual to help me set up a VPN server on my TP Link Omega E707, running Windows OS. The primary goal of this is to allow secure remote access to my home network. Key Requirements: - Set up a VPN server on a TP Link Omega E707 running Windows - VPN server must be accessible outside my network - Ensure security and privacy in the VPN configuration - Establish a reliable connection method for remote access The ideal candidate should have: - Proven experience in setting up VPN servers on TP Link routers - Extensive knowledge of Windows OS - Understanding of network security and remote access protocols. Please note that my TP Link Omega E707 has a dynamic IP address.

...documents, and managing information from contact details to medical records. Key components should include: **Attendance Tracking** - The system should enable manual entry by teachers. **Student Profiles** - Each student should have an individual profile displaying personal details, contact information and medical details. - Student details and parent details will be collected using Office 365 Forms and the replies should write directly into the student management system. **Document Storage** - A document storage section is required for maintaining relevant records and resources. Including student documents like passports, reports, etc. **Grid View and Dashboards** - Information should be displayed in a grid view with filters for ease of access, and customizable dashboards...

I'm seeking an experienced freelancer to clean up and modernize a collection of PDF forms, exceeding 10 in total. The project will encompass a full design update to create a sleek and contemporary aesthetic, as well as the addition of new fields and removal of unnecessary ones for a streamlined user experience. Moreover, the forms should be made fillable and consistent across all versions. Including dropdown boxes and such interactive elements is a must, making ease-of-use a priority. Proficiency in Adobe Acrobat Pro or similar software, coupled with a keen eye for design, will be ideal for the successful execution of this project. A couple examples of our current forms are attached for reference as well.

I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used...professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward...

I'm looking for an experienced financial analyst with expert-level MS Excel skills to provide a comprehensive understanding of the data and help build a comprehensive energy financial model. Key Deliverables: - Explanation of Cash flow projections - Explanation of ROI calculations - Explanation of Sensitivity analysis - Explanation of 5-year financial projection - Explanation of Manufacturing Financial Feasibility Modeling Data Inputs: - Revenue projections - Cost projections - Investment costs - Tax rates Inflation Handling: - Inflation should be included in the projections Ideal Candidate: - Proficient in MS Excel, capable of building complex models - Experience in financial modeling for the energy sector - Understanding of manufacturing financ...

نحن شركة تجارة إلكترونية نتعامل مع منتجات متنوعة ونبحث عن مدير إعلانات الوسائط الاجتماعية للانضمام إلى فريقنا. تشمل المهام على سبيل المثال لا الحصر: إنشاء الإعلانات على منصات التواصل الاجتماعي المختلفة إنشاء تقارير في Excel وGoogle Sheets بشكل يومي وشهري إيقاف الإعلانات التي لا تقدم عائد الاستثمار المقبول إنشاء إعلان جديد للحملة المتوقفة يجب أن يكون مدير الإعلانات متفرغًا فقط لهذا المشروع وغير ملتزم بأي مهمة أو وظيفة أو دراسة أخرى ساعات العمل: 6 أيام في الأسبوع، 10 ساعات يوميا يجب أن يجيد الوكيل اللغتين العربية والإنجليزية يجب أن يتمتع أيضًا بمهارات تواصل جيدة يمكن أن تعمل على إكسل أن يكون لديك خبرة كافية في إعلانات وسائل التواصل الاجتماعي والتسويق الرقمي

As we are Manpower Supply Agency, We would like to incorporate attendance day to day entry of our workers from this info we would like to automate payroll, billing and Government salutatory. and also a dashboard for overall performance of our agency. Skills and experience: - Human Resources and Employee Management expertise - Ability to create user-friendly interfaces - Experience with Single Sign-On (SSO) integration and other login methods - Capable of adding features like search functionality, photo upload, and editable fields - Excellent communication skills to understand our needs and translate them into a functional system.

I'm looking for a skilled web developer to create a unique, visually appealing portfolio website for me. Key elements: - **Purpose**: The main goal of this website will be to showcase my work and skills. Hence, the emphasis should be on creativity and dynamism. - **Design Style**: I'm inclined towards a creative and dynamic design, so your experience in creating visually appealing websites will be a big plus. Crucial functionalities: - **Contact Form**: I need a simple, user-friendly contact form incorporated into the site. It should be easily accessible and functional. - **Social Media Integration**: The website should also include social media buttons that link to my profiles on various platforms. This will help to increase my online presence and allow visitors to con...

Project is done. Just create 1 api and check api error. Not integrate. work with ftp only

...problems. Experienced in the creative design and delivery of social media campaigns Strong attention to detail and accuracy in managing event logistics, budgets, and administrative tasks. Exceptional written and verbal communication skills, including drafting professional emails and event materials. Excellent IT skills and ability to confidently use PowerPoint, Canva, Word and Excel to quickly pick up new programmes....

NO AUTO BIDS - ONLY ZENDESK PRO! 'm in search of an experienced developer skilled in Zendesk API integration for a project related to airline claim forms. I will provide you parts of the template and you will add the form, calculations, API integration and ticket creations. The website should be built in Laravel or secure platform. If you know about EC261 claims it makes it way easier to choose you. You will do the following: - Create a form which is predefined through parameters and questions. - Add airline and airport database and organize the data with live search preview. - Calculations based on airport distance and claim form. - Zendesk ticket creation along with correct ticket numer and relevant information. - Multilingual form and site (Swedish and English). N...

I need help with data entry from PDFs into Excel, with some basic analysis required post-entry. Key Details: - The primary task is to type data from PDFs into an Excel spreadsheet. - I will provide the PDFs, they contain various types of information that need to be accurately transposed. - The data must be organized neatly and consistently in the Excel file. Data Analysis: - After the data entry, I will need basic analysis of the entered data. This includes simple calculations, averages, basic graphs, etc. - A grasp of Excel's basic analytical functions is essential for this part of the project. Desired Skills: - Proficiency in data entry, especially from PDFs to Excel. - Strong command of Excel, particularly for data management and basic analysi...

I'm seeking an experienced website designer who can create an effective, lead-generating site, mainly focusing on customer leads and providing information about my business. We install free central heating systems and loft insulation on the UK government ECO4 scheme which is aimed at helping fuel poverty and lower household carbon emissions. We have an existing website we use currently but I'd like the new one to be professional, user friendly, clear and engaging. This online platform should predominantly be centered around capturing user information through online forms. The ideal fit for this task would demonstrate: - Strong understanding of user interface and experience to ensure the online form is easy to fill out and compelling enough to convert. - Proven exp...

I'm seeking someone to migrate the content of a PDF DMS 5 book into an Excel spreadsheet. The Excel sheet should serve as a functional checklist with the disorder's name and its description only. Your mission is to categorize the disorders by chapters, mirroring the structure of the original DMS 5 book. Ideal Skills and Experience: - Proficient in data entry and Excel. - Organizational skills to categorize content effectively. I'm not looking for additional columns for notes or references, just an accurate transfer of the book's content to a checkist format de check list to facilitate reading a and diagnosis. Please apply if you're confident in your knowledge of this area and have the appropriate technical skills.

I need an expert to create a Google Ads Universal App Campaign (UAC) HTML5 asset. It should look like this screenshot. This screenshot is from an old asset for a different UAC campaign for the same app (but not never used). Now the app has change name and logo, but it seems that the asset takes the logo and app name + rating from the App/Play Store, also the screenshots in the image carousel. So logo, images and app name is uptodate. I do not have access to the zip file that this asset was made with (it is not possible to download from Google Ads). So I need you to - remake this - fix button and the text below the logo. If we work well together, then I will have more such work for you. ------------ IMPORTANT ----------- For me to consider your bid, please in the description ...

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

I'm in need of a skilled web designer who can create a simple yet professional single page website to showcase my products/services. Key Project Requirements: - Design a clean, professional and visually appealing single page website. - The site should be easy to navigate with a clear focus on displaying products/services. - The design should be in HTML format. Additional Information: - Specific color schemes will be provided for the design. - While I'm not looking for complex functionalities such as contact forms or galleries, I am open to suggestions that could enhance the website's presentation. Ideal Skills: - Proficiency in HTML and web design. - Proven experience in creating engaging single page designs. - Strong sense of aesthetic and design princi...

I need assistance with extracting specific data from a voter list that comes in PDF format from the election commission. Here’s what I need: - Extract Name, FathersName, Age, Gender,...voter list that comes in PDF format from the election commission. Here’s what I need: - Extract Name, FathersName, Age, Gender, VoterID, and SerialNumber from the PDF voter list. - Placement in a standard Excel format is acceptable, no need for any specific formatting. - Not just a one-time service, I also need a software or script that can perform this PDF-to-Excel conversion automatically in the future. Ideal candidates for this project have advanced skills in data extraction, familiarity with handling election data and proficiency in developing an automated system for convenie...

I'm seeking a talented web developer to design and build a custom website targeted at young adults. Key Features: - Capabilities: I anticipate the website will need fratures such as describing my projects, my offerings and the details about my project offerings - User Registration/Login: A user-friendly registration and login system will be essential. - Contact Forms: Incorporating easy-to-use contact forms is a priority. Design Requirements: The website should have a clean, professional look that's appealing to a audience. Ideal Candidate: The ideal candidate for this project is a web developer with experience in e-commerce, user registration and login systems, and contact form integration. They should also have a strong understanding of modern web design pri...

I need a skilled person to help me create a bootable USB for Windows 11. I'm on Mac and need this to be Windows 11. Please let me know how long this will take.

I need a professional adept at advanced Excel functions to create a spreadsheet, which would organize and manage our worker rota for late shifts from Monday to Friday. We have two sites, including inpatient and outpatient pharmacies, which need coverage. Key functionalities of the required Excel Spreadsheet: 1. Worker Availability: - The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, a...

I'm in urgent need of an experienced thumbnail creator to generate striking, ...experienced thumbnail creator to generate striking, vibrant thumbnails for various platforms such as YouTube, websites, and social media. *Style and Theme* Your designs should exude a colorful theme that's enticing and eye-catching. *Thumbnail Content* Each thumbnail should have captions incorporated in the design. The text should be readable without distracting from the overall appeal. To excel in this project, you need to be a skilled designer with a knack for creating visually stunning and colorful thumbnails. You should also have practical knowledge of designing for different platforms, and understand how to incorporate text seamlessly into your work. Past experience in a similar role w...

I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.

I'm looking for a skilled front end developer to help me create a dashboard focused on data visualization,The primary objective of this project is to develop a robust data virtualization tool capable of interpreting, displaying, and analysing collision avoidance system data extracted from log files. This tool will enable users to load log files or Excel files, interpret the data, generate reports based on specified parameters, and visualise the insights using a web application or Power BI interface.

I need a skilled Excel user to help me format a single spreadsheet and create formulas to automate some calculations. Key Responsibilities: - Format the spreadsheet to make it visually appealing and easy to read. - Create formulas to automate calculations based on the data input. - Ensure the spreadsheet is user-friendly and easy to update. Ideal Skills and Experience: - Proficiency in Excel, particularly in data formatting and formula creation. - Prior experience in handling data-heavy spreadsheets. - Strong attention to detail to ensure accurate data processing. - Ability to work independently and deliver the project in a timely manner.

I am searching for a knowledgeable expert in Microsoft Excel who can assist me with a variety of tasks. Specifically, I require aid with formulas and functions, and formatting and design. More specifically, I need assistance with summation and averages, and VLOOKUP and INDEX-MATCH commands. The ideal candidate would have substantial proficiency and experience with Excel, with an emphasis on utilising complex formulas and creating aesthetically appealing and comprehensible spreadsheets.

Hey there! I need a contractor who has access to all the major operating systems: Windows, MacOS, and Linux. For Windows and Linux, virtual machines are acceptable. Another nuance is that you must have an ISO-format keyboard (with a large (tall) Enter key). It i...Belarusian Each language usually has several layouts in the system. You will need to enter all of them. From all 3 operating systems. The second part of the task is the manual adjustment of Dead keys. For all the keys that were entered into the config as "Dead" instead of a symbol, you will need to manually check what exactly this Dead key is and either assign it an ID of an existing Dead key or create a new one. Just to give you idea, my estimation for this task is 1-2 full days of work. Also, attaching exa...

I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create...

I need a Graphic Designer who can compellingly create a 1 page PowerPoint. This PowerPoint is designed to introduce potential business partners to the steps in delivering our services. Your task would entail creating a 1 page Slide based on 'Boxes' of text in a spreadsheet. It must be complete by 13:00 London Time today. The requirements are: - Create a one-page PowerPoint Slide - Tone must be Professional - The target audience is potential business partners - Slide must be completed by 13:00 London Time today - Include "qqq" in your response to show you've read and understand the project details - All parts of the slide must be editable in LibreOffice - Budget is USD 50.00 The spreadsheet will be sent to you before you bid. Id...

I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks

...and Subadmin. The Admin will have the highest level of access and control, managing user roles, form submissions, and payment links. The Doctor will primarily be responsible for filling out forms and creating payment links. The Subadmin will receive completed forms and process payments. - Admin Capabilities: The Admin user should be empowered to manage user roles and permissions, view and edit all forms and payment links, and generate reports. This will be crucial for maintaining the system and monitoring its performance. - Doctor Responsibilities: Doctors will be primarily engaged in filling out forms and creating payment links. They should also have the ability to view responses provided by Subadmins. This project requires a developer who is proficient i...

I'm looking for a professional email marketing agency that can manage an email campaign for me. Essential skills/experience required: - Proficiency with email service like mailchimp or similar - Previous experience in email marketing, particularly in promoting products - Ability to send follow-up email Key d...mailchimp or similar - Previous experience in email marketing, particularly in promoting products - Ability to send follow-up email Key deliverables: - Sending out 350 emails using our email id - Creating and sending follow-up emails - Providing a detailed report on the campaign's performance Please note, I have a template for the emails already. I also have the database of the people to send out in excel format - company name, email, first name and last name - ...

...competencies and capabilities effectively. Key Requirements: - Deep understanding of PowerPoint design, and good eye for attention-grabbing visuals - Ability to translate corporate and product information into engaging content - Experience in creating corporate PowerPoint presentations is a major plus Specific Elements: - The presentation should showcase our capabilities, the products or services we excel in. - While not necessary, a designer who can incorporate well-crafted infographics would be ideal. Looking forward to collaboratively creating a presentation that helps us stand out from competition and generates interest from potential clients....

I need a 3D artist to create basic product models for me. The ideal candidate will have: - Strong 3D modeling skills - Experience with product design - Ability to create multiple fixed views - Familiarity with CAD software - Eye for detail and quality The project is fairly straightforward - I don't require high levels of detail, just the basic shapes and forms of the products. I'll need the models from different angles, so I can showcase them on my website. Let me know if you're the right fit!

...should have a basic understanding of digitazation and you are a critical thinker who can analyse the above matter of the position. You'll need to have expertise in lead generation, particularly in the industries mentioned above. If you had already some experience with lead generation in Switzerland or at least for European companies, this would be a great plus. the data structure should be an excel with minimum the following information: - company name - Some address or city - company website - Industry (one of the 4 above or more detailed) - Some short text about their product (can be e.g. the subtitle of company linkedin page) - contact person name - contact person position - contact person email - some telephone number (can be company or contact person) We ideally ne...

I am looking for a personal assistant who can help me with scheduling appointments, managing emails and correspondence, and running errands. Key Responsibilities: - Scheduling appointments: I need someone who can efficiently organize my calendar and arrange meetings in a timely manner. - Managing emails and correspondence: The ideal candidate should be proficient in handling emails and other forms of communication. - Running errands: Occasionally, I may need assistance with errands, so a reliable and flexible individual is essential. Communication Methods: - A successful candidate should be comfortable using various communication methods. These include email, phone calls, and online chat. Hiring Details: - I have yet to determine the exact number of hours required per week, but...

I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.

I'm looking for a skilled professional to assist with a data entry project. The aim is to input various contact details into a spreadsheet, with a range of essential and additional information. Key responsibilities include: - Entering Name, Email IDs, Phone/Mobile Numbers, and Website Links for each entry. - Including LinkedIn profile links, Other correlated details, and Remar...for each entry. - Including LinkedIn profile links, Other correlated details, and Remarks for each entry. Ideal freelancers for this project should: - Have a background in data entry. - Possess excellent attention to detail. - Be able to work efficiently and accurately. - Familiarity with LinkedIn and other social media platforms. - Experience working with data on spreadsheet platforms like Excel or...

I am in need of a talented graphic designer to help me create compelling visuals for my company's branding, marketing, and information dissemination efforts. This is an expansive project that includes the design of logos, brochures, and posters. Ideal skills for this job include: - Advanced design skills, particularly experience in creating logos, brochures, and posters - Ability to consistently apply and develop a brand identity across various media forms - Knowledge of marketing best practices and ability to create designs that appeal to and engage diverse audiences - from general consumers to business professionals, and various demographic groups Your task will hypothetically encompass: - Developing an engaging and recognizable logo design that captures o...