Automatic graphs excel vbaроботи
Створити таблицю Excel та внести в неї данні з касових чеків. Розбити по періодам та групам.
Потрібно написати модуль (скрипт) для оновлення цін в інтернет магазині. Періодично висилають нові прайси, з яких потрібно підтягувати нові ціни. Вибірку робити по артикулу товару. На сайті поле артикула містить також назву фірми (для прикладу Nowodvorski 65441), а у прайсі просто 65441. Прайси приходять у Excel. Інтернет магазин створений на базі CMS Drupal 7.
Ввод информации в базу, возможно Excel либо другой редактор, могу работать непосредственно с онлайн информацией
Вносити дані до таблиці Excel. Це э дуже непогана робота яку можна виконувати дуже швидко, а головне чітко і без помилок.
saya among dan saya bisa mengoperasikan excel dan saya siap bekrjasama.
I'm seeking a video creator to produce a 1-3 minute promotional video for our esteemed "Postgraduate Diploma in Counselling Psychology" program. The video will target career changers specifically. Key requirements and details: - The video should effectively highlight the program's three main selling points: its course recognition by Singapore Association of Counselli...platforms. The ideal candidate for this job will have: - Proven experience in creating promotional videos, ideally for educational programs or courses - A solid understanding of the psychology of career changers and how to appeal to this specific audience - Excellent storytelling and video editing skills to bring our program's unique strengths to life If this project sounds like something you'...
...an Excel table. The icons are for various amenities that will be listed on a real estate website. Responsibilities: • Search for icons on that match the list of amenities provided. The premium version of Flaticon may be used. • Ensure each icon matches the style and aesthetic suitable for a modern real estate website (in the style as attached files). • Document each icon in an Excel table with two columns: Title and Classname. List of Amenities: • See attached file. Requirements: • Experience with and familiarity with downloading and organizing icons. • Proficiency in Excel. • Attention to detail to ensure the icons are correctly matched to the amenity titles. • Ability to deliver the task within a specified timeframe....
The objective of this project is to create a smart contract on Solana utilizing Rust programming language. The primary goal of this smart contract will be to generate revenue for a specific organization through automatic allocation of funds to an external wallet. KEY FEATURES REQUIRED: * The contract should have the ability to manage ownership transfer. * It would need to direct funds to an external wallet after every transaction is completed. The successful freelancer will have a strong understanding of blockchain and smart contracts, particularly on the Solana platform. Proficiency in Rust is a non-negotiable requirement. Experience of working on revenue generation projects would be a plus. Your tasks will include developing, testing and implementing the smart contract as pe...
Job Title: Excel Expert Needed to Create Yacht Crew Recruitment Cost Template Description: I am seeking an experienced Excel expert to develop a comprehensive spreadsheet template for calculating the costs associated with yacht crew recruitment and retention. I have the necessary calculations and cost categories defined, but I need assistance in creating and formatting the Excel template with advanced formulas. Responsibilities: 1. Develop an Advanced Spreadsheet Template: - Create a user-friendly template in Excel. - Include input fields for recruitment costs, onboarding and training costs, repatriation costs, productivity loss, and miscellaneous costs. - Set up advanced formulas for automated calculations. 2. Implement Calculation Methods: - S...
I'm in need of meticulous and organized professional who can effectively manage data entry, document organization, and scheduling tasks. The scope of the project includes: - Streamlining data entry processes - Organizing and managing key documents, specifically financial statements - Handling a dynamic schedule effectively The ideal candidate should be proficient with Microsoft Excel and Google Suite (Docs, Sheets, Calendar). Your expertise will help us improve our administrative operations efficiently and effectively.
Expectations for this role: * Excellent video editing skills * Best in skills with tools and graphics * You have 100% freedom to be creative and do the editing these videos. Industry: These will be IT training videos or productive videos. Duration: It is a long-duration project Payment: /Video or fixed amount we can p...It is a long-duration project Payment: /Video or fixed amount we can plan it. Initial payment: INR 200 ( Per video ), which we can increase as per quality and your deliverables. Workload: Initially 2 videos per week and can increase to 4-5 videos per week. If qualified, committed and ready for the long term, then only apply. Please share your portfolio to be considered for this role. ( Automatic reply and copy past bid, will be automatically rejected :) ...
I have an Excel file that needs to be formatted with some basic arithmetic formulas. Key Requirements: - I need the data in the cells to be formatted to phone number style. - Basic arithmetic formulas are required for this project. The level of statistical analysis you'd need to provide is basic, such as mean, median, or mode. Ideal Skills/Experience: - Proficiency in Excel and formulas is a must. - Experience with basic statistical analysis is preferred. Please get in touch with your credentials and prior work samples. Thank you.
Paris, thanks for discussing the project with me. This is for what was entered at this project: -Create a worksheet to analyze purchase orders (pending balance to receive from open orders, total cost of the purchase after considering extra expenses, follow up on payment, etc) I did it as a fix price considering something close to the hours you mentioned you would need. If you think that would need to be adjusted we can review. Project requires NDA and IP Agreement.
I need a detailed spreadsheet of information taken from public meetings. The content I'm seeking to compile involves: - Date of the meeting - Detailed descriptions of action items that were voted on, including the specific amounts. In this assignment, precision, attention to detail, and understanding of meeting notes is crucial. Mastery of Excel and experience handling similar tasks is required. Familiarity with action items and the voting process in public meetings will be a plus.
I'm in need of a VBA script that can generate textual reports from Excel spreadsheets. Key Requirements: - The VBA script should focus on generating textual reports, without the need for incorporating charts or graphs. - The data source for the report generation will be Excel spreadsheets. Ideal Skills and Experience: - Proficiency in VBA coding and automation. - Strong understanding of Excel and its data manipulation capabilities. - Prior experience in report generation through VBA is highly preferable.
I need a tool that can scrape text content and tables from LinkedIn quickly and efficiently into an Excel format. The tool needs to be able to: - Extract text content and tables from LinkedIn - Export the scraped information into Excel format - Operate quickly and efficiently to meet a tight deadline The ideal candidate should have: - Experience in web scraping, particularly with LinkedIn - Proficiency in Excel - Ability to develop a tool that can operate quickly and effectively Given the urgency of this project, I need someone who can start ASAP and deliver the tool in a timely manner. Experience with rapid tool development would be a huge plus.
I'm in need of a skilled developer who can design and implement a tool for me. This tool will generate market reports for neighborhoods/cities. The reports should be comprehensive and include key details such as: - Average home prices - Number of homes sold - Average days on market - Graphs depicting increase/decrease trends over the past 12 months The ideal candidate for this job should be proficient in working with RETS or RESO API, as these platforms will be the primary data sources for the tool. The generated report should be accessible through a web page, so web development skills are a must. Your primary responsibilities will include: - Building a tool that fetches and compiles data from the RETS or RESO API - Designing and implementing a user-friendly web page for the...
I need an experienced social media video editor and content creator to produce short videos for a social media advertisement. The advertisement is for an upcoming Alumni Reunion/Networking event. The v...Proficient in video editing software (e.g., Adobe Premiere Pro, Final Cut Pro) - Experienced in creating content for various social media platforms, particularly Facebook, TikTok, and YouTube - Highly creative with a strong visual aesthetic - Knowledge of copyright laws and usage of royalty-free music - Strong communication skills to understand and execute my vision If this sounds like a project you'd excel at, I'd love to see some examples of your previous work. I will provide longer version videos of past events. You'll need to use shorter clips from the long video...
...is capable of efficiently extracting table data from PDF documents. The extracted data should be organized and saved into a customized Excel template. Additionally, the system should be designed to assign different user IDs with varying levels of access control. Key Requirements: - Develop an AI portal with the capability to extract table data from PDFs. - Organize and save the extracted data in Excel using customized templates based on the source PDF. - Implement a user management system that assigns different access controls to various user IDs. Ideal Skills and Experience: - Proficient in AI development and data extraction techniques. - Expertise in Excel automation and customization. - Strong background in user management and access control systems. - Previous...
...should serve the required data to the Angular frontend. - **Real-time Status Updates**: The application should be able to update the user in real-time with the latest trade and progress data. This will require good understanding of data streaming and Angular's capabilities in handling real-time data. - **Data Visualization**: The app will also need a data visualization component, like charts or graphs, for displaying the provided data. Experience with data visualization libraries in Angular or similar frameworks will be an added advantage. Ideal candidates for this project should have a good understanding of Angular, RESTful API development, real-time data processing, and data visualization. They should be able to implement a simple yet effective solution that displays th...
NO TIME WASTERS PLEASE - I have had a lot of issues recently trying to hire someone that says they can do what I ask but cannot. I am looking for help as I am time poor, I am a web developer also. I need a app install that features - cart slide out - will provide automatic discount when a customer purchases 1 or more of a "certain" product - the app needs to allow this - and it does not automatically discount them if customers ads 2 or more. ONLY if the customers adds 1 product to cart - visually appealing I have a lot more work for some proficient in Shopify to help upgrade our site
I'm in need of an AI tool to create and train web chatbots, based on information and/or documents that the customer has entered to feed their chatbot, and they can insert this chatbot into their saas to offer automatic support 24/7 to their customers! The project is similar to this tool: Key Requirements: - Programming Language: JavaScript. It's crucial that the tool supports this language for seamless integration with our existing systems and infrastructure. - Chatbot Functionalities: The tool needs to focus on "Learning and Adaptation." This is critical to ensure our chatbots continuously improve their responses and overall performance based on real-time customer interactions. - Chatbot Customization: I'm looking for an "Advanced" lev...
Looking for an expert in data visualization who can show off their skills by creating some stunning and insightful graphs based on my company's stock data. Here's what I need: - Create a scatter plot of the highest stock price (in the column labeled "High") against time. Write several sentences explaining the process/steps. -Create a scatter plot of the lowest stock price (in the column labeled "Low") against time. Write several sentences explaining the process/steps. -Create a histogram of the adjusted daily closing stock price (in the column labeled "Adj Close"). Make sure the histogram is meaningful by adjusting the bin size so you can see the shape of the histogram. Write several sentences explaining the process/steps by which you created...
I need someone to help with offline data entry. The task involves entering less than 1000 entries into an Excel spreadsheet. Accuracy is key as the data will be used for business analysis. Ideal Skills and Experience: - Proficiency in offline data entry - Advanced Excel skills - Ability to maintain high level of accuracy - Previous experience with similar tasks is a plus
I'm currently working on a historical demography p...freelancer to help with data collection and report writing. Key Responsibilities: - Assist in the collection of relevant data for this project. - Compile the data into a comprehensive and well-structured Word document. - Include visual elements such as charts and graphs in the report to make the data more accessible and user-friendly. Ideal Skills and Experience: - Proven experience with data collection. - Strong academic or professional writing skills. - Proficiency in creating and incorporating visual elements like charts and graphs into documents. - Familiarity with historical demography is a plus. Please apply if you are confident in your ability to meet these requirements and contribute to the successful compl...
I'm looking for someone with strong data gathering skills who can create a comprehensive Excel spreadsheet. The spreadsheet must contain a list of all Australian suburbs along with their corresponding Local Government Areas (LGA). The essential points to be kept in mind are: • The list should be sorted by council areas for easy navigation. • Only the name of the suburbs and their corresponding council areas are required. No additional components such as population or region data are necessary. This project might require advanced web searching capabilities and attention to detail to ensure accuracy of the compiled list. Experience in data extraction is highly desirable.
I need someone who can create a database in MS Excel for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List). 2- A list of all Contracts. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. There should be a Dashboard (Main Page) with link to the pages (Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages) on the top, and below the page list there should be the statistical data of the database. For Add New Invoice page, I should be able to add an invoice details, and if it's related to a contract or purchase order, I should be able to add ...
I'm in need of someone skilled in Microsoft Excel for a couple of tasks. - **Formatting:** Firstly, I require assistance in formatting the spreadsheet. This will include ensuring that the data is clear and easy to read. I would like the spreadsheet to look professional. - **Formula checking:** While the formulas used are not too complex, I still want them to be checked thoroughly for accuracy and consistency. This will mainly involve basic arithmetic operations. I'd appreciate it if you have a background in financial analysis. It would be helpful to have a good eye for detail as well.
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
I require an experienced and proficient VBA developer to create a code that automates data entry tasks in Microsoft Excel. The main objective is to significantly increase productivity and ensure accuracy by automating repetitive data entry procedures. Ideal skills would include: - Vast knowledge of VBA and Excel - Prior experience in developing automation scripts - Exceptional attention to detail - Ability to work within strict deadlines
Need to rectify observations in my report. I'm seeking a skilled SPSS expert capable of providing detailed descriptive statistics and an executive summary based on the data analysis. You'll need to incorporate both visual charts/graphs and a comprehensive written report to effectively communicate the results. Key requirements and skills: - Proficiency in SPSS software - Ability to perform thorough descriptive statistical analysis - Experience in creating visual charts/graphs - Strong report writing skills, particularly in delivering detailed analysis along with an executive summary. The successful applicant will need the ability to interpret data accurately and present findings in a clear and compelling manner. Experience in similar projects within the social sci...
I'm in need of a seasoned Excel expert who's proficient at conducting optimization analysis to solve a real-world problem. Key Requirements: - Profound understanding of optimization analysis - Ability to work efficiently and quickly - Experience with diverse Excel functions Please note that the specific goal of the optimization analysis requires maximizing profits, minimizing costs, or optimizing resource allocation. Your expertise in this area will be crucial to our success.
...daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collection Reports o Daily Receipt Report: Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amounts: Report on o...
...build the interface in React.js. Features: Create and verify user accounts Ability for user to log in, add authentication features See existing projects on a dashboard Create a new project Upload PDF documents, allow for secure storage and easy organization Send documents to an AI LLM API for processing (via Lambda) Handle results and store in PostgreSQL Implement secure payment systems and automatic notification features Provide scripts for provisioning resources in AWS Adhere to best practices for security and data protection Required Skills: Proven experience in web and development. Proficient in front-end and back-end technologies (e.g., React, Node.js, Cognito). Experience with PostgreSQL databases. Strong understanding of UX/UI design principles. Ability to meet deadli...
I need an expert to convert tables from a PDF file into an Excel spreadsheet. The job involves transferring text and numbers from a multi-page PDF table to an Excel document. I have attached the PDF. The analysis should start from page 7. Here's what the project entails: - Converting data from a PDF table that includes both text and numbers - Handling tables that span across multiple pages in the PDF - Transferring the data to Excel without any need for specific formatting or layout changes - Provide the developed script used to obtain the records from the tables. As a freelancer, you should have: - Proficiency in PDF to Excel data conversion - Ability to work with complex table structures - Attention to detail to ensure accurate transfer of all informati...
**Contest: Excel Specialist Wanted for Comprehensive Property Portfolio Management Tool!** Are you an Excel virtuoso with a passion for crafting intricate and comprehensive spreadsheets? We're embarking on a quest to develop the of a cutting-edge Property Portfolio & Financial position Management Tool for our discerning clients. If you possess the expertise to meticulously organize data, create advanced formulas, and design visually captivating presentations, this contest is tailored for you! Join us in revolutionizing property portfolio management with a document that sets the standard for clarity, accuracy, and usability. I would like to be able to edit if required in the future therefore 2 copies will be required. 1 being password and field protected and the othe...
... - Inventory Management: A sophisticated inventory management system is required which involves product categorization, stock monitoring, and purchase order tracking. - GST Reporting: The software should have the capability to generate accurate GST reports in compliance with the relevant regulations. - Billing Features: I would require the software to support invoicing, payment tracking, and automatic payment reminders. Skills and Experience: - Prior experience in developing comprehensive accounting software with inventory management and GST reporting features is highly desirable. - Proficiency in developing web-based applications and integrating user-friendly interfaces. - Strong background in payment systems and invoicing solutions. - Experience in creating multi-user support ...
I'm seeking a technically proficient freelancer to facilitate an integration between my website's payment gateway, Stripe, and Vendus, the Portuguese billing software I currently use. Ideally, the integration should have the following features: - Automatic invoice generation in Vendus in response to transactions completed in Stripe, eradicating the need for manual data input. - Allow secure and efficient transaction process. The ideal candidate for this project will have strong experience with both Stripe and Vendus software, and a proven track record in similar integrations. Understanding of Portuguese is a plus but not essential. Please include examples of similar work when bidding.
I need a software expert to develop a program that scrapes text content off of multiple websites and then cross-references this data against another site. Key Requirements: - The software should effectively pull out text content from all provided sites. - The text content should be in a plain text format, ready for easy analysis and interpretation, preferably in an excel spreadsheet or comma delimited list. - The cross-referencing component is crucial, as the software will need to compare the data scraped with that of another website. Qualifications: - Background in Data Scraping and Software Development. - Previous experience with cross-referencing data. - Proficiency in handling different data formats. In essence, I'm looking for someone who can create a tool that not on...
I am looking for someone skilled in Microsoft Excel and Power Automate. This task involves creating an automation system that sends emails to our internal team members based on given triggers. The automation should trigger when: - An event's start date is approaching - An event's deadline is nearing The email content should serve as a reminder of the approaching start dates. It's pivotal that the chosen freelancer can work with accurate detail to ensure that no deadlines are missed. A deep understanding of Excel, or similar spreadsheet software, automation, and email systems is required for this task. Experience working with scheduling and deadline tracking will be an advantage.
I require an expert in Excel to help me with a statistical analysis of my sales data. The key tasks for this project are: - Conducting statistical analysis: I need you to run a detailed statistical analysis on my sales data. This will involve using advanced Excel functions to analyze variables such as sales trends, forecasts, and correlations. The ideal candidate for this project should have: - Proficiency in Excel: The chosen freelancer should have a deep understanding of Excel and be skilled in using advanced functions. - Statistical Analysis Expertise: Experience in statistical analysis is crucial, as you will be required to interpret the data and provide insights. - Attention to Detail: The work involves handling a large amount of data, so attention to d...
...corner of the triangle Orthogonal rotation • Text moves away from triangle. Minimum distance 1/64” between edge of block and edge of text • Grip allows for rotation from perpendicular Stretch-able location of cable ID • Grip at insertion point of ID text • When the grip moves away from the default location o Line between symbol and text becomes visible o Line around text becomes visible Automatic overlap protection • ID attributes shift if necessary to avoid overlap with other ID attributes. o 0 up o 180 down o 90 left / up (text looks like multiple lines) o 270 right / down (text looks like multiple lines) • Box around text and line from bottom of ID text to midpoint on edge of triangle - Annotative o Triangle block always renders to &f...
I need to improve the existing features of an Excel macro, focusing on enhancing the user interface and experience. Key points: - The primary goal is to make the macro more user-friendly, interactive, and provide better feedback to users. Ideal skills: - Advanced Excel Skills - VBA and Macro Programming - Strong UI/UX design capabilities - User Feedback Integration Please bid if you have experience in enhancing Excel macros in a user-friendly manner and can improve the UI/UX by adding interactivity and feedback. I have a macro working fine. We need 3 improvements: 1- Label photos as A, B and C / 1, 2 and 3 then macro relabel photos per photo matrix 2- Instead to use “SN” in the folder name I want to use “setup” 3- 3- Generate report...
...skilled freelancer who can help automate various tasks in Excel. This includes, but is not limited to, data entry, formulas, and calculations. Key responsibilities: - Automating data entry processes within Excel - Implementing advanced formulas and calculations to streamline calculations - Generating reports and carrying out data analysis using Excel - Ensuring the accuracy and integrity of automated processes Ideal skills and experience: - Proven experience in automating tasks in Excel - Advanced knowledge of Excel functions and formulas - Ability to understand complex data sets and create accurate reports In your application, I'd like to see: - Examples of similar projects you've worked on - Details of your experience with Excel a...
I am seeking an expert in data entry, particularly in the tasks of document conversion, data processing, and data verifi...necessitates the management of confidential and sensitive information, hence, a demonstrated respect and understanding for data privacy is paramount. Key Responsibilities: • Document conversion • Data processing • Data verification Required Skills and Experience: • Proficient with MS Excel • Demonstrated experience in similar roles handling sensitive data • Strong attention to detail • Respect for privacy and confidentiality Note: Familiarity and experience with utilizing formulas and pivot tables within Excel are highly desirable, given the nature of tasks to be performed. Integrity, diligence, and meticulousness a...
I need assistance with copying & pasting data from spreadsheets. The dataset is less than 1,000 entries. Ideal skills and experience for this job: - Experience with data entry, especially from spreadsheets - Attention to detail - Proficiency in Excel - Ability to meet deadlines It's a straightforward task. The goal is to ensure the data is accurately copied and pasted.
I need an experienced Excel programmer to automate repetitive tasks and create custom VBA macros for my project. This assignment requires basic level tasks, so extensive experience in complex macros isn't necessary. Here is what I expect: - Automation of several repetitive tasks to streamline workflow and increase productivity - Creation of custom VBA macros from scratch Ideal Candidate: - Extensive experience with Excel automation and VBA macros - Ability to comprehend and successfully complete basic level assignments - High attention to detail and accuracy Please include your Excel automation and VBA macros experiences in your application. I look forward to working with you on this project.
I need some one to clean a file that has names and addresses The field with the name has business names and first and last name combined. I need them separate. Also some time there are two name or a last name and then the first name of a husband and the first name of the wife I need all that in separate fields See attached sample
