How to use vlookup function in pivot table jobs

I'm looking for a professional who can install Asterisk PBX to facilitate a call routing system. Key Requirements: - Asterisk PBX will function primarily as a call router, modifying incoming caller ID's to the outgoing trunk DIDs. - The system should handle both incoming and outgoing calls efficiently. - The endpoint devices that will connect to the Asterisk PBX are Mobile Operator issued SIP trunks. Ideal Skills and Experience: - Prior experience in setting up and configuring Asterisk PBX systems is essential. - Proficiency in handling and routing calls effectively. - Knowledge of SIP trunks and mobile operators' systems would be a plus. Specific Requirements Requirement: A simple Asterisk PBX installed on our server. It is a voi...

I'm looking to get a hold of all data from a specific JSON URL. Upon retrieval, I want this data presented in a styled list rather than a conventional table or chart. The key element for this project is to have a unique layout arrangement for each data entry on the list. Ideal candidates should: - Have vast experience in working with JSON and data extraction. - Be proficient in HTML/CSS for custom styling. - Show a keen eye for design to curate the desired layout arrangement.

I am seeking a talented researcher to gather, download, and compile the proxies for the Fortune 200 companies from the years 2021, 2022, and 2023. Specific Requirements: - The proxies need to be in PDF format. - For each year, apart from the proxies, a list of company directors and a list of executives from the executive compensation table are needed. - The lists should include each individual's name and their corresponding position (for board members this would be their position on the board, e,g. independent director or governance committee member). - Additionally, each board member and executive's biography should be included as well. Ideal Skills: - Proven experience in conducting detailed corporate research - Proficiency in...

I need a simple app...entry tool (and basic data analysis) for the employees in our organization. There are a few reference tables like Project, Category, Expense type, etc and then there is a main table called Expenses which has project, category, expense type, quantity, price as the columns. These tables are currently available as part of my azure SQL database but I am open to suggestions if you want to store this data differently. The main screen would show a list of projects on the left. The right section will show details like total expenses, expense per category chart of the selected project. Upon clicking inside the project you will see a list of expenses. This screen should have functionality to add a new expense. There should also be screens ...

I am seeking a seasoned Siemens PLC programmer who is skilled in industrial automation. Key Responsibilities: - Must be proficient in various programming languages including ladder logic, structured text, and function block diagram. - Experience working with different Siemens PLC models, though specific model preference was not indicated. - The project involves tasks related to Industrial automation, so any experience in this field would be highly advantageous. Ideal Skills: - Proficiency in Siemens PLC programming - Prior experience in Industrial Automation - Knowledge and experience in ladder logic, structured text, and function block diagram - Ability to work with a variety of Siemens PLC models.

I need a crypto volume bot developed specifically for the BASE chain. This bot will be focused on executing buy and sell orders...chain. This bot will be focused on executing buy and sell orders and creating holders across different wallets. Key Features: - The primary function of the bot will be to execute buy and sell orders. - The bot should also be able to create holders across different wallets. Ideal Skillset: - Proficiency in BASE chain development. - Experience in developing crypto trading bots. - Familiarity with MetaMask and other relevant wallets. - Understanding of cryptocurrency trading and market dynamics. - Strong problem-solving skills and attention to detail. Please provide details of relevant experience, portfolio, and an est...

I'm in need of a talented illustrator who can create a cartoonish style digital illustration of 2 characters and a background for my crypto website. I will provide reference pictures. Requirements: - Digital illustration: The final output should be in a digital format. - Cartoonish style: I'm particularly interested in a cartoonish style of illustration, as opposed to realistic or abstract. Ideal Skills: - Proficient in digital illustration software - A strong portfolio showcasing similar cartoonish art - Creative and able to bring unique ideas to the table This project would be ideal for an illustrator with a knack for creating engaging, fun, and creative cartoon illustrations.

In order to launch my own digital asset, I'm seeking an experienced Blockchain developer proficient in Binance Smart Chain (BSC). Task Requirements: - Develop a standalone token on the BSC platform. - Implement a function that releases unsold tokens on PancakeSwap. Ideal Candidate: - Understanding of cryptocurrency and digital assets. - Experience in creating tokens on BSC. - Familiarity with PancakeSwap and token release. Looking forward to joining forces with a knowledgeable professional in this field.

...with the bidding system in the Gravity Flow WordPress plugin on my website. Specifically, problems surface regarding: - Bids not displaying - Incorrect assignment of bids - Inability to approve or reject bids I have 1 request form that the customer fills out and successfully assigns a form submission to a ROLE vendor group. The role group is successfully notified, and can place a bid on the project as requested. Once the bid is submitted, it is SUPPOSED to assign the bid for approval/rejection to the original customer. I need help with this component. The Bid is not assigning correctly, and the customer cannot approve/reject I am currently using the latest version of the Gravity Flow WordPress plugin and there have been no modifications or cu...

...experience to enhance the functionality of the Node by Email module. The specific improvements required are: Original Function - collect emails from a specific sender email account and post them as Article nodes authored by the specific sender user account. Modified Function - collect emails from ALL senders and post them as Article nodes authored by the sender user account. If an email sender email address is not associated with an existing user account, then create a user account with the user name and email address set to the sender email address. The password should be set to a random number. The account create date will be the current date. If you have any question about the work please let me know before you start. The ideal candidate for...

...and read all bids and bidders. Don't waste my time with a fake bid to get me to message you (I will ignore your bid). This is a seed project with the potential of an ongoing projects. I have questions within the description to make sure it is fully read. Please answer them in your bid. This is a bid. Don't ask what is your budget? The freelancer will provide knowledge and support to create an online post-secondary institute website. The website is scalable and easily deployable. Choose the best domain registrar with the best hosting package, if the domain registrar and host offers website development and designs...or if registrars/host offer integration with LMS or SIS (I would use an open source LMS or SIS with the ability to ...

I'm in need of an expert opinion letter for an EB2 NIW petition. The letter is to be addressed to an individual and should focus on the following: - **Purpose**: The primary function of the letter is to support an EB2 NIW (National Interest Waiver) petition. - **Content**: The letter should be comprehensive, well-researched, and expertly written with a focus on the specific requirements for the EB2 NIW application. - **Relevance**: The content of the letter should be directly related to the applicant's field of expertise and serve to demonstrate their significant contributions to the field. Ideal skills and experience for this project include: - **Legal Writing**: A solid understanding of the legal requirements for an EB2...

I'm in need of a skilled developer to create a user-friendly e-commerce app for Android. The primary function of the app will be E-commerce, specifically, I want to implement a secure payment gateway. Key Features: - Implementation of a secure and user-friendly payment gateway is crucial. Ideal skills and experience: - Experience in Android app development is a must. - Previous experience in e-commerce app development. - Knowledge of implementing secure payment gateways. - Experience with UI/UX design for an engaging and user-friendly app. If you're confident in your ability to deliver a high-quality app that meets these requirements, I'd love to hear from you.

I'm in need of a PostgreSQL script that will loop through my table and update certain columns of the rows that meet a specific static condition. The main functionalities of this script include: - Iterating through all the rows of a given table. - Checking each row to see if it meets a certain static condition. - If the condition is met, updating certain columns within that row. This script should be designed to handle the following requirements: - The script will be used to filter and update specific rows based on a static condition. This condition will remain unchanged. - The script needs to efficiently loop through the entire table and update only the rows that meet the specified condition. Ideal skills and experience for th...

I'm in need of a compelling, professional animated video to serve as an explainer. This video should have a How-to guide format, providing clear, concise and engaging directions on a particular topic. Key Details: - Purpose: The video will primarily serve as an explainer for a specific process or concept. - Message: The focus should be on delivering a step-by-step guide for the target audience to follow. - Audience: The video is designed for professionals, so the tone and content should be suited to this demographic. Your Skills: - Prior experience in creating explanatory animated videos is required. - A deep understanding of how-to guide formats and the ability to deliver complex information in a cl...

...developer to build a minimalist job candidate application platform. Despite its simplicity, it needs to be versatile and user-friendly. This platform will primarily focus on job search functionality, so a keen understanding of efficient and effective search structures is important. Key Project Components: - Develop a platform using React, Redux, Tailwindcss, Material UI. - Incorporate a search job function. The client has not specified any particular filters, so the focus should be on generic job search filters like keyword, job title, company, etc. - Include a minimalist design focusing on user experience and ease of navigation. - The platform should have only job search functionality, and it is not required to have "apply to jobs" functio...

I'm in need of an experienced developer to create a chatbot for a business, to be implemented on a website. The primary functions I need the bot to handle include appointment scheduling, providing detailed information on services, and answering frequently asked questions. Key Requirements: - The chatbot should be designed to specifically function on a website interface. Experience with Voiceflow or similar chatbot development tools is a must. - The bot is expected to collect and store user data in a Googlesheet at this point in time. - It should be able to handle appointment scheduling, providing information on services, and responding effectively to common queries. - The bot should be able to collect...

...experienced Shopify developer to create a brand new Shopify website for my business. The main purpose of this website is to function as an online store, selling physical products. Job Roles: - Plan, design and develop a user-friendly and responsive Shopify website. - Establishing payment and shipping integrations. - Conforming to SEO best practices for product listings. - Implementing a visually appealing layout that complements our brand. Ideal Skills: - Proven experience in Shopify development and design is a must. - Comprehensive understanding of Shopify's system, including the addition of physical products. - Proficiency in setting up payment and shipping systems. - Experience with SEO strategy development and execution. - An eye f...

I'm on the hunt for a talented web designer to help me build an artistic and unique single-page website for my company. and catalog as well - Functionality: The website should be embedded with smooth scrolling functionality for easy navigation. - Purpose: The website's primary purpose is to provide information about the company and Products - Ability to implement smooth scrolling and tab navigation features. - Creative flair and attention to detail to ensure the website reflects the essence of my company. - Design: I prefer a design that is artistic and unique, not your average corporate webpage. - Additional Features: The website should have in-site search function and fully integrate with our company's social media pages. - ...

I am searc...searching for an experienced web developer to build an online platform for Hindu pujas. The main function of this platform is to allow users to book individual pujas in advance. Although live streaming functionality is not needed, the platform should be designed with user engagement and interactivity in mind. Key Requirements: • Development of an advance booking system • User-friendly interface • Secure payment integration Ideal Skills and Experience: • Proven experience in web development • Familiarity with advance booking systems • Previous work on religious or cultural platforms is a plus. Please elaborate on your relevant experience and suggest possible strategies for platform development...

I am in need of an experienced fashion designer who can help us create a line of women's traditional clothing including Sharara set, Kurti and Lehenga. Our primary target group is women between 18-25 years. Key requirements: - Minimum 1-year experience in fashion designing - Proficiency in creating traditional women's clothing like Sharara set, Kurti, and Lehenga - Ability to understand and design for the tastes and preferences of women aged 18-25 Ideal freelancer applications should include: - Previous works in traditional women's clothing - Detailed project proposals including your approach and design methodology for this project Please note that we are looking for a designer who can bring fresh and innovative designs to the ...

A program in Racket/Scheme that implements a parser in its code, controlled by an LL1 grammar of at least 5 rules and performing, for example, validation/translation of some text input. The output of the program will be e.g. input value recognition, translated text or error detection. See an "example 1" . You can use functions fot this example, but the grammar must be you own. Using of recursive descent parser is recomended - see "example 2". General rules: Note that calling a ready-made function from the library is not sufficient to accomplish this task. Your own code must contain a visible algorithm. Your program must work according to the documentation. All documentation must be written in the source code . The p...

...for a data processing function isn't working as expected, but I'm uncertain as to what's causing the problem. Skills and Requirements: 1. Expertise in Java: The job requires a proficient understanding of Java programming to understand and diagnose the existing code. 2. Experience in troubleshooting and debugging: As I am unsure of what's causing the problem, the freelancer needs to be competent in identifying and rectifying coding errors. 3. Understanding of Data Processing Applications: As the main issue with the code lies in its data processing function, an understanding of this will be beneficial in diagnosing and remedying the situation. Your job will be to inspect the Java code, i...

I am seeking a seasoned digital marketer with a proven track record to help me achieve my marketing goals. The specifics of my project are as follows: - The ideal candidate should be well-versed in all major digital marketing platforms, including but not limited to Facebook, Instagram, and Google Ads. - I am open to both short-term and long-term strategies, so the applicant must have experience in implementing both. - The primary objectives of this campaign will include enhancing brand awareness, driving more traffic to my website, and increasing lead generation. The selected freelancer will be expected to bring their expertise to the table, and work closely with me to outline a tailored digital marketing strategy that...

I'm looking for a skilled AI developer to create a content generation app that will primarily analyze images. Key Requirements: - Platform: The app needs to be developed for the web. - AI Function: The primary function of the app is to generate content. - Data Analysis: The app will analyze the pictures I provide for content creation. Ideal Candidate: - Proficient in AI development and content generation. - Experience in designing and deploying web applications. - Familiarity with image processing and analysis. - Strong problem-solving and communication skills. Please share your relevant experience and project samples.

I'm launching a supply chain start up and require a web app specifically designed for inventory management. The chosen freelancer should have extensive experience in the following: - Crafting web apps targeting supply chain management. - Designing a user-friendly interface, specifically a table view with detailed entries. - Integrating key details on the inventory table view, initially, the product name will be included. The prime objective is to achieve an effective inventory management mechanism through this web app. If you've had previous experience in this specific field and understand the ins and outs of inventory management in a supply chain context, your skills will be highly valued.

I'm launching a supply chain start up and require a web app specifically designed for inventory management. The chosen freelancer should have extensive experience in the following: - Crafting web apps targeting supply chain management. - Designing a user-friendly interface, specifically a table view with detailed entries. - Integrating key details on the inventory table view, initially, the product name will be included. The prime objective is to achieve an effective inventory management mechanism through this web app. If you've had previous experience in this specific field and understand the ins and outs of inventory management in a supply chain context, your skills will be highly valued.

I'm urgently looking for a seasoned VB.NET developer who can add new functions to my software application. At this stage, I'm not specific about the functions I want to integrate, I need someone who can provide professional insight based on their experience. The ideal candidate will have: - Extensive experience in creating new software applications - Mastery in debugging and fixing existing VB.NET code - Outstanding ability in enhancing and optimizing performance of software applications While there's an urgency to this project, I need a developer who will not compromise on the quality and efficiency of the work. I look forward to working with you.

...entry skills to assist in transferring text data from digital documents into an excel sheet. The successful candidate should possess: - Reliable accuracy in typing - Fast typing speed (numeric keypad advantageous) - Proficiency in Excel (VLOOKUP, SUMIFS, Pivot Tables, etc.) - Able to interpret written information swiftly - Excellent attention to detail for proofreading entered data. This task will require someone with experience in handling large volumes of data entry, with absolute prioritization on maintaining the integrity and accuracy of the inputted data. Any previous involvement in similar projects handling text data is highly desirable. Understanding of and/or a background in just managing digital d...

...application db in azure db I am looking for a developer for backend operations and experience in MSSQL, WordPress wooCommerce and API integrations. The primary task deduct stock in azure ms sql stock table when order placed in wordpress woocommerce display item list in woocommerce based on mssql stock table create comand to generate order in inventory system when order placed in wordpress woocommerce Key Skills Required: - Strong experience with MSSQL, WordPress woocommerce, API - Expertise in inventory management system e-commerce integrations who have done same work earlier plesae bid I will share explaining video, if you are able to do than you need to work on remote zoom or ultraviewe...

I am in need of a proficient software developer who can build a desktop application for e-commerce and transactions. The expected software will run on Windows. The primary function of the application will be to facilitate online sales, process payments, and manage transactions. Ideal Skills and Experience Required: - Desktop application development expertise - Extensive knowledge in Windows application creation - Proven experience with e-commerce and transaction application development - Familiarity with common payment gateway integration - Strong understanding of data security and encryption for transaction safety. I anticipate a software that is seamless, user-friendly, and secure for conducting business. Please, only bid if you meet these requirements and...

...Description: We are experiencing significant delays with a MongoDB aggregation pipeline in our application. The specific controller takes about 36 seconds to complete when a user has a large amount of chat data in the database. We need a MongoDB expert to review and optimize the aggregation pipeline for improved performance. Details: Our application is built using Node.js with Mongoose as the ODM for MongoDB. The current issue arises when retrieving a user's chat list. The aggregation pipeline fetches chat messages for a given user, including related user information and performs various operations like sorting, grouping, and filtering based on certain criteria. Current Function: Here’s the function that handles the retrieval of ...

...Rise 360 professional to rectify a flaw within the navigation function of a small e-learning project. The issue presents itself with the multiple-choice block, which currently only permits a single correct response. Ideal Skills and Experience: - Proficient in Articulate Rise 360 - Background in e-learning module design - Superior problem-solving skills - Attention to detail to ensure navigation functionality Your task is rather straightforward but vital: - Modify the multiple-choice feature to allow more than one correct answer - Keep the overall integrity of the project intact - Ensure the fix doesn't induce any other issues in the file This is a relatively small job, but successful execution might lead to mo...

I need an experienced Node.js developer to create an automation script for my server deployment. - Automation Task: The script should automate routine server deployments, keeping my operations efficient and consistent. - Server Deployment Activities: The core function of the automation is to handle financial transactions, particularly trading activities. Proficiency in financial systems and trading platforms is necessary. - Financial Transactions: The successful candidate should also have experience with the handling of financial transactions within Node.js applications. The ideal candidate should have brilliant knowledge with Node.js, experience in automating server deployments, and a strong understanding of financial trading systems. Looking to...

Presentation Format 1. Critically evaluate the position of an organisation in its current market. 2. Critically analyse the effects of existing plans on an organisation. 3. Critically explore the relationship between, corporate, business and operational strategies. 4. Apply strategic models and tools to develop strategic options for an organisation. 5. Evaluate strategic options for an organisation. 6. Present a SWOT table (or equivalent) and critically evaluate the organisations current strategic position With Presentation speaker notes Word document Format Report 1. Critically evaluate the relationship between the organisation’s, corporate, business and operational strategies. 2. Apply strategic models and tools to recommend strategic options fo...

I'm looking for a developer to create a unique, custom-built website geared for a cryptocurrency presale. This site will be the primary source for information about the token and presale, so it needs to be user-friendly and intuitive. Key areas of focus will be: * Custom-built platform: I'm not interested in using WordPress or Shopify. My preference is a website custom-built from scratch. * No live chat feature: I don't need a live chat function implemented within the site. * Branding and color scheme: I have my branding guidelines and color scheme that will need to be adhered to during the website build. Ideal experience for the freelancer would be past work with cryptocurrency websites, professional understanding of the crypto la...

i need to replicate the following data by looking for info on WB or IMF websites, i need to first identify how to calculate the Cyclically adjusted (CAB) part, can someone help? the end product is that i have to present similar table (see attached), i need to give clear explanations as to where my data came from, how the adjustements are made the task i received: "One bank presented a chart below and claim that " DM fiscal policy is set to tighten markedly this year ” Can you please check IMF and world bank websites, or other sites, to see if you could replicate the data below. "

AVEVA is a global leader in industrial software. Our cutting-edge solutions are used by thousands of enterprises to deliver the essentials of life – such as energy, infrastructure, chemicals and minerals – safely, efficiently and more sustainably. We’re the first software business in the world to have our sustainability targets validated by the SBTi, and we’ve been recognized for the transparency and ambition of our commitment to diversity, equity, and inclusion. We’ve also recently been named as one of the world’s most innovative companies. If you’re a curious and collaborative person who wants to make a big impact through technology, then we want to hear from you! Find out more at Location: Lake...

...3-5 years old preschoolers. The main educational approach should pivot around musical instruments, precisely piano. Key Responsibilities: * Introduction and constructive teaching of the piano to preschoolers. * Creation of a fun, creative environment that supports play-based learning. * Foster social-emotional development through musical education. Skills & Experience Required: * Previous experience teaching piano to children. * Great versatility to translate music into a playful learning approach. * Background or strong understanding of child development, especially for preschool-aged children. * Past experience in nursery or music education is preferred. In summary, if you love music, teaching, and feel delighted to exploit t...

...professional to provide a detailed and appealing visualization of a modern-inspired living and combined kitchen in a small room Specific Requirements: - Include a 2 seater sofa , coffee table, and dining table and 2 chairs desk and office chair similar to the photos provided and a refrigerator in the space provided in the plan. The wall colour is white. Some artwork on a wall if possible Wall mounted tv 50 inch on wall between bathroom and desk area - Provide high-quality and realistic render. Ideal Candidate: - Exceptional 3D rendering skills. - Proven experience in designing modern interior spaces. - Excellent attention to detail. - Ability to work according to given specifications and meet deadlines. ...

I'm looking for an experienced home textile designer to create a woven pattern for a few of my home textile products - tablecloth, placemat, napkin, table runner, and cushion. Ideal Skills: - Strong expertise in textile design, preferably home textiles - Ability to interpret a woven theme into unique, creative designs - Strong knowledge of different types of fabric, especially how they apply to home textiles - Proficiency in using software such as Adobe Illustrator for pattern creation Responsibilities: - Design patterns for tablecloth, placemat, napkin, table runner, and cushion - Deliver designs in a print-ready format - Willingness to accept feedback and make required changes Any previous exper...

As part of my project, I'm searching for an adept mobile app developer who can build a social network app available for both iOS and Android. Key Requirements: - The pivot of the app is to enable social networking capabilities. - A crucial feature of the project involves designing and implementing robust User Profiles. Ideal Candidate: - You are proficient in both iOS and Android app development. - You have previous experience in creating engaging social networking platforms. - You're highly skilled at implementing user profile features, with a keen focus on UI and UX design. I look forward to your innovative ideas and potential collaborations on this exciting project.

...editor to help me create engaging and compelling social media videos. Key Requirements: - Must have prior experience in video editing, specifically for social media. - The selected candidate will be responsible for editing a short advertisement video for a weight loss supplement. The video should be less than a minute in duration and should be captivating, visually appealing, and able to convey the product's benefits effectively. - The editing style should be modern, creative, and conducive to social media platforms. - While the style of editing is not specified, a vibrant and energetic approach would be preferred given the nature of the product. Ideal Skills: - Proficiency in video editing software. - Strong understanding of social medi...

I'm in need of a skilled mobile app developer who can create a media content mobile app that will function on both iOS and Android platforms. The goal is designing, developing and publishing a simple mobile App to show contents, like images, videos, text and Youtube links. Key Requirements: - The app should support iOS and Android: Please ensure the app is smoothly functional on both platforms. - Responsive design for media contents (texts, images, videos, pdf documents and youtube links). - A searchable feature to look up for content by entering some text and filters. - Publication of the app on Apple Store and Google Play. The main objective of the app is to provide a platform for the distribution of media content. It should be able to han...

I'm in need of a freelancer who can turn a scanned PDF into a Word document for me, maintaining the layout and images. Additionally, I require the addition of a table of contents to the Word document. Ideal Skills: - Proficiency in typing and data entry - Experience or knowledge in OCR software - Understanding of Microsoft Word and its features for document formatting - A keen eye for detail and accuracy in text and layout conversion - Ability to create a table of contents in Word This project requires a high level of accuracy as the Word document should be an exact replica of the scanned PDF. The final Word document should be fully editable and of high quality.

I'm seeking an experienced PowerApps developer to assist in creating a system for daily information management. - Data Formatting: The information will consist mainly of text fields, numeric data, images or multimedia, and a predefined set of choices. - User Interface: The system should offer a user-friendly interface for data entry and management. - Data Storage: The daily information should be saved to a centralized excel or table, allowing all authorized users to access the data at any time. The ideal candidate for this project would have prior experience in PowerApps development, particularly in creating systems for data management and user input. Experience with integrating PowerApps with Excel or other databases would be highly ...

The Full Stack task using Angular and .NET using Ag grid to add, edit, remove and view the table. Also to have read only table without any edits

I'm looking for a creative designer to help me create an engaging A5 flyer that will promote a specific product or service for my small business. Key Requirements: - A5 Size: The flyer should be designed to fit an A5 (148 x 210 mm) format. - Promotional Focus: The primary goal of this flyer is to promote a specific product or service. The design should be tailored to this purpose and be highly engaging. - Creative Freedom: I don't have specific colors or a color scheme in mind, so I'm open to suggestions. Please bring your creativity to the table and help me create something visually appealing. Ideal Skills: - Graphic Design: An eye for design and the ability to create visually appealing marketing material is c...

I have a PDF file that needs to be converted into a Word document while preserving its original formatting. The primary aim of this project is to have the Word document looking as close as possible to the original PDF. Key requirements: - Converting a PDF document to a Word document - Maintaining the existing formatting - Paying particular attention to replicating tables correctly Ideal skills for this job include: - Proficiency in Microsoft Word - Experience in handling PDF to Word conversions - Strong attention to detail, especially when it comes to formatting and layout replication - Familiarity with table formatting in Word If you have a good eye for detail and can ensure that the Word document clos...