Vlookup approximate match formula in power query jobber
Skal bruge et logo til vores nye brand Poweredbynature. Det skal indebære health og power. Poweredbynature kommer til at forhandle alle former for nutrition supplements. Det skal være enkelt og stilet med det blad i front eller i bag.
Hello, we are looking for someone who can control levels for a popular word game for mobiles. The game is available in many different countries and will now be launched in Netherlands. Good knowledge of the dutch language is a requirement! The job is to check the translation and in some cases replace words that do not match the level. There are 3500 levels to be checked and each level has three words with a maximum of 10 letters. When well done, the current content writing and region responsibilities be possible. More info on contact.
Hello, we are looking for someone who can control levels for a popular word game for mobiles. The game is available in many different countries and will now be launched in Germany. Good knowledge of the german language is a requirement! The job is to check the translation and in some cases replace words that do not match the level. There are 3500 levels to be checked and each level has three words with a maximum of 10 letters. When well done, the current content writing and region responsibilities be possible. More info on contact.
I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?
I am in need of a talented individual(s) who can create a highly realistic 3D animation with an educational theme for children. This requires a deep understanding of how to make complex concepts simple and digestible for a young audience. Essential skills and experiences include: - Proven experience in creating realistic 3D animations - Ability to translate educational content into engaging storylines - Proven track record in children's content development, especially in the educational area The right freelancer(s) for this project should display exceptional creativity, have a standout portfolio in 3D animation, and value the power of education. Most importantly, you must know how to captivate and hold children's attention through anim...
...project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that converts their answer (in one cell) to a score (in an adjacent, hidden, cell). The sec...
I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...
I'm in urgent need of a WordPress expert to optimize my website's mobile version. The desktop version is running at 95% speed, but the mobile version is significantly slower, scoring only 66%. I need the mobile version to be optimized to match the desktop speed ASAP. We already use the paid plugin WP Rocket. Key Requirements: - Improve mobile page speed significantly to match the desktop version. - Prioritize optimization of images, heavy themes or plugins, and unoptimized JavaScript and CSS. - Ensure the mobile version is fully functional post-optimization. Ideal Skillset and Experience: - Proficiency in WordPress and understanding of mobile optimization techniques. - Strong experience in optimizing images, videos, themes, plugins, and JavaSc...
...update a directory of funding opportunities. User Authentication and Profile Setup: Developing secure login/logout capabilities and user profile management. AI Chatbot Development: Integrating OpenAI’s ChatGPT API to create an interactive chatbot that conducts a business background quiz and uses responses to tailor funding recommendations. Opportunity Matching System: Implementing algorithms to match users with funding opportunities based on quiz results and profile data. Subscription and Payment Processing: Integrating Stripe for handling subscriptions and payments, including setting up different access levels and monitoring usage. Testing and Quality Assurance: Ensuring all features operate seamlessly and meet user expectations. Documentation and User Support: Creat...
Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.
I am looking for skilled ...performance issues and loads quite slow. There for we have decided to switch from OpenCart to Bagisto store. Responsibilities: - The template needs to match our existing site at least at around 90% ! - No perfection issues at our side - Accepting improvement ideas - There is no need to made it ready for Bagisto, our need is only the CSS and base HTML with dummy content. - Duplicate an existing website to stand alone TailwindCSS template. - Ensure the template is Responsive as our main target is mobiles but desktop as well. - Implement few dummy pages: Homepage, Category, Product, Search, Login / Account. Required Skills and Experience: - Expertise in TailwindCSS, HTML, JavaScript - Experience with website templates - Ability to work efficiently a...
...will be fully involved in the development and updates of the frontend portion of this dynamic project. The basic frontend has already been developed by one developer. Frontend update is required. Here are ten of the most famous singers of all time, known for their vocal prowess and significant influence in the music industry: 1. *Aretha Franklin* - Known as the "Queen of Soul," she is celebrated for her powerful voice and hits like "Respect" and "I Say a Little Prayer." 2. *Elvis Presley* - Often referred to as the "King of Rock and Roll," his charismatic performances and hits like "Heartbreak Hotel" and "Jailhouse Rock" transformed music. 3. *Whitney Houston* - Renowned for her incredible vocal range and emo...
I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS
I'm currently in need of guidance to understand how to navigate through complex office dynamics at the executive level. You will be my mentor to aid in managing conflicts and disputes. Additionally, your help in building strategic relationships and enhancing my networking capabilities will be essential. Here's a brief on what I need help with: - Deciphering office dynamics: As a mentor, provide insights on understanding and manoeuvring around the changing power dynamics in the office. - Managing Conflicts and Disputes: I'm struggling with power struggles at the executive/leadership level. Your expertise in this matter will help resolve the situation effectively. - Building influential relationships: Teach me how to build ...
Information Gathering on Vehicle Charging Methods <Request Details> Please gather product information on vehicles equipped with the technology described in the “2. Desired Technology” section below. *Note Do not collect information based solely on the information listed in the “1. Background” and “3. Reference Information” sections (Sections 1 and 3 are for reference only) 【1. Background】 This is a technology related to charging the on-board storage device with power supplied from an external vehicle charging facility. In recent years, the development of electric vehicles capable of “plug-in charging” using a charging cable for power supply has been progressing, and there is a problem of heat ...
I'm looking for a Power BI expert to help me customize a power BI Report to support conditional email subscriptions. Your main task will be to set up email subscriptions that trigger when the data within the report is changed. This will involve establishing appropriate conditions and ensuring the subscription system is reliable and responsive.
I'm looking for an illustrator to create an image that will complement our existing logo. The primary use of this illustration will be for social media posts with the goal of enhancing our brand awareness. The ideal candidate should be able to: - Create a minimalistic illustration style. - Match the color scheme with our existing logo.
I am in need of an experienced professional who can help with an enhancement to our powerflow analysis utilizing Power Factory software. This project is primarily focused on conducting a comprehensive powerflow analysis to improve the efficiency and reliability of our power systems. Key Responsibilities: - Conduct a powerflow analysis using Power Factory software - Implement enhancements to improve overall power system efficiency - Ensure compliance with regulatory standards and best practices - Provide a detailed report on the analysis and suggested improvements Ideal Skills and Experience: - Proficiency in Power Factory software - Strong background in power systems analysis - Familiarity with power losses, voltage s...
I'm looking for a master plumber to provide comprehensive plumbing services for the finish out of a restaurant commercial space. I need pipe repair, drain cleaning, and water heater installation expertise. I also need someone who can assist with: - Kitchen plumbing setup - Seating area plumbing (if required) - Restroom facilities plumbing To understand the proj...installation expertise. I also need someone who can assist with: - Kitchen plumbing setup - Seating area plumbing (if required) - Restroom facilities plumbing To understand the project specifics, you'll need to request plans and discuss details with me. I expect a skilled, experienced commercial plumber who is familiar with the unique requirements of restaurant plumbing. Please bid if you can match...
...sophisticated. Key requirements include: - A full site graphics design. - In-depth understanding of how to design in a way that's consistent with the elegant and sophisticated theme and historical nature of the content, it is from World War 2 Era World History and Jewish and Christian Religious Themes - Experience with creating custom graphic elements for websites, not just relying on templates. - A good eye for typography, as it's a crucial aspect of the design. - Familiarity with WordPress is a plus, as the designs will be implemented on a WordPress site. The website in question is tenboomthemusical.com. So, the graphics need to not only match the theme but also fit well with the existing content of the site. If you're confident in...
I am in need of an experienced professional who can help with an enhancement to our powerflow analysis utilizing Power Factory software. This project is primarily focused on conducting a comprehensive powerflow analysis to improve the efficiency and reliability of our power systems. Key Responsibilities: - Conduct a powerflow analysis using Power Factory software - Implement enhancements to improve overall power system efficiency - Ensure compliance with regulatory standards and best practices - Provide a detailed report on the analysis and suggested improvements Ideal Skills and Experience: - Proficiency in Power Factory software - Strong background in power systems analysis - Familiarity with power losses, voltage s...
For this project, I have a single digital photo of 18MP resolution (RAW) that requires a specific edit. I need a skilled photo editor to professionally extend the right side of the photo, or "stitch", without compromising the overall quality and feel of the original image. Skills and Experience Required: - Proficiency in photo editing software, especially with photo merging and stitching techniques. - A sharp eye for detail to blend and match the original image for a seamless extension. - Experience with handling RAW images. - Ensure final output maintains its high resolution quality.
I need a custom custom GPT model in OpenAI called "GPT-Invoices". The objective of this project is to enable the GPT model to analyze invoices stored in a OneDrive folder and answer various queries related to these invoices. Once this functionality is implemented, I want to integrate it with Excel to call the GPT model directly from Excel cells and receive responses in the same cells. Project Requirements: GPT-Invoices Setup: The custom GPT "GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all su...
...applications using Power Automate and Power BI. These applications will serve both internal employees and external clients. Key Responsibilities: - Automating complex business processes: I need someone who can create a system that can handle high complexity with advanced data processing and integrations. - Data Analysis and Visualization: You'll be required to develop analytical tools that can process and visualize data effectively. - Custom Form Development: I need custom forms to be built for various purposes within the applications. Ideal Skills and Experience: - Proficiency in Power Automate and Power BI: You need to be well-versed in both these tools to be able to create powerful low-code applications. - Proven track record in...
I am in need of a talented designer to give my Canva brochure a professional upgrade. It should stand out as fun, readable, and professional and should appeal to the general public. Its 45 pages long (43 plus the front and back) and is a guide/brochure for buying in a particular area of Spain. Its in English as its for UK and US readers primarily. Right now, I have all the word content in there. However, when trying to improve how it looks, I realise I have zero creativity in that department I'm not looking for anything too spectacular, but must be something that doesnt look like a 10 year old made! Ideal skills and experience: - Proven expertise in professional design and familiarity with Canva - Strong understanding of colors, fonts, a...
...Message: The logo should predominantly convey a feeling of relaxation and well-being, ensuring that our clients feel at ease and peaceful when they see it. Design Preferences: - A combination of both text and symbols in the logo is preferred. The text should be clear and easy to read, while the symbol should be designed to match the soothing theme. - The color palette is open for your creative input. While I've not selected specific colors, I'd like the colors you choose to reflect the feelings of relaxation and well-being. Ideal skills and experience: - Proven experience in logo design, specifically for wellness, spa, or similar industries. - Strong understanding of color psychology, particularly as it relates to feelings of relaxation and well-being. ...
Elevate your business with our Website Builder Package. We offer a customized 10-page website, including Home, About Us, and Contact Form, plus seven additional pages of your choice. Benefit from 3 hours of personalized 1-on-1 training to manage your site effectively. Key Features Professional Design: Choose from stunning templates, customized to match your brand. Contact Form Integration: Seamless communication with your audience. 3 Hours of Training: Learn to update content and manage your site confidently. Mobile Optimization: Ensure a smooth experience across all devices. SEO Best Practices: Boost online visibility with basic SEO strategies. Domain Connection: Link your existing domain for a branded online presence. How It Works Consultation: Understand your business goals and...
...Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas across different spreadsheet p...
I'm looking for a skilled developer to update the controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then wil...
I'm currently in need of a skilled individual proficient in Elementor and JetEngine to assist in finalizing the configuration of dynamic content imported from another site. The content, which includes Artists, Styles, and Portfolio Items, has been imported successfully (as a Crocoblock/JetEngine "skin" as well as Elementor archive and single templates), but requires further configuration to ensure it functions optimally on my website and fits the visual aesthetic. Key Tasks: - Configuring Custom Post Types (CPTs): The project involves working on Artists, Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships between CPTs & Building...
I'm looking for a professional who can guide me on filming a meeting with 3 iPhones and wireless lavalier mics. The goal is to have the video and audio well-synchronized for post-production editing. Key Responsibilities: - ...Set up 3 iPhones for optimal video quality - Configure wireless lavalier mics for clear audio - Advise on real-time synchronizing of video and audio Ideal Skills and Experience: - Extensive experience with video production - Proficiency in using iPhones for filming - Knowledge of wireless lavalier mic setup - Understanding of real-time video and audio synchronization Meeting Length: Less than 1 hour Environment: Indoors with controlled lighting I need assistance in all aspects of this setup, including ensuring that the video and audio match...
I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL formation, and more. The primary purpose of the proje...- Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex query formation - Familiarity with streamlining and enhancing data storage - Experience in supporting monthly data integrations Your insights and guidance in this project ar...
I'm searching for a competent Power App Developer to develop a specific app for a client > with the opportunity for regular work. Im not looking for 'complexity' but efficiency of solution creation and ability to understand clients data and work flows
I'm currently in need of a skilled individual proficient in Elementor and JetEngine to assist in finalizing the configuration of dynamic content imported from another site. The content, which includes Artists, Styles, and Portfolio Items, has been imported successfully (as a Crocoblock/JetEngine "skin" as well as Elementor archive and single templates), but requires further configuration to ensure it functions optimally on my website and fits the visual aesthetic. Key Tasks: - Configuring Custom Post Types (CPTs): The project involves working on Artists, Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships between CPTs & Building...
I require an experienced industrial designer to construct a high-capacity, 1-liter water bottle. This innovative product design project involves integrating a power bank into a functional water bottle, harmonizing hydration and tech convenience. Key Features and Requirements: - A 1-liter water bottle with a built-in power bank - Built-in power bank should have a charging capacity of 20000mAh - The water bottle can be made of stainless steel or BPA-free plastic Ideal skills and experience: - Industrial design - Experience in designing similar products - Familiarity with working with stainless steel and BPA-free plastic - Understanding of the safety standards for the integration of electronics with drinking vessels. This project blends quintesse...
...organize stock data from my trading view strategy. The person must have experienced in strategy test option in tradingview. No pragramming language required, just manually check. Note that my strategy name is BRAMMA 1. Objective - Find every stocks in US exchange (Nasdaq and NYSE) that meet the BRAMMA strategy conditions Steps to do before everything. - Please gather all the names of US stocks market in both exchange (Nasdaq and Nyse), then please manually check every stock that meet condition and extract them to excel file. - Please select the trigger that match with the tradingview ticker -Please find list of company in Nasdaq exchange here: - Please find list in NYSE exchange here: - Total share number are: 3381
I'm looking for an experienced designer to create vectored logo files from an image, which I will provide to you. The successful freelancer will need to deliver the vectored logo files in AI (Adobe Illustrator) format. Key Requirements: - Create vectored logo files from an image provided - Deliver in AI (Adobe Illustrator) format Please include your past work in your application. Experience in logo design and Adobe Illustrator is a must. Your ability to match the color scheme of the logo to the image provided will be critical.
...Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies. Lead a team of developers in the implementation and maintenance of database systems. Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs. Optimize database performance through indexing, query optimi...
...outcome should be a PNG format. I need the digital image to be editable, not just as a whole but also for individual elements like text. The license plate's color scheme should remain as it is in the original image. Ideal skills for this job include: - Proficiency in graphic design, especially in image conversion - Experience in creating editable digital images - Attention to detail to correctly match the colors from the original I'm looking for a freelancer who can deliver a high-quality, accurate, and editable reproduction of the license plate. Please include examples of similar projects you've worked on in your proposal. License plate will look like the image I have attached. I want the text "Flight for Life" cha...
I'm seeking a logo designer to craft a captivating symbol that represents brand recognition. This logo should encapsulate our core values: trust, reliability, stoicism, power, sisu, professionalism and quality. I have in mind color schemes that either pairs black and gold together or combines blue, gray and white. The ideal freelancer for this job would be experienced in branding and potentially marketing, with a sophisticated understanding of color psychology and simplicity. I'm aiming for a logo that not only distinguishes our brand but also resonates with our audience on a deeper level. Connect with me if you're ready to create a memorable design that conveys trust and quality. The company is a one stop financial marketplace for all business funding ...
...smooth indoor floors; these are the expected terrains where the platforms will be operating and the design should incorporate elements friendly to an indoor setting. - The platforms should be able to function through an electric power source. This means your experience in electrically powered machinery is a necessity. You should ideally possess a strong foundational knowledge of engineering principles relevant to automated systems, prior experience with automated platforms or robotics would be a definite plus. Your problem-solving skills will come into play in tackling the challenge of creating a gentle and imperceptible motion effect. Remember, the key is a seamless movement that gives a sense of magic. Let's discuss your process and vision for incorpora...
...bring creativity and expertise to every project. ?️ **Web Design:** I specialize in designing websites that are not only visually appealing but also user-friendly and responsive across all devices. From concept to development, I ensure that every website I create reflects the unique identity and goals of my clients. ? **Graphic Design:** My graphic design skills extend to a wide range of mediums, from posters and banners to book and magazine covers. I believe in the power of visual storytelling and strive to create designs that leave a lasting impression. ? **Stand Out with Me:** Whether you need a professional website, attention-grabbing posters, or stunning book covers, I'm here to help your project stand out in the crowd. Let's collaborate to ...
...of dummy data in Laravel. 2. Implement form data transfer from the website to the CRM Enquiry Menu in Laravel. 3. Ensure that won enquiries are correctly displayed after conversion to contacts in Laravel. 4. Highlight the current menu item on the left in Laravel. 5. Correct CSV download functionality in Contacts, ensuring filters, headers, and special characters are handled properly in Laravel. 6. Enable clicking anywhere on the contact data table to open the view of that particular contact in Laravel. 7. Remove the display of the last date from the top of the contact view in Laravel. 8. Adjust calendar functionality to match design specifications in Laravel. 9. Ensure tasks are displayed on the task list page in...
I'm in need of an Arduino expert who is adept at programming a small Arduino circuit to control LEDs, a motor, and sound. It will be integrated into a small, Matchbox/Hot Wheels-sized fire truck. The LEDS will flash alternately to represent the emergency lights. The motor will power the back wheels and the sound will play through a small speaker as a siren and horn. Here are the requirements for the project: I believe the Arduino MKR Zero would be a good fit since it has the integrated micro SD card holder and sound processing capabilities. It also has an integrated battery charger. The Arduino needs to be powered by a rechargeable Lithium Polymer battery like 3.7 Volts. - Control LEDs: I believe I can get by with two white 3mm LEDs. I will install fibre-optics to tr...
I am in need of a skilled 3D animator to produce a one-off piece for a special anniversary gift. The concept is centered around a unique personalized message. You will be tasked to bring it to life using striking and vivid 3D animation techniques. Specifications: - The animation should be in 4K resolution. - Capture the sentiment of a personal message, hence the requirement for custom, bespoke animation. - We do not need a ready-made template or off-the-shelf solution. Ideal Candidate: - Proven experience in creating high-quality 3D animation. - Portfolio of previous work, particularly projects with an emotional, personal touch. - Strong attention to detail. - Open to feedback and willing to make edits when required. - Able to work within a timeframe to deliver t...
I need a Zoho expert to help me set up a system where emails that match certain keywords in the subject are copied to a specific WorkDrive folder. Ideal Skills and Experience: - Proficiency in Zoho Mail - Experience in email filtering - Knowledge of WorkDrive system Please note that I want the emails to be copied, not moved, to the WorkDrive folder. I need both incoming and outgoing emails to follow the same method. I work in an office with 15 others and we get new cases meaning new filters frequently, so I'd like a method to be able to update their filters without needing them to redownload anything, sort of like a central hub from my computer. If there is any way for that to be done, I'd like to know the method.
I need a mathematician to solve a number sequence and provide a formula so I can generate the next iteration of numbers as high as I can go.
I'm in need of a talented developer with experience in using Silvaco TCAD on Windows for an AlGaN/GaN HEMT device. The primary objective is to optimize device performance by refining three key parameters: - Power output - Efficiency - Frequency response Key Responsibilities: - Develop Silvaco TCAD code on Windows. - Simulate AlGaN/GaN HEMT device. - Optimize the device's power output, efficiency, and frequency response. - Provide a detailed report of the simulation results including the changes made in the code and the impact on the parameters. Ideal Candidate: - Proficient in Silvaco TCAD, particularly on Windows. - Strong background in semiconductor device modeling, especially in III-V compound semiconductors. - Experie...
