Excel data structureงาน
Coding vba ให้คำนวนและรายงานผลลงในแถบ status bar ที่มุมจอ โค้ดทำงานได้กับทุกชีทในไฟล์ รายงานผลคล้ายค่า sum, average ที่โปรแกรมมีมาให้เดิม ทศนิยมสองตำแหน่ง เลือกเซลล์จากชีทไหนก็ได้ (เซลล์1จากชีทa เซลล์2จากชีท(n) 1. รายงานผลหาร เซลล์1/เซลล์2 2. รายงานผลลบ เซลล์1-เซลล์2 3. รายงานผลเปอร์เซ็นต์ เซลล์2/เซลล์1*100
กำลังทำธุรกิจเกี่ยวกับแพลตฟอร์มการท่องเที่ยว มีทีม dev แล้ว และอยากได้คนที่จะมาวิเคราะห์ วางแผน ออกแบบ structure / architecture / workflow / logic ต่างๆและแตกเป็นงานย่อยให้แก่ developer เพื่อที่จะได้เห็นภาพชัดขึ้น และ developer ทำงานง่ายขึ้นด้วยเช่นกัน
...สามารถ 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)
พัฒนาระบบอัตโนมัติสำหรับรวบรวมข้อมูลที่มีคุณภาพจาก Social Media เพื่อแยกประเภทตามโครงสร้างหมวดหมู่ต่าง ๆ ตามที่ต้องการในเว็บไซต์ได้ โดยไม่ต้องใช้คนทำงาน Can develop an automated system for collecting quality information from Social Media in order to classify according to various types of structure as needed on the website. Without using workers
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
Design structure houseand factory รับออกแบบโครงสร้างบ้าน Townhouse โรงงาน ทำรายการคำนวณประกอบการยื่นขออนุญาติรับเซ็นออกแบบบ้าน อาคารสูงไม่เกิน 4 ชั้นหรือ15 เมตร ตามขอบเขตของภาคีวิศวกร
I would like the assistant to do research about accounting services provided by the accounting offices in Thailand. I would like only Thai person since you have to search information in Thai. From the attached file, I would like you to search website of these accounting offices and p...research about accounting services provided by the accounting offices in Thailand. I would like only Thai person since you have to search information in Thai. From the attached file, I would like you to search website of these accounting offices and provide me the information about their services e.g. the list of services provided by these offices, service rates. I would like you to prepare in in structure manner that I will provide template later. Freelancer who has an accounting background would be ...
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...number of contacts). You need to make sure that these fields are also displayed in the mobile version of the site and add statement generation for these fields. * Set up the generation of a report (pdf file, form will be provided), which displays information about which users did not pay the bills of the previous month * On the 1st day of each month, files must be generated in Excel and XML-Format with the bank data entered by the contractor during registration and the amount to be paid from the account. One file for all users (form will be provided). * Fix the code when sending an E-Mail to the user at the time of invoice generation. Now email is sent many times in a row per day, it should be 1 time * Add one more page to the artist registration form, where you will b...
I need an Excel 365 PowerQuery script that can fetch daily market data and handle potential data source interruptions or changes. I will be providing a URL that contains the market data, and you'll need to replicate the Google Sheets function =INDEX(IMPORTXML("" & C31, "//span[@class='mod-ui-data-list__value']"), 1, 1). This function provides real-time data from the specified URL. Please note that the data is structured using HTML tags. Key requirements: - The PowerQuery should be able to be refreshed with the google sheet. - It needs to include robust error handling. If the data source is unavailable or the structure changes, the PowerQuery should not break but continue to function, ide...
I'm searching for a talented full-stack developer to establish an e-commerce site akin to Shopify but entirely focused on the upload and download of digital files. Key Functionalities: - Implement user registration and login feature. - Develop robust file upload and download functionality for various types of files: documents such as PDF, Word, and Excel; images including JPEG, PNG, GIF formats; and media files such as audio and video. - Integrate a highly secure and user-friendly payment gateway for transactions. Ideal Skills for this Project: - Proficient in full-stack development. - Experience in building e-commerce platforms, particularly with user account management and file sharing features. - Strong understanding of payment gateway integration. - Ability t...
... floorplan and rough design that works for our needs. We are looking for someone to design the pier & beam foundation to the required specs, and to produce all the drawings required for building permit approval in the Regional District of Central Kootenay in BC, Canada. Some more info: The roof structure will be engineered by a local truss provider. The building will be self-built by the homeowner Homeowner has experience with large renovations and small builds. The foundation/ floor structure needs to be engineered for 4.8kpa (small Commercial) and there are some floodplain requirements. Pier & beam foundation will be skirted, insulated, & conditioned to protect plumbing, with radon mitigation. Heating will be mini-split heat pump with gas fireplace seconda...
As your client, I'm looking for an Excel VBA expert who can make my daily processes more efficient by creating an automated reporting solution for me. Key Tasks: - Design and implementation of a VBA macro in Excel to automate the generation of cost summary reports. - The automated reports should be populated by data from four different worksheets, namely Worksheet 1, Worksheet 2, Worksheet 3, and Worksheet 4. Ideal Skills and Experience: - Excel VBA Programming - Experience with automated reporting - Understanding of data manipulation in Excel. -Possible migration of Cost Summary data to Word contract. In your proposal, please share samples of previous automated reporting projects done with Excel VBA. Commitment to deliveri...
I urgen...Key Requirements: - Detailed soil composition analysis: I need a thorough understanding of the land's soil composition. This includes identifying any potential risks or issues that could affect the construction process. - Bearing capacity analysis: It is crucial to assess the bearing capacity of the soil. This information will help to determine the type of foundation that will be needed for any structure built on the land. Timeframe: I require this evaluation to be completed as soon as possible. Ideal Skills and Experience: - Geotechnical engineer or similar background with experience in soil composition analysis and bearing capacity assessment. - Strong knowledge of construction feasibility assessment. Please provide examples of similar projects you have complete...
...pipeline that processes files from a folder structure. You can access the folder here Step2: Adaptation for Continuous File Deliveries: ● Adjust the pipeline to handle continuous file deliveries, where new folders with JSON files are added over time. For example: Step 3: Data Quality Assurance: ● Create a suite of data checks to ensure the data is clean and add a DBT command to run these checks. ● Suggest additional information or metrics that could be used to further ensure data integrity and quality. Key tasks would include: - Setting up DBT and SQLLITE - Developing and testing the pipeline - Establishing appropriate error logging and handling mechanisms Ideal Skills and Experience: - Strong proficiency in DBT and SQLLITE - Experience with da...
...WordPress plugins that will add to our site's functionality. - Content Updates: Regularly update site content based on the needs of our evolving business. Given the nature of these tasks, we're not just looking for someone with experience but someone with: - Deep understanding and familiarity with customizing Wordpress themes. - Have experience with the main aspects of a website: Site layout/structure, visual aesthetics, functionality and interaction. - Have a keen detailed-oriented eye to notice and fix inconsistencies on our site while implementing changes. - Experience in working with and improving SEO. Your relevant experience matters to us. Please share the Wordpress projects you've worked on before alongside your bid. In your bid, offer insight on how you ...
I am looking for a freelancer with expertise in PowerBi and Excel. The task will revolve around creating a one-time report/dashboard on PowerBi sourced from a single Excel spreadsheet. The ideal candidate should have: - Previous experience with PowerBi and Excel - Proven track record of data analysis - Attention to detail Please note that the Excel file won't be changing over time, so there is no requirement for the PowerBi report/dashboard to be updated. Content Description: I have statistics from every UFC fight and want basic visualizations made (I have a rubric)
I need an experienced structural engineer who can provide a structural engineered stamp for a residential timber building in Michigan. Your expertise will be needed to ensure the integrity of the timber structure for the building permit application. Key Requirements: - Proficiency in structural integrity assessments - Experienced with timber constructions in residential environments - Licensed to provide structural engineered stamps in Michigan - Deep understanding of local building regulations - Proven track record in structural engineering This project is more than just a standard assignment; you will be key in ensuring safety of a residential construction. Demonstrated experience in similar projects is essential.
I'm in need of a Webflow expert to help with some tweaks on my existing website. The main goal is to enhance the user experience by modifying the layout and structure, as well as improving navigation and menus. Those are the specific tasks I need help with. Key Requirements: - Proficient in Webflow. - Experience with UI/UX design. - Ability to modify layout and structure. - Apt at enhancing navigation and menus. I'm looking for someone who can execute these tasks efficiently and bring a fresh perspective to the website's design. If you have experience with similar UI enhancement projects, your bid is especially welcome.
I'm in need of a skilled Sketchup designer who can help me convert my house drawing into a 3D model. Your primary goal will be to create a visually accurate representation of my existing house, which will include details like windows, doors, and roof structure. However, the main focus of this project will be to add a pergola structure to the design. The pergola will be delivered by Key tasks include: - Expertly converting my house drawing into a detailed, realistic 3D model - Integrate the pergola seamlessly with the existing structure - Ensuring a high level of accuracy in terms of dimensions and scale The ideal freelancer for this project is someone who has: - Proven experience with Sketchup and 3D modeling - Strong attention to detail, especially when it co...
I'm in need of a WordPress expert to help me with a website. I want it to have the same structure of a specific existing website. Key Requirements: - Develop a WordPress website mirroring an existing one - Your application should include past works only Ideal Skills: - Proficiency in WordPress - Ability to mimic existing website structure - Strong portfolio with past works Please note that no specific features or design changes are required; just a replication of the existing structure. The successful freelancer will be able to deliver a fully functioning and visually identical website.
I'm seeking an Excel expert to create a user-friendly data entry workbook. The job is straightforward and requires the following: - **Data Entry:** The workbook should mostly focus on simple data, like names and dates. I am not looking for any intricate calculations, formulas, or pivot tables. The main focus is on creating an Excel workbook that streamlines the process of entering simple data in a structured and efficient way. Experience in creating user-friendly UX within Excel is a plus. No integration with external systems or services is needed - this is a standalone project. I look forward to collaborating with an experienced professional who can deliver an effective, easy-to-use data entry solution within Excel...
I require AutoCAD 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 ...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 construction of commercial ...
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 management principles. I look forward to working with a detail-orien...
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.
I am seeking a Squarespace developer fluent in integrating Eventbrite for event details display. Objectives: 1. Seamlessly Integrate with Existing Structure: I currently have a Squarespace site that needs integration with my Eventbrite account. 2. Event Details Display: The major function required is the display of event details directly on my website. Ideal Skill Set: - Proficient in Squarespace development - Successful experience in Eventbrite integration - Keen attention to details I look forward to building a successful website experience with your help.
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.
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 beneficial. - Attention to detai...
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.
...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 while significantly contributing to a growing company in the event managemen...
I'm in need of a structural drawing for a front porch addition to my residence, primarily aimed at enhancing the functionality of the entrance. Ideal candidates for the job should have experience with: - Designing front porch additions - Knowledge of materials, specifically wood construction - Experience with...construction - Experience with regulatory/permit submittal processes Key project attributes include: - Use of wood for posts and beams - Incorporation of a roof into the porch design. Porch is 15 feet wide and 7 feet deep, 6"x6" posts , ceiling height 101 inches The chosen freelancer should be able to deliver a design that successfully meets permit regulations, aesthetically complements the current structure, and fulfills its purpose of improving the fron...
โปรดลงทะเบียน หรือเข้าสู่ระบบ เพื่อดูรายละเอียด
I'm in need of a logo for my financial group, Terra Hedge Fund. We primarily deal with land investments and transactions. The logo should be rectangular and maintain a professional and sleek appearance. Key Requirements: - The logo must be rectangular in shape. - It should embody a professional look and feel. - The main themes of the logo should be land/earth and building/structure to reflect our core business in land dealings. Ideal Skills: - Graphic Design - Logo Design - Understanding of financial/business branding - Attention to detail in shaping a professional image
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.
