How to merge two excel sheets based on one columndela

Potrebujem app ki prebere excel in ima možnost vnašanja(import) excel tabel, dostopno mora biti preko mobilne/web aplikacije, imeti mora možnost razporejanja oz dodajanje dela večim ekipam, na koncu mora vse skupaj združiti v skupno tabelo, odšteti količino porabljenega materiala za delo oz voditi zalogo opreme in ločeno voditi količino porabljenega materiala za posamezno stranko, moznost uploada slik za posamezni id stranke, in upload to na pc oz web server

Narisati je treba shemo nadzornega sistema stavbe po nadstropjih in v vsako nadstropje vnesti komponente iz excel tabele - do 100 komponent

Obdelava podatkov, izdelkov različnih proizvajalcev iz različnih virov z Query-ji, lepljenje po ID-ju ipd ipd Trenutno imamo 1 projekt za nekaj ur dela. Po podobni logiki so v pripravi novi projekti..

need help with spreadsheet formula

I'm in need of a Google Sheets scripting expert who can help me create a bidirectional data transfer system in Google Sheets. - The task involves transferring ALL data from one main sheet to multiple other sheets. - The data should be copied as well as linked to the other sheets. - The script should work bidirectionally, meaning any changes made in the source sheet should be reflected accurately in all the other sheets and vice versa. Ideal Skills and Experience: - Proficiency in Google Sheets scripting, specifically working with data transfer and bidirectional systems. - Knowledge of how to copy and link data between sheets. - Experience in creating and maintaining bi-directional data systems. - Abi...

I am seeking a skilled freelancer to guide me in creating Power Automate flows that efficiently import data from a single worksheet Excel document into Dataverse. Key Tasks: - Develop a couple of Power Automate flows to import Excel data into Dataverse. - I have had many difficulties with date and lookup/choice columns not correctly importing. Ideal Candidate: - Expert knowledge and experience in Power Automate. - Proficient in Data Integration between applications. - Knowledgeable in creating approval workflows and automated notifications. - Previous experience with Excel-data integration into Dataverse. - Excellent communication skills.

Tengo una asesoría energética, la cual paga comisión por contrato. La comisión depende de distintos factores. Actualmente tenemos un backend en excel y un frontend en pdf, es decir: Creamos las comisiones en excel para agilizar la creación, las copiamos en un POWERPOINT algo más atractivo y visual, y las convertimos a pdf. Nos gustaría poder implementar la subida de estos excels en una interfaz BONITA, incrustrada en una web. Lo ideal sería poder cargar estos excel a la web y que la web "pintara" estas comisiones a través de una interfaz visualmente atractiva y llamativa para nuestros agentes comerciales. Adjuntamos ejemplo de excel de comisiones de algunas de nuestras compa...

I am looking to commission a skilled Pine script developer to build a trading strategy for me on TradingView based on the Weighted Moving Average (WMA) Indicator and Anchored Volume Weighted Average Price (AVWAP). Key Requirements: • Develop Pine script strategy for TradingView that will generate both long and short trade signals based on WMA and Anchored VWAP. • The strategy should encompass a simple backtesting functionality, optimization is not needed. Ideal Candidate: The ideal candidate for this job will have a significant familiarity with: • Pine script programming and development; • TradingView platform; • WMA and Anchored VWAP indicators. This role requires a detail-oriented professional with a trac...

I want to add 2 RSJ beams to my house to create a canopy above the proposed external terrace area. chem fix bolted back to the concrete structure of house. The house is a newly constructed single story property using ICF (insulated concrete formwork) with 150 mm thick concrete core and 80 mm extruded polystyrene on the outside and the inside. Generally, there is no rebar in the structure other than integral lintels and columns. The proposal is to add a minimal RSJ/UB steal structure to form a canopy structure. This new metal structure shall be fixed to the existing concrete structure by drilling and Chemfix with appropriate sized threaded bar, nuts and washes. It should be noted that 2nr concrete deep pad foundations have already ...

I'm in need of a freelancer who can automate my Excel spreadsheet to increase efficiency and accuracy in data entry and analysis. Key Duties: - Automate data input, validation, and manipulation - Perform calculations and formulas automatically - Generate reports and summaries for the data Ideal Skills: - Proficiency in Excel - Excel input form design - Previous experience in automating data entry processes - Understanding of data manipulation

I'm seeking an experienced Google Script specialist to automate tasks and manage data for my project. Here are the specifics: Automating tasks: Your main responsibility will be to automate data import/export processes using Google Script. I need to take the data attahed to a daily email in excel format, upload this data (and historic) to a data base and then allow to consult that data from different spreadsheet in google with a query. Ideal skills and experience include: - Proficiency in Google Scripts and automation - Experience in data management - Google spreadsheet analisis reports If you have the needed expertise, I'm excited to work with you!

for adult sites (XXX) (¡¡¡¡READ THE DESCRIPTION COMPLETELY !¡¡¡) this is our site, we want a freelancer that can give at least 30 highquality backlinks in at least 15 articles Permanent is a MUST, No Duplicates if you want to be hired, send the list of domains where you will publish the articles with the PR No spam backlinks like blogsport, comments on other postings things won´t be accepted neither Budget: 400 USD don´t harrass me, just bid and send the list, otherwise you will be blocked and reported

We are working under an expedited deadline (less than 1 month) to integrate machine learning with our unit commitment problem (UCP), specifically focusing on renewable energy sources (RES) - solar and wind energy. Key responsibilities: - Implement neural networks in the machine learning algorithm. - Expertly merge UCP with RES (both solar and wind energy). - Expert in unit commitment problems Ideal candidate: - Proven experience in machine learning - Familiarity with neural networks - Strong understanding of renewable energy systems - particularly solar and wind - Ability to meet tight deadlines Your expertise in neural networks and renewable energy is pivotal to the success of this project. Let's make the world more sustainable together!

Prosimo, vpišite se ali se prijavite za več podrobnosti.

...developer who can help me to create a new digital currency based on the Cardano blockchain. Key Project Details: - The primary function of the coin will be as a digital currency - The consensus mechanism should be Proof of Stake (PoS) Skills and Experience: - Strong background in blockchain development, particularly on the Cardano platform - Experience in creating digital currencies and implementing PoS mechanisms - Understanding of the regulatory framework for new crypto projects - Ability to provide guidance on the overall coin development process Deliverables: - Fully functional Cardano-based digital currency - Documentation on the consensus mechanism and any other technical details - Support with the launch and initial depl...

For my project, I need a freelancer with strong skills in data scraping and extraction, particularly with textual conte...Tasks: - Effectively pull relevant textual content and figures - Ensuring the scraped data is comprehensive, accurate, and neatly organized Excel Skills: - The data collected must be meticulously stored in an Excel database - The organization method within the database is by entity An effective freelancer must be detail-oriented, proficient in using Excel and knowledgeable about data scraping techniques from public websites. A background in handling similar tasks would be advantageous. Accuracy and neatness in data organization are also paramount. Please indicate you reviewed the information above and attached and specify the amount of time req...

I'm seeking a skilled Drupal expert to help me to export form submissions from the Drupal website to csv More details will share - Implement a user-friendly CMS system with Drupal - Ensure the system is easy to navigate for non-technical staff - Customise the CMS to suit our business needs Ideal Skills and Experience: - Proficient in Drupal CMS - Prior experience setting up content management systems - Ability to tailor CMS systems to specific business needs - Good communication skills to ensure our team can effectively use the CMS.

I'm in search of a proficient and experienced app developer from India to build a top-notch Fantasy Cricket and Betting app. The app should be designed for both iOS and Android platforms. Key Features: - In-app Payments: The app must incorporate a seamless and secure in-app payment system. Users should be able to easily make transactions. - Leaderboards: The app should have a leaderboard feature. This feature will allow users to keep track of their performance against other players. - Premium Quality: My goal is to have a high-quality and well-designed fantasy app. Aesthetics, functionality, and user experience are key considerations for this project. User Interaction: - Users will have the ability to create their own fantasy teams. This is a cruc...

...DELETE YOUR BID IF YOU DO MOT TEAD I need to automate a process for onboarding a financial session. It should be web-based to keep the cost down. Currently I ask them to break down some of their finances manually. I want to make an interactive interface that asks them questions (to name expenses and add up the amount) with the aim of generating a report consisting of 4 sections: Housing Transportation Food Essentials It should start by asking consent to share this information with me to analyze it. I would also like: name, email age, then how much money they make and whether they make it biweekly, annually or monthly. (This needs to be translated to a monthly figure) Each section will ask questions...

I need an efficient and experienced professional who has a good understanding of Google Sheets and data analysis and entry. Specifically, I need: - Creation of PLP by Copying-Paste Data entry. - Searching a Google sheet for specific products that should be on that PLP - Manually adding each product to that specific PLP based on the results from the sheet A full and detailed brief is available.

I'm in search of a talented artist who can create a humorous and lively hand-drawn caricature for a special gift I'm preparing. The cartoon should feature a single character, designed in a caricature style. Ideal skills for this project include: - Proficient hand-drawing abilities - Experience in creatin...hand-drawn caricature for a special gift I'm preparing. The cartoon should feature a single character, designed in a caricature style. Ideal skills for this project include: - Proficient hand-drawing abilities - Experience in creating caricatures - Creativity and a keen sense of humor The outcome should be an endearing and unique caricature, a one-of-a-kind piece that will surely bring a smile to the recipient's face. I'll supply a photo. I wa...

...capable of merging two indicators in one. Your task will be: - Merge the Two indicators into a single script on the Trading View platform. - Incorporate Fibonacci (Fib) levels in the script, but specifics were not indicated. We can discuss that further. 1. **Combine Indicator Logic**: - Integrate the logic from both indicators into a single script. - Ensure that the functionality to track highs, lows, and Fibonacci levels is preserved. - Maintain separate sections for calculating highs and lows, as well as for drawing Fibonacci lines. 2. **Adjust Inputs Interface**: - Rearrange the input section to display inputs horizontally for better organization. - Add new inputs for the requested features: - Toggle for drawing...

I'm seeking a professional developer with experience in Elementor to design and built an e-commerce website where I can sell my services. Key website functionalities needed include: - Inventory Management: This feature will allow me to keep track of the services offered. - Customer Reviews: A section for customers to leave ratings and reviews enhancing the trustworthiness of the services offered. - Discount codes option: For promotional purposes, a feature to apply discount codes is desirable. Ideal freelancers will have a strong background in e-commerce website creation, specifically service-based businesses, and familiarity with Elementor. A portfolio showcasing similar projects would be advantageous.

I'm in need of an expert in trading view pine script programming who's capable of merging two indicators for my strategy. Your task will be: - Merge the Two indicators into a single script on the Trading View platform. - Incorporate Fibonacci (Fib) levels in the script, but specifics were not indicated. We can discuss that further. Ideal candidates should have: - Good understanding of Trading View's pine script and trading indicators. - Experience in scripting Moving averages and Bollinger Bands. - Knowledge on incorporating Fibonacci levels. Please bid with examples of similar work you've done in the past. I'm looking forward to your proposals.

I'm i...that prints labels from an Excel spreadsheet. The scope is to print personalized employee labels with names and respective earnings for cash payments. Key project features: • Read an Excel spreadsheet in a consistent format, with different entries for each worker's name and earnings. • Print labels with the worker's name and corresponding earning. Candidates should have: • Extensive experience in programming • Familiarity with reading data from Excel • Expertise in printing functions Just to clarify, the format of the spreadsheet will always be the same, only the contents (worker names and earnings) will differ. Please ensure the program is capable of handling this accurately. Your proposa...

...social media manager who can post daily content on Facebook, Instagram, TikTok, and other platforms through Loomly. The job will mostly entail modification of existing content. However, your creative input is most welcome. There is an official step-by-step Process to follow. Minor Excel reporting is required as well. I need somebody who is proficient in English-written and listening/talking. Must be able to work in a New York time zone between the hours of 12 PM and 8 PM. Roughly 2-3 hours a day total Monday-Friday at $30 a week! This role requires: - Excellent understanding of these four platforms - Proven ability to edit and modify existing content in an appealing way - Capacity to deliver consistently on a daily basis - Attenti...

Business Evaluator updated 5-6-24 9:26 Freelancer – When responding back, respond to the questions below, otherwise you will not be considered for the project. Freelancer – I will decide on the project in 3 days. The business evaluator estimates what your business is worth and offers a blueprint for scaling your business to the next level. The blueprint will establish your business baseline, identify your peer group, and advise you on what you need to do (people and budget) to accelerate to the next peer group level. Currently: 1) Written in MS Excel and utilizing Macros for a. Navigation between Sheets b. Set a subscription, 1st time the Worksheet is run, it writes a date in a database workshee...

I'm seeking a talented developer to create a custom Telegram bot for my company. The bot will serve as a communication tool and a source of information. Ideal Skills & Experience: - Proficiency in Telegram Bot API - Experience with bot design, including user input and automated messaging - Capable of implementing and managing information resources The main functionalities of the bot are: - Sending automated messages: The bot should be able to send pre-determined messages at set intervals. - Receiving user input: It should be able to interact with users and receive text input from them. - Providing information based on user queries: The bot needs to be able to present content from our company's internal library which will be p...

...help in revamping my crypto website for 12000 pkr. The improvements I want to see include: - Enhanced navigation menus: You must be able to design clear, intuitive menus that help users find their way around our site. - Better typography and color scheme: Our site needs a more visually appealing font style and color scheme. It's imperative that you have a keen eye for aesthetics. - Improved layout of content: Content must be organized sensibly to provide users with a smooth browsing experience. I envision a modern and sleek look for my website. It should radiate a sense of sophistication and cutting-edge technology. The ideal candidate will have experience working on similar projects and a strong portfolio to back it up. You must be capable of...

You are asked to create an Excel file (FILE A) that: 1) Automatically extract data from another Excel file (FILE B) which is located in an FTP folder and which is updated every day. 2) The FILE A must extrapolate the data from the FILE B based on some filters that can be set or changed. For example, a filter could be the Brand or the Price. 3) The output (FILE C) of FILE A must be a .CSV file composed of 3 columns: SKU, Quantity and Price. 4) The final part is that this FILE C is saved inside another FTP folder. This entire 1+2+3+4 process must be done automatically every day at a certain time without the intervention of an operator.

I'm looking for a skilled Excel expert to work on my financial data. The task involves clearing the data and conducting a thorough analysis specifically focused on profitability. Key responsibilities: - Clearing the provided financial data - Analyzing the data based on the profitability metrics Ideal skills and qualifications: - Proficiency in MS Excel, especially in data analysis - Strong understanding of financial metrics, particularly profitability - Attention to detail and ability to ensure data accuracy - Ability to present findings in a clear, concise manner - Previous experience working with financial data is a plus Please note that the data requires thorough analysis. Clarity and precision are crucial as...

I have a set of Excel sheets that need to be transformed into a powerful data analysis tool. The primary purpose of this tool is to provide detailed data analysis in the form of summary reports. Key requirements: - Data analysis: The tool needs to be proficient in data analysis. It should be able to handle the data provided and present it in a clear and concise manner. - Summary reports: The data analysis results should be presented in summary reports. These reports need to be visually appealing and easily digestible for a non-technical audience. - Automated chart updates: When new data is added to the tool, the charts should be automatically updated to reflect these new changes. This automation is crucial to ensure th...

Note : my budget for whole project is 20$ Project Overview : developing a web-based game that leverages the ChatGPT API to generate unique scenarios and tasks for players. The game will offer personalized experiences with secret objectives that contribute to a collective goal. **Game Flow Implementation:** 1. **User Registration and Profile Creation:** - Players sign up and create profiles. - Each player is assigned a unique identifier (UUID) for tracking. 2. **Scenario Generation:** - At the start of a session, the backend sends a request to the ChatGPT API. - The API returns a scenario that sets the context for the game. 3. **Task Generation:** - Based on the scenario, the backend formulates tasks for each player. - Ta...

...Augmented Generation (RAG)-based chatbot, the full-page chat interface screen, and the miniature chat interface. This job does not include deployment of the files to the production system. A demonstration of the chatbot and its capabilities will be provided upon completion of the project. The chatbot will limit itself to agreed upon topics/information and can handle several conversation turns (i.e., will maintain a temporary chat log per interaction for conversation flow). The chatbot will also be configured to store all chat logs locally. The chatbot will make use of an information store, so domain- and county-specific data will be available. Files will be documented in case of future modification. Client responsibilities : - Providing all applicable in...

I have a database with 200,000 SKU's from retail sales, unfortunately lacking category, subcategory, and brand details. I'm seeking a skilled professional who can assist in mapping these details effectively. Key Deliverables: - Utilize a data matching algorithm to automatically map the SKU's with high accuracy (90-95%). - Present the final output in an Excel spreadsheet. Ideal Skills: - Proven experience in data matching and SKU mapping. - Proficiency in using data matching algorithms. - Experience with handling large datasets. Accuracy is paramount for this project, as the mapped details will be used for further data analysis and decision-making in our retail operations. A high level of precision will be crucial in ensuring the effectiveness of this projec...

I'm seeking an experienced Tableau and Excel expert to assist in creating a high-quality data visualization project. Key project requirements include: - Intermediate level of complexity: The data that needs to be visualized is sourced from multiple sources and requires the implementation of filters. - User-driven data filtering: I am looking to implement specific interactivity features that allow users to manipulate and filter data. The ideal candidate will have: - Proficiency in Tableau and Excel - Experience in creating intermediate level data visualizations - Strong understanding of data filtering and interactivity features If you possess the required skills and experience, please bid on this project.

Note : my budget for whole project is 20$ Project Overview : developing a web-based game that leverages the ChatGPT API to generate unique scenarios and tasks for players. The game will offer personalized experiences with secret objectives that contribute to a collective goal. **Game Flow Implementation:** 1. **User Registration and Profile Creation:** - Players sign up and create profiles. - Each player is assigned a unique identifier (UUID) for tracking. 2. **Scenario Generation:** - At the start of a session, the backend sends a request to the ChatGPT API. - The API returns a scenario that sets the context for the game. 3. **Task Generation:** - Based on the scenario, the backend formulates tasks for each player. - Ta...

I'm in need of an Excel Spreadsheet expert to help with a few key tasks: - Revamp the Weight Loss Tracking Sheet: The current formula isn't functioning as intended. Your job will be to troubleshoot and fix the problem. - Nutrition Plan Integration: Blend the Weight Loss Tracking Sheet with a separate nutrition plan in the same Excel document. The two should have a uniform look, with consistent colours and my branding. - Branding Adjustments: Remove branding from the Weight Loss Tracking Sheet and ensure it matches the nutrition plan in terms of aesthetics. Your expertise in Excel formulas and formatting, as well as design skills will be key in completing this project successfully. Also please make a copy of the tracking sheets...

...and knowledgeable data scraping professional to collect specific information from three major platforms - RERA websites (specifically Maharashtra, Telangana, Haryana, and Delhi), Google, and Justdial. Here's what I am looking for: Details to Scrape: - Name - Mobile Numbers - Locality - City - Address - Pincode Platforms: - RERA Websites (Maharashtra, Telangana, Haryana, Delhi) - Google (DSA and Loan Agents data) - Justdial (DSA and Loan Agents data) The ideal freelancer for this job will be highly experienced in data scraping and will be able to deliver the results in an organized manner. Proficiency in scraping from Google, RERA websites, and Justdial is particularly important. Delivery Format: - The data should be delivered in an excel file for...

I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.

I'm looking for a talented video editor to help with creating a captivating 10-20 seconds video intro for my new book. As the author, I have certain key aspects in mind that could be incorporated, however, I did not define whether it should be animated, live action, or a combination. Your creative input will be greatly welcomed. Ideal Skills: - Video editing - Animation (preferably, but not mandatory) - Creative thinking - Understanding of book themes Experience: - Portfolio of previous video intros or similar projects - Reviews or references validating previous work quality and reliability. Please review the book here:

...this project, I'm on the lookout for an experienced developer who is capable of crafting a telegram bot that operates based on a 'refer and earn' model. Key Responsibilities: 1. Determine Best Programming Language: As I'm uncertain about the best-fit programming language for my project, you are given the flexibility to choose between Python, JavaScript and Ruby, based on your expertise and the bot's needs. 2. Required Functionality: I'm not certain about all the functionalities needed yet. Hence, I expect you to suggest essential attributes during development, keeping in mind a bot that can handle referrals efficiently and incorporate an earning system. 3. Bot Purpose: The primary purpose of this bot i...

I have a 3.5-page handwritten sign-in sheet that I need transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the pro...

I require a skilled web developer to create an engaging user interface for my new project. The primary tasks include: 1. Creation of a login page: - This page should feature seamless Google integration, allowing users to easily sign-in using their existing Google accounts. 2. Developing a tailored home page: - The homepage should dynamically display filtered content based on the user type. We will have three distinct user types and the filtered content must reflect their needs and preferences. However, the specifics of this filtered data is yet to be defined. 3. Designing a user preference form: - A form should be incorporated to harvest key user preference information that will later be used to personalize user experience. 4. D...

...looking to enhance my Shopify store's B2B functionality by integrating two essential features from Sparklayer: - "Quick Buy" Page: This will substitute our current List view, enabling clients to quickly see prices and make bulk orders without navigating through individual product pages. (example is visible in another installed theme) - 'Unit Cost' Display on Product Page: Prices need to be shown in kilograms and automatically sync with Shopify's unit pricing, factoring in base price and dynamic calculations. (example code: ) Ideal candidate should have: - Proven experience with Shopify theme customization - Knowledge of B2B eCommerce solutions - Familiarity with Sparklayer integration - Fluency in JavaScript, HTML/CSS, ...

I'm looking for a skilled professional to make some minor text changes to an existing PDF document while maintaining a similar formatting style. The changes are straightforward and involve only a few words or sentences. Key responsibilities: - Make minor edits to the existing text in the PDF - Ensure that the formatting is similar to the original document Ideal Skills and Experience: - Proficiency in Adobe Acrobat or a similar PDF editing tool - Experience with editing PDFs while maintaining original formatting - Attention to detail for ensuring accuracy in text editing - Strong communication to ensure understanding of the required changes If you have experience with this type of project, I'd love to hear from you. Please provi...

I'm seeking a specialist with expertise in detailed financial data entry. You'll be tasked with entering intricate numbers and figures for our financial reports. Skills and Experience Required: - Proficient in Microsoft Excel. - Experience with financial report data entry. - Detail-oriented with ability to handle complex numerical data. Main Tasks: - Inputting detailed financial data into our Excel-based financial reports. - Ensuring accuracy of data. - Completing tasks within given deadlines. Please share relevant previous experience and examples of your work when bidding.

I'm seeking a proficient Lora developer to integrate a sensor-based device into the Lora network. The device utilizes temperature and light sensors. The preferred candidate should possess: - Proven experience with Lora device integration - Knowledge of sensor-based devices, particularly those employing temperature and light sensors - Creators with background in electronics, IoT devices, wireless sensor networks or similar are especially welcome This integration project requires precision and an understanding of sensor data handling within the Lora network.

I'm in search of a seasoned Excel-savvy bookkeeper to assist with the following tasks: - Accounts Payable: Tracking and managing all outgoing payments in a clear and organized manner. - Accounts Receivable: Overseeing and monitoring all incoming payments, ensuring timeliness and accuracy. - Bank Reconciliation: Regularly reconciling bank statements with our financial records to ensure accuracy. You don't necessarily need to be an expert in accounting software, but you should be fluent in Excel. This project doesn't involve learning new software, but rather meticulously managing and organizing financial data in Excel. I prefer to receive updates and reports via email, so clear and concise communication skills are a must. Ex...

I'm seeking a proficient Lora developer to integrate a sensor-based device into the Lora network. The device utilizes temperature and light sensors. The preferred candidate should possess: - Proven experience with Lora device integration - Knowledge of sensor-based devices, particularly those employing temperature and light sensors - Creators with background in electronics, IoT devices, wireless sensor networks or similar are especially welcome This integration project requires precision and an understanding of sensor data handling within the Lora network.