battery

QUESTION: I'm doing a preventative maintenance spreadsheet. When I complete a task on a particular date, I put the date in that I've completed it in column "B" (for example) and a new "due date" appears in column "B". Is there a way to keep a record on another worksheet that will maintain a...

Good afternoon! I'm still very very new to VBA and user forms in Excel so I'm hoping to get some help. I'd like to create a user form that would allow for the selection of 2 independent defined variables and produce all possible results. Example: I have a remote that can use multiple battery...

This is a bit of an unusual post, aimed at people familiar with optimization problems solved by the Excel solver (or Add-ins like OpenSolver) In the attached Excel file, I simulate the following simple scenario: A house consumes electricity from the grid for 24 hours. The amount of...

Hi everyone, To learn excel beyond a basic level I figure you need a project that is meaningful to your work. I work with large lead acid batteries. There are two of these batteries and each battery is ~250 individual cells. Monthly each battery is manually checked for cell temperature, cell...

I'm not getting any results... or FALSE... no matter how I write this. Can anyone help? If Column A:A equals $B$1, If Column D:D contains "Battery", then give me the date from column S:S. Thank you, Sharon excel 2010

<tbody> Battery lift hours in hours out blank lift hours in hours out blank RR01 RR23 1545 RR02 RR03 RR04 RR05 RR23 1545 1550 RR06 RR07 RR08 RR23 1550 RR09 </tbody> So I've got a spreadsheet...

Is there any correlation between file size and eating up lots of battery life on a small portable PC? Some of our sales reps are experiencing battery life shortages and someone said it was the size of one the files they use, around 15M. I googled around a bit and found nothing to confirm this...

I have an excel document with 8000 + rows with 23 columns and desire to populate the UID column with a number with everything associatedwith that item (between row breaks). What formula can I use to populate the UID column automatically insequential order?(I’ve populated thedata shown below)...

Hi, looking for a shove in the right direction. I would like to have a graphical representation of a battery (224 individual cells) and what I would like to do is map the readings that will be in a separate table onto the cells so you can see for example "If an area of the battery is hot...

I am trying to find a formula for all cells that can take my battery dates that are 3 years old of the current date and or older that show highlighted red. I have used the formula =J10<TODAY()-1095 and it works for one cell but I cannot figure out how to us it for all cells. Please help

Hi gudpm again, After my first useform I got excited to create and develop another one which can be useful more likely in my work. For example I have a spreadsheet like this Machine REPAIR DETAILS DATE MECHANIC PARTS USED M1 replaced battery 1/1/2000...