Principal component analysis excel vbaроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I'm in need of a seasoned business analyst with a focus on property management to help enhance my operations efficiency. Key Responsibilities: - Assessing current operational processes and identifying areas for improvement - Providing data-driven insights to optimize efficiency - Presenting findings in a clear, actionable way Ideal Candidate: - Proven background in business analysis within the property management industry - Strong skills in identifying operational inefficiencies and recommending solutions - Excellent communication skills for presenting complex data in an understandable way.
As discussed basically want it to look like an excel sheet, all the scanner names lined up at the top and have the stocks come down under each. and scanner in this order Multi Scanner, Breakout High, Daily High, Volume Inc. , % to change gainer, Intra Day Rise, Hug 9 EMA, HODspike, 2minSpike2. Have scanners update every 2-3 min.
I'm seeking a data analyst skilled in TTR (Turnaround Time) evaluation, specifically focusing on trends over time. Key Requirements: - Analyze historical TTR data to identify trends over time. - Utilize provided Excel/CSV files for the analysis. - Present findings in a clear and understandable manner. Ideal Skills: - Proficient in data analysis and statistics. - Experience with TTR analysis. - Able to work with Excel/CSV data files.
I need a data analyst to evaluate an Excel spreadsheet containing project data. The analysis should cover run rates, forecast dates, and schedule adherence on a weekly basis. Ideal Skills: - Proficient in Excel - Experienced in data analysis - Able to interpret project metrics No set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I need a data analyst to evaluate an Excel spreadsheet containing project data. The analysis should cover run rates, forecast dates, and schedule adherence on a weekly basis. Ideal Skills: - Proficient in Excel - Experienced in data analysis - Able to interpret project metrics No set rules for this analysis; it is simply a test to assess your ability to perform basic data analysis.
I'm Mandeep Kaur, a 25-year-old seeking help with data entry tasks. You will be primarily tasked with: - Excel data entry - Assisting with filling out application forms Skills & Experience: - Proficient in Excel - Detail-oriented and able to accurately fill out forms - Previous experience with data entry preferred Looking forward to your bids!
...feasibility of a new healthcare clinic project. The primary focus of this analysis will be on the financial performance of the potential clinic. Key responsibilities: - Conduct a thorough financial analysis to determine the viability of the healthcare clinic - Identify potential financial risks and opportunities - Provide detailed recommendations based on your analysis - Evaluate the proposed business plan - Compare 2 different opportunities - Suggest a shreholder agreement for investors Ideal Skills: - Strong background in business analysis, particularly in the healthcare sector - Excellent financial analytical skills - Experience in assessing the feasibility of new projects - Strong report writing skills Your analysis will play a crucial role in ...
CREATE DATA BASE AND PROJECT WITH POWER BI ANALYSIS PROJECT WILL BE 1 DASHBOARD + 1 VBA CODE TO COLLECT DATA + ANALYSIS REPORT
we need a Data architect with following requirements for 2-3 months assignment( 1 position ) Required Skills & Experience Required Profile 7+ years of experience on Database warehouse / lake house programming Experience in implementing at least ...environments. Green Cloud Computing: Knowledge of green computing principles and a track record of optimizing cloud resources for cost and environmental efficiency. Interpersonal & Communication Skills: Ability to work collaboratively with technical and non-technical teams, effectively communicate complex concepts, and influence key stakeholders. Analyze demands and contribute to cost/benefit analysis and estimation Preferred Qualifications Certifications: Azure Solutions Architect Expert or Azure Data Engineer Associate certific...
I'm looking for a web-based script for managing a domain portfolio. The script should enable me to: - Track domain renewal dates - Add and remove domains in bulk - Move domains between different portfolios - Name portfolios (e....files per portfolio, as well as a global export - Backup daily and send via email The script should use a simple Username & Password authentication method. The ideal freelancer for this project should have prior experience in domain management and web script development. Knowledge of domain valuation and renewal processes is a plus. The script should allow for import/export in CSV and Excel formats. I'm open to additional features you may suggest based on your expertise. Please only apply if you are serious and able to delive...
I'm in need of a skilled financial content writer who can produce 10-15 informative and educational blogs per mo...my Twitter platform. Key Responsibilities: - Writing 10-15 small financial blogs each month. - Crafting succinct, engaging content for Twitter, aligned with the themes of the blogs. - Covering a range of topics, primarily market analysis and trends, as well as investment strategies. Audience: - Content should cater to a wide spectrum of readers, from beginner investors to seasoned financial professionals. Ideal Skills: - Proven experience in financial content writing. - Ability to write in an informative and educational tone. - Understanding of market analysis, investment strategies, and current trends. - Social media savvy, with a knack for creating eng...
...vocabulary-building board game for kids (same as Scrabble game - image attached). The logo should reflect the educational and fun nature of the game, appealing to both children and their parents. Requirements: Game Name: The logo must prominently feature Vocabble. Slogan: Include a slogan like below: "Play, Learn, Master English" "Building Brighter Minds!" "Unlock the Power of Words!" "Play, Learn, Excel!" ..... or you can suggest one. Design Style: Clean, modern, and colorful, appealing to families. Avoid overly complex elements. Format: Deliver in vector format (illustrator/corel draw format )and high-resolution PNG/JPEG for print and digital use. Need source file with all the fonts and elements. If you have any questions, pls dm ...
I need assistance performing a statistical analysis to determine if there is a significant difference in the progress of scores over time/age between two groups: early and late. This includes analyzing the following dependent variables: Dependent Continuous/Scale Variables: Individual domain scores (e.g., physical functioning, energy, emotional functioning, etc.) Total scores (mean of domain scores) Mean of each domain score Mean of total scores Analysis Details: Fixed Effects: Age/Time (covariant) Group: Early vs. Late Gender: Female vs. Male Random Effect: Patient ID Software Requirements: IBM SPSS Statistics (Mixed Design Linear Analysis) R Software for additional visualization if needed Deliverables: Full statistical analysis, including significance t...
...profitably of trade with total cost of trade, including gas fees. Possibly implement triangular trade analysis for obscure trading opportunities. Stage 2 (Implementation of trades): Wallet code for trading. Implement buying and selling of identified pairs within/across exchanges and blockchains. Stage 3 (More Complex system) Smart contract, not executing if no profit. Take advantage of gas tokens, flash loans, mempool transaction replacement, and trade batching (wrapping multiple trades across one or more DEXes into a single transaction). Protect from the negative effects of MEV (like front-running or price manipulation). Implement triangular trade analysis for obscure trading opportunities....
I'm in need of a seasoned full stack developer specialized in Laravel and Vue for creating a custom web application with a primary focus on data analytics and reporting. Key Responsibilities: - Develop a robust custom web application - Imple...data sources Ideal Skills: - Proficiency in Laravel and Vue - Extensive experience in REST API development - Strong background in data analytics and reporting - Skilled in working with databases (e.g., MySQL, MongoDB) and APIs (e.g., REST, GraphQL) The project will involve integrating with multiple data sources, including databases and APIs. Experience with external data sources such as CSV and Excel will also be beneficial. Your ability to handle complex data sets and create intuitive user interfaces will be crucial for the success o...
I seek a seasoned P&C insurance underwriter consultant who can enlighten me about the underwriting process, with a strong focus on evaluating risks and internal systems used by the insurers in the underwriting processes. I would also need y...focus on evaluating risks and internal systems used by the insurers in the underwriting processes. I would also need you to support me in providing/creating synthetic data for a commercial P&C quote submission that is usually received from the brokers. Ideal Skills and Experience: - Thorough understanding of P&C insurance underwriting - Strong background in risk evaluation - Proficient in data analysis - Excellent communication skills to explain complex concepts - Experience in consulting Purpose of this request is me building a...
I'm seeking a skilled Power BI and Power Apps professional to transform multiple Excel sheets into an interactive Power Apps platform for various users. The project also includes the creation of a comprehensive dashboard. Key Requirements: - Transforming Excel sheets into a user-friendly Power Apps - Developing a dashboard tracking performance metrics, operational statistics, and assisting with actions and decisions Dashboard Visualizations: - Bar charts and line graphs - Pie charts and donut charts - Tables and matrices - Conditional formatted tables Additional Considerations: - Power App must support multiple clients in an Active Directory format Ideal Skills and Experience: - Proficiency in Power BI and Power Apps - Experience in creating interactive dashboards -...
The project is about analysis the previous data and preparing the report. The deadline is on or before 14th.
...guest preferences/allergies. Billing for F&B services. 5. Cruise & Room Management Booking and reservation system (date, time, cruise routes). Room availability and assignment. Real-time room/cruise occupancy dashboard. Special requests or customizations for guests. 6. Accounts & Finances Invoicing and billing for guests. Expense tracking (fuel, staff salaries, maintenance, etc.). Profit and loss analysis. Tax calculations and reporting. 7. Store Management Inventory tracking (spare parts, toiletries, cleaning supplies). Purchase order generation and vendor management. Low-stock alerts. 8. Purchase Management Procurement planning and tracking. Vendor database and payment schedules. Budget approvals for purchases. 9. Human Resources (HR) Staff database with roles, resp...
I'm looking for a knowledgeable expert on the commission fees, service fees, and other additional costs associat...a knowledgeable expert on the commission fees, service fees, and other additional costs associated with major food delivery platforms in Australia such as Uber Eats, Menulog, and DoorDash. Key Requirements: - Comprehensive understanding of various fees charged by these platforms. - Ability to break down fees per order. - Experience in the food delivery industry is a plus. I need an in-depth analysis on: - Commission fees per order - Service fees - Other additional fees Your insights will help me comprehend the financial implications of using these delivery services. Please provide a detailed bid, explaining your relevant experience and how you plan to source th...
...acceptable as often. Resolution times for incidents – Conformations and notifications - Critical Issues Known as P1’s – Restoration of service 2 to 4hrs - High Priority issues known as P2’s - Resolved time 4 – 8 hours - Medium priority issues known as P3’s - Resolved time 1-2 business days - Low priority issues known as P4’s - Resolved s time 24 hours or as acceptable as often. Root cause Analysis - (RCA’s) to be provided within 5 business days of service restoration. Systems upgrades and maintenance - At least 7 Business days notification for planned outages - Outage hours to be outside of core business hours 8am to 5pm Monday to Friday - distribution groups in CITB. (TBC) Aligned to the response times above. ...
...Performance Metrics: Include lead times, error rates, and cost analysis in the process review. Deliverable: Submit a visual flowchart with financial impact analysis and recommendations for cost-saving initiatives. Timeline Expectation: 2-3 weeks ETC: January 24, 2025 2. Create Inventory Report as Highlighted by Duy Objective: Deliver a detailed analysis of inventory health to improve turnover rates and reduce storage costs. Steps to Complete: Data Collection: Extract real-time data from WMS on shortages, stockouts, and low-velocity SKUs. Financial Analysis: Calculate inventory turnover, carrying costs (including space and obsolescence costs), and aged SKU value losses. Visual Dashboard: Present data through Power BI or Excel dashboards wit...
I'm in need of a Python script that can extract numerical data from an Excel/CSV file. The ideal freelancer for this project should: - Have extensive experience with Python, particularly in data extraction. - Be proficient with handling Excel and CSV files. - Be able to write clean, efficient code. Please note, the data will be purely numerical. The script will need to be able to handle large datasets with ease.
Objetivo del Proyecto Desarrollar una solución automatizada en Python que procese archivos Excel mensuales con múltiples tablas no estructuradas, extrayendo y organizando la información en un formato estructurado y agregando control temporal a los datos. Alcance del Proyecto Desarrollo completo del script en Python usando Jupyter Notebook Documentación del código Manual de usuario para la ejecución del script Requisitos Técnicos Tecnologías Requeridas Python 3.8+ Pandas Openpyxl/XlsxWriter Jupyter Notebook Funcionalidades Principales Procesamiento de Archivos Lectura de archivos Excel (.xlsx) Capacidad de procesar múltiples hojas Manejo de archivos de gran tamaño Control de errores y validaciones ...
I'm looking for someone to find out for me what do Uber eats, Menulog or DoorDash In Australia give to all the restaurants in Australian as is a android hardware brands & models number as do have 5G SIM card & or WiFi. printer Built in Overall, I need comprehensive details on all types of hardware provided to restaurants by these services. This includes: - Detailed information about the Android hardware's SIM card capabilities. I want to know about all SIM card details, specifically focusing on 5G SIM cards - Complete specifications on the printer functionalities of these devices.
I'm an intermediate level CFA candidate seeking a seasoned coach specializing in Financial Reporting and Analysis and Investment Tools. I prefer personalized, one-on-one sessions. Ideal Skills and Experience: - Extensive knowledge and experience in CFA curriculum, particularly in the specified areas - Proven track record of coaching CFA candidates - Excellent communication and teaching skills - Ability to tailor sessions according to my learning pace and style - Familiarity with CFA exam format and question types
Build quote template as below - 1. Polish quote template 2. Macro to create new tab 3. Macro to add new slot in existing quote 4. PDF generation with Inclusion and Exclusion List 5. Push quote info to CRM (if API exists)
...Performance Metrics: Include lead times, error rates, and cost analysis in the process review. Deliverable: Submit a visual flowchart with financial impact analysis and recommendations for cost-saving initiatives. Timeline Expectation: 2-3 weeks ETC: January 24, 2025 2. Create Inventory Report as Highlighted by Duy Objective: Deliver a detailed analysis of inventory health to improve turnover rates and reduce storage costs. Steps to Complete: Data Collection: Extract real-time data from WMS on shortages, stockouts, and low-velocity SKUs. Financial Analysis: Calculate inventory turnover, carrying costs (including space and obsolescence costs), and aged SKU value losses. Visual Dashboard: Present data through Power BI or Excel dashboards wit...
I need to create 1 or 2 shortcut keys with macros in Excel for automating the formatting and reporting of my data. Ideal skills for this job: - Proficiency in Excel - Experience in creating and implementing macros - Ability to automate tasks efficiently
...on a farm, accommodating: 1. A Greenhouse Area: Specifically designed for plant cultivation. 2. A Utility/Storage Facility: An area for tools, equipment, pumps, tanks, and other necessary systems. Main Objectives: - Efficiently integrating these spaces. - Designing the building with a focus on sustainable energy usage. Key Skills & Experience Required: - Proficiency in thermal and HVAC analysis and modeling. - Expertise in energy-efficient design strategies, particularly passive solar design. - Experience with using spray foam for thermal insulation. - Understanding of greenhouse design, particularly with respect to temperature regulation. Your task is to optimize the design to maximize the use of passive solar design principles. The greenhouse area will primarily ne...
I'm in need of a skilled financial content writer who can produce 10-15 informative and educational blogs per mo...my Twitter platform. Key Responsibilities: - Writing 10-15 small financial blogs each month. - Crafting succinct, engaging content for Twitter, aligned with the themes of the blogs. - Covering a range of topics, primarily market analysis and trends, as well as investment strategies. Audience: - Content should cater to a wide spectrum of readers, from beginner investors to seasoned financial professionals. Ideal Skills: - Proven experience in financial content writing. - Ability to write in an informative and educational tone. - Understanding of market analysis, investment strategies, and current trends. - Social media savvy, with a knack for creating eng...
Hi, we need the attached PDF document to be translated from Italian to German, destination: Switzerland. We don't have the OCR for this, but I send you both the Word editable document of the first part, and the Excel that contains the following part (table). Please, use the Word and the Excel documents to create one only final document, like the PDF. I kindly ask you to add [unleserliche Unterschrift] wherever a signature appears. We don't have any specific deadline for that.
I'm in need of a detail-oriented, experienced professional to assist with various bookkeeping tasks. Key Responsibilities: - Recording transactions: Timely and accura...Preparing clear and concise financial statements - Budgeting: Assisting in the preparation of budgets - Auditing: Conducting internal audits to ensure financial accuracy - Forecasting: Providing financial forecasts to aid in strategic planning - Invoicing: Preparing and sending out invoices - Project bookkeeping: Keeping track of finances for specific projects - Must know QuickBooks, NetSuite and Excel Ideal Candidates Should Have: - Extensive experience in bookkeeping - Proficiency in using accounting software - Strong analytical skills - Excellent attention to detail - Ability to meet deadlines - Good commu...
I'm looking for an expert to help me develop a web application that integrates RAG, Ollama, and Neo4j. I need to create a Demo of a RAG application with Neo4j or LangGraph. The idea is to ask open questions to the loaded document and show relationships between data using graphs. Synthetic data can be used but focused on Banking Ideal skills for this job: - Proficiency in web application deve...with Neo4j or LangGraph. The idea is to ask open questions to the loaded document and show relationships between data using graphs. Synthetic data can be used but focused on Banking Ideal skills for this job: - Proficiency in web application development - Experience with data visualization tools and techniques - Knowledge of RAG and Neo4j - Familiarity with Ollama - Strong background in data ...
Email Marketing Project Details Objective: Send two email campaigns to 5,000 current sports bettors with accounts who have not yet made a deposit. Project Overview: Target Audience: 5,000 recipients. Data provided in Excel format (includes recipient email addresses and other necessary details). Email Content: Email 1: Includes a dynamic, clickable banner and text for sports bettors. (both provided by me. Naturally I want your input). Email 2: Sent three days after the first email, includes new text aimed at casino and slots players (provided by me). Sending Details: Emails should be sent from a professional-looking sender name such as: "Mike Spencer – Your V.I.P. Host". The sender email address must be configured to forward any replies directly to my email. Testing ...
I need an experienced professional who can prepare daily, weekly and monthly reports based on exclusive MIS data. The reports should encapsulate performance metrics, with a particular focus on employee productivity. The candidat...Managing all MIS activities of the process. - Ensuring timely resolution of queries from different departments. - Coordinating with process managers for data collation and reporting. - Preparing PowerPoint Presentations according to requirements. - Building and maintaining defined reports. The ideal freelancer should be able to work independently with minimal direction. Strong skills in data analysis, reporting, and presentation preparation are essential. Experience in managing MIS activities and resolving inter-departmental queries will be a significant ...
Cryptocurrency Trading Platform Developer with Expertise in DEX Integration To develop a secure, scalable, and user-friendly decentralized exchange (DEX) and Tradingview platform that allows users to trade cryptocurrencies directly from their wallets without relying on intermediaries. The platform will prioritize decentralization, transp...low-fee blockchains. 9. Anonymous and Permissionless - No Know Your Customer (KYC) or Anti-Money Laundering (AML) processes, enabling true anonymity. - Permissionless asset listings; anyone can add trading pairs as long as liquidity is provided. 10. Analytics and Tools - Real-time analytics on trading volume, token prices, and liquidity data. - Integrated charting tools for technical analysis. - Price alerts and notifications ...
I'm seeking assistance implementing a scientific paper titled "Behavioral Based Insider Threat Detection Using Deep Learning". The replication should encompass all components of the original study, including: - Methodology and implementation - Results and findings - Literature review and background - Source code The literature review must incorporate previous research papers. This replic...for academic research purposes. Therefore, it is crucial that the replication is rigorous, comprehensive and aligns closely with the original study. Ideal Skills and Experience: - Proficiency in deep learning methodologies - Experience with scientific research replication - Strong literature review skills - Ability to implement complex methodologies - Familiarity with source code gener...
I need an existing Excel spreadsheet, which tracks employee data, to be transformed into a secure, user-friendly system. Key Requirements: - The system should provide view-only access to certain users, while others can edit designated sections. - It should automate calculations and formulas, as well as validate data entries to ensure accuracy. Ideal Skills: - Proficient in Excel with experience in spreadsheet security and access control. - Capable of creating automated systems within Excel. - Previous experience with HR-related spreadsheets is a plus.
1. Introduction Stefan & Stefan is seeking proposals from experienced developers or development firms to create "Bookit," a comprehensive tennis booking and challenge platform for tennis en...to create and accept tennis challenges with optional wagers. 3. Empower Clubs: Provide clubs with an interface to manage bookings, schedules, and facilities. 4. Monetize User Engagement: Offer users the opportunity to earn through accepted challenges with wagers. 5. Enhance Administration: Equip the platform owner with robust administrative tools, including reporting and user management. Key Component • Responsive Website for Players, Clubs, and Administrators: A unified platform accessible on desktops, tablets, and mobile browsers that offers all the functionality for users,...
...un portal de empleo leader pero queremos procesar los datos de esos candidatos desde diferentes pragramas de mailing para lo cual necesitamos extraer algunos campos básicos de esa web a la que nos tenemos que logear, ir a la oferta en concreta, al listado de candidatos y de ahi extraer esos datos básicos del candidato (por ejemplo nombre, email, teléfono, experiencia, etc) y pasarlos todos a un excel. Actualmente lo estoy intentando hacer yo a través primero de Selenium y ahora con ParseHub, pero no soy experto en esas herramientas y me da siempre problemas ademas que el portal de empleo tiene sus controles para evitar este tipo de acciones e imagino que hay que tener los trucos o el conocimiento determinados para solventas estas cuestiones como los ca...
In my company the arrival of the inventory to the warehouse is recorded manually in the attached excel file, in the tab "ARRIVO PRODOTTI". Each product is assigned a specific row. For each row the following columns are filled in: ARTICOLO (item code) DESCRIZIONE (item description) DATA PREVISTA (estimated availability date) I° REVISIONE DATA (first revised availability date) II° REVISIONE DATA (second revised availability date) III° REVISIONE DATA (third revised availability date) QTY (quantity) STATO (status) I would need a button for each row, next to the column STATO. The button, powered by a macro, when pushed should trigger an email to be sent to a list of internal recipients, with subject and text filled in with the values of the specific columns,...
...electricity and water bill data (PDF format) into a specific Excel structure. We will provide sample bills AND a detailed mockup of the desired final output format. This ensures your solution directly addresses our exact needs. Data Points (extracted from PDFs): Company Name Flat/Shop Number Account Number Disconnection Notices (flag/status) Electricity, Water Consumption Municipality Period Start Date, End Date Previous Balance, Total Amount Due Key Requirements & Deliverables: Automated Extraction & Formatting: Develop a Power Query workflow to: Pull data points reliably from PDFs according to the provided format guide . Structure the extracted data into Excel sheets exactly matching o...
