Meter Reading Calculator Based On Date

Jul 17, 2009

As part of a project, I need to come up with a meter reading calculator. I start of with 3 base meter readings (A2, F2, K2), which would be read from the meter. 3 reads are needed in case the consumption changes dramatically at some point. I then need Excel to work out the reading for dates in between. The formula needs to be dynamic enough so that I can change any of the grey dates to what I want.

The estimates need to be calculated using an average daily consumption. This figure needs to be displayed in D9.

It would be preferable if macros weren't used. If its possible to explain what to do without an attachment, that would be good too.

ADVERTISEMENT

Create Calculator To Show Start And End Date Based On Specific Date Provided

Jan 12, 2014

I am trying to create a calculator which will show start date and end date based on the specific date provided.

EX: column A has January 1, 2013, column B has Wednesday, Column C should have a start date which supposed to be 4 days ago (December 28).

View 6 Replies View Related

Progress Meter Based On Yes / No Responses?

Nov 18, 2013

how to create a progress meter based on yes/no (completed/not completed) responses? If 2/10 responses are completed, then the progress meter would display 20% or 20% of the bar would be red. Is this even possible in excel? I've used conditional formatting to create a progress meter but can't figure out how to make a progress bar based on responses.

View 1 Replies View Related

Date Formatting - Copy A Date From Temperature & Humidity Reading File Using The Formula?

Jun 17, 2013

I have to excel files

1. Temperature & Humidity Reading

2. Summary

I tried to copy a date from Temperature & Humidity Reading file using the formula ='[Temperature & Humidity Reading.xlsx]Sensor 7'!$C$2 to Summary file

if the date format is like this 6/10/2013 12:00:00 AM the result is fine, but when i try to copy that formula for the succeeding dates the results is same from what i copied.

View 4 Replies View Related

Date Calculator

Oct 22, 2009

I'm building a calculator of sorts for dates. I have a start date in A1. Next to the start date I have a list:

10 days from -start date- is:
15 days from -start date- is:
20 days from -start date- is:
and so on...

I need a formula to return a date that is however many days specified from the start date. If that date lands on a sat or sun I need it to return me the date for the monday after. For example, if my start date is 10/15/09 (thursday) and 10 days from that is 10/25/09 (sunday) I need it to return the date of 10/26/09 (monday). I also need it exclude a range of holidays i have listed.

View 9 Replies View Related

Formula Not Reading Date Format

Dec 1, 2006

I have a formula that reads the date in Colum B on 3 different sheets. The data on the seperate sheets is pulled from a SQL data base and formats the date wtih the time after it.

11-13-2006 10:47

My formula is looking at dates and subtracting them to give a total count of the occurance of the word "Yes" between dates.

My Formula:

=SUMPRODUCT(--('6200'!B2:B65000>=1/1/2006),--('6200'!B2:B65000

View 9 Replies View Related

Age Based Calculator

Jun 7, 2008

I am trying to put together a spreadsheet that works out values based on a persons age or service length.

So in I have the following data in columns starting at B4 and ending at k4:

Date of birth; start date; text; text; text; text; Weekly Pay; Start age; Current Age; Years Service.

The formula I need to provide in l4, m4 and n4 comes from the following rules:

* 0.5 week's pay for each full year of service where age during year less than 22
* 1.0 week's pay for each full year of service where age during year is 22 or above, but less than 41
* 1.5 weeks' pay for each full year of service where age during year is 41+

So in l4 I have:

=IF(J4

View 9 Replies View Related

Calculator Compute Automatically After Inputting The Date

Apr 29, 2009

i m making a very small calculator. It's a little hard to describe, but I need to look like the following
Let's say the individual got here on 1 Jan

Phase 1 is for days 1-14 last for 14 days
Phase 2 is for Day 15-35 last for 21 days
Phase 3 is day 36+

This is what I need it to look like: All the phase information will compute automatically after inputting the date arrived. In addition I would also like to be able to change one of the phase dates and the remainder of the phases compensate according to the newly entered date.

Date Arrived = 01 Jan 09
Phase 1 = 01jan09
Phase 2 = 04Feb09
Phase 3 = 05 Feb09

View 10 Replies View Related

How To Put Together A Userform Based Time Card Calculator

Dec 31, 2008

I am trying to put together a userform based time card calculator. User inputs the time in the time out and how long of a lunch. Then the program will display total hours worked for the day. Ive attached what I have so far. The only thing that is not very clear is that I have one hidden textbox for the lunch. It is there only for calculating and the visible one is going to inc by :15 min.

View 10 Replies View Related

Shipping Charge Calculator Based Upon Weight To A Worksheet

Apr 15, 2008

I’m trying to add a shipping charge calculator based upon weight to a worksheet. I was trying to do with with VLOOKUP (my first attempted use of this) so I created a second worksheet called ‘Shipping’ which has the weights in column A (Weight) and the corresponding shipping cost in column B (Price). Up to 70 pounds, column A increases in two-pound increments (A2 through A36, 2 through 70 lbs); from 70 through 150 pounds, the increases are in five-pound increments (A36 through A52, 70 through 150 lbs). The total weight to be shipped is derived from SUM(D2:D30), located on the first worksheet called ‘Order’ in cell D32. In cell E32 I have entered this formula: VLOOKUP(D32,Shipping!A2:B52,2).

My problem is if Order!D32 returns something like 4.5, the value for four pounds is the result, while the six-pound charge should be the result. If I round this value up to 5.0, 5.5 or even 5.9, I get the same result.

I know I’m not supposed to guess at what I need to do, but these are my thoughts: 1) I need to modify the VLOOKUP formula to select the next higher value, i.e., so the 6 lb charge is selected for E32 when D32 contains 4.5 lbs, or the 85 lb charge is selected for E32 when D32 contains 82 lbs, 2) I need to add a ROUNDUP function to the SUM formula; this would need to round up to the next even number up to 70 lbs and then in increments of five above 70 lbs. I don’t know if either approach is correct, and in any case, I couldn’t figure out the syntax for either of these.
I’ve attached a sample spreadsheet, Shipping_Charge.xls.

View 5 Replies View Related

VBA Code To Convert To Meter

Feb 3, 2014

I have a code that I use to import a txt file, and the dimensions is being imported as millimeters. However I need them to be converted to meters (thus divided by 1000)How can I incorporate that?

View 1 Replies View Related

Andy Popes XP Bar Progress Meter

Jul 24, 2008

I am trying to incorporate one of Andy's Progress Meters from the DN workbook.

There is so much code in the workbook that i don't have a clue where to start in terms of how to extract just what is needed for the XP bar and incorporate that into my code

View 9 Replies View Related

Prevent Screen Flicker & Show Progress Meter

Jun 30, 2008

I have a VBA code that copy data from multiple files into my workbook.

I find the first file, copy the ranges I need into my workbook and continue to the next file until all files are done.

The copy operation in each file is - row by row - because I need to ask questions about each row.

As you understand - what the user sees is a flickering window because I activate the source workbbok -> copy the data -> activate this workbook-> paste the data.

I want to avoid the flickering.

An acceptable solution could be to generate a pop up message box that will say "data is being copied. Pleasd wait while operation is completed". BUT - I don't know how to identify that the action is done and message box can be closed.

View 8 Replies View Related

Calculate Next Due Date Based On Start Date Frequency And Current Date?

Mar 9, 2014

I'm trying to workout how to take a known initial date a repeating frequency and work out the next due date from today.

Example

Initial Date :- 1st of January 2014

Frequency :- every 5 weeks

Current Date :- 9th of March 2014

Next Due date should be :-12th of March 2014 (if I worked it out correctly from my paper calendar)

I want to use a cell formula to do this for different initial dates and varying frequency periods (the frequency will always be whole weeks i.e. 1,2,3,4,5,6,7,8,8,10)

View 4 Replies View Related

Reading In CSV Files

Nov 13, 2009

I'm using the following code to read in any number of CSV files into a single worksheet and concatenating them together

View 2 Replies View Related

Reading Data In Each Row

Mar 4, 2010

I'm trying to write code that looks at the range W(rowid):Z(rowid) and lists each cell value in a listbox. The row id is coming from the listindex of combobox1. I know the rowid part is correct and working because other operations in my worksheet are using it fine. Here's what I've written so far:

With Worksheets("DATA")
For I = 0 To 4
ListBox3.AddItem .Range("W" + I & rowid)
Next I
End With

View 9 Replies View Related

Reading Same Data In Different Sheet

Jul 17, 2014

In sheet 1 data 123. In sheet2 there is also data 123. In sheet3 will automatically data that is same 123 after reading sheet1 & sheet2. Any data with figure that is same in sheet1 and sheet2 will be reading in sheet3.

View 4 Replies View Related

One Cell Reading From Different Locations

Dec 1, 2008

the attached workbook, I am looking for M19, N19 & O19 to read from different locations depending on how many cells are called on when info is entered in P8.

View 10 Replies View Related

Reading All Folder Names

Feb 6, 2014

I want to read all the folders names in a folder.

So for example c:win estfolder

And in test folder there are 5 more folders named test1,test2 etc.

I want to be able to give the path c:win estfolder and let VBA excel read all the names of the folders inside the folder testfolder.

I have found some methodes on the web, but those are for files like .txt etc.

View 3 Replies View Related

Reading One Character Of Text

Apr 18, 2009

The following code reads text one character at a time, and each character is determined either to be a blank space or to be any other character. If it's determined to be any other character, then the character is added to the active cell. If it's determined to be a blank space, then the active cell becomes the cell one column over. The idea is to have different words written in columns next to each other.

The sample text file I'm reading from reads: "text file". The file has only those two words. One space between them. No space before the first word, and no space after the second word. The following code compiles and runs. BUT the result is that the word "text" is in column k, not A. And the word "file" is in column J, not b.

View 2 Replies View Related

Reading From Drop Down Lists

Jan 11, 2010

I have a drop down list in my excel sheet that contains names of manufacturers. What i would like to do (using vba) is display some details of each manufacturer that will be copied from a different sheet.

So my question is, how can i read the string from the drop down list on one sheet and then copy a cell from another sheet.

View 8 Replies View Related

Reading Row Numbers In Database

Mar 5, 2012

I am building a data base. I have a tab where you fill out of a form and then click an activeX command button to write to the data base. I am wondering if there is a way to record how many times to button is pushed. Each time the button is pushed, I want to record the data from the form into a single row in the data base without writing over old data but I do not know how to read how many rows of data are already there.

View 9 Replies View Related

Reading Text From Right To Left

Feb 7, 2007

I am using the find or search function but I need to read my text string from right to left (from the end of the string, instead of from the beggining). Is there a way to do this?

View 9 Replies View Related

Error When Reading Checkbox Value

Mar 21, 2007

I have a spreadsheet with about 200 lines or records and I have added a checkbox to the end of each record. I need to the code to check the checkbox on each line to make a decision on how to process the data, but I do not want to read in a True or False value for 200 check boxes in every step of the loop. I think I'm close but I can't get the following to work...

This is basically what I want:

For i = 1 to x Step 1

IF me.Shapes("Checkbox" & i).Value = True Then

'Perform Action

END IF

Next i
I get an error when I hit the IF me.Shapes..... line

"Object doesn't support this property or method."

View 9 Replies View Related

Reading Into Merged Cells

May 15, 2007

I have a table where sometimes cells are merged. To the right they are not merged, but I need to link to the value of the merged cell. How can I do it if I don't want to do it manually?

Example:
Say A1:A4 is merged, A5 is just normal. I want a formula using those values, say in B1:B5. Now just filling down the formula would reference A1, A2 and so forth. This is wrong.

View 9 Replies View Related

Reading From Clipboard Before Pasting

May 28, 2008

Is it possible for VBA to read data from a clipboard so that it knows what sheet to paste the data to? Currently we run a financial tool and 2 reports are ran and I put in a bottom so users could easily just paste special values into the correct place. Sometimes the users forget if they copied the balance sheet data or income statement data and currently its not a big deal because there are no columns to the right of where it is pasting so it isn't screwing anything up and they just delete the data and paste it to the correct sheet.

I have thought of 2 approaches I am going to take, but started to wonder if one could read the data from the clipboard before the paste.

My 2 options would be:

Option 1. Paste data to newly created sheet and check if it is balance sheet or income statement and then move from newly created sheet to correct sheet and delete newly created sheet. The user wouldn't see any of this because I would disable screen updating.

Option 2. Learn how to use Undo within my VBA or keep the Undo cache with items in it as it typically clears when VBA is executed. That way if they paste it and it is wrong I can just undo the VBA paste.

Option 1 I am confident I can handle. Option 2 I can research and feel I could do, but if it comes a time when a sheet has data I do not want to paste over then this option is no good.

I would like to hear any comments or feedback on this and if it is possible to read data off the clipboard so it knows where to paste.

View 9 Replies View Related

Reading A .txt File In Excel VBA

Jul 5, 2008

I need a little bit of help here ... I can read and process a .txt file from my Excel VBA program, but I am having trouble as follows :

The file I am reading contains a number of heading lines, followed by a number of data lines.

All of the data lines end in a date, so I can use the code ...

If IsNumeric(Right(MyDSRec, 1)) Then
... to pick up the data lines & ignore the heading lines. This is fine and works perfectly.

However, the .txt file that I receive is out of my control, and is prone to error, in that the data line occasionally has what I assume is a "Tab" character after the last date, which means that the line above does not recognise the last character as being numeric.

If you double click "06" at the end of each line on the example below, you should be able to see what I mean (in the .txt document, if I place the cursor at the end and press backspace, all characters at the end are deleted, back to the 06, so they are not individual spaces) ...

RAMSEY1129/0503/0603/0613/06
SHAKESPEARE 1102/0609/0609/0618/06
PREMIER603/0604/0605/0618/06

View 9 Replies View Related

Reading Binary File Bug

Jun 16, 2006

I am running into one of the strangest issues I have seen in a long time. I have a user defined type that I utilize in VB6 and write out to a binary file....

View 7 Replies View Related

Reading Values Into An Array

Jul 31, 2006

I am have a 4x2 table and would like to use the values in the table in numerous procedures. i feel the best way do to this is to record the table as an array and be able to 'paste' or call the array anytime i need to. However, i am unable to read the table into an array.

1. how the array works,
2. how i can read values into an array and
3. how can i 'paste' or call the array at a later stage.

View 4 Replies View Related

Reading Consecutive Dates As One

Oct 12, 2006

how would you read consuctive dates as one

example

person is sick on 10/9/06 and on 10/10/06 . i want that to be read as one sick. now if the person is sick on 10/09/06 and then sick on 10/11/06 that would be read as 2 sicks.
what i need is the consective dates to read then one to read the dates that are not consectutive . giving a total for each one.

View 4 Replies View Related

Reading A Cells Value And As A Range

Jan 7, 2007

I'm trying to use the contents of a cell as a range in my code

Private Sub CommandButton3_Click()
Dim Target As Range
'the cell containing the contents i want
Range("P11").Select
Target = ActiveCell.Value
Range("P9").copy Target
End Sub

Does it read in the value as a string? If so how do i get around this?

View 2 Replies View Related

File Name Reading Through Macro

Apr 4, 2007

i am trying to read the file name in a specific folder through macro of my EXCEL application. i wondered that it is reading that file name in all Lower case.
Ex: the file name in the folder is "Ford of Pompano.xls" when i am reading that name from macro, it is giving me as "ford of pompano.xls". Do i need to change any default settings in EXCEL so that it can read the files names what ever is presend in the folder

View 3 Replies View Related

Little Calculator Wanted

Jan 10, 2007

I've been trying but excel does not seem to recognise x and y

so here it is

2* X = Z

Where 2 is changable
X = Z-2

Now i just want to find what Z is.

Here's an Example
1.3x - z
1.3(x-.06) = z
1.3z - .078 = z
1.3z = z + .78
1.3z-z = .78
.3z = .78
z = .78/.3
z = 2.6

View 14 Replies View Related

Birthday Calculator

Jan 26, 2009

I am hopeless at remembering birthdays tbh - so rather than rely on family to remind me, I decided to make a spreadsheet that shows: D.O.B, current age (in years, months, days), and number of days remaining until next birthday.

Please see attached - I can't figure out why the current age calculation is a month out. e.g 'Sebastian' was born on 16 Nov 2008, which makes him 3 months and 11 days old - but '=TODAY()-C16' yields "00 Years 4 Month(s) 12 Days"

Also, 'Leah' has just her birthday - but now where it is supposed to give 'days until next birthday' it gives an error with the formula: '=DATEDIF(TODAY(),EDATE(C4,(YEAR(NOW())-YEAR(C4))*12),"d")'

View 6 Replies View Related

Freight Calculator

Nov 16, 2009

I'm building a freight calculator and am considering some professional consulting options, but before I do that I wanted to see if I could overcome this one problem. If I can, I think I might be able to complete the calculator myself.

Here's my conundrum:

A potential customer enters "80802" for zip code and "Solomon" for store.

StoreLocation_________ City_______ State_____ Zip______ Distance
Solomon__________ Arapahoe _______CO ____ 80802_____ 270
Garden City_______ Arapahoe_______ CO _____80802_____ 143

The formula (or series of formulas) I'm looking for would then refer to the following hidden sheet and return Arapahoe, CO and a distance of 270 miles from Solomon.

View 14 Replies View Related

Making A Calculator From Vb.net To Vba

Feb 11, 2008

i made a claculator in vb.net, and now i have to make one in vba, what i did was as follows, first ill post the code from last year, then my vba attempt;

View 14 Replies View Related

Progress Tax Calculator

Jun 19, 2006

I'm trying to come up with an efficient formulae or function to calculate tax

The problem I have is that the tax is progressive. As below

the first 20,000 is taxed at 5%
the next 20,000 is taxed at 6%
the next 20,000 is taxed at 7%
the next 20,000 is taxed at 8%
the next 20,000 is taxed at 9%
more than 100,000 is taxed at 10%

I'm trying to do a formula like below

Cell B3 is my taxable amount
Cell B5 =IF(B$3>20000,20000*0.05,B$3*0.05)
Cell B6 =IF(B$3>40000,40000*0.05,(B$3-20000)*0.05)

This gives me a problem in that for 35k say, I end up with a negative number for the second part in cell B6. My other issue is that each calculation will take up 6 rows on my
spreadsheet. I was hoping to set up a function that could do this in a cell, but even the simple stage defeats me at the moment.

View 12 Replies View Related

Timesheet Calculator

Dec 18, 2008

See workbook attached.

I'm looking for help to detemine rates so it automates in the sheet.

Can you give me assistance and code perhaps ? I'm pretty basic at V-Lookup and If functions. Is this the best route to take ?

All is explained within the workbook.

View 10 Replies View Related

Best Way To Implement Calculator?

Feb 20, 2014

Creating a calculator for employees and possibly customers to use to return values based on information inputted. Created a worksheet but thought there may be another way to enter and return the calculated information that may be more user friendly. New to user forms but thought that would work for the user to enter information. Can information be returned from the worksheet to the user form?

View 2 Replies View Related

Get Rid Of The Calculator Toolbar

Nov 25, 2006

I downloaded the calculator toolbar, and for some reason it doesn't look right, it doesn't resemble a calculator layout at all.

The numbers are skewed, as though the layout is in landscape view instead of portrate. I've tried repeately to delete it from the toolbars menu option, with no success. It's become annoying.

View 9 Replies View Related

12 Digit Calculator

Feb 20, 2007

Is there a way to build a 12 digit calculator in excel?

View 9 Replies View Related

ADVERTISEMENT