tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 268921d1380890144-equal-to-formula-not-returning-right-results-if-e3-g-1-o3-0-payroll-test
Sheet: Dailies

 |  |  |  |  |  | 2013-09-23 00:00:00 |  |  |  |  |  |  |  |  |  | 2013-09-24 00:00:00 |  |  |  |  |  |  |  |  |  | 2013-09-25 00:00:00 |  |  |  |  |  |  |  |  |  | 2013-09-26 00:00:00 |  |  |  |  |  |  |  |  |  | 2013-09-27 00:00:00 |  |  |  |  |  |  |  |  |  | Weekly Total
 | Agent Name | Pay Type | Trial Start Date | Actual Paid Start Date | Leaver Date | Shift | WO/WL/Hol/Awol | Shift Start | Time Out (Lunch) | Time In (Lunch) | Shift End | Breaks | Holiday Hrs Booked | Actual [NAME] | [NAME] | Shift | WO/WL/Hol/Awol | Shift Start | Time Out (Lunch) | Time In (Lunch) | Shift End | Breaks | Holiday Hrs Booked | Hours Worked | [NAME] | Shift | WO/WL/Hol/Awol | Shift Start | Time Out (Lunch) | Time In (Lunch) | Shift End | Breaks | Holiday Hrs Booked | Hours Worked | [NAME] | Shift | WO/WL/Hol/Awol | Shift Start | Time Out (Lunch) | Time In (Lunch) | Shift End | Breaks | Holiday Hrs Booked | Hours Worked | [NAME] | Shift | WO/WL/Hol/Awol | Shift Start | Time Out (Lunch) | Time In (Lunch) | Shift End | Breaks | Holiday Hrs Booked | Hours Worked | [NAME] | Total Hrs Hol Booked | Total Hrs Worked | Total Actual [NAME] Pay
ACTIVE | Mr Test | Hourly | 2013-09-23 00:00:00 | Wed/25/09/13 |  | 10:00-19:00 | WO | 10:00:00 | 14:00:00 | 15:00:00 | 19:00:00 | 00:30:00 |  |  |  | 10:00-19:00 | WO | 10:00:00 | 14:00:00 | 15:00:00 | 19:00:00 | 00:30:00 |  |  |  | 10:00-19:00 | WO | 10:00:00 | 14:00:00 | 15:00:00 | 19:00:00 | 00:30:00 |  |  |  | 10:00-19:00 | WO | 10:00:00 | 14:00:00 | 15:00:00 | 19:00:00 | 00:30:00 |  |  |  | 10:00-19:00 | WO | 10:00:00 | 14:00:00 | 15:00:00 | 19:00:00 | 00:30:00
Spreadsheet: 729917d1619440514-group-and-total-duplicate-values-in-a-column-group-and-total-duplicate-values-in-a-column
Sheet: Sheet1

Customer Name | [NAME] |  |  | Customer | Total
YTC Ltd | 1 |  |  | YTC Ltd | 1
Yorkshire Purchasing Organisation - YPO | 1 |  |  | Yorkshire Purchasing Organisation - YPO | 1
YESSS Electrical | 1 |  |  | YESSS Electrical | 1
X L Technical Services | 1 |  |  | X L Technical Services | 1
Wirs (Wolverhampton) Ltd. | 1 |  |  | Wirs (Wolverhampton) Ltd. | 1
[NAME] | 1 |  |  | [NAME] | 1
[NAME] t/a Sunrise Bakery | 1 |  |  | [NAME] t/a Sunrise Bakery | 1
[NAME] | 1 |  |  | WICKES | 12
[NAME] 8080 | 1 |  |  | WHS Plastics Ltd | 1
WICKES Trowbridge 8275 | 1 |  |  | Wholesale POS Limited | 1
WICKES Swansea Extra 8323 | 1 |  |  | [NAME] | 1
WICKES Stowmarket 8493 | 1 |  |  | Walraven Ltd | 1
WICKES Brentwood 8409 | 1 |  |  | Wrights Plastics  Ltd | 2
WICKES Andover 8321 | 1 |  |  | Widney Manufacturing Ltd | 2
Wickes - WEST LONDON FULFILMENT | 1 |  |  | Zeus Media Ltd | 3
WHS Plastics Ltd | 1 |  |  | Westgate Global Ltd | 4
Wholesale POS Limited | 1 |  |  | Yours Clothing Ltd | 6
[NAME] | 1 |  |  | Wiggle Ltd - Citadel | 6
Walraven Ltd | 1 |  |  | XPO Transport Solutions UK Limited | 12
Wrights Plastics  Ltd | 2
Widney Manufacturing Ltd | 2
WICKES Boston 8355 | 2
WICKES Bedford 8264 | 2
Zeus Media Ltd | 3
Westgate Global Ltd | 4
Yours Clothing Ltd | 6
Wiggle Ltd - Citadel | 6
XPO Transport Solutions UK Limited | 12
Spreadsheet: 218931d1362611573-change-cell-color-based-on-greater-than-less-than-formula-vehicles
Sheet: ALL

updated 3/6/13
Vehicle # | LAST | CURRENT | DUE
112 | 38120 | 43109 | 43220
113 | 37870 | 39358 | 42870
114 | 43260 | 44538 | 48260
400 |  | 100107 | 103469
400 generator
196 | 5880 | 6745
196 generator | 429 | 562.7 | 600
609 |  | 77250 | 78249
502 | 47718
Spreadsheet: 792208d1660774244-sumifs-and-lookup-function-resulted-to-null-value-sampleproblemsumifsandlookup-tms
Sheet: Data 1

Posting Date | Assignment | G/L Account | Document Number | Document type | Segment | Profit Center | Cost Center | Amount in local currency
2021-01-04 00:00:00 | 1000001417 | 21200101 | 1500000551 | KZ | CBGD | 2039-000 |  | 10204222.23
2021-01-04 00:00:00 | 1000001417 | 21200101 | 1500000552 | KZ | CBGD | 2039-000 |  | 5644233.2
2021-01-04 00:00:00 | 1000001417 | 21200101 | 1500000553 | KZ | CBGD | 2039-000 |  | 3397125.43
2021-01-04 00:00:00 | 1000001417 | 21200101 | 1500000554 | KZ | CBGD | 2039-000 |  | 2218822.07
2021-01-04 00:00:00 | 1700000100 | 21200101 | 2000040584 | ZP | OHLD | 1963-000 |  | 10047.51
2021-01-04 00:00:00 | 1700000100 | 21200101 | 2000040585 | ZP | OHLD | 1963-000 |  | 21668.4
2021-01-05 00:00:00 | EM00009109 | 21300502 | 2000040586 | ZP | HOFC | HOFC-000 |  | 15000
2021-01-05 00:00:00 | EM09008320 | 21300502 | 2000040587 | ZP | HOFC | HOFC-000 |  | 32691
2021-01-05 00:00:00 | EM09017409 | 21300502 | 2000040588 | ZP | HOFC | HOFC-000 |  | 960
2021-01-05 00:00:00 | EM09017417 | 21300502 | 2000040589 | ZP | HOFC | HOFC-000 |  | 50000
2021-01-05 00:00:00 | EM00003217 | 21300502 | 2000040590 | ZP | HOFC | HOFC-000 |  | 17291.55
2021-01-05 00:00:00 | EM00003217 | 21300502 | 2000040590 | ZP | IPD | 2063-000 |  | 8428
2021-01-05 00:00:00 | EM00009109 | 21300502 | 2000040591 | ZP | HOFC | HOFC-000 |  | 29093.03
2021-01-05 00:00:00 | EM09003978 | 21300502 | 2000040592 | ZP | IPD | 2111-000 |  | 3961.64
2021-01-05 00:00:00 | EM09003978 | 21300502 | 2000040592 | ZP | HOFC | HOFC-000 |  | 15060
2021-01-05 00:00:00 | 1000000943 | 21200101 | 2000040593 | ZP | HOFC | 1997-000 |  | 13979.23
2021-01-05 00:00:00 | 1000000943 | 21200101 | 2000040593 | ZP | IPD | 2053-000 |  | 5715.77
2021-01-05 00:00:00 | 1000000943 | 21200101 | 2000040593 | ZP | HOFC | HOFC-000 |  | 53855.94
Spreadsheet: 722146d1615059610-dynamic-drop-down-list-without-repetition-dynamic_dropdownlist-sample
Sheet: Result

 | Dynamic Selection |  |  |  | Month_List | Week_List
 | Month | 2021-02-01 00:00:00 | The column C should display only Months from the Sheet 'Month' (Column E, without repeating)
 | Week | 9-2021 | This should list down all the weeks falls under Feb-21 i.e. selected from C3 drop down list
 | Week No. |  | This should be displayed based on the C4 value to be fetched from 'Month' sheet
Spreadsheet: 473393d1470180622-auto-populate-calendar-from-list-of-events-in-2-tables-ef945_calendar_two_tables
Sheet: Calendar

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 |  |  |  |  |  |  |  |  | Month | 1 |  | Choose the month and year of interest
2 |  |  |  |  |  |  |  |  | Year | 2016 |  | using the drop-downs in K3:K4
3
4 |  |  |  |  |  |  |  |  | Key:
5 |  |  |  |  |  |  |  |  | English
6 |  |  |  |  |  |  |  |  | Chinese
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
Spreadsheet: 544956d1509116917-conditionally-summing-across-a-varying-number-of-worksheets-copy-of-example-book-allisonns-
Sheet: 2

Stock = | Stock 2 |  |  |  |  | Type = | Fund Type
Date |  | Event |  | Units |  | Transaction amount |  | cu | Year
2016-01-01 00:00:00 |  | Buy |  | 10018 |  | 17065.8
2016-01-20 00:00:00 |  | Dividend |  | 0 |  | 200
2016-02-28 00:00:00 |  | Sell |  | -3256 |  | 11281
2016-03-20 00:00:00 |  | Dividend |  | 0 |  | 150
2016-04-20 00:00:00 |  | Dividend |  | 0 |  | 150
2016-05-02 00:00:00 |  | Sell |  | -3256 |  | 11281
2016-05-20 00:00:00 |  | Dividend |  | 0 |  | 100
2016-06-20 00:00:00 |  | Dividend |  | 0 |  | 100
2016-07-20 00:00:00 |  | Dividend |  | 0 |  | 100
2016-08-05 00:00:00 |  | Buy |  | 1000 |  | 1896.2
2016-08-20 00:00:00 |  | Dividend |  | 0 |  | 110
2016-09-20 00:00:00 |  | Dividend |  | 0 |  | 110
2016-10-20 00:00:00 |  | Dividend |  | 0 |  | 110
2016-11-20 00:00:00 |  | Dividend |  | 0 |  | 110
2016-12-20 00:00:00 |  | Dividend |  | 0 |  | 110
Spreadsheet: chris_germany__2916__1999_2000 Winter Oil Orders
Sheet: JANUARY 2000

Gordonsville Energy LP   (L.S. #2 FUEL OIL ORDERS)
2000-01-01 00:00:00 |  |  | Cost per Gal. Deliv. Excluding VA tax |  |  | Cost per Gal. Deliv. Excluding VA tax | Updated 1/31/2000 |  | Cost per Gal. Deliv. Excluding VA tax
DATE | BP AMOCO                       ORDERS | Order number |  | [NAME]ORDERS | Order number |  | MARATHON/ [NAME]ORDERS | Order number
2000-01-17 00:00:00 |  |  |  |  |  |  | 120000 | MAP-002 | 0.8197
2000-01-18 00:00:00 |  |  |  | 150000 | CIT-003 | 0.8745
2000-01-19 00:00:00 |  |  |  | 240000 | CIT-004 | 0.8745
2000-01-21 00:00:00 |  |  |  | 90000 | CIT-005 | 0.955
2000-01-26 00:00:00 | 165000 | BPA-001 | 0.8312
2000-01-27 00:00:00 |  |  |  | 120000 | CIT-006 | 0.905
TOTAL ORDERED
DRIVE TO MAINTAIN 4.5 MILLION GALLON INVENTORY
1999-12-14 00:00:00 | LAST "STRAPPED" vs [NAME] LEVEL                                (as reference only… available monthly) |  |  | 4,360,000 Strapped            4,365,000 Indicator
2000-02-01 00:00:00 | TANK LEVEL READING @ 10:AM                  as reported by Plant control room |  |  | 3417000
 | TOTAL ORDERED THRU (during) JANUARY
 | Possible Over Delivery
JAN TOTAL | DELIVERED IN JAN. 00                                       per Plant off-load meters |  |  | -291807 | (Deliveries should be shown as negatives to properly calculate the projected level)
 | DELIVERED YESTERDAY, THRU 12:MID                              per Plant Control Room |  |  | 0
 | DELIVERED 12:AM - 10:AM                                 as reported by Plant Control Room |  | See Feb sheet
PROJECTED TANK LEVEL (at completion)
NOTE:
Spreadsheet: 847922d1698769010-help-making-an-annual-leave-calendar-mehhchael-excel-help
Sheet: Sheet1

 |  |  |  |  |  | 2024-04-01 00:00:00
 | Name | A | A-Date | B | B-Date
 | [NAME] | A | 2024-04-08 00:00:00 | B | 2024-05-06 00:00:00 |  | A |  |  |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
 | [NAME] | A |  | B
Spreadsheet: 543597d1508474429-rearrange-database-like-dataset-into-table-for-large-dataset-better-option-index-match-dataset
Sheet: SUMIFS

user_id | Question ID ---> | 19 | 43 | 45 | 4 | 40 | 1 | 3 | 26 | 2 | 49 | 37 | 15 | 28 | 22 | 21 | 29 | 27 | 23 | 11 | 33 | 36 | 25 | 16 | 41 | 30 | 44 | 6 | 8 | 47 | 31 | 34 | 46 | 9 | 38 | 17 | 24 | 35 | 20 | 5 | 10 | 12 | 39 | 7 | 32 | 13 | 48 | 14 | 42 | 18 | 103 | 104 | 105 | 106
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 269788d1381280469-h-lookup-in-different-folders-display-whole-column-file1-2-
Sheet: Feuil1

Choose sector: | Transport | Choose company: | CR
 |  |  |  |  |  |  |  |  |  | Bank1 |  | Finance
 |  |  |  |  |  |  |  |  |  | Bank2 |  | Transport
 |  |  |  |  |  |  |  |  |  | Bank3
 |  |  |  |  |  |  |  |  |  | SNCF
 |  |  |  |  |  |  |  |  |  | DB
 |  |  |  |  |  |  |  |  |  | CR
Spreadsheet: 795661d1662824372-populating-a-team-game-log-from-a-master-schedule-game-schedule-and-log-tim418-
Sheet: Team Game Logs

ATL
Game Date | Opponent | Result (W/L) | RS | RA
Spreadsheet: 818521d1676898675-figure-weight-when-seeing-space-figure-weight-at-space
Sheet: SEQ

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pc Sh:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pc Rem:
PM: |  |  |  |  | PCS: |  |  | TRUCK CUBE: |  |  | SHIP DATE: |  |  |  |  |  |  | Total CF Sh:
TOTAL CUBE: |  |  |  |  | WT: |  |  | NET CUBE: |  |  |  |  |  |  |  |  |  | Total CF Rem:
R | S | P | J | CNC | L | RETURN | SORT | MARK | PCS | CF/PC: | NET CF: | Running CF: | Pcs Sh: | Pcs Rem: | CF Ship: | CF Rem: | ACF: | Truck Weight:
 |  |  |  |  |  |  |  | add | 1 | 2
 |  |  |  |  |  |  |  | ref | 1 | 2.67
 |  |  |  |  |  |  |  | rep | 1 | 4
 |  |  |  |  |  |  |  | 300 | 1 | 1.97 |  |  |  |  |  |  | 1.97
 |  |  |  |  |  |  |  | 362 | 1 | 3.98 |  |  |  |  |  |  | 4.06
 |  |  |  |  |  |  |  | 411 | 1 | 12.42 |  |  |  |  |  |  | 14.12
 |  |  |  |  |  |  |  | 404 | 1 | 10.96 |  |  |  |  |  |  | 12.41
 |  |  |  |  |  |  |  | band | 1 | 0.58 |  |  |  |  |  |  | 0.68
 |  |  |  |  |  |  |  | base | 1 | 3.7 |  |  |  |  |  |  | 3.94
 |  |  |  |  |  |  |  | corner | 1 | 4.78 |  |  |  |  |  |  | 5.16
 |  |  |  |  |  |  |  | rail | 1 | 2.17 |  |  |  |  |  |  | 2.45
 |  |  |  |  |  |  |  | [NAME] | 1 | 0.24 |  |  |  |  |  |  | 0.24
 |  |  |  |  |  |  |  | s cap | 1 | 0.84 |  |  |  |  |  |  | 0.84
 |  |  |  |  |  |  |  | spindle | 1 | 0.3 |  |  |  |  |  |  | 0.38
 |  |  |  |  |  |  |  | 1 | 1 | 3.41 |  |  |  |  |  |  | 5.37
 |  |  |  |  |  |  |  | 2 | 1 | 2.2 |  |  |  |  |  |  | 5.2
 |  |  |  |  |  |  |  | rf | 1 | 1.56
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pc Sh:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Pc Rem:
PM: |  |  |  |  | PCS: |  |  | TRUCK CUBE: |  |  | SHIP DATE: |  |  |  |  |  |  | Total CF Sh:
TOTAL CUBE: |  |  |  |  | WT: |  |  | NET CUBE: |  |  |  |  |  |  |  |  |  | Total CF Rem:
R | S | P | J | CNC | L | RETURN | SORT | MARK | PCS | CF/PC: | NET CF: | Running CF: | Pcs Sh: | Pcs Rem: | CF Ship: | CF Rem: | ACF: | Truck Weight:
 |  |  |  |  |  |  |  | E1 | 1 | 23 |  |  |  |  |  |  | 18.3
 |  |  |  |  |  |  |  | E2 | 1 | 7.44 |  |  |  |  |  |  | 4.87
 |  |  |  |  |  |  |  | E3 | 1 | 6.4 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | E4 | 1 | 4.87 |  |  |  |  |  |  | 5
Spreadsheet: 72458d1273140874-excel-2007-matching-cells-across-different-worksheets-matching-example
Sheet: Sheet1

Style | Stcription | Season | Week | Division | Division group | Class | Country | Currency | Conversion rate to [NAME] | Cost | Initial sales price | Current price
W15004 | [NAME] 09 CHN | 2009W | 2009-08-24 00:00:00 | 15 | Accessories | A1I | UK | GBP | 1.109631 | 5.44 | 15 | 15
W15011 | WILLA MEDSHLDBG 09 CHN | 2009W | 2009-08-24 00:00:00 | 15 | Accessories | A1H | UK | GBP | 1.109631 | 9.68 | 28 | 28
W15012 | WILLA SHOULDBAG 09 CHN | 2009W | 2009-08-24 00:00:00 | 15 | Accessories | A1H | UK | GBP | 1.109631 | 10.66 | 34 | 34
W15040 | [NAME] [NAME] | 2009W | 2009-08-31 00:00:00 | 15 | Accessories | A1H | UK | GBP | 1.109631 | 8.23 | 25 | 25
W15042 | WANDA SHOULDBAG 09 [NAME] | 2009W | 2009-08-31 00:00:00 | 15 | Accessories | A1H | UK | GBP | 1.109631 | 13.29 | 42 | 42
W15043 | WANDA CITY BAG  09 CHN/ | 2009W | 2009-08-31 00:00:00 | 15 | Accessories | A1H | UK | GBP | 1.109631 | 16.65 | 48 | 48
W15047 | WANDA CITYWALLT 09 CHN/ | 2009W | 2009-08-31 00:00:00 | 15 | Accessories | A1I | UK | GBP | 1.109631 | 6.64 | 19 | 19
W15050 | WINNIE BAGUETTE 09 CHN | 2009W | 2009-08-24 00:00:00 | 15 | Accessories | A1H | UK | GBP | 1.109631 | 10.74 | 34
Spreadsheet: a8d3cce5-c2c4-40d9-a503-a41fff7ae0fd
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FAPPN | Test | FAPPN | Atypical Pneumonia DNA Panel Qual | Atypical Pneumonia DNA Panel Qual | Real-Time PCR |  |  |  |  |  | Submit only 1 of the following:   Note: Source is required.   Bronchial Lavage/Bronchial Wash: Collect 1 mL in a sterile container with a leak-proof cap. Ship refrigerate.   [NAME]: Collect 1 mL in a sputum collection kit or a sterile, plastic container with a leak-proof cap. Ship refrigerate.   Throat or Nasopharyngeal Swab: Collect in 3 mL M4 media or V-C-M medium (green-cap) tube or equivalent (UTM). Ship refrigerate. | 0.35 mL | Specimens other than	Bronchial lavage, bronchial wash, sputum, nasopharyngeal swab, throat swab Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | Reference Range: Not detected   Test Performed By:  Focus Diagnostics, Inc.                                        5785 Corporate Avenue                                        Cypress, CA  90630-4750 | Monday through Sunday | 1-3 days | 3-5 days |  | Profile |  |  |  |  | Focus Diagnositics, Inc.
FAPPN | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FAPPN | Order Question | [NAME] | Source |  | Plain Text
FAPPN | Result | [NAME] | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAPPN | Result | [NAME] | M. Pneumoniae DNA | M. Pneumoniae DNA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAPPN | Result | Z2411 | Legionella Species | Legionella Species | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAPPN | Result | Z2412 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAPPN | Result | Z2409 | Chlamydophila Pneumoniae | Chlamydophila Pneumoniae | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FAPPN | Billing Component | FAPPN |  | amplified probe technique, each organism |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87798
FAPPN | Billing Component | FAPPN |  | Legionella pneumophila, amplified probe technique |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87541
FAPPN | Billing Component | FAPPN |  | [NAME] DNA, Qual |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87581
FAPPN | Billing Component | FAPPN |  | Chlamydophila Pneumoniae DNA, Qual |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 87486
Spreadsheet: 112010d1308212745-dynamic-hyperlink-to-cell-value-dynamic-hyperlink-example
Sheet: Sheet1

Price List
Part No. | Product Status | Replacement Part No. | Price
A123 | Active |  | 5
B123 | Obsolete | J123
C123 | Active |  | 10
D123 | Active |  | 7
E123 | Active |  | 8
F123 | Active |  | 5
G123 | Active |  | 5
H123 | Obsolete | AX123
I123 | Active |  | 11
J123 | Active |  | 9
Spreadsheet: 839625d1692117266-stack-formula-column-follow-by-row-stack-formula
Sheet: Sheet1

Dynamic Array 1 | Dynamic Array 2 | Dynamic Array 3 |  | Desired Result with Dynamic Array
 |  |  |  | A
B | 102 | HA |  | 101
C | 103 |  |  | PF
 | 104 |  |  | B
 |  |  |  | 102
 |  |  |  | HA
 |  |  |  | C
 |  |  |  | 103
 |  |  |  | 104
Spreadsheet: 882779d1731250670-reporting-change-from-calendar-year-to-financial-year-adjust-formula-financial-year-reporting
Sheet: Report Generator

Category and Calendar Year | 2020/21 | 2021/22 | 2022/23 | 2023/24 | 2024/25
Consent withdrawal
Access request |  |  |  |  |  | The highlighted cells are returning incorrect values and should be 41 and 38 respectively
Rectification
Erasure
Restriction of processing
Data Portability
Objection to processing
Automated decisions & profiling
Not Valid
Other
Total
Spreadsheet: 152887d1335561982-formula-for-an-aging-report-age-bucket
Sheet: Sheet1

 | Due Date | Total | Days Old | [NAME] |  |  | Minimum | [NAME]
 | 2011-11-30 00:00:00 | 500 | 149 | Older than 120 days |  |  | 0 | 0-29 days old
 | 2011-12-15 00:00:00 | 150 | 134 | Older than 120 days |  |  | 30 | 30-59 days old
 | 2011-12-29 00:00:00 | 200 | 120 | Older than 120 days |  |  | 60 | 60 - 89 days old
 | 2012-01-01 00:00:00 | 300 | 117 | 90 - 119 days old |  |  | 90 | 90 - 119 days old
 | 2012-01-26 00:00:00 | 150 | 92 | 90 - 119 days old |  |  | 120 | Older than 120 days
 | 2012-02-16 00:00:00 | 95 | 71 | 60 - 89 days old
 | 2012-02-18 00:00:00 | 180 | 69 | 60 - 89 days old
 | 2012-03-04 00:00:00 | 160 | 54 | 30-59 days old
 | 2012-03-08 00:00:00 | 140 | 50 | 30-59 days old
 | 2012-04-01 00:00:00 | 1200 | 26 | 0-29 days old
 | 2012-04-12 00:00:00 | 16 | 15 | 0-29 days old
 | 2012-04-26 00:00:00 | 18 | 1 | 0-29 days old
 |  | 0-29 days old | 1234
 |  | 30-59 days old | 300
 |  | 60 - 89 days old | 275
 |  | 90 - 119 days old | 450
 |  | Older than 120 days | 850
Spreadsheet: 295500d1391712567-creating-a-time-off-tracker-for-work-and-i-am-at-a-total-loss-track
Sheet: Time off sheet

Employee Name | Date | Worked from home | PTO Used | Planned/Unplanned | PTO Used2 | Comments | Day of the week
employee e | 2013-12-31 00:00:00
employee l | 2013-12-31 00:00:00
employee e | 2014-01-02 00:00:00
employee a | 2014-01-02 00:00:00
employee f | 2014-01-03 00:00:00
employee k | 2014-01-03 00:00:00
Spreadsheet: 215667d1361451739-auto-populating-a-calendar-from-data-specific-to-tracking-multiple-ship-dates-on-one-date-calendar-1
Sheet: Dates

Date | Description
2013-02-23 00:00:00 | Appointment 1
2011-11-24 00:00:00 | Appointment 2
2011-12-11 00:00:00 | Appointment 3
2011-12-23 00:00:00 | Appointment 4
2012-01-03 00:00:00 | Appointment 5
2012-01-06 00:00:00 | Appointment 6
2012-01-07 00:00:00 | Appointment 7
2012-01-12 00:00:00 | Appointment 8
2012-01-15 00:00:00 | Appointment 9
2012-01-27 00:00:00 | Appointment 10
2012-02-03 00:00:00 | Appointment 11
2012-02-11 00:00:00 | Appointment 12
2012-02-12 00:00:00 | Appointment 13
2012-02-14 00:00:00 | Appointment 14
2012-02-15 00:00:00 | Appointment 15
2012-02-16 00:00:00 | Appointment 16
2012-02-22 00:00:00 | Appointment 17
Spreadsheet: 680023d1590748892-formula-to-lookup-data-with-if-function-sample
Sheet: Sheet1

Reminder Date | Invoice Date | Check
2020-05-26 00:00:00 | 2020-06-01 00:00:00
 | 2020-06-04 00:00:00
 | 2020-06-01 00:00:00
 | 2020-06-02 00:00:00
 | 2020-06-03 00:00:00
 | 2020-06-05 00:00:00
 | 2020-06-06 00:00:00
2020-06-01 00:00:00 | 2020-06-06 00:00:00
Spreadsheet: 04b372d7-ee7d-42ce-b22c-fe993f21e8ba
Sheet: Winchester

 |  |  |  |  | ROOM ASSIGNMENTS |  | Room Detail | Room Type
Building | Room # | Capacity |  |  | Division
WIN | 108 | 28 |  |  | HUM / BUS | 1/2 & 1/2 |  | [NAME]
WIN | 113 | 22 |  |  | Nursing
WIN | 114 | 22 |  |  | CHLSS |  |  | [NAME]
WIN | 115 | 24 |  |  | CSIS |  |  | Comp Lab
WIN | 116 | 24 |  |  | HUM |  |  | Comp Lab
WIN | 207 | 30 |  |  | CHLSS |  |  | [NAME]
WIN | 210 | 30 |  |  | MS |  |  | [NAME]
WIN | 213 | 22 |  |  | HUM |  |  | [NAME]
WIN | 215 | 22 |  |  | CHLSS |  |  | [NAME]
WIN | 216 | 20 |  |  | NS |  |  | Science Lab
WIN | 218 | 40 |  |  | NS / MS | 1/2 & 1/2 |  | [NAME]
 |  |  |  |  |  | Room Allocation
 |  |  |  |  |  | BUS | 0.5
 |  |  |  |  |  | CHLSS | 3
 |  |  |  |  |  | CSIS | 1
 |  |  |  |  |  | HUM | 2 , 1/2
 |  |  |  |  |  | MS | 1,  1/2
 |  |  |  |  |  | Nursing | 1
 |  |  |  |  |  | NS | 1, 1/2
 |  |  |  |  |  |  | 11 rooms total
Spreadsheet: 881078d1728993724-verschachtelte-formel-verschachtelte-formel
Sheet: Input

 | IST |  |  |  |  | Prognose
Name | 2023 | 2022 | 2021 | 2020 |  | 2025 | 2024 | 2023 | 2022
 | 31 | 79 | 66 | 51 |  | 7 | 49 | 53 | 74
 |  |  |  | - |  | -85.71428571428572 | -7.547169811320753 | 4.7 | 2
Hilfszeile | 77 | 50 | 44 | 66 |  | - | - | - | -
 | 57 | 47 | 3 | 98 |  | 27 | 40 | 64 | 5
 | 67 | 70 | 58 | 35 |  | 31 | 20 | 46 | 54
 | 44 | 43 | 96 | 14 |  | 51 | 75 | 98 | 42
 |  |  |  | - |  | 47 | 99 | 27 | 77
Hilfszeile | 8 | 6 | 5 | 10 |  | - | - | - | -
 | 78 | 7 | 16 | 55 |  | 88 | 28 | 98 | 26
 | 24 | 12 | 70 | 51 |  | 37 | 20 | 12 | 66
 | 14 | 95 | 20 | 34 |  | 7 | 22 | 79 | 50
 | 12 | 26 | 36 | 50 |  | 82 | 53 | 98 | 98
 | 68 | 10 | 99 | 48 |  | 52 | 6 | 3 | 8
Hilfszeile | 32 | 43 | 16 | 43 |  | - | - | - | -
Hilfszeile | 23 | 17 | 39 | 21 |  | - | - | - | -
 |  |  |  | 24.7 |  | 71 | 92 | 38 | 84
 | 68 | 15 | 98 | 85 |  | 71 | 44 | 21 | 91
 | 96 | 50 | 40 | 9 |  | 7 | 31 | 44 | 13