...have a excel sheet file from Bloomberg that we need to extract the formula from and apply this formula to build charts in Python/Django project. You will use Highcharts to draw charts from the daily prices of assets fetched from Bloomberg into Django backend DB after applying the formula from the excel file using Pandas library. I will give more details
We do epoxy flooring, and currently we use an excel spreadsheet to work out what it will cost to do the work. However as more people begin to use it, it becomes tricky as some of the formulas can be deleted, and you can't tell when another person is using it. This calculator essentially carries all the information over to another page called Proposal, and from here we can send to the client a...
We need a small project completing.... i believe it involves "VLOOKUP" and will simply copy data from one spreadsheet in to another. Spreadsheet 1 will reference a customer code. We need to look up the customer code on Spreadsheet 2 and copy certain columns (address/client name etc) from Spreadsheet 2 and put in to Spreadsheet 1.
need a vba script where depending on brand name in column can match to email of company
Need to include logic to existing formula in column AD in attached spreadsheet, where if a horizontal cell in column AC is >61, then to reset my COUNTIF formula in column AD to 0, otherwise leave as is
A system that generate the all structural formula from its string formula(C3H8). After that get stable structural formula(most accurate nomenclature) from them. Normally, when considering C4H6, it can draw 3 separated structures. Need to get all structures from a molecular formula. Use python and need to use Rule based method. Skills -Rule Based Techniques
We are looking for a environmentally friendly dish washing formula. This has to be easy to produce, the ingredients must be available at reasonable prices within the EU. Cost to produce and effective product are key in this task
Hello, im using excel 2016. me and my colleuages are working on an identical file(we make copy of the file for each one of us every morning) but we are putting data in different row and colums of the file. After we are done , we want to conbine all this information together into a master file and keep the formating of our files. Does anybody knows how to do it? its a daily job that i have to do.
I have a Google Sheets file that I need a formula for. Please see the attached images. I need a formula that will copy the data on the sheet labelled "All Ongoing Cases" and put it on the correct sheet depending on the value in Column "I" For example you can see that the data in Rows 3&6 has been copied to the "DIP ACCEPT" sheet because in Column
Hi. I need an Excel formula that can be used to calculate the number of 20 second increments per row. Attached is an example of the spreadsheets we use. There is a Duration column (F) in the spreadsheet. The values in that column are seconds. Example below: 1 second - 1 7 seconds - 1 20 seconds - 1 21 seconds - 2 35 seconds - 2 40 seconds - 2 41
I am an Australian manufacturer of infant formula. I would like to establish sales in overseas markets. I am looking to structure the business on a commission based agreement. Our products are of a very high quality and available immediately in orders of 20,000 x 900g tins per order.
I am a true believer in putting only organic ingredients in my hair. My hair has improved in strength, lengthy and...improved in strength, lengthy and hydration. I would love to help other women to experience the same with their hair. I am looking for a chemic engineer to help me come up with a formula to help with a longer shelf life for the product.
OK so basically i'm collecting data for fails at work for example if person 1 has 8 fails the whole row will turn red if person two has no fails they be green and if they in the middle of the numbers they will turn orange
I need this formula within 24 hours of awarding the project and it had to be compatible with Google Sheets. Using Google Sheets, I need a formula to work out the following: In one cell, if the number entered by the user is 240 or below, I need the formula to state that as 'Low Risk' Anything between 241>600 would be categorised as 'Medium Risk' Anythin...
...that Footway only has to fill out the campaign offer, and your great spreadsheet formula will deliver copy in all languages. We have the static words already in each language. You only have to create the best solution for this. The best idea and or spreadsheet formula will win this contest. Provide your idea as a pdf and the best idea will win.
Want to Modified my Existing AFL,
Excel work required for a spaceframe project. Since this spaceframe structure (ellipsoidal dome) is complicated and consists of various pipes and spheres, we need to sort this material out level by level. Looking for a way to extract this data from this table and exclude it from future results with same reference. Reference to extract specific data level by level will be provided my me. Please con...
I have a large sheet, that I need to sum totals. Only way I currently know how to do it will be to many =sum(A#:C#)+(A##:C##)+(A###:C###) etc, but like a thousand times. I have basic "SUMIF" knowledge, but I don't really know how to carry it forward since I've updated my sheet.
I have a spreadsheet that I can't figure out how to make a formula for. Video explainer attached as well as excel spreadsheet. Basically, I need the formula to: Look at 3 cells If value in any of the cells is greater than 0 Multiply by "Rental Comps" based on: field value (1 bed, 2 bed, or 3 bed), and zip code If value is greater than zero in multiple
Hi, I urgently need assistance with an advanced excel formula which can classify 1. Gross Margin $'s and 2. Gross Margin %'s into classifications. The classifications are: Classification 1: Gross Margin $ above $500,001 and Gross Margin % > 20% Classification 2: Gross Margin $ $200,001-$500,000 and Gross Margin % > 20% Classification 3: Gross Margin$
Please refer to the enclosed file for details. We like someone to suggest simpler formula based on requirements set out in "Before" tab. Also he will help us incorporate the formula in the "Formula to incorporate" tab. Let us know if you are confident in tackling the task.
I want to formulated a attachment. Wheres, A sheet name Sample, there is I need a formula which make me help to do work fast and easy. I need a perfect work if you can send me a sample file so Please send so i can understand that you understood what i need to do in this Excel file.
We want the formula for floral wet foam with the phenolic resin. We need a special floral wet foam for our product. We want the formula, mixing chemical parts, and ratios to make the floral wet foam
We need someone to create formula to calculate price for blinds. Formula is: width x height /1000000 x unit price. All we want to do is enter unit price and formula should do calculation. We can work with Excel, open office spreadsheet or Numbers app. We can use any software as long as formula works effectively. When done it should look like photo
I'm creating this database on Google Spreadsheets: https://docs.google.com/spreadsheets/d/1nzH5ZzVL-nsrI3T6JTRF3JsfLdtSbegvJ8vgCREofXA/edit#gid=0 I need a formula which allows me to create column A and column B based on the information obtained in columns C and E. Each row has to look as row 2.
Hi - I need some help building an excel formula that pulls fields based on multiple criteria into a dynamic list. Another freelancer was able to develop one using Nested Ifs but I'm unable to use the * wildcard with If statements. This is a critical requirement and Iam open to your solution. Target price is $20 SGD The work done by the previous