# consumption

1. ### Need Fuel Consumption Excel Database File

Dear friends can anyone help me getting fuel consumption database excel file for all kinds of vehicles (Car, trucks etc).
2. ### Forecast Consumption Chart

Hi I am trying to track paint consumption. I have 50 gallon drums in which a machine consumes at different rates until empty. I log down the gallons used per day. I have 2 to 4 drums on hand at time. I need to chart this information and have the chart forecast on when the 4 drums will be done...
3. ### how to find and sum together all the variables in a table as they relate to daylight hours and night hours

I have a csv file of consumption data recorded every 30 mins for 365 days. How would I write a formula to find all the variables that fall between say 6am and 6pm (daylight hours) and 6.30pm to 5.30am (night time hours)? Ideally I would like a total of consumption during daylight hours and...
4. ### Power Consumption Over Time Period

Hi There, I've been trying how to figure this out but i need a bit of help please!! I have the below table and am trying to work out the power consumption in 15 minute intervals form 7am to midday. The issue I'm stuck with is adding the total power up during each time period to then be...
5. ### VERY new to formulas

I have made a very good worksheet for work but I can't seem to figure out a formula for this problem. <colgroup><col width="110" style="width: 83pt; mso-width-source: userset; mso-width-alt: 4022;"> <col width="107" style="width: 80pt; mso-width-source: userset; mso-width-alt: 3913;"> <col...
6. ### Formula needed to determine net quantities of items, categorized by name and date

Hello, Lower level Excel user here, hoping to get some guidance. My company has to have a spreadsheet to track inventory usage for some components for a daily report. We need to track daily exactly how many of each item we receive into our warehouse and how many we consume to build orders. The...
7. ### My input data is running sum

Hi I have a file with data that I want to import to excel via power query. All data in the file are continuous measurements of three water meters, which means that the consumption per hour is always current readings minus the previous one. To complicate things further, you can also readings...
8. ### Peak/ Off-Peak/ Shoulder calc

HI, I have a mechanical schedule spreadsheet where i calculate all buildings energy consumption. I have to calculate Peak / Off Peak and Shoulder consumption. I am hoping someone can assist with the required easy calculation. I have bee given the sheet from a previous employee with calcs...
9. ### Kilowatt hour consumption formula

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
10. ### Calculating & Forecasting With Excel

Hi i would like some assistance in calculating and forecasting with Excel, anybody can guide me please? Dataset can be found here:https://drive.google.com/open?id=0By...XNQUjZ3REVQalE ": Degree Days Degree days is a way of quantifying temperature ranges. Merging this info with electricity...
11. ### how to divide Continuous data into time based groups ?

Hello Professional, i have continuous data (time & Kg) of material consumption for 3 working shift of a Factory i would like to separate this continuous data into 3 Shifts for every day: for 9.9.2017: Day shift: from 06:00 till 14:00 average consumption...
12. ### Using WHERE, OR and IIF with UPDATE

Hi All I have the following table (sample) <tbody> HOST Function SWC Consumption RTB/CTB for TM1 HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD NON SWC ? HTS SWD SWC ? HTS ITO...
13. ### Logic Formulas for Dependency Tables

Hey folks, Take a look at these three dependency tables: Let's take Dog as an example. In order to produce a Dog, you need to consume a Car and a House (1st degree dependency, first table). However, in order to produce a Car, you need to consume a Computer, and in order to produce a House...
14. ### Excel 2010 vs 2013 vs 2016 resources consuption

Hello. We have old computers in my company. Most have office 2010. I'm fighting with sysadmins that they need to install office 2016, but they argue that new office would eat lots of resources and this old PCs would be laggy. I tried to find some info about resources consumption of different...
15. ### Consumption Cell Charts

I want to use cell charts to visually show me how much of a specific budget item I've consumed. That way I can quickly look at the budget and know my consumption. I know I can use percentages and conditional formatting of the percent to do this, but I was hoping for something more visual...
16. ### Hydro consumption formula quandry

Hi guys, I'm looking to calculate my Hydro consumption on a particular device in my basement. I'm currently running UPS systems to test battery charge & other. I need to run each UPS for a total of 24 hours (charge + plus troubleshooting time). With that said, I'm looking at creating a...

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...