Need formulatrabajos
hi excel cracks i have a items which each has 2 value cells: first cell is "impact" (values 1-4, 1= low) and 2nd cell is "complexity" (values 1-4, 1 = low). Now i want to have a dynamic ranking of my items based on the calculation of the both values. Eg. item "emailing" has a high impa...points. If another item would have a low impact (1) but it's high complex (4)= this item would also have 5 score points. but in terms of priority it's not comparable with the first item, as I want to prioritize items which have a high impact plus a low complexity. Expected output: dynamic sorting/ranking of the items with the associated ranking number NO: VBA, Scripts and similar, ONLY DYNAMIC FORMULA via =Rank( and similary. Propose only if you unders...
- Design a tool where it will get data from a public webpage or public API and send this info using an instant messaging platform to specified phone numbers, if the mentioned date match with the outcome of a specific formula (meaning "if this then that" formula using public data as well). - The data that will be checked is a "variable", meaning it's changing everyday. (Ex: find items on a page that have a certain field greater than X and if Y column of that item is over 2.00, then send me an instant message) - System should check the data every 3 seconds and send it instantly if matched data is found. - The tool should include an authentication service, it should behind a login page. - The tool should login the user into another webpage (through FE lo...
...(Selection) Our Cash Acc => Selection Meena Bazar Branch needs to be Default Value Agent Comm = 0.75 default Formula will fill textbox, but that textbox value user can change Display 4 images with label Previous ids and display Last Transaction in Cash : 5000 and Swiped 5125 as label (NOT Dynamic) Date Current Date Default, user can change User can upload Multiple Photos (This is Static HTML, but just user can check how to upload multiple photos) If User writes Cash .... then fill Swipe Automatic Swipe = Cash*100/(100 - Client %) If User writes Swipe .... then fill Cash Automatic Cash = Swipe - Swipe * Client % / 100 Milestone 1 => 1 page HTML Only, but formula javascript Dynamic No need to Save this page Have a look. Ask queries, give your estimate. This w...
Design And Develop Stock Market Website with Calculation Based Formula For Stock Pick (Forex And Indian Stocks) Data Delay Also Acceptable Add a Mathematical Formula Based Sheet Which Helps in Stocks Picking
Need the formula for identifying next week's dates from a list of dates in Excel.
Hello I am looking for an excel sheet expert to make one formula for me based on my requirements. I will share the requirements over chat with the selected candidate. Please share your experience in making excel sheet formulas. Please bid only if you are an expert to make formula Thank you.
...Tab Based on the previous 2 sections (scanner + charting), a Recommendation tab should show stocks sorted based on: - Buy/Hold/Sell Rating - Star Rating / 1-10 Rating [Shown on platforms] - Market Cap - P:E Ratio - Avg Vol - Vol The stocks with the largest market cap, most stars (highest ratings), lowest P:E ratio, trading near (volume) the average volume should appear to the top. Can use a formula; create #'s; sort them. ________________________________ Bot Tab Based on The Recommendations, the Bot tab should allow for automatic trades to be setup and *must* work fully with TDAmeritrade. _______________________________ Program must work with TD-Ameritrade upon delivery. I won't be sharing my log-in information. I won't pay for a partially functioning app...
NEED RO MAKE SOME ENTRY IN A EXCEL FILE WITH HELP OF SOME FORMULAS
...• Create variables • Loading and calculating data Setting up Planning Security : • Introduction to planning security • Assigning roles to planning users and groups • Setting up planning security • Provisioning users • Assign access permission to users Working with Planning forms, dashboards & Infolets : • Creating Forms / form properties • Creating form folders • Adding formula columns • Building validation rules • Creating forms with Rolling forecast • Create Action menus • Assign action menus to forms • Create Dashboards • Building a dashboard • Dashboard properties & chart types • Building infolets Managing Business Rules : • Introductio...
Hello everyone, I am struggling to get the right formula. Please download the example excel sheet. Basically, you will see a list of names and companies in range A4:D10. What I need the sheet to do is enter a name in B2 and the sheet produce a list, shown in G4:J5. I just cant get it to work! The Name is the unique identifier. Now I need someone good with excel to solve. Please mention you have downloaded the excel before replying or quoting, its important you look at the issue.
need a very short animation which shows how to open a baby formula can to scan a QR code... I have attached a short video ()showing how it would work in real life and we need a basic animation showing how to do this (no hands needed just the can with lid opening)
[ASSISTENTE VIRTUALE ] Siamo alla ricerca di 1 Assistente Virtuale per Presa e Gestione Appuntamenti da integrare nel Team a supporto della rete Vendita. La nostra realtà collabora con proprietari di immobili (ville, case e appartamenti) ed è specializzata nel property management con la formula degli affitti brevi. La risorsa si occuperà di trovare, contattare tramite annunci, chiamate e messaggi (DM) proprietari di immobili e fissare appuntamenti in agenda. La nostra offerta: ✅ Retribuzione fissa oraria ✅ Commissione per meeting fissato e vendita del servizio ✅ Bonus produttività al raggiungimento di obiettivi mensili ✅ Percorso di carriera fino alla qualifica di Office Manager ✅ Lavoro da casa Requisiti indispensabili: - Disponibilità IMMEDIA...
Hi Ahmed Atef Gomma M., I would like to hire you again at your hourly rate (plus tip) to make some changes to the project you completed for me. I added a few more fields, added some tabs, and updated the last tab (xAssets Export). I see you're not online. Hopefully you will be online soon because I'm hoping to have the finished project today. Sorry for the rush. Please let me know if you have any questions.
...way to solve it is to go from a corner of the hypercube along the vector U until you reach the hyperplane (the one with the fourth component equal to zero), or create a mapping matrix which is a four-dimensional oblique projection to the right hyperplane along U (this can be very hard to find, I'm not sure if there is described in any book how to easily calculate such a matrix but it a simple formula exists). Use the vector U = (1, 3, 2, 7). Report the 3-dimensional coordinates that the vertices of the hypercube get after the projection and draw the projected hypercube in a figure with edges between nearby vertices. Remember that there are no edges between all the vertices (use the analogy of a regular cube and figure out between which vertices of the cube there are edges)...
I need to prove that the force of an object will not break a hose. The calculation with the formula must be delivered in Word format. Object mass: 9 kg Velocity: 17 m/s Hose tensile strength 12 N/mm2
Hello, My team and I are looking for an Expert video editor to edit Vertical Short Form content for one of our Projects. The niche is Formula 1 & True Crime, you'd be provided with a script topic and narration, and you would have to do the following tasks: 1. Find clips & images related to the script. 2. Build out a sequence of clips to go hand in hand with the narration. 3.. Add some editing SFX and effects to make the editing more interesting Here's an example of the EXACT sort of editing we are trying to achieve: (I have another previously edited video that I'd like to imitate but I will share it privately in messages) I'm looking for someone who's reliable, who's able to produce at least 5-7 4 minute
I need to find a way to extract the first 10 times each customer used our products and what products they used (their first 10 times). The data set is big and I need a formula for it, but I am not able to find an appropriate formula.
I require someone that can start work this Saturday morning, who can speak English clearly. The work is quite simple for someone with very good Excel experience as it requires work with formula and bulk editing. It is basically editing website names from old to new for e.g to There are couple of thousand urls The person must be 100% Accurate as this is important and English is important to understand the job
Por favor, regístrate o inicia sesión para ver los detalles.
TASK: Create project WPF that used OpenCL NuGet in which need to compare calculation speed for parallelization on CPU cores and GPU cores for jagged arrays of different sizes. ADDITIONAL TASK: Determine if the video card is present. Get data on the number of CPU and GPU cores. PARAMETERS: Variable int i, j, k in range {100;3000} Const in double presentation Input array INP[i+1][j][k] Output array OUT[i][j][k] Formula for(int i = 0; i < valueI; i++) for(int j = 0; j < valueJ; j++) for(int k = 0; k < valueK; k++) OUT[i][j][k] = * (INP[i][j][k] – INP[i+1][j][k])
I need this done NOW. Please don't bid if you can't complete now. Sheet 1-7 contains a column of serial numbers only. Sheet 8 contains a column of serial numbers. Each serial number in sheet 8 contains additional cells of data in the rows next to the serial. I need a formula in sheet 1-7 to look for serial number matches in sheet 8. If it finds a match, I need the cells next to the serial in sheet 1-7 to display (yes or no a match). If a match I need the cells in the same row of the serial to display 5 corresponding cell data from sheet 8 .
Hi, I'm preparing my small firm's quarterly report and need a really simple formula. So, basically my data (input) is like this: Catergory Product item QTY Price product1 test1 1 150 product2 test 2 2 300 And I need to add 3 more row for every product (because of the quarter year) and divide price column with 3 (+ add Colum --> date for each quarter). It should in other words look like this (output): Category Product item QTY Price Date product1 test1 1 50 31.7.2022 product1 test1 1 50 31.8.2022 product1 test1 1 50 30.9.2022 product2 test 2 2 ...
I'm doing a balance sheet reconciliation on a GL account - Estimated Tax Receivables. I have a beginning balance that starts in 2020. I just need like a formula or a pivot table to show me what needs to be billed. Essentially, to see what is pending for me to pay or reverse. I need to see what's giving me that ending balance of $348,852.92.
Baby formula container that can be attached to the bottle for faster milk preparing. I just want the design, not the manufacturing. i have an idea but i am unable to make it into a product. i want someone to translate my idea into design. Looking for someone who is very talented because the idea is a bit complex. I have an illustration but I will share it privately later. No specific timeframe.
i need someone who know formula of excel only excel expert apply dont waste time
Hi, I like to produce an app that switches Arabic letters based on a set of formulas I will provide. There will be two options for two different formulas: - Golden Mean - Servitors For example, if I give the word: اب it will print out غظ Cause ا = غ ب = ظ This is an example and not the ACTUAL formula It should be able to handle and convert bulk using .txt lists.
I'm running Microsoft 365 excel and need help with a formula. I need the formula that will allow excel to automatically past an alpha cell to another worksheet in the workbook when entered into another. Can you help? I'm good with how to do a numerical cell formula, just need the formula that will 'copy and paste' one alphabetic cell into another worksheet. Can you help?
I'm doing a balance sheet reconciliation and i need a formula that'll show me what wasn't reversed or paid.
We are a cabinetry supplier and need help building a stone benchtop calculator that assists our designers in pricing up stone in a matter of minutes. Some formula inclusions and rule application will need to apply when building the calculator.
I need someone that is good with math, stats and data. The person for this project will have the ability to look at current and historical data and determine the likely outcome of a sporting event using a percentage breakdown. For example, based on the raw data, Team A has a 75% chance of winning over Team B. You will create an algorithm where data is plugged in and produce the result for the user. It will be your job to use pure math and science based on the current stats and past performance stats to make this happen. Once you have effectively created a working algorithm, the algorithm and your formula will then be converted to a computer program. If you wish to write to program then that is fine, but we are looking for you to deliver in a workable spreadsheet format ...
Hi, I have got stuck on a Powerpivot task, and need someone to let me know the correct formula. I just want to sum the rows below a subtotal. At the moment it keepts recalculating dynamically. Each row is calculating the mix which is margin - price impact - volume. The issue is that volume is calculated dynamically so a new average unit cost is calculated for all profuct groups when I use the "All" function, where as I just want to add the numbers/rows underneath, using the average unit cost at those levels. So simply I want to add the rows below without it recalculating and working out a new average when I use the ALL function, I have tried Sumx but to do success. I believe for a dax expert this is an easy issue to resolve.
I need a spreadsheet to collect and count catering information over multiple dates organized by pick up times. I have some raw data and I need help organizing and putting necessary formulas / macros together.
I have attached the instructions as well as notes with the necessary formula. The code should be in Python using the Gym library and should be well commented so that I can understand it because I have to defend it.
$20 is the rae for this job I have a spreadsheet with 2 tabs tab 1 "Attendee" has all information in column "T" tab 2 "Postcodes" tab has all the information i want to match Example: When "atendee" column "t" Postcode number matches "Postcode number" in "Postcodes" tab column b - Push "postcodes" tab co...tabs tab 1 "Attendee" has all information in column "T" tab 2 "Postcodes" tab has all the information i want to match Example: When "atendee" column "t" Postcode number matches "Postcode number" in "Postcodes" tab column b - Push "postcodes" tab column G,J,L,Y and AC into "attendee" tab AY, AZ, ba, bb, bc Note...
I need to troubleshoot why this formula is returning the incorrect value. I can provide an example sheet once the job is awarded. The formula in question is: =countifs('PM Capacity'!$A$2:$A$992,$A4,'PM Capacity'!$E$2:$E$992,B$3,indirect("'PM Capacity'!$"&B$1&"$2:$"&B$1&"$999"),"x")
need to create an IF condition in a spreadsheet. it would take about 10 minutes start to finish. I'm not giving more than $5 for this project that takes less than 10 minutes
Poster Project (please see the file name of the photo for your reference) Size for 3 photos should be 30x48 1st picture: The "My Happy Formula" poster is the full lay out but the main product needs to replaced by "Goli Apple Cider Vinegar" product, under the main product in the middle are "Carlson Melatonin 60 Gummies" and "Goli Ashawagandha" (it should be look like it's in the back of the main product which is "Apple Cider Vinegar". The background is the red photo. 2nd picture: The red one is the main photo of this picture. The green photo is the layout for the text, you have to edit it based on the benefits that the Goli ACV have. Less words only. Red photo is the main photo. 3rd picture: Just remove the girl sleeping an...
BASPOALB has created more than 20 templates (using Microsoft word) for nutrition program and also have a formula for choosing the right nutrition program based on certain information we get from our tests. Currently, we do the formula through excel and then choose the template manually and then we insert the details in the template and share it with the customer. In this project, we would like your help to create a webapp that automates the above process. Hence, the webapp should as the user certain information first to choose the right template (similar to the excel sheet) and then asks for the details such as name/date of commencement and insert it in the right place in the template and then produces the nutrition program automatically. There will be also choices for alle...
Need to fetch the market data according to parameters and apply a formula to find a value. This should be done in real time market data. Also such value should be plotted on a chart
if colum l has a certain word in it then colum n = a name I know its very simple to do
Hi Bret C., I noticed your profile wonder if you could help me with an annoying gremlin in my existing Filemaker system. it is a live system, I would like to make a few changes to it, but I would like to tackle 1 of them as a stand alone task. there is an error in a formula / calculation which counts stock levels. do you reckon you could help with this. im in Port Macquarie.
Would like to change the formula calcuation for each time off category to be able to put hours off versus full days
I have used this excel report before and it took 10 minutes for the expert to make a formula. I extract a report from ERP daily, it shows customer payments that have arrived, each customer has a dedicated accounts manager, i want a formula i type into a new row which picks up the customer numbes i.e. 12345 cust 1, 17542 cust no 2, both are Toms customers then places Tom into a new column?
Have a file I need to check if formulas correct.
I am creating a branded bioavailable testosterone calculator for my app. The user enters two values (SHBG and testosterone) and it is supposed to output their bioavailable testosterone ng/dL. I have the sources for the equation below, however I do not understand it. I need someone to simplify this equation and give me a formula so I can plug in the entered input to provide the output. Input: testosterone ng/dl and sex hormone binding globulin nmol/L Output: bioavailable testosterone Albumin is a factor but you can make it a constant by assuming to to be 4.3 g/dL. The equation you provide must result the same outputs as the calculator tool does below. PLEASE DO NOT GIVE ME A MULTI STEP EQUATION. SIMPLIFY IT. I AM LOOKING FOR ONE EQUATION. The calculator can be found her...
I have a table and a field I am trying to pull data from the table to make the table dynamic. I have an INDEX MATCH COUNTIF statement that is working for every tier except the first and I have to change the reference cell there, but this prevents the formula from working on all the other cells. I just need help solving this one issue. I'd like to find a go to person for stumbling block issues one in a while.
