tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 268463d1380648026-sum-hours-by-date-tcs-summary
Sheet: Sheet4

Employee | Name | Production | Oper. No. | Job identification | Status | FromDateTime | ToDateTime | Column1
12269 |  | PD00054315 |  | JOB00417437 | Closed | 2013-01-24 05:03:37 | 2013-01-24 09:12:30 | 04:08:53
12269 |  | PD00053441 |  | JOB00411011 | Closed | 2013-01-24 09:13:08 | 2013-01-24 09:25:55 | 00:12:47
12269 |  | PD00053121 |  | JOB00418762 | Closed | 2013-01-24 09:26:13 | 2013-01-24 11:17:52 | 01:51:39
12269 |  | PD00053121 |  | [NAME] | Closed | 2013-01-24 11:18:06 | 2013-01-24 12:04:52 | 00:46:46
12269 |  | PD00047459 |  | JOB00384889 | Closed | 2013-01-24 12:05:14 | 2013-01-24 12:57:15 | 00:52:01
12269 |  | PD00047459 |  | JOB00384890 | Closed | 2013-01-24 12:57:30 | 2013-01-24 15:27:02 | 02:29:32
 |  |  |  |  |  |  |  | 10:21:38
15848 |  | PD00053109 |  | JOB00409857 | Closed | 2013-01-24 05:05:01 | 2013-01-24 06:36:05 | 01:31:04
15848 |  | PD00053810 |  | JOB00413247 | Closed | 2013-01-24 06:36:35 | 2013-01-24 10:37:30 | 04:00:55
15848 |  | PD00054812 |  | [NAME] | Closed | 2013-01-24 10:37:49 | 2013-01-24 15:36:26 | 04:58:37
 |  |  |  |  |  |  |  | 10:30:36
79279 |  | PD00052035 |  | JOB00399945 | Closed | 2013-01-24 05:02:53 | 2013-01-24 11:18:33 | 06:15:40
79279 |  | PD00052982 |  | JOB00407414 | Closed | 2013-01-24 11:20:23 | 2013-01-24 15:34:01 | 04:13:38
 |  |  |  |  |  |  |  | 10:29:18
89439 |  | PD00052201 |  | JOB00401229 | Closed | 2013-01-24 05:05:21 | 2013-01-24 15:22:20 | 10:16:59
 |  |  |  |  |  |  |  | 10:16:59
89798 |  | PD00045873 |  | [NAME] | Closed | 2013-01-24 05:07:28 | 2013-01-24 15:29:18 | 10:21:50
 |  |  |  |  |  |  |  | 10:21:50
98064 |  | PD00051595 |  | JOB00396363 | Closed | 2013-01-24 05:15:46 | 2013-01-24 06:54:41 | 01:38:55
 |  |  |  |  |  |  |  | 01:38:55
9839 |  | PD00047459 |  | [NAME] | Closed | 2013-01-24 05:04:45 | 2013-01-24 07:10:48 | 02:06:03
9839 |  | PD00047459 |  | [NAME] | Closed | 2013-01-24 07:11:57 | 2013-01-24 08:21:00 | 01:09:03
9839 |  | PD00047459 |  | JOB00384892 | Closed | 2013-01-24 08:21:42 | 2013-01-24 15:37:58 | 07:16:16
 |  |  |  |  |  |  |  | 10:31:22
Spreadsheet: 842115d1694178110-dynamic-array-formula-needed-for-irregular-data-book1
Sheet: Sheet1

 | Source: | Dynamic Array formula needed for irregular data
 |  |  |  |  | Non-dyn.Arr. | Dyn.Arr. | Expected values
 | [NAME] | Dataset | Product | Channel | Division | Division | Type | A-Code | X-Code |  |  |  |  |  |  | Dataset | unique id | Division | Type | A-Code | Colour | X-Code
 | 1 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | [NAME] | North | A | A01 | Grey | X01
 |  |  | Product X | EU |  | North | A | A01 | X01 | North | A | A01 | X01 |  |  | 2 | XEFGH | South | B | A02 | Black | X02
 |  |  | Product X | UK |  | North | A | A01 | X01 | North | A | A01 | X01 |  |  | 3 | XIJKL | West | C | A03 | White | X03
 |  |  | Product X | AU |  | North | A | A01 | X01 | North | A | A01 | X01 |  |  | 4 | XMNOP | North | D | A04 | Green | [NAME]
 |  |  | Product X | US |  | North | A | A01 | X01 | North | A | A01 | X01 |  |  | 5 | XQRST | East | E | A05 | Blue | X05
 | 2 | XEFGH |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | XUVWX | West | F | A06 | Red | X06
 |  |  | Product Y | EU |  | South | B | A02 | X02 | South | B | A02 | X02
 |  |  | Product Y | UK |  | South | B | A02 | X02 | South | B | A02 | X02
 |  |  | Product Y | AU |  | South | B | A02 | X02 | South | B | A02 | X02
 |  |  | Product Y | US |  | South | B | A02 | X02 | South | B | A02 | X02
 | 3 | XIJKL
 |  |  | Product Z | EU |  | West | C | A03 | X03 | West | C | A03 | X03
 |  |  | Product Z | UK |  | West | C | A03 | X03 | West | C | A03 | X03
 |  |  | Product Z | AU |  | West | C | A03 | X03 | West | C | A03 | X03
 |  |  | Product Z | US |  | West | C | A03 | X03 | West | C | A03 | X03
Spreadsheet: 774928d1648729098-find-and-sort-totals-excel-sample
Sheet: Mar 2022

ID # | Team A Maintenance Hours | Team B Maintenance Hours | Total [NAME]
GG984 | 23.2 | 45
GG447 | 45.5 | 77
OP456 | 78.8 | 105.2
HT444 | 4.4 | 78.4
[NAME] | 3 | 14
WE123 | 0 | 12
WR144 | 0 | 54
Spreadsheet: mike_swerzbin__27986__Schedule C Form-west1
Sheet: Schedule C

SCHEDULE C
DOCUMENTATION FORM |  | As of:
 |  | 2001-09-28 00:00:00
ITEM |  | DATA
Transaction or Book Name |  | EPMI Long Term Northwest
Amount |  | 11400000
Entry Date |  | 2001-09-30 00:00:00
Reason for Using Schedule C (e.g., income adjustment) |  | Northwest Refund Risk
Removal Date |  | Reserve will be removed when we receive guidance on refunds from FERC
(If amortization is required, attach the appropriate
amortization schedule)
Methodology for Removal (e.g., amortization or one time removal) |  | We will update the probability of refund risk periodically and adjust reserves
 |  | accordingly
Individual Using Schedule |  | Risk Management / Mike Swerzbin / T. Belden
[NAME] [NAME] |  | Business Analysis & Reporting
Energy Operations |  | [NAME]
Spreadsheet: 718576d1613212689-compare-all-coordinate-values-across-two-arrays-gps-coorindate-compare-example
Sheet: Data

Set 1 Lat | Set 1 Lon | Set 1 Name |  | Set 2 Lat | Set 2 Lon | Set 2 Name |  |  | Set 1 |  | Set 2
47.53670649 | -122.356154283 | AA |  | 47.52141816 | -122.35915813 | Q |  |  |  | is within 200 ft of..
47.53696794 | -122.265114173 | SS |  | 47.60922904 | -122.32933171 | W
47.53704403 | -122.28234489 | DD |  | 47.60565328 | -122.33777166 | E
47.53855079 | -122.36101491 | FF |  | 47.61683018 | -122.33192614 | R
47.53978646 | -122.28260252 | GG |  | 47.53670679 | -122.356154683 | T
47.54024971 | -122.271247038 | HH |  | 47.61247637 | -122.33521814 | Y
47.54032648 | -122.387264665 | JJ |  | 47.51828947 | -122.367275962 | U
47.54053232 | -122.322353127 | KK
47.5409636 | -122.35149856 | LL
47.54198651 | -122.295824181 | ZZ
47.60922801 | -122.32933141 | XX
47.54483359 | -122.280828424 | CC
Spreadsheet: 35081d1232584916-changing-sheet-name-reference-automatically-purchases-compilation-autosaved-
Sheet: NAGS

 |  | PUB NAME |  |  |  |  | PERIOD
 | PERIOD CASH SALES TARGET | 433
 | TARGET GP% TO ACHIEVE | 0.87
 | WET/DRY SPLIT | WET | DRY
 |  | 0.23 | 0.77
 | PERIOD DRY SALES TARGET | 333.41
 | WEEK | 1 | 2 | 3 | 4 | PERIOD TOTAL
 | SALES TARGET | 83.3525 | 83.3525 | 83.3525 | 83.3525 | 333.41
 | ACTUAL SALES | 333 | 334 | 332 | 5433 | 6432
 | SALES VARIANCE | 249.6475 | 250.6475 | 248.6475 | 5349.6475 | 6098.59
 | ALLOWABLE PURCHASES | 10.835825 | 10.835825 | 10.835825 | 10.835825 | 43.34330000000001
 | ACTUAL PURCHASES | 132 | 0 | 0 | 0 | 132
 | REMAINING TO SPEND | -121.164175 | 10.835825 | 10.835825 | 10.835825 | -88.6567
 | CURRENT GP% ACHIEVED | 60.36036036036036 | 100 | 100 | 100 | 90.09009009009009
 | PURCHASE BREAKDOWN | WEEK 1 |  | WEEK 2 |  | WEEK 3 |  | WEEK 4
 |  | SPEND | % OF SPEND | SPEND | % OF SPEND | SPEND | % OF SPEND | SPEND | % OF SPEND
 | FAIRFAX | 44 | 0.3333333333333333 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | M+J SEAFOODS | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | FRESH DIRECT | 22 | 0.1666666666666667 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | WEST COUNTRY | 22 | 0.1666666666666667 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | HOPWELLS | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | 3663 | 44 | 0.3333333333333333 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | OTHER SUPPLIERS | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | #N/A
Spreadsheet: 800878d1665965291-how-to-put-interval-involving-date-and-values-budget-template-hd
Sheet: FS_IS

IS Account | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00 | 2025-10-31 00:00:00 | 2025-11-30 00:00:00 | 2025-12-31 00:00:00 | 2026-01-31 00:00:00 | 2026-02-28 00:00:00 | 2026-03-31 00:00:00 | 2026-04-30 00:00:00 | 2026-05-31 00:00:00 | 2026-06-30 00:00:00 | 2026-07-31 00:00:00 | 2026-08-31 00:00:00 | 2026-09-30 00:00:00 | 2026-10-31 00:00:00 | 2026-11-30 00:00:00 | 2026-12-31 00:00:00 | 2027-01-31 00:00:00 | 2027-02-28 00:00:00 | 2027-03-31 00:00:00 | 2027-04-30 00:00:00 | 2027-05-31 00:00:00 | 2027-06-30 00:00:00 | 2027-07-31 00:00:00 | 2027-08-31 00:00:00 | 2027-09-30 00:00:00 | 2027-10-31 00:00:00 | 2027-11-30 00:00:00 | 2027-12-31 00:00:00
Revenue
IPD
MPD
T1
[NAME]
TV
RMC
Cost of Services
IPD
MPD
T1
[NAME]
TV
RMC
Gross Margin
IPD
MPD
T1
[NAME]
TV
RMC
[NAME]
Division Overhead
IPD
MPD
T1
[NAME]
TV
RMC
[NAME]
Net Margin
IPD
MPD
T1
[NAME]
TV
RMC
[NAME]
G&A Expense
Depreciation and Amortization
Other Operating Expenses
Interest Expense
Working Capital
Term Loan
Income Tax
Spreadsheet: 327922d1403722600-need-formula-to-calculate-ytd-variance-of-current-and-prior-year-test
Sheet: Test

2014-05-01 00:00:00
Ledger account |  |  |  |  |  | 2014-05-01 00:00:00 | 2014-04-01 00:00:00 | 2014-03-01 00:00:00 | 2014-02-01 00:00:00 | 2014-01-01 00:00:00 | 2013-12-01 00:00:00 | 2013-11-01 00:00:00 | 2013-10-01 00:00:00 | 2013-09-01 00:00:00 | 2013-08-01 00:00:00 | 2013-07-01 00:00:00 | 2013-06-01 00:00:00 | 2013-05-01 00:00:00 | 2013-04-01 00:00:00 | 2013-03-01 00:00:00 | 2013-02-01 00:00:00 | 2013-01-01 00:00:00
4001 |  |  |  |  |  | 9562 | 2223 | 6712 | 8373 | 4191 | 1146 | 5614 | 8500 | 6869 | 6822 | 7256 | 7668 | 2504 | 2861 | 9742 | 5479 | 6739
4002 |  |  |  |  |  | 2259 | 8758 | 1977 | 2456 | 8708 | 5257 | 1533 | 5267 | 9425 | 4270 | 4741 | 8598 | 2542 | 4699 | 8609 | 3803 | 4270
4003 |  |  |  |  |  | 7882 | 4684 | 3002 | 3525 | 6744 | 6881 | 7085 | 8385 | 4376 | 3060 | 9598 | 7528 | 6015 | 5161 | 9681 | 5447 | 2547
4004 |  |  |  |  |  | 6630 | 8882 | 6303 | 1807 | 4737 | 6719 | 2219 | 2558 | 5519 | 6078 | 1882 | 7456 | 6889 | 3699 | 8748 | 9361 | 5904
4005 |  |  |  |  |  | 5939 | 9456 | 5502 | 1148 | 7625 | 4697 | 1396 | 2819 | 8847 | 2824 | 6101 | 7557 | 7788 | 9214 | 6358 | 4311 | 3934
Spreadsheet: 112044d1308230436-complete-columns-in-quarter-with-columns-in-years-forum-16-de-junio
Sheet: Hoja2

COUNTRY | YEAR | QUARTER | 1 | 2 | 3
Albania | 1991 | 1
Albania | 1991 | 2
Albania | 1991 | 3
Albania | 1991 | 4
Albania | 1992 | 1
Albania | 1992 | 2
Albania | 1992 | 3
Albania | 1992 | 4
Spreadsheet: 798329d1664428062-highlight-if-there-is-more-than-6-consecutive-cells-containing-the-text-regulated-work-driver-roster-example
Sheet: Sheet1

INFO | 2022-09-21 00:00:00 | 2022-09-22 00:00:00 | 2022-09-23 00:00:00 | 2022-09-24 00:00:00 | 2022-09-25 00:00:00 | 2022-09-26 00:00:00 | 2022-09-27 00:00:00 | 2022-09-28 00:00:00 | 2022-09-29 00:00:00 | 2022-09-30 00:00:00 | 2022-10-01 00:00:00 | 2022-10-02 00:00:00 | 2022-10-03 00:00:00 | 2022-10-04 00:00:00 | 2022-10-05 00:00:00 | 2022-10-06 00:00:00 | 2022-10-07 00:00:00 | 2022-10-08 00:00:00
Name | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Driver 1 | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Day Off | Non-Reg Work | Non-Reg Work | Non-Reg Work | Non-Reg Work | Day Off | Day Off | Day Off | Day Off | Day Off | Day Off | Day Off
Driver 2 | Non-Reg Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work | Regulated Work
Driver 3 | Regulated Work | Regulated Work | Regulated Work | Rest | Sick | Regulated Work | Regulated Work | Left Business | Left Business | Left Business | Left Business | Left Business | Left Business | Left Business | Left Business | Left Business | Left Business | Left Business
Driver 4 | Non-Reg Work | Regulated Work | Non-Reg Work | Non-Reg Work | Non-Reg Work | Non-Reg Work | Non-Reg Work | Rest | Rest | Rest | Rest | Rest | Rest | Rest | Rest | Rest | Rest | Rest
Driver 5 | Non-Reg Work | Non-Reg Work | Non-Reg Work | Non-Reg Work | Non-Reg Work | Regulated Work | Non-Reg Work | Rest | Rest | Rest | Rest | Rest | Rest | Rest | Rest | Rest | Rest | Rest
Spreadsheet: 681310d1591461592-determine-zeroes-of-polynominal-functions-zeroes
Sheet: Sheet1

const. | ax | bx^2 | cx^3 | dx^4 | ex^5 |  | one possible solution for zero
-1000 | 472 | 534 | 654 | 342 | -491
-1000 | 70 | 540 | 1052 | -292 | -73
-1000 | 596 | -401 | 684 | 1150 | 698
-1000 | -159 | 825 | 113 | 237 | 1075
-1000 | -23 | 228 | -143 | 786 | -284
-1000 | 986 | -371 | -164 | 1038 | 70
-1000 | 665 | -181 | 838 | 1167 | 18
-1000 | -147 | 780 | -354 | 600 | 1071
-1000 | -496 | -141 | 64 | -459 | 523
-1000 | 893 | 1166 | -339 | 137 | -361
-1000 | 278 | -157 | -27 | 1079 | 1139
-1000 | 660 | -360 | 220 | 518 | 1048
-1000 | 1085 | 696 | 516 | -450 | -137
-1000 | 969 | -259 | 1041 | 868 | 791
-1000 | 92 | -297 | 277 | 617 | 762
-1000 | 877 | -270 | -81 | 525 | 1078
-1000 | -368 | -209 | -52 | 562 | 768
-1000 | 363 | 521 | 777 | -206 | 699
-1000 | 535 | 1147 | 12 | 530 | 364
-1000 | -100 | -217 | -150 | 549 | -325
-1000 | 86 | 869 | 78 | -21 | 904
-1000 | 893 | -403 | 312 | 1107 | -24
-1000 | -305 | 893 | 168 | 1049 | 831
-1000 | -180 | 802 | -314 | 464 | 503
-1000 | 711 | 575 | 518 | 877 | 976
Spreadsheet: 788631d1658592137-highlight-data-with-vlookup-samplequestionforum
Sheet: TOP-75

107057
107084
798354
107517
107046
780863
107085
101152
107077
780860
780744
798357
107083
780850
798350
107545
820060
798358
780878
780749
798349
798353
107073
820080
107064
107047
798376
751056
798383
780762
798379
770010
820040
770167
798381
107041
770165
107076
770115
798320
780853
107067
107034
798394
820015
770166
798368
101360
798377
100994
101306
780882
820031
798390
780881
751075
820030
780867
751054
107043
107031
798359
101132
780764
107089
751090
751076
798363
751092
751050
101180
100972
100959
780746
Spreadsheet: 777770d1650609983-need-help-to-correct-if-formula-sample
Sheet: Sheet1

 | Date |  | Shift | In Time |  | Out Time | Total Duty |  |  |  | O.T | Remarks | 08:00:00 | 14:15:00 | 16:00:00 | 22:00:00 | 09:00:00 | 16:00:00
SP01 | 2021-12-24 00:00:00 |  | S1 | 09:00:00 | 07:00:00 | 13:00:00 |  | 8
SP02 | 2021-12-26 00:00:00 |  | S2 |  | 09:00:00 | 17:00:00 |  | 8
SP03 | 2021-12-24 00:00:00 |  | G | 10:00:00 |  | 17:00:00 |  | 8
 |  |  |  | This timing are vlookup in actual sheet from other sheet. I manualy add these
Spreadsheet: 213271d1360417879-i-would-like-to-click-once-on-a-cell-shopping-list-help
Sheet: DV Lists

Produce | Pasta | Bread | Dairy | Fruit
Potatoes | Spaghetti | English Muffins | Milk | Apples
Onions | Linguini | Hamburger Buns | Cheese | Oranges
Carrots | Macaroni |  | Yogurt | Bananas
Tomatoes |  |  | Ice Cream
Spreadsheet: 762583d1641648270-consecutive-dates-to-from-and-to-sickness-report
Sheet: Sheet1

RAW DATA |  |  |  |  | Expected Data
Name | Date |  |  |  | Name | From | To
AAB | 2021-12-09 00:00:00 | 1 |  |  | AAB | 2021-12-09 00:00:00 | 2021-12-09 00:00:00
AAB | 2021-12-16 00:00:00 |  |  |  | AAB | 2021-12-16 00:00:00 | 2021-12-21 00:00:00
AAB | 2021-12-17 00:00:00 |  |  |  | AP | 2021-12-29 00:00:00 | 2021-12-29 00:00:00
AAB | 2021-12-18 00:00:00 |  |  |  | AP | 2021-12-15 00:00:00 | 2021-12-15 00:00:00
AAB | 2021-12-19 00:00:00 |  |  |  | AR | 2021-12-16 00:00:00 | 2021-12-16 00:00:00
AAB | 2021-12-20 00:00:00 |  |  |  | AR | 2021-12-20 00:00:00 | 2021-12-21 00:00:00
AAB | 2021-12-21 00:00:00 |  |  |  | AR | 2021-12-23 00:00:00 | 2021-12-23 00:00:00
AP | 2021-12-29 00:00:00 |  |  |  | AR | 2021-12-25 00:00:00 | 2021-12-25 00:00:00
AP | 2021-12-15 00:00:00 |  |  |  | AF | 2021-12-18 00:00:00 | 2021-12-24 00:00:00
AR | 2021-12-16 00:00:00 |  |  |  | AS | 2021-12-08 00:00:00 | 2021-12-09 00:00:00
AR | 2021-12-20 00:00:00 |  |  |  | AS | 2021-12-11 00:00:00 | 2021-12-11 00:00:00
AR | 2021-12-21 00:00:00 |  |  |  | AS | 2021-12-26 00:00:00 | 2021-12-26 00:00:00
AR | 2021-12-23 00:00:00 |  |  |  | AS | 2021-12-28 00:00:00 | 2021-12-28 00:00:00
AR | 2021-12-25 00:00:00 |  |  |  | AS | 2021-12-12 00:00:00 | 2021-12-12 00:00:00
AF | 2021-12-18 00:00:00
AF | 2021-12-19 00:00:00
AF | 2021-12-20 00:00:00
AF | 2021-12-21 00:00:00
AF | 2021-12-22 00:00:00
AF | 2021-12-23 00:00:00
AF | 2021-12-24 00:00:00
AS | 2021-12-08 00:00:00
AS | 2021-12-09 00:00:00
AS | 2021-12-11 00:00:00
AS | 2021-12-26 00:00:00
AS | 2021-12-28 00:00:00
AS | 2021-12-12 00:00:00
Spreadsheet: 681126d1591364400-formula-assigning-date-range-to-each-gl-code-sample-gl-code
Sheet: Sheet1

GL Codes | Month No | Date Ref
1001/BUL/CAST/REV | 1 | 2020-03-31 00:00:00
1002/BUL/METO/REV | 2 | 2020-04-30 00:00:00
1003/BUL/CPT/REV | 3 | 2020-05-31 00:00:00
1004/BUL/CPT/REV | 4 | 2020-06-30 00:00:00
 | 5 | 2020-07-31 00:00:00
 | 6 | 2020-08-31 00:00:00
 | 7 | 2020-09-30 00:00:00
 | 8 | 2020-10-31 00:00:00
 | 9 | 2020-11-30 00:00:00
 | 10 | 2020-12-31 00:00:00
 | 11 | 2021-01-31 00:00:00
 | 12 | 2021-02-28 00:00:00
Spreadsheet: 707579d1607352881-taking-correspondence-between-2-columns-to-specify-another-excel-sheet-excelforum1334713excel_sample2
Sheet: Sheet1

HOMEINSTITUTION | REGION CODE | COUNTRYCODEOFHOMEINSTITUTION | AGE | GENDER | NATIONALITY | SUBJECTAREA | LEVELSTUDY | YEARSPRIOR | MOBILITYTYPE | HOSTINSTITUTION | REGION CODE | COUNTRYCODEOFHOSTINSTITUTION
D  BERLIN14 |  | DE | 27 | F | DE | 461 | 1 | 4 | S | S  JONKOPI01 |  | SE
D  BERLIN14 |  | DE | 27 | F | XX | 582 | 2 | 4 | S | SF HELSINK41 |  | FI
D  BERLIN14 |  | DE | 24 | F | DE | 342 | 2 | 4 | S | S  JONKOPI01 |  | SE
D  BERLIN14 |  | DE | 28 | M | DE | 314 | 1 | 3 | S | UK LONDON062 |  | UK
D  BERLIN14 |  | DE | 22 | F | DE | 314 | 1 | 2 | S | E  TENERIF01 |  | ES
D  BERLIN14 |  | DE | 24 | M | DE | 314 | 2 | 4 | S | IRLDUBLIN27 |  | IE
D  BERLIN14 |  | DE | 28 | F | DE | 314 | 2 | 5 | S | S  GOTEBOR01 |  | SE
D  BERLIN14 |  | DE | 23 | M | DE | 422 | 1 | 2 | S | IRLDUNDALK01 |  | IE
D  BERLIN14 |  | DE | 28 | M | DE | 481 | 2 | 5 | S | TR ISTANBU16 |  | TR
D  BERLIN18 |  | DE | 26 | F | DE | 214 | 1 | 4 | S | TR ISTANBU05 |  | TR
D  BERLIN18 |  | DE | 29 | M | DE | 211 | 1 | 2 | S | A  WIEN06 |  | AT
D  BERLIN18 |  | DE | 26 | F | XX | 214 | 1 | 1 | S | UK LONDON128 |  | UK
D  BERLIN18 |  | DE | 25 | M | DE | 214 | 1 | 2 | S | UK BRISTOL02 |  | UK
D  BERLIN18 |  | DE | 27 | M | DE | 214 | 1 | 4 | S | TR ISTANBU05 |  | TR
D  BERLIN18 |  | DE | 26 | F | DE | 214 | 2 | 4 | S | UK BRISTOL02 |  | UK
D  BERLIN18 |  | DE | 22 | F | DE | 214 | 1 | 2 | S | UK LONDON128 |  | UK
D  BERLIN18 |  | DE | 24 | F | DE | 210 | 1 | 3 | S | I  BOLOGNA03 |  | IT
D  BERLIN18 |  | DE | 23 | F | LT | 214 | 1 | 3 | S | N  BERGEN04 |  | NO
D  BERLIN18 |  | DE | 23 | F | DE | 210 | 1 | 3 | S | NL HEERLEN14 |  | NL
D  BERLIN20 |  | DE | 26 | F | DE | 31 | 1 | 2 | S | [NAME] KOBENHA55 |  | DK
D  BERLIN20 |  | DE | 24 | F | DE | 31 | 1 | 1 | S | IRLTRALEE01 |  | IE
D  BERLIN20 |  | DE | 26 | F | DE | 31 | 1 | 3 | S | [NAME] KOBENHA55 |  | DK
D  BERLIN20 |  | DE | 23 | F | DE | 31 | 1 | 3 | S | A  WIEN63 |  | AT
D  BERLIN20 |  | DE | 21 | F | DE | 31 | 1 | 1 | S | S  MALMO01 |  | SE
D  BERLIN20 |  | DE | 23 | F | DE | 31 | 1 | 1 | S | S  MALMO01 |  | SE
Spreadsheet: 25061d1216149568-validation-pick-lists-picks-containing-spaces-validation-example
Sheet: Sheet1

AREA | CATEGORY |  | Pick List Column | SubPicklistColumn
Accessories | Blast Timer |  | Accessories | Leveler
 | Caster |  | Air Dryers | MB510 Air Dryer
 | Leveler |  | Automations | Modifications
 | Magnifier
 | [NAME]
 | Riser
 | Shelve
 | [NAME]
 | Stand
 | [NAME]
 | Transducer
 | VisionPlus Window Shield
Air Dryers | AD5100 Air Dryer
 | AD5300 Air Dryer
 | MB510 Air Dryer
 | Air Dryer Parts
Automations | Advanced Lathe
 | Standard Lathe
 | Modifications
 | Part Tooling
 | Lathe Parts
 | Profiler
 | Surface Abrader
Spreadsheet: 727608d1617980001-need-help-counting-sizes-per-shirt-color-book4-count-sizes-per-color-ans
Sheet: Sheet1

YS | black |  | sizes | color
YL | black
YL | black
YL | black
AXL | black
YL | black
YXL | black
YXL | black
YM | black
YM | black
YM | [NAME]
YM | [NAME]
YM | [NAME]
YS | [NAME]
YXL | [NAME]
YXL | [NAME]
YL | [NAME]
YM | [NAME]
YL | [NAME]
Ym | [NAME]
YS | gold
YM | gold
YM | gold
YM | gold
AS | gold
YM | gold
YXL | gold
YM | gold
YL | gold
YL | gold
AS | gold
YS | gold
YL | gray
YL | gray
YM | gray
YM | gray
YM | gray
YL | gray
YXL | gray
YL | gray
YM | gray
YM | gray
YM | gray
YXL | gray
YM | gray
YL | gray
YL | gray
YXL | gray
YS | white
YL | white
YM | white
YM | white
YM | white
YL | white
AS | white
YM | white
YL | white
YM | white
Spreadsheet: jane_tholt__13103__phys-transport
Sheet: Sheet1

Physical Index Deals | Excluding | Transport
2002-07-01 00:00:00
Pub Code | PV | Cntr. Eqv.
DJ/BASIN/CIG | 0
IF-CIG/RKYMTN | 0.0001000000047497451 | 0
IF-CIG/WIC | 0
IF-CIG/WINDRVR | 0
IF-ELPO/PERMIAN | -4796282.9273
IF-ELPO/SJ | 8012061.552599995
IF-KERN/RIVER | 154794.2198
IF-NTHWST/CANBR | 154979.9729
IF-NWPL_ROCKY_M | 25439346.4724
IF-QUESTAR | 118417.5782
IF-TW/PERMIAN | 309588.4397
IF-WAHA-TX | 1238353.7588
NGI-MALIN | -1384993.8212
NGI-PGE/CG | -2394166.224099999
NGI-SOBDR-PG&E | -310436.5824999996
NGI-SOBDR-SOCAL | -2483594.3742
NGI-SOCAL | -2322482.7308
NGI-SOCAL(KRS) | -30958.844
NW STANF/1ST-GD | 154794.2198
Grand Total | 21859420.71019999
Spreadsheet: 161033d1339376733-name-lookup-namelookup
Sheet: TableB

Name | Widgets | [NAME]
Anon Muppet | 4 | 18
[NAME] | 14 | 23
[NAME] | 8 | 5
[NAME] | 4 | 33
[NAME] | 44 | 16
[NAME] | 11 | 13
[NAME] | 5 | 6
[NAME] | 17 | 12
[NAME] | 82 | 7
Spreadsheet: 68007d1268535047-excel-if-then-command-sample-book
Sheet: Sheet1

9 | 7 | 4 | 5 | Hey Teylyn. Thank you very much for the help. Ok so basically I want anything 10,11,12 to be 0,1,2 so that the number in the purple do not conatin the 10,11,12.
9 | 7 | 4 | 974
10 | 8 | 5 | 1085
11 | 9 | 6 | 1196
7 | 10 | 7 | 7107
11 | 5 | 6 | 1156
12 | 4 | 8 | 1248
11 | 6 | 4 | 1164
5 | 7 | 5 | 575
4 | 8 | 7 | 487
4 | 9 | 8 | 498
4 | 10 | 9 | 4109
5 | 7 | 8 | 578
7 | 8 | 10 | 7810
9 | 9 | 11 | 9911
9 | 10 | 12 | 91012
5 | 9 | 11 | 5911
6 | 8 | 12 | 6812
7 | 4 | 11 | 7411
4 | 5 | 5 | 455
3 | 8 | 4 | 384
4 | 7 | 3 | 473
Spreadsheet: 157299d1337694993-determining-this-formula-for-validation-sample-text
Sheet: Sheet1

In Service | Validation | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00
2012-05-07 00:00:00 |  | 0 | 0 | 10 | 20 | 30
2012-06-09 00:00:00 |  | 10 | 20 | 30 | 40 | 50
Spreadsheet: 07e8ab7d-c398-4d62-91b2-a154190d042f
Sheet: AP6-Income L2 

IN | Income |  |  |  |  |  |  |  | Years |  | 60
REF | BCIS | Description | Qty | Unit | Rate | Annual Income | Life Cycle Income | (e) | Escaled Life Cycle Income | (i) | Acc. Present Value |  | f | f1 | f2 | (n) | Annual Amount
7.0 | Income
7.1 | Income from Sales
 |  | State client requirements, standards required, working restrictions and procurement context |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
7.2 | Third party income during occupation
 |  | State client requirements, standards required, working restrictions and procurement context
7.3 | Taxes on income
 |  | State client requirements, standards required, working restrictions and procurement context
7.4 | Loss of income
 |  | State client requirements, standards required, working restrictions and procurement context
7.5 | Client definable costs
 | Total Income
Spreadsheet: 455539d1460388769-follow-up-to-earlier-post-regarding-consolidation-example
Sheet: Sheet1

Here Is What The Original List Looks Like |  |  |  |  | Here is What the Consolidated Format Looks Like
1234 | Elephants | 4 |  |  | 1234 |  | 7
TEA457 | Teacups | 3 |  |  | TEA457 |  | 3
1234 | Elephants | 3 |  |  | GOO987 |  | 4
GOO987 | Geese | 4
 |  |  |  |  |  | I need this middle column to have the same information as whats on the far left