"advanced modelling in finance using excel and vba" "spreadsheets" jobber

...for an experienced professional who can create a custom Microsoft Excel spreadsheet for me. This spreadsheet will be designed to generate GUIDs (Globally Unique Identifiers) in a random fashion. The GUIDs will be used for database record identification. Key Requirements: - Development of a custom Microsoft Excel spreadsheet. - Implementation of a random GUID generation mechanism. - Ensuring the functionality for database record identification. Ideal Skills & Experience: - Proficiency in Microsoft Excel, particularly in custom formula creation. - Strong understanding of GUIDs and their usage in database systems. - Previous experience in developing similar solutions. I'm looking for someone who can deliver a well-f...

...experience in developing TV applications. The project involves the creation of a TV app that would support live TV streaming specifically. Here are the project specifics: - **Primary Feature**: The main function of the app is to support live TV streaming. This is the core feature that will require meticulous implementation. - **Content Categories**: The live streaming feature will specifically focus on TV content. This includes channels that cater to TV shows, documentaries, or other related TV broadcasts. - **Device Compatibility**: The app should be compatible with Samsung and LG smart TVs. The ability to ensure the app runs smoothly across different models of these brands is crucial. Ideal candidates should have: - Proven experience in developing TV applicat...

I'm seeking a professional with expertise in sound and vibration analysis to assist me with various tasks in this area. The specifics are as follows: - The tasks will include both noise and vibration analysis. - You'll be required to utilize advanced analytical techniques to solve problems related to sound and vibration. Ideal candidates should have: - Proven experience in Sound and vibration analysis. - Strong knowledge of analytical techniques and tools within this field. - Excellent problem-solving skills and the ability to work This is a great opportunity to work with a client who values expertise and professionalism in sound and vibration analysis. one day deadline

...a professional photographer with experience in real estate and vacation rental property photography. The Photo Shoot Will Include: - Vacation rental properties showcasing interior design elements, property exterior, and landscaping. - Capturing local attractions or amenities related to the properties. Ideal Skills For This Job: - Advanced skills in real estate photography, with a significant focus on vacation rentals. - Ability to capture and highlight interior design elements and property exteriors. - Proficiency in photographing local attractions or amenities. - A keen eye for detail to ensure the properties are presented in an appealing way. Candidates are desired to provide a portfolio of similar work done in...

I'm seeking an expert in Python for a Natural Language Processing project focusing on text classification of social media posts. Key Project Features: - The goal is to build a Python coding notebook that can efficiently classify different types of text within social media posts. This will require a deep understanding of NLP principles and techniques. - The project primarily demands the use of Python for its implementation. Ideal Skills and Experience: - Expertise in Python programming is a must. - A strong background in NLP, particularly in the area of text classification, will be highly beneficial. - Prior experience working with social media text data would be a plus. If you're confident in your Python and NLP skill...

I'm on the lookout for an experienced video editor with superior skills in advanced editing techniques including color correction, special effects, and audio enhancement. The project comprises editing a video of a duration exceeding 10 minutes. Skills Required: - Expertise in advanced video editing techniques - Proficiency in color correction - Special effects implementation - Audio enhancement abilities Please note, a storyboard or script isn't provided, allowing you full creative control to bring the footage to life. Applications from individuals with a knack for creativity are particularly welcomed. Your portfolio demonstrating your past work would be advantageous during the selection process.

I'm in need of a talented 3D artist to create and turn high-quality 3D product models of golf carts into photorealistic digital assets ready for use on our website. I require: - More than 10 unique variations of golf carts. Each variation should appear distinct and unique from the others. Key Skills needed: - Extensive experience in modelling, texturing and rendering 3D models. - Proven ability to create photorealistic models. - Knowledge of the golf cart industry would be beneficial. Please include your portfolio demonstrating your photorealistic 3D modelling skills when bidding.

We are seeking a highly skilled and experienced Data Scraping Specialist to optimize and significantly increase the speed of our current data scraping processes. The ideal candidate will have extensive experience in web scraping, advanced knowledge of bypassing anti-scraping measures, and proficiency in utilizing cloud-based solutions for enhanced performance. Strong problem-solving and hacking skills to navigate complex web security systems are essential for this role. Responsibilities: Analyze and improve existing data scraping scripts to maximize efficiency and speed. Implement and manage cloud-based solutions (AWS, GCP, Azure, etc.) for scalable scraping tasks. Develop advanced strategies to bypass anti-scra...

...seeking an experienced Excel professional to assist with a small data entry project. Key Responsibilities: - Data entry with formulas: You should be proficient in Excel and comfortable working with spreadsheets that require formulas. - Handling digital data: You will be provided with data in a digital format, likely an Excel or CSV file. Ideal Skills: - Advanced Excel skills: You should be well-versed in Excel, particularly in data entry and formulas. - Attention to detail: Precise data entry is crucial for this project. - Efficient and organized: I'm looking for a freelancer who can manage their time and workload effectively. Please note that this is a straightforward pro...

...who specializes in both Java and Python. I'm seeking advanced-level guidance, mainly through the following: - One-on-one mentoring: You will provide personalized, in-depth insights catered to my capacities, skills, and learning speed. We will explore challenges and complex concepts together. Patience and exceptional communication are crucial. - Expertise in Java and Python: You must demonstrate a solid understanding and practical application of these languages in the industry. Exit profiles such as the development of complex systems, application in advanced artificial intelligence, or extensive backend management would be ideal. - Advanced Level Programming: I need a tutor who can...

I'm actively seeking virtual assistants proficient in using advanced software tools, including cloud storage and project management software. Essential tasks that need to be managed are: - Data entry: Accurate and efficient data input is required, particularly into project management software. - Email and calendar management: Duties include organizing my inbox, prioritizing emails, and managing my schedule. I anticipate requiring support for more than 20 hours a week. As such, freelancers should be available to commit to a significant amount of time. Ideal candidates will have a proven track record in similar roles and excellent references.

I am seeking an experienced Excel expert to help resolve an issue with a percentage calculation in my Excel spreadsheet. Despite following standard procedures, the result is incorrect, and I need assistance to identify and correct the problem. Details: I am working with the following data in my spreadsheet: Total Costs for the Job (Cell V14): $241,779.50 Total Collected (Cell V17): $289,844.00 Profit (Cell V15): Calculated as =V17 - V14, resulting in $48,064.50 I need to calculate the profit as a percentage of the total costs, and this should be displayed in cell V16. The formula I am using is: = ( ? 15 / ? 14 ) ∗ 100 =(V15/V14)∗100 Given the values: = ( 48 , 064.50 / 241 , 779.50 ) ∗ 100 = 19.8...

...EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precision, recall, F1 score...

I'm seeking a skilled data entry specialist to assist with removing duplicates from spreadsheets comprising various datasets. The primary goal of this task is to ensure that our data is clean and free of any redundant information. The spreadsheets will be provided for you to analyze and clean accordingly. Ideal candidate must have: - Proven experience in data entry, particularly data cleaning and deduplication. - Proficiency in working with spreadsheets. - Attention to detail and high level of accuracy. - Ability to understand and follow provided data cleaning guidelines. If you fit the criteria and are ready to undertake this task, I look forward to seeing your proposal.

I need to make updates to userform so that empty dates do not affect filter on table. Right now leaving date field empty hides all the rows of table. Few more updates needed and more details will be shared with selected freelancer.

I'm looking for a data scraping specialist proficient in leveraging social media platforms, business directories and website scraping. The goal is to create an Excel sheet with approximately 500 entries for market research purposes. Skills & Requirements: - Proficient in data scraping from multiple sources - Capable of filtering and sorting data - Able to extract and compile the following data fields: zip codes, locations, contact information, business name and industry. The successful candidate should demonstrate experience in similar projects, showcasing their ability to find and compile information efficiently and accurately for market research purposes.

I'm in need of a skilled developer or team that can design and build a highly specialized mobile platform. The platform should be able to adapt to various unique applications. This platform should be intuitive, user-friendly, and able to support a range of features. Key Features: - Natural Language Processing: The platform should possess advanced natural language processing capabilities. - Voice Chat: The ability for the platform to support voice-based communication. - Image and Multimedia: The platform should support a range of multimedia options, from text to photo uploads. Platform Support: The mobile application should support the interface and experience similar to that of Pi from Inflection AI or ChatGPT from OpenAI. Design: The desi...

This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data

I'm seeking an experienced Advanced GMAT tutor to help me excel in the exam. I've chosen to study online, so please ensure you're comfortable with this format. Key Requirements: - Expertise in Advanced GMAT: I'm at an advanced level and I need a tutor who can help me elevate my skills to the next level. - Comprehensive Coverage: I need support in all areas of the GMAT including Quantitative section, Verbal section, Integrated Reasoning, and Essay. - Online Teaching Skills: As I'll be doing all my learning online, you must be adept at teaching through this medium. Ideal Skills and Experience: - Proven track record in GMAT tutoring, especially with advanced students - Strong underst...

I'm looking for a skilled Photoshop artist to professionally enhance a photo by adjusting the colors and lighting. Key Tasks: - make the sea blue/turquoise in the attached photo Ideal Skills: - Advanced color-correction skills in Photoshop - Proven record of achieving natural-looking, flattering results in lighting adjustment - Deep understanding of visual focus in a photo and ability to subtly shift it to a chosen object or person.

I'm in search of a proficient freelancer who has expertise in utilizing MATLAB R2021a for complex Image Processing tasks. As my requirements are quite specific, it is crucial that the preferred candidate has in-depth knowledge of this software and can make the most of its advanced features. Key Responsibilities: - Conduct comprehensive Image Processing tasks - Utilize MATLAB R2021a to its full potential Ideal Skills and Experience: - Profound understanding of MATLAB R2021a - Significant experience in Image Processing - High problem-solving skills using MATLAB Given the specificity and technical nature of this job, candidates who can showcase samples of their previous work with MATLAB, specifically in Imag...

I'm in need of an experienced UI/UX Designer for an iOS app dealing with style and fashion. Core Functionality: - The app is essentially a style and fashion app. It uses AI to help people look their best. - The main functionality of the app is to provide a virtual try-on for clothing, offer color matching suggestions and give personalized style recommendations. Target Audience: - The app is designed for both men and women. Ideal Skill Set: - Previous experience working on fashion or style-related apps is a plus. - Knowledge of AI integration for virtual try-on features is highly desirable. - A keen understanding of color theory and style is important. - Ability to create user-friendly and visually appealing interfaces. - Strong commu...

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to iden...

Project is basically about reading data from file and then using algorithms and data structures sort those data as its needed and then write short documentation...I will also need you to explain me everything you made, how it works etc...Project consists of 4 chapters...1 chapter will be pinned

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

Thank you!

I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts i...

I'm looking for a skilled Shop...developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-party Google map API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Javascript -> jQuery ->...

...skilled real estate photographer, specializing in shooting residential homes, commercial properties, and vacation rentals. You will be responsible for capturing the true essence of these properties through both basic and advanced techniques like HDR photography and video tours. Key areas of focus include: - The facade and outdoor spaces, capturing their uniqueness and charm - Specific rooms like the kitchen and the living room, showcasing their functionality and ambiance Preferred Skills and Experience: - Proven experience in real estate photography (will train) - Proficiency in both basic and advanced photography techniques - Keen eye for architectural details - Ability to capture ...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details...

...a highly skilled and motivated Google Ads and Facebook Ads Specialist to join our dynamic marketing team. The ideal candidate will have a proven track record in managing and optimizing paid advertising campaigns on Google and Facebook to generate high-quality leads. You will be responsible for strategizing, executing, and analyzing ad campaigns to drive conversions and achieve business goals. Responsibilities: Campaign Strategy and Planning: Develop and implement comprehensive lead generation strategies using Google Ads and Facebook Ads. Conduct market research to identify target audiences and create detailed customer personas. Set clear objectives and KPIs for each campaign to measure success....

I'm looking for a skilled React developer who can assist in changing a Stripe integration to specifically for the payment form. - The integration should support recurring payments. - The payment form needs to collect the user's Name, Email, and Phone number. Ideal candidate: - Proficient in React and has experience with payment gateway integrations. - Familiarity with is a plus.

...on WordPress, and will require interns, who will be given adequate training to work on this project. Your responsibilities will include: - Designing and structuring a blog that's user-friendly, easy to navigate, and visually appealing - Creating informative and engaging content that's daily updated, appealing to a general audience - Implementing AI tools to assist in content creation The ideal candidate should have the following skills/experience: - Proficiency in WordPress, with prior experience in blog creation - Strong writing and editing skills, ensuring content is engaging and informative - Familiarity with AI tools, or a willingness to learn and adapt to using these tools - Prior experience ...

Contact me for details i will explain better

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed

I'm looking to develop an Android app using .NET MAUI that focuses on facial detection and tracking for attendance monitoring. Key Requirements: - **Facial Detection:** The app should be able to detect faces in real-time. - highlight detected face with rectangle shape - **Server Communication:** Once faces are detected, the app needs to send this information to a server automatically. - **Attendance Tracking:** The primary goal of the app is to leverage this face recognition technology for attendance tracking purposes.(but no need do any page for this now ) Ideal Skills: - Proficient in .NET and MAUI platform for Android development - Strong experience with facial detection and recognition technologies - Prior work on real-time server commu...

I am looking for a professional Laravel developer who can help in creating a Laravel dashboard. Your experience and skills in working with Laravel will be key in accomplishing this project. This job includes: - Developing a Laravel application for a dashboard - Incorporating specific features into the dashboard, such as: * User Management * Data Visualization * Report Generation * External API Mapping to frontend Your Profile: - Expert Laravel Developer - Extensive experience in creating unique, efficient dashboards - Proficient in user-management systems - Strong background in data visualization - Exemplary skills in report creation and generation Excellent project understanding and creativity are essen...

I need someone to enter 500 purchase invoices into an Excel spreadsheet. I will provide a template for the format. The invoices will be sent to you as digital files through a cloud service, which you'll use to input the basic details like date, vendor, and amount. Ideal Skills and Experience: - Proficiency in Excel for accurate data entry - Experience in processing financial documents - Attention to detail to ensure data accuracy - Ability to handle sensitive financial information with confidentiality - Familiarity with using cloud services for file management Please let me know your experience with similar projects and how you plan to ensure the quality and efficiency of the data entry process.

...our team and help finalize our ride-hailing application. The app is nearly complete, but we need assistance in implementing and refining our two-way communication system within the match-making component. The ideal candidate will have a strong background in Flutter, Bloc state management, and Node.js APIs. **Responsibilities:** - Debug and enhance the two-way communication functionality in our ride-hailing app. - Collaborate with our backend team to ensure seamless integration with Node.js APIs. - Implement and optimize Bloc state management for efficient state handling. - Ensure the app’s match-making system works reliably and efficiently. - Conduct thorough testing to identify and fix any bugs or performance...

...code using JavaScript, HTML5 or using Python, so experience or proficiency in this language is crucial. Key Requirements: - Users should be able to drag and drop objects using mouse or in case of mobile- fingers. - It should offer a moderate level of interactivity. This includes features such as adjusting quantities and temperatures. If a user pours something in a beaker, it should show the beaker full. If emptied, beaker is empty. - Vector images of lab equipments like Test tube, beaker, burner etc can be found online. Ideal Skills: - Proficiency in Python or JavaScript. You may use CreateJS libraries. If you are a programmer with a passion for chemistry, this is a great opportunity to combine your skills in prog...

I'm looking for a skilled Excel expert to create a project tracking sheet with a calendar section that lists weekly milestones. Key Features: - The main sheet is for tracking project progress. It should include: * Project /Task Name * Start Date * End Date * Progress (percentage) * Priority * Action plan * Comments - The calendar section should list team schedule. * Team working schedule "in office / out of office" * Team calendar "working remotely, annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a proj...

I'm in search of a skilled professional with JEST experience to help me create thorough JEST Test classes for my highly complex Lightning Web Components. Key Requirements: - You should have experience in JEST test writing, particularly for Lightning Web Components - The tests you write should focus on ensuring the functionality of these components - The complexity of the components demands that you employ advanced testing strategies - Your tests should aim for integration with other components/services You should have an eye for detail, and be able to provide comprehensive coverage, making sure the components function correctly and interact well with other pieces of the system. Your task will be to write test classes that will provide me with ...

I am in need of an experienced video editor to help me replace a face in 4-6 scenes of my video with another face. The ideal candidate will have a good eye for detail and the ability to make the replacement look as natural as possible. Key Requirements: - Replace face in 4-6 scenes - Make sure the replacement looks natural - Deliver high-quality video editing work Skills & Experience: - Proven experience in advanced video editing - Familiarity with face replacement techniques - Ability to seamlessly integrate new face into scenes - Strong attention to detail Please provide examples of similar work you've done in the past. I'm looking to hire someone who can deliver high-quality work within a reasonable timeframe.

...to create a comparison website to help potential traders assess and select proprietary trading firms in the finance industry. Key Requirements: - The site should have a comprehensive database of different proprietary trading firms, their key features, and offerings. - Users should be able to filter and compare the firms based on various criteria like trading strategies, capital requirements, and more. - A user-friendly interface and robust backend that can handle large amounts of data and provide real-time updates are crucial. Ideal Skills & Experience: - Web development experience, particularly in building comparison websites. - Understanding of finance and proprietary trading firms. - Proficiency in...

I'm looking for a ...specifically tailored to help my sales team improve their performance and to calculate their incentives. Key Requirements: - Compatibility: The software should be compatible with Windows. - Integration: There's no need for the software to be integrated with any existing systems, so you can focus solely on creating the best software for our sales team. - Data Input: The software should have the capability to import data from Excel/CSV files. This method will facilitate the input of sales data and make the software more user-friendly for our team. Ideal Skills and Experience: - Proficient in Windows software development. - Experience in creating software for sales teams or incentive calculation. - Familiarity with ...

I'm in need of a skilled Web Application Developer to create a sales incentives system that will handle complex calculations and generate comprehensive reports. Essential Features: - Commission Percentage Calculation: The system should be able to calculate the commission based on the sales made. - Bonus Calculation: The application needs to compute bonuses based on the sales targets achieved. - Tiered Incentives: The system should offer tiered incentives based on the sales performance. Additional Requirements: - User-Friendly Interface: The application should have a simple, intuitive interface for easy usage. - Reporting: The system should generate detailed reports on the sales incentives calculations. - Security: It's crucial that the application ensures the dat...

I require a skilled digital photo editor who can transform an iPhone-taken picture into a polished 24x36 inches print photo. The work involves some vital tasks: - Enlarging the iPhone...24x36 inches print photo. The work involves some vital tasks: - Enlarging the iPhone photo to 24x36 inches without sacrificing the quality of the image. - The photo needs color correction to make it more vibrant and appealing for print. - Image sharpening is also required to enhance the overall detail and make the photo appear crispier in the final print. Experience in using advanced photo enhancing tools and software is a necessity. Familiarity with producing high-resolution, print-ready images is an added advantage. Looking forward to a beautifully finis...

I require a highly skilled computational fluid dynamics expert to perform a meticulous fluid ...requirements of this project include: - A deep understanding of fluid dynamics, notably turbulence. - Proficiency in using advanced simulation software. - The ability to precisely identify flow patterns. Key outcomes of this project include: - A comprehensive identification and analysis of flow patterns within a turbulent system. Ideally, the freelancer should have: - A background in Computational Fluid Dynamics, particularly turbulence. - Extensive experience with fluid flow simulation. - Detail-oriented analytical skills. Ultimately, this project aims to reveal insights into turbulent fluid flow patterns, providing valuable information...

I'm looking for a professional who can plot GPS coordinates from an Excel spreadsheet onto a map. This map should be easy to interpret, displaying the route taken by a vehicle. Key requirements: - The data provided is in Excel format. - The final map should be a static image file. The main task of this project is to: - Visualize the route taken by a vehicle based on GPS coordinates. - Timestamps are crucial and should be displayed in a clear, understandable manner. - Since I want to see the exact route taken, the map should display addresses corresponding to the GPS coordinates. Although the main focus of the project is plotting the coordinates and timestamps, other features such as: - Distance between points. - Speed of the vehicle. - Est...

Transform my basic, education-oriented PowerPoint slides into something simple but visually engaging. Your task involves: - Reimagining the slides to have a strong visual impact which can effectively educate an audience - Creatively incorporating cool tones, blues and greens, into the design while keeping it professional - Balancing intricate design details with clear, readable information presentation Ideal freelance applicants should have advanced skills in PowerPoint design and an understanding of color theory. Experience in creating educational content will be highly beneficial. I am looking forward to seeing your creativity shine.