Projek mini excelроботи
Необхідно розробити макрос з перетворенням 1 файлу excel "для обробки" у кілька файлів-шаблонів теж у excel. Суть заповнення всіх полів у цих шаблонах з даних файлу excel "для обробки" згідно з алгоритмом описаним у технічному завданні.
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
I have an xlsx file containing 460 products that need to be added to my current WordPress website. The products already have categories and URLs, so no categorization is necessary. However, the URLs don't require any modifications and only basic product information need to be included - no specific...added to my current WordPress website. The products already have categories and URLs, so no categorization is necessary. However, the URLs don't require any modifications and only basic product information need to be included - no specific attributes such as size, color, or brand. Ideal Skills and Experience: - Proficient in WordPress - Familiar with handling product uploads - Able to work with Excel files - Attention to detail for product categorization - Basic understandin...
I'm...Provider Designation: It needs to include space to designate where providers are used during appointments, to keep providers efficiently moving from patient to patient. - Procedure Difficulty/Stress Level: It should have a ranking system for the difficulty and stress level of each procedure, so that providers are not overly stressed each day. Ideal Skills and Experience: - Proficiency in creating Excel or Google Sheets templates. - Previous experience in the healthcare or dental field would be beneficial but not mandatory. - Strong attention to detail, to ensure every aspect of our busy office can be accurately scheduled. This template will be crucial in streamlining our operations, reducing stress during busy periods, and ultimately delivering a better experience fo...
...my clients' needs. I am dedicated to providing translations that respect the tone and context of the original text." --- If you are a beginner, here is a version adapted for you: "I am a beginner translator, but I am highly motivated, with a strong passion for languages and a solid understanding of grammatical structures. I am comfortable translating [describe the types of text you prefer or excel at, e.g., simple articles, product descriptions, emails]. My goal is to learn quickly, improve, and provide quality translations that meet clients' expectations." --- Tips: Be honest: If you don't have much experience, it's fine to mention it, but focus on your enthusiasm and willingness to learn. Specify languages: Always mention the language...
I'm in need of a proficient Excel expert who can devise a mathematical formula tailored for tracking a business budget. The primary function of this formula will revolve around facilitating various financial calculations. Ideal Skills and Experience: - Extensive knowledge and experience with Excel - Strong background in financial analysis - Previous experience in creating budget-tracking tools - Ability to explain complex formulas in simple terms
Project Name: Design, Programing and simulation of a 3-4 DOF robotic arm using simulink and arduino Software: Matlab Simscape Hardwares (I Have): 1) arduino mega 2560 r3 2) servor mg90s 3) 1.5v - 6v r300c mini dc motor rpm3500 4) sg90 micro servor motor 9g(360°) 5) dual channel motor driver modul L298N H-bridge 6) jumper wire cable 7) breadboard 8) robotic arm kit 6dof Deadline 2 days $20 nzd
I need a custom Excel workbook specifically designed for estimating costs in the construction of custom built sunrooms. Key Requirements: - The workbook should be able to estimate costs for a variety of elements including material costs, labor costs, and permits and fees. - There should be a customer input window for various cost factors including packages for windows, framing, and foundations, as well as siding and roofing. - Additional cost categories to be accounted for include drywall, insulation, electrical, HVAC, interior trim, exterior decking, and flooring. Ideal Skills and Experience: - Proficiency in Excel with a strong background in creating custom workbooks. - Experience in construction cost estimation. - Understanding of sunroom construction and necessary mate...
I need assistance in updating my Excel file with data sourced from an online source. Specific Requirements: - Extracting complete records with all available details from the online source: - Updating the Excel file accordingly. - You can use Excel or Google Sheets (either work) - API or Manual Update possible. (API is recommeded) - Add data in yellow section needs to be updated. - Work needs to be completed in 1 day. See attached excel file. Excel Password: 12345
I'm looking for an expert in Excel and cryptocurrency trading who can help me automate a trading system. The project involves: - Creating an Excel-based system that connects to major exchanges like Binance, Coinbase, and Kraken. - Implementing a triangular arbitrage trading strategy within this system. - Primarily focusing on automating trading execution. Ideal candidates should have a strong background in data analysis, trading automation, and a deep understanding of triangular arbitrage. Experience with these specific exchanges is a plus. The goal is to develop a reliable, efficient, and profitable automated trading system. Attached reference video:
I'm looking for a proficient software developer to create a Windows-based Point of Sale (POS) software for me. This software should cater to a multi-user environment, with a client-side interface for cashiers and a manager server for inventory control and oversight. Key Features: - The software must support importation of items from an Excel spreadsheet to streamline inventory setup. - At least three concurrent users should be supported, with potential for scale. - Additional features like sales reporting, customer management, and employee time tracking are required. - A hybrid user interface (touchscreen-friendly with keyboard and mouse options) for the cashier side. - Custom, role-based access control for different users, beyond just basic cashier vs manager permissions. Id...
I'm looking for someone to convert my Excel project data into an MS Project Gantt chart. The Excel sheet contains both tasks and resources, and I want the Gantt chart to reflect a mix of high-level milestones and detailed tasks. Key requirements: - Understanding of both Excel and MS Project - Ability to accurately represent tasks and resources - Skill in creating a Gantt chart with a blend of detailed tasks and overall milestones - Knowledge of incorporating task dependencies, resource allocation, and critical path identification into the Gantt chart Ideal candidates for this project will have experience in project management and a strong proficiency in MS Project. Please include examples of similar projects you've completed in your application.
I need assistance to convert data from 11 Word documents into a Microsoft Excel or CSV file. The data in the Word documents primarily consists of text. The converted data does not require any specific text formatting to be preserved; plain text is fine. I would like the text to be organized in the Excel or CSV file with one paragraph per row. Ideal Skills and Experience: - Proficient in Microsoft Excel - Experienced in data conversion tasks - Attention to detail for accurate data entry - Able to handle multiple documents efficiently.
Option Explicit Type Authvalinterval Lower_Val As String * 40 Upper_Val As String * 40 End Type Type AUTHVALINTERVAL_TAB wert(1 To 10) As Authvalinterval End Type Type AUTHFIELD_VALS fieldname As String * 10 fieldvals As AUTHVALINTERVAL_TAB End Type Type AUTHORIZATION_TAB AUTHORIZATION(1 To 10) As AUTHFIELD_VALS End Type Type AUTHORIZATION_FOR_OBJECT xuobject As String * 10 AUTHORIZATIONS As AUTHORIZATION_TAB End Type Global IT_ROLE_AUTHS(1 To 100) As AUTHORIZATION_FOR_OBJECT Global sapSystem As Object Global sapFuBa As Object Global sapLogon As Object Global sapConn As Object Global sapReturn As Object Sub RolleAnlegen() Dim wert As Object Dim rolle As Object Dim sapObjekt As Object If InitConnection Then Se...
...Saves data to CSV or Excel files. Data Comparison: Compares newly extracted data with previously saved data. Highlights differences: Added entries: Green. Updated entries: Yellow. Deleted entries: Red. Displays comparison results in a table within the program. User Interface (UI): All interface elements (buttons, labels, etc.) in Korean. Buttons: "Login and Start": Logs into the target website. "Extract Data": Scrapes data from the website. "Load Existing Data": Loads previously saved data. "Run Comparison": Compares new and existing data. "Save Results (CSV/Excel)": Saves comparison results to a file. Table Display: Displays extracted and compared data clearly in a table format. Result Saving: Supports saving in CSV for...
I'm in need of an Excel expert who can create a formula for me that ranks data in one column, starting a new rank when data changes in another column. Key Requirements: - The rank needs to be sorted in descending order within each group. - Understanding of IF statements, SUMIF/SUMIFS, and COUNTIF/COUNTIFS is a must. - Experience with complex Excel formulas and conditional calculations. Your expertise will help me streamline my data analysis process.
I'm seeking an experienced accountant to c...an experienced accountant to create a comprehensive balance sheet and profit & loss statement for a small business. Must have an understanding of USA tax code and a creative mind to explain entries and provide valid scenarios in the current post covid business environment. The deliverables should be provided in an Excel spreadsheet. Ideal Skills and Experience: - Proven experience in accounting and preparing balance sheets and profit & loss statements - Proficiency in Excel - Experience working with small businesses - Attention to detail and ability to deliver accurate financial documents Please note that I currently do not use any accounting software. Therefore, the balance sheet and profit & loss statement ...
I'm seeking a professional who can create a sophisticated Excel sheet for me. This sheet should: - Calculate arbitrage opportunities across multiple cryptocurrency exchanges, specifically Binance, Coinbase, and Kraken. - Fetch real-time cryptocurrency prices through API integration, rather than relying on manual entry or CSV imports. The ideal freelancer for this project should have extensive experience with Excel, a solid understanding of cryptocurrency and its market, and proficiency in API integration.
...be paying a fixed price of ₹100–₹200 for the entire project. If you’re okay with this price, kindly message me back so we don’t waste each other’s time. ### **Tasks to Complete** 1. **Update Portfolio Excel File**: - Add details of 12 new clients who hired me after the initial 60 reviews (the current file includes only 60 reviews). - Create a new column to include links to the portfolio folder for each project, ensuring the links match the respective projects. - Add a column with filters to categorize projects by type, such as: - **Data Entry** - **Excel Charts** - **Outsourced Projects** (e.g., Python projects outsourced to another freelancer). - **And More**. 2. **Organize Portfolio by Project Ty...
This coursework is an individual assignment. You must implement it independently. This coursework is a mini project which applies machine leaning techniques to analyse a real- world data set. You are asked to implement several machine learning tasks using the data from "Stack Overflow 2024 Annual Developer Survey". This survey will help you understand the state of software developers, you can read more about the survey here: Stack Overflow Developer Survey 2024. The dataset can be downloaded from the stack overflow CDN and imported into Kaggle: The following tasks are required in the coursework. (1) Implement exploratory data analysis and gain an understanding
I'm looking to have an interactive Excel dashboard created, focusing on specific parameters mapped at the district level for India. The primary parameter of interest is the Count of Automobile Competition. Key Requirements: - An interactive dashboard that visualizes the Count of Automobile Competition at a district level. - Moderate interactivity, including hover effects and clickable elements. - Presentation of data in an engaging and insightful manner. Ideal Skills and Experience: - Proficiency in Excel, particularly in creating interactive dashboards. - Experience in data visualization and presenting complex data in a user-friendly way. - Understanding of the Indian geographical and automobile landscape would be a plus.
I need to develop a Mini App with the following features: 1. Login: Use a registered account and password to log in. After logging in, 9 single-word items will be displayed. 2. Homepage: • Display products and text rotation. • Clicking on a product redirects to its details page, which includes a “Buy Product” button. • Clicking on “Buy Product” redirects to the order inquiry function. The balance under “4-2” will be displayed as unavailable. 3. My Orders: • Displays: all orders, pending, purchased, invalid, completed. • Orders are displayed with calculated prices, and products being ordered will show up in the order list. 4. Member Center: Recharge: Click to display recharge methods. Monitoring of payment meth...
I need a button added in the seller's account for downloading goods using the Unisite CMS script. This should also include a button in the admin panel for the site admin to download products on the seller's tab. The file format for the downloaded goods list should be in Excel. Ideal skills and experience for the job include: - Proficiency in PHP and knowledge of the Unisite CMS script. - Prior experience in creating similar download functionality. - Familiarity with Excel file formatting and handling.
I'm looking for assistance with Excel, specifically with data entry and organization. The primary focus will be on organizing customer information by customer ID. Key Responsibilities: - Organizing customer data in Excel - Ensuring accuracy and efficiency in data entry Ideal Skills: - Proficiency in Excel, particularly in data entry and organization - Experience with handling customer information - Attention to detail Experience with SEO is a plus, as I am also interested in optimizing this data from an SEO perspective. Please provide examples of similar projects you have completed in your proposal.
I'm in need of a detail-oriented professional to assist with cleaning and entering customer data in Excel. The primary task will be identifying and rectifying errors and inconsistencies within the data. Key Responsibilities: - Cleaning customer data in Excel - Data entry into Excel Ideal Skills: - Advanced Excel skills (proficient with formulas, pivot tables, macros) - Experience with data cleaning and data entry - Attention to detail to identify errors and inconsistencies Your work will help streamline our data management processes and improve overall data quality. Please reach out if you're interested and available.
I need a dedicated professional for manual data entry from printed documents. Key Responsibilities: - Accurately transcribing text data from physical documents into designated digital formats. Ideal Skills: - Attention to detail: Ensuring data is entered correctly without mistakes. - Profici...a dedicated professional for manual data entry from printed documents. Key Responsibilities: - Accurately transcribing text data from physical documents into designated digital formats. Ideal Skills: - Attention to detail: Ensuring data is entered correctly without mistakes. - Proficiency in typing: To ensure efficiency in data entry. - Familiarity with basic software: Such as Microsoft Word, Excel, or Google Docs. - Ability to work independently: Following instructions without constant su...
I'm looking for a professional who can build a comprehensive Excel spreadsheet for daily cash flow management. The model should ideally cater to the following requirements: - **Cash Flow Management**: The primary purpose of the model will be to assist in tracking and managing daily cash flow. - **Graphical Analysis**: The model should include features for graphical analysis, enabling easy visual representation of cash flow trends. The ideal candidate for this project should have extensive experience in financial modelling and Excel, with a strong understanding of cash flow management. Skills in creating visually appealing and informative graphical representations within Excel will be particularly beneficial.
I'm looking for a skilled professional to assist with data analysis and report generation in Excel, as well as setting up workflows, integrating with other tools, and customizing fields and modules in my Zoho CRM. Key Responsibilities: - Analyze data and generate reports in Excel - Customize Zoho CRM to fit our needs - Set up efficient workflows in Zoho CRM - Integrate Zoho CRM with other necessary tools Ideal Skills: - Advanced Excel skills - Proficient in Zoho CRM - Excellent data analysis capabilities - Experience in CRM customization and workflow setup - Familiarity with CRM tool integration
I need assistance in designing and organizing three Excel sheets to streamline our workflow and improve visual appeal. Below are the specific requirements: Sheet 1: Annual Events and Campaigns Calendar Purpose: This sheet will serve as a comprehensive calendar for all events and campaigns throughout the year. It should be easy to read and user-friendly for input by all team members. Sections: Marketing Campaigns Events and Conferences Social and Digital Media CEO Profile Raising C-Suite Engagement Traditional Media Internal Communications and Employee Engagement (EE) International Relations Community Engagement, with subsections: School Visits Festivals Farms Engagement Commercial Campaigns Other. Requirements: Each section should have enough cell space for ...
I accidentally deleted some crucial Word and Excel files from my SSD 6 months ago. I consulted several professionals, they all came to 2 problems: 1, The software cannot find out the files I need. Looks like the software only has a limit on storage of deleted files. After deletion, I have played and deleted a lot of games, so the deleted files scanned a huge, included mostly the games, not the files I want. 2, The recover files are not readable. - I'm looking for a data recovery expert who can use advanced tools to recover my lost files. - Previous experience with SSD data recovery is preferred. - Knowledge of recovery methods for Word and Excel files specifically is a plus. - Chat with me.
Hi,I have two excel sheets in one doc. One is with customer information (name, last name, date of birth, etc) and a code called Leistungsort. The code tells me in which store they went shopping. In the second excel sheet there is the adress of the shops including the bsnr. I need a couple of things. 1.) The adresses of the shops have to automatically be integrated into the sheets with the customers. Columne of the code (Leistungsort is the same in both excel sheets, so with that matching would be possible) 2.) After that i need a word letter with a standardized thext includeing all the customers from one shop. i need one word doc for each shop with the name of all customers. Please see the examples attached. This tasks need to be repeated every 2-3 month so i need a t...
...automatically receive reminders for the event via WhatsApp and email. • Automation tools like Power Automate or other free solutions should be used (NO paid 3rd party integrations allowed). 3. Backend Dashboard for Admin • The admin should: • Able to upload an Excel file containing a list of attendees to be added to the sign up database • Create and schedule to Trigger *Unlimited* bulk messages (email and WhatsApp) from the dashboard to remind/invite them to a Zoom session. • Functionality should include: • Bulk messaging from the Excel data. • Management and re-blasting scheduling options for reminders. Recourses : Website is using wordpress . Microsoft suite , hosting . Send me the Video ( similar project you have done before ) , Sc...
I'm in need of a proficient Excel VBA developer to create a high-performance data logger for me. The primary function of this tool is to log data from a wireless barcode scanner, record weight, and convert that weight into quantity. Key Requirements: - The logger must access conversion data from a sheet that could have over 200k lines. - A more efficient version is needed compared to an existing sample I have. The current version is sluggish due to file size. - It should support multiple users on a local network, compiling all results into a single sheet without missing any lines. - The project has a fixed budget, which is not based on hourly rates. Ideal Skills and Experience: - Extensive experience with Excel and VBA, particularly in creating userforms. - Previous wo...
I'm looking for a professional with strong skills in MS Excel and data analysis to create a comprehensive dashboard for tracking key performance indicators (KPIs). Key Requirements: - Create an Excel dashboard primarily focused on tracking KPIs - Analyze financial data specifically related to revenue and expenses - Visualize key metrics such as sales performance, profit margins, and operational efficiency The ideal freelancer should have: - Extensive experience with MS Excel and creating dashboards - Strong data analysis skills - Ability to present data in a clear and engaging way using MS PowerPoint Please include examples of similar projects you've completed in your proposal.
I need a professional to convert a PDF statement containing financial transactions into an Excel file. The transactions should be organized in Excel exactly as they appear in the PDF.
I need a freelancer to convert my PDF bank statement into an Excel format. The Excel file should provide a summary of my transactions.
I'm seeking a skilled video editor to refine my mini vlog for YouTube. The editing style should be smooth and professional, enhancing the overall viewing experience. Key Tasks: - Edit the video to achieve a sleek, polished finish. - Implement noise reduction to ensure the audio is clear and pleasant to listen to. - Enhance the voice to bring out the best in the audio. - Add background music at appropriate intervals to enhance the mood and pace of the vlog. Ideal candidates will have: - Proven experience in video editing, preferably for YouTube content. - Strong skills in audio editing, particularly voice enhancement and noise reduction. - A knack for selecting and integrating background music seamlessly. - A portfolio showcasing a smooth and professional editing style. Ple...
I'm in need of a proficient freelancer to develop a so...need of a proficient freelancer to develop a sophisticated Excel-based accounting system for my business. This system should not only track sales, purchases, payments, and receipts but also offer full automation and complex tracking capabilities. Key Requirements: - Advanced Level Complexity: The system should be capable of complex tracking and be fully automated. - Basic Integration: I need the system to connect with simple accounting software. - Custom Templates: The system must include templates for invoices and financial statements. Ideal Skills: - Expert in Excel with advanced formula and macro skills. - Previous experience in designing comprehensive accounting systems. - Ability to create custom templates a...
I'm seeking an experienced Excel professional to create a comprehensive balance sheet for tracking my business financials. The Excel sheet should include the following financial statements: - Income statement - Cash flow statement - Statement of changes in equity While there are no specific financial metrics or ratios required at this moment, the ability to easily incorporate them in the future would be a significant advantage. Please ensure the design is user-friendly and intuitive. Excel VBA skills could be beneficial for automating some parts of the sheet.
I'm looking for a proficient Android app developer to create a telecalling application with the following features: - Admin Panel: Ability to upload contact details from an Excel sheet. - Click-to-Call Functionality: Contact details displayed on the app for easy dialing. - Feedback Mechanism: Capturing conversation feedback through predefined options. - Tracking Features: Monitoring total calls dialed, average talk time, and call status tracking (completed, missed, missed). - Reporting: A dashboard that provides comprehensive reports. The primary aim of this app is for lead generation. The ideal candidate should have substantial experience in app development, preferably with telecalling apps, and be able to ensure the app is user-friendly and efficient.
I need someone to convert my handwritten notes, written in both Bengali and English, into an Excel spreadsheet. The task involves not just transcription, but also proper typing and formatting to ensure the data is organized and easy to read.
We are looking for a detail-oriented freelancer to format a spreadsheet containing phone numbers and consent time stamps for easy upload to Klaviyo. The ideal candidate should have experience with data organization and spreadsheet management. Your task will involve ensuring that all...stamps for easy upload to Klaviyo. The ideal candidate should have experience with data organization and spreadsheet management. Your task will involve ensuring that all entries are accurately formatted and ready for upload, following specific guidelines we will provide. If you have a keen eye for detail and are proficient in Excel or Google Sheets, we would love to hear from you. Relevant skills: - Spreadsheet management - Data entry - Attention to detail - Proficiency in Excel/Google Sheets ...
I'm seeking a finance and Excel specialist to assist with my budget tracking spreadsheets. The task involves data entry, formula checking, and calculations. Key responsibilities include: - Assisting in the development of detailed custom reports within the spreadsheets - Working with a variety of financial data, including budgets and 1 to 10-year revenue projections Ideal candidates should possess: - Extensive experience with Excel and finance - The ability to create detailed custom reports - Proficiency in handling a wide range of financial data
Будь ласка, зареєструйтесь або увійдіть в систему для перегляду деталей.
I need a skilled financial analyst to prepare a Pro Forma Income Statement, Balance Sheet, Cash Flow and Waterfall Statements from my Excel data. This is specifically for a project I'm involved in, with the ultimate goal of applying for a loan. Ideal candidates should have: - Proficiency in Excel and financial modeling. - Experience in preparing financial statements, particularly various financial statements. - Understanding of loan application requirements and investor perspectives. Please ensure you can deliver a comprehensive and professional document suitable for loan application purposes.
Seeking a full-time member to ...48 hrs/week. If we find during that period that you are a good fit for the role, this could become a long-term position. Our budget for the job is $2/hr USD. Requirements -- Available Mon - Sat, 9am - 7pm NYC time -- Great visual eye -- Attention to detail -- Fluent in English -- Great communication (verbal and written) -- Patience -- Experience with Google Docs, Google Calendar, & Microsoft Excel preferred -- Content writing experience is a plus. -- Newsletter management is a plus. Roles & Responsibilities -- Quality check photos and provide feedback to photo editor. -- Schedule photography appointments with clients and photographers. -- Respond to customer inquiries via email promptly. -- Send lead generation messages. -- Online resear...
