asset

Hi guys, I'm setting up an Excel sheet to maintain a spreadsheet for asset management. We have an asset management system in place, but there are occasional times where it's offline(Or I am), so I wanted to make something that I could chart these items on, and I wanted to get a little fancy. So...

hello All.... I have an excel input form where the user enters a WORKORDER NUMBER (WONUM) and Asset assigned. Most of the time there will be multiple assets per wonum, each of these assets are a separate entry. What I'm trying to accompish: I want a text box that will list these assets in a...

Good day, I have a sheet with Asset Type code, Customer plant and Asset Number. The Asset Type code indicates the configuration on the machines and is not a unique number. The Customer plant is also not unique but Asset Number is unique. There can be numerous Asset numbers for one Asset Type...

Good day, I have a sheet with Asset Type code, Customer plant and Asset Number. The Asset Type code indicates the configuration on the machines and is not a unique number. The Customer plant is also not unique but Asset Number is unique. There can be numerous Asset numbers for one Asset...

I’m trying to set up a table where you can have multiple dynamic lists. For example, column 1 has a drop-down list containing the asset group, column 2 would then have a sub-category if there is one otherwise it would remain blank and column 3 would then show the correct assets attributable to...

Hai, Can i know that how many number of rules maximum in power query? I have some rules in power query as below, the problem the query not functioning if i add few more query to this. Really need your help and how to increase numbers rules or any other alternative. Thank you in advance...

Hello All, I have a large accounting file with parallel construction which I need to pull into each of my assets Profit and Loss Statments. Each asset has a separate PnL page, and in my accounting worksheet, I have each asset named seperately. I'd like to create a formula where I type in the...

Hello, I hope someone can help. I have a sheet of data (Sheet1) which I need to manipulate using VBA. I want to keep the existing data (for sanity checking) and generate an amalgamated version on a new sheet. The rules are quite straightforward: (a) if an asset has a freehold status only...

I would like to calculate current depreciation which should not exceed the cost of the asset, which is in cell b2. Thanks. The current depreciation is being calculated as under: =IF(A8="","",ROUND(IF(A8=1,SLN($B$2,0,$B$3)/12*DATEDIF($B$4,$B$6,"M"),SLN($B$2,0,$B$3)),0)) <tbody> A B C D E F...

Hi, I am trying to create a straight line Depreciation schedule forecast in Excel , based on the asset register received , for the purpose of Forecast , <colgroup><col><col><col><col><col></colgroup><tbody> Asset Current Cost Accumulated Depreciation Net Book Value Date Placed In Service...

Hi, I have a set of data that has three colums; a centre identifier, the type of asset it is (each centre will be classified as an asset type and I have 5 different asset types) and the profit it makes. I have seen a chart before where it shows each centre's profit as a bar (so you get a visual...

Hello, I have a list of assets that went in service in different dates and I want to use DB function to calculate depreciation BY MONTH. I tried =DB($J$43,0,60,R2,4) where: J43 is end of PPE balance 0 salvage value useful life 60 months R2 =1 or the first period when depreciation start 4 is 4...

To whom might be able to help. In the example above location 1 fulfill their 50000 lbs delivery with the first two assets. Would like to modify algorithm so that location 2 is fulfilled with the next available asset (right now starts again with the same assets) and on to the next location so...

Hi, first time poster here...go easy! LOL I have a spreadsheet and in the asset column i have a list of numbers related to that one line of information. All separated by a comma <tbody> Number Title Rev Asset total amount of assets UC02-WPD-UT-REP-N001-000012 Network Design - N1 P01...

Hi All. So I am smack in the middle of a full hardware inventory audit. This means I need to use an existing excel sheet that contains asset numbers and serial numbers. My excel headers are like this: Asset | Name | Serial | Model | Site | description | Change Typically I just print this...

I have financial instruments that need to be recorded as an asset or liability depending on their values. Any suggestions on a formula for the journal entries in columns E and F?

Hello all, I have excel in the below format. Excel 2013/2016ABCD1Asset tagCIIM Asset IDStatusValue2E2902202118195Yes1233E2900852118571Yes3454E2913082119523Yes125E4524042128911Yes12Sheet1 In Sheet 2 I need to update value. Excel 2013/2016ABCD1Asset tagCIIM Asset...

Hello! Simply, I was wondering if anyone had a method for conditional formatting (Font Color) for a row based on whether or not the last four digits of an asset appear in a separate table. (Table A) I've got a spreadsheet that has a large list of equipment as well as columns with current...

I've managed to create a spreadsheet for subcontractors (i work in construction) to auto generate document numbers from 18 mandatory metadata fields (Only 8 fields fill the Document number but the others are mandatory to the EDMS system we use (Aconex)). One section is looking for specific...

Hey Guys, in a bit of a pickle. How do I transpose cells from Columns to rows using a macro and also include the Asset Number and Date next to its respective element. <tbody> Asset Number Date Iron Cr Nickel Al Pb Cu Silver TA20 12/12/2018 24 25 26 52 45 85 65 TA22 10/04/2018 65 875 45 895...