Jump to content

gyroprotagonist

Certifiably Surly
  • Posts

    2,529
  • Joined

  • Last visited

Everything posted by gyroprotagonist

  1. thanks, i will take a look at that. i was able to brute force it in a similar fashion. I used a fixed INDEX(1,1)... INDEX(1,22) where you have the [@1]. and yes just parsing each row individually. Risking causing a coma from boredom, each row is Purchase Order (part #, qty, initial date). There are multiple POs for each part #. The table beside the 'Text' col (Table 1) is pulling from a condensed table that only has 1 row for each part # and has the total amount product available each week. The function of Table1 is to split up the condensed data into chunks that correspond to each PO and put those chunks into the right weeks. easier to see below. Condensed table on top and Table 1 on the bottom. The Text part of it is the result of any changes on how the POs are currently loaded. The group that makes all these changes wants the data in that format, so I was trying to automate it. I don't doubt there is a better way to ultimately input the data, but I am not digging into their SAP crap if I don't have to.
  2. bump so is this possible with excel? I have a table with Weeks for col headers and qtys in certain weeks. I want to create a cell (Text col) that will list each qty by week. Is there a way/function to do this? Parse a row, grab non-zero values, and then combine the qty with the corresponding week. I think i could do a massive IF chain tied to INDEX, but wondered if there was more elegant solution
  3. vax rate falling? Florida: "Hold my beer" https://www.clickorlando.com/news/2021/04/27/florida-private-school-wont-allow-teachers-staff-to-get-covid-19-vaccine/ This has to be a record for stupidity, right? Makes gender reveal parties look like a gathering for the Nobel prize in Physics.
  4. [aggy] don't knock the combusto-fecal trouserrian lifestyle until you have tried it [/aggy]
  5. hmmm. i am guessing there will not be an exception for kids under the age of 12. We had to cancel a fam trip to UK/France in summer 2020. kiddos are 13 and 10. good to see it's opening up again at least.
  6. reminds me of where i used to work. it was in the microchip assembly sector and we used a couple of xray machines. completely enclosed (lead lined) units and nothing like the dentist and doc office ones. I lost a bet and was the prestigious Radiation Safety Officer and had to explain any risks and procedures on what to do the machines were malfunctioning. I tired various factoids (rad dose from a 3hr flight is way more than using machine, inverse square law,etc...) and half the people that worked in the same room as the units said the machine did something to their blood when they were near it. Showing them the rad meter reading from the break room vs 10cm from the active machine (the same reading) made no difference. Dunno what it would take. either money, right to work, right to enter certain places.
  7. seems like that could save money in the long run. from the web, it said avg cost of C19 hospital stay with no insurance was between $35K-70K. - you have 550K deaths. Let's just cut it in 1/3 and say 185K were in a hospital at time of death and received expensive care as the worst of the worst cases. 185K * $35K = $6.48B. take that money / $50 incentive and you have a max potential of getting another ~125M vaxxed to save money on any hospital stays. Insurance companies should be righting over to right to pay people to get vaxxed. Some are, i think in forms of rebates or less taken out of your check for company provided ins. But we as taxpayers who foot the bill for emergency room primary care should want to spend money to save lives and money by paying people to get vaxed.
  8. So we are sorta back with some Q-level shit from texags https://texags.com/forums/16/topics/3195807/1 started as a vax thread, but the Q is strong in this one. you know it's good when this is the OP and we have a Billy-bad-ass sighting. look out over here... This below guy is awesome. he gets a reasonable response to why flu is down this year and then...checkmate... an unbeatable analogy. and then the coup de grace
  9. In English phonology, t-glottalization or t-glottalling is a sound change in certain English dialects and accents that causes the phoneme /t/ to be pronounced as the glottal stop...It has long been seen as a feature of Cockney dialect (wiki on t-glottalization)
  10. ebay peeps, sorry to crash the thread, but we got hit when someone hijacked a dormant ebay registered to my wife, sold a bunch crap and now ebay is trying to come after us for money they paid out in refunds. We started getting all these return shipments from random people. It was all flea collars for pets. probably received 20 packages and it had info that it was an account for my wife. we could not log in the account or get a password sent (old email we no longer had access to). So called ebay and tried to report the fraud and that we were not in control of the account. They were spectacularly unwilling to do anything. would not shut down the account, would not tell us who was running the account the now or stop the auctions. zero fucks given by them. fast forward a couple months, the returns stop coming and we think we are done with it. but now ebay sent some collection letter because we had not refunded money to the people send back flea collars. Does ebay have no way to clawback money from the seller account receiving the money? I guess these guys just move on the next fraud account, set up to receive money and then shut it down when the returns start coming in.
  11. the only variant i have seen that AZ has not proven effective is the South African variant. there is just too little data to make sweeping statements like "the vaccine is ineffective against known variants" . AZ does very well against the UK variant (70% efficacy; linky). With the very limited data it had vs the SA variant, it did not do well in preventing infection. I don't think there is any data with AZ preventing hospitalization and death vs SA variant good or bad. https://theconversation.com/astrazeneca-covid-19-vaccine-faq-why-do-the-age-recommendations-keep-changing-does-it-cause-vipit-blood-clots-is-it-effective-against-variants-158302
  12. agree the message needs to move to incentivizing people to get the shot. There are several articles out there about people catching covid after the vax. This is not shocking as i think best case the mRNA vaxs are 90% at preventing infection. The initial numbers from the CDC on breakthrough cases seem pretty low (compared to the 90% expected efficacy) at the moment. one thing these articles are also saying is that pretty much everyone agrees that the vaxs are ~100% effective of stopping hospitalization and death. So again, another huge incentive, but vax hesitant people don't really care about probability of stopping death but likely would care about not wearing a mask to shop or travel. https://www.pbs.org/newshour/health/the-shock-and-reality-of-catching-covid-after-being-vaccinated https://www.statnews.com/2021/04/20/no-myth-catching-covid-19-after-being-vaccinated/ so again, people can (literally) live with getting a mild case of covid after vaxxing. no big deal in my mind and just a step in the process to 'getting back to normal'. 10-20% of vaxxed people will get sick, recover and move on again. I think as more and more people get vaxxed and hit their 2 week milestone, there will start to be pressure put on retailers to stop mask mandates. What's happening in India and other parts of the world are reminders how fortunate the US is in vaxs delivered to citizens and how effective they are. This is scary. almost 3K per day and you can bet that the number is vastly underreported right now. https://www.nytimes.com/2021/04/24/world/asia/india-coronavirus-deaths.html Also, India was poised to export AstraZeneca's vaccine Covishield to other parts of the world, but now will likely put that on hold. The AZ vax seems to have a good efficacy at 1 dose (~70%) so hopefully that will help. only 8% of the population has 1 shot administered so far and < 2% fully vaxed. compare to 42%/29% in the US.
  13. Drummond was just rebounding over every Mav last night. From the 2H that I saw, way too many 2nd chance points given up. Mavs countered every Laker run and would get off their duff and score when needed. Seeing the KP ankle bend, he should be ok. he did not step on anyone's foot. But who knows with KP. probably a grade 11 high ankle sprain.
  14. 20lbs of tannerite is the sweet spot. only got the local sheriff out to see what the fuss was about. no other towns nosing around.
  15. if they don't have a plan to redistribute the glut of vax that is about to be apparent in the US, the gov needs to get on that ASAP. I read there were clauses in the original vax contracts the Trump admin signed with vax makers that prohibit the use outside of the US. from vanity fair piece: https://www.vanityfair.com/news/2021/04/why-the-us-still-cant-donate-covid-19-vaccines-to-countries-in-need In the grand scheme of things, whatever % of whatever group that refuses to get vaxed in the US is not the big issue when it comes to variants and all that. The US has been the leader in cases and deaths for so long, I had not really looked at much world news lately RE: covid. my how the turntables... I think the US better figure out how reroute some of theses vax doses ASAP. Hell, maybe telling the vax hesitant that these foreigners are going to take their dose will suddenly spark a desire to claim one. It sure works that way for my kids when we take some of their old toys to be donated.
  16. so it's not just my lying eyes. These guys miss a shit ton of wide open 3's
  17. reminded me of this scene Jules: Hash prostitution is legal there, right?Vincent: Yeah, it's legal, but it ain't a hundred percent legal. I mean, you can't walk into a restaurant, roll a joint drop trou and start puffing boinking away. You're only supposed to smoke boink in your home or certain designated places.Jules: And those are hash unlicensed massage bars?Vincent: It breaks down like this: it's legal to buy flash it, it's legal to own it, and if you're the proprietor of a hash unlicensed massage bar, it's legal to sell it. It's legal to carry advertise it, but that doesn't really matter 'cause get a load of this, all right? If you get stopped by the cops in Amsterdam Manhattan, it's illegal for them to search you arrest you for loitering. I mean, that's a right the cops in Amsterdam Manhattan don't have.
  18. it sure is easier to look smart when you are sparring vs Trump. I guess she really misses that backdrop to work from. Just a mind-numbingly stupid thing to think much less say out loud regarding a murder victim.
  19. yeah, dude looks pretty foolish, but it seems every expert has hailed variants as very bad news with not much data to back it up. there very well could be a variant out there that is truly resistant to the vaxes, but i don't think we have seen that yet. Minn did sorta buck the national trend though and increased cases from that point. But certainly not to the hyperbole of the attributed quote. I don't know if scientist are truly worried about these variants and are trying to inject more urgency (fear) into the populous to get vaxed. I get not leaning too hard the other way and saying no worries at all about the variants, but after the discovery of a variant and the initial claims that this one is/may/potentially resistant to current antibodies, i have not seen too much follow up that any variant is truly a c-c-c-c-combo breaker! for the vaxed and recovered. hope it stays that way and there is really not a need for a variant booster.
  20. This is really huge especially compared to the countries using the Sinovac vax, where it's reported that there is only ~3% efficacy after the 1st dose and then up to the 50-60% after the 2nd.
  21. i'm potentially going to win the lotto today. WTF is this shit? They have 1 fucking case and feel comfortable spewing this crap? out of the 6K positive cases from the 84m vaxed in the US, is there a breakdown on variants? Until there is data that a variant is rampaging through the vaxed population, we should tone down the doom and gloom about them being the next destroyer of worlds.
  22. i am with you. with great news like this, there is no reason not open up. That 84m/6k positive test rate is insane in a good way. I was team 'listen-to-docs/WFH/limited travel/wear masks/SD/no parties', but now it does seem like good news is being slowplayed and the powers that be are reluctant to promote that vaxes will nuke the spread of the virus and will reduce/replace the need for masking and SD.
×
×
  • Create New...