{"text_format":"3","workbook":"xls","n_sheets":11,"sheets":["Overview","ExpenseSummary","Mission","Administration","Support","Buildings","Equipment","FedPay","LocalityPay","SeniorExecutive","ExecSchedule"],"not_rendered":{"macros":1,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Overview","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"flags":["formulas_cached_only"]}
["Sources"]
[null,"TranscommunityDesign.html"]
[]
[null,"Journey in Being: Essential Version (Journey in Being-brief.html)"]
[]
[null,"Journey in Being.html"]
[]
[]
["Base Year"]
[null,"The current base year is 2013"]
[]
["Estimates for another base year","To compute expenses for another year"]
[null,"(i) The base data must be re-entered, or"]
[]
[null,"(ii) Multiply costs by appropriate factors"]
[null,"      Inflation from 2013 to calculate initial outlay and initial annual expense"]
[null,"      Estimated inflation from new base year to calculate subsequent annual expense"]

{"sheet":"ExpenseSummary","index":1,"n_rows":21,"n_cols":5,"rows_kept":21,"flags":["formulas_cached_only"]}
[]
["Initial"]
[null,"Buildings",null,17965850]
[null,"Land",null,608994]
[null,"Equipment",null,662600]
[null,"Total",null,19237444]
[]
["Startup"]
[null,"Startup Admin",null,1095326.42,"Reflects two years for leader and administration; plus supplies"]
[null,"Startup Vehicles",null,125000]
[null,"Motel / hotel",null,10400]
[null,"Travel",null,20000]
[null,"Phone",null,2400]
[null,"Total",null,1253126.42]
[]
["Initial outlay",null,null,{"v":20490570.42,"d":"$20,490,570.42"}]
[]
["Base Annual",null,null,{"v":5881074.99125,"d":"$5,881,074.99"}]
["Locality Factor",null,null,1.1416,"Note this may be changed by changing the reference to 'LocalitPay' worksheet"]
[]
["Annual",null,null,{"v":6713835.210011,"d":"$6,713,835.21"}]

{"sheet":"Mission","index":2,"n_rows":26,"n_cols":14,"rows_kept":26,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[null,null,"Grade","Step","Number","Base Rate","Class Total",null,"Assistant","Grade","Step","Number","Base Rate","Class Total"]
[null,"Logic","GS-12",1,1,60575,60575,null,1,"GS-8",1,1,37819,37819]
[null,"AI","GS-12",1,1,60575,60575,null,1,"GS-8",1,1,37819,37819]
[null,"Philosophy","GS-12",1,1,60575,60575,null,1,"GS-8",1,1,37819,37819]
[null,"Science","GS-12",1,1,60575,60575,null,1,"GS-8",1,1,37819,37819]
[null,"Bio-medicine","GS-12",1,1,60575,60575,null,1,"GS-8",1,1,37819,37819]
[null,"Yoga","GS-12",1,1,60575,60575,null,1,"GS-8",1,1,37819,37819]
[null,"Spirit guide","GS-12",1,1,60575,60575,null,1,"GS-8",1,1,37819,37819]
[null,"Expedition","GS-15",10,1,{"v":130168,"d":"130,168"},130168,null,1,"GS-8",1,1,37819,37819]
[null,"Expedition","GS-12",1,2,60575,121150,null,2,"GS-8",1,2,37819,75638]
[null,"Anthropology","GS-12",1,1,60575,60575,null,1,"GS-8",1,1,37819,37819]
[]
[null,"Employees",22]
[]
[null,"Subtotals",{"$nulls":3},"Mission",735918,{"$nulls":5},"Assistant",416009]
[]
[null,"Total",1151927]
[null,"Total + Benefits",1439908.75]
[null,"Annual Supplies",14399.0875]
[]
[null,"Total Annual",1454307.8375]

{"sheet":"Administration","index":3,"n_rows":18,"n_cols":14,"rows_kept":18,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[null,null,"Grade","Step","Number","Base Rate","Class Total",null,null,"Grade","Step","Number","Base Rate","Class Total"]
[]
[null,"Director","GS-13",2,1,74433,74433,null,"Assistant","GS-8",1,1,37819,37819]
[null,"Promotion","GS-11",5,2,57278,114556,null,"Assistant","GS-8",1,2,37819,75638]
[]
[null,"Subtotals",{"$nulls":3},"Admin.",188989,{"$nulls":5},"Assistant",113457]
[]
[null,"Employees",6]
[]
[null,"Total",302446]
[null,"Total + Benefits",378057.5]
[null,"Annual Supplies",3024.46]
[]
[null,"Total Annual",381081.96]

{"sheet":"Support","index":4,"n_rows":45,"n_cols":10,"rows_kept":45,"flags":["formulas_cached_only"]}
{"$rows_empty":8}
[{"$nulls":3},"Category and Description","Grade","Step","Number","Base Rate","Class Totals","Subtotal"]
[]
[null,"Information support",null,"Systems Analyst","GS-10",1,1,46000,46000]
[{"$nulls":3},"Technician","GS-8",1,3,37819,113457,159457]
[{"$nulls":3},"Information Employees",null,null,4]
[null,"Library",null,"Librarian","GS-10",1,1,46000,46000]
[{"$nulls":3},"Assistant","GS-8",1,1,37819,37819,83819]
[{"$nulls":3},"Information Employees",null,null,2]
[null,"Shop-visitor center",null,"Supervisor","GS-10",1,1,46000,46000]
[{"$nulls":3},"Clerk","GS-8",1,1,37819,37819,83819]
[{"$nulls":3},"Information Employees",null,null,2]
[null,"Kitchen",null,"Head Cook","GS-10",1,1,46000,46000]
[{"$nulls":3},"Cook","GS-8",1,2,37819,75638,121638]
[{"$nulls":3},"Information Employees",null,null,1]
[null,"Expedition",null,"Manager-planner","GS-12",1,1,60575,60575]
[{"$nulls":3},"Shop technician","GS-8",1,2,37819,75638,136213]
[{"$nulls":3},"Information Employees",null,null,3]
[null,"Building-grounds",null,"Manager","GS-10",1,1,46000,46000]
[{"$nulls":3},"Maintenance","GS-8",1,2,37819,75638]
[{"$nulls":3},"Mechanical","GS-8",1,1,37819,37819]
[{"$nulls":3},"Grounds","GS-8",1,2,37819,75638,235095]
[{"$nulls":3},"Information Employees",null,null,3]
[null,"Garage",null,"Manager","GS-10",1,1,46000,46000]
[{"$nulls":3},"Mechanics","GS-8",1,3,37819,113457]
[{"$nulls":3},"Drivers","GS-8",1,4,37819,151276,310733]
[{"$nulls":3},"Information Employees",null,null,3]
[null,"Security",null,"Lieutenant","GS-10",1,1,46000,46000]
[{"$nulls":3},"Officers","GS-8",1,4,37819,151276,197276]
[{"$nulls":3},"Information Employees",null,null,5]
[]
[{"$nulls":3},"Total information employees",{"$nulls":4},21]
[]
[null,"Total",{"$nulls":6},1328071,1328050]
[null,"Total + Benefits",{"$nulls":6},1660088.75]
[null,"Annual supplies",{"$nulls":6},8300.44375]
[]
[null,"Total Annual",{"$nulls":6},1668389.19375]

{"sheet":"Buildings","index":5,"n_rows":52,"n_cols":6,"rows_kept":52,"flags":["formulas_cached_only"]}
["Main"]
[null,"Office","Category","Number","Area (sq ft) / office","Total Area/cist"]
[null,null,"Mission",11,180,1980]
[null,null,"Assistant",11,150,1650]
[null,null,"Director",1,250,250]
[null,null,"Promotion",2,180,360]
[null,null,"Assistant",3,150,450]
[null,null,"Information support",4,180,720]
[null,null,"Library",2,180,360]
[null,null,"Expedition",1,180,180]
[null,null,"Building-grounds",2,180,360]
[null,null,"Front office",1,250,250]
[null,"Lecture Hall",null,2,500,1000]
[null,"Computer center",null,1,400,400]
[null,"Library",null,1,1000,1000]
[null,"Kitchen",null,1,400,400]
[null,"Expedition shop",null,1,400,400]
[null,"Shop-visitor center",null,1,500,500]
[null,"Bathroom",null,2,250,500]
[null,"Used space",{"$nulls":3},10760]
[null,"Dead space (halls)",{"$nulls":3},2152]
["Total",{"$nulls":4},12912]
["Cost",175,"per square foot",null,null,2259600]
[]
["Garage","Office","Garage",2,250,500]
[null,"Garage","400 square feet / vehicle",null,4000,4250]
["Total",{"$nulls":4},4750]
["Cost",{"$nulls":4},831250]
[]
["Security","Office",null,2,250,500]
[null,"Receiving etc",null,2,null,1000]
["Total",{"$nulls":4},1500]
["Cost",{"$nulls":4},262500]
[{"$nulls":3},"Number","Area"]
[]
["Community","Housing","A-type",13,1500,19500]
[null,null,"Cost",null,262500,3412500]
[null,null,"B-type",64,1000,64000]
[null,null,"Cost",null,175000,11200000]
["Total Cost",{"$nulls":4},14612500]
[]
["Building area",{"$nulls":4},105912]
["Land area",{"$nulls":4},529560]
["Land costs","$1.15/square foot",{"$nulls":3},608994]
[]
["Building","Costs",{"$nulls":3},17965850]
[]
["Annual"]
[null,"Utilities",{"$nulls":3},359317]
[null,"Maintenance",{"$nulls":3},1796585]
[]
[null,"Total",{"$nulls":3},2155902]

{"sheet":"Equipment","index":6,"n_rows":48,"n_cols":9,"rows_kept":48,"flags":["formulas_cached_only"]}
[]
["Computation",{"$nulls":4},"Cost",null,"#","Total Cost"]
[]
[null,null,"Servers"]
[{"$nulls":5},3000,"Network",1,3000]
[{"$nulls":5},3000,"Information",1,3000]
[{"$nulls":5},3000,"Web",1,3000]
[{"$nulls":8},0]
[null,null,"Workstations",null,null,1000,null,49,49000]
[null,null,"Laptops",null,null,1000,null,28,28000]
[{"$nulls":8},0]
[null,"Network",49,"users",null,150,"(Based on $3000 for 20 users)",49,7350]
[{"$nulls":8},0]
[null,"Windows Server",49,"users",null,150,null,49,7350]
[null,"Windows",77,"users",null,100,"50 upgrade / 3years",49,4900]
[{"$nulls":7},77,0]
[null,"Backup s/h ware",49,"users",null,50,null,49,2450]
[{"$nulls":8},0]
[null,"Printers",49,"users","1 printer / 10 users",1000,null,5,5000]
[{"$nulls":7},5,0]
[null,"Projectors",null,null,"lecture halls + 2",1500,null,4,6000]
[{"$nulls":8},0]
[{"$nulls":8},0]
[null,"Field Computers","Fully figured",null,"# exped personnel",6000,"(Trenton systems, Panasonic)",3,18000]
[null,"Portable satellite modems",null,null,"Same as above",7000,null,3,21000]
[null,"Photovoltaic computer charger",null,null,"Same as above",100,null,3,300]
[null,"Satellite Phones",null,null,"Same as above",5000,"BGAN (Thrane & Thrane, Hughes",3,15000]
[null,"Photovoltaic phone charger",null,null,"Same as above",150,"SATTRANS",3,450]
[]
[null,"Total Initial Cost",{"$nulls":6},173800]
[]
[]
["Expedition"]
[null,"Gear",{"$nulls":3},2500,"personal experience",6,15000]
[null,"Vehicles",{"$nulls":3},20000,null,3,60000]
[{"$nulls":8},0]
["Transportation",{"$nulls":7},0]
[null,"Vehicles",null,null,"1/10 empoyees",20000,"general purpose",8,160000]
[{"$nulls":8},0]
[{"$nulls":8},0]
["Security",{"$nulls":7},0]
[null,"Vehicles",{"$nulls":3},20000,null,4,80000]
[]
[]
["Total",{"$nulls":7},662600]
[]
["Expedition supplies annual=mission personnell * weeks/year*200/week*0.67 time in field",{"$nulls":7},55744]
["Annual expense",{"$nulls":7},221394]

{"sheet":"FedPay","index":7,"n_rows":17,"n_cols":12,"rows_kept":17,"flags":["formulas_cached_only"]}
[null,"General Schedule"]
[null,"Step:",1,2,3,4,5,6,7,8,9,10]
[null,"GS-1 ",17892,18490,19085,19677,20272,20622,21210,21802,21826,22382]
[null,"GS-2 ",20117,20595,21261,21826,22070,22719,23368,24017,24666,25315]
[null,"GS-3 ",21949,22681,23413,24145,24877,25609,26341,27073,27805,28537]
[null,"GS-4 ",24641,25462,26283,27104,27925,28746,29567,30388,31209,32030]
[null,"GS-5 ",27568,28487,29406,30325,31244,32163,33082,34001,34920,35839]
[null,"GS-6 ",30730,31754,32778,33802,34826,35850,36874,37898,38922,39946]
[null,"GS-7 ",34149,35287,36425,37563,38701,39839,40977,42115,43253,44391]
[null,"GS-8 ",37819,39080,40341,41602,42863,44124,45385,46646,47907,49168]
[null,"GS-9 ",41771,43163,44555,45947,47339,48731,50123,51515,52907,54299]
[null,"GS-10 ",46000,47533,49066,50599,52132,53665,55198,56731,58264,59797]
[null,"GS-11 ",50538,52223,53908,55593,57278,58963,60648,62333,64018,65703]
[null,"GS-12 ",60575,62594,64613,66632,68651,70670,72689,74708,76727,78746]
[null,"GS-13 ",72032,74433,76834,79235,81636,84037,86438,88839,91240,93641]
[null,"GS-14 ",85120,87957,90794,93631,96468,99305,102142,104979,107816,110653]
[null,"GS-15 ",{"v":100126,"d":"100,126"},{"v":103464,"d":"103,464"},{"v":106802,"d":"106,802"},{"v":110140,"d":"110,140"},{"v":113478,"d":"113,478"},{"v":116816,"d":"116,816"},{"v":120154,"d":"120,154"},{"v":123492,"d":"123,492"},{"v":126830,"d":"126,830"},{"v":130168,"d":"130,168"}]

{"sheet":"LocalityPay","index":8,"n_rows":37,"n_cols":2,"rows_kept":37,"flags":["formulas_cached_only"]}
[]
[]
["Locality Pay Area","Rate"]
["Alaska",0.2469]
["Atlanta-Sandy Springs-Gainesville, GA-AL",0.1929]
["Boston-Worcester-Manchester, MA-NH-RI-ME",{"v":0.248,"d":"0.2480"}]
["Buffalo-Niagara-Cattaraugus, NY",0.1698]
["Chicago-Naperville-Michigan City, IL-IN-WI",{"v":0.251,"d":"0.2510"}]
["Cincinnati-Middletown-Wilmington, OH-KY-IN",0.1855]
["Cleveland-Akron-Elyria, OH",0.1868]
["Columbus-Marion-Chillicothe, OH",0.1716]
["Dallas-Fort Worth, TX",0.2067]
["Dayton-Springfield-Greenville, OH",0.1624]
["Denver-Aurora-Boulder, CO",0.2252]
["Detroit-Warren-Flint, MI",0.2409]
["Hartford-West Hartford-Willimantic, CT-MA",0.2582]
["Hawaii",0.1651]
["Houston-Baytown-Huntsville, TX",0.2871]
["Huntsville-Decatur, AL",0.1602]
["Indianapolis-Anderson-Columbus, IN",0.1468]
["Los Angeles-Long Beach-Riverside, CA",0.2716]
["Miami-Fort Lauderdale-Pompano Beach, FL",0.2079]
["Milwaukee-Racine-Waukesha, WI",{"v":0.181,"d":"0.1810"}]
["Minneapolis-St. Paul-St. Cloud, MN-WI",0.2096]
["New York-Newark-Bridgeport, NY-NJ-CT-PA",0.2872]
["Philadelphia-Camden-Vineland, PA-NJ-DE-MD",0.2179]
["Phoenix-Mesa-Scottsdale, AZ",0.1676]
["Pittsburgh-New Castle, PA",0.1637]
["Portland-Vancouver-Beaverton, OR-WA",0.2035]
["Raleigh-Durham-Cary, NC",0.1764]
["Richmond, VA",0.1647]
["Sacramento—Arden-Arcade—Yuba City, CA-NV",{"v":0.222,"d":"0.2220"}]
["San Diego-Carlsbad-San Marcos, CA",0.2419]
["San Jose-San Francisco-Oakland, CA",0.3515]
["Seattle-Tacoma-Olympia, WA",0.2181]
["Washington-Baltimore-Northern Virginia, DC-MD-VA-WV-PA",0.2422]
["Rest of U.S.",0.1416]

{"sheet":"SeniorExecutive","index":9,"n_rows":4,"n_cols":3,"rows_kept":4,"flags":["formulas_cached_only"]}
["Senior Executive Service"]
[null,"Minimum","Maximum"]
["Agencies with a Certified SES Performance Appraisal System",120151,180600]
["Agencies without a Certified SES Performance Appraisal System",120151,166100]

{"sheet":"ExecSchedule","index":10,"n_rows":6,"n_cols":3,"rows_kept":6,"flags":["formulas_cached_only"]}
["Executive Schedule"]
[null,"Level I",200700]
[null,"Level II",180600]
[null,"Level III",156300]
[null,"Level IV",166100]
[null,"Level V",146400]