Vlookup Tables Projects
Looking for freelance Vlookup Tables jobs and project work? PeoplePerHour has you covered.
UK QUALIFIED MATHS TEACHER TO MAKE TABLE OF CONTENTS FOR BOOKS
We are looking for a UK Qualified Maths teacher to make a table of contents for 16 books which will cover key components of Maths curriculum of children from ages 5-14. The books will be the following: 1-8 Books - MATHS DRILLS (Covers the 4 operations right from addition of 1 digit numbers to 1 digit numbers to decimal addition etc and with all the other operations in a chronological manner) 1-8 Books - PROBLEM SOLVING - same as above but for problem solving (numerical reasoning, worded problems etc) Best wishes, Beenish
10 days ago8 proposalsRemoteWebsite data scraping
I need to scrape 9 data points from a website and put them into mySQL database. I have one table with these 9 fields. I need a script which runs every hour, scrape data and load the data into this table in mysql database.
7 days ago36 proposalsRemotepre-fundedurgent
Corporate Powerpoint 40 slides charts, content done already
I have a 40 slide corporate presentation with charts, tables, photos . I have written all the content, made the excel file for the charts, saved all the photos. I have a template design I would like to copy. I need someone to actaully make my powerpoint look better, format it, make it look slick.
2 days ago48 proposalsRemoteExpires in 28opportunity
Virtual casino games animations
Hi, Looking for few graphics and animations for upcoming social casino games 1. 10 different female character and basic motiion graphics of hand movement, clapping, smile like a typical casino dealer would move on table during gameplay. potential graphic attached 2. Need background and blank table in front of casino setup - 10 different backgrounds. 4 different casino table with blue, red, green and purple colors. 2d Virtual background could have slot machines, other casino tables, or any other suggested background could be considered. 3. Need animation of winner, congratulations, new round, betting closed . This could be text animations Need full IP and source files Timeline of 20 days or earlier for complete deliverable, any deviation to be agreed in advance else this is to be delivered
13 days ago12 proposalsRemoteCreate a bot - fill in a form using a table and save the outcome
Hello, I need an automation/bot to: - Automatically run every day - Fill out an online form for each row in a Google Sheet table - After submitting the form, take a screenshot and download files from the page that is displayed - Save the screenshot and files in Google Drive following a naming format - Produce a report for any rows that failed In more detail: - A Google sheet exists with approximately 50 rows of data. The records within this table are regularly updated - Specific cells from each row are used to fill in an online form - Open the link in a browser - Click on another link and click an “I agree” box - Open the Google Sheet table. Take the first row - Fill out some of the details on that page using data in the table (I believe the form is Javascript) - A page is displayed. Take a screenshot of this window. Save the screenshot to Google Drive using the format “YYYY.MM.DD HH:MM - LastName(FromGoogleSheet) LastName(FromGoogleSheet) PostCode(FromGoogleSheet) - Details” - Two boxes can be clicked on at the bottom of the page. - Click on the first box. - Take a screenshot. Name it as above but with “Allowance” at the end. - There is an ‘Export to CSV’ option. Click on that. Save the file in the same format with “Allowance CSV” at the end. - Go back a page and click on the second box - Take a screenshot. Name it as above but with “Payment” at the end. - There is an ‘Export to CSV’ option. Click on that. Save the file in the same format with “Payment CSV” at the end. Repeat for the second row. And so on. Create a list of any of the rows that failed to progress to the page after the form has been completed and email it to me each day. Please quote "BFL2902" at the start of your message so I know you have read and understood the brief. Thank you.
a month ago13 proposalsRemoteInterior designer making super realistic digital photos of homes
I will give the designer a photo of a room (it could be a bathroom, bedroom etc) and I would like the designer to change items within the room according to my instructions for each photo. Scenario 1 change the table lamp to something less luxury scenario 2 change the bed to a navy blue comfortable looking bed scenario 3 remove the light switches from the photo scenario 4 Change the coffee table to a round white table. I have more than 1000 pictures to change and I would like to work with someone long term. I have included some pictures to this post showing before and after of a photo so that you can see the results. Even though we will add digital furniture/items, it needs to look super realistic. If it doesn't look realistic enough, then it will not pass. The price for the project will be based on 10 pictures
10 days ago21 proposalsRemoteMenu Display Sign and menus
I need a large menu design for my cafe wall which will be eyecatching and friendly. I have a logo, pattern and the items to be priced, as well as the font. But I need someone to use this to create the menu for the wall - which will be about size A2. I also need a table menu designed in the same way (A5 double sided). Thanks
10 days ago29 proposalsRemoteI need a Lash lift & tint training manual/educators guide made
I'm looking for someone to create a training manual/eductors course about lash lift & tint. I needs to be in a pdf format as well as an editable version. The manual will be for educators/teachers to teach from as well as for students so they can learn on their own. (one manual). The guide needs to be as detailed as possible as it will be for beginners. From laws and legislation to details on how to perform the treatment and everything in between. It needs to be written professionally with pictures to make the guide look for informative. I will give you the 'table of content' titles and you will need to write about that. I need to look good as a PDF/Editable online as well as a printable version so it can be easily printed and turned into a booklet.
2 days ago15 proposalsRemotePostgresql import and data validation rule help
I have huge number of database. we alredy build scema. Need help with import data faster with some table split codditions, now it's taking too much time to import data in main table
a month ago30 proposalsRemoteDevelop online course with my existing materials
Personal Branding: Unleash Your Potential Online is a course I am creating. I am seeking a skilled freelancer to collaborate with me on the development of an online course on personal branding. With a PhD, a thesis, book, and extensive course materials that I have used in the past, I am ready to narrow it down and create a captivating 3-4 module mini course. I envision building a more comprehensive and in-depth course to offer at a higher price point in the future. I have an outline in place, but I am seeking a partner who can bring expertise and creativity to the table. I am not looking for a quick turnaround or a one-time effort. Instead, I want to work closely with you over a period of 2-3 weeks, refining and enhancing the course until it is truly exceptional. I am open to suggestions and feedback throughout the process, and I value your expertise in course development. If you have a passion for personal branding and are ready to make a significant impact, I would love to hear from you. Please list your experience and include a sample of your work or portfolio that demonstrates your skills and expertise in this field. English skills must be at expert level.
7 hours ago10 proposalsRemoteSnooker Club
We are looking for a talented website developer to create a new and exciting snooker club website. The website will include the ability to book tables and make payments online, making it easy for customers to enjoy their snooker experience. We want the website to be bright, fun, and fresh, with an emphasis on people having fun. The website will also feature a members area, where customers can log in to view their bookings, view their account details, and track their progress. We are based in London and are looking for a developer who can create a website that is both user-friendly and visually appealing. The ideal candidate will have experience in creating websites for snooker clubs or other sports-related businesses and will be able to work closely with us to ensure that the website meets our requirements. If you are a talented website developer and are interested in this project, please submit your proposal to us. We look forward to hearing from you.
9 days ago26 proposalsRemoteopportunity
Web Design of Certain Pages in a Website
Background Make a Rezzy (makearezzy.com) is a website which is somewhat similar to OpenTable. We allow restaurants to list the restaurants and customers to book tables at those restaurants. Job Following accepting the role, I will give you some login details to login as a user to the site. This will give you access to certain pages which I would need a redesign for. These pages are: * A details page where a restaurant owner can see information about their restaurant * The main detail page of a site where the user can see information about their restaurant * The search results page * Booking confirmation page * My bookings list page All pages should follow the existing colour scheme and should be fully responsible. Constraints * Must only use royalty-free images with links to the source.
a month ago51 proposalsRemoteSenior Accountant, QB Online & US Taxes for E-commerce Brand
We seek an experienced, energetic candidate with strong accounting skills for our e-commerce business. Full-time, remote role. Must be well-organized, reliable, efficient, and detail-oriented. The candidate will be expected to handle the following tasks: • Organize Quickbooks Online account • Manage all accounting transactions and finances • Track expenses and payments for the e-commerce store (e.g., COGS, shipping, software costs, etc.) • Reconciling various accounts such as our Shopify account, credit card/bank/PayPal statements, business expenses, employee wages, etc. • Manage balance sheets and profit/loss statements • Cash Flow Management Support • Handle accounts payable and accounts receivable • Assist with Inventory Management • Audit financial transactions • Provide support during external audits and tax filings • Create weekly/monthly financial statements • Assist in budgeting and forecasting activities • Collaborate with cross-functional teams to improve financial processes and procedures Requirement and/or Qualifications: • Work experience as a Senior Accountant • Bachelor's degree in Accounting, Finance, or a related field • 2+ years of experience in QuickBooks Online with QuickBooks Certification • Knowledge of US tax preparations, especially for corporations, is highly preferred • Experience working with bank and credit card accounts • Excellent knowledge of accounting regulations and procedures • Excellent computer skills, including proficiency in MS Excel and Google Workspace (Google Sheets, Google Docs, etc.) • Experience in General Ledger functions • Excellent communication skills, both verbal and in writing (English) • Strong attention to detail, persistence, and strong analytical skills • Possesses excellent organizational skills • Certified Public Accountant (CPA) certification is a plus Other preferred requirements: • E-commerce Accounting Experience • Experience with Shopify and PayPal • Experience using Airtable and doing advanced calculations with pivot tables, etc. • Experience with filing state taxes
10 days ago18 proposalsRemoteNeed to create a report using SQL
I require assistance in generating a complex report from multiple data sources within a custom application. The report necessitates retrieving and aggregating information from various tables using SQL queries. It must pull and consolidate pertinent records from a range of interconnected database assets while preserving data integrity. Specifically, the report will need to extract salient fields like identifiers, values, and timestamps from several intricately related operational stores. It should then compile and organize the extracted segments to provide a holistic view of core business operations over a specified timeframe. The constituent pieces must be intelligently linked and cross-referenced to offer meaningful insights. The underlying database schema may be intricate with numerous joins and intricate relationships between entities. As such, the SQL development will require strong expertise in querying disparate sources and nesting clauses to obtain all needed attributes. Optimization will also be critical as improper queries could impact system performance. Overall, the finished report must deliver a cohesive narrative and present compiled information in a clear format that facilitates easy analysis. Requirements gathering, iterative testing, and validation against source data will be pivotal to ensure accuracy and reliability. Mobility with formatting for both onscreen and printable distribution is preferable. Key skills needed are advanced SQL, relational data modeling, report generations, and analytical problem-solving abilities. Experience extracting consolidated views from sophisticated production databases through SQL is a must.
a month ago18 proposalsRemoteopportunity
WordPress NEWS Website
The Project is to develop a dynamic NEWS App using WordPress to provide users with easy access to up-to-date news content on various topics. The app will leverage WordPress's robust CMS capabilities to streamline content management and deliver a seamless user experience across web, table, and mobile devices. 1. User Interface: Clean and intuitive interface for easy navigation. Mobile-responsive design to ensure compatibility across devices. Customizable layout options for user preference. 2. Content Management: Use of WordPress CMS for content creation, editing, and publishing. Ability to categorize news articles for efficient organization. Support for multimedia content including text, images, and videos. Custom Design is available 3. News Feeds: Aggregation of news articles from multiple sources. RSS feed integration to automatically fetch latest news updates. Option for users to customize their news feed based on interests. 4. Push Notifications: Push notification functionality to alert users of breaking news or important updates. Customizable notification settings for user preferences. 5. User Engagement: Social sharing features to enable users to share articles via various platforms. Commenting system to facilitate user interaction and feedback. Bookmarking feature for users to save articles for later reading. 6. Personalization: User profiles to track preferences and browsing history. Personalized recommendations based on user interests and behavior. 7. Monetization: Integration with advertising networks for revenue generation. Option for sponsored content or native advertising. 8. Performance Optimization: Optimization for fast loading times and smooth performance. Image optimization to reduce data usage and improve loading speed. 9. Security and Privacy: Implementation of security measures to protect user data and prevent unauthorized access. Compliance with privacy regulations such as GDPR. 10. Analytics: Integration with analytics tools to track app usage, user engagement, and content performance. Generation of reports for insights into user behavior and content effectiveness. 11. Localization: Support for multiple languages to cater to a diverse user base. Localization of content and interface elements based on user preferences. 12. Technical Requirements: Compatibility with latest versions of iOS and Android operating systems. Integration with WordPress backend, utilizing REST API for data retrieval and management. Testing on various devices and screen sizes to ensure optimal performance. Full requirements will be shared when the final selection is made.
14 days ago45 proposalsRemoteHIRING: YouTube video editor, for educational / how-to videos.
We are seeking to hire an experienced YouTube video editor, to help create educational / how-to videos. The video topics will mainly center around graphic design, ecommerce and photography. The videos will be short (0:30 - 2:00), with a punchy, fast-paced communication / delivery / editing style. The goal of each video is to provide maximum usefulness + educational value to viewers, while also including some humor and entertainment. The workflow will look like this: Each video will have its own folder. This folder will contain the already-edited-together audio narration file for this video, as well as a pool of already-prepared video assets (which could include screen-recording videos, screenshot images, relevant stock videos + images, etc.) You will then take these existing assets, build upon them creatively using your video-editing skills, to help produce a very solid final video. Our videos follow a set of general rules + best practices that include the following: --first 3 seconds = very attention-grabbing, showing animated text on screen to hook them via the "hover over thumbnail" functionality that now exists on YouTube; --high-effort and fast pacing during the video -- helping to maintain the audience's retention + keep them stimulated / engaged for the full duration of the video; --some fun + humor integrated where appropriate/possible into the edits; --sound effects included as well, that synchronize with the video edits on screen and/or with pertinent sections of the video script; --the edits synchronizing very nicely with the current point in the audio narration / script throughout the full video; --the inclusion of some text graphics/animations on screen as well; --zooming / highlighting / cropping certain video assets, so as to make a more focused + effective video presentation. --no background music track (although music can be included when used as sound effects -- just no background music track dropped across the entire timeline basically); Selected candidates will be provided a link to our YouTube channel so they can watch some of our recent videos + get a feel for the general editing style we utilize. The ideal video-editor will have the following attributes: --attention-to-detail, with your edits, and putting in a high amount of effort to do the best job you can to make the video as useful, entertaining, engaging, and smoothly-edited as you can; --can fluently understand the written + spoken English language, as our video narrations will be in English; --uses good video-editing judgement and can produce solid video content independently. doesn't expect to be spoonfed an exactly-specified list of each and every single little edit we want made into the video -- but instead, can understand the goals for a video, look at the pool of prepared assets, then use their skills to put together a solid final video using their best judgement. --the ability to take initiative as an editor, to ensure that the final video is your best effort. examples of such initiative may be: creatively including your own assets, where appropriate, to improve the final video (vs. requiring everything to be 100% prepared in advance for you + having your edits only include the already-prepared files, images + videos). an example might be, creating a funny image via midjourney, to then include in the video to humorously accent a certain point being made; or, finding a humorous or relevant stock video from a site like Storyblocks, then including it in the video, to improve a certain section in the current video; or taking a few screengrabs of a certain website, where the folder of prepared video assets is lacking for that section of a video, so that an adequate video presentation can be made for a given section; etc. we're looking for an editor who will bring more to the table than just dropping existing clips on a timeline -- but instead, will go above and beyond to *build upon* the provided assets, to ultimately help create the best final video each time. **Attached to this job posting is a 20-second partial audio-narration file, along with a screen-recording video. As part of your job application, please include an edited version of this clip that meets the desired criteria I described above. I will use the edited video clip you submit to assess the work quality I can expect from you on this project -- and I will not be hiring anybody for this project who doesn't submit this edited 20-second video clip along with their proposal.** Selected candidates will begin with 1-2 paid "trial" video projects. If your final videos are very solid + what we're looking for, there will be consistent, ongoing video-editing work for you on this project. Please let me know if there are additional questions about any of this. Thank you!
7 days ago24 proposalsRemote
Past "Vlookup-tables" Projects
Convert 3 PDFs to Excel
I have 3 PDF with tables that need converting to an excel file table. Each line should have it's own row, sample attached
Menu Design
Hi - we are looking for someone to design our restaurant and delivery menu. I have attached our table menu. I needed to create a takeaway and restaurant menu. I really like a rustic look and feel.
Convert furniture inventory from blueprints to quantity tables
for 180 school classrooms and related spaces Proficient in remote data entry (e.g., Excel). Transcription of blueprint data to quantity tables. Ensure accuracy and completeness. Collaborate with team online. Proficient in remote data entry (e.g., Excel). Previous surveying experience preferred. see a sample FFE room below
I need a expert on Elementor Pro
i need a Expert developper on Elementor/wordpress to help us finalise some Works on a Elementor Website. Of the 14 templates to be adjusted, 2 present technical problems: Thematic training template: - Tables are not dynamic. Training Templates: - PDF generation does not work. - The additional training tables do not point to the correct training courses. - Breadcrumbs don't work. - Prices, difficulties and durations are not dynamic. These issues must be resolved within the templates and must not be adapted page by page. The searchbar is not completed, the training is not correct, and the animation is not implemented. This technical element is not attached to a template and does not pose a problem when finalizing the design of the 14 other templates. Action plan 1. Finalize the design of the 12 templates without technical problems. These templates have a limited number of display problems, and their corrections are simple. 2. Find a solution to the technical problems of the 2 templates, and finalize the formatting and animation of the search bar. 3. Once the technical problems of the 2 templates have been resolved, have the formatting of these templates finalized by Omar, or directly by the person who resolved the technical problem. Additional questioning The search bar integrated into blog pages is not yet implemented in the dev site. This element already exists, or does it need to be put in place? Technical problem resolution specifications 1. Tables must be dynamic Goals: : - These tables give the list of training courses available within the theme. - These tables are dynamic elements, they are integrated into the template and retrieve data from a database. - These tables must be dynamic in the two templates that use them. Prerequisites: - Each element of the table must be dynamically populated via the database, and in this hierarchy: Name of the theme Category name Number of training courses in the category Name of training training duration Tags related to this training - The "New Arrivals" tags must be displayed in blue, and "Top sales" in red. - When there is only one category in the theme, the category bar must be hidden. - The table must be opened in the thematic template and closed in the training template (child template of the thematic template). 2. The tables in the training template must display additional training for the parent theme Goals: - The table at the end of the training page (child of the thematic page) shows all the other training courses within the same theme. Prerequisites: - The table must have the title “Additional training - #Thematic#”. #Theme# corresponding to the name of the parent theme. - The table must exclude the training corresponding to the training page already opened. 3. Breadcrumbs don't work Objective: - The training template pages display breadcrumbs corresponding to the correct hierarchy and which lead to the correct pages when clicked. Prerequisites: - The breadcrumbs must be organized as follows: - Home / - Our digital training (landing page training) / - #Theme# Page (current page) 4. PDF generation does not work Objective: - The pages of the training templates have two buttons allowing you to generate PDFs. These two buttons allow you to generate PDFs of the training page and use a plugin (PDF Pro) to configure the appearance of the PDF. **Prerequisites:** - When clicking on the PDF button, a PDF should be generated with similar formatting as the original site. - The PDF should open in a new tab. 5. Prices, durations and levels must be displayed and dynamic Objective: - The training template pages have a map on the right. This card displays the price, duration and level of training. These three elements are dynamic and retrieved automatically from a database. Prerequisites: - Prices, durations and levels are displayed dynamically and should not be modified on the pages.