tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 89467d1289262122-countif-within-a-range-hamshire
Sheet: Hamshire

Accounts | Revenue | Minimum | Maximum | # Between Range
Hamshire 1 | 3273.18 | 0 | 500 | 12
Hamshire 2 | 646.11 | 500 | 1000 | 8
Hamshire 3 | 58.15 | 1000 | 1500 | 0
Hamshire 4 | 500 | 1500 | 2000 | 1
Hamshire 5 | 500 | 2000 | 2500 | 1
Hamshire 6 | 500 | 2500 | 3000 | 0
Hamshire 7 | 500 | 3000 | 3500 | 1
Hamshire 8 | 4200 | 3500 | 4000 | 0
Hamshire 9 | 500 | 4000 | 4500 | 1
Hamshire 10 | 6200 | 4500 | 5000 | 0
Hamshire 11 | 245.96 | 5000 | 5500 | 0
Hamshire 12 | 500 | 5500 | 6000 | 0
Hamshire 13 | 323.31 | 6000 | 6500 | 1
Hamshire 14 | 500 | 6500 | 7000 | 0
Hamshire 15 | 0 | 7000 | 7500 | 0
Hamshire 16 | 1687.34 | 7500 | 8000 | 0
Hamshire 17 | 295.8 | 8000 | 8500 | 0
Hamshire 18 | 9200 | 8500 | 9000 | 0
Hamshire 19 | 2221.62 | 9000 | 9500 | 1
Spreadsheet: 824664d1680753974-dynamic-sumif-dynamtic-sumif
Sheet: Sheet1

Type | Amount |  |  |  | Type | Amount
Car | 100
Car | 200 |  |  |  | Boat
Car | 300 |  |  |  | House |  | <---- how to make this behave like Column F?
Boat | 400 |  |  |  | Plane |  | <---- how to make this behave like Column F?
Car | 500
House | 11
Boat | 11
Plane | 222
Spreadsheet: 220809d1363271633-if-command-between-two-sheets-to-equal-value-sample123
Sheet: Sheet1

1 | No Formal Schooling
2 | Grade 01
3 | Grade 02
4 | Grade 03
5 | Grade 04
6 | Grade 05
7 | Grade 06
8 | Grade 07
9 | Grade 08
10 | Grade 09
11 | Grade 10
12 | Grade 11
13 | Grade 12
14 | High School Diploma
15 | Special Education Certificate
16 | GED or Equivalency
17 | Post Secondary Education or Certificate
18 | One Years of College
19 | Two Years of College
20 | Associates Degree
21 | Three Years of College
22 | Bachelor's Degree
23 | Education Beyond Bachelor's Sdegree
24 | Master's Degree
25 | Doctorate Degree
Spreadsheet: 156196d1337208917-a-fun-one-matching-rows-to-columns-sample_richardwedamins
Sheet: Sheet2

Group | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8 | Item 9 | Item 10
Spreadsheet: d564ede9-86f0-46fb-addf-8aa759765ea0
Sheet: Sheet1

Table S8 Summary of mutations suggested to be responsible for the loss of SI in cultivated [NAME] populations. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Species | Mutations suggested to be responsible for the loss of SI | Male functionality confirmed by crossings | References
[NAME] napus** | 1-bp insertion, 5-bp deletion and 308-bp insertion in SRK | y | [80] Okamoto et al. 2007 Plant J 50:391-400
[NAME] napus** | 7-bp deletion in SRK | y | [80] Okamoto et al. 2007 Plant J 50:391-400
[NAME] napus** | About 3.6-kb insertion in the promoter region of the SP11/SCR gene* | y | [80] Okamoto et al. 2007 Plant J 50:391-400
[NAME] napus** | 1-bp deletion in SRK* | n | [79] Goring et al. 1993 Plant Cell 5:531-539
[NAME] rapa | Gene conversion from SLG to SRK | y | [112] Fujimoto et al. 2006 FEBS Letters 580:425-430
[NAME] oleracea | Deletion encompassing the S-domain and the transmembrane domain of SRK | n | [111] Nasrallah et al. 1994 Plant J 5:373-384
*The 3.6-kb insertion in SP11/SCR and 1-bp deletion in SRK were independently observed, while both accessions derived originally from cv. Wester. The significant difference between cultivated and wild populations was still observed when one of them were removed in order to be conservative (two-tailed Fisher's exact test: p = 0.0476, one-tailed: p = 0.0397).
**These four examples from [NAME] napus represent independent evolutionary events in different populations.
Spreadsheet: 119129d1314211963-assign-values-to-dropdown-menu-selections-referencedoc
Sheet: Sheet3

Dropdown Table
Wellness
TDS
Healthy_Back_Non_Incentive
Healthy_Back_Incentive
Open
Wellness | Choice 1 | Choice 2
Percentage 1 | 0.24 | 0.35
Percentage 2 | 0.36 | 0.25
Percentage 3 | 0.58 | 0.24
Percentage 4 | 0.6 | 0.68
Percentage 5 | 0.21 | 0.68
Percentage 6 | 0.2 | 0.68
TDS
Percentage 1 | 0.33 | 0.35
Percentage 2 | 0.35 | 0.25
Percentage 3 | 0.78 | 0.24
Percentage 4 | 0.65 | 0.68
Percentage 5 | 0.46 | 0.1
Percentage 6 | 0.6 | 0.8
Healthy_Back_Non_Incentive
Percentage 1 | 0.2 | 0.45
Percentage 2 | 0.6 | 0.87
Percentage 3 | 0.54 | 0.35
Percentage 4 | 0.28 | 0.25
Percentage 5 | 0.69 | 0.24
Percentage 6 | 0.2 | 0.68
Healthy_Back_Incentive
Percentage 1 | 0.45 | 0.1
Percentage 2 | 0.22 | 0.35
Percentage 3 | 0.39 | 0.25
Percentage 4 | 0.85 | 0.24
Percentage 5 | 0.2 | 0.68
Percentage 6 | 0.1 | 0.69
Spreadsheet: 63045d1264010495-forcing-imported-data-into-a-specific-cell-or-cells-wt_testing_template
Sheet: calibration

Calibration of weights |  |  | result
500 | mg |  | 12/1/2009 9:01:32 AM | 500 | mg
1000 | mg |  | 12/1/2009 9:03:04 AM | 999.96 | mg
10000 | mg |  | 12/1/2009 9:04:40 AM | 10000 | mg
20 | mg |  | 12/1/2009 9:05:55 AM | 19.99 | mg
Cal wt ID 1 | 10210
Cal wt ID 2 | 12210
cal date | 2007-04-12 00:00:00
weights in set | 500 | mg
Cal wt ID | 54
cal date | 2008-12-04 00:00:00
weights in set | 10 | g
 | 20 | mg
Cal wt ID | 55
cal date | 2008-12-05 00:00:00
weights in set | 500 | mg
Spreadsheet: 770130d1645818877-offset-with-count-not-working-horizontally-problem-child
Sheet: scores-averages

 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  |  |  |  |  |  | Average
Team 1
Team 2
Team 3
Team 4
Team 5
Team 6
Team 7
Team 8
Team 9
Team 10
Team 11
Team 12
Team 13
Team 14
Team 15
Spreadsheet: 268767d1380780070-indirect-function-to-pull-desired-no-of-cells-row-data-based-on-data-validation-in-input-file1
Sheet: Output

 | Reference Sheet Name >>>>
 | Name of party >>>>
 | Type of Scheme >>>>>>>>>
 | Name of Product
Spreadsheet: joe_parks__14512__TEXAS_P&L_JUN01
Sheet: KATHY_PHYS

 | IF
 | 5.3 |  |  |  |  |  |  |  |  |  |  |  |  |  | NET Postion
 | 0 | GDA | 3.74 | 3.64 | 3.65 | 3.66 | 3.825 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL P&L
2001-03-01 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-02 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-03 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-04 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-05 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-06 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-07 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-08 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-09 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-10 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-11 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-12 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-13 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-14 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-15 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-16 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-17 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-18 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-19 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-20 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-21 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-22 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-23 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-24 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-25 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-26 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-27 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-28 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-29 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-30 00:00:00 |  |  | 29387 | -5000 | -5000 | -5000 | 1000
2001-03-31 00:00:00
Spreadsheet: 862978d1710525367-calendar-formulas-and-conditional-formatting-annual-calendar-dj
Sheet: August

 |  |  |  |  |  |  |  |  | AUG
 | NOTES
Spreadsheet: louise_kitchen__24091__NEWCO HEADCOUNT NAMES
Sheet: Power Risk East and West

Power Risk (East and West) |  |  | ok
[NAME] | East | Director
[NAME] | East | Director | 2
[NAME] | East | Spec
[NAME] | West | Spec
[NAME] | West | Spec
[NAME] | West | Spec | 4
[NAME] | East | Sr. Spec
[NAME] | East | Sr. Spec
[NAME] | East | Sr. Spec
Casey Evans | East | Sr. Spec
Heather Dunton | West | Sr. Spec | 5
Spreadsheet: 181154d1347948857-conditional-formatting-advanced-sample
Sheet: Sheet1

Employee Name | SURNAME
FAISAL | [NAME]
MUSAFAR [NAME] | CBD
MUHAMMED IJAZ | EFG
TAHIR SHAH | HIJ
RAHEEL TAREEQ | LMN
HABIBULLAH | OPQ
FAISAL | RST
SHOIB | [NAME]
ALAM SHAH | CBD
HAJINOOR | EFG
DIL MOHD | HIJ
AFTAB | LMN
SAYD FARAZ | OPQ
MOHD ESWAR | RST
SHAKEEL AHMED | [NAME]
[NAME] | CBD
MOHD IQBAL | EFG
SAEED MUHAMMAD | HIJ
ASHRAF | LMN
ZAHOOR IQBAL | OPQ
MUSAFAR [NAME] | RST
[NAME] | [NAME]
[NAME] | CBD
RAHEEL TAREEQ | EFG
MUHAMMED IJAZ | HIJ
SAAD | LMN
TAHIR SHAH | OPQ
DEYAR ZAMAN | RST
SAJJAD UL HAQ | [NAME]
GEHAD | CBD
HABIBULLAH | EFG
MOHD ALAM [NAME] | HIJ
MOHD MOEEN | LMN
HAZRAT WAZIR | OPQ
IQBAL | RST
MOHD ALI GHULAM | [NAME]
SHAKEEL | CBD
V.P MEHMOOD | EFG
FAZAL QAYUM | HIJ
SHAFEEQ | LMN
HAMESH GUL | OPQ
MOHD ALI | RST
ABDU MUSAD | [NAME]
MAQSOOD | CBD
YASEEN TARIQ | EFG
ALI   ESSA | HIJ
[NAME] | LMN
MUHAMAD ILYAS | OPQ
RIZWAN KHALID | RST
[NAME] KHATTAK | [NAME]
NASRATULLAH | CBD
[NAME] | EFG
ISSAM MOHD | HIJ
ABDU MUSAD | LMN
MAQSOOD | OPQ
ALI   ESSA | RST
ABEER | [NAME]
TAHIRA | CBD
NAZIA | EFG
MARYAM AHMD | HIJ
TAYEBA SONA | LMN
ANAMMA | OPQ
MALIKA | RST
RIZWANA | [NAME]
MARYAM RAZAK | CBD
NANDINI | EFG
YASMEEN | HIJ
ROMANA | LMN
MARYAM KAMBR | OPQ
SHAHIDAH | RST
MOEED GUL | [NAME]
YASIN BADSHAH | CBD
[NAME] | EFG
FAROOQ SABJAN | HIJ
GHULAM MUSTAFA | LMN
LIAQAT ALI | OPQ
NADEEM | RST
MOHD TARIQ DIN | [NAME]
[NAME] | CBD
[NAME] | EFG
[NAME] | HIJ
ANVAR MEETHALE | LMN
[NAME] | OPQ
MOHD FAROOQ | RST
MOHD NADEEM | [NAME]
SHAMSHER | CBD
KHUSH MOHD | EFG
[NAME] | HIJ
[NAME] | LMN
HASSAN KUTTY | OPQ
[NAME] | RST
MUSTHAFA PUTHAN | [NAME]
RASHID MUBEEN | CBD
ANWAR ALI | EFG
MOHD FAROOQ | HIJ
FOYEJUL HASAN | LMN
FAZAL QAYUM | OPQ
[NAME] | RST
BILAL BALOCH | [NAME]
FAISAL MADAMBIL | CBD
[NAME] | EFG
[NAME] | HIJ
GHULAM MUSTAFA | LMN
FOYEJUL HASSAN | OPQ
LIAQAT ALI | RST
FAZAL QAYUM | [NAME]
MOHD TARIQ DIN | CBD
BILAL | EFG
[NAME] | HIJ
MOHD NADEEM | LMN
SHAMSHER | OPQ
[NAME] | RST
KHUSH MOHD | [NAME]
ANWAR | CBD
SABZ ALI | EFG
AKTHAR | HIJ
AMJAD | LMN
TARIQ | OPQ
AHMED | RST
[NAME] | [NAME]
SHAMSHER | CBD
NOOR MANNAN | EFG
K V AZIZ | HIJ
IDRES | LMN
[NAME] | OPQ
[NAME] | RST
SAJEEV | [NAME]
[NAME] | CBD
HAROON | EFG
MOIDUTTY | HIJ
FAISAL SULTAN | LMN
Spreadsheet: 290169d1389805450-need-help-in-creating-a-time-table-time-table
Sheet: Blad1

Start: 8:00, [NAME] (hh:[NAME]) between each row: 00:10 |  |  |  | Start | 06:30:00
Start time-End time |  | Length (hh:[NAME]) |  | Length | 00:15:00
8:00-8:15 |  | 00:15:00
8:25-8:55 |  | 00:30:00
9:05-9:10 |  | 00:05:00
9:20-9:35 |  | 00:15:00
9:45-10:05 |  | 00:20:00
10:15-11:15 |  | 01:00:00
 |  | 00:15:00
 |  | 00:30:00
 |  | 00:05:00
 |  | 00:15:00
 |  | 00:20:00
 |  | 01:00:00
Spreadsheet: 48936d1248217409-excel-2007-compare-two-versions-of-the-same-workbook-workbook-ver1
Sheet: 1-35-116-04

Project AFE Cost Tracking
Location: | 1
Invoiced Costs
Date | Invoice # | Contractor | Description of Work | Invoiced Cost
Phase II Assessment - Field Work
2006-10-19 00:00:00 | 3637 | SCC | Field work - Phase 2 | 1800
2006-10-19 00:00:00 | 3635 | SCC | Field work - site visit | 709.69
2006-10-31 00:00:00 | 3688 | SCC | Field work - Phase 2 | 2244.29
2006-11-30 00:00:00 | 3709 | SCC | Field work - Phase 2 | 16772.24
 |  |  | subtotal | 21526.22
2006-10-20 00:00:00 | 34699-001 | MSI | Phase 1 File Review | 122.18
2006-10-31 00:00:00 | 35359-001-A | MSI | Field work - Phase 2 | 4158.25
2006-12-15 00:00:00 | 36359-001-A | MSI | Phase 2 Field Work | 1504.8
 |  |  | subtotal | 5785.23
2006-11-13 00:00:00 | 5836 | SPT Drilling | Drilling - Phase 2 | 14523
 |  |  | subtotal | 14523
2006-11-30 00:00:00 | 40 | CHI | "Out of Scope", Decom. Wk | 3520
 |  |  | subtotal | 3520
2006-10-13 00:00:00 | 100-7 | GAEA | EM Survey | 3003.25
 |  |  | subtotal | 3003.25
2006-11-27 00:00:00 | E201382 | MA | Laboratory Analysis | 2908
2006-11-29 00:00:00 | E202291 | MA | Laboratory Analysis | 5576
2006-11-29 00:00:00 | E202282 | MA | Laboratory Analysis | 2016.5
 |  |  | subtotal | 10500.5
2006-10-10 00:00:00 | 2277852 | RT | Shipment of supplies | 159.6355140186916
2006-10-25 00:00:00 | 2274961 | RT | Shipping of samples | 107.92
2006-10-25 00:00:00 | 2275084 | RT | Shipping of samples | 40.79
2006-11-05 00:00:00 | 2280238 | RT | Shipping of samples | 107.43
2007-11-08 00:00:00 | 87139151 | RT | Supply Shipment | 40.79
2006-11-10 00:00:00 | 2278438 | RT | Shipment of supplies | 106.4299065420561
2006-11-10 00:00:00 | 2282918 | RT | Shipping of bentonite | 450
 |  |  | subtotal | 1012.995420560748
2006-11-15 00:00:00 | 1791 | NI | Lodgings and Meals | 428.4
2006-11-15 00:00:00 | 1806 | NI | Lodgings and Meals | 229.44
2006-11-15 00:00:00 | 1794 | NI | Lodgings and Meals | 142.8
2006-11-15 00:00:00 | 1785 | NI | Lodgings and Meals | 250.24
2006-11-15 00:00:00 | 1708 | NI | Lodgings and Meals | 142.8
2006-11-24 00:00:00 | 1824 | NI | Lodgings and Meals | 756.72
2006-11-24 00:00:00 | 1835 | NI | Lodgings and Meals | 410.72
2006-11-24 00:00:00 | 1836 | NI | Lodgings and Meals | 1241.16
 |  |  | subtotal | 3602.28
 |  |  | Total Invoiced to Date: | 63473.47542056075
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: PPM

Raw Material |  | PPM
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 750
Total
Spreadsheet: 22100476-0db0-40a3-b45c-045de622e555
Sheet: Sheet1

Bachelor of Science in Computer Science: Sample Four-Year Curriculum
First Year |  | Second Year |  | Third Year |  | Fourth Year
Fall |  | Fall |  | Fall |  | Fall
CS 1361 | 3 | Math 2305 | 3 | CS 3352 | 3 | CS Elective (Advanced) | 3
Lab Science (Biology or Geology) | 4 | CS 2305 | 3 | CS 4301 | 3 | Math 3301 (For Math Minor) | 3
Eng 1301 | 3 | POLS 2301 | 3 | Chem, Physical Science, or Physics | 3 | CS Elective | 3
Math 1561 | 5 | Comm 2301 | 3 | Visual and Performing Arts | 3 | Eng 3351 | 3
 |  | His 1301 | 3 | Elective | 3 | Elective | 3
Spring |  | Spring |  | Spring |  | Spring
Math 2513 (For Math Minor) | 5 | CS 3304 | 3 | CS Elective (Advanced) | 3 | CS Elective (Advanced) | 3
CS 1362 | 3 | Hist 1302 | 3 | Math 3305 (For Math Minor) | 3 | CS 4306, 4307, 4318, or 4371 | 3
Lab Science (Biology or Geology) | 4 | CS Elective | 3 | CS 4302 | 3 | Social Science | 3
Eng 1302 | 3 | POLS 2302 | 3 | Phys 3444 | 4 | Elective | 3
 |  | Sophomore Literature | 3 | Elective | 2 | Elective | 3
Spreadsheet: 584069d1532960646-average-is-not-average-average-calculations
Sheet: Sheet1

 |  | Column #1 |  |  | Column #2
 | 1 | 138.2 |  |  | 138.9
 | 2 | 138.3 |  |  | 139.2
 | 3 | 138.2 |  |  | 138.9
 | 4 | 142.5* |  |  | 139
 | 5 | 138.2 |  |  | 138.9
 | 6 | 138.2 |  |  | 138.9
 | AVG. | 138.22 |  | AVG. | 138.9666666666667
Average Both Columns |  |  | There's an asterisk after the 142.5 since it is an outlier;
in One Formula |  | 138.6272727272727 | will not be used in the calculation
Average of the Averages; 138.22 and 138.97 |  |  |  | 138.5933333333333
Spreadsheet: jeff_dasovich__14095__818 Malloy California Report (Michaels)
Sheet: Sheet1

CAEM Cost Proposal
 |  | PROPOSED HOURS BY TASK
 | Hours By Task
LABOR |  | TASK 1 Reseach Plan | TASK 2 Initial Draft | TASK 3 Expert Panel | TASK 4 Revise Draft | TASK 5 Industry Review | TASK 6 Final Report | TASK 7 Present Report | TOTAL HOURS | LABOR COSTS
CAEM Personnel
[NAME] | 250 | 8 | 60 | 16 | 24 | 0 | 20 | 8
[NAME] | 200 | 8 | 16 | 16 | 8 | 8 | 8 | 8
Research Assistant | 100 | 16 | 80 | 16 | 16 | 8 | 20 | 8
Expert review panel 5 members | 200 |  | 0 |  | 0 | 0 | 0 | 0
Technical Editor | 100 | 0 | 0 | 0 | 8 | 0 | 24 | 0
Totals By Task
OTHER DIRECT COSTS | $ Per Unit | Units By Task |  |  |  |  |  |  | TOTAL UNITS | TOTAL ODCs
Other Direct Costs
Miscellaneous Expenses
Airfare | 1000 | 0 | 0 | 5 | 0 | 0 | 0 | 2
Ground Transportation | 50 | 0 | 0 | 5 | 0 | 0 | 0 | 2
Per Diem | 200 | 0 | 0 | 10 | 0 | 0 | 0 | 2
Phone, Mail/Courier, Printing, etc. | 50 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Direct Expenses
Totals By Task
TOTAL LABOR & OTHER DIRECT COSTS
Spreadsheet: 888247d1738734086-month-format-test_
Sheet: Voice Database

Date | Date_ | Month | Day | Week | Offered | Answered | Service Level | Answer Rate | <30s | Abandoned | ACR Rate
2025-01-01 00:00:00 |  |  |  |  | 2601 | 2327 |  |  | 1461 | 274
2025-01-02 00:00:00 |  |  |  |  | 2453 | 1595 |  |  | 385 | 858
2025-01-03 00:00:00 |  |  |  |  | 1721 | 1358 |  |  | 649 | 363
2025-01-04 00:00:00 |  |  |  |  | 1257 | 1186 |  |  | 1016 | 71
2025-01-05 00:00:00 |  |  |  |  | 2470 | 1642 |  |  | 510 | 828
2025-01-06 00:00:00 |  |  |  |  | 2162 | 1900 |  |  | 1092 | 262
2025-01-07 00:00:00 |  |  |  |  | 1991 | 1962 |  |  | 1753 | 29
2025-01-08 00:00:00 |  |  |  |  | 2041 | 1998 |  |  | 1750 | 43
2025-01-09 00:00:00 |  |  |  |  | 1876 | 1801 |  |  | 1570 | 75
2025-01-10 00:00:00 |  |  |  |  | 1573 | 1562 |  |  | 1505 | 11
2025-01-11 00:00:00 |  |  |  |  | 1400 | 1361 |  |  | 1294 | 39
2025-01-12 00:00:00 |  |  |  |  | 2144 | 2023 |  |  | 1602 | 121
2025-01-13 00:00:00 |  |  |  |  | 1798 | 1786 |  |  | 1747 | 12
2025-01-14 00:00:00 |  |  |  |  | 1818 | 1798 |  |  | 1757 | 20
2025-01-15 00:00:00 |  |  |  |  | 1842 | 1827 |  |  | 1793 | 15
2025-01-16 00:00:00 |  |  |  |  | 1887 | 1830 |  |  | 1641 | 57
2025-01-17 00:00:00 |  |  |  |  | 1531 | 1475 |  |  | 1216 | 56
2025-01-18 00:00:00 |  |  |  |  | 1332 | 1327 |  |  | 1301 | 5
2025-01-19 00:00:00 |  |  |  |  | 2022 | 2003 |  |  | 1859 | 19
2025-01-20 00:00:00 |  |  |  |  | 1892 | 1876 |  |  | 1813 | 16
2025-01-21 00:00:00 |  |  |  |  | 1877 | 1825 |  |  | 1625 | 52
2025-01-22 00:00:00 |  |  |  |  | 1876 | 1852 |  |  | 1790 | 24
Spreadsheet: 85661d1285732901-sorting-a-cell-amount-into-specific-labelled-amount-columns-demo
Sheet: Sheet4

AMOUNT: THE AMOUNT SPLIT INTO EACH COLUMN
DATA ENTRY BELOW IN CELLS A6 TO A11
AMOUNT
AMOUNT ENTERED | 500 | 1000 | 3000 | 5000 | 8000 | 20000 |  | TOTAL |  | LEFT OVER |  | Need the amounts left over to be rounded up, and added into the appropriate column.
500
750
800
2400
2800
45663
BASICALLY A REPORT AREA:
COUNT: THE COUNT OF HOW MANY PALLETS OF THE AMOUNT ARE NEEDED
COUNT
 | 500 | 1000 | 3000 | 5000 | 8000 | 20000
HOW TO DEAL WITH REMAINDERS?
IE 45633 ORDERED 45000 BUT NOT THE EXTRA 500 WE'D REQUIRE, NEED TO BUILD IN A ROUND UP FUNCTION TO THE LOWEST BUNDLE?
ALSO IF ROUNDED UP TO 500, AND 500 ALREADY IN THE COLUMN, OBVIOUSLY A BUNDLE OF 1000 WOULD PROBABLY BE CHEAPER?
I use the COUNT information in order to multiply it by the bulk purchase price for that particular bulk amount of items.
Spreadsheet: 84477d1284535576-if-statement-inventory-data-sheet-help
Sheet: inventorey-week1

 | store 1 | store 2 | store 3 | store 4
item 1 | 10 | 20 | 30 | 40
item 1 | 10 | 20 | 30 | 40
item 1 | 10 | 20 | 30 | 40
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
item 2 | 1 | 2 | 3 | 4
Spreadsheet: 160733d1339177448-excel-2007-look-up-question-lookup-from-multiple-tabs
Sheet: 174

Attendance Rules: 5 – 5.75   NoCorrective Action 6 – 7.00  No Corrective Action taken; Notice of Attendance Record 7.25 – 7.75   Verbal Warning 8 – 8.75  Written Warning 9 – 9.75  Final Written Warning with 120-day probation Next Point (10) - Review for Termination |  | Occurrence Rules: **Occurrences stay on the record for a rolling one year. **Occurrences stay on until an Approved FMLA letter is issued from UNUM. A doctors excuse does not remove an Occurrence. 8-15 minutes tardy, early departure or shift interruption~.25 16 or more minutes tardy, early departure or shift interruption ~ .50 3 hours or more absent when scheduled to work ~ 1 2 consecutive work days absent (10 hours for part-time)~2 3 or more consecutive days absent (15 hours for part-time)~2.25 Call-off or no-show for scheduled & communicated overtime~1 |  |  |  |  |  |  |  | 0 | n/a
 |  |  |  |  |  |  |  |  |  | 1 | Applied for
 |  |  |  |  |  |  |  |  |  | 0.25 | Approved
 |  |  |  |  |  |  |  |  |  |  | Denied
Tech Name | [NAME] | Total Occurrences
Tech Number | 174 | Corrective Action Step
Date | Occurrence Issued | FMLA   Applied for/ Approved/Denied | Comments
2011-04-04 00:00:00 | 1 | n/a
2011-04-11 00:00:00 | 1 | n/a
2011-08-02 00:00:00 | 1 | n/a
2011-09-18 00:00:00 | 0 | Approved
2011-09-19 00:00:00 | 0 | Approved
2012-03-22 00:00:00 | 1
2011-09-20 00:00:00 | 0 | Approved
2011-11-17 00:00:00 | 1 | n/a
2011-11-20 00:00:00 | 0 | Approved
2011-11-21 00:00:00 | 0 | Approved
2011-11-22 00:00:00 | 0 | Approved
2011-11-23 00:00:00 | 0 | Approved
2011-11-27 00:00:00 | 0 | Approved
2011-11-28 00:00:00 | 0 | Approved
2012-12-28 00:00:00 | 1 | n/a
2012-02-04 00:00:00 | 1 | n/a
2012-02-20 00:00:00 | 1 | Denied
2012-02-21 00:00:00 | 1 | Denied
2012-02-27 00:00:00 | 1 | n/a
Termed
Spreadsheet: 868765d1715441612-split-cell-with-multiple-lines-into-usable-data-explain-sheet
Sheet: Sheet1

Mon 27 May, 20:05 OSS #1 - $2,000,000 GTD [Day2] $630 552 $2,000,000 16 DAYS Mon 27 May, 20:05 OSS #2 Mystery Bounty - $1,500,000 GTD [Day2] $109 2,683 $1,500,000 16 DAYS Mon 27 May, 20:05 OSS #3 - $500,000 GTD [Day2] $66 1,703 $500,000 16 DAYS Sun 26 May, 20:05 OSS #4 Mystery Bounty - $200,000 GTD [Day2] $16.50 3,035 $200,000 15 DAYS Sun 26 May, 20:05 OSS #5 Mystery Bounty - $100,000 GTD [Day2] $2.50 7,975 $100,000 15 DAYS Sun 12 May, 17:05 OSS #89L - $50,000 GTD Low [NAME] Off $11 28 $50,000 JOIN Sun 12 May, 18:05 OSS #90 - $750,000 GTD Sunday High Roller $630 12 $750,000 JOIN Sun 12 May, 19:05 OSS #91 PKO - $750,000 GTD $2,650 4 / 6 $750,000 JOIN HOT This section is reserved to hold tournaments you are registered in. Also, you can use in other rows to place that tournament here. YOURS OSS All-In or Fold STEPS Late Reg:Lvl 9 (41:38) Super Bounty FT Pay - $400 GTD $6.60 53 $400 JOIN Late Reg:Lvl 8 (53:27) [NAME]5,000 GTD $88 34 $5,000 JOIN Late Reg:Lvl 6 (80:39) PKO - $3,000 GTD $33 86 $3,000 JOIN Late Reg:Lvl 2 (115:28) [NAME]600 GTD $11 30 $600 JOIN Late Reg:Lvl 2 (127:28) OSS #2 Mystery Bounty - $1.5M GTD [Flight] $109 7 $1,500,000 JOIN Late Reg:Lvl 7 (152:57) Early Special - $5,000 GTD $16.50 85 $5,000 JOIN Late Reg:Lvl 1 (180:28) PKO Euro WarmUp - $5,000 GTD $109 11 $5,000 JOIN Late Reg:Lvl 4 (186:53) PKO Early Special - $4,000 GTD $11 162 $4,000 JOIN
 | $400 | GTD | $6.60 | 53 | $400 | JOIN
Late Reg:Lvl 8 (53:27) [NAME] | $5,000 | GTD | $88 | 34 | $5,000 | JOIN
Late Reg:Lvl 6 (80:39) PKO | $3,000 | GTD | $33 | 86 | $3,000 | JOIN
Late Reg:Lvl 2 (115:28) [NAME] | $600 | GTD | $11 | 30 | $600 | JOIN
Late Reg:Lvl 2 (127:28) OSS #2 Mystery Bounty | $1.5M | GTD [Flight] | $109 | 7 | $1,500,000 | JOIN
Late Reg:Lvl 7 (152:57) Early Special | $5,000 | GTD | $16.50 | 85 | $5,000 | JOIN
Late Reg:Lvl 1 (180:28) PKO Euro WarmUp | $5,000 | GTD | $109 | 11 | $5,000 | JOIN
Late Reg:Lvl 4 (186:53) PKO Early Special | $4,000 | GTD | $11 | 162 | $4,000 | JOIN
Spreadsheet: drew_fossum__8711__redrock n
Sheet: INCREMENTAL TAXES

 |  |  |  |  |  |  |  |  |  |  |  | Exhibit N
 |  |  |  |  |  |  |  |  |  |  |  | Page  4 of 7
Estimated   Incremental   Taxes   Other
Line
No. |  | Description |  | Year   1 |  | Year  2 |  | Year  3 |  | Year  4 |  | Year  5 |  | Year  6 |  | Year  7 |  | Year  8 |  | Year  9 |  | Year  10
 |  |  |  | -1 |  | -2 |  | -3 |  | -4 |  | -5 |  | -6 |  | -7 |  | -8 |  | -9 |  | -10
1 |  | Ad Valorem Taxes
2 |  | Total Taxes  -  Other