I have a spreadsheet with a number of worksheets. The first worksheet
has the bonuses for employees in this format
ID, Sales Agent, Sales For Date, Bonus for Date, Sales for Date(N),
Bonus For Date (N). . .
The rest of the spreadsheets are each named for the date of sales that
they contai
I sent that a little too soon.
The title refers to the fact that I was looking into another solution.
the sales sheet for each day is broken down with the following information:
Date, EmpID
Currently, what I am doing is separating them by date. However, I was
thinking a much less cluttere
e:
>
> =ADDRESS(1, 3, 1,, "sheet1")
>
> returns
>
> SHEET1.$C$1
>
> =INDIRECT(ADDRESS(1, 3, 1,, "sheet1"))
>
> returns whatever is stored in the cell referenced by SHEET1.$C$1
>
>
> On 09/28/2013 11:30 AM, John Meyer wrote:
>
>&g
=COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
On Mon, Sep 30, 2013 at 1:18 PM, John Meyer
wrote:
> So I guess I'm doing something wrong here.
>
> =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
>
> Returns an Err:501.
Sorry, that e-mail got sent off too quickly. I'm trying this formula
=COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,A2)
C1 contains the name of the worksheet ("09-27-13") and I'm trying to use
it. However, it keeps giving me an err:501.
On Mon, Sep 3
Derp, just saw that.
Thanks.
On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg wrote:
> 2013/9/30 John Meyer
>
> > Sorry, that e-mail got sent off too quickly. I'm trying this formula
> >
> > =COUNTIF(INDIRECT(ADDRESS(1,3,1,,"Bonuses")).$E$1:$E2000,
Still doesn't work. Back to the drawing board.
On Mon, Sep 30, 2013 at 2:32 PM, John Meyer
wrote:
> Derp, just saw that.
>
> Thanks.
>
>
> On Mon, Sep 30, 2013 at 2:01 PM, Johnny Rosenberg
> wrote:
>
>> 2013/9/30 John Meyer
>>
>> > Sorry,
Thou must unsubscribe thyself. Hearken to the instructions below, for
they shall lead you in the path of a less cluttered inbox.
On 9/30/2013 9:53 PM, Victor Nobert wrote:
Please unsuscribe me from the users open.office list. thank you. V. Nobert
From: emell...@gmail.com
Date: Fri, 27 Se
Same Err:501. I'll post up more in the office.
On 10/1/2013 8:11 AM, Johnny Rosenberg wrote:
2013/9/30 John Meyer
Still doesn't work. Back to the drawing board.
Exactly what does your current formula look like and what error message do
you get? Still 501?
Johnny Rosenberg
Okay, I've put up two screenshots.
the first contains the formula and what is listed in C1. The next is
the names of the individual sheets.
On 10/1/2013 8:21 AM, John Meyer wrote:
Same Err:501. I'll post up more in the office.
On 10/1/2013 8:11 AM, Johnny Rosenberg wrote:
On 10/1/2013 5:16 PM, Doug wrote:
I've just received an attachment consisting of an important legal
document as a .docx file. I downloaded Apache 4.0.1 and it won't
open the file. (Neither will Textmaker 2012 or WordPerfect 6.)
Since this is a personal file, I can't send it to you, but do you ha
http://i174.photobucket.com/albums/w108/pueblonative/FormulaError2_zps27abcf42.png
http://i174.photobucket.com/albums/w108/pueblonative/Formulaerror1_zpsda33a4c4.png
Here are the worksheet names and the formula I am using.
question, I can't use a database at work).
On 10/3/2013 10:36 AM, Brian Barker wrote:
At 08:47 03/10/2013 -0600, John Meyer wrote:
http://i174.photobucket.com/albums/w108/pueblonative/FormulaError2_zps27abcf42.png
http://i174.photobucket.com/albums/w108/pueblonative/Formulaerror1_zpsda33a4c
On 10/3/2013 11:42 AM, Brian Barker wrote:
At 10:59 03/10/2013 -0600, John Meyer wrote:
After looking over this problem a bit, I decided to scrap the sheet
name idea and just have all sales on one sheet.
sales are in this format:
DummyField, Date, DummyField, DummyField, SalesRep
For this
Strike that last e-mail, it worked.
On 10/3/2013 11:57 AM, John Meyer wrote:
On 10/3/2013 11:42 AM, Brian Barker wrote:
At 10:59 03/10/2013 -0600, John Meyer wrote:
After looking over this problem a bit, I decided to scrap the sheet
name idea and just have all sales on one sheet.
sales are
Okay, so I just needed one more step with Brian's problem. When I
imported the date from the web site, it also had the time portion. So, I
created another column and put a formula of QUOTIENT(B2;1) and formatted
that as a date. Voila, it works.
---
haven't had my first cup of coffee.
On 10/3/2013 12:41 PM, Brian Barker wrote:
At 12:14 03/10/2013 -0600, John Meyer wrote:
Okay, so I just needed one more step with Brian's problem.
Er, I don't remember having a problem! ;^)
When I imported the date from the web site, it al
Has anybody created a deployable MSI for OpenOffice?
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org
Hey guys:
I'm trying to get my office to upgrade. The IT staff says that they
need an MSI installer build. Is there one available?
Thanks.
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional comman
On 10/19/2013 7:46 AM, Henry Bohné wrote:
I recently upgraded from ver3.3 to ver 4.0.
I work with a big (2.2 MB) text file. With ver3.3 it took 5 to 9 minutes to
save the file, with ver4.0 it takes 29 minutes.
How can I speed it up?
I'm using Windows 7 as OS
Henry Bohné
On 10/20/2013 7:50 AM, Alexandro Colorado wrote:
I would rather think this file has large images that could be re-rendered or
externally linked. If its a huge spreadsheet probably transfer to a database.
In a text file?
-
T
Relevant tables and fields:
Agents
TSR Varchar(6)
Sales
SalesRep Varchar(6)
neither is a primary key (I'm having problems converting it to a primary
key when I import the data from a spread sheet).
I want to find out how many sales each agent got.
Statement:
SELECT "Agents"."TSR", "Age
Semi-solved, I think.
I managed to join the following:
SELECT "AGENTS"."AGENT_ID", COUNT(*) AS "Total Sales" FROM "AGENTS"
INNER JOIN "SALES" ON "AGENTS"."AGENT_ID"="SALES"."SALES_REP" GROUP BY
"AGENTS"."AGENT_ID"
The only problem is I can't seem to add the agent's name.
-
On 10/20/2013 1:14 PM, John Meyer wrote:
Semi-solved, I think.
I managed to join the following:
SELECT "AGENTS"."AGENT_ID", COUNT(*) AS "Total Sales" FROM "AGENTS"
INNER JOIN "SALES" ON "AGENTS"."AGENT_ID"="SALES"
On 10/20/2013 1:54 PM, Uwe Brauer wrote:
Hi
I googled a bit but found no solution to the problem
of rotating a table such that
| 1 | 2 | 3 |
| 4 | 3 | 4 |
becomes
| 4 | 1 |
| 3 | 2 |
| 4 | 3 |
Thanks
Uwe Brauer
http://wiki.openoffice.org/wiki/Documentation/How_Tos/Calc:_TRANSPOSE_funct
On 11/12/2013 2:11 PM, Urmas wrote:
"M. Fioretti":
may I respectfully suggest that a former "VP/CIO of IT and Telecom"
may be expected to know better than highjacking threads on a mailing
list...
It's just seasonal relapse.
Not to completely hijack this thread, but I don't think execs at th
On 11/12/2013 1:56 PM, Toni Caprari wrote:
I'm unable to open a text document that I drafted using office and saved in a
word 97 format.
This problem occurred after inserting "table" in various sections of the
document.
Now I get a pop up error message saying"This is not a winword 97 file"
Did
that?
Peter
On 11/13/2013 11:40 AM, Yolanda Lowery wrote:
users-unsubscr...@openoffice.apache.org
Yolanda LaCombe Lowery
Glendale, California 91201
From: John Meyer
To: users@openoffice.apache.org
Sent: Tuesday, November 12, 2013 1:27 PM
Subject: Re
On 11/14/2013 3:31 PM, Dennis Tuchler wrote:
Please read the attached document about a Mac program called Gatekeeper.
Adjust Gatekeeper as suggested and OO.org will be useable.
-
To unsubscribe, e-mail: users-unsubscr...@open
On 11/17/2013 6:01 AM, Malcolm Doughty wrote:
> I do not want these emails!
>
Just send an e-mail to the appropriate address below.
---
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mai
On 11/20/2013 7:13 AM, karen nonnecke wrote:
> -
> To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
> For additional commands, e-mail: users-h...@openoffice.apache.org
On 11/20/2013 4:07 PM, Joan Grey wrote:
Hi,
My OS is WIN 8 ( ugh!) and as a user of open office on a WIN 7 (gateway
tablet) I chose to load it onto my new ASUS laptop. This pc has been into the
shop 2 X since purchase 5 months ago and was wiped clean of ‘stuff’.
When first in use I loaded ALL
On 11/21/2013 10:09 PM, Jim & Shirley wrote:
I do not like the change in the new Open Office 4. To change the entire screen
to a new colored venue is distracting and delays both the installation and the
close of the program. It is pretty but not useful. Please change it back to
its prior sc
On 12/11/2013 5:41 PM, Jonathan Kalan wrote:
Please - everyone. It would be much better if you would stop using "reply
all" for this survey.
We don't all need to see every single response.
Thank you.
-
To unsubscribe, e-mail
On 12/12/2013 5:21 AM, Alan Rogers wrote:
How does one get off of this mailing list?
vvv
-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-ma
Actually, I was pointing that out to Alan.
On 12/12/2013 12:21 PM, Tom Backer Johnsen wrote:
John
Look at the lower part of the mails you are receiving from the list.
Tom
On 12. Dec 2013, at 18:53 , John Meyer wrote:
On 12/12/2013 5:21 AM, Alan Rogers wrote:
How does one get off of
it will unsubscribe you from the entire list.
On 12/12/2013 12:54 PM, Rochelle wrote:
but will that unsubscribe you to just this subject or all future OO
postings?
Rochelle Uchibori
House Manager
Honolulu Theatre for Youth
808 782-1955 cell
On Thu, Dec 12, 2013 at 9:25 AM, John Meyer
I think troll ist troll auf Deutsch odor English. Frisst du die Troll
nicht bitte!
On 12/19/2013 5:41 AM, TN Patriot wrote:
On Thu, 19 Dec 2013 09:29:33 +0100
"Stöver, Hans-Werner" wrote:
Hi,
The same happened to OpenOffice.
From a nice and good program you made a pack of shit.
So ke
Are you asking if you can ask OpenOffice to natively save in MSO format?
On 12/19/2013 11:47 AM, Johnny Rosenberg wrote:
2013/12/19 James Knott
Johnny Rosenberg wrote:
By the way, isn't there a setting somewhere where you can choose between
Apache OpenOffice file browser and your operating
On 1/4/2014 6:04 AM, natalie guttridge wrote:
Please help
My daughter has written a 2000 word essay. She saved it and then when she
opened it again the whole text has turned into hashtags...can anything be done?
Regards
Natalie
Sent from my iPad
-
On 1/4/2014 12:07 PM, Keith and Leisa Ferguson wrote:
I just found out about open office. It looks really great. I might be
getting a new computer and did not want spend the price of the computer on
MS Office. What I am needing to know is there a good email program out
there similar to Outlook
On 1/8/2014 1:47 PM, Robert Holtzman wrote:
On Wed, Jan 08, 2014 at 08:44:26AM -0600, TN Patriot wrote:
On Tue, 7 Jan 2014 19:47:54 -0500
"Think" wrote:
The fact that...
You go on, and on, and on, and on, blathering and whining when someone
disagrees
with you, yet anything you seem to
I'll have to bookmark that for later.
On Fri, May 23, 2014 at 9:32 AM, Ariel Constenla-Haile
wrote:
> Hello Jennifer,
>
> On Wed, May 21, 2014 at 04:00:19PM +, Mayers, Jennifer A. wrote:
> >
> > We noticed that there does not seem to be a word counter. This is
> > required for essays and so
43 matches
Mail list logo