# Formula writing jobs

I need to replicate excel's sumproduct function using the DAX language in Power BI. I have attached a simple excel spreadsheet with two tabs of input data as well as the output tab I need to recreate using Power BI instead of excel. In this example, each portfolio has a % allocation to multiple strategies and each strategy has a % allocation to multiple holdings. I need to get the holdings...

Assign a % automatically based on other values.

excel **formula** expert needed for drop down menu and graph plotting
BUDGET IS ONLY 15, DO NOT BID HIGHER

I have an exe application, I need to know the **formula** used in it.

I have an exe application, I need to know the **formula** used in it.

...divided and sorted to look like data in sheet 2. We should be able to use this **formula** over and over for different data but in the same form. **Formula** should be able to handle about 1000 rows of raw data in sheet1
As we enter new data (about 1000 rows) in sheet1 in same form **formula**/script should automatically process it into sheet 2.
This is NOT AN EXCEL

We are a small company with a genius product that has the potential to make millions. We hired marketers and spent $30,000 with zero results. We are now looking for marketers that can, and will, sell our product for a percentage of the profits. Our product is designed by doctors, but we are not [url removed, login to view] are the only company in the world that produces this innovative pain relief...

I need 2 excel spreadsheets created both should have 2000 rows.
Two columns in each spreadsheet to be created with a **formula** to generate date and times.
Contact me for more details.

I need to be able to run the levenshtein distance algorithm (or trigram **formula** if that's better) comparing two sets of data from within a single excel. I believe this is doable via VBA and have included a link to a site that provides the VBA code.
[url removed, login to view]
The inputs would each consist

I have spent the best part of two to three hours trying to resolve this specific issue. which relates to a **formula** adding up a series of cells in about 12 sheets. I don't need to use the + for each cell as the numbers are spread across several cells on different sheets. Most of the similar formulas are OK but the VALUE error I corrected became a REF

...someone to tell me what the **formula** is for the 2 sliders on the homepage of this website;
basikloans(dot)com
It calculates a monthly loan repayment based on the information input through the 2 sliders.
Note: If the loan is below £9k the APR changes to 5.2%, then to 4.5% if above £9k
I need someone to write the **formula** out so I can give it to

Searching for Excel Expert to help create pricing formulas & formatting on Microsoft Excel & Google Sheets.

...Sheet Van Wingerden
[url removed, login to view]
Create a **formula** in the google sheet "Inventory" for each column named (week #). The **formula** will move inventory from one column to the next based on the time (Sunday evening at 12:00AM PST.) It will also look up the week# according

I need some assistance with building a t-ra-di-ng model in excel. The workflow is pretty basic I am just coming short on about 5 key columns - can describe verbally what I want for each column -- I just can't figure out the correct formulas. I have attached the excel sheet of what I have done so far and a descriptive word document. Stating what I would like done in each column - the columns ...

count unique values by referring two columns with two or more criteria. Max project duration is 30 mins. it just a single **formula** with IF conditions.

I have an excel spreedsheet with formula's that I require setting up on Zoho. I need to be able to answer the individual fields and the formulas still work out the sums. These questions / additional fields need to be completed for every lead.

I have some work, in an Excel spreadsheet. Calculate average time (number of hours)

Subtotal **Formula** to avoid time consuming manual subtotals. I have been trying to use a SUMIF function based on my research but have been unable to figure it out so far.

Wants to design an excel sheet **formula** and report the outputs on powerpoint, I have the powerpoint report sample that needs to be developed as well,
the report is about keeping an eye on a property development progress, which includes the following:
1. Development Update
a. Permits Update
b. Infrastructure works updates
c. Saudi Electric Company

Need a text extract **formula** for excel. The **formula** needs to locate one of the following phrases (the first time it occurs) in a cell:
LLC
Limited Liability Company
Limited
Ltd
Ltd.
Company
Corporation
Incorporation
Corp.
Inc.
Corp
Inc
Co.
Co
Partnership
Limited Partnership
PC
Professional Company
and then return that phrase along