Hello friends and welcome to today's episode where we are gonna be kicking off with our series 7 content here on the channel My name is Lee also known as Osiris, and I hope you enjoy and find this episode useful It's not so much about a team per se But it's more to do with some resources that are available for you guys to kind of give you a little bit of a head start With the new format coming into effect on the 1st of November But before we get into that there are a few disclaimers here because obviously there is a lot of information yet to be officially confirmed We don't know any stats about the Galarian birds. We only know they're typing We don't know any information really about them outside of that We don't know anything about the new Regis or Galarian slurking So we have got a bunch of information there that's not been Released yet and we also only have information from our data mine earlier in the year that we're kind of basing all these assumptions off Which we don't know to be a hundred percent correct or not like the the move tutors that are available to the new Pokemon coming into the game that we got with the Isle of Armour and do we know about Move tutors that might be available in the Crown Tunder There is a lot of information there that is not been released yet that we have no idea and will not know about until the Crown Tunder is actually released So the format that we are going to be about to jump into could be very different But it's not really about that We have a facility now where we can play a lot of the new Pokemon together in a format against Other players that are playing the same format It means that we can start to learn what a potential meta game or as close to a series 7 meta game as possible Could be right now and so what you want to do as I said, it's on an alternative Showdown server at the minute It's not on the main one the official one and that's for good reason That is for all the reasons that I've listed below They don't have all of the information yet on the format on the Pokemon so they're not putting The format out and that makes sense because it's obviously Nothing's been a hundred percent decided yet. So if you want to play on this new Server you can hop over to Google and then just type in this address if you want which is the sports dot psim And that will take you over to this showdown server the alternative one that I'm talking about where there is a Series 7 ladder available for you to play on now the link to this server will be down in the description below So you'll be able to just use that and jump straight over to this server Once you're here what you want to be looking for in the format drop-down is the national decks DLC to Vgc format that's the one you want to be playing That's the one that you're going to be wanting to build your teams with you can see a little bit of a bigger Look at it. And once you're here, you can jump into the ladder now Like I say you need to have an open mind with this This is going to be a tool used for learning the format or potentially what the format will be like But more importantly, it's about trying combinations of Pokemon seeing what works with the new Pokemon They're going to be introduced Obviously with all of the old Pokemon that are coming back from the band list and the ones that we already have available to us That is going to be series 7 excluding mythicals and legendaries now The other thing just to mention before we jump into this today is obviously the ladder With the format that we've got available to us. There are just some discrepancies You're going to come across some teams that are just not series 7 legal at all I mean I put up a tweet earlier on today about a game that I was playing last night on this server Where I came across five Eternatus and one Mega Blastoise like that is just never going to happen in series 7 So with those players if you pair up with them or whatever just ignore those battles The majority of players are on this server are actually genuinely trying to practice series 7 with Legitimate or as close to legitimate as of right now Series 7 teams that we know of so you're going to be fine. And like I say, it's a great tool It's a great resource to have available to us right now to start testing Practicing getting familiar with the new Pokemon that will be coming into the format and the team that we're going to be using today I'll drop this down in the description as well with a poker paste It's something that I've just been playing around with the last couple of days. It is based kind of around metagross I just think metagross is it's so nice because I've played old formats where metagross has been a beast And it's actually it is a beast in this new format. I really love it. It's so good Especially with the dynamics mechanic and we're playing weakness policy on it Which will probably be one of the more popular items that you'll see played on metagross I would imagine of especially early format and With the clear body as well obviously ignoring any of those kind of stack drops from intimidate and speed drops from things Like bulldoze or whatever you want to pair up with it I've paired this up with tornadoes because it's obviously got that prankster ability got that prankster tailwind It's just invaluable for speed control. Um, I've got brutal swing as well, which is a nice Utility to use with procking metagross's weakness policy Obviously it hits everything on the field boosts the weakness policy and then metagross can literally just start Kowing stuff and boosting it itself with it's great dynamics moves that it's got available to with the steel spike And the max quake there Um, we play off the the zen headbutt as well with our indeedy who can bring the psychic terrain So we've got terrain control here. Uh, and this also pairs nicely with our kind of trick room model the team with gmax hattery um Obviously with the redirection allows us a pretty seamless way to set up trick room most of the time And then we've got talk alt to obviously come in and take advantage of the trick room as well And then rounding off with gmax minisoul Which is obviously Plays nicely with the talk all and gives us a bit of coverage against some of the other weaker things that this team might otherwise struggle with Um, like I say the team uh poker base will be down in the description And that is something that I want to put down there as well If you guys want to jump over onto this server and start playing at least you got a team Straight away that you can just put in you might not be to your taste But at least you got something to get you started with there's nothing worse than coming on to a new server In a new format and sitting in a team builder for hours thinking What am I going to play at least now you can just use this jump in start playing And it'll probably inspire some ideas. You'll probably face other teams You'll get ideas if you're on you'll start playing things that you think in your head are the best things to play So hopefully it is all helpful and that is the main thing about this video It's making you guys aware of this server And giving you a little bit of a push in the right direction to get yourselves familiar and start doing this So we'll have a couple of games as always we always do we may as well And it'll give us a chance to see some of the at least a little sight into some of the teams that are being used at the minute on the ladder So we know a real way to deal with trick room. I mean magnazone is Good against our psychic call for sure. Um, it might be better off us going tornadoes metagross, you know They're probably gonna tailwind though. That's the thing and they're gonna out speed us if we go tailwind So this is where our trick room mod probably comes in a little bit stronger with tokel in the back that can deal with the magnazone and then To be born venus all here because venus all isn't bad against the majority Obviously tapu lele and cinderace give us a few headaches But it will all depend if that their speed control is around late game or not Okay, so we've got magnazone and cinderace. I think we've got a pretty seamless way to set up a trick room here So we can definitely go for that and you know Go follow me and no no no no no no no no cancel wisest. This is really annoying this overlay sometimes It clicks moves that you don't want it to click So you've got to really pay attention to the text here had a game earlier Where I was like g max fine lash the uh the gochomp And it like miss clicked max ooze and i'm like it's like the worst worst thing to happen So if you're using custom overlays, you should and just be careful because some of them a little bit awkward to Deal with now. This is ideal for us. Honestly. This is like perfect because now we get our trick room up We get tolkal onto the field. We're in an amazing position because we can Just go dazzle and eruption if we want or we could go I think Because the thing is the the magnazone's probably got the sturdy ability So we're gonna have to double into it really realistically Um, why are we yeah? We want eruption Is the cinderace gonna stick around? I don't think we need to worry about the cinderace I think we just max and go g max Well, let's go g max mindstorm and get rid of the the electric train get rid of that boost So we'll go eruption And mindstorm into the magnazone there Um sucker punch, which is fine We need to take away the boost the cinderace goes down. It's probably not enough. No, but I don't think magnazons Yeah, this deal spikes fine with the special defense boost that we've got there Okay, so we've got our terrain set up magnazone on the field Doesn't look like my opponent's got too much to come in now and really give us any problems with the psyche train up as well It's kind of like a deterrent for urshifu when it comes onto the field. So now we can just um Yeah, make sure we are clicking the eruption button and then go for that g max smite into the gar chomp And yeah, I feel like like hard trick room size bomb is very strong in this format as well Obviously, it's very early days. Um I originally was testing stack attacker where the metagross was and we didn't have the tornadoes in but um, yeah It's been really good But I've kind of preferred the metagross to stack attacker, which is strange I don't feel like stackers like the more the the best thing in the size spam team at least for me Other pokemon that I feel like are very strong that I've kind of jumped out at me. Uh things like, um Tapu finny have been incredibly strong. Um, and like no surprise really thunderous as well Another great pokemon. Uh, so there's lots There's just a lot of the new pokemon coming into the format as you can imagine because of how good they are Um, doing a lot of decent things. So good going my opponent will jump into another one I don't want to keep this video too long as well. So if you can keep it under 15 minutes, that'd be good And uh, this is one of the examples I'm talking about um You're going to come across players that are doing this on the ladder just to try and be top of the ladder or whatever But like I say, we're not on the ladder. It's not super important The most important thing is the information that you're getting back from the games from the practice that you're putting in So don't be precious about your rank in this ladder. It's not important The the most important thing about this ladder is don't get annoyed or triggered if you come across guys like this They're just doing their own thing and let them do their own thing All it matters to you is the information that you're getting From playing this ladder getting familiar with these new formats getting familiar with these new combinations new pokemon Outside of that like I say what I do with these teams just click off them forfeit It doesn't matter move on majority of the teams that you're going to come up against on the ladder Ha, okay, I'm gonna be I'm gonna be actually legit teams. Okay Um, like this is rare I was playing for a good Couple of hours last night and I came across one team that was like that the rest of the time It was all teams that are genuine series seven teams There are more genuine series seven players on this ladder than they're not But like I say it's good in a way that we've got it for the video to show you guys that that's that sort of thinking pop Up, but don't get don't get like annoyed by it. You can just forfeit and move on Um, okay draggapult tokens he try and like I say one of my favorites rillaboom Incineroar and stack I really like the look of this team I think it's a very solid looking team very scary looking team Got trick room there. It's got the redirection speed control You've got potentially a weakness policy maybe on the draggapult. I don't know it can be more supportive And double fake out which is just really Good support option. Right. Let's get into this one. Um, what are we going to do now? Trick room mod isn't the greatest here, but metagross isn't too bad The thing is the one thing I would have to maybe rely on a little bit is if um I'm going to go tornado this metagross here Uh, we can I think we need indeedy for the the terrain support and probably Talk all in case the trick room goes up Um It's tricky though because I don't really Is venus or better? Maybe just in the back slot because venus or generally isn't bad against more stuff here um And it should add speed heat run as well and unless they've got max speed heat run Okay, so draggapult kiss we can tailwind Um, we could actually switch into indeedy here. It'd be kind of cheeky But it imagine they probably want to go they might even proc our weakness policy You know if they max pulse Which you would expect them to maybe do but they probably want to go airstream dazzle to kind of at least match speed Control if they're going to do anything. I would imagine max draggapult go airstream into Tornades and glean to get rid of it. But that will do us a huge favor if that happens because I meant across gets through this turn unscathed. We don't have a way to proc our weakness policy, which isn't great um But then we do get indeedy onto the field so we can then max and start taking advantage of our um Psychic terrain But there's the airstream yet and the dazzle No, just a slash. Okay, so that's fine. Um, okay now we get indeedy onto the field Because now they're going to be put off going for anything other than Um, they're not going to phantasm for sure. So we could protect here Take advantage of that max and go steal spike. Like do we go steal spike into the toggle kiss? Are they going to switch out into something like incinerole? I mean the defense boost isn't going to be bad anyway I'm going to attack into the draggapult because I feel like the the toggle kiss could switch out And we're not going to see that That's interesting going for an airstream again. It's just fine The defense boost like I say is going to be useful Uh, just a dazzle. All right.  I mean the dazzle crits are going to do a lot of damage I'm miss clicked again Okay, we've got to double protect somehow. This is what I mean about these themes They're like you need to be super careful about what you're actually pressing We do get the plus two defense, which is nice It sets us up decently against the draggapult now the draggapult has got phantom force now So it can dodge a final attack. So whatever comes in um It's more likely to be yeah, really boom makes sense So I think what we'll do is switch into venus or I think the draggapult's probably going to phantom force and we will We just max mind Good mindstorm. It takes away their ability to um, yeah, let's mind storm and make sure we are mind storming I want to switch into venus or and mind storm the really boom Like I'm not worried at all about the draggapult now. It's not posing any threat I don't think they're going to plant letting them my phantom force, but it's a two turn attack. Um I think They're more likely to fake out and dee dee maybe no just going straight for the heatran. Okay. It's got the balloon there But that's fine dragon darts super fine.  They're gonna. Yeah I mean they're gonna try and get really boom back onto the field now Which is like it's all right um I think we could we could potentially just double into the heatran with a sludge bomb earthquake, you know Because if the real a boom comes back onto the field like draggapult could dragon darts. Yeah, it's gonna. Okay. That's fine We'll get rid Oh the heatran actually out speeds us what? Okay, well we get a weakness policy boost So we we'll get rid of everything. I didn't expect the heatran to out speed us like generally like heatrans normally run quite slow, but um Obviously Can't always rely on that. Uh, they are quite speedy pokemon in general and we'll just uh, yeah, well zen headbutt And that should seal the game up for a very close game But uh, yeah, there we go. We actually have speed there the real a boom so just be aware of the speed tiers on certain stuff and Yeah, that was a that was a nice game at least and um, yeah, we're going way over the time now So like I say, this was a bit of information for you guys To have in the video to give you a platform way you can come and practice. Hope you found it useful Really, I hope you do. There's a poker base down below of this team. So hopefully that helps you as well And um, we'll be back very soon with more series 7 if you'd like to see more content more teams and just going and playing on the ladder Please let me know down in the comment section below leave your comments And let me know because super happy to do more content like this until we get the official ladder Up and running and doing more stuff around teams and calls and different combinations that we can see at the minute With what we've got available to us. So yeah, I'm gonna leave it there friends Thank you so much as always for tuning in have a great rest of your day And I will see you for another episode very soon. So until then take care and bye. Bye


In the centre circle, run and go the half way, spray it left to right, he puts that turn of pace on right into the area now. What can he do, cuts out his right foot, shoots, it's in! At least the shot, I think it may have taken a deflection, but he went inside Valley Parade, there he goes, because they have a three goal lead, there again, Stevenage. Brilliant performance, that's it. Oh, what a fantastic goal again, was it tiny, great again. Shows all his pace, it's a trickery, this time he comes inside from the left, onto his right foot, great strike again, don't know if it took a deflection, may have done, but it's on target. Surely a claim in the area, fantastic goal, three-nil-city, absolutely great... ..fundly deservedly won. Bradford City three, Stevenage nil, here at Valley Parade. The Stevenage players looked unbounded, Valley Parade on its feet, Mark uses Bradford Army, bringing it around towards this stadium.


Call the order of the meeting July 16th regular council meeting will the clerk call the will the clerk read the quote, please Thank you mayor for changes to be of any true value. They've got to be lasting and consistent Thank you clerk will call the roll if you'd like to Push number one, please 15 present Here is a quorum tonight. We have Dylan Lindow from troop 801 Joining us tonight. He will lead us in the Pledge of Allegiance Pledge of Allegiance to the flag of the United States of America and to the Republic for which it stands One nation under God Indivisible with liberty and justice for all Thank you and welcome tonight. We'd like to Approve the minutes I've been Hammond. Thank you. Mr. Mayor. I move to approve the minutes of the last council meeting It's been moved and seconded to approve the minutes of the last council meeting. Is there any changes or discussion? See none clerk will call the roll 15 eyes Motion carried tonight. We'd like to introduce the new executive director of the Sheboygan County Economic Development Corporation if Gary Dalmas and Randy Hopper would like to come up Thank you councilmen and council women. I'm Gary Dalmas. I'm the chair of the Sheboygan County Economic Development Corporation First of all, I say, thank you for your support for the past two years We have exciting news and that we have a new executive director that started on July 9th And I wanted to bring Randy here to introduce him to you and haven't say a few words So with that I'd like to introduce our new director Randy Hopper from the SEDC. Thank you, Gary First off, let me just say it's it's great to be here. I'm looking forward to working with everybody I had a great meeting with the mayor last week and I'm looking forward to all of us Trying to drive economic development in this area I think a lot of the problems that we have in our state in our county start with helping people find an opportunity for a job I'm looking forward to partnering with everybody on the council to try to get that accomplished Please feel free to call me anytime. I would love to set up one-on-ones with every one of you And so I'll be calling you to do that. We get a little bit of opportunity to discuss the future Thank you very much for being here. Thank you, Randy and welcome to Sheboyan City clerk, do we have anybody with the for the public forum? Yes, we do first on the list is Dave gas Dave, can I have your home address, please? 1921 and you can go ahead Thank you, everybody. Thank you for allowing me to speak. I'm Dave gas an attorney with Rody Dale's law firm I'm here in behalf of Brett's towing and Brett graph graph and I'm here on the resolution to award the contract for towing services and Brett's perfectly capable of talking on the subject, but it's an emotional subject So I'm here to talk more to articulate his position on this as much as to be really legal But what I'd like to Suggest in in our position is Brett's position is that The current contract of awarding or the process of awarding to one bidder is not necessary There's another arrangement that I would submit as a fairer arrangement to the city I mean it accomplishes the task for the police department And I'm not here to criticize any of the other bidders. They're all capable bidders Some I think are more capable than others, but they all have the ability to provide towing services But unfortunately the current process forces the city to pick one even when that disadvantages Businesses that are tax-paying within the city and I don't think that's fair when you don't have to do that And why do I think you don't have to do that? It's because there's another arrangement out there that I believe Accomplishes the city purposes and is still fair for the business and that's the rotational arrangement whereby You rotate among the qualified bidders and you don't pick one And why do I say that? Well first of all, what are the city's interests in a towing contract? I would submit that the city's interests in the towing contract are really two-fold one How much do they have to pay for law enforcement? for Evidentiary toes that they're responsible for you're worried What what is your cost going to be and secondly clearing the scene of an accident efficiently and expediently and I would submit that a rotational basis does that just right as well as being fair to all the different Businesses that are bidding and why do I say that? Because the qualification process will make it fair you only get to be on the rotation if you qualify But more importantly is there's already an example. It's been in place for decades That's the county the county's been doing a rotational system for decades They have quadrants where people are rotated based on the quadrant they're in and as I understand it's worked very well and I would just ask that the council really Commit to doing a rotational basis. I understand there may be some concern about do you need some more time to basically implement that? And I would agree you probably do I don't think you need more than three to six months I could be wrong on that, but I would think you could put that together based on the fact that we've got a model in place And that you move to that in that way then you can accomplish the goals for the city law enforcement as well as Are fair to all the bidders especially those that are within the city limits? Paying taxes and providing jobs to individuals in our city so with that I would Support and would ask you to consider Going to a rotational committing good to going to a rotational basis I understand there would be some lead time. I don't think it needs to be longer than three to six months But did you go to a rotational basis? as the best way of Accomplishing the goals for the city and being fair to the bidding Tax-paying businesses in the city. Thank you. Thank you, David And then we have Calvin and I don't want to butcher your name. So it's Calvin If you could spell it for me that would be terrific KESW Edr Kesswetter Kesswetter, okay, but you're for years. I just didn't want to do it to you. You'll have five minutes, sir All right. Thank you I'm gonna follow my notes because I'm not as polished the speakers mr. Gas Thank You mr. Mayor and the entire council for giving us the opportunity to speak and before you My name is Calvin Kessler. I'm a service manager for Depot Auto Service and towing. I've been doing this for 14 years The existing towing contract that is scheduled was scheduled to end as of May 1st The one that we're in right now has been postponed several times already bringing us to where we are today Now I have two main issues and I really am gonna try to be brief Mr. Graf brought up the suggestion of switching to a con or from the contract system that we have now in the city of Sheboygan to a Rotational system as exists in the county. I want all to know that Depot is 100% behind that concept We believe it can work We can work together to make this work All the person Lesser began to investigate the idea but she ran into some roadblocks Kind of slowing it down a little bit and she proposed that the last ppns meeting a one-year contract To allow time to research This issue now we understand it takes time as mr. Gas mentioned but we believe that this could be accomplished by the end of the year and We would like to propose that the city and deep will continue to extend this Contract that we're in right now just like we have since May Keep on going to the end of the year and Then by then we should be able to have time to work out the details to get a Rotating list working now at that initial meeting with the ppns and the police chief and finance director recommended arrow towing for this and Only one all the person raised an objection and question them about their choice and this being the best selection for the city of Sheboygan and No real true answer came from that now. I'm asking you as the committee as a whole please consider the facts Number one arrow's prices may appear to be lower on the bid But the contract allows for towing when a tow is done outside the city limits They can be charged mileage at $1 per mile round trip now I interpret this to mean that they can add mileage charges to every tow to their facility That makes the price higher than even the highest bid that was given from the person in the city of Sheboygan To for some the car that just got towed is the only one they have They need to get to their personal belongings or to their vehicle They need to walk take the bus ride in a cab or find a friend to take them there If it's located here in the city, that's Pretty easy, but if it's way out in the country, that's going to be much more difficult for the citizens of Sheboygan Three the contract requires the contract to tow company to respond in 20 minutes now I use map quest to pick three common locations that we have been called to by the police department Now keep in mind these travel times are perfect conditions and no bad weather No traffic jams no road constructions and being in your vehicle driving from arrow shop on highway 32 to City Hall it takes 13 minutes for depot it takes one From arrow to Whedon Creek and sell 12th Street 18 minutes For depot 11 and from arrow to 4th and North Avenue 14 minutes and for depot at 7 Now it's clear that the contractor outside the city is not practical in a 20 minute or less time allowance That's in the bid proposal would be pushed to the limit and or exceeded The only way to make it in 20 minutes is to speed Snow emergencies when we do snow emergencies in a city of Sheboygan. They go very rapidly There's no time to be driving out to the country to drop cars off come back and pick up the next one They have to be done very fast 5th in my final point as of right now Arrow does not have any secured storage on their site that we are aware of you drive by on highway 32 You'll see crash cars sitting all over in the open on highway 32 according to the bid request You must have secured storage meaning a fence with a lock or a building We don't know if they have permission to even be putting that many cars on that property So despite the recommendation has come through we are asking Please consider what is in the best interest of the city of Sheboygan and its residents having to Drive all the way out to the country and we're not talking about just outside of city limits We're talking about about eight miles outside the city Will be an inconvenience to the public as well as to the citizens of Sheboygan Excuse me Kelvin. Would you like an extra minute? I'm sure I'll just wrap it up in motion to approve Okay, go ahead Now as far as picking the lowest price bid Right in the bid proposal on the first page the city reserves the right to reject any and all bids and award the bid that is deemed the most Advantages to the city of Sheboygan Not the cheapest and it even states that although price is a a major concern It is not the only factor in determining who will achieve or who will acquire this Contract as it sits. So the decision that you make tonight is not going to only impact the city and its residents But also local businesses businesses here in the city of Sheboygan paying city taxes and the people they employ Thank you very much for your time. Thank you, Kelvin That would be it Thank you under his mayor's announcements I remind everybody Eastfields Lakeshore weekend is the 27th 28th and 29th at South Pier. Hope to see you all there August 7th. We have National Night Out, which the fire department and police department participating in Walk against crime that will be led by the Sheboygan Police Department and the Sheboygan Sheriff's Department Again, I'd like to see all the citizens and welcome all the citizens there That's all the announcements. I have we now have a hearing an amended To the text of the city ordinance zoning ordinance relating to temporary signs so as to add new Subsection for non-commercial temporary signs. Is there anybody? Wanting to be heard Is there anybody wanted to be heard Is there anybody? Wanting to be heard all them in Hammond. Thank you. Mr. Mayor make a motion to close the hearing It's been moved and seconded to close the hearing is there any further discussion Hearing none the clerk will call the roll 15 eyes motion carries Consent agenda Alderman Hammond Thank you again. Mr. Mayor I make a motion to accept and file all RO's and accept and adopt all RC's put all resolutions and ordinances upon their passage second it's been moved and seconded to accept and file RO's Accept and file all RC's and put upon passage all resolutions. There would be three one through three nine So any discussion? Hearing none clerk will call the roll 15 eyes motion carried communication for one will be referred to law and licensing Five One through five eight will be referred all reports of officers Six one a resolution by Alderman Hammond authorizing retaining outside legal counsel to represent the city in a matter Alderman Hammond Thank You. Mr. Mayor. I'd asked for suspension of the rules To move and seconded for suspension of rules is there any discussion on suspension? Hearing none will vote on suspension first 15 eyes Motion carried Alderman Hammond. Thank you. Mr. Mayor. I move that we pass the resolution It's been moving seconded to pass the resolution. Is there any discussion? Hearing none clerk will call the roll 15 eyes again motion carried Six to a resolution by Alderman Heidemann authorizing executing a contract between the city and Moss associates LLC Alderman Heidemann Thank You. Mayor first. I would need a motion to suspend the rules Second it's been moved seconded to spend the rules discussion under suspending the rules Hearing none will vote on suspending rules first 15 eyes to suspend Motion carried Alderman. I don't make a motion to put the resolution upon a passage second It's been moving seconded to put the resolution upon its passage. Is there any discussion on the resolution? Hearing none clerk will call the roll 15 eyes to pass Motion carried six three through six ten Will be referred Alderman Hammond Thank You mr. Mayor. I'd asked that six ten also be referred to finance as it is a budget related item Thank you in addition to strategic fiscal planning Alderman Hammond can we I Think Alderman Bourne is having a committee of the whole can we do it? Referell Alderman Decker Thank You mr. Mayor. Yeah, I'd also asked to have it referred to Committee of the whole so it will be number 10 will be referred to strategic committee of the whole and finance Thank You 71 Report a committee of law and licensing recommending denying beverage Ison's number 8945 Alderman Vanda Willie Thank You mr. Mayor I move that the RC be accepted and adopted second been moving seconded the RC be accepted and adopted under discussion Alderman van der Lee is Aaron Vrickie here this evening She is here. She appeared before committee on Last week a little history last year 2011 in February of 2011 She applied for her license She was granted even though she had failed to reveal one of her right her only violation So we sent her letter granting the license and told her to be sure to put that on her application She was called before us again Because since that underage alcohol consumption in 2009 Through 2011 she had or during 2011 she had two additional underage alcohols as well as an underage loitering So the committee voted for to want to deny the license Thank You, would you like to address the committee having the council? Last March I had underage and loitering excuse me. Could you speak a little louder there? Yes, thank you in March of last year. I had underage and a loitering I Had an underage because I was present at a place without call. I didn't blow anything That was in August. I forgot to put that on my when I reapplied Basically I'm here because it is my full-time job. It's my main source of money. I've never gotten trouble at my job I've never over served an underager never Nothing has ever gone around at my job. I've been a bartender for three years. I'd like to be approved and not denied All right. Thank you There any discussion from the council all of them in Vanda Willie. Thank you, Mr. Mayor One thing that we did find out during our meeting is that one of her violations for underage alcohol was She was in a bar in Sheboygan with Invalid ID and so our concern is how can she properly ID people and say no to somebody coming in with a Fake ID is there any questions of the applicant all of them in born Thank You mayor Ma'am would you lose your job if you don't have this license or are you still going to be able to work but not close the establishment? I will not be able to work My hours are full-time so they'd find someone else Thank You All of them in raised my question. No, no question same question All of them in Kath Thank You Mary Van Akron Again, is it a question for her? Otherwise pertains to her. Okay. Yes. I would February 15th of 2011 You filled out an application and it came before law and licensing and Jody van der Rohe was on that committee I was bill wagon one come in and Tom powers and the vote was three to one to grant the license I was the one that voted against it. I thought we should have called you in That was in February in March.   You've had four violations and That is why we voted, you know Not to renew the license That that's a big deal to have an underage To have a fake ID in a bar when you have a bartender's license. That is a big deal. Thank you I realized it's a big deal. I Learned my license since then the underage in August. I really I didn't drink anything. I was on a campsite No one was 21. I was the only one who didn't blow anything No one was 21 so no one took the Said it was their alcohol. So I got a fee for Being there I guess and I lost my license in March. I Accidentally, is it till May 4th to July 4th? I haven't Been in any trouble since then I've learned my license or my Any other questions for the applicant? Alderman van Ackeren. Thank You mr. Mayor all the violations that have been I guess noted Are all those are personal violations none of them have occurred at work. Those are all on your personal time Yes, okay, and I guess just for the committee members Was that the case as well in the committee? There was no actual violations at the place of employment where she was granted the license or were they all personal? Violations all personal, but she did go walk into a bar with a fake ID. Okay. Thank you Any other questions of the applicant? All right. Thank you. We'll return it back to the floor there Any discussion on the floor? See none clerk will call the roll Just to clarify an aye vote would be to accept and adopt and deny the license just so you're clear nine eyes six nose motion carries 7-2 Committee report from law license in nine beverage license number 95 97 alderman Fandah wheelie. Thank You mr. Mayor move the RC be accepted and adopted It's been moved and seconded that the order see be accepted and adopted any Under discussion is Amanda stater here this evening She's not here. We invited her to our committee twice and she did not show up either time So any further discussion on? the committee report Hearing none clerk will call the roll 15 eyes motion carries 173 report from committee law and licensing recommending denying beverage operator license 85 45 alderman van der wheeler Thank You mr. Mayor move the RC be accepted and adopted It's been moved and seconded that the RC be accepted and adopted Is Nathan gets here this evening? He is not here the committee did vote four to one to deny his license and we also had a police recommendation To deny it. Thank you. Is there any other discussion on the RC? Hearing none the committee will call the roll. I mean the clerk will call the roll 15 eyes motion carried 74 report from public protection and safety Recommending sending documents to the council to have them look into obtaining grant money for an abatement survey alderman van Akron Thank You mr. Mayor. I moved that the RC be accepted and adopted second It's been moving seconded that the RC be accepted and adopted. Is there any discussion hearing none clerk will call the roll 15 eyes motion carries 75 is a reported committee from finance recommending filing documents submitted to communication from meals and wheels Meals on wheels staying there have submitted an offer to purchase property behind Taylor dry property alderman born Thank You mayor van Akron. I would make a motion to send this back to finance Second It's been moving seconded to re-refer to finance under discussion alderman born under discussion mayor This is a wonderful organization has nothing to do with the organization, but I think Finance should take another look at the price that we're getting for this land. It might be Setting a dangerous precedent for future sales out on that shukr property. That's why I'd like it sent back to Finance for further consideration Thank you, is there any other discussion Motion is to refer to finance clerk. We'll call the roll 13 eyes to nose motion carries RC from public protection and safety recommending authorizing into Authorizing entering into a contract for provision for towing vehicles alderman van Akron. Thank you Thank you, mr. Mayor I would move that the RC be accepted and adopted in the substitute resolution be put upon its passage second It's been moving seconded that the RC put Be accepted and adopted in the resolution be put upon its passage Can I ask all the alderman to speak up into their? Microphones we're having trouble tonight with the air conditioning stuff people hearing so speak louder and speak to your microphones Please alderman born Under discussion. Thank you, ma'er. I was wondering if we could have the representative from the police department give us the department's opinion on the rotational The rotational system on the towing as Advocated by one of the people at the public forum tonight. I believe two of them talked about it Captain Cobb The police department is not an advocate of a rotational towing system We are an advocate for a towing contract of three years The reason I say this I know that the Sheriff's Department has a rotational towing system We have also in the past been on a rotational towing system We tow over 300 cars a year in one department The problems that arose in a rotational towing system that we experienced back prior to 1996 Would still be in place today, even though we have a computer-generated rotation the problems we experienced in the past were Questioning who gets to be within the towing list Once they're in with it in the towing list, how do you set the prices on what they're going to charge for a tow? How do you go back and audit who's on a tow? more importantly fighting inner fighting between tow truck drivers on Their perception of whose turn it is to be called for a tow These are all reasons that we got away from a rotational list into a contract system to begin with With a contract bid with a contract tow service. We have control over The price of tows under certain conditions What's going to happen with cars that are towed? We have a lot more involvement in ensuring that a car that is towed is available back to the Person who owns the car in the first place Because we have those arrangements spelled out ahead of time with with the company that we contract So that is that is really our you know our main purpose and our desire to stay with a towing contract Thank you before you leave That I would like to follow up if I could sure all the men born Captain Cobb Do you consider to be one of your criteria that time is of the essence to get a car picked up? And I I know the gentleman quoted some times for for a local tow operation and then of course you have to take into consideration during the winter when this when the Streets are really bad. So is time of time of the essence. Is that important to the department? Yes, tight times important. We have we have limits within the time bit or we have time limits within the bit itself In the last 16 years. I don't ever remember Can't we've never canceled a contract or try to get out of a contract because of tardiness and showing up at a scene We have questioned and asked for an explanation from time to time Because of an extended amount of time Certainly we understand under certain conditions There is going to be occasions where the 20 minutes has exceeded We don't want that to be our operating principle. So I have one more if I could mayor One more. Thank you. And that is the other point that the gentleman brought up Has it been verified by the committee or the department whether the company in Sheboygan Falls does indeed have A secure area to store the cars is not been verified by the department they have They've accepted the bid and it would be terms of the contract if they violate the terms of the contract We'd be out of the contract Thank you. Thank you. I have two lights on Alderman Hammond and Alderman Donahue. Do you have questions of the captain or Okay, thank you captain Then Alderman Donahue Thank you mayor as an initial matter. I am loathe to Interfer with the committee recommendation That's why we have committees and that that's why their work is so important But with the exception that proves the rule I will speak Regarding concerns that I have based on the information that I have received that the second bid which was from depot towing Was approximately $4 per call less than the winning bid Thankfully thankfully municipalities do structure bids to indicate that price is not the only criterion that we look at We look at quality of service. We look at It's sort of the bang that you get for the buck for the reasons that were outlined actually by both speakers it would indicate to me that That there are significant concerns about just going with the lowest bid here Secondly and the reason that I would need to vote against this is that if in fact the amount of money is relatively small I Can't see taking that business out of the city of Sheboygan I think that we need to to the extent that we can within prudent financial parameters, of course Support local businesses as best we can If I do have any of that information wrong as it was presented to me, I do apologize But I based on the information that I did receive. I'll be voting against this resolution Thank You all the men down here all of them in Hammond Thank You mr. Mayor and Alder and Donna here did a wonderful job of stealing my thunder. I certainly appreciate that But I also have a little bit of a concern the time factor not withstanding and All else being relatively equal I would much prefer to keep it inside of the city of Sheboygan with taxpayers that are paying Taxes inside the city of Sheboygan. I understand we don't have a bi-local ordinance But on the flip side, you know, these guys are paying taxes inside the city of Sheboygan my understanding there hasn't been a service issue and All else being equal again Why wouldn't we keep it here? So I also? Will not be supporting this and would strongly encourage taking a look at other alternatives for this I know the police department may not be a big fan of the rotational system But I think at some point maybe Further review of that might be warranted with the police department's involvement to figure out There's a way to make this work. Thank you Thank you all them and him and all them the racelor Thank You. Mr. Mayor. I'll just as a point I have a personal and professional working relationship with many people involved in this so I'll be upstanding Thank you. All of me cuff. Thank you, Mary Van Akron I was actually at one of the public protection and safety meetings and there was a number that was thrown out One of the bidders mentioned it was a three million dollar contract that three year. Is that does that have? Teeth to it. Is this a three million if this was a three-year contract would this be a million dollar contract? Thank You mayor when I had the meetings with the police department and Everyone else involved The police department may we can bring them up said that it was not a million dollar contract It was more like a hundred thousand dollar contract over the three years I suggested we made it a one-year contract It'll come do at the same time a county does giving us a year's time to be able to find out the best Solution for our city whether we go on rotation or another method and so I did not make a motion to do three-year contract I made a motion to do a one-year contract then took the recommendation of our police department and our finance our Person and took their recommendation and suggested that arrow had gotten it, but it is not a three million dollar contract Or is it a one million dollar contract? It's possibly a one hundred thousand dollar contract over three years From my understanding, I guess the police department could clear that up much better than I could Alderman Lissard or or the chairman We're talking a one-year contract with this and then in April of 2000 And we'd be looking at the next contracts again, or we talk in a year from today's date Aluminum an Akron Thank You mr. Mayor, and maybe Steve would be able to enlighten us more on the legal aspect of that But I believe if I if the contract would do to end in May it would probably be until next May Again as Alderman Lissard pointed out she did amend the document from a three-year contract to a one-year contract But but I guess I would ask Steve his opinion on that if the current contract Technically ended in May if we renew a contract would that be from May or from I guess then the renewal point today? You're asking me I have I've not participated in the public protection safety or had any involvement in the in The bid specs or anything like that, but I would say it's a one-year from when you enter in the contract That's what I would assume would be the The proposal it wouldn't make any sense to go back to May I mean they're they can't provide service back in May they'll start whenever Contract is entered into and I think as it's worded would be one year from the time the contract was executed If it was your intention to go to May, I think you could make an amendment to do that But you know it's up to your whatever your attention of your committee is any other discussion See none What's that? I'm sorry. I didn't see your light all the minister Thank You mayor the other concern I had was in in doing this Investigation was to keep our business locally in the city, and I had some concerns that arrow was outside the city And I did have some conversations with city attorney, and I've forgotten his name I'm so sorry we cannot Deny a bid if they're not in the city there. There's we can't do that. So that's why Half of the people that work for arrow do live in the city But the business is located outside the city, and he's in said he's in the process of buying a business a Carrex on Taylor Drive To hopefully be within the city. So that's why we didn't discriminate against what city the business was located in Thank you any other discussion Alderman van Ackeren. Thank You mr. Mayor. I guess just my Point louder, please. Thank You mr. Mayor my points to this is is again I put a lot of weight on the recommendations of the police chief as well as the purchasing agent Bernie Romer The company that would be awarded the one-year contract did meet the bid Specifications and was the lowest bid that was brought in he did receive the recommendation from both our purchasing agent as well As the police chief so they have high confidence that he'll be able to provide the service We're asking him to do Again, I do share their concerns of the the city business compared to just being outside of the city However, that's not part of our bid process, and I think if we are going to start Mixing that into our bid process that the only you know companies that can bid for a service like this Our companies that reside within the city. I think we'd we'd be taking ourselves down a dangerous road legally So I think we based our decision off the best information we had as well as the recommendations from the police department and the purchasing agent So I do support the the one-year Granting of this contract and we certainly over the next year can look at other provisions as to how this may or may not be able to Be adjusted Thank you any other discussion hearing none clerk will call the roll Six eyes eight nose one abstention Motion fails 7-7 report a committee from public protection and safety recommending repealing and recreating municipal Code for their peeling the two thousand foot requirement for sex offenders Alderman Van Akron. Thank you, mr. Mayor I would move that the RC be accepted and adopted in the ordinance be put upon its passage second So move and seconded that the RC be accepted adopted in a resolution be put upon its passage under discussion Alderman Amen Thank You mr. Mayor I was just hoping for the folks at home that maybe Alderman Van Akron you could explain what the document means and What this entails because there's a change to our sex offender registry just don't want to scare people at home Alderman Van Akron. Sure the the change really entails that if a Person applies for a sex offender resident street residency waiver If they apply for that and they are denied that they cannot apply for an identical waiver within 90 days It it puts a 90-day time space that you can come back and apply for an identical waiver Again, we've ran into some instances where we've had individuals who have come to three four meetings in a row Fill out the paperwork and again the circumstances of what they're asking for nothing has changed They just continually come back Again, this puts a 90-day waiting period that if your circumstances do not change if you're not looking at a different address If any of the concerns by the committee members That were addressed at the committee if none of those things are changed and it's an identical request as before You have to wait 90 days to come back to the committee or come in front of the committee So that's the only change that's happening Thank you. Thank you any other question any other questions from the council Hearing none clerk will call the roll 15 eyes motion carried 7 8 through 7 11 will be referred to finance and the committee of the whole 7 10 through 7 14 will we be referred to finance and The committee of the whole under discussion all the men born Thank You mayor do I understand you correctly then that not only 7 8 which is indicated It's going to the committee of the whole but 7 9 10 and 11 also Yes Okay Very good and and then 12 13 and 14 will be sent to finance strategic and the committee of the whole As stated, I'm sorry all the mccarles. Thank you mayor. I'm just gonna I think someone's got to make the motion because according to the agenda. It's just going to finance 7 9 10 and 11 So moved I don't think that's I think the chair has the option to refer to the committees I Don't think you'd need to vote on that but if somebody is opposed to that I guess Any other discussion We'll move on Ordinance is 8 1 will be referred matterly over general ordinance 8 12 13 from Alderman a raceler Cough vandal William Donahue amending the municipal code to reclassify various positions in the Department of Public Works Alderman Raceler, thank you. Mr. Mayor move that the ordinance be put upon its passage second It's been moved and seconded that the ordinance be put upon its patches any discussion hearing none the 15 eyes Motion carries Matters laid over I'm sorry notice of discharge Alderman Carlson Thank You mayor. I move that the public safety and protection committee be discharged from further consideration of RL 63 dash 12 dash 13 And RL 64 dash 12 dash 13 and referred to finance Zero second second It's been moved that seconded that the documents from public protection safety regarding the Budget issues be sent to finance Would there be a friendly amendment to send it to committee of the whole and strategic since all the other ones have been sent there too? Thank you so the the Motion then is to have those documents sent to the committee of the whole strategic and finance Thank you under discussion Alderman born Any other discussion Alderman van Ackeren Thank You mr. Mayor. I guess I would encourage and ask the council to Deny this request the little louder, please the reason for The delay at this point is that there is an upcoming strategic fiscal planning meeting Hopefully within the next week and a half or so hopefully that we can get that done before the next public protection and safety meeting the reason that the Public protection and safety committee has not reviewed those two documents yet is that part of the discussion in the strategic fiscal planning Meeting is going to be setting the objectives and goals of the budget process And it didn't make sense to me to review our budget documents until we have the goals and objectives of the budget process in front Of us so the the reason that those two documents have not been acted upon as I've held them until we can actually have that strategic fiscal meeting set what the goals and objectives of the the budget process is going to be before we actually review the the committee's Budget requests that are in front of us So I would ask for the patience of the council in a two-week extension to hold that meeting and then be able to review Though budget requests line by line with the committee rather than circumventing the committee's Ability to review that. Thank you Lemon Carlson, thank you mayor Ppns had has had the two meetings since the budget was referred to the committee level We did in fact go through the fire department's portion of the budget and building inspection The only department we were waiting for is the police chief The police chief and and or a representative was not at the the first meeting that we discussed the budget the second meeting The police chief was present. It wasn't on the agenda if everybody remembers a few weeks ago we did approve a budget schedule and That's part of the reason why I'm pulling this out because we Strategic fiscal planning committee the whole and finance are meeting on this and it's going to be Based on the preliminary budget any changes can be made in those three committees And everyone's going to have a kick at the cat at that point But once again, we did approve the budget process of the schedule every other committee Within the council did submit a budget except for Ppns And I couldn't find a really good reason why to prolong this process even more. Thank you Any other discussion Alderman Riesler? Thank you, Mr. Mayor. I guess is a compromise I don't see the strategic fiscal committee meeting before the Public safety is going to meet career for it to them as well And it goes to all four and then everybody's happy that emotion Friendly amendment to the motion. Yes. It's been moved and seconded to amend the amendment To send it to all the protection savey strategic finance Committee of the whole anybody else want it or Under discussion on the amendment only all the manhammon. Thank you, Mr. Mayor Just a point of clarification. Are you going to be having a ppns meeting next Wednesday? I know you indicated you're going to be out of town. Will there be a meeting? A week from this upcoming Wednesday All the manhammon. Can we ask when when was the strategic planning as soon as this ppns budget is approved by ppns? So later that evening It's got to be referred to if we If it's got to be referred to the All the money money Okay, so I just have a sense that there's somebody behind the door with an axe Can't just somebody tell me what's going on? This is a little nutty So just someone really tell me what's happening. I'm interested in this Surely somewhere there is an answer Lurking and I would be interested Alderman Donahue. Thank you Alderman vernacoring. Thank you As I stated I held it off the agenda on purpose for the fact that it was my understanding We'd be having a strategic fiscal planning meeting before my next meeting in which we would discuss the goals and objectives Of the budget process and I thought it was important to have that laid out before reviewing our budget as to whether or not We should be looking for cuts. Should we be looking for a zero-based budget? Are we looking at two to three percent increases? You know what really is the goal and objective of the overall budget process and then how is our committee supposed to be? Reflective of that so that really was the goal of that I understand that it won't meet the budget schedule That certainly was set up and like I said that that solely is My responsibility but but again I did hold that off because it was my understanding We'd be having this meeting here shortly and was my hope to have those budget goals and objectives in place before reviewing it at our Committee level Alderman Carlson is it on the amendment or on the document itself? I was actually going to try to attempt to answer her question. Oh, are you gonna continue to attempt to? I Could yes Alderman Carlson quite frankly. It's all it Hope the holding of this document really comes down to the garbage fee And that document going to strategic fiscal planning. So that's really what the hold-up is There's really no other reason to hold it because we've had plenty of time to review it How many months ago we directed the department heads and the city administrator or the to come up with the budget? They had a goal. That's a budget. They presented later on down the line There was a new plan put in the place to repeal the garbage fee and that's really what this is about All right, the motion is to hold them in Donahue And pertinent to the amendment to the amendment I guess the question that I would have then with the plethora of committees that are going to attend to the budget And I would certainly defer to President Hammond on this But what is the most sensible? way That we proceed because that will influence my vote if it's a question of strategic financial planning not meeting until after ppns Then that's an issue I Would expect expect that the strategic committee meeting would be before committee of the whole to me that would be more of a Planning and and seeking kind of discussion. So Tell me what is the best thing tell us all what the best way is to handle this for the council and for all the folks We represent and that's how I'll vote Thank You. Mr. Mayor The goal of the budget timeline was to have all the budgets Reviewed by the respective committees go to strategic physical planning either this week If most of the committee could be there or next week with also finance looking at it on what next Monday? committee of the whole looking at on the 31st yes, and coming back to the council the following first council meeting of August so that was the laid-out timeline and all of the discussion up until Just recently so that would be the way I would Propose seeing it would be to go to strategic fiscal Finance next week and then committee the whole the following week with recommendations going back to the council the first week of August Okay, the motion is to send it to strategic finance strategic fiscal planning finance committee the whole and public protection and safety Hearing no more calm clerk will call the roll I gotta proceed. I gotta proceed. I'm sorry I didn't see that when I started. Thank you I have a procedural question for either the clerk or the city attorney Do we have is that friendly motion is that friendly amendment? Is that accepted and we don't have to vote on that separately because I'd really like to vote on the I'd really like to vote on the Friendly amendment to send it back to finance I'm sorry. Was it was it to go back to finance or public public back? It was to go back to ppns that was a friendly amendment to include ppns in there Yes, so I go to all four okay Can we can we vote on that friendly amendment or do we have to vote on this whole package of where it's going to go? Well the front friendly amendment generally Goes back to the person who made the original motion and I didn't accept it and If the person making the motion agrees to the friendly amendment to amend his original motion or her original motion then It's accepted. Otherwise if if the person making the original motion Doesn't accept it as a friendly amendment then you would need to vote on that You didn't accept it Alderman Carl. No, okay Okay, so now the amendment is or Motion is to send it to finance strategic Fiscal planning and to Committee the whole And we have a question All the men raised wouldn't we vote on the friendly amendment then if it wasn't accepted I need a motion if there's a motion. I thought you would need to make a motion So okay, I will do that. I'll make a motion to vote on the friendly amendment to include Ppns in that it's been moved and seconded to amend to go to to Public protection and safety to be added to the other three Like we'll call the mold the role on the amendment only give me a minute You want to add ppns to the list is that the amendment? Okay, this is to Prove an amendment to add ppns to the current list That's in the motion previous eight eyes seven nose motion carried Back to the original Clerk will call the roll hang on all four committees now. I Gotta go find it now Love this modern technology. Hey, give me a break here Could just take a Take a manual roll call I Still have to get back in to do the rest of it Actually, I don't never mind All right, the motion was to pass no, okay, I got a backup here many recommendations with sending it Or the amendment was to set to send it to four committees Let's back up from there. We first have we have two motions first We have to have a motion to discharge ppns. Yes or no Then you have a motion to refer and we wouldn't even yeah, then we have a motion to refer to the four committees I need two motions. The first motion is to pull it from ppns. I thought we did it all in fee did not Click will call the roll Bellinger I Born I Carlson. Hi, Decker. Oh Donahue Hammond, hi, I didn't win. All right, class. I was hard. Hi Lewandusky Made a check. Hey, I'm sorry. No, no Raceler Ben Akron. No Vanderweel. Hi And Wongamon Ten eyes five nose. Okay, now it's we need a motion to Refer refer it to the four committees, right? That's there And we can do an all eyes if you want that's fine. I'll adjust it. All those in favor signify by saying aye Hi No, no, we need a motion Okay, we need a motion first to refer refer all of them Carlson make a motion to refer it to Ppns committee the whole strategy physical planning and finance second So move is seconded to refer to the four committees. All those in favor signify by saying aye. Hi chair votes. I'm sorry Opposed hi Motion carries lipstick roll there was We're taking a roll. There was not a unanimous. I Don't think that's true, but okay. I didn't think I can't roll while we took go ahead. No Carlson. No Decker. Hi down to you. Hi Hammond. Hi, I didn't win. Oh Cough. No Lassard. Hi Lewandusky Maddachuk. Hi Raceler. Hi Ben Akron. Hi Vanderwheel. No And one good man Ten eyes five nose motion carries Other matters city attorney 11.2 as an RO by the fire chief section 50-494 of the municipal code Submitting his quarterly report for the period commencing April 1 2012 and ending June 30 2012 That will be Sent to public protection and safety 11.3 is a resolution by Alderperson Hammond Committing fund balances in accordance with gas be 54 That will be referred to I an answer You want that also to go to strategic in committee the whole census talking about your fund balances everything else is Just where everything else is. I don't care. Okay, this will go to finance strategic and committee of the whole 11.4 is communication from Alderperson Hammond requesting that resolution number 234 0304 Establishing a policy for applying undesignated fund balance for the general funds ensuing your budget. I Assume the repeal that's not in there But and to draft the resolution to establish a fund balance policy in accordance with gas be 54 This will be sent to finance committee of the whole and strategic Anything else? Motion to adjourn motion to adjourn second it's been moved and seconded Her to call the roll Hang on hang on hang on you found one one is an RO by the city clerk submitting various license applications for the period And in June 30 2013 and June 30 2014 That will just be sent to lawn licensing now a motion to adjourn motion to adjourn Move seconded to adjourn Put all all in favor signify by saying aye. Hi. Hi Close motion carried


Statistics and Excel. Coin flip statistics example in Excel. Get ready, taking a deep breath, holding it in for 10 seconds, looking forward to a smooth, soothing Excel. First, a word from our sponsor. Yeah, actually, we're sponsoring ourselves on this one because apparently the merchandisers, they don't want to be seen with us.  Like this CPA thinking cap, for example. CPA thinking, CAP, you see what we did with the letters? And this CPA thinking cap is not just for CPAs either. Anyone can and should have at least one possibly multiple CPA thinking caps. Why? Because based on our scientific survey of five people, all of whom directly profit from the sale of these CPA thinking caps, wearing this CPA thinking cap without a doubt, according to the survey, increases accounting productivity tenfold. Yeah, at least. Apparently the hat actually channels like accounting energy from the quantum field ether directly into your head, allowing you to navigate spreadsheets faster. It's kind of like how in like the matrix when Neo learns kung fu, or at least that's what the scientific survey saying. So get one, because the scientific survey participants could really use some extra cash. If you would like a commercial free experience, consider subscribing to our website at accountinginstruction.com or accountinginstruction.thinkific.com. Here we are in Excel. If you don't have access to this workbook, that's okay because we'll basically build this from a blank worksheet so you can just open a blank worksheet. But if you do have access to this workbook, three tabs down below example, practice a blank. Example in essence, answer key, practice tab having pre-formatted sales so you can focus in on the heart of the practice problem. Blank tab being a blank so we can practice formatting the sales in Excel as we work through the practice problem. Let's go to the first tab to get an idea of where we will be going. The scenario being where imagining we have a coin, we want to test whether or not the coin is fair. In other words, if it was a fair coin, we would expect it to have an even chance to be landing on heads or tails. If we were to flip the coin, if it's unfair then we're going to think that the chances are more likely that it lands on either heads or tails. How do we test whether or not the coin is fair? Well, typically we'll run some samples of it, we'll run some trials and we'll take a look at the results of the trials. Now, as we do this, we want to get an idea of the statistics involved and the testing involved and also the tools that we can use in Excel to formulate these tests so that we can practice with those tools in Excel as well. So let's go to the first tab over here and I'm going to format the entire worksheet and I'm going to do that by selecting the triangle up top or you can say control A, right click and format the worksheet as we do every time in Excel. Basically we're going to go to the currency tab and bracketed negative numbers, bracketed and red no dollar sign. I don't think I need the decimals because of the type of problem that we are working in. So I will remove the decimals, then I'm going to zoom in a bit holding control and scrolling in. So I'm currently at 220, I'm at 235 now. And so now what we want to do instead of actually flipping the coin multiple times is say how can I simulate that process in Excel. Now if we had an even flip of 50-50 then we want a random outcome between two variables. So I can use my random function in order to do that. So let's first think about that. Let's think about how we can get a random function between one and two. Now remember when you're flipping a coin, in theory you can say well if the coin was fair and I was to flip it for the entire population being infinity, infinity times, then you would think I'd get an even break between 50-50 heads and tails. So when we actually do a sample, when we test it, you can think of that as a similar thing as taking a sample from the entire population. In this case the entire population being infinity flips, a theoretical concept. And we're testing it with a finite number of flips and then seeing how close we get to what we would think would be the appropriate response given the whole population would be 50-50 and infinite flips. That's one way you can kind of think of it with our sampling concepts. So we need something that's going to come out if it was a fair coin between even random between one and two. So if we say I'm going to have my random results between one and two, I can say this equals a random function between and then I'm just going to say the bottom number is one and the top number is two. So one comma two, there's our random function. This will give us random numbers between one and two. Now it doesn't give us a decimal, so if I was to say maybe you might think that it's going to give us like point something, right? No, it's going to give us the whole number of one or two. So that basically stimulates an even coin if I was to flip an even coin. So if I then copy that down, we can then get, and by the way I'm working here in row six. So I'm going to actually delete some of the rows above it because I thought I was in row one to start with. I'm going to put my cursor on the one, drag down to row five, right click on the selected area and delete that stuff. And then I'll also make this bold, both a full sheet font group and make it bold. So then if I'm on number one, I'm starting at number two.  And so now we've got random amounts of one and two. Notice that every time I click on them, they randomly shuffle again. Let's go ahead and put some a table in here. So I'm going to say format, I'm sorry, insert table. There's our table. And so if we want to make this a little bit more formal, let's assign what one and two means now. So I could then say, let's make B a little bit smaller. I don't want to put anything right next to the table. I need that space. We've got to keep the table separate. The table needs to be separate than the other stuff. And so I'm going to say the heads or a one represents heads, right? So one represents heads and tails is going to be the two. The two is tails. So let's go ahead. So we've assigned our terms and go to the home tab font group. I'm going to make this blue and bordered. I go to the more colors down here. Typically if I don't have the blue yet and pick up that blue. That's the one I want. And then font group and put some borders around it. All right. So then what I'd like to do instead of having this shuffling around all the time, I can then copy my results. I'm going to copy this whole tab and then paste it special without the formulas. Paste it with just the numbers one, two, three. I copy, put my cursor on a column, right click the cells, copy them. And I'm going to put them over here somewhere in like F. I'm going to paste them one, two, three because I don't want the formulas there anymore. I just want the results of that shuffled those shuffled numbers. So I'm going to put one, two, three. So there we have it. Let's make another, hold on a second. It didn't paste one, two, three. I'm going to paste it one, two, three. Okay. And then I'm going to make a skinny E column, skinny E. And then if I was to look at my results here, I would, I could then do a fancy little formula if I wanted to, to basically say whether it's heads or tails. So here's the outcome. I know that one is heads and two is tails, but I could try to say how can I convert my random ones and twos to heads and tails. We'll practice logic functions in Excel, basically asking Excel to give us a result of heads if this number happens to be a one. If this number is not a one, then we'll say give us tails. That's really all we need to do because there's only two variables, heads or tails. So we're going to say if it's a heads, give us heads. If it's not heads, give us tails. So I'm going to put my cursor over here. We're going to say equals if there's our logic function. We can double click on the if or add the brackets, shift nine. Here's our logic box. So here's our arguments down here. We're on the logic test being the first argument where we're going to say that we want, if this number is equal to the number one in our box over here, then when I say then I put a comma. If that test is true, what do you want us to do? That's the next value if it's true. We want you to put a heads next to it if it's true. And then comma, if it's false, what if it's not true? What do you want us to do? We want you to put a tails. So once again, first test if this number equals one. Next part, we want you to then put a heads in it. Next part, if it's not equal to one, put a tails in it. And if I hit enter, it puts a tails. Now I'd like to copy that down. I'm going to double click on it. I can't copy it down as if because these cells will shift down. I want this cell to shift down. I don't want these cells to shift down. So anything that's outside of the current range I'm working in, I need to tell Excel don't shift it down. So for example, this one's in D1. So I'll put my cursor in D1. Now the way you do this is one way is you could just select F4 on the keyboard. It puts a dollar sign before the D and a dollar sign before the one. Those are the two variables locating our cell on the two-dimensional screen. We've got D1. So it's saying that dollar signs have nothing to do with dollars. It's just telling Excel, when I pull this down, don't change the D or the one. Keep the cell exactly the way it is. That's called an absolute reference. And you only need a mixed reference, by the way, but an absolute will work here. So I'm going to use that. And then over here, we've got the tails. So that's on C1. So same thing here. I'm going to put my cursor in there. F4, dollar sign before the C and the one. And C2. Also, we don't want it to move F4. So now these are all absolute cell references except for this one, F2, because I do want that one to move down. So let's hit Enter. I'll show you what I mean. I put my cursor on this. Put my cursor on the fill handle. Let's drag it down to the number one where it should show us the heads. If I double-click on it, there's the references. Didn't change that cell. Didn't change that cell. Didn't change that cell. Did change this cell because now we moved that down to four, whereas here it was at a number two. Then if I just put my cursor on this one and double-click it, it'll go all the way down. So there we've got it all the way down, and we could say these are our results for our first test. I could make it into a table if I want now. Go into the Insert tab, Tables, and Insert a Table, and say I want to add the table. And then we could look at our results, and we could look at them this way. You know, I could show the results from Z to A and put all my heads and all my tails, which might give me an idea. I can count where the middle point is. And then, of course, what we would want to do is get the percentage that's going to be heads versus the percentage that's going to be tails. So let's make a skinny H over here. And so this is basically our sample that we took now. We took a sample of the population, which, in theory, is infinite number of flips, which we know, in theory, if you did an infinite number of flips would come out 50-50, but we just did a sample of 100. So now we can count the heads and count the tails. So let's say we've got heads, tails, and we'll do a count function here. So I could do it this way. We were going to say equals count if. Count if brackets. We only need one condition. So I'm going to say count if. I'm going to pick up the range. Now I could do either range doing this with numbers or doing this with the non-numerical value. So let's just do the heads here. So I'm going to say count them. If that range, comma, has a criteria, what's the criteria that it's just simply going to be heads? So count them if they are heads. And then enter, so there's 52. Now I know if there's 52 out of 100, I could say 100 minus 52, or it would be better for me to give me a double check to do the same thing here. Equals count if brackets the range. So there's the range, comma, the criteria if it's a tails. And then closing that up and enter. And then I'll pick up the total. And the total equals the sum of these two. So there we have it. And I only have 99. So notice I don't exactly have 100. Apparently I didn't count it out properly because I stopped at 100. I missed that first cell. So there's only out of 99. Now actually I think that's actually good because notice if it was out of 100, we could see here that that would be representing 52% versus 49%. But the fact that we always use round numbers in these practice problems can kind of lead to confusion because what we're really doing is saying, I'm taking the 52 heads out of the total number of flips, which there was only 99 in this case. So that means to get a percent, let's put an underline here, font group and underline. I can get a percent by taking equals the heads divided by the total, which is not 100, but only 99. So it's not 52%. We've got a number one. I need to make that to a percent. Home tab numbers, I'm going to make it a percent. Add a couple of decimals just to make it a little bit more exact. So it's 52, 53, right? And this is going to be equal to 49 divided by 100. And then this one is simply going to be equal to this divided by itself or 100%. Or in other words, I could sum up these, which will be 100. And then let's format this one. I'm going to use the format painter this time to format these two the exact same formatting. Home tab, clipboard, format painter, and then paint brushy these two. And so it's the same formatting. I'll underline it here. Home tab, font and underline. So we can see that it didn't come out exactly, even though I did a pretty fair amount of flips, 100 or 99 flips, but it's still 52 heads and tails, 47. So if I was to judge this, I can't really say what's unfair on heads side based on this result, because statistically speaking, it's quite possible that I flip it 100 times and that's pretty close to 50, 50, right? So I'm still going to assume the null assumption that the coin is innocent. It's not fair. I mean, it is fair unless I get a preponderance of evidence that's going to prove to me otherwise. And so that's kind of the general idea. Let's go to the home tab, font group, put some brackets and make this one blue. Okay, I'm going to try to make all these skinnies the same skinny size. Put my cursor on B. I'm holding down control E, holding control H, and then I'm going to make them the same skinny size so they're kind of uniform. And then, so now let's copy this number H. I'm going to go to the home tab, clipboard and format paint the skinny and then skinny rise the L over here. So now let's just do another test just to play with our numbers here. And let's say that we did like 15 of the 1 to 15 flips. And let's say that we did a sample of just one, one flip up to 15 flips and see what the differences are, or two flips up to 15 flips. So let's say we say the number of flips is going to be one and then two and let's bring it up to 15. I'm going to put my cursor on this one and bring it up to 15. And so then I'll center this one and then let's just add our tests. So this is going to be test, test one and then I'll put test two and so on up top and then I'm just going to use my random, my random between one and two again. So random or equals random between, double click the between one comma two. So one's head and two is tails is what we're standing, what it stands for again. So I'm just going to hit enter and so I get, I'm going to put my cursor on that one and fill handle it down. So on the first test I'm going to say we flip it and test two times and then I'm going to put my cursor here and copy it to the right and then I'm going to copy this one down. So I'm going to imagine we flipped it three times this time and then I'm going to notice all of those came out to one on this one random test. So with three flips that's quite, you know, that's quite possible. If I copy it over again and then I pull these down I imagine we flip it four times and then I'm going to copy these to the right and then pull, oh hold on a sec and then pull these down we're going to flip it five times copy these to the right and flip it six times copy these to the right imagine that we flip it seven times copy these to the right I'm going to pull this over a bit imagine that we flip it eight times copy these to the right and then imagine that we flip it nine times and then copy these to the right and imagine that we flip it ten times I'll do it this way so I can copy it to the right easy ten times copy to the right and then we're going to imagine that we flip it eleven times copy to the right imagine that we flip it twelve times copy to the right imagine we flip it thirteen times copy to the right two more times and say that we're going to flip it fourteen times and then copy to the right one more time and then we have to stop these good times of copying to the right and say that we flip it fifteen times so there's our random generation tests going from one I'm going to put my cursor on these two and drag it to the right and it should be able to pick up the test numbers going from test one to fourteen I'm going to select all of these make that into a border by going to the home tab, font group and I'll make it black and white which is typically what I do with the borders and let's center it and then I'm going to go back to the left and I'm going to select all of my information here and put my blue and borders around it now this is just my test range so what I'd like to do is just copy this whole thing and then I'm just going to paste it one, two, three so that this thing will reshuffle anytime I want to kind of reshuffle it I can go in here and reshuffle everything and then it'll and then I can come and copy it again so let's go ahead and copy this thing and copy the whole thing and then go to the left and I'm going to paste it one, two, three just the values now I don't want the formulas but I also want the formatting so I could right click and paste the formatting so I pasted the values in the formatting but not the formulas so I get this mimicking of the table which now gives us our results and I can go down here and say well let's take a look at the heads so I'm going to use my count if function again so I'm going to say equals count if brackets and then I'm going to take the range here down to here and then comma and I'm going to say count if it's there's the range and the criteria if it's a one so count it if it's a one and then brackets enter there are zero this time that is a one notice with these first two tests we've got two tests they came out completely tails which could happen because we only flipped it a few times and then if I copy this to the right now I've got one and two so I'm going to copy this all the way to the right and so there we have it and then we're going to say tails so I could do the same thing count if brackets I'm picking up the entire range because I want to be able to copy it across I'm not just going to pick up those two because I want to copy it across count if comma it's a number two and then close it up and so there it is and here's the total then which is the sum of these two which means we only ran two tests this time so I can underline this and then I can say these are my percent heads versus the percent tails so the percent heads would be equal to zero over two zero and the percent tails would be two over two hold on a sec equals two over two and then the percent percent total which is going to be equal to the sum of these two percents so I'm going to make all of these percents home tab numbers percentifying them so there's our percents and I could put an underline here so there we have it in our first flip we had zero heads two tails and so total tails zero percent heads and a hundred percent tails so let's copy that across putting my cursor on the and copying across and you can see of course the idea would be that if we have more flips then you would think we would get closer to a better result so I'm going to go to the home tab font group and make this blue this time for my totals blue and white let's put some borders around it too for the fun of it put some borders around it so the idea here being that with two flips is probably not going to be enough with an infinite number of flips of the population and so we could come up with some skewed results of you know here's two that all three hit tails here which is kind of unusual and then here we've got the tails are just doing quite well we've got 25 percent tails 75 head because one out of four versus three out of four, five flips so now we have two tails three so that one looks at least a little bit more accurate notice this one we flipped all heads came up this time which is kind of unusual even though we flipped it six times so that's kind of weird and then you got four and three this one actually came out exactly 50-50 so the fact that if you get more flips you would get closer on average however it's not always going to be closer than like this one we flipped it less amount of times 14 versus 15 and the 14 came out to what we would think is actual population 15 is off so then if you use a random generating tool like this you can then go in here and basically reshuffle everything right I can go in here let's do a reshuffle reshuffle make sure that we get every column on the reshuffle it might be better to put a table in here to make sure everything is shuffling let's actually do that let's insert a table make it into a table and then when I reshuffle each column everything should shuffle up and then hopefully that all shuffled up and then we could take all of our numbers that were randomly generated hopefully copy them and paste them into our table over here but paste them formats only one two three and so now we've got a different set of numbers now we're on two that came up heads and then now we've got two and three so there's just a nice tool to be able to kind of simulate our results with the randomness I'm going to make this a little bit thinner and we'll stop it here and continue on with some more testing next time