Combine two excel sheets based on common column jobs

...by creating some stunning and insightful graphs based on my company's stock data. Here's what I need: - Create a scatter plot of the highest stock price (in the column labeled "High") against time. Write several sentences explaining the process/steps. -Create a scatter plot of the lowest stock price (in the column labeled "Low") against time. Write several sentences explaining the process/steps. -Create a histogram of the adjusted daily closing stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by which you created this graph. -Create a histogram of the sto...

Please Sign Up or Login to see details.

I need a skilled React and React Native developer to prioritize on web application development. Web App (React & Ant Design): Login/Register Page: User authentication and registration. Landing Page: Welcome page post-login. Create Record Page: Form to create a new record. Read Details of the Record Page: Display details of a specific record. Mobile App (React Native): Login/Register Page: User authentication and registration. Landing Page: Welcome page post-login. Read Details Page: Display details of a specific record (No create record page required). Additional Details: Figma designs will be provided. Clean and maintainable code is a must. Adherence to best practices in both React and React Native development. Requirements: Proficiency in React, Ant Design, and React Nat...

...in need of a skilled automation specialist to help me streamline and optimize a multi-step process that involves audio analysis and documentation. Key Responsibilities: - Develop a solution (on ) that initiates from an audio file recording and proceeds to: - Audio-to-text conversion using Google Cloud Speech-to-Text - Running the transcript through ChatGPT for analysis - Summarizing the outcome in Google Docs - Maintaining a daily list of patients' names in a Google Sheet Key Objectives: - The primary goal of this automation is to enhance productivity, allowing staff to focus on more intricate tasks. - All stages of this process need to be fully automated. Additional Details: - The daily list of patients' names will be created by the dentist, ...

I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus

footer lacks creativity, and our website has some CSS issues. I'm hoping you can fix it.

Seeking a Los Angeles based social media manager who specializes in content creation (reels). Main Responsibilities: Develop and implement user-engagement posts on Instagram for one month ( no more than 2 posts per week) Ideal Skills: - Proven experience with Instagram platform - Solid understanding of demographic preferences of mature professionals - Creativity and effective communication skills - Demonstrated ability to create engaging content that sparks conversations Your expertise will play a significant role in raising awareness about our brand and establishing a stronger connection with our audience. Please bid if you are interested in bringing ideas and strategies to life and have proven success engaging this demographic on Instagram. You will be responsib...

I will rewrite two blog posts as soon as possible.

I'm looking for a reliable individual based in Tokyo who can collect and send a medium-sized (1-5kg), non-fragile item to Australia. Key Responsibilities Include: - Pick-up item from a specified location in Tokyo - Secure item with protective wrapping - Dispatch to an address in Australia Ideal Candidate: - Must be based in Tokyo - Strong attention to detail, particularly regarding packaging and shipping procedures - Reliable and swift communication - Previous experience in courier services or shipping-related tasks would be beneficial.

...developer to integrate the Single Sign-On (SSO) functionality with my ASP-based website. This is a time-sensitive project, and I need it completed within a month. Key Requirements: - Integrate Single Sign-On: You'll need to implement an SSO solution that allows users to log in to other web sites after logging into my website. When they log into my site they are directed to a dashboard. The dashboard has links to 3rd party websites we work with. Currently the users have to log onto each site when they click a link. I want them to log in once (my site), then click on any link(s) they want to. - ASP Knowledge: You should be familiar with ASP as the primary programming language or framework the website is built with. Ideal Skills and Experience: - Single ...

I am in need of an experienced software developer who can create a Windows-based kiosk application to facilitate student registrations, check-ins, and attendance tracking in a learning school. This will be a user-friendly, touchscreen-based solution, with no requirement for integration with existing systems or databases. Key Features: - Student Registration: The application should allow for the quick and easy registration of new students. - Student Check-In: A reliable and efficient check-in system for students. - Attendance Tracking: Real-time attendance monitoring and tracking. Key Requirements: - Proficiency in Windows-based application development. - Experience in creating user-friendly and touchscreen-compatible interfaces. - Prior experience with kiosk applica...

I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.

I'm in need of a professional who can transform my existing plans into a detailed HMO layout. This task involves creating comprehensive floor plans, incorporating both provided specifications and your own...incorporating both provided specifications and your own recommendations. Key Responsibilities: - Translate the existing plans into an HMO layout - Suggest and incorporate furniture and fixtures - Ensure the layout is detailed and accurate - Combine provided specifications with your own recommendations Ideal Skills and Experience: - Proficient in floor plan creation - Experience in designing HMO layouts - Able to accurately interpret specifications - Good eye for detail, with a focus on accuracy - Strong communication skills, particularly in providing recommendations...

I'm looking for a skilled professional to enhance the checkout process on my WooCommerce site with the goal of reducing cart abandonment. The site is also experiencing slow page loading or technical issues during the checkout process, which need to be identified and resolved. The site's speed needs to be improved to enhance the overall user experience. I'm looking for someone who is an expert in enhancing e-commerce conversions by increasing add to carts and reducing buyer drop offs and cart abandonment. Key Areas: 1. **Cart Abandonment:** - The common reasons for cart abandonment on my site is a long and complicated checkout process. Also, we want to address the reason why users are not adding to cart, and reducing our cart abandonment and increas...

I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able ...

I am seeking a skilled Swift iOS developer who can create an innovative, user-friendly application for managing driving routes via GIS .shp files. Key Features: 1. Import GIS .shp files and convert them into driving routes. 2. Incorporate a web portal feature to assign and track drivers. 3. Real-time updates on the progress of each route. The ideal freelancer for this project should have experience with Swift, iOS development, .shp file manipulation, and incorporating real-time updates into an app. The app also needs a mobile version for drivers to access their routes; therefore, experience with mobile app development is also desired. More specifications will be provided upon selection. Looking forward to a fruitful partnership.

...skilled developer who can help me resolve a recurring issue with my React Native application. Although I don't have specifics on when the app crashes or the specific actions that trigger the issue, the app is currently unstable and crashes periodically. Your main task will be to identify, locate, and resolve the source of this instability. This could involve a range of potential issues from memory leaks, state management problems, race conditions, to others. The ideal candidate should have: - extensive experience in debugging React Native applications, - be familiar with the common culprits of app crashes and how to mitigate them, - be able to work independently based on the problem description provided. If you have successfully resolved similar...

I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.

Key Features: - Online Booking: Parents should be able to make, alter, and cancel their bookings with ease.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample

I'm in need of an Appy Pie expert to build an e-commerce website for me. The website will only have less than 50 products, so it's not a large scale project. I have paid Appie Pie full subscription to use their platform Key Requirements: - Build an E-commerce website on Appy Pie platform - Implement payment gateways: PayPal, Stripe, Credit/Debit Cards - Ensure smooth user experience for shopping Ideal Skills: - Proficient in Appy Pie platform Skills - E-commerce website development experience - Strong knowledge of integrating payment gateways - User experience and design sensibility I'm looking for a skilled professional who can bring my vision to life efficiently and effectively. Please provide relevant samples of your previous work and an estimated timeline for...

I need two outdoor cooking tables based on the document specs provided. I am looking for scaled, cad drawings that can be given to the custom carpenters

Will give u layout to design the packaging.

I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines

I'm looking to build a robust web-based color prediction application with additional features crucial to its success. This includes a user registration/login system, real-time data analytics, and payment gateway integration. The app will also require seamless integration with specific game APIs such as live casino, betting, and potentially others. Key Requirements: - Development of a web-based color prediction application - Implementation of user registration/login system - Integration of real-time data analytics - Seamless payment gateway integration - Integration with live casino and betting game APIs - Potential for additional API integrations Ideal Skills: - Web development expertise (React.js, Node.js, etc.) - Strong experience with real-time data analytics - Pro...

I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.

I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all informati...

Note : my budget not more 10$ for whole project Create AI web app on bubble io **Game Objective:** The goal is to create a web-based multiplayer game where each player receives secret tasks from an AI. These tasks must be completed to progress towards a common goal. The game is dynamic, with scenarios and tasks changing based on player actions. **Step-by-Step Process:** 1. **Player Registration and Friend Network:** - Players sign up and add friends within the game to form a network. - Each player is assigned a unique identifier for tracking purposes. 2. **Hidden Scenario Generation:** - At the beginning of each game session, the AI generates a hidden scenario that sets the context for the tasks. - This scenario is not directly reveale...

**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and t...

I'm looking to create a comprehensive web-based accounting software with essential features that will allow me to manage my finances, track inventory, generate GST reports, and handle billing. This software should also support up to 5 users. Key Features Needed: - Financial Management: The software should offer robust financial management functionalities to help me track and manage my finances effectively. - Inventory Management: A sophisticated inventory management system is required which involves product categorization, stock monitoring, and purchase order tracking. - GST Reporting: The software should have the capability to generate accurate GST reports in compliance with the relevant regulations. - Billing Features: I would require the software to support invoicing, payme...

I'm in need of a PowerBi expert to resolve a critical error for me. The error message reads: "Failed to save modifications to the server. The error returned: 'Relationship '59f250b2-ca16-47f4-8a50-ba4d8636a1ed' points to deleted column 'Setter 2' in table 'Bridge of Setter'." - Urgency: The task should be completed within 24 hours. - Documentation: I don't need any documentation on how the issue is resolved, just the solution itself. - Dataset Access: Unfortunately, I can't provide access to the original dataset. The expert will need to resolve the issue without it. Skills and experience required: - Proficient in PowerBI with experience in resolving server-related errors. - Ability to work under tight deadlines and...

I need an expert to design an effective Business plan offering memorandum ...investors and aim to provide a clear understanding of our business model and financial health. Key Requirements - Business plan -Vacation rental industry not a must - Proven experience in drafting offering memorandums and business plans, preferably within the real estate sector. - Strong understanding of financial data presentation, particularly income statements, cash flow statements, and balance sheets. - Ability to design a document that is engaging and convincing to potential investors. The perfect candidate will demonstrate impeccable attention to detail, a solid understanding of the real estate and investment sector, and experience in financial document preparation. I look forward to receiving ...

Create a Google Sheets system for managing alcohol inventory. Includes columns for Brand, Name, Number of bottles, Country, Rating. Dropdown for rating (1-10). Show stats: unique bottles, total bottles, countries. whit a front page where i can insert the above items, and get under a reading of stats.

I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not on...

...physical products. I'm looking to have the shipping costs calculated based on the distance to the delivery address, using postal/ZIP codes as the metric. Key Requirements: - WooCommerce Setup: Need someone who is well-versed in setting up eCommerce stores with WooCommerce. - Shipping Configuration: Experience in configuring shipping settings within WooCommerce, particularly for distance-based calculations. - Geolocation Skills: Proficiency in working with postal/ZIP codes to determine distances for shipping cost calculation. - Problem-Solving: Ability to troubleshoot and resolve any potential issues that may arise during the project. Your primary task will involve implementing a system that accurately calculates shipping costs based on the dista...

I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.

I have a 120MB JSON file with nested objects, and I am in need of a ski...have a 120MB JSON file with nested objects, and I am in need of a skilled professional who can convert this data into a CSV format. Specifically, I require the following: - The nested JSON objects should be flattened into single columns in the CSV. - The column headers in the CSV should match the keys in the JSON file. The ideal candidate for this job should have: - Proficiency in handling JSON and CSV data structures. - Experience in working with nested JSON objects and flattening them. - Ability to accurately map JSON keys to CSV column headers. If you've successfully converted complex JSON files into CSVs before and you're confident in your ability to deliver clean, well-structured data,...

I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attenti...

I'm in need of a talented game developer to create a mobile game for both iOS and Android, in the grinding genre. I will provide map converters and all necessary assets for the game. Key Features: - Multiplayer Functionality: The game should have the capability for players to interact with each other in-game. - Leaderboards: Implement a system for players to compare their achievements and progress. - In-app Purchases: Include a functioning in-game store where players can purchase virtual goods. As the project is mainly about implementing the provided mechanics, I'm looking for someone with experience in online game development, particularly in the mobile sector. In addition, knowledge of grinding game mechanics will be helpful. An ideal candidate would have experience with imp...

The most emblematic activities to do. The popup login action will be added to the header and from the home page button. Next buttons will also be hidden in lessons.

I am running a Docker container on my local Linux machine. Recently, I made some network settings modifications and since then, the container is not restarting. When I attempt to restart it through Portainer, I am getting a 404 error. Key tasks include: - Investigating the network settings I've made and how they might be stopping the container from restarting. - Resolving the 404 error in Portainer so I can restart the container without issue. - Providing a brief explanation of what went wrong and how it was fixed, for my own understanding. Ideal candidates should have: - Proficiency in Docker, particularly managing containers and network settings. - Familiarity with Portainer, able to diagnose and fix common errors. - Strong troubleshooting abilities to understand and...

...ensuring our standards are met. - Logistics Coordination: You'll be responsible for coordinating the smooth transport of goods from China to other countries. - Dealing with manufacturer: you will be the link between the fabricant and us, so we will need a bilingual person (English and Chinese). - Fabricant Sourcing: You should be able to help us find a fabricant that can make small alterations to common garments. Customization: - The level of customization we require for the garments falls under the 'Medium' category, including printing, color changes or adding small accesories like buttons. Ideal Candidate: - Knowledge in quality control and logistics. - Previous experience in casual clothing or a related field is preferred. - Strong network and ability to sour...

I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report...

I am in need of an Articulate Storyline expert to create an exciting, interactive game-based learning module targeted at adults. Requirements: - The module should have a moderate level of interactivity, including quizzes and drag-and-drop elements - The content must be engaging and challenging for adult learners, it should be both informative and entertaining - Attention to detail is crucial, the module should flow well and be free from technical errors - You are encouraged to bring creativity and originality to the project, it should not be a standard, uninspired e-learning module Ideal Skills: - Expertise in Articulate Storyline is paramount - Experience in developing game-based learning modules is a major plus - Understanding of adult learning principles and ...

I'm seeking a savvy developer to create a 1D barcode (UPC, EAN) inventory management system. This should then be integrated with an existing product management system. Key requirements: - Design and develop a user-friendly barcode inventory control system - Experience with 1D barcodes, preferably UPC and EAN - Capability to integrate with existing product management software The main users of this system will be store staff members. Therefore, it should be easy to navigate, and seamless in functionality to support a fast-paced retail environment. Expected expertise: - Proven experience in building similar inventory management systems - Proficiency in working with 1D barcode technology - Expertise in software integration - Solid understanding of user interface for non-technical ...

...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Exce...

I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and meticulousness a...

I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.

I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.

I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample