Macro refresh excel web query refresh timeงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
1.พัฒนานะบบ IOT ดึงข้อมูลจาก PLC แล้วนำมาแสดงผลในรูปแบบ Web Site โดยแสดงข้อมูลเป็น Real Time 2.สามารถใช้อุปกรณ์ของของบริษัท (Embedded PC) มี SIM ออก Internet ได้ หรือสามารถใช้อุปกรณ์ที่ผู้พัฒนาถนัด แต่ต้องเป็นอุปกรณ์ที่ทนต่อสภาพการใช้งานในโรงงานครับ (ความร้อนและฝุ่น) 3.สามารถใช้ Server ของบริษัทได้ สามารถเลือกได้ตามความถนัดแบบ Windows / Linux และ Database SQL , MySQL, MogoDB , InfluxDB เลือกได้ตามความถนัดครับ 4.เก็บข้อมูลไว้ดูย้อนหลังได้ 90 วัน
...สามารถ 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)
รูปแบบการทำงาน : 1.เข้าเก็บข้อมูลขั้นตอนการทำงานแต่ละแผนกที่บริษัท (เก็บครบตามหัวข้อที่ได้รับไม่ต้องเข้าออฟฟิตแล้วในช่วงนั้น) 2.พิมพ์สรุปข้อมูลทั้งภาษาไทย ตาม Template ที่กำหนดและรวมเล่ม (ทางอีเมล์) 3. ปรับแก้ไขงานบางส่วนและ ปริ้นท์รูปเล่ม (ส่งงานทางอีเมล์) ระยะเวลาเริ่มงาน เดือนสิงหาคม-กลางเดือนตุลาคม สถานที่ รถไฟฟ้ากรุงธนบุรี (เริ่มงาน 9 โมงเช้า- 5 .30 โมงเย็น) สามารถคุยเรื่องเวลาที่สะดวกและงานที่สามารถรับได้โดยไม่กระทบต่อการเรียนหรือ อื่น ๆ ได้ รายได้ ตามแผนกที่ได้รับมอบหมาย จำนวนงานไม่เท่ากัน ประมาณ 10000-12000 บาท / เดือน หากใครได้ภาษาอังกฤษ มีราคาอีกเรทนึง สามารถตกลงกันได้ ติดต่อ เบอร์ 0927498979 กี้
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...engagement and conversion on our app. The current app is based on an old version of [Airdev's Canvas Framework]() (version: <3.0) **Scope of Work:** - Convert old AirDev Canva based app pages and reusable elements to new responsive engine - Design and build popups for sharing and rating content - Design and build a public page optimized for conversion - Update and refresh the homepage/landing page - Create a faceted search page Optional scope - Custom plugin development (very basic plugin / wrapper for a test/production API) - Update a basic Brand Guideline document (if necessary) **Requirements:** - Strong design and UI/UX skills - Ability to work independently and efficiently - Excellent communication and project management skills - Portfolio showcasing previous
I'm looking for someone to set up an FTP server for us. This server will act as a central location for us to receive Excel spreadsheets daily from our suppliers. We only have limited knowledge of Filezilla, so ideally the server would be set up here and would be easy for us to manage. Key requirements: - The server should allow for file storage and sharing. This is crucial as the primary purpose of the server is to receive stock information in Excel format. - We expect to receive these spreadsheets on a daily basis, so the server should be robust enough to handle this. - Different users will need different levels of access. Suppliers should be able to write to the server but not be able to modify or delete other files. Ideal Skills: - Proficient in setting up FTP ser...
I'm in immediate need of an expert in contractual disputes, specifically in cases involving breach of contract and appeals or claims of ownership. I require a comprehensive analysis and legal advice about a possible future appeal or claim regarding the current sellers' ownership rights. I need this job completed as soon as possible. Your role would include: - Expert advice on my legal position - Guidance on potential responses - Possible courses of action Ideal candidates will have: - Experience in dealing with contractual disputes - Understanding of IP rights - Ability to work quickly, providing accurate and dependable advice. - Expetise in Cooperate law and charges loans regarding real-estate and their companies including off shore companies and loan's
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, ...research skills, and experience in internet research, preferably business-related 3. A native of India, domiciled in Cambodia DELIVERY ELEMENTS: • All relevant news, if reported in the native language (Khmer) must be translated into English • Weblink of the news, together with o Source name o News date Note: Milestone will be released the following week (Monday) after the job completion to give us time to organize the report and contact you if we need additional clarification.
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I'm in need of a skilled Excel expert who can assist with advanced formulas and functions. The main task will be related to carrying over formulas in both the same sheet and different sheets. Key requirements: - Advanced knowledge and experience in Excel formulas and functions - Proficiency in carrying over formulas across multiple cells and sheets - Ability to efficiently manage and implement complex formulas Your responsibilities will include: - Identifying the most suitable formulas based on specific requirements - Implementing the formulas accurately and ensuring they work correctly - Carrying over these formulas as needed across multiple cells and sheets If you're an Excel guru with a strong background in advanced formulas and functions, and are conf...
As someone needing assistance with managing data in an Excel sheet, my ideal freelancer would be highly proficient in Excel and able to work accurately and efficiently. The role includes: - Adding new entries to the Excel sheet including the fields: Name, Email, and Phone number - Updating existing entries with the same data fields - Removing any outdated entries The data should be organized into separate columns for each field for straightforward visibility and access. Besides Excel work, this role involves effective email management related to this data. The ability to multitask while maintaining a sharp eye for detail will be vital for this project. Experience in data management and email handling will be advantageous.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
...has extensive skills in public domain and social media researching. DELIVERY ELEMENTS: -All relevant document and news, if reported in native language must be translated into English -Social media handle of the targets -Weblink of the news, together with + Source link + News date + Summary of the news/information Note: Milestone will be released the following week since we need time to clarify your result....
I'm in need of an experienced individual to expertly handle data entry tasks. Specifically, the role will involve inputting personal customer details into databases. Ideal Skills and Experience: • Proficiency in using Excel • Attention to detail • Experience in data entry, particularly with personal customer details • Ability to handle confidential information responsibly Your primary task will be to input data accurately and efficiently. Please ensure you have the above-mentioned skills before bidding. A keen eye for detail and confidentiality are paramount.
I require an expert capable of uploading an Excel dataset into S3 using Lambda and Snowflake to produce reports. The focus will be on identifying data anomalies over time. Your responsibilities will include: - Loading Excel data into S3 - Implementing Lambda and Snowflake for data processing - Generating time-series reports on data anomalies Ideal skills for this role include proficiency in AWS S3, AWS Lambda, and snowflake, with a keen understanding of time-series analysis in Excel reports. Experience in identifying and analyzing data anomalies is also a key component for this project. The aim is to visualize the irregularity in the data, enabling me to make informed decisions based on these reports.
I need a proficient Excel macro creator to help with tasks involving data automation and formatting. The macro will need to work seamlessly across multiple sheets in Excel 365. Key tasks involve: - Automated data entry across multiple Excel sheets. - Formatting the entered data to adhere to specific standards. Ideal Skills and Experience: - Advanced knowledge of Microsoft Excel 365. - Complete understanding of Excel Macro creation. - Demonstrated ability to automate data entry and formatting in Excel. Your commitment to timely and accurate results will be highly appreciated. Thank you in advance for your time and efforts.
As the project owner, I'm looking for a skilled professional to create detailed AutoCAD drawings for the electrical services of a building. The level of detail required is macro-level, focusing on building wiring. This project is for a college assignment. The project requires the preparation of the following AutoCAD drawings: Containment Drawing: Showcasing the paths and management of electrical conduits and other containment systems. All containment will be mounted on suspended Unistrut brackets, with a minimum of 800mm of space above the false ceiling. Single Line Schematic: A detailed schematic for the main distribution board, illustrating the arrangement and connections of switches, fuses, circuit breakers, and other electrical components. Layout Drawings: These will in...
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex data set...
I am looking for a skilled web designer to revamp my informational website. The main goal of this project is to refresh the design and make it more visually appealing to my audience. I am looking for a creative design style that will catch the eye of potential visitors to my site. Ideal skills and experience for this job include: - Proficiency in web design and graphic design - Experience in revamping informational websites - Knowledge of current design trends and ability to incorporate them into the project If you have a passion for creating visually stunning websites and can bring a fresh perspective to my project, I would love to work with you. Let's work together to revamp my website and make it stand out in a crowded online space. Website is static, it ...
I need a Salesforce Analytics Studio Dashboard builder to assist in creating a real-time data dashboard specifically for our sales teams. am looking for someone who has expertise with building dashboards through Salesforce Analytics Studio, the key features I expect from this dashboard are interactive data visualization, real-time data updates, and customizable filters. The ideal candidate for this job would be someone who has experience with Salesforce Analytics Studio - Experience with Salesforce Analytics Studio - History of creating successful sales performance dashboards
We're looking for multiple competent native English editors to trim content and help us improve English language usage across a large batch of tutorials. Starting with a paid trial. Please bid $18.
Project Title: Description: Seeking a talented designer to refresh our logo. Our current logo features a woman and cocoa beans. However, we'd like to update the logo to better reflect our focus on coffee and pay homage to our founder, who was a pioneering figure in the Kenyan coffee industry. Requirements: Incorporate a woman figure in the logo to represent the founder of our Coffee Company. The woman should exude strength, resilience, and leadership. Replace the cocoa beans in the current logo with coffee beans to reflect our primary product. Maintain the overall style and color scheme of the current logo, as we are attached to its aesthetic appeal. Ensure that the logo is versatile and can be used across various platforms, including packaging, signage, and digital media...
I need an Excel budget tracker developed, with specific focus on tracking and calculating expenses related to my business. - The tool should enable me to manually enter expenses and automatically sort these costs into categories. - The main category of interest is 'Commercial Expenses', so having a well-defined, categorizable section for this is important. - I additionally require a feature for budget calculation, providing an easy-to-understand analysis of financial outgoing compared to overall budget. Ideal freelancers for the job would be those proficient in Excel and financial analytics. Experience in developing similar budget tracking tools would be a valuable addition. I have a base of what I need. I need the budget data tab updated with the new budget as w...
I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the past.
I'm looking for a talented video editor who can enhance my YouTube content. Key requirements include: - Expertise in editing YouTube videos specifically with a dynamic and engaging approach. - Ability to deliver polished edits within a tentative duration of 5-10 minutes per video. - Proficiency in creativity and storytelling,...not specified a particular style. - Willingness to work on a continual basis as the frequency of videos is high. Ideal Skills & Experience: - Prior experience in YouTube video editing. - Proven track record in creating engaging content. - Strong understanding of YouTube best practices. - Capability to work efficiently to meet deadlines. If you are passionate about YouTube content creation and excel in video editing, this could be an exciting o...
I'm in need of a Python developer to build a real-time stock trading application. The application should specifically focus on: - Real-time data streaming: The application should be able to fetch and process stock market data in real-time. - Trading algorithm implementation: I'll need you to implement trading algorithms within the application to automate trading decisions. The platform's API integration required for this application is Zerodha's API. Ideal skills for this project include proficiency in Python, experience with real-time data streaming, and a strong understanding of stock trading and algorithms. Prior experience with Zerodha's API is a plus.
I NEED TO JOB READ Please My name is mojtaba from iran And i living in turkey because i cant live to iran and i need to leave turkey and go to armenia That's why i need to find freelancerin...extensive knowledge of camera settings, lighting techniques, and composition principles. I am proficient in software programs such as Photoshop, Premiere, Davinci, and Lightroom for editing and color grading. I am creative and excel at coming up with unique ideas, and I love working with clients to understand their needs and bring their ideas to life. Communication is key to my work, and I am committed to providing excellent customer service and ensuring that my clients are completely satisfied. I am also highly skilled at time management and always deliver high-quality work on ...
It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.
i need menus extracted from a webpage the most important columns (data points) will be category name product name, product price, product description.
