Author Topic: Excell DO help  (Read 7717 times)

0 Members and 1 Guest are viewing this topic.

Offline X-Boeruine/Ulric (Robert)

  • Former players
  • Regent
  • *****
  • Posts: 634
  • Regency: 20
  • rkurelic at gmail.com
Excell DO help
« on: 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?

Offline X-Tuornen/LF (Geir)

  • Former players
  • Noble
  • ****
  • Posts: 455
  • Regency: 10
  • Gender: Male
  • Laela Flaertes, Duchess of Tuornen
Re: Excell DO help
« Reply #1 on: February 28, 2012, 04:57:28 PM »
sure I could
Laela Flaertes, By the Grace of Haelyn Duchess of Tuornen

- Geir
Tuornen / LF

Offline DM B

  • Green Knight
  • Deity
  • Emperor
  • *
  • Posts: 5.210
  • Regency: 51
  • Gender: Male
    • Twilightpeaks.net - Hone of Ruins of Empire
Re: Excell DO help
« Reply #2 on: 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.
DM Bjørn

Offline X-Boeruine/Ulric (Robert)

  • Former players
  • Regent
  • *****
  • Posts: 634
  • Regency: 20
  • rkurelic at gmail.com
Re: Excell DO help
« Reply #3 on: February 28, 2012, 07:05:29 PM »
Managed to figure it out, finally :)

Offline X-Coeranys/WD (Greg)

  • Former players
  • Scion
  • ***
  • Posts: 211
  • Regency: 4
  • Gender: Male
Re: Excell DO help
« Reply #4 on: 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).  ;)
William Deaulen
Baron of Coeranys
Count of Caudraight

Offline X-Boeruine/Ulric (Robert)

  • Former players
  • Regent
  • *****
  • Posts: 634
  • Regency: 20
  • rkurelic at gmail.com
Re: Excell DO help
« Reply #5 on: February 28, 2012, 09:54:57 PM »
LOL, glad I could help.

Offline X-Haelyn's Aegis/RK (Andy)

  • Former players
  • Regent
  • *****
  • Posts: 913
  • Regency: 42
  • Gender: Male
Re: Excell DO help
« Reply #6 on: 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?
Robhan Khaiarén
High Marshal of Haelyn's Aegis
Work hard, walk with honour, be justly rewarded

Offline X-Boeruine/Ulric (Robert)

  • Former players
  • Regent
  • *****
  • Posts: 634
  • Regency: 20
  • rkurelic at gmail.com
Re: Excell DO help
« Reply #7 on: 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 ;)

Offline X-Avanil/Aubrae Avan (Thorsten)

  • Former players
  • Sovereign
  • ******
  • Posts: 1.142
  • Regency: 35
  • Gender: Male
  • Princess Aubrae Avan
Re: Excell DO help
« Reply #8 on: 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.
Aubrae Avan,
Princess of Avanil, Duchess of Taeghas

Diplomacy is the art of letting someone else have your way.

Offline X-Boeruine/Ulric (Robert)

  • Former players
  • Regent
  • *****
  • Posts: 634
  • Regency: 20
  • rkurelic at gmail.com
Re: Excell DO help
« Reply #9 on: February 28, 2012, 10:55:05 PM »
It's not officially over.

See! Who's the warmongrel here?? ;)

Offline X-Haelyn's Aegis/RK (Andy)

  • Former players
  • Regent
  • *****
  • Posts: 913
  • Regency: 42
  • Gender: Male
Re: Excell DO help
« Reply #10 on: 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.
Robhan Khaiarén
High Marshal of Haelyn's Aegis
Work hard, walk with honour, be justly rewarded

Offline X-Osoerde (Alan)

  • The Dragon
  • Former players
  • Sovereign
  • ******
  • Posts: 1.394
  • Regency: 21
  • Gender: Male
Re: Excell DO help
« Reply #11 on: February 28, 2012, 11:11:19 PM »
They would wage war over who gets to bring the sword to bed.
Yes, wyrmling, the meat is made all the more tender by armor...

Offline X-Brosengae [Cloene] (Linde)

  • Former players
  • Noble
  • ****
  • Posts: 460
  • Regency: 19
  • Gender: Male
Re: Excell DO help
« Reply #12 on: 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

Offline X-IHH/Wallac Isilviere (Kasper)

  • Sovereign
  • ******
  • Posts: 1.607
  • Regency: 18
  • Gender: Male
  • Pontiff Wallac Isilviere, High Prefect of the IHH
Re: Excell DO help
« Reply #13 on: 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?
His Holiness Wallac Isilviere, Pontiff of All Anuire, High Prefect of the Impregnable Heart of Haelyn

Offline X-Tuornen/LF (Geir)

  • Former players
  • Noble
  • ****
  • Posts: 455
  • Regency: 10
  • Gender: Male
  • Laela Flaertes, Duchess of Tuornen
Re: Excell DO help
« Reply #14 on: March 16, 2012, 05:21:10 PM »
insert

you insert new rows  :)
Laela Flaertes, By the Grace of Haelyn Duchess of Tuornen

- Geir
Tuornen / LF