Automatically refresh pivot table when data in a sheet changes in excel 2007งาน
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 ที่กำหนดให้
I need some changes to an existing website. เพื่อความทันสมัยและใช้แอปและใช้แอปที่มีให้มีคุณภาพมากยิ่งขึ้น
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
...delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่เลือกด้านบน 1.1.3 แสดงข้อมูล 1 sheet ต่อ 1 ยี่ห้อ 1.2 Upload excel file การกำหนดราคา รถยนต์มือสอง 1.2.1 สามารถ Upload การกำหนดราคา รถยนต์มือสอง จาก excel file ในขั้นตอน Download เพื่อเพิ่มหรือปรับปรุงราคา รถยนต์มือสอง ...
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I have an martingale EA that was design long time ago, but the developer lock it off when it was sent. I need to make some changes but i cant, so i need to do a back engineering or try to open it to make the changes.
I'm looking for a web designer/developer to redesign an IT company's website. The current site has plenty of content but has become disorganized and hard to navigate. The key details of this project are: - Modern and slick design, but we should still be able to display lots of information. - Keeping the existing content: The new design should maintain all the current content and functionalities. - We have had lots of SEO work done throughout the years and we would like to keep as much of that progress as possible, as well as add in some new SEO efforts. - Emphasis on mobile responsiveness: The new website must be highly responsive on all mobile devices. - An organized navigation that is less confusing then the current is a major focus for this project as we...
...seeking a proficient DevOps engineer with expertise in both AWS and Azure platforms to create a Continuous Integration and Continuous Deployment (CI/CD) pipeline. The main duty will be integrating code changes, individual software modifications, into existing code repositories. Need to create a fully functional pipeline with tech documentation and runbooks .. Key Tasks: - Develop, test, and roll out CI/CD pipeline with supporting infrastructure as Code (Kubernetes, Docker) - Manage code releases and updates with popular orchestration tools like : Jenkins , Ansible Ideal Skills: - Proficiency with AWS and Azure cloud platforms - Strong experience with CI/CD - Adeptness with Python, PowerShell programming or any other popular scripting language Th...
I need to be able to create realistic tablecloth images on a table from flat images of the patterns. - Create a render template for realistic tablecloths which can be edited to change the pattern. - 2 shapes are required - rectangular and round - Ideally the table will be in a replaceable kitchen background environment - Finished image should be 4000x4000px allowing for zoom crops to be taken. - Example shape styles are attached
...developer to update my iPad app to fix a server connection issue. The app is currently unable to connect to the server, and this problem needs to be resolved. Once the update is complete, the app should be submitted to the Apple Store, and I require it to be compatible with iOS 12 and earlier. Key Requirements: - Fix the server connection issue preventing the app from connecting - Update the app to be compatible latest ios firmware - Submit the updated app to the Apple Store You should have: - Prior experience in iOS app development, particularly with server connection issues - Ability to navigate Apple's submission process and ensure the app meets their requirements - Proficiency in iOS 12 and earlier, and the ability to make the necessary changes t...
We are looking for a developer experienced in working with the Solana network and trading bots, with a mandatory requirement of being knowledgeable about the Pumpfun platform. Responsibilities: Create a bot/tool to manage trading from multiple wallets on the Pumpfun platform. Enable the bot to generate multiple wallets. Configure Solana quantities to buy per wallet. Develop an auto buy and sell bot to make a project appear legitimate with many sales and buys, thereby boosting projects. Ensure speed execution on the first buys to avoid snipers. The initial buys will be made from different wallets in varying quantities, with all transactions going through simultaneously or with a few seconds' difference. Allow for auto-tipping and priori...
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
I am in need of an experienced developer to customize 6ammart App. The required customizations include user interface changes, additional feature integration, and backend modifications. Key Deliverables: - User Interface Changes: I require color scheme adjustments and layout modifications to improve the overall aesthetic and usability of the app. - Additional Features Integration: I need you to integrate push notifications and a payment gateway into the app to enhance its capabilities - Voucher functionality: Users can purchase vouchers at half price. - Condition: To avail the voucher, the user must share the app link with 10 other users. - Success criteria: If the user successfully shares the link with 10 users, they can redeem the voucher at half price. - ...
I have a financial plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any char...
...We are seeking a skilled and detail-oriented freelance mechanical engineer or designer to work on a comprehensive mechanical design project. The project involves selecting an appropriate architecture for various linkages, creating a CAD model of a mechanism, and effectively communicating through technical drawings. Project Requirements: Architecture Selection for Each Linkage Estimated Time: 3 hours Evaluation Criteria: Creation of a simplified specification sheet Identification and characterization of functions and constraints Hierarchization and creative problem-solving using FAST diagrams Proposal of solutions with clear schematics and sketches Value analysis including criteria, scoring, weighting, and reasoned choices Synthesis of selecte...
I need a freelancer with web scraping skills who can extract product prices and models from my 17 competitors. Ideally, the freelancer should be able to: Extract information accurately and comprehensively. Upload all the extracted information into an Excel sheet. Create a simple online website to facilitate this process. I have hosting and a domain. Enable me to update the extracted information with a single click. Complete this task within a maximum of 48 hours. Please include detailed proposals in your application on how you would approach this project.
Floor joist and beam plan Autocad sheet needed for house plan
...site plugins due to a checksum error. Along with this, I can't download newer versions of WordPress. I also need to make sure that my website is compatible with Consent Mode V2. Your responsibilities include: - Diagnosing and resolving the checksum error that prevents me from updating plugins and downloading WordPress updates. - Ensuring the site complies with Consent Mode V2. - Conducting a thorough evaluation of the website to detect any other issues that could be causing the problem. Skills and experience needed: - Proficiency in WordPress, its functioning, and its common issues. - Experience with plugin management and troubleshooting. - Familiarity with web compliance, especially with Consent Mode V2. - Ability to work around potential issues caused by ...
I am looking for a developer who can create an Android mobile optical reader application using OpenCV for image filtering. The main purpose of the application is to apply image filtering effects to the captured images. I would like to have an application made that will read the rectangular optical form with 25 questions and 5 options specified in the appendix, with a phone camera. Through the application, first the user will enter the answer key of the exam, then the correct/wrong/blank questions should be calculated by determining the options marked with the appropriate image processing algorithm. In addition, the number of times each question was marked as correct, how many times as incorrect and blank should be kept during each determination. The application...
I'm in need of a professional who can perform text editing on a PDF. The changes I require are not too extensive but precise. Key Tasks: - Implement minor text corrections including typos and grammatical errors. - Make necessary content updates such as paragraphs and headers. It's crucial that the final output remains in a text-based format. The document is currently editable, so the process should be smooth. Ideal Skills: - Proven experience in PDF editing. - Strong command over text editing. - Attention to detail for accurate implementation of changes. If you think you're the right fit for this task, I'd love to hear from you.
I have a data in my excel sheet. They are from column A - J, 10 column, 4137 rows of data. The data are in mixed string format, which means all long text mentioning about their company. I need to do some data analysis. So i need help in doing NLP for those data to clean and filter the data. I need help in doing NLP for the data and provide me the python code use to do the analysis, I will need like the summaries of the text. For example, for column Funder Purpose the row contain info like "Since the business started, we have been fully relying on our internal fund. We plan to utilize this fund to support our working capital requirement and operating expenses. Based on our busine...
...their preferred table - Enter their contact details - Indicate special dietary requirements - Specify preference for indoor or outdoor seating - Ensure the website is user-friendly and easy to navigate. Ideal skills for this project would be: - Proficiency in web development - both front-end and back-end - Prior experience in developing restaurant websites or reservation systems would be an added advantage - Strong understanding of UX/UI designs to create an engaging user experience - Able to integrate the website with restaurant's operational system for seamless communication - Attention to detail, especially regarding customer data privacy and security. By creating a comprehensive website, I hope to provide my customers with a sea...
I'm aiming to enhance customer engagement and retention through my website and online digital presence. To achieve this, I am seeking a skilled professional who can bring innovative photography ideas to the table which will be used to update our website and marketing material. We have various sites around the UK and would like premises pictures and on the job professional shots taken. (Please note we are a bodyshop repairer). We are looking at around 50-100 professional shots that we can use, so please feel free to place your bid.
Need to update a recently developed site in WP. Need some minor changes. These changes are probably best if they are based on an hourly rate. Please include hourly rate in y9our response. I don't believe this project will take more than 3-4 hours.
I need a quality writer with expertise in curating cocktail recipes to develop a summer-themed ebook. The intended audience is home bartenders and the recipes should be easy to follow using common household ingredients. Key requirements: - The ebook should include fewer than 50 unique alcohol-based cocktail recipes and food dishes. - Recipes should cover a range of spirits and styles, from classic to innovative. - Each recipe should come with easy to understand cooking instructions and accurate measurements. - Include high-quality images and illustrations for each recipe, if possible. - Easy-to-navigate layout with an index or table of contents at the beginning. Ideal Candidate: - Previous experience in recipe writing or food/cocktail blogging...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" ...
I need a skilled WordPress developer to help me with a range of changes to my current website. Key tasks include: - adding two pages -activating social media icons - Updating and amending content throughout the website I already have all the necessary images, graphics and content for these updates. The focus of this job will be solely on the layout and content modifications.
I'm seeking a skilled content writer to craft a detailed and informative article about coffee tables. The piece should be around 1,200 to 1,500 words and cover various aspects of coffee tables, including their history, different styles and designs, and material options. Moreover, I need the article to highlight the distinctions between residential and commercial coffee tables. Key points to consider: - Research and include the origin and history of coffee tables - Discuss popular styles and designs in the contemporary market - Elaborate on the differences between residential and commercial coffee table considerations - Write in a style that's accessible and engaging for a general audience - Must contain 3 to 5 links as references ...
...seeking someone highly skilled in WordPress, with a strong sense of design, and excellent English proficiency to make comprehensive changes to my company's website. Key Project Components: - **Layout and Design Changes**: You will be responsible for revamping the website's layout and design, ensuring it's clean and professional. - **New Features and Functionality**: I aim to incorporate new filters and category widget to enhance user experience and allow for better navigation and content discovery. The ideal freelancer will: - Have a strong portfolio showcasing their WordPress expertise and design sense. - Be proficient in English to ensure effective communication. - Have experience in adding new features and functionali...
I'm looking for a skilled developer to create a Facebook automation tool that can perform the following tasks: - Automatically like posts where I'm tagged - Provide 150 likes on posts where I'm tagged ( I'll provide 150 accounts but you should show me the demo without these accounts ) - Randomize timing of the likes to appear natural - I should be able to change the main account ( which user tags to gain likes ) The tool should be controllable and customizable on my end, allowing me to adjust the number of likes and timing as needed.
...experienced application developer who is also skilled in UI/UX design to create a futuristic, visually appealing, and user-friendly design for an app I'm developing. Key aspects: - Platforms: The app will be available on both iOS and Android, so you should have experience with both platforms. - Purpose: The app's core function revolves around boosting users' productivity. Hence, it's essential that the UI/UX design enables a smooth and efficient user experience. - Design Style: I have a preference for a futuristic design; think sleek, innovative, and cutting-edge. The ideal candidate should have: - Proven experience in developing and designing productivity apps. - Strong portfolio demonstrating a futuristic design ...
