 the state of the project talk is a traditional one goes over the The numbers some of the numbers about the the community the market where we are some of the markets about some of the numbers about the Technology around us who is using it and so on and so forth I try to update it with the with numbers every year some of the numbers Unfortunately are not entirely new, but I think it's important for everyone to be aware of Of our position in the market So the first is not a real number, but is about the annual report so the annual report you find the 2021 annual report on the website on the blog You can download it you can download it low resolution high resolution and you can download the original Annual report that is going to the German authorities actually the German one is more Document with information than an annual report because it's more text as no images But contains basically most of the same information which are about the project Second one is about the sources of income in 2021 as you can see we have Majority the blue one is donation by papal and the red one is donation with credit cards Then we have a very small Percentage of other donations. They're coming through other means Libera pay or other stuff Direct wise and Then we have the AB member fees, which are one just one percent and Me a very small amount of other income This is the source of income and these are the main expenditures, so we have very small on Depreciation this unfortunately something that we have to account in terms of numbers then we have a quite a large chunk for employees and freelancers One percent which is small community and events. I think We can at least this this is my opinion, but I hope it's shared by by the board We can definitely increase that one percent In the future especially to counterbalance the two years that we had without meeting each other so if in 2023 You have the idea of organizing events in your country Which can be sponsored by TDF do it? Just one one Small question on our side. We have to make sure that we Managed that properly under any point of view So in November, I will send an email To most of the people I can send it to everyone. I can put it on mailing list asking for budgets Even if you don't have an idea Just saying I would like for instance. I make an example the Czech community They always ask they have a couple of events in I think they're in Prague If I'm not wrong, but they're extremely regular. They say we go at those events We need that money to cover cost for the event for Marketing material we need that money for that and that is perfect I mean if I had all the people like Shtenek, sorry, you should buy some vowels for your name because for me, it's impossible to pronounce it I can lend you some vowels no problem, but So if everyone is like Shtenek, it would be wonderful because we can really on January 1st, we have the budget spreadsheet and it is Second Czech community that much is marketing that much is community and it's fantastic But I know I've organized events for many years So I know that with one year in advance. It's difficult to know the numbers so but you can send us a All I would appreciate an email that says I would like to organize a conference Do you think that 3,000 euro is a reasonable amount for next year and we can have an exchange of emails and agree on an amount and Then we have that amount on the on the budget So the board when the board approves the budget there are numbers for communities which can be approved then You organize the event. Okay, you don't organize it and or you organize in a different way But at least we have we know that there is a budget. There is a figure We can manage it properly. Otherwise, it's a it's a the problem is that we have to Chase you on the expenses and at the end of the year we have to You know to match the budget with the expenses, which is not always the the right exercise It would be better to have a budget and then to do the small adjustment that you do at the end of the year not a complete re you know a cosmetic Rework of the budget. So if you have an idea, I think send us the your request of course if your request is Unreasonable the answer will be sorry. We cannot give you 100,000 euro to just to your community Yes, you can organize 100 events, but maybe we should leave some money for the other communities as well So let's do it a balance exercise, but please do answer our emails Please do answer them In due time If you cannot answer that immediately with the numbers just send an email that says Sorry, we are working on the budget. We are discussing our ideas. I will come back to you in one month I will Not on my to-do list in one month call them to to know their budget But at least you help me in chasing you in the right way So please let's work better together on the budget Because it has always been Not on the last two years because it was impossible to organize stuff, but previously it was really a nightmare Believe me and not because we want to have our life totally easy But because we have to make a guess exercise for everything, which is not the best way then we have Projects and tenders 19% and then other expenses. We have the infrastructure of course we have the registration of domains There are a few Of course, we we have a large infrastructure. We have to work. We have I Think we own virtual machine. We own hardware somewhere and therefore we we have to take care of that and but I would be really happy in increasing the Travel budget and the local event budget because that is what helps us to be a real community I mean We are a community Talking with email is fantastic Meeting on behind the screen is okay But you all know that meeting face-to-face is that we are social animals. So meeting face-to-face is so Please do it. Please organize events. Please Invite people to attend your events if you have someone that Of you if you heard a nice talk at the conference Don't be shy invite the guys and say I would like to have your updated talk to my conference We can ask TDF. It's if there is money enough to pay your travel expenses We can do this We have been in Japan, I mean I've been in several countries and I'm Let's say part of my talk of my job is to is to do talks so I'm not the best example, but We had other people in Japan for the Japanese For the Asian event two years ago We had people in South America Both in Paraguay and in in Brazil this year So it is possible. We have the resources Let make it happen more frequently than in the past in the past Of course do not consider the past two years, but please consider the previous situation There was not enough Events which were funded by TDF in my opinion Even in the past when it was possible to travel around and to to organize events This is These are the donations these are donations per day. So each Brick is is donations as you see We are although there are There are fluctuations That our donation trend is definitely a good one We had a two fantastic years during the pandemic because many people many more people downloaded LibreOffice probably many more newcomers felt the need of donating something so we had But this year where things are back almost to normal. We still have a good donation trend Downloads are increasing by the way Which means that the number of donation per download is decreasing. So we have the challenge of bringing up the You know keeping the ratio between downloads as donation at the same level But that's a nice challenge to have because we have donations. We have downloads These are donations by quarter you see we Normally the the last and the first quarter of the year so October November December January February March are the two best quarter This is historically there's no a specific reason I think is more because These are the months where people is traveling less probably or having less holidays, although there is quite a large amount of the globe Where holidays up and during our winter season, but Probably because we still the majority of it happens from the northern hemisphere in terms of donations that is more affected by the northern hemisphere seasonality and these are Is a comparison of monthly donation as you see 2022 is the darker green So it's we are still in a Let's say rather comparable or it's not a darker red not the green We are still rather comparable with 2020 and 2021 and these are the result per year So you see the amount of donations? This is logarithmic of course because otherwise it would not be comparable So the number of transaction and the amount of the transactions This gives you The total of recurring transaction PayPal which is the dark green and and stripe which is credit card the the Light green and these are amounts We have increased the recurring donations which are now In some cases more than 40% which is a very nice Very nice percentage What do we have to consider is that Let's say one shot donations are higher in average in amount Then recurring donations. So we we have recurring donations, but to have the same amount of one Shot one single shot donation amounts for two and a half recurring donations in term of amount Because recurring donations are Growing but they are lower in term of Investment by the individual of course if you donate each month for three years We cannot expect The person to donate the same amount that One person donates for one single donation maybe over three or four years These are downloads Per week the yellow is is 2022 This is the highest year in downloads in our history so and For the comparison that we do with with Let's say the other project This is the first year where we have more than twice the donations of Apache open office The downloads sorry not the donation the downloads of Apache open office This is what I was mentioning before is the ratio between Downloads as donations the green bars are downloads and red line are donations you see If the the ratio was regular, we should always be on top of the of the bar while we are wildly fluk to adding on that these are download by operating system as you can expect 87 percent is windows 8 percent is macOS and 5 percent is linux These are I think that the linux downloads are Not realistic because there is a large number of people installing Libre office from the repositories of the distribution. So as expected we have a probably a higher than the market Percentage of linux downloads. I think it's probably twice as much as the 5 percent that you see and These are downloads by continent As you see Europe is still leading by far then we have 13 percent of North American Asia 10 percent South America and we have the the other continents unknown is Either Antarctica where we have we have done we have the Miklos. We have downloads from Antarctica Antarctica is a beer is a is a Is a Brazilian beer? We have a regular download from Murro Bay's in Antarctica It's I don't know sorry, but the box time is coming I will So it's it's funny because as I was saying We have a regular Download from Murro Bay's in Antarctica So I went to see and it looks like there is one of the Murro Bay's is a multinational mission in Antarctica. So it looks like there is one of the Countries so because it's not just one download there for download for every version regular so when we announce the update the day after there are four downloads from Murro Bay's in Antarctica and I I'm trying to find a Kind of common email address of Murro Bay's to write them and say can you tell me who is Downloading LibreOffice in your base because this is happening for three years now So it's and it's funny because it would be a fantastic story to have you know LibreOffice using in the Murro Bay's in Antarctica because they are developed, you know, they are researchers So it's a qualified Is a qualified public or a qualified number of users is it's not Normal user. They are people that is there for scientific research. It's a scene and unfortunately a Very large user of LibreOffice in Europe, which is CERN The problem is that they are not allowed to comment on the software. They are using and And and this is a pity because at CERN basically all the researchers or the all the research on the Accelerator they are all using Linux and so all the reports are written with LibreOffice And it would be fantastic to have to get one of those documents to show that you know Very serious people technically skilled people very high-level people can use Libre use LibreOffice But unfortunately they cannot because I've I've been at CERN and of course I Made a presentation. So I asked them can we mention this and I said no, unfortunately This is a policy of CERN. We have to be completely product agnostic Outside so we cannot declare Which product we are using Yeah, but it's not like us writing it because you have to get to the CERN Website and dig into the CERN website, which is not exactly the same thing Okay, and this is a map just to confirm the situation. This is a map Of easy to download page you see we have Germany France and the States Brazil Italy Spain UK Poland We have Russia with a rather high number India and China And so the Darker the gray the higher the the number of downloads Russia has increased quite a lot In comparison with a previous Previous image that we we have This is an estimate so they are not precise numbers, but let's say that for every download of LibreOffice from the TDF website There there is probably between half and one download from other websites, which are like softpedia So the websites where which provide the download property of the software, unfortunately One of the issues that we may have with these people is that we are not sure But it's difficult to ensure that they always carry the latest version That is not easy With softpedia in the past there was a An editor Marius Nestor that was ensuring this but he has left softpedia So now we don't have the contact anymore Marius was very keen about having the latest version But it's difficult for instance a CNET is basically impossible I've tried to talk with the editor in shift, but it's basically impossible because they They give the the maintainers of the download website are External contributors and they don't have the control of the external contributors, but these websites have thousands of downloads every month of LibreOffice And as I said Linux download Numbers are negligible because the majority of Linux users is downloading from This distribution repositories although for instance in Italy We insist when they ask we on on on our group on telegram group on the mailing list We always explain that it's better to download from the TDF website even if the Installation is a little bit less user-friendly because you have to To use to go through the terminal But that way you are sure that you you get the real one because in some cases distribution are repackaging LibreOffice and in there have been There have been cases where they added bugs by repackaging LibreOffice, of course not in not in an intended way, but There were regressions Triggered by the repackaging Sorry No, it's your and is it relevant No, it's not really relevant, but it's important for us to know Where bugs can come from because the problem is that people that are installing from distribution repositories are Usually they usually think that these are controlled by TDF and not by the distribution So for instance, we had an issue with with Ubuntu, I don't remember with version, but there was a One may it was a major a major release and For some strange reason It was in they the menu didn't show on the Ubuntu version they immediately solved it But of course and we got complaints in in our main list they say oh you did it wrong and The TDF version was working perfectly. So we had to look and install It's improving because also the people in in the distribution are improving their the quality, but it may happen So the user estimate, you know, we we we don't change the numbers we we always say we have 200 million user actually And I will talk about this on on Saturday the Analysts give us a Percentage that is higher than we consider There at the moment they give us 12% not unique which means that We have of these 12% of the global number of users a Number is using only LibreOffice and a number is using LibreOffice and another so the total of the office suite Gives more than 100% because people use more than one in on their Computer, there are many people that use maybe LibreOffice and Google Docs and people that use LibreOffice and Office 365 and people that is using Microsoft Office and LibreOffice So let's say that the unique Software is probably not the the normal configuration or at least not in in all the cases but Analysts give us 12% at the moment which would be higher than that But let's be conservative because otherwise the risk is that people say, oh, you know, you're Just giving numbers Without any any reasonable Background This is the development overview Garrett 2021 so it's not updated to today it reflects the year 2021 Please remember that we have a dashboard That can be accessed by anyone any day is dashboard document foundation.org and You have the numbers up to the last minute every day. You can Configure it. You can query you can look at the numbers for a company for a specific Period of time so you Learn how to use it because I think it provides an excellent overview on the state of the project and This is git This is bugzilla Issues by status And the red ones are the sold ones and of course the other ones are the Those we are not sold The spikes usually are for instance that one in which was in late October It's related to the fact that we had the first beta of the new major release. So of course you have An higher number of new bugs on that one These are question and answer on this course and Then we have I hope that you can read the names These are these are the top 20 Garrett contributors Many of them are here. Thank you For to everyone then you have the git contributors Cowlin you should stop working 12 to 4 hours per day because you You know Calan Calan Come on Then people ask me but it it's Calan Making 50% of LibreOffice, which is probably not 50, but let's say 12% of 15. Yes Say yeah, but he's a genius, you know, it's up in Galway He speaks Not even Irish he speaks the old Irish language is in front of a dark fire at night and So this way people believes about Calan McNamara. Otherwise, I think you are a machine then now we have bugzilla submitters and Discourse answer Several people are here Mike Kaganski, of course, we have a year we have the the team of How you call it niche NISZ how you say that in Hungarian? Nice so the the team of Lashlow It's working a lot. They they they submit bugs as a team But it's not just a one-person effort and you see Regina Mike Xisco we have Aaron here. We have water Olivier Ilmarie and Thank you to everyone of course because your contribution is What makes LibreOffice? The good brother that we have These are the web late Contribution and I think that one of the things that we could do better is to promote the LibreOffice language Advantage over any other software. So LibreOffice is the software that is localized in more language than any other software in the world The the closest one is I think Firefox with around 80 languages we have Almost 60 more We have 40 released more and another 20 in the works So talking about this I think gives us a big advantage actually I've tried last year. I've tried I wrote to the Guinness World Record and say We should we we how can we apply for the software that is available in more languages and I discovered that Guinness World Record is a private company and If you don't pay you don't win any record Guinness World Record. So Let's Maybe I don't know and I find it too expensive but Let's say that in the future. We may explore the possibility of Giving them some thousand euro To to get the stamp because that has a huge visibility as you know, we there is a many but They told me that these two niche languages are a niche And and is is not widespread. They said no not just it's eight billion people speaking a language So it's not widespread It's it's the the thing that is more known worldwide Everyone speaks a language and this is them. These are the name with the contribution of people web late Unit translation So again here you have Olivier Valter is not here. I mean if you want to meet Valter Moura We have to go and make the conference in Kalyeri. Otherwise, it's impossible to get it We have Rizal in Indonesia Carl Morton is in Norway You you can find Sorry Mike can read it easily anyway I think Marco is here for instance Marco Marega is somewhere is there But we have many excellent contributors here and I think we should Make their work shine more than we do Because that is very important and I know that there are issues in That let's say that the visual representation of languages But at least in some cases we at least we support the language Maybe then we can we have to improve the way the language is managed But at least we support it. So menus are in the language. I mean people Yeah, no because for instance, you know in Italy now we we have we in schools we have People that start the primary school and their native language is not Italian So and in some cases they come to Italy when they are older So they go to school and they have a limited command of Italian So we with with a few schools where we we were able to talk with with the teachers there And they were using LibreOffice, of course, so we stole LibreOffice in the students native language Of course, the objective was not to Them took for the students to keep using their native language forever But to use their native language as a bridge to the Italian menus So we for instance, we had there was a school where Half of a class was from Romanian people and they started and and the learning curve just flattened because by Comparing the Romanian version with the Italian they immediately understood Some of the terms that were while, you know, if you say stamp stamp in Italian is print But if you never heard stampa and you don't associate if you find it in your native language Then you open the Italian menu at the same place you find the stampa You immediately understand that that word is means print So this is something that and Microsoft office doesn't doesn't allow you Even if they support the language if you buy the Italian version, there's no way to have the Romanian language Because you have to buy the Eastern European version that has the Romanian option So you should buy two licenses instead of one So while LibreOffice is you can add as many languages as you want on top So this is the community over the last five years Of course, the community makes sense to look it over the years because It it's it's a we all know that the community is a fluid Entity yes so we have the The red one that the the smaller bars are the core then we have the the other one Is the let's call it occasional and then we have the random ones Of course You see a slight decrease We should probably work to Grow it again, but if you think that this is on five years The situation is is not bad at all and this is a Geography of our community we are Let's say almost everywhere Dark green is where we have members light green is where we have communities But not members and white is where we either we don't have information or we don't have anyone I Think we are doing pretty good. We can improve and I think now it's time for lunch. Thank you And see you later