General Track and plan your Collections with a file! (upd. 12.feb.2018)

[Bob1977]

Hello everyone!
I'd like to introduce a simple xls table that helps in tracking and planning your Airport City Collections.
There are currently 241 Collections and sometimes beginners have difficulties to find their path through them even with many good manuals around. This is kind of a control panel to see the whole picture.
>> Blank table << (for game ver. 6.3.15)
My data (3o0 WP) as an example of file's usage, though outdated. I highlight high priority routes depending on current tasks.
Features of its sheets.

1. 'List'. All Collections are highlighted by their purpose: Power-Ups, Sky Captain, Quantum Leaps, Adventure Buildings, Events, Space, Alliance and Others. Their items and buildings are mentioned, important ones in bold text. New Collections are highlighted with red color.
2. 'Flights' helps you to plan your normal flights as it shows valuable items they give and requisition items they take.
3. 'Heli' is a list of the newly introduced Helicopter destinations.
   
4. 'Power-Ups' is an inventory sheet with according Collections. A small table of requisition flight items added.
   
5. 'SC' is dedicated to 2 old Sky Captain Bonus uber-collections (a collection of 5 collections each).
6. 'SC-AM' is a new pane for the 2 new (2017) Sky Captain Bonus uber-collections based on 50 new Alliance Mission flights.
   
7. 'Events' keeps count of events' collections and items with very brief events' description. Walkthroughs are easy to find here or in AC wikia. Event flights added (with some data missed).
   
8. 'Adv' is a large page for the main game's strategic plan (as I see it) - building Adventure Super Buildings which produce collectible items daily. Build all 96 and 'win' the game.
   
9. 'QL' is for 3 Quantum Leap ubercollections - "Green", "Blue" and "Red". Simple.
10. 'S3' is for Alliance Collections. Black S3 Planes building page.

Space Collections change so quickly no need to keep close watch on them. People usually know how many launches they can make and how much fuel left or don't care about both.
Other Collections are part of small side quests and mostly give only coins and experience.

The table is easy to modify to one's needs. Of course, with every passing event Collections' list has to be updated. Finally it represents a United Map for all platforms.

 

[Kesh]

Nice work, please note that there is one new adventure collection - tower of Babel

 

[Bob1977]

Blank file updated.

 

[Eric The Great]

Hello everyone!
I'd like to introduce a simple xls table that helps in tracking and planning your Airport City Collections.
There are currently 165 Collections and sometimes beginners have difficulties to find their path through them even with many good manuals around. This is kind of a control panel to see the whole picture.
>> Blank table <<
My data as an example of file's usage. I highlight high priority routes depending on current tasks.
Features of its sheets.

1. 'List'. All Collections are highlighted by their purpose: Power-Ups, Sky Captain, Quantum Leaps, Adventure Buildings, Events, Space, Alliance and Others. Their items and buildings are mentioned, important ones in bold text.
   
2. 'Power-Ups' is an inventory sheet with according Collections.
3. 'Events' keeps count of events' collections and items with very brief events' description. Walkthroughs are easy to find here or in AC wikia.
   
4. 'SC' is dedicated to 2 old Sky Captain Bonus ubercollections (a collection of 5 collections each).
5. 'Adv' is a large page for the main game's strategic plan (as I see it) - building Adventure Super Buildings which produce collectible items daily. Build all 84 and 'win' the game.
   
6. 'QL' is for 3 Quantum Leap ubercollections - "Green", "Blue" and "Red". Simple.

Space Collections change so quickly no need to keep close watch on them. People usually know how many launches they can make and how much fuel left or don't care about both.
Alliance Collections are top players' business usually and they don't need any files or guidance.
Other Collections are part of small side quests and mostly give only coins and experience.

The table is easy to modify to one's needs. Of course, with every passing event Collections' list has to be updated. It reflects PC/WP version of the game and probably varies from other platforms.

Bob,

I downloaded the spreadsheet and information is excellent. It works as a great reference tool for those of us too bothered/lazy to actually enter the data into a file, like me.

Thank you pulling this together.

Eric

 

[Bob1977]

File updated. Down the Rabbit Hole collections moved from 1-4 to 146-149.

 

[Bob1977]

I've made an interesting update to the file! The new sheet "Flights" shows you all ordinary flights with Sky Captain and Power-Up collections' items. Now it's even easier to contemplate your hunt progress, planning fleet's setup, directing efforts and such.
Items are highlighted according to each collection's and item's sum:
Few 0-4
Several 5-9
Pack 10-19 (hello, HoMM )
More than that is simply black. You can modify margins in X1, X2 and X3 cells.

 

[rocky]

big Job BOB and thank you

 

[Bob1977]

Having started to get first Alliance maps I thought 'Why not?' and added a page to watch over Alliance collections.
8 collections = 40 items and 40 maps, it seems convenient to check them in one glance.
File updated.

 

[Bob1977]

Updated! I added missing Bali items and fixed a couple of small bugs.

 

[Agent_L]

@Bob1977 Great job!
I would personally like collection number in other places too (like "p-ups"), not just "list" page, but I imagine it's only useful first time when the sheet is filled and after that it's not needed.

 

[Bob1977]

Although the great update is still on its way to PC and WP games I took the liberty to scout ahead and put new features
in >>> the special file <<<. It can be useful for players with updated AC game.

There are interesting things there. Does any one know something about Investment Bank from Hong Kong and Carpet Plane from Baghdad?

 

[crescent moon (RIP)]

Thank you @Bob1977
Your file has been especially helpful in planning adventure flights & flights for powerups. I'm anxious to see the new features the update will bring.

 

[Bob1977]

Thanks! I highlighted with red color new collections.
I'm glad I've not run for QL collections yet since there so many new buildings that go along the way!

 

[crescent moon (RIP)]

Wow - I think I'm actually getting excited about the new update! I hope they give us the mint/casino/bank offer soon, I need greens to buy more land for all those new buildings!!!!

 

[Kesh]

Wow - I think I'm actually getting excited about the new update! I hope they give us the mint/casino/bank offer soon, I need greens to buy more land for all those new buildings!!!!

I have a hunch that after they list all s2 offers they'll put some greenies building offer (giant and falcon is missing).
@Bob1977 - there is one info missing - number of passengers required for falcons and t-bird

 

[david smith]

I have a hunch that after they list all s2 offers they'll put some greenies building offer (giant and falcon is missing).
@Bob1977 - there is one info missing - number of passengers required for falcons and t-bird

sent invite from gameradar2

 

[david smith]

Thanks! I highlighted with red color new collections.
I'm glad I've not run for QL collections yet since there so many new buildings that go along the way!

sent invites to both ur games from gameradar2

 

[david smith]

@Bob1977 Great job!
I would personally like collection number in other places too (like "p-ups"), not just "list" page, but I imagine it's only useful first time when the sheet is filled and after that it's not needed.

please send invites lost u when updated

 

[Bob1977]

The File is updated with new features!
Total star count, requisite items for flights (margins set in Z1-Z3 of 'Flight' page), event flights (with some data missing).

 

[Husam]

Hello everyone!
I'd like to introduce a simple xls table that helps in tracking and planning your Airport City Collections.
There are currently 183 Collections and sometimes beginners have difficulties to find their path through them even with many good manuals around. This is kind of a control panel to see the whole picture.
>> Blank table << (with. T-Birds)
My data (3o0 WP) as an example of file's usage. I highlight high priority routes depending on current tasks.
Features of its sheets.

1. 'List'. All Collections are highlighted by their purpose: Power-Ups, Sky Captain, Quantum Leaps, Adventure Buildings, Events, Space, Alliance and Others. Their items and buildings are mentioned, important ones in bold text. New Collections are highlighted with red color.
2. 'Flights' helps you to plan your normal flights as it shows valuable items they give and requisition items they take.
   
3. 'Power-Ups' is an inventory sheet with according Collections. A small table of requisition flight items added.
   
4. 'SC' is dedicated to 2 old Sky Captain Bonus ubercollections (a collection of 5 collections each).
   
5. 'Events' keeps count of events' collections and items with very brief events' description. Walkthroughs are easy to find here or in AC wikia. Event flights added (with some data missed).
   
6. 'Adv' is a large page for the main game's strategic plan (as I see it) - building Adventure Super Buildings which produce collectible items daily. Build all 84 and 'win' the game.
   
7. 'QL' is for 3 Quantum Leap ubercollections - "Green", "Blue" and "Red". Simple.
8. 'S3' is for Alliance Collections. Black S3 Planes building page.

Space Collections change so quickly no need to keep close watch on them. People usually know how many launches they can make and how much fuel left or don't care about both.
Other Collections are part of small side quests and mostly give only coins and experience.

The table is easy to modify to one's needs. Of course, with every passing event Collections' list has to be updated. Finally it represents a United Map for all platforms.

Good job