Grab data multiple tabs excelงาน
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)
หาข้อมูล 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'm in need of a professional who can develop a desktop application that can generate add...token. Some key details about the project include: - The token will be built on the Solana blockchain, so experience with this platform is essential. - The desktop application needs to support multiple operating systems – Windows, macOS, and Linux. - The address generation feature should be seamless and reliable. I'm looking for a skilled developer who has experience in creating cryptocurrency-related applications, particularly on the Solana blockchain. The ideal candidate should have a good understanding of blockchain technology and be proficient in developing desktop applications for multiple operating systems. Please provide your portfolio demonstrating your ex...
I'm in need of an AI-Powered Technical Service Desk that can effectively handle a variety of technical issues, particularly those related to hardware, software, and network setups. Overview: I'm looking to create an MVP of an AI-assisted technical service desk tool. The goal is to prototype the core capabilities of ingesting, analyzing, and respondi...Anyone who submits a new bid that is more than 10% of their initial bid will be eliminated due to not doing their due diligence. Final selection will be made on final proposal (time/cost/incentives). If the winner does not perform or communicate, the project will be cancelled and the next bidder will be asked to come in. Payment based on final milestone delivery only. Do not ask for hourly or multiple milestones - I will no...
Desarrollo de Planillas Avanzadas en Excel para un proyecto de consultoria
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.
...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 entered data, ensur...
...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 entered data, ensurin...
...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 the Creator to dev...
I am looking for a skilled graphic designer for a logo redesign project. The goal is to deliver a fresh, modern design that represents our brand identity. I need changes in color scheme, typography, and iconography. I will provide ...color scheme, typography, and iconography. I will provide the correct HEX code (#33a1da) for the new primary color. The deadline for this project is one month. Skills needed include graphic design, logo design, typography, and color theory. A successful freelancer will be able to refresh and modernize our logo while staying true to our brand image. The designer will be responsible for creating multiple logo prototypes and presenting them for our consideration. If you have a portfolio showcasing your logo design skills, please include it in your ap...
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.
I currently use Hawksoft CMS and Marketing 360 CRM. My project requires a platform that integrates these systems with a document signer and a calculator. Key Features: - A 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 t...
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 thumbnail that fits t...
We're looking for a graphic designer to create a fresh, modern logo for a website rebrand. Current site is which will be rebranded as StudentTravel.pro. The ideal candidate will hav...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 to seeing some great designs! Good luck...
This is a one day project. I will provide a spead sheet to be formatted in excel. Debits and credits will be separated and sumed that easy 24 months are involved the files email for additional information.
Project 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 enh...
...create an engaging metaverse with a cartoonish art style. The metaverse should be interactive with customizable avatars and support real-time multiplayer gameplay. Features needed: - Interactive Environments: Users should be able to interact with the world and objects 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 ...
...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 creating valuable content? Join us to develop and execute content marketing strategies that resonate with our target audience and drive engagement. CRO Expert: Do you have a keen eye for optimization and improving conversion rates? Join our team to conduct in-depth an...
I'm looking for a skilled trading view indicator developer to create an indicator based on fair value gaps. The indicator will need to include alerts triggered by specific conditions. Details will be 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...
I need a skilled PHP developer for a 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...
I'm in search of skilled songwriters who can write engaging, catchy, and relevant lyrics fo...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 demonstrate your songwriting skills. -$25 a song if they start growing after release the raise goes with the business so need to be comfortable hustling at first with commissions ...
...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 PowerPoint. - Familiarity with accounting software. Altho...
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 DayA shifts, 1 HfdayA sh...
I am looking for a highly 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...
I'm looking for experienced website developers who can create an E-commerce platform that can handle a variety of payment methods. Key requirements: - E-commerce website: The primary aim of this project is to build a fully funct...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 selling physical goods will ...
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 ...
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.
...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 to. - The following sections are to be included: (1) Name/Contact information (2) Summary (3) Professional Experience (4) Technical Skills (5) Professional Designations (6) Education (7) Certifications. Export formats: - PDF - Word Not sure what format this would best be suited for. Could use Exce...
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
...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 includes facilitating and managing multiple number of games simultaneously. Experience in creating real-time applications with WebSocket or similar technologies is desired. * AI opponent - Should have experience in creating a sophisticated AI system capable of playing chess at various difficulty levels. * Leaderboard tracking - Require experience in creating and managing a leaderboard system that tracks players’ progre...
