Excell formula jobs

For the moment in my Power Bi project, there are formulas that are based on raw data. I would like to normalize this raw data (apply 2 formulas based on raw data and a date slicer, see excel) and use this new data in the existing formulas. I will explain the formulas clearly so as not to be mistaken if there is any doubt.

I need you to build a formula that will give me students(column E) with Column W greater that 2 and Column Y greater than 100 and with NO Graduation Project from column M

Hi there, I'm working with google sheets to run "googlefinance" function. Here's a sample function: =query(GoogleFinance("nasdaq:goog", "price", "1/3/2022")) It returns results as a table that looks like this: Date: Close: 1/3/2022 145.07 For my spreadsheet, I don't need the table headings or the date - 3 of the 4 cells I don't want. ("Date:", "Close:", "1/3/2022") I only need the result (1 cell): "145.07". I'm looking for someone to modify this function in Google sheets to only return the result, to the cell where the function is performed.

I want to make an excel doc that will be: 1. Day 2. Month/Date 3. Start work hour 4. End work hour 5. Total worked work 6. Total worked hours in a range of 22:00 - 00:00 7. Total worked hours in a range of 00:00 - 04:00 8. Total worked hours in a range of 04:00 - 06:00 MENTION: A. Columns 1-4 are input columns, so data will be written manually. B. Start and end work hours can be any, there is...hours in a range of 22:00 - 00:00 7. Total worked hours in a range of 00:00 - 04:00 8. Total worked hours in a range of 04:00 - 06:00 MENTION: A. Columns 1-4 are input columns, so data will be written manually. B. Start and end work hours can be any, there is no regular work day, it's work hours, times can be 5 hours a day, some times can be 22 hours. C. Columns 5-8 need to be calculated with...

I have an excel spreadsheet that uses the (=workday) formula to create a backend schedule for building houses. With it I put in one beginning date and it populates the rest of the dates in sequence for the remaining trades. Each row has a trade (ie paint) with a start date and a complication date. I want to add an email address to each row that corresponds to that trade and have it automatically sent to that trade. I only want the trade on that rom to see it’s date and not the whole spreadsheet. Can you help?

...I can upload the input files into a directory and the script can deposit the output file into a directory, if that is easier. If the excel sheets are an issue, we can separate the inout and output sheets into CSV files. Therefore working with CSV files, in stead of excel sheets. Steps: Step1: Stocklist 1 1.1) Create new sku (refer to formula in spreadsheet Column O) 1.2) Remove all duplicates Step 2: Stocklist 2 2.1) Create new sku (sku (refer to formula in spreadsheet Column K) 2.2) Remove all duplicates Step 3: Stocklist 1 and 2 - combine into Combining Stock Lists spreadsheet 3.1) Combine stocklist 1 and 2, into one stocklist with these columns: NewSKU, Total stock (add the stock from stocklist 1 and 2 together) - column Y and Z (See spreadsheet: combining stock ...

Hi, I have a keywords categorisation task which should be simple and straight forward for someone who knows their way around excel. Basically what i need is, based on the rules in the "Keywords Intent" Sheet i want the column category on "Keywords list" to be filled. I've added the guidance needed within the excel file attached and I'm happy to answer any questions that might arise. Many thanks, Lin

Produce a formula that calculates a cash prize distribution among the top 60% team of the participants who entered into a contest. For example: Entry Fee for the contest is : 49INR or 49$ Total size of the contest is: 300000 So total winner will be: 180000. ( 60% of 300000 ) I need a formula that will distribute the winning amount into the 60 percent teams. In the above case total winner are 1800000 Contest size is : 300000 so 300000*49 = 14700000INR 70-80% of this amount only be distributed to winners In one of the competitor site in above case the prizes are Prize 1: 5,00,000 Prize 2: 2,50,000 Prize 3: 1,00,000 Prize 4-4: 30,000 Prize 6-10: 10,000 Prize 11-50: 0,000 Prize 51-500: 2,000 Prize 501-5000: 200 Prize 5001-30000: 100 Prize 30001-60000: 72 Prize 60001-95000: ...

Optimize code using OpenMP. Description Based on an existing unoptimized solution to calculate matrix-vector product. Apply the optimization and check the result. The calculation of a matrix-vector multiplication follows this formula ci = ∑nk = 1Aikbk where A is a matrix, b and c being two vectors. In the sample code, the value is initialized as follows: Aij = 1.0 ⁄ (i + j), bj = 1.0 ⁄ (i + 1). optimized versions: opt1.c, etc. Make an optimized version in this file. Such optimization should be based on OpenMP this time. You may include any compiler and compiler optimization flags that you wish to. Your code should take the same command line argument as the sample unoptimized code unoptimized.c and produce output in the same format too, with no additional informa...

I need a calculator for quality control, here math plays a big part in this project so you should be good at math. I have an example page and formula to help you know what to do. It is to be created with the plugin called: (Cost Calculator Pro). Deadline: 1-3 days

Hi, I'm looking for someone to build a 5/6 page margin calculator app, I want to be able to future edit in android studio. I have been using an excel sheet for this and want to be able to share with others, have my branding on it and collect basic contact details when someone downloads it. The use inputs how much they buy a keg of beer for and the price they sell a pint of beer, hit calculate...details when someone downloads it. The use inputs how much they buy a keg of beer for and the price they sell a pint of beer, hit calculate and it shows the margins, same for wine and spirits. I've added a few pictures, in the files section, of the kind of layout I want, this is very basic, it's only to give you an idea of the flow and functionality of the app, also the spreadsheet ...

I really want a power BI expert who will perform a formula calculation of the LIFO method, I want this work done in the next hour, please do not apply if you do not have a real expert in Power BI

...was previously entered in Excel is entered and managed on the web Daily Weekly Monthly Data Calculation by numerical input formula Enter text reports by journal type Auto-recognize sheets by recognizing QR codes in the app Developed within the initial version development budget of $300 ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ When you enter the journal data value, by the formula entered in advance Calculated or input numerical values are compared with yesterday's date by date. separate the data For details, I will show you the original excel file, so you can do that. It can be seen that the Excel input method has been implemented through the web. And if you enter the formula operation in the general manager and set the form to be entered, General administrators fill ...

Hey! Welcome to my GIG If you need to done accurate Data entry or Typing in Excel or Word . I am right person for you . available 24/7 I can do for you work like , data entry , copy-paste , web resarch ,PDF to word or excel...you need to done accurate Data entry or Typing in Excel or Word . I am right person for you . available 24/7 I can do for you work like , data entry , copy-paste , web resarch ,PDF to word or excel and many more .. I'm always deternined to deliver projects to my clinets before meeting the dead line with 100% statisfaction and loayality. My service list : .Data entry (All type) .PDF to Excell or work .copy and paste work .Data collection .wordPress Data Entry .Data scraping .CRM Data Entry .Online Data emtry .Data conversion .Online Da...

...row_index_num argument (Figure 2-100). The formula is =HLOOKUP(E5,H_Rates,2) Figure 2-100 HLOOKUP function to display bonus Format the results as Percent Style with two decimal places. Copy the formula in cell F5 to cells F6:F14. Set order of operations to calculate total earnings. Select cell G5. Build a formula to add the commissions amount (E5) to the commissions amount times the rate (F5*E5). Copy the formula in cell G5 to cells G6:G14. Create and copy a SUMIF function to calculate total earnings by branch office. Select cell E18. Start the SUMIF function with cells $D$5:$D$14 as the Range argument. Set the Criteria argument as a relative reference to cell C18. Select cells G5:G14 for the Sum_range argument and make the references absolute. Copy...

We are looking for animation, think "Fat Albert", in that the piece is urban, informative, and morality based. We'd add soulful, hip hop, edgy if it makes sense to be, and cultural. We are looking for someone to bring the visual alive based on a provided treatment. We want one tangible scene for this as yet untitled offering, though we do have a working title. We have the treatment, recording of the script (narration/complete audio.) Please provide samples of your work or links where we can view it. Must sign NDA to receive all assets. Thank you for your time and One Love

Write a function to compliment FORMULA() in LibreOffice. All details will be shared in the chat box.

Problem Description Technicians are developing a system for solar panels. The...to see the current yield per solar panel. They also want to see the current yield for a complete solar panel system, consisting of several panels. It must also be possible to determine the maximum yield and the total yield since installation. The yield is shown in kWh. The yield of the solar panels depends on the power of the sun. This yield can be determined linearly by means of the following formula: y=3x+0.6 where y is the number of Wh and x is the solar power in lux. It is slightly more difficult for the rotating solar panels. There is a quadratic relationship between solar power and yield. y=x^2-6. They also want to know the average yield per m2. Solution of this problem: in IntalliJ Deadline:...

Need a person for writing AFL for Five strategies... Separated quote also accepted for selecting work Strategy 1 - price action , renko chart based Strategy 2 - price action , candlestick Strategy 3 - vwap indicator, candlestick Strategy 4- Bollinger Bad , candlestick Strategy 5 - swing high low , candlestick

I need a HTML calculator to calculate the total value of a property. Attached document has all the fields required and example for the formula. Check thoroughly and bid.

Need a person for AFL codes for automation of trading

List of all the potential buyers was made(attached). The data in the excel must be filled, relevant links provided(as in example). See the attached PDF for the describtion as well as the excell for the list of targets. Job can become permanent with time. In order to apply for the job, please fill the relevant columns(as well as provide links) for the following companies in the excel: Merck Bayer Mindray

Need help with cross-matching between 2 files with the formula

I need a few basic formulas built for 1. when the dependency names are the same then total the amount of all of the similarly named dependencies. a. I am using this as a Gantt chart feature on my board. 2. Add all of the similarly named dependencies together to be shown in the Gantt chart a...formulas built for 1. when the dependency names are the same then total the amount of all of the similarly named dependencies. a. I am using this as a Gantt chart feature on my board. 2. Add all of the similarly named dependencies together to be shown in the Gantt chart associated with the item that has the dependencies. Here is a link to help explain what formula we need

I need an expert (under strict NDA)!to analyse a formula to determine the integrity of the output and determine whether there is any leakage in terms of data or sequencing such that the resulting output and formula could be compromised. Preferably based in West Sussex such that we can meet easily face to face but south east possible.

WE HAVE MULTIPLE PRODUCTS WITH THERE SEVERAL PARAMETERS, WE WANT A SOFTWARE ON WHICH OUR SALES TEAM CAN FILL DATA AND CAN SORT DATA AS PER PARAMETERS. IT MUST BE IN SYNC WITH OUR WHOLE TEAM, IT WOULD BE BETTER WITH EXCELL & VB.

Please Sign Up or Login to see details.

looking for Calculator or formula that can calculate any value as input, for start we will do 3 sliders with value in respective of each other when moving the slider it may sound easy, but its complicated one, I'm using very simple example. I have found a website that can build a costume calculator. please check that out if you are familiar with it. we can discuss more if you have a background of this. thanks

Renewable energy data analysis using Excel (use of formula sumifs ,countifs, pivot table, index match, graphs formation and calculation from different sheets,

I am wanting to have an APP On My Iphone that I can enter the data into and it calculates a Result for me I have it in Excell but don't have my laptop with me all the time

Write a function to compliment FORMULA() in LibreOffice. All project details will be shared in the chat.

Write a function to compliment FORMULA() in LibreOffice. All project details will be shared in the chat.

Hi, I'm looking for people who have knowledge on race car aerodynamics. I need a little help with validation in STAR CCM+. I have the design ready, I just need help with setting it up and simulating till I can validate the results.

Hello we search for someone who can edit youtube videos. It's a YouTube Channel about Formula 1.

Write DAX formula in Power Bi to count the rows and display repeat order and not repeat order customers by text see example as attached excel file

we deal in mobile phones a (X) brand gives us various scheme on sales of its different models and end of the month we have prepare a excel for c...various scheme on sales of its different models and end of the month we have prepare a excel for credit notes they give us incentive on sale of different models on different dates suppose (a,b,c,d) are models if i sell these models between 1-10-2022 to 5-10-2022 i get rs (200,400,600,800) respectively and on same models (c,d) i get (100,200) extra if sold between 3-10-2022 to 5-10-2022 so i want a formula to count the credit notes on subjective models or total of scheme refernce and every scheme has refernce number too. for your refernce i am attaching a excel with two workbooks in it one is for scheme and other is for model sold on diffe...

we deal in mobile phones a (X) brand gives us various scheme on sales of its different models and end of the month we have prepare a excel for c...various scheme on sales of its different models and end of the month we have prepare a excel for credit notes they give us incentive on sale of different models on different dates suppose (a,b,c,d) are models if i sell these models between 1-10-2022 to 5-10-2022 i get rs (200,400,600,800) respectively and on same models (c,d) i get (100,200) extra if sold between 3-10-2022 to 5-10-2022 so i want a formula to count the credit notes on subjective models or total of scheme refernce and every scheme has refernce number too. for your refernce i am attaching a excel with two workbooks in it one is for scheme and other is for model sold on diffe...

...Pinterbet, Planetwin365, Plexbet, Pokerstars, Quigioco, Scommettendo, Sisal, Snai, Sportpesa, Sportyes, StanleyBet, Starvegas, Unibet, Williamhill, Wintoto Some of the above list are public APIs . The information in the Oddsmatcher table are: 1. date and time of the event 2. The 2 teams that will play 3. Rating, is calculated based on a mathematical formula knowing the odds. 4. RF (Risk Free), is calculated based on a mathematical formula knowing the odds 5. Bookmakers where you have to bet 6. Liquidity of the bet on the exchange "Betfair" 7. Taste filter with some request, minimum quota, date event 8. A sort of search where you can select the bookmakers you need 9. RF, enter the data so that you can calculate in a precise way (when I need it) Moreov...

Chemical researcher for my formula making

Hi, I need an excel expert who can help me in automation of data process with some advance excel formula and power query. I will pay the required fees

I need a specific formula or script written for Google Sheets to automate one step of a data entry process. It would involve recognizing a cell with a duplicate value in the sheet, and then automatically filling in the remaining cells within that row of data to match those for the duplicate cell that is in a different row (same column) in the sheet.

Looking for an excel guru to help me with a formula

It's a straightforward thing I am trying to do—looking for a pro.

Dear all , i have a small project to print an invoice this invoice includes the QR code for one field the type of this Field is Long Text I need to add QR so I can read it through my camera i am using VB6 and Crystal Report 8.5 #VB6 , Crystal Report 8.5 I need a way to pass a picture from the URL to my report from the VB6 I need a way to Add the QR Formula to My report for Long Text Field the work must be in my PC

=IF(ISBLANK(I4),"",SUMIF($A:$C,I4&"*",$C:$C)) Need the value in E4 & E7. At the moment it is taking the value from E5 & E8. When it see the Credit 1234 or Credit 4567, I don't want the value next to it. I want the value next to it and up one. Only change the cell in red No wholesale changes to the formula and follow the same formula vibe. I have cut down the spreadsheet to simplify my question so please don't go changing it overall function that is not apparent in this cut down version. Thank you for taking a look at this. Thank you

I need to make Excel sheet for material tracking

I have an excel file that's generated by an app on a weekly basis. I need to grab this data and put it into another excel sheet in a particular format. You will need to be familiar with VLOOKUP, and other excel functions to build this formula. I AM **NOT** LOOKING FOR MANUAL COPY AND PASTE. I'm looking for to build this formula so in the future, when I receive new weekly generated excel files from an app, the formula is smart enough to populate the new sheet.

i need to make simple amibroker indicator which is based calculation formula shared with you that need to calculate and plot it as indicator

Hello, I need some help with a Google sheet formula, programming or Zapier solution. We have Google form answer sheet. This sheet is connected via Zapier to automate a Google Docs template document. Each time someone fills in this form, a new row is created in this Google sheet. After that zapier makes an Google Docs document with the data from this sheet. If someone fills in a dropdown selection of different courses, we need to publish a course number and price in the template document. The courses, data and prices are in another worksheet of this Google form answer sheet.