tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: Continental

 | Contintental
 | 500204 |  | 500205
Day | Measured | Scheduled | Measured | Scheduled
1 | 6315 | 6850 | 5183 | 4456
2 | 6177 | 6932 | 4957 | 4503
3 | 6084 | 6932 | 4786 | 4503
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  |  |  | -397510
2001-02-03 00:00:00
Spreadsheet: 25034d1216111787-applying-a-filter-to-multiple-sheets-samplefile
Sheet: Sheet2

Reference No | Gender | Age
21 | Male | 41
22 | Male | 26
23 | Female | 52
24 | Female | 64
25 | Male | 36
26 | Female | 52
27 | Male | 75
28 | Female | 47
29 | Male | 20
30 | Male | 30
31 | Female | 41
32 | Male | 55
33 | Male | 34
34 | Female | 57
35 | Male | 28
36 | Male | 63
37 | Female | 26
38 | Male | 71
39 | Female | 39
40 | Male | 42
Spreadsheet: 708532d1607918286-filter-formula-filter-formula
Sheet: Tent

SKU
Spreadsheet: 886756d1736865505-avarage-of-consumption-to-each-hour-in-a-month-consumption
Sheet: Pivot

Row Labels | Average of TotalAmount
00:00:00 | 0.7121651147540985
01:00:00 | 0.7339809836065574
02:00:00 | 0.7609726229508197
03:00:00 | 0.7410487213114754
04:00:00 | 0.8015871967213115
05:00:00 | 0.7510916721311476
06:00:00 | 0.8348804262295081
07:00:00 | 0.6994010163934427
08:00:00 | 0.4394667547169811
09:00:00 | 0.2756606046511629
10:00:00 | 0.1793665714285714
11:00:00 | 0.1422696764705882
12:00:00 | 0.2472541875
13:00:00 | 0.3493851000000001
14:00:00 | 0.3288077307692307
15:00:00 | 0.5394491774193548
16:00:00 | 0.9276950806451612
17:00:00 | 1.048536612903226
18:00:00 | 1.099592209677419
19:00:00 | 1.134669951612903
20:00:00 | 0.9435976774193546
21:00:00 | 0.9027611935483868
22:00:00 | 1.247420774193548
23:00:00 | 0.8756168709677421
Grand Total | 0.7445564887387394
Spreadsheet: 793074d1661285389-formula-that-subtract-from-available-stock-and-leaving-the-balance-formula-left-stock
Sheet: Sheet1

Item | On Order | On Hand Inv
123 | 10
123 | 5 |  | This needs to subtrack the 10, so the balance now is 40, and so on
123 | 10 |  | This needs to subtrack the 5, so the balance now is 35, and so on
123 | 10
126 | 10 |  | Here Different part number
126 | 5
126 | 5
 |  |  |  | We have a vlookup formula on C that brings the On Hand for the 123 Item. The [NAME] repeasts it self couple of times due the orders Open. Need to have the balance left on the same column taking into consideration that the Item could change
 |  |  |  | As you can see on my example.
 |  |  |  | Need a forumula, that sumifs the other sheet, bring the On Hand, then subtracts from the first order to see what is left On hand.
 |  |  |  | But if the [NAME] change, it brings the next Oh Hand.
Spreadsheet: 213274d1360420660-conditional-formatting-choices-for-excel-forum
Sheet: Sheet3

Student Name | Form | SB1 | SB2 | SB3 | SB4
[NAME], [NAME] | g | GRA | RUS | CIV | ART
Clelland, [NAME] | g | RUS | FRE | MUS | HIS
Flood, [NAME] | g | CIV | FRE | GEO | HIS
Hayles, [NAME] | g | FRE | SPA | GEO | ART
[NAME], [NAME] | g | ICT | SPA | RUS | RS
King, Oliver | g | RS | FRE | RUS | CIV
McNeil, [NAME] | g | LAT | FRE | GER | HIS
Robson, [NAME] | g | HIS | SPA | RUS | MUS
Spreadsheet: 163505d1340332038-autosort-formula-rnklist
Sheet: Deelnemers en stand

Naam | punten |  | Aantal deelnemers: | 27
[NAME] | 91 |  | Prijzenpot: | 405
Cruijff | 90
Tampie | 81 |  | aantal prijzen: | 4.181818181818182
Nico | 79
[NAME] | 74 |  | 1e prijs | 162
Clint | 73 |  | 2e prijs | 121.5
Ekslem | 73 |  | 3e prijs | 81
Jan | 71 |  | 4e prijs | 40.5
Jansoe | 70
[NAME] | 66
Ale | 64
Seyun | 64
Mac | 62
Sander | 62
Kuiper | 61
Gittermaster | 57
Antidote | 56
[NAME] | 56
Kraai | 54
Lars | 53
EB Sports | 52
Freek | 50
[NAME] | 49
[NAME] | 48
Bumme | 45
Sebas | 44
Ernst | 36
Spreadsheet: benjamin_rogers__1024__TLR Analysis
Sheet: Summary

 | Month | TLR 1 Events | TLR 2a Events | TLR 2b Events | TLR 2c Events | TLR 3 Events | TLR 4 Events | Total TLR Events |  | Curtailment Events | % of events w/curtailment | Non-Curtailment Events | MW's Curtailed | Hrs Curtailed
 | Jan
 | Feb
 | Mar
 | Apr
 | May
 | Jun
 | Jul
 | Aug
 | Sep
 | Oct
 | Nov
 | Dec
 | Annual Totals
Spreadsheet: 0841368f-ebec-4406-8c0f-e724bdc1a338
Sheet: Sheet1

Unnamed: 0 | REQUIRED | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Zone 1 (Minimum Requirements) | Zone 2 (Required to move to Zone 2)                                  At least two years in Zone 1 | Done? | Zone 3 (Required to move to Zone 3)                               At least three years in Zone 2 | Done?
1 | High school diploma or G.E.D. | Three years of experience performing unskilled labor and equipment operation experience related to area of assignment. | X | Six years of semi-skilled and journeyman level experience related to area of assignment (including one year of supervisory experience). | X
2 | One year of experience performing unskilled manual labor related to area of assignment. | Safely operates a side loading collection truck. | X | Safely and proficiently operates Tractor and Side Dump Trailer, roll off, and 4 cy front loader  equipment. | X
3 | One year of equipment operation experience. | Basic understanding and ability to operate a roll off truck. | X | Proficient in operating equipment safely in all weather conditions, or on any route. | X
4 | Must possess, or obtain upon employment, a Commercial Drivers License (CDL), type 'B'. | Must possess a Commercial Drivers License (CDL), type 'B' and Tanker endorsement. | X | Must possess a Commercial Drivers License (CDL), type 'A' with Tanker endorsement. | X
5 | Incumbents of this position are subject to pre-employment drug screening, and post-employment random, post-accident, and reasonable suspicion drug/alcohol screening. | Basic understanding of route practices and procedures. | X | Proficiency in route practices and procedures. | X
6 | Ability and willingness to work weekends and holidays on a shift basis, as assigned, or necessitated by operational needs. | Completes assigned tasks at or above standards. | X | Completes assigned tasks at or above standards. | X
7 |  | Proven track record of operational and personal safety. | X | Proven track record of operational and personal safety. | X
8 |  |  |  | Proficiency in conducting snow removal activities at the SCA plant. | X
9
10
 | DESIRED
 | Zone 1 (min.) | Zone 2 (elements to meet zone 2) | Done? | Zone 3 (elements to meet zone 3) | Done?
1 |  | General knowledge of landfill operations. | X | Working Knowledge of landfill operations.
2 |  | Ability to assist with landfill operations using [NAME], [NAME], 966 [NAME], Back Hoe. | X | Ability to assist with landfill operations using [NAME], [NAME], 966 [NAME], Back Hoe. | X
3 |  | Ability to perform minor maintence on equipment such as changing tires, daily preventitive maintence. | X | Ability to perform minor maintence on equipment such as changing tires, daily preventitive maintence. | X
4 |  |  |  | Generla knowledge of rules and regulations that govern landfill operations.
5
Spreadsheet: lisa_gang__22320__ENA_PGE_JUNE_14_15_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 6/14-15/2002
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  | Total In To PGE Trans
0100 | 0 | 0 | 0 | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0
0700 | 50 | 25 | 25 | 25 | 25
0800 | 50 | 25 | 25 | 25 | 25
0900 | 50 | 25 | 25 | 25 | 25
1000 | 50 | 25 | 25 | 25 | 25
1100 | 50 | 25 | 25 | 25 | 25
1200 | 50 | 25 | 25 | 25 | 25
1300 | 50 | 25 | 25 | 25 | 25
1400 | 50 | 25 | 25 | 25 | 25
1500 | 50 | 25 | 25 | 25 | 25
1600 | 50 | 25 | 25 | 25 | 25
1700 | 50 | 25 | 25 | 25 | 25
1800 | 50 | 25 | 25 | 25 | 25
1900 | 50 | 25 | 25 | 25 | 25
2000 | 50 | 25 | 25 | 25 | 25
2100 | 50 | 25 | 25 | 25 | 25
2200 | 50 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24966 | BPA(G)24966 | BPA(G)24966 | BPA(G)24661 | BPA(G)24718
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP
 | MID | MIRANT | SNCL | MORGAN | SDGE
 | MID(T)CPJK/TRACEY/WESLEY | SMUD | ISO(T)CPJK/NP15 | SPP | ISO(T)MALIN/SP15
 | MID(L)WESLEY | SMUD(T)CPJK/NP15 | SNCL(L)NP15 | PAC | SDGE(L)SP15
 |  | SMUD(L)NP15 |  | CDWR
 |  |  |  | SEMP
 |  |  |  | CDWR
 |  |  |  | ISO(T)MALIN/NP15
 |  |  |  | CDWR(L)NP15
Spreadsheet: 123485d1317678279-obtaining-data-within-a-specific-date-range-resource-center-service-tracking-log
Sheet: Participant Roster 

 | DEMOGRAPHICS |  |  |  | ENROLLMENT INFORMATION |  |  |  |  |  |  |  | 3 MONTH RECERTIFICATION |  | 6 MONTH RECERTIFICATON |  | 9 MONTH RECERTIFICATION |  | 12 MONTH RECERTIFICATION |  |  | SUPPORTIVE SERVICES RECEIVED
Date of Entry | Last Name | First Name | DOB | Last 4  of Social | Homeless Verification | [NAME] | Date Enrolled | Case Manager | Assessment Completed | HMIS # | Income at Entry | Type of Service | Homeless verification | Income | Homeless verification | Income | Homeless verification | Income | Homeless verification | Income | Exit Date | Tokens Received | Meal Voucher | BC Voucher | ID Voucher | Comments
2011-04-02 00:00:00 | Lam | Vaness |  |  |  |  | 2011-04-02 00:00:00 | [NAME] |  | 1072746 |  | supportive service
2011-04-04 00:00:00 | Ngon | Men |  |  |  |  | 2011-04-04 00:00:00 | Brandie |  | 1035491
2011-04-05 00:00:00 | [NAME] | [NAME] |  |  |  |  | 2011-04-05 00:00:00 | Brandie |  | 1071611
2011-04-05 00:00:00 | Rhodes | [NAME] |  |  |  |  | 2011-04-05 00:00:00 | Brandie |  | 1069958
2011-04-06 00:00:00 | Hermann | [NAME] |  |  |  |  | 2011-04-06 00:00:00 | Brandie |  | 1071694
2011-04-06 00:00:00 | Moore | [NAME] |  |  |  |  | 2011-04-06 00:00:00 | Brandie |  | 1071678
2011-04-06 00:00:00 | Rojas | Reene |  |  |  |  | 2011-04-06 00:00:00 | Brandie |  | 1058568
2011-04-06 00:00:00 | Vargas | [NAME] |  |  |  |  | 2011-04-06 00:00:00 | Brandie |  | 1071639
2011-04-08 00:00:00 | [NAME] | [NAME] |  |  |  |  | 2011-04-08 00:00:00 | Brandie |  | 1021132
2011-04-11 00:00:00 | [NAME] | Laverne |  |  |  |  | 2011-04-11 00:00:00 | Brandie |  | 1049480
2011-04-12 00:00:00 | [NAME] | [NAME] |  |  |  |  | 2011-04-12 00:00:00 | Brandie |  | 1016075
2011-04-12 00:00:00 | McGee | [NAME] |  |  |  |  | 2011-04-12 00:00:00 | Brandie |  | 1071666
2011-04-12 00:00:00 | [NAME] | [NAME] |  |  |  |  | 2011-04-12 00:00:00 | Brandie |  | 1014864
2011-04-13 00:00:00 | Boney | [NAME] |  |  |  |  | 2011-04-13 00:00:00 | Brandie |  | 1071681
2011-04-13 00:00:00 | Soukup | [NAME] |  |  |  |  | 2011-04-13 00:00:00 | Brandie |  | 1072444
2011-04-14 00:00:00 | Habel | [NAME] |  |  |  |  | 2011-04-14 00:00:00 | Brandie |  | 1071697
2011-04-14 00:00:00 | Martinez | Christian |  |  |  |  | 2011-04-14 00:00:00 | Brandie |  | 1071700
2011-04-18 00:00:00 | [NAME] | Marlon |  |  |  |  | 2011-04-18 00:00:00 | Brandie |  | 1068796
2011-04-18 00:00:00 | [NAME] | Debora |  |  |  |  | 2011-04-18 00:00:00 | Brandie
Spreadsheet: 160178d1338998055-how-to-combine-if-statement-in-offset-function-please-help-timesheet-upload
Sheet: Data Validation - Switch Lists

 | Cell with Validation |  |  | ShortList |  | Full List
 | Full List |  |  | Full List |  | Task for T.G 01 |  | How this works?
 |  |  |  | Task for T.G 07 |  | Task for T.G 02 |  | » [NAME] the cell B7
 |  |  |  | Task for T.G 11 |  | Task for T.G 03 |  | » Go to menu > data > validation
 |  |  |  | Task for T.G 14 |  | Task for T.G 04 |  | » See how the validation formula is used (shown below)
 |  |  |  | Task for T.G 19 |  | Task for T.G 05
 |  |  |  | Task for T.G 22 |  | Task for T.G 06
 |  |  |  | Task for T.G 24 |  | Task for T.G 07
 |  |  |  |  |  | Task for T.G 08
 |  |  |  |  |  | Task for T.G 09
 |  |  |  |  |  | Task for T.G 10
 |  |  |  |  |  | Task for T.G 11
 |  |  |  |  |  | Task for T.G 12
 |  |  |  |  |  | Task for T.G 13
 |  |  |  |  |  | Task for T.G 14
 |  |  |  |  |  | Task for T.G 15
 |  |  |  |  |  | Task for T.G 16
 |  |  |  |  |  | Task for T.G 17
 |  |  |  |  |  | Task for T.G 18
 |  |  |  |  |  | Task for T.G 19
 |  |  |  |  |  | Task for T.G 20
 |  |  |  |  |  | Task for T.G 21
 |  |  |  |  |  | Task for T.G 22
 |  |  |  |  |  | Task for T.G 23
 |  |  |  |  |  | Task for T.G 24
 |  |  |  |  |  | Task for T.G 25
 |  |  |  |  |  | Task for T.G 26
Spreadsheet: 75593d1276134692-summing-totals-by-time-interval-dtel2cs-xfers-03102010-06072010
Sheet: TOTAL BY INTERVAL BY CENTER

EASTERN TIME | AUSTIN | CHESAPEAKE | SAN ANTONIO | TOTAL
08:00:00 | 0 | 2 | 1 | 3
08:15:00 | 0 | 0 | 3 | 3
08:30:00 | 0 | 0 | 0 | 0
08:45:00 | 0 | 6 | 2 | 8
09:00:00 | 0 | 4 | 2 | 6
09:15:00 | 0 | 0 | 0 | 0
09:30:00 | 0 | 5 | 5 | 10
09:45:00 | 1 | 7 | 4 | 12
10:00:00 | 1 | 7 | 3 | 11
10:15:00 | 2 | 4 | 6 | 12
10:30:00 | 1 | 6 | 0 | 7
10:45:00 | 0 | 0 | 0 | 0
11:00:00 | 0 | 4 | 5 | 9
11:15:00 | 2 | 4 | 6 | 12
11:30:00 | 0 | 0 | 0 | 0
11:45:00 | 1 | 9 | 3 | 13
12:00:00 | 0 | 13 | 1 | 14
12:15:00 | 0 | 0 | 0 | 0
12:30:00 | 3 | 5 | 3 | 11
12:45:00 | 0 | 0 | 0 | 0
13:00:00 | 0 | 0 | 0 | 0
13:15:00 | 2 | 6 | 5 | 13
13:30:00 | 0 | 0 | 0 | 0
13:45:00 | 0 | 0 | 0 | 0
14:00:00 | 2 | 3 | 8 | 13
14:15:00 | 0 | 0 | 0 | 0
14:30:00 | 0 | 0 | 0 | 0
14:45:00 | 1 | 5 | 4 | 10
15:00:00 | 0 | 0 | 0 | 0
15:15:00 | 0 | 0 | 0 | 0
15:30:00 | 0 | 0 | 0 | 0
15:45:00 | 0 | 0 | 0 | 0
16:00:00 | 0 | 0 | 0 | 0
16:15:00 | 0 | 0 | 0 | 0
16:30:00 | 0 | 0 | 0 | 0
16:45:00 | 0 | 0 | 0 | 0
17:00:00 | 0 | 0 | 0 | 0
17:15:00 | 0 | 0 | 0 | 0
17:30:00 | 0 | 0 | 0 | 0
17:45:00 | 0 | 0 | 0 | 0
18:00:00 | 0 | 0 | 0 | 0
18:15:00 | 0 | 0 | 0 | 0
18:30:00 | 0 | 0 | 0 | 0
18:45:00 | 0 | 0 | 0 | 0
19:00:00 | 0 | 0 | 0 | 0
19:15:00 | 0 | 0 | 0 | 0
19:30:00 | 0 | 0 | 0 | 0
19:45:00 | 0 | 0 | 0 | 0
20:00:00 | 0 | 0 | 0 | 0
20:15:00 | 0 | 0 | 0 | 0
20:30:00 | 0 | 0 | 0 | 0
20:45:00 | 0 | 0 | 0 | 0
21:00:00 | 0 | 0 | 0 | 0
21:15:00 | 0 | 0 | 0 | 0
21:30:00 | 0 | 0 | 0 | 0
21:45:00 | 0 | 0 | 0 | 0
22:00:00 | 0 | 0 | 0 | 0
22:15:00 | 0 | 0 | 0 | 0
22:30:00 | 0 | 0 | 0 | 0
22:45:00 | 0 | 0 | 0 | 0
23:00:00 | 0 | 0 | 0 | 0
Spreadsheet: 830539d1684962429-payment-schedule-based-on-term-60-84mo-etc-book2
Sheet: Payment Plan

 |  |  |  |  |  |  |  |  |  |  | 2023-06-30 00:00:00 |  | 2024-06-30 00:00:00 |  | 2025-06-30 00:00:00 |  | 2026-06-30 00:00:00 |  | 2027-06-30 00:00:00 |  | 2028-06-30 00:00:00 |  | 2029-06-30 00:00:00 |  | 2030-06-30 00:00:00 |  | 2031-06-30 00:00:00
Account | Division | Quote | Quote Description | Purchase Cost | MSA- Monthly Payment Installment | Monthly Support | Amendment Number(s) | Amendment Net Change in Monthly Payment Installment | Confirmed TBD | [NAME] Notes | FY23 Total Months (July 1, 2022-June 30, 2023) | FY23 Total | FY24 Total Months (July 1, 2023-June 30, 2024) | FY24 Total | FY25 Total Months (July 1, 2024- June 30, 2025 | FY25 | FY26 Total Months (July 1, 2025- June 30, 2026) | FY26 Total | FY27 Total Months (July 1, 2026- June 30, 2027) | FY27 Total | FY28 Total Months (July 1, 2027- June 30, 2028) | FY28 Total | FY29 Total Months (July 1, 2028- June 30, 2029) | FY29 Total | FY29 Total Months (July 1, 2029- June 30, 2030) | FY30 Total | FY29 Total Months (July 1, 2030- June 30, 2031) | FY31 Total |  | TOTAL CAPX Project
1 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
2 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
3 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
4 |  |  |  | 500000 |  |  |  |  | 2023-02-01 00:00:00
5 |  |  |  | 500000 |  |  |  |  | 2023-03-01 00:00:00
6 |  |  |  | 500000 |  |  |  |  | 2023-11-01 00:00:00
7 |  |  |  | 500000 |  |  |  |  | 2023-09-01 00:00:00
8 |  |  |  | 500000 |  |  |  |  | 2022-07-01 00:00:00
9 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
10 |  |  |  | 500000 |  |  |  |  | 2023-06-01 00:00:00
11 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
12 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
13 |  |  |  | 500000 |  |  |  |  | 2023-08-01 00:00:00
14 |  |  |  | 500000 |  |  |  |  | 2023-08-01 00:00:00
15 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
16 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
17 |  |  |  | 500000 |  |  |  |  | 2023-07-01 00:00:00
18 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
19 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
20 |  |  |  | 500000 |  |  |  |  | 2023-08-01 00:00:00
21 |  |  |  | 500000 |  |  |  |  | 2023-03-01 00:00:00
22 |  |  |  | 500000 |  |  |  |  | 2023-03-01 00:00:00
23 |  |  |  | 500000 |  |  |  |  | 2023-10-01 00:00:00
24 |  |  |  | 500000 |  |  |  |  | 2023-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0
Spreadsheet: 147670d1332922710-lookup-values-across-range-of-worksheets-tracker
Sheet: 2011 Feb

ID | Surname | Name | 2011-02-01 00:00:00 | 2011-02-02 00:00:00
1 | Surname1 | Name1 | E | H
2 | Surname2 | [NAME] | C | D
3 | Surname3 | Name3 | E | A
4 | Surname4 | Name4 | B | E
5 | Surname5 | Name5 | F | B
6 | Surname6 | Name6 | D | F
7 | Surname7 | Name7 | A | C
Spreadsheet: 726550d1617289852-building-a-list-with-multiple-checkboxes-samplerecipelist
Sheet: Recipe

 | Apple | [NAME] | Orange | Milk | [NAME] | Salt | Sugar | Water | Wheat [NAME] | Peanuts | Full List
Recipe 1 |  |  |  |  |  |  |  |  |  |  | Apple, Milk, Sugar, Wheat Flour.
Recipe 2 |  |  |  |  |  |  |  |  |  |  | Apple, Orange, [NAME], Salt, Sugar, Water, Peanuts
Recipe 3 |  |  |  |  |  |  |  |  |  |  | Banana, Sugar, Water
Recipe 4 |  |  |  |  |  |  |  |  |  |  | Banana, Salt, Water, Peanuts
Recipe 5 |  |  |  |  |  |  |  |  |  |  | Orange, Sugar, Water
Spreadsheet: 747882d1631753716-if-and-and-functions-book11
Sheet: Sheet1

Employee No | Month | Date of hire | Length of employment | Seniority
1 | Jan-21 | 2013-02-22 00:00:00 |  | IF(N2<1,"<1",IF(AND(N2>1,N2<=3),"1-3",IF(AND(N2>3,N2<=5),"3-5",IF(AND(N2>5,N2<=10),IF(AND(N2>10),">10")))))
2 | Jan-21 | 2013-07-15 00:00:00
3 | Jan-21 | 2013-11-18 00:00:00
4 | Jan-21 | 2014-01-08 00:00:00
5 | Jan-21 | 2014-04-07 00:00:00
6 | Jan-21 | 2014-03-10 00:00:00
7 | Jan-21 | 2014-05-06 00:00:00
8 | Jan-21 | 2014-06-16 00:00:00
Spreadsheet: 712456d1610216312-lookup-or-loop-through-planning_example
Sheet: Data

TrainingType | Format | Level | TypeCode | Amt | [NAME] | Location | Location Code | Travel Labour | Expense Est
ABC | I | 1 |  | 100 | 10 | North | NOR | 2 | 100
XYZ | R | 1 |  | 200 | 20 | East | EAS | 4 | 100
XYZ | I | 2 |  | 300 | 20 | West | WES | 6 | 100
 |  |  |  |  |  | South | SOU | 7 | 100
Spreadsheet: 855023d1704744890-how-to-stop-count-once-a-certain-value-has-been-reached-example-result
Sheet: Example

Persona ID | Period | Absent | Pay |  | 2022-01-01 00:00:00 | 2022-12-01 00:00:00
1234 | 2020-01-01 00:00:00 | 1 | 324
1234 |  | 1 | 5324
1234 |  | 1 | 4234
1234 |  | 1 | 234234
1234 |  | 1 | 543543
1234 |  | 1 | 2354
1234 |  | 1 | 423423
1234 |  | 1 | 4324
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 1 | 421421
1234 |  | 1 | 321321
1234 |  | 0 | 0
1234 |  | 0 | 321
1234 |  | 0 | 7657
1234 |  | 1 | 0
1234 |  | 0 | 0
1234 |  | 1 | 434
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 0 | 0
1234 |  | 1 | 0
1234 |  | 1 | 0
1234 |  | 1 | 543
1234 |  | 1 | 432
1234 |  | 1 | 4234
1234 |  | 1 | 5435
Result:
Spreadsheet: de4832f8-13ba-4774-b0be-a1ead4257c0d
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | 120050 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Brief Title |  | Approval Deadline |  | Reason
 | Joint Housing Dvelopment Partnership
 | with KCSD, LCRA, etc for replacement housing
Details |  |  |  |  | Positions/Recommendations
 | Reason for Legislation |  |  |  | Sponsor |  |  |  | Housing Department
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  |  |  | _________ Department
 |  |  |  |  | or Groups
 |  |  |  |  | Affected
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  |  |  | _________ Department
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or
 |  |  |  |  | Commission |  | By
 |  |  |  |  | Recommendation
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s) |  | 19__ Budget, Page ___
 |  |  |  |  | and Appropriation |  | Unbudgeted, Appropriation
 |  |  |  |  | Account Codes |  | ________________ Fund
 |  |  |  |  |  |  | 00-000-00-0000-A0000
 |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 | Name |  | Date
 | Title
Reviewed by:
 | Name |  | Date
 | Title
Reference Numbers
Spreadsheet: 124482d1318437127-time-calculations-proceduretime
Sheet: Sheet1

Procedure #: | Trial #: | Trial Time: | Procedure Time: | Total Time:
Procedure #1 | Trial #1 | 10:49:15
Procedure #1 | Trial #2 | 10:49:44
Procedure #1 | Trial #3 | 10:50:43
Procedure #1 | Trial #4 | 10:51:14
Procedure #1 | Trial #5 | 10:51:46
Procedure #1 | Trial #6 | 10:52:14
Procedure #2 | Trial #1 | 10:55:32
Procedure #2 | Trial #2 | 10:56:17
Procedure #2 | Trial #3 | 10:57:03
Procedure #3 | Trial #1 | 11:04:23
Procedure #3 | Trial #2 | 11:08:17
added procedure