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

{"sheet":"Overview","index":0,"n_rows":16,"n_cols":3,"rows_kept":16,"flags":["formulas_cached_only"]}
["Sources"]
[null,"TranscommunityDesign.html"]
[null,"Journey in Being-brief.html","Essential version"]
[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"]
[null,"      This may be done by updating data and factors, mostly in red; however some care is needed"]
[null,"       to make sure all factors updated; personnel may be added by careful row insertion; this will"]
[null,"       require update of macros; the macros themselves may be revised to not need this update"]
[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":37,"n_cols":5,"rows_kept":37,"flags":["formulas_cached_only"]}
["Base year",2013,"this can be changed; it will require update of all appropriate data, mainly various factors and FedPay and LocalityPay sheets"]
["Initial"]
[null,"Buildings",null,{"v":20444200,"d":"$20,444,200.00"}]
[null,"Land",null,{"v":701925.5,"d":"$701,925.50"}]
[null,"Equipment",null,{"v":822500,"d":"$822,500.00"}]
[null,"Total",null,{"v":21968626,"d":"$21,968,626.00"}]
[]
["Startup"]
[null,"Startup Admin",null,{"v":1596664.65,"d":"$1,596,664.65"},"Reflects two years for leader and administration; plus supplies"]
[null,"Startup Vehicles",null,{"v":125000,"d":"$125,000.00"},"Vehicles + maintenance + fuel"]
[null,"Motel / hotel",null,{"v":31200,"d":"$31,200.00"},"Leader + 2 Admin for 104 weeks $100/night"]
[null,"Travel",null,{"v":60000,"d":"$60,000.00"},"2years, $10,000 per year per person"]
[null,"Phone",null,{"v":7200,"d":"$7,200.00"},"$100 per month per person"]
[null,"Total",null,{"v":1820065,"d":"$1,820,065.00"}]
[]
["Initial outlay",null,null,{"v":23788691,"d":"$23,788,691.00"}]
[]
[]
["Compute annual expense:"]
["Base Personnel",null,null,{"v":4619244.675,"d":"$4,619,244.68"}]
["Locality  Factor",null,null,{"v":0.1416,"d":"0.14"},"This factor can be adjusted from LocalityPay"]
[]
["Annual Personnel",null,null,{"v":5273330,"d":"$5,273,330.00"}]
["Support",null,null,{"v":3097213,"d":"$3,097,213.00"}]
["Buildings",null,null,{"v":4497724,"d":"$4,497,724.00"}]
[]
["Annual",null,null,{"v":12868267,"d":"$12,868,267.00"}]
[]
["Other years:"]
[]
["New Base Year",2013]
["Inflation",0.018,"http://www.tradingeconomics.com/united-states/inflation-cpi"]
["Initial outlay",{"v":23788691,"d":"$23,788,691.00"}]
["Annual Expense",{"v":12868267,"d":"$12,868,267.00"}]
["Later year",2014,"(Suggest ",2014,"or later)"]
["Inflation",0.018]
["Annual Expense",{"v":13099896,"d":"$13,099,896.00"}]

{"sheet":"Mission","index":2,"n_rows":41,"n_cols":14,"rows_kept":41,"flags":["formulas_cached_only"]}
["Expedition Leader",15,"J",1,{"v":130168,"d":"130,168"},130168,1,null,1,8,"A",1,37819,37819]
["Expedition",12,"A",2,60575,121150,1,null,2,8,"A",2,37819,75638]
["Anthropology",12,"A",1,60575,60575,0,null,3,8,"A",1,37819,37819]
["Logic",12,"A",1,60575,60575,0,null,4,8,"A",1,37819,37819]
["AI",12,"A",1,60575,60575,0,null,5,8,"A",1,37819,37819]
["Philosophy",12,"A",1,60575,60575,0,null,6,8,"A",1,37819,37819]
["Science",12,"A",1,60575,60575,0,null,7,8,"A",1,37819,37819]
["Bio-medicine",12,"A",1,60575,60575,0,null,8,8,"A",1,37819,37819]
["Yoga",12,"A",1,60575,60575,0,null,9,8,"A",1,37819,37819]
["Spirit guide",12,"A",1,60575,60575,0,null,10,8,"A",1,37819,37819]
["Enter description",12,"A",0,60575,0,0,null,11,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,12,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,13,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,14,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,15,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,16,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,17,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,18,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,19,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,20,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,21,8,"A",0,37819,0]
["Enter description",12,"A",0,60575,0,0,null,22,8,"A",0,37819,0]
[null,"Grade","Step","Number","Base Rate","Class Total","Field emp",null,"Assistant","Grade","Step","Number","Base Rate","Class Total"]
[]
[]
["Mission personnel",11]
["Assistants",11]
["Employees",22]
[]
["Subtotals",{"$nulls":3},"Mission",424025,{"$nulls":6},"Assistant",264733]
[]
["Total",688758]
["Benefits (fraction)",0.25]
["Total + Benefits",860947.5]
["Supplies (fraction)",0.02]
["Annual Supplies",17218.95]
[]
["Total Annual",878166.45]
[]
[]
["Mission factor",2]

{"sheet":"Administration","index":3,"n_rows":18,"n_cols":13,"rows_kept":18,"flags":["formulas_cached_only"]}
[null,"Grade","Step","Number","Base Rate","Class Total",null,null,"Grade","Step","Number","Base Rate","Class Total"]
[]
["Director",13,"A",2,72032,144064,null,"Assistant",8,"A",2,37819,75638]
["Promotion",11,"E",3,57278,171834,null,"Assistant",8,"A",3,37819,113457]
[]
["Subtotals",{"$nulls":3},"Admin.",315898,{"$nulls":5},"Assistant",189095]
[]
[]
[]
["Employees",10]
[]
["Total",504993]
["Benefits (fraction)",0.25]
["Total + Benefits",631241.25]
["Supplies (fraction)",0.02]
["Annual Supplies",12624.825]
[]
["Total Annual",643866.075]

{"sheet":"Support","index":4,"n_rows":44,"n_cols":8,"rows_kept":44,"flags":["formulas_cached_only"]}
[null,"Category and Description","Grade","Step","Number","Base Rate","Class Totals","Subtotal"]
[]
["Information support","Systems Analyst",10,"A",2,46000,92000]
[null,"Technician",8,"A",4,37819,151276,243276]
[null,"Information Employees","NA","NA",6]
["Library","Librarian",10,"A",2,46000,92000]
[null,"Assistant",8,"A",4,37819,151276,243276]
[null,"Information Employees","NA","NA",6]
["Shop-visitor center","Supervisor",10,"A",2,46000,92000]
[null,"Clerk",8,"A",4,37819,151276,243276]
[null,"Information Employees","NA","NA",3]
["Kitchen","Head Cook",10,"A",2,46000,92000]
[null,"Cook",8,"A",4,37819,151276,243276]
[null,"Information Employees","NA","NA",2]
["Expedition","Manager-planner",12,"A",2,60575,121150]
[null,"Shop technician",8,"A",4,37819,151276,272426]
[null,"Information Employees","NA","NA",6]
["Garage","Manager",10,"A",2,46000,92000]
[null,"Mechanics",8,"A",4,37819,151276]
[null,"Drivers",8,"A",4,37819,151276,394552]
[null,"Information Employees","NA","NA",3]
["Security","Lieutenant",10,"A",2,46000,92000]
[null,"Officers",8,"A",4,37819,151276]
[null,"Assistant",8,"A",3,37819,113457,356733]
[null,"Information Employees","NA","NA",5]
["Building-grounds","Manager",10,"A",2,46000,92000]
[null,"Maintenance",8,"A",4,37819,151276]
[null,"Mechanical",8,"A",2,37819,75638]
[null,"Grounds",8,"A",3,37819,113457,432371]
[null,"Information Employees","NA","NA",4]
[]
[]
[null,"Total employees",{"$nulls":4},49]
[null,"Total information employees",{"$nulls":4},32]
[]
[]
[]
["Total",{"$nulls":5},2429186,2429186]
["Benefits (fraction)",0.25]
["Total + Benefits",{"$nulls":5},3036482.5]
["Supplies (fraction)",0.02]
["Annual supplies",{"$nulls":5},60729.65]
[]
["Total Annual",{"$nulls":5},3097212.15]

{"sheet":"Buildings","index":5,"n_rows":54,"n_cols":6,"rows_kept":54,"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",2,250,500]
[null,null,"Promotion",3,180,540]
[null,null,"Assistant",5,150,750]
[null,null,"Information support",6,180,1080]
[null,null,"Library",6,180,1080]
[null,null,"Expedition",4,180,720]
[null,null,"Building-grounds",4,180,720]
[null,null,"Front office",2,250,500]
[null,"Lecture Hall",null,2,500,1000]
[null,"Computer center",null,2,400,800]
[null,"Library",null,2,800,1600]
[null,"Kitchen",null,2,400,800]
[null,"Expedition shop",null,2,400,800]
[null,"Shop-visitor center",null,2,500,1000]
[null,"Bathroom",null,4,250,1000]
[null,"Used space","Dead space factor below:",null,null,16520]
[null,"Dead space (halls)",0.2,null,null,3304]
["Total",{"$nulls":4},19824]
["Cost",175,"per square foot",null,null,3469200]
[]
["Garage","Office","Garage",4,250,1000]
[null,"Garage",400,null,4000,4250]
["Total",{"$nulls":4},5250]
["Cost",{"$nulls":4},918750]
[]
["Security","Office","Parking is part of A43",7,250,1750]
[null,"Receiving etc","Mission factorB41*500",null,null,1000]
["Total",{"$nulls":4},2750]
["Cost",{"$nulls":4},481250]
[{"$nulls":3},"Number","Area"]
[]
["Community","Housing","A-type",16,1500,24000]
[null,null,"Cost",null,262500,4200000]
[null,null,"B-type",65,1000,65000]
[null,null,"Cost",null,175000,11375000]
["Total Cost",{"$nulls":4},15575000]
[]
["Building area",{"$nulls":4},122074]
["Land:Building",5]
["Land area",{"$nulls":4},610370]
["Land costs",1.15,"$/square foot",null,null,701925.5]
[]
["Building","Costs",{"$nulls":3},20444200]
[]
["Annual"]
[null,"Utilities","Factor",0.02,null,408884]
[null,"Maintenance","Factor",0.1,null,2044420]
[null,"Depreciate / replace","Factor",0.1,null,2044420]
[]
[null,"Total",{"$nulls":3},4497724]

{"sheet":"Equipment","index":6,"n_rows":50,"n_cols":9,"rows_kept":50,"flags":["formulas_cached_only"]}
[]
["Computation",{"$nulls":4},"Cost(/user)",null,"#","Total Cost"]
[]
[null,null,"Servers"]
[{"$nulls":5},3000,"Network",2,6000]
[{"$nulls":5},3000,"Information",2,6000]
[{"$nulls":5},3000,"Web",2,6000]
[{"$nulls":8},0]
[null,null,"Workstations",null,null,1000,null,64,64000]
[null,null,"Laptops",null,null,1000,null,32,32000]
[{"$nulls":8},0]
[null,"Network",64,"users",null,150,"(Based on $3000 for 20 users)",64,9600]
[{"$nulls":8},0]
[null,"Windows Server",64,"users",null,150,null,64,9600]
[null,"Windows",96,"users",null,100,"50 upgrade / 3years",96,9600]
[{"$nulls":8},0]
[null,"Backup s/h ware",64,"users",null,50,null,64,3200]
[{"$nulls":8},0]
[null,"Printers",64,"users",null,1000,"Check: int(users/10)+1",7,7000]
[{"$nulls":7},7,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},213750]
[]
[]
["Expedition"]
[null,"Gear",{"$nulls":3},2500,"personal experience",6,15000]
[null,"Vehicles",{"$nulls":3},20000,"# exped personnel",3,60000]
[{"$nulls":8},0]
["Transportation",{"$nulls":7},0]
[null,"Vehicles",null,null,"1/10 empoyees",20000,"general purpose",10,200000]
[{"$nulls":8},0]
[{"$nulls":8},0]
["Security",{"$nulls":7},0]
[null,"Vehicles",{"$nulls":3},20000,null,6,120000]
[]
[]
["Total",{"$nulls":7},822500]
[]
["Expedition supplies annual=mission personnell * weeks/year*200/week*0.67 time in field",{"$nulls":7},69680]
["Depreciate/replace/maintain/fuel",null,"Factor",0.25]
[{"$nulls":8},205625]
["Annual expense",{"$nulls":7},275305]

{"sheet":"FedPay","index":7,"n_rows":17,"n_cols":12,"rows_kept":17,"flags":["formulas_cached_only"]}
[17892,18490,19085,19677,20272,20622,21210,21802,21826,22382,1,"Grades"]
[20117,20595,21261,21826,22070,22719,23368,24017,24666,25315,2]
[21949,22681,23413,24145,24877,25609,26341,27073,27805,28537,3]
[24641,25462,26283,27104,27925,28746,29567,30388,31209,32030,4]
[27568,28487,29406,30325,31244,32163,33082,34001,34920,35839,5]
[30730,31754,32778,33802,34826,35850,36874,37898,38922,39946,6]
[34149,35287,36425,37563,38701,39839,40977,42115,43253,44391,7]
[37819,39080,40341,41602,42863,44124,45385,46646,47907,49168,8]
[41771,43163,44555,45947,47339,48731,50123,51515,52907,54299,9]
[46000,47533,49066,50599,52132,53665,55198,56731,58264,59797,10]
[50538,52223,53908,55593,57278,58963,60648,62333,64018,65703,11]
[60575,62594,64613,66632,68651,70670,72689,74708,76727,78746,12]
[72032,74433,76834,79235,81636,84037,86438,88839,91240,93641,13]
[85120,87957,90794,93631,96468,99305,102142,104979,107816,110653,14]
[{"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"},15]
["A","B","C","D","E","F","G","H","I","J"]
["Fed step 1",2,3,4,5,6,7,8,9,10]

{"sheet":"LocalityPay","index":8,"n_rows":35,"n_cols":2,"rows_kept":35,"flags":["formulas_cached_only"]}
["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]
["Locality Pay Area","Rate"]

{"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]