usage

I am a librarian interested in tracking book checkouts over time. I only need to track how often an item has been used, not when or by whom it was used. My library is too small to justify the purchase of an ILS (circulation software), so I am looking for a simpler solution using what I already...

I have a system which generates alerts for part usage but I worry its spamming them. Part lifespan = 30,000 (approx 1 month), Device “A” Average is 1% part lifespan per month or 300 counts per month Device “B” Average is 100% so 30K per month So how do I math? To get a dynamic usage figure...

I am a complete novice at excel, so please forgive me. I am trying to take usage data from my order catalog for two regions and combine them into one table, while keeping the usage totals in discrete columns. The items in the two catalogs are mostly the same, with a few unique items in each...

Hello All I am trying to automate a task that is completed every day on a spreadsheet. I have an inventory tab, which contains the stock details of some 1200 different products. Each day we consume some of these products and update the inventory sheet using the find function and manually...

Hello all. First post... Here is a simplified example of what I want to accomplish. I can change the individual's mobile data rate plan for my group each month, depending on usage. I have ~1000 lines to work with. The plans are only grouped for readability. Rate plans are: 01. 1 MB Plan -...

My ISP has a data usage report/page, and I personally have a simple, max usage/days of month, sitting on excel, with a conditional format that highlights the current date, so at a glance, I go to their site, see how much I've used, and if the value in my excel sheet is more than the usage, I...

Good afternoon all. is there a function in VBA to have a "counter" to record how many times a form gets used?

I have downloaded a spreadsheet and in the formula there is (@) symbol in the formula. What does it do or stand for? I am unfamiliar with is usage. =SUMIFS(ItemizedExpenses[Amount],ItemizedExpenses[G/L Code],[@[G/L Code]],ItemizedExpenses[Purchase Date],">="&D$3,ItemizedExpenses[Purchase...

Hello all, I'm trying to populate an order form ("Supply Usage Form") using VBA. I have a command button that, when selected, loops through a location-based inventory sheet ("Location") and checks columns L & M for missing or expiring items. If any are found, it auto-populates the order form...

I have a code that searches Sheet1 ("Location") for certain criteria and populates Sheet2 ("Supply Usage Form") with that data. This works fine, after looping through all the rows on Sheet1, I need the code to loop through all the newly added data in Sheet2 for duplicates, combine the rows and...

Hello. I know this topic has been discussed in other posts, but every time I try to modify the codes I cannot get it to work. I have a supply order form where column D has the name of each item and columns H (used), I (expired), J (damaged), and L (new) have the numbers that need to be ordered...

I am in desperate need of some help, please! I have an inventory sheet ("LOCATION") and an Order Form sheet ("Supply Usage Form"). I'm trying to get the below code to look at each row from row 9, column "B" to the last row (may vary from time to time) in the inventory sheet in columns 12...

I am working with 2 sheets. Sheet1 is an inventory sheet (name of sheet is "Location") and Sheet2 is an Order Form (Name of sheet is "Supply Usage Form"). "LOCATION" A B&C (combined) D E F G(week1) H(week2)...

Hi all, I now have two worksheets, one containing usage of materials of a product. (Part no. in column A and usage in column B) The other worksheet I have contains purchase price of materials (Part no in column A and price in column B) I tried to use the sumproduction function to calculate...

This is going to be a really complicated issue to explain but I am going to do my best. I am using PowerPivot for measures and PQ to clean the data. I am building a tool that projects energy charges for the next 12 months at facilities that my company owns. The way it works is the highest...

Hi everyone, I have a full set of last years numbers that I am trying to compar to a set of this years numbers on a moving 4 week average. I can get the numbers for the current year using this array formula. =IFERROR(AVERAGE(INDEX('IWI Week Ending Usage Numbers'!3:3,LARGE(COLUMN('IWI Week...

Hi, I'm a newbye so please be patient. I have two colums with several values (wattage usage in the day and wattage usage in the night). I need a third colum which should show the daily variation between the sum of the previous day. So, for example I have in the colum A (5,12,4) and colum B...

Hello I have stumbled upon a strange class called "Table" inside the selenium for VBA. Does anyone know the usage ? I tried many different ways to pass somehow the values ,objects or table element from HTML without any luck. Even reading through the C# source code doesnt reveal any clues...

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

Hello All, I have spread sheet with the data till 2000 rows, with 4 columns of data. The headers are like "App Name", "Ram Usage", "Category" & "Total Space allotted" Column "App Name" will contain names of Different apps might be repeating. Column "Ram Usage" contains the values of how much...