Excel 2003 visual basic code conditional formattingงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
สร้าง Website storytelling visualization อธิบายการทำงานของ machine learning ลักษณะประมาณนี้ ร่วมกับ
...สามารถ 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 ที่กำหนดให้
...THE WORLD THAI CULTURE AND CITY THEN PLEASE MAKE THE BEST USE OF THIS CHANCE. Our Expectations: Have a great body and being a fit person who goes to gym frequently (male/female) (Sharing your full photo is mandatory to apply along with resume) Provide security or being a bodyguard or secretary for our client in person or their organization. Speaks Thai fluently and knows driving bike/car. Speak Basic English Familiar with all the tourist attractions in your area or clubs,nightlife. Ideas to make tourists happy for secretarial jobs by being creative, smart, honest, punctual and hard working (10-12 hours daily). Should be currently living in Pattaya or should make his/her own arrangements for staying in Pattaya during internship. The testing phase is between September 29 to Octob...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
ปัจจุบัน TOPICA EDTECH GROUP ต้องการผู้ช่วยสอนภาษาอังกฤษ 20 คน ในโปรแกรม TOPICA หน้าที่: - ช่วยเหลืออาจารย์เจ้าของภาษาในคลาส Live Session Basic - สอนนักเรียนในคลาสสนทนา - ช่วยเหลือและปรับปรุงคลาสเรียนออนไลน์ให้มีประสิทธิภาพมากยิ่งขึ้น - ทดสอบทักษะภาษาอังกฤษของนักเรียนไทย สิทธิประโยชน์: - เงินเดือนดี ขึ้นอยู่กับจำนวนชั่วโมงที่คุณสอน - ไม่จำกัดชั่วโมงสอน - ทำงานที่บ้าน - ได้ทำงานกับอาจารย์เจ้าของภาษาเพื่อฝึกทักษะภาษาอังกฤษไปในตัว คุณสมบัติที่ต้องการ: - พูดภาษาไทยเป็นภาษาหลัก - สามารถสื่อสารภาษาอังกฤษได้ดี - มีความมั่นใจในการสื่อสาร ชัดเจนและไม่ติดอ่าง - ต้องมีอินเทอร์เนตที่เสถียร (สำหรับที่บ้าน)
สวัสดีครับ ผมกำลังหาคนเขียนโปรเจคเกมส์ออนไลน์ โดยที่ผมมี 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
นี้คือรายละเอียดของโปรเจคผมครับ - เป็นเอกสารประกอบ 1 ชุด - source code ที่เขียนโดย visual studio 2008 เขียนได้ประมาณ 40% แล้วครับ ในเอกสารจะเขียนโดยใช้จาวา แต่ตอนนี้ผมเขียนโดย c# แทนครับซึ่ง เป็นโปรแกรม สกัดกั้นการแสดงผลลัพธ์จากการสืบค้นคำลามก ครับ ซึ่งต้องเขียนโปรแกรมดักจับ chrome browser ไม่ให้แสดงผลลัพธ์รายการที่เป็นคำลามกจากการ search คับ ถ้ารายการไหนเป็นคำลามกก็ไม่ให้แสดงผล ถ้าไม่มีคำลามกก็ให้แสดงผลได้ ครับ พี่ช่วยดูให้หน่อยครับ
ต้องการให้ set-up ในส่วนของ WEB Hosting (ตั้งค่า DNS + อื่นๆ) Wordpress installation (Basic Themes)
I require to verify a basic Energy Compliance report using Comcheck program for a 750 sq. feet single story modular building.
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 have bank statements from Bank A that I need converted into an Excel spreadsheet. The specific transactions you'll be dealing with are both deposits and withdrawals. Here's what I need: - A thorough and meticulous translation of each individual transaction: both deposits and withdrawals. - Once this data is entered into the spreadsheet, I need you to sort it by transaction type. This role requires expertise in Excel and a keen eye for detail is essential, as the integrity of the data will be paramount. Knowledge about financial transactions, specifically deposits and withdrawals, will be useful. A background in bookkeeping or accounting will also be a plus.
I'm in need of a professional to convert my hand-drawn electrical schematics, which are currently in image file format, into electronic schematics. The ideal freelancer for this job would...hand-drawn electrical schematics, which are currently in image file format, into electronic schematics. The ideal freelancer for this job would be experienced in: - Electrical engineering - Using AutoCAD, as this is my preferred software for the electronic schematics The specific requirements for these electronic schematics are: - Must be editable - Detailed, but clear enough for anyone with a basic understanding of electrical schematics to read. Successfully completed projects with similar requirements will be appreciated during the selection process. I look forward to receiving ...
I am seeking a talented Autocad 2D expert to produce a basic layout for a single-level house. I am focusing on structural elements, so no interior design or material specification is needed at this phase. Ideal Skills and Experience: - Detailed knowledge of Autocad 2D - Proven experience in architectural design - Works efficiently and accurately - Familiar with residential building layouts
I'm looking for a professional to develop a sophisticated website for my pizzeria and restaurant. The cornerstone feature will be a detailed, image-based menu. Here are some specifics to take into account: - Menu Display: The menu should be extensively detailed, making use of high-quality images for each item. This should ...the extensive variety. Ideal Skills and Experience: - Prior experience designing food-related or restaurant websites - Proficiency in creating enticing, image-based digital menus - Ability to structure a high number of categories in an easy-to-navigate design. The ideal candidate should have a keen sense of aesthetics suitable for a pizzeria & restaurant and a knack for creating mouth-watering visual depictions of menu items. I can't wait to se...
...should be able to easily locate, access, and view their desired highlights. - **Revenue Generation:** The website should be optimized for ad placements. The goal is to maximize revenue from viewership through strategic ad positioning and formats. - **Scalability:** As a new enterprise, the site should be scalable and able to handle increased traffic and content as the platform grows. - **SEO:** Basic SEO principles should be applied to enhance the website visibility and attract organic traffic. I'm looking for a freelancer who has experience in website development and design, particularly in the sports or video streaming industry. Familiarity with APIs and ad revenue generation is a plus. The ideal candidate should have a portfolio showcasing similar projects and the abilit...
I'm seeking an experienced developer to create an online script that can automate the conversion of CSV files. Script must be browser based and linux based. No preference on programming language. Source file will need to be uploaded to CSV converter, and script will sort data and rename columns based of pre-existing requirements. Once conversion is finished, download link generated to download updated CSV.
I am in need of expert skills in 2D animation to create a short, engaging video that encompasses a unique process. Requirements: - The animation should be 2D. - Experience with creating short, impactful animations is essential. - The completed video should be less than 1 minute in duration. - I will provide the script for the animation. - Grasp on translating text to visual imagery is invaluable. Ideal freelancers will possess exceptional 2D animation skills, strong communication, and an ability to work efficiently to create a punchy, less than a minute video from the provided script.
I'm seeking a seasoned Excel VBA developer to create a script that will regularly manipulate data within my Excel sheets. I have vba code run each 5 hours to export my excel sheets as pdf photos, but the problem here is my pdf photo sometimes not shown correctly, and sometimes its shows correctly. here is my vba code: For i = 1 To 57 '54 ' = False sheetxx(i).Select (Now + TimeValue("0:00:05")) ' "({1068})", True 'DoEvents pdffilename = fname2 & "" & sheetxx(i).Name & ".pdf" jpegfilename = fname2 & "" & sheetxx(i).Name & ".jpg" Shell ("D:khalid savescreenshot " & jpegfilename) ' (Now + TimeVal...
I need assistance with a simple Excel data entry task. This job purely consists of data entry and doesn't require any form of data analysis. The data I need entered includes names and addresses. Ideal Skills: - Proficiency in Excel - Attention to detail - Experience with data entry
I need a professional with excellent data entry skills to assist in cleaning and refining my existing data sets. The data is currently in Excel format, and I want it to be more organized and polished. Skills and Experience: - Proven data entry skills - Proficiency in Excel - Experience with data cleaning and refinement - Attention to detail Tasks to be completed: - Review the current data sets - Remove any inaccuracies or errors - Reorganize the data if needed - Ensure all data follows a consistent format The ideal candidate is someone with a keen eye for detail and the ability to handle large amounts of data efficiently. I expect prompt delivery and utmost accuracy in the task. If that's you, place your bid now!
I'm looking for an illustrative logo design for an app named "Flytunes." It's a music streaming application and I want the logo to reflect the essence of music in a bright and vibrant color scheme. Key details: - Logo Design: I'm keen on having an illustrative style for the logo. - Color ...talented designers. Ideal Skills and Experience: - Experience in designing logos, particularly in the music and entertainment industry. - Proficiency in creating illustrative designs. - Understanding of color psychology and ability to work with a bright and vibrant palette. - Creative flair and ability to come up with unique design concepts. The selected freelancer will have a chance to shape the visual identity of an exciting music streaming app. Please include a li...
...page dedicated to different products and services. - The design style should be modern and sleek, reflecting our brand image. - The brochure should be static, meaning it doesn't require any interactive elements like clickable links or embedded videos. Ideal Skills and Experience: - Proven experience in designing digital brochures, particularly in a sleek, modern style. - Strong understanding of visual design principles and the ability to create engaging layouts....
I need a Python script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organiz...script that will help automate various tasks. Key tasks for this automation include: - File Management: the script should enable the organized handling of Word documents and Excel spreadsheets. - Data Entry: automation for data entry tasks. - Email Sending: automation for sending emails. The ideal candidate for this job should have: - Strong experience with Python scripting and automation. - Understanding of file management concepts and libraries in Python. - Ability to implement automated data entry and email sending functionalities. Looking forward to finding a professional who can deliver efficient, clean code ...
I need a logo designed for my company, Pro Set Services. We specialize in providing top-notch services and expertise to our clients. The logo should reflect our core values of professionalism and expertise, while having a modern and minimalist style. Key Requirements: - Modern and minimalist logo design -...values of professionalism and expertise, while having a modern and minimalist style. Key Requirements: - Modern and minimalist logo design - Representation of professionalism and expertise - Aesthetic that aligns with our company core values Ideal Skills and Experience: - Proven experience in logo design - Understanding of modern and minimalist design - Ability to translate abstract values into visual design - Excellent communication to ensure the design reflects our company&...
I'm looking for graphic designs of 3 unique fairy wings and 3 women, each without a face, at chest level. The theme I'm aiming for is Realistic, ...with unique, visually appealing designs for the fairy wings and women. - Understanding of human anatomy and perspective: Even though the women won't have faces, it's important that the proportions and angles are realistic. - Attention to detail: The devil is in the details, and this is especially true for this project. The fairy wings and women should be meticulously designed to create a striking visual impact. - Strong communication: I'll need you to understand my vision and be able to bring it to life through your designs. While the dimensions weren't specified, I'm open to suggestions on what size ...
...into my supply chain material position excel sheets. Here are the specifics of what I'm after: - Improved Formatting: The overall layout and design of the sheets need a complete overhaul to enhance readability and aesthetics. - Clear Headings and Labels: Make vital information instantly noticeable by introducing clear and concise headings and labels. - Consistent Color Coding: Utilize color coding to clearly distinguish varying points and sections, ensuring coherence and ease in navigation. - Sheet Layout Redesign: I seek a thoughtful redesign that couples functionality and design effectiveness, making the excel sheets intuitive and user-friendly. - Conditional Formatting for Color Coding: I'd appreciate an implementation of conditi...
I require a skilled 3D visual effects animator to create engaging rear projections for a theater production. The play lasts for a duration of 1-2 hours. The animations should be visually stunning and creatively incorporated into the play. The ideal freelancer should have the following skills and experience: - Expertise in creating 3D animations, particularly visual effects. - Ability to animate flying effects and magic effects. - Knowledge and experience in theater productions or similar events are a plus. - Strong understanding of timing and how visuals can enhance a live performance. Your task will be: - To design and animate distinctive 3D flying and magic effects. - To work with the director to ensure the visuals align with the script and the vision of the performan...
... cuts, price per metre, and customer location. This is crucial for managing the diverse pricing needs of my business. - **User-Friendly Interface**: The site should be intuitive and easy for customers to navigate, select their desired product configurations, and see the corresponding pricing. - **Existing Brand Assets**: The design must align with my current brand assets to maintain a cohesive visual identity across all touchpoints. I'm seeking a freelancer with the following skills and experience: - **Shopify Expertise**: Extensive experience in developing and customizing Shopify sites is a must. - **Understanding of E-Commerce Pricing**: A strong grasp of e-commerce pricing strategies and the ability to implement complex pricing models within the Shopify framework. - **UI...
...that can take input as lists of 'subject, problem, idea', and output completed posts, but you're welcome to use a different AI if you want to. We've even generated a list of prompts to generate such good content, so this should be a very easy project. We just need you to have an AI generate the content and make sure all the details are correct. -that the AI didn't hallucinate anything. Formatting is very basic: Subject posts: a few lines of text and some tags. (subject posts are often placeholders for the more interesting content: problems and ideas) Problem posts: a few lines of text, tags, a few statistics with sources cited, and a section for "potential harm". Idea posts: : a few lines of text, tags, and a few statistics with sources ...
I'm in need of a skilled professional to help me evolve my business, focusing specifically on sales, marketing, and operations. - **Sales and Marketing**: The goals here are twofold; enhancing the visibility of o...Marketing**: The goals here are twofold; enhancing the visibility of our brand and improving our lead generation tactics. Experience in digital marketing, social media, and creative marketing strategy is essential. - **Operations and Processes**: Currently, these are handled manually which is time-consuming and inefficient. We're looking for someone to advise us, and possibly implement, a transition to basic or specialized software tools. Ideally, you should have a strong background in operations management and process design. Let's bring our operat...
...while maintaining the content, context, and style of the original material. - Convert PDF documents into editable Word formats, ensuring that the layout and formatting are preserved. - Edit and format Word documents to meet specific client requirements. - Ensure translated documents meet the quality standards and timelines set by clients. **Requirements:** - Must be a native speaker of Spanish with an excellent command of English. - Proven expertise in translation with a strong understanding of linguistic nuances between Spanish and English. - Proficient in converting PDF documents into editable Word formats. - Experience in formatting and editing Word documents with attention to detail. - Ability to work independently and deliver high-quality work under tight deadlines. ...
We're seeking an expert who can analyze eye movements, specifically focusing on pupil dilation using the Eyelink pupillometry system with SR research. The main objective of this project includes: -Measuring emotional response to visual stimuli Ideally, the freelancer should have: - Proficiency in using the Eyelink pupillometry system from SR Research. - An in-depth knowledge of oculomotor functions. - A strong background in neurobehavioral or cognitive science is a plus. - Proven experience in analyzing eye movements, particularly pupil dilation. This project does not require any analysis concerning Saccadic movements, gaze direction, or blink rate, nor does it involve monitoring variables such as emotional state or cognitive load in relation to pupil dilation. The focus is...
I'm in need of an experienced video editor to help with my content for Youtube. Key Requirements: - The video length is over 5 minutes, so experience in managing and maintaining viewer engagement in long videos is a must. - The editing style should cater to a Youtube audience, ensuring the video is engaging, professional, and visually appealing. - While I don't have specific visual effects or transitions in mind, I'm open to your creative input. Ideal Skills and Experience: - Proven experience in editing Youtube content, with a focus on videos longer than 5 minutes. - A strong portfolio of engaging video content. - Proficiency in using video editing software to create high-quality content. - Ability to work independently, delivering the project on time and to a high...
