text:
Q: Find() results in Object variable or With Block variable not set Thanks for reading my post.  I'm new to Excel VBA and have run into a wall debugging a call to Find().  I've gone through several posts on this site and others but so far each fix I've tried has been unsuccessful.
I am writing code to process elements out of financial reports.  Each report contains one or more multi-row & multi-column blocks of cells with details describing a project.  The size of each block isn't consistent, but each always begins in the top left with "Client Name".  So I want to iterate through these blocks keying off that text, then pulling out needed elements.
There's no while loop here yet, as I'm running into the error just setting up the first condition.

Run-time error '91': Object variable or With block variable not set

Here's the section of code from within the Sub, with the error coming in the final line assigning cursorProject:
' store the next report to process
Dim nextReport As String
Dim sourceSheetName As String
Dim sheetSource As Worksheet
nextReport = rptMedia
' copy the worksheet into rptBurn and get that worksheet's name
sourceSheetName = GetSheet(nextReport)
Set sheetSource = Workbooks(rptBurn).Worksheets(sourceSheetName)
sheetSource.Cells.EntireRow.Hidden = False
sheetSource.Cells.EntireColumn.Hidden = False
Workbooks(rptBurn).Activate

' process the sheetSource into sheetCurrent
' set constants
Const constCursorKey As String = "Client Name"
Const constClientColumn As String = "B"
Const constClientNameOffset As Integer = 2
Const constProjectLeft As Integer = 2
Const constProjectRight As Integer = 52
' get range in Client Name column of project entries
Dim cursorStart As Long
Dim cursorEnd As Long
Dim cursorProject As Range
Dim rangeProject As Range
Dim rangeSearch As Range

cursorStart = sheetSource.Columns(2).Find(constCursorKey).Row + constClientNameOffset
' find the last project entry in the sheet
cursorEnd = sheetSource.Range("B" & Rows.Count).End(xlUp).Row
Set rangeSearch = sheetSource.Range(Cells(cursorStart + 1, constProjectLeft), _
                        Cells(cursorEnd, constProjectLeft))
cursorProject = rangeSearch.Find(What:=constCursorKey, LookIn:=xlValues, LookAt:=xlPart, _
                    SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False, _
                    SearchFormat:=False)

This is very sloppy currently as parts will be moved out to its own Sub called while iterating over the reports (hence nextReport is hardcoded here to a specific report name).  The various constants are fixed parameters of the reports.  The unlisted values like "rptBurn" are globals. The GetSheet function works well, but if you want to see it:
Private Function GetSheet(rpt As String) As String
   Workbooks.Open rootPath + rpt
   ActiveSheet.Copy after:=Workbooks(rptBurn).Sheets(Workbooks(rptBurn).Sheets.Count)
   GetSheet = ActiveSheet.Name
   Workbooks(rpt).Close
End Function

I've tried several variations on this.  The Locals all look promising up to the error.  I set the Hidden properties to False based on another post.  I've tried simplifying the call down to the basics and using With, like this:
    Set rangeSearch = Sheets(3).Range("B:B")
    rangeSearch.Select
    With rangeSearch
      cursorProject = .Find("Client Name")
    End With

But I'm always getting an error on cursorProject.  There are definitely many "Client Name" entries in the worksheet I'm testing.  I put in the Select to verify I'm grabbing the correct range; oddly I find that "B:AX" get highlighted (AX is the rightmost used column in the report) in the simple version, but the selection I expect in the original.  Regardless there are "Client Name" instances in either selection--I can select B4 and see "Client Name".
What am I doing wrong?

A: Cursorproject is an object variable (range). You can't simply assign a value to an object variable, you have to set it.
dim strSomeTextVarible as string
dim rngSomeCellsObjectVariable as range

strSomeTextVarible = "abc"

set rngSomeCellsObjectVariable = range("a1:c3")


text:
Bristol City head coach Johnson highlights importance of potential new training facility
The planning application is set to be approved
Connor Laing
Bristol City head coach Johnson has explained how important the new training ground will be to Bristol City
A decision on Bristol City's state-of-the-art training facility and 500-seater stadium looks set to finally be made today.
Bristol City manager Lee Johnson briefly spoke about the situation to Geoff Twentyman on BBC Radio Bristol's Sound of the City programme on Monday.
North Somerset Council's planning committee was expected to give the go-ahead for the club to build a new training centre in Failand during a meeting last month.
But members decided they would defer the decision for a site visit following safety concerns by Long Ashton Golf club.
Bristol City's new training ground: The plans, the delays and why it's so important for the Robins
Bristol City head coach Lee Johnson
Johnson believes this will be a positive step forward for Bristol City if given the go ahead.
"The club is moving in the right direction. Hopefully we'll get this planning through on the training ground reasonably soon because that's going to be important."
He also went onto say that it's not only important for the club that this happens and feels that Bristol City has had some catching up to do with regards to facilities and production of young talent.
Artists impressions of Bristol City's proposed new training ground in Failand, North Somerset. (Image: Copyright Unknown)
"We've got a lot of boys playing for England and we need the facilities in Bristol. It's a big problem compared to other big cities to get those facilities to produce top class players."
The club has produced some great young talent over recent years. Most notably Joe Bryan and Bobby Reid who have both recently left the club to play in the Premier League. Even more recently, defender Lloyd Kelly has come through the system and is playing for the England under-20 side with teammate Jay Dasilva, who is on loan from Chelsea.
Despite the positives it would bring to the city, the decision was delayed until now but could be resolved today.
Bristol City's new training ground - the plans and how it will look
Long Ashton Golf club in Clevedon Road shares a common boundary with the proposed training ground and has said it is concerned about the possibility of stray golf balls hitting players.
It took less than 10 minutes for councillors to vote for a deferral during August's planning meeting once the scheme was open for member discussion.
Now the scheme looks set to be given the go-ahead at a meeting today (Wednesday) after officers recommended the plans for approval once again.
A 500-seater floodlit venue at the new training ground
The proposals for the new training centre include three full-size pitches, seven-a-side and goalkeeping pitches, a medical centre, gym, sports science facility and space for physiotherapists and coaches.
Also on-site will be changing rooms, a kitchen and dining area, grounsdman's compound, 142 parking spaces and a coach drop-off site.
Fans will be able to cheer on the under 23s from the stand during ticketed matches.
The Robins currently share facilities with Queens Elizabeth's Hospital (QEH) School on Clevedon Road, but in December club bosses announced they had submitted a planning application to develop a field next door.
Bristol City's chief executive Mark Ashton has previously said the development of Failand was "key to Bristol City's future".
Failand training ground plans saga
Fans hit back at Failand plan objections
The 287 objections to plans
How it's key to future success
Can't wait to get started
First look at plans
Approval expected
How it will look
Currently the first team and under 23s share pitches with the QEH School and the under 18s play at SGS College Wise Campus site in Filton.
Ashton said the training facility was critical for getting the best out of players and developing "home-grown talent".
The plans received 300 objections – with many coming from members of Long Ashton Golf Club.
But around 200 people also sent letters of support for the proposals, and most nearby residents appear to support the plans.
North Somerset Council
Filton

redpajama_set_name: RedPajamaCommonCrawl


text:
Il termine costumbrismo (dallo spagnolo costumbre, ossia "costume") indica un genere di letteratura narrativa e di pittura sviluppatosi in Spagna nella prima metà del XIX secolo. Esso si contraddistingue per l'interesse nel creare un'opera d'arte prendendo spunto dai costumi e dagli usi popolari.

Storia
Sebbene nella sua ricerca intitolata Los Costumbristas españoles il critico Correa Calderón indichi il XVII secolo come periodo di nascita del genere in questione, generalmente gli storici preferiscono postdatare alla fine del XVIII secolo, il momento storico in cui sia il teatro, grazie a Ramón de la Cruz e ad Juan Ignacio Gonzáles del Castillo, sia la narrativa, grazie invece a J.A. de Iza Zamácola, sull'esempio delle arti figurative proposte nella stessa epoca da Goya, innalzarono i costumi popolari al livello di tematica pregnante e fondamentale e quindi di strumento culturale.

L'età d'oro del costumbrismo si rivelò quella immediatamente seguente, in concomitanza con il fiorire e la diffusione del movimento romantico, durante il quale le scene popolari acquisirono una propria dimensione ed un proprio spazio letterario, raggiungendo notevoli risultati nelle opere di Ramón de Mesonero Romanos e nei racconti di Mariano José de Larra.

Curiosamente, quella che viene definita l'opera costumbrista più emblematica è una miscellanea, intitolata Los Españoles pintados por si mismos pubblicata nel 1843, che raccolse lavori non solamente dei più importanti scrittori dell'epoca, ma anche illustrazioni e disegni dei maggiori pittori del tempo, tra i quali Leonardo Alenza, Fernando Miranda, Antonio Cabral Bejarano (1798-1861), Francisco Lameyer (1825-1877), Vicente Urrabieta y Ortiz e Calixto Ortega.

Verso la metà del XIX secolo sorse in Spagna la letteratura realista, in qualche modo derivata da quella costumbrista, ma portante notevoli differenze nello stile, nella tecnica narrativa, nella trama e nella caratterizzazione dei personaggi. Tra i pittori che abbracciarono questa corrente vi è José Bermudo Mateos.

L'ultima opera propriamente costumbrista spagnola può ritenersi l'Escenas montañesas di José María de Pereda, anche se già nei suoi lavori le scene realistiche, pre-naturalistiche e le istanze sociali presero il sopravvento sul gusto del folclore e dei costumi popolari.

Il costumbrismo conobbe un nuovo periodo florido dopo la sua diffusione nelle Americhe nel corso dell'Ottocento e del Novecento, che da un lato influenzò considerevolmente lo sviluppo della letteratura ispanica e dall'altro rigenerò il costumbrismo con elementi autoctoni centro e Sudamericani.

Ancora oggi, in Messico, la frase «Se Franz Kafka fosse messicano, sarebbe costumbrista» viene comunemente usata sui giornali e sui mezzi di comunicazione di massa, per descrivere in modo sintetico ed efficace la situazione complessa del Paese.

Note

Bibliografia

Altri progetti

Collegamenti esterni

Letteratura spagnola
Correnti letterarie

redpajama_set_name: RedPajamaWikipedia


Electricity utility companies need to monitor the high voltage transmission towers for several reasons. There is often a need or desire to monitor the transmission voltages and currents to assist with the management of the transmission network. There may also be a need to monitor the physical stability of the tower by using accelerometers or seismic instruments which measure earth tremors, strong winds or perhaps vandals damaging the structure.
There are some instances where vandals damaged the towers by removing / stealing parts of the structure to be sold as scrap metal.
As well as having monitoring sensors it may be desirable to have some level of video surveillance. Unidata has received many requests for enhanced remote monitoring with images for remote measurement industrial equipment. Such requests are driven by the need to see what is happening on the sites to confirm measurement instrument readings, and to have a regular, perhaps daily, image of the tower to check for any damage. The ambient weather conditions can also be measured, like temperature, humidity, wind speed and direction. This can be achieved simply by using modern easily installed, all-in-one, ultrasonic weather transmitter.
The voltage and current monitoring is routinely performed and can be accomplished by directly connecting measurement instruments to conductors or indirectly, by measuring field effect surrounding a high voltage conductor. There are many instruments designed to measure voltages directly, however installation of such devices requires special safety planning which may be difficult.
Simpler approach would be to use instruments that measure field strength in close proximity to conductors rather than directly connecting to them. Electrical field strength is dependent on the voltage of the power line and remains relatively stable with the line energized. The higher the voltage on the conductor – the stronger the electrical field around it. For example, a typical overhead distribution line at 11,000V (Volts) and 11m (meters) up in the air will produce average electric field strength beneath the line of (11,000V/11m) approximately 1000V/m. There are other factors affecting measurement, like electrical field decrease with an increase in distance from the line, but example above is just to give general idea of the process involved.
The tower stability can be measured using any general purpose accelerometer, which detects small movements in the tower structure. If the tower is in a region prone to earthquakes, seismic instrument can be added to monitor earth movements. For continuous monitoring of the site, a low resolution video camera or cameras can be added to take a photograph of the structure every hour as a permanent record of the structure. These images are available for engineers at a central location to be viewed and structure assessed for any possible damage.
All of the instruments can be used together to determine the stability of the structure, for example a brief disturbance in the structure would be recorded by the accelerometer and the data from all the sensors can be correlated to determine the likely cause. All of the instruments would be mounted on the tower structure, along with a small solar panel and backup battery so the power system remained independent.
Sensors can be connected to a Neon Remote Logger via SDI 12, Modbus, analog or digital inputs. Logger will scan / collect readings from the sensors on regular, custom specified or intervals. It will check for any unusual out of limits readings and routinely send data to a central Neon Server located at the electricity utility headquarters.
Logged data or alarms are sent using cell phone modem or satellite modem depending on network availability. Data is then displayed on a web browser to be viewed or could also be sent, perhaps once per minute, via web services or FTP to other processing systems for example to the main SCADA system used by the electricity utility.


This is really neat….I have been cooking corn in its husk in the microwave for years (3 min. an ear). The really tough part was husking it while it's hot. This man has come up with the solution. No silks remained on the corn.


text:
Q: PostgreSQL: Realizing columns depending on other tables I'm currently learning the basics of SQL and now I'm facing the following problem. The implementation of it will be in PostgreSQL.
Let's say you have the two following tables in your database:

*

*department(dpID:PK, ..., avg_salary)

*employee(eID:PK, ..., dpID:FK REF department, salary)

(PK = Primary Key, FK = Foreign Key)
So every employee has a salary and a department, every department should store the average salary of its employees (not just in a view).
Of course there should be some kind of update rule in the database, so when a new employee gets inserted, the avg_salary of the employees department gets updated / recalculated.
So when there are e.g. currently no employees in a department X, the avg_salary should be 0. After inserting an employee in department X with a salary of 1000, the avg_salary should be 1000.
Calculating the avg_salary wouldn't be a problem with a sql query.
SELECT AVG(e.salary) FROM empoyee e WHERE e.dpID = ...

But I'm stuck at finding a way to use this result to solve my problem.
So I would be very glad for ideas to realize the function of automatically (re-)calculating attribute values with the result of an aggregation function used on a different table.
Thank you and have a nice day! :)

A: I agree with nbk, you shouldn't use a function to recalculate.
What I would do is create a view. Something like this
create view deptview as select d.name, coalesce(avg(salary),0) from employee e right join department d on e.dpId=d.id group by d.name;

It will recalculate the average every time you use the deptview view
To see your data just
select * from deptview;

redpajama_set_name: RedPajamaStackExchange


text:
GoMonaghan
Promoting Sustainable Travel in County Monaghan
Rural Transport Service
Transport Funding for Community Groups
Walking & Cycling Strategy
Walking & Cycling Trails in Co. Monaghan
National Cycle Network
Ulster Canal Greenway
Active Travel Towns
Walking & Cycling Strategies
Go Monaghan
Go Blayney
Monaghan by Bus
Rural Hackney Scheme
National Route Planner
Reduced fares for 16-18 year olds
On Your Bike!
Bike Hire & Sales in Co. Monaghan
Go Walking
Hospital buses
Have you ever wondered where all those cars are going to, when you watch the traffic crawling through town and clogging up the streets?
Well, research shows that the vast majority of them are on journeys of under 5 miles!
Think about it: there are over 1,000 children under the age of 12 at school in Monaghan town: that's a lot of dropping-off and picking-up every day if everyone comes to school by car.
And then there's the people working in the town – there are over 300 people working in the County and Town Councils alone! Add to this all the people working in the shops, hotels, restaurants and bars….. that's a lot of journeys.
The Census 2011 says:
36,262 people in Co Monaghan over the age of 5 commute to either school or work every day
3,843 do so on foot
150 cycle
22,171 get to school or work by car!!
14,297 people said it takes them less than 15 minutes to make that journey, meaning that they live within 5 miles of their destination. Many of these journeys could be made by foot or bike. This would
un-clog the towns
reduce pollution
make it safer – eg fewer double-parked cars outside the schools to see around, and less stressed drivers taking more care as they pass through town
make the towns nicer places to be
The concept of an Active Travel Town is simple – an Active Travel Town is a town where people make as many local journeys as possible by sustainable means. The car takes second place – on the streets, outside the school gates, in our public areas – and the town is reclaimed by the people.
Of course, while the concept is simple, putting it into practice is far from it. It would be irresponsible to ask children to walk or cycle to school if there were not safe footpaths and cycle lanes in place, for example. So, becoming an Active Travel Town requires planning. There's also no point in providing loads of facilities if you can't convince people to get out of their cars, so we've got to plan how to motivate and reward people for participating in the initiative.
This planning process has already begun. In 2012, Monaghan County Council was awarded funding by the Dept. to start work on making the towns of Monaghan and Castleblayney Active Travel Towns. The first step was to engage with the local businesses, communities and schools to develop Walking & Cycling Strategies for the towns. These were completed in December 2012. The Strategies identified a number of actions which should be taken to support the people of the two towns in trying to make more journeys by sustainable transport means. This website will provide information on the various initiatives as they are rolled out.
You can view the Monaghan and Blayney Strategies here.
Funded by the Dept of Transport Tourism & Sport's Smarter Travel Programme
Have Your Say on the Proposed Cycle Network for Monaghan October 6, 2022
Almost €4 million for walking & cycling in Co. Monaghan announced April 2, 2021
New Walking & Cycling Strategy open to public comment March 31, 2021
McConnons bus service posts new timetable September 18, 2020
New daily Cavan Monaghan bus service August 31, 2018
Bike Week Monaghan
A Monaghan County Council Initiative
Glen Road
Mon - Fri 9.15am to 5.15pm


FeeFreeTicket is your best and last stop for Keith Purnell tickets without fees. For over 10 years we have been in beautiful New England selling tickets nationwide for Keith Purnell. We offer without a doubt the largest inventory online for all Keith Purnell tickets at prices that others resellers cannot compete with. Unlike many other ticket sites or ticket brokers, FeeFreeTicket.com will never add hidden fees or charges to your order and will guarantee your Keith Purnell ticket purchase with our No Worry Guarantee and No Service Fee Promise!
If you are looking for more information about Keith Purnell you should check the wiki, current news and videoes for Keith Purnell that we have listed below. Keith Purnell News, videos and wiki pages are here for your convenience and to help when searching for Keith Purnell tickets. When you need Keith Purnell tickets we are here!


Came across this deal as I was looking to get one of these for my new house.
Was best price of $299 but dropped over last few days.
This system has pretty good reviews.
100%, and these mesh points are not good for gaming at all.
Exactly this. One single Ubiquiti AP is going to crap all over these mesh systems. It's a gimick.
This m5 has access point mode as well, which is a very good future.
Looks like it is, Google let me down when doing a price search!
Very likely a higher total with mwave though, at least with shipping to SA.
Came out to $261.95 for me using Courier Delivery, so I guess it's same price.
I do prefer getting 'free postage' using Amazon Prime rather than know I'm wasting money on postage. It ends up costing the same but I feel better.
Seems they come with EU power adapters. Isn't it illegal to sell without an AU adapter?
I bought a 2 pack in January 2019 and it came with AU plug.
I read that although Google introduced the technology other company's have improved it.
Bargaingeek on 15/04/2019 - 12:10 Comment score below threshold (-5).
Kaboda on 15/04/2019 - 12:12 Comment score below threshold (0).
pc6673 on 15/04/2019 - 12:25 Comment score below threshold (0).
leetec on 15/04/2019 - 12:42 Comment score below threshold (0).
newdad on 15/04/2019 - 12:56 Comment score below threshold (-1).
Bargaingeek on 15/04/2019 - 13:19 Comment score below threshold (-1).
Namesareapain on 15/04/2019 - 13:37 Comment score below threshold (-1).
Namesareapain on 16/04/2019 - 10:26 Comment score below threshold (0).
I already have a Ubiquiti USG, managed switch and NanoHD upstairs at the front next to the modem. Unfortunately, down stairs isn't getting the strongest connection. Connecting another AP via ethernet downstairs isn't an option. Any recommendations for a different solution that doesn't require ethernet connection?
Have you tried EOP adapters?
You can't run a duct outside and down?


Located in Jacksonville, Texas and Ontario, Calif., Klein Products Inc. manufactures large capacity, mobile tank equipment and works closely with Caterpillar OEM Solutions to match their water tanks with Cat® bare chassis trucks.
Founded in 1957, Klein markets their rugged, reliable water trucks to construction and mining customers worldwide.
Klein's patented trapezoidal tank design is inherently safer. Its ingenious trapezoidal shape with wide bottom and narrow top enables excellent operator visibility all around the machine.
Its lower center of gravity combines with the tank's internal baffles to eliminate load surges (when less than full) and reduce the chance of tipping while providing greater vehicle stability and control when negotiating uphill / downhill grades and turns.
Klein Products manufactures large capacity, mobile tank equipment and works closely with Caterpillar OEM Solutions to match their water tanks with Cat® bare chassis.
Importantly, to ensure Klein tanks perform well and withstand the rigors of heavy-duty construction sites and harsh mining environments, Klein also designs and builds all its own high quality pumps, valves and related discharge equipment along with their corrosive-proof aluminum spray heads. One of the options Klein offers is a joystick-controlled water cannon for watering down stockpiles, cleaning out dump bodies, reducing dust in loading areas and even for firefighting.
Klein tank designs match up with all Cat Off-Highway Trucks as well as Cat Articulated Trucks and offer capacities from 5,000 to 40,000 gal. Sales, service and product support for Klein tanks are delivered worldwide through the reliable Cat dealer network that delivers parts either same day or next day anywhere in the world.
"Using the Cat dealer network is the best way for us to service our customers," says Barry McManus, president of Klein Products, Inc.
Klein prides itself on the fact that all its water discharge packages are tailored to the specific needs and applications of its customers.
Owned and operated by Arch Coal, mighty Black Thunder mine in the Power River Basin of Wyoming produces coal around the clock – 24 hours a day, 365 days a year – amounting to millions of tons of coal annually. This large coal mining complex depends on a fleet of Cat® powered Ground Force trucks to support the continuous operation of heavy machinery.
Maintaining fleet efficiency and peak production requires oversized support trucks that refuel and maintain equipment, move machines efficiently around the site and minimize haul road dust. Wilpinjong Mine in Australia relies on a fleet of Cat powered Haulmax support trucks to keep their operations running around the clock.
The Cat® Water Delivery & Control System (WDS) is available for the Cat 777G and 785D Off-Highway Truck Bare Chassis, a dependable, safe and fuel efficient truck platform.


One Stop For All Your Food Needs!
It's worth the drive to enjoy the tasty food and the country feel at the One Way Café. Nestled in picturesque Juniata County of PA, we are your Coffee Shop and Café here in the country at the Walnut Cheese Nook!
We serve a high quality, specialty coffee that is imported and roasted in Lancaster County PA. We make espresso based drinks such as lattes, mochas as well as smoothies, milkshakes, etc.
The Walnut Cheese Nook also provides deli meats and cheeses, cream cheese spreads, party platters, bulk foods, fresh baked goods made in our bakery and much more.
Stop by today and enjoy a delicious meal in our café or order for take out!


描述: Lightstecis a LED Strip Light,LED Linear light system,LED Aluminum Profile manufacturer factory which founded in 2008.We have our own factory and R&D Dept.Local in Guangdong,China.Near Hong Kong,Shenzhen and Guangzhou. We mainly focus on Designing,producing and shipping High quality LED lighting products.All of our LED Products are produced by a team of skilled crafts people and manufacture from the finest materials available.Each finished piece is meticulously inspected and packaged to ensure delivery of only the highest quality product to the customer.Our quality and design are supported by our considerate customer service. Customer satisfaction is our primary goal and we will work hard to accommodate any request and to serve our clients at the highest level possible.No matter you are an Architects,Dealers,Designers or Corporate Buyers,Wholesaler.we will serve you with the same level of care and quality products.Welcome to our factory!


text:
Famous Restaurant Chains That Are Hard to Find
Michael B. Sauter
24/7 Wall St. July 31, 2013
Many of America's once-great restaurant chains are now impossible to find. While McDonald's and Subway locations continue to multiply, Howard Johnson's and Chi-Chi's are all but forgotten.
24/7 Wall St. relied on food industry consulting and research firm Technomic to identify famous American chain restaurants that have either completely vanished, moved overseas or have only a few locations left. In their heyday, these restaurants had hundreds, if not thousands, of locations. As of 2012, most of these once successful brands had just 25 stores or fewer across the country.
Most of the chains that make the list are casual dining restaurants like Chi-Chi's and Ground Round. According to Technomic's Vice President Darren Tristano, their troubles were due to increased competition from larger, more successful operations such as Applebee's, TGIF, Olive Garden and Red Lobster.
America's Worst Companies to Work For
"Those brands did better in terms of expansion, and set the bar much higher," Tristano said. "It's really a combination of greater unit expansion. Those that couldn't keep up and didn't have the franchises or the financing struggled."
Many of these restaurants experienced sudden declines in the early 1980s. Sambo's was once a national brand with more than 1,000 locations. However, a combination of financial problems and a troubling association with racist imagery used in advertisements forced Sambo's into bankruptcy and resulted in the closure of more than 400 locations.
For other chains, the troubles began much later. In the case of Bennigan's and Steak & Ale, a slowing economy during the recession led to lower earnings and an inability of their parent company to service debt. As a result, the chains were liquidated with little warning.
The Best States to Be Unemployed
Bennigan's parent company, Metromedia Restaurant Group, filed for Chapter 7 bankruptcy in 2008. All Steak & Ale locations were closed. The more than 200 Irish-themed locations dropped to just a few dozen. The company has emerged from bankruptcy under new ownership. While some are optimistic about the brand's prospects, "recovery generally means you've hit bottom, but in their case, they've continued to close underperforming units," Tristano warned.
To determine the famous restaurant chains that are now hard to find, 24/7 Wall St. identified brands that, according to Technomic, had hundreds of U.S. locations at their peak between the 1980s and 1990s and a national presence. As of 2012, these restaurant chains could have, at most, only a small number of locations.
These are famous restaurants chains that are hard to find.
1. Howard Johnson Restaurants
> Restaurants in 2012: 2
> Restaurants in 1980: 129
> Year founded: 1927
Howard Johnson's was, for decades, one of the most well-recognized American businesses in the country. The franchise expanded from a single ice cream store located in Quincy, Mass., in 1927 to an empire of restaurants and hotels. By the 1970s, there were more than 1,000 Howard Johnson's restaurants in the United States. Currently, there are only two restaurants in the entire country: one in Bangor, Me., and one in Lake Placid, N.Y. One of the factors contributing to the decline of the chain was the decline of the motel industry nationwide, according to Tristano. The chain has since shifted focus to its hotel division and now maintains properties across the world.
2. Mister Donut
The Most Corrupt Countries in the World
Harry Winouker founded Mister Donut in 1955 after dismantling a failed business venture with his brother-in-law, Bill Rosenberg, the future founder of Dunkin' Donuts. By 1970, there were hundreds of franchised locations across the United States, and the brand was acquired by International Multifoods, at the time one of America's biggest food companies. In 1983, Japan's Duskin Co. Ltd. bought the rights to Mister Donut for all of Asia. Since then, the brand has caught on in Japan, where it is the largest donut chain, with more than 1,100 stores. Worldwide, there are more than 10,000 Mister Donut stores. But as the brand expanded abroad, it vanished at home. Currently, there are no Mister Donut locations in the U.S., after most were acquired in 1990 by Dunkin' Donuts' former parent company Allied-Lyons. "The growth of Starbucks and Dunkin' Brands, and their domination of the U.S. has certainly forced out Mister Donut, and other donut places," said Tristano.
3. Steak & Ale
Steak & Ale was once, alongside Bennigan's, part of Pillsbury's chain restaurant holdings. In 1980, there were just under 200 Steak & Ale locations in the United States. But by 2008, that number had dropped to 50. That is when S&A Restaurant Corp., which ran the chain as well as Bennigan's, filed for bankruptcy. Although Bennigan's has been revitalized and continues to operate, Steak & Ale no longer exists. Both chains were conceived by Norman E. Brinker, who also helped to popularize Chili's and built Brinker International Inc. (EAT), one of the nation's largest food companies.
4. Chi-Chi's
> Restaurants in 1980: 81
Chi-Chi's was founded in Minneapolis in 1975 as a family-style Mexican restaurant. By 1985, the company had nearly 200 locations around the country. But, according to Tristano, the success of other Mexican-themed chains like Taco Bell and Chipotle began to chip away at the company's success. In 2011, Chi-Chi's filed for bankruptcy. At the time of the filing, the chain had roughly $100 million in debt. Shortly after the filing, a hepatitis A outbreak at a location resulted in several deaths. All franchise restaurants have since closed. However, "Chi-Chi's still has their brand licensed for salsa and tortilla chips. So the brand is still around, even though they have no restaurants," Tristano added.
5. Ground Round
Ground Round was founded as a pub-style restaurant in 1969 with a small menu and casual environment. The chain was once part of the 1,000 Howard Johnson's stores. Now, the brand is owned by its own franchisees, who acquired the assets of Ground Round in a bankruptcy sale in 2004. As of 2012, there were just 25 locations nationwide, mostly in northern states, with four in North Dakota and seven in Minnesota. According to the Farmington Independent, a new Ground Round location will open in Farmington, Minn., in September. The restaurants were located primarily in more rural locations and were forced out by other national chains like Buffalo Wild Wings and Applebees, according to Tristano.
Cities Where the Most People Have Heart Attacks
6. Sambo's
> Restaurants in 1980: 1,118
Sambo's was named after its two founders, Sam Battistone and Newell "Bo" Bohnett. At one point the chain included 1,118 restaurants. However, many customers, especially in the Northeast, felt uncomfortable with the name and the company's history. In its early marketing efforts, Sambo's used the principal character from Helen Bannerman's 1899 book "Little Black Sambo," which has been widely criticized for promoting negative racial stereotypes. Issues of political correctness were damaging to the brand as early as the 1970s, Tristano said. The chain suffered from financial troubles and filed for bankruptcy in late 1981 after failing to restructure its debt. The first Sambo's in Santa Barbara, which is owned by the founder's grandson, remains in business.
7. Bennigans
Irish-American-themed restaurant Bennigan's was founded in 1976. It was owned for a time by the Pillsbury Corp., which also owned Burger King. After finding success in the 1990s, Bennigan's began facing heavy competition from other casual family chain restaurants such as Chili's, Applebee's and TGIF. In 2008, Bennigan's filed for bankruptcy and closed more than 200 franchises. Currently, there are just 32 Bennigan's locations in the United States. But the company has come out of bankruptcy under new ownership, and there may be hope for the future of the restaurant chain. Tristano noted, however, that the chain was still closing its weakest-performing restaurants.
The Most Dangerous Cities in America
Ten Brands That Will Disappear in 2014
Ten Cities Where the Poor Can't Get Rich
Duke of Sussex to continue his work with the RFL
Prince Harry to follow in Princess Diana's footsteps and be styled 'Harry, Duke of Sussex'
Takahiromiyashita The Soloist Men's Fall 2020


text:
Infrastructure Transport
Govt invites DPR for Telangana regional ring road
14 Apr 2021 Editorial Team
The Ministry of Road Transport and Highways (MoRTH) has issued a notification inviting a consultant for preparing a detailed project report (DPR) for the Regional Ring Road (RRR) in Telangana.
MoRTH issued the notification for a consultant to prepare the DPR for land acquisition details for the RRR, besides a report on the northern end of RRR covering a distance of 158 km.
Another notification has been issued by the ministry synchronising the Mahabubnagar-Kodangal-Tandur route via Chincholi in Karnataka with NH 65 and renaming it as NH-167N. Similarly, the Kothagudem-Yellandu-Mahabubabad-Nellikuduru-Tharoor-Valigonda route has been synchronised with Gourielli junction, Outer Ring Road on the outskirts of Hyderabad, and it has been declared as NH-930P.
The Telangana government had written to the Minister of Road Transport and Highways Nitin Gadkari to sanction funds for the development of National Highways in the state.
In the past, several requisitions were made to Gadkari regarding recognising the Kothagudem-Yellandu-Mahabubabad-Nellikuduru-Tharoor-Valigonda route as National Highway and developing it. In addition to these, appeals were also made to declare the Medak-Yellareddy-Rudruru route as a national highway.
The central government has approved this national highway as per the route map suggested by Chief Minister K Chandrasekhar Rao. This new national highway will facilitate the connectivity of new districts with Hyderabad. It will reduce both time and distance for the travellers, besides aiding in smooth transportation of goods.
Also read: Ring road to link all districts with state capital
Also read: Centre signs up with JICA for Chennai Ring Road
You have 2 FREE Article(s) left
Access Unlimited Content with Subscription
Regional Ring Road (RRR)
Detailed Project Report (DPR)
Ministry of Road Transport and Highways (MoRTH)
The Ministry of Road Transport and Highways (MoRTH) has issued a notification inviting a consultant for preparing a detailed project report (DPR) for the Regional Ring Road (RRR) in Telangana. MoRTH issued the notification for a consultant to prepare the DPR for land acquisition details for the RRR, besides a report on the northern end of RRR covering a distance of 158 km. Another notification has been issued by the ministry synchronising the Mahabubnagar-Kodangal-Tandur route via Chincholi in Karnataka with NH 65 and renaming it as NH-167N. Similarly, the Kothagudem-Yellandu-Mahabubabad-Nellikuduru-Tharoor-Valigonda route has been synchronised with Gourielli junction, Outer Ring Road on the outskirts of Hyderabad, and it has been declared as NH-930P. The Telangana government had written to the Minister of Road Transport and Highways Nitin Gadkari to sanction funds for the development of National Highways in the state. In the past, several requisitions were made to Gadkari regarding recognising the Kothagudem-Yellandu-Mahabubabad-Nellikuduru-Tharoor-Valigonda route as National Highway and developing it. In addition to these, appeals were also made to declare the Medak-Yellareddy-Rudruru route as a national highway. The central government has approved this national highway as per the route map suggested by Chief Minister K Chandrasekhar Rao. This new national highway will facilitate the connectivity of new districts with Hyderabad. It will reduce both time and distance for the travellers, besides aiding in smooth transportation of goods. Image Source Also read: Ring road to link all districts with state capital Also read: Centre signs up with JICA for Chennai Ring Road
NIIF may buy equity in Ashoka Buildcon HAM road asset for $100 mn
National road safety: Govt to set up advisory body
Telangana allots Rs 1,200 cr to ramp up water supply in Hyderabad
Hyderabad Regional Ring Road: NHAI extends bidding date till June 2
Ring road to link all districts with state capital
The 'Smart' Response to COVID-19
The Scope for Automation


text:
Drug to treat Lou Gehrig's disease shows promise in curing melanoma
01/26/15 3:07am Mike Makmur and Harshel Patel
Nearly 76,000 people were diagnosed with melanoma in 2014, according to the National Cancer Institute website.
Suzie Chen, a professor in the Ernest Mario School of Pharmacy, uses mouse models to study how melanoma progresses from its initiation to the possibility of metastasis, or the spread of a cancer or disease to another organ not directly connected to the cancer or disease. They then move from mouse models to human cell cultures in an effort to gain knowledge to use for human patients, she said.
While more than 900,000 people were diagnosed with melanoma in the United States by 2011, about 90 percent lived at least 5 years after diagnosis. Chen is helping lead the fight to make melanoma fully survivable and preventable.
"When studying [a] mouse model, we noticed that it has a lot of glutamate," she said. "Glutamate is an amino acid, and for a long time people knew cancer cells put a lot of glutamate into their surroundings. We also found this in the culture cells."
The main question about the glutamate, Chen said, was why there was so much extra glutamate in the cells. Since it was found in tumor cells and not normal cells, her team concluded that the glutamate promoted tumor cell growth.
James Goydos, a professor at the Cancer Institute of New Jersey, recommended that Chen test a drug used to treat Amyotrophic Lateral Sclerosis, also known as Lou Gehrig's disease, she said.
Tumor cells in a culture treated with this drug began to die off, Chen said.
Chen then tested the drug in an animal model.
"A culture cell in the closed system can only have one type of cell growing," she said. "When testing an animal, you have all the cells and interactions between different cells. You may get a different answer."
Upon moving to this "in vivo" system, she ended up seeing the same results, she said. After injecting a tumor and subsequently treating the animal with the drug, the progression of tumor growth decreased tremendously.
While the drug slowed down the growth of primary tumors, Chen said tumor metastasis, when the tumor spreads to other organs, was what usually kills patients. The tumor will generally metastasize in the brain, where it can become especially fatal.
"When a patient has a brain metastasis," she said, "they are not given a long time to live. Surgeons will remove the tumor from your brain, and they will expose the patient to gamma radiation to try and irradiate the tumor cells."
Taking the results they had gotten from the drug previously, Chen and her team created a brain metastasis animal model. By tagging the tumor cells, she was able to track the development of the tumor without killing the animal.
Chen's tests split the animal models into four groups that got different treatments: One group had both gamma radiation and the drug, one had only radiation, one had only the drug and the final was treated with nothing.
The tests showed combining the drug with gamma radiation had the highest efficacy in reducing the brain metastasis from growing, she said. The results told Chen's team that a similar process could work in humans.
Despite the known risk of melanoma and other skin cancers, many people do not take enough measures to protect themselves and their skin, said Melvin Pastrana, a School of Engineering sophomore.
He said he regrets not wearing sunscreen whenever he gets sunburned.
"I've been lucky enough to avoid melanoma for the short longevity of my life," he said. "I can't say much about the future. I should probably take more caution, but I'm not really inclined to remember to care."
Krupa Parikh, a School of Arts and Sciences senior, said she is not intensely worried about melanoma. Students who take the necessary precautions, such as applying sunscreen, should be fine.
Tiffany Kingsley, a School of Engineering junior, said people should worry more about their body and skin. Having had a precancerous birthmark removed, she is interested in a drug that can treat melanoma.
"There could be a bump that could be nothing, but it could also be something big," she said.
Chen said the next step is to attempt to try it in humans to see if it will actually help people. Since the drug is already FDA approved, she said, they can quickly move into clinics without having to wait through the approval process, which take up to 20 years.
Mike Makmur
Harshel Patel
5/29/2019 8:27pm
Daily Targum fails to pass referendum for 1st time since 1981
Brendan Brightman
5/21/2019 12:07am
Rutgers' 253rd commencement exercises honors largest-ever graduating class
Cap and Gown: Eagleton graduates look to future


The serial number on this Fullerton Model is a V013 series.
This bass delivers on the mystical Fullerton folklore. It's amazing. Plays great, sounds great, looks great, and is light as a feather at 8.0 lbs. She has that classic flat neck that these models are famous for. Please message me with any questions and I'll gladly answer them as quickly as I can.
All sales are final no warranty implied. I ship to the 48 states only.


Book Advertisement in Deccan Herald newspaper online by choosing from the below various advertising options available. The Ad Rates differs for every option. We have displayed Deccan Herald tariff in the easiest format to book ad easily.
These are the standard sizes Ad published in Deccan Herald Newspaper but you can also opt for any other size as you wish. Ad in Deccan Herald Main Edition are accepted for all days.
The Deccan Herald is a popular English Daily Newspaper publishing from various center in the state of Karnataka. It is published by The Printers (Mysore) Pvt. Ltd. the publishers of Parajavani, a leading Kannada newspaper in Karnataka. Every day Deccan Herald touches the lives of the people of Karnataka. Today the daily shapes the opinions and directs their actions. Deccan Herald was born 54 years ago when the first edition hit the streets on June 16, 1948. The newspaper was a reflection of the optimism, and a voice of the aspirations of a newly independent nation.
Book advertisement in Deccan Herald Online. Deccan Herald is the leading English Newspaper in Bangalore. We are Deccan Herald Authorized Advertising Agency. Our Media expert team helps you to advertise Classified, Display, Appointment, Tender Notice, Public Notice, Obituary, Classified Display & all other categories advertisement. You can give your ad in Deccan Herald through us as we offer special discount on Deccan Herald Ad Tariff. Advertising in Deccan Herald newspaper is one of the best option to target readers of Bangalore and Karnataka.
Follow few simple steps to book ad in Deccan Herald Newspaper ?
Check Deccan Herald Ad Rates which are mentioned in Rupees per square centimeter for the newspaper.
Upon receiving your consent on Deccan Herald Ad Rates quoted to you, we will send you an invoice with every payment options available to make payment. Both Online and Offline payment options are available.
The Ad Rates in Deccan Herald are different for every categories and it varies from location to location, which means the cost are low in the small cities as compared to that of the metropolitan ones. Deccan Herald has editions in Bangalore, Davangere, Gulbarga, Hubli, Mangalore, Mysore, etc. But the Advertisement tariff is generally calculated on the basis of ad type.


You Gutter cannot be debris free all the time. In the process, water will not get to flow smoothly. This may cause a lot of damage to your house. In the process, you will look for a gutter cleaning professional. There are quite a number of companies out there. As a result, you will have a hard time choosing the best company for you. Here are the factors to consider when settling for a gutter cleaning company.
The amount of money that you will have to part ways with in order to have the gutter cleaned should be put into consideration. Every company has its own charges. As a result, you are going to come across a company whose charges are too high. No one wants to have a gutter full of debris. However, you should not allocate the task to a company whose charges are overboard. You will come across companies that charge peanuts for these services. Such a company has a lot of disadvantages.
Secondly, you should ensure that you choose a company that is properly insured. This is because accidents happen each and every time. The process, if the professional does not have insurance coverage, you are the one to cater for the damages. This will end up costing you a lot of money. That is why you should confirm the company's insurance from the relevant company.
The company's reputation should be put into consideration. The company has definitely been in business for a number of years. As a result, you will be in a position to gauge the competency level based on the previous work done. As a result, when you settle for a company with a great track record, you will be assured that they will do a good job.
You should delegate the task to a company which handles polishing. You will realize that there is tar which tends to stick on the gutter. If the company delivers polishing services, it will give the gutter a new look.
You should read online remarks. There are individuals who share their engagement with a certain professional. In the process, you will gather more info about the company. You will be assured that the gutters are thoroughly cleaned if you settle for a highly rated company.
It is crucial that you get guidance from the people you engage with day by day. You may have a friend that interacts with a gutter cleaning professional. This will ensure that you get the best guidance. As a result, the decision-making process will be a piece of cake.


text:
Ball State University Alumni Center photographs and moving images
Ball State University Archives
This collection includes photographs, slides, and video recordings of events at the Ball State University Alumni Center ranging from 1997 to the present.
Materials in English.
Biographical Note / Historical Note / Administrative History
Built in 1997 the Alumni Center houses the offices of Alumni Programs and is fully equipped to hold conferences, receptions, and events. Its features include a major assembly hall, conference and meeting room space, a board room, the Alumni Library, and a 47-foot-high glass conservatory. The building was designed by internationally renowned architectural firm Pei, Cobb, Freed, and Partners, designers of the addition to the Louvre and the Holocaust Museum in Washington, DC. The project architect was James Freed.
1 Cubic Feet
Arranged in the following series:
Series 1: Slides and photographs
Series 2: Moving images recordings
Box: 1 (Text)
Part of the Ball State University Archives Repository
http://cms.bsu.edu/academics/libraries/collectionsanddept/archives
Alexander M. Bracken Library
2000 W. University Avenue
Muncie Indiana 47306 USA
Ball State University Alumni Center records, Archives and Special Collections, Ball State University Libraries
Ball State University Alumni Center records, Archives and Special Collections, Ball State University Libraries https://archivessearch.bsu.edu/repositories/4/resources/2202 Accessed January 20, 2022.


(Cape Town, 23rd August 2016) EduSA has submitted court papers challenging the South African government and policy makers about their failure to make proper allowance for visas for international students wishing to enter South Africa to study English as a foreign language.
EduSA is the national association of English language schools in South Africa. Its 24 members are English language schools that teach English as a foreign language to foreign nationals, who come to South Africa for weeks or months at a time. According to chairperson Johannes Kraus, this brings hundreds of millions of Rands in foreign investment to South Africa.


text:
Die Fletcher-Nunatakker sind zwei Nunatakker im westantarktischen Ellsworthland. Sie liegen 3,3 km südwestlich des Barker-Nunatak in der Gruppe der Grossman-Nunatakker.

Der United States Geological Survey kartierte sie anhand von Luftaufnahmen der United States Navy aus den Jahren zwischen 1965 und 1968 sowie Landsataufnahmen von 1973 bis 1974. Das Advisory Committee on Antarctic Names benannte sie nach dem US-amerikanischen Kartografen James B. Fletcher, der gemeinsam mit seinem Kollegen Kenneth Barker das Satellitenvermessungsteam des United States Geological Survey auf der Amundsen-Scott-Südpolstation im antarktischen Winter 1977 bildete.

Weblinks
  (englisch)
 Fletcher Nunataks auf geographic.org (englisch).

Nunatak
Grossman-Nunatakker


text:
Building a Retirement Plan: Here Are the First 3 Steps
Dow Tumbles, Tech Stocks Slump As Energy Price Surge Stokes Inflation Fears
A surge in global energy prices is stoking inflation concerns that could stall the post-pandemic recovery, putting Wall Street on the defensive in early Wednesday trading.
Martin Baccardax
U.S. stocks slumped lower Wednesday, and look poised to give back all of yesterday's gains, as a surge in global energy prices adds to inflation concerns that could stall the post-pandemic recovery.
Stocks were given some support, however, by a stronger-than-expected reading of private sector jobs gains for the month of September, with ADP reporting the addition of 568,000 new positions last month.
With oil prices trading at the highest levels in seven years, thanks in part to price spikes in coal and natural gas that has accelerated energy switching in major economies around the world, benchmark government bond yields are moving north in response to the anticipated inflation effects of the rolling energy crunch.
In the UK, where the nation's power grid relies heavily on natural gas imports, prices surged by 37% on Wednesday alone to a fresh record high of more than $40 per British Thermal Units, a level that is around eight times higher than spot prices in the United States and the equivalent of around $220 for a barrel of crude oil.
Benchmark 10-year Treasury notes yields jumped to 1.552% in overnight trading, before easing to 1.511%, with investors now concerned for both the energy-related impact on inflation and the slowing growth prospects of power shortages around the world.
At the same time, the Atlanta Federal Reserve's GDPNow forecasting tool, a real-time indicator of U.S. growth, fell to 1.3% in its last reading, with consumption pegged at just 1.1%.
"The beat on private payroll numbers is a positive but there's no shortage of catalysts out there that could move the market; surging energy prices, debt ceiling impasse, and booster uncertainty," said Mike Loewengart , managing director of investment strategy at E*Trade Financial. "And positive labor market data comes with the implication that the Fed can tighten policy at a quicker pace. But the fact that hiring is up, shouldn't be discounted—it's definitely a good thing in terms of recovery."
Stocks Slump, Energy Prices Rip, Zuckerberg Hits Back - 5 Things You Must Know
The Dow Jones Industrial Average slumped 355 points by mid-dat trading while the broader S&P 500 fell 35 points.
The Nasdaq Composite futures, meanwhile, fell 77 points with index heavyweights Apple (AAPL) - Get Free Report marked 1% lower at $139.80 each.
Facebook (FB) - Get Free Report shares also extended their recent decline, falling 2% to $326.50 each even as CEO Mark Zuckerberg addressed both accusations from a whistleblower that the social media giant prioritizes profits over people, as well as a crippling error that shut down its platforms for six hours earlier this week, in a rare public post late Wednesday.
Constellation Brands (STZ) - Get Free Report shares fell 0.4% higher after the Corona and Modelo beer maker posted weaker-than-expected second quarter earnings, but topped Street revenue forecasts and boosted its full-year profit outlook.
WTI futures for November delivery were last seen $1.37 lower on the session at $77.56 per barrel while Brent contracts for December, the global pricing benchmark, slipped $1.36 to $81.19 per barrel, near the highest since 2014.
Natural gas prices are on the move, as well, surging nearly 40% in a single day in the United Kingdom and rising nearly 1.5% in the U.S. to $6.40 per British Thermal Units.
Henry Hub Remains the Center of Natural Gas Markets
In overseas markets, energy price surges in Europe, as well as a disappointing reading for Germany's August exports, clipped the region-wide Stoxx 600, which fell 1.9% in late-morning trading in Frankfurt.
Overnight in Asia, where markets in China remain closed for the Golden Week holiday celebrations, Japan's Nikkei 225 slumped 1.05% to close at a six-week low of 27,528.87 points while the region-wide MSCI ex-Japan benchmark fell 0.94% to test the lowest levels in nearly a year.
Follow mdbaccardax


text:
House Members Urge Trump to Appoint Anti-Semitism Envoy
WASHINGTON – A bipartisan group of 167 Members of Congress are calling on President Donald Trump to keep the State Department's Special Envoy to Monitor and Combat Anti-Semitism in a letter released on Monday.
"As Members of Congress who care deeply about anti-Semitism at home and abroad, we urge you to maintain and prioritize the appointment of the Special Envoy to Monitor and Combat Anti-Semitism," the letter states. The initiative was spearheaded by Representative Eliot Engel (D-NY), Christopher H. Smith (R-NJ), Nita Lowey (D-NY), Ileana Ros-Lehtinen (R-FL), Ted Deutch (D-FL), and Marc Veasey (D-TX).
According to a Bloomberg report last month, the White House was considering eliminating the Anti-Semitism Envoy in addition to other budgetary cuts.
Last year, anti-Semitic acts plagued Jewish communities across the world. In Paris, a Jewish boy was physically assaulted near a Synagogue and called a "dirty Jew," a Holocaust memorial was vandalized in Hungary, and a 54 year Uruguay Jewish old man was stabbed to death in a hate crime.
The United States has also witnessed a recent spike in anti-Semitic incidents including bomb threats of JCCs and Jewish cemetery vandalisms.
"The Office of the Special Envoy enables the U.S. to show the world its commitment to these ideals, particularly at a time when anti-Semitism is dangerously on the rise," the letter explains.
Former Special Envoy Ira Forman told Jewish Insider on February 28, "I can't believe someone at the White House won't have better sense than to realize that this is a disaster. I just can't believe that they would even think of this given the relatively small budget needed to run this office."


text:
Q: Why does Typescript complain that an object is not assignable to its type? When running the following TypeScript code:
type valueType = {[key: string]: number} | {[key: string]: {[date: string]: number}} | {[key: string]: string;}

const myData1: valueType = {
  "name": "Eduardo",
  "city": "Miami",
  "state": "FL",
  "age": 22,
  "progress": {"2018": 67, "2019": 76, "2020": 89}
}

TypeScript complains that the object is not assignable to the type valueType although I explicitly tell it can have different types inside the object. What would be the proper way of allowing multiple different types inside an object?
This is the warning I get:
Type '{ "name": string; "city": string; "state": string; "age": number; }' is not assignable to type 'valueType'.
  Type '{ "name": string; "city": string; "state": string; "age": number; }' is not assignable to type '{ [key: string]: string; }'.
    Property '"age"' is incompatible with index signature.
      Type 'number' is not assignable to type 'string'.

Thank you!

A: { [key: string]: number }

This type says that all properties must be a number.
{ [key: string]: { [date: string]: number } }

This type says that all properties must be an object, all of whose properties are numbers.
{ [key: string]: string; }

This type says that all properties must be a string.
type valueType =
    | { [key: string]: number }
    | { [key: string]: { [date: string]: number } }
    | { [key: string]: string; }

This type says that it is one of the three above possibilities. Meaning it must be all numbers, all string, or all objects.
It does not allow you to mix and match these.
So I think you have the union in the wrong place. You want one object type, but the properties could be any of the three possibilities.
type ValueType = {
  [key: string]: number | string | { [date: string]: number }
}

Playground

But if you wanted to type this particular bit of data more strictly, you can do that in one simple interface:
interface ValueType {
  name: string
  city: string
  state: string
  age: number
  progress: { [date: string]: number }
}

Playground

A: The problem with the valueType type in your code is that you're telling typescript that the type will have key-value pairs where the keys are strings and all values are either numbers or strings or of the type {[date: string]: number}}. But what you need is a type that has string keys and number/string values in the same object.
Try this:
type valueType = {[key: string]: number | string | { [date: string]: number }};

const myData1: valueType = {
  "name": "Eduardo",
  "city": "Miami",
  "state": "FL",
  "age": 22,
  "progress": {"2018": 67, "2019": 76, "2020": 89}
}

If you want your type to have fixed keys:
type valueType = { name: string, city: string, state: string, age: number, progress: { [date: string]: number } };


This class is the common ancestor for all window classes used by Cuberite. It is inherited by the cLuaWindow class that plugins use for opening custom windows. It is planned to be used for window-related hooks in the future. It implements the basic functionality of any window.
Note that one cWindow object can be used for multiple players at the same time, and therefore the slot contents are player-specific (e. g. crafting grid, or player inventory). Thus the GetSlot() and SetSlot() functions need to have the cPlayer parameter that specifies the player for whom the contents are to be queried.
Windows also have numeric properties, these are used to set the progressbars for furnaces or the XP costs for enchantment tables.


Eva's back! Yay! That means that this week's Mr Linky will be over at A Striped Armchair so head on over to share your loot.
I have had another pretty big week loot wise (for me anyway). Here's what I got.
Jaran by Kate Elliott - Amanda from Desert Book Chick recently talked about this novel as a must read sci-fi. I am not a huge reader of this genre, but it sounded interesting enough to capture my attention.
The Oak Apple by Cynthia Harrod-Eagles - Reloot, yes again. This is the next book in the Morland Dynasty series and I really do want to read it.
Daughter of the Forest by Juliet Marillier - Another reloot.
The Little Stranger by Sarah Waters - Reloot. I haven't read Sarah Waters yet. I have borrowed her books a few times but keep on having to return it unread.
Never Love a Lawman by Jo Goodman - Despite the fact that Jo Goodman has quite a large backlist, my library only has a few of her books. Not too long ago I borrowed Beyond a Wicked Kiss, but even just reading the first pages it was obvious that the book was part of a series, and I can't stand reading books out of order. I therefore returned that book and instead borrowed this one.
The Strangely Beautiful Tale of Miss Percy Parker by Leanna Renee Hieber - When this book first came out I checked the library catalogue but there was no listing. I am not sure what made me check again, but now the book is in so I had to borrow it.
Island of the Swans by Ciji Ware - I started reading A Cottage by the Sea earlier this week, and before I was more than 50 pages in I was checking the library catalogue to see what other books they had by this author.
Coventry by Helen Humphreys - This is another book where it caught my eye when it was first released but I checked the catalogue and it wasn't there. I am glad it is now.
The King of Attolia by Megan Whalen Turner - Reloot again. This time I will actually read it!
Good loot! The Little Stranger is on my TBR and The Strangely Beautiful Tale of Miss Percy Parker.
Ooh, nice stuff there!! I also have a copy of The Little Stranger and Daughter of the Forest, so I will be interested in hearing your thoughts on them. I also read Coventry awhile ago, and liked it a lot. I hope you do too!
Lots of great looking loot. Hope you get to read those reloots!
I loved the Jaran series and read them all in quick succession after finishing the first book. I've since bought all the books in her next series though have hesitated to start it because (I know this sounds stupid) I have so much else I need to read that I can't afford to get sucked into a 7-volume series now. Daughter of the Forest and Little Stranger are also excellent.
I participated in the loot for the first time!
I just recently got hooked on Jo Goodman's books... I confess to reading those Grantham books completely out of order. Daughter of the Forest is in my TBR. I think I've put it off for the one book that leads to a great many others reason.
Wow! great loot. I can't wait to hear what you think about Ciji Ware's book.
Beth, I enjoyed Cottage by the Sea so I am now looking forward to reading more for her.
Hi Ludmilla! Nice to see you! I read a Jo Goodman book earlier this year and thought it was excellent. I intend to try and keep up with her new releases, especially those Western romances!
Kritter, welcome to Library Loot.
Sarah, unfortunately this is the only book in the library by Kate Elliott, but if I like it enough then I may consider trying to get hold of more from her.
Oh, you've read Coventry already Zibilee. Cool! I have wanted it since I first heard of it.
Amy, I am really looking forward to Strangely Beautiful.
I haven't read any Sarah Waters yet, either but I did find Little Strangers at Half-Price books a couple of months ago. Now to find the time to read it!
LOVE Daughter of the Forest! And Sarah Waters! I'm reading her books in published order, though, so haven't gotten to The Little Stranger yet (Night Watch is next up for me). The title and cover of The Strangely Beautiful Tale of Miss Percy Parker looks enchanting; I hope you read that one so you can tell me whether or not to read it!


What Antiperspirant have you most recently used?
What Toothpaste have you most recently used?
What type of Shaving product did you most recently use?
Would you like to add any feedback on the Athlete Pack?
To close the feedback loop, we would like to ask you these 4 questions again in about a month. Please check the box below to let us do that.
I am willing to answer the same 4 questions in a month to help P.W. Leopard gain more feedback to better their service.


"Misleading warnings about common beverages will do nothing for real public health challenges like obesity and diabetes."
SB 300 will probably face an uphill battle, given the past performance of similar bills in California. In 2016, Monning introduced a similar bill—Senate Bill 203—that failed to advance out of the Senate Health Committee. Similar bills introduced in 2014 and 2015 also failed to advance.
Other efforts to curb sales of sugary beverages in the state have had mixed results. In 2014, voters in Berkeley approved a soda tax measure that charges retailers 1 cent for every ounce of sugary drinks sold within the city limits.
In 2012, voters in the cities of Richmond and El Monte rejected ballot measures calling for a similar tax on sugary drinks.


As always, you can create at least two cards from this Topper Set, with the ability to create more depending on the size of your card and how you use your elements.
Our adorable Polar Pals is a soft and snuggly Topper Set that will melt away any winter blues!
Our Polar bear pup plays in the snow, making a super cute snowman buddy. While another scene sees two Polar Pals snuggling up cosily under the silvery moonlight.
The gorgeous shimmer of blues and grey are accentuated with real silver foil, for a truly sparkling luxury finish.
'Sending Love, Hugs and Christmas Cuddles', 'Wishing you a magical Christmas' and 'Let it snow' are the sweet sentiments that add the final touch to this gorgeous Topper Set.
With 15 individual elements you can create at least two cards from this Topper, with the ability to create more depending on the size of your card and how you use your elements.


Whatever the weather is, this one of a kind smokeless grill gives you that great backyard barbecue flavor while it promotes healthy, low-fat cooking. Premium non-stick surface with grill and griddle cooking zones sears perfect steaks, chops, burgers, veggies, or easily make pancakes and eggs in the morning, any fats drain away into the internal drip tray which could be filled with water for smokeless grilling. Large cooking surface feeds the whole family indoors or outdoors It features tempered glass lid for easy viewing or to be used as a wind shield. Take it anywhere you go, the grill shots close - briefcase style - to store away and has a strong carry on handle when on the move. Adjustable temperature control gives you perfect cooking with maximum control.


For your convenience, you are welcome to print and complete the Patient Registration Form to save time upon your arrival.
When your pet is admitted to the Small Animal Internal Medicine Service at the MSU-CVM Animal Health Center (AHC), you and your pet are under the care of our hospital care team, including board-certified veterinary internists, graduate veterinarians, certified veterinary technicians and other health care professionals who are trained to provide your pet with the highest quality of care.
Your animal will stay with you unless diagnostic testing or procedures are required. At any time, there is a whole team of clinicians and students who are working with your pet. Is your pet comforted especially by a scratch behind the ear? Do loud noises scare him? Let our team know your pet's preferences and quirks. One of the great benefits of a teaching hospital like ours is that your pet will have extra attention, both clinically and personally. Because there are so many professionals involved with your pet's care, we have the resources available to take your calls and answer your questions during his or her stay with us.
During a visit here, your pet will be treated by a team of doctors including attending veterinarians, residents, and interns. Veterinary medical students will also assist the team.
A board-certified veterinary specialist and MSU-CVM faculty member who leads the healthcare team of residents, interns and veterinary medical students and who is responsible for your pet's plan of care.
Veterinarians who have received their veterinary medical degree, have significant experience or training after graduation and have then elected to pursue advanced training in the specialty of Small Animal Internal Medicine.
Veterinarians who have received their veterinary medical degree and are now pursuing the first step towards receiving advanced training.
Senior (final year) students who will be involved in your pet's care as part of their preparation to become veterinarians but will only work under the supervision of the attending veterinarian.
It is not unusual for your hospital care team to rotate, and for several doctors to be treating your pet. Even the attending veterinarian may change during your stay. As new veterinarians join the team, they will introduce themselves. Although the veterinarians may rotate, the quality of your care will not diminish because the entire hospital care team is tightly coordinated to provide you with the best possible care.
We also recognize the importance of providing you with as much information as possible about the care your pet will be receiving at the AHC. Your hospital care team is available to answer questions or concerns you or your family may have about your pet's condition and treatment plans. During any of your consultations with any team member, please feel free to ask questions or seek clarification about anything you may not understand.


"Turning addicts into athletes," boasts the organization's slogan, written across the backs of its shirts on race day.
"Run for your life, run for yourself," others have inscribed across the chest.
Odyssey House runners at the 2018 NYC Marathon.
Odyssey House, a drug addiction recovery program based out of Manhattan and the Bronx, has had over 500 clients compete in 19 marathons since its inception in 2000.
Sunday was no exception, as organization CEO John Tavolacci and coach Andre Matthews were up bright and early to get their 40 runners situated at the starting village.
"It's a miracle story," said Tavolacci, a native Long Islander. "This group, last year, some were in prison, now they are in the program running the New York City Marathon.
"I always tell people, society gave up on this group, I tell them everyone has given up on you," he added. "This is your opportunity to prove them wrong. This is part of their recovery."
Sunday's runners were an amalgamation of numerous races and backgrounds, as well as varying ages -- spanning anywhere from 25 to 72 years old.
For Matthews, 58, it is his 21st marathon after two decades of sobriety.
Sylvia Hyman, Matthews' sister, has run the Marathon in support of her brother each of the last 10 years.
"It's absolutely incredible," said Hyman. "I was on the sideline watching Andre for so many years, I said if they can do it, I can do it.
Andrew Matthews and Sylvia Hyman at the 2018 NYC Marathon.
John Kane, 47, has been clean for one year and seven months, and he credits much of his progress to running.
"I got involved with the running team as a client at Odyssey House, I was addicted to opioid painkillers and heroin for a number of years," explained Kane. "Through hard work with counselors and joining the running team, I've overcome my addiction.


text:
export default class HeartRateService {
	constructor() {
		this.device = null,
		this.server = null,
		this.characteristics = new Map()
	}

	connect() {
		return navigator.bluetooth.requestDevice({
			filters: [{ services: ['heart_rate'] }]
		})
		.then(device => {
			this.device = device
			return device.gatt.connect()
		})
		.then(server => {
			this.server = server
			return server.getPrimaryService('heart_rate')
		})
		.then(service => {
			return Promise.all([
				this.cacheCharacteristic(service, 'body_sensor_location'),
				this.cacheCharacteristic(service, 'heart_rate_measurement')
			])
		})
	}

	disconnect() {
		this.device.gatt.disconnect()
	}

	cacheCharacteristic(service, characteristicUuid) {
		return service.getCharacteristic(characteristicUuid)
			.then(characteristic => {
				this.characteristics.set(characteristicUuid, characteristic)
			})
	}

	readSensorLocation() {
		const char = this.characteristics.get('body_sensor_location')
		return char.readValue()
			.then(value => {
				let sensorLocation = value.getUint8(0);
				switch (sensorLocation) {
					case 0: return 'Other';
					case 1: return 'Chest';
					case 2: return 'Wrist';
					case 3: return 'Finger';
					case 4: return 'Hand';
					case 5: return 'Ear Lobe';
					case 6: return 'Foot';
					default: return 'Unknown';
				}
			})
	}

	startHeartRateNotifications() {
		const char = this.characteristics.get('heart_rate_measurement')
		return char.startNotifications()
			.then(() => char)
	}

	stopHeartRateNotifications() {
		const char = this.characteristics.get('heart_rate_measurement')
		return char.stopNotifications()
			.then(() => char)
	}

	parseHeartRate(value) {
		return value.getUint8(1)
	}
}

redpajama_set_name: RedPajamaGithub


In the past, Emma Watson has shown an affinity for basic black and white, deploying neutrals to great effect on the red carpet—but her latest outfit fully embraced the season's power color. Making the trip to Twitter headquarters earlier this week for a roundtable with CEO Jack Dorsey and The Circle co-stars Tom Hanks and Patton Oswalt, the actress wore an off-the-shoulder blouse and wide-leg trousers from Gabriela Hearst, cutting a fine figure in head to toe red. She accented the look with gold All Blues hoops, an Ana Khouri ear cuff, and sky-high Manolo Blahniks, a sleek contrast from the Disney princess moments she embraced to promote Beauty and the Beast.
A monochromatic moment always makes an impression, and in Watson's case, an ethical one. Documenting every detail of the look on her The Press Tour Instagram, she continued to broadcast the message that great fashion can be environmentally conscious. Despite the head-turning color, Watson couldn't resist including one neutral touch—a streamlined trench, for which Hearst won the Woolmark Prize this year. It was a timeless piece that made her bright ensemble pop all the more.


text:
How To & Tutorials
Get Inspiration & Ideas
Contrado Blog
What is Jute? The 'Golden Fiber' That's Here to Stay
January 15, 2020 September 17, 2020 by Kaity
What is jute?
We all have used burlap sacks, rustic looking bags, curtains and several other pieces of furniture or accessories that have a lattice-like weave and coarse texture. Chances are that these products were made of jute. But how many people actually know what is jute?
Jute is a natural fiber derived from plants. The long, soft and shiny fibers are spun into coarse, strong threads that are then put to a multitude of uses. Jute is second to cotton in terms of production. It's also referred to as the 'golden fiber' due to its color and cost-effectiveness.
What is jute made of?
Jute is obtained from the plants Corchorus Olitorius and Corchorus Capsularis. These plants are native to the Indian subcontinent and are grown throughout the year. The jute fibers are mainly concentrated near the woody, central parts of the stalk. They are composed of cellulose and lignin. There are two kinds of jute that are produced today: white jute and brown jute (stronger, softer, and silkier).
What is jute's origin and history?
Historical documents dating back to the Mughal rule in India state that villagers used to wear clothes made of jute. Indians also used ropes and twines made of jute for household and other purposes. The Chinese used jute, among other natural materials, for making paper. A small piece of jute paper with Chinese characters on it has been discovered in Dunhuang, Gansu Province in northwest China. It is believed to have been produced during the Western Han Dynasty.
From the 17th century onwards
The British East India Company was the first trader of jute. In 1793, the Company exported around 200,000 lbs of jute. When a shipment was sent to Dundee, Scotland, the flax spinners were anxious to learn whether jute could be processed mechanically.
In the 1830's, the Dundee spinners learned how to spin jute yarn by modifying their power-driven flax machinery. The rise of the jute industry in Dundee saw a corresponding increase in the production and export of raw jute from the Indian sub-continent.
Calcutta (now Kolkata) was the hub for the raw materials. There was an abundant supply of labor as well as ample coal for power. The city was also conveniently located for international shipping. The first jute mill was established at Rishra, on the River Hooghly near Calcutta in 1855.
By 1869, five mills were operating with 950 looms. In 1910, 38 companies exported more than 3 billion feet of cloth and over 450 million bags. Then, by 1939, there were a total of 68,377 looms, concentrated mainly on the River Hooghly near Calcutta.
The earliest jute products made in Dundee were coarse bagging materials. With more experience, however, finer fabrics called burlap, or hessian were produced.
Post Indian Independence
After the fall of the British Empire in India in 1947, most of the jute barons left India, though the industrial set-up for jute manufacturing remained. Most of these mills were taken over by the Marwari businessmen. East Pakistan lacked a Jute Industry but had the finest stock of the fiber. As political tension rose between Pakistan and India, Pakistan felt the need to set up their own jute industry. After the liberation of Bangladesh from Pakistan in 1971, most of the Pakistani owned jute mills were taken over by the government of Bangladesh. Eventually, the Bangladeshi government set up the Bangladesh Jute Mills Corporation.
How is jute made?
The cultivation of jute requires a warm and humid climate, plenty of rainfall, and well-drained, loamy soils. The interesting thing about growing jute is that it hardly needs fertilizers and pesticides.
After the stems are harvested from the plant, they are subjected to 'retting', wherein they are steeped into slow running water for 10 to 30 days in order to allow for bacteria to dissolve the gummy materials holding the fibers together. After this, the non-fibrous matter of jute is scraped off in a process called 'stripping', and then the fibers are separated by beating the stem with a paddle.
The separated fibers are then washed, dried, graded, and sent off to jute mills, where they are further processed to make jute yarn. The yarn is then used for the production of the various jute products.
What is jute used for?
From making clothes, ropes, and household products in the ancient times, jute sandbags were exported from Bengal to the trenches during World War I. Subsequently, it was also used for the fishing and arms and construction industry.
In present times, this versatile fiber is used for making household items such as carpets, sacks, rugs, coverlets for chairs, etc. The more diversified use of jute includes products such as espadrilles that lend an element of glam to this otherwise humble fiber.
Advantages of jute
Can be easily blended with synthetic fibers
Disadvantages of jute
Prone to creasing
Not drapey enough
Color can be affected if exposed to sunlight
Loses strength if exposed to water
Can I print my own jute?
There are many reasons that you might want to print on jute material. There is little more satisfying than creating something yourself, especially from start to finish, and printing your own jute can certainly help you do that.
Now that you know all about jute, check out all the other fabrics in our range with our fabric swatch pack and get creative with your next project.
Leave a comment18962 views
Written by Kaity
Kaity is one of the Digital Marketing Executives here at Contrado. In her spare time, she enjoys memorizing rap lyrics with her many house plants.
Previous storyThe Artist's Experience: Contrado vs. Fine Art America
Next storyHow To Get My Art Noticed: Your Marketing Guide To More Sales
Get Inspiration & IdeasLearn the Basics
The Best Baby Fabrics for Your Little One
October 9, 2019 September 17, 2020 by Kaity
How To & TutorialsLearn the Basics
Drop-Shipping Marketing: How to Market your Shopify Store
March 18, 2020 August 19, 2020 by Kaity
Printing Photos on Fabric is Easier Than You Think
January 8, 2021 January 8, 2021 by Kaity
Contrado's Periodic Table of Dropshipping: All the Elements You Need to Know
October 11, 2021 October 20, 2021 by Melissa
Shop our top product ranges
Tea towel printing
Custom scarves
Serial Number Revealed: How Old Is My Singer Sewing Machine?
September 11, 2019 January 27, 2021 by Kaity
How To Sew Stretchy Fabric Without Going Mad – A Beginner's Guide
June 3, 2019 November 25, 2019 by Stefanie
5 Free Wall Art Visualizer Apps to See Art in Your Home
March 15, 2021 March 15, 2021 by Melissa
16 Foolproof Methods: How to Stop Glasses from Fogging with Face Mask
July 28, 2020 September 17, 2020 by Kaity
What Is Viscose: Understanding Your Fabrics
August 28, 2019 November 27, 2020 by Kaity
#ContradoCreatives


text:
Q: Linearly Interpolate Missing Data in mySQL COVID-19 Data obtained from OurWorldInData includes total_boosters column to track vaccine boosters in any given country. My goal is to create a column for daily new boosters (boosters_new), then create a 90 day rolling sum (boosters_90roll). The problem is total_boosters has a lot of missing data, so I would like to linearly interpolate the missing data. If the missing data is not filled in any way, then a rolling sum would be a poor estimate and would be visualized poorly.
I already have a working solution to this, but it is the trickiest query I've worked on. I am posting this question to learn if there are cleaner/more efficient ways of doing this.
Sample input:

location
date
total_boosters

Albania
2022-03-07
245527

Albania
2022-03-08

Albania
2022-03-09

Albania
2022-03-10
248491

Albania
2022-03-11

Albania
2022-03-12

Albania
2022-03-13

Albania
2022-03-14
251024

Albania
2022-03-15
252161

Sample output:

location
date
boosters_new
boosters_90roll

Albania
2022-03-07
988
988

Albania
2022-03-08
988
1,976

Albania
2022-03-09
988
2,964

Albania
2022-03-10
633.25
3,597.25

Albania
2022-03-11
633.25
4,230.5

Albania
2022-03-12
633.25
4,863.75

Albania
2022-03-13
633.25
5,497

Albania
2022-03-14
1,137
6,634

Albania
2022-03-15
886.8889
7,520.8889

Current solution
-- Group total_boosters and sequential nulls as boosters_group, then counts and numbers the rows in each group
WITH BoostersGrouped AS
(
SELECT
    location,
    date,
    total_boosters,
    boosters_group,
    COUNT(boosters_group) OVER (
        PARTITION BY location, boosters_group
    ) AS group_count,
    ROW_NUMBER() OVER (
        PARTITION BY location, boosters_group
    ) AS group_nrow
FROM
    (
    SELECT
        location,
        date,
        total_boosters,
        COUNT(total_boosters) OVER (
            PARTITION BY location ORDER BY date
        ) AS boosters_group
    FROM Vaccinations
    ) grouped
),
-- Self join to get total_boosters for current and next booster_group
BoostersFilled AS
(
SELECT
    bg1.location,
    bg1.date,
    bg1.boosters_group,
    bg1.group_count,
    bg1.group_nrow,
    bg2.boosters_current,
    bg3.boosters_next
FROM BoostersGrouped bg1
LEFT JOIN
    (
    SELECT
        location,
        boosters_group,
        max(total_boosters) AS boosters_current
    FROM BoostersGrouped
    GROUP BY location, boosters_group
    ) bg2
    ON bg1.location = bg2.location
    AND bg1.boosters_group = bg2.boosters_group
LEFT JOIN
    (
    SELECT
        location,
        boosters_group,
        max(total_boosters) AS boosters_next
    FROM BoostersGrouped
    GROUP BY location, boosters_group
    ) bg3
    ON bg1.location = bg3.location
    AND (bg1.boosters_group + 1) = bg3.boosters_group
),
-- Linearly interpolate total_boosters
BoostersInterp AS
(
SELECT
    location,
    date,
    CASE
        WHEN boosters_group = 0 THEN 0
        ELSE (boosters_current + ((boosters_next - boosters_current)* group_nrow / group_count))
    END AS boosters_interp
FROM BoostersFilled
),
-- Calculate daily boosters_new
BoostersNew AS
(
SELECT
    location,
    date,
    (boosters_interp - boosters_lag) AS boosters_new
FROM
    (
    SELECT
        location,
        date,
        boosters_interp,
        LAG(boosters_interp) OVER (
            PARTITION BY location ORDER BY date
        ) AS boosters_lag
    FROM BoostersInterp
    ) BoostersLag
)
-- Calculate 90 day rolling sum
SELECT
    location,
    date,
    boosters_new,
    SUM(boosters_new) OVER (
        PARTITION BY location ORDER BY date ROWS BETWEEN 89 PRECEDING AND CURRENT ROW
    ) AS boosters_90roll
FROM BoostersNew;

A: That's an interesting question!
I suspect that logic can be simplified (and possibly become more efficient?) by making more use of window functions.
Here is a query that does the linear regression directly on the total_boosters metric.
select location, date,
    coalesce(
        total_boosters,
        total_boosters1 + (total_boosters2 - total_boosters1) * (rn - 1) / cnt
    ) total_boosters
from (
    select v.*,
        min(total_boosters) over(partition by location, grp1) total_boosters1,
        min(total_boosters) over(partition by location, grp2) total_boosters2,
        count(*) over(partition by location, grp1) cnt,
        row_number() over(partition by location, grp1 order by date) rn
    from (
        select v.*,
            count(total_boosters) over(partition by location order by date) grp1,
            count(total_boosters) over(partition by location order by date desc) grp2
        from vaccinations v
    ) v
) v

The logic is to define groups of rows that either start (grp1) or end (grp2) with a non-null value, followed by null values ; using these groups, we can identify the "preceding" and "following" values, count the number of missing values and their positions : that's the second layer of the query. The most outer query does the linear regression.
Now it is quite easy to compute the new_boosters metrics, using lag(). Yur code already has a similar logic ; We can wrap the above query in a CTE, and then:
with cte as ( ... above query ...)
select location, date, total_boosters,
    total_boosters - lag_total_boosters as boosters_new,
    avg(total_boosters - lag_total_boosters) over(
        partition by location
        order by date rows between 89 preceding and current row
    ) boosters_90roll
from (
    select c.*,
        lag(total_boosters) over(partition by location order by date) lag_total_boosters
    from cte c
) c

Demo on DB Fiddle:

location
date
total_boosters
boosters_new
boosters_90roll

Albania
2022-03-07
245527.0000
null
null

Albania
2022-03-08
246515.0000
988.0000
988.0000

Albania
2022-03-09
247503.0000
988.0000
1976.0000

Albania
2022-03-10
248491.0000
988.0000
2964.0000

Albania
2022-03-11
249124.2500
633.2500
3597.2500

Albania
2022-03-12
249757.5000
633.2500
4230.5000

Albania
2022-03-13
250390.7500
633.2500
4863.7500

Albania
2022-03-14
251024.0000
633.2500
5497.0000

Albania
2022-03-15
252161.0000
1137.0000
6634.0000


During a fun-filled day at the beach, it can be hard to remember to re-apply SPF every 2 hours! Getting lost in a great book or laying out with headphones in can lead to forgetting and awful peeling skin. Our skin can be dried out and reptile-like for weeks to come. Check out these products that'll help revive damaged, dry, sunburned skin!
This overnight, bouncy, fresh sleep mask is perfect to revive dehydrated, damaged skin that's seriously in the need of a pick-me-up!
After a day out in the sun, this lotion cools the face down.
Perfect for the body, this lotion eases the burning and itching of sunburn. It nourishes skin which protects the tan and prevents peeling!
This leave-in cream formula saves damaged tresses after sun exposure.
Perfect for on-the-go hydration, this hibiscus and rose-infused water refreshes and hydrates skin. Best used after sun exposure.
Share the post "Best Skincare to Save Sunburned Skin"


text:
Q: Usage of "screened for" in the context of a study sample One of my friends, who corrected my manuscript, said this sentence wasn't immediately obvious to her.

The sample was screened for birth defects and major disabilities.

It's supposed to mean that the final sample/result of screening process didn't contain any people with birth defects and major disabilities, because we checked for it and rejected anybody who had such disabilities (to preclude alternative explanations for our findings).
Now I find that the word is less clear than I thought based on what I read in scientific papers (can mean both selecting AND rejecting).
I'm not sure if "screened for" is already clear enough (from the article context it should be obvious that we weren't interested in birth defects) or if I can use another preposition to be able to keep this simple sentence and still let everybody know that the final sample didn't contain any people with birth defects etc.

A: You could say:
The points pertaining to birth defects and major disabilities were screened out of the sample.
This should mean what you intend to convey.
Check these:
http://www.macmillandictionary.com/dictionary/british/screen-out
http://www.macmillandictionary.com/dictionary/american/screen-out

A: It could imply giving specific attention to, but not necessarily implying the nature of attention.


text:
Q: Correct way to inform business rules violation during JSON parsing We have the following scenario in our company:
There are some business objects which have business rules associated with them. One of these objects, Person, has the following rules:

*

*A Person must have a name (that is in coding terms not null, nor empty)

*A Person's name mustn't consist solely of spaces and/or tabs

The business object has in its constructor a parameter for name, which uses a non-nullable type to receive the name. In similar fashion there's a property which stores the name as a non nullable type.
In the constructor an exception (MyException) is thrown when the name is empty after trimming the spaces and/or tabs.
There's also a backend which deals with these objects using REST api through JSON
Right now we are using a library (Jackson) to parse JSON data received in our backend. We have specified in our DTOs that the field for the name can't be null or be missing from the JSON object. In case of deserializing a JSON object with a missing/null name field the library throws an exception.
If a Person received in the backend throws MyException then the backend converts that exception into an detailed JSON message to be sent to the client.
But if the received JSON of a Person doesn't have the field 'name' or is null we let the library throws its own Exception and that is the error presented to the client.
The question is: Should the exception thrown by the parsing library be treated the same as MyException given that both are business rules?

A: Depending on the way those errors are presented to the user of the API, it may be OK, or may not.
For both errors, it is important to have:

*

*The indication that something went wrong. With REST, this means sending an HTTP 403 or a similar status code in the response. It also usually translates into a JSON which is visually identifiable as being an error (for instance by naming the root JSON node error).

*The concerned field, that is name.

*The description of the error, i.e. what went wrong. Is the name field missing? Or it was found, but the value is invalid? In other words, the user should be able to identify the mistake in the input.
The type of the underlying exception is not necessary. It could be MyApp.Something.Whatever.BusinessRules.InvalidUserNameException or JsonSerializer.Validation.NullFieldException. The user of the API doesn't care, and shouldn't see the types anyway, since this reflects the implementation, and would vary if you refactor your code, or if you move to another language or serialization library.
So:

*

*Having exceptions from the JSON library side by side with your own, custom exceptions, is perfectly normal.

*But this should still result in uniform messages shown to the end user.

A side note about the actual business rule:

A Person's name mustn't consist solely of spaces and/or tabs

Why not? Why would a non-breaking whitespace (U+00A0) be a valid name, but a tab wouldn't?
If your intention is to prevent users from screwing up with your system, you'll fail anyway. With Unicode, there are a lot of ways to do funny stuff which will display very... nicely (or which won't display at all). Or you may restrict your users to [A-Za-z ] range, which would be technically very convenient, and would also make it impossible to enter the names of most of the persons in the world.
Otherwise, I can't see a case where the user would enter a tab as a name by mistake, and if this is a frequent case, you may check twice the user interface which encourages this sort of errors.


The big medical news recently was a seminal study of prostate cancer, suggesting that when it is diagnosed, we men have options―including the option of waiting. In the words of the study authors themselves: "At a median of 10 years, prostate-cancer–specific mortality was low irrespective of the treatment assigned, with no significant difference among treatments." The treatments studied included surgery right away, radiation right away, or monitoring- with treatment deferred until or unless the disease progressed.
Prostate cancer, however, is a notorious challenge in this regard. The prostate gland grows throughout a man's life, causing almost all of us eventually to become nocturnally itinerant for the obvious reason (yes, I am there). The same factors that cause the gland to grow continuously make cancer all but inevitable. The best estimates indicate that 80% or more of men age 80 or older have prostate cancer.
However, most of these men die with prostate cancer, not of it. More often than not, the disease is quite indolent, progressing slowly if at all. Just that was seen in the new study. Of the 545 men randomly assigned to monitoring, disease progression occurred eventually in 112, or 20%, at a rate of 22.9 events per thousand person-years of monitoring (in case it's not clear, a "person-year" of monitoring is the observation of 1 person for a full year). Flipped around, this means that in 80% of men not treated for their localized prostate cancer, the disease did not appreciably progress over ten years.
There are various challenges related to screening for prostate cancer, but this is the big one: we are not yet good at predicting which of the early cancers will ever progress. For this reason, the U.S. Preventive Services Task Force has historically recommended against prostate cancer screening, and for whatever it's worth, this age-eligible Preventive Medicine specialist- has not undergone any.
That's fairly compelling already, but the new study was about men already diagnosed with prostate cancer. At that point, hasn't the window of opportunity for prevention closed?
No, it has not. In one study published in 2008, Dean Ornish and colleagues showed that a lifestyle intervention in men with prostate cancer could activate cancer suppressor genes, and stifle the activity of cancer promoter genes. In a follow up paper 5 years later, they demonstrated the same intervention lengthens telomeres, caps at the ends of our chromosomes the length of which correlates strongly with the length of life itself.


text:
@class RDMStudentDataController;
@class RDMTeacher;

@interface RDMTeacherLinkListViewController : UIViewController <NSFetchedResultsControllerDelegate, UITableViewDataSource, UITableViewDelegate>

@property (nonatomic, strong) RDMTeacher *teacher;
@property (nonatomic, strong) RDMStudentDataController *dataController;

@end