tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 211928d1359992347-pull-data-based-on-day-of-week-from-another-workbook-for-previous-three-weeks-salesreport2013
Sheet: 0203

 | Date: | 2013-02-03 00:00:00
 | Day
 | Time | Trans. | Total Sales | Avg. Sales
 | 09:00:00 | 0 | 0
 | 10:00:00 | 8 | 38.87
 | 11:00:00 | 27 | 156.33
 | 12:00:00 | 56 | 494.04
 | 13:00:00 | 59 | 531.44
 | 14:00:00 | 36 | 172.06
 | 15:00:00 | 38 | 242.69
 | 16:00:00 | 35 | 274.12
 | 17:00:00 | 30 | 347.46
 | 18:00:00 | 22 | 188.76
 | 19:00:00 | 25 | 161.97
 | 20:00:00 | 12 | 65.25
 | 21:00:00 | 3 | 30.48
 | 22:00:00 | 12 | 52.72
 | 23:00:00 | 10 | 85.69
 | 1900-01-01 00:00:00 | 11 | 88.74
 | 1900-01-01 01:00:00 | 0 | 0
 | 1900-01-01 02:00:00 | 0 | 0
 | 1900-01-01 03:00:00 | 0 | 0
 | 04:00:00 | 0 | 0
 | Total
Spreadsheet: 489999d1479554512-football-predictions-football-predictions
Sheet: Week 35

Fixtures | Week 35 |  |  |  |  | Player Scores
Home Team | Score |  |  | Away Team |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | Damian West | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  | -
 |  |  |  |  | Weekly Total
Spreadsheet: 831542d1685707076-formular-to-call-data-from-another-sheet-5-and-6-ask
Sheet: WASICHANA

MKOA WA MANYARA
HALMASHAURI Y WILAYA [NAME]
MATOKEO [NAME] WA MUHULA WA KWANZA MEI, 2023 DARASA LA VI WASICHANA
S/N | KATA | SHULE | JINA LA MTAHINIWA | JINSI      2. MS | MASOMO |  |  |  |  |  |  |  |  |  |  |  | JML | WASTANI | DARAJA | [NAME] | [NAME]
 |  |  |  |  | KISWAHILI |  | ENGLISH |  | HISABATI |  | SAYANSI NA TEKNOLOJIA |  | M/JAM |  | URAIA NA MAADILI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D
1 |  | SHEKINA | [NAME] | 2 | 41 | A | 27 | C | 28 | C | 27 | C | 40 | B | 37 | B | 22 | C | 222 | 31.71428571428572 | B | 13 | 13
2 | KALOLENI | SHEKINA | GLADNESS P SHOSHO | 2 | 41 | A | 30 | C | 31 | B | 34 | B | 39 | B | 36 | B | 25 | C | 236 | 33.71428571428572 | B | 9 | 9
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Spreadsheet: 680316d1590941953-all-possible-combinations-of-two-lists-combinations
Sheet: Sheet2

Place A |  | Place B
October |  | October
Abees |  | Abees
[NAME] |  | [NAME]
[NAME] |  | [NAME]
Abo Hammad |  | Abo Hammad
[NAME] |  | [NAME]
[NAME] |  | [NAME]
Abo Rawash |  | Abo Rawash
Abo Rdees |  | Abo Rdees
Abo Soltan |  | Abo Soltan
Abo Zaabal |  | Abo Zaabal
Abo Zenima |  | Abo Zenima
Alamein |  | Alamein
[NAME] |  | [NAME]
Aresh |  | Aresh
Assiut |  | Assiut
Aswan |  | Aswan
Attaka |  | Attaka
[NAME] |  | [NAME]
Badr City |  | Badr City
Banha |  | Banha
[NAME] |  | [NAME]
Belbees |  | Belbees
[NAME] |  | [NAME]
Cairo |  | Cairo
Dahshour |  | Dahshour
Dakhla |  | Dakhla
Damietta |  | Damietta
Damnhour |  | Damnhour
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
El Salam City |  | El Salam City
[NAME] |  | [NAME]
El-Amreya |  | El-Amreya
El-Asher |  | El-Asher
El-Ayat |  | El-Ayat
El-Esmaileya |  | El-Esmaileya
El-Fayom |  | El-Fayom
El-Hamam |  | El-Hamam
El-Kanater |  | El-Kanater
El-Kattamya |  | El-Kattamya
el-khatatba |  | el-khatatba
El-Mahala |  | El-Mahala
El-Mansoura |  | El-Mansoura
El-Minia |  | El-Minia
El-Monofeya |  | El-Monofeya
El-Nobaria |  | El-Nobaria
El-Obour |  | El-Obour
El-Reef El-Oroby |  | El-Reef El-Oroby
El-Salheya |  | El-Salheya
El-Sharkeya |  | El-Sharkeya
El-Suez |  | El-Suez
El-Tawfikeya |  | El-Tawfikeya
Esna |  | Esna
Fashn |  | Fashn
[NAME] |  | [NAME]
Gamasa |  | Gamasa
[NAME] |  | [NAME]
[NAME] |  | [NAME]
HELWAN |  | HELWAN
Hikestep |  | Hikestep
hosh eisa |  | hosh eisa
Hurghada |  | Hurghada
Idko |  | Idko
Inshas |  | Inshas
Inside Port |  | Inside Port
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
Kaha |  | Kaha
Kallyob |  | Kallyob
[NAME] |  | [NAME]
Kharga |  | Kharga
[NAME] |  | [NAME]
Korymat Helwan |  | Korymat Helwan
Korymat Sokhna |  | Korymat Sokhna
kowsna |  | kowsna
Luxor |  | Luxor
[NAME] |  | [NAME]
Manash |  | Manash
Mars Alam |  | Mars Alam
[NAME] |  | [NAME]
MAZARAA DINA |  | MAZARAA DINA
[NAME] |  | [NAME]
Merghem |  | Merghem
[NAME] |  | [NAME]
New Cairo |  | New Cairo
New Capital |  | New Capital
New capital - Mahager |  | New capital - Mahager
Om [NAME] |  | Om [NAME]
Outside Port |  | Outside Port
Owynat |  | Owynat
[NAME] |  | [NAME]
Port Tawfik |  | Port Tawfik
Qabbary |  | Qabbary
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
Rashid |  | Rashid
Robeiky |  | Robeiky
[NAME] |  | [NAME]
Safaga |  | Safaga
[NAME] |  | [NAME]
Shabrakheit |  | Shabrakheit
Shabramant |  | Shabramant
Sharm El-Sheikh |  | Sharm El-Sheikh
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
Siwa |  | Siwa
Sohag |  | Sohag
Sokhna |  | Sokhna
Solimania |  | Solimania
Tanta |  | Tanta
[NAME] |  | [NAME]
Tookh |  | Tookh
Toshka |  | Toshka
wadi [NAME] |  | wadi [NAME]
[NAME] |  | [NAME]
Wadi El-Natron |  | Wadi El-Natron
Wahat Bahrya |  | Wahat Bahrya
[NAME] |  | [NAME]
Zafarana |  | Zafarana
ZEFTA |  | ZEFTA
[NAME] |  | [NAME]
(blank) |  | (blank)
Spreadsheet: phillip_m_love__30678__200001Trans_OA
Sheet: TX-HPLC-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  HPLC - Transport
REGION:  TEXAS
PRODUCTION MONTH 0001
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
30 |  | Transport Revenue - Sharp
31 |  | Transport Revenue - Martin
32 |  | Transport Revenue - Third Party
33 |  | Compressor Fuel Expense
34 |  | Transport Expense - Third Party
35 |  | Unaccounted for Gas Loss
36 |  | Originations
37
38
39 |  | Miscellaneous
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 888152d1738594730-possible-to-change-highlight-cells-different-color-before-and-after-cf-with-3-colors_3
Sheet: Sheet1

Start | End |  | 2025-01-01 00:00:00 | 2025-01-02 00:00:00 | 2025-01-03 00:00:00 | 2025-01-04 00:00:00 | 2025-01-05 00:00:00 | 2025-01-06 00:00:00 | 2025-01-07 00:00:00 | 2025-01-08 00:00:00 | 2025-01-09 00:00:00 | 2025-01-10 00:00:00 | 2025-01-11 00:00:00 | 2025-01-12 00:00:00 | 2025-01-13 00:00:00 | 2025-01-14 00:00:00 | 2025-01-15 00:00:00
2025-01-04 00:00:00 | 2025-01-10 00:00:00 | 1 |  |  | 1
2025-01-02 00:00:00 | 2025-01-12 00:00:00 | 2 | 2
2025-01-05 00:00:00 | 2025-01-15 00:00:00 | 6 |  |  |  | 6
2025-01-07 00:00:00 | 2025-01-12 00:00:00 | 5 |  |  |  |  |  | 5
2025-01-02 00:00:00 | 2025-01-08 00:00:00 | 3 | 3
2025-01-04 00:00:00 | 2025-01-14 00:00:00 | 4 |  |  | 4
 |  |  |  |  | I made only CF for nr 1 and 2
Spreadsheet: sara_shackleton__36614__Star Gas Propane Swaps - CAS 1-16-02
Sheet: Check List Documentation

Star Gas Propane, L.P.
D E A L |  |  |  |  | L E G A L |  |  |  |  |  |  | C O N T R A C T S |  |  | C O L L A T E R A L
Contract Number | Enron Entity | Debtor | P/F | Product | Master | Omnibus | Netting Agreement | Termination Letter | Termination Date | 1 Way/2 Way/Silent on Payment Termination | Proposed Termination Amount | Enron Confirm | Customer Confirm | Broker Confirm | Guaranty | L/C | Cash
V04385.1 | ENA | Y | F | [NAME] | N | Y | N | N | n/a | ? | 1864501 | Y |  |  | n/a | n/a | n/a
V70597.1 | ENA | Y | F | [NAME] | N | Y | N | N | n/a | ? | 1864501 | Y |  |  | n/a | n/a | n/a
VC3690.1 | ENA | Y | F | [NAME] | N | Y | N | N | n/a | ? | 1864501 | Y |  |  | n/a | n/a | n/a
VE4488.1 | ENA | Y | F | [NAME] | N | Y | N | N | n/a | ? | 1864501 | Y |  |  | n/a | n/a | n/a
VV1060.1 | ENA | Y | F | [NAME] | N | Y | N | N | n/a | ? | 1864501 | Y |  |  | n/a | n/a | n/a
Y48721.1 | ENA | Y | F | [NAME] | N | Y | N | N | n/a | ? | 1864501 | Y |  |  | n/a | n/a | n/a
Y70079.1 | ENA | Y | F | [NAME] | N | Y | N | N | n/a | ? | 1864501 | Y |  |  | n/a | n/a | n/a
VQ3874.1 | ENA | Y | F | [NAME] | N | Y | N | N | n/a | ? | 1864501 | Y |  |  | n/a | n/a | n/a
VQ3603.1 | ENA | Y | F | [NAME] | N | Y | N | N | n/a | ? | 1864501 | Y |  |  | n/a | n/a | n/a
Spreadsheet: 5d8e92fb-c694-4bb2-bbe9-75dc028db0bf
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0034201 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | Cruse Meat Processing | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Cabarrus | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 0.95 |  | Area (acres): |  | 0.95 |  | Area (acres): |  | 0.95 |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in): |  | 0.5 |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 8.43 |  | Annual Rate (in): |  | 8.43 |  | Annual Rate (in): |  | 8.43 |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 65682d1266363179-excel-2007-sorting-how-to-get-a2-come-before-a10-example5432
Sheet: Sheet1

SetCode | bympg | fzrtz | sortby
A1 | 0 | 0 | A0000001
A2 | 142 | 13789.57 | A0000002
A3 | 129 | 285189.47 | A0000003
A4 | 5955 | 6427 | A0000004
A5 | 614 | 767.5 | A0000005
A6 | 4907 | 24520 | A0000006
A7 | 37400 | 1009557 | A0000007
A8 | 1173 | 15249 | A0000008
A9 | 4904 | 24520 | A0000009
A10 | 47426 | 25894577.16 | A0000010
A11 | 900283 | 12907055.97 | A0000011
A12 | 0 | 0 | A0000012
A13 | 761 | 78397.61 | A0000013
A14 | 1214590 | 255453182.53 | A0000014
A15 | 0 | 0 | A0000015
A16 | 0 | 0 | A0000016
A17 | 57841 | 57841 | A0000017
A18 | 0 | 0 | A0000018
A19 | 4096 | 117128.46 | A0000019
A20 | 4092 | 22616.15 | A0000020
aa1 | 0 | 0 | aa0000001
aa2 | 0 | 0 | aa0000002
aa3 | 583785 | 5721191.5 | aa0000003
aa4 | 0 | 0 | aa0000004
aaa1 | 0 | 0 | aaa0000001
b1 | 179302 | 545519.25 | b0000001
B2 | 5299867 | 10694189.6 | B0000002
b3 | 47619 | 47626 | b0000003
b4 | 312 | 624 | b0000004
ba1 | 312 | 1170 | ba0000001
ba3 | 0 | 0 | ba0000003
c1 | 0 | 0 | c0000001
c2 | 2257911 | 4511762.25 | c0000002
c3 | 0 | 0 | c0000003
cc4 | 0 | 0 | cc0000004
d1 | 21235 | 849373 | d0000001
e1 | 4721051 | 100130958.95 | e0000001
e3 | 5309961 | 5358133 | e0000003
e5 | 0 | 0 | e0000005
vx2 | 5312310 | 22800910.2 | vx0000002
Spreadsheet: kate_symes__18415__MidC
Sheet: DJ Mid-C Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-03 00:00:00 |  | 175.7 | 14400 | 163.68 | 3800
 | 2001-01-02 00:00:00 |  | 185.67 | 14400 | 176.33 | 3000 | 142.46 | 2097 | 126.6 | 1453
 | 2001-01-01 00:00:00 |  | 187.5 | 0 | 175 | 0 | 111.05 | 95 | 110 | 300 |  | 176.33 | 9000
 | 2000-12-31 00:00:00 |  | 167.5 | 0 | 157.5 | 0 | 150.12 | 2630 | 110 | 450 |  | 164.5 | 19440
 | 2000-12-30 00:00:00 |  | 171.7 | 19408 | 160.7 | 5608 | 146.38 | 705 | 145.32 | 1175
 | 2000-12-29 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 214.02 | 1107 | 166.68 | 674
 | 2000-12-28 00:00:00 |  | 217.65 | 10992 | 169.05 | 3208 | 190.98 | 1381 | 158.36 | 802
 | 2000-12-27 00:00:00 |  | 394.68 | 12400 | 267.17 | 3320 | 165.54 | 2855 | 159.35 | 1123
 | 2000-12-26 00:00:00 |  | 451.15 | 10624 | 428.32 | 2712 | 182.26 | 2772 | 177.14 | 934
 | 2000-12-25 00:00:00 |  | 410 | 32 | 315 | 200 | 201.38 | 12441 | 207.74 | 775 |  | 377.09 | 5160
 | 2000-12-24 00:00:00 |  |  |  | 315 | 200 | 225.8 | 1588 | 225.35 | 855 |  | 377.09 | 5160
 | 2000-12-23 00:00:00 |  | 462.41 | 8224 | 382.64 | 1912 | 325.41 | 4915 | 244.19 | 2400
 | 2000-12-22 00:00:00 |  | 463 | 8624 | 382.94 | 1712 | 349.16 | 4653 | 309.33 | 2630
 | 2000-12-21 00:00:00 |  | 463 | 8624 | 384.75 | 2112 | 425 | 150 | 350 | 50
 | 2000-12-20 00:00:00 |  | 463.54 | 9424 | 386.4 | 1912 | 411.71 | 1117 | 365.63 | 240
 | 2000-12-19 00:00:00 |  | 471.25 | 7824 | 408.97 | 312 | 547.65 | 3749 | 506.72 | 1005
 | 2000-12-18 00:00:00 |  | 372.89 | 7600 | 321.88 | 1600 | 378.62 | 360 | 328.33 | 150
 | 2000-12-17 00:00:00 |  |  |  |  |  | 368.41 | 1404 | 355.96 | 663 |  | 321.88 | 4800
 | 2000-12-16 00:00:00 |  | 317.57 | 11504 | 272.19 | 1112 | 374.92 | 642 | 339.88 | 168
 | 2000-12-15 00:00:00 |  | 317.59 | 11424 | 272.19 | 1112 | 364.78 | 598 | 477.91 | 763
 | 2000-12-14 00:00:00 |  | 459.34 | 7024 | 342.87 | 1712 | 380.91 | 1574 | 283 | 1890
 | 2000-12-13 00:00:00 |  | 700.87 | 7824 | 485.4 | 1712 | 391.35 | 1561 | 349.97 | 318
 | 2000-12-12 00:00:00 |  | 956.16 | 9024 | 636.87 | 2712 | 526.56 | 322 | 355.87 | 412
 | 2000-12-11 00:00:00 |  | 3322.42 | 5744 | 2166.67 | 600 | 1285.47 | 695 | 451.85 | 621
 | 2000-12-10 00:00:00 |  |  |  |  |  | 595.02 | 1607 | 516.15 | 975 |  | 2125 | 2400
 | 2000-12-09 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 423.26 | 1913 | 496.71 | 380
 | 2000-12-08 00:00:00 |  | 781.79 | 10896 | 449.75 | 808 | 604.06 | 1877 | 475.29 | 433
 | 2000-12-07 00:00:00 |  | 628.75 | 8000 | 490 | 1000 | 664.04 | 2134 | 377.22 | 552
 | 2000-12-06 00:00:00 |  | 360.3 | 13200 | 283.68 | 3800 | 417.71 | 480 | 254.49 | 195
 | 2000-12-05 00:00:00 |  | 278.15 | 16000 | 234.69 | 3200 | 305.36 | 1340 | 275 | 1155
 | 2000-12-04 00:00:00 |  | 276.46 | 14800 | 247.86 | 4200 | 261.33 | 1471 | 225.6 | 1552
 |  |  |  |  |  | ..
Spreadsheet: 882410d1730804875-calendar-summary-ef1658_uretim-programi-takvim
Sheet: Takvim

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1-10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yıl | 2024 |  |  | 11-20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 11 |  |  | 31-40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41-50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  | Range: | 1-10
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  |  |  | Notlar
Spreadsheet: 865922d1712872826-power-query-move-every-second-row-book1-2-
Sheet: Sheet1

Emp ID | Level | Employee Name | Attendance/Score |  |  | Emp ID | Level | Employee Name | Attendance | Score
1 | OO1 | A | 0.3 |  |  |  |  |  | 0.3 | 0
1 | OO1 | A | 0 |  |  | 2 | PP1 | B | 0.6 | 1
2 | PP1 | B | 0.6 |  |  | 3 | CC3 | C | 0.8 | 1
2 | PP1 | B | 1 |  |  | 4 | OI11 | D | 0.1 | 0
3 | CC3 | C | 0.8
3 | CC3 | C | 1
4 | OI11 | D | 0.1 |  |  | DESIRED RESULTS
4 | OI11 | D | 0
RAW
Spreadsheet: 716640d1612291826-excel-formula-for-multi-tiered-pricing-water
Sheet: Sheet1

Charge Rate | Cost Per 1000 gallons |  |  | Total Gallons Used: | 12000
Base Charge | 21.53 | Floor |  | Final Bill:
0 to 5,000 gallons | 3 | 0
5,001 to 10,000 gallons | 3.45 | 5001
10,001 to 15,000 gallons | 3.97 | 10001
15,001 to 20,000 gallons | 4.56 | 15001
20,001 to 25,000 gallons | 5.25 | 20001
>25,001 gallons | 6.03 | 25001
Spreadsheet: 269980d1381339160-sumifs-function-scenario_3_start-2013-finished
Sheet: Campaign

Client ID | Campaign ID | Name | Client Name | Start Date | Manager | Type | Status
1 | 1 | Think Small |  | 2013-01-12 00:00:00 | [NAME] | [NAME] | Paid
2 | 2 | Great Taste, Less Filling |  | 2013-01-14 00:00:00 | Sean | Radio | Paid
4 | 3 | A Diamond is Forever |  | 2013-01-20 00:00:00 | [NAME] | Magazine | Paid
1 | 4 | Think Small |  | 2013-01-22 00:00:00 | [NAME] | Newspaper | Unpaid
6 | 5 | Marlboro Man |  | 2013-01-27 00:00:00 | [NAME] | Television | Unpaid
1 | 6 | Think Small |  | 2013-02-04 00:00:00 | Ray | Social Media | Unpaid
3 | 7 | Just Do It |  | 2013-02-10 00:00:00 | Mark | Magazine | Paid
8 | 8 | Where is the Beef |  | 2013-02-14 00:00:00 | Sean | Newspaper | Unpaid
9 | 9 | Get a Mac |  | 2013-02-17 00:00:00 | Mark | Social Media | Paid
2 | 10 | Great Taste, Less Filling |  | 2013-02-22 00:00:00 | [NAME] | Social Media | Unpaid
7 | 11 | Got Milk |  | 2013-02-27 00:00:00 | [NAME] | [NAME] | Unpaid
2 | 12 | Great Taste, Less Filling |  | 2013-02-27 00:00:00 | [NAME] | Television | Unpaid
7 | 13 | Got Milk |  | 2013-03-05 00:00:00 | Mark | Social Media | Unpaid
4 | 14 | A Diamond is Forever |  | 2013-03-07 00:00:00 | [NAME] | Social Media | Unpaid
9 | 15 | Get a Mac |  | 2013-03-10 00:00:00 | [NAME] | Newspaper | Unpaid
2 | 16 | Great Taste, Less Filling |  | 2013-03-14 00:00:00 | [NAME] | Radio | Unpaid
5 | 17 | The Absolut Bottle |  | 2013-03-20 00:00:00 | Sean | Social Media | paid
6 | 18 | Marlboro Man |  | 2013-03-27 00:00:00 | [NAME] | Radio | Unpaid
7 | 19 | Got Milk |  | 2013-03-30 00:00:00 | Ray | Radio | Unpaid
5 | 20 | The Absolut Bottle |  | 2013-04-04 00:00:00 | [NAME] | Newspaper | Unpaid
8 | 21 | Where is the Beef |  | 2013-04-10 00:00:00 | Ray | Television | Unpaid
9 | 22 | Get a Mac |  | 2013-04-15 00:00:00 | [NAME] | Magazine | Unpaid
10 | 23 | Does she or Doesn’t She |  | 2013-04-17 00:00:00 | Sean | Radio | Unpaid
10 | 24 | Does she or Doesn’t She |  | 2013-04-18 00:00:00 | [NAME] | Newspaper | Unpaid
Spreadsheet: 838996d1691588551-excel-sumif-based-on-frequency-and-unique-value-in-another-cell-data
Sheet: Sheet3

ID | Date | Amount
190326 | 2023-05-09 00:00:00 | 2 |  | 190326
190326 | 2023-07-27 00:00:00 | 13 |  | 191712
190326 | 2023-08-05 00:00:00 | 4 |  | 141922
191712 | 2023-08-05 00:00:00 | 4 |  | 149847
191712 | 2023-08-05 00:00:00 | 4 |  | 129741
141922 | 2023-01-24 00:00:00 | 1 |  | 187294
141922 | 2023-01-24 00:00:00 | 1 |  | 150398
149847 | 2023-07-02 00:00:00 | 1 |  | 188045
149847 | 2023-07-02 00:00:00 | 1 |  | 145310
149847 | 2023-07-02 00:00:00 | 1 |  | 195288
149847 | 2023-07-02 00:00:00 | 1 |  | 142429
149847 | 2023-07-02 00:00:00 | 1 |  | 162240
149847 | 2023-07-02 00:00:00 | 1 |  | 194721
129741 | 2023-02-08 00:00:00 | 1 |  | 118435
187294 | 2023-05-14 00:00:00 | 2 |  | 165080
187294 | 2023-05-14 00:00:00 | 2 |  | 104417
187294 | 2023-05-14 00:00:00 | 2 |  | 195870
150398 | 2023-03-09 00:00:00 | 1 |  | 183023
188045 | 2023-06-04 00:00:00 | 1 |  | 105288
188045 | 2023-06-04 00:00:00 | 1 |  | 166119
188045 | 2023-06-04 00:00:00 | 1
188045 | 2023-06-04 00:00:00 | 1
145310 | 2023-07-24 00:00:00 | 3
145310 | 2023-07-24 00:00:00 | 3
145310 | 2023-07-24 00:00:00 | 3
145310 | 2023-07-24 00:00:00 | 3
195288 | 2023-03-22 00:00:00 | 1
195288 | 2023-03-22 00:00:00 | 1
142429 | 2023-06-24 00:00:00 | 2
162240 | 2023-02-27 00:00:00 | 1
194721 | 2023-01-20 00:00:00 | 2
118435 | 2023-06-20 00:00:00 | 50
165080 | 2023-02-25 00:00:00 | 15
165080 | 2023-02-25 00:00:00 | 15
165080 | 2023-02-25 00:00:00 | 15
165080 | 2023-02-25 00:00:00 | 15
104417 | 2023-06-03 00:00:00 | 1
195870 | 2023-05-26 00:00:00 | 1
195870 | 2023-05-26 00:00:00 | 1
183023 | 2023-07-14 00:00:00 | 26
183023 | 2023-07-14 00:00:00 | 26
183023 | 2023-07-14 00:00:00 | 26
105288 | 2023-01-13 00:00:00 | 1
166119 | 2023-03-24 00:00:00 | 1
Spreadsheet: 28085d1221945648-compare-2-columns-then-give-count-example
Sheet: Sheet1

 |  |  |  | 1st [NAME] | 2nd [NAME] | Answer should be:
 | Jan | 1000 |  | 400 | 400 | 1000
 | Jan | x
 | Jan | x
 | Jan | n/a
 | Jan | 1000
 | Feb | x
 | Feb | 2000
 | Feb | 2000
 | Feb | 2000
 | Feb | x
 | Feb | 2000
 | Mar | x
 | Mar | 3000
 | Apr | 4000
 | Apr | x
 | Apr | x
 | Apr | 4000
 | Apr | n/a
 | Apr | 4000
 | May | x
Spreadsheet: 021e46ab-1433-4312-b0b6-2c552c8b8a6d
Sheet: FileExample

File Example; changes noted
 | Change notation
<?xml version="1.0" encoding="UTF-8"?>
<!--Sample XML file generated by XMLSpy v2012 rel. 2 (x64) (http://www.altova.com)-->
<SERVSCourseSubmission xsi:noNamespaceSchemaLocation="DistrictCourseCatalogue_schema_v2.xsd" xmlns:[NAME]/XMLSchema-instance">
<SchemaVersion>2</SchemaVersion> | Must be 2
<[NAME]
<OrganizationID>
<UnitNumber>0001</UnitNumber> | Site tag has been removed
<UnitType>01</UnitType>
</OrganizationID>
<Year>2012</Year> | Year can be greater than 2011
</Header>
<CourseRecords>
<CourseRecord>
<LocalCourseCode> </LocalCourseCode>
<LocalTitle> </LocalTitle>
<SiteNumber>000</SiteNumber>
<StateCourseCode>12345</StateCourseCode>
<CourseLevels>
<CourseLevel>X</CourseLevel>
</CourseLevels> | AP and IB indicators removed
<SequenceNumber>1</SequenceNumber>
<SequenceLimit>1</SequenceLimit>
<StandardAddressed>S</StandardAddressed>
<GradRequirementIndicator>true</GradRequirementIndicator>
<EndOfCourseIndicator>true</EndOfCourseIndicator>
<Colleges> | New section
<College>
<CollegeCourseLevel>X</CollegeCourseLevel>
<CollegeCode>000000</CollegeCode>
<CollegeCourseCode>!</CollegeCourseCode>
<CollegeCourseCredits>0</CollegeCourseCredits>
</College>
</Colleges>
<LocalDescription> </LocalDescription> | New element
</CourseRecord>
</CourseRecords>
</SERVSCourseSubmission>
Spreadsheet: 160881d1339268423-breakdown-hours-formula-overtime
Sheet: IDP

 | 2012-06-02 00:00:00 |  | 2012-06-03 00:00:00 |  | 2012-06-04 00:00:00
PST | [NAME] | Actual Hrs | [NAME] | Actual Hrs | [NAME] | Actual Hrs
03:00:00
03:30:00
04:00:00
04:30:00
05:00:00
05:30:00
06:00:00
06:30:00
07:00:00
07:30:00
08:00:00
08:30:00
09:00:00
09:30:00
10:00:00
10:30:00
11:00:00
11:30:00
12:00:00
12:30:00
13:00:00
13:30:00
14:00:00
14:30:00
15:00:00
15:30:00
16:00:00
16:30:00
17:00:00
17:30:00
18:00:00
18:30:00
19:00:00
19:30:00
20:00:00
20:30:00
21:00:00
21:30:00
Total Hrs