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
Program to Scrape Web Site and create Magento import XLS/CSV import file Program to scrape website and create Magneto import file Input: 1) Web site [login to view URL] 2) PriceList Export File. Only rows with “SONY PROFESSIONAL” in column “MANUFACTURER” – <B> to be processed 3) File with additional UPC codes and Product weigh...
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.
Hello I need a simple script/program/solution for windows which compare two spreadsheets via column A in both files. If column A in spreadsheet 1 contains values which are not in column A in spreadsheet 2, then it outputs these values (with all rows for that column). A spreadsheet can contain 3-5000 values. Simple project/Script - If in doubt ask first before bidding.
I have uploaded here a .csv excel file in which a program needs to be developed. It contains approximately 17 series of data e.g. column A to G represents 1st series, column I to T represents 2nd series and so on. There is a(one) column gap between each series. First series A to G and last series GW to HC need not be done anything. Programming is
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
I need to get output as the structural formula from its string formula(C3H8). Normally, when considering C4H6, it can draw 3 separated structures. I need to get all structures from a molecular formula. After that need to get most accurate nomenclature for the organic compound. Need to use python for that and need to use Machine learning or Rule based
Hi - I need some help building an excel formula that pulls fields based on multiple criteria into a dynamic list. I think the formula should be some combination of INDEX, MATCH, LARGE but am open to your solution. Target price is $20 SGD The criteria for the dynamic list is shown in C4:C12 of the attachment. The formulas for the dynamic list list
I need a Excel Formula to look into certain data and give me the Range beginning and Ending Cell References. Basically it will look for blank Cells in the data, and when it sees one, the Formula will give me the Cell Reference that the Range ends there. and a new Range starts: Cell Reference. I have attached an Excel Sheet clearly showing what is
So the just of it is that on the sheet titled BLANK PIPELINE FOR DEALERS I’m trying to have the sheet auto-populate columns K and L when the user selects the “products” from a dropdown list coming from the sheet titled RMC Price List.
I have a spreadsheet that we are going to use in a website for an end user to select a per-engineered kit. They will have multiple choices to make and based on their answers, it will select a kit and tell them what kit to use and the price. Ii need a quick turnaround (hopefully today) on to write some formulas for me. have the layout. It consists of 3 steps: Step one, select one of 3 choices, s...
Here is the link - Form Creation Complete form data needs to be exported to CSV format upon completion. Once the user register himself he should be receiving a SMS & Email with his Registration ID ( Unique ) and a email to the admin with all the form information in it. The field title would be in english and hindi. It has to be same as the original
I have CSV exports of products from Adobe Busines Catalyst I need a tool or script or plugin that will alter the Adobe Busines Catalyst products CSV export Into a WooCommecre CSV file for import without errors. I can manually download and upload images The import must take into account for each product: All categories including multiple categories
I need the development of AFL code on the logic I have in mind but unable to piece it all together meaningfully. Have most of the requisite indicators and have a clear understanding of buy and sell logics. Need some professional coders help in piecing it all together and build a scanner/explorer for the same.
Need help formatting excel spreadsheet and adding formula for discount
I'm the founder of a start-up cosmetic line that specializes in hair care products made from naturally-derived (i.e., non-synthetic) materials. We are in the product development phase, and we're looking for a cosmetic chemist who can take our formulas and description of their pros and cons and provide alternative/corrected formulas. The consultant will work directly with me, and will be ...
...would allow us to implement a formula so that we can enter the data in a CSV format from one file and the formulas will put the data in the set fields to the format we need to upload to Linnworks. We need it so that this CSV file can be reused in future by ourselves and we can drop the data in to one field and the formula will organise it in the way
I will provide almost 1000's series numbers. You have to find the formula or algorithm from this series.
We import csv files to TablePress from various AWS S3 buckets. We need somebody who can write a custom importer that will run as a cron to import all csv files (daily) from various S3 buckets (one per bucket).
HI, We need convert a XML database to CSV. In the database there are 1761 article. (see attachment) We need all the attributes in separate columns. (example in attachment) for each product code(SKU) XML in the zip see also attachment Who can help us out? Gr. Laurens
...ability for a user to enter information within a CSV file, upload it, then have our application automatically create an online web form based on the info provided by the user (e.g. form field type, form field selections, etc.). Hence, instead of having to manually create an online form, they can upload the CSV file which contains all of the required info
I have one system which generates some numbers when data is feed in to.I would like to decode the formulas used.I would just give an example of input number with generated output numbers.I want to know what logic is [login to view URL] is related to may be mean,averages or standard deviation [login to view URL] if you have these skills ,then you are hired with your reasonable terms.
Need a software or formula (via excel, etc) built to be able to provide simple performance reporting for investment accounts. Looking for a time weighted return provided at a customizable date range. 1 month, 3 months (quarterly), year to date, year over year inception (start) to date OR a customizable data range of my choosing. Also need to be able
I need a formula in which the following In the table (C2:I44) have entered in client name (list K2:K27) In cell L1 the output shows the day and time of the clients booked in schedule eg : Client A: Session 1 = Monday 5:00am, session 2 = Wednesday 7:00am, Session 3 = Friday 5:20am Client B: Session 1 = Tuesday 5:20am, Session 2= Wednesday 5:20am Client
HI, I require a simple spreadsheet created with only a few values, however, one which is tricky. I have attached a rough draft of the spreadsheet which indicates in the comments what is to occur. Please note, I require the spreadsheet to look much more professional then the one attached. Please do not provide a quote until you have read and understood the requirements as per attached spreadsheet...