Data input macro excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
เขียนโปรเเกรม Sudoku ที่สามารถเเก้โจทย์ Sudoku ที่ user inputโดยไม่ใช้ library ที่เกี่ยวกับ constraint(CLD(FD) library) เขียนโดย backtracking เเละเชื่อมกับ UI โดยใช้ python
...สามารถ 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...
1) ชุดควบคุม ที่รับข้อมูลจากเซ็นเซอร์ 1-6 input แล้ว นำข้อมูลมาประมวลผล และสั่งการ ทั้งแบบ PID และ Relays output 2) จาก 1st stage พัฒนาต่อยอด เป็น IOT on desktop and Mobile.
ทำ 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 ที่กำหนดให้
...ที่อยู่ในขอบเขตการพัฒนา Donors • View Organizations - Display story and donation method selection • Donation Status - Display result of the payment from Payment Gateway, Direct Transfer, or Rabbit Line Payment • List Donation Transactions - Search for all the donation transactions based on the input from donors like citizen id, full name, and mobile number Administrators • Manage Organizations - List all organization that were registered so far and can be filtered by some information • Register Organizations - Input form to register new organizations • Update Organizations - Update form to modify some information about registered organizations • Remove Organizations - A confirmation page to delete an organization • Vie...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ต้องการให้พัฒนา ระบบฟังภาษาไทยผ่าน php โดยเมื่อฟังคำที่เป็นคำสั่ง เช่น เปิดไฟ ให้ไปสั่ง function php ให้ทำงานต่อ ทางผมมี function อยู่แล้ว ขาดส่วนที่รับ input เป็นเสียงเพื่อไป trigger ให้ function ที่เตรียมไว้ได้ทำงานต่อ
ต้องการให้พัฒนา ระบบฟังภาษาไทยผ่าน php โดยเมื่อฟังคำที่เป็นคำสั่ง เช่น เปิดไฟ ให้ไปสั่ง function php ให้ทำงานต่อ ทางผมมี function อยู่แล้ว ขาดส่วนที่รับ input เป็นเสียงเพื่อไป trigger ให้ function ที่เตรียมไว้ได้ทำงานต่อ
...that can crawl through a list of websites provided in an Excel file and export all the webpages it finds into a new Excel file. This task is aimed at scraping the entire content of the websites, not just a specific piece of information. Key Requirements: - The script must be able to read a list of websites from an Excel file. - The script should use natural crawling mechanisms, not sitemap, to find all the webpages on each website. - All the webpages found on the websites should be exported into a new Excel file. The purpose of this script is to aid in analyzing the content of these websites, so it's crucial that all pages are scraped. Ideal Skills: - Proficiency in Python programming, particularly web scraping. - Knowledge of Excel file handl...
...Responsible for connecting to the IP camera over the RTSP protocol using the rtspsrc element. Once connected the pipeline needs to prepare the stream for consumption by lower pipelines as below. Segment Pipeline Take the input stream and output HLS segment files which will be persisted to disk over NFS. It is important to note that we need a hook so that when the files are written we can send a notification message over the message broker announcing the segment file size, name, etc. Transcode Pipeline This child pipeline, when activated, is responsible for transcoding the input H.265 stream to H.264 to prepare it to be consumed over WebRTC. Requirements Solution must be implemented using golang. Solution must use the go-gst library for accessing gstreamer bindings. Co...
I require an expert in Excel to build a comprehensive tracking file. This task involves: - Establishing a data entry form to easily input inventory and project progress details. Knowledge of creating user-friendly interfaces within Excel is beneficial. - Implementing automated calculations to streamline the data analysis process. Strong mathematical and analytical skills are essential. - Creating a graphical representation of data to facilitate understanding. Experience in data visualization is a must. The spreadsheet will track fewer than 10 types of inventory data and project progress data. Your familiarity with inventory management processes and project tracking would be highly valuable. This assignment calls for you to u...
I am looking to streamline my excel data entry process. Needs centralized on the automation of numerical data entry in my Excel spreadsheets. Key requirements: - Automate simple data entry into few columns. - Experience with Excel data entry automation required. - Should have good knowledge of Excel functionalities and automations. - Ability to handle numerical data efficiently. Experience in handling simple data entry (few columns) and automating the same would be ideal for this job. Reach out if you need more information and looking forward to your expert assistance in this process improvement.
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
I'm looking for an experienced developer to create a seamless connection between a professional and corporate-designed front e...for an experienced developer to create a seamless connection between a professional and corporate-designed front end interface and our existing Django back-end. The required functionality includes: - User registration and login - Data input and submission forms - Interactive data visualization Ideal skills for this project include: - Strong knowledge of Django and its integration with front-end technologies - Experience in designing and implementing professional and corporate user interfaces - Expertise in user registration, data input forms, and interactive data visualization - Ability to ensure smooth communicat...
I'm in search of a meticulous data entry specialist to assist with my Excel-related work. Key responsibilities: - Data entry: The work pertains to entering simple, text-based data into Excel sheets. - Data sourcing: This role requires you to source the data before entry. Ideal skills for this project: - Proficiency in Excel: A strong grasp of Excel functions and formulas is a must. - Data entry experience: Previous experience with data entry, especially in Excel, is preferred. - Research skills: A knack for sourcing data efficiently and accurately.
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I need a proficient Excel user to create a workbook for my multiservice business. What I Require: - The ability to record both cash, check and card income, as well as expenditure for each. This tool needs to be able to accommodate and separate these different transactions for easy access and clarity. Desired Features: - It should automatically calculate the daily and monthly income for each category. - Must also offer a daily and monthly balance for cash flow. Skills & Experience: - Strong Excel skills are a necessity. - Ideally, the freelancer should have experience with creating business financial sheets. Timeline: - I'd like this project completed as soon as possible. Urgency is key.
I am looking for an exceptional web developer who can create an informational website aimed at the general public. I have all the necessary content available, and I need someone who can perfectly input this content into a sleek, easy-to-navigate design that will engage and inform users. Ideally, looking for someone to create a wordpress website. Ideal skills and experience: * Proficient in HTML, CSS, JavaScript or relevant programming languages * Experience in designing and developing websites with a clear and engaging interface * Strong comprehension of UI/UX design, making sure the website is user-friendly for the general public * Proven track record in efficient project delivery * Ability to adhere strictly to my branding and design guidelines. Lastly, I need you to make the...
I'm seeking a talented graphic designer to create a realistic silhouette of a human figure for my logo. Given the nature of my brand, this silhouette should embody a universally appealing aesthetic while maintaining the identifiable form of a human figure. INCLUDE THE GOLF CLUB. I would also like to have a version of the outline of the human figure on...creating realistic silhouette designs, particularly focused on human figures. - Proficiency in a variety of digital design tools - A creative eye that can contribute fresh and innovative ideas - The ability to work collaboratively and receptive to feedback Please note that the desired emotion or feeling the silhouette should evoke was not specified, leaving room for creativity. Your expertise and input will be highly valued ...
I am in need of someone with substantial Google Ads experience to launch and run two ad campaigns for me. Unfortunately, I haven't defined the goals, target demographics, or specific budget for these campaigns yet. Therefore, the chosen freelancer needs to have: - Proficiency in developing a strategy for Google Ads. - Solid under...chosen freelancer needs to have: - Proficiency in developing a strategy for Google Ads. - Solid understanding of goal setting for ad campaigns, namely in increasing website traffic, lead generation, and brand awareness. - Ability to advise on target demographics setting, including age group, gender, and geographical location. - Experience in managing ad campaigns for varying budgets. Your input in these areas is critical to the success of thes...
Wrong data is show in the report. Need to link the correct input to the report. Work with ftp only
I'm in need of a freelancer who can assist me with the styling and formatting of an Excel spreadsheet. Your task will primarily involve applying cell style formatting. Specifically, I'm requiring assistance with: - Implementing cell style formatting. Please note that while the exact type of cell styles are not defined yet, I will be able to provide more details and guidance once the project begins. Ideal skills for this job would include: - Proficiency in Microsoft Excel - Previous experience with complex Excel formatting - Ability to work independently and on deadline Please, in your bid, include examples of any similar jobs you've completed.
As the project owner, I require an Arduino Uno code, specifically designed to interact with a fingerprint reader for input, LCD and 14 relays for output. Key Requirements: - The code should identify 14 people's fingerprints (let's say 2 different fingerprints for each person), write the name of that person on the LCD and activate the corresponding relay for each person. - The associated relays will control a particular robotic device. - When an unrecognized fingerprint is scanned, the system should write on LCD "unrecognized fingerprint" without triggering any relay. Ideal Skills and Experience: - Proficiency with Arduino programming - Experience working with fingerprint readers - Knowledge of relay and robotic systems . Familiarity with sensor integrations ...
I need a database where we can store our sales transactions. The database will be manually updated by our staff. I would also like to have reports generated on our sales. Key Requirements: - Develop a database to store sales transactions - Enable manual data entry by staff - Implement a reporting system that can generate sales reports Ideal Skills: - Proficiency in database development - Experience with manual data input systems - Ability to create custom reporting features Please provide examples of previous similar projects you've worked on.
I'm looking for an Azure professional who can help me set up an Azure cloud solution to host my Excel data. The project involves: - Hosting Excel Data: I will provide you with an Excel file, which I would like hosted on Microsoft Azure. The data in this file will not be updated frequently, just once for now. - Web Application: I would like the Excel data to be accessed through a web application. This means you will need to set up a simple, user-friendly interface for viewing and possibly manipulating the data. Ideal Skills: - Experience with Microsoft Azure, particularly in hosting data. - Proficiency in setting up web applications. Please get in touch if you have the right expertise, and we can discuss the pr...
I am seeking a detail-oriented freelancer to input text and numerical data into 3 small Excel spreadsheets, containing 1 column each. 2 spreadsheets for emails, one called Minnesota, one called Midwest. 1 spreadsheet of inventory numbers. See attached. Only emails are needed. Inventory is on yellow paper Ideal Skills: - Proficient in Excel - Attention to detail - Knowledge of data organization and management Highlight the entries that you are not sure of, or the handwriting is to difficult to read. English fluency in a must.
The task centers around leveraging Python programming and machine learning skills to perform data analysis. The data to be analyzed are contained in an Excel sheet, specifically focusing on customer data. The ideal freelancer for this task should exhibit the following: - Strong proficiency in Python programming. - Solid experience with machine learning. - Familiarity with data analysis, particularly descriptive analysis. - Ability to accurately interpret customer data. The task requires a reading of the Excel sheet and performing data analysis based on the customer data contained within. The chosen Python and machine learning expert will focus on descriptive analysis techniques to extract meaningful insights. Your insights sh...
I'm in need of an experienced PowerShell script writer, specifically for Power BI associated data management tasks. As part of the project, code will be required to execute the following tasks: - Data extraction from Excel files, CSV files, and SQL databases - Transformation of data, including extraction and update of parameter values from Data Models in each Workspace Ideally, the freelancer would carry a strong understanding and hands-on experience with PowerShell scripting, Power BI, data transformation techniques, and working with database source files like Excel, CSV, and SQL formats.
Hello, I have 6 simple contact web forms that I would like recorded into a single matrix. The goal is to see the field alignment and comparison between the form data.
I'm seeking an expert data analyst specializing in financial data analysis for real estate development projects. The focus will be on the financial aspects of our upcoming construction project, specifically concerning future projections for the next 10 years. Candidates should be competent in: - Creating custom excel/ google sheet template - Forecasting Capital Expenditure - Predicting Cash Flow - Delivering revenue Projections Your role will involve analyzing, interpreting, and providing insights on these aspects. Proficiency in financial modeling and forecasting is a must. Knowledge about the construction sector will be highly regarded, and prior experience in real estate development is a bonus. To make informed decisions, we're relying on accurate and...
...to rent residential and commercial spaces in Malta. The latter includes people interested in renting commercial properties such as offices, restaurants, and shops. - Marketing Channels: The ideal candidate should have expertise in using various marketing channels to attract potential clients. This includes proficiency in leveraging social media platforms, email marketing, and marketplaces. Your input and suggestions for additional channels are also welcome. The successful freelancer will need to: - Have a good grasp of lead generation strategies, particularly in the real estate sector - Be able to tailor the approach to attract different types of clients (investors, homebuyers, renters) - Demonstrate creativity in using various marketing channels to reach the target audience ...
...integrated voltage regulation. This project requires expertise in high-power applications, voltage regulation, and serial communications. Project Requirements: Microcontroller: RP2040 chip to manage all operations. Power Handling: Board must handle input of 24V. Voltage Regulation: Conversion of 24V input to 12V and 5V outputs. MOSFETs: 5 MOSFETs for 24V, 7A control. 4 MOSFETs for 12V, 5A control. Communication: USB Type-C for robust serial communication. Inputs and Outputs: 2 analog inputs. 1 One Wire communication interface. Additional pins for digital input/output as required. Deliverables: Complete PCB design files ready for manufacturing, including gerber files. Schematic capturing and PCB layout. BOM (Bill of Materials) with sourcing options. Documentation ...
