US_Consumption_of_Plant_NutrientsgraphSpreadsheetImportfileurl0phosphate11nitrogen11other11other_industry11potash11year11 Imports the supplied Excel file. 2011-09-21 02:02:30.958 EDT net.sf.taverna.t2.activitiesspreadsheet-import-activity1.3net.sf.taverna.t2.activities.spreadsheet.SpreadsheetImportActivity 1 6 6 41 D other E nitrogen F other_industry G potash A over B year C phosphate L 2001 N 2002 H 1999 J 2000 T 2005 V 2006 P 2003 R 2004 X 2007 Z 2008 false false false EMPTY_STRING PORT_PER_COLUMN , net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeGenerateGraphURLdata2headers1years1graphURL00 Generates a URL (Google Charts format). 2011-09-21 02:01:50.266 EDT net.sf.taverna.t2.activitiesbeanshell-activity1.3net.sf.taverna.t2.activities.beanshell.BeanshellActivity title 0 text/plain java.lang.String true data 2 text/plain java.lang.String true headers 1 text/plain java.lang.String true years 1 text/plain java.lang.String true graphURL 0 0 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeGet_Image_From_URLurl0image00 Retrieves chart output from Google in an image format to be displated in Taverna. 2011-09-21 02:02:14.388 EDT net.sf.taverna.t2.activitieslocalworker-activity1.3net.sf.taverna.t2.activities.localworker.LocalworkerActivity url 0 'text/x-taverna-web-url' java.lang.String true base 0 'text/x-taverna-web-url' java.lang.String true image 0 'image/*' 0 workflow org.embl.ebi.escience.scuflworkers.java.WebImageFetcher net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeBeanshellyear1phosphate1nitrogen1potash1data22headers11years11 This Beanshell script takes the values from SpreadsheetImport and prepares them to be passed to the Google Chart URL creator in the next step. 2011-09-21 02:01:28.389 EDT net.sf.taverna.t2.activitiesbeanshell-activity1.3net.sf.taverna.t2.activities.beanshell.BeanshellActivity year 1 text/plain java.lang.String true phosphate 1 text/plain java.lang.String true nitrogen 1 text/plain java.lang.String true potash 1 text/plain java.lang.String true data 2 2 headers 1 1 years 1 1 workflow net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Invokeurl_valuevalue00 URL file supplied for the user is an Excel file, or .xls. 2011-09-21 02:02:51.71 EDT net.sf.taverna.t2.activitiesstringconstant-activity1.3net.sf.taverna.t2.activities.stringconstant.StringConstantActivity http://www.myexperiment.org/files/568/download/FertilizerUse.xls net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Parallelize 1 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.ErrorBouncenet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Failovernet.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.Retry 1.0 1000 5000 0 net.sf.taverna.t2.coreworkflowmodel-impl1.3net.sf.taverna.t2.workflowmodel.processor.dispatch.layers.InvokeSpreadsheetImportfileurlurl_valuevalueGenerateGraphURLdataBeanshelldataGenerateGraphURLheadersBeanshellheadersGenerateGraphURLyearsBeanshellyearsGet_Image_From_URLurlGenerateGraphURLgraphURLBeanshellyearSpreadsheetImportyearBeanshellphosphateSpreadsheetImportphosphateBeanshellnitrogenSpreadsheetImportnitrogenBeanshellpotashSpreadsheetImportpotashgraphGet_Image_From_URLimage 99c992df-d200-4cda-a973-c60be723e784 2010-07-07 12:14:16.5 EDT dfa2cd09-f53d-47f4-91cd-207ec2dc2c34 2010-07-07 11:51:22.4 EDT 2b4081cb-db1e-48ea-9fe4-4ab7340e54a0 2011-09-21 01:59:35.454 EDT 70c23010-0b47-424e-a1ce-73c040c3d3c6 2010-07-07 11:43:47.690 EDT 486a5356-0f3e-424d-b14e-249295875f2d 2010-07-13 07:31:34.664 EDT 58b3ac31-cfb3-418a-85ae-1990b2883c35 2010-07-07 17:57:04.585 EDT Kayleigh Ayn Bohémier 2011-09-21 01:59:25.196 EDT cca71cbe-6d97-4896-90c2-d91016f12882 2010-07-07 17:45:31.148 EDT 27965b7c-1a89-46ac-8c9b-a4c6bf9144f0 2010-07-13 06:22:36.27 EDT 99e82825-40e1-4fa9-8cf4-5348a8ff7b82 2010-07-07 17:38:24.439 EDT 6d9b5609-37c3-4fb1-9eea-e6b70209427e 2010-07-07 09:05:03.421 EDT e263e793-b394-4a57-855e-13e69b8780c2 2010-07-07 12:00:11.782 EDT 64b51b72-af09-4842-b034-293dee7a03ff 2010-07-07 17:40:56.858 EDT 6c2a0ecf-5d91-4722-adf6-607c912ed54c 2010-07-07 11:54:20.460 EDT d8b96d03-8431-4cc0-b032-51e0c32092d3 2010-07-07 12:27:09.166 EDT US Consumption of Plant Nutrients 2011-09-21 01:59:16.741 EDT b4363407-ef56-4cf3-998f-8e780a8dc816 2010-07-07 11:41:31.230 EDT 14724df6-fee6-4b24-8fbc-eeeeb3dc4e61 2010-07-07 11:38:21.137 EDT 41265789-c464-4ee2-b145-95ece9388305 2010-07-07 17:34:29.364 EDT 6f16e5e6-7e90-44af-9e7a-f63785e5408e 2010-07-07 17:53:58.943 EDT 47de0484-f703-40ab-b1f7-b0826495a00d 2010-07-07 18:09:23.782 EDT 846fe49f-d38f-4a35-9623-ce685d43c50d 2011-09-20 23:56:04.112 EDT ed6b9485-f62c-4f37-a068-ad7e8b62f9f0 2011-09-21 02:02:52.617 EDT 7ca4b117-111d-4605-826e-868d7d159b52 2010-07-13 06:16:32.697 EDT cf60043b-e08a-49d7-a150-711f413d3d18 2010-07-07 17:52:10.583 EDT cee35c36-afaf-4093-bcc5-eaac292207f5 2010-07-07 11:02:30.469 EDT 812e7abc-4866-43dc-b9d4-44370a399e4e 2010-07-07 12:23:44.739 EDT 73ce4e99-6b83-45d0-8605-896d6d48b7f0 2010-07-07 12:01:14.713 EDT a5bbe32f-ad20-4411-bc0e-d8f693e95493 2010-07-07 17:55:54.366 EDT 58a4da02-d1f0-41ce-9ace-8a62b49b62d7 2010-07-13 06:22:26.72 EDT d533c230-a40d-4f9b-9ad4-f4389d4a6f1f 2010-07-07 11:00:00.482 EDT This workflow takes data from the ERS, TVA (Tennessee Valley Authority), AAPFCO (Association of American Plant Food Control Officials), and the TFI (The Fertilizer Institute) and represents them in a bar chart. 2011-09-21 01:59:05.412 EDT f0fe1955-23d6-41b7-b1af-b36d641429b4 2010-07-07 12:24:52.98 EDT 2c1532f6-0ba4-48ea-9bf4-3fd3e39c6289 2010-07-07 09:00:56.585 EDT e28f14b3-e4ae-4d0b-893d-3a8400625069 2010-07-07 11:10:13.994 EDT 31ac21d6-7c10-48ff-b9b2-82cac03f55c9 2010-07-07 17:43:05.458 EDT 6e069c36-8d88-4017-96cf-c1fa87007777 2010-07-07 11:20:48.694 EDT 9c2e4b9c-5f25-4416-8653-cd9198a9271e 2010-07-13 06:19:30.143 EDT a752e401-77c5-42ef-9bf8-a60aa8af73f5 2010-07-07 17:50:42.557 EDT 92d8fa84-2553-4de1-bff5-7d2a9b53c58d 2010-07-07 12:31:19.499 EDT 7d1166bd-dfa5-4675-918c-a880314302cb 2010-07-07 11:04:08.606 EDT 808e3725-2a08-4907-9706-fb7f0f08f62f 2010-07-13 06:20:05.749 EDT c0753ab7-cd9d-400e-b483-048dcbaad5f9 2010-07-07 11:36:44.391 EDT 30c2f2c6-dbd5-4e7a-9620-f6e8526fb9bc 2010-07-07 18:04:59.33 EDT 4462bd43-bcec-4aaf-83e5-64e111668a64 2010-07-07 18:00:20.619 EDT 8af7971d-f944-4f27-b62a-437be1b99d3c 2010-07-07 11:07:29.140 EDT 9a2e5f63-ee29-42f3-810e-dc54fa9dfe3c 2010-07-07 11:59:16.81 EDT 464013e1-0699-4e1a-bac7-047576261b33 2010-07-07 18:07:59.655 EDT 980d729b-1ec7-492c-9dfd-ccb19f9e81a7 2010-07-07 17:59:09.755 EDT 23eec6e0-9a32-461c-bd90-ba03bdc49d41 2010-07-07 12:25:28.613 EDT 6622310c-9440-45a1-a051-729487b00b46 2010-07-13 07:32:33.863 EDT