02_FISTF Event Results file (replace old organization & results files)

Download

275 Downloads

Version: 4.6

Last Updated: 16-05-2024

Share
DescriptionPreview

Excel file to be sent to FISTF to communicate event organization & results.
Event results are not taken into account for the World Ranking until they are sent within this file.
Event results are not taken into account if data inside the file don’t respect formats.

This file has to be sent via the contact form on fistf.com and not sent by email.
Contact form is here : https://fistf.com/contact/contact-fistf-for-operations-sport-calendar-rankings/
don’t forget to specify ”Results” in the ”Your Recipient” field.

4.6 : Evolution : Change Ladies with Women
4.5.2 : Correction : Adding more lines in Open & Veterans tabs
4.5.1 : Correction : Different small modifications – List of values for Withdraw field in Team tab, ”TOSS” replaced by ”Players/Teams draw”, Group number corrected in Results Teams tab.
4.5 : Removal of the evaluation part in the TOURNAMENT DETAILS tab, and addition of payment details
4.4.1 :Correction : Compute of Barrage’s points (L??) for Individuals
4.4 : Evolution : Compatibility with Open Office => The file can be used with Open Office or Libre Office. Not fully tested with this free software, but seems to work.
4.3.1 : Correction : Conditional format on points equalities in individual groups
4.3 : Correction : List of values for Players in individual groups
         Evolutions : Some upgrades on worksheets layouts & colors
4.2 : Evolution : Add of Last 64 in Stage and conformity with HB ranking points for Last 64
4.1.3 : Correction : Bad count of won/lost matches & for/against goals in groups ranking for teams
4.1.2 : Correction : Control of FISTF Codes in Players list tabs
4.1.1 : Correction : No list of values for FISTF Codes
4.1: Evolution: Change of the possible values for withdrawals in category tabs; ””At Start”” & ””Excused””
””At Start””, means organisation was informed of the withdraw the day of competition. Even if there is an acceptable reason which avoid any penality, the entry fee is still to be paid.
””Excused”” says that player informed organisation with an acceptable reason and in a reasonable delay before the start of the event ; no penality and no fee”
4.0.2 : Correction : Bad column names in data requests
4.0.1 : Correction :
===> Tournament Details : formula correction to calculate number of participants
===> Results Individuals : Change formula of conditionnal format on column AD
4.0 : Evolution : Change of discount rate in accordance with HB 2023-2024
3.5.1 : Correction : Table names in Veterans … U12 tabs
V3.5: Added FISTF Code column in registration tabs in order to provide organizer with the possibility to fill either Player Name or either FISTF Code
V3.4:
===> Added Discounted amount of levies if paid before 14 days in ”Tournament Details” tab. => Start and End dates to be filled now to determine last day of 25% discount on levies.
===> Added highligth on points in groups in case of draw without Diff-Draw or Shout-out filled.
===> Correction in Team groups ranking calculation. Draw in groups were not considered before.
===> Correction in list of values in team groups for team name (before only club names were listed)V3.3.1: Correction : Bad Group Numbers in ”Results Individuals” 
V3.3:
===> Some small updates in ””Things not to forget””
===> Correction : format condition for players of teams => check players are in the Club but not in the Teams that is composed of Club Name plus ”” 2””, ”” 3””, …”
V3.2.1: Conditional Format correction for Teams in groups & Added Version tab for releases history
V3.2: Added list of choice for players in groups, for players in teams & for teams in groups 
V3.1:
===> Added more values in Category column for Results and highlighting
===> Added a section to report inappropriate behaviors in ”Tournament Details” tab
===> Password protection of all tabs to avoid wild copy/paste that destroys formulas
V3.0: Automatic group ranking for Teams 
V2.7: Correction : Individuals & Teams results tabs : adding som additional controls and warnings 
V2.6: Correction : ranking calculation for Teams 
V2.5: Correction : some score cell’s format was set to ”text”. Change to ”Standard” format. 
V2.4: Some minor changes and compatibility with new WR tables on fistf.com => This new version is mandatory for Tournaments.V2.3: #Team values in Teams tab are now A, B, C, D or E. The complete name is then ClubName, ClubName 2, … 
V2.2.1: Minors corrections
V2.2: precisions to refresh FISTF database tables (Players, Clubs & Nations) in the ”Things not to forget” tab

World Ranking 2024-05 after addition of GP Vienna results recieved on May 6

Download

138 Downloads

Version: 1.1

Last Updated: 08-05-2024

Share
DescriptionPreview

Licences & World Ranking at the end of April 2024 AFTER addition of GP VIenna recieved on May 6 => to be used for competitions on May 2024

World Ranking 2024-05

Download

112 Downloads

Version: 1.0

Last Updated: 03-05-2024

Share
DescriptionPreview

Licences & World Ranking at the end of April 2024 before addition of GP VIenna recieved on May 6