Optimization excel calculation vbaงาน
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
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Writing Particle Swarm Optimization (PSO) by Matlab in Helicopter Routing for Solving High Voltage Transmission Line Inspection. This thesis want to be saved cost and distance of inspect the High Voltage and complex condition (Master's Degree) ต้องการผู้ที่สามารถเขียน PSO Particle Swarm Optimization ในโปรแกรม Matlab ได้ โดยโปรเจคนี้จะเป็นการกาต้นทุนและเส้นทางที่น้อยที่สุดในการตรวจสอบเส้นสายไฟฟ้าแรงสูง ภายใต้ เงื่อนไขที่ซับซ้อน (เป็นงานวิจัยระดับปริญญาโท)
I'm looking for a skilled individual to assist me in optimizing my LinkedIn profile and ultimately helping me to land a sales role. Key Responsibilities: - Optimize my LinkedIn profile content to align with my target industry - Sales. - Enhance the visibility of my profile on the platform. - Develop a networking strategy that will ...me to land a sales role. Key Responsibilities: - Optimize my LinkedIn profile content to align with my target industry - Sales. - Enhance the visibility of my profile on the platform. - Develop a networking strategy that will assist me in my job search. The ideal candidate should: - Have a strong background in sales or recruiting within the sales domain. - Be proficient in LinkedIn profile optimization. - Demonstrate a good understanding of netw...
...Google. This role is crucial as it directly impacts the site's performance and visibility. The ideal candidate should be proficient in WordPress and capable of making necessary changes to the site. I require assistance in identifying the most relevant keywords and incorporating them effectively to improve my site's ranking. Key Responsibilities: - On-Page SEO - Keyword research and suggestions - Optimization of website elements based on keywords - Website maintenance and changes - Optimize Google Business Profile Ideal Qualifications: - Solid experience in on-page SEO for WordPress sites - Proven track record of enhancing website visibility - Proficiency in working with Google and Bing search engines - Experience in keyword research and application Please include det...
I am in need of an expert who can assist me with the customization and setup of Microsoft Office applications. Key responsibilities: - Ass...applications. Key responsibilities: - Assessing my requirements and suggesting the best ways to customize the Microsoft Office software. - Configuring the settings and options of the software to meet my specific needs. - Providing step-by-step guidance to help me understand and use the customized features efficiently. Ideal Skills and Experience: - Proficient in Microsoft Office Suite (Word, Excel, Outlook). - Experience in customizing and setting up Microsoft Office applications for various purposes. - Excellent communication skills to explain technical information in a clear and understandable manner. Your assistance would be greatly ap...
hello Currently, AWS-related consultation is needed. Also, we are looking for someone who can connect to AWS (build a server). We are looking for someone who can perform AWS-related tasks such as SSL, server management, backup settings, cost optimization, etc. My current budget is around $10-$20. Please write "awsp" in chat or in the proposal to help determine whether bots are verified.
I require a clean and professional logo for my project management consulting business, Let’s Sort This Out, LLC. There isn't any specific imagery I am tried to, perhaps incorporate a pen, clipboard or excel style doc - I am 100% open to creative suggestions! Ideal designers will be experienced in corporate branding and able to present a portfolio of similar work.
I'm in a rush and need a skilled designe...detailed design phase. I need you to take concepts and transform them into detailed plans, elevations, and sections. There's a deadline to be mindful of, as the completion is needed as soon as possible. Key responsibilities include: - Translating architectural concepts into detailed designs - Creating detailed plans, elevations, and sections - Ensuring the design meets all necessary standards To excel in this project, you should have: - Proficiency in AutoCAD and 3D Max - A deep understanding of architectural design principles - Experience in detailed architectural design - The ability to work efficiently under pressure and meet tight deadlines If you're confident in your skills and can deliver high-quality work quickly, I...
I'm looking for an SEO expert who can help me significantly improve my website's performance in terms of organic traffic, search engine rankings, and keyword optimization. Key Goals: - Increase organic traffic: I want a huge boost of the number of visitors coming to my website through organic search. - Improve search engine rankings: I need my website to rank higher in search engine results pages, particularly for keywords relevant to my business. I want to make use of web hooks. - Optimize website for keywords: I require a comprehensive keyword strategy that will help my site rank for the most relevant terms. Target Audience and Location: - Local, National, International: My target audience is quite broad, encompassing customers from different geographical locations. T...
I need a solution to bulk add unknown contacts to a Whatsapp group. The contacts to be added will be provided in an Excel or CSV file. The task must automatically add these contacts to the group; however, there is no need to save them to my phone's address book. Ideal candidate for this project should have: - Experience with WhatsApp's API and group management - Proficiency in working with Excel or CSV files - Ability to automate adding of multiple contacts
I'm seeking an experienced email marketer to handle my email campaigns. Key Responsibilities: - Develop and execute email marketing strategies - Create engaging email content for specific target audiences - Analyze campaign performance and optimize for success Ideal Candidate: - Proficie...- Develop and execute email marketing strategies - Create engaging email content for specific target audiences - Analyze campaign performance and optimize for success Ideal Candidate: - Proficient in email marketing tools and platforms like Mailchimp, Constant Contact, and SendinBlue - Experienced in creating effective email campaigns - Data-driven, with a focus on performance analysis and optimization Please submit your proposal with relevant experience and examples of past successful e...
I need an Android or PC based application for creating quotations, generating invoices, and tax receipts. It should support offline functionality, with essential features available without an internet connection. Key Features: - Creating Quotations: The app should allow users to create comprehensive and customizable quotations, including options to choose profile, colour, glass, mosquito netting, etc. - Generating Invoices: Users should be able to conveniently generate invoices based on the created quotations. - Generating Tax Receipts: The app should also support the generation of tax receipts. Additional Requirements: - Save as PDF: The ability to save these documents in a PDF format is essential. - Customer Data: The app should maintain a database of customer information. - Edit Old ...
I am on the hunt for a specialist who is knowledgeable and skilled in wireless communication and operation research. For this particular project, you will be req...Background in operation research would give you a substantial edge. 3. **Outcome of the Project**: Ultimately, the effort you invest in implementing the algorithm and creating the mathematical model needs to result in the optimization of the system. The perfect candidate for this project is well-versed in wireless communication, particularly cellular technology. Practical experience in operation research, algorithm implementation, and mathematical model creation is also crucial for the success of the project. Efficient problem-solving skills, a knack for optimization, and a strong mathematical foundation are e...
I need a professional SEO expert to optimize my website in order to improve our search engine rankings on Google. - The main goal for the project is to increase organic traffic and visibility on Googl...rankings on Google. - The main goal for the project is to increase organic traffic and visibility on Google. - I have a list of specific keywords and phrases that I would like to target. - The work is urgent, so quick and effective execution is essential. Ideal Skills and Experience: - Proven track record of successful SEO projects, especially on Google - Expertise in keyword research and optimization - Ability to implement and execute strategies quickly, with a focus on achieving results in a timely manner. Please include any relevant past projects or case studies in your ap...
...my B2C website. Key Responsibilities: - Conduct a thorough website optimization to ensure it's search engine friendly and user-friendly, with a focus on conversion optimization. - Develop and implement creative and effective social media marketing strategies that resonate with my target audience. - Create and execute a content marketing plan that will help drive organic traffic to the site. Ideal Candidate: - Proven experience in website optimization, with a track record of increasing organic traffic and improving conversion rates. - Expertise in B2C digital marketing, particularly in the areas of social media and content marketing. - Proficiency in SEO tools and strategies. - Understanding of conversion rate optimization techniques. - Excellent commu...
I am in need of a skilled professional in Lambda and Python to assist with the configuration of my Lambda function, optimize my Python code, and help me debug errors. Key tasks: - **Lambda Function Configuration:** I need help setting up my Lambda function correctly. - **Python Code Optimization:** I am using Python 3.x and require someone to optimize my code. - **Error Debugging:** I need assistance in finding and resolving errors in my Lambda function. Ideal candidate should: - Have prior experience with Lambda and Python. - Be comfortable working with Python 3.x. - Be adept at debugging and optimizing code. - Demonstrate strong problem-solving skills.
...extensive experience in: - Building and maintaining large-scale social media platforms - Implementing complex user permission systems - Working with real-time data handling, crucial for a dynamic user experience - Integrating a wide range of third-party services Standouts will demonstrate: - Proven track record with React.js & - Creative problem-solving skills - Efficient performance optimization in large projects - Strong communication for collaborative development Mandatory; - React.js - GraphQL - - Team collaboration - Strong understanding of front-end development - You work 45 hours per week by sharing your screen during your shift - weekend available - You work on monthly basis incoms "no upfront" - You work on UTC time Please apply with your relevant ex...
I need to perform an analysis of a webpage that includes: - Pricing Landing Page Analysis: Conduct a CRO analysis. Provide an analysis of how these areas currently impact user behavior and suggest strategies for improvement. - Create simple user personas - Identify two competitors and list strength and weaknesses
This blog will be addressed to women and men and will aim to inform and raise awareness around a specific health issue, potentially promoting healthy lifestyles and wellness and creating a community of people who face the same problems and have the same concerns.
I'm in need of a skilled professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used...professional who can scrape data from Google. The project requires the extraction of names and email addresses for specific profiles to be used as a potential leads database. Upon successful extraction, the data needs to be presented in an Excel spreadsheet, CSV, etc. Ideal Skills and Experience: - Proven experience in data extraction from websites - Proficiency in Excel - Strong attention to detail and accuracy - Experience in extracting usernames and emails is a plus Deliverables: - The extracted Data - The data must be clean, organized, and formatted in an Excel spreadsheet I look forward...
I'm looking for an experienced financial analyst with expert-level MS Excel skills to provide a comprehensive understanding of the data and help build a comprehensive energy financial model. Key Deliverables: - Explanation of Cash flow projections - Explanation of ROI calculations - Explanation of Sensitivity analysis - Explanation of 5-year financial projection - Explanation of Manufacturing Financial Feasibility Modeling Data Inputs: - Revenue projections - Cost projections - Investment costs - Tax rates Inflation Handling: - Inflation should be included in the projections Ideal Candidate: - Proficient in MS Excel, capable of building complex models - Experience in financial modeling for the energy sector - Understanding of manufacturing financ...
نحن شركة تجارة إلكترونية نتعامل مع منتجات متنوعة ونبحث عن مدير إعلانات الوسائط الاجتماعية للانضمام إلى فريقنا. تشمل المهام على سبيل المثال لا الحصر: إنشاء الإعلانات على منصات التواصل الاجتماعي المختلفة إنشاء تقارير في Excel وGoogle Sheets بشكل يومي وشهري إيقاف الإعلانات التي لا تقدم عائد الاستثمار المقبول إنشاء إعلان جديد للحملة المتوقفة يجب أن يكون مدير الإعلانات متفرغًا فقط لهذا المشروع وغير ملتزم بأي مهمة أو وظيفة أو دراسة أخرى ساعات العمل: 6 أيام في الأسبوع، 10 ساعات يوميا يجب أن يجيد الوكيل اللغتين العربية والإنجليزية يجب أن يتمتع أيضًا بمهارات تواصل جيدة يمكن أن تعمل على إكسل أن يكون لديك خبرة كافية في إعلانات وسائل التواصل الاجتماعي والتسويق الرقمي
As we are Manpower Supply Agency, We would like to incorporate attendance day to day entry of our workers from this info we would like to automate payroll, billing and Government salutatory. and also a dashboard for overall performance of our agency. Skills and experience: - Human Resources and Employee Management expertise - Ability to create user-friendly interfaces - Experience with Single Sign-On (SSO) integration and other login methods - Capable of adding features like search functionality, photo upload, and editable fields - Excellent communication skills to understand our needs and translate them into a functional system.
...mobile app designed for performing a mathematical magic trick. The app will involve complex calculations and data handling to reverse engineer a sequence of mathematical operations based on user input, ultimately revealing specific playing cards with pre-determined ages and birth years. Key Features: User Input: Users will input a final large number and a chosen multiplier (1-10). Reverse Calculation: The app will perform reverse calculations to derive intermediate values and ultimately the user's birth year. Data Mapping: The app will map calculated results to corresponding birth years, ages, and specific playing cards. Deck Arrangement: The app will indicate the correct position of playing cards in a deck based on calculated results. Error Handling: The app should accoun...
...and Spanish in a complete SEO perspective (title, bullet point and descriptions) according to the guidelines. Requirements: 1. No machine/automated translation software 2. Creative writing according to local language 3. Inclusion of the specific keywords researched 4. Check similar products for reference 5. Immediate availability to start the project 6. Good computer skills (Slack, Trello, Drive, Excel) 7. Excellent knowledge of English, French and Spanish 8. Speed in performing the required tasks 9. Demonstrable previous experience in the role 10. Responsibility, attention to detail, proactivity and a high sense of autonomy with an orientation towards teamwork Project on an hourly basis with the possibility of long-term collaboration. No Agencies, No Inexperienced and No Contrac...
...problems. Experienced in the creative design and delivery of social media campaigns Strong attention to detail and accuracy in managing event logistics, budgets, and administrative tasks. Exceptional written and verbal communication skills, including drafting professional emails and event materials. Excellent IT skills and ability to confidently use PowerPoint, Canva, Word and Excel to quickly pick up new programmes....
My project involves migrating a medium-sized database (between 1GB and 10GB) to Oracle, and optimizing its performance. The databas...also need to be designed, as this is not yet finalized. Key responsibilities include: - Migrating existing data: I need an expert who can handle this without losing any data or causing downtime. - Performance optimization: Once the data is migrated, the database needs to be optimized for speed and efficiency. - Designing the database schema: Your ability to design a schema that aligns with our business goals is critical for this project’s success. Ideal candidates should have extensive experience in Oracle database development, with a focus on data migration and performance optimization. A proven track record in designing database schem...
Enthalpy energy chemical calculation for gas reaction Quick calculation will share details in message
I need help with data entry from PDFs into Excel, with some basic analysis required post-entry. Key Details: - The primary task is to type data from PDFs into an Excel spreadsheet. - I will provide the PDFs, they contain various types of information that need to be accurately transposed. - The data must be organized neatly and consistently in the Excel file. Data Analysis: - After the data entry, I will need basic analysis of the entered data. This includes simple calculations, averages, basic graphs, etc. - A grasp of Excel's basic analytical functions is essential for this part of the project. Desired Skills: - Proficiency in data entry, especially from PDFs to Excel. - Strong command of Excel, particularly for data management and basic analysi...
