Compare worksheet excel vbnet Jobs
This is a one of project; I'm looking for an Excel expert to develop a workbook enabling data analysis of multiple bank and credit card statements. This workbook must have the ability to run multiple functions/reports - Implementation of SUM and COUNT functions. - Utilization of VLOOKUP or HLOOKUP. - Creation of Pivot Tables and informative Charts. The ideal candidate would be someone with prior experience in financial analysis or data engineering, who can ensure that the workbook provides the insights needed. Ability to ensure accuracy and relevancy within the formulas and functions is essential. Attached is a sample data file. This is a pdf to excel conversion. Prior to submission, the conversion data will be sanity checked and verified. If an alternative format...
Bitte melde dich an oder Loge dich ein um Details zu sehen.
I have an Excel sheet with some data that needs a basic clean-up. I'm looking for someone who can help me with this task. Key Responsibilities: - Remove duplicates from the data - Ensure the data is clean and free from any inconsistencies This task is fairly straightforward and doesn't require any advanced data cleaning techniques. It's more about ensuring the data is accurate and removing any unnecessary repetitions. Ideal Skills: - Proficiency in Excel and data entry - Attention to detail - Ability to follow instructions and deliver work accurately and on time This project is ideal for someone who is starting out or looking for a quick task to complete. If you're good with Excel and data management, this would be a good fit for you.
I need an Excel expert to create an advanced sheet for employee management. This sheet would primarily serve two types of employees, sales and telecallers, and perform multiple significant tasks. Key Features: - The sheet should calculate sales data and commissions. - It must track daily leads assigned to the sales team. - It needs to generate reports on business shared between telecaller and sales teams. Design Requirements: - The design should be simple and minimalistic. - It must have color-coded cells for easy interpretation and usage. As the Excel version was not specified, the sheet should ideally be compatible with multiple versions to ensure smooth operation. Ideal Skillset: - Advanced knowledge of Excel. - Experience in creating sophisticated Excel...
I'm looking for a developer to create an airdrop script specifically for Solana SPL. The main aim of this script is to distribute tokens to a specific, pre-selected group of Solana SPL addresses/wallet. The script/app able to read the list of addresses/wallet from txt or Excel . The distribution needs to be fully automated, without requiring any manual intervention. The amount of tokens need to be specific or random from 100 to 1000 etc. Also be able to adjust the Sol sending fees. Key requirements: - The script should be designed to distribute tokens to only a specific, pre-selected group of Solona SPL users, not all users. - It should be fully automated, meaning the distribution process should not involve manual intervention. Ideal skills and experience: - Proficiency in de...
New freelancer welcome, I'm in need of a virtual assistant to help with my project , quick copy-paste job. My need video clip copy and pasts Excel sheet. I will give video link just need copy time clip. Ideal Candidate: - Proficiency in copy-pasting tasks - Ability to complete the task within a few hours - Experience in virtual assistance would be a plus. Looking forward to working with you! More discus with freelancer chat. Need strong freelance. Thanks
I want my existing website to be redesigned to have a modern, new look. The existing website is one page, but I want the content to be split into sub-pages: Home, Features, Compare, About and Buy. These sub-pages shall have the current website's content. The design must support Dark Mode / Light Mode selection similarly as the current existing website does. This project is only for the design, there is no implementation. If I like the design that you make, I will also hire you to do the implementation. The implementation will be no CMS, just PHP + Bootstrap + jQuery. If you want to use any third party resources (fonts, images, libraries, modules etc), they must be pre-approved before using them. This project does NOT include logo design, the existing logo will be used
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I'm looking for an Excel expert to create a custom software for me. The software should primarily focus on automating spreadsheet tasks and presenting data in a visual manner. Key Requirements: - **Spreadsheet Automation**: I'm seeking a solution that can automate various tasks within Excel, reducing manual work and minimizing errors. - **Data Visualization**: The software should also have the capability to visualize the data from my local files. The visualizations should be in the form of static charts and graphs. Ideal Skills and Experience: - Advanced Excel Skills: You should have extensive experience with Excel, including creating complex formulas, using VBA for automation, and chart creation. - Data Visualization Expertise: A strong understandi...
I am looking for a proficient movie reviewer to write a two-page critique on the plot of the movie, "Civil War". This review should be focused on identifying and discussing the plot holes. - Identify and discuss major plot holes in the movie. - The review is not just about spotting the plot holes, but also providing an engaging a...engaging and insightful analysis of these inconsistencies in the storyline. - Give a comparison of "Civil War" to other movies in the similar genre and how it stands out or falls flat. The ideal candidate would be someone with an extensive background in film studies, understanding of plot development, and experience in writing movie reviews. Familiarity with the genre of the movie and ability to compare it with other films effectivel...
I'm looking for a data entry operator who can assist me with cleaning, verifying and entering a small volume of data from handwritten documents. - The task involves verifying data for accuracy, identifying and correcting errors, and entering the information into an Excel or CSV file. - The data volume is small, around 1,000 records, making it an ideal project for someone who is detail-oriented and meticulous. Ideal candidates should have: - Experience in data entry and data cleansing tasks - Proficiency in using Excel or CSV files - High level of attention to detail - Ability to work with handwritten documents If you possess these skills and are interested in working on this engaging project, please submit your proposal.
I would like to create a solution (can be EXCEL, etc.) for creating working schedule, your solution must have these features: 1. Allow multiple locations, with different schedules and number of workers; 2. Setup multiple workers, set dayoff, hours per week, min hours per day and max hours per day; Example: The worker can have 2 days off (w2 = Monday, w3 = Tuesday, …), should work 48 hours per week, and 5 until 8 hours per day (in sequence, 10:00 – 15:00). 3. Views per week, per month (and per location or per worker) – generate a week / month schedule per location and per worker. 4. A random button to regenerate all again 5. And a button to make equilibrium (YES or NO), with YES on this button, your solution will try to adjust the schedule to ensure the &ldquo...
I have given Start time, Interval, End time in excel When i give start time(Ex:9:15), when that time reached E col data automatically copied in into G col, Next Interval is 10 Mins, When 9:25 reached E col data automatically copied in into H col, When 9:35 reached E col data automatically copied in into I col,When 9:45 reached E col data automatically copied in into J col, When 9:55 reached E col data automatically copied in into K col, When 10:05 reached E col data automatically copied in into L col, When 10:15 reached E col data automatically copied in into M col.(H col vale > G col, that cell is green, H col vale < G col, that cell is red, same process for all col) 9:15-9:25 is 1 10Mins during that time, how many time(count) E col value>G col value( Ascending not dece...
Bitte melde dich an oder Loge dich ein um Details zu sehen.
I'm in need of a professional who can accurately convert scanned PDFs into Excel. 3 different sheet for each supplier. The PDFs are inventory sheets that need to be organized by item number. These sheets will be used for inventory management, so it's crucial that the data is correctly transposed. Key Requirements: - Convert scanned PDFs to Excel - Organize data by item number - Implement conditional formatting to ensure data accuracy Ideal Skills: - Proficiency in data entry and conversion from PDF - Advanced Excel skills, especially in organization and conditional formatting - Experience with inventory management or similar data handling is a plus I look forward to receiving bids from professionals who can guarantee quick and accurate work.
...API. The ideal candidate will have experience in API integration and database management. Key Project Requirements: - Implement a bulk upload feature for FNSku to ASIN conversion - Utilize Amazon API to extract the ASIN number from the given FNSku - Develop an API database to store and retrieve the ASIN number and the FNSku Additional Functionalities: - Ensure the system allows bulk upload of Excel files - Incorporate the ability for users to download the conversion results - It's essential that results can be downloaded in a specific format, and in this case, directly to an API database. Ideal Skills and Experience: - Prior experience with Amazon API integration and product data extraction - Proficiency in bulk data processing and manipulation - Strong understanding of d...
...containing text data. Post scanning, these QR codes should display the text information incorporated while creating the codes. Furthermore, the software needs to house an Excel Workbook, which should be updated through manual uploads. The Workbook will be responsible for printing the necessary details derived from the CSV file. In addition, the software should also be engineered to retrieve cellular data upon scanning the QR code. Ideal Skills: - Proficiency in developing web-based software - Extensive knowledge in handling CSV files - Expertise in QR code generation and functionality - Experience in managing Excel Workbooks - Able to incorporate manual uploads - Experience with cellular data retrieval from QR scans. This entails a complex task, requiring ...
I'm in need of a versatile data scientist who can expertly navigate both Python and R. For this assignment, you should be proficient in various data analysis techniques including: - Predictive modeling - Data visualization - Statistical analysis The dataset I'll provide comes in Excel format. Your task will be to demonstrate these techniques in Python and R as accurately as possible. Please submit a bid if you're confident in your ability to efficiently illustrate professional-level data analysis in both languages. For now, I only need Part 1 and Part 3 to be done. Part 1 has multiple subparts and should be done in R language. While Part 3 should be done in Python
I need a word document translated from English to Japanese as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I need a word document translated from English to Turkish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
I need a word document translated from English to Spanish as soon as possible. The file has 800 words. Need high quality human translation only. Google/AI or automatic software works are not allowed and will be rejected. Need the translation back in word document format maintaining the formatting and layout of the source file. I would also need an excel sheet prepared, with source texts in column A and translation column B. Need this to be done within 5-6 hours of awarding the project. Bid only if you are available to do it now. Price: 12 CAD fixed. Deadline: 5-6 hours max Don't bid if you don't agree the price and timeframe. Thanks!
...develop a digital scorecard in Microsoft Excel. The ideal candidate will have experience in Excel data management, visualization, and automation functionalities. Key Requirements: - Microsoft Excel proficiency: The digital scorecard will be based on Microsoft Excel, and as such, the freelancer must be highly skilled in this software. - Data entry fields: The scorecard should have user-friendly data entry fields, allowing for the easy input of information. - Interactive charts and graphs: The scorecard should include interactive charts and graphs that visually represent the data. - Automated calculations and summaries: The scorecard should automate calculations and summaries based on the data entered. Skills/Experience: - Proficiency in Microsoft Excel...
I am in need of a skilled data entry freelancer to assist in inputting textual data from digital files into an Excel spreadsheet. Key Responsibilities: - Accurately inputting textual data into an Excel spreadsheet. Ideal Skills and Experience: - Proficiency in data entry, particularly with textual data. - Familiarity with Excel and the ability to work efficiently with spreadsheets.
Good day. Trust you're well. I have a project that I need to download multiple PDF documents from website and compile them into 1 excel spreadsheet. Would you be willing to help with this?
I am looking for an Excel VBA script coder to assist me with a project for generating tags for e-commerce products from the description. Products are car spare parts. Need to tag the products with names of make, model, variant. Specific requirements: - - Generate tags for e-commerce products in a excel sheet. The product description is saved in Column A and the tags should be generated by referring to the list of available tags. Please see the excel sheet attached here. _ One product can have multiple tags associated with it from the tags list, The VBA script should run and generate tags while referring to the data in other sheets for tag names. Please see the excel sheet attached. Ideal skills and experience: - Proficiency in Excel VBA script coding -...
...details, but I need a more comprehensive, automated solution. The tracker will need to detail: - Crop type (specializing in fruits and vegetables) - Quantity harvested - The date of harvest - The sale price of each item - Purchaser name - Remaining stock (calculated by subtracting the amount sold from current inventory) Ideal skills and experience for this project would include Google Sheets or Excel expertise, incorporating automated calculations, and the ability to create a user-friendly layout. Knowledge of or experience with farming or agriculture would be a bonus but is not a requirement. The key for me is accuracy and simplicity. A system that is too complicated or prone to errors won't save me any time. I look forward to working with someone who can help streamline ...
...served per cashier to optimize checkout processes and improve service efficiency. Worker Activity Recognition: Analyze personnel activities on-site to boost productivity and ensure compliance with operational protocols. Construction Site Applications Safety Gear Compliance: Ensure all workers wear mandatory safety equipment, such as helmets and vests, using video analysis. Progress Monitoring: Compare ongoing work against blueprints or 3D models to monitor progress and ensure adherence to plans. Defect Detection: Identify structural problems or deviations from specified standards in real-time, allowing for prompt corrections. Resource Allocation and Management: Track the location and usage of machinery and equipment to optimize workflows and reduce downtime. Risk Assessment and ...
I'm looking for a professional who specializes in cleaning text data to help me with my project. Key Responsibilities: - Identify and remove duplicates within the text data - Correcting typos, spelling mistakes, and grammatical errors - Standardize the data in terms of formats and consistency I need someone who can handle this project within a month. Ideal Skills: - Proven experience in data cleaning, specifically with text data - Proficiency in text mining and natural language processing - Attention to detail and accuracy - Effective communication skills to keep me updated on the progress of the project. If you have these skills and are available to start working on the project as soon as possible, I'd love to hear from you.
1- Convert the excel data to Sage300 GLGE entries: Help in converting data from the excel details data to Sage300 excel format to import them directly inside Sage 300 ERP to create the needed GLGE entries automatically. 2- Support Sage300 Integration (AM Acquisition app): The application you developed previously needs an update. In the current process of creating Acquisition Entries based on shipments, all items are being transferred to the Fixed Asset module, irrespective of the data. The necessary update involves ensuring that only records with relevant data are migrated automatically when shipments are loaded in the application. Specifically, records without asset details (Sage optional fields) should be flagged as ignored. This flag should provide the user wit...
I need a proficient data entry operator to assist a task involving typing handwritten documents into Excel spreadsheets. The ideal candidate would have previous experience in data entry, and a high speed typing ability. Accuracy is key in this project, as they'll be transcribing valuable information, it's critical every detail is correct. Time management skills are also important, as there's a specific deadline to complete the task. If you've done similar jobs in the past, please mention it in your proposal. I look forward to working together.
I need help populating an Excel sheet with 378 company websites. - The task involves searching the internet for the website of each company and entering it into the Excel sheet. - If a company doesn't have a website, please mark it as 'No Website'. - All URLs should be inserted in a new column in the existing Excel file. I would prefer the URLs to be in the format '' or ''. Ideal Skills: - Proficiency in Excel and web research. - Attention to detail to accurately populate the data. - Strong communication to flag issues or ask questions during the process.
Any one experienced with octoparse or any other web scrapping tool can easily complete this straight forward web scrapping project. Please see this google drive link for instruction and check attached excel where sample scrapping is done for you.
...analyst to organize and create detailed furniture packages for various property types and customer segments. The goal is to systematically structure these packages in Excel, covering multiple styles and accommodating property sizes from studio apartments to 4-bedroom homes. Each style will cater to different client types: holiday homes, new homeowners, expats, and investors. ### Objectives - **Create Defined Furniture Packages**: Develop comprehensive lists of items included in each package tailored to specific client types and property sizes. - **Organize Data Efficiently**: Present the data in a clear, accessible format in Excel that allows our team to understand and utilize the information effectively for sales and marketing strategies. ### Scope of Work 1. **Data Org...
I'm in search of a talented and hard-working freelancer to help me with an Excel task. The job at hand is complex and demands someone with strong analytical skills and attention to detail. The primary objective of this project is to achieve a high level of accuracy and efficiency in the output. Thise means that the quality of work is paramount. To succeed in this role, you must have a good understanding of Excel, be able to think logically, and work meticulously. Key Skills & Experience: - Proven track record in Excel data management - Strong analytical and problem-solving abilities - Attention to detail - Ability to work autonomously I look forward to receiving your application, and I will be in touch with the successful candidate soon.
...streamline the process of time-stamp duration reporting in Excel. The solution I'm seeking should ideally have the following components: I have a report (excel-sheet) exported from a system that I use in a weekly basis, however in this report, the date and time of processing exported in a form of “timestamp” and in order to calculate elapsed time of each stage in cycle, every time I have to do the followings: - Fix the format issue in excel since system always export data in a form of “timestamp” and there is no to fix that. - Exclude non-working hours for each stage/ elapsed time. - Exclude Weekends (Friday & Saturday). - Sum up the total of elapsed times Do you have a solution that I can use the as tool either by creating exc...
I'm looking for a freelancer who can provide me with the links to Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Co...Facebook pages of specific public figures/politicians, total of 1215 (IMPORTANT! I need only pages, NOT private profiles). The links should be delivered in google sheets which I will provide, along with the names. Key Requirements: - Compile a list of specified Facebook pages - Deliver the links in google seets Ideal Skills and Experience: - Proficiency in Internet Research - Experience with Excel or Google Sheets - Strong attention to detail - Ability to follow instruct...
DESEO HACER UN CAMBIO DE TARIFAS DE UN DOCUMENTO EN WORD DONDE ACTUALIZAR EN BASE AL TEXTO INICIAL SOLAMENTE MODIFICAR LOS IMPORTES QUE SE INDICAN CON LOS CONCEPTOS E IGUALMENTE A EXCEL POR APARTADOS
I'm in need of a proficient Excel and Word expert who can assist me with various tasks. Unfortunately, I did not specify the exact tasks nor provide a deadline for this project. However, I'm excited to review your proposal and discuss your experience in more detail. Please include your past work in Excel and Word with your proposal. This could be anything from template creation to complex data analysis and automation. The more detail you can provide about your past work, the better. In terms of my needs, I'll be looking for a flexible freelancer who can help out with a range of tasks. Experience in data analysis, formula creation, and automation in Excel would be particularly desirable, as would proficiency in creating and formatting templates in Wor...
I am in need of an experienced and knowledgeable professional to assist in the development of a comprehensive training program for individuals aspiring to become advanced pentesters. Key responsibilities: - Create a structured, in-depth training curriculum focused on web applications, networks, and mobile applications pentesting. - Design ...particularly in the areas of web applications, networks, and mobile applications. - Prior experience in designing and delivering training programs, workshops, or courses. - Strong communication skills and the ability to explain complex technical concepts in a clear and concise manner. The goal of this project is to equip participants with the necessary skills, knowledge, and practical experience to excel as advanced pentesters in a professiona...
...menu data, which exceeds 500 entries, in Excel. My project primarily involves handling text data. Here's what you would focus on: - Categorizing different types of food items. - Ensuring accuracy and consistency in data entry. While not a firm requirement, familiarity with culinary vocabulary could be beneficial. Additionally, someone proficient in MS Excel and particularly experienced in data categorization would be ideal. I appreciate your consideration and look forward to potentially working with you. Paid project: remote work Seeking Assistance: Categorizing Online Menu Data in Excel Hey guys, I hope you're doing well! I'm reaching out because I could use your expertise for a project I'm working on involving categorizing online me...
I have a highly encrypted XLSM file that I urgently need help with. This specific project involves making VBA in the file visible. I need someone with advanced VBA skills and experience in cracking down highly encrypted XLSM files. Key requirements: - Expertise in VBA for Excel - Experience with highly encrypted XLSM files - Ability to make VBA visible in such files Please only apply if you have previous experience in this area and can start immediately. BID NOW!!! Serious freelancers only with the skills since it is ASAP!!
...VIVADO, to implement different edge detection algorithms, including Canny and Sobel, for the purpose of comparing their performance. Key Requirements: - Implement edge detection algorithms in VIVADO: The primary task is to develop and deploy edge detection algorithms in an FPGA, with a focus on Canny and Sobel techniques. - Algorithm Performance Evaluation: The main goal of this project is to compare the efficacy and efficiency of different edge detection algorithms, so you should have a strong background in image processing and be able to provide a thorough analysis of their performance. - Knowledge of other edge detection algorithms: While Canny and Sobel are the main focus, knowledge of other edge detection algorithms such as Laplacian would be advantageous. Ideal Skills and...
...VIVADO, to implement different edge detection algorithms, including Canny and Sobel, for the purpose of comparing their performance. Key Requirements: - Implement edge detection algorithms in VIVADO: The primary task is to develop and deploy edge detection algorithms in an FPGA, with a focus on Canny and Sobel techniques. - Algorithm Performance Evaluation: The main goal of this project is to compare the efficacy and efficiency of different edge detection algorithms, so you should have a strong background in image processing and be able to provide a thorough analysis of their performance. - Knowledge of other edge detection algorithms: While Canny and Sobel are the main focus, knowledge of other edge detection algorithms such as Laplacian would be advantageous. Ideal Skills and...
...as a platform for data visualization and export. Key Functionalities for Admin User: - **User Management:** The admin should have the capability to manage user accounts, including setting access permissions. - **Graph Creation:** The admin needs to be able to create visual representations of data. - **Data Viewing and Exporting:** The admin should be able to view all the data and export it to Excel for further analysis. Graphs Per Department: - **Data Points:** The graphs should focus on data from Sales, Expenses, Profit, and Number of Employees, using a rolling average approach for accuracy. - **Rolling Average Calculation:** The rolling average for the graphs should be calculated based on Manual Entered Data, per department. Additional Requirement: - **Formula Calculation...
...of both text and numeric data from PDF files. The extracted data will then need to be arranged in a specific format in an Excel sheet. Key Responsibilities: - Extract both text and numeric data from PDF files - Perform the data extraction on a weekly basis - Arrange the extracted data in specific columns and rows in Excel Ideal Candidate: - Proficient in using PowerAutomate for data extraction - Experience working with PDF files and Excel - Attention to detail for correct formatting of data - Ability to meet weekly deadlines - Strong communication skills to verify data accuracy Please find attached pdf (extract) example (there is 5 different templates to use) & excel (input). Looking forward to working with you! We have many more use cases like this,...
I'm in need of a highly skilled AWS OCR specialist to help extract data from a large number of PDF invoices. We intend to export the extracted data into an Excel (XLSX) file. All invoices follow a consistent format, as shown in the attached sample. All invoices have been scanned at 300dpi resolution with searchable OCR enabled." Key Requirements: - Proficiency with OCR technologies, particularly those integrated with AWS services (Textract) - Experience with extracting data from PDFs, especially invoices. - Ability to export extracted data into Excel format. The freelancer will supervise the implementation process on our PC. Due to confidentiality, access to the invoices will be provided remotely on my PC
Bitte melde dich an oder Loge dich ein um Details zu sehen.
...during the period of 2019 - 2020 [Note: you may not have access to all the stocks from Yahoo Finance during this period; please explain how you handle this issue]. • Explain whether dimension reduction techniques are needed. • Explain how you measure the performance. • Please show both the in-sample and out-of-sample performance. • Show evidence that the strategy you develop is profitable. • Compare the out-of-samp General Instruction: • We would like you to on the one hand, approach the problem from a practical perspective, and on the other hand, have a systematic methodology. You are encouraged to go beyond the requirements mentioned and use the quantitative techniques you have to solve the problems. • The final report is expec...
I need a seasoned Excel Macro developer to help me create a macro to automate repetitive tasks and generate daily reports. Key Requirements: - The macro needs to be compatible with Excel 2016, as this is the primary version I'm working with. - I'll need to run the macro daily, so it has to be stable and reliable for consistent use.
