"advanced modelling in finance using excel and vba" "spreadsheets"งาน
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...
สวัสดีค่ะ ไม่ทราบว่ารับทำโปรเจคทางด้าน Modelling, Simulation and Optimisation ใช้ python code ค่ะ
สวัสดีค่ะ ไม่ทราบว่ารับทำโปรเจคทางด้าน Modelling, Simulation and Optimisation ใช้ python code ค่ะ
ทำ 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
I need a skilled Excel professional to help me with data analysis and manipulation using the Solver add-in to solve optimization problems. Key Requirements: - Perform data analysis and manipulation in Excel - Apply Solver add-in to solve optimization problems Ideal Skills and Experience: - Strong proficiency in Excel - Prior experience with data analysis and manipulation - Familiarity with Solver add-in in Excel - Ability to interpret data to solve optimization problems - Attention to detail and accuracy for successful data manipulation Please include your relevant experience and how you can address the task described above in your bid.
Es ist eine Aufgabe die in Excel gemacht werden muss, bzw Excel Solver bis 10.05
La tarea sera la gestión completa de cuentas para los anfitriones de distintas pl...de propiedades. Necesitamos especialistas en atención al cliente que puedan encargarse de las tareas administrativas y la gestión de cuentas. Los requisitos para el solicitante incluyen gran atención a los detalles, título universitario, acceso al correo electrónico y conocimiento del uso de un dispositivo (computadora o teléfono), herramientas de software básicas (Microsoft Office - Word y Excel). Necesitamos miembros rápidos, precisos y especializados. Es obligatorio aprobar una prueba corta/terminar una tarea, que podría durar entre 2 y 4 horas, con posibilidad de extenderse hasta 1 semana, si el candidato está inv...
...skilled Excel dashboard developer to build a proficient tool to track vital business metrics a balance scorcard. The ideal candidate for this job should have: - Expertise in creating user-friendly KPI and balanced scor cards dashboards. - Understanding of various KPIs including revenue growth, customer acquisition, and conversion rate. Key Project Details: - I already have specific KPIs to be tracked and would share them with you post project initiation. - The dashboard should be designed to automatically update on a monthly basis based on manual input that would be added to calculation sheet for each kPI. - The dashboard must be easy to read, understand, and interactive. - the dash board should include risk alert for KPIs we are falling behi...
...carrier's 40% weighting in the Transportation Studies module and will be assessed by an individual report submitted via canvas. In your report you would need to include the experimental and the model results of your selected noise barriers. You will be judged on how you have been innovative in your conceive, design and how you improved the performance rating of your noise barrier. Assessment Criteria 1) Conceive (research noise barriers) = weight age (10%) 2) Project 1: Performance of reflective/absorbing noise barriers = weight age (40%) 3) Project 2: Traffic noise mapping = weight age (40%) 4) Modelling of noise barrier = weight age (10%) Project Details: Project Description: We are seeking a skilled freelancer to assist with...
...experienced and React.js developer to join our web development project. The main goal is to integrate APIs into a pre-existing template and add specific functionalities for a multi-company business management system. The system must be capable of managing multiple companies under a single platform, allowing administrators to easily switch between companies. MAX BUDGET: $ 400 USD Responsibilities: API Integration: Connect the frontend template with our API. Implement the necessary endpoints for the required functionalities. Validate the data received from the API and manage errors efficiently. UI/UX Functionalities Implementation: Implement language and theme changes in the user interface; the template already includes this functionality but it mus...
...seeking a skilled software developer to create a visitor management system that offers a range of advanced features. Key Features: - Visitor check-in/check-out: The software needs to manage visitors as they enter and exit the premises, logging their check-in and check-out times. - Visitor registration: A system that allows the entry of visitor details for security purposes. - Visitor badge printing: A key feature that's crucial for the seamless identification of visitors. - Delivery: The software should incorporate a delivery management system, tracking and notifying visitors when a delivery arrives. - Employee Sign in and sign out: A function that tracks the presence of employees as they arrive at and leave the premis...
I need to create a quantitative analysis system for the Finance market. I already have the calculations, but I need someone to pull the data using an API and perform the calculations to achieve the desired result using Python.
I am in need of a highly skilled and experienced Python developer to join our team. This can be the full time remore job opportunity to work on EST. My ideal candidate must have over 8 years of experience in Python, with proficiency in web development, data analysis, and machine learning. Key Responsibilities: - Develop the website from scratch, ensuring it is user-friendly and responsive. - Implement and integrate user registration and login functionalities. - Create interactive data visualizations to help users understand and explore the data. - Incorporate real-time chat support for enhanced user engagement. The ideal candidate should have: - Over 8 years of experience in Python. - Proven expertise in web de...
I'm in need of an expert to carry an advanced data scraping task on Github. Key project specifics: - The kind of data to be harvested includes not only text content and links, but also user IDs, emails and names. Therefore, this project requires someone with a skill set that allows for scraping beyond the surface level. Ideal Freelancer: - Ability to implement advanced scraping techniques to ensure quality and completeness of obtained data. - Experience in harvesting sensitive information like User IDs, emails and names. - Respectful of privacy laws and legal restrictions regarding data scraping. - Self-motivated, detail-oriented, and reliable. Please be ready to provide examples of similar projects you have...
...quantitative data analyst well-versed in AMOS and SPSS. The project is focused on: - Data Analysis: The main task is to conduct correlation and moderation in Amos. - Statistical Modeling: Create and employ statistical models as a critical part of the data analysis process, with specific focus on correlation and moderation. - Research Support: There will be some instances where you would need to support ongoing research. Knowledge in research methods would be advantageous. Ideal Skills: - Proficiency in AMOS and SPSS - Strong experience in statistical modelling - A background in quantitative data interpretation - Understanding of research methodologies - Familiarity with correlation and moder...
I am currently working on my PhD thesis, with its focus primarily on statistical analysis. I am in need of an expert in statistical analysis, particularly in inferential statistics, to assist me in my study. Key Skills and Experiences Needed: - Deep understanding of inferential statistics - Familiarity with hypothesis testing and established statistical software, such as AMOS SPSS - Background in handling advanced statistical analyses for academic research or a related area Expectations: - Assisting to lay out inferential statistical methods in the form of hypothesis testing - Converting raw data into comprehensive and understandable terms - Constructing and presenting data effectively to contribute to the ro...
...Cryptocurrency In the realm of digital currencies, Bitcoin stands as the pioneer, the trailblazer that sparked a global financial revolution. Born out of a white paper titled "Bitcoin: A Peer-to-Peer Electronic Cash System" published by the mysterious Satoshi Nakamoto in 2008, Bitcoin has evolved from a concept into a phenomenon that has reshaped the landscape of finance, technology, and beyond. Understanding Bitcoin: The Basics Bitcoin operates on a decentralized peer-to-peer network, utilizing blockchain technology to facilitate secure and transparent transactions without the need for intermediaries such as banks or governments. Unlike traditional currencies, which are controlled and regulated by central authorities, Bitcoin is gov...
...Cryptocurrency In the realm of digital currencies, Bitcoin stands as the pioneer, the trailblazer that sparked a global financial revolution. Born out of a white paper titled "Bitcoin: A Peer-to-Peer Electronic Cash System" published by the mysterious Satoshi Nakamoto in 2008, Bitcoin has evolved from a concept into a phenomenon that has reshaped the landscape of finance, technology, and beyond. Understanding Bitcoin: The Basics Bitcoin operates on a decentralized peer-to-peer network, utilizing blockchain technology to facilitate secure and transparent transactions without the need for intermediaries such as banks or governments. Unlike traditional currencies, which are controlled and regulated by central authorities, Bitcoin is gov...
As a project owner, I require a talented Android developer to create an intuitive and efficient application. Though I wasn't specific about the primary goal or progression of the project, the essential focus will be on executing an efficient Android app. Further details will be disclosed to the selected candidate. Ideal skills and experience required for this project: • Expertise in Android app development • Familiarity with Google Play Store's guidelines • Good understanding of UI/UX principles • Demonstrated ability to take a product from draft to launch • Capability to work flexibly as project requirements evolve Dipesh here , founder of SR finance! Our goal is to finance smartphone of low price range of 10k -20...
I am in need of a skilled photo editor to provide advanced editing for a set of 30 images. This comprises of not just light adjustments or retouching, but manipulating the images and even adding new elements to enhance them. The details required are as follows: - The images need to be edited to an advanced level, including manipulation and addition of elements. - The final format for the image edits will need to be in JPEG. - These images must be delivered in high resolution. For this task, I require an expert who has extensive experience with photo manipulation and has an excellent command of photo editing software. An eye for details, creativity, and accuracy is a must. Proven experience in delivering high-resolution...
...Cryptocurrency In the realm of digital currencies, Bitcoin stands as the pioneer, the trailblazer that sparked a global financial revolution. Born out of a white paper titled "Bitcoin: A Peer-to-Peer Electronic Cash System" published by the mysterious Satoshi Nakamoto in 2008, Bitcoin has evolved from a concept into a phenomenon that has reshaped the landscape of finance, technology, and beyond. Understanding Bitcoin: The Basics Bitcoin operates on a decentralized peer-to-peer network, utilizing blockchain technology to facilitate secure and transparent transactions without the need for intermediaries such as banks or governments. Unlike traditional currencies, which are controlled and regulated by central authorities, Bitcoin is gov...
I'm in need of an experienced developer who is skilled in machine learning and natural language processing, with a particular focus on training models for Text-to-Speech (TTS) applications. In this project, I require assistance in training a dataset from scratch to create a functional, ready-to-use model for Coqui AI TTS specifically designed for the French language using a specific voice. Key requirements: - Intermediate to Advanced level experience in machine learning and NLP. - Previous experience in training TTS models, especially with Coqui AI. - Proficiency in French is a plus. - Familiarity with working on a model for a specific voice. The ideal candidate should be able to guide me through the proces...
I'm currently ...currently seeking a skilled tutor to assist me in two key areas of MS Project - Scheduling and Task Dependencies. My current proficiency in MS Project is considered intermediate. I'm looking to improve these skills and advance to a more professional level with the software. I learn best through practical, hands-on exercises. This means that I'm looking for a tutor that can provide me with interactive, project-based learning experiences. Ideal Skills and Experience: - Proficiency in advanced MS Project features, particularly in Scheduling and Task Dependencies - Previous experience in tutoring or teaching MS Project - Ability to create engaging, practical exercises for effective learni...
I'm on the lookout for an experienced tutor specializing in Advanced Placement (AP) Precalculus and AP Calculus. The lessons will be conducted online, so proficiency with digital teaching tools is essential. Here's what I ideally need: - A thorough understanding of both AP Precalculus and AP Calculus - Pen-tab - Experience with US students If this is you, please bid with a sample tutoring video in English language on any topic of Calculus!
I am looking for an ...looking for an experienced video editor who can help me create engaging content for both Instagram Reels and TikTok. The primary goal of these videos is to captivate and interact with my audience. Key Responsibilities: - Performing advanced video editing to enhance the quality of the content. - Ensuring the videos are suitable for both Instagram Reels and TikTok. - Implementing creative ideas to engage with the audience effectively. Ideal Skills: - Proficiency in advanced video editing techniques. - Experience in creating content specifically for Instagram Reels and TikTok. - A deep understanding of audience engagement strategies for social media. If you're a talented video editor and content crea...
I'm currently in need of an expert in transportation economics to assist with a modelling project. The focus of the project will be on supply and demand analysis, and cost-benefit analysis within the transportation sector. Key Requirements: - Expertise in transportation economics modelling - Proficiency in supply and demand analysis - Skilled in conducting cost-benefit analysis -scenario analysis based cost and time Ideal Skills: - Extensive experience in econometric modelling and analysis - Strong understanding of transportation sector dynamics - Ability to interpret and apply economic theory to real-world transportation issues Experience with similar projects and a so...
...online, I'm in need of a proficient web designer to help me create a state-of-the-art e-commerce website. Key requirements for the website are: - Focus on Physical Products: The website is intended to sell physical goods, thus a user-friendly interface for showcasing these products is paramount. - Inventory Management: The site should feature an automatic inventory management system to streamline operations and ensure up-to-date stock levels. - Payment Method: I’ve chosen Stripe as my preferred payment method. Therefore, seamless integration of Stripe as a secure mode of payment on the website is crucial. The ideal freelancer for this project should have a wealth of experience in e-commerce website design, proficiency in the integration of au...
...photorealistic renders and videos for a range of products. The ideal candidate must excel in rendering techniques, possess meticulous attention to detail, and have the ability to breathe life into products through stunning visual representations. Responsibilities: Create photorealistic 3D models of products. Develop high-quality textures and materials. Render product images and videos using industry-standard software. Collaborate closely with the creative team to ensure alignment with brand guidelines. Optimize renders and videos for various platforms. Requirements: Demonstrated expertise in 3D rendering, modeling, texturing, and lighting. Proficiency in industry-standard 3D software. A strong portfolio sho...
...demonstrated through this project require expertise and experience in: - Development of coastal protection measures - Implementation of renewable energy projects - Adoption of climate-resilient agricultural practices It is expected that these initiatives will lead to the: - Reduction of vulnerability to climate change impacts - Enhancement of resilience to extreme weather events Therefore, professionals with experience in environmental conservation, renewable energy projects, and climate-resilient agricultural practices will be instrumental to the success of this project. Demonstrated experience in advanced coastal protection engineering is equally beneficial. By addressing these challenges, we will ensure sustainability and resilienc...
I'm looking for an Excel expert to develop an NSE options chain tool that will provide real-time data. The primary goal of this software is to facilitate educational purposes by explaining the basic concepts of options trading. Key Requirements: - Real-Time Data: The tool should be able to fetch and update real-time data from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency ...
I'm looking for a skilled video editor who can take my raw footage and transform it into engaging, high-quality content. My primary focus is on Reels - these short videos need to be creatively edited with advanced techniques like color grading and special effects. Key Requirements: - Skilled in advanced video editing techniques - Ability to execute color grading and special effects - Proficient in creating short-form content, particularly Reels - Experience in Instagram marketing The end goal of these edits is to drive sales, so I need someone who can help me create content that is not only visually appealing but also strategically crafted to encourage conversions. If you have a proven track record in video editing ...
