NSF Funds dataset US dollar to Euro currency converter

Created: 2011-11-25 04:25:07 Last updated: 2011-11-25 04:29:42

Download Workflow

This workflow uses a 2012 Fiscal Year dataset from the National Science Foundation (NSF), a currency conversion web service from WebservicesX.NET and processes data using the workflow tool Taverna. It converts US dollars from a spreadsheet to Euros.

<o:p></o:p>

Preview

Download as scalable diagram (SVG)

Run

Run this Workflow in the Taverna Workbench...

Option 1:

Copy and paste this link into File > 'Open workflow location...'
http://www.myexperiment.org/workflows/2581/download?version=1
[ More Info Expand ]

Workflow Components

Authors (0)

Titles (0)

Descriptions (0)

Dependencies (0)

Inputs (0)

Processors (25)

Name	Type	Description
ConversionRate	wsdl	Wsdl http://www.webservicex.net/CurrencyConvertor.asmx?WSDL Wsdl Operation ConversionRate
ConversionRate_input	xmlsplitter
ConversionRate_output	xmlsplitter
USDollars	stringconstant	Value USD
Euros	stringconstant	Value EUR
SpreadsheetImport	spreadsheet
NSF_Funding_by_Account	stringconstant	Value http://www.nsf.gov/about/budget/fy2012/tables/overview_01.xlsx
Multiplication_Omnibus	beanshell	Script Float MultiplicationResult = 0; try{ MultiplicationResult = Float.valueOf(Column) * Float.valueOf(ConversionRate); } catch ( Exception e){ }
Concatenate_Value_and_Unit_Omnibus	localworker	Script output = string1 + string2;
EuroLabel	stringconstant	Value Euros in Millions
Concatenate_strings_for_result_Omnibus	localworker	Script output = string1 + string2;
Concatenate_Label_and_Equals	localworker	Script output = string1 + string2;
Equals	stringconstant	Value =
Multiplication_ARRA	beanshell	Script Float MultiplicationResult = 0; try{ MultiplicationResult = Float.valueOf(Column) * Float.valueOf(ConversionRate); } catch ( Exception e){ }
Concatenate_Value_and_Unit_ARRA	localworker	Script output = string1 + string2;
Concatenate_strings_for_result_ARRA	localworker	Script output = string1 + string2;
Multiplication_FY2011	beanshell	Script Float MultiplicationResult = 0; try{ MultiplicationResult = Float.valueOf(Column) * Float.valueOf(ConversionRate); } catch ( Exception e){ }
Concatenate_Value_and_Unit_FY2011	localworker	Script output = string1 + string2;
Concatenate_strings_for_result_FY2011	localworker	Script output = string1 + string2;
Multiplication_2012Request	beanshell	Script Float MultiplicationResult = 0; try{ MultiplicationResult = Float.valueOf(Column) * Float.valueOf(ConversionRate); } catch ( Exception e){ }
Concatenate_Value_and_Unit_2012Request	localworker	Script output = string1 + string2;
Concatenate_strings_for_result_2012Request	localworker	Script output = string1 + string2;
Multiplication_2010EnactedAmount	beanshell	Script Float MultiplicationResult = 0; try{ MultiplicationResult = Float.valueOf(Column) * Float.valueOf(ConversionRate); } catch ( Exception e){ }
Concatenate_Value_and_Unit_2010EnactedAmount	localworker	Script output = string1 + string2;
Concatenate_strings_for_result_2010EnactedAmount	localworker	Script output = string1 + string2;

Beanshells (5)

Name	Inputs	Outputs
Multiplication_Omnibus	ConversionRate Column	MultiplicationResult
Multiplication_ARRA	ConversionRate Column	MultiplicationResult
Multiplication_FY2011	ConversionRate Column	MultiplicationResult
Multiplication_2012Request	ConversionRate Column	MultiplicationResult
Multiplication_2010EnactedAmount	ConversionRate Column	MultiplicationResult

Outputs (5)

Name	Description
FY_2010_Omnibus_Actual
FY_2010_ARRA_Actual
FY_2010_Enacted_and_Annualized_FY_2011_CR
FY_2012_Request
Change_Over_FY_2010_Enacted_Amount

Datalinks (42)

Source	Sink
ConversionRate_input:output	ConversionRate:parameters
Euros:value	ConversionRate_input:ToCurrency
USDollars:value	ConversionRate_input:FromCurrency
ConversionRate:parameters	ConversionRate_output:input
NSF_Funding_by_Account:value	SpreadsheetImport:fileurl
ConversionRate_output:ConversionRateResult	Multiplication_Omnibus:ConversionRate
SpreadsheetImport:FY 2010 Omnibus Actual	Multiplication_Omnibus:Column
Multiplication_Omnibus:MultiplicationResult	Concatenate_Value_and_Unit_Omnibus:string1
EuroLabel:value	Concatenate_Value_and_Unit_Omnibus:string2
Concatenate_Value_and_Unit_Omnibus:output	Concatenate_strings_for_result_Omnibus:string2
Concatenate_Label_and_Equals:output	Concatenate_strings_for_result_Omnibus:string1
SpreadsheetImport:Label	Concatenate_Label_and_Equals:string1
Equals:value	Concatenate_Label_and_Equals:string2
SpreadsheetImport:FY 2010 ARRA Actual	Multiplication_ARRA:Column
ConversionRate_output:ConversionRateResult	Multiplication_ARRA:ConversionRate
Multiplication_ARRA:MultiplicationResult	Concatenate_Value_and_Unit_ARRA:string1
EuroLabel:value	Concatenate_Value_and_Unit_ARRA:string2
Concatenate_Value_and_Unit_ARRA:output	Concatenate_strings_for_result_ARRA:string2
Concatenate_Label_and_Equals:output	Concatenate_strings_for_result_ARRA:string1
SpreadsheetImport:FY 2010 Enacted/ Annualized FY 2011 CR2	Multiplication_FY2011:Column
ConversionRate_output:ConversionRateResult	Multiplication_FY2011:ConversionRate
Multiplication_FY2011:MultiplicationResult	Concatenate_Value_and_Unit_FY2011:string1
EuroLabel:value	Concatenate_Value_and_Unit_FY2011:string2
Concatenate_Label_and_Equals:output	Concatenate_strings_for_result_FY2011:string1
Concatenate_Value_and_Unit_FY2011:output	Concatenate_strings_for_result_FY2011:string2
SpreadsheetImport:FY 2012 Request	Multiplication_2012Request:Column
ConversionRate_output:ConversionRateResult	Multiplication_2012Request:ConversionRate
Multiplication_2012Request:MultiplicationResult	Concatenate_Value_and_Unit_2012Request:string1
EuroLabel:value	Concatenate_Value_and_Unit_2012Request:string2
Concatenate_Label_and_Equals:output	Concatenate_strings_for_result_2012Request:string1
Concatenate_Value_and_Unit_2012Request:output	Concatenate_strings_for_result_2012Request:string2
SpreadsheetImport:Change Over FY 2010 Enacted Amount	Multiplication_2010EnactedAmount:Column
ConversionRate_output:ConversionRateResult	Multiplication_2010EnactedAmount:ConversionRate
Multiplication_2010EnactedAmount:MultiplicationResult	Concatenate_Value_and_Unit_2010EnactedAmount:string1
EuroLabel:value	Concatenate_Value_and_Unit_2010EnactedAmount:string2
Concatenate_Label_and_Equals:output	Concatenate_strings_for_result_2010EnactedAmount:string1
Concatenate_Value_and_Unit_2010EnactedAmount:output	Concatenate_strings_for_result_2010EnactedAmount:string2
Concatenate_strings_for_result_Omnibus:output	FY_2010_Omnibus_Actual
Concatenate_strings_for_result_ARRA:output	FY_2010_ARRA_Actual
Concatenate_strings_for_result_FY2011:output	FY_2010_Enacted_and_Annualized_FY_2011_CR
Concatenate_strings_for_result_2012Request:output	FY_2012_Request
Concatenate_strings_for_result_2010EnactedAmount:output	Change_Over_FY_2010_Enacted_Amount