# Data set formula jobs

I have a large sheet, that I need to sum totals. Only way I currently know how to do it will be to many =sum(A#:C#)+(A##:C##)+(A###:C###) etc, but like a thousand times. I have basic "SUMIF" knowledge, but I don't really know how to carry it forward since I've updated my sheet.

I have some work, in an Excel spreadsheet.

I have a spreadsheet that I can't figure out how to make a **formula** for.
Video explainer attached as well as excel spreadsheet.
Basically, I need the **formula** to:
Look at 3 cells
If value in any of the cells is greater than 0
Multiply by "Rental Comps" based on: field value (1 bed, 2 bed, or 3 bed), and zip code
If value is greater than zero in multiple

Hi, I urgently need assistance with an advanced excel **formula** which can classify
1. Gross Margin $'s and 2. Gross Margin %'s into classifications. The classifications are:
Classification 1: Gross Margin $ above $500,001 and Gross Margin % > 20%
Classification 2: Gross Margin $ $200,001-$500,000 and Gross Margin % > 20%
Classification 3: Gross Margin$

Please refer to the enclosed file for details.
We like someone to suggest simpler **formula** based on requirements **set** out in "Before" tab.
Also he will help us incorporate the **formula** in the "**Formula** to incorporate" tab.
Let us know if you are confident in tackling the task.

I want to formulated a attachment. Wheres, A sheet name Sample, there is I need a **formula** which make me help to do work fast and easy. I need a perfect work if you can send me a sample file so Please send so i can understand that you understood what i need to do in this Excel file.

i need you to create **formula** for some values in excel

I would like to Input those numbers on Row C and the corresponding result will be on D, E and F base on the Count System Value. SEE PHOTO

We want the **formula** for floral wet foam with the phenolic resin.
We need a special floral wet foam for our product.
We want the **formula**, mixing chemical parts, and ratios to make the floral wet foam

We need someone to create **formula** to calculate price for blinds. **Formula** is: width x height /1000000 x unit price. All we want to do is enter unit price and **formula** should do calculation. We can work with Excel, open office spreadsheet or Numbers app. We can use any software as long as **formula** works effectively. When done it should look like photo

Hello,
We are looking for self heating limestone **formula** to heat foods.
Regards,

I'm creating this database on Google Spreadsheets:
https://docs.google.com/spreadsheets/d/1nzH5ZzVL-nsrI3T6JTRF3JsfLdtSbegvJ8vgCREofXA/edit#gid=0
I need a **formula** which allows me to create column A and column B based on the information obtained in columns C and E.
Each row has to look as row 2.

...requires additional work and debugging as per attached SPEC.
1, CRM (Shipping) PDF - Page Break afer "x" number of products, main **data** to carry forward to new page also.
2, Invoice Database - Unit price is calulated based on a **formula** and not as default product price. Due to this the database is not being populated.
3, Services Products - prices are maintained

I have several workbooks with several sheets each. Each sheet has several lines with a column where we find a code. I need each line that contains that code to be copied.

I want **formula** of feed supplement related to animals.
I want deep knowledge about the **formula** .

Need to modify an excel sheet to show room night relevant to the correct month

Hi, I want someone to build a simple AFL for Amibroker. I do not use any indicators. I want simple code for work in analysis and scan all the nse stock options.

Hi - I need some help building an excel **formula** that pulls fields based on multiple criteria into a dynamic list. Another freelancer was able to develop one using Nested Ifs but I'm unable to use the * wildcard with If statements. This is a critical requirement and Iam open to your solution. Target price is $20 SGD
The work done by the previous

...for coding – Django templates or react website with CMS approach using DB to save Website **Data**. (Flow will be - prototype – Design – layout – programming – transfer)
2. Platform to update content. - For Django we will get default Django Admin (just need to **set** it up), for react there has to be created Admin Screens.
3. Responsive designs to be compati...

I need to get output as the structural **formula** from its string **formula**(C3H8). Normally, when considering C4H6, it can draw 3 separated structures. I need to get all structures from a molecular **formula**. After that need to get most accurate nomenclature for the organic compound. Need to use python for that and need to use Machine learning or Rule based

Hi - I need some help building an excel **formula** that pulls fields based on multiple criteria into a dynamic list. I think the **formula** should be some combination of INDEX, MATCH, LARGE but am open to your solution. Target price is $20 SGD
The criteria for the dynamic list is shown in C4:C12 of the attachment. The formulas for the dynamic list list

Expert in Google Sheet to add custom **formula**

I need a Excel **Formula** to look into certain **data** and give me the Range beginning and Ending Cell References. Basically it will look for blank Cells in the **data**, and when it sees one, the **Formula** will give me the Cell Reference that the Range ends there. and a new Range starts: Cell Reference. I have attached an Excel Sheet clearly showing what is

So the just of it is that on the sheet titled BLANK PIPELINE FOR DEALERS I’m trying to have the sheet auto-populate columns K and L when the user selects the “products” from a dropdown list coming from the sheet titled RMC Price List.

I have a spreadsheet that we are going to use in a website for an end user to select a per-engineered kit. They will have multiple choices to make and based on their answers, it will select a kit and tell them what kit to use and the price. Ii need a quick turnaround (hopefully today) on to write some formulas for me. have the layout. It consists of 3 steps: Step one, select one of 3 choices, s...

I just need someone to basically change some formulas to all of my sheets. Its a little tedious but not hard at all. Short work, an hour tops.

I need the development of AFL code on the logic I have in mind but unable to piece it all together meaningfully. Have most of the requisite indicators and have a clear understanding of buy and sell logics. Need some professional coders help in piecing it all together and build a scanner/explorer for the same.

Need help formatting excel spreadsheet and adding **formula** for discount

I'm the founder of a start-up cosmetic line that specializes in hair care products made from naturally-derived (i.e., non-synthetic) materials. We are in the product development phase, and we're looking for a cosmetic chemist who can take our formulas and description of their pros and cons and provide alternative/corrected formulas. The consultant will work directly with me, and will be ...

...would allow us to implement a **formula** so that we can enter the **data** in a CSV format from one file and the formulas will put the **data** in the **set** fields to the format we need to upload to Linnworks.
We need it so that this CSV file can be reused in future by ourselves and we can drop the **data** in to one field and the **formula** will organise it in the way

I will provide almost 1000's series numbers. You have to find the **formula** or algorithm from this series.

Hi, I want someone to build a simple AFL for Amibroker. Since I make use of just 1 or 2 indicators, this should not be very difficult. Interested people contact me for details.

need to have knowledge in finance.
i need a detailed explanation of the Capital Asset Pricing Model (CAPM) **formula** derivation.
a step by step file is needed.

...assistance with a small excel project.
Task description:
Columns B and C provide a first **set** of **data** intervals. (a top and bottom depth interval). For example in row 14 the interval goes from 816.665 m to 816.833 m.
Columns Q and R provide a second **set** of **data** intervals (a top and bottom depth interval). For example in row 14 the interval goes from

i have some small work for electric generator modifications and need help

Summarising **data** from table onto new sheets in specific formats. All formulas no VBA.

Hi, require assistance with some logic regarding the chart computation for one **formula** only. Require anydesk to show the dashboard and the requirements.

I have one system which generates some numbers when **data** is feed in to.I would like to decode the formulas used.I would just give an example of input number with generated output numbers.I want to know what logic is [login to view URL] is related to may be mean,averages or standard deviation [login to view URL] if you have these skills ,then you are hired with your

Need a software or **formula** (via excel, etc) built to be able to provide simple performance reporting for investment accounts. Looking for a time weighted return provided at a customizable date range. 1 month, 3 months (quarterly), year to date, year over year inception (start) to date OR a customizable **data** range of my choosing. Also need to be able

I have 3 Excel files with LinkedIn contact details that need to be merged into 1, then the contacts need to be undoubled and some formulas have to be put in to create some new columns.

I need a **formula** in which the following
In the table (C2:I44) have entered in client name (list K2:K27)
In cell L1 the output shows the day and time of the clients booked in schedule
eg :
Client A: Session 1 = Monday 5:00am, session 2 = Wednesday 7:00am, Session 3 = Friday 5:20am
Client B: Session 1 = Tuesday 5:20am, Session 2= Wednesday 5:20am
Client

HI, I require a simple spreadsheet created with only a few values, however, one which is tricky. I have attached a rough draft of the spreadsheet which indicates in the comments what is to occur. Please note, I require the spreadsheet to look much more professional then the one attached. Please do not provide a quote until you have read and understood the requirements as per attached spreadsheet...

Need to match new ids with old ids in an excel file, has to be case sensitive.

I have the excel and the PDF Form, you just have to add a formulas (javascript) to form and show an averge. PDF, Javascript.

Problem: there's often a traction problem when playing indoor basketball, especially if the sole...it still picks up some dust (though it's better than everything else in that regard).
What I'm looking for: a chemist/material scientist to help me tweak the tire softener **formula** to make it dry faster and to make it less susceptible to picking up dust.

i need a simple **formula** making for excel to work out the percentage of numbers, the spreadsheet is attached its simple 1 min job but dont hve time, if its more than $5 i'll do it myself sorry