Automatic updates excel spreadsheetงาน
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)
...- Persons with interest in Japanese tourism - Candidates may be offered more work if their results are good so we look forward to many applicants - Japanese speaking candidates are welcome but candidates who don't speak Japanese are still considered ■Prohibition - Copying or rewriting of any existing content or article already submitted - Submitting products that copied from any result from automatic translation tools or software - Reprinting or leaking of any contents to a third party Plagiarism is crime, and please be aware that there is a case of termination of the contract and legal procedures when such act including "copy and paste" would be discovered....
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
I need you to fill in a spreadsheet with data. ทำงานค้าขายตามตลาดนัด
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I need help with my Microsoft Excel project! Specifically, I require assistance with the following: - **Formulas and Functions:** - Basic arithmetic operations. I don't need anything too complex, just fundamental formula structures. - **Automation:** - No macros for repetitive tasks are required, but I need guidance on setting up conditional formatting rules within the document. I'm looking for a Freelancer who is experienced in Excel and is comfortable with basic arithmetic operations and conditional formatting. You should be able to provide clear, concise, and easy-to-follow guidance. A strong attention to detail and excellent communication skills are a must. If you're proficient in these areas, I'd love to hear from you!
I'm in need of an experienced VBA developer who can create custom macros for me, specifically to assist in automating tasks within Microsoft Excel. I'd like to streamline processes and increase efficiency within the software. Key requirements: - Proficient in VBA: You should be well-versed in VBA programming and have a proven track record of creating efficient and effective macros. - Microsoft Excel expertise: Experience in working extensively with Excel is a must. - Automation focus: The macros need to automate a variety of tasks, including data entry, report generation, and potentially formatting. While the complexity of the data manipulation needed isn't explicitly detailed, please be prepared to work on tasks ranging from basic calculations to more...
...GoHighLevel (GHL) CRM for automated text and phone call follow-ups, as well as to an Excel sheet for manual review and further action. Key requirements: - Pixel Integration: Develop and implement a pixel solution that captures lead data. - Real-Time Collection: Ensure the system collects data instantly when a lead lands on the specified page. - GoHighLevel (GHL) Integration: Connect the system to GHL for automated text and phone call follow-ups. - Excel Integration: Enable the system to send collected lead data to an Excel sheet via email. Ideal skills and experience: - Proficiency in WordPress and pixel integration. - Experience with CRM systems, particularly GoHighLevel (GHL). - Knowledge of data handling and Excel automation. - Strong communication skill...
...with innovative ways to connect our various social media channels to the site to boost traffic from social to web, add api feeds to save content creation writing articles time, and bring tactics and ideas to bring more engagement, with the following key features: - **API Content Feeds:** I need the site to display a variety of content types, including news articles, video content, social media updates and publically valuable content, sports, birth & death notices. The ideal candidate for this project should have: - **Experience with News Media Websites:** Experience in creating personalised news media content and working with API content feeds is a must. - **WordPress Development Expertise:** Proficiency in WordPress development is essential. - **E-Commerce Skills:** Unders...
...need a specialist in server maintenance and troubleshooting, particularly for my Dedicated Linux Server Level 2 Strato. The key tasks required are: - Recovery: I need help with server recovery, the ability to troubleshoot and restore the server in case of failure. - Update: Keeping the server software up-to-date is crucial for security and compatibility. I need a specialist to handle the server updates effectively. Ideal skills for this job include: - Strong expertise in Linux server administration and management. - Proven experience with server recovery procedures. - Proficiency in updating server software without causing disruptions. - Strato dedicated server recovery - Operating system Ubuntu 16.04 LTS 64bit + Plesk Onyx (unsupported) - Ubuntu is outdated therefore weI cant...
I need a freelancer to help me gather phone numbers from clothing stores in County . You'll be provided with the location and shops to focus on. Key Responsibilities: - Utilize street view to identify shops - Collecting phone numbers of all such shops - Organize and input these numbers into an Excel spreadsheet Ideal Skills: - Proficient in using street view and other location tools - Detail-oriented and capable of data entry - Comfortable using WhatsApp for communication This is a straightforward project, but attention to detail is crucial. Feel free to reach out if you have any questions.
I urgently need a Python script created to scrape data from Website 1 and write it to a CSV file. The data I need to extract is specific to TVL daily total. Site: Key Requirements: - Develop a Python script for web scraping - Extract TVL daily total data from - Save the data into a CSV file Ideal ... Key Requirements: - Develop a Python script for web scraping - Extract TVL daily total data from - Save the data into a CSV file Ideal Skills: - Proficient in Python programming - Experience with web scraping tools and techniques - Strong understanding of data handling, especially writing to CSV files - Good communication for timely updates on the project's progress.
...organisation, with defined states, assigned responsibilities, and status updates for the reporter. Additionally, it should include a Business Intelligence (BI) panel with detailed statistics on generated and managed reports. User Interface (UI) Report Form: An intuitive interface for reporters to submit their reports anonymously or with personal details. Reporter Portal: Access for reporters to track the status of their report using a unique code. Task Management for Reports Task States: Each report should go through various states (e.g., Received, Under Review, Under Investigation, Concluded). Assignment of Responsibilities: Ability to assign responsible parties for each state or stage of the report. Notifications: Automatic notifications to the reporter abou...
...management. - Expert knowledge of various safety threats and first-hand experience in planning for and mitigating these issues at events. - Excellent crisis and crowd control management skills. - Relevant qualifications in safety and emergency management NEBOSH ICG as minimum - excellent communication management - experience in generating reports - advanced Microsoft skills particularly in (words, excel and power point) Your role will be pivotal in ensuring our events are safe, enjoyable and error-free. The ideal candidate will anticipate issues before they arise and resolve them swiftly when they do. Your proficiency in maintaining safety at massive events will be the key to a long-term partnership. Location: KSA Period: 3 months (extendable) Commencing approx: Aug-Sep 2024...
...configurable conditions. It should facilitate easy data input from Excel and offer detailed comparisons, with the ability to export results to Excel. Offer Creator: The freelancer should create functionality for users to customize sales offers by selecting and modifying purchase conditions, adjusting margins, and generating offer views exportable to Excel. Order Recording: Develop a user-friendly interface for recording orders by selecting sales and purchase offer IDs, entering customer-requested details, and generating informative tables for efficient processing. Inquiry: Enable users to upload customer lists for comparison with purchase prices, configure margins, and calculate selling prices directly. The module should support export to Excel for conveni...
I am in need of an expert in B2B lead generation to help me with a specific project. The task involves targeting a local area for potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and co...potential angel and private investors for an H.M.O in the health sector. Key Job Requirements: - Identify and compile a list of 50-100 angel or private investors from the local area. - Investors must have a previous history of investing in the health sector. - Delivery of the leads in an Excel spreadsheet format. Ideal Candidate: - Proven experience in B2B lead generation. - Good knowledge of the health sector and investment trends. - Excellent research skills. - Proficient in data management and Excel. - Strong communication...
I need a skilled website developer to create a travel and tourism website using for the frontend and Node.js for the APIs. The prototype will be similar to the following websites: and Key Requirements: Frontend Development: Expertise in Nex...Integration: Knowledge of building SAAS applications and connecting them with brokers through APIs. Design: - I already have a theme in mind. It is the "ghurbo theme" which is a combination of {client's description of the theme}. Deliverables: Fully functional travel and tourism website with frontend built in and backend in Node.js. Admin dashboard for content management and itinerary updates. Integration with broker APIs for seamless booking and package management.
...have a strong understanding and experience in these areas. Key Deliverables: - Develop and implement a comprehensive social media marketing strategy across Facebook, Instagram, and LinkedIn - Create engaging and insightful email marketing campaigns - Increase brand awareness and drive customer engagement - Monitor and analyze the performance of each marketing campaign - Provide me with regular updates and recommendations for optimization Ideal Freelancer: - Previous experience in network marketing, specifically in social media and email marketing - Proficiency in using different social media platforms, especially Facebook, Instagram, and LinkedIn - A creative mind with the ability to come up with unique and original marketing strategies - Excellent communication and reporti...
I am currently in need of a freelancer with proficiency and prior experience in data entry, specifically entering numerical data from CSV files. Key Tasks: - Effici...specifically entering numerical data from CSV files. Key Tasks: - Efficiently enter a large volume of numerical data from digital CSV files. - Guarantee accuracy in all data entries. - Identify any discrepancies or errors in the provided data and report promptly. The ideal candidate will: - Have excellent attention to detail. - Be comfortable working with large data sets and have advanced spreadsheet skills. - Have prior experience with CSV files. - Be prompt and efficient in delivering the task. Please include details of relevant experience and skills in data entry when you bid. Double-check your work for accura...
I'm looking for an experienced Excel Power-BI professional to assist me with various tasks. Key requirements: - Proficiency in Excel Power-BI. - Demonstrated experience in data analysis, dashboard creation, and report generation. - Ability to work with minimal supervision. I will share more details in via chat box. Only interested person placed a bid Thanks
I'm seeking a Django and Python Fullstack developer who can lend their expertise to my application project. The chosen freelancer should excel in creating: - Robust user authentication and authorization systems - Seamless database integration - Responsive design that adapt to various devices I have certain design ideas but I would highly appreciate guidance to help realize these concepts. The freelancer should possess a strong grasp of user-centric design and prove instrumental in translating these concepts into a streamlined, functional, and easy-to-use interface. Ideal skills: Python, Django, Database Management, User Interface Design, User Experience Design, and Responsive Web Design. It's a bonus if the candidate has a knack for making technical functionalities sim...
I'm in need of an experienced SEO specialist who can help me improve search engine rankings for my truck parts and accounting websites. Specifically, I'm seeking someone who can assist me with backlink building. The main go...and of high quality. Since my target market is local, it would be ideal if the backlinks could be sourced from local websites. Key Skills/Experience required: - Proven track record in SEO and backlink building - Understanding of SEO principles for different industries - Prior experience in local SEO would be a plus. I'm looking for someone who can work independently and provide regular updates on the progress of the project. If you're confident in your SEO skills and have experience in similar projects, please reach out - I'm l...
I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
I'm looking for a proficient spreadsheet expert to create a thorough forecast sheet for my new project. I will be providing all required information for our project. It’s a village that we building and we need proper professional spreadsheet done with ( cash in flow and cash out flow. . It should encompass data on sales, expenses, and profits, analyzing trends and variances, while also incorporating a break-even analysis. Key Requirements: - In-depth monthly analysis of sales, expenses, and profits. - Solid experience in applying trend analysis. - Capable of conducting variance analysis. - Skilled in implementing break-even analysis. - Previous experience in creating comprehensive business financial forecasts. The end goal of this project is to have a detail...
I'm looking for a freelancer who can gather and organize data in Excel for me. This will involve gathering specific data, creating an Excel spreadsheet and providing a basic summary of the data. Key responsibilities: - Organizing data in an Excel spreadsheet - Creating basic summary Ideal Skills and Experience: - Proficiency in Excel - Data organization - Data analysis - Chart creation in Excel I may have more projects in the future if this one goes well. Please include your relevant experience in your bid.
I'm interested in purchasing apps that have been released on the Google platform. I'm looking for apps that fall into categories such as entertainment, games, tools, movies, and videos. The desired apps should have the following features: - In-Application migration, and source code signature file and password provided. - Push notifications to keep users engaged and informed about new updates. - Social media integration to help users share their experiences and invite others to use the app. The specific functionalities I seek include: - User profiles for personalized experience. - A robust search functionality for easy navigation. - Video streaming feature to broadcast various contents. - Different levels for games to keep users engaged and challenged. - Categorized tool...
...with a portfolio showcasing similar projects. Design Expertise: Ability to create a website with a modern, clean design similar to Ntiva. The site must feature unique pictures and content specific to Tymor Technologies. 3D Logo and Animations: Proficiency in integrating 3D logos and dynamic animations. Communication Skills: Excellent communication skills with the ability to provide regular updates via WhatsApp. Timeline Commitment: Ability to deliver a sample home page within 1 day of the start date and complete the entire website within 2 weeks. Content Development: Capability to create and integrate 25+ content-rich pages. Hosting Knowledge: Familiarity with WordPress, which is already active for hosting on our domain. Professional Input: Ability to provide examples and ...
...features. Phase 4: Integration and Testing (3-4 weeks) • Integrate frontend with backend. • Conduct unit testing, integration testing, and user acceptance testing. Phase 5: Deployment (1 week) • Set up the production environment and deploy the website. • Ensure domain and hosting are configured. Phase 6: Post-Launch Support (3 months) • Monitor the website for any issues. • Provide bug fixes and updates as needed. • Offer user support. Technology Stack Frontend: • HTML, CSS, JavaScript • Framework: React.js (or Angular/Vue.js) Backend: • Node.js with (or Django/Rails) • Authentication: JWT or OAuth Database: • PostgreSQL or MySQL Payment Gateway: • Stripe, PayPal, or another secure payment processing service Platfo...
I'm in need of an expert in Excel for a project centered around statistical data analysis. Key Requirements: - I require someone able to handle statistical analysis in Excel. - The data is large and will require a high level of accuracy and attention to detail. - Since the data source is not specified, you should be flexible and able to adapt to varying data types. Ideal Skills and Experience: - Proficient in Excel, especially in handling large data sets. - Experience with statistical analysis in Excel. - Previous success in providing accurate data analysis. Please note the source of the data is not explicitly mentioned, so experience with different data types is a plus.
...fleets and managing stock, and facilitating seamless communication with our workshop. The application should include the following features: - Fleet Maintenance Organisation: An effective and user-friendly system to manage our service schedules and gather data on both maintained and pending cases. - Comprehensive Service Dockets: Tools to record detailed information on every job, including automatic cell population for standard information. - Stock Management: Features to keep track of tyres and other parts available in each of our service vehicles. - Reminder system: Identifiers to highlight upcoming work and parts requiring attention, ensuring our team is always prepared. - Location Tracking: Can track service trucks to optimize routes and service delivery. - Time Managemen...
I need a freelancer who can seamlessly import several Excel sheets into my ERP system, ERPnext, without the need for data validation. The data includes items, journal vouchers, invoices, and stock entries. Key Requirements: - Importing 3+ Excel sheets for Items and Stock Entry, and likely more than 3 for JV and PDC. - Understanding of ERPnext data import structure. Skills Required: - Proven experience with ERPnext data import. - Advanced Excel skills for handling large datasets. - Attention to detail and accuracy in data handling.
...data to a database. Here are the specifics: - **Export Data:** The form's data should be exported in Excel format. - **Client Communication:** The data collected needs to be sent to the client as a PDF document. - **Form Fields:** The form should include fields for 'Contact Information', 'Service Request Details' and 'User Feedback'. This project also includes the task of taking a form I already have in PDF format, and converting it to a WPForms. Please note that this form is quite complex, so experience with custom fields and complex form layouts is desired. Ideal candidate should have: - Strong command of Wordpress, specifically WPForms - Experience with exporting to databases and Excel - Proficiency in generating PDF documents fro...
