# The formula for writing a report jobs

On **the** PRINTING TAB
Whenever you select **a** SCREEN on Cell F3-7, it will populate with that amount in Cell I17.
But will say (**THE** NUMBER) Setup or Setups
Like this:
Price Includes: 1 Front Colour, 1 Setup, Screen Printing
If it's 2 or more it changes to:
Price Includes: 2 Front Colours, 2 Setups, Screen Printing.
when you select **a** colour it puts

I have an excel sheet I need **the** **formula** and/or macro edited **for**.

I need to have **a** spreadsheet I have created, automatically change colours when inspections are due, and servicing duration selectable by **a** drop down cell.

I need to delete some data in **the** database of my software written in Java and hosted on Tomcat.
i made some error in entry so i need to delete **the** data and make my entry again.
i also need to copy out **a** **formula** from one of **the** files.

I’m looking **for** some to create **a** **formula** that would be able to transform **a** distance in yards and feet to **a** primoximty to **a** random position in yards
Column **a**,b and c would be manually imputted
**The** data in Column **A** would be **a** distance in yards
Column B would would be **the** distance in length yards
Column c would be...

create **a** VBA function that plays 100 rounds of **the** game friend or foe

Hi I need **the** following **formula**.
We use Google sheets **for** tracking projects. We need to be able to know when we have assigend **a** person too many tasks **for** them to complete in one day. So if we assign them too many hours, something goes red to highlight it.
Here is **a** sample spreadsheet: [login to view URL]

Create an excel spreadsheet "program" to reformat data from various cells in one sheet to another. Combine cell data based on other cell data.

Make **a** spreadsheet **for** **the** transport system and integrate automate system **for** **the** data update and Generate Reports.

Hey! I need **a** formular in Row J:
IF Row B = (is found in) Sheet "Kosten" Row B
AND IF Row F = (is found in) Sheet "Kosten" Row G
THEN SHOW Price of Sheet "Kosten" Row R
File is attached. I think it's very easy **for** you. Who can help?

Hi there,
i have **a** set **a** data in excel, i need someone to create some advanced pivot table with **formula**, and **a** couple of graphs.

This is **a** simple project **for** **a** Mathematician to work out **a** **formula**. See **the** attached image please.

I am trying to convert and excel **formula** into php but **the** results are not **the** same

I need to explain what **the** **formula** describes in PM (Removed by Freelancer.com Admin)
It's **a** simple, fun project I am working on. I will need 1, max 2 hours of your time.
I can pay $10 per hour

Hi there, I hav...fields, when user puts value in **the** input fields it need to check if it is according to **the** core data (value is on same row)
If not is **the** same, it needs to show message box stating, value is not **the** same.
then user can proceed to change value or keep different value
and it has to do **for** all **the** values
check screenshot **for** examp...

I am soon releasing **a** music video of my song **The** Peace **Formula** ([login to view URL])
I want it to go viral on **the** internet and I want to hire who knows how to make it go viral.

Column D contains **a** code. **The** first 8 digits of **the** code have many duplicates, with only **the** last 3 digits (including **the** -) being different.
I want to hide, or remove, all rows that have duplicates on **the** first 8 digits.
Quick and easy.

...names in **the** same columns, plus other columns containing other values. List 2 has column **A** Last Name and column B First Name only. I need to find duplicate first and last names and remove **the** entire row of duplicates from both lists.
**The** first list contains names that have unsubscribed from an email, but I do not have their email address. **The** second

I am working on **a** simple spreadsheet of US time zones.
I have **a** list of numbers that I am working with and **a** list of area codes that fall into each time zones.
I need **a** quick **formula** to look at each number, reference **the** list of area codes (sheet 2) and identify which time zone each number belongs in.

Rectify **the** error in series excel **formula**, prompt action is required

i have an (embedded/nested?) if/then statement **for** **a** worksheet that i can not get to work.
it has lots of variables that i want to include in one long statement / cell instead of multiple ones (**the** only way I know how to do it).
I need **a** quick turnaround, if possible.

...backward interpolation **formula** which mean how **the** **formula** became like this from **the** beginning.
I will give you **the** proof of Gauss's forward interpolation **formula** to help you understanding what I want.
please ONLY bid if you are **a** mathematician, understanding Methods of Numerical Analysis and understanding **the** project's goal.
N...

There's not much more than **the** title. I have **a** set of physics math that has been converted to excel. I have **a** couple more left and need someone with **a** physics background to help me convert them to excel.

...are measuring **a** sugar value with **a** refractometer during fermentation.
Due to **the** fact that alcohol is decreasing it influence **the** refractometer value and we do not get **the** right sugar content.
To compensate that we made measurements with other instruments to find **a** correction factor.
Of course depending on **the** start sugar value, **the** corr...

See attached descriptio...There rotating vector of fixed lenght L. Use L=1
- **the** vector projects onto an X and Y axis. These 2 axis are at 120 degreed (They are not 90o orhtogonal)
- knowing **the** projection Lx and Ly find **the** **formula** that gives **the** angle **a**
- provide **a** verification table showing that your **formula** always works with **a** from...

I have **a** very small and probably easy job that an excel expert can help me with. **The** **formula** is 2 calculations that depend on fixed data which can vary. Not sure if that makes sense but talk through briefly or email more detail.

...someone to help me repair this COUNTIF **formula**
=IF(COUNTIF($E$1:$E$13300,E1)=1,"Unique",COUNTIF($E$1:$E$13300,E1))
Here also is **a** video which shows **the** difficulty that I am experiencing.
[login to view URL]
Assistance is greatly appreciated.
I will pay $4 **for** full completion of this task.
**The** solution must work in my existing sheet

ONLINE FULL EXCEL TRAINING WITH ALL **Formula**

We are **a** leading organic baby food company. And we would like to invite you to help us broadcast our organic baby **formula** product throughout social media. **A** perfect candidate should:
1. Have connections or could help find 60+ Facebook and Instagram accounts in mom&baby, shopping, lifestyle, or other baby-related categories.
2. Reach out **the** accounts

I need someone who can decrypt an android apk and provide me **the** **formula** used **for** generating 2 header fields sent as http request.
It should be **a** 10 - 15 minute job **for** someone who knows how to do it. I am not looking **for** someone willing to learn and I will ignore bot bids.
Thanks.

Need help to automate my shipping website to allow it to give it instant quotes, I need **the** services of someone who is good in mathematics and can also help to design how we will produce our quotes

Hi I need someone to teach me salesforce development
**the** area i am intrested are:
Formulas
Apex
Trigger
I want someone to teach me until i get expert on these.
Thank you

We need to implement certain trading strategies **for** our portfolio management and automate it using Amibroker **Formula** Language(AFL)

Hi,
Please take **a** look at **the** attached document.
This shows an example of my 'dataset', and **the** layout of how I would like it to be transformed...
I would like to accomplish **the** "End Result" with **the** use of **a** **formula** only - and NO helper columns. - Array formulas are also fine.
** I don't want to use macros **
** I don...

Need to convert this excel **formula**: =-((G2+(G2*F2))*(((1+F2)^(C2))-1)/F2)
to **a** javascript, according to this:
[login to view URL]

I have an excel doccument, which I need to create **a** **formula** to search information by inserting **the** name of **a** student.

Hi,
Please take **a** look at **the** attached document.
This shows an example of my 'dataset', and **the** layout of how I would like it to be transformed...
Ideally, I would like to accomplish **the** End Result with **the** use of **a** **formula** only - and NO helper columns.
I have colour coded **the** data to make it easier to read.
Please take **a...
**

**
$24
(Avg Bid)
**

**
Excel Need a formula
Ended
$20
(Avg Bid)
$19 / hr
(Avg Bid)
$114
(Avg Bid)
$18
(Avg Bid)
Excel match formula
Ended
$21
(Avg Bid)
**

I have **a** row of cells. each cell has an index match **formula**. I need **a** **formula** that will return **the** first value in **the** cell that is not ""
Attached is **the** sheet.
I want cell F11 to display **the** result from range G11:Z11

1. **Formula** **for** Markup
2. **Formula** **for** Volume Pricing
**A**. I have 3 files, same format on each file. Each file has Inventory Sheet & Markup sheet.
I (amatear) have used (If) **formula**, I know you can do better.
B. I have try to have volume discount **formula** and failed.
I use hidden columns.
I use Teamviewer.

...written **a** complicated pricing program in Excel and need assistance finishing it.
**For** this moment you are bidding on debugging **the** macro "Building 1" Located on **the** "Quote" Worksheet.
**The** winning person will:
*Have advanced knowledge of Excel.
*Be able to start immediately
*Be available **for** hourly work over **the** next 10 days t...

Need **formula** to calculate day and time **for** my excel sheet

I have some work, in an Excel spreadsheet.
It’s very simple.... basically just want **a** match **formula**

I have **a** signage Company and sell different signs. Some are standard and others custom made. In general we work on **a** per square meter (m2) price. I need **a** **formula** **for** pricing. Example: **A** sign is **A**:190mm x 190mm **for** $30 (works out to $831/m2). **A** sign B:290mm x 290mm sells **for** $58 (works out to $689/m2). If I only work on **the...
**

**
$25
(Avg Bid)
**

**
$26
(Avg Bid)
$103
(Avg Bid)
$89
(Avg Bid)
$28
(Avg Bid)
**
I need **a** **formula** or macro to extract URL’s and text between <**a** href> and </**a**> tags.
There could be up to 20 occurrences per cell.
All links merged into one column, and all **the** text between **the** anchor text in 1 column.
I do have **a** **formula** in sheet 1, cell D, but its not correct. I need it to be extended to cater **for**...

...three Formulas **A**, B, C, that need to be written mathematically, and possibly write an algorithm to go with it.
% PREPOSITIONS
% COMMON NOUNS
% PLURAL NOUNS
% BASE VERBS
% DETERMINERS
% ADVERBS
% PRONOUNS
% ADJECTIVES
**The** % is defined, but not in above example, since this post is public to freelancer.com.
What I Need is mathematical **formula** or algorithm

Need someone who can help with matching two different sheets in excel i.e. GDP growth rates **for** specific countries in specific years (in one sheet) and matching this with **a** new column ''GDP Growth'' in **a** sheet with premiums **for** M&**A**-transactions.

if Column 1 AND column 3 are **the** same, then these rows should be together in column 2, divided by **a** comma