Data scraping 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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I have a database with 200,000 SKU's from retail sales, un...SKU's from retail sales, unfortunately lacking category, subcategory, and brand details. I'm seeking a skilled professional who can assist in mapping these details effectively. Key Deliverables: - Utilize a data matching algorithm to automatically map the SKU's with high accuracy (90-95%). - Present the final output in an Excel spreadsheet. Ideal Skills: - Proven experience in data matching and SKU mapping. - Proficiency in using data matching algorithms. - Experience with handling large datasets. Accuracy is paramount for this project, as the mapped details will be used for further data analysis and decision-making in our retail operations. A high level of precision will...
I'm seeking an experienced Tableau and Excel expert to assist in creating a high-quality data visualization project. Key project requirements include: - Intermediate level of complexity: The data that needs to be visualized is sourced from multiple sources and requires the implementation of filters. - User-driven data filtering: I am looking to implement specific interactivity features that allow users to manipulate and filter data. The ideal candidate will have: - Proficiency in Tableau and Excel - Experience in creating intermediate level data visualizations - Strong understanding of data filtering and interactivity features If you possess the required skills and experience, please bid on this project.
...Pakistan, Bangladesh, India, etc. I need a freelancer from LATIN AMERICA only. I need close to EST time!! Furthermore, I need a BILINGUAL freelancer!! So READ before biding. I need a fully bilingual professional (I will interview in English via video) to do some tasks for my agency, such as: PR Outreach Social media Content editing or creating CRM management Email marketing Email scraping Researching Organizing data in spreadsheets Copywriting Basic Wordpress (change text, add a button, upload a file, etc) And others related to the position You must be a FAST learner, attentive to details, curious, with great writing skills. Looking for someone that pays attention and doesn’t keep making the same mistakes over and over. Attention to detail. Common sense. T...
I am seeking an Excel expert with strong data analytics skills to create an Excel sheet primarily for data analysis. The main function of the Excel sheet will be to conduct descriptive analysis. Ultimately, this analysis will assist me to forecast sales trends. Key Requirements: - Expertise in Excel and data analytics - Knowledge in sales forecasting - Experience developing descriptive analytic platforms - Familiarity with project management and financial tracking is a plus I expect the final document to provide me with detailed insights to make informed decisions about future sales strategies. If you possess the necessary skills and experience, I look forward to receiving your bid.
...an experienced and knowledgeable data scraping professional to collect specific information from three major platforms - RERA websites (specifically Maharashtra, Telangana, Haryana, and Delhi), Google, and Justdial. Here's what I am looking for: Details to Scrape: - Name - Mobile Numbers - Locality - City - Address - Pincode Platforms: - RERA Websites (Maharashtra, Telangana, Haryana, Delhi) - Google (DSA and Loan Agents data) - Justdial (DSA and Loan Agents data) The ideal freelancer for this job will be highly experienced in data scraping and will be able to deliver the results in an organized manner. Proficiency in scraping from Google, RERA websites, and Justdial is particularly important. Delivery Format: - The data...
I need an Excel expert to help me organize and document my financial data. - The project involves documenting financial data, primarily focused on weekly updates. - There are no specific calculations or analyses required at this stage. - The ideal freelancer should have a good handle on Excel and experience working with financial data. Looking forward to receiving your bids.
I'm in need of a detail-oriented specialist to perform data entry on textual content that's already well-organized. Key Tasks: - Accurate entry of textual data into Excel format - Pace of work should be efficient without compromising the quality - Ensure a smooth transition of data, maintaining its organization Ideal Skills and Experience: - Previous experience in data entry jobs would be beneficial - Proficiency in Excel - Excellent attention to detail - Ability to handle data in an organized manner - Good command of English language to understand textual data.
I need an expert to take on a data documentation project. It involves converting data from Excel sheets into word documents. The skillset required includes, but is not limited to: - Proficiency in Microsoft Excel and Word - Attention to detail, since the data to be converted is a mix of numerical and textual information - Excellent data organization skills The intended outcome is to have data that was originally in Excel converted and reorganized into a Word document. Please bid if you're sure you have the right skills for this task.
I have a 3.5-page handwritten sign-in sheet that I need transcribed into an Excel spreadsheet. The main purpose of this task is to make it easier for me to search through the records. The final document should be a straightforward, clean and well-organized spreadsheet, reflecting the original sign-in sheet's content as accurately as possible. Skills and experience necessary: - Proficiency in transcription, especially from handwritten documents - Strong knowledge of Excel or Google Sheets for high-quality spreadsheet creation - Attention to detail to ensure accuracy and completeness of the transcription The ideal freelancer should be reliable, with good communication skills to ensure smooth and efficient completion of the project. Color-coding or highlighting of spec...
I'm seeking a specialist with expertise in detailed financial data entry. You'll be tasked with entering intricate numbers and figures for our financial reports. Skills and Experience Required: - Proficient in Microsoft Excel. - Experience with financial report data entry. - Detail-oriented with ability to handle complex numerical data. Main Tasks: - Inputting detailed financial data into our Excel-based financial reports. - Ensuring accuracy of data. - Completing tasks within given deadlines. Please share relevant previous experience and examples of your work when bidding.
I'm in search of a seasoned Excel-savvy bookkeeper to assist with the following tasks: - Accounts Payable: Tracking and managing all outgoing payments in a clear and organized manner. - Accounts Receivable: Overseeing and monitoring all incoming payments, ensuring timeliness and accuracy. - Bank Reconciliation: Regularly reconciling bank statements with our financial records to ensure accuracy. You don't necessarily need to be an expert in accounting software, but you should be fluent in Excel. This project doesn't involve learning new software, but rather meticulously managing and organizing financial data in Excel. I prefer to receive updates and reports via email, so clear and concise communication skills are a must. Experience in bookkeepi...
I need an Excel expert to help me document my financial data in a specific text-based format. Key Requirements: - Organizing and documenting financial data in Excel - Following a specific text-based format provided by me Ideal Skills and Experience: - Proven experience in working with financial data - Proficiency in Excel, including advanced functions for data organization - Excellent attention to detail and ability to follow specific instructions accurately and efficiently.
helps how to convert excel sheets into a document
Looking for someone who is highly knowledgeable in Excel functions, formulas, and formatting. The ideal freelancer will have experience performing the following tasks in Excel spreadsheets in portuguese - Implementing a variety of Excel formulas and functions - Applying diverse formatting techniques Unfortunately, I have not specified the exact functions, formulas, or formatting needed, meaning the freelancer must employ a broad range of knowledge and expertise in these areas. Experience with Excel in Portuguese is a definitive plus. The project requires an adaptable and meticulous individual able to meet changing demands efficiently.
I need a talented designer to create a minimalist logo for my company. Here are my requirements: - The primary color scheme should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligator...should be based on black and white (grey if useful). - The design should be minimalist, with clean and straightforward lines. - Incorporation of the company name is not obligatory. Skillful use of it, contingent on how it fits into the design and overall aesthetics, is appreciated. Ideal candidates should possess past experience in minimalist logo design and a keen eye for balancing colors. If you excel in creating attention-grabbing logos with subtle details, then this project i...
I'm looking for an experienced freelancer who can convert my Excel sheets into Word documents. The documents need to be in text only and follow a specific format, for which I'll need help in creating a template. Ideal Skills: - Proficiency in Excel and Word to ensure accurate conversion. - Experience in template creation and design to help structure the documents appropriately. - Attention to detail to ensure the final Word documents are error-free and cohesive.
...provide a scraping sample (2-3 lines) aligned with the instructions below. Scrape data from this website: Filters to be used: - "CAR": 203 and 16348 - "Anno di Concessione": 2020, 2021, 2022, 2023, 2024 - "Importo": select "Compreso fra 100000 e 200000", "Compreso fra 200000 e 500000" and "Maggiore di 500000" We need to scrape the results from all the possible combinations of the above filters. The outcome table should contain all the columns of the initial table AND all the data contained inside each result (you can access in it by clicking on the magnifiying lens). To be clear: - identificativo di riferimento - numero di riferimento - titolo misura - tipo misura - COR - titolo progetto - data...
Hola, María, necesitaría el trabajo de este excel: https://docs.google.com/spreadsheets/d/1tnP73xrnE0SGNuynpLpnl1r7mThhi4liPCQCYjTRdvE/edit#gid=1193400678 Gracias,
I'm looking for a freelancer who can create a custom Excel sheet to track the daily attendance of my employees. The sheet should: - Be user-friendly and easy to navigate - Allow for automated calculation of total attendance - Be able to handle multiple employees at once - Have the capacity to expand for future growth I'm not looking for anything too complex, just a simple, efficient tracker that can help me keep tabs on my employees' attendance on a daily basis. Ideal Skills: - Proficiency in Excel, including advanced formulas and functions - Experience in developing user-friendly, automated spreadsheets - Strong organizational and communication skills to ensure the tracker meets my needs and is easy to understand and use.
...seeking a seasoned data analyst with expertise in data science who can thoroughly clean, preprocess, and visualize a dataset sourced from CSV files. The chosen candidate: - Should first start with cleaning and preprocessing the data to create a reliable foundation for analysis. - Should then interpret and present that same data through meaningful visuals to explore its intricate properties and characteristics. - Should additionally facilitate statistical analysis to derive patterns and trends otherwise invisible to the naked eye. The hoped-for end-product of this project is not just predictive analytics but insight and data-driven recommendations that will inform future decision-making. Proficient use of Python or R for these tasks is essential, as i...
I'm in need of an individual proficient in Excel to streamline data analysis for my sales numbers. The main objective will be to dissect revenue trends within the data, so particular attention to this metric is essential. Ideal qualities include: - Great attention to detail - Previous experience in data analysis - Proficiency in Excel - Understanding of sales and revenue benchmarks This role will require you to receive raw data and translate it into an easy-to-understand format, highlighting pivotal information. Your focus will be on creating complex formulas to identify revenue trends, which will help inform our future sales strategies.
I'm looking to automate my trading processes using the Zerodha Excel API. As I'm unsure of the API's development, I need a freelancer who is experienced in API integrations and has a good understanding of automated trading systems. Key Elements: - Automation: The primary goal is to automate trades based on predefined criteria. This involves developing a system that can analyze market conditions and execute trades automatically. - Zerodha Excel API: As I am unsure about the development of this API, you should have a good understanding of it or be able to quickly grasp its functionalities. - Trading Experience: It would be beneficial if you have prior experience in developing automated trading systems. - Predefined criteria: The system should be able to automati...
I'm looking for a skilled data scraping professional to assist me with a project. I had a working script in Python using an API, but the company implemented a Cloudflare protection that is always blocking me. You would need to find a solution how this could be circumvented (e.g. proxies) and large amounts of data be scraped. If you are interested, I am happy to provide more details privately.
...correct answer (the choice in BOLD). - Some questions "refer to a figure". Most questions have zero or one figures, a few have more. I have provided Columns Figure A... FigureH for these as required. LOOK AT THE EXAMPLE. task is to put all 1090 questions into an excel file. I have put one question in there as a sample. I have also put one image which shows two additional questions. - If you win the project, you will get the full PDF. You will be able to cut and paste from the PDF. - To bid on this project, you must give me the excel file back with these two sample entries put in after the one that I did. The sample is a JPG file so you must type it in manually. Successful project: - All questions in there, in correct order from the PDF. - No typos. - Co...
I'm looking for a reliable freelancer to help with a small-sized project involving Excel data entry. The information will be shared via online documents. Ideal Skills and Experience: - Proficiency in Excel and data entry - Attention to detail is a must - Ability to handle small-scale tasks efficiently
I'm looking for a skilled sales closer with a strong track record in retail sales. The ideal candidate should have a versatile background, capable of handling both brick-and-mortar and e-commerce environments. Experience in the pharmaceutical or healthcare industry is a plus. Key responsibilities include: - Engaging with...include: - Proven track record in retail sales, ideally with experience in both brick-and-mortar and e-commerce - Strong communication and negotiation skills - Ability to understand and communicate the benefits and features of pharmaceutical products - Experience in selling healthcare or pharmaceutical items would be highly beneficial If you believe you have the skills and experience needed to excel in this role, please do get in touch. I look forward to he...
I wil...changes daily , One such project should be made I'm seeking a proficient Excel specialist to take on a project that primarily involves formatting and creating advanced formulas. Key Responsibilities: - Take charge of the spreadsheet's aesthetic and logical formatting - Develop and implement formulas to aid data analysis and interpretation - Arrange numerical data alphabetically from A to Z Ideal Skills: - Proficiency in Excel functions and formulas - Strong attention to detail, particularly regarding formatting - Excellent problem-solving skills Project Timeline: This project needs to be completed within a month, demonstrating your ability to meet deadlines is crucial. So, if you have good experience with Excel, particularly with...
I'm currently seeking a skilled freelancer for a data entry job concerning primarily text data. The data to be entered will be provided in an Excel spreadsheet and will need to be accurately transferred to an online database. Ideal candidates should have: - Proficiency in Microsoft Excel - Experience with data entry into online databases - Attention to detail and accuracy Please place your bid based on the information provided, and get ready to embark on an engaging and fulfilling data entry task.
I'm run...managing our inventory through Excel spreadsheets. It's getting increasingly cumbersome and we're looking to streamline the process with a dedicated inventory management software. Key Features: - I'm interested in a system that will have robust reporting and analytics capabilities. This will help us keep a close eye on our stock levels, sales trends, and overall inventory health. Ideal Skills and Experience: - Experience with developing inventory management software, particularly for food and maintenance materials - Proficiency in building systems with strong reporting and analytics features - Ability to create user-friendly interfaces for easy data input and retrieval - Experience working with Excel and the ability to potentially integr...
I'm in need of a proficient individual who excels in SPSS for a data interpretation task. The main task involves the analysis of a questionnaire and exporting relevant tables from SPSS. Here's what I'm looking for: • Skilled in analyzing questionnaires using SPSS • Able to export data into tables • Analysis should be done based on patterns of behavior • Writing a brief description of data based on hypotheses The data is on an Excel file right now. Please bid only if you have relevant skills and experience as it will demand a high level of expertise and detail orientation. Don't hesitate to ask if you have any queries. Thank you!
As a Media TV Channel, we are seeking a UDAID Contract Compliance Specialist to review our contracts, ensure compliance with cont...adhere to all terms and conditions outlined in our contracts. - Auditing financial records: You will need to conduct detailed audits of our financial records to guarantee compliance. Industry Experience: While not mandatory, if you've previously worked in the media TV channel sector, it would be an added advantage. Understanding the unique nuances and challenges of this industry will help you excel in this role. Ideal Skills and Experience: - Experience with USAID contracts is a must. - Previous work in media TV channels would be beneficial. - Strong background in contract compliance and financial auditing. - Detail-oriented with excellent commun...
