tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__18185__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-02-27 00:00:00 |  | 171 | 64 | 113.75 | 1600
 | 2001-02-26 00:00:00 |  | 177.86 | 224 | 133.56 | 1392 | 157.54 | 2280 | 111.96 | 1798
 | 2001-02-25 00:00:00 |  | 147.5 | 0 | 135 | 280 | 131.22 | 2999 | 108.91 | 2383
 | 2001-02-24 00:00:00 |  | 174.29 | 224 | 115.26 | 1560 | 148.66 | 1535 | 132.09 | 1146
 | 2001-02-23 00:00:00 |  | 174.29 | 224 | 115.54 | 1480 | 166.64 | 2128 | 118.23 | 893
 | 2001-02-22 00:00:00 |  | 201.14 | 224 | 118.5 | 1312 | 160.02 | 656 | 90.98 | 787
 | 2001-02-21 00:00:00 |  | 210 | 224 | 148.86 | 560 | 161.32 | 1192 | 89.98 | 1296
 | 2001-02-20 00:00:00 |  | 232.14 | 224 | 137.14 | 112 | 130.89 | 1348 | 114.12 | 758
 | 2001-02-19 00:00:00 |  | 232.14 | 224 | 145 | 160 | 156.82 | 1839 | 154.53 | 1668
 | 2001-02-18 00:00:00 |  | 287.5 | 320 | 240.5 | 0 | 197.15 | 771 | 166.45 | 1129
 | 2001-02-17 00:00:00 |  | 282.14 | 224 | 221.43 | 112 | 230.67 | 1640 | 205.12 | 1180
 | 2001-02-16 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 251.75 | 3017 | 181.8 | 1576
 | 2001-02-15 00:00:00 |  | 387.5 | 384 | 198.75 | 192 | 391.66 | 5037 | 207.21 | 1058
 | 2001-02-14 00:00:00 |  | 275.24 | 1312 | 150.92 | 392 | 304.68 | 695 | 197.1 | 1165
 | 2001-02-13 00:00:00 |  | 185 | 160 | 151.57 | 1400 | 194.42 | 1165 | 136.79 | 587
 | 2001-02-12 00:00:00 |  | 207.14 | 560 | 138.91 | 880 | 140.84 | 1676 | 158.45 | 785
 | 2001-02-11 00:00:00 |  | 150 | 160 | 140 | 600 | 141.19 | 3174 | 132.09 | 2803
 | 2001-02-10 00:00:00 |  | 153.75 | 320 | 115.46 | 1720 | 150.05 | 2068 | 161.43 | 828
 | 2001-02-09 00:00:00 |  | 153.75 | 320 | 116.25 | 1760 | 168.64 | 1070 | 117.98 | 945
 | 2001-02-08 00:00:00 |  | 176.25 | 960 | 148.1 | 2000 | 174.99 | 844 | 91.4 | 1905
 | 2001-02-07 00:00:00 |  | 169.28 | 4224 | 131.32 | 3628 | 190.46 | 1300 | 95.76 | 1283
 | 2001-02-06 00:00:00 |  | 149.44 | 720 | 146.14 | 1400 | 153.56 | 520 | 88.67 | 917
 | 2001-02-05 00:00:00 |  | 160.19 | 1864 | 143.63 | 1772 | 142.39 | 1579 | 82.26 | 1310
 | 2001-02-04 00:00:00 |  | 150 | 0 | 146.67 | 1200 | 94.46 | 2705 | 81.4 | 2734
 | 2001-02-03 00:00:00 |  | 165 | 0 | 152.1 | 2000 | 127.82 | 6039 | 83.63 | 2119
 | 2001-02-02 00:00:00 |  | 160 | 320 | 148.88 | 1600 | 145.26 | 2069 | 111.08 | 2227
 | 2001-02-01 00:00:00 |  | 231.82 | 176 | 161.58 | 696 | 171.56 | 2512 | 111.53 | 1611
 | 2001-01-31 00:00:00 |  | 250 | 64 | 145 | 32 | 196.22 | 2670 | 133.68 | 1348
 | 2001-01-30 00:00:00 |  | 200.83 | 384 | 142.84 | 592 | 205.28 | 1618 | 135.46 | 1365
 | 2001-01-29 00:00:00 |  | 232.86 | 224 | 197.1 | 1000 | 188.91 | 2740 | 130.63 | 1506
 | 2001-01-28 00:00:00 |  | 200 | 320 | 175 | 0 | 178.38 | 3068 | 130.84 | 1999
Spreadsheet: 856768d1705945771-multiple-criteria-data-validation-multiple-data-validation-etaf
Sheet: Sheet1

 |  |  | Firm | Firm A | Firm B | Firm C | Firm D | Firm A | Firm B | Firm C | Firm A | Firm B | Firm A
 |  |  | Fund | Fund 1 | Fund 1 | Fund 1 | Fund 1 | Fund 2 | Fund 2 | Fund 2 | Fund 3 | Fund 3 | Fund 4
 |  |  | ID | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Choose Firm | Firm A
Choose Fund | Fund 3
ID | 8
 | I have 3 rows of information and I want to be able to select a firm in B4 and a fund in B5 that then outputs an ID in B6.
Spreadsheet: 162806d1340085530-index-match-large-based-on-a-criteria-index_large_match_help-with-criteria
Sheet: Sheet1

 |  |  |  |  |  |  |  | Only IF A = RED  --   Index / Large / Match   formula to show the largest price effect.
Raw Data
Model | Part # | Price Effect | Mix Effect | Prev Month Price | Curr Month Price
Red | ABC | 5 | 20 | 80 | 90
Red | DEF | 6 | 21 | 81 | 91 |  |  |  | Desired Results in yellow below
Yellow | GHI | 7 | 22 | 82 | 92
Blue | JKL | 8 | 23 | 83 | 93 |  |  |  | TOP 3 Largest Price Effects -  Model:  RED
Red | MNO | 9 | 24 | 84 | 94 |  |  |  | # | Model | Price Effect | Part Number | Curr Month Price
Red | PQR | 10 | 25 | 85 | 95 |  |  |  | 1 | Red
Red | STU | 11 | 26 | 86 | 96 |  |  |  | 2 | Red
Red | VWX | 12 | 27 | 87 | 97 |  |  |  | 3 | Red
Blue | ABC | 13 | 28 | 88 | 98
 |  |  |  |  |  |  |  | Only IF A = Blue --   Index / Large / Match   formula to show the largest price effect.
 |  |  |  |  |  |  |  |  | Desired Results in yellow below
 |  |  |  |  |  |  |  |  | TOP 3 Largest Price Effects -  Model:  Blue
 |  |  |  |  |  |  |  |  | # | Model | Price Effect | Part Number | Curr Month Price
 |  |  |  |  |  |  |  |  | 1 | Blue
 |  |  |  |  |  |  |  |  | 2 | Blue
Spreadsheet: 108762d1305744146-excel-2007-trying-to-count-number-late-early-for-appoitment-latecheck-test
Sheet: Sheet1

Check-In Time | Appoint Time | Visit Type | (Difference) |  | Visit Type | Buffer (minutes) | # Late
07:34:00 | 07:30:00 | 1 | 4 minutes late |  | 1 | 10 | 0
07:39:00 | 07:30:00 | 3 | 9 minutes late |  | 2 | 10 | 0
07:40:00 | 09:30:00 | 2 | 1100 minutes early |  | 3 | 10 | 0
08:13:00 | 08:15:00 | 2 | 20 minutes early
08:39:00 | 08:45:00 | 1 | 60 minutes early
08:55:00 | 09:15:00 | 2 | 200 minutes early
09:46:00 | 10:00:00 | 3 | 140 minutes early
10:31:00 | 10:45:00 | 3 | 140 minutes early
Spreadsheet: chris_germany__2915__12 1999 GELP OIL BY VENDOR
Sheet: Monthly Summary

 | 1999-12-01 00:00:00 | SUMMARY OF FUEL OIL DELIVERIES TO GORDONSVILLE
 | COMMENTS | Plant Recorded Off-Load Meter Reading |  | BP AMOCO "GROSS" DELIVERED | MARATHON ASHLAND "GROSS" DELIVERED | CITGO    "GROSS" DELIVERED
 | Current Month Ordered |  |  | 0 | 150000 | 187500
 | Current Month Delivery
 | ESTIMATED Gallons still unaccounted for… | 0 | 0
 | MONTH BEGINNING TANK INVENTORY | 4360000 | (AS STRAPPED BY PLANT… 12/14)
 | MONTH BEGINNING TANK INVENTORY | 4365000 | (AS REPORTED BY PLANT CONTROL ROOM)
 | PLANT RECORDED OFFLOAD TOTAL
 | ALL SUPPLIERS "GROSS" DELIVERY RECORD
 | TOTAL DIFFERENCE, Current month
Note: |  |  | ESTIMATED COST SUMMARY (based on BOL, not invoice)
 |  |  |  | "Gross" Gallons Delivered
 |  |  |  | [NAME]. Cost per gallon | 0
 |  |  |  | Estimated Cost of Oil for Month
Spreadsheet: 844736d1696436454-sum-spilled-array-sum-spilled-array
Sheet: Sheet1

 | 0 | 31 | 61 | 91 | 121 | 151 | 181 | 271 | 366 |  | < | <=
 | 0-30 | 031-60 | 061-90 | 091-120 | 121-150 | 151-180 | 181-270 | 271-365 | 366+ | Grand Total | 90 | 150
Level 1 | 0.9493547894929522 | 0.904783085731298 | 0.9655487161544682 | 0.6861963582878359 | 0.6961931991833352 | 0.2922003341515982 | 0.6556856414431802 | 0.6033548769741919 | 0.4350869493232514
Level 2 | 0.851858181620123 | 0.7220656043074298 | 0.2917728208923938 | 0.7015574181591908 | 0.5690542414651676 | 0.321483054192701 | 0.597426229003517 | 0.1673272183147085 | 0.3850874392344508
Level 3 | 0.8767090543738556 | 0.02040150656256112 | 0.9495993108657994 | 0.9774388093474402 | 0.1713337040688552 | 0.1042579629135236 | 0.6988723266072905 | 0.2955112617562148 | 0.7915259750591506
Spreadsheet: 833162d1686821082-lookup-previous-month-mileage-from-table-sample35
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Current Date
 |  |  |  |  |  |  |  |  |  | Month | 03 | 04 | 05 | 06 |  | Truck # | Previous Month
 |  |  |  |  |  |  |  |  |  | Jan | 10000 | 9000 | 25000 | 10000 |  | 03
 |  |  |  |  |  |  |  |  |  | Feb | 11000 | 10000 | 27000 | 15000 |  | 04
 |  |  |  |  |  |  |  |  |  | Mar | 12000 | 12000 | 29000 | 16000 |  | 05
 |  |  |  |  |  |  |  |  |  | Apr | 13000 | 15000 | 31000 | 17000 |  | 06
 |  |  |  |  |  |  |  |  |  | May | 15000 | 17000 | 33000 | 18000
 |  |  |  |  |  |  |  |  |  | Jun | 16000 | 19000 | 35000 | 22000
 |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  | Dec
Spreadsheet: 374152d1422689887-updating-average-function-not-pivot-table-average-update-1-
Sheet: Sheet1

 | Patients visits to health Centers
 |  |  | Children |  | Pregnant |  | Adults
 |  |  | Total |  | Total |  | Total
 | 2015-01-01 00:00:00 |  | * |  | * |  | * |  | Average Patients visits per day ?
 | 2015-01-02 00:00:00 |  | * |  | * |  | * |  | Average would be daily updated according
 | 2015-01-03 00:00:00 |  | * |  | * |  | * |  | to daily new data entry
 | 2015-01-04 00:00:00 |  | 28 |  | 14 |  | 9
 | 2015-01-05 00:00:00 |  | 12 |  | 12 |  | 8
 | 2015-01-06 00:00:00 |  | 22 |  | 1 |  | 2
 | 2015-01-07 00:00:00 |  | * |  | * |  | *
 | 2015-01-08 00:00:00 |  | 24 |  | 6 |  | 11
 | 2015-01-09 00:00:00
 | 2015-01-10 00:00:00 |  | 13 |  | 2 |  | 5
 | 2015-01-11 00:00:00 |  | 10 |  | 3 |  | 6
 | 2015-01-12 00:00:00 |  | 24 |  | 16 |  | 13
 | 2015-01-13 00:00:00 |  | 21 |  | 9 |  | 5
 | 2015-01-14 00:00:00 |  | 15 |  | 16 |  | 9
 | 2015-01-15 00:00:00 |  | 15 |  | 15 |  | 6
 | 2015-01-16 00:00:00
 | 2015-01-17 00:00:00 |  | 20 |  | 13 |  | 6
 | 2015-01-18 00:00:00 |  | 17 |  | 18 |  | 7
 | 2015-01-19 00:00:00 |  | 12 |  | 20 |  | 4
 | 2015-01-20 00:00:00 |  | 12 |  | 18 |  | 7
 | 2015-01-21 00:00:00 |  | 14 |  | 14 |  | 11
 | 2015-01-22 00:00:00 |  | 17 |  | 15 |  | 8
 | 2015-01-23 00:00:00
 | 2015-01-24 00:00:00 |  | 16 |  | 22 |  | 7
 | 2015-01-25 00:00:00 |  | 16 |  | 20 |  | 9
 | 2015-01-26 00:00:00
 | 2015-01-27 00:00:00
 | 2015-01-28 00:00:00
 | 2015-01-29 00:00:00
 | 2015-01-30 00:00:00
 | 2015-01-31 00:00:00
 | Total
 |  | Mon
 |  | Tue
 |  | Wed
 |  | Thu
 |  | Fri
 |  | Sat
 |  | Sun
Spreadsheet: 868617d1715300717-fishing-club-sheet-formula-help-index-broe-comp-sheet-chads-new-edit
Sheet: Results

Sussex Inlet Bowling Club Fishing Club B.R.O.E.  2023
 |  | Winner |  |  | [NAME] Up |  |  |  |  | [NAME] |  |  | PRESS"F9"  Once to Calculate Results!
 |  | Heaviest | Angler # |  | Second | Angler # |  | Mystery Weight | Difference | Closest Weight | Angler #
SATURDAY | BREAM
 | DRUMMER
 | DUSKY |  |  |  |  |  |  |  |  |  |  |  | Mystery Prize Winner
 | FLATHEAD
 | LEATHERJACKET
 | LUDRICK |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | MORWONG |  |  |  |  |  |  |  |  |  |  |  |  | Weight ([NAME])
 | SALMON |  |  |  |  |  |  |  |  |  |  |  |  | Angler #
 | SNAPPER
 | TAILOR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Up
 |  | Winner |  |  | [NAME] Up |  |  |  |  | [NAME] |  |  |  | Weight ([NAME])
 |  | Heaviest | Angler # |  | Second | Angler # |  | Mystery Weight | Difference | Closest Weight | Angler # |  |  | Angler #
SUNDAY | BREAM
 | DRUMMER
 | DUSKY
 | FLATHEAD |  |  |  |  |  |  |  |  |  |  |  |  | General [NAME]
 | LEATHERJACKET |  |  |  |  |  |  |  |  |  |  |  |  | Total Fish Weighed In (Kg)
 | LUDRICK |  |  |  |  |  |  |  |  |  |  |  |  | Total # of Fish
 | MORWONG
 | SALMON
 | SNAPPER
 | TAILOR
Spreadsheet: 55623d1255714286-telling-excel-a-cell-equals-another-cell-on-a-worksheet-hprp-assessment-final-sample
Sheet: STAFF - CLIENT EVALUATION

Homelessness Prevention and Rapid Re-Housing Program
APPLICANT INFORMATION
Intake Date: | 2009-10-25 00:00:00 |  |  |  | # in Household: | 0
Household Information
Last Name: | Doe |  | M. Initial: | M | First Name: | 0
Last Name: | 0 |  | M. Initial: | 0 | First Name: | 0
Home Phone: | [PHONE] |  |  | Cell [NAME]): | 0
Work [NAME]): | [PHONE] |  |  | [NAME]): | 0
Present Address
Residence Address: | 1234 Main St, Providence, RI 5555
Mailing Address: | Same as above
HPRP CLIENT EVALUATION
Services Recommended for Client
[NAME] recommended to receive the following services:
Service |  |  | Time Period |  | Provider | Notes
Case Management
Housing Relocation
Landlord/Tenant Education
Financial Counseling
Legal Services
Financial Assistance
Staff Referrals
Households referred to the following agencies or services:
Service |  |  | Agency |  | Notes
Financial [NAME]
Item | Subsidy Amount |  | Actual Cost |  | Subsidy Type | Time Period
Staff Notes:
Staff Approval:
HPRP Staff:________________________________ |  |  | Date: _______________ |  | Agency: ____________________________
Spreadsheet: 542474d1507882694-extracting-rows-based-on-user-input-example-13-
Sheet: Output By Location

Source | [NAME] | A | B | C | D | E | F | G | H | Area | Customer Segment | Customer Segment | Value 1 | Loading | Value 2 | Value 3 | Value 4 | Value 5 | Value 6 | Value 7 | Value 8 | Value 9 | Value 10 | Value 11
Spreadsheet: 834274d1687592919-find-and-replace-ref-in-formula-excel-sample
Sheet: Sheet1

SALE-INV-NO | KAPAN | DATE | PARTY NAME | DAYS | DUE DATE | DUE DAY | BILL/WO | RECEIVABLE $ | RECEIVABLE RS | USD RECEIVED | RS RECEIVED | USD DIFF | RS DIFF | DATE RECD | YES/NO
0 |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0
Spreadsheet: 160779d1339187877-bucket-filling-based-on-range-of-values-book1
Sheet: Sheet1

 |  |  |  | Cell | Value | Excess | 10000000 | 10000 | 5000 |  | Check
Ranges | Min | [NAME] |  | L1 | 1000 | 0 | 0 | 0 | 1000 |  | 1000 | 1
A | 0 | 5000 |  | L2 | 50001 | 0 | 40001 | 5000 | 5000 |  | 50001 | 1
B | 5000 | 10000 |  | L3 | 100000 | 0 | 90000 | 5000 | 5000 |  | 100000 | 1
C | 10000 | 10000000 |  | [NAME]
 |  |  |  | L5
 |  |  |  | L6
L1 is Range A |  |  |  | L7
L2 is Range A for 4000 |  |  |  | L8
L2 is Range B for 1000 |  |  |  | L9
L3 is Range B for 4000
L3 is Range C for 2000
Spreadsheet: 818917d1677127159-how-can-some-number-of-data-be-repeated-again-and-again-keeping-their-order-how-can-some-number-of-data-be-repeated-again-and-again-keeping-their-order
Sheet: Sheet1

Variable Group of Set | Id No. |  | Desired output |  |  | Sets | =Sheet1!$A$2:INDEX(Sheet1!$A:$A,MATCH("zzzzz",Sheet1!$A:$A))
Set-1 | 123456 |  | Set-1
Set-3 | 123457 |  | Set-3
Set-5 | 123458 |  | Set-5
Set-7 | 123459 |  | Set-7
Set-9 | 123460 |  | Set-9
Set-11 | 123461 |  | Set-11
Set-13 | 123462 |  | Set-13
 | 123463 |  | Set-1
 | 123464 |  | Set-3
 | 123465 |  | Set-5
 | 123466 |  | Set-7
 | 123467 |  | Set-9
 | 123468 |  | Set-11
 | 123469 |  | Set-13
 | 123470 |  | Set-1
 | 123471 |  | Set-3
 | 123472 |  | Set-5
 | 123473 |  | Set-7
 | 123474 |  | Set-9
 |  |  | Set-11
 |  |  | Set-13
 |  |  | Set-1
 |  |  | Set-3
 |  |  | Set-5
 |  |  | Set-7
 |  |  | Set-9
 |  |  | Set-11
 |  |  | Set-13
 |  |  | Set-1
 |  |  | Set-3
 |  |  | Set-5
 |  |  | Set-7
 |  |  | Set-9
 |  |  | Set-11
 |  |  | Set-13
 |  |  | Set-1
 |  |  | Set-3
 |  |  | Set-5
 |  |  | Set-7
 |  |  | Set-9
 |  |  | Set-11
 |  |  | Set-13
 |  |  | Set-1
 |  |  | Set-3
 |  |  | Set-5
 |  |  | Set-7
 |  |  | Set-9
 |  |  | Set-11
 |  |  | Set-13
 |  |  | Set-1
 |  |  | Set-3
 |  |  | Set-5
Spreadsheet: 819550d1677577509-sum-fields-based-on-month-data-to-analysis
Sheet: Analysis

Date | Near miss | Dangerous situation / action | Damage | Accident resulting In injury (no lost time) | Lost time accidents (3 days & under) | Lost time accidents (over 3 days but not RIDDOR) | RIDDOR (due to injury type) | RIDDOR (over 7 day absence)
2022-11-01 00:00:00
2022-12-01 00:00:00
2023-01-01 00:00:00
2023-02-01 00:00:00
2023-03-01 00:00:00
2023-04-01 00:00:00
2023-05-01 00:00:00
2023-06-01 00:00:00
2023-07-01 00:00:00
2023-08-01 00:00:00
2023-09-01 00:00:00
2023-10-01 00:00:00
2023-11-01 00:00:00
2023-12-01 00:00:00
YTD
Spreadsheet: 858582d1707216324-yesterday-this-week-last-week-previous-weeks-formula-sample-060224
Sheet: Sheet1

Event Logged Date | Latest Update | Expected Result
2024-02-01 00:00:00 |  | Today
2024-01-31 00:00:00 |  | Yesterday
2024-01-30 00:00:00 |  | This week
2024-01-29 00:00:00 |  | This week
2024-01-28 00:00:00 |  | This week
2024-01-27 00:00:00 |  | This week
2024-01-26 00:00:00 |  | This week
2024-01-25 00:00:00 |  | Last week
2024-01-24 00:00:00 |  | Last week
2024-01-23 00:00:00 |  | Last week
2024-01-22 00:00:00 |  | Last week
2024-01-21 00:00:00 |  | Last week
2024-01-20 00:00:00 |  | Last week
2024-01-19 00:00:00 |  | Last week
2024-01-18 00:00:00 |  | Previous week
2024-01-17 00:00:00 |  | Previous week
2024-01-16 00:00:00 |  | Previous week
2024-01-15 00:00:00 |  | Previous week
2024-01-14 00:00:00 |  | Previous week
2024-01-13 00:00:00 |  | Previous week
2024-01-12 00:00:00 |  | Previous week
2024-01-11 00:00:00 |  | Previous week
2024-01-10 00:00:00 |  | Previous week
2024-01-09 00:00:00 |  | Previous week
2024-01-08 00:00:00 |  | Previous week
2024-01-07 00:00:00 |  | Previous week
2024-01-06 00:00:00 |  | Previous week
2024-01-05 00:00:00 |  | Previous week
2024-01-04 00:00:00 |  | Previous week
2024-01-03 00:00:00 |  | Previous week
2024-01-02 00:00:00 |  | Previous week
2024-01-01 00:00:00 |  | Previous week
Spreadsheet: 743655d1628663533-dependent-drop-down-lists-material-drop-downs-example-ans-1-
Sheet: Material_List

 |  |  |  |  |  |  |  |  | Helper | Helper | Helper
 |  |  | Material | Color | Brand | Cost | Roll Weight | Roll Unit | Material | Color | Brand
 |  |  | PETG | White | Zyltech | 19.95 | 1 | Kg
 |  |  | PETG | White | Zyltech | 84.95 | 5 | Kg
 |  |  | PETG | Gray | Zyltech | 84.95 | 5 | Kg
 |  |  | PLA | White | Zyltech | 14.95 | 1 | Kg
 |  |  | TPU | Black | Zyltech | 23.95 | 1 | Kg
 |  |  | TPU | Blue | Zyltech | 23.95 | 1 | Kg
 |  |  | PETG-ESD | Black | 3DXSTAT | 110 | 1 | Kg
 |  |  | [NAME] | Green | AnyCubic | 35 | 1 | Kg
 |  |  | [NAME] | Clear | AnyCubic | 34 | 1 | Kg
Spreadsheet: sally_beck__33873__EGM_MgmtSum-Q4-1214
Sheet: Expense Weekly Change

ENRON GLOBAL MARKETS
4TH QUARTER 2000 EXPENSES - WEEKLY CHANGE
 |  | Direct Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Liquids
Coal
Emissions
Weather
Global Risk Markets
Financial Trading
Transportation
Office of the Chairman
Subtotal
LNG
Middle East
Puerto Rico
Subtotal Commercial
Total
Group
Other Interest Related Charges
Total
 |  | Operating Expenses
Business Team |  | Forecast | Plan | [NAME] |  | [NAME]
Spreadsheet: 804514d1668110617-index-match-and-offset-statement
Sheet: PO

 |  | Invoice Number | Store | Location | Amount | P.O
10/03 | 10/03 | 990 | STORE | Anywhere, USA | 46.98 | 701826071-
10/03 | 10/03 | 991 | STORE | Anywhere, USA | 48.29 | 701826071-
10/03 | 10/03 | 992 | STORE | Anywhere, USA | 3.01 | 702121594-
10/03 | 10/03 | 993 | STORE | Anywhere, USA | 12.97 | 701950190-
10/03 | 10/03 | 994 | STORE | Anywhere, USA | 50.34 | 702057636-
Spreadsheet: 713579d1610813380-how-to-calculate-exeact-sum-and-using-formula-calculation-sum-and-
Sheet: Sheet1

 | % | Total | Count | Total Rent | Rent for CC | Sum() | Diff.
 | 0.2424242424242424 |  | 1
 | 0.2121212121212121 |  | 1
 | 0.1515151515151515 |  | 1
 | 0.0303030303030303 |  | 1
 | 0.0303030303030303 |  | 1
 | 0.1212121212121212 |  | 1
 | 0.1515151515151515 |  | 1
 | 0.06060606060606061 |  | 1
 |  |  | 1 Total | 123
 | 0.5 |  | 2
 | 0.5 |  | 2
 |  |  | 2 Total | 1001
 | 0.09523809523809523 |  | 3
 | 0.4761904761904762 |  | 3
 | 0.04761904761904762 |  | 3
 | 0.2380952380952381 |  | 3
 | 0.1428571428571428 |  | 3
 |  |  | 3 Total | 127
Spreadsheet: 719315d1613616694-possible-indirect-function-needed-or-any-feasible-method-indirect-match-other-sheets
Sheet: 48-000046679

Client ID | Client Name | Account | Name | Group Name | Invoice No | Description Total | Charge Type | Random | Random | Random | Random | Random | Random | Random | Random | Random | CCY | Invoice Charge
497987 | Example | 64597987000 | Example |  | 46579 | SK SubTotal |  |  |  |  |  |  |  |  |  |  | USD | 841099.38
497987 | Example | 0046-997897658 | Example |  | 467989 | Surcharge |  |  |  |  |  |  |  |  |  |  | USD | 5.87
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 3

 | November 15 | November 22 | November 29 | December 6 | December 13
Total Interest Rate* | 12193 | 16121 | 11858 | 19841 | 21362
Cleared** | 8282 | 11354 | 10325 | 14933 | 15309
Uncleared | 3911 | 4767 | 1533 | 4908 | 6053
Total Cross-Currency | 646 | 817 | 223 | 639 | 961
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 646 | 817 | 223 | 639 | 961
Total Credit | 7494 | 13918 | 4729 | 8103 | 4835
Cleared | 4300 | 6302 | 2918 | 5232 | 3266
Uncleared | 3194 | 7616 | 1811 | 2871 | 1569
Total FX | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 20333 | 30856 | 16810 | 28583 | 27158
Weekly total, swap ticket volumes by asset class and cleared status (number of new trades), all products, tenors, and participant types. For cleared swaps, this table reflects the creation of only one of the two swaps that results from the clearing process. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 1aa2ea47-02f2-4adf-8efa-70a47f91bafe
Sheet: Sheet1

City Officials Statements | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
For Quarter Ending 6/30/2010
(As of 8/4/2010)
Name | Title | Personal Benefits Reported | City Benefits Reported
Adams, Sam | Mayor | 1625
[NAME], [NAME] | At-will staff for Mayor [NAME]
Clarke, [NAME] | At-will staff for Mayor [NAME] | 66
Fish, [NAME] | Commissioner | 26 | 5000
Fritz, Amanda | Commissioner
Gonzales, Cevero | At-will staff for Mayor [NAME]
Griffin-Valade | City Auditor
Hanson, [NAME] | Portland Planning Commission Member
Jimenez, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | Director of Bureau of Fire, Rescue and Emergency Services
Lauer, [NAME] | At-will staff for Mayor [NAME]
Leonard, [NAME] | Commissioner
Lord II, Reese | At-will staff for Mayor [NAME]
Marriott, [NAME] | Director of Bureau of Environmental Services
[NAME], [NAME] | At-will staff for Mayor [NAME]
Neal, Clay | At-will staff for Mayor [NAME]
[NAME], Skip | At-will staff for Mayor [NAME]
Pellegrino, [NAME] | Director of Government Relations | 200
Ponder, [NAME] | At-will staff for Mayor [NAME]
Reese, [NAME] | Director of Bureau of Police | 55
Reece, [NAME] | At-will staff for Mayor [NAME]
[NAME], [NAME] | At-will staff for Mayor [NAME]
Ruiz, [NAME] | At-will staff for Mayor [NAME]
Saltzman, [NAME] | Commissioner
[NAME], [NAME] | Director of Bureau of Development Services
Schneider, Kimberly | At-will staff for Mayor [NAME] | 35
[NAME], [NAME] | At-will staff for Mayor [NAME] | 50 | Yes, No Values Provided
[NAME], [NAME] | At-will staff for Mayor [NAME]
Stringfield, Sierra | At-will staff for Mayor [NAME]
Uwagbae, Grace | At-will staff for Mayor [NAME]
Yocom, [NAME] | At-will staff for Mayor [NAME] | 22
Spreadsheet: 158319d1338174996-count-items-conditionally-countifsexample
Sheet: Sheet1

Num | Cust | FirstLetter
B200 | Cust1 | B
B201 | Cust2 | B
C202 | Cust3 | C |  | 1 | <<[NAME] function =COUNTIFS(B2:B7,"",C2:C7,"C")
C203 |  | C
A204 | Cust5 | A
A205 | Cust6 | A