Export datatable excel web vbnet jobs
I urgently require an Excel Macro specialist who can: - Automate data analysis and reporting - Streamline data cleaning and formatting - Facilitate sending emails with attachments The data is organized in a single sheet with multiple columns. You'll need to create the macro as soon as possible and integrate it with Outlook for emailing the outputs. Ideal Skills and Experience: - Expert-level proficiency in Excel Macros - Prior experience with data analysis and reporting - Knowledge of data cleaning and formatting techniques - Familiarity with automating email sending in Outlook Time is of the essence so swift turnaround is essential.
...structure, visualizing, slicer and desktop and mobile support, exportable in CSV PDF format Key Requirements: - Connects to Excel files and SQL database - Generates a separate Pivot table - Creates a complete, interactive Dashboard - Automatically updates all tables after a new order is added - Performs forecast analysis (time, client, items) - Conducts graphic analysis (using Bar, line etc.) - Allows export of reports in CSV, PDF formats - Offers mobile compatibility for dashboard access - A separate sheet must be provided for all formulas/arguments for each column function. The most critical feature of this program is an interactive dashboard. Experience with Excel, SQL, and dashboard creation is essential. Understanding data analysis and visualization technique...
The project will be due in two parts: (i) the excel example matching and the Nelson & Siegel fitting and (ii) the MBS valuation and risk measurement part.
I have a Java source code from GitHub that requires some adjustments. The modifications needed include: - Feature Additions: The primary task is to integrate the code with other services. - Data Export/Import: I would like to add functionalities related to data export and import. The final deliverable should be a JAR file, which I can run on my machine. Ideal candidates for this project should have: - Proficient knowledge in Java - Experience with GitHub source code - Ability to integrate code with other services - Skills in developing data export/import functionalities. Please bid only if you can deliver high-quality work in a timely manner.
I'm looking for a professional to help me list fashion accessories, specifically jewelry, on eBay. The items to be listed will mainly be necklaces, earrings, rings, and bracelets. I have a spreadsheet with 7,300 listings and I need someone with bulk uploading knowledge/ experience because manual will take too long. I can do any excel formatting needed for it to be published such as categories etc but I don't know how to upload it and keep getting an error.
I'm conducting interviews with experienced graphic designers who have extensively used the Canva platform, primarily for large-scale projects. Your insights and expertise will greatly contribute to my research. Ideal candidates should: - Be able to share insights on various design types created on Canva - Possess an advanced level understanding of Canva -...primarily for large-scale projects. Your insights and expertise will greatly contribute to my research. Ideal candidates should: - Be able to share insights on various design types created on Canva - Possess an advanced level understanding of Canva - Have experience working with a diverse range of clients Interviews will be conducted via chat or call. The main objective of the research is to export and share large projec...
...collect soccer betting odds and data for various leagues over the past three years. This data should be neatly organized in an Excel workbook, with separate tabs for each league and year. Key Requirements: - Data points: Closing odds and Match results. - Leagues: Premier League, La Liga, Serie A and 5-6 additional leagues of my choosing. - Excel interface: I need a user-friendly interface to easily add other leagues in the future. - Data updates: The system should be designed for manual updates. - Data points: Specify the source for closing odds (e.g., 2 x major bookmakers). Ideal Skills: - Extensive experience with Oddsportal. - Proficiency in data scraping and Excel. - Previous examples of similar projects to demonstrate capability. Please provide a time and co...
I have a PDF file containing 4-10 tables that need to be converted to Excel. The conversion process should also include formulas, data cleaning and formatting to ensure the Excel file is ready for analysis. Ideal skills for this task include: - Proficiency in Excel - Attention to detail for data cleaning - Experience with data formatting - Ability to work with PDF files and extract tables from them Each table should be placed in a separate sheet.
I'm seeking a software designer who can create a web-based application for a surplus funds recovery agent. This software should primarily focus on lead generation, with specific emphasis on lead segmentation capabilities. Key Features: - Lead Segmentation: The software should be capable of categorizing leads based on certain criteria, to enhance the efficiency of the recovery process. - Web Interface: The recovery agent should be able to access the software and its data seamlessly through a user-friendly web interface. - Include customizable filters to refine and view specific segments of leads. - Allow the import and export of lead data through CSV or Excel files. - Provide detailed reporting and analytics tools for monitoring performance and outc...
...Taipei City, we hope this system can be less manual as passable, please help to develop software for client to find the road and make his work easier *Project: Extraction and Organization of Map Data from Taipei Historical Map System** **Project Overview:** Seeking a GIS analyst or data processor to extract data from Taipei’s historical map platform. The project involves structuring this data in Excel, identifying specific regions and land distributions, and adding annotations to enhance clarity and accuracy. **Key Project Requirements:** 1. **Data Extraction and Layer Selection**: - Access Taipei’s historical map platform.( 台北歷史圖資) ( please use chinese map) - Select layers such as road sections, area maps (mark road areas in white), cadastral maps, public/private...
I'm seeking an expert to conduct a comprehensive statistical analysis using patient record data, primarily focused on assessing the diagnostic accuracy of various imaging tests. Excel is fine, but open to suggestions. I also need a small write up discussing the results on the analysis. Probability values (p-values), and Bayes' theorem understanding is important We have collected the results of Ultrasound (US), and MRI images of 20 patients and their TMJ (jaw joint). We need to compare results for statistical accuracy. I have done the work, it contains simple categorical and dichotomous data, but I need it checked and confirmed. To clarify, we have data on the scans of 20 patients, both US and MRI scans, for the TMJ, right and left, and looking at Anterior Disc Displaceme...
I'm seeking a skilled Excel expert to create a client database for me tailored for accounting purposes. This database needs to be user-friendly, organized, and equipped with reminders for appointments and deadlines. Key requirements: - The database will store contact details and appointments/deadlines for each client. However, I want to maintain a level of privacy so that not everything is visible until the specific client is clicked on. - The information should be organized in a single Excel sheet with collapsible sections for each client. - The database should include automated features, specifically reminders for appointments and deadlines. Ideal skills and experience: - Proficiency in Excel, especially with creating collapsible sections and automated featur...
This dataset ...whether the candidate joined or not The model output should be presented in a user-friendly dashboard format. The model should prioritize accuracy to ensure the highest likelihood of predicting candidates who will join the company. The model output should include charts and graphs for easy interpretation. Excel The model will use a supervised machine learning approach. The dashboard should highlight the probability of acceptance for each candidate. The dashboard should be built as an Excel spreadsheet. The model should use a random forest algorithm for predicting the likelihood of candidates joining the company. Advanced customization options will be available for all dashboard visuals. The dashboard visuals should include advanced customization options for d...
I am seeking a data entry expert proficient in Excel to handle my inventory data. The tasks will involve data entry, analysis, and visualization, spread across multiple worksheets. Ideal skills and experience: - Proficiency in Excel is a must - Familiarity with inventory data preferred - Experience in data analysis and visualization - Attention to detail for accurate data entry - Ability to manage and work with multiple worksheets About the internship Selected intern's day-to-day responsibilities include: 1. Type efficiently on the computer in English 2. Manage the clerical office tasks 3. Work on emails and replies 4. Surf the internet and search for relevant data as per our niche 5. Analyze and record the data for our database 6. Work on follow-up calls 7. Work on m...
I'm seeking a professional to assist with creating new product listings for my Amazon seller account. I am a newly established in US Import / Export start-up. The products are physical unique and selective imported goods from China, Pakistan, Bangladesh, Turkey, EU, and others. I need someone who can create compelling and optimized listings to attract potential buyers. Understanding that anticipation is to grow from ground 0 up as a long-term trusted member as a contractor. Minimum Item Sale Price estimated at $20 - $50+, later expected items of $500 - $1000+. Next stage is to link a company website that shall be linked to Amazon as a partner. Retail sales initially, later to expand to wholesale. Required Skills / Tasks: - Available to list, communicate w/ customers as ...
I'm in need of a bespoke Excel spreadsheet to help manage finished products across four different locations. The spreadsheet should include: - A front page providing an overview of current stock levels. - Separate tabs feeding data into the front page. - One line per item in stock. - Custom charts for the dashboard. The dashboard should have specific charts tracking: - Inventory levels over time - Stock turnover ratio - Location-wise stock distribution Data will be updated daily, so the system needs to be easy to use and efficient for that frequency. Ideal candidates for this project will have extensive experience with Excel, including creating complex spreadsheets and custom charts. Understanding of stock management systems would be a plus. Please provide samples of...
I'm looking for a Python script that can help me track details about phone numbers including their location, carrier, and owner information. Key requirements: - The code should allow for bulk upload of phone numbers from an Excel file. - It should be able to extract and display information about each number. Ideal skills and experience: -Details of number like registration image -all social media connection details -Tracking movement of number - Proficient in Python programming. - Experience working with data extraction and tracking. - Familiarity with Excel and bulk data processing. The script should provide in-depth owner details.
I need a detail-oriented professional to assist with data entry and financial reconciliations. Your tasks will include: - Inputting a variety of financial transactions (sales, purchase, and expense) into Excel on a daily basis. - Accurately recording invoices and receipts. - Helping with monthly, quarterly, and yearly reconciliations by verifying records against bank statements. Ideal skills and experience for the job: - Proficiency in Excel. - Experience with data entry and financial reconciliation. - Excellent attention to detail and accuracy. The professional should be able to work independently with minimal supervision.
...structure, visualizing, slicer and desktop and mobile support, exportable in CSV PDF format Key Requirements: - Connects to Excel files and SQL database - Generates a separate Pivot table - Creates a complete, interactive Dashboard - Automatically updates all tables after a new order is added - Performs forecast analysis (time, client, items) - Conducts graphic analysis (using Bar, line etc.) - Allows export of reports in CSV, PDF formats - Offers mobile compatibility for dashboard access - A separate sheet must be provided for all formulas/arguments for each column function. The most critical feature of this program is an interactive dashboard. Experience with Excel, SQL, and dashboard creation is essential. Understanding data analysis and visualization techniqu...
As discussed in the chat, I created a script in Python to convert Beast of Cloud CSVs to Mystore ONDC Excel format.
I require an Excel specialist to create a macro that counts cell values based on specific colors. These counts will be used for generating reports. Key Requirements: - Count values from Green and Orange colored cells - Utilize a macro for automation Currently, the colored cells are updated via a drop-down list with three options. The ideal freelancer for this project should have extensive experience with Excel, particularly with creating macros and handling conditional formatting.
...collection for running events. Attendance tracking or seat allocation for workshops and conferences. Scannable through mobile/web-based tools. 2.5 Inventory Management Real-time tracking of event-specific items (e.g., t-shirts, seats, meals). Automated updates during registration. Alerts for low stock thresholds. 2.6 Payment Integration with Billplz Secure online payment processing. Supports local payment methods and tiered pricing (e.g., early bird discounts, VIP tickets). Payment receipts included in notification emails. 2.7 Reporting and Analytics Exportable data for participants, groups, and payments (e.g., CSV, Excel). Visual dashboards for real-time insights: Ticket sales and registrations. Inventory u...
Job Title: Data Researcher Needed to Build UK Builders & Contra...UK location. Gather accurate and up-to-date information including: Name Telephone number Email address Website Requirements: Experience in online research and data collection. Ability to organize data efficiently in a clear and structured format (e.g., spreadsheet). Familiarity with UK regions and construction industry is a plus but not essential. Deliverables: A detailed database in Excel. Additional Notes: The work will involve sourcing data from websites, directories, and other online platforms. Please ensure all data collected complies with data privacy regulations. If you’re interested and have experience in similar projects, please apply with a brief explanation of your approach and r...
...Kindly look at my portfolio. I am professional Structural Engineer with more than 08 years experience. I can design any types of residential and commercial buildings with proper structural analysis, Load calculation report and detailed drawing following by ASCE, ACI, IBC, BNBC codes. I have expertize in different types of professional software like SAFE, ETABS, AUTO CAD, STAAD Pro, SAP 20000, MS EXCEL, MS POWERPOINT etc. I have also expertise at 3D design and 2D draft work of AUTOCAD, SKETCH UP and other relevant softwares. I am able to deliver your project with all the key requirements and your timeframe. I have practical experience in many RCC structures, Steel Structures, Timber structures etc which were delivered to clients with their feedback. My team members are incor...
...Exporting for GTA5: Demonstrate how to export the model as .ydd, .ytd, .ymt, and .yft files using Blender plugins like Sollumz. Importing into GTA5: Show how to integrate the ped into GTA5 using tools like OpenIV and test it in-game. Expectations: Duration: A detailed, high-quality video tutorial (30-60 minutes). Language: Clear narration in English or Urdu. Content: Screen recordings for each step, with necessary annotations or subtitles. Resources: Include a list of tools, download links, and any required plugins for the process. Ideal Skills and Experience: Strong expertise in 3D modeling and GTA5 modding workflows. Proficiency in AI platforms like Meshy AI or MidJourney for model creation. Experience with Blender, including plugins like Sollumz for GTA5 export. Famil...
...TextMeshPro or UI Text components for Gujarati localization. Ensure proper rendering of Gujarati text in menus, dialogues, and other UI elements. UI Adjustments: Ensure that the UI can dynamically adjust for longer Gujarati text and that it doesn't overlap or break the layout. Localization Workflow: Use Unity Localization Package to store translations. Implement a system to easily manage and import/export Gujarati translations (e.g., through CSV or JSON files). Testing: Test the game to ensure that all text is displaying correctly in Gujarati and that there are no font or layout issues. Skills Required: Unity 3D Localization in Unity TextMeshPro UI/UX Design C# Programming...
I'm looking for a skilled professional with extensive experience in VBA and macros to assist with data manipulation on my Excel sheets. Your primary tasks will include sorting and filtering data, as well as combining and merging sheets. Ideal Skills and Experience: - Proficient in Excel, VBA, and macros - Strong data manipulation skills - Experience with sorting, filtering, and merging data in Excel - Ability to automate repetitive tasks to improve efficiency - Proficient in using and creating advanced Excel formulas - Experience in error handling and debugging VBA code - Ability to manage and work with dynamic data ranges - Experience in integrating Excel with external APIs - Proficiency in creating and customizing pivot tables - Strong skills in ...
Looking for someone that is proficient in doing Balance sheet and income statement for banking purposes. Must be able to take some data in excel and formulate a professional document that can be submitted. Must start immediately and complete within 24 hrs.
- A simple widget for fill-in-the-blank question. - The widget includes ...- Clicking "To JSON" generates a JSON object representing the text structure and the blanks (refer to the attached image for an example). - Clicking "From JSON" parses a JSON object and reconstructs the blanks within the text area. In other words, the widget can export and import its content, including the blanks - The widget must be responsive, so when the width is narrow, the blanks will wrap to the next line if needed - Any package used from must be compatible with all supported Flutter platforms (i.e., Desktop, Web, and Mobile). - Deliver within 2 days. Please make sure to use a clean approach and maintain clean code. - Please make sure to see the attached image, which re...
I'm in need of a proficient data entry specialist. The primary task will involve handling Excel spreadsheets. Your responsibilities will encompass: - Inputting, updating and maintaining data with a high level of accuracy. - Ensuring data integrity and confidentiality. - Performing regular backups to secure data. - Generating reports from the data as needed. Ideal candidates should have: - Proven experience in data entry, particularly with Excel. - Excellent attention to detail. - Strong organizational skills. - Ability to work independently and meet deadlines. I look forward to your bids and am eager to find a reliable professional to assist with this task.
I'm looking for a freelancer who can assist with data entry from PDF documents. The data is mixed, meaning it includes both text and numerical data. The task requires straightforward, plain data entry without any need for formatting or structuring. Ideal Candidate: - Attention to detail to ensure accuracy in data entry - Proficient in handling mixed data - Experien...entry without any need for formatting or structuring. Ideal Candidate: - Attention to detail to ensure accuracy in data entry - Proficient in handling mixed data - Experience in data entry from PDF documents is a plus - Able to work independently and meet deadlines The project involves data entry from less than 100 PDF pages. The project should be completed within 2 weeks. Please use Microsoft Excel for the da...
I'm seeking a skilled Excel professional to help update several spreadsheets and create a comprehensive dashboard. The primary focus will be on a roster employee attendance sheet, but other HR-related data may be involved. Key Responsibilities: - Update and improve Excel sheets - Create a user-friendly dashboard - Implement coding where necessary for enhancements Specific Goals for the Attendance Sheet: - Automated calculations: To simplify data processing - Visual charts/graphs: To represent data trends clearly - Conditional formatting for attendance patterns: To easily identify anomalies I'm open to any additional improvements or optimizations that I may not be aware of. Ideal candidates should have a strong background in Excel, experience in HR data an...
I'm seeking a proficient Excel expert to create a comprehensive school fee management system for me. The system should include functionalities for fee calculation and tracking, generating fee receipts, and sending payment reminders. Key functionalities: - Fee Calculation & Tracking: The system should automatically calculate fees and track payments. - Generating Fee Receipts: It should be able to generate receipts for the fees paid. - Payment Reminders: The system should have an alert system for payment reminders. - Discount Management: Include functionality to apply discounts or scholarships to student fees as needed. - Payment History: Track the complete payment history of each student for easy reference. The system will not need to handle multiple currencies or differe...
I have a Google sheet with tabs for every day of the week listing football teams and their respective training locations. I need a formula or function on the first tab that searches through all other tabs to find each team's training times and displays them in a new column next to the team name. The team names in each tab match e...for adjustments in team names and additions in the first sheet column A and update accordingly. - The training times should be displayed for all days of the week. Ideal Skills: - Proficient in Google Sheets - Experienced in creating complex formulas and functions - Familiarity with organizing and analyzing sports data The training times should be displayed in a 24-hour format. I've attached an excel file, but to be 100% clear this is to be do...
I'm looking for an Excel expert. I need to be able to have an inventory table on one sheet with ingredients and prices, and recipe cards on another sheet. The project requires a formula that will allow me to type an item (e.g. flour) and it will pull the price from the inventory table. Key Requirements: - Excel expertise - Ability to create custom formulas - Understanding of inventory management in Excel The ingredients will be listed vertically in the inventory table, and the ingredient names will be exactly the same in both the inventory table and the recipe cards.
I need assistance with an Excel-based project. Requirements: - I have multiple sheets with student data. - I have a set of questions. - I want each student to receive a customized question paper based on specific criteria from their data in the Excel sheets. - I want this customized question paper to be in a Word document. - I also need help emailing each student their own question paper. Ideal Skills: - Proficiency in Excel and Word. - Experience with data analysis and customization. - Familiarity with email automation tools.
I'm looking for someone to help me populate a spreadsheet with greyhound race betting data. The data should be sourced from Greyhound Racing Victoria Website in a specific way. Result CSVs will have to be downloaded for each meeting from June 2023 to current day. Data from these CSVs is then to be copied and pasted into a sheet of the attached Excel workbook in the following fashion; - All data from results csv copied into 'CSV data' Sheet - Then, cells B3:AS14 in 'Comps' sheet copied, and values (not formulas) pasted into 'Data' sheet under the previous race. I have already done this for a number of race meetings so the 'Data' sheets already contains quite a bit of data. There's no need for the data to be updated regularly at thi...
I need a professional Excel spreadsheet designed to track my car expenses for tax purposes, both for business and private use. Key Features: - Mileage tracking: The spreadsheet should be able to record and calculate my daily mileage. - Fuel expenses: It should accommodate my fuel receipts and compute total fuel costs. - Depreciation: The spreadsheet needs to account for the depreciation of my car. Data Input: - Daily mileage: I will input my mileage on a daily basis. - Fuel receipts: The spreadsheet should have a section for my fuel receipts. - Maintenance costs: There should be a space for recording my maintenance costs. Data Display: - Tables: The data needs to be organized in clear and concise tables. - Graphs: I would like to see visual representations of my data in the for...
I'm seeking an experienced mobile app developer to create an Android/iOS app for field data collection. The app should be able to import data from Excel spreadsheets and function like a customizable form with fields for work order numbers, addresses, job details, test results, and image uploads. After data collection, it should export to both Excel and PDF formats. Key requirements include: - Offline data collection capabilities: The app should primarily work offline with connectivity needed only for data uploads and downloads. - Image uploads: The app must allow users to upload pictures as part of the data collection process. - Customizable fields: Users should be able to tailor the form fields according to their specific data collection needs. Ideal candidate...
I'm in need of a professional to create an adva...professional to create an advanced, interactive dashboard using MS Business Intelligence tools. This dashboard should cater to a variety of data sources and metrics. Key Requirements: - Connect the dashboard to SQL Database and Excel Sheets - Visualize and display key metrics including Sales data, Financial information and Customer Relationship Management (CRM) data - Incorporate advanced interactivity features, employing drill-down capabilities and interactive graphs Ideal Skills and Experience: - Extensive experience with MS BI tools - Proficiency in SQL and Excel - Prior experience working with sales metrics and financial data - Ability to create user-friendly, interactive dashboards - Strong understandin...
Excel File: Using the data files assigned to you, find the interesting “story” that is contained in the data and build a dashboard to visually illustrate “your story” to a user who is unfamiliar with the data file. Include these ten elements plus any other Excel skills that help tell “your story.” 1. Data combined from more than one file by Power Query (Get Data/From Folder) 2. Data sorted (largest to smallest or alphabetically, etc.) 3. Pivot table(s) 4. Slicer(s) 5. Time-line slicer(s) (see video on how to convert your years to a date format) 6. Pivot chart(s) 7.&nbs...
...an ag-Grid expert who can create optimal financial templates within ag-Grid tables. Key requirements: - Experience in designing ag-Grid tables primarily for mixed data display - A strong understanding of financial data and the ability to create relevant templates - Proficiency in implementing sorting, filtering, row grouping, and aggregation functionalities - Ability to incorporate export capabilities to Excel or CSV - Proficiency in performance optimization for large datasets - Ability to apply conditional formatting based on financial metrics - Experience with custom cell renderers to enhance data visualization - Experience with integrating ag-Grid tables with various APIs - Ability to create custom themes or integrate with existing design systems - Experience implement...
...experienced Excel VBA professional to create a macro that can assist in handling scientific data from an analytical instrument. When we analyze a sample, we got a list of retention time (in minute) and data are associated with each retention time (name, %ID, value of area). 1 retention time = 1 molecule. From one sample to another one, the retention times can slightly differ but they both correspond to the same molecule (for example sample 1, retention time = 6.432min and for sample 2 = 6.438min). I need a macro to group all retention time that are close one with each other among different samples (we can use a constant value to define the range). For each group, I need to list the associated values for each sample. Raw data are in an Excel file. Key Responsibilities...
...data entry and financial analysis. I need my bank statements from the past three years converted into Excel and used to create basic Profit & Loss statements. The primary purpose of this project is to provide a clear overview of my business's financial situation. Therefore, a detailed analysis of the data is not necessary, but I do need basic categorization of expenses and income. The ideal freelancer for this job should: - Be proficient in Excel - Have experience with financial analysis - Understand basic business accounting - Have a keen attention to detail to ensure accuracy in data entry. - Maintain strict confidentiality of financial information. I prefer the use of a standard Excel template for the Profit & Loss statements, so familiarity wit...
...need someone who can help me with daily data entry for my electronics products. This includes product descriptions, technical specifications, and pricing details. Ideal candidate should: - Have experience with data entry, particularly with electronics - Be able to work on a daily basis - Have good attention to detail to ensure all information is accurate - Have proficient skills in Microsoft Excel or other spreadsheet software - Be capable of quick turnaround times to keep data current - Possess basic knowledge of SEO to ensure product descriptions are optimized - Understand technical jargon related to electronics for accurate descriptions - Experience with data validation techniques to ensure data integrity - Possess strong communication skills for clarifying ambiguities in pr...
...event is completed. I am currently using a Google Sheets / Excel workbook approach that is not connected or aligned - so the same data needs to be entered multiple times and is prone to errors. I would like to create a new workbook that has pivot tables and allows for all data to be entered once, and then have the correct formulas show what payments have been collected, what is still due, how much has been paid out and what is still pending. I also need reports to be able to be run for this and each sales manager to have their own tab to see what they are owed and have been paid already. And another list of tabs for clients to show what rebates have been paid out and what is still pending. I am not locked into using Excel or Google Sheets if there is a free or low ...
