Excel 2008 :: Creating Formula To Convert Information?

May 7, 2014

I am trying to get a grip on my gas n electric bills. My problem is in creating a formula to convert the info I have into the final bill.

The info I have is -: days of use, amount of G n E used, standing charge, price/unit and discounts applicable. For simplicity I have converted them all into a rate per day and £GB. I tried the following formula

:-(standing charge per day * days used)+(cost per KWH * No.of KWH used) - (discounts * days used) / (100) * (94)

This last one is to account for a direct debit 6% discount. I used cell address for things like No of days usage and KWHs used in the period. The values in these cells have themselves been calculated via a formula from other info. The results I get seem to be a constant variable which indicates that I am doing it wrong.

View 3 Replies


ADVERTISEMENT

Extract Information From PDF And Convert To Excel

May 21, 2014

Is there any way to create a specific template that will extract information from PDF file and make it to an Excel File ? The Template would know each PDF and will know which information to extract to excel ?

View 1 Replies View Related

Excel 2008 :: Cannot Open Structure Protected Excel Document

Mar 25, 2013

******** type=text/javascript>*********>******** type=text/javascript src="http://pagead2.googlesyndication.com/pagead/show_ads.js">*********>

I tried locking an excel document and i ticked a box that said protect structure, and then entered my password and now I cannot open the document. It is a white square on my desktop now with no options to do anything, it cannot even be attached to an email or deleted. This was on excel 2008 on a macbook.

View 1 Replies View Related

Excel 2008 :: Opening Asp Files?

Nov 7, 2013

I have Mac 2008 Excel. For my work, I download .asp files and open them in Excel. No problem. The problem is... I'm wanting to use another computer at work that has Mac 2011. When I open the exact same .asp files, they show coding (html?). I can fix this by changing the name of the file extension from ".asp" to ".xls." But I convert these files a lot during the day and this is an extra step I don't want to take. And it works fine in version 2008. So what can I do in version 2011 to make it open the files without all the coding?

View 2 Replies View Related

Excel 2008 :: Pulling Data From On Sheet To Another

Apr 3, 2013

Expand the explanation for the previous thread? [URL]....

I am trying to do basically the same thing, I have a long list of clients and need to separate them by date they contacted us. I am using Excel 2008 on a mac, which does not allow micros. the previous thread does exactly what i need to do, but i cant get it to work.

View 2 Replies View Related

Excel 2008 :: How To Add Data Labels For Scatter Plot Coming From 3rd Column

Jul 29, 2014

I'm using Excel 2008 for Mac & cannot figure out how to add a data label to an XY scatter plot that comes from a 3rd, separate column.

I have 3 columns of data: (A,B,C)
Labels, X values, Y values

When I select the Data Source for the Chart, there is a greyed out box for Category X axis labels, which is where I remember such information going in PC versions of Excel I used to use.

From the formatting palette, the only options to select for labels add the values of column B, but I need the reference from column A.

I'm not familiar with macros or visual basic. How to add these labels? This is Mac, Excel 2008.

View 3 Replies View Related

Convert Vba To Excel Formula

Jul 5, 2012

I want to convert code below to excell formula

VB:
Sub Fonksyon171819()
Dim total As Double, i As Integer
total = 0

[Code]....

View 4 Replies View Related

Convert Excel Formula To VBA

Feb 14, 2012

Here is the excel formula that works fine. =INT(EXP(.0003*POWER(x,2)))

View 1 Replies View Related

Creating Macro Which Replicates Excel Formula

Apr 1, 2014

I have created the following excel attached which gives me the results I require,

However I am wondering is there any possibility I can get the results produced via VBA as it takes to long to calculate with formulas

View 1 Replies View Related

Excel Formula To Convert Time

Nov 18, 2011

I Excel formula to convert time to seconds. For example:

12:05:00 AM Expected asnwer= 300.

View 3 Replies View Related

How To Convert Excel Formula To VBA Code

Jul 4, 2012

(1) =round(if(bran!g1="raw",if(bran!n1=$f$19,(bran!p1/$g$19)*(bran!n1-$g$19),if(bran!n1>=$f$20,((bran!p1/$g$19)*($f$19-$g$19))+((bran!p1/$g$19)*(bran!n1-$f$19)*2),if(bran!n1=$j$20,((bran!p1/$k$19)*($j$19-$k$19))+((bran!p1/$k$19)*(bran!n1-$j$19)*2),if(bran!n1$f$25,bran!j1*$h$25,if(bran!o1>$f$26,(bran!o1-$f$26)*bran!j1*$h$26,if(bran!o1$j$25,bran!j1*$l$25,if(bran!o1>$j$26,((($j$26-$j$27)*$l$27*bran!j1)+((bran!o1-$j$26)*bran!j1*$l$26)),if(bran!o1>$j$27,(bran!o1-$j$27)*bran!j1*$l$27,if(bran!o1

View 1 Replies View Related

Creating A Form And Storing Information?

Dec 14, 2011

This challenge may be better handled in Access or a true database but the person making the request only uses Excel.

1. Create a form that will accept names, dates, and grades.

2. Store the information on a separate worksheet so that it's being accumulated and reports can be ran from it.

I'm aware of Excel's automatic form but it doesn't allow for validation.

Example: some score ranges are 0-5 others are 0-15. We can't allow for a 12 to be put in where the max is 5.

I know how to do the validation. The big challenge now is telling Excel: I've completed entering this record. Now clear, and start a new record on the next row?

View 2 Replies View Related

Taking One Cell Information And Creating Two

Jul 28, 2014

I have a userform that searches a data base for an address an pulls up the corresponding information. I was wondering if there was a way to get it so that if I put 1234 5th Street when it puts the information into the data base it would separate it into two cells so 1234 would be in one section and 5th street would be in another.

View 1 Replies View Related

Creating A List From Several Sheets Of Information

Feb 19, 2007

I have a wb containing several sheets that the field supervisors use to fill out for ordering material. Each sheet contains different types of material. The problem is that, if they only need one particular item from each type (sheet), they have to print 7 or 8 sheets just for those 7 or 8 items. I want to create a sheet that will list everything they are ordering in one compact, neat area, so they only have to print one sheet.

The set up of the sheets goes like this. There's a column containing the name of all the items. Next to each item is a place they can specify how many of that item they want. They leave it blank if they don't want any. That's it. Really quite simple.

So now, I need this new sheet to find all the cells that a quantity was entered on the other sheets, and list that and the description of the item wanted, along with what type of material it is. I have figured out one way of doing it, but it would take a crap load of hidden IF formulas, and I know there has to be a simpler way. I'm open to all suggestions - whether it's vb codes or formulas, it doesn't matter to me.

View 9 Replies View Related

Excel Formula To VBA Code Batch Convert

Jul 22, 2014

I use a software to find relationship between some variables. this software can export results (excel mathematical formula) to a text or excel file. I need use this formulas in my VBA codes. but I should convert about 100-150 formula each time, hence this is very time consuming and hard to do that manually. I wondering if there is any macro code or third party software for that?

excel formulas are like this:

VB:
=((1/2)*((((EXP(EXP(EXP(-0.00159049260456001*$A1)))+2.36277505628942)/(LN(1.34876400300668*$B1))+(1/2)*((13.8900474312246)+(EXP(2.22254189839997*$C1)))))+(2.56256412775789*$D1/((1/2)*((1.34876400300668*$B1)+(EXP((1/2)*((EXP(-0.000633515788838835*$E1))+(-15.3575339156491)))))*(-15.3575339156491-1.31506071323009*$F1*EXP(EXP(2.22254189839997*$C1))))))*0.00300997948851126+-0.00736105020728091)

View 5 Replies View Related

Creating A Source Sheet To Pull Information From.

Aug 17, 2007

I'm trying to do is create a macro that will autopopulate information from a source sheet. What I have is a different route sheet for 25 or so technicians within my company on one worksheet.

I want to be able to have a source sheet that I can change daily and have it autopopulate the information needed into the appropriate cells/sheets from this one source sheet.

I am pretty sure there is a way to do this, but I'm not familiar enough with creating macros to do this myself, although if I had an example of one cell and a simple explanation of how to fit this to the information needed I think I could do this on my own.

View 9 Replies View Related

Creating New Worksheets Based On Information From The Master

Jun 14, 2007

I have a spreadsheet that I am trying to use as the 'master'. I want to break down this master by category (Column D) and label the worksheet by category (AA, Code, SQL...)

I need for the code to search the D1:D500 column and find "AA", "Code" or "SQL" and place the entire respective row on each respective worksheet. Then sort by colmn E. There are columns a:h that need moved to each sheet.

View 3 Replies View Related

Convert 1 Column Of Information To 3

Jul 25, 2014

I have an address list that I need to convert to 3 columns. How do I do this?

View 3 Replies View Related

How To Convert String To Excel Date Format Using Formula Or VBA

Sep 28, 2012

Is there a way to convert the string "Sep 28 2012" to excel date format using a formula or vba?

View 8 Replies View Related

Creating New Sheets With Macros Based On Column Information

May 9, 2012

I am new to using Macros and have not had great progress building a macros to make my life easier.

What I am trying to do
-In my main database tab 'FW Telecom' Use column A ( a set of numbers) to create a new tab based on that number, with a 'FW' infront IE ( column A shows 11, i want the tab to read FW 11)
-I want to create one for every number in the column
-Then I would like to copy my 'Template' tab to each new tab.
-From there I would like to fill in the information in the new tabs from the main database tab 'FW telecom'
-Since they will all be copies of the original template, i figure i can just get it to pull from the first column A and then fill in the info.

Not too much in theory going on here, just take my database and move the pertinent information to a user friendly look which I set up in 'template'

View 6 Replies View Related

Excel 2007 :: Convert VLookup To Match And Index Formula

Sep 21, 2012

HTML Code: VLOOKUP(M2,'FX Rates'!$A$1:$P$199,2,FALSE)

I have lots of vlookups in my spreadsheet. Match and Index is a better method and should speed up my spreadsheet (1000s of vlookups!).

View 5 Replies View Related

Creating Macro To Convert Formulas To Values On Data Sheet?

May 16, 2012

I am creating a Macro to convert formulas to values on a Datasheet after each entry from a form (worksheet) is carried over. Since each entry will go on a separate row I created formulas to give the new datas location. I just can't get the syntax correct for it to run.

Sub Convert_Formulas_to_Values()
Range("Reviews!$B$202").Value: Range("Reviews!$AF$202").Value.Select
Selection.Copy[code]....

View 4 Replies View Related

Creating A Yearly Database File Using Information In Daily File

Feb 7, 2008

I would like to automatically update a 'yearly' database file with info from a file that is changed on a daily basis.

The daily file that i use has info like date, truck number, delivery stops, weight.

the database file has the similar headings.

at the end of each day this daily file is saved. I would like to have the info that is entered into the daily file automatically plugged into the yearly database file into the next available group of cells with respect to the salesperson.

This is kind of a generalization but i'm hoping to just get pointed in the right direction. If something like this involves vba then it will be beyond my ability and i'll have to do it manually, which is fine

View 9 Replies View Related

Creating Form: Fill All The Information Across That Row Into Other Boxes On The Form

Nov 5, 2006

I need to create a form that if you were to enter a name in the text box it would fill all the information across that row into other boxes on the form. Basicly if I type John Doe in the text box it would look in col A for John Doe and then put whats in the cells on that row into different boxes on my form. I have tried searching but I have had no luck. Im very new to forms so this is a great experience.

View 3 Replies View Related

2004 VBA To 2008 Apple Script

Oct 17, 2008

I would like to convert them to AppleScript so I can use them in Excel 2008.

From what I understand I should be able to do this with AppleScript, but I have never used it before and have absolutely no idea what I am doing.

Not only do I need to know how to convert the VBA to AppleScript, I need to know what to do to make it run in Script Editor, etc.

There are two VBA Macros, each is to highlight a specified cell range, then turn on cell protection.

It is my understanding that although I couldn't record this into my VBA Macro, AppleScript will also let me unprotect the worksheet at the beginning of the script, and then re-protect it at the end of the script.

View 8 Replies View Related

Placing The Date (1-JAN-2008) In The Right Column For DAY

Nov 8, 2008

Placing the date (1-JAN-2008) in the right column for DAY

Now I have a Matrix in which I have the Days as Colum Headings and the Week Numbers as the Rows.

I will be mentioning the Date let's say 1-JAN-2008 in the Cell A1 and I want this date to appear in the approriate Column for the DAY
For Ex:-

The day for the date 1-Jan-08 was a Tuesday, therefore the date should appear in the Column having a Heading Tuesday and in the Column Monday it should show as 31-Dec-07 and the Columns for Wednesday,Thursday,Friday,Saturday and Sunday the Following dates after 1-Jan-08 (i.e. 2-Jan-08, 3-Jan-08, 4-Jan-08, 5-Jan-08, 6-Jan-08).

The appearance of the Date should change as per the day-date combination and as such for the preceding as well as following dates..

Ex:- Lets say for 1-Jan-09 which comes on a Thursday it should display (1-Jan-09) under column Thu and Mon,Tue,Wed should display ( 29-Dec-08,30-Dec-08,31-Dec-08) and Friday,Saturday and Sunday the Following dates after 1-Jan-08 (i.e. 2-Jan-09, 3-Jan-09, 4-Jan-09).

View 3 Replies View Related

XL 2008 Pivot Table Refresh

Jan 17, 2010

I am running XL 2008 on a Mac and have created a pivot table that works well. However, without VBA (and I don't know how to write in Applescript), is there a way to put a REFRESH button on my spreadsheet?

View 9 Replies View Related

Display A Table Created In 2008, In A VBA Form

Jan 19, 2009

I created a table in excel, using it's Table feature, the first column has A - J, the second column has 1 - 10,

I then created a VBA form in VBA6,

How do i display that table and its 2 columns in a VBA form?

View 13 Replies View Related

IF Function Inform If Person Worked Over 6 Months In 2008

Feb 1, 2009

I have attached a worksheet that shows the last and first name of an employee along with their hire date and term date, if termed. What I am looking for is a function that will tell me if a person was active as of 12/31/08 which will read true on the side of their name under active; I also need a function that will tell me if a person worked over 6 months in 2008.

The first person John Doe was hired in 2005 and has a true on the side of his name which meant that he was active as of 12/31/08 but as you can see Jane Doe has true on the side of her hire date and false on the side of her term date and I don't want it to read the first true but the last true of someones name, but Jane Doe qualifies for working over 6 months even though she started in 2007.

View 7 Replies View Related

Turn On View Vba Code In Apple MAC Office 2008

Aug 19, 2009

how i can turn on view vba code in Apple MAC office 2008.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved