Csv txt vbaJobs

I'm looking for an Excel VBA expert who'll be prepared to take on challenges on the go, as this listing lacks specific task detail. I rely on you to be innovative and foresee potential tasks such as automating data entry, creating macros, or generating reports. Ideal Skills & Experience: • Proven VBA scripting in the Excel environment • Experience with automation, macros, and report generation • Demonstrable troubleshooting skills In your application, please showcase your past work, how much experience you have, and provide a detailed project proposal. While the specific tasks aren't predefined, your application should reveal your versatility and expertise in VBA scripting. The project's ultimate purpose is unknown, potentia...

I have a daily dataset of the prices and funding fees of cryptocurren...format for ease of understanding and comparison. Any tool or programming language that can efficiently and accurately perform this task is acceptable. The goal is to create a structured, automated process that can handle this daily task with precision. Ideal Skills and Experience: - Strong Excel skills, especially in formulas and functions. - Prior experience with automation in Excel, macros and VBA programming. - A good understanding of cryptocurrencies and their pricing. - Ability to deliver a clean and user-friendly layout for the output. Your work will significantly ease my daily workload and improve my decision-making process. I look forward to your proposals. Screen of excel file.

I'm seeking a VBA expert who can help me create a tool that will generate both PDF and Word documents from a specific column of an Excel file. The Word document should contain some static data derived from the column details. The primary requirements are as follows: - The tool should be able to generate both PDF and Word documents. - The Word document should include some fixed data from the Excel details. - An interactive graph should be included in the Word document, based on the data from the specific column.

I need a VBA script tailored to Excel that will assist in my data analysis projects. It should prompt me to enter a target amount, then let me select a range of cells that contain various amounts. The code should find a combination within the selected range that makes the sum equal to or closest to the target amount. It could be more than the target amount or less than the target amount but it should be closest. It should then highlight the cells that make the sum that is closest to target amount. It should also ensure that only visible rows are to be considered. Hidden rows are not to be considered. Key Requirements: - Prompt for target amount and range of cells - Find combination closest to target sum - Compatible with Excel 2016 and above Key Features: - Return the first closes...

In need of a qualified freelancer to automate tasks such as report generation and data manipulation in Excel using advanced VBA. Key Tasks: - Create automated processes in Excel for data manipulation and report generation - Work with Excel data sources exclusively Skills and Experience: - Expert in Excel VBA development - Proficient in the use of advanced Excel functions, including array formulas and 'What-if' analysis - Strong understanding of data handling in Excel The successful candidate will be expected to demonstrate a track record of automating complex tasks in Excel using advanced VBA, and manipulating data accurately and efficiently.

...receipts, and account balance reporting. Optional features include a chart of accounts with automatic generation of accounting entries and export functionality in TXT, JSON, and XLS formats. The ideal candidate should be able to implement these features and ensure they are integrated seamlessly into the existing system. Key Points: - Extend existing module with purchase and sales registration. - Implement correction notes and payment/collection receipts. - Create an account balance report feature. - Optional: Develop a chart of accounts with automatic generation of accounting entries. - Optional: Implement export functionality in TXT, JSON, and XLS formats. - Also required: Develop a receipt form and accounts receivable/payable for clients, suppliers, cash, and banks, as ...

I require a simple mailing software that can send bulk emails to a list of 60,000 email addresses. The software is intended to be a standalone tool, focusing solely on delivering the emails effectively. It does not need any extra analytics or whatever. Key Requirements: - Able to send bulk emails to 60,000 recipients - Capable of importing email addresses from a CSV file - No additional features are needed, simplicity is key - Any optimisation that would not let it go to spam is welcomed. Application Details: When submitting your proposal, please include a detailed project proposal that outlines how you plan to create this software in a cost-effective manner. Be sure to highlight any relevant experience or past work that demonstrates your ability to complete this project effective...

Hello, I have a CSV file that contains our product catalogue, that file is dynamic, is contained on a hosting (www... ) and change the stock and products info each X hours, I need upload that catalogue products to Amazon

Hello, I need upload my CSV catalogue products to Amazon, is a dynamic CSV cointained on a hosting that change and refresh the information

I am looking for a skilled individual who can develop a tool or app for uploading of information from .csv and xl files to a website. Ideal candidates should have a strong background in software development, particularly tools or apps dealing with data extraction and upload. Experience with web development and understanding of data display techniques will be considered an advantage.

I need a Laravel Expert to make two separate tasks urgently. Task 1: Wherever something specific is not specified, you have complete freedom of choi...DB • Add create/edit functionalities. Requirements: o Country field should be a dropdown populated from the DB o Active field should be a checkbox o Show how many months the client is registered in our DB o Validate the inputs in the backend (basic validation) • Add delete customer functionality • Implement a simple search functionality. The search fields are by your choice. • Create “Import from CSV” functionality for adding new clients into the DB. Mandatory fields - email and country. Rules: You can use – Laravel, JS libraries, Google search, etc. The frontend is not important, so don’t...

Please read carefully and task is listed below:- I'm in need of a proficient website scraper for a one-time scraping task. The data I'm interested in includes text ...scraping - Ability to retrieve and save text content, images, and links from websites - Proficiency in structuring and organizing scraped data for analysis - Understanding of the importance of data quality and integrity Please note that the scraping is a one-time project. The scraper should be designed to efficiently collect and organize the data for subsequent analysis. Note: I need a data into csv format and I will provide you the excel file and need to do in that. Task: I need the all company brands models with the company category and description /properties of smartphone. Website:

I am in need of a proficient VBA and Excel Macros expert to develop a simple, yet efficient invoice/billing application. Key Features: - Generation of invoices from input data. - Tracking and calculation facility for totals. - Maintaining a robust database for customers and invoices generated. Interface Requirements: - The GUI should be straightforward and user-friendly, allowing quick input, management, and retrieval of information. Data Handling: - The application should exploit Excel capabilities for the storage and manipulation of all the data, including customer and invoice records. Ideal Skills & Experience: - VBA and Excel Macros expertise. - Experience in creating user-friendly GUIs in Excel. - Able to develop robust database systems in Excel. - Knowled...

I need a freelancer to scrape a website and provide the data in a CSV file. The chosen freelancer should have extensive experience in web scraping and be able to provide previous examples of their work. The data should be neatly organized and easily digestible.

This is the project file file,that you have to work on . The main objective of this project is to predict forest is caught fire or not fire based on the user inputs from the gui. My current project model is not perfectly working...conditions based on my datasets given as reference. you can use any of this four datasets, according to your comfort in the project and train the model. but while testing the inputs on gui , it should predict accurate values for all the 4 dataset values for values from these 4 data sets randomly for testing. Your model should work for all these 4 data sets. 2.db4.csv You have to test the inputs on GUI using my datasets, and send a video like attached in the resources to predict fire or not fire

I am seeking a highly skilled AI engineer to develop a real-time predictive AI system for 7-day forecasting of MODIS Fire Hotspots. The output should present in CSV that include at least date, lat, lon, Given the lack of preference for any specific platform, an ideal candidate should have versatility in implementing AI algorithms on various platforms such as desktop computers, mobile devices and web browsers. The Learning data set: - MODIS csv daily fire hotspots over southeast asia since the year 2000 - MODIS NetCDF monthly burn scars over southeast asia since the year 2000 -ERA5 NetCDF daily meteorology included precipitation, maximum temperature, minimum temperature, relative humidity, plenary boundary layer hight, wind speed and direction. Key Project Requirement: -...

I am seeking a skilled programming expert, proficient in either Ruby or Python, with intermediate-leve...task involves intelligently executing aggregations and nested queries in ElasticSearch, extracting data, in JSON format, and then transposing it into Excel or CSV format. I'm open to whichever format you are more comfortable with, so long as it is either of the two mentioned. In addition to this, having familiarity with job automation via GitHub is critical for this project role. This background should include understanding how to automate and schedule tasks to regularly extract, convert, and save this data. Ideal Skills: - Proficiency in Ruby or Python - Intermediate level ElasticSearch querying - Experience with JSON to Excel/CSV conversion - Familiarity with Git...

I am building a website where user can upload csv and view/download content generated from backend, chat with uploaded file (e.g. ) I need just one page, landing page will include a browser box to upload a file, no authentication, no payment integration. once file uploaded, it will be processed in the backend and result will be produced in tile format (e.g. ) user can view large formats of the result by clicking over it, download it from larg/tile format. type pinaki in caps in start of your proposal. you need to focus on fuctional stuff ignore everything else from ref. () site. Tech stack: technlogy: frontend => Angular/NodeJS/(or any other tech)+HTML5 Backend is being developed by some other

...linked to tasks and aspects. Flexibility: Standardized workbook naming ("PrepA", "Year1B", etc.) to allow for scaling. Master File: A central file pulls data from teacher workbooks, providing schoolwide reporting. Automatic Updates: Master File refreshes data when teacher workbooks are saved (VBA preferred). Reports: Basic summaries within teacher workbooks, and comprehensive reports in the Master File. Desired Skills: Proficiency in Excel: Deep understanding of formulas, data linking, and sheet structuring. VBA Expertise: Experience with workbook events and automating updates. UI Focus: Emphasis on clear navigation and user-friendly data entry within Excel. Deliverables: Workbook Templates: Standardized teacher workbook template Master File template ...

I'm searching for someone with significant experience in crafting .csv spreadsheets to facilitate streamlined payroll processes. The core task involves creating a timesheet spreadsheet that can be conveniently uploaded into ADP for payroll. The essential fields to include in the spreadsheet are: - Employee Name - Date - Time In - Time Out - Break Time What sets this task apart is the need to automatically calculate total work hours from the given time-in and time-out, with break time appropriately deducted. An understanding of ADP systems will be an advantage in ensuring seamless integration. Proficiency in advanced .csv functions and an ability to translate the requirements into a user-friendly, efficient tool is vital. You should be a pro at handling spreadsheet ...

As I'm launching a new business, I need your expertise in developing VBA scripts and macros in Excel to help me automate several repetitive tasks. I am looking for an expert in MS Excel to develop a special MS Excel Macro which can be integrated to MS Excel environment, in order to generate an output file. This tool will allow us to transform a specific Input file into another Output file. • Input: catalog_product_option-YYYY-MM-DD • Output: The 2 files are attached, with a color mapping to recognize the columns in scope. In summary, we need to be capable to issue an export file in a specific format (see attached picture “”): • Specific Orders of the column (Green) • Suppress the duplicated values for some line items, on 3 fields. The macr...

I'm in need of a proficient Excel specialist who can help create a solution for selecting rows to display in Excel with a total at the bottom. Requirements: - Proficiency in Excel and experience with creating VBA or macros - Ability to display both numerical and text data - Ensure compatibility with Windows Operating System Please note, this task calls for a clean, simple solution. Your proposal should detail your previous work with similar Excel functions.

Adjust the VBA code to exclude names

I'm seeking an experienced professional to chat or talk with for two hours at some time April 4/13-4/18/2024 - who specializes in digital storage and file/document management, probably involving a database and complimentary software. Knowledge of real time file synchronization, distributed file system, database or related software that can rename, copy, and retrieve PPTx, PDF, MP4, txt, and other files - preferably on native NTFS and onto network drives. I hope to have an extended chat or a live conversation, maybe a couple hours talking about the project scope and the technologies available. The intent is for me to have a clearer picture of what I need to learn in order to create a budget and invite a developer to help create the file management system that will speed up our...

I have a very simple web page that has a scrollable table with data. I can't copy and paste the data as a whole into excel, it's requiring that I copy each entry one by one. I'm looking for someone that can help design a simple program to automatically save all data as a csv file. Thanks

Hello, I need upload my catalogue on CSV to Amazon

...functionality into Zoho CRM. *MUST be detail-oriented, intuitive, and goal-driven (a mix of self-directed + training new user on functions). > Limited "directions" to follow-.. instead = "intent/goals" to achieve in organizing our partnerships) + log/line items of tasks & interactions..... set up reminders. + storage / display of real estate inventory (line items of basic data fields) - CSV or XLS files used. + centralized access to source links/quick jumps to various related URLs + templates for standardized emails, trackers, etc *MUST provide 1-2 hours of remote training to a new Zoho user > efficiently able to communicate in English > teach basic Zoho proficiency. Additional training & future workload is negotiable. ...

Need an Excel VBA expert to do automate a workflow of flagging the date of the first non-zero value in a row. I'm looking for a freelancer with the following skills: - Proficient in VBA programming. - Previous experience in developing Excel automation scripts. - Able to deliver the project as soon as possible.

I need an expert who can perform a detailed competitor analysis for me. I need the Moz domain authority of 395 URLs in a CSV file. Key requirements: - Calculate Moz domain authority for 395 URLs - Deliver the data in a CSV file - Provide a detailed competitor analysis Skills and experience needed: - Strong understanding of SEO and competitor analysis - Proficiency in using tools like Moz Pro, SEMrush, or any other suitable tools for this task - Ability to deliver actionable insights based on the data gathered The ideal candidate should be able to provide me with a comprehensive overview of my competitors based on the domain authority of their URLs. Please include any relevant experience you have in your bid.

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

I need an Excel macro develop...Requirements: - Email Trigger: The macro should send emails based on the completion date of each training module, not just the hire date. - Email Recipients: The email notifications should be sent to both the new hire and their manager. - Email Content: The email should include the name and email of the new hire, along with a list of overdue training modules. Ideal Skills and Experience: - Proficient in VBA and Excel: You should have a strong background in developing macros and automating processes within Excel. - Familiarity with Employee Training Systems: Experience with tracking and managing employee training programs is a plus. - Communication Skills: You should be able to effectively communicate with me to ensure the macro meets the business req...

I am seeking a highly skilled AI engineer to develop a real-time predictive AI system for 7-day forecasting of MODIS Fire Hotspots. The output should present in CSV that include at least date, lat, lon, Given the lack of preference for any specific platform, an ideal candidate should have versatility in implementing AI algorithms on various platforms such as desktop computers, mobile devices and web browsers. The Learning data set: - MODIS csv daily fire hotspots over southeast asia since the year 2000 - MODIS NetCDF monthly burn scars over southeast asia since the year 2000 -ERA5 NetCDF daily meteorology included precipitation, maximum temperature, minimum temperature, relative humidity, plenary boundary layer hight, wind speed and direction. Key Project Requirement: -...

Download two files from a website and sort them and get CSV output The project was uploaded to GitHub The project includes a 30-day warranty including changes and updates

In this project, we're aiming to categorize video transcripts, identify key topics, and enhance the searchability of video content. The main goal is to differentiate between questions and sentences contained within a video transcription CSV data file. Following features are required: - TF-IDF, LSA, LDA, Word2Vec, and SentenceTransformer for text vectorization. - Utilise various models to evaluate the performance using an ROC curve. - The differentiation of the content type should be indicated in the 'label' column. The value can be 'question' for sentences that are actually questions, and 'sentence' for regular statements. - Development of a RESTful API with Flask. - Dockerization of the API. Ideal candidates for this project should have: - Pr...

...is to gather specific information that will be crucial for our lead generation efforts. Requirements: - I need accurate and up-to-date information for each number. This includes the individual's name, location, email, and social media profiles. The accuracy of this information is crucial to the success of our lead generation campaign. - You will be provided with the phone numbers in an Excel or CSV file, and I would like the enriched data to be returned in the same format. Ideal Freelancer: - Experience with bulk enrichment of phone numbers, especially in the Indian market, is essential. - Proficient in using tools like Truecaller or any other app that can provide the required information. - A good understanding of lead generation and the importance of accurate data to ...

I'm in need of an experienced MySQL and Neo4J expert who can help me with designing a database schema and an ERD Diagram from a CSV file. Make a report of the database with proper screenshots and run some queries. more details in chat... Requirements: - Proven expertise in MySQL and Neo4J - Solid understanding of database schema designing - Producing an ERD Diagram

I need a proficient VBA professional who can help develop an Excel recruitment tracker dashboard. Key components should include: - Display recruitment data in visually engaging formats including bar charts, pie charts and tables. - Incorporate dropdowns using macros form control for flexible data querying. - Capture essential data points such as candidate name, the position applied for and the application status. - Provide tracking capabilities for application status reflecting stages like pending, shortlisted, and interview scheduled. -Should have recruitment metrics like Time to hire, recruitment funnel and other key metrics The ideal candidate should have robust skills in VBA and Excel, particularly in creating dynamic and interactive dashboards. Experience in human r...

Hi Farzana, I'm currently looking for a virtual assistant who could help me with different projects and everyday tasks. I am a personal stylist and Etsy seller and I would need help with the following: - Security save of my Etsy products (copy and paste the description into Txt file organized with images in thematic folders, adding the downloadable file or the Canva template link to it) - Checking and tracing my emails, answering to requests - Canva text editing based on an example. ( This refers to for example e-books where I prepare the first pages and I ask you to insert the provided text based on the given sample pages) - Any other assistance with calendly or google calendar - Reasearches or creating statictics occasionally We could discuss the weekly tasks each Monday on ...

I have two CSV files that I need compared. I need to compare the file 1 and 2 attached. we have to filter the data in the file 1 column C considering only the voice alta, bassa, media. And check if they are in the file 2 column C "sku" with a quantity (column G) >0 The app need to create as output a file with the data in the file 1 column C considering only the voice alta, bassa, media -> column A and in the column B: - if there is in the file 2 column C "sku" with a quantity (column G) >0 yes - if there is not no If you have any questions contact me. Thanks, Regards, Marco

I have a crucial data warehousing project that requires an expert's touch. The key aims of this project revolve around: Data Extraction: The source of our data will be CSV files. Experience with dealing with such files is a must. Data Transformation: The raw data we extract needs to be cleaned, merged and aggregated. If you have a proven track record in similar transformations and know how to handle a wide range of data discrepancies, your expertise could be just what this project needs. Data Loading: Once the data is extracted and transformed, it needs to be loaded into the warehouse. This process should be seamless and error-free. The ideal candidate will have an in-depth understanding of Python and data visualization tools, as they are integral to this project's suc...

I'm seeking a highly skilled Excel expert to develop a versatile, either fully or semi automatic, Excel formula or action algorithm that can handle specific data manipulation tasks. This Excel tool must be able to automatically select data...row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipulation, versatility, and a deep understanding of Excel’s inbuilt functions and scripting in VBA are crucial for this project. Proficiency in creating user-friendly interfaces within Excel for ease of customization by the end user w...

I need an expert in web scraping, specifically in Python, to extract text data from a particular website. The scraping is a one-time task, not requiring routine updates, and the extracted data needs to be saved in an Excel file (or CSV). This will be hidden behind a login wall - so I suggest that the Python script will go to the website and then wait one minute, where I will manually log in. Ideal Skills and Experiences: - Proficiency in Python for web scraping - Experience with scraping text specifically - Ability to deliver the required output in a CSV format

As a business owner, I'm constantly confronted with the tedious tasks of data entry, data formatting, sorting, and filtering. I am looking to automate this process to save time and improve efficiency. Key Features Needed: -A VBA Macro for Excel to automate data entry and formatting of a text (.txt) file. -Automation of data sorting and filtering needs to be incorporated. Ideal Skills & Experience: -Strong proficiency in VBA and Excel. -Experience in automating data entry, sorting, and filtering via Macros. -Real-world experience dealing with text files in Excel. With your help, I envision a tool that ultimately makes my life easier and my workload manageable.

...Laravel Nova CSV Import extension () to troubleshoot and resolve an issue where CSV imports into the Contacts model do not produce errors but also do not result in new contacts being added to our database. The extension has undergone slight modifications, and the problem might be related to these changes. Job Details: Project Basis: This is a short-term project focused on fixing the specific issue described. Environment: Our project uses Laravel with Nova installed. We have a modified version of the Laravel Nova CSV Import extension located in packages/simonhamp/laravel-nova-csv-import/src/Importer.php. Problem Statement: Despite successful data receipt (verified via dump() within the map() function of the for a sample CSV import)

This task requires a dedicated portal using Flexbox and CSS. The task will create a dedicated set of elements on a dedicated new subdomain, which will only contain these products in a nice Flexbox CSS design. Key aspects of the job: - Design based on the current design. - Products listing: Upload and import products from an Excel sheet - Each product should have a sub-page where details of the product are mentioned and listed - Approx 10 types of attributes are to be handled centrally for the products and filtering should also be possible Specific requirements: - The imported data from the Excel sheet should be updated on the portal - existing products to be updated - The products are listed as Flexbox Other requirements: - Work based on a full price offer, invoice to EU company is n...

hi evryone simple project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible by us...project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible...

I have an Excel workbook. I would like to expand that workbook and add an inventory aspect to the workbook. I am looking for a developer with extensive experience with VBA script and custom functions in Microsoft Excel 365. If the first job goes well we will have more consistent work (other jobs) to be done.

I'm in need of a skilled developer who can assist me in parsing a CSV file with a primary focus on extracting date/time data. Key Project Requirements: - Experience with CSV file parsing - Proficient in data extraction, specifically date/time information - Ability to store and present extracted data in an Excel format This project will require a good understanding of handling CSV files and data extraction. Prior experience in similar projects would be a plus. Please provide relevant examples of similar work when bidding. Swift completion, attention to detail, and accuracy are critical for this task. Efficiency and cleanliness of your code are also very important.

...Android OS. KEY DETAILS: - **Operating System:** The modified client must function seamlessly on Android platforms, from Android 8. - **Interface:** This project will be focused solely on command line execution modifications. A GUI interface is not needed. You just need to provide a version that I can trigger via command line, such as: Start: v2ray connect (or ) which .json / .txt file will contain the parameters and server details Stop: v2ray disconnect - **Functionality:** The task will involve modifying an existing app which can be launched via command line. I assume the native tun2socks in the open-source will remain unchanged - Scripting: Shell Script Compatibility - This application should permit scripts to be run from the command line. This requires your android

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.