Extract database information excelงาน
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)
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
ไฟล์ template ที่มีให้เป็น .AI ต้องการใส่ข้อมูลลงใน template มีข้อข้อมูลต้นฉบับให้เป็น ไฟล์ pdf ให้ใส่เนื้อหาและจัดเรียงตามตัวอย่าง (file pdf) จำนวน 39 หน้า
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ต้องการข้อมูลที่ติดต่อได้จริง ของร้านสปา และร้านขายส่งผลิตภัณฑ์เกี่ยวกับสปา ทั่วประเทศไทย (มากที่สุด) ข้อมูลที่ต้องการ -ชื่อร้าน -เจ้าของ/ผู้ดำเนินการ -หมายเลขโทรศัพท์ -หมายเลขแฟกซ์ -หมายเลขโทรศัพท์มือถือ (ถ้ามี) -อีเมล์ -ที่อยู่จัดส่งเอกสาร ***เป็นข้อมูลที่ update ใช้ได้จริงเท่านั้น
I'm seeking an experienced developer to assist in optimizing database speed for my Node.js website. Key tasks: - Conduct initial review of current setup, hosted on a Hostinger VPS with a configuration of 16GB - Advise and implement changes to improve response time, usining knowledge of different hosting platforms such as Amazon Web Services, Google Cloud Platform or Microsoft Azure. - Familiarity with MySQL as a database management system is a must. Ideal candidate would possess keen problem-solving abilities, strong knowledge in database management and previous experience with Hostinger VPS. Experience is optimizing Node.js websites is advantageous. Please provide examples of similar assignments in your proposal.
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
I require a software solution that can extract and unlock full calibration data from a sensor for further analysis. The software must have the ability to interact with the sensor via USB connection. Key Features: - should be able to fully extract the calibration data from the sensor - the tool should be user-friendly and have a clear interface - the software should have a USB connection for the sensor - the software should be able to output the data in a readable format for further analysis Ideal Skills: - Proficiency in software development - Experience in sensor calibration and data extraction - Familiarity with USB connections and software interfacing - Strong understanding of data analysis and presentation The project will require a combination of technical and practic...
I am experiencing an undefined error while fetching user data from my database. Adding small details like 20-30 rows takes a long time to reflect on the website. I believe the problem lies with my current shared hosting server, which isn't performing to the expected standards. Specifically, I need: • Diagnosing and solving the undefined error occurring during data fetching • Migrating to a more reliable and faster server • Live on-screen share during the entire migration process The ideal candidate should have: - Proven experience in solving database issues - Knowledge of efficient and secure server migration processes - Excellent communication skills to explain step-by-step actions during a live screen share.
I'm seeking an expert in AdSense approval to optimize my football-focused blog for monetization. Key tasks include: - Reviewing and fine-tuning the site to meet AdSense requirements. - Solving possible issues preventing AdSense approval. - Advising on ways to maintain approval. Ideal applicants should have proven experience in AdSense approval for information sharing sites, particularly sports blogs. Understanding of AdSense policies, SEO strategies and excellent communication skills are necessary. Knowledge of football is a plus. Overall, your role will be instrumental in ensuring the smooth operation and profitability of my blog, enhancing user experience while maximizing revenue. This will involve detailed insight and adept problem-solving - I look forward to working w...
...adept at managing my calendar and coordinating with my contacts. - Managing emails and correspondence: You'll be responsible for filtering and replying to emails on my behalf. - Organizing documents and files: Keeping my paperwork in order is crucial. You should be proficient at filing, archiving, and retrieving documents. The ideal candidate should be well-versed in: - Microsoft Office (Word, Excel, PowerPoint) - Google Suite (Gmail, Google Docs, Google Sheets) - Calendar and scheduling software (Outlook, Google Calendar) In addition, fluency in German and Spanish, on top of English, would be considered a significant asset. This is a long-term role, with no strict deadline for completion. I value professionalism, discretion, and efficiency in my secretary, and I'm e...
I am in need of an Excel expert to help in building a comprehensive Excel file. The purpose of this Excel file is to manage different types of data. This data is of intermediate complexity, consisting of multiple data sources and types. Key Tasks: - Data Analysis: I need assistance in analyzing the data that will be managed within the Excel file. - Formulas and Functions: The Excel file will require the use of various formulas and functions to ensure its smooth operation. - Data Visualization: Help is needed in visualizing the data in the Excel file. Skills and Experience: - Extensive experience with Excel, especially in data management. - Proven ability in data analysis, including the interpretation and manipulation of complex datasets. -...
I'm looking for a skilled professional to create a robust AI-driven marketing program. This project aims to optimize the marketing database, generate sales, and increase our revenue. Key requirements include: - Building an AI system for data verification to ensure high-quality, accurate information. This includes email verification, phone number verification, and address verification. - Implementing an AI program to sort and segment lists for each campaign. It should consider the following criteria: - Demographic data: Utilizing data such as age, location, gender, and income level. - Customer behavior data: Tracking and understanding customer interactions with the business, such as preferences, buying habits, and engagement. - Purchase history data: Analyzing past...
My WordPress website is currently displaying "Error establishing a database connection" and I can't access the admin dashboard. I need an experienced freelancer with deep expertise in WordPress troubleshooting and database issues resolution. Tasks will include: - Diagnosing the cause of the database connection issue - Fixing the problem to get the website back online - Ensuring all website features are functioning as they should post-fix I'm using a Cpanel on Godaddy for hosting. So, familiarity with Cpanel and Godaddy is a requirement for this task. Also, I'd prefer someone with immediate availability as this is a high-priority issue. Skills required: - Advanced WordPress proficiency - Strong understanding of databases - Experience with ...
I need you to take the list of 250 companies on a google sheet and search each company online and confirm there website, then search for eaxh comoany and add the data to a google slide. Theee should be 3 cell names on the sheet Company name Website Companies house link
I am seeking a proficient Excel programmer who can assist me in automating tasks, creating complex formulas and calculations, and generating reports and trading signals based on S&P500 Index data. The ideal candidate should have: - Proficiency in Excel with a strong track record of automating tasks and creating formulas - Experience in generating reports based on financial data, specifically S&P500 Index - Strong analytical skills to ensure the calculations and data analysis are accurate and reliable - Excellent communication skills to understand my requirements and provide regular updates Some of the key responsibilities and tasks include: - Automating the extraction of S&P500 Index data - Creating formulas and calculations to analyze the extracted data - Devel...
I'm seeking a savvy graphic designer with a firm grasp on creating a compelling logo. The ideal candidate should excel at crafting Corporate and Bold designs. Key requirements: - Develop logo consistent with brand identity - Color scheme: Vibrant Colors - Experience in Corporate and Bold style preferred Your portfolio demonstrating similar work will greatly enhance your application. Be ready to provide a draft and work iteratively. This project will involve a creative, charming and bold design to reflect the character of my brand. Your committed engagement till the end of this project is appreciated.
Enlgish: I have a large quantity of PDFs to process and I am looking for the same specific information each time. I'd like it to input it into Google sheet. I would like to have a program where I can drag and drop the documents, then click on "extract," which allows me to have the information in the correct cells of my Excel or Google Sheet file. ------------------------ French: J'ai Une grande quantité de PDF à traiter et je recherche à chaque fois le même information spécifique Je souhaiterais automatiser le processus
I'm in search of a proficient Excel Macro programmer who can automate data entry tasks with emphasis on numeric data. The ideal candidate would deliver a macro that inputs numbers into Excel and uses "if, then else" logic to perform specific tasks. Essential skills include: - Extensive experience with Excel Macros - Solid understanding of data entry automation - Proficiency in working with numeric data - Good grasp on logical functions especially if, then else Your primary function will involve interpreting requirements and programming the macro to swiftly and accurately complete data entry tasks. Please ensure your portfolio showcases relevant work.
I'm in need of a Pinescript developer who can extract the source code of an invite-only script on TradingView. I'm looking to replicate this script for my personal use, with no need for customization. Key Requirements: - Proficiency in Pinescript and experience with TradingView scripts - Ability to extract the source code of invite-only scripts
I have included examples of each of the following files I would like to have: - Each US state in a vector EPS file with a cut line. Each as their own file name. - A photo of each with dimensions - A mock up photo of each state decal on the back window - An excel sheet with all the states and associated dimensions Example: North Each state .EPS cut file would need to be within a 3.5" x 5.5" rectangle or a 5.5" x 3.5" rectangle. Whichever best fits the state. I have attached an "Examples" file as well that gives further instruction for setting up the file. There are 50 States. I will need 3 folders: 1- Cut Files (50 .EPS files) 2- Dimension Photos (50 Photos) 3- Mock Up Photos (50 Photos To find all the state outlines, you will need to Googl...
...this tool is crucial. - Deliverables: I'd like the results of your analysis to be presented in written reports and clear visualisations ( an interactive dashboard maybe). These should be detailed, accurate, and accompanied by valuable visual representations of the data. Ideal Qualifications: - Proficiency in Data Analysis: You should have a strong background in data analysis and an ability to extract key insights from complex data sets. - Expertise in Google Analytics: Experience with Google Analytics is essential for this project. You should be well-versed in its features and capabilities. - Strong Communication Skills: Your ability to translate technical findings into clear, actionable insights is crucial. - Experience in Web Performance Analysis: Prior experience in ana...
I have an online database searching service and I'm looking to upgrade its current features and introduce some new ones. Key Features to Add: - Advanced Search Options: I'm interested in building on my current search function to offer more refined search capabilities. - Scraping: I'm looking to add a data scraping capability to my service. This will involve extracting data from various websites and integrating it into my existing database. - AI Data Analysis: I'd like to incorporate AI data analysis functionality into my service. Specifically, I'm interested in pattern recognition and data clustering. Other Enhancements: - Batch Searching: I need to implement a batch search functionality. - Additional Database Integration: I'm interes...
...software developer to create a robust recruitment agency software with advanced features. Key Features: - Candidate tracking: The software needs to efficiently manage candidate profiles, applications, and communication. - Job posting: A user-friendly interface for posting job listings, including editing and removing listings as needed. - Resume parsing: Ability to automatically parse and extract key information from resumes to streamline the recruitment process. - ATS: Incorporation of an Applicant Tracking System (ATS) to manage the hiring process from initial application to final placement. Platform and Integration: - The primary platform is desktop, so experience with desktop application development is essential. - While I haven't specified integration needs, exp...
I have a level sensor which is currently sending data to a local Wi-Fi network...local Wi-Fi network, accessible through a web browser using the sensor's IP. I'm seeking assistance to automate this process and have the following requirements: 1. Data Fetching: The sensor is measuring liquid levels. This specific information needs to be fetched and transferred directly to an Excel sheet. 2. Data Update Frequency: The data should refresh in the Excel sheet every minute. 3. End Goal: The collected data will be used to generate a chart in Excel. Ideal skills for this project would include extensive experience with automation, proficiency in Excel, and understanding of level sensor operations. Knowledge of networking would be a plus. Are you the ...
I'm seeking a proficient developer to build a user authentication and authorization system using JS, Node.js, and MySQL. The core function of this project will be role-based access control. Key Features: - Role-based access control system: The system should be able to accommodate three different roles - Admin, User, and Guest, each with different permissions. Ideal Skill...sent to the relevant address based on the campaign. • I have a list of ASM email addresses from a Company. I'd like to trigger emails to each of the ASMs on the list. (Campaign wise)" 8. Download Reports: • Include Camp Details Entry Date: This option focuses on the purpose of having the date - to track when the camp details were entered. • To select Date Range • To Select HQ Wise ...
I'm in need of a proficient Smartsheet expert to assist me in recommending and developing multiple program and project plans. I want to work with expert on a shared screen to help me to learn as we go. I need someone fluent in English - I have a little hearing loss Key responsibilities will involve: -Building SMARTSHEET plans -- Linking to External data (i.e. Excel) that will be used in updating the SMARTSHEET plans. - Utilizing SMARTSHEET Functions: Proficient use of formulas and calculations is essential for this project. - Building Reports and Dashboards: Experience in creating comprehensive and visually appealing reports and dashboards is necessary. The primary goal for this project is to efficiently and accurately track the progress of different projects within the ...
*** US CANDIDATES ON...background to manage various tasks. Key Responsibilities: - Budgeting: You'll be responsible for creating and monitoring budgets to ensure financial health. - Expense Tracking: Accurately log and keep track of expenses to maintain a clear financial picture. - Invoicing: Prepare and send invoices to vendors and clients in a timely manner. Your Experience: - Proficiency in Excel: Since I currently handle finance using Excel, it is essential that you are comfortable with this software. - Previous Finance Management: Experience in budgeting, expense tracking, and invoicing is a must. - Strong Communication: Being able to keep me updated and informed on financial matters is key. Please highlight your relevant experience and how you can support me in ...
I have a PDF document that I need retyped into an Excel file. The PDF consists of a total of 10000 pages with data organized in 4 columns. I'm looking for an experienced multiple freelancer who can accurately retype the data from the PDF into an Excel spreadsheet as plain text. Key requirements: - Retyping the content of a large PDF file into Excel - Data organization into 4 columns - Ensuring high accuracy in data entry See the attached file and google sheet link I will give 500 pages first if we meet rate and deadline.
...noticeable delays during actions that involve fetching data from the MongoDB database, significantly impacting the user experience. I'm seeking a skilled developer who can help me address these performance issues. Key Tasks Include: - Investigating and identifying the root cause of the slowdown when fetching data from MongoDB - Implementing optimizations and solutions to improve the performance of the server actions, particularly those related to database interactions - Testing and validating the improvements before deployment to ensure they effectively address the issue without causing any unintended consequences Ideal Freelancer: - Proficient in and MongoDB - Experienced in optimizing server actions and database interactions for performance - Familiar wi...
I'm looking for an expert in Excel to build a comprehensive 'Team Scorecard' for my team. This sheet will be used to track a range of tasks and behaviors to ensure the team is performing at their best. Key Features: - The project involves tracking various tasks and behaviors including daily reports, client communication, social media postings, timekeeping, invoicing, and meeting attendance. - I need the sheet to calculate total and average points automatically. This will be based on the tasks completed and the quality of those tasks. - It should also include conditional formatting to highlight outstanding performances. This will help us recognize and reward exceptional work. - Data validation is important to ensure accuracy and consistency in point entries. - Visu...
