tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 135480d1326093224-total-count-within-date-range-sample-file
Sheet: Sheet1

Empl. No. | Employee Name | DOJ | DOB
2 | ASDF | 23.03.2008 | 02.01.1977
3 | GGH | 22.11.2009 | 07.08.1979
5 | DG | 01.10.2009
465 | EW | 19.06.2011 | 21.12.1972
9879 | GHJ | 17.04.2011 | 14.08.1968
46546 | SF | 23.05.2010 | 25.04.1988
899 | WEEE | 01.03.2009 | 16.06.1986
4651 | ASDF | 04.10.2009 | 06.09.1986
465456 | HHJ | 06.12.2009 | 02.07.1985
13213 | WER | 11.04.2010 | 21.02.1988
46565 | SADFADS | 18.04.2010 | 02.11.1986
165 | FHG | 30.05.2010 | 04.05.1987
465 | REWT | 06.06.2010 | 06.12.1986
45665 | RTEWR | 15.05.2011 | 10.02.1988
16546 | SDFG | 08.11.2009 | 03.09.1973
465 | DSFG | 16.03.2010 | 03.06.1986
4565 | GSFD | 18.07.2010 | 04.08.1988
Spreadsheet: 126054d1319494722-compiling-data-from-multiple-work-sheets-goodwill
Sheet: 9-30-2011

[NAME] |  | 2011-09-30 00:00:00
Quan. | Item | Net  Value | Gross Value
1 | 2000 Venture Headlamp | 65
1 | Black Leather Computer Chair | 40
1 | Kids Castle Set | 30
1 | Kids Play Foam Squares  Rug | 20
3 | Hockey Sticks | 25
1 | Kitchen Clock | 15
1 | Large [NAME] | 20
1 | 100 Ft Extention Cord | 20
1 | 50 Ft Extention Cord | 15
2 | 25 Ft Extention Cord | 10
1 | Pants | 7
7 | Shirt | 5
1 | Leather Boots | 15
1 | Cordless Telephone | 35
1 | Swivel Picture Frame | 10
1 | Shower Curtain Rings | 4
4 | Shoe Trees (pair) | 4
2 | Complete Sets of Sheets | 15
1 | New MP4 Player | 75
2 | Towels | 3
1 | New Candle | 3
1 | [NAME] | 2
10 | Miscelaneous Kitchen Items | 2
1 | New Adidas Tennis Shoes | 30
2 | Book | 4
10 | Tie | 2
1 | Laptop Computer IBM With Dock | 75
1 | Infant Dishwasher Basket | 3
1 | [NAME] Shoes | 10
1 | Faux Leather Boots | 10
1 | Sweater | 5
1 | Thumb Nailer | 200
1 | Irrigation Slip Connector (Sprinkler) | 20
Spreadsheet: daren_farmer__5735__HPLN0222
Sheet: Sheet1

[NAME] |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - February 22, 2001
 |  |  |  |  |  | **Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-02-22 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 875067d1721639582-generate-unique-id-test-book-1-1-
Sheet: Sheet1

ID | Date | Name | Customer
 | 2024-07-22 00:00:00 | Reece - RU | x | Manual
220724RU2 | 2024-07-22 00:00:00 | Reece - RU | y
220724RU1 | 2024-07-22 00:00:00 | Reece - RU | x
250724SH1 | 2024-07-25 00:00:00 | [NAME] | z
250724BW1 | 2024-07-25 00:00:00 | [NAME] | c
250724SH2 | 2024-07-25 00:00:00 | [NAME] | c
Spreadsheet: 483820d1475861419-how-to-track-this-by-hours-and-not-days-employee-attendance-orginal
Sheet: Calendar View

 | EMPLOYEE ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select an Employee: |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select a Year: |  |  |  |  |  |  |  |  | 2016
 |  |  |  |  |  |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PTO |  |  |  |  |  |  | CME
Spreadsheet: scott_neal__37916__STOR9814
Sheet: STOR951

ENRON CAPITAL & TRADE RESOURCES |  |  |  |  |  |  |  |  |  |  |  |  |  | Confidential - For Internal Use Only
STORAGE UPDATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | File: STOR9814
Below is a summary of the estimated storage working gas levels
for the week ending: |  |  | 2001-01-12 00:00:00
 |  | Gas In Stg | Gas in | Quantity | Percent | Percent |  |  |  |  | Last Year | Three | Five | Quantity | Quantity | Quantity
 |  | Prev Week | Storage | Change | Change | of Full |  |  |  |  | Same | Year | Year | Change From | Change From | Change From
U.S. Region |  | (Bcf) | (Bcf) | from last week | from last week | Capacity |  |  |  |  | Week | Average | Average | last year | 3 year avg. | 5 year avg.
Production Area |  | 350 | 323
(TX, LA, OK, KS, MS)
Market Area - East |  | 935 | 872
Market Area - West |  | 277 | 264
TOTAL U.S.
MONTH TO DATE
Enron Gas Services |  |  | 36.2 | 0 | 0 | 0.924 |  |  |  |  | ECTR is refilling [NAME] as third parties
(as of 1/20/95) |  |  |  |  |  |  |  |  |  |  |  |  |  | are withdrawing, this keeping our
 |  |  |  |  |  |  |  |  |  |  |  |  |  | total position flat for the week.
AGA FULL CAPACITY |  |  | 3294 |  |  |  |  |  |  |  |  |  |  | 3294 | 3294 | 3294
Maximum Gas In Stg Level (Bcf) |  |  | 3127 |  |  |  |  |  |  |  |  |  |  | 3127 | 2832 | 2915
Minimum Gas In Stg Level (Bcf) |  |  | 1335 |  |  |  |  |  |  |  |  |  |  | 1006 | 794 | 871
Spreadsheet: 688211d1595623346-how-to-return-pay-value-looking-at-two-criteria-copy-of-pt-aniverasry-raises-for-upload
Sheet: Sheet2

EMPLOYEE |  | Rank | HIRE DATE | STEP | Step aniversary dates |  |  |  |  |  |  | Stipends |  |  |  | Current Hourly Rate
Number | Name |  |  |  | < THAN 12 MONTHS | 12 - 47 MONTHS | 48 -95 Months | 96 - 131 months | 132 - 179 months | 180 PLUS | BASE PAY | Engineer Pay | FF 3/ AOF | HAZMAt Tech | Loyalty
 |  |  |  |  | STEP 1 | STEP 2 | STEP 3 | STEP 4 | STEP 5 | STEP 6
374 |  | FF/EMT-P | 2004-03-15 00:00:00 | 6 |  |  |  |  |  |  |  | 1 | 0.1 |  | 1
540 |  | FF/EMT-B | 2006-11-03 00:00:00 | 5 |  |  |  |  |  |  |  |  |  |  | 1
854 |  | FF/EMT-P | 2016-02-03 00:00:00 | 3 |  |  |  |  |  |  | 17.6281
901 |  | FF/EMT-P | 2016-10-31 00:00:00 | 2 |  |  |  |  |  |  | 17.6281
953 |  | FF/EMT-P | 2018-05-19 00:00:00 | 2 |  |  |  |  |  |  |  |  |  |  |  | 18.0688
954 |  | FF/EMT-P | 2018-06-25 00:00:00 | 2 |  |  |  |  |  |  |  |  |  |  |  | 18.0688
963 |  | FF/EMT-P | 2018-12-13 00:00:00 | 2 |  |  |  |  |  |  | 16.0062 |  |  |  |  | 18.0688
969 |  | FF/EMT-B | 2019-02-05 00:00:00 | 2 |  |  |  |  |  |  | 16.0062
978 |  | FF/EMT-B | 2019-06-17 00:00:00 | 2 |  |  |  |  |  |  | 16.0062
979 |  | FF/EMT-P | 2019-06-18 00:00:00 | 2 |  |  |  |  |  |  | 16.0062 |  |  |  |  | 18.0688
981 |  | FF/EMT-B | 2019-06-16 00:00:00 | 2 |  |  |  |  |  |  | 16.0062
994 |  | FF/EMT B | 2020-01-23 00:00:00 | 1 |  |  |  |  |  |  | 10 |  |  |  |  | 16.4064
997 |  | FF/EMT B | 2020-02-12 00:00:00 | 1 |  |  |  |  |  |  | 10 |  |  |  |  | 16.4064
998 |  | FF/EMT-P | 2020-02-18 00:00:00 | 1 |  |  |  |  |  |  | 17.1364 |  |  |  |  | 17.1364
984 |  | FF/EMT-B | 2019-06-23 00:00:00 | 0 | 2020-07-07 00:00:00 |  |  |  |  |  | 10
1000 |  | FF/EMT B | 2020-07-07 00:00:00 | 0 |  |  |  |  |  |  | 10 |  |  |  |  | 10
1001 |  | FF/EMT-P | 2020-07-14 00:00:00 | 0 |  |  |  |  |  |  | 10 |  |  |  |  | 10
 |  |  | STEP | 0 | 1 | 2 | 3 | 4 | 5 | 6
 |  |  | FF/EMT B | 10 | 16.4064 | 16.7434 | 17.3387 | 18.3833 | 18.5406 | 18.6754
 |  |  | FF/EMT-P | 10 | 17.1364 | 18.0688 | 18.2374 | 19.4056 | 19.4392 | 19.5853
Spreadsheet: 77659d1278080144-comparing-two-groups-of-numbers-book1
Sheet: Sheet1

1 | 2 | 5 | 7 | 11 | 14 | 18 | 21 |  | 7 | 9 | 1 | 11 | 12 | 15 | 16 | 21
9 | 8 | 12 | 11 | 13 | 18 | 19 | 25 |  | 1 | 2 | 5 | 7 | 14 | 11 | 18 | 21
3 | 6 | 13 | 11 | 19 | 21 | 23 | 24 |  | 12 | 11 | 2 | 5 | 9 | 7 | 16 | 25
Spreadsheet: 779443d1651777162-combining-let-xlookup-and-replace-main-workbook
Sheet: Main Sheet

GTIN | Grocery Code | Type | Category | Sub Category | Brand | Quantity | Shipped From | Names
1234 |  | [NAME] | Food | Fruit | Whole Foods | 2 | Canada | [NAME]
1224 |  | Apple | Food | Fruit | Whole Foods | 1 | USA | [NAME]
6546 |  | Peach | Food | Fruit | Whole Foods | 3 | UK | [NAME]
4512 |  | [NAME] | Food | Fruit | Whole Foods | 4 | Mexico | Fred
6351 |  | Watermelon | Food | Fruit | Whole Foods | 5 | France | Nadine
4355 |  | Mango | Food | Fruit | Whole Foods | 6 | Italy | Angelica
1244 |  | [NAME] | Food | Fruit | Whole Foods | 7 | Brazil | [NAME]
3545 |  | Grapes | Food | Fruit | Whole Foods | 8 | Japan | [NAME]
9743 |  | Raspberries | Food | Fruit | Whole Foods | 9 | China | [NAME]
3428 |  | Blueberries | Food | Fruit | Whole Foods | 10 | Argentina | Billy
1247 |  | [NAME] | Food | Fruit | Whole Foods | 11 | Greece | Vern
Example Formula 1: | BW4354-BC | =LET(x,XLOOKUP($A2, '[[NAME], '[[NAME], XLOOKUP($A2, WIP.xlsx!$B:$B, WIP.xlsx!$D:$D, "n/a")),IF(LEN(x)>6,LEFT(x,6),x))
Example Formula 2: | FG4354 | =REPLACE($A2,1,2,"FG")
 | *Need to combine formula 1 and 2 so that it returns the value without anything exceeding 6 characters but then replaces any values that start with "BW" with "FG".
Spreadsheet: 877487d1724316724-redundancy-calc-with-a-difference-a-formula-question-thenewunion-redundancy-calc-with-a-difference-v2-365-aligw
Sheet: Sheet1

 | Redundancy Calc with a difference
 |  |  |  |  | Age @ | Years | Age @ | 0.5 | 1 | 1.5 | Completed | Total
 | Employee Name | DOB | Hire Date | Exit Date | Hire | Worked | Exit | X | Y | Z | Years | Weeks | Status | Expected Output
 | Empl 001 | 1990-09-30 00:00:00 | 2009-03-09 00:00:00 | 2024-08-13 00:00:00 |  |  |  |  |  |  |  |  | Correct | 13 |  | Perfect!
 | Empl 002 | 1974-03-22 00:00:00 | 2008-01-04 00:00:00 | 2024-10-31 00:00:00 |  |  |  |  |  |  |  |  | Correct | 20.5 |  | Perfect!
 | Empl 003 | 1980-04-18 00:00:00 | 2020-07-27 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  |  |  |  |  | Correct | 5.5 |  | Perfect!
 | Empl 004 | 1969-04-03 00:00:00 | 2008-06-25 00:00:00 | 2025-03-06 00:00:00 |  |  |  |  |  |  |  |  | Correct | 23 |  | Perfect!
 | Empl 008 | 1990-07-21 00:00:00 | 2012-12-03 00:00:00 | 2024-11-30 00:00:00 |  |  |  |  |  |  |  |  | ? | 11 |  | -1 for 1.5 weeks is incorrect, expect 11 weeks in 1 and 0 in 0.5 and 1.5
 |  | 0.5 week’s pay for each full year worked when you’re under 22
 |  | 1 week’s pay for each full year worked when you’re between 22 and 41
 |  | 1.5 week’s pay for each full year worked when you’re 41 or older
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 4

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-04 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1409 |  | 1451 |  | 67694 |  |  |  |  |  | 29 | 1 | *
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 2 | *
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 3231 |  | 3875 |  | 67694 |  |  |  |  |  | 29 | 3 | * |  |  | 15
 |  |  |  |  |  |  |  |  | 6999 |  | 6999 |  | 68918 | 0 |  |  |  |  | 28 | 4 | * |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 5 | * |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 158 |  | 413 |  | 67694 |  |  |  |  |  | 31 | 6 | * |  |  | 22
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 29 | 7 | * |  |  | 15
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 30 | 8 | * |  |  | 14
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0 |  |  |  |  | 29 | 9 | * |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 15 | * |  |  | 16
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 13872 |  | 15520 |  | 67694 |  |  |  |  |  | 28 | 35 | * |  |  | 17
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 28 | 39 | * |  |  | 17
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 69149 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1636 |  | 1681 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1039 |  | 1272 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 11342 |  | 12581 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3153 |  | 3474 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 2376 |  | 2490 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4617 |  | 4760 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1633 |  | 1867 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 38 |  | 41 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 152774d1335522576-sorting-across-column-labels-in-a-pivot-827725
Sheet: Sheet1

Item Number | Caption | [NAME] | Sales | ItemCaption |  |  | Sum of Sales | [NAME]
123456 | mum | a | 830 |  |  |  | ItemCaption | a | b | c | Grand Total
123457 | mum | a | 300 |  |  |  | 123459 mum | 1026 |  |  | 1026
123458 | mum | a | 922 |  |  |  | 123458 mum | 922 |  |  | 922
123459 | mum | a | 1026 |  |  |  | 123456 mum | 830 |  |  | 830
123460 | mum | b | 308 |  |  |  | 123457 mum | 300 |  |  | 300
21364 | dad | b | 977 |  |  |  | 23453245 dad |  |  | 1143 | 1143
28378271 | dad | b | 194 |  |  |  | 28378271 dad |  | 194 |  | 194
23453245 | dad | c | 1143 |  |  |  | 235 sister |  |  | 539 | 539
325 | dad | c | 1253 |  |  |  | 435413 sister |  |  | 1116 | 1116
235 | sister | c | 539 |  |  |  | 123460 mum |  | 308 |  | 308
435413 | sister | c | 1116 |  |  |  | 325 dad |  |  | 1253 | 1253
13443 | sister | c | 1079 |  |  |  | 21364 dad |  | 977 |  | 977
 |  |  |  |  |  |  | 13443 sister |  |  | 1079 | 1079
 |  |  |  |  |  |  | Grand Total | 3078 | 1479 | 5130 | 9687
Spreadsheet: 166926d1341847312-vlookup-or-reference-problems-number-refrence-example
Sheet: Sheet1

80 | 81 | 82 | 83 | 93 | 94 |  | 84 | 85 | 86 | 77 | 78 | 79 |  | 87 | 88 | 89 | 90 | 91 | 92 |  | 95 | 96 | 97 | 98 | 99 | 100
207 | 1308 | 2126 | 3628 | 3108 | 4527 |  | 4609 | 5402 |  | 7347 | 8643 | 9340 |  | 7227 |  |  |  | 1429 | 2205 |  | 5131 | 6207 | 7303 | 8304 | 9401 | 244
208 | 1307 | 2129 | 3219 | 3109 | 4327 |  | 4610 | 5403 |  | 7542 | 8541 | 9539 |  | 7228 |  |  |  | 1430 | 2206 |  | 5125 | 6208 | 7304 | 8505 | 9402 | 245
213 |  | 2221 | 3220 |  | 4328 |  | 4411 |  |  | 7548 | 8444 | 9540 |  | 7519 |  |  |  |  |  |  |  | 6306 | 7412 |  |  | 450
214 |  | 2222 | 3529 |  | 4325 |  | 4412 |  |  | 7441 |  | 9142 |  | 7520 |  |  |  |  |  |  |  | 6401 | 7411 |  |  | 451
409 |  | 2421 | 3325 |  | 4326 |  | 4211 |  |  |  |  | 9439 |  |  |  |  |  |  |  |  |  | 6206 |  |  |  | 540
305 |  | 2422 | 3326 |  | 4123 |  | 4212 |  |  |  |  | 9440 |  |  |  |  |  |  |  |  |  |  |  |  |  | 541
313 |  |  | 3323 |  | 4124 |  | 4607 |  |  |  |  | 9345 |  |  |  |  |  |  |  |  |  |  |  |  |  | 542
314 |  |  | 3532 |  |  |  | 4608 |  |  |  |  | 9346 |  |  |  |  |  |  |  |  |  |  |  |  |  | 543
309 |  |  | 3127 |  |  |  | 4313 |  |  |  |  | 9341 |  |  |  |  |  |  |  |  |  |  |  |  |  | 546
 |  |  | 3128 |  |  |  | 4203 |  |  |  |  | 9342 |  |  |  |  |  |  |  |  |  |  |  |  |  | 550
 |  |  |  |  |  |  | 4204 |  |  |  |  | 9249
 |  |  |  |  |  |  | 4205 |  |  |  |  | 9250
 |  |  |  |  |  |  | 4206
 |  |  |  |  |  |  | 4415
 |  |  |  |  |  |  | 4416
9 | 2 | 6 | 10 | 2 | 7 | 0 | 15 | 2 | 0 | 4 | 3 | 12 | 0 | 4 | 0 | 0 | 0 | 2 | 2 | 0 | 2 | 5 | 4 | 2 | 2 | 10 | 105
 |  | 36 |  |  |  |  |  |  | 36 |  |  |  |  |  |  | 8 |  |  |  |  |  |  | 25
Spreadsheet: 731187d1620223932-turning-raw-data-into-dataset-table-using-formula-attachment
Sheet: Sheet1

 | WHAT I HAVE |  |  |  |  |  |  |  |  |  | WHAT I WANT TO ACHIEVE
 |  | Product A |  |  |  |  |  | Product B |  |  | Customer Name | Year | Product | Net Sales
 |  | 2016 | 2017 | 2018 | 2019 | 2020 | Result | 2016 | 2017 |  |  | 2017 | Product B | 50 |  | Rows with unique sales data, defined by 3 parameters: Customer + Year + Product
 | Customer 1 |  |  |  |  |  |  |  | 50 |  | Customer 2 | 2016 | Product A | 290
 | Customer 2 | 290 | 150 | 60 | 230 | 70 |  |  |  |  | Customer 2 | 2017 | Product A | 150
 | Customer 3 |  |  |  | 110 | 100 |  | 30 | 50 |  | Customer 2 | 2018 | Product A | 60
 |  |  |  |  |  |  |  |  |  |  | Customer 2 | 2019 | Product A | 230
 |  |  |  |  |  |  |  |  |  |  | Customer 2 | 2020 | Product A | 70
 |  |  |  |  |  |  |  |  |  |  | Customer 3 | 2019 | Product A | 110
 |  |  |  |  |  |  |  |  |  |  | Customer 3 | 2020 | Product A | 100
 |  |  |  |  |  |  |  |  |  |  | Customer 3 | 2016 | Product B | 30
 |  |  |  |  |  |  |  |  |  |  | Customer 3 | 2017 | Product B | 50
Spreadsheet: 686104d1594364752-more-efficient-counta-sumif-and-sum-formulas-needed-for-training-spreadsheet-training2
Sheet: Training 3

 | Training 3
 |  |  | 07:30:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:30:00 | 08:30:00 | 08:30:00 | 09:00:00 | 09:30:00 | 09:30:00 | 10:00:00 | 10:00:00 | 10:00:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:00:00 | 11:00:00 | 11:00:00 | 11:00:00 | 13:00:00 | 13:00:00 | 13:00:00 | 13:30:00 | 13:30:00 | 13:30:00 | 15:00:00
 | # of Sessions |  | 1
 | # of Expected on Training Day |  | 1 | 2 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 2 | 3 | 2 | 2 | 3 | 2 | 2 | 2 | 3
 | # [NAME] |  | 1 | 2 | 1 | 3 | 3 | 2 | 2 | 2 | 0 | 2 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 1 | 3 | 2 | 2 | 3 | 2 | 2 | 2 | 3
 | New Hire Show Rate
 | [NAME] | The same for training 1-6
 | C6: | Count Row 6 from column D and over, Only the cells with data entered in them
 | C7: | Sum of row 7 tfrom Column D and over "IF" Row 8 has data enetered
 | C8: | Sum of Row 8 from Column D and over
 | Column D and Over: | Manually entered.
Spreadsheet: 741045d1626786713-auto-populate-table-with-start-and-end-year-work
Sheet: Working

Financial Figures
Sales
Gross Profit
Free Cashflow
NPV
IRR
Lease
Sales
Gross Profit
Net Income
Asset Management
Sales
Gross Profit
Net Income
Spreadsheet: 832113d1686125815-cell-conditional-formatting-using-formula-to-change-fill-color-based-on-project-plan-task-project-plan-template_forum-aligw
Sheet: Sheet1

 |  |  |  | Week
 | Start week | Total weeks | End week | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Task 1 | 3 | 2 |  |  |  |  |  |  |  |  |  |  | Green fill should be autogenerated if task falls in the particular week
Task 2 | 2 | 3
Task 3 | 4 | 4
Spreadsheet: 4e8dc5a0-f0e0-4813-8279-2b9c647c7de9
Sheet: Form 2 Enrollment-DSA

[NAME] AND BASIC SUPPORT GUARANTEE INFORMATION
 |  |  |  |  |  |  |  |  |  |  |  |  | WEIGHTED
 |  |  |  |  | WEIGHTED |  |  |  | WEIGHTED |  |  |  | ESTIMATED
 |  |  |  |  | ACTUAL PRIOR YEAR |  |  |  | ACTUAL CURRENT YEAR |  |  |  | YEAR
1. | Pre-kindergarten
 | (NRS 388.490) |  |  | x .6 = |  |  |  | x .6 = |  |  |  | x .6 =
2. | Kindergarten |  |  | x .6 = |  |  |  | x .6 = |  |  |  | x .6 =
3. | Elementary
4. | Secondary
5. | Ungraded
6. | Subtotal
7. | Students transported into
 | Nevada from out-of-state
8. | Students transported to
 | another state
9. | Total WEIGHTED enrollment
10. | Hold Harmless
11.
 | Estimated per SB522 77th session |  |  |  |  |  | WEIGHTED |  |  |  | Use rates below:
 | Fill in information for each district: |  |  |  |  |  |  |  |  |  |  |  | Reference amounts for #12
 |  |  | School District |  | Rate revised 5/24/2013 |  | Enrollment |  | Subtotal |  |  |  | Estimate:  "Outside Revenue"
 |  |  | Carson City |  | 6643 |  | 0 |  |  |  |  |  | 1086
 |  |  | Churchill |  | 6629 |  | 0 |  |  |  |  |  | 1069
 |  |  | [NAME] |  | 5544 |  | 0 |  |  |  |  |  | 997
 |  |  | [NAME] |  | 5998 |  | 0 |  |  |  |  |  | 2386
 |  |  | Elko |  | 6692 |  | 0 |  |  |  |  |  | 1113
 |  |  | Esmeralda |  | 15798 |  | 0 |  |  |  |  |  | 8308
 |  |  | [NAME] |  | 100 |  | 0
 |  |  | Humboldt |  | 5409 |  | 0 |  |  |  |  |  | 2047
 |  |  | Lander |  | 385 |  | 0
 |  |  | Lincoln |  | 10500 |  | 0 |  |  |  |  |  | 1295
 |  |  | Lyon |  | 7186 |  | 0 |  |  |  |  |  | 922
 |  |  | Mineral |  | 9622 |  | 0 |  |  |  |  |  | 1683
 |  |  | Nye |  | 7085 |  | 0 |  |  |  |  |  | 1368
 |  |  | Pershing |  | 8738 |  | 0 |  |  |  |  |  | 2272
 |  |  | [NAME] |  | 8455 |  | 0 |  |  |  |  |  | 6494
 |  |  | Washoe |  | 5585 |  | 0 |  |  |  |  |  | 1138
 |  |  | White Pine |  | 7315 |  | 0 |  |  |  |  |  | 1902
 |  |  | Multidistict
12. | Estimated "Outside Revenue" (Supplemental Support) per pupil
 | This is the per pupil share of local taxes, etc, from the district.
 |  |  |  |  |  |  |  |  |  |  | Total Weighted-#9 |  | Hold Harmless-#10
13. | Total basic support for enrollee including outside revenue
14. | Estimated number of special education program units |  |  |  |  |  |  |  | (Should be 0  or 2 maximum - see prior year allotment)
 |  |  |  |  |  | X | 39768 | amount per unit
 |  |  |  |  |  |  |  |  |  |  | Total Weighted |  | Hold Harmless
15. | TOTAL BASIC SUPPORT GUARANTEE (Number 13 +14)
 |  |  |  | Charter School
Form 2 Enrollment - DSA
Spreadsheet: 818106d1676589958-if-and-or-q-and-d-feb-with-summary-end
Sheet: 13th

1 | Defect ID | Unit ID | Unit Date | Prod Date | Act Date | Shift | Year | Serial | z | ID #1 | ID #2 | ID #3 | Product | Color #1 | Color #2 | Part | Location | Concern | [NAME] | Rank | Grid Label | Responsible Area | Responsible Cell | Recording User | Recording Area | Recording Cell | Recording Station | Defect Status | Root Cause | Root Cause User | Comments | sequence no | 1st | 2nd | 3rd | Date
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 13a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche / Index | 2487733.1586102 | 5098324.653322199 | 7586057.8119324
Asia | 0 | 117692.7283004 | 117692.7283004
Europe | 1081521.2447916 | 2465225.7265664 | 3546746.971358
North America | 1390322.0499936 | 2290287.268415 | 3680609.3184085
Other | 15889.863825 | 225118.9300403 | 241008.7938653
Other | 0 | 473315.2340623 | 473315.2340623
Exotic/Total Return Swap | 0 | 50349.9493917 | 50349.9493917
Swaptions | 0 | 422965.2846706 | 422965.2846706
TOTAL
Spreadsheet: 849327d1699856693-sumproduct-and-countif-function-to-count-text-with-comma-book1
Sheet: Sheet1

 | 1st | 2nd | 3rd |  | Player Name | Total Points |  |  |  |  |  |  | Shared winner
Game 1 | A,B | C |  |  | A |  |  |  |  |  | 1st place | 3 points | 2.5 point each
Game 2 | B | A | C |  | B |  |  |  |  |  | 2nd place | 2 points | 1.5 point each
Game 3 | B | A | C |  | C |  |  |  |  |  | 3rd place | 1 points | 0.5 point each
Game 4 | B | A | C |  | D
Game 5 | B | A | C |  | E
Game 6 | B | A | C
Game 7 | B | A | C
Game 8 | B | A | C
Game 9 | B | A | C
Game 10 | B | A | C
Spreadsheet: 741685d1627277145-how-to-countif-formulas-with-time-example
Sheet: LEVEL 1

EVENT ID |  |  |  |  |  |  | 1 day, 0:00:00
EVENT
EVENT DATE
EXTERNAL DOORS
INTERNAL DOORS
SHOW START TIME
APPROX END TIME
EVENT AREA | LEVEL 1
EVENT VENUE | ARENA
 |  |  | Roster |  |  | Actual
NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
 | Supervisor [NAME] | Level 1 Supervisor 1 - AREA WARDEN
 | Supervisor [NAME] | Level 1 Supervisor 2 - AREA WARDEN
 | Event Correspondent | Event Correspondent
Total
 |  |  | Roster |  |  | Actual
NAME | POSITION | [NAME] | START | FINISH | Shift Length | START | FINISH | Paid Hours | Employee Signature
 | Usher - Early | Concourse Directional - Position 1
 | Usher - Early | Concourse Directional - Position 2
 | Usher - Warden | Door 2 - WARDEN
 | Usher - Staff Entry | Door 3 - Staff Entry
 | Usher | Door 4
 | Usher | Door 5
 | Usher | Door 6
 | Usher | Door 7
 | Usher - Warden | Door 8 - WARDEN
 | Usher - Staff Entry | Door 9 - Staff Entry
 | Usher | Wheelchair Bay 3
Total
Authorized by:
Name: |  |  | Date:               /                /
Position: | Event Manager