How to compare large data sets in excel työt

FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...

Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.

Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.

Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.

lojnjg gyguuuuuuuu gg jbjiiihhtft kiyoio

2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.

Offline typing job,data entry job

I have a sizable 2.32 acre plot that I'm looking to have professionally landscaped with an emphasis on low maintenance and sustainability. In your proposals, I'd appreciate designs which include, but are not limited to: * Trees and shrubs * Water features such as ponds or fountains * Hardscape elements like patios or walkways * Fruit and vegetable garden * A greenhouse * Implement permaculture specific to USDA Climate Zone 8b * Develop a food forest The ideal candidate for this job is an expert in sustainable landscape design, with experience designing for large spaces. If you have experience in permaculture and food forests, this would certainly be a plus. This project is about balancing beauty with functionality, so I'm...

Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.

...assistance to improve my Excel workbook used for estimates and bids. The ideal candidate for this task should have: - Top-notch Excel skills, specifically understanding VLOOKUP functions and formulas for summing totals. - Experience in creating automatic calculations to streamline my estimation process. - A knack for designing and customizing Excel templates. - A solid understanding of construction or a similar industry would be a huge plus. Specific tasks include: - Building automated calculations for summing totals and utilizing VLOOKUP functions. - Customizing Excel templates, specifically for the cover sheet, project details sheet, and bid summary sheet. Approach this task with a good understanding of how general contrac...

I am actively seeking 50 dedicated women to assist with part-time digital marketing on Facebook and Instagram. Ideal candidates are those with: -No skills required - 10th pass can also apply - work from home opportunity - Training and guidance will be provided This is an exclusive opportunity for women only. If you're looking to excel in a digital marketing role, please place your bid.

I am looking to develop a unique 3D animation character - a female mosquito with exaggerated characteristics such as a large body and big eyelashes. The traits should appeal to the softer side and present the mosquito character as adorable, and even cute. Required Skills and Experience: - Advanced skillset in 3D animation and character design - Ability to carry a concept to completion and create characters with a distinct style - Experience in creating cute and endearing characters I am looking for a freelancer who can bring this 3D character to life, injecting it with charm and charisma which is hard to miss.

I’m looking for a doodle drawing commission to include some elements of my family life. Doddle protrait to include a few of each of the below, maybe interacting some how. The idea is to use this as a print to go onto a vinyl wrap. I need to be able to replicate the image supplied and piece them together to created a large wrap. Thanks. Challenger 2 tank Royal Tank Regiment symbol Fire Engine Firefighter Skydiver Motorbike Camper van Classic mini car Volkswagen t3 van Vw crafter 2019 van Lady graduating in the gown Husband and wife 4 children, 3 boys 1 girl Tent Beach Staffordshire bull Terrier ( white face, brown patch over the right eye) Cockapoo Black and white tabby cat

I am making a GANTT chart and need to make it highlighted. the chart is created using highlight formula instead of using basic insert chart option. I need help to do a part of it. Video explanation of the problem: Excel file I am working on is attached: The ideal chart should look like the attached image: Looking for the cheapest service as this is almost done.

I am looking for a talented developer to help me implement a comprehensive quiz management system for my personal project. Key requirements include: - Ability to manage multiple choice, true or false, and open-ended quizzes - Provide access to these quizzes through both a website and a mobile application - Incorporate user account management for both quiz administration and participation Skills and experience in the following areas are essential: - Full stack development - Proficiency in developing both web and mobile applications - Previous experience with managing and implementing complex systems with multiple user roles The successful candidate should be able to deliver a high quality, user-friendly system within a reasonable timeframe. 1. ...

I need assistance with pagination in my 200+ page Word for Mac document, specifically in certain sections. The main issue I'm facing is inconsistent numbering, which seems to be disturbing the flow and continuity of my work. The chosen freelancer should have: - Proficiency in Microsoft Word for Mac (I'm using version 16.85 copyright 2024). - An excellent understanding of pagination issues and how to resolve them. - Experience with document formatting in large Word files. Please only bid if you're confident you can rectify this issue quickly and efficiently.

Seeking a long-term Python Data Scientist and Generative AI expert Your task is to develop a prototype chatbot that is powered by Generative AI and Large Language Model (LLM) to respond to user queries using domain-specific knowledge and RAG implementation. The project will focus on integrating LLM frameworks, managing data preprocessing, and implementing the chatbot's user interactions. ONLY people who respond to below screening questions will be considered: 1) Did you fine-tune an LLM model using LoRA or QLoRA? If so, which model did you fine-tune, and what was the use case? 2) Do you have a GitHub profile? If so, can you share the link? 3) Are you proficient in English, and what is your hourly rate?

I'm seeking knowledgeable professionals to provide accurate structural calculations and plans for a vast commercial warehouse exceeding 10,000 square feet. The project demands vast knowledge and experience in large-scale commercial building design conforming to local building codes and standards. You should have: - Proven expertise in commercial building design, particularly warehouses and racking system - Strong understanding of building codes and standards. - Ability to communicate effectively and provide clear, comprehensive plans. Your responsibility will be: - Developing structural calculations that adhere to safety and local building codes. - Creating detailed plans for the entire warehouse structure.

...domain that I'm looking to sell. It was originally intended for an e-commerce website. As I'm not planning to develop a website using this domain, I'm interested in finding potential buyers who can make the most of its e-commerce potential. Key Points: - The domain is ideal for e-commerce purposes, which makes it a great opportunity for someone in the online sales space. - I'm particularly interested in connecting with individual entrepreneurs, small to medium businesses, and potentially large corporations who are searching for a domain that fits an e-commerce website. I'm looking for someone who can help me find potential buyers and close the sale. This job will require: - Strong networking skills and an und...

...configuring AWS EventBridge to handle large volume webhook events from Shopify - Routing these events to either SQS or Lambda Your primary task will be to ensure that Shopify webhooks are efficiently processed through AWS EventBridge. Ideal skills and experience for this job: - Proficiency in AWS services, especially EventBridge - Experience with Shopify webhooks - Knowledge of server setup and configuration - Prior experience with middleware systems and large volume event handling - shopify graphql and restful api Please note that while the user hasn't specifically outlined the action to be taken upon receiving the webhooks, it's expected that you'll be able to advise on the optimal setup for further processing o...

I'm looking for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can de...

I'm in need of a skilled individual who is proficient in blockchain and wallet analysis, specifically on the Arbitrum blockchain. The project involves analyzing transaction patterns and wallet balances and activities. Key Requirements: - Proficiency in blockchain analysis, particularly on the Arbitrum blockchain - Ability to identify patterns and trends in transactions - Proficient in analyzing wallet balances and activities Deliverables: - A comprehensive report that includes methodology, analysis, and conclusion - The report should be presented in a combination of written format and visual presentation (charts and graphs) Please note that I will provide you with access to the necessary pages and data on Arbiscan. You...

I'm on the lookout for a music producer experienced in creating UK Hardcore tracks, tailored for high-energy party atmospheres. My DJ sets do not exceed an hour, and I'd like fresh, custom tracks that can keep the energy up during my performances. The ideal candidate would have: - Knowledge of and experience in creating UK Hardcore music - An understanding of high-energy party tracks - Capability to deliver compressed, ready-for-play tracks within set deadlines - Creativity and originality in track production Experience producing DJ sets will be highly beneficial. Please provide examples of previous work that relate to my requirements.

...experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward ...

I'm in urgent need of a creative and professional designer who can quickly design a medium-sized roll up banner (80cm x 200cm) for a sharktank presentation. Your responsibility will include highlighting the sharktank event announcement in a compelling and attractive manner. Ideal Skills: - Proficiency in graphic design software - Experience in designing banners, specifically for events - Ability to deliver high-quality work promptly The project needs to be completed as soon as possible, so I need someone who can start immediately. --- Ignite your senses Neuroplay logo Large neuro play written across More pink More purple QR Code white drop --- Fully editible format to add QR code later on my side Attached a design I...

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.8...

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I need a machine learning model developed in Python. This model should be able to evaluate prospective student applications by comparing them to historical data sets. The goal is to classify and sort the new applicants efficiently. Key Requirements: - Develop a classification-based machine learning model in Python - Understand and work with historical data sets to evaluate new student applications - Deploy the model in a web application format for ease of access Ideal Skills and Experience: - Strong background in machine learning and Python - Previous experience in developing classification models - Ability to understand and work with large data sets - Prior experience w...

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

I need a comprehensive web scraping task done on Yellowpages for business broker. The goal is to extract the following data about businesses: - Business name - Address - Phone number - Email - Website - Contact Person I'm looking for a professional who is well-versed in web scraping and can deliver accurate and complete data. Skills required: - Proficiency in web scraping techniques - Experience with scraping - Attention to detail to ensure all relevant data is captured - Ability to deliver in a timely manner Please note that the number of pages to be scraped is not defined, meaning the task might involve a large number of results. The scraper should be able to handle this efficiently.

I need an expert in Shopify to assist and guide me through customizing my store significantly. I'm looking for someone who can work closely with me, explaining the processes, and potentially carrying out the changes themselves. As this will be an ongoing project, we'll be adding many categories. To ensure you're the right fit for this role, please provide a list of stores you've worked on in the past. Key tasks include: - Extensive customization: We need to go beyond the standard Shopify theme and make significant changes to the store design and layout. - Adding products and categories: You'll be responsible for adding and organizing a large number of products and categories. - Setting up payment and shipping: Ensur...

I'm seeking an experienced Android app developer to create a custom app like Linphone with specific features and design requirements. Requirements: - Voice & Video Calling: The app should allow users to make both voice and video calls. - Custom Design: The app needs a unique, custom design that sets it apart from other similar apps. - Integration: The app should have the capability to call to extensions. Ideal skills and experience for this job include: - Proficiency in Android app development. - Experience with developing communication apps. - Knowledge of integrating calling features with extensions. - Ability to create a visually appealing, custom design. If you have the skills and experience needed, I'm looking forward ...

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**...

Hello there, I'm seeking a proficient 3D artist to create captivating interior renderings of a residential space of ~6,000 SF The house rooms are below: Basement - Bunk room - Living Area - 3 Baths - Bar/Kitchenette - Guest Room - Laundry Main Floor - Master bath, closet, and room - Living/Dining area/Kitchen - Entry - Closet - Laundry/Mudroom - Powder Bath - 3 1/2 car garage Second Floor - Study - Coffee Bar - (x2) Guest Bed/Bath/Closet - Laundry - Workout Room What I envision is a mountain style theme; something that creates a feel of comfort and tranquility. To make a successful bid, ideal skills and experience would include: - Prior experience with large scale residential interior rendering - Proficiency in 3D software - A keen eye for detail ...

I'm looking for a sharp representative who can identify and convince individuals, small businesses, and large corporations in the technology sector of the benefits of our services. The main goal of this project is to build brand awareness and gain more customers in the E-marketing company. You earn 10% of the profits from each customer. Key Responsibilities: - Researching potential clients and their needs - Understanding our services and how they can benefit clients - Convincing potential clients to trust our services and brand Ideal Skills & Experience: - Previous experience in sales - Excellent communication and persuasion skills - Ability to conduct effective market research ------------------------------ Tasks: -Find a...

...freelancer to help me extract financial data and regulatory filings from a tax website. This involves scrapping website using the provided credentials by the client, i am looking for getting the python code as i can run the code myself in the future or integrate it to another system. Key Requirements: - I need approximately 300 data points extracted. - The output for these data points should be organized into a PDF or Word. This project is about creating an automated system to generate instant reports about a company. Only difficulty is the website has drops downs to select the period involved and in those 300 data points actually many come from the same source. Ideal Skills and Experience: - Experience in ...

I'm in need of an experienced freelancer to assist me with mapping my Shopify products which exist on Baselinker software to relevant marketplaces. The primary goal of this project is to improve inventory management. Your tasks will include: - Setting up the mapping of my Shopify Baselinker products on various marketplaces. - Ensuring that all of my products are correctly synced and organized - Assisting in customizing the inventory management system to fit my specific needs Ideal skills and experience for this project include: - Prior experience with Baselinker software and its marketplace mapping capabilities - Strong understanding of Shopify and its inventory management system - Proven track record of managing large inventories...

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

I'm in need of a skilled video editor and animator to create an elegant and professional intro for an upcoming religious conference named AWC Campmeeting 2024. Key Details: - The intro should be between 30-45 seconds long. - All assets such as photos, logos, and voice-overs will be provided. - Key elements to include are: - Event name and dates - Speaker highlights - Location details - Musical Guest Key Skills: - Proficiency in video editing and animation - Experience with audio editing is a plus - Ability to produce a high-quality, elegant, and professional theme The goal of this project is to create an engaging and impactful introduction that sets the tone for the event and captures the essence of the conference. A freelan...

Thank you!

...financial plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do no...

A...system, I am seeking a professional to help streamline our supplier onboarding and product uploading processes. The primary challenge we face is handling a large number of SKUs effectively - we typically deal with between 10,000 and 50,000 on a regular business. Key Project Needs: - Improve SKU processing speed and accuracy. - Streamline supplier onboarding process. - Make it easier to manage large volumes of SKUs. The ideal candidate will have previous experience in SKU and/or supplier management, process improvement, and working with high volume product management. Expertise in our current system would be a beneficial, but is not a necessary requirement. You should be driven by efficiency and comfortable working with large data...

I'm in need of a skilled programmer who is adept in Python, Java, and C++. Your tasks will span database management, working with algorithms and data structures, and user interface design. Here's a further breakdown of the ideal skills and experience I'm looking for: - Programming skills: Proficient in Python, Java, and C++. Familiarity with various coding patterns and best practices. - Database management: Experience in handling large datasets, querying databases in an optimized manner, and ensuring the integrity and safety of the data. - Algorithms and Data Structures: Demonstrated understanding of algorithms and data structures. The ability to use this knowledge to solve problems ef...

...skilled data researcher who will research online UK based local planning authority databases for certain information sets. - Specific focus is needed on planning submissions and permissions that require BNG (biodiversity net gain credits)(the leads). The information is to be taken from Local Planning Authority official websites (publicly available information and no logins required). An in-depth knowledge of planning submissions and permissions and BNG is NOT needed. What is however required is accurate information to be taken from those websites and converted into a database for us. - This work can be done remotely and only requires a computer and access to the internet. - The geographical focus of the UK planning authorities we require info...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "P...

A general information article is needed for waiting room chairs. The article should provide insight into the purp...general information article is needed for waiting room chairs. The article should provide insight into the purpose of waiting room chairs and the benefits they provide to a businesses guests. The article is to provide a resource into understanding what sets waiting room chairs apart from other office chairs. - Must be between 1,000 to 1,200 words - Article must contain 3 to 5 references, the links will be provided upon awarding the project More details: This is for a website that provides general information on a wide range of topics. What is the main goal of your article? provide general information on waiting room chairs How so...

I need a meticulous data entry specialist to help me clean and format a large set of digital documents. Key Responsibilities: - Sorting and organizing data effectively. - Removing any duplicates and errors present in the data. The ideal candidate should be familiar with data entry and have a keen eye for detail. Experience in data cleaning and formatting would be a plus. Time management is crucial for this project.

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed