Simple project based employee timesheet 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
** for whom the specified budget is not suitable, please do not respond to the project ** * Set up link personalization so that by clicking on a link sent from the site, the page opens only to the user to whom it was sent. If clicking on the link will enter the login information of another user, in this case it should not proceed. Configure the correct redirect to the necessary sites * insert a link to a document for download on one of the site pages (this document has already been generated and there is a download link on another page of the site) * Add generation of an invoice for using the site in pdf form (the form will be provided) with saving on the pages in the admin panel and on the user page. * Edit the account pages created in the admin panel, add a filter by user, mon...
I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ideally providing a notification that an error occurred
...establish an e-commerce site akin to Shopify but entirely focused on the upload and download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability to work with various digital file formats. - Att...
Looking to have my existing logo, which is currently in PNG format, converted to a vector image in Adobe Illustrator. Here's what I need from this project: - You will be working with a simple logo, predominantly composed of shapes and lines - Original color scheme must to be kept exactly as is. Consists of one color shape on transparent background - I need the final product in Illustrator format (.ai) and png format Ideal freelancer for this job is someone who is skilled and experienced in Adobe Illustrator, especially in recreating logos. It's important that you have a keen eye for detail to replicate the original logo accurately while maintaining its simplicity. The successful freelancer will be expected to deliver high quality work that reflects the professiona...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to delivering high quality and d...
I'm looking for a skilled developer to create a secure web-based platform. The platform will be used for the creation, distribution, and analysis of various types of questionnaires. Key Requirements: - The platform needs to ensure the security of user data via encryption and secure storage. - The questionnaires to be designed will include both surveys and assessments. - The questionnaires will contain both multiple-choice and open-ended questions. -Reports need to be automated in PDF format -i want to know what software you plan to use fir the user interface and the back end data collection Ideal Skills: - Proficiency in web development, especially in creating secure platforms. - Experience in designing and developing survey and assessment tools. - Familiarity with encryp...
I'm in need of a Cloud-based HPC system for a statistical analysis project. Key Requirements: If you have access to a HPC i need that service for a python code. lets talk about price
I'm seeking a professional graphic designer to bring my brand to life through a modern, icon-based logo. Your design should ideally: - Present a sleek, contemporary aesthetic - Primarily feature the color black Creative mastery of icon-based logo design is a must, and prior experience in creating modern and stylish logos would make you stand out as a candidate. Looking forward to your innovative contributions!
I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)
I'm looking for a skilled developer to create Python-based modeling and simulation tools for UAV Swarms. Ideal candidates should have experience in Python and Machine Learning, as well as a solid understanding of industrial processes and systems. The tools should ideally offer real-time simulation capabilities, data visualization, and the ability to integrate with relevant software. A formal report of the project is required with the simulation and coding work. You may need to discuss these details with me once we get started on the project.
I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel.
I require AutoCAD shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects ...accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and construction of commercial ...
I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.
I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project management principles. I look forward to working with ...
...intelligence. We plan to expand our product offerings in the future. Project Description: We are looking for an experienced web developer to design and develop the corporate website for our company. This will be the first point of contact for potential clients and should reflect the innovation and efficiency of our solutions. The website must be visually striking, high-performing, and user-friendly. Responsibilities: Design and develop a responsive, optimized website accessible on all devices. Integrate a section for our ticket management software, highlighting its advantages such as process optimization and artificial intelligence. Implement an online calculator to estimate costs based on the Chilean UF per employee. Set up efficient communication channels (live...
I'm in need of a freelancer capable of efficient and precise textual data entry into Microsoft Excel. This project requires a keen eye for detail, a high level of accuracy, and excellent organizational skills. You should be fluent in English and proficient in using Excel. To make an informed bid, freelancers should include the following: - Examples of past work related to data entry, particularly with Microsoft Excel. Stats that display the accuracy and efficiency of your work would be a huge plus. - Any relevant experience in data entry or related fields. Please note, attention to detail and Excel proficiency are paramount to this project.
For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.
I am seeking expert-level assistance in writing a performance review to improve the efficiency of approval of time-card process within the deadline. The current recurrent issue is timecard approvals often not being done on time or missing punches. This severely impacts the operational efficiency, and payroll processing for all the employees and I need a plausible solution ...punches. This severely impacts the operational efficiency, and payroll processing for all the employees and I need a plausible solution to remedy this. Key Requirements: - Introduce measures to prevent frequent delays in approving timecards. - Create reminders for the employees to approve time and make necessary corrections in case of missed punches. - Build a smart reminder system for the employee to review...
Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.
I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly beneficial. - Attention t...
I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.
...potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills while significantly contributing to a growing company in the event managemen...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
We are currently in need of a highly skilled and experienced senior software developer to create web-based attendance and payroll software. Key Features: - Time Tracking: Essential for accurately recording hours worked. - Leave Management: Allowing HR to monitor and control employee leave effectively. - Shift Scheduling: Facilitating efficient scheduling and management of employee shifts. - Payroll Functionality: A critical component, ensuring accurate and timely processing of employee salaries and wages. It's beneficial if you have experience in creating applications that may need to potentially interact with existing payroll or HR systems in the future. However, specific integration with these systems at this point is undecided. Your experience in deal...
...enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration and reporting. - High attention to detail. We're excited to colla...
I'm looking for an experienced developer who can create a web-based calendar with a unique feature to allow users to book dates. If a date is unavailable, the application should clearly indicate it. For the view/UI React/It's front-end Library Setting up server, Use , which we'll use it for serve our front-end to talk with our DB Which is MongoDB, the DataBase. To deploy MERN stack app for free, first build your React frontend. Choose Netlify or Vercel for frontend hosting. Connect your GitHub repository and deploy the React app. For the server, select Heroku. Prepare your backend, set environment variables, and follow Heroku's deployment guide. For the database, use MongoDB Atlas, their free tier suffices. Connect your backend to MongoDB Atlas using its URI. ...
I am looking for someone based in the UK to assist me with my online business. The major responsibilities include: - Customer Support: You'll be tasked to answer basic customer inquiries. It's an easy commission based job that anybody can do on side, just the basic requirement is the person should be located in the UK.
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation v...
...functionalities. Project Overview: We are seeking to develop a modern web application using cutting-edge technologies: - Frontend: React.js for dynamic and responsive user interfaces. - Backend: Laravel for robust and scalable server-side logic and API development. To begin, we can provide you with access to a working instance of the current application, which you can run locally using XAMPP or WAMPP. Please ensure that PHP version 5.6 is installed to ensure compatibility and functionality. If you are interested in this exciting project and would like to discuss further details, including access to the existing application and specific requirements, please let us know. Thank you for considering this opportunity to collaborate on a forward-thinking technolo...
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcting country codes. - Timely updates: Experience in...
...manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them Experience in handling and managing sales and expense data is crucial for this project. The freelancer should b...
Design: Need a simple clean website, with a few tabs, About Us, What we do, Contact us etc. Colours: Primarily White and blue with a black footer. Can give more details once we agree a price and timelines
