text:
Astronomy Camp at AIS 2011
Well, this is the first blog post that I'm publishing after 2 months. I'm really sorry about the absence of updates and news as i was really busy with University academics and AIESEC work. This post is about the Astronomy camp that we conducted for the Asian International School (AIS) last 18th of March
Astronomy Camp - March 2011 at University of Colombo
I'm now gonna blog about an event that we had in our University almost 2 months back. I'm really sorry guys for dragging this such longer due to the busy schedule I've been undergoing last few months due to various reasons. Hope you don't mind me sharing in so late. Anyway here it is...
Watch Total Solar Eclipse 11th July 2010 Live Streaming from EclipseBlog
The most awaited total solar eclipse of the year 2010 is about to take place in less than next 20 hours from now. There have been a lot of groups/ individuals flocked at South Pacific islands and Chilean territories right now waiting for the eclipse to take place.
IYA2009 Commemorative Coins Issued by Many Countries Worldwide
As the title of this post hints, there were lot of countries involved in this worldwide celebration during 2009, which was the 400th anniversary of both the discovery of telescope for astronomical observation by Galileo Galilei and the publication of "Astronomia Nova" by Johannes Kepler. These were the reasons which were prominent in specifying 2009 as the IYA.
A Tribute to Fiami the author of The Lives of Galileo
I have already made a post about Fiami, and his great gift that I received during the Christmas season. I got many great feedback on that and even my friends wanted to read it, as none of them had the comic book with them, So I thought of doing a youtube video featuring Fiami
93rd Birth Anniversary of Sir Arthur Clarke
8:06 AM Desh No comments
Let's cherish the 93rd birth anniversary of Sir Arthur Clarke, who rendered an immense service to the world, by means of his innovative concepts on telecommunication + thrilling scientific books, We should do something to remind the world about his being in a day like this, as what his imagination has rendered, continues to grow day by day....
Here is some information from his bio, for those who wish to know, [Source: Wikipedia]
Clarke was born in Minehead, Somerset, England. As a boy he enjoyed stargazing and reading old American science fiction pulp magazines. After secondary school and studying at Huish's Grammar School, Taunton, he was unable to afford a university education and got a job as an auditor in the pensions section of the Board of Education.
During the Second World War he served in the Royal Air Force as a radar specialist and was involved in the early warning radar defence system, which contributed to the RAF's success during the Battle of Britain. Clarke spent most of his wartime service working on Ground Controlled Approach (GCA) radar as documented in the semi-autobiographical Glide Path, his only non-science-fiction novel. Although GCA did not see much practical use in the war, it proved vital to the Berlin Airlift of 1948–1949 after several years of development. Clarke initially served in the ranks, and was a Corporal instructor on radar at No 9 Radio School, RAF Yatesbury in Wiltshire. He was commissioned as a Pilot Officer (Technical Branch) on 27 May 1943. He was promoted Flying Officer on 27 November 1943. He was appointed chief training instructor at RAF Honiley in Warwickshire and was demobilised with the rank of Flight Lieutenant. After the war he earned a first-class degree in mathematics and physics at King's College London.
In the postwar years, Clarke became the Chairman of the British Interplanetary Society from 1946-1947 And again from 1951-1953 although he was not the originator of the concept of geostationary satellites, one of his most important contributions may be his idea that they would be ideal telecommunications relays. He advanced this idea in a paper privately circulated among the core technical members of the BIS in 1945. The concept was published in Wireless World in October of that year. Clarke also wrote a number of non-fiction books describing the technical details and societal implications of rocketry and space flight. The most notable of these may be The Exploration of Space (1951) and The Promise of Space (1968). In recognition of these contributions the geostationary orbit 36,000 kilometres (22,000 mi) above the equator is officially recognized by the International Astronomical Union as a Clarke Orbit.
On a trip to Florida in 1953 Clarke met and quickly married Marilyn Mayfield, a 22-year-old American divorcee with a young son. They separated permanently after six months, although the divorce was not finalised until 1964."The marriage was incompatible from the beginning", says Clarke. Clarke never remarried but was close to a Sri Lankan man, Leslie Ekanayake, whom the author called his "only perfect friend of a lifetime" in his dedication to The Fountains of Paradise. Clarke is buried with Ekanayake, who predeceased him by three decades in 1977, in the Colombo central cemetery. In his biography of Stanley Kubrick, John Baxter cites Clarke's homosexuality as a reason why he relocated, due to more tolerant laws with regard to homosexuality in Sri Lanka. Journalists who inquired of Clarke whether he was gay were told, "No, merely mildly cheerful." However, Michael Moorcock has written:
Everyone knew he was gay. In the 1950s I'd go out drinking with his boyfriend. We met his proteges, western and eastern, and their families, people who had only the most generous praise for his kindness. Self-absorbed he might be, and a teetotaller, but an impeccable gent through and through.
Moorcock's assertion is not supported by other reports, although in an interview in the July 1986 issue of Playboy magazine, Clarke stated "Of course. Who hasn't?" when asked if he had had bisexual experiences.
Clarke also maintained a vast collection of manuscripts and personal memoirs, maintained by his brother Fred Clarke in Taunton, Somerset, England, and referred to as the "Clarkives." Clarke has said that some of his private diaries will not be published until 30 years after his death. When asked why they were sealed up, he answered "'Well, there might be all sorts of embarrassing things in them"
Cassini Scientist for a Day Essay Contest 2010 – Sri Lanka
The 9th Edition of Cassini Scientist for a Day Essay Contest, Fall 2010 is now in progress around the world. Cassini Scientist for a Day Essay Contest is an international essay contest, carried out by NASA. This is aimed at raising awareness about Saturn, its moons and current updates among students in general. At the same time this contest focuses on improving students know-how on essay-writing and scientific thinking and merging them for a better output.
Sri Lankan students now have the chance of taking part by submitting their entries. If you're in grades 5-13, this is the change to show the world the talent you got. The contest is held under 3 age groups and you can write an essay about any of 3 targets that Cassini spacecraft reached in last October.
Age groups:
-Grades 5 to 6
-Grades 9 to 13
•Target 1: A close-up view of the moon Rhea
•Target 2: A video of Titan, Tethys and Enceladus dancing under Saturn's rings
•Target 3: A time-lapse movie spanning a whole day on Saturn
Just grab up the target, that you're most interested in and start putting together a piece of writing. You're supposed to explain why your target is the best to yield more about Saturn and its moons, in terms of scientific value. Go ahead and do some research and learn as much as you can about these targets and enrich the content belonging to your preferred.
Your essays will be evaluated by a panel of judges and winners will have the change to raise their questions directly from the Cassini scientists. Moreover every entry will receive a certificate of participation too.
You can browse the contest rules at http://scientistforaday.blogspot.com/p/contest-rules.html
and submit your entry online as well. More information is available from Cassini Scientist for a Day as well
If you have any inquiry or clarification to be made fee free to email it to jdpdesh (at) gmail.com , also you can contact the National Coordinator through 071-6202262
Thank you for your interest in the Cassini mission, and good luck with your essays -- Look forward to hearing from you!
Prasanna Deshapriya
National Coordinator for Sri Lanka
Scientist for a Day Essay Contest 2010
6-photo-slider
10:52 AM Desh 1 comment
Well, If you have read one of the latest blog posts you can be familiar with this '6-photo-slider' that I'm gonna talk about now. Otherwise you can check that out at Starry Night in Kandy | Another Outreach Event with MAS, which will make more sense.
Now I'm gonna present you the 6 photos of the final slideshow we had. Indeed it was a tough challenge for the contestants to correctly recognize the 6 photos, each of which was made visible only for 10 seconds from the projector. Now try it for yourself too and check how many of them are familiar to you. Of course you can have as much time as you prefer, but try to do it quick. Random googling might not help a lot since Google is yet unable to google images/ photos :) Correct answers can be found at lowermost portion of this post. Take a minute just for a small test.
Before giving you the answers I'd like to just let you know about the final evaluation we had.
It was the Sombrero galaxy which was the only object identified by the students. Now go and see how you have performed.
I'd like to hear any feedback as well, if you might have.
Abell Nebula
Sombrero Galaxy
Witch-head Nebula
Apophis Asteroid
Comet Lulin
Hubble Nebula
A lecture on Exoplanets by Michael Snowden
A lecture on Exoplanets will be delivered by professional astronomer Michael Snowden tomorrow at University of Moratuwa. Michael is a professional astronomer from New Zealand and he has been contributing towards the development of astronomy in Sri Lanka since last few decades. Following are specific details about this lecture.
Michael Snowden
Topic : Exoplanets
Time : 11:00 AM
Date : 04th of November 2010
Venue : Auditorium of Department of Electronic & Telecommunication Engineering, University of Moratuwa
Starry Night in Kandy | Another Outreach Event with MAS
11:01 PM Desh No comments
Last Friday gave me the hope of the beginning of a fresh weekend, getting started with an astronomy event. It was the members of the Mathematical & Astronomical Society of University of Colombo (MAS), back in outreach action. We had been invited to contribute to the 'Starry Night 2010' organized by St. Anthony's College, Kandy. Basically this 'Starry Night' focused on 2 segments being Astronomy Quiz & Workshop, first of which is an evaluation of observation based astronomy knowledge in general and the latter was aimed for providing more insight into astronomy and observation, particularly aimed at newbies of astronomy.
Our outreach task was to conduct the astronomy workshop and the quiz related observation sessions. As a matter of fact I'd like to note that this is the normal procedure every school adopts when it comes to organizing such an event. This is reflected with my experience with such astronomy campaigns in recent times, You always have a bi-dimensional workout, which has a quiz and a workshop. Moreover this was the twice in a row, that I would be getting involved with the same annual event, organized by the same school. I was there last time too, but I'm afraid I haven't made a blog post about that :(
We left Colombo, actually the University premises, around 1.00 pm starting our way up amidst the hills to Kandy. There were 9 of us, as contributors representing MAS, plus Mr. Jayathu Fernando, a Research Scientist of The Arthur C Clarke Institute for Modern Technologies (ACCIMT), and his family members joining Starry Night 2010 and we were quipped with 2 telescopes + few Meade binoculars, which were the primary resources we were having for this outreach maneuver.
Here are our members that contributed.
Prasanna Deshapriya (me)
Chethya Vidanapathirana
Virajith Samarasinghe
Saman Aravinda
Nisal Samararatne
Gayan Anushka
Muditha Bandara Rathnayaka
Chamika Niranjan Goonetilaka
Chanya Deshani Subasinghe Arachchige
You always know that you can't count on weather, it's a key fact that is unpredictable. It was the same monster that came against us last Friday evening. We managed to arrive at Kandy around 8.00 pm despite the rain fall and some stopping-bys that had to be made on the way. The students started off Starry Night 2010 as soon as we arrived and the first was the lecture by Mr.Jayathu Fernando as the chief guest on instruments, used with astronomy. However the skies remained cloudy and it was rare that you could spot any star at all. It took our hope of observations away and seemed that we would have to be just stick to indoor sessions, which was what actually happened in the end.
Still we conducted the workshop by having separate sessions, covering Observation Astronomy, Star Maps for Dummies, and much more detailed discussion on Rayleigh scattering. There was also a Q&A session allowing the students to raise whatever the questions they had and to have their doubts cleared. But it was really bad that no observation could be made, but we were looking forward for better skies even in the later morning hours, but the waiting never paid off.
In addition to astronomy, Antonians didn't forget to add some variety to the event, with their talented musicians and the great magic show, which took everyone by amusement. It was the first time I saw a magic show during an astronomy event. Hats-off to the dedicated Antonian guys for their great organizing efforts !
In the end we contributed to the last round of the quiz, (but this turned out to be the penultimate in the end) which was a photo based round, where the students were supposed to recognize the projected photos of nubulae, galaxies, and other stellar / extra-terrestrial objects. Soon, it was the time for the announcement of the winners, but we, who were also held the quiz-masters of this quiz, were told that there had been a tie of scores of 2 teams, so that a winner for the quiz would not be announced. Since there was no regulation on a tie-break had been introduced prior, we opted in for 'another' final round and announced that. I prefer calling this last round as '6-photo-slider' since the way it was prepared was so unique. Finally the team from the Ananda College won the quiz and the Isipathana College emerged runners-up.
It was around late noon on Saturday the 30th (just before the Halloween), when we were back in Colombo, after some involvement with astronomy and traveling within a 24-hour period.
Please await the photos and crucial '6-photo-slider'
2 Sri Lankans Visit Europe
In recent times there were a lot of conferences, exhibitions and awareness programs taking place around the globe just focusing on astronomy and related issues. You might remember CAP2010 which was held in South Africa sometime ago in this year. I think this kind of programs help boost the world of astronomy and they help people to gain more insight into this wonderful science.
Well, today I'm gonna focus this post on a couple of events, being JENAM 2010 & Space Generation Congress 2010 (astronomy and space issues related respectively) and their Sri Lankan participation. They were held in Europe within last 8 weeks.
In fact 2 Sri Lankans made their way to Europe for these events representing Sri Lanka and basically I believe that it's been a great chance for our country to be noticed in terms of astronomy and space.
Thilina Heenatigala
The first of these was JENAM - Joint European National Astronomy Meeting, held in Lisbon, Portugal starting from 06th to 10th of last September. Thilina Heenatigala, Secretary of Sri Lanka Astronomical Association represented Sri Lanka and he presented a session on GAM - Global Astronomy Month - 'Inaugurating a New Annual Celebration of the Universe'. In addition to that there were manifold topics, being discussed on the grounds of IYA2009, its various projects and beyond IYA as well.It is also noteworthy that there was a Book Launch "Postcards from the Edge of the Universe" at the ESO stand in collaboration with JENAM 2010.
Yohan Ferreira
The other event was Space Generation Congress 2010, held in Prague, Czech Republic from 23-25 September, 2010. Space Generation Congress is the annual congress organized by The Space Generation Advisory Council, which is a global non-governmental organisation, aiming to represent students and young space professionals to the United Nations, States, and space agencies.Yohan Ferreira, who is the SGAC Regional Coordinator for Asia Pacific represented Sri Lanka in for this.
I think we can look forward for more opportunities similar to this, so that we can better showcase how Sri Lanka perceives and contributes to astronomy and space related issues, which in the long run can benefit everybody. Of course hats off to the two guys for their contribution rendered and looking forward to more input....
Just as its name states STAR PARTY is not merely a function of night sky observation, but an aesthetic introduction to the field of Astronomy, an enigmatic experience for an apprentice, unforgotten night for everybody participating in. In Sri Lanka Star Party is the dream of every stargazer, not only to witness but to get involved. When we embarked upon Star Party in 2004, with the Astronomical Society of Mahamaya Girls' College, Kandy, being the pioneers of Observation Competitions in South Asia region, it was visible that a gleaming future of Sri Lankan astronomy was lying ahead. Consequently this turned out to be an official launch of a mammoth event of local astronomy calendar.
Even though stargazing assemblages are found frequent in foreign countries, they're rarely seen in Asian continent. Due to the inadequate allocations and investments in Astronomy field, still a slowly development is in progress. What is more amazing in Star Party is that both amateurs and veterans are allowed to employ their practical aspects of astronomy, enabling their wisdom to pacify the unique taste of this ancient science. Inculcating young astronomers to be accredited professionals is also one of our goals. Now you shall find it easy to understand our definition of Star Party.
Let's take a brief look at the format of Star Party. In the beginning according to their schools, all the participating school students are divided into teams, each having 5 members. And then there are observation sessions to compete at, inclusive of lunar observation, constellation observation, deep-sky observation plus a quizzical evaluation in the end.
Ultimately the most outstanding team, which has scored highest overall marks, will be awarded champions.
And Star Party is back,
Date : 15th Oct 2010
Time : 4:30 p.m. local time
Venue : University of Peradeniya, Kandy, Sri Lanka
Targeted Audience : School Children/ Amateur Astronomers
More Information can be obtained from info [at] starparty.lk and don't forget to check out the official website http://StarParty.LK , This ime there will be an online quiz as well for anybody to take part and end up winning prizes in addition to the webcast [http://Live.StarParty.LK] that will also be on air via the website during the Star Party time
A Post of Revival
11:32 AM Desh No comments
I thought of publishing this post just to revive the blogging, that I've been continuing over the last 2 years. In fact I'd been way busy during last couple of month, with various stuff, like Uni exams, numerous functions, AIESEC projects, of of course SLUG - which is the latest focus, being the Sri Lanka University Games, held triennially - I got qualified to the Chess team of our University :), Of course this made me stuck in an environment, with less astronomy, when it came to practical aspects in deed. However I'm fortunate not to have missed that much of news and updates thanks to the internet and Facebook community where there're friends like Thilina, Yohan, Joan, Gianluca, Tatiana, Julio etc...
I hope to publish several other posts on some astronomy stuff that are related to Sri Lanka in upcoming posts, and I believe you, the readership will follow me as they did earlier and I take this moment to regret my online absence via this blog during last couple of months.
Let's move forward, the blog has now been revived :)
Received the IYA2009 Commemorative Coin of Ukraine
I'm writing this post to update about the Ukrainian IYA2009 coin that I received yesterday. In fact this is the first IYA2009 commemorative coin that came under my possession although it's already been more than 7 months since the closing ceremony of IYA2009.
Here is the coin and some of the details about it.
Denomination: 5 hryvnia (currency of Ukraine)
Metal: Copper-Nickel
Weight: 16.54 g
Diameter : 35 mm
Quality: special uncirculated
Edge: grooved
Mintage: 45 000
Designers: Volodymyr Taran, Oleksandr Kharuk, Sergei Kharuk.
Authors of models: Anatoly Demyanenko, Sviatoslav Ivanenko
I ordered the coin through Ebay, which is of course the best shopping center out there online and it took around 2 weeks for the arrival of the coin via snail-mail.Still you can order the coin and it costs less than 12 USD in total including shipping as well, Although I have searched for the other commemorative coins of other countries, Ebay didn't seem to have them on sale; of course they can be bought online at different numismatic stores but at very expensive rates.
If you're a regular visitor to this blog you must have noticed that Australia, Austria, Canada, Malaysia, Cook Islands, Greece..etc have issued official commemorative coins in celebration of the International Year of Astronomy 2009.
Additionally you can find a complete archive about all the official commemorative coins of IYA2009 though the IYA2009 Coin Blog that I've published.
However I have not given up my numismatic thirst and am always on lookout for the rest of the coins to be collected.
http://astroblogger.new.newsvine.com/_news/2010/04/04/4115392-iya2009-commemorative-coins-from-around-the-world
Eclipse 11th July 2010 : Photos + Videos + Experience
1:27 PM Desh 2 comments
The only total solar eclipse of the year 2010 took place few hours ago over the South Pacific Ocean and some Latin American countries. Many astronomers + eclipse-chasers, who had already made it to the possible eclipse sites were lucky enough to witness the total solar eclipse with fairly good weather condition. Traversing over the South Pacific the silhouette of the moon crossed over Polynesian Islands, Easter Island, Cook Island and ended its path from Southern Argentina after going through Chilean territories.
Moreover it was more interesting to see Easter Island / Isla de Pasqua being crowded with a lot of people interested in astronomy & astrophotography in general. It's also noteworthy that the same island is subject to Archaeoastronomy | ethnoastronomy as well.
It was glad to see some of these astronomy groups live streaming the webcast of total solar eclipse with instantaneous tweets as well. In my opinion that was very helpful for the rest of the enthusiasts, who have not been unable to make their way to South Pacific/ Chile.
Here are some of the videos that have been recorded featuring different phases of the entire eclipse. These include the phenomena such as totality of the total solar eclipse, the solar corona, and the spectacular diamond ring effect, that are not to be missed in an eclipse like this.
Credit : WOLFC2008 [You can check out his youtube channel and there're more videos uploaded featuring the Total Eclipse]
The following is a footage courtesy of AFP featuring Pre-eclipse preparations at eclipse site located in Easter Island among those ancient cultural icons/ artifacts.
This is an another video produced by Reuters [Thanks Universe Cafe for sharing this :)] catching some best moments during the total solar eclipse. This is also from Easter Island by http://www.youtube.com/user/mkentrianakis
I was tuned in with the live webcast brought out by Wakayama University from Hao Islands (French Polynesia) while the tweets of Ichikawa Yuichi from the same group kept many of the viewers updated.
Credit : Wakayama University
Here are some of the great photos featuring the total solar eclipse.
Credit: Donald Gardner [Atoll de Hao, French Polynesia, South Pacific]
Credit :Alejandro Tombolini [Trenel, La Pampa, Argentina]
It was evident from the Google trends that people were after the total eclipse and Fifa WC Finals during last few hours. For example the EclipseBlog I manage in both Spanish and English received more than 20,000 visitors during last 24-hours.
In case you happened to miss the eclipse, still you can watch the recordings. They can be accessed here. These are courtesy of Wakayama University Group.
1.http://www.ustream.tv/recorded/8217930 #1 from Hao, French Polynesia
The EclipseBlog will be featuring live feeds from different sources as an attempt to bring the eclipse live to many those whoa re unable to make it to the exact locations. During last Annular solar eclipse, back on 15th January EclipseBlog together with SkyLK brought out a live streaming of the eclipse from Jaffna, Sri Lanka.
Here is the webpage where you can watch the eclipse online. http://2010eclipse.blogspot.com/p/solar-eclipse-live.html
Let's hope the weather will be fine and everything would be ideal for the total solar eclipse.
Here are some basic facts about this total solar eclipse.
As the second solar eclipse of the year 2010, there will be a total solar eclipse on 11th of July 2010. This will also be the only total solar eclipse visible for this year. In this eclipse the totality will last for maximum 5 minutes and 20 seconds, exactly at the point (Co-ordinates : 19.7S & 121.9W) which is marked in below map. The totality will start at 18:15:15 GMT (UT) and will end at 20:51:42 GMT (UT) as the shadow leaves the Earth.
Path of Total Solar Eclipse :
The path of the eclipse, whose maximal width would be some 259 km, falls over the southern hemisphere of the planet, mostly traversing through the Pacific Ocean. In fact the Moon's umbral shadow will cast through the South Pacific Ocean while Cook Islands (especially Mangaia, the oldest island in the Pacific) & famous Easter Island (Isla de Pascua in Spanish)will be the only landmasses to be encountered in the South Pacific Ocean. Then the moon's shadow of the total solar eclipse will take the route across southern Chile and Argentina, as the totality will come to an end from there onwards.
Path of Partial Solar Eclipse :
In addition to the totality, which is restricted only for a small populated territory, a partial solar eclipse, caused by the Moon's penumbral shadow will be visible to a wider region, which includes South Pacific and South America. The counties where the eclipse would be visible as a partial solar eclipse include Argentina, Chile, Peru & Bolivia. If you're inside a vessel in South Pacific you will likely at least see the partial solar eclipse.
Eclipse solar total el 11 de julio de 2010
Información sobre el eclipse:
Como el segundo eclipse del 2010, habrá un eclipse solar total el 11 de julio de 2010. Este será el único eclipse solar total que se verá este año. Este eclipse durará en total 5 minutos y 20 segundos como máximo, exactamente en el punto señalado en el mapa inferior. (Coordinadas: 19.7S y 121.9O). El eclipse total comenzará a las 18:15:15 GMT (TU) y terminará a las 20:51:42 GMT (TU) a medida que la sombra se aleje de la Tierra.
La ruta del eclipse solar total:
La ruta del eclipse, cuyo ancho máximo sería de alrededor de 259km, cae sobre el hemisferio sur del planeta, atravesando principalmente el Océano Pacífico. De hecho, el umbral de la sombra de la Luna se proyectará a través del Océano Pacífico Sur mientras las Islas Cook (especialmente Mangaia, la isla más antigua del Pacífico), y la famosa Isla de Pascua serán las únicas masas terrestres que se encuentren en el Océano Pacífico Sur. Entonces la sombra de la luna del eclipse solar total seguirá la ruta a través del sur de Chile y Argentina a medida que el eclipse total terminará de aquí en adelante.
La ruta del eclipse solar parcial:
Además del eclipse total que está restringido a una pequeña parte de territorio habitado, un eclipse solar parcial causado por la sombra penumbral de la Luna será visible en una región más amplia, que incluye el Pacífico Sur y América del Sur. Los países en los que el eclipse sería visible como un eclipse solar parcial incluyen Argentina, Chile, Perú y Bolivia. Si usted está en un barco en el Pacífico Sur seguramente podrá ver al menos el eclipse solar parcial.
Source : http://2010eclipse.blogspot.com/2010/02/eclipse-solar-total-el-11-de-julio-de.html
GAM-Global Astronomy Month (GAM2010) - Trailer Launched
Guys, here is the long waited official trailer of GAM2010 :
If you have a close friend you'd love to take to a star party,
a family member you'd like to show the sky,
a colleague you've always wanted to understand the exciting things in the sky,
a distant friend who shares your passion for astronomy,
a stranger on the street you want to encourage to look up at the wonders that lie just above,
this is your invitation to share the sky with them all.
Take your family. Invite your friends. Share your sky.
Be part of Global Astronomy Month.
~One People, One Sky~
And here is the Spanish version of the trailer :
El trailer oficial del Mes Global de la Astronomia, 2010, en Español. Un mismo Pueblo, un mismo Cielo!
GAM- Is There Anybody Out There ? : Spying the Exoplanet TrES-3b
Back to back nights with astronomy, which is such an irresistible sequence of events, were taking place right from 06th of April, This GAM 2010 featured remote observation sessions continued even on 07th of April, supporting the fact that quench for the true astronomy is hardly appeased. I hope this is the 2nd night that Gianluca broke rest. His dedication to the GAM & Astronomy is so remarkable...
After running a long marathon collecting more than 100 Messier objects all over the heavens, our next goal was an espionage, Yes literally we set out to spy the Exoplanet TrES-3b, which was transiting over it's own star. We were led by Gianluca with his clear and detailed commentary and we had Virtual Telescope by your side to equip us with the tools necessary for the analytics of far-away TrES-3b.
Here is a video that I created, featuring Gianluca during our Espionage of TrES-3b.
This starry adventure was more of a scientific one, which was capable of determining many parameters with pure science, astrophysics indeed. We can plot a graph from the data yielded from observations and then integrate all the plots with error bars to determine important information of the target, which in this case was TrES-3b. I have posted below some of the raw plots and full graph in the end.
The parameters such as velocity, mass, orbital period, etc of Exoplanet TrES-3b could be deciphered from the plots, and I welcome anybody to go ahead and analyze the data and make them available here with a comment. This is just to make you, readers more knowledgeable and build a colloquium on this great exercise..
As same as in the previous remote observation session, participants were issued with a certificate, which is in fact a souvenir of GAM2010. So far GAM has been so thrilling and exciting and I believe in the fact it will continue to fascinate more people under the AWB's general slogan "One People One Sky"
Here is the certificate
Thus follows the plots, First I will post the final Plot, !!
Here are the rest of plots that were made with the help of Virtual Telescope, There are ordered in the order of their time of being plotted. Firtst one is the earliest and so on and so forth.
Thank you AWB, VT & Gianluca for giving all of us a great chance to keep discovering the universe on our own with GAM 2010. Be ready for the upcoming GAM events Saturn Watch and Here Comes the Sun !
GAM-Messier Marathon with 6,500 Runners ! 10 + Hours
I was lucky enough to be a part of the largest Messier Marathon, which could be claimed as the largest event of such a kind with the participation of more than 6,500 runners (participants) for throughout a period of 10+ hours. This was the 1st virtual remote observation session that we had in GAM, The observations were based on Virtual Telescope located at the backyard observatory of Dr. Gianluca Masi, Ceccano, Italy together with the guided narration from Gianluca. In fact the Origins of the Online Messier Marathon are connected with 100HA, which was a great project that we had during IYA2009. Now this endeavor is progressing with the initiative taken by AWB with GAM 2010.
In the end we were able to observe 103 Messier objects located all over the sky and of course have fun together.
The Online Messier Marathon started on April 5, staring at 18.00 Universal Time and continuing with the Messier catalogue, classified by the famous French astronomer/ comet-hunter Charles Messier. For me, this was not only my first chance to take part in a messier Marathon, also a platform where I could meet and interact with a lot of fellow astronomy friends/ colleagues from around the globe.
One of the benefits you can have individually, was that you could take real time images, which are really great and informative while running in the marathon. As you click on the dynamic page the picture will be opened in a new tab ready to be saved. As far as I remember we started the marathon from M31 and continued through M110, M52, M103..etc
http://virtualtelescope.bellatrixobservatory.org/mm2010.html : This was the unique URL of this event.
Now I will focus on interesting things happened during the tiresome but enjoyable run. However I will not post more images here but facts. Of course the images will be online soon at Gianluca's Facebook.
Once we were having a short break and afterward the break Gianluca was gifted with w nice artwork done by our Nicaraguan friend Julio Vannini. It resembled waving Gianluca smiling in a background of heavenly bodies, Gianluca was so much thrilled with it and you can also see the image here.
Then Gianluca dedicated a nebula to Julio withing a short while. (Actually I fee I am still living with the Messier Marathon as I'm writing this :) ) Can anyone guess the gift given by Gianluca?... It was Messier 64 (M64, NGC 4826) the famous Black Eye galaxy. (Julio owns a Galaxy now :D)
M64- Black Eye galaxy
We also had a 1-minute silence for the innocent people who were faced with the Earthquake in Italy back in April, 2009. This happened during IYA at the time, when 100HA was concluding and was one of the sad news everybody shared.
Mike Simmons the chair of GAM 2010 and president of AWB also joined the EPIC run amidst his busy schedules and shared the joy of starry nights with One People One Sky slogan.
Global Astronomy Month : Online Messier Marathon
Yet one of the significant features of this long Messier Marathon was that everyone was issued with a certificate of participation, I hope this would be a wonderful souvenir for any astronomy lover. Here is mine.
In addition to this we had loads of fun, with chatbox and Gianluca's accompany...It was just fantastic, you never need to miss such a great one. It's tantalizing.... I also had screen capture recording of the event and will put them youtube soon...
And folks, await the next one, happening less than in 10 hours from now : "Is There Anybody Out There?"
Check out more info here : http://virtualtelescope.bellatrixobservatory.org/itaot2010.html
In the end I thank Gianluca, Mike, and all the AWB/ GAM officials and other supporters who committed their efforts in bringing up this event to such an overwhelming success.
~~~~~~~~~~~~~~Here are some of the Images that I was able to save !!!!~~~~~~~
M13 - Hercules Globular Cluster
M20 - The Trifid Nebula
M84 - A galaxy of the Virgo Cluster of Galaxies
M45 - Elegant Pleiades
M99 - A spiral galaxy in the constellation Coma Berenices
M57 - Ring Nebula
Cassini Scientist for a Day Essay Contest 2010 – S...
Starry Night in Kandy | Another Outreach Event wit...
Received the IYA2009 Commemorative Coin of Ukraine...
Eclipse 11th July 2010 : Photos + Videos + Experie...
Watch Total Solar Eclipse 11th July 2010 Live Stre...
GAM-Global Astronomy Month (GAM2010) - Trailer Lau...
GAM- Is There Anybody Out There ? : Spying the Exo...
GAM-Messier Marathon with 6,500 Runners ! 10 + Hou...


text:
Last edited by Arashilar
Tuesday, July 7, 2020 | History
2 edition of How to select foremen and supervisors found in the catalog.
How to select foremen and supervisors
Richard Charles Oberdahn
by Richard Charles Oberdahn
Published 1944 by National Foremen"s Institute, Inc. in Chicago, Deep River, Conn .
Supervisors, Industrial.,
Personnel management.
Statement by R.C. Oberdahn.
Contributions National Foremen"s Institute.
COVID Resources. Reliable information about the coronavirus (COVID) is available from the World Health Organization (current situation, international travel).Numerous and frequently-updated resource results are available from this 's WebJunction has pulled together information and resources to assist library staff as they consider how to handle coronavirus. The Supervisor's Toolbox was created to support managers and supervisors as a ready reference of proven tools. These are drawn from over thirty years' experience in human resources and organization development. Most are original, yet several are adapted from a range of sources encountered over the years.
Construction Foremen with the Right Stuff are calculating, yet, able to make quick decisions because they are advanced planners, understand the state of their crew and clearly understand how to maximize the team's capabilities to get the job completed effectively. Effective decision makers utilize ground rules for making decisions – call it. Where should a first-time supervisor start? This is the question Joseph F. Duffy sets out to answer in his book Being a Supervisor (Business Books, ). After 45 years as an executive with.
The supervision of anything can be easily made using the help of the evaluation form which can be easily defeated as per the template. Using the help of the form template drafting the evaluation form for the employee becomes easier as one get an idea about how to frame the form and what all things are to be may also see employee evaluation steps. The trackman's helper, a handbook for track foremen, supervisors and engineers. by Joseph Kindelan,Frederick A. (Frederick Augustus) ed Smith,Coates, F. R., joint ed,Sullivan, Jerry, joint ed,Dana, Richard Turner, joint ed,Trimble, Alexander, Foster joint ed. Share your thoughts Complete your review. Tell readers what you thought by rating and reviewing this book.
A just & true love
Dauids repentance, or, A plaine and familiar exposition of the 51. Psalme
The Precincts of Paradise
Lawns.
Three Days with Robert E. Lee at Gettysburg
The Age of Revolution
Three centures of English booktrade bibliography
early Stuarts 1603-1660
Cisco Networking Academy Program Fundamentals of Voice and Data Cabling Lab Companion
Treaty of peace and commerce between the King of Great Britain and the Emperor of Morocco: also treaties of peace and commerce between the King of Great Britain, the Bey and Commander of Tunis, the Dey and Governor of Algiers, and the Bey and Governor of Tripoli. Published by authority
Brush up your Japanese
Super humans
Propulsion Meeting Proceedings Jan. 1988 Los Angeles, Ca (Spie Volume 872)
Energy and chemistry
Jack Nicklaus, the full swing
Byron-Shelley-Keats in memoriam yearly prizes for the best essay in English written by a woman.
How to select foremen and supervisors by Richard Charles Oberdahn Download PDF EPUB FB2
How to select foremen and supervisors. Chicago, Deep River, Conn. National foremen's Institute [] (OCoLC) Document Type: Book: All Authors / Contributors: Richard C Oberdahn; National Foremen's Institute. Yet, few managers and supervisors are prepared to mentor and train the next generation of construction supervisors and foremen.
Most construction supervisors have years of experience on the tools, learning their trade, sometimes through apprenticeships, but mostly learning from others and through experience. Hello Select your address How to correct workers, a working guide for department heads, supervisors and foremen, Paperback – January 1, by Glenn Gardiner (Author) See all formats and editions Hide other formats and editions.
Price New from Used from Author: Glenn Gardiner. The book is centered around the "Clifton Strengths Finder," an online assessment that will help you do just that. (The assessment is based on a Gallup study of 2 million people in a range of Author: Shana Lebowitz.
Relationship between Psychological Health and the Characteristics of Superior Managers, Supervisors, Foremen, etc.
(Notes from Likert) This is a kind of holistic thinking, or organismic thinking in which everything is related to everything else and in which what we have is not like a chain of links or like a chain of cause and effects but rather resembles a spider web or geodesic dome in which.
How to select foremen and supervisors book the candidate with the greatest chance for successful performance in a much tougher assignment – as a supervisor or manager.
You Benefit – And So Do Your Employees Correct decisions have a series of direct payoffs. The employee who is promoted and who can handle the job usually becomes a more stable worker – so job turnover drops. The supervisor signs the form and asks the employee to sign it.
The form and its action plans are reviewed every few months, usually during one-on-one meetings with the employee. Note that if the supervisor has been doing a good job supervising, then nothing should be surprising to the employee during the appraisal.
Supervisor Guide Book Overview Case Study: Becoming a Supervisor Nicole was an outstanding ongoing case manager. She went above and beyond in all of her ongoing case management duties. Nicole worked well with her families and foster parents.
She participated in the implementation of the protective capacity family assessment. She was. Take a page out of any app developer's book of tricks to make good use of money, perks, points, badges and more to reward and recognize great coaching. Just as an example, if a certain group of employees moves into the top quartile, or team performance on a specific metric has greatly improved, reward those supervisors.
The job of supervisor, especially for new supervisors, can be one of the most confusing, frustrating and stressful jobs in an organization.
Many times, a person is promoted to a supervisor role, not because the person has already shown strong skills in supervising people, but because the employee continued to do a high-quality job that was much.
Evaluating Human Relations Programs for Industrial Foremen and Supervisors is an unedited reprinting of Dr. Donald L. Kirkpatrick's doctoral dissertation exactly as it was written in Within it lies the beginning of what is known today as the Kirkpatrick Four Levels.
Foremen Training Program Preface Hanna Consulting Group (HCG) is please to provide comprehensive Foremen Training Program for specialty contractors' sub-foremen, foremen, and superintendent.
We pledge our utmost effort in serving your needs in an efficient, professional and timely manner. We propose 10 modules, four hours per module. National Foremen's Institute: How to prepare an employee's handbook, (New York, ) (page images at HathiTrust) National Foremen's Institute: How to select foremen and supervisors, (Chicago, Deep River, Conn.
[etc.]: National foremen's institute, inc., []), also by Richard C. Oberdahn (page images at HathiTrust; US access only). Evaluating Human Relations Programs for Industrial Foremen and Supervisors is an unedited reprinting of Dr. Donald L. Kirkpatrick's doctoral dissertation exactly as it was written in Within it lies the beginning of what is known today as the four levels of training evaluation.
High Output Management: Dickerson declares himself to be a "huge fan of this book, wish I had read it long before I did.". The Essential Drucker: He's equally enthusiastic about this one, saying.
supervisor with the State of California. The behavioral interview questions included in this guide have been developed to elicit information about a candidate's past experiences that relate to the behaviors (described in the Leadership Competency Model) required to successfully perform as a first-level supervisor in the State of California.
specifically for new managers or supervisors, and the remaining chapters apply to both new and seasoned supervisors. More information on The Supervisory Basics Series can be found at the conclusion of this e-book. Listen to the Supervisory Basics Podcast Series: Tips for Managers and HR Professionals on Helping Individual Contributors Transition.
The Successful Construction Supervisor and Foreman - Kindle edition by Netscher, Paul. Download it once and read it on your Kindle device, PC, phones or tablets. Use features like bookmarks, note taking and highlighting while reading The Successful Construction Supervisor and s: 6.
But these are not the only qualities and skills a manager, leader or decision maker needs to be successful. In this article you can find 11 attributes every great supervisor needs. Personal qualities. Emotional balance: The supervisor works in situations which involve authority, leadership, meeting targets and deadlines, conflicts etc.
The. SUPERVISOR COMMENTS: (Supervisors answered one or both of the following questions: If you had a position available would you hire this intern full-time. Any comments. More experience will help with communication skills, and confidence. (Student) was a delight to work with and I know she will be successful in what ever she does.
Becoming a supervisor is about developing your team. When your team can effectively do the work, then you can attend training, take a vacation or go to a meeting and the department doesn't fall apart.
That's the work of a supervisor. What tips do you have for first-time supervisors? Please share them in the comments. This course will provide information about contract documents and construction law to help supervisors recognize the roles and responsibilities of all contracted parties, to develop an understanding of how contract documents can be helpful to solve problems and resolve conflicts, and to develop positive relationships between all parties in the construction process.New supervisors have demonstrated their proficiency in technical skills in order to be promoted to supervision.
However, as a leader becomes more involved in supervision, the amount of time available for doing technical tasks decreases and the amount of time spent helping others increases. Supervisors eventually find themselves.
poldasulteng.com - How to select foremen and supervisors book © 2020

redpajama_set_name: RedPajamaCommonCrawl


A youth gathering also is planned for Saturday at FountainGate Fellowship.
Abilenians are urged to be a part of the Fill the Well experience Sunday night as a kick off to the weeklong ReviveTX: Big Country citywide event.
The "well" is Shotwell Stadium, so lots of souls will be needed for the event, which starts at 7 p.m. Sponsored by 1-Kingdom, Fill the Well is billed as "a night of citywide unity through worship & prayer," with about 40 participating churches. All are welcome to the free event.
Scott Beard, pastor of FountainGate Fellowship and a leader in 1-Kingdom, said about 10,000 people are expected.
"We're sure hoping for it," he said.
1-Kingdom, an organization of evangelical pastors and civic leaders, also is the local sponsor for ReviveTX: Big Country. The goal of the event is to blanket the city with volunteers ministering to people on the streets for the week. The local event is part of the larger ReviveTX organization, based in Richardson.
A youth gathering is scheduled for 1-5 p.m. Saturday at FountainGate Fellowship, 909 N. Willis St. That event will include lunch, training, organizing into teams, and heading out into the community to pray. Those youths will participate in the Fill the Well worship service Sunday night at Shotwell.
Sunday night's event will include prayer, worship, a message and a time at the end to meet with prayer counselors. Lou Engle, co-founder of The Call ministry based in Colorado Springs, will be guest speaker. Worship music will be provided by Brenton Dowdy, former worship leader at Beltway Park Church, now of Kansas City.
Each day during the week, volunteers with ReviveTX: Big Country will meet at 7:30 a.m. for prayer, worship, and breakfast at New Hope Church, 3122 S. Clack St. Lunch and noontime activities will be at a different church each day. Dinner and an evening service will begin at 5 at New Hope.
In June, two representatives of ReviveTX from Richardson, Wesley Morris and Wade Aaron, me potential sponsors in Abilene. The original ReviveTX event was held in downtown Dallas, with a goal of spreading across Texas.
"Our heart is to train and equip the saints," Morris said.
The plan is to engage people in conversation, with permission, in open spaces such as parks, at bus stops, and by going door to door. People who show an interest will be given a color-coded rubber bracelet and matching New Testament.
The different colors on the bracelets have a scripture chapter and verse number stamped on them. That color corresponds to a colored tab in the Bible, marking the location of the scripture.


A fast title loans is a short term loan secured against your vehicle. The amount you may borrow when taking out a title loans in hancock county is determined by the wholesale value of your vehicle. hancock county title loans does not perform a credit check on applicants, but will verify information with various national databases. Your personal information provided when you applied for the title loans is used in the low cost title loans approval process. hancock county title loans employees conduct themselves in a professional and appropriate manner.
hancock county title loans offers you a convenient and secure way to borrow funds against the equity in your auto with no credit check. hancock county title loans is a company started to help people who needed secured, title loans. How does getting a small title loans work? Is it possible to change the due date for title loans? Our hancock county title loans office receives compliments from customers of all walks of life thanks to our outstanding customer support.
Your car is the collateral for our quick title loans. Our title loans are simpler and faster than home equity loans. You need to first complete our title loans application. If you are unable to make a title loans payment on your scheduled due date, you must contact your hancock county title loans office to set up alternative payment arrangements. hancock county title loans verifies employment and references, but does not disclose the nature of the business because we respect our customers' privacy.


Nottoway Court-House, Va., April 29, 1865.
enemy, who was visible some three-quarters of a mile distant moving up the White Oak road. The enemy's rifle-pits were taken, together with about 1,500 prisoners and several battle-flags. Here a little confusion resulted from the troops exchanging shots with the cavalry who were coming up in front of the enemy's works. After a few moments' delay the line of battle was again changed perpendicularly to the White Oak road and the enemy's works. This change brought the First Division on the left of the Third. The command was then pushed forward along the rifle-pits, capturing prisoners and driving the enemy before it, until it advanced to the Five Forks, where the cavalry and the infantry met, capturing five guns, several caissons, and the Third Brigade, First Division, taking on the Ford road a train of wagons and ambulance belonging to Picket's division. About this point Major-General Sheridan in person directed me to take command of the Fifth Corps and push the enemy down the White Oak road. I immediately directed General Ayres and the other commanders to push forward with all possible dispatch, and the pursuit was kept up until after dark, when the command was halted, the cavalry having pushed to the front out of sight and hearing of the infantry. Soon after this an order was received from the major-general commanding to withdraw the corps some three miles and camp near Gravelly Run Church. The corps went into bivouac about 11 p. m.
On the morning of April 2 the command moved down the White Oak road some two miles and massed near the Dabney house, where it remained until about 11 a. m., when it returned to the Five Forks, and moved across Hatcher's Run on the Ford road, and across the South Side Railroad to the Cox road, driving the enemy's cavalry vedettes before it and campaign at night at the Williamson house at the intersection of Namozine road with the River road. The Third Division, under General Crawford, was detached at this point and directed to co-operate with General Merritt, who was confronting the enemy near the crossing of the Namozine River.
April 3, the command moved along the River road to the Namozine Creek, thence across to the ford taken by the cavalry, bivouacked for the night in the vicinity of Deep Creek. April 4, the command moved at 5 a. m., via Dennisville, and before dark was found in line of battle below Jetersville, with its left extending across the Danville railroad. During the night a line of rifle-pits was constructed in front of the corps. The command remained in this position during the whole of the 5th instant. At 7.40 p. m. April 5 an order was received from the major-general commanding directing me to report for orders to Major-General Meade, commanding the Army of the Potomac.
On the morning of the 2nd, at the Five Forks, between 3,000 and 4,000 stand of arms and several caissons and wagons were destroyed, there being no transportation for them.
I desire to call to the especial attention of the major-general commanding Brevet Major-Generals Ayres and Bartlett, Brigadier-General Chamberlain, and Brevet Brigadier-General Gregory, for their efficiency and promptness in executing my orders and in the management of their commands in the battle of the 1st instant; also Lieutenant-Colonel Richardson, commanding Seventh Wisconsin Veteran Volunteers, who came under my personal observation; he handled his regiment with great ability, and displayed great energy in pushing his command after the enemy.
132 officers. The number picket up on the subsequent days was 944, including 42 officers. A report of flags captured and the names of the captors has already been forwarded with the flags to the headquarters of the Cavalry Corps.
I submit herewith a list, nominal and tabular, of the casualties in my command in the battle of the 1st instant.
Assistant Adjutant-General, Headquarters Cavalry Corps.
NOTE.-The official report from the commanding officer First Division states the number of prisoners taken by the division on the 1st instant to be as follows: First Brigade, 1,050 men, 2 colonels, 6 captains, 11 lieutenants; Second Brigade, 475 men; Third Brigade, 849 men, 3 captains, 5 lieutenants; total, 27 officers and 2,374 men.
Nottoway Court-House, April 29, 1865.
the vicinity of Ligontown Ferry, meeting with no opposing force, save small detachments of cavalry, and capturing about 300 prisoners and many wagons. The distance marched this day was thirty-two miles.
April 7, moved at 5 a. m., in obedience to instructions, for Farmville, via Rice's Store. The head of the column arriving near High Bridge, orders were received, at 9.30 a. m., to pass in rear of the Sixth and Second Corps and move with all possible dispatch to Prince Edward Court-House which point was reached about 7.30 p. m., marching about twenty miles.
Order the Fifth Corps to follow the Twenty-fourth, at 6 a. m., up the Lynchburg road, the Second and Sixth to follow the enemy north of the river.
Striking it at Prospect Station about 12 m., thence following the Twenty-fourth Corps toward Appomattox Court-House, bivouacking the next morning about 2 a. m. within about two miles of the above place, having marched a distance of twenty-nine miles. The march from Prospect Station was very slow and tedious, the road being obstructed by the repeated and long halts of the Twenty-fourth Corps.
April 9, the corps moved at 4 a. m., reaching General Sheridan's headquarters, near Appomattox Court-House, about 6 a. m. Very soon after it was reported that the cavalry were heavily engaged and hard pressed. The Twenty-fourth Corps was moving out when the Second Division, under General Ayres, moved on parallel line rapidly toward the firing. A message was received from General Sheridan, through his aide, Captain Martin, that the enemy was pressing back the cavalry. General Ayres immediately pushed forward his division at a double-quick, and deployed the One hundred and ninetieth and One hundred and ninety-first Pennsylvania Volunteers, under Colonel Pattee, as skirmishers, they being armed with the Spencer rifle, and the rest of the division in two lines of battle. The First Division, under General Bartlett, came up on the right, and formed two lines of battle, with the One hundred and fifty-fifth Pennsylvania, a portion of the One hundred and ninety-eighth Pennsylvania, and the One hundred and eighty-fifth New York Volunteers as a skirmish line. All immediately moved forward and attacked the enemy, pushing him back, and driving both his infantry and artillery from the hills westward through the town, taking a number of prisoners, several wagons, caissons, and limbers. A portion of the skirmish line had entered the town, being strongly supported by our lines of battle, when a message was received from General Sheridan that hostilities would be suspended, as General Lee was about to surrender.
Although a battle was expected at this point, and orders had been carefully given by staff officers for the divisions to keep well closed up, through some unaccountable mistake or neglect on the part of the commander of the Third Division it failed to follow the column, and did not move until an officer had been specially dispatched for it to move up, and did not reach its proper position until after hostilities for the day had ceased.
The number of prisoners captured were, 187 officers, 4,287 enlisted men; total, 4,474.
Too much praise cannot be given both officers and men for the cheerfulness exhibited through the long marches and the many privations and hardships that had to be endured.
I beg to call the especial attention of the major-general commanding to Brevet Major-Generals Ayres and Bartlett and Brigadier-General Chamberlain for their promptness, efficiency, and zealousness in the execution of all orders.
To my staff, both personal and corps, my thanks are due for their patience, alacrity, and cheerfulness in the discharge of all their duties.
A list of casualties, nominal and tabular, has already been forwarded.
Report of casualties in Fifth Army Corps from March 29 to April 9, 1865, both inclusive.
*But see revised table, p. 586.


We offer limo service in Hagerstown MD that cannot be beaten. From our classy vehicles to our suave chauffeurs, everything we have to offer is always top-of-the-line. The most important part of our job is you, so we are ready to take you on any journey that you want to go on. Whether you want us to show up on your wedding day to whisk you and your significant other away to a beautiful honeymoon or you just want us to take you and your mom out for an unforgettable Mother's Day dinner, we are ready to please.
Our limousine service offers the reliability that you can count on. Whether you are just getting off of a plane and want a safe and comfortable riding experience to your hotel room or you want to hire a limousine for the day to take you around town for business meetings, we are here to help. There is no event that we can't handle. You can hire us for a prom night, high school reunion, birthday party, bachelor party, wine tour, or anything else that you can come up with. Our vehicles are all in excellent condition so that you can be the center of attention wherever you go.
There is no need to worry about learning directions and trying to drive yourself around. Instead, you can sit back and relax while you are being chauffeured from place to place like a celebrity. When you choose our limousine service, we want everything to go just right. We want you to have a fun and memorable experience whether you want us to drive around with a group of your friends or you just want to use the back of our vehicle as your mobile office for the day. There are many things that set us apart from our competitors. One of the most substantial advantages that you will receive by choosing us for your limo service is our excellent customer service. Our entire staff looks forward to being helpful and courteous to you. Our skillful chauffeurs will arrive on time and ready to help you enjoy yourself.
Allow us to show you what it feels like to ride in a comfortable and luxurious vehicle. We are ready to provide safe services. We only hire professional chauffeurs who are good at what they do. Book our car service Hagerstown in MD today for a reliable and stress-free experience.


text:
Q: How to know if the value of a column (xlsx) == elements of mylist with python? I have the following list:
mylist = [5093, 5243, 5390, 5753, 5818, 5961, ...]

How to know if the value of a column == elements of mylist and print in mylist elements order:
import openpyxl
doc = openpyxl.load_workbook("file.xlsx")
hoj = doc['Hoj']
for fil in hoj.rows:
    for column in fil:
        if column.value == ELEMENT IN "mylist":
            print(column.value) --> I NEED THAT ORDERED BY MYLIST

sorry for my bad english

A: It would be easy if you use pandas so, after that just use boolean masking:
import pandas as pd
df = pd.read_excel('datafile.xlsx') #dataframe
for elt in my_list: #my_list is the list want to evaluate
    print(df[df[column] == elt]) #boolean masking. Column is the column you want to evaluate

redpajama_set_name: RedPajamaStackExchange


On February 14th, 2012, Coleman Lemieux & Compagnie (CLC) officially opens the Citadel, a newly renovated centre for contemporary dance in Toronto's Regent Park. Located at 304 Parliament St., the former 1912 Salvation Army Citadel has been redesigned by Diamond & Schmitt Architects into a dance centre with a 1,800-square-foot studio/theatre, a 900-square-foot studio, office space for CLC and accommodation for out-of-town artists. The facility is also home to YogaBeat, which hosts pay-what-you-can yoga classes. CLC made its home in the Citadel in 2007 when co-artistic directors (and husband and wife) Bill Coleman and Laurence Lemieux moved the company from Montréal to Toronto. They soon became part of the Regent Park Revitalization Project and launched the Brick by Brick Campaign in 2009 to raise funds for renovations. The opening will include a ribbon-cutting ceremony, celebration and open house from 5pm to 6pm. February 15th through 25th, CLC presents Les cheminements de l'influence (Pathways of Influence), the Citadel's first official performance (although Company Vice Versa unofficially performed Children of the Triangle there in January). The Brick by Brick Campaign to raise funds is ongoing.


Srinagar: Rehbar-e-Taleem teachers Monday accused government of playing cruel joke with them for failing to implement the promised implementation of 7th pay commission and de-linking of their salary from Ministry of Human Resource Development (MHRD).
"We demand regularization of services, time bound promotion, delinking of salaries from MHRD and they should disburse the pending salaries of ReTs," protesting teachers said.
Chairman Jammu and Kashmir Rehbar-e-Taleem Teachers Forum Farooq Ahmad Tantray threatened to launch a sit-in protest in Jammu from December 10 if their demands were not fulfilled at the earliest.
"Its a cruel joke they have played with the teachers community," they said.


text:
Women should be allowed to take abortion pills at home, say doctors
Emily Reynolds
Currently, the law does not allow women to take the abortion pill at home. But a group of top doctors and activists wants that to change.
A group of the world's top doctors has urged the government to allow the abortion pill to be taken at home.
Leading officials from the British Society of Abortion Care Providers, the Royal College of Obstetricians and Gynaecologists and the Faculty of Sexual and Reproductive Healthcare have urged the health secretary to change the law, which currently means women have to take the abortion pill, misoprostol, at a "licensed premises".
But many women experience the side effects of the pill within thirty minutes, meaning they can begin miscarrying on their way home – often on public transport.
Writing in the journal BMJ Sexual and Reproductive Health, the team say that there is "no justification not to act unless the aim is to punish women having a legal abortion".
"This risks the distress of having the abortion while travelling back from the clinic, a trauma that would be entirely preventable if women were allowed to take the drugs at home," they write. "Furthermore, it selectively disadvantages the most vulnerable – those who are deprived, live in rural areas or have dependants."
The Welsh and Scottish governments have already allowed the home use of the pill, with Welsh Health Secretary Vaughn Gething saying that the change offers "additional choice to women requesting an abortion and enables them to complete treatment in an environment where they feel most comfortable".
"It will also reduce the burden currently placed on clinical resources, increase the availability of appointments for women who want to access termination of pregnancy services and enable a greater number of women to access abortion provision at an earlier point in their pregnancy," he said.
The effects of taking the abortion pill at a clinic, rather than at home, is well documented.
Activist Claudia Craig, who is campaigning for a change in the rules, has written extensively about the issue.
Writing for The Independent, Craig said she "collapsed almost as soon as I got inside my home…and then started miscarrying and vomiting on the floor".
"I can't imagine what it would have been like if we had been stuck in traffic for just two minutes longer," she said. "And I was lucky that I could afford a taxi – many women cannot and have to travel home on public transport."
And in an open letter to then-Health Secretary Jeremy Hunt, Craig argued that the home use of pills would have numerous benefits.
"Allowing home use of Misoprostol for abortions would save the NHS money," she writes. "It would relieve some of the strain on overstretched services. It would help women who live in poverty or are experiencing domestic violence to access abortions safely and it would save thousands of women like me from pain and distress."
Images: Getty
Emily Reynolds is a journalist and author based in London. Her first book, A Beginner's Guide to Losing Your Mind, came out in February 2017 with Hodder & Stoughton. She is currently working on her second.


text:
Govt moves to remodel transmission firm, asks Discos to address liquidity challenge
By Emeka Anuforo, Abuja
Babatunde Fashola
Mindful of the myriad of challenges besetting the Transmission Company of Nigeria (TCN), the Minister of Power, Works and Housing, Babatunde Fashola, yesterday hinted of plans to remodel the firm.
He noted that government was working on a modular model for the proposed reform of the transmission grid, stressing that the nation's network must be rejigged to attract more private sector participants.
Also yesterday, Fashola charged distribution companies (Discos) to source for funds with a view addressing the liquidity challenge in the electricity distribution sub-sector of the industry.
To this end, he counselled owners of the power firms to consider some kind of equity sharing with new investors.
Fashola, who spoke when he received a team from the Nigerian Economic Summit Group (NESG) led by its Vice-Chairman, Mrs. Sola David-Borha.
He said power asset owners should be ready to bring in more funds by offering to dilute their stakes in exchange for sorely needed inputs like meters, transformers and other equipment required for systems upgrade, insisting that it would make more business sense to give up some shares in exchange for capital.
The minister noted that the move would make for redistribution of operators' risk assets in exchange for equipment and capacity to drastically reduce the prevailing high occurrences of commercial and technical losses.
He further reminded the power asset owners that the success of the privatisation exercise solely rests on the distribution end in the value-chain, hence the need to step up their collections so as to meet the timelines agreed with government.
Fashola commended the leadership of NESG for expressing its willingness to partner with his ministry in proffering solutions through constant engagements.
Earlier, David-Borha appealed to the minister to assist in the area of enabling legislation that would reduce conflict in the course of implementing projects conceived under private public partnership.
She also asked government to tackle some critical roads that would guarantee traffic flow, which she noted, had been a major concern for investors.


Past week was pretty crazy. No time to elaborate but I want to thank the wonderful individuals who have gifted me with lovely new clothes, a remarkable AC unit, and stunning candle tower from my Amazon Wishlist. Thank you soooooo much!!!! Some challenges have arisen recently but thus far I'm holding my own and look forward to reporting back here with news regarding an ongoing, non work-related project which has captured my heart.
Feel free to e-mail Rainier at info@diablofilms.com for remaining copies of calendar or other classic Wild Goose memorabilia.
Funny how some pics just take me back in time..
Thanks again to the generous souls who made my day with the awesome gifts!! AC unit in particular is helping me stay cool under pressure right now. Hope everyone is having a great weekend.
P.S. Have embarked on another round of shooting but will answer post comments as soon as I can. Many thanks to all of you who have contributed comments. I always enjoy reading them.
I meant to check in sooner but have immersed myself in an endeavor which will keep me busy through the weekend. Earlier tonight I returned home, sat at desk with bowl of Cheerios, saw my cat Santoro gallop through the air like winged cavalry. He seemed to be chasing a bug. A moment later I turned to see him on my bed foaming at the mouth. copious amounts of white liquid pouring over his chin and chest. I ran to him, he ran under the bed. Finally I reached him, grabbed a towel to mop fluid off face and body. He smelled like peppermint. Terrified by surreal episode I found name of 24 hour emergency clinic whose receptionist immediately suggested that I bring him in. Too scared to cry I prayed in the car, holding one hand on steering wheel and other on top of Santoro's carrying case. Even his distressed meows sounded weak and unrecognizable. Then he went silent. Staring out windshield I used right hand to unzip carrier, stroked soft fur til Santoro popped out like Houdini and tried to escape. Relieved by his resilience I wrestled him back into case.
To make long story short emergency vet thinks Santoro ingested something, possibly a bug, which made him temporarily ill. All his vital signs looked good. Vet gave him subcutaneous fluids, anti-nausea medication, and suggested that I feed him a small amount of food at 1am to see how he handled it. She had no explanation for the peppermint smell of substance which had emitted from Santoro's mouth. As we motored home I noticed a neon shamrock winking in the distance. Upon approach Irish tavern looked half empty. I felt like sitting down at the bar and putting Santoro on the stool next to me but we kept driving. Several hours after arriving home Santoro hungrily ate some food and now seems perfectly fine. So grateful.
Btw.. whilst waiting for 1am I took the opportunity to Google "insect that smells like peppermint". Before you decide I'm crazy check this out. Too tired to think more about it now but I will return in 2 hours to ponder issue, move car out of 4am street cleaning zone, and answer post comments which have accumulated in past week. Hope everyone is well. Good night!


In case you aren't aware, a new General Data Protection Regulation has been adopted by the European Union and will be going into effect on May 25, 2018. You'll be forgiven for not being aware because I only found out about it yesterday. Our friends at Bravo Fleet have graciously shared with us the information that they have already put together for their fleet, which I have copied below. Their actual announcement can be found here.
I'll be keeping everyone updated on what's going on. Bravo Fleet will be sharing information with me as well so the fleets can be on the same page with regards to keeping up with the new policies. So be sure to watch this space for more information.
The information contained within this post and the communications with Bravo Fleet on this topic ("Communication") were prepared for informational purposes only. The Communication is not intended to be and should not be considered legal advice. The Communication is provided only as general information and may be incomplete and/or not reflect the most current legal developments. None of the Communication is intended to constitute an attorney-client relationship. You should not act upon any of this Communication without consulting professional legal counsel.
As you may have already heard, the General Data Protection Regulation ("GDPR"), adopted by the European Union in 2016, goes into full effect on May 25, 2018. Between this and the growing concerns over Internet privacy as a whole, Bravo Fleet has decided to offer some general guidance to our players, sims and staff regarding the collection, management and processing of personal information.
Why should you read this? Beyond simply respecting fellow members of this wonderful community because, if you are found in violation, penalties can be as high as €20 million for a website that produces no revenue (like a sim site).
GDPR is a legal framework designed to give individuals greater control over their personal data including not just physical information like names and postal addresses but also digital information like email and IP addresses. Under GDPR, websites must provide privacy policies, cookie policies, easy opt-out, breach notifications and reasonable security precautions, and they are restricted from using personal information for anything outside the stated purpose of why the individual provided it without receiving the individual's explicit consent.
While GDPR technically only protects the rights of EU citizens, it does so globally, whether or not you or your server reside within the EU. As long as an EU citizen can visit your website, you must comply with GDPR. Thus, in the context of Bravo Fleet, we recommend that all sim sites immediately take steps to comply with GDPR.
What about other privacy regulations?
In the process of preparing this recommendation, a legal review was also conducted of other international privacy laws. The recommendations provided forthwith are also intended to comply with the United States Electronic Communications Privacy Act, the Australia Privacy Act, the Canada Personal Information Protection and Electronic Documents Act, the Mexico Law on the Protection of Personal Data Held by Private Parties, the California Online Privacy Protection Act and the California Information Practices Act, among others. All EU privacy regulations besides GDPR have been, or are about to be (before May 25, 2018), deprecated by GDPR, hence why they were not considered separately.
The recommendations herein explicitly do not satisfy the requirements of Russia, Kazakhstan, China, Indonesia and Columbia, and it may not satisfy other regulations that were not directly considered.
What do I need to do to comply with privacy regulations?
The key of Internet privacy is informed consent by the individual.
If you are ever in doubt, measure the action you're about to take against whether you have received consent to take it. For example, when a user signs up for your sim, they give their email address to receive mission post emails and sim announcements. If you email them about something unrelated or you give their email address to someone outside the explicit purpose of your sim, you would be in violation of the GDPR and other international privacy laws.
f. how an individual may request their data removed from your system.
In discussing how you capture and handle data, you should account not just for the data you directly collect when they sign up but also for your server logs and cookies. It you use Google Analytics or another tracking tool, that must also be explicitly disclosed, along with the purpose of such tools.
2. "Your California Privacy Rights" Page - Your website should include a page entitled "Your California Privacy Rights" with the following text (substituting in place of the placeholders): "If you are a California resident, California Civil Code Section 1798.83 permits you to request information regarding the disclosure of your personal information by [INSERT: ORGANIZATION] to third parties for the third parties' direct marketing purposes. To make such a request, please [INSERT: CONTACT INSTRUCTIONS]."
c. use strong passwords for your database and any account that can access others' information.
4. No Implied Consent - Your website should not pre-check any checkboxes regarding agreeing to terms or allowing the release of an individual's information. Nova and most forum and blog software already handle this correctly by listing terms and asking the user to press an "Agree" button.
6. Age of Consent - Because age of consent varies by country (even in the GDPR), rather than sorting through the varying laws for every applicant, we recommend adding to your sign up terms a statement such as "I affirm that I have the full right and authority to enter into this Agreement, including that I am of the age of majority in [INSERT: WEB HOST COUNTRY] and my own country." You may also include a clause allowing a parent or guardian to enter into the Agreement on behalf of the Individual. This is completely separate from your sim age rating.
8. IP Tracking - Do not store an individual's IP address (beyond your access logs, which should be deleted regularly), nor place third-party code or embeds on your site that track a user's activity. If you intend to do this, you will need to look into additional rules about this (beyond the scope of our recommendation).
9. Advertising and Marketing - Do not use an individual's personal information for any purpose other than simming (not even a simple email about something else), and do not provide an individual's personal information to any third party (no ads, marketing or lead generation tools). If you intend to do any of these things, you will need to look into additional rules about this (beyond the scope of our recommendation).
10. Data Breach Notification - If you suffer a data breach, you should notify all individuals with personal information that was compromised immediately. You should also consult individual privacy laws regarding additional requirements (beyond the scope of our recommendation).
By what date do I need to comply?
Although we recommend you comply as soon as possible, because some of these recommendations stem from other laws, we recommend all sim sites come into compliance no later than May 24, 2018 in order to meet the deadline for GDPR enforceability.
Is there any help available to comply?
Additionally, Bravo Fleet is currently working with Anodyne Productions to see if we can release an update to Nova including the ability for users to delete their own accounts in order to better comply with the easy opt-out provision of GDPR.
Questions or concerns may be directed to JonM and the Bravo Fleet Command Council, although remember we are no replacement for the advice of a legal professional.
avoid tracking IP addresses or other identifying features of your users.
Bravo Fleet will be providing sample policies by May 14, 2018.


text:
Q: Examine query inside postgres function I would like to use a query result as a condition on what action to perform inside a postgres function. Here is my attempt:
CREATE OR REPLACE FUNCTION upsert_bin_effect(operation_id integer, typ text, asset_id integer, qty double precision) RETURNS boolean AS $$
BEGIN
    existing_locked := (SELECT SUM(qty) AS qty INTO existing FROM bin_effect be WHERE be.operation_id = operation_id AND be.type = typ AND be.asset_id = asset_id AND be.locked = true GROUP BY be.operation_id, be.type, be.asset_id);
    qty = qty - existing.locked.qty

    existing_unlocked := (SELECT * INTO existing FROM bin_effect be WHERE be.operation_id = operation_id AND be.type = typ AND be.asset_id = asset_id AND (be.locked = false OR be.locked IS NULL));
    IF EXISTS(existing_unlocked)
    THEN
        UPDATE bin_effect be SET be.qty = qty WHERE be.id = existing_unlocked.id
    ELSE
        INSERT INTO bin_effect be (be.operation_id, be."type", be.asset_id, be.qty) VALUES (operation_id, typ, asset_id, qty);
    END IF;

END;
$$ LANGUAGE plpgsql;

existing_locked can have multiple rows, I'd like to subtract the sum of existing_locked.qty from the incoming qty. Then, update the record that is not locked (i.e. in existing_unlocked), if it exists, with the net qty - otherwise insert a new row with the net qty.
If we assume there is a table with the following data:
operation_id, type, asset_id, qty, locked
1, 'A', 1, 10, true
1, 'A', 1, 20, true
1, 'A', 2, 5, true
1, 'A', 2, 15, null

The following call:
upsert_bin_effect(1, 'A', 1, 100)

should result in:
operation_id, type, asset_id, qty, locked
1, 'A', 1, 10, true
1, 'A', 1, 20, true
1, 'A', 2, 5, true
1, 'A', 2, 15, null
1, 'A', 1, 70, null

The following call:
upsert_bin_effect(1, 'A', 2, 100)

should result in:
operation_id, type, asset_id, qty, locked
1, 'A', 1, 10, true
1, 'A', 1, 20, true
1, 'A', 2, 5, true
1, 'A', 2, 95, null

The following call:
upsert_bin_effect(1, 'A', 3, 100)

should result in:
operation_id, type, asset_id, qty, locked
1, 'A', 1, 10, true
1, 'A', 1, 20, true
1, 'A', 2, 5, true
1, 'A', 2, 95, null
1, 'A', 3, 100, null

To better describe how I'd like this function to work here is some javascript pseudocode which implements the desired functionality:
// these are mock result sets, assume they were queried where operation_id, type, asset_id are equal and locked is true/falsy respectively.
const existingLocked = [];
const existingUnlocked = [];

function upsert_bin_effect(operationId, typ, assetId, qty) {
    const lockedQty = existingLocked.reduce((sum, r) => sum + r.qty, 0);

  // incoming qty represents the total qty. lockedQty represents qty for locked rows (rows we cannot update)
  // If there is nonzero lockedQty, we subtract it from qty because when we upsert qty
  // we need to ensure that all rows qty will sum to the incoming qty.
  qty = qty - lockedQty;

  // existingUnlocked should only ever contain a single row (because of the upsert logic below)
  if (!!existingUnlocked[0]) {
    // if there is an existing unlocked row, update it with the (incoming qty - any locked qty)
    existingUnlocked[0].update('qty', qty);
  }
  else {
    // otherwise insert a new row with qty = (incoming qty - any locked qty)
    db.binEffect.insert(operationId, typ, assetId, qty)
  }
}

I am pretty new to sql function programming. Does this make sense? If not, how can I accomplish what I am trying to do?

A: There several issues with this function before you get to what you want:
DECLARE existing RESULT

--There is no RESULT type and you do end with ; So:

DECLARE existing RECORD;

existing_locked is not declared so assignment to it will fail.
Same for existing_unlocked.
qty = qty - existing.locked.qty does not end with a ;
I would spend some time here:
https://www.postgresql.org/docs/12/plpgsql-structure.html
From your comment below I'm not seeing that the new examples match what you say you want:
operation_id, type, asset_id, qty, locked
1, 'A', 1, 10, true
1, 'A', 1, 20, true
1, 'A', 2, 5, true
1, 'A', 2, 15, null
1, 'A', 1, 70, null

--The following call:

upsert_bin_effect(1, 'A', 2, 100)

--should result in:

operation_id, type, asset_id, qty, locked
1, 'A', 1, 10, true
1, 'A', 1, 20, true
1, 'A', 2, 5, true
1, 'A', 2, 95, null

"existing can have multiple rows, I'd like to subtract the sum of existing.qty from the incoming qty for any locked rows. Then, update any record that is not locked with the incoming qty if an unlocked row exists, otherwise insert a new one."
I would have thought the result would be:
operation_id, type, asset_id, qty, locked
1, 'A', 1, 10, true
1, 'A', 1, 20, true
1, 'A', 2, 5, true
1, 'A', 2, 115, null

UPDATE
A stab at what I think you want. Obviously not tested, but it should be a reasonable starting point.
CREATE OR REPLACE FUNCTION upsert_bin_effect(operation_id integer, typ text, asset_id integer, qty double precision) RETURNS boolean AS $$
DECLARE
    existing_locked RECORD;
    existing_unlocked RECORD;
    net_qty float;
    unlocked_ct integer;

BEGIN
    existing_locked := (SELECT SUM(qty) AS qty INTO existing FROM bin_effect be WHERE be.operation_id = operation_id AND be.type = typ AND be.asset_id = asset_id AND be.locked = true GROUP BY be.operation_id, be.type, be.asset_id);
    net_qty = qty - existing.locked.qty;

    existing_unlocked := (SELECT * INTO existing FROM bin_effect be WHERE be.operation_id = operation_id AND be.type = typ AND be.asset_id = asset_id AND (be.locked = false OR be.locked IS NULL));
GET DIAGNOSTICS unlocked_ct = ROW_COUNT;
    IF EXISTS(existing_unlocked)
    THEN
        IF unlocked_ct = 1 THEN
           UPDATE bin_effect be SET be.qty = net_qty WHERE be.id = existing_unlocked.id;
        ELSEIF unlocked_ct > 1
            --Not sure if you want this to happen, included as example.
            RAISE EXCEPTION 'Too many unlocked row';
        END IF;
    ELSE
        INSERT INTO bin_effect be (be.operation_id, be."type", be.asset_id, be.qty) VALUES (operation_id, typ, asset_id, qty);
    END IF;

END;
$$ LANGUAGE plpgsql;

A: Let me just preface this by saying, this could be a bit of an XY problem. Postgres has mechanism for locking rows in a transaction, but without having to modify them. This means other transactions cannot update them, but may still be able to read their pre-locked state. This is known as SELECT FOR UPDATE. So your upsert_bin_effect could read the locked rows, but would not be able to modify them.
If you create a unique index on unlocked rows, then you can do this in a single query, using INSERT ... ON CONFLICT UPDATE. Given this example schema:
create table bin_effect (
    operation_id integer not null,
    typ text not null,
    asset_id integer not null,
    qty double precision not null,
    locked boolean not null
    -- don't understand why you were using null to indicated that the row was not locked
);

-- create a partial unique index that guarantees at most one unlocked row per "key"
create unique index bin_effect_unqiue_unlocked
    on bin_effect (operation_id, typ, asset_id) where not locked;

Then given a table initialised from the following insert:
insert into bin_effect values
    (1, 'A', 1, 10, true),
    (1, 'A', 1, 20, true),
    (1, 'A', 2, 5, true),
    (1, 'A', 2, 15, false);

Then the following query will insert an unlocked row or update the unlocked row for the given operation_id, typ and asset_id. You can then either use this query as a parameterised query in either directly or as part of a stored function. NB. This is a raw query for operation_id = 1, typ = 'A', asset_id = 1 and a new quantity of 100.
-- pre-calculate the desired qty, so we only compute it once
with new_value as (
    select
        -- use coalesce for when there no matching rows in table (locked or otherwise)
        100 - coalesce(sum(qty), 0) as qty
    from bin_effect
    where
        operation_id = 1
        and typ = 'A'
        and asset_id = 1
        and locked
)
-- try to insert a new row
insert into bin_effect (operation_id, typ, asset_id, locked, qty)
    values
        (1, 'A', 1, false, (select qty from new_value))
    -- if the insertion fails, then update the pre-existing row
    on conflict (operation_id, typ, asset_id) where not locked
        do update set qty = (select qty from new_value)
;

As a stored function:
create or replace function upsert_bin_effect(operation_id_ integer, typ_ text, asset_id_ integer, new_qty double precision)
returns double precision as $$
    with new_value as (
        select
            new_qty - coalesce(sum(qty), 0) as qty
        from bin_effect
        where
            operation_id = operation_id_
            and typ = typ_
            and asset_id = asset_id_
            and locked
    )
    insert into bin_effect (operation_id, typ, asset_id, locked, qty)
        values
            (operation_id_, typ_, asset_id_, false, (select qty from new_value))
        on conflict (operation_id, typ, asset_id) where not locked
            do update set qty = (select qty from new_value)
        returning qty
    ;
$$
language sql;

Example usage and output:
postgres=# select upsert_bin_effect(1, 'A', 1, 100);
 upsert_bin_effect
-------------------
                70
(1 row)

postgres=# select upsert_bin_effect(1, 'A', 2, 100);
 upsert_bin_effect
-------------------
                95
(1 row)

postgres=# select upsert_bin_effect(1, 'A', 3, 100);
 upsert_bin_effect
-------------------
               100
(1 row)

postgres=# table bin_effect;
 operation_id | typ | asset_id | qty | locked
--------------+-----+----------+-----+--------
            1 | A   |        1 |  10 | t
            1 | A   |        1 |  20 | t
            1 | A   |        2 |   5 | t
            1 | A   |        1 |  70 | f
            1 | A   |        2 |  95 | f
            1 | A   |        3 | 100 | f
(6 rows)


Find comfort at this 2 bedroom 2 bathrooms unit facing east. Just seconds away from the water and mtns to the warm welcoming village. Recently updated with new flooring and new painting, this well maintained building is close to parks, shops, restaurants plus guest suite in building. Recreation facilities include gym, pool table and library. All measurements approx, the buyer to verify if necessary.


Maurice, 4th and last Baron Egerton of Tatton, was an innovator and a man of great inventive and technical skill. A pioneer aviator, photographer and filmmaker, he was an early motorist and prodigious traveller.
A shy and somewhat solitary figure, his great legacy was to leave the Tatton estate to the National Trust for the benefit and enjoyment of others.
He was a great supporter of local youth and founded the Egerton Boys Club to encourage the Knutsford youngsters to play sport and be involved in health-giving physical activity in the great outdoors.
Maurice Egerton spent a considerable portion of his time on his Kenyan estate, which is where he died in 1958.
Visitors to the estate can learn more about this fascinating man in the Maurice Egerton Exhibition Room.


"Pamphlet Nurses Guild Anniversary 50th; 2002-07-28." Anniversary Papers. Pilgrim Missionary Baptist Church Collection. Monroe Fordham Regional History Center, Archives & Special Collections Department, E. H. Butler Library, SUNY Buffalo State.


In Ancient Egypt the iconography on the walls of the tombs were crucial for the dead's resurrection.
The iconography in the tomb of Tutankhamun was strong enough for granting the king's regeneration. Both, the scenes and its emplacement had a sense.
Orientation of the Tutankhamun iconography.
The ancient Egyptian artists selected for this king a group of images which evoked the first moment of Tutankhamun's regeneration. So, his entrance into the Hereafter granted his resurrection, and therefore, his eternity.
But also the artists selected the emplacement for each image.
The orientation of the Iconography in the Tomb of Tutankhamun..
If we observe carefully the decorative ensemble we note two main parts: the east side and the west side.


text:
Kamilla Kowal Weight Loss: How Much Weight Did She Loose?
Kamilla Kowal is one of the newest stars in the entertainment business, but she is just setting foot in the industry as a promising new actress from Canada.
In addition to her work on sitcoms such as Letterkenny, The New Romantic, and Nowhere, she is also known for her remarkable contributions to other movies.
Aside from being a model, she was also the winner of the Canadian beauty pageant known as Miss Greater Sudbury and held the title for two years.
Kamilla Kowal Early Life
She is a Canadian-born actress and model and was born in the year 1993, making her one of the youngest in her generation. As far as her ethnicity is concerned, she is of mixed racial descent, which means that she belongs to three distinct groups: Central European, Romanian, and Polish.
As far as her parents and siblings are concerned, there is not much information about them. There is so much secrecy surrounding Kowal that it is impossible to find out where they are or their names.
In her early years, Kamilla Kowal spent most of her time with her relatives and the rest of her siblings in Canada. She had a pretty decent childhood, and most of her needs were met easily during that time.
The only thing we know for sure about her academic background is that she attended St. Benedict Catholic Secondary School during her high school years.
In the year 2009, she started attending acting classes at a Canadian agency called Charm Plus, which specializes in acting classes for women.
Kamilla Kowal Weight Loss
During the filming of Bonnie McMurray, the actress Kamilla Kowal lost a lot of weight, a process that shocked the viewers since how could someone lose so much weight within so short a period of time?
Kamilla Kowal has lost a considerable amount of weight since her weight loss did not have to be healthy since she was already lean and fit. She did not need to lose any more weight.
Consequently, the situation did not look very good at all, and it spooked some viewers, who immediately began to worry about her health.
There was something right about the way she looked in Letterkenny before, as opposed to how she looks now, which seems sickly thin compared to how she looked in Letterkenny before.
Despite the fact that she was never known for her figure in the past, after this weight loss, fans realized that she had a toned body back when she was younger.
Taking a closer look at the actress from the Web of Lies, she appears to be a pile of bones now, a sign that she is in very bad health.
When fans asked why she had changed so much and had lost such a large amount of weight, she reportedly cited her advancing age as the reason for her change.
People were left scratching their heads after Kamilla Kowal weight loss, and the response she received was even more puzzling. Her new look was well-received by some of her fans.
Many people thought that she looked like a fitness freak going all the way out. Thus Kamilla Kowal weight loss has been rolling over the internet.
Kamilla Kowal Net Worth
Kowall, as of 2022, has a net worth of $300,000, which is mostly the result of her acting career, which has earned her most of her money.
A number of work activities led to Kamilla's impressive net worth, such as acting, modeling, advertising campaigns, and endorsements.
In addition to being kept in the dark about her life, her wealth is also kept secret, including her car, house, and other valuable assets. Kamilla seems to enjoy spending time with her friends in her spare time, judging by the photos she uploads to her Instagram account.
It's worth noting that Kamilla has also starred in a variety of movies, including The New Romantic (2018) and American Hangman (2019).
It is no secret that she has a lot of popularity among the public as well as on social media. She is undoubtedly a social media influencer since she has over 175k followers on Instagram, where she typically uploads the most beautiful and stunning images that she captures.
Stephanie Boswell Plastic Surgery: What Kind Of Procedure Has She Undergone?
Carly Simon Plastic Surgery: What Kind Of Treatment She Has Done?