Twilightpeaks.net

RoE General => The Sage (Questions & Answers) => : X-Boeruine/Ulric (Robert) February 28, 2012, 04:49:14 PM

: Excell DO help
: X-Boeruine/Ulric (Robert) February 28, 2012, 04:49:14 PM
So, I'm looking at the DO template, the army section and all I see there is an endlessly repeating series of "RAW #Value, #Value"....

I try entering armsmen and get their stats. Cool

However, there are only 28 spots there and, while this might be enough for Roesone, its not enough for Boeruine. If I try to insert a row below or above an existing line, I get didly squat. Even if I keep the formatting, the row doesn't work. I don't get any stats auto-filled.

Could you explain to a completely excell-clueless person how I'm supposed to add another 10,20,30,60,.... entries?
: Re: Excell DO help
: X-Tuornen/LF (Geir) February 28, 2012, 04:57:28 PM
sure I could
: Re: Excell DO help
: DM B February 28, 2012, 06:00:13 PM
Mark rows - say 151 to 165 - copy, insert copied cells. Done. You now have 15 more lines with correct formatting which also doesn't break any formulas.
: Re: Excell DO help
: X-Boeruine/Ulric (Robert) February 28, 2012, 07:05:29 PM
Managed to figure it out, finally :)
: Re: Excell DO help
: X-Coeranys/WD (Greg) February 28, 2012, 09:03:30 PM
That's good to know that it does break any reference cells from other worksheets - thanks, I learned something today (<-- =old dog, new trick).  ;)
: Re: Excell DO help
: X-Boeruine/Ulric (Robert) February 28, 2012, 09:54:57 PM
LOL, glad I could help.
: Re: Excell DO help
: X-Haelyn's Aegis/RK (Andy) February 28, 2012, 10:45:38 PM
Could you explain to a completely excell-clueless person how I'm supposed to add another 10,20,30,60,.... entries?

Going to war so soon dear chap?  Haven't you only just finished the last one?
: Re: Excell DO help
: X-Boeruine/Ulric (Robert) February 28, 2012, 10:49:44 PM
No Andy. I'm not going to war yet. Just counting and numbering my gazillions of ultra-marines..


Just in case..

You never know ;)
: Re: Excell DO help
: X-Avanil/Aubrae Avan (Thorsten) February 28, 2012, 10:50:12 PM
Could you explain to a completely excell-clueless person how I'm supposed to add another 10,20,30,60,.... entries?

Going to war so soon dear chap?  Haven't you only just finished the last one?

It's not officially over.
: Re: Excell DO help
: X-Boeruine/Ulric (Robert) February 28, 2012, 10:55:05 PM
It's not officially over.

See! Who's the warmongrel here?? ;)
: Re: Excell DO help
: X-Haelyn's Aegis/RK (Andy) February 28, 2012, 11:00:34 PM
Could you explain to a completely excell-clueless person how I'm supposed to add another 10,20,30,60,.... entries?

Going to war so soon dear chap?  Haven't you only just finished the last one?

It's not officially over.

Is it ever?  I'd say barring occasional marriages between the two of you but I guess that would just be opening up a new front rather than a true peace accord.
: Re: Excell DO help
: X-Osoerde (Alan) February 28, 2012, 11:11:19 PM
They would wage war over who gets to bring the sword to bed.
: Re: Excell DO help
: X-Brosengae [Cloene] (Linde) February 29, 2012, 12:26:54 AM

Could you explain to a completely excell-clueless person how I'm supposed to add another 10,20,30,60,.... entries?

I had the same problem when I played Ilien and mustered and/or levied every turn, so luckily it wasn't a problem for me to increase army/navy sizes when I got Brosengae
: Re: Excell DO help
: X-IHH/Wallac Isilviere (Kasper) March 16, 2012, 04:40:43 PM
Mark rows - say 151 to 165 - copy, insert copied cells. Done. You now have 15 more lines with correct formatting which also doesn't break any formulas.

How do I expand DO as to make space for say five more units ("gift" of 5 Irregulars from our beloved DM)? I can do the above copy paste but I would like to have more rows. I have only row 167 free to use now as row 168 is the Army Unit Total etc?
: Re: Excell DO help
: X-Tuornen/LF (Geir) March 16, 2012, 05:21:10 PM
insert

you insert new rows  :)
: Re: Excell DO help
: X-IHH/Wallac Isilviere (Kasper) March 16, 2012, 05:58:01 PM
Thx  :-[
: Re: Excell DO help
: DM B March 16, 2012, 10:18:44 PM
Mark rows - say 151 to 165 - copy, insert copied cells. Done. You now have 15 more lines with correct formatting which also doesn't break any formulas.

How do I expand DO as to make space for say five more units ("gift" of 5 Irregulars from our beloved DM)? I can do the above copy paste but I would like to have more rows. I have only row 167 free to use now as row 168 is the Army Unit Total etc?

The DM will remember to add them to your DO if you can't.
: Re: Excell DO help
: X-IHH/Wallac Isilviere (Kasper) March 16, 2012, 10:38:43 PM
Mark rows - say 151 to 165 - copy, insert copied cells. Done. You now have 15 more lines with correct formatting which also doesn't break any formulas.

How do I expand DO as to make space for say five more units ("gift" of 5 Irregulars from our beloved DM)? I can do the above copy paste but I would like to have more rows. I have only row 167 free to use now as row 168 is the Army Unit Total etc?

The DM will remember to add them to your DO if you can't.

Thank for your consideration :-)


I seems to have managed even to find the annoying locations you have put them originally so you can have your fun. I'll move them this season if you'll allow me using wage war action anyway
: Re: Excell DO help
: DM B March 16, 2012, 11:29:15 PM
They are your units, so you can move them :)
: Re: Excell DO help
: X-IHH/Wallac Isilviere (Kasper) March 16, 2012, 11:34:18 PM
They are your units, so you can move them :)

Aren’t you a dear?
: Re: Excell DO help
: X-Avanil/Aubrae Avan (Thorsten) March 24, 2012, 01:53:10 PM
Quick question:

I have a text box in my DO where my descriptions are in. But I now notice that sometimes the words are broken up, lines are moved down and some letters disappear. This happens quite often with the letter S or O.

For example the following sentence

“Uh..” Carpinter replied eloquently."

in my textbox is broken up, so that it appears as following:

“Uh..” Carpinter replied el

quently"

What's with that?
: Re: Excell DO help
: X-Avanil/Aubrae Avan (Thorsten) March 24, 2012, 01:58:06 PM
Quick question:

I have a text box in my DO where my descriptions are in. But I now notice that sometimes the words are broken up, lines are moved down and some letters disappear. This happens quite often with the letter S or O.

For example the following sentence

“Uh..” Carpinter replied eloquently."

in my textbox is broken up, so that it appears as following:

“Uh..” Carpinter replied el

quently"

What's with that?


Following up on this, if I turn the offending letter into a capital version, the lines are once more restored and unbroken.
: Re: Excell DO help
: X-Brosengae [Cloene] (Linde) March 24, 2012, 05:39:43 PM
It is a trick to keep you busy editing text instead of plotting for world domination
: Re: Excell DO help
: X-Avanil/Aubrae Avan (Thorsten) March 24, 2012, 05:40:56 PM
It is a trick to keep you busy editing text instead of plotting for world domination

It's working.
: Re: Excell DO help
: X-Osoerde (Alan) March 24, 2012, 06:46:39 PM
Thorsten, seems very kooky to me.

Do the cells have "Wrap Text" turns on or off?
: Re: Excell DO help
: DM B April 30, 2012, 02:11:41 PM
Can someone tell me where Cohesion went???
: Re: Excell DO help
: X-Points East April 30, 2012, 08:40:36 PM

Can someone tell me where Cohesion went???

OoC:

Cohesion can be found in the WAR worksheet.

: Re: Excell DO help
: DM B May 02, 2012, 11:04:08 AM
I found it shortly after my post.

It's a very sensible location; but I need to be able to track cohesion (not hits) in the asset tab.