How to compare two columns in different excel sheets jobs

I'm in need of an Excel expert to assist in creating advanced statistical or financial functions. Your job will be to help me with these complex Excel tasks and generate charts or graphs as the final output. Key Requirements: - Deep understanding of Advanced statistical or financial functions in Excel. - Ability to generate visual representations through charts or graphs. Your role would entail: - Collaborating with me to understand the data and the desired outcomes. - Leveraging your expertise to implement the appropriate statistical or financial functions within Excel. - Presenting the results in a visually compelling manner through the creation of charts or graphs. Please share your rel...

...I am new to react. If I click open panel a panel opens. if I drag the item from the panel to column2 it should add to the table and simulataneously it should add to column 1. same way if I add to column 1 it should add to column 2 table two. I am able to achieve for column 1 but not inside column 2 table. can you lee me know how to fix it. Providing my code and fiddle link below. ,src%,src%2FApp.jsx&terminal=dev import { useState } from 'react'; import reactLogo from './assets/'; import viteLogo from '/'; import './'; import { DragDropContext, Droppable, Draggable } from 'react-beautiful-dnd'; function App() { const [panelOpen, setPanelOpen] = useState(false);...

Description: I need an app (iOS) to automate data entry into a Google Spreadsheet used for my car rental business. Each tab in the spreadsheet represents a specific car. The app should allow employees to: Select a car category (corresponding to a tab in the spreadsheet). Select a rental date. Input various amounts (e.g., rental income, expenses). Automatically update the corresponding tab in the Google Sheet with the provided data. Requirements: Experience with Python and Google Sheets API. Ability to create a user-friendly interface. Strong understanding of gspread and oauth2client libraries. Good communication skills and responsiveness. Deliverables: A functional app that performs the required operations. Documentation on how...

I have a requirement for someone well versed in Excel formulas and calculations, specifically with respect to tracking approaching dates. The main objective is to monitor upcoming deadlines. Ideal candidates should have: - Proficiency in Excel calculations and conditional formatting - Expertise in implementing algorithms to track deadlines - Strong attention to detail - Previous experience in project tracking or similar Your role would involve setting up the necessary formulas and conditional formatting to efficiently track these dates. Understanding the importance and urgency of deadlines, your input would greatly assist in managing our tasks better.

I'm experiencing...experiencing issues with an Excel file that shows as 'We found a problem with some content...' when trying to open it. The file is 99.7 MB, which may be the issue. File is mainly contact details, text and photos. I've tried Excel's 'Open and Repair' tools with no success. I am aiming to work with an Excel expert who can recover the data without loss, if possible. The freelancer should have: - Intensive experience with Excel - A deep understanding of Excel file structures and experience in fixing corrupted Excel files - Familiarity with various recovery methods beyond just 'Open and Repair' I am looking forward to saving my data with your expertise. Let's...

I'm looking for an Excel expert to repair my medium-sized spreadsheet which is currently corrupted and crashes upon trying to open. Key tasks include: - Diagnosing why the file is crashing upon opening - Recovering both crucial data and restoring the original structure The success of this project is crucial as there is vital information that needs to be salvaged from the corrupted Excel file. Ideal freelancer should have: - Extensive experience working with large Excel datasets - Proven ability to recover corrupted files - Strong attention to detail to ensure all data and structure is accurately restored

I'm in need of a Progressive Web Application (PWA) for collecting survey responses towards an onboarding process. The application will feature: - A mixed set of survey questions, including both multiple choice and open-ended questions. - Responses will be sent to a Google Sheet for easy management. - Integration with a payment gateway after the survey for users to proceed with payment. - Survey responses should not be anonymous. The ideal freelancer for this project should have experience in developing Progressive Web Applications (PWAs) and integrating them with Google Sheets and online payment gateways. They should also be able to implement a mixed survey layout and ensure that the survey responses are not anonymous.

I am seeking a proficient Photoshop artist to manipulate two images. They should excel in vintage editing, producing an image in a sepia tone. What I imagine is two faces, expertly swapped onto the bodies of vintage gold miners. Precision and creativity will be pivotal, as I want the faces to be partially blended, retaining some of their original quality but also integrating well with the miner bodies. Applicants should demonstrate prior experience in complex face swapping tasks. Candidates who have a portfolio of vintage image editing will be of particular interest. Need to provide image of gold miners. Use whichever of my photos that provide the best image.

excel assignment for an event study. template and example below

I'm in need of a professional accountant to handle my quarterly bookkeeping and financial statements. The ideal candidate should be well-versed in accounting principles and practices, have experience in bookkeeping and financial statement preparation. Familiarity with QuickBooks and Excel is crucial. Key responsibilities: - Perform quarterly bookkeeping tasks - Prepare accurate and timely financial statements - Maintain clear and organized financial records The successful freelancer will be consistent, detail-oriented, and able to meet deadlines. Experience with similar projects is a plus. Please provide your relevant experience along with your bid.

I'm in need of an expert who can fix a google script for me. This script connects with an external web service API that provides data and populates specific columns of a Google Sheet with the parsed JSON data. Lately, it has been throwing up an error: Address unavailable:(Code: 63:32). I haven't made any changes to the API or Google Sheet recently, so I am unsure as to why this is occurring. I would appreciate it if a proficient Google Scripts and API specialist could look into this matter and fix the issues that are leading to this error. Ideally, I am looking for someone who: - Is well-versed with Google scripts - Has a good understanding of APIs, especially ones related to external web services - Can troubleshoot errors effectively ...

Develop macro-enabled Excel workbook

Hi Viet Hung, I hope this message finds you well . Earlier this year you wrote me a google script to make a call from an api and import the json results on the google sheets. It was working great until recently . I keep getting the following error message: Error Exception: Address unavailable: at Search(Code:63:32) If I share the script with you , would you please be able to look at it and let me know how much it would be fix the issue ?

I'm in need of a detail-oriented freelancer to assist with data entry of numerical data. The details of the data, source, and number of fields or columns per entry are currently uncertain as the project is in preliminary stages. Key Responsibilities: - Enter numerical data accurately. - Be prepared to handle digital files or physical documents. Ideal Skills/Experience: - Proven track record in data entry. - Excellent attention to detail. - Capable of handling possible multiple data sources and fields. - Great organizational skills.

Need to be located in the NYC area. We are seeking a skilled individual to join our team on a contract basis as a Geofencing and Data Visualization Specialist. The ideal candidate will possess expertise in geofencing technology, data integration, visualization tools, and cloud platform automation. Responsibilities: 1. Geofenced Mapping: Utilize bulk Google Sheets data to create geofenced mapping solutions. Implement geofencing techniques to accurately map addresses and locations and precise boundary definitions for target areas. Includes visual enhancements for clustering data and map filtering. 2. Data Integration: Integrate web scraped data into geospatial existing datasets. Ensure seamless integration and compatibility with mapping and v...

Data Entry from Scanned Business Cards to Excel We are looking for a highly meticulous data entry specialist to transfer information from approximately 2400 scanned business cards into an Excel spreadsheet. === Data Points to Include for Each Card: 1. Name, Position, Company, Phone (include all numbers, Fax (if available) and correct country code, Emails, Websites, Social Media Links, Address, City, Country ,PO Box, category of company 2. AND Any other available information on the cards === Requirements: * High accuracy is crucial; entries will be checked for spelling and number accuracy. * The partner needs to speak English fluently and in writing as well. * Images will need to be renamed at the end of the project to m...

I'm looking for a skilled developer to create a comprehensive management platform for a restaurant and cafe. Some of the modules required but not limited to the followings: - [ ] Ecommerce - [ ] CRM an Loyalty System - [ ] VOIP ans SMS integration - [ ] Marketing campaign design - [ ] Mobile & Online Ordering - [ ] POS - [ ] product add-ons when taking orders - [ ] barcode scanners and mobile printers - [ ] customised print designs per store - [ ] multi-tenant - [ ] Table Service, reservation, pr-eorder, pre-payment - [ ] Delivery, In-Store pickup, integration to other delivery platforms - [ ] Staff Management, time sheets - [ ] Digital Menu Management, View the menu on mobile and make order and payment - [ ] Reporting & Anal...

Start with the word in the attachment. Start your offer with the word in the attachment. We are looking for a database with websites, HAVING EMBEDDED YOUTUBE Videos on their sites. Prepare a list with : Name of the company, youtube Link, PLZ, City, Phone, Mail, Website, Link @ impressum Niches: Fitness, Lifestyle, Wellness, fashion, sport article Area: German-speaking (Austria, Germany, Switzerland) I would like to have at least 2000 websites with top-quality data. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. To decide who is our partner and to see your understanding, please provide a sample with at least 10 data entries.

As an AI Engineer, I'm looking for a specialist to develop an AI system that is proficient in machine learning and computer vision. In particular, I need the system to excel in image recognition and data analysis. Ideal Skills: - Proficiency in machine learning and computer vision - Extensive experience with image recognition and data analysis - Skilled in Python, TensorFlow, and PyTorch The AI Engineer must also have a solid understanding of the Python programming language, as well as experience working with TensorFlow and PyTorch frameworks. The ideal candidate will be able to demonstrate a strong track record in developing and implementing AI systems that can successfully perform image recognition and data an...

...research task to be undertaken for a list of 8,000 businesses across a region of the UK. I am looking for specific data points, such as: - Names of Managing Directors - Their respective phone numbers & email addresses - Best postal addresses and phone numbers of the companies - General business email address - Number of employees the companies have - Notes to be provided if no data The chosen Freelancer should have prior experience in accurate data collation and verification and be well-versed with up-to-date UK business registries or databases which must include the businesses website and LinkedIn. A keen attention to detail is necessary, as I require accurate, reliable data. Prior knowledge of UK businesses, particularly management hierarchy, w...

I am in need of a skilled professional who can provide the following accounting services using Excel: - Preparation of Financial statements - Cash flow analysis - Financial statements analysis You will be ideally proficient in Excel-based financial modeling and analysis, understanding how to manipulate and interpret data to present clear, concise, and informative reports. A solid background in accounting will ensure accuracy in financial statement preparation and analysis. Your ability to meet deadlines with minimal supervision will be a crucial factor for success. Existing familiarity with my current accounting software, Excel, is mandatory. A background in business finance or related fields and demo...

I need an expert who can implement a protocol for sending the saved logged data files (about 200MB, on SD card, in .txt format) over two ESP8266s without connection to the internet in the shortest possible time. It is better if the protocol is FTP, but others are accepted, too.

...forged. Key Requirements: - Authenticate Signature: The primary objective is to prove the signature on the check is not mine. This involves comparing the signature on the check with my genuine ones. - Legal Context: Experience or understanding of fraud investigations and court procedures would be beneficial as this is related to a legal charge. Your Approach: - Signature Analysis: I would need you to compare the signature on the check with my genuine signatures to provide me with definitive proof that it's not mine. - Documentation: It's essential that you can provide a clear and detailed report on your findings, suitable for legal purposes. Ideal Skills and Experience: - Forensic Document Examiner: Experience in this area would be ...

I need a skilled web developer to duplicate 785 WordPress pages within 1 hour. The project involves customization of the URL and page title to align with specific city names provided in an Excel sheet. Key Requirements: - Duplicate 785 WordPress pages quickly and accurately - Customize the URL and title of each page according to its respective city - Ensure that the formatting and layout of the duplicated pages remain consistent with the original - Provide a high level of detail and accuracy to maintain the integrity of the multi-location business promotion strategy Ideal Skills and Experience: - Proficiency in WordPress and web development - Ability to work quickly and accurately under time constraints - Strong attention to ...

...competent developer to construct an AI-powered chatbot for my WordPress website. This project requires a colorful and creative design that can effectively balance its vibrant nature with its functions. This chatbot should excel in: - Customer support: Ability to resolve queries, troubleshoot, and provide live assistance to customers. - Lead generation: Capability to initiate conversations and attract potential customers. - Appointment scheduling: Seamless calendar synchronization for hassle-free appointment bookings. - Marketing & Promotion: Efficient in promoting services or products, generating interest, and ushering in sales. - Order Exchange & Processing: Capability to handle orders, process them and ensure sm...

...competent developer to construct an AI-powered chatbot for my WordPress website. This project requires a colorful and creative design that can effectively balance its vibrant nature with its functions. This chatbot should excel in: - Customer support: Ability to resolve queries, troubleshoot, and provide live assistance to customers. - Lead generation: Capability to initiate conversations and attract potential customers. - Appointment scheduling: Seamless calendar synchronization for hassle-free appointment bookings. - Marketing & Promotion: Efficient in promoting services or products, generating interest, and ushering in sales. - Order Exchange & Processing: Capability to handle orders, process them and e...

As an organization, w...an experienced Data Analytics & MIS Executive to handle critical tasks in the realm of data analysis and MIS. Key Responsibilities: - Conduct in-depth data analysis - Generate regular and ad-hoc reports - Optimize our data systems Skills & Experience Required: - Proficiency in Excel - Proficiency in Power BI - Experience in working with sales data - Experience in working with customer data - Experience in working with EV Car booking data Your role will involve using your analytical skills to interpret complex data and generate insightful reports. You'll also be responsible for ensuring that our systems are optimized for maximum efficiency. The ideal candidate for this role should ...

You will be required to Copy technical part number from PDFs to excel file. Most of the files have copy paste enabled. I have around 400 PDFs. The brief provided will be very precise and easy to follow. Its a long term project. Will have projects on monthly basis If you understand what we are looking for. A fairly simple project with easy guide to follow through

I have a pressing need to transfer a large quantity of image files. Key Requirements: - Data Transfer: You will be tasked with swiftly transferring a substantial number of image files. - Organization in Excel: Following the transfer, you should organize these images in an Excel document. While this is not a conventional method for handling images, it is a specific requirement for my project. Ideal Skills: - Proficient in Data Transfer: You need to be skilled in transferring data swiftly and accurately. - Excel Expertise: You should have experience in using Excel to organize and manage files. Timeframe: - I would prefer this project to be completed as soon as possible. Please only apply if yo...

I need a Excel macro that can scrape data from a https://www.ebay.com. The Excel macro should be set to run whenever want to update the data in my spreadsheet. Excel should have Product Name Product UPC Product SKU It will then go to find that Product I want excel macro - list with the number of watches/shoes for that item

...trouble with a runtime error in my ChatGPT Excel VBA script, specifically during data analysis. I need an experienced VBA developer to help me identify and resolve the issue. Key aspects of the project: - Debug a runtime error: The issue is occurring during the data analysis process. You'll need to identify the root cause of the error and implement a solution to ensure the script runs smoothly. Ideal skills and experience: - Proficient in Excel VBA: You should have a strong command of Excel VBA, particularly in handling data analysis tasks. - Debugging experience: Prior experience in identifying and resolving runtime errors in VBA is essential. - Familiarity with ChatGPT integration: While not manda...

...assistance in resolving. These are: - My data is not updating as expected - I am experiencing inconsistencies with the visualizations - My dashboard is not loading at all at times The primary data source giving trouble is Google Sheets. To rectify the situation, an expert is required to restore my confidence that my dashboard will operate as expected. Moreover, it seems the tables of data specifically are not displaying correctly. This might entail performing checks, and implementing changes to the manner in which this particular format of visualization operates. Ideal Skills: - Proficient in Google Data Studio and Google Sheets - Experience in troubleshooting and resolving data visualization problems - Familiarity wi...

...skilled developer to construct a detailed and efficient web application that will manage the docking of vehicles based on set priorities in real-time. Here's a detailed breakdown of the project: - Programming Language: The web app is to be developed using JavaScript, so proficiency in this language is essential. - Real-Time Updates: Real-time updates are a crucial aspect of this project, meaning that the system should be able to allocate vehicles to docks swiftly and efficiently as priorities change. - Dock Management: The core function of the application is to manage the docking of vehicles based on the priority given for each against time (backend). This includes real-time adjustments as priorities change. - Google Sheets I...

Create a public dashboard from Looker Studio reading data from excel / google sheets.

I'm looking for a business writer to assist me with business report.. Please respond with your relevant experience in business writing. I am currently studying a Masters in Digital Marketing. Theres four parts to the assignment e.g. Conduct an accessibility and UX analysis on two top players in the fashion/merchandise industry, compare the results with the Google Merchandise Store. Do an analysis of their digital presence and competitive positioning. Analyse the GMS, etc.

ChatGPT is generating VBA to automate Excel data manipulation and other actions. As a VBA EXPERT, you will debug the code when it doesn’t do exactly what it was asked to. The project is being built module by module. There are about 6 modules.

I am in need of a comprehensive report on Corporate Finance Analysis focusing on the financial performance of Saudi Dairy and Foodstuff co. (SADAFCO). The report should be conducive to a word format, with a targeted length of approximately 20 pages. Instructions: 1. Deep dive on Saudi Dairy and Foodstuff co. (SADAFCO) 2. Data Collection: - Financial Reports: Obtain recent annual and quarterly financial reports from the company's official website or financial market databases. - Market Data: Use TADAWUL to gather historical price data. - Beta Value: Retrieve the company's beta from Yahoo Finance. - Risk-Free Rate: Search for current risk-free rate data applicable to Saudi Arabia (usually government bond yields). 3. Analysis Tasks: - Capi...

...Interior Design**: I need an expert in 3D interior design who can create realistic visualizations of the interior spaces planned for the house. The ideal freelancer for this role should have a good creative sense, experience in interior design, and proficiency in 3D modeling software. - proposal of finishes (parquet, wallpaper, furniture colors, proposal of types of lamps) - complete construction of the interior (walls, partitions) - distribution of furniture for each room - the exact determination of the types of interior carpentry - determining the exact types of glass partitions - complete tiling of the bathrooms with the selected type of tiles - positioning of sockets and switches - positioning of sanitary objects - **Structural Engineering Design**: I'm ...

I'm looking for an Excel expert to create a custom software for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Exp...

I am seeking an experienced architect/designer to create a plan for a granny flat that primarily focuses on accommodating a family member. The design requirements are as follows: - The granny flat should encompass two bedrooms. - The design must be clearly grounded in traditional aesthetics. - I expect the layout to maximize space and seek to build a warm, inviting environment. Ideally, you have prior experience in residential, specifically granny flat, designs. A strong understanding of traditional design principles is also highly appreciated. Please provide a portfolio of similar projects. I’m looking forward to seeing your innovative ideas.

...developer to create a script that can convert .AAF files to .CSV format using either the pyaaf2 module or another suitable alternative. Key Requirements: - This task can not be solved with ChatGPT, because it gives wrong results that are not working, so be careful. - The script should focus on extracting and organizing the clip names and timecodes from the .AAF file. - The CSV output should be structured with separate columns for each attribute, specifically Clip Name, Start Timecode, and End Timecode. This format is crucial for the successful integration of the data. - The Timecode can be in SMPTE format (HH:MM:SS:FF) or in Seconds with Milliseconds. Ideal Skills: - Proficiency in Python programming, with a strong understanding of data manip...

I'm looking for a professional who can proficiently split Column D in my Excel spreadsheet into columns E, F, G, H . This data must remain on the same sheet post-split progression. I have provided an example in row 2 Key requirements: - Excel proficiency with experience in splitting columns - Ability to deliver quality work in a timely manner - Must respect data privacy Any freelancer applying for this project should include their relevant Excel experience to demonstrate their skill. This task needs to be completed quickly and correctly, so I need someone who knows their way around Excel. Let me know if you're up for it, I'm eager to get started on this as soon as possible.

Looking for an efficient, detail-oriented freelancer to recreate an existing one-page design on an Excel sheet, intended solely for data entry. You must be swift but precise, ensuring all data entered is accurate and comprehensive. I will provide the design for recreating, so your task will be purely focused on data entry. Skills & Experience: - Proficiency in Excel - High attention to detail - Speed in data entry without jeopardizing quality - Familiarity with handling and organizing large data sets.

I want a program that is connected to a webcam/camera whereby if camera sees the object he gives an alert that the object has been recognized. So lets say I see a specific car that I like; the camera will recognize it based on the images of the car that is saved and will compare to it if its that car. If he thinks its that car he will take a snapshot and I will see if its true or not.

We are seeking Assistants or Operations Associates to join our E-commerce company on a long-term basis. In this position, you will be responsible for some recurring tasks everyday, Read our product reviews & feedback, Checking for Unfulfilled Units online, Handle customer queries via Amazon/eBay, Check UPC, Assist in FBA fee checking,etc Requirements: - Prior experience with Amazon activities (preferred). - Should know how to use Google Sheets (required) - Always connected via computer or mobile device. - Strong English communication skills. - Capability to follow instructions and work effectively with minimal supervision. - Freshers and newbies who are eager to learn can also apply. How to Apply: If you are intere...

I'm in need of a proficient data entry professional who will enter customer data into Excel spreadsheets. Key Responsibilities: - Transfer customer data accurately into Excel - Double-check data for mistakes or inconsistencies - Maintain confidentiality of customer data Ideal skills and experience: - Proficiency in Excel - Attention to detail - Experience with data entry tasks - Strong understanding of handling sensitive customer data.

I am seeking a proficient freelancer who can effectively extract data from six graphs (line and area) and reproduce the graph in Excel. Please review the attached Excel file for grahps (3 of them are already processed as an example). Ideal Skills & Experience: - Demonstrated ability in data extraction - Excel competence - A keen eye for detail Freelancers should include examples of their past work for consideration. Your bid should be reflective of your skills and experience. I am looking forward to viewing your proposals. Please make them as detailed as possible.

I urgently require a professional to help me with an operations job. The specific tasks and software knowledge required are undefined as I am currently uncertain of my specific needs. Ideal Skills and Experience: - Experience in diverse operations tasks like data entry, order tracking, and document organization - Proficiency in using a range of software like Microsoft Excel, inventory management systems, and quality control software. A willingness to adapt and the ability to quickly pick up new tasks would be extremely beneficial for this role.

I have a significant amount of physical documents that need to be transferred accurately into an Excel spreadsheet. I plan to mail these documents to you on a regular basis for entry. Your responsibilities will include: - Accurately entering the data from the physical documents into an Excel spreadsheet - Ensuring that the data is error-free - Organizing the data in a clear and logical manner - Maintaining confidentiality and security of the documents The ideal candidate will have: - Proven experience in data entry, preferably from physical documents - Excellent attention to detail - Proficiency in Excel - Good organizational skills - Ability to maintain confidentiality Looking for a reliable and meticulous per...

I'm in need of an experienced website developer proficient in creating intuitive, user-friendly platforms. The aim is to make a website where users can build their own profiles and engage with relevant content. Key project requirements are: - Minimum of 10 dynamic pages. - Facilitate user profile creation, Email account registration through private domain and interaction with content On map interface with bookmarking and trip planning features. - An aesthetically appealing interface targeting a wide range of audience namely, clients, customers and the general public. As the site's main focus is to provide product information Of registered university and College Institutions rather than sales or to capture user details for marketing, the desig...