Net compare excel filesงาน
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...
ทำระบบการเลี้ยงปศุสัตว์ (Livestock Management) นำเสนอเบื้องต้นของ Development Tools: Front-end: Angular JS Language: .Net Core (Web responsive) Database: SQL Server/Azure SQL Database Operation System: Windows Cloud Solution :Hybrid Azure
ทำ 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)
...ไม่เกี่ยวข้องกับระบบใหม่ e. Source code และสิทธิ์ใน source code ทั้งหมด เป็นของผู้ว่าจ้าง f. ผู้ว่าจ้าง ต้องการเข้าถึง repository ของ source code ด้วย เพื่อประโยชน์ในการ review ป้องกันการสื่อสารผิดพลาด g. Platform NodeJS และ deploy บน Docker หรืออื่นๆ ที่เป็นรูปแบบที่คล้ายกัน h. แยกส่วนแสดงผล (client javascript) และส่วน Api (REST Api อย่างชัดเจน) 2. ระบบเดิม เป็น program บน Windows เป็นภาษา C# .Net framework และ MS SQL server a. เมื่อสั่งซื้อสินค้า จะสร้างข้อมูลการสั่งซื้อใน MS SQL Server และมีใบ PO ออกมา b. เมื่อรับออเดอร์แล้ว จะสร้างข้อมูลใน MS SQL Server และพิมพ์ใบงานส่งให้ฝ่ายผลิต i. ใบงานมี 2 ประเภท ผลิตตามออเดอร์ และผลิตเพื่อเก็บสต๊อก 3. ระบบที่ทำเพิ่ม ต้องการทำงานบน Website โดยใช้งานบนมือ Android, iOS, และ Windows บน Chrome, มีเครื่อง print sticker หลายๆเครื่อง ต่อกับ Serv...
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
Windows .NET พัฒนา loginscript สำหรับ windows10
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ค่าจ้างตามตกลง Programmer C#.Net MS SQL HTML etc.
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I am looking for someone proficient in typing to convert content from a 30 page PDF into Word and Excel documents. The majority of the content will go in Word with a few items to be transcribed into Excel. Requirements: - High typing accuracy and speed - Familiarity with Word and Excel formatting Specific instructions: - For Word, the content should be formatted in Calibri 12 point font and single spaced. - For Excel, maintain one row per entry for optimal readability. Ideal candidates should have prior experience in similar data entry tasks. Familiarity with PDF conversion tools, text formatting, and spreadsheet management would be a plus.
...can export the text and numeric data from a PDF table into an Excel spreadsheet. I would like the Excel data to be organized according to the fields in the PDF table. All fields in the PDF table should be included in the Excel sheet. Key requirements: - Export text and numeric data from a PDF table into an Excel spreadsheet - Organize the data on Excel according to the fields in the PDF table - Include all fields in the PDF table in the Excel sheet Ideal Candidate: - Proficient in PDF to Excel data transfer - Excellent attention to detail for verifying and cross-checking data - Familiarity with text and numeric data formatting in Excel - Capable of delivering accurate and organized final results. There will be 901 rows of Ex...
...someone experienced in installing SSL certificates on Azure hosting. We run two .NET based sites on a single Azure instance - they are: We have control of the domain, but need to work with our client for control of the subdomain. We will purchase a multi-domain Comodo SSL certificate from NameCheap (potentially a new PositiveSSL Multi-Domain certificate again) and have you activate it and install it on the Azure service. The current SSL is due to expire on the 28th May 2024. Key Requirements: - Install the SSL certificate on an Azure instance hosting my two .NET sites. - Ensure that both sites are configured to run with HTTPS. The ideal
...diligent freelancer with strong attention to detail and experience with Microsoft Excel and Shopify for a data entry project. Having a deep understanding of these two platforms is crucial to the seamless execution of the task. The project involves: - Using a spreadsheet to find and identify approx 4500 books on Amazon. - Using an online import tool to bring book data into a Shopify website - Adding extra product information in the shopify website from the spreadsheet about the book. - Determine the genre of the book and categorising in shopify accordingly. The ideal candidate should have: - Proven experience in data entry, preferably within Shopify. - Access to US version of Amazon. - Proficiency in Microsoft Excel. - High level of accuracy and organisation. - Good leve...
As the client, I am looking for a reliable professional to build a customized Excel plugin that will enhance my financial data management. Key Features: - Automatic Calculations: The plugin should be capable of performing automatic calculations, saving time, and minimizing any possible errors. - Data Validation: Ensuring data accuracy is crucial, thus the plugin should include data validation steps that help identify and correct any inaccuracies promptly. - Customizable Formatting: To enable smoother navigation and interpretation, the plugin should allow for customizable formatting tailored to my data and personal preferences. - Model Versioning: Unlike other models that auto-update or create new versions, I require a plugin that allows me to manually select the version to w...
I'm looking for a developer experienced in .NET Core and Umbraco to make modifications to an existing Umbraco project. The main focus will be on changing the CSS and the Free Trial form, which needs to be integrated with a CRM system. Key Requirements: - Proficiency in .NET Core and Umbraco - Skilled in CSS customization - Experience with CRM integrations - Understanding of user authentication in Umbraco The main tasks include: - CSS changes to improve the overall look and feel of the site - Customizing the Free Trial form, particularly: • Layout and design adjustments • Integration with a CRM system for effective lead management Your expertise in Umbraco components, particularly in navigation menus, contact forms, and image carousels, will be beneficial...
I have a list of addresses for invitations that need to be transcribed from a handwritten list into an Excel spreadsheet. The addresses should be formatted consistently in the following structure: Name, Street Address, City, State, Zip Code. - Handwritten list will be provided, and should be transcribed accurately - Standardize the address format for consistency - No correction needed for typos, just ensure the format is standardized The ideal freelancer for this project would have: - Proficiency with Excel for data entry and formatting - Attention to detail to ensure accuracy and consistency - Experience with handling addresses or similar data is a plus
I'm seeking an experienced Excel professional to assist with the implementation of various financial formulas and functions in my spreadsheets. I am trying to create an excel sheet for sales people to put some data entry and get final pricing. i have the basic excel sheet ready, and if you willing to work on it i can share it and explain in more details In particular, I need help with: - The execution and application of financial functions specifically. - An ability to accurately conduct cost and estimating calculations. - Strong problem-solving skills to fine-tune formulas for efficiency and accuracy. A background in finance and substantial experience with Excel's wide array of financial functions would be very advantageous for the successful completion o...
I'm in need of a sophisticated chatbot solution. This chatbot should have the capability to interact with and analyse documents uploaded to it – including PDF, Excel, and Word files. Here is what I am expecting: Document Interaction: • Extract information from PDF, Excel and Word files • Provide document descriptions that enable efficient and informative interactions Graph Generation: • Generate graphical representations from data extracts • Capable of creating bar charts, pie charts, and line graphs Desirable Skills & Experience: • Expertise in Django is a must • A good understanding and experience of GT4 API • Knowledge of ORM and DRF • Familiarity with data visualization may come in handy To recap,...
I need a proficient freelancer to assist in the conversion of a PDF and an Excel file into a CSV format, specifically tailored for WIX integration. Key Requirements: - Conversion of a PDF file into a CSV format. The PDF contains crucial information that needs to be extracted and transformed into an easily readable and usable format for WIX. - The Excel file contains customer data, specifically including names, email addresses, and phone numbers. This information should also be integrated into the CSV file. Ideal Skills and Experience: - Strong expertise in data conversion, particularly from PDF and Excel to CSV. - Familiarity with WIX Integration - including the ability to format the CSV file in a way that is ready for immediate use in WIX. - Experience handling cus...
...around Exotic and Collector Cars. I need a comprehensive market research and Total Addressable Market (TAM/SAM/SOM) analysis specifically focusing on the exotic automotive lending industry. Key Points: - Industry Focus: Exotic Automotive Lending - Information Required: - Market size and growth potential - Competitor analysis - Customer demographics and preferences Target Audience: - High net worth individuals - Car enthusiasts - Exotic car dealerships Ideal Freelancer: - Proven experience in market research and TAM analysis - Specific experience within the automotive or lending industry would be a plus - Ability to synthesize data and provide actionable insights - Understanding of the dynamics and trends in the exotic automotive market - Strong analytical skills and the...
I'm in need of a professional to help populate my BIGIN CRM with contact information from an Excel file. The task will involve: - Transferring data from Columns A, B, C of my Excel file to BIGIN CRM. - Achieving appropriate data segregation based on geographic location within the CRM. This task will require a keen attention to detail and strong experience in and BIGIN CRM and integrate emails to Outlook. A solid understanding and experience in data segregation & bIGIN PLATFORM is also key for successful delivery of this project. The aim is to streamline my contacts for easier management. Your keen knowledge of geography and ability to dissect contact data is highly needed.
...exactly needs to be backed up in a Magento website. - Creating backup files that encompass all necessary aspects of my website. - Completing a full site transfer using the created backup files to preserve integrity and functionality. You must have: - Expertise in website migration, particularly Magento sites. - Proficient knowledge in creating and using backup files. - Familiarity with hosting environments, specifically VPS. - Strong understanding of Magento 2. I am open to guidance on best practices for site transfers and backup file creation. This project requires a careful and knowledgeable freelancer, who can ensure a smooth and successful website transfer. Need help with setting up a Magento site using back up files. The freelancer should be able to...
I am seeking a skilled .NET developer to create a Windows application with the following features: - User Authentication and Authorization: The application should ensure secure user access and have roles-based permissions. - Database Integration and Management: Experience with handling complex data and ensuring its security is essential. - API Integration: The application needs to communicate with external systems through APIs. My primary concern is scalability. The application must be designed to grow and handle an increasing number of users without compromising performance. Hence, I am looking for a developer who can plan and implement a scalable architecture from the very beginning. The ideal candidate should have: - Proficiency in .NET framework, particularly for Windo...
As someone struggling with certain aspects of Excel 2016, I need an experienced VBA Developer who can assist in creating custom Excel functions and rectifying existing Excel errors. Key duties will include: - Macros programming to automate repetitive tasks - Troubleshooting and fixing inaccuracies in the current Excel functions, if any Despite my lack of specificity about the exact functions or errors, I expect the developer to have a strong understanding of Excel functions in general and to use this knowledge to identify any issues that may exist. Ideal candidates should: - Have significant experience in VBA development - Have a solid understanding of custom Excel functions - Be proficient in troubleshooting & error handling in Excel...
I will download and place the files in one folder as requested
I need to have an excel sheet to track expenses made on each items coming under 'purchases for office construction works', stationery for office, project software tool like project management tools, hosting service plans etc also for nterior decoration, expense on inaugration and also i need to list expected cost for future purchases
I am currently in need of a proficient Excel expert capable of aiding me in data analysis for my investment data portfolio. The Ideal Candidate Should: - Have in-depth knowledge and experience in Excel, particularly in handling and managing large amounts of data with efficiency. - Be familiar with investment-related data and understand trends to aid in analysis. - Be able to demonstrate past work on similar projects, ideally in the investment sector. Project Scope: - The task involves in-depth data analysis of my investment portfolio which encompasses various types of data. - The freelancer will need to interpret and analyze the data using advanced Excel formulas and techniques. The successful freelancer should include their past work in their application. An unde...
I require an expert in Python and Excel to assist with data analysis and manipulation tasks. The central focus will be: - Data Reshaping: You'll be transferring data from daily received *.xls files to a timeseries database. Tee database must be updated regularly, every day when one or more new datasets are available. - Data Cleaning: This involves improving the quality of data in our Excel files. Inaccuracies are often a result of missing data, which you'll need to identify and rectify. Key skills and experience needed: - Proficient in using Python with Excel for data analysis and manipulation. - Expertise in data cleaning, particularly in identifying and addressing missing data, double occurences, inconsistent datas - Experience in re...
I'm looking for a VBA programmer to help me with creating custom functions and macros for data analysis in Excel. Key Tasks: - Creating Macros: The project involves developing macros that can automate repetitive tasks and facilitate data analysis. - Building Custom Functions: I need custom functions to aid in data cleaning and manipulation, as well as report generation. Ideal Skills: - Proven experience in VBA programming, especially in Excel. - Strong background in automating tasks and data analysis. - Ability to develop custom functions for data cleaning and report generation. Output: - The generated reports should be in an Excel spreadsheet format, as well as a PDF document. Please provide samples of your previous VBA work, specifically any projects rel...
I'm looking for a skilled MS Excel professional who can work on a multi-sheet file that requires data analysis, formula application, and design enhancements. Key Requirements: - Data Analysis: The primary aspect of this project is to analyze the existing data. - Formulas and Functions: Implementing formulas and functions to drive accurate calculations and insights. - Formatting and Design: Enhancing the visual appeal of the sheets, ensuring they are user-friendly and professional. The file contains 2-5 sheets, and I anticipate that the work will involve a mix of data analysis, formula implementation, and design adjustments. Since I've opted to complete the project, I'm open to any additional suggestions you might have to enhance the overall functionality of the she...
