tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868501d1715220554-very-complicated-sum-function-testing
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
 |  |  |  |  |  | NO EVENT |  |  |  | SmallEvent |  | SmallEvent
NAME | FULL NAME |  |  |  |  |  |  |  |  |  |  | 1 | 250 |  |  |  |  | 1 | 750
NAME | FULL NAME |  |  |  |  |  |  |  |  |  |  | 1 | 250 |  |  |  |  | 2 | 600
NAME | FULL NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 750
NAME | FULL NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 600
NAME | FULL NAME |  |  |  |  |  |  | 1 | 500
NAME | FULL NAME |  |  |  |  |  |  | 1 | 500
Spreadsheet: 77443d1277912394-extract-room-number-and-student-id-and-put-them-in-other-cells-studenthousing-3-
Sheet: MANDO

MANDO | Total on MANDO: | 44
Class # | Title | Last | First
10010 | Mr. | Al | Capone | **title, last, first concatenated as before I actually got it done with the last code I posted, but it isn't pretty because I can't move the data to a new area
10010 | Mr. | [NAME] | [NAME]
10010 | Mr. | [NAME] | [NAME]
10010 | Mr. | Ryuichiro | Kuroda
10010 | Mr. | Salvatore | Leone
10010 | Mr. | [NAME] | Juntao
10010 | Mr. | [NAME] | Lem
10020 | Mr. | [NAME] | Guerrard
10020 | Mr. | [NAME] | Love
10030 | Mr. | Avery | Carrington
10030 | Mr. | Giacomo | Magliozzi
10030 | Mr. | [NAME] | [NAME]
10030 | Mr. | [NAME] | [NAME]
10040 | Mr. | Akira | Hojo
10040 | Mr. | Alberto | Napoli
10040 | Mr. | [NAME] | [NAME]
10040 | Mr. | [NAME] | Morello
10040 | Mr. | [NAME] | Morgan
10040 | Mr. | Kakihara | Ichi
10040 | Mr. | Subhash | Nagre
10045 | Mr. | Alexei | [NAME]
10050 | Mrs. | Clarissa | Dalloway
10070 | Mr. | Richie | Cusack
10080 | Mr. | [NAME] | Willis
10080 | Mr. | Chucky | Pancamo
10080 | Mr. | King | [NAME]
10085 | Mr. | Mark | Antony
10085 | Mr. | Ricardo | [NAME]
10100 | Mr. | [NAME] | [NAME]
10100 | Mrs. | Claudine | Colette
10100 | Mr. | [NAME] | Pianta
10100 | Mr. | Florentino | Ariza
10110 | Mr. | Binx | Bolling
10110 | Mr. | Casanova | Frankenstein
10110 | Mr. | Escobar | [NAME]
10115 | Mr. | Manick | Baasha
10120 | Mr. | Cyrus | [NAME]
10120 | Mr. | Giovanni | [NAME]
10120 | Mr. | [NAME] | Gatsby
10130 | Mr. | [NAME] | Polford
10130 | Mr. | Never | Everwas
10130 | Mr. | Newland | [NAME]
10140 | Mr. | [NAME] | Ryder
10150 | Mr. | Marcus | [NAME]
Spreadsheet: 805681d1668830433-nested-substitute-giving-me-problems-forum-2
Sheet: Table 6

No. | Last10 | Horse
3 | 30959x000x | Samizdat tcdsho(HT) 7yo(Gelding)
4 | 112x121147 | Comes A Time tcds 6yo(Gelding)
5 | [NAME] | Minsk Moment h 4yo(Stallion)
6 | 4131311192 | Let's Galahvant ds(D/A) 4yo(Gelding)
7 | 53x111x673 | Devoted dsb(D/A) 4yo(Gelding)
8 | 31237214x9 | Bruce Almighty tcds(HT) 7yo(Gelding)
9 | x1012x6554 | It'sarayday tcdshb(HT) 4yo(Gelding)
10 | x056705432 | [NAME] tcds 8yo(Gelding)
11 | 8x22133214 | Em Tee Aye tcds(HT) 5yo(Gelding)
12 | x312x73553 | Staralign tcdsb 7yo(Gelding)
13 | x125x6x773 | [NAME]) 5yo(Gelding)
14 | 112124x71x | [NAME]n't Silly tcds(HT) 5yo(Gelding)
1 | x056200710 | Winning Partner dso(D/A) 7yo(Gelding)
2 | x787440805 | Dig Deep tcd 6yo(Gelding)
Spreadsheet: 819357d1677449656-formula-to-calculate-downtime-loadout-log-template
Sheet: Monday

Date | Division | Route | Hauler | Trailer Number | Scheduled Depart Time (Route Sheet) | NEW Estimated Load Completed Time | Actual Load Completion Time | Time Load Departed Dairy | Shift | Load Start Time | Load Finish Time | Load Duration | Case Count | Pallet Count | Trailer Temp | Reason For Downtime | Comments
2023-02-13 00:00:00 | Central | 208 |  | 3127 | 12:00:00 |  | 08:40:00 |  |  | 08:20:00 | 08:40:00 |  | 926 | 18 | 36.8 | 5:30-6:10 Safety Traning
2023-02-13 00:00:00 | Central | 209 |  | 8663 | 12:10:00 |  | 09:00:00 | 13:18:00 |  | 08:40:00 | 09:00:00 |  | 1194 | 23 | 45.8 | 6:10-6:40 Pickers
2023-02-13 00:00:00 | Central | 210 |  | 8650 | 12:37:00 |  | 09:30:00 | 13:54:00 |  | 09:00:00 | 09:30:00 |  | 1057 | 21 | 45 | 6:40 - 8:20 Chain off Track 1
2023-02-13 00:00:00 | Central | 211 |  | 8614 | 13:00:00 |  | 10:30:00 | 11:35:00 |  | 10:00:00 | 10:30:00 |  | 1104 | 21 | 45.5 | 9:30-10:00 break
2023-02-13 00:00:00 | Central | 212 |  | 8633 | 13:49:00 |  | 10:50:00 |  |  | 10:30:00 | 10:50:00 |  | 1163 | 22 | 39.5 | 11:50-12:20 lunch
2023-02-13 00:00:00 | Central | 213 |  | 8658 | 14:09:00 |  | 11:10:00 | 14:13:00 |  | 10:50:00 | 11:10:00 |  | 1120 | 22 | 45 | 3:40-4:15 Chain off on [NAME]
2023-02-13 00:00:00 | Central | 214 |  | 3157 | 15:00:00 |  | 11:40:00 |  |  | 11:10:00 | 11:40:00 |  | 1131 | 21 | 39.1
2023-02-13 00:00:00 | Central | 215 |  | 3134 | 15:00:00 |  | 12:50:00 | 17:42:00 |  | 12:20:00 | 12:50:00 |  | 1177 | 22 | 40.8
2023-02-13 00:00:00 | Central | 216 |  | 8654 | 18:30:00 |  | 13:20:00 |  |  | 12:50:00 | 13:20:00 |  | 1042 | 20 | 43.5
2023-02-13 00:00:00 | Central | 217 |  | 8638 | 20:00:00 |  | 13:50:00 |  |  | 13:20:00 | 13:50:00 |  | 806 | 20 | 40.9
2023-02-13 00:00:00 | Ruler | C04 |  | 6770 | 19:00:00 |  | 14:10:00 | 16:34:00 |  | 13:50:00 | 14:10:00 |  | 915 | 18 | 45.6
2023-02-13 00:00:00 | Ruler | C05 |  | 2899 | 19:30:00 |  | 14:30:00 | 16:35:00 |  | 14:10:00 | 14:30:00 |  | 735 | 16 | 45.1
2023-02-13 00:00:00 | Ruler | C06 |  | 1856 | 20:00:00 |  | 14:50:00 | 16:43:00 |  | 14:30:00 | 14:50:00 |  | 773 | 19 | 38.9
2023-02-13 00:00:00 | [NAME] | J04 |  | 8661 | 05:00:00 |  | 15:10:00 |  |  | 14:50:00 | 15:10:00 |  | 627 | 12 | 36.5
2023-02-13 00:00:00 | F4L | 301 |  | 8647 | 02:00:00 |  | 15:20:00 |  |  | 15:10:00 | 15:20:00 |  | 450 | 9 | 42.7
2023-02-13 00:00:00 | F4L | 302 |  | 8641 | 02:23:00 |  | 15:40:00 |  |  | 15:20:00 | 15:40:00 |  | 1032 | 20 | 45.9
2023-02-13 00:00:00 | Mariano's | M05 |  | 8637 | 02:52:00 |  | 16:35:00 |  |  | 15:40:00 | 16:35:00 |  | 1159 | 26 | 43.6
Spreadsheet: 834696d1688003937-text-based-on-two-cells-2020companies-example
Sheet: Sheet2

IF data here - populate in column c |  | formula here
BARCLAY DAMON LLP
CT CORPORATION SYSTEM
CT LIEN SOLUTIONS
J. TAYLOR & ASSOCIATES, LLC
KONICA MINOLTA
KONICA MINOLTA BUSINESS SOLUTIONS USA, INC.
KONICA MINOLTA PREMIER FINANCE
MEDHQ LLC
MEDICAL EQUIPMENT RESOURCES & CONSULTING
MEDTELLIGENCE LLC
TAYLOR COMMUNICATIONS INC
VMG HEALTH
WALLER LANSDEN DORTCH & DAVIS, LLP
WHEELER STAFFING PARTNERS, INC.
WHITE SANDS SALES TAX CONSULTING, LLC
[NAME]
WILLIS TOWERS WATSON US LLC
WILLKIE FARR & GALLAGHER LLP
WISCONSIN DEPARTMENT OF REVENUE
WOMBLE BOND DICKINSON US LLP
ZRG PARTNERS LLC
 | JE Entry BARCLAY DAMON LLPmisc text here
 | JE Entry CT CORPORATION SYSTEMmisc text here
 | JE Entry CT LIEN SOLUTIONSmisc text here
 | JE Entry J. TAYLOR & ASSOCIATES, LLCmisc text here
 | JE Entry KONICA MINOLTAmisc text here
 | JE Entry KONICA MINOLTA BUSINESS SOLUTIONS USA, INC.misc text here
 | JE Entry KONICA MINOLTA PREMIER FINANCEmisc text here
 | JE Entry [NAME] text here
 | JE Entry MEDICAL EQUIPMENT RESOURCES & CONSULTINGmisc text here
 | JE Entry MEDTELLIGENCE LLCmisc text here
 | JE Entry TAYLOR COMMUNICATIONS INCmisc text here
 | JE Entry VMG HEALTHmisc text here
 | JE Entry WALLER LANSDEN DORTCH & DAVIS, [NAME] text here
 | JE Entry WHEELER STAFFING PARTNERS, INC.misc text here
 | JE Entry WHITE SANDS SALES TAX CONSULTING, LLCmisc text here
 | JE Entry [NAME] text here
 | JE Entry WILLIS TOWERS WATSON US LLCmisc text here
 | JE Entry WILLKIE FARR & GALLAGHER LLPmisc text here
 | JE Entry WISCONSIN DEPARTMENT OF REVENUEmisc text here
 | JE Entry WOMBLE BOND DICKINSON US LLPmisc text here
 | JE Entry ZRG PARTNERS LLCmisc text here
 | JE Entry BARCLAY DAMON LLPmisc text here
 | JE Entry CT CORPORATION SYSTEMmisc text here
Spreadsheet: andy_zipper__127__Broker & Exchange Detail 6-8-01
Sheet: BROKER DEAL SUMMARY

EnronOnline Broker Detail for 6/8/2001
Completed Transactions:
TODAY
Date | 2001-06-08 00:00:00
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 2 | 18 | 155 | 995 | 20 | 1150
Natsource LLC |  | 14 |  | 627 | 14 | 627
Amerex Natural Gas I, Ltd. | 3 |  | 387.5 |  | 3 | 387.5
Amerex Power, Ltd. |  | 14 |  | 1220 | 14 | 1220
Prebon Energy, Inc. |  | 4 |  | 0 | 4 | 0
Grand Total | 5 | 50 | 542.5 | 2842 | 55 | 3384.5
**Waiting on Broker Fees for Prebon Energy, Inc's German Power Trade on 6/7/01 and 6/8/01
LTD
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 102 | 314 | 28535 | 24824.84 | 416 | 53359.84
Natsource LLC | 38 | 307 | 6208.5 | 28078 | 345 | 34286.5
Power Merchants Group, LLC | 13 |  | 1636.83 |  | 13 | 1636.83
Amerex Natural Gas I, Ltd. | 62 | 1 | 10486.4375 | 4 | 63 | 10490.4375
Amerex Power, Ltd. |  | 109 |  | 9869 | 109 | 9869
Prebon Energy, Inc. |  | 6 |  | 120 | 6 | 120
Grand Total | 215 | 737 | 46866.7675 | 62895.84 | 952 | 109762.6075
Failed Transactions:
TODAY
Date | 2001-06-08 00:00:00
FAILED TRANSACTION COUNT | Commodity
Broker | Power | Grand Total
APB Energy, Inc. | 2 | 2
Natsource LLC | 2 | 2
Amerex Power, Ltd. | 1 | 1
Prebon Energy, Inc. | 1 | 1
Grand Total | 6 | 6
LTD
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. | 43 | 44 | 87
Natsource LLC | 7 | 42 | 49
Power Merchants Group, LLC | 21 |  | 21
Amerex Power, Ltd. |  | 13 | 13
Amerex Natural Gas I, Ltd. | 6 |  | 6
Prebon Energy, Inc. | 1 | 1 | 2
Grand Total | 78 | 100 | 178
Spreadsheet: lisa_gang__22219__EPE_MARCH_2002
Sheet: MARCH(12)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-03-12 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS | FOUR CORNERS |  | PALO VERDE | PALO VERDE | PALO VERDE
Pacific | Mountain | SALE | SALE |  | PURCHASE | PURCHASE | PURCHASE
Standard | Standard | EPMI | EPMI |  | EPMI | EPMI | MIRANT
Time | Time | 22.25 | 22.25 |  | 121 | 121 | 141.5
 |  | CARRY OVER FROM 3/11 | ON GOING DAILY |  | ON GOING DAILY | ON GOING DAILY | ONGOING DAILY
 |  | 3/1/02-3/31/02 | 3/1/02-3/31/02 |  | 3/1/02-3/31/02 | 3/1/02-3/31/02 | 3/1/02-3/31/02
 |  | EPMI TAG#41387 | EPMI TAG#41424 |  | EPMI TAG#41427 | EPMI TAG#41426 | EPMI TAG#41434 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL | DIRECT BILL |  | DIRECT BILL | DIRECT BILL | DIRECT BILL
2400 | 0100 | 25 | 0 |  | 0 | 0 | 0
0100 | 0200 | 0 | 25 |  | 0 | 0 | 0
0200 | 0300 | 0 | 25 |  | 0 | 0 | 0
0300 | 0400 | 0 | 25 |  | 0 | 0 | 0
0400 | 0500 | 0 | 25 |  | 0 | 0 | 0
0500 | 0600 | 0 | 25 |  | 0 | 0 | 0
0600 | 0700 | 0 | 25 |  | 0 | 0 | 0
0700 | 0800 | 0 | 0 |  | -25 | -25 | -25
0800 | 0900 | 0 | 0 |  | -25 | -25 | -25
0900 | 1000 | 0 | 0 |  | -25 | -25 | -25
1000 | 1100 | 0 | 0 |  | -25 | -25 | -25
1100 | 1200 | 0 | 0 |  | -25 | -25 | -25
1200 | 1300 | 0 | 0 |  | -25 | -25 | -25
1300 | 1400 | 0 | 0 |  | -25 | -25 | -25
1400 | 1500 | 0 | 0 |  | -25 | -25 | -25
1500 | 1600 | 0 | 0 |  | -25 | -25 | -25
1600 | 1700 | 0 | 0 |  | -25 | -25 | -25
1700 | 1800 | 0 | 0 |  | -25 | -25 | -25
1800 | 1900 | 0 | 0 |  | -25 | -25 | -25
1900 | 2000 | 0 | 0 |  | -25 | -25 | -25
2000 | 2100 | 0 | 0 |  | -25 | -25 | -25
2100 | 2200 | 0 | 0 |  | -25 | -25 | -25
2200 | 2300 | 0 | 0 |  | -25 | -25 | -25
2300 | 2400 | 0 | 25 |  | 0 | 0 | 0
2400 | 0100 | 0 | 25 |  | 0 | 0 | 0
 | MST Total |  |  |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  | TOTAL SALES |  |  |  | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C | EPE(G)4C |  | PINWEST(G)PV | PINWEST(G)PV | PINWEST(G)PV
 |  | EPMI | EPMI |  | AEP | EPME | MIRANT
 |  | AZPS(T)FC3/PPD2 | AZPS(T)FC3/PPD2 |  | EPMI | AEP | EPE
 |  | WALC(T)PPD2/COOLIDGE | WALC(T)PPD2/COOLIDGE |  | EPE | EPMI | EPMI
 |  | CRSP(L)COOLIDGE | CRSP(L)COOLIDGE |  | EPE(T)PV/WW | EPE | EPE
 |  |  |  |  | TEP(T)WW/SP3 | EPE(T)PV/WW | EPE(T)PV/WW
 |  |  |  |  | EPE(T)SP3/LUNA | TEP(T)WW/SP3 | TEP(T)WW/SP3
 |  |  |  |  |  | EPE(T)SP3/LUNA | EPE(T)SP3/LUNA
 |  |  |  |  |  | EPE(L)LUNA | EPE(L)LUNA
Spreadsheet: 221239d1363439903-npv-for-hire-purchase-after_tax_npv
Sheet: Sheet1

RATE | 0.08 | 0.08
GRADIENT | 0 | 0
TAXRATE | 0 | 0.4
NPER | 24 | 24
PMT | -2000 | -2000
FV | 0 | 0
TYPE | 0 | 0
GTYPE | 0 | 0
COMPOUNDING
PERIOD
[NAME] | 1 | 1
tadPV
TADXL.com
Spreadsheet: 0dd949a8-9252-4e21-970c-c648751a5c39
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Time study sheet |  |  |  |  |  |  | Time study sheet
 | Date ______________________________ |  |  |  |  |  |  | Date ______________________________
 | Reason for visit ______________________ |  |  |  |  |  |  | Reason for visit ______________________
 | DVM ______________________________ |  |  |  |  |  |  | DVM ______________________________
 | TIME: |  |  |  |  |  |  | TIME:
 |  | [NAME] |  |  |  |  |  |  | [NAME]
 |  | Client in room |  |  |  |  |  |  | Client in room
 |  | Technician in room |  |  |  |  |  |  | Technician in room
 |  | DVM in room |  |  |  |  |  |  | DVM in room
 |  | Client to front |  |  |  |  |  |  | Client to front
 |  | Checked out |  |  |  |  |  |  | Checked out
 | NOTES: |  |  |  |  |  |  | NOTES:
PLEASE record every client visit for services (exam, vaccines, etc.) |  |  |  |  |  |  | PLEASE record every client visit for services (exam, vaccines, etc.)
Place completed slips in the black basket with TIME STUDY label. |  |  |  |  |  |  | Place completed slips in the black basket with TIME STUDY label.
 |  | THANKS |  |  |  |  |  |  | THANKS
Spreadsheet: 837508d1690210228-looking-for-information-with-a-formula-document-formula-example
Sheet: Test distribution per requireme

Requirement ID | Status
A-1
A-2
A-3
A-4
A-5
A-6
A-7
A-8
[NAME]
A-10
A-11
A-12
A-13
A-14
A-15
A-16
A-17
A-18
A-19
A-20
A-21
A-22
A-23
A-24
A-25
Spreadsheet: kate_symes__18260__Deal Correction 4-2
Sheet: 3-29

Date of Inquiry | Adjustment date | Date of applied calc | Deal Date | Desk Involved | Reason | Correction located by: | Broker | Change | Details of reason | Deal # | Delivery | Term | Hours p/op/rtc | MW | Price | Counterparty
 | 2001-03-29 00:00:00 | 2001-03-29 00:00:00 | 2001-03-28 00:00:00 | STSW | MF | Houston | TFS | Added .0075 broker fee |  | 563728 | [NAME] | Q3-01 | On [NAME] | 25 | 610 | Constellation
 | 2001-03-29 00:00:00 | 2001-03-29 00:00:00 | 2001-03-28 00:00:00 | STCA | CM | Houston | APB | Added late deals: EES sleeves |  | 564924-929 | NP-15 | Q2-02 | On [NAME] | 50 | 100-99.95/170-169.95 | EES/Allegheny/Mirant
 |  |  |  | Grand Count
Spreadsheet: 53841d1253777465-excel-2007-compare-3-columns-in-sheet-1-with-sheet-2-then-add-sheet-1-fourth-column-data-compare-3-columns
Sheet: Sheet1

COLUMN 1 | COLUMN 2 | COLUMN 3 | COLUMN 4
1005 | 10 | [NAME] | Royal Blue
1005 | 20 | [NAME] | Navy Blue
1006 | 50 | [NAME] | Rose
1100 | 40 | Sonam | Green
1156 | 80 | Rashmi | Pink
Spreadsheet: 05490745-546d-43e2-98f3-9b255be1bd28
Sheet: Sheet1

Federal Funding Compliance: Payroll Certification
Instructions: Where employees are expected to work solely on a single Federal award or cost objective, charges for their salaries and wages will be supported by periodic certifications that the employee worked solely on that program for the period covered by the certification. The certifications will be prepared at least monthly and will be signed by the employee and supervisor having first-hand knowledge of the work performed by the employee (OMB Circular [NAME] for Non-profit LEAs-most charters).
Charter:
Employee Name:
Employee Title:
Fiscal Year:
I, |  |  |  |  |  | , certify that
 | (Employee Name)
100% of my work time from |  |  |  |  |  | to
 | (Beginning Date ex. Month/Date/Year)
 |  | was spent on
(Ending Date ex. Month/Date/Year)
 |  |  | duties and responsibilities.
(Federal Funding Source/Grant)
Employee Signature:
Date:
[NAME]'s Signature:
Date:
Spreadsheet: 119764d1314722965-conditional-formatting-with-multiple-calculations-project-control
Sheet: Working Sheet

Pre-Activity Schedule
Due Date | Group 1 | Group 2 | Group 3 | Group 4 | Group 5 | Task Coding
2011-08-01 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2011-08-02 00:00:00 | [NAME] | Wilson | Anna | Periera | Fransesca
2011-08-03 00:00:00 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Submission Dates
Due Date | Group 1 | Group 2 | Group 3 | Group 4 | Group 5 | Task Coding
2011-08-01 00:00:00 | 2011-08-01 00:00:00 | 2011-08-01 00:00:00 | 2011-08-01 00:00:00 | 2011-08-01 00:00:00 | 2011-08-01 00:00:00
2011-08-02 00:00:00 | 2011-08-01 00:00:00 | 2011-08-03 00:00:00 | 2011-08-03 00:00:00 | 2011-08-02 00:00:00 | 2011-08-02 00:00:00
2011-08-03 00:00:00 | 2011-08-03 00:00:00 | 2011-08-03 00:00:00 | 2011-08-04 00:00:00 | 2011-08-06 00:00:00 | 2011-08-09 00:00:00
Color coding based on Submission Dates
Due Date | Group 1 | Group 2 | Group 3 | Group 4 | Group 5 | Task Coding
2011-08-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | In Time
2011-08-02 00:00:00 | -1 | 1 | 1 | 0 | 0 | Tolerable
2011-08-03 00:00:00 | 0 | 0 | 1 | 3 | 6 | Inordinate
Spreadsheet: 152167d1335276586-basic-conditional-formatting-ga-exp-savings-week-of-4-8-11
Sheet: GA CUSTOMERS

 | [NAME] | VENDOR | PARTS/ EQUIPMENT | BILLS DUE | PARTS                   (Marked up 12%) | LABOR  LOGGED | BALANCE IN  SAVINGS | TRANSFER FROM SAVINGS | BALANCE  AFTER TRANSFER
1 | BILLINGS FLYING SERV |  |  | TOTALS |  |  | 17.5
2 | ROB BLAKE |  |  | TOTALS |  |  | 27932.5
3 | [NAME] |  |  | TOTALS |  |  | 1000
4 | [NAME] |  |  | TOTALS |  |  | 1000
5 | CENTURY CONST |  |  | TOTALS |  |  | 3135.31
6 | [NAME] |  |  | TOTALS |  |  | 879.95
7 | DALLA AERO |  |  | TOTALS |  |  | 14887.5
8 | BRICK LORING |  |  | TOTALS |  |  | 0
9 | DAN PORTER |  |  | TOTALS |  |  | 25000
10 | STEPPLER RANCH |  |  | TOTALS |  |  | 1635.17
11 | [NAME] |  |  | TOTALS |  |  | 875.12
12 | TAYLOR AG |  |  | TOTALS |  |  | 3000
13 |  |  |  | TOTALS
Spreadsheet: 134662d1325558091-how-to-associate-cell-contents-with-other-cells-sample2
Sheet: Sheet1

ID | Group | Starting Date | Date | Number of days | Species | Tank | Collected | N | P | SE | SL | Nu | Pu | SEu | SLu | Notes
SB1 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 1 | 2011-05-12 00:00:00 | 150 | 2 | 3 | 4
SB10 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 4 | 2011-05-12 00:00:00 | 210 |  | 3 | 4
SB11 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 2 | 2011-05-12 00:00:00 | 185 |  | 3 | 4
SB12 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 4 | 2011-05-12 00:00:00 | 140 |  | 1 | 1
[NAME] | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 3 | 2011-05-12 00:00:00 | 130 |  | 4 | 5
[NAME] | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 3 | 2011-05-12 00:00:00 | 230 |  | 1 | 2
SB15 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 3 | 2011-05-12 00:00:00 | 260 |  | 3 | 4
SB16 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 2 | 2011-05-12 00:00:00 | 120 |  | 7 | 7
SB17 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 2 | 2011-05-12 00:00:00 | 120 |  | 4 | 5
SB18 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 1 | 2011-05-12 00:00:00 | 160 |  | 7 | 7
SB19 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 5 | 2011-05-12 00:00:00 | 170 |  | 2 | 2
SB2 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 6 | 2011-05-12 00:00:00 | 210 | 1 | 1 | 1
SB20 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 8 | 2011-05-12 00:00:00 | 85 |  | 1 | 2
SB21 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 7 | 2011-05-12 00:00:00 | 55 |  | 1 | 2
SB22 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 7 | 2011-05-12 00:00:00 | 120 |  | 3 | 4
SB23 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 8 | 2011-05-12 00:00:00 | 150 |  | 3 | 4
SB24 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 6 | 2011-05-12 00:00:00 | 165 |  | 1 | 2
SB25 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 6 | 2011-05-12 00:00:00 | 70 |  | 1 | 2
SB26 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 3 | 2011-05-12 00:00:00 | 120 |  | 3 | 4
SB27 | SB | 2011-01-01 00:00:00 | 2011-06-12 00:00:00 |  | U | 1 | 2011-05-12 00:00:00 | 145 |  | 1 | 1
SB12 | SB |  | 2011-12-12 00:00:00 |  | U | 8 | 2011-05-12 00:00:00 |  |  |  |  |  | 15 | 4 | 4
[NAME] | SB |  | 2011-12-12 00:00:00 |  | U | 8 | 2011-05-12 00:00:00 |  |  |  |  |  | 30 | 4 | 4
SB19 | SB |  | 2011-12-12 00:00:00 |  | U | 7 | 2011-05-12 00:00:00 |  |  |  |  |  | 40 | 4 | 4
SB2 | SB |  | 2011-12-12 00:00:00 |  | U | 8 | 2011-05-12 00:00:00 |  |  |  |  |  | 40 | 4 | 4
SB20 | SB |  | 2011-12-12 00:00:00 |  | U | 7 | 2011-05-12 00:00:00 |  |  |  |  | 85 | 60 | 4 | 4
SB21 | SB |  | 2011-12-12 00:00:00 |  | U | 7 | 2011-05-12 00:00:00 |  |  |  |  |  | 55 | 4 | 5
SB24 | SB |  | 2011-12-12 00:00:00 |  | U | 6 | 2011-05-12 00:00:00 |  |  |  |  |  | 15 | 4 | 5
SB25 | SB |  | 2011-12-12 00:00:00 |  | U | 6 | 2011-05-12 00:00:00 |  |  |  |  |  | 15 | 4 | 5
SB27 | SB |  | 2011-12-12 00:00:00 |  | U | 6 | 2011-05-12 00:00:00 |  |  |  |  |  | 5 | 4 | 4
Spreadsheet: 783162d1654619192-if-or-then-formula-driving-me-nuts-sample1_andor
Sheet: Blad1

 |  |  |  | D with A | D with A OR B OR C
1 |  |  | 3 |  |  | <should be no match?
 | 2 |  | 2 |  |  | <should be match?
 |  | 3 | 1
2 |  |  | 2
 |  | 3 | 3
Dutch | English
Als | If
Of | Or
Spreadsheet: 152267d1335318853-excel-2007-index-across-multiple-sheets-in-workbook-example
Sheet: CentralCoast

DATE:
BAY | ROUTE | [NAME] | CASES | [NAME] |  | ADJ | STOPS | CASE PICKER | Total | Start | Stop | Adj | T-TIME | BOTTLE PICKER | [NAME] | START | STOP | ADJ | T-TIME | CASE PICKER PRECENT |  |  |  | BOTTLE PICKER PERCENT
Spreadsheet: 488822d1478849895-formula-to-consolidate-results-category-calculator
Sheet: Sheet1

Batteries
Bodykits & Styling
Brakes
Cooling
Cylinder Head & Valvetrain
Drivetrain
Electronics
Engine Components
Engine Management & ECU
Exhaust Systems
Forced Induction
[NAME]
Handling
Ignition
Intake Systems
Interior
Magazines
Mechanic Tools & Adhesives
Merchandise
Race Apparels
Safety
Wheels
Spreadsheet: 705814d1606317020-else-if-function-not-working-tableau_dpa
Sheet: 20XX

Langue | Anglais |  | Type de Document | T776
1 | 2 | 3 | 4 | 5 | 6* | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  | Notes
 |  |  |  |  | Total de la DPA pour l'année : Total de la colonne 12 (inscrivez la ligne 9936 de la partie 4 le montant  i moins toute partie personnel et toute DPA pour les frais d'utilisation [NAME] résidence aux fins de l'entreprise**) |  |  |  |  |  |  | i
1 | 2 |  |  |  | 3 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  | =SI($B$1="Français"; SI(ET($E$1="T776";  "x"; SI(ET($E$1="T777";  "x"; SI(ET($E$1="T2125";  "x";)))))); SI(ET($E$1="T776";  "x"; SI(ET($E$1="T777";  "x"; SI(ET($E$1="T2125";"x")))))))
1 | 2 |  |  |  | 3 | 4 | 5
1 | 2 |  |  |  | 3 | 4 | 5
1 | 2 |  |  |  | 3 | 4 | 5
NOTES