Vba xls csv delimiterKazi

Pozdrav Mario, U Sloveniji ne nađem dobrih programera za Prestashop za normalnu cijenu. Trebam nekoliko popravka u mom templatu u vezi Tabova i importa CSV fila. Kasnije još mnogo drugih radova ali to mi je hitno. Prvi put radim sam trgovinu i zapelo mi je pa bi želeo imati programera koji je sposoban surađivati na dugi rok in je izvrstan u svom poslu. Više info o projektu/poslovima šaljem naknadno. Hvala puno i ljepi pozdrav, Edvard Gepoint d.o.o. +38641607517

I am looking for a freelancer to assist with cleaning and analyzing a small dataset in Microsoft Excel. Key Responsibilities: - Data Cleaning: The dataset includes multiple columns and rows that need to be checked for inconsistencies, errors, and duplicates. - Data A...Proficiency in Microsoft Excel and experience with data cleaning and analysis. - Attention to detail to ensure the dataset is thoroughly cleaned. - Basic data analysis skills to interpret the dataset and present the findings in a clear manner. Please note that the project does not require any specific tools or methods for analysis, but any experience with Pivot Tables, Statistical Formulas, or Macros/VBA would be an added advantage. If you are interested in this project, please include any relevant experience in...

I've compiled a comprehensive global leads d...specific filter. Instead, they're a mix of different categories from various industries, countries, and professions. This eclectic mix provides a wide range of opportunities for potential buyers. - **Delivery Method**: I'm looking to sell this database through a CSV file, online access to the database, and a Google Drive link. This way, buyers can easily access and use the leads without any hassle. Ideal candidates for this project should have: - Experience in database management and sales leads generation. - Proficiency in CSV file handling and managing online databases. - Familiarity with Google Drive for sharing and collaborating on documents. If you're interested in purchasing the database or have any...

I have an Excel file with a macro that I need to be updated for compatibility with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requir...with Excel for Mac 2019 or later. The current macro's compatibility with macOS is unknown to me, and I need an expert to assess and modify the code as needed. Key Requirements: - Update the existing macro for compatibility with Excel for Mac 2019 or later. - Ensure the modified macro functions correctly on a MacBook Pro 2018 intel OS Ventura. Ideal Skills and Experience: - Proficient in Excel VBA and macros. - Extensive experience in adapting macros for cross-platform compatibility. - Knowledge of macOS compatibility issue...

[Deadline Saturday 5 pm EST] Hello, I am trying to create some supervised models in Python based on this Kaggle data set I have started however struggling to finalize the code; Preliminary Data Exploration: Explore the data, and provide some basic summary statisti...logistic regression, and k means (must have visualizations) The goal is to identify the best loans; most profitable, and load status for being paid off DELIVERABLES Finished code with all steps detailed below, data preprocessing and data cleaning, EDA including visualization, Supervised Data Model (Clustering, Decision Tree, Kmeans and Logistic Regression) the models must have visualizations CSV file link: [Deadline Saturday 5 pm EST]

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

I have collected the dataset in CSV format and now require an expert to develop a multi-class logistic regression model for me. Key requirements: - The dataset is ready and available in CSV format which can be used for the model. - You should have expertise in developing logistic regression models for multi-class classification. - Proficiency with Python is a must as I prefer the model to be developed using this language. Technical Requirements: Proficiency in Python and familiarity with libraries such as NumPy, Pandas, Keras, and TensorFlow. Knowledge of statistical learning, logistic regression, and gradient ascent optimization. Ability to write clear and concise documentation and well-commented code.

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

Hello, I need fil a CSV with the Amazon categories in French

...Requirements: Platform: Microsoft Excel and Outlook. Preferred Methodology: VBA for seamless integration with Microsoft Office suite. Other suggestions are welcome if they provide a better solution. Deliverables: Automated Excel Workbook: An Excel file with VBA scripts to automate data entry, courier selection, and order form generation (if chosen methodology). VBA scripts to automate sending and receiving emails via Outlook (if chosen methodology). Documentation: Detailed documentation on how the automation works, including instructions for use and troubleshooting. Testing and Support: Initial testing of the automated system and support for any issues that arise during the first month of operation. Skills Required: Proficiency in VBA for Excel and Outloo...

I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.

Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restau...script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval

Create excel sheet with data for best location of new factory to optimize cost of transportation using three different methods with all data required including VBA code

I need a skilled Web Scraping specialist to write code in Python (preferably) that scrapes a specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're

I need a VRBO scraper to extract property details, pricing, and availability. - The scraper should be built with Python and the output should be in CSV format. - The data points I need include property title, description, amenities, pricing, and availability. - The scraper should be able to handle multiple URLs at once. - The code should be well-structured and commented for easy maintenance. Ideal skills: - Proficiency in Python - Experience in web scraping - Understanding of VRBO website structure - Ability to handle and store data in CSV format

I need a web scraping professional to create a script to extract specifi... - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quotes Quotes+ Bookmarks Bookmarks+ Authentication is done through twitter, I will connect my twitter account and run the script myself Deliverables: - Format: Script that I can run to export the required data in a CSV file. Ideal Candidate: - Proficient in web scraping tools and techniques. - Experience working with online marketplaces and eCommerce data. - Ability to deliver CSV files and automate the process for daily updates would be highly advantageous. - Familiarity with specifically would be a plus, but not essential. Please check the attachment, this is the exact format and data that im looki...

I have a PDF membership directory that was emailed to me. I need someone skilled in data extraction to help convert it into an easily readable CSV file. The ideal candidate should possess: - Proficiency in working with both PDF and CSV file formats. - Strong data extraction skills. - Attention to detail for data accuracy. Each member listed per row with the perinate contact information separated into its own cells ie: entity/last name/first name/address/ste#/city/state/zip/office ph/email/cell ph The task should be completed by 5/23/24.

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

Based on a specific Management zone

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

I'm in need of a skilled freelancer who can perform daily scraping of job titles from Indeed. Ideal Skills and Experience: - Proficient in web scraping, particularly from Indeed - Able to automate the scraping process on a daily basis - Competent in delivering data in CSV format Data Update Frequency: - It's essential that the scraping is carried out daily Delivery Format: - The scraped data should be provided in a CSV file Looking forward to your proposals.

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

...frequency/bpm output. This project is intended for a research project I am undertaking. I am looking to see if FFT/Wavelets are able to produce acurate bpm readings so there is not definitive method to follow which is why I require your help/ Key requirements include: - Utilizing Fast Fourier Transformation and/or Wavelet Analysis to transform the raw temperature data. (Data is in the form of multiple .csv files with temperature readings and time stamps). Ideal skills for this project include: - Proficiency in Fast Fourier Transformation and Wavelet Analysis. - Strong command of R programming language for generating the output in R code. Maximum budget for this project is $100 USD. Required turn around will be approximately one week (the sooner, the better). Unfortunately I...

I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.

I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeValue("0:00:...

We need someone to generate tr...basic: Subject posts: a few lines of text and some tags. (subject posts are often placeholders for the more interesting content: problems and ideas) Problem posts: a few lines of text, tags, a few statistics with sources cited, and a section for "potential harm". Idea posts: : a few lines of text, tags, and a few statistics with sources cited. One last thing, we're bulk uploading to Needpedia using csv files so we need you to pass us the training data in that format. AI can do that pretty easily once the content's generated but getting it to do everything all on its own has been hard. So far we've gotten the best result from our custom gpt by inputting one 'tri-prompt' at a time (a related subject, problem, and ide...

...are still around 500 products still needing to be done. The focus will be on using the Yoast Plugin to enhance Product titles. Increasing the word count of Product descriptions to around 230 words (sometimes creating from scratch using other sites as reference and or using AI to help), then creating search engine title and focus keywords and repairing URL structures if needed. If working through CSV is easier, a data export can be sent with relevant data columns. Key Responsibilities: - Enhancing product descriptions for improved SEO performance - Optimizing meta tags to drive more organic search traffic - Restructuring URLs to align with best SEO practices - Utilizing Yoast Plugin to ensure optimal SEO efficiency for delivery area audience Please submit a detailed project pro...

I'm seeking a talented developer with a solid understanding of Excel VBA and Python to develop a system that generates and runs Python code via a manual button within Excel. The Python code generated should have the capability to work with financial data specifically. Linguistic proficiency in Excel VBA and Python is required; knowledge in XLwings or a similar tool would be a significant advantage.

I'm in need of a proficient data scientist who can assist me in obtaining targeted gene expression data from the web-based database Culling specific gene expression characteristics, such as expression levels in different tissues and co-expression networks are the ma...scientist who can assist me in obtaining targeted gene expression data from the web-based database Culling specific gene expression characteristics, such as expression levels in different tissues and co-expression networks are the main focus. I require the downloaded data to be in CSV format. Ideal Skills: - Data extraction capabilities - Familiarity with gene expression databases - Proficient in handling large datasets - Ability to deliver data in CSV format

Hello, I need mapping a CSV that contains many information and put all words in each column

The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are,...

I need to change the way my web site updates schedules for tv channels. Right now my site scrapes external sites and pickle dumps and returns data to the site. I want a json or csv to upload to updates all channels manually or we can use my admin to update with file.

I'm seeking a data operator skilled in the analysis and visualization of numerical data. The primary task is to handle the numerical data in my CSV file. Key responsibilities include: - Data Analysis: You'll be responsible for performing thorough data analysis on the numerical figures in the file. - Data Visualization: In addition to the analysis, I need engaging visualizations of the data to be created. This will help to communicate the insights effectively. Specific tasks I need help with include: - Descriptive Statistics: You should be able to calculate and present descriptive statistics for the data. - Trend Analysis: You'll also need to identify and represent any trends present in the numerical values. Ideal candidates for this project should: - Have experi...

I'm looking to expand the export capabilities of my OsTicket installation. Specifically, I need to add a feature that allows me to export ticket information to a CSV file. Key requirements include: - Implementation of an additional export feature in OsTicket - This feature should specifically allow for exporting ticket information - The exported file format should be CSV The ideal freelancer for this project would have: - Strong experience with OsTicket and its customization - Proficiency in PHP for making changes to the system - Familiarity with CSV file handling Please provide examples of similar work in your proposal.

I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward to receiving your proposals!

...sources for job scraping, including Google jobs. # Comprehensive Job Details: Extraction of all details included in the job listing, such as job title, company name, location, job description, requirements, etc. # Web Interface: A user-friendly web interface where users can enter the URL of the job listings page and initiate the scraping process. # Downloadable in .csv Format: The scraped job data should be downloadable in .csv format for easy analysis and storage. # Filtering Options: Ability to filter job listings based on old vs. new jobs for specific job verticals (e.g., technology, finance, healthcare) and support for Middle East/GCC countries. # Scalability: The scraper should be able to handle a large volume of job listings from multiple sources without perform...

I need assistance in scraping the entirety of Grainger's online catalog and compiling it into a CSV. The CSV will need to include specific details about each product, including but not limited to the product name, description, price, manufacturer, Grainger number and SKU number. Key Responsibilities: - Scraping the Grainger website for all product details. - Compiling the scraped data into a CSV file. - Ensuring that the data is organized and categorized correctly. Ideal Skills for this Project: - Proficiency in web scraping tools and techniques. - Experience in organizing and compiling large datasets. - Understanding of CSV file format and its use. - Familiarity with Grainger's website and the ability to navigate it effectively. It's importan...

I need a professional adept at advanced Excel functions to create a spreadsheet, whi...The ability to input more than 20 workers' availability. - An advanced combination of automatic and manual assignment based on the available days of our workers considering part-timers. 2. Worker Ability: - A system to allow input about the worker's ability to cover specific sites, based on their previous experience. The ideal freelancer should have a high proficiency in Excel, including VBA, Macros, and writing complex formulas, balanced with an understanding of rota scheduling needs. Experience in the healthcare/pharmacy field would be a plus as well. Your understanding of our needs would help us make this project a success. Good work on this project could lead to more opportun...

I'm looking for a Virtual Assistant with solid experience in Python, JavaScript and VBA, particularly for handling scripting tasks. Ideal Skills and Experience: - Proficient in Python and JavaScript - Previous experience with scripting tasks - Excellent communication skills - Pro-active communication style Main Responsibilities: - Writing and implementing scripts in Python and JavaScript with APIs - Ensuring the smooth execution of various scripting tasks

I'm looking for an expert to engineer an Asana project with a focus on workflow automation. The project should have robust features such as: - Task management: I need a proper setup to facilitate the creation, allocation, and tracking of tasks. - Collaboration tools: The Asana pr...Asana project creation, especially in the field of workflow automation, will be preferred. Your experience in creating an intuitive, professional, and sleek UI will come handy. A solid understanding of efficient task management, collaboration, and tracking tools is also essential. Finally, your ability to understand and translate requirements into action will set you apart. I have attached the CSV file i'm hoping to import and would like suggestions on including templates to use across multipl...

I have a specific custom Google map that I need data from. The data I require includes: Business name, Customers name, Address, City, State, Postcode, website, phone. Key points: - You will be scraping a specific custom Google map - The data needed includes Business name, Customers name, Address, City, State, Postcode, website, phon... Key points: - You will be scraping a specific custom Google map - The data needed includes Business name, Customers name, Address, City, State, Postcode, website, phone Ideal Skills: - Proficient in web scraping techniques - Expertise in data extraction from Google Maps - Experience in handling large datasets - Attention to detail for accurate data gathering. Ideally i would like this in a CSV format. There are aprox 720 records in the custom g...

...write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriate method) integration in Excel that allows calling the GPT-Invoices model and returning the response in the same cell. Skills Required: Experience with OpenAI GPT models and their customization. Strong understanding of Excel, including VBA or other scripting languages for Excel. Experience with integrating APIs with Excel. Familiarity with cloud storage solutions like OneDrive and handling file structures programmatically. Additional Information: Please provide examples o...

I'm looking for a professional who can set up an automatic download of mainly .csv files from FTP, SFTP, https and webscraping-login. The script should be configured to run daily/weekly at pre-defined time - configurable for each file. Requirement: Check after each download that the download has actually been downloaded. Notify user if any errors occur. Key Requirements: - Configure FTP download automation on Windows enviroment or hosted. - Schedule the download to occur at defined day/hour. - Check if download has been succesful. - Clear commented code. I only respond to bids where the bidder clearly has read the description...sorry (not really sorry, lets not waste each others time :) ) I prefer fixed price, but have entered hourly - let me know your suggestion.

...two-week timeline. The Laravel-specific requirements are as follows:- 1. Fix the Home Dashboard to display real data instead of dummy data in Laravel. 2. Implement form data transfer from the website to the CRM Enquiry Menu in Laravel. 3. Ensure that won enquiries are correctly displayed after conversion to contacts in Laravel. 4. Highlight the current menu item on the left in Laravel. 5. Correct CSV download functionality in Contacts, ensuring filters, headers, and special characters are handled properly in Laravel. 6. Enable clicking anywhere on the contact data table to open the view of that particular contact in Laravel. 7. Remove the display of the last date from the top of the contact view in Laravel. 8. Adjust calendar functionality to match design specifications in Larav...

I'm in need of a programmer well-versed in TIA (V18) Unified and JavaScript to assist with a specific task. - **Skillset**: Proficiency in TIA (V18) Unified and JavaScript is crucial. Experience in data manipulation and handling would be an added advantage. Your primary responsibility will be to help me export a datalogfile created in TIA (V18) Unified to a CSV file using JavaScript. The purpose of this export is for archiving, as the datalogfile is stored locally. Please reach out if you believe you have the right skills and experience for this task.

I am looking for a proficient C# developer who can build a .Net 8 Console application with in-depth CSV handling capabilities. You will need to be able to: - Import CSV files; - Validate CSV data, specifically focusing on data format and range checks; - Convert validated CSV data to a c# DTO format; - Post the converted data to an API. Responding to errors is a significant part of the project. The application should be able to handle any issues encountered during the import, validation, or conversion processes seamlessly. Proficiency in C# is a core necessity, with previous experience in CSV handling and data validation highly desired.

The project consist to convert a json format file to some csv format files

I'm seeking a professional to assist with integrating my python scraping script output to my personal WordPress site in real-time. Key Requirements: - The integration should be real-time and without the need for page refresh - The current output of the python script is a CSV file, but can be Json or another Ideal Freelancer: - Proficient in Python and WordPress - Experience with real-time data integration - Familiarity with data formats (CSV, JSON, etc.) - Excellent communication skills to deliver a seamless solution Looking forward to working together.

...will go to 'BodyParts3D', 'Lluis Vinent' and 'Z-Anatomy'. The tools need to be set up for and be owned by the client. Profile: >3 years of experience in tailored projects in Unity Experience in the set up and use of databases Good organization and communication skills Necessary missions (estimated 100 euros): Share the project on Unity Hub Create a database containing a .csv file (the translations) and a series of texts (the definitions), Link it to the objects (the anatomical structures) through the existing functions already set up, Adapt the app for Windows, Mac and Linux, Set up a functional and reactive web viewer, Explain how to paste it on a website and how to update it, Optional missions (estimate...

I require a freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong atte...freelancer skilled in data entry. Unfortunately, I was unable to determine the specific type of data entry needed, total entries required, and the format of the data. However, I am seeking a dependable professional who can adapt to different tasks. Ideal skills include: - Strong attention to detail - Data categorization - Data verification - Data conversion The applicant should be proficient in Excel, CSV, and PDF. This role is likely to involve handling various types of data, so versatili...