Army List Generator

General discussion forum for anything related to Field of Glory Renaissance Wars.

Moderators: hammy, Slitherine Core, FOGR Design

quackstheking
1st Lieutenant - 15 cm sFH 18
1st Lieutenant - 15 cm sFH 18
Posts: 844
Joined: Tue Jul 20, 2010 2:41 pm
Location: Hertfordshire, England

Post by quackstheking » Thu Mar 24, 2011 12:59 pm

Hi -

I've just checked the sort in BG March order and it worked OK for me. I only highlighed Columns A to K. The spreadsheet moves around correctly the base points and BG totals.

When I tried highlighing past column K it didn't work as those are protected cells.

A great resource which does all I need and use every time.

Thanks for all the hard work. :)

Don

Three
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 216
Joined: Fri Apr 25, 2008 7:30 pm

Post by Three » Sat Mar 26, 2011 3:52 pm

I still can't get it to work, and when I tried to print it anyway it came out as a small, unreadable box in the middle of the page. I know it must be me, but everything that is described above I can do easily on the FoG:AM one by Olivier, but not with this one (actually, either of the two R ones).

Back to the scribble pad.

petedalby
Lieutenant-General - Do 217E
Lieutenant-General - Do 217E
Posts: 3036
Joined: Mon Sep 18, 2006 5:23 pm
Location: Fareham, UK

Post by petedalby » Sat Mar 26, 2011 4:04 pm

There is nothing more frustrating than technology when it won't work for you.

Whereabouts are you based?
Pete

Three
Sergeant - 7.5 cm FK 16 nA
Sergeant - 7.5 cm FK 16 nA
Posts: 216
Joined: Fri Apr 25, 2008 7:30 pm

Post by Three » Sat Mar 26, 2011 10:05 pm

450 miles/7hours and 28 minutes north of you, according to Google maps :!: :lol:

kevinj
Major-General - Tiger I
Major-General - Tiger I
Posts: 2379
Joined: Sun Feb 25, 2007 11:21 am
Location: Derbyshire, UK

Post by kevinj » Thu Mar 31, 2011 2:50 pm

Hi Paul, this is really good. Would it be possible to include somewhere at the top to add the name of an Ally?

daveallen
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 542
Joined: Sat Dec 09, 2006 9:21 am

Post by daveallen » Fri Apr 01, 2011 6:56 am

Two Problems I experienced this morning:

1. Commanded Shot come out at one point less than they should

2. Artillery completely mess up the calculation column, giving a N/A result

Since neither has been complained of by others I'm thinking it might be because I'm using Excel 1997-2003. Will try again on a 2007 machine and let you know.

Regards,

Dave Allen

daveallen
Master Sergeant - U-boat
Master Sergeant - U-boat
Posts: 542
Joined: Sat Dec 09, 2006 9:21 am

Post by daveallen » Fri Apr 01, 2011 7:20 am

Whoops - just found the purpose of the BG Type column....

And I hadn't filled in the quality type for my artillery.

Sorry for any trouble...

Dave

timmy1
Lieutenant-General - Nashorn
Lieutenant-General - Nashorn
Posts: 3436
Joined: Fri Feb 29, 2008 8:39 pm
Location: Chelmsford, Essex, England

Post by timmy1 » Sun Apr 10, 2011 11:19 am

Found a small error in versions 2.7 and 2.8.

Cell P2 where it is summing the BG Points Values, is selecting N10 to N45 but N46 is not included. Understand why but in that case A46-K46 should be protected as otherwise it does not make clear that they are not included. When used in anger I can't see that being a problem but I was playing around with some of the C&C Indians and needed to save a row somewhere but it did not add up correctly.

PyrrhicVictory
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 35
Joined: Mon Jun 30, 2008 4:18 pm

Post by PyrrhicVictory » Sun Apr 10, 2011 2:33 pm

I seem to be having an issue with the costs of pike and shot regiments coming out right. In the books, the MF Musket troops are 8 points, but the sheet always comes out to 7. I was looking at a Later Thirty Years German list from Wars of Religion. I have tried listing the MF musket troops first and second. I made sure the BG is numbered. It seems that the 1 point for shot being in a BG with pike is not being added. Of course, just calling the Infantry Regiment a "Swedish Brigade" adds the points to make the costs correct.

Am I the only one?

timmy1
Lieutenant-General - Nashorn
Lieutenant-General - Nashorn
Posts: 3436
Joined: Fri Feb 29, 2008 8:39 pm
Location: Chelmsford, Essex, England

Post by timmy1 » Sun Apr 10, 2011 7:30 pm

I don't have that problem using Excel 2007 on Windows Vista. Do you enter pike in both the impact and melee columns for the HF? That works for me.

Vespasian28
Master Sergeant - Bf 109E
Master Sergeant - Bf 109E
Posts: 477
Joined: Fri Nov 02, 2007 9:04 pm

Post by Vespasian28 » Fri Apr 22, 2011 3:25 pm

I have tried listing the MF musket troops first and second. I made sure the BG is numbered. It seems that the 1 point for shot being in a BG with pike is not being added.
Just had the same problem but simply solved. Just make sure both lines representing your BG have the same number in the BG# column.

hazelbark
General - Carrier
General - Carrier
Posts: 4957
Joined: Tue Feb 13, 2007 9:53 pm
Location: Capital of the World !!

Post by hazelbark » Wed May 18, 2011 8:07 pm

Any chance of getting the password to unlock this spreadsheet.

Its just very small for the eyes.

list_lurker
Major - Jagdpanther
Major - Jagdpanther
Posts: 1003
Joined: Tue Sep 26, 2006 8:51 am
Contact:

Post by list_lurker » Mon May 23, 2011 4:36 pm

Hi Paul

small bug, the worksheet can't seem to handle multiple impact types, Salvo + Bayonet for instance

also, could we get more lines? 46 is just not enough - lest not for my crappy Korean list with a lot of BGs having 3 lines, and a lot of poor troops

Ta

Simon

hazelbark
General - Carrier
General - Carrier
Posts: 4957
Joined: Tue Feb 13, 2007 9:53 pm
Location: Capital of the World !!

Post by hazelbark » Wed Jul 06, 2011 5:55 pm

Superior Pike and Shot units must list the pike line first to get the cost right for the muskets.

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Version 2.9 now published

Post by shangtuming » Sun Sep 04, 2011 7:20 pm

Hello all.

Been snowed under with work and houshold projects over the summer but have finally got round to upgrading the the FoG-R list generator.

Line 46 is now added correctly (Bring on the Indians!)
Allies can now be listed and I have added some instructional comments which might help.

The Impact + Bayonet is a bit more involved and will have to wait for the next version. _ If I am wrong in my belief this does not affect the points values then let me know and I will move it up the priority list.

Not sure about the Superior Pike + shot. It seems to work for me. - Has anyone else had this problem?

Paul :D

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

More Lines!

Post by shangtuming » Sun Sep 04, 2011 7:30 pm

Extra 10 lines added to "Large Army Tab" sorry no Magnifying glass!

Paul

timmy1
Lieutenant-General - Nashorn
Lieutenant-General - Nashorn
Posts: 3436
Joined: Fri Feb 29, 2008 8:39 pm
Location: Chelmsford, Essex, England

Post by timmy1 » Sun Sep 04, 2011 8:06 pm

Paul

Sadly I did have this problem with my Britcon list submission. I had to redo it to get the list right. PM me if you want me to send you a copy showing the error.

Regards
Tim

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Pike + Shot points

Post by shangtuming » Sun Sep 04, 2011 9:53 pm

Thanks I will have a look at the example.

On a general point;

All multi row Battle Groups will only calculate additional points if rows are marked as the same number in the BG# column.

Shot Points will be correct when entering pike first because Excel sees the Blank BG# cells as being the same number (0).

Paul :)

rich
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 30
Joined: Wed Aug 05, 2009 7:12 pm

Post by rich » Thu Sep 22, 2011 12:33 pm

Paul

I assisted Olivier to re-design the interface for the FOGAM army list generator he developed.
Olivier did the hard work making it work I just helped him make it look nice.

Let me know if you are interested in me helping you with the FOGR generator interface.

Rich

shangtuming
Corporal - 5 cm Pak 38
Corporal - 5 cm Pak 38
Posts: 49
Joined: Sun Feb 11, 2007 5:10 pm

Post by shangtuming » Sun Sep 25, 2011 6:07 pm

Thanks for the offer.

I have been looking at this, but the need to squeeze so many lines on a page leaves precious little space for decoration.

I am working on a version that allows multiple page printing but maitains continuity with the army details - otherwise it could become a list checkers nightmare!

Post Reply

Return to “Field of Glory : Renaissance Wars : General Discussion”