This video I will cover things to eliminate from doing so that your skin will be prepared for the good stuff. You can't use good ingredients without stopping what may be causing some of your skin issues. Some of the skin issues I've had recently are very simple solutions. Silence to see what you need to eliminate in your skinfood journey.


text:
Q: Where to put other class functions in a hook? say I have a react class component I want to convert to using hooks
class Something extends React.Component {
    constructor(){
    }

    componentDidMount(){}

    handleSubmit(){}

    changeSomethingElse(){}

    render(){}
}

I understand that I can use useEffect for componentDidMount and render and I can use useState for my component state but other functions I have in my class, handleSubmit in this instance, can that still live as a function inside my new function component or do I need to extract this somewhere else?

A: For the most part, you extract them somewhere else. In fact, I would argue they almost certainly should never have been part of the class in the first place, and the only reason they are there is because this gives you convenient access to props and state. But this convenience comes at a price. The class you gave as an example seems to have the following concerns:

*

*Run some logic on mount (GET request?)

*Handle form submission (POST data?)

*ChangeSomethingElse (state update?)

*Render stuff.

That's a lot for a single React component. Although I do see a lot of React components like that, they conflate a lot of separate concerns. One of the nice things about functional components is that they make it hard to do this while classes make it oh so easy. Rough translation into a functional component:
// easily tested with fetch mocked out, you do
// have to manually pass in data since you don't
// have `this` to get props and state from
const getData = () => {};
const handleSubmit = (evt, data) => {};

const MyComponent = (props) => {
  const [data, setData] = useState();
  const [somethingElse, changeSomethingElse] = useState();

  // Runs once, on mount
  useEffect(() => {
    getData().then(resp => resp.json()).then(setData);
  }, []);

  return data
    ? <props.RenderComponent data={data} onClick={changeSomethingElse} />
    : <props.LoadingComponent />;
};

This component is responsible for state and passing that state on to pure children for rendering. Those functions at the top don't even have to be in the same file if there's no reason for them to go there (unlike the class example). You could even optionally split this into 2-3 components separating the two useState calls and the conditional LoadingComponent render but that's probably overkill.

A: Yes.
const Something = props => {

  // constructor(){}
  useEffect( () => {
  }, [])

  // componentDidMount(){}
  useLayoutEffect( () => {
  }, [])

  // handleSubmit(){}
  const handleSubmit = event => {
  }

  // changeSomethingElse(){}
  const changeSomethingElse = () =>{
  }

  // render() {}
  return (

  )
}

A: Typically, other functions in a class component will be callback functions that mutate state. They will be passed as event callback (onClick, onChange etc.) or used in timer.
While using hooks, in function component, you will have them as local functions.
If they are using state variables in closure, like setCounter(counter + 1), then you need to create them using useCallback, like:
const incrCounter = useCallback(() => setCounter(counter + 1))

Alternatively, you can use function type param for setXXX, in which case you can just declare them as normal local function:
const incrConter = () => setCount(counter => counter + 1)

If you had other properties in your class component, then you can set them up using useRef hook.

A: i think your concern lies on performance. you can use useCallback so that your function wont be recreated on rerender.
import React, { useCallback } from 'react'

const Someting = () => {
  const handleSubmit = useCallback(() => {}, [// you can add dependencies here so that the function will be updated with the correct values])
  const changeSomethingElse = useCallback(() => {}, [])

  return
do something here...

}

redpajama_set_name: RedPajamaStackExchange


text:
Q: Não mostrar produto inativo na busca de produtos Possuo um trecho de código que faz uma busca ao meu BD pelo termo, até tudo correto, mas tenho produtos que estão inativos e não deveriam ser pegos e estão aparecendo, o código está assim, devo estar errando na query.
    $query_rsBuscaFiltro = "SELECT marca.descricao AS marca,
                         produtos.id_produto,
                         produtos.id_departamento,
                         produtos.id_subdepartamento,
                         produtos.id_marca,
                         produtos.descricao AS prodDesc,
                         produtos.lancamento,
                         produtos.codigo_msb,
                         produtos.status
                    FROM produtos INNER JOIN marca ON (produtos.id_marca = marca.id_marca)
                   WHERE (produtos.descricao LIKE '%".$pesquisa."%')  OR
                         (produtos.resumo LIKE '%".$pesquisa."%')     OR
                         (produtos.codigo_msb LIKE '%".$pesquisa."%') OR
                         (produtos.detalhes LIKE '%".$pesquisa."%')   OR
                         (marca.descricao LIKE '%".$pesquisa."%') AND
                         produtos.status = 1 ";
                         echo $query_rsBusca;
$rsBuscaFiltro = mysql_query($query_rsBuscaFiltro, $conexao) or die(mysql_error());
$row_rsBuscaFiltro = mysql_fetch_assoc($rsBuscaFiltro);
$totalRows_rsBuscaFiltro = mysql_num_rows($rsBuscaFiltro);

A: Acredito que você controla os produtos inativos pelo produtos.status. Na sua query ele só se refere ao último OR. Então se um dos OR anteriores derem positivo ele retorna o produto. Você tem que reescrever assim:
$query_rsBuscaFiltro = "SELECT marca.descricao AS marca,
                         produtos.id_produto,
                         produtos.id_departamento,
                         produtos.id_subdepartamento,
                         produtos.id_marca,
                         produtos.descricao AS prodDesc,
                         produtos.lancamento,
                         produtos.codigo_msb,
                         produtos.status
                    FROM produtos INNER JOIN marca ON (produtos.id_marca = marca.id_marca)
                   WHERE ((produtos.descricao LIKE '%".$pesquisa."%')  OR
                         (produtos.resumo LIKE '%".$pesquisa."%')     OR
                         (produtos.codigo_msb LIKE '%".$pesquisa."%') OR
                         (produtos.detalhes LIKE '%".$pesquisa."%')   OR
                         (marca.descricao LIKE '%".$pesquisa."%')) AND
                         produtos.status = 1 ";
                         echo $query_rsBusca;
$rsBuscaFiltro = mysql_query($query_rsBuscaFiltro, $conexao) or die(mysql_error());
$row_rsBuscaFiltro = mysql_fetch_assoc($rsBuscaFiltro);
$totalRows_rsBuscaFiltro = mysql_num_rows($rsBuscaFiltro);

Acrescentando os () no WHERE antes do AND, ele vai testar se algum LIKE combina e se der positivo ele vai testar se o status é = 1.

A: Altere a ultima linha da query para: produtos.status = 0 ";


text:
// --------------------------------------------------------------------------------------------------------------------
// <copyright file="IQueryHandler.cs" company="Naos Project">
//    Copyright (c) Naos Project 2019. All rights reserved.
// </copyright>
// --------------------------------------------------------------------------------------------------------------------

namespace Naos.Database.SqlServer.Client
{
    /// <summary>
    ///     Represents a query handler (typically a database read operation).
    /// </summary>
    /// <typeparam name="TQuery">The type of the query.</typeparam>
    /// <typeparam name="TResult">The type of the result.</typeparam>
    public interface IQueryHandler<in TQuery, out TResult>
        where TQuery : IQuery<TResult>
    {
        /// <summary>
        ///     Handles the specified query.
        /// </summary>
        /// <param name="query">The query to handle.</param>
        /// <returns>The query results.</returns>
        TResult Handle(TQuery query);
    }
}

redpajama_set_name: RedPajamaGithub


text:
Q: Conditionally display multiple variables in MsgBox This is a college assignment.
We have these checkboxes in a userform.
Let's say I have three checkboxes which are:
Find Max,
Find Min,
Find Average
These find the max, min and average values from a certain range.
My problem here lies with the MsgBox.
After the program does the calculation based on the choices, there will be a MsgBox that displays these values.
How do I create a MsgBox that displays the choices I have selected previously?
If I could create a MsgBox for each choice, that would be easier, but this assignment requires that they all appear in a single MsgBox.
If I chose only Max and Min, then the MsgBox should display just the Max value and Min value. If I choose only Max, then the MsgBox should display the Max value. If I choose all, then the MsgBox should display all of them.
I'm thinking I could create a MsgBox for all possible scenarios, but I actually have six choices here that should be displayed whether they were selected or not in the userform. I feel this would be not very effective. I guess there must be some conditional coding between the userform checkboxes and the MsgBox.

A: Try something like below:
Sub ShowResults()

    Dim sMessage As String

    ' btnMax btnMin btnAvg - use your controls names
    If btnMax.Value = True Then
        sMessage = sMessage & "Max is: " & CStr(yourMAXvalue) & vbNewLine
    End If

    If btnMin.Value = True Then
        sMessage = sMessage & "Min is: " & CStr(yourMINvalue) & vbNewLine
    End If

    If btnAvg.Value = True Then
        sMessage = sMessage & "Avg is: " & CStr(yourAvgvalue) & vbNewLine
    End If

    If Len(sMessage) > 0 Then MsgBox sMessage
End Sub

A: *

*Create a Userform with (Name):fmrCalculator & Caption: Calculator

*Create 3 labels with Caption: Max, Min & Avarage

*Create 3 Checkboxes with (Name): cbxMax, cbxMin & cbxAverage

*Create 1 CommandButton with (Name): cdbCalculate & Caption: Calculate

*Double Click on the CommadButton and import the below code:

Code:
Private Sub cdbCalculate_Click()

    Dim rng As Range, cell As Range
    Dim cnrtl As Control
    Dim strMessageBox As String

    'Clear the string
    strMessageBox = ""

    'Set the rng you want
    Set rng = ThisWorkbook.Worksheets("Sheet1").Range("A1:A10")

    'Check if all values in the range are numeric to avoid errors
    For Each cell In rng

        If Not IsNumeric(cell) Then
            MsgBox "The value in column " & cell.Column & " , row " & cell.Row & " is not a number!", vbCritical
            'Stop the code
            End
        End If

    Next cell

    'Loop all Controls
    With Me

        For Each cnrtl In .Controls

            'Check if the control is checkbox
            If TypeName(cnrtl) = "CheckBox" Then

                'Check if the checkbox is checked and find the Max
                If cnrtl.Name = "cbxMax" And cbxMax.Value = True Then
                    strMessageBox = "Max value=" & Application.WorksheetFunction.Max(rng)
                End If

                'Check if the checkbox is checked and find the Min
                If cnrtl.Name = "cbxMin" And cbxMin.Value = True Then
                    If strMessageBox = "" Then
                        strMessageBox = "Min value= " & Application.WorksheetFunction.Min(rng)
                    Else
                        strMessageBox = strMessageBox & vbNewLine & "Min value= " & Application.WorksheetFunction.Min(rng)
                    End If
                End If

                'Check if the checkbox is checked and find the Avarage
                If cnrtl.Name = "cbxAverage" And cbxAverage.Value = True Then
                    If strMessageBox = "" Then
                        strMessageBox = "Average value=" & Application.WorksheetFunction.Average(rng)
                    Else
                        strMessageBox = strMessageBox & vbNewLine & "Avarage value= " & Application.WorksheetFunction.Average(rng)
                    End If
                End If

            End If

        Next cnrtl

        MsgBox strMessageBox, , "Results:"

    End With

    Unload Me

End Sub

UserForm View:


Liberalisation of the Danish wind power market and the introduction of green credit trading has been postponed for two years until January 1, 2002. The government decided the market would be too small for a credit trading exchange to be economically viable before that time, the Danish Energy Agency explains. The government is still aiming, however, at having a green power market fully functioning by 2003 (Windpower Monthly, December 1999). Meantime the price of a green credit is to be politically set to ensure continued wind development in Denmark. Wind turbines may sell their power today for DKK 0.043/kWh plus income from the sale of green power credits, if there was a market for them. The guaranteed minimum price obtainable on the trading exchange was to have been DKK 0.10/kWh. The energy ministry is now considering whether this is a high enough fixed premium to keep the wind market active over the next two years, confirms Kai Worsaae from the energy agency. The chairman of Denmark's wind turbine owners association, Flemming Tranæs, is satisfied with the decision to postpone the introduction of credit trading until the mechanism is fully prepared.


text:
Brady Fletcher Wants Your Money, Millennials
March 28, 2017 @ 1:27 pm By Cole Lyons
Past generations have had their market opportunities; the Baby Boomers the jump in energy prices during the 1970's and Generation X had the tech boom (and bust) of the 1990's. But Brady Fletcher says the empowerment-driven Millennials haven't had their own spring of market luck.
"Millennials haven't had the benefit of seeing a robust commodity cycle in Canada where previous generations have all made a lot of money," the Vancouver–based managing director of the TSX Venture Exchange told Business In Vancouver.
Fletcher has now set his sights on persuading Millennials to try their hand in the stock market
After joining the stock exchange known for its junior mining companies and colorful past last October, Fletcher set his sights on convincing more millennials to invest.
It might be a task as daunting as building a thermal coal mine in B.C. when prices were still spiralling downward in 2012.
Current market volatility is pushing the majority of millennials away from investing, according to September 2016 survey commissioned by Toronto-Dominion Bank.
The results found 36% of millennial respondents don't know if it's the right time to invest, while 22% say it's "definitely" not the right time. More than one-third (37%) reported that they don't invest at all.
But for those who do, they're focused not on mining stocks or chemical companies.
A March 2017 survey commissioned by the Responsible Investment Association found 58% of millennials want to put their money into companies that solve social or environmental problems. That's more than double the rate of baby boomers (25%) and significantly larger than Gen Xers (35%).
"You look at this generation and there is a very high focus on the social good and the social impact. But I think the mining industry has not done a good enough job discussing [its] stewardship for the environment," added Fletcher.
The new TSXV boss says the stock exchange needs to go beyond a more aggressive social media strategy to attract interest for young people. Instead, it's looking at ways of becoming more innovative in its approach to technology.
The TSXV has partnered with Voleo, a Vancouver-based fintech that has developed a mobile trading platform that lets users collaborate in online investment clubs.
The platform is being used as part of a university outreach initiative to build investment clubs and get students to make peer-to-peer recommendations.
"We can't just rely on standard tools that are in front of us. We need to figure it out, we need to adapt, and we need to measure what's working."
Fletcher added that the allure of investing in tech companies or life sciences focused on the emerging cannabis industry could also prove fruitful for younger generations.
Fintech TIO Networks, which went public on the TSXV more than a decade ago, never graduated to the TSX. Instead, it was acquired last month by PayPal Holdings Inc. (Nasdaq:PYPL) for $304 million.
It's the type of exit Fletcher said could bring more positive attention to the TSX-V.
Chris Nicola, chief technology officer and co-founder at online investment firm WealthBar Financial Services Inc., said about one-third of its clients are millennials.
Despite the advances in technology and investment WealthBar is pursuing, Nicola said the biggest challenges reaching that demographic is that they're still decades away from retiring. Investment simply isn't top of mind for them, he said.
"They've got other primary goals in mind. They have lower disposable income available for savings than previous generations and they have higher student debt. A lot of them are dealing with those problems first and foremost."
OurCrowd Portfolio Company Cannabis Firm BOL Pharma Plans Listing on Toronto Stock Exchange
Trading of Novogratz $GLXY Crypto Shares Halted in Toronto After 18.6% Drop
Perspective: Equity Crowdfunding Isn't Your Only Option
SoFi CEO Antony Noto Talks Millennial Stock Investing Habits With CNBC's Jim Cramer
Rebound Ready: Analysts Note 'Buy' Rating For Mogo Finance Technology Inc.
Korea Exchange Launches Korea Startup Market using Blockchain Technology
Brief: UK Alternative Lender Growth Street Taps Millennial Investors
Zopa Teams Up With Fintech Startup Pariti to Help Millennials Pay Off Credit Cards
Revolut Research Says Millennials are Saving More than Ever but Still Worry About Financial Future
Snowball Effect Prepares Secondary Market for Crowdfunded Securities
Shojin Property Partners' Latest Research Reveals: Increasing Numbers of Millennials Are Investing in Property Crowdfunding
The Millennial Opportunity: Dave Girouard Talks About Upstart Lending
Millennials & Banks: Hate's a strong word. They don't care.
Fintech Goes to School: Lenny Links with FICO, Provides Credit Scores to Millennial Students
$300 Million To Pave. Direct Lender Receives Big Boost to Lend to Millennials
This entry was posted in Canada, Fintech and tagged brady fletchter, chris nicola, millennials, paypal, tio networks, tsx, venture exchange, voleo, wealthbar financial. Bookmark the permalink.
Insurtech Lemonade Raises $175 Million, Looks for $125 Million More

redpajama_set_name: RedPajamaCommonCrawl


text:
Q: Configure Sharepoint site to access over the Internet I have a microsoft Azure VM and installed a standalone Sharepoint 2013 server on windows server 2008 R2, I have setup everything and working fine but i am not able to configure site for accessing it over the internet.
i mean can anyone please suggest step by step procedure to configure sharepoint 2013 site that can be accessed over the internet/out of LAN zone like google/Microsoft websites.

A: I have been searching for the solution for almost 3 days and found what is necessary to access sharepoint 2013 site over the internet.

*

*if you are running a standalone system then here is this LINK that'll explain how to setup your environment, that worked for me.

*if you are running an azure VM, you'll have to check for static IP  and reserved IP for your VM (Suggested by MS Professionals), and create an endpoint for the sharepoint port to give access over the internet, Then you can access your sharepoint site using VM's http:/// or http://.
Hope it helps somebody.


text:
Örslev är ett litet skedliknande toalettredskap som användes under vikingatiden och fram till sen medeltid, på vissa platser 1800-talet, för att gröpa ur öronvax och andra orenligheter ur öronen. Ett annat namn på redskapet är öronsked.

Örslevar förekommer sällan i svenska fynd, men tycks ha varit mycket populära på andra närmare platser, bland annat i Finland och Baltikum.

De som hittats är vanligen tillverkade av brons och ganska enkla men även exemplar av silver förekommer, dock betydligt mer sparsamt. De var formade som en miniatyrsked med ett platt, breddat handtag, ibland var handtaget ornerat. Högst upp fanns en ögla eller bygel för upphängning.

Ett par mycket fina exemplar förekommer i Birkagravarna och Svarta jorden, däribland en enkel gjord av ben, men exemplar av silver är sällsynta. Ett fint exemplar med en valkyria och en miniatyr av Fenrisulven som ornament kommer från Birka, en från ett gotländskt skattfynd från Sigsarve, Hejde socken och en från en skatt vid Villie, Lilla Slågarps socken, Skåne. Överhuvudtaget under dess historia är de vanligast från vikingatiden. Fynd har gjorts i gravar och lösfynd i mängder.

Lista över fyndplatser med örslevar
 Jämjö socken, Blekinge. Fint exemplar av brons, hängande tillsammans med pincett i bronsring. Från provinsialläkare Otto Kristian Ekmans samling.
 Rikvide rör, Närs socken, Gotland. Örslev och pincett hopsatta med en ring, funna vid grävning å ett gravfält fyllt med små gravhögar.
 Kyrkebjers, Gothems socken, Gotland. Vackert exemplar, handtaget brett med ett ovalt hål i mitten, funnen som lösfynd i en åker. Möjligen gravfynd, då man även hittat ett hänglås av järn och ett djurhuvudspänne på åkern.
 Okänd fyndort, Gotland. Mycket vackert exemplar, skruvad spiralornering i en fin åttform. Sålda av en man till SHM som dock inte visste vart mer exakt fyndet var hittat, tillsammans med nyckel m.m.
 Valva, Eskelhems socken, Gotland. Fin men nött örslev lik den från Gotland, i ett hål en fin kedjelänk. Funnen tillsammans med 4 djurhuvudspännen, 1 dosspänne, 1 nål, 5 kedjor, 1 rembeslag, 2 ringspännen, 1 brynsten och 1 armring av en man intill tre skelett i en stenig backe.
 Botvide, Öja socken, Gotland. Det fint ornerade skaftet. Funnen i flatmarksgrav vid utgrävning av Peter Manneke år 1961.
 Roslags-Näsby, Täby 138, Täby socken, Uppland. Tillverkad av järn, mycket enkel. Funnen vid undersökning av 41 gravar.
 Hemlingby, Norelund, Valbo socken, Gästrikland. Tillverkad av brons. Funnen i grav vid utgrävning.
samt
 Verchnij Saltov, Voltjansk, Charkov (ry.; ukr.: Verchnij Saltiv, Vovtjansk, Charkiv), Ukraina. Här har flera stycken hittats i vikingatida gravar.

Se även
 Bomullspinne

Källor

 Vikingatidens ABC, Statens Historiska museum, Historia i fickformat, 1981.

Hygienartiklar
Arkeologiska artefakter

redpajama_set_name: RedPajamaWikipedia


CRLP200: Career Ready Learning & Practice is a subject that empowers you to not only think about your future career but actually experience what it's like through a professional placement or team-based professional consultancy experience.
Gaining work experience is critical in increasing your employability in the competitive job landscape. This makes it more important than ever to increase your confidence and undertake an elective to get you career ready.
Your professional experience will take place alongside subject delivery and you will manage your timetable with your industry host. CRLP200 is offered every session across several campuses.
Either enrolled in a Bachelor's Degree that accepts elective subjects from the General Schedule OR has received permission from the faculty to do so.
If you are enrolled or ready to enrol, you must attend one compulsory placement preparation workshop the week before session week 1. The date and time of this session will be available along with your subject timetable.
For exact dates and times, please see the UOW subject timetable and search subject code CRLP200.
If you are interested and would like to learn more about the subject, come along to one of our information sessions where you can meet the Subject Coordinator and find out how this subject could work for you.
Students can enrol in this subject via SOLS.


text:
Call Letters: 13 full-power stations; 14 low-power translators throughout Vermont
Frequency: https://vpr.org/radio-stations-coverage-maps
http://www.vpr.org
Affiliations: BBC, NPR, PRI, and APM
Networks: American Routes Private Network, New England Network News Exchange, Here's the Thing, Reveal, and American Public Media
Listener-supported Vermont Public Radio has been serving the people of Vermont and the surrounding region since 1977. As Vermont's only statewide public radio network, VPR is a trusted and independent source for news, music, conversation, NPR programming, and much more. For more information about VPR News and VPR Classical, a list of frequencies and streaming audio from all of VPR's services, visit VPR.org.
"The Home-State Record"
In-depth look at the home-state records of the Democratic presidential candidates. Nine 4:30 news stories.
From: Vermont Public Radio
Commentary series highlights the perspective of people in their twenties.
40-to-1 Maple Sugar Season
It takes approximately 40 gallons of sap to make one gallon of maple syrup. Celebrate the tradition in the series 40 to 1: Maple Sugar Season, which looks at how to tap, boil, grade and cook with liquid gold.
Camel's Hump Radio
Bill Harley hosts this weekly half-hour family read aloud program, featuring a compelling excerpt from children's literature.
Charlie's Garden Journal
"Charlie's Garden Journal" is a weekly program for both the amateur and the experienced gardener. It's hosted by expert horticulturalist Charlie Nardozzi; a nationally recognized garden writer, consultant, and speaker. From lawns and lilacs, to giant pumpkins, perennials, and pests; Charlie Nardozzi covers a lot of ground.
Updated: Aug 08, 2011
Cool How-Tos
A series of short, sound-rich pieces in which experts teach listeners a practical or whimsical skills.
Iran Journal
Audio journal by an American reporter in search of his family's roots in Iran.
Iran Today
A look inside the culture and daily life of modern Iran.
VPR's "Our National Parks" series explores issues facing the national parks in their next century and how some of these problems are being addressed.
Soldier Stories
Eight National Guard soldiers who spent nearly a year in Iraq describe their experiences at war.
But Why: A Podcast For Curious Kids Radio Hour
On But Why: A Podcast For Curious Kids, we take questions from kid listeners all over the world and find interesting people to help answer them. We...
Our National Parks: New Models
Series: Our National Parks
These parks are all large areas of public land managed by the National Park Service. But there are few such opportunities anymore; all the land is ...
Bought by Spokane Public Radio
Out National Parks: A Call To Stewardship
Birthdays are a time to celebrate, but an opportunity to look forward as well. There are many challenges the national parks must face in the 21st ...
Our National Parks: Indigenous Voices
Though the national parks have famously been called "America's best idea", this sentiment is not universally accepted. Native Americans were dispos...
Our National Parks: Beyond Boundaries
Visitors to our national parks may notice that the boundaries of many parks are marked by straight lines. These lines are political boundaries that...
Our National Parks: Preserving Wilderness
The 1964 Wilderness Act was a milestone in American environmental history. After hundreds of years of clearing away the wilderness, the official po...
Our National Parks: Turning Admiration Into Action
The National Park Service finds itself in a seemingly paradoxical circumstance: widely admired, but increasingly uneasy about its ability to carry ...
Our National Parks: For The Benefit Of All
National parks have famously been called "America's best idea." This expression is commonly interpreted as meaning preservation of America's iconic...
Our National Parks: America's Classroom
American education is embracing "high-impact" practices such as engagement with real places and problems, experiential and service learning, intera...
Bought by Spokane Public Radio and Radio Newark
Our National Parks: The Balance Between Building Constituency And Preservation
The numbers for 2015 are in and they're impressive; there were 305 million visits to the national parks last year. And while it's wonderful that so...
Destination Moon 07/17/19
HV012- For the Fallen 05/15/18
A Chanukah Celebration with Chicago a cappella 12/13/17
Reveal Weekly Generic Promos 09/12/17
Generic Promos for Stations 09/12/17
July 4th with Leroy Anderson and the Boston Pops 06/30/17
Chuck Berry and His Disciples 03/21/17
African American Voices 02/17/17
NEXT Episode 21 12/30/16
Leroy Anderson Christmas 12/12/16
Staff of Vermont Public Radio
Victoria St. John (Admin)
Michelle Owens (Admin)
Coordinator of Marketing & Communications
Ty Robertson
Coordinator of Community Engagement
Betty Smith (Admin)
Producer of commentaries and cultural features
Jane Lindholm (Admin)
Host, Vermont Edition
Ric Cengeri (Admin)
Production Associate
John Van Hoesen (Admin)
Vice President for News
Liz Fullerton (Admin)
Jonathan Butler (Admin)
VPR Online Manager
Mary Williams (Admin)
Kari Anderson (Admin)
Amy Noyes
Melody Bodette
John Dillon
Aaron Kimball (Admin)
Mary Carol Maganzini (Admin)
Liam Connors (Admin)
Producer/Announcer
Steve Zind
Jake Rusnock (Admin)
Walter Parker (Admin)
Chris Albertine (Admin)
Sarah Ashworth (Admin)
New Hampshire Public Radio news director


text:
PAS Lawmaker Warns Catholic Priests Against Being Used by Umno in Allah Row
Umno leaders are pushing the Allah issue to make Catholic priests come across as unreasonable parties and to use them as pawns to drum up support from urban Malays, a PAS lawmaker has warned.
Shah Alam MP Khalid Samad told The Malaysian Insider he met the priests this week after being invited by the Roman Catholic Archdiocese of Kuala Lumpur to speak on the current religious situation at their monthly meeting at the Archdiocesan Pastoral Centre in Jalan Robertson, off Jalan Pudu, in the federal capital.
"I told them (the priests) that whether they like it or not, they are being used as political pawns by Umno-Barisan Nasional in this issue.
"They (Umno) are trying to polarise society so that the Malays feel they are threatened by everyone else," the Shah Alam MP told The Malaysian Insider, saying he spoke on the Allah issue and ongoing row over the seizure of the Bahasa Malaysia and Iban Bibles.
Khalid had also told the priests that facts are being hidden from rural Malays who were not aware that the world was laughing at Malaysia over the Allah row.
The PAS lawmaker said the rural Malays are fed with news from the government-controlled media and are ignorant of the real situation.
"It is the urban Malays that need to be won over. Umno is becoming more desperate as the support from urban Malays is dwindling.
"It is a political game. Umno's survival depends on whether they can make Muslims feel they are under threat," he told the priests.
Khalid joined the likes of fellow PAS compatriots Datuk Mujahid Yusof Rawa and and Sepang MP Hanipa Maidin who have organised dialogues in churches nationwide to "build bridges" with the community following the Allah row.
In his 40-minute talk with the priests, Khalid told them that PAS's stand on the Allah issue was clear – there is nothing wrong with non-Muslims using the term in their faiths as long as it is not misused or misinterpreted.
"There is no written proof in the Quran that the Prophet had prevented non-Muslims from using the word," he said.
Umno, he told the religious leaders, was using the debate over the word Allah to cover up their failures in other matters.
"For example, the hike in prices of goods and services which has caused the cost of living to rise," he added.
As far as PAS is concerned, he said, Islam is a religion that preaches mercy and peace, irrespective of religion.
"This is how we differ from Umno. They use religion as a tool for their political survival."
He was echoing the sentiments of PAS president Datuk Seri Abdul Hadi Awang who had accused Umno of opposing Islam during his closing speech at the 59th PAS general assembly last year.
"The party that opposes Islam the most is Umno. The DAP doesn't agree with Islam. We have differences of opinion but the DAP voices out their differences," Hadi was quoted as saying.
The current Allah row became more heated after the Selangor Islamic Religious Department (Jais) raided The Bible Society of Malaysia earlier this month and seized more than 300 copies of the Alkitab and Bup Kudus (Iban bible).
Selangor Umno chief Datuk Seri Noh Omar had also recently announced that 30 roadshows had been lined up to "educate" Muslims on the state's controversial legislation governing propagation among Muslims in view of the Allah row.
He had also led about 1,000 Umno members in Hulu Selangor in a protest against the use of the word Allah by Christians.
At the end of the march, they had burnt an effigy of Rev Father Lawrence Andrew, who is the editor of the Catholic weekly, Herald.
Andrew had earlier caused an uproar after he insisted that Catholics in Selangor will continue to use the word Allah during Bahasa Malaysia church services despite a decree by the Sultan forbidding non-Muslims from doing so.
Last year, the Court of Appeal overturned a High Court ruling that allowed Christians to use the word Allah in the Herald, saying that Allah was not integral to the Christian faith.
Christians make up about 9% of the Malaysian population, or 2.6 million.
Almost two-thirds are Bumiputeras and based in Sabah and Sarawak, where they routinely use Bahasa Malaysia and indigenous languages in their religious practices, including describing God as Allah in their prayers and holy book.
Read the Bahasa Malaysia version of this article courtesy of The Malaysian Insider
-The Office of MP for Shah Alam-
English Islam News
Labels: English Islam News


1. S Eric Berry is placed on NFI list and is paid something harmless to our cap.
My (realistic) choice for the Chiefs has essentially whittled down to two players: Cam Erving at center, and Kevin Johnson at corner. Both players fill immediate areas of need. Erving would start immediately at either C or RT. Johnson would replace the likely-departing Sean Smith in 2016 (or, even better, Smith is extended and the Chiefs have two starting CBs on the outside who are at least 6'2"). I think Johnson can start right now over Phillip Gaines, who I still really like, and combined with Smith, Gaines, and Jamel Flemming, keep the Chiefs secondary in the Top 5.
Johnson lacks elite speed, but that's what Gaines is ostensibly for. His skillset is extremely similar to Sean Smith, who is a bit bigger and a bit more athletic but lacks Johnson's intense mean streak. Smith is a true #1 when the "light is on," but a liability when it flickers off. Johnson's light never goes off, and exhibits an intensity our secondary has lacked since losing Brandon Flowers.
The question does become -- can the Chiefs seriously draft a CB with non-elite speed? I have my doubts, as I selected Jalen Collins last time around. But Johnson needs to be a serious, serious consideration assuming he lasts to us, which I think he will.
I typically try to be more creative than this, just selecting the same guy over and over again. I promise I'll do better for the remainder of the mock.
Dismukes is definitely underrated on this board. He doesn't sport outstanding measurables but he is a starter-caliber center that you can plug in right away. If the Chiefs elect to pass on Cam Erving in the 1st, it is possible that they try to land a technique-solid center who can start immediately on day two.
Mauldin is every bit the prospect his teammate Marcus Smith was last year. Smith was dramatically overdrafted in the 1st round, and since Mauldin carries all the weaknesses of Smith (and isn't the top-end athlete Smith is/was), we'll have a major course correction and he'll be available here at this point in the draft.
The Chiefs have to have contingency plans for life after Hali and Houston, if it ever gets that far. Mauldin/Ford is a start.
It's easier to teach a good receiver to adequately block than it is to teach a good blocker to adequately receive. Kroft has already shown an adept ability to create separation with soft hands. At 240 lbs, he'll need to pack on some more muscle and the Chiefs will likely work to evolve him as a blocker.
Time to body out this defense, right quick. McCarthy is a gigantic mountain of a man that will need significant work to get him into NFL shape. He can nonetheless be a force at 6'5" with ridiculous, long arms. Poe never comes out anyway, so at least he'll have a learning curve.
Hull is somebody I'm very excited about in the late rounds. Hull is an absolute drill sergeant on the field, with a contagious energy that elevates the play of the entire defense. He's also a very smart player, filling his gaps responsibly and hitting with serious power. He's not a Day One starter, but we don't need one of those -- we need a guy with starter upside, and Hull fits that to a T.
Hill was, at one point, one of the top threats in all of college football. A great combination of hands, athleticism, and route-running had him projected as a very good NFL receiver -- until he tore his ACL in 2013. Since then, he's spent the past year doing what he can to get his game going, with middling results.
The Chiefs can pretty much immediately insert Hill into the strength & conditioning program and eventually get him back to his previously awesome ability.
I spent the day yesterday checking out some Canadian talents, and it turns out that Waud is pretty damn impressive, at 6'5", 290 lbs, with good athleticism and the frame to show off some powerful strength. The Chiefs like shopping north of the border, obviously.
Cairo Santos does not inspire confidence. It's time for an upgrade, and Brindza is arguably my favorite kicker in the draft.
It's interesting how much people's opinions can vary.
To me, Dismukes is one of the most overrated players in the draft. I think he's a pretty middling college center, and I have six guys ahead of him at the spot.
I wanted Grasu with that pick, as I think he's better and a clear Dorsey pick, but I assume he'll be gone by that time.
Do you want a starter, or do you want a STARTER.
That's essentially the calculation being made.
i just dont understand your infatuation of cam erving. i like the guy, i like me some fatties too. I took him in the second in one of my mock drafts several months ago. i still like him as an immediate interior lineman who could eventually play tackle. but he just flat out isn't as good as the other tackle prospects in this class. i think he's a 2nd to 3rd round type of player as a tackle, and i dont think any center is worth a first round pick.
Yeah it's looking that way that he'll be gone. He is definitely the most athletic of all the centers outside Erving. He's got very quick feet, at least initially to set up his block.
I think Erving probably ends up playing center in the NFL. He could play tackle or guard somewhere eventually, but I think he's a center.
I believe in positional value as much as anybody, but at the end of the day, you've got to be pragmatic.
What will make the Chiefs better: Cam Erving, or Kevin Johnson. Not "a center" versus "a corner" on "a hypothetical NFL team." We have known roster realities and available talent to consider.
People talk about reaching for a player of need, of drafting the best available player, etc... but that's thinking about the draft pick-by-pick. At the end of the (three) days it's about "how much have you improved your team?" You have to look at the collection of players you got and ask yourself "How much did my team improve? What weaknesses do I have that my opponents will try to exploit?"
If you just take BPA every pick and don't think about needs you'll end up drafting 5 damned running backs.
center just isn't that important of a position in the end of the day... an elite center is going to do very little in improving a team. what combo of players would make the chiefs better?
or Maurkice pouncey, and an average corner like Brandon Carr?
Center is one of the least impactful positions in football, and having an elote center isn't going to win you jack.
the draft nevers ends up how its supposed to but the first round pick gives you the best chance possible of finding an elite player, and i don't want our best chance going on a center. i'd much rather try to find an elite tackle, cb, wr, te, really anything but center.
Don't love it, but I appreciate the effort and I'm just glad to see some new football threads.
A 35 year drought can make you thirsty.
Sorry, don't agree. Last year, the Browns started off really good (7-4), were in first place in their division, then had injuries on O and D and it all went to hell (and finished 7-9). But the most important injury was Alex Mack.
The Browns' rushing offense dipped from 146.4 rushing yards per game with Mack to 90.5 without him.


We have experience in handling local and international arbitration processes, from the moment of the notification of the dispute, to the preparation of the arbitration demand, the gathering of the evidence, the preparation of the experts and their testimonies and the appearance in hearings.
We are jointly in charge (together with a North American counterpart) of the sponsorship of the international arbitration between the Spanish company ALBACORA and the Ecuadorian State.
We have a solid team prepared to litigate before Ecuadorian judicial bodies. We have sponsored our clients in tax, customs and administrative litigation for years, obtaining favorable results in recovery and savings.
In addition, we have experience and knowledge in the management of constitutional actions, especially in the tax, customs and administrative law areas, whose foundation has been recognized by the constitutional authorities and specialized operators.
We have knowledge and abundant experience in managing claims and administrative challenges before the public administration of Ecuador. We have sponsored petitions, claims and resources before administrative authorities achieving positive outcomes.


text:
Q: Using boost 1_48 with Apache qpid on Windows I stuck while trying to compile qpid c++ with boost 1_47_0 using Visual Studio 2010.
Here is steps sequence, that I made:

*

*Built boost 1.48.0

*Added BOOST_ROOT, BOOST_INCLUDEDIR, BOOST_LIBRARYDIR, etc. to %PATH% env. variable

*Installed cmake, Python, Ruby and added their paths to %PATH% env. variable

*Untared qpid-cpp-0.14.tar.gz

*Applied patch from https://bugzilla.redhat.com/attachment.cgi?id=542165&action=diff due to last changes in boost file hierarchy

*Renamed a few, required by qpid, boost libraries from libbost_LIBRARY-vc100-mt-1_48.lib to boost_LIBRARY.lib format

*Launched "cmake -i -G 'Visual Studio 2010'" in the 'qpidc-0.14' directory and successfully received *.vcxproj files

Now, the problems were appeared.
I loaded 'ALL_BUILD.vcxproj' file, created on step 7, and tried to build one project - qpidcommon. But I couldn't, due to 'missing a library' error. I renamed boost libraries from libbost_LIBRARY-vc100-mt-1_48.lib to boost_LIBRARY-vc100-mt-1_48.lib file format again and tried to compile.
And, at least, I received next:
...
...
...
(__imp_??0variables_map@program_options@boost@@QAE@XZ) referenced in function
"public: void __thiscall qpid::Options::parse(int,char const * const *,class
std::basic_string<char,struct std::char_traits<char>,class std::allocator<char> > const &,bool)"
(?parse@Options@qpid@@QAEXHPBQBDABV?$basic_string@DU?$char_traits@D@std@@V?$allocator@D@2@@std@@_N@Z)

3>D:\wc-gather\tplibs\qpidc-0.14\src\Release\qpidcommon.dll : fatal error LNK1120:
33 unresolved externals
========== Build: 2 succeeded, 1 failed, 0 up-to-date, 0 skipped ==========

I have no ideas, how to handle this, without adding a library direct to project. Do you?
Thanks.

A: boost_LIBRARY-vc100-mt-1_48.lib should be an import library (for boost_LIBRARY-vc100-mt-1_48.dll), not a static one. Rename it to its original name (with lib prefix). Next, build a full boost, to have any possible variation
bjam -j8 toolset=msvc --build-type=complete

Use -j8 if you have 8-core (like intel i7) for a big speedup (8 minutes for a full build),  and install boost (bjam toolset=msvc --build-type=complete install)
Then try to rebuild your application again.


Blue light blocking glasses have been in the market for a few years now which begs the question on everyone's mind – Do we really need them and what benefit does it give us? We will try to answer these questions throughout this article but first let us find out exactly what blue light is.
How long do you usually spend in front of a monitor, a tv screen or your phone. If you do not live somewhere with where technology has not caught up yet and somehow reading this article through a newspaper are self aware enough you would answer with quite a high number. Somewhere between 6 to 8 hours is what is the amount of time people nowadays spend under lights of these electronic gadgets. And if you are working in front of a desk doing clerical work or something similar then this number could spike up to 10 to 12 hours. The point is we spend way too much time in front of screens where we devote about a quarter to a half of our day.
A straightforward definition of blue light is simply a color in the light spectrum that is visible to the human eye. Light, by the way, are electronic particles or photons that travel in waves. These waves that make up the light vary in lengths or amplitude and strength. Light emits energy wherein the waves with shorter length give off more than the longer ones. This energy is responsible for the distinct colors that are recognizable to the human eye and together it makes up the light spectrum or electromagnetic spectrum.
This spectrum, because of its nature has infinitely many different energy levels. But, only a limited strand of it is visible which is called the visible light and it makes up the colors that the human eye can see and distinguish. Some lights that the eyes cannot see include x-rays, gamma rays and UV rays. They may also be harmful but is another topic for another article.To quickly enumerate what colors are make up visible light, you simply have to recall the colors of a rainbow, and they are violet, indigo, blue, green, yellow, orange and red.
Now, on to the blue light. this light is somewhat special because it has the shortest wavelength which means it has the strongest energy emission among all of the visible spectrum. Because of this, health scientists have been postulating that over-exposure to this sort of light may not be handled by human genetics yet. This means that it could be dangerous to eyesight and overall health. Never has the nights in human civilization been so bright as compared to what it has been. Because of electricity, our eyes are are subjected to bright lamps, computer screens, tv screens and smartphones instead of torches and campfires at night. While this is not exactly a bad thing, it is still responsible thing to investigate blue light if we as a generation are being subjected to a hazard right under our noses.
All this talk about blue light being harmful might surprise you as to what is its main source. It is not the smartphone screens or that desktop monitor from work but the sun. The difference though is that the sun will set and will not turn up until the next morning giving us more time to rest our eyes before we see it again. Blue light can be found absolutely everywhere once you step outside your house during the day. In fact blue light is what makes the sky blue – now that settles that question.
Blue light is not without its function to human beings. Throughout human evolution, humans have developed their outstanding body clock to the tune of blue lights. Blue light tells our bodies, through our eyes that we have to be alert. This stabilizes our sleep cycle to ensure us to keep awake so we will be sleepy when our body needs to rest. All this contributes to the body's circadian rhythm or our sleep cycle. Aside from that, blue light has also been observed to boost our moods, our physical prowess and even our senses of well being.
If blue light was so good, why do we have blue light blocking glasses. As stated previously, blue light waves packs the most energy among all the visible light waves because the lengths or amplitudes of its waves are much shorter. This causes blue light to flicker much more than other kinds of visible lights. This flickering can sometimes be heavy on the eyes and might cause loss of clarity affect sharpness and even reduce visual contrast when exposed to it for very long times.
Many experts are trying to find a direct correlation if there are any to common eye strain related discomforts such as dizziness, headache, mental fatigue and physical fatigue. This could mean that prolonged exposure to electronic devices that emit blue light might be considered dangerous for you.
Although our eyes have enough protection to protect itself from blue light, it has not been programmed yet to block out excess light. Hence the need for blue light blocking glasses.
While there is not much that we can do now because of our over reliance on electronic screens, there are still some things that we can improve. For one, we can try to cut back on electronic devices when not necessary. Go for a walk or a run for instance instead of streaming a movie marathon. You could also eat healthier food that has a positive effect on your eyes like carrots.
You can also invest in blue light blocking glasses but know when is the right time to use them. As blue light is still essential to the human body, you may want to put them on only when you should not be seeing the sunlight like at night or when you should be sleeping.


In the world's emerging markets, demand for contract logistics – the business of engineering supply chains and optimizing warehousing, transportation, distribution and inventory – is growing rapidly.
Market intelligence firm Transport Intelligence (Ti) estimates that the contract logistics market will grow at 6.8 percent per year between now and 2018, driven primarily by expanding demand in emerging markets. This trend is most notable in Asia Pacific, which is set to overtake Europe as the world's largest contract logistics market. By 2018, Asia Pacific's contract logistics revenues are expected to approach $100 billion. Other high-growth regions include Africa (11.6 percent CAGR), Asia Pacific (10.7 percent CAGR), Central America (10.2 percent CAGR), and the Middle East (8.6 percent CAGR), Ti says.
There are two parts to this story. First, e-commerce is reshaping demand for industrial real estate in mature markets, driving significant rate increases that in turn are seeing companies offshoring warehousing, storage and other destination supply chain activities. In the United States, for example, industrial rents (75 percent of which go toward warehousing) rose 3.4 percent in the last year and are coming close to pre-crisis 2008 levels, according to The Economist. As a result, there has been a push for contract logistics in emerging markets where industrial space is cheaper. Asia, in particular, has benefitted from the trend as logistics providers increasingly offer solutions like "direct to store" shipments or distribution center bypass models that get goods to market without an expensive intermediate stop in the mature, high-rent country where they are to be sold.
Agility's flagship facility in Dubai has allowed major pharma, retail, and auto customers to consolidate dozens of national distribution centers into one regional facility.
The second driver is the explosive growth in consumer demand in emerging markets themselves. It has been powered by increases in population, size of the middle class, spending power, and urbanization rates, along with steady progress in health, education and poverty reduction. Of note has been dynamism in the economies of ASEAN, GCC and Sub-Saharan African countries, and growth in the economies of Indonesia, Nigeria, Bangladesh, Mexico and Pakistan. Consumer demand has fed the need for upgraded warehousing, transportation, systems and supply chain expertise in those countries as they shift to higher-value exports and pivot to meet the demands of the new consuming class at home. What does this mean?
The nature of contract logistics in emerging markets is being redefined. As markets such as China, India, Indonesia and Nigeria continue to mature, simple structures for storage and rudimentary inventory management are no longer enough. Businesses in industries ranging from retail to technology expect modern industrial infrastructure and facilities, no matter where they operate. Increasingly, they demand value-added services within the four walls of the warehouse – from technology upgrades, to labeling and managing of returns. They also are seeking the same supply chain solutions that allow large multi-national companies to optimize how they run their businesses by enhancing reliability and cost effectiveness. "We clearly see this changing dynamic play out in our business," says Tarek Sultan, Agility CEO.
In the Middle East, Agility has been able to consolidate costly national distribution centers of customers in pharma, retail and automotive into a more efficient regional distribution hub at Agility's flagship Dubai facility.
n Asia, Agility built the largest polymers mega-hub in China, constructing it to world-class specs with an intense focus on Health Safety & Environmental standards.
In Africa, Agility is building 70 sophisticated distribution parks for FMCG, life sciences, and oil and gas customers.
"The very definition of contract logistics in emerging markets has shifted dramatically. Companies like ours are reshaping what it means to do contract logistics in Asia, the Middle East and Africa," Sultan says.
Contract logistics in emerging markets has shifted dramatically as witnessed by the Agility-operated mega-hub in Shanghai built for a chemicals client and the largest of its kind in China.
Small and medium-sized local companies based in emerging markets are also beginning to take advantage of supply chain management tools and techniques once available only to multi-nationals and regional giants. In the past, especially in the Middle East and Asia, local companies tended to manage their warehousing and distribution in-house. That is rapidly changing, says Morten Damgaard, CEO Agility Southeast Asia.
One of Agility's customers in Malaysia is a local retail company that grew from two stores to more than 100 in just two years.
A third factor driving contract logistics demand in emerging markets is the critical role of technology investment. There is a demand for greater visibility across the entire supply chain. Customers that once looked only for simple track and trace capability are today looking for business intelligence and analytical tools that help them manage day-to-day flows of goods and identify areas in their supply chains where they can wring out cost.
One size does not fit all, and an agile offering in IT is essential.
Agility offers customers the ability to integrate with their Enterprise Resource Planning system (ERP). For larger customers with more sophisticated needs, Agility is also able to integrate with vendors, clients and third parties via Electronic Data Interchange (EDI) or web services.
Agility customers have access to a web-based customer portal that offers configurable reports, online shipment booking, and management of documents, exceptions, vendors, and stock and inventory.
The advantages are clear: 100 percent elimination of manual rekeying, improvements in data quality, and the ability to allow venders to directly submit – and take accountability for – their information online.
UNINTENDED CONSEQUENCES E-commerce, nearly 7 percent of all sales in the United States, is creating demand for warehousing space. Rents and property values for this space are increasing rapidly. Many companies, particularly those producing in Asia, are looking to ship goods direct to stores to avoid the expense of consolidation, fulfillment and distribution in the United States.


JOSE MOURINHO says Marouane Fellaini was sent off because of who he is.
The Manchester United midfielder was shown a red card after head butting Manchester City's Sergio Aguero.
Fellaini was furious with referee Martin Atkinson and Mourinho revealed the Belgian was disappointed with the decision.
He said: "I didn't watch the Fellaini incident on TV but I spoke with Fellaini.
"He thinks it was a red card because he is Fellaini. I spoke to Martin [Atkinson, referee] - he thinks it was a red card.
"I can guess it's a bit of a red card and a bit of a very smart, very experienced Argentinian player."


VBA Loop Range And Insert Values In New Column?
Loop Through Range Find Values?
Extract Values From One Column Based On Two Criteria From Two Other Columns?
I built a Microsoft Access database for my church to track member information. I was able to import a lot of the needed information to create the records for each individual and household easily. What I can't do is import their offering donations until it is "Normalized." Which means that I need each row to be 1 record with the fields listed as the column headings. My church has a spreadsheet with several sheets one of which is named Input. I've attached the desensitized file for you to view/play with.
What I need to do is loop through the input sheet and find all the values in range B:4 to GN:387 that are greater than zero or not null (I believe they entered the default as zero so their other calculations would work). Then I need those values to be transferred to the column labeled Offering Amount on the ImporttoAccess sheet. Somehow I also need to define three variables associated with the cell that is contains a value greater than zero.
Each of these I need to attach to the value offering amount and insert into their corresponding column fields for that record. I have entered 2 example rows of data into the ImporttoAccess sheet for you to see what I am after. I am sure it's possible since the data is there, But how to go about it.
I'm attempting to write a macro that will select all the rows which contain a value in a specific column. Say for example, all the instances of "test" in column C, I need to select the entire row with that value in the column.
I should also mention that by using an autofilter, only specific row numbers are selected. The source spreadsheet is dynamic and will not always display the same value in the same row, and thus I need something a little more adaptable.
I've had a look at some examples of extracting unique values but it seems quite complex to me!
I have a list of customer names in column A, column B contains a material code (number format), column C contains the material information sheet (text & number format), column D contains the date that the material information sheet was sent (all column headers are in row 1).
Columns E, F & G follow the same format as above but for a different material code - this is repeated further in Columns H, I & J.
All of the material codes are different, but some material information sheets can be the same for some materials.
In column K I need to identify the unique material information sheet values for each customer, as some are duplicated.
Is this possible? There may be some blank values in the row i.e. a customer does not receive a certain material.
Perhaps just an easier way of organising the spreadsheet!
I need a formula to extract data after "
Color: " & before"
"
I have already use this formula but I get the "#VALUE!" error even if the cell contains the "
Color:
" data.
Sometimes, some cells does not contain the "
Color:
" data, I don't want the "#VALUE!" error, I just want a blank cell there.
I need some assistance with a simple macro. Im clueless when it comes to macros.
column "e" contains the year built for homes. Some of the fields contain "9999" or "0000" or blank. I need to delete these entire rows. If the year is between 1900 and 2020 I would consider it valid and keep the row.
if column "e" is not between 1900 and 2020 delete the entire row.
I have data of different accident year. Now I need to identify different Accident Year and use them in Macro to do certain things. For example in the file attached I am using them in Msgbox. Now to acheive that I first extracted unique values using advanced filter on Column C and later use the different value to POP up the Msgbox. (This is achieved). Now I want to skip this part of doing Advance filter to extract unique value. Is there a way I can know unique value of data through the code itself and use them in program. here is what I am doing currently: I have delted the most of the data cause I am concerned with coulumn containing acc_year only.
Looking for formula to extract values from column A, D through K from raw data table if conditions are met. Desired outcome is in green color.
What the easiest way of looping though the values in a column in a macro? How to you "call" the cells in the macro?
I'm working with reports where I am given a list of used RFID tags which contain 13 alpha-numeric characters, and need to compare it against another list, in order to determine if any are matching. I'd like to be able to loop through one column of values to compare against the other, but unfortunately my VBA skills aren't that great..
I have 2 worksheets. The first sheet has data of which some needs to be copied to a second worksheet. The trigger is a value found in column E. If a match is found, then a copy statement needs to be built. The values in F, G & H are the values to be used in the copy statement. The content of cell H may be numbers or letters or both.
What is the correct format of the copy statement?
In the attached, sheet 2 has a formula that pulls the Item (column B) from Sheet 1 based on Instocks (column F) being less than the value in N2. Would it be possible to add a second criteria to the formula in sheet 2? In short, can I pull the item from column B of sheet 1 into sheet 2, where in sheet 1, column F values are less than N2 AND where column G values are greater than O2?
I'd love to just vlookup the fill rate value and then filter it down, I know at some point I will be asked to weed it down a bit via a formula instead.
What i'm trying to do is i would like to compile in 1 column all duplicate values from multiple cells.
ex. A1 to 10 is numbered 1 to 10 respectively, B1 to B10 is numbered 6 to 15 respectively. which means in A1:B10 the duplicate values are 6,7,8,9,10. i could like these number to show automatically in C1 to C5.
I am finding it very difficult to extract the Project reference data for each employee, I have attached sample working file for reference.
Column A lists an account code on the summary line of each invoice. I'd like to copy this account code upwards for each individual line of the invoice so that I can summarise each type of charge by account code in a pivot table.
I'm a bit stumped as to how to do it. If possible I don't want to have to modify the data itself in any way so that I can paste new data in the each day without altering it.
I've started on the right with a CountA function for each row, which I was intending as a means to identifying the blanks rows and discount them, but it also showed up that each line requiring an account code to be copied returns a 4 and each invoice summary line returns a 9. I'm just not sure how to reflect this in a function.
I need to creating a macro to highlight entire rows if a cell in that row (C) contains specific values.
I'm looking for a formula to sum three adjacent cell values in a specific row and then sum up all of the rows.


For the first time ever – Cartoon Network stars from the PowerPuff Girls, Adventure Time, Ben10 and The Amazing World of Gumball appear together in a spectacular and unforgettable live show! Audience will get the opportunity to share this first-hand experience with our young audience, families and Cartoon Network fans of all ages bringing them closer to their favourite superheroes.
No Next Event Available For this Date.


Patient advocacy groups specializing in brain vascular malformations are here to help you. They are devoted to providing support, resources and services for patients and families. Join these groups to help yourself, your family, and other patients.


text:
Home › News › Industry
Reuters API
Facebook, Instagram are hot spots for fake Louis Vuitton, Gucci and Chanel
Facebook owner Meta Platforms is struggling to stop counterfeiters from pushing fake luxury goods from Gucci to Chanel across its social media apps, according to research and interviews, as the company barrels into ecommerce.
Its platforms have emerged as hot spots for counterfeit offenders who exploit their range of social and private messaging tools to reach users, according to interviews with academics, industry groups and counterfeit investigators, who likened brands' attempts at policing services like Facebook, Instagram and WhatsApp as a game of "whack-a-mole."
"Facebook and Instagram are the key marketplaces where counterfeit goods get sold to members of the public. It used to be eBay 10 years ago, and Amazon five years ago," said Benedict Hamilton, a managing director at Kroll, a private investigation company hired by brands hurt by counterfeiting and smuggling.
Research, led by social media analytics firm Ghost Data and shared exclusively with Reuters, showed counterfeiters hawking imitations of luxury brands including Gucci, Louis Vuitton, Fendi, Prada and Chanel.
It identified more than 26,000 active counterfeiters' accounts operating on Facebook in a June-October 2021 study, the first time its counterfeit research had focused on Meta's flagship app, and it found more than 20,000 active counterfeiters' accounts on Instagram, up from its count the previous year but down from a 2019 peak when they identified about 56,000 accounts.
About 65% of the accounts found in 2021 were based in China, followed by 14% in Russia and 7.5% in Turkey.
Ghost Data is an Italian analytics firm founded by cybersecurity expert Andrea Stroppa, who is also a data analyst consultant for the World Economic Forum. The firm has a track record of exposing the use of social media by counterfeiters, Islamic State supporters and for digital propaganda.
A Reuters search of keywords identified dozens of Instagram accounts and Facebook posts that appeared to promote counterfeit goods, which Meta removed for violating its rules after Reuters flagged them.
Online commerce is a key priority for Meta, which has pushed new shopping features that could help grow its revenue as it faces pressures like ads tracking changes and sputtering user growth, and has signaled a hard stance against counterfeiters. Instagram said luxury brands like Dior, Balenciaga and Versace had adopted shopping features on its app and said some like Oscar De La Renta and Balmain were using in-app checkout.
But users exploiting its platforms to sell fake goods present a persistent problem for the company, which also faces scrutiny from lawmakers and regulators about its content moderation.
"The sale of counterfeits and fraud is a problem that has always persisted with new technology," said a Meta company spokesperson in a statement. "We are getting better every day at stopping these sales and cracking down on fraudsters," the person added.
'PLAYING CATCH-UP'
Most buyers know they are not getting the real deal when they pay $100 for a handbag that retails for over $5,000. But harms include hits to brands' sales and reputation, potential safety issues of unregulated goods, and ties between counterfeiting and organized criminal activity, experts said.
Meta has joined ecommerce sites and online marketplaces in grappling with the sale of counterfeit goods. But unlike public listings on sites dedicated to shopping like eBay and Amazon.com, social platforms also provide offenders multiple channels to post in closed spaces, send private messages and use disappearing content like Instagram Stories, experts said.
"They're creating a lot of unique opportunities for counterfeiters to hide," said Lara Miller, vice president of corporate strategy at the International AntiCounterfeiting Coalition. "We're all playing catch-up."
Counterfeiters took advantage of features like WhatsApp product catalogs, which are unencrypted and available through the app's "business profile" option, to show their wares, the Ghost Data report said.
Ghost Data's Stroppa said he had seen an increasing trend of whole counterfeit transactions occurring on the company's platforms, rather than linking out to external sites.
Some high-end labels remain wary of the ability of a broad spectrum of major online platforms, from ecommerce sites to social apps, to deal with counterfeiters.
In 2020, Chanel, Lacoste and Gant left a European Commission initiative aimed at increasing cooperation between brands and sites including eBay, Alibaba and Facebook's Marketplace to fight counterfeiting, saying it was not effective.
Chanel finance chief, Philippe Blondiaux, said in an interview last year that Chanel, which only sells cosmetics and perfume online, did not believe Facebook or Instagram were "the right environment to sell luxury items," adding the brand wanted a "very protected" and intimate environment for its customers.
The Organization for Economic Cooperation and Development, which estimated the global trade in counterfeit products was as much as $464 billion in 2019, has said a boom in ecommerce in 2020-21 led to massive growth in the supply of online counterfeit goods.
Academics said the fraud had mushroomed during the COVID-19 pandemic, while legislation in the United States and European Union remained unable to combat it.
Chanel, Gucci and Prada said their fight against counterfeiters resulted in hundreds of thousands of social media posts taken down last year, but did not comment specifically on Meta's services. Vuitton and Fendi owner LVMH, which in a filing said it spent $33 million to fight counterfeiting in 2020, declined to comment.
According to a lawsuit Meta filed with Gucci last year, the platform has struggled since 2015 to shut down a woman in Moscow accused of selling fake goods on is services via a network of more than 150 accounts.
BATTLING COUNTERFEITERS
Meta having more user shopping data could help with ad targeting, filling an information vacuum left after Apple started letting owners of its devices block companies from accessing user information.
Meta legal directors told Reuters that cracking down on counterfeiters was key as its commerce plans ramped up. "As commerce has become a strategic priority for the company and as we've been building new shopping experiences, we've recognized that we want to make sure those experiences are safe and trusted for brands and for the users," Meta's director and associate general counsel for IP Mark Fiore said last summer.
Meta, which says it has 3.59 billion monthly active users across its apps, in October launched an updated tool for brands to search and report counterfeits in posts, ads or commerce features, and says it typically responds to complaints of such infringements within 24 hours.
In a recent report the company said it removed 1.2 million pieces of counterfeit Facebook content, including accounts, reported to it from January to June 2021 and about half a million on Instagram. The company said in this period it also proactively removed 283 million pieces of Facebook content violating counterfeit or copyright infringement rules and about 3 million on Instagram, either before they were reported by brands or before they went live.
Big push by British Beauty Council to promote Future Talent Programme
Jack & Jones boosts commitment to organic cotton
Nona Source (LVMH) uses young designers to promote its circular model
Luxury: heels and moccasins make a comeback after years of sneaker dominance
David's Bridal expands alterations offer in UK
China's luxury market shrank 10% in 2022 -Bain
Intradeco acquires Indera Mills


(Richmond, IN)--Business owners in Richmond's Depot District Monday night addressed Common Council and Mayor Dave Snow, urging them to take a step back on plans to create a bicycle loop through the area. "I can't find anything that shows there were any studies done...traffic, the impact on parking," said Matt Stegall. Roger Richert talked about parking that could be eliminated. "No developer, including myself, wants to invest in an area where parking is being taken away." Then, this from Richert: "Does the mayor and INDOT have our years of experience and expertise to run our businesses? If so, buy us out. I'd rather sell now than when the district is vacant and boarded up again." Little Sheba's owner Steve Terzini said he would be out of business if forced to endure extended construction. The Loop bicycle path project would connect 7th and 10th Streets along Fort Wayne Avenue and North E, cutting across storefronts of most Depot District businesses. "This connecting path is very important to our city. However, it's very important to do it in such a way that enhances the corridor and does nothing to take away from the vibrant culture that's been fostered by these local business owners," Snow said. Construction on the second phase would not start until 2022. Until then, Snow promised to open the channels of communication. "In the coming weeks and months, you'll see me in the community more, hear me on more local radio shows, see more partnerships with local media. And, as I've said before, more community input meetings," Snow added. Snow said that no formal planning for a second phase had begun.


text:
Shop Talk »
WOLFWALKERS Trailer
LAPPG January Meeting with Director Maxim Jago
January 6, 2021 | By Staff
For the Los Angeles Post-Production Group's (LAPPG) January meeting, you can join the Director of The Creativity Conference, Maxim Jago, for a deep dive into best practices and far-reaching insights to help you keep the spark alive and maintain your creative flow. After exploring diverse approaches to the creative process with guidance from world-class... »
Dolly Grip Q&A With John Mang & Mitch Dublin, SOC
June 2, 2020 | By Staff
The Society of Camera Operators (SOC) joins Dolly Grippery, a motion picture camera platform for professionals in the industry, in hosting the fourth Dolly Grip Q&A on Wednesday, June 3rd, at 1pm PST via Zoom. This session will feature veteran camera operator Mitch Dublin, SOC and Dolly Grip John Mang. Also, Darryl Humber will... »
UCLA TFT: 10th Annual Sketch to Screen Costume Design Panel
February 1, 2020 | By Staff
Brian Kite, Interim Dean of the UCLA School of Theater, Film and Television (UCLA TFT), one of the most prominent academic institutions for entertainment and performing arts education, and Professor Deborah Nadoolman Landis, Ph.D., founding director of the UCLA TFT David C. Copley Center for Costume Design, have announced the 10th annual Sketch to... »
Hollywood SMPTE: The Irishman
January 14, 2020 | By Staff
The Hollywood Section of SMPTE will present The Irishman this Thursday, January 16th, 2020, at the historic Hollywood American Legion Post 43 in Hollywood to learn more about the innovative technologies and workflows deployed to create such stunning visuals for film, now with 10 Oscar nominations including Best Picture, Editing and visual effects. Faced... »
Discounted Early Registration Ends April 15th: The PGA Celebrates 10th Anniversary of The Produced By Conference June 9th-10th
April 3, 2018 | By Staff
The 10th annual Produced By Conference is set for Saturday, June 9 and Sunday, June 10 and will take place at Paramount Pictures Studios in Los Angeles. Every year, the Produced By Conference features an incredible collection of speakers. This year, we look forward to hosting Bruce Miller, Elisabeth Moss and Warren Littlefield, the... »


Every fashionista needs a luxe bag that gives her outfit an extra boost. That's exactly what this ring handle tote bag does! The shopper handbag is black, has golden details and two beautiful golden coloured round ring handles. This ring handle tote bag can be used as a shopper hand bag, as well as as a shoulderbag. Attach the shoulderstraps to the bag to wear it over your shoulder. The bag is closeable with a zipper and on the inside of the bag are various pockets and zippers for a nicely organised bag. This big shopper bag is perfect for a day shopping with friends or to combine with a beautiful luxe oufit.


The 2015 Canadian GRESB Results are in and the 11 Canadian organizations that submitted the survey fared quite well. Oxford and Bentall Kennedy continue to show leadership, placing 1st in their respective categories and the list of first time GRESB submissions continues to grow (This year Triovest reported for the first time). Still, several more organizations have submitted through the grace period (the survey is submitted but the results are not public) and plan to submit survey responses in 2016.
It was noted at the 2015 Canadian Results Release that GRESB has transformed the landscape that energy efficiency will be operating as organizations are now looking beyond 1 or 2 year paybacks, to 5 and even 10 year paybacks – Organizations are becoming more forward looking in terms of sustainability, energy efficiency, health and wellness, the list goes on – These features will pay dividends not only in emerging regulations like building labelling in Toronto, but also current and future GRESB submissions.
While Canada fared better than North America as a whole, Australia and New Zealand still remain the global leaders. Looking at the individual aspect score breakdowns (see end for full results) provides additional insight into where the participating Canadian CRE organizations strengths lie.
Source: GRESB 2015 Results Release Presentation, Chris Pyke, COO GREB. Sept 15, 2015.
Canadian firms have robust management strategies in place to address ESG concerns (Scoring 83 vs the global average of 71), however it is clear that with regards to performance indicators, there is much room for improvement (Cdn. Scored 51 vs the global avg. of 38).
Operationalizing management practices from the top down is difficult, especially when sustainability specific staff managing national operations at any CRE organization is limited. Yet progress is possible and had been made in several areas – with Canada fairing strongly in Risks & Opportunities, and greatly outperforming the globe on the topic of stakeholder engagement with a score of 74 vs the global avg. of 53.
Measurement improvements will be the next key issue to improve upon in 2016 and this fits hand-in-hand with performance. You don't manage what you don't measure so benchmarking and monitoring programs are important in setting a precedent for performance improvements. Both the measurement and performance areas will provide Canadian CRE organizations with an opportunity to show continual improvement to stakeholders in 2016.
Moving forward, although GRESB will adjust scoring in the measurement category to account for such high scores across the board in 2015, performance and measurement are likely to be good indicators of how leading firms continue to lead, while also bringing to light emerging leaders in the CRE industry.
The Global Real Estate Sustainability Benchmark [(GRESB) more at– www.gresb.com] has emerged as the dominant reporting framework for the real estate portfolio performance in North America. Specific questions go into greater depth than what is available through CDP and scoring is based on a geographic peer-based ranking system where organizations score within 4 quadrants, ranging from Green Starters to Green Stars. From the asset owner standpoint – GRESB aligns with UN PRI – which in Canada includes over 26 Asset owner signatories.
The emphasis on ESG performance metrics for investors has added an additional layer of transparency of how Property Management firms operate and the environmental management practices in place throughout a portfolio. Analysts are increasingly incorporating ESG factors into financial models for companies under coverage to assess and predict performance. Additionally, performance can be assessed and tracked against the annual GRESB Survey Results.
The implications have trickle down effects at the property level. This can range from corporate energy, water, waste or GHG mandates to corporate wide targets. Support from large pension fund investors for investment in energy efficiency measures with longer perspective paybacks is also something that may become more.
The Performance Indicators Section covers the actual operational and performance aspects within a portfolio. With regards to data, GRESB supports Energy Star Portfolio Manager data transfer for GRESB submissions. The second aspect of Performance indicators is data coverage – which would include real time data availability and sub-metering systems in place as well as overall availability of data. With one of the weakest scores in the 2015 survey results, there is a lot of room for improvement in the Performance Indicators section (This is second only to Building Certifications).
As GRESB rapidly cements itself as the standard for real estate portfolio ESG performance assessment, around the world, we can expect to see increasing emphasis on energy management efforts.
Special appreciation to Kyle Pinto for his work in putting the above article together.
This entry was posted on October 8, 2015 by Kyle Pinto. Kyle is in charge of Sustainability Strategy and Implementation and heads our sustainability service offerings.


text:
'Dancing With the Stars' Review: Nobody Puts Bindi in the Corner
TVTV Reviews/Recaps
Oh, what a fantastic week on Dancing With the Stars! It was "Iconic Dance Week", where the couples did modern recreations of famous dances from films, TV, and music videos. This was unbelievably entertaining, and featured show favorite, Leah Remini, filling in as co-host for Erin Andrews this week. It also featured the icon Olivia Newton John sitting in as a guest-judge, and loads of wonderfully inventive choreography. But before we get to this week's episode, last week, I was unable to fulfill my duties as your trusty TV reviewer, due to a prior commitment. So, here now, for your reading pleasure, is a one-paragraph highlights version of what happened on last week's show:
Guest judge Maksim Chmerkovskiy showed up with oddly 1980's feathered hair. Stars were put with different pro dancers, voted by audience, for "Switch Up" Week. Host Tom Bergeron returned after being home the week before to be with his ailing dad. Hayes went through puberty live on the show when his voice cracked like Peter Brady over and over. Bruno used the term "Kangaroo-ish", to describe someone's dancing style. Paula Deen was a pain in the butt with her new pro dance partner Mark, immediately demanding hugs and love and patience from him. Paula then flashed the judges by lifting her skirt/dress up, and they almost fainted. Bruno told Alek to "caress" the Rumba. Tom Bergeron asked "Can we keep Bindi for next season too?" Tom Bergeron ended the show by saying that this was his dad's favorite show and he never missed an episode, and he would like to think "that he is still watching now." We are so sorry for your loss, Tom.
Now, onto this week's show …….
Hayes / Emma: They were assigned Grease, and Hayes literally said "What's that?" OH MY GOD. Whats that?? Whats that??? Are you serious, kid? I know you are 2 years old and know nothing about anything that happens over 6 seconds, but how do you not know this play or film or SOME version of it? How have you never even heard of it, ever? Ugh. Anyway, they recreated the famous last scene from the film, to the song "Youre the One That I Want". The set and costumes were pretty much right on, and it was a great recreation. Olivia said "you kept in all the elements, great job!' Horny Carrie Ann told Hayes "you are such a stud!" Um, relax there, lady. He is FIFTEEN years old, and besides, he can only do things for 6 seconds before he peters out. Get it? That was a VINE joke. Backstage, Leah said the word "amazing" literally 14 times. Scores were 8/8/8/8. Len woke up from his nap he was taking last week, just in time for this weeks show. Upon seeing Hayes and not knowing who the hell he is, he promptly fell right back asleep.
Andy / Allison: This was probably my favorite dance of the night, personally, just because it had so many elements, and I loved the way Allison's choreography managed to include so many different dance moves and moments from the film, all in one dance routine. She included the raincoats, the couch, and even two sets of stairs for them each to dance/walk up and down as part of the number. It was awesome. The song, was, of course, "Good Morning", from the famous and wonderful film Singing In the Rain. The couple had the honor of meeting Gene Kelly's widow, Patricia, for some tips and history on her husband's legacy. So cool. Julianne told Andy "the other guys need to watch out!", while Carrie Ann said it "felt just as good and fresh as the original!" Backstage with Leah, Andy said: "If you're listening, Gene, I had a great time getting to know you this week. It was an honor." Very sweet. Even sweeter were the perfect scores. 10/10/10/10. Len was at home dancing around his living room with a bottle of prune juice.
Alexa / Mark: They did the famous Britney Spears performance from the Video Music Awards, of "I'm A Slave 4 U." This, of course, includes a real live snake, which I'm actually surprised they pretty much forced upon Alexa. Cant they just use a fake one? Is it really necessary to make this woman dance with a live snake around her neck? I'm sorry, but if I was on the show and they said I had to dance with a snake, I would be runnign so fast for the door, you wouldn't even see me. During rehearsals, Mark said "the most important thing is to not upset the snake." How about the most important thing being DONT USE A SNAKE!!!!??? Bergeron hilariously said: "Say hello to their little friend!" Mark worse the worst wig of all time for this dance, and apparently the judges didn't find the dance as sexy as it was supposed to be. Carrie said "you missed the essence of Britney with that" Leah said backstage that people online had already started a drinking game to drink each time she says "amazing." So it wasnt just me noticing that. Scores were not quite as amazing at 8/7/7/8.
Bindi / Derek: "Nobody puts Bindi in the corner". That is what Derek said to Bindi, upon learning they would be re-creating the classic, iconic "Time of My Life" dance from Dirty Dancing. And to help them out a bit with the all-important lift above the head, was the original "Baby", Jennifer Grey. In footage, Derek said he had never been more nervous for a dance in his life, because lifts are not his specialty. But just like in the film, the two took to the water to rehearse the lift again and again, and they got the dance down to perfection. I felt like I was watching the movie all over again. Olivia called Bindi "enchanting", and Bruno stood up and screamed "My little star has gone SuperNova tonight!" Alrighty then. Scores were perfect at 10/10/10/10. Len changed the channel at home to "Murder She Wrote."
Paula / Louis: I don't know about you, but whenever I think Paula Deen, I think MADONNA! It's almost like they are the same person … except not at all. Whoever gave her "Vogue" for her song must have been high on lead paint at the time, because even SHE knew it was a bad idea. "We don't have one thing in common, y'all. I don't wear cones or pose in the nude. Nothing." Also, she dances, while you are forcibly dragged across the dance floor in your bloomers. Basically, they recreated the performance from the MTV Awards, so Paula was able to hide in the larger than life costumes and the many people performing with her She did lots of hand movements – her wrists got a good workout, and her legs shuffled along as usual. Tom Bergeron hilariously mocked Louis's short tight shorts by announcing "men's shorts now available at stuffasockinit.com ". The judges seemed speechless at this point, Paula kept cracking up laughing at absolutely nothing, y'all, and backstage, she screamed about 7 times in a row to nobody: "We did it! We did it! We did it! We did it!" Did what? Walked across the dance floor to music? Also backstage, when Louis randomly went underneath Paula's dress and poked his head out during the Leah Remini interviews, Leah yelled "Yeah Paula! Ride it! Ride it!" Paula then motioned physically as if she were … well …. riding Louis. It was even more disturbing than it sounds. Why? Just …. why? Scores were 6/6/6/6, and Len turned the channel back just in time, then promptly upchucked in his vegetable soup.
Carlos / Witney: So, their assigned song was from the film Magic Mike, and it was the song "Pony." As Carlos so poignantly said in the footage: "It's a song about a bunch of dudes stripping." He was very hesitant to do this at all, because he felt uncomfortable with the graphic nature of the song and lyrics and movements he was doing. He brought up having a strong faith and God in his life, and how it felt wrong to be so raunchy. Witney convinced him he is playing a character, and it would be fine if he embraced it. The dance was pretty darn hot, as he thrusted about shirtless and oiled up with a few other male dancers too. Bruno was on his feet and experiencing a standing ovation in his pants, if ya know what I mean!!!! "On your knees and beg for forgiveness. Repent!!!" I don't know about you, but you've answered MY prayers!" He is hilarious Julianne said he nailed it, and Olivia joked that maybe he missed his calling and should have been a stripper. Backstage, Leah opened by saying: "So, whats up with church tomorrow?" So funny. Scores were 10/9/9/10, and Len had to have his eyeballs removed so he could no longer see such shocking things on TV.
Nick / Sharna: This couple got to re-create the epic dance number from Saturday Night Fever, to the song "You Should Be Dancing", by the Bee Gees. I gotta say, the live performance , both singing and musically, by the show's band, was right on with this one. It's not easy to recreate Bee Gees songs, and they did it in the exact tone of the original. This dance was a total blast, and again, it felt like I was watching the movie all over again. Nick loved playing Travolta's role, and he did great with it. Carrie Ann said some crap about him going in and out of character, which I did not see at all. Julianna called it a "true reinvention of what that was. Outstanding." Bruno simply called it "brilliant." Scores were 9/10/10/10, because Carrie Ann is a party pooper.
Alek / Lindsay: They were assigned Elvis Presley's "Jailhouse Rock", which was another classic scene, and in this number, Alek did capture the look of a young Elvis. The dance itself felt a bit low energy, or it seems like he isn't as into being on the show ever since the Oregon shooting. And who could blame him? I could be wrong here, but he just seems off somehow. Scores were 8/8/7/7.
Tamar / Val: This was so beyond cool. Their assignment was the awesome music video version of Janet Jackson's "Rhythm Nation." Aside from the drama that always seems to come from Tamar, (this week she was sick all week-long ), this was really cool on many levels. The judges loved it, and Bruno told her that he couldn't tell her apart from the actual pro dancers – it felt like she was leading. Scores were perfect ten across the board.
GOING HOME: Sadly, or maybe not so much, it was Paula Deen who was sent home this week, y'all. Her parting words, other than to laugh like a hyena for no apparent reason over and over, were "Ummm soooo excuuuuhhhted " (that would be "I'm so excited " in Paula-speak). "I get to go see my grandbabies!!!!" Okay then Paula. Enjoy those grandbabies. Be well.
COMING UP NEXT WEEK:
Len wakes up from another nap and flips on "Wheel of Fortune."
Hayes makes a 7 second VINE video by accident, and is shunned by his millions of fans.
Somebody tries to put Bindi in the corner. It's not pretty.
Erin Andrews returns and can't get into her dressing room. All the locks have been changed and Leah Remini's name now appears on the door. The producers ask her to leave the studio immediately, as she has been randomly replaced for no reason, with no explanation. She wakes up in a cold sweat, realizing she must have had a bad dream. Or was it? Brooke Burke Charvey is holding a microphone and standing over Erin's bed. She yells at her over and over through fits of sobbing: "You've been replaced. How does that feel? How does that feel??"
Kelley Lynn
@theworkprint
Previous articleThe Leftovers: "Off Ramp" Review
Next article'Room' Review – "It's Still Just You And Me And That's Okay"
TV January 19, 2022
Culture January 16, 2022
Books January 16, 2022


This was the site of Nunn Mills Power Station, built by the Northampton Electric Light and Power Company in 1917. As the map below shows, the Midland Railway added a new junction to connect the power station to the railway in 1916 to both aid with construction and to service the station during its lifetime.
The power station played a key role in World War Two and was a target for Nazi bombers, although it was never hit. The company went so far as to paint camouflage on the outside of the buildings, as can be seen in the photograph below. Many employees of the Electricity company volunteered for the Home Guard and Air Raid Precautions services during the war to help protect the site.
One of the turbines in the power station was also used to test newly-developed jet engines and their inventor, Sir Frank Whittle, regularly visited the site to monitor progress.
During its lifetime the power station also supplied an outdoor swimming pool on Midsummer Meadows with heat produced by the generators.
Areal photograph showing the power station, with the Midsummer Meadows swimming pool on the opposite bank of the river.
This generated power for Northampton until it was closed in 1975. The cooling towers were demolished in 1979, more than 15,000 people turned out to watch the demolition.
The demolition of the cooling towers (1979).
As the photographs below show, the rest of complex stood abandoned eyesore until 2015, when they were demolished to make way for the University Campus.
Opposite the power station sat the Avon cosmetics factory. Avon Cosmetics was founded in America in 1886, and opened its first UK offices here in Northampton in 1959. In the 1960s Avon became a famous brand as TV adverts popularised the catchphrase 'Ding-dong, Avon calling.' This referred to the fact that, instead of shops, Avon's products were sold by women door-door. Between 1989 and 2004 Avon had a factory on this site and built its headquarters here in 2009.