Vlookup and pivot tables työt

As part of my Master's degree in linguistics, I urgently need a professional proofreader and editor to diligently review my academic paper. The paper, titled "The influence of learning a third language on interlanguage development : a systematic review," is 17,754 words in length and must adhere to APA 7th style guide. PS. Don't worry about the word length it's mostly tables. Key Requirements: - Expertise in academic proofreading and editing is a must. - Familiarity with APA style guide. The project has a tight deadline, with the work needing to be completed within a week. If you have the necessary skills and experience, I look forward to receiving your proposals.

I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The for...in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver a...

...me with a unique task. I need assistance with table extraction from financial scanned PDF Documents. The tables in these documents are complex, often containing merged cells and layouts that are more intricate than standard. Key Requirements: - Proficiency in OCR techniques, especially in relation to table extraction. - Experience working with scanned PDFs. - Ability to efficiently handle tables with merged cells or complex layouts. Your role will involve: - Utilizing OCR software to extract tables from scanned PDFs. - Ensuring the accuracy and completeness of the extracted data. - Solving any issues that may arise from the complexity of the tables. You need to be experienced in OCR and have a keen eye for detail to apply for this rol...

I need a simple app developed using Microsoft Power Apps. This app will primarily serve as a data 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 ha...

I'm looking for an google sheets / excel guru who can construct an advanced drop-down loo...lookup system for my entire sheet. This system should include multiple variables that will inform the price from the database. Currently looking up values manually in a series of tables, tables may need reformatting to allow for efficient searching Key skills and experience: - Proficient in MS Excel Advanced Functions - Experience with both numerical and text data - Knowledge of creating drop-down lookups for entire sheets The final product should streamline our decision-making process by providing agile, accurate prices based on the selected variables. Your comprehensive understanding and application of numerical and text data within an Excel envir...

...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 document data will be a significant advantage. By bidding, you agree to maintain the confidentia...

...skilled and enthusiastic Nursery Teacher, specifically for the age group of 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 ...

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.

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 ha...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 closely matches the original PDF, I&...

I need a Word document created from a PDF file. This isn't a simple text extraction but requires keen attention to detail as the formatting of the original PDF must be maintained meticulously in the Word document. The PDF is mainly text, so you won't need to worry about handling complex elements like tables or graphs. Ideal candidates for this gig should have: - Proficiency in PDF and Word - Eye for detail to replicate exact formatting - Solid command of English and document formatting skills to ensure no loss of content or meaning in the conversion.

A reliable database migration specialist (with previous email campaign setup skills) with their own computer and internet to work from home. You will be working with the Microsoft SQL server, experience is preferred but not essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in ...

...PHP and MySQL expert, your task will be to fix a challenge I'm facing with PHPSpreadsheet. My Excel data is not being imported correctly into MySQL as tables are not being created. Despite no error messages alerting me to these issues, the hiccup persists. Below is a more detailed description. After login, the user uploads 4 required and 2 optional Excel files on the dashboard page. The files are uploaded to an “upload” folder on the server and the file names and other info are stored in the “files” table of the mysql database. All of the above works with no problems. Once the actions above are complete, a button at the bottom of the dashboard page is activated. When the button is pressed, PHPSpreadsheet is used to mo...

Currently in need of a proficient freelancer for converting my book from PDF to Word format. As unsure if the final Word file should retain the formatting of the original PDF, passages in the book do not seem to need specific attention to detail like conversion of images, tables, graphs, etc. Ideal Skills and Experience: - Proficiency in PDF and Word. - High attention to detail. - Excellent command of the English language. - Prior experience in book or similar document conversions. Please bid if you have the experience and skills to undertake this project.

I’m looking ...write a query or script. This task involves calculating the sum of items across three tables.. The complexity lies in filtering the said items between a certain date range and by a specific field value. Ideal Skills & Experience: • Proficient in writing SQL queries • Knowledge on MySQL, specifically on data manipulation among multiple tables • Excellent understanding of database design and principles • Problem solving ability to handle complex programming scenarios. Please note, I didn't provide the names of the fields to be summed in each table. So, the chosen freelancer will need to work with me and understand the complex structure of my database in order to pull this off. Therefore excellent communica...

I'm looking for a skilled individual who can create a pivot dashboard for my business. This dashboard needs to be updated daily and needs to include comprehensive sales data, material costs, labour costs, and profit and loss. Ideal Skills: - Data management - Ability to create and maintain pivot dashboards - An in-depth understanding of business financials. The main users of this dashboard will be the Management Team. Therefore, it needs to be designed in a user-friendly manner and should meet the needs of a strategic managerial perspective. The ultimate goal is to help us make more informed and data-driven decisions. Your expertise in data handling and visualization is much needed for this project. If you've c...

I am looking for an expert to automate my daily incremental SQL scripting to extract multiple tables from my ERP system, and export them to CSV files. Key Requirements: - The system in question is Progress/OpenEdge. - The extraction should include tables such as Customers, Orders, Products, General Ledger detail, Job Costs, Invoicing, and Budgets. - The script should be set to run on a daily basis. I need a freelancer who: - Has a strong grasp of Progress/OpenEdge. - Has experience with automated SQL scripting. - Can efficiently export data to CSV files.

*** NO PLACEHOLDERS - ONLY TRUE BIDS*** I'm in search of a skilled professional who can format a 6" x 9" paperback book. Here are some specifics regarding what I need: • Format my A4 manuscript into a 6" x 9" format. No cover design work. I want to get it ready for Amazon printing. This is a quick formatting job - I need attention to details, particularly with tables, index, and consistency throughout.

We require a specialist Excel developer ca...stock) - Distribute picklists to employees (Generate a picklist and have employees confirm Picking them) - Picked parts must be scanned out of inventory once employee picks qty - All picking will be archived on weekly basis to reduce worksheet size - Layout the worksheet to match our IR Scanning format - Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has to be LIVE) - Add a dashboard for visual view of KPI's and results The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored. Knowledge needed. - Excel Formula Mastery - Pivots ...

...experienced and efficient architect or planner who can design a well-researched, detailed plan for a hotel complex dedicated to both adult and child activities. The main focus is on children's activities, however, the exterior facilities should also accommodate adults. The project includes 3 stages and please quote them as follows: a. research and documentation of all areas, elements, playgrounds, sport fields, etc. - mood board for each area with reference pictures and details about size, dimensions and features. b. 2D master plan of all areas (black and white with dimensions and coloured without dimension) (*we have a total area of approximately 107.000 sqm with buildings included that are not more of 10.000 sqm) c....

I'm looking for a talented developer with experience in HTML and inline CSS. I have two pages of text content in PDF and Word format which need to be artfully converted to HTML for email distribution. The critical specifications for this project are: - Efficient use of HTML tables to structure content - Inline CSS for styling to maintain presentation across various email platforms - No need for responsive design due to the email context

...Design should be modern and trendy, reflecting our brand's innovative image. - The size of the booth is 21.3x16.4 ft, hence the design should be suitable for this scale. - We want to step up onto our stand. Have wooden / hard flooring (no carpet), low tables and chairs, a reception desk. A kitchenette area with a fridge, coffee machine and storage for coats and bags. We would like our logo to be large and visible across the top of our stand. Due to our location, we are unable to have anything high over our stand as it had a low ceiling above our space. Ideal Skills: - Prior experience in designing trade show booths, particularly modern designs. - Proficiency in design software to create detailed visual representations of the booth. - Goo...

I'm looking for an experienced freelancer to convert a Google document into a Word document. The Google document may contain a variety of elements such as font styles and sizes, bulleted or numbered lists, and tables. Ideal Skills and Experience: - Proficiency in Google Docs and Microsoft Word - Experience in document formatting and conversion - Attention to detail in maintaining the original document's formatting I anticipate a quick turnaround for this project.

The target of this project is the organization of content tables, figures, and tables. In addition, rewriting and editing the manuscript should be done to improve the information and language. rAs a plus, replying to the suggestions and remarks that will be made.

...projects, each with potential for future expansion depending on client satisfaction and ongoing evaluations. Project 1: Integration and API Development This project involves creating a synchronized customer table accessible via both web and mobile applications, and developing and integrating APIs. We also need to enable the functionality to preview and download existing quotes via the web and mobile applications. Additionally, assisting the client in installing the latest version on their local host to facilitate their participation in the testing process. Project 2: Software Enhancement and Bug Resolution Our second project is a comprehensive web-based software developed using HTML, Bootstrap, PHP, Laravel, and MySQL. We ...

Seeking a highly skilled Tikz and Latex programmer to create a variety of graphics and tables for my research paper. Types of Graphics: The project will require the creation of: - Diagrams - Plots - 3D Representations - Tables Role of Graphics: The graphics and tables produced will serve to: - Illustrictate complex concepts - Visualize data - Compare and contrast research results Required Skills: The ideal candidate for this project should be proficient in: - Tikz - Latex Your contribution will play a crucial role in enhancing the visual appeal and readability of my research paper. Prior experience in similar projects would be advantageous. Let's make science more understandable and engaging!

...all database tables. This project will involve implementing advanced features such as column selection, filtering, sorting, pagination, and complex table relationships like aggregations and master-detail references. Core Requirements: 1. API Framework: The API should be developed using .NET 8. I am open to using either OData or GraphQL for the API architecture, depending on what the developer finds most suitable for the project requirements. Alternative suggestions are welcome for discussion. 2. Generic Controller: The API should feature a single, generic controller that can dynamically handle all tables within the database. This approach requires sophisticated coding to manage CRUD operations generically across all tables. 3. Metadata-Driven Archite...

I'm looking for a skilled web developer who ...can create a top-notch website for my pizzeria, Napoletana. The website should ideally be a reflection of our brand, incorporating a red and white color scheme into the design. Key Features to Include: - An efficient online ordering system for a seamless customer experience - A section for our menu, complete with prices and detailed descriptions - A straightforward reservation system for customers to book tables with ease In terms of visuals, we have images that we'd like to use for the website. Hence, an ability to incorporate these into the design tastefully is crucial. The ideal candidate should have experience in building restaurant websites and an understanding of user interface to provide an eas...

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I am seeking an individual proficient in converting PDF files into editable Word documents with a specific focus on maintaining table formats. Key Tasks: 1. Convert multiple PDF files to Word documents. 2. Accurately transfer tables from PDFs to Word, ensuring the original formatting is maintained. Ideal Candidate: - Experienced in PDF to Word conversion - Detail oriented with strong formatting skills - Previous work successfully converting tables from PDFs to Word.

I'm looking for help in combining multiple Excel slicers into one for our data analysis needs. Th...for multiple data. Detailed description is as follows: I have a accounting sheet. Where in one separate sheet I have captured Incomes along with the date and amount and other sheet I have put Expenses along with Date and amount. Now in summary sheet I am using Income pivot table, where I am using Slicer on Date (Merged for Months and Years). I want the same slicer to be used for Expense pivots as well. The ideal freelancer for this job should be proficient in: - Excel - Slicers and PivotTables - User experience design - Data analysis techniques Your input and expertise in this project can help streamline our data manipulation proce...

CRUD 2 tables only. Long term project.

I'm experiencing performance issues within m...experiencing performance issues within my IoT-based platform, mostly coming from slow query response times, excessive storage consumption, and challenges with insert operations after compression. I'm looking for an experienced TimescaleDB expert to optimize this. - Optimize slow query response time - Reduce excessive storage consumption - Fix insert operations after compression The ideal freelancer for this project is someone who has extensive experience in TimescaleDB, particularly in query optimization and compression features. Unfortunately, I'm unable to provide the number of tables in the platform, but I need someone who is capable of handling extensive data and complex structures. If you�...

I am in need of a professional who can help provide insights into a dataset using Excel's pivot charts, tables, and dashboard. The area of the data is unspecified as of now, but a strong candidate would be adaptable and skilled across domains. Key responsibilities will include: - Data Visualization - Creating Pivot Charts - Building Tables - Preparing a Dashboard Note: This project is basic-level work and my budget is 10 not more than that I already checked price comparisons with different freelancing platforms. if anyone works in that price range only the person make bids does not waste time.

I'm currently seeking an Oracle SQL developer with exceptional proficiency in cre...seeking an Oracle SQL developer with exceptional proficiency in creating logics. This task requires: - Writing an SQL code for data extraction purposes. - The code needs to be written as quickly as possible, with a time frame of 1-2 hours. - The solution should deal with the joining of multiple tables and creating doing some further order by, group by codes Decent knowledge of Oracle and experience in handling similar tasks would be ideal for success in this project. Your ability to deliver accurately and timely will be greatly valued. The code should be written using simple statements. I am not sure how to set up a connection to our datapool though. I can show couple ...

I am looking for a freelancer who is proficient in data entry and familiar with Excel to assist in the digitization of a 276-page vintage parts manual. Your task would be to: - Accurately copy the information from pdf to Excel. This includes part numbers, the description of parts, and all other columns present in the original tables in the document. - Organize the spreadsheet such that each section of the document is represented by a separate worksheet. No specific data validation rules or cell formatting are required, but the data must be accurate and searchable in Excel. This job requires someone with a keen eye for detail and a good understanding of Microsoft Excel. Prior experience in similar data entry tasks would be a significant advantage. A sa...

I'm in need of a Python expert who can meticulously extract text and tables from PDFs for data analysis. The requirements are as follows: - Develop a Python solution in form of a Jupyter Notebook - Preferable use of the libraries PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber for extraction Required Skills and Experience: - Proficient in Python - Familiarity with Jupyter Notebook - Experience with PyPDF2, Tabula, PDFMiner, PyMuPDF, and PDFPlumber - Data extraction and analysis expertise. Your commitments would include understanding the architecture of the PDFs, and the most effective library for extraction in each case. The ultimate goal is to create a Python script that eases the data extraction process for subsequent analysi...

I'm looking for an experienced editor to assist with my word document, which is notes to financial statements. - Specific tasks include formatting changes, specifically around tables and sections, and content revisions that ensure the document reflects the current financial standards. - The ideal candidate will have a strong understanding of financial statements and the ability to accurately reflect this in written form. I'm looking for someone who can make these changes swiftly and with a high level of accuracy. Please indicate your experience with similar projects in your bid.

...extracted from handwritten notes. This project entails meticulously transferring this data into a specifically structured format such as tables or lists. Key responsibilities include: - Accurate transcription of handwritten notes into digital format. - Organizing the data into tables or lists, maintaining coherence and clarity. Ideal skills for this project: - Excellent typing skills with high accuracy. - Proficient in the use of Microsoft Excel or Google Sheets. - Attention to detail is critical due to the nature of handwritten sources. - Experience in data entry from handwritten notes is preferable. Your main task will be taking the handwritten notes provided and diligently converting them into a designated structured format. I look forward to workin...

I'm seeking a Wedding Videographer proficient in capturing high standard, smartphone style videos of a wedding. Your focus should be: - Nailing the unique smartphone aesthetic while maintaining the quality - Primarily capturing celebratory dancing and showcasing the products placed on the tables Ideal candidates come with experience in unique videography styles and an eye for detail. A clear understanding of lighting and ability to work under event conditions is appreciated. Please share your portfolio links in your bid.

...skilled developer to create an architectural floor plan module for my online property management platform. The module should allow users to zoom in and out, navigate to specific units, and edit floor plans. Key Requirements: - Zooming & Navigating: The module should facilitate smooth, intuitive zooming in and out of the floor plan, as well as the ability to navigate to specific units. - Editing Tools: Users should be able to make alterations to the floor plan. This includes adding and deleting elements like floor sections, walls, tables, chairs, windows, and doors. They should also be able to draw shapes and add text labels. And resize, rotate and move all object. Ideal Skills & Experience: - Proficiency in HTML5 c...

I'm looking for an experienced Laravel developer to help with some modifications to a Chatify Laravel Chat project. The existing functionality of the chat app needs to be customized. Specifically, I need the login functionality to be adapted. This includes creating separate tables for user and admin chats, and developing a separate login page for each type of user. I'm looking for a skilled developer who can customize the Chatify platform to support two separate tables for Users and Admin to login and chat between each other. This is the source code

I'm looking for someone who can convert my handwritten sheets into an Excel spreadsheet. - Purpose: This is purely a data entry task. I don't need any ana...convert my handwritten sheets into an Excel spreadsheet. - Purpose: This is purely a data entry task. I don't need any analysis on the data, just a simple data entry from the sheets to Excel. - Detailed Formatting: I only require basic formatting. This means simple lists or tables, no need for any formulas, data sorting, or complex formatting. Please note: I will provide physical copies of the sheets to be converted. Ideal skills and experience: - Proficiency in data entry, specifically using Excel - Attention to detail and accuracy - Ability to follow clear instructions - Previous experience ...

...facilitate the engaging experience of the app on both iOS and Android. Key Requirements: - Design should be created using Figma - Platforms: Design should be optimized for both iOS and Android NOTE: I will not provide any Sketch/UI designs - the requirement will be in the form text only. When bidding provide the cost per screen. Your responsibilities would include: - Creating a design using Figma, Field details will be given as tables/text/para. - Designing intuitive UI elements - Ensuring the design is suitable and optimized for both iOS and Android. - will provide a reference theme - Need to provide 4 sample themes before we start the work - Ideal skills and experience for this project would include: - Proficiency in Figma and ...

I am in need of a skilled Excel expert capable of understanding and applying advanced conditional formatting. The project entails: - Data analysis related tasks - Comprehensive use of both pivot tables and Excel formulas/functions - The main focus will be on setting conditional formatting based on both cell values and any contained text Here’s what you’ll need to do specifically: - Configure Excel to change the text color if certain conditions, related to cell value or text, are met - Set Excel to change the background color under the same conditions Ideal skills for this job would include: - Previous work with complex Excel functions and data analysis - Hands-on experience with conditional formatting - Detail-oriented approach to...

As I work to organize my impending exam schedule, I find myself needing assistance with expanding the current table. I have a standard, portable table, representing my schedule, which presently has le...expanding the current table. I have a standard, portable table, representing my schedule, which presently has less than 10 rows. I'm seeking help in modifying it by adding less than 10 more rows while maintaining its format. Here's what I require from you: * Experience in organizing and editing tables * Ability to discern formats and replicate them consistently * Capability to add rows as per requirements * Knowledge of moving text up and down the page Your task will entail the careful insertion of new rows and subsequent data filling. Your at...

...designed for training purposes and does not require confidentiality agreements. The mentor should have a strong understanding of architecture and interactions between different modules in a complex multiplayer project. Budget: 90 euros per month, fixed payment. Session Frequency: The candidate can suggest the number of hours they are willing to invest within this budget, providing flexibility to encourage a competitive environment and cost-effectiveness. Objective: To develop advanced MERN stack skills with a focus on creating a multi-table casino poker platform. Required Skills: Strong experience with the MERN stack (MongoDB, , React.js, Node.js). Background in building complex multiplayer applications, particularly those with multiple tables and tou...

As a 3D artist, I am seeking assistance to bring an AutoCAD plan into life using 3D Max. This project entails simple, primitive method furniture modeling including: - Chairs - Tables - Sofas The plan is for a small house of less than 1000 square feet. No rendering required, the purpose of this project is purely for 3D Max modeling and visualizing the design. Proficiency in AutoCAD, furniture modeling, and attention to detailed measurements are essential for this project.

...hair wig. This project involves creating a 3D model that looks natural and realistic, ensuring the wig's texture and color offers a sense of genuineness. Objectives: Model Design: Design a 3D model of a wig that looks natural and realistic. The wig should have a natural hair texture, color, and style that can be adjusted if necessary. Format: The model should be exported in .obj format, which is compatible with our existing ARCore-based application, aslo the z-axis protrusion must be hollow, to enable a see through view when looked from +z-axis Optimization: The model must be optimized for real-time performance on mobile devices. This includes a low polygon count while maintaining a high level of detail in texture and form. Texturing: Detaile...

I need a reliable freelancer...document to fully preserve the original PDF's formatting including fonts, colors, and layout. - The original PDF is a typed copy, not handwritten or scanned. - The final Word document should contain a clear and usable table of contents based on the original PDF content. Ideal Skills and Experience: - Demonstrable experience in accurately converting PDFs to Word, specifically maintaining the original formatting. - Proficiency in using Microsoft Word and its formatting tools. - Familiarity with creating and structuring tables of contents in Word. Please provide a brief overview of your experience with similar projects when bidding. I'm looking for a reliable freelancer with a strong attention to detail ...

...of text, tables, charts, and images that need to be converted into Excel and Word formats. The key requirements are: - The data in the photo must be completely editable in both Excel and Word. This includes all text, tables, charts, and images. - The photo contains a mix of content, including text, tables, charts, and images. It's important that the freelancer is able to accurately capture and translate all of this information into the Excel and Word formats. Ideal skills and experience for this job include: - Proficiency in data entry and extraction. - Advanced skills in using Microsoft Excel and Word. - Experience in handling mixed content (text, tables, charts, images), and...