consumption

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

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...

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...

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...

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...

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...

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...

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...

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 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...

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...

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...

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...

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...

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...

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...