Macro large database excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
หลังจากลูกค้าโทรเข้ามาเมื่อคุยเสร็จแล้วลูกค้ากดวางสาย หรือ พนักงานกดวางสาย อยากให้หลังจากนั้นประมาณ 20 นาทีให้โทรศัพท์กลับไปหาลูกค้าเพื่อประเมิณความพึงพอใจ โดยใช้ macro-survey เป็นเมนูที่จะโทรออกอัตโนมัติ
...สามารถ 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)
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ต้องการข้อมูลที่ติดต่อได้จริง ของร้านสปา และร้านขายส่งผลิตภัณฑ์เกี่ยวกับสปา ทั่วประเทศไทย (มากที่สุด) ข้อมูลที่ต้องการ -ชื่อร้าน -เจ้าของ/ผู้ดำเนินการ -หมายเลขโทรศัพท์ -หมายเลขแฟกซ์ -หมายเลขโทรศัพท์มือถือ (ถ้ามี) -อีเมล์ -ที่อยู่จัดส่งเอกสาร ***เป็นข้อมูลที่ update ใช้ได้จริงเท่านั้น
I'm looking for a skilled freelancer to help me create a pivot table in Microsoft Excel that will be used to find pricing quicker Key Requirements: - The pivot table must be created in Microsoft Excel. - The purpose of the pivot table is to find pricing easier The data sources which the pivot table will be using are confidential, and will be shared with the selected freelancer.
I'm seeking a proficient individual to help with a data entry project. I have about 40 URLs, from which I need to extract the product names, prices, and descriptions. The goal is to collate this information in a pre-defined Excel template. Key Aspects: - Extract product names, prices and descriptions from 40 URLs. - Populate an Excel file with the gathered data.
I'm seeking a skilled individual with a strong command of Microsoft Excel and Word. The tasks at hand are primarily data entry, table creation in Excel and development of an instruction manual in Word. Key Responsibilities: - Efficiently perform data entry tasks in Excel. - Create tables in Excel to visually present the data. - Develop an instruction manual in Word. Ideal skills for this project include: - Advanced proficiency in Microsoft Excel, with a strong expertise in data entry and structuring information. - Proficiency in creating tables, and potentially pivot tables. - Strong experience in creating documents in Word, preferably instructional or informative content. - Attention to detail, as accurate data entry is vital. - Strong communica...
I am looking for a software engineer / software developer for joint software design and software testing in a large project. Your tasks are theoretical software design and the creation of software design documents that are handed over to programming companies. It is also your job to check the correct execution of the programming (check the code and the functions)
I'm seeking a savvy graphic desi...parents. Key elements for incorporation into the design include: - The university's logo - Our specific color scheme - The university's tagline The ideal freelancer for the job should have: - Expertise and experience in modern graphic design, preferably in the education sector. - Must be comfortable working with specific design elements and color schemes. - Proven experience of designing for large scale formats such as billboards. - An understanding of how to effectively communicate to a varied audience, including students and parents. - should know Corel draw This is an immediate requirement; hence prompt responses and commitment to the deadline will be highly appreciated. Looking forward to seeing your portfolio and discussing po...
I'm seeking an experienced tech professional who can help build a Linux-based mailserver. This project requires knowledge on setting up large number of email accounts and managing manual IP rotation. Key Components would include: 1. Setting up a Linux-Based Mailserver - Your experience setting up mailservers on Linux OS will be important for this task. 2. Adding a Large Number of Email Accounts - I need the mailserver to cater to a large volume of email accounts. 3. Manual IP Rotation - I've opted for manual IP rotation, so your expertise in this area would be a major advantage. 4. Mailserver needs to be able to have an API for us to create mailboxes automatically. Operating systems experience, particularly Linux, and familiarity with the ins and out...
I am in need of a skilled professional who can assist me in setting up the Odoo Books system for my invoicing processes. Requ...Requirements: - Configure the system to enable the creation of goods and service invoices in USD. - Implement moderate customization to the invoice templates, focusing on layout changes and adding custom fields. - Import all of my product information from an Excel sheet. This includes product names and their respective cost prices (which are in INR). Ideal Candidate: - Proficient in working with Odoo Books and setting up invoicing processes. - Experience with customizing invoice templates within Odoo. - Skilled in data import from Excel sheets to Odoo. I look forward to working with a professional who can deliver these requirements effectively...
Generic replied will be rejected. You must have experience in Radix, Scraping Data a...website - Data to be scraped includes textual content , pricing and metadata - Skilled in managing and maintaining the scraped data's quality and relevance This data then needs to be imported into a woocommerce site as a variable product. The ideal candidate should have: - Expertise in working with WooCommerce platform - Proficiency in radix software - Experience in data scraping and storing large volumes of data The scraped data should be imported to my WooCommerce site every month. It's crucial for the service performed to be accurate and thorough. Communication and reliability is key. Please apply with this reference:BPRAD11. Failure to do so will result in your generic applica...
I need a Python expert to create a robust parser for extracting data from large JSON files, each exceeding 10 MB. Key Requirements: - Comprehensive knowledge of Python - Strong grasp of JSON data structures - Experience in handling and processing large data files - Familiarity with data extraction techniques The parser should be highly efficient and capable of managing substantial JSON files seamlessly, without compromising on the speed of execution. I value your expert advice on the most suitable Python libraries to use for optimal results.
Hello to all talented SQL freelancers! We are seeking an advanced SQL specialist with proven experience in handling multi-level marketing (MLM) databases, as well as knowledge of Dolibarr ERP. We need someone who can understand the complex terms associated with MLM compensation plans and create effective SQL queries to extract the necessary data, as well as integrate with Dolibarr ERP systems. Responsibilities: Develop advanced SQL queries to extract data from MLM databases. Understand and apply concepts of MLM compensation plans. Collaborate closely with the team to understand project requirements and goals. Integrate SQL solutions with Dolibarr ERP systems. Optimize query performance and ensure data integrity. Requirements: Demonstrable experience in SQL and PHP. Deep knowledge of re...
I'm in need of an Excel calendar for 2024 - 2025 that will be used for tracking school days off and special events. The calendar should feature the following: - Ability to add and modify events - Monthly view - Color-coded categories - Dates should be highlighted with background color Ideal skills: - Proficiency in Excel, including knowledge of advanced functions - Experience in creating and customizing calendars - Design proficiency to ensure aesthetic and functional layout Look at the Sample
As I aim to identify the key variables in a large cross-sectional data set, I need a professional who can help with a multiple regression analysis. Key Requirements: - Ability to conduct a large-scale regression analysis using cross-sectional data - Experience in identifying key variables in regression analysis - Proficiency in data interpretation and providing meaningful insights from the analysis Your role will be crucial in interpreting and understanding the data to identify these key variables. This will involve the use of statistical tools and an in-depth understanding of regression analysis. It's important to note that due to the extensive nature of the data set, the analysis will require a high degree of accuracy. Ideal Skills: - Strong statistical background...
I'm in need of a virtual assistant to help with a variety of tasks, specifically: data entry, email management, and conducting research. ...help with a variety of tasks, specifically: data entry, email management, and conducting research. Ideal Skills and Experience: - Proficient in Google Docs and Sheets - Experience in managing email inbox - Can attend video calls and meeting to write MOM with clients I'm looking for someone who can commit to more than 20 hours per week. The ideal candidate should have a basic understanding of Excel or Google Sheets. Your job will be to document data, answer emails effectively, and conduct research on various topics. I am looking for someone who is timely, organized, and detail-oriented. Please reach out if you think you are a goo...
As a business owner with a Shopify store, I require an experienced professional to help me with product listing. I have 5000 physical products that I need to be added to my store. Key Responsibilities: - Inputting product details such as title, price, and descr...to be added to my store. Key Responsibilities: - Inputting product details such as title, price, and description - Uploading high-quality images for each product - Ensuring that all data is accurate and consistent Ideal Skills and Experience: - Prior experience with Shopify product listings - Familiarity with product data entry - Attention to detail to ensure accuracy - Ability to work with a large volume of products Please let me know your experience with similar projects and how you plan to manage the high volume of...
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
I am looking for a freelancer who can help create some high quality t-shirt graphic designs with a minimalistic touch. I have a specific color palette in mind that I'd like to use, and the graphics need to be large in size. The successful applicant should have experience designing for apparel and understand the principles involved in creating eye-catching designs. I'm looking forward to finding a talented individual who can help bring my vision to life.
We are a small and international team looking for a long term partnership with individuals or teams skilled in seamless background removal/replacement and retouching - capable of handling large quantities of images daily without compromising on quality. Our budget and payment structure is negotiable and flexible, and we are also open to hiring full time. Applicants must be open to signing an NDA and doing a test so we can assess editing proficiency. Looking forward to hearing from you!
One excel file with macro as per the customer requirement
...identifying IP addresses and locations from emails and VoIP calls. The objective is to pinpoint the sender's location and detect any suspicious activities. Key job requirements: - Technically proficient in tracking IP addresses and locations from emails and VoIP. - Ability to provide a detailed regional breakdown of the identified location. - Should be competent in processing and analyzing large data sets, as I will provide all the necessary emails and VoIP phone numbers for tracking. Desired experience: - Previous experience in similar projects concerning cyber security and digital forensics is a big plus. - Advanced analytical and problem-solving skills are necessary. - Proficiency in tools related to data gathering, IP tracking, and location identification is e...
I am seeking an experienced freelancer who is proficient in data mining tasks in Excel. the analysis must done in excel by installing the data mining tools in excel The ideal applicant should be capable of installing and executing data mining tools in Excel. Unfortunately, I cannot specify what data mining tasks will be performed, nor the type of data provided for the analysis as these details are not available just yet. However, in order to be eligible for consideration, please include: - Detailed project proposal showcasing your approach to data mining tasks. Feel free to inquire if you need any more details. A strong understanding of data mining in Excel is essential for this task. Looking forward to your proposals.
As a business owner, I need a data entry operator who is proficient and experienced with Excel formulas. This is fairly urgent, and I am looking to make a quick hire for this role. The complexity of the task at hand includes: - Data entry with calculations - interpretations are not necessary - The project needs to be completed as soon as possible The ideal candidate for this job would possess: - Speed and accuracy for data entry tasks - Strong proficiency with Excel - A deep understanding of Excel formulas - The ability to work under tight deadlines I look forward to seeing your bids and working with you. Thanks!
I need a knowledgeable and experienced pivotchart expert in Excel, who can assist in creating a line chart to visualize my customer data. This chart should effectively illustrate the purchasing behavior of my customers over time. A deep understanding of customer trending and Excel pivotchart is essential. Key Requirements: - Expertise in Excel pivotchart (specifically line charts) - Ability to analyze and visual customer data - Experience in monitoring customer purchasing trends - Quick and efficient work pace - Attention to detail and accuracy - Excellent data visualization skills This role requires strong organizational and analytical skills. Previous experience in similar tasks is highly valued. I look forward to seeing your bids.
...Salesforce. This integration aims to effectively manage and synchronize customer data, ensuring data consistency across all platforms. Key Responsibilities: - Establish a reliable integration process that will ensure all customer data in Orderwise is reflected in Salesforce, and vice versa. - Provide real-time synchronization operations to ensure accurate, up-to-date information. - Ability to handle large amounts of data without compromising the system. Ideal Skills and Experience: - Proven experience in integrating ERP systems with Salesforce. - Familiarity with Orderwise systems. - Proficient in customer data management. - Ability to solve complex integration issues. - Effective communication skills to explain technical processes simply. I look forward to working with pro...
I'm in search of a project coordinator with a background in team coordination and excel. The selected individual will be primarily responsible for planning and organizing a one time project, it will be plotting out some meetings and planninh some deadlines in excel. I'd like to ask them questions while they plan it out if possible! Key Requirements: - Strong Experience in Project Management: This is the most critical requirement. Experience in managing technology-related projects is highly preferred. - Strong Organizational and Time Management Skills: Ability to organize tasks efficiently and manage deadlines effectively. - Excellent Communication and Interpersonal Skills: Ability to communicate effectively with team members, stakeholders, and clients.
I'm seeking a seasoned graphic designer who can convert a JPG image into a vectorial file. This vector will be used to print a large poster. Key Skills and Experience: - Excellent command of vector graphics software (such as Adobe Illustrator) - A keen eye for translating details and preserving the integrity of the original image in the vector format - Proven experience in art involving geometric shapes Scope of Work: - Create a sharp, detailed vector that can scale for large prints without loss of quality - The vector will primarily consist of geometric shapes - Ensuring the vector is print-ready for large poster output. Please share your portfolio of relevant projects when bidding. Thank you.
I'm looking for an expert in traditional farmhouse design to help me craft a beautiful and authentic layout for my new home. What's unique about this project is the number of bedrooms - I only need on...skills to understand my vision Despite the reduced bedroom number, I expect a well-proportioned design to fully utilize the intended space. You should have a keen eye for detail to ensure the end result is a practical and charming home. Since I haven't specified a certain feature as the most important, a balanced understanding of the traditional style's components, like a spacious outdoors and large kitchen area, is crucial. If you have a portfolio of similar projects, please feel free to share it. I look forward to collaborating with someone who shares my lo...