Vba code rs232 excelงาน
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
สวัสดีครับ ผมกำลังหาคนเขียนโปรเจคเกมส์ออนไลน์ โดยที่ผมมี Source code เกมส์อยู่แล้ว ซึ่งซื้อมาจาก Unity assert store แนว MMORPG (Offline) Link !/content/15552 มี Demo ให้ทดลองเล่นอยู่ครับ โดยความต้องการของผมมีดังนี้ครับ 1. สามารถมองเห็นความเคลื่อนไหวของตัวละครในเกมส์ของผู้อื่นได้ (Animation network) เช่น เดิน , วิ่ง ,เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I am looking for an experienced developer who can use Cython to wrap my existing CUDA code. This is a relatively simple code that is currently used for data analysis. Task: This is done in Linux (ubuntu). I had a old cython code that used to be able to connect with the CUDA code, i think the newer version of CMake changes had made it impossible. I have attached a small reduction of the code, it is pretty much just calling a CUDA kernel from the Python using Cython. The CMake builds, but when the Cython is imported the symbol cannot be found. (to build you need to define an environment variable CUDAHOME points to your nvcc) Steps: 0 (optional) you can Make the cuda code inside to check if it works (1) run (with CUDAHOME env var) (2) run (fail a...
We're seeking a talented 3D artist capable of producing captivating photorealistic renders and videos for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong portfolio sho...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must....
I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP ser...
My main focus for this project is the Java code implementation. I'm looking to hire a freelancer who can create class diagram and help me translate a class diagram into well-crafted Java classes. Key Tasks: -Create diagrams - Translate a modified class diagram into Java classes - Ensure the Java classes are correctly implemented according to the diagram Your responsibilities will include: - Adding products to the rental cart - Calculating rental fees and duration - Processing payment - Generating a rental invoice Your expertise in Java and software design will be crucial for this project. I anticipate that this task will involve a deep understanding of class design as well as an understanding of the rental business process. Please include examples of your previous Java pr...
...embedded C++ source code. The review should encompass the following: - Identification of any potential issues which could result in undesired behaviour - Identify any obvious errors in logical design or use of pointers, arrays etc Lint has already been run on the software - I do not want to see the output of lint! This code has been tested on hardware and performs ok. It controls motors, reads switches, encoders and ADC's, and drives eeprom and digipots. I need a final check to capture any errors or issues that may not be known. I do NOT want any style or general commenting recommendations - the review is ONLY TO IDENTIFY serious issues. I do not want speedup suggestions. This is close to production so any changes *need to be necessary* to improve the quality of ...
I am seeking a talented artist who can translate my wedding vows into 3D morse code and paint them on a large, 31x60 canvas. Since the art will be a unique blend of the abstract and the personal, the ideal freelancer for this job would be someone with experience in both abstract art and coding. The wall art will be the centrepiece of the room, thus, high quality is paramount. The painting should be created in such a way that the canvas can stand alone without the need for a frame. Affinity for detail, creativity and an understanding of morse code are preferred skills for this task.
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...
I am looking for a skilled developer who can help me develop a custom Liquid code editor to be integrated into the Braze platform. This editor should support custom liquid code snippets. I first need someone to troubleshooting existing code and determine why the color displayed is blue Key Responsibilities: - Troubleshooting existing and building new Liquid code in Braze Ideal Skills and Experience: - Proficiency in Liquid programming language - Experience in developing custom code editors - Prior experience with Braze platform - Proficiency in Syntax: {% if ... %} ... {% elsif ... %} ... {% else %} ... {% endif %}: This is the syntax for conditional statements in Liquid.
As someone needing assistance with managing data in an Excel sheet, my ideal freelancer would be highly proficient in Excel and able to work accurately and efficiently. The role includes: - Adding new entries to the Excel sheet including the fields: Name, Email, and Phone number - Updating existing entries with the same data fields - Removing any outdated entries The data should be organized into separate columns for each field for straightforward visibility and access. Besides Excel work, this role involves effective email management related to this data. The ability to multitask while maintaining a sharp eye for detail will be vital for this project. Experience in data management and email handling will be advantageous.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex data set...
I'm looking for an expert in Raspberry Pi programming, ideally with experience in IR code programming. I would like a Raspberry Pi to be programmed to send IR codes (It also needs to capture these codes in the first instance) My setup will be a raspbery PI with the 7" touch screen PI display. I need a front end where I can present countdown timers, once the timer hits zero I need to send an IR signal. If the timer isn't stopped after countdown 1 minute later I need to send two more IR signals. Along with the PI and Screen I will need you to tell me what other hardware I need to purchase to capture and send these IR signals. Their will be only 5 signals in total to capture and these will not change during program operation Key Skills: - Raspberry Pi programming ...
I need an expert who can enhance my existing Java application, which currently translates MATLAB code to X10, to also support C++ as a target language. Key Modifications: - **Update Syntax Translation Rules**: The modification requires a deep understanding of both MATLAB and C++ syntax. The existing rules for translation from MATLAB to X10 need to be adjusted to C++. - **Add Support for C++ Specific Libraries**: The modified application should be able to integrate commonly used C++ libraries seamlessly. Accuracy and Time: - **Accuracy is Key**: The conversion of MATLAB code to C++ needs to be precise. While I'm open to additional development time, the primary goal is to ensure the accuracy of the conversion. - **No Specific Library Requirements**: Though the modific...
I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budget as w...
I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the past.
I'm looking for a talented video editor who can enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling,...not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, this could be an exciting o...
I'm looking for an experienced professional to create engaging and interactive VPAID ads for desktop. Key Requirements: - **Platform**: The ads are specifically targeted for desktop platforms. - **Objectives**: The main goal of these VPAID ads is to increase brand awareness. - **Interactivity**: The ads should have interactive elements, specifically forms to enhance user engagement and drive interactions. Ideal Skills and Experience: - Proven track record in designing and implementing successful VPAID ad campaigns. - Proficiency in creating interactive elements within ads, such as forms, that can drive user engagement. - Strong understanding of desktop ad optimization strategies aimed at boosting brand awareness. If you have the skills and experience in VPAID ad creation, especiall...
I'm having issues with my Helios 2 program, which is written in Python. The primary problem is that it's producing incorrect output. Key Project Details: - Program Type: The codebase is for Helios 2. - Language: The program is coded in Python. - Issue: The primary concern is with the output being incorrect. I need a professional who is adept at debugging in Python to identify the root cause of the problem and subsequently correct it. The ideal freelancer for this job must have: - Extensive experience in Python programming - Strong background in software debugging - Previous experience with large codebases - An understanding of the Helios 2 program or the ability to quickly learn and understand it.
I NEED TO JOB READ Pl...i need to find freelancering job I am Professional and i can do your work goodly im new in freelancer As a photo and videographer with 18 years of experience, I have extensive knowledge of camera settings, lighting techniques, and composition principles. I am proficient in software programs such as Photoshop, Premiere, Davinci, and Lightroom for editing and color grading. I am creative and excel at coming up with unique ideas, and I love working with clients to understand their needs and bring their ideas to life. Communication is key to my work, and I am committed to providing excellent customer service and ensuring that my clients are completely satisfied. I am also highly skilled at time management and always deliver high-quality work on time and with...
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.
For this project, I need an expert well-versed in Excel-based data analysis to conduct statistical analysis, data visualisation, and predictive modelling on a medium-sized dataset comprising of 1,000 - 10,000 records. - Statistical Analysis: Analyze the data to uncover trends, patterns, and correlations. - Data Visualization: Generate intuitive charts, graphs and other visual representations to better understand the data. - Predictive Modeling: Develop predictive models to forecast future trends based on current data. Ideal Skills: - Proficient in Excel for data analysis - Proven experience in statistical analysis and predictive modeling - Excellent data visualization skills - Understanding of handling medium-sized datasets. This analyst should prioritize accuracy, prec...
I'm in need of an Excel expert to help me with intermediate-level spreadsheet formatting. The tasks include moving data from sheet to another sheet Ideal Skills and Experience: - Proficiency in Excel
I need a PowerBI specialist for uninterrupted data extraction, processing, and visualization for our existing business operations. I expect you to be proficient in dealing with CSV files, Microsoft Excel, and Tally, as these are the main data sources in our operation. Core responsibilities will be: - Setting up PowerBI to pull data from these sources - Creating meaningful data visualizations that help us make informed business decisions. While we're not yet sure how frequently we'll need data refreshes in PowerBI, you should be prepared to advise us on best practices based on our data volume and usage trends. Thus, familiarity with handling versatile data flow frequency is a must-have. Experience in similar projects and excellent communication skills will be hugely ben...
