Make XY Event Layer - need to convert to tab delimited csv file?
I have a very large csv file (too large to load in excel). If you take a section of the data and load it in excel, strings all load into one column, seperated by spaces. I need to create XY Event Layers from this csv and it appears for this to work that the csv needs to be tab delimited. I've tried to write a Python script replacing spaces with '\t' or using the csv module but cannot get it to work - my scripting knowledge is limited. Does anyone have a script to do this or can point me in the right direction? Any help would be much appreciated.
Do you have MS Access? Access can handle much larger files then Excel.
No, I am afraid not. I know I can split the original files into parts to fit into excel, but I am going to have to do this a lot, so a script would be really useful. Thanks anyway.
The best way to load CSV files is to define the schema in schema.ini in the same folder. This is by the Microsoft Text File driver that many Windows applications use including ArcGIS. It has no limits on file sizes and many other benefits. You can define the field separator, rename the field names, set fields types and text widths. If the first row has field names you can use them, skip them or rename them. It is very flexible and fast.
I have only recently discovered how useful the schema.ini definition can be. It saves having to write a Python script to parse and load the data into a table. You can just add the CSV file and export it to a geodatabase so you can edit and use it.
If you are going to create an XY event table, be aware that this is in memory and may be very slow converting it to a featureclass, or it may even fail. For very large files it may still be better to use an insertCursor to write a point featureclass directly in Python.


The tainted-coins tag has no usage guidance.
I just came across the term "taint analysis" in a crypto-related conversation. This came up while discussing "tracking bitcoin transactions" so it's somehow related to that. That's all I know.
I'd like to know the addresses used for a fraud, in order to make a service for analysing bitcoin blockchain. If you know the service for that, could you tell me it?
Is it possible to reject a bitcoin payment?
Say someone sends bitcoin to an address. It is later determined that those incoming funds are tainted and the recipient wants no association. What is their recourse?


text:
Home » Parents beg Varsity to Pull Out of ASUU Strike
Parents beg Varsity to Pull Out of ASUU Strike
By News Agency of Nigeria September 10, 2022 No Comments1 Min Read
The Parents/Stakeholders Forum (PSF) of the Benue State University Makurdi, has appealed to its ASUU members to pull out of the national body of ASUU to enable them to catch up with accumulated academic calendar years.
This appeal is contained in a statement by the Public Relations Officer of the university, Mr Tser Vanger, on Saturday in Makurdi.
It quoted the PSF's chairperson, Mrs Keziah Agundo, who expressed concern about the unutilised academic calendar months, explained that the "pull out" would enable them catch up with acculated workload.
She said the 2020, 2021 undergraduate programmes had yet to be matriculated while the 2022 Unified Matriculation Tertiary Examinations (UMTE) admissions were ongoing.
According to the statement, the Vice Chancellor of the university, Prof. Joseph Iorapuu, calls for the resumption of academic activities in the school.
He explained that most of the grievances of the teachers bordered on funding.
The statement also indicated that the meeting was attended by top management of the university, including the BSU branch chairman of ASUU, Dr Victor Tarnongo, who promised to present the demands of PSF to the appropriate authorities.
(NAN)
Previous ArticleGovt to Separate Boys from Girls in Secondary Schools
Next Article UNIBEN Chaplain sues for Love and Care among Nigerians

redpajama_set_name: RedPajamaCommonCrawl


text:
Carry Trade Is Back, but With New Risks
David Roman
Updated April 17, 2009 7:24 am ET
The carry trade is making a comeback, but in a new form and with new risks.
The old carry trade was a relatively predictable creature. It meant borrowing funds in low-interest rate currencies like the Japanese yen, and depositing them into stable high yielders like the Australian dollar -- for easy returns.
Now, investors looking to profit...


text:
The PJ Tatler
The Political Importance of Pussy Riot
By Rick Moran Aug 20, 2012 5:01 PM ET
In November of 1862, Harriet Beecher Stowe, the author of Uncle Tom's Cabin, went to the White House for a visit with the president. Upon meeting her, Abraham Lincoln is said to have remarked, "so you are the little woman who wrote the book that started this great war."
The Russian punk band Pussy Riot probably has Vladmir Putin thinking something similar. The band's music is horrible, but subversive, and the band members are heroically unafraid of authorities. At a time when the rest of Russia's opposition seems if not cowed, then certainly subdued, Pussy Riot is rocking the boat and spitting in the face of its authoritarian president.
The band's trial and 2 year sentence for "hooliganism" — a catch-all charge from the days of the KGB for political dissent — has electrified the opposition in Russia and breathed new life into a movement whose members suffer constant harassment and are subject to arrest at any given moment.
But Pussy Riot just keeps on truckin':
If anyone thought the members of incarcerated Russian punk band Pussy Riot would be cowed by the two-year prison sentence handed down last week, all they need do is check out the lyrics to the group's latest song, "Putin Lights Up the Fires."
A video for the song created by London's Guardian newspaper was released Friday:
"The country is going into the streets boldly… the country is going to bid farewell to the regime," the band's singers blare over a suitably thrashy guitar-bass-drums track built on a descending chord progression.
The trio of women were arrested after a February guerrilla performance protesting Russian President Vladimir Putin in Moscow's main cathedral. Last week, the three were sentenced to two years in prison for "hooliganism."
The government's response to the group's protest has sparked reactions around the world, with serious messages of solidarity from superstars such as Paul McCartney and Madonna to "Family Guy" creator and "Ted" director Seth McFarlane, who tweeted last week: "Russian Punk Band Sentenced … For Hooliganism (Plus 8 counts of shenanigans, tomfoolery, hijinks, jibber-jabber, and razzmatazz)."
Here's the full text of "Putin Lights Up the Fires":
This state may be stronger than time in jail.
The more arrests, the happier it is.
Every arrest is carried out with love for the sexist
Who botoxed his cheeks and pumped his chest and abs.
But you can't nail us in the coffin.
Throw off the yoke of former KGB!
Putin is lighting the fires of revolution
He's bored and scared of sharing silence with the people
With every execution: the stench of rotten ash
With every long sentence: a wet dream
The country is going, the country is going into the streets boldly
The country is going, the country is going to bid farewell to the regime
The country is going, the country is going, like a feminist wedge
And Putin is going, Putin is going to say goodbye like a sheep
Arrest the whole city for May 6th
Seven years isn't enough, give us 18!
Forbid us to scream, walk and curse!
Go and marry Father Lukashenko
Like Lech Walesa and Solidarity in Poland, an opposition under siege needs a symbol of resistance to brave the oppression from authorities. While there have been several courageous leaders of the loosely organized movement opposing Putin, like recently arrested Gary Kasparov, there has been no overarching personality or symbol around which the Russian opposition could unite and rally. Pussy Riot may not want the job but their actions have inspired and heartened a heretofore despondent movement.
An internet vote is scheduled for October 7 with all of the fragmented opposition invited to participate. They are to elect a coordinating council in advance of big demonstrations planned for later this year. If Pussy Riot does nothing else except inspire people to participate in this online event, they will have served their country well.


One of the best steps to refuse single-use plastic is to bring your own tote bag wherever you go. Just put this in your bag so it's handy when you need it.
Always remember that #YouMatter in every single effort you make.


text:
layout: page
title: Chapter 11
---

	Chapter 11 - Credit: issaquah.wednet.edu

redpajama_set_name: RedPajamaGithub


text:
Hackers attack BlackBerry blog, threaten employees, after RIM agrees to help London police
By Andrew Couts	 August 9, 2011
Hacker group "TeaMp0isoN" infiltrated the corporate-run Inside BlackBerry blog after Research In Motion publicly agreed to help London law-enforcement authorities track down the people who helped orchestrate the devastating riots that have engulfed parts of London and its surrounding areas for the past three days, reports The Next Web. The hackers also threatened the safety of BlackBerry employees, saying they would turn over stolen personal data to rioters if the company cooperated with police.
In place of the normal blog, which has since been taken offline, TeaMp0isoN posted a statement to RIM, which said that their cooperation with authorities will lead to innocent BlackBerry Messenger users being "charged for no reason at all, [as] the Police are looking to arrest as many people as possible to save themselves from embarrassment."
The group also said it had access to personal data about RIM employees located in the UK, and warned that it would release this information to the rioters if the company complied with police demands.
The message, in full, reads:
Dear RIM,
You Will _NOT_ assist the UK Police because if u do innocent members of the public who were at the wrong place at the wrong time and owned a blackberry will get charged for no reason at all, the Police are looking to arrest as many people as possible to save themselves from embarrassment…. if you do assist the police by giving them chat logs, gps locations, customer information & access to peoples BlackBerryMessengers you will regret it, we have access to your database which includes your employees information; e.g – Addresses, Names, Phone Numbers etc. – now if u assist the police, we _WILL_ make this information public and pass it onto rioters…. do you really want a bunch of angry youths on your employees doorsteps? Think about it…. and don't think that the police will protect your employees, the police can't protect themselves let alone protect others….. if you make the wrong choice your database will be made public, save yourself the embarrassment and make the right choice. don't be a puppet..
p.s – we do not condone in innocent people being attacked in these riots nor do we condone in small businesses being looted, but we are all for the rioters that are engaging in attacks on the police and government…. and before anyone says "the blackberry employees are innocent" no they are not! They are the ones that would be assisting the police.
Following the breach of the blog, TeaMp0isoN posted to the group's Twitter feed, saying repeatedly that they "do not condone" volence towards innocent civilians, "only towards police."
Yesterday, reports revealed that rioters used BlackBerry Messenger (BBM) to plan the angry demonstrations, which were initially sparked by the controversial police shooting of 29-year-old Mark Duggan, who was an accused drug dealer. Unlike social networks, such as Twitter and Facebook, which can be easily monitored by police, BBM is more private, and only works between BlackBerry devices.
After discovering the role its messaging service played in facilitating the riots, RIM told Scotland Yard it would cooperate with its investigation to track down and arrest protesters who posted "inflammatory" messages. Some fear that this means RIM will hand over the identities of BBM users.
According to a report on the matter by the Guardian, RIM can be legally ordered to hand over user data to police, but the Canada-based company says it cannot unscramble the encrypted messages that are sent over BBM, making it nearly impossible to identify the sender.
[Image via]
A new BlackBerry with a keyboard is still on the schedule for 2022
Classic BlackBerries are finally losing suppport as company shuts down services
BlackBerry rises from the grave: New 5G phone with a keyboard coming in 2021
Sorry fans, Blackberry Messenger for Android and iOS died May 31
BlackBerry Key2: Everything you need to know


How do you make a state-of-the-art loudspeaker appeal to a segment of younger women, without pushing away the male consumers? That question was key in the design process of Vifa's HELSINKI loudspeaker. Benefits over features became the focal point for framing the product; female users tend to be highly critical when it comes to technology products. Therefore everything in the product is oriented around a series of main benefits: Uncompromised sound. Nordic, minimalist aesthetics mixing easily in to any interior. Easy and intuitive interface. Tactile experience through embroidered buttons. Complete mobility in a product adapted for both indoors and outdoors use, thus acknowledging the nomadic existence of the younger consumer-segments. Material-wise, obtaining the utmost quality was key to reflect the engineering craftsmanship that lies within the loudspeaker: Resistant, custom-made Kvadrat textile allowing sound to pass perfectly, rigid aluminum frame moulded in one piece, and a genuine leather strap. HELSINKI was designed to differentiate itself from the classic perception of how a strong loudspeaker should look, without ever compromising Vifa's trademark sound quality.


Jenny Tsang is absolutely rocking this authentic grey layering trend! By pairing a flowing blanket coat with a tie-front tee and leather leggings, Jenny has achieved the perfect contrast between tight and loose! We adore this look. Coat: Tsang, Sweater: Vince, Trousers: Blesse'd Are the Meek.


What to do with Ukraine ambitions?
I feel a slight hesitation, when I have to consider an eventual Ukrainian accession to the EU. I have known Kiev in the Gorbatshov days. In spite of its fervent nationalism, ways of dealing and culture there are Soviet. The Western part, Galician, often Polish speaking, is stark oriented to the West: Culturally, but also commercially (agriculture). The Eastern part, however, often russophone, a mining and heavy industry zone, is linked with many ties to old Russia. The Krim and surrounding regions are also Russian, be it with an Asian original population.
Potentially, it is a huge agricultural asset to the EU. Large stretches of fertile land, all the fibres you'll need in the coming century. The same is true for coal: when the petroleum sources will dry up, a coal-based energy policy will need the Ukrainian riches.
Half of the country is decidedly western-oriented. We should not let them down, in spite of their anti-semitism and maffiose structures. The other half, however, is not. It is tied with many ties to mother Russia. The energetical riches there, are very important to a future Russian economy. The strategical locations at the Black Sea (Krim) are vital to the Russians.
If the EU leaves Russia out in the foreseeable future, a deal could be made with the Russians, sharing influence in the Ukraine. The Western regions being progressively incorporated in the EU-market, while the Eastern regions would be linked to the Russian economy and the Krim region would become then a shared Russo-Ukrainian affair.
But, if the EU would decide in the coming years to integrate with Russia, for energetic reasons and strategic reasons, another scenario is thinkable. The 50 million strong Ukraine could become a West- as well as East-oriented country, politically organised as a western democracy, but economically linked to its big Russian neighbour.
"EU officials and Ukrainian diplomats expect Ukraine to join the WTO in Spring or Summer - before Russia. The WTO entry would allow the EU and Ukraine to sign a "deep" free trade agreement down the line, which would remodel Ukraine's economy along EU lines.
These considerable steps [visa facilitations] to the EU will bring us closer in the future to our strategic goal of joining the EU," Mr Yanukovych said. Later, while meeting EU top diplomat Javier Solana, he squeezed his elbow like an old friend amid a chat on visas, and spoke of frequent telephone contact.
In foreign policy terms, Mr Yanukovych also gave Brussels political promises he will extend the mandate of the EU's border-monitoring team in Moldova, which has been a pain in the neck to pro-Russian rebels in the Moldovan region of Transdniestria since it started work.
But the steely-eyed Ukrainian, whose Party of the Regions to an extent represents the old Ukraine of oligarchs and the Russophone, anti-NATO part of Ukrainian society in the east, showed the limits of his pro-western feeling when reacting to news the US Congress had approved Ukraine's future NATO membership.
This is why I think, that a successful integration of the Ukraine is dependent on a more independent EU foreign policy and an arrangement between the EU and Russia.
"Nowadays Ukraine is not ready for accession. The level of public support is about 20 percent and the decision on NATO will be taken by a national referendum," he said, adding "no dates" were ever mentioned in a deal he made on foreign policy with Ukraine's pro-NATO president Viktor Yushchenko last year.
Perhaps, a Russian-oriented government in Ukraine is not as bad as it seems, for the EU. Yanulovytch is a person, who could make arrangements with both the EU and Russia, without being suspected of selling out Ukrainian national interests.
When Mr Yanukovych's political rivals come to Brussels, they paint him as a danger to the country's pro-EU path. "Let's see this process [Yanukovych's return to power] not as a tragic one but as a test," Mr Yushchenko said on 8 March. Last November, [but] ex-PM Yulia Tymoshenko called Yanukovych "Kuchma-lite," referring to Leonid Kuchma, the repressive, pre-Orange Revolution president.
and with a view to helping Ukraine."
"Let's stop talking about Russia and Ukraine as if it was still the old Soviet Union - those days are gone now," a Ukrainian diplomat said.
Starting with "An 21st Century Caligula..." on November 2, 2005, on the Legal Alien in New York blog, I followed the deployment of the 2003 Valerie Plame affair closely.
In my opinion, the primary target of the White House smearing campaign was not, as commonly thought, Plame's husband Wilson, but the liquidation of the CIA front store in Istanbul, led by Plame.
A new defeat for the mobile phone providers.
The EU Commission proposal for a cap on roaming charges gets support from national ministers in a meeting in Germany.
But that is not yet the end of the story. In one of its next meetings, a formal European Council will have to accept the proposal. The Companies are trying to get a compromise by offering complicated programmes for customers, that may roughly cut 40% of the extra roaming charges.
But the conditions are unclear, and are linked, as in the case of my provider, the Belgian Proximus an affiliate of Vodafone, to subscriptions that make a change of provider very difficult. The programmes do not offer, either, a reduction of the high costs for receiving calls abroad, nor for extra international SMS-charges.
The EU-Commission initiative is a test case for its capacity to show European citizens, that Europe protects them. In view of rising Euroscepticism, the cap on roaming charges has become a major issue. It may show, that the Barroso Commission is as social as its predecessor, who capped to 0% the international transfer charges in Euros of the banks.
"All citizens in the EU should be able to judge in July how effective the work of their ministers and their parliamentarians has been," said EU telecoms commissioner Viviane Reding - a staunch supporter and initiator of the roaming price cuts.
The Test Case reasoning, as you see.
But British [Minister] Margaret Hodge has argued against a system which would introduce rigid price limits for roaming, saying the potential costs to companies of €2.9 billion would be spread across the sector and harm innovation in the area.
"If we have a rigid maximum price ceiling it will quickly turn into a minimum price, and that I think will inhibit real competition. You don't want to lose flexibility," Ms Hodge said in an interview with the Financial Times.
Ms. Hodge argues against something the Commission is NOT proposing. The price cap is not 'rigid'. It imposes solely a maximum percentage extra costs for roaming above the existing charges related to the moment, the time and the distance of calls. If those costs rise or sink, the value in money of the maximum extra roaming charge will correspondingly rise or sink. That is not what is commonly called 'rigid', isn't it?
In fact, as we explained earlier here, Mobile Communications providers are since about 10 years profiting from an anomaly in Europe's common market. National frontiers, that are technically no obstacle at all for transmitting communications, are used as milk-cows for imposing extra charges. Licenses for mobile phone (and internet access-, see later) net works, are nationally allocated (and -heavily- paid for). This creates technically redundant frontiers, separations, between national network complexes.
This situation is falsifying open competition, a configuration that would result in lower prices for transnational calls and communications. The champions of open competition should attack this national allocation system as the real falsifier, and not the European regulations that intend to limit the harm it does to the market and its providers and consumers!
But no, oligopolistic market providers are conservative at heart. Rectifying the division of charges between national and international callers, would mean, that an easy and profitable extra source of income will need to be replaced by others. That is difficult and painful. It means extra work for the top bureaucracy of the providers. And, maybe, the loss of extra fat that is now invested into sponsoring of, for instance, golf tournaments (with free tickets for the direction) and conventions in the Caribbean for top- and middle managers and their spouses and secretaries. Money that is not serving any 'innovation'.
As opposed to the commission's proposal to see the new roaming limits apply automatically, Britain favours an "opt-in" regime in which the new maximum tariff is only applied if customers request it.
"People are not daft. People are pretty adept at working out the best package," Ms Hodge said in the interview.
Ms. Hedgehodge sticks all her pins out against those continental dirigists. Her arguments are exactly those, we denounced earlier, when we analysed a 'Financial Times' contribution by a hired British lobbyist for Vodafone. Most mobile phone consumers go on holiday abroad. They have all the experience of bad surprise at the ensuing monthly bill. They are outraged at the exceptional high costs for their international calls, made and received.
An European price regulation would be an obstacle to free competition and innovation?
Nor Ms. Hodge, neither the lobbyists, will be able to reason that away. Even, if the side of the professional international callers has been weakened by granting preferential tariffs for roaming to big companies. That argument is pure demagogy.
It is very sound for the companies and for the economy in general, if extra profits resulting from pre-common market anomalies, are regulated away. The EU position is more in line with free market thinking than that of the mobile phone providers and of the British Government.
An alternative for sound companies: Open the national networks to everyone!
I do not understand the opposition of big European transnational players like the French Orange, the German Telekom (T-Mobile), the British Vodafone and -even- the smaller Dutch KPN with its dedicated networks in Germany, Belgium and some central European countries. They could deploy in a free European market, that would be no more falsified by national allocations. They could demand access to national markets that are now closed to them, in order to offer European-wide competing tariffs and get, in that way, millions of new clients, who would provide them the means for innovation. In stead of rear-guard lobbying, they would do better to justify their claim on a supplement to the EU regulation, allowing any European provider to sell his subscriptions in every EU country.
They would quickly take an advance on their competitors like the Luxembourg providers, who, profiting from the national allocation, operate from an area not bigger than a post stamp, mainly in order to catch the calls of transiting European citizens in their networks and being able to charge them extra roaming tariffs!
You see, all this is why so-called free markets need reasonable regulators. For their own well-being!
The US, and the UK via NATO, are urging European countries to join the hopeless anti-guerrilla struggle in (Southern) Afghanistan. Two relatively big European powers, Italy and Spain, decided recently not to join in. Certainly one of the reasons, why the Blair Government, days after their announcement of the Iraq troop reduction, felt obliged to increase their number of military in Afghanistan.
Sneers about Latin opportunism and cowardice.
Such is not our view.
Both governments witness responsibility, diplomatic finesse and realistic assessment.
The Italians, for instance, are not afraid to take the lead in the UN Southern Lebanon dissuasion force. They rightly think, that that investment has a real impact upon a vital interest for Europe and that it has some chances to succeed. Spain, the home country of EU foreign Commissioner Solana, apparently has adopted a more EU-oriented international security policy, which is not made into an issue by its ferociously antisocialist opposition.
In the actual Afghanistan, the conditions are not open to a productive intervention by European states. What started as a popular uprising against a foreign oppressor, is being taken over by Pakistan-based 'Talibans'. That struggle cannot be won, either by terror (the American-British-Australian way), nor by appeasing (the Dutch way in Uruzgan).
The British and Dutch governments should sit down and listen to their European partners. A common European security policy is more needed than ever.


text:
Q: Getting Attributes for UI Elements Using AXUIElementCopyAttributeValue Function in Swift3? I'm trying to get the title of each ui element inside a window using the following function.
func AXUIElementCopyAttributeValue(_ element: AXUIElement, _ attribute: CFString, _ value: UnsafeMutablePointer<CFTypeRef?>) -> AXError

However, the function AXUIElementCopyAttributeValue to get AXTitle returns an error. What's the right way to get the values for attributes of UI Elements in swift3? Here's my code.
var children:CFTypeRef?
var error = AXUIElementCopyAttributeValue((windows?[0])!, "AXChildren" as CFString, &children)
if error == .success, let elements = children as? [AXUIElement] {
    for element in elements {
        var cfName:CFTypeRef?
        error = AXUIElementCopyAttributeValue((element), "AXTitle" as CFString, &cfName)
        if error == .success {
            let axValue = cfName as! AXValue
            let type = AXValueGetType(axValue)
            var attribute = ""
            var attributePtr = UnsafeMutableRawPointer(Unmanaged<AnyObject>.passUnretained(attribute as AnyObject).toOpaque())
            AXValueGetValue(cfName as! AXValue, type, &attributePtr)
            attribute = Unmanaged<AnyObject>.fromOpaque(attributePtr).takeUnretainedValue() as! String
            print("\(attribute)")
        } else {
            NSLog("\(error)")
        }
    }
}

I also tried
if error == .success, let name = cfName as? String {
   print(name)
}

Thank you so much!

redpajama_set_name: RedPajamaStackExchange


"What did you say? Me seeking help from the likes of you?" Songyue looked at Yi Yun as though he was mad.
She had endured through immense difficulties in the cultivation of the Crystal Refinement Technique by tightening her belt to spend money on incomplete heritage. She began training from ore slag and, with perseverance and consistency, she finally accomplished her present-day achievements. And now, a guy who was new to the Chaos Heavens and knew nothing was making such a bold statement?
"If you are that impressive, I guess joining our team has really been a burden on you," said Songyue sarcastically as she glared at Tie Mu. What sort of person did Tie Mu acquaint himself with? It was no wonder he offended Cang Gu. Such a person with grandiose aims but puny abilities would be the first batch of cannon fodder to be eliminated in the Chaos Heavens.
Tie Mu was at a loss as to what to say. What had gotten into Yi Yun's mind? Why was he spouting words that made less and less sense?
"Get to work! Ignore him!"
Songyue gave the command. This was the second time she was beginning the crystal refining. The Crystal Refining Furnace was filled with ore, but this time only about half of what her previous attempt entailed. This was because Songyue had expended too much energy previously, so refining that much was already a challenge of her limits.
Taishan, Tie Mu, and Chuan went through the prescribed order by injecting their energies into the Crystal Refining Furnace as Songyue began forming the marks.
Although Songyue did not believe one bit of Yi Yun's words, she was especially careful when forming the marks. Her speed at forming the marks also slowed down drastically because she could not afford to fail.
These few days were critical for her future!
Master Duanmu was recruiting apprentices, an extremely rare opportunity for her! Faced with intense competition, Songyue had little chance, so she needed to do well.
If the furnace really exploded, not only would she have to pay the high cost of compensation, but her hopes of becoming Master Duanmu's apprentice would be nothing but a dream.
Songyue was fully focused as she entered an ethereal state. Her eyes were only filled with the ores and the Crystal Refining Furnace.
As such, Taishan, Tie Mu, and Chuan seemed to face a test. Songyue was giving her all, so they did the same.
As time passed, Taishan and Tie Mu's bronze skin was covered in sweat. Yet, they they could not afford the time to wipe it off.
Yi Yun watched by the side idly. He could tell how focused Songyue's attitude towards the crystal refinement was and that she was a diligent woman. Unfortunately, many a time in the martial world, the outcome of putting in immense efforts would still be failure.
Yi Yun's perception was locked onto the piece of ore inside the Crystal Refining Furnace that had been tampered with. The ore's array formation was very intricately designed, allowing it to perfectly hide itself inside the cauldron's flames. It was already beginning to accumulate its energies.
The heat from the flame, the Yuan Qi from Songyue, and the energies from the Chaos Ores were seeping into the concealed array formation bit by bit. The energy it consumed was extremely minute, something that Songyue could not detect at all.
Once the concealed array formation had gathered the sufficient energy, it activated. It was not very strong and, in fact, very weak, but it was like a drop of water that dripped into a pot of boiling hot oil.
The outcome was like the spurting of oil!
The cauldron flames turned fervent as the tongues of flames began sweeping. The entire Crystal Refining Furnace began to quiver as the ores inside jumped vigorously like frying beans.
Songyue's expression changed. What's happening!?
At that instant, she sensed that the energies gathered in her marks were turning chaotic. The Yuan Qi in the ores were like horses that had escaped their reins, galloping freely in the Crystal Refining Furnace.
One Chaos Ore after another began to crack!
The cracks constantly widened, and once they completely cracked, the energies would be released like a flood. Then, there was only one outcomethe explosion of the furnace!
Just the mere thought of a furnace explosion drained the color from Songyue's face.
The next few days were critical for her future. She absolutely could not afford such a huge mistake.
However, why did the energy turn chaotic? Songyue had been very careful with every step she took in her second crystal refinement process. She believed that she did not make any mistakes, and even if the refinement failed, it would not have led to the explosion of the furnace. This was definitely abnormal.
Songyue naturally remembered what Yi Yun had said. He said that refining the ores would result in a furnace explosion.
At that moment, Songyue was high strung. She used all her energy to control the chaotic energies within the Crystal Refining Furnace, so much that she did not even dare turn her head to look at Yi Yun. All she could do was look at him through the corner of her eyes. Her face was filled with anxiety.
Tie Mu and company had also sensed something amiss. Their energies were connected to the Crystal Refining Furnace's array formation, so they could clearly sense the chaotic energies inside.
Once it exploded, not only would it destroy the expensive Crystal Refining Furnace, but it would also injure them!
And with the next mining expedition happening shortly, any injuries now would no doubt bring them one step closer to death.
"Senior Sister Songyue, what's happening!?" Taishan asked anxiously. If he had not been taken care of by Songyue usually, he would have abandoned the furnace and fled.
"Senior Sister Songyue!" Tie Mu said as well, while looking towards Yi Yun.
"Yi Yun You You knew that the Crystal Refining Furnace would explode?"
Songyue managed to split a wisp of her psyche energy with great difficulty as she sent Yi Yun a voice transmission. She could not bear the consequences of an exploded Crystal Refining Furnace.
"You went through such great efforts to divert your attention and send me a voice transmission, only to say such pointless words to me?" said Yi Yun in an unhurried manner.
His sentence made Songyue choke back on the remaining words she had to say.
"What about me? I already warned you, but you were the one who refused to listen. And now, you are asking me something that has obviously happened? You still had about thirty seconds left, but you have less than fifteen seconds now. By the way, as you were attempting to bind the energy within the Crystal Refining Furnace, those energies were becoming increasingly accumulated. The explosion's might will likely not be something you can withstand."
When Yi Yun said that, Taishan and Tie Mu were dumbfounded.
They would be heavily injured from the explosion in fifteen seconds!
But if they were to flee now, the Crystal Refining Furnace would explode immediately. Songyue's outcome was obvious!
"Brother Yi, what should we do now?"
Tie Mu burned with anxiety. Although the pocket world had a Godly Monarch Crystal Refinement Master presiding over it, he was a person of higher stature than Master Duanmu. He was in charge of making sure the rules were followed, so how was it possible for a Godly Monarch to help them?
"Yi Yun, you previously mentioned that you can help when you are required?" Songyue suddenly recalled Yi Yun's words. Now, all she could do was seek Yi Yun's help as a desperate attempt in a hopeless situation.
"I said that you need to pay the appropriate price." Yi Yun answered unhurriedly.
Now, there were less than six seconds. They were on the brink of an explosion!
"I'll agree to any price you want!"
Songyue nearly shouted that out. Her eyes were already bloodshot for she was already at her limits!
"I want all the ore slag in your interspatial ring as well as five kilograms of refined ores!"
Songyue was taken aback when she heard that. Yi Yun was gorging her!
"You are fishing in troubled waters!"
Yi Yun did not reply as Songyue was close to tears. However, she knew that this was all a result of her own choices. She had ignored Yi Yun when he warned her; now, the price for seeking Yi Yun's help had naturally gone up. He had made it clear from the beginning.
With regards to this, Songyue could only accept the outcome of her poor choices.
Even if she risked the end of the greatest opportunity of her lifetime, she did not wish to see Taishan, Tie Mu, and Chuan implicated.
"I will compensate you in the future, but I need these now," said Yi Yun tersely.
It was as though this sentence gave Songyue confidence. She gritted her teeth, took off her interspatial ring, and flicked it straight at Yi Yun.
Yi Yun phased away and appeared in front of the Crystal Refining Furnace. Simultaneously, he allowed the interspatial ring to enter the God Advent Tower space within him.
He grabbed the Crystal Refining Furnace with one hand!
"What are you doing? Don't you want your hand anymore!?"
Songyue was alarmed. The temperature the Crystal Refining Furnace had was unimaginable. Even warriors would be instantly burnt from placing their hands on the furnace's surface.
However, Yi Yun did not seem to hear Songyue as his hand pressed onto the Crystal Refining Furnace.
Immediately, his Yuan Qi surged into the Crystal Refining Furnace!
Yi Yun was extremely weak at the moment and his Yuan Qi appeared to be on a completely different level when placed on the backdrop of the Crystal Refining Furnace's chaotic energies. It looked like a puny attempt by an ant to shake a tree. Upon seeing this, Songyue felt despair. How could they stop the explosion?
Yet, purple points of light suddenly lit up the next moment around the Crystal Refining Furnace. Each point of light was a tiny nomological mark. Before Songyue could identify the nomological marks, the marks were injected into the Crystal Refining Furnace.
Songyue found it unbelievable. How did Yi Yun do it? How did he calm down such chaotic energies with his weak Yuan Qi!?
"You are a Crystal Refinement Master?"
Songyue subconsciously came to a possibility that left her astounded; however, why would he ask Tie Mu what a Crystal Refinement Master was if he was one?
"It's simply resolving a major issue with little effort. What's so strange about it? Someone was able to use a tiny array formation to stir the ores' energy in the furnace to make it explode. On the contrary, I used a small and weak amount of energy to calm it down. That's all."
How how was that the same?
Songyue was left completely speechless. It was possible for a tiny spark to set a prairie ablaze, but was it possible to use a single drop of water to put out a prairie fire?
Of course, there was no way for Songyue to know that Yi Yun had the Purple Crystal. His ability to control energy was unparalleled.
And at that moment, Yi Yun had already found the source of the explosion, which was also the concealed array formation that was planted by someone. Although the array formation was intricate, it did not possess much might. Yi Yun reduced it to ashes with a mere thought!
After Yi Yun completed this feat, he immediately retracted his Yuan Qi and psyche energy. After all, he had only borrowed the powers of the Purple Crystal. It was alright if he only ameliorated the explosive situation, but if he were to absorb the energies within the Crystal Refining Furnace, he would likely garner the attention of the Godly Monarch who presided over the area. He would then be in danger.
If not for his lack of Chaos Ores and low Yuan Qi, he would not have taken action at all.


text:
SoCal VegFest 2017 review
SoCal VegFest 2017
Our family had a great time at SoCal VegFest in OC. For ten bucks admission for our family of four we got to try a lot of new products and learn some new things. There were tons of vendors ranging from education for kids all the way to vegan shoes. Something for everyone.
I'm not going to lie. The real reason I went was for the food. It was totally worth it. Between the various foods we tried I spent another 50 bucks or so, but I would do it again in a heartbeat.
Veggie Grill – Carlsbad, CA review @veggiegrill
Ok so I had been wanting to try this place so bad. I had a really good excuse to since we were at Legoland already. This was literally right down the street.
Since I had never been there I was overwhelmed with options but I remember seeing the Super Rica burger on Instagram and it looked awesome so I went for that.
So glad I did!
For our family of four to eat it cost about 12/person- but now after a few weeks of trying out some other places the prices are quite affordable in comparison. Plus you get more food and it's reliable.
You order at the counter and then they bring your food. Everything we ordered was made to order, so the wait time is about 15 minutes if they're not busy.
There's a good selection from bowls and salads to burritos and burgers. Something for everyone.
I wish I could try everything on the menu!
Legoland California vegan food at pizza and pasta buffet
It's Halloween time at Legoland California and we thought for our Brick or Treat we would try something different so we tried the pizza and pasta buffet.
There's two small salad bars with some descent options. Oils, vinegar and Italian dressing are going to be your only options. But there are some fresh veggies, chickpeas and a few other goodies.
We asked and found that this gluten free pasta with fresh marinara were also vegan. My son ate two plates. I didn't eat the pasta because I'm paranoid and trust no one but I tasted the sauce and it was delish!
The buffet is $17 for an adult and $10 for a child.
Located inside Imagination Zone.
UCI MIND ANNOUNCES MARIA SHRIVER AS CELEBRITY HONOREE FOR 8TH ANNUAL "A DECEMBER TO REMEMBER" GALA
All event proceeds will support Alzheimer's disease research
Irvine, Calif., (October 5, 2017) — UCI MIND, Orange County's only state and federally-funded Alzheimer's disease research center, has announced that Maria Shriver, internationally renowned Alzheimer's disease advocate, founder of The Women's Alzheimer's Movement, and former First Lady of California, will be honored at its 8th annual A December to Remember Gala on Saturday, December 2, 2017.
"Maria Shriver is a champion for Alzheimer's disease research, and is a voice of strength for many families and individuals who are suffering as a result of this disease," says Dr. Joshua Grill, Co-Director of UCI MIND. "We are proud to partner with Ms. Shriver and honor her important work that continues to shine a light on Alzheimer's disease."
Shriver is the founder of the Women's Alzheimer's Movement (WAM), a global alliance of individuals, organizations, researchers and industry leaders who are committed to studying Alzheimer's disease and why it disproportionately affects women.
"Every 66 seconds a new brain develops Alzheimer's. Two-thirds of them belong to women, and no one knows why that is," explains Shriver, who began her advocacy for the cause when her father was diagnosed with the disease in 2003. "This is a devastating disease that must be stopped. Through the support of local communities and research organizations such as UCI MIND, we will continue to work towards a cure."
Shriver's organization seeks to bolster scientific pursuits to understand why women are at increased risk for Alzheimer's disease, and to help all people take steps to improve brain health. WAM also raises money to support gender-based research, and shares stories and resources for patients and loved ones battling Alzheimer's.
Dr. Frank LaFerla, Dean of UCI's School of Biological Sciences and Co-Director of UCI MIND, notes that Orange County is particularly susceptible to the pressures of Alzheimer's disease.
"More than 84,000 people in Orange County are living with Alzheimer's disease, and that number is anticipated to increase 74% by the year 2030," Dr. LaFerla explains. "The only way to avert this crisis is through research, which is precisely where the proceeds from this event will be applied."
With support from the local community, UCI MIND funds projects that allow researchers to seek out scientific advances that will help identify ways to prevent or slow the onset of neurological disorders like Alzheimer's.
"Thanks to the tremendous generosity of our attendees, last year's gala raised over $375,000 to support innovative research on new studies and clinical trials," says Dr. LaFerla. "This year, we've extended an invitation for guests to attend an exclusive pre-event cocktail reception with Maria Shriver prior to the Gala, along with various unique sponsorship opportunities that we hope will continue to support our research efforts surrounding Alzheimer's disease."
UCI MIND is one of only 30 NIH-funded Alzheimer's Disease Research Centers in the nation.
"The research being done at UCI MIND provides hope for millions of individuals who are affected by this heartbreaking disease," LaFerla adds. "It's through attending events like our annual gala or participating in clinical research trials that Orange County residents can, in fact, make a difference and help researchers get closer to a cure."
For more information about the 8th annual A December to Remember Gala, or to inquire about sponsorship opportunities, please visit gala.mind.uci.edu or contact Danny Harper, Senior Director of Development at UCI MIND, at 949-824-3793.
About UCI MIND (UC Irvine Institute for Memory Impairments and Neurological Disorders)
The UC Irvine Institute for Memory Impairments and Neurological Disorders (UCI MIND) is internationally recognized for its research accomplishments in disorders of the brain, particularly those that are age-related.
UCI MIND is the University's center for aging and dementia research, with its faculty seeking to understand the causes leading to neurological disorders such as Alzheimer's disease, frontotemporal dementia, Lewy body dementia, and Huntington's disease.
For those suffering from age-related memory problems, its goal is to develop improved means for effective diagnosis and treatment and to provide help to families and caregivers.
UCI MIND is home to one of 30 Alzheimer's Disease Research Centers funded by the National Institute on Aging, and is one of ten California Alzheimer's Disease Centers funded by the California Department of Public Health. For more information, please visit mind.uci.edu.
Tom's of Maine wild lavender deodorant review
Good morning. I just wanted to share this awesome Tom's of Maine wild lavender deodorant. Even before going vegan, I started getting terrible rashes in my underarm area. I would have to rotate deodorants and wash it off when I got home from work. Then I would try and fix my rash with tea tree oil. When we were on our second vegan shopping trip at @wholefoodsorangecounty I stumbled into their health and wellbeing aisles – and saw a ton of options. At first I was overwhelmed and then excited. I picked up this gem just to see if it would work and it has. It has lasted a few months and I use a lot of deodorant- I used to wear clinical strength. Plus, NO MORE RASH! I want to try other scents now. What kind of deodorant do you use?


text:
Neuilly ist eine Commune déléguée in der französischen Gemeinde Valravillon mit  Einwohnern (Stand: ) im Département Yonne in der Region Burgund.

Seit 1. Januar 2016 ist sie Teil der Gemeinde Valravillon in der neuen Region Bourgogne-Franche-Comté. Die Gemeinde gehörte zum Kanton Charny (bis 2015 Aillant-sur-Tholon) und zum Arrondissement Auxerre.

Geographie
Neuilly liegt etwa siebzehn Kilometer nordwestlich von Auxerre am Fluss Ravillon.

Bevölkerungsentwicklung

Sehenswürdigkeiten

 Kirche Notre-Dame de l'Assomption (Friedhof Monument historique)

Weblinks

Ort in Bourgogne-Franche-Comté
Commune déléguée im Département Yonne
Gemeindeauflösung 2016
Valravillon

redpajama_set_name: RedPajamaWikipedia


text:
Q: Creating an index for each subject in R I'm working with some data on repeated measures of subjects over time. The data is in this format:
Subject <- as.factor(c(rep("A", 20), rep("B", 35), rep("C", 13)))
variable.A <- rnorm(mean = 300, sd = 50, n = Subject)
dat <- data.frame(Subject, variable.A)
dat

   Subject variable.A
1        A   334.6567
2        A   353.0988
3        A   244.0863
4        A   284.8918
5        A   302.6442
6        A   298.3162
7        A   271.4864
8        A   268.6848
9        A   262.3761
10       A   341.4224
11       A   190.4823
12       A   297.1981
13       A   319.8346
14       A   343.9855
15       A   332.5318
16       A   221.9502
17       A   412.9172
18       A   283.4206
19       A   310.9847
20       A   276.5423
21       B   181.5418
22       B   340.5812
23       B   348.5162
24       B   364.6962
25       B   312.2508
26       B   278.9855
27       B   242.8810
28       B   272.9585
29       B   239.2776
30       B   254.9140
31       B   253.8940
32       B   330.1918
33       B   300.7302
34       B   237.6511
35       B   314.4919
36       B   239.6195
37       B   282.7955
38       B   260.0943
39       B   396.5310
40       B   325.5422
41       B   374.8063
42       B   363.1897
43       B   258.0310
44       B   358.8605
45       B   251.8775
46       B   299.6995
47       B   303.4766
48       B   359.8955
49       B   299.7089
50       B   289.3128
51       B   401.7680
52       B   276.8078
53       B   441.4852
54       B   232.6222
55       B   305.1977
56       C   298.4580
57       C   210.5164
58       C   272.0228
59       C   282.0540
60       C   207.8797
61       C   263.3859
62       C   324.4417
63       C   273.5904
64       C   348.4389
65       C   174.2979
66       C   363.4353
67       C   260.8548
68       C   306.1833

I've used the seq_along() function and the dplyr package to create an index of each observation for every subject:
dat <- as.data.frame(dat %>%
            group_by(Subject) %>%
            mutate(index = seq_along(Subject)))

   Subject variable.A index
1        A   334.6567     1
2        A   353.0988     2
3        A   244.0863     3
4        A   284.8918     4
5        A   302.6442     5
6        A   298.3162     6
7        A   271.4864     7
8        A   268.6848     8
9        A   262.3761     9
10       A   341.4224    10
11       A   190.4823    11
12       A   297.1981    12
13       A   319.8346    13
14       A   343.9855    14
15       A   332.5318    15
16       A   221.9502    16
17       A   412.9172    17
18       A   283.4206    18
19       A   310.9847    19
20       A   276.5423    20
21       B   181.5418     1
22       B   340.5812     2
23       B   348.5162     3
24       B   364.6962     4
25       B   312.2508     5
26       B   278.9855     6
27       B   242.8810     7
28       B   272.9585     8
29       B   239.2776     9
30       B   254.9140    10
31       B   253.8940    11
32       B   330.1918    12
33       B   300.7302    13
34       B   237.6511    14
35       B   314.4919    15
36       B   239.6195    16
37       B   282.7955    17
38       B   260.0943    18
39       B   396.5310    19
40       B   325.5422    20
41       B   374.8063    21
42       B   363.1897    22
43       B   258.0310    23
44       B   358.8605    24
45       B   251.8775    25
46       B   299.6995    26
47       B   303.4766    27
48       B   359.8955    28
49       B   299.7089    29
50       B   289.3128    30
51       B   401.7680    31
52       B   276.8078    32
53       B   441.4852    33
54       B   232.6222    34
55       B   305.1977    35
56       C   298.4580     1
57       C   210.5164     2
58       C   272.0228     3
59       C   282.0540     4
60       C   207.8797     5
61       C   263.3859     6
62       C   324.4417     7
63       C   273.5904     8
64       C   348.4389     9
65       C   174.2979    10
66       C   363.4353    11
67       C   260.8548    12
68       C   306.1833    13

What I'm now looking to do is set up an analysis that looks at every 10 observations, so I'd like to create another column that basically gives me a number for every 10 observations. For example, Subject A would have a sequence of ten "1's" followed by a sequence of ten "2's" (IE, two groupings of 10). I've tried to use the rep() function but the issue I'm running into is that the other subjects don't have a number of observations that is divisible by 10.
Is there a way for the rep() function to just assign the grouping the next number, even if it doesn't have 10 total observations? For example, Subject B would have ten "1's", ten "2's" and then five "3's" (representing that his last group of observations)?

A: You can use modular division %/% to generate the ids:
dat %>%
    group_by(Subject) %>%
    mutate(chunk_id = (seq_along(Subject) - 1) %/% 10 + 1) -> dat1

table(dat1$Subject, dat1$chunk_id)

#     1  2  3  4
#  A 10 10  0  0
#  B 10 10 10  5
#  C 10  3  0  0

A: For a plain vanilla base R solution, you also could try this:
dat$newcol <- 1
dat$index <- ave(dat$newcol, dat$Subject, FUN = cumsum)
dat$chunk_id <- (dat$index - 1) %/% 10 + 1

which, when you run the table command as above gives you
table(dat$Subject, dat$chunk_id)
     1  2  3  4
  A 10 10  0  0
  B 10 10 10  5
  C 10  3  0  0

If you don't want the extra 'newcol' column, just use 'NULL' to get rid of it:
dat$newcol <- NULL


text:
Gaggioli and Frattini take Bisbee titles
Davide Frattini (Team Monex) and Lynn Gaggioli (T-Mobile) wrapped up the overall titles at La Vuelta de Bisbee Sunday morning despite both final stages being won by gutsy solo breakaways. Burke Swindlehurst (Navigators) found a reserve of strength after having to contend for his top-three spot without team support and powered the infamous Tombstone Canyon climb for his solo win. In an almost 50-mile breakaway, two-year cycling veteran Michelle Beltran (Red 5 Racing), stormed up the final climb minutes ahead of the field to claim her stage win. The day opened with GC leaders holding known,
Gaggioli defended her lead
Davide Frattini (Team Monex) and Lynn Gaggioli (T-Mobile) wrapped up the overall titles at La Vuelta de Bisbee Sunday morning despite both final stages being won by gutsy solo breakaways.
Burke Swindlehurst (Navigators) found a reserve of strength after having to contend for his top-three spot without team support and powered the infamous Tombstone Canyon climb for his solo win. In an almost 50-mile breakaway, two-year cycling veteran Michelle Beltran (Red 5 Racing), stormed up the final climb minutes ahead of the field to claim her stage win.
The day opened with GC leaders holding known, but not secure, advantages over the rest of the potential podiums. The long looping stage rolled first down away from town along open desert highways then back to the base of the 14-mile Mule Pass climb before finally turning up to the Tombstone Canyon finale.
Beltran had company for the first few miles but, no one could stay with her
An early break of three riders slipped off the front after only several miles in the women's event. With more than 45 miles left in the race, the two team's containing GC threats to overall leader and unsupported racer Lynn Gaggioli, didn't have an investment in chasing it down.
Beltran, one of the three breakaway riders, who was 5:45 behind on GC at the start of the day, managed to get away from her breakmates. "A friend told me a few weeks ago that there's magic in boldness," she said of her mentality on the course. "I was thinking of that when I got away."
Back in the main group sat Gaggioli, the Tamarack/Goldy's team of second-placed Suz Weldon and Team Victory Brewing with third-placed Brooke Ourada.
"Because the break didn't contain anyone from Goldy's or Victory," Gaggioli said, "the field kept sitting."
So Beltran's effort held.
In fact, she extended it on the road into dangerous territory, threatening GC at one point. "The officials told me the gap was up to five minutes," said Beltran. "So I just kept doing all the things I thought the group wouldn't do – power over climbs, press on the downhills."
Gaggioli was left to monitor the break on her own
With no teammates to help, Gaggioli had to depend on others to bring the break back. Neither of the other podium contenders' teams would work and Gaggioli found herself off the front too often, being marked for the climb and getting help only from random other riders.
That left Beltran, a former bodybuilder and fitness trainer who's only been cycling competitively for two years, 2:54 up the road at the bottom of Tombstone Canyon. Beltran crossed the line far enough ahead for a two-handed salute and a pat on the back from almost every other finisher who came after, but with not quite enough time to overtake the general classification.
Gaggioli approached the final climb with all her rivals safely in sight, finishing well enough to secure the overall. The competent and tactical way in which she won Bisbee seems to indicate that she's is, in fact, recovering properly and returning to form after an injury she sustained toward the end of last season. She will be rejoining some of her T-Mobile teammates for next week's Tour of the Gila and will be seen later this year at the Joe Martin and Captech Classics.
In the men's race, the gaps between the top-three GC spots were much tighter so control on the road was more critical. Davide Frattini's Team Monex and Drew Miller's Landis Trek/VW had the most at stake and were seen constantly patrolling the front of the field.
"The team worked hard all day to chase breaks," Frattini said in fractured English. "There was more wind (on the highways) and it was more difficult."
The early break in the men's race would gain just over three minutes before the chase began
Miller's team shared the load. "It was mostly a comfort thing (to stay at the front of the field). Keep me near the front. Keep things under control."
The pressure from Monex and Landis Trek/VW kept the race together over the climb up Mule Pass. From there, riders had only the run up to the climb back into and up Tombstone Canyon.
Team Monex in control
It was at that point that Burke Swindlehurst decided that, as an unsupported rider, this might be his only chance to win. "I attacked about three miles out," he said. "There was no time to take inventory (about who was close behind and how far back they were). I just gave it everything I had."
A select group of about twelve riders, which contained Frattini and Miller, watched from behind. "Frattini played a really smart race," Miller said. "I kept waiting for him to chase Burke."
But Frattini knew that he didn't have to beat Swindlehurst up the climb, just keep him within the 17-second advantage he held in GC. He knew the gaps because he, and every member on his team, had the numbers and times of the top dozen or so contenders taped to their stems. "All attacked, all jumped," he said about the run up into town. "I chased but waited to the last kilometer."
"Frattini lit it up the last 200 meters," Miller said. Frattini only yielded eight seconds to Swindlehurst on the line — enough to hold on to the win by just three seconds. "He managed it beautifully," Miller said.
Maybe with continued success like Frattini had in Bisbee, he'll be able to reconcile the problem that put him in the U.S. in the first place – lack of a contract to race in his native Italy.
Race NotesYes, There Was a B Race
As well as the Elite men's and women's fields battling on the roadsin and through Bisbee, there was a 75-rider strong Master's and Cat 3 andbelow B event. Team Honeywell Cycling and their designated GC leader, EricBrownell, controlled the race through every stage. He won the prologuetime trial and, with help from a large group of teammates, kept close controlon each stage.Brownell has been cycling for more than five years, competes with histeam throughout the West and is occasionally seen nationally in selectedevents (such as the road race national championships). His associationwith Honeywell Cycling, a Phoenix-based club team comprised of Honeywellemployees and some community members, began when he worked for what wasthen Allied Signal. "I was part of the founding team and love racing withthese guys," he said."I was in Bisbee last year in the A race. My friends said they wantedto race but needed a GC rider so I said 'sure, I'll ride the B race foryou guys.'" Brownell gathered up the leaders jersey on the first day andhis team never let him lose it. "We had fun. I'd love to do it again."
Rainbow stripes in Bisbee
You may have noticed one conspicuously female name in the results of men's race this weekend. Mari Holden (T-Mobile), who won the Olympic Silver Time Trial medal,the Time Trial World Championship and the U.S. National Time Trial Championshipsin 2000, was in Bisbee to get valuable training miles. By competing inthe men's race, which she wasn't here to contest she says, she gained greatermileage and avoided the competitive pressure that would have come fromracing alongside the fierce, 60-rider women's field.Look for Holden at the Tour of the Gila in Silver City, New Mexico nextweek, and at the National Championships in June where she'll attempt toqualify for a 2004 Olympic spot.Stage 3 Results:
1. Burke Swindlehurst (Navigators)
2. Davide Frattini, Team Monex at 0:09
3. Drew Miller, Landis Trek/VW, 0:09Women
1. Michele Beltran, Red 5 Racing
2. Brooke Ourada, Team Victory Brewing, at 01:49
3. Kate Sherwin, s.t.Final overallMen
1. Frattini
2. Swindlehurst, at 0:03
3. Miller, at 0:03Women
1. Lynn Gaggioli, T-Mobile
2. Ourada, at 0:49
3. Suz Weldon, Tamarack/Goldy's, at 01:16.
Ve-gains? Why so many pro riders are turning vegan – and why so many stay away
Caleb Ewan first in line ahead of Philippe Gilbert at Milano-Sanremo
Tour de Hoody: Is the sky falling on Ineos Grenadiers?
Clásica San Sebastián: Annemiek van Vleuten goes solo for rainsodden victory
Power analysis: Il Lombardia by the numbers
Eric Brunner solos to U.S. 'cross national title


text:
Midvale School District #433
Go to site - Midvale School District #433 http://www.midvalerangers.org/'
School review and Information: Contact information and list of board of trustees.
Previous 10 school Idaho Falls School District 91 http://www.d91.k12.id.us/ Idaho Falls School District 91 Information about the school board, forms, links to school pages, and budget report.
Previous school Middleton School District #134 http://www.msd134.org/ Middleton School District #134 Links to school pages, information about the school board and food services, and calendar.
Random 1 school Penn Yan Central School District http://www.pycsd.org/ Penn Yan Central School District District and some school information for public schools serving grades kindergarten through 12.
Random 2 school The Bonn Graduate School of Economics http://www.bgse.uni-bonn.de/ The Bonn Graduate School of Economics The Bonn Graduate School of Economics is designed for highly qualified students with a strong interest in quantitative economic research. The successful completion of the program will qualify students for positions in academic institutions, industry, political and public administration.
Random 3 school Clarksville School District http://www.csdar.org/ Clarksville School District (Johnson County) Calendar, lunch menus, job openings, salary schedules, board agenda and minutes, and school sites.
Random 4 school Sir Wilfrid Laurier School Board http://www.swlauriersb.qc.ca/ Sir Wilfrid Laurier School Board Council meetings, publications, and job postings. Located in Rosemère.
Random 5 school Hoover City School System http://www.hoovercityschools.net/ Hoover City School System Information about the district that includes a school directory, demographics, departments, maps and calendar. Also provides parent information, links to all schools in the district, employment opportunities and contact details.
Next school Moscow School District #281 http://msd281.org/ Moscow School District #281 Information about curriculum, newsletters, calendar, and test scores.
Next 10 school Ririe Joint School District #252 http://ririe.id.schoolwebpages.com/ Ririe Joint School District #252 Contact information and district calendar.
Random 4 school North Boone School District http://www.nbcusd.org/ North Boone School District Features information on district administration, schools, calendar of events, transfer eligibility, driving directions, links for students and teachers, and contacts.
Random 5 school Catalina Foothills School District http://www.cfsd16.org/ Catalina Foothills School District District information and policies.
Next 70 school Evanston/Skokie Community Consolidated School District 65 http://www.district65.net/ Evanston/Skokie Community Consolidated School District 65 Illinois school district links to district and school board information, area schools, a school calendar, and a policy handbook.
Previous 70 school Kellogg School District # 391 http://www.kelloggschools.org/ Kellogg School District # 391 (Kellogg) District news, calendar, mission statement, district strategic plan, employment opportunities, administrative directory, board policies, and school web sites.
Next 170 school Brookwood School District 167 http://www.brookwood167.org/ Brookwood School District 167 Links, events and other information on the district. Serving Glenwood.
Previous 170 school Collins Hill High School Wrestling https://collinshillwrestling.wordpress.com/ Collins Hill High School Wrestling Varsity, JV and youth wrestling programs located in Suwannee, Georgia.


Featuring a single freshwater pearl, light-catching Swarovski crystals and diamante detail, this wedding pendant necklace is simply beautiful. Complete with sterling silver clasp and extension chain for the perfect fit.
Necklace length: 40.5-45.5cm adjustable. Pendant: 3cm.


text:
HOT CHOCOLATE IN A BOWL
…but what's that got to do with the price of eggs?
Basic HTML
← Catching up on Chihayafuru: Poems 161-165
Masterpost: On Anime 'Writing' Project →
Kawamori x Yoshino on Creating Macross Frontier
This was a discussion between Kawamori Shōji (Chief Director) and Yoshino Hiroyuki (Series Composition), in which they discussed the genesis of Macross Frontier, the 25th anniversary production that reignited the Macross fandom both in Japan and around the world. It appeared in the first volume of Animage Original, which dates from August 2008. Since it was released during the second half of the show's original TV run, there is nothing in the discussion about the controversial ending. However, I do recommend this to anyone who wants to know where the ideas for their favourite characters came from, or who is interested in the earliest stages of creating a TV series.
At first glance, "an incompatible pairing." On one side is the genius designer and director whose unique works such as Genesis of Aquarion have attracted the support of a core group of fans. On the other is the popular screenwriter that has participated in all manner of hits, starting with Mobile Suit Gundam SEED. How did these two creators, who arguably stand at opposite ends of the anime world, come together to develop the story of Macross Frontier?
25 years of experience became our trump card
To start off, I'd like to ask the two of you about how this project was born.
Yoshino: It'd be better to start from before I joined the team, perhaps?
Kawamori: Well, from the time of Macross Zero (2002-2004), I'd been involved in discussions about making a Macross project for the 25th anniversary. The orders I'd been given during that early planning stage were to "do something like the original SDFM" and "that I don't twist things any more than I'd already done" (chuckles). We had an idea for short project that ended up being canned, about a special investigation valkyrie team whose work is to crack down on crimes committed by full-sized Zentradi…
Yoshino: Wow, I'd be interested in watching that, actually…
Kawamori: Then, you might call this a blessing or a curse, but after Macross Zero, I directed Genesis of Aquarion, so I'd actually had my fill of "twisted" stories by then. In any case, the first thing I worried over was what to do about the singer. If we went with a guy, it'd be difficult to surpass Basara. But a lone female singer wouldn't be able to adequately cover the range of music styles that we have today. So we thought about making it about a group of female artistes….
Yoshino: I see, you mean like Idolmaster? But if you had such a group singing and dancing, the animators would all keel over and die.
Kawamori: Right. And that's why we started talking about having a pair of girls. But starting the story with the duo already formed would not have been that interesting, so we were going to introduce them separately. And that's how the characters that became Ranka and Sheryl were created. As for Alto, the protagonist, he was originally a gamer.
Yoshino: Right. I remember that.
Kawamori: A beautiful gamer that outwits all the guys in the line—but it turns out that he's a guy…(chuckles). However, the notion of a gamer who also demonstrates his skills in a real fight is pretty common.
Yoshino: Overman King Gainer used that idea, too.
Kawamori: And so, we came up with something that sat in complete contrast with the concepts of 'the future' and 'space': a kabuki onnagata.1 There was also an order from the producers to lower the target age group, which is why we went with a school-based story. And then we came up with the idea of a quarter-sized Macross, which went hand-in-hand with the working title of Macross 25 (Quarter). It was just after that that Bandai Visual producer Kunisaki Hisanori introduced me to Yoshino, who was involved in creating Mai-HiME (2004).
Yoshino: At the time, Producer Kunisaki told me that this new Macross was set in space, but they wanted to create something like the original SFDM. He also added that "it took us a year to convince Kawamori on this, so I'm leaving the rest to you" (chuckles). With regards to the triangle, Kawamori's plan was to have two guys and one girl. But I was like "That wouldn't be interesting at all. Let's make it a harem, with two girls!"
Kawamori: Come to think of it, I hadn't actually done any harems before this. I just never believed anyone could be that lucky (chuckles).
Yoshino: When Kawamori showed me the character chart, Sheryl was little more than an artiste that Ranka looked up to. So we raised her standing in the story and thus completed the triangle. Sheryl was like the movie (Do You Remember Love?) version of Minmay, whilst Ranka was the TV version. I was pretty much challenging myself to follow in the footsteps of the original. At first, Kawamori gave me a funny look, but with the second episode, "Hard Chase," I was able to break through his doubts.
Kawamori: Right. With "Hard Chase," I came around to thinking of this series as a challenge of seeing how differently we could present the same set-up. When Kanno (Yōko) said to me: "Doesn't kabuki consist of the same programmes being done over and over, just adapted slightly different for each generation?," I finally thought that what we did with Alto was the right choice. Though it was after-the-fact, like "Oh, so that's why I made him a kabuki actor."
Yoshino: For "Hard Chase," we didn't discuss anything beforehand; I just nervously handed over my first draft of the episode script. I figured that if this one passed muster, then I'd probably be able to do anything (chuckles). In contrast with Kawamori, who's all about doing something different each and every time, I'm the kind of person who's quite up front about what I like.
Redoing the original, but making it different: instead of falling like Minmay,
Ranka has to be saved from being sucked out into space.
Kawamori: Even whilst saying that "we'll take the path sown by SDFM," at first, I was actually trying to resist that.
Yoshino: But after you came around with "Hard Chase," it was like you just accelerated.
Kawamori: Are you referring to that time with episode 4, when I was like "I'm really sorry, Yoshino, but even though I confirmed this script already, could you rewrite it one more time?"
Yoshino: Yup. Episode 4 was "Miss Macross," if I remember correctly. We'd gone through all the way to the final draft for episode 4, so I was surprised when you told me "If we're doing this much in episode 7, then could we make episode 4 even more flashy as well?"
Kawamori: It was when we were working on episode 4 that it really hit me that 25 years had passed. That is to say, even if we were following the same path and structure as the original SDFM, because Kanno had joined us, and because there were two songstresses instead of just one, it was already different. And once that happened, I felt that whilst the surface might look the same, we could use everything below that surface to rise up to the challenge.
Before long, the 50 years that have passed in the world of Macross will also have started to flow on us
Kawamori: I had wanted to pace Aquarion better than the shows of the past, but I still ended up regretting that it felt so slow. Then, when I watched Mai-HiME, it proceeded at a pretty fast clip. Like, really interesting things were happening by episode 6 or 7. I was really impressed by that, so right from the start, we decided that we'd go at double-speed for Macross F.
Yoshino: In any case, since we have two songstresses, we'd never fit everything in if we didn't go at double-speed (chuckles).
Kawamori: Right right. It really wouldn't fit. We've come up with lots of side-stories and details, too, but there's simply no time to do them all.
Yoshino: We have thrown away a lot of ideas. But the more we throw away, the more polished the final work should be.
Kawamori: We've only used ideas that have broken the 10-second barrier (for the 100m sprint). But if two episodes in a row have been in the 10-second tier, then the next one has to be from at least the 8-second tier. No matter how many ideas we came up with, there'd be no point if they didn't fulfil these kinds of criteria. And because of this, we were pretty stressed at least until the end of the first cour.
Yoshino: That's right, I think it was around the 10th episode, "Legend of Zero," that the characters started moving on their own. I remember you saying that you wanted to do a 'film within a film', and for various reasons, we decided on using Macross Zero…
Kawamori: Deciding to go with Zero for that in-universe movie was a huge breakthrough for us.
For example, the triangle started moving forward…
Yoshino: Because of episode 10, we started being able to see both the background and the ending of the show. All the elements that were just strewn about until then became neatly connected to each other.2
Kawamori: Even though it was a 'film within a film', it crossed a line for us. In remaking Zero, it was like the 50 years that had passed in-universe became a temporal axis upon which history turned.
Yoshino: Zero was actually the newest Macross work, but just as it would have been for the characters in Frontier, it felt to us like those 50 years had passed.
Kawamori: It was a strange feeling, huh? Like we'd really become part of that pseudo-history ourselves. As if, along the lines of an idea that I came up with 25 years ago, something encompassing all of the works produced so far came to us. And since we've encountered it, it's become even more meaningful. Looks like the term "Super-dimensional" really wasn't just for show (chuckles).
Yoshino: So that's it! (Laughs)
Kawamori: 25 years ago, I gave myself the constraint of not reusing things that had been successful in previous works. That's why SDFM was quite an accumulation of those things I could not do. And after 25 years, it's become something of a classic, which was quite a shock in its own way.3
From the disposition of an entertainer…
Kawamori: At the moment, it seems like a lot of the people watching Macross F have seen previous Macross series, like the original or Macross 7.
Yoshino: But there are also many younger fans. If you look up Macross F in a certain blog accumulator, you can get results differentiated by gender and age. When broadcast first began, it was about half/half gender-wise, with the core group of viewers in their twenties. But more recently, teenagers and girls/women are gaining in number.
Yoshino, did you have a particular strategy for targeting fans new to the franchise?
Yoshino: I wouldn't call it a strategy, but when I was involved in Code Geass: Lelouch of the Rebellion, we did some research on the question of "what can we do to engage younger viewers?" and even spent several entire nights debating it. Of course, what we learned from that was used in Code Geass. And the methods and elements we didn't use for Code Geass were key to the making of Macross Frontier.
Kawamori: Until this series, I had thought about the question of "how do we convey what we want to convey to viewers easily?" However, what was really refreshing about working with Yoshino was that we seriously addressed the question of "how do we make this show popular?" (chuckles)
I really need to watch DYRL again. I went back to find a screenshot, and absolutely loved the character animation in this performance scene!
Yoshino: There are so many shows nowadays, of any and every kind, so in the first place, you've got to get people to watch it. If you asked me what is different between 25 years ago—when you were working on SDFM—and now, I'd suggest that it's far more difficult now to get people to watch that first episode.
Kawamori: Yes, and that's something that I've felt for other shows I've worked on. But I've been rather stubborn about it, like "If we do this, then sure, they'll love it, but that's pretty much brainwashing, isn't it?" (chuckles). And so, we're now trying to give great enjoyment to viewers without crossing that line into brainwashing.
Yoshino: Well, there are, broadly speaking, two types of directors. The ones who get really into the things they like and thus stay in the minor-leagues, and the entertainers. But I think that you are someone whose interests—the things that you want to do and that you enjoy doing—make you an entertainer-type.
Kawamori: Oh…I see.
Yoshino: Hm…well, please don't think about it too much (chuckles).
Kawamori: Perhaps the perfect balance is something like "Well, I've done something like this once before…" If you do something that's completely new, then it'll resonate strongly with about 10% of viewers, but the rest of them would probably blank out, huh? (chuckles).
Yoshino: Despite that struggle, though, Kawamori is the one who always says "As long as it's interesting, it's possible!" You can really trust in him as an entertainer. Because of that, if I could connect all that things that Kawamori finds interesting, then I was certain that it'd become something that the masses would like. I've been fortunate enough to have participated in a quite number of other hits, and I've thrown everything I've learned from those experiences into Macross F. The first thing I have to do here is come up with something that Kawamori will find interesting.
Kawamori: Yoshino, you must have incredibly large drawers (of talent/skills). And in that, there is so much technical finesse that you're really brilliant at pulling everything together. It's like, "You can fall through just a little bit more, you know." That's something that went through my mind when we first starting working together.
Yoshino: There were quite a number of instances where you had me do huge rewrites even after the third draft, huh?
Kawamori: Recently, when it comes to story developments that we can see coming, I've become able to say "We can't do that (laughs). Try completely changing just this part to use this idea instead—but everything else is A-Okay."
Yoshino: I'm quite particular about consistency, so if it's just me writing, then I have a tendency to bring everything together really neatly…but there's an amazing destroyer sitting right in front of me here (chuckles). It's pretty unusual for the first draft and the final draft (of the episode script) to be this different, don't you think?
Kawamori: But if we don't do that, the existence of the original series means that this series might be too predictable/pre-ordained. Wouldn't that be frustrating? I'm glad that we gathered together so many people who don't like stuff that's predictable.
Embarrassment beyond our expectations has been burnt onto film
At the same time, when we open the lid, the songs give off a rather mature impression.
Yoshino: We really have to thank Kanno Yōko for that.
Kawamori: I'd just worked with Kanno on Aquarion, so we had something of a tacit agreement that we'd work together again only after doing several other series each. But I wanted to ask her for a few songs for Frontier, so I showed her the story, and she turned around and said "I'll do them all!" (chuckles).
Yoshino: When Kanno came around to say she'll do it after reading the episode scripts, I was like "Alright!" For us screenwriters, our first and most important task is to write something that the other staff will be interested in doing. So when we confirmed Kanno, I felt that we'd gotten over that first mountain.
Kawamori: Fortunately, we were somehow able to find May'n for Sheryl and Nakajima Megumi for Ranka. For Kanno as well, it seemed like she figured it all out after she got them to sing the same song. In any case, the episode where their singing really helped us out was the third one, "On Your Marks."4 We crammed a heap of stuff into that episode, but for some reason, the finished episode was really clear and refreshing. I was like, "Huh? What happened?"
Yoshino: Me, too—I asked Kawamori, actually, "Has this turned into a really embarrassing story about youth?" But at the same time, it leaves you with such a great feeling.
Kawamori: I do wonder, how in the world were we able to make something so embarrassing at this age… Of course, it's not that we weren't aiming for that outcome; rather, if we're not careful, then it'll become even more of a story about youth than even the first Macross. By way of contrast, I felt that we'd been overreaching(?) back then.
Yoshino: For me, I was rather apprehensive of the danger that it'd unconsciously become "something made by 30- and 40-something-year-old men reminiscing about their own youth" (chuckles).
Kawamori: But you know, it really was because of May'n and Megumi and the rest of the fantastic seiyuu that Frontier can be seen straight-out as a show about youth. Kanno even called it "Kōshien."5
Yoshino: That sense of shyness, of embarrassment, in those first few episodes really felt good, Nakajima Megumi's guileless acting as well.
Kawamori: Kikuchi Yasuhito, who I'd asked to direct the show, is great at depicting cute characters in an orthodox way, which was really helpful in achieving that balance. That mysterious balance that goes beyond the question of whether it's interesting or not, that you can't achieve even if you aim for it.
Yoshino: In terms of how people behave in daily life, or rather, how girls behave, Kikuchi really is fantastic at that. Take Sheryl, for example—if you're not careful, there are quite a few things about her that would inspire hate. But he was able to capture her as the cute girl that we'd envisioned, so we're incredibly grateful for that.
But now, the 'show about youth' aspect of Frontier has grown thinner, wouldn't you say?
Kawamori: That's true. You could say it's become a bit harsher, or perhaps, we made it so heartwarming that it seems to have gone in an improbable direction. Of course, Macross F itself is improbable, really (chuckles), but one person has gone off in a good direction. In maintaining that balance in the triangle, it was like a pure air pocket came into being. Part of it may be that Megumi has now debuted, but that final scene of episode 10 where Ranka ascends onto the stage really gave off a sense of anticipation. It wasn't just the great animation in that scene, but also the costume designed by Ebata Risa. A simple dress, but with slightly more elaborate shoes.
Yoshino: And that bit where she hesitated before ascending the stairs, wasn't that great?! I thought it was fantastic! Though I'm not sure what you'll make of this, since it comes from the person who wrote the script…(chuckles). But I do wish that young people today would believe in themselves more, in what they like and in what they want to do. Our main characters—Ranka, who didn't give up on her dream; Alto, who's trying his best even after going against his family; and Sheryl, who's bursting with confidence—they're all carrying that hidden message that we want young people to come away with.
KAWAMORI Shōji (born February 2, 1960, from Tōyama Prefecture) is a director and mechanic designer who belongs to Studio Nue. He debuted as a mecha designer in Fighting General Diamos (1978), before he was involved in the creation of The Super Dimensional Fortress Macross (1982). He debuted as a director for SDFM: Do You Remember Love? just two years later, and has since been involved in numerous other works.
YOSHINO Hiroyuki (born June 2, 1970, from Chiba Prefecture) is a former schoolteacher and magazine journalist who has become a screenwriter. He has been involved in landmark shows such as Mobile Suit Gundam SEED(2002) and Code Geass: Lelouch of the Rebellion (2006). He was also responsible for series composition on Mai-HiME (2004).
Disclaimer: As always, the translation is entirely mine, as are any mistakes and misinterpretations. Please do not copy and paste large portions of it anywhere else, though feel free to link to the post itself if you wish.
This is the 8th post in my "On Anime 'Writing'" project, in which I have been looking at how the key staff of producers, directors and screenwriters work together to plan and write the shows that grace our screens. If you liked it, I hope you'll check the other posts out, too. And feel free to drop me a note or question about any other series that you're interested in for behind-the-scenes info!
an actor that plays female roles in kabuki theatre, which is traditionally performed only by men. ↩
Before anyone gets any strange ideas that "OMG! Frontier really was written on the fly as they were animating it!" please note that Kawamori and Yoshino are still talking about pre-production here. ↩
In the commentaries for episodes 4 and 10, Yoshino and Kawamori go into a little more detail about what they'd talked about here. I have actually posted summaries of the eight commentary tracks that were recorded for the original BD/DVD releases back in 2008/9, but I need to go over them again. I also need to get to the four extra commentaries recorded for the Zentra-sized BD-box set that was released a few years ago… ^^; ↩
Hm…the only insert song in this episode was Ranka's Aimo…unless they're referring to the two girls singing "Diamond Crevasse" at the end of the previous episode? ↩
Kōshien is the baseball stadium where the national high school baseball tournament is held in spring and summer every year, and is shorthand for the tournament itself. "Going to Kōshien" is basically the dream of any and every high school baseball player in Japan. ↩
Filed under Anime, Anime 'Writing', Behind-the-scenes, Macross, Project, Staff
About karice
MAG fan, freelance translator and political scientist-in-training. I also love musicals, travel and figure skating!
3 Responses to Kawamori x Yoshino on Creating Macross Frontier
Pingback: For the record: Yack Deculture! | HOT CHOCOLATE IN A BOWL
Pingback: Masterpost: On Anime 'Writing' Project | HOT CHOCOLATE IN A BOWL
Pingback: [1] -macross frontier: love- – Mage in a Barrel
Editorials and translations by an anime and manga fan, amateur translator and political scientist in training.
Unless otherwise noted, all Japanese, Korean and Chinese names will appear in surname-given name order on this blog.
'White Box' Treasure is where I store my collection of translations and useful links. I also post random translations snippets at 'White Box' Gems and have fun with Japanese at Language is Life.
Otherwise, feel free to hit me on curiouscat or tumblr, or tap the "Ask me anything" tab below the header.
Currently on hiatus (Jan, 2018~)
Categories Select Category Anime (442) Code Geass (6) ΛLDNOΛH.ZERO (34) Macross (49) Monogatari Series (34) Yuri!!! on ICE (32) Behind-the-scenes (92) Cast (26) Staff (77) Cultural Notes (39) drama (28) J-drama (18) K-drama (10) Fandom (23) Film (90) Chinese-Hong Kong (1) Japanese (20) Western (71) Games (1) Literature (37) Eastern (6) Western (16) Manga (145) Chihayafuru (35) Performance (6) Pick That Voice!! (7) Project (30) Anime 'Writing' (30) Tokyo Youth Ordinance Bill (6) Translation (124) Episode Commentary (12) Interview (43) Lost in translation? (15) Music and Lyrics (2) Radio Show (8) Uncategorized (7) Year Review (136) 2006 – 2009 (5) 2010 (13) 2011 (13) 2012 (13) 2013 (13) 2014 (17) 2015 (15) 2016 (16) 2017 (16) 2018 (11) 2019 (1)
Archives Select Month December 2019 (2) January 2019 (5) December 2018 (7) October 2018 (1) June 2018 (1) January 2018 (6) December 2017 (8) November 2017 (3) October 2017 (8) September 2017 (5) July 2017 (2) June 2017 (2) May 2017 (2) April 2017 (2) March 2017 (3) February 2017 (4) January 2017 (9) December 2016 (11) November 2016 (6) October 2016 (8) September 2016 (3) August 2016 (3) July 2016 (6) June 2016 (2) May 2016 (5) April 2016 (5) March 2016 (6) February 2016 (3) January 2016 (7) December 2015 (10) November 2015 (5) October 2015 (6) September 2015 (3) August 2015 (6) July 2015 (4) June 2015 (6) May 2015 (5) April 2015 (1) March 2015 (3) February 2015 (7) January 2015 (21) December 2014 (15) November 2014 (7) October 2014 (6) September 2014 (2) August 2014 (2) July 2014 (1) June 2014 (3) May 2014 (4) April 2014 (3) March 2014 (5) February 2014 (1) January 2014 (10) December 2013 (18) November 2013 (1) October 2013 (7) September 2013 (4) August 2013 (4) July 2013 (1) June 2013 (1) May 2013 (4) April 2013 (8) March 2013 (5) February 2013 (5) January 2013 (8) December 2012 (15) November 2012 (4) October 2012 (2) September 2012 (7) August 2012 (4) July 2012 (5) June 2012 (4) May 2012 (1) April 2012 (5) March 2012 (4) February 2012 (4) January 2012 (10) December 2011 (9) November 2011 (5) October 2011 (2) September 2011 (4) July 2011 (6) June 2011 (1) April 2011 (1) February 2011 (1) January 2011 (13) December 2010 (13) November 2010 (4) October 2010 (5) September 2010 (1) May 2010 (3) April 2010 (1) March 2010 (5) February 2010 (4) January 2010 (6) December 2009 (5) November 2009 (3) October 2009 (2) September 2009 (1) August 2009 (3) July 2009 (1) June 2009 (4) May 2009 (4) April 2009 (7) March 2009 (2) February 2009 (3) January 2009 (2) December 2008 (1) November 2008 (3) October 2008 (8) April 2008 (2) February 2008 (8) January 2008 (3) December 2007 (1) November 2007 (1) July 2007 (4) May 2007 (8) March 2007 (2) February 2007 (8) December 2006 (5) October 2006 (1) September 2006 (1) July 2006 (2) May 2006 (2) April 2006 (2) February 2006 (11) January 2006 (4) December 2005 (3) November 2005 (2) October 2005 (3) September 2005 (1) August 2005 (5) June 2005 (3) March 2005 (5)
[Podcast] Chatty AF… on Rakugo Shinju: Ishida Akira x…
Anikenkai Anime Club… on Rakugo Shinju: Ishida Akira x…
sendnootsnow on A second look at Usagi Dr…
Eventing in 2018 Par… on Things to do in Tokyo in winte…
Chihayafuru 138: on Taichi
(Summary/Translation): The world of Aldnoah.Zero
Review: Moyashimon
Macross 'Canon'? Oh, you mean Macross HISTORY...a shout out to Kawamori Shouji and postmodernism
Chihayafuru Manga: Poem 138
Short Translations
soyouwanttowatchfs: 2019-2020 ISU Grand Prix Assignments (as of...
chibipika: Every time a post on queerplatonic relationships makes its way around tumblr, the...
In reply to a recent askTo the person who sent me a translation ask recently, I didn't want to post...
Indonesia Anime Times Features
How Do Indonesian Otaku Search and Use Information? A Brief Profile of Indonesian Otaku Information Behavior
"Astra Lost in Space" Anime Review: A Great Journey to Discover Oneself
The Magic Rain (Malaysia)
THE MAGIC RAIN's Top 10 Most Anticipated Games of 2020
Hatsune Miku: Seraphim On The Ring – Vocaloid Spotlight
What Went On At Comic Fiesta 2019
Cautious Hero: The Hero Is Overpowered but Overly Cautious – Anime Review
Our Top (Non-Sequel) Picks For Winter 2020!
Anime Pilipinas (Philippines)
ODEX to release "Konosuba" anime film in Philippine cinemas this March 2020
Medialink's Ani-One adds "Show By Rock!! Mashumairesh!!", "Infinite Dendrogram" to Winter 2020 lineup
MUSE Asia adds two more titles to Winter 2020 simulcast lineup
Sony Pictures offload Asian television channels to former executives
Medialink's Ani-One streams "Sorcerous Stabber Orphen" reboot this Winter 2020
Sakugabooru
Keep Your Hands Off Eizouken! 02 – Production Notes
Hoshiai no Sora / Stars Align: A Story About Corporate Betrayal, But Also A Lot More
Episodic Gurren Lagann Interviews with Director Hiroyuki Imiashi & co. – Episode 4 (Anime Style, January 2008)
Fire Force – Episode 1
Naruto EPISODE 133: "A Plea from a Friend" (NEWTYPE – August 2005)
An Interview w/ Atsushi Wakabayashi (ANIMAGE December, 2008)
Guin Saga : Interview with Director Atsushi Wakabayashi (Part 2)
Deculture Shock
Macross Illumination Live!!!!!!
Mai Shiranui Popup Shop
Winter 2020 Premiere Digest
A3! Spring and Summer – Episode 1
ARP: Backstage Pass – Episode 1
In/Spectre – Episode 1
A Destructive God Sits Next to Me – Episode 1
ANN Features
The Best of Anime 2019
Boku no Hero Academia – 77
To Aru Kagaku no Railgun T – 02
Jibaku Shounen Hanako-kun – 02
Plunderer – 02
Secrets of the Slate
have you guys considered making a page on the K wiki and putting the indexes there?
Hi all!Long story short: ultimately secretsoftheslate has two aimsSpreading K related news and...
Tatsukida
Kore wa ai de, koi janai [Chapter 1]
Kurosaki kun no Iinari ni Nante Naranai [Chapter 62 - Devil Brother]
Kono Oto Tomare [Chapter 87 - Silent Thunder]
18-sai, Nii Zuma, Furin shimasu. [Chapter 0 - 18 years old, Secret Prologue, Wedding Eve]
Free Talk: New Year Greetings
GROPING in the DARKNESS – Links to structure points covered
Taking the Plunge: Japanese Self-Immersion. Links to all structure points
Speaking Japanese Without an Accent – Vital Skill or Party Trick?
Planet Hanyu
La Stampaより「日本の羽生に投げられたぬいぐるみに込められたトリノの情熱」~他
ポッドキャストKiss&Cry II第5回「羽生結弦の珠玉~SS/TRの評価基準」
ポッドキャストKiss&Cry II第7回「トリノGPF~女子シングル考察+」
In the absense of time
Remembering Love for Macross Frontier: Newtype Character Polls
Brief thoughts on Yuri!!! on ICE episode 12
Language is My Life
Key elements in anime production: 'Scripts' 'scripts' and 'scripts'?
"Royal Road"? "Easy way out"? Ohhhh, you mean "Classic"
Yuzuru Hanyu - the Absolute Champion
White Box Treasure
My collection of links to anything and everything that goes on 'behind-the-scenes'.


text:
Q: Exporting an array to Excel I'm trying to export an array of arrays to excel.  I have it set up to be a header variable, and a data variable that basically builds a giant string to be executed in the export.  However, only the header variable is going through.  Let me show some code:
This is setting the parameters:
    str_replace(" ", "_", $getData['name']);
    $filename = $getData['name']."_summary.xls";
    header("Content-Type: application/x-msdownload");
    header("Content-Disposition: attachment; filename=\"$filename\"");
    header("Pragma: no-cache");
    header("Expires: 0");

Which goes to a function to get the information:
foreach($tempRS as $key=>$value)
{
    foreach($value as $iKey=>$iValue)
    {
        if($count == 6)
        {
            $iValue = str_replace('"', '""', $iValue);
            $iValue = '"'.$iValue.'"'."\n";
            $data .= trim($iValue);
            $count = 0;
        }
        else
        {
            $iValue = str_replace('"', '""', $iValue);
            $iValue = '"'.$iValue.'"'."\t";
            $data .= trim($iValue);
            $count++;
        }
    }

}
$header = "ROW HEADER 1\tROW HEADER 2\tROW HEADER 3\tROW HEADER 4\tROW HEADER 5\tROW HEADER 6\n";
print "$header\n$data";

I can't seem to figure out why i'm losing the $data variable on the export.

A: Why not just fputcsv() to generate that CSV data for you? Or better yet, instead of making a .csv masquerade as an Excel file, you can use PHPExcel to output a native .xls/.xlsx and actually use formatting and formulae in the generated spreadsheet.

A: first of all, use echo instead of print. Print causes loads of overhead as it does both return and echo the data.
Secondly, don't put the variables within quotes, use
echo $header ."\n".$data;

To get to your question, does the foreach loops actually loop? Have you checked the $data if it contains any data?
A better solution might be this:
$header = '';
echo $header;

foreach() loop here {
    //echo the data here instead of putting it in a variable
}

Or maybe better, use http://nl.php.net/fputcsv

A: I tested your code and it seems that your trim() method is trimming your \n and \t.
If you remove it, your code should be fine.
Here's my code to export a array of product in excel.
Only one little problem with this code : Excel doesn't want to open it because of a format problem, but if you click "yes" when it promps an error message, you'll be ok...
No problem with open office though
Working on a fix...
$filename = "products_exports " . date("Y-m-d H_i_s") . ".xls";

/**
 * Tell the browser to download an excel file.
 */

header("Content-Type: application/x-msdownload; charset=utf-8");
header("Content-Disposition: attachment; filename=\"$filename\"");
header("Pragma: no-cache");
header("Expires: 0");

/**
 * The header of the table
 * @var string
 */
$header = "";
/**
 * All the data of the table in a formatted string
 * @var string
 */
$data = "";

//We fill in the header
foreach ($productArray as $i => $product) {
    $count = 0;
    foreach ($product as $key => $value) {

        if($count == count((array)new Product("")) - 1){
            $header.= $key;
        }
        else{
            $header.= $key . "\t";
            $count++;
        }
    }

    break; /*One loop is enough to get the header !*/
}

//And then the data by the product and all the categories

/*Where $productArray = This can be your custom array of object. eg.
  array[0] = new YouCustomObject(your params...);
*/
foreach ($productArray as $i => $product) {
    $count = 0;
    foreach ($product as $key => $value) {
        if($count == count((array)new Product("")) - 1){
            $value = str_replace('"', '""', $value);
            $value = '"' . $value . '"' . "\n";
            $data .= $value;
            $count = 0;
        }
        else{
            $value = str_replace('"', '""', $value);
            $value = '"' . $value . '"' . "\t";
            $data .= $value;
            $count++;
        }
    }
}

echo $header ."\n". $data;