Excel macro save as csv with filename jobs
I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what y...
The program is designed to facilitate the simple handling of orders in a restaurant kitchen. Waitresses will be able to add orders through a panel in Window #1, which will allow managing the orders displayed in Window #2. Window #2 will be dedicated solely to displaying current orders. Window #1 will fe...can be added to or removed from the cart. Once an order is completed, it will be possible to send it to Window #2, where it will appear on the list of orders to be processed. From Window #1, it will also be possible to delete orders that have already been displayed in Window #2. Additionally, Window #1 will provide an option to preview orders currently displayed in the kitchen. The program will save the order state to ensure that, upon closing and reopening, the previous state is...
...expert to update my Excel dashboard. This dashboard is currently used for reporting the daily status of equipment. The update should streamline the process, making it faster and more convenient. Key Tasks: - Revamp the Excel dashboard to improve its efficiency - Incorporate equipment status and availability as primary data points - Ensure the new setup accommodates future needs - Due to much formula, the sheet is slow to navigate Currently, I manually input the status and availability of equipment into the dashboard. The updated dashboard should ideally reduce the manual workload and make the reporting process more efficient. Skills and Experience Required: - Proficiency in Excel, with a strong understanding of dashboard creation and management - E...
Project Title: Python Script to Query ArcGIS REST API and Save Layers (including Parcels) Data in PostgreSQL Description: I need a Python script to interact with the ArcGIS REST API of the provided service. The script should: Retrieve and list all available layers and tables from the service. Specifically query the (14) table to extract parcel data, including geometries and attributes. Save the retrieved data into a PostgreSQL database with a properly defined schema. API Reference: or or
I need an expert in Excel VBA to breathe new life into my project. The enhancements will involve: - **Data processing and automation**: Improving the efficiency and speed of data handling processes. - **User interface enhancements**: Making the project more user-friendly with better forms, buttons, and navigation. - **Integration with external systems**: Ensuring seamless connectivity with other platforms and systems. The user interface improvements will focus on: - **Forms and input fields**: Streamlining data entry and enhancing usability. - **Buttons and navigation**: Simplifying the user journey through the project. - **Report layouts and visuals**: Upgrading the presentation of data for better comprehension. Visually, the reports will need: - **Better ...
...streamline your CRUD operations and save you valuable development time? Join our dynamic team and get the chance to use Xcrud, the powerful PHP framework that simplifies database management! About the Position: As a Web Developer at our company, you'll work on exciting projects where you'll leverage cutting-edge technologies to build scalable and efficient web applications. We’re looking for someone with: Strong proficiency in PHP, MySQL, and web development frameworks Experience in building and managing dynamic websites and apps Problem-solving skills and the ability to handle complex data management tasks Why You Should Join Us: We understand that your time is valuable, which is why we use Xcrud to power our database management syste...
I'm seeking a professional adept in web scraping and macro automation. The project primarily involves: - Scraping financial data from company websites. - Extracting contact details from these websites. Ideal candidates should have extensive experience in data scraping, with a strong understanding of financial data and company websites. Proficiency in macro automation is a must. Please provide examples of similar projects you've completed in your proposal.
I am looking for a Hindi-speaking individual to visit our warehouse in Port Klang, Malaysia. The purpose of this visit is to teach a small group of our Indian staff (1-5 members) basic computer skills. Skills to be taught include: - Using a web browser - Using Google Sheets - Using Microsoft Excel The level of proficiency we aim for is basic. Your role will be crucial in helping our staff become more computer literate and improving their productivity. Ideal candidates will have: - Proficiency in Hindi and Malay - Strong knowledge of basic computer skills - Experience in teaching or training - Patience and good communication skills
1) Collect data, examine it, and identify any duplicates or outliers, ensuring its completeness and accuracy. 2) Create a table and organize the data in a clear and easy-to-understand format. 3) Provide statistical analysis using mean, median, mode, variance, standard deviation, and other relevant metrics. 4) Present charts that illustrate the relationships between variables 5) Present charts that help predict future trends, identify gaps, and improve performance and operational efficiency.
...complete this questionnaire sheet this weekend, so may I request your professional English writing expertise. Fill out the attached sheet to provide input for this comedy writing material based on rationality in everyday life. I welcome you to read the following first, then check out the sheet, place a bid. It would be kind of you to provide the answers using quality English grammar in the attached Excel spreadsheet within 2 days. Allow me to observe your progress after the first hour so I can provide early feedback on your answers. Get into the spirit of comedy writing, consider all the witticisms and wordsmith techniques, and provide your best answer to each of the questions (70+). Look for inspiration online around jokes, puns, irony, repartee, sarcasm, memes, idioms, brainy-...
I need assistance with my Excel workbook. - Software: The data is in Excel. - Tabs: The workbook contains 1-5 tabs. - Specific Columns: Only column D is being checked for hidden text. The project involves going through the rows on each tab and widening the rows in column D so all of the wrapped text can be read.
I'm looking for a one-time web scrape of an eBay page containing 5,500 products. The products do not have any variants, which should simplify the task. Data to be scraped: - Product name, price, category, subcategory, brand - Product description and images The final deliverable should be an Excel/CSV file containing all the scraped data. Ideal skills for this project include: - Proficient in web scraping - Experienced in data organization and Excel/CSV Please, only bid if you can deliver quality work in a timely manner. Thank you!
I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Budget is 30 usd it could lead to ...
I need assistance with renumbering my Excel file. The task involves: - Sequentially numbering all rows in column B with simple integers (1, 2, 3, ...). The freelancer should be proficient in Excel and have experience with data manipulation and formatting.
I'm looking for a skilled data scraper who can collect both organic and paid Google search results for me. The data will need to be delivered in CSV format. Ideal Skills and Experience: - Proficient in web scraping tools and techniques - Experience with data extraction from Google - Knowledge of SEO and understanding of organic vs paid results - Ability to deliver data in specified formats, particularly CSV - Prior experience with similar projects would be an advantage. Please include examples of your previous work with Google data scraping in your proposal.
I have an Excel sheet locked with input data that needs adjustment for proper calculations. The sheet is primarily for data analysis. Key Tasks: - Unlock the sheet to facilitate modifications - Adjust specific numbers to correct data input errors - Modify calculation formulas to ensure accurate outcomes Ideal Skills and Experience: - Proficiency in Excel, including unlocking sheets, modifying data, and adjusting formulas - Strong attention to detail to identify and correct data input errors - Experience in data analysis to understand the context and purpose of the adjustments
I need mixed data (text and numbers) from a PDF entered into an Excel spreadsheet. The ideal freelancer should be proficient in data entry, have excellent attention to detail, and be experienced in working with both PDFs and Excel. Key Requirements: - Entering mixed data (text and numbers) from a PDF into an Excel spreadsheet - Formatting the data into standard tables - Applying conditional formatting as per the requirements Please ensure you have a strong understanding of how to implement conditional formatting in Excel, as this will be a crucial part of the task.
I'm looking for a skilled VBA programmer to enhance my existing code. Around 75% of the code is already written to read data from CSV/Excel. The enhancements should facilitate the generation of summary reports, creation of various types of graphs and additional data processing functionalities. Key Responsibilities: - Modify existing VBA code to create summary reports. - Develop functionality to generate Bar charts, Line graphs, and Pie charts. - Implement additional data processing capabilities including data filtering, sorting, and aggregation. Ideal Skills: - Proficiency in VBA - Experience with Excel and CSV data processing - Strong understanding of data visualization techniques - Ability to create comprehensive summary reports Please note, th...
I have a set of 69 KPIs in an Excel sheet, spanning across 10 projects. I need a performance formula that will automatically provide the KPIs/projects status based on specific thresholds. It's important to note that some of the KPIs are negative metrics. In addition, I require an interactive dashboard for these KPIs. The entire project is in Arabic. Key requirements: - Devise a performance formula that can assess the KPIs/projects status based on predetermined thresholds - Create an interactive dashboard in Microsoft Excel - Understand and cater for negative metrics within the KPIs - Project is in Arabic, hence understanding or capability to work in Arabic is a plus Ideal skills and experience: - Proficient in Microsoft Excel - Experience in creating interactiv...
...example Excel file. Data needs - Data extraction for last 30 trading days of sovereign bonds from Kenya, Burkina Faso, Sao Tome and Principe (São Tomé-et-Príncipe), Ghana, Liberia, Zimbabwe, Peru, El Salvador, Sierra Leone, and Namibia. - Platforms that may be used include Cbonds, Bloomberg, Refinitiv Eikon, or Market Axess, etc... - Specific data columns required: issue (bond name and detail), date, time of last trade, stock exchange, bid, ask, bid ask spread, min, high, close, indicative and indicative type, volume of transactions in monetary units at par, volume of transactions in securities, turnover, number of deals. Technical requirements Ability to select all countries, date range, bond type, and status (outstanding/active) on a financial analysis ...
I'm looking for a freelancer who can enter data from an Excel sheet into my e-commerce website. This task involves working with electronics products and requires attention to detail and technical understanding. Key Responsibilities: - Enter product data from Excel(upto 5K data) into the website. - Include all necessary product descriptions, focusing on technical specifications and usage instructions. - Upload product images alongside the descriptions.
I need assistance uploading 1000 products to my Magento store. Product Information: - I have all the product details ready which include descriptions, images, and pricing. - The information is not in a standard format, so some preliminary data processing may be needed. Skills and Experience Required: - Extensive knowledge and experience with Magento is essential. - Proficiency in data processing and Excel is required, as the product information will need to be formatted for Magento. - Attention to detail is critical to ensure all product information is uploaded correctly.
What I would like to do is create a service ticket that users (picked from a drop-down list) can fill in data (customer name, telephone number and reported problem) Dropdown List (building number and room or door number) Save the data to the same file, Later recall ticket fill in work performed and then have customer sign it, save it back to the same file, be able to email it, print it, and keep the ticket forever. Have a way to find it later and update it if necessary. I would also like to have each new ticket auto number (ticket 001, ticket 002) Auto date (ticket created, ticket updated, ticket signed) Have a drop down of users (individuals who create tickets), Buildings, rooms doors plus any other miscellaneous data needed in a text box. A fillable area for work performed...
Hi, Iam are looking for a highly qualified development team capable of working with Java and Vaadin. Ideally, you already have a pre-built Java Vaadin platform that can be extended, as our goal is to save time and launch quickly. In addition, parts of the solution must support Progressive Web App (PWA) capabilities. We look forward to hearing from you! Key Requirements: Java & Vaadin Expertise Proven experience with Vaadin framework (preferably with existing reusable components or a pre-built platform). Strong understanding of Java (including Java 8+ features and best practices). PWA Readiness Ability to integrate or develop Progressive Web App features for designated parts of the platform. Offline capabilities, push notifications, and other PWA...
I'm seeking assistance in creating an Excel spreadsheet dedicated to customer data entry. The primary focus will be on tracking customer contact details. Key Requirements: - Proficient in Microsoft Excel - Experience in data entry - Ability to maintain accuracy and confidentiality Ideal Skills: - Data Management - Attention to Detail - Proficiency in Excel Functions and Formulas
...system. Scan Page: Connect the network IP input field with the Network Scanning Scripts (Python Scripts). Connect the scan type selection field (from 10 available types) with the appropriate scanning script (each scan type is linked to a specific script). After the scan is completed, a CSV file containing the scan results will be generated. The path of the CSV file will be passed to the Merging and Analysis Scripts, which will merge the data with the existing dataset (ready) and generate the final report. Report Page: Display the final report generated from the scan and merging process. Profile Page: Display user information and the network addresses that have been scanned. Your Tasks: * Develop the Backend to connect the frontend with...
I have over ten Excel files containing sales figures organized by product. All these files have the same format, making them straightforward to merge. I'm seeking a freelancer who can expertly consolidate these files into one comprehensive total sheet. Ideal Skills: - Proficient in Excel - Data Analysis - Attention to Detail - Experience with Data Consolidation
I'm looking for an Excel sheet that generates newspaper bills for approximately 150 houses on a weekly basis. This should include the delivery charge and provide a total for each week, as well as a 4-week total, excluding holidays or days when the paper isn't delivered. Key Requirements: - The bill should include the house number and address, total number of papers delivered, and the week's total cost including the delivery charge. - I need to manually enter non-delivery days. - The final summary of the total weekly and 4-week costs should be displayed in the same Excel sheet. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in creating complex sheets with formulas and functions. - Previous experience i...
I need a meticulous professional to assist with data entry from scanned documents. The data consists of both text and numbers, and needs to be accurately transferred into an Excel spreadsheet. Ideal Skills: - Proficiency in Excel - Excellent attention to detail - Prior experience with data entry from scanned documents - Ability to handle mixed data types (text and numbers) - Strong organizational skills
I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what y...
I need assistance with an Excel task. The project involves adding rows in Excel based on a specified number in a cell. Key Requirements: - Adding new rows containing specific formulas - Ensuring that the formulas in the new rows reference fixed cells Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in working with Excel formulas - Detail-oriented with a good understanding of fixed cell references in Excel
Scrape data from an auto part website and create CSV. You will also get images without copyright. Project must be in Shopify standards and be ready to upload. Scraping may be over 15k sku's
I'm seeking a skilled data scraper who can gather product descriptions and pricing information from a specified auto parts website. Key Requirements: - Scraping data for more than 2000 products - Creating a well-structured CSV file - Formatting product descriptions in plain text Ideal Skills: - Proficient in web scraping tools and techniques - Experienced in data organization and CSV creation - Attention to detail to ensure accurate data collection Please only apply if you have previous experience with web scraping and can provide examples of similar projects.
I'm looking for a proficient Python developer who can create a script for me. The specifics of the project, such as the script's primary purpose, the type of data it will process, and the input format it should accept, have not been defined yet. Therefore, I'm open to suggestions based on what you think would be the best fit for a Python script. Read the file attached for details and say ''Halo' so i know you have read the details Ideal Skills and Experience: - Proficiency in Python - Experience in creating Python scripts - Ability to work with various data types - Knowledge of different input formats, such as CSV, JSON, and Excel files - Creativity in proposing suitable script purposes Please feel free to propose what y...
...Technology StartUp focused on hardware and software development for monitoring natural hazards, such as rockfall, landslides, glaciers and snow and ice avalanches. I need a creative and catchy name for my StartUp that reflects its innovative and cutting-edge nature and our reliable solutions to let our customers sleep well at night. My StartUp helps the customer to: - manage natural hazard risks effectively - reduce risk and increase public safety - in the end, save the customers ass if something happens My StartUp provides solutions for the monitoring of: - mountains, e.g rocks, cliffs, snow, ice, rivers.. - we deal with gravitational natural hazards (=any mass that moves downhill with gravity either quickly or slowly) - these include rockfall, avalanch...
I am an experienced and professional writer with a talent for breathing new life into stories. With expertise in ghostwriting and editing, I’ve crafted engaging content across multiple formats, including biographies, memoirs, e-books, fiction, non-fiction, websites, blogs, and product descriptions. Since 2016, I’ve been a full-time freelance copywriter with double Digital Marketing certifications. With a keen eye for detail and a passion for linguistic precision, I am well-equipped to undertake the comprehensive proofreading and editing of any book. I have a proven track record in editing various written materials, including books, with a focus on preserving the author's voice while refining clarity and coherence. With a decade of...
...to avoid any robotic or AI-generated tone. Project Scope: Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free from plagiarism (verified using plagiarism detection tools). Accuracy: Maintain the factual accuracy and core message of the original articles. Natural Language: Written in a clear, concise, and engaging style, avoiding robotic or AI-generated phrasing. Readability: Optimized for online reading with appropriate use of headings, subheadings, bullet points, and short paragraphs. SEO Considerati...
I need a skilled graphic designer to create 5 eye-catching social media banners for my app. The banners should be visually appealing, engaging, and suitable for various social media platforms. The Content: - Move your money around the world with ease. Use Gloubal! - The Gloubal App. Your money in any currency! Deposit. Exchange. Withdraw. - Buy Data, Airtime, Utility Bills in any country. Use Gloubal! - Save your money in USD, earn up to 21%PA. Use Gloubal! - A virtual dollar card that works on every website. Use Gloubal! Remember to include the 'Download Now' button also on all the banners.
...to avoid any robotic or AI-generated tone. Project Scope: Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free from plagiarism (verified using plagiarism detection tools). Accuracy: Maintain the factual accuracy and core message of the original articles. Natural Language: Written in a clear, concise, and engaging style, avoiding robotic or AI-generated phrasing. Readability: Optimized for online reading with appropriate use of headings, subheadings, bullet points, and short paragraphs. SEO Considerati...
We already have a MySQL cursor with a loop set up to fetch values and perform certain calculations. We need an experienced MySQL developer to extend this cursor with additional logic to populate more values into the table in the most efficient way possible, with minimal overhead on the database. I will provide an Excel spreadsheet with simple formulas required to replicate the logic. The extension involves implementing approximately 9 additional calculations and updating a different table using simple IF statements based on the calculated values. Key Requirements: • Extend the existing MySQL cursor, which already has a loop set up for fetching values. • Implement about 9 additional calculations based on simple formulas provided in an Exce...
I'm in need of an Excel expert who can help automate some of my book-keeping tasks. The main focus will be on reconciling accounts. Your responsibilities: - Utilise experience with excel formulas and macros to refresh existing reconciliation process for the book-keeping and management reporting of a small UK charity. - Ensuring accuracy and efficiency in the automation. Ideal skills and experience: - Proficiency in Excel, particularly in using formulas and creating macros. - Background in book-keeping and accounting. - Experience in automating tasks in Excel.
...to avoid any robotic or AI-generated tone. Project Scope: Content Volume: 4000 articles Source Material: Provided in CSV format (containing article titles and content). Deliverables: 4000 rewritten articles in a specified format (e.g., .docx, .txt, or directly into a WordPress staging environment – to be discussed). Content Requirements: Uniqueness: 100% original content, free from plagiarism (verified using plagiarism detection tools). Accuracy: Maintain the factual accuracy and core message of the original articles. Natural Language: Written in a clear, concise, and engaging style, avoiding robotic or AI-generated phrasing. Readability: Optimized for online reading with appropriate use of headings, subheadings, bullet points, and short paragraphs. SEO Considerati...
...assist with advanced Excel tasks, day-to-day inventory management, and voucher entries. The candidate should be proficient in VLOOKUP, charts, and pivot tables, and adept at removing duplicates. Key responsibilities include: - Utilizing advanced Excel functions for data analysis and visualization. - Regularly updating stock levels and performing inventory reconciliations. - Assisting with various voucher entries, including expenses and income, purchases and sales, and journal entries. - Maintaining comprehensive account books, including cash and bank, sundry debtors and creditors, current assets and liabilities. - Performing BRS and journal entries, as well as managing credit and debit notes and party ledgers. Ideal skills and experience: - E...
I'm looking for a comprehensive list of Honda 2-wheelers dealers across India, extracted from the provided website. The data should be organized in an Excel file with the following characteristics: - Specific Details: For each dealer, I need the dealer name and address, as well as their contact numbers and email. - Geographic Scope: The list should cover all of India. - Data Organization: The dealers should be organized in the Excel file by state. Ideal skills for this job include data extraction, proficiency in Excel, and attention to detail. Previous experience in compiling similar lists would be an advantage.
...and set up a wallet scanner for the Solana blockchain. The current version is not functioning as required, as it is returning inaccurate or false data. The issue is suspected to stem from the API being used, though it could also be code-related. The purpose of the wallet scanner is to analyze wallet performance based on profit and loss (PnL), win rate, and other parameters like weekly or monthly performance. The resulting CSV file must reflect accurate wallet performance metrics. Key Requirements: Data Accuracy: The data in the CSV file must accurately reflect the actual performance of the wallets. Before submission, the developer must verify the accuracy of the output data and ensure it aligns with wallet performance. API Integration: If the curre...
...reliable data metrics such as Profit and Loss (PnL), win rate, and performance over weekly/monthly timeframes. The current implementation is plagued by inaccurate or false data, resulting in wallets with near-zero balances being reported as highly profitable. Despite trying multiple APIs (Solana public API, GMGN API, and BirdEye API) and even scraping data from relevant websites, the results have been inconsistent and unreliable. This project requires a solution that not only filters out fake or non-credible wallets but also provides a robust mechanism to analyze and verify real-world wallet performance. Key Objectives: 1. Data Accuracy: - The output data must accurately reflect the true wallet performance on the Solana blockchain. - Outputs su...
