Vlookup if contains işler
Merhaba, Daha önce burdan baya proje konusu açtığım oldu ama amaca ulaşamadım, Amaca ulaşamama sebebi bilemedim hani teklif veriyorda seçiyorum bak diyorum verdiğiniz ücrette son kararınız mı evet diyor adam sonra nedense yapmıyor İngilizce dilim olaydı bak yabancılar hemende nasıl yapar, Türk insanımız sağolsun. Kısaca başka bir projeye yöneldim. Hemen isteğimi belirteyim. Bir sorgulama sitesi olacak şimdi Adresini inceleyiniz site sorgulama uzerine kurulmus fatura, isimden numara numaradan isim gibi v.b , site sadece yönlendirme yaparak link vererek hizmet vermektedir. benim istediğim bunların bot ile örneğin elektrik borcunu varsayın tedaş kurumundan botla veriler çekilerek sorgulanması sağlanacaktır herhangi bir yönlendirme olm...
Python da (pandas) exceli okuyarak tabloya atmak. sonrasında bazı kolon ve rowlarda işlemler yaparak (örneğin excelde filtreleme, vlookup gibi) yeni tablolar olusturmak ve bu tabloları yeni bir excele atmak. eğer çok iyi biliniyorsa bazı grafikler ve social network analizi de isteyebilirim. Reading excel with python (pandas), making some adjustments in the data like sorting or vlookup or some text mining. then extracting each table to the new excel files.
I'm on the hunt for a dynamic writer who can craft persuasive content with an adventurous twist. - Purpose: Your main goal is to persuade our audience. Your words should convince, compel and convert our readers. - Style: Be adventurous! Your content shouldn't just tell stories that resonate; it should encourage our readers to step outside of their comfort zones by weaving in elements of thrill and adventure. - Audience: Our primary target are teenagers, so your content should speak their language—current, cool and captivating. Ideal Skills: - Proven experience in persuasive writing. - Familiarity with youth culture and teenage language. - Mastery in storytelling with an adventurous bent. Your talent to spin words into persuasive messages will be the key to this projec...
We want to receive data in the JT808 format and upload to mysql. We also need a way to send back data with an API for others to send data.
Hi there, I hope this message finds you well. I'm reaching out regarding a data entry project that requires immediate attention. I believe your expertise would greatly contribute to the successful completion of this project. Your prompt response and commitment to quality are highly appreciated. Looking forward to your positive response and collaboration. Warm regards, Ansaf
I'm seeking a talented animator to bring my voiceovers to life on a digital whiteboard. These educational videos, aimed at an adult audience, should be around eight minutes long. I will provide with the voiceovers. I will also provide link to a sample video. Looking for long term friendship in this field. So quote your competitive price. Key Requirements: - Ability to create classic black and white whiteboard animations - Experience in developing content for adults - Able to accurately depict the topics provided through the voiceover - Commitment to deliver an 8-minute-long video - Strong understanding of how to engage and educate through visual storytelling
...medical translations - specifically from English to Spanish. This project involves the translation of a clinical card which is in the format of a medical report. Here's what's needed specifically: - The translated copy will be used by a Medical Professional, hence, the translation should maintain its professionalism, accuracy, and relevance to the medical field. - Although the report mainly contains general medical terms, it's crucial that these specific terms are correctly translated while maintaining the original meaning intact. A background in medical literature or related field would be beneficial. - Punctuality and attention to detail is a must, especially when considering that the document involves sensitive information. - High translation quality is als...
I'm seeking a talented animator to bring my voiceovers to life on a digital whiteboard. These educational videos, aimed at an adult audience, should be around eight minutes long. I will provide with the voiceovers. I will also provide link to a sample video. Looking for long term friendship in this field. So quote your competitive price. Key Requirements: - Ability to create classic black and white whiteboard animations - Experience in developing content for adults - Able to accurately depict the topics provided through the voiceover - Commitment to deliver an 8-minute-long video - Strong understanding of how to engage and educate through visual storytelling
I need a comprehensive email list of more than 100 small beauty clinics situated in Denmark. This list will be used for email marketing campaigns and potential business partnerships. The ideal...Denmark. This list will be used for email marketing campaigns and potential business partnerships. The ideal freelancer for this project will have: -Experience in data mining and scraping -Knowledge of the Denmark beauty industry -Vast experience in compiling email lists Your task will be to: -Identify and compile an email list of small Danish beauty clinics -Ensure the list is expansive and contains more than 100 clinics -Provide proof of due diligence in the clinic size selection Please note that we are specifically targeting small size clinics. Your list should reflect this p...
I need a skilled developer to start a Chrome extension project. The development requirements are simple but the project contains a few important decisions to take. I plan to continue this project in the future and I want you to choose platforms and tools which are easy to work with. You will also build a basic CI/CD to allow fast testing and deployment in the future. This project includes several components: 1. **Backend**: Create a basic python backend using FastAPI. The backend should support encrypted communication. 2. **Chrome Extension**: User can send textual page content to the server to be logged in a database. In the database, text is indexed by user-id and url. 3. **User Authentication**: The extension will use Google sign-in for user authentication. 4. **Deployment**...
Overview In this challenge, you are tasked with the simulation of mining process of a block, which includes validating and including transactions from a given set of transactions. The repository contains a folder mempool which contains JSON files. These files represent individual transactions, some of which may be invalid. Your goal is to successfully mine a block by including only the valid transactions, following the specific requirements outlined below. Objective Your primary objective is to write a script that processes a series of transactions, validates them, and then mines them into a block. The output of your script should be a file named that follows a specific format. Requirements Input You are provided with a folder named mempool containing several JSON files. E...
More details: What programming language would you like the freelancer to use for implementing the Chrome controller? Python What specific inputs do you want to be made on the page? Text data What specific actions should be taken to confirm status if finished? Await page popup, Scan page for specific text, Check a specific form element on page for status change
Make list of all the car workshops with their email in a region in Belgium And if possible also mail the provided letter — if succesfull would also be needed for other industries
I have a folder that contains scanned images of invoices and delivery documents. They are named by the document number. i.e 000001.pdf. I want a python or delphi program that will check the folder for a document. When you find one. you will process it as follows. 1. found document to process. 2. open text file. Probably CSV format. Lookup document number and get email address from 2nd Field. 3. Create email with predefined subject and content (html) 4. send message to a specific ip address and port. 5. on sucess. Move file to done folder. 6. on fail. If failure is Missing record for email address. Move to “missing email folder” if any other error move to failed folder. Add to reason for failure. 7. process next file. (add short sleep to not overloa...
...the attached colors, logo, screenshots, and graphics. The attached zip file has the logo, colors, and some sample graphics you should use when creating your sample presentation, so please review the files in teh zip. I will select the winner who creates the best looking sample presentation. Once I select you as the winner, I will provide you with our unformatted power point presentation which contains all of the actual final content that must be used in the actual presentation that you will complete for us. You will apply the approved design style to the presentation and complete it, provide a few round of basic revisions to ensure it is perfect. We will then release the contest award to you. We will provide 3 prizes for 1st, 2nd, and 3rd place entries in order to encoura...
Unfortunately, I'm facing a difficult issue with a corrupted PowerPoint 2019 file. I need a tech-savvy freelancer to help me recover all elements, inclu...as well as video and audio content. - Access: I fully own and have access to the corrupted file. - PowerPoint Version: The presentation was originally created with PowerPoint 2019. - Content Recovery: The PowerPoint contains a combination of text and images, video and audio elements, and charts and tables which all needs to be fully restored. Ideal Skills and Experience: Familiarity and expertise with PowerPoint 2019 is absolutely necessary, as well as a background in troubleshooting and file recovery. Knowledge of video and audio formats would also be beneficial. If you're skilled at salvaging seemingly los...
I need a Simulink model needs to be upgraded. The existing model contains a battery. I wanted the model to use AEFK algorithm to predict battery SOC. I expect the freelancer to add Adaptive kalman filtering technique (AEFK) to the model to estimate the Battery State-of-Health. Reference model: The battery model is attached below. NOTE: ONLY ELECTRICAL ENGINEERS ARE PREFERRED The selected freelancer also have the choice to work for long term commitment. In that case, they should have the potential to undertake 2-3 such small and intermediate level projects per month
I am looking for a Shopify specialist who can help me create a table within a collection. This collection on my Shopify Store contains links to datasheets and technical specifications. Ensuring a seamless user interface and flawless mobile interface is key. The end goal is to have a well-structured table that's both informative and visually appealing in PC as well as mobile. Let's connect and discuss how you can help me achieve this. Please check out the temporary table on the following link Please submit your design proposal
I'm looking to collaborate with an experienced website developer to create a portfolio website of 6-10 pages. The aim of this website is to present a striking, interactive portfolio that contains both photo collections and video clips. Key Requirements: - Development of a portfolio website displaying photos and videos - Creation of 6-10 detailed and engaging pages - Incorporation of a sleek, user-friendly design Ideal Skills: - Proficiency in modern website development - A good eye for design aesthetics - Experience in creating portfolio websites - Strong understanding of photo and video integration on websites Your creativity, technical skill and an extensive portfolio to evidence these will make you a top candidate for this project.
We have a .NET MVC application. We are using 4.5.2 framework. We can upgrade if needed. We are looking for a sample code to implement Azure SAML Single Sign On(SSO). You can use component if you want. You will create your own Azure account and just complete the code in C#. You will give us a demo to implement in our portal. You will also create the documentation on how to implement that. Steps: 1. register custom app in azure. Click on that application should catch the email address and other fields on the C# page.
I am looking for a skilled developer with substantial experience in WordPress that can optimise my site for speed performance, specifically focusing on improving the page load speed. Key Details: - The website is built on the WordPress platform. - The predominant concern is the page load speed. - The website contains eCommerce features which might affect load speed. The ideal candidate should demonstrate prior experience in similar projects and be capable of handling possible hitches that might arise from the eCommerce features. This will involve making necessary adjustments and suggestions to ensure the page load speed is at its best without compromising user experience. WordPress and eCommerce experience, alongside an astute understanding of speed optimization practices, will ...
I need to convert the following Perl code to PHP: The expected output is a PHP class that can convert a docx file into text. The attached zip contains a mockup of such class (with demo code) and a test docx file. The task is straight forward. If you place a bid, expect it to be accepted. If you fail to deliver, you'll be subjected to a bad review. This is to avoid wasting my time with autoposters and people who lowball the bid and then try to ask for more money. You have been warned. Read the brief, check the code and place a bid accordingly.
I am looking for an experienced data analyst who is well-versed in PySpark to clean up a medium-sized dataset in a CSV file format. The file contains between 10k-100k rows, and your primary role will be to: - Remove duplicate data entries - Deduplicate the dataset - Handle missing values - Aggregate the resultant data Your proficiency in using PySpark to automate these processes efficiently will be critical to the success of this project. Therefore, prior experience in handling and cleaning similar large datasets would be beneficial. Please note, this project requires precision, meticulousness, and a good understanding of data aggregation principles.
I am looking for a freelancer who excels at copy typing from PDF to word. The task involves replicating a PDF document that contains a mix of text and images into a text-only document. Ideal skills and experience: - High proficiency in Microsoft Word - Exceptional attention to detail - Ability to accurately copy typing from PDF to a Word document. - Proven track record of data entry or similar tasks. Though the PDF contains both text and images, only the text contents are meant to be copied. No images have to be included in the final document. Your prime job will be to ensure that the document's textual integrity remains intact. Please place your bid if you satisfy the above requirements and are ready to begin the task immediately.
We are looking for a creative Wordpress Elementor designer who can help us design a small webshop with Italian delicacies. The webshop contains around 40 products and 5 product categories (Olive Oil, Truffle Products, Aceto Balsamic, Charcuterie & Miscellaneous). All products and categories have already been added in the WooCommerce admin console. So it only involves designing the layout of 6 web pages with Elementor Pro. My project involves: - The design of 5 distinct web pages for an E-commerce site (Home, shop, About, Basket, Checkout) - Integration of customized headers and footers on each webpage The current website is already equipped with Wordpress, Elementor Pro & WooCommerce behind it. These things therefore no longer need to be installed. We can also provide: ...
I require assistance with my MySQL database which contains birthday data. Currently, the birthdays are sorted by year, though I need them to be sorted by day. The given birthday data is formatted as a date. I need a professional who is an expert in MySQL to help sort these records and retain accurate data. * Key Job Requirements - Proficient in MySQL - Able to sort date-type data in MySQL - Detail oriented for data accuracy The ideal candidate should have a solid understanding of database management, more specifically in MySQL. Your role will be to sort the birthdays in the required order: day, then month. Confirmation of understanding of this order is essential for job success.
I need a Simulink model needs to be upgraded. The existing model contains a battery. I wanted the model to use AEFK algorithm to predict battery SOC. I expect the freelancer to add Adaptive kalman filtering technique (AEFK) to the model to estimate the Battery State-of-Health. Reference model: The battery model is attached below. NOTE: ONLY ELECTRICAL ENGINEERS ARE PREFERRED
I'm looking for a talented packaging designer to assist me in creating a modern and impactful design for a tin box that contains motorcycle parts. The design will primarily aim to enhance our brand identity and appeal specifically to the South American market. Key requirements include: - The use of orange and black, which are our brand colors - Please refer to the attached current brand design moldboard for reference (but do not copy, we are looking for creative ideas here) and the source file for sizing reference - Logo must remain the same - The creation of a BOLD and modern design that can stand out, refer to current design -DO NOT USE design that may look too fancy/soft/cute looking. -DO NOT USE gradient as it does not print - Ideally, previous experience in package desig...
I need a Simulink model needs to be upgraded. The existing model contains a battery. I wanted the model to use AEFK algorithm to predict battery SOC. I expect the freelancer to add Adaptive kalman filtering technique (AEFK) to the model to estimate the Battery State-of-Health. Reference model: The battery model is attached below. NOTE: ONLY ELECTRICAL ENGINEERS ARE PREFERRED
Graphic designer to craft party invitation for my son's upcoming 10th birthday. We are hosting a Gaming/ Virtual Reality themed party and would like the invitation to reflect FORNITE and PS5. Your task will be to: - Incorporate a combination of gaming and VR elements. - Ensure the invitation contains basic information including: the date and time of the party, the venue's address and a note reminding attendees to bring their game controller. - Propose a color scheme that fits the theme. I'm open to ideas and would love to see different proposals. Ideal sources will have enough ability to copy/paste one of the ideas showed. I'm looking forward to seeing your imaginative ideas. "GAME ON" "MANU" "Have reach level 10" "Let...
I have a project that requires someone with experience scraping and assembling research in a data spread. The below link contains 165 fairs, which are already in my spreadsheet: This job requires you to find additional fairs that are not on my list, such as this one: and The idea of this assignment is to make a sheet that contains not just very highly respected art fairs, but also smaller ones like these two examples that have been around for a long time but are not necessarily listed everywhere. I need you to add columns and data to my sheet, including the closing date of the fair, and the fair's website. You also must have a high completion rating and job count in order
I would like to design and program a database and interfaces for website It contains electronic applications The idea of the site is to combine two projects into one project, that is, merging the direct classified advertising project with the freelancing project in one site. I have a Photoshop design that explains the details of the project, consisting of 244 pages
...developer to implement the new design. Additionally, we are looking to make changes to our content management system (CMS) to deliver a better online experience for our users. 2.0 CMS Changes The content management system is currently structured around the concept of a fortnightly bulletin which has articles and events. Our online platform allows users to: • Download a Microsoft Word document that contains the articles from a specific bulletin and a list of upcoming events within that month from all bulletins. • View articles broken down by category from a specific bulletin. • View articles broken down by category from all bulletins. • View a calendar of events from all bulletins. We are looking to make changes to the content management system that will al...
More details: What is the purpose of the translated documents? Business use What type of business documents need to be translated? Technical manuals Does your technical manual contain specific industry terminologies? Yes, it contains specific industry terminologies
Hi, I’m looking for a Django developer with significant experience in full-stack development. The reason they have to be US / Canadian based is due to the fact that contains very specific American real estate language which if not known to some extent and being easily understood - makes an otherwise simple task - impossible. Whilst the task itself is isolated to a great extent from the much larger project, unless the meaning of the words comes as second nature - it would take more time to document the task than to just do it. Further the tasks requires access to a database key that is not a toy. As per the auto generated blurb below - celery and sql skill sets are also required. Thanks for your consideration. - Being geographically placed in the US or Canada is not ...
I'm seeking an SEO expert who can increase traffic to my website and boost its online visibility. This project will require working on three main areas: - Site structure and navigation: I need someone who is proficient with navigating back-end complexities and can ensure our pages have the right hierarchy to maximize SEO. - Content optimization: My website contains a considerable amount of content which needs a thorough audit and optimization to align with best SEO practices. I am looking for someone with excellent knowledge of keyword research and on-page optimization. I want high visibility in the UK, USA and Germany. - Technical SEO: My website may have underlying technical issues that need rectification. Potential errors could be related to mobile optimization, speed, Me...
...more voluminous than others. Therefore, text length should be evaluated with a real book approach instead of the number of characters, words, or sentences. The first two pages will have the text arranged in a circular shape, same as the attached pictures, and the rest will be rectangular, same as the attached pictures. I added the font type (ttf) that is required to be displayed on the text and contains the Surah name box and the verse separator. I don't care about colors, backgrounds, or anything else, just the texts and the way they are presented in the required order The ideal freelancer would have explained experience working with SwiftUI and JSON files. Familiarity with implementing unique ordering systems, especially according to custom specifications, would also b...
...instructions and work independently. -Excellent time management skills – this project has a tight deadline. -Familiarity with spreadsheets or database software. Scope of Work: -You will be given access to a list of vehicle owner data. -Your task will be to verify and update the expiry dates of vehicle ownership in our database using the information available on a specified website. -The list contains approximately [10000] entries. Confidentiality is paramount; you must ensure that all data remains secure and is handled in compliance with data protection regulations. Timeline: The project needs to be completed within 3 days from the start date. Budget: We are willing to pay 600 INR for the complete project. Please provide your quote considering the scope and timeline o...
...than 50 product pages of my website. Due to gaps in the previous system, our current forms were not defined, but I am looking for the implementation of new, user-friendly designs that are free from technical issues. Contact forms should be sent to my email along with an order and indicate which order they are associated with. The contact form currenly on the site should be used as a template and contains all the necessary fields except for one. The missing field is "describe any customizations you would like to make to the dress." It should be the first field. Ideal skills include: - Extensive experience in web development - Proficiency in HTML, CSS, Javascript - Strong communication to ensure accurate implementation - Ability to troubleshoot and correct any potentia...
I want to create Google add on, which can be downloaded by different users. Work: to send multiple email to different users with custome message, attachment and title. These data located in Google spreadsheet which contains the field like name of email receiver, email id, title , name of file for attachment, message etc. There is no constraints for paid users while for free users daily email are limited to 10.
I need an expert translator to convert an English business document into French. - The document contains specific brand names that must be kept intact in English, having the ability to differentiate these from the text that needs to be translated is critical. - You should be fluent in both English and French, proficient in business jargon of both languages, and have a strong understanding of preserving proprietary names during translation. - A background in translating business or official documents is preferred. Your attention to detail will ensure the accurate translation of this business document while maintaining its original integrity. Skills and Experience: - Proficient in English and French - Understanding brand names and trademarks - Experience in translating busine...
I'm launching a kava bar that offers a unique selection of kava, coffee, hookah, and snacks. I'm in need of a full branding suite that includes a logo, menu, and storefront sign design. The aesthetic should align with the interior colors of the bar, reflecting a professional and luxurious vibe. The ideal candidate will have experience in creating cohesive branding materials that not only match the interior design but also enhance the overall customer experience. This project requires a keen eye for detail and a creative approach to ensure the branding effectively communicates the upscale and inviting atmosphere of our kava bar.
...1. On the form, there is a field that says "Not You? If the above name and email are incorrect. Click here to login to your account or create a new profile." Add functionality so that link logs out the current user, then redirects them to: 2. After completing the form, the data should get pushed into Freeagent. Map fields as outlined below: - Look up existing FreeAgent record based on field FreeAgent Id (for contact) (id: 24). This is a hidden field added to the form which contains the Freeagent contact id. This is stored in the Wordpress user profile and auto populated to the form. The Contact record should already exist in Freeagent from when the user first registered. If no matching contact is found in Freeagent based on ID
I am looking for an expert in online publishing to aid in disseminating my personal journey article. As the piece contains profound insights that politicians, business people, and more may find valuable, I believe it's crucial for it to gain great exposure, especially on platforms that host online magazines. Ideal Skills & Experience: - Comprehensive knowledge and experience in online publishing, specifically online magazines. - Strong understanding of the target market (politicians and business people). - Excellent communication and collaboration skills. - Proven track record of successfully published articles. Key Responsibilities: - Identify relevant online magazines that align with the article's targeted audience. - Submit the article to these identified pl...
I'm on the hunt for a talented graphic designer to create a logo for our podcast titled "If I Knew". The logo should visibly convey our main themes: friendship and growth, psychology and philosophy, and life stories. In terms of color scheme, I'm leaning towards a black and gold palette. As for the aesthetic, I'd love a logo that marries minimalistic and modern design. I believe these choices reflect the contemplative, profound nature of our podcast. Ideal Skills: • Graphic Design • Logo Design • Brand Design • Minimalistic/Modern Design • Color Theory The successful candidate will have a noted background in creating unique, eye-catching digital logos. An understanding of podcast audience engagement through aesthetics would be ad...
I need a freelancer to help create a digital copy of a paper document. The paper contains simple text and I need to achieve an exact replica, including punctuation. The task involves: - Typing the paper content into Microsoft Word verbatim - Ensuring precision in replicating punctuation and all textual aspects - Checking and ensuring no typing errors for high document fidelity Ideally, the freelancer should have excellent typing skills, attention to detail, and prior experience in transcription. Familiarity with Microsoft Word is required.
...in PDF form created by Xactimate- essentially pdfs of data which mimics spreadsheets; examples attached). The primary objective is to develop a system or ability that can accurately identify discrepancies in settlement amounts allocated room by room, as outlined in insurance settlement PDFs, against our own estimates. Typically an insurance company will provide an Xactimate PDF file to us that contains allotted monies for an insurance loss to estimate the cost of the loss. Our role is to produce our own version of that same file, based on our calculations and observations/costs which are typically way more than what the insurance company allows initially. The data tool therefore would analyze these files (broken down by location inside the property), and view, analyze, compare...
I need to extract a list of 500+ stores from an online directory. The structure of the directory is: - A home page with a long list of stores. You can see the name of each store. If you click on a store, you will be taken to that store's page. - Each store has its own page in the directory. This page contains lots of data about the company. This is what needs scraping. Key Deliverables: - Excel or CSV file containing contact data for each store Data required to be extracted (if found on the page): - store name (this is the store's name, separate from company name) - store company name - store website URL - store Facebook page - store telephone number - store email - store Introduction paragraph - google maps link - opening hours IMPORTANT: You must ensure...
I'm in need of a freelancer who can assist me with copy typing text from a PDF document into a word document. - The PDF document contains fewer than 50 pages. - The text needs to be typed accurately and formatted similar to the PDF document. - In addition to the text, the document contains images that need to be included in the Word file, maintaining their original quality and placement. Ideal Skills: - Quick and accurate typing - Proficiency in using PDF and Word processors - Image editing and basic graphic design skills to handle images within the document - Experience in similar projects would be an asset. If this sounds like a task you can handle, I look forward to hearing from you.
...familiarity with app integration with APIs. Excellent understanding of in-app messaging and push notifications is also a must. PLEASE NOTE: I am a flutter developer myself, I am a mediocre designer though, I need a talented "Designer" that gives me a working flutter app, not a figma design for the app. this app contains a single page, it's UI should be stunning to say the least, it should also be animated & interactive. The app will request an api like this -> If it returned 200 pong then The service is working otherwise the service is down. It should allow swipe down to recheck, it should also allow reporting service down errors to admin should the user chose to via sending an email to a predefined email. This feature should only be visible on t...