List of countries and states in excelงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
1. ใส่ VBA ให้รายการที่ Tickแล้ว ย้ายจากtabแรกย้ายไปเก็บใน tab2 (done list) และให้วันที่ในtab2 เป็นวันที่ที่ย้าย 2. ใน tab ถ้าวันที่ในรายการ ไหน <3 วันให้ทั้งแถวเปลี่ยนเป็นสีแดง
...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)
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
I'm currently residing outside of the United States and am in need of a US virtual number for business communications. This will be a long-term requirement, spanning more than 6 months. Key requirements: - Set up a US virtual number for business communication needs. - Ensure the number is compatible with WhatsApp. Ideal Skills and Experience: - Experience in setting up US virtual numbers for business purposes. - Familiarity with WhatsApp and its functionality with virtual numbers. - Ability to provide a number that can be used for an extended period of time.
...vehicles that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This technology is a technique that uses light to draw on the road surface in the direction the car is moving. The light changes direction and color based on the direction the car is moving. For example, the light drawing appears white behind the car when the car is in reverse, and orange on the left rear side of the car when it is making a left turn. <<NOTICE>> The target car brands in this search are limited to Japan, US, and Chinese brands. <Requirements for Payment> ・Submit documentary evidence that clearly states the details of the subject produc...
...product information of the autonomous driving system <Overview> Please collect product information on vehicles that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This product is related to the autonomous driving system. The system performs automatic driving control that allows the vehicle to drive automatically. Automated driving control includes automatic lane change, which causes the vehicle to change lanes. The system starts changing lanes upon receiving an instruction to start changing lanes, determines whether the conditions for stopping the lane change are met, and gives priority to the driver's steering if the driver turns the wheel while changing lanes. Duri...
Title: Collecting product information of autonomous driving systems. <Overview> Please collect product information on vehicles that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This product is about autonomous driving systems. When the driver operates the steering, accelerator, brakes, or other controls during automated driving, the system ends automated driving and switches the vehicle to manual operation. When the system requests the driver to end automatic driving during automatic driving, it notifies the driver that automatic driving will continue and prepares for manual driving, and then activates the operating means to end automatic driving. Notify the...
...information of the automatic braking of the vehicle <Overview> Please collect product information on vehicles that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This system is about automatic braking of the vehicles. This system can detect obstacles in front of the car and automatically stop the car in case of a potential collision. The system measures the distance and relative speed to obstacles and automatically adjusts the car's braking power accordingly. When the braking force reaches a predetermined value from its upper limit, the braking force is weakened. The upper limit of braking force is set t...
...technologies described in the “Technology Description” section below. <Technology Description> This technology arbitrates between control commands acquired from driving support applications that respectively implements driving support functions, outputs instructions based on a control command after arbitration to a processor that is able to control at least one of a brake actuator or a drive actuator. This technology also acquires a steering angle and a yaw rate as the control commands from the driving support applications. Please search for this technology in this contest. <<NOTICE>> The target car brands in this search are limited to US, European, Chinese, and South Korean brands. <Requirements for Payment&...
I have code for login trading accound and fetch token data. I need to update more data from the code to my system.I need to collect live data from the web and candle stick, Mins Intervals are in Dropdown box, I can choose any minutes interval, I need you to collect Last 5 candle data from the Excel in the web and other details for each token, I will give token name in the excel, It will automatically display the rows of data. If i chanage time interval it will display those data only. Need ot automate the buy/sell order Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet...
...seeking the skills of a self-motivated PHP developer, well-versed both in front-end and back-end development, including intricate database integration services. You need to have a comprehensive command of PHP to take on unpredictable project tasks. Ideal Skills and Experience: - Proficiency in PHP - Front-end and Back-end development capabilities - Experience in database integration - Robust problem-solving skills - Excellent communication As a freelance PHP developer for this project, you should bring a mix of creativity, forward-thinking, and technological prowess. You're free to engage this project with your unique style, stamping your innovation on our vision. Main Project Purpose: The main thrust of...
I am seeking a highly meticulous and efficient Data Collection Specialist to gather basic contact information for 25 agencies specializing in scripting video sales letters (VSLs). The task involves sourcing and validating agency names, email addresses, and website links, then recording these details into a spreadsheet. Responsibilities: -Conduct basic research to locate contact information for 25 specified agencies. -Validate that email addresses are current and active. -Accurately enter all data into a provided spreadsheet format. Requirements: -Experience in data collection and validation. -Proficiency in basic research and use of spreadsheets (e.g., Google Sheets or Microsoft Excel). -Ability to deliver acc...
I need an Excel 365 PowerQuery or VBA script that can fetch daily market data and handle potential data source interruptions or changes. Google Shhets example =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). <Where C31 = Cell containing the Stock eg GB00B8XYYQ86, LU1033663649 or GB00B0CNH163 I need an identical function in MS365 Excel - either with PowerQuery OR VBA (preferable) Ideal skills: - Proficiency in Excel 365 and PowerQuery and VBA - Experience in web scraping and handling dynamic data sources. I am after a fixed quote for this project.
...meet the must have criteria at the beginning of this job description post. We are looking for a motivated and successful grant writer located within Canada! The grant writer will be responsible for locating, researching, and applying for potential funding opportunities in order to ensure successful grant approvals. The Grant Writer MUST be Canadian or have the expertise and experience with the Canadian government, ideally living in Canada and speaks and writes English Fluently. They MUST specialize in IT/digital marketing/ ecommerce/employee hiring grants They MUST have a proven strong track record of total grants submitted vs approvals in the last year within Canada. They are responsible for finding fun...
...professional who can assist me with the formation of a single-member LLC in the United States. Key Requirements: - LLC Registration: The primary task will be to help me register a single-member LLC in the United States. - Registered Agent Services: I also need assistance with the provision of Registered Agent services. Ideal Candidate: - Legal Expertise: A strong understanding of LLC formation and US business laws is crucial. - Experience: Prior experience in registering single-member LLCs in the US and providing Registered Agent services is highly preferred. - Attention to Detail: The successful candidate should be meticulous and able to ensure all paperwork is completed accurately and prompt...
We are seeking a talented and creative logo designer to join our team. As a logo designer, you will be responsible for conceptualizing and creating unique, memorable, and visually appealing logos that effectively represent our brand identity. You will collaborate with our marketing team to understand our brand values, target audience, and design requirements. If you have a passion for design and can translate concepts into compelling visual representations, we would love to hear from you. Key Responsibilities: -Collaborate with the marketing team to understand brand requirements and design objectives. -Conceptualize and develop innovative logo designs that align with brand identity and target audience. -Present design concepts ...
I'm...expert researcher to build a comprehensive list of 3300 Chair of Governors from public secondary schools for me. Each secondary school has one, if a chair can not be found clerk of Governors acceptable. The budget is $100 no more - please send a sample of 10 to 20 Governors Key requirements include: - The list should be organized alphabetically by county/area - I need contact details to include email addresses and phone numbers. Your experience with web research, data mining and data entry will be crucial to successfully carry out this task. Knowledge of educational institutions and contact compilation is key. Please ensure that the details gathered adhere strictly to public schools only. I expect high l...
...create a custom CRM system in Excel for my business. Key requirements: - Sales Tracking: I need a system that allows me to monitor sales performance and forecast future sales. - Task Management: The CRM should have a task management feature to help me organize and prioritize my daily activities. Additional details: - The system will be used by a small team of 1-10 users, so it needs to be user-friendly and easy to navigate. - No integration with other software or platforms is needed at this time, so the focus will be solely on creating a robust, efficient Excel-based CRM. Ideal skills and experience for this job would include: - Proficiency in Excel, with a clear understanding of how to create complex formul...
...experienced in web scraping and data collation. The project will involve scraping blog articles in HTML format and compiling desired information into an Excel file. Key Project Requirements: * The extraction will be from specified URLs, using their individual patterns for efficient and accurate scraping. * For each blog article, I need the title, the full text, and the publish date extracted. * This scraped data must be properly arranged in an Excel file for easy analysis. * List of articles is here: Ideal Candidate Expertise: * Proven experience in web scraping is a must, preferably with full understanding of HTML structures. * Proficiency in Excel and data organization. ...
...Sources is looking candidates for Senior Business Analyst – VBA, Advance Excel. Job Role: Senior Business Analyst Job Location: Remote Experience: 4 + Years as Business Analyst – VBA , Advance Excel 3+ years of experience is required in creating dashboards in Manufacturing, Banking, Retail Industry. Working Hour: 3 hour per day (per day) Salary: 150 – 200 INR Per Hour Job Responsibilities : • Understanding Company requirements. • Understanding, consolidating and analyzing data from spreadsheets. • Creating dashboards, reports and charts in Analytics tools. • Working on financial and other types of modeling projects. • Having knowledge Dashboard Creation, Mainframe automat...
I'm in immediate need of a cloud-based stock management software with barcode generation, scanning, stock quantity tracking, and weight measurement functions. The system should enable me to: - Generate and scan barcodes for every product in my stock - Track the quantity of each item I have in stock - Measure the weight of my stock in grams I prefer a cloud-based solution that can be accessed and updated from any internet-connected device. The software should have an easy to use interface and be able to: - Enable manual entry of stock data - Support updating stock information by scanning barcodes - Automatically update stock data from my sales records The software could be developed in Exc...
I need an Excel sheet created with the primary purpose of data analysis. This sheet should have the following features: - Data Sorting and Filtering: This is crucial for making the analysis process efficient and easy to navigate. I need the sheet to be able to handle large amounts of data and allow for quick and convenient sorting and filtering. - Data Visualization: In addition to the data analysis, I also require the sheet to include line graphs. I believe that visualizing the data will make it much easier to understand and interpret. The ideal freelancer for this project is someone with a strong background in Excel and experience in creating data analysis tools. It is important that the ...
I'm in need of a freelancer to assist with data cleaning from PDF documents. The task involves organizing the data into an Excel spreadsheet. Ideal skills for this role include: - Proficiency in data cleaning techniques - Strong attention to detail - Proficient in Excel for organizing data - Previous experience in similar data entry tasks
We are looking for registered Nurses in Italy, Spain, France and Germany to participate in a very short and engaging online Medical Education research project. The task has two layers: -Participate in a very short online survey about Medical Education content -Recruit other Nurses to participate in the activity. Every recruit is reimbursed for their participation. Only registered Nurses from these countries should apply, please.
I want to scrape daily leads from LinkedIn Jobs, Indeed Jobs, , etc. The task involves extracting data from these job sites and exporting it to Excel sheets. It would be preferable to have some kind of automation that reduces human dependency in obtaining leads every day. If someone has already set up a similar process before, I would prefer that. Preference will be given to those who have previously performed lead extraction tasks for recruitment websites.
...operating in the healthcare sector, committed to leveraging data to enhance our services and support for medical professionals. Our focus is on identifying and connecting with newer medical professionals and travel nurses to offer them tailored opportunities and support. What We Need: We're seeking a talented web scraper who can help us gather specific data on medical professionals with new NPI numbers. Your task will involve targeting individuals in specific states and collecting their information accurately and efficiently. Your Responsibilities: Develop a web scraping solution capable of targeting specific states and names of medical professionals with new NPI numbers. Ensure the accura...
I require a skilled Excel VBA developer to create a dynamic system in Excel. The process should work as follows: - The system will generate a new CSV file when I hit a specific button. - The new CSV file should contain 'item data'. The item data will include: - Item name - Item description - Item price The CSV file should be structured in a simple, easy-to-read format, with each item's data on a separate row. I need this system to be easily maintainable in the future, so please ensure that the code is well-commented and organised. Ideal Skills and Experience: - Proficient in Excel VBA - Experience in dynamically creating CSV files - Attention to detail for correct data formatting - Ability to c...
tengo libros excel que tienen diferentes planillas, son registros de notas de estudiantes, pueden ser varias hojas del libro excel, quiero poder transferir esa informacion a hojas con el mismo diseño en gsheets, y viceversa, lo que ponga en excel quieor que se envie a gsheets, y lo mismo de gsheets, puedo tener varios libros excel, cada uno con diferentes datos, quiero que cada libro excel y gsheets sea individual referente otro, y que se almacenen en diferente cuenta de correo electronico. adjunto imagen de referencia de una hoja del libro en excel. quiero saber cotizacion, manera de hacerlo, que se requeriria por favor. una de las ideas, seria desarrollar una app android que funcione como plantilla, que al tener la direccion de un libro...
I am a new pool builder in Atlanta looking align with a Professional (Structural) Engineer who is REGISTED IN THE STATE OF GEORGIA, UNITED STATES for company projects. I'm currently to replicate the attached set of engineered plans that I have from our sister company in Florida. We build pools the exact same way using the same subcontractors. I require structural engineered plans for a medium-sized (up to 40 feet), in-ground swimming pool, constructed from concrete. - Design Expertise: Freelancers should have experience in designing medium-sized, in-ground concrete pools. Expertise in understanding the durability, strength, and aesthetics of concrete pools is essential. - Engineering Skills: The...
Project Overview: I am seeking assistance in integrating image links into two Excel sheets containing a total of 620 and 46 product entries for my Shopify store. Each entry includes links to the official websites where the products are sold. The task involves creating a new column labeled Images in both Excel sheets and inserting corresponding image links. This integration is crucial for ensuring that when uploading a CSV file to Shopify, each product will display its respective images seamlessly. Project Details: Scope: Adding image links to Excel sheets for 666 products in total. Task: Create a new column labeled Images in each Excel sheet and insert corresponding image links for each product. Requirement...
Complete Excel Analytical and Descriptive Analysis on provided dataset by Friday 4 pm
I'm in need of a professional who can analyze comprehensive survey data and present the results in a detailed, report that relates to each hypothesis for my thesis research. The analysis is expected to be done using Excel analyses then further descriptive analysis is needed, focusing on summarising the main characteristics of the data and how they prove/disprove each hypothesis. This will involve exploring the responses to the survey questions, identifying patterns, trends, and constructing summary statistics. The key deliverable for this project will be as follows: an Excel spreadsheet with... - raw data in one tab (provided for you in the attached excel document) - cleaned data a separate tab (pr...
...operating in the healthcare sector, committed to leveraging data to enhance our services and support for medical professionals. Our focus is on identifying and connecting with newer medical professionals and travel nurses to offer them tailored opportunities and support. What We Need: We're seeking a talented web scraper who can help us gather specific data on medical professionals with new NPI numbers. Your task will involve targeting individuals in specific states and collecting their information accurately and efficiently. Your Responsibilities: Develop a web scraping solution capable of targeting specific states and names of medical professionals with new NPI numbers. Ensure the accura...
