 I would like to have Prashant Matapati in the room. I don't know if he's in the room at the moment. I see someone sharing. Yeah, I'm here. Yeah, please, could you start with your presentation? And then Ronnie follows you immediately after? Yeah, sure, sure. OK, I see a presentation. OK, Prashant is there. Thank you. Please. Can you see the screen? Yes. OK, please start. Hello, good morning, everyone. So today I'm going to present about the program that, of course, we are launching through the Google Season of the Docs competition. So for those of you who are not aware of Google Season of the Docs, so this is a yearly program that is launched by Google in which they foster documentation for open source organizations. So luckily, I have been selected by LibreOffice to perform on one such operation that is advanced-scale course. So we are getting an advanced-scale course with the guidance of Olivia. So now let's quickly get into the program. So agenda for presentation is basically a project plan that is how we intend to cover this project plan. And then what are the topics that we are looking forward in this course. And finally, what have we done so far? So the timeline that Google has given, so basically, first, as I told, we are creating the advanced-scale course. So this course would be covering all the advanced topics of Calc, like formulae, pivot tables, statistical tools, et cetera. So the time frame given by Google for us is a 11-week window that is basically it starts from September 14th and runs along until November 13th. So basically, we have calculated it and we found that we have got 11 weeks in time. And within this 11 weeks of time, what we have done is we have chosen some 10 topics, 10 advanced topics from Calc. And we have been developing content for that. And once I develop the content, I send it for review for Olivia. And once the review is done, what we are doing, we are uploading the course content to Moodle Cloud. So once all the 10 topics that we have decided are uploaded to Moodle Cloud, at the end of the 11th week, we will make the course public. So that is what we have planned to do. And yeah, you can see that you can see the list of topics that we have seen. These are the 10 topics that we have selected, advanced topics, formulae functions. So you can see that anyone who wishes to learn about these topics should have at least some knowledge about Calc, like for example, what is a cell example. So once they are aware of that, then they can come to this advanced Calc course. So these are the topics that we intend to cover in our course in our 11 week period, throughout our 11 week period. And we have started off on September 14th itself on our project target. And so far, if I want to see the progress of this thing, so far we have four weeks are done and every week our plan is to complete one topic every week. So on the same lines, we have till now four weeks are completed and we are done with four topics, formulae functions, regular expressions, and pivot tables. So unfortunately, we are not yet uploaded anything to Moodle Cloud because there is minor issues, but that will be sorted out and within, from next week onwards, we will be able to upload all the content to Moodle Cloud. These courses are ready, three of them have been reviewed and they are ready to be uploaded to Moodle Cloud. So from next week, we'll start uploading the content to Moodle Cloud. And yeah, as I told by the end of 11th week, all 10 topics should be uploaded to Moodle Cloud. Yes, that's it, the short presentation from myself. Any questions? Just to comment, we are using an instance kindly offered by LibreOffice Italia, the Italian community for LibreOffice. They have a Moodle installation there, but the plan is to have a second installation inside the Document Foundation infra. So the classes will be shared between Libre Italia and the Document Foundation. And the idea was of course not to do things that we already find in the internet, either by videos or something like that, but to push for all the very advanced techniques that we have in Calc. So, any other question for Prashant? If not, then we follow with Ronny. Ronny Gandhi is... Olivia? Yeah. But Dan is asking if the work can be accessed already. Yes, but it's like a Moodle instance. We need some authorizations to get there. And at the moment, we are uploading some of the files, but we want to have something more interactive and we are working to make it more dynamic because we just don't want to have only files, auditive files uploaded. The idea is to have something that can be interactive using most of the Moodle facilities. So if you can wait a couple of weeks that we sort out all the issues that we have in Moodle, that would be okay. And if you have some experience in Moodle, and you want to help us, please contact us. We will appreciate to have your help in sorting out the Moodle instance. Yes, we will coordinate with Gillem. Gillem already uploaded, I mean, woke up an old Moodle instance. But this was quite recent. So the point is that we were very busy in preparing the presentation and the LibreOffice conference. So time got short in the last couple of weeks, but the horizon is a little bit easier for us right now. Okay, let's follow with Ronnie. Ronnie is working on a second Google of Season of Doc program. Please, Ronnie. Prashant, could you cut your... Perfect, perfect. Please, Ronnie. Is my screen visible? Yes. Okay, so hello everyone. My name is Ronnie Gandhi. I am working on Calci Functions Wiki Reference and User Guide Project. So basically, I am editing the Wiki pages for Calci Functions. We have developed an agenda for this project, which is as follows, adding a universal structure to the Wiki pages, populating the Wiki structure, adding illustrations, diagrams and equations, handling or removing any copyrighted content, adding Wiki notes, warnings, pin messages and additional links. So adding a universal structure to the Wiki pages. Before this project began, Wiki pages for Calci Functions were non-uniform in addressing similar kind of contents. To solve this issue, I have followed a structure defining each function with the following sections in order. Function name, categories, summaries, syntax, returns, arguments section, additional details, examples, related LibreOffice functions, ODF standard and equivalent Excel functions. So these sections, we assume that these sections can well describe a function for any new user. So some of the common changes include adding uniform layout for keeping each category of text under the same section for multiple functions. For example, previously details about error cases based on arguments being passed were mentioned either in argument section or in detail section, but now all lies under argument section, adding tabulated examples which were earlier in plain text in some places and in tables in other places. Further, following a similar way of writing related functions, for example, now pages for functions like Count and CountA have almost similar content, but highlighting the key differences between each one of them, making it easier for user to interpret. Next, once the structure is established, we focus on populating Wiki structure. Most of the Wiki for Calci functions had many sections completely empty or others were filled with minimal details. So under this project, I added details about each section using help pages for reference along with the ODF. I have also researched additional details depending on particular functions, including what is the range of the result, whether a particular range of argument gives error cases, adding equations and images, finding related functions for related LibreOffice function section, any other additional details that seem important for the function, whether an argument can be passed directly via reference or as an array, adding all types of example cases, including those that result in errors with description about each one of them. Next is adding illustrations, diagrams and equations. I believe diagrams and equations act as an interactive connection between a documentation and the reader. As contrast to the plain text that was already out there, many mathematical, statistical and financial functions can be better described by adding a graph plot for their curves and equations wherever required. I have added such graphs and equations for functions mentioned here and many others like sine, cos, exponential, erf, beta, binomial distribution. Here is one example of 8-an-h function for which I have added a GIF that describes the curve of the function. Further equations for gamma and binomial distributions have been mentioned which are represented over here. Next, handling or removing copyrighted content. There have been some function pages that contain verbatim content from other sources. Also, there were cases where equivalent Excel functions were described and linked to their Excel pages. We see this as a serious problem and for which I have removed any occurrence of such issues and these changes have been further checked by Steve Fanning, my task mentor. Further, adding wiki notes, warning, pin messages and additional links. Following the same format as the help pages, offer, I have created templates to add note points, warning messages about certain criteria that must be satisfied for a particular function and pin messages. I believe these things act as an additional layer of information on top of the standard information that we are offering. Besides, I have added additional links to wikipedia pages for certain distribution functions like binomial, beta and f-distribution for those users who are keen to know about the mathematical side of these functions in depth. So with this guidelines, I am working on each Calci page functions, Calci functions for each page and with this, I would like to end my presentation and I would be happy to answer any of the queries that you have. Thanks a lot. If one of you has any questions to Ronny, please, just a complement of completion of information, you can access the work that is done by Ronny, accessing the wiki of the Document Foundation and clicking on the documentation entry page and then you have on the left, you will have a link to the wiki functions that we are developing. Just a question from myself. Alain, if you hear me. Yes. I was wondering if within Calci, there are functions, in particular text functions that manipulate and then define a list of texts in a similar fashion as the Perl function would do. Say you would receive a ABC parameter and perform an operation on the full list itself instead of a single string, for example. Am I clear? Do we have a list and link functionalities in Calc that would perform in a similar fashion as Perl's handling lists? Would there be text on numbers? This is Olivier speaking. I don't know this answer. Okay. I forgot to mention one thing that there are around 500 functions that I would be addressing in this period of GSOC, GSOC 2020. So, we have just come across 150 functions as of now. Thanks for your work. Back in the later section of the... Yes, I'm going to put the link here. Just a moment, please. Here is the link. Okay. No further questions. Thank you all for attending this meeting. Thank you to Prashant, Matapati and Ronnie Gandhi for coming to this conference. And present their work. And again, thank you guys for the opportunity. Thanks a lot. Thank you. Thanks to you. Bye-bye. Thank you very much. Next talk will be in half an hour from now. Bye-bye. See you later. Bye-bye.