How to calculate difference between two dates in excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
...Content ดังนี้ครับ 1. ให้พนักงานขาย รายงานรุ่นและจำนวนที่ขายกลับมาที่เรา โดยในเว็บจะมีสรุปยอดขายเป็นกราฟหรือชาร์ตต่างๆให้ ที่สามารถ sort เป็น สาขา เป็นเขต หรือทั้งประเทศได้ แบ้วแต่แกนที่เราต้องการ 2. มีระบบ Log in ซึ่งจะยึด user ของพนักงานกับสาขาที่เรากำหนดไว้ หมายความว่าเมื่อพนักงานกดรายงานยอดขายระบบจะ แท็กว่ามาจากสาขาไหน 3. หน้าพื้นฐาน เพื่อแจ้งข่าวสารหรือโปรโมชั่นต่างๆ และสามารถแก้ไขได้ง่าย 4. มีแพลตฟอร์มหลังบ้านที่สามารถแก้ไข เพิ่ม ลบ ข้อมูลได้ ทั้งในเรื่องของข้อมูลพนักงานข้อมูลสาขา โดยกำหนดให้ทำได้เฉพาะ User ที่กำหนดไว้ 5. สามารถ Export ข้อมูล รายงานต่างๆมาเป็น Excel 6. สามารถทำข้อสอบในลักษณะคล้ายๆ Google form 11:20 Avatar ได้ครับ 11:20 Avatar มี host หรือยังครับ 12:05 ยังครับ อยากทราบราคาก่อนนะครับ ว่าเริ่มต้นที่เท่าไหร่ 12:12 Avatar คร่าวๆ ประมาณ 1...
ผมกำลังทำโปรเจคจบปริญญาตรีเกี่ยวกับการ เลือกสีรองพื้นให้ตรงกับสีผิวด้วยโปรแกรม matlab ไม่ต้องทำออกมาเป็นแอปพลิเคชันครับ แต่ในเบื้องต้นอยากให้หน้า GUI แสดงผลออกมาได้ก็พอครับ flow คร่าวๆที่ร่างไว้คือ ใช้กล้องโทรศัพท์ถ่ายใบหน้าหรือท้องแขน จากนั้นโปรแกรม หาค่าสีเฉลี่ยเป็น rgb แปลงค่าเป็น Lab แล้วนำไปคำนวณหา deltaE (color difference) เมื่อเทียบกับข้อมูลของรองพื้นที่มีอยู่แล้ว ถ้าสีเฉดไหนไหนค่า deltaEน้อยที่สุด ก็แปลว่าใกล้เคียงสีผิวนั้นที่สุด ก็แสดงผลลัพธ์เป็นสีรองพื้นนั้นครับ (ทำด้วยโปรแกรม matlab เท่านั้นครับ)
ทำ 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 ที่กำหนดให้
...government offices, concerts special protection staff. This company is being setup in Bangkok because of a huge market in Thailand. My client will provide manpower services for all clients with a very low and competitive pricing. They are in the process of setting up a very big corporation in Bangkok. We are currently seeking freshers or low experienced people or freelancers either male or female with a good knowledge of the local areas within Pattaya and are willing to support our clients with their security requests on time and in an economical way. This will be the launch of the testing phase of the firm. WE WANT TO RECRUIT EMPLOYEES TO HELP US GROW OUR BUSINESS. THIS WILL BE OUR PILOT BATCH. IN CASE YOU ARE INTERESTED ...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Need an accountant who can use Xero accounting program and can help reconcile and tax. Monthly pay between 600-900USD for the right person. ใช้ xero program ได้เปนอย่างดี กระทบยอดบัญชีได้ทุกหมวด ปิดงบการเงิน ต้นทุน
Create a Dynamic Web pages for calculate transport charge using MySQL and PHP ต้องการโปรแกรมที่สามารถคำนวณค่าขนส่งสินค้าโดยนำข้อมูลที่มีผู้กรอกลงหน้าเวบมาคำนวณกับ Data base ค่าขนส่งสินค้าที่มี แล้วส่งให้ผู้กรอกลงหน้าเวบทางอีเมล
...user-friendly Google Form and Excel template system. This system will be geared towards the hotel management sector and will be used for recording bookings, sales, expenses, and other business-related data. Key Requirements: - Design and Implementation of Google Form: The form should be intuitive and easy to use. It should have fields for recording bookings, sales, expenses, and other relevant business information. - Excel Templates: The gathered data from the form should be integrated into a set of Excel templates. These templates should be professionally designed and easy for hotel management to use. Your Role: - Your role will be to create a system that can manage multiple businesses. The system should serve as a plug and play solution that...
...efficiently calculate the surcharges on a retaining wall, which is intended to support a residential building. The terrain is straightforward, without any particular challenging aspects. Key responsibilities and qualifications include: Tasks: - Conduct stability analysis and design checks - Calculate surcharges based on building loads - Ensure retaining wall is adequate for loads and soil conditions Ideal Skills and Experience: - Civil or structural engineering background - Experience in retaining wall design and surcharge calculations - Understanding of soil pressure distribution - Familiarity with residential building requirements This is more than a project; it's about safely supporting a home. So, if you've got the expertise and are ready ...
...compartment should be designed as a functional part of the fuse box cover and open from inside that's hard to tell apart from the rest. I’m thinking a magnet opens a hidden latch - The size of the compartment should be compact, about 25mm increase in the cover height will work but without causing a bulge or noticeable difference. Key Skills: - Knowledge and experience in 3D modeling and design - Attention to detail in rendering modifications - Familiarity with designing automobile parts is not a must but would be a plus. For this project, understanding the balance between functionality and stealth is very important. I look forward to seeing your unique design ideas. I may be able to provide a 3D scan of the...
...will be promoting an event, so it needs to strike a balance between being visually appealing and informative. Key requirements include: - Design: I want a black and white background photo. This will help make the text and other elements on the cover stand out. - Content: The cover should include information about the host, such as their name, occupation, and background/experience. This should be presented in a clear and professional manner. - Call to Action: The cover needs to include the website URL of the event. This should be prominently displayed and easily clickable. Ideal skills for this job include: - Graphic Design: You should have a solid background in creating engaging and professional graphics for social media. - Branding: You shoul...
Looking for someone with advanced skills in Excel and PDF interactivity who can transform a multi-sheet excel document into an editable PDF, while maintaining its ability to be converted back into an excel document. The purpose of this conversion is to enhance collaboration, hence the PDF should feature: - Interactive input fields that can be edited. - Checkbox and/or radio button functionalities. Also looking to add our company logo in the header and company info (addresses, phone numbers etc) in the footer. The ideal freelancer would not only support this conversion, but also maintain the original formatting to protect the sanctity of the document. Previous experience in similar work would be advantageous. L...
I'm in need of a seasoned freelancer who can help design a professional and engaging newsletter targeted specifically at newby freelancers. This is a recurring project, and I require the newsletter to be sent out on a weekly basis. Key Requirements: - Design and Set-up: I need someone with a keen eye for design who can make the newsletter visually appealing and professional. - Audience Focused: The content of the newsletter should be tailored and engaging for experienced freelancers, providing them with valuable insights and tips that can help them excel in their freelance careers. Ideal Skills and Experience: - Proven experience in designing newsletters, specifically for experienced professionals. - Familiarity with email marketing tools for manag...
...website developer to create a user-friendly car rental website. The primary aim of the site is to facilitate online car reservations. Key Features: - Online Booking System: Users should be able to easily reserve a car through the website. This feature is central to the website's functionality. - Vehicle Availability Search: The website must have a search functionality that allows users to check for the availability of different vehicles on their desired dates. - User Reviews and Ratings: It's important to include a system for users to leave reviews and ratings. This can help build trust and credibility in our services. - Credit Card Payment Integration: The website should be able to securely process credit...
I need a FB cover photo for a group. The Title should be "Merchants of Camelot" and say "Hosted by Andrea Oliver". It should include the attached image in black & white and the website Colors - Yellow/Gold and Dard Red Theme - Camelot with Red Roses Fond - Variations between script, bold and regular are appreciated.
I'm in need of a creative and skilled developer to help me create an engaging platform for language translation between French, Algerian dialect, and vice versa. The goal is to enrich users' vocabulary. My primary requirements for this platform include: - A user-friendly search function that allows users to look up words in both languages. - A feature that enables users to record their pronunciation of words for feedback and improvement purposes. In terms of design, I envision the platform to follow a zoo and animal theme, presenting a fun, vibrant, and engaging visual experience for users. Ideal candidates for this project should have experience in: - Building interactive and engaging platforms - Integrati...
...converting Excel formulas to Google Sheets, particularly with the VLOOKUP function. The problematic formula in question is central to my data analysis processes. I need a professional who can troubleshoot and effectively convert these formulas to be compatible with Google Sheets. Key Tasks: - Identify the source of the "IFERROR" error in the VLOOKUP formula as it functions in Google Sheets. - Modify the formula for accurate results in Google Sheets, ensuring it retains its original functionality post-conversion. Ideal Skills and Experience: - Proficient in both Excel and Google Sheets formulas and functions. - Strong experience with VLOOKUP and IFERROR. - Ability to troubleshoot and adapt formulas a...
I need assistance in creating a specialized budgeting spreadsheet focusing on drivers license renewal costs. As someone who understands the intricacies of financial data, your task encompasses the following: - Developing a budgeting spreadsheet with an emphasis on renewal fees. - Including a feature for expense tracking and an income versus expenses comparison. - Incorporating a mechanism for budget forecasts to plan my finances better. The ideal freelancer for this task should excel in financial data management and have a comprehensive understanding of Excel or similar platforms. Previous experience in creating budget planning or financial management tools would be a significant advantage. Let's simplify my financial management together.
As the client, I need a website that can function offline, primarily aimed at assigning 3D components to various errors. These components should be simple structural designs. The basis for the assignment of these components is a manual input system. Integrating a feature for capturing photos of these errors is also crucial for this project. Ideal skills and Experience: • Proficient in 3D designs • Web Development Skills • Experience with Offline Application Development Key Features: • Assign 3D Components to Errors (manual input basis) • Capture Photos of Errors • Offline Functionality
My firm has expanded to the point that we are in need of a virtual assistant. All work will be done from home, and you will be with our company for as long as we need. The tasks required include basic data entry, internet research, and basic communications with outside parties. Work can be done from anywhere in the world. You will be required to be online for 6-8 hours a day between the hours of 8 AM EST to 4pm EST. You must have basic English skills and know how to use a computer for basic tasks.
As the client, I am search of a seasoned virtual assistant to support me during typical work hours, 9am to 5pm (UTC +1). The ideal candidate will possess the following expertise: CRM MANAGEMENT: Monitor and manage follow-ups and sales activities within the CRM. Update and maintain accurate records of customer interactions and sales leads. Assist in developing strategies to improve CRM processes and efficiency. Customer Service: Respond to customer inquiries and resolve issues promptly and professionally. Maintain a high level of customer satisfaction through effective communication and problem-solving skills. Liaise with other departments to ensure customer needs are met. Email Management: Monitor and manage the CEO's email inbox, prioritiz...
...developer to build a grocery tracking app with a barcode scanner and expiry date tracker features. This application should be compatible with iOS and Android. I picture the user interface to be simple and minimalistic, ensuring a user-friendly and seamless experience. How much will this and how long will this take you? Much like Summary of the "Keep Fresh" Grocery Expiry App Project Project Overview "Keep Fresh" is a mobile application designed to help users track the expiry dates of their groceries. The app provides a simple and user-friendly interface for adding grocery items, viewing current inventory, and receiving notifications before items expire. The goal is to create a useful tool with AI features to...
Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
Hi Nima D., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I'm seeking an experienced professional to help me record online educational video lessons that are primarily targeted at Adult Professionals. These lessons involve frequent interactions such as: - Recording approximately 35 hours of video lessons in MP4 1080x1920 full HD. The tasks include - Shifting between slides. - Clicking on content to reveal additional information. - Uploading and sending the videos over to me. - Note: Recording must be clear of any external noise and unnecessary pauses between slides or content reveals. The challenge is to capture these interactions in one continuous video. I'm seeking someone with: - Proficiency in online video recording - Dedicated to quality and attention t...
I'm currently in need of a skilled individual proficient in Elementor and JetEngine to assist in finalizing the configuration of dynamic content imported from another site. The content, which includes Artists, Styles, and Portfolio Items, has been imported successfully (as a Crocoblock/JetEngine "skin" as well as Elementor archive and single templates), but requires further configuration to ensure it functions optimally on my website and fits the visual aesthetic. Key Tasks: - Configuring Custom Post Types (CPTs): The project involves working on Artists, Styles, and Portfolio Items. These should be set up in a user-friendly way so that I can easily manage and present the content on my site. - Establishing Relationships between...
We’re seeking a talented designer to create a logo for our sports club, “Jackdaws Bielefeld.” We play Roundnet (also known as Spikeball). I have a detailled vision in mind and some examples from other clubs, yet I am looking forward for you to infuse your own creativity in the design. Here are the key points I had in mind: Style: - Balance between aggression and friendliness. - Keep it simple for various applications (jerseys, Instagram, cups) and to be easily recognizable. - Elements should include the name of our club, a roundnetball a jackdaw (that's a specific kind of raven) Text: - Prominent “Jackdaws Bielefeld” in colorful typography. - Readable even when printed small. Jackdaw Imagery: - De...
I’m looking for a skilled professional to create TV commercials that promote a specific product or service. The main aim is to reach young adults between 18-34 years old, and the commercials should be lifestyle-focused. Key Requirements: - The commercials need to be engaging and appealing to a young adult audience - They should focus on promoting our product or service in a lifestyle-focused manner - They should be delivered in a TV friendly format Ideal Skills and Experience: - Proven experience in TV commercial creation - A good understanding of the target audience - Creativity in making lifestyle-focused content - Excellent storytelling and engaging style If you have experience in creating TV commercials that...
...skills to complete easy chores. Responsibilities include having regular discussions across multiple dating platforms. The final goal is to quietly shift folks from dating applications to Instagram chat or Snapchat app. This gig runs on a per commission basis and will cost $5. My virtual assistant can close an appointment in 15 minutes or less. I'd imagine. Some minor fluff discussion is required. One out of every five leads to a sale in less time. So, for now, I'll put the fee at $5. A minimum of $200 to $300 a month can be earned from your phone. only working one hour or less per day I'll be delivering two canned lines. You simply use it multiple times, but you can customize it to suit your preferences. ...
I'm in need of a brochure to increase awareness about the civic and community management within our general resident population. The brochure needs to have: - A Modern design aesthetic that appeals to a wide range of residents. - Clear and concise information about our projects, achievements and future plans. Striking the right balance between captivating visuals and informative text will be crucial to engage our audience. Ideal Candidate: - A seasoned graphic designer with a strong portfolio in modern brochure design. - Prior experience in designing for community-based projects will be looked upon favorably. - Strong understanding of layout, typography, and color theory. - Skills in conveying messages effectively thro...
I'm looking for a skilled WordPress designer to create a visually appealing website for my bistro. The main goal of the website is to showcase our menu and daily specials. The website will be done in 1 page only with all content located in 1 page - About us: The section should display some basic info of the business - Drink Menu and Prices: This section should display all the drinks we offer, including relevant information such as sizes, prices and any special offers. - Happy Hour Specials: This should list our happy hour deals, complete with pricing and timings. - Upcoming Events: This section should provide information about any live music events we have scheduled, including dates, times and the performers. - Where are we located: showcase locat...
...freelancer to develop a dynamic, user-friendly car advertisement website. This platform will serve as a marketplace for both new and used cars, empowering users to explore options effortlessly and make informed decisions. Primary Purpose: * Implement robust search functionality to enable users navigate based on their specific requirements, such as car type, model, brand, year, and other factors. * Create a section for featured listings to highlight select cars, thereby giving sellers the opportunity for added visibility. * Develop a flawless and transparent user review system to allow communication between buyers and sellers regarding the performance, functionality, and reliability of the listed cars. Transaction Feature: * Integrate a secu...
...a professional with experience in developing machine learning models that can help me create a model that will calculate true odds for horses in races. Your main task will be to analyze past performance data, race results, and betting data and develop a model that can find positive expected values within the races. Key requirements: - Experience in developing machine learning models for predictive analytics. - Ability to work with and analyze horse racing data. - Strong understanding of odds calculation and betting practices in horse racing. I'm looking for candidates with a strong background in statistics and data analysis, particularly in the field of sports betting. Successful freelancers should include their e...
I'm looking for a freelancer to conduct market research to determine the best selling aftermarket products in the motorcycle industry: specifically, my target segments are in the super sport, sport, sport touring and cruiser Japanese motorcycles (Honda, Suzuki, Yamaha and Kawasaki). I'm looking for at least information from 2 databases (examples would include Amazon and Ebay but open to other possibilities too). I wanted to limit the types of products to: (1) Brackets (2) Protective engine covers (3) Levers (brake, clutch, etc..) (4) Air intake components (air intake box or air inlet ductings). The project consists of 2 parts and thinking it would be in Excel format (but open to other formats too):
