Excel extract data from table based on multiple criteriaงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...สามารถ 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)
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
ข้อมูลในภาษาไทยจะเป็นไปตาม. YOU MUST BE A NATIVE THAI SPEAKER TO DO THIS JOB!!! NO EXEPTIONS!!! Im looking for someone to complete a SEO on our page: www.d-contact.shop. The page is in pure HTML, so no wordpress plug ins or anything like that. The metatext for google search has already been written in thai. If you deliver good work there might be aditional tasks such as off page SEO. We also have several other pages that needs fixing. ฉันกำลังมองหาคนที่จะทำ SEO บนหน้าของเรา: หน้าอยู่ใน HTML บริสุทธิ์ดังนั้นไม่มีปลั๊กอิน wordpress ins หรืออะไรแบบนั้น มีการเขียน metatext สำหรับการค้นหาของ Google เป็นภาษาไทยแล้ว หากคุณทำงานได้ดีอาจมีงานอื่น ๆ เช่น off page SEO นอกจากนี้เรายังมีหน้าที่อื่น ๆ อีกหลายหน้าที่ต้องการแก้ไข
คำนวณ Dynamic flow เพื่อดูการ action เปิด-ปิดของตัว Valve ที่ Condition เเตกต่างกัน
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
looking for job typing document from book by on line I mean want to work at home
Programming with c # or C ++ connected to the camera. Face Detection with Face snapshot datetime into the database with MySQL. CCTV ( Detection Face of multiple pages on a single ticket )
...banners and other smaller visual elements for websites is a significant plus. Project Details: - First Project: Design a homepage for a casino website, including footer and header. - Content: The homepage will feature a substantial amount of content (approximately 20,000 words). - Visual Requirements: Each H2 heading (around 40 in total) will need a corresponding image. These images can range from banners to other types that visually complement the content. Unique images should be created using Google Translate to fit each heading’s context. - Stage Site: - It has AI placeholder images right now, you will replace them. - Design Quality: We are aiming for a premium feel similar to Skills Required: - Proficiency in Figma - Strong portfolio
I need assistance setting up a WordPress blog on Amazon EC2 for a new blog AWS Setup and Deployment: a new WordPress instance on AWS using Amazon Lightsail or EC2. the existing ThemeForest theme from Bluehost to AWS. Content and Design: the site content is primarily in Arabic, with some pages in English. advice for students on studying abroad. any unnecessary content. a minimalist design. 5. Set up menus, categories, and subcategories. Content Upload: images and articles in Arabic. all content is well-organized and properly formatted. SEO and Analytics: up a Google XML sitemap. Google Analytics. the site for SEO. Performance Optimization: caching solutions to improve site
...be used across multiple channels like my website, social media, business cards, flyers and even merchandise such as apparel and mugs. Therefore, the design should be versatile and able to maintain its appeal across these different mediums. Ideal Skills: - Graphic Design - Logo Design - Branding - Understanding of various design software and tools ABOUT "Valentius Kryptix" Valentius is a dynamic company specializing in Software Development, Management Consulting, Digital Marketing, and EdTech. We deliver cutting-edge software solutions, provide strategic management insights, craft impactful digital marketing campaigns, and innovate in educational technology to empower businesses and learners alike. Valentius combines expertise and creativity to drive success across ...
...chatbot will be programmed to carry out multiple tasks: - Answer typical queries - Offer relevant advice - Schedule meetings - Perform any function that is currently possible for it to do verbally The AI chatbot should be compatible with Slack and eventually extend to all phone applications. The chatbot should integrate with a database. We could explore other data integration requirements during our discussions. Ideal applicants are those familiar with AI chatbot programming, Google Assistant integration, and broad-reaching app compatibility. Database integration knowledge is essential, with bonus points for those who can offer a variety of data integration possibilities. Please bid only if you are skilled in these areas and ready to collaborate on this ...
I'm looking for a talented 2D animator who can b...than 1 minute in duration. - This job involves creating multiple videos, so efficiency and consistency in your animation style is crucial. - The ideal candidate will have experience in creating animations specifically for teenagers, ensuring the content is relatable and appealing to this demographic. Skills and Experience: - Proven ability to create high-quality 2D animations, ideally in a cartoon style. - Previous experience in creating animations aimed at teenagers is highly preferred. - Strong time management skills and the ability to maintain quality across a high volume of work. If you're an animator who can capture the attention of a teenage audience with your creative storytelling and animation skills, I'...
I'm seeking a professional to assist me in boosting the online visibility of my business, specifically on social media platforms. The primary goal of the role is to help me increase the online visibility of my business. Key responsibilities include: - Creating a comprehensive social media strategy that aligns with my business goals - Developing engaging content to attract and retain followers - Executing the strategy across various social media platforms - Monitoring social media analytics and providing insights for further improvement The ideal freelancer for this project will have a strong background in social media management, digital marketing, and content creation. Experience in the same industry as my business would be a significant plus. Please share your releva...
I need an experienced Linux admin who can help me set up a CentOS server to function as a web, database, and file server. The ideal candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file server - Ensure the server is secure and optimized for performance - Provide documentation of the setup and configuration for future reference.
I have a list of 50000 urls, I would like to scape the pages to see if they contain references to scripts - I will provide a list of the urls and the scripts. Deliverable should be an excel with the 50000 urls and whether they contain the link for each script. Looking for fast turnaround
I am in need of a skilled Mac...dataset is of moderate complexity, featuring multiple variables. The primary goal of the model will be to understand the relationships between these variables. Key Responsibilities: - Utilize the provided dataset to develop a causal model - Ensure that the model is capable of effectively illustrating relationships between variables - Optimize the model for performance Ideal Candidate: - Proficient in Machine Learning and Python - Experience with building causal models - must have worked on techniques like robust synthetic control, dowhy, econml, trigamite, DECI and other double ML/causal techniques - Strong analytical and problem-solving skills - Ability to work with moderate to complex datasets - Strong understanding of relationship modelin...
...seeking proposals from experienced web scraping and data analysis firms to conduct a comprehensive data collection and analysis project. The purpose of this project is to gather detailed information on menu items, pricing, customer ratings, promotions, and deals from various food delivery mobile apps operating within our city. The goal is to mine this data for actionable insights to inform our advertising, promotional strategies, and competitive benchmarking. 2. Project Scope The selected vendor will be responsible for developing and implementing a solution to: • Subscribe to and navigate through multiple food delivery mobile apps. • Collect data on menu items including descriptions, pricing, customer ratings, and...
I'm looking for a skilled character artist/graphic designer to help reimagine my online avatar. I have already created the avatar but now I'm looking for an artist who can reimagine it in their own style and can create multiple poses, outfits, expressions, etc. The gig will initially be for a series of twitch elements but this contest will be a simple "take my existing drawing and reimagine it in your own style." The envisioned avatar should be in a cartoon style, reflecting everyday life. I'm looking for a design that is cheerful and energetic. Key requirements: - A strong portfolio of cartoon character designs is a must. - Experience in conveying specific emotions and personality traits through visual design. - Great understanding of the nuances of chara...
I'm working to develop a series of 500 infographics aimed at UPSC students. These will cover a range of topics, primarily focusing on current affairs and geographical data. Specific Topics: - Economy and finance - Politics and governance - Environment and climate change Level of Detail: - Intermediate level analysis Key Responsibilities: - Creating infographics on the selected topics. - Ensuring the information is current and accurate. Ideal Skills: - Experience in creating educational infographics. - Knowledge of current affairs and geography. - UPSC exam preparation experience would be a plus. Please note that the graphics should be clear, concise, and engaging for a student audience. Your work should support students in understanding and retaining the i...
...Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract the re...
...have a web application that runs on PHP and I'm looking to integrate it with APIs provided by multiple suppliers. These suppliers will send us three specific types of data through their APIs - customer information, product information, and order information. Key Requirements: - Connect the webapp with Supplier A, Supplier B, and Supplier C APIs. - Extract and process customer information, product information, and order information sent by these suppliers. - Display this data on the webpages of the application. - Store this data efficiently in a database. Skills and Experience: - Proficient in PHP and API integration. - Strong understanding of database management. - Experience in handling customer, product, and order data. - ...
...effectively categorize the games on my site. - This will involve back-end work and ensuring that the taxonomies are correctly linked to the relevant content. SPECIFICATIONS (REFERENCE IMAGES PROVIDED): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and create a new one called Booking Category. This will need look up the `11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) a...
...PDF attachments from Outlook emails. Key Requirements: - Extract PDFs based on dates within the PDF text: The PDFs should be saved based on a specific criterion - dates within the PDF text. Your role will be to parse these dates and save the files in a designated folder on my computer. Skills and Experience: - Proficiency in Outlook: A deep understanding of Outlook's email management functionalities is a must for this project. - PDF Parsing: Experience with parsing text within PDFs is essential. - Automation: The ability to create a script or use a tool that can automate the process of saving the PDFs according to the specified criteria. - Efficiency: The project needs to be completed urgently, so the ideal candidate should...
...should be able to: - Extract the first value from the first document that is loaded - Select the second value from the second document that is loaded The communication between the Chrome extension and the server should be seamless and efficient. The server should be able to receive and process the values extracted by the extension. Iam using a multiple AWS windows instances upto 16. So in every instance I use chrome Browser for my Business to customers daily. So I run a Extension in chrome for Auto click drop-down &radio button That extension developed by other freelancer So Every instance& chrome extension has to connect to the server and if we change the radio button and drop-down on the server it has to be clicked as order wise. If ...
I'm looking for a freelancer based in New York, USA. You must aware of OSE Registration numbers in NYC. Please apply only if you're in this area.
...should be able to: - Extract the first value from the first document that is loaded - Select the second value from the second document that is loaded The communication between the Chrome extension and the server should be seamless and efficient. The server should be able to receive and process the values extracted by the extension. Iam using a multiple AWS windows instances upto 16. So in every instance I use chrome Browser for my Business to customers daily. So I run a Extension in chrome for Auto click drop-down &radio button That extension developed by other freelancer So Every instance& chrome extension has to connect to the server and if we change the radio button and drop-down on the server it has to be clicked as order wise. If ...
...Instagram account. This account mainly focuses on my love for cars and travels. Key responsibilities: - Increase followers and engagement: Your primary goal is to enhance both the quantity and quality of interactions with my followers. Content creation: - Daily posts: Consistent daily posts are essential to maintain an active presence on the platform. - Photo posts: You will be required to capture visually appealing shots of my cars and travel experiences. - Videos or reels: I also need engaging video content, showcasing my cars and travel destinations. Ideal skills and experience: - Proven track record of managing and growing personal Instagram accounts. - Proficiency in creating quality social media content, specifically with a focus on cars and travel. - S...
I need a graphic designer to cr...simple and minimalist logo that will emphasize brand recognition. The logo will be used across various platforms including on my website, print materials, and social media. Key deliverables for the project include: - A simple, minimalist logo design that focuses on brand recognition - The logo should be versatile and suitable for use across a range of platforms, including websites, print materials, and social media Ideal skills and experience for this job: - Proven experience in graphic design, particularly in creating logos that focus on brand recognition - Proficiency in minimalist design styles - Understanding of how to create logos that are versatile for use across multiple platforms - Strong communication skills to under...
...navigation. - You'll have to give me options to select/finalize a WP theme. - I can provide any theme from - If you prefer any other theme than you'll have to arrange it by yourself. - Include key pages such as Home, About Us, Services, Contact, Testimonials. - Additional pages like Pricing, Career, Blog, Get in touch, Book FREE Trial (CTA), Request FREE Consultation (CTA), Terms & Conditions, Refund Policy, Privacy Policy, Disclaimer. - No specific color schemes or branding guidelines. You have the freedom to be creative. But I have a logo and I would prefer that its in line with it. Ideal Skills and Experience: - Extensive experience with WordPress, including theme based development. - Knowledge of UX/UI design and best practices for lead conversion. - St...
I am in need of a skilled iOS app designer to help develop a start-up program aimed at addressing the ubiquitou...iOS platform app design - Prior experience in start-up or related app development - Solid understanding of user experience and interface design - Excellent problem-solving skills and creativity - Ability to work within deadlines and multi-task effectively. This project requires someone who can intuitively understand the needs of a start-up and bring creative solutions to the table. I look forward to hearing from you. I have searched the app store and have not found anything like this but it is very much needed. I will need to get a confidentiality agreement signed before anything starts. It should be fairly simple but I am not versed in app production. Thank y...
