tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 178343d1346767534-rows-of-names-need-to-be-placed-in-solumns-first-last-rows-to-columns
Sheet: Sheet1

Last | First
Gans-Brangs | Kathy R |  |  | [NAME] | Blango | [NAME] | Blasetto | [NAME] | Cimorose | Cheryl | Cordaro | [NAME] | Dadourian | Daniel | Datto | Catherine | de Vane | Philip | Del Parigi | [NAME] | Ferguson | [NAME] | Goldman | Mitchell | Hoctin-Boes | Guido | Illueca | Marta | Maya | Juan | [NAME] | [NAME] (DBL) | Minervini | Gianmaria | Mullen | Jamie A | Newell | [NAME] | Pennington | [NAME] | Piraino | Anthony | Trudo | [NAME] | Zhao | June | Bilmes | Robyn | Celuch | Kelly J | [NAME] | [NAME] | [NAME] | [NAME] | Fariello | Andrew | Hinton | Vonda | [NAME] | Kimberly | [NAME] | Naeem | [NAME] | [NAME] | Ney | Christine A | Osborne | Jenny | Pettineo | [NAME] | [NAME] | [NAME] (MA) | [NAME] | [NAME] | Sayre | [NAME] | Shaffer | [NAME] (MED AFFAIRS) | Wendell | [NAME] | Yee | John | [NAME] | Helen
Sargent-Heuer | Louise
Sweet | Brian
[NAME] | [NAME]
Cho | Maria
Chung | Yen
[NAME] | [NAME]
Easton | [NAME]
[NAME] | Sep
Fetchko | [NAME] A
Finis | Lynda
Goldkamp | [NAME]
Hark | Bernard
[NAME] | Joan
Marczely | Mary
Mohler | [NAME]
[NAME] | Rina
Perlsweig | Debra
Quan | Marian
Shay | Michelle
Shoop | Corie A
Timmins | [NAME]
Titus | Danielle
[NAME] | [NAME]
[NAME] | [NAME]
Young | [NAME]
[NAME] | [NAME]
Catini | Julia
Oliphant | Janet
Pollitt | Dawn
Pottorf | [NAME]
Venuti | Christine
Bohannan | Kimberly
Brown | [NAME]
Byrnes | Challey
[NAME] | Julie
Greer | Lakita
Gring | [NAME]
Krause | [NAME]
Mason | [NAME]
Mathews | Deb A
Shotyk | [NAME]
Timberlake-Kinter | [NAME]
Toler | [NAME]
Anzalone
Spreadsheet: 87724d1287588253-help-with-a-dashboard-reporting-tool-hr-case-tracker-test2
Sheet: reportingtool

 |  |  | Reporting Tool
 |  | From |  | To
Directorate
Investigating manager
HR Lead
Status (Select) |  | Calender Days Open (Reliant on Start Date >) | Employee Name | Directorate | Investigating Manager | HR Lead | Trade Union Rep | Adjustment? | Suspension Start Date dd/mm/yy | Suspension End Date dd/mm/yy | Days Suspended (Running Total) | Calendar Days Suspended (Total) | Allegation Detail / Investigation Progress (Free Text) | Primary Allegation | Secondary Allegation (If Applicable) | Start Date | End Date | Total Duration (False if Open) | Outcome | ESR Updated? | Appealed? | Tribunal?
Spreadsheet: 14b4d7cd-266a-4462-aa77-af460be24771
Sheet: CDS-F

F. STUDENT LIFE
F1 | Percentages of first-time, first-year (freshman) degree-seeking students and degree-seeking undergraduates enrolled in Fall 2013 who fit the following categories:
F1 |  |  |  | First-time, first-year (freshman) students | Undergraduates
F1 | Percent who are from out of state (exclude international/nonresident aliens from the numerator and denominator) |  |  | 0.49 | 0.48
F1 | Percent of men who join fraternities |  |  | 0.09 | 0.08
F1 | Percent of women who join sororities |  |  | 0.14 | 0.11
F1 | Percent who live in college-owned, -operated, or -affiliated housing |  |  | 0.99 | 0.85
F1 | Percent who live off campus or commute |  |  | 0.01 | 0.15
F1 | Percent of students age 25 and older |  |  | 0 | 0.01
F1 | Average age of full-time students |  |  | 18 | 19.6
F1 | Average age of all students (full- and part-time) |  |  | 18 | 19.7
F2 | Activities offered Identify those programs available at your institution.
F2 | Campus Ministries | X
F2 | Choral groups | X
F2 | [NAME] band | X
F2 | Dance | X
F2 | Drama/theater | X
F2 | International Student Organization | X
F2 | Jazz band | X
F2 | Literary magazine | X
F2 | Marching band
F2 | Model UN | X
F2 | Music ensembles | X
F2 | Musical theater
F2 | Opera
F2 | Pep band
F2 | Radio station | X
F2 | Student government | X
F2 | Student newspaper | X
F2 | Student-run film society
F2 | Symphony orchestra
F2 | Television station
F2 | Yearbook | X
F3 | [NAME] (program offered in cooperation with Reserve Officers' Training Corps)
F3 |  | On Campus |  | At Cooperating Institution | Name of Cooperating Institution
F3 | Army ROTC is offered:
F3 | [NAME] is offered:
F3 | Air Force ROTC is offered:
F4 | Housing: Check all types of college-owned, -operated, or -affiliated housing available for undergraduates at your institution.
F4 | Coed dorms | X
F4 | Men's dorms | X
F4 | Women's dorms | X
F4 | Apartments for married students
F4 | Apartments for single students
F4 | Special housing for disabled students | X
F4 | Special housing for international students | X
F4 | Fraternity/sorority housing | X
F4 | Cooperative housing
F4 | Theme housing | X
F4 | Wellness housing | X
F4 | Other housing options (specify):
Spreadsheet: 775347d1649053625-merge-worksheets-into-one-book1_pq
Sheet: Sheet2

Year | Emp Dept ID | Area | Grade 1 | [NAME] | [NAME]
2021 | 1 | Customer Support |  | 1
2021 | 2 | Data |  |  | 1
2021 | 3 | Customer Support |  | 1
2021 | 4 | International | 1
2021 | 5 | Data | 1
Spreadsheet: 686993d1594906484-vba-multiple-spreedsheets-linked-staff1a
Sheet: Staff 1a

CLAIMANT ID | SECTOR: CHOICE 1_(SELECT OR TYPE THE CLAIMANT PREFERENCE | SECTOR: CHOICE 2_(SELECT OR TYPE THE CLAIMANT PREFERENCE) | METHOD OF CONTACT_PHONE/JOURNAL | 18-24 | SELF EMPLOYED | HEALTH ISSUES | FOUND WORK | COMMENTS
RAJ | Civil Service | Childcare | BOTH | YES | NO | YES-CAN WORK | NO | HARD WORKER
DEEPAK | Childcare | Childcare | JOURNAL | YES | YES | NO | NO | GOOD
[NAME] | Education | Care | PHONE | YES | NO | YES-CAN WORK | NO
[NAME] | Care | Care | BOTH | NO | NO | YES-CAN WORK | YES | VERY GOOD
Spreadsheet: 1bd1ab7e-ea27-424e-bb5e-2fa6b2944073
Sheet: 2000-2012

GAVI Alliance
Cash received 2000-2012
as of 31 March 2012
millions US$
 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | Total
Australia |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 8.6
Canada |  |  | 1.88035602 | 4.75542135 |  | 130.8686406 | 5.19031142
Denmark |  | 1.14740743 |  |  | 3.33887922 | 3.41610739 | 4.41126234 | 4.73754 |  |  | 1.807207
European Commission (EC) |  |  |  | 1.26 |  |  |  | 4.84964 | 23.129114 | 28.63013
France |  |  |  |  | 6.02911392 |  | 12.63 |  |  |  |  | 34.5
Germany |  |  |  |  |  |  | 5.2604 | 5.948 |  |  |  | 8.5 | 3.264
Ireland |  |  | 0.51075 | 0.62375 | 0.65 | 0.83146 | 7.902 | 8.3112 | 3.84132 |  | 3.630863
Japan
Luxembourg |  |  |  |  |  | 0.64515 | 1.318775 | 0.81184 | 1.4229 | 1.19124 | 1.10044
Netherlands |  | 24.06033462 | 13.37517187 | 16.49264195 | 17.32986645 | 15.85941435 |  | 33.547469 | 38.885301 | 31.20579 | 25.1113845 | 26.3
Norway |  | 17.89468975 | 21.32565609 | 21.79108674 | 40.92459264 | 39.53459411 |  | 86.156761 | 65.44948326 | 82.80032471 | 76.483608 | 79.2
Republic of Korea |  |  |  |  |  |  |  |  |  |  | 0.4
Spain |  |  |  |  |  |  |  |  | 40.5362
Sweden |  | 1.89213259 | 1.11479998 | 2.38518169 | 4.93142988 | 12.66340061 | 14.59397503 | 15.514976 | 19.151976 | 13.80099952 | 36.4874975 | 92.7
United Kingdom | 4.4634 |  | 15.04825 | 5.60595 | 18.491535 | 6.625149 | 23.214072 |  |  |  | 15.883044 | 85.1
United States |  | 48.092 | 53 | 58 | 59.64 | 64.48 | 69.3 | 69.3 | 71.913 | 75 | 78 | 89.8
Donor Governments and EC
Anglo Amercian plc |  |  |  |  |  |  |  |  |  |  |  | 1
Bill & Melinda Gates Foundation | 325 | 425 |  | 3.5 | 5 | 154.338 |  | 75 | 75 | 75 | 75 | 264.1 | 183.8
His Highness Sheikh [NAME] |  |  |  |  |  |  |  |  |  |  |  | 14.1
"la Caixa" Foundation |  |  |  |  |  |  |  |  | 5.8 | 5.9 | 4 | 3.1 | 0.237
JP Morgan
The Children’s Investment Fund Foundation (UK) |  |  |  |  |  |  |  |  |  |  |  |  | 2.1
Other private | 0.02 |  | 1.630361 | 2.580847 | 1.805051 | 0.47348 | 1.904352 | 1.1 | 0.8 | 1 | 1 | 0.8 | 0.6
Private Contributions
Sub-total
IFFIm to GFA transfers |  |  |  |  |  |  | 524.749285 | 428.268866 | 272.638133 | 330.027 | 320 | 300
AMC funds |  |  |  |  |  |  |  |  |  |  | 42.87705
Total contributions
Donations recorded on a cash basis
Spreadsheet: 811799d1672799023-xlookup-problems-with-duplicates-samplesheet-1-
Sheet: Sheet2

Amount | GAL
69.86
116.57
11.53
31.58
69.72
154.5
285.54
398.82
288.45
59.7
2.31
61.28
135.89
109.31
85.7
20
8.36
56.86
128.04
125.34
45
15
120
60.09
114.41
7.99
52.5
159.32
58.66
80.28
23
170
34
49.01
93.93
122
50
125.37
23.27
255.01
150
28.31
47
71.12
49
42.58
44.32
89.87
118.32
474.8
126.57
85.34
40
67.07
160
56.83
38.19
72
408.57
936.2
760.18
43
12.49
24.89
10
66.02
101.34
79.57
62.65
91.84
2359.8
86
136.41
208.6
625.7
27.98
155.36
38.62
35.73
224.4
620.43
37.76
121.7
128.54
102.42
48
87.51
188.29
8.55
604.35
71.53
2.39
88.69
18.87
153.81
112.4
11.84
7.99
84.6
59
-1.51
123.34
69
10
221.19
144.88
11
34.71
93.57
165.47
12.75
-301.64
17
26.6
8
24.77
80.72
143.29
37.7
772.1
31.3
138
332.43
150
108
35.4
85.7
34.36
51.27
178
23.11
17.72
43
35.96
6
146.46
55.95
13.78
48
729
729
20.84
Spreadsheet: 815173d1674782763-extract-numbers-from-right-before-dash-in-excel-extract-values_sample
Sheet: Sheet1

Names | Numbers
[NAME], Mcmahon - 1 | 1
[NAME], Brown - 2 | 2
Ashley, Smith - 3 | 3
[NAME], Cameron - 4 | 4
[NAME], Cisneros - 5 | 5
[NAME], Jacobs - 6 | 6
Marcus, Phillips - 7 | 7
Amanda, Knox - 8 | 8
Judith, Butler - 9 | 9
Candice, [NAME] - 10 | 10
[NAME], Thompson - 11 | 11
[NAME], Harrington - 12 | 12
[NAME], Watson - 13 | 13
[NAME], [NAME] - 14 | 14
Scott, Wallace - 15 | 15
[NAME], Atkinson - 16 | 16
Autumn, Goodman - 17 | 17
[NAME], Rowe - 18 | 18
Amber, [NAME] | 19
Scott, Glenn - 20 | 20
[NAME], Miranda - 21 | 21
[NAME], Morse - 22 | 22
Gregory, Perez - 23 | 23
Derrick, Stephens - 24 | 24
[NAME], Jenkins - 25 | 25
Lisa, Phillips - 26 | 26
[NAME], Lewis - 27 | 27
[NAME], Avery - 28 | 28
[NAME], [NAME] | 29
Mrs. [NAME] | 30
[NAME], Macias - 33 | 33
Kelly, [NAME] - 34 | 34
[NAME], [NAME] | 35
Spreadsheet: 18da4d74-97fe-4528-8934-3b204fbfab28
Sheet: Sheet1

Library Web Site Statistics  <http://www.uri.edu/library/> | 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
2004-2005
Successful requests for pages (visits)
 | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | ANNUAL TOTAL
/library/ successful requests for pages (visits) | 88368 | 91983 | 100943 | 127905 | 113997 |  |  |  | 115869 | 110956 | 83716 | 98996 | 932733
uri.edu successful requests for pages (visits) | 2417526 | 2793086 | 2661505 | 2536738 | 2353069 |  |  |  | 2641799 | 2549687 | 2408584 | 2526643 | 22888637
/library/ visits as % of uri.edu visits | 0.03655307119757967 | 0.0329323909109852 | 0.03792703752200353 | 0.05042105254858799 | 0.04844609316598876 |  |  |  | 0.043859884873906 | 0.04351749842235537 | 0.03475735120718231 | 0.03918084193136902 | 0.04075091933171905
/library/ distinct hosts served | 10999 | 10577 | 10893 | 13425 | 13470 |  |  |  | 13696 | 14389 | 12954 | 13216 | 113619
uri.edu distinct hosts served | 232474 | 240426 | 201587 | 214902 | 213589 |  |  |  | 256468 | 268319 | 263156 | 279509 | 2170430
/library/ distinct hosts served as % of uri | 0.04731281777747189 | 0.04399274620881269 | 0.05403622257387629 | 0.06247033531563224 | 0.0630650454845521 |  |  |  | 0.05340237378542352 | 0.05362646700382753 | 0.04922555442399185 | 0.04728291396699212 | 0.05234861294766475
Spreadsheet: 73639d1274276722-match-value-that-is-closest-in-value-and-also-fulfills-other-criteria-problem1
Sheet: problem

STAGE 1
 | Items to be matched | items to match with |  | Desired outcome
 | Size in Mil$ | Size in Mil$ | PE Firm | Match
item 1 |  | 77.027 | 0 | # N/A
item 2 | 98.741 |  | 0 | item 5
item 3 |  | 99.05 | 0 | # N/A
item 4 |  | 833.354 | 0 | # N/A
item 5 |  | 103 | 1 | # N/A
I want to match [NAME] to the item that is closest in value and is also a PE Firm (PE Firm = 1) and return the result to column E.
In this case for item 2, the closest in value is item 3. However, 3 is not a PE Firm.
I would already be happy if someone could tell me how to do this. See below if you want to see my whole challenge ;)
You might wonder, why don’t I just delete all those Items that are not PE firms. For that see stage 2 below
STAGE 2
 | Items to be matched | items to match with |  | Items to be matched | items to match with | Desired outcome
 | Size in Mil$ | Size in Mil$ | PE Firm | Industry code | Industry code | Match
item 1 |  | 77.027 | 1 | 7564 |  | # N/A
item 2 | 98.741 |  | 0 |  | 7833 | item 1
item 3 |  | 99.05 | 0 | 3842 |  | # N/A
item 4 |  | 110 | 0 | 3321 |  | # N/A
item 5 |  | 103 | 1 | 6522 |  | # N/A
I want to match [NAME] to the item that is closest in value, is a PE firm and has the same first letter for the Industry Code
So that would be item 1.
Thanks in advance, please let me know what might be unclear.
Spreadsheet: 120421d1315280573-modify-table-range-management-visit-tracker-rev-1
Sheet: 2012

 |  |  |  |  | GO MARINE GROUP - Management Ship Visit Register NOTE COPY for 2012 BEFORE USE
 |  |  |  |  | Jannuary |  |  | February |  |  | March |  |  | April |  |  | May |  |  | June |  |  | July |  |  | Aug |  |  | September |  |  | October |  |  | November |  |  | December
AQEX | Aqila Explorer | CIEN | Client | STAFF | Date | Ship | Visit Type | Date2 | Ship2 | Visit Type2 | Date3 | Ship3 | Visit Type3 | [NAME] | Ship4 | Visit Type4 | Date11 | Ship5 | Visit Type5 | Date6 | Ship6 | Visit Type6 | Date7 | Ship7 | Visit Type7 | Date8 | Ship8 | Visit Type8 | Date9 | Ship9 | Visit Type9 | Date10 | Ship10 | Visit Type10 | Date112 | [NAME] | Visit Type11 | Date13 | Ship12 | Visit Type12
GACA | Go [NAME] | DMOB | Demob | [NAME]
GALT | Go [NAME] | EXTA | Exernal Audit
GCOU | Go Cougar | EXTI | Exernal Inspection
GEME | Go Emerald | GENM | General Management
GEWV | Geowave Voyager | INDR | Industrial Relations
GISH | GO INSHORE Fleet | INTA | Internal Audit | [NAME]
HAVH | [NAME] | INTI | Internal Inspection
NEPT | Neptune Trident | INVG | Investigation
REME | Rem Etive | MOBN | Mobilisation
SANC | [NAME] | OTHR | Other
TDAU | [NAME] | PROJ | Project Induction | [NAME]
TDEF | [NAME] | SAFE | Safety
TSOL | [NAME] | TECH | Technical
UDIS | UOS Discovery | TRAN | Training
ADD: |  | ADD:
ADD: |  | ADD: |  | [NAME]
ADD: |  | ADD:
ADD: |  | ADD:
 |  |  |  | Heath  [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 1305aee5-2454-4427-9c7f-1ae08e992ba0
Sheet: 7 Attendance

7 | Lodge, section and national OA event attendance:  Attend lodge, section and national OA events.
 |  | Set and achieve a chapter attendance goal for OA events |  |  | [NAME] |  | 25
 |  | Exceed the chapter attendance goal by 10% |  |  | Silver |  | 50
 |  | Exceed the chapter attendance goal by 20% |  |  | Gold |  | 100
 | Chapters should support lodge events.  Chapter member representation at section and national events or an OA High Adventure program is not required, but counts toward goal achievement when it occurs.  The intent of this criterion is to encourage the chapter to set and meet a goal for participation in lodge events, and for chapters to support the lodge in reaching its goals for these events.
 | Identify the Benchmark
 |  | List the lodge, section and national OA events at which the chapter will be represented. |  |  |  |  | [NAME]? | Goal Met? Goal Exceeded?
Lodge Events | 1.
 | 2.
 | 3.
 | 4.
 | 5.
Section Events | 1.
 | 2.
National Events | 1.
 | 2.
 |  | AVERAGES:
 |  |  |  |  |  |  | JTE Level:
 |  | How can the chapter improve attendance next year?
 | Plan for Next Year
Spreadsheet: 808812d1670667672-extract-first-4-numbers-from-string-of-9-with-varying-leading-zeros-first-4-query-including-leading-zeros
Sheet: Sheet4

How Member # displays in Excel without formating | 9 digit Member # Custom Formatting | Member Surname | Member  First Name | Manually Calculated Group # | 4 digit Group # Custom Formatting
2000259 | 2000259 |  |  |  |  |  | Goal: Extract the first 4 digits from the fomatted 9 digit Member # (B) including leading zeros and auto populate the formatted 4 digit Group # (F)
3500393 | 3500393 |  |  | 35
9100097 | 9100097 |  |  | 91 |  |  | Leading zeros vary by Member # as well as the numbers following the first four.
9400062 | 9400062 |  |  | 94
26100180 | 26100180 |  |  | 261
30101186 | 30101186 |  |  | 301
31700097 | 31700097 |  |  | 317
43100203 | 43100203 |  |  | 431
108700008 | 108700008 |  |  | 1087
130600001 | 130600001 |  |  | 1306
134100003 | 134100003 |  |  | 1341
159200018 | 159200018 |  |  | 1592
Spreadsheet: 487150d1477935623-formula-to-consolidate-tables-consolidatetables2
Sheet: Table1

Cde | Name | Age
A16 | [NAME] | 43
R6O | [NAME] | 29
69U | [NAME] | 32
A16 | [NAME]
R60 | [NAME]
A16 | [NAME]
R60 | [NAME]
R60 | [NAME]
69U | [NAME]
69U | [NAME]
A16 | [NAME]
R60 | [NAME]
R60 | Gavin
A16 | [NAME]
Spreadsheet: 269298d1381104674-multiply-countifs-by-value-in-different-column-of-same-row-sample-book
Sheet: Sheet1

 |  |  |  | Today's Summary
 |  |  |  | BO | A | T
Desired Results |  |  |  | 5 | 4 | 5
 |  |  |  | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | 2013-10-05 00:00:00 | 2013-10-06 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00 | 2013-10-13 00:00:00
 |  |  | Qty
 |  |  | 5 | BO | BO | BO | BO
 |  |  | 1 | BO | BO | BO | A
 |  |  | 3 | BO | BO | A | A
 |  |  | 5 | BO | A | A | T
Spreadsheet: 215b8f63-614d-49a3-bdff-368b82bc6596
Sheet: Sheet1

New York State Conservation Partnership Program--2013-14 Professional Development Grants | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
BUDGET TEMPLATE
 | Year 1 |  | Year 2 |  | TOTAL | Notes
 | Land Trust Match | NYSCPP Grant | Land Trust Match | NYSCPP Grant
A. Staff
Position: |  |  |  |  | 0
Position: |  |  |  |  | 0
Position: |  |  |  |  | 0
Position: |  |  |  |  | 0
FICA/Taxes/Fringe Benefits: |  |  |  |  | 0
B . Direct Office Expense
a. |  |  |  |  | 0
b. |  |  |  |  | 0
c. |  |  |  |  | 0
[NAME] (specify)
a. |  |  |  |  | 0
b. |  |  |  |  | 0
c. |  |  |  |  | 0
D. Other Expenses (specify)
a. |  |  |  |  | 0
b. |  |  |  |  | 0
c. |  |  |  |  | 0
TOTAL | 0 | 0 | 0 | 0 | 0
Spreadsheet: 877544d1724343677-merging-two-pivot-tables-bauxn-book1
Sheet: Sheet3

Category | Amount | Premium | Industry
1.1 | 7 | 17596.71688105002
1.2 | 8 | 2723.669225866156
1.3 | 9 | 11389.34481424953
1.4 | 1 | 24346.47047665817
1.5 | 5 | 16267.17233458284
2.1 | 9 | 24733.75176036284
2.2 | 6 | 9683.99943843302
2.3 | 6 | 9219.174404893138
2.4 | 5 | 7438.919132214409
2.5 | 2 | 12530.61338326658
3.1 | 7 | 18581.62359014679
3.2 | 7 | 24653.74246240388
3.3 | 2 | 14706.27983216452
3.4 | 8 | 28401.90445834626
3.5 | 3 | 15112.81952164779
1.1 | 7 | 20066.62172851486
1.2 | 1 | 16752.85279931178
1.3 | 3 | 14651.44160726427
1.4 | 7 | 2121.629855463691
1.5 | 7 | 23877.78985166036
2.1 | 3 | 1146.331059792877
2.2 | 5 | 16981.88443278165
2.3 | 1 | 2909.782892794606
2.4 | 1 | 18945.45360376141
2.5 | 4 | 7981.012193740034
3.1 | 5 | 17207.94808198056
3.2 | 2 | 3193.78412459839
3.3 | 8 | 14485.13893544869
3.4 | 2 | 14871.0103953363
3.5 | 5 | 18785.4958262292
1.1 | 4 | 7149.091836531535
1.2 | 9 | 28205.40915761023
1.3 | 2 | 27749.96111497498
1.4 | 9 | 20680.50764030894
1.5 | 8 | 3267.271361697999
2.1 | 6 | 2990.45924171493
2.2 | 5 | 23327.41287997401
2.3 | 4 | 12036.09018494982
2.4 | 7 | 9822.78779327796
2.5 | 7 | 20696.89746958969
3.1 | 7 | 22763.87364508772
3.2 | 5 | 6145.114957950568
3.3 | 8 | 29338.471245271
3.4 | 6 | 14006.3947446428
3.5 | 2 | 4471.685978401163
1.1 | 9 | 27939.00625983577
1.2 | 3 | 27020.74357068282
1.3 | 6 | 21982.65138775283
1.4 | 2 | 3019.370107205117
1.5 | 4 | 7087.484822979269
2.1 | 5 | 14924.34136481037
2.2 | 4 | 11520.47799431422
2.3 | 4 | 7814.78106057385
2.4 | 9 | 18831.8616888748
2.5 | 8 | 12917.33744612659
3.1 | 3 | 11696.3055948327
3.2 | 5 | 6533.477462614938
3.3 | 2 | 11566.72936993256
3.4 | 7 | 18202.07250784406
3.5 | 5 | 26786.77605037015
Spreadsheet: 33559090-f108-4845-bc3b-3547011e3756
Sheet: Sheet1

 |  |  |  | USD/Cooperative/Interlocal # |  |  |  | D0
 |  |  |  | Contact Name
 |  |  |  | Title
 |  |  |  | Phone #
 |  |  |  | Date
2013-14 Form 120-A
Estimated Special Education State Aid
Amounts for School Districts Received on Behalf of an Interlocal or Cooperative
1 | Estimated 2013-14 Special Education State Aid
2 | Estimated Direct Payment to Coop/Interlocal
3 | Estimated state aid to be received from participating districts |  |  |  |  |  |  |  |  | #1 minus #2
4 | Coop Direct Receipts as % of Total State Aid |  |  |  |  |  |  |  |  | #2 divided by #1
5 | Remaining % to Allocate |  |  |  |  |  |  |  |  | 100% minus #4
 | Col A |  | Col B |  | Col C |  | Col D |  | Col E
 | USD # |  | Local Contribution Amount $ |  | % of Local Contributions        to Total |  | Percent of State Aid for each USD/Interlocal (C times #5) |  | 2013-14 Est. Special Education State Aid Dollars   (D times #1)
 |  |  |  |  |  |  |  |  |  | Sponsoring District
 | Total
Spreadsheet: 766857d1644104258-lookup-range-to-retrieve-values-as-an-array-sample3
Sheet: Sheet1

 | Code | Value |  | Code Input |  | Week of |  | ?
 | A | 2 |  | A |  | 2021-12-27 00:00:00
 | B | 12
 | C | 23
 | A | 16
 | Code | Value
 | A | 2022-01-15 00:00:00
 | B | 2022-02-15 00:00:00
 | A | 2022-04-12 00:00:00
Spreadsheet: 771192d1646494322-unique-count-of-of-column-a-where-column-b-contains-word-test
Sheet: Dashboard

Active Users Sheet | Manual Count | Formula Total
Unique count of IDs where Match = Yes | 593
Unique count of IDs where Match = Yes and Team = Green | 26
Unique count of IDs where Match = Yes and Team contains "Green" | 86
Unique count of IDs where Match = Yes and Team contains "Blue" and Dept contains "Pears" | 20
Logins Sheet | Manual Count | Formula Total
Unique count of IDs where status = active and login is in last 6 months | 300
Unique count of IDs where status = active and Match = Yes and login is in last 6 months | 66