Activity log macros 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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
กรอกข้อมูลในสเปรดชีต Everything about data entry ,ms word .ms excel
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I need to work in a excel doc to do a macro to calculate new prices and add some other information.
*this task is for beginner level person only I am looking for beginner level Excel expert only. Please note that this is fixed price project and not per hour. Please no place holder bid. Please bid with your final price only. I'm looking for a professional to help me format a large Excel sheet and assist with some data analysis tasks.
I am looking for an experienced IT professional or team to implement an employee tracking tool on our Windows server. The tool will be used to monitor employee activity, with specific focus on screenshot recording, application time summary and URL time summary. - **Main Features**: The tool should be able to capture screenshots, track time spent on various applications, and summarize the time spent on different URLs. - **No Real-Time Alerts Needed**: We do not require real-time alerts for any employee activities. - **No Integration Required**: The tool does not need to integrate with any other software or tools. The tool we are considering for this project is available at this link: We are open to other open-source employee monitoring software as well
I'm working on a new c2cWorldTV website and I need an experienced WordPress coder who can seamlessly integrate specific BuddyPress functionalities into the new BUILD template. Key functionalities to be integrated include: - User messaging - Group creation and management - Activity streams - Live phone connect capabilities similar to Facebook or Zoom - Image and streaming uploads - Sharing options to cellphones and other platforms - Event planning tools for organizing and managing events within the community. - Advanced user profile customization options including avatar uploads and profile themes. - Customizable notification system to keep users informed about activities and updates. - Friend connections feature to allow users to add and manage friend lists. - Polls and survey...
I'm looking for a script or API that can export my Active Campaign Deal Notes into a CSV/Excel file. Key Requirements: - The script/API must export the Deal Notes in a CSV/Excel format. - The output should include the note content, the date created, and the username of the note creator. Ideal Skills: - Proficient in scripting and API integrations, especially with Active Campaign. - Strong understanding of data export and manipulation. - Experience in generating CSV files from API data. Please, do not apply if you do not have the required skills and experience.
I'm working on a new c2cWorldTV website and I need an experienced WordPress coder who can seamlessly integrate specific BuddyPress functionalities into the new BUILD template. Key functionalities to be integrated include: - User messaging - Group creation and management - Activity streams - Live phone connect capabilities similar to Facebook or Zoom - Image and streaming uploads - Sharing options to cellphones and other platforms - Event planning tools for organizing and managing events within the community. - Advanced user profile customization options including avatar uploads and profile themes. - Customizable notification system to keep users informed about activities and updates. - Friend connections feature to allow users to add and manage friend lists. - Polls and survey...
...cleaning of the collected data (e.g., remove duplicates, tokenize text). No need for extensive geospatial tagging or advanced processing—keep it simple. 3. Basic Analysis: Use simple NLP techniques (e.g., sentiment analysis or word frequency analysis) to identify key trends. Build a basic machine learning model (e.g., linear regression or decision tree) to predict disease trends based on tweet activity. 4. Visualization: Create basic visualizations like bar charts or line graphs to show trends. Use tools like Matplotlib or Seaborn for simplicity. --- Deliverables: 1. A small-scale prototype pipeline for data collection, analysis, and visualization. 2. Basic machine learning model implementation. 3. Complete source code and brief documentation (no advan...
I'm Henri John and I'm looking for a developer or a team to create a mobile application for renting e-scooters or e-bikes. The app needs to be compatible with both iOS and Android. Key features: - User registration and login: The app should allow users to create accounts, log in, and manage their profiles. - Payment processing: I need a secure and efficient payment system integrated within the app. While the user skipped the question about how to find available scooters or bikes, I envision a user-friendly interface that could potentially include both map and list views, similar to other rental apps. Ideal skills and experience for this project include: - Proficiency in cross-platform mobile app development - Experience with integrating secure payment gateways - Skill...
...Ideal skills for this job include: - Strong communication and interpersonal skills - Experience in business networking - Ability to represent a company professionally Please note: You will be provided with business cards and brochures to distribute during the event. If you have potential and you are interested, Please send me a message so that we can discuss... we can associate for Post event activity also, if performance is great we can appoint you as Country manager further....
Need an Android app and iOS app for a Blog with the following Features. Need the Project to be completed in 15 Days. Non delivery of the Project will lead to penalty of 10x of the agreed amount 1. User Authentication Module Purpose: To allow users to log in or register and manage their accounts. Components: Sign-up, Login, and Logout screens Social media login integration (optional) User profile management Forgot password functionality Libraries: Firebase Authentication, OAuth, JWT 2. Blog Management Module Purpose: To manage the creation, editing, and deletion of blog posts. Components: Blog post editor (Rich Text Editor) Categories/Tags for organizing posts Save Draft functionality Publishing and unpublishing blog posts Admin interface for managing content Libraries: Custom backe...
...The app should incorporate essential features such as payment gateway integration, product search and filter options, as well as a system for user reviews and ratings. I would like to create the app to purchase and view the videos. I would like to add features like a timer alarm that can be set to remind team member to count minutes of happiness in a journal like page for member to note what activity is being counted as happy. I would like to add future features for members to communicate with each other thru the app and even set up group calls or webinars in app. I would like members to be able to build a profile page that includes a video or 2 and be able to view other members profiles Key Requirements: - Proficiency in cross-platform app development, ideally using a framework...
Need an Android app and iOS app for a Blog with the following Features 1. User Authentication Module Purpose: To allow users to log in or register and manage their accounts. Components: Sign-up, Login, and Logout screens Social media login integration (optional) User profile management Forgot password functionality Libraries: Firebase Authentication, OAuth, JWT 2. Blog Management Module Purpose: To manage the creation, editing, and deletion of blog posts. Components: Blog post editor (Rich Text Editor) Categories/Tags for organizing posts Save Draft functionality Publishing and unpublishing blog posts Admin interface for managing content Libraries: Custom backend API, Retrofit for network requests 3. Blog Post Display Module Purpose: To display blog posts to users. Components: List/...
Pull all data of each publisher as we discussed + create an excel file as you did in the previous job. Delivery in on january 20th
I'...need of a Virtual Assistant to help with remote admin tasks. This role primarily involves data entry of customer information and some spreadsheet work. The ideal candidate must have an intermediate understanding of Microsoft Excel, as tasks will include the use of pivot tables and advanced functions. Additionally, the assistant will be tasked with managing my email. Key Responsibilities: - Data entry of customer information - Email management - Spreadsheet work, including the use of pivot tables and advanced functions in Excel Ideal Candidate: - Familiar with MS Excel and Outlook - Capable of handling basic to intermediate data entry tasks - Able to manage emails efficiently Please provide your hourly rate, inclusive of all fees. The workload might be ong...
I am seeking a Mail Merge expert to assist with document creation from Excel or CSV files. The project involves: - Utilizing a non-specific mail merge platform to execute the task efficiently. - Creating a variety of documents using Mail Merge. - Working primarily with data sourced from Excel or CSV files. Ideal candidates should have extensive experience with Mail Merge, particularly with non-Microsoft or non-Google platforms. Proficiency in handling Excel and CSV files is essential.
I have multiple CSV files containing data downloaded fro...is on extracting specific sales data from these files. Ultimately, I need someone to create a chart or dashboard based on this data, comparing sales across different regions. Key Requirements: - Extract specific sales data from multiple CSV files - Create a chart or dashboard comparing regional sales - Use either Power BI or Excel for the analysis and visualization Ideal Skills: - Proficient in data extraction from CSV files - Experienced in using Power BI or Excel for data visualization - Able to create insightful and easy-to-understand charts or dashboards. Please note, the purpose of this project is to visualize regional sales comparisons. Your expertise and attention to detail will be crucial for the success...
I have a PDF file containing financial data that needs to be converted into an Excel spreadsheet. The data is structured in tables within the document. Ideal Skills: - Proficiency in Excel - Data conversion from PDF - Attention to detail Experience: - Prior projects involving financial data preferred - Experience with PDF to Excel conversion
I'm seeking an Excel expert to enhance a self-grading Excel sheet for beginner students. The goal is to make it more visually appealing and user-friendly based on an example file I have. Key Requirements: - Quick turnaround time (within 2 hours) - Experience in Excel - Ability to implement visual improvements such as color coding, formatting, and graphical elements - Potential for future projects if work is satisfactory The primary function of the Excel sheet will be visual data representation. Please apply if you can meet the requirements and deliver promptly.
I need a Python script that selects bars from a table based on their close proximity. 1. i provide the list of bar names in a city / country 2. find bars / clubs in table that are in close proximity using google api to find lat/lon of venue 3. compile a list of 2 bars and 1 club in close proximity 4. use python code to update starting time of activity in itinerary suggested greedy algorithm, 1. replace a venue from the existing set that has maximum distance to other venues 2. stop iteration when net distance below some threshold Ideal Skills: - Proficiency in Python - Experience with data manipulation and analysis - Ability to work with various data formats Please note that I have not yet finalized all the specifics of the project, but I am open to discussing and refining the ...
I'm in need of a freelancer who can extract text from a PDF into an Excel Spreadsheet. The job requires basic cleaning and formatting of the data in the spreadsheet. Key Tasks: - Text extraction from PDF - Inputting data into Excel - Basic cleaning and formatting of the data Ideal Skills: - Proficient in Excel - Attention to detail - Previous experience with data extraction from PDF Looking forward to your bids.
Hi there, I need someone to manually copy and paste text and numbers from tables in a 90-page PDF document into an Excel template with five predefined columns. Key Requirements: - Combine split sentences into a single line. - Leave a blank line between paragraphs. - Adhere to specific formatting requirements as per the predefined template. Ideal Skills: - Excellent attention to detail. - Proficient in Excel. - Able to follow specific instructions meticulously. Flat rate 5 NZD Bonus: 5 NZD bonus for error-free, on-time delivery. Deadline - one day i.e. 15 Jan 25 Please start your bid "5NZD" I appreciate you reading my post
I'm in need of a professional data scraper to extract contact information from 1400 profiles on a particular website and import it into an Excel CSV file. Key Requirements: - Scraping of 7 specific fields of contact information from each profile, including: - First name - Last name - Email address - Phone numbers - Social media links - Opponent - Win or loss/method Ideal Skills: - Proficient in web scraping tools and techniques. - Excellent attention to detail to ensure data accuracy. - Experience with data processing and Excel. Please bid if you have prior experience in this type of project.
...a skilled Power BI freelancer to assist with creating interactive dashboards, reports, and data visualizations. The ideal candidate will have a strong understanding of Power BI, data modeling, and business intelligence tools, with the ability to turn complex data into clear insights. Key Responsibilities: Design and develop Power BI dashboards and reports. Connect to various data sources (SQL, Excel, cloud databases, etc.) and transform data for reporting purposes. Implement DAX queries and functions for calculated measures and columns. Ensure data accuracy and troubleshoot issues within the data model. Optimize dashboards for performance and user experience. Collaborate with stakeholders to gather requirements and deliver solutions. Required Skills: Proficiency in Power BI and ...
...offline AI model training. Knowledge of database management (PostgreSQL/MongoDB). Ability to create intuitive UI/UX designs for non-technical users. Strong communication skills for creating video tutorials. Deliverables Fully functional Lawyer AI platform with the following: Integration of 3 APIs. Custom admin panel for non-coders to train and manage AI models. Video tutorial explaining: How to log in to the admin panel. How to upload datasets and configure training jobs. How to monitor progress and save trained models. Documentation covering: System architecture and design. Instructions for maintaining and updating the platform. Ideal Candidate Proven track record of building similar platforms or admin panels. Ability to deliver high-quality work within deadlines. Willingness to...
...offline AI model training. Knowledge of database management (PostgreSQL/MongoDB). Ability to create intuitive UI/UX designs for non-technical users. Strong communication skills for creating video tutorials. Deliverables Fully functional Lawyer AI platform with the following: Integration of 3 APIs. Custom admin panel for non-coders to train and manage AI models. Video tutorial explaining: How to log in to the admin panel. How to upload datasets and configure training jobs. How to monitor progress and save trained models. Documentation covering: System architecture and design. Instructions for maintaining and updating the platform. Ideal Candidate Proven track record of building similar platforms or admin panels. Ability to deliver high-quality work within deadlines. Willingness to...
I'm looking to control Liquid Cryogenic Fluid Pumping System, using a Schneider electric Machine Expert and Viso Studio for HMI. The system should monitor and log temperature, pressure and flow rates. Prove safety interlocks and shutdowns. The Liquid Cryogenic Fluid Pumping System takes liquid cryogenic fluid from a vertical tank and supplies the user with vaporized gas at two pressures (high and Low). Pressure is supplied via two 60 hp pumps (P1 / P2) with only one operating at a time. High pressure liquid is fed through an ambient vaporizer with low temperature protection applied downstream. The resulting high-pressure gas is fed to a distribution manifold where gas is fed to either a mid-pressure storage tubes or a high-pressure storage tube. Downstream of each storage ...
I am looking for a way to automatically export and sort timesheet data from Microsoft Teams/Shifts. The timesheet needs to be exported weekly based on our pay period (Friday - Thursday). A new Excel document should be created for each supervisor or team leader, and each staff member should have their own sheet within their teams relevant Excel document. All data in the supervisor documents should be easily readable. If automatic exporting is not possible, the minimum requirement is for someone to manually export the timesheet and copy it into a location where it can be automatically processed, with no additional input required from the staff member exporting the timesheets. The data that needs to be extracted from the timesheet export includes: Date Clock-in Clock-out ...
...across both versions. 3. Backend Maintenance: • Maintain and optimize Laravel-based backend APIs 4. WebSocket Enhancements: Required Skills: • Proficiency in Java for Android development. • Expertise in Flutter for cross-platform development. • Strong experience with Laravel for backend maintenance and integration. • Deep understanding of WebSocket programming • Strong debugging and log analysis skills to identify and resolve complex issues. What We’re Looking For: • Proven experience maintaining or developing mobile applications. • Ability to work independently and communicate effectively with stakeholders. • A proactive approach to identifying and resolving technical challenges. • Experience optimizing ...
I'm seeking an expert in data research who can help me investigate customer data. The primary focus will be on gathering staff contact information for 250 companies. I ... Example of the staff list for first company CRMLS The ideal freelancer for this project should have: - Proven experience in market research, particularly customer data. - Strong analytical skills to interpret complex data sets. - Proficiency in Excel to organize and present the data. The final deliverable should be in the form of detailed Excel spreadsheets that clearly present the researched customer data. Provide First Name, Last Name, Title, Company Address, Company Name, Email, Mobile Phone, Linkedin acount
