tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 853995d1703953650-chatgpt-says-this-cant-be-done-without-vba-track-menstruation
Sheet: Sheet1

[NAME] | Menstruation Start | Menstruation End | Fertile Start | Ovulating | Fertile End | Menstruation Period | Fertility Period
 |  |  |  |  |  |  |  |  | Your most recent cycle start date |  | 2023-12-08 00:00:00
 |  |  |  |  |  |  |  |  | Your typical cycle length in days |  | 31
 |  |  |  |  |  |  |  |  | Days from period start until ovulation begins |  | 14
 |  |  |  |  |  |  |  |  | Typical menstruation days |  | 4
Spreadsheet: 823113d1679715637-summarizing-a-workbook-lego-replacement-parts
Sheet: Set # 8942

Checked | Qty | Part# | Colour | Description
 | 4 | 4120017 | Black | Technic, Liftarm, [NAME] x 4
 | 2 | 4211865 | Light Grey | Technic, Pin 3L with Friction Ridges and [NAME]
 | 4 | 4124108 | Trans Orange | Bar 4L (Lightsaber Blade / Wand)
 | 1 | 4210655 | [NAME] | Technic, [NAME] and Pin Connector Perpendicular Double
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 129260 | 129182
2 | 126748 | 122113
3 | 123158 | 122442
4 | 107561 | 106472
5 | 111357 | 111062
6 | 113863 | 113152
7 | 89887 | 128168
8 | 120044 | 119268
9 | 117369 | 115843
10 | 103180 | 98992
11 | 108603 | 107939
12 | 111233 | 110704
13 | 119896 | 119795
14 | 112667 | 112310
15 | 108935 | 108429
16 | 107432 | 107294
17 | 108973 | 108429
18 | 105972 | 105750
19 | 106485 | 106082
20 | 97063 | 94980
21 | 91009 | 90233
22 | 120835 | 120080
23 | 119482 | 118456
24 | 116376 | 114885
25 | 127730 | 128419
26 | 137820 | 139153
27 | 125177 | 125597
28
29
30
31
2001-07-31 00:00:00 |  |  | -36642
2001-08-27 00:00:00
CBS Volume
 |  |  | -14958
Spreadsheet: 185837d1349860199-display-data-using-a-criteria-0a1_fot_loan-database-sample
Sheet: Database

User Name | Contact no. | Department | Notebook Model | Serial | Qty | Accessories |  |  |  |  | Date of Issue | Expected Date of Return | Date of Return | Issued By | Remarks: | Ticket No.
 |  |  |  |  |  | [NAME] | [NAME] | Bag | Battery | Others
[NAME] | 2356425 | HR | Dell E6220 | [NAME] | 1 | 1 | 0 | 0 | 1 | 0 | 2012-10-10 00:00:00 | 2012-10-12 00:00:00 | 2012-10-10 00:00:00 | IT
[NAME] | 2356425 | FND | Dell E6220 | SGH23420Y2 | 1 | 1 | 0 | 0 | 1 | 0 | 2012-10-09 00:00:00 | 2012-10-13 00:00:00 |  | IT
[NAME] | 2356425 | ITD | Dell E6320 | SGH23420Y3 | 1 | 1 | 0 | 0 | 1 | 0 | 2012-10-10 00:00:00 | 2012-10-13 00:00:00 |  | IT
[NAME] | 2356425 | HR | Dell E6220 | SGH23420Y4 | 1 | 1 | 0 | 0 | 1 | 0 | 2012-10-10 00:00:00 | 2012-10-12 00:00:00 |  | IT
[NAME] | 2356425 | HR | Dell E6320 | SGH23420Y5 | 1 | 1 | 0 | 0 | 1 | 0 | 2012-10-10 00:00:00 | 2012-10-12 00:00:00 | 2012-10-10 00:00:00 | IT
[NAME] | 2356425 | ITD | Dell E6220 | SGH23420Y6 | 1 | 1 | 0 | 0 | 1 | 0 | 2012-10-09 00:00:00 | 2012-10-13 00:00:00 |  | IT
[NAME] | 2356425 | FND | Dell E6320 | SGH23420Y7 | 1 | 1 | 0 | 0 | 1 | 0 | 2012-10-09 00:00:00 | 2012-10-13 00:00:00 |  | IT
[NAME] | 2356425 | ITD | Dell E6320 | SGH23420Y8 | 1 | 1 | 0 | 0 | 1 | 0 | 2012-10-09 00:00:00 | 2012-10-13 00:00:00 | 2012-10-13 00:00:00 | IT
Spreadsheet: 860756d1708734737-want-a-drop-down-menu-to-format-group-of-cells-from-a-reference-sheet-formatting-help
Sheet: 2

AREA SERVED |  |  |  |  | DESIGN |  |  | PRE | FINAL |  |  | NOTE | % of Design
 |  | NO. | TYPE | SIZE
 |  | 1 | CD | 12 | NA | NA
 |  | 2 | CD | 12 | NA | NA
 |  | 3 | CD | 12 | NA | NA
 |  | 4 | CD | 12 | NA | NA
 |  | TOTAL | - | -
REMARKS:
Spreadsheet: 37529d1235567549-speed-optimization-timer
Sheet: Sheet2

 |  | Average Time | Improvement | Calculation | [NAME]
 | Formula 1 | 0.1046883159986464 | 0 | 278
 | Formula 2 | 0.09366722399718128 | 0.1052752821203815 | 278
 | Formula 3 | 0.08139189599896782 | 0.2225312326160622 | 278
 | Formula 4 | 0.07139488400134723 | 0.318024334231622 | 278
 | Formula 5 | 0.06009577200020431 | 0.4259553090816618 | 278
 | Iterations | 1000
 | Data 1 | 5
 | Data 2 | 74.13333333333334
 | Data 3
 | Data 4
 | Data 5
 | Data 6
 | Data 7
 | Data 8
 | Data 9
 | Data 10
 | Data 11
 | Data 12
Spreadsheet: 185374d1349683466-if-between-2-dates-book2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00
Our Ref | Account Code | Transaction D | GL Code | GBP Total Base | Currency | Net Total | Total | From | To | From & To | Months | Per Month | Month Start |  | Middle Month | Month End | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | 29/02/2012 |  | 45000 | £ |  | 45000 | 2012-03-01 00:00:00 | 31/05/2012 | 91 | 3 | 15000 | 69 | -64 | 0 | 05 |  |  |  |  |  | 0 | 0 | 0
Spreadsheet: 128636d1321129929-vlookup-in-different-coumns-hooves-world-racing-syndicate-updated
Sheet: Sheet4

GROUP MEMBERS
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Anne-Rita le Riche | Anne-Rita le Riche
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Carola Larsson | Carola Larsson
[NAME] | [NAME]
Chezza Goodgirl | Chezza Goodgirl
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Dante Love Dancel Lara | Dante Love Dancel Lara
[NAME] | MICK [NAME]
Deb Mclean | Deb Mclean
[NAME] | [NAME]
Doreen Laws Hart | Doreen Laws Hart
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
J T Patryck Voie | J T Patryck Voie
[NAME] | [NAME]
[NAME] | [NAME]
Jane-Marie Nash | Jane-Marie Nash
[NAME] | [NAME]
[NAME] | [NAME]
Jen Rayoso | Jen Rayoso
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME] [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] Condely | [NAME] Condely
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
Spreadsheet: 79a86955-e311-4ef4-992b-6e0065ec1634
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | U.S. Census Bureau
 |  | Source: Quarterly Financial Report
 |  | All Manufacturing: U.S. Total
 |  | Not Seasonally Adjusted Net Sales, Receipts, and Operating Revenues [Millions of Dollars]
 |  | Period: 2000 to 2013
 |  | Data Extracted on: December 7, 2013 (1:44 pm)
Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter
2000 |  |  |  | 1128790
2001 | 1082233 | 1116597 | 1062443 | 1033734
2002 | 994073 | 1071574 | 1068667 | 1082128
2003 | 1072017 | 1096910 | 1109436 | 1118800
2004 | 1145872 | 1248717 | 1250976 | 1288495
2005 | 1258442 | 1352179 | 1384246 | 1416600
2006 | 1397414 | 1485624 | 1467143 | 1432485
2007 | 1405836 | 1526484 | 1539399 | 1588312
2008 | 1566418 | 1724172 | 1682270 | 1401261
2009 | 1196693 | 1253821 | 1305867 | 1353446
2010 | 1349210 | 1461717 | 1463507 | 1481530
2011 | 1532484 | 1657405 | 1650561 | 1645072
2012 | 1648177 | 1689523 | 1656860 | 1673210
2013 | 1625739 | 1704288
Spreadsheet: 15cb473c-2938-4394-b90f-388df51e30cb
Sheet: MN Institution Contact Info

To obtain more detailed program and contact information, visit the general website, then locate links to the Education Department.
College/Institution | Location | Telephone Number | Website address
Augsburg College | Minneapolis, MN 55454 | [PHONE] | visit www.augsburg.edu
Bemidji State University | Bemidji, MN 56601 | [PHONE] | visit www.bemidjistate.edu
Bethel University | St. Paul, MN 55112 | [PHONE] | Visit www.bethel.edu
Capella University | Minneapolis, MN 55402 | [PHONE] | visit www.capella.edu
Concordia University - St. Paul | St. Paul, MN 55104 | [PHONE] | visit www.csp.edu
Hamline University | St. Paul, MN 55104 | [PHONE] | visit www.hamline.edu
Minnesota State University, Mankato | Mankato, MN 56002 | [PHONE] | visit www.mnsu.edu
Minnesota State University, Moorhead | Moorhead, MN 56563 | [PHONE] | visit www.mnstate.edu
Southwest Minnesota State University | [NAME], MN 56258 | [PHONE] | visit www.smsu.edu
St. Cloud State University | St. Cloud, MN 56301 | [PHONE] | visit www.stcloudstate.edu
[NAME] University | Winona, MN 55987 | [PHONE] | visit www.smumn.edu
University of St. Thomas | St. Paul, MN 55403 | [PHONE] | visit www.stthomas.edu
University of Minnesota - Duluth | Duluth, MN 55812 | [PHONE] | visit www.d.umn.edu
University of Minnesota - Twin Cities | Minneapolis, MN 55455 | [PHONE] | visit www1.umn.edu
Walden University | Minneapolis, MN 55401 | [PHONE] | visit www.waldenu.edu
Winona State University | Winona, MN 55987 | [PHONE] | visit www.winona.edu
Spreadsheet: 874827d1721333435-add-birth-year-to-a-duplicate-username-proctor-spreadsheet
Sheet: Sheet1

Original Table
Date | Student | Birthdate | Mother's Maiden Name | Last Name | Birth Year | Birthdate 2 | Username | [NAME] | [NAME] | CNA Class Completion Date (or Date of DHW Letter) | Full Name of Instructor or DHW or TRNS | Initial to Verify: Passed Skills Test | Initial to Verify: Correct Personal Info & Paid Test | Attempt No. | Type (Electronic or Oral) | Date of Test | Time of Test | Proctor | P/F | Notes |  | Cell | [NAME]
 | Corrie [NAME] | 1974-09-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last Name | IF(ISERROR(FIND(" ",B2)),"",IF(ISERROR(FIND(" ",RIGHT(B2,LEN(B2)-FIND(" ",B2)))),RIGHT(B2,LEN(B2)-FIND(" ",B2)),RIGHT(B2,LEN(B2)-FIND(" ",B2,FIND(" ",B2)+1))))
 | Corrie Kash | 1950-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Birth Year | YEAR([@Birthdate])
 | [NAME] | 1949-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Birthdate 2 | TEXT(C2, "mmddyyyy")
 | [NAME] | 1951-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Username | LOWER(LEFT(B2,1)&"."&LEFT(E2,4))&[@[Birth Year]]
 | [NAME] | 1952-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | H2&SUBSTITUTE(CHAR(64+COUNTIF(H$2:H2,H2)),"A","")
 | [NAME] | 1960-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | LOWER(LEFT(B2,1))&[@[Birthdate 2]]&UPPER(LEFT([@[Last Name]],1))&"*"
 | Carly Kash | 1970-01-01 00:00:00
 | [NAME] | 1980-01-01 00:00:00
 | [NAME] | 1979-08-24 00:00:00
 | [NAME] | 1979-08-24 00:00:00
 | [NAME] | 1978-08-25 00:00:00
New Table - adding a dot in the username and hoping to use the birth year instead of a letter for duplicates
Date | Student | Birthdate | Mother's Maiden Name | Last Name | Birth Year | Birthdate 2 | Username | [NAME] | [NAME]
 | Corrie Kash | 1950-01-01 00:00:00
 | [NAME] | 1949-01-01 00:00:00
 | [NAME] | 1951-01-01 00:00:00
 | [NAME] | 1952-01-01 00:00:00
 | [NAME] | 1960-01-01 00:00:00
 | Carly Kash | 1970-01-01 00:00:00
 | [NAME] | 1980-01-01 00:00:00
 | [NAME] | 1979-08-24 00:00:00
 | [NAME] | 1979-08-24 00:00:00
 | [NAME] | 1978-08-25 00:00:00
Spreadsheet: 75941d1276541487-index-match-match-index-match-match
Sheet: Sheet1

 |  |  |  |  |  |  | BigTen |  | ACC |  | Independents
 | 1 | BigTen | Illinois |  |  | 1 | Illinois | 1 | #N/A | 1 | #N/A
 | 2 | BigTen | Indiana |  |  | 2 | Indiana | 2 | #N/A | 2 | #N/A
 | 3 | BigTen | Iowa |  |  | 3 | Iowa | 3 | #N/A | 3 | #N/A
 | 4 | BigTen | Michigan State |  |  | 4 | Michigan State | 4 | #N/A
 | 5 | BigTen | Michigan |  |  | 5 | Michigan | 5 | #N/A
 | 6 | BigTen | Minnesota |  |  | 6 | Minnesota
 | 7 | BigTen | Northwestern |  |  | 7 | Northwestern
 | 8 | BigTen | Ohio State |  |  | 8 | Ohio State
 | 1 | ACC | Boston College
 | 2 | ACC | Clemson
 | 3 | ACC | Duke
 | 4 | ACC | Florida State
 | 5 | ACC | Georgia Tech
 | 1 | Independents | Navy
 | 2 | Independents | Notre Dame
 | 3 | Independents | Army
 |  | Sample Sheet 1 |  |  |  |  | Sample Sheet 2
Spreadsheet: hunter_shively__12666__Nov_01 Volume Changes
Sheet: Nov 2

Pipeline | Producer | Zone | Current Volume | New Volume | Change | Index | GDA | Fixed | Comments
CGLF | Exco | Onshore | 302 | 334 |  |  | 32
FGT | Forest | Z 1 | 115 | 1 |  |  | -114 |  | Well Down
[NAME] | Exco | Zone 4 | 467 | 536 |  |  | 69
NGPL | Exco | La | 277 | 380 |  |  | 103
NGPL | Conoco | STX | 3825 | 2000 |  |  | -1825
SNAT | W&T | Uncntrnd WH | 1025 | 841 |  |  | -184
TRNKL | Crosstex | ELA | 546 | 296 |  |  | -250
TRNKL | Stone | ELA | 700 | 625 |  | -75 |  |  | [NAME]
TRNKL | Forest | ELA | 11164 | 14164 |  |  | 3000
Venice |  |  | 668 | 664 |  |  | -4
 |  |  |  |  | Day Total
 |  |  |  |  | MTD Total | -13774 | 827
Spreadsheet: darrell_schoolcraft__7317__imball0202
Sheet: Duke

Duke Energy Field Services
Contract  24268
2002-01-31 00:00:00 |  | 1508753.99
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2002-02-03 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874 | 283
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262 | -1
500267
Duke Energy Trading and Marketing
Contract  24693
2002-01-31 00:00:00 |  | 275313.72
2002-02-03 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 367789 | 117857 | 193435
2002-01-31 00:00:00 |  | 855876.1
2002-02-03 00:00:00
500241
500391 | 252
500392 | 277
Duke Energy Trading and Marketing
21665 | oba | 73445.08 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36401
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
24268
24693
24361
21665
22664
23995
22051
20379
26357
21544
24532
Spreadsheet: 330592d1404808474-plotting-year-wise-maximum-value-and-occurance-date-the-input-date-is-in-text-format-plotting-year-wise-maximum-value-and-date-
Sheet: analysis

Yearwise | [NAME]. Value | [NAME]. Date | [NAME]. Day | Min. Value | Min. Date | Min. Day
2007
2008
2009 |  |  |  |  |  |  | These are array formula
2010
Answer for cross verification
2007 | 345.6 | 20070504 |  | 239.55 | 20070203
2008 | 387.35 | 20080702
2009 | 347.15 | 20091231
2010 |  | 20101111
Spreadsheet: benjamin_rogers__1184__ NAES_CUSTOMERS for EES
Sheet: INDUSTRIAL

 | INDUSTRIAL
 | NAME | PROCESS | REVENUES | GENERATION | BASE LOAD | PEAK LOAD | RELATIVE RATES | DEREGULATION | ORIGINATOR
1
2
3
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
32
33
34
35
36
37
38
39
40
Spreadsheet: 285488d1387649718-question-search-for-unique-text-or-number-in-a-range-matching-a-value-gulwar_countunique_ron_v1a
Sheet: Sheet1

Part_Number | Lot_ID | Part_ID | Lot_Part |  | T2C532 |  | <-Ron's formula
1 | T2C531 | 1 | T2C531-1 |  |  |  | <-Gulwar's formula
3 | T2C531 | 2 | T2C531-2
7 | T2C531 | 3 | T2C531-3
9 | T2C531 | 1 | T2C531-1
11 | T2C531 | 3 | T2C531-3
16 | T2C534 | 1 | T2C532-1
17 | T2C534 | 3 | T2C532-3
18 | T2C532 | 5 | T2C532-5
19 | T2C532 | 3 | T2C532-3
21 | T2C532 | 1 | T2C532-1
24 | T2C533 | 2 | T2C533-2
25 | T2C533 | 3 | T2C533-3
27 | T2C533 | 4 | T2C533-4
29 | T2C533 | 5 | T2C533-5
31 | T2C533 | 3 | T2C533-3
33 | T2C533 | 2 | T2C533-2
Spreadsheet: 146919d1332422926-countif-a-person-has-at-least-1-whole-weekend-free-book24
Sheet: Sheet1

 |  |  | 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
First Name | Last Name | Contract | 01/04/2012 | 02/04/2012 | 03/04/2012 | 04/04/2012 | 05/04/2012 | 06/04/2012 | [NAME] | 08/04/2012 | 09/04/2012 | 10/04/2012 | 11/04/2012 | 12/04/2012 | 13/04/2012 | 14/04/2012 | 15/04/2012 | 16/04/2012 | 17/04/2012 | 18/04/2012 | 19/04/2012 | 20/04/2012 | 21/04/2012 | 22/04/2012 | 23/04/2012 | 24/04/2012 | [NAME] | 26/04/2012 | 27/04/2012 | 28/04/2012 | 29/04/2012 | 30/04/2012 | Total "Off" | Total planned hours | Weekly average
Paulina | Conde | UP | 09:00 - 17:00 | 09:30 - 17:30 | Off | 09:30 - 17:30 | 09:30 - 17:30 | 13:00 - 21:00 | Off | Off | Off | 11:30 - 19:30 | 11:30 - 19:30 | 11:30 - 19:30 | Off | 11:30 - 19:30 | Off | 09:00 - 17:00 | Off | 09:00 - 17:00 | Off | 09:00 - 17:00 | 09:00 - 17:00 | 09:00 - 17:00 | 13:00 - 21:00 | Off | 13:00 - 21:00 | 13:00 - 21:00 | 13:00 - 21:00 | 13:00 - 21:00 | Off | 13:00 - 21:00 | 10 | 0 | #[NAME]! | No
[NAME] | Danis | UP | Off | Off | 09:30 - 17:30 | 09:30 - 17:30 | 09:30 - 17:30 | 09:30 - 17:30 | 09:30 - 17:30 | Off | Off | Off | 12:00 - 20:00 | 12:00 - 20:00 | 12:00 - 20:00 | Off | Off | 09:00 - 17:00 | 12:00 - 20:00 | Off | 09:00 - 17:00 | 09:00 - 17:00 | 09:00 - 17:00 | 09:00 - 17:00 | Off | 09:00 - 17:00 | 09:00 - 17:00 | Off | 09:00 - 17:00 | 09:00 - 17:00 | 09:00 - 17:00 | 13:00 - 21:00 | 10 | 0 | #[NAME]! | No
[NAME] | Dobruch | UP | 09:30 - 17:30 | 09:30 - 17:30 | 09:30 - 17:30 | 09:30 - 17:30 | Off | 09:30 - 17:30 | 09:30 - 17:30 | Off | Off | 12:30 - 20:30 | 13:00 - 21:00 | Off | 12:30 - 20:30 | 12:30 - 20:30 | Off | Off | 09:00 - 17:00 | 09:00 - 17:00 | 09:00 - 17:00 | 09:00 - 17:00 | 09:00 - 17:00 | Off | Off | 09:00 - 17:00 | 09:00 - 17:00 | 09:00 - 17:00 | 09:00 - 17:00 | 09:00 - 17:00 | Off | 11:30 - 19:30 | 9 | 0 | #[NAME]! | No
Spreadsheet: 47375d1246405099-fill-cell-w-value-present-in-another-row-if-columns-match-third-smpl-1-
Sheet: Sheet1

The Specials | The Specials | The Specials | Blank Expression
The Specials |  | The Specials | Blank Expression
The Specials |  | The Specials | Blank Expression
The Specials |  | The Specials | Blank Expression
The Specials |  | The Specials | Blank Expression
Anxiety Always | Anxiety Always | Adult. | [NAME]
Here Come The Warm Jets | Here Come The Warm Jets | [NAME] | [NAME]
Here Come The Warm Jets |  | [NAME] | [NAME]
Here Come The Warm Jets |  | [NAME] | [NAME]
Here Come The Warm Jets |  | [NAME] | [NAME]
Here Come The Warm Jets |  | [NAME] | [NAME]
Adore | Adore | [NAME] | Blank Page
Adore |  | [NAME] | Blank Page
[NAME] | [NAME] | Shuttle 358 | Blast
 |  | Shuttle 358 | Blast
15
Spreadsheet: 1e06dc08-476e-47bc-a6d1-312c2a510b41
Sheet: Framework

 | French |  |  |  |  |  | Tuberculose
 |  | CovRow |  | ModId |  | IntRow
Spreadsheet: 822823d1679554191-formula-to-automatically-calculate-a-value-in-decimal-format-from-a-range-book1-1-
Sheet: Sheet1

Look Up Value |  |  | Value | Range
87.45 |  |  | 91 | 3.5
 |  |  | 90 | 3.4
Return Value |  |  | 89 | 3.3
 |  |  | 88 | 3.2
 |  |  | 87 | 3.1
 |  |  | 86 | 3
 |  |  | 85 | 2.9
 |  |  | 84 | 2.8
 |  |  | 83 | 2.7
 |  |  | 82 | 2.6
 |  |  | 81 | 2.5
 |  |  | 80 | 2.4
 |  |  | 79 | 2.3
 |  |  | 78 | 2.2
 |  |  | 77 | 2.1
Spreadsheet: 771887d1646907696-index-match-function-error-sample
Sheet: Unit

Unit | Fund | Sum of PYOPA - Prior Year Outstanding Partner Advance  (1) | Sum of Budget (2) | Sum of KK Expenses (3) | Encumbrance  (4) | Advances (5) | Budget Balance [2-3-4-5] | D.R. % [3]/[1+2] | U.R. % [3+4+5]/[1] | Programme Budget | Delivery | Delivery % | Utilization | Utilization % | Bal for Programme | HR/Operations Budget | Utilization | Utilization % | Balance |  | Remarks
EVAW
 | Core |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $54507 - Technical Support Consultant and 12337*2 - Repurposed for Covid Response-2 SSAs
 | Non-Core |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $90K- Support Agency,  $48K- Report/Study/Comms,  $72587- E-Govt. tool, $60K- Intl. [NAME] In Person meetings & Travel
 | Non-Core |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $45K- 3 Individual Experts- Training Procurement- Learnet- ToR Being Finalised Comms Agency- Evaluation Underway SEWA- Proposal being Finalised TISS- ToR being finalised
 | Total
WEE
115825 | Core |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $18,000- Consultant- [NAME], Govt. of Kerala,  $20,000 cash transfer,  $16300 Admin and HR cost
115825 | Non-Core |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $15K- Research MCA $20K- Investor Consortium $22K- Impl. Agency -Industry Disruptor $33287- Interweave, $20K- Agency-Virtual WEPs Awards $5118- Video Documentation $89813- Salary & Admin Cost
 | Total
IGP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $7K- 1 SSA at RCO-Radhika $5737- Protection Officer surge support
 | Core |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $36K- SSA UN Coord./ WPS $8K- Prog. Building WPS $4K- Side Panel at HLPF with [NAME]. $18K- Monitoring of UPR  $7220- Knowledge assets on normative work
 | Total Core
 | Non-Core
 | Ford |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CFP Advertised $82K- C/f next year- SEES Contract -laptop/equip $40K- TISS PCA $30K- Virtual Conveneings $65K- C/F Next Year  $21K- COVID Comm.
 | BMGF
 | Total Non Core
Core andNon-Core
RM & M&E
82109 | RM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $4K- Dr. [NAME] $10K- R.O.- Country Portfolio Evaluation $3.2K- SSA-M&E $5K- Corporate $2.8K- Cost Recovery $39.5K- Surge Support
 | M&E
Total Core
Communication
82109 | Core |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | $25K- [NAME] $12K- Payroll
Spreadsheet: 79218d1279520146-excel-2007-how-to-make-this-conditional-equation-book1-index-1-
Sheet: Sheet2

 |  |  | Rules
 |  | back to sheet 1 | [NAME] ( trucker10) | Formula S H G |  |  |  |  |  | C2 > * or /
 |  | 212 | 32.61538461538462 | 32.61538461538462 | 1 to 5 | If C2 | [NAME]6 |  | 1 | 6
 |  | 14 | 28 | 28 | 6 to 9 | If [NAME] | [NAME] |  | 6 | 4
 |  | 66 | 33 | 33 | 10 to 15 | If C4 | [NAME] |  | 10 | 2
 |  | 122 | 34.85714285714285 | 34.85714285714285 | 16 to 25 | If C5 | [NAME]1.5 |  | 16 | 1.5
 |  | 302 | 35.52941176470588 | 35.52941176470588 | 26 to 50 | If C6 | [NAME] |  | 26 | 1
 |  | 359 | 36.63265306122449 | 36.63265306122449 | 51 to 75 | If C8 | D2= C2/2 |  | 51 | 0.5
 |  | 23 | 34.5 | 34.5 | 76 to 90 | If C9 | D2= C2/2.5 |  | 76 | 0.4
 |  | 56 | 28 | 28 | 91 to 110 | If [NAME] | D2= C2/3 |  | 91 | 0.3333333333333333
 |  | 89 | 35.6 | 35.6 | 111 to 130=/3;5 | If C11 | D2= C2/3.5 |  | 111 | 0.2857142857142857
 |  | 316 | 37.1764705882353 | 37.1764705882353 | 131 to 150=/4 | If C12 | D2= C2/4 |  | 131 | 0.25
 |  | 206 | 37.45454545454545 | 37.45454545454545 | 151 to 175=/4;5 | If [NAME] | [NAME] |  | 151 | 0.2222222222222222
 |  | 56 | 28 | 28 | 176 to 210=/5;5 | If [NAME] | D2= C2/5.5 |  | 176 | 0.1818181818181818
 |  | 98 | 32.66666666666666 | 32.66666666666666 | 211 to 250=/6;5 | If C15 | [NAME] |  | 211 | 0.1538461538461539
 |  | 135 | 33.75 | 33.75 | 251 to 290=/7;5 | If [NAME] | [NAME] |  | 251 | 0.1333333333333333
 |  | 77 | 30.8 | 30.8 | 291 to 320=/8;5 | If C17 | D2= C2/8.5 |  | 291 | 0.1176470588235294
 |  | 36 | 36 | 36 | 321 to 360=/9;8 | If C18 | D2= C2/9.8 |  | 321 | 0.1020408163265306
Spreadsheet: 856631d1705836827-pivot-table-from-different-sheets-not-in-a-nice-large-data-table-attendance-missed-session-catch-up-log-test
Sheet: Learner1

 | Attendance |  |  |  | Additional support plans
Name | P3 | P6 | P9 | P12 | Declared but Declined | University Learning Support Plan from DDSS | Departmental Support plan | Return to Learning Support Plan | Functional Skills training and progress
Learner1
Session missed | Module | Tutor(s) | How missed work was caught up |  |  | Auto completed by Att spreadsheet
2023-09-05 00:00:00 | MGT61102 | Tutor 1 | Video recording uploaded onto blackboard |  |  | PS to link
2023-09-06 00:00:00 | MGT61102 | Tutor 2 | Resources on blackboard |  |  | PS to complete
2023-09-11 00:00:00 | MGT61100 | Tutor 3 | (tutor to complete) |  |  | tutor to complete