{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Definitions","Instructions ","Strategic Site Plan","Facility Data","Population Data","Parking Inventory","Current Peak Demand","Future Growth","Future Demand","Future Supply","Surplus Deficit","Demand Ratio Matrix"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":5,"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":"Definitions","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
["Basic Definitions"]
[]
[null,"Peak Hour/Shift Population Data","The point at which the number of individuals within each population group reaches its highest level throughout the day, i.e., peak shift."]
[]
[null,"Calculated Daily Estimate","is the estimate of population data gathered by the hospital's administration on daily basis"]
[]
[null,"Peak Shift","Is usually defined as weekdays between 7AM and 3PM but may differ based on the characteristics of the medical campus"]
[]
[null,"Percent Average Bed Occupancy","The average number of beds occupied daily by patients divided by the total number of beds.  Example; 100 licensed beds, annual average daily occupancy 75 beds, average bed occupancy equals 75."]
[]
[null,"Practical Capacity","Refers to the operational efficiency of a parking facility or system and measures the stress on the parking system in relation to parking demand. A parking facility is perceived by its users to be at full operational capacity when occupancy levels reach 90-95%. Potential parkers find it difficult to locate an available space once this level is exceeded.  This figure is automatically applied within the Parking Inventory and Future Supply tables."]
[]
[null,"Peak Parking Demand","The point at which demand for parking reaches its highest level."]
[]
[null,"Percent Average Annual Growth/Decline"," is the change in population by year, and is calculated by dividing the difference between the projected and the current population by the current population. ( Projected Population-Current Population)/Current Population."]
[]
[null,"Parking Surplus/Deficit","Parking surplus is the number of spaces in excess of what the demanded for parking is. Parking deficit is the number of spaces by which the current supply of parking is less than the demand for parking.   Both definitions are typically applied to peak parking use/demand periods.   These figures are automatically calculated within the Surplus/Deficit table"]
[]
[null,"Space Allocation","Parking restrictions for a specific parking space/parking lot by user group, i.e. patient, physician, visitor, etc"]

{"sheet":"Instructions ","index":1,"n_rows":24,"n_cols":2,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
[]
["Instructions"]
["Step 1:","Read the Preamble to the Parking Demand Model "]
[]
["Step 2:","Request copy of Strategic Site Plan from Office of Construction Facilities Management and insert into Site Plan worksheet."]
[]
["Step 3:","Enter Facility Data (see blue and yellow highlighted cells) into Table 1. Note that the average daily census  should be entered for each of the categories. ( Average is defined as the sum of all the given elements divided by the total number of elements). For \"other\" categories (see yellow highlight) please note in the dialog box the type of bed and its associated inpatient treatment.  Include definition of average daily census."]
[]
["Step 4:","Enter Population Data (blue and yellow cells) into Tables 2a and 2b.  Note that for all employee, physician, volunteer, students and other groups in Table 2a peak shift data is required.  Peak shift is generally defined as weekdays between 7AM and 3PM. For all inpatient and outpatients, average daily population data is required.                                                                                                                                                                             "]
[null,"Full and part-time employee group categories include but are not limited to administrative staff, direct patient care givers, w/o compensation employees, canteen workers, custodial workers, lab technicians, researchers, medical school administrative and teaching staff, and any medical or non-medical employees who are assigned to work on the medical center campus on a long-term basis.   Physician categories include but should not be limited to consulting/attending physicians, affiliated medical school physicians, or any physicians that was full-access working privileges at the medical center.  For \"other\" categories (highlighted yellow) please note in the dialog box the employee classification and their associated job responsibilities."]
[null,"For inpatients and outpatients data (Table 2b), please first include the actual average daily volumes in column I. In case the actual daily data was not recorded/available, then enter the annual inpatient and outpatient data provided by ProClarity in column G. For visitors and vendors, please first include the actual daily counts in column G. In case visitors and vendors population data was not available/recorded, do not enter anything in column G. The PDM formula will automatically calculates the daily estimates. "]
[null,"Note that as average daily population volumes for inpatient visitors, non-treatment visitors, vendors, and other visitors are typically not recorded by VAMC/VISN systems it has been calculated automatically based on industry standards associated with the number of hospital, domiciliary, nursing home, SCI, and other beds."]
[]
["Step 5:","Enter current Parking Inventory (see blue and yellow cells) into Table 3.  Include permanently owned/operated on and off-site parking facilities and temporary on-site facilities but exclude those off-site facilities that are leased and/or under short-term ownership/operation.  For \"other\" VAMC parking facilities (see yellow highlighted cells) please note in the dialog box the location (on vs. off-site) and surface condition (asphalt vs. gravel). If off-site also note whether the facility(ies) have shuttle service."]
[]
["Step 6:","Select appropriate VAMC characteristic on the Current Peak Demand table (Table 4).  By pressing the applicable \"macro button\" the peak parking demand ratios for each campus user group from the Demand Ratio Matrix tab will be automatically applied. Please reference the Parking Demand Model addendum for background on urban, suburban, rural and strong, mixed, and weak transit and car/vanpool characteristics.  VAMC/VISN representatives must include justification of the selected characteristics when submitting the PDM to CFM for review and approval.  Written justification must include information on public transit opportunities, employee car/vanpool participation and where available information on employee, patient, visitor travel mode split (car, bus, light rail, walk, etc.) and commuting patterns.   Once the appropriate characteristics macro button is selected the peak parking demand for each user group will be automatically calculated. Note that parking demand for fleet vehicles are already included in the employee demand figures.  AFTER SELECTING THE TYPE OF THE FACILITY IN TABLE 4, PLEASE PLACE AN X IN THE BOX NEXT TO THE MACRO BUTTON"]
[null,"Note that the analysis of current parking demand includes a recommendation for the provision of ADA accessible handicapped parking spaces.  This recommendation is based on survey findings at the ten (10) pilot institutions that found that between 7% and 16% of vehicles parked on a VA campus during the peak hour displayed handicapped hangtags and/or license plates.  At present, the number of handicapped accessible spaces on a VA medical center is 3% of the total supply.   While the provision of handicapped spaces should continue to meet or exceed ADA standards and should their placement should be at the discretion of VAMC/VISN planners and asset managers, the model recommends the number of spaces that should be provided under two scenarios; with patient and visitor valet service and without valet service, with the with valet recommendation acknowledging that many handicapped patients and visitors would chose to use that service."]
[]
["Step 7:","Enter annual growth projections of employee, physician, and patient/visitor into the Future Growth table (Table 5). ( See the Definitions Tab of this model for instructions to calculate  growth)   VAMC/VISN representatives must include justification for the annual growth rates to include source and definitions when submitting the PDM to CFM for review and approval. Future parking demand calculations (see Table 6) and ultimately estimates of future parking surplus or deficit (Table8) will be impacted by these figures."]
[]
["Step 8:","Enter annual estimates for the loss or gain of parking spaces into the Future Supply table (see Table 7a). Note that in order for the model to calculate future supply,  the space allocation column in Table 7a should be filled out. Negative numbers indicate loss and positive numbers indicate gain of parking spaces."]
[]
[null,"Note that the Demand Ratio Matrix tab of this Excel spread sheet is password protected, You CANNOT enter any data into this tab. "]

{"sheet":"Strategic Site Plan","index":2,"n_rows":70,"n_cols":10,"rows_kept":70,"cut":false,"hidden":false,"merged":[[67,4,67,6],[67,8,67,9],[53,6,53,7],[55,6,55,7],[57,5,57,9],[59,5,59,9],[46,6,46,7],[47,6,47,7],[49,6,49,7],[51,6,51,7],[61,5,61,9],[65,4,65,8]]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
["Strategic Site Plan (Source: VA Office of Construction Facilities Management)",null,null,null,null,null,null,"To be provided by OOCFM"]
[]
[]
[]
[null,"VHA","Enter Facility Name, City & State Here",null,null,null,null,null,null,"Enter VISN/VAMC Number"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"INSERT OOCFM PROVIDED FACILITY MAP HERE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"INSERT OOCFM PROVIDED FACILITY DATA HERE"]
[]
[null,null,null,null,"Address:"]
[]
[null,null,null,null,"Acreage:","VHA","NCA","Available","Outleased","VA Total"]
[]
[]
[null,null,null,null,"Buildings:","Existing","Historic","EHR Seismic","Vacant","Avg Age SF"]
[]
[]
[null,null,null,null,"Gross Sq Feet","Existing","Ideal","Vacant","Out-Leased","In-Leased"]
[]
[]
[null,null,null,null,"Initiatives:","Complete","Scope",null,"Cost","Funded"]
[null,null,null,null,"Majors:"]
[]
[]
[]
[null,"Context Map"]
[]
[]
[]
[null,"VISN:"]
[]
[null,"Mission:",null,null,"CARES"]
[]
[null,"Patients:",null,null,"EUI's:"]
[]
[null,"Affiliations:"]
[]
[null,"VBA:",null,null,"ESPC:"]
[]
[null,"NCA:",null,null,"FCA Total Technical Corrections Cost:"]
[]
[null,"Other Programs:",null,null,"Community-Based Clinics:",null,null,null,"Vet Centers:"]
[]
[null,"Department of Veterans Affairs Office of Construction & Facilities Management  (00CFM3A)",null,null,null,null,null,null,null,"January  2009"]

{"sheet":"Facility Data","index":3,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[[34,1,36,4],[11,2,11,5],[5,2,5,8],[10,2,10,5],[12,2,12,5]]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
["VAMC Facility Data"]
["Table 1"]
[]
[null,"Facility Name"]
[null,"Facility Address"]
[null,"VISN Identification Number "]
[null,"Facility Identification Number"]
[null,"Date Data Provided (Mon/Day/Year)"]
[]
[null,"Name of Data Provider"]
[null,"Job Title"]
[null,"Contact Information (phone/e-mail)"]
[]
[null,"Facility Building Gross Square Feet"]
[]
[null,"Number of Hospital Beds"]
[null,"Percent Avg. Bed Occupancy (Avg.Daily Census)"]
[]
[null,"Number of Domiciliary Beds"]
[null,"Percent Avg. Bed Occupancy (Avg.Daily Census)"]
[]
[null,"Number of CLC Beds"]
[null,"Percent Avg. Bed Occupancy (Avg.Daily Census)"]
[]
[null,"Number of Nursing Home Beds"]
[null,"Percent Avg. Bed Occupancy (Avg.Daily Census)"]
[]
[null,"Number of Spinal Cord Injury Beds"]
[null,"Percent Avg. Bed Occupancy (Avg.Daily Census)"]
[]
[null,"Other Beds (please describe below)"]
[null,"Percent Avg. Bed Occupancy (Avg.Daily Census)"]

{"sheet":"Population Data","index":4,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[[24,1,26,2],[17,5,19,7],[30,1,32,2],[32,5,34,7]]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
["VAMC Peak Hour/Shift Population Data"]
[{"$f":"+'Facility Data'!C5","v":0}]
[]
["Table 2a",null,null,null,"Table 2b"]
[null,null,"Peak",null,null,null,"ProClarity","Calculated","Actual Average"]
[null,null,"Shift Volumes",null,null,null,"Actual Annual","Daily Est.","Daily Volumes"]
["Employees, Physicians, Students, & Others",null,null,null,"Inpatients and Outpatients"]
[]
[null,"Full-Time Employees",null,null,null,"Outpatients",null,{"$f":"ROUND(+G10/260,0)","v":0}]
[]
[null,"Part-Time Employees",null,null,null,"Total Inpatient Admissions of All Beds",null,{"$f":"ROUND(+G12/365,0)","v":0}]
[]
[null,"Physicians",null,null,null,"Emergency Department",null,{"$f":"ROUND(+G14/365,0)","v":0}]
[]
[null,"Service Organization Emp.",null,null,null,"Other Outpatient Services (describe below)"]
[]
[null,"Volunteers"]
[]
[null,"Resident & Other Students"]
[]
[null,"Other Full-time Staff/Physicians (describe below)",null,null,"Visitors & Vendors/Contractors",null,"Actual Daily ",null,"Calculated "]
[null,null,null,null,null,null,"Count",null,"Daily Est."]
[]
[null,null,null,null,null,"Inpatient Visitors (determined by PDM formula)",null,null,{"$f":"IF((+'Facility Data'!C17*'Facility Data'!C18)+('Facility Data'!C20*'Facility Data'!C21*0.5)+('Facility Data'!C26*'Facility Data'!C27*0.5)+('Facility Data'!C29*'Facility Data'!C30*0.5)+('Facility Data'!C32*'Facility Data'!C33)>10,ROUND((+'Facility Data'!C17*'Facility Data'!C18)+('Facility Data'!C20*'Facility Data'!C21*0.5)+('Facility Data'!C26*'Facility Data'!C27*0.5)+('Facility Data'!C29*'Facility Data'!C30*0.5)+('Facility Data'!C32*'Facility Data'!C33),-1),ROUND((+'Facility Data'!C17*'Facility Data'!C18)+('Facility Data'!C20*'Facility Data'!C21*0.5)+('Facility Data'!C26*'Facility Data'!C27*0.5)+('Facility Data'!C29*'Facility Data'!C30*0.5)+('Facility Data'!C32*'Facility Data'!C33),0))","v":0}]
[]
[null,null,null,null,null,"Non-Treatment Visitors (determined by PDM formula)",null,null,{"$f":"IF((+'Facility Data'!C17*4500)/80000>10, ROUND((+'Facility Data'!C17*4500)/80000,-1),ROUND((+'Facility Data'!C17*4500)/80000,0))","v":0}]
[]
[null,"Other Part-time Staff/Physicians (describe below)",null,null,null,"Vendors (determined by PDM formula)",null,null,{"$f":"IF(+'Facility Data'!C15/30000>10, ROUND(+'Facility Data'!C15/30000,-1),ROUND(+'Facility Data'!C15/30000,0))","v":0}]
[]
[null,null,null,null,null,"Other Visitors (quantify and describe below)"]

{"sheet":"Parking Inventory","index":5,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[17,1,19,2],[26,1,28,2],[36,1,38,2],[43,1,45,2]]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
["VAMC Parking Data"]
[{"$f":"+'Facility Data'!C5","v":0}]
["Table 3"]
[null,null,"Current",null,"Practical"]
[null,null,"Inventory",null,"Capacity"]
[]
["Open/Unrestricted Parking (available to anyone)",null,null,null,{"$f":"ROUND(+C8*0.9,0)","v":0}]
[]
["Employee/Physician/Student Parking"]
[null,"Open/Unrestricted",null,null,{"$f":"ROUND(+C11*0.95,0)","v":0}]
[null,"Car/Vanpool",null,null,{"$f":"ROUND(+C12*0.95,0)","v":0}]
[null,"Volunteer",null,null,{"$f":"ROUND(+C13*0.95,0)","v":0}]
[null,"Student",null,null,0]
[null,"Handicapped Accessible",null,null,0]
[null,"Other (describe below)",null,null,0]
["Total Employee/Student",null,{"$f":"SUM(C11:C16)","v":0},null,{"$f":"SUM(E11:E16)","v":0}]
[]
[]
[]
[]
["Physicians"]
[null,"Reserved/Restricted",null,null,{"$f":"ROUND(+C23*0.95,0)","v":0}]
[null,"Open/Unrestricted",null,null,{"$f":"ROUND(+C24*0.95,0)","v":0}]
[null,"Other (describe below)",null,null,{"$f":"ROUND(+C25*0.95,0)","v":0}]
["Total Physician Spaces",null,{"$f":"+C23+C24+C25","v":0},null,{"$f":"+E23+E24+E25","v":0}]
[]
[]
[]
[]
["Patient/Visitor Parking"]
[null,"Self Park",null,null,{"$f":"ROUND(+C32*0.9,0)","v":0}]
[null,"Valet ",null,null,{"$f":"ROUND(+C33*0.9,0)","v":0}]
[null,"Handicapped Accessible",null,null,{"$f":"ROUND(+C34*0.9,0)","v":0}]
[null,"Other (describe below)",null,null,{"$f":"ROUND(+C35*0.9,0)","v":0}]
["Total Patient/Visitor Spaces",null,{"$f":"+C32+C33+C34+C35","v":0},null,{"$f":"+E32+E33+E34+E35","v":0}]
[]
[]
[]
[]
["Government/Fleet Vehicles",null,null,null,{"$f":"ROUND(+C41*0.95,0)","v":0}]
[]
["Total Other Parking (describe below)",null,null,null,{"$f":"ROUND(+C43*0.95,0)","v":0}]
[]
[]
[]
[]
["TOTAL PARKING INVENTORY",null,{"$f":"+C41+C36+C26+C17+C8","v":0},null,{"$f":"+E41+E36+E26+E17+E8","v":0}]

{"sheet":"Current Peak Demand","index":6,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
["VAMC Peak Parking Demand Ratios"]
[{"$f":"+'Facility Data'!C5","v":0},null,null,null,null,null,"VAMC"]
["Table 4",null,null,null,null,null,"Characteristics"]
[null,null,null,null,null,null,"(Select One)",null,null,null,"PLACE AN X IN THE BOX NEXT TO THE MACRO BUTTON"]
[null,null,"Peak ","Selected","Peak Parking",null,"Urban"]
["Population Group",null,"Population","Demand Ratio","Demand",null,"Strong"]
["Staffing"]
[null,"Full-time",{"$f":"+'Population Data'!C10+'Population Data'!C22","v":0},0.6,{"$f":"IF(C9*D9>10, ROUND(C9*D9,-1),ROUND(C9*D9,0))","v":0},null,"Urban"]
[null,"Part-time",{"$f":"+'Population Data'!C12+'Population Data'!C29","v":0},0.5,0,null,"Mixed"]
[null,"Physicians",{"$f":"+'Population Data'!C14","v":0},0.75,0]
[null,"Service Organization",{"$f":"+'Population Data'!C16","v":0},0.65,0,null,"Urban "]
[null,"Volunteers",{"$f":"+'Population Data'!C18","v":0},0.2,0,null,"Weak"]
[null,"Students",{"$f":"+'Population Data'!C20","v":0},0.2,0]
["Total Staffing",null,{"$f":"SUM(C9:C14)","v":0},"---",{"$f":"SUM(E9:E14)","v":0},null,"Suburban"]
["Patients",null,null,null,null,null,"Strong"]
[null,"Outpatients",{"$f":"IF('Population Data'!I10>=1,'Population Data'!I10,'Population Data'!H10)","v":0},0.3,{"$f":"IF(C17*D17>10, ROUND(C17*D17,-1),ROUND(C17*D17,0))","v":0}]
[null,"Inpatient Admissions",{"$f":"IF('Population Data'!I12>=1,'Population Data'!I12,'Population Data'!H12)","v":0},0.3,{"$f":"IF(C18*D18>10, ROUND(C18*D18,-1),ROUND(C18*D18,0))","v":0},null,"Suburban"]
[null,"ED Patients",{"$f":"IF('Population Data'!I14>=1,'Population Data'!I14,'Population Data'!H14)","v":0},0.4,{"$f":"IF(C19*D19>10, ROUND(C19*D19,-1),ROUND(C19*D19,0))","v":0},null,"Mixed"]
["Total Patients",null,{"$f":"SUM(C17:C19)","v":0},"---",{"$f":"SUM(E17:E19)","v":0}]
["Visitors",null,null,null,null,null,"Suburban"]
[null,"Inpatient & ED Visitors",{"$f":"IF('Population Data'!G25>=1,'Population Data'!G25,'Population Data'!I25)","v":0},0.4,{"$f":"IF(C22*D22>10, ROUND(C22*D22,-1),ROUND(C22*D22,0))","v":0},null,"Weak"]
[null,"Non-treatment Visitors",{"$f":"IF('Population Data'!G27>=1,'Population Data'!G27,'Population Data'!I27)","v":0},0.45,{"$f":"IF(C23*D23>10, ROUND(C23*D23,-1),ROUND(C23*D23,0))","v":0}]
[null,"Vendors",{"$f":"IF('Population Data'!G29>=1,'Population Data'!G29,'Population Data'!I29)","v":0},0.4,{"$f":"IF(C24*D24>10, ROUND(C24*D24,-1),ROUND(C24*D24,0))","v":0},null,"Rural"]
["Total Visitors",null,{"$f":"SUM(C22:C24)","v":0},"---",{"$f":"SUM(E22:E24)","v":0},null,"Mixed"]
["Total ",null,{"$f":"+C15+C20+C25","v":0},"---",{"$f":"+E15+E20+E25","v":0}]
[null,null,null,null,null,null,"Rural"]
["Recommended Provision for Handicapped Acccessible Spaces",null,null,null,null,null,"Weak"]
[null,"w/ Patient & Visitor Valet Service (3% of total demand) =",null,null,{"$f":"ROUND(+E26*0.03,0)","v":0}]
[null,"w/o Patient & Visitor Valet Service (7% of total demand) =",null,null,{"$f":"ROUND(+E26*0.07,0)","v":0}]

{"sheet":"Future Growth","index":7,"n_rows":26,"n_cols":22,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
["VAMC Average Annual Growth/Decline Projections"]
[{"$f":"+'Facility Data'!C5","v":0}]
["Table 5"]
[]
[]
["Population Group",null,{"$f":"'Facility Data'!$E$9+1","v":1},{"$f":"C7+1","v":2},{"$f":"D7+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Staffing"]
[null,"Full-time"]
[null,"Part-time"]
[null,"Physicians"]
[null,"Service Organization"]
[null,"Volunteers"]
[null,"Students"]
["Patients"]
[null,"Outpatients"]
[null,"Inpatient Admissions"]
[null,"ED Patients"]
["Visitors"]
[null,"Inpatient & ED Visitors"]
[null,"Non-treatment Visitors"]
[null,"Vendors"]
[]
[]
["Note:"," Average annual gowth/decline projection is the change in population by year, and is calculated by deviding the difference between the projected population "]
[null,"and the current population by the current population  (( Projected Pop. - Current Pop.)/Current Pop)."]

{"sheet":"Future Demand","index":8,"n_rows":30,"n_cols":23,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
["VAMC Existing and Future Peak Parking Demand"]
[{"$f":"+'Facility Data'!C5","v":0}]
["Table 6"]
[]
[null,null,"Peak Parking","Future Peak Parking Demand"]
["Population Group",null,"Demand",{"$f":"+'Facility Data'!E9+1","v":1},{"$f":"+D7+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Staffing"]
[null,"Full-time",{"$f":"+'Current Peak Demand'!E9","v":0},{"$f":"ROUND(+C9+(C9*'Future Growth'!C9),0)","v":0},{"$f":"ROUND(D9+(D9*'Future Growth'!D9),0)","v":0},{"$f":"ROUND(E9+(E9*'Future Growth'!E9),0)","v":0},{"$f":"ROUND(F9+(F9*'Future Growth'!F9),0)","v":0},{"$f":"ROUND(G9+(G9*'Future Growth'!G9),0)","v":0},{"$f":"ROUND(H9+(H9*'Future Growth'!H9),0)","v":0},{"$f":"ROUND(I9+(I9*'Future Growth'!I9),0)","v":0},{"$f":"ROUND(J9+(J9*'Future Growth'!J9),0)","v":0},{"$f":"ROUND(K9+(K9*'Future Growth'!K9),0)","v":0},{"$f":"ROUND(L9+(L9*'Future Growth'!L9),0)","v":0},{"$f":"ROUND(M9+(M9*'Future Growth'!M9),0)","v":0},{"$f":"ROUND(N9+(N9*'Future Growth'!N9),0)","v":0},{"$f":"ROUND(O9+(O9*'Future Growth'!O9),0)","v":0},{"$f":"ROUND(P9+(P9*'Future Growth'!P9),0)","v":0},{"$f":"ROUND(Q9+(Q9*'Future Growth'!Q9),0)","v":0},{"$f":"ROUND(R9+(R9*'Future Growth'!R9),0)","v":0},{"$f":"ROUND(S9+(S9*'Future Growth'!S9),0)","v":0},{"$f":"ROUND(T9+(T9*'Future Growth'!T9),0)","v":0},{"$f":"ROUND(U9+(U9*'Future Growth'!U9),0)","v":0},{"$f":"ROUND(V9+(V9*'Future Growth'!V9),0)","v":0}]
[null,"Part-time",{"$f":"+'Current Peak Demand'!E10","v":0},{"$f":"ROUND(+C10+(C10*'Future Growth'!C10),0)","v":0},{"$f":"ROUND(D10+(D10*'Future Growth'!D10),0)","v":0},{"$f":"ROUND(E10+(E10*'Future Growth'!E10),0)","v":0},{"$f":"ROUND(F10+(F10*'Future Growth'!F10),0)","v":0},{"$f":"ROUND(G10+(G10*'Future Growth'!G10),0)","v":0},{"$f":"ROUND(H10+(H10*'Future Growth'!H10),0)","v":0},{"$f":"ROUND(I10+(I10*'Future Growth'!I10),0)","v":0},{"$f":"ROUND(J10+(J10*'Future Growth'!J10),0)","v":0},{"$f":"ROUND(K10+(K10*'Future Growth'!K10),0)","v":0},{"$f":"ROUND(L10+(L10*'Future Growth'!L10),0)","v":0},{"$f":"ROUND(M10+(M10*'Future Growth'!M10),0)","v":0},{"$f":"ROUND(N10+(N10*'Future Growth'!N10),0)","v":0},{"$f":"ROUND(O10+(O10*'Future Growth'!O10),0)","v":0},{"$f":"ROUND(P10+(P10*'Future Growth'!P10),0)","v":0},{"$f":"ROUND(Q10+(Q10*'Future Growth'!Q10),0)","v":0},{"$f":"ROUND(R10+(R10*'Future Growth'!R10),0)","v":0},{"$f":"ROUND(S10+(S10*'Future Growth'!S10),0)","v":0},{"$f":"ROUND(T10+(T10*'Future Growth'!T10),0)","v":0},{"$f":"ROUND(U10+(U10*'Future Growth'!U10),0)","v":0},{"$f":"ROUND(V10+(V10*'Future Growth'!V10),0)","v":0}]
[null,"Physicians",{"$f":"+'Current Peak Demand'!E11","v":0},{"$f":"ROUND(+C11+(C11*'Future Growth'!C11),0)","v":0},{"$f":"ROUND(D11+(D11*'Future Growth'!D11),0)","v":0},{"$f":"ROUND(E11+(E11*'Future Growth'!E11),0)","v":0},{"$f":"ROUND(F11+(F11*'Future Growth'!F11),0)","v":0},{"$f":"ROUND(G11+(G11*'Future Growth'!G11),0)","v":0},{"$f":"ROUND(H11+(H11*'Future Growth'!H11),0)","v":0},{"$f":"ROUND(I11+(I11*'Future Growth'!I11),0)","v":0},{"$f":"ROUND(J11+(J11*'Future Growth'!J11),0)","v":0},{"$f":"ROUND(K11+(K11*'Future Growth'!K11),0)","v":0},{"$f":"ROUND(L11+(L11*'Future Growth'!L11),0)","v":0},{"$f":"ROUND(M11+(M11*'Future Growth'!M11),0)","v":0},{"$f":"ROUND(N11+(N11*'Future Growth'!N11),0)","v":0},{"$f":"ROUND(O11+(O11*'Future Growth'!O11),0)","v":0},{"$f":"ROUND(P11+(P11*'Future Growth'!P11),0)","v":0},{"$f":"ROUND(Q11+(Q11*'Future Growth'!Q11),0)","v":0},{"$f":"ROUND(R11+(R11*'Future Growth'!R11),0)","v":0},{"$f":"ROUND(S11+(S11*'Future Growth'!S11),0)","v":0},{"$f":"ROUND(T11+(T11*'Future Growth'!T11),0)","v":0},{"$f":"ROUND(U11+(U11*'Future Growth'!U11),0)","v":0},{"$f":"ROUND(V11+(V11*'Future Growth'!V11),0)","v":0}]
[null,"Service Organization",{"$f":"+'Current Peak Demand'!E12","v":0},{"$f":"ROUND(+C12+(C12*'Future Growth'!C12),0)","v":0},{"$f":"ROUND(D12+(D12*'Future Growth'!D12),0)","v":0},{"$f":"ROUND(E12+(E12*'Future Growth'!E12),0)","v":0},{"$f":"ROUND(F12+(F12*'Future Growth'!F12),0)","v":0},{"$f":"ROUND(G12+(G12*'Future Growth'!G12),0)","v":0},{"$f":"ROUND(H12+(H12*'Future Growth'!H12),0)","v":0},{"$f":"ROUND(I12+(I12*'Future Growth'!I12),0)","v":0},{"$f":"ROUND(J12+(J12*'Future Growth'!J12),0)","v":0},{"$f":"ROUND(K12+(K12*'Future Growth'!K12),0)","v":0},{"$f":"ROUND(L12+(L12*'Future Growth'!L12),0)","v":0},{"$f":"ROUND(M12+(M12*'Future Growth'!M12),0)","v":0},{"$f":"ROUND(N12+(N12*'Future Growth'!N12),0)","v":0},{"$f":"ROUND(O12+(O12*'Future Growth'!O12),0)","v":0},{"$f":"ROUND(P12+(P12*'Future Growth'!P12),0)","v":0},{"$f":"ROUND(Q12+(Q12*'Future Growth'!Q12),0)","v":0},{"$f":"ROUND(R12+(R12*'Future Growth'!R12),0)","v":0},{"$f":"ROUND(S12+(S12*'Future Growth'!S12),0)","v":0},{"$f":"ROUND(T12+(T12*'Future Growth'!T12),0)","v":0},{"$f":"ROUND(U12+(U12*'Future Growth'!U12),0)","v":0},{"$f":"ROUND(V12+(V12*'Future Growth'!V12),0)","v":0}]
[null,"Volunteers",{"$f":"+'Current Peak Demand'!E13","v":0},{"$f":"ROUND(+C13+(C13*'Future Growth'!C13),0)","v":0},{"$f":"ROUND(D13+(D13*'Future Growth'!D13),0)","v":0},{"$f":"ROUND(E13+(E13*'Future Growth'!E13),0)","v":0},{"$f":"ROUND(F13+(F13*'Future Growth'!F13),0)","v":0},{"$f":"ROUND(G13+(G13*'Future Growth'!G13),0)","v":0},{"$f":"ROUND(H13+(H13*'Future Growth'!H13),0)","v":0},{"$f":"ROUND(I13+(I13*'Future Growth'!I13),0)","v":0},{"$f":"ROUND(J13+(J13*'Future Growth'!J13),0)","v":0},{"$f":"ROUND(K13+(K13*'Future Growth'!K13),0)","v":0},{"$f":"ROUND(L13+(L13*'Future Growth'!L13),0)","v":0},{"$f":"ROUND(M13+(M13*'Future Growth'!M13),0)","v":0},{"$f":"ROUND(N13+(N13*'Future Growth'!N13),0)","v":0},{"$f":"ROUND(O13+(O13*'Future Growth'!O13),0)","v":0},{"$f":"ROUND(P13+(P13*'Future Growth'!P13),0)","v":0},{"$f":"ROUND(Q13+(Q13*'Future Growth'!Q13),0)","v":0},{"$f":"ROUND(R13+(R13*'Future Growth'!R13),0)","v":0},{"$f":"ROUND(S13+(S13*'Future Growth'!S13),0)","v":0},{"$f":"ROUND(T13+(T13*'Future Growth'!T13),0)","v":0},{"$f":"ROUND(U13+(U13*'Future Growth'!U13),0)","v":0},{"$f":"ROUND(V13+(V13*'Future Growth'!V13),0)","v":0}]
[null,"Students",{"$f":"+'Current Peak Demand'!E14","v":0},{"$f":"ROUND(+C14+(C14*'Future Growth'!C14),0)","v":0},{"$f":"ROUND(D14+(D14*'Future Growth'!D14),0)","v":0},{"$f":"ROUND(E14+(E14*'Future Growth'!E14),0)","v":0},{"$f":"ROUND(F14+(F14*'Future Growth'!F14),0)","v":0},{"$f":"ROUND(G14+(G14*'Future Growth'!G14),0)","v":0},{"$f":"ROUND(H14+(H14*'Future Growth'!H14),0)","v":0},{"$f":"ROUND(I14+(I14*'Future Growth'!I14),0)","v":0},{"$f":"ROUND(J14+(J14*'Future Growth'!J14),0)","v":0},{"$f":"ROUND(K14+(K14*'Future Growth'!K14),0)","v":0},{"$f":"ROUND(L14+(L14*'Future Growth'!L14),0)","v":0},{"$f":"ROUND(M14+(M14*'Future Growth'!M14),0)","v":0},{"$f":"ROUND(N14+(N14*'Future Growth'!N14),0)","v":0},{"$f":"ROUND(O14+(O14*'Future Growth'!O14),0)","v":0},{"$f":"ROUND(P14+(P14*'Future Growth'!P14),0)","v":0},{"$f":"ROUND(Q14+(Q14*'Future Growth'!Q14),0)","v":0},{"$f":"ROUND(R14+(R14*'Future Growth'!R14),0)","v":0},{"$f":"ROUND(S14+(S14*'Future Growth'!S14),0)","v":0},{"$f":"ROUND(T14+(T14*'Future Growth'!T14),0)","v":0},{"$f":"ROUND(U14+(U14*'Future Growth'!U14),0)","v":0},{"$f":"ROUND(V14+(V14*'Future Growth'!V14),0)","v":0}]
["Total Staffing",null,{"$f":"SUM(C9:C14)","v":0},{"$f":"SUM(D9:D14)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Patients"]
[null,"Outpatients",{"$f":"+'Current Peak Demand'!E17","v":0},{"$f":"ROUND(C17+(C17*'Future Growth'!C16),0)","v":0},{"$f":"ROUND(D17+(D17*'Future Growth'!D16),0)","v":0},{"$f":"ROUND(E17+(E17*'Future Growth'!E16),0)","v":0},{"$f":"ROUND(F17+(F17*'Future Growth'!F16),0)","v":0},{"$f":"ROUND(G17+(G17*'Future Growth'!G16),0)","v":0},{"$f":"ROUND(H17+(H17*'Future Growth'!H16),0)","v":0},{"$f":"ROUND(I17+(I17*'Future Growth'!I16),0)","v":0},{"$f":"ROUND(J17+(J17*'Future Growth'!J16),0)","v":0},{"$f":"ROUND(K17+(K17*'Future Growth'!K16),0)","v":0},{"$f":"ROUND(L17+(L17*'Future Growth'!L16),0)","v":0},{"$f":"ROUND(M17+(M17*'Future Growth'!M16),0)","v":0},{"$f":"ROUND(N17+(N17*'Future Growth'!N16),0)","v":0},{"$f":"ROUND(O17+(O17*'Future Growth'!O16),0)","v":0},{"$f":"ROUND(P17+(P17*'Future Growth'!P16),0)","v":0},{"$f":"ROUND(Q17+(Q17*'Future Growth'!Q16),0)","v":0},{"$f":"ROUND(R17+(R17*'Future Growth'!R16),0)","v":0},{"$f":"ROUND(S17+(S17*'Future Growth'!S16),0)","v":0},{"$f":"ROUND(T17+(T17*'Future Growth'!T16),0)","v":0},{"$f":"ROUND(U17+(U17*'Future Growth'!U16),0)","v":0},{"$f":"ROUND(V17+(V17*'Future Growth'!V16),0)","v":0}]
[null,"Inpatient Admissions",{"$f":"+'Current Peak Demand'!E18","v":0},{"$f":"ROUND(C18+(C18*'Future Growth'!C17),0)","v":0},{"$f":"ROUND(D18+(D18*'Future Growth'!D17),0)","v":0},{"$f":"ROUND(E18+(E18*'Future Growth'!E17),0)","v":0},{"$f":"ROUND(F18+(F18*'Future Growth'!F17),0)","v":0},{"$f":"ROUND(G18+(G18*'Future Growth'!G17),0)","v":0},{"$f":"ROUND(H18+(H18*'Future Growth'!H17),0)","v":0},{"$f":"ROUND(I18+(I18*'Future Growth'!I17),0)","v":0},{"$f":"ROUND(J18+(J18*'Future Growth'!J17),0)","v":0},{"$f":"ROUND(K18+(K18*'Future Growth'!K17),0)","v":0},{"$f":"ROUND(L18+(L18*'Future Growth'!L17),0)","v":0},{"$f":"ROUND(M18+(M18*'Future Growth'!M17),0)","v":0},{"$f":"ROUND(N18+(N18*'Future Growth'!N17),0)","v":0},{"$f":"ROUND(O18+(O18*'Future Growth'!O17),0)","v":0},{"$f":"ROUND(P18+(P18*'Future Growth'!P17),0)","v":0},{"$f":"ROUND(Q18+(Q18*'Future Growth'!Q17),0)","v":0},{"$f":"ROUND(R18+(R18*'Future Growth'!R17),0)","v":0},{"$f":"ROUND(S18+(S18*'Future Growth'!S17),0)","v":0},{"$f":"ROUND(T18+(T18*'Future Growth'!T17),0)","v":0},{"$f":"ROUND(U18+(U18*'Future Growth'!U17),0)","v":0},{"$f":"ROUND(V18+(V18*'Future Growth'!V17),0)","v":0}]
[null,"ED Patients",{"$f":"+'Current Peak Demand'!E19","v":0},{"$f":"ROUND(C19+(C19*'Future Growth'!C18),0)","v":0},{"$f":"ROUND(D19+(D19*'Future Growth'!D18),0)","v":0},{"$f":"ROUND(E19+(E19*'Future Growth'!E18),0)","v":0},{"$f":"ROUND(F19+(F19*'Future Growth'!F18),0)","v":0},{"$f":"ROUND(G19+(G19*'Future Growth'!G18),0)","v":0},{"$f":"ROUND(H19+(H19*'Future Growth'!H18),0)","v":0},{"$f":"ROUND(I19+(I19*'Future Growth'!I18),0)","v":0},{"$f":"ROUND(J19+(J19*'Future Growth'!J18),0)","v":0},{"$f":"ROUND(K19+(K19*'Future Growth'!K18),0)","v":0},{"$f":"ROUND(L19+(L19*'Future Growth'!L18),0)","v":0},{"$f":"ROUND(M19+(M19*'Future Growth'!M18),0)","v":0},{"$f":"ROUND(N19+(N19*'Future Growth'!N18),0)","v":0},{"$f":"ROUND(O19+(O19*'Future Growth'!O18),0)","v":0},{"$f":"ROUND(P19+(P19*'Future Growth'!P18),0)","v":0},{"$f":"ROUND(Q19+(Q19*'Future Growth'!Q18),0)","v":0},{"$f":"ROUND(R19+(R19*'Future Growth'!R18),0)","v":0},{"$f":"ROUND(S19+(S19*'Future Growth'!S18),0)","v":0},{"$f":"ROUND(T19+(T19*'Future Growth'!T18),0)","v":0},{"$f":"ROUND(U19+(U19*'Future Growth'!U18),0)","v":0},{"$f":"ROUND(V19+(V19*'Future Growth'!V18),0)","v":0}]
["Total Patients",null,{"$f":"SUM(C17:C19)","v":0},{"$f":"SUM(D17:D19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Visitors"]
[null,"Inpatient & ED Visitors",{"$f":"+'Current Peak Demand'!E22","v":0},{"$f":"ROUND(C22+(C22*'Future Growth'!C20),0)","v":0},{"$f":"ROUND(D22+(D22*'Future Growth'!D20),0)","v":0},{"$f":"ROUND(E22+(E22*'Future Growth'!E20),0)","v":0},{"$f":"ROUND(F22+(F22*'Future Growth'!F20),0)","v":0},{"$f":"ROUND(G22+(G22*'Future Growth'!G20),0)","v":0},{"$f":"ROUND(H22+(H22*'Future Growth'!H20),0)","v":0},{"$f":"ROUND(I22+(I22*'Future Growth'!I20),0)","v":0},{"$f":"ROUND(J22+(J22*'Future Growth'!J20),0)","v":0},{"$f":"ROUND(K22+(K22*'Future Growth'!K20),0)","v":0},{"$f":"ROUND(L22+(L22*'Future Growth'!L20),0)","v":0},{"$f":"ROUND(M22+(M22*'Future Growth'!M20),0)","v":0},{"$f":"ROUND(N22+(N22*'Future Growth'!N20),0)","v":0},{"$f":"ROUND(O22+(O22*'Future Growth'!O20),0)","v":0},{"$f":"ROUND(P22+(P22*'Future Growth'!P20),0)","v":0},{"$f":"ROUND(Q22+(Q22*'Future Growth'!Q20),0)","v":0},{"$f":"ROUND(R22+(R22*'Future Growth'!R20),0)","v":0},{"$f":"ROUND(S22+(S22*'Future Growth'!S20),0)","v":0},{"$f":"ROUND(T22+(T22*'Future Growth'!T20),0)","v":0},{"$f":"ROUND(U22+(U22*'Future Growth'!U20),0)","v":0},{"$f":"ROUND(V22+(V22*'Future Growth'!V20),0)","v":0}]
[null,"Non-treatment Visitors",{"$f":"+'Current Peak Demand'!E23","v":0},{"$f":"ROUND(C23+(C23*'Future Growth'!C21),0)","v":0},{"$f":"ROUND(D23+(D23*'Future Growth'!D21),0)","v":0},{"$f":"ROUND(E23+(E23*'Future Growth'!E21),0)","v":0},{"$f":"ROUND(F23+(F23*'Future Growth'!F21),0)","v":0},{"$f":"ROUND(G23+(G23*'Future Growth'!G21),0)","v":0},{"$f":"ROUND(H23+(H23*'Future Growth'!H21),0)","v":0},{"$f":"ROUND(I23+(I23*'Future Growth'!I21),0)","v":0},{"$f":"ROUND(J23+(J23*'Future Growth'!J21),0)","v":0},{"$f":"ROUND(K23+(K23*'Future Growth'!K21),0)","v":0},{"$f":"ROUND(L23+(L23*'Future Growth'!L21),0)","v":0},{"$f":"ROUND(M23+(M23*'Future Growth'!M21),0)","v":0},{"$f":"ROUND(N23+(N23*'Future Growth'!N21),0)","v":0},{"$f":"ROUND(O23+(O23*'Future Growth'!O21),0)","v":0},{"$f":"ROUND(P23+(P23*'Future Growth'!P21),0)","v":0},{"$f":"ROUND(Q23+(Q23*'Future Growth'!Q21),0)","v":0},{"$f":"ROUND(R23+(R23*'Future Growth'!R21),0)","v":0},{"$f":"ROUND(S23+(S23*'Future Growth'!S21),0)","v":0},{"$f":"ROUND(T23+(T23*'Future Growth'!T21),0)","v":0},{"$f":"ROUND(U23+(U23*'Future Growth'!U21),0)","v":0},{"$f":"ROUND(V23+(V23*'Future Growth'!V21),0)","v":0}]
[null,"Vendors",{"$f":"+'Current Peak Demand'!E24","v":0},{"$f":"ROUND(C24+(C24*'Future Growth'!C22),0)","v":0},{"$f":"ROUND(D24+(D24*'Future Growth'!D22),0)","v":0},{"$f":"ROUND(E24+(E24*'Future Growth'!E22),0)","v":0},{"$f":"ROUND(F24+(F24*'Future Growth'!F22),0)","v":0},{"$f":"ROUND(G24+(G24*'Future Growth'!G22),0)","v":0},{"$f":"ROUND(H24+(H24*'Future Growth'!H22),0)","v":0},{"$f":"ROUND(I24+(I24*'Future Growth'!I22),0)","v":0},{"$f":"ROUND(J24+(J24*'Future Growth'!J22),0)","v":0},{"$f":"ROUND(K24+(K24*'Future Growth'!K22),0)","v":0},{"$f":"ROUND(L24+(L24*'Future Growth'!L22),0)","v":0},{"$f":"ROUND(M24+(M24*'Future Growth'!M22),0)","v":0},{"$f":"ROUND(N24+(N24*'Future Growth'!N22),0)","v":0},{"$f":"ROUND(O24+(O24*'Future Growth'!O22),0)","v":0},{"$f":"ROUND(P24+(P24*'Future Growth'!P22),0)","v":0},{"$f":"ROUND(Q24+(Q24*'Future Growth'!Q22),0)","v":0},{"$f":"ROUND(R24+(R24*'Future Growth'!R22),0)","v":0},{"$f":"ROUND(S24+(S24*'Future Growth'!S22),0)","v":0},{"$f":"ROUND(T24+(T24*'Future Growth'!T22),0)","v":0},{"$f":"ROUND(U24+(U24*'Future Growth'!U22),0)","v":0},{"$f":"ROUND(V24+(V24*'Future Growth'!V22),0)","v":0}]
["Total Visitors",null,{"$f":"SUM(C22:C24)","v":0},{"$f":"SUM(D22:D24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total ",null,{"$f":"+C15+C20+C25","v":0},{"$f":"+D15+D20+D25","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Recommended Provision for Handicapped Acccessible Spaces"]
["w/ Patient & Visitor Valet Service (3%)",null,null,{"$f":"ROUND(+D26*0.03,0)","v":0},{"$f":"ROUND(+E26*0.03,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["w/o Patient & Visitor Valet Service (7%)",null,null,{"$f":"ROUND(D26*0.07,0)","v":0},{"$f":"ROUND(E26*0.07,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Future Supply","index":9,"n_rows":69,"n_cols":22,"rows_kept":69,"cut":false,"hidden":false,"merged":[[16,3,16,5],[23,3,23,5],[8,3,8,5],[8,6,8,7],[10,3,10,5],[11,3,11,5],[11,6,11,7],[10,6,10,7],[9,3,9,5],[9,6,9,7],[19,3,19,5],[23,6,23,7],[17,3,17,5],[19,6,19,7],[18,6,18,7],[17,6,17,7],[12,6,12,7],[14,6,14,7],[13,6,13,7],[12,3,12,5],[13,3,13,5],[14,3,14,5],[15,3,15,5],[15,6,15,7],[21,6,21,7],[20,3,20,5],[20,6,20,7],[22,3,22,5],[22,6,22,7],[21,3,21,5],[18,3,18,5],[16,6,16,7],[24,3,24,5],[43,6,43,7],[42,6,42,7],[41,3,41,5],[41,6,41,7],[30,6,30,7],[27,3,27,5],[31,6,31,7],[24,6,24,7],[25,3,25,5],[26,3,26,5],[25,6,25,7],[28,3,28,5],[26,6,26,7],[36,6,36,7],[37,6,37,7],[28,6,28,7],[34,6,34,7],[27,6,27,7],[29,6,29,7],[38,3,38,5],[45,3,45,5],[43,3,43,5],[34,3,34,5],[39,6,39,7],[47,6,47,7],[40,6,40,7],[44,6,44,7],[38,6,38,7],[33,6,33,7],[35,6,35,7],[32,3,32,5],[33,3,33,5],[46,6,46,7],[45,6,45,7],[40,3,40,5],[36,3,36,5],[39,3,39,5],[32,6,32,7],[29,3,29,5],[49,2,49,3],[30,3,30,5],[37,3,37,5],[44,3,44,5],[42,3,42,5],[31,3,31,5],[35,3,35,5],[46,3,46,5],[47,3,47,5]]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
["VAMC Existing and Future Peak Parking Demand"]
[{"$f":"+'Facility Data'!C5","v":0}]
["Table 7a, 7b & 7c"]
[]
["Existing Parking Spaces to be Displaced and/or Added"]
[null,null,"Displaced","Space",null,null,"Year to be"]
["Lot Name/Code","Capacity","Spaces","Allocation",null,null,"Displaced"]
[null,null,null,null,null,null,2011]
[null,null,null,null,null,null,2011]
[null,null,null,null,null,null,2012]
[null,null,null,null,null,null,2012]
[null,null,null,null,null,null,2013]
[null,null,null,null,null,null,2013]
[null,null,null,null,null,null,2014]
[null,null,null,null,null,null,2014]
[null,null,null,null,null,null,2015]
[null,null,null,null,null,null,2015]
[null,null,null,null,null,null,2016]
[null,null,null,null,null,null,2016]
[null,null,null,null,null,null,2017]
[null,null,null,null,null,null,2017]
[null,null,null,null,null,null,2018]
[null,null,null,null,null,null,2018]
[null,null,null,null,null,null,2019]
[null,null,null,null,null,null,2019]
[null,null,null,null,null,null,2020]
[null,null,null,null,null,null,2020]
[null,null,null,null,null,null,2021]
[null,null,null,null,null,null,2021]
[null,null,null,null,null,null,2022]
[null,null,null,null,null,null,2022]
[null,null,null,null,null,null,2023]
[null,null,null,null,null,null,2023]
[null,null,null,null,null,null,2024]
[null,null,null,null,null,null,2024]
[null,null,null,null,null,null,2025]
[null,null,null,null,null,null,2025]
[null,null,null,null,null,null,2026]
[null,null,null,null,null,null,2026]
[null,null,null,null,null,null,2027]
[null,null,null,null,null,null,2027]
[null,null,null,null,null,null,2028]
[null,null,null,null,null,null,2028]
[null,null,null,null,null,null,2029]
[null,null,null,null,null,null,2029]
[null,null,null,null,null,null,2030]
[null,null,null,null,null,null,2030]
[]
[null,"Current","Future Supply"]
["Space Allocation","Capacity",{"$f":"+'Facility Data'!E9+1","v":1},{"$f":"+C51+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Open/Unrestricted",{"$f":"+'Parking Inventory'!C8","v":0},{"$f":"+B52-(IF(D9=$A$52, C9, 0))-(IF(D10=$A$52, C10, 0))","v":0},{"$f":"+C52-(IF(D11=$A$52, C11, 0))-(IF(D12=$A$52, C12, 0))","v":0},{"$f":"+D52-(IF(D13=$A$52, C13, 0))-(IF(D14=$A$52, C14, 0))","v":0},{"$f":"+E52-(IF(D15=$A$52, C15, 0))-(IF(D16=$A$52, C16, 0))","v":0},{"$f":"+F52-(IF(D17=$A$52, C17, 0))-(IF(D18=$A$52, C18, 0))","v":0},{"$f":"+G52-(IF(D19=$A$52, C19, 0))-(IF(D20=$A$52, C20, 0))","v":0},{"$f":"+H52-(IF(D21=$A$52, C21, 0))-(IF(D22=$A$52, C22, 0))","v":0},{"$f":"+I52-(IF(D23=$A$52, C23, 0))-(IF(D24=$A$52, C24, 0))","v":0},{"$f":"+J52-(IF(D25=$A$52, C25, 0))-(IF(D26=$A$52, C26, 0))","v":0},{"$f":"+K52-(IF(D27=$A$52, C27, 0))-(IF(D28=$A$52, C28, 0))","v":0},{"$f":"+L52-(IF(D29=$A$52, C29, 0))-(IF(D30=$A$52, C30, 0))","v":0},{"$f":"+M52-(IF(D31=$A$52, C31, 0))-(IF(D32=$A$52, C32, 0))","v":0},{"$f":"+N52-(IF(D33=$A$52, C33, 0))-(IF(D34=$A$52, C34, 0))","v":0},{"$f":"+O52-(IF(D35=$A$52, C35, 0))-(IF(D36=$A$52, C36, 0))","v":0},{"$f":"+P52-(IF(D37=$A$52, C37, 0))-(IF(D38=$A$52, C38, 0))","v":0},{"$f":"+Q52-(IF(D39=$A$52, C39, 0))-(IF(D40=$A$52, C40, 0))","v":0},{"$f":"+R52-(IF(D41=$A$52, C41, 0))-(IF(D42=$A$52, C42, 0))","v":0},{"$f":"+S52-(IF(D43=$A$52, C43, 0))-(IF(D44=$A$52, C44, 0))","v":0},{"$f":"+T52-(IF(D45=$A$52, C45, 0))-(IF(D46=$A$52, C46, 0))","v":0},{"$f":"+U52-(IF(D47=$A$52, C47, 0))-(IF(D48=$A$52, C48, 0))","v":0}]
["Employees/Students",{"$f":"+'Parking Inventory'!C17","v":0},{"$f":"+B53-(IF(D9=$A$53, C9, 0))-(IF(D10=$A$53, C10, 0))","v":0},{"$f":"+C53-(IF(D11=$A$53, C11, 0))-(IF(D12=$A$53, C12, 0))","v":0},{"$f":"+D53-(IF(D13=$A$53, C13, 0))-(IF(D14=$A$53, C14, 0))","v":0},{"$f":"+E53-(IF(D15=$A$53, C15, 0))-(IF(D16=$A$53, C16, 0))","v":0},{"$f":"+F53-(IF(D17=$A$53, C17, 0))-(IF(D18=$A$53, C18, 0))","v":0},{"$f":"+G53-(IF(D19=$A$53, C19, 0))-(IF(D20=$A$53, C20, 0))","v":0},{"$f":"+H53-(IF(D21=$A$53, C21, 0))-(IF(D22=$A$53, C22, 0))","v":0},{"$f":"+I53-(IF(D23=$A$53, C23, 0))-(IF(D24=$A$53, C24, 0))","v":0},{"$f":"+J53-(IF(D25=$A$53, C25, 0))-(IF(D26=$A$53, C26, 0))","v":0},{"$f":"+K53-(IF(D27=$A$53, C27, 0))-(IF(D28=$A$53, C28, 0))","v":0},{"$f":"+L53-(IF(D29=$A$53, C29, 0))-(IF(D30=$A$53, C30, 0))","v":0},{"$f":"+M53-(IF(D31=$A$53, C31, 0))-(IF(D32=$A$53, C32, 0))","v":0},{"$f":"+N53-(IF(D33=$A$53, C33, 0))-(IF(D34=$A$53, C34, 0))","v":0},{"$f":"+O53-(IF(D35=$A$53, C35, 0))-(IF(D36=$A$53, C36, 0))","v":0},{"$f":"+P53-(IF(D37=$A$53, C37, 0))-(IF(D38=$A$53, C38, 0))","v":0},{"$f":"+Q53-(IF(D39=$A$53, C39, 0))-(IF(D40=$A$53, C40, 0))","v":0},{"$f":"+R53-(IF(D41=$A$53, C41, 0))-(IF(D42=$A$53, C42, 0))","v":0},{"$f":"+S53-(IF(D43=$A$53, C43, 0))-(IF(D44=$A$53, C44, 0))","v":0},{"$f":"+T53-(IF(D45=$A$53, C45, 0))-(IF(D46=$A$53, C46, 0))","v":0},{"$f":"+U53-(IF(D47=$A$53, C47, 0))-(IF(D48=$A$53, C48, 0))","v":0}]
["Physicians",{"$f":"+'Parking Inventory'!C26","v":0},{"$f":"+B54-(IF(D9=$A$54, C9, 0))-(IF(D10=$A$54, C10, 0))","v":0},{"$f":"+C54-(IF(D11=$A$54, C11, 0))-(IF(D12=$A$54, C12, 0))","v":0},{"$f":"+D54-(IF(D13=$A$54, C13, 0))-(IF(D14=$A$54, C14, 0))","v":0},{"$f":"+E54-(IF(D15=$A$54, C15, 0))-(IF(D16=$A$54, C16, 0))","v":0},{"$f":"+F54-(IF(D17=$A$54, C17, 0))-(IF(D18=$A$54, C18, 0))","v":0},{"$f":"+G54-(IF(D19=$A$54, C19, 0))-(IF(D20=$A$54, C20, 0))","v":0},{"$f":"+H54-(IF(D21=$A$54, C21, 0))-(IF(D22=$A$54, C22, 0))","v":0},{"$f":"+I54-(IF(D23=$A$54, C23, 0))-(IF(D24=$A$54, C24, 0))","v":0},{"$f":"+J54-(IF(D25=$A$54, C25, 0))-(IF(D26=$A$54, C26, 0))","v":0},{"$f":"+K54-(IF(D27=$A$54, C27, 0))-(IF(D28=$A$54, C28, 0))","v":0},{"$f":"+L54-(IF(D29=$A$54, C29, 0))-(IF(D30=$A$54, C30, 0))","v":0},{"$f":"+M54-(IF(D31=$A$54, C31, 0))-(IF(D32=$A$54, C32, 0))","v":0},{"$f":"+N54-(IF(D33=$A$54, C33, 0))-(IF(D34=$A$54, C34, 0))","v":0},{"$f":"+O54-(IF(D35=$A$54, C35, 0))-(IF(D36=$A$54, C36, 0))","v":0},{"$f":"+P54-(IF(D37=$A$54, C37, 0))-(IF(D38=$A$54, C38, 0))","v":0},{"$f":"+Q54-(IF(D39=$A$54, C39, 0))-(IF(D40=$A$54, C40, 0))","v":0},{"$f":"+R54-(IF(D41=$A$54, C41, 0))-(IF(D42=$A$54, C42, 0))","v":0},{"$f":"+S54-(IF(D43=$A$54, C43, 0))-(IF(D44=$A$54, C44, 0))","v":0},{"$f":"+T54-(IF(D45=$A$54, C45, 0))-(IF(D46=$A$54, C46, 0))","v":0},{"$f":"+U54-(IF(D47=$A$54, C47, 0))-(IF(D48=$A$54, C48, 0))","v":0}]
["Patients/Visitors",{"$f":"+'Parking Inventory'!C36","v":0},{"$f":"+B55-(IF(D9=$A$55, C9, 0))-(IF(D10=$A$55, C10, 0))","v":0},{"$f":"+C55-(IF(D11=$A$55, C11, 0))-(IF(D12=$A$55, C12, 0))","v":0},{"$f":"+D55-(IF(D13=$A$55, C13, 0))-(IF(D14=$A$55, C14, 0))","v":0},{"$f":"+E55-(IF(D15=$A$55, C15, 0))-(IF(D16=$A$55, C16, 0))","v":0},{"$f":"+F55-(IF(D17=$A$55, C17, 0))-(IF(D18=$A$55, C18, 0))","v":0},{"$f":"+G55-(IF(D19=$A$55, C19, 0))-(IF(D20=$A$55, C20, 0))","v":0},{"$f":"+H55-(IF(D21=$A$55, C21, 0))-(IF(D22=$A$55, C22, 0))","v":0},{"$f":"+I55-(IF(D23=$A$55, C23, 0))-(IF(D24=$A$55, C24, 0))","v":0},{"$f":"+J55-(IF(D25=$A$55, C25, 0))-(IF(D26=$A$55, C26, 0))","v":0},{"$f":"+K55-(IF(D27=$A$55, C27, 0))-(IF(D28=$A$55, C28, 0))","v":0},{"$f":"+L55-(IF(D29=$A$55, C29, 0))-(IF(D30=$A$55, C30, 0))","v":0},{"$f":"+M55-(IF(D31=$A$55, C31, 0))-(IF(D32=$A$55, C32, 0))","v":0},{"$f":"+N55-(IF(D33=$A$55, C33, 0))-(IF(D34=$A$55, C34, 0))","v":0},{"$f":"+O55-(IF(D35=$A$55, C35, 0))-(IF(D36=$A$55, C36, 0))","v":0},{"$f":"+P55-(IF(D37=$A$55, C37, 0))-(IF(D38=$A$55, C38, 0))","v":0},{"$f":"+Q55-(IF(D39=$A$55, C39, 0))-(IF(D40=$A$55, C40, 0))","v":0},{"$f":"+R55-(IF(D41=$A$55, C41, 0))-(IF(D42=$A$55, C42, 0))","v":0},{"$f":"+S55-(IF(D43=$A$55, C43, 0))-(IF(D44=$A$55, C44, 0))","v":0},{"$f":"+T55-(IF(D45=$A$55, C45, 0))-(IF(D46=$A$55, C46, 0))","v":0},{"$f":"+U55-(IF(D47=$A$55, C47, 0))-(IF(D48=$A$55, C48, 0))","v":0}]
["Government/Fleet Vehicles",{"$f":"+'Parking Inventory'!C41","v":0},{"$f":"+B56-(IF(D9=$A$56, C9, 0))-(IF(D10=$A$56, C10, 0))","v":0},{"$f":"+C56-(IF(D11=$A$56, C11, 0))-(IF(D12=$A$56, C12, 0))","v":0},{"$f":"+D56-(IF(D13=$A$56, C13, 0))-(IF(D14=$A$56, C14, 0))","v":0},{"$f":"+E56-(IF(D15=$A$56, C15, 0))-(IF(D16=$A$56, C16, 0))","v":0},{"$f":"+F56-(IF(D17=$A$56, C17, 0))-(IF(D18=$A$56, C18, 0))","v":0},{"$f":"+G56-(IF(D19=$A$56, C19, 0))-(IF(D20=$A$56, C20, 0))","v":0},{"$f":"+H56-(IF(D21=$A$56, C21, 0))-(IF(D22=$A$56, C22, 0))","v":0},{"$f":"+I56-(IF(D23=$A$56, C23, 0))-(IF(D24=$A$56, C24, 0))","v":0},{"$f":"+J56-(IF(D25=$A$56, C25, 0))-(IF(D26=$A$56, C26, 0))","v":0},{"$f":"+K56-(IF(D27=$A$56, C27, 0))-(IF(D28=$A$56, C28, 0))","v":0},{"$f":"+L56-(IF(D29=$A$56, C29, 0))-(IF(D30=$A$56, C30, 0))","v":0},{"$f":"+M56-(IF(D31=$A$56, C31, 0))-(IF(D32=$A$56, C32, 0))","v":0},{"$f":"+N56-(IF(D33=$A$56, C33, 0))-(IF(D34=$A$56, C34, 0))","v":0},{"$f":"+O56-(IF(D35=$A$56, C35, 0))-(IF(D36=$A$56, C36, 0))","v":0},{"$f":"+P56-(IF(D37=$A$56, C37, 0))-(IF(D38=$A$56, C38, 0))","v":0},{"$f":"+Q56-(IF(D39=$A$56, C39, 0))-(IF(D40=$A$56, C40, 0))","v":0},{"$f":"+R56-(IF(D41=$A$56, C41, 0))-(IF(D42=$A$56, C42, 0))","v":0},{"$f":"+S56-(IF(D43=$A$56, C43, 0))-(IF(D44=$A$56, C44, 0))","v":0},{"$f":"+T56-(IF(D45=$A$56, C45, 0))-(IF(D46=$A$56, C46, 0))","v":0},{"$f":"+U56-(IF(D47=$A$56, C47, 0))-(IF(D48=$A$56, C48, 0))","v":0}]
["Other Parking ",{"$f":"+'Parking Inventory'!C43","v":0},{"$f":"+B57-(IF(D9=$A$57, C9, 0))-(IF(D10=$A$57, C10, 0))","v":0},{"$f":"+C57-(IF(D11=$A$57, C11, 0))-(IF(D12=$A$57, C12, 0))","v":0},{"$f":"+D57-(IF(D13=$A$57, C13, 0))-(IF(D14=$A$57, C14, 0))","v":0},{"$f":"+E57-(IF(D15=$A$57, C15, 0))-(IF(D16=$A$57, C16, 0))","v":0},{"$f":"+F57-(IF(D17=$A$57, C17, 0))-(IF(D18=$A$57, C18, 0))","v":0},{"$f":"+G57-(IF(D19=$A$57, C19, 0))-(IF(D20=$A$57, C20, 0))","v":0},{"$f":"+H57-(IF(D21=$A$57, C21, 0))-(IF(D22=$A$57, C22, 0))","v":0},{"$f":"+I57-(IF(D23=$A$57, C23, 0))-(IF(D24=$A$57, C24, 0))","v":0},{"$f":"+J57-(IF(D25=$A$57, C25, 0))-(IF(D26=$A$57, C26, 0))","v":0},{"$f":"+K57-(IF(D27=$A$57, C27, 0))-(IF(D28=$A$57, C28, 0))","v":0},{"$f":"+L57-(IF(D29=$A$57, C29, 0))-(IF(D30=$A$57, C30, 0))","v":0},{"$f":"+M57-(IF(D31=$A$57, C31, 0))-(IF(D32=$A$57, C32, 0))","v":0},{"$f":"+N57-(IF(D33=$A$57, C33, 0))-(IF(D34=$A$57, C34, 0))","v":0},{"$f":"+O57-(IF(D35=$A$57, C35, 0))-(IF(D36=$A$57, C36, 0))","v":0},{"$f":"+P57-(IF(D37=$A$57, C37, 0))-(IF(D38=$A$57, C38, 0))","v":0},{"$f":"+Q57-(IF(D39=$A$57, C39, 0))-(IF(D40=$A$57, C40, 0))","v":0},{"$f":"+R57-(IF(D41=$A$57, C41, 0))-(IF(D42=$A$57, C42, 0))","v":0},{"$f":"+S57-(IF(D43=$A$57, C43, 0))-(IF(D44=$A$57, C44, 0))","v":0},{"$f":"+T57-(IF(D45=$A$57, C45, 0))-(IF(D46=$A$57, C46, 0))","v":0},{"$f":"+U57-(IF(D47=$A$57, C47, 0))-(IF(D48=$A$57, C48, 0))","v":0}]
["Total",{"$f":"SUM(B52:B57)","v":0},{"$f":"SUM(C52:C57)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,"Practical","Future Practical Capacity "]
["Space Allocation","Capacity",{"$f":"+C51","v":1},{"$f":"+C62+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Open/Unrestricted",{"$f":"+'Parking Inventory'!E8","v":0},{"$f":"ROUND(+C52*0.9,0)","v":0},{"$f":"ROUND(+D52*0.9,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Employees/Students",{"$f":"+'Parking Inventory'!E17","v":0},{"$f":"ROUND(+C53*0.95,0)","v":0},{"$f":"ROUND(+D53*0.95,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Physicians",{"$f":"+'Parking Inventory'!E26","v":0},{"$f":"ROUND(+C54*0.95,0)","v":0},{"$f":"ROUND(+D54*0.95,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Patients/Visitors",{"$f":"+'Parking Inventory'!E36","v":0},{"$f":"ROUND(+C55*0.9,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Government/Fleet Vehicles",{"$f":"+'Parking Inventory'!E41","v":0},{"$f":"ROUND(+C56*0.95,0)","v":0},{"$f":"ROUND(+D56*0.95,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Other Parking ",{"$f":"+'Parking Inventory'!E43","v":0},{"$f":"ROUND(+C57*0.95,0)","v":0},{"$f":"ROUND(+D57*0.95,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Total",{"$f":"SUM(B63:B68)","v":0},{"$f":"SUM(C63:C68)","v":0},{"$f":"SUM(D63:D68)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Surplus Deficit","index":10,"n_rows":12,"n_cols":22,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Veteran's Affairs Medical Centers Parking Demand Model"]
["VAMC Existing and Future Peak Parking Demand"]
[{"$f":"+'Facility Data'!C5","v":0}]
["Table 8"]
[]
[null,null,"Future Practical Surplus or Deficit"]
["Space Allocation","Current",{"$f":"+'Facility Data'!E9+1","v":1},{"$f":"+C7+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Employees/Students",{"$f":"+'Future Supply'!B63+'Future Supply'!B64-('Future Demand'!C9+'Future Demand'!C10+'Future Demand'!C12+'Future Demand'!C13+'Future Demand'!C14)","v":0},{"$f":"+'Future Supply'!C63+'Future Supply'!C64-('Future Demand'!D9+'Future Demand'!D10+'Future Demand'!D12+'Future Demand'!D13+'Future Demand'!D14)","v":0},{"$f":"+'Future Supply'!D63+'Future Supply'!D64-('Future Demand'!E9+'Future Demand'!E10+'Future Demand'!E12+'Future Demand'!E13+'Future Demand'!E14)","v":0},{"$f":"+'Future Supply'!E63+'Future Supply'!E64-('Future Demand'!F9+'Future Demand'!F10+'Future Demand'!F12+'Future Demand'!F13+'Future Demand'!F14)","v":0},{"$f":"+'Future Supply'!F63+'Future Supply'!F64-('Future Demand'!G9+'Future Demand'!G10+'Future Demand'!G12+'Future Demand'!G13+'Future Demand'!G14)","v":0},{"$f":"+'Future Supply'!G63+'Future Supply'!G64-('Future Demand'!H9+'Future Demand'!H10+'Future Demand'!H12+'Future Demand'!H13+'Future Demand'!H14)","v":0},{"$f":"+'Future Supply'!H63+'Future Supply'!H64-('Future Demand'!I9+'Future Demand'!I10+'Future Demand'!I12+'Future Demand'!I13+'Future Demand'!I14)","v":0},{"$f":"+'Future Supply'!I63+'Future Supply'!I64-('Future Demand'!J9+'Future Demand'!J10+'Future Demand'!J12+'Future Demand'!J13+'Future Demand'!J14)","v":0},{"$f":"+'Future Supply'!J63+'Future Supply'!J64-('Future Demand'!K9+'Future Demand'!K10+'Future Demand'!K12+'Future Demand'!K13+'Future Demand'!K14)","v":0},{"$f":"+'Future Supply'!K63+'Future Supply'!K64-('Future Demand'!L9+'Future Demand'!L10+'Future Demand'!L12+'Future Demand'!L13+'Future Demand'!L14)","v":0},{"$f":"+'Future Supply'!L63+'Future Supply'!L64-('Future Demand'!M9+'Future Demand'!M10+'Future Demand'!M12+'Future Demand'!M13+'Future Demand'!M14)","v":0},{"$f":"+'Future Supply'!M63+'Future Supply'!M64-('Future Demand'!N9+'Future Demand'!N10+'Future Demand'!N12+'Future Demand'!N13+'Future Demand'!N14)","v":0},{"$f":"+'Future Supply'!N63+'Future Supply'!N64-('Future Demand'!O9+'Future Demand'!O10+'Future Demand'!O12+'Future Demand'!O13+'Future Demand'!O14)","v":0},{"$f":"+'Future Supply'!O63+'Future Supply'!O64-('Future Demand'!P9+'Future Demand'!P10+'Future Demand'!P12+'Future Demand'!P13+'Future Demand'!P14)","v":0},{"$f":"+'Future Supply'!P63+'Future Supply'!P64-('Future Demand'!Q9+'Future Demand'!Q10+'Future Demand'!Q12+'Future Demand'!Q13+'Future Demand'!Q14)","v":0},{"$f":"+'Future Supply'!Q63+'Future Supply'!Q64-('Future Demand'!R9+'Future Demand'!R10+'Future Demand'!R12+'Future Demand'!R13+'Future Demand'!R14)","v":0},{"$f":"+'Future Supply'!R63+'Future Supply'!R64-('Future Demand'!S9+'Future Demand'!S10+'Future Demand'!S12+'Future Demand'!S13+'Future Demand'!S14)","v":0},{"$f":"+'Future Supply'!S63+'Future Supply'!S64-('Future Demand'!T9+'Future Demand'!T10+'Future Demand'!T12+'Future Demand'!T13+'Future Demand'!T14)","v":0},{"$f":"+'Future Supply'!T63+'Future Supply'!T64-('Future Demand'!U9+'Future Demand'!U10+'Future Demand'!U12+'Future Demand'!U13+'Future Demand'!U14)","v":0},{"$f":"+'Future Supply'!U63+'Future Supply'!U64-('Future Demand'!V9+'Future Demand'!V10+'Future Demand'!V12+'Future Demand'!V13+'Future Demand'!V14)","v":0},{"$f":"+'Future Supply'!V63+'Future Supply'!V64-('Future Demand'!W9+'Future Demand'!W10+'Future Demand'!W12+'Future Demand'!W13+'Future Demand'!W14)","v":0}]
["Physicians",{"$f":"+'Future Supply'!B65-'Future Demand'!C11","v":0},{"$f":"+'Future Supply'!C65-'Future Demand'!D11","v":0},{"$f":"+'Future Supply'!D65-'Future Demand'!E11","v":0},{"$f":"+'Future Supply'!E65-'Future Demand'!F11","v":0},{"$f":"+'Future Supply'!F65-'Future Demand'!G11","v":0},{"$f":"+'Future Supply'!G65-'Future Demand'!H11","v":0},{"$f":"+'Future Supply'!H65-'Future Demand'!I11","v":0},{"$f":"+'Future Supply'!I65-'Future Demand'!J11","v":0},{"$f":"+'Future Supply'!J65-'Future Demand'!K11","v":0},{"$f":"+'Future Supply'!K65-'Future Demand'!L11","v":0},{"$f":"+'Future Supply'!L65-'Future Demand'!M11","v":0},{"$f":"+'Future Supply'!M65-'Future Demand'!N11","v":0},{"$f":"+'Future Supply'!N65-'Future Demand'!O11","v":0},{"$f":"+'Future Supply'!O65-'Future Demand'!P11","v":0},{"$f":"+'Future Supply'!P65-'Future Demand'!Q11","v":0},{"$f":"+'Future Supply'!Q65-'Future Demand'!R11","v":0},{"$f":"+'Future Supply'!R65-'Future Demand'!S11","v":0},{"$f":"+'Future Supply'!S65-'Future Demand'!T11","v":0},{"$f":"+'Future Supply'!T65-'Future Demand'!U11","v":0},{"$f":"+'Future Supply'!U65-'Future Demand'!V11","v":0},{"$f":"+'Future Supply'!V65-'Future Demand'!W11","v":0}]
["Patients/Visitors",{"$f":"+'Future Supply'!B66-('Future Demand'!C20+'Future Demand'!C25)","v":0},{"$f":"+'Future Supply'!C66-('Future Demand'!D20+'Future Demand'!D25)","v":0},{"$f":"+'Future Supply'!D66-('Future Demand'!E20+'Future Demand'!E25)","v":0},{"$f":"+'Future Supply'!E66-('Future Demand'!F20+'Future Demand'!F25)","v":0},{"$f":"+'Future Supply'!F66-('Future Demand'!G20+'Future Demand'!G25)","v":0},{"$f":"+'Future Supply'!G66-('Future Demand'!H20+'Future Demand'!H25)","v":0},{"$f":"+'Future Supply'!H66-('Future Demand'!I20+'Future Demand'!I25)","v":0},{"$f":"+'Future Supply'!I66-('Future Demand'!J20+'Future Demand'!J25)","v":0},{"$f":"+'Future Supply'!J66-('Future Demand'!K20+'Future Demand'!K25)","v":0},{"$f":"+'Future Supply'!K66-('Future Demand'!L20+'Future Demand'!L25)","v":0},{"$f":"+'Future Supply'!L66-('Future Demand'!M20+'Future Demand'!M25)","v":0},{"$f":"+'Future Supply'!M66-('Future Demand'!N20+'Future Demand'!N25)","v":0},{"$f":"+'Future Supply'!N66-('Future Demand'!O20+'Future Demand'!O25)","v":0},{"$f":"+'Future Supply'!O66-('Future Demand'!P20+'Future Demand'!P25)","v":0},{"$f":"+'Future Supply'!P66-('Future Demand'!Q20+'Future Demand'!Q25)","v":0},{"$f":"+'Future Supply'!Q66-('Future Demand'!R20+'Future Demand'!R25)","v":0},{"$f":"+'Future Supply'!R66-('Future Demand'!S20+'Future Demand'!S25)","v":0},{"$f":"+'Future Supply'!S66-('Future Demand'!T20+'Future Demand'!T25)","v":0},{"$f":"+'Future Supply'!T66-('Future Demand'!U20+'Future Demand'!U25)","v":0},{"$f":"+'Future Supply'!U66-('Future Demand'!V20+'Future Demand'!V25)","v":0},{"$f":"+'Future Supply'!V66-('Future Demand'!W20+'Future Demand'!W25)","v":0}]
["Other Parking ",{"$f":"+'Future Supply'!B67","v":0},{"$f":"+'Future Supply'!C67","v":0},{"$f":"+'Future Supply'!D67","v":0},{"$f":"+'Future Supply'!E67","v":0},{"$f":"+'Future Supply'!F67","v":0},{"$f":"+'Future Supply'!G67","v":0},{"$f":"+'Future Supply'!H67","v":0},{"$f":"+'Future Supply'!I67","v":0},{"$f":"+'Future Supply'!J67","v":0},{"$f":"+'Future Supply'!K67","v":0},{"$f":"+'Future Supply'!L67","v":0},{"$f":"+'Future Supply'!M67","v":0},{"$f":"+'Future Supply'!N67","v":0},{"$f":"+'Future Supply'!O67","v":0},{"$f":"+'Future Supply'!P67","v":0},{"$f":"+'Future Supply'!Q67","v":0},{"$f":"+'Future Supply'!R67","v":0},{"$f":"+'Future Supply'!S67","v":0},{"$f":"+'Future Supply'!T67","v":0},{"$f":"+'Future Supply'!U67","v":0},{"$f":"+'Future Supply'!V67","v":0}]
["Total Surplus or Deficit",{"$f":"SUM(B8:B11)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Demand Ratio Matrix","index":11,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[[3,2,5,14]]}
["Veteran's Administration Medical Centers Parking Demand Model"]
["VAMC Peak Parking Demand Ratios"]
[{"$f":"+'Facility Data'!C5","v":0}]
["Table 4",null,"THIS TAB IS PROTECTED. YOU CANNOT ENTER ANY DATA"]
[]
[]
[null,null,"Urban",null,null,"Suburban",null,null,"Rural"]
[null,"Transit & Car/Vanpool Rating","Strong","Mixed","Weak","Strong","Mixed","Weak","Mixed","Weak"]
["Staffing"]
[null,"Full-time",0.4,0.5,0.6,0.65,0.7,0.75,0.8,0.85]
[null,"Part-time",0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.75,0.8]
[null,"Physicians",0.7,0.75,0.75,0.8,0.8,0.85,0.85,0.85]
[null,"Service Organization",0.5,0.6,0.65,0.7,0.75,0.75,0.8,0.85]
[null,"Volunteers",0.15,0.15,0.2,0.2,0.25,0.25,0.3,0.3]
[null,"Students",0.15,0.2,0.2,0.25,0.3,0.3,0.35,0.35]
["Patients"]
[null,"Outpatients",0.25,0.25,0.3,0.3,0.35,0.4,0.4,0.45]
[null,"Inpatient Admissions",0.25,0.25,0.3,0.35,0.35,0.35,0.4,0.4]
[null,"ED Patients ",0.3,0.35,0.4,0.4,0.4,0.45,0.5,0.6]
["Visitors"]
[null,"Inpatient Visitors",0.4,0.4,0.4,0.4,0.45,0.45,0.5,0.6]
[null,"Vendors",0.45,0.45,0.45,0.5,0.5,0.5,0.55000000000000004,0.6]
[null,"Non-treatment Visitors",0.4,0.4,0.4,0.4,0.45,0.45,0.5,0.6]
[]
[null,null,"S = Strong",null,"M = Moderate or Mixed",null,null,"W = Weak"]