Excel vba data miningงาน
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...
สวัสดีค่ะ รบกวนสอบถามหน่อยนะคะ พอดีจะให้ช่วยวิเคราะห์งานเพิ่มเติมหน่อยนะคะ แต่ทำในส่วน code python ไปบ้างแล้วนะคะ
ทำ 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
I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos)
I have a level sensor which is currently sending data to a local Wi-Fi network, accessible through a web browser using the sensor's IP. I'm seeking assistance to automate this process and have the following requirements: 1. Data Fetching: The sensor is measuring liquid levels. This specific information needs to be fetched and transferred directly to an Excel sheet. 2. Data Update Frequency: The data should refresh in the Excel sheet every minute. 3. End Goal: The collected data will be used to generate a chart in Excel. Ideal skills for this project would include extensive experience with automation, proficiency in Excel, and understanding of level sensor operations. Knowledge of networking would be a plus. Are yo...
I'm seeking a proficient developer to build a user authentication and authorization system using JS, Node.js, and MySQL. The core function of this project will be role-based access control. Key Features: - Role-based access control system: The system should be able to accommodate three different roles - Admin, User, and Guest, each with different permissions. Ideal Skill...sent to the relevant address based on the campaign. • I have a list of ASM email addresses from a Company. I'd like to trigger emails to each of the ASMs on the list. (Campaign wise)" 8. Download Reports: • Include Camp Details Entry Date: This option focuses on the purpose of having the date - to track when the camp details were entered. • To select Date Range • To Select HQ Wise ...
...little hearing loss Key responsibilities will involve: -Building SMARTSHEET plans -- Linking to External data (i.e. Excel) that will be used in updating the SMARTSHEET plans. - Utilizing SMARTSHEET Functions: Proficient use of formulas and calculations is essential for this project. - Building Reports and Dashboards: Experience in creating comprehensive and visually appealing reports and dashboards is necessary. The primary goal for this project is to efficiently and accurately track the progress of different projects within the Smartsheet and create Dashboards for multiple audiences. Ideal candidates should have: - Expertise in Smartsheet - linking Smartsheet plans to external data - Linking Multiple Smartsheet project plans that share tassks - Proficiency in...
*** US CANDIDATES ON...background to manage various tasks. Key Responsibilities: - Budgeting: You'll be responsible for creating and monitoring budgets to ensure financial health. - Expense Tracking: Accurately log and keep track of expenses to maintain a clear financial picture. - Invoicing: Prepare and send invoices to vendors and clients in a timely manner. Your Experience: - Proficiency in Excel: Since I currently handle finance using Excel, it is essential that you are comfortable with this software. - Previous Finance Management: Experience in budgeting, expense tracking, and invoicing is a must. - Strong Communication: Being able to keep me updated and informed on financial matters is key. Please highlight your relevant experience and how you can support me in ...
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
I'm looking for an expert in Excel to build a comprehensive 'Team Scorecard' for my team. This sheet will be used to track a range of tasks and behaviors to ensure the team is performing at their best. Key Features: - The project involves tracking various tasks and behaviors including daily reports, client communication, social media postings, timekeeping, invoicing, and meeting attendance. - I need the sheet to calculate total and average points automatically. This will be based on the tasks completed and the quality of those tasks. - It should also include conditional formatting to highlight outstanding performances. This will help us recognize and reward exceptional work. - Data validation is important to ensure accuracy and consistency in point entries. ...
I'm looking for a skilled professional to create a comprehensive database ( 10,000 to 20,000) of Non-Resident Indians (NRI) wo...promotions for my existing business. Key Elements Needed: - Name - Email - Mobile - Company Name (if available) - Country of Residence or Work Data Collection Methods: - Online Surveys - Social Media Platforms - Public Records Skills and Experience Needed: - Experience in data collection and database creation - Proficiency in using online survey tools - Familiarity with social media data mining - Ability to identify and use relevant public records - Attention to detail to ensure accuracy of collected data - Understanding of the NRI demographic is a plus The ideal candidate for this project should have a track record of ...
I'm in need of an experienced sales agent who will work as a representative for my travel consulting services, focusing on individual clients. Key Responsibilities: - Promoting and selling my consulting services - Establishing new relationships with indiv...for my travel consulting services, focusing on individual clients. Key Responsibilities: - Promoting and selling my consulting services - Establishing new relationships with individual clients - Providing expert advice on travel solutions You're a great fit if you: - From Taiwan - Have prior experience in sales, especially in the field of consulting - Understand the travel solutions market - Excel at building customer relationships over diverse clientele. I look forward to boosting my travel consultancy service s...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I am looking for an experienced Scala developer to implement a specific functionality in a data processing environment. The aim is to process text data more efficiently. Key Requirements: - Deep knowledge of Scala and spark - Proven experience in data processing, notably with excel, json and text data - Ability to deliver clean and efficient code The ideal candidate should be able to show previous projects where they successfully implemented or improved similar functionalities.
I need an expert to conduct a color analysis on an apparel website. Your task involves studying product images and employing Adobe Illustrator's eye dropper tool to identify the hexcodes for each. Main objectives include: - Identifying hexcodes for main colors using Adobe Illustrator - Organizing the hexcodes by clothing type - Completing the provided Excel Sheet Your role is critical as the information will be utilized in color trend analysis for apparel. Therefore, a proven background in graphic design, color profiling, knowledge of Adobe Illustrator and an eye for fashion would be ideal. My budget for this project is 100 USD. Please, proficient users of the English language only for accurate communication.
...an online system to replace the use of Excel sheets for data storage and calculations. The system will need to have: - Data Entry and Storage: It should be able to handle both numerical and textual data effectively and efficiently. - Automated Calculations: The system should be designed to automatically handle basic calculations such as summations and subtractions. To ensure the system is user-friendly and can handle our basic data management needs, you must have a solid understanding of relational databases and be proficient in web application development. Experience in designing systems with automated calculations is a big plus. A keen eye for user experience and the ability to follow design guidelines is also appreciated. We have an example e...
...material usage, stock alerts, etc. 10. **Stock Alerts:** - Implement stock alert mechanisms to notify users when inventory levels fall below a certain threshold. - Alerts can be sent via email, SMS, or displayed within the software dashboard. This software solution would require a database backend to store all relevant data and a user-friendly interface for easy interaction. You could develop it using Microsoft Access, incorporating forms, queries, reports, and VBA (Visual Basic for Applications) for automation and customization. Consider consulting with stakeholders and users throughout the development process to ensure the software meets their specific needs and requirements. Additionally, thorough testing and refinement will be crucial to ensure the software ...
Para crear un documento de Excel con macros, la persona que lo va a desarrollar necesitará conocer varios aspectos: Conocimientos básicos de Excel: Deben estar familiarizados con las funciones básicas de Excel, como la creación de hojas de cálculo, el formato de celdas, la creación de fórmulas, etc. Macros en Excel: Deben comprender qué son las macros en Excel y cómo funcionan. Esto incluye la capacidad de grabar y editar macros, así como comprender el lenguaje de programación VBA (Visual Basic for Applications) utilizado para escribir y modificar código de macros. Requisitos del documento: Deben comprender claramente los requisitos y objetivos del documento de ...
Hola .Necesitaria extraer un excell y que se me guardara en una carpeta todos los días . El excell se encuentra en un programa llamado Mulsesoft
...persist until acknowledged Crafting a user-friendly web admin panel for app management Using cloud functions to create an HTTP endpoint for JSON data reception Developing a device management page, including adding devices, assigning properties, and linking them to client profiles Creating and managing client and user profiles, including assigning users to clients or groups In essence, the app should allow for the creation of client profiles with customizable fields. JSON data received from devices in alarm states should be stored in Firebase, linked to client profiles via device ID, and trigger alarm notifications on the user's app until acknowledged. To excel in this project, you should possess: Strong proficiency in Firebase and Flutterflow, along with clou...
I require a professional web scraper to collect both text (data points) and images from a long list of web pages about hotels and destinations. - The project involves saving the actual images of destinations/hotels —not just their URLs—from every webpage. - As for the text content, I'm particularly interested in several points - The extracted data and saved images should be meticulously organized in an Excel sheet for easy review and reference. Ideally, I'm seeking someone with an extensive background in web scraping and data extraction. Being proficient in Excel would be a significant plus. Accuracy, attention to details, and reliability are also crucial traits for this task.
I'm seeking a data mining expert to rework my project's problem statement, craft novel project objectives, and link the methodology with a literature review. I'm primarily focusing on Stacking classifier and Hybrid stacking models. The ideal candidate should have a strong background in these models to help develop a completely new approach for my project. Key requirements for this role include: - Expertise in classification models, especially Stacking classifier and Hybrid stacking - Strong experience in data mining and methodology development - Proven track record of combining insights from multiple studies - Ability to write a comprehensive literature review and identify gaps in existing studies Your role will be crucial in not only improvin...
...count reports…..cost incurred report…. Weekly Duty roster template/ or default values for a duty, these defaults can be changed.…..fixed duties with fixed employees…this helps the manager to enter the data quickly…. Restaurant duties are different – there will be 4 shifts. And 3 halls. Each hall has maximum number of duties…..waiters need to assigned to those duties….and cleaning boys need to be assigned to cleaning duties…..see the “Floor Staff” sheet in the attached excel file. Summary report for floor staff….with total man hours, ots etc….refer the “Floor Staff” sheet in the attached excel file. Need to send sms to present employees and owner on submitting the duty...
I need a sophisticated Excel spreadsheet designed and developed for tracking key performance aspects of my dumper truck and excavator rental company. The spreadsheet needs to be well-organized, easy to navigate, and detail-oriented, focusing on the following elements: - Expenses: Detailed tracking of an array of expenses. The ability to enter itemized costs is a must, and other daily expenses (office, car fuel..). Also monthly expenses like rent, salaries, bonuses and truck or excavator maintenance ect. - Income: This should include a breakdown of different revenue sources. - Employee tracking: A system to input and manage each employee's work hours. - Machine rental: Documentation of the equipment rented, including the duration of rental. - Fuel consumption: Dedicated sectio...
I'm in need of a highly skill...effectively is crucial. -Relevance ranking: The system should be capable of ranking search results based on their relevance to the search query. -Personalized recommendations: The ultimate goal is to personalize user experience, thus the engine should be capable of generating recommendations based on user behavior and preferences. In terms of data sourcing, the AI engine should primarily draw information from databases. A background in data mining and database management would therefore be advantageous. Proven experience in AI, machine learning, and natural language processing is a must-have. Understanding of UX design to foster user-friendly interactions is also highly desirable. If you have relevant skills and experience...
I'm looking for a freelancer who can build a dynamic Excel line chart that tracks and compares the performance of two teams over time. - **Metrics:** The chart should reflect team scores. - **Updates:** I need the chart updated within a 10-hour timeframe, to capture the latest performance data. Ideal Skills: - Proficiency in Excel and creating dynamic charts. - Understanding of data visualization and performance tracking. - Ability to automate data updates for real-time reporting.
I'm looking for a skilled Excel expert who can help me create a comprehensive food costing spreadsheet. In particular, I would like the following sections: - **Ingredients Cost**: where I can enter the prices of all the ingredients I use in my recipes. - **Recipe Costing**: a section where I can input my recipes and the spreadsheet automatically calculates the total cost of each recipe based on the ingredients. - **Menu Pricing**: a feature where I can input the recipes from my menu and the spreadsheet automatically calculates a profitable price based on the recipe costs. - Inventory management: - **Track Inventory Levels**: a feature that keeps an eye on my ingredient stock levels. - **Predict Future Inventory Needs**: an analysis that could help me foresee when I&#...
Hi. I need help to setup the binding for a RichTextBox .NET Control so that data is retained. There may be use of VBA that is needed. This is within a FactoryTalk View SE version 14 application. I don't know .NET or VBA, I am a FactoryTalk guy though. Example use case: Lets say a factory has 100 valves. If a user opens popup for Valve #3, I need a text box field in that popup for the user to enter data, and then data is preserved/saved. That popup should be one common FTV display that references the Valve_# that was selected (using parameter files, or...). This example is the main objective. I need a simple and easy solution to this, and I need to understand how to do it myself afterwards. This is perhaps a 1 hour job. My name is Marc....
Project entails designing PCB layouts for Cryptocurrency Miner PCB Design using ASIC chips for cryptocurrency mining. Deliverables consist solely of comprehensive PCB design files, ensuring reliability, accuracy, and meticulous attention to detail.
...that can convert a Marathi excel sheet to English. The application should have the following features and capabilities: - Upload functionality: Users should be able to upload Marathi excel sheets into the application. - Conversion: The application should accurately convert the Marathi data (including names, addresses, phone numbers, gender) to English without any loss of information. - Download functionality: The application should allow users to download the converted English excel sheet. - Volume handling: The Marathi excel sheets may contain around 2000 records, so the application needs to handle this volume efficiently. Ideal skills and experience for this job would include: - Strong proficiency in PHP and web application development. - Experien...
...and enhance overall quality. - Video Call Backgrounds: Design custom backgrounds for video calls that reflect our corporate identity. - Word Templates and Project Proposals: Create templates for documents and proposals that are user-friendly and visually aligned with our brand. - PowerPoint Templates: Design templates for presentations that are both professional and creative. - Invoice Templates (Excel): Develop invoice templates that are clear, professional, and include custom fields as per our requirements. - Social Media Profile and Cover Photos: Design attractive profile and cover images for our social media that maintain visual coherence. - Corporate Email Signature Design: Create an email signature that elegantly incorporates our logo and contact details. - Corporate Mug De...
...material is in Excel format and contains over 10,000 words. Ideal Skills and Expertise: - Fluent in both English and German - Proven experience in translation, particularly related to technical or software content - Proficient in working with Excel files Please note that the translation must be accurate and precise to ensure that the technical terms are properly translated. Your familiarity with accounting and POS software terminology is highly desirable. The software is up to 90% translated, we need translator for correction and addition. ......................... Ich suche einen erfahrenen Übersetzer, um einen großen Umfang an Inhalten von Arabisch ins Deutsche zu übersetzen. Die Inhalte beziehen sich auf Buchhaltung und POS-Software. Das Ausgangsmate...
Recopilar información de indicadores de turismo y su disponibilidad en la red. Trabajo de documentación y búsqueda.
