Data collection reporting using 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
I need an experienced graphic designer who can help me enhance the design of basic ID cards for my organization's 44 employees. Key Requirements: - I will provide an Excel file with detailed employee information. This should be included in the design. - Each ID card should include the employee's Name, Employee ID Number, Date of Birth, Emergency Contact Number, and the Company Address. - The design should be professional and visually appealing. I'm looking for someone who can take on this task urgently and provide high-quality work within a short timeframe. Your past experience in designing functional and aesthetically pleasing ID cards will be a huge advantage.
I'm currentl...connections and functionality. These need to be debugged and resolved. - Adding New Functions: I'm looking to enhance the admin panel with new features in the following areas: - User Management: I need a more robust user management system to be implemented. - Content Management: The content management system should be optimized for smoother operation. - Reporting and Analytics: I require better tools for analytics and reporting within the admin panel. Ideal Developer: The ideal candidate for this project should have: - Extensive experience with CodeIgniter and PHPMyAdmin. - A strong background in resolving database connection errors and functionality issues. - Previous expertise in developing user management, content management, and analytics t...
I'm seeking a specialised CodeIgnitor and phpMyAdmin expert to enhance my betting website's backend. As part of a 5-hour daily commitment, the role involves: - Integrating a UPI payment gateway in the admin panel. I've chosen Google Pay as the preferred UPI platform. - Setting up data analytics and reporting, crucial for measuring and optimizing our betting system's performance. Prior experience with betting sites, UPI integrations and systems reporting is desirable. If you're a driven problem solver who enjoys developing sophisticated functionalities, I'd love to hear from you.
I need a professional freelancer to design an HTML form for my website. This form must have: - Text fields for basic information collection - Dropdown menus for selection options - Capture creation The form should be designed with user-friendly, visually appealing elements. Your role will also include: - Implementing validation requirements for all input fields. This will ensure that the user completes all the required fields in the correct format. - Integrating an email script that will automatically send a reply to the submitter. This is an essential feature for my project. Ideal Skills and Experience: - Proficiency in HTML and CSS for form design - Experience in creating and implementing form validation - Knowledge of backend scripting languages for email automation - Unders...
...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 freelancer for 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.
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...
...{useNavigation, useRoute} from '@react-navigation/native'; import BackButtonHandler from '../BackButtonHandler/BackButtonHandler'; import KeyCenter from '../../utils/KeyCenter'; import {UserType} from '../../UserContext'; const HostPage = () => { const {userId, setUserId} = useContext(UserType); const prebuiltRef = useRef(); const navigation = useNavigation(); const route = useRoute(); const data = ; const userID = userId; const liveID = userId; const userName = 'swapnil'; return ( <BackButtonHandler style={}> <ZegoUIKitPrebuiltLiveStreaming ref={prebuiltRef} appID={KeyCenter.LiveStreamKey.APP_ID} appSign={KeyCenter.LiveStreamKey.APP_SIGN} userID={userID} ...
I'm looking for a freelancer to develop a company profile for my business, with a primary focus on . The profile should be in PDF format and written in English. "Rqeem Valuation & Consulting is a certified entity by TAQEEM for providing business as well as machinery & equipment valuations for different purposes such as M&A transactions, internal decision making, litigation, and financial reporting. As a member of the Saudi Authority for Accredited Valuers (Taqeem), our enduring leadership, collaboration, and focus on anticipating what the future looks like for our clients has positioned us as a trusted partner in the industry." Key Requirements: - The company profile should be compelling, engaging, and concise, tailored to attract potential customers and ...
...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. 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 simulta...
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 an experienced app developer to create a mobile application tailored for airport transfer drivers. The primary function of this app is to assist our drivers in collecting proof of customer no-shows. The app must include the following features: - GPS location tagging: The app should be able to capture and store the precise location of the driver when a photo is taken. - Date and time stamping: Each photo taken should be automatically stamped with the current date and time. - Picture capture functionality: The app should provide an intuitive and user-friendly interface for capturing images. It is crucial that the app also includes a secondary functionality for flight tracking. The app should be able to link to flight schedules, write the time and date of a passenger�...
I am searching for a marketing expert to spearhead a campaign targeted specifically at businesses for my LED lights. The primary goal of this task is to increase sales. With a budget of less than $100, cr...in B2B marketing, ideally in the LED lighting or related sector. - Demonstrable track record in optimizing marketing campaigns to boost sales. - Ability to be resourceful and innovative on a lean budget. Your responsibilities will include: - Creating and implementing a compelling marketing strategy aimed at businesses. - Utilizing efficient marketing methods to sustain the budget. - Regular reporting on campaign performance, sales increase, and cost-effectiveness. Please provide examples of your previous work, particularly any similar B2B marketing campaigns you've succes...
I need to create dynamic 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 or reporting would be a bonus.
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 skilled software developer to create a Windows application that focuses on generating data reports from a SQL database. Key Requirements: - The application must be compatible with the Windows platform - The main functionality of the application should be the generation of data reports. - The reports should be sourced from SQL database. Ideal Skills and Experience: - Proficiency in Windows application development - Strong knowledge and experience with SQL database and report generation - Previous experience with data reporting software would be a plus.
I'm in need of an expert in software engineering, particularly in the realm of Windows game engine development using C#. The project requires the implementation of a robust physics engine into the game engine. Key Requirements: - Proficient in C# programming for Windows platform - Demonstrable experience in game engine development - Strong understanding of software engineering principles The main focus will be on integrating a physics engine into the existing framework of the game engine. If you have experience in creating 2D or 3D physics engines, that would be a huge plus. It is important that you are able to work independently and are self-driven, as the project will involve a lot of individual problem solving and innovation. Experience with multiplayer capabilities would...
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 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 into sales together!
...documentation for external auditors. • Implement and maintain internal financial controls and procedures. Requirements: • Bachelor’s degree in Accounting, Finance, or related field. • Certified Public Accountant (CPA) or similar certification preferred. • Minimum of 5 years of accounting experience, particularly in a corporate setting. • Strong understanding of GAAP and financial reporting. • Proficient in accounting software (e.g., Xero, QuickBooks, SAP, Oracle). • Excellent analytical, problem-solving, and decision-making skills. • Strong attention to detail and ability to prioritize and manage multiple tasks. • Excellent communication and interpersonal skills. Benefits: • Competitive salary and c...
...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 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 group...
I'm seeking a SPSS expert to help me with a comprehensive survey analysis. Key Project Details: - This will involve a full survey analysis aimed at measuring customer satisfaction specifically in relation to CSR. - Your objective will be to gain a solid understanding of how our customers perceive our CSR efforts and its impact on Customer loyalty. Ideal Skills and Experience: - Proficiency in SPSS and survey analysis. - Strong background in market research and customer satisfaction measurement. - Knowledge or experience in CSR evaluation is a definite plus. -Knowledge in Customer Loyalty.
...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 analysis b...
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 Tab...
I'm in need of a comprehensive warehouse inventory replenishment tracking system for our Fastener drawer at Home Depot. The system should have a focus on reporting and analytics, real-time bin shrink, and work with an electronic keypad and analog/digital interface. Key Features: - **Reporting and Analytics:** The system should provide insightful reports on inventory levels and trends. This will help us make data-driven decisions. - **Real-Time Bin Shrink:** I need to know if the quantity of items in the bin matches the recorded amount. - **Interface:** A mobile app interface will be ideal, making it easy for staff to work on the go. Inventory Tracking: - The system should involve manual entry for inventory tracking. The system should be user-friendly an...
I am in need of a skilled outbound appointment setter to assist in generating leads for my ERP solutions, specifically Zoho and Odoo. Key Responsibilities: - Outbound calling to potential clients and setting up appointments for ERP product demonstrations - Maintaining a high level of professionalism and customer service during all interactions - Tracking and reporting on all appointments set, including relevant client information While it's not a strict requirement, preference will be given to candidates with experience in Zoho and Odoo, as they will be able to provide a deeper insight into our ERP solutions and potentially answer any preliminary questions that may arise. Ideal Skills and Experience: - Proven experience as an outbound appointment setter, preferably in the ...
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.
Integrated Al-Quran Education System Development Brief: Create a digital platform for Al-Quran education that features student progress tracking and transparent reporting. The system will utilize PHP Laravel, Flutter or .NET Core, with MySQL/MariaDB on a Linux server. Key Features: User registration for different roles: Admins, Teachers, Guardians, and Students. Payment options both online and offline. Attendance and performance monitoring tools. Video tutorials for Quranic concepts. Requirements: Experience in educational technology. Quick turnaround and budget adherence. Deliverables: Complete web application. User guide and maintenance support. Proposal Needs: Approach, timeline, and cost.
...Description: We are seeking a skilled Freelance Full Stack Developer with experience in AI technologies, web development, and data processing to build an automated pipeline for creating AI images. The successful candidate will be 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 AP...
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 ...
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, p...
