Calculating Shipment Rates Base On Origin City And Destination City?
Apr 4, 2014
how to match a series of rates for a destination city depending upon the origin city. I have figured out how to match rates from origin city to multiple destination cities but have not figured out how to change the series of rates when the origin city changes. These rates will be calculated on the "calculator" in the excel document depending on the cities chosen.
I have attached a document that shows a simplified version of what I am trying to do.
View 2 Replies
ADVERTISEMENT
Jan 30, 2014
I have a large database from a central appraisal district. In the database the city is stored as a numerical value. The problem is I need to convert the numerical value for the city to a text string with the actual city name. For example the values to the attached example database are as follow:
excel help forum 2.xlsx
024 = Hurst
026 = Fort Worth
025 = Euless
017 = Mansfield
013 = Keller
The issue is, I need to convert this column of numbers into the string of the actual city name. Is there some type of command, or macro that I could use to automate this process? Attached is a small example copy of the database.
View 13 Replies
View Related
Sep 5, 2013
I have
Userform
Textbox1
Textbox2
textbox1 containing the province
textbox2 containing the city
If didn't click any value of province the city textbox2 don't have any value and if i click the one of the province the city will now have a value . Is that possible
Here is the picture : [URL] .....
View 6 Replies
View Related
Aug 5, 2014
Data validation using named ranges as countries are listed multiple times and to relate country with cities.
How can i relate country with city in two different columns(named ranges) not in order.
Formula to be used for Data Validation would be useful.
Sample data file is attached.
Its just a sample.data can be for 250 rows.
Book1.xlsx‎
View 2 Replies
View Related
Dec 3, 2013
I have an excel of around 20.000 entries and I need it completed tomorrow for work There is the address in one column, and I need to copy and paste only the city to the next column. Any formulas I tried return an error. The city can have one or more words and it is usually after the zip code. For Example:
PLACE DE LA FONDUE 04360 MOUSTIERS SAINTE MARIE ----> MOUSTIERS SAINTE MARIE
19 AVENUE DE MESSINE 75008 PARIS ----> PARIS
160 BIS RUE DE PARIS 92100 BOULOGNE BILLANCOURT ----> BOULOGNE BILLANCOURT
25 SQUARE DE MONT-LOUIS 95380 LOUVRES ----> LOUVRES
View 5 Replies
View Related
Sep 8, 2009
I have an address field that is concatenated as such that the city name is attached to the end of the street name as follows:
4 Example WayOakland, CA 94601
I have over 200 of these with different addresses and cities in my workbook so it's not always the same length. How can I grab the city out of this string? Is there a way to key on the capital letter of the city? Or is there another way?
View 14 Replies
View Related
Apr 11, 2008
to automate a process that split name, address, city, state, and zip.
here are the examples of name, address, city, state, zip that i would like to be split in each column. this is difficult because the datas are not consistent and not predictable in how it WILL BE GIVEN....
View 13 Replies
View Related
Apr 12, 2008
I believe many people face is to automate a process that split name, address, city, state, and zip.
here are the examples of name, address, city, state, zip that i would like to be split in each column. this is difficult because the datas are not consistent and not predictable in how it WILL BE GIVEN....
View 9 Replies
View Related
May 8, 2007
I need something that will count the number of rows with the same city name in column c, and then show that count in the first row of that range in column f. thx
View 6 Replies
View Related
May 2, 2008
I have a column that has data like this in it:
cityname, stateAbbreviation, XXXXX
or
sacramento, CA 95814
The tricky part is that sometimes there's a comma delimiting these fields and sometimes there is just a space between these fields.
So, I suppose the script would have to assume a length of 2 chars for the state and when it finds that it knows that what was before that string of 2 chars was the city.
Also, sometimes there is a longer zip with 10 digits code like this:
cityname stateAbbreviation XXXXX-XXXXX
sacramento CA 95814-82202
How might I write some VB code to loop through this column and break up this cell into 3 other cells?
View 7 Replies
View Related
Mar 31, 2014
I have a spreadsheet of over 8000 addresses. I have the street, state and zip but not the cities.
Is there a way I can do a search and mass import of cities from a website, like USPS? I'd like to know if there is something I can do quickly rather than manually look each zip code up and enter it in one by one.
View 2 Replies
View Related
Jun 20, 2013
I want to sort all of the "column2" by alphabetical order. The order will be first by state and then by city. For example the first box the column2 order should be (Fountain Hills, AZ) properties first followed by (Mesa, AZ) properties second followed by (Peoria, AZ) etc.... ending with (Flower Mound, TX) last.
The issue that I'm having is that when I create a custom sort the comma after the city indicates a new value being AZ. For example my custom sorting looks like this: Fountain Hills, AZ, Mesa, AZ, Peoria, AZ. This is limiting my ability to sort the files as is with city, state. I solved this issue by removing the commas after all the cities. This worked but was time consuming. Is there a faster way? The workbook is below.
Development Projects Mr Excel.xlsx
View 2 Replies
View Related
Jul 16, 2008
I have list of various city names in column B. From that i need unique city names in validation cell.
The reason is,
we have emp id, name, designation, area, marital status for our employees. From that if i select emp id from validation cell1 i have to get all employee id's available in the sheet1 is need to come under the validation2 cell automatically. and if i select "area" from validation cell1, all unique areas need to be list out in the validation cell2. Its look likes a filter. but without filter i need this for creating application.
View 9 Replies
View Related
Aug 28, 2008
I am almost done with form I have been making and so far this forum has been invaluable.
My last hurdle is this:
I have a list of Tax Exempt Customers that when thier name is entered into the form, I would like it to not add tax.
I have tried a forumula like this:
=IF(CustName='CustTaxExemptList'!D2:D27,"Exempt",(=VLOOKUP(qtProjAddress3,'City Mileage and Tax Rates'!A2:C702,3))
The above formula does not work, but I dont know why. I want it to lookup the city tax and add it in if the customer is not on the tax exempt list.
View 9 Replies
View Related
Nov 21, 2009
i am trying to figure out, how to automatically update time, based on specific city's time zone? Lets say, if the city is dallas, time zone is Central GMT-6. In the next cell, the time shows up as Dallas's local time, instead of local computer time. And this time updates itself after every 2 min.
2ndly, if that city's time is later than 8:59 PM local time, that specific city's cell grays out.
Attach: Snapshot of sheet
View 14 Replies
View Related
Jan 30, 2014
i have an excel spread sheet (2010) that contains city, st and zip in one cell. i need to separate these into 3 individual cells. My problem is the some of the cities are one, two and sometimes 3 words so using a delimiter of space will not separate them correctly.
View 4 Replies
View Related
Apr 3, 2009
heres the data: [url]
Im meant to produce a simple spreadsheet that calculates the floor area of a new build city centre hotel. The developer is looking at various plots of land that allow differing sizes of floor plates and storey heights. The key variables are the number and type of bedrooms, number of floors and whether the hotel is classed as a premium or budget hotel.
I need to produce a spreadsheet that shows the key variables and the total calculated floor area at the top of the sheet.
View 14 Replies
View Related
Dec 5, 2012
I have been researching this for 3 days and I cannot find a solution. I have City, State information in A1. I also have City, State information in B1. I need to put them into City (D1) and State (E1).
View 4 Replies
View Related
Jul 20, 2006
I have three columns. The first column contains a certain category ( i.e. Cat 1, Cat 2, ect.), and the second and third columns contain numbers referring to that category:
Ex:
A1 B1 C1
Cat 1 6 5
I want to be able to find the success rate (C1/B1), but I want Excel to recognize what category it belongs too so I can split the success rates into categories in a different location. What function, if there is one, do I use, and what information do I need to plug in.
View 8 Replies
View Related
Oct 14, 2013
I am trying to create a booking calculation sheet for facilities. I want it to create something like a quote for customers. So when booking facilities, the hourly rate changes after 6pm. What I want to do is to put in a start time and a finish time and it calculate how many hours are before 6pm and charge them at $12 per hour, as well as how many hours after 6pm and charge them $18 per hour. I have tried a few things but they don't seem to work. I'm struggling with the logic of it really. This is mainly because the start time may or may not be before 6pm, as too the finish time.
View 6 Replies
View Related
Feb 28, 2008
I have US money supply data, arranged monthly from 1975-2008. I need to calculate the monthly growth rates. I would really appreciate some help as I have no clue how to do this.
here is a link to a text version of the data I am using: [url]
View 9 Replies
View Related
Jun 20, 2014
Never tried complicated formulas in Access and at a bit of a loss... What I am trying to do is calculate a utility bill based on stepped rated.
For example:
Usage up to the first 500KHW is billed at .067 per KWH
Usage after the first 500KWH from 501 to 999 is billed at .044 per KWH
Usage from 1000 up is billed at .0318
So if my usage was 1200 KWH...
((500 x .067)+(500 x .044)+(200 x .0318)) = 61.86
I was assuming it would require an complex "if" function to split the 1200 into steps and then calculate charges per step?
View 9 Replies
View Related
Aug 15, 2007
formula is needed to get excel to calculate all A rates seperate from B rates and C rates example 10 A rates @ 50.00 9 B rates @ 40.00 and 6 C rates @ 30.00 so although the rates could be mixed up (not following in any particular order the result which I would like to appear on a separate spreadsheet would be A = 500.00 B = 405.00 C = 180.00 then to get them to total up = £1085.00
A 50.00
B 40.00 then separate sheet with answer a 100.00 b 40.00 c 60.00
A 50.00
C 30.00
C 30.00
View 9 Replies
View Related
Apr 14, 2013
I want to fill all a column bottom-up but without specify cells in format "A1500:A2" like
VB:
Range("H1578").Select
Selection.AutoFill Destination:=Range("H2:H1578")
{H1578 have a formula so...}
I have data in the first 7 columns, with a variable(Range) for the first 5 columns
VB:
Dim oRange As Range
Set oRange = ActiveSheet.Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(89, 4))
{The first cell in it is A1}
My question is : How to fill Range("H2:H1578") using my ''oRange'' variable?
I try with OffSet but my code didn't work. I need to do the same with the 6 columns to the right and then plot in a chart.
View 4 Replies
View Related
Aug 18, 2014
I want to split data of a shipment into multiple rows, based on the a standard pallet quantity
E.G.
1) SKU: 807020450043BATCH: 41826790QTY: 15600
(PALLET QTY 1560)
2) SKU: 807580450044BATCH: 41452190QTY: 5760
(PALLET QTY 576)
I want to split the row by the pallet qty, will result in 10 rows of 1560 / 576 Data will look like this
8070204500434182679015600
807580450044414521905760
View 3 Replies
View Related
Feb 20, 2014
I am about to apply for an entry-level job as a scheduler for a company that ships olive oil. But before I decide to actually do this I'd like to see what I'm getting myself into.
It is how Microsoft Excel is used to schedule shipments, monitor inbound shipments and keep track of inventory.
View 1 Replies
View Related
Nov 28, 2008
I have a pareto chart(Bar & Cumulative Line Chart) that I would like to have the line orginate at x = 0 & y = 0 without changing the position of the other points on the line chart.
Basically this is for better visual appearance. When I add a 0 to the table, it skews the alignment of the line chart with the corresponding bar chart.
View 7 Replies
View Related
Dec 3, 2009
I have a list of IPs that have attacked a certain site over the past year. There are 3000 different IPs, so I would like to automate this. Is there a way to code a lookup on an IP to match its country of origin? ....
View 6 Replies
View Related
Jun 24, 2008
i have a bunch ofdaily rates back from 2005. sometimes ill have one or even 2 or 3 missing rates in a row. when there is a blank rate, i just want excel to calculate the average of the date below and the date after. right now, ive just been going manually to each missing date's rate and calculating the average.
View 9 Replies
View Related
Mar 27, 2007
I am trying to create a conditional formula. I have multiple workers that work for different $$ per hour. I am keeping the hourly rates on one page for security purposes (the person that is going to be updating the hours worked is not very computer savy and they less they have to type the better) and the hours on another... I want copy a formula down the page that will calculate the hours to the hourly rate. The issue is that i want the formula to look at all of the hourly rates (assume they get raises) for Joe and multiply the most recent hourly rate times the hours... in addition I don't want the formula to re-calculate when a new hourly rate is put into the hours sheet.
Example
Jan. 1 joe works 8hours at $10 per hour formula in A1 (or wherever) calculates $80
Jan. 2 joe gets $1 raise
Jan. 2 Joe works 8 hours at $11 per hour formual in A2 calculates $88 but formula in A1 maintains the $80 and does not calculate the $1 raise.
View 12 Replies
View Related
