Closer estimation at costs.

1 files changed, 144 insertions, 113 deletions

diff --git a/data/2014/europe.ttl b/data/2014/europe.ttl
index a195e03..79ab496 100644
--- a/data/2014/europe.ttl
+++ b/data/2014/europe.ttl
@@ -518,7 +518,7 @@
 	gr:hasMaxCurrencyValue "398"^^xsd:float .
 
 :subsidy-debianJonas a payment:Payment ;
-	rdfs:label "Debian sponsorship Paris <-> Barcelona for Jonas"@en ;
+	rdfs:label "Debian sponsorship Paris <-> Barcelona and Paris -> Brussels for Jonas"@en ;
 	payment:payer :org-debian ;
 	payment:payee :person-jonas ;
 	payment:expenditureLine [ a payment:ExpenditureLine ;
@@ -534,8 +534,11 @@
 		payment:payment :offer-sncfBarcelonaParisSeat ;
 		payment:netAmount "26.50"^^xsd:decimal
 	], [ a payment:ExpenditureLine ;
-		rdfs:comment "calculated discount, based on actual Interrail ticket price and list prices of actual rides: 352.20/???"@en ;
-#		payment:netAmount "-??"^^xsd:decimal
+		payment:payment :offer-sncfParisBrusselsSeat ;
+		payment:netAmount "30"^^xsd:decimal
+	], [ a payment:ExpenditureLine ;
+		payment:payment :share-debianJonas ;
+		payment:netAmount "??"^^xsd:decimal
 	] ;
 	payment:totalNetAmount "??"^^xsd:decimal .
 
@@ -544,43 +547,55 @@
 	payment:payer :org-debian ;
 	payment:payee :person-siri ;
 	payment:expenditureLine [ a payment:ExpenditureLine ;
+		payment:payment :offer-dbHolbækCologne ;
+		payment:netAmount "79.25"^^xsd:decimal
+	], [ a payment:ExpenditureLine ;
+		payment:payment :offer-sncfBrusselsParisSeat ;
+		payment:netAmount "30"^^xsd:decimal
+	], [ a payment:ExpenditureLine ;
+		payment:payment :offer-sncfParisBarcelonaSeat ;
+		payment:netAmount "26.50"^^xsd:decimal
+	], [ a payment:ExpenditureLine ;
+		payment:payment :offer-sncfBarcelonaParisSeat ;
+		payment:netAmount "26.50"^^xsd:decimal
+	], [ a payment:ExpenditureLine ;
+		payment:payment :offer-sncfParisBrusselsSeat ;
+		payment:netAmount "30"^^xsd:decimal
+	], [ a payment:ExpenditureLine ;
+		payment:payment :offer-dbCologneHolbæk ;
+		payment:netAmount "79.25"^^xsd:decimal
+	], [ a payment:ExpenditureLine ;
 		payment:payment :offer-dbInterrail10 ;
-		payment:netAmount "339.00"^^xsd:decimal
+		payment:netAmount "339"^^xsd:decimal
 	] ;
-	payment:totalNetAmount "339.00"^^xsd:decimal .
+	payment:totalNetAmount "610.50"^^xsd:decimal .
 
 :subsidy-greens a payment:Payment ;
-	rdfs:label "Greens/EFA sponsorship Paris -> Brussels -> Holbæk for Jonas"@en ;
+	rdfs:label "Greens/EFA sponsorship Holbæk <-> Cologne for Jonas"@en ;
 	payment:payer :org-greens ;
 	payment:payee :person-jonas ;
 	payment:expenditureLine [ a payment:ExpenditureLine ;
-		payment:payment :offer-sncfParisBrussels ;
-		payment:netAmount "99.00"^^xsd:decimal
+		payment:payment :offer-dbBahncard25Probe ;
+		payment:netAmount "25"^^xsd:decimal
 	], [ a payment:ExpenditureLine ;
-		payment:payment :offer-dbBrusselsCologne ;
-		payment:netAmount "53.00"^^xsd:decimal
+		payment:payment :offer-dbHolbækCologne ;
+		payment:netAmount "79.25"^^xsd:decimal
 	], [ a payment:ExpenditureLine ;
 		payment:payment :offer-dbCologneHolbæk ;
-		payment:netAmount "154.00"^^xsd:decimal
-	], [ a payment:ExpenditureLine ;
-		rdfs:comment "calculated discount, based on actual Interrail ticket price and list prices of actual rides: 306/???"@en ;
-#		payment:netAmount "-??"^^xsd:decimal
+		payment:netAmount "79.25"^^xsd:decimal
 	] ;
-	payment:totalNetAmount "??"^^xsd:decimal .
+	payment:totalNetAmount "184.50"^^xsd:decimal .
 
 :subsidy-epfsug a payment:Payment ;
-	rdfs:label "EPFSUG sponsorship Holbæk -> Brussels for Jonas"@en ;
+	rdfs:label "EPFSUG sponsorship Cologne -> Brussels and Paris -> Brussels for Jonas"@en ;
 	payment:payer :org-epfsug ;
 	payment:payee :person-jonas ;
 	payment:expenditureLine [ a payment:ExpenditureLine ;
-		payment:payment :offer-dbHolbækCologne ;
-		payment:netAmount "154.00"^^xsd:decimal
-	], [ a payment:ExpenditureLine ;
-		payment:payment :offer-dbCologneBrussels ;
-		payment:netAmount "53.00"^^xsd:decimal
+		payment:payment :offer-sncfParisBrusselsSeat ;
+		payment:netAmount "30"^^xsd:decimal
 	], [ a payment:ExpenditureLine ;
-		rdfs:comment "calculated discount, based on actual Interrail ticket price and list prices of actual rides: 207/???"@en ;
-#		payment:netAmount "-??"^^xsd:decimal
+		payment:payment :share-epfsug ;
+		payment:netAmount "??"^^xsd:decimal
 	] ;
 	payment:totalNetAmount "??"^^xsd:decimal .
 
@@ -590,13 +605,13 @@
 	payment:payee :person-jonas ;
 	payment:expenditureLine [ a payment:ExpenditureLine ;
 		payment:payment :offer-sncfBrusselsParisSeat ;
-		payment:netAmount "30.00"^^xsd:decimal
+		payment:netAmount "30"^^xsd:decimal
 	], [ a payment:ExpenditureLine ;
 		payment:payment :offer-taxiParisFromBrussels ;
 		payment:netAmount "40"^^xsd:decimal
 	], [ a payment:ExpenditureLine ;
-		rdfs:comment "calculated discount, based on actual Interrail ticket price and list prices of actual rides: 99/???"@en ;
-#		payment:netAmount "??"^^xsd:decimal
+		payment:payment :share-fosdem ;
+		payment:netAmount "??"^^xsd:decimal
 	] ;
 	payment:totalNetAmount "??"^^xsd:decimal .
 
@@ -626,20 +641,6 @@
 		tio:accessTo :train-roskildeHolbæk
 	] .
 
-:ticket-dsbPadborgRoskilde a tio:TicketPlaceholder ;
-	rdfs:label "Train ticket from Padborg to Roskilde"@en ;
-	tio:scope [ a tio:scopeOfAccess ;
-		tio:eligibleServiceLevel tio:Economy ;
-		tio:accessTo :train-padborgRoskilde
-	] .
-
-:ticket-dbPadborgRoskilde a tio:TicketPlaceholder ;
-	rdfs:label "Train ticket from Padborg to Roskilde"@en ;
-	tio:scope [ a tio:scopeOfAccess ;
-		tio:eligibleServiceLevel tio:Economy ;
-		tio:accessTo :train-padborgRoskilde
-	] .
-
 :ticket-dbRoskildeCologne a tio:TicketPlaceholder ;
 	rdfs:label "Train ticket from Roskilde to Cologne"@en ;
 	tio:scope [ a tio:scopeOfAccess ;
@@ -664,20 +665,6 @@
 		tio:accessTo :train-brusselsCologne
 	] .
 
-:ticket-dbPadborgAachen a tio:TicketPlaceholder ;
-	rdfs:label "Train ticket from Padborg to Aachen"@en ;
-	tio:scope [ a tio:scopeOfAccess ;
-		tio:eligibleServiceLevel tio:Economy ;
-		tio:accessTo :train-padborgAachen
-	] .
-
-:ticket-dbAachenBrussels a tio:TicketPlaceholder ;
-	rdfs:label "Train ticket from Aachen to Brussels"@en ;
-	tio:scope [ a tio:scopeOfAccess ;
-		tio:eligibleServiceLevel tio:Economy ;
-		tio:accessTo :train-aachenBrussels
-	] .
-
 :ticket-dbInterrail10 a tio:TicketPlaceholder ;
 	rdfs:label "InterRail 10 days within 22 days"@en ;
 	tio:scope [ a tio:scopeOfAccess ;
@@ -817,20 +804,6 @@
 	tio:from :station-roskilde ;
 	tio:to :station-holbæk .
 
-:train-padborgAachen a rail:Train ;
-	tio:operatedBy :org-db ;
-	tio:from :station-padborg ;
-	tio:to :station-aachen .
-
-:train-aachenBrussels a rail:Train ;
-	tio:operatedBy :org-db ;
-	tio:from :station-aachen ;
-	tio:to :station-brussels .
-
-:train-padborgRoskilde a rail:Train ;
-	tio:from :station-padborg ;
-	tio:to :station-roskilde .
-
 :taxi-parisFromBrussels a tio:Taxi ;
 	tio:from :station-parisNord ;
 	tio:to :place-irill .
@@ -843,17 +816,6 @@
 	tio:from :station-barcelona ;
 	tio:to :place-venueBcn2014 .
 
-:offer-dsbPadborgHolbækPlain a gr:Offering ;
-	gr:name "Holbæk-Padborg plain"@en ;
-	gr:description "Non-discount train ticket from Padborg to Holbæk"@en ;
-	gr:includes :ticket-dsbRoskildeHolbæk, :ticket-dsbPadborgRoskilde ;
-	gr:hasBusinessFunction gr:Sell ;
-	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
-		rdfs:comment "DKK384 is approx. €52"@en ;
-		gr:hasCurrency "DKK"@en ;
-		gr:hasCurrencyValue "384"^^xsd:float
-	] .
-
 :offer-dbBahncard25Probe a gr:Offering ;
 	gr:name "Probe-BahnCard 25"@en ;
 	gr:description "BahnCard 25 valid for 4 months"@en ;
@@ -906,38 +868,19 @@
 		gr:hasCurrencyValue "99"^^xsd:float
 	] .
 
-:offer-dbPadborgBrusselsPlain a gr:Offering ;
-	gr:name "Padborg-Brussels plain"@en ;
-	gr:description "Non-discount train ticket from Padborg to Brussels"@en ;
-	gr:includes :ticket-dbPadborgAachen, :ticket-dbAachenBrussels ;
-	gr:hasBusinessFunction gr:Sell ;
-	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
-		gr:hasCurrency "EUR"@en ;
-		gr:hasCurrencyValue "85"^^xsd:float
-	] .
-
-:offer-dbCologneBrussels a gr:Offering ;
-	gr:name "Cologne-Brussels"@en ;
-	gr:description "Train ticket from Cologne to Brussels"@en ;
+:offer-dbCologneBrusselsPlain a gr:Offering ;
+	gr:name "Cologne-Brussels plain"@en ;
+	gr:description "Non-discount train ticket from Cologne to Brussels"@en ;
 	gr:includes :ticket-dbCologneBrussels ;
 	gr:hasBusinessFunction gr:Sell ;
 	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
 		gr:hasCurrency "EUR"@en ;
-		gr:hasCurrencyValue "19"^^xsd:float
-	], [ a gr:UnitPriceSpecification ;
-		gr:hasCurrency "EUR"@en ;
-		gr:hasCurrencyValue "29"^^xsd:float
-	], [ a gr:UnitPriceSpecification ;
-		gr:hasCurrency "EUR"@en ;
-		gr:hasCurrencyValue "34"^^xsd:float
-	], [ a gr:UnitPriceSpecification ;
-		gr:hasCurrency "EUR"@en ;
-		gr:hasCurrencyValue "39"^^xsd:float
+		gr:hasCurrencyValue "53"^^xsd:float
 	] .
 
-:offer-dbBrusselsCologne a gr:Offering ;
-	gr:name "Brussels-Cologne"@en ;
-	gr:description "Train ticket from Brussels to Cologne"@en ;
+:offer-dbBrusselsColognePlain a gr:Offering ;
+	gr:name "Brussels-Cologne plain"@en ;
+	gr:description "Non-discount train ticket from Brussels to Cologne"@en ;
 	gr:includes :ticket-dbBrusselsCologne ;
 	gr:hasBusinessFunction gr:Sell ;
 	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
@@ -1041,6 +984,102 @@
 		gr:hasCurrencyValue "13.35"^^xsd:float
 	] .
 
+:offer-interrailPlain a gr:Offering ;
+	gr:name "Plain tickets matching all sponsored interrail rides"@en ;
+	gr:description """Non-discount ticket expenses for equivalent rides as all actual sponsored interrail rides.
+Cologne <-> Brussels: 106
+Brussels <-> Paris: 198
+Paris <-> Barcelona: 352.20"""@en ;
+	gr:includes :ticket-dbCologneBrussels, :ticket-dbBrusselsCologne,
+		:ticket-thalysBrusselsParis, :ticket-thalysParisBrussels,
+		:ticket-renfeParisBarcelona, :ticket-renfeBarcelonaParis ;
+	rdfs:seeAlso :offer-dsbCologneBrusselsPlain,
+		:offer-dsbBrusselsColognePlain,
+		:offer-sncfBrusselsParisPlain,
+		:offer-sncfParisBrusselsPlain,
+		:offer-sncfParisBarcelonaPlain,
+		:offer-sncfBarcelonaParisPlain ;
+	gr:hasBusinessFunction gr:Sell ;
+	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
+		gr:hasCurrency "EUR"@en ;
+		gr:hasCurrencyValue "656.20"^^xsd:float
+	] .
+
+:offer-debianJonasPlain a gr:Offering ;
+	gr:name "Plain tickets matching interrail rides sponsored by Debian for Jonas"@en ;
+	gr:description """Non-discount ticket expenses for equivalent rides as actual interrail rides sponsored by Debian for Jonas.
+Paris <-> Barcelona: 352.20
+Paris -> Brussels: 99"""@en ;
+	gr:includes :ticket-renfeParisBarcelona, :ticket-renfeBarcelonaParis ;
+	rdfs:seeAlso :offer-sncfParisBarcelonaPlain,
+		:offer-sncfBarcelonaParisPlain ;
+	gr:hasBusinessFunction gr:Sell ;
+	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
+		gr:hasCurrency "EUR"@en ;
+		gr:hasCurrencyValue "451.20"^^xsd:float
+	] .
+
+:offer-epfsugPlain a gr:Offering ;
+	gr:name "Plain tickets matching interrail rides sponsored by EPFSUG"@en ;
+	gr:description """Non-discount ticket expenses for equivalent rides as actual interrail rides sponsored by EPFSUG.
+Cologne <-> Brussels: 106"""@en ;
+	gr:includes :ticket-dbCologneBrussels, ticket-thalysParisBrussels ;
+	rdfs:seeAlso :offer-dbCologneBrusselsPlain,
+		offer-sncfParisBrusselsPlain ;
+	gr:hasBusinessFunction gr:Sell ;
+	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
+		gr:hasCurrency "EUR"@en ;
+		gr:hasCurrencyValue "106"^^xsd:float
+	] .
+
+:offer-fosdemPlain a gr:Offering ;
+	gr:name "Plain tickets matching interrail rides sponsored by FOSDEM"@en ;
+	gr:description """Non-discount ticket expenses for equivalent rides as actual interrail rides sponsored by FOSDEM.
+Brussels -> Paris: 99"""@en ;
+	gr:includes :ticket-thalysBrusselsParis ;
+	rdfs:seeAlso :offer-sncfBrusselsParisPlain ;
+	gr:hasBusinessFunction gr:Sell ;
+	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
+		gr:hasCurrency "EUR"@en ;
+		gr:hasCurrencyValue "99"^^xsd:float
+	] .
+
+:share-debianJonas a gr:Offering ;
+	gr:name "Share of interrail ticket expenses sponsored by Debian for Jonas"@en ;
+	gr:description "Share of interrail expenses, estimated from non-discount prices of equivalent rides"@en ;
+	rdfs:comment "339 * 451.20 / 656.20"@en ;
+	rdfs:seeAlso :offer-dbInterrail10, :offer-interrailPlain,
+		:offer-debianJonasPlain ;
+	gr:hasBusinessFunction gr:Sell ;
+	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
+		gr:hasCurrency "EUR"@en ;
+		gr:hasCurrencyValue "??"^^xsd:float
+	] .
+
+:share-epfsug a gr:Offering ;
+	gr:name "Share of interrail ticket expenses sponsored by EPFSUG"@en ;
+	gr:description "Share of interrail expenses, estimated from non-discount prices of equivalent rides"@en ;
+	rdfs:comment "339 * 106 / 656.20"@en ;
+	rdfs:seeAlso :offer-dbInterrail10, :offer-interrailPlain,
+		:offer-epfsugPlain ;
+	gr:hasBusinessFunction gr:Sell ;
+	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
+		gr:hasCurrency "EUR"@en ;
+		gr:hasCurrencyValue "??"^^xsd:float
+	] .
+
+:share-fosdem a gr:Offering ;
+	gr:name "Share of interrail ticket expenses sponsored by FOSDEM"@en ;
+	gr:description "Share of interrail expenses, estimated from non-discount prices of equivalent rides"@en ;
+	rdfs:comment "339 * 99 / 656.20"@en ;
+	rdfs:seeAlso :offer-dbInterrail10, :offer-interrailPlain,
+		:offer-fosdemPlain ;
+	gr:hasBusinessFunction gr:Sell ;
+	gr:hasPriceSpecification [ a gr:UnitPriceSpecification ;
+		gr:hasCurrency "EUR"@en ;
+		gr:hasCurrencyValue "??"^^xsd:float
+	] .
+
 :members-bahncard25 a gr:BusinessEntityType;
 	rdfs:label "Holders of DB Bahncard25 discount cards"@en .
 
@@ -1109,10 +1148,6 @@
 	foaf:name "Siri Reiter" ;
 	foaf:Homepage <http://sirireiter.dk/> .
 
-:station-aachen a rail:Station ;
-	rdfs:label "Aachen Hbf" ;
-	rail:serves dbpedia:Aachen .
-
 :station-barcelona a rail:Station ;
 	rdfs:label "Barcelona Sants" ;
 	rail:serves dbpedia:Barcelona .
@@ -1129,10 +1164,6 @@
 	rdfs:label "Holbæk station" ;
 	rail:serves dbpedia:Holbæk .
 
-:station-padborg a rail:Station ;
-	rdfs:label "Paderborn Hbf"@de ;
-	rail:serves dbpedia:Padborg .
-
 :station-parisLyon a rail:Station ;
 	rdfs:label "Paris-Gare de Lyon" ;
 	rail:serves dbpedia:Paris .