tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: matthew_lenhart__26343__Breast Test 2
Sheet: Breast Test II

 | Playboy.com's Breast Test II
 | Directions
 | In the grey box, enter "real" or "fake" (without the quotes).  The right answer will appear in the light blue box.
 | The spreadsheet will automatically calculate your score after the last picture.  (I got 16 out of 20.  The average
 | score on Breast Test I was 12.38 out of 20.)
 | Your score
 | 0-5 | A total bust!  Your homework: Compare the Demi Moore of "About Last Night…" with
 |  | the enhanced version in "Striptease" (or get an eye implant).
 | 6-10 | Did you take this test with a bra over your eyes?  Clearly, you think saline is that annoying
 |  | French-Canadian singer.
 | 11-15 | You racked up a respectable score, but you still might want to enhance your implant insight.
 | 16-19 | You're a natural!  Congratulations, you win the World Cups.
 | 20 | Great job, Mr. [NAME]!
Spreadsheet: 855849d1705332290-paste-filtered-data-in-book-book3
Sheet: April - December 2023

Date | Payee & Memo | Corrected Payee | Amount | Memo | OrigPayee
2023-04-24 00:00:00 | [NAME] |  | 1 |  | [NAME] From [NAME] [PHONE]
2023-04-26 00:00:00 | [NAME] |  | 1360 |  | [NAME] From [NAME] [PHONE]
2023-04-26 00:00:00 | [NAME] |  | 235 |  | [NAME] From Diane Lucas Bach2Cawroed
2023-04-26 00:00:00 | Tiante Wade |  | 130 |  | [NAME] From Tiante Wade Cof0Ucuxf31P
2023-04-27 00:00:00 | Crystal Mcnellage |  | 225 |  | [NAME] From Crystal Mcnellage Cti3Aallerbq
2023-04-27 00:00:00 | Bianca Cosme |  | 95 |  | [NAME] From Bianca Cosme [PHONE]
2023-04-28 00:00:00 | [NAME] |  | 100 |  | [NAME] From Toni Fletcher Nav0Hu6Pu5P1
2023-04-28 00:00:00 | Isabelle [NAME] |  | -175 |  | [NAME] To Pastel Cupcakes [PHONE]
2023-04-28 00:00:00 | [NAME] |  | -70 |  | Zelle Payment To Mone Brazell [PHONE]
2023-04-28 00:00:00 | [NAME] I Greene |  | -100 |  | Zelle Payment To Mone Brazell [PHONE]
2023-08-01 00:00:00 | [NAME] |  | 400 |  | [NAME] From Isabelle [NAME]
2023-08-01 00:00:00 | Brea Z Grate |  | 155 |  | [NAME] From Safia D Williams-Laville [PHONE]
2023-08-02 00:00:00 | Tiffany A Thomas |  | 95 |  | [NAME] From Tatiyana I Greene [PHONE]
2023-08-02 00:00:00 | [NAME] |  | 65 |  | [NAME] From [NAME] Bacbvlvcxft0
2023-08-03 00:00:00 | Shontel Campbellsalmon |  | 276.5 |  | Real Time Transfer Recd From Aba/021000021 From: [NAME]: T200641614046 Info: Iid: 20230803021000021P1Brjpm00050064544 Recd: 15:41:48 Trn: 0342480215Rw
2023-08-03 00:00:00 | [NAME] |  | 146.43 |  | Real Time Transfer Recd From Aba/021000021 From: [NAME]: T200641717102 [NAME]: Iid: 20230803021000021P1Brjpm00510082620 Recd: 20:19:10 Trn: 0557830215Rv
2023-08-04 00:00:00 | Precious Boyd |  | 195.93 |  | Real Time Transfer Recd From Aba/021000021 From: [NAME]: T200642156202 Info: Iid: 20230804021000021P1Brjpm00520067969 Recd: 15:08:57 Trn: 0352781216Ru
2023-08-04 00:00:00 | Rhea [NAME] |  | 150 |  | [NAME] From Brea Z Grate [PHONE]
2023-08-04 00:00:00 | [NAME] |  | 125 |  | [NAME] From Tiffany A Thomas [PHONE]
Spreadsheet: 880196d1727816878-drop-down-list-small-problem-categories
Sheet: Arkusz1

works well (I select a category and then the appropriate product) |  |  |  |  |  |  |  |  | I have a problem here
Cat1 |  | Cat1 | Product 1 cat1 |  | Drop down list 1 : | Cat1 |  |  | Cat1 |  | Cat1 | Product 1 cat1 | 1 |  | Choose1 : | Cat4
Cat2 |  | Cat1 | Product 2 cat1 |  | Drop down list 2: | Product 1 cat4 |  |  | Cat2 |  | Cat1 | Product 2 cat1 | 1 |  | Choose2: | Product 2 cat4 | <-- | after selecting the category above I want to display only those products (from the selected category) with status 1 and I don't know how to do it
Cat3 |  | Cat1 | Product 3 cat1 |  |  |  |  |  | Cat3 |  | Cat1 | Product 3 cat1 | 0
Cat4 |  | Cat1 | Product 4 cat1 |  |  |  |  |  | Cat4 |  | Cat1 | Product 4 cat1 | 0
 |  | Cat2 | Product 1 cat2 |  |  |  |  |  |  |  | Cat2 | Product 1 cat2 | 1
 |  | Cat2 | Product 2 cat2 |  |  |  |  |  |  |  | Cat2 | Product 2 cat2 | 1
 |  | Cat2 | Product 3 cat2 |  |  |  |  |  |  |  | Cat2 | Product 3 cat2 | 1
 |  | Cat2 | Product 4 cat2 |  |  |  |  |  |  |  | Cat2 | Product 4 cat2 | 1
 |  | Cat2 | Product 5 cat2 |  |  |  |  |  |  |  | Cat2 | Product 5 cat2 | 0
 |  | Cat2 | Product 6 cat2 |  |  |  |  |  |  |  | Cat2 | Product 6 cat2 | 0
 |  | Cat2 | Product 7 cat2 |  |  |  |  |  |  |  | Cat2 | Product 7 cat2 | 0
 |  | Cat3 | Product 1 cat3 |  |  |  |  |  |  |  | Cat3 | Product 1 cat3 | 1
 |  | Cat3 | Product 2 cat3 |  |  |  |  |  |  |  | Cat3 | Product 2 cat3 | 1
 |  | Cat3 | Product 3 cat3 |  |  |  |  |  |  |  | Cat3 | Product 3 cat3 | 1
 |  | Cat3 | Product 4 cat3 |  |  |  |  |  |  |  | Cat3 | Product 4 cat3 | 1
 |  | Cat3 | Product 5 cat3 |  |  |  |  |  |  |  | Cat3 | Product 5 cat3 | 0
 |  | Cat3 | Product 6 cat3 |  |  |  |  |  |  |  | Cat3 | Product 6 cat3 | 0
 |  | Cat3 | Product 7 cat3 |  |  |  |  |  |  |  | Cat3 | Product 7 cat3 | 0
 |  | Cat3 | Product 8 cat3 |  |  |  |  |  |  |  | Cat3 | Product 8 cat3 | 0
 |  | Cat4 | Product 1 cat4 |  |  |  |  |  |  |  | Cat4 | Product 1 cat4 | 1
 |  | Cat4 | Product 2 cat4 |  |  |  |  |  |  |  | Cat4 | Product 2 cat4 | 1
 |  | Cat4 | Product 3 cat4 |  |  |  |  |  |  |  | Cat4 | Product 3 cat4 | 1
 |  | Cat4 | Product 4 cat4 |  |  |  |  |  |  |  | Cat4 | Product 4 cat4 | 0
 |  | Cat4 | Product 5 cat4 |  |  |  |  |  |  |  | Cat4 | Product 5 cat4 | 0
Spreadsheet: d54d441a-718a-4958-aa5a-f9ec1a7a9ddd
Sheet: Worldwide Gross Sales

MATTEL, INC. AND SUBSIDIARIES
[NAME] INFORMATION (Unaudited)
 |  |  |  |  | 2 0 1 1 |  | 2 0 1 2
(In millions, except percentage information) |  |  |  |  | 1 Qtr |  | 1 Qtr
[NAME] Sales:
Mattel Girls & Boys Brands |  |  |  | $ | 650.8 | $ | 622.2
 | % Change |  |  |  | 0.15 |  | -0.04
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 1 |  | -1
Fisher-Price Brands |  |  |  |  | 309.9 |  | 310.2
 | % Change |  |  |  | -0.02 |  | 0
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 1 |  | -2
American Girl Brands |  |  |  |  | 73 |  | 76
 | % Change |  |  |  | 0.04 |  | 0.04
Other |  |  |  |  | 7.4 |  | 8.8
Gross Sales |  |  |  | $ | 1041.1 | $ | 1017.2
 | % Change |  |  |  | 0.08 |  | -0.02
 | Pos./(Neg.) Impact of Currency (in % pts) |  |  |  | 0 |  | -1
Reconciliation of Non-GAAP to GAAP Financial Measure:
Gross Sales |  |  |  | $ | 1041.1 | $ | 1017.2
[NAME] |  |  |  |  | -89.2 |  | -88.8
Net Sales |  |  |  | $ | 951.9 | $ | 928.4
 | % Change |  |  |  | 0.08 |  | -0.02
The financial information included herein should be read in conjunction with Mattel's consolidated financial statements and related notes in its Annual Reports on Form 10-K and/or Quarterly Reports on Form 10-Q, as applicable.
Spreadsheet: 8c5146b9-a064-4db7-870a-d6b224cd7fb4
Sheet: Sheet1

2004-09-14 00:00:00 | UNITED STATES SENATOR - REPUBLICAN | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Belknap County | Alciere, r | [NAME], r | Tipa, r | Haddock, d | scattered
Alton | 22 | 258 | 11
Barnstead | 9 | 173 | 10 |  | 3
Belmont | 7 | 224 | 15 | 2
Center Harbor | 2 | 111 | 4
Gilford | 11 | 423 | 13
Gilmanton | 9 | 147 | 6 |  | 2
[NAME] | 2 | 181 | 4
[NAME] | 5 | 131 | 4 | 1 | 1
[NAME] 3 | 6 | 113 | 1
[NAME] | 5 | 118 | 7 |  | 1
[NAME] | 5 | 70
[NAME] 6 | 3 | 151 | 2
Meredith | 14 | 436 | 10 | 1 | 7
New Hampton | 4 | 154 | 9 |  | 2
Sanbornton | 8 | 144 | 4 | 2 | 1
[NAME] | 2 | 168 | 8 |  | 5
TOTALS | 114 | 3002 | 108 | 6 | 22
 | UNITED STATES SENATOR - REPUBLICAN
Carroll County | Alciere, r | [NAME], r | Tipa, r | Haddock, d | scattered
Albany | 2 | 36
[NAME] | 7 | 139 | 3 | 2
[NAME] | 1 | 64
Chatham |  | 21
Conway | 7 | 234 | 6 | 33
Eaton | 2 | 23
[NAME] | 5 | 46 | 1
Freedom | 1 | 60 | 5
Hale's Location |  |  |  | 1
Hart's Location |  | 7 | 2
[NAME] | 5 | 80 | 6
[NAME] | 2 | 97 | 3
Moultonborough | 15 | 235 | 6
Ossipee | 6 | 206 | 4
Sandwich | 4 | 104 | 6 | 1
Tamworth | 4 | 112 |  |  | 2
Tuftonboro | 5 | 164 | 5 |  | 1
Wakefield | 5 | 220 | 5
Wolfeboro | 10 | 356 | 5
TOTALS | 81 | 2204 | 57 | 37 | 3
Spreadsheet: 46726e10-3e1c-4278-a1d4-80b6d756e569
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Calculating Expected Body Weight for Various               Degrees of Dehydration
 |  | Enter Body Weight
 |  |  |  | 0.01 | 0.02 | 0.03 | 0.04 | 0.05
 |  | 160 | 150 | 158.4 | 156.8 | 155.2 | 153.6 | 152
Spreadsheet: 137990d1327458301-sum-cell-based-on-criteria-countif-formula-assistance-test
Sheet: Sheet1

 |  |  |  |  |  | 1 | 2
 |  |  |  |  |  | A |  | x
 |  |  | A | B |  |  | B
 |  | x | 0 | 2 |  |  | B
 |  | y
 |  | z | 1 | 0 |  |  | B
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | z
 |  |  |  |  |  | A
 |  |  |  |  |  | A
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  | A
 |  |  |  |  |  | A
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | B
 |  |  |  |  |  |  | B
Spreadsheet: 793583a4-61ec-41ed-bf7c-12db117212fb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Patapsco and Back Rivers for all available years | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
Indicator | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009
Chlorophyll a | 14.21 | 16.67 | 7.11 | 0 | 0 | 14.21 | 0 | 23.77 | 10.05 | 0 | 0 | 9.47 | 8.53 | 0 | 7.11 | 2.46 | 0 | 0 | 8.53 | 0 | 0 | 0 | 0 | 0
Aquatic Grasses | 0 | 0 | ND | 0 | 0 | 0 | 0 | 0 | 0.24 | 0 | 1.46 | 1.23 | 3.72 | 0 | 0 | 0 | 2.03 | 1.68 | 54.8 | 71.68 | 11.44 | 2.33 | 5 | 3
[NAME] | 55.7 | 66.22 | 60.54 | 61.87 | 64.47 | 60.07 | 56.45 | 59.72 | 59.34 | 53.24 | 60.39 | 64.69 | 55.09 | 55.71 | 49.51 | 54.78 | 57.37 | 48.29 | 54.77 | 54.29 | 51.65 | 57.37 | 59 | 46.202
[NAME] | ND | ND | ND | ND | ND | ND | ND | ND | ND | ND | 33.33 | 55.56 | 50 | 16.67 | 0 | 66.67 | 27.27 | 55.56 | 25 | 29.41 | 14.29 | 83.33 | 44 | 54.54545455
Water Clarity | 0 | 0 | 8.66 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6.56 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Phytoplankton Index | 18.18 | 18.18 | 0 | 54.55 | 18.18 | 9.09 | 27.27 | 45.45 | 18.18 | 0 | 12.5 | 11.11 | 20 | 0 | 0 | 0 | 0 | 10 | 20 | 10 | 0 | 10 | 10 | 10
Water Quality Index | 42 | 27.63 | 25.44 | 20.62 | 21.49 | 24.76 | 18.82 | 27.83 | 23.13 | 17.75 | 20.13 | 24.72 | 21.21 | 20.76 | 18.87 | 19.08 | 19.12 | 16.1 | 21.1 | 18.1 | 17.22 | 19.12 | 20 | 15.40066667
Biotic Index | 9.09 | 9.09 | Insufficient Data | 27.27 | 9.09 | 4.55 | 13.64 | 22.73 | 9.21 | 0 | 15.76 | 22.63 | 24.57 | 5.56 | 0 | 22.22 | 9.77 | 22.41 | 33.27 | 37.03 | 8.58 | 31.89 | 20 | 22.51515152
Bay Health Index | 25.54 | 18.36 | Insufficient Data | 23.95 | 15.29 | 14.65 | 16.23 | 25.28 | 16.17 | 8.87 | 17.95 | 23.68 | 22.89 | 13.16 | 9.44 | 20.65 | 14.44 | 19.25 | 27.18 | 27.56 | 12.9 | 25.51 | 19.71 | 18.95790909
Spreadsheet: 104332d1301977018-excel-2007-excel-2007-compare-2-columns-for-inventory-reorder-levels-cfstockreorder
Sheet: Sheet1

ReOrder Level | In Stonk
Spreadsheet: 737492d1624444836-power-query-m-code-formula-to-produce-a-detailed-customers-ledge-m-code-formula
Sheet: Transactions

 | Date | Details | Customer Code | Customer Name | Receipt | Invoice | Amount
 | 2021-01-01 00:00:00 | Opening Balance | 12 | [NAME] |  |  | 1000
 | 2021-01-01 00:00:00 | Opening Balance | 20 | [NAME] |  |  | 0
 | 2021-01-01 00:00:00 | Opening Balance | 13 | [NAME] |  |  | 100
 | 2020-01-10 00:00:00 | Sales | 12 | [NAME] |  | C0020 | 1145
 | 2020-01-10 00:00:00 | Sales | 13 | [NAME] |  | C0021 | 1010
 | 2020-01-12 00:00:00 | Sales | 20 | [NAME] |  | C0022 | 1020
 | 2020-01-12 00:00:00 | Sales | 12 | [NAME] |  | C0023 | 1030
 | 2020-01-14 00:00:00 | Sales | 13 | [NAME] |  | C0024 | 1040
 | 2020-01-14 00:00:00 | Sales | 12 | [NAME] |  | C0025 | 1050
 | 2020-01-12 00:00:00 | Receipts | 12 | [NAME] | R100 | C0020 | 1145
 | 2020-01-13 00:00:00 | Receipts | 13 | [NAME] | R101 | C0021 | 900
 | 2020-01-14 00:00:00 | Receipts | 3 | [NAME] | R102 | C006 | 1200
 | 2020-01-19 00:00:00 | Receipts | 12 | [NAME] | R103 | C0023 | 700
 | 2020-01-20 00:00:00 | Receipts | 13 | [NAME] | R104 | C0024 | 1040
Spreadsheet: 728955d1618832546-formula-for-percentage-reduction-of-numbers-from-new-base-number-question
Sheet: Sheet1

[NAME] of quantities |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.18
No | Position | Unit | Quality | Single Price-no Vat | Total Price- no Vat | Single price-with [NAME] | Total Price-with [NAME] |  |  | 1. Our predicted prices are F12 cell ([NAME]) without VAT or H12 cell(1066838 EU) with [NAME].
1 | Excavation of earth from 3 and 4 category for pillars and with dimensions of foundation 0.8 * 0.8 * 1.3 | m3 | 20.8 | 500 |  |  |  |  |  | 2. After auction the prices are reduced F12=803090 and H12=947646,20
2 | Excavation of earth of 3 and 4 category with dimensions 0.4 * 0.8 for laying supply distribution cables | m3 | 320 | 280 |  |  |  |  |  | 3.Problem: How to reduce single prices according the after action total price, is there a excel formula for that?
3 | Procurement and installation of fine sand 10 cm below and 10 cm above the cable | m3 | 80 | 490
4 | Re-burial of the excavated soil in the ditch | m3 | 240 | 30
5 | Loading and transport of surplus land in the length of 5 km | m3 | 100.8 | 600
6 | Steel pillar with a height of 10m | No. | 25 | 15000
7 | Construction of concrete foundation with concrete brand MB 20 for columns, with built-in anchor plate and pipe Ф50 mm for input-output of cables: -0.8 * 0.8 * 1.3 | No. | 25 | 4500
8 | Procurement and laying of cable in an already excavated trench | m | 1070 | 98
9 | Procurement and installation of galvanized steel strip FeZn 30x4mm in an already excavated trench with power lines and its connection with appropriate cross plates and screws for grounding the columns | m | 1070 | 98
 |  |  |  | Total
Spreadsheet: 149191d1333737762-chart-formatting-error-sample
Sheet: YTD Chart

OCR Bed Loss YTD 2012 by Division, By Reason
[NAME] | Northeast | Northeast | Mideast | Central | Southeast | West | Total
 | Pricing  (right axis) | All other
Closed | 0 | 182 | 76 | 331 | 90 | 61 | 740 |  |  | 37 | 68 | 298 | 19 | 61
Collections | 0 | 140 | 367 | 1082 | 197 | 0 | 1786 |  |  | 0 | 367 | 849 | 29 | 0
JV | 0 | 1045 | 500 | 0 | 359 | 673 | 2577 |  |  | 1045 | 254 | 0 | 0 | 673
Other | 0 | 262 | 139 | 281 | 214 | 1040 | 1936 |  |  | 245 | 66 | 177 | 214 | 293
Per Diem | 0 | 30 | 0 | 0 | 0 | 665 | 695 |  |  | 30 | 0 | 0 | 0 | 178
Pricing | 13388 | 0 | 221 | 307 | 36 | 864 | 14816 |  | 13348 |  | 42 | 75 | 36 | 96
Service | 0 | 3446 | 1635 | 678 | 492 | 1087 | 7338 |  |  | 2642 | 928 | 591 | 110 | 624
Sold/Under New Mgt. | 0 | 0 | 571 | 433 | 266 | 141 | 1411 |  |  | 0 | 400 | 383 | 91 | 54
Total | 13388 | 5105 | 3509 | 3112 | 1654 | 4531 | 31299
Spreadsheet: 820179d1677903998-formulas-in-table-change-when-adding-new-lines-create-unique-entry-1-
Sheet: Sheet1

Total Distinct
Week Closed | 2023-01-01 00:00:00
Object | Observation | Datapoint | Datapoint2 | Week Closed
ABC
ABC
ABC
DEF
GHI
GHI
Spreadsheet: 81610d1281716899-complicated-if-then-dummy
Sheet: Sheet1

[NAME] | Y
[NAME] | E
[NAME] | N
Michelle | Y
[NAME] | E
Kelly | N
Corinne | Y
[NAME] | N
[NAME] | Y
[NAME] | N
Spreadsheet: 216942d1361929912-microeconomics-market-equlibrium-illistrations-equilibrium
Sheet: Sheet1

 |  | 5 | 50
 | 0.01
Spreadsheet: feb6da97-cd7a-44af-ad74-cd7fe6e4d535
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
EHRC | Test | EHRC | Ehrlichia chaffeensis (HME) Antibody, IgG, Serum | Ehrlichia Chaffeensis (HME) Ab, IgG | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Heat-inactivated specimen | <1:64 | Monday through Friday; 9 a.m. | Same day/1 day | 3 days | 1 | 86666 |  |  |  |  | Rochester
EHRC | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EHRC | Result | 81478 | Ehrlichia Chaffeensis (HME) Ab, IgG | Ehrlichia Chaffeensis (HME) Ab, IgG | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 47405-6 | Ehrlichia chaffeensis [NAME].IgG:Titr:Pt:Ser:Qn:IF
Spreadsheet: 794880d1662378235-absence-trackershowing-extra-days-in-some-months-how-to-fix-employee-absence-tracker
Sheet: March Abs Data

 |  |  | PLEASE NOTE:  The start day is the first day of leave/sickness and the end date is the last day of leave/sickness and NOT the day that they retun to work
 | Employee Name | Start Date | End Date | Type of Leave | Reason for Sickness Absence | Other reasons for Leave Of Absence | Days | Self Cert Completed | Teaching / Non Teaching | Continued absence from previous month? | Has a Doctors Note been submitted? | Doctors Note Start | Doctors Note End | Is the [NAME] ongoing at the end of the month
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-30 00:00:00 | Sickness Absence | Heart (Pressure, Circulation etc)
 | Employee 1 | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | Sickness Absence | Mental Health (Stress / Anxiety etc)
 | Employee 1 | 2022-08-10 00:00:00 | 2022-08-12 00:00:00 | Sickness Absence | Back / Neck
 | Employee 1 | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | Dependant Care Paid
 | Employee 1 | 2022-08-24 00:00:00 | 2022-08-26 00:00:00 | Compassionate Paid
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-29 00:00:00 | Leave of Absence Paid |  | Fertility
 | Employee 1 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | Leave of Absence Unpaid |  | Study Leave
 | Employee 1 | 2022-05-05 00:00:00 | 2022-05-15 00:00:00 | Dependant Care Unpaid
 | Employee 1
 | Employee 1
Spreadsheet: 118442d1313690055-matching-test
Sheet: CY11 Q3

Date | Last Name | Location |  |  |  | State | # of duplicate names for that state
2011-07-18 00:00:00 | [NAME] | Delaware
2011-07-18 00:00:00 | [NAME] | Alabama
2011-07-18 00:00:00 | [NAME] | Colorado
2011-07-18 00:00:00 | [NAME] | Alabama
2011-07-18 00:00:00 | SCOTT | New York
2011-07-18 00:00:00 | JONES | Alaska
2011-07-18 00:00:00 | JONES | Alaska
2011-07-19 00:00:00 | JONES | Alabama
2011-07-19 00:00:00 | BRANDON | California
2011-07-20 00:00:00 | MONTGOMERY | Missouri
2011-07-20 00:00:00 | [NAME] | Kansas
2011-07-20 00:00:00 | [NAME] | Alabama
2011-07-20 00:00:00 | JUSTIN SPENCER
2011-07-20 00:00:00 | [NAME]
2011-07-20 00:00:00 | [NAME]
2011-08-10 00:00:00 | LYNCH JAMES
2011-07-25 00:00:00 | MARKWOOD CHRISTOPHER M
2011-07-25 00:00:00 | BRENNAN STEPHANIE A
2011-07-25 00:00:00 | BRANDON HILL | Georgia
Spreadsheet: 264350d1378850368-associating-cells-so-that-sorting-them-maintains-relationship-on-another-worksheet-yankplayer87
Sheet: Payroll

Pay date | Employee number | First Name | Last name | Pay Rate | Pay Source | Hours | Total
2013-01-31 00:00:00 | E001 |  |  |  |  | 35
2013-01-31 00:00:00 | E002 |  |  |  |  | 36
2013-01-31 00:00:00 | E003 |  |  |  |  | 37
2013-01-31 00:00:00 | E004 |  |  |  |  | 38
2013-01-31 00:00:00 | E005 |  |  |  |  | 39
2013-01-31 00:00:00 | E006 |  |  |  |  | 35
31 Jan 13 Total
2013-02-28 00:00:00 | E007 |  |  |  |  | 36
2013-02-28 00:00:00 | E008 |  |  |  |  | 40
2013-02-28 00:00:00 | E009 |  |  |  |  | 35
2013-02-28 00:00:00 | E001 |  |  |  |  | 32
2013-02-28 00:00:00 | E002 |  |  |  |  | 40
2013-02-28 00:00:00 | E003 |  |  |  |  | 50
28 Feb 13 Total
2013-03-31 00:00:00 | E004 |  |  |  |  | 45
2013-03-31 00:00:00 | E005 |  |  |  |  | 39
2013-03-31 00:00:00 | E006 |  |  |  |  | 12
31 Mar 13 Total
Grand Total
Spreadsheet: 733020d1621356263-help-with-formula-copy-from-one-area-to-another-to-simplify-view-scheduling-file-not-working-v2
Sheet: Teams Entered

# | Team Name | GS | GP | Win | Loss | Tie | Runs Against | Runs For | [NAME] | RPG | [NAME] | Win %
1 | Reno Huskies
2 | McQueen Lancers
3 | Bishop Manogue Miners
4 | Spanish Springs Cougars
5 | Damonte Ranch Mustangs
6 | Carson Senators
7 | Reed Raiders
8 | [NAME]
9 | Galena Grizzlies
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: 821395d1678695650-help-with-recurring-bills-formula-between-2-dates-and-payday-periods-bills-2023-ans
Sheet: 2022 (Paul)

Bills 2023
DATE | PRODUCT | TYPE | COST | Column1 | Luxury |  | House |  | Pets |  | Vehicles |  | Family |  | Credit |  | Left |  |  |  | Pay Dates
1 | [NAME] | Credit | 215.93
1 | [NAME] | Vehicle | 55.12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-03 00:00:00
2 | [NAME] | House | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-17 00:00:00
8 | [NAME] | Credit | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-03-31 00:00:00
9 | Bill 5 | Family | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-14 00:00:00
12 | Bill 6 | Luxury | 6.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-04-28 00:00:00
15 | [NAME] | House | 187.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-12 00:00:00
18 | [NAME] | Credit | 14.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-05-26 00:00:00
18 | Bill 9 | Luxury | 14.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-09 00:00:00
20 | Bill 10 | Vehicle | 47.28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-06-23 00:00:00
20 | Bill 11 | Family | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-07 00:00:00
21 | Bill 12 | Vehicle | 28.52 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-21 00:00:00
22 | Bill 13 | Luxury | 7.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-04 00:00:00
22 | Bill 14 | Luxury | 11.99 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-27 00:00:00
Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-10 00:00:00
Income |  |  | 2323.96 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-24 00:00:00
Left |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-01-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-02-16 00:00:00
 |  |  |  |  |  | This pay
 |  |  |  |  |  | From | To | Total |  |  | Today
 |  |  |  |  |  |  |  |  |  |  | This Pay
 |  |  |  |  |  |  |  |  |  |  | Next Pay
Spreadsheet: 138578d1327741486-validating-hourly-rates-timekeeping
Sheet: Sheet1

Name | Basic | [NAME] per Hour | Shift Start | Shift End | Hours w/ Night diff | Hours With Night diff | Night Differential | Total Salary
[NAME] | 10000 | 1250 | 21:00:00 | 1900-01-01 06:00:00 |  |  | 0.1
Seph | 10000 | 1250 | 20:00:00 | 1900-01-01 05:00:00 |  |  | 0.1
Nick | 10000 | 1250 | 18:00:00 | 1900-01-01 03:00:00 |  |  | 0.1
Com | 10000 | 1250 | 23:00:00 | 1900-01-01 09:00:00 |  |  | 0.1
Night Differential
11PM to 6AM
night differential falls from 11PM to 6AM.  Its rate per hour is paid at 10%