{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Start Here","Inputs","Daily","DataViewer","Summary","Precip","Raw","Temperature","Export"],"not_rendered":{"charts":7,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Start Here","index":0,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[25,10,29,10],[25,6,29,6],[1,1,3,11],[5,1,7,11],[25,8,29,8],[25,2,29,4]]}
[]
[null,"WEPP Breakpoint Climate Data Generator\nVersion 2.0"]
[]
[]
[]
[null,"Created by Joseph Trotochaud\nNational Soil Erosion Research Laboratory\nPurdue University - Department of Agricultural and Biological Engineering"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Trims data to a designated time period, fills in gaps, and generates DataViewer.",null,null,null,"Builds Breakpoint File based on numbers in DataViewer Sheet.",null,"Supplemental macro which creates daily average data from sub-daily values.",null,"Clears all sheets and returns original data to Inputs Sheet."]

{"sheet":"Inputs","index":1,"n_rows":2,"n_cols":29,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,22,23,22]]}
[null,"Date/Time","Precipitation",null,"Date/Time","Maximum\n Temperature",null,"Date/Time","Minimum \nTemperature",null,"Date/Time","Solar \nRadiation",null,"Date/Time","Wind \nSpeed",null,"Date/Time","Wind \nDirection",null,"Date/Time","Dew Point \nTemperature",null,null,null,"Date/Time","Air \nTemperature",null,"Date/Time","Relative \nHumidity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\\/    SUPPLIMENTAL DATA    \\/"]

{"sheet":"Daily","index":2,"n_rows":1,"n_cols":2,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Date/Time","Variable"]

{"sheet":"DataViewer","index":3,"n_rows":34,"n_cols":14,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,6,4,12],[1,1,4,5],[1,13,4,17],[11,1,11,2],[12,1,12,2],[14,1,15,5],[13,1,13,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2]]}
[]
[null,"Data Viewer",null,null,null,null,"This sheet contains graphical outputs of the data that will be used to write the Breakpoint file. After reviewing the graphs, make any changes necessary to the data to the right of the graphs and press \"Build Breakpoint File\" below or on the \"Start Here\" sheet.",null,null,null,null,null,null,"Data to modify ------->"]
[]
[]
[]
[]
[null,"Summary Chart*",null,"Min","Mean","Max"]
[null,"Precipitation",null,{"$f":"MIN(W:W)","v":0},{"$f":"AVERAGE(W:W)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(W:W)","v":0}]
[null,"Maximum Temp.",null,{"$f":"MIN(AC:AC)","v":0},{"$f":"AVERAGE(AC:AC)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AC:AC)","v":0}]
[null,"Minimum Temp.",null,{"$f":"MIN(Z:Z)","v":0},{"$f":"AVERAGE(Z:Z)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(Z:Z)","v":0}]
[null,"Dew Point Temp.",null,{"$f":"MIN(AO:AO)","v":0},{"$f":"AVERAGE(AO:AO)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AO:AO)","v":0}]
[null,"Wind Speed",null,{"$f":"MIN(AI:AI)","v":0},{"$f":"AVERAGE(AI:AI)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AI:AI)","v":0}]
[null,"Solar Radiation",null,{"$f":"MIN(AL:AL)","v":0},{"$f":"AVERAGE(AL:AL)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AL:AL)","v":0}]
[null,"Wind Direction",null,{"$f":"MIN(AF:AF)","v":0},{"$f":"AVERAGE(AF:AF)","v":{"$error":"#DIV/0!"}},{"$f":"MAX(AF:AF)","v":0}]
[null,"*Represent single largest and smallest datapoints, and mean for all datapoints in period."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Each point corresponds to the amount of rainfall within a 10 minute period. Tails only connect the end of one storm to the beginning of the next and have no physical meaning."]
[]
[]
[null,"Each point corresponds to the amount of rainfall within a 10 minute period. Tails only connect the end of one storm to the beginning of the next and have no physical meaning."]

{"sheet":"Summary","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Precip","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Raw","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Temperature","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Export","index":8,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}