Close

Page 47 of 109 FirstFirst ... 3745464748495797 ... LastLast
Results 1,151 to 1,175 of 2717
  1. #1151
    Vale Nollsy Embers's Avatar
    Join Date
    Oct 2014
    Posts
    18,741
    Rep Level
    16360
    Rep Power
    918
    Quote Originally Posted by showdownhero View Post
    So even though Histrionics rudely turned down my kind offer a phone conference to discuss my covid spready I'll explain it here



    the johns hopkins data is a mix of country and state data so it needed to be tidied up a bit to be digestible

    confirmed: raw confirmed case data from johns hopkins
    country list: a tab I use to make sure I have the most up to date country list without duplicates
    recovered: raw recovered data from johns hopkins
    dead: raw dead data from johns hopkins
    active: vlookups that calculate active cases (confirmed less recovered less dead)
    active country totals: that data with a sumif function so it's per country
    confirmed country totals: the confirmed data with a sumif function to create country totals
    days more than 100: just a calculation tab don't worry about it
    100 cases: shows all the countries based on their case growth once they hit 100 cases
    totals less china:world total less china

    worth mentioning i'm using my old laptop which only has excel 2003 hence why the file extension is xls instead of xlsx

    here's the update with today's data

    https://drive.google.com/open?id=1J_...tpDKAxAlIUCgIr
    Do you or anyone else want office 2016 with license key btw? We have 1500 spare licenses is all . If you want it just pm me and I’ll email a link sometime next week

  2. #1152
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    11,640
    Rep Level
    21527
    Rep Power
    686
    Adelaide Crows Crystal Palace
    Quote Originally Posted by Ball So Hard View Post
    $133 fine.
    in victoria too or just qld?
    Quote Originally Posted by showdownhero View Post
    there’s a couple of clusters of illness in Mt Baker and Gawler where they’ve been tested but their results aren’t back yet. These individuals have all recently returned from various hot spots overseas and are almost guaranteed to returned positive results. Could be a spike in SA numbers in the next few days.

  3. #1153
    the implication. fender's Avatar
    Join Date
    Oct 2014
    Location
    London
    Teams
    Joey Barton, Haynesus
    Posts
    4,668
    Rep Level
    10537
    Rep Power
    297
    Newcastle United Parramatta New York Knicks

    Death Riding Civilization: The RZ Coronavirus Thread

    Doubt they will be fining anybody for missing this one tbh.

    Sorta keen to vote just for mayor cause GC one is a fuckwit but been winning for years, one of major policy’s is a cruise ship terminal


    Sent from my iPhone using Tapatalk
    Picture Phife losing a battle, come on, get off it
    Put down the microphone son, surrender, forfeit

  4. #1154
    Veteran Triptanes's Avatar
    Join Date
    Oct 2014
    Teams
    Toasters
    Posts
    15,966
    Rep Level
    28437
    Rep Power
    928
    WCE Toast WCE
    Quote Originally Posted by fender View Post
    one of major policy’s is a cruise ship terminal

  5. #1155
    Veteran Triptanes's Avatar
    Join Date
    Oct 2014
    Teams
    Toasters
    Posts
    15,966
    Rep Level
    28437
    Rep Power
    928
    WCE Toast WCE
    Quote Originally Posted by showdownhero View Post
    So even though Histrionics rudely turned down my kind offer a phone conference to discuss my covid spready I'll explain it here



    the johns hopkins data is a mix of country and state data so it needed to be tidied up a bit to be digestible

    confirmed: raw confirmed case data from johns hopkins
    country list: a tab I use to make sure I have the most up to date country list without duplicates
    recovered: raw recovered data from johns hopkins
    dead: raw dead data from johns hopkins
    active: vlookups that calculate active cases (confirmed less recovered less dead)
    active country totals: that data with a sumif function so it's per country
    confirmed country totals: the confirmed data with a sumif function to create country totals
    days more than 100: just a calculation tab don't worry about it
    100 cases: shows all the countries based on their case growth once they hit 100 cases
    totals less china:world total less china

    worth mentioning i'm using my old laptop which only has excel 2003 hence why the file extension is xls instead of xlsx

    here's the update with today's data

    https://drive.google.com/open?id=1J_...tpDKAxAlIUCgIr
    any graphs brah? we are simple cunts here

    some of this shit you could use to try fucking around with in power bi too for practice

  6. #1156
    the implication. fender's Avatar
    Join Date
    Oct 2014
    Location
    London
    Teams
    Joey Barton, Haynesus
    Posts
    4,668
    Rep Level
    10537
    Rep Power
    297
    Newcastle United Parramatta New York Knicks

    Death Riding Civilization: The RZ Coronavirus Thread

    Quote Originally Posted by Triptanes View Post


    Absolute mong going for his third term.


    Sent from my iPhone using Tapatalk
    Picture Phife losing a battle, come on, get off it
    Put down the microphone son, surrender, forfeit

  7. #1157
    disco Ball So Hard's Avatar
    Join Date
    Oct 2014
    Teams
    Essendon
    Posts
    6,392
    Rep Level
    13383
    Rep Power
    394
    Toast Toast Toast
    Quote Originally Posted by showdownhero View Post
    in victoria too or just qld?
    No idea, only reason it came up is because QLD is forcing people to vote today.
    #NBCSiberia

  8. #1158
    Veteran Triptanes's Avatar
    Join Date
    Oct 2014
    Teams
    Toasters
    Posts
    15,966
    Rep Level
    28437
    Rep Power
    928
    WCE Toast WCE
    Quote Originally Posted by fender View Post


    Absolute mong going for his third term.


    Sent from my iPhone using Tapatalk
    holy fuck

    "this virus threat really shows how we could be broadening the viruses we bring in - norovirus and coronavirus is not enough"

  9. #1159
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    11,640
    Rep Level
    21527
    Rep Power
    686
    Adelaide Crows Crystal Palace
    Quote Originally Posted by Triptanes View Post
    any graphs brah? we are simple cunts here

    some of this shit you could use to try fucking around with in power bi too for practice
    USA! USA! USA!

    Quote Originally Posted by showdownhero View Post
    there’s a couple of clusters of illness in Mt Baker and Gawler where they’ve been tested but their results aren’t back yet. These individuals have all recently returned from various hot spots overseas and are almost guaranteed to returned positive results. Could be a spike in SA numbers in the next few days.

  10. #1160
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    11,640
    Rep Level
    21527
    Rep Power
    686
    Adelaide Crows Crystal Palace
    By comparison Australia is doing pretty much anywhere else in the world with the exception of Denmark

    Quote Originally Posted by showdownhero View Post
    there’s a couple of clusters of illness in Mt Baker and Gawler where they’ve been tested but their results aren’t back yet. These individuals have all recently returned from various hot spots overseas and are almost guaranteed to returned positive results. Could be a spike in SA numbers in the next few days.

  11. #1161
    disco Ball So Hard's Avatar
    Join Date
    Oct 2014
    Teams
    Essendon
    Posts
    6,392
    Rep Level
    13383
    Rep Power
    394
    Toast Toast Toast
    USA is going to be fucking carnage.
    #NBCSiberia

  12. #1162
    Veteran Triptanes's Avatar
    Join Date
    Oct 2014
    Teams
    Toasters
    Posts
    15,966
    Rep Level
    28437
    Rep Power
    928
    WCE Toast WCE
    Fake news, that’s why trumps gonna open up the country again in a cuppla weeks. Nah, already seems like fucking carnage there already

    With those graphs they need to be cases per capita / per test or something? Don’t want you to do more work there’s just something missing for me trying to compare countries

  13. #1163
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    11,640
    Rep Level
    21527
    Rep Power
    686
    Adelaide Crows Crystal Palace
    Quote Originally Posted by Triptanes View Post
    Fake news, that’s why trumps gonna open up the country again in a cuppla weeks. Nah, already seems like fucking carnage there already

    With those graphs they need to be cases per capita / per test or something? Don’t want you to do more work there’s just something missing for me trying to compare countries
    Thing is the majority of the American cases are concentrated in a relatively small number of areas.
    Quote Originally Posted by showdownhero View Post
    there’s a couple of clusters of illness in Mt Baker and Gawler where they’ve been tested but their results aren’t back yet. These individuals have all recently returned from various hot spots overseas and are almost guaranteed to returned positive results. Could be a spike in SA numbers in the next few days.

  14. #1164
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    11,640
    Rep Level
    21527
    Rep Power
    686
    Adelaide Crows Crystal Palace
    Up until a few days ago Johns Hopkins were providing the US data by state but for some unknown reason they've pulled the pin on that
    Quote Originally Posted by showdownhero View Post
    there’s a couple of clusters of illness in Mt Baker and Gawler where they’ve been tested but their results aren’t back yet. These individuals have all recently returned from various hot spots overseas and are almost guaranteed to returned positive results. Could be a spike in SA numbers in the next few days.

  15. #1165
    Veteran whale's Avatar
    Join Date
    Oct 2014
    Teams
    Essendon, Arsenal
    Posts
    2,845
    Rep Level
    8926
    Rep Power
    208
    Essendon Bombers Arsenal NULL
    USA always gotta be number one
    Quote Originally Posted by MarshallMatthers
    fuck i cant wait till dinner hope we get take away
    Quote Originally Posted by MarshallMatthers
    ended up getting kfc

    wowowowowow

  16. #1166
    disco Ball So Hard's Avatar
    Join Date
    Oct 2014
    Teams
    Essendon
    Posts
    6,392
    Rep Level
    13383
    Rep Power
    394
    Toast Toast Toast
    1/6th of the world's cases in USA now.

    Incredible.
    #NBCSiberia

  17. #1167
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    11,640
    Rep Level
    21527
    Rep Power
    686
    Adelaide Crows Crystal Palace
    Triptanes

    The things I do for you homos, source is johns hopkins but it's not done in the time series any more.

    https://github.com/CSSEGISandData/CO..._daily_reports

    Population data from wikipedia

    Quote Originally Posted by showdownhero View Post
    there’s a couple of clusters of illness in Mt Baker and Gawler where they’ve been tested but their results aren’t back yet. These individuals have all recently returned from various hot spots overseas and are almost guaranteed to returned positive results. Could be a spike in SA numbers in the next few days.

  18. #1168
    Veteran yeah_nah's Avatar
    Join Date
    Oct 2014
    Location
    Perth
    Teams
    Toasters
    Posts
    12,549
    Rep Level
    27037
    Rep Power
    777
    Quote Originally Posted by showdownhero View Post
    Triptanes

    The things I do for you homos, source is johns hopkins but it's not done in the time series any more.

    https://github.com/CSSEGISandData/CO..._daily_reports

    Population data from wikipedia

    Pls plot on scatter graph with population density

    Sent from my SM-G955F using Tapatalk
    Quote Originally Posted by Eagle E View Post
    I then started saving extra money as a result of eating dumpster food.

    I knew when to hit the dumpster for optimum catch.
    Quote Originally Posted by Eagle E View Post
    accualy scared of getting knocked out by yenny
    #broughtback

  19. #1169
    übermensch showdownhero's Avatar
    Join Date
    Oct 2014
    Location
    Melbourne
    Teams
    Adelaide, Crystal Palace
    Posts
    11,640
    Rep Level
    21527
    Rep Power
    686
    Adelaide Crows Crystal Palace
    Quote Originally Posted by yeah_nah View Post
    Pls plot on scatter graph with population density

    Sent from my SM-G955F using Tapatalk
    u r 1 cheeky cunt m8
    Quote Originally Posted by showdownhero View Post
    there’s a couple of clusters of illness in Mt Baker and Gawler where they’ve been tested but their results aren’t back yet. These individuals have all recently returned from various hot spots overseas and are almost guaranteed to returned positive results. Could be a spike in SA numbers in the next few days.

  20. #1170
    Veteran Triptanes's Avatar
    Join Date
    Oct 2014
    Teams
    Toasters
    Posts
    15,966
    Rep Level
    28437
    Rep Power
    928
    WCE Toast WCE
    Quote Originally Posted by yeah_nah View Post
    Pls plot on scatter graph with population density

    Sent from my SM-G955F using Tapatalk
    I noticed he had the lat & long of each place in there, so was thinking a bubble chart by geolocation visualisation would be nice

  21. #1171
    Veteran Triptanes's Avatar
    Join Date
    Oct 2014
    Teams
    Toasters
    Posts
    15,966
    Rep Level
    28437
    Rep Power
    928
    WCE Toast WCE
    My neighbours have had m8s around every day for the last week. All their conversations are about how lonely it is in isolation, and how much they miss seeing each other

    It's literally been like a week, you haven't even done it, and shit is gonna get real for you if it becomes a full lockdown

  22. #1172
    disco Ball So Hard's Avatar
    Join Date
    Oct 2014
    Teams
    Essendon
    Posts
    6,392
    Rep Level
    13383
    Rep Power
    394
    Toast Toast Toast
    For whatever reason people see self isolation as not going out and getting pissed at home with the boys.

    Boggles the mind really.
    #NBCSiberia

  23. #1173
    Veteran Histrionics's Avatar
    Join Date
    Oct 2014
    Teams
    Collingwood, Newcastle United, Melbourne City
    Posts
    3,227
    Rep Level
    6649
    Rep Power
    201
    Collingwood Magpies Newcastle United Chicago Bulls
    showdownhero Good job brah and sorry I get nervous talking to cute boys hehe.

    Graphs are good. Much easier for me to understand lol

  24. #1174
    Veteran Histrionics's Avatar
    Join Date
    Oct 2014
    Teams
    Collingwood, Newcastle United, Melbourne City
    Posts
    3,227
    Rep Level
    6649
    Rep Power
    201
    Collingwood Magpies Newcastle United Chicago Bulls
    Srs tho thanks for the offer

  25. #1175
    Veteran Triptanes's Avatar
    Join Date
    Oct 2014
    Teams
    Toasters
    Posts
    15,966
    Rep Level
    28437
    Rep Power
    928
    WCE Toast WCE
    Quote Originally Posted by Ball So Hard View Post
    For whatever reason people see self isolation as not going out and getting pissed at home with the boys.

    Boggles the mind really.
    Bearing in mind this is an early-mid 40s couple with 3 kids. Definitely fit in the we're too white/smart/affluent to get it category

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •