Vba csv numberformat işler

I have data of greyhounds racing in CSV I need to calculate the ROI for level stakes of £1 (Total Profit/Total Stake) for the following categories: Time of the day in bands of 30 minutes Minutes before the start time down to the minute, in bands of 1 minute Day of the week Racecourse Trap it can be in a google sheet final product but im open to suggestions and generally open to suggestion for the whole project

As a client, I am seeking a proficient coder who specializes in Excel Visual Basic Macro to perform specific operations. I need a practical solution that inserts information from one table to another based on certain requirements. Key Details: - The task involves two Excel ta...configurable. - Table 1 or Table 2 may be or not at the same xlsm file (configurable). - A msg box must appear after the oparation: " [Number] new rows added." - An adept freelancer should provide a report how to configure the Macro, in case of increasing or reducing the number of rows, or doing the basic configuration. Skills and Experience: - Excel Macro Development - Visual Basic for Applications (VBA) - Experience in Data Transfer between Tables - Proficient in Data Check and Comparison - Ba...

Transformation of the file to csv format and shapefile of points.

Attached is an Excel file (CSV). You need to fill in the blue (Milestone 1) and orange columns (Milestone 2). Milestone 1 : Blue Columns You can fill up the 9 blue columns on the excel file from that site []() For each row on the excel, here is the link: … all the way to proposal 456 ... (I already filled up the rows from 457 to 461 as an example to help you.) On each page link, on the top right corner when you hover your mouse, you will see this popup. See picture 1. This is 461 as an example, I highlighted the values in blue. We need to enter those 9 values to the corresponding 9 columns. Milestone 2 : Orange Columns

I'm looking for a highly skilled VBA developer who can efficiently manage Access databases with advanced functionalities. The expert will be specifically focusing on: - Maintaining and managing our inventory database which includes advanced features like queries, forms, and reports. - The developer should be proficient in dealing with Access databases with several tables and relationships. The ideal freelancer should be experienced in VBA development, Access database management, handling sophisticated database relationships and advanced features like queries, forms, and reports. Exceptional knowledge and experience with inventory-related databases will be a significant plus.

I need an expert in R programming language to assist with asset pricing, trading and portfolio construction. The data needing analysis is stored in a medium-sized CSV file. Your responsibilities would include: - Conducting robust data analysis to identify patterns and trends - Building statistical models to predict future asset prices - Developing data visualizations to effectively demonstrate asset performance The ideal candidate is proficient in R programming, with specific expertise in asset pricing and financial data analysis. You should be comfortable working with mid-sized datasets and be able to process CSV files seamlessly. Demonstrable experience with financial trading or portfolio construction will be strongly advantageous. Your ability to create meaningful data v...

Demonstration on how to mass upload listings and menus to Drupal site using .csv (menus is extremely large file)

I need an expert in R programming language to assist with asset pricing, trading and portfolio construction. The data needing analysis is stored in a medium-sized CSV file. Your responsibilities would include: - Conducting robust data analysis to identify patterns and trends - Building statistical models to predict future asset prices - Developing data visualizations to effectively demonstrate asset performance The ideal candidate is proficient in R programming, with specific expertise in asset pricing and financial data analysis. You should be comfortable working with mid-sized datasets and be able to process CSV files seamlessly. Demonstrable experience with financial trading or portfolio construction will be strongly advantageous. Your ability to create meaningful data v...

...Default Hierarchy: Examples (Initiative, EPIC, Story, Task, sub-tasks, bugs) Hierarchy features: parent, child, relationships, Teams assigned to, worker assigned to, and unique-IDs for projects/project tasks. Additional abilities would be the option to attach fields, and external files such as word docs, excel docs, pdf's at the task or project hierarchy level. - Bulk Import from CSV/Excel - Bulk Export from CSV -Customizable percent complete formulas (by task count, task durations (totals days), etc. - Project templates should support KANBAN views, Agile templates, dashboard creation, and link generation restricting access to authorized users. -Ability to create forms and email distribution lists to complete. Simple reporting view with graphs for sender. -...

I'm in need of a skilled Windows API VBA coder to accomplish several specific tasks dealing with 64-bit Excel. Primary duties will include: - Redesigning Windows API call in VBA to be compatible with 64-bit Excel - Handling interactions with Windows API - Employing specific Windows API functions like EnumPrinters, StrLen, and StrCopy An ideal candidate for this project would be experienced in manipulating Windows controls, handling external applications, and automating repetitive tasks. Mastery over translating call in VBA and proficiency with 64-bit Excel are crucial. Your in-depth understanding of Windows API specifics and interactions would be greatly valued.

We need to recruit a VBA coder that also understands Office Scripts. We have several automation projects that we need to work on using VBA, but then transition them to Office Scripts. We need to work in the UK based shift and the person should be available during the UK hours. 1. Candidate should have excellent communication skills 2. Candidate will be working for a UK-based company, so, they should be ready to work on a UK-based shift 3. Candidate should have knowledge of Office Scripts 4. Candidate should have problem-solving and leadership skills

Hi, I have an e-commerce website on CommerceHQ that I am migrating to WoomComm. Unfortunately, CommerceHQ does not offer API support or the ability to export... You will need to do web scraping to create a CSV file of all the reviews by product. This file is then loaded in the WoomCommrce Site to match the products. You will need to provide a random sample of 20 product reviews As of now, there are 12282 reviews. You will need to provide the last reviews as of the Live date

...necessary! Your web crawler module should support almost any web technology so that it can handle almost any page type. The co-working extraction module may be developed or just adapted. Both should extract specific event data periodically from tenthousands of given event web pages. A page training process may be supported to increase reliability. At first the extracted data should be presented in a CSV file format initially (test platform). Later, the data will be stored in a database for further analysis and retrieval (end version). You should also fulfill the following key conditions: * Good knowledge of SCRUM development processes * Ability to make reliable estimations and time plans * Reliable, careful and transparent communication culture * Independent working manner;...

Project Title: Image To Text I am in need of a freelancer who can convert a large number of JPEG images into text. I have more than 20 images that need to be converted. Skills and Experience: - Proficiency in image-to-text conversion - Experience working with JPEG images - Familiarity with converting images into csv format Requirements: - Ability to accurately convert images into text format - Output text format should be in csv If you have the necessary skills and experience, and can meet the requirements, please bid on this project.

We, at India Tech Stack, are on the lookout for an intermediate level Flink developer who is proficient in Java, microservices, Kafka Connect and Apache Flink. A deep understanding of Flink Architecture, Flink Monitoring and Metrics Event Time, ...Architecture, Flink Monitoring and Metrics Event Time, and Watermarking is essential. - Key Responsibilities: - New software development - Optimization of existing systems - The project is expected to last more than 6 months on-site. Ideal skills: - Java - Microservices - Kafka Connect - Apache Flink. Conceptual understanding of: Batch and Stream Processing Formats such as CSV, JSON, Avro or Protobuf Work Location : Onsite - Gurgaon (Preferable)/ Bengaluru Intermediate level experience in these skills is highly ...

Design a macro to systematically compute employee scores in relation to the requisite job scores and subsequently generate a comprehensive list of employees who align with the job criteria.

Hi Dwiwati62, Thanks for contacting me! I am quoting HKD 600 for this project and able to deliver the scraper within 2 days. There are 85 links bu...days. There are 85 links but all the html structure are similar, except this link Therefore, I will need to develop two scrapers for these two different links. For your convenience in the future, you can just put the links inside a csv file, and the scraper will read the link from the csv and scrape. I will provide the Python script executable file and the scraped data in csv form and send them to you through any channels you would like to. I am also provide 30 days maintenance starting from the date of project finish if there is a bug for the script.

I'm seeking a fre...are straightforward: - I will provide a CSV file that contains the text for each of 400 images. - Your task will be to copy the text from the CSV file and create PNG images using the text and a simple, plain background, for upload to Insta. - Each image should carry the dimensions for an Insta post. - Furthermore, all text within the image should be set in a sans-serif font, specifics of which will be determined. Experience in graphic design and proficiency in using Canva or similar software would be ideal for this project. Strong attention to detail is required to ensure all images are formatted correctly in accordance with the project's specifications and saved in accordance with the methodology contained in the csv file. Familiarity...

I'm loo...bath townhouse without basements. Images or tables are not needed in this project. - extract price for sold properties for above specifications - extract count of newly listed and sold properties for above specifications The specific data required from each product listing are: - Product prices Data storage: Data can be store in csv file Or Data can be stored in influx db Data refresh: Every 1 hour Optional: Use grafana to view data stored in csv or influx db The ideal candidate for this project has extensive experience in web scraping and data extraction, and is capable of handling challenges that may arise during the process. Prior work with product data is a plus. Your understanding and application of ethical scraping practices will also b...

Hola, Tengo una tienda online en la que necesito sincronizar mis stocks con los de mis proveedores. Algunos de ellos me proporcionan los archivos CSV, XLSX, XML o similar, entonces puedo sincronizarlos, pero hay otros que no me dan esta información y sólo se podría hacer visitando la web, accediendo con mis datos de distribuidor y visitando cada producto y cada variante. Naturalmente como tengo miles de productos no me es viable estar mirando cada producto para poder saber si hay o no hay stock y lo que necesitaría es una forma de obtener un CSV a partir de la web del proveedor, donde me diga si cada producto y variante (o combinación) está disponible o no y así poder actualizarlo en mi tienda.

Whaticket es una software open source que se encuentra en la plataforma () busco un desarrollador que puedo agregar los botones de; agregar contactos en formato vcf y/o csv, bulk whatsapps y que los usuarios con rol "Users" tengan ciertas restricciones

I'm in need of a proficient Python developer experienced in data preprocessing and cleaning. We've got a sizable CSV dataset in need of some sprucing up before it is ready for our pre-trained model. Particularly, the following tasks need to be impeccably executed: - Removal of missing data: Eradicating instances with incomplete information. - Duplicate handling: Identification and exclusion of recurring data points. - Data format standardization: Ensuring data consistency across the board for seamless processing. Skill set needed include proficiency in Python, experience with PowerBI and web scraping, alongside knowledge of PyTorch. You should be well-versed in data cleaning strategies and tactics for large datasets. The budget allocation for this project is tight at 50$...

I am looking for a freelancer who can help me automate formulas and calculations in Excel. I have specific details and requirements for the formulas and calculations that need to be automated. I am open to suggestions on how the automated system should look or function, but I do have specific requirements that need to be met. Skills and Experience: - Strong proficiency in Excel and VBA programming - Experience in automating formulas and calculations in Excel - Ability to understand and implement specific requirements for the automated system

I'm in need of a Python script that can translate a multilingual CSV file automatically. Specifically, I am interested in having multiple languages supported. This offers a tremendous opportunity to showcase your coding prowess and gain long term partnership with my regular projects. I need Python script for a CSV File that can translate into different language. One column on the CSV file needs to be translated.. I need a script for a massive translation of CSV files from English to multiple languages. The product title column needs translation only. It's important the original format of the CSV files is kept in transcriptions. It might needed to use Google APIs for translation or Chat-GPT for massive auto translation functions. Languages req...

I am looking to have a customized Excel VBA program developed. The primary function of this program would be to generate reports using data collected by a data logger in CSV format. • The type of data to be processed includes but is not limited to sales data, customer information, and product inventory. • The data will be collected by the data logger at varying intervals; daily, weekly, or monthly. As such, the VBA program will need to accommodate this variability. The ideal freelancer for this task should have excellent skills in VBA programming, experience with data processing, and understanding of report generation. A background in working with sales data, customer information, and product inventory would be advantageous.

...must be able to identify and extract relevant information based on the client's requirements. - The data scraping is a one-time task, meaning it will be performed only once and not on a recurring basis. - The script should be able to navigate through different pages and categories on the Amazon website to extract the desired data. - The extracted data should be saved in a structured format, such as CSV or JSON, for further analysis and processing. - The developer should have experience in handling large amounts of data and ensuring efficient and reliable scraping. - Attention to detail and the ability to handle potential changes in the Amazon website's structure are crucial for successful scraping. - The project timeline and budget will be discussed and agreed upon with...

I'm looking for an expert Excel VBA coder to develop an inventory management system for me. Your tasks will include but are not limited to: - Automation of Data Entry: I aim for an efficient system where manual data entry is minimized. - Report Generation: The system should generate comprehensive reports on stock levels, sales, and other important statistics. - Macro Development: I'm looking for a coder who can develop user-friendly macros to simplify tasks and processes. The specific functionalities I need the inventory management system to possess include: - Stock Tracking: I need an effective way to track the inflow and outflow of goods in the store. - Automatic Data Entry. A home page sheet where I can select the type and quantity of material to be added/issued from...

File Conversion Project I need help converting multiple documents into different formats. Requirements: - Expertise in file conversion and formatting - Proficiency in working with various file types, including PDF, Word, Excel, and text files - Experience in converting files to Excel, txt/csv, or Access formats Tasks: - Convert a variety of documents (word, rtf, txt, and pdf) into desired formats - Ensure the integrity and accuracy of data during the conversion process - Organize and format the converted files according to specifications Skills and Experience: - Strong understanding of file conversion techniques and tools - Proficient in working with PDF, Word, Excel, and text files - Familiarity with Excel functions and data manipulation - Detail-oriented and able to maintain d...

I am looking for a freelancer to help me with my project. The main task is to import both text and image data into my MERN project. I would like the freelancer to customize and adapt the data to fit my project's requirements. Data Import: - Import both text and image data - Import data from a CSV file Timeline: - The project needs to be completed in less than a week Ideal Skills and Experience: - Experience working with MERN stack - Proficient in data import and manipulation - Familiarity with CSV file format - Attention to detail and ability to adapt data to project requirements

...combinations of valves on and off according to pre-defined process. - The system should be customizable and allow for easy configuration of the valve combinations and the process itself. - The system is completely offline. All interaction with the system shall be done using a physical interface (uSD card for instance). Ideally the process setup shall be done in a separate file like a text file or csv so changes to the process are easy without the need to compile, flash etc. - There are different phases for the process. For each phase the main pump shall be turned off for a defined time (e.g. 30s) and the the valves switched to a predefined combination. After the defined time, the main pump is turned on and runs for a predefined time. - There will be a few programs. Each progr...

As an individual who has taken the first steps towards digitizing data management, I am seeking a proficient Android developer who can transform my existing Excel-based userforms into an enticing Android appl...- A critical feature of this app would be its capability to sync data effortlessly to an external Excel sheet. Hence, experience in database sync technologies is a must. All in all, a successful candidate should demonstrate ample experience in Android application development, a knack for intuitive UI/UX design, and familiarity with data syncing between Android and Excel. While the knowledge of VBA isn't required, it could be advantageous to understand the context of the userforms better. Let's enhance the usability of our userforms and bring this vision to the fing...

Create two things 1- power bi 2-excel sheet using VBA 3-Pdf or doc. report

...coming from the existing tables and one of the existing Dashboard data to be bring into the system 3. LOGIN: Login should for multiple tenants if user wants to login and he/she has multiple tenants. There should be a dropdown where he/she ca select tenant and all the data will be displayed for that tenant. 4. EMPLOYEE DETAILS: Minor Changes 5. IMPORT DATA: Functionality to import data from .csv file is to be added. a. Employees import and set as needed default fields or insert into respective tables. b. Import Monthly Deductions (3 Different types) while giving respective existing data effect by updating and printing the imported data with financial data in reports c. Import the Communication Achieving 6. YEARLY PROCESS a. Create entries for the next 12 months for the live...

I am looking for a machine learning expert to help me with an image recognition project. I have a dataset in CSV format that I would like to use for this project. The ideal candidate should have experience in image recognition and be proficient in working with CSV datasets. Especially Single Shot Detector and Faster RCNN algorithms needed. Google colab and local machine trainings should be done. I have the dataset VOC, yolo format and XML type. I can provide a dataset compatible with my data set.

Básicamente tengo un archivo CSV y quiero pasarlo a un archivo JSON

...chatgpt translation need to be done for a CSV File Translated to different language, only one column on the csv needed to be translated... we need a script for a massive translation of CSV files from English to multiple languages. The product title column needs translation only. It's important the original format of the CSV files is kept in transcriptions. It might needed to use Google APIs for translation or chatgpt functions for massive auto translation functions. Languages required for translation include: - German - Spanish - Italian - Dutch - French - Portuguese - Arabic, etc... Ideal skills for this project include: - Advanced level in the languages mentioned above - Previous experience in fast script writing - Excellent knowledge of ...

Cần xử lý file thô từ hệ thống thành file hoàn chỉnh .

I am looking for a freelancer who can help me prepare my products for import into Shopify. The products should be prepared in CSV file that I just need to "IMPORT" it to my shopify shop. Platform and Format: - Currently, I have my product data stored in a Word Doc and jpg files. - I will provide these files to the freelancer for import. Product Data: - I do not have a specific format for my product data, so I will need assistance with formatting. - The freelancer should be able to work with Word Doc and jpg files to organize and structure the product data. Number of Products: - I have less than 50 products that need to be imported into Shopify. Skills and Experience: - Experience with Shopify and product import is essential. - Strong attention to detail to ensure acc...

...Israeli payment gateway utilizing an API, and should be orchestrated via Make. Key Features: - The client interface should incorporate a live chat support to facilitate real-time client interactions. - In addition to this, an internal dashboard should be developed to cater to the management team's needs, providing them with an overview of customer interactions and data. - the client will upload a csv which needs to be parsed and entered into airtable Ideal Candidate: Ideal candidates should be adept with the mentioned software (Airtable, Bubble, Make), and should have profound experience in developing web applications, WhatsApp bots, customer chatting systems, and integrating payment gateways. A strong understanding of developing customer support oriented systems will com...

Project Duration: 1 Hour Project Type: CSV to SQL database Project Difficulty: Standard Project Overview: We have a large CSV of 2.0GB that we would like converted into a SQL database ready for us to import view MySQL 5* FEEDBACK WILL BE LEFT FOR YOU

I require a web-based tool (dashboard) for data collection. To facilitate this, I plan to purchase a web template to avoid designing and programming from scrat...sort locations by various criteria such as location name (alphabetically), city, canton, and business category. 3. Search Functionality: An integrated search function that enables searching by location name or filtering locations by their category. 4. Data Selection and Export: The ability to select individual locations and export the associated data in common file formats like Excel (XLSX) or CSV for further analysis and reporting. 5 .Login System: A user authentication system allowing access only with a username and password. Please provide me with a quotation and outline how and with what technologies you would imple...

I'm seeking an expert web scraper who specializes specifically in extracting images from e-commerce websites. The main task is to navigate through multiple e-commerce platforms and collect visual content. Key Requirements: - Proficiency in web scraping tools and techniques. - Previous experience with e-commerce websites scraping is advantageous. - Ability to export and organize scraped data in CSV format. This project demands a high level of accuracy and efficiency, with keen attention to detail to ensure that all required images are appropriately captured and categorized.

I am seeking an experienced developer to create an automatic scraper to gather data from a chosen website. The ideal candidate will be proficient in data mining and extraction. Specifically, what I require is: - A scraper for Website A - Extraction of text content, images, and links - To deliver the extracted data in CSV format Your expertise should cross the following areas: data scraping, web crawling, and handling CSV formats. Awareness and understanding of potential website barriers to scraping (such as CAPTCHA or javascript challenges) is highly beneficial. Please, provide examples of previous similar projects when placing your bid.

Need someone to create or build a job board website that uses data from the attached csv. Data must read from mysql or another DB on the server side. Can use any thing from wordpress to Django to node etc.

I need an Excel application that performs both data entry and calculations, and at the same time, is capable of automating repetitive tasks. This involves dealing primarily with sales data and inventory tracking. Here's what I'm looking for: • A system t...same time, is capable of automating repetitive tasks. This involves dealing primarily with sales data and inventory tracking. Here's what I'm looking for: • A system that can efficiently enter and compute sales data and inventory tracking details. • An application that automates repetitive tasks to simplify the working process. It would be great to find someone with a strong background in Excel VBA, who can deliver this project within a month. The ideal candidate should have a solid understand...

Primer mandato, copiar una a una las columnas f,g,h…zww desde la fila 9910 hasta 10009 de la hoja2 e ir pegando los valores en la columna b 9897 hasta 9996 de la hoja 2 Segundo mandato copiar una a una las columnas xaa,xab,xac…xau desde la fila 2 hasta 944 de la hoja2 e ir pegando los valores en la columna bn 8950 hasta 9892 de la hoja 2 Intercalar primer mandato con el seundo, Por cada columna que copie y pegue del primer mandato copiar y pegar todas las columnas del segundo mandato Cada vez que la celda b 9896 de la hoja2 sea mayor que 15 copiar la columna b 9894 hasta 9996 de la hoja2 e ir pegando sus valores a partir de la primera celda vacía de la hoja 1

...line, and as a .txt file. The crawler would use those to crawl. I would like to specify how many businesses to return, with a default value of 20 if I don't specify (or I can change the script before I run it to a different number). So this by default would be about 2 pages of Google results. All the gathered data must be meticulously compiled into a CSV file in the format just like the example (). The columns in the csv that are empty still need to be in there for proper import into my Wordpress site. I am particularly looking for someone with a wealth of experience in web scraping, data mining, and the like, coupled with an understanding of the Google Search function and locations. Proficiency in using Python, Scrapy, or other similar tools is desirable. Tim...

We need to recruit a VBA coder that also understands Office Scripts. We have several automation projects that we need to work on using VBA, but then transition them to Office Scripts. We need to work in the UK based shift and the person should be available during the UK hours. 1. Candidate should have excellent communication skills 2. Candidate will be working for a UK-based company, so, they should be ready to work on a UK-based shift 3. Candidate should have knowledge of Office Scripts 4. Candidate should have problem-solving and leadership skills

...with my VBA code in Excel. I'm not exactly sure what the error message is, but it's preventing me from using the VBA code for business analytics decision making. The VBA code is meant to automate tasks related to business analytics. However, I cannot detail the specific tasks because I am not receiving any positive results from the current setup. Your expertise in VBA, Excel, Debugging, and Business Analytics would be greatly beneficial in resolving this issue. Skills and Experience Required: - Strong VBA and Excel skills - Experience with Debugging - Background in Business Analytics - Problem-solving Skills - A keen eye for detail to identify the bug in the current VBA code - Excellent communication skills to explain your debuggi...

I'm searching for a seasoned data engineer with adept skills in AWS services such as Lambda, Red shift, S3, and Step functions along with a solid proficiency in Python. The main task on ...engineer with adept skills in AWS services such as Lambda, Red shift, S3, and Step functions along with a solid proficiency in Python. The main task on this project involves: - Data Processing: You will use the AWS services along with Python to process CSV files. The ideal candidate should have: - Proficient skills in Python programming and AWS services. - Significant experience with data processing, particularly CSV file formats. - Proven expertise in data transformation. The ideal outcome of this project is the successful transformation of our CSV datasets through the exp...