tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 474958d1470988809-two-drop-down-menus-for-the-one-table-and-graph-sample-data2
Sheet: Sheet2

 | Week | Item A Sales | Item B Sales | Item C Sales | Item D Sales
Adam | 1 | 26 | 12 | 26 | 12
Brett | 1 | 23 | 29 | 12 | 10
Cameron | 1 | 28 | 13 | 27 | 11
[NAME] | 1 | 28 | 25 | 18 | 16
[NAME] | 1 | 15 | 27 | 26 | 13
[NAME] | 1 | 26 | 27 | 20 | 24
Greg | 1 | 14 | 23 | 20 | 28
Adam | 2 | 16 | 22 | 10 | 16
Brett | 2 | 28 | 16 | 24 | 23
Cameron | 2 | 13 | 19 | 20 | 12
[NAME] | 2 | 23 | 26 | 12 | 30
[NAME] | 2 | 24 | 17 | 23 | 22
[NAME] | 2 | 18 | 14 | 15 | 20
Greg | 2 | 17 | 18 | 24 | 25
Adam | 3 | 29 | 14 | 18 | 27
Brett | 3 | 27 | 10 | 16 | 13
Cameron | 3 | 25 | 16 | 10 | 29
[NAME] | 3 | 20 | 20 | 23 | 15
[NAME] | 3 | 26 | 17 | 15 | 27
[NAME] | 3 | 19 | 29 | 28 | 26
Greg | 3 | 25 | 29 | 17 | 30
Adam | 4 | 28 | 12 | 28 | 13
Brett | 4 | 11 | 22 | 15 | 28
Cameron | 4 | 13 | 10 | 22 | 14
[NAME] | 4 | 22 | 16 | 25 | 10
[NAME] | 4 | 13 | 11 | 19 | 22
[NAME] | 4 | 21 | 30 | 23 | 18
Greg | 4 | 22 | 24 | 29 | 17
Adam | 5 | 30 | 15 | 16 | 10
Brett | 5 | 10 | 11 | 14 | 24
Cameron | 5 | 20 | 29 | 14 | 21
[NAME] | 5 | 16 | 21 | 24 | 11
[NAME] | 5 | 29 | 24 | 24 | 28
[NAME] | 5 | 23 | 21 | 18 | 10
Greg | 5 | 18 | 19 | 14 | 20
Spreadsheet: 740056d1626168784-avoid-circular-reference-in-lookup-example
Sheet: Sheet1

Date | ID | Received? |  | Desire result: if any ID is received for a given date, then mark them all as YES
2021-07-02 00:00:00 | 1 |  |  | YES
2021-07-02 00:00:00 | 2 |  |  | YES
2021-07-02 00:00:00 | 3 |  |  | YES
2021-07-02 00:00:00 | 4 |  |  | YES
2021-07-02 00:00:00 | 5 |  |  | YES
2021-07-02 00:00:00 | 6 |  |  | YES
2021-07-02 00:00:00 | 7 |  |  | YES
2021-07-02 00:00:00 | 8 |  |  | YES
2021-07-02 00:00:00 | 9 |  |  | YES
2021-07-09 00:00:00 | 1 |  |  | YES
2021-07-09 00:00:00 | 2 |  |  | YES
2021-07-09 00:00:00 | 3 |  |  | YES
2021-07-09 00:00:00 | 4 |  |  | YES
2021-07-09 00:00:00 | 5 |  |  | YES
2021-07-09 00:00:00 | 6 |  |  | YES
2021-07-09 00:00:00 | 7 |  |  | YES
2021-07-09 00:00:00 | 8 |  |  | YES
2021-07-09 00:00:00 | 9 |  |  | YES
2021-07-09 00:00:00 | 10 |  |  | YES
2021-07-09 00:00:00 | 11 |  |  | YES
Spreadsheet: 689580d1596529705-is-countif-the-correct-function-to-match-a-substring-in-a-range-to-a-selected-value-excelforum-1-
Sheet: OrderConf

 |  | ORDER CONFIRMATION
 | Attn:    Mr. |  |  |  | OC #: | 0685-2021-CF-034-A
 | Customer: |  |  |  | OC Date:
 | Address: |  |  |  | Your PO:
 | City: |  |  |  | Offer #:
 | Delivery: | Within May 2020 |  |  | YYY:
 | Dear Sirs
 | We refer to your mail dated XXX, for your requirement of XXX Fans. We are pleased to confirm your order as under. ……….
 | Itemcode | [NAME] | Description | Qty | Unit Price | Total | Column1
 |  |  |  |  | OC Total
Spreadsheet: 104914d1302362527-too-many-nested-if-book1_mohitspamz
Sheet: Sheet1

Test A1 | Test B1 | Test C1 |  |  |  |  |  |  |  |  |  |  |  | Test O1 |  |  |  | Test S1 | Test T1 | Test U1 |  | Test W1 |  |  |  |  |  |  |  |  |  | Test AG1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Test AU1 |  |  |  |  |  |  |  |  | Test BD1
Heres the deal,
If J7=1, Then IF C1<>””, True 1, False 0
0 |  |  |  |  | Change with Drop-Down > |  |  |  | 6
IF Not Then
IF J7=2, Then IF AG1<>””, True 1, False 0
0
IF Not Then
If J7=3, Then IF BD1<>””, True 1, False 0
0
If Not Then
If J7=4, Then IF AU1<>””, True 1, False 0
0
If Not Then
If [NAME], Then IF And (C1<>””,AG1<>””,BD1<>””,AU1<>””) True 1, False 0
0
If Not Then
If J7=6, Then If And (A1<>””, B1<>””), Check IF And(O1<>””, S1<>””) And Check if And (T1<>””,U1<>””) Or W1<>”” True 0 False 1
1
1 | 1 Gets Row Coloured and 0 makes row Uncoloured
Note
1 | 1
0 | 0
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: Origination

Marketing
[NAME] Rorscharch | Associate |  |  | 50000
[NAME] | Associate | 2 |  | 75000
[NAME] | Director
[NAME] | Director |  |  | 75000
[NAME] | Director
[NAME] | Director |  |  | 50000
[NAME] | Director |  |  | 75000
Edith Cross | Director
[NAME] | Director | 7
[NAME] | Director, Managing | 1
[NAME] | Manager |  |  | 75000
[NAME] | Manager |  |  | 50000
[NAME] | Manager | 3 |  | 20000
[NAME] | Vice President | 1 |  | 50000
 | TOTAL
Spreadsheet: rick_buy__32829__SS Participation
Sheet: nov. 15-18

Thursday 11/15 | Friday 11/16 | Saturday 11/17 | Sunday 11/18
Casino night 5pm-9pm: | Breakfast/speaker 8:45am-9:45am: | Tour 10am-5pm: | Brunch 10am-1pm:
[NAME] |  |  | Program staff
[NAME]
[NAME]  x37036
[NAME]x35684 | Lunch/speaker 11:30am-12:45pm:
[NAME]
Berney Aucion  x34784
[NAME]
[NAME] (London) | Interviews 1-4pm:
[NAME]  x36179 | [NAME]  x31667 2nd choice
[NAME]  x57424 | [NAME]
have 10 need 10 | [NAME]x31873
 | [NAME]
 | [NAME]
Any Dates: | [NAME]  x37036
[NAME] | [NAME]x35684
intv/dinner | [NAME]  x53311
[NAME] | [NAME]
[NAME] | Berney Aucion  x34784
[NAME] | [NAME]
[NAME]  x51688 | [NAME] (London)
[NAME]x34256 | [NAME]  x36179
[NAME] | [NAME]
[NAME]  x31915 | [NAME]  x57424
[NAME] | have 15 need 55
[NAME]  x30594
 | Dinner 6pm-9pm:
 | Current analyst
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]  x30359
 | [NAME]
Spreadsheet: sally_beck__34369__FallonDelaneyrpt
Sheet: Pearce

Retain - Pearce
GIS ID | Formatted Name | Company Name | Job Title | [NAME] | Level1 Full Name | Level2 [NAME] | Level3 [NAME] | Level4 [NAME] | Company | BU Supported: EGM, EIM, EBS, EES or ENA
90137723 | MIRALLES, [NAME] | ENRON NET WORKS LLC(CNEN) | DIR COMM TRADING SUPT | ALBRECHT, KRISTIN W | WHALLEY, [NAME] | PIPER, GREGORY | BECK, SALLY | APOLLO, BETH | Estate
90128759 | PEARCE, BARRY J | ENRON NET WORKS LLC(CNEN) | VP COMM TRADING SUPT | BECK, [NAME] | WHALLEY, [NAME] | PIPER, GREGORY | BECK, SALLY | PEARCE, [NAME] | Estate
90005889 | UMBOWER, DENAE L | ENRON NET WORKS LLC(CNEN) | MGR COMM TRADING SUPT | PEARCE, BARRY J | WHALLEY, [NAME] | PIPER, GREGORY | BECK, SALLY | PEARCE, [NAME] | Estate
 |  |  |  | 3
Spreadsheet: darrell_schoolcraft__7314__imball0202
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -5330
9238 |  | -3000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 |  | -289318
58710 |  | -243
60921 |  | -281438
78026 |  | 1650
500084 |  | -9000
500085 | -144
500097 | -13101 | -12000
INDEX
2002-01-31 00:00:00 |  |  | 805169.68
2002-02-03 00:00:00
CBS Volume
 |  |  | 325714
Spreadsheet: 0a4e0ceb-2dad-4070-9e60-ea53d0c2fcb7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Rose Moving & Storage Wayne Cty |  | Corrigan Moving Systems Wash Cty |  | Premier-Relocations, Inc. [NAME]
Daytime Mover/Helper M-F per hr | 32 |  | 30.5 |  | 32
Sample Job A Total | 96 |  | 309 |  | 320
Sample Job B Total | 423 |  | 296.25 |  | 348
 | As read at bid opening
Spreadsheet: 644877d1570792500-freight-cost-calculation-based-on-weight-and-distance-sample-freight-analysis_2
Sheet: Input &required output

OID | Quote_Weight | Distance (In Miles) | Cost -output required without fuel surcharge | Cost Output -with fuel surcharge
3634 | 138 | 74.666448
3676 | 368 | 1052.471069
3718 | 270 | 732.056664
3760 | 213 | 279.1653
3802 | 100 | 1512
3886 | 348 | 2142.846402
3928 | 333 | 437.544117
Spreadsheet: 865803d1712784643-left-instruction-has-left-sense-behind-left-weird-numbers
Sheet: Sheet1

Sub ListAllFile()
Dim objFSO As Object
Dim objFolder As Object
Dim objFile As Object
Dim ws As Worksheet
Dim sPath As String
Dim lrA As Long
Dim lrB As Long
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set ws = Worksheets.Add
'Get the folder object associated with the directory
sPath = InputBox("What is the full Path to Search?")
Set objFolder = objFSO.GetFolder(sPath)
ws.Cells(1, 1).Value = "The files found in " & objFolder.Name & " are:"
ws.Cells(1, 2).Value = "The files found have modified dates:"
ws.Cells(1, 3).Value = "The file [NAME] is:"
'Loop through the [NAME] collection
For Each objFile In objFolder.Files
'If objFile.Name Like "*.pdf" Then
lrA = Range("A" & Rows.Count).End(xlUp).Row
lrB = Range("B" & Rows.Count).End(xlUp).Row
ws.Range("A" & lrA + 1).Value = objFile.Name
ws.Range("B" & lrB + 1).Value = objFile.DateLastModified
ws.Range("C" & lrB + 1).Value = objFile.Size
'End If
Next
'ws.Cells(2, 1).Delete
'Clean up!
Set objFolder = Nothing
Set objFile = Nothing
Set objFSO = Nothing
End Sub
Spreadsheet: 879300d1726764361-unalbe-to-get-dates-and-times-to-convert-and-cant-combine-columns-a-and-b-date-and-time-etc
Sheet: Sheet1

AGENCY | CASE # | OCCU DATE/TIME | RPT DATE/TIME | UCR CODE
FMO | 190900002 | 2019-09-01 23:25:00 | 2019-09-01 23:25:00 | 200
FMO | 190900003 | 2019-09-01 23:58:00 | 2019-09-01 23:59:00 | 200
FMO | 190900001 | 2019-09-01 13:34:00 | 2019-09-01 13:35:00 | 200
FMO | 200700014 | 2020-07-05 18:35:00 | 2020-07-05 18:36:00 | 200
HCC1 | 200200524 | 2019-05-23 08:00:00 | 2020-02-28 11:51:00 | 720
HCC1 | 200500155 | 2020-05-10 18:00:00 | 2020-05-11 20:04:00 | 13B
HCC1 | 210400271 | 2021-04-15 00:00:00 | 2021-04-15 14:49:00 | 23F
Spreadsheet: 747829d1631716509-pulling-percentage-values-between-sheets-and-identifying-name-fields-client-wise-division
Sheet: Sheet1

Name | Client 1 | Client 2 | Client 3 | Total
RIMA
NAFIZ
MANAV
MAY
[NAME]
DIVYESH
RITA
SHADIL
[NAME]
SABARI
TAHIR
[NAME]
GEOFF
SAVIO
EMMA
[NAME]
ENRICO
[NAME]
TINA
WAJD
ROMAIL
PRASHANT
SHAHRYAR
MAYSA
ALI DARWICH
UDAY
SIMRAN
SHAHZEB
HUSAM
ADITI
ZAMAN
APRIL
PRIYAL
RAJIT
PRIYAA
Spreadsheet: 831908d1685983196-formula-issue-retreiving-data-from-one-sheet-to-the-other-with-same-identifiers-book3-excel-help-aligw
Sheet: Sheet2

Place | Name | ID |  | Division |  | ID2 | ID3 | ID4 | CODE 1 | CODE 2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | A | A1
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | A | A1
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | A | A2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | A | A2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | A | A3
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B1
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B1
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B1
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B1
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B1
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | B | B2
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | A | A4
X | [NAME], [NAME] | 1 |  | 5 |  | 2 | 3 | 4 | A | A4
Spreadsheet: 087f5f52-1934-4cf7-bfe4-7cd2ec41423f
Sheet: Sheet1

Regulations Committee | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
First Name | Last Name | BusInstitution | RegsOffice | RegsRepresents | RegsOrigDate | RegsBegCurTerm | RegsEndCurTerm | RegsTerm
[NAME] | Wiens | [NAME] | Vice Chair | Classroom Teachers | 07-01-06 | 07-01-11 | 06-30-14 | 2nd Full Term
[NAME] | Bulk | Atchison Elementary |  | Classroom Teachers | 06-09-09 | 07-01-12 | 06-30-15 | 2nd Full Term
[NAME] | Gross | Junction City High School |  | AVTS Educators | 06-09-09 | 07-01-12 | 06-30-15 | 2nd Full Term
[NAME] | Hogan | Ottawa University |  | Higher Education | 07-01-08 | 07-01-11 | 06-30-14 | 2nd Full Term
Marlysue | Holmquist | Bethany College |  | Higher Education | 05-30-13 | 07-01-13 | 06-30-16 | 1st Full Term
Royce | [NAME] | [NAME] |  | School Administrators | 05-30-13 | 07-01-13 | 06-30-16 | 1st Full Term
Kathi | Sanders | Fort Hays State University |  | Higher Education | 06-11-12 | 07-01-12 | 06-30-15 | 1st Full Term
[NAME] | Shepherd-Adams | Hays High School |  | Classroom Teachers | 11-14-11 | 07-01-12 | 06-30-15 | 1st Full Term
Vacant | Vacant |  |  | School Administrators
Vacant | Vacant |  |  | School Administrators, PSB Rep
2013-07-01 00:00:00
Spreadsheet: 205912d1357933378-count-of-employees-at-any-given-time-count-of-employees-at-any-given-time-nickmessick1-oeldere-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | How Many Workers Total Between Hours
GROUP | Supervisors | Employees | Date Start | Time Start | Date End | Time End
1 | 2 | 10 | 2013-01-11 00:00:00 | 14:00:00 | 2013-01-12 00:00:00 | 00:00:00 |  |  | Between | Date: |  |  | Supervisors | Employees
2 | 1 | 9 | 2013-01-11 00:00:00 | 22:30:00 | 2013-01-12 00:00:00 | 08:30:00 |  |  |  | Time:
3 | 2 | 10 | 2013-01-12 00:00:00 | 07:00:00 | 2013-01-12 00:00:00 | 17:00:00 |  |  | And | Date:
4 | 1 | 6 | 2013-01-12 00:00:00 | 13:15:00 | 2013-01-12 00:00:00 | 23:15:00 |  |  |  | Time:
 |  |  |  |  |  |  |  |  | 2013-01-11 00:00:00 | Supervisors | Employees | TOTAL
 |  |  |  |  |  |  |  |  | 00:00:00
 |  |  |  |  |  |  |  |  | 01:00:00
 |  |  |  |  |  |  |  |  | 02:00:00
 |  |  |  |  |  |  |  |  | 03:00:00
 |  |  |  |  |  |  |  |  | 04:00:00
 |  |  |  |  |  |  |  |  | 05:00:00
 |  |  |  |  |  |  |  |  | 06:00:00
 |  |  |  |  |  |  |  |  | 07:00:00
 |  |  |  |  |  |  |  |  | 08:00:00
 |  |  |  |  |  |  |  |  | 09:00:00
 |  |  |  |  |  |  |  |  | 10:00:00
 |  |  |  |  |  |  |  |  | 11:00:00
 |  |  |  |  |  |  |  |  | 12:00:00
 |  |  |  |  |  |  |  |  | 13:00:00
 |  |  |  |  |  |  |  |  | 14:00:00
 |  |  |  |  |  |  |  |  | 15:00:00
 |  |  |  |  |  |  |  |  | 16:00:00
 |  |  |  |  |  |  |  |  | 17:00:00
 |  |  |  |  |  |  |  |  | 18:00:00
 |  |  |  |  |  |  |  |  | 19:00:00
 |  |  |  |  |  |  |  |  | 20:00:00
 |  |  |  |  |  |  |  |  | 21:00:00
 |  |  |  |  |  |  |  |  | 22:00:00
 |  |  |  |  |  |  |  |  | 23:00:00
Spreadsheet: 270674d1381583734-sumif-advanced-30-daysforum
Sheet: Data

Payment |  |  | Suppliers |  |  | Overheads & Expenses |  |  |  |  | Wages |  |  |  | Yes/No | Quote sent | Job Status
Method | Payment | Payment terms | Supplier | Payment terms |  | Expenses | Cost applicable to | Overheads | Category |  | Employees | Type |  |  | Return Sent | Sent | Open
Debit Card | Paid | 7 | KR Electrical | YES |  | Diesel | Company cost | Stationary | Expenses |  |  | Wages |  |  | Yes | Not Sent | Closed
Cheque | Unpaid | 14 | Edmundsons | NO |  | Parking | [NAME] | Furniture | Overheads |  |  | Dividends |  |  | No | Not required
Cash | N/A | 21 | WF | NO |  | Congestion | [NAME] | Liability insurance |  |  |  |  |  |  | N/A
Bank transfer |  | 30 | ADI | NO |  | Train/ toll charge | Sub-Contractor | Van Insurance
Personal account |  | NET30 | Plumbers merchants | NO |  | College/ training course |  | Van Road tax
Direct Debit |  | 60 | Minitran | YES |  | Postage |  | [NAME]
Standing Order |  | NET60 | Electrifix | NO |  | Penalty Charge/Fine |  | Van MOT/Service
BACS |  |  | [NAME] | NO |  | Tools |  | Van Purchase/Sale |  |  |  |  |  |  | Job costing
Other |  |  |  |  |  | Clothing |  | Website/Email/Software |  |  |  |  |  |  | Quotation
 |  |  |  |  |  | [NAME] credits |  | Office/Lock-up Rent |  |  |  |  |  |  | Agreed Job
 |  |  |  |  |  | Van |  | Electric
 |  |  |  |  |  | Hospitality |  | Internet
 |  |  |  |  |  |  |  | Telephone
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Trade membership fees
 |  |  |  |  |  |  |  | Accountancy costs
Spreadsheet: 39858d1238112099-inserting-a-line-on-my-reference-sheet-test-for-help
Sheet: Lookup Table

 | Banners/ Event Programs | Website | Newsletter | Flyers to Schools | Event Announcements | Food | VIP Booth Access | Entertainment Incentive | Recognition Plaque | Newspaper | Promotional Space | Raffle Tickets | Ride [NAME] | Recognition Street Banners | Est. Tax Ded. Amt.
Title | 3-ft x 10-ft Event Banner and [NAME] | Link on Web Site | Newsletter | Recognition in Flyers | 15-sec Stage Advertising | Comp food & beverage for 6 | VIP Booth Access | 12 VIP seats for ALL concerts | Recognition Plaque | Recognition in Newspaper | 20x20 Promotional Space | 100 Raffle Tickets | 4-Unlimited Ride Wrist Bands | Imperial Hwy Brea Blvd & more | 17808
Diamond | 3-ft x 10-ft Event Banner (or Event Program) | Link on Web Site | Newsletter | Recognition in Flyers | 15-sec Stage Advertising | Comp food & beverage for 6 | VIP Booth Access | 10 VIP seats for ALL concerts | Recognition Plaque | Recognition in Newspaper | 10x10 Promotional Space | 50 Raffle Tickets | 2-Unlimited Ride Wrist Bands |  | 4098
Platinum | 3-ft x 10-ft Event Banner (or Event Program) | Link on Web Site | Newsletter | Recognition in Flyers | 15-sec Stage Advertising | Comp food & beverage for 6 | VIP Booth Access |  | Recognition Plaque |  |  |  | 2-Unlimited Ride Wrist Bands |  | 2628
Corporate | 3-ft x 10-ft Event Banner (or Event Program) | Link on Web Site | Newsletter | Recognition in Flyers | 15-sec Stage Advertising | Comp food & beverage for 2 | VIP Booth Access |  | Recognition Plaque |  |  |  |  |  | 1366
Gold | 3-ft x 10-ft Event Banner (or Event Program) | Recognition on Web Site | Newsletter |  |  |  |  |  |  |  |  |  |  |  | 450
Cougar | [NAME] | Recognition on Web Site | Newsletter |  |  |  |  |  |  |  |  |  |  |  | 225
Spreadsheet: 116318d1311751495-excel-claim-sorting-claims-sorting-tracker-cst-1-1-
Sheet: Total

 |  |  | Claims Summery
Renewal Date Period |  | Starting Year | Five Years Period |  |  |  |  | Paid No of  Claims | Paid Total  Amount | Outstanding  No of Claims | Outstanding  Total Amount | Total Number of Claims | Total Amount
2011-08-01 00:00:00 | 2012-08-01 00:00:00 | 2011 | 2011-08-01 00:00:00 | 2011 | To | 2012-07-31 00:00:00 | 2012 | 1 | 15 | 0 | 0 | 1 | 15 |  |  |  |  | 2011-08-01 00:00:00 | 2012-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2010 | To | 2012-07-31 00:00:00 | 2011 | 2 | 6356 | 0 | 0 | 1 | 6356 |  |  |  |  | 2010-08-01 00:00:00 | 2011-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2009 | To | 2012-07-31 00:00:00 | 2010 | 1 | 15 | 1 | 500 | 2 | 515 |  |  |  |  | 2009-08-01 00:00:00 | 2010-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2008 | To | 2012-07-31 00:00:00 | 2009 | 0 | 0 | 0 | 0 | 2 | 0 |  |  |  |  | 2008-08-01 00:00:00 | 2009-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2007 | To | 2012-07-31 00:00:00 | 2008 | 1 | 200 | 1 | 100 | 0 | 300 |  |  |  |  | 2007-08-01 00:00:00 | 2008-07-31 00:00:00
 |  |  | 2011-08-01 00:00:00 | 2006 | To | 2012-07-31 00:00:00 | 2007 | 3 | 5200 | 1 | 50 | 2 | 5250 |  |  |  |  | 2006-08-01 00:00:00 | 2007-07-31 00:00:00
 |  |  | Total Summary |  |  |  |  | 8 | 11786 | 3 | 650 | 8 | 12436
 |  |  |  |  |  |  |  | Note: column D&E have similar formula
 |  |  |  |  |  |  |  | Note: column F&G have similar formula
 |  |  |  |  |  |  |  | Note: Range can be changed by replacing 43 in the formula with 100 or onward
Spreadsheet: 771887d1646907696-index-match-function-error-sample
Sheet: Sheet5

 |  |  | Anticipated INDIA CO  DELIVERY AND  UTILIZATION :JAN-Dec 2021
 |  |  | Office | Fund | Sum of PYOPA - Prior Year Outstanding Partner Advance  (1) | Sum of Budget (2) | Sum of KK Expenses (3) | Encumbrance  (4) | SAVINGS | Budget Balance [2-3-4-5] | D.R. % [3]/[1+2] | U.R. % [3+4+5]/[1] |  |  |  |  |  |  |  | Advances (5) | Budget Balance [2-3-4-5] | D.R. % [3]/[1+2] | U.R. % [3+4+5]/[1]
 |  |  | B0921    India | Core |  |  | 571226 | 93855 | 82900
 |  |  |  | Core Requirement |  | Core Savings
 |  |  |  | FLIGHT-Pradan | 27000 | Office Exp | 6500
 |  |  |  |  |  | Comms | 23400
 |  |  |  |  |  | M&E | 53000
 |  |  |  | Total
 |  |  |  | Funds blocked  for 16 days of  Activism
 |  |  |  | Comms | 7000
 |  |  |  | EVAW | 5000
 |  |  |  | MPTF | 53200
 |  |  |  | M&E-Susan's travel | 2000
 |  |  |  | Total
Spreadsheet: 718150d1613014504-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 16

 |  |  | Date | 2021-01-16 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 9:00:00 | 9:30:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 758686d1639000577-attendance-spreadsheet-assistance-employee-attendance-record-eba
Sheet: Calendar View

 | EMPLOYEE ATTENDANCE RECORD |  |  |  |  |  |  |  |  |  |  |  |  |  | Days on Leave |  |  |  |  | Working Days |  |  |  |  |  | Call out |  |  |  |  | Incomplete Shift |  |  |  |  | Tardy |  |  |  |  | Other
 | Select an Employee: | [NAME]
 | Enter Year:
 | Weekday/Month | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU  2 | FRI | SAT
 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 |  | Start Date |  | End Date |  | Type of Leave |  |  | Days |  | Roll Off Date |  |  | Level of PDA |  |  |  | Comments
 |  | 2021-12-11 00:00:00 |  | 2021-12-12 00:00:00 |  | Call out
 |  | 2021-12-12 00:00:00 |  | 2021-12-13 00:00:00 |  | Call out
 |  | 2021-12-13 00:00:00 |  | 2021-12-14 00:00:00 |  | Call out
 |  | 2021-12-14 00:00:00 |  | 2021-12-15 00:00:00 |  | Call out
 |  | 2021-12-15 00:00:00 |  | 2021-12-16 00:00:00 |  | Call out
 |  | 2021-12-16 00:00:00 |  | 2021-12-17 00:00:00 |  | Call out
 |  | 2021-12-17 00:00:00 |  | 2021-12-18 00:00:00 |  | Call out
 |  | 2021-12-18 00:00:00 |  | 2021-12-19 00:00:00 |  | Call out
 |  | 2021-12-19 00:00:00 |  | 2021-12-20 00:00:00 |  | Call out
 |  | 2021-12-20 00:00:00 |  | 2021-12-21 00:00:00 |  | Call out
 |  | 2021-12-21 00:00:00 |  | 2021-12-22 00:00:00 |  | Call out
 |  | 2021-12-22 00:00:00 |  | 2021-12-23 00:00:00 |  | Call out
 |  | 2021-12-23 00:00:00 |  | 2021-12-24 00:00:00 |  | Call out
 |  | 2021-12-24 00:00:00 |  | 2021-12-25 00:00:00 |  | Call out
 |  | 2021-12-25 00:00:00 |  | 2021-12-26 00:00:00 |  | Call out
 |  | 2021-12-26 00:00:00 |  | 2021-12-27 00:00:00 |  | Call out
 |  | 2021-12-27 00:00:00 |  | 2021-12-28 00:00:00 |  | Call out
 |  | 2021-12-28 00:00:00 |  | 2021-12-29 00:00:00 |  | Call out