Japan Earthquake

Japan Earthquake | Page 1376

@Nancy Yes, that mostly unlabeled stats page draws from the others. The main pages load the fed CSVs, and the compilation page draws the figures it needs from those.
by radioguy 5/25/2011 3:54:09 PM

@radioguy LOL, I need more coffee. I just need to know what cells to get the most current readings from if that is how these gauges need to be set up. I emailed Rob and asked him for details on how he built his so it can be replicated.
by Nancy 5/25/2011 3:55:38 PM

This is the spreadsheet I am looking at. Thought it had auto update on the stats? spreadsheets0.google.com
by Nancy 5/25/2011 3:56:59 PM

@Nancy The "All Latest" page just grabs the last line (the newest entry) from all the other pages and posts them on that page.
by radioguy 5/25/2011 3:58:17 PM

@radioguy LOL. Part of my problem was that I was on the wrong spreadsheet. :-0
by Nancy 5/25/2011 3:59:43 PM

I can use the two spreadsheets to get the headings corrected in English. Will do that first. Sounds like nabbing cells off that "latest" main page will do what we need. So then I just have to get a few details from rob on the code and we should be able to finish the gauges and get them on a page.
by Nancy 5/25/2011 4:00:55 PM

@Nancy Yes, the historic is going away now that I have the auto working. I'll save it for future reference.
by radioguy 5/25/2011 4:01:24 PM

@Nancy That's what I made that page for... otherwise you're drawing from an ever-changing last row.
by radioguy 5/25/2011 4:01:55 PM

Didn't someone translate all those labels for us?
by radioguy 5/25/2011 4:02:23 PM

@radioguy makes sense. I tried to edit the headers on the "live" spreadsheet in the detail pages and it seemed to have a formula in there instead of just junk. I think DH was going to translate them but didn't yet, he asked about it last night and I wasn't sure what sheet he should do it on. If I pull that content out of where the name label goes is it going to break something? IE sheet TempU56 Column B Row 3 - if I edit that will it break anything
by Nancy 5/25/2011 4:04:41 PM

It looks like the proper names are on the latest main page, do we still need them translated?
by Nancy 5/25/2011 4:08:01 PM

@Nancy On that sheet you can't really edit anything since the cells are autofiilled... they're all just "continue"s That's why I made the static one. The page called The Latest, we can put headers in next to the Unit Name. I figured Date doesn't need to be labeled.
by radioguy 5/25/2011 4:08:04 PM

@Nancy Not if we have them all. You'll notice that some of the units go all the way out to U c
olumns...
by radioguy 5/25/2011 4:08:57 PM

@radioguy K, if you want that historical one translated let me know or I can do it or point DH to it.
by Nancy 5/25/2011 4:09:07 PM

We need labels in The Latest if someone can do that. Then that page will be readable as the latest everywhere... useful at a glance.
by radioguy 5/25/2011 4:10:10 PM

@radioguy I should be able to drop those in by following the same row the text is already in on that sheet. Will see if I can match them all up.
by Nancy 5/25/2011 4:14:23 PM

i just rewatched famed Japanese director Akira Kurosawa's Dreams. One of the dreams is about a nuclear powerplant disaster. These are all apparently based on dreams that Kurosawa had. i recommend it highly.
by billmcd 5/25/2011 4:15:01 PM

@billmcd huh, the only movie of his I have not seen. May have to see if Netflix has it. Ikiru seems relevant, the whole interaction and mindset. www.imdb.com
by Nancy 5/25/2011 4:20:14 PM

@RadioGuy - I am going to ask DH to do some of the translations on the active reactor sensors. The translate seems to put out vague junky translations. I usually catch him online before I go to bed. I can point him to the static sheet and have him email me translations for the headers.
by Nancy 5/25/2011 4:22:58 PM

Perfect. For now, the numbers are there and those who are used to reading the tables will recognize them.
by radioguy 5/25/2011 4:23:46 PM

If we can find useful historic norms, we could freeze a row for them under the headers.
by radioguy 5/25/2011 4:24:34 PM

@ Nancy Says it all really. Would be good if it went viral.
by jt 5/25/2011 4:34:53 PM

@Nancy : i see the temp and pressure reading charts. www.houseoffoust.com but are there no radiation charts ?
by Edano 5/25/2011 4:39:08 PM

@edano - the rad readings are on the 'level pr data' chats. That link is to the historic ones. Current ones at www.tepco.co.jp
by hudebnik 5/25/2011 4:42:37 PM

@Edano If there are data sources for that, we should be able to mine them. Does TEPCO have CSVs for those somewhere?
by radioguy 5/25/2011 4:42:45 PM

@jt I think it should. I may put it on my site and share it around with a few people by email. I put it on my personal facebook page
by Nancy 5/25/2011 4:45:18 PM

@hudebnik : the 'level pr data' chart has only mm anfd MPa units. no radiation i think.
by Edano 5/25/2011 4:48:49 PM

@edano @radioguy - for instance #1 current csv values are www.tepco.co.jp the rads are in 4 columns the form 2.15E+02 (215Sv/hr) Change the last bit to data_2u-j.csv for #2 etc.
by hudebnik 5/25/2011 4:49:30 PM

Page down until you find them, they can be a long way down the table.
by hudebnik 5/25/2011 4:50:04 PM

@hudebnik : i see them in the table, but not plotted.
by Edano 5/25/2011 4:50:52 PM

Should be the last 4 filled tables on the right.
by hudebnik 5/25/2011 4:50:52 PM

You are right they are not plotted, that will be up to the geniuses here.
by hudebnik 5/25/2011 4:51:29 PM

@ Nancy It's art that is closer to the truth than all the news. I wonder how many people in Japan have seen it. 1990 was 21 years ago.
by jt 5/25/2011 4:56:30 PM

@Edano We should be able to. It's already posted in live format and can be called online for graphing as a source range.
by radioguy 5/25/2011 4:56:44 PM

@jt Powerful movie. I remember that nuclear sequence vividly, and I only saw it a couple of times.
by radioguy 5/25/2011 4:58:59 PM

@hudebnik Those CSVs are the source for the live spreadsheets.google.com document.
by radioguy 5/25/2011 5:00:46 PM

thanks to @billmcd for posting info about the movie. I just found it on youtube.
by jt 5/25/2011 5:04:03 PM

Final works and last years (1987–1998)

For his next movie, Kurosawa chose a subject very different from any that he had ever filmed before. While some of his previous pictures (for example, Drunken Angel and Kagemusha) had included brief dream sequences, Dreams was to be entirely based upon the director's own dreams. Significantly, for the first time in over forty years, Kurosawa, for this deeply personal project, wrote the screenplay alone. Although its estimated budget was lower than the films immediately preceding it, Japanese studios were still unwilling to back one of his productions, so Kurosawa turned to another famous American fan, Steven Spielberg, who convinced Warner Bros. to buy the international rights to the completed film. This made it easier for Kurosawa's son, Hisao, as co-producer and soon-to-be head of Kurosawa Production, to negotiate a loan in Japan that would cover the film's production costs. Shooting took more than eight months to complete, and Dreams premiered at Cannes in May 1990 to a polite but muted reception, similar to the reaction the picture would generate elsewhere in the world.
by jt 5/25/2011 5:09:27 PM