Advanced excel data processingงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ 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)
หาข้อมูล 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 นิกส์
This script must be developed in Python 3 or higher and must take a PNG image as input and return 4 letters. It is desired to achieve 95 percent accuracy or higher (out of a total of 200 test images), not use paid libraries, and be efficient (less than 3 seconds processing time per image). Hardware where it will be tested: Architecture: x86_64 CPU operation mode(s): 32-bit, 64-bit CPU(s): 8 Memory: 15877 The images can be extracted from the following site (captcha image):
...pipeline to handle continuous file deliveries, where new folders with JSON files are added over time. For example: Step 3: Data Quality Assurance: ● Create a suite of data checks to ensure the data is clean and add a DBT command to run these checks. ● Suggest additional information or metrics that could be used to further ensure data integrity and quality. Key tasks would include: - Setting up DBT and SQLLITE - Developing and testing the pipeline - Establishing appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with data pipelines, specifically involving text file processing - Familiarity with data transformation techniques - Quality assurance and bug fix...
I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)
...program is centered around data processing. The project will be divided into two primary tasks: - Writing the Program: The ideal candidate should have strong proficiency in Racket LISP/Scheme, with a proven background in developing data processing applications. You will be provided with additional details on the specific requirements of the program. - Documentation: The second part of the project involves creating comprehensive documentation for the program. Ideally, you will be able to write clear and concise technical documents, with a strong attention to detail. Specific features or requirements for the program include: - Input Validation: Ensuring that the program correctly processes and validates input data. - File Handling: Involves reading an...
I'm in need of a highly skilled instructor with advanced accounting knowledge to develop educational video tutorials for my YouTube channel. The primary focus will be on financial accounting topics. Key Responsibilities: - Creating engaging, informative video tutorials - Presenting complex financial accounting concepts in an easily understandable manner Given the nature of this project, it would be ideal if you have: - Advanced knowledge in accounting, specializing in financial accounting - Experience in teaching or tutoring, preferably in creating e-learning content - An ability to simplify complex concepts into digestible content - Proficiency in creating video tutorials, from scripting to presentation. Your insights and expertise will play a key role in helping my...
...value by improving video and sound quality, integrating texts, and employing impactful visual effects. Responsibilities: Edit and assemble raw footage into high-quality, finished projects tailored for different platforms, following specific content style and technical requirements. Improve video clarity and visual appeal, including color correction, lighting adjustment, and sharpening using advanced editing software. Add appropriate soundtracks, voiceovers, and adjust audio levels to enhance the overall video impact. Integrate dynamic text overlays, subtitles, and graphic elements to effectively communicate the message and enhance viewer engagement. Collaborate with our creative team to ensure each video meets the strategic goals and maintains brand consistency. Deliver polishe...
I'm in search of a talented developer with strong expertise in Python and options...applying neutral strategies. - The strategies should accurately consider option strike prices. An in-depth understanding of how option strike prices impact the trading outcome will be invaluable for the success of the project. - The complexity level required in this project involves developing multi-leg option positions. Therefore, experience and knowledge in creating such advanced strategy positions is a must. Advanced knowledge in Python, financial markets and specifically in options trading is highly important for this project. A strong background in trading strategy development will be a significant plus. Looking forward to working with a capable expert to accomplish this challengin...
I am seeking a gam...puzzles. Incorporating a storyline or theme into the game is crucial for immersing players in game play. Features Requested: - Sudoku Puzzle Implementation: The game will primarily focus on providing Sudoku puzzles for the user to solve. - Varying Difficulty Levels: Players should be provided the freedom to select their preferred difficulty level. This feature should range from beginner to advanced levels to cater to a wide audience. - Intertwined Storyline: Incorporate a unique captivating theme or storyline into the Sudoku puzzles to enrich the overall user experience. Ideal Skills: - Familiarity with the Sudoku puzzle system and various difficulty levels. - Experience in mobile game development. - Ability to creatively weave a storyline into the game...
I am in search of a seasoned AI developer with expertise in various AI domains. The ideal candidate should have a strong background in: - Natural Language Processing - Machine Learning - Computer Vision I'm also looking for a candidate with a proven track record of working on complex AI projects. Please provide details of your past work and experience in the AI field. A detailed project proposal would be a plus. The project will involve developing a sophisticated AI system, so it's crucial that you are well-versed in the latest AI technologies and methodologies. Feel free to share any specific programming language experience you have, although it's not a prerequisite. Looking forward to receiving your application!
I have an urgent need to withdraw some money, and for that, I need a photo of my ID. The ID picture is on my phone but I am facing difficulty in processing it. I need immediate help in converting the photo into a format suitable for a SCID application. I need someone who is experienced with this process to assist me. Key requirements: - Expertise with SCID photo requirements - Ability to assist urgently - Previous experience with similar tasks is a plus. Please reach out to me if you can help.
Seeking assistance to streamline my medical billing tasks, specifically in insurance claims processing and payment posting. With an in-depth understanding of Excel spreadsheets and electronic medical billing software, your expertise will be used to enhance efficiency. The complexity of the project is increased as working with more than 10 healthcare providers. Key Attributes: - Proficient in insurance claims processing - Experienced in payment posting - Competence in the use of Excel spreadsheets and electronic medical billing software - Background in working with numerous healthcare providers While the task will be challenging, your contribution will be pivotal in improving our system. Looking forward to your applications.
As the client for this project, I'm seeking a skilled developer for an effective e-commerce website that handles both physical and digital products. This site needs to be specially developed for seamless bank transactions. Key requirements include: 1. Capability to list and sell both physical and digital products 2. A secure system for processing bank transfer payments 3. Immediate project commencement with swift completion Strong applicants should come with experience in e-commerce website development, payment gateway integration (specifically for bank transfers), and efficient project delivery capabilities. Familiarity with both physical and digital product catalogs is crucial for this job.
I'm seeking a proficient developer to create a robust photo editor with the following features: - Cropping and resizing capabilities - Basic color adjustments - Implementation of filter presets T...proficient developer to create a robust photo editor with the following features: - Cropping and resizing capabilities - Basic color adjustments - Implementation of filter presets The software should support importing and exporting in JPEG and PNG formats. In terms of design, I am looking for a user interface that is advanced and customizable to cater to a variety of user needs. This project requires strong skills in UX/UI design, along with a solid understanding of image processing and manipulation. Experience creating photo editing software or similar applications wi...
...searching for a Python developer knowledgeable in numerical data analysis. The key task of this project will be developing a Python script for classifying images. This script will then need to perform advanced data visualization tasks on numeric data. Task would be to analyze a dataset containing different types of fish breeds Images and is required to classify them using CNN based on their location and chemical compositions in various parts of an ocean/location Ideal Skills: - Excellent grasp of Python programming - Strong understanding of image classification techniques - Proficiency in numerical data analysis - Expertise in data visualization methodologies Previous experience with projects involving Python, image classification and ...
I am in need of knackful lead generation specialists capable of targeting individuals interested in online courses spanning Data Science, Digital Marketing, IT, Finance, and so on. Desired Qualifications: - Proven experience in quality lead generation - Knowledge or experience in the online course industry - Confident in reaching target audiences through various methods Job Scope: - Identify potential leads interested in online courses - The skill-level of the leads is not specified; your expertise should cover targeting beginners to advanced learners - You have the freedom to use popular lead generation strategies like Social Media Ads, Email Marketing Campaigns, Search Engine Optimization (SEO), or other beneficial channels This project provides an opportunity to apply ...
MATLAB USERS Visual Processing and Object Detection: The first task will be to detect and segment objects in images using traditional computer vision methods. It will be necessary to automatically separate the balls from the background and evaluate the accuracy of the segmentation. Feature Calculation: The second task will be to extract texture and shape features. By using appropriate algorithms to calculate the shape attributes of the balls, it will then obtain textural attributes with gray level collaborative matrices. Object Tracking: The third and final task will be to track the movement of a ball by applying a Kalman filter. Working with real and noisy coordinates, it will create a tracking algorithm and compare the tracked path with the real one. summarize this in 250 words
I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel...
I am in need of expert help to scrape text data from specified websites. After the data has been collected, the next step is to clean the data, ensuring that it is in the appropriate format for use. The final output should be managed and stored in a Database Management System. The ideal freelancer for this project should have: - Proven experience in web scraping, specifically text data from websites - Advanced skills in data cleaning to ensure the data is usable and well-structured - Capabilities to manage and store the cleaned data into a Database Management System Please provide any relevant examples of previous work in web scraping and data cleaning and provide details about how you plan to carry out this project.
I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...
I am seeking an experienced C programmer to assist in the implementation of the Inpainting ...seeking an experienced C programmer to assist in the implementation of the Inpainting Interpolation Algorithm into my existing application. Key Requirements: - Implementing the Inpainting Interpolation Algorithm - Working with images as the primary input - Generating enhanced images as output The ideal candidate will possess: - Proficiency in C programming language - Strong background in image processing and manipulation - Experience with algorithm implementation - Prior knowledge of Inpainting Interpolation Algorithm would be a plus I have to implement algorithm described here : into my own function. I will share more informations in a DM
I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.
I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with a detail-orien...
I am looking for an artist to create a photorealistic CGI rendering for visualization purposes. I have plans with elevations which I attach. This is an outdoor barbecue area Task needs to be complete in 48hrs. When you provide me with a quote please address me as Steve. Ideal candidates for this project should: - possess advanced skills in photorealistic CGI rendering - have experience in rendering interior details - be able to interpret and visualize designs accurately - be detail-oriented Please share your portfolio showcasing similar projects you've undertaken. We anticipate a collaborative communication process to ensure that the resulting render meets our visualization needs.
I require expert help with photo editing, particularly in removing white lines that are present throughout an image. Here's what this project entails: • Remove all types of white lines (vertical, horizontal, and diagonal). • Ensure the final image looks organic and seamless after the line removal. The ideal freelancer for this project has advanced retouching skills combined with exceptional attention to detail to ensure no distortions or visible signs of editing remain. Previous experiences in similar projects will be a definitive plus. Fluency in English is also required to facilitate smooth communication. Looking forward to your proposals.
I'm in need of a freelancer capable of efficient and precise textual data entry into Microsoft Excel. This project requires a keen eye for detail, a high level of accuracy, and excellent organizational skills. You should be fluent in English and proficient in using Excel. To make an informed bid, freelancers should include the following: - Examples of past work related to data entry, particularly with Microsoft Excel. Stats that display the accuracy and efficiency of your work would be a huge plus. - Any relevant experience in data entry or related fields. Please note, attention to detail and Excel proficiency are paramount to this project.
I require a WordPress developer to create a website with e-commerce functionality for selling physical goods. Requirements: - We need to implement advanced product customization options. This will be a key feature of the website and is crucial for our customer experience. - The website will be selling physical goods, so experience in creating e-commerce platforms for physical goods is crucial. Ideal skills and experience: - Proficiency in WordPress development - Expertise in e-commerce functionality within WordPress - Experience in implementing advanced product customization options - Prior experience in developing e-commerce platforms for physical goods would be ideal.
For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.
I'm in need of a skilled bookkeeper who's proficient in Xero. The ideal candidate will have experience handling a variety of tasks, including: - Invoicing and payments - Expense tracking - Payroll processing I have 2 bank accounts that require reconciliation. The perfect freelancer for this job will have a comprehensive understanding of accounting principles and be able to manage bookkeeping tasks with precision and attention to detail. Please highlight your experience with Xero in your proposal.
I am seeking expert-level assistance in writing a performance review to improve the efficiency of approval of time-card process within the deadline. The current recurrent issue is timecard approvals often not being done on time or missing punches. This severely impacts the operational efficiency, and payroll processing for all the employees and I need a plausible solution to remedy this. Key Requirements: - Introduce measures to prevent frequent delays in approving timecards. - Create reminders for the employees to approve time and make necessary corrections in case of missed punches. - Build a smart reminder system for the employee to review timecards
I need a skilled professional familiar with MS Office for a word processing task, specifically focusing on personal letters. Key responsibilities include: - Processing the content for personal letters. - Ensuring correct grammar, punctuations, and overall coherence. - Working within the style and tone provided for these letters. Ideal applicant would have: - Excellent word processing skills. - A meticulous eye for detail. - Prior experience in drafting and editing personal letters. This project requires the precision and personal touch of an experienced Office specialist who understands the intricacies of personal correspondence.
Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.
