tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 130394d1322240879-excel-2007-phone-number-repeated-copy-of-example-1-
Sheet: Sheet1

Trouble # | Service Instance | Customer | Time Received | Trouble Type | Time Cleared/Closed | Recurrence | Repeat below? | Intervention? | What Was Done | Trouble Disposition | Resolution Comments | Root Cause | MTTR
TR0000007979905 | 5195551234 | Customer 1 | 2010-12-09 09:10:32 | Packet Loss | 2010-12-09 10:33:25 | 2 | Yes | No | Did Not Assist Trouble Ticket | G11R | TOK IN LANTERN/IN SYNC WITH TRAFFIC/SS ALLSTREAM JUST [NAME] AND ALL IS OK NOW/TOK NTF. | [NAME]
TR0000008184791 | 5195551235 | Customer 1 | 2011-02-01 09:32:55 | TR Cancel |  | 1 | No | No | TR Cancel | 0 | 0 | TR Cancel
TR0000008189747 | 6135551234 | Customer 1 | 2011-02-02 10:07:16 | Sync with no connectivity | 2011-02-03 15:48:42 | 1 | No | Yes | Closed Ticket | G11R | sync ok-customer not available -data flow ok-pls refer bck to isp | ISP
TR0000008760765 | 5195551234 | Customer 2 | 2011-06-09 09:25:18 | Other | 2011-06-09 13:07:42 | 0 | Yes | Yes | Tested & Dispatched Field Technician | Turned Back To ISP - Defective Modem- ISP to Fix | LTOK/full sync/2wy traffic, al1_d6016-6016-384_u800-800-256   profile/errors @ modem end/on hold 10 mins | N.T.F
TR0000009166395 | 6135554530 | Customer 2 | 2011-09-09 11:29:13 | Sync with no connectivity | 2011-09-13 13:07:38 | 2 | Yes | Yes | Tested & Dispatched Central Office Technician | F99R | BH=00.00;AB;ntf working on slam 7441 sec visite bill dmc allstream/FOK out OTHER-UNKNOWN, FIRE, RODENTS OR INSECTS | N.T.F
Spreadsheet: d4d9237b-e8b3-447f-8b6c-d35fc83e1b47
Sheet: Sheet1

COMMUNITY PROJECT/ZONING | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Case No SD1294 - The Washinton Irving Condominium - Preliminary Plat
Brief Title |  |  | Approval Deadline
To consider approval of a preliminary plat in District R-5
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor | City Planning & Development Director
 |  |  |  |  |  | [NAME], AICP
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  | 4th District
 |  |  |  |  | or Groups |  | (Glover & Blackwood)
 | Reason for Legislation |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | City Development
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | none known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For |  | with conditions
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or |  | City Plan Commission |  |  |  |  |  |  |  | (7-0)   12-19-06
 |  |  |  |  | Commission |  | By |  |  | (Archie, [NAME], Graf, Holwick, Macy,
 |  |  |  |  | Recommendation |  |  |  |  | Martin and Myers)
 |  |  |  |  |  |  | X |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  | X |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
Fact Sheet Prepared By: |  |  | Date:   01-08-07
 | [NAME] |  |  |  | Initial application filed 10-20-2006
 | Staff Planner |  |  |  | Plans corrected per CPC 01-08-07
Reviewed by: |  |  | Date:  01-08-07
 | [NAME], Manager
 | Development Management
Reference Numbers
Spreadsheet: 052eed46-872e-4136-9710-397485f35a9b
Sheet: BUDGET NARRATIVE

Grantee Name: | ORGANIZATION
Budget Item | Justification/Explanation
STAFF CATEGORY
SALARIES
Executive Director: $[NAME],[NAME] XX%
Staff member: $[NAME],[NAME] XX%
Staff member: $[NAME],[NAME] XX%
BENEFITS
Executive Director @ XX%
Staff member @ XX%
Staff member @ XX%
EQUIPMENT CATEGORY
EQUIPMENT PURCHASE
[NAME]
EQUIPMENT LEASE/RENTAL
[NAME]
EQUIPMENT MAINTENANCE AGREEMENTS
[NAME]
Computer/Server/Website Maintenance Agreements
OTHER CATEGORY
PROFESSIONAL SERVICES
Advertising
Attorney
Audit
Bookkeeping/Accounting
Information Technology
Insurance
Liability Insurance - Office
Liability Insurance - Directors & Officers
Worker's Comp
Payroll Service
Printing/Reproduction
Staff Training/Education
Computer Software
Meeting Room Charge
PROFESSIONAL MEMBERSHIP DUES/SUBSCRIPTIONS
Organizational Membership Dues
Other Membership Dues
Newspaper Meeting Notices
Office Supplies
Program Supplies
Postage and Overnight Mail
REASONABLE ACCOMMODATIONS
Interpreter Services
OCCUPANCY EXPENSES
Rent
Cleaning/Maintenance
Utilities
TELEPHONE/INTERNET/FAX
Cell phone service
Land line telephone service
[NAME]
Internet service
TRAVEL
Travel - Lodging
Travel - Meals
Travel - Transportation
Administrative Overhead
Spreadsheet: 766274d1643824098-dragging-formula-while-skipping-cells-that-contain-data-example-1-
Sheet: Sheet1

First Name | Last Name
 | Family/Con | 0
 | English 9 | 1
 | WA HIST | 0
 | Marq/Laser | 0
First Name | Last Name
 | Algebra 1 | 1
 | Ag Mech | 1
 | Art 1 | 3
 | Fitness | 2.3
First Name | Last Name
 | Algebra 1 | 3.3
 | CWU TH 107 | 2
 | ART 1 | 4
 | English 9 | 3.7
First Name | Last Name
 | Family/Con | 0
 | Algebra 1 | 1
 | WA HIST | 0
 | Band | 4
First Name | Last Name
 | Fitness | 2.3
 | Ag Mech | 1
 | Adv Ag Mech | 0
 | English 9 | 0
First Name | Last Name
 | Family/Con | 1.7
 | Algebra 1 | 1
 | Adv Ag Mech | 2.3
 | Ag Mech | 1
First Name | Last Name
 | Family/Con | 1.7
 | Drama | 1
 | ART 1 | 1.7
 | English 9 | 1.7
First Name | Last Name
 | Choir | 4
 | Algegra | 2.3
 | Family/Con | 2.7
 | English 9 | 3.3
Spreadsheet: 876146d1722833876-adding-grand-total-at-end-and-doing-sum-of-each-column-hstack-with-grand-total
Sheet: RequiredOutput

 | Head 4 | Head 5 | Head 6 | Head 8
X | 725 | 188 | 583307.07 | 117
Y | 817165.55 | 294052 | 19538.3 | 484886.79
Grand Total |  |  |  |  | <This I require in formula
Spreadsheet: 216808d1361894012-help-with-nested-vlookup-function-to-calculate-estimated-annual-insurance-premium-ckg-operating-costs
Sheet: Estimate Form

Car Operating Cost Estimate Form
Data Inputs
Expected number of drving miles per year: |  |  |  |  |  |  | 25000
Type of driving: |  |  |  |  |  |  | Mixed
Purchaser's state: |  |  |  |  |  |  | IL
Purchaser's residential status: |  |  |  |  |  |  | Suburban
Purchaser's driving safety record: |  |  |  |  |  |  | Average
Gas price adjustment percentage" |  |  |  |  |  |  | 1.13
Model # | Make | Description | # [NAME] | Gas $/yr | Insurance $/yr | Avg. Maint. $/yr | Annual Operating Costs
1 |  |  | 4
4 |  |  | 6
5 |  |  | 8
7 |  |  | Turbo
Spreadsheet: mike_swerzbin__28069__EMR Prices
Sheet: Sheet1

 |  | Peak |  | Off-Peak
Region | Delivery Date | Low | High | Low | High
Red numbers indicate flat, 24-hour products.
NW/N. Rockies | 2002-01-09 00:00:00 | 18 | 19 | 15 | 16
Mid-Columbia | 2002-01-09 00:00:00 | 18 | 19 | 15 | 16
COB | 2002-01-09 00:00:00 | 20 | 21.25 | 16.5 | 17
N. California | 2002-01-09 00:00:00 | 22.25 | 23.75 | 16.5 | 18
Midway/Sylmar | 2002-01-09 00:00:00 | NA | NA | NA | NA
S. California | 2002-01-09 00:00:00 | 21.25 | 23 | 15 | 17.25
Mead | 2002-01-09 00:00:00 | 21 | 22.5 | 14 | 14.75
Palo Verde | 2002-01-09 00:00:00 | 20 | 22 | 13.2 | 15
Inland SW | 2002-01-09 00:00:00 | 20 | 22.5 | 13.2 | 15
4-Corners | 2002-01-09 00:00:00 | 20 | 21.5 | 13 | 14
Central Rockies | 2002-01-09 00:00:00 | 17.75 | 18.75 | 14.25 | 15.5
Spreadsheet: 270989d1381776905-rank-or-range-grouped-rows-based-on-criterial-in-a-different-column-excel-forum-question-101413
Sheet: Systems (2)

Global Grade | total | votes | average | rank | [NAME] | scaled score | range | scale range | normalized score
6 | 2 | 2 | 1 | 2 | 2 | 1 | 1 | 20 | 20
6 | 4 | 2 | 2 | 1 | 2 | 0 | 1 | 20 | 0
7 | 2 | 2 | 1 | 3 | 3 | 2 | 1.5 | 13.33333333333333 | 20
7 | 5 | 2 | 2.5 | 1.5 | 3 | 0.5 | 1.5 | 13.33333333333333 | 0
7 | 5 | 2 | 2.5 | 1.5 | 3 | 0.5 | 1.5 | 13.33333333333333 | 0
8 | 2 | 2 | 1 | 9 | 9 | 8 | 8 | 2.5 | 20
8 | 4 | 2 | 2 | 7.5 | 9 | 7 | 8 | 2.5 | 17.5
8 | 9 | 3 | 3 | 5.5 | 9 | 6 | 8 | 2.5 | 15
8 | 6 | 2 | 3 | 5.5 | 9 | 6 | 8 | 2.5 | 15
8 | 6 | 3 | 2 | 7.5 | 9 | 7 | 8 | 2.5 | 17.5
8 | 7 | 1 | 7 | 3 | 9 | 2 | 8 | 2.5 | 5
8 | 5 | 1 | 5 | 4 | 9 | 4 | 8 | 2.5 | 10
8 | 9 | 1 | 9 | 1 | 9 | 0 | 8 | 2.5 | 0
8 | 8 | 1 | 8 | 2 | 9 | 1 | 8 | 2.5 | 2.5
9 | 4 | 3 | 1.333333333333333 | 5 | 5 | 3.666666666666667 | 2 | 9.999999999999998 | 20
9 | 3 | 2 | 1.5 | 4 | 5 | 3.5 | 2 | 9.999999999999998 | 18.33333333333333
9 | 10 | 3 | 3.333333333333333 | 1 | 5 | 1.666666666666667 | 2 | 9.999999999999998 | 0
9 | 6 | 2 | 3 | 2.5 | 5 | 2 | 2 | 9.999999999999998 | 3.333333333333336
9 | 6 | 2 | 3 | 2.5 | 5 | 2 | 2 | 9.999999999999998 | 3.333333333333336
 |  |  | current formula for rank | .=RANK.AVG(Y3,$Y$3:$Y$4)
 |  |  | current formula for range | =MAX($AB$3:$AB$4)-MIN($AB$3:$AB$4)
Spreadsheet: 868062d1714761268-index-match-function-indexequiv
Sheet: Out

Semaine | Heures  travaillees | Heures temporaires | Heures supplementaires | Conge rais pers - Planifie | Conge rais pers - Urgent | PAICD - approuve | Conge special | Accident du travail | [NAME] (PT&TP) | Conge non-paye |  | 2023
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
Spreadsheet: 127882d1320671677-conditional-formatting-to-indicate-start-date-and-end-date-sample1
Sheet: Main

Name | Start | End | TOTAL
 |  |  | AL | MC | HS | EL | CL | TR | NCNS
Name | 2011-11-01 00:00:00 | 2012-01-10 00:00:00
[NAME] | 2011-11-01 00:00:00 | 2011-12-10 00:00:00
Name3 | 2011-11-01 00:00:00 | 2011-12-10 00:00:00
Name4 | 2011-11-01 00:00:00 | 2011-12-10 00:00:00
Name5 | 2011-11-01 00:00:00 | 2011-12-10 00:00:00
Name6 | 2011-11-01 00:00:00 | 2011-12-10 00:00:00
Name7 | 2011-11-01 00:00:00 | 2011-12-10 00:00:00
Name8 | 2011-11-01 00:00:00 | 2011-12-10 00:00:00
Name9 | 2011-11-01 00:00:00 | 2011-12-10 00:00:00
Name10 | 2011-11-01 00:00:00 | 2011-12-10 00:00:00
Name11 | 2011-11-01 00:00:00 | 2011-12-10 00:00:00
Name12
Name13
Name14
Changing the dates in green column reflects on other sheets according to their respective months
AL | Annual Leave
MC | Medical Leave
TR | Training
Spreadsheet: 129044d1321424079-how-to-validate-the-two-sheets-report-sales-check
Sheet: Manager

2011-11-16 00:00:00
 | Electronics | Books | Fruits | Vegetables
A01 | 10000 | 23636 | 43536 | 966626
A03 | 10000 | 23636 | 43536 | 10000
A02 | 1245698 | 4458723 | 212246497 | 23213586
B03 | 23636 | 63582 | 4458723 | 2123646
B06 | 10000 | 23636 | 43536 | 966626
B04 | 23636 | 4458723 | 212246497 | 23636
A04 | 43536 | 43536 | 966626 | 43536
B05 | 966626 | 4458723 | 212246497 | 966626
A05 | 10000 | 78596 | 1245698 | 23636
B06 | 10000 | 23636 | 43536 | 966626
B02 | 78596 | 63582 | 324893 | 2123646
A04 | 43536 | 43536 | 966626 | 43536
Spreadsheet: 292431d1390592410-changing-reference-saving-original-calculations-changingreference
Sheet: Cost Entries

[NAME] | Level | Cost
1 | High
5 | Low
8 | Medium
9 | Low
4 | Low
5 | Low
67 | High
58 | High
89 | Medium
62 | High
54 | Low
85 | Medium
26 | High
48 | High
69 | Low
Spreadsheet: 83237d1283263593-sumproduct-not-calculating-sumproduct
Sheet: Sheet1

Period | 2010-08-02 00:00:00 | 2010-08-06 00:00:00
Previous Week Avg | #N/A | #N/A
Current Week Avg | #N/A | #N/A
Delta % | nm | nm
 | DJIA | DJIA
 | INDU INDEX | INDU INDEX
DATES | Px Last | [NAME]
2010-08-01 00:00:00
2010-08-02 00:00:00 | 8952.89 | 233763168
2010-08-03 00:00:00 | 9015.1 | 215443120
2010-08-04 00:00:00 | 8769.7 | 266736080
2010-08-05 00:00:00 | 8742.46 | 226743728
2010-08-06 00:00:00 | 8599.18 | 204302256
2010-08-07 00:00:00
2010-08-08 00:00:00
2010-08-09 00:00:00 | 8473.97 | 273558400
2010-08-10 00:00:00 | 8448.56 | 304050912
2010-08-11 00:00:00 | 8200.14 | 355087552
2010-08-12 00:00:00 | 8212.49 | 436916032
2010-08-13 00:00:00 | 8281.22 | 439447360
2010-08-14 00:00:00 | 8375.45 | 357940800
2010-08-15 00:00:00
2010-08-16 00:00:00
2010-08-17 00:00:00 | 7949.09 | 419419392
2010-08-18 00:00:00 | 8228.1 | 410143488
2010-08-19 00:00:00 | 8122.8 | 420081120
2010-08-20 00:00:00 | 8077.56 | 370524992
2010-08-21 00:00:00
2010-08-22 00:00:00
2010-08-23 00:00:00 | 8116.03 | 316729184
2010-08-24 00:00:00 | 8174.73 | 247782304
2010-08-25 00:00:00 | 8375.45 | 357940800
2010-08-26 00:00:00 | 8149.01 | 247467424
2010-08-27 00:00:00 | 8000.86 | 303210368
2010-08-28 00:00:00
2010-08-29 00:00:00
2010-08-30 00:00:00 | 8000.86 | 303210368
2010-08-31 00:00:00 | 9034.69 | 213710336
Spreadsheet: 764074d1642565698-consolidate-multiple-tabs-with-different-headers-not-using-power-query-copy-of-sample-book-1
Sheet: Merge Summary

[NAME] | Last Update | Building | Name | Size | User ID | Stage |  |  |  |  | 0 | 0 | 0 | 0 |  |  | IDX | TAB_List | Count_Each
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAB 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAB 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAB 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAB 4
Spreadsheet: 782657d1654173415-goal-seek-conditional-sum-product-is-this-possible-sump-goal-seek
Sheet: Sheet1

 |  |  |  |  |  | Target | Achieved
 |  |  |  |  |  | 670
 |  |  |  |  | Fixed ratio | Can be integer only
 |  |  |  | 4 | 0.032
 |  |  |  | 8 | 0.064
 |  |  |  | 12 | 0.096
 |  |  |  | 24 | 0.096
 |  |  |  | 36 | 0
 |  |  |  | 48 | 0.288
 |  |  |  | 108 | 0.432
 |  |  |  |  |  | OBJECTIVE: To achieve combination that is closest to target
Spreadsheet: 188022d1350658891-search-box-in-excel-to-search-key-words-in-sentences-in-multiple-worksheets-example-fi
Sheet: Search 

 |  |  |  |  | Sheet | Question From | Row
 | Search Box |  | Button
 | #This spreadsheet will contain all the questions/answers we have encountered from  documents/files/reports/etc. I will upload questions/answers into the different worksheets depending on category.  #Column A of each sheet will have the name of document/file/report.  #Column B would contain the question or answer we provided #I would like to use a search box, to type a key word that I would like to find across the different worksheets. The search would look into the questions/answers Column B, through the texts (random length of sentence). And then provide in search sheet, the sheet that contains the word (Column F), the document the word came from (Column G) and the row it is found in (Column H).  #I would like to add extra questions/answers to the different  worksheets and even produce new ones. So it would be very helpeful to understand what formula/macro changes I need to complete to update Excel document
 | #For example if I wanted to search the word "Technology", The results list would contain:
 |  |  |  |  | Sheet | Question From | Row
 |  |  |  |  | Financial Questions | Document C | 4
 |  |  |  |  | Management Questions | Document A | 2
 |  |  |  |  | Security Questions | Document Y | 2
 |  |  |  |  | Executive Summary | Management Report X | 4
Spreadsheet: tracy_geaccone__40418__2001 UAF
Sheet: Sheet1

 |  | January | February | March | April | May | June | July | August | September | October | November | December | YTD
Fuel / UAF - UAF Used (Expense) |  | -52 | 1032 | 138 | -413 | -80 | 760 | 995 | 248 | 192 | -301 | 81 | -103 | 2497
- UAF Measurement Adjustment (Expense) |  | 0 | 0 | -1100 | 402 | 0 | -753 | -1003 | 0 | 0 | 0 | 0 | 0 | -2454
- UAF Imbalance Adjustment (Expense) |  | 0 | 0 | -950 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -950
Spreadsheet: 160602d1339136213-finding-player-and-avg-top-3-scores-copy-of-ringer-percent-experiment3
Sheet: Sheet2

 |  |  |  |  |  | bc canstat
card # | Name |  | Prov | Div | ringer avg | best 3 avg | events
614111 | Smith | [NAME] | bc |  | 43.85714285714285 | 0 | 7
614112 | Cole | [NAME] | bc |  | 21.2 | #N/A | 5
614016 | Moffat | [NAME] | bc |  | 4.125 | #N/A | 8
Spreadsheet: mark_taylor__24994__Week 7 Lines
Sheet: Sheet1

 | Wk 7
 | Spread
 | Favorite |  | Underdog
Saturday | Miami (Fla.) | 7 | FLORIDA STATE
 | Syracuse | 4 | PITTSBURGH
 | [NAME] | 7 | NAVY
 | VIRGINIA TECH | 20 | Boston College
 | Wake Forest | 8.5 | DUKE
 | NORTH CAROLINA | 8 | Virginia
 | Illinois | 4 | INDIANA
 | MICHIGAN STATE | 5.5 | Iowa
 | MICHIGAN | 11 | Purdue
 | NORTHWESTERN | 13 | Minnesota
 | Ohio | 8 | CENTRAL MICHIGAN
 | East Carolina | 13.5 | ARMY
 | WESTERN MICHIGAN | 9.5 | Bowling Green
 | [NAME] | 26 | BUFFALO
 | Texas | 18 | OKLAHOMA STATE
 | Oklahoma | 21 | KANSAS
 | MIAMI (OHIO) | 8.5 | Akron
 | Kansas State | NL | TEXAS TECH
 | Nebraska | 33.5 | BAYLOR
 | Iowa State | 2.5 | MISSOURI
 | Northern Illinois | 11 | KENT
 | NOTRE DAME | 12 | West Virginia
 | MISSISSIPPI STATE | 25 | Troy State
 | Fresno State | 7 | COLORADO STATE
 | AIR FORCE | 14.5 | Wyoming
 | ARKANSAS STATE | 4 | UL-Lafayette
 | [NAME] | 14 | NEW MEXICO
 | Alabama | 7.5 | MISSISSIPPI
 | UCLA | 11.5 | Washington
 | OHIO STATE | 10.5 | Wisconsin
 | Florida | 21 | AUBURN
 | Texas Christian | 10.5 | TULANE
 | COLORADO | 8 | Texas A&M
 | Oregon | 14 | CALIFORNIA
 | TEMPLE | 11.5 | Rutgers
 | Middle Tenn. State | 14 | NORTH TEXAS
 | Louisiana Tech | 10 | NEVADA
 | ALA.-BIRM. | 7.5 | Cincinnati
 | SAN JOSE STATE | 7 | Southern Methodist
 | STANFORD | 3.5 | Wasington State
 | [NAME] | 8.5 | EASTERN MICHIGAN
 | SOUTHERN CALIFORNIA | 2.5 | Arizona State
 | UNLV | 4.5 | San Diego state
 | Georgia | 8 | VANDERBILT
 | South Carolina | 9 | ARKANSAS
 | SOUTH FLORIDA | 18 | Connecticut
 | LSU | 15.5 | Kentucky
 | Clemson | 3.5 | NORTH CAROLINA STATE
 | NEW MEXICO ST. | 13 | Idaho
 | Memphis | 7 | HOUSTON
 | BOISE STATE | 13 | Tulsa
 | OREGON STATE | 6 | Arizona
 | HAWAII | 7 | Texas-El Paso
Spreadsheet: e2a710f0-b8db-430d-b74a-6cb344a63fc8
Sheet: data dictionary

Worksheets
by County | 2010 Census, 2010 Previous Estimate & 2040 data summarized by county
by MCD | 2010 Census, 2010 Previous Estimate & 2040 data summarized by Minor Civil Division (Political Townships)
by Municipality | 2010 Census, 2010 Previous Estimate & 2040 data summarized by Municpality, includes a record for the unincorporated portion of each county, highlighted in red. Municipal summaries are approximate and follow quartersection (subzone) boundaries. Refer to map to see how they line up.
A note concerning township (MCD) and municipal summaries:
Aggregation of forecast data to the municipal and township level was created through a GIS-based exercise, where whole subzones were assigned to municipalities and townships based on the proximity of each subzone’s central point (centroid) to current municipality/township boundaries.  Therefore, these summaries do not exactly account for population residing within existing municipal boundaries; they are approximate.  [NAME] to the PDF maps available on the CMAP website for depictions of “assigned” municipal and township boundaries used to generate these summaries. These subzone aggregations were created for tabulation purposes only, and are not intended to suggest or predict the future extent of any community.
Link to map | Municipal subzone assignment map (PDF, 7 MB)
Link to map | Township subzone assignment map (PDF, 6 MB)
Variables
2010 Census, Summarized to Subzone
HH10 | 2010 Census households
PHH10 | 2010 Census population in households
PNGQ10 | 2010 Census population in group quarters
EMP10 | Current total employment (2012 update)
RET10 | Current retail employment (2012 update)
2010 Pre-Census Estimates Used as Forecast Base
HH10_FB | 2010 households as ESTIMATED in 2010 and used as basis for 2040 Projections
PHH10_FB | 2010 population in households as ESTIMATED in 2010 and used as basis for 2040 Projections
PNGQ10_FB | 2010 population in group quarters as ESTIMATED and used as basis for 2040 Projections
EMP10_FB | 2010 total employment as ESTIMATED in 2010 and used as basis for 2040 Projections
RET10_FB | 2010 retail employment as ESTIMATED in 2010 and used as basis for 2040 Projections
2040 Forecast
HH40 | 2040 households
PHH40 | 2040 population in households
PNGQ40 | 2040 population in group quarters
EMP40 | 2040 employment
RET40 | 2040 retail employment
Questions? | Contact [NAME]
 | [EMAIL]
 | Sepember 10,2012
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 123129 | - | 69754
Cross-Currency Fixed-Fixed | - | 3468 | - | 3274
Cross-Currency Fixed-Float | - | 2617 | - | 637
TOTAL | - | 129214 | - | 73665
Spreadsheet: 190201d1351556810-how-to-consolidate-data-with-different-paramenter-test
Sheet: Output

 | Project
 | A | B | C | D
Account Desciption
Revenue
Government
Private
Contract
Revenue Total
Cost
Description
Prime Costs
Material Usage
Sub-Contractor Fees
Worker Overtime
Worker Salary
Prime Costs Total
Direct Costs
Advertising & Promotion
Client Welfare
Discount Allowed
Docking Expenses
Donation
Employees Medical Fees
Employees Welfare
Entertainment
Freight Charges
Fuel & Oil Usage
Hire Charges
Inspection
[NAME] oil
Maint Of Building And Infra
Printing
Professional Fees
Realized Forex Loss
Refreshment
Sea Trial
Stationery
Telephone And Telefax
Tendering Expenses
Travelling-Accommodation
Travelling-Fares
Travelling-Subsist Allowance
Vehicle Running Exp-Fuel & Oil
Vehicle Running Exp-Others
X-Ray & Radiography
Direct Costs Total
Cost Total
Gross Profit
Spreadsheet: 738019d1624765344-formula-to-copy-data-from-one-sheet-to-another-excelformula
Sheet: NewData

Date | Number |  | Name
2021-06-16 | 19.26 |  | [NAME]
2021-06-17 |  |  | [NAME]
2021-06-18 | 21.33 |  | [NAME]
2021-06-19 |  |  | [NAME]
2021-06-20 | 22.13 |  | [NAME]
2021-06-21 | 22.51 |  | [NAME]
2021-06-22 | 22.72 |  | [NAME]
2021-06-23 |  |  | [NAME]
2021-06-16 | 6.84 |  | Fred
2021-06-17 | 6.87 |  | Fred
2021-06-18 | 6.98 |  | Fred
2021-06-19 | 7.06 |  | Fred
2021-06-20 | 7.14 |  | Fred
2021-06-21 |  |  | Fred
2021-06-22 |  |  | Fred
2021-06-16 | 0.51 |  | [NAME]
2021-06-17 |  |  | [NAME]
2021-06-18 |  |  | [NAME]
2021-06-19 | 0.56 |  | [NAME]
2021-06-20 |  |  | [NAME]
2021-06-21 | 0.65 |  | [NAME]
2021-06-22 |  |  | [NAME]