Excel stock projectsроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I'm seeking a proficient Excel expert to design a spreadsheet for tracking and calculating salesman commissions. Key Features: - Data Tracking: The spreadsheet must track sales amounts and the dates of each sale. - Commission Calculation: The commission should be calculated as a flat rate per sale. - User-Friendly Design: The spreadsheet should be easy to navigate and use, with clear labels and instructions. Ideal Skills: - Advanced Excel Skills: Including but not limited to, knowledge of formulas, functions, and data organization techniques. - Experience with Commission Calculations: Familiarity with creating spreadsheets for tracking sales commissions is a plus. - Attention to Detail: The ability to create an accurate and reliable tracking tool.
I'm seeking an Excel expert to automate a variety of tasks. These include: - Data Entry: Streamlining the process of inputting information into Excel. - Data Analysis: Implementing functions or scripts to process and analyze the data automatically. - Reporting: Generating regular reports based on the analyzed data. The automation will need to interact with Google Sheets. It will have to both read from and write to the Sheets. The ideal freelancer for this project would be someone with a deep understanding of Excel, experience with Google Sheets, and a knack for data automation. Python or similar programming skills would be a plus.
I am looking for a freelancer to develop a well-structured, automated, and professionally designed Excel sheet for Portfolio, Program, and Project Management, aligned with PMI standards and requirements. 1. Excel Sheet Development The Excel file should be designed for comprehensive project tracking and management, incorporating the following: A. Portfolio, Program, and Project Structure • A structured Portfolio Management sheet to oversee multiple programs and projects. • A Program Management sheet to consolidate and track multiple related projects. • A Project Management sheet for individual project tracking, execution, and control. B. Core Project Management Features (Aligned with PMI Standards) • Project Overview Dashboard: ...
I need assistance with manual data input into an Excel spreadsheet and potentially creating a format or template for the data. Key Tasks: - Manual data entry into Excel - Potential assistance with creating a suitable format/template for the data Ideal Skills: - Proficient in Excel - Experience with data entry - Ability to create and set up Excel templates Please note that I'm not entirely sure what the final format will look like, so flexibility and creativity will be key.
I'm looking for a seasoned web developer to create a professional design crypto/forex/stock trading and investment website. This platform should allow users to select investment plans and receive returns, with an admin dashboard for overall site management. Key Features: - A user dashboard that allows tracking investment progress, managing deposits and withdrawals, and monitoring referral and investment earnings. - A vibrant and dynamic design style, appealing and engaging for users. - Comprehensive admin controls for overseeing the entire platform. The ideal freelancer for this project should have: - Extensive experience in developing investment platforms. - Strong skills in web design with a flair for vibrant and dynamic styles. - Ability to create intuitive user and admin ...
BUSINESS DEVELOPMENT MANAGER •...their queries and requirements • Develop sales presentations or proposals to explain service specifications • Maintain customer records by using the CRM and logging communication • Receive and follow-up on clients funding, volume, and new account activations Requirements: Academic Qualification Requirement: - B.Sc. Degree from any discipline - 4 years of extensive experience in Forex/ Banking/ Stock and Commodities Brokerage fields in sales Department Professional Key Knowledge Area Requirement: - Financial markets knowledge in FX, Stocks, Commodities - Technical and Fundamental analysis Skills & Competencies: - Strong relationship management and networking skills - Selling skills - Communication skills - Customer orient...
I'm looking for an Excel Macro expert to create a macro for me that will automate reporting from local Excel files on my Mac. I need this to enhance efficiency and accuracy in my data handling.
More details: What specific functionalities do you need in the inventory management sheet? Track stock levels, Automate ordering, Generate usage reports How will the initial data be entered into the inventory sheet? Manually What type of items will be tracked in the inventory sheet? Finished goods, Cleaning supplies
I'm seeking a skilled PHP developer who can seamlessly publish real-time Excel data from my PC or OneDrive onto my WordPress website. This Excel file, which contains some external links, needs to be displayed in a customized table format. Key Requirements: - Expertise in PHP and WordPress - Proficient in handling Excel data and creating table formats - Capable of implementing real-time data updates - Experience with integrating external links into Excel Ideal Candidate: - A PHP developer with a strong background in WordPress and real-time data publishing - Able to customize Excel data into a table format - Quick and efficient in delivering high-quality work
I'm looking for an Excel sheet that can help me track my daily body vitals. The metrics I need to monitor are heart rate, blood pressure, and body temperature. I will be inputting the data manually, but I also want the sheet to be compatible with data from my smartwatch. Ideal Skills: - Excel expertise - Understanding of health metrics - Experience with data tracking sheets Key Features: - Manual data input fields - Compatibility with smartwatch data - User-friendly design
Input data, ms word, Excel, ppt Dapat bekerja dengan teliti
...Management: Automate VAT calculations and tax filing reports. Payroll Integration( (optional).: Manage staff salaries and incentives Audit Logs: Maintain logs for all financial transactions. C. Inventory Management Centralized Stock Tracking: Real-time inventory updates across all branches. Track stock transfers between branches. Alerts: Low stock alerts and auto-reorder suggestions. Expiry date warnings for medications. Supplier Management: Track supplier orders, deliveries, and payments. Batch management (e.g., batch numbers for medicines). Multi-Branch Stock Reconciliation: Resolve discrepancies between branches. D. Multi-Branch Management Branch Roles: Admin (full access to all branches). Branch Manager (manage their branch only). Pharmaci...
I am a data analyst in need of assistance with creating a sales report in MS Excel. Ideal skills for this project: - Expertise in MS Excel - Strong data analysis skills - Experience in sales report creation Looking forward to your bids.
Looking for a freelancer to assist with data entry and creation of documents in Excel. The ideal candidate should have experience with both numerical and textual data entry, and be proficient in Excel. The project involves creating and entering less than 50 documents, and we are open to suggestions on format and templates.
My pick slip template needs some modifications to align with the requirements of my growing business. The modifications are as follows: - Removing the 'Out of Stock' table from the bottom of the pick slip. - Adding a new alphanumeric 'Vendor code' column in-between the 'description' and 'quantity' of the middle table. - The new information to be added in this column is the Vendor code, which is accessible in Business Central. - Add borders between items The final output needs to be in .RDLC format, so that it can be uploaded as a custom template into Business Central. Ideal Skills: - Proficiency in .RDL [XML] and .RDLC file formats - Experience with Business Central - Strong attention to detail - Ability to modify templates according to sp...
De un archivo pdf de buena calidad con 10 - 14 hojas que este en una carpeta llamada pdf y se tiene que extraer solo las tablas y pasarlas a otra carpeta llamada procesadas a un archivo Excel con el nombre de la primera hoja 1.- Scripts en Python pdf a excel 2.- pdf en la carpeta llamada pdf 3.- extraer las tablas y hacer un archivo Excel con nombre de la primera hoja del pdf en la carpeta procesadas Si requieres el archivo para poder ver mejor el detalle mándame un mensaje. Puede ser otro lenguaje de programación y también Google sheets
We are looking for an exp...troubleshooting system issues ✅ Assist with API integrations (e.g., Shopify, Tasklet, Power Automate) ✅ Support system administration, configurations, and backend maintenance ✅ Identify and resolve data inconsistencies, batch processing errors, and stock movement issues ✅ Assist in training and documentation for internal teams Required Skills & Experience: ? Proven experience with Wiise (Microsoft Dynamics 365 Business Central) ? Strong knowledge of API integrations, Power Automate, and Azure Logic Apps ? Experience in ERP administration, stock movement, and reporting ? Ability to troubleshoot batch number mismatches and system posting issues ? Excellent problem-solving skills and ability to work independently Job Type: ? On-demand hourly sup...
I need a skilled developer to create a POS app for my restaurant, specifically for the Android platform. The app should encompass essential features such as order management, inventory tracking, and sales reporting. Key Features: - Order Management: The app should allow for efficient handling of customer orders. - Inventory Tracking: It should help keep tabs on stock levels in real-time. - Sales Reporting: The app needs to generate comprehensive sales reports. Integration: The app should seamlessly integrate with our existing systems. This includes our accounting software, customer loyalty program, and online ordering system. Ideal Skills: A strong background in Android app development is a must. Experience in creating POS systems or similar applications will be a significant a...
I'm seeking a web designer to create a small e-commerce website for selling physical goods. The site also needs to feature an engaging, personality test-style quiz element. Key Requirements: - A shop page with a user-friendly interface - Product pages featuring detailed descriptions, pricing, and stock levels - A quiz-like addition that engages users and tests their personality - An appealing, easy-to-navigate design Ideal skills and experience would include: - Proficiency in e-commerce website development - Experience with interactive, quiz-style web elements - Strong design skills, with a focus on creating engaging, user-friendly interfaces - Knowledge of SEO and digital marketing strategies to increase site visibility and sales.
...Features: ✅ Trip Management • Manually add/edit trips or bulk upload via Excel/CSV. • Automated trip assignment based on driver availability & location. • Live trip modifications (e.g., change pickup times, cancel trips). ✅ Automated Route Optimization • Uses Google Directions API to generate optimized routes. • Real-time traffic adjustments to reduce delays. • Supports multi-passenger trips (patients traveling in the same direction). ✅ Driver Monitoring & Tracking • Live GPS tracking for active drivers. • View driver workload & trip acceptance rates. • Send manual trip reassignment notifications if needed. ✅ Medicaid Billing Integration • Generates Medicaid-compliant trip logs for reimbursement. • ...
I need assistance in arranging data related to gemstone manufacturing on a single spreadsheet. The ideal candidate should be proficient in Excel and experienced in data organization. Key requirements include: - Proficient in Excel - Ability to manipulate and analyze data - Experience relevant to gemstone or manufacturing processes Deliverables: A well-organized and clearly presented sheet containing all relevant data for gemstone manufacturing, ready for analysis.
I need a Python script that can extract hotel names and their corresponding page links from various travel and hotel booking w...Proficiency in Python, particularly in web scraping libraries such as BeautifulSoup or Scrapy, selenium. - Knowledge of data extraction techniques and tools. - Experience with manipulating and structuring data for easy interpretation and usage. Please note that the format for the extracted data has not been specified yet, so flexibility in your coding to allow for various output formats (CSV, JSON, Excel) would be beneficial. Additionally, while the primary focus is on hotel names and page links, potential to expand the data set to include hotel addresses, ratings, and room prices would be appreciated. Please bid if you have the required skills and e...
Looking for assistance with Excel sheets and real estate tasks for my building and real estate projects. Let me know if you're interested!
We are currently seeking a skilled professional for a virtual data entry role. Below are the job requirements and expectations: Primary Responsibilities: • Enter data from PDF files into Excel spreadsheets. • Ensure accuracy and attention to detail. Job Requirements: • Proficiency in Excel. • Typing speed of at least 30 words per minute (to be verified via a typing test on ). • Ability to work virtually with high-speed wired internet (minimum 25 Mbps). • Access to a desktop computer in a professional setting. • Familiarity with remote access software such as AnyDesk or TeamViewer, as the work will be done on our computer. • Availability to work between 10:00–11:00 AM Vancouver time (Pacific Daylight Time). Additional Real ...
I'm looking for a freelancer to create an Excel workbook that consolidates data from 7 source sheets into a main sheet. The solution should dynamically update in real-time as the data in the source sheets change. PLEASE SEE THE ATTACHED PDF FOR A BETTER UNDERSTANDING. Key requirements: - Use either Excel formulas or Power Query. VBA and Macros are not allowed. - Summarize totals for each unique combination of columns A-D from the source sheets. Note : data both sheets could go up to 1000 + rows. Deliverables: - A fully functional Excel file where the main sheet updates in real-time. - Clear documentation or a short instructional guide explaining how the solution works. Ideal skills and experience: - Strong Excel skills and expertise in using Power Qu...
Enhance an Excel file about real estate investment. I'll highlight entry values in green, correct and insert formulas when needed.
I'm looking for a custom Excel template to organize my extensive sports memorabilia collection. The collection includes various types of items, such as: - Autographed items - Trading cards - Game-used items - Pop figures - Jerseys - Balls - Movie memorabilia The template should be user-friendly, allowing for easy input and tracking of each item. Ideal candidates should have experience in creating digital templates, preferably for memorabilia or similar collections. Skills needed: - Advanced proficiency in spreadsheet software - Experience in template creation - Knowledge of sports memorabilia is a plus. Please submit your proposal if you have the required skills and experience. I am not looking to create a logo or websitr
I need an Excel dashboard created from our data that we currently track in Excel across multiple locations. The dashboard should display a variety of key metrics including: - Sales data - YOY Data - Membership Sales - Membership Conversions - Labor as a percentage of revenue - Birthday party revenue and YOY data for same week LY - Concessions Revenue and YOY data for same week LY The ideal freelancer should have: - Expert proficiency in Excel - Experience in creating dynamic dashboards - Ability to visualize data using bar charts and line graphs - Understanding of sales and revenue tracking The dashboard should be able to visualize data using bar charts and line graphs, as well as dynamic dashboard visuals. The dashboard will need to refresh data on a weekly basis. ...
I have an Excel workbook with 7 source sheets and 1 LV (Landing View) sheet. The task is to automatically consolidate data from the 7 sheets into the Main sheet using either Excel formulas or Power Query (VBA and Macros are strictly off-limits). Requirements: - The solution needs to be dynamic, updating the LV sheet in real time as data in the 7 source sheets changes. Deliverables: - A fully functional Excel file where the LV sheet updates in real-time based on data from the 7 sheets. - Clear documentation, or a short instructional guide, explaining how the solution works. Ideally, the freelancer will have strong Excel skills, expertise in using Power Query, and a good understanding of data mapping. Experience with creating dynamic Excel solutions w...
El objetivo principal del Dashboard es monitorear el avance y control de la etapa de preparación de diversas obras públicas, incluyendo el seguimiento de entregables, plazos, presupuesto, riesgos y adquisición de recursos, todo ello en EXCEL. El Dashboard es clave para controlar los avances de múltiples obras, asegurando que el presupuesto no se exceda, que los plazos se respeten y que los recursos (personales y materiales) estén disponibles a tiempo. La toma de decisiones debe ser ágil y basada en datos claros, por lo que los indicadores y las alertas deben estar configurados para resaltar cualquier problema (retrasos, sobrecostos, falta de recursos). Cuento con el alcance y datos claves que deberia tener el dashboard. Contactarme al +*5*1...
Scrape agent's full name, company, mobile number, and suburb from the provided RealCommercial link. Store the data in a structured spreadsheet format. Remove duplicate entries to ensure clean data. Deliver the final CSV or Excel file.
I'm looking for a freelancer who can scrape product data from various websites and compile it into a CSV file. Specific Requirements: - Website Selection: I have not specified which websites to scrape yet. - Data Points: The freelancer should be proficient in extracting the following pieces of information: Price, Product Description, and Stock Availability. - Data Format: The final product should be a well-structured CSV file. Skills and Experience: - Proven experience in web scraping - Proficiency in data extraction and manipulation - Familiarity with major e-commerce platforms - Ability to deliver clean, well-structured data Please reach out if you have the necessary skills and experience.
I'm looking for a Matlab expert with a solid understanding of Artificial Neural Networks (ANN) to help predict stock price crash risk using the data I have. Key Requirements: - Expertise in Matlab, especially in developing and testing ANN models. - Deep understanding of the subject. - Ability to interpret and communicate complex data predictions in a clear and concise manner. The primary goal of this project is data prediction, specifically forecasting potential stock price crashes (dependant CRASH). The ideal candidate will be able to leverage their skills and experience to create a model that can accurately predict these occurrences based on historical time series data.
...Scientific research labs • Medical and clinical labs • School/educational labs • Governmental labs • Food testing labs • HPLC labs • Cytogenetics labs • Industrial labs Data Requirements: Each laboratory entry must include the following: 1. Laboratory Name 2. Address 3. Telephone Number 4. Email Address (mandatory) 5. Website (if available) Project Deliverables: • A spreadsheet (Excel, Google Sheets, or CSV format) containing at least 1,500 unique laboratory contacts. • Each row should represent one laboratory, with columns for the required data points above. Important Details: • Labs from Mexico or Brazil will NOT be accepted. Please do not include any contacts from those countries. • All data must be acc...
I'm seeking a creative designer to develop a store front poster for my gym. The primary objective of this poster is to attract new members. Key Featu...energetic nature of our gym Attached: - I have attached some ideas and inspiration. Ideal Skills: - Graphic design expertise, preferably with experience in creating promotional material for gyms or similar fitness establishments - Strong understanding of visual marketing and how to attract potential customers through design - Creativity and ability to deliver unique design ideas Note: - Logo and stock photos are already purchased and will be provided when the project starts. Your portfolio should include examples of relevant work. Please submit your proposals if you can deliver an engaging design that can help us grow our m...
I need assistance in exporting questions, answers, and explanations from a ChatGPT report into an Excel document. The data consists of 400 items formatted as text paragraphs in the report. Please see example link below: If you open the file above, you will see there are 400 questions organised into: 1) questions 2) correct answer 3) Explanations When you try to ask ChatGPT to export all data into an excel document it doesn't do this properly. It only gives a sample of the questions. I want a freelancer to find a way so that you can instruct ChatGPT to properly export all data so it matches what is produced from before. We have over 100+ documents with each document containing 400+ questions. If you can do it for 1 correctly
I'm looking for a freelancer who can set up an automated process that transfers my inventory details from QuickBooks Desktop to an Excel sheet on a daily basis. Key Requirements: - Data Transfer: The project entails transferring inventory details from QuickBooks to an Excel sheet on a daily basis. - Data Processing: After the data is transferred, I need it to be summarized in the Excel sheet. Ideal Skills: - Proficiency in QuickBooks Desktop - Advanced Excel skills - Experience with data automation Please ensure you have the relevant experience and skills before bidding. I look forward to your proposals.
I'm seeking a proficient accountant with strong financial analysis skills and expertise in Microsoft Excel. Key Responsibilities: - Conduct comprehensive financial analysis - Manage accounts payable and receivable Ideal Skills: - Proficient in Microsoft Excel - Strong financial analysis capabilities - Experienced in managing accounts payable/receivable
...a tailored Excel template to streamline my work checks. Currently, I have to manually copy and paste complicated formulas and use text replace functions to substitute keywords like LESS and PLUS with their mathematical counterparts. For examples sake, I want to put in "(25%LESS1/8LESS1/16 of 7/8) of 1/2 of 1/2 of 8/8" in A1, and have a Cell then automatically output that info. I have used substitute functions, then did evaluate formulas, but doesn't turn out right. Key Responsibilities: - Develop an Excel template that can process long form mathematical expressions and return values automatically, saving me the tedious work. - Ensure the template can handle mixed operations including addition, subtraction, multiplication, and division. Ideal Skills: - St...
I'm in search of a proficient Excel specialist to assist with various tasks related to public data and knows how to do formulas ! . Your primary responsibilities will include: - Data Entry: Accurately inputting information into Excel sheets. - Data Analysis: Utilizing Excel's powerful tools to make sense of the data, organize it and seperate it - Report Generation: Creating comprehensive reports based on the data analysis. Key skills and experience required for the job include: - Proficiency in Excel, with a particular focus on data entry, analysis and report generation. - Experience working with public data. - Expertise in generating charts and applying formulas.
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
I'm looking for an Excel expert to help me create a comprehensive spreadsheet for an educational charity. Key Responsibilities: - The main purpose of the Excel Spreadsheet will be to compare various metrics of specific areas (London Boroughs) within the Region. - We need to compare a variety of metrics. The specific metrics will be populated later, but they could include population statistics, crime rates, and educational outcomes. - The level of detail in the comparison needs to cater for both high-level overviews and detailed analyses. Ideal Skills and Experience: - Proficiency in Excel is a must, with experience in data analysis and spreadsheet creation. - Understanding of educational metrics and social statistics would be a plus. - Ability to create user-f...
I have an old and heavy Excel sheet that often lags. I need an updated, optimized, and improved version without any errors. My primary use for this Excel sheet is data analysis. Specifically, I use it for: - Statistical analysis - Data visualization - Using pivot tables The sheet typically handles more than 100,000 rows of data. Ideal skills for the job include: - Advanced expertise in Excel - Experience with data analysis - Skills in optimizing Excel sheets for heavy data usage - Proficiency in creating error-free and efficient spreadsheets Please note, I need this task completed as soon as possible.
I'm looking for an Excel expert who can help me automate my spreadsheets to reduce manual data entry, specifically dealing with financial data. The ideal freelancer for this job should have extensive experience in Excel, particularly in spreadsheet automation. Skills in handling financial data and creating efficient solutions to streamline processes are a plus. Please include your relevant experience in your bid.
