Compare csv files vba jobs
I'm looking for an experienced freelancer to help me configure the folder and file permissions for a specific website on CyberPanel. Key Requirements: - The main goal of this task is to ensure the website's functionality is not hindered by strict security measures. - The website should have specific folders and files with read-only access, and others with read and write access. - Experience working with CyberPanel or similar control panels is essential for this project. In your application, please highlight your relevant experience with similar tasks. Note: Please focus on experience in your application, rather than detailed project proposals. Thanks.
I need a wide range of details about accommodations on , downloaded for analytical purposes. This data should include r...data should include room availability, pricing, customer reviews, accommodation rate variances, photos, addresses, and phone numbers. - Essential Skills and Experience: 1. A strong understanding of web scraping tactics and data extraction. 2. Proficiency with 's platform and data structures. 3. Data organizing skills to deliver finalized data in CSV format. The outcome I envision is a well-organized CSV file that can further my research and analysis goals. A successful delivery will require attention to detail to ensure all requested information is included. Please bring forward your innovative solutions and reliable data handling methods.
I'm looking for an expert in VBA and macros to help streamline my processes in Excel. Key Requirements: Shifts: Defined two shifts in the "task tap": Morning: 6:00 to 15:30 Afternoon: 14:00 to 22:30 Quality: Updated the agreed-upon columns in the "quality tap." And remove the error code if there is no any number Delays: Ensured delays are reflected as discussed. Task Order: Arranged tasks in the "task tap" from oldest to newest. Please review the file and let me know if you have any questions or require further changes. Requirements: 1- Required an option in this file (Excel) that when the planner change the completion date of any task in column K in the TASKS tap, the color of the cell will be changed to yellow, and a not...
...an efficient solution regarding data transfers for my HubSpot account. This task requires: - A Zapier workflow configured to transport data from an automated CSV file to my HubSpot account, executed twice daily, ensuring timely and regular data updates - Fine-tuning of the data transfer to include only specific columns from the CSV file, ensuring that only relevant data is procured - Arrangement of the data in the same sequence as it appears in the source CSV file, ensuring a smooth correlation between sources and easing the tracking process All applications are welcome, however, familiarity with Zapier, data transfer protocols, CSV manipulation, and a sound grasp over data continuity would be considered peak assets for this task. If you could get on this i...
I would like a stand-alone Windows 10 executable file that extracts and saves the following data from MP4 video and/or MP3 audio files: 1. number of frames in the file 2. amplitude (how loud) for any frame based on frame number 3. frequency (pitch in hertz) for any frame based on frame number 4. size (in bytes) of the jpeg for any frame based on frame number 5. jpeg for any frame based on frame number It works as follow: 1. The user browses to a TXT file. 2. Each line in the TXT file lists the: a. location of an MP4 video or MP3 audio file [B below] b. data to be extracted from the file [D,E,F below] c. location where the extracted data is to be saved [C below] 3. As each file is processed, a line is displayed indicating the line and file, data saved and errors that occurre...
...Azure/M365 ecosystem, including Azure Data Factory, Azure Data Lake, and M365 Experience with fuzzy matching algorithms Proficiency in data integration and ETL processes Familiarity with MongoDB and data storage + M365 Integration Strong analytical and problem-solving skills Excellent communication and documentation skills Task Breakdown: Develop a fuzzy matching module to compare data across 15-20 points of data Implement additional matching algorithms (e.g., exact matching, regex pattern matching) to handle various data formats Develop 15*3 ETL processes to handle different data formats and request codes Integrate the developed modules with our Azure/M365 environment Configure data storage, authentication, and authorization Perform ...
...liquor industry, and how tequila stacks up against other spirits. You'll need to: - Thoroughly research consumer habits such as preferences and buying patterns - Access and analyze market reports, specifically Nielsen Reports, IWSR Reports, and Beverage Industry Reports. Any other spirit reports would also be valuable - Make a comparative analysis of tequila sales against other spirit categories - Compare tequila companies that have bought out others. No particular brand is noted; however, the focus should be on the most popular companies in this context The freelancer should have strong research skills, familiarity with the beverage industry, and proven experience in market analytics. Understanding of consumer psychology would be a plus. Willingness to delve deep into the...
I have a large volume of numerical data that needs to be entered from multiple digital files. The files will be provided to you in a digital format. Key Requirements: - Data Entry: Accurately input numerical data from digital files into a specified format. - Efficiency: Handle a substantial quantity of data in a timely manner. Ideal Freelancer: - Proficient in data entry with experience in handling numerical data. - Attention to detail to ensure accuracy. - Previous experience with large-scale data entry projects is a plus.
I have a large volume of numerical data that needs to be entered from multiple digital files. The files will be provided to you in a digital format. Key Requirements: - Data Entry: Accurately input numerical data from digital files into a specified format. - Efficiency: Handle a substantial quantity of data in a timely manner. Ideal Freelancer: - Proficient in data entry with experience in handling numerical data. - Attention to detail to ensure accuracy. - Previous experience with large-scale data entry projects is a plus.
The project involves: 1. Go to an FTP location and get the last 10 csv files. Input example attached as '' 2. Combine those newest 10 files and map to new structure. Mapping example attached as '' 3. Save new file as 'BooksRunImport YYYY-MM-DD ", place in production folder "C:LakesideBooksClientDownloads" as tab delimited .txt, with an additional copy in folder as a backup. Output example attached as '' I would prefer it be written in NodeJS and compatable with v14.16.1 as I am familiar with how to edit the structure and I have other similar scripts running. I will supply FTP location and login as well as folder locations.
I'm looking for a skilled developer to create a one-time scraper for the TruePeopleSearch website. The scraper should focus on extracting addresses and phone numbers, and the output should be in CSV format. Key Requirements: - Develop a scraper for TruePeopleSearch - Extract addresses and phone numbers - Output the data in CSV format Ideal skills and experience for this project: - Proficient in web scraping - Experience with scraping tools and techniques - Proficient in CSV formatting - Understanding of data extraction from websites
...freelancer to assist me with an online data migration project. Key Tasks: - The primary task will involve accurately and efficiently transferring data from Excel/CSV files into an online database. - Ensure data integrity and make necessary corrections where needed. Ideal Candidate: - Proficiency in working with online databases and Excel/CSV files. - Attention to detail and accuracy is crucial. - Prior experience handling data migration tasks, preferably in a similar context. - Familiarity with data verification practices. The end goal of this project is to successfully migrate all the data from the provided Excel/CSV files into the online database without any loss or corruption. A successful freelancer will have the ability to work indepen...
Urgently seeking a proficient Microsoft Excel user to help input a mix of numeric and text data into a CSV file. Your skills and experience should encompass: - Mastery of Microsoft Excel - Wide-ranging background in data input - Solid understanding of CSV files - Ability to work quickly and accurately The project is immediate and time-sensitive. Appreciate your prompt attention and swift action. Looking forward to your bids.
I'm in search of a meticulous data entry specialist to help with a simple text data entry task. The job is quite straightforward, involving the transfer of information from digital files to a different format. The role strictly involves data entry without the need for any form of data analysis. Key responsibilities: - Accurately entering text data from digital files into a specified format. Ideal Skills and Experience: - Proven experience with data entry. - Attention to detail. - Proficiency in working with digital files and transferring data.
I need someone to upload files of a website on my namecheap hosting. I have .zip file with full website files (wp-content, wp-config and all the others) and I need this to be uploaded and made to work on my namecheap hosting and database.
If someone is looking for the capacity to enter between 300 and 1000 products, you can use a CSV archive or a manual form. If you propose a catalogue, the objective is to increase the price of each product by 35%, regardless of the initial cost. Also, you need to find quality images for each product and adjust them to a resolution of 500x500 pixels. Similarity, you should add videos for some products. The remuneration offered is 10 Dominican pesos for each combined product. The type of exchange can be consulted to obtain the equivalence on other days. It is important to note that the 35% increase is applied to the purchase price, which means that the selling price will be 35% higher than the original price. Please ensure you explain this point clearly."
I'm in need of an experienced Excel professional to help me build a secure data management system. This system will be used to handle both financial and customer information. Key Requirements: - **Data Security**: A robust system that...customer data. - **User Management**: The system should be designed for 1-10 users, allowing them to access and input data securely. - **User Experience**: While the users are expected to have advanced Excel skills, the system should be designed with clear interfaces and user-friendly features. Ideal Candidate: - Proven experience in designing secure data management systems in Excel - Proficiency in VBA and Excel's advanced features - Strong understanding of data security and privacy - Excellent communication skills to understand and mee...
I'm looking for an experienced VBA coder who can focus on two main tasks. 1. **Fixing Existing Issues:** - My current VBA code has issues with execution errors and incorrect results. I need solutions to these two problems. 2. **Adding Modifications:** - I'm looking for someone who can add additional features to my existing VBA code. - Good user experience is important too so improvements on the user interface would be very beneficial. Ideal candidates will have an excellent understanding of VBA syntax, debugging, and error handling. Experience with user interface design is also appreciated. The aim here is to produce accurate calculations, formatted data or reports swiftly and easily.
I'm looking for a skilled developer to create an efficient FTP script that will allow me to upload files to a specific folder in cPanel. Key Requirements: - The script should be optimized for small files, as large file handling is not a priority. - It should be developed in a language suitable for FTP functionality. The script will be used to automate the process of uploading files to a specific folder on a cPanel server. The ideal developer should have experience in: - Building FTP scripts for file uploads - Working with cPanel and its file management system - Ensuring the script runs smoothly for smaller files Please include in your proposal your experience with similar projects and any relevant skills that make you the ideal candidate for this task.
Hello, I am seeking an experienced JavaScript developer with expertise in CesiumJS to optimize an existing aviation visualization project. The application is built using HTML, JavaScript, and CesiumJS, and is designed to display flight data from CSV files in a 3D environment. We have already implemented the capability to handle formation flights and a top-down view of multiple aircraft. However, I need assistance in improving the frame rate and optimizing the updateFlightView function. Project Requirements: -Frame Rate Optimization: Enhance the application to ensure a stable frame rate of over 30 FPS, particularly when visualizing multiple aircraft in formation. -Optimization of Existing Features: The current implementation of formation flights and the top view visualizati...
I am in need of a s...images. - Update Frequency: I require the data to be updated once. This means that the scraper should be designed to pull the data once and not re-visit for updates. - Data Format: The extracted data should be saved in a CSV file. This is the preferred format for the end result of the scraping process. Ideal Skills and Experience: - Proficiency in Python: A strong background in Python programming is essential. - Web Scraping Experience: Previous experience with web scraping tools and techniques is highly desired. - Data Handling: Knowledge of how to handle and store data in CSV format. - Attention to Detail: The ability to make sure that the scraper is collecting all necessary data accurately. - Time Management: The capacity to complete the project in...
I need a freelancer to enter numeric data into Excel from digital sources. Key Requirements: - Proficient in data entry - Expertise in working with Excel - Attention to detail The task is straightforward and simply requires the accurate transfer of numeric information into a pre-existing Excel template. I will provide the data in digital format (Excel, CSV) and expect it to be entered systematically according to the format provided.
I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account Name: C...
...a variety of design tasks. The project will involve: I already have a logo design but it needs editing. I want it to be more visible on social media at the moment you can't really read the words when it is uploaded. Possibly needs to be more bold. I like the wording Modern Money to be in modern pointy style font. I would also like another option of all the yellow font in Gold so that I can compare the two. I only need the logo at the moment but I will be needing the below in the near future. I am looking to work with someone that I can keep coming back to for additional graphic design work so I am relly needing someone I can continue to work with and understands my vision for the aethetic and brand I am wanting to create. - Designing graphics for educational e-books....
use submitted requirements and add to the existing figma protpotype. the job needs to be done rapidly
...experimentation. - Network traffic data analysis, particularly for IDS - Intrusion detection systems (IDS) and Cybersecurity. - Proven hands-on experience in network traffic data processing. Here is what you will do: - Design a unique deep learning methodology for intrusion detection. - Develop an evaluation/testing protocol. - Run experimental tests and analyses on the network traffic data. - Compare and document the analysis results. The outcome should be a well-delineated deep learning methodology, that includes a detailed comparative analysis report backing up the efficiency of our newly developed approach in intrusion detection. Prior experience with IDS and deep learning methodologies writing is highly desirable. Your advanced skills in deep learning and intrusion det...
I am seeking a freelancer to undertake an analysis and design optimization of a truss structure, using ANSYS software and genetic algorithm. This is based on criteria provided in attached articles. Key deliverables include: - Optimization of material usage - Enhancement of load capacity - Management of stress distribution in the design The main objective of this project is to compare different analysis methods and their results. This is an urgent project requiring immediate commencement. Expertise in Structural Engineering, ANSYS, and algorithm optimization is essential. Preferred candidates would have proven experience in similar projects, particularly in comparing and evaluating analysis methodologies. A keen eye for detail and capability to draw meaningful conclusions from ...
Urgently seeking a proficient Microsoft Excel user to help input a mix of numeric and text data into a CSV file. Your skills and experience should encompass: - Mastery of Microsoft Excel - Wide-ranging background in data input - Solid understanding of CSV files - Ability to work quickly and accurately The project is immediate and time-sensitive. Appreciate your prompt attention and swift action. Looking forward to your bids.
I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.
...Illustrator to primarily vectorize my existing image and logo files. This is important for various applications, including print, web and video ads. Not only am I looking for someone to vectorize these files, but also apply necessary modifications via Photoshop or Illustration techniques. This will be done with a keen attention to detail and a good sense of design aesthetics. The ideal freelancer for this project should have: - Strong skills in Adobe Illustrator - Experience in image and logo file modification - An impressive portfolio showcasing similar projects When applying, please ensure to highlight your experience. Your unique touch and innovative techniques could be just what I need to bring these files to life. I have attached the files in quest...
...videos. The app should also be able to match the detected face with a reference photo, which I will provide. Key Requirements: - Face Detection: The primary function of the app is face recognition. It should be able to detect faces in a live setting. - Anti-spoofing: The app should be able to distinguish between a live face and a photo or video. - Face Matching: The application should be able to compare the detected face with a reference photo, and provide a match. Your responsibilities will include: - Developing the mobile application for both iOS and Android platforms. - Integrating the necessary software components for live face detection. - Building the anti-spoofing measures to ensure the app is secure. - Implementing the face matching algorithm with the provided referen...
DESCRIPTION: This project involves the overall UI design of the entire website. However, because we need to compare designs, we are treating the INDEX design as the first phase. After evaluating the INDEX design, the second phase, which involves the overall UI design, will be assessed and negotiated separately. 1. The homepage must include the following items: a. LOGO (will be provided during the design process) b. MENU: HOME / LIVE / PRE-MATCH / LIVE CASINO / SLOTS / E-SPORTS / GAMES / VR SPORTS c. Login popup d. Registration popup e. Multilingual menu 2. Things to note: a. You can change the current design and position, but you must not alter the required fields, such as the existing fields for registration and login, as well as the items in the MENU...
...informations See for the actual webshop Language: main language English, other languages needed: German, Italian, Spanish, Portuguese, French, Arabic Reworking of product pictures for to have same appearance of background color Currencies: Euro and USD Shipping global (within EU with various VAT options of the delivery address country, shipping outside EU VAT free) Import products from csv file (about 1500) -reformat description Rework product pictures with uniform background (white) Required plugins (e.g. custom programmed if not available already): Engraving (customization) of our products, visible on the product during purchasing process Up to 3 lines engraving of product visible on the product during the purchasing process. (all available fonts to choose from) Possibili...
I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver ...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
I need to organize my activities with my personal assistant to share files, emails, tasks, calendars Etc.
...how you will track, analyze, and report on these metrics. Performance Monitoring and Analysis: Detail your process for continuously monitoring campaign performance. Explain the metrics and tools you will use to track effectiveness, such as conversion rates, cost per acquisition, engagement rates, and other relevant KPIs. Describe how you will conduct A/B testing and multivariate testing to compare different aspects of the campaigns and determine the most effective strategies. Identification of Underperforming Campaigns: Explain your methodology for identifying campaigns that are not performing as expected. What specific indicators will you look for to pinpoint areas of concern? Provide examples of how you have handled underperforming campaigns in the past, including the steps...
...how you will track, analyze, and report on these metrics. Performance Monitoring and Analysis: Detail your process for continuously monitoring campaign performance. Explain the metrics and tools you will use to track effectiveness, such as conversion rates, cost per acquisition, engagement rates, and other relevant KPIs. Describe how you will conduct A/B testing and multivariate testing to compare different aspects of the campaigns and determine the most effective strategies. Identification of Underperforming Campaigns: Explain your methodology for identifying campaigns that are not performing as expected. What specific indicators will you look for to pinpoint areas of concern? Provide examples of how you have handled underperforming campaigns in the past, including the steps...
I'm looking for a skilled data entry freelancer to help me with the entry of text data from digital files. The entered data will be utilized for analysis purposes. Key Responsibilities: - Transferring text data accurately from digital files into a specified format - Ensuring the data is entered completely and error-free - Maintaining data confidentiality and security The ideal candidate for this project: - Has a proven track record in data entry, specifically with text data - Is meticulous and detail-oriented, with strong organizational skills - Has the ability to handle potentially repetitive tasks with accuracy and efficiency - Understands the importance of data confidentiality and is committed to upholding it Your successful completion of this project will greatly...
...automating the transfer of information between those departments: linking the data, defining "trigger" events, and processing data from various inputs into "smart" trackers. I have a clear outline of what I want to accomplish - what data I need, who I need it from, and how I want the tracking of the inputs to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. ...
We are seeking an experienced developer to integrate OpenAI GPT into our existing database system (Zoho CRM) to enable natural language queries for investor searches. Users on our website will describe their company and transaction details, and the GPT will summarize and request additional information. Based on this, the GPT will score investors using a customizable algorithm and provide a CSV list of the top 100 matches. Users interested in further details must sign an NDA and fee agreement via an automated system, with their information and preferences automatically transferred to our CRM database. Key Project Details: User Interaction on Company Website: Users will describe their company and transaction details on our website using natural language queries. The GPT will genera...
I'm looking for a seasoned server administrator to set up a dedicated server for container-based provisioning...virtualadmin or something to manage and deploy the entire system and interface to manage and control all the stuff over server. the setup will be done on single server for now and it can required a feature to get expanded with single click, so that purpose of the cloud get achieved. Open stak can be used as well ( just a reference) if anything else will work on fly then we will go with that. if compare what kind of service it will be, then this can be similar like vercel or netlify based website and app hosting Your task will be setting up the server considering routine maintenance, security, scalability, and resilience to handle high traffic. Thanks in advance...
I want a script that allows me to export a Zencart catalog () to CSV in real-time with the following fields: Title Short description Category (x, y, z) Description Image URLs (URL1, URL2, URL3) Price Stock
I am looking for a developer who can design a data uploader for my website. The primary purpose of this tool is to allow me to upload different types of files such as Excel spreadsheets, CSV files and Text files into my website's backend. Key Requirements: - Support for multiple file types: The uploader should be able to accept a variety of file formats, including Excel spreadsheets, CSV files, and Text files. - Basic Data Validation: Before the data is uploaded, I need this tool to perform basic data validation. This would involve checking for field completeness to ensure that all necessary fields are populated before the upload is allowed. Ideal Skills and Experience: - Proficiency in web development: The ideal candidate should hav...
Please start your proposal by saying "hello MBA student" I am looking for a skilled data scraper who can efficiently extract specific data from a football website (). and one more for average age of squad. Extraction will need to go CSV Key Tasks: - Extracting 'Average Age of Squad' information - Extracting 'Net Spend' data Ideal Skills: - Proficiency in data scraping - Understanding of football statistics - Experience with similar projects or websites is a plus I trust your expertise to advise if additional information is needed for successful execution. Experience and accurate, meticulous work is what this project calls for.
I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.
Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.
Urgently seeking a proficient Microsoft Excel user to help input a mix of numeric and text data into a CSV file. Your skills and experience should encompass: - Mastery of Microsoft Excel - Wide-ranging background in data input - Solid understanding of CSV files - Ability to work quickly and accurately The project is immediate and time-sensitive. Appreciate your prompt attention and swift action. Looking forward to your bids.
...essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in the Austr...
