tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 162729d1340040425-sumproduct-with-multiple-criteria-to-a-calculate-a-moving-average-based-on-a-range-test2-krunk-oeldere-
Sheet: Blad1

 | Waarden
Rijlabels | [NAME] | avarage [NAME]
01Week 1 | 319.25 | 63.25
01Week 2 | 375.5 | 60
01Week 3 | 374 | 60.5
01Week 4 | 381.75 | 63
01Week 5 | 145.25 | 27.75
02Week 1 | 384.75 | 64.5
02Week 2 | 375.5 | 61.5
02Week 3 | 369.75 | 59.75
02Week 4 | 367.75 | 59.25
02Week 5 | 61 | 10
03Week 1 | 391 | 67
03Week 2 | 414 | 62.5
03Week 3 | 364.25 | 61.5
03Week 4 | 397.5 | 59.5
03Week 5 | 171.25 | 29.25
04Week 1 | 367.5 | 67.75
04Week 2 | 360.75 | 64.5
04Week 3 | 369.75 | 65.75
04Week 4 | 371 | 63.25
04Week 5 | 120.5 | 18.25
05Week 1 | 385.25 | 63.25
05Week 2 | 384.5 | 61.75
05Week 3 | 375.25 | 61.75
05Week 4 | 368.25 | 58.5
05Week 5 | 129.5 | 25.5
06Week 1 | 403.5 | 57.75
06Week 2 | 313.5 | 48.75
06Week 3 | 379.3333333333333 | 66
06Week 4 | 388 | 64.33333333333333
06Week 5 | 141.3333333333333 | 20
07Week 1 | 352 | 56.66666666666666
07Week 2 | 376.6666666666667 | 56.33333333333334
07Week 3 | 356 | 62.66666666666666
07Week 4 | 345.6666666666667 | 64.66666666666667
07Week 5 | 134.6666666666667 | 28.33333333333333
08Week 1 | 386 | 59.33333333333334
08Week 2 | 350.6666666666667 | 57.66666666666666
08Week 3 | 335.6666666666667 | 62.66666666666666
08Week 4 | 337.6666666666667 | 57.66666666666666
08Week 5 | 145.3333333333333 | 27
09Week 1 | 320.6666666666667 | 60.66666666666666
09Week 2 | 337 | 57.66666666666666
09Week 3 | 312.6666666666667 | 59.33333333333334
09Week 4 | 327.6666666666667 | 61.33333333333334
09Week 5 | 99.66666666666667 | 16
10Week 1 | 313.3333333333333 | 60
10Week 2 | 314.3333333333333 | 54.33333333333334
10Week 3 | 309.6666666666667 | 55
10Week 4 | 294.3333333333333 | 60
10Week 5 | 107.6666666666667 | 24.66666666666667
11Week 1 | 310 | 61.33333333333334
11Week 2 | 303 | 54
11Week 3 | 291.3333333333333 | 57.33333333333334
11Week 4 | 238.3333333333333 | 53.33333333333334
11Week 5 | 101 | 16.66666666666667
12Week 1 | 310.6666666666667 | 56.33333333333334
12Week 2 | 316.6666666666667 | 53
12Week 3 | 317 | 60.33333333333334
12Week 4 | 243.3333333333333 | 54.66666666666666
12Week 5 | 141.3333333333333 | 24.66666666666667
Eindtotaal | 309.8039215686275 | 53.36274509803921
Spreadsheet: 135b842a-cf51-4788-af96-223fa2bec030
Sheet: Sheet1

PuChem compound | Agent_1 | PubChem compound | Agent_2 | Confidence | Feature patterns involved | Literature support
938 | niacin | 60822 | [NAME] | 0.452380952381 | C10A_C04A(0.[PHONE]) ENSP00000354222_ENSP00000219771(0.725) | PMID: 10095800, Bangladesh J Pharmacol 2008; 3: 8-16.
14219 | metformin hydrochloride | 3476 | glimepiride | 0.452380952381 | ENSP00000316136_ENSP00000229328(0.[PHONE]) | PMID: 11678974, PMID: 18849173, PMID: 16406190
6014 | promethazine hydrochloride | 3672 | ibuprofen | 0.452380952381 | D04A_C01E(0.[PHONE]) ENSP00000342560_ENSP00000251535(0.725)
3672 | ibuprofen | 62945 | pseudoephedrine sulfate | 0.452380952381 | R01B_C01E(0.[PHONE]) | (ibuprofen/pseudoephedrine/chlorpheniramine)PMID: 15562884
2462 | budesonide | 2764 | ciprofloxacin | 0.452380952381 | A07E_J01M(0.[PHONE])
14219 | metformin hydrochloride | 65999 | telmisartan | 0.452380952381 | ENSP00000229328_ENSP00000264867(0.[PHONE]) | PMID: 20415664
444025 | [NAME] | 2764 | ciprofloxacin | 0.446428571429 | S01B_J01M(0.[PHONE]) | United States Patent 6359016
938 | niacin | 150311 | ezetimibe | 0.444444444444 | C10A_C04A(0.[PHONE]) | ezetimibe/simvastatin/niacin, PMID: 20152243
11065 | amitriptyline hydrochloride | 4585 | olanzapine | 0.444444444444 | N06A_N05A(0.[PHONE]) | PMID: 18172909
4107 | methocarbamol | 3108 | dipyridamole | 0.444444444444 | M03B_B01A(0.[PHONE])
62857 | fluoxetine hydrochloride | 4748 | perphenazine | 0.444444444444 | N06A_N05A(0.[PHONE]) | PMID:8104930
2576 | carisoprodol | 3108 | dipyridamole | 0.444444444444 | M03B_B01A(0.[PHONE])
2764 | ciprofloxacin | 444036 | fluticasone propionate | 0.444444444444 | D07A_J01M(0.[PHONE])
2764 | ciprofloxacin | 5018304 | diclofenac sodium | 0.444444444444 | S01B_J01M(0.[PHONE]) | PMID: 19301941
1983 | acetaminophen | 40400 | buprenorphine | 0.444444444444 | N02A_N02B(0.[PHONE]) | PMID: 7041936
1983 | acetaminophen | 5288826 | morphine sulfate | 0.444444444444 | N02A_N02B(0.[PHONE]) | PMID: 8729309(buprenorphine/ acetaminophenl /ketoprofen)
Spreadsheet: 818146d1676622059-sum-return-look-daily-and-return-weekly-copy-of-psr-daily-report-2023
Sheet: Core Issues

DATE | ORDER NUM | BATCH NUMBER | 4 | wrong ID | wrong Paper | wrong Q | data sheet | scrap unit | COLOUR | TIME CORRECTED | PICKED BY
2023-01-04 00:00:00 | 50202 | dsr1700l | 15 | 1
2023-01-04 00:00:00 | 50038 | 03-10913 | 1 | 1
2023-01-06 00:00:00 | 46838 | 26g67210 | 12 | 3
2023-01-06 00:00:00 | 50331 | 26g35343r | 8 | 3
2023-01-06 00:00:00 | 49686 | 1417lb | 14 | 2
2023-01-06 00:00:00 | 49685 | 1417lb | 14 | 1
2023-01-09 00:00:00 | 42924 | dsr1708l | 15 | 2
2023-01-09 00:00:00 | 47618 | 26g67229 | 8 | 1
2023-01-09 00:00:00 | 49170 | 26g40541 | 5 | 2
2023-01-09 00:00:00 | 41694 | 26g67167 | 11 | 1
2023-01-09 00:00:00 | 47929 | 26g67232 | 13 | 2
2023-01-09 00:00:00 | 45360 | dsr1711l | 13 | 1
2023-01-10 00:00:00 | 48562 | 26g67210 | 13 | 4
2023-01-10 00:00:00 | 46177 | 26g67229 | 13 | 2
2023-01-10 00:00:00 | 45828 | dsr1708l | 15 | 4
2023-01-10 00:00:00 | 45584 | 26g67229 | 13 | 1
2023-01-10 00:00:00 | 41428 | dsr1708 | 12 | 4
2023-01-12 00:00:00 | 50160 | 26g67232 | 13 | 1
2023-01-12 00:00:00 | 50280 | 26g60395 | 7 | 1
2023-01-12 00:00:00 | 50535 | 26g42177 | 15 | 15
2023-01-12 00:00:00 | 50533 | dsr1616 | 15 | 10
2023-01-12 00:00:00 | 50536 | 26G42177t | 15 | 15
2023-01-12 00:00:00 | 50538 | 26G42177t | 15 | 15
2023-01-12 00:00:00 | 50537 | 26g42177t | 15 | 15
2023-01-18 00:00:00 | 50677 | 26g60397r | 6 | 1
2023-01-19 00:00:00 | 50773 | dsr1261 | 15 | 1
2023-01-20 00:00:00 | 50675 | 26g36123 | 15 | 2
2023-01-20 00:00:00 | 50740 | 26g20257 | 11 | 2
2023-01-20 00:00:00 | 49918 | dsr572l | 15 | 1
2023-01-24 00:00:00 | 50612 | 26g67259r | 3 | 1
2023-01-24 00:00:00 | 50849 | 26g40547 | 7 | 1
2023-01-24 00:00:00 | 50876 | 03-13230 | 3 | 1
2023-01-24 00:00:00 | 50892 | 26g20257 | 13 | 1
2023-01-25 00:00:00 | 50414 | 26g67234 | 13 | 1
2023-01-30 00:00:00 | 50414 | 26g67234 | 13 | 1
2023-01-30 00:00:00 | 50970 | 26g76265 | 6 | 1
2023-01-30 00:00:00 | 50869 | 26g67236
2023-02-02 00:00:00 | 50797 | 26g76231 | 5 | 4
2023-02-03 00:00:00 | 50143 | 26g20383r | 9 | 2
2023-02-06 00:00:00 | 51486 | dsr636l | 15 | 2
2023-02-06 00:00:00 | 50822 | [NAME] | 15 | 1
2023-02-06 00:00:00 | 51243 | 26g89104 | 2 | 1
2023-02-07 00:00:00 | 51382 | 26g20383 | 14 | 1
2023-02-07 00:00:00 | 51489 | dsr680l | 14 | 2
2023-02-09 00:00:00 | 51494 | 26g42177 | 14 | 1
2023-02-09 00:00:00 | 50663 | dsr1701l | 13 | 1
2023-02-09 00:00:00 | 51492 | 26g42177 | 14 | 1
2023-02-09 00:00:00 | 51477 | dsr765l | 4 | 1
2023-02-09 00:00:00 | 51458 | 26g37299 | 4 | 1
2022-02-10 00:00:00 | 51480 | 26g20375 | 14 | 1
Spreadsheet: 54291d1254310053-min-and-max-values-w-in-specific-date-range-book3
Sheet: Sheet1

Date | A | B | C | D | E
2006-02-01 00:00:00 | 11.16 | 1.8096875 | 16.42 | 5.851 | 23.19
2006-02-02 00:00:00 | 11.16 | 2.012604166666667 | 16.77 | 6.116 | 24.32
2006-02-03 00:00:00 | 11.17 | 2.096041666666666 | 16.92 | 6.127 | 24.5
2006-02-04 00:00:00 | 11.16 | 2.181770833333331 | 16.86 | 6.125 | 24.13
2006-02-05 00:00:00 | 11.17 | 2.056875000000001 | 16.57 | 6.061 | 23.67
2006-02-06 00:00:00 | 11.17 | 1.942604166666668 | 16.33 | 5.973 | 23.81
2006-02-07 00:00:00 | 11.23 | 1.860208333333332 | 17.57 | 9.193 | 23.97
2006-02-08 00:00:00 | 11.16 | 2.929791666666666 | 20.38 | 13.37 | 37.75
2006-02-09 00:00:00 | 11.15 | 2.235312499999999 | 17.46 | 7.534 | 27.94
2006-02-10 00:00:00 | 11.17 | 1.8021875 | 16.53 | 6.17 | 24.44
2006-02-11 00:00:00 | 11.18 | 1.627604166666667 | 16.2 | 5.62 | 22.64
2006-02-12 00:00:00 | 11.19 | 1.902708333333333 | 18.45 | 13.42 | 27.46
2006-02-13 00:00:00 | 11.18 | 2.482499999999998 | 19.78 | 14.19 | 38.68
2006-02-14 00:00:00 | 10.36 | 3.751458333333334 | 35.37 | 35.77 | 53.99
2006-02-15 00:00:00 | 11.13 | 20.5371875 | 54.08 | 33.88 | 113.2
2006-02-16 00:00:00 | 1.693 | 11.11770833333333 | 39.27 | 43.83 | 79.54
2006-02-17 00:00:00 | 1.473 | 16.86979166666667 | 38.25 | 35.58 | 94.1
2006-02-18 00:00:00 | 2.309 | 7.995520833333335 | 16.6 | 15.39 | 37.88
2006-02-19 00:00:00 | 3.411 | 4.829166666666667 | 13.09 | 11.01 | 26.95
2006-02-20 00:00:00 | 8.371 | 4.405416666666667 | 18.76 | 10.93 | 29.23
2006-02-21 00:00:00 | 9.365 | 8.155833333333335 | 27.21 | 15.77 | 42.18
2006-02-22 00:00:00 | 7.734 | 8.767499999999998 | 26.66 | 13.64 | 46.48
2006-02-23 00:00:00 | 1.519 | 9.600000000000001 | 28.41 | 67.52 | 99.42
2006-02-24 00:00:00 | 1.561 | 18.97604166666667 | 35.68 | 57.05 | 132.7
2006-02-25 00:00:00 | 1.502 | 9.392187499999999 | 18.2 | 21.27 | 48.69
2006-02-26 00:00:00 | 1.913 | 6.083645833333335 | 12.97 | 15.24 | 35.07
2006-02-27 00:00:00 | 11.04 | 4.889583333333333 | 21.6 | 19.74 | 40.33
2006-02-28 00:00:00 | 11.04 | 6.669375 | 24.6 | 16.37 | 49.75
2006-03-01 00:00:00 | 10.57 | 3.830520833333332 | 19.73 | 10.47 | 34.9
Spreadsheet: 158071d1337968615-error-of-n-a-when-summing-up-columns-using-index-and-match-for-multiple-worksheets-sales-report
Sheet: Apr

# |  |  |  |  |  | Existing | Existing | Existing | New | New | New | Referrals | New | Flights
 | CTUser | Reg | BO | Name | Title | Sales | Unique |  | Sales | Unique |  |  | Lines | Fund Amount
1 | SJUDGE | NE | 22 | SJUDGE | Pers Banker/Consumer Lender | 37 | 11 | 3.363636363636364 | 43 | 5 | 8.6 |  | 1
2 | MBOT | NE | 55 | MBOT | Pers Banker/Consumer Lender | 55 | 19 | 2.894736842105263 | 33 | 5 | 6.6 | 1 | 7 | 2792.1
3 | DCATE | NE | 66 | DCATE | Pers Banker/Consumer Lender | 19 | 8 | 2.375 | 85 | 13 | 6.538461538461538 |  | 1
4 | DTABOT | NE | 56 | DTABOT | Personal Banker II | 63 | 20 | 3.15 | 61 | 8 | 7.625 |  | 4 | -1963.829999999998
Spreadsheet: 693360d1598948141-dynamic-count-on-pivot-table-sample-data
Sheet: Index

 |  |  |  |  |  |  |  | Sheet types
 |  |  |  | / DRAFT |  |  |  | Input: Facts
 |  |  |  |  |  |  |  | Input: Assumptions
 |  |  |  |  |  |  |  | Calculation
 |  |  |  |  |  |  |  | Output
 |  | Type the title of this Excel model into this cell
 |  | Last changed on: 01-Sep-2020
 |  | Type a short summary of what your model does here. This whole sheet automatically updates as you continue to build your model to reflect ist sheet structure. It is a good idea to write a description on every sheet as this will make it easier for others (and yourself) to understand what the model does. Navigate quickly by clicking the sheet names.
 |  | Sheet Name | Description | Type
 | w6pd7nBS | Sheet3 |  | Calculation
 | g9+/ErSA | Sheet1 | Type a sheet description here. | Calculation
 | SNl1vbwD | Sheet2 |  | Calculation
Spreadsheet: 835603d1688676018-script-formula-macro-to-update-headers-examplebookheaders
Sheet: Sheet1

Client First Name | Client Last Name | Client Address1 | Client Address2 | Client City | Client State | [NAME] | Client Email | Client Work Phone | Client Mobile | Client Home Phone
[NAME] | Smith | 123 test st | st 3 | Phoenix | AZ | 85024 | [EMAIL] | 4567894545 | 7898521203 | 7412588522
[NAME] | [NAME] | 456 test st | st 4 | Peoria | AZ | 85025 | [EMAIL] | 5623258974 | 5648745120
Spreadsheet: 67778d1268309915-pivot-table-layout-issue-moving-from-xl03-to-xl07-test-layout
Sheet: Sheet1

Created in Excel 2003 |  |  |  |  |  | Created in Excel 2007
Customer | Qtr 1 | Qtr 2 | Qtr 3 | Qtr 4 |  |  | Data
ALFKI |  |  |  | 60 |  | Customer | Sum of Qtr 1 | Sum of Qtr 2 | Sum of Qtr 3 | Sum of Qtr 4
ANATR |  |  | 340 |  |  | ALFKI |  |  |  | 60
ANTON |  | 867.6 |  |  |  | ANATR |  |  | 340
AROUT |  |  |  | 510 |  | ANTON |  | 867.6
BERGS | 312 | 920 | 680 |  |  | AROUT |  |  |  | 510
BLONP |  | 956.25 |  |  |  | BERGS | 312 | 920 | 680
BOLID |  |  |  | 1170 |  | BLONP |  | 956.25
BONAP | 1500 | 248.4 | 524.4 |  |  | BOLID |  |  |  | 1170
BOTTM |  |  |  | 200 |  | BONAP | 1500 | 248.4 | 524.4
ERNSH |  |  |  | 180 |  | BOTTM |  |  |  | 200
FOLIG |  |  | 3125 | 1875 |  | ERNSH |  |  |  | 180
Grand Total | 1812 | 2992.25 | 4669.4 | 3995 |  | FOLIG |  |  | 3125 | 1875
 |  |  |  |  |  | Grand Total | 1812 | 2992.25 | 4669.4 | 3995
Spreadsheet: jeffrey_a_shankman__14000__Exhibit 14 (Scenario 6)
Sheet: DWR Billing Determinants

DWR Billing Determinants
Update July 22, 2001
 | System |  |  | SB 43 Customers |  |  | AB 265 Customers
Period | GWh | Current Rate | Revenues | Sales | Current Rate | Revenues | Sales | Current Rate | Revenues
Q1,2001 | 1096 | 6.5 |  |  | 6.5 |  |  | 6.5
Q2,2001 | 1919 | 6.5 |  |  | 6.5 |  |  | 6.5
Q3,2001 | 2443 | 6.5 |  |  | 6.5 |  |  | 6.5
Q4,2001 | 2348 | 6.5 |  |  | 6.5 |  |  | 6.5
Q1,2002 | 2514 | 6.5 |  |  | 6.5 |  |  | 6.5
Q2,2002 | 2662 | 6.5 |  |  | 6.5 |  |  | 6.5
Q3,2002 | 2994 | 6.5 |  |  | 6.5 |  |  | 6.5
Q4,2002 | 2655 | 6.5 |  |  | 6.5 |  |  | 6.5
Jan01-Dec02
Oct01-Dec02
Mar27-Dec02
Spreadsheet: benjamin_rogers__1066__NewCo-7-15-00
Sheet: ENA_Assumptions

ENA GenCo ASSUMPTIONS
TECHNICAL ASSUMPTIONS: |  | 1999 PROJECTS |  |  |  | 2000 PROJECTS
 |  | Brownsville | Caledonia | New Albany |  | [NAME] | Wheatland | [NAME] |  | Sub Total
Number of Turbines |  | 4 | 6 | 6 |  | 3 | 4 | 8
Summer Capacity (MW)(1) |  | 458 | 466 | 371 |  | 510 | 470 | 608
[NAME] (HHV, Btu/kWh) |  | 11406 | 12064 | 12500 |  | 10592 | 11734 | 11973
Numbers of Starts |  | 75 | 75 | 75 |  | 75 | 75 | 75
ISO Capacity |  | 494 | 504 | 396 |  | 536 | 508 | 656
PRICING ASSUMPTIONS:
Fixed Price Demand Charge ($/kW-month) |  | 4
Energy Charge ($/MWh)
Start Charge ($/Start/Turbine)
Annual Generation (MWh) |  | 624921.7078730493 | 544139.6717506632 | 410269.84 |  | 532991.6197855896 | 461312.7218562186 | 2002000
OPERATING COSTS ASSUMPTIONS:
Variable O&M ($/MWh) |  | 1.5 | 1 | 1 |  | 1.5 | 3 | 2
Major [NAME] ($/Start/Turbine) |  | 1500 | 1000 | 1000 |  | 1500 | 1500 | 1000
Annual Escalator |  | 0.03
Annual Cost (000$ in Year 2000)
Fixed O&M |  | 1563.63147 | 1721.30196 | 1878.06659 |  | 1242.481714285714 | 1515.790285714286 | 1448.540571428571
Variable O&M
Major [NAME]
Owner's Expense |  | 431.7851666666667 | 410.9306666666667 | 362.6721666666667 |  | 322.2511428571429 | 306.2677142857142 | 400.6471428571429
Property Tax Liability
TAX ASSUMPTIONS:
Federal Income Tax Rate |  | 0.35 | 0.35 | 0.35 |  | 0.35 | 0.35 | 0.35 |  | 0.35
State Income Tax Rate |  | 0.06 | 0.05 | 0.05 |  | 0.06 | 0.045 | 0.0718
Adjusted Gross Income Tax |  | N/A | N/A | N/A |  | N/A | 0.034 | N/A
Gross Receipts Tax Rate |  | N/A | N/A | N/A |  | N/A | 0.012 | N/A
Franchise Tax Rate (Year 1) |  | 0.0025 | 0.0025 | 0.0025 |  | 0.0025 | N/A | 0.0015
Franchise Tax Rate (Year 2-20) |  | 0.0025 | 0.0025 | 0.0025 |  | 0.0025 | N/A | 0.001
(1) Includes additional capacity of 20 MW at Caledonia and 15 MW at New Albany, with installation of evaporative coolers by June 2000.
Spreadsheet: 767044d1644253978-ifs-statement-with-concat-book3-1-
Sheet: Sheet1

Monthly | Hours | #Mi | 173.[PHONE] | 173.[PHONE]
Total | Annual | Hours | #Mi | 2080
Merit | % | #Mi | [NAME] | [NAME]
OT | Rate | Factor | #Mi | 1.5
Attrition | % | #Mi | 4.e-002 | 4.e-002
MIP | % | Modifier | #Mi | 6.3e-002
401K | % | #Mi | 4.e-002 | 4.e-002
Benefits | % | #Mi | 8.e-002 | 8.e-002
Taxes | % | #Mi | 1.5e-002 | 1.5e-002
PC | Rate | #Mi | 35 | 35
Cell | Phone | Rate | #Mi | 40
Auto | Lease | Rate | #Mi | 666.[PHONE]
Monthly | Hours | 173.[PHONE] | 173.[PHONE] | 173.[PHONE]
Spreadsheet: 95274d1294903096-formula-that-looks-at-the-text-and-month-and-then-adds-the-correct-numbers-copy-of-xl0000003
Sheet: Sheet1

Employee | Amount | Date
Smith, [NAME] | 2231.32 | 2011-01-01 00:00:00
Doe, [NAME] | 156 | 2011-01-16 00:00:00 |  |  |  |  | Sum of Amount
Smith, [NAME] | 658.32 | 2011-01-22 00:00:00 |  |  |  |  | Employee | Date | Total
Doe, [NAME] | 123.34 | 2011-03-20 00:00:00 |  |  |  |  | Doe, [NAME] | Jan | 156
Doe, [NAME] | 6524 | 2011-08-06 00:00:00 |  |  |  |  |  | Mar | 123.34
Smith, [NAME] | 2365 | 2011-06-08 00:00:00 |  |  |  |  |  | Aug | 6524
 |  |  |  |  |  |  | Smith, [NAME] | Jan | 2889.64
Smith, [NAME] | Amount |  |  |  |  |  |  | Jun | 2365
January, 2011 |  |  |  |  |  |  | Grand Total |  | 12057.98
February, 2011
March, 2011
Spreadsheet: 763084d1641986700-count-based-on-entry-uk-prod-lt-holiday-calendar-2022-copy
Sheet: Dec 22

 | Absence Type Key | V | Vacation |  |  | H | Public Holiday |  |  | S | Sick |  | ML/PL | Maternity/ Paternity leave |  |  | BD | Birthday |  |  | T | Training
 | 2022-12-01 00:00:00 | Dates of Absence |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022
 |  | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Days
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | Fran |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | Jo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | Maria |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | Mark |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | Michelle |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
 | Zak |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H | V | V | V
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H | H
Spreadsheet: 54612d1254655055-excel-accounting-help-pm-tracking
Sheet: Purchases

Date | Code | Item | Purchased | Price | Total
2009-07-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 2 | 1 | 2
2009-07-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 50 | 1 | 50
2009-07-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 50 | 1 | 50
2009-07-29 00:00:00 | [NAME] | 50mm x 35mm Keyring | 100 | 1 | 100
2009-08-29 00:00:00 | PG-Snow | Snow Photo Globe | 1 | 1 | 1
2009-08-29 00:00:00 | PG-Glitter | Glitter Photo Globe | 6 | 1 | 6
2009-08-29 00:00:00 | PG-Snow | Snow Photo Globe | 6 | 1 | 6
2009-08-29 00:00:00 | PG-Heart | Heart Photo Globe | 6 | 1 | 6
2009-08-29 00:00:00 | PG-Snow | Snow Photo Globe | 45 | 1 | 45
2009-08-29 00:00:00 | MUG-Glass-Stein | [NAME] Beer Stein | 2 | 1 | 2
2009-09-29 00:00:00 | KR-BOB | Black Bottle Opener Keyring | 8 | 1 | 8
2009-09-29 00:00:00 | DC-90S | 90mm Square Acrylic Drink Coaster | 10 | 1 | 10
2009-09-29 00:00:00 | DC-90S | 90mm Square Acrylic Drink Coaster | 16 | 1 | 16
2009-09-29 00:00:00 | DC-90S | 90mm Square Acrylic Drink Coaster | 16 | 1 | 16
2009-09-29 00:00:00 | MP-DIY | Do It Yourself Mousepad | 1 | 1 | 1
2009-09-29 00:00:00 | MP-DIY | Do It Yourself Mousepad | 18 | 1 | 18
2009-10-04 00:00:00 | MP-DIY | Do It Yourself Mousepad | 12 | 1 | 12
2009-10-04 00:00:00 | MP-DIY | Do It Yourself Mousepad | 18 | 1 | 18
2009-10-04 00:00:00 | MP-Printed | Printed Mousepad | 10 | 1 | 10
Spreadsheet: 820872d1678315865-matching-two-columns-and-returning-the-third-example
Sheet: Transactions

Date | Type | Description | Value | Column1 | [NAME] | Category should be
2023-03-01 00:00:00 |  | UKI T/A DIRECTLINE | -10 |  |  | wife
2023-03-01 00:00:00 |  | UKI T/A DIRECTLINE | -20 |  |  | me
2023-03-02 00:00:00 |  | UKI T/A DIRECTLINE | -30 |  |  | dog
2023-03-02 00:00:00 |  | UKI T/A DIRECTLINE | -40
2023-03-02 00:00:00 |  | Savings Account | -50 |  |  | To Savings
2023-03-03 00:00:00 |  | SAVINGS ACCOUNT | 60 |  |  | From Savings
2023-03-04 00:00:00 |  | BRITISH GAS | -20 |  |  | Energy
2023-03-05 00:00:00 |  | WATER | -150 |  |  | Energy
Spreadsheet: 857846d1706718889-sum-hours-based-on-date-range-and-id-and-then-summarize-on-a-separate-tab-eot-sample-v2
Sheet: COSTA

Name | ID |  |  |  |  | CHARGE MONTH: |  |  |  | PAYROLL WORKSHEET
COSTA |  |  |  |  |  | 2023-11-01 00:00:00 |  |  |  | Schedule: | Weekly |  |  | Mo. [NAME]: |  |  |  | Hrly [NAME].: |  |  |  | Position: | Officer
 |  |  |  |  |  |  |  |  |  | Shift: | Grave |  |  | Stipends/UA |  |  |  | Bi-Wk Equiv.: |  |  |  | Union: | R08
LEAVE USAGE
TYPE | V | S | SF | CTO | HC | IH | PH |  |  |  |  |  | Hours Worked
DATE |  |  |  |  |  |  |  |  |  | Period # | Start | End | Regular | Holiday | Overtime | CTO | Total | Swing | S Due | Grave | G Due | Total Comp | OT Rate
 |  |  |  |  |  |  |  |  |  | 1 | 2023-10-22 00:00:00 | 2023-11-04 00:00:00 | 80 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 2 | 2023-11-05 00:00:00 | 2023-11-18 00:00:00 | 80 |  |  | 0
 |  |  |  |  |  |  |  |  |  | 3 | 2023-11-19 00:00:00 | 2023-12-02 00:00:00 | 80 |  |  | 0
 |  | NO TIME TAKEN |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | Total All OT Worked:
TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | OT Reported by Dept:
 |  |  |  |  |  |  |  |  |  |  |  |  | Less Holiday RDO:
OVERTIME AUTHORIZED
REASON | DATE | FROM | TO | HOURS | EARN ID | PAY CODE | SWING | GRAVE |  |  |  |  |  | Difference:
FOOTBALL VS BOISE | 2023-11-04 00:00:00 | 1500 | 2330 | 8.5 | OTPR | 871-425P |  | 1.5
BOARD OF TRUSTEE MEETINGS | 2023-11-06 00:00:00 | 900 | 1330 | 4.5 | OTPR | 213-425P
BOARD OF TRUSTEE MEETINGS | 2023-11-07 00:00:00 | 700 | 2000 | 13 | OTPR | 213-425P
BOARD OF TRUSTEE MEETINGS | 2023-11-08 00:00:00 | 700 | 1700 | 10 | OTPR | 213-425P
VETERANS DAY - REG SHIFT | 2023-11-10 00:00:00 |  |  | 12 | HG6 | 213-425HP
FOOTBALL VS NEW MEXICO | 2023-11-18 00:00:00 | 1600 | 2345 | 7.8 | OTPR | 871-425P |  | 1.75
THANKSGIVING DAY - REG SHIFT | 2023-11-23 00:00:00 |  |  | 12 | HG6 | 213-425HP
Total
 |  |  |  | Regular Shift Differential Hours: |  |  |  | 180
 |  |  |  | Total Shift Differential Hours to Pay:
Spreadsheet: 0da39b64-26a0-4941-85a9-ef619a9e6a9e
Sheet: Exhibit XVIII, Page 2

Owners Forms
USAA-CIC
Pennsylvania
Catastrophe & Total Loss History
Accident Year | Catastrophe Incurred Losses | Total Incurred Losses
1993-06-30 00:00:00 | 324726 | 1348340
1994-06-30 00:00:00 | 846900 | 3138212
1995-06-30 00:00:00 | 32042 | 2244029
1996-06-30 00:00:00 | 1046150 | 3480585
1997-06-30 00:00:00 | 108694 | 2009313
1998-06-30 00:00:00 | 328524 | 2663839
1999-06-30 00:00:00 | 196185 | 3278390
2000-06-30 00:00:00 | 1241516 | 5598217
2001-06-30 00:00:00 | 156647 | 3833596
2002-06-30 00:00:00 | 69954 | 3868750
2003-06-30 00:00:00 | 457367 | 4401651
2004-06-30 00:00:00 | 1196312 | 6929144
2005-06-30 00:00:00 | 825340 | 8835244
2006-06-30 00:00:00 | 565786 | 7516935
2007-06-30 00:00:00 | 949749 | 8099781
2008-06-30 00:00:00 | 310283 | 10989905
2009-06-30 00:00:00 | 893694 | 11260337
2010-06-30 00:00:00 | 6182182 | 18610140
2011-06-30 00:00:00 | 2421095 | 16923863
2012-06-30 00:00:00 | 4188357 | 17356359
Spreadsheet: 833959d1687359598-format-table-based-on-types-values-sample_real
Sheet: Аркуш1

type | title |  | Production plan
1 | Ford C-Max |  | Ford C-Max
1 | Ford C-Max |  | Ford C-Max
1 | Ford C-Max |  | Ford C-Max
2 | Ford C-Max |  | Needed funding
2 | Ford Fusion |  | Ford C-Max
3 | Ford [NAME] |  | Ford Fusion
3 | Ford [NAME] |  | Budget
3 | Ford [NAME] |  | Ford [NAME]
 |  |  | Ford [NAME]
 |  |  | Ford [NAME]
1 - "Production plan", 2 - "Needed funding", 3 - "Budget"
Types cannot be written in the table, only in formula