tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 90244d1290002592-data-all-over-the-sheet-to-be-cleaned-prepforpivot
Sheet: Final Result

 |  | Group
Number | Name | AAA | BBB | CCC | DDD | Grand Total
111111111 | [NAME] | 500 |  | 1000 | 500 | 2000
222222222 | [NAME] | 400 |  | 800 | 400 | 1600
333333333 | Jake | 255 |  | 510 | 255 | 1020
444444444 | [NAME] | 200 |  | 200 |  | 400
555555555 | [NAME] | 300 |  | 300 |  | 600
666666666 | [NAME] | 700 | 6854 | 700 | 6854 | 15108
777777777 | Pauline | 200 | 400 | 200 | 400 | 1200
888888888 | Timmy | 400 | 954 | 400 | 954 | 2708
999999999 | [NAME] | 255 | 510 | 255 | 510 | 1530
Grand Total |  | 3210 | 8718 | 4365 | 9873 | 26166
Spreadsheet: 711855d1609946473-cumulative-average-for-current-year-formula-ups2021
Sheet: Aug2021

UPS Shipping
 | STANDARD |  | OVERNIGHT
Date: | # [NAME] | $Cost$ | # [NAME] | $Cost$
2021-08-01 00:00:00
2021-08-02 00:00:00
2021-08-03 00:00:00
2021-08-04 00:00:00
2021-08-05 00:00:00
2021-08-06 00:00:00
2021-08-07 00:00:00
2021-08-08 00:00:00
2021-08-09 00:00:00
2021-08-10 00:00:00
2021-08-11 00:00:00
2021-08-12 00:00:00
2021-08-13 00:00:00
2021-08-14 00:00:00
2021-08-15 00:00:00
2021-08-16 00:00:00
2021-08-17 00:00:00
2021-08-18 00:00:00
2021-08-19 00:00:00
2021-08-20 00:00:00
2021-08-21 00:00:00
2021-08-22 00:00:00
2021-08-23 00:00:00
2021-08-24 00:00:00
2021-08-25 00:00:00
2021-08-26 00:00:00
2021-08-27 00:00:00
2021-08-28 00:00:00
2021-08-29 00:00:00
2021-08-30 00:00:00
2021-08-31 00:00:00
Totals:
Spreadsheet: 886951d1737045625-vlookup-match-over-multiple-tabs-in-worksheet-multi-tab-example
Sheet: CLASSIC

CLASSIC
Standard Range
Part No. | Description
CLH-S-BK | Classic & Headrest - Black Spacer Fabric | 310
CLH-V-BK | Classic & Headrest - Black Soft Grain Vinyl | 320
CLH-V-C-BK | Classic & Headrest - Black Soft Grain Vinyl outers/Black Corduroy centres | 300
CLH-V-BW-BK | Classic & Headrest - Black Soft Grain Vinyl outers/Black Basketweave centres | 350
CLH-L-M-BK | Classic & Headrest - Black Leather Facings/Black Vinyl Back | 360
CLH-L-BK | Classic & Headrest - Black Leather | 320
Spreadsheet: 1cd11b2c-12a7-4b11-ae84-d5354438c094
Sheet: 11a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 504 |  | 504
 | FRA | 13324 |  | 13324
 | Exotic
 | Inflation
 | IRS- [NAME] | 22112 |  | 22112
 | OIS | 1144 |  | 1144
 | VNS | <100 |  | <100
 | Zero Coupon | 152 |  | 152
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | 37236 | N/A*** | 37236
Estimated swap transaction volumes, week ending November 16, by product type and tenor (in number of transactions), all participant types and currencies.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 484613d1476357076-increase-excelnoviceuk
Sheet: Sheet1

 |  | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Total | % increase
 | 2014-2015 | 172220.77 | 197905.7 | 183176.7 | 135534.9 | 115595.9 | 109463.9 | 158504.5 | 83690 | 125369.7 | 99196.4 | 150367.1 | 94296.78 |  | N/A
 | 2015-2016 | 129337.8 | 84474.3 | 98308.6 | 134667.8 | 183409.6 | 117744.5 | 153147.3 | 78377.8 | 57478 | 75613 | 148785.3
 | 2016-2017
 |  | I would only like it to take into account up untill september as Octobers values have not been finalised. |  |  |  |  |  |  | I would like a formula in this cell that tells me if I am up or down in comparison to the preivious year.
Spreadsheet: darrell_schoolcraft__7701__March 2002 Maint
Sheet: Sheet1

MARCH 2002
2002-03-06 00:00:00
SUN | MON | TUE | WED | THU | FRI | SAT
 |  |  |  |  | 1 | 2
 |  | [NAME] [NAME]
 |  |  |  | [NAME]
N M/L
S M/L
Bondad
San Juan Basin
[NAME]
Havasu
3 | 4 | 5 | 6 | 7 | 8 | 9
 |  |  |  |  |  | L1100 & 1103 Blythe Ties
[NAME]
[NAME] [NAME] |  |  | [NAME]
 |  | [NAME] Shell Half | Caprock 2 Generator 3 hr | Dutch Flat 1&2 Emissions |  | 750 [NAME] rate for 12 hrs
 | Dutch Flat 1 Insp
 | L 1103 VAI-TSA Pig |  | L 1100 VAI-TSA Pig
 | Window Rock 5B Insp
N M/L | -40 | -40 | -40 | -15
S M/L
Bondad
San Juan Basin
[NAME] |  | -35
Havasu | -65 | -65
10 | 11 | 12 | 13 | 14 | 15 | 16
 | Afton PLC
 | Bondad 1A Insp |  |  |  |  | L 1208 Recvr FLG-V 31
 | [NAME]
 |  |  | Wenden B Emissions
 |  | Mojave ESD 8 hrs | Wenden B Insp
 | L 1600 Pig ORA-CGB
 | Castle Dome Insp/ESD
 | Window Rock 3A Insp
 |  | L 1103 VAI-TSA Calip
N M/L | -40 | -40 | -40 | -30 |  | -60
S M/L
[NAME] | -85 | -85
San Juan Basin
[NAME]
Havasu |  |  | -85 | -85
17 | 18 | 19 | 20 | 21 | 22 | 23
Afton PLC
 | [NAME]
 |  | L 3162 Tie-In L 2000
 |  | Willcox Batteries
 |  | Oracle Emissions Test | Oracle Valve Ops
 | L1110 Replace MP 102
 | [NAME] 1B Insp
 | L1300 Eff Test Vcity-BWA | L1300 Eff Test BWA-LAG | 430 MMcf/d Min
 | Roswell 3 Insp
 |  | L 1600 Calip ORA-CGB
N M/L | -20 | -20 | -20
S M/L @ Pecos | -20 | -20 | -20 | -20 | -20 | -20
S M/L @ Waha | -90 | -360 | -90
Bondad
San Juan Basin
[NAME] | -85 | -85 | -85 | -15
Havasu
24/31 | 25 | 26 | 27 | 28 | 29 | 30
Afton PLC |  |  |  |  |  | 2002-03-31 00:00:00
L1110 Replace MP 102 |  |  |  |  | L 1100 lower MP 534
 | Keystone 2B Controls
 | Alamo Lake 1 Insp
 | [NAME]
 | San Juan ML Sta ESD
 | Window Rock 4A Insp
 | L 1300 Vcity-BWA Pig
N M/L | -35 | -35
S M/L @ Pecos | -20 | -20 | -20 | -20
Bondad | -35 | -35 | -35 | -35 | -35
San Juan Basin | -35 | -35 | -35 | -35 | -35
[NAME] |  | -60 | -60 | -60 | -60
Havasu
[NAME] 1A OH   Mar 31 - Apr 15
[NAME] to Waha | March 18, 20-22 | -50
 | March 19 | "Zero" flow to [NAME]
 | March 25 - 29 | -50
Spreadsheet: 753849d1635786697-automatic-cell-population-from-another-tab-resource-overview
Sheet: Pipeline

 |  | Project Type | Start Date | Skill Type | 2021-11-01 00:00:00 | 2021-11-02 00:00:00 | 2021-11-03 00:00:00 | 2021-11-04 00:00:00 | 2021-11-05 00:00:00 | 2021-11-06 00:00:00 | 2021-11-07 00:00:00 | 2021-11-08 00:00:00 | 2021-11-09 00:00:00 | 2021-11-10 00:00:00 | 2021-11-11 00:00:00 | 2021-11-12 00:00:00 | 2021-11-13 00:00:00 | 2021-11-14 00:00:00 | 2021-11-15 00:00:00 | 2021-11-16 00:00:00 | 2021-11-17 00:00:00 | 2021-11-18 00:00:00 | 2021-11-19 00:00:00 | 2021-11-20 00:00:00 | 2021-11-21 00:00:00
 |  | Project X | 2021-11-03 00:00:00 | Skill 1 |  |  | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project X |  | Skill 2 |  |  |  |  | 15 | 15 | 15 | 15
 |  | Project X |  | Skill 3 |  |  |  |  | 15 | 30 | 30
 |  | Project X |  | Skill 4 |  |  |  |  |  | 7.5 | 7.5
 |  | Project Y | 2021-11-06 00:00:00 | Skill 1 |  |  |  |  |  | 7.5 | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Y |  | Skill 2 |  |  |  |  |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5
 |  | Project Y |  | Skill 3 |  |  |  |  |  |  |  |  | 7.5 | 15 | 15 | 15 | 15
 |  | Project Y |  | Skill 4 |  |  |  |  |  |  |  |  | 7.5 | 15 | 15
 |  | Project Z | 2021-11-10 00:00:00 | Skill 1 |  |  |  |  |  |  |  |  |  | 7.5 | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15 | 7.5 | 7.5
 |  | Project Z |  | Skill 2 |  |  |  |  |  |  |  |  |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Z |  | Skill 3 |  |  |  |  |  |  |  |  |  |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
 |  | Project Z |  | Skill 4 |  |  |  |  |  |  |  |  |  |  |  | 7.5 | 15 | 15 | 15 | 15 | 7.5 | 7.5 | 15 | 15
Spreadsheet: 454406d1459837461-index-match-reconcilatin-file-attached-qaabb_reconcilation_mar16
Sheet: CZABB

IG RECONCILIATION  March 2016 |  |  |  |  |  |  |  |  | chk
VENDOR | CZABB
VENDOR CODE
 |  | IGB CODE | USD | EUR | QAR | AED | CHF
VENDOR BALANCE AS PER STATEMENT OF ACCOUNT |  | IGB165 | 210666.4 | 9322
 |  | IGB195
 |  | IGB705
 |  | IGB235
QAABB SAP BALANCE AS OF 31st March 2016 |  | IGB255 |  | 98811
 |  | IGB525 |  | -263496
 |  | IGB223
 |  | IGB615
OPEN GR |  | IGB535
TOTAL INVOICES NOT BOOK LESS GRN DONE ([NAME]) |  | IGB525
TOTAL QAABB BALANCE
UNRECONCILED INVOICES IN VENDOR STATEMENT OF ACCOUNT (INVOICES NOT BOOKED IN SAP)
Invoice no | Date | PO Ref | PC | Curr | Amount | Booked | Open GR | [NAME]
Booked in SAP not claiming by counter party
Invoice no | Date | PO Ref | PC | Curr | Amount | Booked | Open GR | [NAME]
PREPARED BY |  |  | APPROVED BY
[NAME] |  |  | Sajeesh.M
Spreadsheet: 722136d1615055862-find-x-in-a1-paste-z-in-b2-exceltest
Sheet: Sheet1

Stk# | Description | Department
19104 | 1921 Anejo 750ML | Liquor
19105 | 1921 Blanco Tequila 750ML
19106 | 1921 La Crema de Mexico 750ML
19103 | 1921 Reposado [NAME]
256 | Alba Vineyard Blueberry Wine 500 | Wine
257 | Alba Vineyard Red Raspberry 500M
21069 | Astral Tequila Blanco 750ML
20545 | B Cellars Blend 23 White Wine
20122 | B Cellars Blend 26 Red Wine
20546 | B Cellars Maldonado Chardonnay
860 | Baron De Luze Bordeaux Rouge 750
14936 | Belhaven Black Stout 4PK Can | Beer
970 | Belhaven Scottish Ale 6PK
17269 | [NAME] Thistle 6PK Btl
20213 | [NAME] Csk Bbn 750ML
20214 | [NAME] 750
22796 | Belle Meade Reserve Bourbon 750M
Spreadsheet: darrell_schoolcraft__7316__imball0202
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 |  | 150
2 | 309 | 150
3 | 285 | 150
4 | 252 | 150
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
2002-01-31 00:00:00 |  |  | 174567
2002-02-04 00:00:00
CBS Volume
 |  |  | 76390
Spreadsheet: 489656d1479379178-caculate-time-worked-overtime-from-one-day-to-the-next-ot-auto-calc-l
Sheet: Sheet2

 |  |  | Time IN |  | Time OUT | Hours - Minutes worked | Decimaal
 |  | 2016-11-13 00:00:00 | 22:15:00 | 2016-11-14 07:15:00 | 07:30:00
 |  | 2016-11-14 00:00:00 | 22:15:00 | 2016-11-15 00:00:00 | 07:45:00
 |  | 2016-11-15 00:00:00 | 22:15:00 | 2016-11-16 00:00:00 | 08:00:00
 |  | 2016-11-16 00:00:00 | 22:15:00 | 2016-11-17 00:00:00 | 07:30:00
 |  | 2016-11-17 00:00:00 | 22:15:00 | 2016-11-18 00:00:00 | 07:00:00
 |  | 2016-11-18 00:00:00 | 22:15:00 | 2016-11-19 00:00:00 | 07:45:00
 |  | 2016-11-19 00:00:00 | 22:15:00 | 2016-11-20 00:00:00 | 08:15:00
 |  | 2016-11-20 00:00:00 | 22:15:00 | 2016-11-21 00:00:00 | 08:30:00
 |  |  | This will always be PM |  | This will always be AM
Spreadsheet: 1e6989b8-7270-4dd2-8278-057cfe0e7bd8
Sheet: 2004-05

Table C
Graduate Student Numbers by Faculty and Year Group
2004-05
Faculty | Year 1 | Year 2 | Year 3 | Year 4 | Year 5+ | Year 6+ | Total
Arts and Humanities | 436 | 188 | 38 | 17 | 11 | 2
Built Environment | 549 | 242 | 63 | 25 | 14 | 17
Clinical Sciences | 379 | 378 | 266 | 127 | 28 | 7
Eastman Dental Institute | 77 | 96 | 66 | 42 | 25 | 3
Engineering | 458 | 237 | 178 | 86 | 53 | 11
Laws | 402 | 28 | 5 | 1 | 0 | 1
Life Sciences | 500 | 255 | 186 | 56 | 18 | 11
Mathematical and Physical Sciences | 182 | 98 | 87 | 11 | 2 | 0
Social and Historical Sciences | 883 | 250 | 104 | 45 | 19 | 10
Total
The Clinical Sciences total includes the Graduate Institutes of Child Health, Neurology and Ophthalmology and the Eastman Dental Institute.
Spreadsheet: 151251d1334841632-matching-columns-and-combining-numbers-example
Sheet: Sheet1

Recipient_Name | Recipient_Description | State | All Emails
[NAME] | Representative | IL | 8
[NAME] | Representative | IL | 13
[NAME] | Representative | IL | 20
[NAME] | Representative | IL | 6
[NAME] | Representative | IL | 1
[NAME] | Representative | IL | 18
[NAME] | Representative | IL | 22
[NAME] | Representative | CA | 27
[NAME] | Representative | CA | 1
[NAME] | Representative | CA | 52
[NAME] | Representative | CA | 49
[NAME] | Representative | WA | 7
[NAME] | Representative | WA | 21
[NAME] | Representative | WA | 23
[NAME] | Representative | NE | 5
[NAME] | Representative | NE | 6
[NAME] | Representative | NE | 2
[NAME] | Senator | MN | 103
[NAME] | Senator | MN | 7
[NAME] | Senator | MN | 196
[NAME] | Senator | MN | 172
Spreadsheet: 853008d1702977184-reduce-occurances-of-data-book1
Sheet: Sheet1

Tool Machine
129 UK/FF/MC25
129 UK/FF/MC27 |  | 129 UK/FF/MC27
129 UK/FF/MC26 |  | 129 UK/FF/MC26
205 UK/FF/MC25 |  | 205 UK/FF/MC25
229 UK/FF/MC24 |  | 229 UK/FF/MC24
229 UK/FF/MC24 |  | 229 UK/FF/MC25
229 UK/FF/MC24
229 UK/FF/MC24
229 UK/FF/MC24
229 UK/FF/MC24
229 UK/FF/MC24
229 UK/FF/MC25
229 UK/FF/MC25
229 UK/FF/MC25
229 UK/FF/MC25
229 UK/FF/MC25
229 UK/FF/MC25
229 UK/FF/MC25
229 UK/FF/MC25
Spreadsheet: 136231d1326484254-combine-multiple-data-sets-into-one-master-spreadsheet-example
Sheet: Desired Summary

Category | Sub-category | Invoice 1 | Invoice 2 | Total
Books | The Hobbit | 12 | 10
Books | [NAME] |  | 7
Food | Grapes | 6.75 | 5
Toys | He-Man | 5.5 | 1
Toys | Transformers | 10
 | Total
Spreadsheet: 165285d1341140625-repeat-a-combination-of-rows-and-columns-example
Sheet: Sheet1

Row 1 | Row 2 |  |  |  |  |  |  |  |  |  | Expected Result
A | 1 |  |  |  |  |  |  |  |  |  | A | 1
B | 2 |  |  |  |  |  |  |  |  |  | A | 2
C | 3 |  |  |  |  |  |  |  |  |  | A | 3
 | 4 |  |  |  |  |  |  |  |  |  | A | 4
 | 5 |  |  |  |  |  |  |  |  |  | A | 5
 |  |  |  |  |  |  |  |  |  |  | B | 1
 |  |  |  |  |  |  |  |  |  |  | B | 2
 |  |  |  |  |  |  |  |  |  |  | B | 3
 |  |  |  |  |  |  |  |  |  |  | B | 4
 |  |  |  |  |  |  |  |  |  |  | B | 5
 |  |  |  |  |  |  |  |  |  |  | C | 1
 |  |  |  |  |  |  |  |  |  |  | C | 2
 |  |  |  |  |  |  |  |  |  |  | C | 3
 |  |  |  |  |  |  |  |  |  |  | C | 4
 |  |  |  |  |  |  |  |  |  |  | C | 5
Spreadsheet: 693988d1599251202-auto-filling-based-on-previous-cells-xlf20200904-autofill_down_row_at_year_end-for_danielllmzmz-as
Sheet: Sheet1

 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
Line1 | 20 | 24 | 27 | 31 | 37 | 47 | 53 | 62 | 54 | 36 | 32 | 29
Line2
Weights | 0.5
 |  | I assume this must be 1/3, not exactly 0.33 as in the pic - otherwise the figures don't match
 |  | Similarly, I assume this is 1/6
 | Values from picture on forum, for checking
 | 31.167 | 30.583 | 30.514 | 30.636 | 30.591 | 30.597 | 30.603 | 30.599 | 30.6 | 30.6 | 30.6 | 30.6
 |  |  |  | ↑ this is different but I think that must be from a typo
Spreadsheet: 37214d1235148616-subtracting-2-columns-of-data-from-each-other-when-labels-in-separate-columns-match-example
Sheet: Sheet1

DATASET 1 |  | DATASET 2
OPP IDs | Sums | Opportunity | Expected Value | Dx - By IF Dx present in By
1-1W9ODJT | 54799 | 1-27OWHAC | 3,000.00
1-2CWNICU | 13500 | 1-2CWNICU | 25,088.00
1-2L2MPVN | 65600 | 1-2L2MPVN | 124,272.00
1-2N869TM | 0 | 1-2N869TM | 500.00
1-2ROUMMB | 30000 | 1-2ROUMMB | 30,000.00
1-2SKKX7Q | 51855 | 1-2SJN6EP | 13,178.00
1-3TDP1JJ | 250 | 1-3508L31 | 60.00
1-3THRLYP | 0 | 1-3N23YEQ | 1,000.00
1-3UD4V1Q | 4491 | 1-3TDP1JJ | 360.00
1-3X0RXUM | 4451 | 1-3THRLYP | 1.00
1-3ZI81IM | 12306 | 1-3UCFCSH | 100.00
 |  | 1-3UD4V1Q | 4,883.00
 |  | 1-3X0RXUM | 3,561.30
 |  | 1-3XLCP5N | 1.00
 |  | 1-3ZI81IM | 16,408.00
Spreadsheet: 648345d1572987045-how-to-find-the-value-of-a-product-or-aggregation-according-to-its-sum-product-value_mod
Sheet: Solver_setup

 |  |  |  |  |  |  | VALUE CODE | PRODUTS
 |  |  |  |  |  |  | 1060 | GREEN PLATES
 |  |  |  |  |  |  | 66 | ORANGE PLATES
 |  |  |  |  |  |  | 293 | YELLOW PLATES
 |  |  |  |  |  |  | 129 | RED PLATES
 |  |  |  |  |  |  | 1061 | PURPLE PLATES
 |  |  |  |  |  |  | 131 | SILICON PLATES
 |  |  |  |  |  |  | 731 | INDIGO
 |  |  |  |  |  |  |  | Object func
 |  |  |  |  |  | ENTER CODE |  | 1255
 |  |  |  |  |  | ALL PRODUCT MATCHED |  | GREEN PLATES, ORANGE PLATES,RED PLATES
 |  |  |  |  |  |  |  | ANSWER SHOULD BE IN I13 AS SHOWN
 |  |  |  |  |  |  |  | because aggregation 1060+66+129 equal to 1255
 |  |  |  |  |  |  | Enter code in I13 and run Solver
Spreadsheet: 05fe99ce-2e3e-4653-8480-92c54b45c2f3
Sheet: 11. State SF

 | FY 2012 Federal Real Property Charts
 | US Total Square Footage†
 | State | Owned GSF** | Leased GSF | Total GSF
 | Alabama | 50773337.24 | 4805771 | 55579108.24
 | Alaska | 42185412.8 | 2895877 | 45081289.8
 | Arizona | 49934933.565 | 4252121.9 | 54187055.465
 | Arkansas | 21839403.79 | 1552200 | 23391603.79
 | California | 274160093.675 | 20249499.25 | 294409592.925
 | Colorado | 50669382.38 | 7448369.88 | 58117752.26000001
 | Connecticut | 12845122.88 | 956405 | 13801527.88
 | Delaware | 5915893.185 | 419524 | 6335417.185
 | District of Columbia | 68759063.43 | 26765124.6 | 95524188.03
 | Florida | 99609817.27000001 | 12126713.15 | 111736530.42
 | Georgia | 111772110.595 | 10516519.67 | 122288630.265
 | Hawaii | 48754045.555 | 835821 | 49589866.555
 | Idaho | 18135769.445 | 1757891.35 | 19893660.795
 | Illinois | 64087613.48999999 | 6063681 | 70151294.49
 | Indiana | 26845988.346 | 2855908.76 | 29701897.106
 | Iowa | 14692684.12 | 2091193.13 | 16783877.25
 | Kansas | 34262468.20999999 | 2956984 | 37219452.20999999
 | Kentucky | 43588729.575 | 5671798.67 | 49260528.245
 | Louisiana | 38985866.155 | 4052045 | 43037911.155
 | Maine | 10656112.665 | 895360 | 11551472.665
 | Maryland | 107589818.505 | 23129392.6 | 130719211.105
 | Massachusetts | 31942649.462 | 3159934 | 35102583.462
 | Michigan | 23263166.63 | 4923174 | 28186340.63
 | Minnesota | 19352928.472 | 2414954 | 21767882.472
 | Mississippi | 43438294.895 | 2432581 | 45870875.895
 | Missouri | 45746042.01 | 9088892.75 | 54834934.76
 | Montana | 14491867.955 | 2228647.35 | 16720515.305
 | Nebraska | 13640747.7 | 1570993.16 | 15211740.86
 | Nevada | 24692577.47 | 2097073 | 26789650.47
 | New Hampshire | 4037673.060000001 | 612403 | 4650076.060000001
 | New Jersey | 40799296.725 | 4602865 | 45402161.725
 | New Mexico | 54609704.73 | 3842585.88 | 58452290.61
 | New York | 84653788.435 | 9022381 | 93676169.435
 | North Carolina | 82925564.39 | 5518280 | 88443844.39
 | North Dakota | 21865745.453 | 1090286 | 22956031.453
 | Ohio | 63414368.59 | 5661352.77 | 69075721.36
 | Oklahoma | 46626706.23 | 9224793.57 | 55851499.8
 | Oregon | 20458054.54 | 3153527 | 23611581.54
 | Pennsylvania | 71220180.77 | 9266600.02 | 80486780.78999999
 | Rhode Island | 13318604.59 | 524215 | 13842819.59
 | South Carolina | 47710320.873 | 2169705 | 49880025.873
 | South Dakota | 15819761.365 | 2130201.04 | 17949962.405
 | Tennessee | 54862587.895 | 3505822 | 58368409.895
 | Texas | 176659049.919 | 24157430.2 | 200816480.119
 | Utah | 27515494.42 | 2900149.82 | 30415644.24
 | Vermont | 3242230.07 | 1153466.78 | 4395696.850000001
 | Virginia | 152538529.305 | 28805186.54 | 181343715.845
 | Washington | 79554166.755 | 5202063.71 | 84756230.46499999
 | West Virginia | 20629416.195 | 2714421 | 23343837.195
 | Wisconsin | 20155000.455 | 2636835 | 22791835.455
 | Wyoming | 13119841.255 | 810196 | 13930037.255
 | Total | 2528368027.49 | 298919216.55 | 2827287244.039999
 | † All real property data from the CFO Act agencies required to submit data to the FRPP
 | **includes federal government owned, museum trust, state government owned
 | Total GSF
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  |  | -677 | -581
2 |  |  |  |  |  |  |  |  |  |  | -928 | -581
3 |  |  |  |  |  |  |  |  |  |  | -911 | -581
4 |  |  |  |  |  |  |  |  |  |  | -981 | -581
5 |  |  |  |  |  |  |  |  |  |  | -658 | -581
6 |  |  |  |  |  |  |  |  |  |  | -805 | -581
7 |  |  |  |  |  |  |  |  |  |  | -709 | -581
8 |  |  |  |  |  |  |  |  |  |  | -828 | -581
9 |  |  |  |  |  |  |  |  |  |  | -884 | -581
10 |  |  |  |  |  |  |  |  |  |  | -856 | -581
11 |  |  |  |  |  |  |  |  |  |  | -595 | -581
12 |  |  |  |  |  |  |  |  |  |  | -581 | -581
13 |  |  |  |  |  |  |  |  |  |  | -639 | -778
14 |  |  |  |  |  |  |  |  |  |  | -677 | -778
15 |  |  |  |  |  |  |  |  |  |  | -865 | -778
16 |  |  |  |  |  |  |  |  |  |  | -591 | -778
17 |  |  |  |  |  |  |  |  |  |  | -988 | -778
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 31688.49
2002-01-17 00:00:00
CBS Volume
 |  |  | 11681
Spreadsheet: 83c0c0a1-e416-459e-83d5-c961868324bd
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFTAP | Test | FFTAP | [NAME], [NAME] | [NAME], [NAME] | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Plastic screw-cap vial: PlScr |  |  | 10 | mL | 10 mL aliquot or random or spot urine collected without preservative in a plastic container. Send specimen refrigerated. | 3 mL Note: Submission of the min | Specimens other than	[NAME] Anticoagulants other than	N/A Hemolysis	N/A  Thawing	Cold OK; Warm OK Lipemia	N/A Icteric	N/A | Not established   Test Performed By:  Medtox Laboratories                                402 W. County Road D                                St. Paul, MN  55112 | Monday through Sunday | 5 days | 7-10 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
FFTAP | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
FFTAP | Result | [NAME] | [NAME] | [NAME] | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 760439d1640201937-i-dont-know-how-to-describe-what-i-want-to-do-sample1
Sheet: Margin Sheet1.0 DNU

Product | C Premium | C Regular | M Regular | M Premium | C Diesel | M Diesel | P Regular | PM Premium | P Diesel | PM Diesel | K Regular | K Diesel | KM Diesel | [NAME] | [NAME] | Cawston Diesel | [NAME] | O Regular | OM Premium | O Diesel | OM Diesel | WK Premium | WK Regular | WKM Premium | WK Diesel | WKM Diesel | OL Regular | OLM Regular | OL Diesel | OLM Diesel | MD Regular | MDM Regular | MD Diesel | MDM Diesel | PCDEF | PDEF | ODEF | WKDEF
2021-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.543 | 0.543 | 0.543 | 0.543
FARMER
GROUP 1
GROUP 2
GROUP 3
GROUP 4
GROUP 5
GROUP 7
GROUP 8
Group 10
Native Grp 5
[NAME]
FARMER
GROUP 1
GROUP 2
GROUP 3
GROUP 4
GROUP 5
GROUP 7
GROUP 8
Group 10
Native Grp 5
[NAME]
FARMER
GROUP 1
GROUP 2
GROUP 3
GROUP 4
GROUP 5
GROUP 7
GROUP 8
Group 10
Native Grp 5
[NAME]
FARMER
GROUP 1
GROUP 2
GROUP 3
GROUP 4
GROUP 5
GROUP 7
GROUP 8
Group 10
Native Grp 5
[NAME]
Spreadsheet: 711747d1609875296-countif-3-criteria-plus-blank-mismatch
Sheet: Sheet1

 | Schedule | timesheet
Name 1 | 8 | 8
Name 2 | 8 | 8
Name 3 | 8
Name 4 | 8 | 8
Name 1 | 8 | 6
Name 2 | 8 | 5
Name 3 | 8 | 2
Name 4 | 8 | 2
Name 1 | 8 | 8
Name 2 |  | 8
Name 3 | 8 | 8
Name 4 | 8 | 8
Name 1 | 8 | 6
Name 2 | 8 | 4
Name 3 | 8 | 8
Name 4 | 8 | 8
Result i want (how many mismatch between B & C)
Name 1 | 2
Name 2 | 3
Name 3 | 2
Name 4 | 1
Spreadsheet: 860189d1708388524-formula-to-split-up-index-result-into-several-columns-name-split-up
Sheet: Look up

Data |  |  |  |  |  |  |  |  |  | Desired Results
# | Name |  |  | Reference | Column 1 Current Formula | Column 2 Current Formula | Column 3 Current Formula | Column 4 Current Formula |  | Column 1 | Column 2 | Column 3 | Column 4
1 | 123-ACTIVE |  |  | 1 |  |  |  |  |  | 123 | Active
2 | 456-Equity-AP |  |  | 2 |  |  |  |  |  | 456 | Equity | AP
3 | 978-Fixed Assets |  |  | 3 |  |  |  |  |  | 978 | Fixed Assets
4 | 12345-Accounts Payable-GL-Mar |  |  | 4 |  |  |  |  |  | 12345 | Accounts Payable | GL | Mar