tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 137477d1327144902-conditional-formatting-year-11-markbook-draft
Sheet: Grade lookup table

Mark | Grade |  | Grade | GradeMin |  | Mark | Grade
18 | A* |  | A* | 17 |  | 0
17 | A* |  | A | 15 |  | 3 | U
16 | A |  | B | 13 |  | 9 | G
15 | A |  | C | 11 |  | 17 | F
14 | B |  | D | 9 |  | 25 | E
13 | B |  | E | 7 |  | 33 | D
12 | C |  | F | 5 |  | 41 | C
11 | C |  | G | 3 |  | 49 | B
10 | D |  |  |  |  | 57 | A
9 | D |  |  |  |  | 65 | A*
8 | E
7 | E
6 | F
5 | F
4 | G
3 | G
2 | U
1 | U
Spreadsheet: 44623d1243403024-index-match-and-multiple-values-schedexample
Sheet: Sheet1

Name | 2009-01-01 00:00:00 | 2009-01-02 00:00:00 | 2009-01-03 00:00:00 | 2009-01-04 00:00:00 | 2009-01-05 00:00:00 | 2009-01-06 00:00:00 | 2009-01-07 00:00:00 | 2009-01-08 00:00:00 | 2009-01-09 00:00:00 | 2009-01-10 00:00:00 | 2009-01-11 00:00:00 | 2009-01-12 00:00:00 | 2009-01-13 00:00:00 | 2009-01-14 00:00:00 | 2009-01-15 00:00:00 | 2009-01-16 00:00:00 | 2009-01-17 00:00:00 | 2009-01-18 00:00:00 | 2009-01-19 00:00:00 | 2009-01-20 00:00:00 | 2009-01-21 00:00:00 | 2009-01-22 00:00:00 | 2009-01-23 00:00:00 | 2009-01-24 00:00:00 | 2009-01-25 00:00:00 | 2009-01-26 00:00:00 | 2009-01-27 00:00:00 | 2009-01-28 00:00:00 | 2009-01-29 00:00:00 | 2009-01-30 00:00:00 | 2009-01-31 00:00:00
[NAME] | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D
Teresa | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D
[NAME] |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D
[NAME] |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D |  |  | D | D | D |  |  | D | D |  |  |  | D | D
[NAME] | D | D |  |  | D | D | D |  |  | D | D |  |  | D |  | D |  |  | D | D | D |  |  | D | D |  |  | D |  | D
[NAME] |  |  | D | D |  |  | D | D | D |  |  | D | D |  | D |  | D | D |  |  | D | D | D |  |  | D | D |  | D |  | D
Date | 2009-01-05 00:00:00
Spreadsheet: 8a93ed2a-d51d-4e20-8414-621da5fb0cfa
Sheet: Sheet1

Overall Rating Of The Repair | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Ethnicity | Excellent | Fair | Good | Poor | Terrible | Total
Black and Minority Ethnic | 410 | 188 | 944 | 84 | 43 | 1669
White British | 280 | 54 | 313 | 30 | 15 | 692
Unknown | 20 | <10 | 24 | <10 | <10 | 55
Total | 710 | 248 | 1281 | 115 | 62 | 2416
Spreadsheet: 32291d1228390413-solved-similar-problem-to-my-minif-sumproduct
Sheet: Sheet1

 | 1 | 2 | 3 | 4
AMG | 1 | 1 | 1 | 0 |  | AMG | 1
AgHorizons Canada | 2 | 0 | 0 | 1 |  | AgHorizons Canada | 1
AgHorizons United States | 0 | 2 | 1 | 0 |  | AgHorizons United States |  | 2
Cotton | 1 | 1 | 0 | 1 |  | Cotton |  |  |  | 4
 |  |  |  |  |  | AMG |  |  | 3
 |  |  |  |  |  | AgHorizons Canada | 1
 |  |  |  |  |  | AgHorizons United States |  | 2
 |  |  |  |  |  | Cotton |  | 2
 |  |  |  |  |  | AMG |  | 2
 |  |  |  |  |  | AgHorizons Canada | 4 |  |  | 4
 |  |  |  |  |  | AgHorizons United States |  |  | 3
 |  |  |  |  |  | Cotton | 1
 | 1 | 2 | 3 | 4
AMG | #N/A | #N/A | #N/A | #N/A
AgHorizons Canada | #N/A | #N/A | #N/A | #N/A
AgHorizons United States | #N/A | #N/A | #N/A | #N/A
Cotton | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 126944d1320072247-spreadsheet-with-multi-formulae-help-helpmestock
Sheet: Sheet1

MONTHLY EXPENSES SHEET PER VEHICLE OCTOBER 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | COST TABLE - named range |  | 2011-10-01 00:00:00
 | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y691 | TOTALS |  |  |  |  | Item | Cost |  | SD06 | AD06 | MT03 | AD54 | EJ53 | MA59 | BD55 | Y961
ADHESIVE |  |  | 15 |  |  |  |  |  |  |  |  |  |  | ADHESIVE | 2.83 | ADHESIVE
DEGREASER |  |  | 1 |  |  |  |  |  |  |  |  |  |  | DEGREASER | 7.5 | DEGREASER
SINGLE EDGED BLADES |  |  |  |  |  |  |  |  |  |  |  |  |  | SINGLE EDGED BLADES | 5 | SINGLE EDGED BLADES
STANLEY BLADES |  |  |  |  |  |  |  |  |  |  |  |  |  | STANLEY BLADES | 0.75 | STANLEY BLADES
LONG BLADES |  |  |  |  |  |  |  |  |  |  |  |  |  | LONG BLADES | 9.6 | LONG BLADES
TISSUE ROLL |  |  |  |  |  |  |  |  |  |  |  |  |  | TISSUE ROLL | 4.5 | TISSUE ROLL
CUTTING GLOVES |  |  |  |  |  |  |  |  |  |  |  |  |  | CUTTING GLOVES | 9.22 | CUTTING GLOVES
RUBBER GLOVES |  |  |  |  |  |  |  |  |  |  |  |  |  | RUBBER GLOVES | 3.1 | RUBBER GLOVES
PRIMERS |  |  | 2 |  |  |  |  |  |  |  |  |  |  | PRIMER | 5 | PRIMER
RUBBER BLOCKS |  |  |  |  |  |  |  |  |  |  |  |  |  | RUBBER BLOCKS | 4 | RUBBER BLOCKS
RED BOX WIPES |  |  |  |  |  |  |  |  |  |  |  |  |  | RED BOX WIPES | 7.5 | RED BOX WIPES
TOTALS PER VEHICLE
Spreadsheet: 868513d1715238960-very-complicated-sum-function-testing-ans
Sheet: Sheet1

EVENT 1 |  | Total of | AR | APC |  | STATE 1 |  | STATE 2 |  | STATE 3 |  | STATE 4 |  | STATE 5 |  | STATE 6 |  | AP1 |  | AP2 |  | AP3 |  | AP4 |  | AR1 |  | AR2 |  | AR3 |  | AR4 |  | AR5 |  | AR6 |  | AR7 |  | AR8 |  | AR9 |  | AR10 |  | AR11 |  | AR12 |  | AR13 |  | AR14
 |  | best six | current |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | River City Classic |  | Mooloolabah
 |  | AR points | RANK | Oct |  | April |  | March |  | March |  | April |  | May |  | June |  | Oct |  | May |  | Sept |  | Nov |  | June |  | July |  | June |  |  |  | Sept |  | Sept |  | April |  | May
 | Weighting                  No of players/teams |  |  | 1 |  | 0.5 | NO | 0.5 | 8 | 0.5 | 5 | 0.5 |  | 0.5 |  | 0.5 |  | 0.75 |  | 0.75 |  | 0.75 |  | 0.75 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25 |  | 0.25
Last Name | Full Name |  |  | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts | Place | Pts
 | =F7+J7+P7+T7+V7+AF7 |  |  |  |  | NO EVENT |  |  |  | SmallEvent |  | SmallEvent
NAME | FULL NAME |  |  |  | 100 |  | 300 |  | 400 |  | 200 | 1 | 250 |  | 300 |  | 100 | 1 | 750 |  | 500 |  | 400 |  |  |  | 250 |  | 100 |  | 300
NAME | FULL NAME |  |  |  | 300 |  | 100 |  | 200 |  | 100 | 1 | 300 |  |  |  |  | 2 | 300 |  | 300 |  | 300 |  |  |  | 100 |  | 100 |  | 100
NAME | FULL NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 750
NAME | FULL NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 600
NAME | FULL NAME |  |  |  |  |  |  | 1 | 500
NAME | FULL NAME |  |  |  |  |  |  | 1 | 500
Spreadsheet: 830202d1684774844-excel-help-for-roulette-elad-excel-explained
Sheet: Foglio2

the system must track 18 splits | 1/4
here they are | 2/5
 | 3/6
 | 7/10
 | 8/11
 | 9/12
 | 13/16
 | 14/17
 | 15/18
 | 19/22
 | 20/23
 | 21/24
 | 25/28
 | 26/29
 | 27/30
 | 31/34
 | 32/35
 | 33/36
Spreadsheet: 791163d1660183939-help-with-sumproduct-countif-countifs-index-match-what-to-choose-excel-help-with-formulas
Sheet: Sheet2

Select Doc_ID | Year | # of Rev | Total Training Events | Total Training Time
 | 2015 |  |  |  |  | All
 | 2016
 | 2017 |  |  |  |  | SOP-04077
 | 2018 |  |  |  |  | WRK-00479
 | 2019 |  |  |  |  | WRK-00577
 | 2020 |  |  |  |  | WRK-01610
 | 2021 |  |  |  |  | WRK-01777
 | 2022 |  |  |  |  | WRK-02123
 |  |  |  |  |  | WRK-03109
 |  |  |  |  |  | WRK-03575 |  | Cell | [NAME]
 |  |  |  |  |  | WRK-04933 |  | A2 | Helper Cell- I created a drop down with unique Doc_ID values from column A of sheet 1 and added a value of "All".  If "All" is selected, I'd like all the formulas to perform the caluculations below for all document versions.  [NAME] in column G UNIQUE(Sheet1!A2:A810,FALSE) added "All" and hid it.  I also created a drop -down in A2 via Data Validation.
 |  |  |  |  |  |  |  | C2 | Count of revisions (Doc_Ver) per Doc_ID.  Example: There are 5 rows for SOP-02659, version 1.0.  This would be a count of "1".  Version 2.0 has 6 rows.  This will be count # 2 and so on.  There are many doc_ids with many versions.  This is where the helper cells come in play.
 |  |  |  |  |  |  |  | D2 | Total Training Events- This is the count of how many unique users per Doc_ID and Doc_Ver.  Note: the users in column F are made up to protect their names.  There are possible duplicate user names per doc_ID and Doc_Version, hence "unique".
 |  |  |  |  |  |  |  | E2 | Total Training Time- This is a calculation of the total hours spent on training per Doc_ID and Doc_Ver.  Each user spends 0.2 hours per page.  I assume the training events per Doc_ID and Doc_Ver multiplied by Pages
Spreadsheet: 43234d1241801527-compare-for-dupes-and-add-missing-cell-info-dupereplacetest
Sheet: Sheet1

sub unit | category | first name | Last name | email | pin number | tel number | add | guid
sub 1 | cat 4 | [NAME] | [NAME] | [EMAIL] |  | ooo.7777 | home | a2323
sub 2 | cat 4 | [NAME] | black | [EMAIL] |  | ooo.7777 | home | a2323
sub 1 | cat7 | [NAME] | jone | [EMAIL] |  | ooo.7777 | home | a2323
sub3 | cat2 | [NAME] | Bloggs | [EMAIL] |  | ooo.3333 | office | [NAME]
 |  | I would like to compare email addresses for dupes and add missing PIN number in Column F from Column F in sheet 2
Spreadsheet: john_griffith__15690__05_15_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 465 | 36 | 38
N01-P/C | 470 | 68.5 | 69.5
Q01-P/C | 475 | 90 | 94
U01-P/C | 480 | 109 | 112
V01-P/C | 480 | 125 | 129
X01-P/C | 495 | 144 | 148
[NAME]-P/C | 510 | 165 | 168
F02-P/C | 515 | 179 | 183
G02-P/C | 505 | 184 | 189
H02-P/C | 485 | 170 | 173
J02-P/C | 445 | 130 | 135
K02-P/C | 435 | 117 | 127
M02-P/C | 435
Z02-P/C | 470 | 161 | 163
Spreadsheet: 681657d1591689629-index-a-datasheet-to-create-an-invoice-using-1-criterion-test_data_4
Sheet: Invoice

Customer |  |  |  |  |  |  |  |  |  |  |  | Misc |  |  |  | <<List>>
Name |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  | 2020-01-01 00:00:00
Address |  |  |  |  |  |  |  |  |  |  |  | Order No. |  |  |  | 2020-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | INVOICE NUMBER |  |  |  | 2020-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-05-01 00:00:00
Site |  |  |  |  |  |  |  |  |  |  |  | Invoiced by Date | 2020-10-01 00:00:00 |  |  | 2020-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
 |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  | 2020-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  | Sub Total
Spreadsheet: 701811d1603942706-power-query-conditional-column-on-date-covid-last-week-yn
Sheet: Table1

Last Test | Age | LT 7
2020-10-25 00:00:00 | 1900-01-03 00:00:00 | No
2020-10-20 00:00:00 | 1900-01-08 00:00:00 | Yes
2020-10-23 00:00:00 | 1900-01-05 00:00:00 | No
2020-10-23 00:00:00 | 1900-01-05 00:00:00 | No
2020-10-25 00:00:00 | 1900-01-03 00:00:00 | No
2020-10-19 00:00:00 | 1900-01-09 00:00:00 | Yes
2020-10-23 00:00:00 | 1900-01-05 00:00:00 | No
2020-10-25 00:00:00 | 1900-01-03 00:00:00 | No
2020-10-27 00:00:00 | 1900-01-01 00:00:00 | No
2020-10-26 00:00:00 | 1900-01-02 00:00:00 | No
2020-10-23 00:00:00 | 1900-01-05 00:00:00 | No
2020-10-20 00:00:00 | 1900-01-08 00:00:00 | Yes
2020-10-24 00:00:00 | 1900-01-04 00:00:00 | No
2020-10-23 00:00:00 | 1900-01-05 00:00:00 | No
2020-10-24 00:00:00 | 1900-01-04 00:00:00 | No
2020-10-19 00:00:00 | 1900-01-09 00:00:00 | Yes
2020-10-24 00:00:00 | 1900-01-04 00:00:00 | No
2020-10-25 00:00:00 | 1900-01-03 00:00:00 | No
2020-10-18 00:00:00 | 1900-01-10 00:00:00 | Yes
2020-10-27 00:00:00 | 1900-01-01 00:00:00 | No
2020-10-27 00:00:00 | 1900-01-01 00:00:00 | No
2020-10-20 00:00:00 | 1900-01-08 00:00:00 | Yes
2020-10-26 00:00:00 | 1900-01-02 00:00:00 | No
2020-10-19 00:00:00 | 1900-01-09 00:00:00 | Yes
Spreadsheet: 215803d1361486640-return-top-5-results-w-corresponding-text-from-adjacent-cells-map1-jsmifc-oeldere-
Sheet: Blad1

 |  |  |  |  |  |  |  | you can hide column I (if you want)
 |  |  |  |  |  |  |  |  | 5 |  |  | Apples
 |  |  |  |  |  |  |  |  | 3 |  |  | Oranges
 |  |  |  |  |  |  |  |  | 0 |  |  | Grapes
 |  |  |  |  |  |  |  |  | 7 |  |  | Kiwis
 |  |  |  |  |  |  |  |  | 1 |  |  | Pears
 |  |  |  |  |  |  |  |  | 2 |  |  | Plums
 |  |  |  |  |  |  |  |  | 0 |  |  | [NAME]
 |  |  |  |  |  |  |  |  | 2 |  |  | Bananas
Spreadsheet: 164758d1340884159-excel-2007-trying-to-build-a-time-sheet-work-book-and-am-stuck-on-seperating-the-day-and-night-shift-new-project-pay-roll-and-time-sheet-beta-day-night-test-1
Sheet: Tuesday Night Timesheeet

 |  |  | TRI TOOL INC.
 | Customer: |  |  |  |  |  |  |  |  | CUSTOMER CONTACT: |  |  |  |  |  | JOB NO: |  |  |  |  |  | Home Page
 | Work Location: |  |  |  |  |  |  |  |  | CUST. P.O. NO. |  |  |  |  |  | DATE:
 | Employee: |  |  |  |  | TOTAL HRS: |  | WORK [NAME]/WORK ORDER NO. |  |  |  |  |  |  |  |  | CONSUMABLES: |  |  |  |  | Payroll
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QUAN: | PART NO:
 |  |  |  |  | Verify the following SAFTY ITEM CHECKLIST as required on this site. |  |  |  |  |  |  |  |  | Equipment Usage: |  |  |  |  | Tech Initial
 |  | NO | YES
 |  |  |  | 1 | If required, has the site specific training been completed?
 |  |  |  | 2 | If permits are required, do you have the proper papers?
 |  |  |  | 3 | Is Scaffolding correct and safe?
 |  |  |  | 4 | If lockout is required, has the proper procedure been followed?
 |  |  |  | 5 | Do you know the emergency signals?
 |  |  |  | 6 | Do you know the escape routes and assembley points?
 |  |  |  | 7 | Are safety glasses required?
 |  |  |  | 8 | Is a face sheild required?
 |  |  |  | 9 | Is a hard hat required?
 |  |  |  | 10 | Are flame resistant clothes required?
 |  |  |  | 11 | Is hearing protection required?
 |  |  |  | 12 | Are safety toed shoes required?
 |  |  |  | 13 | Are respirators required? |  |  |  |  |  |  |  |  | SIGNATURES:
 |  |  |  | 14 | Is fall protection equipment required?
 |  |  |  | 15 | Other: |  |  |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  |  |  |  |  |  |  |  | TRI TOOL:
Spreadsheet: 215776d1361477039-excel-2007-conditional-formatting-for-a-row-based-on-value-of-multiple-cells-college-and-career-readiness-example
Sheet: Sheet1

Blue | Career Ready
Green | College Ready
Green/green | College & Career Ready |  |  |  |  |  |  |  | KOSSA Exam |  |  | MNA |  |  | WORKEYS
Count | [NAME].? | ACT/ COMPASS | College & Career | Test Name | First Name | Last Name | High School | Program | Certificate | MC Score | Scenario | Certificate | Written | Performance | Cert | AM | LI | RFI
1.5 | Y | Y | Y |  | Julie | [NAME] | LCHS | Office Tech | Y | 70 | 75 |  |  |  | CX | 70 | 70 | 70
1.5 | Y | Y | Y |  | Julie | [NAME] | LCHS | Auto | N | 50 | 75 |  |  |  | Y | 70 | 70 | 70
1 | N | Y | N |  | Julie | [NAME] | LCHS | Electricity | N | 50 | 65 |  |  |  | N | 50 | 70 | 60
1 | Y | N | N |  | Julie | [NAME] | RHS | CAD | Y | 75 | 80 |  |  |  | Y | 70 | 70 | 70
1.5 | Y | N | N |  | Julie | [NAME] | TCHS | Accounting | N | 60 | 80 |  |  |  | Y | 70 | 70 | 70
 | KOSSA: | MC Score = at least 70, Scenario = at least 75, then pass & certificate
 | WorkKeys: | AM, LI, RFI scores = 70 or above, then pass & certificate
 | [NAME] but not academic component = Career ready
 | Kossa + WorkKeys + Academic component = college & career ready
 | [NAME] or WorkKeys (but not both) + Academic component = college ready
Spreadsheet: 168639d1342531871-interval-pricing-of-volumes-using-if-formula-0aabook1-41-
Sheet: Sheet1

 | Volume | Value |  | Rate | Intervals
2012-01-01 00:00:00 | 15000 |  |  | 3 | 0 to 80,000 Tonnes | 0 | 80000
2012-02-01 00:00:00 | 16000 |  |  | 4 | 80,000 to 120,000 Tonnes
2012-03-03 00:00:00 | 17000 |  |  | 5 | 120,001 to 240,000 Tonnes
2012-04-03 00:00:00 | 18000 |  |  | 6 | 240,001 to 400,000 Tonnes
2012-05-04 00:00:00 | 19000
2012-06-04 00:00:00 | 20000
2012-07-05 00:00:00 | 21000
2012-08-05 00:00:00 | 22000
2012-09-05 00:00:00 | 23000
2012-10-06 00:00:00 | 24000
2012-11-06 00:00:00 | 25000
2012-12-07 00:00:00 | 26000
Spreadsheet: 700369d1603166412-need-help-to-have-formula-to-ignore-cells-with-no-dates-multiple-cells-in-a-row-playing-with-timeline
Sheet: SFR Conv & FHA (Rehab)

Subject | Start Date | All day event | Reminder on/off | Meeting Organizer | Categories | Description | Location
Sign Disclosures |  | True | False | Team Rosa | Sign Disclosures
[NAME] |  | True | False | Team Rosa | [NAME]
Processing Review |  | True | False | Team Rosa | Processing Review
Submit to Underwriting |  | True | False | Team Rosa | Submit to Underwriting
[NAME] |  | True | False | Team Rosa | [NAME]
[NAME] |  | True | False | Team Rosa | [NAME]
Conditional Approval |  | True | False | Team Rosa | Conditional Approval
Contractor Package Due |  | True | False | Team Rosa | [NAME]
[NAME] |  | True | False | Team Rosa | [NAME] | _x000D_
Submit for Project Approval |  | True | False | Team Rosa | Submit Conditions
Project Approval |  | True | False | Team Rosa | Final Approval
Submit Conditions |  | True | False | Team Rosa | Submit Conditions
CD |  | True | False | Team Rosa | CD
Final Approval |  | True | False | Team Rosa | Final Approval
[NAME] CD |  | True | False | Team Rosa | [NAME] CD
Docs Out |  | True | False | Team Rosa | Docs Out
Signing |  | True | False | Team Rosa | Signing
Close Date |  | True | False | Team Rosa | Close Date
Spreadsheet: 731657d1620486509-v-lookup-based-on-different-sheets-using-data-validation-list-test-sheets-ans
Sheet: Mar 22

Enter 1st of Month Here -> | 2022-03-01 00:00:00 | Controller | Volunteer 1 | Volunteer 2 | Volunteer 3 | Volunteer 4 | Volunteer 5 | Volunteer 6
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
 | Morning
 | Afternoon
Sat
Sun
Spreadsheet: 544810d1509037617-how-to-populate-sheets-with-information-from-other-sheets-example
Sheet: FO

description | size | barcode | Quantity
Ford [NAME] | LG | 5246654074885325 | 1
Ford Excursion | XS | 4338407630342241 | 1
Ford Exploder | XS | 5162631860402969 | 0
Ford Taurus | SM | 3056465265823272 | 0
Ford Galaxy | ME | 1971649534824314 | 0
Spreadsheet: 835363d1688540149-count-and-rank-from-data-with-category-example-hd
Sheet: Sheet1

 | Group | Transport |  |  | Count |  |  |  | Rank |  |  |  |  | Count
 | Children | Boat |  |  | Group | Transport | Count |  | Group | Transport | Count | Rank |  | Group | Transport | Count
 | Adult | Car |  |  | Children | Boat | 1 |  | Children | Bus | 2 | 1 |  |  | Car | 1
 | Teen | Bike |  |  |  | Car |  |  |  | Boat | 1 | 2 |  |  | Bus | 1
 | Adult | Bus |  |  |  | Bike | 1 |  |  | Bike | 1 | 2 |  |  | Taxi | 2
 | Adult | Taxi |  |  |  | Bus | 2 |  |  | Plane | 1 | 2 |  |  | Boat | 3
 | Teen | Boat |  |  |  | Plane | 1 |  |  | Car |  |  |  | Children | Boat | 1
 | Teen | Taxi |  |  |  | Taxi |  |  |  | Taxi |  |  |  |  | Bike | 1
 | Children | Bike |  |  | Teen | Boat | 2 |  | Teen | Car | 3 | 1 |  |  | Plane | 1
 | Teen | Car |  |  |  | Car | 3 |  |  | Boat | 2 | 2 |  |  | Bus | 2
 | Adult | Boat |  |  |  | Bike | 1 |  |  | Bike | 1 | 3 |  | Teen | Bike | 1
 | Children | Plane |  |  |  | Bus |  |  |  | Taxi | 1 | 3 |  |  | Boat | 2
 | Children | Bus |  |  |  | Plane |  |  |  | Bus |  |  |  |  | Taxi | 1
 | Adult | Boat |  |  |  | Taxi | 1 |  |  | Plane |  |  |  |  | Car | 3
 | Adult | Taxi |  |  | Adult | Boat | 3 |  | Adult | Boat | 3 | 1
 | Teen | Boat |  |  |  | Car | 1 |  |  | Taxi | 2 | 2
 | Teen | Car |  |  |  | Bike |  |  |  | Car | 1 | 3
 | Children | Bus |  |  |  | Bus | 1 |  |  | Bus | 1 | 3
 | Teen | Car |  |  |  | Plane |  |  |  | Bike
 | Adult | Boat |  |  |  | Taxi | 2 |  |  | Plane
Spreadsheet: 162f8a76-fe99-417c-b5d2-bbeff76dac54
Sheet: Sheet1

FY 2011 AEA STATE AID PAYMENTS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | ORIGINAL | SEPT-MAR | PAID THROUGH | AMOUNT
 |  | BUDGET | PAYMENT | [NAME] | REMAINING
1 | [NAME] 1 | 13431398 | 1343141 | 9401987 | 4029411
5 | PRAIRIE LAKES AEA 8 | 13196032 | 1319603 | 9237221 | 3958811
7 | AEA 267 | 28293632 | 2829366 | 19805562 | 8488070
9 | MISSISSIPPI BEND AEA 9 | 19600648 | 1960068 | 13720476 | 5880172
10 | GRANT WOOD AEA 10 | 27263347 | 2726336 | 19084352 | 8178995
11 | HEARTLAND AEA 11 | 49241026 | 4924107 | 34468749 | 14772277
12 | NORTHWEST AEA | 16359617 | 1635961 | 11451727 | 4907890
13 | GREEN HILLS AEA 13 | 16376170 | 1637617 | 11463319 | 4912851
15 | GREAT PRAIRIE AEA 15 | 15006162 | 1500620 | 10504340 | 4501822
 |  | 198768032 | 19876819 | 139137733 | 59630299
Spreadsheet: holden_salisbury__12295__2-5act
Sheet: EPEData

 | 37389.13541666666
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,ECON, 35  , 65  , 34  , 83  , 31  ,1
 | NEWMAN 3 ,ECON, 36  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,ECON, 87  ,100  , 66  ,107  , 13  ,1
 | NEWMAN 4 ,UNAV,  0  ,215  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 158 ,  265,  135, 293 ,  84 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,MANL, 59  ,105  , 60  ,151  ,  0  ,1
 | RIOGRANDE,,  59 ,  105,   60, 151 ,   0 ,
 | PALOVERDE,MANL,603  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 52  , 52  , 52  ,104  ,  0  ,1
 | LAMBDA, 14.98,  706,  704,  128,    5,    0,11890,0
 | APS     ,FIRM    ,FC,  ,  25,  25
 | APS     ,FIRM    ,PV,  ,  25,  25
 | IID     ,FIRM    ,PV,  ,  84,  84
 | PGT     ,LOSS    ,LC,  ,  -1,  -2
 | PNM     ,FIRM    ,FC,  ,  30,   0
 | PNM     ,LOSS    ,WM,  ,   3,   3
 | SPS     ,FIRM    ,ED,  ,-130,-100
 | SRP     ,LOSS    ,PV,  ,   4,   4
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | CISO    ,FIRM    ,PV,  ,  78,   0
 | TNP     ,LOSS    ,AM,  ,  -2,  -2
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
 | 37300.62986111111
 | NEWMAN 1 ,UNAV, -0  , 75  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 39  , 75  , 34  , 83  ,  0  ,1
 | NEWMAN 3 ,ECON, 38  ,100  , 35  ,103  , 40  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,174  ,215  , 86  ,214  , 41  ,1
 | NEWMAN   ,, 251 ,  390,  155, 400 ,  81 ,
 | COPPER   ,[NAME], -0  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,AVAL,  0  , 47  , 29  , 48  ,  0  ,1
 | RIOGRAN 7,AVAL,  0  , 38  , 32  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  ,121  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,   0 ,    0,    0,   0 ,   0 ,
 | PALOVERDE,MANL,603  ,600  ,600  ,600  ,  0  ,1
 | FOURCRNRS,MANL, 51  , 51  , 51  ,104  ,  0  ,1
 | LAMBDA, 23.51,  798,  796,   80,   -3,    0,11060,21
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1