Export datatable excel web vbnet jobs
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 ...
...following details for each product:  Product Name  Price  Barcode (UPC-A format)  Internal Reference Number  Product Image 2. Data Integration: Import all product data from an Excel spreadsheet into the InDesign document. Ensure seamless data merging to populate product details accurately. 3. Barcode Specifications: Barcodes will be in UPC-A format, with the check digit calculated using a barcode generator. Check digit calculation will be handled via either Excel formulas or specialized software. 4. Promotional Pages: Design 5–10 promotional pages separately. These pages will not be populated from the Excel spreadsheet. Incorporate unique, visually appealing designs for these promotional pages. 5. Design Deliverables: The catalog will combine data-driven...
I need an Excel sheet designed to help manage a rotating shift roster. This sheet should support inputting shift data manually and utilizing basic formulas for automation. Key Requirements: - Manually inputting shift data - Designing the sheet with support for rotating shifts - Utilising basic Excel formulas for automation Ideal Skills: - Proficiency in Excel - Experience with shift management systems - Basic understanding of Excel formulas This project is perfect for someone who can create a user-friendly Excel sheet that simplifies managing rotating shifts. The sheet should accommodate day, evening, and night shifts. The sheet should include basic reports for tracking shift distributions and employee hours. The sheet should include specific shift p...
I'm looking for a skilled Excel freelancer who can enhance my existing spreadsheet. This project primarily focuses on improving data entry and validation processes. Key Tasks: - Use existing Data Validation features to create conditions - Implement trigger lists based on selections Ideal Candidate: - Proficient in Excel with strong experience in Data Validation - Able to create, automate and manage dropdown lists - Capable of designing a user-friendly spreadsheet for efficient data entry and validation. Experience with creating complex Excel conditions and a good understanding of data validation is crucial for this project.
I am facing challenges in encrypting my NinjaTrader strategies using Agile.NET. Although I've managed to export the compiled assemblies (.dll) and utilize for encryption, I encounter compatibility issues when trying to load these encrypted strategies back into NinjaTrader. Key Challenges: 1. Configuring Exclusion Rules: I need help setting the correct exclusion rules in to ensure the encrypted code maintains NinjaTrader functionality. 2. Balancing Encryption Levels: I require assistance in determining appropriate encryption levels that safeguard my strategy code while still ensuring compatibility with NinjaTrader. 3. Resolving Errors: I frequently encounter constructor-related errors post-encryption that need troubleshooting. Ideal Candidate Skills: - Extensive experience
I'm looking for an expert in TreeAge Pro and Markov modeling to convert an existing TreeAge model into a interactive independent Excel based economic model. Key Responsibilities: - Convert a TreeAge Pro model utilizing Markov modeling technique into Excel files Ideal Skills and Experience: - Proven expertise in Markov modeling and TreeAge Pro. - Strong background in healthcare analysis. - Experience modeling treatment effectiveness. - Excellent communication skills to explain complex model outputs.
I need professional help to set up multiple VLOOKUP functions in my Microsoft 365 Excel file. I will provide remote access via Teams or Zoom.
...and Heat & Material Balances (H&M) Material Properties and Safe Handling of Hydrocarbons & Chemicals Life Safety Rules Risk Management & Hazard Control Standards for Instrumentation, Electrical, and Mechanical Integrity Equipment-Specific Safety Training Detailed safety procedures for critical facility zones including: Inlet Manifolds & HIPPS Systems Separation Units & Stabilizers Compression & Export Systems Storage & Transfer Systems Flare, Dehydration, and Vapor Recovery Units Chemical Injection, Sweetening, and TEG Systems Reporting & Documentation Develop training for effective use of operational reports: Daily Operations & Maintenance Reports Alarms & Trips Registers Clamps, Preventive Maintenance, and Anomaly Reports Training M...
I'm looking for an Excel expert to create a data analysis workbook for tracking cryptocurrencies. Key Features: - Portfolio performance visualization: I need to be able to see how my portfolio is performing over time, with clear and easy-to-understand visuals. - Transaction tracking: The workbook should have a function for tracking my transactions, allowing for easy monitoring of my buying and selling activities. Ideal Skills and Experience: - Advanced knowledge of Excel, including functions, formulas, and data visualization tools. - Experience in creating workbooks for tracking financial data, particularly cryptocurrencies. - Ability to understand and meet specific data analysis needs. Please provide examples of similar projects you have completed in your proposal.
...in the product title then nothing appears in the recipients columns. I then require a similar thing to happen for “occasion”. Again I have a list of the occasions that could appear. I would like someone to sort my data this way but also teach me the best way how for my future reference. The sorting and categorization should be done using a spreadsheet tool like Excel. I would like the final sorted data to be provided in an Excel file....
I'm looking for a talented designer to revamp 50 pages of Figma. The project will entail updating both the visual style and layout of the design, making it responsive for mobile, tablet, and desktop, and preparing it for export in Vue.js. Key Responsibilities: - Update the design: The chosen freelancer will need to enhance both the visual style (colors, fonts, images) and the layout and structure of the design. - Ensure responsiveness: The design must be compatible across mobile, tablet, and desktop devices. - Prepare for export: The final designs must be export-ready for Vue.js. I have comprehensive design guidelines and branding assets that will aid the project. Ideal Skills and Experience: - Proficiency in Figma - Strong understanding of responsive design ...
...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 analysis has already been completed. Only advanced customization options to be done for dashboard visuals. The dashboard visuals should include advanced customization options for detailed analysis. The dashboard should include high interactivity features such as drill-...
...b. A Greedy approach And one of the following approaches c. A* approach d. A Genetic algorithm e. The Simulated annealing algorithm f. any other solutions You will need to implement the selected algorithms using Java. Your implantation should allow the user to input the number of cities and the distance between each pair of cities, or it should allow the user to input the city distances as an excel of csv file. Your project must have all algorithms in a single Java Project file. You should provide the following: 1. Explain how each selected approach works in details. 2. A simple (step by step) explanation of the 3 selected algorithms 3. Analyze each algorithm complexity. 4. Compare the performance of the 3 implemented approaches in terms of execution time on different number o...
...structured format. Data Processing in Excel: Transfer the extracted data into a prebuilt Excel template with predefined fields. Automate scoring by comparing candidate responses with a list of correct answers. Automation & Tools: Suggest and implement the best tools Ensure scalability and ease of use for non-technical users. Deliverables A secure, fillable PDF forms. (Might need few forms with minor changes in each) A reliable workflow to extract and transfer data to Excel. Automated scoring in Excel based on predefined rules. Clear documentation for the process. Skills Required Experience with PDF form creation (e.g., Adobe Acrobat). Proficiency in automation tools . Excel a...
I'm looking for a spreadsheet that calculates the 10-year gain on a fixed amount investment in stocks. The spreadsheet should also account for an annual withdrawal of 5% of th...design should be user-friendly, allowing easy navigation and comprehension of the calculations. - Include graphical representations such as line charts to visualize the investment growth over the 10-year period. - The spreadsheet should include an initial input sheet for entering the initial investment, expected annual return rate, and withdrawal percentage. Ideal Skills: - Proficient in Excel or Google Sheets. - Strong understanding of investment calculations. - Experience in designing financial spreadsheets. Include a 5% growth rate after historical data drops off as a reference index for t...
I'm looking for a web application that streamlines the mass production of identity cards. The application should include: - Advanced Customization: Users should have full control over layout and design of the identity card templates. This includes the ability to change colors, fonts, and all visual aspects of the card. - Form-based User Interface: The interface for modifying the arrangement of fields on the card should be form-based inputs. It should be intuitive and user-friendly for easy navigation. - Versatile Data Import: The application should support bulk data import from various file formats, with a primary focus on Excel. Other supported formats should include CSV, XML, JSON and PDF. The ideal candidate for this project should have extensive experience in we...
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 approximately 1000 product items in an Excel file that need to be organized and uploaded to WooCommerce on my WordPress site. - The product images are currently embedded within the Excel file, but they are not properly organized. - All product details, including descriptions and prices, are complete, except for the categories which need to be assigned. - I need a professional with experience in WordPress, WooCommerce, and data entry to help me with this task. The ideal freelancer for this job should: - Have a strong background in WooCommerce and WordPress. - Be detail-oriented and able to categorize products correctly. - Have excellent data entry skills. - Be familiar with bulk uploads to WooCommerce.
...application that utilizes the Mindee API. This application can either be web-based or an offline program, depending on your expertise and what you believe would work best. Key Requirements: - The app should be capable of scanning all types of passports. - It needs to extract all pertinent details from the passports. This includes personal information (name, date of birth, etc.), visa details, and travel history. - All extracted information should be compiled and shareable as an Excel file. Ideal Skills and Experience: - Proficient in app development with significant experience in both web and offline programs. - Familiarity with the Mindee API is a plus. - Excellent understanding of data extraction and Excel file formatting. - Prior experience w...
...source of data, have various formats and structures, rendering manual processing a tedious task. The information will be utilized to access Xtream IPTV services covering channels, VOD, and series. Key Requirements: - Experience and proficiency in Python. - Prior exposure to data extraction and handling scripts. - Familiarity with M3u files is a plus. - Ability to deliver the extracted data in Excel format. The ideal freelancer for this project will have a keen eye for detail and a strong problem-solving mindset to navigate the varied structures of the M3u files. Your script will significantly streamline the data extraction process, making it efficient and effective....
I am looking to grow the following two apps that we have developer GoDial Mobile CRM It is a mobile based CRM that allows you to add contacts from phonebook, excel, call logs and auto dial them for sales. It also allows you to send bulk sms, whatsapp, manage tasks, set callbacks, reminders, track payments and all sales related tools. I has business card sharing, auto call popup for incoming call tracking and many more features. DreamStory It is a ai based dream interpretation tool, it allows you to journal your dreams everyday via text or audio, then it automatically uses AI to interpret your dreams, it scores dreams, finds hidden meanings, over time does analysis for recurring pattern and insights. It also allows
I'm seeking a professional with superior skills in statistics, Excel, and data analysis to assist with a task involving survey data. You'll be provided with the necessary documentation to guide your work. Ideal candidates should: - Have extensive experience with survey data analysis - Be proficient in Excel and familiar with its advanced features - Have a solid understanding of statistical methods, particularly descriptive and inferential statistics - Possess strong data interpretation skills - Be comfortable handling and analyzing large and complex datasets Please note that the specific statistical methods to be applied have not been predetermined, and the format of the data has not been specified. Your expertise will be crucial in determining the appropriate tec...
I'm looking for an experienced developer who can create a singer tap for an API integration into a GraphQL based API. The primary goal of this integration is data export. Key Responsibilities: - Developing a singer io tap for API integration - Proficiency in working with GraphQL - Troubleshooting any issues that arise during the integration process - Implement thorough unit testing to ensure the reliability of the integration. - Create comprehensive documentation for the integration process for future reference. - Implement robust error handling to manage data synchronization issues effectively. Ideal Skills and Experience: - Previous experience in creating singer taps - please tell me you experience working with singer tap or meltano
I'm seeking an expert in MS Office 365 for advanced training and guidance across several applications. This includes Word, Excel, Outlook, Teams, and MS Bookings. Key Responsibilities: - Provide comprehensive, advanced-level training and guidance on MS Office 365 applications. - Tailor training sessions to enhance my understanding and proficiency in Word, Excel, Outlook, Teams, and MS Bookings. Ideal Skills and Experience: - Proven expertise and extensive experience with MS Office 365. - Excellent teaching and communication skills, capable of delivering advanced content in an understandable manner. - Strong knowledge of Word, Excel, Outlook, Teams, and MS Bookings. - Patience and ability to tailor training to individual needs.
I have 3 business problems that I need to solve by using statistical analysis on 3 different real-life datasets. My 3 business problems, for which I need the datasets are: a) Problem 1 : Inventory Management Inefficiencies; b) Problem 2: sales data c) Problem 3 : tell you later... The goal is for me to analyse this data with Forecasting or ML techniques later. datasets would need to have the following features: 1) real data (not dummy data) 2) at least 500 data points 3) enough columns for me to run a statistical analysis 4) Industry- Retailer 5) country: indifferent but preferably Australia
I need a database designed primarily for generating quotations. This database should be able to store several types of data, including: - Product details - Client information - Past quotations - Cost - Project timelines - 3 months - Supplier details - Discounts offered The data should be inputted into the database automatically using forms. Ideal skills for this j...Supplier details - Discounts offered The data should be inputted into the database automatically using forms. Ideal skills for this job include: - Database design and development - Understanding of costing and quotation processes - Experience in creating user-friendly input forms Please submit your bid if you have the relevant experience and skills. The database should be developed using MS Excel or accept reco...
We need someone experienced to install Panda AI Pro on my Ubuntu DigitalOcean server following this setup: Please note, I already have an existing droplet on DigitalOcean, so the focus is solely on the installation of Panda AI and connecting Groq and our Ollama API to it
Here's the complete overview of the Keyword Research Tool: Project Purpose: This tool is designed for SEO specialists and content managers, combining web scraping with AI-based keyword generation. It automatically analyzes websites and generates relevant keywords based on actual page content (and in most cases: The URLs have no rankings which we can use from sistrix) Main Features: Web Scraping: Extracts content from websites (meta data, main content, headings) Intelligent content detection and filtering by LLM (Claude/OpenAi), based on content of the webpage, e.g. first 1000 Characters? Caching of Keywords to avoid repeated downloads / queries Keyword Analysis: Uses OpenAI (GPT-4) or Anthropic (Claude) for keyword generation Dynamic prompt generation based on page ...
I'm in need of a software developer who can create a Windows desktop application for me. The software's primary function is to manage data. Key Responsibilities: - Design and develop a robust desktop application that operates smoothly on the Windows platform. - Implement effic...functionalities. - Integrate necessary security measures to protect data. - Set up and integrate with a reliable database system. Ideal Skills and Experience: - Proven experience in desktop application development, specifically for Windows. - Strong expertise in data management software creation. - Excellent problem-solving skills and attention to detail. The application should include data import and export functionalities. The application will manage financial data. The user interface should ...
I'm in need of a new website designed with a minimalist style. The site will serve as a web server with a domain name, capable of using PHP coding to communicate with handheld Point of Sale (POS) systems. This server will be configured using the HTTP protocol, which I'll provide. The primary purpose of this website is to offer a comprehensive overview of transactions from multiple POS systems, facilitating tracking for audit purposes. The key details to be monitored and displayed include: - Total sales - Total sales per unit - Daily transaction summary - Total sales per unit per person (names uploaded by unit) - Total sales per unit per area (names uploaded by unit) - Time of each transaction - Location of each transaction - The amount of each individual transaction - Nu...
I'm seeking a data analyst to summarize my product sales data and draw actionable insights. The primary focus will be identifying sales trends over time. Key Responsibilities: - Ana...primary focus will be identifying sales trends over time. Key Responsibilities: - Analyze product sales data - Identify and summarize sales trends over time - Visualize findings in Excel and PowerPoint - Predict future sales based on historical data Ideal Skills: - Proficiency in Excel for data analysis - Experience in creating visual presentations in PowerPoint - Strong analytical skills to identify trends and draw insights The analysis should cover the period from 2023 to 2024. The final report should include an in-depth analysis of the findings. The final report should be delivered i...
I'm looking for a professional to create a Budget Forecasting, Analy...or other key financial metrics. - Incorporate historical data analysis to improve forecast accuracy. - Multiple visualization options like graphs, charts, and tables to display data effectively. - Reports should be exportable in various formats such as PDF, Excel, and Word. - Drill-down capabilities to enable detailed analysis of individual data points or categories. - Support for scenario planning to evaluate different financial outcomes based on varying assumptions. Ideal Skills: - Proficiency in data visualization tools - Advanced Excel skills - Experience with financial analysis and forecasting - Ability to create user-friendly dashboards Please only respond if you have the necessary skills and ...
I need a proficient Excel expert to create a comprehensive sales invoicing tracker. Key Requirements: - The tracker should manage only sales invoices. - Each sales invoice entry should include: - Client name and contact - Invoice amount and date - Product or service details - New rows should automatically repeat a pre-defined pattern of color shading for easy tracking. Ideal skills for this job include: - Advanced Excel skills - Experience in developing invoicing trackers - Attention to detail - Ability to create user-friendly interfaces The tracker should include alerts for approaching invoice due dates. Also it be able to produce monthly sales summary report. The monthly sales summary report should include advanced filters such as sales by client, sa...
