Vlookup google sheets reference another sheet jobs
I have identified the specific CPP code that needs to be converted to Java. The CPP code interacts with external systems and the Java code should maintain a similar code structure as the CPP code. Key Requirements: - Convert CPP code to Java: You should be experienced in both languages and possess a strong understanding of how to transl...code structures. - Maintain a Similar Code Structure: The Java code should be as close as possible to the original CPP code in terms of its structure. I'm looking for a developer that can efficiently convert the code and ensure that it maintains the same ability to interact with external systems. Ideal Skills: - Proficient in C++ and Java. - Experience in translating code from one language to another. - Knowledge of working with external s...
NERC Holidays Insertion Directions I am creating a excel sheet for electricity pricing research. There are typical days and there are holidays for which the typical load (demand) shape gets distorted. As a preliminary step in this project, I need to identify all of the holidays that occurred from January 1, 2006 until present. The recognized holidays for the US electricity markets are called “NERC holidays,” which is the abbreviation for the North American Electric Reliability Corporation. The six recognized NERC holidays are New Year’s Day Memorial Day (last Monday in May) Independence Day (always July 4) Labor Day (first Monday in September) Thanksgiving Day (the fourth Thursday in November) Christmas Day (always December 25) Please also add three
Please Sign Up or Login to see details.
...understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to Inquirie...
I am in need of an experien...the rankings of my website on Google. The primary goal is to boost our visibility on this popular search engine. Key Responsibilities: - Review and optimize the website content - Implement on-page SEO strategies - Conduct keyword research and analysis - Develop and execute a comprehensive SEO plan Ideal Skills: - Proven experience in SEO, particularly in improving rankings on Google - Proficiency in keyword research tools and techniques - Strong grasp of search engine algorithms and ranking factors - Excellent analytical and problem-solving abilities - Good communication skills to report progress and suggest recommendations. Please only apply if you have a track record of successfully increasing the search engine rankings for websites, partic...
I am in need of a skilled animator to create a 3D promotional animation for my locker product. The target audience for this video is adults, so the animation should be informative and visually appealing to a mature audience. Key requirements and responsibilities include: - Creating a 3D animation styled video - Crafti...the app. The lock changes into green and he can take out his bed again Maybe we have a different light at this time because it’s afternoon or evening He leaves and the door closes automatically because of the self closing hinges. Contest: The video should not be longer than seven seconds, and in the next step we will add all the administrative functions on the video as well. But that is another object Please count with some small changes included aft...
...seeking an adept professional to develop a cross-platform app for real estate. Available on iOS, Android, and Web, the app's functionalities must include: - Property Search: An intuitive, user-friendly interface for users to search properties. - Filter options: Users can filter search results based on different criteria. - Saved favorites: Users can bookmark their preferred properties for future reference. The app should also facilitate user interaction with features allowing: - User registration/login: Smooth user registration and login process. - Agent registration/login: Smooth Agent registration and login process. - Property listing details: Detailed information showcased for each property listing on Map. - Contact agent/owner: Messaging feature to facilitate communi...
I need New freelancer who can create an advanced Productivity app. like Regain screen time + Focus only for Android. The app should have the following features: - All apps Usage - App Reminders: for Example: When the user selects any app for reminder. Let's YouTube as an example. When the user opens Youtube on his phone, a pop- up will appear asking for how long you wants to use youtube. 5 minutes 10 minutes 20 minutes. If the user selects 5 minutes, then a pop-up will appear again if he uses it for 5 minutes. Just like the Regain app. - Separate screen for whatever permission is required. - Bottom Navigation with two button: 1. Home: Show the top app usages time, then selected app open like youtube open 3, Instagram open 5. 2. Apps : Shaw the app list for selecting and app ...
I have a 5,000-word article that needs to be urgently (24 hours) formatted according to APA 7th guidelines. The syntax, wording, and spelling also need to be checked. The primary requirements are: - In-text citations - Reference list - Page layout conformance with APA 7th rules The specific sections of the article that require special formatting are: - Title page - Abstract - Introduction - Method - Results - Discussion - Conclusion - References The entire document needs to be formatted according to APA 7th rules. Please note that the preferred font style is Times New Roman.
...experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integration • Laying out elegant formatting of the sheet • JSON data access library (including CRUD, parse/stream, search etc etc) • “Areas” library to create formated spaces within Excel Sheets (formating, inserting buttons, Create/Delete/InsertRows, elegant location naming systems) • Execute/Recalc tools (e.g. when the sheet is not busy it may ping a URL every 60 seconds) • Please show any experience and work done in the above We are a startup who would like to make a significant contribution to ...
...the finish can be a bit painted effected than a real world photo. - There should be a golden colour highlight design which will be actually a gold foil stamping done on the paper bag, which is the highlight of the design!! - This golden highlight should not exceed 50% of the area, it would be great if it covers the center part of the bag. - Sides of the bag should be in green as seen in the reference pics with some designs on it. - Front and back of the bags will remain the same, there is no bottom design. - Please try to minimize the number of colour used (no restriction if its majorly used all over the design). Five to six colour usage is okay. - Dimension of the product is 12inch X 10inch X 4 inch (HxBxW) . - The final work should be given in coral draw format, or whatever f...
I am in need of a skilled individual to help me with a Google ads campaign for my sports memorabilia business. The focus of the project is: - **Location:** The initial focus will be on the Melbourne market, so I need someone who understands this market and can tailor the campaigns accordingly. - **Goal:** The primary aim of the campaign will be to generate leads. I want to attract potential customers interested in sports memorabilia. - **Services:** Although I offer custom framing and fundraising services as well, the campaign will mainly revolve around sports memorabilia sales. Ideal candidates for this project should have: - **Google Ads Expertise:** Demonstrable experience in running successful Google Ads campaigns is crucial. - **Local Market Knowledge:** A ...
We have a B2B WordPress website that fails Core Web Vitals on mobile and desktop. The site was originally made by one developer, then worked on by another, resulting in many issues due to lack of communication. The website uses Elementor and a customized theme. We would like to work with an expert WordPress developer to improve the site's performance and get it into the green in Core Web Vitals. We also want to remove all unnecessary plugins (currently the site has almost 50 WordPress plugins). We are open to moving the site to a new server if required and rebuilding it to improve performance. Looking to work with an experienced WP developer and performance expert to solve this. Please get in touch if this is something you specialize in and we can discuss this project further...
Seeking a Google Playstore account for instant entertainment and games app deployment, with a focus on teenagers. In brief: - I aim to bypass the testing process prevalent in the usual account creation. - The focus of my app portfolio will be on applications that cater to the teenage demographic. Ideal Freelancer: - Experience with Google Playstore account transactions. - Proficiency in developing and publishing entertainment and games apps. - Understanding of the teenage market and its preferences.
I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English
My main objective is to drive product sales through a focused Google ad campaign. I need a freelancer that can: - Understand the beauty industry and the dynamics of promoting online courses. - Harness this understanding to create a strategic Google ad campaign, aimed at intermediate learners. The campaign should stand out visually but also contain content that speaks directly to intermediate learners looking to improve their beauty expertise. Experience in the beauty industry is desirable, but more importantly, I'm looking for someone who can demonstrate a solid track record in managing successful Google ad campaigns tailored to specific audiences. Familiarity with online education platforms is a plus.
I'm in need of a professional animator to create a series of short, engaging animated videos. The main goal of these videos is to educate the audience on a variety of topics, such as Science, History, and Health and wellness. Sample reference video. Key Responsibilities: - Create visually engaging and informative animated videos - Ensure the content is clear and easy to understand for the intended audience - Develop storyboards and scripts in coordination with me Ideal Skills and Experience: - Proven experience in creating educational animated videos - Strong understanding of the topics mentioned, Science, History, and Health and wellness - Excellent communication skills to work closely with me on content creation - Ability to create content
I am engrossed in studying a company's customer, product, and trucks data for my PhD research. Contemporary businesses encounter a significant challenge wherein their delivery trucks often travel from one region to another with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box
I'm looking for a skilled graphic designer to assist with designing business cards, the sole focus being on this print material. I have a logo and colour scheme that I would like you to incorporate into the business card design. This will ensure consistency across all of my print materials. Attaching our company brochure for reference. Ideal skills for this project: - Proficient in print design - Experience with business card design - Ability to work with existing branding guides - Strong attention to detail and creative flair
...tasks. Key Tasks: - Filing Annual Financial Statements - Conducting an Audit - Updating Statutory Registers Key Requirements: A. Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). B. Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). C. Assistance & Documents Preparation for Company's Current Bank Account. D. Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, and Director's Report. E. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions). F. Preparation & Filing of Annual Returns Form AOC - 04 (Financials Related Annual Return). G. Preparation & Filing of Annual Returns Form MGT - 07/07A (Management Related Annual Re...
I'm looking for a skilled professional who can help me generate leads with a new Google Ads campaign in Saudi Arabia. Ideal Skills and Experience: - Proficiency in Arabic language is a must - Extensive experience in Google Ads, particularly in lead generation - Familiarity with the Saudi Arabian market and audience preferences Key Objectives: - Tailoring the existing Google Ads campaign to target the right audience in Saudi Arabia - Ensuring the ad effectively generates leads for my web design and development business - Incorporating a clear call-to-action for people to reach out via WhatsApp or phone call after clicking on the ad Please include "I know Arabic" in your bid to indicate you've understood the requirements.
Hello Christian, Thank you for discussing the interior design project for your living room. Considering the floor plans, photos, and moldboard design you've shared, I propose delivering approximately 8 realistic rendering images within 7-10 days for 700 EUR. The payment will be divided into two milestones: one for the preview and another for the final rendering images. Best regards, Mohsen
...feature for an e-commerce site. It should enable customers to easily find products they are interested in, through categories, filters, and search functionality. Payment Gateway Integration: I have the following specific payment gateways in mind for this project: - PayPal: A widely used payment gateway that provides flexibility in payment options and offers a trusted payment experience. - Stripe: Another popular choice for online transactions, Stripe offers seamless integration and a secure payment process. Ideal Skills and Experience: - Proficiency in frontend development - Experience with e-commerce website development - Knowledge of Figma or similar design tools - Experience in integrating payment gateways, especially PayPal and Stripe If you're confident in your abili...
...finalize sales contracts, ensuring favorable terms for both parties. Follow up with clients throughout the sales process to provide updates and address any concerns. Stay updated on market trends, property values, and industry regulations. Utilize advertising methods and marketing strategies to promote properties and attract potential buyers. Maintain a database of clients and properties for future reference. Collaborate with other team members to achieve sales targets and objectives. Requirements: Bachelor's degree/ Pursuing Bachelors, Marketing, or related field preferred. Minimum of 1-5 years of experience in real estate sales. Excellent communication and interpersonal skills. Proven ability to generate leads, convert prospects, and close deals. Valid driver's li...
...expert who is Google Ads Certified and able to verify crucial business operations, particularly related to my advertising campaigns. The focus of this project is to ensure the complete and accurate functioning of my PPC campaigns. This involves the following key aspects: - **Business Operations Verification:** The ideal candidate will have a deep understanding of Google Ads and be able to perform a comprehensive verification of the business operations linked to my PPC campaigns. This includes ensuring that all tracking and conversion mechanisms are set up correctly and functioning optimally. - **Google Ads Certification:** It is crucial that the chosen freelancer is Google Ads Certified, as this certification signifies a high level of expertise and knowle...
I will develop a custom Landing page based on your reference.
...designer who can create a memorable, professional, and visually appealing logo for a Trucking Transport Company. The logo should draw the attention of my target audience and help establish a strong brand recognition. Key Requirements: - The Name R.T.J. should be inserted on the grill - The word TRANSPORT should be put on the front bumper bar, both carved in one example and straighter cross in another example. - the logo should convey an icon of the front of a truck (see attachment) with the name inside sections. - The logo should be created with some blues, some gold font colours - the logo should be given to me in a few different colour samples I'm on a tight deadline for this project and need it to be completed as soon as possible. Ideal Skills and Experience: - Prov...
I'm in need of a Google search expert to help with keyword research and ad campaign management. Key Tasks: - Keyword Research: The primary goal of this research is to increase website traffic. The expert should be able to identify high-performing keywords for our industry. - Ad Campaign Management: The target audience for these campaigns are national customers. The expert should be able to set up and manage effective campaigns on Google. Ideal Skills and Experience: - Proven experience in keyword research and search engine optimization. - Track record of successful ad campaign management, particularly for national audiences. - Knowledge of Google's advertising platform and its functionalities. - Ability to analyze data and optimize campaigns for better performanc...
I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).
*PLEASE READ THE GOOGLE DOCK BELOW CAREFULLY AND CONTACT US FIRST IF YOU HAVE QUESTIONS* Details of our current project STACK can be seen here -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. We will start with 5-10 small task in and then go to some smaller .NET tasks all with 1 day sprints for you to become familiar with the software and then our main goal will be to integrate another B2B API for our MVNO. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on your time zone. If you are awarded the task we expect you to accept IMMEDIATELY and if the project is not accepted immediatly we
I'm seeking a developer who can help me resolve an issue that the google pay button doesn't appear when the allowed auth method is CRYPTOGRAM_3DS. Thank you,
I'm seeking a developer who can help me resolve an issue that the google pay button doesn't appear when the allowed auth method is CRYPTOGRAM_3DS. Thank you,
...website to collect all relevant data. Data Compilation: Organize the information into a clear, structured table that facilitates easy comparison. Graphic Design: Develop visual graphics to accompany the data, enhancing the clarity and accessibility of the analysis. Deliverables: A detailed table comparing key aspects of each 3D planner software. Visual graphics summarizing the comparison for easy reference. Action Required: I need someone to thoroughly explore the websites of the listed competitors and extract all pertinent information. The final output should be a well-organized comparison table and attractive visual graphics that effectively highlight the key differences and similarities in their offerings. Here is the list of the competitors: -
...enhance two key areas of my website and I need your expertise. - Supplier Product Upload and Search Functionality: Firstly, I would like to improve the way how suppliers can upload products (one product with different supplier prices by different suppliers), and how it is displayed to customers. - MLS Feed Integration: Secondly, I'm looking to connect my website to receive an MLS feed from another website. This would require you to setup the connection and ensure the data is accurately synced. Ideal Skills: - Proficiency in web development with a focus on ecommerce features - Experience with implementing search functionality improvements - Knowledge of MLS feed integration would be a bonus. - Laravel If you're confident in your ability to deliver on these two area...
I'm looking for a skilled designer to complete a product quick start guide for the XESS ION product. A mockup created in InDesign is attached but it is only for content and to help convey the concept. High resolution product images are attached, as well as the product's datasheet for reference. It needs to be: - Sleek: It needs a fresh, modern, and professional look. - Good Layout: A new design should improve the overall structure and flow of the content. - Clear Typography: The text in the brochure is essential for understanding the content. The typography needs to be enhanced to improve the English quality and clarity. Ideal skills and experience for this project include: - Proficiency in Adobe InDesign or Illustrator - Strong design sense and the ability to create...
I'm looking for a skilled developer who can create a CS-Cart website along with both Android and iOS mobile apps. Please note that I have not specified the primary features for the website. In terms of the design, I'm open to suggestions. Reference is We will add Auction bidding option as well Mobile App You have an access to the mobile app source code for 1 year. Please let me know your GitHub account username so we could send an invitation to the repository. The source code can be used for the app customization with a hired developer. If you want us to build the standard mobile app for you, please follow these steps: 1. Please install the Mobile application add-on in your admin panel. Add-ons are
I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.
I am in need of someone who can promote and edit videos for my residential real estate Project I have some clips and a reference video Also I need someone who can help me with describing the popular location surronding my site using "google earth" which i have a reference Project needs to be completed within today If anyone available Kindly BID
Need an web hosting an expert to update my DNS settings. This is essential to ensure a smooth and seamless transfer. Ideal Skills and Experience: - Proficiency in DNS settings and configuration - Experience with migrating websites between hosting providers - Expertise in Google Workspace, particularly in setting up domain emails - Good communication skills to keep me updated on the progress and potential issues.
...multiplayer gameplay. Key Points: - The game will need to be developed using Unity and Photon Unity Networking (PUN) to facilitate the asynchronous multiplayer experience. - The gameplay should be optimized for mobile devices, ensuring a smooth and enjoyable experience for players. - The focus of the game will be on asynchronous multiplayer, meaning that players will be able to engage with one another without being required to be online simultaneously. This will require robust synchronization mechanisms and a well-thought-out game design. Ideal Skillset: - Proficiency in Unity and PUN is a must for this project. - Strong experience in mobile game development, with a portfolio of successful titles. - Prior experience with asynchronous multiplayer game development will be a signi...
I need a professional to prepare my income statement and balance sheet according to IFRS standards. My records are ready, and I only require a summary-level of detail. Ideal skills and experience include: - Proficiency in IFRS (International Financial Reporting Standards) - Proven track record in preparing financial statements, especially income statements and balance sheets - Detail-oriented and able to work with a high level of accuracy - Good communication skills to clarify any details for a summary-level reporting. This is a one-time project, but if successful, there may be more in the future.
I'm a digital affiliate marketer who needs a comprehensive product cross-referencing and price comparison tool developed for my e-commerce website. The tool should be capable of processing data from around 30,000 products across 5-10 different stores. Key Requirements: - Cross-reference 30,000 products from 5-10 stores: The tool should be able to analyze and compare prices for a substantial number of products across multiple listed stores. - Avoiding Captcha and ad blockers: The tool should be designed to function effectively while avoiding common barriers like Captcha or ad blockers. - User-friendly filters: The tool should offer a variety of filters to help users refine their search results. - Display results directly on product pages: The comparison results should be in...
I need a comprehensive responsibility matrix for our Sap MDG & BODS project. - The Matrix needs to clearly outline the roles and responsibilities of each team member involved in the project. - It should include both high-level, overarching responsibilities and detailed, task-based responsibilities. - Our intention is to use this matrix as a live document for daily project management, as a reference document and as a tool to facilitate efficient communication between different teams. The successful candidate for this project must have: - Strong knowledge of Sap MDG and BODS - Experience in creating clear, comprehensive and actionable responsibility matrices - Excellent communication skills to ensure that the matrix is effectively used by our teams.
I require an experienced accountant to prepare a set of financial documents for my company. Last 2 year Audited Financial statements for the previous 2 fiscal year-ends: Income Statement, Balance Sheet, Cash Flow Statement Interim Financial Statements (Balance Sheet, P&L, Cash Flow Statement) Financial statements for the most recent interim period: Income Statement, Balance Sheet, Cash Flow Statement Merchant Processing Statement
I'm in need of an experienced audio technician, preferably with a background in voice manipulation and sound editing. As per the requirements of my project, I'm attempting to alter my voice recording to emulate that of another person, whom I have vocal samples from. Qualifying candidates should be adept at manipulating aspects such as pitch, tone, and accent to make my voice a convincing replica of the target voice. Key skills and experience: - Proficiency in sound editing - Prior experience with voice alteration tasks Please include the following information in your application: - Examples of past work, preferably including voice alteration projects. Despite the technical requirements being unspecified, proficient knowledge and use of appropriate software are unequivoc...
Please collect product information on cars that are equipped with the technology described in the [2. Technology Description] column below. ※Note Please do not collect information based only on the information listed in [1. Background] [3. Reference information] ([1] and [3] are for reference only) 【1 Background】 This technology pertains to a system that utilizes mobile devices in vehicles. Specifically, it combines a smart key system with Ultra-Wideband (UWB) wireless communication to authenticate the mobile device with the vehicle and precisely detect the location of the device. Based on this location, the system determines whether to allow or deny vehicle operations. This aims to enhance security and service quality. However, since UWB communication uses high-frequency ba...
I'm in need of a skilled WordPress developer to create a professional and clean WordPress website for my company. Although no specific functionalities were indicated, a user-friendly interface, seamless navigation and functionality, and a professional design reflective of the tech industry are all important factors. Expertise in WordPress, knowledge of tech industry...WordPress developer to create a professional and clean WordPress website for my company. Although no specific functionalities were indicated, a user-friendly interface, seamless navigation and functionality, and a professional design reflective of the tech industry are all important factors. Expertise in WordPress, knowledge of tech industry trends, and an eye for design are preferred skills. reference website w...
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:01"...
