# Excel formula spreadsheet spreadsheet jobs

Only people with knowledge of DAX syntax and Powerpivot apply please. i need a pivot table that has in one of the columns the total amount of th dataset. Please see attachment.

My name is Pilar, I am working on building an **excel** for tax calculation purposes and I am running into some trouble with a **formula** that I cannot build-in on my own.
The **excel** is basically an annual gain/loss stock portfolio statement that takes the dollar amount of the purchase and sale proceeds and converting it into the official Mexican peso rate

This should be a quick **formula** to pass my way.
Just need an "IF" **formula**.
As you can see, in Column "A" I will be selecting the status of the MSR, and need it to auto fill the applicable total to the appropriate cell on the right (Received, In Progress, Complete, Shipped)
No need to bid on this, as I have a freelancer already lined up

Help me with Sensitivity analysis, Monte Carlo simulation, optimise the LCOE **formula**.
I have done some part of the work and I need you to improve the overall paper and also help with Sensitivity analysis, Monte Carlo simulation, optimize the LCOE **formula**.
More details will be shared.
Thanks

I NEED AN **EXCEL** **FORMULA** CREATED FOR A HYDRAULIC LOSS PIPE CALCULATOR, I WILL PROVIDE A VIDEO OF ME DOING IT THE LONGHAND WAY (BY HAND) I WILL THEN NEED YOU TO CREATE AN **EXCEL** PROGRAM FOR THE CALCULATIONS TO BE AUTOMATED - THE CALCULATIONS WILL BE BASED OF INPUT DATA EXTRACTED FROM A COMPUTER PROGRAM, THIS DATA WILL INCLUDE PIPE SIZES, LENGTHS ETC.

Hi there, I have two documents. One shows: * Post code * Names of customers The other shows: * Post code * Longitude * Latitude I need the first document to ALSO show long & lat for all listed postcodes. that's it. So, long/lat' from sheet 2 need to be put onto sheet 1 I need it immediatetly. Very easy job.

Mengisi **spreadsheet** dengan data saya bisa memasukkan data di **excel** dengan beberapa **formula**

I need my **excel** **spreadsheet** finished with **formula** ,it cant be done with VBA or Macro because only **formula** is alowed .

I made a robot it has 2 motors and 2 encoders attached
the encoder....motors and 2 encoders attached
the [login to view URL] reads the value from the wheel and display on ROS and I can see the movement on RVIS but the movement is not correct so the **formula** might need to be fix
[login to view URL] works fine but I will like to combine that code with [login to view URL]

I have ongoing work related to our previous project 'I need an **Excel** expert to help me find a solution to this problem via a **formula** or macro'

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

...mica and nail polish suspension. i've made just about every kind of nail polish. Thermal color changing, neon, magnetic etc.... I need someone to create a new nail polish **formula** for me. all ideas are welcome. when u bid please submit a possible idea so i know u understand this project. you don't have to tell me the entire concept i just need to know

Hi, I have a complicated **excel** project underway which someone else designed - now one of the formulas doesn't work so I need help on how to extablish the error and then fix it.
I need someone who can skype or do some kind of video call and screen share as I'd perfer to talk it through with someone..
I do not want to upload files as they are personal

I have a difficult **excel** set up which someone else built for me - One of my formulas is not working and I need help to work out how to fix it.

I need a **formula** or macro that will find in file [login to view URL] values (article code searched) as in uploaded files values like in [login to view URL]

Create a probability **formula** relating to blockchain Proof-of-Work systems: Given: 1. a hash of N bits, 2. a 'difficulty' of L leading zero bits, 3. a matching hash (generic solution S) is found on average in M minutes. (by varying a part of the input data, nonce) Someone selects one predetermined hash fitting the above requirements and searches only

I want you to make web scrapping and build a list of some company. I will give more details on message. Bid only for those who are honest and responsible freelancer. Thanks

...is extremely important since each row is connected to a primary key.
The file will be provided as a one **spreadsheet** which can be imported into **Excel** or another **spreadsheet** program. The deliverable is a **spreadsheet** that matches the output **formula** based on a set of examples attached to this posting.
PLEASE NOTE that this will be a manual effort. The

Hi,
I have an **excel** **spreadsheet** that I need to calculate the vector angle of the three plot points I have.
Please modify my **excel** **spreadsheet** to memorize this conversion and input results in F column for each row.
Also, please give me the math algo equation written on a notepad to calculate the vector angle. This way I can use it in other projects

hello, i need an **excel** **formula** which would count the number of occurences in a column , attached is the sample file, the result should give me the list of codes that are present in column A , and count how many times it appears in the whole column.
this is a very simple task, expected budget is 5$

I have 4-6 separate commission reports that are all either CSV for **excel** files. They all have multiple columns of information but I only need 7 or so columns from each **spreadsheet**. Each column is named differently and in different orders between the reports. I need to extract the 7 columns that I need from each report and combine them into one master

Knowledge about Waveguides is a must.
I will provide you with the code and the **formula**.
The code is an implementation of a 2d rectangular waveguide.

I develop business logic in **Excel** and need a **formula** to scan several hundred transactions to find circular payments.
In the example, A pays B, B pays C, C pays D, D pays E, E pays F, F pays A the elimination **formula** needs to remove from each payment the smallest circular amount. (A pays 180 to B; B pays 30 to C; C pays 50 to D; D pays 10 to A:

Need an **Excel** **formula** worker to duplicate words in a row to produce variations on a id number.
example. hello1, hello2, hello3 etc.
Please don not apply unless you know how to do device the right **formula** to duplicate these numbers
Pays $30 AUD

I need a **formula** to calculate the difference between 2 values output in a percentage. 2 columns Actual and Forecast, where if actual is 0 and forecast is 0 - result 0%. Actual is 0, forecast 10 - result - (100%). Actual 10, forecast 0 - result - 100%

I have three examples that I am trying to compare information from each example independently to a database; I am trying to think of a **formula** that when I paste the example it will compare it to the database scenarios( Labeled 2-29) and report back with each of the scenarios which information is missing.
-------------------------------------------

I have three examples that I am trying to compare information from each example independently to a database; I am trying to think of a **formula** that when I paste the example it will compare it to the database scenarios( Labeled 2-29) and report back with each of the scenarios which information is missing.
-------------------------------------------

i need to create **excel** file with a statistical calculator **formula** ,
Please check attached image first , the image contain a list of Percent numbers of a population in different ages ( Please Check Attached Image ) .
i want to be able to add as input those percents from image , and the **formula** calculate those needed ranges :
- 17-29 = X%
- 30-44

...is simple, but it requires a powerful computer with a lot of RAM since you have to run a **formula** on 645,000 rows. If you don't have a powerful computer, please don't bid.
1. Download the **spreadsheet** we provide to you after we hire you
2. Open the sheet in **Excel**, go to cell S1506
3. Select cells S1506, T1506, U1506, V1506, W1506 and copy them
4. Paste

Insert some formulase in Excell using V-lookup and data validation. I provide clear instruction on what to do

...blends Agile Software Development and performance management processes to help teams prioritize metrics, measure value and execute their game plans. I need help creating a **formula** for estimating Team and Player Recommended Values.
View the framework and process here: [login to view URL]
Within this process teams identify statistics

URGENT - Count consecutive sequence in single column or row that satisfy certain logic (i.e. = / < / > / >= / <= / <>...etc.) in the order of columns or row (i.e. if the selection was in row 1: pick 0 to choose A-Z order and 1 to choose Z-A order. Same if selection is column) Hint from programing language: COUNT A:Z ( WHILE ( A:Z >= 0 ) , ORDER=A:Z, VALUE IF FALSE=0)

Hi, Is your company able to manage this task within next 12 hours? Two formulas extracting particular text. It is nothing complicated. If you manage this one, we can cooperate more often. My price is 15 $.

Hi Sousa, I'm looking to make an editable **formula** on a **excel** **spreadsheet**.
I need to calculate the following:
(1) a win / loss average, (2) an average profit per win, (3) an average loss of profit per loss, and then (4) a calculation to determine a percentage of profitability given the results of the prior (1 - 3) equations. For example: If I win 9/10

I need to find a **formula** that one our competitors is using to calculate the product price.
The product price is calculated based on the area in SQM. The inputs are length and width (which gives area in sqm). Price is calculated using the area however we do not know the exact **formula**.
Your job is to find the **formula**. It could take in consideration

I want you to create a **formula** for me for my ebay business **spreadsheet**

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

need to correct afl _SECTION_BEGIN("hello"); SetChartOptions(0,chartShowArrows|chartShowDates); strike=28000; sym1="BANKNIFTY18AUG"+strike+"PE"; sym2="BANKNIFTY18AUG"+strike+"CE"; _N( Symbol1= ParamStr("Strike1", "sym1") ); SetForeign( Symbol1 ); C1 = C;H1 = H;L1 = L;O1 = O;V1 = V; PlotOHLC(O1,H1,L1,C1,"STRIKE1"...

I have some work, in an **Excel** **spreadsheet**. With formal to use a table as a command specification for every product

...hopefully a long term partnership. I am looking to partner with someone who is able to research formulas for dietary supplements, and figure out where I can buy the cheapest **formula** for my product.
So here is the first job, can you find out where in USA, we can manufacture this product that contains these things, How much does it cost per bottle? Per

Hello,
I am looking for someone to create the right Woo Price Calculator **formula** for my website that will deliver me a dynamic pricing system for my printing company.
The products will have 3-4 custom options that all depend on size to create final price.
Here is a link to a website and product that has the same dropdown values that I will require

I have 1 **excel** file.
There are 2 tabs "Sheets" at the bottom
The first sheet is my main list that I will use to print when i go out to buy materials at a hardware store, but now, is empty..
The second sheet has a complete list of materials i may need in the future, it'll have "The name of the material" , and the "Quantity" needed. I'm trying to get

I have 1 **excel** file.
There are 2 tabs "Sheets" at the bottom
The first sheet is my main list that I will use to print when i go out to buy materials at a hardware store, but now, is empty..
The second sheet has a complete list of materials i may need in the future, it'll have "The name of the material" , and the "Quantity" needed. I'm trying to get

I am a payroll administrator trying to simplify an **excel** **spreadsheet** from one tab to another tab but do not know how to code the **formula**. I know how I wish the cells to function but do not know how to write the **formula**.

I’m trying to make silicone sex toys (buttplug, vibratort etc). But before starting, i need to know the best silicones to create LELO quality items.. (i just need to know the detailed medical grade silicone brand and model) Then i will create mold, and start trying as like in Youtube videos..

One page **formula** with 8 images that requires animation or whiteboard

I develop business logic in **Excel**
I need a **formula** to scan several hundred transactions to find any circular payments:
For example
A pays B, B pays C, C pays D, D pays E, E pays F, F pays A
it needs to remove from each payment the smallest circular amount.
For example:
A pays 180 to B; B pays 30 to C; C pays 50 to D; D pays 10 to

**Excel** Expert with success in maintaining and organizing data,
Skilled in :
[login to view URL] **formula** development,
2. Pivot Table generation, and Pivot reporting
3. Sorting & indexing of Data
4. Formatting **spreadsheet**

...1660$. With those 1660$ I can give out immediately 5 new loans and the next day I will receive 16.60$ x 105 loans= 1743$ which I give out 5 new loans. And so on. I need a **formula** to be able to calculate the growth of my business, doing it until day 20 is easy since it just grows but at day 21 the initial 100 customers are done paying so the incoming