I'm in need of a skilled Excel expert who can help me build a formula that integrates data across multiple sheets. The formula needs to leverage advanced functions like VLOOKUP, INDEX/MATCH, and ARRAY. Key Requirements: - Advanced Excel proficiency - Expertise in VLOOKUP, INDEX/MATCH, and ARRAY functions - Experience with multiple sheets data integration - Strong problem-solving skills and attention to detail Please note that this isn't a project suited for beginners in Excel. You should have a proven track record in working with complex formulas and integrating data across different sheets. Your ability to deliver accurate and efficient solutions will be greatly valued.
As an investor, I require a CFA-qualified professional to assist with complex bond pricing tasks. Specifically, my investment portfolio focuses on municipal bonds and I am keen on better understanding their quantitative pricing. Key tasks will include: - provide spreadsheet with all cash flows and formula - extrapolate discount rate using forward sofr and muni curve - The perfect candidate will have a strong background in quantitative investment analysis, a solid understanding of bond markets, and proven experience in pricing municipal bonds. In-depth knowledge and practical application of quantitative pricing models will also be highly advantageous. In the end, I just want excel spreadsheet delivered in a day
Hello harry, are you able to make the same website in 2 days ?
xin chào tôi càn tạo mã khoá và giới hạn thời gian sử dụng cho ALF tư amibroker của tôi
...to create a live data feed plugin for Amibroker, specifically connecting to NSE (National Stock Exchange) in India. Key Requirements: - Real-time stock prices, historical data, and market indices are the primary data types I need the plugin to fetch. - The data should be updated every second, ensuring the most up-to-date information is available for analysis. Ideal Skills and Experience: - Strong experience in plugin development for Amibroker. - Proficient in connecting to NSE data feeds. - Solid understanding of real-time data processing. - Prior experience in developing data plugins for the financial markets will be a plus. The successful candidate will need to ensure the plugin is reliable, accurate, and delivers the data smoothly to Amibroker. I would also ...
I have a requirement to develop a bespoke Microsoft Excel spreadsheet to calculate sales commissions. Let me share the specifics: - The variables: I want this spreadsheet to take into account the Sales Volume, the Profit, and the Commission Percentage while computing sales commissions. - Calculation specifics: Commission should be determined according to a custom formula that considers the Commission Percentage. - Data input: The spreadsheet should be easy to use, allowing me to manually input the data for calculation. The ideal freelancer for this project would be someone well-acquainted with the mechanics of Microsoft Excel and its formulas. Relevant experience in the field of sales calculations would be an asset. I am trusting that this tool will enhance efficient determinati...
I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spr...the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong understanding of Excel functions and data manipulation techniques. The success of this project relies heavily on precise execution and attention ...
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products tha...Ex. When picking (Scan out Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has to be LIVE) - Add a dashboard for visual view of KPI's and results The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored. Knowledge needed. - Excel Formula Mastery - Pivots Tables -...
I'm seeking a detailed market research report on the baby milk formula industry in India. The report should cover: - Market size and growth trends nationwide - An in-depth analysis of the competitive landscape including market share - An overview on consumer preferences and purchasing behavior The main objective of this market research is to assess the competitive landscape of the baby milk formula industry in India, enabling me to make informed business decisions. A nationwide, Pan-India focus is required. It would greatly benefit from having a candidate with experience in market research, an understanding of the Indian consumer market—especially the baby product segment—and excellent analytical skills.
I have a current report in Excel 365 that I'd like to improve. Key Requirements: - Automate formulas to avoid errors: I need an expert to automate specific formulas in the report, which primarily involve Sum, Average, and Count functions. - Complete totals by searching information in the other existing sheets: For this, the formulas should pull information from Sheet 1, Sheet 2, and Sheet 3 to ensure the accuracy and completeness of the totals. Ideal Candidate: - Experience in Excel 365, particularly in automating formulas and cross-referencing data from multiple sheets. - Attention to detail and the ability to ensure the accuracy of the final report. This project is ideal for someone who is skilled in Excel and has experience in managing complex data sets within the software...
I'm in need of an Excel expert who can assist me with a project that involves data analysis, financial calculation, and advanced formula and functions. This project involves working on a single Excel file with the main goal of improving data organization. This requires a hands-on approach, strong problem-solving skills, and a keen eye for detail. Skills/Experience Needed: - Advanced Excel proficiency - Strong background in data analysis and financial modeling - Experience in creating complex formulas and functions - Excellent organizational and problem-solving skills. Your work will be instrumental in streamlining our data handling processes and make them more efficient. Please provide examples of similar projects you've worked on in the past.
Overview: Pilote d’Usine requires a bespoke e-commerce website built preferably using WordPress and WooCommerce. The website should be fully responsive, ensuring optimal functionality on both mobile and desktop browsers. The design and feel should resonate with motorsport themes such as Formula 1, FIA, Karting, and WEC. Key Requirements: 1. Multilingual Support: - Initially, the website must support English and French. - Scalable to accommodate up to 5 languages. 2. Editable Content: - All images and texts should be easily editable by the admin without needing developer intervention. 3. User Account and Eligibility: - Registration page for user account creation and verification based on racing license or credentials. - Verification process for eligibility to...
...& Video Ads *excludes ad cost Testimonial: Following the Pandemic our SEO, Blogs and Website were out of date and no longer ranking in Search. No one could find us! Small Business Marketing Solutions knew exactly how to target the problem. First they did all the keyword research needed to update our blogs and content. SMB also created awesome videos for our marketing and used their special formula to give us maximum visibility with every post. Using a methodical approach and small batch testing they determined which platforms we should target with our marketing spend to find our customers. I highly recommend working with Small Business Marketing Solutions. Nicole know's her stuff and is a master at research to understand all the data. Her work is still paying dividen...
Key Elements: - Measurements 33x81 - The design should be eye-catching and attract attention. -Color scheme: Pink, White, Black “From Struggle to Strength: Conquer Thinning, Alopecia, and Breakage Naturally “ Our products •Stimulates hair follicles for natural growth •Nourishes and strengthen hair from root to tip •Herbal formula promotes thicker, fuller hair •Reduces hair loss and breakage •Restores shine and vitality to dull, damaged hair •Free from harsh chemicals and additives •Suitable for all hair types and textures Follow us on Instagram @Mikellerosecollection Contact us (313)5597139
I am in need of an experienced freelancer who can assist in data analysis and Excel formula troubleshooting. Key Tasks: - Perform qualitative textual analysis on both textual and numeric data - Spot inconsistencies, errors and trends in the data - Troubleshoot any issues with Excel formulas and functions Ideal Skills and Experience: - Proficient in using Excel for data analysis - Exceptional skills in data interpretation and reporting - Strong problem-solving skills, specifically for Excel formulas and functions troubleshooting - Proven expertise in qualitative textual analysis.
I'm in need of an experienced Python developer who can create a backtest for an existing strategy. Key Project Aspects: - Strong proficiency in Python is mandatory. - Familiarity with the following Python libraries: Pandas, NumPy, Matplotlib. - Experience in working with historical stock data. In this project, you will be using the Python programming language to develop a backtest for my trading strategy using historical stock data. The successful implementation of this brief requires a thorough understanding of the aforementioned Python libraries. Ideal Candidate: - The perfect candidate is a Python expert who has substantial hands-on experience with these libraries and backtesting strategies. - Experience with financial data analysis, particularly stock market dat...
I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.
We're looking for someone to help us design new style racing seat for our racing simulator. Unlike traditional racing seat which has a seat back and a seat bottom, we are looking for any creative designed to help us design a formula style racing seat. When designing the seat, we are looking to reduce the size of the packaging, so from manufacturing stand point, the seat needs to be disassembled into smaller pieces. I have attached a few example of similar seats that we're currently looking for. As for the framing, we can use either square, round tube, metal plate, and aluminum extrusion bars.
I need a detailed Microsoft Excel spreadsheet that tracks expenses related to Hurricane Ian and deducts them from my current house appraisal. Key aspects of the project: - **Expense Tracking**: The spreadsheet should offer a detailed list of expenses. These should be categorized (e.g. repairs, replacements, labor). - **Formula Integration**: It should also include formulas that automatically calculate the sum of these expenses. Ideal Candidate: - Proficient in Microsoft Excel - Experience creating detailed expense tracking sheets - Familiarity with property appraisal processes and calculations Please submit examples of similar spreadsheets you've created in the past.
...conditions. In this case, the cells should be highlighted based on containing certain text. Skills and experience required: - Proficiency in Microsoft Excel is essential. - Familiarity with conditional formatting in Excel to highlight cells. - Experience working with text-based data in Excel. - Attention to detail to ensure the correct text is highlighted. I need a quick or instant way either with a formula or conditional formatting to find where each of the values in this column are located in the bordered areas, and then highlight those specific cells. Basically I am going to a website, downloading a long list of parts with individual numbers and then need to be able to quickly search all of those numbers in my excel spreadsheet all at once and highlight those cells instead o...
I'm seeking a skilled freelancer to integrate BUY SELL buttons on my AmiBroker charts, allowing these buttons to execute orders through Finvasia, Flattrade, Angel, and Alice Blue Brokers using the respective API key. Key Requirements: - Implementation of BUY SELL Buttons: The primary task is to incorporate BUY and SELL buttons on the AmiBroker charts. - API Integration: Your role will be to link these buttons to the respective brokers' APIs. - Broker Support: The system should support order execution on Finvasia, Flattrade, Angel, and Alice Blue. Additional Considerations: - Portfolio Management: The system might involve managing multiple portfolios across these brokers. - Real-time Updates: If possible, the system should provide real-time updates on order status...
I'm in need of an expert Amibroker AFL developer to create an automated trading system based on a Bollinger Band breakout strategy. This system incorporates a couple of candlestick patterns and an ATR based stop-loss and take-profit. Key Requirements: - The system is to be coded solely using Amibroker AFL - The strategy will be applied to both Stocks and Futures - The breakout timeframe is mainly for intraday but can be extended to swing too. Skills and Experience: - Proficiency in Amibroker AFL is an absolute must - Solid understanding of Bollinger Bands, ATR, and candlestick patterns - Experience in creating automated trading systems is highly preferred - Prior experience with Stocks and Futures trading is an added advantage. This project is time-sensitive, ...
I'm looking for a software that can be designed within Excel to track daily sales and present a detailed profit calculation per liter of petrol. Key Features: - Dail...detailed profit calculation per liter of petrol. Key Features: - Daily Sales Tracking: The software should enable manual entry of daily sales figures for accuracy. - Profit Calculation: The software should generate a detailed report on profit per liter of petrol sold. - Remining fuel in tank also show - calculate auto profit in the tank Ideal Skills: - Proficiency with Excel including advanced formula writing, data organization, and report generation. - Understanding of petrol pump operations and metrics. Note: While the project is to be developed in Excel, suggestions for potential future software integrati...
I'm looking to engage with a skillful Excel whiz who excels (pun intended) in a variety of Excel formulas. In particular, I need someone who has proficiency in: - Average and standard deviation for each part - Average and standard deviation parts total by invoice - Average and standard deviation trip charge - Average and standard deviation Material markup % - Average and standard deviation Hours - Average and standard deviation Installation labor - Average and standard deviation Non-installation expenses - Average and standard deviation Other fees - Average and standard deviation Freight
I'm looking for a skilled video editor to transform my less than 2 minute Formula 1 footage into a fast-paced exciting and engaging Snapchat video that includes energetic transitions, music overlay, and special effects. Key Requirements: - Expertise in video editing, particularly in a thrill cars fast-paced style. - Previous experience in editing Formula 1, race track style sports or action-related content is a plus. - Proficiency in adding music overlays and special effects to enhance the viewing experience. The final video needs to capture the essence of a Formula 1 experience - the speed, thrill, and excitement, while maintaining an engaging narrative flow. A keen eye for detail and ability to synchronize energetic transitions with the music and special effe...
I want a formula in column D of the attached spreadsheet to convert the date in column C to DD/MM/YYY
I'm looking for a Google Sheets expert who can create formulas, automate data calculations, and provide data analysis and reporting. The successful freelancer will need to automate data input from a website or database. Ideal Skills & Experience: - Proven expertise in Google Sheets, particularly in formula creation and automation. - Experience in data analysis and reporting. - Demonstrated ability to automate data input from websites or databases. - Strong communication skills and ability to provide detailed project proposals.
I am in need of an Amibroker AFL code for halftrend, specifically designed to function in two timeframes - 5 minutes and 1 hour. This AFL doesn't require an array of features - all I need is the basic functionality that aligns with the performance of the halftrend in Tradingview. What I require: - Suitable skills in Amibroker AFL coding and understanding of trading systems - Ability to align halftrend commodity trends with Tradingview performance - Timely delivery and willingness for revisions if necessary If you have a solid understanding of system trading and experience in AFL, your expertise would be highly beneficial for this project.
...monthly rental fee for equipment. The JavaScript function you develop should be able to replace the existing Excel macro that uses Goalseek. - Data Handling: The function should be designed to receive input data manually from the user. This means that the function should be able to take in data directly from the user, process it, and return the calculated rental fee. - Complexity: The current formula used in the Excel macro for calculating the rental fee is moderately complex. It involves elements such as interest rates and amortizations. The JavaScript function you create should be able to handle these complexities and produce accurate results. Ideal Skills: - Proficient in JavaScript and algorithmic problem-solving. - Experience with Excel macros and Goalseek is a plus. - St...
I need a proficient Excel specialist to provide immediate support with data analysis, automation, and formula creation. Your expertise is essential in transforming a specific data format from '111111111111' to '' in Excel. I just need for someone to show me how to do it so I can replace it in my Excel database
Hiiiiiiiii again!!!!! following the Supply and Demand indicator, comes Backtest Strategy project for you
I'm looking for an experienced Excel expert to assist with my data analysis and formula creation tasks. - Data Analysis: I need you to help me with both statistical and financial analysis. It's essential that you are comfortable and proficient with these kinds of data analysis within Excel. - Formula Creation: You'll also be responsible for creating various formulas, particularly related to budgeting and financial forecasting. Experience in working with such data to build accurate and efficient formulas is a must. I'm looking for someone who can quickly understand the data, provide insightful analysis, and create the necessary formulas for financial tasks.
I'm looking for a graphic designer to create a trendy and eye-catching design for my t-shirt, focusing on the latest trends in car sports. The design should incorporate elements of Formula 1 racing, soccer, cricket and sports cars in a way that is stylish and appealing. Key Requirements: - Proficiency in graphic design, particularly for apparel - Understanding of the latest trends in car,sports - Ability to creatively incorporate Formula 1 racing, soccer,cricket and sports cars into a cohesive and attractive t-shirt design It's important that the design is not only visually appealing but also resonates with fans of car sports, as well as those who appreciate the latest trends in sports. Experience in designing for apparel, particularly t-shirts, will be highly val...
I need a developer who can create a bridge between the Kotak REST API and Amibroker. The primary goal is to enable order placement within Amibroker directly via the Kotak API. (automatic orders according to afl Buy/Sell signals) Key Requirements: - Utilize the REST API - Integrate order placement functionality. - Support for both Market and Stop-loss orders in NSE Index Options. - Ensure seamless operation. The ideal candidate should have: - Proven experience with financial APIs and trading platforms. - Knowledge of both the Kotak API and Amibroker. - Excellent understanding of different order types, especially Market and Stop-loss orders. - A strong track record of delivering reliable, secure, and high-performance software solutions.
We need 48 picture cards. The card game involves building stories with children during therapeutic sessions. A child chooses a card from each theme and tells a story with these cards. For example the hero is a b...wicked witch Find a treasure Free a princess Heal the sick king Catching a fiery horse “Emotion” Cards (emoticon) Sad Fear Anger Unfair Worried Disgust Joy Love “The unexpected friend” cards Knight Fairy The mysterious child The good genius The good magician The golden unicorn Princess The good witch “Power” Cards A precious stone The magic potion The magic wand The flaming sword The magic formula The magic mirror The golden key The Cape “Adventure Location” cards A castle A planet An enchanted forest A cavern A ship The...
Seagull EA is a fully automated Forex trading system. We have 3rd party verified live track record from 2020. As well as the Tickdata backtest from 2006 shows solid result. Please see the screenshots attached. We are looking for a Business Development Manager to assist with lead generation and sales strategy development for Seagull EA. We charge monthly subscription fees to the clients. 50-70% monthly commissions should be paid to the Business Development Manager after each product is sold. The commission is valid as long as the clients are using our product.
...Format" from a third party form) 1st Extension (To be Activated & Input using script as per logic) 2nd Extension (To be Activated & Input using script as per logic) 3rd Extension (To be Activated & Input using script as per logic)w Priority (fixed data coming from a third party form) Status (pending/completed) Assigned to (fixed names coming from a third party form) RATING (auto calculated using a formula) The Due Date and extension columns are in text format ("DD-MM-YYYY"). Script Functionality: The script runs daily to check each task's status and due date, comparing it with the current date. It sends data to specific webhooks if the task meets certain conditions: If "Due Date" is on or before the current date and the Status is "...
Update the changes to calculator form according to new prototype with updated formula
Looking for an experienced web developer who can take my Google Sheets table / Excel spreadsheet with the custom formula and turn it into an engaging, dynamically updatable and nicely styled website which I can embed into multiple sections of my WordPress site. Skills and Experience: - Proficient use of WordPress - Extensive experience with website development and design - Sound knowledge of Google sheets and its functionalities - The developer should be able to make the sheet customizable and allow for data updating. Please include your experience relevant to the job as part of your application. Don't worry about showcasing your past work or drafting a detailed project proposal - your background in web development and WordPress is what's most important to me. Not...
I'm in need of a proficient Excel and Word expert who can assist me with various tasks. Unfortunately, I did not specify the exact tasks nor provide a deadline for this project. However, I'm excited to review your proposal and discuss your experience in more de...discuss your experience in more detail. Please include your past work in Excel and Word with your proposal. This could be anything from template creation to complex data analysis and automation. The more detail you can provide about your past work, the better. In terms of my needs, I'll be looking for a flexible freelancer who can help out with a range of tasks. Experience in data analysis, formula creation, and automation in Excel would be particularly desirable, as would proficiency in creating and form...
...Excel for further analysis. Graphs Per Department: - **Data Points:** The graphs should focus on data from Sales, Expenses, Profit, and Number of Employees, using a rolling average approach for accuracy. - **Rolling Average Calculation:** The rolling average for the graphs should be calculated based on Manual Entered Data, per department. Additional Requirement: - **Formula Calculations:** The website should also support formula calculations for further analysis as requested by the admin. Ideal Candidate Profile: - Proficient in web development with experience in creating data-driven websites. - Familiar with graph creation and data visualization tools. - Good understanding of user access management and data exporting. - Able to implement rolling average calculations ...
I'm having a significant issue with my Google Sheet that needs sorting quickly. The main issue I'm dealing with is a formula error - when I try to make a hyperlink auto-populate after inputting a specific exercise, it just isn't working, which is causing a lot of frustration. Key Requirements: - Understands Google Sheets - Skilled in fixing formula errors - Fast turnaround time Ideal Skills and Experience: - Strong expertise in Google Sheets and formulas - Proven troubleshooting evaluation - Ability to deliver ASAP.
I am looking for someone who can help me correct some formulas and formatting errors in my Excel spreadsheet. - The spreadsheet contains Sum and Count formulas that need to be fixed. - There are also formatting errors that need to be addressed. Ideal skills: - Proficiency in Excel - Experience with formula correction - Attention to detail for formatting errors.
I am currently experiencing some issues with a Google Sheets array formula that is pulling the wrong data from columns G, H, I, and J. I need a skilled and experienced freelancer who is adept at Google Sheets formula manipulation to help me rectify this. Here is what needs to be done: - Identify why the formula is pulling incorrect data and address the issue. - Correct the array formula such that it accurately matches and places data from the correct columns. Deep understanding of array formulas and error troubleshooting in Google Sheets is a prerequisite for this project. An ability to work quickly and accurately is also key.
As an organization focused on understanding our customers better, we are in need of an Excel tool that is designed to handle customer data. Specific functions needed are: - Advanced calculation and formula functionality. You should be adept in creating and troubleshooting complex Excel formulas. - Data Visualization: Ideally, you should be skilled in creating efficient and easily interpretable Bar Graphs. This is how we'd prefer our data to be visualized. Key skills and experience: - High-level proficiency in Excel - Demonstration of designing efficient data visualizations in Excel - Ability to work with customer data effectively. A comprehensive understanding of Excel, including experience with customer data analysis, will position the chosen freelancer for success in this...
We offer an exciting 50/50 monthly revenue partnership that allows you to refer clients to our payment processing account specialists. Our unique approach involves providing your clients with a comparison formula that highlights any overbilling in their current processing statements. By setting competitive rates, we help merchants save substantial processing fees. Additionally, most merchants who opt for the new surcharge program in the USA (and recently in Canada) receive state-of-the-art equipment replacement for free. The successful referral will be a client who signs up for a POS system and payment processing services. Please provide a quote for setting up this system and indicate your experience with similar projects.
...of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a CS...
...of how the process works, from the reporting of a crime, to the eventual match/no match on the DNA database. b. Identify any conditional aspects of the process, for example if there are any stages of the process where resources only become available once the previous sample has been processed. c. Second, write out the relevant equations associated with each step of the process, and construct a formula for the overall time in system. d. Use relevant notation and write out equations using Equation Editor in Word. e. Note – the rule of thumb is that any reader can pick up your report and replicate your results by following the methods. 2. Use mean values of each parameter to construct an “average” solution. a. Unit of interest – a DNA sample collected by a C...
