Difference between revisions of "AdminDoc2.0"
(→Round difference of the hours at 5 minutes) |
(→Accountancy) |
||
Line 120: | Line 120: | ||
Club accounts are only bank line receiving money. | Club accounts are only bank line receiving money. | ||
+ | =Aircraft Type= | ||
+ | ==Tank== |
Revision as of 11:57, 11 January 2008
This page is dedicated to receive admin doc of release 2.0.
- Lors de l'import d'utilisateurs, contrairement à la version 1.2 où il y avait une série de check-box permettant de définir les paramètres par défaut, c'est les paramètres par défaut du club qui sont appliqués.
Contents
- 1 Flight hours computation
- 1.1 Formula
- 1.2 Examples
- 1.2.1 Difference of the hours
- 1.2.2 Difference of the counters
- 1.2.3 Round difference of the hours at (top) 5 minutes
- 1.2.4 Round difference of the hours at (bottom) 5 minutes
- 1.2.5 Round difference of the hours at (nearest) 5 minutes
- 1.2.6 Difference of the counters plus 5 minutes
- 1.2.7 Round difference of the counters at 10 hundreth
- 1.2.8 Greater between difference of the hours and difference of the counters
- 1.2.9 Greater between difference of the hours and round difference of the counters at 5 minutes
- 2 Pricing management
- 3 Accountancy
- 4 Aircraft Type
Flight hours computation
In all formula, due to difference with interpretaion of decimal separator in various personnal computer, all values must to write without decimal separator, use X/Y to obtain correct value
Do not forget that time is given in sexacentimal. So to convert in hours you have to divide by 600.
1 minute = 10 sexacentimals 5 minutes = 50 sexacentimals
1 hundredth of minute = 6 sexacentimals 10 hundredth of minute (=1 tenth of minute) = 60 sexacentimals
Example: for 100,10 €/h
10010*%DURATION/60000
to round at 5 minutes : roundCeil(X,50)
to round with 10 hundredths : roundCeil(X,60)
Formula
Variable name | description |
---|---|
%DURATION | flight time input into the form |
%COUNTER_DEPARTURE | counter departure input into the form |
%COUNTER_ARRIVAL | counter arrival input into the form |
Function | description | Example |
---|---|---|
max(a,b) | return the maximum between a and b | |
min(a,b) | return the minimum between a and b | |
abs(a) | return the absolute value of a | |
roundCeil(a,b) | return the a value round top to b | roundCeil(106,5) return 110 |
Examples
Difference of the hours
%DURATION
Difference of the counters
%COUNTER_ARRIVAL - %COUNTER_DEPARTURE
Round difference of the hours at (top) 5 minutes
roundCeil(%DURATION, 50)
Round difference of the hours at (bottom) 5 minutes
roundCeil(%DURATION - 40, 50)
Round difference of the hours at (nearest) 5 minutes
roundCeil(%DURATION - 20, 50)
Difference of the counters plus 5 minutes
%COUNTER_ARRIVAL - %COUNTER_DEPARTURE + 50
Round difference of the counters at 10 hundreth
roundCeil(%COUNTER_ARRIVAL - %COUNTER_DEPARTURE, 60)
Greater between difference of the hours and difference of the counters
max(%DURATION, %COUNTER_ARRIVAL - %COUNTER_DEPARTURE)
Greater between difference of the hours and round difference of the counters at 5 minutes
max(%DURATION,roundCeil(%COUNTER_ARRIVAL - %COUNTER_DEPARTURE, 50))
Pricing management
Formula
The formula knows following variables:
Variable name | description |
---|---|
%DURATION | Calculated duration recorded for the flight |
%COUNTER_DEPARTURE | counter departure recorded for the flight |
%COUNTER_ARRIVAL | counter arrival recorded for the flight |
Function | description | Example |
---|---|---|
max(a,b) | return the maximum between a and b | |
min(a,b) | return the minimum between a and b | |
abs(a) | return the absolute value of a | |
roundCeil(a,b) | return the a value round top to b | roundCeil(106,5) return 110 |
Example
- An aircraft with a cost of 94€ per flight hours, will have:
94*%DURATION/600
- An aircraft with a cost of 110€ per "counter" hours, will have:
110*(%COUNTER_ARRIVAL-%COUNTER_DEPARTURE)/600
Accountancy
Accountancy definition from wikipedia
double entry principle
double entry definition from wikipedia
What does OpenFlyers?
OpenFlyers' goal is to manage all clients bills and only clients bills (not the suppliers one).
Thus, you got members that make some flights. For each flight, OpenFlyers debit the member account and credit the aircraft account according to the flight hours pricing rules. (in some case, it can also credit the member account and debit another account).
Account presentation
Aircraft accounts
(in French: 7xxxxx account)
Aircraft accounts are only revenues account and should only have credit.
Member accounts
(in French: 411xxx account)
- Member accounts are debited by bills (flights, fees, ...)
- Member accounts are also credited by member payments (credit card, check, cash, ...)
When a member account is credited by payments, the other entry (debit) is made on a club account (according to the payment management)
Club accounts
(in French: 512xxx account)
Club accounts are only bank line receiving money.