tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kam_keiser__17787__phys procedures-new
Sheet: Timeline

Note: | 50 in the Rolloff % field will exclude 50% of positions - report 50% of positions
 | 0  in the Rolloff % field will exclude 100% of positions - report 0% of positions
 | leaving the field blank will exclude 0% of positions - report 100% of positions
 |  | Input in Rolloff % field |  |  |  | % of Positions calculated
Before NX1
2001-04-25 00:00:00
 |  | Index Only |  |  |  | Index Only
 | Current Month | Prompt Month | Prompt Month |  | Current Month | Prompt Month | Prompt Month
 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-05-01 00:00:00 |  | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-05-01 00:00:00
Physical | --- |  | --- |  | 1 |  | 0
Index | --- | --- | --- |  |  | 1
Gas Daily | --- | --- | --- |  | 1 | 1 | 0 |  | 0% of index positions / 100% of fixed price positions
Basis | 0 |  | --- |  | 0 |  | 1
Price | --- |  | --- |  | 0 |  | 1
on NX1
2001-04-26 00:00:00
 |  | Index Only |  |  |  | Index Only
 | Current Month | Prompt Month | Prompt Month |  | Current Month | Prompt Month | Prompt Month
 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-05-01 00:00:00 |  | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-05-01 00:00:00
Physical | --- |  | 50 |  | 1 |  | 0.5
Index | --- | --- | --- |  |  | 0.5
Gas Daily | --- | --- | 50 |  | 1 | 0.5 | 0.5 |  | 50% of index positions / 100% of fixed price positions
Basis | 0 |  | 50 |  | 0 |  | 0.5
Price | --- |  | --- |  | 0 |  | 0
day after  NX1
2001-04-27 00:00:00
 |  | Index Only |  |  |  | Index Only
 | Current Month | Prompt Month | Prompt Month |  | Current Month | Prompt Month | Prompt Month
 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-05-01 00:00:00 |  | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-05-01 00:00:00
Physical | --- |  | --- |  | 0 |  | 1
Index | --- | --- | --- |  |  | 0
Gas Daily | --- | --- | --- |  | 1 | 0 | 1 |  | 100% of index positions / 100% of fixed price positions
Basis | 0 |  | 0 |  | 0 |  | 0
Price | --- |  | --- |  | 0 |  | 0
last day of the month - the first column will shift to the next month
2001-04-30 00:00:00
 |  | Index Only |  |  |  | Index Only
 | Current Month | Prompt Month | Prompt Month |  | Current Month | Prompt Month | Prompt Month
 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-06-01 00:00:00 |  | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-06-01 00:00:00
Physical | --- |  | --- |  | 1 |  | 0
Index | --- | --- | --- |  |  | 1
Gas Daily | --- | --- | --- |  | 1 | 1 | 0 |  | 100% of index positions / 100% of fixed price positions
Basis | 0 |  | --- |  | 0 |  | 1
Price | --- |  | --- | extend the "To" date in portcalc to include prompt month positions (ex. From date = 28-Apr-2001 To date = 01-Jun-2001) | 0 |  | 1
Spreadsheet: 30662d1226338381-record-data-button-margin-calc-start
Sheet: Sheet1

Margin Calculator
 | Quantity | Description | Cost | Total Cost | Price | Total Price | Margin %
 | 4 | Software | 952 |  | 1299
 | 60 | Hardware | 414 |  | 432
 |  |  |  | Kit Total Cost |  | Kit Total Price
 |  |  |  |  |  | Total Profit
 |  |  |  |  |  | Total Margin %
Spreadsheet: 816706d1675785197-find-the-blanks-and-return-name-s666-pq-find-the-blanks-and-return-name
Sheet: Sheet2

 | List on names not done |  | [NAME] |  | Not done
 |  |  | a |  | a
 |  |  | c |  | c
 |  |  | d |  | d
 |  |  | g |  | g
 |  |  | i |  | i
 |  |  | j |  | j
 |  |  | l |  | l
 |  |  | m |  | m
 |  |  | o |  | o
 |  |  | p |  | p
Spreadsheet: 723286d1615610472-join-table-into-text-with-headers-and-bullet-points-example
Sheet: Sheet1

A | B | C | D | E
1 | 1 | Blank | 1 | 1 | A - 1 - 2 - 3 B - 1 - 2 D - 1 - 2 E - 1 - 2 - 3
2 | 2 | Blank | 2 | 2
3 | Blank | Blank | Blank | 3
Blank | Blank | Blank | Blank | Blank
Blank | Blank | Blank | Blank | Blank
Spreadsheet: 835654d1688701492-help-with-calculating-percentages-danyos-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | % by Vendor
VENDOR | PART ID | DELIVERY STATUS |  | % overall by status |  | % overall by Part ID |  |  | Early | On-Time | Late | Early | On-Time | Late | Early | On-Time | Late | Early | On-Time | Late
Vendor A | Part A | Late | Early |  | Part A |  |  |  | Part A | Part A | Part A | Part B | Part B | Part B | Part C | Part C | Part C | Part D | Part D | Part D | Part E | Part X | Part Y
Vendor A | Part B | On-Time | On-Time |  | Part B |  |  | Vendor A
Vendor A | Part C | Late | Late |  | Part C |  |  | Vendor B
Vendor A | Part D | Early |  |  | Part D |  |  | Vendor C
Vendor A | Part A | On-Time |  |  | Part E |  |  | Vendor D
Vendor B | Part A | On-Time |  |  | Part X
Vendor B | Part E | Late |  |  | Part Y
Vendor C | Part A | Late
Vendor C | Part X | Early
Vendor C | Part Y | Early
Vendor D | Part X | On-Time
Spreadsheet: 849660d1700071173-overtime-timesheet-how-to-remove-regular-horking-hours-on-weekend-ot-time-sheet-calculator
Sheet: Data

Years | Months | Days | Weekend
2015 | January | 1 | No Weekend
2016 | February | 2 | Sat & Sun
2017 | March | 3 | Sun & Mon
2018 | April | 4 | Mon & Tue
2019 | May | 5 | Tue & Wed
2020 | June | 6 | Wed & Thu
2021 | July | 7 | Thu & Fri
2022 | August | 8 | Fri & Sat
2023 | September | 9 | Mon Only
2024 | October | 10 | Tue Only
2025 | November | 11 | Wed Only
2026 | December | 12 | Thu Only
2027 |  | 13 | Fri Only
 |  | 14 | Sat Only
 |  | 15 | Sun Only
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
Spreadsheet: 121926d1316513443-insert-text-which-is-to-be-a-sheet-name-into-array-lookup-examplesheet
Sheet: Sign off MONTH 2011

 | Job # | Gallery online & job signed off by Manager
 | Job # | Online gallery not required & job signed off by Manager
 | Job # | NO FORM SUBMITTED BY PHOTOG, BUT SIGNED OFF BY MANAGER
 | Jobs signed off by Manager
DO NOT DELETE COLUMN |  |  |  |  |  |  | DO NOT DELETE COLUMN | DO NOT DELETE COLUMN | DON NOT DELETE COLUMN |  |  | DO NOT DELETE COLUMN | DO NOT DELETE COLUMN
 | Name of relative gallery tracking sheet |  |  | MONTH 2011 gallery
 | Job number | Notes if applicable
 | ABC
 | GHI
Spreadsheet: andy_zipper__167__DYNEGY-ICE VOL Apr11
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-11-01 thru Apr-11-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-11-01 | 781641703 |  | Sold | NG Fin BS, LD1 for NGI | Chicago | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Duke Energy Trading and Marketing LLC | 0.1375 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Apr-11-01 | 794411880 |  | Sold | NG Fin BS, LD1 for IF | Perm | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | AEP Energy Services, Inc. | -0.05 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Apr-11-01 | 108412752 |  | Sold | NG Fin BS, LD1 for IF | Perm | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | El Paso Merchant Energy L.P. | -0.05 | USD / MMBtu | 10000 | Daily | 310000 | MMBtus | [NAME], G
Apr-11-01 | 312872248 |  | Sold | NG Fin BS, LD1 for IF | Perm | [NAME] | May-01-01 | Oct-31-01 |  |  |  | AEP Energy Services, Inc. | 0.1025 | USD / MMBtu | 10000 | Daily | 1840000 | MMBtus | [NAME], G
Apr-11-01  Deals
Spreadsheet: 851881d1702005519-need-consolidated-total-duration-of-the-training-hours-spent-by-each-employee-formula-vijavad-
Sheet: Main Data

EMP ID | Name | First Join | Last Leave | In-Meeting Duration | Date Value | Days Count | Time Value
123789 | Vijay | 11/20/23, 2:02:13 PM | 11/20/23, 5:32:12 PM | 3h 29m 58s
276543 | Kiran Kumar V | 11/21/23, 3:07:21 PM | 11/21/23, 5:57:40 PM | 2h 50m 18s |  |  |  |  | EMP ID | Name | Sum of Days Count | Sum of Time Value
276543 | Kiran Kumar V | 11/23/23, 4:13:46 PM | 11/23/23, 6:20:18 PM | 2h 6m 31s |  |  |  |  | 123789 | Vijay | 1 | 3:29:58
276543 | Kiran Kumar V | 11/24/23, 2:31:54 PM | 11/24/23, 5:59:09 PM | 3h 27m 15s |  |  |  |  | 276543 | Kiran Kumar V | 4 | 12:18:34
276543 | Kiran Kumar V | 11/27/23, 2:25:27 PM | 11/27/23, 6:19:57 PM | 3h 54m 30s |  |  |  |  | 289765 | Manikanta | 7 | 19:06:42
289765 | Manikanta | 11/21/23, 4:15:22 PM | 11/21/23, 5:57:09 PM | 1h 41m 46s
289765 | Manikanta | 11/22/23, 2:48:29 PM | 11/22/23, 2:49:08 PM | 38s
289765 | Manikanta | 11/22/23, 2:48:29 PM | 11/22/23, 5:57:53 PM | 2h 3m 23s
289765 | Manikanta | 11/22/23, 3:55:08 PM | 11/22/23, 5:57:53 PM | 2h 2m 45s
289765 | Manikanta | 11/23/23, 3:36:50 PM | 11/23/23, 6:20:21 PM | 2h 43m 30s
289765 | Manikanta | 11/24/23, 2:15:49 PM | 11/24/23, 5:59:59 PM | 3h 44m 10s
289765 | Manikanta | 11/27/23, 2:52:41 PM | 11/27/23, 6:08:36 PM | 3h 15m 54s
289765 | Manikanta | 11/28/23, 5:45:21 PM | 11/28/23, 5:59:46 PM | 14m 24s
289765 | Manikanta | 11/29/23, 2:36:12 PM | 11/29/23, 5:56:24 PM | 3h 20m 12s
Spreadsheet: 875332d1721917334-how-to-automatically-filter-multiple-arrays-of-data-by-their-relevant-headings-lookup-sheet-test
Sheet: Cause Controls Lookup

Cause ID: | Cause Name: | Description: | Control ID: | Control Name: | Description:
441276
 |  |  | 1486554 | CoN363 | CoD363
 |  |  | 1486375 | CoN184 | CoD184
 |  |  | 1486504 | CoN313 | CoD313
 |  |  | 1486223 | CoN32 | CoD32
 |  |  | 1486239 | CoN48 | CoD48
 |  |  | 1486401 | CoN210 | CoD210
 |  |  | 1486371 | CoN180 | CoD180
 |  |  | 1486276 | CoN85 | CoD85
 |  |  | 1486382 | CoN191 | CoD191
 |  |  | 1486385 | CoN194 | CoD194
 |  |  | 1486212 | CoN21 | CoD21
Spreadsheet: 858d94c6-5de4-4aa8-b1b2-3db240a8f365
Sheet: PAG 18 - table 2

Ambev shareholding structure
 | ON | %Outs | PN | %Outs | Total | %Outs
Anheuser-Busch InBev | 1290455585 | 0.7402125769008175 | 629090105 | 0.462505584846456 | 1919545690 | 0.6185026976231897
FAHZ | 297810410 | 0.1708257250976902 | 0 | 0 | 297810410 | 0.09595840459794845
Market | 155092096 | 0.08896169800149223 | 731088292 | 0.537494415153544 | 886180388 | 0.2855388977788619
Outstanding | 1743358091 | 1 | 1360178397 | 1 | 3103536488 | 1
Treasury | 530599 |  | 742340 |  | 1272939
TOTAL | 1743888690 |  | 1360920737 |  | 3104809427
Free float BM&FBovespa | 150857911 | 0.08653294568614246 | 455667978 | 0.3350060396526059 | 606525889 | 0.1954305648878841
Free float NYSE | 4234185 | 0.002428752315349767 | 275420314 | 0.2024883755009381 | 279654499 | 0.09010833289097776
Spreadsheet: 694161d1599400206-link-between-two-list-box-filter-pivot
Sheet: Sheet1

partner | Project |  | partner | B
A | 6001 |  |  |  |  | Partner list |  |  |  | Project list
A | 6004 |  | [NAME]
B | 6002 |  | 6002
A | 6007 |  | 6003
B | 6008 |  | 6008
A | 6005 |  | 6011
B | 6003 |  | Total Geral
C | 6012
A | 6154
C | 6009
C | 6017
B | 6011
A | 6010
Spreadsheet: 210948d1359617268-forumlas-with-date-dependency-sample
Sheet: Sheet1

2013-01-17 00:00:00 | 938
2013-01-18 00:00:00 | 780
2013-01-21 00:00:00 | 560
2013-01-22 00:00:00 | 816
2013-01-23 00:00:00 | 659
2013-01-24 00:00:00 | 864
2013-01-25 00:00:00 | 764
2013-01-28 00:00:00 | 744
2013-01-29 00:00:00 | 626
2013-01-30 00:00:00 | 715 |  | Todays volume compared to last 5 days
2013-01-31 00:00:00
2013-02-01 00:00:00 |  |  | I'm looking for that formula to adjust to the Value in column B for TODAY and the AVERAGE Range to be adjusted to the 5 previous days of TODAY
2013-02-02 00:00:00
2013-02-03 00:00:00
2013-02-04 00:00:00
2013-02-05 00:00:00
2013-02-06 00:00:00
Spreadsheet: 859550d1707908129-how-to-count-consecutive-dates-for-each-employee-from-a-listing-of-absence-dates-test-absence-file
Sheet: Sheet1

Employee: | Start | End | Column1 | Is a period | #periods
EE1 | 2024-01-02 00:00:00 |  |  |  |  | consectuvie with w/e break should be 1 occurrence |  | EE1
EE1 | 2024-01-03 00:00:00 |  |  |  |  |  |  | EE2
EE1 | 2024-01-04 00:00:00 |  |  |  |  |  |  | EE3
EE1 | 2024-01-05 00:00:00
EE1 | 2024-01-08 00:00:00
EE1 | 2024-01-09 00:00:00
EE1 | 2024-01-10 00:00:00
EE1 | 2024-01-11 00:00:00
EE1 | 2024-01-12 00:00:00
EE2 | 2024-01-08 00:00:00 |  |  |  |  | Correct
EE2 | 2024-01-09 00:00:00
EE2 | 2024-01-10 00:00:00
EE2 | 2024-01-11 00:00:00
EE2 | 2024-01-17 00:00:00
EE3 | 2024-01-18 00:00:00 |  |  |  |  | consectuvie with 2 w/e breaks should be 1 occurrence
EE3 | 2024-01-19 00:00:00
EE3 | 2024-01-22 00:00:00
EE3 | 2024-01-23 00:00:00
EE3 | 2024-01-24 00:00:00
EE3 | 2024-01-25 00:00:00
EE3 | 2024-01-26 00:00:00
EE3 | 2024-01-29 00:00:00
EE3 | 2024-01-30 00:00:00
EE3 | 2024-01-31 00:00:00
EE4 | 2024-01-09 00:00:00 |  |  |  |  | Correct
EE4 | 2024-01-19 00:00:00
EE4 | 2024-01-31 00:00:00
Spreadsheet: 148462d1333421544-how-to-list-multiple-values-by-searching-key-search-and-list-multiple-value
Sheet: Sheet1

key | value
aaa | 11
bbb | 22
[NAME] | 33
aaa | xx
xxx | aa
aaa | hello
search key | aaa
result | 11 | xx | hello
Spreadsheet: 717276d1612549415-pulling-sorting-data-from-spreadsheet-based-on-specific-criteria-excel-sample
Sheet: Sheet1

ORIG_ID | FROM_DATE
99954 | 2020-10-17 00:00:00
99954 | 2020-10-17 00:00:00
99954 | 2020-10-17 00:00:00
99954 | 2020-10-17 00:00:00
99954 | 2020-10-19 00:00:00
41855 | 2020-06-29 00:00:00
41855 | 2020-06-29 00:00:00
41855 | 2020-06-29 00:00:00
41855 | 2020-06-29 00:00:00
41855 | 2020-06-29 00:00:00
41855 | 2020-06-29 00:00:00
88752 | 2020-07-05 00:00:00
88752 | 2020-07-05 00:00:00
88752 | 2020-07-05 00:00:00
88752 | 2020-07-12 00:00:00
66782 | 2020-09-08 00:00:00
77833 | 2020-10-02 00:00:00
77833 | 2020-10-02 00:00:00
77833 | 2020-11-08 00:00:00
17762 | 2020-12-01 00:00:00
17762 | 2020-12-07 00:00:00
17762 | 2020-12-07 00:00:00
Spreadsheet: 139080d1328062589-help-with-data-extraction-from-a-workbook-book2
Sheet: Sheet1

ed14122 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2009 | 28.02.2010 | 0 | 61 | 571.13518
ed14122 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.03.2010 | 30.06.2010 | 0 | 61 | 666.79
ed14122 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2010 | 30.06.2011 | 0 | 61 | 766.1
ed14122 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2011 | 31.12.9999 | 0 | 61 | 872.28
pw6542 | Monthly | 2 |  | 1 | NRES | 1 | 2 | 01.07.2009 | 28.02.2010 | 0 | 65 | 800.93
pw6543 | Monthly | 2 |  | 1 | NRES | 1 | 2 | 01.03.2010 | 30.06.2010 | 0 | 65 | 918.87
pw6544 | Monthly | 2 |  | 1 | NRES | 1 | 2 | 01.07.2010 | 30.06.2011 | 0 | 65 | 1054.94
pw6545 | Monthly | 2 |  | 1 | NRES | 1 | 2 | 01.07.2011 | 31.12.9999 | 0 | 65 | 1197.82
uuj5442 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2009 | 28.02.2010 | 0 | 62 | 546.86
uuj5443 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.03.2010 | 30.06.2010 | 0 | 62 | 632.35
uuj5444 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2010 | 30.06.2011 | 0 | 62 | 727.4
uuj5445 | Annual | 2 |  | 1 | NRES | 1 | 2 | 01.07.2011 | 31.12.9999 | 0 | 62 | 829.93
Spreadsheet: 00b27eb0-08b6-47b4-820b-7e9bc21f43fd
Sheet: Subtotal

Month | Date | Object Code | Category | Amount
January | 2004-01-08 00:00:00 | 3209 | Computer equipment | 389
January | 2004-01-12 00:00:00 | 4100 | Office supplies | 28.19
January | 2004-01-15 00:00:00 | 1909 | Salary faculty | 289872
January | 2004-01-15 00:00:00 | 2999 | [NAME] staff | 98983
February | 2004-02-02 00:00:00 | 4100 | Office supplies | 55.98
February | 2004-02-15 00:00:00 | 1909 | Salary faculty | 198772
February | 2004-02-15 00:00:00 | 2999 | [NAME] staff | 109871
February | 2004-02-19 00:00:00 | 3209 | Computer equipment | 218.2
February | 2004-02-25 00:00:00 | 4100 | Office supplies | 109.8
March | 2004-03-03 00:00:00 | 3209 | Computer equipment | 18.84
March | 2004-03-07 00:00:00 | 4100 | Office supplies | 256.78
March | 2004-03-15 00:00:00 | 1909 | Salary faculty | 325098
March | 2004-03-15 00:00:00 | 2999 | [NAME] staff | 100982
March | 2004-03-15 00:00:00 | 4100 | Office supplies | 134
March | 2004-03-18 00:00:00 | 4100 | Office supplies | 128.75
March | 2004-03-21 00:00:00 | 4100 | Office supplies | 289
March | 2004-03-22 00:00:00 | 4100 | Office supplies | 309
March | 2004-03-29 00:00:00 | 3209 | Computer equipment | 189.21
March | 2004-03-29 00:00:00 | 3219 | Computer software | 589
April | 2004-04-03 00:00:00 | 3209 | Computer equipment | 278.21
April | 2004-04-04 00:00:00 | 3219 | Computer software | 219
April | 2004-04-05 00:00:00 | 3219 | Computer software | 489
April | 2004-04-07 00:00:00 | 4100 | Office supplies | 89.1
April | 2004-04-15 00:00:00 | 1909 | Salary faculty | 309876
April | 2004-04-15 00:00:00 | 2999 | [NAME] staff | 97098
April | 2004-04-28 00:00:00 | 3209 | Computer equipment | 3897
April | 2004-04-29 00:00:00 | 3209 | Computer equipment | 47
May | 2004-05-05 00:00:00 | 4100 | Office supplies | 87.45
May | 2004-05-15 00:00:00 | 1909 | Salary faculty | 215988
May | 2004-05-15 00:00:00 | 2999 | [NAME] staff | 95009
May | 2004-05-15 00:00:00 | 3209 | Computer equipment | 58.9
May | 2004-05-15 00:00:00 | 3209 | Computer equipment | 289
May | 2004-05-15 00:00:00 | 3209 | Computer equipment | 190
May | 2004-05-16 00:00:00 | 4100 | Office supplies | 44.7
May | 2004-05-17 00:00:00 | 4100 | Office supplies | 35.9
May | 2004-05-20 00:00:00 | 4100 | Office supplies | 29.9
May | 2004-05-22 00:00:00 | 4100 | Office supplies | 10.77
June | 2004-06-05 00:00:00 | 3219 | Computer software | 453
June | 2004-06-15 00:00:00 | 1909 | Salary faculty | 250921
June | 2004-06-15 00:00:00 | 2999 | [NAME] staff | 90021
June | 2004-06-25 00:00:00 | 3209 | Computer equipment | 189
June | 2004-06-28 00:00:00 | 4100 | Office supplies | 9.76
June | 2004-06-29 00:00:00 | 4100 | Office supplies | 100.87
Spreadsheet: 39799d1238078758-copy-select-rows-on-2-sheets-to-a-3rd-sheet-book1
Sheet: JAN

Description | Date | Amount | Category
Chase | 2009-01-01 00:00:00 | 500 | mortgage
Chevron | 2009-01-12 00:00:00 | 25 | gasoline
Kroger | 2009-01-21 00:00:00 | 75 | grocery
Shell | 2009-01-25 00:00:00 | 30 | gasoline
Spreadsheet: 169788d1343059078-pulling-only-last-30-days-data-from-larger-all-time-table-ef132_list1
Sheet: Recent

 | Start date: | 2012-06-06 00:00:00
Match | ID | Incident Date | Issue Title | Impact Time
7 | 565 | 2012-06-12 00:00:00 | Update Not Received | 1
8 | 566 | 2012-06-11 00:00:00 | Update Not Received | 0
9 | 544 | 2012-06-10 00:00:00 | Slowness issues | 0
10 | 547 | 2012-06-09 00:00:00 | Slowness issues | 3
11 | 548 | 2012-06-08 00:00:00 | Update Not Received | 0
12 | 549 | 2012-06-07 00:00:00 | Update Not Received | 2.1
13 | 550 | 2012-06-06 00:00:00 | Update Not Received | 0
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Spreadsheet: 708105d1607615605-returning-value-in-one-sheet-based-on-data-and-time-criteria-in-another-result-based-on-data-and-time-match
Sheet: Result sheet

Date (DD/MM/YYYY) | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
2020-10-15 00:00:00
2020-10-16 00:00:00
2020-10-17 00:00:00
2020-10-18 00:00:00
2020-10-19 00:00:00
2020-10-20 00:00:00
2020-10-21 00:00:00
2020-10-22 00:00:00
2020-10-23 00:00:00
2020-10-24 00:00:00
2020-10-25 00:00:00
Spreadsheet: 834719d1688032835-trying-to-create-a-list-from-another-table-using-the-last-populated-column-work-teams
Sheet: Teams

 | In | Players | Random Number | Rank | Number of people |  |  | Team A | Team B
 |  |  |  |  |  |  | 1
 |  | [NAME] |  |  |  |  | 2
 |  | [NAME] |  |  |  |  | 3
 |  | Stephen |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
Spreadsheet: 133626d1324502122-excel-2007-conditional-formatting-for-shortest-time-extract-values
Sheet: Sheet3

 |  |  |  |  | 20:32:12
 |  |  |  |  | 15:56:16
 |  |  |  |  | 18:56:47
 |  |  |  |  | 07:18:42
 |  |  |  |  | 10:08:26
 |  |  |  |  | 04:09:19
 |  |  |  |  | 09:27:17
 |  |  |  |  | 12:00:16
 |  |  |  |  | 04:35:24
 |  |  |  |  | 10:27:05
 |  |  |  |  | 07:22:08
 |  |  |  |  | 09:54:39
 |  |  |  |  | 19:06:27
 |  |  |  |  | 16:56:21
 |  |  |  |  | 00:13:56
 |  |  |  |  | 18:43:07
 |  |  |  |  | 03:48:48
 |  |  |  |  | 06:04:50
 |  |  |  |  | 09:36:08
 |  |  |  |  | 05:18:51
 |  |  |  |  | 15:36:55
 |  |  |  |  | 08:33:31
 |  |  |  |  | 05:13:34
 |  |  |  |  | 11:06:57
 |  |  |  |  | 02:07:12
 |  |  |  |  | 21:58:04
 |  |  |  |  | 00:48:56
 |  |  |  |  | 21:39:54
 |  |  |  |  | 12:33:16
 |  |  |  |  | 10:19:59
 |  |  |  |  | 13:47:41
 |  |  |  |  | 09:48:09
 |  |  |  |  | 01:12:17
 |  |  |  |  | 06:59:22
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -52125 | -53717 | -55029 | -54300
2 | -29081 | -34217 | -38945 | -44300
3 | -29493 | -34217 | -38994 | -44300
4 | -34243 | -34217 | -44588 | -44300 |  |  |  |  |  | [NAME] |  | Pecos Del |  |  | Cumulative
5 |  |  |  |  |  |  |  |  | Month | Measured | Scheduled | Measured | Scheduled | Imbalance | Balance
6 |  |  |  |  |  |  |  |  | 2000-12-01 00:00:00 | Balance as of 12/31/00 |  |  |  |  | -7752
7 |  |  |  |  |  |  |  |  | 2001-01-01 00:00:00 | -231248 | -57416 | -97420 | -261633
8 |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 | -21620 | -15000 | 0 | -5000
9 |  |  |  |  |  |  |  |  | 2001-03-01 00:00:00 | -162976 | 0 | -266 | -160000
10 |  |  |  |  |  |  |  |  | 2001-04-01 00:00:00 | -796190 | -10000 | -33222 | -771924
11 |  |  |  |  |  |  |  |  | 2001-05-01 00:00:00 | -893146 | -43184 | 0 | -842284
12 |  |  |  |  |  |  |  |  | 2001-06-01 00:00:00 | -652748 | -31034 | -332106 | -946401
13 |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | -1299468 | -656709 | -734846 | -1410580
14 |  |  |  |  |  |  |  |  | 2001-08-01 00:00:00 | -1826791 | -534941 | -305444 | -1560630
15 |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | -1552478 | -728692 | -117048 | -943957
16 |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 | -1139380 | -196498 | -307336 | -1322794
17 |  |  |  |  |  |  |  |  | 2001-11-01 00:00:00 | -144119 | -155994 | -1349971 | -1325152
18 |  |  |  |  |  |  |  |  | 2001-12-01 00:00:00 | -379245 | -376245 | -721032 | -724604
19 |  |  |  |  |  |  |  |  | 2002-01-01 00:00:00 | -279779 | -271068 | -1831943 | -1808648 |  |  | estimated
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 53045
2002-03-04 00:00:00
CBS $
 |  |  | 90293.96
Spreadsheet: 841706d1693889690-formula-to-calculate-percentage-emmarky-tms
Sheet: Sheet1

Question | Response
A1 | Yes | X
A2 | yes
A3 | yes | X
A4 | no
B1 | no | X
B2 | n/a
B3 | yes | X
B4 | no
C1 | n/a | X
C2 | yes | X
[NAME] | no
C4 | n/a | X
D1 | yes
D2 | no | X
D3 | n/a
D4 | yes | X
Total percentage |  | list in a cell on another sheet
 |  | list in a cell on another sheet referred to by Named [NAME]
 |  | static list embedded in formula
 |  | static list using Named Value
 |  | list in a cell on another sheet
 |  | list in a cell on another sheet referred to by Named [NAME]
 |  | static list embedded in formula
 |  | static list using Named Value
Spreadsheet: 30841d1226525526-making-a-list-of-names-from-inputted-data-aj-quiz
Sheet: Data

 |  |  | Mrs | 1
 |  |  | Miss | 2 |  | 0
 |  |  | Ms | 3
 |  |  | Master | 4 |  | 85 |  | Congratulations - You have passed!
 |  |  | Mr. | 5
 |  |  |  | 6 |  |  |  | Unfortunately, you have not passed!
 |  |  | [NAME] | 7
 |  |  | [NAME] | 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
 |  |  |  | 41
 |  |  |  | 42
 |  |  |  | 43
 |  |  |  | 44
 |  |  |  | 45
 |  |  |  | 46
 |  |  |  | 47
 |  |  |  | 48
 |  |  |  | 49
 |  |  |  | 50
 |  |  |  | 51
 |  |  |  | 52
 |  |  |  | 53
 |  |  |  | 54
 |  |  |  | 55
 |  |  |  | 56
 |  |  |  | 57
 |  |  |  | 58
 |  |  |  | 59
 |  |  |  | 60