Data net web application excel macrocông việc
I'm looking for a professional who can streamline and automate the process of writing technical reports for me. These reports will be generated from various data sources, including databases and Excel spreadsheets. Ideal Skills: - Proficiency in Microsoft Word and its automation tools - Strong understanding of technical report writing - Experience with data manipulation from databases and Excel - Ability to create scripts or macros for automation The input data files will be in docx format. I need someone who can help me save time and effort so that I can focus on more strategic tasks.
I'm looking for a professional data scraper to extract emails, addresses, and phone numbers from company websites and business directories for 650 companies based in the Chicago area. The final output should be neatly organized in an Excel spreadsheet. Ideal Skills: - Proficiency in data scraping - Experience with Excel - Attention to detail Please include in your bid any relevant experience you have. Thank you!
I have prepared some sales data in an Excel file. I require a freelancer to construct 5 charts for an editable dashboard. This will consist of 3 pie charts and 2 bar charts, all in neutral tones. Ideal Skills: - Proficient in Excel - Experienced in data visualization - Able to create clean, professional charts Please, only bid if you're able to deliver high quality work.
I'm looking for a freelancer to help me refine a project management spreadsheet for tracking an upcoming event. The spreadsheet is already drafted but needs to be polished and improved in several areas. ...spreadsheet for tracking an upcoming event. The spreadsheet is already drafted but needs to be polished and improved in several areas. Key Tasks: - Enhancing the formatting and layout to make it more user-friendly and visually appealing. - Reviewing and improving the formulas and calculations to ensure accuracy and functionality. - Organizing the data in a more logical and efficient manner. Ideal Skills and Experience: - Proficiency in spreadsheet software (Excel, Google Sheets, etc.) - Strong attention to detail - Prior experience in creating or enhancing project ma...
...de las tarifas obtenidas desde la API. 4. Selección de la opción de envío por parte del cliente y almacenamiento en la orden de compra. 5. Desarrollo optimizado y compatible con NopCommerce 4.2 o superior. 6. Código limpio y bien documentado para futuras modificaciones. Requisitos del Desarrollador: - Experiencia en NopCommerce y desarrollo de plugins personalizados. - Conocimiento en **.NET Core, C# y consumo de APIs REST**. - Experiencia previa con integraciones de pasarelas de envío (deseable, pero no excluyente)....
Tenemos la necesidad de un proyecto en vb net, que a partir de un xslt convierta un XML en el formato necesario para facturae, y lo suba al portal de pruebas de facturae, validándose y dándose por bueno en el portal de facturae. La función tendrá que leer el XML, transformarlo a través del xslt y enviarlo a través del portal, gestionando todas las peticiones a través de vb net.
I am seeking a detail-oriented freelancer for manual data entry tasks from various digital files. The data primarily consists of customer feedback and reviews sourced from Excel spreadsheets, PDF documents, and Word documents. Key Responsibilities: - Accurately entering text data from various digital files - Cleaning the data by removing duplicates and errors Ideal Skills and Experience: - Proficiency in Excel, Word, and handling PDF documents - Exceptional attention to detail to ensure accuracy - Experience with data cleaning and preprocessing
Project Description: We are seeking an experienced Excel professional to review, fix, and enhance a comprehensive recruitment tracker. The file is currently structured to support recruitment metrics tracking but has several functional and formula-related issues that need resolution. Additionally, the tracker must be optimized to integrate with mail merge functionalities for providing weekly status updates and progress tracking to the direct manager and hiring managers. Scope of Work: 1. Dashboard Fixes: • Correct the formula for Total Open Vacancies to accurately count open vacancies using =COUNTIF(VacanciesTable[Vacancy Status], "Open"). • Fix the Fill Rate formula to use structured references like =COUNTIF(VacanciesTable[Vacancy Status], "Closed"...
I need an Excel spreadsheet to effectively monitor and record employee attendance. Key Features: - Data Entry: The spreadsheet must accommodate employee name, ID, department, and dates of attendance/absence. - Automated Status: It should have drop-down menus for selecting "Present," "Absent," or "On Leave." - Summary Section: Formulas should calculate each employee's total working days, days present, absent, and on leave. - Conditional Formatting: It must highlight absences that exceed five in a month. - Search Functionality: Include filters to search by date range. - Error Validation: Use data validation rules to prevent duplicate entries. The ideal freelancer for this project should be proficient in Excel and have prior ex...
I will organize all annexes from multiple Annual Health Reports (approximately 195 annexes across 10 years) into a single, well-structured Excel file. Each annex will have its own dedicated tab, and the data will be compiled historically, ensuring accuracy and consistency across years. Delivery will be made everyday around Palestine time 4pm
Excel Expert Needed for Data Analysis Tables
...club. The project includes: Teardrop Flag/Banner Design: Eye-catching design suitable for outdoor use. Incorporate our logo, color code, and font. Modern, vibrant, and textured geometric patterns. Pickleball Paddle Design: Aesthetic and sporty design for pickleball paddles. Must align with our branding, utilizing our colors, logo, and font. Include vibrant textures and geometric shapes. Mesh Net Cover for Sea Container: Create a visual design to be printed on a mesh fabric to conceal a sea container. Should be bold, modern, and incorporate brand elements. Consider patterns that blend seamlessly into an outdoor sports setting. Gazebo Roof Design: Design for the roof of a portable gazebo. Must feature the logo prominently and maintain a modern, geometric, and vibrant aesthetic...
...Reporting: Custom dashboards for each role to view relevant tickets. Graphs and statistics on ticket status, resolution times, and team performance. Downloadable reports (PDF/Excel) for ticket analytics. User-Friendly Interface: Simple, intuitive design with Bootstrap UI components. Fully responsive for mobile, tablet, and desktop devices. Search and filter options for efficient ticket management. Integration Requirements: Seamless integration with our existing HRMS software. Ability to import/export data from/to other systems if required. Technical Requirements: Frontend: HTML5, CSS3, Bootstrap 5, jQuery, AJAX Backend: ASP.NET Web Forms (v4.8) Database: SQL Server Authentication: Form-based authentication with role-based access control. Deployment: On-premise wi...
I'm seeking assistance to clean up my Excel data and generate a visually appealing report on our IT Budget. Data Cleaning: - I have some formatting issues that need to be fixed. - Incorrect date formats - Inconsistent text case - Mismatched column structures Ideal Freelancer Skills: - Proficient in Excel data cleaning and analysis - Ability to create engaging visual reports Please note, the type of visual report hasn't been specified yet. I would appreciate your expertise in determining the most effective way to present the data.
I am seeking a detail-oriented freelancer for manual data entry tasks from various digital files. The data primarily consists of customer feedback and reviews sourced from Excel spreadsheets, PDF documents, and Word documents. Key Responsibilities: - Accurately entering text data from various digital files - Cleaning the data by removing duplicates and errors Ideal Skills and Experience: - Proficiency in Excel, Word, and handling PDF documents - Exceptional attention to detail to ensure accuracy - Experience with data cleaning and preprocessing
I'm looking for an experienced Excel VBA freelancer to help me Filter a data set with anther list of data . the filtering is "contain filtering" . sample data attached , sheet 1 Column A through K is the data that i need to be filtered . Column L is the data that used to filter . sheet 2 is an example of reporting , the excel attached is just sample of all of data
...for an expert in advanced Excel functionalities to help transform complex datasets into visual insights to forecast outcomes. Key Responsibilities: - Utilize Excel's data visualization tools to create compelling graphical presentations of data. - Help in interpreting visual data representations to predict future trends. Ideal Skills and Experience: - Proficiency in advanced Excel functionalities, particularly with data analysis and visualization. - Experience in creating and interpreting pivot tables, charts, and graphs. - Strong understanding of forecasting techniques. - Ability to deliver insights in an understandable manner. Please note that while I have experience with data cleaning and statistical analysis, my primary nee...
I'm seeking a skilled accountant with experience in the restaurant industry for bookkeeping and tax filing. The income data is tracked via a kiosk ordering system and recorded in Excel. Key Responsibilities: - Manage and maintain our Xero bookkeeping software - Prepare and deliver our financial statements (Balance Sheet, Income Statement, Cash Flow Statement) on a quarterly basis - Handle tax filing Ideal Skills and Experience: - Extensive experience with Xero - Previous bookkeeping experience in the restaurant industry - Proficient in preparing financial statements and tax filing - Ability to work with Excel and data from a kiosk ordering system - Attention to detail and strong organizational skills. let me know your pricing per quarterly.
Hi, I have my qualitative data, and there is a problem with documenting the analysis. I have the result from the analysis done manually; I want it to be documented on an Excel sheet and an NVIVo sheet. Thank you
We are working on a project that collects data through surveys aimed at understanding trends, traveler preferences, and satisfaction levels within the tourism sector. Currently, the process involves manual work using Excel, which is time-consuming and inefficient. To address this, we aim to develop a system that automates data preparation, classification, and visualization (using POWER QUERY), thereby enhancing accuracy and decision-making capabilities. The overarching goals of the project are: of Dashboards in Power BI Building interactive dashboard(s) to present various analyses, key questions, and insights, supported by constructed indicators, DAX formulas, and other advanced features. Statistical Indicators Generating descriptive statistical measures (e.g.,
I'm in need of a budget-friendly freelancer to help me scrape text data from a website. There will be various tasks, but consistency with incoming work is expected. Key Requirements: - Text Data: The primary focus will be on extracting text from the website. - Excel Format: The scraped data should be organized and delivered in an Excel file. - Weekly Requirement: Tasks will be assigned on a weekly or biweekly basis. Ideal Skills: - Data Scraping: Proficiency with web scraping tools and techniques is essential. - Excel: Strong skills in data organization and manipulation within Excel. - Budget Friendly: Ability to complete tasks at a cost of less than $18 per task depending on management. I'm looking for som...
I'm seeking a productivity expert to help me with effective time management and goal-setting strategies. Your primary role will be to assist in enhancing my personal productivity and helping me prioritize tasks effectively. Ideal skills include: - Expertise in time management techniques - Proven track record in goal-setting strategies - Exceptional task prioritization abilities Experience in working with individuals or teams in a similar capacity is a plus. Your contribution will be key to boosting my overall productivity and achieving success.
I'm seeking a highly skilled Excel professional to create a detailed analytical Profit and Loss (P&L) calculator for my retail business. This calculator should encompass all pertinent business costs to aid in identifying optimal products for boosting profits. Key Requirements: - Comprehensive inclusion of business costs: The calculator should account for inventory costs, employee salaries, rent, commissions & bonuses, and operational costs. - Future Target Metrics: It should enable tracking of key future targets such as revenue growth and profit margins. Ideal Candidates: - Proficient in Excel with demonstrated experience in creating detailed and professional business calculators. - Previous experience in the retail industry will be highly regarded. - Able to p...
I'm seeking a skilled VB.Net programmer for creating a desktop application. The application is primarily focused on software development. Key Requirements: - Expertise in VB.Net programming - Experience in desktop application development - Ability to understand and implement specific software features Skills and Experience: - Proficient in VB.Net - Prior experience in developing desktop applications - Strong software development background
I need a professional VB.NET programmer to develop a desktop application for astrology purposes. This application should have the ability to generate horoscopes, create astrological charts, and perform compatibility analysis. Key Features: - Horoscope Generation: The application should be able to compute and generate horoscopes based on user data. - Astrological Chart Creation: Users should be able to input data and the application will create astrological charts. - Compatibility Analysis: The application should be able to assess and analyze compatibility between users based on astrological principles. Ideal Skills: - Proficient in VB.NET - Experience in desktop application development - Understanding of astrology (not mandatory but...
...desktop-based Facility Management Application. The application needs to improve operational efficiency within a facility. Key Features: - Work Order Management: The application must provide a comprehensive system for managing work orders, tracking their progress and completion. - Asset Tracking: The application should include a robust asset tracking feature to monitor the status and location of all assets. - Scheduling and Calendar Management: The application needs to incorporate scheduling and calendar management functionalities for better planning and coordination. - Photo Integration: The application should have the capability to integrate and display photos as part of work orders or asset tracking. Ideal Skills and Experience: - Proven exp...
...terraform apply* I'm looking for an Oracle Cloud (OCI) and Terraform specialist with prior experience in building simple applications. This project involves working with a GitHub repository that contains all the necessary code. All code is provided in the Github repo with link below. Your task will be to deploy this application on OCI and *PROVIDE DETAILED STEPS SO I CAN EASILY EXECUTE "terraform apply" AND GET THE APPLICATION SETUP IN MY OCI ACCOUNT*. The primary aim of this application is to serve as an educational demo. *Test "terraform destroy" to be sure nothing is left running that will result to charges in future. Ideal skills and experience for the freelancer include: - Proven expertise with Oracle Cloud Infrastructure (OCI) - P...
...be done; 1. For the keywords “courage in education”, “education” AND “courage”, “school” AND “courage”, “teacher” AND “courage” the studies conducted between 2014-2024 in the databases will be listed in excel. This list will include abstracts (the database already provides this service). All of them, including the overlapping ones, will be saved in excel. 2. Search words for Dergipark will be in Turkish. 5. It is important to include abstracts as we will do the review through abstracts. 6. Finally, all of them will be merged together in a single excel file. 7. I will get from you excel files for each keyword and database separately and all of them put together (Master list...
I'm in need of an expert spreadsheet designer who can create customized financial tracking spreadsheets for my clients. Key Responsibilities: - Design and develop financial spreadsheets, using either excel or numbers - Customize the spreadsheets to facilitate lifetime tax analysis for what happens over time to a qualified plan showing Required Minimum Distributions, taxes, reinvested RMDs and taxes to heirs. Like to be able to put information on sheet 1 as an input page including clients name(s), single or married, year, age(s), life expectancy, type of qualified plan (IRA, 401k, 403b, 401A) dollar amount of investment, rate of return, tax rate. Roth conversion amounts, number of years, tax credit info, etc. Then on second sheet columns for each section with the rows automati...
...developer to create a remote desktop application compatible with both Windows and MacOS. This application will enable full control assistance to remote users, necessitating comprehensive experience in the development of interactive, user-friendly software. Key Requirements: - Develop a remote desktop application compatible with Windows and MacOS. - Ensure the application allows full control access, not just view-only mode. - Implement OTP/Password-based Authentication as the sole method for initiating remote sessions. - Application can be developed on any technology. This application needs to seamlessly integrate with my existing ASP.NET MVC application, which will initiate the remote requests. Thus, experience with ASP.NET MVC and remo...
1. Admin Panel: Login: - Admin login functionality with username and password for secure access. Dashboard: - Manage Students: - Add new students with their details (name, email, etc.). - View student records. - Update student scores (Listening, Grammar & Written Expression, and Reading). - View calculated total score and CEFR level. - Update Scores: - Input Listening, Grammar & Written Expression, and Reading scores for each student. - Generate and Download Results: - After updating the scores, admins can generate a PDF report for each student showing their detailed scores and CEFR level. 2. Scoring Formula The total score will be calculated using the following formula: Total Score = (Listening Score + Grammar Score + Reading Score) ÷ 3 × 10 3. CEFR...
Taking my content contained in a word document, I need an Excel sheet designed as a meeting agenda tool for team meetings. It should be visually appealing and easy to use. The design must incorporate appealing colors and themes as well as varied font styles and formatting to enhance readability and engagement. Ideal skills for this project include: - Proficiency in Excel - Strong understanding of visual design - Experience in creating interactive and user-friendly Excel tools Please note that while the tool should be visually engaging, its primary purpose is to facilitate clear and structured meeting agendas.
I'm in need of an experienced macro coder to help automate tasks in Microsoft Excel. The project's primary focus is on: - Task Automation: Streamlining repetitive processes to save time and enhance efficiency. Ideal candidates should have a strong background in Excel, with proven experience in macro development. Understanding of complex Excel functions and ability to troubleshoot issues are key.
I'm looking for a dedicated professional to apply for jobs on my behalf in the United States. The roles include: Data Scientist, Data Analyst, Software Engineer, and Data Engineer. Key details: - Job platforms: , , , , - Application materials: I will provide my resume for each of the 4 roles - Resume customization: No customization needed Ideal candidates for this project should have: - Excellent understanding of the tech job market - Proficiency in using the specified job platforms Your efforts will be well-compensated.
I need a skilled data scraper to extract information from roughly 250 active real estate listings on a WordPress site. The data fields to be collected include: - Price - Photos and Floorplans - Property Title and Description - Land/Property Size - Bedrooms/Bathrooms - Address The final output should be delivered to me as a neatly organized Excel/CSV file and all images and floorplans saved in folders referencing the Property ID. Ideal candidates for this project should have: - Proven experience in web scraping, specifically from WordPress sites - Proficiency in data organization and Excel - Familiarity with real estate data is a plus This is a one-time project, so I don't require ongoing data scraping. If you have the necess...
I need an experienced Excel VBA professional Key Requirements: - Proficiency in Excel VBA - Experience in diagnosing and fixing VBA code
...business descriptions and photos for each listing. Key Features: 1. Add custom fields to the directory for celebrity business details: Celebrity Name, Business Name, Industry (Fashion, Food, Tech, etc.), Founded Year, Website Link, Investment Details (optional), Ratings & Reviews, Custom Post Type for Blogs & News, Multi-language support (if needed) 2. Advanced Search & Filtering (by Industry, Net Worth, Celebrity Name), Auto-suggestions for search queries, Optimize performance using AJAX-based filtering, Option for featured/sponsored listings 3. Users can vote for their favorite celebrity businesses, Show weekly/monthly/yearly ranking trends, Display graph-based voting trends, Spam prevention: Limit votes per IP/session Planning to use this theme -
I'm looking for a professional with a strong background in finance and investments to create an extensive financial model for analyzing sat...model will be investment analysis. Key Tasks: - Develop a comprehensive financial model capable of evaluating potential satellite investments. - The model should assess various key metrics such as Return on Investment (ROI), Payback Period, Net Present Value (NPV), Internal Rate of Return (IRR), Risks, Weighted Average Cost of Capital (WACC), Risk premiums and more. Ideal Skills: - Strong expertise in financial modeling, particularly for investment analysis. - Experience with satellite investments is a plus. - Proficiency in using advanced features in Excel or similar tools. Please submit your proposal if you have the relevant ...
We're in the midst of creating a new web application and are seeking a skilled Outsystems developer to join our team. Ideal Skills and Experience: - Proficient in Outsystems platform - Strong web application development background - Team player with good communication skills - Problem-solving mindset
I'm looking for an Excel expert who can create a Google Sheet for tracking my cryptocurrency portfolio. The sheet should monitor Bitcoin (BTC) and Solana in real-time, displaying market prices, portfolio movements, and gain/loss metrics. It should also feature Line charts, Bar charts, and Pie charts to visualize the data. Key Requirements: - Proficiency in Excel and Google Sheets - Experience in creating real-time data tracking tools - Ability to create and integrate various types of charts Ideal Skills: - Strong understanding of cryptocurrency and market tracking - Excellent data visualization skills - Attention to detail to ensure accurate tracking of gains and losses
I'm in need of a dedicated and efficient data entry freelancer. The task involves entering text data sourced from digital documents into an Excel file. The ability to meet deadlines and deliver work quickly is key. Tasks will include: - Data extraction from digital documents. - Data entry into an Excel file. - General consistency checks on the data to ensure its validity. Ideal skills for this job include: - Proficiency in Excel. - Excellent attention to detail. - Strong time management skills. - Previous experience in data entry from digital documents.
I'm seeking a proficient Full Stack Developer w...and C#. The primary objective of the project is to develop a new web application, with the backend being built on the .NET Framework. Key requirements: - The candidate should be well-versed in web development, with a strong understanding of how HTML, CSS, and JavaScript integrate with backend systems. - Experience in database design and development is essential, specifically with SQL Server as this will be the primary database for the project. - Familiarity with secure coding practices and performance monitoring tools is highly desirable to ensure the application is robust and efficient. This project is perfect for a candidate who is not only skilled but also passionate about delivering high-qualit...
I'm in need of a proficient data entry operator who has extensive experience working with Excel. The job will involve handling mixed data (both numerical and text). Key Responsibilities: - Manually entering text data from various sources into Excel. - Handling numerical data, primarily sales figures. - Processing and entering mixed data (numerical and text) into Excel. Ideal Skills: - Proficiency in Excel, with a deep understanding of its functions and capabilities. - Attention to detail to prevent errors during manual data entry. - Experience handling sales figures is a plus.
I'm in need of an experienced automation expert to help with processing data from PDF and Excel files. The project involves: - Data Extraction: Taking data from text-based PDF files and Excel files. - Data Transformation: Cleaning the data and adding it into an SQL Database automatically. Ideal candidates for this project should have a strong background in database management and automation, with specific experience working with SQL Databases. They should also have skills in data cleaning and transformation, ensuring that the data is ready for use within the database. If you're able to streamline this process and make it more efficient, that would be a big plus. Please provide examples of similar projects you'...
...experienced Excel expert to develop an equipment finance calculator for me. The calculator must allow for adjustments to be made on the following parameters: - Interest rate - Brokerage fee - Loan duration - Balloon payments - Principal amount: Input field to specify the initial loan amount. - Payment frequency: Option to select how often payments are made (e.g., monthly, quarterly). - Down payment: Input field to specify any upfront payment made at the time of purchase. I will need to be able to adjust interest rate and also brokerage. The calculator will be used on a Windows operating system. Therefore, it should be designed accordingly. Ideal candidates for this project should have a strong background in finance and excel, with experience in creating finance-related t...
I am in need of an Excel expert to update a pre-existing calculator that estimates the cost of fly/insect screens. This project involves fixing some errors, enhancing the user interface, and adding support for a second manufacturer. Key Tasks: - Identify and fix calculation errors and macro-related issues. - Update dropdown lists to include a second uPVC extrusion manufacturer. - Modify the document to allow for additional selectable options from multiple price list documents. - Implement user prompts in the interface for improved usability. - Enhance the overall user interface to be more intuitive. Ideal Skills: - Proficient in Excel, with advanced skills in using and creating Macros. - Experience in improving Excel user interfaces. - Ability to troubleshoot ...
I'm seeking a skilled app developer to create a car wash application for both iOS and Android platforms. This app should primarily focus on a robust customer review system. Key Features: - Cross-Platform Compatibility: The app should function seamlessly on both iOS and Android devices. - Subscription-Based Booking System: The app should have a booking system that operates on a subscription basis. This will require the developer to design a user-friendly interface that makes it easy for users to subscribe and book services. - Comprehensive Customer Reviews Section: The most critical aspect of this application is an effective customer review system. This feature needs to be intuitive and engaging, encouraging users to share their experiences and feedback. Ideal Skills: ...
I'm in need of a comprehensive spreadsheet to track the status of various projects. This will involve: - Tracking Project name and status - Keeping tabs on Assigned team members - Noting Contract Amounts - Noting Start & End Dates - Noting Purcha...on Assigned team members - Noting Contract Amounts - Noting Start & End Dates - Noting Purchase Orders - Calculating Totals of Base Contract + Change Orders - Recording Change Orders Throughout The Project - Monitoring Billing Progress - Once Project is finished I need the date removed from one sheet and transferred to another sheet. Ideal candidates for this project should be proficient in Excel or Google Sheets, with a strong understanding of project management tracking. Experience in building similar tracking spread...
I'm seeking a skilled lead generation expert to extract emails and WhatsApp numbers from exhibitor lists at the Dubai World Trade Center. Sponsors Exhibitors EMAILS Key Deliverables: - An Excel spreadsheet containing: - Company names - Contact persons (preferably Managers) - Company addresses - Email and WhatsApp numbers of owners - Locations - Sector Ideal Skills and Experience: - Proficiency in Excel - Experience in lead generation - Strong attention to detail for manual verification tasks. To secure this project, you must extract at least 100 emails from a single website mentioned in the examples. I am looking for leads from all regions within the Dubai World Trade Center.
