Sql merge data excel jobs

We are developing a spreadsheet-based database of the most popular English quotations (or English translations), and are looking for a researcher with native English language skills who can identify and collate (into Excel or Google Sheets) the following requirements, providing the quotation, the author, and the source document (if available): - 1,000 most popular quotations from literature (prose and poetry), excluding Bible quotations and the works of William Shakespeare - 500 additional most popular English language quotations in addition to the above (from non-literary sources - 200 of William Shakespeare’s most popular quotations Maximum length of each quotation is 55 words. Extensive source material is available online, and we encourage the use of existing source mate...

I'm in need of a Virtual Admin Assistant to help me manage my daily work. Key Responsibilities: - Data Entry & Report Writing: You would be handling data entry tasks & writing report and (you only need to direct report to me so simple communication) - Task Management: Utilizing software such as Trello, or Microsoft Excel to keep track of tasks and deadlines. Ideal Skills and Experience: - Experience as a virtual assistant or in administrative roles is a huge plus. -Experience in wiritng report will be added advantage - Proficiency with task management tools and software. - Excellent organizational and time-management skills. - Strong communication skills - you should be comfortable communicating via email, phone calls, and video conferences. Communicat...

I am looking for a skilled and experienced professional who can render detailed plans and elevations for my residential construction project. Your task will involve: - Preparing construction drawings that effectively communicate design intent. Your work should be easy to understand and facilitate the building process. - Providing compreh...detailed drawings can be used for accurate cost estimation. Your background in architectural design or civil engineering, coupled with proficiency in CAD software, will be extremely beneficial. Experience in residential construction projects is a must. Please keep in mind the crucial role these drawings play in the project's execution and the importance of accuracy and attention to detail. If you excel at this, you might be the right fit ...

I'm seeking a proficient data analyst with strong statistical analysis capabilities. Your main responsibilities will be: - Data Cleaning & Preparation: This includes cleansing the data from any incomplete records, duplicates or errors. - Statistical Analysis: You'll need to conduct a thorough statistical analysis of the data, utilizing regression analysis specifically. The project will involve various types of data including numerical, categorical, and textual data. Since we'll be working in a professional environment, knowledge and proficiency in MS Office is a must. This includes Excel, PowerPoint, and Word. Ideal candidates should be well-versed in data analysis and have a strong statistical background. P...

I'm in need of an Excel macro expert who can help me with a data arrangement task. The task involves transferring sequences of cells data from one grouped workbook to multiple original workbooks and worksheets. The data transfer should be based on specific criteria. Key Requirements: - Data transfer based on a specific criteria: The macro should transfer data based on a specific criteria. This involves arranging the data from the grouped workbook into different cells in a column in the original workbooks based on predefined conditions. - Conditional Logic: The macro should include conditional logic. This means that the data transfer should not just be a simple copy-paste operation, but should involve logical conditions for accu...

Provide: 1. French and 2. German translations for the static strings used on a website. I've compiled a list of all the static strings on a website. A native French speaker and a native German speaker are needed to update the Excel file attached with the translations from: 1. English to French and 2. English to German Thank you!

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

I'm looking for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to go around a circuit usin...

I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.

...request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook to inquire about availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen co...

I'm in search of a talented tattoo artist who can create a unique blackwork tattoo design for me. NOTE: The design is to be based on an existing tattoo (photo is attached, must incorporate this tattoo), but expanded upon with a fresh blackwork twist. ... particularly blackwork style. It's crucial that you've got a keen eye for incorporating sacred geometry and symbolism into your designs. Key Points: - Proficiency in blackwork tattoo style - Ability to artfully incorporate sacred geometry into the design - Understanding of creating symbolism in tattoos, particularly representing enlightenment and spirituality Your creativity and ability to merge these elements will be essential in completing this project. A transfer sheet will be required upon awarding. Looking for...

I'm looking for a skilled freelancer with experience in image stitching using OpenCV. The primary goal of this project is to merge two images into a single image. Project requirements : You will be able to choose 2 grayscale images from the graphical interface. The images will be read from the disk and displayed, and the mouse will be used to choose corresponding points on the images (at least 3). Pairs of dots will be marked with crosses of the same colour in the images, but distinct (random choice of colours) for each pair. After pressing a key a third image will be displayed containing the first image pasted to the second image on a black background. For this, the image registration algorithm will be implemented, which calculates the geometric affine transformation based...

Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.

I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.

...thumbnail and title optimization. - Dive into analytics and user engagement data to constantly refine and improve our strategies. Ideal Candidate: - Proven experience in YouTube SEO, with a track record of improving video ranking and visibility. - In-depth knowledge of keyword research tools and SEO optimization techniques specific to YouTube. - Proficiency in utilizing analytics tools to drive decisions and enhance content performance. - Strong creative skills for developing eye-catching thumbnails and titles. - Passionate about the YouTube platform and staying up-to-date with the latest trends and algorithm changes. If you're ready to join a results-driven team and help businesses across various industries excel on YouTube, we'd love to hear from you. A perfe...

Beginner level freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tab...Question and Answer pdf is given, In the format mentioned above, just add another 3 options in Google sheet, and write the answer in Aiken formatting. Note: The question should be in one line (cell). After Each "ANSWER: X" is marked, the next line/row will be blank. Can you do a sample for the first 3 mcq? Can you do this for a 5-star review and lowest price? Do the sample in the attached Excel file by referring to the PDF attached. For sample, do the 3rd, 4th and 5th question as example in google sheet online and share th...

Please Sign Up or Login to see details.

I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related data entry is advantageous but not mandatory. - Strong atte...

...relevant answers from PDF files content. Experience and Skills: - Strong understanding of natural language processing - Previous experience with developing chatbots - Familiarity with sentiment analysis - Ability to create personalized recommendations for users - Skilled in extracting and understanding content from PDF files - Strong problem-solving skills and attention to detail Details - Upload Excel file containing Expediente Codes - Use automation and OpenCV to solve Captcha and download files - Upload files to s3 bucket - Integration with existing system - use google to authenticate to the system (maybe change to office 365) Requirements: - REMOTE SERVER: Existing server - Access to S3 Bucket - Access to chatgpt api - Access mysql aws instance We need acc...

I need a freelancer to search for the "Business Directory" URL on 342 websites. The websites are in the following sheet (I have added business directory URLs for the first four entries, as a sample): You will search for the business directory URL on each website, then enter the URL in the "Business Directory" column of that Google Sheet. (Note: some websites don't use the exact term "business directory". What I'm looking for is the web page on each site that contains the list of businesses in each city, so the business directory could be called something else, for example "business listings".) The task is a one-time search. My budget is $20. This is an excellent project for a new freelancer who is looking for a 5-star review.

I have two websites that need to be merged with a main focus on consolidating information. The current websites are different in design and themes, and I'm looking for a professional who can successfully merge them into a cohesive, user-friendly site. Key requirements: - Consolidate information: The primary goal is to combine and organize the content from both websites into a single, easily navigable platform. The new website should provide a clear and seamless user experience. - Prioritize by relevance: The content should be arranged in a way that is most relevant to the user. This may involve restructuring and reorganizing information to ensure that the most important details are easily accessible. Ideal skills and experience: - Proficiency in website design and deve...

I need an experienced data entry freelancer who can assist with a high priority task. The project involves inputting data into an Excel spreadsheet and carrying out online data entry tasks. The ideal candidate will be proactive, detail-oriented, and able to work efficiently with minimal supervision.

As discussed, this includes the following - 1. Automated trading functionality in excel using the TWS API 2. Customization of entry and any other rules post discussion 3. Python codes 4. Deployment support and 2-weeks support for smooth operation

I am in need of someone adept in Excel and knowledgeable in medicine, especially in dosages and weight-based calculations. The challenging aspect of this project is to modify an existing locked Excel spreadsheet which is used to calculate dosages once a patient's weight is entered. Tasks involve: - Updating the dosages of specific medications based on the guidelines I have on hand. - Modifying the weight-based formula in alignment to these dosage updates. Skills and experience: - Proficient in Excel and worksheet protection - Comprehensive understanding of medical dosages - Experience or understanding of weight related dosages calculations. I will provide the necessary medication and dosage guidelines to the successful bidder for reference. The idea...

I'm looking for a talented CGI or VFX specialist to enhance the visual appeal of a banner. The purpo...the visual appeal of a banner. The purpose of this enhancement is to create a captivating effect that evokes a futuristic and technological atmosphere. Key Elements: - Realistic Textures: I envision the final product to have a tactile quality that's close to real life. - Dynamic Lighting Effects: A play of light and shadow is essential in achieving the futuristic vibe. Your role will be to merge these elements seamlessly into the banner to create a cutting-edge, visually striking piece. This project will not only require technical skills, but also a keen aesthetic eye for detail and coherence. Experience in similar projects or a strong portfolio in CGI and VFX will be...

...business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a...

I'm looking for an expert in Microsoft Power Apps to develop...the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functional sol...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

...maps. The goal is to clearly illustrate the evacuation routes within the building's layout. Requirements: - The present pdf copy of the floor plans should be converted into an editable format. The preferable formats are Word, Excel, or Editable PDF. - Use color-coding to differentiate the evacuation routes for better clarity. The color to be used for the evacuation routes is Red. Ideal Freelancer: - Proficient in creating and editing floor plans. - Skilled in using software that can create and edit floor plans, such as Adobe Acrobat for PDFs, Microsoft Word and Excel. - Experience working on evacuation plans or similar projects is an advantage. - Knowledge of color-coding and its application within floor plans to ensure the clarity of the evacuation routes. The ...

Start your offer with the word in the attachment, otherwise we dropp you out. We are looking for a database with websites, HAVING EMBEDDED YOUTUBE Videos on their sites...the site, PLZ, City, State, Phone, Mail, Website Niches: Construction Systems in Austria, Germany and Switzerland Phsiotherapeuts in Austria, Germany and Switzerland I would like to have at least 2000 websites with top-quality data. Delivered in 1 day. Delivery in one Excel file. Time of delivery is a key element in our decision. Offer a price for 2.000 data entries. We extend our partners for this kind of task´s. With all of them we have a longterm Partnership. To decide who is our partner and to see your understanding, please provide a sample with at least 50 data entries within 2 ...

...understanding of this field. As a VA, you will play a pivotal role in managing various tasks associated with our crypto-related platforms, including a YouTube channel, social media accounts, a blog, and a Telegram community. Key Responsibilities: Research and Summarization: Conduct research on new crypto products, trading companies, and product features. Summarize findings in visually appealing Excel sheets or Designs or reports for easy comprehension. Partnership Outreach: Reseacrch & Contact potential partner programs to explore collaboration opportunities. Negotiate special deals, such as free products or community discounts, or paid sponsorships. Follow up with potential partners to finalize agreements. To manage inbox and keep it up to date Replying to Inquirie...

I'm in need of a skilled freelancer to assist with some data entry work. While the specifics of the work have not been defined yet, it will likely involve entering data into a database, transcribing written documents into digital format, and/or filling out online forms. The task can involve different formats such as Excel spreadsheets, Word documents, or online platforms.

I have a series of brief game videos that I'd like to merge into a single dynamic and engaging advertisement for my Game. The individual videos are all under a minute in length and I'm looking for a fast-paced, energetic style of editing. I have created this video: I rate it 4/10. I expect yours to be at least 8/10. Deliverables: - Primary Video of 30 seconds in Portrait and Landscape - Secondary Video of 15 seconds in Portrait Resources: 1. Videos are attached. If you do not find them interesting, I can attach more 2. Game Name: "Patterns Puzzle Game" 3. Game Platform: "Android, IOS" 4. Keywords: Relaxing, Interesting, Puzzle, Patterns, Tough 5. Ping me for more details. Key Requirements: - Combine multiple, short videos into one cohesive

I'm seeking to secure funding for a multi-industry workers' accommodation project. The accommodation caters to construction, seasonal farm, wind farm, abattoir, and gold mine workers. For this, I need a professionally crafted project proposal and a corresponding financial model in Excel. Ideal freelancers for this project should possess: - Proven experience in drafting project proposals related to housing or accommodation - In-depth knowledge in the creation of financial models using Excel - A strong understanding of multi-industry accommodations - Great analytical and strategic thinking skills - Familiarity in the Construction, Agriculture, Energy, Food Processing, and Mining Industries would be advantageous.

...Product Manager seeks VBA developer for Excel app development Your resources • Windows 10/11 & MS Office (sorry MS Office MacOS has too many compatibility problems!) • Location with good acoustics, headphones, good internet (so we can have high quality meetings). ESSENTIAL - DO NOT IGNORE THIS! Your skills • Experienced with Excel and Excel VBA coding to professional standards • Good conversational Technical English • Touch typing (we do live meeting notes) • Python OO coding experience would be good Your Technical Knowledge and experience • VBA sufficient so that you can develop (or source and enhance) • Create a professional app/plugin • Create coding standards including trialling GITHUB integration • La...

I'm looking for assistance with online data entry to Excel. The task is not overly complex but will involve working with reference numbers and ensuring accurate data entry and cross-referencing. Full training will be given and I will explain all. Budget is hourly and $3 max need to have good understanding of English

I'm in need of an app developer who can create a straightforward, yet efficient application for both iOS and Android. Key Features: - User Portal: This will be the main entry point for users. It should be user-friendly and intuitive. - Document Import: Users should be able to import documents into the application. - Document Merging: The app should have the capability to merge documents. - Text Processing: The application should be able to process text. File Formats: - The app should support the following file formats for document import: PDF, Word (docx), and text files. The ideal candidate for this job should have: - Proficient in both iOS and Android app development. - Experience with document processing and merging. - Knowledge of file format compatibility. Please prov...

...generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing so...

...or Amazon VA. • Excellent verbal and written communication skills in English with clients • BSc/BA in Business and/or Marketing from an English speaking institute preferred • Solid organizational skills to timelines, tasks and documentation across multiple accounts • Expert knowledge of Amazon flat file upload (Seller Central & Vendor Central) • Advanced knowledge of Microsoft Office (expert in Excel) • Experience using project management platforms (Trello) • Able to analyze workload and tasks to estimate turnaround times • Fluent in English, other EU languages is a plus • Strong attention to detail • Analytical skills • Research and Problem solving skills • Strong interpersonal skill • Most importantly be passi...

I have a 1-page Excel spreadsheet with 9 text columns that need to be merged. I'm looking for someone who can start this job immediately and has experience in Excel data manipulation and formatting. Please only bid if you can do this job immediately and I will award and give you the file.

I'm seeking an expert in Excel analytics. This project involves working with existing but undisclosed business data to help me understand and optimize the business's performance through indicators like KPIs. The freelancer's task encompasses: - The creation of robust dashboards that effectively communicate KPI outcomes. - The execution of classification analysis to differentiate key data points. - Clustering the data into discernable patterns to aid business decision making. Ideal skills for this job include Excel proficiency, data analytics experience, and an understanding of key business metrics such as KPIs, dashboards, classification, and clustering. A background in business data analysis and the ability to assign meanin...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design princi...

...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on

I'm in need of a professional who is highly skilled in Excel for a project involving 4-color conditional formatting. The project will focus predominantly on numerical data. Here are the essentials: - Proficiency in Excel is crucial - Deep understanding of 4 color conditional formatting, specifically with numerical data - Experience with setting color-coding based on specific values I'm looking for an expert who can swiftly and accurately apply this formatting to a substantial amount of data. Thanks for considering bidding on this project.

I HAVE A WORD DOCUMENT THAT FEEDS VIA AN EXCEL SHEET VIA A COMPLEX VBA .. I need the following to addede: Split of Clients for Buys, Sells, Buy/Sell Spreads, Brokerage, Management Costs Currently, the Excel only allows the input of trades for one client, however, we’d like to have this broken up to at least 3 clients (I remarked client and partner in the meeting, however, we have some clients who have an account each, plus a joint-account).

...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...

I'm in need of a creative logo designer who can craft a unique and visually appealing logo for my new automotive business. The ideal candidate will have a good understanding of modern and vintage design aesthetics, and the ability to merge these two styles seamlessly. Key Requirements: - Modern and Vintage Style: The logo should reflect a blend of modern and vintage design elements. - Warm Tones: I prefer warm color tones such as reds, oranges, and yellows. - Automotive Theme: The logo should incorporate elements or symbols that are related to the automotive industry, but the design approach should be creative and unique. Ideal Skills: - Proficiency in graphic design software. - Strong portfolio that showcases creative and unique logo design work. - Excellent understanding of...

I find myself in need of a skilled freelancer to restore my suspended Google Business account. My account was suspended due to exceeding the storage limit, and I have been unable to fix this issue myself. The professional perfect for this job should excel in: - Google Business account restoration - Dealing with suspension issues, specifically exceeding storage limit - Providing tips and guidelines on how to avoid future suspensions due to storage issues The task includes confirming the suspension reason, working towards resolving it, and ensuring resumption of the account. Knowledge on dealing with Google's support system would be highly advantageous. Looking forward to working with you.

I need a freelancer to help me type text from digital files to an Excel spreadsheet. - The data you will be typing is textual in nature, with the content coming from digital files. The final output should be an organized and error-free Excel spreadsheet. - Attention to detail is crucial. The ideal candidate for this job will have experience with data entry, exceptional typing speed and accuracy, and a track record of working efficiently with digital text and Excel. Please be sure to include any relevant experience and your estimated timeframe for completing this task.

...registration, excel upload, and assigning packages. Key Requirements: - Develop a user registration system: The module should collect the following user information: Name, Email address, Phone number, password, course, batch. - Implement an excel upload feature: Users should be able to upload excel files select of course and batch - Enable package assignment: The module should allow for the assignment of packages to users. while user registration or excel upload Ideal Skills and Experience: - Proficient in PHP: As the app is built on this platform, a strong expertise in PHP is essential. - Experience in user registration systems: The successful candidate should have experience in creating user registration modules. - Excel upload integration: Experie...