Excel macro find records match criteria jobs

I'm looking for a web developer to create an informative website on Hostinger. All the necessary project information - including website content, theme (have flier can send to match), logo, and colour scheme - have been collected, finalised and ready for development. The website will include the following pages: - Home page - About Qigong page: What is Qigong, Who Can Practise, What To Expect, Benefits - About Wild Swan Flowing River Qigong page: Aims, Background, About Meetings, About Mark - Upcoming Events page - Contact page - Links page - Notes page While I didn't specify any additional functionality or design preferences, I do expect the website to: - Be intuitive and easy to navigate - Incorporate our company branding (logo, colour scheme) Ideal Skills: - Profic...

...DDP pricing from each supplier, including all costs associated with production, shipping, and import duties, to ensure transparency and cost-effectiveness. Deliverables: - A detailed report listing three verified suppliers for the specified product category, including their contact information, lead times, and DDP pricing. - Documentation of the supplier verification process, highlighting key criteria used to assess supplier reliability. - Any additional insights or recommendations based on the sourcing agent's expertise and industry knowledge. Requirements: - Proven experience as a product sourcing agent in China, with a strong track record of successfully identifying and vetting suppliers. - Expertise in navigating and platforms, including advanced search techniques

I need a designer for a flyer/postcard promoting my service-based business. This piece plays a significant role in announcing our offerings to the market. Key Requirements: - Design should promote our business services effectively. - Match the design color scheme with our existing business logo colors. Ideal Skills: Freelancers with experience in designing marketing/advertising materials, particularly for service-based businesses, will be ideal for this project. A keen sense of color matching and understanding of marketing strategies will be beneficial.

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-functioning and efficient sol...

I am looking for a skilled developer to create an engaging Employee Pre-Verification system. This system will focus on Background check and Referral check. Key Functionalities: - **Background Check**: This system should have the ability to conduct background checks on potential employees. This can involve checking criminal records, credit history, and other relevant information. - **Referral Check**: The system should also incorporate a referral check system. This can help verify the authenticity of the references provided by the employee. User Interface: - The UI of this system should be interactive and engaging. This will ensure that the system is not only functional but also user-friendly. Reporting System: - The system should generate reports in two ways: - **Downloadable ...

I'm seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward project with no requirement for data analysis or visualization. A h...

...files (Illustrator or Photoshop) with all layers available, and all files used. Submission Guidelines: - Submit your original logo design through the contest platform, we will be active on the messages, if you ask a question, give us a few days and we will get back to you. If you prefer to direct message, you can do that too. - Ensure that your design aligns with the provided instructions and criteria or it may get rejected. - Plagiarized or copyrighted entries will be automatically disqualified and reported. - Rejected entries indicate missing criteria's and will not be considered. This is not personal just business. . ***Please note this is how we rate your entries right away so you have clear direction of where your entries stand. . RATING SYSTEM: - 1 STAR: indicate...

I'm looking for an experienced WHMCS developer to help improve an already developed financial history graph. I had a developer from before that told me he could improve the module by take order dates and other dates already in the database to fill in missing data of the graph. Right now the graph just records order and financial information in the database and displays it on the graph. Where there is no data the graph just shows a straight line as shown in the demo screenshot. So I want the graph to show the data that its table is missing by getting this information from the WHMCS database. The end result would fill in the missing data of the straight line and also show the history on the graph from the start of the database, right now it only goes back 3 years because that is ...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.88 % =(48,064.50/241,779.50)∗100=19.88% However, i...

I need a CRM solution designed around the latest version of Odoo, O...designed around the latest version of Odoo, Odoo 13 or Zoho. I'm looking for developers with specific skills and experience customizing Odoo CRM or Zoho Creator (CRM). Key features I need to integrate: - Contact management - Management of the Contracted Services pipeline - Customer support tickets - Agenda management with confirmations via automation via email and Whatsapp - Patient Medical Records - Integration and Management of WhatsApp messages - Built-in video calling appointments Additionally, the project requires specific design and branding elements that will be explained in more detail during the selection process. An eye for detail and a creative mindset are required to meet the specifics of the p...

...com/ Base Website Custom Design: Includes up to 4 unique page designs. Responsive Layout: Mobile-friendly design that adapts to various screen sizes and devices. CMS Integration: WordPress installation and setup, allowing for easy content management. Content Strategy Session: Session to outline the site’s content needs and SEO goals. Contact Form: Integration of a basic contact form which stores records in the CMS system. Google Analytics Setup: Integration of Google Analytics for tracking website traffic. Security Plugins: Installation of security plugins to help protect the website from common threats. The following pages are included in the base design package. • Home • About • Travelers • Clients Additional Page Development Creation of additional web...

Please Sign Up or Login to see details.

...Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score, ROC-AUC) • Score Calculation and thresholds • Deployment and Monitoring Tools available: • In use: Microsof...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm on the lookout for an experienced GDPR solicitor who can provide sound advice and representation on legal issues primarily concerning data breaches. My organization routinely deals with a considerable volume of potentially sensitive phone call records. Here are the main tasks that the right candidate should be prepared to handle: * Legal Guidance: I need expert advice on how to navigate legal disputes related to potential data breaches involving phone call records. * Legal Representation: The ideal candidate must be well-versed in representing an organization during any potential legal dispute, with an emphasis on data breaches. If you have a thorough understanding of GDPR compliance, with a particular emphasis on data breach protocols - I would like to hear from y...

I'm in need of a financial programmer with experience in Easy Language (TradeStation) to create an automated trading strategy for the stock market. The strategy will be designed to make trading decisions autonomously, based on specific criteria. Key Requirements: - Proficient in Easy Language (TradeStation) - Demonstrated experience in creating automated strategies for the stock market - Ability to understand and implement complex trading algorithms Ideally, the project should be completed within a week. I am looking for a professional who can effectively communicate and ensure the successful execution of this project.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

...available on both iOS and Android platforms. Key Features: - User Profiles: Users should be able to create and maintain profiles showcasing their work and experience in the movie industry. - Push Notifications: The app should feature push notifications to keep users informed about job opportunities and industry news. - Search Functionality: A robust search functionality is crucial for users to easily find relevant job postings. Ideal candidates should have experience in app design, particularly in developing user-centric and intuitive interfaces. Knowledge of job portals, or similar platforms, will be an added advantage. Your work will directly impact the careers of budding movie industry professionals, so a keen eye for detail and a passion for the entertainment industry will ...

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

...platforms, and is designed to provide users with medical opinions using AI. Key features to be included in the app are: - Diagnosis Suggestions: The app should provide users with accurate diagnosis suggestions based on their reported symptoms. - Symptom Checker: A symptom checker that helps users identify the possible medical conditions related to their symptoms. - Medical Records Storage: A secure and easy-to-use medical records storage system, allowing users to keep track of their health history. Ideal candidates for this project should have: - Proven experience in designing UI/UX for mobile applications, particularly in the medical or healthcare sector. - Proficiency in understanding and translating complex requirements into user-friendly designs. - A strong portfolio...

I'm in need of a talented video editor to help bring my vlogs to life. Each video will be around 10-15 minutes long and I'm looking for someone who can match my desired style, which is a good pace and chic/elegant. In terms of video editing specifics, I'm hoping to incorporate cute and feminine transitions to make the videos more engaging. Key Requirements: - Video editing experience, especially in the realm of vlogging content - Able to maintain a good pace and chic/elegant style - Skilled in incorporating cute and feminine transitions The ideal candidate will have a keen eye for detail, a solid understanding of the Youtube vlogging landscape, and be creative in their approach to video editing. Please INCLUDE any relevant examples of your work.

I'm in search of a proficient freelancer who has expertise in utilizing MATLAB R2021a for complex Image Processing tasks. As my requirements are quite specific, it is crucial that the preferred candidate has in-depth knowledge of this software and can make the most of its advanced features. Key Responsibilities: - Conduct comprehensive Image Processing tasks - Utiliz...R2021a - Significant experience in Image Processing - High problem-solving skills using MATLAB Given the specificity and technical nature of this job, candidates who can showcase samples of their previous work with MATLAB, specifically in Image Processing, will be prioritized. This is an opportunity for seasoned MATLAB users; those with a more superficial understanding of the software may not find this pr...

I will be working on your presentation, which will consist of 30 to 40 slides. I will follow the template you shared with me in our chat and create additional graphics for the SWOT and PESTEL analyses, ensuring they match the theme.

I urgently need an expert in C# to integrate my Point of Sale/Enterprise Resource Planning (POS/ERP) system with QuickBooks Online. The goal is seamless syncing of different modules, including, but not limited to: - Customer Information - Inventory Status - Purchase History - Sales Records - Products, Categories, etc... Familiarity with QuickBooks Online APIs and proficiency in C# .net Core is imperative for this role. Past experience with similar projects will be highly valued. The timeline is urgent; I need this integration done ASAP. we already have a code we made integration with SAP Business One, we can share this code to have the fastest development, and also we have the code of a previous developer who made of Quickbooks so it would help to see how to integrate

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

...and usability of the app. - Additional Features Integration: I need you to integrate push notifications and a payment gateway into the app to enhance its capabilities - Voucher functionality: Users can purchase vouchers at half price. - Condition: To avail the voucher, the user must share the app link with 10 other users. - Success criteria: If the user successfully shares the link with 10 users, they can redeem the voucher at half price. - Failure criteria: If the user fails to share the link with 10 users, they will receive a 10% discount on the voucher instead. Some more questions - Can the voucher sharing process be automated or tracked within the app? Ideal Skills and Experience: - Proficient in mobile app development, particularly customization on existing app...

Description: We are looking for a highly skilled and motivated frontend developer to create a cross-platform desktop application for Windows and MacOS using Electron.js. The application will man...including: A brief introduction of yourself and your experience relevant to this project. Examples of previous projects or similar desktop applications you have developed. An outline of your approach to this project, including your development process and timeline. Your availability. Any additional skills or experiences that make you a strong candidate for this role. We are excited to find a talented developer to join our team and bring this project to life. If you are passionate about web & desktop application development and meet the requirements above, we would love to hear from y...

Thank you!

I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...

...creating a CAD model of a mechanism, and effectively communicating through technical drawings. Project Requirements: Architecture Selection for Each Linkage Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analysis including criteria, scoring, weighting, and reasoned choices Synthesis of selected solutions CAD Modeling of a Mechanism Estimated Time: 8 hours Evaluation Criteria: General appearance and manufacturability of parts Quality and cleanliness of part modeling and construction trees Accurate assembly definition and kinematic ...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Pagamento ordine" and "Rimborso". Make the sum using the formula in column J "totale ordine" of the attached “esempio output” file 2- Filter the rows of input file 2 (attached), column D "Dettagli prodotto" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "dettagli prodotto”of input file column 2 are listed. (example VAT file attached) 3- The app must check th...

We have a non-trivial design built in Figma. We need a WordPress theme built to match that design. The desktop version is ready. This job also includes building the mobile version, according to what our designer will create soon in Figma. See the attached document for our requirements, as there are some details there.

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed

Hi, I am looking for someone to help me with courier delivery plugin for Botble Laravel CMS. 1) Technical tasks for the delivery person part - I need to add the role of the delivery person (name, phone number, passport photo (2 photos), text fields for biography, login and password) - so that he can log in to his account via login password. - When a customer orders goods, the admin must assign delivery to a certain deliveryman (list of deliverymen) that he delivered the goods to the client and should be the delivery status (picked up the goods, on the way, delivered, canceled). - Deliverer should see how much what goods delivered, new ordered goods (from admin) - notifications of new orders in telegram bot for deliverymen 2) Inside the product in each article should generate a barcode, ...

I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.

I'm seeking a talented graphic designer well-versed in manipulating JPEG images, with strong capabilities in color adjusting, increasing detail, and digitally enhancing logos. To match the existing bold and vibrant style of my logo, your purpose will be to improve the color dynamics, amplify the detail, and increase overall digital appeal. Key skills required: - Proficiency in graphic design software, - Demonstrative understanding of color theory, - Outstanding attention to detail, - Proven experience with digital enhancement techniques, - Ability to maintain and enhance existing stylistic themes. This project requires a fine balance between preserving the original feel of the logo and introducing initiatives to noticeably improve it. Ideal candidates will have a portfolio ...

...to join our team and help finalize our ride-hailing application. The app is nearly complete, but we need assistance in implementing and refining our two-way communication system within the match-making component. The ideal candidate will have a strong background in Flutter, Bloc state management, and Node.js APIs. **Responsibilities:** - Debug and enhance the two-way communication functionality in our ride-hailing app. - Collaborate with our backend team to ensure seamless integration with Node.js APIs. - Implement and optimize Bloc state management for efficient state handling. - Ensure the app’s match-making system works reliably and efficiently. - Conduct thorough testing to identify and fix any bugs or performance issues. - Maintain high code quality and adhere...

I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on targ...

...analysis, probability, and betting systems to provide valuable insights on betting odds. The particular sports/esports of interest are Football, Basketball, Cricket and Counter-Strike: Global Offensive. The detailed responsibilities are: - To provide one/two sure shot (can be multi) odd everyday with 1.5 odd minimum - Analyze real-time and historical stats for Football, Basketball, and CS:GO to find out possible outcome - Draw insightful inferences - Suggest betting strategies based on the analyzed odds - Provide regular reports and updates on the competitive odds in the market The ideal candidate will have an analytical mindset, strong mathematical skills, and a comprehensive understanding of the mentioned sports. Prior experience in sports/esports betting analysis is highly...

Looking for a professional who can integrate a donation page into a website using CCAvenue as payment gateway.. Tasks Use our donation page with 6 different donation options and amounts and make the checkout via CCAvenue work. Design/create form to c...to collect donor details (name, email, address, PAN etc) based on a sample form that will be provided. Backend Development (PHP): Integrate CCAvenue API using their PHP libraries. Develop functionality to capture donation amount and donor details. Send transaction data (amount, details) securely to CCAvenue for payment processing. Create a database to store donor information and transaction records. Payment Processing: Handle CCAvenue response (success/failure) after payment authorization. CCAvenue account to use for this project...

I'm looking to create a comparison website to help potential traders assess and select proprietary trading firms in the finance industry. Key Requirements: - The site should have a comprehensive database of different proprietary trading firms, their key features, and offerings. - Users should be able to filter and compare the firms based on various criteria like trading strategies, capital requirements, and more. - A user-friendly interface and robust backend that can handle large amounts of data and provide real-time updates are crucial. Ideal Skills & Experience: - Web development experience, particularly in building comparison websites. - Understanding of finance and proprietary trading firms. - Proficiency in database management and user interface design. - Ability t...

I'm looking for a skilled software developer to create a Windows-compatible software application. This software should be specifically tailored to help my sales team improve their performance a...with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with Excel/CSV data import for softw...

Hi, Looking for a person to create an spread sheet monthly for sales records during that month. Will need to take information off of individual sales order sheets/emails and transfer it onto a spread sheet... buyer/address/item(s) they bought/amount they paid etc. Will be a reoccurring task per month. Will pay per month, expecting 100-200 sales per month. Please show rate per entry.

I need a reliable professional to help me with monthly inventory updates from the dealers and the sales department. Key Tasks: - Quantity Update: Ensure all stock levels are accurately reflected in our records. - Product Description Update: Make sure all product descriptions are up-to-date and accurate. - Product Code, UOM (Kit/Vials), Rupee Value: Cross-check and update product codes, Unit of Measure (Kit/Vials) and Rupee Value accordingly. Format: I have a specific format that the inventory updates need to be in. You will need to use this template to ensure data consistency and compatibility with our existing systems. Frequency: This is a monthly task and I would need your support on an ongoing basis. Ideal Skills: - Proficiency in inventory management. - Attention to detail ...

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Estimated time of arrival (ETA)...

I'm looking for a skilled freelancer to create a mantra chart in Excel. This will be a presentation-worthy document, so I'm keen on ensuring that it's well-structured and visually appealing. Key Requirements: - Incorporating text, numbers, and dates into the chart - The chart should feature less than 10 mantras - Ensuring the final output is suitable for professional presentation The task will require someone with excellent Excel skills and an eye for design. A good understanding of data representation would be a big plus. You can expect detailed instructions and guidance from me throughout the project. Feel free to ask any clarifications you might need.

I require a modern, upbeat video montage for a birthday celebration. This montage should be crafted from personal home videos that will be provided. Ideal Skills for the Project: - P...from personal home videos that will be provided. Ideal Skills for the Project: - Proficiency in video editing software like Adobe Premiere Pro, Final Cut Pro, etc. - Ability to incorporate seamless transitions between video clips, creating an energetic and continuous flow - A creative flair to devise a modern and upbeat theme throughout the montage - Strong understanding of tempo and pacing to match the upbeat tone of the montage - Experience creating personal video birthday montages would be advantageous The final product should capture the joyous essence of the occasion and create a memorable e...

...skilled UI-UX designer to overhaul the design and experience of our existing cashback and coupons website. The target audience for our platform consists of tech-savvy individuals and budget-conscious shoppers. The improvements we're looking for are: - Enhanced navigation: The current website's navigation is not smooth and as intuitive as we'd like. The new design should make it easier for users to find what they need without much effort. - Modernized visual design: Our platform needs a fresh and appealing look that resonates with our audience. This includes updating the color scheme, typography, and overall visual aesthetics. - Improved user-friendliness: The user experience on our site needs to be seamless, efficient, and enjoyable. We aim to retain our current...

I am looking for a talented videographer and editor to create engaging football themed entertainment shorts for my YouTube channel. Key Responsibilities: - Filming and editing a variety of shorts focused on football skills and tricks, match highlights and analysis, as well as news and updates on football events. - Creating high-quality, entertaining content that captivates viewers and enhances the visibility of my channel. Ideal Skills: - Excellent video shooting and editing skills, preferably with experience in sports media. - Deep understanding of YouTube platform and trends. - Strong knowledge of football, and ability to bring out the thrill and passion of the sport in the videos. Your expertise will aid in building my channel's reputation and viewership. Make sure you b...

...the AirPods Pro 2 that goes into the ears should stick up 15 mm above the case. Steps to Create the 3D Model in Blender: Set Up Blender: Open Blender and delete the default cube. Model the Charging Case: Create the Main Body: Press Shift + A to add a new mesh, select Cube. Scale the cube to the dimensions of the PCB and battery: Press S to scale, then X, Y, and Z to scale along specific axes to match 33 mm (X), 40 mm (Y), and 10 mm (Z). Adjust for AirPods Pro 2 Dimensions: Add another cube and scale it to fit the AirPods Pro 2 dimensions with some extra room for fitting: Height 31 mm, Width 22 mm, Depth 25 mm. Use the boolean modifier to subtract this new cube from the main body to create the cavity for the AirPods. Design the Butterfly Top: Butterfly Shape: Use the Bezier Cur...