Csv services query jobs

I'm seeking a proficient scriptwriter to design an Airtable...relationships. The main task for this script will be to focus on combining data from the parent-child and combining it onto 1 row each. Specifically, the required updates will involve: - Combining Parent and all children data onto same row - Taking DOB field and splitting into a Month field and a Year field - The end result should be a base where I can upload a new CSV and it outputs the desired result into a new table that I can download a csv from The ideal candidate for this role is someone well-versed with airtable scripting and data management, specifically having a strong knowledge of number fields. Your experience with manipulating parent-child data relationships will be crucial for successful compl...

I'm looking for a skilled and experienced web designer to help me with my Squarespace website. The key areas of focus for this project are: - Redesigning the homepage layout: I want a fresh and modern look that improves the overall user experience and enhances visual appeal. - Adding new pages for products/services: I need to extend my site with new pages that feature my products/services. This requires a good understanding of Squarespace's page layout and structure. - Updating the website content: I need assistance in updating the current content on my site to make it more engaging and relevant. In addition to the above, I'm also looking for assistance with SEO optimization. This includes: - Enhancing the website's responsiveness and ensuring it's...

...Transport. Key Details and Sections: - Company History and Background: A concise but engaging history and background of D&G Transport. - Services Offered: Clear and visually appealing representation of the various services we offer. - Testimonials from Clients: Incorporating positive client feedback to build credibility. - Pricing and Packages: A straightforward presentation of our pricing and packages. - Contact Information: Ensuring our contact details are prominently displayed for easy access. Target Audience: - Individuals in Need of Transportation: The material should resonate with individual consumers who might require our transportation services. - Businesses in Need of Transportation: Content should also be tailored to appeal to corporate clients. T...

I'm looking for a talented WordPress developer to revamp my current website to provide detailed information on our services, especially tax preparation and bookkeeping, in a modern and sleek design. Key project requirements include: - Modern and sleek design: The new site should have a contemporary and visually appealing look and feel to engage our audience. - Comprehensive service pages: The site must effectively showcase our tax preparation and bookkeeping services. Each service page should provide in-depth information to help potential clients understand our offerings. The ideal candidate should have experience in: - WordPress development - Designing modern and sleek websites - Creating effective service pages with a focus on tax preparation and bookkeeping. We ha...

I'm looking for a skilled web developer to create a professional website for my ginning cotton factory. The primary purpose of this website will be to provide information regarding the factory and its services to potential clients. Key Requirements: - The main goal of the website is to showcase our factory and the different services we offer. The emphasis is on providing detailed information, not generating leads. - The website should be developed using a Content Management System (CMS) such as WordPress or Joomla. This will allow me to easily update and manage the content in the future without requiring technical expertise. - I want the website to have a user-friendly interface, making it easy for visitors to navigate and access the information they are looking for. - ...

The Climate Justice Coalition will hold an event. You are cordially invited to take videos and photos of the event and send them to me. The material needs to contain specified elements, such as banners, placards. I’ll provide with ideal prices for your services. When: 11:45 am, Saturday 18 May Where: Cavendish Square Gardens, W1G 0AN, London Specific Requirements: - Capture the essence: I'm looking for you to capture the energy and commitment of the event attendees. - Important elements: Please ensure that speeches, the crowd's response, and the banners and placards are prominently featured in your work. - Tone: The videos and photos should be candid and spontaneous, giving viewers a real feel for the event. Ideal Skills and Experience: - Photography/Videography:...

I'm expanding my technology business and I need a...assist in setting up remote meetings through calls. Key Responsibilities: - Your primary goal will be to increase sales, through setting up meetings. - You'll be expected to make 100 dials daily, using the software and numbers provided. - I will provide you with a Salesforce CRM to manage the leads and appointments. Ideal Candidate: - Should have a basic understanding of technology products and services - a tech-savvy individual would be preferred. - Experience in sales calling and lead generation is a plus. - Proficiency in using Salesforce CRM would be an advantage. This is a part-time role, requiring 4 hours a day. Please make sure to apply if you're comfortable with the daily call volume and have the necessa...

Looking to automate a data entry process and generate reports on Google Sheets. The ideal candidate should be able to integrate data from Google Forms and CSV files into the Sheets to perform these tasks. The project has to be completed ASAP.

...about the logistics industry, specifically in the area of transportation and distribution. Key tasks will include: - Providing in-depth analysis of last mile delivery, including identifying and studying trends, challenges, and solutions. - Research and provide insights about effective entry points and custom clearance methods regularly used in the industry. - Investigate and analyze courier services, including their efficiency and impact on the overall distribution process. - Examine the use and effectiveness of locker and PUDO (pick up drop off) points in modern logistics. - Who are the main ecommerce sellers. Suitable candidates should have extensive experience in transportation and distribution within the logistics sector, exceptional research and analytical skills, and ...

Your task wi...already started with 25. Below are the details you need to provide: - Contact information: This includes the name, phone number, and email address of the relevant point person. - Company name and address: Anxiety-free navigation to every business. - Industry details: Basic insights about the field the business operates in. - Services and cost of services: Here's where it gets a bit tricky. Not all services are built the same. If available, I want the cost of services to be distinguished based on their nature. A background in business intelligence, data collection, or related disciplines will give you a leg up. Attention to detail is absolutely critical. For the best results, previous experience with Airtable is recommended. The airtable da...

Looking to automate a data entry process and generate reports on Google Sheets. The ideal candidate should be able to integrate data from Google Forms and CSV files into the Sheets to perform these tasks. The project has to be completed ASAP.

I'm on the hunt for an individual adept in coordinating and managing our data analytics platform, BestAgent, in the AWS Marketplace. BestAgent is an advanced modular integrative predictive Ai data analytics platform that lessen legacy losses given default during repossesion, mortgagee...Banks and their Arrears, Recovery, Collections and Hardship departments Your tasks will revolve around: - Managing and optimizing the Product Listings of our platform. - Initial customer inquiries regarding our platform. - Partner Central ACE Program reporting. Ideal candidates will have a strong background in AWS Marketplace and Partner Central, have a developed understanding of the financial services SaaS procurement process, comfortable with customer service, and exhibit excellent commun...

I'm searching for a proficient Go coder to develop a software application tailored for the Linux platform. Key requirements include: - Proficiency in the Go programming language - Proven experience in s...requirements include: - Proficiency in the Go programming language - Proven experience in software development - Keen understanding of the Linux operating system - Network programming - Geneve encapsulation - CoreDNS development Looking for Go programmers with strong networking background to write a DNS handler plugin for CoreDNS which can receive Geneve packet from client, decap the underlying DNS query in UDP or TCP or DoH preform DNS resolution as normal through the built in forward plugin. On the response side the plugin must be able to encap back to Geneve and res...

I have a real estate development company, and I'm looking for a dedicated Excel expert to help me streamline my expense tracking process. Key Requirements: - I already have a template set up and in one of the tabs I have a CSV statement import. Your primary task will be to create a formula that can automatically pull data from a statement import into the relevant property tab. - The data should be ordered by date to ensure clarity and easy reference. - I have created a macro to change the debit figures to negative amounts in the spreadsheet. - I am open to changes/ideas on if it requires a different setup. Ideal Skills and Experience: - Advanced Excel skills are a must. You need to be comfortable working with complex formulas to manipulate data. - Experience with real est...

I require services for two separate projects—a commercial parking lot and a sewer lift station. The parking lot is expected to accommodate light vehicles, such as cars and small trucks. Any relevant experience dealing with such parking lots would be much appreciated. The second project would involve replacing our current sewer line and installing a sewer lift station. Experience in dealing with sewage system projects, particularly in odor control methods, is essential. Ideal Skills: -Experience in parking lot planning and design -Expertise installation for sewer lift stations -Experience in troubleshooting sewer line issues

...Google Play Store. 2. Ensure compliance with all platform guidelines and policies, particularly those specific to apps using location services. 3. Create effective promotional materials, including screenshots, graphics, and app descriptions for the listings. 4. Efficiently manage the testing, submission, and approval process. 5. Communicate effectively and professionally throughout the project. Requirements: 6. Proven experience in successfully submitting apps to both Apple App Store and Google Play Store. 7. Ability to create high-quality promotional materials for app store listings. 8. Understanding of compliance requirements for apps using location services. 9. Ability to work independently and communicate effectively, particularly during US time zones. 10. Familiarity...

I require a new, simple landing page to be created for my website. The main goal of this landing page is to provide a brief introduction of our company and our services, and to encourage visitors to engage with us through a call-to-action button. Key inclusions for this landing page: - Our company logo and name - A brief, concise description of our product/service - A clear and appealing call-to-action button that says "Get Quote" I am seeking a skilled web designer/developer who can create an engaging, visually appealing and user-friendly landing page that will help drive conversions and capture leads. Experience in creating landing pages with strong call-to-action elements is a definite plus.

I need a skilled professional who can aid me in creating a business plan for a consulting service offering nutritional advice. This project includes setting up a website to reach potential clients. Key Responsibilities: - Develop a comprehensive business plan tailored to the nutrition industry. - Create a user-friendly and dynamic website promoting our services. Ideal Skills: - Business planning and strategy experience - Proficient in web design - Knowledge of micronutrients and macronutrients - Experience in healthcare/nutrition industry Your expertise in consulting for the wellness and nutrition industry will be critical in guiding this project to success.

As a business owner, I am looking for a freelancer talented in creating and organizing multimedia content for my website, promoting specific products/services in a hierarchical fashion. This is a brilliant opportunity for skilled creatives who can transform my vision into an engaging and user-friendly online platform. Key tasks include: - Creating captivating multimedia content such as photos and videos to promote my offerings. - Organizing the multimedia content in a hierarchical structure to create a seamless user experience. Ideally, I am seeking professionals who have: - Proficiency in creating appealing multimedia content. - Excellent understanding of web content organization, particularly the hierarchical structure. - Demonstrated experience with similar projects.

I'm in need of an Instagram specialist who can expertly set up a new account for the purpose of promoting my products or services. Your key responsibilities will include: - Account setup: Efficient and thoughtful creation of a new Instagram account that aligns with our branding. Ideal candidate should have proven experience in Instagram account setup and optimization.

I'm seeking a creative mind to produce engaging reels for my real estate project. These reels will encompass various aspects including: 1. Virtual Tours: Making use of compelling visuals and narratives to show prospective clients around properties. 2. Testimonial Reels: Crafting engaging narratives from client testimonials to encourage trust and interest in our services. 3. Tips: Offering home staging advice, as well as tips for buying and selling a house. These tips should be concise, informative, and engaging. It's essential the freelancer has a knack for storytelling, video editing, and content creation in the real estate industry. Experience in creating reels is of high importance. Truly understanding the real estate marketplace and able to communicate effectively...

...Exchange/Messaging: Provides design, implementation, migration, and high-level troubleshooting services for Microsoft Exchange and messaging systems, including Microsoft365. Windows Servers: Provides project design + implementation, and high-level troubleshooting for infrastructure, including Windows Server (2019, 2016, 2012 R2, 2012, 2008 R2, 2003) and virtualization environments on both Hyper-V and vSphere, in addition to Citrix XenApp and/or XenDesktop, and Azure Virtual Desktop. Active Directory: Provides project design + implementation and high-level troubleshooting for Active Directory, including Azure Active Directory (Intra AD), Intune, AutoPilot, Group Policy, Access/Identity Management, AADS, Federation Services, Domain Controllers, etc. for medium to enterpr...

I'm in need of a skilled Google Ads expert to help me generate inquiries for flight bookings. I'd like to emphasize that the primary goal of these calls is to handle inquiries about our flight booking services, assisting potential customers in understanding our offerings, and ultimately driving them to make bookings. Key Responsibilities: - Creating and managing effective Google Ads campaigns to target potential customers in need of flight booking services. - Ensuring the ads are strategic and enticing enough to generate a good number of quality inquiries. - Tracking and analyzing the performance of the campaigns and making necessary adjustments to optimize results. The ideal candidate should have a strong background in: - Google Ads campaign management - Experie...

I am in need of a professional website designer to create a website for our new company, Econo Group. The primary goal of the website is to generate leads for our services in plumbing and pressure cleaning and excavation. Key Features: - Service Descriptions: The website should clearly outline the range of services we offer in plumbing and pressure cleaning and excavation. It's important that potential customers understand the quality and scope of our services. - Before and After Photos: We would like to include a gallery of before and after photos showcasing the outcomes of our services. These images should be prominently displayed in a way that highlights the effectiveness of our work. - Contact Information: It's essential that users can easily fi...

...agent who speaks both English and Spanish. This role is primarily for selling our telecom service through outbound sales calls. Key Responsibilities: - Conducting outbound sales calls to potential customers - Converting leads into sales - Achieving and exceeding sales targets Ideal Candidate: - Proficient in English and Spanish - Previous experience in outbound sales - Familiarity with telecom services (preferred) - Excellent communication and negotiation skills - Proven track record in meeting and exceeding sales targets - Self-motivated, results-oriented and customer-centric What we offer: - Working hours: from Monday to Friday, from 8:00 am to 6:00 pm PST. - We offer USD 200/week Plus Commissions. This is a great opportunity for a sales professional looking to expand their...

Closing down various AWS services and migrating to InMotion, as discussed via chat. Thanks!

I'm looking for a skilled English to Chinese interpreter to assist me in a casual business meeting over Zoom. Key Requirements: - Proficient in both English and Chinese with experience in interpretation services - Understanding of business language and etiquette - Comfortable with Zoom or similar video conferencing tools Given it's a one-time event and the level of formality is casual, I'm not expecting stiff, overly formalized interpretations. A more conversational style would be appropriate. Ideal candidates should be able to convey the message in a clear and concise manner, while ensuring the tone and intention of the speaker are accurately reflected.

...be responsible for network administration, server management, and software installation and updates. Key responsibilities will include, but are not limited to: - Managing and maintaining our network and server infrastructure - Implementing necessary software updates and installations Ideal candidates will have proven experience in a similar role, with a strong understanding of IT support services. They should be comfortable working in a team of more than five and collaborating with existing IT support members. The successful IT Systems Administrator will need to be proactive, responsible, and effective at communicating with non-technical team members. Demonstrated skills in problem-solving, project management, and the ability to prioritize tasks effectively are essential. ...

I need a concise and informative PowerPoint presentation done on the Disabled Facilities Grant (DFG) in the UK. This will be presented in PPT and should run for 8 minutes, no AI: MAIN QUERY OF TASK: "The DFG team currently has a large backlog of cases, both children and adults, that need to be dealt with and processed promptly and efficiently. We will be undertaking a process review to enable us to achieve eliminate the backlog. What suggestion would you have to update the process, and the service, ensure HBC compliance, and ultimately customer satisfaction? Key Task: - Conduct Research: The main focus of this presentation will be the process review of the DFG application process in the UK. The ideal candidate should have a strong background in thorough research and experienc...

I need a logo for my new business, IT Pros 365. It's a company that offers IT managed services including network monitoring, data backup and recovery, and proactive system maintenance. The ideal logo for my company should reflect professionalism, trustworthiness, and expertise. The design should be clear, simple, and memorable, while also conveying a sense of security and reliability. It should be suitable for various uses - online, printed materials, and more. The skills and experience I'm looking for in a designer: - Proven experience in creating logos for IT companies or businesses with a similar focus - Understanding of the IT industry and managed services - Ability to translate complex concepts into visually appealing and understandable design - Proficiency ...

...developer who can help in launching an informational website. Here's what you need to know. * Purpose: The objective of the website is to disseminate informational content. Although it doesn't have an e-commerce feature, it should be user-friendly with a clean and professional look. * Pages: The website should include the following pages - Home, About Us, Services, Contact, Portfolio, Testimonials, and a special page for Resume Writing Services. * Applications: Please include a detailed project proposal when applying. This should outline your plans for the project, including how you intend to make the website functional, engaging, and user-friendly. Make sure to include a proposed timeline and budget. Ideal Skills: > - Web Development > - User Experienc...

Please Sign Up or Login to see details.

allawns is a landscaping corporation based in the midwestern United States it serves Ohio,Pennsylvania Virginia, and Indiana- services mainly offers for outdoor seasonal times of summer spring fall and winter. A text based logo is preferred as allawns will be relying heavily on the powerful and simple friendly miniminal logo Key specifications: - The design style should be modern and minimalist, yet striking enough to create a lasting impact. - Predominant colors to be used are free to be chosen by the artist Please feel free to use these creatively to render a modern feel. - Even though I've skipped the specification for any specific symbols or icons, I am open to your creative inputs. However, the logo must remain crisp and professional. Ideal candidate: - You should have...

I'm in need of a website designer for my small business. The main purpose of the website will be to showcase the products/services that my company offers. Key Requirements: - Design a Small Business Website: The primary focus of the site will be to showcase our products and services. - Product Catalog with Categories: An organized, user-friendly product catalog will be featured on the website. - Online Booking/Appointment System: The site must include a functional online booking/appointment system to facilitate client interactions. - Multi-Page Extension: The initial site will focus on product/service showcasing. However, it will need to eventually extend to multiple pages like HR, Finance and other divisions. Ideal Skills: - Proven experience in designing E-commerce...

We're on the lookout for a video shooter and editor to help deliver New Project Property tour videos for our real estate business on daily basis. Here's what we need: - Video Editing: We're focused on property tour videos. Your job will include shooting videos and transforming it into a complete, polished tour showcasing the property. - Style: We are not lookin...high-quality videos - Excellent eye for detail to ensure videos are free from errors and inconsistencies - Strong storytelling ability to create engaging and compelling property tour videos - Good time management skills to meet deadlines We encourage individual freelancers. We believe in creating long-term relationships with our collaborators, and if we are satisfied with your work, we might need your services...

I'm seeking a reliable freelancer to import vendor pricing data into Sage. The data is currently stored in a CSV formatted Excel spreadsheet, with data cleaning required prior to import. The project will entail: - Cleaning the vendor pricing data as required - Successfully importing clean data into Sage Ideal Skills: - Proficient in Excel and its functionalities, especially CSV format - Experience in data cleaning - Demonstrated proficiency in Sage, particularly in data import functions - Attention to detail is crucial for this task This task requires a freelancer with the right blend of skills in Microsoft Excel and Sage software to ensure smooth, error-free integration of vendor pricing data.

...professional who can assist us in crafting compelling technical and financial proposals for our events. This role involves creating visually appealing designs and themes that align with our clients' objectives and summarizing them into concise proposals that capture attention and secure contracts. Skills Required: Proficiency in writing technical and financial proposals for event management services. Experience in graphic design, including creating visually engaging themes and layouts. Ability to synthesize complex information into clear and concise summary proposals. Attention to detail and a creative mindset to develop innovative solutions that exceed client expectations. Responsibilities: Collaborate and understand client requirements and objectives. Develop comprehen...

I'm looking for a simple and clean Shopify website to showcase my food and allow customers to order food on my website. Key Requirements: - I need the website to be designed in a minimalist and clean style, with a user-friendly and easy-to-navigate interface. - The focus should be on showcasing my products and services effectively. Ideal Skills and Experience: - Previous experience with designing and developing Shopify websites is essential. - A good eye for minimalist and clean design, with the ability to create an elegant and sophisticated look. - Understanding of user experience and ability to design a website that is easy to navigate. - Strong communication skills and the ability to understand and incorporate my business requirements into the website design. Pleas...

I'm seeking a talented graphic designer to create a logo and business cards for Lemmon & Hale, PLLC. This project requires design with Victorian influences and color scheme, including rich hues of red, burgundy, chestnut, dark green, brown, and blue. ...and color scheme, including rich hues of red, burgundy, chestnut, dark green, brown, and blue. We would like to incorporate a Victorian and/or a subtle Catholic icon, possibly with the letters LH in the middle. Skills & Experience: - Advanced graphic design - Knowledge of Victorian and Icon symbolism - Creativity and attention to detail - Experience designing for law firms or professional services would be a plus. The ideal freelancer will produce a logo and business cards that reflect the prestige and professio...

I'm looking to develop an interactive and user-friendly website for my on-demand car workshop. This platform will primarily offer car repair, car maintenance, and tire replacement services. Key Features: - **Online Booking System:** The website needs to have a seamless online booking system. Customers should be able to easily select the service they need, choose a suitable time, and make a reservation. - **Service Pricing Information:** Transparent pricing is essential. I want all service costs clearly listed on the website so that customers know what to expect without any hidden fees. Design Preferences: - **Clean and Modern:** The design should be minimalistic, appealing, and easy to navigate. Prioritizing a clean and modern look is crucial. The ideal candidate for this ...

I'm looking to create an engaging Wordpress website to highlight the services provided by my Zym Centre. With a primary focus on our service offerings, the website needs to effectively represent the unique benefits that our zym centre provides. Key Features: - Display of various services we offer Ideal freelancer: - Telugu Candidates(most Preferable) - Experience in developing portfolio websites - Strong knowledge of Wordpress - Previous work with fitness or wellness sectors would be a bonus.

I'm seeking an experienced designer to creat...design. - Strong understanding of color theory, particularly in using bright and bold colors effectively. - Experience in designing for multiple platforms, ensuring the logo remains clear and impactful in various sizes and formats. If you have a portfolio showcasing similar projects you've worked on, I'd love to see it. My business name is : "DEFRILEX Defrilex is a corporation : language services, virtual call center, real estate company, online stores, media and entertainments, consultation. So DEFRILEX is the umbrella company that regroups all the above. I need ORIGINAL logo design, no AI generated logo. I need all the layers for logo animations, and other publications. I need high quality logos. take your ...

I am in need of an expert React Native developer to upgrade my existing app running v0.59.9 and bring it up to date with the latest version of React Native v7.0+ In addition to the platform upgrade also need to: - Upgrade Facebook SDK for FB login to continue working - Adjust query in 'My Activities' to only show activities created in the past, while 'Latest Activities' should only show future activities from all users within radius Skills and Experience: - Proficient in React Native - Experienced in upgrading apps to support multiple platforms - Familiar with the latest version of React Native

...looking to develop an e-commerce site specifically for selling digital products through subscription services. I need a proficient web developer experienced in creating user-friendly and secure e-commerce platforms. Key Functions Include: - Subscription management: The website should allow users to easily manage their subscriptions, including signing up, payment processing, upgrading, downgrading, and canceling. - Secure payment gateway: The site must have a fully-integrated, secure payment system that can handle regular subscription payments. Skills & Experience Required: - Proven track record in e-commerce website development. - Expertise in setting up and managing subscription services. - Proficiency in secure payment gateway integration. - Strong understandi...

I'm looking to create an engaging Wordpress website to highlight the services provided by my Zym Centre. With a primary focus on our service offerings, the website needs to effectively represent the unique benefits that our zym centre provides. Key Features: - Display of various services we offer Ideal freelancer: - Experience in developing portfolio websites - Strong knowledge of Wordpress - Previous work with fitness or wellness sectors would be a bonus.

I'm in need of a professional web developer capable of building a simple, yet elegant, subscriber-based website. My vision fo...Google Sheets database in an engaging manner. This could be in the form of graphs, tables, etc. - Regular updates: The data on the website should be updated weekly directly from Google Sheets (some data in Google Sheets is "live data", and as such the updated are more frequent, but automatic). Therefore, integration skills are crucial. - Core Pages: Standard pages required include 'About Us', 'Services' and 'Contact Us'. Ideal freelancers should have strong experience and skills in web development and Google Sheets integration, alongside great UI/UX design. On top of this, being able to visually present data...

Seeking legal services to amend the visitation schedule of my current child custody arrangement. The desired outcome is to increase my visitation days, prompted by an improvement in my circumstances. Ideal skills for the job: - Proficiency in family law with specific expertise in child custody cases - Demonstrated success in securing desired outcomes for clients seeking modifications to visitation arrangements - Strong communication and negotiation skills Key Responsibilities include: - Review the current child custody agreement - Understanding the improvement in my circumstances - Propose a revised visitation schedule reflecting the desired increase in days - Represent my interests in court if necessary. Please provide previous case outcomes in your proposal.

Company Name: Cerrajería Rivera Tagline: Apertura rápida y segura, siempre Services offered from company: Car unlocking House unlocking Installation and maintenance of residential locks Car keys from scratch with a chip in case of loss Color: Blue

I'm seeking an experienced graphic designer. Due to the open-ended nature of this project, I require someone who can proficiently handle a variety of tasks, from logo design, illustrations, to print design. Ideal Skills: - Versatility in graphic design scope - Ability to work with different color schemes - Familiarity with branding, marketing materials, and website graphics. see attached documents. I'm looking for someone to make the same idea but redesign it and make it look nice. we would also like to add a short description to each service. and add a straight box truck to those

I have a simple but essential task: getting my square porch screened in using polyester mesh. This project partially involves an existing frame, so I need someone who can adeptly work with these parameters and ensure a bug-free porch. Key Details: - Screen material: Polyester mesh - Porch layout: Square - Frame: Partially existing Preferred Skills: - Experience in porch screening or related services - Problem-solving abilities for working with an existing frame - Attention to detail to ensure full bug protection