There's no question that the Target Prepaid REDcard (AKA REDbird) is an exciting new product. At this time, though, it is only available in select locations across the United States (see "How to find REDbird").
I've been working on a "Complete Guide to REDbird". In the process, I examined all of the questions that readers have posed on my previous REDbird posts. I want to make sure that the guide I'm writing addresses all common questions. In the course of this analysis, I found that the vast majority of questions had to do with whether or not people can buy and use REDbird if they don't live near a participating Target store.
1. Can I reload REDbird at a non-participating (and out of state) Target?
2. What is the process for buying cards for other people?
The answer to the first question is easy. YES. Once you have a registered REDbird, you can use it and reload it at any Target store in the United States.
A map and list of participating stores can be found here: How to find REDbird. Note that some participating stores are not listed on Target's Prepaid REDcard website. So, it makes sense to call your local Target stores to ask. Make sure to stress that you are looking for the Prepaid REDcard, not the debit or credit REDcard.
When the cashier rings up the card, you'll be asked how much to load. Make sure to load at least $1 since people have reported activation issues with less than $1.
b) On the swipe terminal, indicate that you want to register the card. Hand your driver's license to the cashier.
The cashier will enter your drivers license number, your name, and your address into their terminal. This is OK. The person you are buying the card for can change the details later when they register online.
c) On the swipe terminal, you will be asked for your social security number, phone number, and to confirm the data the cashier typed in.
Go ahead and put in your information, or the info for the person you are buying for, or simply make up numbers. I've found that it doesn't matter. You just need to get past this step in order to pay for the card.
You can pay with credit, debit, or cash. Credit card payments will not result in cash advance fees.
If you have already bought a REDcard on the same day, the register will prevent you from buying a second one if you use the same social security number that you used before. For an easy work-around, see step 3 C, above.
Now that you have an activated temporary card, the person you are buying it for can register it online in their own name. You can either send them the physical card, or send them the card information: card number, four digit security code on the front, and the expiration date. They should be able to do the rest from home.
Enter your card number and security code. Leave date of birth blank.
Once you've registered the card, you can now load up to $1500 to the temporary card (assuming you have it in-hand) at Target stores. This $1500 is inclusive of the amount originally loaded. Once your permanent card arrives, you can load up to $2500 per day and up to $5000 per calendar month.
On the other hand, you are kinda encouraging fraud and also they use the SS# to recover lost cards and other verifications when calling in and other stuff potentially….
Have you seen a guide for the stores on how to load the card? My wife tried to load her card last night in Alexandria or Fairfax and she felt like they did not know what to do with it.
It was not loaded, but she also got a fraud alert from Citibank so it could have been due to that.
I think your wife wasn't able to load it due to the fraud alert. It happened to my husband as well and he just cleared it up with the CC, while he was still at target, then the transaction went through just fine. I'm in Leesburg, VA and the cashiers are confused about the card over here as well because they haven't really seen it before, since it isn't offered in our area. I have been going straight to the costumer service desk and loading it there versus the regular cashiers and they all know what to do.
I live in Leesburg as well. I'm currently in the process of having my card bought for me by my brother-in-law in another city. Would you mind sending me a PM over at flyertalk to the username "taterman"? I'd love to ask you a couple of questions about the Leesburg Target and perhaps coordinate a little so we don't seem like two crazy people at the same Target.
Anyone know if the temporary card can be bought with a passport instead of a driver's license? Spouse doesn't drive. I saw one related question on another forum but no reliable answer. If it's questionable, I'll follow the advice above to get her one. Thanks for the guide!
How about favorite UNloading techniques for your guide?
Since, per month, you could never unload the full amt. via ATM, how are people consistently unloading, as I'm sure not everyone has 3-5k in bills EACH month.
Alright, I am not trying to be witty. They have bill pay and you should be able to send a check to yourself/spouse/friend. Deposit in bank and get over. I personally would not do that 100% but rather mix in some genuine bills, check for rent or mortgage if possible, etc.
You forgot the circles and arrows Daraius….
Agreed. The first couple of posts were helpful, but almost every day for 2 weeks seems overkill. Is there nothing else interesting to write about in the points and miles world?
In general my approach to picking topics is to write about whatever I'm most excited about at the time. REDbird has certainly qualified for that, especially early on. One exception I make to that rule is when I get frequent questions about a particular topic, then I like to write a post to try to clarify things. That's what this and several other REDbird posts already written and still to come are all about.
Data-wise, out of curiosity, I looked back at the last two weeks..
@brian…is that a serious question? You ask how to unload a card with billpay? Sheesh!
Greg, in your experience, how long did it take for the permanent card to arrive?
My card came in about 7-10 days.
If you have a Bluebird, can you get a temporary Redbird, cancel Blue and then get permanent Redbird? or do you have to cancel Blue before you get a temp Red?
You can get a temporary RedBird while you still have a BlueBird. Then you must close the BlueBird account prior to registering the RedBird online.
Yes, you can buy the temp REDbird at any time. Just cancel Bluebird before registering REDbird online.
Has anyone able to load RedBird card at a non participating Target store like in California? One issue might be these non participating stores cashiers don't know how to do it.
Yes, though the cashiers do not know how to do it. Fortunately all they need to do is swipe the Red card, enter the amount to load, you swipe your payment and they enter the last 4 digits on the card you swiped. Same process as Amex For Target.
Yes. As others have said, it is possible at any Target store in the US. The problem may be that the cashier doesn't know how to do it, but the solution is to have them swipe the REDcard on their register the same way they would reload a gift card.
Any updates on redbird issues in NC?
Are people still reporting problems in NC?
For those of you asking about loading your card at "non-participating" Targets…I had the same issue with confused cashiers. At one point a cashier even ran it as an "American Express for Target" card which charged a $3 load. I got the fee dropped and then went to Flyertalk for answers.
One poster heard a manager tell his cashier to load it just like a Starbucks gift card. So I went to the store the next day and suggested that to two separate cashiers who both admitted to never having loaded the card before. Worked like a charm.
You will know the transaction is working when the touchpad in front of you brings up a list of accepted payment forms.
Why leave DOB blank on the first screen?
If you put in the DOB of the person who bought the card, the next screen will pre-populate with their information. If someone else bought the card for you, you don't want that.
I bought two RedCards at one Target with the same SSN. I bought them at two different registers. No problem.
That's interesting. I've tried that, but it hasn't worked in Michigan.
No REDcards anywhere near me, so I had someone from another state send me one. I went through the online registration, setting up the card for a family member who has authorized me to manage her card for her. Received the card, went online to complete the registration process and get the permanent card. At the end of the online registration process, was asked a series of ID verification questions – asking about old addresses (10-15 years back). Answered the questions to the best of my ability, all correctly (I think – the questions were obscure and all about very old details). At the end of the registration, the screen said "Thanks for requesting an account. We need additional information, so watch your email." Hmm. No email from them for 3 days. Hmmm.
Has anyone else seen this, know what it means, or have a suggestion? Thanks.
With only one of four cards that I registered, I had to go through the ID verification process as you described. At the end, though, my card was approved. You might have to call them to clear this up.
Question on managing a card for someone else (my parent). Can you load redbird for someone else using your credit card? Hoping to keep both my serve and someone else's redbird in the 'family'. I believe serve needs the same credit/debit card name and address. But what will happen at the Target register when I try and load my Dad's redbird with my credit card? And I assume redbird billpay won't care what bills I pay in whose name.
Yes, absolutely. I've loaded three other people's cards at Target without trouble with my own credit cards. I've never had a cashier look at the name on the reloadable card.
Oh, and yes you can pay bills that are in other people's names as well.
I bought a second one for my daughter with my DL# and a temp ssn/birthday. When we registered it, I did not leave birthday blank. I filled in her info and it worked.
Thanks for that added info. Its not really that we're disagreeing just that there are multiple ways to accomplish the same thing. The key is not to use the birthday of the person who bought the card since that will pre-populate their personal info. Its not even that bad if you do prepopulate that info, its just easy then to make a mistake.
What about using someone else's card for future loads? Is ID required? Assuming I am using my own credit cards, could I load a family member's registered or permanent REDcard without any issue?
Yes, you can do that. You can reload other people's cards at Target and pay with your own credit card.
– I don't have SSN but ITIN. can I get still this card?
– can I use Target gift cards to load?
Great question about the ITIN. I don't know the answer though!
No, cashiers are told (by the system) not to allow Target gift cards.
Didn't have an SSN, but ITIN. I went ahead and bought the card and loaded $500. Came back home to learn that SSN is a must. So cannot register this card online. Too bad I wasted on max load.
Sorry to hear that. Thanks for letting us know.
I have the same question as PR (question 16). I don't want to have to close my bbird, will using a family members rbird with my credit card work? Thank you.
I live in FL and would appreciate if anyone living in the participating Targets help me obtain 1 or 2 of these prepaid REDbird.
Are there any other ways besides going to Target to fund it by my credit card? If I go to Target tomorrow (November 1st), I will lose the October limit (daily $2,500; monthly $5,000), right?
Can I unload my temp redcard via target atm & how much is max withdrawal in one transaction?
Follow-up to my own question. I called ahead before driving to a state with Redbird and was told that my wife's passport would work and that I could get a temp card for her.
When I got to the store I was able to get my temp card just fine with my DL, but when we tried to use my wife's passport, we got errors. I called customer support and they wanted to confirm info with my wife, who wasn't there, so that didn't help. Even though in my comment above I said I'd follow your advice if I ran into trouble, in the moment I didn't even think to have her scan my DL again and enter my wife's info (I guess I was getting skittish).
Thankfully, and before I even had to ask, the Target employee suggested I just take the card with me.* When I got home I called customer support again and they talked about a BB/Serve-related glitch and that I'd need to send in a bunch of documents. Today, however, I went to a non-participating Target, followed your directions, and had no trouble getting the out-of-state temp card loaded for my wife (and I also topped up my temp card with $1k). Wish I'd remembered yesterday, but all's well that ends well. Thanks again for the write-up!
* Just want to add that the Target employee was about the friendliest, most helpful person I've ever met in retail. Apart from the unexplainable glitch, everything went smoothly and she just wanted to get me set up and running.
Also had some problems this weekend with the cashiers not knowing how to load. The "load it like a gift card" worked for me. The customer service people knew how to do it for sure, so I did my first load on my temp card there.
Do you have to use bank account different from BB for Redbird?
No, you can use the same one I believe.
When does the limit reset? I got the card in late October and I have used up the 5k in 3 days.
I live in a state that sells this card and have already purchased 1 for my own use. However, my friends and relatives from other states, have asked me to buy additional 8 cards so they can activate. Do you think this will raise any red flags as I am required to give my Driver License??
Also, I was charged $5 in the initial load, does this seem right? when there shouldn't be any charge?
The $5 fee is fine. Target charges $5 in some states and offers the card free in other states.
Is it possible to use the SS# of underage children to register a Redbird…put another more direct way – is there a minimum age to register a RB in someones name and use it effectively?
Unfortunately, no. The person who registers must be 18 or older.
Is it possible to load it using Amex Gift Cards?
Does the registered address for cards I am managing for people have to be their address (same as their address that Amex might have on record)? Or can I use one mailing address (mine) to manage multiple cards for others (family members) that don't actually live with me? My guess is that this is possible but I am wondering if there are any known data points? Thanks!!!
It doesn't have to be their usual address, but it would help. If you use your own address, you will probably have to do some things to prove your (ie their) identity. I did this with cards for my sister and niece and was able to get them approved, but it was a bit of a hassle.
That makes sense. Thanks for taking the time to answer!
Can the redbird be activated at a store that do not stock the card? Say a target has the redbird in stock (for free) but a friend is not comfortable registering the card.
Maybe, but that would require taking an unactivated card out of a Target store. I wouldn't recommend doing that without permission from the store manager.
interested to know if this worked for you?
Can a non scanned RedBird be activated at a non participating store?
When reloading. with credit card, are there any credit card providers that you should not use , that could result in cash advance or other charges?
Arcane question here, but how is the monthly RedBird cycle timed (for the 5K limit)? Is it calendar month, or based on the date you activated your temporary RedBird or your permanent RedBird?
Just wanted to say THANK YOU for this post. Your detailed instructions (as well as on how to close Bluebird family accounts) helped resolve my account closing & registration issues when AMEX customer service couldn't. So, still in this season of Thankksgiving, I just wanted to say that I am personally thankful for you. you help minimize a lot of headsaches and challenge me (and others, I'm sure) to stretch our miles/points-earning limits 🙂 Thank you!
Great! I'm glad my posts helped!
I was in Greensboro NC yesterday and they pulled them all from the area stores because they weren't registering properly.
Thanks for the update. I've been waiting for them to resolve these NC issues. Guess I'll have to keep waiting.
Is the $1500 max load to the temp card counted in the monthly 5K max?
The amount you load on first purchase is not counted towards the monthly $5K, but the rest is.
Someone sent me a redcard and I tried to activate it at my local Target without success. My cashier swiped the card and the screen prompted the cashier to enter the load amount. As soon as load amount is entered, register displayed "can't read card, please call the number on the card". Can the problem be the prepaid redcard has not be launched in Calif yet?
No, that's not the reason. It could be that you got a bad card or that the cashier did something wrong. I don't know.
What is the sequence the cashier needs to do to activate the card? Does s/he scan the UPC at the top right corner first then the code at the bottom of the package?
They scan the card's packaging as if you're buying it and then they should be prompted for the rest.
If I just get the card info from the other person and register for the permanent card, will they have access to the account or is the permanent card a different number and whatnot?
Have you heard of any success stories of a non scanned RedBird being activated at a non participating store?
and thank you for your tremendous contributions to us!
Are you able to load your wife's card at Target? Or is it always have to be the name on the card as the who who loads?
That will really depend on the register attendant if you say you have another one. It will be up to them to actually ask/care for the second ID. Worth a try.
I can't say I've done it myself, but have heard of someone who has first hand.
Yes, I load my wife's card, my sister's card, and my niece's card.
Have you done a post on analyzing which card to use for the loads? i.e. any negative repercussion from using another AMEX card?
No problem using Amex cards. All cards treat as purchase. I'll writeup recommendations soon.
Does it have cc bill pay can you pay other credit cards like you can with serve?
Can I bill pay the credit card that I used to load REDbird?
Is the temp card still usable after the permanent card arrives and is active? I got mine from a colleague and want to make sure they can't withdraw money from my account if they decide to be dishonest suddenly (they emailed me a pic of the temp card but they have the physical one).
I was able to purchase 4 red cards using my license at a local target on a single day using diff ssn with same drivers license. I attempted to register one online. It gave me an error message saying I had an open bluebird account. So I entered each of the other 3 cards, each one giving me an error message. Then called redbird who told me my bluebird account is only "closed" not "permanently closed." And, it must be permanently closed. So I called bluebird who confirms my bluebird acct won't be permanently closed for a month. So apparently I have to wait to register my own card online.
1. Will I, in fact, be able to register my redbird card online once my bluebird card is "permanently closed"?
2. Will there be any problem to register my family members as owners of the other 3 cards now that Redbird connected the dots over the phone that there's a single name and more than 1 ssn when I registered in store?
3. Is there any risk to attempting to register them with the cards associated with my license?
Many thanks for the instructions – yesterday was able to successfully purchase 2 RedBird temp cards for $500 each (one of them for my wife – used different registers and scanned my own DL twice with different SS#). Once got back home activated both cards and today loaded $1000 on each with SPG Amex at Guest Services of a non-participating Target near home. At both Targets really enjoyed the feeling of not being treated as a small-degree criminal like it was at local Walmart with BB.
It looks like Bill Pay is not active until permanent card is received and activated (at least that is what the website says). Any way around it? If not, what is the limit for ATM withdrawals per transaction? Per day?
Once again really appreciate all your efforts!
That's correct about billpay. You can withdraw, I think, $700 per day.
Ridiculous I'm in Hawaii and will be the very last to be able to get this card. Anyone care to help please email me.
I got the 'being reviewed' screen and to check my email because they will need more information from me….I don't remember ever getting those on the BB or Serve cards.
When registering these cards does it use the social # just for identification or will it actually pull credit or show up on a credit report?
They will be able to see some of that info ONLY if they know your birthdate. When registering, they can leave the birthdate blank on the first screen, or enter the birthdate of the person who bought the card in order to prepopulate some of the stuff on the next screen.
I live just outside Charlotte, NC and have been following a few blogs re Redbird. I finally decided to take the plunge and drove to the Target stores in Greensboro, NC earlier today. I went to the Bridford Parkway and Highwoods Blvd locations. Neither stores carried Redbird. I spoke with individuals at the Customer Service desk at each store who stated there had been numerous problems, the cards had been pulled, and they were no longer carrying the cards. I asked if they would be able to reload a card that I brought in and both stated no. They said they receive almost daily calls from customers looking for Redbird. Looks like Redbird is dead in NC.
I just registered my temp Redbird, now waiting for the permanent one to arrive.
It's likely too late for March, but for April, I'd like to try paying my rent with Redbird.
So, between now and then, I'll be heavily loading it via credit cards.
Can one purchase a 2nd REDbird prepaid card? I have already purchased and am using one now, but would like to begin using a 2nd one. After purchasing the temporary card (2nd one) at Target how does one register it online, etc. to set up the account so it is not confused with one's first REDbird account?
You can purchase a second one, but you can't register it to yourself. Each person can only have one Redbird in their own name.
so, i want to know if i asked my friend to register a red card for me, is there anything damage to him?
so, i want to know if i asked my friend to register a red card for me, is there anything damage to him? because he don't know whether the prepaid redcard debit can be overdraft.
You can't "overdraft" redbird. If you don't have the funds, it is not going to allow you to proceed with the the transaction.
Does anyone think that there is any potential for fraud if you buy one of these online? That is can the person who bought it for you (and has your account #) have access to your account, even if it is registered under your name, SS, etc?
I think it is safe. Your permanent card will have a new number.
I've tried twice to buy a 2nd card. The 1st was on the same day I bought mine. No go. The 2nd time was on a different day. Again no go. I used a different SSN and birthday on the 1st attempt. I used my real SSN and birthday on the 2nd attempt. Not sure if they've closed the loophole or what but so far I've only been able to buy 1 card with my driver's license.
I've heard a few similar reports recently. If the loophole is closed, it happened very recently. Another possibility is that they may be having system issues overall (or in certain stores) for activating cards.
I am in Texas so there is no Target nearby for me to pick one of these up in store. A friend of mine is currently in Richmond, VA visiting family (he's from Ontario, Canada). If he goes to a target store in Richmond to buy a redbird for me and uses his Ontario driver license and enters my SSN in the terminal will they have a problem selling him the redbird because he is providing a Canadian driver license?
I don't think he'll be able to use his Canadian driver's license to buy one. I could be wrong though.
do you have to have a closed serve account before buying a temporary card?
Did you find someone to do this for you Michael?
So, If I buy one on ebay or reddit and they send me the info to register…do I still need a valid SSN? Or can I just make one up, or did the person I bought it from already make one up?
Might be a silly question but just to clarify–In the month when you first get the temp card, what is the max that can be loaded? $5k total or up to $1500 on the temp card + $5k on the permanent card? Thanks.
Actually one more question–Can someone with a subaccount card load a main account? For e.g., if I have a sub account for an account in someone else's name, can I use that to swipe and deposit at a Target? (like having the card and cc both in my name just in case someone wants to check). Thanks.
Anyone found problems w/using someone else's card – for example, if I were to get a card in my family members name (with their permission of course) and then I use it at Target to load, etc… Do they check the name vs. the credit card name to make sure they match, etc…?? Not sure I want to give up my bluebird card yet.
At most stores I've had no trouble loading REDbird cards that have other people's names on them. There is one Target in my area, though, where they trained the cashiers to check the name against your ID. So, I mostly avoid that Target except when loading my own card.
Went to pick up a couple of cards for friends today and couldn't get more than one. Customer service said they would only sell one to a person. Probably not a system restriction but probably makes sense that a person won't have more than a SSN to associate with a drivers license.
I already have a target redcard, and just got another one today using a family member's SSN# and contact info at checkout. My Question: When I'm registering card online, can I put in my original information, or will it detect that I already have an existing redcard account and not allow me to register?
You can't get a 2nd card registered online to your SSN. Best bet is to sign up for a family member with their name, SSN, etc.
i have closed my Serve account 4 weeks ago. My son got the temporary prepaid redcard for me, using his driving license and address details.
I Called the 855 306 7395 Number but they cannot do anything, and said card is under my Son's name and i need to go back to the store 120 miles away to see if they can do something or change it, as they cannot do anything about it…………..what is this Crap?
WHAT CAN/SHOULD I DO NOW?
When I first opened my Redbird account, I had a lot of trouble because the system thought that my Serve account was still open.
tried that option too right now, still does NOT WORK…………..so i guess buying for someone 'Option is OVER AND DEAL of the PAST', eh?
I don't think so. For some reason its not working for you. What does it say now that you've closed your Serve account online and tried to register with a different email address?
I got the same freaking message. Did you previously have a redcard?
I had one in March, then I closed it. I tried to reapply using others temp card. It doesn't work this time.
Mayur, one reason why some people were having the same issue was that they were trying to register for Redbird with the same phone number and/or email as the closed Serve account. For this reason I've advised people getting the Redbird from me to change their phone nr and email address on Serve or Bluebird before closing them, if they want to register for Redbird with the same info.
By the way, for people who are in a non-Rebird (REDcard) state, you can buy one from me via email for a small fee, I've provided temporary activated Redbird info to well over a thousand people by now, go to NoonRadar.com for more info and reviews.
: "We're sorry, but we cannot approve you for a Target Prepaid REDcard® Account right now because you already have an existing Serve Account. If you'd like to open a Target Prepaid REDcard® Account, please call us at 855-306-7395″. The customer serve recommended me to register the REDCARD with the same email after 30 days of the Serve closure and said there is nothing he can do at this point.
Forget to mention, the CSR said a lots of people are having the same issue I had and it might be their IT issues and they are working on it. I was asked to be patient waiting 30 days from the closure.
Generally speaking, it seems from others' reporting that Amex/Redbird customer service might be willing to help more if you patiently and rationally insist and explain your case, sometimes calling a 2nd or third time.
Still, if there's nothing they can technically do to help, then you just might have to wait or accept that answer.
my serve has been closed more than 2 months ago………….well screw redbird……..i am getting bluebird instead…….i can use same debit GC's bought from giftcardmall and such websites and load Bluebird at walmart right? CAN I?
Yes, you should be able to load pin-based gift cards to Bluebird ad Walmart, except for Vanilla type ones.
However, if you're not able to open Redbird due to Serve still showing open on the Amex computers, the same thing should apply if you attempt to open Bluebird…Serve/Redbird/Bluebird are all prepaid Amex products.
Hi Noonradar, you are right. I applied for bluebird and same message 'My serve account is still open". This is same message i got when trying to open Redbird earlier.
However i have called Serve customer service twice and they have confirmed my serve account is CLOSED………….and i cannot log to my previous serve account ( as it is closed).
Anyone who can help/guide me in right direction, will appreciate it, and thanks in advance.
Mayur, one thing you can try…apply again for Redbird or Bluebird, when entering your SSN, change the last digit to something else. The Amex computer won't be able to match your SSN with your name and will flag the registration for human approval. Upload a copy of your SSN card along with your ID, call them and let them know you've made a typo when entering the SSN.
Best case scenario, they will approve your registration and it will go through, since manually approved. Worst case scenario, they won't approve it and have you apply again via the computer.
I haven't done this and would only attempt it if all else failed, but others have reported doing this successfully. One person on FlyerTalk reported being advised to do so by Amex cust service to bypass the issue you're experiencing, which is supposedly due to some glitch on their part. Now this is one person on the internet, so take that with the appropriate weight.
Let us know how it goes if you decide to try it.
I will do it, and let you know how it goes. But that is a Brilliant suggestion, as phone calls to Serve are USELESS and Waste of time.
I have a friend that can get me a red card in New Mexico. Customer Service told me that he can just come in and get one and not activate it–basically avoiding the register. Will this work and allow me to register it? I sure hate to pay $23 for something he can get free. If he has to activate it does that information have to match his Drivers License?
Hi, I wondered if this procedure still stands now? Also are people still wanting these cards since the changes? Thanks.
Yes, I believe that the basic process is the same. One big exception: you can't pay with a credit card. Yes, people still want these because at many Target stores you can use debit gift cards to reload REDbird.
Which card is better between Bluebird and Redbird? Any of these 2 has benefits over the other?
Can Bluebird at Walmart be loaded with debitcards with same convenience as one can load Redbird at Target?
If i have choice of selecting, which one should i go for and why?
Bluebird otherwise has an additional feature of having a physical checkbook, but you can send a check via mail through billpay both with Redbird and Bluebird. Their monthly limits are both $5K.
Aaah…Thank you for the prompt reply. WM is 15 mins away, Target is an hour away from me. Looks like BB is the choice for me then. I can Load the $500 VGC's bought from websites and Load them on my BB at WM without any issues right?
On that note, Looks like Giftcards.com not only has removed their free shipping codes, but the Per Card Fee has also been increased by $1 or so…..any comments on that? Any other good websites to by the VGC's or MCG's?
Target vs Walmart is not just about distance, but also about whether you can load at all and the level of difficulty in doing so. For instance, generally speaking most Targets are easier to load with than most Walmarts, but a select few Walmarts have a working KATE (money center) via which you can load without a cust service rep.
You might have to try one and then if it doesn't seem to work switch on the other (you can close Bluebird and open Redbird, and vice versa).
I don't do the online gift cards nowadays or a lot of gift cards in general (too busy with activating temporary Redbirds for online sale) but people seem to buy of giftcards.com, also if you have a Simon Mall nearby might be a good venue.
There's usually some fee/cost associated with gift cards, in stores it's usually around 1%, online might be less when there's deals or indirect/longer ways.
What are daily loading limitings for Both Bluebird and Redbird? how much can one load at either WM/Target per day?
$2.5K/day for each of them.
Hey, I posted this question on another article, but this one seems more active, so trying here: For those that manage multiple RBs – Do you use the same mailing address for all your RBs (or at least for more than one)? I have 3 with different addresses. I'm about to add my cousin as a 4th, but I'm considering skipping the step of mailing it to him and him sending it to me. I'm thinking just use his SS, and send to my address. Thoughts?
I assume using a minor's (my child's) SS# won't work. Amex will not be able to match it to public record and reject, yeah?
They will probably make you upload documents including ID, which wouldn't work. They might make you just answer public record questions, but if the minor has no credit file, they will prob go straight to having you upload/fax documents.
This is in theory though. Data pints wise, I don't know if anyone has tried to register a prepaid Amex acct on their less than 18 year old child's name.


text:
How did Netanyahu come to believe he runs the world?
Arthur Milner writes about Netanyahu and his free rein to do whatever he pleases.
By Arthur Milner
I arrived in Israel Friday morning, travelled to Bethlehem in Palestine, and then to the international city of Jerusalem. There's no trace, that I've seen, of the apparently upcoming war with Iran or the recent protests against the Palestinian Authority.
The English version of Haaretz, Israel's left-wing newspaper, is bustling with attacks on Netanyahu's efforts to destroy Israel. I am reminded of a column by New York Times columnist Paul Krugman from a few months back: "It seems obvious from here that the narrow-minded policies of the current government are basically a gradual, long-run form of national suicide."1
According to several major Jewish journalists in the United States, that suicide is no longer "long-run." The New Yorker's David Remnick: "It is hard to overestimate the risks that Benjamin Netanyahu poses to the future of his own country." M.J. Rosenberg, formerly of AIPAC and Israel Policy Forum: "Binyamin Netanyahu poses an existential threat to the Jewish state. Those who claim to care about Israel need to speak out. Will we really allow this rightist egomaniac to destroy a 2000 year old dream?"
How did it come to this?
Initially it seemed the threatened bombing of Iran was just another diversion from settlement expansion. As long as Israel was killing or threatening to kill people in Lebanon, Gaza or Iran, no one paid attention to Palestinians losing their homes. (Even now, under cover of potential international disaster, Israel – not the settlers' organizations but the actual government of Israel – is seeking a ruling from Israeli courts to allow it to build 40 new settlements on privately owned Palestinian land.)
But Netanyahu's recent behaviour is fantastic. Does he – and do Israelis – really think they can order the world about? Do they really think it's all right to start a war that will destabilize the world because they're nervous? Do they think they, who actually have a nuclear arsenal, can bomb another country that they merely suspect is building one? Do they really think they can grossly interfere with the U.S. election and that there will be no consequences?
I guess they do. And if they – Netanyahu and his supporters and Jewish Israelis – really do think they run the world, how did they come to believe such a ridiculous thing?
China and Russia and the United States ignore international law when it suits them, but they're superpowers. Who's going to go to war with China over Tibet? But Iraq thought it could ignore international law (in Kuwait) and Iraqis suffered the consequences. The Serbs thought they could ignore international law and they paid. It took a long time, but apartheid South Africa paid too.
Pretty much every country in the world – including Canada – regards Gaza, the West Bank, the Golan Heights and Jerusalem as occupied territories and regards the settlements in the West Bank and East Jerusalem as illegal under international law. But Israel has annexed the Golan and Jerusalem and continues to build and expand settlements – and force Palestinians from their homes. Israel has been creating refugees and illegally refusing their return since 1948.
What's the consequence? Preferred status in trade with Europe. Canadian sycophancy. Charitable status for illegal settlements. $3.5 billion in annual untied aid from the United States. The United States goes against its own policies and interests in the Arab world by vetoing UN resolutions on Israel. Israel humiliates the U.S. Vice President when he visits and there is no consequence. Israel's Prime Minister openly defies the U.S. President in a speech before the Congress in Washington, and what's the punishment? One standing ovation after another.
No wonder Israeli Jews think they're omnipotent. If Israeli leaders believe Israel has a free hand to do whatever it wishes, where did they possibly get that idea?
My point is, this isn't sudden. Israel has always been allowed to get away with – literally – murder. The consequences for Palestinians have been disastrous. The consequences for the world – 100 years of increasingly bad relations between the West and the Arab and Muslim worlds – are immeasurably awful.
I read an article by Sefi Rachevski in yesterday's Haaretz:
We are probably confronting a final moment. The moment that realization of … the inability to change things spreads, emigration and the collapse of the liberal bubble that maintains Israel will soon follow … The religious right received 65 seats thanks to poor voter turnout among moderates. The hope and the fury that created the 2011 social protests; the existential danger in the face of the dominant extremist atmosphere – including arrogant foreign policies that isolate Israel – could … give rise to a non-religious, non-racist government … that will stop subsidizing and stop nurturing the racist-extremist hothouse.2
From the point of view of moderate Israeli Jews like Rachefski, who would like to live in a democratic country, defeating the religious right is crucial. From the point of view of anyone who cares abut Israel's survival, defeating the religious right is important.
But from the point of view of Palestinians, it's not a big deal. Israel's plan to populate and annex the occupied territories has proceeded under all Israeli governments. The left, as much as the right, has excluded Palestinians from Israel's democracy – completely in the occupied territories but also, to a great extent, within Israel itself. The left, like the right, has been deaf to the rights of refugees. Finally, there's no reason to think that peace is more likely under a left-wing government than a right-wing one; the left has just been better at making it look as if lack of progress is the Palestinians' fault.
By our silence and inaction, we've created the megalomaniac that is Netanyahu and the monster that Israel is becoming. The solution? Stop doing what hasn't worked. Instead, take international action to force Israel to comply with international law.
1 April 24, 2012.
2 "The final moment before the liberal population leaves Israel," September 16, 2012.
Netanyahu photo courtesy Lance Page, adapted by Pete Souza / Flickr
Jewish settlement near Bethlehem, Photo courtesy Jay Voorhees/Flickr
Arthur Milner
Arthur Milner is a playwright and theatre director. His most recent play, Getting to Room Temperature, is a hard-hitting, sentimental and funny one-person play about death and assisted dying. Facts, a murder mystery set... Read More

redpajama_set_name: RedPajamaCommonCrawl


Our Work Together — michellcclark.com - More than what you came for.
I'm here to help you build the mental framework and practices that will fuel long term digital media success.
Algorithms come and go. "Best practices" that work today will be ineffective within 18 months. Learning social media tips and tricks will give you a competitive edge, but building systems and processes that position you to consistently absorb relevant content and information, learn from relevant real life case studies, listen to the audience you seek, and resonate across multiple platforms will position you to be impactful for years to come.
Let's outline the framework for your social media success. Sign up for an initial consultation today.
Establish and clarify measurable, time-sensitive goals for your social media presence.
Evaluate the thought process that drives your current social media habits and content consumption.
Collaboratively create manageable daily and weekly checklists to facilitate progress towards your goals.
Discuss any additional consultative or coaching needs.
Want to skip the initial consultation and discuss a custom program that fits your specific needs?
Sign up for a strategic goal-setting session, in which we will explore and clearly define the steps necessary to manifest the vision you have for your social media presence.
The initial investment for this appointment will count as a deposit towards pricing for the long term programming that we agree upon.
I'm Michell. I've been intentionally building brands for myself and others since 2009. I've been able to leverage my digital audience of over 100K to acquire a publishing deal for my first print book, sell out numerous brunch parties, and launch a plethora of income streams. Yes, I use plethora in real life.
I've executed digital campaigns with Grey Goose, Cricket Wireless, 3 Musketeers, Marriott Hotels, Bevel, and many more. I had no idea what I was doing when I get started, but my mindset helped me to find my way and take control. I'm here to help you build and leverage your social media presence to secure long term, real life wins. I'm here to help you avoid some of the mistakes that held me back as I learned how to maneuver. Let's get to it.
"I recommend Michell as a consultant to anyone looking to build a purpose driven brand. He has experience creating an effective brand presence for himself and his projects. He understands that developing a brand is more than just nice colors and a catchy tagline.
Michell has the know-how to recommend the content creation strategies that will make your brand memorable to anyone who comes across your materials both online and offline."
"Michell provided me with the framework to establish a digital presence that has allowed me to continuously build my fan base and increase consumer loyalty. He is an excellent communicator and understands how to send the right message without coming across the wrong way.
Michell helped me to create a huge buzz that led to millions of digital streams and me being able to tour internationally. I was able to do all of this without sacrificing my authentic persona as an artist or damaging my integrity in the process."
"Michell took charge of developing a unique social media strategy that was thoroughly tailored to accommodate my needs as a Virginia State Delegate. The strategy focused extensively on my need to interact with my constituency.
Michell was proactive and knowledgeable, incorporating different approaches for each social media platform to ensure that my content was consistently effective."
"Michell has a great understanding of how to be authentic within a business environment. The principles he employs can be implemented in different types of ventures.
Our conversations have a very natural feel that center around using current events and leveraging pop culture to enlighten people. Michell is very receptive to various perspectives, making for very productive conversations."
Rescheduling Policy: Appointment rescheduling requests will be honored up to 24 hours before the scheduled call time.
Cancellation Policy: Cancellation requests can be requested via the contact box below up to 48 hours before the scheduled call time.


As stated in previous chapters, when designing a program, you need to consider the user interface and all inputs and outputs required by the program. The Battlecell program interface shown in Figure 5.16 is fairly simple, consisting of two 10 by 10 grids in which the user and computer must place their ships. The user will input ship and target selections via mouse clicks on worksheet cells. Clicking the Command Button control will initiate the game and an area of merged cells will serve as a message board to help the user know what to do. Other program inputs and outputs include help messages output to the worksheet and sound files that are played during the course of the game.
The program will require at least two modules, including the object modules for the Workbook and Worksheet objects containing the game. The object module for the Workbook object is required for its Open(), BeforeClose(), and WindowResize() events that will be used to satisfy the requirements for clearing, resizing, and resaving the workbook. The object module for the Worksheet object is needed for its SelectionChange() event that will satisfy the requirements for the user's selection of ship locations and targets. Standard modules may be used as well in order to better organize the code.
1. Format the worksheet with two 10 by 10 grids, merged cells for help messages, and a Command Button control. Use colors, borders, and large fonts to make the grids, merged cells and Command Button control stand out. Define names for the two grids and the merged cells in order to make the code that references these ranges easier to read.
2. Resize the workbook window via the Zoom property of the Window object (sub procedure). The workbook should automatically resize when the user opens the workbook file or resizes the workbook window (Open() and WindowResize() events of the Workbook object).
3. Clear the user's and computer's grids (sub procedure) of color and values, and save the workbook when the user closes the workbook file (BeforeClose() event of the Workbook object).
4. Initialize the game (sub procedure) when the user clicks the Command Button control (Click() event of the Command Button control).
5. Capture the user's selections for ship placement (SelectionChange() event of the Worksheet object) and color the selection light blue if valid (several custom sub procedures that validate the selection for the following: location within the user's grid, length, one row or one column, overlap with another ship). The validation procedures should return an error message if the user's selection is invalid.
6. Randomly generate locations for the computer's ships and mark them with an X after validation. This will require several sub procedures that generate the row and column indices for the computer's ships. The same sub procedures that validate the user's ship selections should also validate the randomly generated selections used for the computer's ships.
7. Capture the user's selections for targeting the computer's ships (SelectionChange() event of the Worksheet object) and color the validated target blue for a miss and red for a hit. The target must be validated for the following: location within the computer's grid, only one cell selected, and the target has not been previously selected. Use custom sub procedures that return an error message if the target is not validated.
8. Play a sound file if the user's target is valid.
9. Play another sound file (explosion) if the user scores a hit, and test for the end of the game. Play another sound file (specific for the user winning the game) if the game is over.
10. Immediately following the user's target selection, simulate the computer's return fire. Randomly generate a target (sub procedure) and color the validated target green for a miss and red for a hit. Validate the target using the same validation procedures used to validate the user's target.
11. If the computer scores a hit, then test for the end of the game and play another sound file (specific for the computer winning the game) if the game is over.
12. Re-enable the Command Button control and terminate the program when a winner is declared (sub procedure).


text:
Zendavesta (26) + -
Bragdon, May (5/16/1865 - 3/21/1947) (16) + -
Bragdon, Katherine Elmina (12/30/1837 - 9/6/1920) (12) + -
Hillman, John Constantine (1865 - 1932) (6) + -
Davis, Charlotte Gleason (4/12/1861 - 1938) (5) + -
Behns (4) + -
Sibley's (Rochester, N.Y.) (4) + -
Charlotte (Charlotte, N.Y.) (3) + -
Davis, Hamilton Clark (10/14/1864 - 2/10/1947) (3) + -
Davis, Lillian May (1871 - 1910) (3) + -
Flack, Ethel L. (1877-1971) (3) + -
Hillman, John Constantine (1865 - 1932), Caring, Elsie G. (b. 1887?), Rochester Orphan Asylum (Rochester, N.Y.), Zoroaster (d. 1909), Zendavesta
May Bragdon Diary, September 5, 1900, p. 198
Burgess, Frank Gelett (1/30/1866 - 1951), Backus, Harry E. (b. 1860?), Davis, Frank Allen (3/21/1873 - 6/1/1953), Charlotte (Charlotte, N.Y.), Stony Lake (Ontario, Canada), Zoroaster (d. 1909)
Clubb, John Scott (1875 - 1934), Dickins, Mary Belle (9/9/1876?), Rowe, Marguerite H. (1886 - 1967), Bragdon, George Chandler (4/29/1832 - 8/7/1910), Wilkinson, Josephine (10/22/1862 - 3/3/1943), Cro' Nest (Rochester, N.Y.), Zoroaster (d. 1909)
May Bragdon Diary, October 26, 1903 – October 27, 1903, p. 245
Bragdon, George Chandler (4/29/1832 - 8/7/1910), Davis', Davis, Charlotte Gleason (4/12/1861 - 1938), Baker, Lura Ophelia (8/13/1870 - 1922), Davis, Frank Allen (3/21/1873 - 6/1/1953), Davis, Lillian May (1871 - 1910), Hillman, John Constantine (1865 - 1932), Cro' Nest (Rochester, N.Y.), Zoroaster (d. 1909)
Zozie favorite pose.
Zoroaster (d. 1909)
Inclusion, May Bragdon Diary, May 30, 1906 – June 2, 1906, p. 127
Zo & Zen. 6/06.
Zoroaster (d. 1909), Zendavesta
Zozie and his mistress. (M.B.)
Zoroaster (d. 1909), Bragdon, May (5/16/1865 - 3/21/1947)
Zozie on a post.
Inclusion, May Bragdon Diary, April 1, 1907 – April 6, 1907, p. 247
Zo's 7th birthday picture. 4/2(9)/07.
Inclusion, May Bragdon Diary, April 29, 1907 – May 8, 1907, p. 255
GCB & Zozie. 4/28/07.
Zoroaster (d. 1909), Bragdon, George Chandler (4/29/1832 - 8/7/1910)
Inclusion, May Bragdon Diary, September 5, 1900, p. 198
"Zozie."
Inclusion, May Bragdon Diary, July 7, 1900 – July 18, 1900, p. 157
Zen & Zo.
Zendavesta, Zoroaster (d. 1909)
Inclusion, May Bragdon Diary, March 17, 1901 – March 23, 1901, p. 242
Zozo.
Inclusion, May Bragdon Diary, July 28, 1901 – August 10, 1901, p. 257
Zoroaster.
Inclusion, May Bragdon Diary, January 30, 1904 – February 1, 1904, p. 290
M.B. and Zozie.
Zo and Zen. 3/31/01.
Inclusion, May Bragdon Diary, February 10, 1901 – February 23, 1901, p. 234
Inclusion, May Bragdon Diary, March 14, 1901, p. 235
Zo's tail & the steeple.
Zo - in a hole in the fence.


"Ladies and gentlemen, the childish display, the childish exposition and behavior of the Drive-By Media yesterday once again has proven me right. The bizarre questions, the unhinged, childish, so transparently desirous questions from our Drive-By Media regarding the health of President Trump, has proved something....They believe this," Limbaugh stated near the top of his show.
There's no way these people could act as stupid and dumb and childish for an entire hour as they did yesterday if they didn't believe it, if they didn't hope it, if they hadn't invested in it. They believe all of these sick fantasies that they conjure up. And this is why they often confuse their opinions with being facts. They mistake their fantasies for being truth, without evidence, without reading.
They believe Donald Trump is on the verge of Alzheimer's, insanity, and death. They believe the doctor lied in reporting Trump's health statistics.
"We're dealing with unhinged instability....But the vast majority of the White House press corps and the big names at cable news are actually what they accuse Trump of being. They are unfit for their jobs," he added.
"They believe he's insane. They believe he's gonna die. They believe it! That's why all this stuff, they think, is made up and faked. They believe it...But just again, the allegation here, the reckless allegation, the willing desire to destroy a doctor's career and reputation, all in pursuit of getting rid of Donald Trump...These people are shameless. They obviously have not an iota's worth of compassion or respect," Limbaugh stated.
But, I mean, the childishness and the ignorance and the prejudice. You can see the education these people are the product of and it's scary. And these are supposedly the best journalism has to offer. These are the people with the top jobs, folks, and they are children. They're dangerously unqualified, incurious, fact-absent, totally propagandized young kids.
This is pathetic. These people are… What's the word? They're obsessed, and the poison with which they're obsessed is hatred. Hatred and resentment. But they are literally boiling with rage each and every day.
RUSH LIMBAUGH: Ladies and gentlemen, the childish display, the childish exposition and behavior of the Drive-By Media yesterday once again has proven me right. The bizarre questions, the unhinged, childish, so transparently desirous questions from our Drive-By Media regarding the health of President Trump, has proved something. And interestingly enough, it's something that I highlighted yesterday. They believe this.
Now, I know a lot of you think that the media is just hitting on things to try to trip Trump up or to convince Trump voters that he's nuts and they say all these outrageous things. Like I told the audience at the Media Research Center gala that I keynote addressed back last fall, the danger here is that while they are actors, they do believe this stuff, folks! And their believability transfers to some of the brain-dead members of their audiences.
The media believes — they're not just trying to create the illusion — the media believes that Donald Trump is not fit to be president. The media believes he is in the early onset stages of either Alzheimer's or dementia. They believe that he is mentally teetering on the edge and with a gentle nudge daily from them, that they can send him over it. They believe he can't read. They believe he literally sits on his bed in the residence scarfing down Quarter Pounders with cheese and a double orders of fries. They believe that. It is not just a caricature or picture that they create. They believe it!
There's no way these people could act as stupid and dumb and childish for an entire hour as they did yesterday if they didn't believe it, if they didn't hope it, if they hadn't invested in it. They believe all of these sick fantasies that they conjure up. And this is why they often confuse their opinions with being facts. They mistake their fantasies for being truth, without evidence, without reading. They believed Obamacare would do everything Obama promised. And they still do.
If he was really only 6-2 and was what he weighs (239, is that the weight?), that would make him obese. Whereas at 6-3, he's not obese. He's just overweight. And obese means he's slovenly and irresponsible and is a slob and is going to die. So what we're watching here — with all due respect (chuckles) extended to that wacko senator from Arizona, Jeff Flake — is the media is the clown show. It is the media unfit. This current crop is entirely unfit to discharge their constitutional duties.
Well, we have to say it that way because they're given constitutional recognition in the First Amendment. You know a Republican is losing his mind when he goes to the floor of the United States Senate and praises the media and calls them "the truth squad" in an effort to rip Donald Trump as trying to destroy the truth and American institutions. These people — this current crop of Drive-By reporters — are unfit. They are unstable. If all it was was they are just partisan — just your usual, ordinary, everyday, standard leftist partisans — that'd be one thing. That would be tolerable.
But this is way beyond partisanship. This is way beyond bias. We're dealing with unhinged instability. Jim Acosta yesterday had to be thrown out of wherever they were, the Roosevelt Room, and Trump shut him down with one word: "Out!" So yesterday, Acosta said, "I never thought this could happen anywhere but an authoritarian country." Today Jeff Flake compared Donald Trump to Stalin! Right, Jeff Flake compared Donald Trump to Josef Stalin, who was a mass murderer, in the old Soviet Union.
The true Stalinists today are the American left. "Stalinist" defined as someone who demands that you think as they do and love it, demands that you agree with them and love it and love them. They will brook no discord and they will accept no intolerance. You believe them or you will be destroyed....But the vast majority of the White House press corps and the big names at cable news are actually what they accuse Trump of being. They are unfit for their jobs. They're not reporting the news. They're not trying to find the truth.
This is the same Drive-By Media that never batted an eye when Bill Clinton refused to release his medical records, even though STDs and venereal diseases and the drugs used to combat them can affect one's mind. But they were not interested in any of that, despite everything they knew. They covered for Bill Clinton not releasing his medical records, saying it wasn't important, that his approval ratings were sky-high; the American people didn't care.
It seems like it was only yesterday the Drive-Bys were talking about the Michael Wolff book and how the Wolff book claims some insiders describe Trump as childish and childlike. Well, what we had yesterday in the White House briefing room was nothing more than Romper Room without a teacher. The Drive-By Media was the kids playing in the sandbox, not getting their toys and not getting their lunches and not getting recess. This is the same media that never questioned Hillary Clinton when she could barely stand up!
The same media that never questioned Hillary Clinton when she collapsed trying to get into a van to make a fast getaway after almost having collapsed at a 9/11 ceremony. The same media that never asked Hillary about her supposed concussions. The same media that never questioned when she was wearing those thick Coke bottle glasses because of her double vision! They said it was actually double vision; it was to prevent seizures.
They believe he's insane. They believe he's gonna die. They believe it! That's why all this stuff, they think, is made up and faked. They believe it.
But just again, the allegation here, the reckless allegation, the willing desire to destroy a doctor's career and reputation, all in pursuit of getting rid of Donald Trump. These people are shameless. They obviously have not an iota's worth of compassion or respect. This doctor is just another person to be destroyed and sent packing on the road to getting rid of Trump. I mean, this is serious stuff, to accuse a White House doctor, any doctor of lying about it, making it up, accusing the president of threatening if they didn't make it up.
This has been a Drive-By story for many weeks now, and the thrust of it is that Trump is unstable. He's unfit. The lying, filled-with-errors Michael Wolff book suffices as evidence for these people that Trump is unfit!
And you heard the attempt here at getting at 239 pounds versus the height and would that be obese or any of this. But, I mean, the childishness and the ignorance and the prejudice. You can see the education these people are the product of and it's scary. And these are supposedly the best journalism has to offer. These are the people with the top jobs, folks, and they are children. They're dangerously unqualified, incurious, fact-absent, totally propagandized young kids.
This is pathetic. These people are…What's the word? They're obsessed, and the poison with which they're obsessed is hatred. Hatred and resentment. But they are literally boiling with rage each and every day. I guess they expected these results to be deadly for Trump, maybe even in a literal sense, and they just can't accept what they heard. It's too good. It defies what they know to be true.


Pumps seem easy to overlook, appearing more as a background tool to an industry than a necessity. However, they are an important backbone piece in numerous trades. They serve multiple functions depending on the business, responsible for moving both fluids and gases and presenting flexibility in what operates them, like electricity or wind power. Here are the most common kinds of pumps available and how they work.
This kind of pump is used for moving liquids via a balanced pressure system. This includes hydraulic pumps, which can be broken up into categories of piston pumps, vane pumps and gear pumps. Due to its use of pressure, a pressure regulator is necessary to maintain that balance, and these can be found by specific manufacturers, like arrow regulators.
An impulse pump uses gas found in a liquid to create its pressure. The gas is trapped and continues to build pressure the longer it sits. Upon its release, the liquid shoots up. A hydraulic ram, pulser pump and airlift pump all fall into this category of pump.
A velocity pump relies on the flow of fluid to increase velocity and create energy. In turn, that energy is converted into pressure once the velocity is again reduced. A unique trait of this pump is that it does not require a valve to be opened and closed to create pressure, which is required for a positive displacement pump.
This pump relies on a steam engine and piston to create a buildup of pressure. This pump is mainly historical, but recent interest in small solar steam pumps has caused it to resurface somewhat.
Evolving technology has transformed pumps numerous times over the years, adapting to as many possible energy sources as possible. Though they might not seem impressive to the unassuming eye, they are engineering feats that play major roles in commerce today.


easy question, how do I "un-jailbreak" my iphone?
Discussion in 'iPhone Tips, Help and Troubleshooting' started by mrfreeziexp, Jul 9, 2008.
I have a jailbroken 1.1.4 iPhone right now, how to I "un-jailbreak" it? Do I just hit restore on iTunes? Will that brick it?
Will this also lock it back to the carrier? I don't want that!
Yes. Restoring will return the phone to factory 1.1.4 settings (i.e. locked and no third party apps) If you want to keep using the phone on another network you can't restore or update to 2.0 until a jailbreak+unlock is released.


text:
AI and Machine Learning for Clinical Trials – Examining 3 Current Applications
Kumba Sennaar Last updated on March 5, 2019
Last updated on March 5, 2019, published by Kumba Sennaar
Kumba is an AI Analyst at Emerj, covering financial services and healthcare AI trends. She has performed research through the National Institutes of Health (NIH), is an honors graduate of Rensselaer Polytechnic Institute and a Master's candidate in Biotechnology at Johns Hopkins University.
The clinical trial is a foundational pillar of the pharmaceutical drug discovery process. Essentially, clinical trials are research studies which seek to determine if a medical treatment or device is safe and effective for humans. While the pharmaceutical drug industry has experienced some fluctuations it remains a profitable market. Global prescription drug expenditures are estimated to reach nearly $1.5 trillion by 2021 according to Quintiles IMS Holding.
However, major challenges facing researchers structuring clinical trials are high costs and have low rates of success. According to the U.S. Food and Drug Administration, roughly 1 in 10 of drugs tested in human subjects receive FDA approval and millions of dollars are invested in the research process.
In this report, we set out to determine the answers to the following important questions:
What types of AI applications are emerging to improve clinical trial efficiency and optimization?
How is the healthcare market implementing these AI applications?
The majority of AI use-cases and emerging technologies for clinical trials appear to center around three primary applications:
Patient Recruitment: Companies are developing software platforms to better match patients to clinical trials based on specified criteria.
Clinical Trial Design: Companies are developing machine learning algorithms to help researchers manage clinical trial workflows.
Clinical Trial Optimization: Companies are developing machine learning models to predict which patients are at risk of dropping out of clinical trials to prevent threats to trial validity.
Founded in 2010 with headquarters in London, England and offices in New York, NY and Carmel, Indiana, Antidote claims that it uses machine learning to connect patients to medical research studies through its clinical trial matching platform.
Using algorithms trained on high volumes of patient eligibility criteria for clinical trials, thousands of open trials are searched by the Antidote Match search engine based on user responses to a questionnaire.
Upon accessing Antidote's website, patients searching for clinical trials are prompted to provide responses to a series of questions about their health such as "for what condition are you looking to find a clinical trial?" and about their location to be matched to opportunities nearby.
In the 2 minute video below, CEO and Founder Pablo Graiver and Antidote staff discuss the mission of the company and its potential value to the drug discovery process.
According to a case study, a clinical trial relating to Alzheimer's disease required 10,000 participants in 2 months. Antidote claims that through its platform and partnerships, it "delivered 8,000 of the required 10,000 referrals in less than 2 months [and its referrals] were seven times more likely to complete the required follow-up than referrals from other sources."
Through Antidote's Connect Network, the company has expanded its platform access to health organizations by allowing the Match search engine to be embedded into websites. As a result, the company claims that its platform reaches over millions of patients through more than 180 online communities.
Companies partnering with Antidote include the National Kidney Foundation, Lupus Research Alliance, and Healthline.
Staff members with machine learning experience include Tom Reeve, a London-based Data Engineer trained at the University of Essex. To date, Antidote has reportedly raised $28.9 million in funding and is backed by the Merck Global Health Innovation Fund.
Deep 6 AI
Founded in 2015 and based in Pasadena, California, Deep 6 AI claims that it uses natural language processing (NLP) to better match patients to clinical trials.
Deep 6's algorithms are trained on patient medical data and thousands of clinical data points, such as symptoms, diagnoses, and test results, and they are extracted from patient health records. The company claims that it can execute the extraction process "while masking protected health information."
Next, the extracted clinical data points are aggregated to develop a clinical profile. The clinical profiles are used to find and compare populations, cohorts, and individual patients meeting user search criteria.
In the 2-minute video below, CEO and co-founder Wout Brusselaers provides an overview of the company's goals to use its platform to help accelerate access to drug development.
In a case study, the company describes how it assisted Cedars-Sinai Heart Institute in improving its ability to identify eligible patients for a research study. Prior to implementation, the research team required an average of six months to identify two eligible patients for a clinical trial requiring a total of eight patients.
Using the Deep 6 AI platform, Cedar Sinai was reportedly able to identify 16 patients meeting the eligibility criteria for the trial in an under an hour.
B. Kerim Tshimanga is a Data Scientist for Deep 6 AI with machine learning and deep learning expertise. He received his degree in Physics from the University of California, Santa Barbara.
Clinical Trial Design
Trials.AI
Founded in 2015 and based in San Diego, California, Trials.AI claims it leverages NLP to help researchers more efficiently manage clinical trial workflows.
The algorithms driving Trials.AI's cloud-based Study Optimizer platform are reportedly trained on "billions of data points from past clinical trials, medical journals, and real-world sources" to identify risk factors and provide recommendations for clinical trial optimization.
For example, the process begins with a user uploading his or her research protocol documents in Microsoft Word or PDF to the platform. Risk factors are identified by analyzing the protocol text, and any potential barriers to a successful trial. such as recruitment and retention, are reported on a dashboard.
Based on the insights derived from the analysis, the platform provides recommendations for mitigating risk to optimize the research protocol. Multiple team members can collaborate on the platform to help navigate stakeholders through their trial. This enables all team members to be informed.
At 2:20 in the 6-minute video below, Kim Walpole, co-founder and CEO of Trail.AI, discusses the features and potential benefits of her company's platform.
Walpole claims that Trials.AI helped the Moores Cancer Center at UC San Diego Health shorten its study timelines by nearly 33% and reduce data errors by 20%.
The revenue model entails a one-time onboarding fee and a subsequent monthly data storage fee per trial. At the time of Walpole's presentation, sponsored trials onboard at $15,000 with a $833 monthly fee. Enterprises onboard at $100,000 with a $250 monthly fee.
We were unable to find an estimate for the total amount of funding that Trials.Ai has raised However, investors include DreamIt Ventures, Nex Cubed, and EvoNexus. According to LinkedIn, the company's Principal AI Architect is Fuad Rahman, who earned his PhD in Computer Vision and Pattern Recognition from the University of Kent in the United Kingdom.
BullFrog AI
Founded in 2017 with headquarters in Annapolis, Maryland, BullFrog AI claims that it uses machine learning to predict more accurate matches of patients to therapies in development.
The startup claims that its platform bfLEAP was developed over the past seven years at The Johns Hopkins University Applied Physics Laboratory. Trained on high volumes of clinical data, BullFrog AI's algorithm drives the platform which conducts data mining to identify relationships and patterns within large, complex data sets.
For example, the software application starts the process by receiving a set of clinical data, the data is cleaned, analysis is performed, data correlations are made and predictive models can be generated.
In February 2018, the startup announced its strategic partnership with the Lieber Institute for Brain Development in an effort to improve antipsychotic drug selection for patients. In a quote, Kristin Bigos, MD, a lead investigator with the Lieber Institute, provides more context around the challenges to targeted drug selection:
Until now there has been no effective alternative to the trial and error approach for matching patients to the best antipsychotic. Being able to understand and predict which drugs will work best for which patients would be of tremendous benefit to both patients and the physicians that serve them.
In a case study, the startup claims that from a set of 240 million data points, the system identified 30 targets of interest, and ultimately seven of those were confirmed as accurate targets. Using standard methods, the same process would required 70,000 targets instead of just 30 to achieve the same results.
We were unable to determine the amount of funds the company has raised to date through our research, nor does the company list any employees on its Linkedin Profile. It seems Bullfrog is just getting off the ground.
Clinical Trial Optimization
Brite Health
Founded in 2015 and based in Palo Alto, California, Brite Health claims that it leverages machine learning to better manage patient engagement in clinical trials.
The company's patient app and site dashboard are driven by its algorithm, which is reportedly trained on millions of clinical data points. The recommendation engine is able to identify key markers that tend to correlate with patient disengagement from research studies.
For example, through the mobile patient app (shown below), the system sends notifications to the user related to their scheduled tasks and site visits throughout the clinical trial. Engagement with the app is also encouraged through curated content and personalized communication. A conversational chatbot customized with approved study materials is available to patients at any time.
Research teams are able to monitor patient engagement and adherence using the platform's dashboard (shown below). Insights and notifications from the recommendation engine allow earlier intervention with patients to prevent nonadherence and dropouts from the study.
We were unable to find case studies or the total amount of funds raised through our research. However, current backers include Plug and Play Ventures and Unshackled Ventures.
Brite has participated in a Health and Wellness Innovation Program led by Pfizer, and Bayer's Dealmaker program.
There does not seem to be any C-level executives on the team with an AI background. We caution readers to be wary of companies that claim to do AI without any C-level AI experts on their team.
Takeaways for Business Leaders in Healthcare
While it is important to note that the majority of companies profiled are within their first few years of operation, applications targeted towards patient recruitment appear to have the strongest traction.
For example, pharmaceutical firms such as Merck have invested in Antidote's platform which may offer important value to accelerate the R&D timelines by identifying the right candidates at a much faster rate. Considering the length of a successful clinical trial can run as long as 10 to 15 years from start to finish, time-saving strategies are of critical importance.
In contrast, patient engagement and optimization are some of the newest applications of AI. These applications require more case studies to gain a deeper sense of their potential competitiveness in the pharma industry.
This data will be particularly important in the case of patient engagement. As more healthcare providers use health IT to manage patient health getting patients to consistently use multiple apps may present challenges.
For large, international studies with thousands of patients, multiple language options will be needed to meet the needs of participants around the globe.
Whereas patients seeking clinical trials are often self-motivated to participate and tools to help them discover relevant opportunities could be an easier sell.
As the volume and complexity of clinical data continue to increase, AI applications offer potential value to the clinical trial process and the pharmaceutical drug industry.
Header Image Credit: International Myeloma Foundation
Discover the critical AI trends and applications that separate winners from losers in the future of business.
Sign up for the 'AI Advantage' newsletter:
Related posts (5)
The State of AI Applications in Healthcare – An Overview of Trends
This article is based on a panel discussion facilitated by Emerj (Techemergence) CEO Dan Faggella on the state of AI in the healthcare industry. The panelists were Just Biotherapeutics Chief Business Officer Carolina Garcia Rizo (representing healthcare startups) and Senior Manager for A.I./Machine Learning at Bayer Kevin Hua (representing big pharma). This session was part of the Applied Artificial Intelligence Conference by Bootstraps Labs held in San Francisco on April 12, 2018. The video of the panel is provided below:
Machine Learning in Radiology – Current Applications
It should come as no surprise that AI has found its way into radiology in a similar fashion to most other medical fields. Many AI vendors selling into the radiology field are just beginning to gain regulatory approval. We researched the use of AI in radiology to better understand where AI comes into play in the industry and to answer the following questions:
Machine Learning in Genomics – Current Efforts and Future Applications
Genomics is a branch of molecular biology focused on studying all aspects of a genome, or the complete set of genes within a particular organism. Today, machine learning is playing an integral role in the evolution of the field of genomics.
Machine Learning in Real Estate – Trends and Applications Presented
This article is based on a presentation originally given by Daniel Faggella, CEO & Founder at Emerj (formerly TechEmergence) to a group of real estate executives at a Grupo4s "Future of Real Estate" event in San Francisco, in March of 2018.
Machine Learning in Sales Enablement – Applications and Considerations for Sales Leaders
Sales enablement refers to any technology solution designed to increase productivity during the sales cycle, usually for enterprise business development. Whether managing many sales reps in a large organization or increasing a single sales executive's conversion rates, the primary goal of sales enablement is to push productivity numbers up and to the right.
PDF Brief: 3 Ways to Spot AI Trends
Learn three simple approaches to discover AI trends in any industry. Download this free white paper:


Akash Ambani and Shloka Mehta formally got engaged in a grand engagement ceremony held at Antillia in Mumbai on June 30, 2018. The Who's Who of Bollywood attended the grand event.
The couple looked gorgeous as they came out to pose for the paparazzi. The functions for the ceremony started off a few days before. Reports said that a high profile floral designer from California was flown in for the decoration of the venue.
Akash looked royal in a maroon sherwani with a white pyjama while Shloka looked pretty in a pink embroidered lehenga. The couple was seen posing with Nita Ambani and Isha Ambani. The engagement ceremony was hosted by Shah Rukh Khan, who attended the ceremony with wife Gauri Khan and son Aryan Khan.
Akash had formally proposed Shloka in March, 2018 in presence of family members in Goa after being together for five years. The wedding is expected to take place by the end of 2018.


Chile has a significantly high exposure to disaster risk, with extreme natural events being a major part of its history.
The situation has pushed the country to strengthen its resilience, learning lessons after each major event suffered. Initially exclusively reactive, Chile has turned towards a more preventative attitude, making it today one of the leading countries in coping with major seismic events.
We are pleased to publish our latest document, Public Warning in Chile: Resilient Culture. The document highlights the risks faced by the 4000km long country and discusses how emergency response structures can be used effectively, with a special focus on the use of public warning systems.
EENA would like to thank the authors and contributors of this document, including EENA Members Maria Jesús Pérez Cotta (Spain) and Victor Orellana Acuña (Chile), as well as EENA team members Cristina Lumbreras and Ana Romero.


Distinguished by its wood cladding, blue Board and Batten shutters, and welcoming verandas, this classic yet informal beach retreat combines contemporary architectural influences with historic New England born aesthetic. Wooden pathways transport you through the picturesque community nestled among the rolling dunes of WaterSound Beach. The home's arbor adorned with flowering vines welcomes you to this 4,257 square foot estate which features a fun and functional reverse floor plan. The spacious 4 bedroom main house with a bonus bunk room offers an appointed carriage house and can be found in the heart of the private community. Soaring ceilings, wood floors and natural light abound, this home donned in ornate wainscoting and simple shiplap paneling creates a coveted andcomfortable beach cottage escape for your family. The main floor living room features shiplap ceilings with beautiful beams running crosswise, and vertical wood paneled walls to accentuate the elevated interior. Two expansive guest suites and a double room with a detached bath can also be found on the main level of this home, as well as, a bonus bunk room for four with built in storage space. The heart of the home can be found on the second level, which features an open concept great room, a spacious coastal kitchen, and a dining room; which encompasses a dividing wall of picture windows that flood the space with natural light and adds a charming detail to the room. The open kitchen offers crisp white cabinets,carrara marble countertops, a center island and breakfast bar, apron sink, a 1950's vintage Northstar fridge, and a classic 1940's antique Wedgewood stove. The home's great room offers vaulted wood paneled ceilings with exposed beams, transom lights and access to a covered porch. Off of the expansive dining room with seating for eight, you can enjoy alfresco dining year round in the screened-in eating porch. Also on this level is a spacious master suite with an attached master bath, expansive walk-in closet and a private screened-in porch. Enjoy the added convenience of the home's elevator and attached two-car garage. The top floor of this home offers an expansive crow's nest featuring panoramic views of WaterSound and the emerald green hues of the Gulf of Mexico. The home offers a screened in front porch flanking the front door, a convenient landing pad connecting the main house and carriage house, laundry rooms on both levels of the home, a screened in patio connecting the main house and garage, and multiple window benches meant for enjoying a good book. This one of a kind WaterSound beach house is a MUST SEE!


Surprise field trip! Future Farmers of America.
Our business card is our soil punch card also! Buy 10 bags and get one FREE!
With anything you ingest, it's smart to use FoxFarm organic soils. We have plenty of it in our expanded soil room.
7 pallets unpacked in 2 hours!! Stacked and packed with the largest soil and coco selection in town. Thank you for making us your favorite grow store!
Our Customers are the BEST! Warm cookies and cold milk! Thanks J and T!
Free Supreme Growers Myco Tea ALL SUMMER LONG!!
Please bring your own jug. Watch your plants pop with our exclusive tea.
Pest Problems?! We've got you covered. Fresh ladybugs and numerous organic solutions.
It's Always Customer Appreciation Day!!
It's always customer appreciation day at your locally owned friendly grow store. Come see some our exclusive products and great prices.
We have some large 1 gallon and half gallon Ball jars. Really fun for salads to curing along with custom glass ones with our logo & Seattle 12s etched in. Stop by for all your growing needs.
Ready to set up your Mother's Garden??
Oxygen Pot Systems NEW system would be a great way to introduce Mom to hydroponics.
Plus we have the cloth bags and extension kits! Stop in for specials all weekend.
A BIG THANKS to Hydrofarm, Cutting Edge Solutions Lush LED, Botanicare, House and Garden Nutrients, Oxygen Pot Systems, Smart Pots,MagicalButter.com ,Concentrates, General Hydroponics, Gorilla Grow Tent, Supreme Growers, FoxFarm Kindra's Wok 'N Roll for all your support with our open house. Join us tomorrow April 11th, from 10am - 4pm! Raffle held at 2 PM for those who have raffle tickets.
You MUST be here to collect prize.
Future Hydrofarm Employees! Working to make the store happy and clean!


text:
Karel Bělohoubek (Žarošice, regio Kyjov, Moravië, 29 december 1942) is een hedendaags Tsjechisch componist, muziekpedagoog, dirigent, klarinettist en fagottist.

Levensloop
Nadat hij de eerste klarinetles bij Rudolfa Zavadila had studeerde Bělohoubek van 1956 tot 1959 fagot en klarinet aan de Militaire Muziekschool in Roudnice nad Labem, bij Litoměřice in de regio Ústí nad Labem.

Na het studium werd hij in 1959 lid van het militaire muziekkorps in Stříbro en verbleef hier tot 1961. In hetzelfde jaar vertrok hij naar Praag en werd lid van de Posádkovoá hudba Praha (militaire kapel van de garnizoen). Later wisselde hij in het Ústřední hudba Armády České republiky (Centrale blaasorkest van het Tsjechische Leger). Tegelijkertijd zette hij zijn fagot-studies aan het Praags Conservatorium bij Karel Pivoňka voort. Aan dit conservatorium studeerde hij ook dirigeren bij Bohuslav Čížek. Voor het dirigeren kreeg hij ook nog privé-les van Prof. Bartoše.

In 1978 werd hij dirigent bij het Ústřední hudba Armády České republiky (Centrale blaasorkest van het Tsjechische Leger) in Praag en werd in 1987 tot chef-dirigent benoemd. In deze functie bleef hij tot hij met pensioen ging in 1999.

Al in jonge studentjaren heeft hij zich voor instrumentatie geïnteresseerd en zijn vakbekwaamheid als arrangeur en componist voortdurend verder gebracht. Eerst deed hij bewerkingen voor blaasorkest van bekend klassiek repertoire zoals Ouverture tot de opera "De Verkochte Bruid van Bedřich Smetana, de Bolero, van Maurice Ravel, de Symfonische dansen uit het musical "West Side Story" van Leonard Bernstein. Later schreef hij eigen werk, dat meestal door zijn orkest, het Ústřední hudba Armády České republiky (Centrale blaasorkest van het Tsjechische Leger), werd uitgevoerd en soms ook op cd opgenomen.

Hij is ook een veelgevraagd jurylid bij nationale en internationale wedstrijden. Verder is hij hoofddirigent van het symfonisch orkest Prague Festival Orchestra.

Composities

Werken voor harmonieorkest
 Alla Marcia, mars
 Auf der Prager Burg, mars
 Bagatellu pro lesní roh - Bagatella, voor hoorn en harmonieorkest
 Barytonetta, voor bariton/eufonium en harmonieorkest
 Bolero
 Briosso
 Clarinet Czárdás
 Concertino, voor klarinet en harmonieorkest
 Chvilka Rubata
 Drei Amselbrüder, voor Es-klarinet en 2 Bes-klarinetten en harmomnieorkest
 Eine kleine Weile, concertstück
 Feierabend-Polka
 Grotesky pro fagoty s názvem Bručouni (Groteke voor fagot als brombeer)
 Gute Laune für Blechbläser - (Goed humeur voor koperblazers)
 Habanera
 Intrádu
 Klarinetový čardáš
 Kleine Etüde
 Launische Jugend
 Malou etudu - Mala Etuda - Piccolo-Kapriolen
 Malé polky a valčíky Rozmarné léto
 Matinátu - Mattinata, voor sopraan-saxofoon en harmonieorkest
 Meditace
 Metamorphosis of the Wind, wals
 Neposedna Polka - Schenk mir ein Lächel'n
 Ozvěny
 Piu Avanti
 polky Pálavanka - Pálavanka Polka
 Perličky stříbrného plátna
 Podzimní promenády
 Polonézu - Polonaise
 Polky Pro dva
 Polky Pro tri, voor flügelhoorn, bariton/eufonium, tuba en harmonieorkest
 Preludio
 Promenaden-Walzer (concertwals)
 Reminiscence - Die Reminiszenz
 Romanci pro křídlovku a tenor - (Romance voor flügelhoorn (bugel) en bariton/eurphonium)
 Russische fantasie
 Selanky pro trubku - Selanka, voor trompet en harmonieorkest
 Serenádu - Serenade
 Stavarska polka
 Svaty vaclave choral - (Wenzel koraal)
 Teufels-Galopp (Duivelsgalop)
 Ukolébavky
 Vorwärts!, mars
 Welcome March
 Zabicka
 Žarošické Polka
 Zastaveníčko
 Zdravice - Begrüssung - Salute
 Zpev Skrivana - Gesang der Lerche, solo voor twee klarinetten en harmonieorkest

Externe link
  Biografie

20e-eeuws componist
21e-eeuws componist
Tsjechisch componist
Tsjechisch dirigent
Tsjechisch muziekpedagoog

redpajama_set_name: RedPajamaWikipedia


With the battle for recognizable public policy ends turned drastically against them — the National Energy Board's Joint Review Panel for the Northern Gateway Pipeline recently recommended it be approved — opponents of the oil sands are turning to what would be some new tactics. They would be new, that is, if they weren't already so old.
The role BDS played in the defeat of Apartheid has long been subject to debate. There have even been some arguments that BDS prolonged Apartheid, rather than shortening it.
But at least the BDS campaign, as applied to South African Apartheid, had one undeniable strength: it had a number of demands — simply, the end of Apartheid — that were achievable and morally superior to the status quo. There was simply no morally acceptable argument for the upholding of Apartheid.
The BDS campaign, as applied to the oil sands, has neither of these strengths. The demand to keep Albertan oil "in the soil" is not achievable, nor is it morally superior to the status quo. It is, in fact, ethically inferior to the status quo, and doubly inferior compared to expansion of the oil sands.
The BDS campaigners have put themselves at odds with a concept that so far none of its detractors have been able to counter: that concept, of course, being that of ethical oil.
The concept, popularized by Ezra Levant but owing at least equal credit to intellectual progenitors such as Mike Milke, holds that while oil is an imperfect fuel, no perfect fuel currently exists. Oil is the best currently available. And seeing as this is the case, oil will remain necessary until a better substitute is developed.
-Human rights – is that oil produced in an environment that values human rights? Are minorities treated fairly or ruthlessly?
-Environmental protection – Is that oil produced with environmental protections in place?
-Economic benefit – Is the economic benefit of that oil shared, or is it reserved for a select group of people?
-The promotion of peace or conflict – Does the production of these oil resources fuel violence in the place where it is produced, or elsewhere in the world?
Whether oilsands critics care to admit it or not, oilsands oil gets a passing grade on all four of these criteria. It doesn't score perfectly, but it passes.
But given that we've determined that oil will be used, if Alberta oil — in particular oilsands oil — remains "in the soil," as these activists demand, where will Canadians get their oil? Where will the people who would otherwise buy Canadian oil buy their oil? From whom?
The answer, as Levant has hammered over and over again, is quite simple: from Middle Eastern dictatorships and theocracies such as Saudi Arabia, or from failed state regimes such as Sudan. Places where human rights are not respected. Places where the environment is not protected. Places where oil money is horded for the sole benefit of royal families or ruling elites. Places where civil wars are fought over oil, or where the proceeds from the sale of oil are used to fund terrorism abroad.
Remarkably, if divestment from the oilsands were to lead to a shutdown of oilsands production, some very Apartheid-like regimes would find themselves profiting very handsomely from it. Which is ultimately where the movement to convince Canadian universities to divest from oilsands production meets the utter depths of its moral nadir.
These are, unfortunately, people who seem to lack the will to explore these issues in anything even resembling the requisite depth. Suffice to say, the fact that these people don't like the concept of ethical oil doesn't make it any less valid. They ignore it — and act in a manner that would funnel business to very unethical oil producers — at their own moral peril.


text:
Q: Oracle - sum hours I have a table with some FROM / TO columns that represent hours:
FROM    TO
00:00   02:00
04:00   05:00
15:00   18:00

What I need to to sum the FROM / TO rows and see if they equal 24 hours.  Not sure how to do that.....

A: Theory
To solve this you need to do 2 things:

*

*Calculate the time difference between the two timestamps:

Calculating difference between two timestamps in Oracle in milliseconds
Another option is to just subtract the two columns and multiply by 24 (you should get back the hours).

*Sum the result which is basically sum()

*Check hours are greater than 24
Example 1
So a good first try would be something like:
SELECT sum((toTime-fromTime)*24) from data;

DbFiddle: https://dbfiddle.uk/?rdbms=oracle_18&fiddle=fd91fd44b4c8ef7066dcdcc47ba64a9c
Problem with simplified Example
However, we have a problem because we don't take the day into account. So the next step is to also use the group by function and calculate the total hours by date
Here is a solution for that:
SELECT to_char(fromTime,'DD/MM/YYYY'), sum((toTime-fromTime)*24) from data
group by to_char(fromTime,'DD/MM/YYYY');

https://dbfiddle.uk/?rdbms=oracle_18&fiddle=d861ee1b0252cb2dcd3bbf6901f12a5f
Add a true/false for If we have 24 hours:
SELECT to_char(fromTime,'DD/MM/YYYY'),
case when sum((toTime-fromTime)*24) = 24 then 'YES' else 'NO' END as is24
from data
group by to_char(fromTime,'DD/MM/YYYY');

https://dbfiddle.uk/?rdbms=oracle_18&fiddle=ef0df7ad12c2da1a107b4628619df5a1

A: Although Menelaos has a good answer for working with real timestamps (and you could convert your strings to timestamps and use that answer), given that you have varchar2s and the hours are always even, you might also find this useful:
To get the part of the number before the colon, you can use SUBSTR and INSTR to do something like SUBSTR("TO", 0, INSTR("TO", ':')-1).
Then you can convert that to a number using TO_NUMBER by doing something like TO_NUMBER(SUBSTR("TO", 0, INSTR("TO", ':')-1)).
You can then subtract "FROM" from "TO" to get the difference for each row and use the aggregate SUM to total them. So the final query looks something like:
SELECT SUM(TO_NUMBER(SUBSTR("TO", 0, INSTR("TO", ':')-1)) - TO_NUMBER(SUBSTR("FROM", 0, INSTR("FROM", ':')-1)))
FROM mytable

A couple of comments:
If you know for sure that the times are always even hours, it would make more sense to just store them as numeric values. You could always present them to users in a different format, but storing the ":00" is just redundant and makes working with the values harder.
On the other hand, if you think that in the future there might be minutes or seconds or ranges that cross date boundaries, you're going to save yourself a lot of trouble just using a more appropriate type to start with (date or timestamp).
I double quoted the column names "TO"/"FROM" in my examples since they are reserved words. I'm not sure if using reserved words in column names is considered good practice in general, but it's something I tend to avoid.

redpajama_set_name: RedPajamaStackExchange


Paramount Trophies do not collect any personally identifiable, financial or health-related information.
Non-personally identifiable information (non-PII) is collected to allow us to analyse how our website is used and to improve the content and service our website provides.
Paramount Trophies owns the collected information and will not sell, trade, or rent the information to others. We may use the information to continue contact with the user. This may include contact such as follow-up calls, e-mail correspondence, or mail correspondence to follow-up on the contact or to provide marketing information about promotions, new services, or important website changes. Paramount Trophies may share this information with its business partners for the specific purpose of a promotion or service offering.
Paramount Trophies utilises industry standard methods and mechanisms such as firewalls, intrusion monitoring, and SSL (Secure Sockets Layer) password protection, the standard eCommerce security protocols for establishing an encrypted link between a web server and a browser to protect your electronic information. Multiple physical security methods such as locking devices and 24 hour premise monitoring are also employed. Finally, access to PII is limited to a small number of personnel and on a need-to-know basis.
Paramount Trophies website may contain links to other internet websites. Paramount Trophies neither controls nor endorses external websites and is not responsible for the content of such sites. This policy does not cover the privacy policies and data collection practices of non-Paramount Trophies websites.