text:
Q: Get Row Additions/Deletions from same MySQL table I have the following employee table and I want to know who left/joined the company based on the "Month", "Quarter" and "Year" as per the output shown below.
From the data we can see that Olivia left the company in Q1 of 2017 and Geogia and Grace joined the company in Q2 of 2017
Employee DB Table
| Month | Quarter | Year | Company | Company Description | Employee ID | Employee Name | Country Description |
| M1    | Q1      | 17   | 020     | US                  | 03237       | Jessica       | UNITED STATES       |
| M1    | Q1      | 17   | 020     | US                  | 05153       | Olivia        | UNITED STATES       |
| M1    | Q1      | 17   | 020     | US                  | 06809       | Hannah        | UNITED STATES       |
| M1    | Q2      | 17   | 020     | US                  | 03237       | Jessica       | UNITED STATES       |
| M1    | Q2      | 17   | 020     | US                  | 0680        | Hannah        | UNITED STATES       |
| M1    | Q2      | 17   | 020     | US                  | 08434       | Georgia       | UNITED STATES       |
| M1    | Q2      | 17   | 020     | US                  | 08858       | Grace         | UNITED STATES       |

Desired Output
| Month | Quarter | Year | Company | Company Description | Employee ID | Employee Name | Country Description | Status |
| M1    | Q1      |   17 |     020 | US                  |       03237 | Olivia        | UNITED STATES       | Out    |
| M1    | Q2      |   17 |     020 | US                  |       08434 | Georgia       | UNITED STATES       | In     |
| M1    | Q2      |   17 |     020 | US                  |       08858 | Grace         | UNITED STATES       | In     |

I'm trying to use the following statement but I'm stuck
SELECT  t.month,
        t.quarter,
        t.year,
        t.employee_id,
       t.employee_name

FROM q4_16_hc AS t
JOIN q4_16_hc AS t1
  ON t1.employee_id = t.employee_id
WHERE t.month <> t1.month
group by t.employee_id

A: You would normally do this using a full join. As MySQL doesn't support it, you should do a union all with a left join and right join.
--Employees who left from previous quarter
SELECT t1.month,
    t1.quarter,
    t1.year,
    t1.employee_id,
    t1.employee_name,
    'Out' as status
FROM q4_16_hc AS t1
LEFT JOIN q4_16_hc AS t2 ON t1.employee_id = t2.employee_id AND t1.year = t2.year
AND t1.Company=t2.Company AND t1.quarter='Q1' AND t2.quarter = 'Q2'
WHERE t2.employee_id is null
UNION ALL
--Employees who newly joined
SELECT t2.month,
    t2.quarter,
    t2.year,
    t2.employee_id,
    t2.employee_name,
    'In'
FROM q4_16_hc AS t1
RIGHT JOIN q4_16_hc AS t2 ON t1.employee_id = t2.employee_id AND t1.year = t2.year
AND t1.Company=t2.Company AND t1.quarter='Q1' AND t2.quarter = 'Q2'
WHERE t1.employee_id is null

A: This comes very close to what you want:
select x.*
from ((select t.employee_id, t.employee_name,
              min(concat_ws(':', year, quarter, month)) as yqm,
              'in' as which
       from q4_16_hc t
       group by t.employee_id, t.employee_name
      ) union all
      (select t.employee_id, t.employee_name,
              max(concat_ws(':', year, quarter, month)) as yqm,
              'out' as which
       from q4_16_hc t
       group by t.employee_id, t.employee_name
      )
     ) x;

You can use substring_index() or substr() to extract the year, quarter, and month if you really need those in separate columns.


text:
Previous (Albert Schweitzer)
Next (Alberta)
First Architect of the Third Reich
Minister for Armaments
Berthold Konrad Hermann Albert Speer, commonly known as Albert Speer (March 19, 1905 – September 1, 1981), was an architect, author and high-ranking Nazi German government official, sometimes called "the first architect of the Third Reich."
1 Early years
2 First architect of the Reich
3 Minister of Armaments
4 After the war
4.1 Nuremberg trials
4.2 Imprisonment
4.3 Release and later life
Speer was Hitler's chief architect before becoming his Minister for Armaments during the war. He reformed Germany's war production to the extent that it continued to increase for over a year despite ever more intensive Allied bombing. After the war, he was tried at Nuremberg and was sentenced to 20 years' imprisonment for his role in the Third Reich. As "the Nazi who said sorry,"[1] he was the only senior Nazi figure to admit guilt and express remorse. Following his release in 1966, he became an author, writing two bestselling autobiographical works, and a third about the Third Reich. His two autobiographical works, Inside the Third Reich and Spandau: the Secret Diaries detailed his often close personal relationship with German dictator Adolf Hitler, and have provided readers and historians with an unequaled personal view inside the workings of the Third Reich. Speer died of natural causes in 1981, in London, England.
Speer was born in Mannheim, Germany, the second of three sons of Albert and Lina Speer. Although Speer became an architect, he originally wanted to become a mathematician when he was young. Instead, he followed in the footsteps of his father and grandfather and studied architecture. He began his architectural studies at the Karlsruhe Institute of Technology; his decision to study locally instead of at one of the more prestigious institutes was dictated by the inflation of 1923. In 1924, when the inflation had stabilized, Speer transferred his studies to the more esteemed Technical University of Munich. In 1925, he transferred again, this time to the Berlin Institute of Technology. It was there that he was under the tutelage of Heinrich Tessenow. Speer had a high regard for Tessenow and when he passed his exams in 1927 he became Tessenow's assistant. His duties as assistant involved teaching seminar classes three days a week. Although Tessenow himself never agreed with Nazism, a number of his students did, and it was they who persuaded Speer to attend a Nazi Party rally in a Berlin beer-hall in December 1930.
Speer claims to have been apolitical as a young man; nevertheless, he did attend the rally. He was surprised to find Hitler dressed in a neat blue suit, rather than the brown uniform seen on Nazi Party posters. Speer claimed to have been quite affected, not only with Hitler's proposed solutions to the threat of Communism and his renunciation of the Treaty of Versailles, but also with the man himself. Several weeks later he attended another rally, though this one was presided over by Joseph Goebbels. Speer was disturbed by the way he had whipped the crowd into a frenzy, playing on their hopes. Although Goebbels' performance offended Speer, he could not shake the impressions Hitler made on him. The next day he joined the Nazi Party as member number 474,481.
In the summer of 1922, he got to know Margarete "Margret" Weber from Heidelberg (1905-1987). They married in Berlin on August 28, 1928, despite the fact that Speer's mother was against this relationship. Between 1934 and 1942, Margret gave birth to six children: Albert, Hilde, Fritz, Margarete, Arnold, and Ernst.
Speer's first major commission as a Party member came in 1932 when Karl Hanke (on whose villa Speer previously worked) recommended him to Goebbels to help renovate the new District Headquarters in Berlin, and, later, to renovate Goebbels' Propaganda Ministry. Goebbels was impressed with his work and recommended him to Hitler, who assigned him to help Paul Troost renovate the Chancellery in Berlin. Speer's most notable work on this assignment was the addition of the famous balcony from which Hitler often presented himself to crowds that assembled below. Speer subsequently became a prominent member of Hitler's inner circle and a very close friend to him, winning a special place with Hitler that was unique amongst the Nazi leadership. Hitler, according to Speer, was very contemptuous towards anybody he viewed as part of the bureaucracy, and prized fellow artists like Speer whom he felt a certain kinship with, especially as Hitler himself had previously entertained architectural ambitions.
First architect of the Reich
Zeppelinfeld
When Troost died in 1934, Speer was chosen to replace him as the Party's chief architect. One of his first commissions after promotion was perhaps the most familiar of his designs: The Zeppelintribüne, the Nuremberg parade grounds seen in Leni Riefenstahl's propaganda masterpiece, Triumph of the Will. In his autobiography, Speer claimed that, upon seeing the original design, he made a derogatory remark to the effect that the parade ground would resemble a "rifle club" meet. He was then challenged to create a new design.
The grounds were based on ancient Doric architecture of the Pergamon Altar in Anatolia, but magnified to an enormous scale, capable of holding two hundred and forty thousand people. At the 1934 Party rally on the parade grounds, Speer surrounded the site with one hundred and thirty anti-aircraft searchlights. This created the effect of a "Cathedral of Light," (which referenced columns) or, as it was called by British Ambassador Sir Neville Henderson, a "cathedral of ice." Speer later described this as his greatest work.
Nuremberg was also to be the site of many more official Nazi buildings, most of which were never built; for example, the German Stadium would have held another four hundred thousand spectators as the site of the Aryan Games, a proposed replacement for the Olympic Games. While planning these buildings, Speer invented the theory of "ruin value." According to this theory, enthusiastically supported by Hitler, all new buildings would be constructed in such a way that they would leave aesthetically pleasing ruins thousands of years in the future. Such ruins would be a testament to the greatness of the Third Reich, just as ancient Greek or Roman ruins were symbols of the greatness of their civilizations. In practice, this theory manifested itself in his marked preference for monumental stone construction, rather than the use of steel frames and ferroconcrete.
In 1937 Speer designed the German Pavilion for the 1937 international exposition in Paris. Speer's work was located directly across from the Soviet Pavilion and was designed to represent a massive defense against the onslaught of Communism. Both pavilions were awarded gold medals for their designs.
Speer was also directed to make plans to rebuild Berlin, which was to become the capital of a "Greater Germany"—Welthauptstadt Germania. The first step in these plans was the Olympic Stadium for the 1936 Summer Olympics, designed by Werner March. Speer also designed the new Reich Chancellery, which included a vast hall designed to be twice as long as the Hall of Mirrors in the Palace of Versailles. Hitler wanted him to build a third, even larger Chancellery, although it was never begun. The second Chancellery was damaged by the Battle of Berlin in 1945 and was eventually demolished by the Soviet occupiers after the war.
Almost none of the other buildings planned for Berlin were ever built. Berlin was to be reorganized along a central three-mile-(five km) long avenue. At the north end, Speer planned to build the Volkshalle—an enormous domed building, based on St. Peter's Basilica in Rome. The dome of the building would have been impractically large; it would be over seven hundred feet (over two hundred meters) high and eight hundred feet (three hundred meters) in diameter, seventeen times larger than the dome of St. Peter's. At the southern end of the avenue would be an arch based on the Arc de Triomphe in Paris, but again, much larger; it would be almost four hundred feet (120 m) high, and the Arc de Triomphe would have been able to fit inside its opening. The outbreak of World War II, in 1939, led to the abandonment of these plans.
Part of the land for the boulevard was to be found by building two major railway stations, one just north and one just south of the boulevard. This would free up many of the tracks in between. However, according to Speer in The Spandau Diaries, 80,000 buildings would have to be destroyed to complete his plans.
While the north-south axis was not completed, an east-west axis, focused upon the Brandenburg Gate was completed and remains in Berlin today. While none of the buildings designed by Speer during the Nazi era still stand in Berlin, some lampposts still do.
It has been alleged that Speer was responsible for the forced evictions of Jews from their houses to make room for his grand plans, and for re-housing only Aryans affected by this work. These allegations are, however, disputed. He was also listed as present at the 1943 Posen Conference, a charge Speer later contested by saying that he had in fact left early.
Speer did have an architectural rival: Hermann Giesler, whom Hitler also favored. There were frequent clashes between the two in regard to architectural matters and in closeness to Hitler.
Minister of Armaments
Hitler was always a strong supporter of Speer, in part because of Hitler's own frustrated artistic and architectural visions. A strong affinity developed between Hitler and the ambitious young architect early in their professional relationship. For Speer, serving as architect for the head of the German state and being given virtual carte blanche as to expenses, presented a tremendous opportunity. For Hitler, Speer seemed to be capable of translating Hitler's grandiose visions into tangible designs which expressed what Hitler felt were National Socialist principles.
After Minister of Armaments and War Production Fritz Todt was killed in a plane crash in 1942, Hitler appointed Speer as his successor in all of his posts. Hitler's affinity for Speer and the architect's efficiency and avoidance of party squabbling are believed to have been considerations in Speer's promotion. In his autobiography, Speer recounts that the power-hungry but lazy Hermann Göring raced to Hitler's headquarters upon word of Todt's death, hoping to claim the office. Hitler instead presented Göring with the fait accompli of Speer's appointment.
Faced with this new responsibility, Speer tried to put the German economy on a war footing comparable to that of the Allied nations, but found himself incessantly hindered by party politics and lack of cooperation from the Nazi hierarchy. Nevertheless, by slowly centralizing almost all industry control and cutting through the dense bureaucracy, he succeeded in multiplying war production four times over the next two and a half years, and it reached its peak in 1944, during the height of the Allied strategic bombing campaign. Another big hurdle in his way was the Nazi policy of excluding women from factory work, a serious hindrance in war production and a problem not experienced by Germany's enemies, all of whom made use of the female workforce. To fill this gap, Speer made heavy use of foreign labor as well as forced labor, the latter mainly from the various types of prisoners in the Third Reich.
Speer was considered one of the more "rational" members of the Nazi hierarchy, in contrast with Hitler, Göring, Goebbels, and Himmler. Speer's name was found on the list of members of a post-Hitler government envisioned by the conspirators behind the 1944 July 20 plot to kill Hitler. However, the list had a question mark and the annotation "if possible" by his name, which Speer credits with helping save his life from the extensive purges that followed the scheme's failure. By his own account, Speer considered assassinating Hitler in 1945 by releasing poison gas into the air intake vent on the Führerbunker, but the plan, such as it was, was frustrated for a number of reasons. Independent evidence for this is sparse. Some credit his revelation of this plan at the Nuremberg trials as being pivotal in sparing him the death sentence, which the Soviets had pushed for.
On January 13, Speer gave a presentation to army corps commanders in a camp near Berlin. According to Speer, Allied bombing was not the biggest problem for German industry. He pointed out that German industry had produced 218,000 rifles in December 1944 alone, nearly double the monthly average in 1941. The production of automatic weapons was up by four times and tank production was up by nearly five times. In addition, the tanks produced were much heavier.[2]
Speer talked for over forty minutes reeling off production statistics. German industry's problem, according to Speer, was Germany's shortage of fuel. Speer did not mention to the corps commanders anything about the shortage of ammunition or the growing reliance on slave labor.[3]
Hitler continued to consider Speer trustworthy, though this trust waned near the war's end as Speer, at considerable risk, campaigned clandestinely to prevent the implementation of Hitler's Nero Decree. The Nero Decree was issued on 19 March and it promoted a scorched earth policy on both German soil and occupied territories. Speer worked in association with General Gotthard Heinrici, whose troops fighting in the east retreated to the American-held lines and surrendered there instead of following Hitler's orders to make what would have been a suicidal effort to hold off the Soviets from Berlin.
Speer even confessed to Hitler shortly before the dictator's suicide that he had disobeyed, and indeed actively hindered Hitler's "scorched earth" decree. According to Speer's autobiography, Speer visited the Führerbunker towards the end and stated gently but bluntly to Hitler that the war was lost and expressed his opposition to the systematic destruction of Germany while reaffirming his affection and faith in Hitler. This conversation, it is said, brought Hitler to tears. On 23 April, Speer left the Führerbunker. Now in disfavor, on April 29, Speer was excluded from the new cabinet Hitler outlined in his final political testament. This document specified that Speer was to be replaced by his subordinate, Karl-Otto Saur.
Nuremberg trials
Immediately after the war, there seemed to be little indication that Speer would be charged with war crimes. Speer travelled unprotected and openly participated in the so-called Flensburg government for weeks, in the presence of Allied officers. Upon request, he held a series of widely-attended lectures for officials of the Allied occupying powers on various topics, including mistakes made by the Nazi government in industrial and economic affairs (though he never spoke about slave labor) and the effectiveness of the Allied strategic bombing campaigns. Some journalists and spectators even expected Speer to be appointed by the occupying powers to help restore Germany's economy. He was taken to Versailles, to General Dwight D. Eisenhower's then-headquarters. However, any such speculation ended when he was arrested and sent to Nuremberg for trial.
At the Nuremberg Trials, Speer was one of the few officials to express remorse. He was sentenced to 20 years' imprisonment, most of which he would serve at Spandau Prison, West Berlin, largely for his use of slave labor.
According to interviews after his imprisonment, as well as his memoirs, Speer adopted a "see no evil" attitude towards the Nazi atrocities. For example, through his friend Karl Hanke he learned of unspecified disturbing events at Auschwitz. He then purposely avoided visiting the camp or trying to get more information on what was taking place. In his autobiography, he claims that he had no direct involvement or knowledge of the Holocaust, although he admits having blinded himself to its existence and expresses remorse for this. He certainly was aware, at least, of harsh conditions for the slave labor and some critics believe that his books understate his role in the atrocities of the era. Newly released documents suggest that Speer knew a lot more about the atrocities than he was telling, but hard evidence for that remains very thin.[4]
Speer's acknowledgment of guilt was nuanced. He acknowledges guilt as a high official of a criminal government, without acknowledging guilt for any crimes committed by himself. His self-described crimes seem to be more acts of omission, including failure to make inquiry into the Holocaust, and failure to challenge Hitler. He paints himself as a nonpolitical technocrat. However, The Guardian has published details that a letter written in 1971 to Hélène Jeanty, the widow of a Belgian resistance leader, reveals that Speer did, in fact, know of Himmler's plans to exterminate all the Jews, in spite of Speer's earlier claims to have left Himmler's Posen speech early. In the letter he says, "There is no doubt—I was present as Himmler announced on October 6, 1943, that all Jews would be killed."
One problem with assessments of Speer's complicity in the Holocaust comes from his status in post-war Germany; he became a symbol for people who were involved with the Nazi regime yet did not have (or claimed not to have had) any part in the regime's atrocities. Even today, German historians such as Joachim Fest tend to have a high opinion of him, while many non-German historians take a lower view. As film director Heinrich Breloer remarked:
[Speer created] a market for people who said, "Believe me, I didn't know anything about [the Holocaust]. Just look at the Führer's friend, he didn't know about it either."
During his time in prison, Speer painstakingly documented his experiences in his secret prison diary, which was later released as Spandau: The Secret Diaries. He described his time in prison as consisting mainly of a mind-numbing and pedantically enforced daily routine; incessant petty personal rivalry between the seven prisoners; a pervasive and bloated prison bureaucracy; and, as three prisoners were released early due to ill-health, many false hopes of his own early release. Speer and most of the prisoners had established secret lines of communication to the outside world via sympathetic prison staff. Speer made full use of this by, among other things, writing innumerable letters to his family (which were restricted to one outgoing page per month under official regulation) and even having money spent on his behalf from a special bank account for a variety of benign purposes.
Speer, as recounted in his diary, made a deliberate effort to make as productive use of his time as possible. In the first decade, he wrote the first draft of his tell-all memoirs. He considered this to be his "duty" to history and his people as the sole surviving member of Hitler's inner circle, in possession of knowledge and a degree of objectivity that no one else had. As the prison directors both forbade the writing of a memoir and recorded each sheet of paper given to the prisoners, he wrote much of his memoir secretly on toilet paper, tobacco wrappings, and any other material he could get his hands on, and then had the pages systematically smuggled out.
All the while Speer devoted much of his energy and time towards reading books from the prison's library, which was organized by fellow prisoner and ex-Grand Admiral Erich Raeder. The prisoners could also have books sent over from the local branch of the Berlin library, and, later, from the central library. Speer was, more so than the others, a voracious reader and he completed well over 500 books in the first three years alone.[5] His tastes ranged from Greek drama to famous plays to architectural books and journals, partly from which he collected information for a book he intended to write on the history and function of windows in architecture.
Later, Speer took to the prison garden for enjoyment and work. Heretofore the garden was divided up into small personal plots for each prisoner with the produce of the garden being used in the prison kitchen. When regulations began to slacken in this regard, Speer was allowed to build an ambitious garden, complete with a meandering path, rock garden, and a wide variety of flowers. The garden was even, humorously, centered around a "north-south axis," which was to be the core design element of Speer and Hitler's new Berlin. Speer then took up a "walking tour of the world" by ordering geography and travel books from the local library and walking laps in the prison garden visualizing his journey. Meticulously calculating every meter travelled, he began in northern Germany, went through the Balkans, Persia, India, and Siberia, then crossed the Bering Strait and continued southwards, finally ending his sentence in central Mexico.
While Speer was incarcerated, his Nuremberg counsel, Dr. Hans Flachsner, remained as his attorney. His major work during this time was stalling the de-Nazification proceedings against Speer. While Speer could not have been subject to further incarceration, the property upon which his family survived during that time could have been confiscated. The proceedings were eventually ended by West Berlin Mayor and future Chancellor Willy Brandt. Flachsner would accompany Margarete Speer to Spandau to greet Speer on his release.
Release and later life
Speer's release from prison in 1966 was a worldwide media event. Abandoning plans to return to architecture (two proposed partners died shortly before his release) he then revised and published two autobiographical books based on the diary entries he had made in prison as well as a third about the SS, which was less well-received. His books, most notably Inside the Third Reich and The Spandau Diaries, provide a unique and personal look into the personalities of the Nazi era, and have become much valued by historians. Speer was aided in shaping the works by Joachim Fest and Wolf-Jobst Siedler from the publishing house, Ullstein.[6] Speer died of a cerebral hemorrhage in London, England, on September 1, 1981, exactly 42 years after Germany invaded Poland.
Speer's daughter, Hilde Schramm, became a noted left-wing parliamentarian. Speer's eldest son, Albert, became a successful architect in his own right. Arnold Speer, Speer's second youngest son, born in 1940, became a community doctor.
↑ BBC, The Nazi who Said Sorry. Retrieved September 19, 2007.
↑ Antony Beevor, Berlin: The Downfall 1945 (Penguin Books, 2002, ISBN 0-670-88695-5), 9.
↑ Anthony Beevor, Berlin: The Downfall 1945 (Penguin Books, 2002, ISBN 0-670-88695-5), 10.
↑ Kate Connolly, Wartime reports debunk Speer as the good Nazi, The Daily Telegraph. Retrieved September 19, 2007.
↑ Jack Fishman, Long Knives and Short Memories: The Spandau Prison Story (Breakwater Books, 1986, ISBN 0-920911-00-5).
↑ Wolf Jobst Siedler, Wir waren noch einmal davongekommen (Siedler, 2004, ISBN 3886807908).
Beevor, Antony. Berlin: The Downfall 1945. Penguin Books, 2002. ISBN 0-670-88695-5.
Fest, Joachim, Ewald Osers (trans.), and Alexandra Dring. Speer: The Final Verdic. Harcourt, 2002. ISBN 0151005567.
Schmidt, Matthias. Albert Speer: The End of a Myth. St Martins Press, 1984. ISBN 031201709X.
Sereny, Gitta. Albert Speer: His Battle With Truth. Knopf, 1995. ISBN 0394529154.
Speer, Albert. Inside the Third Reich. New York: Macmillan 1970. ISBN 0684829495.
Speer, Albert. Spandau: The Secret Diaries. New York: Macmillan 1976. ISBN 0026995018.
Speer, Albert. Infiltration: How Heinrich Himmler Schemed to Build an SS Industrial Empire. Macmillan, 1981. ISBN 0026128004.
Speer, Albert. Architektur. Arbeiten 1933-1942. Propyläen, 1995. ISBN 3549054467.
Van der Vat, Dan. The Good Nazi: The Life and Lies of Albert Speer. George Weidenfeld & Nicolson, 1997. ISBN 0297817213.
The Hitler Cabinet – 30 January 1933 to 30 April 1945
Adolf Hitler | Franz von Papen | Konstantin von Neurath | Joachim von Ribbentrop | Wilhelm Frick | Heinrich Himmler | Lutz Graf Schwerin von Krosigk | Alfred Hugenberg | Kurt Schmitt | Hjalmar Schacht | Hermann Göring | Walther Funk | Franz Seldte | Franz Gürtner | Franz Schlegelberger | Otto Georg Thierack | Werner von Blomberg | General Keitel | Freiherr von Eltz-Rübenach | Julius Heinrich Dorpmüller | Wilhelm Ohnesorge | R. Walther Darré | Herbert Backe | Joseph Goebbels | Bernhard Rust | Fritz Todt | Albert Speer | Alfred Rosenberg | Hanns Kerrl | Hermann Muhs | Otto Meißner | Hans Lammers | Martin Bormann | Karl Hermann Frank | Rudolf Hess | Ernst Röhm
The Schwerin von Krosigk Cabinet – 2 May 1945 to 23 May 1945
Graf Schwerin von Krosigk (Chief Minister, independent) • Wilhelm Stuckart (NSDAP) • Albert Speer (NSDAP) • Franz Seldte (NSDAP) • Otto Georg Thierack (NSDAP) • Grand Admiral Dönitz (independent) (In his capacity as Reichskriegsminister) • Julius Heinrich Dorpmüller (NSDAP) • Herbert Backe (NSDAP)
Final occupants of the Führerbunker by date of departure
Karl Gebhardt · Julius Schaub · Christa Schröder · Johanna Wolf
Theodor Morell · Albert Speer · Joachim von Ribbentrop
Walter Frentz
Robert Ritter von Greim · Hanna Reitsch
Heinrich Müller · Bernd von Freytag-Loringhoven · Gerhardt Boldt · Rudolf Weiss
Erich Kempka · Traudl Junge · Gerda Christian · Constanze Manziarly · Else Krüger · Otto Günsche · Johann Rattenhuber · Werner Naumann · Wilhelm Mohnke · Hans-Erich Voss · Ludwig Stumpfegger · Martin Bormann · Artur Axmann · Walther Hewel · Günther Schwägermann · Armin D. Lehmann
Rochus Misch · Helmuth Weidling · Hans Refior · Theodor von Dufving · Siegfried Knappe
Date uncertain
Wilhelm Zander · Heinz Lorenz · Heinz Linge · Hans Baur
Still present May 2
Erna Flegel · Werner Haase · Johannes Hentschel
Committed suicide
Ernst-Robert Grawitz · Adolf and Eva Hitler · Joseph and Magda Goebbels · Wilhelm Burgdorf · Hans Krebs · Peter Högl
Hermann Fegelein · Goebbels children
Principal defendants at the Nuremberg Trials
Bormann · Dönitz · Frank · Frick · Fritzsche · Funk · Göring · Hess · Jodl · Kaltenbrunner · Keitel · v.Neurath · v.Papen · Raeder · v.Ribbentrop · Rosenberg · Sauckel · Schacht · v.Schirach · Seyss-Inquart · Speer · Streicher
Key: Sentenced to death · Imprisoned · Acquitted
Albert Speer history
History of "Albert Speer"
Retrieved from https://www.newworldencyclopedia.org/p/index.php?title=Albert_Speer&oldid=1018324

redpajama_set_name: RedPajamaCommonCrawl


An examination is conducted of the effects of increasing rotor size on system heave response time and power consumption, due to the increasing rotor blade inertia. The study aims to establish a rotor size at which using an electric motor and fixed-pitch, variable-RPM rotor may no longer be feasible due to the degradation in system climb rate response time and handling qualities ratings. Several isolated rotors ranging from 1 to 8 feet in diameter are simulated, and the heave responses are examined based on Froude scaled ADS-33E-PRF requirements. A model validation is performed using data from a 28-inch diameter rotor tested on a rotor test stand apparatus. Various feedback controller designs are then considered, including proportional and proportional-derivative control laws. Pure proportional control fails to reach scaled Level 1 requirements due to the underutilization of the motor. Using proportional-derivative control, rotors 6 feet or less in diameter can meet the scaled ADS-33E-PRF Level 1 heave response requirements with variable-RPM control alone; rotors larger than this may not be responsive enough for effective operation.
Walter, A., McKay, M., Niemiec, R., Gandhi, F., Hamilton, C., Jaran, C., "An Assessment of Heave Response Dynamics for Electrically Driven Rotors of Increasing Diameter ,"
8th Biennial Autonomous VTOL Technical Meeting & 6th Annual Electric VTOL Symposium, Mesa, AZ, Jan. 29-31 2019.


text:
PAYFAIRLY
Market Pricing Tool
Kirk Douglas, longtime movie that is influential, dies at 103
Leave a Comment	/ cashnetusa review / By admin
Kirk Douglas, the intense, muscular star using the dimpled chin who starred in "Spartacus, " "Lust for Life" and lots of other films, helped fatally damage the blacklist against suspected Communists and reigned for many years as a Hollywood maverick and patriarch, passed away Wednesday, their household stated. He had been 103.
An actor from the golden age of movies who lived well into his golden years, a humanitarian whose commitment to justice and the causes he believed in set a standard for all of us to aspire to, " his son Michael said in a statement on his Instagram account"To the world, he was a legend.
Kirk Douglas' death was reported by individuals mag.
Their granite-like energy and underlying vulnerability made the son of illiterate Russian immigrants one of many top stars of this century that is 20th. He appeared much more than 80 movies, in roles which range from Doc Holliday in "Gunfight during the OKAY Corral" to Vincent van Gogh in "Lust for lifestyle. "
He worked with a few of Hollywood's best directors, from Vincente Minnelli and Billy Wilder to Stanley Kubrick and Elia Kazan. Their profession started during the top of this studios' energy, significantly more than 70 years back, and finished in a far more diverse, decentralized era which he assisted result in.
Constantly competitive, including along with his very very very own family members, Douglas never ever received an Academy Award for the specific movie, despite being selected three times — for "Champion, " "The Bad plus the Beautiful" and "Lust for lifestyle. "
However in 1996, the Academy of movement Picture Arts and Sciences awarded him an honorary Oscar. His other honors included A presidential medal of freedom and a lifetime success prize through the United states movie Institute.
He had been a category unto himself, a potent force for modification and icon of stamina.
In their latter years, he had been a last connect to a so-called "Golden Age, " a person almost since old since the industry it self.
Inside the youth, he represented a brand new style of performer, more independent and adventurous than Clark Gable, Spencer Tracy along with other leaders for the studio period associated with 1930s and 1940s, and much more ready to speak their head.
Reaching stardom after World War II, he had been as likely to play cads (the film producer in "Bad as well as the striking, " the journalist in "Ace into the Hole") while he had been at home before the camera as he was suited to play heroes, as alert to the business. He began his production that is own company 1955, whenever numerous actors nevertheless depended from the studios, and directed a number of their subsequent movies.
A born fighter, Douglas had been particularly happy with their part in the the downfall of Hollywood's blacklist, which halted and ruined the professions of writers suspected of pro-Communist task or sympathies. The use of banned writers was widely known within the industry, but cashnetusaapplynow.com login not to the general public by the end of the'50s.
Douglas, whom years earlier in the day had reluctantly finalized a loyalty oath getting the starring role in "Lust for Life, " offered an essential blow as he freely credited the previous Communist and Oscar winner Dalton Trumbo for script work with "Spartacus, " the epic about a servant rebellion during ancient Rome that has been released in 1960. (A few months earlier in the day, Otto Preminger had established Trumbo's title would seem in the credits for "Exodus, " but "Spartacus" came out very first. )
"Everybody encouraged me personally never to get it done as you won't have the ability to operate in this city once more and all sorts of of this. But I happened to be young adequate to say to hell along with it, " Douglas stated about "Spartacus" in a 2011 meeting utilizing the Associated Press. "I think I would have been too conservative: 'Why should I stick my neck out? If I was much older, '"
Douglas seldom played gently. He had been compulsive about finding your way through roles and a supreme victim on digital camera, whether stabbed with scissors in "Ace within the Hole" or crucified in "Spartacus. "
HR Data Services provides free information! To do this we analyze employer-reported pay data and create comprehensive reports based on revenue, industry and location.
Michael Dennis Graham
Call: 1 917-453-4341
Email: Michael.graham@grahall.com
2019 HR Data Services, All rights reserved


text:
Log in via RCPCH
Cardiopulmonary exercise testing in children with cystic fibrosis: one centre's experience
You need to be signed in to access email alerts. If you have an account log in with your user name and password. If you don't have an account you can just enter your email address in the email box below.
Copyright © 2022 BMJ Publishing Group Ltd & Royal College of Paediatrics and Child Health. All rights reserved.


text:
Chicks dig the car
RP Logs » Archives: Logs » Chicks dig the car
October 16, 2014 Kate and Damian catch up over Titans talk and a little Vorpal on the side.
Gotham, ew…Gross
Ibn al Xu'ffasch
http://www.youtube.com/watch?v=OG_6CopW9GQ
Late night in Gotham isn't usually Kate's thing. She's more used to Central Park, or the docks of New York. Gotham? Gotham is weird. But then again, there are plenty of things to keep the archer busy. She's been trying to track down the druids who came after Keith. Unfortunately, they're not exactly easy to isolate among the weird. At the moment, she's just finished up with a few strange cult-sorts, who have been left tied to a lamp post while she perches on a fire escape nearby, grimacing down into her cell phone as she tries to figure out the streets here.
From quite some distance down the alleyway, there's a guttural roar of an engine and, without warning, a pair of blinding floodlights illuminate the scene in question. A blank tank like vehicle rolls down the alleyway and draws up towards the pair of lampfolk; lying there strung up.
The Batmobile comes to a halt and sits there for a moment. For a long moment. Waiting for something. Scanning something, perhaps.
Kate looks up from the phone at the sound of the engine, arching a brow when it comes roaring down the street. "This place is ridiculous," she mutters under her breath, tucking the phone away in her pocket and swinging over toward a spot of roofline closer to the vehicle. "Anybody home?" she calls over.
The canopy to the Batmobile hisses as it opens slowly, the flood lights so blinding that those out in front stand no chance of seeing them. Inside the hyper-futuristic insides, Batman is not there. Instead, it's Robin. Or one of the Robins, as it were.
"Just me, Just Kate," Ibn al Xu'ffasch says, the white lenses of his mask affixed upon her. "It's been a while. Too long."
"Nice ride," Kate calls back with a smirk, making her way around to the side of the bat mobile. "You got a license and registration for this thing, or is it hot?" Gingerly, she reaches out with the end of her bow, poking at the side of the vehicle in a testing motion.
For the first time in 32 hours, Damian smiles. "It's bought and paid for. This is a long way from home, Just Kate. What brings you to Gotham?" His thick accent is understandable, but doesn't seem to have Americanized any in the past few weeks. "The last time I saw you, we ran into that man the Midnighter."
When the car doesn't zap her bow, Kate leans against it, crossing her arms over her chest and smirking over at Damian. "Helping a friend, actually. I think one of your cohorts is doing the same. You know Vorpal?" she asks, head tilting as she gets a closer look at the bits and pieces that make up this particular piece of equipment.
"I do," Robin responds with pride. "He is a Titan. As am I. I'm afraid he's ill, but I cannot confirm with what. I've not seen him in some time, but recently had a package delivered to him. I do hope it arrives."
Inside, there are all sorts of gizmos that can never be done justice with the simple phrasing of 10pm. Nevertheless, it is certainly something to behold.
Kate quirks a brow at part of that. "You joined the Titans?" she asks, a touch of surprise in her voice. "Huh." She turns to face the car, folding her arms over the edge of the catch as she looks inside. "This…is a lot of expensive tech." And Kate knows expensive tech. "Clint has to sign paperwork before SHIELD lets him take out something like this. Anyhow. Vorpal. Kind of more than just ill, I'm afraid. So I'm trying to track down these druid guys who were after him."
"You seem surprised," Damian responds, clearly a bit ruffled. "I assure you, I am a hero of great renown. They are lucky to have me." Clint? Oddly enough he's recently had a run in with this 'Clint' but that was a different discussion for a different time. "The bureaucracy your friend Clint must have sounds apalling," he responds, mysteriously, giving no information about Batman in his response. As the topic turns back to Vorpal, Ibn takes greater interest, "What happened? I've not gotten a straight story from anyone." Vorpal doesn't particularly like Damian, it's true, and Vorpal himself did not get specific about his condition.
"Some druids called down the Wild Hunt," Kate explains. "We managed to chase some of them off, but apparently more of them caught his scent when we ran into them. They wanted to cut the cat loose, so they came after him with some sort of enchanted blade or mirror thing. They stabbed him, and the cat got out of the bag, so to speak. Unfortunately, it was sort of helping to keep him alive."
Damian frowns, "This sounds worse than I had feared. I did not realize you were close with him. I'm sorry. If there is anything I can do to assist you in helping him, I'd like to. Regardless of our differences, he and I are teammates. Also, I noticed you did not respond to my comment that noted your surprise in me being a Titan. I'd like you to elaborate."
"He's a friend," Kate admits. "And I help my friends. I'm just…" She falls silent, letting out a long breath. "There's not a lot I can do, you know? It's a mystical thing. And most of what I can do is shoot people. So." At his last, she looks back, smile flickering as she shakes her head. "You struck me as a little bit more…I dunno. Grounded. I like the Titans, but I didn't sign on. They're a little too bright and shiny for me."
"In my estimation, what the Titans need is to be a bit more grounded. I am the dirt on their cupcakes. You should join in. It wouldn't be so lonely for me," Robin changes the subject back, "Regardless of whether his ailment is physical or mystical, I will do my best to assist."
"You're not wrong," Kate agrees on the topic of the Titans. At his last, she hops up to try to swing into the Batmobile, grin flashing. "Great. Then you're driving. These guys say there's a place down by…Buford, I think they said? I'm not great on the whole street map around here. Not my territory."
"Hold on."
If there was a doubt as to actually who owned the vehicle, the bat insignia's all over the equipment gives a pretty good hint. The cockpit closes and Damian peels out, pushing the pair hard against their seats. His expert driving pulls him just out of the way of killing the two lamposted druids as he pulls out onto the street and really puts on the gas. From behind, a flame explodes from the back of the Batmobile, pushing the car even faster.
_201410gothamhawkeye_iiibn_al_xu_ffaschtitans


to give you all the nitty gritty details of the how and why.
After I get it all paper patterned I'm going to use Illustrator to make a digital pattern. Last year I stumbled upon this great class by Lauren Dahl, Pattern Workshop. So I'll be using that to hone the illustrator ninja skills I got from writing my book. Then I'll get to do the digital part of the drafting and grading, and tiling the whole shebang for digital download. Her class could not have been offered at a better time for me. I'm excited to get moving on it.
What's on your cutting table this week?


text:
Q: Source control of Excel VBA code modules I'd like to be able to source control my Excel spreadsheet's VBA modules (currently using Excel 2003 SP3) so that I can share and manage the code used by a bunch of different spreadsheets - and therefore I'd like to re-load them from files when the spreadsheet is opened.
I've got a module called Loader.bas, that I use to do most of the donkey work (loading and unloading any other modules that are required) - and I'd like to be able to load it up from a file as soon as the spreadsheet is opened.
I've attached the following code to the Workbook_Open event (in the ThisWorkbook class).
Private Sub Workbook_Open()
    Call RemoveLoader
    Call LoadLoader
End Sub

Where RemoveLoader (also within the ThisWorkbook class) contains the following code:
Private Sub RemoveLoader()
    Dim y As Integer
    Dim OldModules, NumModules As Integer
    Dim CompName As String

    With ThisWorkbook.VBProject
        NumModules = ThisWorkbook.VBProject.VBComponents.Count
        y = 1
        While y <= NumModules
            If .VBComponents.Item(y).Type = 1 Then
                CompName = .VBComponents.Item(y).Name
                If VBA.Strings.InStr(CompName, "Loader") > 0 Then
                    OldModules = ThisWorkbook.VBProject.VBComponents.Count
                    .VBComponents.Remove .VBComponents(CompName)
                    NumModules = ThisWorkbook.VBProject.VBComponents.Count
                    If OldModules - NumModules = 1 Then
                        y = 1
                    Else
                        MsgBox ("Failed to remove " & CompName & " module from VBA project")
                    End If
                End If
            End If
            y = y + 1
        Wend
    End With
End Sub

Which is probably a bit overcomplicated and slightly crude - but I'm trying everything I can find to get it to load the external module!
Often, when I open the spreadsheet, the RemoveLoader function finds that there's a "Loader1" module already included in the VBA project that it is unable to remove, and it also fails to load the new Loader module from the file.
Any ideas if what I'm trying to do is possible? Excel seems very fond of appending a 1 to these module names - either when loading or removing (I'm not sure which).

A: Look at the VBAMaven page.  I have a homegrown solution that uses the same concepts.  I have a common library with a bunch of source code, an ant build and an 'import' VB script.  Ant controls the build, which takes a blank excel file and pushes the needed code into it.  @Mike is absolutely correct - any duplicate module definitions will automatically have a number appended to the module name.  Also, class modules (as in Sheet and ThisWorkbook) classes require special treatment.  You can't create those modules, you have to read the input file and write the buffer into the appropriate module.  This is the VB script I currently use to do this.  The section containing @ delimited text (i.e. @build file@) are placeholders - the ant build replaces these tags with meaningful content.  It's not perfect, but works for me.
''
' Imports VB Basic module and class files from the src folder
' into the excel file stored in the bin folder.
'

Option Explicit

Dim pFileSystem, pFolder,  pPath
Dim pShell
Dim pApp, book

Dim pFileName

pFileName = "@build file@"

Set pFileSystem = CreateObject("Scripting.FileSystemObject")

Set pShell = CreateObject("WScript.Shell")
pPath = pShell.CurrentDirectory

If IsExcelFile (pFileName) Then
    Set pApp = WScript.CreateObject ("Excel.Application")
    pApp.Visible = False
    Set book = pApp.Workbooks.Open(pPath & "\build\" & pFileName)
Else
    Set pApp = WScript.CreateObject ("Word.Application")
    pApp.Visible = False
    Set book = pApp.Documents.Open(pPath & "\build\" & pFileName)
End If

'Include root source folder code if no args set
If Wscript.Arguments.Count = 0 Then
    Set pFolder = pFileSystem.GetFolder(pPath & "\src")
    ImportFiles pFolder, book
    '
    ' Get selected modules from the Common Library, if any
    @common path@@common file@
Else
    'Add code from subdirectories of src . . .
    If Wscript.Arguments(0) <> "" Then
        Set pFolder = pFileSystem.GetFolder(pPath & "\src\" & Wscript.Arguments(0))
        ImportFiles pFolder, book
    End If
End If

Set pFolder = Nothing
Set pFileSystem = Nothing
Set pShell = Nothing

If IsExcelFile (pFileName) Then
    pApp.ActiveWorkbook.Save
Else
    pApp.ActiveDocument.Save
End If

pApp.Quit
Set book = Nothing
Set pApp = Nothing

'' Loops through all the .bas or .cls files in srcFolder
' and calls InsertVBComponent to insert it into the workbook wb.
'
Sub ImportFiles(ByVal srcFolder, ByVal obj)
    Dim fileCollection, pFile
    Set fileCollection = srcFolder.Files
    For Each pFile in fileCollection
        If Right(pFile, 3) = "bas _
          Or Right(pFile, 3) = "cls _
          Or Right(pFile, 3) = "frm Then
            InsertVBComponent obj, pFile
        End If
    Next
    Set fileCollection = Nothing
End Sub

'' Inserts the contents of CompFileName as a new component in
'  a Workbook or Document object.
'
'  If a class file begins with "Sheet", then the code is
'  copied into the appropriate code module 1 painful line at a time.
'
'  CompFileName must be a valid VBA component (class or module)
Sub InsertVBComponent(ByVal obj, ByVal CompFileName)
    Dim t, mName
    t = Split(CompFileName, "\")
    mName = Split(t(UBound(t)), ".")
    If IsSheetCodeModule(mName(0), CompFileName) = True Then
        ImportCodeModule obj.VBProject.VBComponents(mName(0)).CodeModule, _
                         CompFileName
    Else
        If Not obj Is Nothing Then
            obj.VBProject.VBComponents.Import CompFileName
        Else
            WScript.Echo  "Failed to import " & CompFileName
        End If
    End If
End Sub

''
' Imports the code in the file fName into the workbook object
' referenced by mName.
' @param target destination CodeModule object in the excel file
' @param fName file system file containing code to be imported
Sub ImportCodeModule (ByVal target, ByVal fName)
    Dim shtModule, code, buf
    Dim fso
    Set fso = CreateObject("Scripting.FileSystemObject")
    Const ForReading = 1, ForWriting = 2, ForAppending = 3
    Const TristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0

    Set buf = fso.OpenTextFile(fName, ForReading, False, TristateUseDefault)
    buf.SkipLine
    code = buf.ReadAll

    target.InsertLines 1, code
    Set fso = Nothing
End Sub

''
' Returns true if the code module in the file fName
' appears to be a code module for a worksheet.
Function IsSheetCodeModule (ByVal mName, ByVal fName)
    IsSheetCodeModule = False
    If mName = "ThisWorkbook" Then
       IsSheetCodeModule = False
    ElseIf Left(mName, 5) = "Sheet" And _
       IsNumeric(Mid (mName, 6, 1)) And _
       Right(fName, 3) = "cls Then
       IsSheetCodeModule = True
    End If
End Function

''
' Returns true if fName has a xls file extension
Function IsExcelFile (ByVal fName)
    If Right(fName, 3) = "xls" Then
        IsExcelFile = True
    Else
        IsExcelFile = False
    End If
End Function

A: I've been working on exactly this for months.  I think I figured it out.
If the VB Project is trying to remove a module containing something in the call stack, it delays the removal until the call stack pops the module being replaced.
To avoid a module being in the call stack, launch your code with Application.OnTime
Private Sub Workbook_Open()

    'WAS: module_library (1)

    Application.OnTime (Now + TimeValue("00:00:01")), "load_library_kicker_firstiter"

End Sub

If you are self-healing your code like I am, you'll also have to launch your code that overwrites the 'calling' code with that same strategy.
I did not perform extensive testing yet, I am in total celebration mode, but this gets me extremely close to straightforward 99.9% self-healing code within a standalone .xls file without any other tricks

A: Usually the "Loader1" thing happens when Excel is asked to import a module and a module already exists with the same name. So if you import "Loader", then load it again and you'll get "Loader1". This would be because Excel doesn't know (or maybe just doesn't care) if it's really the same thing or a new chunk of functionality that just happens have the same module name, so it imports it anyway.
I can't think of a perfect solution, but I think I'd be inclined to try putting the load/unload logic in an add-in - that Workbook_Open thing looks a little vulnerable and having it in all workbooks is going to be a huge pain if the code ever needs to change (never say never). The XLA logic might be more complex (trickier to trap the necessary events, for one thing) but at least it'll only exist in one place.

A: There is an excellent solution to the vba version control problem here: https://github.com/hilkoc/vbaDeveloper
The nice part about this is that it exports your code automatically, as soon as you save your workbook. Also, when you open a workbook, it imports the code.
You don't need to run any build scripts or maven commands and you don't need to make any changes to your workbooks. It works for all.
It has also solved the import problem where modules such as ModName are being imported as ModName1 into a duplicate module. The importing works as it should, even when doing it multiple times.
As a bonus, it comes with a simple code formatter, that allows you to format your vba code as you write it within the VBA Editor.

A: Can't leave comment to comment

There is an excellent solution to the vba version control problem
  here: https://github.com/hilkoc/vbaDeveloper

About saving custom VBAProjects using this XLAM.
Try this in Build.bas:
'===============
Public Sub testImport()
    Dim proj_name As String
    Dim vbaProject As Object

    'proj_name = "VBAProject"
    'Set vbaProject = Application.VBE.VBProjects(proj_name)

    Set vbaProject = Application.VBE.ActiveVBProject
    proj_name = vbaProject.name

    Build.importVbaCode vbaProject
End Sub
'===============
Public Sub testExport()
    Dim proj_name As String
    Dim vbaProject As Object

    'proj_name = "VBAProject"
    'Set vbaProject = Application.VBE.VBProjects(proj_name)

    Set vbaProject = Application.VBE.ActiveVBProject
    proj_name = vbaProject.name

    Build.exportVbaCode vbaProject
End Sub
'===============

This will export/import Active VBA Project.

A: The following is an easy-to-implement answer if you don't need to export your VBA code automatically. Just Call the following sub and it will export (as text) the VBA code of the current active workbook in a subfolder named "VC_nameOfTheWorkBook". If your project is a .xlam, you need to temporarily set the IsAddin property to false. Then you can easily add the new subfolder to Git. It is a slight modification of the code found here made by Steve Jansen. For a more complete solution see Ron de Bruin post.
You need to set a reference to "Microsoft Visual Basic For Applications Extensibility 5.3" and to "Microsoft Scripting Runtime" in the VBE Editor.
Public Sub ExportVisualBasicCode()
    Const Module = 1
    Const ClassModule = 2
    Const Form = 3
    Const Document = 100
    Const Padding = 24
    Dim VBComponent As Object
    Dim path As String
    Dim directory As String
    Dim extension As String
    Dim fso As New FileSystemObject
    directory = ActiveWorkbook.path & "\VC_" & fso.GetBaseName(ActiveWorkbook.Name)
    If Not fso.FolderExists(directory) Then
        Call fso.CreateFolder(directory)
    End If
    Set fso = Nothing
    For Each VBComponent In ActiveWorkbook.VBProject.VBComponents
        Select Case VBComponent.Type
            Case ClassModule, Document
                extension = ".cls"
            Case Form
                extension = ".frm"
            Case Module
                extension = ".bas"
            Case Else
                extension = ".txt"
        End Select

        On Error Resume Next
        Err.Clear

        path = directory & "\" & VBComponent.Name & extension
        Call VBComponent.Export(path)

        If Err.Number <> 0 Then
            Call MsgBox("Failed to export " & VBComponent.Name & " to " & path, vbCritical)
        Else
            Debug.Print "Exported " & Left$(VBComponent.Name & ":" & Space(Padding), Padding) & path
        End If

        On Error GoTo 0
    Next
End Sub

redpajama_set_name: RedPajamaStackExchange


The UN climate agreement finalized in Paris over the weekend comes just in time for the holiday season. This historic moment feels like a gift for my children, adding a warm light to the darkest time of the year.
No, it's not enough. The pollution reductions enshrined in the agreement – even if fully implemented – will lead to global temperature increases far beyond the 1.5 degrees Celsius scientists warn us would stretch civilization to its limits.
No, this agreement won't fix the problem. We are in for a much longer, harder journey than it would have been if nations had started addressing climate change a few decades ago, when scientists first raised the alarm. Time isn't on our side, and we have to both meet and strengthen our commitments to a safe climate on a global scale, with blinding speed. "We" means we, all of us, every single one, and that's never been an easy task.
This agreement offers hope for my children. For your children. For all the world's children, and all the children still to come in this world. Before this agreement there was no international consensus on how and even whether to address this issue. Now there is.
And so much more, too.
Here are four things the Paris climate agreement gives my children.
No more excuses. For the first time, the world's nations have united to stop climate change. We are all in this together – and the UN climate agreement has enshrined that axiom. That's important because for years, climate couch potatoes have argued that the US shouldn't pitch in to stop pollution if other countries aren't going to make changes. That excuse is gone. The nations of the world have come together and agreed to take action. It's time to get off the couch and get moving.
More ambitious goals than ever before. Before the UN climate agreement, the world was on track to warm 8.1 degrees F (4.5 degrees C) by 2100. The commitments laid out in the climate agreement put the world on track to warm 6.3 degrees F (3.5 degrees C) by 2100. This is not enough. I am not saying that it is. It falls short of the somewhat arbitrary marker of 2 degrees C, which many scientists and analysts say is the limit beyond which human civilization cannot be stretched. But 6.3 is better, a lot better, than 8.1. It's a shift in the trajectory, and it's in the right direction. I am celebrating that.
Telling the truth. And on the goals front, the UN climate agreement finally admits that 2 degrees C is actually too much. We now have global commitment to limit global temperature increases to "well below" 2 degrees C above pre-industrial levels, and to pursue the goal of 1.5 degrees C. That half-degree is important – it's the difference between a nation literally drowning or staying above water, in the case of some small island nations facing physical obliteration from sea level rise. It is also important for the health and safety of people on the margins, the poorest among us, those living on shorelines set to be inundated, those already dealing with malnutrition, those who literally can't survive an increase in food prices, the flooding of their home, or a wave of infectious disease spread through climate disruption. That half-degree tells the truth about the chaos we face, and admits our collective moral obligation to face that truth.
A carbon free future. The Paris agreement sets a long-term goal to get to greenhouse gas neutrality, a situation in which climate warming emissions are balanced by carbon sinks that remove such gases from the atmosphere, like forests. This goal is set for the second half of the century. Many say that's way too long if we want to turn this ship around. I say 2050 is better than never. And the big picture is actually stunning: This is the first global affirmation that the world will transition away from fossil fuels. Not just reduce emissions. But eliminate them. Most of the remaining global reserves of coal, oil, and gas must remain in the ground, while the global economy moves toward clean and renewable energy. Chills.
I attended the climate talks in Paris to make sure the voices of parents were heard loud and clear by the negotiators. I wanted an agreement that would protect my kids from climate chaos. Although our work is not yet over, the Paris agreement has set us on the right path.


text:
L-G not present at Niti Aayog meet, Amitabh Kant tells CM Arvind Kejriwal
June 17, 2018 /0 Comments/in NATIONAL, POLITICS, SPIRITUAL /by Demokratic Front Bureau
NITI Aayog's Meeting
Niti Aayog CEO Amitabh Kant responded to Delhi chief minister's Twitter post questioning who had given Lieutenant Governor Anil Baijal the power to replace the CM at the council meeting.
Delhi Chief Minister Arvind Kejriwal today said he has not "authorised" LG Anil Baijal to attend the NITI Aayog meeting in his place after a report claimed the presence of the Constitutional head at the meeting.
However, NITI Aayog Chief Executive Officer Amitabh Kant described the report as "totally incorrect".
"Under which provision of the Constitution does LG have powers to replace the Chief Minister? I have not authorised him to go in my place," Kejriwal tweeted.
Kejriwal was responding to a Twitter user's claim that LG Baijal "chose" to represent Delhi at the Niti Aayog meeting and had reached the meeting venue.
Responding to the report, Kant said, "This is totally incorrect. Lt. Governor of Delhi is not present at the Fourth Meeting of the Govening Council of NITI Aayog." Kejriwal accompanied by his deputy Manish Sisodia and ministers
Satyendar Jain and Gopal Rai is staging a dharna at Baijal's office for the last one week, demanding that IAS officers end their "strike" and approve doorstep ration delivery scheme of his government.
Kejriwal and his Cabinet colleagues are sitting at the office of Lt Governor Anil Baijal demanding his direction to the IAS officers to end their "strike" and approve doorstep ration delivery scheme, since last Monday.
Prime Minister Narendra Modi chaired the fourth meeting of the Governing Council of NITI Aayog at Rashtrapati Bhawan which is underway right now.
The Council is likely to discuss important issues such as measures taken to double farmers' income; progress of flagship schemes such as Ayushman Bharat, National Nutrition Mission, and Mission Indradhanush; development of aspirational districts and celebration of the 150th birth anniversary of Mahatma Gandhi.
The Governing Council will also review the work done during the previous year and deliberates upon the future developmental priorities.
The day-long meeting will be attended by Union Ministers, Chief Ministers from the States, Lieutenant Governors of Union Territories and senior officials from the Government of India.
The Governing Council of NITI Aayog is the premier body tasked with evolving a shared vision of national development priorities, sectors, and strategies with the active involvement of States in shaping the development narrative.
The bureaucrats in Delhi are not meeting Delhi ministers as part of their protest against an alleged assault on Chief Secretary Anshu Prakash in February.
They are demanding an apology from Kejriwal for the incident.
https://demokraticfront.com/wp-content/uploads/2018/06/56509-twrxpipuql-1493003088.jpg 630 1200 Demokratic Front Bureau https://demokraticfront.com/wp-content/uploads/2018/05/LogoMakr_7bb8CP.png Demokratic Front Bureau2018-06-17 12:47:542018-06-17 12:47:54L-G not present at Niti Aayog meet, Amitabh Kant tells CM Arvind Kejriwal
अब अरविन्द ने प्रधान मंत्री को... Congress's Silence Quizzical


My mission is to empower women to successfully navigate the cancer journey. The road is long and the outcome often uncertain, but developing a solid plan can help the patient regain the sense of control that is lost with the diagnosis. "You have cancer". Those three words change everything. The normal response is "How am I going to survive? Where do I start? Where are the experts who treat my type of cancer? What treatments are best for me?" Fear and confusion cloud the ability to take action. Professional assistance at a time when a situation is emotionally charged can make a significant difference in the outcome. I am an active advocate, accompanying clients to appointments translating information, and adding clarity. My position is to be their consultant and my role is to be their coach, but my foremost goal is to guide and support them during the battle of their lives. My vision is to see that fewer women have to fight this battle.
Elyn is a cancer coach and certified holistic cancer educator. After assisting women diagnosed with cancer for several years, she took her passion to another level and founded Elyn Jacobs Consulting, Inc. In 2007, her mother succumbed to breast cancer after a long, grueling battle. Elyn was diagnosed just prior to her mother's death and her sister was diagnosed a year later. As a survivor, Elyn has a unique perspective and can share with others what she has been through and what she has learned from it. This personal experience allows her to better understand what clients are feeling — whether anger, anxiety or frustration — and to help them work through these obstacles. Her goal is to empower clients to gain control over the course of treatment. Elyn has done extensive research on cancer prevention and has written articles on this topic. Nobody is more motivated to seek out an anti-cancer regimen than a cancer survivor who wants to remain a survivor. She is passionate about helping others get past their cancer and into cancer-free lives.


Given the choice, consumers prefer to buy products from organisations that are committed to ethical trade. Yet practising ethical trade is more complicated than it sounds. Modern supply chains are vast. Labour issues are increasingly complex. Wages and living standards vary drastically from country to country. Individual companies cannot tackle these challenges alone.
The Ethical Trading Initiative (ETI) is an alliance of companies, trade unions and non-governmental organisations. It exists to identify and promote good practice in employment conditions. Committed to improving people's working lives, the ETI focuses on companies producing, supplying and selling goods for consumer markets.
Most UK retailers now recognise the ETI. To be a member, your organisation must adhere to a code of labour practices based on key conventions of the International Labour Organisation (ILO) and accompanied by a set of general principles. In this way, the ETI ensures that companies take responsibility for the ethical sourcing of their goods.
Members of the ETI are expected to adopt the Base Code or adapt their own codes of practice to incorporate the Base Code. We offer ETI audits to help you and your suppliers meet ethical trading requirements and improve workers' lives.


Quiring, Courtney, et al. "Rolaids Ultra Strength Tablets." Davis's Drug Guide, 16th ed., F.A. Davis Company, 2019. Anesthesia Central, anesth.unboundmedicine.com/anesthesia/view/Davis-Drug-Guide/109964/all/Rolaids_Ultra_Strength_Tablets.
Quiring C, Sanoski CA, Vallerand AH. Rolaids Ultra Strength Tablets. Davis's Drug Guide. 16th ed. F.A. Davis Company; 2019. https://anesth.unboundmedicine.com/anesthesia/view/Davis-Drug-Guide/109964/all/Rolaids_Ultra_Strength_Tablets. Accessed April 19, 2019.
Quiring C, Sanoski CA, Vallerand AH. Rolaids Ultra Strength Tablets [Internet]. In: Davis's Drug Guide. F.A. Davis Company; 2019. [cited 2019 April 19]. Available from: https://anesth.unboundmedicine.com/anesthesia/view/Davis-Drug-Guide/109964/all/Rolaids_Ultra_Strength_Tablets.


NT/98/95/ME require additional installation steps.
Part of "Schematic on the Fly"®.
Provides notes for single items or complete paths and additional Database Navigation methods.
"Built in" Database that is always available.
Used by "Schematic on the Fly"® to create Drawings.
Specifies the actual connection to the above Equipment.
Documents cases where rare, unusual or complex Connectors are used.
May be used for Impedance, Signal Levels or any other critical information.
A text area used to document any parameters that do not fit into the above categories.
Type of Signal Eg. Audio, Video etc.
Direction and type of connection. Eg Input, Output, Bi-directional.
In addition to the standard features, additional tools are included to assist in maintaining correct sequences: "Unique Testing Mode" to warn of duplicates and "Cable ID Offsetting" to shift blocks of numbers.
Graphical View of Cable Labels - Cabel Labels Database.
Provides Equipment and Signal filtering and "Path Finder" selection.
Shows all data for a Single Cabel Label.
Spreadsheet style view of Multiple Cabel Labels.
Enables the individual conductors within a cable to be documented.
A handy area to keep bits of information that is not related to a specific item.
Report/Export contents are User Defined. A report creation tool is provided.
Enabling this facility is particularly useful when opening Databases over a Network that may be problematic. Before the Database is opened for use, a backup copy is made so if the network crashes you will still have the original Database.
Rather than create a new Database its sometimes easier to create a copy and modify it. Rename and SaveAs make this process very simple.
Enables Databases to be loaded automatically each time the System starts. This makes operation very simple and fast. We recommend using this facility and the "Default View" set to "Schematic on the Fly"® for most "day to day" applications.
Handy way to make a large number of changes to the Database at once.
This is a neat way to move about the Database quickly, particularly if it is large. When "Jump To" is invoked it shows a drop down box listing the contens of that Field in the Database, "click" and you immediately jump to that data.
A way of highlighting cables that is stored in the Database.
Swap some or all of the data between End A and End B Fields. Ideal after adding a copy and they are the wrong way around - saves a lot of typing!
By the time you reach Input 128 things are pretty boring. When enabled this facility reads the data in a field and will increment/decrement it every time a new record is added - another great time saver.
There are many special functions to reduce the workload, these are accessed using small "..." buttons in relevant places.
This applies to the Single and Multiple View. It enables the data to be ordered by any field, or group of fields in ascending, descending or mixtures of these.
Hide, show, set the order and width. These make the Multiple View easier to use for a specific application.
This is a little popup window on the right hand side of the Multiple View. Its very handy as it shows all the data for the current row, this stops you scrolling over to see it.
A neat little utility that provides conversion between various definitions and can provide actual voltage, current and power values.
A block circuit sketchpad. Place the blocks you need on the page, print it out and then draw the connections. Ideal for thinking about various options. The user can also add their own blocks.
A little note area for those odd times when you need one.
Printer Control Cabel Labels Custom "Pre Driver"
This provides advanced Printer/Spooling/Page Size functions which reduces Printer Driver support required for most printers.
Tractor pull feed is recommended for simplicity and reliability in volume situations.
Windows Driver must support limited Page Size Settings (A4). Some Driver settings will require adjustment to cater for loading and ink variations.
Custom Pre Printer Driver supports: 8, 6, 4, 2 Cabel Labels per page and Simulated A4.
CPU Type Min: 4 Ghz Pentium 4, faster (and more cores) the better for SOF!


It helps to improve immune system and associated symptoms of arthritis, provides nutritional support for healing of joints and helps in Calcium absorption. It is ideal for people who need long-term joint strength or stiff joints. It can also be consumed by people suffering from trauma pain, painful and achy joints, backache, muscular pain, rheumatoid arthritis, osteoarthritis, gout, sciatica and knee aches.
Provides nutritional support to support healing of joints.


text:
Hyundai Targets African Americans With Marketing Campaign From Black-Owned Firm
The automaker's first black branding agency rolls out strategy to promote hybrid vehicles.
By Kevin Michael Briscoe November 2, 2021
A screenshot from one of the "OKAY Hyundai" ads targeting African American consumers for the automaker's hybrid and electric vehicles. (Courtesy of Hyundai)
"OKAY Hyundai," a new campaign using black slang to target African American consumers, rolled out last week, months after the automaker announced its first partnership with a black-owned marketing agency.
Hyundai Motor America hired Maryland-based Culture Brands in May to reach that market and to "be more strategic, targeted and authentic in how we communicate with African American consumers," said Erik Thomas, the automaker's senior group manager for experiential and multicultural marketing.
"… We look to continue to connect with people on their own terms and in relevant ways. As we increase our share of voice with the African American market and communicate successfully, we anticipate sales growth will follow."
Hyundai Motor America's Erik Thomas says Culture Brands' expertise in reaching diverse communities in a culturally relevant way was key to the firm's selection as the automaker's first African American marketing agency of record. (Courtesy Hyundai Motor America)
The "OKAY Hyundai" social media, TV and radio ad campaign, which highlights the 2022 Hyundai Tucson and Santa Fe plug-in hybrids, contains references embedded in its messaging that Culture Brands sees as part of its recipe for success.
<!-article_inarticle_2-->
"In the African American community, placing OKAY before something is the quintessential way things worth noticing are acknowledged," said Eunique Jones Gibson, chief executive and creative officer at Culture Brands. "Together [with Hyundai], it's the perfect nod to Hyundai and to our prospective buyers. See someone with a nice outfit on? OKAY outfit. See someone driving a vehicle that elevates the entire market? OKAY Hyundai."
Reaching out to increase sales of hybrids
While Hyundai does not publicly break out sales data by audience, black consumers make up a miniscule percentage of hybrid or plug-in vehicle buyers, many analysts say. Hyundai is trying to connect to an overall African American market that accounted for $835 billion in consumer spending in 2019, according to McKinsey and Co.
Some industry watchers are applauding the "OKAY Hyundai" campaign and the hiring of a black marketing agency as a precursor to more involvement by minority-owned creative agencies.
"When you look at the top seven brands for African Americans, which include Toyota, Honda, Chevrolet, Nissan, Ford, Kia and Hyundai, all but one currently has an African American agency of record," said Marc Bland, chief diversity officer at IHS Markit, a London-based business intelligence firm.
"With automotive being a peer-driven industry, I expect to hear an announcement soon that all the top African American brands will align with African American marketing agency partners."
When Hyundai announced its partnership with Culture Brands in an effort to reach more black buyers, it said it was looking for an agency that was expert in "not only developing creative and marketing solutions for the African American target segment, but an agency that really knew about building culture."
Culture Brands evolved from a social media campaign initiated by Gibson in 2012, following the death of Trayvon Martin, a 17-year-old black youth killed in Florida earlier that year. A year later, during Black History Month, she launched the digital platform, Because of Them We Can.
"It grew beyond a Black History Month campaign to encompass the past, present and future in black excellence, celebrating black culture and achievements 365 days a year," said Gibson.
She said the digital platform reaches "millions of people monthly."
Gibson, who began her online advertising career with Microsoft, and produced campaigns for such brands as Warner Bros., American Family Insurance, Nickelodeon and the Green Bay Packers, formed Culture Brands in 2017. She said much of the content created for the "OKAY Hyundai" campaign will be "amplified" using the Because of Them We Can platform.
"Our team takes special care in the placement of branded messaging to ensure credibility," Gibson said. "With this new opportunity with Hyundai, [we] can house corporate, vehicle and themed content."
Disinterested Audience
The automotive industry, according to Hyundai's Thomas, is "in the midst of an evolution" as electric vehicles slowly grab more and more market share. Electric vehicle enthusiasts point to low maintenance costs, enhanced performance over gas-powered vehicles, low cost of charging a vehicle, and quick charging times. It's Culture Brands' job to effectively communicate these key benefits to a black audience.
Sales of electric vehicles "are tipped to account for just under one-fourth of the global market by 2025. It is estimated that pure battery electric vehicles will account for about 7.4 percent of worldwide car sales," according to data from Statista.
"It is expected that the market share of conventional internal combustion engines will shrink to about 20 percent by 2050, while electric vehicles are projected to account for 8 out of 10 vehicle sales."
(Statista)
"We believe it's important to educate the total market on the aspects of this evolution and how it will likely impact their car buying and ownership experience," said Thomas.
"… There needs to be a few considerations put in place, including charging stations in urban areas where many African Americans work, live and play; new solutions like true wireless charging to accommodate African American urban living where a private garage is often not an option; and education campaigns to help the African American consumer understand why EVs are a good … and safe choice for them."
Studies show, however, that the African American audience is somewhat indifferent to the benefits of electric and/or hybrid vehicles and the perils of climate change.
Citing IHS Markit data on new vehicle registrations, chief diversity officer Bland, said the African American community accounts for just 4 percent of all electric vehicle registrations in the United States.
In California, which accounts for half of all electric vehicles in the country, 3 percent of hybrid vehicle buyers and 2 percent of plug-in electric vehicle buyers were black, according to "New Routes to Equity: The Future of Transportation in the Black Community," a September 2020 report by the Congressional Black Caucus Foundation.
Third Way, a public policy think tank, conducted a month-long series of focus groups in Detroit, Philadelphia and Greensboro, North Carolina, in February 2020, to gain insight into these communities' views on climate change and clean energy.
"With exception to two or three participants across Detroit and Greensboro, climate change and the environment did not surface as a top issue among focus group participants in the three cities," said the ensuing report, titled "Black Americans Care about Climate Change (But It's Complicated)," which was published in July 2020. "Health care, education, racism, school debt and crime were among the top priorities named in the focus groups."
The same segment of the population is disproportionately affected by climate change, according to the nonprofit Environmental Defense Fund. It reports that African Americans are more likely to live in communities vulnerable to severe weather and floods, experience more climate-induced heat waves, and suffer from severe medical conditions, particularly asthma, exacerbated by pollution.
"Acknowledging environmental issues that are important to various degrees to different new vehicle prospects is a universal concern," Gibson said. "At Culture Brands, we maintain our pulse on the culture through our media platforms and consumer brands. We use these insights and learnings to create culturally relevant and affirming campaigns and content.
"The various aspects of our business provide ongoing access to African American culture. From this we derive insights, and those insights are shaped to support our clients' brand strategies."
Edited by Judith Isacoff and Matthew B. Hall
Recommended from our partners
<!-article_inarticle_player-->
Two-time 168-Pound Champion David Benavidez Seeks To Be Both A Fighter And A Fortune Teller»Next Post
Louisiana Legends: There's No Limit To Fiend's Greatness


text:
Q: How to update entry in sql? I cant figure it out. I have this variable (for example):
$level_building = "test,";

and this sql string:
mysql_query("UPDATE info_buildings SET building='$level_building' + building WHERE nick='$nick'") or die(mysql_error());

all i want to do is to add new text test, after existing text, but after updating it, sql shows 0 (building=0).. My sql output should look like this test,test,test,... Example: building=test,test,test, and each time i use sql string UPDATE it should write new test text in the same building string.. Sorry for bad english i hope you understand this.

A: In MySQL, + is for arithmetic addition. To concatenate strings, use CONCAT():
UPDATE info_buildings
SET building = CONCAT('$level_building', building)
WHERE nick = '$nick'

All the MySQL string functions can be found here.
However, I recommend you reconsider your table design. Putting comma-separated lists in a single column is usually poor design. You should use a separate table with a row for each value.


The Savory Spice Shop was the overall winner of the 2013 Princeton Salsa Slam.
Masala Grill was the People's Choice winner in the 2013 Princeton Salsa Slam.
The Salsa Slam judges debate the merits of each entry.
Hot, mild, fruity, zesty — the entries in the second annual Salsa Slam at the Princeton Public Library tonight ranged from traditional recipes to creations with a twist that included watermelon, raisins and a tandoori-inspired salsa. Ten local restaurants competed for the title of Salsa Slam champ. The overall winner, selected by a panel of four judges, was the Savory Spice Shop on Spring Street. Masala Grill was the first runner up, and Mediterra was the second runner up. About 50 people sampled the salsas and voted for the People's Choice award, which went to Masala Grill. The People's Choice runner up was Mediterra. Before and after the judging, visitors enjoyed dancing (salsa, of course) on Hinds Plaza with the Central Jersey Dancers.
The Central Jersey Dancers taught people their moves.
Enjoying some salsa on Hinds Plaza.


text:
Published: 6 Jul 2019
Fuel on demand? Meet CAFU
CAFU launches the Middle East's first on-demand fuel delivery service app in the UAE
Did you know people in the UAE spend 30 minutes on average at a fuel station? CAFU, an app developed entirely in the UAE aims to change this.
They've developed an app wherein you can register your car and payment details, and whenever you want to refuel, simply point your location on the map and leave your fuel tank unlocked; and they'll refuel it as per your schedule.
Currently available only in Dubai, it delivers quality petrol in both Super 98 and Special 95.
The smart new solution for UAE's citizens and residents is said to be inspired by the country's visionary leaders and futuristic plans.
"We are proud to unveil the region's first on-demand fuel delivery app. Dubai as a smart city known for its dynamic environment that enables the development of new innovative technologies for its people, providing them with convenient solutions. With CAFU, we are excited to bring a world class service that redesigns the whole refueling process, making it simple, safe, and convenient."
Rashid Al Ghurair, founder, CAFU
CAFU's fuel delivery is handled by its own fleet of fuel trucks driven by "CAFU Pilots" who follow world-class standards in safety and delivery of fuel. All pilots are HAZMAT trained and certified to handle fuel with CAFU's vehicles that are equipped with the latest safety technology.


text:
Titanic Hotel has launched a Pink Menu for Breast Cancer Awareness Month
This October, Titanic Hotel Liverpool is launching a pink-themed food and drink menu to raise awareness for Breast Cancer Awareness month which takes place from 1st-31st October, with a percentage of the proceeds going to The Clatterbridge Cancer Charity.
The Clatterbridge Cancer Charity raises vital funds for The Clatterbridge Cancer Centre NHS Foundation Trust, one of the UK's leading cancer centres which cares for over 30,000 patients every year, with the trust's new flagship hospital, Clatterbridge Cancer Centre – Liverpool, having opened in June.
Available in both Stanley's Bar & Grill and The Rum Bar, which will have its back bar lit pink throughout October, the menu will offer a refreshing Pink Lady mocktail or Rhubarb tonic.
Pink Lady mocktail
MORE - National Museums Liverpool reveals Black History Month programme details
Food options feature the favourite classic prawn cocktail, pan-roasted salmon with sautéed Pink Fir potatoes and sorrel & pink peppercorn sauce, followed by a mouth-watering apple & rhubarb crumble with custard.
The menu has been kept alcohol free keeping in line with its health and well-being focus, and £1 from every item sold from the pink menu will be donated to The Clatterbridge Cancer Charity, who provide the very best care and develop life-saving treatments for people with cancer.
Joanne Dunford & daughter
Based on Pembrook Place in the city's Knowledge Quarter, Clatterbridge Cancer Centre provides specialist cancer care for people in Cheshire & Merseyside and beyond.
One of their patients is Joanne Dunford from Gatacre, who has recently been given the all clear after having treatment for breast cancer. Joanne was the very first patient to ring the End of Treatment Bell in the new hospital, with her last chemotherapy session taking place on the hospital's opening day in June.
MORE - You can watch Christmas Films and panto at this new Liverpool drive-in Winter Festival
There's been over £250k raised for the LFC Foundation from Legends charity match refunds
👉https://t.co/6zLgjmffLl pic.twitter.com/wOrfopzfhy
— The Guide Liverpool (@TheGuideLpool) September 30, 2020
Joanne comments:
"At The Clatterbridge Cancer Centre, the team just felt like family. They put me at ease and being in the new hospital was like sitting in your own chair at home! The views are spectacular. When I was coming in for their treatment, to look at the view of our beautiful city, it was amazing and it lifted my spirits. I'm so pleased Titanic Hotel has chosen to help The Clatterbridge Cancer Charity during Breast Cancer Awareness Month and raise awareness of the amazing work it does in Merseyside."
Titanic Hotel's Operations Manager, Scott Davies, adds:
"With the importance of health and wellbeing being such a pivotal, current topic, we are honoured to work with The Clatterbridge Cancer Charity and highlight the importance of their work. We hope customers enjoy our pink menu whilst raising funds for an incredible and worthy cause".
Visit the Titanic Hotel website here or The Clatterbridge Cancer Charity website here.
MORE - Government must offer more financial support to area if restrictions tighten say Liverpool City Region leaders
Charity LiverpoolClatterbridge Cancer CentreClatterbridge Cancer CharityFood and Drinkfundraisinggoing outHealthHotelsLifestyleTitanic Hotel


A spectator is told to select one animal from a group of 64.
He is allowed a totally FREE choice. There are eight animals on each of 8 cards. The spectator merely points to the card which has his animal on it. He then mixes the cards and turns them over to the other side. He finds his selected animal once again on one of the 8 cards. The 64 animals are in a totally different order on the reverse side. Again, he simply points to the card which has his animal on it. YOU INSTANTLY know which animal he selected.


shock sensor module interfacing with pic microcontroller, In this article, I am going to talk about the shock sensor or vibration detection sensor module. The shock sensor module as its names suggest is used to detect shocks. It is also known as a vibration sensor. In this shock detection project, we will see how the shock detection sensor works? How to interface it with pic microcontroller and how we can use it in real time embedded systems projects. I will be using pic16F877A microcontroller.
1 What is Shock Sensor Module?
What is Shock Sensor Module?
Every shock sensor module consists of three pins. Two pins are used for power on this module such as positive 5 volts and ground. The third pin is used for sensing the vibration and giving the logic high signal to any type of controller such as a microcontroller or Arduino etc. shown in figure 2.
The working principle of the shock sensor module is very simple. When anyone touch, hit, mover or jolt the thing where shock sensor module has installed then this sensor sends the signal to their brain or controller for indicating the intensity of this hit, move or touch. Similarly, depending on this intensity, the brain or controller sends a logic high signal to a buzzer, beep or sound system. Two methods are used for installing the shock sensor module which we have described in detail in the above paragraph. For installing this shock sensor module two metal contacts are used and along with these contacts shock sensor is installed, and we can configure these contacts with a simple switch. When any on touch these contacts then shock sensor pins are short then current flow these pins. During this, the sense pin means third pin sense this current and sends a logic high signal to the brain or microcontroller. Then alarm or beep would be turned on according to the intensity of touch, move or vibration.
For acquiring proper advantages or benefits, a brain or controller is required with this shock sensor module. Different controllers such as a microcontroller or Arduino etc. have been using with shock sensor. But here, we will explain it with pic microcontroller PIC16F877A. This controller consists of four ports and shock sensor could be contacted with any port, but that port is configured as an input port in programming. It is programmed in c language with the help of mikro/c software and is powered up with 5 volts dc voltages. Similarly, when it is connected with microcontroller then during any movement, vibration or jolt then microcontroller receives the logic low signal from sense pin of shock sensor.
Because the shock sensor module we are using is an active low shock sensor module. an alarm system or buzzer is connected at the output of the microcontroller, therefore, the microcontroller would be turned on or off the alarm or buzzer after some processing the logic low signal. Because the shock Microcontroller is the main intelligent controller with the shock sensor module, therefore, it has done all the work more precisely and efficiently during an emergency situation.
so to interface shock sensor with pic16f877a microcontroller, we need to use one digital input pin of a microcontroller. I have pin number 5 of PORTB as a digital input pin. If you don't know how to use digital input-output pins of pic microcontroller I recommend you to check this article.
Hello. Do you have a project file in proteus and .hex? It would be interesting to take a look.