Simple public data search and database building in excelงาน
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)
ต้องการสคริป Jquery Script สำหรับโฆษณาวีดีโอ ก่อนโหลดตัวเล่น Iframe จาก data-href button - ตอนกดโหลด Player จะมีโฆษณามาแสดงทุกครั้ง ก่อนที่จะดึงตัวเล่นมากจาก data-href <div class="player_ep"> <div style="text-align: center"> <button type="button" data-href="" data-resolution="fast_p2p" class="btn btn-primary play-ep">Player 1</button> <button type="button" data-href="" data-resolution="google_photos" class="btn btn-default play-ep">Player 2</button> </div> </div> โดยรูปแบบ ดึงโฆษณาวีดีโอมาแสดง จะดึงจาก รูปแบบคล้ายๆ แบบนี้ครับ หรือออกแบบมาให้ก็ได้ครับ...
ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
นี้ตัวอย่างครับ ลอง search ดูเป็นไอเดียคร่าวๆก็ได้ครับ Snapchat
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
ทำเว็บ ค้นหาร้านเสื้อผ้าที่เราจะสามารถซื้อเสื้อผ้าชนิดนี้ได้ถูกที่สุดจากเว็บเว็บไซต์ที่ขายของอยู่ทั้งหมด อย่างน้อย 3 เว็บไซต์ ดึงข้อมูลของเว็บขายเสื้อผ้ามาเก็บไว้ เก็บราคา รูปภาพ ลิ้ง เพื่อเอามาเปลี่ยบเทียนดูตอน search mี่หน้าเว็บของเรา
ต้องการข้อมูลที่ติดต่อได้จริง ของร้านสปา และร้านขายส่งผลิตภัณฑ์เกี่ยวกับสปา ทั่วประเทศไทย (มากที่สุด) ข้อมูลที่ต้องการ -ชื่อร้าน -เจ้าของ/ผู้ดำเนินการ -หมายเลขโทรศัพท์ -หมายเลขแฟกซ์ -หมายเลขโทรศัพท์มือถือ (ถ้ามี) -อีเมล์ -ที่อยู่จัดส่งเอกสาร ***เป็นข้อมูลที่ update ใช้ได้จริงเท่านั้น
...an existing excel document that I would like to adapt to help with quotations & orders. Key Features: - The adapted document should automatically generate quotations, order forms, and perform the necessary calculations. - The excel file should have fields for product name, quantity, price, and customer information. Additionally, it should accommodate the inclusion of photos, and sizing information (a template image will be provided for reference). Calculations & Formulas: - The document should perform total price calculations, as well as tax calculations. Ideal Skills & Experience: - Proficiency in Excel - Experience with automated document generation - Exceptional skills in creating complex formulas - Attention ...
Important: Project must be completed within 10 hours or less I have designed the attached company fact sheet in Excel. I would like help converting this to a Microsoft Word template. I need it to be flexible so that all the text and information can be changed and amended as needed, and I can change the charts. I have also attached the logos to be used.
I’m seeking engineering plans for a deck attached to my home that are required for building permits in my municipality in Stuart Florida. Please let me know if you need anything else. Thanks again and I look forward to working with you.
I need a comprehensive website created for my small handyman business which offers plumbing, electrical and carpentry services. Specific features the website needs to include are: - An online booking system that allows customers to schedule our services. - Detailed descriptions and visuals for each service we offer - plumbing, electrical, and carpentry. The ideal freelancer for this job would have experience building e-commerce websites, particularly with a booking feature. Proficiency in web design to accurately capture the essence of my services is also needed.
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
...of macros in Excel. The purpose of these macros is to automate the process of generating multiple files from a base Excel file, specifically for the task of data analysis. Key Requirements: - The macros should be designed to create multiple Excel files from a single base file. The output files should maintain the formulas, formats, and templates of the original file. - The macro should be designed to run on a monthly basis. - The output files can have the same format with different data. The ideal candidate should have: - Proficiency in VBA and Excel - Experience in creating macros for data analysis - Ability to deliver a reliable, efficient, and well-commented solution. I need this to be deliv...
I need a simple yet unique logo designed swiftly. I will provide a jpeg or ppt file as reference. The logo will need to be developed using Illustrator or other vector graphics software. It should be versatile enough to use across multiple platforms, ensuring it remains crisp and clear. Key Points: - Combination of text and icon in the design - Specific color preferences will be provided - Required in an hour or less Ideal Skills: - Proficiency in Illustrator or similar software - Ability to work swiftly without compromising quality
I'm in the technology industry, and I'm looking for a skilled SEO expert to help bolster the online presence of my website. I need someone with a good understanding of SEO, particularly link building, to help me acquire high-quality DA backlinks. My website is Key requirements: - Advanced knowledge of SEO and backlink building - Proven track record of successful SEO projects - Understanding of quality content production and consumer-focused link building Your tasks will include: - Conducting a thorough analysis of my website and target audience. - Developing a backlink strategy tailored to the technology sector and my consumer audience. - Implementing the strategy by acquiring high-quality backlinks from reputabl...
...am in need of a SharePoint expert who will be on hand for 4 hours daily to assist with various tasks relating to my SharePoint site. The selected individual will be primarily tasked with: - Document management: The organization, updating, and safeguarding of crucial documents. - Workflow automation: Streamlining business processes to improve effectiveness. - SharePoint site customization: Tailoring the site to suit our specific needs. At the moment, the specific SharePoint version being utilized is unspecified, so a basic understanding of multiple versions is beneficial. There's also a need to integrate Power Automate, so experience with this tool is essential. Ideal candidates must be proficient with SharePoint, organized, detail-oriented, and experienced ...
I'm currently on the lookout for an expert in Excel 2016, with a specialized focus on the creation of VBA. The end goal? Correct spelling mistakes across multiple worksheets in my data set. Given the language locale, proficiency in English (USA) is essential. In addition to this: - Strong attention to detail and accuracy skills are needed. - Proven experience of using Excel, especially dealing with multiple worksheets. - Experience in creating and executing VBAs effectively for similar problems. Do you believe that your expertise aligns with these requirements? If so, consider submitting a proposal.
I am looking for a software solution to extract exam questions and answers from PDF files and organize them into an Excel spreadsheet. The extracted data should be structured such that each question is listed in one column, its corresponding answers are listed in subsequent columns, and each row represents a single question and its answers. Project Requirements: PDF/Doc Parsing: The software should be able to parse PDF/Doc files containing exam questions and answers. Extracted data should include the question text and its associated answers. Data Organization: Questions should be listed in the first column of the Excel spreadsheet. Answers should be organized in subsequent columns, wi...
...my data warehousing project, only 1st stage so it doesn't require a lot of effort. If your work is good, we can continue the rest of the stages! Key Requirements: - Data Integration: The main task is to bring in public datasets and integrate them into the data warehouse. - Reporting & Visualization: The data warehouse primarily serves as a hub for reporting and data visualization using Microsoft Power BI. Ideal Skills and Experience: - Proficient in data integration and ETL processes. - Experience with public datasets. - Advanced knowledge of Microsoft Power BI. - Solid understanding of the business needs behind data warehousing. What exactly I will need you to deliver ...
Follow directions in video. Maidstone and Unity - Janessa and Kenzie Turtleford/Shellbrook/North Battleford - Juan David and Eduardo Meadow Lake - Cody/Tristan
I'm in dire need of a professional with deep understanding of Graph Convolutional Networks (GCN), machine learning and data science to assist in building an anomaly prediction model. Since the specific anomalies to be predicted and the data to be used are not yet defined, your flexibility and adaptability are vital. Accuracy requirements are also to be specified later; hence, your ability to quickly alter the model's complexity is coveted.
...startup for my business launch event in Jamaica. Key Focus of the video: * The video should highlight the hard work, dedication and resilience that I and my team have put into building my startup. * It should be a looping video that will play during my speech at the event. Content for the video: * I will provide pictures from past events, recorded meetings and pitches, personal or professional video clips. These should be included in the video to enrich the storytelling. Ideal skills: * Previous experience in documentary-style video creation is preferred. * Understanding of the startup landscape may be beneficial. * Ability to weave a compelling narrative using the provided material. * Good sense of pacing and timing to make...
I'm in dire need of a professional with deep understanding of Graph Convolutional Networks (GCN), machine learning and data science to assist in building an anomaly prediction model. Since the specific anomalies to be predicted and the data to be used are not yet defined, your flexibility and adaptability are vital. Accuracy requirements are also to be specified later; hence, your ability to quickly alter the model's complexity is coveted.
I am seeking a registered Texas PE (Professional Engineer) or Licensed Firm to endorse Structural and Electrical drawing that has been completed for a Steel Modular Building.
I'm in need of a structural design for my residential property. The structure should be designed to be one floor in height. I'd prefer a G+2 foundation type, that is, a structure with a Ground floor and 2 upper floors. Key Requirements: - Create a structural design for a single floor residential property - Implement a G+2 foundation (Ground floor + 2 upper floors) Ideal Skills and Experience: - Professional experience in structural design, particularly for residential projects - Proficiency with architectural design software to create detailed plans - Strong understanding of building codes and regulations, particularly for residential properties
...currently quite busy and colorful. It features a dove, a crown, and wings, all with varying thickness of lines. I'm looking for a talented designer who can transform this logo to a minimalist style with the following specifics: - Simplify the design: The current logo is too busy to be used effectively. I need a designer who can simplify the design while keeping the key elements intact. - Change the color to black: The logo is currently in color, which is distracting and not suitable for all use cases. I want the logo to be in a single color - black, to give it a more professional and cohesive look. - Unify the lines: Currently, the design has varying thicknesses in the lines of the dove, crown, and wings. I want all lines to ...
...specializes in architectural design and CAD modeling. Requirements: - Experience in architectural design and CAD modeling - Ability to create detailed architectural plans and models from scratch - Proficiency in CAD software such as AutoCAD or SketchUp - Knowledge of architectural principles and See examples first Project Details: - The project involves creating architectural designs and CAD models for a building project. - The client has existing drawings and models that they would like to use as a starting point. - The freelancer will be responsible for adapting some elements of the existing drawings/models. - 3D rendering services will also be required to create realistic visualizations of the designs. Ideal ...
I'm in need of a skilled professional who can provide a "no-rise" certificate for my residential property. This certificate is essential for obtaining a building permit. I require a comprehensive "no-rise" analysis certificate. This means that the report should outline that the proposed construction will not increase flood levels during a flood event. The ideal candidate for this project should have: - Experience in providing no-rise certificates for building permits - Expertise in flood risk assessments - A strong understanding of residential property regulations and requirements Please note that a "no-rise" certificate is not the same as a flood risk assessment report. It's focused on ensuring that ...
I've got a Shopify store that needs an SEO upgrade. I'm looking for a competent freel...Shopify store that needs an SEO upgrade. I'm looking for a competent freelancer to handle: - Keyword Research: I need my products to rank competitively in search results. Your task will involve identifying high-ranking keywords that fit my store's niche. - On-Page Optimization: This includes meta descriptions, title tags, image optimization and other on-page elements to boost the store's SEO. - Link Building: Build quality backlinks that will drive traffic to my store. It's necessary to have familiarity with Shopify SEO; I believe it is key to implement this task effectively. Please ensure to include details of your past work in this re...
...com ) is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be involved in our pre-employment screening by conducting a visit to our candidates’ residential address with the candidate’s consent letter. JOB DESCRIPTIONS: • Conduct the site visit to the candidate’s residential address • Conduct the basic verification of the candidate’s residence & reputation with the neighbors, head of the local community, police stations, ...