Excel run multiple macros in sequenceงาน
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...
ทำ 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
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
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 )
I screwed up on the backend of my website. The site is I must have clicked something that removed all the links to...all the links to the socials on the sign up page. I need for someone to do the following: 1. Put the logos back up (it should just be a click of a button. I just don't know which one) 2. I'd like to add two more social link to the list. (patreon & buy me a coffee) 3. I'd like for each person who signs up to get an email thanking them for joining. 4. I'd like to make it so people can't sign up multiple times with the same email address. 5. On wordpress there are numbers for each person who signs up. If I delete a person the numbers don't change order. It would be nice if they did. This isn't a major thing if hard to do th...
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.
...user-friendly log in system with multiple users. - Integration of Hawksoft CMS and Marketing 360 CRM into the platform. - A document signer with the ability for electronic signatures and document tracking. - A calculator that includes formulas for interest and payment schedules. Ideal Skills: - Proficiency in CMS and CRM integration, particularly with Hawksoft CMS and Marketing 360 CRM. - Experience in developing document signing features with elements such as electronic signatures and document tracking. - Strong background in building calculators with advanced financial formulas, particularly those related to interest and payment schedules. - UI/UX design skills, to create a user-friendly interface that seamlessly integrates all these features....
I am looking to fill a longterm editor position for multiple projects for my agency. I am running a short-format content agency that edits videos for various coaches, businesses and podcasts. *The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging.* *I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth.* *You will be paid 7usd for every video-edit.* *The process is super streamlined.* *All videos are tailored by me -> you get the raw footage, edit it and upload the edited videos in a separate folder. I expect a simple thumbna...
...website rebrand. Current site is which will be rebranded as StudentTravel.pro. The ideal candidate will have experience in brand creation and a portfolio that demonstrates proficiency in creating modern, eye-catching logos. Key Requirements: - Use of Blue, Purple and Green colors from the current site (or complimentary) in the design - Logo must embody a Modern style - Target audience is educators, primarily female over 40 years of age - Incorporation of the full site name, '', in the design - No use of globes, airplanes or other tired travel graphics - Will need high and low rez versions in multiple formats, also a greyscale/bw version upon completion of the project Please reach out with any additional questions. Looking forward ...
...Overview: We are looking for a talented web developer or development team to transform our Excel workbook into a dynamic subscription-based web application. This workbook is integral to the operations of multiple educational institutions, featuring data management, automated calculations, and reporting capabilities. Project Goals: Seamless Transition from Excel to Web: Convert all functionalities, including complex formulas and VBA macros, from the Excel workbook into a web-based application. Robust Subscription Management: Develop a modular subscription system that allows for easy updates and the addition of new features. Future-Proof Architecture: The application should be built with scalability in mind, allowing for easy modifications and e...
...within it. - Customizable Avatars: Users should be able to customize their online persona in multiple ways. -Real-time Multiplayer: The metaverse needs to support multiple users interacting in real-time. Interaction: The primary mode of interaction should be through keyboard and mouse controls. A detailed understanding of user controls in a 3D environment is important. Skills and Experience: - Expertise in 3js for creating 3D environments - Experience with creating customizable characters - Understanding of multiplayer game development - Ability to implement user controls for 3D navigation - Previous work with cartoonish art style. Can you build a metaverse? Lets start with a simple empty place we can run around together and speak t...
...digital marketing and ready to take your career to the next level? We're seeking talented individuals to join our dynamic team at zintcs, a leading digital marketing agency in the industry. About Us: At zintcs, we're dedicated to helping businesses thrive in the digital landscape. As a forward-thinking agency, we specialize in providing comprehensive digital marketing solutions tailored to our clients' unique needs. From SEO and social media marketing to email marketing and e-commerce strategies, we leverage cutting-edge techniques to drive results and exceed expectations. Position Available: We are currently hiring for multiple positions within our expert team: Content Marketing Connoisseur: Are you passionate about storytelling and creatin...
...discussed later. Should have complete knowledge on trading view. Multiple timeframes will be used including the seconds timeframes. Key Requirements: Indicator: The focus of this project is to develop a robust trend-following indicator for trading purposes based on Fair value gaps. Details will be shared in detail. Basic knowledge about fair value gaps required. Platform: The indicator should be specifically designed for the trading view to work on all platform. Alert System: The indicator will need to include an alert system that can be triggered by specific conditions. These conditions will be determined by the indicator itself. Ideal Skills and Experience: - Proficiency in Trading View Indicator Development - Extensive experience in developing trend-...
...project that requires merging multiple images into a single template. The primary task is to overlay images on top of a template, creating a final image that is a combination of all the images. Key requirements include: - Merging multiple images: This project involves overlaying several images on top of each other to create a final composite image. - Positioning and Size: The ability to adjust the positioning and size of the images being overlaid is essential. While I prefer a simple drag and drop tool to adjust these parameters, the output should be precise. - Output Formats: The final image should be available in both JPEG and PNG formats. Ideal skills and experience for this job include: - Strong proficiency in PHP: Since this project will be executed pr...
I'm in search of skilled songwriters who can write engaging, catchy, and relevant lyrics for a variety of genres. Key Requirements: - Genres: Primarily Rap, Trap, and R&B, but also capable of writing for other categories. - Reference Tracks: I have over 40 reference tracks that I'll need you to work with. - Purpose: The tracks you'll be writing lyrics for are intended for promotional and maybe commercial use down the line. Ideal candidates will have: - A strong understanding and appreciation for rap, trap, and R&B music. - Proven experience in writing lyrics for a wide range of genres. - Ability to creatively adapt and work with multiple reference tracks Of me melodizing and flowing. - A portfolio or examples of previous work that demonstra...
I'm in immediate need of a dedicated and dynamic Virtual Assistant to support my growing needs. The ideal candidate will be someone who thrives in managing multiple tasks efficiently and possesses a keen eye for detail. Your main responsibilities will include: The budget is 100 USD a month. ( 6 hours a day, 6 days a week ) - Managing my emails with the utmost discretion and organization. - Scheduling appointments, ensuring I never miss an important date. - Conducting data entry tasks with accuracy. - Performing internet surveys to gather valuable information for projects. - Preparing ad-hoc reports based on collected data and research. Required Skills and Experience: - Proficiency in Microsoft Office Suite, especially in Excel, Word, and P...
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 Day...
...experienced developer specifically skilled in Backtrader and Interactive Brokers integration to create an intricate trading strategy. Key components of this strategy include: - Incorporation of risk management tools to safeguard investments - Multiple time frame analysis for comprehensive market overview - Utilization of Exponential Moving Average (EMA) in decision making I require the strategy's entry and exit criteria to be based on: - Moving average crossovers to identify potential market opportunities - Identification of support and resistance levels to pinpoint price boundaries - Breakout strategy implementation to exploit significant price moves I am open to discussing other elements that you think might be beneficial to the strategy, your in...
I'm looking for experienced website developers who can create an...functional E-commerce platform that can handle transactions smoothly and securely. - Payment methods: I'm looking to integrate the platform with a variety of payment methods, including Credit Card, PayPal, and UPI. Experience in integrating these payment gateways is a must. - Physical products: The platform will be used to sell physical products, so the site will need to be able to handle product listings, shopping carts and checkout processes. Ideal skills and experience: - Proficiency in E-commerce website development is a must. - Experience in integrating multiple payment gateways, ideally including Credit Card, PayPal, and UPI. - Previous experience with developing platforms for se...
...and ensure secure user authentication. Key Features: - Generate new Bitcoin addresses: The wallet must be able to create and manage a sequence of addresses derived from a single seed. - Monitor transactions: The platform should provide real-time updates on incoming transactions to the user's wallet. - Secure user authentication: secure authentication system to protect the user's funds and personal information. Ideal Skills: - Proficient in Bitcoin and Blockchain technology - Strong experience in web development and security - Familiarity with HD wallet implementation - Knowledge in real-time transaction monitoring If you have a proven track record in developing secure, efficient, and user-friendly web-based Bitcoin wallets, I'd lik...
I am seeking a skilled Network Administrator to convert my computer into a gaming server. My interest lies in hosting multiplayer strategy games, therefore, the professional should have a strong understanding of server setup specific to these game types. Important considerations for this project are: - Support for multiple game sessions running concurrently. - Capable of handling a maximum of 50 concurrent players. The ideal candidate will demonstrate proven experience in similar projects and possess detailed knowledge in network administration, particularly in gaming server setups. Please express your expertise in your bid proposal.
I'm using Spring Boot 2.4.5 and looking for an expert in Apache Camel for a complex integration project. Key Requirements: - Handling data integration across various systems, including databases, REST APIs, and file systems. - Primarily, the task involves data transformation. Your role will be: - Developing efficient routes and integration patterns using Apache Camel. - Ensuring seamless data transformation across multiple systems. Ideal candidates should have: - Proficiency in Spring Boot and Apache Camel, with a proven track record of similar projects. - Strong understanding of data transformation techniques. - Familiarity with various types of integration, particularly database, REST API, and file system integration. This is a challenging project and re...
I'm urgently seeking an adept architect who can redesign my semi-detached house into 2 residential units of different sizes. The job requires: - Extensive knowledge in residential layout planning and design - Considerable experience in remodelling homes into multiple units - Strong understanding of space utilization while ensuring privacy - Ability to work under tight deadlines, as I need this project completed ASAP Success in this project would mean a seamless transformation of my semi-detached house into 2 practical and aesthetically pleasing units of different sizes. To manage and maintain builders stage payments at each stage once work completed.
I'm urgently looking for a professional who can create a customizable resume builder for me. It needs to be a simple and effective tool that allows users to easily input their information and then customize which sections and responsibilities they want to include in their resume. As I have experience in multiple industries and blended roles (i.e. Human Resources and Safety), I need to be able to select the responsibilities or accomplishments I wish to include for each past employer. I need to reduce my 5 page resume and tailor each resume for each employer. Currently spending an hour or more to tailor each resume. Key features: - Customizable sections - Ability to choose responsibilities to add for each employer from a list of responsibilities that can be added...
Los datos se los tiene en un archivo de excel, son recetas de cocina y la lista de productos (ingredientes), necesito generar una nueva receta según el pedido del cliente, y consolidar en una tabla la cantidad de productos total y el costo de cada producto (este dato se obtiene del portafolio de productos) que se necesita comprar para la preparación de todas las recetas
I am in need of a proficient developer who can assist me to complete my project on React Js which is a crypto chess game. The ideal candidate should have the following skills and experience: * Frontend development - The design and theme of the game should be in classic style. It's paramount to have a good understanding of user interface and experience. Knowledge of React Js is mandatory. * Backend development - This involves creating a secure and efficient server-side system. Proficiency in Node Js or any suitable scripting language is crucial. * Database integration - You will be tasked with integrating MongoDB into the project. Knowledge and experience in MongoDB use is required. Specific features to be added include: * Real-time multiplayer - This inc...
I'm in need of a highly talented and adaptable video editor who can expertly handle a variety of editing tasks. Due to the undefined nature of the video content, all applicants are required to be proficient in editing videos across multiple genres, from corporate to travel to wedding videos. Skills and qualifications: - Extensive experience in video editing - Proficient in video editing software - Demonstrated ability to edit videos in multiple genres - Precision, attention to detail, and creativity To be deemed successful, freelancers should include in their application: - Portfolio of previous work including but not limited to corporate, travel, and wedding videos. - Relevant experiences related to video editing. - Detailed p...
...to the next. You will complete a rough draft and a final draft for this assessment. Content: You should focus on the information that you think would be most useful to students. You have two options: You can go for breadth, by including material from multiple topics (weeks) covered in the class; OR You can go for depth and include only material from 1 specific topic covered in the class. To demonstrate originality, include information from at least three sources shared with you within this course or the course you choose to highlight in your blog. You may use any assigned course readings or material shared with you by your instructor. Format this paper and cite all information used following APA format. Pictures The blog post should be readable and vi...
...and detail-oriented Accountant to join our finance team. The ideal candidate will have a strong background in accounting practices and principles, with a proven track record of handling complex financial records and reports. This position requires precision and the ability to work under tight deadlines. Responsibilities: • Prepare accurate monthly, quarterly, and annual financial statements. • Manage general ledger, accounts receivable, accounts payable, and payroll processing. • Ensure compliance with all federal, state, and local corporate, payroll, and other applicable taxes. • Conduct regular ledger maintenance and comprehensive reconciliation of all accounts. • Assist in the budget preparation and financial forecasting processes. ...
...developer well-versed in C# and Selenium to create a bot to facilitate automation on Facebook Marketplace. The bot that I'm envisioning would need to perform the following tasks: - Can use multiple accounts, log into several accounts to enter automatic Facebook marketplace listings or Facebook group posts, logged in accounts are saved and can be opened without re-entering the password - Autopost Facebook Marketplace Create Product Title, product description, Product Category, Product Condition, location and product price range, Product Availability, Product Label / Keywords can be separated by commas, SKU Only We Can See. After inputting, you can automatically select a location, especially for the Indonesian region. - Can upload autoposts to Facebook Marketpla...
...attention to detail and excellent organizational skills to assist in a product sourcing and data entry project. This task involves purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 29 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 29 bottles must be labeled in a manner that correlates with the...
Perform an in-depth sensitivity analysis of a Pressure Swing Adsorption (PSA) process for CO2 capture using zeolite 13X. Scale up a CO2 capture system from a small-scale experimental study detailed in the attached research paper to an industrial application focusing on a flue gas stream solely made up of CO2 and N2. This comprehensive investigation can be based on specific equations, data, and parameters that will be provided from a relevant paper. Duties and Responsibilities: - Understand the Base Model: Analyze the experimental study to grasp foundational models and calculations. - Industrial Sensitivity Analysis: Utilize any effective method to scale up these findings to industrial levels. - Use MATLAB, Excel, or any other tool to conduct a detailed sensitivity an...
...attention to detail and excellent organizational skills to assist in a product sourcing and data entry project. This task involves purchasing Orangina soft drink from at least two different stores, entering specific product data on our platform, labeling the purchased items clearly, and preparing for their shipment to Ireland. **Task Overview:** - **Purchase Orangina:** Secure 4 bottles of Orangina from a minimum of two distinct retail locations. Preference for varying shops to compare regional stock variances. - **Data Entry:** Log into our online platform to input two critical pieces of information for each product: the best before date and the store from where it was purchased. - **Labeling:** Each of the 4 bottles must be labeled in a manner that correlates with the e...
Excel Automation of my project and data visualization
I'm in need of an Excel expert who can assist me with data analysis, formulas, and data visualization. The project involves working with a dataset of medium size, specifically, between 1,000 - 10,000 rows. Key requirements for this role include: - Strong understanding of data analysis: The ideal candidate should have a proven track record of analyzing data, preferably in a business context. - Proficient in formulas and calculations: You should be very comfortable with advanced Excel formulas and calculations. - Data visualization skills: The ability to present data in an easily understandable and visually appealing way is crucial for this project. Specific functionalities and tools that need to be utilized include: - Pivot Tables: You will ...
