Excel vba import csv data plot jobs
ShiftScale Digital is seeking a highly skilled and detail-oriented Product Data Management Specialist to join our team. The ideal candidate will be responsible for managing product data imports, edits, updates, and more for Shopify and WooCommerce sites. This role requires expertise in efficiently managing and manipulating data in Excel, building out product catalogs, and creating relationships between products. The candidate should also be proficient in scraping data from vendor websites and formatting it correctly for website display.
...freelancer who can assist me with enriching the data in a CSV file. This file contains information on over 6000 Fast-Moving Consumer Goods (FMCG) products, including product titles and barcodes. Key Tasks: - Go through the CSV file: Identify each product's title and barcode. - Search for the product image online: Using the product title or barcode, find a suitable image of the product. - Download the image: Save the image to your local system. - Organize the images in folders: Each image should be saved in a folder named after the product category. - Rename the image files: Each image should be renamed to match the product’s barcode with a .png/.jpg/.jpeg extension (e.g., ). Ideal Candidate: - Proficient in data analysis and data enrichme...
...aspects of my project - data analysis and automation. Here's a breakdown of the requirements: - **Data Analysis**: The primary task involves analyzing datasets in CSV format. The selected candidate should be adept with NumPy, able to make sense of the data and derive meaningful insights. - **Automation**: The second crucial aspect is automation. I'm looking to automate certain processes in my project that involve database queries. Proficiency in Django will be necessary here. Ideal candidates for this project would have: - **Strong Python Skills**: You should be well-versed with working on data analysis and automation tasks using Python. - **Experience with NumPy & Django**: Proficiency in these frameworks is a must. - **Data ...
...need of a proficient Excel expert who has a solid understanding of Excel macros and compatibility issues with Excel for Mac 2018 or later. The project involves assessing and modifying an existing Excel macro to ensure that it functions seamlessly on Mac platforms. Key tasks include: - Assessing the existing Excel macro and its functionality - Modifying the macro to be fully compatible with Excel for Mac 2018 or later - Implementing the desired modifications related to data transfer, header and footer creation, as well as digital stamp inclusion The ideal freelancer for this project should have: - Proficiency in Excel macro development and modification - Prior experience with Excel for Mac compatibility issues - Strong unde...
I'm in need of an Excel expert who is well-versed in Excel and has experience in creating detailed and visually appealing dashboards for project management purposes. The primary goal of this dashboard is to help me track the effort and progress of my project. The information that I'd like to track includes: - Time spent on tasks - Percentage of completion - Deliverable status The excel is small and has only 15 rows its more like visualization task so that all data can be projected in one place as a dashboard.
I have import an avatar with an animation from Daz to Clo. I want dress it with a complex bikini with a belt. This is not stable in the animation. I need help.
I'm looking for a skilled Excel professional to clean a text-based dataset for me. The dataset is not massive, but it's quite messy. The data cleaning task is relatively straightforward and basic. You'll have to perform operations such as removing duplicates and adjusting formats. Ideal Skills and Experience: - Proficiency in Excel: You should be comfortable working with large datasets in Excel, including applying formulas and functions. - Data Cleaning Expertise: Prior experience in cleaning text data is a major plus. - Attention to Detail: The devil is in the details; I need someone who won't overlook small nuances in the data set. Once the data is cleaned, I'll need you to carry out some basic analysis...
I'm seeking a skilled personal assistant to help with my data tasks, focusing on Excel entry and processing. Key Tasks: - Excel Data Entry: You'll be responsible for entering more than 500 data points. - Data Processing: You will also assist in processing these data entries. Your Skills: - Proficient in Excel: You should be able to work with pivot tables and VLOOKUP functions. - Data Entry Expertise: Demonstrable experience in managing large data quantities is a must. - Organized & Detail-Oriented: The ability to maintain accuracy and precision while handling this large volume of data is crucial. This is a great opportunity for someone who's eager to showcase their Excel skills in a p...
...creation and editing of digital job cards. There is also a requirement for quotes, parts / inventory, archived jobs, and customer management. Both employees and managers will need access to the system, with an admin login section for authorization of completed job cards. We would like the system to export completed jobs to CSV file for automated invoice generation in Quickbooks Online. We will also require the system to import the customer database from Quickbooks in CSV format. Key Functionalities: - Creation and Editing of Jobs - Ability to use system on-site / remotely through the use of iOS or Android web browsing. Some - Ability to select a simple job status from a drop-down combo box eg. In-progress, waiting for collection, waiting on parts, not started, c...
Looking for a Python & Active Directory Expert to create a script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, group policy etc. and export to a MS Excel File. More information attached.
Develop macro-enabled Excel file to handle CSV
I'm in need of a professional who can convert a PDF document to Excel format. The PDF contains a mix of text, tables, and images, which must be meticulously replicated in the Excel format. Key requirements: - Handle mixed content: The PDF has a mix of text, tables, and images. You should be able to accurately translate this diverse content into Excel. - Replicate PDF layout: The layout of the PDF needs to be maintained in the Excel format. This means tables should look the same, images should be placed correctly, and the text should be in the same positions. Ideal skills and experience: - Proficient in PDF to Excel conversions: You should have experience in converting PDF documents with mixed content to Excel while maintaining layout integr...
...as necessary. The purpose of the table extraction is for data analysis. The HTML file has multiple tables with some nested elements, not overly complex. Key Requirements: - Need an expert in Python programming - Familiarity with Pandas and Beautiful Soup - Experience in data analysis The job mainly involves reviewing the existing code, fixing any issues that may hinder the data extraction, and ensuring that the extracted table is ready for analysis. Please note that no additional data preprocessing is required, just fixing the current code. --- name "iXBRL" , inside folder contain multiple html file, each html file contain multiple tables. Python to extract specific table and stack them together to create an Excel file. name "現金流...
...looking for an architect to design my house starting from very basic, I have only the dimension of my plot (I have drawn a very rough sketch of my plot and attached it below). Now you have to design complete house starting from zero. I need complete design of my house, starting from zero. First of all I need floor plans for both floors (Sizes of bed rooms, washrooms, kitchen, drawing room etc everything), then I need 3D rendering of all including front elevation, at the end I need a complete 3D video of complete house design. (There must be a proper ventilation system in complete house including all rooms, baths, kitchen etc). My plot size is 1750 Square feet Dimensions are 35*50. its a corner plot. ---->>> Requirements for ground floor: 2 bed r...
I have a project that requires purely text data entry. I have a set of handwritten notes which need to be entered into a spreadsheet. Key Requirements: - The data is text-based, and it's crucial that the freelancer can transcribe this accurately and efficiently. - Proficiency in using spreadsheet software like Excel or Google Sheets is a must. Ideal Skills: - Fast and accurate typing skills - Proficient in using spreadsheet software - Experience with data entry, especially from handwritten sources
...The design should reflect a clean, minimalist, and contemporary feel. - 3 Story Layout: The home will be three stories, so the floor plans and other details should reflect this verticality. - Comprehensive Views: I require detailed renderings of the front and rear elevations, as well as a bird's-eye view of the entire property. - Additional Drawings: I also need high-quality floorplans and a plot plan to accurately represent the property. Ideal Skills: - Strong Proficiency in architectural design and modern styles - Experience in creating luxury home designs - Proficient in rendering software for detailed and realistic 3D images - Attention to detail and the ability to translate aerial photos into accurate renderings - Strong communication skills to understand and inter...
I need an Excel tool that can sort data by category and provide users with an interactive experience. I'm looking for an experienced Excel developer who can create a user-friendly, yet advanced, Excel tool. The tool should have the following features: - **Filtering**: The tool should allow users to filter data by category. This is a crucial aspect of the tool's functionality, as the data will be organized by this field. - **Interactive Buttons**: I would like the tool to have buttons that allow users to sort data. When a button is clicked, the data should rearrange itself based on the selected category. For example, when a user clicks on the button related to 'Category A', all data entries related to ...
From 2.5 lakh records, need to find the duplicate data and make different sheets with unique data. Example: In a sheet of alphabets, that have multiple A’s, B’s, C’s. Now I need separate them and make a sheet with all A’s, separate sheet with all B’s, another sheet with all C’s.
I'm looking for a professional who can help with Excel work, primarily focusing on formula creation and formatting tables. Key Requirements: - I need assistance in creating formulas that can automate calculations and processes in Excel. - I'm looking for a clean and simple format for my tables, in line with a minimalist style. Ideal Freelancer: - Proficient in Excel, with a deep understanding of formula creation. - Experienced in table formatting and design, with a flair for minimalism. - Able to deliver high-quality, error-free work in a timely manner.
...detailed financial reports and dashboards, primarily based on data from Excel spreadsheets. Key Responsibilities: - Develop compelling, visually appealing reports and dashboards that are easy to interpret and navigate. - Tailor the reports and dashboards specifically to financial analysis, ensuring they provide the insights necessary for informed decision-making. Ideal Candidate: - Proven experience creating financial analysis reports and dashboards in Power BI. - Proficiency in integrating data from Excel spreadsheets. - Strong attention to detail and the ability to translate complex financial information into clear, concise visual elements. This project requires a high level of expertise in Power BI, financial analysis, and data visualization. ...
...to create a standalone origins movie screenplay for a Spider-Man villain that I've named "Venom: Sunset". The story is set in 1389 Tokyo and centers around a misunderstood hero who eventually turns into a villain. Key Elements: - Historical Accuracy: The screenplay should be well-researched and accurately reflect the culture, customs, and events of Tokyo in 1389. - Samurai Fighting Scenes: The plot should include engaging, well-choreographed combat sequences involving Samurai warriors. - Character Development: It's crucial that the protagonist's transformation from a misunderstood hero to a villain is believable and emotionally resonant. Desired Tone: - Dark and Gritty: The overall tone of the screenplay should be dark, intense and gritty. The story s...
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX fo...
I require an expert script writer who can create a bash script for data processing tasks that involve the creation and deletion of files, specifically CSV files. Details: - The main task will involve managing CSV data. - The bash script should be able to create and delete selected CSV files. - I'm looking for someone skilled in bash scripting, especially with a focus on file handling and data processing. - Previous experience in working with CSV files, data manipulation and command line tools will be required. - We need the script to be concise, efficient and capable of running smoothly without unnecessary delays. Looking forward to your interactive and engaging responses.
I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround
...option. The system must run on WordPress and work on it until it is 100% functional. My website is made with Wordpress + Elementor + acf STEP 2: After having the complete system in its entirety, you must import comments that are in a json, in said JSON are the perfumes + their comments and leave it linked and when you add manual comments to each entry, add them normally and add them without problem. The idea is to import all the perfumes + their comments. IT IS IN A JSON WHICH I ALREADY HAVE UPLOADED TO MY SERVER. IT WOULD JUST CREATE SOME SCRIPT TO MAKE THE INTRODUCTION OF THE DATA TO MY WEBSITE. EYE: You must tell me your prices and time, don't ask me my budget, just tell me when you charge and the time it will take and if you are 100% sure you will do...
Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract
I'm looking for a skilled professional who can migrate an existing voicemail manager system from Google Script (Javascript) to Office365. The primary purpose of this migration is to rebuild the system on a completely different platform. Key Requirements: - Proficient in Google Script (Javascript) - Familia...intricacies of voicemail manager systems. The project's success will depend on the freelancer's ability to effectively transfer the existing system's functionalities to the new platform. The system must be rebuilt using Javascript, ensuring compatibility with the desired platform: Office365. I also need help to complete previous project. Help with the following: 1. Batch file to merge Ruckus csv files instead of overwriting. 2. Batch file to find missi...
...Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 300 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automation through VBA. • Good Technical knowledge of VBAs, Macro, MS Offic...
Hello, I need convert a PDF invoice to Excel to import to our invoices software
I'm looking for an experienced Power BI developer to create bespoke reports and dashboards, which will be integrated into Microsoft Teams. Tasks: - Handling data from Excel spreadsheets and converting it into insightful reports and dashboards. Skills and Experience: - Strong command of Power BI for report and dashboard creation. - Proven experience with Excel spreadsheets. - Good knowledge of integrating Power BI into Microsoft Teams. The goal is to make complex data easy to understand, facilitating better decision-making within our team. Your work will directly impact our day-to-day operations and strategies.
I have a Python notebook containing well-structured code that effectively translates a sample of a large dataset from English to Arabic. However, the current code cannot handle the entire dataset due to its size. using : model_name = 'Helsinki-NLP/opus-mt-en-ar' Tasks: - Modify the ...effectively translates a sample of a large dataset from English to Arabic. However, the current code cannot handle the entire dataset due to its size. using : model_name = 'Helsinki-NLP/opus-mt-en-ar' Tasks: - Modify the existing Python code in the provided notebook to translate the entire dataset from English to Arabic. - Ensure the translated data is saved in two formats: Comma-Separated Values (CSV), and Apache Parquet (.parquet) - Provide the CSV and parquet fi...
...a specialized WordPress developer with experience in Excel operations and data showcasing. Key tasks: - Create a WordPress page that extracts numeric and text data from an Excel sheet. - Implement highlights and color-coded information on the webpage for better readability and understanding. - The data on the Excel sheet will be updated on a monthly basis, hence the website should be able to fetch the data automatically upon any modifications. Ideal skills: - Proficiency in WordPress and Excel integration - Experience in creating visually appealing data showcases or infographics - Strong understanding of data extraction and display technologies The aim is to have a user-friendly webpage that accurately repres...
I'm in search of an Excel expert who can assist me with complex tasks in Excel. Specifically, help is needed in two key areas: - Formulas & Functions: While basic arithmetic operations are simple for me, I need assistance with text and date functions. - VBA Macros: I'm looking for someone who can develop advanced user forms and interfaces. This requires a high level of VBA expertise. The ideal candidate would have a strong background in Excel, with a focus on formulas, functions, and VBA. Previous experience working on advanced macros and a deep understanding of text and date functions will be a huge plus. The ability to communicate effectively and understand my specific needs is essential.
I'm in search of a versatile freelancer with skills in Word, Excel, programming, and graphic design. Your expertise in these areas will help me in different domains. Your main tasks will include: - Formatting documents in Word, ensuring a professional and consistent layout. - Creating Excel spreadsheets and conducting data analysis. Proficiency in Excel will be crucial to help me interpret and visualize data effectively. - Developing software or web applications. I am working with Java/Spring/JavaFX and am open to creative development ideas and solutions. - Designing logos and visuals. Your ability to create engaging and unique visuals will be a big asset to my projects. I am currently using Word 2010 and will be working with Java/Spring/JavaFX fo...
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I'm looking for someone who can design a sophisticated budget template for me in Excel. This template should: - Track both income and expenses - Project weekly outcomes - Compare actual amounts to budgeted amounts - Include more than 20 budget categories - Incorporate graphs and charts for visual representation. Skills necessary for this project will include advanced Excel knowledge and experience with financial modeling. The ideal candidate will have previously worked with complex budget templates and be comfortable creating a user-friendly interface. You should know how to devise a system that simplifies input and keeps data organized and easy to understand. Your ability to turn raw numbers into straightforward graphs and charts will be particularly valuable...
I need a professional to convert the information in the attached document into an organized, well-formatted Excel sheet. The project will require you to: - Copy all the text content of the document into corresponding cells in the Excel sheet. - Transcribe all tables and charts in the document accurately into the Excel. - Maintain the original formatting of the data in the document. The Excel document should: - Include all columns and rows from the original document. - Not require any additional formulas or functions.
I am in need of a comprehensive Excel sheet that does calculation. Data entry is not too complex; it includes dates, dropdowns and formulas. Requirements: - Design an Excel sheet that calculates basic arithmetic operations, performs statistical analysis, and handles financial calculations. - The form should be user-friendly and able to accommodate the moderate complexity of data entry. - I need an expert who can create a clear and concise interface for the user, making data entry and subsequent calculations easy and efficient. It would be great if the freelancer has experience with: - Excel design for calculation purposes - Data entry form design - Experience in basic arithmetic operations, statistical analysis, and financial calculations...
Please Sign Up or Login to see details.
I'm looking for a skilled developer to assist with syncing an Excel file to my phpMyAdmin database. Key Requirements: - Real-Time Syncing: The sync should take place continuously in real-time. Any updates made to the Excel file should be reflected in my phpMyAdmin database instantly. Skills and Experience: - Proficient in Excel and phpMyAdmin - Experience in data syncing and database management - Familiarity with real-time data syncing No specific data validation or transformation is needed during the import process. The goal is to ensure that any changes made in the Excel file are accurately reflected in the existing database.
I'm in need of an Excel expert to enhance my files. The tasks include: - Removing duplicate rows - Fixing formatting issues - Merging two sheets into one Additionally, I would like to incorporate a corporate branding style in the file, utilizing appropriate colors and logos. Ideal Freelancer: - Proficient in Excel with experience in data cleaning - Skilled in formatting and merging multiple sheets - Familiar with incorporating corporate branding within Excel
I'm looking for an efficient data entry professional to input a variety of data into Excel for me. The required data includes: - Text data - Numeric data - Date and time data The main purpose of this data entry is to facilitate data analysis and the creation of reports. There are approximately 100-500 data entries in total. Ideal Skills: - Proficient in Microsoft Excel - Excellent attention to detail - Strong analytical skills - Previous experience with large volumes of data input
I need a detail-oriented and efficient freelancer to assist me with a data entry project. The specifics are as follows: - The project requires entering a combination of numeric and text data. - The goal is to have the data organized in a clear and coherent manner. The format of the data is likely to be in spreadsheets, although it may vary. Proficiency in Excel and Google Sheets will be essential for this task. Previous experience in data entry with formulas will be considered a plus. The ideal candidate will be able to deliver high-quality work in a timely manner.
I'm in need of a skilled developer to create a text-based GPT (Generative Pre-trained Transformer) specifically for analyzing excel outputs and give answer according to user pre-defined questions.
Active Directory Expert to create a Python script and test data to capture all meta data linked to and which describes the confined parameters of an AD account, AD RMS (Rights management Services) group policy GPO etc. and export to a MS Excel File. More information attached.
I'm looking for a dedicated virtual assistant to assist me with simple data entry tasks. The data will be provided in handwritten notes. Ideal Skills and Experience: - Proficiency in data entry - Ability to handle simple copy-pasting tasks - Experience with handwritten notes data entry is a plus - Attention to detail and accuracy - Excellent time management skills - Familiarity with tools like Excel or Google Sheets for organizing the data Please note that while the tasks are straightforward, attention to detail is crucial. I'm looking for someone who can deliver accurate and timely results.
I desire a professional Macrodroid developer with a strong portfolio to create a macro for any use. The objective of the macro is to read a CSV file and automatically send a specific WhatsApp message to each phone number listed in the file. Key requirements include: - import a CSV file (Name,Given Name,Additional Name,Family Name,Phone 1 - Type,Phone 1 - Value) - Creation of a macro that automatically triggers WhatsApp messages. - The macro should be programmed to initiate the messages when it reaches a phone number listed in the CSV file. - The message is from CSV or default the same for all numbers in the CSV file. Ideal Candidate: - Proficiency and extensive experience working with Macrodroid. - A proven track record with similar projects. -...
I have a substantial Excel table and I am in need of a skilled data analyst to help with correlation analysis between Column 1 to 9 of my dataset, which contains more than 4200 rows and 9 columns. Need the source file of xls with formula too Key Responsibilities: - Perform accurate correlation analysis on specified columns - Generate line graphs to visualize the correlation Ideal Skills and Experience: - Proficiency in Excel and correlation analysis - Solid understanding and experience with line graph creation - Excellent problem-solving abilities - High attention to detail I'm looking for accurate and efficient work so I can understand the relationship between my data points and act accordingly. Your experience could be the key to enhancing my project. ...
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
