Need formula Jobs
Please write an excel formula, that calculates the German income tax. Please send one formula for each year. I need 2018-2027. Each year is different Formula needs to 100% match the results shown in the German govermental website for this matter: You need to check the "single" lower selection for calculation. I tried the formula, that was posted in here https://www.datev-community.de/t5/Wirtschaftsberatung/Excel-Formel-zur-exakten-Berechnung-der-tariflichen/td-p/133285#_=_ But it is not specific enough, or did not work for me. I assume these links might be helpful, or not. You need to check if the formulas are correct. Maybe even research. https://www.finanz-tools
...have already been created (since February 2017) -400-500 transactions have been generated. Data, or transactions, are entered into the corresponding worksheet according to the appropriate category. The worksheets are all formatted as tables, but have different headers. The columns have different formatting (date, currency, numeric, text) and in a few columns the data (VAT) is calculated with a formula. Why we cannot solve the problem ourselves / challenges: -Tables in worksheets have different headers (should stay that way). -Automation, linking and storage of new worksheets unclear Attached are screenshots and an example of a worksheet with some sample data. If we award you this contract, we will require you to sign a Non Disclosure Agreement because it is confidential infor...
I need someone who can give me a formula that recognizes a duplicate entry in an Excel table. Imagine I already have 30 or 50 entries (names) and now I am entering another name. Now I would like to receive a hint that this name already occurs. It should be marked in color. Ich benötige jemanden, der mir eine Formel gibt, die in einer Exceltabelle einen doppelten Eintrag erkennt. Stell dir vor, ich habe bereits 30 oder 50 Einträge (Namen) und trage nun einen weiteren Namen ein. Jetzt möchte ich einen Hinweis bekommen, dass dieser Name schon vorkommt. Es soll farblich markiert werden.
...time. The best keywords Find hundreds of low-competition keywords that your competitors don't even think about. Simple backlink espionage Use clear factors to identify the very best backlinks of the competition for a better ranking. RankingTracker The ranking tracker currently provides you with your rankings for all relevant keywords - you are always up to date. Profit forecast The winning formula shows you how much you can at least earn with your site in a certain niche. Optimization planner You get a schedule Step-by-step instructions to improve your site. ...
I need a scraper parsing URLs such as and writing the data from result lists into a Google spreadsheet. Input: - Column A in the spreadsheet includes all URLs that need to be scraped. It can be up to 50 URLs - These URLs will be scraped 3 times per day Output: - This data needs to be saved into columns: - Per entry also a datestamp (when was this scraped and added to the list) - No duplicates - The list is sorted by the latest entry coming first - The columns behind the columns with the scraped data can be edited (we will put formula in) Also notice this: - User agent that does the scrape shall look like
- Mick Schumacher Prema Formula 3 (2017) - Jordan 191 (1991) - Benetton 194 (1994) - F2000 (2000)
...nehmen kann diese werden dann in einen Topf gepackt solange bis dieser voll ist nun geht es nach dem Prinzip los wer mehr einzahlt an wert hat eine höhere Chance zu gewinnen. Hier die Beschreibung wie es im Normalfall funktionieren soll For every $0.01 that user deposit in pool we give him one ticket. The tickets are sorted by the deposit order. The winning ticket is found by using the formula floor ((number of tickets - 0.0000000001) * (winning percentage / 100)), where the floor function returns the largest integer less than or equal to a given number. Das Ganze Läuft über Anbindungen von API,s und Javascripten. Jegliche Preise/werte von den Einzelnen Items bekommt man von hier Ich habe mir ein paar Seiten rausgesucht die mir von aufbau und der
I need an Excel expert to help me with my spreadsheet. My spreadsheet has some formula errors that need to be fixed. The spreadsheet is not very complex; it mainly contains simple formulas and calculations. Ideal skills for this job: - Strong understanding of Excel formulas - Experience in fixing formula errors - Attention to detail After the fixes, I plan to use the spreadsheet for daily operations. I need help to fix the column titled "Total Shifts" and the row titled "TOTAL" - Both of these are not calculating the correct numbers when a selection is made from the dropdown lists in the table. I also want a report creating which will tell me how many of each shift type in that week the employee has done i.e if they have done 3 Day...
...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...
I'm looking for an experienced business planner to help create a detailed business strategy for my upcoming baby milk infant formula brand in Saudi Arabia. I'm targeting a wide range of age groups, from newborns to toddlers, including specialty formula. Key Elements: - **Market Analysis**: This should outline the current market situation in Saudi Arabia, including competitors, market size, and trends. - **Financial Projections**: The business plan should include detailed financial projections over the next 3 years. This will be crucial for securing investments and planning our growth. - **Marketing Strategy**: I need a comprehensive marketing plan that will help us effectively reach our target audience in Saudi Arabia. - **Pricing Structure Strategy**: Your ...
I'm currently facing some issues with my Excel tracker. - The tracker contains a VBA macro file which seems to be causing formula errors and formatting issues. I'm unsure of the exact nature of these errors, but it's clear they are impacting the accuracy and usability of the tracker. I need a freelancer who can review and rectify these issues in the tracker. An ideal candidate would have strong experience with VBA and Excel, able to handle complex formulas and troubleshoot formatting problems swiftly. Your goal is to ensure that the tracker is fully functional and error-free. Experience with similar projects will be a plus.
I'm looking for a freelancer to help with a simple Excel data entry task, as well as some basic formula work. I have a spreadsheet that primarily contains numbers. Your role would be to accurately type this data into the sheet, ensuring that every entry is correct and in the right format. This task is meant for particular record-keeping purposes, so precision and attention to detail are crucial. In addition to the data typing, I need some basic Excel formulas applied. Experience with Excel and knowledge of formulas is essential to ensure the data is well-organized and easy to work with. This task is not overly complex but will require someone who is proficient with Excel's formula functions.
I'm looking for a skilled Ninja Trader developer to make adjustments to an existing indicator. The changes required include: - Adjusting the indicator's calculation formula: This involves fine-tuning the parameters and logic of the current formula. - Modifying the visual appearance of the indicator: Changing the color scheme and customizing the font or text size are some of the visual modifications needed. - Adding new features or functionality to the indicator: I'm looking to incorporate additional capabilities to the indicator to enhance its utility. The ideal candidate should have: - Demonstrable experience in Ninja Trader 8 development - A strong understanding of indicator calculation and visual customization - The ability to implement new features effect...
I'm in need of an Excel formula expert to help me with a specific task. I need a formula that will COUNT cells based on the following criteria: - I need to COUNT the number of cells in a range that are greater than -250 - The count should be done for the last 50 cells (ongoing) Your task will be to help me create a formula that dynamically counts the number of cells based on the above criteria. I need this formula to be able to adjust as new values are added to the range. The ideal Freelancer for this project should have: - Extensive experience with Excel functions and formulas - Strong understanding of dynamic range referencing in Excel - Excellent communication skills to explain the logic behind the formula in layman...
I have a calculator form that needs some updates made. It allows the user to input measurements for an industrial hose to find out settings for crimping. Current form is here: Need to add an option for the user to calculate with Hose Wall Thickness OR Hose ID & OD. Here is a prototype showing how this will work: New page (needs some jQuery updates): Also have Excel with new formula
I'm looking for a skilled product designer who can help me launch an organic milk formula targeted for kids aged 1-10 years old. The milk will come in 800 gram cans. Key requirements for this project include: - i need a logo brand name Royal Dairy , product name : Total Grow - Designing the packaging to be bright and colorful, which will appeal to children of the specified age group. - incorporating claim such as australia made , halal , organic , ACO certified , rbgh free , no sugar added , no preservative , no hormon - Incorporating ingredients like grassfed, organic certification, manuka UMF10, and DHA into the packaging design, adding value to the product for our target audience. Ideal skills and experience for this job include: - Product design, particularly in t...
In search of a competent Excel specialist adept in Microsoft Access for multiple automation tasks. I need assistance with: - Macros Development: The main tasks include automation and creating tools. The proficient use of macros in daily operations is essential. - Report Generation: Specifically, the generation of technical proposal reports. Alongside this, the candidate should also be capable of automating the formula calculation process. Familiarity with financial, sales, and project status reports is an added advantage. - Tool Building: The capacity to build tools and other operations geared towards improving efficiency is crucial. Ideal skills include deep understanding of Excel functionalities, proficiency in Microsoft Access, extensive experience in automation via macr...
I require a highly skilled professional with dexterity in MS Excel and Video Editing. Tasks will encompass: For MS Excel: - Comprehensive data analysis - Detailed spreadsheet formatting - Advanced formula creation for profound financial analysis. For Video Editing: - Apt video trimming - Expert color correction - Adding text and graphics creatively to videos. Ideal candidate will have proven ability in both fields, demonstrating both attention to detail in data management, and creativity in video enhancement. Proficiency in financial analysis and data visualization is a major plus.
Hi Jay - been a long time since we interacted. But I want to let you know that we still use the excel file that you created for us way back in 2017. Its been our main stay. I have another Excel file which requires formula to effect colour change in cells under various conditions. Knowing you, it might be just a 10 or 15minute assignment. Would you be able to help. Thanks. Vish
I am in need of an Excel professional with an intermediate level of proficiency to assist with various tasks on my project. The specifics of these tasks are open for discussion, therefore a degree of flexibility and adaptability is required. You should ideally have proven experience with data analysis, spreadsheet automation, and formula creation despite the fact these haven't been specified outright. An overview of your past relevant projects included in your bid would be highly appreciated. Convince me with your technical prowess and past success stories.
... Key Components: - The table will need to calculate individual doctors' collections and revenue based on specified variables - Additionally, the table will need to factor in: - The predetermined variables for calculating individual doctors' collections and revenue - Management fees - The table will also need to consider the partner's 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, form...
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 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";"CAND") See attached word doc
...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 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.
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, ...
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.
...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.
I'm in need of an Excel wizard capable of 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 variab...
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...
...YES PLS MESSAGE ME WITH THE CORRECT ANSWER, I WONT RESPOND TO MESSAGES WITHOUT IT For this project, I am 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 th...
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...
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, u...
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 branding details are attached, so please incorporate them into your design. I'm drawn to clean, uncluttered layouts with a dominant color for a bold look. Here's some inspiration text to get you started: -"Never miss a moment underwater. The CrystalVision Dive Mask Anti-Fog 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 ...
