tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 329973d1404472373-converting-rankings-to-scores-for-a-sports-spreadsheet-sports-day-results-spreadsheet
Sheet: Boys

Boys
100m Heat 1 |  |  |  |  | 100m Heat 2 |  |  |  |  | 100m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N | 4 | 5 |  |  | N |  |  |  |  | N
 | P | 5 | 4 |  |  | P |  |  |  |  | P
 | Q | 6 | 3 |  |  | Q |  |  |  |  | Q
 | R | 3 | 6 |  |  | R |  |  |  |  | R
 | S | 2 | 8 |  |  | S |  |  |  |  | S
 | T | 8 | 1 |  |  | T |  |  |  |  | T
 | V | 7 | 2 |  |  | V |  |  |  |  | V
 | X | 1 | 10 |  |  | X |  |  |  |  | X
Boys
200m Heat 1 |  |  |  |  | 200m Heat 2 |  |  |  |  | 200m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Boys
400m Heat 1 |  |  |  |  | 400m [NAME] |  |  |  |  | 400m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Boys
800m Heat 1 |  |  |  |  | 800m Heat 2 |  |  |  |  | 800m Final
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Boys
Javelin |  |  |  |  | Discus |  |  |  |  | [NAME]
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Long Jump |  |  |  |  | High Jump |  |  |  |  | 4x100 Relay
Name | Form | Position | Points |  | Name | Form | Position | Points |  | Name | Form | Position | Points
 | N |  |  |  |  | N |  |  |  |  | N
 | P |  |  |  |  | P |  |  |  |  | P
 | Q |  |  |  |  | Q |  |  |  |  | Q
 | R |  |  |  |  | R |  |  |  |  | R
 | S |  |  |  |  | S |  |  |  |  | S
 | T |  |  |  |  | T |  |  |  |  | T
 | V |  |  |  |  | V |  |  |  |  | V
 | X |  |  |  |  | X |  |  |  |  | X
Spreadsheet: 152095d1335257335-producing-monthly-totals-tied-to-a-calendar-output-counter
Sheet: Sheet2

 | Windows |  |  | Doors
 | Outer Frame | Sash | Completed  Window Units | Door Frame | [NAME] | Completed  Door Units
2012-04-23 00:00:00
 |  |  |  |  |  |  | WINDOWS | DOORS
 |  |  |  |  |  |  | Monthly Output | Monthly Output
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  |  | WINDOWS | DOORS
 |  |  |  |  |  |  | Monthly Output | Monthly Output
Spreadsheet: 91285d1291053281-sumproduct-function-sumproduct
Sheet: Sheet1

 |  | Stock code | Ingredient | Quantity
 |  | AAA |  | 500
 |  | BBB |  | 1500
 |  | BBB |  | 2500
 |  | CCC |  | 1200
 |  | DDD |  | 4855
 |  | AAA |  | 2650
 |  | BBB |  | 4850
 |  | FFF |  | 4158
 |  | CCC |  | 4589
 |  | AAA |  | 4554
 |  | FFF |  | 4582
 |  | AAA |  | 4589
 |  | BBB |  | 2547
 |  | GGG |  | 3500
 |  | DDD |  | 2598
 |  | AAA |  | 1258
 |  | DDD |  | 4859
 |  | BBB |  | 1458
 |  | DDD |  | 5896
 |  | AAA |  | 48759
Spreadsheet: michelle_lokay__26627__imbalsumm0102
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 36840 | 37236
2 | 44709 | 44762
3 | 42744 | 42762 |  | 15000
4 | 42732 | 42762 |  | 15000
5 | 42708 | 42762 | 40 | 15000
6 | 48175 | 48262
7 | 33784 | 33736
8 | 44644 | 44762
9 | 44746 | 44762
10 | 44757 | 44762
11 | 44761 | 44762
12 | 44742 | 44762
13 | 44751 | 44762
14 | 44721 | 44762
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00
2001-02-14 00:00:00
Spreadsheet: 788048d1658239989-auto-populate-a-cell-based-on-exact-adjacent-value-when-having-same-names-book-sample1
Sheet: Sheet1

Number | Name | Serial |  |  |  | Serial | Name | Number
10 | [NAME] | 66666 |  |  |  |  |  |  | 10_Bonnie M_66666
10 | [NAME] | 55555 |  |  |  |  |  |  | 10_Bonnie M_55555
10 | [NAME] | 23335 |  |  |  |  |  |  | 10_Sarah H_23335
11 | Mac | 77777 |  |  |  |  |  |  | 11_Mac_77777
11 | [NAME] | 42224
12 | [NAME] | 55224 |  |  |  | These 2 columns don´t show the correct data from the right of the 2nd, or 3rd ¨10¨. When I press the 2nd or 3rd ¨10¨ in the I column I need the adjancet data coresponding to the right A cell.
12 | Doe | 12122
13 | [NAME] | 83838
14 | [NAME] | 21212
 |  |  |  |  | Example: | Should return 55555 | Should return [NAME] | 2nd 10
 |  |  |  |  |  | Should return 23335 | Should return [NAME] | 3rd 10
Spreadsheet: 175058d1345362156-drop-down-list-linking-data-issue-workbook
Sheet: Sheet1

Date | Details |  |  |  |  |  | Amount | Paid | [NAME]
 | Patient :                                                          ID No :
 | DOB :
 | Treating Provider :
 | ICD-10/Diagnoses :
 | Procedure(s) / Modifiers
AM | 72006 - INT Laser beam
 | 0006
Spreadsheet: 01d8bb0f-4c19-41fd-ad03-ec9799e1d47b
Sheet: FY 2007 Lease Turnover Analysis

FY 2007 Lease Turnover Analysis
Disposition Of Leases Expiring in FY 2007 | Sq Ft | % of Total Sq Ft | Count | % of Total Count
Leases Scheduled to Expire in FY 2007 | 23582505 | 1 | 1852 | 1
Extended in FY 2007 Beyond FY 2007 | 15152655 | 0.6425379746553642 | 1201 | 0.6484881209503239
Renewed During FY 2007 | 1562769 | 0.06626815090254407 | 79 | 0.04265658747300216
Replaced in Same Building with New Leases | 2111195 | 0.08952378044656409 | 228 | 0.123110151187905
Subtotal | 18826619 | 0.7983299060044724 | 1508 | 0.8142548596112311
Leases Terminated | 3387402 | 0.1436404656757202 | 236 | 0.1274298056155508
Leases Moved to Another Leased Building | 1368484 | 0.05802962831980742 | 108 | 0.05831533477321815
Subtotal | 4755886 | 0.2016700939955276 | 344 | 0.1857451403887689
[Non-add: Leases Terminated - Move to Federal Bldg | 390470 | 0.01655761336634934 | 27 | 0.01457883369330454 | ]
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 2361618 | 0.1001427965349737 | 122 | 0.06587473002159827 | ]
Disposition of Leases Expiring After FY 2007
Leases Scheduled to Expire After FY 2007 | 148004614 | 1 | 6680 | 1
Lease Replaced In Same Leased Building After [NAME] | 270022 | 0.00182441609556848 | 9 | 0.001347305389221557
Lease Replaced In Same Leased Building Before Firm Term | 500 | 3.378273058433165e-06 | 1 | 0.0001497005988023952
Lease Replaced In Different Leased Building After [NAME] | 263064 | 0.001777404047687324 | 27 | 0.004041916167664671
Lease Replaced In Different Leased Building Before Firm Term | 157955 | 0.001067230241889621 | 3 | 0.0004491017964071856
Lease Terminate W/O Lease Replacement After [NAME] | 634998 | 0.004290393271117886 | 67 | 0.01002994011976048
Lease Terminate W/O Lease Replacement Before Firm Term | 87422 | 0.0005906707746286883 | 14 | 0.002095808383233533
[Non-add: Leases Terminated - Move to Federal Bldg | 28206 | 0.0001905751397723317 | 2 | 0.0002994011976047904
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 399026 | 0.002696037570828704 | 55 | 0.008233532934131737
FY 2007 Lease Turnover
Total Leases At Start of FY 2007 | 171587119 | 1 | 8532 | 1
Same/Replacement Leases Continued Past FY 2007 | 165687794 | 0.965619068410374 | 8077 | 0.946671354899203
Same Lease Space Dis-Continued Past FY 2007 (Turnover) | 5899325 | 0.03438093158962591 | 455 | 0.053328645100797
[Non-add: Leases Terminated - Move to Federal Bldg | 418676 | 0.002440019987747448 | 29 | 0.003398968588842006
[Non-add: Leases Terminated - Canceled Agency Req. 1/ | 2760644 | 0.01608887669475935 | 177 | 0.02074542897327707
1/ Only counts actions where leases had to be terminated due to customer office closures, partial reductions in space not included.
Spreadsheet: 142040d1329596853-auto-populate-data-from-sheet-1-to-correct-location-in-subsequent-sheets-2012-fantasy-golf
Sheet: St Jude

 |  | WEEK 10 FedEx St. Jude Classic
 |  | Total Earnings |  |  |  | Rankings Through Week 10 | Total
 | [NAME] | 0 |  | 2 |  | [NAME]
 | [NAME] | 5000 |  | 1 |  | [NAME]
 | [NAME] | 0 |  | 3 |  | [NAME]
 |  | 0 |  | 4 |  | 0
 |  | 0 |  | 5 |  | 0
 |  | 0 |  | 6 |  | 0
 |  | 0 |  | 7 |  | 0
 |  | 0 |  | 8 |  | 0
 |  | 0 |  | 9 |  | 0
 |  | 0 |  | 10 |  | 0
 |  | 0 |  | 11 |  | 0
 |  | 0 |  | 12 |  | 0
 |  | 0 |  | 13 |  | 0
 |  | St. Jude Classic |  | YTD
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
Spreadsheet: andy_zipper__173__DYNEGY-ICE VOL Apr19
Sheet: E-Mail

 | 2001-04-19 00:00:00
 | Intercontinental Exchange |  |  | Enron's Activity on ICE
 | Commodity | Volume |  | Enron Entity | Commodity | Deals | Volume
 | TOTAL POWER (MWH) |  |  | EPM | POWER
 | TOTAL GAS (MMBTU) |  |  | ENA | GAS
 | >ICE PHYSICAL GAS |  |  | ENA | CRUDE
 | >ICE FINANCIAL GAS |  |  | ECC
 |  |  |  | Enron's Activity on Dynegy Direct
 |  |  |  | Enron Entity | Commodity | Deals | Volume
 |  |  |  | EPM | POWER
 |  |  |  | ENA | POWER
 |  |  |  | ENA | US NATURAL GAS
 |  |  |  | ENA | COAL
 |  |  |  | EGL | NATURAL GAS LIQUIDS
Spreadsheet: 836302d1689254475-pivot-table-conditional-formatting-based-on-item-and-qty-book1
Sheet: Sheet1

Data |  |  |  | Conditional Formats
Item | Qty |  |  | Pivot Table
Item 1 | 100 |  |  | Item 1
Item 2 | 50 |  |  | Item 2
Item 3 | 0 |  |  | Item 3
… |  |  |  | …
… |  |  |  | …
… |  |  |  | …
Item 1028 | 60 |  |  | Item 1028
Item 1029 | 40 |  |  | Item 1029
Spreadsheet: 0a9b17b0-ead7-4db6-a1f1-370e306e1011
Sheet: Sheet1

SEZIONE/DELEGAZIONE DI ………………….. | Unnamed: 1 | Unnamed: 2
BILANCIO PREVENTIVO ANNO SCAUT _____/_____
DISPONIBILITA' FINANZIARIE INIZIALI
 | Cassa
 | C/C bancario
 | [NAME] (depositi, ecc.)
 | [NAME]   (a) | 0
ENTRATE
 | [NAME]
 | Censimenti
 | Quote di Sezione
 | Quote per Uscite
 | Quote per Campi
 | …………………
 |  | 0
 | Autofinanziamento
 | [NAME] (quote straordinarie)
 | Da Scaut Shop
 | Da Attività/Eventi
 | ……………………
 |  | 0
 | Finanziamenti esterni
 | Contributi di Enti Pubblici
 | Contributi da Privati
 | ……………………
 |  | 0
 | TOTALE ENTRATE  (b) | 0
USCITE
 | Spese di gestione Sede
 | Affitto
 | Energia elettrica
 | Spese telefoniche
 | Acquedotto
 | [NAME]
 | Manutenzione locali
 | ……………………….
 |  | 0
 | Segreteria-Tesoreria
 | Censimenti
 | Cancelleria
 | Spese postali
 | Spese bancarie
 | ………………….
 |  | 0
 | Spese per attività associative
 | Spese per le [NAME]
 | Spese per Uscite
 | Spese per Campi
 | Spese per Attività/Eventi
 | …………………………..
 |  | 0
 | Spese Magazzino-Equipaggiamento
 | [NAME] attrezzature
 | Manutenzione attrezzature
 | Scaut Shop
 |  | 0
 | Spese di gestione automezzi
 | Assicurazioni - bollo
 | Carburanti - Lubrificanti
 | Manutenzioni - riparazioni
 |  | 0
 | TOTALE USCITE  (c) | 0
IL PRESIDENTE COMMISSARIO                                            IL TESORIERE
I REVISORI DEI CONTI
Spreadsheet: 376380d1423585657-would-like-to-say-hello-and-ask-for-so-suggestions-and-ideas-bedstate-2015
Sheet: Looking For

10th February 2015 | TOTAL BEDS LOOKING |  |  |  |  |  | Total Male | Total Female |  |  |  | MEDICAL BEDS
 | 0 |  |  |  |  |  | 0 | 0
17.00hrs
WARD | CAT 1 |  |  |  |  |  | WARD | CAT 2 |  |  |  |  |  | WARD | CAT 3
 | M | F | SrM | SrF | AcM | AcF |  | M | F | SrM | SrF | AcM | AcF |  | M | F | SrM | SrF | AcM | AcF
Westcliff |  |  |  |  |  |  | Westcliff |  |  |  |  |  |  | Westcliff
[NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
Eleanor Hobbs |  |  |  |  |  |  | Eleanor Hobbs |  |  |  |  |  |  | Eleanor Hobbs
Respiratory |  |  |  |  |  |  | Respiratory |  |  |  |  |  |  | Respiratory
ARCU |  |  |  |  |  |  | ARCU |  |  |  |  |  |  | ARCU
Cardiology |  |  |  |  |  |  | Cardiology |  |  |  |  |  |  | Cardiology
[NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME]
Estuary |  |  |  |  |  |  | Estuary |  |  |  |  |  |  | Estuary
ASU |  |  |  |  |  |  | ASU |  |  |  |  |  |  | ASU
Oncology |  |  |  |  |  |  | Oncology |  |  |  |  |  |  | Oncology
Paglesham |  |  |  |  |  |  | Paglesham |  |  |  |  |  |  | Paglesham
DME |  |  |  |  |  |  | DME |  |  |  |  |  |  | DME
General Medicine |  |  |  |  |  |  | General Medicine |  |  |  |  |  |  | General Medicine
Subtotal | 0 | 0 | 0 | 0 | 0 | 0 | Subtotal | 0 | 0 | 0 | 0 | 0 | 0 | Subtotal | 0 | 0 | 0 | 0 | 0 | 0
Total Medical | 0 |  |  |  |  |  | Total Medical | 0 |  |  |  |  |  | Total Medical | 0
Total beds looking for | 0 |  |  |  |  |  | Total beds looking for | 0 |  |  |  |  |  | Total beds looking for | 0
 |  |  |  |  |  |  |  | SURGICAL BEDS
 | M | F | SrM | SrF | AcM | AcF
 |  |  |  |  |  |  |  |  |  |  | Main Bay |  |  | SR | Total
CAT 1 | 0 | 0 | 0 | 0 | 0 | 0 |  | Males |  |  | 0 |  |  | 0 | 0
CAT 2 | 0 | 0 | 0 | 0 | 0 | 0 |  | Females |  |  | 0 |  |  | 0 | 0
CAT 3 | 0 | 0 | 0 | 0 | 0 | 0 |  | Grand Total |  |  | 0
Spreadsheet: 4514b961-f124-4616-a4ee-31e33bbdfbfa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
EXECUTIVE COUNCIL - District No. 1
2000-09-12 00:00:00 | Burton, r | [NAME], r |  | [NAME]
Albany | 49 | 11
[NAME] | 121 | 27
Alton | 374 | 124 |  | 1
Ashland | 165 | 24
Atkinson & Gilmanton Academy Grant | 0 | 0
[NAME] | 261 | 45
Bath | 85 | 8
Bean's Grant | 0 | 0
Bean's Purchase | 0 | 0
Belmont | 351 | 101 |  | 2
[NAME] | 22 | 9 |  | 1
[NAME] | 91 | 10
[NAME] | 111 | 13
[NAME] 3 | 189 | 22 |  | 2
[NAME] 4 | 52 | 7
Bethlehem | 166 | 23
Bridgewater | 104 | 34
Bristol | 298 | 60
Cambridge | 0 | 0
Campton | 203 | 42
Canaan | 194 | 52
Carroll | 66 | 11
Center Harbor | 151 | 17 |  | 3
[NAME]'s Purchase | 0 | 0
Charlestown | 151 | 73
Chatham | 32 | 3
Claremont Ward 1 | 120 | 79 |  | 1
Claremont Ward 2 | 200 | 151
Claremont Ward 3 | 144 | 69
[NAME] | 47 | 5
Colebrook | 295 | 36
Columbia | 6 | 77 |  | 1
Conway | 655 | 92 |  | 2
Cornish | 118 | 37
Crawford's Purchase | 0 | 0
Croydon | 46 | 19
Cutt's Grant | 0 | 0
[NAME] | 89 | 8
Dix's Grant | 0 | 0
Dixville | 20 | 0
Dorchester | 25 | 10
Dummer | 45 | 0
Easton | 38 | 2
Eaton | 43 | 11
[NAME] | 71 | 25
Ellsworth | 12 | 4
Enfield | 221 | 33 |  | 1
Errol | 32 | 10
Erving's Location | 0 | 0
Franconia | 99 | 11
Freedom | 153 | 45
Gilford | 669 | 129 |  | 2
[NAME] | 122 | 13
[NAME] | 91 | 20
Grantham | 226 | 79 |  | 1
Green's Grant | 0 | 0
Hadley's Purchase | 0 | 0
[NAME] | 30 | 11
Hale's Location | 19 | 1
Hanover | 363 | 107 |  | 1
Hart's Location | 12 | 1
Haverhill | 575 | 76
Hebron | 109 | 19
Holderness | 191 | 34
[NAME] | 118 | 10
[NAME] | 135 | 29 |  | 1
Kilkenny | 0 | 0
[NAME] | 324 | 90
[NAME] | 234 | 34 |  | 2
[NAME] 3 | 238 | 44
[NAME] | 176 | 36 |  | 1
[NAME] | 145 | 18 |  | 3
[NAME] 6 | 245 | 29
Lancaster | 349 | 34
Landaff | 38 | 3
Lebanon Ward 1 | 216 | 53
Lebanon Ward 2 | 166 | 41
Lebanon Ward 3 | 223 | 45
Lincoln | 120 | 13
Lisbon | 115 | 16 |  | 1
Littleton | 660 | 55 |  | 1
Livermore | 0 | 0
Low & Burbank's Grant | 0 | 0
[NAME] | 43 | 7
Lyme | 113 | 21
[NAME] | 195 | 24 |  | 1
Martin's Location | 0 | 0
Meredith | 556 | 113
Milan | 119 | 18
[NAME] | 8 | 0
Monroe | 110 | 9
Moultonborough | 566 | 174 |  | 1
New Hampton | 148 | 54
Newport | 267 | 118 |  | 2
Northumberland | 121 | 16
[NAME] | 0 | 0
Orange | 28 | 2
Orford | 81 | 18
Ossipee | 227 | 53 |  | 1
Piermont | 94 | 13 |  | 1
[NAME]'s Grant | 0 | 0
Pittsburg | 186 | 25
Plainfield | 125 | 25
Plymouth | 388 | 49
Randolph | 50 | 0
Rumney | 176 | 41
Sanbornton | 172 | 64
Sandwich | 162 | 37
Sargent's Purchase | 0 | 0
Second College Grant | 0 | 0
Shelburne | 32 | 1
Springfield | 95 | 28
[NAME] | 36 | 1
Stewartstown | 75 | 13
[NAME] | 43 | 3
Success | 0 | 0
[NAME] | 67 | 5
Sunapee | 324 | 164 |  | 2
Tamworth | 188 | 27
Thompson & Meserve's Purchase | 0 | 0
[NAME] | 147 | 32
[NAME] | 199 | 63
Tuftonboro | 267 | 87
Wakefield | 219 | 94
[NAME] | 116 | 11
Waterville Valley | 20 | 4
Wentworth | 90 | 11
Wentworth's Location | 3 | 0
[NAME] | 188 | 23
Wolfeboro | 599 | 159
Woodstock | 104 | 13
Totals | 18371 | 4100 |  | 35
Spreadsheet: 07b2fe31-0e87-4d6e-ad11-a90abf4f7abd
Sheet: I

Course color corresponds with term of offering. BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | CAR Designation | Comment
International Studies
INST 245 | Social Sciences OR | Non-Western | cross-listed with EVST 245
 | Natural & Mathematical Sciences-Nat Sci w Lab
INST 251 | Social Sciences
INST 261 | Social Sciences | Experiential -Travel* | * when course travels-the course does not travel for all offerings
INST 270 | Social Sciences
INST 321 | Social Sciences |  | cross-listed with PSCI 321
INST 335 |  | Experiential-Travel
INST 391-392 |  | Experiential-Research
INST 422 |  | Capstone; Experiential-Research
INST 448-449 |  | Capstone
INST 452-453 |  | Capstone
INST 483-484 |  | Capstone
INST 487-488 |  | Experiential-Research
INST 493-494 |  | Capstone; Experiential-Research
INST 496-498 |  | Capstone; Experiential-Research
Spreadsheet: 139103d1328076079-nested-if-statement-with-index-and-match-within-vanguard-template
Sheet: Sheet4

 | Category 3
 |  | 4200 | 3900 | 3600 | 3300 | 3000
 | 3600 | 743 | 743 | 595 | 594 | 593
 | 3000 | 673 | 672 | 541 | 540 | 540
 | 2700 | 637 | 637 | 515 | 515 | 514
 | projection | 2900
 | length | 3800
 | index
 | Category 4
Spreadsheet: 797617d1664005908-consecutive-numbering-spill-formula-cumulative-sum-formula-export-09
Sheet: Sep Payroll

 |  |  | Index
Sum of BILLABLE_ENTITY_AMOUNT
catdholder | [NAME] | Total
cloi Oftk | 724279 | 55500
cloi Oftk Total |  | 55500 | 1 | cloi Oftk
coii tczct | 798949 | 373096.52 | 3 | coii tczct
 | 798959 | 10720.12665 | 3 | coii tczct
 | 798929 | 1149 | 3 | coii tczct
coii tczct Total |  | 384965.64665 | 3 | coii tczct
coqccc [NAME] qcioi | 798972 | 5784.110000000001 | 7 | coqccc [NAME] qcioi
 | 724279 | 47.8 | 7 | coqccc [NAME] qcioi
coqccc [NAME] qcioi Total |  | 5831.910000000001 | 7 | coqccc [NAME] qcioi
[NAME] | 724259 | 1211.5457 | 10 | [NAME]
[NAME] Total |  | 1211.5457 | 10 | [NAME]
ctit cztci | 722999.97 | 342.73 | 12 | ctit cztci
 | 798972 | 45552.8 | 12 | ctit cztci
ctit cztci Total |  | 45895.53000000001 | 12 | ctit cztci
cuvcl tcsciccc | 798949 | 1517.2662 | 15 | cuvcl tcsciccc
 | 798959 | 1156523.07837 | 15 | cuvcl tcsciccc
 | 798929 | 11669 | 15 | cuvcl tcsciccc
cuvcl tcsciccc Total |  | 1169709.34457 | 15 | cuvcl tcsciccc
cvi Sccpitc | 724279 | 400 | 19 | cvi Sccpitc
cvi Sccpitc Total |  | 400 | 19 | cvi Sccpitc
[NAME] [NAME] | 798949 | 866.9 | 21 | [NAME] [NAME]
[NAME] Ziv Total |  | 866.9 | 21 | [NAME] [NAME]
ioct ctcq | 798949 | 1403.2858 | 23 | ioct ctcq
 | 798959 | 102881.35016 | 23 | ioct ctcq
ioct ctcq Total |  | 104284.63596 | 23 | ioct ctcq
Ipot pov | 724279 | 1111 | 26 | Ipot pov
Ipot pov Total |  | 1111 | 26 | Ipot pov
pilcq cutccct | 798972 | 55539 | 28 | pilcq cutccct
pilcq cutccct Total |  | 55539 | 28 | pilcq cutccct
qcic tisitt | 798972 | 117800 | 30 | qcic tisitt
qcic tisitt Total |  | 117800 | 30 | qcic tisitt
qcviq ucut | 724259 | 5553.9 | 32 | qcviq ucut
 | 798949 | 110000 | 32 | qcviq ucut
qcviq ucut Total |  | 115553.9 | 32 | qcviq ucut
qot tcpti | 798949 | 144852.302 | 35 | qot tcpti
 | 798959 | 817 | 35 | qot tcpti
 | 798929 | 1149.92 | 35 | qot tcpti
qot tcpti Total |  | 146819.222 | 35 | qot tcpti
scit.licctip . | 798949 | 400 | 39 | scit.licctip .
scit.licctip . Total |  | 400 | 39 | scit.licctip .
Scpi-tosct tctoi | 797289.92 | 972 | 41 | Scpi-tosct tctoi
Scpi-tosct tctoi Total |  | 972 | 41 | Scpi-tosct tctoi
ticcctl cttoucs | 798949 | 669 | 43 | ticcctl cttoucs
ticcctl cttoucs Total |  | 669 | 43 | ticcctl cttoucs
toi Zitoi | 798949 | 110140.9 | 45 | toi Zitoi
toi Zitoi Total |  | 110140.9 | 45 | toi Zitoi
[NAME] | 798949 | 11118 | 47 | [NAME]
[NAME] |  | 11118 | 47 | [NAME]
tot ciztiuttp | 798949 | 110000 | 49 | tot ciztiuttp
tot ciztiuttp Total |  | 110000 | 49 | tot ciztiuttp
toticc czulcc | 798972 | 883 | 51 | toticc czulcc
toticc czulcc Total |  | 883 | 51 | toticc czulcc
[NAME] | 798949 | 400.4 | 53 | [NAME]
[NAME] qcviq Total |  | 400.4 | 53 | [NAME]
Grand Total |  | 2440071.934879999