Fill in an Excel Spreadsheet with COMPLEX Dataงาน
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)
หน้าแบบฟอร์ใบเสนอราคา 1. ดึงข้อมูลลูกค้าจาก Database หรือ สามารถเพิ่มรายชื่อลูกค้าใหม่ได้เลย ใช้ Select2 1.1 เมื่อดึงข้อมูลลูกค้าได้มากแล้ว ให้ Auto fill ข้อมูลที่เลือเช่นที่อยู่ใบกำกับภาษี 2. ค้นหาข้อมูลสินค้าในฟอร์ม 2.1 ค้นหาข้อมูลสินค้าได้จาก Database ในช่อง SKU ได้ และ Auto Fill ช่องอื่นๆเช่นรายละเอียดและราคา 2.1 ค้นหาข้อมูลสินค้าได้จาก Database ในช่อง Detail ได้และ Auto Fill 3. SUM ราคาสินค้าแยก VAT และราคารวม 4. ส่งเอกสารให้ ลูกค้าได้ในรูปแบบไฟล์แนบ PDF และ Email ได้ทันที ข้อมูลตามรูปแนบบ ใช้ Codeinater และ Boostrap4
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
I need you to fill in a spreadsheet with data. ทำงานค้าขายตามตลาดนัด
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
Writing Particle Swarm Optimization (PSO) by Matlab in Helicopter Routing for Solving High Voltage Transmission Line Inspection. This thesis want to be saved cost and distance of inspect the High Voltage and complex condition (Master's Degree) ต้องการผู้ที่สามารถเขียน PSO Particle Swarm Optimization ในโปรแกรม Matlab ได้ โดยโปรเจคนี้จะเป็นการกาต้นทุนและเส้นทางที่น้อยที่สุดในการตรวจสอบเส้นสายไฟฟ้าแรงสูง ภายใต้ เงื่อนไขที่ซับซ้อน (เป็นงานวิจัยระดับปริญญาโท)
I'm in need of a professional who can create video tutorials for me. I find it challenging to understand things when provided in a technical way. I am seeking someone who can provide me with clear, step-by-step instructions. Ideal Skills and Experience: - Ability to simplify complex information - Proficiency in creating video tutorials - Great communication skills - Patience and understanding The scope of the tutorials is open-ended. It may involve explaining software usage, programming concepts, or even product assembly. If you're adept at breaking down complicated instructions into simple, easy-to-digest steps, then I'd love to hear from you.
...trial win, an educational tool for key strategies employed during the trial, and a marketing asset for my practice. Key Tasks: - **Video Style:** I envision this video to be crafted in a documentary-style. It should include interviews with key figures, possibly witnesses or clients, and reenactments of key moments in the trial. - **Duration:** The video should be brief, kept under 5 minutes, to ensure it is engaging and easily consumable for viewers. Skills and Experience: - **Video Production:** The chosen freelancer should have a proven track record in producing high-quality, engaging videos. - **Storytelling:** A keen sense of narrative and the ability to convey complex legal information in a clear, compelling way are essential. -...
I require AutoCAD shop drawings for the intention of construction planning for a commercial building. ...shop drawings for the intention of construction planning for a commercial building. The freelancer should include comprehensive architectural details. A strong background in creating accurate AutoCAD drawings detailing architectural specifics for commercial projects is a must. The desired candidate will need a strong understanding of construction processes, especially within the commercial realm, to ensure every detail contributes to a seamless build. Your craftsmanship will directly influence our build strategy, so we expect precise and detailed work. Please only apply if you excel in AutoCAD and have direct experience in the realm of architecture and constr...
I require a freelancer who is savvy with setting up social media and Gmail accounts. Create 50 Google email (gmail) accounts with the names in a provided excel spreadsheet. I have not attached it here, I will provide it when the project starts, as I don’t want to make them public to others then the person that will create the accounts. It is real accounts for real people that do not use gmail today, and that do not have a social presence. In the spreadsheet there is also information about the backup email to be used for PW resetting etc. Create 50 Facebook and Instagram accounts matching the google accounts. Ad profile pictures. Ad 20 to 30 random pictures to each account. Follow 30 to 50 people for each account. Make the profiles...
I'm looking for a seasoned Excel expert to create a set of macros that can automate my data extraction process. Here's what I need: - Automate data extraction: The primary purpose of these macros is to enable automated data extraction from local files. The data in question is stock market data. The ideal candidate for this project would have: - Proficiency in Excel: You should have a strong grasp of Excel, particularly in designing and implementing macros. - Experience in data extraction: You should have a track record of successfully automating data extraction processes. Looking forward to hearing from you.
I am looking for an expert in Excel to design a dynamic spreadsheet for project tracking. This spreadsheet will focus on monitoring task progress and deadlines. Key Features: - Daily updates: I will be updating task progress and deadlines daily, and so I need the spreadsheet to be user-friendly and efficient. - Task highlighting: If a task is falling behind schedule, I need it to automatically become highlighted in red. This will help me prioritize tasks and ensure no deadlines are missed. - This will need to show throughput for every phase and also provide an average through in volume. Skills and Experience: - Proficient in Excel - Experience in creating dynamic spreadsheets - Understanding of project m...
The task is to visit "Vilniaus Implantology House Lithuania". and 1- Verify Certificate and get a form filled, sign and stamped by them. 2- 4 to 5 geotagged photos are required with name board visible of place with surroundings. 3- In case of refusal take the written refusal with stamp with details of the person who refused to fill the form name, designation, phone number and email. If above mentioned requirements are fulfilled than task will be completed.
I'm in need of a freelancer capable of efficient and precise textual data entry into Microsoft Excel. This project requires a keen eye for detail, a high level of accuracy, and excellent organizational skills. You should be fluent in English and proficient in using Excel. To make an informed bid, freelancers should include the following: - Examples of past work related to data entry, particularly with Microsoft Excel. Stats that display the accuracy and efficiency of your work would be a huge plus. - Any relevant experience in data entry or related fields. Please note, attention to detail and Excel proficiency are paramount to this project.
For this task, I am specifically seeking a freelancer who is proficient at data entry and familiar with Excel spreadsheets. The project primarily involves numeric data, so accuracy is vital. Key Responsibilities: - Input numeric data into an Excel spreadsheet. - Maintain a minimum 98% accuracy level. Ideal Skills and Experience: - Proficient in Excel. - High attention to detail. - Experienced in numeric data entry. - Proven track record of maintaining high levels of accuracy. Please ensure you have the necessary skills and experience before placing your bid. I look forward to your detailed proposals.
Need to extract data from website: , into an Excel file. Specifically name, discipline (medical practitioner, midwife, nurse, OT, physio, psychologist, podiatrist), location (incl suburb and postcode), initial registration date, registration expiry. There would be at least 100,000 rows of data. Only barrier, is this data is not able to be 'searched' efficiently. Individual names can be looked up. Or disciplines with a select number of names demonstrated...but I can't find a way to show ALL clinicians at once. Looking for a solution which can reliably pull all the names from the database.
...Mobile Technologies in Somalia within the Somalia context. Focusing on youth and community engagement, this proposal will serve to bridge the gap between digital technologies and social development. Key Responsibilities: - Create an in-depth proposal with a focus on the integration of mobile applications, crowdfunding, and gaming into our initiative. - Address the importance of education and training programs and the use of social media and online platforms for awareness campaigns in driving youth and community engagement. SCOPE OF CONSULTING SERVICES REQUESTED: 1. Crowdfunding platform hosting: - Maintain a crowdfunding platform that can utilized on an ad hoc basis for individual projects to be fundraised by Somali communities during con...
I'm looking for an Excel expert who can build a simple yet effective sheet for basic arithmetic calculations. Key requirements: - Perform basic arithmetic operations: The main functionality of the sheet should be to perform basic arithmetic operations such as addition and subtraction. - Real-time collaboration: The sheet should support real-time collaboration, where multiple users can edit the Excel file simultaneously. Ideal skills and experience: - Strong background in Excel: The freelancer should have a deep understanding of Excel and the ability to create formulas for basic arithmetic. - Real-time collaboration proficiency: Experience in implementing real-time collaboration features in Excel will be highly benef...
I'm looking for a reliable and experienced data entry specialist who can assist me with entering data from images. The images will be directly uploaded to a website, and I need the data to be transcribed into various formats like Excel sheets, Word documents, and for copywriting purposes. Ideal Skills and Experience: - Prior experience with data entry from images - Proficiency in Excel and Word - Copywriting experience is a plus The primary goal of the project is to create a comprehensive database in various formats, so the ability to accurately transcribe and organize data is crucial. The chosen freelancer should have keen attention to detail and a high level of accuracy.
I'm seeking a skilled data analyst who can help me with analyzing longitudinal data from online survey responses. Key Responsibilities: - Conducting latent growth modeling on the longitudinal data - Providing insights on the developmental patterns observed - Assisting in the interpretation of the results Ideal Skills and Experience: - Proficiency in handling and analyzing large datasets - Prior experience in the application of latent growth modeling - Strong background in longitudinal data analysis - Ability to effectively communicate complex statistical concepts - Familiarity with online survey data collection methods is a plus If you have the expertise and enthusiasm to dive into this project, I ...
...productive communication with potential clients. - Convert conversations into promising leads. - Record conversational details into our database. REQUIRED SKILLS AND EXPERIENCE: - Exceptional persuasive communication skills. - Proven experience in lead generation. - Familiarity with the corporate events and conferences sector. - A resilient attitude to handle potential rejections and keep going. This role demands someone ready to excel in a fast-paced environment while showcasing dedication, autonomy and agility. Your ultimate aim will be to assist in the company's expansion through the successful generation of potential leads. This is an excellent opportunity for someone looking to apply and enhance their telecalling skills whil...
I need an Excel VBA expert to automate the generation and visualization of customer data reports. This task requires the building of a dashboard to simplify the report generation process. Key Tasks and Skills Required: - Strong understanding of Excel VBA for automation tasks. - Experience in building dashboards for report generation. - Skills in visualizing customer data within Excel. Outcome and Project Scope: - Develop an automated process for report generation. - Ensure the dashboard is user-friendly and visually appealing. - The final output should provide easily digestible customer data insights.
As a data enthusiastic business, we're seeking a talented freelancer who can design an effective Power BI Dashboard to integrate various data sources including Excel spreadsheets, CSV files, and SQL databases. The ideal freelancer would: - Have extensive experience with Power BI and DAX language integration. - Demonstrate an excellent grasp of designing dashboards that report on KPIs. - Be well-versed with creating DAX calculations in the Power BI environment. We require the dashboard to focus on specific metrics, therefore, a strong understanding of reporting on KPIs using DAX language is a must. Additional Skills: - Proficient in Microsoft Excel and SQL databases. - Understanding of data integration a...
I'm seeking an experienced blog writer who can eloquently narrate my recent venture in the startup ecosystem. Aside from just recounting my experiences, the main focus will be to communicate these in a manner that's both educational and informative for my target audience - the general public who has a keen interest in startups. Key tasks will include: - Developing engaging blog content around my anecdotes - Conveying realities of starting up in an educational manner - Making complex aspects of running startups understandable to a non-technical audience. The perfect fit for this project would be a freelancer with a solid background in blogging or journalism about entrepreneurial journeys and startups, and capable of...
First task is below 1) 1200 Youtube video link of recipes will be provided in google spreadsheet. for e.g each link with be 2) the person need to paste the link at 3) Cut and paste 3 windows record and 1 recipe image screenshot (from youtube) and then upload in a software ( a paid version will be provided) 4) expect to finish 1200 recipes in 60-100 hours. Please quote following if you want to try this project 1) how much for updating 1200 recipes as whole project? 2) How much is per hr rate?
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Ac...
I am looking for a Optimizely CMS expert who has expertise and experience like below. You could highlight your experience in the following areas for me: * Architecture, design, and development of websites and digital solutions using Optimizely CMS * 5 years of experience in web development, with at least 3 years focused on Optimizely CMS and Commerce development * Strong proficiency in .NET, C#, ASP.NET, MVC, JavaScript, HTML, and CSS * Experience with cloud platforms (e.g., Azure, AWS) and DevOps practices (desirable) * Demonstrated ability to architect and deliver complex web solutions on the Optimizely platform
You can see in this google drive folder: I have two spreadsheets: municipalities and duplicates. The duplicate spreadsheet contains all of the records in the municipalities spreadsheet that are considered a duplicate. I don't need any help determining a duplicate, that has already been determined. What I need is for someone to go through the rows in the duplicates sheet, and find those rows in the municipalities sheet, and highlight them. You can see an example of what I mean in the two images attached here. the 'duplicates_examples' image shows a series of duplicate lines, and the municipalities_duplicated image shows those lines highlighted in yellow. That is exactly what I am looking
...a skilful and creative professional to create an engaging explainer video about the functionality of our website/app. The goal is to simplify and communicate how our platform works to our regular users in clear terms. The project specifics are: - There's no pre-existing script, thus it will be your responsibility to invent a compelling, easy-to-understand narrative - The primary objective is to accurately and clearly explain how our website/app works, focusing on tools and features that users might find particularly useful and informative - Our target audience are the regular users of our website/app. The video should be extremely user-friendly, with the ability to explain complex concepts in a simplified way. Ideal Skills: - Experience i...
I'm in need of a custom Android application that will help me manage my daily tasks and keep track of my expenses and income. I'm aiming for simplicity and user-friendliness, as the app is for personal use only. Key Features: - Task Scheduler: - Ability to set reminders: I'd like to be reminded of important tasks or events. - Task prioritization: It should allow me to prioritize tasks based on their importance. - Task categorization: I need to categorize tasks according to their nature or urgency. - Expense Tracking: - Manual entry of expenses: I'd like the app to have a simple interface where I can manually input my expenses. - Categorizing expenses: The app should allow me to categorize my expenses for better organization. I'm not looking for...
I'm in need of a skilled translator to convert a biography Wikipedia page from Portuguese to English. Key Project Details - Translation from Portuguese to English: The Wikipedia page I need help with is a biography. The task requires the translator to faithfully convert the content into English while maintaining the original context and meaning. - Word Count: I'm unsure of the specific word count. It would be ideal to have a translator who can handle varying lengths of content efficiently. - No Additional Research: The primary task is to translate the existing content, without the need for additional research or the inclusion of new information. Ideal Candidate Skills - Proficiency in Portuguese and English: The ideal candidate should have native or nea...
I need an Excel expert to build a tool that can automatically validate and correct any incorrect country codes in the file. Requirements: - Replace incorrect country codes: The tool should replace the incorrect country codes with the correct ones. - Predefined list: The correct country codes should be determined based on a predefined list. - Daily updates: The tool should be able to handle daily updates. Ideal Skills and Experience: - Advanced Excel skills: You should have a deep understanding of Excel functions and VBA programming. - Data validation: Experience with data validation and manipulation in Excel. - Attention to detail: It's crucial that the tool is accurate in identifying and correcti...
I am in need of an expert who can continuously build and manage MIS excel sheets pertaining to data analysis, sales forecasting, and expense tracking on a daily basis. Key tasks: - Establishing excel sheets to analyze a broad range of data - Constructing a sales forecasting model within the excel sheets - Regular tracking and management of expenses via the excel sheets Data sources would primarily be spreadsheets and databases. These excel sheets will require daily updates, enabling close monitoring of key metrics. Ideal skills: - Proficient in Microsoft Excel - Exemplary skills in data analysis and modeling - Good understanding of databases and how to extract data from them E...
...application that combines information or functionalities from two or more web APIs in a useful and sensible way. This is called a Web Mashup. You are free to decide on the purpose of your application, and which Web APIs you use. However, the Web APIs you have selected need to work together to fulfil the purpose of your application. An example: An intelligent Flickr photo browser that displays photos related to user’s interest. This can be done by fetching user’s “like” from Facebook web API, and then use this information to retrieve Flickr photos (using Flickr search) related to user’s like. (Note: A good implementation of this application would be at a pass level) In a more sophisticated implementation, an analysis of use...
