Web based vba excel data processing projectงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 15,000 ครับ รวมระบบหลังบ้าน ไม่รวม host กับ domain ครับผม 12:13 Avatar ทั้งนี้ต้องดูรายละเอียด ข้อ 1, 3 และ 6 อีกครั้งครับผม วันนี้ 15:24 ฉันสนใจจ้าง 15:25 โทษทีครับ ที่คุยไว้หลายเดือนก่อน โดนเบรคโปรเจคไป นี่จะกลับมาทำ 15:25 พอจะลดได้มั้ยครับ 15:32 อยากจะทำเว็บไซต์รวบรวมยอดขาย พนักงานให้มี Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แล้วแต่แกนที่เราต้องการ export รายงานออกมาเป็น excel ได้ 2. มีระบบ Log in...
ทำ excel คำนวนภาษีส่วนบุคคล 5 คน โดยสามารถเปลี่ยน variable ต่างต่างได้เพื่อทำ scenario analysis (ie ถ้ารายได้ x จะได้ x) ______________________________________________ Excel personal tax calculations for 5 people, with different variables changing for scenario analysis. (ie if income x is obtained x)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
งานที่ผมทำเกี่ยวกับกล้องติดตามการเคลื่อนที่ โดยใช้ Image Processing ในการประมวณผลภาพ โดยใช้กล้อง Webcam ในการจับภาพแล้วนำมาประมวณผลครับ มีตัวอย่างตามไฟล์ที่แนบครับ งานผมทำลักษณะเดียวกันครับ แต่ไม่จำกัดภาษาที่ใช้เขียน จากนั้นส่งค่าไปไห้ไมโครคอนโทรเลอร์เพื่อสั่งการเซอร์โวมอเตอร์ไห้หมุนกล้องไปยังจุด ๆ นั้นครับ อุปกรณ์ที่มีอยู่คือ microcontroller และ servomotor และ webcam ครับ อีกไฟล์เป็นขอบเขตของงานผมครับ ไม่จำกัดภาษาที่ใช้เขียน ระยะเวลาในการทำเสร็จภายในวันที่ 14 มีนาคม 2557 ติดต่อกลับ 085-820-5665 นิกส์
I'm in need of a freelancer who can transcribe a moderately complex PDF file into a Word document, while ensuring that the formatting of the original docume...the original document is preserved. Key points: - The layout of the PDF is moderately complex, including tables, lists, and minor images. - The final Word document needs to be an exact replica of the PDF in terms of formatting and layout. - It should be fully editable, with no text turned into images to preserve formatting. I require a freelancer who has: - Proficiency in both PDF and Word processing. - Experience in managing moderately complex document layouts. - A keen eye for detail to ensure all formatting is accurately transcribed. If you possess these skills and can deliver a high-quality result, please submit...
...application. This tool will structure reports from user inputs and is required to be fully compatible with Microsoft Excel. Therefore, proficiency in Excel-integrated application development is essential. Key Tasks and Specifications include: - Designing and coding a desktop application for report generation - Ensuring the application can accurately convert user input data into structured reports - Implementing compatibility with Microsoft Excel for the accessible and seamless transfer of data The ideal freelancer for this project has a strong background in software development, particularly with creating desktop applications and working with Excel. Experience with coding Excel-integrated apps and understanding of user-friendly U...
I'm in need of an Excel Expert to create a functional and visually cohesive form for my company. The form should have various action buttons and cell locking features to ensure data integrity. Key Features Required: - Action Buttons: The form needs to have a 'Submit' button for data submission and a 'Clear' button for form reset. - Time Store Function: This unique feature should automatically calculate time spent on the form, store time values in a specific cell, and generate a report of time spent. Its implementation should be seamless and user-friendly. - Cell Locking: Certain cells in the form must be locked to prevent accidental changes. This is crucial for the form's operational integrity. Design Requirements: - The form should be ...
I'm in need of a professional designer to create a text-based logo and minimalist t-shirt designs. Key requirements: - Text-based logo: I'm looking for a simple yet effective logo that emphasizes text. It should be unique and memorable, representing my brand effectively. - Minimalist t-shirt designs: I'm seeking t-shirt designs that are clean, understated and yet visually appealing. This will help to ensure the designs can be easily applied to t-shirts and other merchandise. An understanding of typography and color theory is crucial to deliver high-quality work. The ability to create designs that are suitable for printing is also a must. Ideal skills for this job include: - Proficiency in graphic design software such as Adobe Illustrator and Photoshop - S...
I'm in need of a designer who can craft a creative, text-based logo for my business. The ideal candidate should have a keen eye for detail, color, and typography, and abilities to effectively communicate my brand's creativity using warm colors like reds, oranges, and yellows. Skills & Experience: • Logo Design • Typography • Color Theory • Creativity • Understanding of Brand Identity Looking forward to your proposals!
I'm in need of a website that is secure and provides my clients with the ability to register and login. The ke...login. The key features of the site should be: - User registration - User login - User profile creation My clients should also be able to access an Excel file on our Onedrive cloud and extract pricing information from there. Finally, they should be able to submit their orders directly to us via email. This includes order details such as description, price, and delivery instructions. Additionally, clients should be able to attach relevant files to their orders. The ideal candidate for this project would have vast experience in secure website development, Microsoft Onedrive integration, and email integration. Familiarity with order processing systems w...
...developer to create a web-based application that connects to an API. The primary purpose of the app is booking real wood products specifically. Key Requirements: - The app should facilitate booking of wood products, which could be furniture, timber, or other related items. - It needs to be connected to an external API for real-time pricing, availability, and order processing. - The user interface should be intuitive and user-friendly to ensure a seamless experience for potential agents/clients. Ideal Skills: - Proficient in web app development with a strong understanding of APIs. - Previous experience with booking systems is a plus. - Knowledge of e-commerce platforms and payment gateways. - Ability to design a visually appealing and user-friendly inter...
...tasks primarily centered around Excel and Word. - Excel: The emphasis will be on crafting sophisticated formulas and performing financial projections. I need someone with an understanding of finance and the ability to manipulate data in Excel. A depth of knowledge in Excel formulas, calculations, and data analysis is crucial. - Word & PDF: Apart from Excel work, there is a need for expert formatting and layout design skills in Word, as well as converting Word documents to PDF format. Finally, I am seeking someone who can apply a professional design to a CV. The style I want to embody is professional, and therefore a good understanding of professional layout design and typography will be beneficial. Ideal candidates should have...
I'm in need of an expert in Excel for data entry and cleaning. The tasks involve handling text-based, numeric, and date & time data. Key Responsibilities: - Perform accurate data entry - Cleanse and format the data as needed Ideal Skills and Experience: - Proficiency in MS Excel - Proven experience with data entry and data cleaning - Attention to detail - Ability to work with various data types, including text-based, numeric, and date & time data
I'm looking for a skilled website developer who could take on creating an e-commerce website for my business from scratch. I need some key functionalities built-in, including: - Inventory management - Payment gateway - User registration and login The number of products to be...website for my business from scratch. I need some key functionalities built-in, including: - Inventory management - Payment gateway - User registration and login The number of products to be featured on the website will be discussed at a later date. Ideal candidates should have extensive experience in e-commerce platforms and strong knowledge of inventory management systems, secure payment processing, and user-friendly registration interfaces. Your portfolio highlighting similar projects would be mu...
...of a meticulous freelancer to assist with data entry and the organization of several Excel spreadsheets. Your primary task will involve entering data from various not-specified sources into Excel, as well as categorizing and structuring this data in a logical and efficient manner. Desirable Skills & Experience Required: - Mastery of Excel functions and formatting features - Strong attention to detail and accuracy - Proven experience in data entry - Ability to work with limited supervision - Data analysis and detection of irregularities is considered a plus. The task doesn't necessarily require prior relevant experience but being familiar with Excel and data structuring principles would be advantageous....
I am seeking a specialist to create a Word to PDF conversion tool. The tool should be capable of batch processing to manage multiple Word documents at a time. Maintaining the original document's layout is essential, but minor adjustments are acceptable. - Ideal Skills: Experience in Word and PDF software, batch processing systems, and document formatting. - Experience Required: Proven experience with similar projects, knowledge about Word and PDF file structures, and a knack for preserving layout with acceptable minor changes. Capable candidates, bring your expertise to the fore and support this endeavor in transforming Word documents into PDFs efficiently.
I need assistance transferring my handwritten notes into a digital spreadsheet. Ideal skills and experience include: - Proficiency in data entry - Ability to decipher handwritten text - Expertise in spreadsheet software, such as Excel or Google Sheets
...an advanced Excel user, I'm looking for a professional who can help me with two specific aspects of my project: performing advanced data analysis and creating macros to automate repetitive tasks. Key Requirements: - Data Analysis: You should be well-versed in data visualization, statistical analysis, and data cleaning and manipulation. Your ability to extract insights from complex data sets and present them clearly is crucial. - Macro Development: You will be responsible for automating repetitive tasks in Excel, including generating reports, automating data entry, and creating efficient formula calculations. Your macros should be user-friendly and easy to maintain. Ideal Skills: - Proficiency in Excel, includi...
I'm seeking a Python developer who's proficient in web scraping to help me extract data from social media platforms. Key Responsibilities: - Develop and implement a Python script for web scraping data from social media channels. Deliverable: - The scraped data should be compiled and delivered in an Excel spreadsheet for further analysis. Ideal Candidate: - Proficient in Python with a strong background in web scraping techniques. - Prior experience in scraping data from social media platforms will be a big plus. - Ability to deliver the end results in an organized, neat and easily accessible format, such as an Excel spreadsheet. Please reach out if you think you're the right fit with the necessary expert...
I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with P...
As I'm looking for a skilled ERP and CRM developer to support the development of a comprehensive system for my business. The ideal candidate will have expertise in: - Inventory management - Sales and order processing - Financial management - Customer relationship management - Indian accounting and taxation Your primary responsibilities will include: - Designing, developing and maintaining the ERP and CRM system - Ensuring the system is fully compliant with GST regulations and other Indian accounting standards - Implement features like: - Lead management - Contact management - Sales forecasting - Bookkeeping - Bank reconciliation - Payroll The successful freelancer should have a robust understanding of ERP and CRM systems, particularly in the context of the Indian...
...system is to process images captured by cameras in real-time. The OCR system will be used for analyzing the data extracted from the digital meters, so a high level of accuracy is required. Key Requirements: - Develop an OCR feature that can accurately read and extract characters from digital meters - Implement the system to process images captured by cameras in real-time Ideal Skills and Experience: - Strong background in OCR technology, python, Tesseract, customized ocr readers, particularly with processing images from cameras - Experience in developing systems for specific industrial use cases is a plus electric meters, kwh meters etc. - Ability to handle a large amount of data accurately and in a timely manner. Please bid if you have the skills and experienc...
I need help with a range of AWS Cloud Practitioner tasks, across foundation, architecture, and development. The primary goal of this assistance is to build a strong understanding of AWS core services. Key Requirements: - Assistance across AWS Cloud Foundation, AWS Cloud Architecture, and AWS Cloud Development. - Guidance in understanding core AWS services. Ideal Skills and Experience: - Proven experience in AWS Cloud Practitioner tasks and concepts. - Strong communication skills to explain and guide through the complexities of AWS. - Previous experience in teaching or mentoring others in AWS is a plus, but not mandatory. It’s essential that you understand the holistic view of AWS to assist me in gaining a comprehensive understanding of the platform. Please indicate your experienc...
I'm in need of a comprehensive contact list for Queensland-based mine sites. I'd like the list to include: - Company name and contact details - Mine site location and address - Contact person and title I'm looking for a high volume of entries, so ideally more than 50 mine sites should be included. The final deliverable should be an Excel spreadsheet. Ideal freelancers for this project should be experienced in data mining and collection. You should be thorough and detail-oriented to ensure all information is accurate. Knowledge of Queensland's mining industry would be a plus.
I have a requirement for someone adept at data entry and proficiency in working with PDF documents and Excel. My project involves converting a PDF document into Excel format. Key Details: - Source Document: The source document is a PDF which needs to be copied verbatim into Excel. - Structure: The data should be displayed in the Excel document exactly as it appears in the PDF format. No need to segregate into different columns based on the type of data. - Special Handling: There are no specific requirements for handling or formatting any particular data in the PDF document. Ideal Skills: - Experience in data entry and manipulation - Proficiency in Microsoft Excel - Ability to work accurately with P...
...**Designing the Website**: I have a specific theme in mind, so your expertise in implementing this design and ensuring a smooth, visually appealing interface is crucial. - **Setting up Product Categories**: Organizing the store's products into logical and user-friendly categories is an important aspect of this project. Your skills in structuring and optimizing these categories for easy navigation and search will be highly valued. - **Integrating Payment Gateways**: Seamless and secure payment processing is key to the success of my store. Your ability to integrate the necessary payment gateways, ensuring a smooth and hassle-free purchasing experience for customers, is essential. In addition to these tasks, the store will require: - **Custom Product Options**: The abi...
...detailed data analysis project. This project involves extracting, analyzing, and reporting on data from a sophisticated relational database setup. The ideal candidate should have a solid background in data science, with specific skills in SQL and R. Responsibilities: Efficiently query and manage data using SQL from a SQLite3 database. Apply R programming techniques for advanced data cleaning, analysis, and visualization tasks. Ensure data integrity and optimize data processing workflows. Analyze results to derive actionable insights and compile detailed reports. Document all processes and code in a clear and comprehensive manner. Requirements: Profound knowledge of SQL with experience in handling large-scale databa...
...me know. - Multiple Payment Options: We need to make it easy for the customer by offering multiple payment options. Ideal Skills and Experience: The ideal candidate should have extensive experience in WordPress plugin development and should be familiar with API integrations. Knowledge of efficient payment processing systems and taxi booking systems would be an advantage. Coding skills should also accompany a good sense of UX, since user-friendliness is key to the success of this project. We are looking for someone who can deliver a high-quality and reliable plugin....
...a lightweight, text-based version of the classic Pac-Man game specifically for the Mac platform. The development will focus only on the easy level of gaming, meaning only Pac-Man, mazes, and points will be incorporated, no ghosts or power-ups. Moreover, the design should align with the classic look of the original game. Given the specific development needs, the ideal freelancer should possess: - 2-3 cpp/hpp files - driver file - only using #include<iostream> #include<conio.h> #include <stdlib.h> #include<windows.h> Library’s -no graphics text based. -MAY 10th - Proficient understanding of C++ - Mac game development experience - An understanding of classic game design - An appreciation for the original Pac-Man game to ensure accura...
I'm looking for an experienced Excel professional to help me set up a SUMIFS formula in an Excel spreadsheet with the following requirements: - The SUMIFS function needs to work with numeric matching criteria. - The source for the data is an Excel spreadsheet. - The most crucial aspect for this project is that the SUMIFS formula needs to be dynamic. It should update automatically as new data is added to the spreadsheet. Ideally, you should have: - Proven experience working with Excel SUMIFS functions, especially with numeric matching criteria. - The ability to create dynamic formulas that update with changes in the source data. - Strong attention to detail to ensure the formula is implemented correctly and efficiently. If you&...
I'm on...the hunt for a skilled Data Analyst who will work closely with our customer data, primarily formatted in Excel/CSV. The primary goal of this analysis is to identify trends and patterns that could aid our business processes. Key Responsibilities: - Deep analysis of customer data to identify patterns and trends - Create visually engaging and understandable reports Ideal Skills and Experience: - Proven track record as a Data Analyst - Comprehensive understanding of data analysis methodologies - Superior skills in Excel/CSV data processing - Ability to present complex information in an engaging and understandable manner. Your contribution will hugely impact our business decisions. I look forward to viewing your...
Project Overview: The project involves reconciling sales data with weekly remittances over a span of 2.5 years in Excel. This requires merging multiple remittance files into one cohesive dataset, and then cross-referencing the sales data with the remittance data using a unique identifier (e.g., order number). The goal is to ensure that each sale corresponds to an accurate payout in the remittance, identifying any discrepancies or missing payments. Project Tasks: Data Collection: Gather all sales data and remittance files spanning 2.5 years. Ensure each dataset includes a unique identifier (e.g., order number) for matching. Data Merging: Consolidate all remittance files into one master remittance dataset. Arrange the ...
I'm seeking a driven sales assistant well-versed in multitasking. Your main responsibilities will include cold calling, lead generation and sales follow-up. My business resides within the marketing industry. Having knowledge of different marketing channels like social media, email marketing, consulting, content production, and digital assets is preferred. To excel in this role, here's what you need: - A strong background in sales particularly cold calling and lead generation. - Good understanding of multiple marketing channels. - Excellent follow-up skills to ensure effective sales conversions. Apply if you're ready to help drive growth in an active marketing environment.