tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 122889d1317227640-count-without-using-pivot-table-uploadsheet
Sheet: Sheet1

Name | Product
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A |  |  |  |  | Product A | Product B | Product C | Product D
[NAME] | A |  |  |  | [NAME]
[NAME] | A |  |  |  | [NAME]
[NAME] | B |  |  |  | [NAME]
[NAME] | B |  |  |  | [NAME]
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | C
[NAME] | C
[NAME] | C
[NAME] | C
[NAME] | C
[NAME] | C
[NAME] | C
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | B
[NAME] | C
[NAME] | B
[NAME] | C
[NAME] | D
[NAME] | B
[NAME] | C
[NAME] | C
[NAME] | B
[NAME] | C
[NAME] | B
[NAME] | C
[NAME] | B
[NAME] | C
[NAME] | B
[NAME] | A
[NAME] | D
[NAME] | A
[NAME] | D
[NAME] | D
[NAME] | D
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | A
[NAME] | D
[NAME] | D
[NAME] | C
[NAME] | C
[NAME] | B
[NAME] | B
[NAME] | D
[NAME] | D
[NAME] | D
[NAME] | D
[NAME] | D
Spreadsheet: 31346d1227158877-ranking-vertically-ranking
Sheet: Sheet1

 |  |  |  |  | Rank |  |  |  | Points |  | Rank |  |  |  | Points |  | Rank |  |  |  | Points
 |  |  |  |  | 1st | Name 1 |  |  | 18 |  | 7th | Name 8 |  |  | 13 |  | 15th | Name 15 |  |  | 10
 |  |  |  |  |  | Name 2 |  |  | 18 |  |  | Name 9 |  |  | 13 |  |  | Name 16 |  |  | 10
 |  |  |  |  | 3rd | Name 3 |  |  | 16 |  |  | Name 10 |  |  | 13 |  | 17th | Name 17 |  |  | 9
 |  |  |  |  |  | Name 4 |  |  | 16 |  |  | Name 11 |  |  | 13 |  | 18th | Name 18 |  |  | 8
 |  |  |  |  | 5th | Name 5 |  |  | 15 |  | 12th | Name 12 |  |  | 12 |  | 19th | Name 19 |  |  | 7
 |  |  |  |  | 6th | Name 6 |  |  | 14 |  |  | Name 13 |  |  | 12 |  | 20th | Name 20 |  |  | 6
 |  |  |  |  |  | Name 7 |  |  | 14 |  | 14th | Name 14 |  |  | 11 |  | 21st | Name 21 |  |  | 5
Spreadsheet: 267351d1380051487-calculate-points-and-divisions-student-exam-score-sheet-1-
Sheet: Student's Score Sheet

Student | HISTORY | KISWAHIL | ENGLISH | GEOGR | CIVICS | PHYSICS | CHEMISTRY | BIOLOGY | MATHS | Score | Division
[NAME] | a | c | c | b | f | a | d | d | c
ALLY | d | d | b | f | d | c | f | d | f
HAMISI | b | a | d | d | c | b | a | a | d
ASHA | f | c | d | c | b | f | f | d | c
ASHURA | c | c | b | b | a | c | d | c | b
Spreadsheet: 464488d1465153087-how-count-occurences-in-multiple-separated-columns-using-countif-or-other-function-tr-eng
Sheet: M.Krawiec ORG

MIESIĘCZNY  PLAN  TRAS
 | Region............................................ |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
Lp. | PONIEDZIAŁEK  I |  |  | TYP KLIENTA | TYP WIZYTY | WTOREK  I |  |  |  | TYP KLIENTA | TYP WIZYTY | ŚRODA  I |  |  |  | TYP KLIENTA | TYP WIZYTY | CZWARTEK  I |  |  | TYP KLIENTA | TYP WIZYTY | PIĄTEK  I |  |  | TYP KLIENTA | TYP WIZYTY
1. | [NAME] |  |  |  |  | [NAME] |  |  |  |  |  | Makro [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
2. | PiP Matyi Poznań |  |  |  |  | [NAME]. |  |  |  |  |  | [NAME]. G. |  |  |  |  |  | MMt swarzedz |  |  |  |  | PiP Głogowska Poznań
3. | [NAME] |  |  |  |  | Bydgoszczdis |  |  |  |  |  | [NAME] |  |  |  |  |  | ITM Hortensja Swarzędz |  |  |  |  | PSS Śrem
4. | [NAME] Poznań |  |  |  |  | [NAME]. |  |  |  |  |  | [NAME]. G. |  |  |  |  |  | MMt Kostrzyn |  |  |  |  | PSS Śrem
5. | [NAME] |  |  |  |  | [NAME]. |  |  |  |  |  | Baćpol Ziel.g. |  |  |  |  |  | MMT Leszczyńska Poznań |  |  |  |  | PSS Śrem
6. | [NAME] |  |  |  |  | [NAME]. Toruń |  |  |  |  |  | [NAME]. G. |  |  |  |  |  | PIP [NAME]. |  |  |  |  | Śremdis
7. | [NAME] |  |  |  |  | [NAME] torun |  |  |  |  |  | [NAME]. G. |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
8. | [NAME] |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
9. | [NAME] |  |  |  |  | [NAME] Chodkiewicza |  |  |  |  |  | Horex Krosno Odrz |  |  |  |  |  | [NAME]
10. | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
11.
12.
13.
14.
15.
16.
17.
18.
Lp. | PONIEDZIAŁEK  II (04.01.2016r.) |  |  | TYP KLIENTA | TYP WIZYTY | WTOREK  II |  |  |  | TYP KLIENTA | TYP WIZYTY | ŚRODA  II |  |  |  | TYP KLIENTA | TYP WIZYTY | CZWARTEK  II |  |  | TYP KLIENTA | TYP WIZYTY | PIĄTEK  II |  |  | TYP KLIENTA | TYP WIZYTY
1. | [NAME] |  |  |  |  | [NAME]. |  |  |  |  |  | [NAME]. |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
2. | PiP Matyi Poznań |  |  |  |  | [NAME]. |  |  |  |  |  | [NAME]. |  |  |  |  |  | ITM Hortensja Swarzędz |  |  |  |  | [NAME]
3. | [NAME] |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]. |  |  |  |  |  | [NAME] |  |  |  |  | PSS Warszawska Kalisz
4. | [NAME] Poznań |  |  |  |  | [NAME]. |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | PSS Tęcza Kalisz
5. | [NAME] |  |  |  |  | [NAME]. |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]. |  |  |  |  | PSS Częstochowska Kalisz
6. | [NAME] |  |  |  |  | [NAME]. Toruń |  |  |  |  |  | Bydgoszczdis |  |  |  |  |  | [NAME] Konstytucji |  |  |  |  | PSS Dobrzecka Kalisz
7. | [NAME] |  |  |  |  | [NAME] torun |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | Makro Kalisz
8. | [NAME] |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  | [NAME]
9. | [NAME] |  |  |  |  | Daro Żnin |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME]
10. | [NAME] |  |  |  |  | [NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Ostrówdis
11. | [NAME] |  |  |  |  | [NAME]
12. | Ewa Mosina
13.
14.
15.
16.
17.
18.
18.
Spreadsheet: 7db2e058-5f70-4c09-8631-45cec45d88e4
Sheet: Sheet1

Percentage of People Served by Community Water Systems Who Received Drinking Water That Met All Applicable Health-based Standards of the Safe Drinking Water Act, Maine, 2000-2010 | Unnamed: 1
Year | Percent of people serve by community water systems who received safe drinking water
2000 | 0.6160229505145466
2001 | 0.647990247742304
2002 | 0.8820648637657584
2003 | 0.8880333269738945
2004 | 0.9328314275420877
2005 | 0.9249014816591511
2006 | 0.9212174824725612
2007 | 0.9192611994428573
2008 | 0.90601109925231
2009 | 0.9197477783319421
2010 | 0.928
US 2010 | 0.94
Data source:  Safe Drinking Water Information System (SDWIS)/ US EPA
49.7% of Maine residents live in communities with public water systems, while the remaining 50.3% have private wells or get their water from small private systems (2011 population data.)
There are 380 community water systems in Maine.  Some of these systems serve more that one town.  The number of people served by a partitcular water system varies by location.
Spreadsheet: 0c1f4102-6b35-44f4-852b-428f6e0a9765
Sheet: E601 SAL

DISTRIBUTIVE SCHOOL ACCOUNT - DECISION E-601 SALARY
 | POS | POS | $ | POS | $ | POS | $
WEIGHTED ENROLLMENT
AVG STARTING TEACHER SALARY
[NAME] (COLA)
INSTRUCTIONAL PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
INSTRUCTIONAL PERSONNEL
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
INSTRUCTION SUPPORT PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
ADMINISTRATIVE SUPPORT PERSONNEL
LICENSED
STUDENT RATIO
2%ROLL-UP
NON-LICENSED
STUDENT RATIO
2%ROLL-UP
OTHER LICENSED & NON-LICENSED
STUDENT RATIO
2%ROLL-UP
TOTAL SALARIES
50% of the PERS pay factor (state employee pay factor = 89.385%, DSA factor = 94.6925%)
TOTAL SALARIES LESS 25% PERS EQUAL |  |  |  |  |  |  |  | state pay factor = [NAME]
SUBSTITUTE SALARIES |  |  |  |  |  |  |  | use 50% of employee pay reduction for DSA
FRINGE BENEFITS
[NAME]
WORKER'S COMP
UNEMP INS
MEDICARE
MEDICAL INS
OTHER
TOTAL POSITIONS/SALARIES
AND FRINGE BENEFITS
BENEFIT/SALARY RATIO
 |  |  | Net |  |  | Net
Summary | E671 | E601 | Diff | E671 | E601 | Diff
Salaries
Substitute Salaries
Extra Duty, Misc Salaries
Retirement
Worker's Comp
Unemp Comp
Medicare
Medical
Other
Add back estimated column adjustments* | 0 |  |  | 0
Total Salaries and Fringe Benefits
Spreadsheet: 539307d1506037306-bring-up-a-certain-value-using-different-variables-example2
Sheet: Sheet1

2 or more variables I have a difficult time to accomplish |  |  |  |  |  |  |  |  |  |  |  | 1 Variable that I could accomplish
Country | Units | Total Money | Price Per Unit | Classifcation |  | Resulta I want to get |  | Country | Price | Classification |  | Country | Units | Total Money | Price Per Unit | Classifcation
Mexico | 1 | 12000 |  | x | <- | Power |  | Mexico | 0 | Low |  | Mexico | 1 | 12000
Mexico | 3 | 1000 |  | x | <- | Low |  | Mexico | 8000 | Power |  | Mexico | 3 | 1000
Argentina | 1 | 24000 |  | x | <- | Power |  | Argentina | 0 | Low
Argentina | 3 | 8000 |  | x | <- | Low |  | Argentina | 12000 | Power
Brazil | 1 | 2000 |  | x | <- | Power |  | Brazil | 0 | Low
Brazil | 3 | 100 |  | x | <- | Low |  | Brazil | 1000 | Power
 |  | Rule: If my country at column A matches my country in column K, bring me the result of column L into column E, when my column D (price) falls into the numerical range.
 |  | Example: if Mexico in column A matches Mexico in column B, and my price per unit is $333.33, bring me the word "Low", if my price is above $8000 bring me "Power"
 |  | I was able to accomplish this when I had only one country as a using a VLOOKUP([@[Total Money]]/[@Units],$J$5:$K$6,2,TRUE)
 |  | however now that I have more variables as countries I can't figure out a simple way to do this.
Spreadsheet: 205409d1357810076-calculate-due-date-after-every-alternate-year-from-a-start-date-sample-data
Sheet: Sheet1

 |  | Next Due Date
Name | First Travel Date | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
A | 2009-01-01 00:00:00
B | 2008-05-01 00:00:00
C | 2011-10-24 00:00:00
D | 2007-08-12 00:00:00
E | 2014-02-11 00:00:00
F | 2007-06-09 00:00:00
G | 2011-01-09 00:00:00
H | 2012-07-06 00:00:00
I | 2013-04-30 00:00:00
J | 2005-10-22 00:00:00
K | 2016-08-06 00:00:00
L | 2013-05-04 00:00:00
N | 2012-03-18 00:00:00
O | 2010-12-22 00:00:00
Spreadsheet: c8867b93-422b-4bf0-a9c6-ade02c1dc543
Sheet: Sheet1

New York State Energy Research and Development Authority | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Solicitation No. 2569 | Unnamed: 6 | Unnamed: 7
Contract Pricing Proposal Form
Contractor: |  |  |  |  | Name of Proposed Project:
Address:
Location (where work is to be performed): |  |  |  |  | NYSERDA Funding: |  | 0
 |  |  |  |  | Total Project Cost: |  | 0
 |  |  |  |  | Total | Funding & | Cost-sharing
 |  |  |  |  | Project | Co-funding | & Other
Cost Element |  |  |  |  | Cost | via NYSERDA | Co-funding
1.   Direct Materials
a. Purchased Parts
b. Other
Total Direct Materials |  |  |  |  | 0 | 0 | 0
2.   Materials Overhead |  |  | Rate:
3.   Direct Labor (specify names/titles) |  |  | Hours | Rate/hr
Total Direct Labor |  |  |  |  | 0 | 0 | 0
4.   Labor Overhead |  |  | Rate % | $ [NAME]
Total Labor Overhead |  |  |  |  | 0 | 0 | 0
5.   Outside Special Testing
6.   Equipment
7.   Travel
8.   Other Direct Costs
9.   Subcontractors/Consultants
Total Subcontractors/Consultants |  |  |  |  | 0 | 0 | 0
10. General & Administrative Expense |  |  | Rate % | Element(s)
11. Fee or Profit  (if allowable)      Rate: |  |  |  |  | 0 | 0 | 0
12. Total Estimated Project Cost |  |  |  |  | 0 | 0 | 0
Spreadsheet: 837122d1689865981-how-to-use-is-number-search-and-if-and-together-question
Sheet: Sheet1

Name | Country | Description | Qty | $$ | [NAME]
Chair | US | Furniture | 1 | 100 | False
Table | UK | Furniture Demo | 2 | 550 | True
Pen | CN | Pen Demo | 1 | 400 | False
Pencil | US | Stationary | 1 | 1000 | False
Pencil | UK | Pencil Demo | 2 | 600 | True
Spreadsheet: 100244d1298648781-3-d-graph-766016
Sheet: Sheet1

 | x-axis | y-axis | z-axis
 | CrCl | concentration | %OE
 | 10 | 5 | 20
 | 20 | 15 | 40
 | 30 | 7.5 | 50
 | 40 | 8 | 60
 |  | concentration
 |  | 5 | 15 | 7.5 | 8
 | 10
 | 20
 | 30
 | 40
 | 10
 | 20
 | 30
 | 40
Spreadsheet: 806437d1669301513-matching-notes-from-yesterdays-data-to-todays-newly-imported-data-example
Sheet: Today

Inv | Date | Supplier | Cost
1 | 2022-11-20 00:00:00 | A Bloggs | 1
2 | 2022-11-21 00:00:00 | B [NAME] | 2
3 | 2022-11-22 00:00:00 | C [NAME] | 3
4 | 2022-11-23 00:00:00 | D Bloggs | 4
5 | 2022-11-24 00:00:00 | E Bloggs | 5
Spreadsheet: 803804d1667720076-formula-to-calculate-transit-times-example
Sheet: Sheet1

Day of Collection | Next Departure | No of Days to [NAME] (min)
2 | 3
5 | 1
5 | 1
3 | 4
3 | 4
5 | 1
3 | 4
5 | 1
3 | 4
2 | 3
4 | 5
2 | 3
1 | 2
1 | 2
4 | 5
5 | 1
4 | 5
4 | 5
3 | 4
1 | 2
5 | 1
1 | 2
5 | 1
5 | 1
2 | 3
3 | 4
Key
Monday | 1
Tuesday | 2
Wednesday | 3
Thursday | 4
Friday | 5
Spreadsheet: 274248d1383057422-delete-all-contents-under-specified-column-value-delete-all-contents-example
Sheet: Sheet1

Field 1 | Field 2 | Field 3 | Field 4 | Field 5 | Field 6
Blue | [NAME] | X | 14 | 05:00:00 | RCH
Blue | [NAME] | XX | 345 | 06:00:00 | RCH
Blue | [NAME] | [NAME] | 12 | 07:00:00 | RCH
Blue | [NAME] | X | 6 | 08:00:00 | RCH
Red | [NAME] | XX | 5 | 09:00:00 | RCH
Red | [NAME] | X | 37 | 10:00:00 | RCH
Red | Michelle |  | 98 | 11:00:00 | RCH
Red | [NAME] | X | 1045 | 12:00:00 | RCH
Red | [NAME] |  | 3 | 13:00:00 | RCH
Red | [NAME] | XXXXX | 40 | 14:00:00 | RCH
Red | Mark | XX | 10 | 15:00:00 | RCH
Green | Willie | X | 17 | 16:00:00 | RCH
Green | [NAME] | [NAME] | 76 | 17:00:00 | RCH
Green | Hudson | XX | 10000 | 18:00:00 | RCH
Red
Blue
Green
Red
Red
Blue
Blue
Blue
Blue
Spreadsheet: 30017d1225299303-countif-and-sumif-formula-question-excel-forum-newbie-copy-of-excel-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Exclude 1 | [NAME] | Exclude 3 | [NAME] | Exclude 5 | Exclude 6 | Exclude 7 | Exclude 8 | Exclude 9 | Exclude 10
Criteria | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Total | A | B | C
Score | 3 | 2 | - | 4 | 1 | - | 1 | 3 | 2 | 2 | 18 | 5 | 13 | 20 |  |  |  |  | y | y |  |  | y | y
Spreadsheet: phillip_allen__28858__rentroll_investors
Sheet: Max Rent

Unit | Out. Bal | Weekly | Bi-Weekly | Monthly
1 |  | 110
2 |  | 95
3 |  | 120
4 |  |  |  | 330
5 |  | 130
6 |  |  | 260
7 |  | Mgr
8 |  | 130
9 |  |  | 220
10 |  | 110
11 |  |  | 240
12 |  | 110
13 |  | 140
14 |  |  | 190
15 |  |  | 190
16 |  | 120
17 |  | 130
18 |  | 110
19 |  |  |  | 525
20 |  | 130
21 |  |  | 240
22 |  | 130
23 |  | 120
24 |  | Maint
25 |  | 120
26 |  | 115
27 |  | 130
28 |  | 130
29 |  | 115
30 |  |  |  | 400
31 |  | 125
32 |  | 130
33 |  | 130
34 |  | 125
35 |  | 125
36 |  | 125
37 |  | 125
38 |  |  |  | 520
39 |  | 130
40 |  |  |  | 600
41 |  |  |  | 550
42 |  | 120
43 |  | 120
44 |  |  |  | 650
Expected Income
Periods/Year |  | 52 | 26 | 12
Total
Actual Received
1st Dep
2nd Dep
Spreadsheet: 715197d1611597717-check-if-target-times-are-met-test
Sheet: Russ Mann

Visit Date | +45 days | Customer | Notes |  | Job Date | Customer | Amount
2020-11-13 13:36:27 | 2020-12-28 00:00:00 | STAMPTECH, INC. | BLAH BLAH
2020-11-13 13:39:06 | 2020-12-28 00:00:00 | AOC METALS | BLAH BLAH
2020-11-13 13:45:52 | 2020-12-28 00:00:00 | MOTION INDUSTRIES | BLAH BLAH |  | 2020-12-24 00:00:00 | MOTION INDUSTRIES
2020-11-13 13:56:07 | 2020-12-28 00:00:00 | COUNTY OF CHESTERFIELD | BLAH BLAH |  | 2020-12-25 00:00:00 | virginia concrete pumping
2020-11-13 14:05:14 | 2020-12-28 00:00:00 | VIRGINIA CONCRETE PUMPING | BLAH BLAH |  | 2020-12-30 00:00:00 | DRILLCORE LLC
2020-11-13 14:09:48 | 2020-12-28 00:00:00 | STEMMLE PLUMBING REPAIR INC | BLAH BLAH |  | 2020-12-27 00:00:00 | MOTION INDUSTRIES
2020-11-13 14:17:39 | 2020-12-28 00:00:00 | YARDMASTERS IRRIGATION | BLAH BLAH |  | 2020-11-24 00:00:00 | DRILLCORE LLC
2020-11-20 10:21:08.000 |  | DRILLCORE LLC | BLAH BLAH
2020-11-20 10:21:08.000 |  | DRILLCORE LLC | BLAH BLAH
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
 |  |  |  |  |  |  |  | X
Spreadsheet: 47997d1247169996-how-to-pull-info-in-column-c-when-a-and-b-match-certain-criteria-sap-log-audit-template-07-09-09-fs
Sheet: 11W - RM

Name | Advocate | Beginning of Year Goals | Mid-Year Updates | End of Year Updates | TOTAL | Student Snapshots TOTAL
Spreadsheet: 811690d1672751467-copy-whole-rows-if-condition-is-fulfilled-example-file
Sheet: Sheet1

 |  |  | Start | Starts at | End | Ends at
 |  | Appointment 1 | 2023-03-06 00:00:00 | 09:00:00 | 2023-03-06 00:00:00 | 18:00:00
 |  | Appointment 2 | 2023-03-06 00:00:00 | 11:00:00 | 2023-03-06 00:00:00 | 12:00:00
 |  | Appointment 3 | 2023-03-07 00:00:00 | 08:30:00 | 2023-03-08 00:00:00 | 09:00:00
 |  | Appointment 3 | 2023-03-07 00:00:00 | 08:30:00 | 2023-03-08 00:00:00 | 09:00:00
 |  | Appointment 4 | 2023-03-08 00:00:00 | 08:00:00 | 2023-03-08 00:00:00 | 10:30:00
Spreadsheet: 727744d1618068939-updating-index-function-mealplan-aligw
Sheet: Meal Planner

 |  | Meal Planner | Recipe Index
 | Week starting
 | Day of the Week | LUNCH
 |  | My New Recipe
 |  | Spinach Feta Pizza
 |  | Empty Recipe
 |  | Empty Recipe
Spreadsheet: 067b4334-3adc-45ec-b819-f189e0183954
Sheet: Accounts

SchoolID | Username (SSID) | FirstName | MiddleName | LastName | Home Address Line 1 | Home Address Line 2 | City | State (2 char) | Zip (5 digit) | Graduation Year (4 digit) | Student's e-mail | Student's PhoneNumber
File Name: UTFnndddddddddddddddddddd.xls
·         UTF is the three characters “UTF”
·         nn    is the two character LEA ID/number, for example Granite School Districts is “12”
·         dddddddddddddddddddd is the actual name of the LEA up to 20 characters, for example “Granite School Dist”.  Please, no punctuation except spaces.
SchoolID: nnsss
·         nn is the two character LEA ID/number, for example Granite School Districts is “12”
·         sss is the three digit school number, for example Skyline High School is “718”
·         Therefore the SchoolID for Skyline High Schools is “12718”
Username/SSID
Cannot be blank
This must be the unique statewide student ID assigned by the USOE.
First and Last names cannot be blank and cannot exceed 50 characters. Any characters are allowed including hyphens.
Middle Name cannot exceed 50 characters. Any characters are allowed including hyphens.
Home Address Line 1 is limited to 50 characters.
Home Address Line 2 is limited to 50 characters.
City is limited to 50 characters.
State is the 2 character abbreviation.
Zip Code is limited to 5 digits.
Graduation Year is the 4-digit year the student is expected to graduate from high school.
E-mail is limited to 50 characters.
Student’s Phone Number is limited to 12 digits including punctuation and is only used to display on the student’s resume.
Spreadsheet: 60014d1260534941-sending-data-from-input-sheet-to-other-sheets-in-a-workbook-new-budget-planner1
Sheet: Marmy Ins

Marmy Insurance
Month | Year | Paymet
January | 2008
February | 2008
March | 2008
April | 2008
May | 2008
June | 2008
July | 2008
August | 2008
September | 2008
October | 2008
November | 2008
December | 2008 | 13
January | 2009 | 13
February | 2009
March | 2009 | 11.71
April | 2009 | 11.71
May | 2009 | 11.71
June | 2009 | 11.71
July | 2009 | 11.71
August | 2009 | 11.71
September | 2009 | 11.71
October | 2009
November | 2009
December | 2009
January | 2010
February | 2010
March | 2010
April | 2010
May | 2010
June | 2010
July | 2010
August | 2010
September | 2010
October | 2010
November | 2010
December | 2010
Spreadsheet: 686666d1594742703-budgeting-spreadsheet-sample-budget
Sheet: Sheet1

 | Paycheck Amount |  | Date Paid |  |  |  | This would be on a different page:
 |  |  |  |  |  |  | Bills | Amount | Due Date | Paycheck 1 | Paycheck 2 | Paycheck 3
 |  |  |  |  |  |  | Gas | 65 | 15th | Amount needed from this check
 |  |  |  |  |  |  | Water | 45 | 28th |  | Amount needed from this check
 |  |  |  |  |  |  | Mortgage | 1700 | 1st | Amount needed from this check |  | Amount needed from this check
 | Bills | Amount | Dates Due
 | Gas | 65
 | Water | 45
 | Mortgage | 1700
Spreadsheet: 33817d1230648922-how-do-you-create-a-formula-that-will-sum-like-values-list-unique-values-and-combine-fruittotals
Sheet: Sheet1

Line Family | Fruit | Order_Num | QTY
K_ apple | apple | 567849405 | 10 |  | 4 |  | 24 | lemon | 76
K_ apple | apple | 567848175 | 15 |  | 11 |  | 42 | grape | 106
K_ orange | orange | 574545913 | 24 |  | 15 |  | 44 | orange | 96
K_ grape | grape | 574546028 | 24 |  | 13 |  | 45 | apple | 117
7L lemon | lemon | 583482538 | 1 |  | 17 |  | 47 | banana | 129
7L banana | banana | 579432711 | 1 |  | 9 |  | #N/A
7L banana | banana | 587487475 | 1 |  | 10 |  | #N/A
7L banana | banana | 580694697 | 1 |  | 18 |  | #N/A
7L apple | apple | 583356435 | 19 |  | 12 |  | #N/A
7L apple | apple | 585199015 | 6 |  | 14 |  | #N/A
H_ grape | grape | 587017413 | 1 |  | 16 |  | #N/A
J_ apple | apple | 585261773 | 1 |  | 28 |  | #N/A
J_ orange | orange | 585171956 | 1 |  | 21 |  | #N/A
G_ grape | grape | 584498376 | 48 |  | 34 |  | #N/A
I_ lemon | lemon | 582486415 | 2 |  | 19 |  | #N/A
I_ banana | banana | 583129675 | 1 |  | 20 |  | #N/A
L_ lemon | lemon | 585685831 | 1 |  | 22 |  | #N/A
L_ banana | banana | 585685963 | 1 |  | 23 |  | #N/A
L_ orange | orange | 585686631 | 1 |  | 24 |  | #N/A
P_ lemon | lemon | 584497634 | 48 |  | 25 |  | #N/A
P_ banana | banana | 584498129 | 48 |  | 26 |  | #N/A
P_ orange | orange | 584498194 | 48 |  | 27 |  | #N/A
J_ lemon | lemon | 585597788 | 24 |  | #N/A | 24 | #N/A
J_ banana | banana | 585597762 | 24 |  | 35 |  | #N/A
J_ orange | orange | 586336376 | 1 |  | 31 |  | #N/A
J_ apple | apple | 586201166 | 10 |  | 29 |  | #N/A
7L apple | apple | 579462130 | 16 |  | 30 |  | #N/A
7L apple | apple | 579697347 | 1 |  | 33 |  | #N/A
7L orange | orange | 578792172 | 3 |  | 32 |  | #N/A
O_ orange | orange | 586734257 | 1 |  | 44 |  | #N/A
O_ apple | apple | 586112025 | 1 |  | 39 |  | #N/A
O_ grape | grape | 586457560 | 1 |  | 42 |  | #N/A
O_ banana | banana | 586516696 | 1 |  | 36 |  | #N/A
O_ banana | banana | 587189162 | 1 |  | 37 |  | #N/A
H_ banana | banana | 585280864 | 1 |  | 38 |  | #N/A
H_ banana | banana | 585348125 | 1 |  | 47 |  | #N/A
H_ apple | apple | 585184462 | 1 |  | 40 |  | #N/A
7L apple | apple | 587331905 | 1 |  | 41 |  | #N/A
J_ apple | apple | 579539267 | 16 |  | 46 |  | #N/A
J_ grape | grape | 579535182 | 16 |  | 43 |  | #N/A
J_ grape | grape | 579535307 | 16 |  | #N/A | 42 | #N/A
J_ orange | orange | 579538947 | 16 |  | 45 |  | #N/A
7L orange | orange | 577965027 | 1 |  | #N/A | 44 | #N/A
C_ apple | apple | 584005015 | 20 |  | #N/A | 45 | #N/A
7L banana | banana | 584613578 | 16 |  | 48 |  | #N/A
7L banana | banana | 586424347 | 32 |  | #N/A | 47 | #N/A