Metastock formula loopingcông việc
Xây dựng một plugin và component cho user chấm rating cho bài viết dựa trên nền Strap...người chấm 4 sao e là số người chấm 5 sao Build a plugin and component for User take rating of articles based on Strapi and Nexjs front-end. The rating element must show how many people put 4 stars or 5 stars or so on... Show Average Point Rating. Each user and each IP address is only taken the rating one time. A front-end demo contains 1 post and rating component based on NEXTJS TYPEScript. The formula for Average Point Rating: (1 * A + 2 * B + 3 * C + 4 * D + 5 * E) / 5 In which : A is the total of people who take 1-star B is the total of people who take 2-star C is the total of people who take 3-star D is the total of people who take 4-star E is the to...
1 / auto scan amazon price, other sites (wallmart, homdeport ..) have changed and if you change, go to ebay and reprice with new price of amazon or other site (wallmart, homdepot ..) according to the formula prefilled. (ex: ebay price = amazon price * ) 2 / Get the new order output file 3 / Automatically increase the quality of the product after an order 4 / automatically evaluate feed back for customers 5 / Automatically send offers to customers who have watched the product (watching) 6 / Track if the product is about to expire (3 days left), it will scan to see if it is eligible or not, if not enough then end it (condition is sold within 27 days)
I'm looking for a talented freelancer to build a custom table that can accurately determine partners' collection and payout within our dental practice. This table should be flexible enough to allow for the substitution of various numbers, which i...percentage ownership for each partner in the practice. This percentage ownership will be calculated based on the individual collections and the percent ownership. Ideal skills for this project include: - Proficiency in Numbers or relevant software to create the table. We use Apple devices. - Understanding of dental practice finances and revenue calculations - Ability to create a flexible, formula-based table that can easily reconfigure numbers - Strong communication skills to ensure the table meets the needs and requireme...
As the project owner, I am looking for a talented individual who can handle two crucial tasks in Excel: 1. Adding advanced functionality with IF, VLOOKUP, and INDEX MATCH formulas. 2. Implementing conditional formatting. To be successful in this project, you should have: • Proficiency in Excel's advanced functions and calculations • Experience with customizing Excel using conditional formatting • Attention to detail and the ability to execute tasks accurately. Your primary task will be to help me improve Excel's current functionality by implementing the advanced functions mentioned and customizing my Excel using conditional formatting. Your deep understanding of Excel will be crucial to successfully carrying out these tasks.
...function that returns the range based volatility estimate proposed by Rogers and Satchell. See e.g., Rogers, L. C., Satchell, S. E., & Yoon, Y. (1994). Estimating the volatility of stock prices: a comparison of methods that use high and low prices. Applied Financial Economics, 4(3), 241 247, if you wish to learn about the formula’s motivation. The Rogers-Satchell range based volatility formula is given by � �??(?)=(1 ?) 1 2(∑{ln(?? ?? )ln(?? ?? )−ln(?? ?? )ln(?? ?? )} ? ?=1 ) 1 2 2. (30 marks) The p-th percentile of a set of n observations of a given variable is defined as the observation located in the p(n+1)/100-th ordered position (e.g. the 10th percentile of a variable for which we have 50 observation...
I require a coder proficient in Ctrader Indicator development to execute my vision. I need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the size of a b...need an indicator that identifies trend reversals, highlights overbought and oversold conditions and generates buy and sell signals. Specific calculations must include: I would like an indicator for Ctrader which calculates and displays the size of a body and total size of the CURRENT candle in the current time frame. It should also display the following on a new line according to this Excel formula: =IF(BODY<=(CANDLE/2);"LLX";"...
I'm seeking a Google Sheets expert to assist me with creating a dynamic client database with a functional search button and also save and modify button . Key tasks will include data analysis, spreadsheet automation, and formula creation. The database needs to store specific information like client name, accountant name, bank names, and sort, amongst others. Ideal freelancers should have extensive experience in Google Sheets with a knack for complex formula creation and automation. Strong data analysis skills will also be useful for this project. Familiarity with creating searchable databases is highly desired.
...available with certain quantities all the time. Requirements: **Data Synchronization**: The connecting should sync data between Excel and WhatsApp in background. - **Automated Messaging**: The Updated data values needed to send automated messages to one contact. These messages will be alerts, and The content of these messages will be generated by data within the Excel sheet. Very Important: Excel Formula/Script/Code/Macro/VBA Function or whatever you can call which is embedded in and compatible with excel. (You have to open the attachment to run a script on it). When the available quantity of a spare part reaches a certain value ( Minimum Stock Value or Less ), An automatic Notification Message including the data of I.N , S.P.D , and A.Q, Will be instantly sent into my what&...
I'm looking for an Excel expert to automate various tasks relating to our tracking system and create an intuitive dashboard. The tasks will involve automation of formula calculations and report generation, to streamline our data processing workflow, and reduce human error. Key tasks include: - Automate formula calculations: Efficiently automate intricate excel formula calculations. - Automatic report generation: Create a mechanism for generating immediate, error-free reports that highlight key aspects. - Dashboard creation: Design a user-friendly dashboard displaying information based on Automatic report Generation. The ideal freelancer for this job should have: - A deep understanding of Excel's advanced features; - Previous experience with automatio...
Professional design and graphics for a landing page. Must be done with Figma for an easy transition to WordPress. Must be responsive for mobile. Landing page details: 1- Title: Watch Formula 1 Live With TheHatVPN. 2- Target audience: Users that want to watch Formula 1 races online. 3- Inspiration from competitor: This landing page will be posted on , please use the color scheme of the site in your design.
I'm in need of someone who can assist me in developing Excel formulas for financial equations, focusing specifically on profit and loss analysis. - You should be an expert in using Excel for financial analysis. - You will need to create tailored formulas to handle profit and loss calculations effectively. - Experience in business finance, particularly in profit and loss statement analysis, is greatly preferred.
here is the specification Invite the bot with the following required permissions: admin XP calculation formula: 1 character = 1 xp (bot needs to read each message) Bot stores member data of group: ID, XP Accessible on /leaderboard/[groupID] Commands: /mylevel /levelof [@username - find by ID] Response: "@username Level: level Rank: rank current XP/required XP for next level, bar [███████---] (for each 10% completed) Sent with love by LevelBotTg" /ranking "send a link to chat: [groupID] Sent with love by LevelBotTg" admin commands: /clear - all xp reset to 0
I'm seeking a highly skilled Excel expert to develop a versatile, either fully or semi automatic, Excel formula or action algorithm that can handle specific data manipulation tasks. This Excel tool must be able to automatically select data from a certain type of table. Hence flexibility is essential. Likewise, it should be able to arrange this selected data against particular types of rows. The formula should be customizable to adapt to various row types. The main aim is to create a solution which allows for selection and rearrangement of data based on multiple potential criteria, whether by column header, row label, or specific values even though I have not specified them at this point. Therefore, excellent comprehension of Excel data manipulation, versatility, ...
Seeking an adept freelance developer to help me incorporate a continuously looping MP4 video into a 7'' Raspberry Pi LCD screen. Key requirements: * Proficiency in handling Raspberry Pi projects, especially involving LCD screens. * Good working knowledge of video formats (Specifically MP4) in Raspberry Pi environments. * Ability to include audio output through headphones. * No additional control features are required for this task. Please note, that the goal is a smooth, continuous video loop with seamless transitions. Relevant experience with similar projects would be highly appreciated.
hi evryone simple project is needed in Excel i have date which is connected to server to import data so i need to update the Date by click at the icon "Update:" [ the icon connected to hyperlink for example] please see the attachment, and after the implement needed is will take the Cell: Date + "00:01" and return it back and it will automatically update> if is it possible by usuing formula in excel or use some VBA code
I'm in need of an expert who can adeptly identify and fix formula errors in my spreadsheet. Currently, the main issue isn't reflecting a 10% commission in specific cells. My spreadsheet just doesn't show the correct result, which has become challenging for me. To really nail this task, you should have: - Proficient Excel skills - A strong understanding of spreadsheet formulas - Detail-oriented data management skills - Excellent problem-solving abilities Please approach this project with meticulous diligence and an eye for detail. By doing so, we can finally address the incorrect calculations of the commission in the workbook.
I'm currently working with two Excel sheets for inventory data. I need help with applying VLOOKUP functions to these sheets. I need the correct formula to lookup the Sheet 1 Column A data, in Sheet 2 Column B, and apply Sheet 2 Column B data in Sheet 1 Column B - please see attached. Key Requirements: - Understand and implement VLOOKUP formula to connect data between the two sheets. - Ensure the VLOOKUP function is working correctly and efficiently. Ideal Skills and Experience: - Proficiency in Excel functions, particularly VLOOKUP. - Prior experience working with Inventory data is a plus. - Attention to detail and accuracy in data manipulation. Please reach out if you're confident in your Excel skills and can assist with this project.
I'm currently in need of an expert in Google Sheets proficient in utilizing the Vlookup formula to match and compare data between two columns in a simple table with rows and columns. Key Tasks: • Apply Vlookup to compare and match data • Simplify and present result in an understandable format • Assure accuracy of matched results Ideal skills and experience: • Proven experience with Google Sheets • Strong understanding of the Vlookup formula • Exceptional attention to detail • Ability to deliver accurate results promptly. Please present examples of similar work in Google Sheets applying the Vlookup formula.
** MUST CREATE A RECREATION OF THE PHOTO ATTACHED ** As an illustrator, I need to create a looping, rendered illustration of the 5 villas from from the photo attached. The scene should capture the main features of the villas. The villas rendering angle should be at villa height ( sample attached ): The illustration will be used to better highlight the 5 villa locations on Orchid Bay beach that you see in the photo and some of the activities available around the villas and beach. The photo sample has been altered to leave out one villa that does not participate in the FDC rental group( This is why you will see a flaw in the center of the photo) please blend to fix and alter the angle to more of a villa level view. Liberty can be taken to better highlight the activities An attachm...
...values for terms in a document. Use the TF*IDF formula with term frequency, document frequency, and total number of documents. Task 2.3: Implement a TF*IDF based IR model Create a main function to call my_tfidf() for each document and print the top 20 terms with TF*IDF weights. Use original queries as titles to calculate ranking scores using TF*IDF. Task 3.1: Calculate average document length Implement a function avg_length(coll) to calculate the average document length in a collection. Modify code to store and calculate document lengths in Rcv1Doc objects. Task 3.2: Calculate BM25 scores Define a function my_bm25(coll, q, df) to calculate BM25 scores for documents given a query. Parse the query using parse_query() and apply the BM25 formula to calculate scores. Tas...
I'm in search of an Excel expert who can create a specific quotation formula for my window and door shop. The formula should: - Calculate per square meter cost - Incorporate various variables, including item price, quantity, discounts, profile price, glass price, mosquito net price, Extras, and installation - Categorize 'Extras' to include delivery and customization fees Ideal professionals for this project would have significant Excel experience, particularly with complex formula creation. Knowledge of cost calculation and financial modeling would be beneficial. Efficiency and attention to detail are key in this project.
...constructing a precise, data-driven model specific to marketing data, as well as supply and demand. Key functionalities are to include: - Data Visualization: Proficiency in translating raw data into visual charts and graphs. Your work should result in a model that effectively communicates complex data in an easily digestible format for decision-making purposes. - Formula Calculations: You must be familiar with advanced Excel formula calculations to manipulate and compute data in ways that align with our specific market information. - Scenario Analysis: High proficiency in scenario analysis is key. Able to put together various ‘what-if’ scenarios in the Excel market model, taking into account different variables that may impact the business. Our project req...
For my project, I'm seeking an expert in creating statistical formulas that would convert compiled raw data into a clean, streamlined dashboard. This formula should be able to handle the following: - Data Type: Call volume averages from the past week. - Statistical Concept: The formula should be able to perform a comprehensive regression analysis and probability calculation from the raw data. Ideal candidates should have a solid background in statistics, proficiency in data visualization and analysis, and significant experience with dashboard creation. Knowledge of how these concepts apply to call center data would be a definite plus. Effortless transformation of data into easily digestible information is the key objective here.
I am seeking a skilled graphic designer to create a logo for my content agency, Ultimate Content Formula. Logo Requirements: - Combination of text and icon - Conveys a theme of creativity and innovation - Utilizes an Orange, Blue, White, and Black color palette Ideal freelancers should be proficient in logo design, with experience in choosing the right visual elements to communicate brand identity and values. Experience in professional content and/or creative industries will be highly valued. Creativity and an innovative aesthetic sense are a must. Ability to communicate efficiently and appreciate client's vision is highly desirable.
I'm looking for an expert in Excel to develop a formula capable of performing a combination of basic arithmetic operations (addition, subtraction, multiplication, division), statistical analysis (sum, average, median), and logical operations (IF statements, conditional formatting) on a large dataset containing more than 1000 cells. The entire work will only involve a single worksheet. Skills and Experience: - In-depth knowledge of Excel - Proficiency in Excel functions and formulas - Experience handling large datasets - Understanding of statistical analysis Your task will involve: - Creating a user-friendly, efficient formula - Testing the formula rigorously on provided data - Ensuring accuracy and prompt delivery Please only apply if you are highly skilled i...
...seeking a professional who can convert multiple Metastock formulas into Tradingview. Key Responsibilities: - Successfully translate more than five Metastock formulas into the Tradingview platform. - Fully capture the calculation method using the Metastock formula. - Ensure all plots are accurate to the Metastock formula. - Customize alerts as per the Metastock indicator. Ideal Candidate: - A profound understanding of Metastock formulas and indicators. - Solid experience with Tradingview. - Demonstrated skills in calculation, plotting, and alert customization. - Ability to finish the project in a timely manner, without compromising accuracy. Your success in this role would be measured on the accurate translation and functionali...
I am on the hunt for someone highly skilled using excel. The selected freelancer will process data from a CSV file, apply exact match criter...entries from the CSV files are kept intact - they must not be removed or merged. Prior experience in data matching and a strong understanding of CSV files is highly desirable. Please ensure you can: - Handle large CSV files - Apply exact match criteria - Combine values of a column to replicate a formula - 16 columns of data combining to output a pre determined formula - match the formula across entries on another spreadsheet - 800 rows Let's maximize data accuracy and efficiency together. output formula should be as so - a:[‘number of options’]:{option values separated by ‘;’ } then inpu...
...social media icon, similar to the like button on Instagram. it should be a looping animation where the button comes to life a bit with color and movement, similar to the YouTube like button animation. If you are interested, please reply and confirm what you will plan to do to complete this task. You can find the icon to be animated attached; we will explain the animation we want once details are confirmed. DEADLINE: Our deadlines are rolling in so we need the animation by the end of the week. We will expect you to stop working every 3 hours and check in to see progress. Maximum time taken for this simple animation should be 10 hours. Key Requirements: - Proficient in 2D animation - Experienced in creating looping animations - Understanding of social media profile requi...
Calculate the total cost for each client using a fix rate and a waterfall method, from a large data set of clients. Explain each step of the process (the applicability of each formula) so anyone can replicate the calculations. All the detailed requirements are provided in the first tab. More details: What are the specific data points for each client that need to be considered in the calculation? Revenue What format is the client data currently in? Excel spreadsheet Do you require a step-by-step guide included within the same Excel file, or should it be provided in a separate document? Within the same Excel file
I need someone to help write up a script that allows users to do some calculation on a web page. The idea is that when you have a mathematic formula, you plug in data and then perform the calculation. It is very tedious and inconvenient. It would be nice that the users do not have to see or touch the formulas, they simply input the numerical data and then click calculate button, the result pops up immediately. The formulas A/L - B/W = F and B=1-A (1+F*W)^A multiplied by (1-F*L)^B and the product is designated as R or something like this. There will be some fields for users to fill out including A, L and W (B can be calcuated when A is known, or users can define B as well), and then they are instructed to click on the calculate button to get F and R. So basically, users de...
I'm seeking a skilled developer to create a desktop application that draws stoc...Must be able to calculate oscilators and show on screen such as MACD, Traci and volume chart Ideal candidates should have a solid background in financial software development, particularly in handling historical stock market data and developing Windows desktop applications. Proficiency in creating candlestick, line, and bar charts is highly preferable. Creating and charting oscillators from formula such as MACD and TRACI necessary. Understanding of stock market and folder selections like NYSE, Nasdaq, etc., will aid the ease of this project. Create signals when conditions met. Scan data base of chosen folder/s for signal and show list. Must be able to select from list and view chart and keep li...
I need a new Instagram ad promoting my CrystalVision Dive Mask Anti-Fog Kit. I need a square image (1080 x 1080 px) that showcases the product and really pops on the feed. My brand...Kit keeps your mask crystal clear for a fog-free dive." -"Be dive-ready anytime, anywhere. The CrystalVision Dive Mask Anti-Fog Kit is compact and easy to use, so you can defog your mask quickly and effectively." -"Don't forget your essentials! The CrystalVision Dive Mask Anti-Fog Kit is a must-have for any scuba diver." Highlight the benefits (optional) : "Alcohol-free, marine-life friendly formula" Feel free to use your own creative wording as well, or placeholder text(lorem ipsum) if that works better for the design process. I can't wait to see what y...
I am in need of a mid-level freelancer - people manager to assist in the recruitment and onboarding of new team members, as well as the monitoring of overall team performance and productivity, leading to a clear view of all tasks in total and individually. We are building a Formula 1 team of media professionals that are fast, allways learning, wanti g to make a lot of cash and win at our game. Key Responsibilities: - Recruiting and onboarding new team members: You will be responsible for sourcing, screening, and onboarding new hires to the team. - Monitoring team performance and productivity: You will need to keep track of individual and overall team progress, and provide regular updates and clear visibility for me. I am looking for a mid-level professional with experience in pe...
...in Google Spreadsheets. Though I have a sound understanding of Google Apps Scripting, I find myself needing professional assistance with: - Data Entry & Organization: My project involves significant amounts of event data that require precise and systematic entry and organization. - Formula Creation: An adeptness at formula intricacies is a must-have. You should be capable of formulating complex prescriptions to perform specific functions. - Report Generation: Coupled with formula creation, you should be able to synthesize the data into concise and illuminating reports. - Scripts & General Automated Solutions: Lastly, I'm looking for someone who can write scripts and provide automated solutions to enhance overall efficienc...
Explore, Roll out and Implementation :- FMS - Flowchart Management System PMS - Product Management System Query Formula, Filter, Sort, Import range Google sheet Checklist Google Form Form mule Form ranger, Delegation Sheet
I need a formula to sum all products I sell by months
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
...well-versed in calculator creation, who can transform my vision of a conveyancing quote calculator into a digital reality. Feature Requirement: • The core purpose of the project is to develop a Legal Fee Calculator, that is, a digital tool that computes legal fees in real-time. Key Factors: • Essentially, the calculator must take the purchase price into account while making calculations. Formula for Calculation: • The unique selling point of the calculator will be its ability to compute the legal fees on a sliding scale based on the purchase price. Desired Skills and Experience: • A strong background in financial computing or relevant experience in calculator building. • Proven ability to deliver complex digital tools in a user-friendly, accessible...
Hi everyone, I'm looking for experts in gravity form. Really good and precise. I have a problem with a number field, where I apply a rather complex mathematical formula. I try to do it with the "advanced calculation" plugin from gravity pearks, but it gives me a critical error due to exponentiation. The forum used is this: (141*(({CREATININA (mg/dl):38}/{KAPPA:124})^{ALFA:123})*(({CREATININA (mg/dl):38}/{KAPPA:124})^ -1.209)*(0.993^{ETÀ:7})*{SESSO VALUE:122}*{RAZZA VALUE:121}) I tried the same thing with javascript, but it doesn't work: <script> jQuery(document).ready(function($) { function calculateGFR() { var creatinina = parseFloat($('#input_38').val()); var kappa = parseFloat($('#input_124').val()); ...
I am in need of an Excel expert who can create a formula that will allow for real-time updating across multiple sheets. This formula should automatically transfer all inputs from sheet one to both sheet 2 and sheet 3. Key requirements: - Expertise in Excel and formula creation - Experience with real-time data updating in Excel - Ability to automate data transfer across multiple sheets The assignments from sheet 1 should appear as the words written and not "assignment" in the weekly and monthly calendars.
I'm looking for an Excel expert who can modify the pricing formula and user interface of my existing price calculator. It is a very basic lookup, with quite rudimentary discounts that need to be applied, and we have a working example to share which you can backsolve how to build/update as needed. Here are the specifics: 1. Update the lookup to a new pricebook tab (Both current, working example, and new example with the new price book will be shared) 2. Introduce new add-ons tick list on the calculator (basic calculations (percentage of total, and fixed price) 3. Build out a visual display of a basic discount matrix (10%, 20% etc - this will be supplied) $. User Interface Improvement: - The updated calculator should still be user-friendly and intuitive. - Experience ...
Ca cineva care apreciază profesionalismul și fluiditatea muncii mele, am nevoie de un specialist bine versat în Foi de calcul Google. Sarcinile tale principale vor fi modificarea unui sheet deja functional, crearea de formule de înaltă funcționare și îmbunătățirea designului, respectând în același timp o estetică profesională și corporativă. Este imperios necesar ca datele sa fie protejate, se folosesc celule needitabile, se preiau date din sheet-uri diferite, se actualizeaza formule pe masura ce se introduc date Proiectul constă modificarea unui google sheet cu 4-5 sheet-uri dependente, astfel incat sa fie pregatit pentru un utilizator fara experienta in Google sheet. Responsabilitati cheie: - Reproiectarea foilor care reflectă un aspect profesional și corp...
As part of my project, I'm dealing with a large set of data (more ...project, I'm dealing with a large set of data (more than 10,000 rows) in Excel, for which I require professional assistance. Key Tasks: - Apply specific Excel formulas to perform financial calculations, including NPV, IRR, and ROI. - Utilize logical and text functions such as IF, CONCATENATE, and VLOOKUP for data management and analysis. Ideal Candidate: - Proficient in Excel functions and formula calculations - Experienced in handling large datasets - Strong financial analysis background The right freelancer will help me analyze this data successfully and draw meaningful conclusions. This project requires detailed and careful work due to the extensive dataset. I appreciate your time and considerat...
Hello, In formula mode, Excel only shows reference to cells and not the actual number. I need an excel function that will convert formulas (Cell B4) to actual numbers (Cell C4). The attached image will explain what is needed.
I'm seeking 2 new logos to revamp my speedway website's two logos. Here's what I'm aiming for: - A top logo, which is displayed as 200 x 100 on the site - A bottom logo, which is displayed as 200 x 200 on the site High-res versions of the logos must also be avail...palette (navy blue, light blue and white, see attached logos). - The word '' must be incorporated into each logo; I specifically want the "h" in lowercase and maybe a different colour for a unique touch. - For the bottom logo, include a background element that is a silhouette of a speedway car, adding a level of sophistication. The speedway car is important, and it should not be a Formula 1 car, a Tesla but a Late Model Speedway car. Attached are the current logos, and would l...
Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.
I'm searching for an EES (Engineering Equation Solver) expert tasked with modeling and simulation of a furnace for heating purposes. As this project dives into thermal systems, relevant experience in this field is invaluable. Report with calculation formula, step by step. EES calculation file, result data in the table You can do it in Python This project is only report writing and all the codes and implementation, we can find on google or ChatGPT I want plaig and Ai free work as I’ve to submit it Project specifics will include: - Detailed thermal system simulation of a furnace - Deliver an accurate and efficient furnace model Ideal candidates will: - Apply profound knowledge of EES - Demonstrate experience with thermal system modeling - Be proficient in furnace desig...
I'm in need of a skilled Google Sheets Developer to assist with primarily formula creation and automation. The tasks will involve: - Crafting and implementing arithmetic and statistical formulas. - Setting up lookup and reference formulas in spreadsheets. - Implementing basic conditional formatting and data validation. While the expected formulae are basic - simple calculations or conditional formatting - accuracy is a primary necessity. Google Sheets experience and precision in formula creation, particularly in arithmetic, statistical and lookup formulas, are key for successful completion of this project. Collaboration and sharing skills would be an added advantage.
