Combining exel files removing duplicates trabalhos

I have a database containing over 600 serial numbers. Email serial number has an associated email address. Instead of listing the same email address multiple times, I would like a script to place all serial numbers by one email address. This will enable me to email the customer once with ALL of their serial numbers in one email. ...over 600 serial numbers. Email serial number has an associated email address. Instead of listing the same email address multiple times, I would like a script to place all serial numbers by one email address. This will enable me to email the customer once with ALL of their serial numbers in one email. Example: Hannah Walker appears in the database 5 times, the script should remove the four duplicates of Hannah Walker and put all 5 serial numbers by...

I am looking for a proficient photo editor to help me with a project that involves the removal of single person figures from a variety of ...photo editing, ideally with complex scenarios - High proficiency utilizing software such as Adobe Photoshop to alter images in a natural and seamless manner. Ability to maintain consistency of the scene following object removal. - Strong attention to detail, to ensure the final images are free from irregularities or hints of alteration. Your task will specifically concentrate on: - Detecting and removing a single person from an image (see attached) - Ensuring the urban setting remains unchanged and looks natural after the removal. Please reach out if you have the necessary skills and can execute meticulous work, delivering high-quality alter...

My project involves removing a person from a photo and substitivng that figure with more of the fountain that is in the background of the same image. Here are key details: -The photo is in HEIC format. -The person should be entirely replaced in the image, not just removed. -Replace the person with a continuation of the fountain already present in the picture's background. The ideal freelancer for this project would be proficient in photo manipulation and editing, with specific experience in manipulating HEIC file formats. A strong sense of aesthetics and detail is crucial to ensure that the inserted fountain looks as natural as possible in the final product. First photo is the one I would like to be edited to remove the man on the right. Second photo has a better picture of...

Some functions are not working properly. All files of the site are hosted and the site is complete but due to some error while connecting to the database some code is missing and the connection is not completed. You have to find out where the problem is and fix it properly. I will help you in everything ******* I'm seeking a skilled PHP developer to assist with a project that involves fixing a PHP file and combining a Php ,MySQL database. The main tasks for this project include: - Resolving a database connection issue in the PHP file. - Combining the MySQL database in the backend of the PHP file. Your role will be crucial in ensuring that the database is correctly integrated into the PHP file and that the database connection is stable and error-free. The PH...

I'm in need of an engaging and interactive activity book to complement my upcoming children's book designed for children between the ages of 5 and 8. The activity book should contain 32-40 pages, combining a variety of activities to keep young minds entertained and stimulated. Key Requirements: - A blend of different activities: I'm looking for a mix of activities, particularly coloring pages, mazes, word scrambles, picture matching, and find objects in pictures. These activities should be both fun and educational, reinforcing the themes and characters of the book. - Specific Inclusions: The coloring pages should predominantly feature the main character of the book as well as key scenes. These illustrations should be vivid and appealing to children in the target ag...

I urgently need an experienced photo editor who can bring to life a deeply personal project. This revolves around creating a fitting tribute for a deceased classmate. The tasks involved in this project include: - Removing the current background from the photo - Adding a cap and gown to the person in the picture - Merging the modified photo with another one Please note that this project requires utmost attention to detail to ensure that the final product looks as natural as possible. As it carries emotional significance, it's paramount to handle this task sensitively and respectfully. Ideal candidates should have significant experience in advanced photo editing techniques such as object adding, background removal, and image merging. Please provide evidence of similar projects...

As a web development company, we're looking for a multi-talented VFX designer with website designing skills. This individual would primarily be responsible for infusing our site with a mix of motion graphics and 3D animation. The website's theme is to be playful so the animations must align with this concept. We'd like to see a diverse use of styles, combining realistic, cartoon-like, and abstract elements. Ideal Skills and Experience: • Proven 3D Animation skills • Profound abilities in motion graphics • Website designing experience • Ability to balance different animation styles • Artistic vision that complements a playful theme. The suitable candidate will have a portfolio of projects demonstrating these skills and a keen eye for cr...

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data Analysis: After cleaning, I need the freelancer to perform basic data analysis to extract meaningful insights from the dataset. Ideal Skills: - Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statis...

I'm in need of an automated background remover tool for photo editing. Key Requirements: - Fully automated: The tool should be capable of removing backgrounds from photos without requiring any manual adjustments. - File Format Support: The tool should support the file format for the background removal. - User-friendly: The tool should be easy to use and navigate, even for those with no prior experience in photo editing. Ideal Skills and Experience: - Proficient in programming languages suitable for creating automated tools - Experience in photo editing and understanding of background removal techniques - Prior experience in developing similar tools or software for photo editing purposes The successful candidate will be able to develop a user-friendly, fully automated to...

I have a set of JPEG images featuring people, and I need the background removed. The final images should be delivered in JPEG format with a white background. Key Requirements: - Working on JPEG format images - Removing background professionally, focusing on people - Delivering final images in JPEG format with a white background Ideal Skills/Experience: - Proficiency in background removal - Experience in photo editing, ideally with focus on people - Understanding of different image formats and their implications - Attention to detail and quality control in final image delivery Please ensure you have a good portfolio or examples of similar work to showcase your skills in photo editing and background removal. Any relevant experience in working with people-focused images will be an a...

I am in search of a skilled Photoshop expert for a project involving photo editing of 35 images of my hotel real estate. These images are intended for optimizing my Airbnb listings. Images - Key Editing Requirements: - Removing background: Ensuring that the focus is solely on the property by removing any unnecessary elements. - Enhancing colors and lighting: Making the images visually appealing through color adjustments and lighting enhancements. - Image Sharpening: Emphasizing on the sharpness and details of the images. - Lens correction: Correcting any lens-related distortions to ensure the pictures are accurate. - Image Resizing and Formatting: Preparing the edited photos in the appropriate dimensions

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. Proficiency in using MS Office is also a key requi...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I have a large batch of text data in PDF files that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I need an expert in Photoshop to help with a virtual renovation of a kitchen picture. This involves: - Updating the cabinets and countertops - Changing the flooring - Adding new appliances - Removing a wall The updated aesthetic should reflect a modern style with sleek cabinets and quartz countertops. The right candidate will have extensive experience in photo retouching, graphic design, and image manipulation, especially within interior design contexts. A keen eye for detail and a solid understanding of modern interior design trends will be advantageous.

...only changes. Overwrite records in web database), or Replace database on web (delete database on web and reupload from Access). Administrator must be able to import from Excel files into MS Access database (voters). When importing from excel to MS Access database (locally) then ms access database must be updated with the following rules: 1. When a record doesn’t exist in Access, but exist in Excel, create it 2. When a record exist in Excel and Access (based on field: EL_NO, UPDATED ALL FIELDS FROM EXCEL AND OVERWRITE ACCESS FIELDS except THOSE FIELDS IN Access starting with FINAL_ and user data entries. 3. In excel files there it is possible to exist duplicate entries (based on field EL_NO). In that case remove duplicated and leave the record which has a value (<&...

Por favor, Cadastre-se ou Faça Login para ver os detalhes.

...current font is outdated. I need a modern, sleek, and readable font to be implemented - Redesigning the logo: A logo redesign to reflect the updated color scheme and font Content Updates: - Updating text: The text content on the website needs to be refreshed to be more compelling, accurate and engaging - Adding new images: Incorporating new images to add visual appeal and relevance to the content - Removing outdated information: Clearing out obsolete information to keep the website current and relevant Functionality Improvements: - Edit Wordpress Astra Pro essentials Theme: Enhance the theme and improve its YOAST SEO - Layout Enhancement: Refine the layout of the website to be more user-friendly and visually appealing - Pages & Features: I have a specific set of pages (6),...

I'm currently looking for an expert who can assist in removing plagiarism from a 6421-word academic paper. The primary purpose of the paper is publication in a journal, meaning originality and authenticity is crucial. Key Requirements: - The paper is 6421 words and I need the plagiarism removed promptly. - The document is intended for publication in a journal, so maintaining the original content and context is essential. Ideal Candidate: - Proficient in identifying and rectifying plagiarism. - Experience with academic writing and journal publication. - Capable of working under tight deadlines without compromising quality. If you believe you possess the necessary skills and expertise for this project, I would be excited to hear from you.

...have a set of photos taken with my phone that I need to be optimized in Photoshop. These pictures will be used to promote my moving and transport company. Optimizations: - Adjust Brightness and Contrast: Enhance the visual appeal of the images. - Crop and Resize: Ensure the photos are suitable for multiple marketing platforms. - Remove Background: Enhance the professionalism of the images by removing any background distractions. - Logo Inclusion: Incorporate my company's logo onto the images in a way that makes it appear as though it's a natural part of the vehicles. - There are around 25 pictures attached for you to choose from, but i only need 10 max 15 to be edited. You need to use your experience in choosing what is more professional and what will look better for ...

As the project owner, I am encountering various indexing problems on my WordPress website. These issues specifically stem from noindex tags ...handling technical SEO components, specifically noindex tags and canonical errors - Experience in indexing website pages Your task will be to: - Effectively remove the noindex tags from the specified pages - Accurately fix canonical errors on these pages Ive literally tried EVERYTHING and nothing will get my website indexed properly This job entails dealing with both components mentioned, namely removing the noindex tags and fixing canonical errors. Your comprehensive understanding of SEO, more particularly in WordPress, will be key to successfully completing this project. Your attention to detail and accuracy in resolving these issues ar...

I am looking for an experienced photographer who specializes in portrait photography, with a knack for capturing the beauty of various landscapes. The portraits will be outdoor, inspired by nature, and will be used for personal purposes. Ideal candidates should have: - Prior experience in both portrait and na...Ideal candidates should have: - Prior experience in both portrait and nature photography - An eye for capturing stunning outdoor portraits - Ability to create and imagine scenes that encapsulate the unity of human and nature With that, I look forward to seeing your portfolio and discussing your creative process. Please also include any relevant experience in your proposal. Any previous work combining portraits with landscapes would be advantageous. Let's create beautifu...

...As someone who knows how important SEO plays in the organic growth and visibility of a website, I expect you to employ top-notch strategies in improving my website's reach and visibility. Your tasks will include: - Increasing the organic traffic on my website, - Enhancing my website's search engine rankings, - Driving up conversion rates on-site, - Working on online reputation management by removing any negative comments. Ideal candidates should have: - Specialized experience in SEO for real estate, most notably residential properties. - The ability to implement effective SEO strategies for real estate. - A track record of success in improving organic traffic, search engine rankings, conversion rates for real estate websites, and online reputation management. Y...

...electrical and mechanical engineering principles. - Familiarity with designing for bicycles or other sporting equipment would be a plus. Interview questions below are mandatory: Q1: If current dynamos range between 3W to 7W, but alternators can go up to 100W. Can you make use of existing technology to capture up to a 100W from biking? (For instance using more then one dynamo or alternator or combining both) If yes, how? Q2: Can you create a hybrid system (an in between-system that can be mid-range between producing the low watts of a dynamo and the high watts of an alternator)? If yes, how do you aim to achieve this? Q3: Are you able to optimize the energy capture and storage efficiency of the system in a lightweight manner? (no more then 1kg - including batteries). If yes, des...

I'm in need of a professional who can help me clean up my LinkedIn account by removing 3000 connections that are no longer relevant to my current network. Key requirements: - The task is urgent and should be completed within two weeks. - I'll provide a specific list of connections to remove, so keen attention to detail is crucial. Ideal skills for this job include: - Proficiency in LinkedIn's interface and connection management. - Strong organizational skills and attention to detail - Prior experience in LinkedIn network management This task is critical to enhancing the quality of my LinkedIn networking, so I'm looking for someone who can handle it efficiently and effectively.

I'm seeking a proficient Corel Draw or adobe Ilustrator user with experience in editing vector graphics for laser cutting purposes. Specifically, I require assistance in modifying shapes and cut paths within these files. Key Responsibilities: - Editing vector graphics for laser cutting - Modifying shapes and cut paths as necessary Ideal Skills and Experience: - Proficient in Corel Draw or Adobe Ilustrator - Experience in editing vector graphics

I'm looking for a skilled professional to improve the accuracy of my cloud-based database. To achieve this, the tasks at hand include: - Identifying and removing duplicate entries - Standardizing data formats to ensure consistency - Conducting routine data cleaning checks to maintain accuracy Ideal candidates should have: - Proven experience in data cleaning and management - A deep understanding of cloud-based database systems - Strong communication skills as I prefer to get updates and progress reports through an instant messaging app.

I'm looking for a skilled professional who can help clean up some Polycam 3D scans for 3D printing. The main tasks include: - Removing noise and artifacts: The scans have some imperfections that need to be cleaned up. - Smoothing the surface: The model needs to have a smooth finish for 3D printing. - Closing holes in the model: I need any gaps or holes in the model to be fixed. I am able to download the scans in multiple file formats, so please let me know which one works best for you. Additionally, I intend to sell these prints, so you will need to sign a Non-Disclosure Agreement. Ideal skills and experience for this job include: - Proficiency in 3D modeling and 3D printing - Experience with cleaning up 3D scans - Attention to detail - Knowledge of file formats such as STL,...

I have a unique project focusing on the creation of 3D OBJ files, which will subsequently be used to develop aesthetically pleasing MP4 video presentations for jewellery pieces. Key Deliverables: - Creation of finely detailed 3D OBJ files for specific jewellery designs. - Conversion of these 3D models into 360-degree rotation MP4 videos showcasing the designs. Ideal Skills: - Proficiency in 3D modelling software to create detailed OBJ files. - Significant experience in video animation/rendering, specifically with jewellery. - A keen eye for detail and a strong aesthetic sense to capture the allure of the jewellery pieces. Your portfolio showcasing previously created 3D models and MP4 videos will be highly appreciated. I believe this project offers an exciting opport...

I have a bulk of digital files that need to be accurately transcribed into a digital format. The files are all in English, so proficiency in English is necessary for this project. Ideal skills and experience include: - Proficient in English - Fast and accurate typing skills - Experience with data entry

I have a large set of data in Excel that requires thorough cleaning and organizing. - Tasks include: - Removing duplicates - Standardizing data formats - Data validation and verification - Identifying and correcting errors - Sorting and categorizing data Ideal Skills: - Proficiency in Excel or similar data management tools - Experience with data cleaning and organization - Strong attention to detail and accuracy The volume of data is significant, so I'm looking for someone who can work efficiently without compromising the quality of the work.

I require a Photoshop expert to digitally apply fresh paint to specific features in 5 exterior photos of this house. You will focus primarily on the decks and trim. This project calls for a realistic and high-quality end result because they will be used for print. I also need this turned around in 24 hours. Today is May 16, 2024 in United States 2:30 Mountain Time. * Removing any visual aging or wear from the deck/trim areas on the left side of the house to match the right side * Applying a new coat of paint to these specific areas * Enhancing the images to make the new paint look fresh and realistic.

I'm looking for a content creator capable of producing engaging software tutorials and product demonstrations. The content should be designed for my website, combining videos and PDFs. The project is focused on: - Software tutorials: These should be clear, concise, and easy to follow. - Product demonstrations: These should be engaging, showcasing the software's features and benefits. The specific skills and expertise required for this project include: - Experience with software tutorials and product demonstrations - Proficiency in video editing and creation - The ability to translate complex information into easy-to-follow content - Attention to detail in creating visually engaging PDFs The tone of the content should be strictly educational, aiming to inform the vi...

I am looking for an expert in photo editing and retouching. My goal is to enhance the visual appeal of an image by opening the subject's eyes and removing any distracting elements in the background. Here are the details: - Skillfully open the eyes of the subject in the photo to create a natural and engaging look. - Remove unwanted elements from the background to bring the focus back to the main subject. - Retouch and improve the overall composition of the photo, preserving it's natural ambiance while adding a touch of vibrancy. - The final edited image should be in medium resolution (150dpi). - The image is to convey an emotional tone of happiness. Ideal candidate should have strong experience in image retouching, background cleanup and expert skills in Photoshop...

I'm seeking a skilled photo editor for my ecommerce product photos. Here's exactly what I need: - Background removal - Color correction: balancing and adjusting colors for better consistency and enhanced aesthetic appeal. - Blemish removal: smoothing out or removing any spots, wrinkles or imperfections. A sound knowledge of business-oriented visuals will give you an edge in this project. Familiarity with ecommerce product photography will also be beneficial. This project requires attention to detail consistency and ultimately efficient turnaround time.

I am seeking a skilled photo editor who can help in removing unwanted red tones from faces in a large photo, greater than 1 MB. The main objective of this task is to create a more natural-looking appearance, thereby enhancing the overall quality of the photo. Skills and Experience Required: - Expertise in photo editing software - Prior experience with color correction tasks - Exceptional attention to detail - Ability to preserve high image quality during the editing process Upon successful completion of the task, I want the final image delivered in JPEG format. Your bid should include a brief description of how you intend to achieve a natural look. Thank you.

I am seeking a skilled digital illustrator with a flair for AI style artistry. The project will involve creating captivating illustrations of mechanical animals, really playing wi...of life and machinery. Details: - The art style should reflect a unique appreciation for AI aesthetics. - The main theme revolves around mechanical animals, incorporating realistic detail and abstract concepts. - The chosen medium for this project is digital illustration. Ideal Skills: - Proficiency in AI style digital illustration. - Experience in drawing mechanical themes. - A knack for combining realism and abstract elements effectively. If you can translate complex ideas into visually stunning digital art, I want to hear from you. This is your chance to be a part of a captivating art project f...

I'm currently seeking a professional with experience in Battery Management Systems (BMS) to design and develop a LiFePO4 BMS. The key requirements and features include: - BMS should support 8S and 4S configurations - Maximum amperage capacity of 100A - The ability to alter the BMS ampere capacity by adding or removing MOSFETs or any other relevant hardware as required - The BMS should include essential safety features such as: * Temperature monitoring * Short circuit protection * Cell balancing * Reverse polarity protection - The system should allow for charging and discharging through the same port I need this project to be completed within a month. Ideal skills and experience for this job include: - In-depth knowledge and experience in BMS design, particularly w...

I'm looking for a skilled Photoshop expert to handle a range of photo editing tasks. These include: - Enhancing Image Quality: The photos need to be improved in terms of sharpness, color, and overall visual appeal. - Removing Background: Professionally removing the backgrounds of the images, ensuring they are clean and suitable for various purposes. - Adding Filters/Effects: Incorporating suitable filters and effects to enhance the aesthetics of the images. The final edited images should be delivered in three main formats: JPEG, PNG, and TIFF. Experience in these formats and the ability to deliver high-quality work efficiently are essential for this project.

I seek for 20 CAD for the entire project which will be delivered in an hour upon receiving files.

I'm in need of a meticulous freelancer who can accurately transfer textual data from digital files into a Word document. Key Requirements: - Proficiency in data entry - Attention to detail to ensure error-free input - Familiarity with Word processing software I will provide the digital files containing the textual data, and I expect the final output to be in a Word document.

I'm in need of a highly ...customers. - Bright & Colorful: I'm envisioning a design that is lively, colorful, and playful. - Target Audience: The design needs to appeal to a wide range of people, including families with children, young adults, and business professionals. Ideal skills and experience for this project: - Graphic Design: Proficiency in menu design, particularly for traditional formats. - Creativity: A knack for combining bright colors and engaging visuals. - Market Understanding: Experience in designing for broad target audiences. - User Experience (UX) design: Ensuring the menu is easy to navigate and understand for all potential users. If you think you have what it takes to create a menu book that captivates and entices all customers, I look forward ...

Video editing is the art of manipulating and combining video files to create a completed video project. Video Editors will cut together film clips, alter and correct sound mixing, add digital effects, and make other essential technical changes to video files.

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 includes an additional key with the keycode IntlBackslash, which simply cannot be entered from another keyboard format and thus included in the configurations. The task is fairly simple but voluminous. You will need to add various keyboard layouts to the system and press all the keys in turn on a special web page, which will generate a configuration. List of languages: - English - French - German - Italian - Russian - Ukrainian - Belarusian Each language usually has several layouts in the system. You will need to enter all of th...

We are seeking an experienced Email Marketing Specialist to manage and execute email campaigns for our Wix site. With a database of over 24,000 emails collected from our various platforms, we need a professional to cleanse our email list, removing inactive and non-responsive addresses, and develop effective marketing strategies to engage our audience. **Responsibilities:** - Analyze and cleanse a database of approximately 24,000 email addresses to ensure high deliverability. - Develop and execute email campaigns tailored to various segments of our audience. - Monitor and report on the performance of the email campaigns, including open rates, click-through rates, and conversions. - Suggest and implement improvements for future campaigns based on analytics and performance metrics. *...

I have a photograph that needs a specialist touch. The primary task will include: - Removing the shadow from my face to achieve a more natural look. The project doesn't specify any particular area of focus so a balanced approach to the entire face would be appreciated. Ideal candidates will have a robust understanding of photo editing, specifically shadow reduction, and are mindful of preserving the photo's natural appearance. Proficiency in various photo editing software and an eye for detail are essential.

I'm looking for a skilled photo editor who can give some exterior real estate shots the right touch of alteration for an onl...photo editor who can give some exterior real estate shots the right touch of alteration for an online listing. Your role will include: - Removing unwanted objects - Performing sky replacements - Add a garden - Add outdoor furniture - Any other advanced manipulation that can increase the aesthetic appeal of my property images The ideal candidate should not only be proficient in advanced image retouching techniques but also have a keen eye for detail and real estate photography. You create a digital masterpiece from a simple photo. High quality and attention to detail are my keys to attracting potential online buyers. I will send the bigger jpeg fi...

I'm looking for a talented designer to create an illustrative poster for our company, which specializes in removing snakes from homes and businesses. The poster will primarily be displayed in physical locations, so it needs to be eye-catching, informative, and visually engaging. Key Information: - Company name and logo - Services offered (snake removal) - Contact information - Photos (of snakes and/or successful removals) The poster should have the logo and phone number at the top - 0418633474 Caution - Snakes Have Been Found In This Area. In case of snake sighting: *Call snake catcher and discuss next steps * Attempt to continually watch the snake * Try not to scare the snake so it doesn't attempt to hide. *Alert all staff of the situation. * If a bite occurs call 000 ...

I have a bulk of digital files that need to be accurately transcribed into a digital format. The files are all in English, so proficiency in English is necessary for this project. Ideal skills and experience include: - Proficient in English - Fast and accurate typing skills - Experience with data entry