Excel macros 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 นิกส์
I'm urgently looking for a Laravel expert to assist with my project. We're needing support specifically in the backend development, particularly revolving around: - Data Processing: You'll need to have proven skills and experience in handling data storage, retrieval, and manipulation within the Laravel framework. - API Integration: Expertise in integrating third-party APIs into Laravel projects is critical. The job needs to be expedited and I appreciate promptness and dedication to fulfilling the project within a short period. Proven prior experience in similar projects will be a definitive plus. Please include "Laravel Backend Expert" at the start of your proposal to confirm you've read and understood the full requirements.
I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.
...purchases and be compatible with all current Android versions. Key Requirements: - Develop front-end and back-end of the app - Implement in-app purchasing functionality - Ensure the app supports all current Android versions Data Management: - I prefer direct database access for content management - Utilizing third-party services for a more seamless and efficient data processing Ideal Skills: - Proven experience in Android app development - Proficiency in implementing in-app purchases - Strong understanding of both front-end and back-end development - Familiarity with managing data via direct database access and third-party services This project offers a great opportunity for a talented Android app developer to showcase their skills in creating a versatile...
I need an automation program that can handle my textual data entry and processing tasks.
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
...DONE THAT IS THE CONDITION) I need a skilled frontend developer to create basic HTML/CSS pages. You will need to integrate these frontend pages with a Python backend. The project involves adding JavaScript for client-side validation and implementing AJAX page transitions. After pressing the 'save' button on one of the pages, the page should transition to the next. The data inputted should be sent to the Python backend for processing. Key Requirements: - Proficient in HTML, CSS, and JavaScript - Experience with client-side validation and AJAX - Prior work experience that showcases your frontend development skills - Proficiency in Python is a must for the backend implementation Please provide me with your relevant past work when you apply for this project. Would ...
I'm looking for an AWS expert who can set up my profile in Mumbai with 1000 virtual central processing units (vcpus). This highly specific task requires excellent knowledge of Amazon Web Services. Key tasks include: * Setting up EC2 instances specifically optimized for compute. * Ensuring the configuration supports the primary application of machine learning. You should have a deep understanding of AWS, specifically EC2 instances, with a proven track record of setting up compute optimized environments tailored for machine learning. Prior experience with large scale setup (1000+ vcpus) would be a distinct advantage in being successful in this project.
...with big data capabilities, specifically focusing on real-time monitoring and fraud detection. Key Features: - The system should support real-time monitoring of transaction data. - It should have fraud detection capabilities. - Data visualization to aid in tracking and analysis. - Analytics for evaluating transaction patterns and identifying potential issues. - Smooth Data Pipeline with Realtime streaming for efficient data handling. - API integration with third parties to ensure seamless operation. Target Audience: This platform is primarily aimed at banking and financial institutions, as well as e-commerce companies. Preferred Technology Stack: - Java & Python for the core of the platform. - Big Data technologies for processing...
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
... I need assistance in modeling simulation, establishing an effective control system design, and performing signal processing. Key responsibilities: - Build a model simulation - Design a stringent control system - Perform signal processing Although the specific task was not clarified, I value a freelancer who can dynamically adjust to the task at hand. Hence, your application should highlight your past work, experience, and a detailed project proposal–these are essential components to your success in this project. The ideal freelancer should display: - Excellent knowledge of Simulink - Previous experience in model simulation, control system design, and signal processing - Proficiency in MATLAB, and Simulink Blocksets Please ensure to include any releva...
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
...for an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules ...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
...specific set of features to cater to the needs of both the service providers and the clients. Key Features: - User Registration: Allow both service providers (beauty professionals) and customers to create accounts. - Search Functionality: Clients should be able to search for beauty professionals based on their services and availability. - Booking and Payment: Seamless booking and secure payment processing. - Calendar View for Schedule: A clear and organized view of the availability of service providers. - SMS Reminder: Automated reminders to reduce no-shows. - Partial Section for Advertisement: A space for beauty professionals to promote their services. Ideal Skills: - Experience in developing multi-platform applications. - Proficiency in user-friendly design. - Knowledge of se...
...staging site is located at: Desktop: PWA: For the design of our Progressive Web App, we used the OpenTable application as the inspiration. Similar applications that have the same functionality as our sites are: Airbnb Zillow Our application currently has approximately 20 screens and includes payment processing through our own custom gateway. QUALIFICATIONS Minimum 4 Years experience with Mobile App development, with at 2 years of experience with Flutter framework Provide at least THREE (3) live and working Mobile Apps that you have developed using Flutter or React Native Strong familiarity with both iOS and Android development environments, SDKs. Previous experience implementing user authentication
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and enh...
...eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and PowerPoint. - Familiarity with accounting software. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simulta...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 DayA shifts, 1 HfdayA sh...
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I require a proficient WPF developer to design a...developer to design and create a user-friendly desktop application with the functionality and design, on par with that of Visual Studio. My project would need your expertise in: - Data Binding: Connecting the software to a database for efficient processing and managing of information. - UI Design: As Visual Studio served as inspiration, the application must have a clean, intuitive user interface, prioritizing user experience. - Navigation and Control: Implement a logical, coherent system to smoothly navigate around the application. The ideal candidate should have experience developing desktop applications, data visualization tools, and creating user-friendly interfaces, particularly in WPF. Familiarity with Visual St...
...is to develop a Reactive Web App that would help match care-providers with care-seekers (similar to what SitterCity does). We have requirements specs that we can provide to help get started on the project. The App must have web and mobile user authentication, as well as e-commerce integration and social media integration. For the e-commerce aspect, we would need features like checkout, payment processing, billing, etc. The social media integration should include features like logging in using social accounts, etc. We’re looking for in-depth knowledge of Web App development process, someone who can develop efficiently and according to our design specifications. Experience with creating an App with similar functionalities is a major plus. Building must be done with latest tec...
...have a strong background in accounting practices and principles, with a proven track record of handling complex financial records and reports. This position requires precision and the ability to work under tight deadlines. Responsibilities: • Prepare accurate monthly, quarterly, and annual financial statements. • Manage general ledger, accounts receivable, accounts payable, and payroll processing. • Ensure compliance with all federal, state, and local corporate, payroll, and other applicable taxes. • Conduct regular ledger maintenance and comprehensive reconciliation of all accounts. • Assist in the budget preparation and financial forecasting processes. • Provide detailed analyses and explanations of all transactions. • Prepare...
...product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
...from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. ...
Excel Automation of my project and data visualization
...an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will be ...
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...for: Similar Site: - Product Organization: with a clear categorization by product type - Versatile Payment Options: the site must support all payment methods including Credit Card, PayPal, and Bank transfer - Admin Panel: a powerful and convenient admin panel to add or remove products, manage orders, and customer data. Ideal skills required include: expertise in e-commerce website design, understanding of different payment processing systems, and proficiency in building secure admin panels. Prior experience in developing similar websites would be appreciated. The main aim is to provide an easy-to-navigate, secure, hassle-free shopping experience to our customers. Note: I need estimate for design and development for both website and backend admin panel. Website must
...Description: We are seeking a skilled Freelance Full Stack Developer with experience in AI technologies, web development, and data processing to build an automated pipeline for creating AI images. The successful candidate will be responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with exte...
...confidential and protect our identity. Additional Considerations: • : We are aware of tools like that can identify real user IPs versus PROXY IPs. Our solution should withstand such scrutiny. If you have expertise in this domain and can provide a solution meeting these criteria, we invite you to bid on this project. Let’s collaborate to enhance our request processing while safeguarding our privacy and security....
