Hello everyone and welcome back to another video. So in today's video, we're still on the theme of power query But we're going to address the issue where we have a number of files that we wish to combine To create one data set that we're able to use in our Excel file and then be able to obviously visualize from there on The great benefit of this if you're watching this video and you're either requiring this in Excel or maybe something like Power BI This this exact solution is transferable across both So first thing you can see on the screen at the moment is we've got our file explorer open And we can see that within this folder of snapshots. We have three files So in this scenario, maybe the end of every month this snapshot is taken and it's obviously capturing data For us, we'll see the data as soon as we pull it into power query But it's a real simple 10 row 10 or 12 rows per file Containing the date at which it was the snapshot was captured and also a value per each individual So we'll treat this as maybe sales data. So we'll without further ado, we'll just jump straight into it so any of you familiar with power bi may be aware of a Not to say a quick aware doing this But I guess it is quicker but maybe an out-of-the-box way of doing this in which you can go to get data Go to From file and then go down to maybe from folder I am not going to go for that solution just because when power bi does this for you It creates a number of unnecessary steps So we're going to be using obviously a lot of manual Well, not a lot of but we're going to do a couple of manual formulas But you'll just see how straightforward and simple it is to achieve So if you've done this process before I'm showing on the screen Yeah, you have a something to compare to if you haven't done that process before By all means have a play around with it But I think the solution that I'm going to show makes it a lot more streamlined and simple to follow as well So what we're going to do is we're going to select to go data and we're going to go straight to launch power query editor And once power queries load itself obviously at the moment We've got no data in here So it looks quite bland what I'm going to do is right click in the queries paying over the side here Go to new query and then I'm going to go down to other sources and go blank query So in here, we are now going to find or locate our file location or folder location So I say more specifically so very easy one to remember all you do is go equal folder and Then you can see the next one is folder dot files and I'm going to open my brackets and just for Laziness I've got the link I required just the side over here on another screen You can see at the moment It's obviously given an error because nothing has been provided But if I just now paste that in there and obviously of course you can then change this This file path as as required Once I've entered that I'm going to hit enter and you can see we're now seeing our file and Here we can see you've got that file again that folder open again So we can see our three files in here and you can see they map exactly or not mapping see them exactly same in here So this also gives you some added flexibility should you need to incorporate such information into your reports We'll leave this for now, but obviously that's another one that you can play around with So the next thing we need to do is how can we combine these three files? In this scenario into one data set and it's important to mention here as well that the solution We're now going to enter when more files are added to this folder So maybe at the end of this month or next month there will now be four files rather than three This solution will include that additional file to make sure that our data set will continue to grow as time goes on So what we need to do over here is I go to our applied steps I'm going to right-click and go in set step after and you can see at the moment the step is just defaulted So we've got our source at the moment Obviously what's going to go get the the files in that folder and then custom is currently just referring to exactly the same step What I'm going to do though is if you just remove source for the time being I'm going to enter the formula binary Dot combine. Oh and it's gone for me. So just go type in the binary dot combine and Sometimes power query will do this. You can see it's doubly entered the binary So I'm just going to make sure that I delete that one off before it gets confused later on Open brackets and simply all we need to do now is refer to the previous step. So for us, it's called source But if you were I don't know for whatever reason your step your first step or step referring to was called something else Then obviously it would be referring to that step instead So I'll just type source and you can see it's popped up with a suggestion So I'm just going to hit tab so it's selected and then the last thing I need to do is do a square bracket and type the word Content and you can see it's now put a closing square bracket and also a closing curve bracket for the function of combine and In most simplest terms what this is doing is just saying combine all the sources Content is one way you could put it. They might not be the most technical answer But it simply put that's what it's doing if we now hit enter You can see how it's done exactly as required. It's gone to all of those files and combined all the information together so you can see we've got obviously the Headers for each file of obviously being included in here and likewise for each file You can see we've got the November snapshot the December snapshot and then lastly the most recent January snapshot and how we've got Like say the first two columns or first three columns of ID name and region are all gonna be the same and then each month It's gonna obviously have a unique file date, but also unique figures here as well So we just need to do a couple of steps to tidy up our data So the first thing I'm going to do is promote the first row of the data set to headers So simply under the home table got selected here halfway across you can see first use first row as headers So if you select that you can see that in scenario has now been fixed The next thing we want want it Well, we will want to address is we don't want these column headings appearing in every you know throughout our data set We literally just want See one set headings and then obviously our dates so all I'm going to do in the file date But again, you could apply this anywhere suitable is I'm simply going to go into the drop-down and I'm just going to deselect file date and Go okay, and you can see that's now created this filtered rows step for me And simply if we now look at it it says obviously change type one, which is our previous step Each file day is not equal to file day So any of you not familiar if we wanted it to be equal to file day you would see this symbol whereas the less than greater than that symbols combined meet Equate to does not equal so we can see that's worked for us as well And yet we then have our data set that we require So two last things I'll just observe as having said that is this file date at the moment is being treated as text I don't want that I want it to be recognized as a date So I'm just going to select the ABC we currently have in the top left for that field And I'm just going to navigate down and select date and you can see it's now converted that to a date for me and likewise for sales, so we're just going to just quickly try and see if we can convert this to a Whole number you might want to do decimal working with Sales amounts, but I'm just going to go for a whole number at this time and Yep, you can see it is converted that for us as well. So let's just check out other ones Yeah, I'm happy employee idea is text name is text region is text sales is a whole number but alternatively obviously like I said You could make that a decimal if you did want decimal places in your values and our last file date We can see has been stored as a date as well So and that yeah, I'm probably just worth noticing You can see the steps have been applied as required and we can now see the actual formula should we require that? So obviously rather than do this manual you could if you could remember it you could obviously type this in Straightaway rather than having to do it manually Last thing to do is going to change this to change the rename. So let's call this something in the lines of Snapshot data through all lack of Better terms so you can see it's now see renamed in the query over here so last thing I'm going to do is go closing load and Obviously it will now refresh and pull through that data for us and there we go We have now got our data All combined into one table for us here called snapshot data It's we've got sheet one here as well. I'm not going to use that So I just deleted that off So the last thing obviously the benefit of doing this is we want about to now present this data So we could simply go into here and let's say let's put in a pivot table. So let's go insert pivot table From table or range and we can select it from here snapshot data So I might done that a bit quick if you navigate to the top left of your table You can see your black arrow Change so it goes into a diagonal as soon as it does that if you select it will identify that you've selected The table alternatively if you knew the table name, you can just type that in here and it will do the same for you And we can just validate. So where is it going to put our pivot table? Okay, location snapshot data, which is our tab name and it's going to go into I1 So yeah, obviously the selection we made here. Let's just do okay And now what we can do is obviously the benefits of having this all into one data is we can now Separate our file dates. So let's just I don't want quarters and years. I just want to have the date And let's say we want to do this by region and then we'll bring in our sales amount And we can see we've now got it there So we can now see all the benefits now bringing this all into one file is we've now got our sales by month and Obviously the total that each region has done an alternatively you could obviously demonstrate this by a person's name as well And as I mentioned halfway through there The real benefit of obviously doing this solution is as new files or snapshots are added to that folder direct Folder destination then obviously every time we refresh our data set And simply all we need to do for that is we right click our data set or our table and we can go down to refresh It will pull through the latest data. So we're able to report on it as well Again, the real benefit of this is it just keeps all those Separate snapshots or those snapshots snapshots separate. This is what I'm trying to say Rather than like, you know having to maintain a manually in one master file So it's a real benefit of using that way. So I hope you enjoyed that video And it gave you a solution if you're looking for this problem Or it's giving you some ideas on how you could improve one of your existing reports If you liked the video, uh, please do give the video a like It's not only greatly appreciated by me, but it does help that all important youtube algorithm And if it's your first time checking out the channel or you've watched our videos before Could I please ask you to consider subscribing to the channel? Obviously it will not only help me But again, it will notify you once you hit that bell notification button of all of our future videos as and when they come out So once again, thank you very much for watching and we'll see you in the next video


Thanks for staying with us. Now following tensions gripping the country between Biafra agitators and security forces, Nigerian President Mohamed Bwari has reiterated that his administration will not bow down to demands of separatists. The president's reaction and decision to crackdown on agitators and criminal elements in the southeast has caused very reactions from across the country. While some agree with the president's approach, others have stated otherwise. Osiroghe Ogboa has more. President Mohamed Bwari said his administration will shock those who want to destroy the system. During a meeting with the INEC leadership, the president said in court, �Those misbehaving today are too young to be aware of the destruction and loss of lives during the Nigerian Civil War. Those of us in the field for 30 months who went through the war will treat them in a language they understand� A cross-section of Nigerians have described the statements as �unpresidential� and �threatening�. �Unpresidential� is quite the reprehensible. I think every Nigerian should come out and condemn the statement because we need to break down that statement, understand what the president was trying to do by putting out that statement. And look at what is the choice of war. We would teach them in the language they understand. What does it mean by that? Basically, it was saying that, �Oh, all the evils did not tell the younger evils the horror of the war.� We would revisit that war, we would revisit the horror of that war to them. For him to have come out and said the things he had said, the way he said them, in the context and the manner in which he said them, on the platform in which he said it. Because it's a classic textbook case of how not to understand and how not to communicate your non-understanding of a very, very sensitive situation. Analysts have also condemned this development, which they have described as a seemingly military approach. I mean, even without the president's reaction yesterday, the possibility of the security authorities carrying out any of the activities on that except of human rights or without anyone being susceptible to human rights abuses was probably non-existent. Our security authorities have shown and have a well-documented track record of human rights abuses. So that wasn't going to happen. The president's statement probably just amplified the space and the opportunity for that to happen, which is tragic and unfortunate, because like you're right, you point. The fact of the matter is, no matter the level of militarization of the landscape in Nigeria, that will not stop people from agitating. The solution is always that it is far better for us to draw, draw now, either convoke a sovereign national conference or go back to the ones did by Jonathan's regime. In its response, the opposition People's Democratic Party advised the president to stop issuing threats and act decisively to end in security in the country. Osaw Gye Ogmawah, Plus TV Africa. Interestingly, a day after, Twitter deleted the president's tweets, insisting that it violates its rules. This obviously didn't go down well with the federal government, as it stated that Twitter's mission in Nigeria is suspicious by the Minister of Information and Culture. Did the social media platform go too far? Osaw Gye Ogmawah is the implication of the action against the Nigerian president. Social media site Twitter, removed on Wednesday, a post by Nigeria's president Mohamadubwari, threatening punishment for regional secessionists, blamed for attacks on government buildings. The social media firm says, Buhari's tweets referring to the 1967-1970 civil war, violated its abusive behavior policy. In reaction to this many Nigerians, senior lawyers, activists and also the Honezen Igbo have praised the social media giant for the steps taken and said it's a warning sign to President Buhari. The federal government in its reaction said Twitter's mission in Nigeria was suspicious. The mission of Twitter in Nigeria is very, very suspect, as Twitter deleted the violent tweets that in Amidicano. I've always said that those who handle the communication of the president are his greatest enemy. Somebody who is managing the Twitter handling of the president, who is supposed to arrange even if the president has made a mistake when he was talking before, in other places of presidency, the barricade and the fear of all kinds, any president who handles that kind of Twitter is supposed to not take the president's request. Mr President has made a very clear, Mr President was speaking strictly to trouble me first. People want to undermine the security of the Nigerian people, for which it's personally a part to ensure that the security of the Nigerian people is in place, and this person has made it a point of duty since 2015 when their political party laws are that they are going to do everything within their means to make the country of government a good place. In reference to Twitter rules and policies, some have argued for or against deleting the president's tweet and if it infringes on the president's right to expression. There's nothing suspicious about the actions of Twitter. I mean, if you read that tweet, you will know that if another man is going to do this, you are on high, or if I say this entire issue, does he expect to come and pick you up? We have seen the terrorist leader, Nambi Kanu, make your friends to kill him, make your friends to turn the Nigerian into his room, and I'm not sure Twitter deleted any of his tweets, except if I'm wrong. So, like a regular moment like this, I think the interest of some organizations in Nigeria is something that Nigerians should start thinking about. From being called on presidential, there have been calls for better handling of the president's social media accounts, and a better approach towards dowsing the tension across the country. Osaogye Ogbama, plus TV Africa. While various reactions are also symptomatic of the divisiveness among opinion leaders, everyone is advised to extreme actions and inactions from the lens of objectivity rather than ethnic and religious sentiment. Now, this is Unhumanitarian Organization. The International Committee of Red Cross established almost one-and-a-half century ago in 1863 says it has not drilled from its core mandate of helping people affected by conflict and armed violence. The group stated thus during a court's visit to plus TV Africa's office in Lagos by its spokesperson. Plus, TV Africa's senior correspondent Kaila Dela Dendi tells us more. While it is debatable whether Nigeria is at war, the International Committee of the Red Cross is not leaving anything to chances as it continues to provide services to civilian population and the Northeast who are affected by the insurgency. Speaking on the challenges faced by its officers, the RCRC spokesman in Nigeria highlights the problem of access. Working with the International Committee of the Red Cross is actually a daunting task. A lot of issues come up and, yeah, working in conflict situations because the organization is giving the mandate to protect and assist people that are affected by armed conflict and violence. And this is what we've been doing in Nigeria. A lot of issues that have to do with access. Most of the times what we want to do is to protect and assist people that are affected by violence and conflict. If we don't have access, then this is really going to be a big challenge because the populations out there are going to continue to suffer. There would be no food to support them with. There would be no medication, so this is really a big concern to us. Sadly, some of the ICRC had had to pay the Supreme Prize while trying to save the civilian population. These, the body says, would not deter them from carrying out their functions dutifully. The humanitarian consequences in the Northeast of Nigeria where most of our operations are is actually very, very severe because we see a lot of people who don't have access to medication, to food, to shelter and so on and so forth. So these are some of the challenges that the organization is suffering because a lot of needs are out there and then our hands are tied. He explains that his neutral role is never called to question. ICRC is a neutral organization, a neutral humanitarian organization that is independently working to assist people that are affected by conflict and violence. This is our principle of operations. We try as much as possible to inform all the actors to the conflicts, both the civilian population and also the armed groups. Of course with the armed forces of Nigeria that we are a neutral organization and what we do is mostly to assist civilian populations. This is what we do. Of course, we also call on all the actors to the conflict to respect the International Committee of the Red Cross and also by extension to respect all humanitarian actors that are there supporting people that are affected. The armed groups are expected to obey the rule of engagement which protecting ICRC officers and other humanitarian groups fall into. Only when this is followed to the letter, the unwarranted attacks faced by these good-spirited citizens may not end in the nearest future. Kairi Ladehendi, Plus TV Africa. And finally on this week's package, the attention is now shifted to Menjro Hygiene Day, a group known as Center for Water and Environment Development has urged parents to educate female words on menstrual health and hygiene so as to know what to do when they are experiencing the flow for the first time. The project manager of the group stated this in Yola during an event to mark today. This year's celebration centered on girls at the secondary school, particularly government girls secondary schools in Yola, the Adama State Capital, with the aim of educating them on the need to know what to do at the first day of menstruation. The project manager, Dori Sakama says it is pertinent for the awareness on the female words in order to reduce the rate at which young girls always fall a victim on the first day of menstruation. She urged parents to always be friendly to their female words at the early stage so that they will know the needful. Not just mothers, even fathers, that's the parents. And that's what if you see in our program is we invite boys so that we catch them young. But eventually they become fathers. If the mother will be shined, at least the father will be able to tell the mother, have you educated this your child?  And mostly they start from age nine. Some of the students thanked the organization for the awareness and expressed happiness saying their awareness will go a long way in guiding them on what to do at the first day of the menstruation. I was afraid, I thought it was my fault. Then I went and told my mom that she now called my aunt. She now asked her if I have a boyfriend. Then my aunt was now like, no, I don't have a boyfriend. Then from then she now called my brother from Levos. Then my brother now told her that it's not a thing because I was at a very thing that age when I started it. Then my brother now... How old were you then? I was nine. Okay. Then my brother now told her that it's a normal thing for a girl to start. She told me that anytime I see blood flowing from my body I should not be afraid. It is menstruation. And she taught me how to use the part. With this one day awareness on the celebration of World Menstrual Hygiene Day it is expected that parents will take up their responsibility in educating female words at the earliest stage. Well it is possible to create a world where no woman or girl is held back because she menstruates. That means the world in which every woman or girl are empowered to manage their menstruation safely hygienically with confidence and without shame. And that's a wrap now but before we go let's do please remind you to follow us at Plus TV Africa on Facebook, Twitter and on Instagram and to subscribe to our YouTube channel at Plus TV Africa. I'm Jacinta Obuco. Thank you for watching. If you enjoyed the news please do subscribe to our YouTube channel and don't forget to hit the notification button so you get notified about fresh news updates.


Welcome planning commissioners staff and guests special welcome to our newest planning commissioner commission member. Mr. Carl S. Soria Multiple staff members are here today to ensure that the meeting runs smoothly and all applicants and members of the public Are able to participate in the meeting at the appropriate times If you're here today and would like to speak about a case Please provide your name clearly into the microphone and please be sure to sign in either at the back of the room Or at the podium for documentation purposes if you're here today to speak about a case You must speak up when the chairperson calls for public comment And I'll go ahead and call the roll. Mr. Cohn present mr. Cook Miss Davis present mr. Osorio Present and Miss Thomas present. We have a quorum. I'll give a brief review of the meeting format Applicants with requests before the planning commission are allotted a presentation time of 10 minutes This time should include but is not limited to an overview of the project case history and any pertinent meetings held regarding the request This time also includes all persons presenting information on behalf of the applicant such as attorneys engineers or and or architects The time limit does not include any questions asked by the planning commission or staff regarding request During the public comment period members of the general public are given the opportunity to address their concerns in intervals of two minutes After the public comment period applicants have five minutes to respond The administrator has a timer and will make presenters aware of when their time has expired The planning commission reserves the right to amend these procedures on a case-by-case basis Are there any changes to the agenda? Yes, there are two changes to the agenda since publication case number six a text amendment Which was TA dash 2023 dash 005 for 1531 Taylor Street has been deferred until the October meeting in Case number eight, which is annex dash 2023 dash 0018 This is a future land use map amendment and zoning map amendment for a pending annexation at Park Lane Road Has also been deferred the planning commission uses the consent agenda to approve non controversial or routine matters by a single motion or vote Examples of such items include approval of site plans annexations and street names If a member of the planning commission or the general public would like to discuss an item on the consent agenda You must speak up after the consent agenda is read Then that item is removed from the consent agenda and considered during the main the meeting The planning commission then approves the remaining consent agenda items I'll go ahead and read through the consent agenda. The first item is approval of the August 10th 2023 meeting minutes and Case number two is a future land use map amendment and zoning map amendment for a pending annexation This is annex dash 2023 dash 0020 at 3214 Bluff Road This is request for a recommendation on the assignment of the land use classification of urban edge community activity center UEC one and the assignment of zoning of community activity center corridor district CAC for a pending annexation The property is currently classified as economic development center corridor and a priority investment area and zoned in one by Richland County Is there anyone here to speak about? 3214 bluff road seeing none we can advance The next case case 3 is annex dash 2023 dash 0021 3650 bluff road This is a request for recommendation on the assignment of the land use classification of urban edge community activity center UEC one and The assignment of zoning of community activity center corridor district CAC for a pending annexation The property is currently classified as economic development center corridor in a priority investment area and zone GC by Richland County Is there anyone here to speak about 3650 bluff road and we can proceed? Case number four is a future land use map confirmation. It's L. U. M. A. Dash 2023 dash 0000 for 118 118 and a half 126 132 and 138 Bluff Road Request recommendation on the confirmation of the future land use classification of urban core mixed residential type 3 UC MR 3 The property is currently assigned an interim future land use classification of UC MR 3 or urban core mixed residential type 3 And we'll go ahead and just read the next case. It's on the same property This is a zoning map confirmation ZMA dash 2023 dash 0013 for the same property on bluff road Request recommendation on the confirmation of zoning of residential two-family mill village district RDMV a portion within the floodplain overlay district The property is currently assigned an interim future land use classification of residential two-family mill village district a portion within the floodplain overlay district Is there anyone here to speak about the cases at bluff road and we can proceed and as mentioned case number six has Been deferred so that brings us to oh well the vote on the Consent agenda Seen as there's no one here from the public to speak on these cases Is there anyone on the planning commission who would like to speak on any of the cases on the consent agenda with that I will entertain a motion to approve the August minutes and the consent agenda Mr. Chairman I'd like to make a motion to approve the consent agenda in the minutes from August Have a motion can I get a second all those in favor say aye. Hi any opposed Motion passes We will use the following outline for the regular agenda items The administrator will introduce the case the applicant will have 10 minutes to make a presentation The planning commission may then ask questions the public comment period will be open to those present The public comment period will be closed The applicant will have five minutes to respond to the public comments Planning commission may ask additional questions of the applicant Deliberation and action by the planning commission will follow. That's going to bring us to S plan 2023 dash zero zero zero nine and this is a project that entails a construction of a 250,000 square foot multifamily development on 2.4 acres within the block founded by Hugi Washington and William Street the proposed development will contain 223 one-bedroom apartments and to 27 two-bedroom apartments in a minute the tea space which will include a clubhouse pool and garages The required number of all-street parking spaces for this development is zero where the applicant will be providing 344 in addition the applicant is proposing to construct eight parking spaces along the Washington Street right away adjacent to the development the requirement required bicycle parking is 13 short short-term parking spaces and 63 long-term parking spaces Whereas the applicant will be providing 15 short-term spaces and 63 long-term parking spaces the applicant has also provided a traffic impact study and should the Commission be inclined to grant the approval of the site plan staff will request that the Commission grant approval subject to staff comments Numberly the applicant as president can explain their case. Thank you for having me. I'll be relatively quick We I am my name is Ryan solo. I'm the president of development for Silver Hills We're a multinational multifamily developer that's active all throughout the United States we partnered with We are a family run organization. So and we are long-term holders of all of our assets So what that means in terms of the projects that we build is we really focus on the quality of what we build We try to build really nice high-end apartments that really activate the activate areas We are very focused on helping to create vibrant walkable downtown So a lot of our projects if you look at what we've done in downtown Fort Myers and in Orlando and in Daytona Beach And and we have a project a 300 unit project in uptown Charlotte that's under construction. We really are We are really experts at trying to activate areas that need the residential Component in order to have the walkability So we're very excited about this project because this is really on you know being adjacent to the corner of huge Hugie and Gervais and right across the street from the public's and walking distance to all the restaurants and community amenities here We're very excited as we think our projects really can activate the area and really feel in need I feel in need that the community doesn't have and that there's been a lot of student housing developed in this area but not really much in the way of Multifamily traditional for rental products. So that's what we're offering here We really focus on building you said it's an urban walkable product So you can see some of the elevations that we have Kind of gives you a sense of what our buildings look like really try to blend into the community and Kind of work through kind of work with the kind of work symbiotically with other the other projects in the area and You know that that's kind of us in a nutshell You know we in our inside of our buildings We are very focused on putting together a high-end amenity package. So we will have a really nice pool courtyard clubhouse Everything in terms of parking for the for the residents will be in a parking garage So there won't be any impact on the part on the on the adjacent neighborhood for parking purposes and That's basically us in a nutshell. I'm happy to answer any questions you may have and I appreciate the time Appreciate the presentation. Thank you. It's been a while. We've seen a few projects For this site. So we're great to see one go We were very excited to work on this we've been we've been working on this project for a long time. So we're really excited to get going the traffic study was favorable for I Believe so. Yes. No additional. Okay. I looked through it, but I Make sure I miss anything Okay, do you want to have any comments? I don't have a comment, but I do have a question Can you tell me what your targeted? Renters are for your apartment buildings. Is it students or is it seniors or so we we are a market rate product So we're not student housing. So this is not designed to be So typically when you see student housing projects, what you typically see is, you know, a common area with three or four or five bedrooms our product is Mostly heavily geared towards one bedroom units our average square footage is you know in the seven That's you know probably high sixes low sevens. So it's really geared towards I would say more of a more You know, typically what we find is our residents tend to be more of the young professional The people who are living and working in a downtown area that being said we we wind up with residents from frankly all walks of life teachers doctors firefighters You know because our unit size tends to be a little bit on the smaller side It allows us to kind of hit a little bit lower of a price point. So we tend to wind up with you know a fair amount of It's really a mix of everything Okay, thank you I have one question for staff. We're in this approval purely looking at the site plan That is correct. I believe DDRC approval will be next week. Okay. Thank you Thank you. Thank you very much Like crowd today, is there anyone from the public who would like to speak? for against or By the project anyone on planning commission have any other questions or comments of the applicant or staff? I'll entertain a motion Mr. Chair, I like to make a motion to approve as planned to 023009 2.5 acres 400 block of Washington Street and 1245 Huger Street Second and is that with staff comments? Yes with staff comments In second All those in favor say aye. Aye. Aye. Any opposed? Motion passes And since the last case was deferred that's all the business we have today That I'll entertain a motion to adjourn Mr. Chair, I'd like to make a motion to adjourn the meeting Second All those in favor aye. Aye


Five weeks ago I spoke to you from the steps and said that this government was not going to hang around and that we would not wait until Brexit Day, October 31, to deliver on the priorities of the British people. So I'm proud to say that on Wednesday Chancellor Sadjid Javed is going to set out the most ambitious spending round for more than a decade. I said I wanted to make your streets safer and that is why we are recruiting another 20,000 police officers. I said I wanted to improve your hospital and reduce waiting times at your GP. And so we are doing 20 new hospital upgrades in addition to the 34 billion more going into the NHS. And I said I wanted every child in this country to have a superb education. That's why I announced last week that we are levelling up funding across the country and spending much more next year in both primary and secondary schools. And it's to push forward this agenda on these and many other fronts that we need a Queen's speech in October while leaving due time to debate Brexit and other matters. And as we come to that Brexit deadline, I am encouraged by the progress we are making. In the last few weeks, the chances of a deal have been rising, I believe, for three reasons. They can see that we want a deal. They can see that we have a clear vision for our future relationship with the EU, something that has not always perhaps been the case. And they can see that we are utterly determined to strengthen our position by getting ready to come out regardless, come what may. But if there's one thing that can hold us back in these talks, it is the sense in Brussels that MPs may find some way to cancel the referendum or that tomorrow MPs will vote with Jeremy Corbyn for yet another pointless delay. I don't think they will, I hope that they won't. But if they do, they will plainly chop the legs out from under the UK position and make any further negotiation absolutely impossible. And so I say to show our friends in Brussels that we are united in our purpose. MPs should vote with the government against Corbyn's pointless delay. I want everybody to know there are no circumstances in which I will ask Brussels to delay. We're leaving on the 31st of October, no ifs or buts. We will not accept any attempt to go back on our promises or scrub that referendum and armed and fortified with that conviction. I believe we will get a deal at that crucial summit in October, a deal that Parliament will certainly be able to scrutinise. And in the meantime, let's let our negotiators get on with their work without that sword of Damocles over their necks and without an election. Without an election, I don't want an election, you don't want an election. Let's get on with the people's agenda, fighting crime, improving the NHS, boosting schools, cutting the cost of living, unlocking talent and opportunity across the entire United Kingdom with infrastructure, education and technology. It is a massive agenda. Let's come together and get it done and let's get Brexit done by October the 31st. Thank you very much.


Worship is about style. Worship is about either music. It's either about clapping or not clapping. It's about jumping or not jumping. It's about shouting or not shouting. But it's not about God. Satan will make you focused on the style of worship as long so it will cause you to miss the object of worship. David one day was dancing before God so crazy and his wife she was sitting on the side of the window and the Bible says that she was looking at him and she's like, I worship God but not like this. And she was so offended with his style when he came in instead of giving him a hug and says, you know congratulations we made it. This is awesome.  And he says, look what you're doing. You're dancing wrong. You shouldn't be moving over there.  You should be more dignified. Carry about your image or your reputation. And David looks at her.  He says the problem with you.  He says, I don't think about how I think about who and how will take care of itself. And the Bible says because she cared about the style she never praised God. God never heard the praise and God's hand was never moved to open her womb to she will conceive a child. If we become a church that worships God for God not for the style and worships God for God, not for the style and worship divinity, not dignity, something is going to happen. God is going to hear that. And the Bible says God's hand is going to be moved. Can somebody say amen? And God's hand is going to be moved. When we come to worship here and you realize that it's not about the style. It's about the object of our worship. God's hand is going to be moved and God is going to bless us and God is going to use us and God is going to touch us. It's not about the style. It's about the object of our worship. Sometimes people come and say, I didn't feel anything during this worship. I did not like this worship. Since when was this worship about you? I thought we were worshiping him. So if you didn't like it, great. That wasn't for you in the first place. The question is, did he like it? And if he liked it, we're all happy. And if you did not like it, do not worry because it was not about you in the first place. When you come and it's not your favorite song and not your favorite musician and not your favorite leader and not your favorite this and then. The words are not there. Remember, this is about the object, not the style. And when you are in love with the style, you cannot get the hand of God moving. Why? Because you're not worshiping the object, you're worshiping the style. That's why most of us, the songs that you like on your iTunes are mainly about the style, not necessarily about object. And it's good to like the style. Don't get me wrong. It's good to sing professionally. It's good so when you have all the instruments, you have the flute, you have the drums. It's good when the worship leader really pumps you up. It's good when the song makes you move, makes you jump. But at the end of the day, rejoicing in worship and liking the style does not move the hand of God. It's when I keep in front of my mind, it's not about the song, it's about the God. It's not about the music, it's about the creator. And only then his ear hears that I make him the object of my worship. His hand will begin to move. Can somebody say amen?


Hey guys, it's Drew with GeoArm and I'm back to talk to you about the 2GIG edge and learning in the 2GIG-GB1E-345 glass break detector. Super easy to do. The first thing you're going to do when you get it out of the package is you'll need to remove it from its back plate, which is very, very easy to do as well. But I've already done so. So once you're able to separate it by basically just getting the arrows unaligned by twisting it counterclockwise, if you look closely from the back here, I'm going to twist it counterclockwise and then it comes open. And I've already installed the batteries. These come in little individual pieces of plastic for wrapping. But you're going to need the back plate off at this point anyways. So what we're going to do after you've inserted the batteries is we're going to go ahead and jump into our panel programming menu by hitting the gear in the bottom right hand corner and entering our installer code, which on mine is 1561, which is the factory code. We're going to scroll down to installer toolbox. At this point, you're going to go into panel programming. It'll populate another set of menus here. And you're going to go into wireless zones. At this point, you're going to go to the first available zone or whatever zone that you want to use personally. Mine is going to be on zone one because I don't have anything programmed in here. First thing we're going to do is we're going to choose the equipment code for this. It is going to be the E-Series glass break detector, which the code is 2864. And once you've chosen the correct equipment code, you press the down arrow. At that point, it's going to ask what the sensor type is. You're going to choose whatever the responsibility for your glass break is going to be. If you're trying to monitor for a 24-hour glass break, then you need to be aware that any noise with a high pitch more than likely would trigger a glass break detector, so be very careful. What I typically recommend is only having an arm when you're not there. So what I'm going to do for this one is choose perimeter. And then we're going to choose the down arrow to acknowledge that. And then it's going to be asking for the TXID. At this point, we're going to hit the learn button on the keypad there. And then we're going to hit the tamper switch, which is located just in between the two batteries on the inside of the circle here. So you can see it right here. You just press that button down, and it should learn it in. There it is right there. So it took me pressing it down a few times, but it did eventually learn in. So it's in there now. You hit accept on that to confirm the serial number. The sensor loop should be a one. You press the down arrow, and at this point, you can choose the voice descriptor. So I'll just make this living room, for instance. So I'll type in living, and then room, and then glass break, and then press done. So now it says living room, glass break. You don't really need a chime for a glass break detector. The smart area assignments, I'm going to leave the transmission delay. That lets the panel know that this needs an additional delay before it transmits. I typically turn that off because I want my sensors to transmit immediately. After that, you press the down arrow, then you're going to see sensor reports. That's if you want this actual sensor to report its alarms to the central station. Of course, I would choose yes because we want it to report to the central so that we call you and let you know what's going on. Finally, it's sensor supervised, which lets the sensor know that it needs to check in with the actual 2GIG edge system to report and let it know that it's okay. At this point, it is programmed incorrectly. You're going to hit the back arrow all the way out of programming. Make sure to subscribe to our YouTube page and click the Show More tab underneath the video where you can view valuable links pertaining to this product, similar how-to videos, and our low-cost, no-contract alarm monitoring services.


Okay, so maybe this CSC is a little light on biologists of note, and a little heavy on religion and lawyers, but they are a think tank after all, it's not as though they were a research lab. But in 2005, thanks to grants from the CSC, a research lab was born, with strong ties to the Discovery Institute.  A journalist from the New Scientist, a magazine for science people, showed up at the front door in late 2006, in an attempt to interview the researchers there. After getting a chilly reception, including actually having the door slammed in her face, she was finally granted an audience with one of the directors, George Weber, a retired business professor at a private Christian college. He stated that, we are the first ones doing what we might call lab science in intelligent design, and the objective is to challenge the scientific community on naturalism. He also states that Biologic Institute is a branch of Discovery Institute. A few days after this interview, Weber left the board. In an email, the lab's senior researcher and spokesperson, Doug Axe, told the new scientists that Weber was found to have seriously misunderstood the purpose of Biologic and to have misrepresented it. Apparently he spoke out of turn and was expelled for it. Doug Axe and Galger and Brendan Dixon seemed to be the core of the Biologic's nine current faculty. Of the nine faculty, only three have PhDs in Biological Science, and three were in the movie expelled as poor victims of scientific establishment. So how productive is this research institution, operating on a budget of half a million dollars a year? Since 2005, they have produced two papers. That's one paper per two years between nine faculty. What have they discovered? They wrote a software program that models the evolution of Chinese Han characters as some sort of analogy to protein folding. And Sternberg wrote a philosophical paper on gene function relationships. Both papers appear in online only journals, meaning you can't pick up a copy of these articles written on paper. The software program appears to be in a journal with an acceptance rate of 60%. Basically you pay $1,300 and you get your article published. The other is in a philosophy and mathematical modeling of bioinformatics journal. And yet on their website they list over 30 publications. But wait a minute, some of their publications predate the inception of the institute by six years. What they've done is claim credit for the faculty's previous work at other institutions, work that has nothing to do with intelligent design. To address the questions of who, what, where, and show me the money, let's ask the important question of why. Simple. They aren't interested in convincing the scientific world of their position. They don't need legitimate research results. They could care less if they discover any therapies or diagnostics. They are only interested in the illusion, the skin deep impression of real research, real scientists who have a dissenting opinion of the almost universally accepted views of evolution and common descent. You need look no further than the infamous wedge document, authored by Philip Johnson at the inception of the Discovery Institute. If you haven't read it I have a link on the right to the original document, in which a strategy is laid out to bypass the First Amendment protections against state supported religion. And before I get a comment that a separation of church and state is not mentioned in the Constitution, read the Supreme Court decision of 1878. In the wedge document, Doug Axe has given the task of creating a research institution for the express purpose of giving scientific legitimacy to the movement. Paul Qian, the marine biologist, is given the task of taking on the entire paleontology community and the purpose of the organization is clearly spelled out to be religious. I don't understand how anyone could believe that this institution is anything other than a religious apologetics organization attempting to disguise itself to bypass constitutional protections. And they are succeeding because the American people don't know the difference between a point mutation and a point guard. You guys with lab coats have a disagreement? How is the average person supposed to make a choice? Teach the controversy? That sounds eminently reasonable. The Discovery Institute is preying, pun intended, on poor scientific competence of the American people and picking their battles where local government is dominated by fundamentalists and evangelicals. It's sad and a little scary and unless people wake up and realize what is being done science education in the US is in real jeopardy. I want to leave you with an entertaining story that made me laugh. Anne Galger, one of the faculty of the Biological Institute reported on her work at the Wister retrospective symposium. She discussed leaky growth in microbial colonies at high densities leading to horizontal transfer of genetic information and announced that under such condition she had actually found a novel variant that seemed to lead to enhanced colony growth. Gunther Wagner said, so a beneficial mutation happened right in your lab, at which point the moderator halted questioning. Thanks for watching.