Excel conditional formatting based on another cell valueงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
อัปเดต 4 แบบฟอร์มออนไลน์ใน Javascript Update 4 online forms in Javascript. Remove 3 paragraph from 1 form and add 1 text field to another form. Example, what needs to be done: Adjust this form according to the picture attached. Possible long term collaboration ahead.
...สามารถ 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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
Improve my PS website ranking for 10 local keywords in 1 month - organic SEO - white hat only - off-site SEO - work report (weekly) - keywords ranking report (weekly) - need to see improved ranking result in 1 month to continue another month - not more than 75 USD - keyword นายสิบตำรวจ สอบประทวน สอบนายสิบตำรวจ นายสิบ สายอำนวยการ นายสิบ สายปราบปราม สมัครนายสิบ สมัครนายสิบตํารวจ ติวนายสิบ กำหนดการสอบนายสิบ สมัครเรียนนายสิบ
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Memecoin Website & Staking Dashboard Developer We are seeking a talented and experienced Freelance Web Developer to design and develop an engaging website and secure staking dashboard for our new memecoin project. This is an exciting freelance opportunity to showcase your skills in cryptocurrency and decentralized finance. Project Overview: - Design a visually appealing and user-friendly website to promote our memecoin and engage the community - Develop a robust staking dashboard allowing users to manage their memecoin assets and staking activities - Integrate the website and dashboard with blockchain technology and smart contracts - Implement data visualization for real-time coin metrics and staking rewards - Ensure top-notch security practices to protect user funds and data Require...
I need of a developer to create a Docker image that can run Windows TTS on Ubuntu. i need a dev to make a bottle / docker image that can run windows tts to portably create tts .wav files on ubuntu. (using Wine) This will allow for the creation of .wav files using the Windows TTS engine in a portable and efficient manner. Steps: Install bottles / Wine / playonlinux Install the the tts into the bottle Use Balabolka to create a text .wav file example command: balcon -n Emily -t "The text will be read slowly." -s -5 -v 70 -w "d:Sound"
I'm in need of a proficient developer with Elementor Pro expertise and coding experience. The project is about finalizin... I am looking for an expert in Elementor Pro. I have almost finished putting together a site using a kit, however there are some tweaks and such as: Menu re-design (wireframes to be provided) Optimise site for mobile and tablet Optimise for SEO Automations in buttons across the site Small design changes to headings on front page (have hero title motion effect, entrance animation appear in typewriter movement (like chat gpt) Add a button to the header to link to another portal and a sign in widget to that portal. Site currently has 10 pages and 50 pages of blog content. Most of the work pertains to the front page. The blog area requires some lin...
I'm in need of a skilled typist with a minimum typing speed of 50WPM to transcribe online content for personal use. Key Requirements: - Proficiency in English language. - Minimum typing speed of 50 words per minute. - Able to adhere to specific formatting requirements. The ideal candidate should be able to ensure that the content is accurately transcribed and formatted according to my specifications. Experience in transcription and a good understanding of English language is essential for this task.
I need assistance with Excel to create multiple rules for a specific column in my spreadsheet. Here's what the project entails: - Developing rules based on cell formatting - The rules will be used to match multiple cells within the column following 5 specific criteria sets - The rules will be custom formulas specially designed for this task Ideally, you should be expert in handling Excel advanced features, specifically custom formulas. If you have experience in creating complex Excel tasks, that would be an added advantage. The ultimate goal is to automate the process where specific data is matched and inserted in another column.
...and preferences. I'm offering this role on a base pay with commission basis, with a lucrative percentage of the sales going directly to you. Terms: Base pay $1000. Quota: At least $10000 in sales through a combination of base program ($2500 x 4), middle program ($4000 x 3), and premium program ($8000 x 2). 10% commission for all revenue generated beyond $10000. Some key details: - Selling services: The product in question is a range of consumer services. - Target market: Your focus will be on consumers. Therefore, your approach should be tailored to attract and engage individual customers rather than businesses. - Manual reporting: I prefer to track the sales through manual reporting. It is your responsibility to provide accurate and timely reports on the sal...
The task must be done via anydesk or teamviewer! i will not share the code because the issue to fix is minor must have knowledge about laravel vite .. i am having an issue with updating the background colour of my app and i am unable to do a proper build.
...interface design is highly sought after. The project involves: - Developing an interactive and intuitive web-based platform that will visualize multidimensional data on a map of the USA. - Allow users to select which data dimensions are shown, enabling a customizable experience and how they are shown, such as Scatter Map, Contour Map, Area Map, Bubble Map, and more. - Simple Interactive Elements Concerning the data format, I am currently uncertain whether it will be provided in a specific format or requires preprocessing. Therefore, adaptability and problem-solving skills will be advantageous in this sphere. Misunderstandings around data formatting could result in inaccuracies on the platform, so a keen attention to detail is paramount. Responsibilities...
I need a professional web designer to create a unique design in Figma. The design should be inspired by , , and Key requirements include: - Creation of a design with unique color scheme - The design must be unique, fresh and not a copy of any existing designs. - The style should be based on bespoke designs - a form with fields to get informations about the customer's car - it has to have social proof form google reviews - a stepflow with 3 steps - faqs - and sections containing information about my business
I am in need of a developer skilled in Python for a project concerning the creation of a tablet finder application compatib...skilled in Python for a project concerning the creation of a tablet finder application compatible with Windows. The primary feature of this application must be search filters, specifically, those able to find tablets based on their MAC addresses. Ideal candidate would posses: - Proficient in Python - Experience in creating search filters - Familiar with MAC addresses - Working knowledge of Windows compatibility - Detail-oriented and able to work autonomously. The focus of this project is the development of a reliable application that can perform complex searches based on a tablet's MAC address. This is a specialized task requiri...
...tasks, then update certain field data, like tracking status - When the project is created, auto copy the project’s name to Exhibition. Please see the screenshot. Same thing in task, once select the customer, it will update the title. - Once new task is created (saved), it will update the external MySql tables (there are different tables), send the Customer name, Tacking number, Status, etc… data(value) to there creating or updating the mysql database. Also once the task is updated, like Status, it will update the database in the related record. This is for our tracking system. Users do not need to update tracking system separately. They only need to update everything in Odoo system. Similar case in National Skill Competition module, do exactly the same thing for the...
I require a knowledgeable freelancer to build an Excel sales order form which can handle multiple ship dates and calculate discounts on a sliding scale. Key Functionalities: - Multiple ship dates: I would like customers to choose their ship dates from a calendar function. - Discount calculation: Discounts should be calculated on a sliding scale based on the volume of the order. The ideal person for this task will have proven experience in building advanced Excel spreadsheets, primarily focusing on dates manipulation and financial calculations. An understanding of sales processes, specifically as it relates to ship dates and discounts, is advantageous.
I’m seeking skilled machine learning experts capable of creating AI systems focused on preventing physical theft. The primary targets are retail stores, specifically, monitoring theft in aisles and the stock room. Ideal Skills/Experience: - Proficient in Machine Learning - Experience with AI security solutions - Background in retail security systems - Strong understanding of video surveillance tech Duties: - Devise advanced AI systems for theft detection - Prioritize monitoring of aisle and stockroom areas - Implement machine learning to enhance theft prevention - Ensure seamless integration with existing security infrastructure
Our client seeks a skilled contractor to manage a network of 40 WordPress blogs. This is a highly sensitive project due to the volume and value of the websites. Candidates have to send in identification and sign NDA. Key Responsibilities: Systems Administration: CPanel management, database administration (PHP), FTP, firewalls. WordPress Maintenance: Plugin updates, theme management, basic frontend/backend operations. Security Focus: WordPress hardening, malware/infection remediation, firewall configuration, virus scanning, intrusion prevention. SEO: Basic on-site/off-site optimization, Google Search Console, Google Analytics, Google Webmaster Tools, Google ReCaptcha, cookie consent implementation. The Ideal Candidate: Demonstrated WordPress administra...
We are looking to develop a web-based application using Zoho Creator that allows users to scan QR codes of individual products and barcodes of outer cartons for inventory management purposes. The application will generate reports based on the scanned data, providing insights into the frequency of scans for each unique QR code. Sure, here's a detailed project requirement draft for your freelancing project: --- **Project Title:** QR Code and Barcode Scanning App for Inventory Management **Project Overview:** We are looking to develop a web-based application using Zoho Creator that allows users to scan QR codes of individual products and barcodes of outer cartons for inventory management purposes. The application will generate reports based on...
...success fee equal to a % of grant funds awarded. Exact terms to be specified in contract. To Apply: Please submit a cover letter , and 2-3 writing samples demonstrating your grant writing abilities to [insert email address]. In your cover letter, please describe your experience with grant writing and why you would be a strong fit for our startup business. We are an equal opportunity employer and value diversity. All qualified applicants will be considered regardless of race, color, religion, gender, gender identity, sexual orientation, national origin, disability status, or any other characteristic protected by law. The contract freelance grant writer will work remotely but must be able to communicate fluently in English via email, phone and video conferencing. This is an exciti...
I am currently facing an issue with my website - when a user registers on the site, instead of being redirected to their profile page or login page, the system keeps them on the same page. Furthermore, upon this failure to redirect, it shows it is successful when registering but doesn't take to another page. I need someone with strong proficiency in HTML, CSS, JavaScript, PHP, and SQL to diagnose the problem and implement a solution so that after successful registration, users are seamlessly taken to their profile page. The ideal candidate should have: - Significant experience in PHP, HTML, CSS, JavaScript, and SQL. - Proven track record in troubleshooting and rectifying website issues. - Firm understanding of user authentication and session management.
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
...intricate elements which are best understood by those well-versed in Simulink. Leveraging your knowledge, I need assistance in modeling simulation, establishing an effective control system design, and performing signal processing. Key responsibilities: - Build a model simulation - Design a stringent control system - Perform signal processing Although the specific task was not clarified, I value a freelancer who can dynamically adjust to the task at hand. Hence, your application should highlight your past work, experience, and a detailed project proposal–these are essential components to your success in this project. The ideal freelancer should display: - Excellent knowledge of Simulink - Previous experience in model simulation, control system design, and signal proc...
I need an expert to create Power BI slides for data analysis. - The primary objective is to assist me in analyzing the data from excel spreadsheets efficiently. - The slides are intended for basic data analysis. Therefore, the level of interactivity required is basic, encompassing features like tool tips and basic filters. Ideal candidates should have: - Proficiency in Power BI for data analysis. - Proven experience working with Excel spreadsheets. - The ability to create easy-to-understand visuals. - Good communication skills to understand the requirements and deliver the project urgently.
...an expert to assist in creating a dynamic Power Bi dashboard. This job should revolve around integrating data from Excel spreadsheets and designing a variety of data visualizations. Key Responsibilities: * Guide me in creating the dashboard on my company account. * Connect the Power Bi dashboard to Excel spreadsheets as the primary data source * Develop compelling data visualizations using pie charts, line graphs, and bar charts * Configure the dashboard to refresh data on a weekly basis Ideal Candidate: * Strong experience with Power Bi and data analysis * Proficient in handling Excel data * Expertise in creating different types of charts * Ability to work with time-based data refreshing schedules Scope of Work: The Initiator engages th...
The objective of this project is to develop a...visibility and ranking in search engine results for relevant keywords and phrases, driving organic traffic and lead generation. - Contact and Support: Provide clear and accessible contact information, including a contact form, phone number, and email address, for customers to easily reach out to Domino Home Services for inquiries or support. We'd prefer to use Wordpress but if you think that another platform is better, we can consider that. You'll need to provide: - the design - the content: we'll provide you with all the information you would need to create the pages. Please start your bid with "I'll be a great fit for this project because". Provide examples of websites you have created that would give...
I need to connect ElevenLabs' text-to-speech API to another tool through Zapier. So far, Elevenlabs' response has been a binary. Instead, I need the audio URL so that the second app I want to connect with Elevenlabs can use the URL in an automation. To participate in this project, you'll need to create your own free accounts for both services. The participant will need to deliver a complete solution that, if possible, doesn't involve hosting the content in a third-party service. To participate, please start your message with "Bonjour". This way, I'll know you've read this instructions. If you need clarification, pleaset let me know.
...includes: - Identifying energy usage patterns to help us understand consumption trends. - Implementing anomaly detection techniques to flag any irregular or unexpected behavior in our system. - Providing actionable recommendations for energy optimization based on the patterns and anomalies identified. Details about the data: I want to have 3 tables: Real time data table: The data will be captured directly from sensors at the form of columns, for example, Device 1, device 2 , device 3, and rows are time captured at growing rate of 1s. the value of the row is the energy consumed of that device at that exact second. This will be a large table. Hourly Data Table: Aggregate data hourly to feed into the anomaly detection model, stored in the 'Hourly' table, to...
I'm looking for an experienced developer to create a multi-tenant marketing dashboard for me. This dashboard should mirror the functionalities of another platform I have access to, but with some additional features. The main features of the project include: - Customizable user interface: The dashboard should allow users to customize their views and layouts to suit their needs. - Reporting and Analytics: I need the dashboard to provide comprehensive reporting and analytics features for tracking: - Email marketing metrics - Lead generation metrics - Social media metrics Additionally, the dashboard should be able to integrate with various third-party applications. These applications include: - Google Analytics - Twilio - Facebook - Instagram - Google Reviews The ideal fre...
I am looking for a professional developer to create a comprehensive real estate website using React. As the client has not specified a particular function, it is anticipated that the ...Strong aesthetic sense for creating intuitive, user-friendly design What to Include in your Application: - Samples of past work, especially of previous real estate websites you've created - Description of your experience with React and with real estate website development - A detailed proposal for the project, addressing all functionalities and anticipated challenges - Any suggestions for adding value to the project beyond the basic requirements I am excited about the possibility of collaborating with individuals who bring passion, expertise, and creativity to the table. Let's build somet...
I need a proficient Python expert to scrape recipes from a designated website to an Excel sheet. The project needs to be completed as soon as possible. You can use this open-source working scraper Key requirements: - Scraping recipe information (name, ingredients, cooking instructions, nutrition facts) from a specific website. - Outputting the scraped data in a well-organized Excel sheet. Ideal skills for this project include: - Proficiency in Python for web scraping. - Familiarity with scraping data from websites. - Excellent organizational and data management skills for outputting the data in Excel. If you can deliver this quickly and efficiently, please feel free to bid.
...this site will be to create a strong online presence for our business and show our target audience the value we provide. Key Deliverables: - A visually engaging and easy-to-navigate website - Proper display and descriptions of our services - Integration of informative resources for potential customers - SEO optimization for enhanced online visibility - Mobile-friendly design for easy access on all devices Ideal Skills and Experience: - Proven experience in web development and design - Extensive portfolio showcasing a variety of websites - Strong understanding of SEO best practices - Proficiency in modern web development tools and platforms - Experience in creating websites for service-based businesses would be a plus. Please include the following in your applicat...
...costs for feedstock and revenue by product including (renewable diesel, LCFS credit prices, RIN prices and any other revenue sources or applicable tax incentives) - Model Creation: Develop a financial cash flow model that can reliably forecast our cash position over the next 3-5 years. Specifically, I'd like to be able to determine the break evens for a particular feedstock price, or incentive value. Skills/Experience Required: - Strong Finance Background: Deep understanding of financial analysis and forecasting. - Research: Ability to find and interpret financial data to inform the model. - Modeling: Proficiency in creating financial models, preferably in the same or similar context. - Data Analysis: Experience in analyzing financial data and trends to make accurate finan...
My project needs an abstract illustration developed for an advertising campaign. It's ideal for a freelancer with innovative skills and experience in graphic design who appreciates the avant-garde: ATTACH is the image, dont need hand and cards. Instead of tshirt, HAT has to be written - Create a visually stri...pulsating with energy. - The illustration should be creatively dynamic yet clear enough to represent my brand's unique qualities. - This piece of work will be pivotal in our upcoming advertising campaign and can characterize our brand's distinctive visual identity. Previous experience with advertising campaigns and abstract visual design is highly desired. Understand my brand, immerse in our aesthetic value, and redefine it into a fascinating and revolutiona...
