 This is Hack the Opaq how to create a free online library catalog with Seth Allen the online Instructional librarian at the King University in Bristol, Tennessee. So we've got a back-to-back Tennesseeans here Good morning Seth. Are you with us? Yes, can you hear me here coming through loud and clear and you're all set to go Okay. All right Well, good morning. I hope everyone's doing well. My name again is Seth Allen. I am I have two library jobs I never sleep For one, I am the online instruction librarian at King University. We're in northeast Tennessee in the town called Bristol All the Virginia border That's my full-time job. It's the newly created position. I love it because I get to use technology and I love the integration of education and Technology and particularly free technology. I have worked at a number of small libraries over the past couple of years I've been a solo librarian now at three schools I have worked for schools that are woefully underfunded and as a result I've spent my professional career looking for cheap workarounds to technology. My other job is Theological librarian for Rockbridge Seminary Rockbridge Seminary started about 10 years ago as the first completely online seminaries do this and get Masters in Divinity, which is usually the credential to be a Senior pastor at a church and just now we're offering a doctorate of leadership. It's a doctorate of ministry and leadership There's been a lot of challenges as you might imagine with a completely online school Having Think about a thousand students all together There isn't a huge budget for the library. So One of the things that I've done and this presentation is based on my second job as the theological librarian is How do I get the most? Bank from my bottom of resources. How do I get information out there and how do I make it searchable? It really seems to me like Libraries are adding more and more electronic content The paradox is the more electronic content we add the harder it is for our patrons to find The more training that it takes is not as intuitive as maybe we would like it to be This is particularly true when You get books from several e-book vendors. All right, so we have reference books from Gale Virtual Reference Library We also purchase some e-books from Epsco and they both they have their own search platform And they're excellent, but It's hard to Send students to three important places to search for books. Okay, so that was the challenge that I had all the money that we really had is is tied up in not so much e-book subscriptions, but Access to five and six databases We have several Epsco databases So news to say we did not have any money at our school to be able to put together a catalog so How I got around that is To create just a list of resources. I took this position Back in August and I inherited the position from a friend. He resigned from the position He suggested that I take position. I was hired and I basically had a spreadsheet of all the resources All right, and I said to myself there's got to be some way to make this search all right have a good friend who is a librarian and He's always discovering new resources and he introduced me to what's called magic table Or excuse me awesome table what it is it is a Script or sometimes it's called a gadget that works within Google sites and what it does it takes a Spreadsheet puts it online and makes it searchable All right, I'm going to open up here This window This is the virtual library This is what I have been working on for the past couple of months as you see here This is a completely online library catalog. Okay, so I've been able to catalog books and I've Put hyperlinks to the titles have information about authors the publisher the subject headings Okay, so let's say for example. I want to search for a subject. I'll type in Bible Right when I type it in it narrows down my results. So I go from 9,000 results almost 9,000 results to almost 700 results Okay, so this is a very helpful tool So I'm going to show you guys Just basically how to get started with it and also some resources out there For one I Let me just begin by saying I'm the type of person who will Jump into something first and then think about the consequences later. Okay, so I've only been using this for about two months now There's a couple of things Since I started working on it that I thought about how can I Fix them like for example, how do I? Capture statistics on how many books are being used or Checkouts or what if somebody wanted to adapt the system for books in print? How could they go about Making it so that students can actually check out books with the system. All right I need to say I'm still working on those but I want to show you How I got started and give you some suggestions for Workarounds for some of the common problems because this is not a complete Library management system. All right, so it doesn't have the bells and whistles. It's not easy easy to capture statistics for example It's not easy to do reports. All right If you can do that, that's great, but you've got to Use hacks to be able to get there. All right. So first thing I want to do is to pull up My PowerPoint here. All right. I pulled together a couple of resources here There's a really good comprehensive video series here and I'm going to make this Presentation available afterwards about how to get started with Google sites if you're not familiar with it If you are not a tech person per se Google sites is probably one of the easiest web builders that you could use. All right It only takes a couple of minutes and if you have a Gmail account It's already linked to a Gmail account. All right, but let's say that you're setting up one for your work To create Google sites you may want to actually create a new Google account completely So that's not tied to your personal Gmail account But if you have Gmail or if you have an account with any one of Google services You automatically have access to Google sites. All right Google sheets is what's a part of the Google Drive as you know, Google has been trying in recent years to Basically replicate the Microsoft Office suite online. A lot of you are already using it I see a lot of librarians using Google sheets Google documents, you know, which is like Microsoft Word Google sheets is obviously a lack of cell There's even a PowerPoint equivalent. I believe it's called Google slides But there's just a thousand things that you can do and the good news is both of them are free to use I believe with a basic account in the Google sheets where you can store Word documents You can store Excel spreadsheets PowerPoints images sound You get a shared folder kind of like Dropbox with two gigs of storage All right, and from there you can either upload existing spreadsheets documents or you could actually create your own within Google sheets all right, I Am going to pull up now my account work and And in this case actually had my account tied to The spreadsheet that I created and the Google sites. All right, so how I got here what this is This is a Google sites. Okay, and what it is The catalog itself is a spreadsheet that's been embedded in Google sites Okay So I'm going to pull up my Gmail account here from work Okay, when you're signed into your Gmail account, you want to click on this icon here and then click on sites Okay The first time you try to create a site when I click on the create button I'm not going to go through how to create a site that'll just take too much time There'll just be way too much information. But again, there's plenty of tutorials out there about how to do it I've already created this site here where I'm storing the online catalog. So I'm going to open this up Okay, and now I'm in the edit screen and I know I'm in the edit screen because I see these tools up here, okay All right You can click on the edit button to edit the page Okay, and then you'll see the contents of the page here All right, that's one part of it Okay So again, you need Google sites and you need your spreadsheet where you're keeping your information Let me go back to my Gmail account All right, and I'm going to click on this button again and now I'm going to click on Google sheets here It may look different You may not see it at the top if you don't see Google sheets or Google Drive You want to just click on more and then you can click on even more and that's where you get Pretty much all the apps here I think the first time that you use Google sites you may find that it's just way down here under home and office But once you use it It will automatically pin it to the top of your Search area here All right, so under Google sites Or under the the app spark you want to go back and you want to look for a spreadsheet or sheets I'm going to click on this It may take a second to open But here I have the spreadsheet where actually keep the data Okay, and I'm going to open up this spreadsheet All right, so this is what the back end looks like. All right, so you may be asking yourself Well, how do you know how to set this up? Okay on my presentation here? I have the documentation for how to set up awesome table It's really easy to use And they have explanations about how to set up your spreadsheet so that it works with this gadget called awesome table And so that you have final product where I Your users are able to search Okay, so I uploaded my PowerPoint Okay To create hyperlinks to the books So like what you see right here You have to format them as a hyperlink Okay, so you see here. I have a link to the book Okay, and I have the title of the book there. All right I Did not go and put all the major fields that you would find in a typical mark record Like I left out the description field. That was just a personal decision. I have title author publisher publication date ISBN numbers and I use the subject heads and something that I just Played with and you can try this if you want to actually circulate print books I added a column here and I call it loan status. Okay, and I typed in checkout. So maybe if you want to Circulate book and print You could change all of these books to available like you wanted to do that. You could just type in available All right, and then take this right here and Just move it down and you can make everything say available. That's that's one of the shortcuts to learn Let's say you check out the book You may want to change the available to do on Say March the 15th Okay, all right when you share this document It's going to show up in the library catalog. All right, so people will be able to see when the book is checked out Okay, so more about the Table and how to set it up to work with the awesome table The top column obviously I put Whatever access points, okay, and in the documentation for the awesome table it shows you how to set up the filters So the awesome table will know how to read it Okay, I Can't explain this in depth, but again on my presentation. I have a link to this awesome table documentation It's about a 15 page document. So it has pretty much everything you could do with awesome table Okay All right now. I'm back in my spreadsheet. I want to go to file and I want to press publish to the web Okay, you're gonna have to make it publishable to the web to be able to Invent it in your site I've already published it here, but if I did now press this publish button Okay That's step one of making it public the next thing you want to do is go to file and share All right, and you want to make sure the settings here are set so that anyone on the internet can find a view so Making your spreadsheet public to the web is a two-step process First you want to publish it and then you want to make sure it's shared with the web. Okay? All right, so I've got the link here. Okay, what I did is I went to the Home page that I've created where I was going to hold my library catalog All right, and then I went under table Wait Having some technical difficulties on my end here. I bear with me just a second. Okay? I went under the edit page Okay, and then I went to insert All right, and then under more gadgets I Click I look for Awesome table. All right. I see this is the awesome table here And I press select And this is where you go and you'll actually set up the awesome table Okay, so I'll just go over this very quickly again. It's under the insert and more gadgets All right Now scroll down to awesome table press select Okay, and this is where I type in that spreadsheets The public link all right The sheet one It's works like tabs in Microsoft Excel. You see here how you have different sheets here You can add them on this automatically set up to read the first sheet here okay, and I am using columns a through h Okay, so I want to make sure that it said a 1 to h and If I click this button I can allow viewers to download the data as a CSV file So it's like a it's like an Excel file. Okay, and then I can choose Do I want to make the spreadsheet pull width of the page? How long I want it to be I don't want to water around the page and I don't want to title around the page And that's just a personal preference. It's really up to you All right now. I'm going to press save on the inside here Okay, all right that way it's loaded The spreadsheet and once I've done that I'll press okay Okay, and now I'll press save Okay, I'll take a second to load here, but if your Spreadsheet is set up correctly It should set it up so that each one of those columns is now searchable Okay, so again it read the first column there and that's what you see here Okay, and then the filters when I set up the filters it created searchable filters Okay, so how this catalog works is it's basically three pieces. It's a Google spreadsheet it's Google sites and It is a gadget called awesome table Right and again on this presentation here. I have examples here Tutorials that you can go through explanations and how to set it up I Created a video tutorial earlier about what I did have a website called librarian hacks calm And I'm just going to pull this up Again librarian hacks calm and I share how to use Google sites and other shortcuts And click on the librarian hacks page Okay, and here I have video tutorials about Different resources, but there's one here create a free online library catalog where I basically demo what I've just done Okay, so with my institution again, we don't have a lot of money for votes As we're adding new programs particularly doctorates We need to make sure that we have enough resources to be able to assist their students And like I was saying earlier even though there's a lot more content that's on mine We're having trouble with Making it searchable for students Some of the things some of the hacks that I've come up with is to be able to Pull books that are on the open domain Books that are for example no longer under copyright Maybe they have a creative commons license and actually pull those into the catalog. All right, so with our library catalog right now We have 8,985 books We may not have more than about 200 of those that are subscription ebooks through Epsco and Yelver to work its library But I've slowly been adding online resources Open access books from places like project Gutenberg Open library since we are a Seminary there's a site called Christian cloud classics in theory a library and actually have links here that takes you to the Mark records page. All right. I am not a catalog All right, I'll go ahead and say that So this has really been a learning process for me. The most I've done is copy cataloging I've never really had to do something as Fundamental as creating records or Trying to pull data from different sources but with a lot of Open domain books like with open library or project Gutenberg You can download the entire catalog as a mark record. All right and using mark edit Which is a free tool and if you're not familiar with it. I would highly recommend Seeing the cataloger at your school or if you have a friend who may be catalogs Asking them how it works. It's really easy to use. It's a free software that's available You'll download the software and have instructions here for how to open up a mark record and to save it as a text file all right, so When I do that, I'm then able to open it up in Microsoft itself. Okay, and that's where I'll go in and I will Do different types of editing so for example, I imported a lot of records from Open library. All right, what I did to be able to sit through the books and to pull up things that I didn't need is When I imported it, I made sure that I imported the fields for the Dewey decimal number and I imported the fields for the Library of Congress call number. Okay, and again These are things that I don't intuitively know. It's just been a couple of weeks of trial and error Okay, so when I imported it you see all the records here All of the fields, the mark fields, they imported as different columns All right, so what I would do is I would use the sort and the sort A to Z list and Sort them A to Z. Okay, so I had like a column here and I've already deleted it with LC column numbers I sorted it from A to Z and then I just went through the subjects that I wasn't using and I pulled them out. All right, so I just went back and I would go back and delete You know a row of records if it's something that I don't need That's one way that I was able to quickly sort out what I didn't need. Okay So once I have the data formatted and this is something that I'm working on right now These are records from open library I'm going to have to set them up But you know probably in a day or so they're going to be ready for me to add to the catalog Okay Whenever I have these properly formatted like all I have to do is to copy the records and I can actually copy the whole spreadsheet Then I go back to that Google spreadsheet Okay, and at the very bottom of it all I would do is I would paste Okay Press share and then all of those records will be added Okay, one of the problems that I've had is to figure out how to Format the the title with a hyperlink, okay Google or this spreadsheet and awesome table it uses HTML tags whenever you want to do things like this When I first set this up I Would have a title here All right, and then I would have a hyperlink to the book in a separate column All right, I found a workaround to be able to Take this information and create a Automatically formatted hyperlink right so like what I have here where there's a hyperlink to the book with their The title is showing okay, I can't really go into it right now And I haven't done a tutorial on how to do this But basically what I did was I took the spreadsheet All right, I took these the column with The title of the book and the hyperlink to the book and I used Melmerge I used no merge to be able to create records like this Okay, with no merge I was able to and it took a couple of times again to figure it out to be able to format it so that I have hyperlink here and So that it's showing the travel of the book right So some of the challenges and some of the thoughts that I have after doing this For one thing like I said earlier. I'm the type of person who does something and then I'll think about the ramifications later Capturing stats has been an issue How do you do that? You know being in a credit at school? I have to somehow show Circulation statistics right so I'm still working on what to do about that But one thing that I have learned is that with a Google spreadsheet you can search You can capture statistics about how many people are clicking on a sales in a spreadsheet by using Google analytics All right, I don't have a link to it here, but you can just Google Google analytics For spreadsheets And Google analytics is a really sophisticated tool what it does it actually searches Within spreadsheets and tell you how many times people have visited how long they've been on your page And it's completely free tool right and now they've set it up so that normally can you I use Google analytics on your website But there's an add-on so that you can actually take a spreadsheet and you can see how many times people have Clicked on a particular resource Okay, another problem that I have that I've thought of how to fix is just Adding due dates to books. So what I did here initially I didn't have a column for checking out Right, but it's very easy in the setup page to just add another column. Okay, so I'll show you here in the setup I'm going to click on the edit button and In this Google gadget this is the spreadsheet That's embedded in my page. All right. I'm gonna go back to properties here. Okay, and I can Switch the range here. So let's say I wanted to add a column To Include a checkout period. I changed this from G to H. All right, so added another column And then I made sure I saved it. Okay, and then save it here Right and that way I'm able to add a column and it just says if it's checked out or not So under loan status it says it's available or if it's checked out and I would just write in manually the due date Okay Another issue that I thought of later on is how do you deal with? authentication issues all right Depending on your institution depending on your policies sometimes Institutions have proxy servers so that you can Have a single login for all your resources One of the problems that I've had here is how to do this How to set it up so that students can go directly to the resources, okay? One of the good things is I was able to contact Epsco who provides a number of our ebooks And I spoke to tech support and they set up links here so that it goes directly to the resource All right, so if I click on one of the titles here and the first couple of pages are Epsco ebooks they set up the link so that it already has the Password information built into it. Okay. The only caveat is I can't put this on a public website I'm just showing you guys for the sake of I demonstrating how to use this but I have the library catalog in this case Only available through our learning management system We have noodle at our institution and make sure that this is not on the public page, but it's immobile All right, so I would be very cautious about creating links like this that go directly to the resource and putting it on a public page Okay, but you can discuss with your representative from Epsco or wherever else you get ebooks and Talk about how students can authenticate, right? For the ease of searching I went ahead and made it so that students go directly to the resources and again This is not on a public page. This is only on our internet Okay, so that's just a very brief introduction about how to use Awesome table and Google sites to create a library catalog I won't believe plenty of times. I figured you guys would have questions. So if you have any questions for me I'd love to hear them Does anyone have any questions about what I did how to use it? Oh, yeah Thank you, Seth. We got questions coming in from the audience here. So Laura, what do we got up there? Okay, first they're saying are there licensing issues with making searchable in this format Are there licensing issues? Yes, however, if the ebooks are being if the records are being made online Normally there isn't a problem with you adding them to your records or to your catalog The way that I know for sure that it works is I have a friend who works for a school that uses OCLC world share I believe it's called and he's able to quickly add Open domain books to his catalog. It's a very one-step process and I'm kind of jealous. All right. So whenever I When I remember I'm about to add resources I make sure that I contact him and I ask him, you know This is something that I can link to my catalog. All right Another way to be on the safe side is to obviously not to download the books yourself and try to upload them to your own server I mean, that's that's clearly a copyright violation But to link to different resources. So like with my catalog I'm gonna go through a couple of pages here and Pull up a link If it's if it's working right now, but what I have here is I have a link that actually goes to like open library All right, or it goes to Project Gutenberg So it doesn't directly download it, but it takes you to a page where then you can download it All right, and I think that's a way to stay safe Okay Any other questions? Yes, they they're saying What if Google ever crashes? Do you back up? And if so, how? Yeah That's a that's a good idea and one thing that you can do is You can take the spreadsheet and then you can go to file and download it You can save the Excel spreadsheet so that you'll have a copy on your computer Back up back up back up And Yes, somebody's saying it looks kind of time-consuming How much time does this actually take? I Knew somebody would ask that question. Well, if you know what you're doing it doesn't take very long The learning curve has been a little bit high with me But I'm getting better with it. So for example with project Gutenberg I was able to download all their records and I was able to format them so that they would show up in the search box here Sift through them and I was able to do all of that sift through and get about 7,000 records I would say in about four hours. Okay? If it's your first time, obviously it's going to take you longer, but I just I think it is a huge Investment, but it's definitely worth it Yeah, I would think in that case. It's kind of the beginning it's set up might be the the Kind of that that's where the learning curve is but once you've got it set up adding records is not necessarily something that you know it's just I Don't want to say busy work, but it's kind of it's as time-consuming as The more you do it the faster it gets kind of thing right absolutely and The first couple of sites that I went through I'm asking myself like is this really worth my time I didn't found out how to download records and how to really use mark edit and That that is the most time-saving thing is to be able to use that It may seem like busy work, but you know look for shortcuts Ask around I think someone else is using I have my contact information if people want to ask me questions about it I have links to three different really good resources here open library project Gutenberg and Christian Classics If you're a library where you can download the records and I have a link here to mark edit about how to Download this tool and how to export the mark files as a text record and there is really simple tools from CUNY libraries College New York I think about how to export mark records in the text files, which can then be opened up in the Google spreadsheets Yeah, well any other question. Yeah, I just a couple of comments one is the moment you said I did that with a mail merch all three of us are like Oh, yeah, I mean I thought that was great And we do have one comment from Julie on Twitter. She's saying Seth Allen is a spreadsheet beast So you've got some math skills there on the spreadsheet according to Julie, so Laura some other audience questions well one of the audience members is asking have you tried have you looked at any of the other Software packages that you can use for a simple library catalog. He's suggesting they the co-haul Community version of that might be a way that some people would want to go for a catalog Yeah, yeah, absolutely. I mean that's an option as well You know, I'm not really familiar with like the FTP Upload process and I know that you have to download files upload them to a server and The great thing about this this is completely free. All right The only investment obviously is the time to learn how to use it Okay, but I'm not paying for hosting because it's hosted on Google sites I'm not paying for any of the other IT support, you know, I Google things and that's basically my IT support You know, if you're feeling confident and it's something that you definitely is a big learning curve about how to use this But once you use it, I mean, I just think it's a great option. I mean co is a good option because It supports full mark records and I know at most institutions people want to have full mark records Well If you had to move to another platform or something could you move your essentially your data? I could move the data I work for another institution where they had bought one of those Home and church library catalogue and softwares and what it was, you know, all it was was a glorified Excel spreadsheet All right So I use mark edit in the past to take an Excel spreadsheet and to be able to create mark records with it now They weren't perfect. They were incomplete But the data more or less transferred and I was able to create mark record And I may want to add I'll make a shameless plug There is a library software out there that I've used before and of course right now I'll forget the name of it library world When I work for a school of about 200 students There is a completely cloud-based learning management or library management system cataloging I've been asked or public access catalog and it was $500 a year for everything tech support coasting It's called library world. I really enjoyed that one. So, you know, if you do want to pay for one That would be a really good way to go Okay, um, yeah, I've got a couple questions for you the once you set up the spreadsheet And let's say you're gonna add at all you add a thousand records Do you need to then? Republish things or is it just pretty much you save the spreadsheet with the extra thousand records and now it's live Well, um, I Can pull it up You press the share button and the share it does the equivalent of publish. Okay Okay, and then you want to make sure that you go back to your site and press share on the site So you press share on the site and the spreadsheet and It should be updated. All right, and it updates immediately, which is a really nice thing And like what I did is I took the link here All right, and then I put the link in our schools learning management, right? All right So when people get a learning management system, they'll click on the link and they'll be able to pull up this page Yeah, so in other words when you update the spreadsheet, you do have to kind of republish it before the webpage will pick up the new data Correct. Okay. Just want to make sure you know didn't skip that step and then okay, so Most it looks like you know correct me if I'm wrong that most of the resources that you're looking at are kind of kind of open access online resources where or something you subscribe to But you kind of showed that you're also using it sort of as a circulation system. So you do have print content in there that that you're then checking out by manually updating the spreadsheet I Don't because we're completely all in school. I just I wanted to demo that just in case anyone's doing that. Okay, okay Okay, gotcha. Yeah, so so you could by having a column that you manually update use it as a search system But it's it's a bit of a manual process You could Question another question from the audience They're asking has anyone ever uploaded a web link to their OPEC catalog is this a viable use of the OPEC Has has anyone ever uploaded a web link to their Let me see if I can maybe rephrase the question. Have you considered adding? Most of what you're adding online is is like online ebooks things like that would would you add like here's a great website or Blog on a topic. Would you consider adding that to you? So, you know a pure web resource? It's a possibility I'll go ahead and pull up here some of the other pages I've used Google or the awesome table to be able to Categorize different types of resources so like vital commentaries is really essential for seminary students So like I've used this and like I've been able to take Commentaries that are freely available online and like I can have them narrow down This is using again awesome table by theological perspective. So let's say I wanted to look at all the Catholic commentaries I can do that Created like century of publication. So let's say you will look at 16th century. You can do that. Alright, I Did the same with open access journals. Alright, again Under topic like I created my own topics. These aren't necessarily LC topics. So, yeah, I mean it's something that you could do I have a list of the best websites, but I had not thought of using Awesome table to be able to do that. That is a good idea. Okay, could you bring up? Because I see here with your Bible commentaries in your open access journals You've got those drop-down lists with with filter choices Can can you show us how you you did that in the in the spreadsheet to make those work? Yeah, absolutely. Let me open up the spreadsheet here Okay I want to go back and I'm actually going to have to open up that spreadsheet Okay, so each one of those tabs in the catalog What I did in in the Google sites I Created another page. So you click on create page. So this is a separate page All right, and this is another spreadsheet that I embedded in there. Okay so this is the commentaries page and What I used was the category filter right so in the documentation for The awesome table they show you the different filters that you can use. You can do a date filter, which is really cool It's like a like a sliding scale I don't know if you ever used an exgo database, but you're able to Limit things to certain dates. It doesn't have a year. So it has like a month day here It's like standard date formats in Excel. That's what it uses But to be able to create these drop-down menus all I use was category filter and I make sure that I use my own Control vocabulary so to speak when I set these up Gotcha. Okay. Yeah So I We've got a few more minutes and if anybody else has any questions or comments You know, please feel free to submit them through the Q&A or through Twitter, but I gotta say I had Heard about Seth doing this I saw some blog post or somebody mentioned it and then I Invited Seth to submit and and I'm glad he did because I this is this is probably way Slicker than I ever envisioned. I've not played with Google Sheets all that much myself and especially not this thing I had the the just changing from string to category and then it generates those drop-down lists That's that that is slick is the best word I can come up with Cool. Yeah, cool. I mean It's you know, I was kind of expecting a whole bunch of you know Here is the HTML and CSS I I used to put this together and and what we've got is basically You add this gadget and set up a spreadsheet and then it does all work for you. I that's that's very impressive Yeah So At this point Just a comment that came in that I think is interesting Not sure if this will work for my library, but I'll definitely use it for personal projects. Oh, there you go. Yeah Yeah, yeah, absolutely. There's a thousand and one way to use my table Or awesome table. I should sound I keep calling magic table because that's that's the word that I would use to describe it But I'm keeping inventory. I think that would be an amazing tool to you know, keep inventory of You know an office library If you go to the awesome tables Documentation they show you how One real estate company they actually used awesome table to keep up with listings So like whenever they had houses or sell they had it like a searchable spreadsheet So you could search like a hundred to hundred fifty thousand dollar range You can search by price you can search by location And it would give you very basic information and you could have a link and it would take you to a web page Where that particular house I that that really blew me away. Yeah, have have you And and since you can only use this in-house made maybe not but have have you pulled this up on a tablet or a phone and How well does it adjust to different screen sizes? Um Okay Not great. Okay, particularly when you're looking at a spreadsheet it is hard to render it in a Phone I have a Samsung Galaxy and it works so so Okay, Google Thights has gotten a lot better over the past couple years. I mean it's it's not quite there But you can more or less render it now sometimes I'll pull up on my phone and you know It makes it the size of the screen and sometimes I have to scroll over Horizontally because it wants to show me like the regular version of the screen. So, you know, again, that is an issue With using Google sites and Google spreadsheets All right. Well, yeah, thanks. I like said I think I use like one Google spreadsheet to track something when I'm out in bookstores and things like that And it's got like three columns in it. So yeah, anything more complicated than that might might have some issues, but Okay. All right, so no other questions from the audience and we're just about at 10 of here I've got a 11 48 10 48 my time here So I think we will wrap up this session Seth. Thank you very much. Could you just for a moment pull up your Contact information again if anybody has any questions for you. There you go right down at the bottom of the screen there And as we've said will be we've recorded all this so we will be posting that stuff up next week So Seth, thank you very much And what we're gonna do is we are going to take now a short break and we will be back with our next session at The top of the hour. Thanks for attending. We'll be back with you in a few minutes