{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Main Menu","View Sheet","Calc Sheet","12 month view","12 month Calc Sheet","Sheet1"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":18,"comments":2,"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":"Main Menu","index":0,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[[13,11,15,17],[17,11,22,17],[5,11,11,17]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"The Cost Share Calculator provides estimated percents and dollar amounts for cost sharing by FEC cycle. Both percents and dollars will be prorated for partial cycles.  Note: the percents and dollar amounts may not match exactly the calculations from the Cost Share Module but should be fairly close if the same fringe benefit rates and F&A rates are used."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Attach a copy of the calculator results to the GC1 Addendum to assist GCA in entering the pledge."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"BEFORE YOU START:                                                                  1. The security warning may prompt you to \"enable content.\"        2. Download the calculator first to your computer and then turn on the Excel Toolpak. This will ensure that the Toolpak activates and provides the correct calculations. "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Need some help?  Check out these links for further assistance:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"http://f2.washington.edu/fm/maa/sites/default/files/fec/excel-toolpak.doc\",\"Instructions for Turning on the Excel Toolpak\")","v":"Instructions for Turning on the Excel Toolpak"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"http://f2.washington.edu/fm/maa/sites/default/files/fec/costshare-calculator-inst.doc\",\"Instructions for Using the Cost Share Calculator\")","v":"Instructions for Using the Cost Share Calculator"}]
[]
[null,null,"For help using the FEC Calculator",null,null,null,null,null,null,null,null,{"$f":"HYPERLINK(\"http://f2.washington.edu/fm/maa/fec\",\"MAA FEC webpage\")","v":"MAA FEC webpage"}]
[null,null,"contact eFECS at:"]
[null,null,null,null,"efecs@u.washington.edu"]

{"sheet":"View Sheet","index":1,"n_rows":53,"n_cols":40,"rows_kept":53,"cut":false,"hidden":false,"merged":[[31,0,34,0],[35,0,38,0],[1,3,1,5],[2,3,2,5],[15,0,18,0],[19,0,22,0],[23,0,26,0],[27,0,30,0]]}
[null,null,"Academic FEC Calculator"]
["Faculty Name (Last, Mid., First)"]
["Faculty EID"]
["eGC-1 or Budget Number (no dashes or punctuation)"]
["Type of Cost Sharing"]
["Cost Sharing Start Date"]
["Cost Sharing End Date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Validation",null,{"$f":"DATE(YEAR(F6)+5,MONTH(F6),DAY(EOMONTH(DATE(RIGHT(TEXT(F6,\"mm/dd/yyyy\"),4),MONTH(F6),DAY(F6)),1)))","v":"1905-01-28"}]
["Monthly Effort Pledge",null,null,null,"Person-Months Conversion Chart"]
["Monthly IBS (not full time rate)",null,null,null,{"$f":"HYPERLINK(\"http://www.washington.edu/research/osp/gim/gim35.html\",\"IBS components - GIM 35\")","v":"IBS components - GIM 35"}]
["Current Benefit Rate",null,null,null,{"$f":"HYPERLINK(\"http://www.washington.edu/research/osp/gim/gim3.html\",\"Current rates - GIM 3\")","v":"Current rates - GIM 3"}]
["Cost Share F&A Rate",null,null,null,{"$f":"HYPERLINK(\"http://www.washington.edu/research/osp/gim/gim13a.html\",\"Current Rates - GIM 13\")","v":"Current Rates - GIM 13"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Start","End","Start","End","Start","End"]
[null,"Exclude\nQtr?","Qtr","Start Date","End Date","CSM\nEffort %","Commited Salary","Benefits","Associated F&A","CSM $",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K","L","M","N","O","O","P","P","Q","Q","S"]
[{"$f":"'Calc Sheet'!A9","v":""},null,{"$f":"IF($B16=\"X\",\"\",INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AD16)))","v":""},"","",{"$f":"IF($B16=\"X\",\"::\",INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AG16)))","v":"::"},{"$f":"IF($B16=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AH16,\":\",AI16))))","v":0},{"$f":"IF($B16=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AJ16,\":\",AK16))))","v":0},{"$f":"IF($B16=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AL16,\":\",AM16))))","v":0},{"$f":"IF($B16=\"X\",\"::\",INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AN16)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,{"$f":"AD$15&$AC16","v":"K13"},"L13","M13","N13",{"$f":"AH$15&($AC16-4)","v":"O9"},"O13",{"$f":"AJ$15&($AC16-4)","v":"P9"},"P13",{"$f":"AL$15&($AC16-4)","v":"Q9"},"Q13","S13"]
[null,null,"","","",{"$f":"IF($B17=\"X\",\"::\",INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AG17)))","v":"::"},{"$f":"IF($B17=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AH17,\":\",AI17))))","v":0},{"$f":"IF($B17=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AJ17,\":\",AK17))))","v":0},{"$f":"IF($B17=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AL17,\":\",AM17))))","v":0},{"$f":"IF($B17=\"X\",\"::\",INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AN17)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC16+6","v":19},"K19","L19","M19","N19",{"$f":"AH$15&($AC17-5)","v":"O14"},"O19",{"$f":"AJ$15&($AC17-5)","v":"P14"},"P19",{"$f":"AL$15&($AC17-5)","v":"Q14"},"Q19","S19"]
[null,null,"","","",{"$f":"IF($B18=\"X\",\"::\",INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AG18)))","v":"::"},{"$f":"IF($B18=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AH18,\":\",AI18))))","v":0},{"$f":"IF($B18=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AJ18,\":\",AK18))))","v":0},{"$f":"IF($B18=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AL18,\":\",AM18))))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC17+6","v":25},"K25","L25","M25","N25",{"$f":"AH$15&($AC18-5)","v":"O20"},"O25",{"$f":"AJ$15&($AC18-5)","v":"P20"},"P25",{"$f":"AL$15&($AC18-5)","v":"Q20"},"Q25","S25"]
[null,null,"","","",{"$f":"IF($B19=\"X\",\"::\",INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AG19)))","v":"::"},{"$f":"IF($B19=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AH19,\":\",AI19))))","v":0},{"$f":"IF($B19=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AJ19,\":\",AK19))))","v":0},{"$f":"IF($B19=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AL19,\":\",AM19))))","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31,"K31","L31","M31","N31","O26","O31","P26","P31","Q26","Q31","S31"]
[{"$f":"'Calc Sheet'!A33","v":""},null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,"K37","L37","M37","N37","O32","O37","P32","P37","Q32","Q37","S37"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43,"K43","L43","M43","N43","O38","O43","P38","P43","Q38","Q43","S43"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49,"K49","L49","M49","N49","O44","O49","P44","P49","Q44","Q49","S49"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55,"K55","L55","M55","N55","O50","O55","P50","P55","Q50","Q55","S55"]
[{"$f":"'Calc Sheet'!A57","v":""},null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61,"K61","L61","M61","N61","O56","O61","P56","P61","Q56","Q61","S61"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,67,"K67","L67","M67","N67","O62","O67","P62","P67","Q62","Q67","S67"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,73,"K73","L73","M73","N73","O68","O73","P68","P73","Q68","Q73","S73"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,79,"K79","L79","M79","N79","O74","O79","P74","P79","Q74","Q79","S79"]
[{"$f":"'Calc Sheet'!A81","v":""},null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,85,"K85","L85","M85","N85","O80","O85","P80","P85","Q80","Q85","S85"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,91,"K91","L91","M91","N91","O86","O91","P86","P91","Q86","Q91","S91"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,97,"K97","L97","M97","N97","O92","O97","P92","P97","Q92","Q97","S97"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,103,"K103","L103","M103","N103","O98","O103","P98","P103","Q98","Q103","S103"]
[{"$f":"'Calc Sheet'!A105","v":""},null,{"$f":"IF($B32=\"X\",\"\",INDIRECT(CONCATENATE(\"'Calc Sheet'!\",AD32)))","v":""},"","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,109,"K109","L109","M109","N109","O104","O109","P104","P109","Q104","Q109","S109"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,115,{"$f":"AD$15&$AC33","v":"K115"},"L115","M115","N115","O110",{"$f":"AI$15&$AC33","v":"O115"},"P110","P115","Q110","Q115","S115"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,121,"K121","L121","M121","N121","O116","O121","P116","P121","Q116","Q121","S121"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,127,"K127","L127","M127","N127","O122","O127","P122","P127","Q122","Q127","S127"]
[{"$f":"'Calc Sheet'!A129","v":""},null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,133,"K133","L133","M133","N133","O128","O133","P128","P133","Q128","Q133","S133"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,139,"K139","L139","M139","N139","O134","O139","P134","P139","Q134","Q139","S139"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,145,"K145","L145","M145","N145","O140","O145","P140","P145","Q140","Q145","S145"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,151,"K151","L151","M151","N151","O146","O151","P146","P151","Q146","Q151","S151"]
[null,null,null,null,null,null,{"$f":"SUM(G16:G39)","v":0},{"$f":"SUM(H16:H39)","v":0},{"$f":"SUM(I16:I39)","v":0},{"$f":"SUM(J16:J39)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M","Mandatory"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R","Committed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A","Aggregate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S","Shift in Funding Source"]

{"sheet":"Calc Sheet","index":2,"n_rows":154,"n_cols":20,"rows_kept":154,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BUDGET Start Date",null,null,null,null,{"$f":"'View Sheet'!F6","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"BUDGET End Date",null,null,null,null,{"$f":"'View Sheet'!F7","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Effort Pledge",null,null,null,null,{"$f":"'View Sheet'!F8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly IBS",null,null,null,null,{"$f":"'View Sheet'!F9","v":0}]
[null,null,null,null,null,null,{"$f":"IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+366=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+366))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,"Acct Code Benefit Rate",null,null,null,null,{"$f":"'View Sheet'!F10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable F&A Rate",null,null,null,null,{"$f":"'View Sheet'!F11","v":0}]
[]
[null,"Qtr","Pay Prd","PP_StartMonth","PP_StartDay","PP_EndMonth","PP_EndDay","PP_Start","PP_End","Percent per Pay Period","Qtr","Qtr\nStart Date","Qtr\nEnd Date","BGT %","Salary","Benefits","F&A Rate","Subtotal","BGT $","Year Factor"]
[{"$f":"IF($S$1=0,\"\",YEAR(TEXT($S$1,\"mm/dd/yyyy\")))","v":""},"WI",1,1,1,{"$f":"D9","v":1},15,{"$f":"IF(AND(DATE(A9,D9,E9)<=$S$1,DATE(A9,F9,G9)>=$S$1),$S$1,IF(OR(DATE(A9,D9,E9)<$S$1,DATE(A9,D9,E9)>$S$2),\"\",(DATE(A9,D9,E9))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A9,D9,E9)<=$S$2,DATE(A9,F9,G9)>=$S$2),$S$2,IF(OR(DATE(A9,F9,G9)<$S$1,DATE(A9,D9,E9)>$S$2),\"\",DATE(A9,F9,G9)))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(ISNUMBER(H9),ISNUMBER(I9)),$S$3/2,\"\")","v":""},null,null,null,null,{"$f":"IF(ISNUMBER(J9),ROUND($S$4*J9,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J9),ROUND(O9*S$5,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J9),ROUND((O9+P9)*$S$6,2),\"\")","v":""},{"$f":"IF(ISNUMBER(SUM(O9:Q9)),SUM(O9:Q9),\"\")","v":0}]
[{"$f":"A9","v":""},"WI",2,{"$f":"IF(D9=D8,D9+1,D9)","v":1},{"$f":"IF(G8>15,E9+G9,1)","v":16},1,{"$f":"DAY(EOMONTH(DATE(RIGHT(TEXT($S$1,\"mm/dd/yyyy\"),4),D10,E10),0.5))","v":31},{"$f":"IF(AND(DATE(A10,D10,E10)<=$S$1,DATE(A10,F10,G10)>=$S$1),$S$1,IF(OR(DATE(A10,D10,E10)<$S$1,DATE(A10,D10,E10)>$S$2),\"\",(DATE(A10,D10,E10))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A10,D10,E10)<=$S$2,DATE(A10,F10,G10)>=$S$2),$S$2,IF(OR(DATE(A10,F10,G10)<$S$1,DATE(A10,D10,E10)>$S$2),\"\",DATE(A10,F10,G10)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A10","v":""},"WI",3,2,1,2,{"$f":"IF(F11<>F10,15,DAY(EOMONTH(DATE(RIGHT(TEXT($S$1,\"mm/dd/yyyy\"),4),D11,E11),0.5)))","v":15},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","WI",4,2,16,2,{"$f":"IF(F12<>F11,15,DAY(EOMONTH(DATE(RIGHT(TEXT($S$1,\"mm/dd/yyyy\"),4),D12,E12),0.5)))","v":28},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","WI",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J8:J13)>0,B13&\" '\"&RIGHT(A13,2),\"\")","v":""},{"$f":"IF(SUM(J9:J13)>0,TEXT(DATE(YEAR(TEXT($S$1-30,\"mm/dd/yyyy\")),D32,E32),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J9:J13)>0,TEXT(DATE(RIGHT(A13,2),F13,G13),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K13=\"\",\"::\",ROUND(SUM(J9:J13)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R9:R13),0)","v":0}]
["","SP",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J14:J19)>0,B19&\" '\"&RIGHT(A19,2),\"\")","v":""},{"$f":"IF(SUM(J14:J19)>0,TEXT(DATE(RIGHT(A19,2),D14,E14),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J14:J19)>0,TEXT(DATE(RIGHT(A19,2),F19,G19),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K19=\"\",\"::\",ROUND(SUM(J14:J19)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R14:R19),0)","v":0}]
["","SU",12,6,16,6,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",{"$f":"SUM(O21:Q21)","v":0}]
["","SU",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J20:J25)>0,B25&\" '\"&RIGHT(A25,2),\"\")","v":""},{"$f":"IF(SUM(J20:J25)>0,TEXT(DATE(RIGHT(A25,2),D20,E20),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J20:J25)>0,TEXT(DATE(RIGHT(A25,2),F25,G25),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K25=\"\",\"::\",ROUND(SUM(J20:J25)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R20:R25),0)","v":0}]
["","AU",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,{"$f":"IF(ISNUMBER(J27),ROUND($S$4*J27,2),\"\")","v":""},"","",0]
["","AU",20,10,16,10,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(OR(ISNUMBER(H31),ISNUMBER(I31)),$S$3/2,\"\")","v":""},{"$f":"IF(SUM(J26:J31)>0,B31&\" '\"&RIGHT(A31,2),\"\")","v":""},{"$f":"IF(SUM(J26:J31)>0,TEXT(DATE(RIGHT(A31,2),D26,E26),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J26:J31)>0,TEXT(DATE(RIGHT(A31,2),F31,G31),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K31=\"\",\"::\",ROUND(SUM(J26:J31)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R26:R31),0)","v":0}]
["","WI",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(OR(ISNUMBER(H32),ISNUMBER(I32)),$S$3/2,\"\")","v":""},null,null,null,null,"","","",0]
[{"$f":"IF($S$2=0,\"\",IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+366=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+366)))","v":""},"WI",1,1,1,1,15,{"$f":"IF(AND(DATE(A33,D33,E33)<=$S$1,DATE(A33,F33,G33)>=$S$1),$S$1,IF(OR(DATE(A33,D33,E33)<$S$1,DATE(A33,D33,E33)>$S$2),\"\",(DATE(A33,D33,E33))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A33,D33,E33)<=$S$2,DATE(A33,F33,G33)>=$S$2),$S$2,IF(OR(DATE(A33,F33,G33)<$S$1,DATE(A33,D33,E33)>$S$2),\"\",DATE(A33,F33,G33)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0,null,1]
[{"$f":"A33","v":""},"WI",2,{"$f":"IF(D33=D32,D33+1,D33)","v":1},{"$f":"IF(G32>15,E33+G33,1)","v":16},1,31,{"$f":"IF(AND(DATE(A34,D34,E34)<=$S$1,DATE(A34,F34,G34)>=$S$1),$S$1,IF(OR(DATE(A34,D34,E34)<$S$1,DATE(A34,D34,E34)>$S$2),\"\",(DATE(A34,D34,E34))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A34,D34,E34)<=$S$2,DATE(A34,F34,G34)>=$S$2),$S$2,IF(OR(DATE(A34,F34,G34)<$S$1,DATE(A34,D34,E34)>$S$2),\"\",DATE(A34,F34,G34)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A34","v":""},"WI",3,2,1,2,15,{"$f":"IF(AND(DATE(A35,D35,E35)<=$S$1,DATE(A35,F35,G35)>=$S$1),$S$1,IF(OR(DATE(A35,D35,E35)<$S$1,DATE(A35,D35,E35)>$S$2),\"\",(DATE(A35,D35,E35))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A35,D35,E35)<=$S$2,DATE(A35,F35,G35)>=$S$2),$S$2,IF(OR(DATE(A35,F35,G35)<$S$1,DATE(A35,D35,E35)>$S$2),\"\",DATE(A35,F35,G35)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
["","WI",4,2,16,2,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","WI",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J32:J37)>0,B37&\" '\"&RIGHT(A37,2),\"\")","v":""},{"$f":"IF(SUM(J32:J37)>0,TEXT(DATE(RIGHT(A32,2),D32,E32),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J32:J37)>0,TEXT(DATE(RIGHT(A37,2),F37,G37),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K37=\"\",\"::\",ROUND(SUM(J32:J37)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R32:R37),0)","v":0}]
["","SP",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J38:J43)>0,B43&\" '\"&RIGHT(A43,2),\"\")","v":""},{"$f":"IF(SUM(J38:J43)>0,TEXT(DATE(RIGHT(A43),D38,E38),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J38:J43)>0,TEXT(DATE(RIGHT(A43,2),F43,G43),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K43=\"\",\"::\",ROUND(SUM(J38:J43)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R38:R43),0)","v":0}]
["","SU",12,6,16,6,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J44:J49)>0,B49&\" '\"&RIGHT(A49,2),\"\")","v":""},{"$f":"IF(SUM(J44:J49)>0,TEXT(DATE(RIGHT(A49,2),D44,E44),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J44:J49)>0,TEXT(DATE(RIGHT(A49,2),F49,G49),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K49=\"\",\"::\",ROUND(SUM(J44:J49)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R44:R49),0)","v":0}]
["","AU",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",20,10,16,10,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J50:J55)>0,B55&\" '\"&RIGHT(A55,2),\"\")","v":""},{"$f":"IF(SUM(J50:J55)>0,TEXT(DATE(RIGHT(A55,2),D50,E50),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J50:J55)>0,TEXT(DATE(RIGHT(A55,2),F55,G55),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K55=\"\",\"::\",ROUND(SUM(J50:J55)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R50:R55),0)","v":0}]
["","WI",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
[{"$f":"IF($S$2=0,\"\",IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+(T57*366)=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+(T57*366))))","v":""},"WI",1,1,1,1,15,{"$f":"IF(AND(DATE(A57,D57,E57)<=$S$1,DATE(A57,F57,G57)>=$S$1),$S$1,IF(OR(DATE(A57,D57,E57)<$S$1,DATE(A57,D57,E57)>$S$2),\"\",(DATE(A57,D57,E57))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A57,D57,E57)<=$S$2,DATE(A57,F57,G57)>=$S$2),$S$2,IF(OR(DATE(A57,F57,G57)<$S$1,DATE(A57,D57,E57)>$S$2),\"\",DATE(A57,F57,G57)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0,null,2]
[{"$f":"A57","v":""},"WI",2,{"$f":"IF(D57=D56,D57+1,D57)","v":1},{"$f":"IF(G56>15,E57+G57,1)","v":16},1,31,{"$f":"IF(AND(DATE(A58,D58,E58)<=$S$1,DATE(A58,F58,G58)>=$S$1),$S$1,IF(OR(DATE(A58,D58,E58)<$S$1,DATE(A58,D58,E58)>$S$2),\"\",(DATE(A58,D58,E58))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A58,D58,E58)<=$S$2,DATE(A58,F58,G58)>=$S$2),$S$2,IF(OR(DATE(A58,F58,G58)<$S$1,DATE(A58,D58,E58)>$S$2),\"\",DATE(A58,F58,G58)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A58","v":""},"WI",3,2,1,2,15,{"$f":"IF(AND(DATE(A59,D59,E59)<=$S$1,DATE(A59,F59,G59)>=$S$1),$S$1,IF(OR(DATE(A59,D59,E59)<$S$1,DATE(A59,D59,E59)>$S$2),\"\",(DATE(A59,D59,E59))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A59,D59,E59)<=$S$2,DATE(A59,F59,G59)>=$S$2),$S$2,IF(OR(DATE(A59,F59,G59)<$S$1,DATE(A59,D59,E59)>$S$2),\"\",DATE(A59,F59,G59)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
["","WI",4,2,16,2,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","WI",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J56:J61)>0,B61&\" '\"&RIGHT(A61,2),\"\")","v":""},{"$f":"IF(SUM(J56:J61)>0,TEXT(DATE(RIGHT(A56,2),D56,E56),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J56:J61)>0,TEXT(DATE(RIGHT(A61,2),F61,G61),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K61=\"\",\"::\",ROUND(SUM(J56:J61)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R56:R61),0)","v":0}]
["","SP",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J62:J67)>0,B67&\" '\"&RIGHT(A67,2),\"\")","v":""},{"$f":"IF(SUM(J62:J67)>0,TEXT(DATE(RIGHT(A67,2),D62,E62),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J62:J67)>0,TEXT(DATE(RIGHT(A67,2),F67,G67),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K67=\"\",\"::\",ROUND(SUM(J62:J67)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R62:R67),0)","v":0}]
["","SU",12,6,16,6,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",17,9,1,{"$f":"D73","v":9},15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J68:J73)>0,B73&\" '\"&RIGHT(A73,2),\"\")","v":""},{"$f":"IF(SUM(J68:J73)>0,TEXT(DATE(RIGHT(A73,2),D68,E68),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J68:J73)>0,TEXT(DATE(RIGHT(A73,2),F73,G73),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K73=\"\",\"::\",ROUND(SUM(J68:J73)/3,3))","v":"::"},{"$f":"IF(ISNUMBER(J73),ROUND($S$4*J73,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J73),ROUND(O73*S$5,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J73),ROUND((O73+P73)*$S$6,2),\"\")","v":""},0,{"$f":"ROUND(SUM(R68:R73),0)","v":0}]
["","AU",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",20,10,16,10,{"$f":"IF(F76<>F75,15,DAY(EOMONTH(DATE(RIGHT(TEXT($S$1,\"mm/dd/yyyy\"),4),D76,E76),0.5)))","v":31},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J74:J79)>0,B79&\" '\"&RIGHT(A79,2),\"\")","v":""},{"$f":"IF(SUM(J74:J79)>0,TEXT(DATE(RIGHT(A79,2),D74,E74),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J74:J79)>0,TEXT(DATE(RIGHT(A79,2),F79,G79),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K79=\"\",\"::\",ROUND(SUM(J74:J79)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R74:R79),0)","v":0}]
["","WI",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
[{"$f":"IF($S$2=0,\"\",IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+(T81*366)=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+(T81*366))))","v":""},"WI",1,1,1,1,15,{"$f":"IF(AND(DATE(A81,D81,E81)<=$S$1,DATE(A81,F81,G81)>=$S$1),$S$1,IF(OR(DATE(A81,D81,E81)<$S$1,DATE(A81,D81,E81)>$S$2),\"\",(DATE(A81,D81,E81))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A81,D81,E81)<=$S$2,DATE(A81,F81,G81)>=$S$2),$S$2,IF(OR(DATE(A81,F81,G81)<$S$1,DATE(A81,D81,E81)>$S$2),\"\",DATE(A81,F81,G81)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0,null,3]
[{"$f":"A81","v":""},"WI",2,{"$f":"IF(D81=D80,D81+1,D81)","v":1},{"$f":"IF(G80>15,E81+G81,1)","v":16},1,31,{"$f":"IF(AND(DATE(A82,D82,E82)<=$S$1,DATE(A82,F82,G82)>=$S$1),$S$1,IF(OR(DATE(A82,D82,E82)<$S$1,DATE(A82,D82,E82)>$S$2),\"\",(DATE(A82,D82,E82))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A82,D82,E82)<=$S$2,DATE(A82,F82,G82)>=$S$2),$S$2,IF(OR(DATE(A82,F82,G82)<$S$1,DATE(A82,D82,E82)>$S$2),\"\",DATE(A82,F82,G82)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A82","v":""},"WI",3,2,1,2,15,{"$f":"IF(AND(DATE(A83,D83,E83)<=$S$1,DATE(A83,F83,G83)>=$S$1),$S$1,IF(OR(DATE(A83,D83,E83)<$S$1,DATE(A83,D83,E83)>$S$2),\"\",(DATE(A83,D83,E83))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A83,D83,E83)<=$S$2,DATE(A83,F83,G83)>=$S$2),$S$2,IF(OR(DATE(A83,F83,G83)<$S$1,DATE(A83,D83,E83)>$S$2),\"\",DATE(A83,F83,G83)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
["","WI",4,2,16,2,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","WI",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J80:J85)>0,B85&\" '\"&RIGHT(A85,2),\"\")","v":""},{"$f":"IF(SUM(J80:J85)>0,TEXT(DATE(RIGHT(A80,2),D80,E80),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J80:J85)>0,TEXT(DATE(RIGHT(A85,2),F85,G85),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K85=\"\",\"::\",ROUND(SUM(J80:J85)/3,3))","v":"::"},"","","",{"$f":"SUM(O85:Q85)","v":0},{"$f":"ROUND(SUM(R80:R85),0)","v":0}]
["","SP",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J86:J91)>0,B91&\" '\"&RIGHT(A91,2),\"\")","v":""},{"$f":"IF(SUM(J86:J91)>0,TEXT(DATE(RIGHT(A91,2),D86,E86),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J86:J91)>0,TEXT(DATE(RIGHT(A91,2),F91,G91),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K91=\"\",\"::\",ROUND(SUM(J86:J91)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R86:R91),0)","v":0}]
["","SU",12,6,16,6,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(OR(ISNUMBER(H96),ISNUMBER(I96)),$S$3/2,\"\")","v":""},null,null,null,null,"","","",0]
["","SU",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J92:J97)>0,B97&\" '\"&RIGHT(A97,2),\"\")","v":""},{"$f":"IF(SUM(J92:J97)>0,TEXT(DATE(RIGHT(A97,2),D92,E92),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J92:J97)>0,TEXT(DATE(RIGHT(A97,2),F97,G97),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K97=\"\",\"::\",ROUND(SUM(J92:J97)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R92:R97),0)","v":0}]
["","AU",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",20,10,16,10,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J98:J103)>0,B103&\" '\"&RIGHT(A103,2),\"\")","v":""},{"$f":"IF(SUM(J98:J103)>0,TEXT(DATE(RIGHT(A103,2),D98,E98),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J98:J103)>0,TEXT(DATE(RIGHT(A103,2),F103,G103),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K103=\"\",\"::\",ROUND(SUM(J98:J103)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R98:R103),0)","v":0}]
["","WI",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
[{"$f":"IF($S$2=0,\"\",IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+(T105*366)=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+(T105*366))))","v":""},"WI",1,1,1,1,15,{"$f":"IF(AND(DATE(A105,D105,E105)<=$S$1,DATE(A105,F105,G105)>=$S$1),$S$1,IF(OR(DATE(A105,D105,E105)<$S$1,DATE(A105,D105,E105)>$S$2),\"\",(DATE(A105,D105,E105))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A105,D105,E105)<=$S$2,DATE(A105,F105,G105)>=$S$2),$S$2,IF(OR(DATE(A105,F105,G105)<$S$1,DATE(A105,D105,E105)>$S$2),\"\",DATE(A105,F105,G105)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0,null,4]
[{"$f":"A105","v":""},"WI",2,{"$f":"IF(D105=D104,D105+1,D105)","v":1},{"$f":"IF(G104>15,E105+G105,1)","v":16},1,31,{"$f":"IF(AND(DATE(A106,D106,E106)<=$S$1,DATE(A106,F106,G106)>=$S$1),$S$1,IF(OR(DATE(A106,D106,E106)<$S$1,DATE(A106,D106,E106)>$S$2),\"\",(DATE(A106,D106,E106))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A106,D106,E106)<=$S$2,DATE(A106,F106,G106)>=$S$2),$S$2,IF(OR(DATE(A106,F106,G106)<$S$1,DATE(A106,D106,E106)>$S$2),\"\",DATE(A106,F106,G106)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A106","v":""},"WI",3,2,1,2,15,{"$f":"IF(AND(DATE(A107,D107,E107)<=$S$1,DATE(A107,F107,G107)>=$S$1),$S$1,IF(OR(DATE(A107,D107,E107)<$S$1,DATE(A107,D107,E107)>$S$2),\"\",(DATE(A107,D107,E107))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A107,D107,E107)<=$S$2,DATE(A107,F107,G107)>=$S$2),$S$2,IF(OR(DATE(A107,F107,G107)<$S$1,DATE(A107,D107,E107)>$S$2),\"\",DATE(A107,F107,G107)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
["","WI",4,2,16,2,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","WI",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J104:J109)>0,B109&\" '\"&RIGHT(A109,2),\"\")","v":""},{"$f":"IF(SUM(J104:J109)>0,TEXT(DATE(RIGHT(A104,2),D104,E104),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J104:J109)>0,TEXT(DATE(RIGHT(A109,2),F109,G109),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K109=\"\",\"::\",ROUND(SUM(J104:J109)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R104:R109),0)","v":0}]
["","SP",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J110:J115)>0,B115&\" '\"&RIGHT(A115,2),\"\")","v":""},{"$f":"IF(SUM(J110:J115)>0,TEXT(DATE(RIGHT(A115,2),D110,E110),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J110:J115)>0,TEXT(DATE(RIGHT(A115,2),F115,G115),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K115=\"\",\"::\",ROUND(SUM(J110:J115)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R110:R115),0)","v":0}]
["","SU",12,6,16,6,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J116:J121)>0,B121&\" '\"&RIGHT(A121,2),\"\")","v":""},{"$f":"IF(SUM(J116:J121)>0,TEXT(DATE(RIGHT(A121,2),D116,E116),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J116:J121)>0,TEXT(DATE(RIGHT(A121,2),F121,G121),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K121=\"\",\"::\",ROUND(SUM(J116:J121)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R116:R121),0)","v":0}]
["","AU",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",20,10,16,10,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J122:J127)>0,B127&\" '\"&RIGHT(A127,2),\"\")","v":""},{"$f":"IF(SUM(J122:J127)>0,TEXT(DATE(RIGHT(A127,2),D122,E122),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J122:J127)>0,TEXT(DATE(RIGHT(A127,2),F127,G127),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K127=\"\",\"::\",ROUND(SUM(J122:J127)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R122:R127),0)","v":0}]
["","WI",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
[{"$f":"IF($S$2=0,\"\",IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+(T129*366)=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+(T129*366))))","v":""},"WI",1,1,1,1,15,{"$f":"IF(AND(DATE(A129,D129,E129)<=$S$1,DATE(A129,F129,G129)>=$S$1),$S$1,IF(OR(DATE(A129,D129,E129)<$S$1,DATE(A129,D129,E129)>$S$2),\"\",(DATE(A129,D129,E129))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A129,D129,E129)<=$S$2,DATE(A129,F129,G129)>=$S$2),$S$2,IF(OR(DATE(A129,F129,G129)<$S$1,DATE(A129,D129,E129)>$S$2),\"\",DATE(A129,F129,G129)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0,null,5]
[{"$f":"A129","v":""},"WI",2,{"$f":"IF(D129=D128,D129+1,D129)","v":1},{"$f":"IF(G128>15,E129+G129,1)","v":16},1,31,{"$f":"IF(AND(DATE(A130,D130,E130)<=$S$1,DATE(A130,F130,G130)>=$S$1),$S$1,IF(OR(DATE(A130,D130,E130)<$S$1,DATE(A130,D130,E130)>$S$2),\"\",(DATE(A130,D130,E130))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A130,D130,E130)<=$S$2,DATE(A130,F130,G130)>=$S$2),$S$2,IF(OR(DATE(A130,F130,G130)<$S$1,DATE(A130,D130,E130)>$S$2),\"\",DATE(A130,F130,G130)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A130","v":""},"WI",3,2,1,2,15,{"$f":"IF(AND(DATE(A131,D131,E131)<=$S$1,DATE(A131,F131,G131)>=$S$1),$S$1,IF(OR(DATE(A131,D131,E131)<$S$1,DATE(A131,D131,E131)>$S$2),\"\",(DATE(A131,D131,E131))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A131,D131,E131)<=$S$2,DATE(A131,F131,G131)>=$S$2),$S$2,IF(OR(DATE(A131,F131,G131)<$S$1,DATE(A131,D131,E131)>$S$2),\"\",DATE(A131,F131,G131)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
["","WI",4,2,16,2,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","WI",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J128:J133)>0,B133&\" '\"&RIGHT(A133,2),\"\")","v":""},{"$f":"IF(SUM(J128:J133)>0,TEXT(DATE(RIGHT(A128,2),D128,E128),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J128:J133)>0,TEXT(DATE(RIGHT(A133,2),F133,G133),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K133=\"\",\"::\",ROUND(SUM(J128:J133)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R128:R133),0)","v":0}]
["","SP",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",9,5,1,{"$f":"D137","v":5},15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,{"$f":"IF(ISNUMBER(J137),ROUND($S$4*J137,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J137),ROUND(O137*S$5,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J137),ROUND((O137+P137)*$S$6,2),\"\")","v":""},0]
["","SP",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SP",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J134:J139)>0,B139&\" '\"&RIGHT(A139,2),\"\")","v":""},{"$f":"IF(SUM(J134:J139)>0,TEXT(DATE(RIGHT(A139,2),D134,E134),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J134:J139)>0,TEXT(DATE(RIGHT(A139,2),F139,G139),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K139=\"\",\"::\",ROUND(SUM(J134:J139)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R134:R139),0)","v":0}]
["","SU",12,6,16,6,{"$f":"IF(F140<>F139,15,DAY(EOMONTH(DATE(RIGHT(TEXT($S$1,\"mm/dd/yyyy\"),4),D140,E140),0.5)))","v":30},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","SU",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J140:J145)>0,B145&\" '\"&RIGHT(A145,2),\"\")","v":""},{"$f":"IF(SUM(J140:J145)>0,TEXT(DATE(RIGHT(A145,2),D140,E140),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J140:J145)>0,TEXT(DATE(RIGHT(A145,2),F145,G145),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K145=\"\",\"::\",ROUND(SUM(J140:J145)/3,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R140:R145),0)","v":0}]
["","AU",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",20,10,16,10,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","AU",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",{"$f":"SUM(O149:Q149)","v":0}]
["","AU",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",{"$f":"SUM(O150:Q150)","v":0}]
["","AU",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J146:J151)>0,B151&\" '\"&RIGHT(A151,2),\"\")","v":""},{"$f":"IF(SUM(J146:J151)>0,TEXT(DATE(RIGHT(A151,2),D146,E146),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J146:J151)>0,TEXT(DATE(RIGHT(A151,2),F151,G151),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K151=\"\",\"::\",ROUND(SUM(J146:J151)/3,3))","v":"::"},"","","",{"$f":"SUM(O151:Q151)","v":0},{"$f":"ROUND(SUM(R146:R151),0)","v":0}]
["","WI",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",{"$f":"SUM(O152:Q152)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S9:S151)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S153-'View Sheet'!J40","v":0}]

{"sheet":"12 month view","index":3,"n_rows":53,"n_cols":38,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,5],[19,0,20,0],[21,0,22,0],[23,0,24,0],[25,0,26,0],[1,3,1,5],[2,3,2,5],[15,0,16,0],[17,0,18,0]]}
["Calendar FEC Calculator"]
["Faculty Name (Last, Mid., First)"]
["Faculty EID"]
["eGC-1 or Budget Number (no dashes or punctuation)"]
["Type of Cost Sharing"]
["Cost Sharing Start Date"]
["Cost Sharing End Date (no more than 5 years from Start Date)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Date Validation",null,{"$f":"DATE(YEAR(F6)+5,MONTH(F6),DAY(EOMONTH(DATE(RIGHT(TEXT(F6,\"mm/dd/yyyy\"),4),MONTH(F6),DAY(F6)),1)))","v":"1905-01-28"}]
["Monthly Effort Pledge",null,null,null,{"$f":"HYPERLINK(\"http://www.washington.edu/research/.SITEPARTS/.documents/.osp/person_months.pdf\",\"Person-Months Conversion Chart\")","v":"Person-Months Conversion Chart"}]
["Monthly IBS (not full time rate)",null,null,null,{"$f":"HYPERLINK(\"http://www.washington.edu/research/osp/gim/gim35.html\",\"IBS components - GIM 35\")","v":"IBS components - GIM 35"}]
["Current Benefit Rate",null,null,null,{"$f":"HYPERLINK(\"http://www.washington.edu/research/osp/gim/gim3.html\",\"Current rates - GIM 3\")","v":"Current rates - GIM 3"}]
["Cost Share F&A Rate",null,null,null,{"$f":"HYPERLINK(\"http://www.washington.edu/research/osp/gim/gim13a.html\",\"Current Rates - GIM 13\")","v":"Current Rates - GIM 13"}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Prd ID","Prd SD","Prd ED","BGT%","Salary start","Salary End","Ben Start","Ben End","F&A St","F&A End","Prd Total"]
[null,"Exclude\na Prd?","Semi-Annual Prd","Start Date","End Date","CSM\nEffort %","Commited Salary","Benefits","Associated F&A","CSM $",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"K","L","M","N","O","O","P","P","Q","Q","S"]
[{"$f":"'12 month Calc Sheet'!A9","v":""},null,{"$f":"IF($B16=\"X\",\"\",INDIRECT(CONCATENATE(\"'12 month Calc Sheet'!\",AB16)))","v":""},{"$f":"IF($B16=\"X\",\"\",INDIRECT(CONCATENATE(\"'12 month Calc Sheet'!\",AC16)))","v":""},{"$f":"IF($B16=\"X\",\"\",INDIRECT(CONCATENATE(\"'12 month Calc Sheet'!\",AD16)))","v":""},{"$f":"IF($B16=\"X\",\"::\",INDIRECT(CONCATENATE(\"'12 month Calc Sheet'!\",AE16)))","v":"::"},{"$f":"IF($B16=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'12 month Calc Sheet'!\",AF16,\":\",AG16))))","v":0},{"$f":"IF($B16=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'12 month Calc Sheet'!\",AH16,\":\",AI16))))","v":0},{"$f":"IF($B16=\"X\",\"\",SUM(INDIRECT(CONCATENATE(\"'12 month Calc Sheet'!\",AJ16,\":\",AK16))))","v":0},{"$f":"IF($B16=\"X\",\"::\",INDIRECT(CONCATENATE(\"'12 month Calc Sheet'!\",AL16)))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,{"$f":"AB$15&$AA16","v":"K20"},{"$f":"AC$15&$AA16","v":"L20"},"M20","N20",{"$f":"AF$15&($AA16-11)","v":"O9"},"O20",{"$f":"AH$15&($AA16-11)","v":"P9"},"P20",{"$f":"AJ$15&($AA16-11)","v":"Q9"},"Q20","S20"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA16+12","v":32},"K32","L32","M32","N32",{"$f":"AF$15&($AA17-11)","v":"O21"},"O32",{"$f":"AH$15&($AA17-11)","v":"P21"},"P32",{"$f":"AJ$15&($AA17-11)","v":"Q21"},"Q32","S32"]
[{"$f":"'12 month Calc Sheet'!A33","v":""},null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44,"K44","L44","M44","N44","O33","O44","P33","P44","Q33","Q44","S44"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56,"K56","L56","M56","N56","O45","O56","P45","P56","Q45","Q56","S56"]
[{"$f":"'12 month Calc Sheet'!A57","v":""},null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,68,"K68","L68","M68","N68","O57","O68","P57","P68","Q57","Q68","S68"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,80,"K80","L80","M80","N80","O69","O80","P69","P80","Q69","Q80","S80"]
[{"$f":"'12 month Calc Sheet'!A81","v":""},null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,92,"K92","L92","M92","N92","O81","O92","P81","P92","Q81","Q92","S92"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104,"K104","L104","M104","N104","O93","O104","P93","P104","Q93","Q104","S104"]
[{"$f":"'12 month Calc Sheet'!A105","v":""},null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116,"K116","L116","M116","N116","O105","O116","P105","P116","Q105","Q116","S116"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,128,"K128","L128","M128","N128","O117","O128","P117","P128","Q117","Q128","S128"]
[{"$f":"'12 month Calc Sheet'!A129","v":""},null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,140,"K140","L140","M140","N140","O129","O140","P129","P140","Q129","Q140","S140"]
[null,null,"","","","::",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,152,"K152","L152","M152","N152","O141","O152","P141","P152","Q141","Q152","S152"]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AA28),\"\",AB$15&$AA28)","v":""},{"$f":"IF(ISBLANK($AA28),\"\",AC$15&$AA28)","v":""},"","",{"$f":"IF(ISBLANK($AA28),\"\",AF$15&($AA28-11))","v":""},{"$f":"IF(ISBLANK($AA28),\"\",AG$15&$AA28)","v":""},{"$f":"IF(ISBLANK($AA28),\"\",AH$15&($AA28-11))","v":""},{"$f":"IF(ISBLANK($AA28),\"\",AI$15&$AA28)","v":""},{"$f":"IF(ISBLANK($AA28),\"\",AJ$15&($AA28-11))","v":""},{"$f":"IF(ISBLANK($AA28),\"\",AK$15&$AA28)","v":""},{"$f":"IF(ISBLANK($AA28),\"\",AL$15&$AA28)","v":""}]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK($AA29),\"\",AB$15&$AA29)","v":""},"","","",{"$f":"IF(ISBLANK($AA29),\"\",AF$15&($AA29-11))","v":""},{"$f":"IF(ISBLANK($AA29),\"\",AG$15&$AA29)","v":""},{"$f":"IF(ISBLANK($AA29),\"\",AH$15&($AA29-11))","v":""},{"$f":"IF(ISBLANK($AA29),\"\",AI$15&$AA29)","v":""},{"$f":"IF(ISBLANK($AA29),\"\",AJ$15&($AA29-11))","v":""},{"$f":"IF(ISBLANK($AA29),\"\",AK$15&$AA29)","v":""},""]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","","",""]
[null,null,null,null,null,null,{"$f":"SUM(G16:G27)","v":0},{"$f":"SUM(H16:H27)","v":0},{"$f":"SUM(I16:I27)","v":0},{"$f":"SUM(J16:J27)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"M-Mandatory"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"R-Committed"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A-Aggregate"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"S-Funding Source Shift"]

{"sheet":"12 month Calc Sheet","index":4,"n_rows":154,"n_cols":20,"rows_kept":154,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Sharing Start Date",null,null,null,null,{"$f":"'12 month view'!F6","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Sharing End Date",null,null,null,null,{"$f":"'12 month view'!F7","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly Effort Pledge",null,null,null,null,{"$f":"'12 month view'!F8","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Monthly IBS",null,null,null,null,{"$f":"'12 month view'!F9","v":0}]
[null,null,null,null,null,null,{"$f":"IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+366=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+366))","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,"Acct Code Benefit Rate",null,null,null,null,{"$f":"'12 month view'!F10","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Applicable F&A Rate",null,null,null,null,{"$f":"'12 month view'!F11","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Dividend variable",6]
[null,"SAP","Pay Prd","PP_StartMonth","PP_StartDay","PP_EndMonth","PP_EndDay","PP_Start","PP_End","Percent per Pay Period","Qtr","Qtr\nStart Date","Qtr\nEnd Date","BGT %","Salary","Benefits","F&A Rate","Subtotal","BGT $","Year Factor"]
[{"$f":"IF($S$1=0,\"\",YEAR(TEXT($S$1,\"mm/dd/yyyy\")))","v":""},"1st",1,1,1,{"$f":"D9","v":1},15,{"$f":"IF(AND(DATE(A9,D9,E9)<=$S$1,DATE(A9,F9,G9)>=$S$1),$S$1,IF(OR(DATE(A9,D9,E9)<$S$1,DATE(A9,D9,E9)>$S$2),\"\",(DATE(A9,D9,E9))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A9,D9,E9)<=$S$2,DATE(A9,F9,G9)>=$S$2),$S$2,IF(OR(DATE(A9,F9,G9)<$S$1,DATE(A9,D9,E9)>$S$2),\"\",DATE(A9,F9,G9)))","v":{"$error":"#VALUE!"}},{"$f":"IF(OR(ISNUMBER(H9),ISNUMBER(I9)),$S$3/2,\"\")","v":""},null,null,null,null,{"$f":"IF(ISNUMBER(J9),ROUND($S$4*J9,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J9),ROUND(O9*S$5,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J9),ROUND((O9+P9)*$S$6,2),\"\")","v":""},{"$f":"IF(ISNUMBER(SUM(O9:Q9)),SUM(O9:Q9),\"\")","v":0}]
[{"$f":"A9","v":""},"1st",2,{"$f":"IF(D9=D8,D9+1,D9)","v":1},{"$f":"IF(G8>15,E9+G9,1)","v":16},1,{"$f":"DAY(EOMONTH(DATE(RIGHT(TEXT($S$1,\"mm/dd/yyyy\"),4),D10,E10),0.5))","v":31},{"$f":"IF(AND(DATE(A10,D10,E10)<=$S$1,DATE(A10,F10,G10)>=$S$1),$S$1,IF(OR(DATE(A10,D10,E10)<$S$1,DATE(A10,D10,E10)>$S$2),\"\",(DATE(A10,D10,E10))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A10,D10,E10)<=$S$2,DATE(A10,F10,G10)>=$S$2),$S$2,IF(OR(DATE(A10,F10,G10)<$S$1,DATE(A10,D10,E10)>$S$2),\"\",DATE(A10,F10,G10)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A10","v":""},"1st",3,2,1,2,{"$f":"IF(F11<>F10,15,DAY(EOMONTH(DATE(RIGHT(TEXT($S$1,\"mm/dd/yyyy\"),4),D11,E11),0.5)))","v":15},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",4,2,16,2,{"$f":"IF(F12<>F11,15,DAY(EOMONTH(DATE(RIGHT(TEXT($S$1,\"mm/dd/yyyy\"),4),D12,E12),0.5)))","v":28},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",12,6,16,6,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J9:J20)>0,B20&\" '\"&RIGHT(A19,2),\"\")","v":""},{"$f":"IF(SUM(J9:J20)>0,TEXT(DATE(RIGHT(OFFSET(K20,0,-10),2),D9,E9),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J9:J20)>0,TEXT(DATE(RIGHT(A19,2),F20,G20),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K20=\"\",\"::\",ROUND(SUM(J9:J20)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R9:R20),0)","v":0}]
["","2nd",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",{"$f":"SUM(O21:Q21)","v":0}]
["","2nd",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,{"$f":"IF(ISNUMBER(J27),ROUND($S$4*J27,2),\"\")","v":""},"","",0]
["","2nd",20,10,16,10,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(OR(ISNUMBER(H31),ISNUMBER(I31)),$S$3/2,\"\")","v":""},null,null,null,null,"","","",0]
["","2nd",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(OR(ISNUMBER(H32),ISNUMBER(I32)),$S$3/2,\"\")","v":""},{"$f":"IF(SUM(J21:J32)>0,B31&\" '\"&RIGHT(A31,2),\"\")","v":""},{"$f":"IF(SUM(J21:J32)>0,TEXT(DATE(RIGHT(A32,2),D21,E21),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J21:J32)>0,TEXT(DATE(RIGHT(A32,2),F32,G32),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K32=\"\",\"::\",ROUND(SUM(J21:J32)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R21:R32),0)","v":0}]
[{"$f":"IF($S$2=0,\"\",IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+366=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+366)))","v":""},"1st",1,1,1,1,15,{"$f":"IF(AND(DATE(A33,D33,E33)<=$S$1,DATE(A33,F33,G33)>=$S$1),$S$1,IF(OR(DATE(A33,D33,E33)<$S$1,DATE(A33,D33,E33)>$S$2),\"\",(DATE(A33,D33,E33))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A33,D33,E33)<=$S$2,DATE(A33,F33,G33)>=$S$2),$S$2,IF(OR(DATE(A33,F33,G33)<$S$1,DATE(A33,D33,E33)>$S$2),\"\",DATE(A33,F33,G33)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0,null,1]
[{"$f":"A33","v":""},"1st",2,{"$f":"IF(D33=D32,D33+1,D33)","v":1},{"$f":"IF(G32>15,E33+G33,1)","v":16},1,31,{"$f":"IF(AND(DATE(A34,D34,E34)<=$S$1,DATE(A34,F34,G34)>=$S$1),$S$1,IF(OR(DATE(A34,D34,E34)<$S$1,DATE(A34,D34,E34)>$S$2),\"\",(DATE(A34,D34,E34))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A34,D34,E34)<=$S$2,DATE(A34,F34,G34)>=$S$2),$S$2,IF(OR(DATE(A34,F34,G34)<$S$1,DATE(A34,D34,E34)>$S$2),\"\",DATE(A34,F34,G34)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A34","v":""},"1st",3,2,1,2,15,{"$f":"IF(AND(DATE(A35,D35,E35)<=$S$1,DATE(A35,F35,G35)>=$S$1),$S$1,IF(OR(DATE(A35,D35,E35)<$S$1,DATE(A35,D35,E35)>$S$2),\"\",(DATE(A35,D35,E35))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A35,D35,E35)<=$S$2,DATE(A35,F35,G35)>=$S$2),$S$2,IF(OR(DATE(A35,F35,G35)<$S$1,DATE(A35,D35,E35)>$S$2),\"\",DATE(A35,F35,G35)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
["","1st",4,2,16,2,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",12,6,16,6,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J33:J44)>0,B44&\" '\"&RIGHT(A44,2),\"\")","v":""},{"$f":"IF(SUM(J33:J44)>0,TEXT(DATE(RIGHT(A43,2),D33,E33),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J33:J44)>0,TEXT(DATE(RIGHT(A44,2),F44,G44),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K44=\"\",\"::\",ROUND(SUM(J33:J44)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R33:R44),0)","v":0}]
["","2nd",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",20,10,16,10,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J45:J56)>0,B56&\" '\"&RIGHT(A56,2),\"\")","v":""},{"$f":"IF(SUM(J45:J56)>0,TEXT(DATE(RIGHT(A55,2),D45,E45),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J45:J56)>0,TEXT(DATE(RIGHT(A55,2),F56,G56),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K56=\"\",\"::\",ROUND(SUM(J45:J56)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R45:R56),0)","v":0}]
[{"$f":"IF($S$2=0,\"\",IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+(T57*366)=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+(T57*366))))","v":""},"1st",1,1,1,{"$f":"D57","v":1},15,{"$f":"IF(AND(DATE(A57,D57,E57)<=$S$1,DATE(A57,F57,G57)>=$S$1),$S$1,IF(OR(DATE(A57,D57,E57)<$S$1,DATE(A57,D57,E57)>$S$2),\"\",(DATE(A57,D57,E57))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A57,D57,E57)<=$S$2,DATE(A57,F57,G57)>=$S$2),$S$2,IF(OR(DATE(A57,F57,G57)<$S$1,DATE(A57,D57,E57)>$S$2),\"\",DATE(A57,F57,G57)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,{"$f":"IF(ISNUMBER(J57),ROUND($S$4*J57,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J57),ROUND(O57*S$5,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J57),ROUND((O57+P57)*$S$6,2),\"\")","v":""},{"$f":"SUM(O57:Q57)","v":0},null,2]
[{"$f":"A57","v":""},"1st",2,{"$f":"IF(D57=D56,D57+1,D57)","v":1},{"$f":"IF(G56>15,E57+G57,1)","v":16},1,31,{"$f":"IF(AND(DATE(A58,D58,E58)<=$S$1,DATE(A58,F58,G58)>=$S$1),$S$1,IF(OR(DATE(A58,D58,E58)<$S$1,DATE(A58,D58,E58)>$S$2),\"\",(DATE(A58,D58,E58))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A58,D58,E58)<=$S$2,DATE(A58,F58,G58)>=$S$2),$S$2,IF(OR(DATE(A58,F58,G58)<$S$1,DATE(A58,D58,E58)>$S$2),\"\",DATE(A58,F58,G58)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A58","v":""},"1st",3,2,1,2,15,{"$f":"IF(AND(DATE(A59,D59,E59)<=$S$1,DATE(A59,F59,G59)>=$S$1),$S$1,IF(OR(DATE(A59,D59,E59)<$S$1,DATE(A59,D59,E59)>$S$2),\"\",(DATE(A59,D59,E59))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A59,D59,E59)<=$S$2,DATE(A59,F59,G59)>=$S$2),$S$2,IF(OR(DATE(A59,F59,G59)<$S$1,DATE(A59,D59,E59)>$S$2),\"\",DATE(A59,F59,G59)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
["","1st",4,2,16,2,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",12,6,16,6,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J57:J68)>0,B68&\" '\"&RIGHT(A68,2),\"\")","v":""},{"$f":"IF(SUM(J57:J68)>0,TEXT(DATE(RIGHT(A67,2),D57,E57),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J57:J68)>0,TEXT(DATE(RIGHT(A68,2),F68,G68),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K68=\"\",\"::\",ROUND(SUM(J57:J68)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R57:R68),0)","v":0}]
["","2nd",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",20,10,16,10,{"$f":"IF(F76<>F75,15,DAY(EOMONTH(DATE(RIGHT(TEXT($S$1,\"mm/dd/yyyy\"),4),D76,E76),0.5)))","v":31},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J69:J80)>0,B80&\" '\"&RIGHT(A80,2),\"\")","v":""},{"$f":"IF(SUM(J69:J80)>0,TEXT(DATE(RIGHT(A79,2),D69,E69),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J69:J80)>0,TEXT(DATE(RIGHT(A79,2),F80,G80),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K80=\"\",\"::\",ROUND(SUM(J69:J80)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R69:R80),0)","v":0}]
[{"$f":"IF($S$2=0,\"\",IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+(T81*366)=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+(T81*366))))","v":""},"1st",1,1,1,{"$f":"D81","v":1},15,{"$f":"IF(AND(DATE(A81,D81,E81)<=$S$1,DATE(A81,F81,G81)>=$S$1),$S$1,IF(OR(DATE(A81,D81,E81)<$S$1,DATE(A81,D81,E81)>$S$2),\"\",(DATE(A81,D81,E81))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A81,D81,E81)<=$S$2,DATE(A81,F81,G81)>=$S$2),$S$2,IF(OR(DATE(A81,F81,G81)<$S$1,DATE(A81,D81,E81)>$S$2),\"\",DATE(A81,F81,G81)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0,null,3]
[{"$f":"A81","v":""},"1st",2,{"$f":"IF(D81=D80,D81+1,D81)","v":1},{"$f":"IF(G80>15,E81+G81,1)","v":16},1,31,{"$f":"IF(AND(DATE(A82,D82,E82)<=$S$1,DATE(A82,F82,G82)>=$S$1),$S$1,IF(OR(DATE(A82,D82,E82)<$S$1,DATE(A82,D82,E82)>$S$2),\"\",(DATE(A82,D82,E82))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A82,D82,E82)<=$S$2,DATE(A82,F82,G82)>=$S$2),$S$2,IF(OR(DATE(A82,F82,G82)<$S$1,DATE(A82,D82,E82)>$S$2),\"\",DATE(A82,F82,G82)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A82","v":""},"1st",3,2,1,2,15,{"$f":"IF(AND(DATE(A83,D83,E83)<=$S$1,DATE(A83,F83,G83)>=$S$1),$S$1,IF(OR(DATE(A83,D83,E83)<$S$1,DATE(A83,D83,E83)>$S$2),\"\",(DATE(A83,D83,E83))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A83,D83,E83)<=$S$2,DATE(A83,F83,G83)>=$S$2),$S$2,IF(OR(DATE(A83,F83,G83)<$S$1,DATE(A83,D83,E83)>$S$2),\"\",DATE(A83,F83,G83)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
["","1st",4,2,16,2,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",12,6,16,6,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J81:J92)>0,B92&\" '\"&RIGHT(A92,2),\"\")","v":""},{"$f":"IF(SUM(J81:J92)>0,TEXT(DATE(RIGHT(A91,2),D81,E81),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J81:J92)>0,TEXT(DATE(RIGHT(A92,2),F92,G92),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K92=\"\",\"::\",ROUND(SUM(J81:J92)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R81:R92),0)","v":0}]
["","2nd",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"IF(OR(ISNUMBER(H96),ISNUMBER(I96)),$S$3/2,\"\")","v":""},null,null,null,null,"","","",0]
["","2nd",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",20,10,16,10,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J93:J104)>0,B104&\" '\"&RIGHT(A104,2),\"\")","v":""},{"$f":"IF(SUM(J93:J104)>0,TEXT(DATE(RIGHT(A103,2),D93,E93),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J93:J104)>0,TEXT(DATE(RIGHT(A103,2),F104,G104),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K104=\"\",\"::\",ROUND(SUM(J93:J104)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R93:R104),0)","v":0}]
[{"$f":"IF($S$2=0,\"\",IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+(T105*366)=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+(T105*366))))","v":""},"1st",1,1,1,{"$f":"D105","v":1},15,{"$f":"IF(AND(DATE(A105,D105,E105)<=$S$1,DATE(A105,F105,G105)>=$S$1),$S$1,IF(OR(DATE(A105,D105,E105)<$S$1,DATE(A105,D105,E105)>$S$2),\"\",(DATE(A105,D105,E105))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A105,D105,E105)<=$S$2,DATE(A105,F105,G105)>=$S$2),$S$2,IF(OR(DATE(A105,F105,G105)<$S$1,DATE(A105,D105,E105)>$S$2),\"\",DATE(A105,F105,G105)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0,null,4]
[{"$f":"A105","v":""},"1st",2,{"$f":"IF(D105=D104,D105+1,D105)","v":1},{"$f":"IF(G104>15,E105+G105,1)","v":16},1,31,{"$f":"IF(AND(DATE(A106,D106,E106)<=$S$1,DATE(A106,F106,G106)>=$S$1),$S$1,IF(OR(DATE(A106,D106,E106)<$S$1,DATE(A106,D106,E106)>$S$2),\"\",(DATE(A106,D106,E106))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A106,D106,E106)<=$S$2,DATE(A106,F106,G106)>=$S$2),$S$2,IF(OR(DATE(A106,F106,G106)<$S$1,DATE(A106,D106,E106)>$S$2),\"\",DATE(A106,F106,G106)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A106","v":""},"1st",3,2,1,2,15,{"$f":"IF(AND(DATE(A107,D107,E107)<=$S$1,DATE(A107,F107,G107)>=$S$1),$S$1,IF(OR(DATE(A107,D107,E107)<$S$1,DATE(A107,D107,E107)>$S$2),\"\",(DATE(A107,D107,E107))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A107,D107,E107)<=$S$2,DATE(A107,F107,G107)>=$S$2),$S$2,IF(OR(DATE(A107,F107,G107)<$S$1,DATE(A107,D107,E107)>$S$2),\"\",DATE(A107,F107,G107)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
["","1st",4,2,16,2,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",12,6,16,6,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J105:J116)>0,B116&\" '\"&RIGHT(A116,2),\"\")","v":""},{"$f":"IF(SUM(J105:J116)>0,TEXT(DATE(RIGHT(A115,2),D105,E105),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J105:J116)>0,TEXT(DATE(RIGHT(A116,2),F116,G116),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K116=\"\",\"::\",ROUND(SUM(J105:J116)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R105:R116),0)","v":0}]
["","2nd",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,{"$f":"IF(ISNUMBER(J121),ROUND($S$4*J121,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J121),ROUND(O121*S$5,2),\"\")","v":""},{"$f":"IF(ISNUMBER(J121),ROUND((O121+P121)*$S$6,2),\"\")","v":""},{"$f":"SUM(O121:Q121)","v":0}]
["","2nd",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",20,10,16,10,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J117:J128)>0,B128&\" '\"&RIGHT(A128,2),\"\")","v":""},{"$f":"IF(SUM(J117:J128)>0,TEXT(DATE(RIGHT(A127,2),D117,E117),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J117:J128)>0,TEXT(DATE(RIGHT(A127,2),F128,G128),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K128=\"\",\"::\",ROUND(SUM(J117:J128)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R117:R128),0)","v":0}]
[{"$f":"IF($S$2=0,\"\",IF(YEAR(TEXT($S$1,\"mm/dd/yyyy\"))+(T129*366)=YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$2,\"mm/dd/yyyy\")),YEAR(TEXT($S$1,\"mm/dd/yyyy\")+(T129*366))))","v":""},"1st",1,1,1,{"$f":"D129","v":1},15,{"$f":"IF(AND(DATE(A129,D129,E129)<=$S$1,DATE(A129,F129,G129)>=$S$1),$S$1,IF(OR(DATE(A129,D129,E129)<$S$1,DATE(A129,D129,E129)>$S$2),\"\",(DATE(A129,D129,E129))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A129,D129,E129)<=$S$2,DATE(A129,F129,G129)>=$S$2),$S$2,IF(OR(DATE(A129,F129,G129)<$S$1,DATE(A129,D129,E129)>$S$2),\"\",DATE(A129,F129,G129)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0,null,5]
[{"$f":"A129","v":""},"1st",2,{"$f":"IF(D129=D128,D129+1,D129)","v":1},{"$f":"IF(G128>15,E129+G129,1)","v":16},1,31,{"$f":"IF(AND(DATE(A130,D130,E130)<=$S$1,DATE(A130,F130,G130)>=$S$1),$S$1,IF(OR(DATE(A130,D130,E130)<$S$1,DATE(A130,D130,E130)>$S$2),\"\",(DATE(A130,D130,E130))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A130,D130,E130)<=$S$2,DATE(A130,F130,G130)>=$S$2),$S$2,IF(OR(DATE(A130,F130,G130)<$S$1,DATE(A130,D130,E130)>$S$2),\"\",DATE(A130,F130,G130)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
[{"$f":"A130","v":""},"1st",3,2,1,2,15,{"$f":"IF(AND(DATE(A131,D131,E131)<=$S$1,DATE(A131,F131,G131)>=$S$1),$S$1,IF(OR(DATE(A131,D131,E131)<$S$1,DATE(A131,D131,E131)>$S$2),\"\",(DATE(A131,D131,E131))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AND(DATE(A131,D131,E131)<=$S$2,DATE(A131,F131,G131)>=$S$2),$S$2,IF(OR(DATE(A131,F131,G131)<$S$1,DATE(A131,D131,E131)>$S$2),\"\",DATE(A131,F131,G131)))","v":{"$error":"#VALUE!"}},"",null,null,null,null,"","","",0]
["","1st",4,2,16,2,28,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",5,3,1,3,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",6,3,16,3,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",7,4,1,4,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",8,4,16,4,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",9,5,1,5,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",10,5,16,5,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",11,6,1,6,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","1st",12,6,16,6,{"$f":"IF(F140<>F139,15,DAY(EOMONTH(DATE(RIGHT(TEXT($S$1,\"mm/dd/yyyy\"),4),D140,E140),0.5)))","v":30},{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J129:J140)>0,B140&\" '\"&RIGHT(A140,2),\"\")","v":""},{"$f":"IF(SUM(J129:J140)>0,TEXT(DATE(RIGHT(A139,2),D129,E129),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J129:J140)>0,TEXT(DATE(RIGHT(A140,2),F140,G140),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K140=\"\",\"::\",ROUND(SUM(J129:J140)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R129:R140),0)","v":0}]
["","2nd",13,7,1,7,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",14,7,16,7,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",15,8,1,8,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",16,8,16,8,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",17,9,1,9,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",18,9,16,9,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",19,10,1,10,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",20,10,16,10,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",21,11,1,11,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",22,11,16,11,30,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",23,12,1,12,15,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",null,null,null,null,"","","",0]
["","2nd",24,12,16,12,31,{"$error":"#VALUE!"},{"$error":"#VALUE!"},"",{"$f":"IF(SUM(J141:J152)>0,B152&\" '\"&RIGHT(A152,2),\"\")","v":""},{"$f":"IF(SUM(J141:J152)>0,TEXT(DATE(RIGHT(A151,2),D141,E141),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(SUM(J141:J152)>0,TEXT(DATE(RIGHT(A151,2),F152,G152),\"mm/dd/yy\"),\"\")","v":""},{"$f":"IF(K152=\"\",\"::\",ROUND(SUM(J141:J152)/dividend,3))","v":"::"},"","","",0,{"$f":"ROUND(SUM(R141:R152),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O9:O152)","v":0},{"$f":"SUM(P9:P152)","v":0},{"$f":"SUM(Q9:Q152)","v":0},{"$f":"SUM(R9:R152)","v":0},{"$f":"SUM(S9:S152)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S153-'12 month view'!J40","v":0}]

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