Hi, my name is Art Brownlow, I'm a professor of music and also faculty fellow for academic innovation at the University of Texas, Rio Grande Valley. One of my duties in the latter role is to oversee our OER initiatives from the academic side. In this way, I work closely with our OER librarian and our scholarly communications librarian to coordinate our affordability program. And hi, my name is Gabby Hernandez, I'm the open education librarian and I oversee things from the research side. My main role is to coordinate the project's grants and professional development opportunities related to open education and textbook affordability. I work with all types of stakeholders across campus including administrators, faculty members, librarians, instructional designers, bookstore managers, and students. Together we work to ensure faculty have the support they need to adopt, adapt, or create OER so students can have access to their course content at little to no cost. So thank you for viewing our presentation about how we collect course marking information for our zero and low cost courses and what we do with that data. But first we'd like to introduce you to our institution. The University of Texas, Rio Grande Valley is located in Deep South Texas. We have two main campuses that are 70 miles apart, plus seven satellite campuses spread over 100 miles or so along the Rio Grande River. Our enrollment is just over 32,000 students. UTRGV is one of the country's largest Hispanic serving institutions with a 90% Hispanic population. Many of our students are first generation college students and 61% of our students are Pell eligible. With this very unique set of demographics, the affordability of higher education is one of our campuses main concerns. The UTRGV's textbook affordability project is working hard to ensure our students have access to their course materials at little to no cost and we'll be talking about one of those initiatives next. Texas Senate Bill 810 was passed into law in 2017. Among other things, this law requires universities to mark OER course materials in their course schedules. In marking our courses, we've taken a broad interpretation of OER to include library licensed materials, instructor created materials, and even no course materials at all. So instead of OER, we have adopted the use of the terms zero cost and low cost in our course markings. Now we add statements with these designations to the course listings in our course schedule. You see here the ZC statement which reads, all materials for this course including textbooks and any software slash courseware will be available at no cost to the student. And here is the LC statement which is similar. And as you can see, our threshold for low cost is $40 or less. Before 2021, we really had no systematic approach to this process. We kept a growing database of known affordability advocates and friends. Each semester then we sent them email requests for their ZC and LC courses and then we sent that data to the registrar for marking. In this way, we IDed around 100 courses per semester, but it was inefficient and time consuming. So this past spring, we developed our course material reporting form. This is a short form that we have front loaded to our traditional textbook adoption process. And it has resulted in over a 300% increase in courses that we've been able to ID as zero and low cost. Here is the landing page of the form. We've used this for two sessions now, summer and fall. And the way we distributed it to the faculty was through a link to this page sent via listserv announcement from our provost. So next, I'm going to take you through the form so you can see the flow and what kind of data we're collecting. Okay, so here again is the landing page of the form. And you'll first see an explanation of what types of information we are collecting. And then next, you see that there is contact information there for any needed help. So now I'll select the term. And as you see, there's only one option now, but in the spring, when we send out the form for summer, it will show both summer sessions. So let's click on fall. Now the first thing we ask is if all your courses use only course materials that cost more than $40. If the answer is yes, then it's fairly obvious you are a traditional textbook user. And the form will take you straight to a link that takes you to the bookstore where you can then submit your textbook order. But if the answer is no, then you are presented with a list of all your courses for that term. Now, as you can see, I'm only teaching one course this semester, but there it is. It's listed here. So I'll click on the green plus sign. Now there is a description of course materials here. You know what is and what is not considered a course material, just so the person who's taking the form will be clear about it. And then it asks if the course is zero cost. If yes, then you're asked to choose one or more of these options. Say you use OER and library licensed. Then you click submit and you're then directed to the same ending page as before. And you're done. But we now have data about what kinds of zero cost materials you're using. However, if you choose no, and I think I'll have to go back for that. There we go. Say you choose no, then you're asked if the course is low cost. Let's say your answer to that is yes. Now you see this answer is open-ended. But you can see some of the suggested responses, you know, homework, systems, apps, etc. Once you've entered your responses, you can click submit and you're done. But again, we have our data. Now by the way, back when you chose yes to the low cost query, if you had chosen no to that question, you would have been sent ahead to the ending page. And at that point there would be no reason to answer no, we know that. But we provided that escape for anyone who found themselves there by mistake. And so that's our form. It's simple and yet it has provided us with some very powerful data. And more information about how many instructors are using zero and low cost course materials than we've ever had before. The faculty have input all their information in the course materials reporting form. We receive an automated report weekly of all the updated information. The reporting form is always live to allow faculty to make updates as needed. The data is then taken from the Excel spreadsheet and copy and paste it into AirTable. AirTable is a relational database that allows easier utilization of the data sets provided. Here you can see some of the information that is collected from our faculty. This is the data in its raw form and at a glance we can see which courses are marked zero cost or low cost. And if the faculty member is using library-aligned materials, OER, or no textbook for each assigned semester. Between summer 2021 and fall 2021, we collected almost 1,000 data sets representing seven semesters worth of information. I needed a better way to collect and utilize this data. Within AirTable, one can create various views of the data to look at individual data sets. As you can see here, I have created various views of the information using filters and groups to provide easy access to necessary information at a glance. One perk of using AirTable is the ability to have the information updated in real time. I can make a change in one view and have the rest of the data sets reflect that change automatically. Depending on the need, I can see which faculty are using OER only. I can see the zero cost course for fall 2021. Or I can see an overview of how many data sets are in each semester. Or even create a different view to fit the needs of the requester, which so far have included administrators and student government. Using the course materials reporting form and inputting this data into AirTable has been a game changer for our textbook affordability initiatives. Now that we have the data from the form and it's easily manipulated through AirTable, we have been able to really utilize this information. As some examples, we have made reports showing the percentage of affordable course materials that are used at UTRGV. About 50% of those courses said they are not requiring textbooks at all. About 30% reported they're using OER and the remaining said they were using library licensed materials which could include databases or unlimited licensed ebooks. We've also been able to build relationships with our campus bookstore and the Office of the Registrar. We send the course material reporting information to the bookstore to which they have been able to update the information on their side to ensure students know what type of course material. If any needs to be purchased for their classes. We also send the list of zero and low cost courses to the registrar who then uploads this information on their end so it can be reflected on the website when students search and register for classes. Our outreach efforts have even benefited from this data. We were able to cross check outreach lists with this information to create more targeted and individualized outreach efforts and see which colleges really are our OER champions. For the first time we really know who is out there teaching with OER at UTRGV. I was able to perform an outreach using all the faculty members who reported that they were using OER in fall 2021. I reached out individually to each faculty and asked which OER textbook they were using. As you can see on this slide, we got a lot of responses and there was a wide variety of OER being used and represented on campus that represents many different subject areas. Another big win we had from implementing the course material reporting form was the student access to this information. As mentioned earlier, SB 810 requires Texas institutions to have this information accessible to students. We have created a list of every zero cost and low cost course and put this information on our library guide so students can know exactly which classes they can register for that have either zero cost for their course materials or something less than $40. To ensure this information reaches students beyond listing it through the registrar, we performed a mini marketing campaign where we put this information on all of the library's social media platforms as well as on the library's website homepage. We have had more than 500 views for this information since we put it out a few months ago. In summary, I'd like to say that we now have a structure whereby we can find, collect and mark zero and low cost course materials in our course offerings. Is this structure perfect? No, and we will be tweaking our form the next few times we use it. But I think it is a reliable tool for fulfilling the requirements of state legislation and for collecting the data we need to improve affordability at UTRGV. And overall this data has really helped us understand what is happening with OER on campus. Utilizing Airtable has allowed me to create very detailed reports very quickly and easily. One request we had from our student government, they wanted to know which courses were not using zero and low cost course materials to see how they could reach out to them and see if there were OER for those courses and start a conversation. Because of this form, I was able to get that information in their hands at the click of a button and just, and this is just one example of how we were able to utilize this information to go beyond course marking and enhance our OER initiatives on campus. Thank you so much for joining our presentation today and learning about how we have been able to address course marking on our campus. On this slide we have our contact information as well as links to our websites where you can learn more about this and other initiatives we are hosting at UTRGV. The textbook affordability project website has information about our faculty recognition program as well as textbook affordability resources and support for our faculty. The OER and textbook affordability library guide has our list of zero and low cost courses as well as other information regarding OER for our faculty and students. If you have any questions for us, feel free to write them in the chat or contact us after the session. We look forward to hearing from you.


Hello and welcome. My name is Shannon Kemp and I'm the Chief Digital Manager of DataVercity. We'd like to thank you for joining the DataVercity webinar today, improving advanced data prep and analytics and spreadsheets sponsored today by Altrix. Just a couple of points to get us started. Due to the large number of people that attend these sessions, you will be muted during the webinar. For questions, we'll be collecting them by the Q&A in the bottom right-hand corner of your screen. If you'd like to tweet, we encourage you to share highlights or questions via Twitter using hashtag DataVercity. If you'd like to chat with us or with each other, we certainly encourage you to do so. Just click the chat icon in the upper right-hand corner for that feature. And as always, we will send a follow-up email within two business days containing links to the slides, the recording of the session, and additional information requested throughout the webinar. Now let me introduce to you our speakers for today, Lisa Aguilera and Hassan Habibati. Lisa is a Senior Product Marketing Manager at Altrix. She is passionate about the analytics space and showing how to innovate analytic technology and how innovative technology can help analysts, I can say that well, move past mundane data tasks, evaluate their skills and expertise, and deliver ever-increasingly sophisticated insights. Hassan is a Solutions Engineer at Altrix. Hassan empowers customers by helping them get to insight fast. Hassan teaches data science-related topics at the University of California, Irvine. Hassan has a hands-on analytics experience and was instrumental in launching various analytic practices in the OCLA area. And with that, let me turn it over to Lisa and Hassan to get us started. Hello and welcome. Thank you so much. Thank you, Shannon. So as Shannon mentioned, I'm Lisa Aguilar and with me I have Hassan. I wanted to spend a few quick moments going through what we're going to be talking about today. And first and foremost, I want to say thank you so much for joining us and taking the time out of your busy schedules. We hope that you will be able to learn something interesting out of what we showcase today. Now throughout this webinar we're going to be focusing on a few things. We first and foremost recently commissioned a report by IDC and we are going to be going over some of the results of that report and really focusing on some of the most prevalent use cases, activities, and function analysts like yourself do when conducting analysis in spreadsheet-like software. Now we're going to take a quick look at the top barriers organizations face and then some of the recommendations that came out of this report. And finally my colleague Hassan here is going to be doing a quick demonstration on how you can augment your process and overcome some of the challenges when working with spreadsheets. With this report I just kind of want to level set and give a bit of a background before we dive into the details of this report and paint a picture of who participated in this survey. Feedback was aggregated from over 550 respondents across a wide range of users and they looked at the usage and challenges of advanced spreadsheet usage. And we looked at it across organizations, industries, and partners. It touched on a broad range of individuals within organizations so it wasn't skewed by one type of respondent or one size of organization. Now one of the more interesting pieces of information that was discovered from this report was the fact that self-service data press and analytics via spreadsheet-like solutions has been going on for years even prior to BI and visualization fads and it's something that still continues to be the case today. Now according to IDC, 8% of employees still engage with spreadsheets to do some sort of data preparation as their software of choice. The fuel of big data becoming mainstream has actually driven the desire to extract insights from all available data to brand new levels and is resulting in an extremely high demand for self-service data preparation and analysis by tech savvy business users that want to be able to access their data without having to depend on other departments which is also fueling the usage of spreadsheet analysis and advanced spreadsheet analysis in business units today. In addition to that, IT is actually playing a big role in this process in trying to understand and determine how as an internal organization they can help business units deliver results faster and answer the questions that impact employees and impact organizational directions quickly. Now when we look at the data of the IDC report and we look at the usage, three of the most frequent uses of spreadsheets focus on data integration, ad hoc data analysis, and data visualization. Now the typical analysis performed when using spreadsheets focuses on what if analysis, cleansing, pivoting, and prepping that data for presentations into something like a PowerPoint. Now of those common functions that analysts perform, at least on a weekly basis, a lot of the functions begin with summarizing data, manipulating it, blending that data, building what if statements, and then going into advanced statistical calculations informally. Now it may not seem like there's a lot there, it's a pretty common practice, but on average people who are doing this are spending about 26 hours per week working in spreadsheets. So finding a better way to perform these processes is actually critical. It's critical to your success, it's critical to your success if you're using spreadsheet-like software. And then it's critical to the insights that your organizations are depending on to leverage and make decisions. So how can we become more efficient? Well, it starts with some of the basic techniques that a lot of people do in beginning work with data. One of the first things that people do when they begin to work with data and spreadsheets is they make a copy of that data and paste it into a spreadsheet. Now sometimes it's done because you don't want to lose the original, sometimes it's done because it's the path of least resistance, and copying and pasting from a source is the easiest way to begin to actually work with that data. But copying and pasting data from the source into a spreadsheet is one of the biggest ways in working with data. So ask yourself, are you copying and pasting data from its original source into a spreadsheet before you've been working on it? If you are, you really need to take into consideration how wasteful this process is for you, as well as some of the insights that you're going to be developing. Now here's why. First, it contributes to wasteful repetition in the data preparation process. In addition, copying and pasting isn't even the most easiest way to get data into the source that you can use to manipulate it and work with it. It isn't the most accurate way to begin the process of working with that data. It actually greatly introduces a possibility of human error. Coupled with that, IT isn't necessarily a fan of this method either. They are responsible for data integrity, data security, and the copying and pasting data from a source can result in internal policy and external compliance violations. Now, most importantly, copying and pasting data from its source into a spreadsheet before you begin working on it actually rose the data integrity. You are not dealing with data at the source, and therefore it introduces a lack of ability to audit the data trail and validate the insights you have created. Just imagine if one of your managers or your executives discovered an error in a report that you were building and asked you to be as they could trace it back to the source and find out where it went wrong. Do you have to tell them that you copy and pasted data from a source and correctly into a spreadsheet and that's what introduced the error? It's a very uncomfortable conversation to ask, to have, and it's a very uncomfortable question to be asked why you're copying and pasting data from the source into spreadsheets to begin with. Now, in addition to data integrity issues that are introduced by copying and pasting data from the source, working with spreadsheets also introduces risk exposure. Now, those of you who work in organizations that are focused on governance and focus on Dany's lineage, you should be concerned with using spreadsheets for your data work. A lot of IT departments, when they hear self-service analytics, they often think of the wild, wild west and data marks and Excel spreadsheets running on muck and are they old, how relevant are they? And spreadsheets really contribute to this perception. In addition, as I mentioned earlier, spreadsheets introduce the human error aspect into the analysis process and many times over the news, I'm sure many of you have seen, there have been costly mistakes organizations have had to face due to the fact that there was a spreadsheet error. So, given all these concerns, why aren't more organizations turning to alternative solutions outside of spreadsheets? Now, the results of the IDC survey break it down into three major issues. It's revolving around compatibility issues with other systems within the organization that are already established and maintained. There are concerns about lengthy implementation times and how quickly can you actually get started in working with an alternative solution. And there's also concerns about high costs. So, spreadsheets tend to be free. Other alternative solutions tend to cost money. And how can you actually support that and fund that? Now, the reality of software applications is actually different from this perception. Applications today are actually more open than ever before. And software is actually becoming easier and more intuitive to use and install and get going with, reducing the learning curve and implementation times, if that's what you're worried about. It also may be more costly for organizations, as I mentioned earlier, introducing human error into spreadsheet solutions than it would be to pay for an alternative solution. The reality also is stand-alone spreadsheets never really solve the problem of preparing for data analytics. Spreadsheets are great if you're working with one or two forms of data. But when you start to expand that to three, or four, or eight, or nine, or up to 15 data sets, or on different worksheets you're trying to combine them, it's going to get difficult, not only for you to keep track of that data in those spreadsheets and those sources, but also to manipulate the data in the spreadsheet itself. You're going to get a lot of hanging up. You may get your Excel crashing. As a result, there has been an emergence of self-service analytic software, and that's putting the data preparation, data cleansing, and data merging of analytics into the hands of analysts without you having to go to different departments to get the data that you need, and without you having to turn to different departments to perform the insight that you actually need. Now, a lot of organizations say that well, these solutions are competing against free solutions. So let's take a little bit of a circle back to some of those numbers that I talked about earlier with IDC. Now, when I said that 8% of organizations and 8% of the data workers within organizations are actually using Excel or spreadsheet for their data work, I want you to take a look at what does that really mean. That means five million users in the United States alone and 16 million users in the rest of the world. But what does that also look like for you? There's a lot of people using spreadsheet like software to do analytics. What does that really mean in terms of what you do on a day-to-day basis? Now, when you look at the insights that I talked about earlier from IDC, that on average, 26 hours per week of working in the spreadsheet is wasted. Given a 40-hour work week, that equates to 65% of time wasted performing manual tasks. The majority of your week, if you think about it, and you're doing analytics in a spreadsheet, is spent wasted on manual aspects. 35% of this time that you're spending in your spreadsheet is wasted on just repeating simple efforts when data sources are updated.  So what does this mean? It means that there is a huge population of data workers like yourself who are wasting a tremendous amount of time in their day in and out working with something that is a free solution. Now, when you try and quantify this, that is 1.3 billion hours wasted on duplicate work in the United States alone. That doesn't even account for the time spent on spreadsheet-type software for the other data tasks that I talked about that you guys typically perform. But the truly scary number is this one. The number of hours wasted in the U.S. alone is equivalent to flushing $60 billion a year on repetitive manual tasks and spreadsheets. This should really clearly paint the picture that free isn't always free. Of the 5 million advanced spreadsheets used in the U.S., eight of the 25 hours working spreadsheets is spent on during repetitive tasks, such as updating data. Based on a baseline salary estimate, that's 12,000 per worker per year just wasted because analysts are not able to automate routine manual process. Now, I can assure you if you or your manager walked into an executive meeting with an annual budget enhanced saying, we're going to allocate a couple million to repetitive manual tasks this year, I'm pretty sure that would not go over well. But the reality of it is it's happening and it's happening every day. It's just that no one's admitting it. Is it because of the true cost of wasting or repetitive tasks isn't really understood or that organizations really don't understand that free doesn't actually equal free when it comes to spreadsheet-like software for data analytic tasks? So what does IDC recommend based on the results of the survey? Users of standalone spreadsheets are unable to achieve the desired levels of integrity through the data preparation process and outcomes. And there are huge gaps between the importance of data and analysis and data integrity compared to what one is actually able to achieve in spreadsheet-like software. The big problem is the cost of maintaining the status quo of performing data work in spreadsheets is staggering. Free is not always free. IDC recommends that analysts and users consider self-service data preparation software and self-service data analytics software as alternative to spreadsheets. And to build business cases for self-service data analytics based on productivity cost savings. They also recommend that users explain the business case for self-service data preparation software by highlighting some of the additional benefits self-service data analytics software offers, which is better control, higher levels of data work and analysis and integrity, and it helps you to provide trust, availability, security, and compliance. Now, the purpose of this webinar is to give you a sense of the benefits of using an alternative solution over spreadsheets for data analytics. Spreadsheets are at the core of almost every single business, and they're not going to be replaced. The purpose here is really to highlight how an alternative workflow-type solution can both augment and help your processes and tasks that you may be struggling when you are working in a spreadsheet-like software to do your analytics. Now, before we can do that, let's do some brief information on why people use spreadsheets. So, most of the time, I'm sure most of you guys are using it because it's something that you're familiar with. It's easy, it's free, it's low cost, it's always available. A lot of times, people like what they can do with spreadsheets because they can instantly see the changes in the data that you're making. Now, typically, it'll cover almost everything that an analyst needs to do on a day-to-day basis for our data work. But as I mentioned earlier, there are really a lot of issues in working with spreadsheets. There's the productivity cost, which is huge when you start to quantify it. There's the ability of trying to get past two or more data sources. There are Excel role limitations for how much data you can actually work with within a spreadsheet. The other thing that tends to be a nightmare is collaboration within spreadsheets. I mean, imagine if somebody sent you a spreadsheet that had all of these formulas in them, are you going to be able to pick up that analytic cap and work it on yourself? Or is that spreadsheet going to have to kind of wait until you can sit down and have a conversation with the person who created and actually go through all the formulas and functions that are in it? The other thing is we have analysts tell us all the time, they don't trust what each other's spreadsheets and want to redo the work themselves. So those are some of the issues when working with spreadsheets. Now, what can be an alternative solution? Workflows are great augmentations to some of the spreadsheet working you may be doing. Workflows are a lot more transparent. They will allow you to understand what's taking place through each step of the analytic process, because it's self-documenting. And because it's self-documenting, others can quickly understand what's happened to the data quickly and easily, just by looking at icons and the workflow itself. The other thing that workflows do help with is because they're easy to understand, collaboration amongst analysts is actually quite easy. You can create an analytic insight, pass that on over to a colleague from a different department who can use it for their downstream process. The other thing is, in terms of visualizing the data, spreadsheets do allow you to see the data straight away. But with a workflow, you get to see the data at each step in the process by running that process. You understand exactly what's happening to your data while it's happening. Now, another reason why workflows are a great alternative is for the simple reason that a large percentage of your day-to-day job is repeatedly preparing and updating data when the data set changes on a daily, weekly, hourly, nightly, quarterly, or monthly basis. Having to do that work over and over again within a spreadsheet-like environment is time-consuming and tedious. And as we talked about earlier, extremely costly, not only for you and your productivity, but for your organizations as well. Workflows actually free you from the tedious tasks of producing the same reports over and over again. They allow you to build out a process that you want to perform on your data. And whenever that data changes, you simply point to the new data set and it runs through. It doesn't require any coding, and it allows you to actually move on from common data prep tasks to more advanced analytic work. When you update your data set, the other thing that workflows actually allow you to do is projectionalize your workflow and your analytic process. So in spreadsheets, this is typically done in tedious coding and visual basics or in building macros.  Workflows actually allow you to automate and schedule as data refreshes. And you don't have to worry about augmenting anything as data sets changes. If you're trying to do this in Excel, visual scripts or visual basics, you will actually have to merge or recode your workflows to get them to work together. With a drag and drop visual workflow, you can simply just add a secondary process and set everything on automatic. The other thing that workflows allow you to do is really embrace analytic flexibility. You're no longer really kept to where your data is stored or what it looks like. You don't have to worry about if your data is in a SQL server. You don't have to worry about if your data is in a Teradata. You don't have to worry if your data is in the cloud and AWS and having to write custom scripts and codes to extract that data out before you can perform analytics on it. Workflows actually break down those barriers and allow you to connect to the data at those sources and bring them together visually and intuitively without turning to another department to do it for yourself. With that, I'm going to turn this on over to Hassan, my colleague here, who's going to show you how a workflow process can help augment what you are currently doing in Excel. Thank you, Lisa. That was mind-boggling. Thank you. I'm going to go ahead and share my screen. I'm going to show you today how we would build one of these workflows that Lisa was mentioning to hopefully help save time and then get back some of that $60 billion that we are collectively wasting. What you're looking at is... This is Ulthwick's designer. Here on top, I have all the tools that I can use to visually build out a workflow and document a process that's going to describe how I'm going to prep, clean up, and blend my data. These tools are color-coded to make them easier to find, but they are also organized by functional areas. I have tools to allow me to input and output data in my workflow. I have tools to allow me to prepare my data, do some data cleansing, data filtering. I can also blend my different data sets together. I even have tools to do advanced things like predictive analytics, et cetera. Most of what I'm going to show you today is going to exist under this favorite step. In order to build my workflow, I'll just simply drag and drop these tools onto this open space here that we call the canvas. As I bring the tools to the canvas, the results of what I'm doing and how my data is being transformed will show up down here in this results window. This will allow me to see how each one of my tools is transforming my data and what my data looks like both before and after that tool was added to the workflow. Give me really transparency and data lineage. Over here on the left is the configuration window. As I bring each one of the tools, you will see that the configuration window changes, allowing me to configure that particular tool. For our workflow today that we want to build together, let's say I have customers all over the country and then I have different regions and then I have my salespeople or the different regions send me their data and region-specific files. I want to bring those files in together, make them into one dataset, clean that dataset, and maybe do some analysis on it. I noticed that I'm contributing to that money loss that is $60 billion by doing this manually month, week over week. If some new data comes in, I have to do the same repeatable task and I would like to automate this a little bit. I'm going to go ahead and build a workflow to help me with that. In order to bring in some data, the first thing you would do is bring in this input data tool onto the canvas. Notice the configuration window changed allowing me to configure this input data tool. We can bring in data as Lisa mentioned from many different types and really just making it easier for you to get in a database connection. We have a wide variety of databases. As long as you have an ODPC, an OLA, a DB driver, and then you have access to that database, we will allow you to bring in that data. But let's say I have my data in the file. Let me go ahead and navigate over to where my data is. And then let's say these are the different regions and that's how my data comes in. If I go over here to show the types. Of course, not everybody follows the same rules. Some people send me their data as a comma-separated CSV file. Some people send me their data as an Excel. Which is fine. Altrix will help me with that as well. But let's say I want to bring in this first comma-delimited CSV file representing region one. I have about eight of those and then I have an Excel sheet that has the same type of data. What I'm going to do, I selected R1 and I'm going to go ahead and click open. And you can see right away, Altrix was able to bring in that data. It shows me a sample down here in the configuration window, just letting me know that it was able to bring in some of that data. But I want to bring in more than that. I don't want to have to create another input tool for each one of those files. I'm going to go over here to my region file. I'm going to replace the one. Instead of R1, I'm going to use a wildcard and now if I click run, Altrix is a runtime environment so when I click run, it will actually go ahead and process my workflow. Notice now I have over 2,356 records that were brought in. If I look at the messages, it's actually going to show me all the files. I was able to bring in R1 through R8 in one input tool. So now I want to bring in that one additional file that is actually type as an Excel sheet. I'll go ahead and drag and drop another input tool onto the canvas and this time I'm going to have to get over and grab that Excel worksheet. R10. I'll select the sheet name and now you can see that I have my data down here. It looks a little bit different again. Some people do things differently and I have their different system so it looks like here that my data is actually not as clean as the common delimited file. First of all I notice that my force row actually has data and I'm going to select this indicating that force row contains data. But now I need to clean this up a little bit. It looks like my column headers are not where I want them to be so I'm going to actually have Altrux skip the first two rows trying to get me to the data that I really want. In order to do that I'm going to use a sample tool and I'm going to tell Altrux to actually go ahead and skip the first two rows of data and then we can examine our app and see if that's the desired result or not and that's what's really beautiful about having a visual way to build your workflow. You're actually kind of going about it doing it and seeing is this is what I wanted so notice what happened. Now my data, my customer which looks like column headings are actually in the first row of data actually what I wanted because now I have a tool that's going to help me clean that up even further. I know I need to now rename these columns with this force row of data but let's say I'm new to Altrux I'm not really sure how to do it and I'm just learning.  Notice Altrux searches any tools within the platform that will allow you that will help you with the term that you're searching for but also searches online help documentation and Altrux community made up of customers Altrux associates and employees and we're always pushing out content to help our customers but let's say you find a tool that you like this dynamic rename is the one I'm looking for you can open up an example and actually see how that tool is being used and what's really, really amazing is I can actually find a tool that I like I can actually drag and drop that tool right onto the canvas not even having to worry about where that tool is and I think that's amazing because what that does to me it keeps me in the process it keeps me thinking about the task at hand I don't get distracted by going out and doing a Google search or anything I find a tool, I like it it looks promising I'm just going to go ahead and use it in my workflow dynamic rename tool rename my data there's several options I'm going to select the one that says take field names from the force row of data and then I'm going to click run to have it process my data and examine my results you can see that now my column headings actually came from that force row of data that was buried somewhere in my data set so at this point I have these two data sets here they, you know, they I'm ready to bring them together regions 1 through 8 this is region 10 1 through 9 and 10 I guess but these are all my regions and now I'm ready to stack these results together in one data set I'm going to go ahead and bring the union tool the union tool is going to allow me to do exactly that stack my data together in one data set over here on the left I'm going to select the manual even if all my columns are the same name you can have the auto-config as a best practice I like to do the manual config and then just look at my data and see if it's lined up correctly and it looks like most of my columns are lined up first name, last name are called differently again, not everybody is following the same rules and we all are humans so I'm going to take these two columns here first name, last name I'm going to simply just rearrange my columns to have them lined up so I'm not copying stuff in Excel I'm not, you know, control C control V and making mistakes on where I insert the column I simply aligned all my columns to make sure they're aligned correctly now if I click run I can now I have if I click on output coming out of the union I have 2,678 records representing all my regions you can see the region column over here so now at this point I have, this looks like a decent data set I'm going to take a further look at it before I build a workflow and invest my time I want to save some time by doing some data quality, data profiling on this data before I go ahead and use it I'm going to drag this Browstool over here and then hit run again the Browstool is going to allow me to get really quick and very valuable data profiling information about the data that I just bought in notice my columns are now color coded really indicating the health of this data this is demo data so it's very, very clean but if you hover over the columns it tells you how much, you know if it's nulls, if there's how many null values are there if my data is okay or not as you select a column you can come over here to the left and you see how many unique values are there so this way you're kind of getting this health check on your data before you invest your valuable time building a workflow and then realizing you have bad data but let's say that happens and it happens sometimes and then you realize there's some things here that I need to pay attention to as I mentioned this is a very clean data set we offer a data cleansing tool I'm just going to go ahead and bring a data cleansing tool on here the data cleansing tool allows you to do very common and often repeated data cleansing operations things like what do I do with nulls without replacing with blanks or zeros I have unwanted characters in my data set maybe if I came from excel I have a lot of white spaces maybe if I came from the web and I did some web scraping I have line breaks and tabs and things like that maybe there are letters where they're not supposed to be maybe people are putting numbers in the same field and it's not supposed I can clean all of that up and it's really nice but I can do it all in one tool I can even modify the case if I want to make everything lower case or upper case I can actually hit run now and what's really nice about these tools that I'm adding notice there's an incoming anchor and outgoing anchor out of each one of these tools the incoming anchor tells you exactly what the data looked like before this tool worked on it and the outgoing anchor the arrowhead shows you what happened to the tool after it was processed to the data after it was processed by this tool so you can see my first name, last name there was kind of a mixed bag of different upper case I guess they're all upper case and now they're all turned into lower case because that's what I told it to do my cleansing tool so there are different options for you as well so let's say at this point everything came in from a power in Excel and I can click on this metadata down here to show me kind of the metadata of what I have and it looks like everything came in as a string which is very common sometimes and you may have to change some of them to numbers but let's say you don't want to have to worry about this you want Alt-Rex to do that for you we have a tool called Autofield that really tells Alt-Rex what to want to select the best field for me based on the data that is contained in that field so it's going to select the most optimal size and the right type of the field for that column based on the data the one exception I make is I always unselect the zip file just in case I have some zips that are starting with zeros, I have leading zeros and I don't want to really touch those so other than that it will work very nice on the rest of my data types now if I click run and I want to see what this Autofield tool did, I can click on the tail coming in, click on the metadata and we saw everything was coming in as a string, now if I click on the arrowhead coming out I can see I now have a mixed bag of different types, there's some number there's some strings and Alt-Rex selected the best size based on the data that was coming in and this is dynamic so if I have new data coming in and this is part of my workflow and Alt-Rex needs to adjust this it's actually doing this every time you run the workflow so if you have new data that's coming in this step will be automated for you at this point these are all my customer related information coming in from all my different regions I'm going to go ahead and bring in some transaction data at this point and I want to show you how we do that connecting to a database rather than a mail so I'm going to go back to my favorite step I'm going to bring in another input data tool, at least I mentioned there's really no artificial limits of how many of these input data tools you can have or how many rows or things like that, this time I'm going to go ahead and connect to a SQL server we can connect to many different types of databases as I mentioned as long as you have the driver and then you can configure it as chances are we'll be able to create a connection for you, so you can enter that database I have a SQL server running here on my demo machine I'm going to go ahead and connect to my SQL server and I'm going to bring in a transactions file I can bring in this file as is our transactions table in this case I can select some of the columns if I have a stored procedure that I normally use to bring in my data I can leverage that in here I have to throw it away if I want to write my own SQL code I can do that in here as well but for the most part if you want to keep this as a code free environment you know you can do that so at this point I'm going to bring all my transactions I'm going to click okay and update sample to see kind of what's in here so I have things about customer ID, order ID, store number, I have some order dates, some shipping dates, shipping methods etc. so altrux is what I would call dates and time aware so it knows what time it is you can do comparisons of time and dates and things like that so let's say I want to try to figure out how long does it take to maybe ship each one of these orders you know where we notice our business is down a little bit and I want to develop some intelligence on you know the causes of that maybe it's taking too long to ship the orders and that's hurting our sales so I'm going to calculate how long it takes to ship an order in order to add any formulas or business logic to your workflow you would use this formula tool the formula tool allows you to update any existing columns or you can add your own a new column if you would like in this case I'm going to add a new column and I'm going to call it something like shipping time because I need to understand how long is it taking to actually ship my product so I'm going to compare kind of the time that a customer ordered a product and when it was actually shipped to them so I'm going to use a function if you click on this FX button here there's a lot of functions that are available to you including date time functions and then we have something called date time def somewhere over here I can select it or I can actually date time def should be over here okay I forgot my alphabet there and I can compare so date one is going to be my shipping date so I'm just fast-talk typing it shipping date I selected my second date is going to be my order date so that's when they ordered it and I'm going to say you know give me the difference in days I'll just type days here so this is going to calculate the duration between my shipping date and my order date now if I click run I'm going to see that I have this additional column and my data set over here if I flip over to the data let me just make this a little bit bigger so now I have shipping time indicating the number of days that it's taking to ship this product so this is great so now I want to see how if this is affecting the customers I want to kind of develop some aggregations on a customer level I'm going to go ahead and bring this and connect it to my data stream and the summarizer allows you to aggregate on whatever fields you make sense for you so I'm going to take the customer ID and I'm going to say you know group my customer ID because I want to understand what is happening on the customer level but I also want to know how many times this customer shows up in my transaction file so if I say count I need to say count and so that's going to count how many times this customer ID shows up and I can say this represents the transactions I also want to see the shipping time on the customer so that's the new field that I created I'm going to take shipping time and then I'm going to say you know what why don't you just average the shipping time for me notice I can't find the average function here because I missed the step notice my shipping time is the string so I can because I have a visual workflow I know what the briefest step is I know where I calculated the shipping time so imagine doing this in Excel and figuring out oh my god where did this go wrong and what did I do I can come back here and really no sweat just changes to a double and then now I fix this error so imagine compare doing that in Excel and how what a nightmare that would have been I'm going to go over here to an American and I'm going to say okay the average shipping time for the customer and while you add it I'm going to take my sales and actually I'm going to sum the sales for the customer so simply by selecting the fields and saying how I want to aggregate them I'm able to create a summary now if I run I'm going to show you what the results look like so now for this customer ID 2 he or she has one transaction average shipping time is 2 and then total sales or you know is $5.76 so that's great so at this point I want to see okay what is when was the last time I had an interaction with this customer so I want to calculate the number of days since the last order so I want to try to find what is the most recent date I can do that by actually go in the summary and then finding my order date which is one of my columns and I'm going to say what is the max order date what is the latest or the most current I guess order date that I have that this client placed an order and now I'm going to take this max order date I'm going to build a formula around it actually let me go ahead and run show you that so I have max order date here now I'm going to provide a formula another formula tool and this time I'm going to calculate the number of days since I last interacted with this customer and maybe this is meaningful for me I'm going to develop some intelligence maybe build a predictive model or something like that so I'm going to use that date time so I'm going to create a new column it's called days since last order something like that or last transaction the same date time def function that I did in the first formula this time date one is going to be now so I'm going to say date time now select that function date two is going to be this max order date that I just got in my summary so that represents the last time this customer placed an order and now I'm going to get the difference in days and then you can see in the data preview which shows me kind of a calculated result based on the first row of data just giving me a warm up fuzzy and letting me know that this data is you know it calculates correctly and I have no errors now if I click run I'm going to see that I now have a new field called days since last order and now I can actually do something with this see you know what is going on and you know sorted or trying to figure out what is going on with these customers but what I have so far I have kind of two sets one going up here on top representing you know kind of customer data I have transaction data going here on the bottom at this point I want to try to join these two data sets together this is very similar to how you would do like a field lookup and excel or you know or join in a database let me show you how much how simple this is and how easy it is to fix any problems that you may have so in order to do I join I'm going to go into all and just bring these two data sets together and I have to tell altrux how do I want to join them I'm going to join them on customer ID so I select customer ID from both the left and the right coming into the join I have a left side and the right side allowing me that data lineage so I can always trace my steps back and see where the data came from coming out of the join I have three outputs there represented very well here in this VIN diagram I have the J output which is my inner join I have my right unjoined so these are records in the right input that did not match and I have my left unjoined so this would be records in my left input that did not match down here I have total transparency in terms of what is coming in I see the columns that came in from the left I see the columns that came in from the right I can deselect some of the columns here if I would like customer ID is coming in otherwise because it's my joining field I can actually deselect that if I want I can deselect other columns I can rename some of these fields if I would like so let's say I want to take this max order field and maybe call it something else like class order so I can rename this whatever makes sense for my flow now I'm going to click run I'm going to show you the output from the join tool and really keep in mind kind of when you do a join up in Excel the kind of information that you have here that you're going to have in Excel of course we have the J which is our inner join so this represents the combined data set they can see my customer information you can also see my transaction information all in one data set joined on the customer ID but what I see additionally I see what did not join so on the right nothing I have zero here but I look on the left I see the ruckus did not join what's really nice about this I can actually take this and develop some intelligence about it so these represent customers that did not have any transactions maybe I can do more outreach more marketing to these customers so I don't lose this output here whatever fell out of the join I can grab it I can build a whole section of the workflow to handle this let's say I want to be I want to automate this workflow it's going to run on a schedule and I want to be alerted if this happens I want to be alerted if any ruckus come out of the left side here and I want to be notified so I'm going to use something called a test tools I'll go up here I find a test tool I'm just going to show you this real quick and then I'll just take it out I'm going to add a test tool so the test tool allows you to test for a condition I'm going to come up here and say you know add a new event no transactions I'm going to say you know alert me if the ruckus are greater than zero so what's going to happen now if I run my workflow and it finds that something came out of the L notice the workflow breaks because that condition is as broken that condition was met so now what I can do I can actually as far automating my workflow I can come here to events and say you know what add a new event and then send me an email I can send me an email when this workflow run with errors so now I'm notified I'm kept in the loop that something happened I haven't have an error so this you know so now I can automate my workflow and be notified when something goes wrong I don't want to do any of this so let me just go ahead and just remove this I just wanted to show you what it would look like if you choose to kind of automate your workflow so now at this point coming out of the join I have my data set combined data set let's say now I want to now that had cleansed this data it's combined it looks nice I'm going to go ahead and output it to maybe an Excel sheet and I want to do different tabs for each one of the regions that came in so the way to do that I'm going to get an output data tool and just add it to my workflow and I'm going to actually output to a flat file and I'm going to say webinar output or something like that maybe this is my customer list and I'm going to go ahead and select Excel let's see I have the different types I can select this one I guess and click save I can give it a sheet name but what I want to do I want to make the sheet name dynamic I'm going to say take the file table name from a field and I'm going to say I changed the file or table name and now I'm going to select a field in my database to drive the name of the sheet and in this case it's going to be my region so I select region here and now if I run you can see that I created an Excel sheet and I'm going to go ahead and see that I created an Excel sheet R1, R2, R3 I can actually open one of these drag it over here and you can see I was able to output the summary that I created this is all my cleaned up data and then I select a different option here I can see maybe I selected different option change file table name let me go back table name maybe because I have it sorry about that okay let me give it another name it's called my report it's going to be Excel give it a sheet name now click run and it's running so that's what happens when you're running something live and you are a human okay there you go so now it's creating my report Excel with these different sheets but let's say this is not how I finally want this maybe I'm using some visualization tool and I want to output this to a TDE file or maybe something to visualize it in another visualization tool what's really nice about this is I'm not tied down to one output I can take the same data and I can output it to different ways and I find this very handy with our customers because some of them say well I want somebody but my executives they want to see a dashboard or something like that I can definitely output this to somewhere else another file type and in this case I'm going to just go ahead and select the TDE file which is a tab load data extract and then give it a name I should say T output and then just go ahead and run it and you can see in my messages now it says 2272 records were written to this tableau TDE file now I can open this up in tableau I can build my workbook and I can visualize my data so at this point now that I have automated prepping and blending the data together cleaning it from all the different regions that are coming in instead of spending my 26 hours a week that I use on prep and blend and cleaning up this data I actually now have time to do analytics that will bring value to my organization and as you notice the more I automate the more time I'm going to have to actually go deeper and add even more analytics maybe at this point I can leverage some of the predictive tools the Ulteryx has maybe I can do spatial analytics or drive time analytics you know to find out how far my customers live from my stores or things like that so really very quickly on you know I want to predict what is the likelihood of somebody responding to a marketing campaign and my data I have the suspended fields I have been collecting responder information on my customers maybe I want to predict the likelihood of them responding in the future I'm just doing this at a very high level just to show you that these predictive analytics models are ready to go for you out of the box I'm just going to connect my data to the model and I can give it a name it's going to you know something like marketing model and I'm going to select what is it that I want to predict so it's going to be my responder field whether they will respond to a marketing campaign I can select the variables that influence that field maybe the number of transactions maybe the average shipping time maybe how much time they spend with me they have to drive to get to my store so once I select these variables I can actually run and now I have a predictive analytics model this built out of the box this is airing out because it's I don't have it on overwrite so now I can do and you can see the more I build the more time I have to do to do other things so and if you're interested in this altrux has many analytics kits to help you get started with advanced analytics if you go here under the help menu and you look at sample workflow you know you see how you can do things like presentations we can all come and see some of these kits starter kits for analytics as a starter kit for things like predictive analytics learn how to do you know different models a force model linear regression logistic regression these are all here as targets and all of these starter kits can be downloaded from a website that will be altrux.com and then slash kits I really hope you've enjoyed this I hope you've seen kind of how you can save and don't spend all this time on doing data prep and blend and actually move over and start doing some analytics Shannon I'm going to send it back to you see if there are any questions would you mind quickly just handing me the Q&A? yes I will do that somebody stole the ball from me there you go I think you have it you should do it would you mind passing me that ball while you do the Q&A? I thought I'd pass it to you it looks like you just send it to me there you go great so we're going to get to the Q&A here the presentation will be made available to the rest of you guys who did see this presentation today with that let me pass this on to Shannon who will come we'll run through some of our Q&A just to let everybody know to answer some of the most popular questions as Lisa mentioned I will send a follow-up email by end of day Thursday with links to the slides the recording and there's a lot of fantastic questions coming in so if we don't have a good chance to I'll try to get some answers and maybe we can get some of those in the follow-up email as well so keep them coming in but we'll we've got just a few minutes here to get to some of the great questions so let me ask you know is this sql engine on excel files and then what's the difference with microsoft access okay well if I understand the question correctly you know altrux is really database agnostic we can actually connect to any database so if you bring in stuff from excel from access from cql once you bring it into altrux it all looks the same to us after that point so there's some limitations with the database you have to have the driver installed and configured we respect existing database permissions so if you have permissions to that database or you have that data in an excel sheet well I like to connect to it so what's the volume of data altrux designer can handle before running into performance issues the only limitation that you know and we have customers that use it in really great ways and bring in a lot of data up to a billion records and my colleague who sits next to me at her previous shop using altrux she's a former user she was able to bring in up to a billion records would it be right on her laptop company issued all the limitation is your own physical machine and memory and hard drive that you have available so we don't forget we also have in database processing so if you're concerned if you're if you have big data characteristics type of data you can run this and then write in the database itself so we have in database processing as well. We have a few questions here so do you do the predictive functions come included with altrux or are those an additional cost and can you import Excel formulas into altrux. So regarding the predictive you have to download the predictive star kit to get the predictive categories what's important about this is they're all written they're all based on R and then you can actually open the predictive tools and edit the R code if you wanted to do something specialized or more advanced or something that's specific to you. I think the second question was about Excel formulas we unfortunately you have to rewrite some of those formulas in altrux if you have some custom formulas that you are using in your data processing currently. I'm afraid that is all the time that we have for what a great presentation Lisa and Hasan thank you so much and thanks to our attendees for everything we do. Again we didn't have time to get to a lot of the questions today but we will get those over to altrux too we'll help follow up with those answers and get those to you if you want to keep the questions coming in I will make sure and get those over appropriately. And again just a reminder to everyone I will send a follow-up email by end of day Thursday with links to the slides, links to recording and additional information again thanks to altrux and Lisa and Hasan thank you so much.


Mr. Hoosha I'd like you to take a seat and I invite Mr. Kumar to share the highlights with us of the report. Good afternoon everybody. Yeah it's obviously as Naval mentioned highly delighted and I'm looking forward to the second edition of the Influencing Influencer Marketing session from both the forum and Inca. You know I was just when Naval was speaking here I was just thinking about it you know ten years back if we had thought about you know having a session like this maybe it would have been more you know a possibility and when you look at last two to three years I think the way the digital accelerations happen and the significance of the entire space of influences etc has you know further accelerated the significance of this channel in the entire marketing space. So before I get on to some of the highlights again I would like to take this option to thank the forum team right working along the Inca team and getting this session organized. It's also interesting to notice if you look at the agenda of the how the day is that multiple topics including involving how to use this to improve brand love, how to look at it from social commerce, how to use some of this influencer and leverage them. Very interesting topics and there are already people who have done it, there are already brands who have used it and are also sharing their thoughts and their learning. So I'm sure the day is going to be more insightful. As I said as we witness the entire digital acceleration playing a critical role in the modern marketing era you know channels like influencer marketing has only become more significant and we all are witnessing influencer marketing as you know playing a vital role in you know not just in productivity of brands but shaping brands appropriately to consumers. It is becoming a powerful tool for any marketer wanting to reach out to new audiences and engage with them. As we just launched the report and it would come to all of you to your hands soon some of the key highlights that I can share here let me try and do that. It is poised to grow at a robust 25% CAGR for the next five years. It has actually grown almost like 42% year on year which is from 900 crores in 21 to an estimated 1275 crores in 22 and mind you these are not including the media activation number so that's even bigger larger you know spends associated link with the entire channel of influencer marketing. So that's why influencers are divided into macro, nano and micro creators depending on the number of followers they have and over 75% of brands consider nano, micro and macro influences as key to building and sustaining brands over using celebrities. When it comes to content people are comfortable with accessing short-form video content across platforms such as Instagram Reels, YouTube, Shorts, Mo, George and Tagata and you know others. We while you know doing the survey getting the report working on it found some very interesting findings. 80% of respondents feel that the short content formats would continue to remain the main format of content preference irrespective of the platform. Consumers have become increasingly conscious of the digital trust and authenticity of influencers and 90% of respondents who are part of the survey have pledged to be the ASCII compliant. In terms of creating effective campaigns the majority of brands using AI preferred preferred AI power tech platforms in aiding, selecting, optimizing and creating them. Over 55% of brands consider live streaming and social commerce as emerging and more effective modes to influence the purchase. So as I said this is a quite a evolving landscape. In fact today when we go and talk to marketers we have brands actually repeating the usage of this entire channel. We have lots of learning that is happening which is actually using to grow the brands in multiple areas getting new audiences. We have a lot of curiosity coming from the marketers to see how this can be used wisely and intelligently to get some more productivity. So all this is obviously helping us to navigate the entire marketing effort in this changing landscape. We hope this report will play an important role for marketers, influencers and brands to understand how influence the marketing is taking shape in the country and how they can leverage this to grow business. I want to thank you all attending this session. Have a good day and enjoy the day. Thank you.


starring Raymond Burr as Captain Lee Quince, specially transcribed tales of the dark and tragic ground of the wild frontier, the saga of fighting men who rode the rim of empire, and the dramatic story of Lee Quince, Captain of Cavalry. Might as well stay mounted, Sergeant. Looks like the stage is ready. Yes, sir. I'll talk to the agent. Morning, Mr. Church. Good morning, Captain. Did you come for them? My orders say to meet Mr. and Mrs. Horace Quiring at the Red Cloud Agency and escort them to Fort Laramay. Good. Is that their stage outside? It is. Did you hear me say good? I heard you. Good. That's good for their leaving and good for good riddance, too. Bureau of Indian Affairs bothering you, Mr. Church? Bothering's a small word, Captain. I won't try to spell it all out for you. You wouldn't believe me if I did. Suffice it to say, I am played out. Well, if they're ready. The Indians are played out, too. What's the matter with them? You don't know these folks at all? The major says Mr. Quiring has something to do with the Bureau of Indian Affairs. Basket weaving, dancing, law and culture studies, fire making, Indian mythology. Oh, I tell you, Captain, we've had a busy couple of weeks. Well, if he wants to learn about the Indians, he'd... Captain, he's been teaching. He's been teaching the Indians how to make baskets? That's the least of it. Him and his Mrs. Too touched up a few of the tribal dances and that gussies... I'll say, your orders don't mention Gussie. Gussie? She's their niece. A great hand to go around and make fire as rubbing a couple of dry sticks together. Showed the Indians how, did she? Oh, they was amazed. Oh, you wouldn't leave Gussie here. Well, I mean, seeing her name ain't set down in your orders. Oh, you wouldn't do a trick like that, me, Captain. I'll take him home. Oh, good. Of course, that poses a problem, too. How's that? You gotta find them first. They lost? Always. Let's go, Captain. Can you see them yet? I make out three heads up at the top of the rocks. Guess they're heads. That's the querying. From the distance, there's always some question. Then you get close up and... Oh, I've got to rest. Oh, dear. I'm getting lightheaded. I don't see how they got up that high. Especially the women. No, you don't. You've got to catch them in the act to believe it. And then you'd swear you hadn't seen it. Oh, active. Mighty active. Well, I'll go up and get them. Can't keep the patrols sitting around all morning. I figured they're your responsibility now, Captain. I've done all I can do. And in some. We'll pick you up on our way down. Mr. Querying. I never hoped for this. Truly a legopus mutus. Watch your Latin, Gussie. Legopus leucuras. This is strictly speaking, of course. It's a rupestrus. But you can't blame the girls for being carried away. You talking about that bird there on the ledge? I know you're going to tell me it's a white-tailed ptarmigan. But in bird circles it's a... It's a grouse. Well, yes, if you want to be blunt, it's a grouse. Horus? Right here, Winifred. Only in the broadest sense is the ptarmigan a grouse. Again, again, I'll give you nothing more. Remember, Uncle Horus? Aunt Winifred's last paper before the Ornithological Society definitely established the ptarmigan as a gallinacious bird akin to the grouse. Oh, you see, man, you want to have your facts well in hand before you take on the querying girls. Oh, by the way, who are you? I'm Captain Quince. I'm in charge of your cavalry escort to Fort Larimer. Oh, yes, indeed, of course. Well, now, I'm Horus' querying. Oh, and this is my wife, Winifred, and my niece, Augusta. We call her Gussie. Gussie. A girl's Captain Quince. Ma'am, Miss... Chickans, Captain. Yes, ma'am. My goodness, Quince. Well, she's thinking of the Australian black ash. Oh? Indeed, I'm not, Uncle Horus. We studied the Quince at the seminary. I'm thinking more in terms of the pear-shaped fruit of the Pyrus Sidonius. Well, she has you there, Horus. Oh, yeah, I warn you, Captain. They keep a man on his pace. Well, shall we make our dissent? Yes, I kind of think we better. Maybe it's a little early for them to have breakfast, Lee. For the querings? They probably struck out before dawn and roasted a buffalo on an open fire.  I know you don't like your assignment, Lee, but there's no cause to exaggerate. I thought the Indian agent was exaggerating, too. They seem like perfectly nice people to me. Pleasant, close-knit family. You spent five minutes with them. Never got past how to do. Mrs. Daggett was leaving on the stage. I explained that. It's all right. Maybe it's better you find out for yourself. The Indian agent says they know more about Indians than the Indians do. They might start telling us how to run the guard mount. I wish they'd come. I'm starved. Maybe they're lost. Oh, that's ridiculous. The Indian agent says they're always lost. They go climbing around a lot, looking for birds and things. Well, they're not lost this time. Here's Mr. Quiring. Well, my goodness. Oh, don't you bother getting up for me, Major and Captain. Morning, Mr. Quiring. Morning, sir. Oh, isn't it? Sit down, Mr. Quiring. Thank you. All right. Well, now, how nice. So this is the officer's mess, isn't it? That's right. Would you like some coffee while we're waiting? Oh, I'd love some coffee. A good cup of coffee to you. Waiting for the ladies. And the ladies? For Mrs. Quiring, Miss Gussie. Oh, the girls, the girls. See, where are they? Well, I just supposed you'd all be together. We were? We were. But that was at breakfast. I haven't seen the girls since breakfast. A little raspy in the throat, are we, Captain? No, I sort of choked. You want to watch that? That's bad business. You've had breakfast, Mr. Quiring. Goodness, yes. Why, it's after seven, Major. Oh, it was a good breakfast, too. It was outdoors, you know, open fire. All the sounds of the aurora as the sun came up and shone with its full glory on Laramie Peak. You say in open fire, Mr. Quiring? Yes, Gussie insists on an open fire. Ever since she learned how to... Well, the things young ladies learn in seminars these days. Well, I'd just open your eyes then. Mind telling us what you had for breakfast? Oh, glad to. Winifred's department, you know, the food. She made the boast, but to tell you the truth, I never thought she'd bag it. Well, sir, she wasn't up in that canyon five minutes until... Bang, bang! Oh, I'm sorry, I hope I didn't frighten you, Major. Oh, no, no, no, I'm all right. Bang, bang, what, Mr. Quiring? Oh, breakfast, yes, breakfast. It wasn't a buffalo by any chance. Oh, no, no, no, a buffalo. I don't believe Winifred could have bagged a buffalo. No, it wasn't a buffalo. No, I didn't think it would be. No, it was an antelope. See, that is a bad throat you've got there, Captain. I guess it comes from exaggerating things. Wouldn't you say, Major? I've got some business to attend to. Better get over to headquarters. But you haven't had your breakfast, Major. Well, I'm not hungry. Oh, no, no, I'll bet Winifred could tempt you with some of that antelope. Oh, my, delicate succulents. I hoped their foray into the woods was successful. I couldn't go with them. You see, I was most anxious. What foray into what woods, Mr. Quiring? What woods? Now, wait, just let me get my bearings. Now, which way is north? That way. Oh, that's splendid. Yes, that's it. There are some woods to the north, and last time I saw the girls, they were... Captain Quintz, you're to form a search party immediately. Take what men you need. Search part? Why? The land to the north is Indian country, Mr. Quiring. Of course, that's why they went. Oh, my goodness, a search. You speak as if the girls are lost. We're speaking as if they're in danger, Mr. Quiring.  Oh, I don't think they'll bother the girls. But I am glad you mentioned that. I've been meaning to have a chat with you concerning the perimeter defense of the fort. Captain. Yes, sir. Move out. Yes, now, Major. Right away, sir. I noticed last night a tattoo. It seemed to me it would make the slightest difference. I wonder if I understood you correctly, Captain. We're to look up in the trees as well. You understood me, Mr. Cybert. Up in the trees, up on rock ledges, up on cliffs. The ladies climb, sir? Climb or fly, I don't know. But you pick a spot no one can get to, except maybe an eagle, and it'll be there. Head of us, Mr. Cybert. Sounds like a grizzly. Like no grizzly I ever heard. Put your right foot down, Mr. Cybert. Let's give him a hand. It's an Indian, Captain. My poor devil. Somebody stuffed a gag in his mouth, and what's all this he's caught in? That, Mr. Cybert, is a butterfly in that. A butt? Well, how on earth? Here, give me a hand. Yes, sir. Let's get that kerchief out of his mouth. No. No kill. No kill. You're all right.  What are we caught on, Mr. Cybert? It's a handle or something, sir. Trapped down this brush. You let go. I run. I no come here again. You let go. White squaws, crazy. Yeah, I think you're right. Look where she is. Clear up at the top of the... I told you, Mr. Cybert. You better come down from there, Mrs. Quiring. No, no. You not let her down here again. I run. White squaw full of bad spirits.  Young man. Keep working, Mr. Cybert. Let him go when you get him free. I'll go up and get the... the girls. I heard you, Mrs. Quiring. And you deliberately let him go. After I told you, he bothered us. He won't bother you anymore. See, down there, he's running like fired on. They've flown at Winifred. But with all the commotion, who can blame them? Indeed. Indeed, first the Indian. And we silenced him. But now, Mr. Gussie, something important, Captain. Ma'am. Ma'am, you got to understand a few things about the West, about Indians, about Army garrisons. Well, now, if that isn't what we're trying, our level best to do, Captain Quince, and how better to do it than by going directly to nature, studying the birds of flight, the animals. Miss Gussie. Yes? Miss Gussie, this is Indian country.  Now that's plain silly. It's a treaty, says so, Mrs. Quiring. Took a long time talking, negotiating, giving and taking. And finally, it was decided the Indians were the only ones with rights to this land. The Indian didn't mean us any harm, did you think, Aunt Winifred? Fear this thing from his mind. He was nosy, that's all. Gussie and I had stolen up on...  We'd stolen up on a bittern, a sharp-shinned hawk. Aunt Winifred, your language. I'm breaking it down for the Captain. Remember the problem we had earlier about what he called a grouse? Oh, of course. Ma'am, if you'll let me get a word in. A bittern, a sharp-shinned hawk, a goshawk, a bald eagle, and a crow. A crow, Aunt Winifred? The Indian was a crow, wasn't he, Captain? Yes, ma'am. He was a crow. And to use her words, Major, when the crow persisted in making so much noise, we did the only reasonable thing. That's when they dropped a butterfly net on him and gagged him with a kerchief. Wait a minute. I've lost track. Is this crow a bird or a... Indian. Captain, the Army's been my life for 15 years. But this business with the choirings may bring it to an untimely conclusion. I'm about to write Washington and if they send another party out here in the name of investigating anything, I'll resign. How long the choiring's going to be putting up here? He hasn't said. But this is an order, Captain. From now on, I'm assigning you to a full-time watch in the three of them. We can't always be sending search parties out to find them. There's no watch in the three of them at one time. They got away a pair and off or striking out alone. Sign a man to each of them. But I want them accounted for at all times. Hope we don't have any Indian uprisings before they leave. Couldn't spare the men to fight them. Oh, no. That'd be Mrs. Quirey. What on earth is she doing with Sergeant Gors? Talking to him, anyway. I'd have to get closer to find out what about. You go ahead, Captain. I'm going over to the Suttlers. I just remembered that Mrs. Daggett's out of a hatpin. What's she saying, all right? It won't direct statements. Let me make this nice Sergeant understand. What's wrong, Sergeant? I don't rightly know, Captain, something about the way I walk or don't walk or something. The ladies, she... Oh, you two haven't met? Formally? Well, now we... She just come on me, talking. Allow me, Mrs. Quiring. This is Sergeant Gors. She can, Sergeant. Yes, ma'am. Now then, did you say Gors? Yes, ma'am. That's my name, Gors. Wonderful! Cassie and Horace, a quince and the Gors on the same army post. Oh, I can't wait. This is too good to keep. You'll excuse me. Yes, ma'am. And don't forget, Sergeant, Toa... She sure got a burr somewhere, isn't she? Maybe. I... You think I walk funny, Captain? I'm beginning to think everyone's a little funny around here, one way or another. Hmm. What's your name? What's she going on about my name for? She knows what it means. Well, what does it mean? I don't know. Me, I got a couple of choices. They can't decide if I'm an Australian black ash or the pear-shaped fruit of the pyrus sedonia. Captain, I'm going to go get me some beer. See you practice on the way over, Sergeant. I don't forget. Toe out. Now, you just got to make up your mind We can't come looking for you every now and then. Well, I've never lost, you know. Never. I always know where I am. I have maps and charts. Well, it's more that I don't know where you are. Holdin' your loss. No, sir. I'm not. I'm just... Oh, well, that's a different matter entirely. Don't worry. I'll get his back. I have maps and charts and things. Can't understand Winifred, though. That's my wife, Winifred. Yes, sir. It's not like her to steer me wrong this way. Usually, Winifred's word is her bond. She says something, it's true, but this time she... By the way, I don't believe I caught your name, Sergeant. My name's Gorse. Oh, yes, Sergeant. Oh, that's a fine name. Imagine you're quite proud of her. Did you say Gorse? I sure did. Oh, my. That's a good one. Now, the joke's on me, Sergeant. It is, huh? Well, that didn't steer me wrong at all. She said, oh, my, this is wretched. Yes, it is, this is wretched. She was telling me about the Gorse, you see. And I was quite naturally excited about that. Why? Well, for a good reason. I assure you. You don't run into Gorse every day, you know. Well, I don't, but... Now, look here, Mr. Quire. And I quite naturally assumed that Winifred was referring to the common furs or wind. And that's why I struck out to see it. Perhaps snip a sample or two. I sure don't know what you're talking about.  I hear everything she says, and I don't know what she's talking about, neither. Well, then as I rode out, I got to thinking, perhaps Winifred wasn't referring to the common furs or wind at all. Yes, I said, well, it's been years since I read her paper on the Gorse, but I remember the main points, all right? So, let me see now. There's the Gorse Linnit, the Gorse Chat, Gorse Hatch, Gorse Hatcher, and Gorse Hatcher. What are you talking about? All them Gorses. Oh, my. Oh, no, say. Oh, shame on me. Well, I never remember to keep it simple for the lemur. Well, I never remember. Well, to begin at the beginning again, we're back now to the furs and the wind. That's very like Juniper.  Birds? Yeah, birds, songbirds, many of them. You like birds, is that what you're saying?  Birds and I, oh, I'm sorry, but a sergeant named Gorse, Winifred will just have to do a paper on that. Oh, we got a lot more interest in birds than that out here. You do. Oh, sure. Well, you don't want to mess around with common old Gorses when you can come up on a, uh, say, the Jayhawk. Yeah. He flies backwards, you know. Backwards? Then there's the Mugwump. Mugwump? Mm-hmm. Did you say Mugwump? My goodness, I thought they were extinct. Oh, no. No, we got them all over out here. Then there's the three-footed Firebird. Three-footed? Stands on one, rubs his other two together, makes fires. Gussy will be thrilled. I just can't believe this. That's why I come up here, Captain. They're really leaving. That's what they say, pushing farther west on the trail of a three-footed Firebird. I told them California, up high in the Sierra. At least, why, it's the last covey I saw was there. All right. Captain, Mrs. Quiron's going to give you full credit on her paper about them. You better count heads here. There's Mr. Quiron talking to the major. Well, I seen Mrs. Quiron not two minutes ago. She was helping the squad do some Indian beadwork. She isn't doing it now. Find her, of course. Oh, now, she ain't run away again, Captain. I want them all three on that stage, Sergeant. Yes, sir. Keep an eye out for Miss Gussy while you're at it, Sergeant. Yes, sir. Captain? Yes, Mr. Quiron? Well, now, I wouldn't want to miss shaking your hand in farewell, Captain. The stage is packed. I've said my goodbyes to the major. Can you lose something? Your wife, and I don't see Miss Gussy either. Well, now, let me see. Well, if I were Winifred, now, where would I go? I always begin that way easy, and then I let my mind function as if it were Winifred's mind. The Root House. Never mind the settlers. That far? Well, when we were... What's she doing at the Root House? You didn't know. She found a small flowering gorse and thought it only failed. Never mind. What now? It's Miss Gussy, Captain. Yes, see, Captain. We're all accounted for. There's no problem. I'm afraid there is, sir. It seems Miss Gussy was demonstrating how quickly she... Well, they don't think it's too serious, but under the circumstances, they took her to the post-hospital. Hospital? Under what circumstances, Mr. Cybertz? Burned hands, Captain. But the doctor says in a few days she'll be able to travel. In a few days. Mr. Cybertz, this is an order. For the next few days, no dry sticks for Miss Gussy. Now move out. The book, The Fort Laundromat, is produced and directed by Norman Macdonald and stars Raymond Burr as Lee Quince, Captain of Cavalry, with Vic Perram as Sergeant Gorse. The script was specially written for Fort Laundromat by Kathleen Hyte with sound patterns by Bill James and Tom Henley, musical supervision by Amorigo Moreno. Featured in the cast were Howard McNeer, Virginia Gregg, Parley Bear, Shirley Mitchell and John Daener. Jack Moyles is Major Daggett and Harry Bartell is Lieutenant Cybertz. Company, tension, dismiss. Next week, another transcribed story of the Northwest Frontier and the troopers who fought under Lee Quince, Captain of Cavalry. Yours truly, Johnny Dollar, is no signature on a Valentine. Not that our danger-loving insurance investigator is opposed to romance. It's just that the detective's profession calls for a pragmatic approach to life if he wants to go on living. That's why, no matter how lovely a lady may be, no matter how attracted to her Johnny Dollar may be, solving the particular case he's working on always takes precedence over sentiment. The case he's working on now calls for courage as well as caution and it's a baffling mystery thriller you'll enjoy following clue by clue as you listen to yours truly, Johnny Dollar, Monday through Friday evening on most of the same CBS radio stations.


Hey pickup rates one-to-one, it's all secures! Fist size element on the east corner on Fuji town soon on foot patrol moving west, I line to follow. Nissan 248, 6.1, 3374 feet, infantry in the open, uniform echo, 0219, 2380. Talk on from JFO lightning 92 alpha, southeast 260, egress right pull Nissan Saab 9 Black 11, advising ready for march restrictions.


Russian troops regrouping in Kupyansk-Lyman directions after significant losses. Having suffered significant losses, Russian troops are now regrouping in the Kupyansk and Lyman directions, as well as redeploying the newly formed brigades and divisions from Russia. The relevant statement was made by the Ukrainian Defence Ministry on Telegram, referring to Commander of the Ground Forces of the Armed Forces of Ukraine, Colonel General Oleksandr Syrskiy. The operational situation in the Eastern direction is remaining tense. After a month of fierce battles and suffering significant losses in the Kupyansk and Lyman directions, the enemy is now regrouping its forces and means while also transferring the newly formed brigades and divisions from the territory of Russia, Syrskiy noted. In his words, Russia's key objective is to increase the level of combat potential and resume active offensive actions. At the same time, enemy units continue to inflict damage with artillery, mortars and aircraft. Under such conditions, we must promptly take all measures to strengthen our defences on the threatened lines and advance where possible. In order to implement these tasks, my regular working trip to the Kupyansk and Lyman directions was scheduled. Syrskiy stressed. According to Syrskiy, in cooperation with the commanders of the operational and tactical groups and brigades, all necessary decisions were made and measures taken to strengthen the defense and repel enemy attacks.


I'm gonna do Fuen Caliente to El Pilar. It's 17 kilometers and 1,400 meters of elevation. It's gonna be an epic run and I thought I'd just give you guys an overview of What gear I'm bringing on the run including hydration and nutrition strategy So I'm just sitting here basking in the morning sun. I just had 7 bananas So it's about 9 30 now in the morning. I had 7 bananas Well, I started a day with like half a liter of water Then I had 7 bananas now and then I'll start my run in about two hours Because there are there's a lot of I have to take a few buses and stuff like that So I got two hours to digest about 700 calories and at that point my stomach will be fairly empty Ready to start taking in the run nutrition. Let's talk about that in a second First I want to show you guys what I'm wearing. So first of all, I'm wearing these the ultra superior 2.0 shoes Really solid trail running shoes very comfortable very good and underneath. I got the in Jinji toe socks, of course Then I'm wearing the compressed sport calf sleeves And I like them a lot and then just like a six shorts on my upper body I have first of all, I have the heart rate monitor for my Garmin 6 30 Super epic watch and then I have a t-shirt from craft and then long sleeve shirt from Sockney And I might or might not use this while I'm running But I'm the highest point of the run is gonna be one thousand nine hundred meters So it might be a little cool up there So I'm just bringing this just in case and also for the Sun in case I need to protect myself against the Sun It's nice to have a long sleeve shirt along with me on the run. I'll be wearing a cap Against the Sun and of course sunglasses So that's basically what I'll be wearing Let's take a look at my backpack So here I have the Osprey Rev 6 backpack and By the way, I'll put links in the description to all the different gear that I'm using affiliate links And if you want to buy those you can click the link and go ahead and buy it And if you do we get a little bit of a commission for sending you there But the price remains the same for you. So it's a good way to support the project Anyway, here's the backpack really nice backpack Inside it. I have a few things First of all, I have the GoPro Hero 4 silver camera, which is filming right now It stays in this pocket and in this little pouch. I have my photo camera the this one the Sony Cyber shot I can't remember the model right now. I'll put it in the description Take some cool pictures from my Instagram account that you better go check out the link is also in the description And I've got my money my cards my bus card all that stuff my phone and I have the number for Girl that's staying at the camping that I'm staying at right now just in case of an emergency I can call her And there's a car there that she can use just in case right and I'm also gonna get the number for the taxi People because after my run I actually have to get home and I need to rely on hitchhiking I have to find some tourists and ask them if I can catch a ride and if I can't do that I'll have to take a taxi so I need their number to then I'll also be using these my brand new black diamond distance set Trekking poles carbon super light like 150 grams each they fold out obviously And they're just like really nice to to when you're going on steep uphills To help save the legs a little bit and help out with the arms So I'll be using those I tried them for the first time last week when I did farro the fun caliente to Los Canarios That run and that's the first segment of the trans-vulcania race today I'm doing the second segment of the trans-vulcania race, which is from Los Canarios to El Pilar So yeah, they'll come in handy. I'll make a review of them at a later point for sure now Let's talk a little bit about my nutrition so First of all, yeah, as I said, I ate those bananas and then in the back back pack here. I have a bladder of one and a half liter of water With about 150 grams of sugar and a little bit of salt In it. So this is my this is 150 grams of sugar. That's about 600 calories so that's gonna fuel me through my Two and a half hour run probably and then as I finish I'll start eating my recovery Meal, which is gonna be of dates. I have about Maybe 150 grams of dates and then a bag of dried bananas About six bananas in this pack Hopefully I'll also be able to find some water at the El Pilar Place when I arrive there just like a area for people to cook stuff and like, you know camp and stuff So there's probably a little bit of water available there. So that's pretty much it. That's that's it.  That's everything I've got As I said, I'll put links in the description if you want to check out the gear in more detail I really look forward to this run.  Sun is out and not much clouds up on the mountain I'm a little nervous as well. Obviously, it's gonna be pretty intense It's the toughest run of my life basically But I'm gonna force myself to keep the intensity easy though Because last time I did the long run last week. I pushed a little bit too hard I mean, it was all good fun anyway But I need to learn how to keep my intensity low when I'm doing these long runs with all this climbing and everything I just need to But you know, I have to walk I have to hike those uphills and That's part of the game. So that's nice with these trekking poles as well. I think that's about it I love gear. I love equipment. I love tools. I love technology And I'm really excited about a lot of these items and as I'm getting more and more into running more serious about it I'm also getting acquiring more and more Gear and I think that's that's a fun process I really like it like my latest acquisition as I said was these trekking poles and it's just I don't know it It just it makes it makes the whole thing all the more fun Like I remember when I got my first Garmin watch and then later when I got this one. It was just like It took my running to another level because suddenly I mean, I don't know I just I also get excited by having cool tools, you know, so anyway, I hope your running is going well Tell me in the comments How it's going What kind of equipment do you use maybe maybe you've tried some of the equipment that I have here Do you have experience with trekking poles anything like that? Share it in the comments I'd love to hear about it. Please subscribe. Of course, if you haven't done so already stay tuned for more videos coming up Thanks for watching. See you around