usage

Hi The program I'm working on is to help me determine my monthly electricity usage taking into account the cost 4 tables in the excel file. If I make a payment then usually it will span over 2 months. I just can not find how to get it right as what I have is not correct. The single payment...

All hi, i would like to prepare a VBA code so that, to set print area, the usage rows and columns only. Please note that the range change each time when i download the file from accounting system. Many thanks in advance

Hey guys, I’d like to create a chart with the following data as an example. 08:45 10:00. 3 9:50 11:15. 2 11:15 13:30. 4 13:00 15:00. 1 So it’ll show: between 8:45 and 09:50 = 3 between 9:50 and 10:00 = 5 between 11:15 and 13:00 = 4 between 13:00 and...

Hello Everyone, Could some genius please help me with formula or ways to find a daily occupancy rate of car park in hourly bases based on transaction of “Date Time IN” and “Date Time OUT”. ? Below are the actual sample of transaction we receive. Note: Drivers can park for more than a day as...

Hi there, Hoping someone can help me. I need to split usage of units in different columns (without using VBA): For example- Total Usage: 29 (B3) Column C: The first 1 to 12 unit are free Column D: Units 13-25 are charge 1 Column E: Units 26+ are charge 2 I want to the split the usage...

Hi, I am trying to create an inventory spreadsheet where usage removes quantities from a lot until it is completely relieved and then the next lot is subtracted from. I have completed this as below: <colgroup><col><col><col span="2"><col><col><col></colgroup><tbody> Lot Date Received Qty...

Lets say whole ABCD is written in A column Row wise. I want to apply filter to show rows with only, A, C, U, K How would i go about this without manually checking these using simple filter option. Also suggest wildcard usage if for example I search for *A*

Hi ~ Need a bit of help. I have a spreadsheet where I am trying to incorporate an accrual usage calendar with columns that will calculate the usage based upon what is accrual is typed in a particular day of the month (cell). I have this so far ... =IF(OR(J7="VAC", L7="VAC"...

Good afternoon, I have a workbook. Within that workbook I have two worksheets, one is called customer list and the second is called raw data. The raw data worksheet is set up like below... <colgroup><col width="129" style="width:97pt"> <col width="31" style="width:23pt"> <col width="63"...

I've been working with ERP data in the past few months. Lately, Excel seems to be hanging with the processor usage in the bottom right corner slowly increasing. There are also intermittent white screens and (Not Responding) messages. Sometimes it recovers, sometimes it doesn't and I have to...

I am trying to calculate the power consumption on my computer, monitor, Refrigerator, TV's and portable air conditioner. I am looking for a formula that I can take information from the devices to calculate the usage. Thanks, Mike

Hi to everyone, i would be greatly appreciate if you could help so that to create a vba code and mark the usage range in excel. Please note that the rows are change each time whenever i download the data. Below is an example in col. "A", "B", "C" till row "8". Many thanks in advance A...

<tbody> Month day item name usage 1 item name 2 3 2 item name 2 7 3 item name 3 2 3 ... 3 ... 4 .. 4 .. 5 .. 6 . </tbody> sheet1 is above, I need calculate the daily usage and total usage in following sheet2 base on the list of...

I have a spread sheet that has usage numbers for items based on location of the item being used. I have to sort the spreadsheet to give me the item that has the highest usage for the past 90 days, but then gives me the item ID information for the other branches associated with it. Currently when...

Here is a small sample below. I have about 12,000 rows of energy usage data by the hour per day. I would like to know what my average kWh usage is at a specific hour per month. I think I need to use some kind of index/match sum function, but I'm not really sure how to do it. I also played...

Bonjour, J'ai installé l 'addin HTML Maker et je cherche le menu " dans la feuille" et non dans le code VBA; je ne vois aucun menu en + dans mes menus; par contre j'ai bien le menu "code documentor" (autre utilistaire proposé ici). Sauf erreur de ma part, HTML Maker permet de copier aussi...

I have data for customer visits but want to build up on what I have. month: Jan Hours open: 116.5 Visits: 412 Average hours per visitor: 2 I am trying to find out what percentage of the 116.5 hours were taken advantage of by customers. I have been testing modifying this formula: (xx /...