How to delete large sets of data 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...
ทำ 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 ที่กำหนดให้
...Donors • View Organizations - Display story and donation method selection • Donation Status - Display result of the payment from Payment Gateway, Direct Transfer, or Rabbit Line Payment • List Donation Transactions - Search for all the donation transactions based on the input from donors like citizen id, full name, and mobile number Administrators • Manage Organizations - List all organization that were registered so far and can be filtered by some information • Register Organizations - Input form to register new organizations • Update Organizations - Update form to modify some information about registered organizations • Remove Organizations - A confirmation page to delete an organization • View Do...
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
...create , database retrieve, database update , database delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน 1.1.3 แสดงข้อมูล 1 sheet ต่อ 1 ยี่ห้อ 1.2 Upload excel file การกำหนดราคา รถยนต์มือสอง 1.2.1 สามารถ Upload การกำหนดราคา รถยนต์มือสอง จาก excel file ในขั้นตอ...
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...dashboard will display custom data. - The dashboard should have data filters that allow users to interact with the data, specifically in the form of dropdown menus. - Charts should be easy to understand and navigate. Ideal Skills and Experience: - Proficiency in Tableau: The ideal candidate should have a strong background in creating Tableau dashboards with complex data sets and interactive elements. - Data Visualization: A good understanding of how to present data in a visually appealing way is crucial. The ability to communicate complex data effectively is a plus. - User Experience (UX) Design: A good understanding of how the end user wil...
I'm in need of a one-of-a-kind abstract high-resolution floral-botanical art print digital file. This digital file should be suitable for printing at sizes up to 48" x 48". Key Requirements: - The style of the art print should botanical, with no specific restrictions on the type of flowers or botanicals included. See photos. - The color scheme should be based on cool tones, specifically blues, greens ,but with pinks. These colors should be harmoniously blended to create a soothing and aesthetically pleasing piece. - The art print's primary motif should be a large scale floral design. This design should be striking and suitable for wall art in a home. Ideal Skills and Experience: - Proven experience in...
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
...strong attention to detail and a good understanding of circuit board layout is crucial for this project. Key Requirements: - Proficiency in Altium Designer - Experience with multilayer PCB design with large PCB Boards - Ability to understand and implement complex circuit board layouts - Attention to detail Please provide examples of your previous PCB design work using Altium. A portfolio demonstrating your experience in multilayer PCB design will be highly regarded. This is an LED board which needs layout editing with adding few more components. Please Show your previous work with dense Layout with Noise and Heat Management of components and PCB. Please also specify your availability of work. Attaching few files ...
...for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simu...
...developer to build a frontend for a Student Management System. Key Project Details: - Two Types of Users: The system will have both admin and normal user functionalities. - Entities: The project involves five main entities: students, admin, class, exam, hall, and scheduling. - CRUD Operations: The system should allow for Create, Read, Update, and Delete operations for the mentioned entities. Admin User Features: - Access Control: The admin user should have the ability to control user access and manage permissions. - Reports Generation: The system should be able to generate exam scheduling reports. I will provide you with the Swaggy API list for this project. The deadline for this project is Saturday night. Ideal skills and experience: - Profici...
I have a large batch of text data in PDF files that needs to be copied and pasted into a specific format. Key Requirements: - Transfer text data from various PDF files - Ensure accuracy and precision in the copying - The time-sensitive nature of the task - The data must be transferred into a format that is easy to work with Ideal Candidate: - Proficient in using PDF files - Strong attention to detail - Previous experience with data entry/copy-paste tasks - Ability to work under time constraints
I have a project that entails exporting contacts from one database and merging them in a particular manner. Here's what I need: • Transferring data between databases -- changing to a new program • Combining the Excel rows into a single cell. Only the address, city, state, zip into one cell. Name, phone, email will stay separate. • The final format for the merged data should be in CSV. Ideal skills and experience required for this project include extensive knowledge about Excel functionalities, CSV formats, and database management. Previous experience with contact data transfer and merging will be highly appreciated. Let me know if you've done similar jobs in the past.
You will take screenshots from various reddit subreddits and make a simple video similar to the format of these videos: @rSlash/videos You must be able to create a quick thumbnail similar to the above with each video. Can use ElevanLabs for voiceovers. -You have an eye for detail - no mistakes. -You are able to create a large quantity of videos, and you do not miss your deadline. Budget: $15 per long form video. They will be in batches, and this has potential to be long-term. If interested, please title your application "Video Editor for Faceless Youtube Channel." Add a link to your past editing samples + confirm that you edit in Adobe Premiere Pro. We will proceed with a short trial assignment.
Objective: Our company aims to automate its logistics process to improve efficiency and reduce manual workload. We are looking for a freelancer with expertise in automation to develop a system that streamlines the process from transport request to courier confirmation. *** Current Process *** (The current process excel files will be given aswell as the detailed process) Request Submission: Teams within the company fill out an Excel file with transport details, including pickup location, destination, size, and weight of the shipment. Courier Selection: The logistician identifies 3 or 4 potential couriers from a database based on the transport's distance, size, and location. The logistician contacts these couriers via Outlook ...
I need a Python script that can batch process text overlay onto images (jpg/png). All the images and all the text will be unique. Each set of text(s) (1-2 sentences) will have its own unique image. (one-to-one) I would like to have a CSV file containing all the unique sets of text. The script would reference a folder of images. The script needs to be able to handle 20-200 images. I would like to be able to change the font style, size, the position on the image, and to have the text be able to wrap to the next row on the image.
I am currently using R, specifically the ppcor package, to conduct partial correlations on a sizable dataset. Unfortunately, the process is slow and fails to address all columns efficiently. I'm seeking assistance to: - Improve the computation speed - Enhance the handling of columns within my dataset The ideal freelancer for this task should be proficient in R programming, with specific experience in working with the ppcor package or similar tools for statistical analysis. A background in optimizing code for large datasets would be highly beneficial.
...professional well-versed in MAXQDA software and data analysis to assist with my upcoming project. The work will involve the analysis of multiple sets of data - primarily surveys, interviews, and focus groups. Key tasks involved: • Coding data sets on MAXQDA • Analyzing coded data • Delivering insightful interpretations of results The job will involve approximately 40 surveys, 12 interviews, and 2 focus groups. It's therefore crucial that the successful individual or team is able to perform this task efficiently, maintaining high-quality data analysis throughout. Having previous experience in a similar job, and professional knowledge of Windows operating sys...
Hi Rahul - I have an excel sheet that we currently use to calculate fees based off different calculations. I would like this form to be simpler, and easier to use.
I'm looking for an experienced Power BI specialist to create a dashboard for me. The data that I would like to be integrated into this system is in an Excel spreadsheet. Key project requirements include: - Creation of a detailed and interactive Power BI dashboard - Integration of Excel data sources into the dashboard - Configuration of the system to ensure real-time data updates Ideal Skills/Experience: - Proficiency in Power BI, particularly in creating dashboards - Experience in integrating data from Excel spreadsheets - Understanding of how to configure real-time data updates in Power BI.
A high resolution interior design (e.g using Vray) of our living room. We like natural materials. We will keep the fireplace with black belgian hardstone. We will also keep the same wooden floor. We also plan to keep the large main eating table with the red lamps, but optionally would be open to different lamp colors there. We likely also would like to keep the one dark grey wall on which the TV is positioned as it was recently painted. If possible a Fen Shui aligned design. The windows in the picture are facing west. We are especially looking for design ideas for a new couch, accessories, living room table and lamp. As well as suggestions for where to place plants. Also where to best place the paintings of our 3 childre...
I'm in need of an expert content creator to help build up my brand awareness targeting spiritual seekers. Your role will be to create an enticing E-book that will appease their spiritual curiosity and further concrete our brand in their minds. Requirements for this project: - Approximately 50 pages - page ratio 3:5 landscape - Exceptionally creative and outside the box thinker. - Experience creating lead magnet starter kits or creative ebooks. - Excellent content creation skills: you should be able to create an E-book that is both informative and engaging with the art direction of "Ancient Modern.". - A thorough understanding of non-religious spiritual and mindfulness practices: it's important to know what...
I am in need of a professional and experienced technical recruiter who can assist in filling multiple IT Project Manager positions in my company. The role will involve conducting interviews, assessing candidates' suitability, and supporting the hiring process until the positions are successfully filled. Key Responsibilities: - Conducting thorough interviews with potential candidates for the IT Project Manager role. - Assessing candidates' qualifications, skills, and suitability for the position. - Collaborating with the hiring team to shortlist and present the most qualified candidates. - Providing feedback and recommendations on potential hires. Ideal Skills and Experience: - Proven experience as a technical recruiter, particularly in ...
I need a skilled photographer to take a large number of high-quality images of industrial parts at specific location(s). Requirements: - Expertise in product photography, particularly with industrial parts. - Ability to shoot more than 50 photos. - Flexibility to work on-site at various locations. - Proficiency in lighting and composition. - Prior experience in studio or on-site product photography. Please provide a portfolio showcasing your past relevant work when applying.
I need assistance with migrating my large WordPress website from GoDaddy to Hostinger. The site is over 100MB in size and includes both custom themes and plugins. Key Requirements: - Migrate large WordPress website (over 100MB) from GoDaddy to Hostinger - Ensure smooth transition of custom themes and plugins I do not require the migration of any email accounts associated with the website. It's crucial that the migration is done swiftly and accurately to avoid disruption to the live site. Ideal Skills and Experience: - Proven experience in large WordPress migrations - Expertise in handling custom themes and plugins - Strong understanding of GoDaddy and Hostinger hosting environments - Excellen...
...freealancer to create an mcq list for moodle quiz website in Aiken formatting. Aiken format I am following is Frusemide tablets 40mg tablets are in stock. How many would you give for a dose of 120mg? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: A Sulphasalazine tablets 500mg are on hand. The dosage required is 2g. How many tablets are required? A) 3 tabs B) 2 tabs C) 4 tabs D) 5 tabs ANSWER: C So can you create options like a teacher, you don't need to know a lot about the topics. If you are wondering, It is nursing mcq (multiple choice questions). I have the questions and answers ready in a pdf. The first 428 questions are ready. Once the Question and Answer pdf is given, In the format mentioned above, just add...
I'm in need of a PHP page that helps our agents to send an order. This page should be intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel...
...following combination of online database and data entry interface from users + a local MS access file. Online Database and web I terface for data entry We want to have multiple users to view and edit information for subscribers (names) in a database. Those users must be able to login on a web page, with a username and password. All users will see same information. But certain fields, those they will be able to edit, will be visible only to that specific user (and admin). Multiple users must be able to enter data (different) for each subscriber. User must be able to filter certain columns, search in all fields, hide/show columns. Online (on web) visible to users, will be only the fields me...
...professional with expertise in deck design and drafting to create permit-ready prints for a large, more than 200 square feet, composite deck. The final deliverables should be ready-to-submit prints for deck build permit application. The candidate with a thorough understanding of composite materials, city codes, and permit requirements will be preferred. Skills and Experience: - Architectural Drafting - Deck Design - Knowledgeable in composite materials - Awareness of city codes and permit requirements Kindly note, the design is for a plain deck – no extra features like built-in seating, planters, or pergolas are required. I'm looking forward to working with someone who can deliver quality work on time....
...assistance in two primary areas to rectify an unexpected issue with a stolen phone and compromised Gmail account. - Bypass Google's second verification: My Gmail account is currently secure with two-step SMS verification. However, the difficulty is that I don't possess access to the phone where the verification code is sent via SMS. Thus, I need assistance in circumventing this verification to recover my Gmail account. - Remote data wipe: Since my phone has been stolen, I wish to delete all data stored on it remotely. I'm looking for a professional with understanding in Google’s verification systems and proficient knowledge in remotely wiping data from an Android device. Privacy an...
I'm in search of a diligent and detail-oriented individual to assist me on a part-time basis with data entry tasks mainly in the finance sector. Key Responsibilities: - Data Entry: You will be responsible for inputting and maintaining various financial data into spreadsheets and databases. - Accuracy and Attention to Detail: Ensuring the provided data is accurately entered, including cross-referencing and validation. - Data Quality: Assisting in maintaining the quality of the data and suggesting improvements where necessary. Skills and Experience: - Proficiency in Microsoft Excel is a must as this will be the primary tool used. - Previous experience in finance-related ...
Necesito crear ficheros XML para ser importados a un ERP (software contable y de producción basica), generados en base a: 1. Una tabla de Excel con información a ser importada. 2. Una estructura XML predeterminada para la creación de ordenes de producción 3. Unas condiciones que hay que cumplir para que se pueda generar correctamente el fichero XML Probablemente una vez realizado el proyecto, se podría se necesitar realizar algunos ajustes o cambios puntuales, que en todo caso serán pagados. El diseño tiene que ser modificable en Visual Basic Busco seriedad, profesionalidad y mucha rapidez.
...efficient data entry professional to handle an important task for my project. Your primary role will include: * Entering diverse types of data (both text and images) into a spreadsheet. * The data will be quite varied, so an ability to handle multiple data types effectively is fundamental. * An eye for detail is essential considering the diverse nature of data that will be input. The ideal candidate should possess advanced MS Excel skills and have considerable experience in data entry. Your ability to manage large amounts of data, and ensure it's correctly and promptly entered into the spreadsheet, will be critical to this role. Familiarity with different types ...
...strong skillset in both Python programming and data science, specifically with a focus on finance who can help complete a project within the next 7 days. Here are the key skills and qualifications I think might be required to successfully complete this project, although I am not experienced in Python so you might find this easier and possible to do well without using as much. > Python Proficiency, as it is the primary tool for this project. > Familiarity with essential Python libraries such as pandas, NumPy, (Matplotlib, Seaborn?), Scikit-learn > Data Science and Analysis: - Data Manipulation: Ability to clean, preprocess, and manipulate large datasets. Skills in visualizing and understanding data tre...
We are in search of a skilled software integrator to help me integrate my personal deployment system with an IA/Chatgpt API. This project involves building and implementing a chatbot that's capable of: - Natural language processing: The chatbot should be able to understand and interpret human language, not just in a literal sense, but also in context. - Chatbot functionality: The chatbot should have the capacity to engage in meaningful conversations with users, along with the ability to learn and adapt over time. - Question and Answers: The chatbot should be able to provide answers to frequently asked questions and find relevant answers from PDF files content. Experience and Skills: - Strong understa...
