Call web service excel formula jobs
hi I have this sheet attached and I need a formula for column E to give that result ie if the value in column A is OAR: EMP02717 (1 record) then the result in column E is EMP02717
...products (problem here is that there are more than 200k lines (200000) But could split them into several sheets Example is within the sheets link aswell, I basicly just need a formula that is able to calculate every below cells until the next empty cell. https://docs.google.com/spreadsheets/d/1TS-OkJ8aokBqXyut0_XWCDp5RQ38-WnqBlU_z8fPNlU/edit#gid=0
...generate the following formula please: - Column E on our excel sheet has times populated in them - the times are usually minutes (for example 21 minutes OR 30 minutes OR 33 minutes OR 1 hour 10 minutes) etc - we would like a formula creating which we will place into an adjacent new column (let's call this column X) - the formula should automatically resul...
...in sheet 2 a formula which is connected to a filter which shows me depending on the filter I choose in sheet 2 only particular rows from sheet 1. Sheet 1 will be replaced monthly. Sheet 2 should be programmed that it pulls the numbers from sheet 1. An easy way to illustrate is Pivot table. The only thing is that I need this all formula based, maybe
...a certain period X (variable, in # of days). So if X is 30, the formula would look at the average frequency of 'actions' (ie: in days) over the past 30 days. If X is 60, over the past 60 days, etc. See sample under Additional Project Files. I'm looking to fill C10:C2033 with a formula that would check, over the last 30 days from a certain date (CELL
Hello i wold like to buy the formula that are used in this website: [login to view URL] The formula, must be in Excel
I need a new website. I need you to design and build it based on my specification.
I need two spreadsheets to be merged together. Then using formulas I need to update one spreadsheet using the others information, without it updating blanks.
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.
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.
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'
...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
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$
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 $.
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
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..
