I don't expect to get any bites on this one, but, "Hey, it's Friday -- it
Just got this one dropped on my lap -- we have a spreadsheet with items that
we depreciate -- this spreadsheep has been touched/maniulated by many over
the years (I just gained access to it, since it's not doing what the Finance
folks would like it to do).
Here's what it does ...
Col H has a description of the item
Col J has In Service Date
Col L has the Life of the item (ie, 60 mos, 120 mos)
Col M has the Original Cost of the item
Col N figures the Monthly Depreciation (=M2...Pasting Portions of an Excel Spreadsheet
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: pop
<a href="http://screencast.com/t/YjhhYTU5YzU">http://screencast.com/t/YjhhYTU5YzU</a> <br><br>Hello, above is a short video with my question. I'm trying to paste a portion of an excel spreadsheet into an email and retain the boxes that are in the original spreadsheet. <br><br>Thanks for your help, <br><br>Robby
On 1/18/10 5:43 AM, in article 59bb12ee.-1@webcrossing.JaKIaxP2ac0,
We are having a problem with the fixed asset depreciation on some assets.
The auditors have found that the depreciation on these assets is calculating
a larger amount than expected. The items involved all are Buildings and they
are have an acquisition date that precedes our implementing the system. They
were loaded into the system on 7/7/2000.
How can we fix this?
Not enough info Andrea to advise a fix. If you can give us all the
particulars of the asset, the depreciation settings, current
depreciation amounts, etc., maybe we can help. The more detail the
MCP...Can I import a Lotus 1-2-3 spreadsheet into Excel and save all fo.
I would like to import a 1-2-3 spreadsheet that contains many formulas. It
would be really great if the formulas were understood by Excel and preserved
during the import. Is this possible?
I think it depends on your versions.
I use Excel XP (2002) and when I file/Open, I get a choice of file types,
including an option to select
"Lotus 1-2-3 (*.wk?)"
I think Lotus superseded that with *.123 file types (and for all I know they
may have moved on from that ... it has been a while).
Lotus also has an option to save a file as .xls or .xlw file type, but again
depending on...How do I use excel spreadsheets created in Excel 2000 atwork on my
I use documents on my laptop at work which uses excel 2000, my home pc has
microsoft works - so excel is more up to date. Other than using Excel
Viewer, which means that I can't adapt documents, what options do I have for
using the documents on both computers?
option 1. purchase excel for your home pc.
option 2. see option 1.
>I use documents on my laptop at work which uses excel
2000, my home pc has
>microsoft works - so excel is more up to date. Other
than using Excel
>Viewer, which means that I can't adapt docume...Mirror spreadsheet?
What I'm trying to do is work in a spreadsheet and having an exact one as a
backup, like when you link cells and when you change one cell the other one
change too, but in this case I need the whole spreadsheet, when I work in one
the other one change, add or delete data too. It would work like a mirror
Is this posible?
Thanks in advance.
From Microsoft's help file
Automatically save a backup copy of a workbook
You can use AutoRecover to have Excel automatically save a backup copy each
time you save a workbook. The backup copy provi...Linked Spreadsheets
Is there anyway to tell if an excel spreadsheet contains
links without opening each spreadsheet individually?
Thank you for your help.
go to Edit and look to see if the "links" selection is
available or not. If available, click on it and it will
show your links.
>Is there anyway to tell if an excel spreadsheet contains
>links without opening each spreadsheet individually?
>Thank you for your help.
For companies that have assets with MACRS depreciation methods, does anybody
know the averaging convention that you would combine with one of the double
declining methods to make the schedule work?
Charles Allen, MVP
I've always used Half Year convention to simulate MACRS in GP. It
MCP-GP, MCT, MVP
East Coast Dynamics
That's what I've done as well. Works fine.
On Sep 11, 12:05=A0pm, "Frank Hamelly, MCP-GP, MCT, MVP"
> I've a...How to password protect WORKS spreadsheet
Does anyone know how you can prevent a spreadsheet from
being openned and viewed by applying a password
Use the Save as.. feature. When you type in the name of the file (or existing name is highlighted), you would see 3 buttons on the right side. The 3rd button is Options... Click on it& your doors to password protection would open
...font of spreadsheet tabs' name
How to extend (change) font of spreadsheet tabs' name?
The size of the sheet tabs are governed by the setting for Scrollbars in
Windows Display Appearance. Mine are at 18. Start there and work your way
up or down. The font will increase or decrease with the size of sheet tabs.
So: with Excel Application closed.
Win98 as example...
Start > Settings > Control Panel > Display > Appearance(WinXP
"Item" drop down select Scrollbar
Change setting to Taste
Depending upon your settings, you may have to re-boot to s...How do I copy spreadsheets with charts?
I am constantly making workbooks with 12 spredsheets (one for each month of
the year). In these spredsheets I have embedded charts.
When I have done the setup for the first month I make 11 copies of the
January sheet and do search replace in these ones to make them correct.
Problem is - I haven't found any way to avoid having to change all
datasources of the charts manually. They are all linked to the original
spredsheet and not their new "mother" - the copy.
I am very grateful for help in this one.
Right-click the sheet tab, select move or copy, ...Depreciation
I am not too familiar with Great Plains. One of my clients told me that when
he closes out book depreciation for the year, he must also close out tax
depreciation. Is this true? If not, how does it work? I have used several
other systems (especially macola) and you can close one book without closing
You do not have to close all books at the same time.
Charles Allen, MVP
> I am not too familiar with Great Plains. One of my clients told me that when
> he closes out book depreciation for the year, he must also close out tax
&g...Linkage between spreadsheets .... link from file1 sheet3 to file 2 sheet 1
I have a password protected master spreadsheet with 10 worksheet
included, I would like to create another password protected spreadshee
where the viewer may only see the contents of sheet 3 from the firs
It is vital that the second spreadsheet is password protected.
Message posted from http://www.ExcelForum.com
just link the cells from this sheet. something like
in cell a1 of your new worksheet
"dwalley >" <<email@example.com> schrieb im
New...How do I unlock specific cells in a spreadsheet that I protected? #2
I have a spradsheet that I protected and I now want to unlock some specific
cells so my users can update the cells. I tried to do this by going to Format
then Cells and so on, but when I clicked on the Format tab then on the Cell
option, the cell option is grayed out(not active). What is causing this and
is there a work around?....Tks, MM
By default all cells are locked when the sheet is protected.
First, you must Unprotect the sheet via Tools>Protection>Unprotect sheet.
Select the cells you wish to unlock and Format>Cells>Protection. Check
"unlocked&q...Passwording a linked spreadsheet
I've been asked to create a series of spreadsheets that link into one
Each spreadsheet will have a summary column where the users will input
what they want to see on the master spreadsheet.
The master spreadsheet will then only show that field.
However I want users to have access to the master spreadsheet but only
selected personnel can have access to all of the seperate spreadsheets.
I would like to password each of these files with a different password.
Only problem is that when your in the master spreadsheet and you update
the links, it asks for the pas...How to import MS Excel Spreadsheets into MS Money 2004 Deluxe
Is there a mechanism to import a MS Excel Spreadsheet into
MS Money 2004?
A bank will only provide the transactions in Excel
Any help will be appreciated.
"Varun Gupta" <firstname.lastname@example.org> wrote in message
> Is there a mechanism to import a MS Excel Spreadsheet into
> MS Money 2004?
> A bank will only provide the transactions in Excel
> Any help will be appreciated.
...Asset accounts for cars and depreciation question
I have an asset account for my car so I can weigh it against money I
borrowed to finance it. Over time the car will, of course, depreciate and I
was wondering how others are accounting for this. Your input is greatly
Annual adjustments in value to reflect www.nadaguides.com, entered as an
expense categorized as transportation. You can categorize it however you
I believe GAAP requires not revising the actual asset account, but creating
a contra-asset account and expensing that. Management reports then include
both asset and contra-asset, which ...How to email a spreadsheet
I just installed 2007 Student and want to email a spreadsheet. I open the
desired page, click the email btton in the toolbar and nothing happens. What
am I missing??
> I just installed 2007 Student and want to email a spreadsheet. I open the
> desired page, click the email btton in the toolbar and nothing happens. What
> am I missing??
Sending Email from Excel directly requires Outlook, which is not part of Office
2007 Students and teachers edition.
Look at www.rondebruin.nl for alternative solutions
Jan Karel Pieterse
Membe...Linking two spreadsheets
I have a master document which includes training information for al
employess. Currently, we have tabs for each employee (small company)
which describes all of their daily/weekly tasks.
The problem is that you can't edit the file if someone else has i
We'd like to create an individual spreadsheet for each employee an
still be able to display them in the master document. Is there a way t
pull all the data from the individual spreadsheets into the maste
document? I know you can link individual cells from multiple documents
but because we don't know how big each person...what is straight line depreciation and double line depreciation?
In article <928DC52C-D390-45C6-9847-693648A1A5DA@microsoft.com>,
MISSY <MISSY@discussions.microsoft.com> wrote:
"JE McGimpsey" <email@example.com> wrote in message
Quite a good article for wikipedia, but it misses one very important point.
The original purpose of charging depreciation to the P&L was to build up a
reserve in order to replace the asset when it became obsol...How to set up spreadsheet to track replaced parts
I track parts that are replaced on our machinery. Most of these are
not a problem, but there's one that has me hoping for an easier way.
One part is used in 170 different places. When one is replaced, I
need to note some parameters, reason for replacement, and the position
code of the part. At certain points, we pull the machine in and
replace all 170 in one fell swoop, including any newer replacements.
To top it off, there may be different brands of these parts - all the
same part, just from a different place, and that also needs to be
noted. And then I need to calculate the lifespan...Copying a macro to another spreadsheet
I have a macro (assigned to a button) within my excel spreadsheet. I want
to give this macro (and button) to several my colleagues for them to insert
into their spreadsheet. What is the easiest way of doing this?
I right clicked on my button and selected Copy. I then loaded up one of the
spreadsheets and pasted it in. Looked good. Button and Macro worked in her
sheet. However, one of the "side effects" was that when she clicked the
button it opened my spreadsheet on her computer. (we are on a network and
our spreasdsheets are in the same directory). Obvioulsly the button I
co...Totalling non adjacent cells in a spreadsheet
I am running WXP with Excel 2003 edition. I wish to know if, and how to set
up a running total for various predefined categories in a spreadsheet.
I have set up my monthly expenditure with debit & credit columns, totals are
fine. I list all for say, August, enter Septembers beneath with a C/F
balance, each expenditure is given a category name i.e. Utilities,
Can I then select all the entries entered under say, Housekeeping, and place
them into a cell as a running total, (doesn't matter where i put these
results on the spreadsheet) other than manually en...Depreciate new year transactins
Is it possible to calculate January ‘09 depreciation without closing the
fixed asset module for 2008? Any issues with this?
I don't believe GP will let you do this. You must close 2008 first.
Dynamics GP MVP
Flexible Solutions - home of GP Reports
"Sara" <Sara@discussions.microsoft.com> wrote in message
> Is it possible to calculate January ‘09 depreciation without closing the
> fixed asset module for 2008...Inventory Depreciation
GP8.0 / SQL2000.
We 'depreciate' inventory that has been dead stock for 2 years or more as a
summary on the G/L. I would like to adjust the inventory value of each of
those affected items in our inventory subledger. We are using moving
What is the best way to accomplish that? Are there any built in tools, or
do I need to write my own queries? I can easily prepare the list of dead
stock items and their current cost. Is it a simple matter of applying a
percentage reduction to each of these items in the IV00101 table? Or, is
there more to it than that?...