"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'm in need a freelancer to assist in the comprehensive design and development of a commercial electric car. This car will be a full hybrid, meaning it will be capable of self-charging, and will have a particular focus on energy efficiency. Key Responsibilities: - Full Exterior and Interior Design: This car needs to be visually appealing, and project a modern, sleek, and commercial image. - Mechanical and Electrical System Design: We need a team with a strong focus on engineering, able to create systems that are energy efficient and innovative. - Innovations: This is an important aspect of the project. We're looking for a team that can bring fresh ideas to the table, with a particular interest in self-driving...
What we have -------------------------- 1: Excel or CSV file. containing addresses to post letters 2: Letter Quality ( Paper weight, Sizes, Cost per letter etc configuration in JSON array) What we need -------------------- - Standalone PHP Script where we will be able to select an item from provided JSON. - Through DHL API we will validate the provided addresses(in the form of exel or csv) if each individual address is valid - or we should be able to select the areas of over choice over google map is shown in the provided video - this funcationaly is also provided over DHL api I think. and there demographic filters can also be applied which are provided be DHL api also shown in the video Please apply only if you the the required experience. the...
I'm in need of a virtual assistant who can handle various tasks. The ideal candidate should have the following capabilities: - Advanced Romanian language proficiency for translation tasks - Making outbound calls - Managing emails, scheduling, and data entry - Assisting in the translation and completion of company and business registration forms - conducting research I prefer my virtual assistant to be a problem solver, detail oriented, and proactive. Experience in a similar role and excellent communication skills are a must.
I'm in need of a professional who can convert both scanned documents and photos into simple data in Excel format (language is not in English workable when one can use translate and understand the few terms that are there). The ideal candidate will have the following skills and experience: - Proficient with MS office - Expert in handling MS Excel - Ability to follow a specific Excel template provided - Attention to detail to ensure accurate data entry ***The task is very simple and just requires attention to detail. I need mainly 4 Data Rows: 1. Date 2. Payor/Payee 3. Amount 4. Short Description of Transaction (if given in the doc) Please message me to talk about the project and the reali...
We are an Ecommerce company dealing with variety products and we are looking for a Social Media Ads Manager to join our team. The tasks includes but not limited to: Creating the ads on different Social Media Platforms Create reports in Excel, and Google Sheets on a daily and monthly basis Turning off the ads which are not delivering the acceptable ROI Creating a new ad for the stopped campain The Ads Manager must be solely free for this project and not committed to any other task, job or study work hours: 6 days a week, 10 hours a day The agent must be fluent in both Arabic and English Must also have good communications skills Can work on Excel Have sufficient experience in Social Media Ads and Digital Marketing
I'm looking for a skilled AI Developer to program module that speaks with AI (Gemini or GPT) as batch analysis of Excel files. Key Responsibilities: - Conducting pattern recognition and insights in the data Ideal Skills: - Strong AI development experience - Proficiency in Excel and data analysis - Ability to automate analysis processes
I'm in need of a skilled full-stack developer to create a website that is primarily aimed at monitoring the activities of employees within company. It is my university project that's why It doesn't need to be perfect like for a real company. And deadline is 21.05.2024 The website needs to have the following features: - the most important part is frontend and design - Company name EasyLang and website should contain company name -Time tracking: The ability to record employees' working hours accurately. - Employee attendance tracking: A system to automatically monitor the attendance of employees. - Task assignment and progress tracking: A tool to assign tasks to employees and monitor the progress of these tasks. - The WEBSITE sho...
I'm looking for an experienced product designer proficient in 2D and 3D software, to produce detailed sketches for my laboratory equipment business. The requirements are as follows: - Design various types of equipment including microscopes, centrifuges, and benchtop equipment like magnetic stirrers, heating mantles etc. - Need both 2D and 3D designs. - Expecting advanced level of detail in sketches, with all internal and external components highlighted. Having knowledge in scientific/laboratory equipment will be deemed a strong plus. Designers adept in bringing complex concepts to life and meticulous attention to detail will be preferred. Please share examples of your previous work with similar requirements.
I need a talented designer to envision the interior of a 500-1000 square feet one bedroom apartment. As I skipped the style preference, I am open to different ideas, whether modern, rustic or minimalist: - Propose an efficient layout - Choose color schemes, lighting, and materials - Provide 3D visualizations or sketches The bedroom features aren’t specified, hence a basic design with regular bedroom essentials will suffice. Ideal skills and experience: - Previous experience with apartment design - Proficiency in 3D modelling software - Creative eye for design - Good understanding of current interior design trends.
...for my website on technology, finance, and health. The successful candidate must have a strong understanding of SEO principles and be able to implement them effectively. The budget of the project is 0.1 to 0.15 PPW, so don't bid if you don't agree with the budget. Key Requirements: - Ability to write engaging and informative content on the mentioned topics - Should be plagirism--free (we will check in copyscape) and AI-free (we will check in copyleaks) - Experience in SEO writing for online content - Excellent research skills to produce high-quality, accurate, and up-to-date material - Consistency in delivering projects in a timely manner I am looking to pay on a per-project basis, making this an ...
As an investor seeking to streamline my algorithmic trading operations, I am in need of an able Python Developer who specializes in automation tasks. This role requires an individual with: - Mastery of Python and experience with automation tasks, most especially within the investment and stock market scenario. - Skilled and knowledgeable in stock market terminology with experience in use of Websockets for API integration Suitable candidates are expected to have good communication skills to effectively understand and implement required changes in a timely fashion. Help me maximize my trading potential with your Python expertise!
I'm in need of an Advanced SAP PAPM Trainer to join our dynamic team. The ideal candidate should: - Possess advanced expertise in SAP PAPM - Be able to deliver engaging and interactive training - Have prior experience in training others on this particular module Please note that we are specifically looking for an individual with a strong background in this specific module, rather than a general SAP professional. The training will be conducted remotely, so good communication skills and a strong internet connection are essential. If you fit this criteria, I'd love to hear from you. Let's discuss the details and how we can work together to ensure a successful training experience.
I'm in need of a skilled web developer to create a website that is primarily aimed at monitoring the activities of employees within company. It is my university project that's why It doesn't need to be perfect like for a real company. And deadline is 21.05.2024 The website needs to have the following features: - the most important part is frontend and design - Company name EasyLang and website should contain company name -Time tracking: The ability to record employees' working hours accurately. - Employee attendance tracking: A system to automatically monitor the attendance of employees. - Task assignment and progress tracking: A tool to assign tasks to employees and monitor the progress of these tasks. - The WEBSITE should C...
...presentation that outlines a recommended design for a command and control room, specifically tailored for marine operations, such as coast guard activities. This design should primarily focus on enabling monitoring and surveillance, as well as facilitating communication and coordination among personnel. Key Points: - The design should incorporate essential technology integrations. These include: - High-resolution displays for clear visual feedback. - Secure communication systems to ensure confidential information exchange. - Real-time tracking and mapping functionalities for operational supervision. Moreover, the command and control room should: - Be designed with ergonomic furniture and layout in mind for the comfort and e...
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.
Looking for an expert video editor with proficiency in Adobe Premiere Pro, experienced in advanced features such as animation and special effects. The aim is to take raw footage and transform it into an engaging video of more than 15 minutes. YOUTUBE CHANNEL NAME - CIVIL BEINGS. SUBSCRIBER COUNT 2.3 Million. The ideal freelancer would have: - Solid experience in Adobe Premiere Pro - Knowledge of advanced editing techniques, including animation and special effects - Capability to produce longer videos (more than 15mins) Your portfolio presenting similar works will be highly appreciated during the selection process.
I'm in need of an expert in Rapid Miner to assist in analyzing a dataset and generating an inference report. Key Responsibilities: - Perform advanced data analysis on provided dataset. - Create and execute predictive models. - Generate a comprehensive inference report based on the analysis and model results. (2500 words) I would like to pay $50 for this project
...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...
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 ...
I'm in need of a freelancer who can assist with inputting numerical data into spreadsheets. The primary objective of this task is to prepare this data for analysis. Key Responsibilities: - Accurately transcribe numerical data into spreadsheets - Ensuring data integrity and validity - Formatting and organizing data for ease of analysis Skills: - Proficiency in data entry and working with spreadsheets - Attention to detail and accuracy - Understanding of data analysis principles - Time management for meeting deadlines This project holds the potential for future data analysis tasks, so a keen eye for detail is crucial.
I'm in need of an intricate financial model designed for a residential property that focuses on calculating equity investments. Specifically, I want: - Informative analytics on 'Return on Equity', to evaluate potential profits over time. - An illustration of 'Cash Flow Distribution', to comprehend the income dispersions. - Analysis on 'Equity Multiple', to understand the total cash received against the total equity invested. Ideal freelancers will have a strong background in financial modelling, specifically pertaining to property investments. Understanding of debt financing, equity investments and capability in generating these specific outputs is critical.
I'm seeking a proficient data analyst to decode my online shopping platform's sa...The primary task is to accurately identify prevailing sales trends. Your role will encompass: - Cleaning and preparing raw sales data from the online shopping platform - Utilizing advanced statistical methods to analyze the data - Identifying significant sales trends - Providing a detailed report on the findings Ideal Skills: - Proven experience in data analytics, particularly sales data - Proficiency in statistical software like Python, R or SAS - Ability to interpret complex data and communicate findings effectively - Prior experience working with online shopping platform data will be advantageous. Your detailed understanding of sales trends will inform our ...
...mobile app. The app will essentially offer real-time market data and advanced charting features. Key Requirements: - Integration of TradingView API: The core focus of this project is to provide users with access to real-time market data and the ability to perform advanced technical analysis using TradingView's robust charting tools. - We will provide the datafeed with indicators required via web socket , the app will use this data and display a real time live chart on the app. You only need to do this chart on the app. No other funtions required. - Cross-Platform Development: You should have experience in developing cross-platform applications that run smoothly on both iOS and Android devices. flutter prefered. Ideal Skills...
I'm in need of an expert in financial modelling to help evaluate numerous real estate investment opportunities. This project is focused on comprehensive analysis of potential investments and to help me make informed decisions. Key Areas: - Evaluating Investment Opportunities: I need someone who can create robust and reliable financial models to assess the viability of various real estate ventures. Your models should help me identify and prioritize the most promising investments. - Financial Metrics: Your models should primarily focus on Return on Investment (ROI), Net Present Value (NPV), and Capitalization Rate (Cap Rate). These are the key metrics I need to see to make sound investment decisions. Ideal Candidate: - Proven Experie...
Hello! I need someone who is an expert in web programming with PHP to translate any kind of PDF for free in using PHP. This PDF must not lose its quality. It must remain intact and it must preserve the ORC format, style and all. I want the translation to be exactly like the one from onlinedoctranslator.com. I know you're going to tell me that the Google Translate api isn't free, but you can use this library (link removed) . Then it has to choose the number of pages in the PDF. Even if the PDF is 100 pages or more, it must be able to translate it. It must support encrypted PDFs and PDFs protected by passwords. I will use your code in my site. You can visit it and you'll see that the PDF translation is missing. I&...
I'm in need of a full-fledged ready made e-commerce marketplace that supports multiple vendors, with an emphasis on vendor dashboards. Here's a breakdown of the key components and features I'm looking for: - **Purpose**: The platform will be primarily for selling products. It will be app-oriented, with main categories dedicated to specific apps, and subcategories under each app to organize products effectively. - **Vendor Dashboards**: Critical for vendors to manage their products, sales, discounts, wallet, delivery options, and other details effectively.. - **API Integration**: I need a sophisticated API to allow for seamless integration with different systems and services, allowing for extended functionality and data exchange. P...
...freelancer to help me in drawing the developed Artificial Neural Network (ANN) which will predict data related to education. The visual representation of the selected parameters and the predicted data versus the actual data will be shown in the form of spreadsheets. Your role will be to: - Draw the developed ANN for education prediction - Show the selected parameters for the developed ANN - Visualize the predicted data versus the actual data in spreadsheets Ideal skills and experience: - Solid understanding of Artificial Neural Networks (ANN) - Experience in data visualization, particularly using spreadsheets - Familiarity with educational data or at least a background in developing predictive models in...
