# Call web service excel formula jobs

Need a google sheet **formula** that does the following. **Excel** **formula** will not work, needs to work in Google Sheets.
Get the total of all F cells in the sheet name Payments where the number in D in the sheet named Payments equals B in this sheet.

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 on Cell I17 XXX Colours. i want to do the sa...

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 ...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 the distance right or left in feet

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 have three columns in **excel** with core data and three columns with input 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

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.

I have two lists. List 1 has last and first 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 lis...

I am working on a simple spreadsheet of US time zon...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.

Hi,
I need you to proof Gauss's 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

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**.

...somebody who is able to find a **formula** to calculate the right correction factor for each start value and each step during fermentation.
We put the data from different start values into an **excel** sheet to see if it could be possible to find a **formula**. We are not mathematician so we need somebody who can find the **formula** for us.
Attached you can find

See attached description.
- There rotating vector of fixed lenght L. Use L=1
- the ve...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 0 to 360degrees

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.

I need 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

ONLINE FULL **EXCEL** TRAINING WITH ALL **Formula**

...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 and ask them to broadcast our baby **formula** product on their social media 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)

....
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't want to use pivot tables **
** I don't want to use filters **
I just want a **formula** or array **formula** to transform the dataset, into the End Result as shown in the exam...

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.

...
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 look and let me know if you are capable of helping me.
Thank you very

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.

...even consider your offer.
I have 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

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**

...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 Square meter price of Sign A, Sign B would be $69.88 and would be too expensive. So I am looking for a **formula** that should a sign increase in size

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 20 occurrences per cell, as well

...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 that states, Based on the % that totals 100%, a paragraph, will be made up of those % percentages. Say Common Nouns is 10%, there would be 10% nouns in the paragraph

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.