tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 297435d1392391287-time-series-forecast-based-on-market-share-market-penetration-time-series-forecast
Sheet: time series forecast

year | Quarter | Car | units_sold_(Sport) | units_sold_(4x4) | units_sold_(City) | sales_units ('000) | market share (Sport) | market_share_(4x4) | market_share_(City)
2010 | Q1 | car1 | 651.33 | 130.59 | 118.31 | 1324
2010 | Q1 | car2 | 559.12 | 114.66 | 148.44 | 765
2010 | Q1 | car3 | 246.23 | 137.4 | 49.86 | 530
2010 | Q2 | car1 | 559.42 | 114.56 | 107.61 | 1435
2010 | Q2 | car2 | 475.21 | 129.67 | 130.6 | 847
2010 | Q2 | car3 | 212.96 | 103.74 | 45.45 | 520
2010 | Q3 | car1 | 654 | 110.03 | 108.26 | 1449
2010 | Q3 | car2 | 538.89 | 154.78 | 157.09 | 835
2010 | Q3 | car3 | 223.29 | 124.64 | 40.28 | 513
2010 | Q4 | car1 | 629.68 | 115.29 | 115.43 | 1432
2010 | Q4 | car2 | 548.76 | 155.17 | 130.25 | 848
2010 | Q4 | car3 | 196.35 | 95.1 | 48.17 | 548
2011 | Q1 | car1 | 666.25 | 135.74 | 108.81 | 1568
2011 | Q1 | car2 | 573.31 | 152.7 | 165 | 874
2011 | Q1 | car3 | 213.34 | 107.8 | 45.73 | 532
2011 | Q2 | car1 | 667.1 | 208.16 | 196.08 | 1552
2011 | Q2 | car2 | 528.71 | 263.09 | 214.56 | 823
2011 | Q2 | car3 | 194.03 | 131.32 | 69.95 | 546
2011 | Q3 | car1 | 666.9 | 212.36 | 193.93 | 1556
2011 | Q3 | car2 | 546.04 | 260.91 | 217.88 | 360
2011 | Q3 | car3 | 183.39 | 142.11 | 78.18 | 863
2011 | Q4 | car1 | 692.17 | 204.06 | 190.25 | 562
2011 | Q4 | car2 | 558.76 | 268.07 | 234.72 | 1414
2011 | Q4 | car3 | 202.07 | 136.87 | 64.34 | 350
2012 | Q1 | car1 | 681.79 | 214.05 | 198.98 | 995
2012 | Q1 | car2 | 570.34 | 254.3 | 229.44 | 640
2012 | Q1 | car3 | 177.45 | 142.98 | 71.42 | 1621
2012 | Q2 | car1 | 683.54 | 231.16 | 194.83 | 362
2012 | Q2 | car2 | 549.89 | 276.23 | 220.26 | 878
2012 | Q2 | car3 | 182.91 | 136.58 | 77.02 | 595
2012 | Q3 | car1 | 666.03 | 228.41 | 192.7 | 1593
2012 | Q3 | car2 | 561.84 | 273.19 | 248.78 | 376
2012 | Q3 | car3 | 180.49 | 139.53 | 86.9 | 969
2012 | Q4 | car1 | 677.26 | 218.97 | 203.52 | 631
2012 | Q4 | car2 | 595.91 | 310.21 | 242.51 | 1590
2012 | Q4 | car3 | 180.81 | 121.72 | 90.44 | 352
2013 | Q1 | car1 | 721.65 | 222.68 | 190.07 | 1040
2013 | Q1 | car2 | 593.3 | 298.54 | 252.13 | 669
2013 | Q1 | car3 | 200.34 | 122.66 | 71.56 | 1551
2013 | Q2 | car1 | 680.2 | 202.57 | 192.55 | 372
2013 | Q2 | car2 | 596.4 | 313.35 | 250.08 | 965
2013 | Q2 | car3 | 175.96 | 140.88 | 72.48 | 659
2013 | Q3 | car1 | 668.28 | 207.76 | 191.62 | 1648
2013 | Q3 | car2 | 606.69 | 293 | 255.29 | 374
2013 | Q3 | car3 | 189.76 | 138.85 | 71.32 | 1011
2013 | Q4 | car1 | 705.61 | 216.8 | 203.53 | 693
2013 | Q4 | car2 | 573.24 | 293.74 | 240.3 | 1609
2013 | Q4 | car3 | 171.23 | 136.36 | 64.42 | 364
Spreadsheet: 674792d1588015603-comparing-two-sheets-and-displaying-differences-example2
Sheet: New Database

Entry | Name | Fruit | Cost
1 | [NAME] | Lemon | 4.99
2 | [NAME] | Apple | 1.2
3 | [NAME] | Orange | 4.3
4 | [NAME] | Kiwi | 1.99
5 | [NAME] | Apple | 3
7 | [NAME] | Peach | 0.5
Spreadsheet: 173724d1344694463-conditional-format-based-on-a-defined-range-engineering-release
Sheet: Release

 |  |  | Engineering Release
 | ER Number |  |  | Project Name |  |  | Date
Cost Code | QTY | TA Part# | Detail# | Description/Material | Primary Vendor | Unit Cost | Required Date | Job # | Area | [NAME] (Formula) | Header
 |  |  |  |  |  |  |  |  |  |  |  |  | Primary Vendor
 |  |  |  |  | TAKIT |  |  |  |  |  |  |  | TACNC
 |  |  |  |  | TAHORN |  |  |  |  |  |  |  | TAFAB
 |  |  |  |  | TACNC |  |  |  |  |  |  |  | TAHORN
 |  |  |  |  | hmm |  |  |  |  |  |  |  | TAKIT
 |  |  |  |  | testing |  |  |  |  |  |  |  | TAMACH
 |  |  |  |  | see? |  |  |  |  |  |  |  | TAPRE
 |  |  |  |  | This only works sometimes.
Spreadsheet: mark_haedicke__24590__2002 Plan Budget Pack - Legal Group 021001(HCODE)
Sheet: Adaytum by CC

 | ( Refresh view for your relevant CC or Region )
 | 2002 Plan
 | Adaytum
 | Value USD | Total Cost | Total | Budget 2002
 |  | Legal
 | Total Salaries & Wages | 6797972.556706808
 | Total Travel and Entertainment | 409180
 | Total Office Costs | 76862
 | Total Consultancy Costs | 604358
 | Total Occupancy | 0
 | Total Legal & Audit | 15379045.99999999
 | Total Other GA | 329435
 | Communications Costs | 426300
 | Taxes Other Than Income | 0
 | TOTAL G&A | 24023153.5567068
 | 2001 Actual / CE2
 | Adaytum
 | Forecast | Full year | Consolidated
 |  | Legal
 | Salaries & Wages | 6425658.774625184
 | Travel & Entertainment | 465151.17
 | Office Expenses | 73975.12
 | Consultancy | 537421.3
 | Audit & Legal | 17081533.64
 | Occupancy Costs | 0
 | General & Admin | 367789.44
 | Communications | 57806.15
 | Taxes Other Than Income | 0
 | TOTAL G&A | 25009335.59462519
Spreadsheet: 215279d1361325174-return-a-year-for-all-data-over-a-threshold-in-a-row-without-macros-sample-yearresultssummary
Sheet: sample

2013
0 | 0.277 | 0.232 | 0.32 | 0.291 | 0.399 | 0.366 | 0.4 | 0.349 | 0.364 | 0.345 | 0.383 | 0.304 | 0.281 | 0.257 | 0.231
Threshold: | 0.35
=SUBSTITUTE(IF(COUNTIF(A2:P2,">="&$B$4)>1,COUNTIF(A2:P2,">="&$B$4)&" years over : ",IF(COUNTIF(A2:P2,">="&$B$4)=0,"",COUNTIF(A2:P2,">="&$B$4)&" year over : "))&IF(A2>=$B$4,A1&", ","")&IF(B2>=$B$4,B1&", ","")&IF(C2>=$B$4,C1&", ","")&IF(D2>=$B$4,D1&", ","")&IF(E2>=$B$4,E1&", ","")&IF(F2>=$B$4,F1&", ","")&IF(G2>=$B$4,G1&", ","")&IF(H2>=$B$4,H1&", ","")&IF(I2>=$B$4,I1&", ","")&IF(J2>=$B$4,J1&", ","")&IF(K2>=$B$4,K1&", ","")&IF(L2>=$B$4,L1&", ","")&IF(M2>=$B$4,M1&", ","")&IF(N2>=$B$4,N1&", ","")&IF(O2>=$B$4,O1&", ","")&IF(P2>=$B$4,P1&", ","")&IF(COUNTIF(A2:P2,">="&$B$4)=0,"",","),", ,","")
OR, SHORTER WITHOUT REMOVING THE FINAL ","
=IF(COUNTIF(A2:P2,">="&$B$4)>1,COUNTIF(A2:P2,">="&$B$4)&" years over : ",IF(COUNTIF(A2:P2,">="&$B$4)=0,"",COUNTIF(A2:P2,">="&$B$4)&" year over : "))&IF(A2>=$B$4,A1&", ","")&IF(B2>=$B$4,B1&", ","")&IF(C2>=$B$4,C1&", ","")&IF(D2>=$B$4,D1&", ","")&IF(E2>=$B$4,E1&", ","")&IF(F2>=$B$4,F1&", ","")&IF(G2>=$B$4,G1&", ","")&IF(H2>=$B$4,H1&", ","")&IF(I2>=$B$4,I1&", ","")&IF(J2>=$B$4,J1&", ","")&IF(K2>=$B$4,K1&", ","")&IF(L2>=$B$4,L1&", ","")&IF(M2>=$B$4,M1&", ","")&IF(N2>=$B$4,N1&", ","")&IF(O2>=$B$4,O1&", ","")&IF(P2>=$B$4,P1&", ","")
Spreadsheet: 28f6c86f-4ce2-40a9-a3e0-623cc7a67e36
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8094 | 51780 | Anna | Jordens | ESP | 0 | 00:20:01 | 00:01:13 | 00:36:26 | 00:01:20 | 00:11:37 | 1 | 01:10:35
8094 | 57369 | [NAME] | Azirar | GBR | 0 | 00:20:01 | 00:01:22 | 00:36:57 | 00:01:22 | [NAME] | 2 | 01:11:51
8094 | 55906 | Eve | [NAME] | IRL | 0 | [NAME] | 00:01:31 | 00:40:11 | 00:01:19 | 00:11:44 | 3 | 01:15:56
Spreadsheet: 130247d1322141137-search-and-copy-function-example
Sheet: Sheet1

Item | Cat_1 | Cat_2 | Cat_3 |  |  | [NAME] | Mast_2 | Mast_3
Collect Pram | Wood | [NAME] | Bed Sidewalk |  |  | Wood | Furniture | Table Chair
use Cradle | [NAME] | [NAME] | Misc items |  |  | Wood | [NAME] | Bed Sidewalk
Dish or else | Chemicals | Soap | Soapdish, [NAME] |  |  | Vegetable | Chopped Sliced | Beans Carrots Peas
Top Gun |  |  |  |  |  | Chemicals | Soap | Soapdish, [NAME]
Carrot steam | Vegetable | Chopped Sliced | Beans Carrots Peas |  |  | [NAME] | [NAME] | Misc items
Spreadsheet: 508975d1490448947-sort-and-create-golf-scramble-teams-of-3-somes-using-equal-handicaps-handicap3somes
Sheet: Sheet1

 |  |  | TEAMS OF 3
 |  |  |  |  | player | hcp
 |  |  | 1 |  | Coop | 6
 |  |  | 2 |  | [NAME] | 9
 |  |  | 3 |  | [NAME] T | 14 |  |  | team | total hcp | average hcp
 |  |  | 4 |  | [NAME] | 17 |  |  | 1
 |  |  | 5 |  | [NAME] | 18 |  |  | 2
 |  |  | 6 |  | [NAME] | 19 |  |  | 3
 |  |  | 7 |  | [NAME] | 20
 |  |  | 8 |  | Hank | 23
 |  |  | 9 |  | Carol | 24
 |  |  |  |  |  |  |  |  | 3 | teams of 3 players
 |  |  |  |  |  |  | average handicap
 |  |  | TEAMS OF 4
 |  |  |  |  | player | hcp
 |  |  | 1 |  | Coop | 6
 |  |  | 2 |  | [NAME] | 9
 |  |  | 3 |  | [NAME] T | 14 |  |  | team | total hcp | average hcp
 |  |  | 4 |  | [NAME] | 17 |  |  | 1
 |  |  | 5 |  | [NAME] | 18 |  |  | 2
 |  |  | 6 |  | [NAME] | 19 |  |  | 3
 |  |  | 7 |  | [NAME] | 20
 |  |  | 8 |  | Hank | 23
 |  |  | 9 |  | Carol | 24
 |  |  | 10 |  | [NAME] | 10
 |  |  | 11 |  | Mark | 18
 |  |  | 12 |  | [NAME] | 23
 |  |  |  |  |  |  |  |  | 3 | teams of 4 players
 |  |  |  |  |  |  | average handicap
Spreadsheet: 168219d1342321716-add-values-in-a-column-to-a-number-and-then-start-again-running-totals-to-1000-and-back
Sheet: Sheet1

Num | [NAME] | To 1000 | To get to 1000
382
330
648
579
578
394
423
441
599
205
285
241
612
108
114
407
453
682
583
294
554
182
386
646
416
193
Spreadsheet: 793027d1661268371-help-with-comparison-needed-sample
Sheet: Sheet1

CONDITION | [NAME] | DATE & TIME
Door Forced | SE Stairs | 2021-01-01 00:00:00
Door Forced | CR NW Stairs | 2021-01-01 00:00:00
Door Forced | CR SW Stairs | 2021-01-01 00:00:00
Door Forced | CR NW Stairs | 2021-01-01 00:00:00
Door Forced | CR SE Stairs | 2021-01-01 00:00:00
Door Forced | CR SW Stairs | 2021-01-01 00:00:00
Door Forced | CR SW Stairs | 2021-01-01 00:00:00
Door Forced | CR NW Stairs | 2021-01-01 00:00:00
Door Forced | CR SE Stairs | 2021-01-01 00:00:00
Door Forced | CR E Stairs 2 Out | 2021-01-01 00:00:00
Door Forced | CR E Stairs 1 In | 2021-01-01 00:00:00
Door Forced | CR W Stairs 2 Out | 2021-01-01 00:00:00
Door Forced | CR W Stairs 1 In | 2021-01-01 00:00:00
Door Forced | CR [NAME] | 2021-01-01 00:00:00
Door Forced | CR HV Switch Rm A | 2021-01-01 00:00:00
Door Forced | [NAME] A | 2021-01-01 00:00:00
Door Forced | CR HV Switch Rm A | 2021-01-01 00:00:00
Door Held Open | [NAME] IN | 2021-01-01 00:05:00
Door Alarm Reset | BR Ext Loading Store IN | 2021-01-01 00:07:00
Door Held Open | CR Office | 2021-01-01 01:21:00
Door Alarm Reset | CR  Office | 2021-01-01 01:22:00
Door Held Open | [NAME] IN | 2021-01-01 04:28:00
Door Alarm Reset | [NAME] IN | 2021-01-01 04:29:00
Door Held Open | CR Office | 2021-01-01 04:31:00
Door Alarm Reset | CR  Office | 2021-01-01 04:34:00
Door Forced | [NAME] | 2021-01-01 07:29:00
Door Alarm Reset | [NAME] | 2021-01-01 07:29:00
Spreadsheet: 798032d1664281176-help-trying-to-add-up-values-from-multiple-lines-where-a-condition-is-met-mrose
Sheet: Sheet1

First Name | Last Name | Employee ID | Schedule | Position | Site | Regular | OT | Double OT
[NAME] | Jones | PC-720 | EARTH VILLAGE | Total
[NAME] | Jones | PC-720 | EARTH VILLAGE | [NAME] | EVOP SHOP | 35.12
[NAME] | Jones | PC-720 | EARTH VILLAGE | DREAM CLEANER | EVOP SHOP | 0.82
[NAME] | Jones | PC-720 | EARTH VILLAGE | Kitchenhand | SPECIAL EVENT | 2
[NAME] | Jones | PC-720 | EARTH VILLAGE | Service Star | EVOP SHOP | 29.35
[NAME] | Smith | PC-706 | EARTH VILLAGE | Total
[NAME] | Smith | PC-706 | EARTH VILLAGE | DREAM CLEANER | BOH | 2
[NAME] | Smith | PC-706 | EARTH VILLAGE | Kitchenhand | BOH | 42.68
[NAME] | Smith | PC-706 | EARTH VILLAGE | Kitchenhand | SPECIAL EVENT | 3
[NAME] | Smith | PC-706 | EARTH VILLAGE | No Position | BOH | 11.42
[NAME] | Jones | PC-700 | EARTH VILLAGE | Total
[NAME] | Jones | PC-700 | EARTH VILLAGE | Free Meal PREP | BREADLAND | 13
[NAME] | Jones | PC-700 | EARTH VILLAGE | Free Meal PREP | BREADLAND | 2.5
[NAME] | Jones | PC-700 | EARTH VILLAGE | Service Star | EVOP SHOP | 20.63
[NAME] | Jones | PC-700 | EVC / BL VOL TEAM | Service Star | BREADLAND | 4.9
[NAME] | Jones | PC-700 | EARTH VILLAGE | Free Meal PREP | BREADLAND | 4.73
[NAME] | Jones | PC-700 | EARTH VILLAGE | Free Meal PREP | SPECIAL EVENT | 2
EVOP SHOP
BOH
SPECIAL EVENT
BREADLAND
Spreadsheet: 1297ea0f-5e0d-47a9-a991-8599c5db47a0
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Fill in the blue boxes with the appropriate number to calculate the amount of supplementary weighting available
for your district for qualifying courses and students.  Sample calculations may be found on row 13.
According to IAC 281 - 97, supplementary weighting is available:
If a student is eligible to be counted as a resident student, and if:
 | Resident student attends class in another school district, or
 | Resident student attends class taught by a teacher employed by another school district, or
 | Resident student attends class taught by a teacher jointly employed by two or more school districts
 | A | B | C | D | E | F | G
 | Class periods in a year of this class | Total periods available in a school year | Number of resident students in the class | Weighting factor | =Supplementary weighting | District Cost Per Pupil | Dollars for Supplementary Weighting
 | (ex. 2 periods X 180 days) | (ex. 8 periods per day X 180 days) |  |  | (A/B*C*D=E)
 |  |  |  | 0.48 | 0 |  | 0
 | Whole-grade sharing pursuant to board action to study reorganization (A=B)
 | (Same calculation as above)
 |  |  |  | 0.1 | 0 |  | 0
 | Regional Academy Host
 | (Same calculation as above, minimum of 15 if both Arts/Sciences and CTE, maximum of 30)
 |  |  |  | 0.1 | 0 |  | 0
 | ICN
 | (Same calculation as above)
 |  |  |  | 0.05 | 0 |  | 0
 | Resident student attends a community college Arts/Science class for college credit.
 | (Same calculation as above)
 |  |  |  | 0.46 | 0 |  | 0
 | Resident student attends a community college Career/Technical Education class for college credit.
 | (Same calculation as above)
 |  |  |  | 0.7 | 0 |  | 0
 | Converting community college course hours to "periods" for this calculation
 | F | G | H | I | J | K
 | How many minutes in one sitting of the class | How many times a week does the class meet | Over how many weeks does the class meet | Total minutes in the community college class | How many minutes in one period at the high school | =The number of "periods" in the community college class
 |  |  |  | (F*G*H=I) |  | (I/J=K)
 |  |  |  | 0 |  | 0
 | (Operational Function Sharing Calculation may be found at:
 | [NAME] )
Spreadsheet: 888885d1739509237-using-index-and-match-where-match-has-several-conditions-reporting-n-a-error-tried-a-lot-book1
Sheet: Sheet1

Table1 |  |  |  |  |  | Table2
month | year | supervision | individual | future added columns |  | date | supervision | individual | future added columns
11 | 2024 | 1.4 | 2 |  |  | 2024-11-02 00:00:00
12 | 2024 | 1.77 | 1.69 |  |  | 2024-12-02 00:00:00
1 | 2025 | 1.58 | 1.64 |  |  | 2025-01-03 00:00:00
2 | 2025 | 1.56 | 1.27 |  |  | 2024-11-04 00:00:00
 |  |  |  |  |  | 2024-11-04 00:00:00
 |  |  |  |  |  | 2024-11-04 00:00:00
 |  |  |  |  |  | 2024-11-05 00:00:00
 |  |  |  |  |  | 2024-11-06 00:00:00
 |  |  |  |  |  | 2024-11-06 00:00:00
RNG1 |  |  |  |  |  | [NAME]
month | year | supervision | individual | future added columns |  | date | supervision | individual | future added columns
11 | 2024 | 1.4 | 2 |  |  | 2024-11-02 00:00:00
12 | 2024 | 1.77 | 1.69 |  |  | 2024-12-02 00:00:00
1 | 2025 | 1.58 | 1.64 |  |  | 2025-01-03 00:00:00
2 | 2025 | 1.56 | 1.27 |  |  | 2024-11-04 00:00:00
 |  |  |  |  |  | 2024-11-04 00:00:00
 |  |  |  |  |  | 2024-11-04 00:00:00
 |  |  |  |  |  | 2024-11-05 00:00:00
 |  |  |  |  |  | 2024-11-06 00:00:00
 |  |  |  |  |  | 2024-11-06 00:00:00
Spreadsheet: 879904d1727492302-filtering-data-using-mulitple-criteria-with-and-and-or-functions-test-dynamic-filtering
Sheet: Dynamic Filtering

 | Sales Comps |  |  |  |  |  | Results:
 |  |  |  |  |  |  |  |  |  |  |  |  | Instrument Date
 |  | Building Type |  | Retail |  |  | Area |  |  |  |  |  | From
 |  |  |  |  |  |  |  |  |  |  |  |  | To
 |  |  |  |  |  |  |  |  | MIN | MAX
 |  | City |  | rapid city | [NAME] |  | Square Feet |  |  |  |  |  | File Date
 |  | Zoning |  | General commercial district | Commercial most restrictive  C1 |  | $/Square Foot |  |  |  |  |  | From
 |  | Tax ID |  |  |  |  | Sales Price |  |  |  |  |  | To
 |  | Address |  |  |  |  | Acres
 |  | Grantee |  |  |  |  |  |  |  |  |  |  |  | Sorting
 |  | Grantor |  |  |  |  |  |  |  |  |  |  |  | Area
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Descending
 | Tax ID | Address | City | Area | Square Feet | $/Square Foot | Sales Price | Zoning | Instrument Date | Grantee | Grantor | Building Type | File Date | Acres
 |  | 8475 Main | Rapid City | City Center | 8469 | 183.0204274412563 | 1550000 | General commercial district | 2020-01-20 00:00:00 | N/A | N/A | Retail | 2020-01-21 00:00:00 | 0.9
 | 15684 | 658 Oak St | [NAME] | [NAME] | 7050 | 201.4184397163121 | 1420000 | Commercial most restrictive  C1 | 2020-01-22 00:00:00 | N/A | N/A | Retail | 2020-01-23 00:00:00 | 0.99
Spreadsheet: d538787f-bf1b-4e22-80a9-ff6cd85852c5
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43509551 | 2014-10-09 21:09:48 | AXIS | 1 | 5 | 3 | 1089753 | Interociter2 | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43509677 | 2014-10-09 21:23:03 | ALLIES | 0 | 3 | 5 | 1089753 | Interociter2 | 8709 | mediterranean | 1942-06-12 | 1942-06-12 | Knightsbridge | Knightsbridge
43609499 | 2014-10-16 21:40:36 | AXIS | 1 | 5 | 3 | 578329 | Valentin de Ramillies | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43609660 | 2014-10-16 21:51:59 | ALLIES | 1 | 5 | 2 | 578329 | Valentin de Ramillies | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
Spreadsheet: 863770d1711146902-formula-to-find-nth-value-based-on-multiple-criteria-with-duplicates-exp-report
Sheet: Sheet1

DATA |  |  |  |  | DESIRED RESULTS
SKU | QUANTITY | EXP DATE |  |  | SKU | Expiration 1 | Quantity 1 | Expiration 2 | Quantity 2 | Expiration 3 | Quantity 3 | Expiration 4 | Quantity 4
SKU1 | 34 | 2024-08-01 00:00:00 |  |  | SKU 1 | 2024-08-01 00:00:00 | 177 | 2024-09-01 00:00:00 | 1 | 2024-09-23 00:00:00 | 39 | 2024-09-30 00:00:00 | 104
SKU1 | 1 | 2024-08-01 00:00:00 |  |  | SKU 2 | 2024-10-17 00:00:00 | 827 | 2024-10-19 00:00:00 | 3950
SKU1 | 1 | 2024-08-01 00:00:00 |  |  | SKU 3 | 2024-10-17 00:00:00 | 5107 | 2024-10-21 00:00:00 | 5 | 2024-10-25 00:00:00 | 2073 | 2024-10-26 00:00:00 | 1
SKU1 | 1 | 2024-08-01 00:00:00
SKU1 | 1 | 2024-08-01 00:00:00
SKU1 | 1 | 2024-08-01 00:00:00
SKU1 | 1 | 2024-08-01 00:00:00 |  |  | SKU2 |  | 827 |  | 3950 |  | 0 |  | 0
SKU1 | 137 | 2024-08-01 00:00:00 |  |  | SKU3 |  | 5107 |  | 5 |  | 2073 |  | 1
SKU1 | 1 | 2024-09-01 00:00:00
SKU1 | 39 | 2024-09-23 00:00:00
SKU1 | 97 | 2024-09-30 00:00:00
SKU1 | 2 | 2024-09-30 00:00:00
SKU1 | 2 | 2024-09-30 00:00:00
SKU1 | 2 | 2024-09-30 00:00:00
SKU1 | 1 | 2024-09-30 00:00:00
SKU2 | 543 | 2024-10-17 00:00:00
SKU2 | 250 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 6 | 2024-10-17 00:00:00
SKU2 | 6 | 2024-10-17 00:00:00
SKU2 | 2 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 2 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 2 | 2024-10-17 00:00:00
SKU2 | 3 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 1 | 2024-10-17 00:00:00
SKU2 | 3950 | 2024-10-19 00:00:00
SKU3 | 1680 | 2024-10-20 00:00:00
SKU3 | 1759 | 2024-10-20 00:00:00
SKU3 | 1659 | 2024-10-20 00:00:00
SKU3 | 1 | 2024-10-20 00:00:00
SKU3 | 3 | 2024-10-20 00:00:00
SKU3 | 3 | 2024-10-20 00:00:00
SKU3 | 2 | 2024-10-20 00:00:00
SKU3 | 1 | 2024-10-21 00:00:00
SKU3 | 4 | 2024-10-21 00:00:00
SKU3 | 2071 | 2024-10-25 00:00:00
SKU3 | 2 | 2024-10-25 00:00:00
SKU3 | 1 | 2024-10-26 00:00:00
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: West Power Trading

 | West Power Trading
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  | % of |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  | Total Exp |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  |  | Compensation | 0 | 64
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense |  |  |  |  | 46080
ENAMKTEX | Marketing |  |  |  |  | 20000 |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  | 6094 |  |  |  | [NAME] | 52800 | 0
ENARENT | Rent |  |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  |  | Specialist | 63000
ENATRANS | Transportation |  |  |  |  | 0 |  |  |  | Sr. Specialist | 78000
ENAOTHEX | Other Expenses |  |  |  |  | 75000 |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  |  |  |  | Director | 156000 | 7
 | Headcount |  |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  |  | VP | 216000 | 2
 | Analyst & Associate Headcount |  |  |  |  |  |  |  |  | MD | 240000 | 1
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 677322
 |  |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 86787d1286761508-counting-frequency-of-transactions-by-time-sample-1-solution
Sheet: Sheet1

Name | Date/Time | Hour
[NAME] | 2014-09-30 16:40:00 | 16
[NAME] | 2014-10-01 16:19:43 | 16
[NAME] | 2014-10-02 17:50:39 | 17
[NAME] | 2014-10-02 07:18:00 | 7
[NAME] | 2014-10-02 09:16:00 | 9
12:00:00 | 0
01:00:00 | 0
02:00:00 | 0
03:00:00 | 0
04:00:00 | 0
05:00:00 | 0
06:00:00 | 0
07:00:00 | 1
08:00:00 | 0
09:00:00 | 1
10:00:00 | 0
11:00:00 | 0
12:00:00 | 0
01:00:00 | 0
02:00:00 | 0
03:00:00 | 0
04:00:00 | 2
05:00:00 | 1
06:00:00 | 0
07:00:00 | 0
08:00:00 | 0
09:00:00 | 0
10:00:00 | 0
11:00:00 | 0
Spreadsheet: 813920d1674057869-forula-to-highlight-diference-in-amounts-example
Sheet: 04.01

Number | Amount
0037192 | 3482.83149
0038274 | 111746.416583
0038655 | 3300.239421
0038834 | 1959.668205
0038874 | 3942.158921
0038876 | 16052.701798
0038885 | 4658.621696
0038904 | 1688.108711
0038929 | 9558.232123