tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 112082d1308243866-excel-2007-consecutive-numbers-over-110-consecutive-numbers
Sheet: test

Employee | SSN | Employee ID | Title | Hire Date | Seniority Date | Term | Eligible Date |  | Notes | 2009-06-01 00:00:00 |  | 2009-07-01 00:00:00 |  | 2009-08-01 00:00:00 |  | 2009-09-01 00:00:00 |  | 2009-10-01 00:00:00 |  | 2009-11-01 00:00:00 |  | 2009-12-01 00:00:00 |  | 2010-01-01 00:00:00 |  | 2010-02-01 00:00:00 |  | 2010-03-01 00:00:00 |  | 2010-04-01 00:00:00 |  | 2010-05-01 00:00:00 |  | 2010-06-01 00:00:00 |  | 2010-07-01 00:00:00 |  | 2010-08-01 00:00:00 |  | 2010-09-01 00:00:00 |  | 2010-10-01 00:00:00 |  | 2010-11-01 00:00:00 |  | 2010-12-01 00:00:00 |  | 2011-01-01 00:00:00 |  | 2011-02-01 00:00:00 |  | 2011-03-01 00:00:00 |  | 2011-04-01 00:00:00 |  | 2011-05-01 00:00:00
Employee 1 |  |  |  | 2010-09-09 00:00:00 | 2010-09-09 00:00:00 |  |  |  |  | 341.5 | Ineligible | 232.75 | Ineligible | 235 | Ineligible | 167 | Ineligible | 146 | Ineligible | 138 | Ineligible | 147 | Ineligible | 174.25 | Ineligible | 341.5 | Ineligible | 232.75 | Ineligible | 235 | Ineligible | 167 |  | 146 |  | 138 |  | 147 |  | 174.25 |  | 341.5 |  | 232.75 |  | 235 |  | 167 |  | 146 |  | 138 |  | 147 |  | 174.25
Employee 2 |  |  |  | 2010-11-16 00:00:00 | 2010-11-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 110 | Ineligible | 161.75 | Ineligible | 169.75 | Ineligible | 112.75 | Ineligible | 115 | Ineligible | 117.75 | Ineligible | 152.5 | Ineligible | 118 |  | 110 | Ineligible | 161.75 | Ineligible | 169.75 | Ineligible | 112.75 |  | 98.25 |  | 117.75 |  | 152.5
Employee 3 |  |  |  | 2010-09-09 00:00:00 | 2010-09-09 00:00:00 |  |  |  |  | 354.25 | Ineligible | 219.5 | Ineligible | 188 | Ineligible | 177 | Ineligible | 148.25 | Ineligible | 89.5 | Ineligible | 141.25 | Ineligible | 151.75 | Ineligible | 354.25 | Ineligible | 219.5 | Ineligible | 188 | Ineligible | 177 | Ineligible | 148.25 | Ineligible | 118 | Ineligible | 141.25 | Ineligible | 151.75 | Ineligible | 354.25 | Ineligible | 219.5 |  | 188 |  | 177 |  | 148.25 |  | 89.5 |  | 141.25 |  | 151.75
Employee 4 |  |  |  | 2010-11-16 00:00:00 | 2010-11-16 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 129.5 | Ineligible | 141.75 | Ineligible | 147 | Ineligible |  |  | 112.25 | Ineligible | 204.75 | Ineligible | 173.5 | Ineligible | 150.5 | Ineligible | 129.5 | Ineligible | 141.75 | Ineligible | 147 | Ineligible
Employee 5 |  |  |  | 2010-09-09 00:00:00 | 2010-09-09 00:00:00 |  |  |  |  | 95.44 | Ineligible | 62.5 | Ineligible | 74.6 | Ineligible | 52.6 | Ineligible | 59.5 | Ineligible | 112 | Ineligible | 95.8 | Ineligible | 62.6 | Ineligible | 78.6 | Ineligible | 219.5 | Ineligible | 188 | Ineligible | 177 | Ineligible | 97.75 | Ineligible | 96.5 | Ineligible | 41.5 | Ineligible | 48.6 | Ineligible | 116 | Ineligible | 25.4 | Ineligible | 98.2 | Ineligible | 95.6 | Ineligible | 148.25 | Ineligible | 89.5 | Ineligible | 141.25 | Ineligible | 19.5 | Ineligible
Spreadsheet: 30174d1225494284-eliminate-endings-from-part-numbers-part-numbers
Sheet: Sheet1

Part Numbers
PCM3002E
[NAME]
CDCV304PWR
SN65220DBVT
SN65LVDS2DBVR
ADS7841E
TLC2272ID
TLC2274ID
TLC5620IDR
TLV2372IDGK
TLV2374IPW
LM324DR
LMV393ID
LMV393IDR
MAX3237EIDBR
NE555DR
TL7702BIDR
REG104GA-3.3
REG104GA-3.3/2K5
TLC7701IPW
TPS3705-33DGNR
TPS72118DBVR
TPS73101DBVR
TPS73101DBVT
TPS767D325PWP
TPS77618D
TPS78601DCQR
TPS78601DCQRG4
TPS78633DCQ
TPS78633DCQR
UCC281DP-ADJ
TPS2816DBVT
[NAME]
[NAME]
74LVC1G125DCKRG4
[NAME]
CD74HC4051PWRG4
SN74AHC138D
SN74AHCT08PW
SN74AHCT1G04DCKT
SN74HC00DR
SN74HC138D
SN74HC138PW
[NAME]
SN74HC4066PW
SN74HC74D
SN74HCT00PW
SN74LVC08APWR
SN74LVC125APWR
SN74LVC139AD
SN74LVC1G07DBVR
SN74LVC1G125DBVR
SN74LVC1G17DCKR
SN74LVC1G240DBVR
SN74LVC1G79DCKT
SN74LVC244ADW
SN74LVC541ADWR
SN74LVC74APWR
TS3A5018PWRE4
REG104GA-3.3
REG104GA-3.3/2K5
TPS73101DBVR
TPS73101DBVT
TPS73115DBVTG4
TPS76333DBVR
SN74AHC1G14DBVR
SN74LVCH244ADW
SN74LVTH273DWR
MAX3223ECDWR
REG104GA-3.3
REG104GA-3.3/2K5
TPS73101DBVT
TPS76730QD
TPS76750QD
[NAME]
CD74HCT238M96
SN74ALVC16244ADGGR
[NAME]
SN74LVTH273DW
TS3A5018DR
[NAME]
NE555DR
REG104GA-3.3/2K5
TPS72118DBVR
TPS78601DCQR
[NAME]
DSD1791DBRG4
SN65220DBVR
ADS7826IDRBRG4
LM211D
LM2902DR
LM311DR
TL431IDBZR
UA78L05ACDR
REG104GA-3.3
TPS2491DGSRG4
TPS73101DBVR
TPS73218DBVR
TPS73218DBVTG4
SN74LV574APWR
SN74LVC00APWRG4
SN74LVC1G32DCKR
SN74AHC1G14DBVR
SN74AHC1G14DBVR
[NAME]
SN74LV574APWR
SN74LVC1G32DCKR
TMDS341PFCR
TS3DV416DGGR
SN75240PWR
TPIC6595N
TPS2044D
[NAME]
SN74HC14D
TS3DV416DGGR
SN75240PWG4
TPS2044AD
SN74HC14DR
TS3DV416DGGR
TMS320F2809GGMA
TMS320F2812GHHA
TMS320F2812ZHHA
TMX320F2809GGMA
DRV594VFP
DRV594VFPR
ADS8344E
[NAME]
TPS62044DGQR
TPS62054DGS
TPS62054DGSR
TPS3802L30DCKR
UCC284DP-ADJ
UCC284DPTR-ADJ
SN74AHC1GU04DCKR
TPS62054DGSRG4
UCC284DP-ADJ
ADS8341E
OPA337UA
MAX3221IPWR
TPS3802L30DCKR
UCC284DP-ADJ
SN74AHC1GU04DCKR
[NAME]
TMS320F2812GHHA
DRV594VFP
Spreadsheet: 877647d1724438547-overall-status-formula-test-spreadsheet
Sheet: Test 

Example 1
 |  |  |  | Status |  |  |  |  |  |  |  |  |  |  |  | Not Started
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Progress
Overall |  |  |  | In Progress |  |  | Overall status returns "In Progress" |  |  |  |  |  |  |  |  | Blocked
Task 1 |  |  |  | Complete |  |  |  |  |  |  |  |  |  |  |  | Complete
Task 2 |  |  |  | In Progress |  |  | If any of these contain anything other than "Complete"
Task 3 |  |  |  | Blocked
Task 4 |  |  |  | Not Started
Example 2
 |  |  |  | Status
Overall |  |  |  | Complete |  |  | Overall status returns "Complete"
Task 1 |  |  |  | Complete
Task 2 |  |  |  | Complete |  |  | If all of these contain "Complete"
Task 3 |  |  |  | Complete
Task 4 |  |  |  | Complete
Spreadsheet: 131516d1323109627-enter-data-in-first-available-cell-from-other-cell-formula-help-needed
Sheet: parameters

Rows 1-8 Payroll Administration Only
Enter in cell F2 the row number of the first employee |  |  |  |  | 10 |  | Enter in cell [NAME] the column number that has employee numbers |  |  |  |  | 4
Enter in cell F3 the row number of the last employee |  |  |  |  | 12 |  | Enter in cell M3 the first column that has Hours or $ payroll data |  |  |  |  | 18
Enter in cell F4 the row number of the D/E |  |  |  |  | 4 |  | Enter in cell M4 the last column that has Hours or $ payroll data |  |  |  |  | 27
Enter in cell F5 the row number of the 2 digit codes |  |  |  |  | 5 |  | Enter in cell M5 the column number of the sequence # |  |  |  |  | 8
Enter in cell F6 the column number of the rate # |  |  |  |  | 9 |  | Enter in cell M6 your company number |  |  |  |  | [NAME]
Enter in cell F7 the column number of the override department # |  |  |  |  | 15 |  | Enter in cell M7 the column number of the override shift # |  |  |  |  | 11
Enter in cell F8 the column number of the override division # |  |  |  |  | 13 |  | Enter in cell M8 the column number of the override branch # |  |  |  |  | 14
Enter in cell F9 the column number of the override rate $ amount |  |  |  |  | 12 |  | Enter in cell M9 the column number of the override local |  |  |  |  | 17
Enter in cell F10 the column number of the override state |  |  |  |  | 16 |  | Enter in cell M10 the column number of the job number |  |  |  |  | 10
Enter in cell H11 the path to the test folder |  |  |  |  |  |  | C:\Test
Enter in cell H12 the path to the IMPORT file |  |  |  |  |  |  | C:\Test
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
Spreadsheet: 753502d1635478732-lookup-to-show-whole-row-from-1-lookup-cell-help
Sheet: Sheet1

Type | Pipe # |  |  | Heat # | Length | Truck Tally # |  |  | Notes | Delivered
Pipe Joint - FBE |  | - | 6 | 1914330 | 37.9 | A | - | 13 |  | 2021-10-07 00:00:00
Pipe Joint - FBE |  | - | 7 | 1924540 | 36.6 | A | - | 18 |  | 2021-10-07 00:00:00
Pipe Joint - FBE |  | - | 8 | 1924540 | 39.5 | A | - | 15 |  | 2021-10-07 00:00:00
Pipe Joint - FBE |  | - | 9 | 1974656 | 38.8 | A | - | 3 |  | 2021-10-07 00:00:00
Pipe Joint - FBE |  | - | 10 | 1974656 | 39.5 | A | - | 8 |  | 2021-10-07 00:00:00
Pipe Joint - FBE |  | - | 11 | 1924542 | 39.4 | A | - | 7 |  | 2021-10-07 00:00:00
Pipe Joint - FBE |  | - | 12 | 1914330 | 39.4 | A | - | 10 |  | 2021-10-07 00:00:00
Pipe Joint - FBE |  | - | 13 | 1934833 | 39.4 | A | - | 4 |  | 2021-10-07 00:00:00
Pipe Joint - FBE |  | - | 14 | 1954942 | 39.3 | A | - | 5 |  | 2021-10-07 00:00:00
Pipe Joint - FBE |  | - | 15 | 1934833 | 39.2 | A | - | 6 |  | 2021-10-07 00:00:00
Pipe Joint - FBE |  | - | 16 | 1924540 | 39.5 | A | - | 2 |  | 2021-10-07 00:00:00
Spreadsheet: 833284d1686882315-finding-top-5-with-multiple-criteria-and-solving-for-duplicate-results-results-test
Sheet: Sheet1

 |  | Example 1 |  |  |  |  |  |  |  |  |  |  | Example 2
 |  | State | Store | Day 1 |  | Top 5 Restaurants |  |  |  |  |  |  | State | Store | Day 1 |  | Top 5 Restaurants
 |  | CA | [NAME] 1 | 487 |  | CA | 1 |  |  |  |  |  | CA | [NAME] 1 | 487 |  | CA | 1
 |  | CA | [NAME] 2 | 790 |  |  | 2 |  |  |  |  |  | CA | [NAME] 2 | 790 |  |  | 2
 |  | CA | [NAME] 3 | 734 |  |  | 3 |  |  |  |  |  | CA | [NAME] 3 | 734 |  |  | 3
 |  | CA | [NAME] 4 | 790 |  |  | 4 |  |  |  |  |  | CA | [NAME] 4 | 790 |  |  | 4
 |  | CA | [NAME] 5 | 471 |  |  | 5 |  |  |  |  |  | CA | [NAME] 5 | 471 |  |  | 5
 |  | CA | [NAME] 6 | 856 |  | NV | 1 |  |  |  |  |  | CA | [NAME] 6 | 856
 |  | CA | [NAME] 7 | 457 |  |  | 2 |  |  |  |  |  | CA | [NAME] 7 | 457
 |  | CA | [NAME] 8 | 276 |  |  | 3 |  |  |  |  |  | CA | [NAME] 8 | 276
 |  | CA | [NAME] 9 | 407 |  |  | 4 |  |  |  |  |  | CA | [NAME] 9 | 407
 |  | CA | [NAME] 10 | 302 |  |  | 5 |  |  |  |  |  | CA | [NAME] 10 | 302
 |  | NV | [NAME] 1 | 114 |  | TX | 1
 |  | NV | [NAME] 2 | 401 |  |  | 2
 |  | NV | [NAME] 3 | 301 |  |  | 3
 |  | NV | [NAME] 4 | 507 |  |  | 4
 |  | NV | [NAME] 5 | 815 |  |  | 5
 |  | NV | [NAME] 6 | 815 |  | HI | 1
 |  | NV | [NAME] 7 | 277 |  |  | 2
 |  | NV | [NAME] 8 | 360 |  |  | 3
 |  | NV | [NAME] 9 | 204 |  |  | 4
 |  | NV | [NAME] 10 | 523 |  |  | 5
 |  | TX | [NAME] 1 | 699 |  | FL | 1
 |  | TX | [NAME] 2 | 377 |  |  | 2
 |  | TX | [NAME] 3 | 482 |  |  | 3
 |  | TX | [NAME] 4 | 960 |  |  | 4
 |  | TX | [NAME] 5 | 247 |  |  | 5
 |  | TX | [NAME] 6 | 721
 |  | TX | [NAME] 7 | 534
 |  | TX | [NAME] 8 | 960
 |  | TX | [NAME] 9 | 366
 |  | TX | [NAME] 10 | 284
 |  | HI | HI Store 1 | 691
 |  | HI | HI Store 2 | 313
 |  | HI | HI Store 3 | 568
 |  | HI | HI Store 4 | 180
 |  | HI | HI Store 5 | 446
 |  | HI | HI Store 6 | 407
 |  | HI | HI Store 7 | 714
 |  | HI | HI Store 8 | 828
 |  | HI | HI Store 9 | 531
 |  | HI | HI Store 10 | 300
 |  | FL | FL Store 1 | 640
 |  | FL | FL Store 2 | 176
 |  | FL | FL Store 3 | 471
 |  | FL | FL Store 4 | 337
 |  | FL | FL Store 5 | 115
 |  | FL | FL Store 6 | 241
 |  | FL | FL Store 7 | 797
 |  | FL | FL Store 8 | 819
 |  | FL | FL Store 9 | 470
 |  | FL | FL Store 10 | 244
Spreadsheet: chris_stokley__3843__0221CT111
Sheet: 111

ID | 111 | Data | Trans Type
Zone | SP15 | Volume |  |  | Rate |  |  | ISO_Charge
MrktDt | Hour | EPMI | ISO-Prelim | [NAME] | EPMI | ISO-Prelim | [NAME] | EPMI | ISO-Prelim | [NAME]
2001-02-21 00:00:00 | 1 | -10.6318288685467 | -15.46 |  | 124.904 | 124.904 |  | 1327.95816563353 | 1930.56
 | 2 | -11.5286078704806 | -17.08 |  | 88.6235 | 88.6235 |  | 1021.705925467774 | 1513.32
 | 3 | -9.807151794443081 | -14.64 |  | 125.3632 | 125.3632 |  | 1229.45583376561 | 1835.48
 | 4 | -9.7754563793799 | -14.58 |  | 124.6464 | 124.6464 |  | 1218.475641555872 | 1817.34
 | 5 | -11.60866671956411 | -16.97 |  | 88.4235 | 88.4235 |  | 1026.478825590712 | 1500.57
 | 6 | -12.10328814976998 | -17.14 |  | 73.86240000000001 | 73.8624 |  | 893.9781526993343 | 1265.78
 | 7 | -8.443977511342101 | -14.22 |  | 127.6307 | 127.6307 |  | 1077.710676117074 | 1815.09
 | 8 | -9.104909695498861 | -14.79 |  | 26.0901 | 26.0901 |  | 237.5483686429224 | 385.86
 | 9 | -10.12063362162653 | -15.87 |  | 27.1301 | 27.1301 |  | 274.5732961864093 | 430.44
 | 10 | -11.47085664565753 | -17.63 |  | 27.9607 | 27.9607 |  | 320.7328372865376 | 492.97
 | 11 | -12.11904477440616 | -18.44 |  | 40.8955 | 40.89550000000001 |  | 495.614516762174 | 754.05
 | 12 | -12.50083378512804 | -18.88 |  | 109.8119 | 109.8119 |  | 1372.739684487406 | 2073.41
 | 13 | -12.40482704314078 | -18.68 |  | 116.3325 | 116.3325 |  | 1443.084790092717 | 2173.5
 | 14 | -12.9960686902636 | -19.53 |  | 95.8751 | 95.8751 |  | 1245.999385285892 | 1872.66
 | 15 | -12.82292886295334 | -19.29 |  | 82.97 | 82.97 |  | 1063.918407759236 | 1600.52
 | 16 | -6.008527470396402 | -9.09 |  | 25661 | 25661 |  | 154184.8234178419 | 233213.62
 | 17 | -9.360837127490942 | -14.31 |  | 118.8457 | 118.8457 |  | 1112.495709044506 | 1700.63
 | 18 | -8.753052893927102 | -13.45 |  | 143.3334 | 143.3334 |  | 1254.605094258003 | 1927.69
 | 19 | -8.553025326200189 | -13.12 |  | 22.1618 | 22.1618 |  | 189.5500945531704 | 290.69
 | 20 | -8.236279911971742 | -12.79 |  | 21.7541 | 21.7541 |  | 179.1731039214218 | 278.15
 | 21 | -11.67661548736749 | -18.4 |  | 34.4497 | 34.4497 |  | 402.255783789008 | 633.79
 | 22 | -11.11733365113416 | -17.92 |  | 36.6471 | 36.6471 |  | 407.4179268731421 | 656.55
 | 23 | -11.80471534189635 | -16.2 |  | 76.2162 | 76.2162 |  | 899.7103093467342 | 1234.59
 | 24 | -12.72985642590583 | -18 |  | 134.3053 | 134.3053 |  | 1709.687058939648 | 2417.97
 |  | -255.6793240484915 | -386.48 |  |  |  |  | 174589.6930059007 | 263815.23
Spreadsheet: 488890d1478883891-unique-without-duplicates-and-able-to-be-counted-in-a-pivot-table-or-another-solution-duplicates
Sheet: Sheet1

HIDE | FROM | PDF | RPRT | Store Name | Region | Rep | Name | Show | Date | Style | Number | Cocatenated values | Count
BVB | XZY | Store | BVB | [NAME] | ABT2245
UWBB | Anything | goes | store | South TAYLOR | 2016-10-22 00:00:00 | ABT2245
BVB | XZY | Store | BVB | [NAME] | ABT2245
UWBB | You're | the | bomb | South TAYLOR | 2016-10-22 00:00:00 | ABT2245
UWDS | Anything | goes | store | [NAME] | 2016-10-29 00:00:00 | ABT2245
UWDS | Anything | goes | store | [NAME] | 2016-10-29 00:00:00 | ABT2245
BVB | XZY | Store | BVB | [NAME] | ABT2245
UWBB | You're | the | bomb | South TAYLOR | 2016-10-22 00:00:00 | ABT2245
UWDS | Anything | goes | store | [NAME] | 2016-10-29 00:00:00 | ABT2245
Spreadsheet: 920e44a6-b272-477b-924e-89dc3d62d188
Sheet: Sheet1

Agency | Name | Phone Number | E-mail address | Name.1 | Phone Number.1 | E-mail address.1 | Name.2 | Phone Number.2 | E-mail address.2
Aging | [NAME] | 783-5166 | [EMAIL] | [NAME] | 783-8613 | [EMAIL]
Agriculture | [NAME] Smyser | 787-1065 | [EMAIL] | [NAME] | 787-1065 | [EMAIL] | Ericka Warner | 787-1065 | [EMAIL]
Banking & Securities | [NAME] | 783-3611 | [EMAIL]
Civil Service Commission | [NAME] | 783-2691 | [EMAIL]
Community and Economic Development | [NAME] | 395-9338 | [EMAIL] | [NAME] | 265-7662 | [EMAIL]
Conservation and Natural Resources | [NAME] | 346-3962 | [EMAIL] | [NAME] | 705-3741 | [EMAIL]
Corrections | [NAME] | 728-5355 | [EMAIL] | [NAME] | 728-5351 | [EMAIL]
Drug & Alcohol Programs | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Education | [NAME] | 783-9343 | [EMAIL]
Environmental Protection | Renata E. Moseley | 787-8476 | [EMAIL]
Executive Offices | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Fish And Boat Commission | [NAME] | 705-7825 | [EMAIL]
Game Commission | [NAME] | 787-7836 | [EMAIL]
General Services | [NAME] | 783-0828 | [EMAIL]
Governor's Office | [NAME] | 787-5330 | [EMAIL]
Health | [NAME] | 547-3185 | [EMAIL] | [NAME] | 547-3197 | [EMAIL]
Historical & Museum Commission | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Insurance | [NAME] | 787-8027 | [EMAIL]
Labor & Industry | [NAME] | 787-9767 | [EMAIL] | [NAME] | 787-2453 | [EMAIL]
Lieutenant Governor's Office | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Liquor Control Board | [NAME] | 783-9853 | [EMAIL]
Military and Veterans Affairs | [NAME] | 861-8850 | [EMAIL] | [NAME] | 861-6372 | [EMAIL]
Milk Marketing Board | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Municipal Retirement Board | [NAME] | 787-2065 | [EMAIL]
PA Emergency Management Agency | [NAME] | 651-2018 | [EMAIL]
PA Human Relations Commission | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Pennvest | [NAME] | 783-5446 | [EMAIL] | [NAME] | 783-5446 | [EMAIL]
Probation And Parole Board | [NAME] | 787-5699 x1348 | [EMAIL]
Psers | [NAME] | 720-4738 | [EMAIL] | [NAME] | 720-4739 | [EMAIL]
Public Utility Commission | [NAME] | 787-8714 | [EMAIL]
Public Welfare | [NAME] | [PHONE] | [EMAIL] | [NAME] | 525-5477 | [EMAIL]
Revenue | [NAME] | 787-2709 | [EMAIL] | [NAME] | 787-2709 | [EMAIL]
State | [NAME] | 783-9274 | [EMAIL] | [NAME] | 787-6604 | [EMAIL]
State Emp Retirement Board | [NAME] | 237-0242 | [EMAIL] | [NAME] | 237-0265 | [EMAIL]
State Police | [NAME] | 787-6941 | [EMAIL] | [NAME] | 783-5547 | [EMAIL]
State Tax Equalization Board | [NAME] | 395-9338 | [EMAIL] | [NAME] | 265-7662 | [EMAIL]
Transportation | [NAME] | 395-9338 | [EMAIL] | [NAME] | 265-7662 | [EMAIL]
Turnpike | [NAME] | 831-7243 | [EMAIL]
Revised 9/16/14
Spreadsheet: 53183d1253115932-cumulative-this-period-totals-cumulative-costs
Sheet: period 3 cum

Cost Centre | Department | Emp.Ref. | Name | Tax Year/Period | PAY 2 | PAY 001 | C/Forward | Gross Pay | Income Tax | [NAME] | DED 1 | B/Forward | Total Deds | Net Pay | Ers NIC | Stat.Rebate
1 | 123 | 999999999 | MCTEST T | 2009/04 | 100 | 1234 | 0 | 2133 | 41000 | 2363.24 | 500 | 0 | 43863.24 | 161136.76 | 26179.07 | 0
2 | 345 |  |  |  | 200 | 10 |  | 2355
3 | 456 |  |  |  | 300 | 12 |  | 1455
4 | 567 |  |  |  | 400 | 14 |  | 1256
5 | 678 |  |  |  | 500 | 32 |  | 2546
6 | 345 |  |  |  | 600 | 12 |  | 1236
7 | 987 |  |  |  | 500 | 10 |  | 1245
8 | 7645 |  |  |  | 550 | 15 |  | 1298
9 | 457 |  |  |  | 635 | 10 |  | 1239
10 | 879 |  |  |  | 325 | 32 |  | 123
11 | 908 |  |  |  | 653 | 32 |  | 1478
12 | 709 |  |  |  | 654 | 32 |  | 1258
13 | 678 |  |  |  | 569 | 21 |  | 1254
Spreadsheet: phillip_m_love__30683__onsys forms 0003
Sheet: Valero Sale

[NAME]
Contract: various | 2000-03-01 00:00:00
 | CPR estimate | Actual Payment | [NAME] | UA 4 RATE
[NAME] | 1199419
VALUE | 3128040.53
NET RATE |  |  |  | 2.54
Volume Variance:
 |  | =D8 (Volume Variance) * (B12-E12) CPR Price less UA 4 Rate
Rate Variance:
 |  | =(B8+D8) Actual [NAME] * (C12-B12) Actual Price less CPR Price
 | TOTAL IMPACT TO INCOME:
 |  | =Volume [NAME]
 |  | Check Figure = ((D10/D8) less E12 UA 4 Rate) * D8
CHECK FIGURE |  | ($1,526,969)/(446,480) LESS $1.947 (UA4 RATE) BY (446,480MMBTU)
Note:
Spreadsheet: 92789d1292343219-vlookup-similar-values-book1
Sheet: Sheet1

TABLE1 |  |  | [NAME]
NAME | ID |  | NAME | ID
ANGKANH |  |  | A41_2Gi_ANGKANH | ID001
KAB_PHLUK |  |  | A41_2Gi_KAB_PHLUK | ID002
PHUM_PRAMMUOY_DAB |  |  | A41_3Gi_PHUM_PRAMMUOY_DAB | ID003
KHNANG_TA_KONG |  |  | A41_2Gi_KHNANG_TA_KONG | ID004
 |  |  | A41_2G1i_PHUM_PRAMMUOY_DAB | ID005
 |  |  | A41_2G1i_THMA_KREAE_LEU | ID006
 |  |  | A41_2G1i_KHPOB_TA_NGUON | ID007
 |  |  | A41_2G1i_AE_LECH | ID008
Spreadsheet: 51428d1251110891-count-all-unique-values-text-definition-of-unique-d-book1
Sheet: Sheet1

 | 11 UNIQUE VALUES
f | 1
ew | 3
d | 1
dw | 1
ew | 3
r | 1
ef | 1
er | 2
re | 1
fer | 1
fr | 1
ew | 3
t | 1
rf | 4
er | 2
w | 1
rf | 4
fe | 2
rf | 4
we | 1
rf | 4
fe | 2
Spreadsheet: 819520d1677562348-vlookup-specific-description-from-multiple-tabs-under-specific-header-name-in-one-column-s666-pq-prices-samples
Sheet: Compare

Master [NAME] |  |  |  |  |  |  |  | Price Matched Compare from price matched tabs
Code | Date | Part Code | Name | Price 1 | Price 2 | Price 3 |  | Code | Date | Part Code | Name | Price 1 | Price 2 | Price 3
ABC | 2023-01-26 00:00:00 |  |  | 69.876 | 68.34 | 67.879 |  | ABC | 2023-01-26 00:00:00 |  |  | 69.876 | 68.34 | 67.879
DEF | 2023-01-26 00:00:00 |  |  | 1.989 |  |  |  | DEF | 2023-01-26 00:00:00 |  |  | 1.989
GHI | 2023-01-26 00:00:00 |  |  | 87.212 |  |  |  | GHI | 2023-01-26 00:00:00 |  |  | 87.212
JKL | 2023-01-26 00:00:00 |  |  | 3.4234 |  |  |  | JKL | 2023-01-26 00:00:00 |  |  | 3.4234
MNO | 2023-01-26 00:00:00 |  |  | 1.044 |  |  |  | MNO | 2023-01-26 00:00:00 |  |  | 1.044
PQR | 2023-01-26 00:00:00 |  |  | 1.232 |  |  |  | PQR | 2023-01-26 00:00:00 |  |  | 1.232
STU | 2023-01-26 00:00:00 |  |  | 2.43 |  |  |  | STU | 2023-01-26 00:00:00 |  |  | 2.43
VWX | 2023-01-26 00:00:00 |  |  | 1.876 |  |  |  | VWX | 2023-01-26 00:00:00 |  |  | 1.876
YZA | 2023-01-26 00:00:00 |  |  | 0.08997 |  |  |  | YZA | 2023-01-26 00:00:00 |  |  | 0.08997
AAA | 2023-01-26 00:00:00 |  |  | 0.1231 |  |  |  | AAA | 2023-01-26 00:00:00 |  |  | 0.1231
BBB | 2023-01-26 00:00:00 |  |  | 1.312 |  |  |  | BBB | 2023-01-26 00:00:00 |  |  | 1.312
CCC | 2023-01-26 00:00:00 |  |  | 4.2342 |  |  |  | CCC | 2023-01-26 00:00:00 |  |  | 4.2342
Code | Date | Part Code | Name | Price 1 | Price 2 | Price 3 | Check
ABC | 2023-01-26 00:00:00 |  |  | 69.876 | 68.34 | 67.879 | All TRUE
DEF | 2023-01-26 00:00:00 |  |  | 1.989 | 2.289 | 2.589 | All TRUE
GHI | 2023-01-26 00:00:00 |  |  | 87.212 | 87.512 | 87.812 | All TRUE
JKL | 2023-01-26 00:00:00 |  |  | 3.4234 | 4.0234 | 4.623399999999999 | All TRUE
MNO | 2023-01-26 00:00:00 |  |  | 1.044 | 1.644 | 2.244 | All TRUE
PQR | 2023-01-26 00:00:00 |  |  | 1.232 | 1.832 | 2.432 | All TRUE
STU | 2023-01-26 00:00:00 |  |  | 2.43 | 3.03 | 3.63 | All TRUE
VWX | 2023-01-26 00:00:00 |  |  | 1.876 | 2.476 | 3.076 | All TRUE
YZA | 2023-01-26 00:00:00 |  |  | 0.08997 | 0.68997 | 1.28997 | All TRUE
AAA | 2023-01-26 00:00:00 |  |  | 0.1231 | 0.7231 | 1.3231 | All TRUE
BBB | 2023-01-26 00:00:00 |  |  | 1.312 | 1.912 | 2.512 | All TRUE
CCC | 2023-01-26 00:00:00 |  |  | 4.2342 | 4.8342 | 5.4342 | All TRUE