Vba compare worksheets työt
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.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Looking for an expert in Oracle Integration Cloud to assist with my tasks in application integration and process automation. The integration should compare two files on the FTP, and send an email to the recipients. - In-depth understanding of Oracle Integration Cloud - Strong knowledge in Application integration - Process automation skill set - Ability to advise on best integration strategies
...talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enhancements without disrupting existing functionalities. Key Featu...
...and data entry project. This task involves purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 29 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 29 bottles must be labeled in a manner that correlates with the entered data, ensuring no discrepancies. - **Shipping Coordination:** Prepare the samples for ...
...and data entry project. This task involves purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 4 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 4 bottles must be labeled in a manner that correlates with the entered data, ensuring no discrepancies. - **Shipping Coordination:** Prepare the samples for sh...
...translation Your assignment: The tasks will contain a question and 2 answers to it written in Japan. All instructions will be provided in English. 1) You will evaluate these 2 answers across 6 categories (safety, writing style, verbosity, followed instructions, truthfulness, overall quality). For example, “safety” indicator means presence of toxic or offensive language and so on. 2) You will compare the two statements and decide which one is a better answer to the question 3) You will provide a brief justification to your decision You are our perfect candidate if: - You are a native-level fluency in Japanese or have a C1 certificate of Japan - Your English proficiency is fluent - Your laptop meets requirements: RAM from 6 GB, Windows 10+ or iOS - You have stable...
I'm searching for a professional well versed in Excel to help with lookup functions. I'm struggling with finding matching values and retrieving data from different worksheets in a text-based file. Key parts of this project: - Locating matching values across two worksheets - Retrieving needed text data from another worksheet The ideal candidate will have: - Strong proficiency in Excel lookup functions - Experience dealing with data across multiple worksheets - Understanding of text-based data within Excel
...further analyses from Tasks 4f and 4g as the basis for improving the model, construct 2-3 plausible scenarios that will improve the confidence that at least half of all samples from one week are processed in 24 hours or less. b. Modify at least two stages of the model (these must be reasonably unique – do not copy scenarios from others). c. Rerun simulation model with the same random number seed and compare results to that produced in Task 4. d. By plotting and comparing relevant probability distributions, explain how your modified scenario has reduced the time taken to process samples, and how it has impacted the likelihood of processing samples in under one day. 6. Insights and recommendations a. In your report, provide a short summary of your insights and recommendations...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
Dough one Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical kno...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
The app is supposed to: - Search for specific product and add it in the cart with all needed information: delivery location, accessories, quantity. (Example: HP laptop with 14in size) - Compare the product price and service quality in the platforms and give results of the comparison. ( example: price in Amazon for the laptop is 1000$, delivery time is 3 days, the reviews are 4 star. Same for other platforms) - Direct the user to the selected platform to complete the purchase. (Example: to purchase the laptop from Amazon)
I'm looking for a VBA expert who can help me automate the modeling of intermediate mechanical components in Autodesk Inventor. Key Requirements: - Automate part modeling in Autodesk Inventor - The parts to be modeled are intermediate mechanical components, such as gears and brackets - The VBA code should allow user input for customization of the parts, specifying dimensions and features Ideal Skills and Experience: - Proficient in VBA programming - Previous experience with Autodesk Inventor - Strong understanding of mechanical components and their modeling - Ability to incorporate user input into VBA code for part customization This project is perfect for someone who enjoys automating processes and has a good understanding of mechanical engineering prin...
I'm looking for a competent Java developer to assist with the development of several data structures and algorithms. In this project, you will conduct a set of experiments to compare the performance of dictionary implementations that use unsorted arrays vs. sorted arrays. You are given the Dictionary interface () and its implementation class (). In addition, the file contains a list of 10,000 key-value pairs that represent certain measurements. Key Skills: • Expertise in Java programming • Extensive experience with diverse data structures and algorithms • Ability to adapt to fluctuating project requirements Your ability to create powerful, flexible systems with Java will be crucial for this undertaking. Though the
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
I need an Excel VBA code that can perform exact word matching within an Excel spreadsheet. - The code should generate a list of matched words.
Input:- You will get an excel file as input. Step1- Sort the Excel file by site name and place data in sheet 1 Step2- Sort the Excel file by site address and place the data in sheet 2 Step3- Sort the Excel file by latlong and place the data in sheet 3. After Sorting and creating 3 different sheet, we ne...in sheet 2 Step3- Sort the Excel file by latlong and place the data in sheet 3. After Sorting and creating 3 different sheet, we need to apply the logic to find exact duplicate and high match. Example - means in sort by site name we will find exact duplicate and high match site(75%) match and print exact duplicate/ partial match. Then for exact duplicate and partially match we are going to compare all row and need to print what is matching like site city, site state, site c...
...engine website targeted towards budget travelers. This platform will be focused on providing a unique and efficient way to find niche flights. Key Features: - Advanced search filters: The website should offer a variety of filters to help users tailor their search and find the most relevant flights. - Price comparison functionality: An essential feature for budget travelers, allowing them to easily compare prices of flights. - User reviews and ratings: An interactive section where users can share their experiences and rate flights, enhancing the overall user experience Target Audience: The primary target audience for this platform will be budget travelers. The design and functionality of the site should cater to their specific needs and preferences. User Interface Design: The i...
...The report should contain data from the MySQL database, calculations or summaries of data, visualizations or charts, and be structured as a paginated report, using SQL language. The report should be designed to be accessed as a printable PDF document. It is not required to be interactive, as a static report is sufficient for my needs. Key Requirements: - Proficiency in Microsoft Access, MySQL, VBA, PDF, Python, and Excel - Competency in SQL language for data manipulation - Experience in designing paginated reports The ideal candidate should have a proven track record of creating similar reports, with the skills and knowledge necessary to work with the specified technologies. Your ability to deliver a professional, well-structured, and visually appealing report within the give...
I require an experienced data analyst conversant with Excel to create a detailed spreadsheet and comprehendible report about compression pay between LPN & RN nurses, as well as ...and current salary in 2024 2).The FA (Fair Acres nursing) leadership file highlights all Nurse supervisors/managers ( uses this for comparing salaries. (also note their start dates are listed in column "O") 3).The Fair Acres employee list is a list of all employees. I've highlighted in "green" & "pink" the LPN nurses and the RN nurses ( nursing category employees notes on file) you are to compare the .The FA (Fair Acres nursing) leadership file and the Fair Acres employee list (pink & green). This is the data you will be working with. Please let me know ...
As a professional with high-volume data, I'm seeking a highly skilled Excel expert. You should have proficiency in: - Data analysis - Data visualization - Excel formulas, functions and macros - Visual Basics Application (VBA) I'm dealing with more than seven datasets, each one having high complexity (many columns and over 5000 rows). I will need your expertise in managing and understanding this data. Ability to quickly comprehend and adjust to new data structures would be advantageous. Proven experience with large data sets and advanced Excel usage is a must for this project. Please include examples of previous similar work in your proposal.
2 excel files with VBA macro as per customer requirement
One excel file with macro as per the customer requirement
I'm looking for a professional WordPress developer to create a comprehensive comparison platform for Uber and Lyft, including a blog and a forum. The goal is for users to be able to easily compare the prices for these services. Key Features: - **Fare Comparison**: The main feature of the site will be a real-time price comparison between Uber and Lyft. This should include: - **Distance Calculation**: The system should be able to calculate the distance between two points. - **Fare Estimation**: Users should be able to get an estimation of how much a trip would cost with each service. - **Real-time Price Comparison**: The site should be able to directly pull the current prices from both Uber and Lyft to allow for a real-time comparison. Other Functionalities: - **Use...
We are seeking a talented freelancer to develop a fare comparison website that allows users to compare prices between ride-sharing services Uber and Lyft. The website should provide an intuitive interface for users to input their trip details and receive real-time fare estimates from both platforms. Once users have compared the fares, they should be able to seamlessly redirect to the Uber or Lyft app to book their ride. Additionally, we want to incorporate a blog and forum section to foster discussions and provide valuable information for both drivers and riders. Skills Required: Proficiency in PHP, Laravel framework, HTML, CSS, and JavaScript Experience with API integration (Uber and Lyft APIs) Strong understanding of web development and design principles Ability to create secure,...
We are seeking a talented freelancer to develop a fare comparison website that allows users to compare prices between ride-sharing services Uber and Lyft. The website should provide an intuitive interface for users to input their trip details and receive real-time fare estimates from both platforms. Once users have compared the fares, they should be able to seamlessly redirect to the Uber or Lyft app to book their ride. Additionally, we want to incorporate a blog and forum section to foster discussions and provide valuable information for both drivers and riders. Skills Required: Proficiency in PHP, Laravel framework, HTML, CSS, and JavaScript Experience with API integration (Uber and Lyft APIs) Strong understanding of web development and design principles Ability to create secure,...
We are seeking a talented freelancer to develop a fare comparison website that allows users to compare prices between ride-sharing services Uber and Lyft. The website should provide an intuitive interface for users to input their trip details and receive real-time fare estimates from both platforms. Once users have compared the fares, they should be able to seamlessly redirect to the Uber or Lyft app to book their ride. Additionally, we want to incorporate a blog and forum section to foster discussions and provide valuable information for both drivers and riders. Skills Required: Proficiency in PHP, Laravel framework, HTML, CSS, and JavaScript Experience with API integration (Uber and Lyft APIs) Strong understanding of web development and design principles Ability to create secure,...
We are seeking a talented freelancer to develop a fare comparison website that allows users to compare prices between ride-sharing services Uber and Lyft. The website should provide an intuitive interface for users to input their trip details and receive real-time fare estimates from both platforms. Once users have compared the fares, they should be able to seamlessly redirect to the Uber or Lyft app to book their ride. Additionally, we want to incorporate a blog and forum section to foster discussions and provide valuable information for both drivers and riders. Skills Required: Proficiency in PHP, Laravel framework, HTML, CSS, and JavaScript Experience with API integration (Uber and Lyft APIs) Strong understanding of web development and design principles Ability to create secure,...
We are seeking a talented freelancer to develop a fare comparison website that allows users to compare prices between ride-sharing services Uber and Lyft. The website should provide an intuitive interface for users to input their trip details and receive real-time fare estimates from both platforms. Once users have compared the fares, they should be able to seamlessly redirect to the Uber or Lyft app to book their ride. Additionally, we want to incorporate a blog and forum section to foster discussions and provide valuable information for both drivers and riders. Skills Required: Proficiency in PHP, Laravel framework, HTML, CSS, and JavaScript Experience with API integration (Uber and Lyft APIs) Strong understanding of web development and design principles Ability to create secure,...
...Here are the detailed requirements: Fare Comparison: Implement a user-friendly interface with a search box that includes auto-suggestions for addresses. Users should be able to enter their pickup and drop-off locations effortlessly. Utilize the Uber and Lyft APIs to fetch real-time fare estimates for the specified route. Display the results in a clear and informative manner, allowing users to compare the fares side by side. Ensure that the API integration is secure and adheres to the respective API guidelines and rate limits. Redirect to Uber/Lyft: Once users have compared the fare estimates, they should have the option to proceed with their preferred service. Upon clicking on either Uber or Lyft, they should be seamlessly redirected to the respective company's website or...
I need a WordPress website developed with specific features and functionalities. The main purpose of the website is to allow users to compare fare estimates between Uber and Lyft for a given route. Here are the detailed requirements: Fare Comparison: Users should be able to enter their pickup and drop-off locations in a search box with auto-suggestions for addresses. The website will then display the estimated fares for both Uber and Lyft for the specified route. Once the user clicks on either company, they should be redirected to the respective Uber or Lyft website to complete the booking. Forum: Implement a forum section where drivers and riders can discuss various topics related to their experiences with Uber and Lyft. This includes discussions on fares, driver/rider safety, a...
I need a WordPress website developed with specific features and functionalities. The main purpose of the website is to allow users to compare fare estimates between Uber and Lyft for a given route. Here are the detailed requirements: Fare Comparison: Users should be able to enter their pickup and drop-off locations in a search box with auto-suggestions for addresses. The website will then display the estimated fares for both Uber and Lyft for the specified route. Once the user clicks on either company, they should be redirected to the respective Uber or Lyft website to complete the booking. Forum: Implement a forum section where drivers and riders can discuss various topics related to their experiences with Uber and Lyft. This includes discussions on fares, driver/rider safety, a...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and d...
I need a WordPress website developed with specific features and functionalities. The main purpose of the website is to allow users to compare fare estimates between Uber and Lyft for a given route. Here are the detailed requirements: Fare Comparison: Users should be able to enter their pickup and drop-off locations in a search box with auto-suggestions for addresses. The website will then display the estimated fares for both Uber and Lyft for the specified route. Once the user clicks on either company, they should be redirected to the respective Uber or Lyft website to complete the booking. Forum: Implement a forum section where drivers and riders can discuss various topics related to their experiences with Uber and Lyft. This includes discussions on fares, driver/rider safety, a...
I'm seeking a skilled developer to take my existing demo code and bring it to the next level. The application is web-based and is intended to automate the extraction of data from Word and Excel documents, and then compare the data for consistency. Key Responsibilities: - **Improved Data Extraction Accuracy:** The code should be enhanced to improve the accuracy of the data extraction process. The developer should implement robust methods to ensure that all necessary data is correctly captured. - **Enhanced Comparison Algorithm:** The comparison algorithm should be optimized to better handle the extracted data. The developer should ensure that the comparison is done accurately and efficiently. - **User-Friendly Interface:** The current demo code lacks a user-friendly interface. ...
MATLAB USERS Visual Processing and Object Detection: The first task will be to detect and segment objects in images using traditional computer vision methods. It will be necessary to automatically separate the balls from the background and evaluate the accuracy of the segmentation. Feature Calculation: The second task will be ...will be to extract texture and shape features. By using appropriate algorithms to calculate the shape attributes of the balls, it will then obtain textural attributes with gray level collaborative matrices. Object Tracking: The third and final task will be to track the movement of a ball by applying a Kalman filter. Working with real and noisy coordinates, it will create a tracking algorithm and compare the tracked path with the real one. summarize this in...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
I need an Excel...Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in creating tools that can handle daily data updates would be ideal. If you have experience with similar projects, please provide example...
I need a seasoned VBA and Macro expert to assist me with the creation of an interactive dashboard for a small project. The main tasks include: - Development of VBA code to automate repetitive tasks. - Creation of custom functions to enhance the dashboard's functionality. - Ensuring the dashboard can generate reports effectively. I'm specifically looking for someone with: - Proficiency in VBA and Macro. - Previous experience in creating interactive dashboards. - Ability to generate reports through coding. - Good communication skills and attention to detail. If you're confident in your VBA skills and have a good eye for visualizing data, I'd love to discuss this project with you.
I have an existing VBA application that performs various calculations. I need to convert the VBA application to a Python-based desktop application. Key Requirements: - The converted application should perform the same calculations as the original VBA application. - The application should have a user-friendly GUI for easy input and output. - I am looking for a programmer with experience in both VBA and Python, to ensure a smooth and accurate conversion. Ideal Skills: - Strong proficiency in VBA and Python. - Experience in desktop application development. - Knowledge in creating user-friendly GUIs. - Ability to accurately replicate functionality from VBA to Python.
The draft literature review will be assessed on how well you address the following criteria: Relevant choice of four (4) journal articles related to the topic of the qua...address the following criteria: Relevant choice of four (4) journal articles related to the topic of the qualitative study - factors affecting hotel customer satisfaction. Correct use of APA7 Referencing both in-text and in the reference list Clearly and succinctly explaining the content of the article and key findings within the word count of 500-600 words (excluding the reference list) Ability to compare and contrast the four (4) journal articles (published no earlier than 2012) Ability to accurately identify any limitations of each study/paper (within the journal articles) Must use 12 font, Times New Roman, 1....
As the client for this project, I urgently require an expert in VBA.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
I'm looking for a solution to generate QR codes within an Excel document. The QR codes will be primarily used for URLs. The Attached Document Need Text Data from "Sheet Data" Column A into B2 Need Text Data from "Sheet Dat...based on the URLs provided. - Implementation of standard QR codes: Custom designs are not required. The focus is on generating functional, standard QR codes. - Ease of use: The end-user will be working in Excel, so the implementation should be user-friendly and seamless within the Excel environment. Ideal Skills and Experience: - Proficiency in Excel: A deep understanding of Excel formulas and VBA scripting is essential for this project. - Experience with QR code generation: Prior experience with generating QR codes, especially within Exce...
Looking for an expert in Excel VBA and Macros to automate various processes in my work-flow. Here's the brief rundown of the task involves: - Automated data analysis which includes summarizing data, filtering, Slicers, automatic calculation, and the visualization of data. - Creation of a Custom excel automatic dashboard for real-time reporting and data visualization. Ideal Skill-Set: You should be knowledgeable and experienced in the use of Excel VBA and Macros for automation. Prior experience in VBA, Macros, data analysis and report generation would be a major advantage. Familiarity with automated summary, filtering, Slicer and calculation methods is essential; knowledge of using Macros to create dashboards for real-time reporting is key. If you can meet th...
I'm looking for an experienced VBA programmer to extend and modify the existing 'getpdf' project. The key focus is on integrating it with Microsoft Excel. Key Responsibilites: - Integration with Microsoft Excel: This involves extracting data from Excel files and downloading data from VBA which is PDF-based data, renaming it, and using Selenium. Ideal Skills: - Strong VBA programming skills. - Proficiency in integrating VBA with Microsoft Excel. - Experience with Selenium for web data extraction. - Prior work with GETPDF data extraction preferable.
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to create user-friendly interfaces for Excel.
