Re: looking for an app
- From: james.homme@xxxxxxxxxxxx
- To: programmingblind@xxxxxxxxxxxxx
- Date: Mon, 17 Nov 2008 14:51:05 -0500
Hi,
Some spreadsheets have a column for indicating that transactions have
cleared the bank. Does anyone know how to say something like this in a
formula? Let's say you have a number in B1 AND A CLEAR INDICATOR IN C1. You
only want B2 added to the usable balance if C2 contains the letter X. I
haven't found a way to refer to the cell you are pointing to, so I assume
that you may need to put a hidden column in your spreadsheet once you set
it up, but I'm not sure.
Thanks.
Jim
James D Homme, Usability Engineering, Highmark Inc.,
james.homme@xxxxxxxxxxxx, 412-544-1810
"The difference between those who get what they wish for and those who
don't is action. Therefore, every action you take is a complete
success,regardless of the results." -- Jerrold Mundis
Highmark internal only: For usability and accessibility:
http://highwire.highmark.com/sites/iwov/hwt093/
"The Elf"
<inthaneelf@roadr
unner.com> To
Sent by: programmingblind@xxxxxxxxxxxxx
programmingblind- cc
bounce@freelists.
org Subject
Re: looking for an app
11/11/2008 02:51
AM
Please respond to
programmingblind@
freelists.org
the way I usually do such things is I start the actual register about three
rows down, and if I put this together it would read across with...
check#, date, PTOO (pay to the order of), amount, notes
below that would be your "working area"
up at the top the first row I would select columns "A" through "E" and go
to
the format menu and merge them giving it a nice fancy lettered E-Check
Register (your name here)
you could even color the background in and such.
then on the second line I would put:
"Useable Balance:" without the quotes in column "A" and put a formula in
the B column of row 2 like this:
=SUM(D4:D1000)
that will automatically add all the numbers you enter in the amount column
automatically, now here's the goodie, this setup will allow you to enter
deposits you make into the account as a positive number
"primary deposit (in the PTOO column)" and 1000.00 in the "amount" column
then if you enter a written check you make it a negative number, cause your
spending it, so
101 | 11/11/08 | what's its name high school | -12.00 | box of pencils
(fund
raiser)
I used a | to break it into the "columns" but if you do this it will add
the
negative number to the primary deposit amount and put the corrected amount
988 in your B2 usable funds cell
you can also add in other fancies like turning the date column from b4 down
(control shift page down) to date format and from D4 down to "currency" to
make it even sharper
there is a way to make it do things when you hit enter in a specific cell
(like putting the current date in the date cell if you hit enter there),
but
I'd have to look them up again
HTH,
inthane
----- Original Message -----
From: "Tyler Littlefield" <tyler@xxxxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx>
Sent: Monday, November 10, 2008 8:35 PM
Subject: Re: looking for an app
> yeah, I've got works. I was thinking about using excel.
> If I kept a balance, say a verticle sheet with what it was on the left,
> and then the values on the right, is there a way to make it automatically
> add to the total?
> If I'm going straight down, I can add ranges, but it'd be nice if it
would
> just add the values as they're inserted.
>
>
> Thanks,
> Tyler Littlefield
> email: tyler@xxxxxxxxxxxxx
> web: tysdomain-com
> Visit for quality software and web design.
> skype: st8amnd2005
>
> ----- Original Message -----
> From: "The Elf" <inthaneelf@xxxxxxxxxxxxxx>
> To: <programmingblind@xxxxxxxxxxxxx>
> Sent: Monday, November 10, 2008 9:28 PM
> Subject: Re: looking for an app
>
>
>> do you have either MSO office or MSO Works, if you have either you can
>> punch out an "electronic checkbook tallier in about as much time as it
>> takes you to type in the column headers, and even have a running
>> "Available Balance" at the top of the thing.
>>
>> HTH,
>> inthane
>> ----- Original Message -----
>> From: "Tyler Littlefield" <tyler@xxxxxxxxxxxxx>
>> To: <programmingblind@xxxxxxxxxxxxx>
>> Sent: Monday, November 10, 2008 4:52 PM
>> Subject: O-t: looking for an app
>>
>>
>>> Hello,
>>> I've got an assignment for Life management to find a "electronic
>>> checkbook."
>>> Can anyone make suggestions based on what they use?
>>>
>>>
>>> Thanks,
>>> Tyler Littlefield
>>> email: tyler@xxxxxxxxxxxxx
>>> web: tysdomain-com
>>> Visit for quality software and web design.
>>> skype: st8amnd2005
>>>
>>> __________
>>> View the list's information and change your settings at
>>> //www.freelists.org/list/programmingblind
>>>
>>
>>
>> __________
>> View the list's information and change your settings at
>> //www.freelists.org/list/programmingblind
>>
>
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
>
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind
Other related posts:
