Welcome to the FTS Forum - Read the introduction here

Avatar
Please consider registering
Guest
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
sp_Feed
Topic Rating: +1 Topic Rating: +1 (1 votes) 
sp_TopicIcon
FDD MASTER FILES
Avatar
scotty7788
Beginner
Members

Accelerator 2020
Forum Posts: 12
Member Since:
February 16, 2019
sp_UserOfflineSmall Offline
1
March 18, 2020 - 10:47 am
sp_Permalink sp_Print
0

hi anyone know if theres any master files going to be realised in march?

Avatar
ArtTest
Moderator
Moderators

Members
Forum Posts: 227
Member Since:
March 6, 2016
sp_UserOfflineSmall Offline
2
March 18, 2020 - 5:16 pm
sp_Permalink sp_Print
0

They should be. Please email Ian if you don’t get them.

Avatar
simonmuir62
Beginner
Members

Accelerator 2020
Forum Posts: 26
Member Since:
June 3, 2019
sp_UserOfflineSmall Offline
3
March 19, 2020 - 12:04 pm
sp_Permalink sp_Print
+1

Now would be a great time to release them, all got plenty of time on our hands to dig into them.

Avatar
kopendkid
Beginner
Members
Forum Posts: 3
Member Since:
June 30, 2019
sp_UserOfflineSmall Offline
4
May 2, 2020 - 9:16 pm
sp_Permalink sp_Print
0

Hi, just need a bit of help with the FDD sheets. I’ve bought sheets for 17/18 & 18/19 and when I merge them with 19/20 I don’t seem to get any plus/minus figures when filtering each year. Any help greatly appreciated.

Avatar
ArtTest
Moderator
Moderators

Members
Forum Posts: 227
Member Since:
March 6, 2016
sp_UserOfflineSmall Offline
5
May 3, 2020 - 11:36 am
sp_Permalink sp_Print
0

Just a thought but do the ranges above each plus/minus cover the whole dataset? You might need to increase the right-most row number.

Avatar
kopendkid
Beginner
Members
Forum Posts: 3
Member Since:
June 30, 2019
sp_UserOfflineSmall Offline
6
May 3, 2020 - 1:21 pm
sp_Permalink sp_Print
0

Thanks Art for the reply. Yes I think they do but I’m not the brightest with excel. The only results of plus/minus figures I get is for the 19/20, the rest are showing 0. It must be the way I am copying and pasting them together but I’ve tried a few ways now but no joy.

Avatar
danny2
Beginner
Members
Forum Posts: 17
Member Since:
August 4, 2013
sp_UserOfflineSmall Offline
7
May 3, 2020 - 6:32 pm
sp_Permalink sp_Print
0

As Art says, the formula for adding the cells will only cover down to the row number of last result on that sheet. So when you paste another sheet on the end you will need to adjust the formula on the result figure to cover all the new rows. Easiest way I find is just to add a 0 on. Might be easier ways but I’m no expert either. If that doesn’t work then not sure. 

Avatar
kopendkid
Beginner
Members
Forum Posts: 3
Member Since:
June 30, 2019
sp_UserOfflineSmall Offline
8
May 3, 2020 - 11:51 pm
sp_Permalink sp_Print
0

Thanks Danny, got it figured out in the end.

Forum Timezone: Europe/London
Most Users Ever Online: 92
Currently Online: laticsmarra, deano12366, leewillo75
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Lord Dio: 108
leewillo75: 67
des911: 62
@capitalchrisw: 61
jamiep: 48
Callum: 48
chasanddave: 48
gurds1991: 48
Neil: 41
Beeble: 39
Newest Members:
beckyb1977
leticia
natashaka
armandodiush
johnathan
thommytanker
film-pp
annzef
wallabies
nakhla
Forum Stats:
Groups: 5
Forums: 24
Topics: 227
Posts: 1769

 

Member Stats:
Guest Posters: 3
Members: 4601
Moderators: 2
Admins: 2
Administrators: Ian, Geeky Boy
Moderators: ArtTest, davefts