{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Entitlement","NonEntitlement","Total Draw","Sheet4"],"not_rendered":{"charts":0,"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":"Instructions","index":0,"n_rows":34,"n_cols":2,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["Texas Department of Housing and Community Affairs"]
["Texas Emergency Mortgage Assistance Program (TEMAP)"]
[]
["This spreadsheet is to be used by Subrecipients administering TEMAP to report the households processed during the month and the household data of the beneficiaries.  Households assisted are reported only once in this spreadsheet to TEMAP. "]
["The spreadsheet is not necessarily reflective of your monthly draw since it can include future months of assistance.  The spreadsheet's purpose is to identify duplication of benefit (name, address and months of assistance) with other mortgage assistance programs."]
["Each month's report is to be submitted via Smartsheet no later than the 15th day of the following month (e.g., the report on July 2021 program activity will be due no later than August 15, 2021)."]
[]
["Instructions - Household Data"]
["Part C Programs will complete each tab in this workbook. Complete the Entitlement tab for clients you served from Entitlement ares listed in your contract. Complete the NonEntitlement tab for clients you served from NonEntitlement areas listed in your contract. "]
["1. Enter subrecipient name in cell B1."]
["2. Enter month and year in cell F1 using the drop down box."]
["3. Report data for each household receiving assistance during the reporting period in one row."]
["4. Columns A-C - Enter application information. "]
["5. Columns D-H - Indicate the address and county in which the applicant's home is located."]
["6. Column I - Enter the number of individuals in the household."]
["7. Column J- Enter the total household annual income."]
["8. Column K - Indicate the household's income as a percentage of Area Median Income (AMI) using the drop down box."]
[null,"2021 Area Median Income"]
["9. Column L - Enter the method used to determine the household's income eligibility using the drop down box."]
["10. Columns M-R - Enter demographic information for head of household."]
["11. Columns S-V - Enter information about arrears owed by the household. Use the drop down box in Column U to indicate all months paid."]
["12. Columns W-Z - Enter information about current or future months of assistance requested by the household. Use the drop down box in Column AF to indicate current/future month paid."]
[null,"Column AA will autopopulate with the combined total owed by the household."]
["17. Save file as yymmdd_[city or county name]_TEMAP Household Data.xls and submit via Smartsheet form linked below:"]
[null,"https://app.smartsheet.com/b/form/01db3251f2f649f2ba7cae9bf9d4fc62"]
[]
["Instructions - Total Draw"]
["Part C Programs will complete each tab in this workbook. Complete the Total Draw tab with the total drawn from Entitlement and NonEntitlement for admin and project from your Housing Contract System draw. The completed sheet should equal the draw you submitted in Housing Contract System."]
["1. Select the reporting month from the date dropdown menu"]
["2. Enter the total Admin for Entitlement in cell C4."]
["3. Enter the total Admin for NonEntitlement in cell C5."]
["4. Enter the total Project for Entitlement in cell C8."]
["5. Enter the total Project for NonEntitlement in C9."]
["6. Review the totals on the sheet for accuracy by comparing to your Housing Contract System Draw. "]

{"sheet":"Entitlement","index":1,"n_rows":100,"n_cols":27,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,5,0,6],[0,8,0,11],[0,12,0,17],[0,18,0,21],[0,22,0,25],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[7,3,7,4],[8,3,8,4],[9,3,9,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[79,3,79,4],[80,3,80,4],[81,3,81,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[88,3,88,4],[89,3,89,4],[90,3,90,4],[91,3,91,4],[92,3,92,4],[93,3,93,4],[82,3,82,4],[83,3,83,4],[84,3,84,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[103,3,103,4],[104,3,104,4],[105,3,105,4],[94,3,94,4],[95,3,95,4],[96,3,96,4],[97,3,97,4],[98,3,98,4],[99,3,99,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[115,3,115,4],[116,3,116,4],[117,3,117,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[109,3,109,4],[110,3,110,4],[111,3,111,4],[124,3,124,4],[125,3,125,4],[126,3,126,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[118,3,118,4],[119,3,119,4],[120,3,120,4],[121,3,121,4],[122,3,122,4],[123,3,123,4],[136,3,136,4],[137,3,137,4],[138,3,138,4],[139,3,139,4],[140,3,140,4],[141,3,141,4],[130,3,130,4],[131,3,131,4],[132,3,132,4],[133,3,133,4],[134,3,134,4],[135,3,135,4],[148,3,148,4],[149,3,149,4],[150,3,150,4],[151,3,151,4],[152,3,152,4],[153,3,153,4],[142,3,142,4],[143,3,143,4],[144,3,144,4],[145,3,145,4],[146,3,146,4],[147,3,147,4],[160,3,160,4],[161,3,161,4],[162,3,162,4],[163,3,163,4],[164,3,164,4],[165,3,165,4],[154,3,154,4],[155,3,155,4],[156,3,156,4],[157,3,157,4],[158,3,158,4],[159,3,159,4],[172,3,172,4],[173,3,173,4],[174,3,174,4],[175,3,175,4],[176,3,176,4],[177,3,177,4],[166,3,166,4],[167,3,167,4],[168,3,168,4],[169,3,169,4],[170,3,170,4],[171,3,171,4],[184,3,184,4],[185,3,185,4],[186,3,186,4],[187,3,187,4],[188,3,188,4],[189,3,189,4],[178,3,178,4],[179,3,179,4],[180,3,180,4],[181,3,181,4],[182,3,182,4],[183,3,183,4],[196,3,196,4],[197,3,197,4],[198,3,198,4],[199,3,199,4],[200,3,200,4],[201,3,201,4],[190,3,190,4],[191,3,191,4],[192,3,192,4],[193,3,193,4],[194,3,194,4],[195,3,195,4],[208,3,208,4],[209,3,209,4],[210,3,210,4],[211,3,211,4],[212,3,212,4],[213,3,213,4],[202,3,202,4],[203,3,203,4],[204,3,204,4],[205,3,205,4],[206,3,206,4],[207,3,207,4],[220,3,220,4],[221,3,221,4],[222,3,222,4],[223,3,223,4],[224,3,224,4],[225,3,225,4],[214,3,214,4],[215,3,215,4],[216,3,216,4],[217,3,217,4],[218,3,218,4],[219,3,219,4],[232,3,232,4],[233,3,233,4],[234,3,234,4],[235,3,235,4],[236,3,236,4],[237,3,237,4],[226,3,226,4],[227,3,227,4],[228,3,228,4],[229,3,229,4],[230,3,230,4],[231,3,231,4],[244,3,244,4],[245,3,245,4],[246,3,246,4],[247,3,247,4],[248,3,248,4],[249,3,249,4],[238,3,238,4],[239,3,239,4],[240,3,240,4],[241,3,241,4],[242,3,242,4],[243,3,243,4],[256,3,256,4],[257,3,257,4],[258,3,258,4],[259,3,259,4],[260,3,260,4],[261,3,261,4],[250,3,250,4],[251,3,251,4],[252,3,252,4],[253,3,253,4],[254,3,254,4],[255,3,255,4],[268,3,268,4],[269,3,269,4],[270,3,270,4],[271,3,271,4],[272,3,272,4],[273,3,273,4],[262,3,262,4],[263,3,263,4],[264,3,264,4],[265,3,265,4],[266,3,266,4],[267,3,267,4],[280,3,280,4],[281,3,281,4],[282,3,282,4],[283,3,283,4],[284,3,284,4],[285,3,285,4],[274,3,274,4],[275,3,275,4],[276,3,276,4],[277,3,277,4],[278,3,278,4],[279,3,279,4],[292,3,292,4],[293,3,293,4],[294,3,294,4],[295,3,295,4],[296,3,296,4],[297,3,297,4],[286,3,286,4],[287,3,287,4],[288,3,288,4],[289,3,289,4],[290,3,290,4],[291,3,291,4],[304,3,304,4],[305,3,305,4],[306,3,306,4],[307,3,307,4],[308,3,308,4],[309,3,309,4],[298,3,298,4],[299,3,299,4],[300,3,300,4],[301,3,301,4],[302,3,302,4],[303,3,303,4],[316,3,316,4],[317,3,317,4],[318,3,318,4],[319,3,319,4],[320,3,320,4],[321,3,321,4],[310,3,310,4],[311,3,311,4],[312,3,312,4],[313,3,313,4],[314,3,314,4],[315,3,315,4],[328,3,328,4],[329,3,329,4],[330,3,330,4],[331,3,331,4],[332,3,332,4],[333,3,333,4],[322,3,322,4],[323,3,323,4],[324,3,324,4],[325,3,325,4],[326,3,326,4],[327,3,327,4],[340,3,340,4],[341,3,341,4],[342,3,342,4],[343,3,343,4],[344,3,344,4],[345,3,345,4],[334,3,334,4],[335,3,335,4],[336,3,336,4],[337,3,337,4],[338,3,338,4],[339,3,339,4],[352,3,352,4],[353,3,353,4],[354,3,354,4],[355,3,355,4],[356,3,356,4],[357,3,357,4],[346,3,346,4],[347,3,347,4],[348,3,348,4],[349,3,349,4],[350,3,350,4],[351,3,351,4],[364,3,364,4],[365,3,365,4],[366,3,366,4],[367,3,367,4],[368,3,368,4],[369,3,369,4],[358,3,358,4],[359,3,359,4],[360,3,360,4],[361,3,361,4],[362,3,362,4],[363,3,363,4],[376,3,376,4],[377,3,377,4],[378,3,378,4],[379,3,379,4],[380,3,380,4],[381,3,381,4],[370,3,370,4],[371,3,371,4],[372,3,372,4],[373,3,373,4],[374,3,374,4],[375,3,375,4],[388,3,388,4],[389,3,389,4],[390,3,390,4],[391,3,391,4],[392,3,392,4],[393,3,393,4],[382,3,382,4],[383,3,383,4],[384,3,384,4],[385,3,385,4],[386,3,386,4],[387,3,387,4],[400,3,400,4],[401,3,401,4],[402,3,402,4],[403,3,403,4],[404,3,404,4],[405,3,405,4],[394,3,394,4],[395,3,395,4],[396,3,396,4],[397,3,397,4],[398,3,398,4],[399,3,399,4],[412,3,412,4],[413,3,413,4],[414,3,414,4],[415,3,415,4],[416,3,416,4],[417,3,417,4],[406,3,406,4],[407,3,407,4],[408,3,408,4],[409,3,409,4],[410,3,410,4],[411,3,411,4],[424,3,424,4],[425,3,425,4],[426,3,426,4],[427,3,427,4],[428,3,428,4],[429,3,429,4],[418,3,418,4],[419,3,419,4],[420,3,420,4],[421,3,421,4],[422,3,422,4],[423,3,423,4],[436,3,436,4],[437,3,437,4],[438,3,438,4],[439,3,439,4],[440,3,440,4],[441,3,441,4],[430,3,430,4],[431,3,431,4],[432,3,432,4],[433,3,433,4],[434,3,434,4],[435,3,435,4],[448,3,448,4],[449,3,449,4],[450,3,450,4],[451,3,451,4],[452,3,452,4],[453,3,453,4],[442,3,442,4],[443,3,443,4],[444,3,444,4],[445,3,445,4],[446,3,446,4],[447,3,447,4],[460,3,460,4],[461,3,461,4],[462,3,462,4],[463,3,463,4],[464,3,464,4],[465,3,465,4],[454,3,454,4],[455,3,455,4],[456,3,456,4],[457,3,457,4],[458,3,458,4],[459,3,459,4],[472,3,472,4],[473,3,473,4],[474,3,474,4],[475,3,475,4],[476,3,476,4],[477,3,477,4],[466,3,466,4],[467,3,467,4],[468,3,468,4],[469,3,469,4],[470,3,470,4],[471,3,471,4],[484,3,484,4],[485,3,485,4],[486,3,486,4],[487,3,487,4],[488,3,488,4],[489,3,489,4],[478,3,478,4],[479,3,479,4],[480,3,480,4],[481,3,481,4],[482,3,482,4],[483,3,483,4],[496,3,496,4],[497,3,497,4],[498,3,498,4],[499,3,499,4],[500,3,500,4],[501,3,501,4],[490,3,490,4],[491,3,491,4],[492,3,492,4],[493,3,493,4],[494,3,494,4],[495,3,495,4],[508,3,508,4],[509,3,509,4],[510,3,510,4],[511,3,511,4],[512,3,512,4],[513,3,513,4],[502,3,502,4],[503,3,503,4],[504,3,504,4],[505,3,505,4],[506,3,506,4],[507,3,507,4],[520,3,520,4],[521,3,521,4],[522,3,522,4],[523,3,523,4],[524,3,524,4],[525,3,525,4],[514,3,514,4],[515,3,515,4],[516,3,516,4],[517,3,517,4],[518,3,518,4],[519,3,519,4],[532,3,532,4],[533,3,533,4],[534,3,534,4],[535,3,535,4],[536,3,536,4],[537,3,537,4],[526,3,526,4],[527,3,527,4],[528,3,528,4],[529,3,529,4],[530,3,530,4],[531,3,531,4],[544,3,544,4],[545,3,545,4],[546,3,546,4],[547,3,547,4],[548,3,548,4],[549,3,549,4],[538,3,538,4],[539,3,539,4],[540,3,540,4],[541,3,541,4],[542,3,542,4],[543,3,543,4],[556,3,556,4],[557,3,557,4],[558,3,558,4],[559,3,559,4],[560,3,560,4],[561,3,561,4],[550,3,550,4],[551,3,551,4],[552,3,552,4],[553,3,553,4],[554,3,554,4],[555,3,555,4],[568,3,568,4],[569,3,569,4],[570,3,570,4],[571,3,571,4],[572,3,572,4],[573,3,573,4],[562,3,562,4],[563,3,563,4],[564,3,564,4],[565,3,565,4],[566,3,566,4],[567,3,567,4],[580,3,580,4],[581,3,581,4],[582,3,582,4],[583,3,583,4],[584,3,584,4],[585,3,585,4],[574,3,574,4],[575,3,575,4],[576,3,576,4],[577,3,577,4],[578,3,578,4],[579,3,579,4],[592,3,592,4],[593,3,593,4],[594,3,594,4],[595,3,595,4],[596,3,596,4],[597,3,597,4],[586,3,586,4],[587,3,587,4],[588,3,588,4],[589,3,589,4],[590,3,590,4],[591,3,591,4],[604,3,604,4],[605,3,605,4],[606,3,606,4],[607,3,607,4],[608,3,608,4],[609,3,609,4],[598,3,598,4],[599,3,599,4],[600,3,600,4],[601,3,601,4],[602,3,602,4],[603,3,603,4],[616,3,616,4],[617,3,617,4],[618,3,618,4],[619,3,619,4],[620,3,620,4],[621,3,621,4],[610,3,610,4],[611,3,611,4],[612,3,612,4],[613,3,613,4],[614,3,614,4],[615,3,615,4],[628,3,628,4],[629,3,629,4],[630,3,630,4],[631,3,631,4],[632,3,632,4],[633,3,633,4],[622,3,622,4],[623,3,623,4],[624,3,624,4],[625,3,625,4],[626,3,626,4],[627,3,627,4],[640,3,640,4],[641,3,641,4],[642,3,642,4],[643,3,643,4],[644,3,644,4],[645,3,645,4],[634,3,634,4],[635,3,635,4],[636,3,636,4],[637,3,637,4],[638,3,638,4],[639,3,639,4],[652,3,652,4],[653,3,653,4],[654,3,654,4],[655,3,655,4],[656,3,656,4],[657,3,657,4],[646,3,646,4],[647,3,647,4],[648,3,648,4],[649,3,649,4],[650,3,650,4],[651,3,651,4],[664,3,664,4],[665,3,665,4],[666,3,666,4],[667,3,667,4],[668,3,668,4],[669,3,669,4],[658,3,658,4],[659,3,659,4],[660,3,660,4],[661,3,661,4],[662,3,662,4],[663,3,663,4],[676,3,676,4],[677,3,677,4],[678,3,678,4],[679,3,679,4],[680,3,680,4],[681,3,681,4],[670,3,670,4],[671,3,671,4],[672,3,672,4],[673,3,673,4],[674,3,674,4],[675,3,675,4],[688,3,688,4],[689,3,689,4],[690,3,690,4],[691,3,691,4],[692,3,692,4],[693,3,693,4],[682,3,682,4],[683,3,683,4],[684,3,684,4],[685,3,685,4],[686,3,686,4],[687,3,687,4],[700,3,700,4],[701,3,701,4],[702,3,702,4],[703,3,703,4],[704,3,704,4],[705,3,705,4],[694,3,694,4],[695,3,695,4],[696,3,696,4],[697,3,697,4],[698,3,698,4],[699,3,699,4],[712,3,712,4],[713,3,713,4],[714,3,714,4],[715,3,715,4],[716,3,716,4],[717,3,717,4],[706,3,706,4],[707,3,707,4],[708,3,708,4],[709,3,709,4],[710,3,710,4],[711,3,711,4],[730,3,730,4],[731,3,731,4],[724,3,724,4],[725,3,725,4],[726,3,726,4],[727,3,727,4],[728,3,728,4],[729,3,729,4],[718,3,718,4],[719,3,719,4],[720,3,720,4],[721,3,721,4],[722,3,722,4],[723,3,723,4]]}
["Subrecipient:","Enter city, county or organization name here",null,null,"Month:",null,null,null,"Household, Income, and Eligibility",null,null,null,"Demographics",null,null,null,null,null,"Arrears",null,null,null,"Current/Future Mortgage",null,null,null,"Assistance"]
["Application Date","Household ID","Head of Household (HOH) Name","Household Street Address",null,"Household    City","Household       ZIP Code","Household County","Household Size","Household Annual Income","Percent AMI","Income Verification Method","Gender of HoH","Race of HoH","Ethnicity of HoH","Veteran HoH? Y/N","Senior HoH? (62+) Y/N","Disability HoH? Y/N","Arrears Owed?","# of Months \n(not to exceed 6)","Months Paid","Amount Requested","Current/Future Months Requested?","# of Months \n(Not to exceed 11 when combined w/ arrears)","Months Paid","Amount Requested","Total Amount"]
[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,{"$f":"SUM(V3,Z3)","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,{"$f":"SUM(V4,Z4)","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,{"$f":"SUM(V5,Z5)","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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,{"$f":"SUM(V68,Z68)","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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,0]

{"sheet":"NonEntitlement","index":2,"n_rows":100,"n_cols":27,"rows_kept":100,"cut":false,"hidden":false,"merged":[[0,1,0,3],[0,5,0,6],[0,8,0,11],[0,12,0,17],[0,18,0,21],[0,22,0,25],[7,3,7,4],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[1,3,1,4],[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[31,3,31,4],[32,3,32,4],[33,3,33,4],[34,3,34,4],[35,3,35,4],[36,3,36,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,3,29,4],[30,3,30,4],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[47,3,47,4],[48,3,48,4],[37,3,37,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[55,3,55,4],[56,3,56,4],[57,3,57,4],[58,3,58,4],[59,3,59,4],[60,3,60,4],[49,3,49,4],[50,3,50,4],[51,3,51,4],[52,3,52,4],[53,3,53,4],[54,3,54,4],[67,3,67,4],[68,3,68,4],[69,3,69,4],[70,3,70,4],[71,3,71,4],[72,3,72,4],[61,3,61,4],[62,3,62,4],[63,3,63,4],[64,3,64,4],[65,3,65,4],[66,3,66,4],[79,3,79,4],[80,3,80,4],[81,3,81,4],[82,3,82,4],[83,3,83,4],[84,3,84,4],[73,3,73,4],[74,3,74,4],[75,3,75,4],[76,3,76,4],[77,3,77,4],[78,3,78,4],[91,3,91,4],[92,3,92,4],[93,3,93,4],[94,3,94,4],[95,3,95,4],[96,3,96,4],[85,3,85,4],[86,3,86,4],[87,3,87,4],[88,3,88,4],[89,3,89,4],[90,3,90,4],[103,3,103,4],[104,3,104,4],[105,3,105,4],[106,3,106,4],[107,3,107,4],[108,3,108,4],[97,3,97,4],[98,3,98,4],[99,3,99,4],[100,3,100,4],[101,3,101,4],[102,3,102,4],[115,3,115,4],[116,3,116,4],[117,3,117,4],[118,3,118,4],[119,3,119,4],[120,3,120,4],[109,3,109,4],[110,3,110,4],[111,3,111,4],[112,3,112,4],[113,3,113,4],[114,3,114,4],[127,3,127,4],[128,3,128,4],[129,3,129,4],[130,3,130,4],[131,3,131,4],[132,3,132,4],[121,3,121,4],[122,3,122,4],[123,3,123,4],[124,3,124,4],[125,3,125,4],[126,3,126,4],[139,3,139,4],[140,3,140,4],[141,3,141,4],[142,3,142,4],[143,3,143,4],[144,3,144,4],[133,3,133,4],[134,3,134,4],[135,3,135,4],[136,3,136,4],[137,3,137,4],[138,3,138,4],[151,3,151,4],[152,3,152,4],[153,3,153,4],[154,3,154,4],[155,3,155,4],[156,3,156,4],[145,3,145,4],[146,3,146,4],[147,3,147,4],[148,3,148,4],[149,3,149,4],[150,3,150,4],[163,3,163,4],[164,3,164,4],[165,3,165,4],[166,3,166,4],[167,3,167,4],[168,3,168,4],[157,3,157,4],[158,3,158,4],[159,3,159,4],[160,3,160,4],[161,3,161,4],[162,3,162,4],[175,3,175,4],[176,3,176,4],[177,3,177,4],[178,3,178,4],[179,3,179,4],[180,3,180,4],[169,3,169,4],[170,3,170,4],[171,3,171,4],[172,3,172,4],[173,3,173,4],[174,3,174,4],[187,3,187,4],[188,3,188,4],[189,3,189,4],[190,3,190,4],[191,3,191,4],[192,3,192,4],[181,3,181,4],[182,3,182,4],[183,3,183,4],[184,3,184,4],[185,3,185,4],[186,3,186,4],[199,3,199,4],[200,3,200,4],[201,3,201,4],[202,3,202,4],[203,3,203,4],[204,3,204,4],[193,3,193,4],[194,3,194,4],[195,3,195,4],[196,3,196,4],[197,3,197,4],[198,3,198,4],[211,3,211,4],[212,3,212,4],[213,3,213,4],[214,3,214,4],[215,3,215,4],[216,3,216,4],[205,3,205,4],[206,3,206,4],[207,3,207,4],[208,3,208,4],[209,3,209,4],[210,3,210,4],[223,3,223,4],[224,3,224,4],[225,3,225,4],[226,3,226,4],[227,3,227,4],[228,3,228,4],[217,3,217,4],[218,3,218,4],[219,3,219,4],[220,3,220,4],[221,3,221,4],[222,3,222,4],[235,3,235,4],[236,3,236,4],[237,3,237,4],[238,3,238,4],[239,3,239,4],[240,3,240,4],[229,3,229,4],[230,3,230,4],[231,3,231,4],[232,3,232,4],[233,3,233,4],[234,3,234,4],[247,3,247,4],[248,3,248,4],[249,3,249,4],[250,3,250,4],[251,3,251,4],[252,3,252,4],[241,3,241,4],[242,3,242,4],[243,3,243,4],[244,3,244,4],[245,3,245,4],[246,3,246,4],[259,3,259,4],[260,3,260,4],[261,3,261,4],[262,3,262,4],[263,3,263,4],[264,3,264,4],[253,3,253,4],[254,3,254,4],[255,3,255,4],[256,3,256,4],[257,3,257,4],[258,3,258,4],[271,3,271,4],[272,3,272,4],[273,3,273,4],[274,3,274,4],[275,3,275,4],[276,3,276,4],[265,3,265,4],[266,3,266,4],[267,3,267,4],[268,3,268,4],[269,3,269,4],[270,3,270,4],[283,3,283,4],[284,3,284,4],[285,3,285,4],[286,3,286,4],[287,3,287,4],[288,3,288,4],[277,3,277,4],[278,3,278,4],[279,3,279,4],[280,3,280,4],[281,3,281,4],[282,3,282,4],[295,3,295,4],[296,3,296,4],[297,3,297,4],[298,3,298,4],[299,3,299,4],[300,3,300,4],[289,3,289,4],[290,3,290,4],[291,3,291,4],[292,3,292,4],[293,3,293,4],[294,3,294,4],[307,3,307,4],[308,3,308,4],[309,3,309,4],[310,3,310,4],[311,3,311,4],[312,3,312,4],[301,3,301,4],[302,3,302,4],[303,3,303,4],[304,3,304,4],[305,3,305,4],[306,3,306,4],[319,3,319,4],[320,3,320,4],[321,3,321,4],[322,3,322,4],[323,3,323,4],[324,3,324,4],[313,3,313,4],[314,3,314,4],[315,3,315,4],[316,3,316,4],[317,3,317,4],[318,3,318,4],[331,3,331,4],[332,3,332,4],[333,3,333,4],[334,3,334,4],[335,3,335,4],[336,3,336,4],[325,3,325,4],[326,3,326,4],[327,3,327,4],[328,3,328,4],[329,3,329,4],[330,3,330,4],[343,3,343,4],[344,3,344,4],[345,3,345,4],[346,3,346,4],[347,3,347,4],[348,3,348,4],[337,3,337,4],[338,3,338,4],[339,3,339,4],[340,3,340,4],[341,3,341,4],[342,3,342,4],[355,3,355,4],[356,3,356,4],[357,3,357,4],[358,3,358,4],[359,3,359,4],[360,3,360,4],[349,3,349,4],[350,3,350,4],[351,3,351,4],[352,3,352,4],[353,3,353,4],[354,3,354,4],[367,3,367,4],[368,3,368,4],[369,3,369,4],[370,3,370,4],[371,3,371,4],[372,3,372,4],[361,3,361,4],[362,3,362,4],[363,3,363,4],[364,3,364,4],[365,3,365,4],[366,3,366,4],[379,3,379,4],[380,3,380,4],[381,3,381,4],[382,3,382,4],[383,3,383,4],[384,3,384,4],[373,3,373,4],[374,3,374,4],[375,3,375,4],[376,3,376,4],[377,3,377,4],[378,3,378,4],[391,3,391,4],[392,3,392,4],[393,3,393,4],[394,3,394,4],[395,3,395,4],[396,3,396,4],[385,3,385,4],[386,3,386,4],[387,3,387,4],[388,3,388,4],[389,3,389,4],[390,3,390,4],[403,3,403,4],[404,3,404,4],[405,3,405,4],[406,3,406,4],[407,3,407,4],[408,3,408,4],[397,3,397,4],[398,3,398,4],[399,3,399,4],[400,3,400,4],[401,3,401,4],[402,3,402,4],[415,3,415,4],[416,3,416,4],[417,3,417,4],[418,3,418,4],[419,3,419,4],[420,3,420,4],[409,3,409,4],[410,3,410,4],[411,3,411,4],[412,3,412,4],[413,3,413,4],[414,3,414,4],[427,3,427,4],[428,3,428,4],[429,3,429,4],[430,3,430,4],[431,3,431,4],[432,3,432,4],[421,3,421,4],[422,3,422,4],[423,3,423,4],[424,3,424,4],[425,3,425,4],[426,3,426,4],[439,3,439,4],[440,3,440,4],[441,3,441,4],[442,3,442,4],[443,3,443,4],[444,3,444,4],[433,3,433,4],[434,3,434,4],[435,3,435,4],[436,3,436,4],[437,3,437,4],[438,3,438,4],[451,3,451,4],[452,3,452,4],[453,3,453,4],[454,3,454,4],[455,3,455,4],[456,3,456,4],[445,3,445,4],[446,3,446,4],[447,3,447,4],[448,3,448,4],[449,3,449,4],[450,3,450,4],[463,3,463,4],[464,3,464,4],[465,3,465,4],[466,3,466,4],[467,3,467,4],[468,3,468,4],[457,3,457,4],[458,3,458,4],[459,3,459,4],[460,3,460,4],[461,3,461,4],[462,3,462,4],[475,3,475,4],[476,3,476,4],[477,3,477,4],[478,3,478,4],[479,3,479,4],[480,3,480,4],[469,3,469,4],[470,3,470,4],[471,3,471,4],[472,3,472,4],[473,3,473,4],[474,3,474,4],[487,3,487,4],[488,3,488,4],[489,3,489,4],[490,3,490,4],[491,3,491,4],[492,3,492,4],[481,3,481,4],[482,3,482,4],[483,3,483,4],[484,3,484,4],[485,3,485,4],[486,3,486,4],[499,3,499,4],[500,3,500,4],[501,3,501,4],[502,3,502,4],[503,3,503,4],[504,3,504,4],[493,3,493,4],[494,3,494,4],[495,3,495,4],[496,3,496,4],[497,3,497,4],[498,3,498,4],[511,3,511,4],[512,3,512,4],[513,3,513,4],[514,3,514,4],[515,3,515,4],[516,3,516,4],[505,3,505,4],[506,3,506,4],[507,3,507,4],[508,3,508,4],[509,3,509,4],[510,3,510,4],[523,3,523,4],[524,3,524,4],[525,3,525,4],[526,3,526,4],[527,3,527,4],[528,3,528,4],[517,3,517,4],[518,3,518,4],[519,3,519,4],[520,3,520,4],[521,3,521,4],[522,3,522,4],[535,3,535,4],[536,3,536,4],[537,3,537,4],[538,3,538,4],[539,3,539,4],[540,3,540,4],[529,3,529,4],[530,3,530,4],[531,3,531,4],[532,3,532,4],[533,3,533,4],[534,3,534,4],[547,3,547,4],[548,3,548,4],[549,3,549,4],[550,3,550,4],[551,3,551,4],[552,3,552,4],[541,3,541,4],[542,3,542,4],[543,3,543,4],[544,3,544,4],[545,3,545,4],[546,3,546,4],[559,3,559,4],[560,3,560,4],[561,3,561,4],[562,3,562,4],[563,3,563,4],[564,3,564,4],[553,3,553,4],[554,3,554,4],[555,3,555,4],[556,3,556,4],[557,3,557,4],[558,3,558,4],[571,3,571,4],[572,3,572,4],[573,3,573,4],[574,3,574,4],[575,3,575,4],[576,3,576,4],[565,3,565,4],[566,3,566,4],[567,3,567,4],[568,3,568,4],[569,3,569,4],[570,3,570,4],[583,3,583,4],[584,3,584,4],[585,3,585,4],[586,3,586,4],[587,3,587,4],[588,3,588,4],[577,3,577,4],[578,3,578,4],[579,3,579,4],[580,3,580,4],[581,3,581,4],[582,3,582,4],[595,3,595,4],[596,3,596,4],[597,3,597,4],[598,3,598,4],[599,3,599,4],[600,3,600,4],[589,3,589,4],[590,3,590,4],[591,3,591,4],[592,3,592,4],[593,3,593,4],[594,3,594,4],[607,3,607,4],[608,3,608,4],[609,3,609,4],[610,3,610,4],[611,3,611,4],[612,3,612,4],[601,3,601,4],[602,3,602,4],[603,3,603,4],[604,3,604,4],[605,3,605,4],[606,3,606,4],[619,3,619,4],[620,3,620,4],[621,3,621,4],[622,3,622,4],[623,3,623,4],[624,3,624,4],[613,3,613,4],[614,3,614,4],[615,3,615,4],[616,3,616,4],[617,3,617,4],[618,3,618,4],[631,3,631,4],[632,3,632,4],[633,3,633,4],[634,3,634,4],[635,3,635,4],[636,3,636,4],[625,3,625,4],[626,3,626,4],[627,3,627,4],[628,3,628,4],[629,3,629,4],[630,3,630,4],[643,3,643,4],[644,3,644,4],[645,3,645,4],[646,3,646,4],[647,3,647,4],[648,3,648,4],[637,3,637,4],[638,3,638,4],[639,3,639,4],[640,3,640,4],[641,3,641,4],[642,3,642,4],[655,3,655,4],[656,3,656,4],[657,3,657,4],[658,3,658,4],[659,3,659,4],[660,3,660,4],[649,3,649,4],[650,3,650,4],[651,3,651,4],[652,3,652,4],[653,3,653,4],[654,3,654,4],[667,3,667,4],[668,3,668,4],[669,3,669,4],[670,3,670,4],[671,3,671,4],[672,3,672,4],[661,3,661,4],[662,3,662,4],[663,3,663,4],[664,3,664,4],[665,3,665,4],[666,3,666,4],[679,3,679,4],[680,3,680,4],[681,3,681,4],[682,3,682,4],[683,3,683,4],[684,3,684,4],[673,3,673,4],[674,3,674,4],[675,3,675,4],[676,3,676,4],[677,3,677,4],[678,3,678,4],[691,3,691,4],[692,3,692,4],[693,3,693,4],[694,3,694,4],[695,3,695,4],[696,3,696,4],[685,3,685,4],[686,3,686,4],[687,3,687,4],[688,3,688,4],[689,3,689,4],[690,3,690,4],[703,3,703,4],[704,3,704,4],[705,3,705,4],[706,3,706,4],[707,3,707,4],[708,3,708,4],[697,3,697,4],[698,3,698,4],[699,3,699,4],[700,3,700,4],[701,3,701,4],[702,3,702,4],[715,3,715,4],[716,3,716,4],[717,3,717,4],[718,3,718,4],[719,3,719,4],[720,3,720,4],[709,3,709,4],[710,3,710,4],[711,3,711,4],[712,3,712,4],[713,3,713,4],[714,3,714,4],[727,3,727,4],[728,3,728,4],[729,3,729,4],[730,3,730,4],[731,3,731,4],[732,3,732,4],[721,3,721,4],[722,3,722,4],[723,3,723,4],[724,3,724,4],[725,3,725,4],[726,3,726,4],[739,3,739,4],[740,3,740,4],[741,3,741,4],[742,3,742,4],[743,3,743,4],[744,3,744,4],[733,3,733,4],[734,3,734,4],[735,3,735,4],[736,3,736,4],[737,3,737,4],[738,3,738,4],[751,3,751,4],[752,3,752,4],[753,3,753,4],[754,3,754,4],[755,3,755,4],[756,3,756,4],[745,3,745,4],[746,3,746,4],[747,3,747,4],[748,3,748,4],[749,3,749,4],[750,3,750,4],[763,3,763,4],[764,3,764,4],[765,3,765,4],[766,3,766,4],[767,3,767,4],[768,3,768,4],[757,3,757,4],[758,3,758,4],[759,3,759,4],[760,3,760,4],[761,3,761,4],[762,3,762,4],[775,3,775,4],[776,3,776,4],[777,3,777,4],[778,3,778,4],[779,3,779,4],[780,3,780,4],[769,3,769,4],[770,3,770,4],[771,3,771,4],[772,3,772,4],[773,3,773,4],[774,3,774,4],[787,3,787,4],[788,3,788,4],[789,3,789,4],[790,3,790,4],[791,3,791,4],[792,3,792,4],[781,3,781,4],[782,3,782,4],[783,3,783,4],[784,3,784,4],[785,3,785,4],[786,3,786,4],[799,3,799,4],[800,3,800,4],[801,3,801,4],[802,3,802,4],[803,3,803,4],[804,3,804,4],[793,3,793,4],[794,3,794,4],[795,3,795,4],[796,3,796,4],[797,3,797,4],[798,3,798,4],[811,3,811,4],[812,3,812,4],[813,3,813,4],[814,3,814,4],[815,3,815,4],[816,3,816,4],[805,3,805,4],[806,3,806,4],[807,3,807,4],[808,3,808,4],[809,3,809,4],[810,3,810,4],[823,3,823,4],[824,3,824,4],[825,3,825,4],[826,3,826,4],[827,3,827,4],[828,3,828,4],[817,3,817,4],[818,3,818,4],[819,3,819,4],[820,3,820,4],[821,3,821,4],[822,3,822,4],[835,3,835,4],[836,3,836,4],[837,3,837,4],[838,3,838,4],[839,3,839,4],[840,3,840,4],[829,3,829,4],[830,3,830,4],[831,3,831,4],[832,3,832,4],[833,3,833,4],[834,3,834,4],[847,3,847,4],[848,3,848,4],[849,3,849,4],[850,3,850,4],[851,3,851,4],[852,3,852,4],[841,3,841,4],[842,3,842,4],[843,3,843,4],[844,3,844,4],[845,3,845,4],[846,3,846,4],[859,3,859,4],[860,3,860,4],[861,3,861,4],[862,3,862,4],[863,3,863,4],[864,3,864,4],[853,3,853,4],[854,3,854,4],[855,3,855,4],[856,3,856,4],[857,3,857,4],[858,3,858,4],[871,3,871,4],[872,3,872,4],[873,3,873,4],[874,3,874,4],[875,3,875,4],[876,3,876,4],[865,3,865,4],[866,3,866,4],[867,3,867,4],[868,3,868,4],[869,3,869,4],[870,3,870,4],[883,3,883,4],[884,3,884,4],[885,3,885,4],[886,3,886,4],[887,3,887,4],[888,3,888,4],[877,3,877,4],[878,3,878,4],[879,3,879,4],[880,3,880,4],[881,3,881,4],[882,3,882,4],[895,3,895,4],[896,3,896,4],[897,3,897,4],[898,3,898,4],[899,3,899,4],[900,3,900,4],[889,3,889,4],[890,3,890,4],[891,3,891,4],[892,3,892,4],[893,3,893,4],[894,3,894,4],[907,3,907,4],[908,3,908,4],[909,3,909,4],[910,3,910,4],[911,3,911,4],[912,3,912,4],[901,3,901,4],[902,3,902,4],[903,3,903,4],[904,3,904,4],[905,3,905,4],[906,3,906,4],[919,3,919,4],[920,3,920,4],[921,3,921,4],[922,3,922,4],[923,3,923,4],[924,3,924,4],[913,3,913,4],[914,3,914,4],[915,3,915,4],[916,3,916,4],[917,3,917,4],[918,3,918,4],[931,3,931,4],[932,3,932,4],[933,3,933,4],[934,3,934,4],[935,3,935,4],[936,3,936,4],[925,3,925,4],[926,3,926,4],[927,3,927,4],[928,3,928,4],[929,3,929,4],[930,3,930,4],[943,3,943,4],[944,3,944,4],[945,3,945,4],[946,3,946,4],[947,3,947,4],[948,3,948,4],[937,3,937,4],[938,3,938,4],[939,3,939,4],[940,3,940,4],[941,3,941,4],[942,3,942,4],[955,3,955,4],[956,3,956,4],[957,3,957,4],[958,3,958,4],[959,3,959,4],[960,3,960,4],[949,3,949,4],[950,3,950,4],[951,3,951,4],[952,3,952,4],[953,3,953,4],[954,3,954,4],[967,3,967,4],[968,3,968,4],[969,3,969,4],[961,3,961,4],[962,3,962,4],[963,3,963,4],[964,3,964,4],[965,3,965,4],[966,3,966,4]]}
["Subrecipient:","Enter city, county or organization name here",null,null,"Month:","2021-06-01",null,null,"Household, Income, and Eligibility",null,null,null,"Demographics",null,null,null,null,null,"Arrears",null,null,null,"Current/Future Mortgage",null,null,null,"Assistance"]
["Application Date","Household ID","Head of Household (HOH) Name","Household Street Address",null,"Household    City","Household       ZIP Code","Household County","Household Size","Household Annual Income","Percent AMI","Income Verification Method","Gender of HoH","Race of HoH","Ethnicity of HoH","Veteran HoH? Y/N","Senior HoH? (62+) Y/N","Disability HoH? Y/N","Arrears Owed?","# of Months \n(not to exceed 6)","Months Paid","Amount Requested","Current/Future Months Requested?","# of Months \n(Not to exceed 11 when combined w/ arrears)","Months Paid","Amount Requested","Total Amount"]
[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,{"$f":"SUM(V3,Z3)","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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,{"$f":"SUM(V35,Z35)","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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,{"$f":"SUM(V67,Z67)","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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,{"$f":"SUM(V99,Z99)","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,0]

{"sheet":"Total Draw","index":3,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Please enter your draw per funding part in the tables below. The total amounts entered in this sheet should match your Housing Contract System draw for this month."]
[]
[null,"Date"]
[]
[]
[null,"Entitlement Admin"]
[null,"NonEntitlement Admin"]
[null,"Total Admin",{"$f":"SUM(C6:C7)","v":0}]
[]
[null,"Entitlement Project"]
[null,"NonEntitlement Project"]
[null,"Total Project",{"$f":"SUM(C10:C11)","v":0}]
[]
[null,"Total Draw",{"$f":"SUM(C8,C12)","v":0}]

{"sheet":"Sheet4","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Race","Ethnicity"]
["American Indian/Alaskan Native","Hispanic or Latino"]
["Asian","Non Hispanic or Latino"]
["Black/African-American"]
["Native Hawaiian/Pacific Islander"]
["White"]
["American Indian/Alaskan Native & White"]
["Asian & White"]
["Black/African American & White"]
["Amer. Indian/Alaskan Native & Black/African American"]
["Other Multi-Racial"]
["Race Unknown"]