Convert list excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...สามารถ 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
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.
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 enhancemen...
I just need someone to open these files in 3ds max and save them as max2021, nothing else. I'll consider it a favor. Thanks in advance.
...optimization strategies that enhance user experience and drive conversions SMM Guru: Do you live and breathe social media? As our social media marketing expert, you'll craft engaging campaigns that captivate audiences and drive brand awareness. Email Marketing Extraordinaire: Are you skilled in crafting compelling email campaigns? Join our team to create personalized email marketing strategies that convert leads into loyal customers. E-Commerce Marketing Maven: Do you have a knack for driving sales in the e-commerce space? Join us to develop innovative e-commerce marketing strategies that drive revenue and growth. SEM/PPC Pro: Are you an expert in pay-per-click advertising? Join our team to manage and optimize PPC campaigns that deliver measurable results and ROI for our...
...in need of a talented WordPress developer to create a professional website for my construction company. I've skipped the specific pages and special features questions, as I'm open to suggestions and best practices regarding what to include to make the site appealing and functional. Key requirements include: - full web design and build on CMS tool like Wordpress, drupal - goal of website is to convert leads to sales calls - need someone with good graphic design experience so that the site has a modern look and isn't too cookie cutter/cheap looking - need to be build for web analytics - below are some examples of sites id like to mimic in a way Ideal skills and experience for this job include: - Proficiency
...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. Although not the main focus, this skill will probably be essential for financial tasks. - Exceptional organizational skills. You should be able to manage various tasks simultaneously without compromising quality. - Excellent time management. Given the volume of work, prioritizing tasks effectively is key. - Strong communi...
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'm looking for a marketing professional who can run a targeted Facebook Pay Per Call campaign. Specifically, I want someone who can reach Spanish-speaking individuals and drive them to call our service for debt settlement. Key Requirements: - Experience: I need someone who has a proven track record in Pay Per Call campaigns, preferably in the financial or debt settlement sector....take the desired action of making a phone call. - Tracking: While I prefer Facebook's native call tracking system, proficiency in any other reliable tracking method would be beneficial. The ultimate aim of this project is to increase the number of phone call inquiries our debt settlement service receives. I'm looking for someone who can not only create engaging ads, but also ensure that they ...
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 need to create dynamic dashboards for health data reporting purposes. My requirements are as follows: • Expertise in da...dashboards for health data reporting purposes. My requirements are as follows: • Expertise in data visualization and dashboard creation using Tableau • Experience in handling health data is favorable but not a must • The dashboard should be interactive • The end goal is to create comprehensive reports generated from our health data through top-tier visualization • Must possess the ability to convert health data into actionable insights through innovative visualization methods The professional I am seeking should have a proven track record in Tableau data visualization and dashboard creation. Knowledge in health data analysis ...
I need to convert my Wordpress website into mobile apps for both iphone and android. I require the converted apps to have push notifications features. Key Requirements: - Convert my Wordpress website to both iPhone and Android apps. - Implement push notifications feature for the mobile apps. Ideal Skills: - Proficiency in converting websites to mobile apps. - Experience in adding push notifications to mobile apps. - Familiarity with both iOS and Android app submission process.
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'm looking for a TikTok influencer to help promote and generate sales for my new takeaway food business. Key Requirements: - TikTok Expertise: Proven track record as a TikTok influencer is crucial also in Instagram. - Sales-Oriented Approach: A strong understanding of how to convert views into sales is highly appreciated. - Video Content Creation: Ability to create engaging product review videos on TikTok, instagram and facebook is required. - Must be based in London. - Must have at least 300k followers. If you're an influencer with a knack for sales promotion and content creation, I'd love to discuss this opportunity with you. Let's drive engagement and sales togther!
I need a skilled professional to convert my medium-sized plastic electrical equipment into a 3D model optimized for 3D printing. Key Requirements: - The item to have the same size as the original model - The final 3D model should be optimized for 3D printing specifically. Ideal Skills: - Experience with 3D modelling and rendering. - Proficiency in 3D printing optimization. - Knowledge of the AnyCubic 3D printer will be a huge plus. Please include a brief overview of your relevant experience when applying. I have some plastic pieces that I need to print out because when I scan them myself there's a little bit of a difference and I need it to be perfect
I'm in need of a skilled typist who can help me convert my PDF documents into editable text. The primary language of the documents is English. Requirements: - Type all the content in the PDFs accurately into a Word or Google Docs file. - Ensuring that there are no typographical or grammatical errors. - No specific formatting is needed, just plain text. Ideal Skills: - Proficiency in English language. - Fast typing speed with high accuracy. - Experience in PDF to Word/Google Docs conversion.
The task is to tag for deletion, the cases on my data sheet that are settled, and where they sold the property, so I can perfect my data in my CRM (Go High Level), so we prospect opportunities. To do this, you need to look up the case number and required you can access the sites from your country of origin either directly of through the use of a VPN. No exceptions! I have attached a sample file so you can see the scale. Only detail oriented, highly organised persons will be considered. Let's see if we are a fit!
I'm looking for an expert in digital marketing. Your role will be focusing heavily on converting leads to purchases and optimizing landing pages for enhanced User Experience (UX). Our mobile pages should be optimised to REDUCE BOUNCE and RETAIN CUSTOMERS. Key Responsibilities: - Develop highly effective digital marketing strategies - Lead generation and conversi...REDUCE BOUNCE and RETAIN CUSTOMERS. Key Responsibilities: - Develop highly effective digital marketing strategies - Lead generation and conversion through Google Ads - Optimizing landing pages for UX Ideal Candidate: - Proven experience in the above. Send examples of Landing Pages that you have designed. Your expertise with our target audience will be crucial for our campaign success. Let's convert leads ...
...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 Marketplace using multiple browsers at once - Can Autopost Facebook Marketplace with Excel Import Format - Autopost Facebook Marketplace Duplicate Product Preventer - Autopost Facebook Marketplace Settings to Prevent Banned Accounts - Auto Post Facebook Marketplace Bulk Edit Facebook Marketplace that has been input - The input Facebook Marketplace Autopost Report & Status can be exported - You can search for Facebook groups based on keywords with the selected sta...
Hello My name is Faisal We have a Tapware company and have photos with white background. We are looking for someone to convert these images into real life realistic photos. Example, we will provide a tap or shower photo with a white Background. See attached example We then want to add this to a bathroom looking image, bathrooms to look like modern Australian. Please provide me with Some similar work you’ve done and pricing Structure
...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 analysis based on the equations given - Document each step of the analysis clearly, ensuring that any reader can follow the process and results seamlessly. Ideal Skills and Experience: - Proven experience in sensitivity analysis. - Strong understanding of Pressure Swing Adsorption processes. - Ability to interpret and implement ...
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 be required to create and ma...
I'm looking for a functional implementation utilizing AWS media convert in a .NET core environment, with a specific focus on video transcoding. - Functionalities: The main functionality to be implemented is video transcoding with the target being MP4 format. - Desired Output: The desired output resolution for the transcoded videos should be 1080p. Ideal Skills and Experience: - Significant experience with AWS Media Convert - Proficient in .NET core programming - Experience with video transcoding technologies - Understanding of video formats, particularly MP4, and resolution settings.
I need an experienced AutoCAD professional to convert 4 hand-drawn sketches to accurate, scaled engineering blueprints. Requirements: - The focus will be on creating basic outlines with dimensions, as opposed to full detail or annotations. - The sketches will need to include Mechanical Symbols. - Additionally, I need a PDF copy of each sketch, scaled to 11"x17" paper size. Ideal Skills and Experience: - Proficiency in AutoCAD for creating engineering blueprints. - Familiarity with Mechanical Symbols and notations. - Ability to work from basic hand-drawn sketches to generate high-quality, accurate plans. - Previous experience in creating scaled PDF copies would be an advantage.
I need assistance with a one-time data entry task into Microsoft Excel. The volume is less than 100 entries. Ideal Skills: - Proficient in Microsoft Excel - Attention to detail - Strong data entry skills Please note that the data needs to be accurately entered and organized in the Excel sheet. The project shouldn't take more than a few hours for someone with good data entry experience.
...responsible for developing a complete solution that includes trend analysis, automated prompt generation, integration with image generation APIs (such as DALL-E, Stable diffusion and MidJourney), backend infrastructure setup, and frontend design. Responsibilities: Trend Analysis: Implement a system to analyze and extract trends from Google searches stored in an Excel file. Prompt Generation: Develop an automated system to convert trend data into creative prompts suitable for image generation APIs. API Integration: Connect with external APIs like DALL-E or MidJourney to generate images based on the automated prompts. Backend Development: Build and maintain a backend system to handle API calls, manage image and data storage, and ensure efficient data flow throughout the app...
I'm looking for a skilled transcriptionist to convert my lengthy PDF manual into a typed format. Here are some key details: - The manual exceeds 100 pages, making the task time-consuming and demanding attention to detail. - The manual is text-based, with tables and diagrams. A Procedure Manual. The ideal candidate will: - Have prior experience in transcription, specifically with lengthy documents. - Be proficient in English, ensuring an accurate transcription. - Be detail-oriented and able to maintain high standards throughout the task. Ensuring the accuracy and completeness of the transcription is crucial. This will be the foundation upon which other team members will build on.
I have some ideas regarding the design of the app but I need assistance in finalizing it. I'm looking for a Flutter developer with experience in Magento to replicate the look and feel of my website in an app. Key Requirements: - Convert ideas into a polished app design - Implement Magento features in the app Deadline: - I'd like the project completed as soon as possible Ideal Candidate: - Proficient in Flutter app development - Experience with Magento - Strong UI/UX design skills - Ability to work efficiently under tight deadlines Please provide examples of your previous Flutter projects and experience with Magento in your proposal.
I have an Excel sheet with construction project data that I'd like to convert into a Power BI report. This sheet includes data from various projects of different types in a mix-use development setting. Key requirements: - Convert the Excel sheet data to a visually appealing and informative Power BI report - Create a Power BI report that can be easily updated with new data and link with Excel sheets - Ensure the report is user-friendly and can be navigated easily - Internal Links within Power BI to enhance user interaction Ideal skills and experience: - Proficient in Power BI, with a portfolio that showcases similar projects - Experience in working with construction project data, preferably mix-use developments - Excellent data visualization and ...
I'm looking for a data expert to merge two sets of data from Excel spreadsheets. The combination should be based on a unique ID field that is generated using fields common in both datasets. Here are the key details: - Data Type: Both data sets are in Excel format. - Merging Output: The final result should be a new Excel spreadsheet. - Matching Fields: There are common fields present in the two datasets that should be used to generate a unique ID for matching. -Filter: There are records that will not be used, but they are easily identified by a unique, consistent value The ideal freelancer for this project should: - Be proficient in Excel and capable of handling small datasets. - Have experience in data merging, particularly based on generated unique iden...
