tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 586356d1534340210-formula-not-giving-expected-results-sample-workbook
Sheet: Floors & Ceilings

Directions: Select type of floor (Open Web or Solid) and sheathing. Select sheetrock (1/2" or 5/8").
Floors |  |  |  | Span - Supporting Deck |  |  |  | Stairway
Open Web Joist | OSB |  |  | [NAME] | Cost Per LF |  |  | Total | 282.9484
[NAME] | Per SF |  |  | 10'-14' | 7.861939
10 | 4.799447840329996 |  |  | 14' 1"-16' | 7.675249 |  |  | U-Shaped Stairway
11 | 4.815943626382381 |  |  |  |  |  |  | Total | 354.9282
12 | 4.515391575240468
13 | 4.620193491522449
14 | 4.297452457319376
15 | 4.320182392625166
16 | 4.056534681378558
Ceilings |  |  |  | Span - Supporting Ceiling
1/2 Sheetrock |  |  |  | Per LF | 5.001008571428571
[NAME] | Per SF | Mass. Code
10 | 2.401433207711192 | 0.01555625
11 | 2.471166055248657 | 0.01563068181818182
12 | 2.291347300155226 | 0.01569270833333333
13 | 2.280125139129425 | 0.01574519230769231
14 | 2.13867796936128 | 0.01579017857142857
15 | 2.112840422228887 | 0.01582916666666667
16 | 1.998892130988043 | 0.01586328125
Spreadsheet: 1af37c26-16f5-439c-ba8b-59f0133b483a
Sheet: Sheet1

OGLALA LAKOTA COLLEGE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | MILEAGE REPORT
DATE:_____________________ |  |  | ACCOUNT CODE:______________________________
___________________________________ |  |  | ______________________________________
NAME |  |  | CLAIMANT SIGNATURE
___________________________________ |  |  | _______________________________________
ADDRESS |  |  | SUPERVISOR SIGNATURE
DATE | FROM | TO | PURPOSE OF TRAVEL | [NAME]
TOTAL MILEAGE __________________________X.485 Per Mile =_______________________
September 30 thru December 31, 2005
TOTAL MILEAGE __________________________X.445 Per Mile =_______________________
effective January 1, 2006
Spreadsheet: 201283d1355937329-link-sheets-so-that-so-that-values-are-automatically-updated-example
Sheet: Weekly Scheudule

[DEPARTMENT SCHEDULE]
 | SUNDAY |  |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY
PAY PERIOD: 12/9 | 2012-12-09 00:00:00 |  |  | 2012-12-10 00:00:00 |  |  | 2012-12-11 00:00:00 |  |  | 2012-12-12 00:00:00 |  |  | 2012-12-13 00:00:00 |  |  | 2012-12-14 00:00:00 |  |  | 2012-12-15 00:00:00
STORE HOURS | 11AM-8PM |  |  | 9AM-9PM |  |  | 9AM-9PM |  |  | 9AM-9PM |  |  | 9AM-9PM |  |  | 9AM-9PM |  |  | 9AM-9PM |  |  | Total Hours
[NAME] | 08:00:00 | 17:00:00 |  |  |  |  | 09:00:00 | 16:00:00 |  |  |  |  | 09:00:00 | 17:00:00 |  | 04:00:00 | 06:00:00 |  | 12:00:00 | 22:00:00
[NAME] | 15:00:00 | 22:00:00 |  | 10:00:00 | 16:00:00 |  |  |  |  | 09:00:00 | 17:00:00 |  | 18:00:00 | 22:00:00
[NAME] | 13:00:00 | 17:00:00 |  | 13:00:00 | 19:00:00 |  |  |  |  |  |  |  | 18:00:00 | 22:00:00 |  |  |  |  | 17:00:00 | 22:00:00
[NAME] | 13:00:00 | 16:00:00
Eli
Samantha
Akoto
[NAME]
Gene
[NAME]
Kiesha
[NAME]
[NAME]
[NAME]
Benicio
Quiana
Taquasha
Romera
Total Hours Daily:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budgeted Hours: | 6000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Real Hours:
Spreadsheet: 624982d1558211094-trying-to-build-a-navigation-route-card-for-royal-marine-training-route-card
Sheet: Page 1

 | Name: |  |  |  |  |  | Route Card |  |  |  |  |  |  |  | Section
 | Leg | From | To | GridB | MAGB | BACK | DIST | PACE | Elev. | TIME | Description
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _ | 3200 |  | 4 | 100 | 70 | 1 | 2.5
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
 |  | _ _ _  / _ _ _ | _ _ _  / _ _ _
Spreadsheet: 883947d1732744329-lambda-and-xlookup-issue-excel-sumif-let-riddle
Sheet: Sheet1

 | Raw data |  |  |  |  |  |  |  | Named ranges
 | Fruits | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 |  |  | References | Name
 | Apples | 2229 | 2366 | 2623 | 2878 | 3001 |  |  | A3:F4 | tblData
 | Pears | 700 | 849 | 1140 | 1294 | 1568 |  |  | B3:G13 | tblDataBody
 | [NAME] | 0 | 0 | 0 | 0 | 0 |  |  | A4:A14 | lstFruits
 | Bananas | 176 | 184 | 219 | 224 | 226 |  |  | C2:G2 | lstMonths
 | Peaches | 7 | 8 | 9 | 10 | 10 |  |  | A18:D20 | tblBundles
 | Cherries | 296 | 207 | 205 | 217 | 222 |  |  | A18:A20 | lstBundles
 | Tomatoes | 155 | 158 | 161 | 164 | 168
 | Dates | 383 | 390 | 397 | 444 | 451
 | Nuts | 0 | 23 | 46 | 35 | 89
 | Raspberries | 4511 | 5622 | 7732 | 8966 | 11132
 | Strawberries | 11877 | 12088 | 15770 | 16041 | 18154
 | Bundles
 | Name | Includes
 | Red | Strawberries | Raspberries | Cherries | Tomatoes
 | Yellow | Pears | Apples | Peaches | Bananas
 | Dry | Nuts | [NAME] | Dates
 | Reports
 | Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- This solution works great enough, but I am looking to simplify it even more.
 | Red |  |  |  |  | =SUM(SUMIFS(B$4:B$14,lstFruits,FILTER(tblBundles,lstBundles=$A25,0)))
 | Yellow |  |  |  |  | Look in January data,in the list of fruits and sum if fruit is included in the bundle filtered to the bundle color.
 | Dry
 |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- I'd love to have a clean LET function, pass the ranges for months and bundle names to a LAMBDA function
 | Red |  | #[NAME]! | #[NAME]! |  | and spill the values in the table. I banged my head on the SUMIF only accepting ranges issue for days…
 | Yellow | #[NAME]! | #[NAME]! | #[NAME]! |  | Can I use the same FILTER approach, and use a LAMBDA to SUM all the XLOOKUP values for each fruit?
 | Dry | #[NAME]! | #[NAME]! | #[NAME]! |  | I've failed so far…
 | 3 month all table output |  |  |  |  | <- It updates the table correctly (I ca format the dates later), but the main calc seems to havethe same issue.
 |  | 45658 | 45689 | 45717
 | Red | #[NAME]! | #[NAME]! | #[NAME]!
 | Yellow | #[NAME]! | #[NAME]! | #[NAME]!
 | Dry | #[NAME]! | #[NAME]! | #[NAME]!
 | [NAME] exploration
 |  |  | Raspberries | Cherries | Tomatoes
Spreadsheet: 792964d1661246717-create-dropdown-with-matching-help-07
Sheet: Sheet1

 | COACHING STAGE |  |  |  |  | Site Wide | Gantry | Roof | SGA1 | Infra | Core
 | Team | Assigned Coach | Date assigned |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | SGA1 |  |  |  |  | benny | benny | PETER | [NAME] | benny | benny
 | Infra |  |  |  |  |  | HELI | ALEX | benny | Cute | Bye
 |  |  |  |  |  |  |  | benny |  |  | Thailand
 | After select Column B dropdown
 | Column C dropdown will base on column b selection to select coach
Spreadsheet: 49843d1249279570-sum-values-in-a-dynamic-range-contiguous-cells-in-a-table-example
Sheet: 9

Actuals
Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Comments | Job comments
TOTALS |  |  |  |  | 170030 |  | TOTALS
 |  |  |  |  | 8208 |  | 9
 |  |  |  |  | 7425 |  | 9
 |  |  |  |  | 9479 |  | 9
 |  |  |  |  | 8817 |  | 9
 |  |  |  |  | 6604 |  | 9
 |  |  |  |  | 8499 |  | 9
 |  |  |  |  | 6566 |  | 9
 |  |  |  |  | 3365 |  | 9
 |  |  |  |  | 6015 |  | 9
 |  |  |  |  | 974 |  | 9
 |  |  |  |  | 3032 |  | 9
 |  |  |  |  | 699 |  | 9
 |  |  |  |  | 7366 |  | 9
 |  |  |  |  | 1099 |  | 9
 |  |  |  |  | 1429 |  | 9
 |  |  |  |  | 6578 |  | 9
 |  |  |  |  | 7906 |  | 9
 |  |  |  |  | 8603 |  | 9
 |  |  |  |  | 9707 |  | 9
 |  |  |  |  | 7539 |  | 9
 |  |  |  |  | 4299 |  | 9
 |  |  |  |  | 2219 | 45.15 | 9
 |  |  |  |  | 243 |  | 9
 |  |  |  |  | 6680 |  | 9
 |  |  |  |  | 4879 |  | 9
 |  |  |  |  | 7236 |  | 9
 |  |  |  |  | 5365 |  | 9
 |  |  |  |  | 3996 |  | 9
 |  |  |  |  | 4693 |  | 9
 |  |  |  |  | 7126 |  | 9
 |  |  |  |  | 3384 |  | 9
Spreadsheet: 04e496d5-00f6-4d29-84cf-a78704766449
Sheet: Derby Results

 | Laurel Highlands Council, Keystone District 2012 Klondike Derby Results
 | Station |  | # [NAME] | # Adults | Sled Inspection | Cooking | First Aid | [NAME] | Sled Race | Fire Building | Orienteering | Knot Tying | [NAME] | Shooting Range | Scout Trivia | Citizenship | Final Station Total | Orienteering time | Score submitted by patrol | Sled Race Time | Patrol Method | Scout Spirit
 | Unit | [NAME] |  |  | #1 * | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 | #10 | #11 | #12 | [NAME] 327 |  |  |  | [NAME] 48 | [NAME] 36
1 |  |  | 5 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 308.5
2 |  |  | 7 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 306.3
3 |  |  | 5 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 300.8
4 |  |  | 7 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 296.7
5 |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 296
6 |  |  | 6 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 295.7
7 |  |  | 11 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 274.8
8 |  |  | 4 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 291.2
9 |  |  | 7 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 290.6
10 |  |  | 6 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 286.5
11 |  |  | 8 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 288.8
12 |  |  | 8 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 280.1
13 |  |  | 5 | 2 |  |  |  |  |  |  |  | 14.5 |  |  |  |  |  |  | 276
14 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 270
15 |  |  | 7 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 257
16 |  |  | 6 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 257.5
 |  |  |  |  | *3 bonus pts possible |  |  |  |  |  |  |  |  |  |  | 1st
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd
 |  | total |  |  |  |  |  |  |  |  |  |  |  |  |  | 3rd
2012-02-04 00:00:00
Spreadsheet: 473089d1470045196-vlookup-partial-text-example
Sheet: Student list

five digit ref |  | Age as 1/9/16 | Student Ref. | Forenames | Surname | Gender | Nationality
 |  |  | CEG08025912 | [NAME] | Smith | Male | Chinese | 2010-01-01 00:00:00
 |  |  | CEG08024611 | [NAME] | Jones | Male | Azeri | 2010-01-02 00:00:00
 |  |  | CEG08025628 | [NAME] | Titch | Male | Chinese | 2010-01-03 00:00:00
Spreadsheet: 141823d1329474020-create-folder-path-from-tree-structure-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | path | folder name
 |  |  | folder
 |  |  |  | one
 |  |  |  | two
 |  |  |  |  | mac
 |  |  |  |  | pc
 |  |  |  |  |  | components
 |  |  |  |  |  |  | cpu
 |  |  |  |  |  |  |  | and
 |  |  |  |  |  |  |  | intel
 |  |  |  |  |  |  |  |  | i7
 |  |  |  |  |  |  |  |  |  | extreme
 |  |  |  |  |  |  |  |  | i5
 |  |  |  |  |  |  | gfx
 |  |  |  |  |  |  |  | Other
 |  |  |  |  |  |  |  | AMD-ATI
 |  |  |  |  |  |  |  | Nvidia
 |  |  |  |  |  |  |  |  | Quatro
 |  |  |  |  |  |  |  |  |  | x450
 |  |  |  |  |  |  |  |  | NAME
 |  |  |  |  |  |  |  |  |  | supplier
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Example
 |  |  |  |  |  |  |  |  |  |  |  | Data
 |  |  |  |  |  |  |  |  |  |  |  |  | FolderName
Spreadsheet: 677805d1589535075-trying-to-use-an-if-function-to-categorize-employee-schedules-based-on-optimization-groups-schedules
Sheet: Schedule Data

Date | Agent | [NAME] | Start Time | End Time | Type
2020-05-11 00:00:00 | Employee A | Lunch | 11:15:00 | 11:45:00 | LBB
2020-05-11 00:00:00 | Employee A | Break 1 | 13:30:00 | 13:45:00 | LBB
2020-05-11 00:00:00 | Employee A | Break 2 | 15:45:00 | 16:00:00 | LBB
2020-05-11 00:00:00 | Employee B | Break 1 | 12:00:00 | 12:15:00 | BBL
2020-05-11 00:00:00 | Employee B | Break 2 | 13:45:00 | 14:00:00 | BBL
2020-05-11 00:00:00 | Employee B | Lunch | 15:15:00 | 15:45:00 | BBL
2020-05-11 00:00:00 | Employee C | Lunch | 11:15:00 | 11:45:00 | LBB
2020-05-11 00:00:00 | Employee C | Break 1 | 13:30:00 | 13:45:00 | LBB
2020-05-11 00:00:00 | Employee C | Break 2 | 15:45:00 | 16:00:00 | LBB
2020-05-11 00:00:00 | Employee D | Break 1 | 12:00:00 | 12:15:00 | BBL
2020-05-11 00:00:00 | Employee D | Break 2 | 13:45:00 | 14:00:00 | BBL
2020-05-11 00:00:00 | Employee D | Lunch | 15:15:00 | 15:45:00 | BBL
2020-05-11 00:00:00 | Employee E | Lunch | 12:15:00 | 12:45:00 | LBB
2020-05-11 00:00:00 | Employee E | Break 1 | 14:30:00 | 14:45:00 | LBB
2020-05-11 00:00:00 | Employee E | Break 2 | 16:45:00 | 17:00:00 | LBB
2020-05-11 00:00:00 | Employee F | Lunch | 12:15:00 | 12:45:00 | LBB
2020-05-11 00:00:00 | Employee F | Break 1 | 14:30:00 | 14:45:00 | LBB
2020-05-11 00:00:00 | Employee F | Break 2 | 16:45:00 | 17:00:00 | LBB
2020-05-11 00:00:00 | Employee G | Break 1 | 11:00:00 | 11:15:00 | BLB
2020-05-11 00:00:00 | Employee G | Lunch | 13:00:00 | 13:30:00 | BLB
2020-05-11 00:00:00 | Employee G | Break 2 | 15:15:00 | 15:30:00 | BLB
2020-05-11 00:00:00 | Employee H | Break 1 | 11:00:00 | 11:15:00 | BLB
2020-05-11 00:00:00 | Employee H | Lunch | 13:00:00 | 13:30:00 | BLB
2020-05-11 00:00:00 | Employee H | Break 2 | 15:15:00 | 15:30:00 | BLB
2020-05-11 00:00:00 | Employee I | Break 1 | 10:45:00 | 11:00:00 | BBL
2020-05-11 00:00:00 | Employee I | Break 2 | 12:30:00 | 12:45:00 | BBL
2020-05-11 00:00:00 | Employee I | Lunch | 14:15:00 | 14:45:00 | BBL
Spreadsheet: 752508d1634810927-partial-text-frequency-counting-in-reports-forum-sample-adenoma3
Sheet: Sheet1

number | Report | Amount of adenomas | Amount of no adenomas |  |  |  | adenoma | no adenoma
1 | Colonoscopy: biopsy performed 50 cm from anus. No polyp or adenoma. Tubulovillieus adenoma in biopsy 2. Biopsy 3 hyperplastic polyp. No adenoma.
2 | Fragemented hyperplastic polyp. No adenoma.
3 | Villieus adenoma in 1. No polyp. Biopsy 2 no polyp or adenoma. Biopsy 3 no adenoma or polyp
4 | I:  Tubular adenoma low grade dysplasia  II: biopsy 75 cm from anus: tubular adenoma low grade dysplasia III:  Tubular adenoma low grade dysplasia  IV:  Tubular adenoma low grade dysplasia  V: biopsy 60 cm from anus. No polyp or adenoma. VI: biopsy 50 cm from anus. hyperplastic polyp no adenoma.
5 | sessile laesion. 50 cm from anus
6 | [NAME] from anus. Adenocarcinoma, no other polyps
7 | I:  Tubular adenoma low grade dysplasia  II: no polyp or adenoma III:  adenoma undefined IV: hyper plastic polyp, no adenoma
8 | tubulovillieus adenoma in 1. Hyperplastic polyp in 2, no adenoma. No polyp or adenoma in 4.
9 | Infectious activity in 1
10 | I:  [NAME] biopsy coecum: tubulovillieus adenoma with low grade dysplasia. II: Polypectomy: tubular adenoma low [NAME]. Diamiter polyp 0,5 cm  III: Polypectomy 80 cm from anus. Tubulovilieus adenoma low [NAME]; diameter polyp 1,5cm. IV:  [NAME] membrane: No abnormalities (no polyp or adenoma)
Spreadsheet: sally_beck__33697__Metrics 0609
Sheet: Energy Capital Res.

E N R O N   N O R T H   A M E R I C A - H O T  L I S T  M E T R I C S |  |  |  |  |  |  |  |  |  |  |  |  | Team: | Energy Capital Resources
Results based on Activity through June 9, 2000 |  |  |  |  |  |  |  |  |  |  |  |  | Week | 10
 |  | Weekly Summary - 2Q00 through 1Q01
 |  | # of Transactions
 |  | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13
 |  | 2000-04-07 00:00:00 | 2000-04-14 00:00:00 | 2000-04-21 00:00:00 | 2000-04-28 00:00:00 | 2000-05-05 00:00:00 | 2000-05-12 00:00:00 | 2000-05-19 00:00:00 | 2000-05-26 00:00:00 | 2000-06-02 00:00:00 | 2000-06-09 00:00:00 | 2000-06-16 00:00:00 | 2000-06-23 00:00:00 | 2000-06-30 00:00:00
Postings Rollforward:
Beginning |  | 0
+ Entrances |  | 0 | 11 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0
- Exits |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0
- Executions |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Ending
 | Dollar Value of Transactions
 | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 |  | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Average
Postings Rollforward:
Beginning |  | 100.5
+ Entrances |  | 0 | 14.3 | 1
- Exits |  | 0 | 0 | 0
+/- [NAME] |  | 0 | 0 | -13
- Executions |  | 0 | 0 | 0
Ending
Average Deal Size
 |  |  |  |  |  |  |  | Forward Quarters
 | Actual |  |  | Current Quarter |  | Per |  |  |  |  |  |  |  | Total Year
 | 1Q00 |  |  | 2Q00 |  | Hot List |  | 3Q00 |  |  | 4Q00 |  |  | 2000 |  |  | 1Q01
 | # | $ |  | # | $ |  |  | # | $ |  | # | $ |  | # | $ |  | # | $
Executions | 1 | 0.1 |  | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 |  |  |  |  | 0 | 0
DPR/MPR |  | 0.8 |  |  | 2.861 |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 0
Postings | 0 | 0 |  | 1 | 0 |  |  | 5 | 0 |  | 6 | 0 |  |  |  |  | 0 | 0
Identified Margin
Budget |  | 10.3 |  |  | 2 |  |  |  | 5 |  |  | 8
$ Coverage
$ millions
Spreadsheet: 783e3f04-0afe-405c-a351-ec7d00101b9d
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
40880587 | 2014-04-07 04:36:53 | AXIS | 1 | 6 | 4 | 1546205 | player1546205 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
40880862 | 2014-04-07 04:56:33 | ALLIES | 0 | 3 | 6 | 1546205 | player1546205 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 890037d1741170779-4-names-in-one-row-split-into-one-row-for-each-name-split-into-firstname-and-surname-sample
Sheet: ABC LDM Name Splitter

UPRN | Address 1 | Address 2 | Address 3 | Address 4 | Address 5 | Postcode | Person 1 | Person 1 Email | Person 2 | Person 2 Email | Count Names | Cumulative | UPRN | Address 1 | Address 2 | Address 3 | Address 4 | Postcode | Name | First Name | Middle Name | Surname | [NAME]
125055638 | 102 | 7 East Princes Street | Rothesay | Bute |  | PA20 9DL | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Title List
125000629 | 23 Glenview | Dalmally |  |  |  | PA33 1BE | Mr [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr
125056324 | G02 . | 12 The Terrace | Ardbeg Road  Rothesay | Bute |  | PA20 0NP | Mr [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mrs
125089289 | 2 Eton Avenue | [NAME] |  |  |  | PA23 8DG | Miss [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Miss
125001257 | 7 . | 1 Park Lane | [NAME] |  |  | G84 7NT | Mr [NAME] |  | [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  | Master
125014105 | 202 | 5 Kirk Street | Campbeltown |  |  | PA28 6BL | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mstr
125027228 | 3 Chamberlains House | Front Street | Inveraray |  |  | PA32 8UY | Mr [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dr
125021377 | 10E Longsdale Terrace | Oban |  |  |  | PA34 5JS | Mr [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rev
125030032 | 12 Rosedale Gardens | East Princes Street | [NAME] |  |  | G84 7RW | Ms Fiona C Gillies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lord
125019363 | Flat 2  Dalintober House | North Shore Street | Campbeltown |  |  | PA28 6EH | Miss [NAME] | [EMAIL] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ms
125024454 | 32 [NAME] | [NAME] |  |  |  | PA23 8NR | Mr [NAME] | [EMAIL]
125023901 | 16 Keil Court | Hanover Street | [NAME] |  |  | G84 7AW | Eilidh O [NAME]
125042896 | 49 [NAME] | [NAME]'s Quay | [NAME] |  |  | PA23 8LB | Mr [NAME] | [EMAIL] | [NAME] | [EMAIL]
125021185 | Buckhyne | 5 Shore Road | Carradale | Campbeltown |  | PA28 6SH | Miss [NAME] | [EMAIL] | [NAME]
125056404 | 1 [NAME] (1st Floor) | Kilchattan Bay | Rothesay | Bute |  | PA20 9NW | [NAME] | [EMAIL] | Mr [NAME]
125008313 | Flat 1/1 | 33 East Princes Street | Rothesay | Bute |  | PA20 9DN | Mr [NAME] | [EMAIL] | Mrs Gayle I J Madden
125071406 | Lime Kiln Cottage | Isle Of Gigha |  |  |  | PA41 7AD | Mrs Jean F M Brownie | [EMAIL] | Mr [NAME] Brownie | [EMAIL]
125052790 | 4 Woodside | Isle Of Gigha |  |  |  | PA41 7AD | [NAME] | [EMAIL]
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: first feb

2011-02-11 00:00:00
0 |  | yes | Amount | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income Tax Income | MiscellaneousNon- Taxable | Owner Loan
Received From | Check No | Invoices Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: andy_zipper__178__DYNEGY-ICE VOL Apr27
Sheet: ICE-EPM

Enron Power Marketing
Activity on ICE
UOM | Deals | Volume
MWhs
 |  |  |  |  |  |  | START | END
Enron Power Marketing, Inc.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-27-01 thru Apr-27-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-27-01 | 8856296038 |  | Bought | Firm-LD Peak | Cin | Next Day | Apr-30-01 | Apr-30-01 |  |  |  | Duke Energy Trading and Marketing LLC | 68 | USD / MWh | 50 | Hourly | 800 | MWhs | Dorland , C
Apr-27-01 | 155027260 |  | Sold | Firm-LD Peak | TVA | Next Day | Apr-30-01 | Apr-30-01 |  |  |  | Morgan Stanley Capital Group, Inc. | 62 | USD / MWh | 50 | Hourly | 800 | MWhs | Carson , M
Apr-27-01 | 148065964 |  | Sold | Firm-LD Peak | Cin | Jul01-Aug01 | Jul-01-01 | Aug-31-01 |  |  |  | American Electric Power Service Corp. | 122 | USD / MWh | 50 | Hourly | 35200 | MWhs | [NAME], R
Apr-27-01 | 174815088 |  | Bought | Firm-LD Peak | Cin | Bal Week | May-01-01 | May-04-01 |  |  |  | Duke Energy Trading and Marketing LLC | 77.5 | USD / MWh | 50 | Hourly | 3200 | MWhs | Dorland , C
Apr-27-01 | 145787990 |  | Sold | Firm-LD Off-Peak | SP-15 Off-Peak | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Duke Energy Trading and Marketing LLC | 152 | USD / MWh | 25 | Hourly | 8200 | MWhs | Richter, J
Apr-27-01 | 184593416 |  | Sold | Firm-LD Peak | Comed | Bal Week | May-01-01 | May-04-01 |  |  |  | Morgan Stanley Capital Group, Inc. | 67 | USD / MWh | 50 | Hourly | 3200 | MWhs | Dorland , C
Apr-27-01 | 786904348 |  | Bought | Firm-LD Off-Peak | Mid C Off-Peak | 2001-06-01 00:00:00 | Jun-01-01 | Jun-30-01 |  |  |  | Morgan Stanley Capital Group, Inc. | 255 | USD / MWh | 25 | Hourly | 7600 | MWhs | Richter, J
Apr-27-01  Deals