Working with large datasets 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)
คัดลอกข้อมูลจากเว็บไซต์ คัดลอกข้อมูลจากเว็ปไซต์ลงในไฟล์excel
หาข้อมูล 16 อย่างของ Blogger จาก 50 fanpage แล้วกรอกลงให้ excel ที่กำหนดให้
พิมพ์สูตรคณิตศาสตร์ได้ ตัวอย่างงาน
ต้องใช้ imacro คัดลอกข้อมูลจาก web site ลง excel
คีย์ข้อมูลต่างๆลง Excel การคัดลอกบทความต่างๆลง word
ทำ presentation งานโดยใช้ Powerpoint สามารถแทรกงานที่เป็นข้อมูล ตารางและกราฟ จาก data ที่เป็น Excel
...Preservation**: It's also important that the original formatting of the PDFs is maintained in the Word files. This includes font styles, sizes, colors, spacing, and other visual elements. - **Image Handling**: The PDFs contain important images that need to be accurately placed in the Word documents. This means the images should be correctly positioned and sized in the Word files to ensure the integrity of the original documents is preserved. I'm looking for a freelancer who has extensive experience in PDF to Word conversion, particularly with large-scale projects. The ideal candidate should be proficient in document formatting and handling images within Word files. Attention to detail is key for this project, as accuracy in...
...scientist specializing in ship engine assembly to analyze key parameters and offer process insights. Key Parameters and Metrics: - **Efficiency:** Analyze the efficiency of our ship engine assembly processes. - **Performance:** Look into the performance metrics of the assembly line. - **Reliability**: Assess the reliability of our ship engine assembly. Process Insights: - **Workflow Optimization:** Provide insights and recommendations on how we can optimize our workflow for better efficiency and productivity. - Collect datasets for llmRAG and embedding vector database - You should choose the models for llms and RAG and frameworks Ideal Skills: - Proven experience in data science, particularly in the manufacturing industry with a focus on ship engi...
I am in need of a large wooden sign for my restaurant and catering business. The sign should have a rustic look and feature either a bear or loon as a design element. It must clearly showcase the text "Restaurant and Catering". Specifics: - Material: Wood - Size: Large (more than 5 ft) - Display: Primarily for outdoor use Ideal Skills and Experience: - Experience in designing and crafting wooden signs, particularly for outdoor use - Knowledge of rustic design aesthetics - Ability to incorporate a bear or loon design in a visually appealing manner - Understanding of the requirements for signage in an outdoor setting, including weather resistance and durability - Portfolio demonstrating similar work would be a significant advantage. Ple...
I am seeking an experienced Power BI expert who can assist with generating intermediate reports. This role involves: - Working with Excel datasets. - Developing seamless processes to generate user-friendly reports. - Troubleshooting any issues that may arise during report generation. The ideal freelancer should have: - Excellent understanding of Power BI. - Experience in report generation. - Adept knowledge in handling Excel datasets. - An analytical mindset with attention to detail. Proficiency in Excel and experience with intermediate report generation will be highly advantageous.
I'm in search of a skilled content creator and blogger who specializes in entertainment content. Specifically, I require someone with a good understanding of Nigerian entertainment industry to create engaging text-based posts for a Facebook page. Key requirements: - Content Creation: You will be responsible for creating and posting the content on daily basis, focusing on the latest entertainment gossips and happenings in Nigeria. - Expertise in Nigerian Entertainment: The ideal candidate should have a good knowledge of the Nigerian entertainment industry, including celebrities, trends, and events. - Text-Based Posts: I am particularly interested in text-based posts. While images and videos can be used to compliment the text, the main focus sh...
I'm looking for an experienced Excel expert to create a customized spreadsheet for my construction project. The primary usage of the sheet will be for material and labor cost estimation, and I need it to include visualizations in the form of charts for budget allocation. Key Tasks: - Set up the sheet with the right formulas and functions to ensure accurate calculations for material and labor costs. - Design the sheet to be user-friendly, yet professional in appearance. The ideal candidate should have: - Proficient knowledge and experience in using Excel for construction projects. - Prior experience in creating similar spreadsheets with formulas and visualizations. - An understanding of the construction industry and the speci...
I have a complex Excel file with more than 10 worksheets that I need help with. The project involves three main tasks: data entry, formulas and calculations, and data analysis. Key Responsibilities: - Data Entry: - Ensure accurate entry of information across various tabs - Formulas and Calculations: - Implement necessary formulas and calculations to make sure that the data is accurately processed - Data Analysis: - Utilize Excel functions for data analysis Skills and Experience Required: - Proficient in Excel, including strong skills in data entry and formula creation - Experience in data analysis and visualization would be a plus - Attention to detail and accuracy are crucial as the data is spread across multiple tabs T...
I am looking for a skilled Elasticsearch expert to help with data indexing and analysis for a large dataset. The data to be indexed is primarily textual and it is sourced from database entries. Experience with database management and textual data analysis is a crucial requirement for this project. The primary tasks include: - Analyzing and indexing a large dataset from database entries - Setting up Elasticsearch for efficient data analysis - Implementing indexing strategies for textual data Proficiency in Elasticsearch, data indexing, and database management is benefit for this project. Familiarity with handling large datasets and textual data is a must.
...perform an in-depth exploratory data analysis. This analysis is pivotal for identifying trends and patterns, detecting outliers and anomalies, and assessing the data quality. You will need to create a PowerPoint presentation or slide deck along with a script or talking points based on your own perspectives and insights gained from your analysis, culminating into a 5-10min presentation. *Visuals must be included* A rough time breakdown for the presentation would be: 1-2 min introduction of datasets, why it was chosen etc. 3-4 min how the data was cleaned and analysed, talk about the insights, talk to the visuals presented. 1-2 min conclusion and wrapping up the presentation etc. Key Requirements: - Proficiency in data analysis and exploratory data analysis....
...stand-up banner and table cloth designs based on an existing PSD template. The project involves: - Designing a large stand-up banner and table cloth (8ft x 4ft) - Adhering to the provided PSD template style The final deliverables should be: - High-quality and print-ready designs - Utilizing the existing template while introducing new and creative elements - Designs should be suitable for a large format and visual from a distance As I'm not familiar with the printing terminology, I'll need you to ensure the design includes what is needed for a professional print job. Ideal skills and experience for this job include: - Proficiency in Adobe Photoshop/Illustrator - Experience in large format print design - Ability to maintain a consi...
I'm in need of a Wix website designer to create an engaging and user-friendly online store. This platform will cater to young adults, focusing on social justice-related merchandise. It must be modern and clean and user-friendly. Key Features: - Online Store: The main purpose of the website is to sell a wide range of social justice-related products. This will encompass more than 100 items, so experience managing large inventories is a must. - Blog Section: In addition to the store, the website will have a blog section. This is essential for SEO ranking, so design experience that incorporates this is a plus. - Drop-Shipping Integration: The website should be linked to a drop-shipping company, ensuring efficient and seamless order processing. Ideal Candidate: - Pr...
necesito un Software punto de venta con estas caracteristicas Especificaciones • Software de escritorio • Base de datos mariadb • Control de Licencias de manera remota con servidor • Demo de presentación • Grabado de videos de su desarrollo paso a paso Menú principal • En forma de pestañas • iconos e...teléfono 6. Correo 7. Sitio web 8. País 9. Departamento 10. Ciudad 11. Creador de moneda 12. Logo foto 13. Facturas tamaño carta y recibo 14. Creación de formas de pago 15. Creador de impuesto porcentaje de uso RESPALDO DE BASE DE DATOS 1. Respaldo de base de datos manual 2. Respaldo de base de datos al cerrar programa Configuración 1. Subida y bajada de productos de forma masiva con tablas de ...
Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
I have a large volume of both text and numeric data that I need inputted into Microsoft Excel. Here's what I need: - Accurate entry of the text and numeric data - Scaled to handle a large quantity of data - Flawless use of Microsoft Excel for data entry Ideal candidates will be detail-oriented, proficient in Excel, and able to handle a large volume of data. Proven data entry experience would highly be beneficial for this task.
I am on the lookout for a tech whizz who can streamline and boost our Squid and Linux configuration to more efficiently handle a large quantity of proxies, potentially using a /48 ipv6 for each, amounting to a massive number (~65k for a /32 and 512k for a /29). Currently, we are facing: - Proxy connection issues - Resource utilization problems We are working with an enormous number of proxies, way more than 50,000. Our current server is running on Ubuntu 20. Ideal Skills and Experience: - Proven track record with Linux (Ubuntu) server management - Thorough understanding of Squid protocols - Expertise in managing high-volume proxy servers - Solid capability to optimize system resources We need someone who can provide a smooth and superfast experien...
I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.
As part of my thesis, I'm in need of a 3D model and rendering for a co-working space. The project focuses on the entire building comprising 5 floors, but interior designs are only required for a few views. Key Requirements: - I'm looking for a modern style for the co-working space. - I require basic level of detailing for the 3D models and renderings, with simple textures and minimal details. The main areas to focus on for the interior views are the various workspaces within the co-working space. Ideal Skills and Experience: - Proficiency in 3D modelling software, specifically for architectural projects - Prior experience in creating basic level 3D models and renderings. The project is specifically aimed for my thesis, so ...
...for a highly skilled and experienced freelancer with a strong background in both economics and finance. Specifically, we require your proficiency in Stata and Matlab coding as well as a deep understanding of the Ramsey-Cass-Koopmans growth model. For this project, your responsibilities include but won't be limited to: - Coding in Stata and Matlab with proficiency. - Accurately interpreting and utilizing the Ramsey-Cass-Koopmans growth model. - Applying your economic and financial knowledge for effective economic modeling. We're looking to complete an advanced level of economic modeling. Therefore, you will need to demonstrate a high degree of competence and experience in complex economic theories, principles, and modeling. Your exp...
I'm in need of an experienced freelancer who can create a detailed model of a co-working space for presentation and visualization purposes. Key Elements: - Furniture and Layout: It is essential that the model accurately reflects the planned arrangement of workstations, collaboration areas, and other furniture. - Exterior Elevation: The model should also include an exterior view, showcasing the aesthetics and design of the building. The ideal candidate for this project should have: - Proven experience in creating detailed, realistic 3D models - sketchup Autocad plans are already there
I'm in search of an expert in MS Excel to help me with an advanced task involving formula creation. This project requires knowledge of macros and pivot tables. Your primary responsibilities will include: - Developing and implementing complex formulas in Excel - Ensuring the data is correct and displayed properly - Creating macros and pivot tables - Providing any insights that can help improve the overall process The ideal candidate should have: - Proven experience in advanced Excel tasks - In-depth understanding of macros and pivot tables - Ability to communicate effectively and provide clear progress updates - Attention to detail and accuracy in data analysis and formula creation
...custom-built house project. Key Details: - The house has a large floor area measuring over 2,000 sq ft. - The architectural style is contemporary. Your skills and experience should include: - Proficiency in architectural rendering software - Experience with large and modern property designs - Ability to interpret and translate 2D architectural plans into lifelike 3D form - Good sense of light, shade, color to realistically portray materials and surfaces Your task will involve creating: - Detailed and realistic exterior rendering reflecting modern design aesthetics - 3D floor plan rendering that provides a comprehensive view of the property layout Please, in your proposal, include samples of similar projects you've worked on in the past...
I'm seeking a skilled CAD designer for an urgent project. I need detailed plans for lot ...seeking a skilled CAD designer for an urgent project. I need detailed plans for lot splitting on a large parcel of land. This is planned for a presentation to potential investors and should focus on showcasing potential land use options. Key requirements: - Ability to create detailed CAD plans: You should be proficient in CAD to create detailed, professional plans. This includes incorporating topography and key landmarks for a comprehensive view. - Urgent turnaround: I need this project completed urgently. The sooner, the better. This project is crucial for my investor pitch. Your ability to deliver high quality work under time pressure will be valuable. Please include relevant e...
I want someone who can create a database in Excel/Access for Invoices Log (tracking for already processed invoices) with the following features. 1- A list of all invoices (Master List) with the field names I will provide. 2- A list of all Contracts with the field names I will provide. 3- A list of all Purchase Orders. 4- A list of Approvers who is approving the invoices. 5- A list of Accounts. 5- All of these list should be linked with each other. The database should have a main page, with link to the above mentioned list pages plus Add Invoice, Search Invoice, Search Approver, Search Contract, Search PO, Search Account and Reports pages. For Add New Invoice page, I should be able to add an invoice details in it, and if it's r...
I need 1 photo modified. The photo that needs to be changed = Model-car-photo1-8bit.jpg. The edits I need are as follows, and ...models arm marks and tan line. (). Remove Bright Reelections on car hood and window. (). Remove the large crack in the concrete ground. (). Make the car lights look like they are on. (). Edit the license plate so it says THT GIRL. Make it look real. () After those edits are done, please make the subject stand out from the background.. Maybe darken the car and background, to put more emphasis on the model.. Final Deliverable: I need the layerd PSD file with the various edits on separate layers.
I'm looking for fresh candidates who are enthusiastic about architectural drawing. No prior experience is necessary as I'll provide you with all the necessary training and guidance. Skills and Experience: - No prior experience needed - Familiarity with AutoCAD is a big plus, but not mandatory - Strong passion for architectural drafting - Willingness to learn and grow in the field Roles and Responsibilities: - Create architectural drawings using AutoCAD - Follow my guidance and instructions for the project - Be open to feedback and willing to make necessary revisions If you're interested in starting your journey in architectural drafting and are looking for a hands-on learning experience, this opportunity is perfect for you.
I'm on the hunt for a skillful coder proficient in web scraping, specifically for Website A. The goal of this project is for obtaining valuable and significant data for analysis, competitive intelligence, and price comparison. While there's no explicit mention of the type of data to be scraped, I anticipate that a capable offering will cater to a variety of needs such as: - Text content - Image content - Metadata Ideal Experience and Skills: - Proven experience with web scraping - High proficiency in handling large data sets - Comfort in navigating Website A - Ability to collect comprehensive data categories Looking forward to a potential collaboration to achieve this goal!
I'm in need of a creative professional who can both design large, eye-catching logos and apply them to T-shirts. Desired skills and experience for this project include: • Graphic design: As the logos are yet to be designed, your expertise in creating memorable and visually striking images will be critical. • Knowledge of textiles: Understanding how your designs will translate when printed onto fabric will make a significant difference to the finished product. • Experience in screen printing: To ensure the large logos are applied accurately and effectively on the T-shirts. • Attention to detail: Your meticulous eye will ensure the final product looks exactly as envisioned. Applicants with examples of previously designed lo...
We are seeking a skilled developer or development team to create a comprehensive web crawler system. This system should scrape, structure, and update information from web pages, handle large projects, and be accessible via a powerful API. The system should offer user-friendly features for both individuals and businesses and include flexible user management for both customers and employees. Project Requirements 1. Web Crawling and Data Extraction -Develop a system capable of scraping entire websites and extracting data from each page. -The system should divide the scraped information into sections to facilitate easy reading and understanding. -For e-commerce sites, the system should identify and structure the following information: --Product category (including breadcrumbs for hiera...
I’m in need of an experienced Excel software engineer who specializes in automation. The project revolves around automating data entry tasks in Excel. We are an accounting firm and I am looking to automate my compliance practices. Tasks include 1) rolling forward previous year excel work papers 2) taking information from. Client data sheets (excel) and importing into new excel workpaper workbook 3) data analytics based on metrics 4) hyperlink to source data Ideal candidates should have: - Proven experience with Excel macro programming and automation - Ability to work with numeric and legal data - Strong attention to detail to ensure data accuracy This will be a valuable addition to our workflow. Looki...
I'm in search of a talented sculptor who can create a medium-sized figurative sculpture out of marble. Key Requirements: - Figurative Sculpture: The piece should embody human or animal forms, executed in a classical or contemporary style. - Medium Size: The final sculpture should be up to 3 feet in size, requiring a keen eye for proportion and detail. - Marble Material: I specifically desire the sculpture to be carved out of marble. Expertise in working with this material is essential. Ideal Skills and Experience: - Proven track record in creating figurative sculptures, with a strong portfolio to showcase previous work. - Proficiency in sculpting medium to large pieces, particularly in the 3 feet range. ...
I'm looking for a skilled AutoCAD designer who can help with the layout design of a 10-floor office space. The space is quite large, each floor is approximately 1460 sq meter. Ideal Skills and Experience: - Proficiency in AutoCAD - Extensive experience in interior or office design - A good understanding of office space functionality - Strong communication skills - Ability to incorporate diverse requirements - Time management and multitasking capabilities.
