tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 833943d1687353353-count-data-in-different-columns-hazards-raised-by2
Sheet: Sheet1

Shift | Name | [NAME] | Near Misses | Total Hazards or N/M raised |  |  | [NAME] | Near Misses | Total Hazards or N/M raised | People Raising Hazard or Near Misses
B | [NAME] | 6 | 1 |  |  | A
B | [NAME] | 3 | 1 |  |  | B
Eng | [NAME] | 3 |  |  |  | C
A | [NAME] | 1 |  |  |  | Eng
Eng | Pav |  | 1 |  |  | WE
Eng | [NAME] | 1
B | [NAME] | 3
A | [NAME] | 2 | 1 |  |  |  | =SUMIF(A2:A16,E2,C2:C16)
A | [NAME]
WE | [NAME] | 1
Eng | [NAME] | 3
A | [NAME]
B | [NAME] | 5
C | [NAME] | 4
B | Emma |  | 1
C | Jake
Spreadsheet: 166023d1341430079-collecting-dynamic-data-and-sorting-moving-it-tester-book
Sheet: Sheet1

 |  | low | high
 |  | 15 | 50
 |  |  |  |  |  |  | new data | new data 2
 |  | a | 23 |  |  |  | a | 23
 |  | b | 35 |  |  |  | b | 35
 |  | c | 46 |  |  |  | c | 46
 |  | d | 12
 |  | e | 85
 |  | f | 353
 |  | g | 46 |  |  |  | g | 46
 |  | h | 2
 |  | i | 813
 |  | j | 512
 |  | k | 22 |  |  |  | k | 22
 |  | l | 13
 |  | m | 46 |  |  |  | m | 46
 |  | n | 96
 |  | o | 968
 |  | p | 891
Spreadsheet: 758422d1638869361-nested-if-different-criteria-each-with-different-outcomes-excel-sample
Sheet: Sheet2

Product type | Flavour A | Flavour A | Flavour A | Flavour A | Flavour B | Flavour B | Flavour C | Flavour C | Expected outcome
A | [NAME] | [NAME] | [NAME] | [NAME]
A | Mint | Mint | Mint | Mint
A | Apple | Apple | Apple | Apple
A | Peach | Peach | Peach | Peach
A | Cream | Cream | Cream | Cream
A | Blueberry | Blueberry | Blueberry | Blueberry
A |  |  | [NAME] | [NAME]
A | 0 | Blueberry | Blueberry | Blueberry
A | # | Blueberry | Blueberry | Blueberry
A | #N/A | #N/A | #N/A | [NAME]
A | [NAME] | [NAME] | [NAME] | [NAME]
A | Mint | Mint | Mint | Mint
A | Apple | Apple | Apple | Apple
A | Peach | Peach | Peach | Peach
A | Cream | Cream | Cream | Cream
B |  |  |  |  | Blueberry | Blueberry
B
B |  |  |  |  | 0 | [NAME]
B |  |  |  |  | # | Mint
B |  |  |  |  | #N/A | #N/A
B |  |  |  |  | [NAME] | [NAME]
C |  |  |  |  |  |  | Mint | Mint
C |  |  |  |  |  |  | Apple | Apple
C |  |  |  |  |  |  | Peach | Peach
C |  |  |  |  |  |  | Cream | Cream
C |  |  |  |  |  |  | Blueberry | Blueberry
C |  |  |  |  |  |  | Apple | Apple
C |  |  |  |  |  |  | Mint | Mint
C |  |  |  |  |  |  | # | Mint
C |  |  |  |  |  |  | #N/A | #N/A
C |  |  |  |  |  |  | [NAME] | [NAME]
C |  |  |  |  |  |  | Mint | Mint
C |  |  |  |  |  |  | Apple | Apple
C |  |  |  |  |  |  | Peach | Peach
C |  |  |  |  |  |  | Cream | Cream
C |  |  |  |  |  |  | Blueberry | Blueberry
C |  |  |  |  |  |  |  | Apple
C |  |  |  |  |  |  | 0 | Peach
C |  |  |  |  |  |  | # | Cream
C |  |  |  |  |  |  | #N/A | Blueberry
Spreadsheet: 797724d1664099326-multiple-items-each-with-a-date-column-and-values-how-to-summarise-by-year-extracting-amounts-received-in-a-date-range
Sheet: Sheet1

List of dividends Recveived
Lenovo |  | IBM |  | GSK |  |  | Desired Output
2021-07-13 00:00:00 | 150 | 2021-03-01 00:00:00 | 100 | 2021-04-15 00:00:00 | 250 |  |  |  | IBM | GSK
2022-08-13 00:00:00 | 122 | 2021-06-01 00:00:00 | 100 | 2021-10-15 00:00:00 | 500 |  | 2021
2023-07-15 00:00:00 | 920 | 2021-09-01 00:00:00 | 100 | 2022-04-15 00:00:00 | 300 |  | 2022
 |  | 2021-12-01 00:00:00 | 100 | 2022-10-20 00:00:00 | 600 |  | 2023
 |  | 2022-03-01 00:00:00 | 110
 |  | 2022-06-01 00:00:00 | 110
 |  | 2022-09-01 00:00:00 | 110
 |  | 2022-12-01 00:00:00 | 110
Spreadsheet: c9f0cfa8-4529-408f-8ddf-446e95c1aae8
Sheet: Report

Unit | Unit Priority | Objective Name | Strategic Direction | Impact Type | Resource Id | Resource Name | Resource Type | Year 1 Cost | Year 1 Savings | Year 2 Cost | Year 2 Savings | Year 3 Cost | Year 3 Savings | Year 4 Cost | Year 4 Savings
Facilities | 1 | Establish a means for client event setup requests. | None | -- Pick One --
Facilities | 2 | Establish an ongoing means for customer feedback. | None | -- Pick One --
Facilities | 3 | Document established Facilities Operating Procedures. | None | -- Pick One --
Facilities | 4 | Identify and plan solutions for possible problems over transition period anticipated in July 2010 when current Facilities Supervisor retires. | None | -- Pick One --
Facilities | 5 | Explore options for addressing anticipated staffing and equipment needs. | None | -- Pick One -- | 2.3.r1 | Obtain additional part-time custodian. | OnGoing | 16800 | 3000 | 16800 | 300 | 16800 | 300 | 0 | 0
Facilities | 5 | Explore options for addressing anticipated staffing and equipment needs. | None | -- Pick One -- | 2.3.r2 | Monthly cell phone or stipend. | OneTime | 900 | 0 | 900 | 0 | 900 | 0 | 0 | 0
Facilities | 5 | Explore options for addressing anticipated staffing and equipment needs. | None | -- Pick One -- | 2.3.r3 | Obtain new courier [NAME]. | OneTime | 25000 | 1500 | 250 | 4500 | 250 | 2500 | 0 | 0
Spreadsheet: 218357d1362434358-finding-median-of-a-aggregated-prices-excel-example
Sheet: Sheet1

 | $101K to $150K | $151K to $200K | $201K to $250K | $251K to $300K | $301K to $350K | $351K to $400K | $401K to $450K | $451K to $500K | $501K to $550K | $551K to $600K | $601K to $650K | $651K to $700K | $701K to $750K | $751K to $800K | $801K to $850K | $851K to $900K | $901K to $950K | $951K to $1M | $1M to $1.05M | $1.05M to $1.1M | $1.1M to $1.15M | $1.15M to $1.2M
 | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total | Closings Total
 |  |  |  | 408 | 188 | 73 | 33 | 26 | 14 | 14 | 6 | 1 | 1 | 0 | 0 | 1 | 0 | 2 | 1 | 0 | 0 | 0
Spreadsheet: 714e4973-6678-45b4-8e18-d5546ce5da1e
Sheet: Rev 3429

 |  | REQUEST FOR SUPPLEMENTAL REVENUE
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT: |  |  | Finance
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2012-04-05 00:00:00 |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | REVENUE
 |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
AL |  | 3429 |  | 120000 |  | 590000 |  |  |  | 2608650 |  | I
AL |  | 3429 |  | 120000 |  | 485100 |  |  |  | 191404 |  | I
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
[NAME]:
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 706717d1606849108-totalling-consolidating-data-sumproduct-with-mult-and-add-glewis14-
Sheet: Total

 |  |  |  |  |  |  |  |  |  | E4US references | 6
 |  |  |  |  |  |  |  |  |  | Week references | 46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  | Stock (pcs) |  |  | SAFETY STOCK |  |  |  |  | 8 | 9
Material ID | New code | Material Description | Factory | Supplier | In transit | MIN | MAX | Comments | E4us | combined stock
68138572 | 68190271 | Big pack total |  |  |  | 5 | 13 |  | Demand
 |  |  |  |  |  |  |  |  | Production
 |  |  |  |  |  |  |  |  | Closing stock
 |  |  |  |  |  |  |  |  | Fwd Cover
68138555 | 68138552 | Small pack total |  |  |  | 0 | 0 |  | Demand
 |  |  |  |  |  |  |  |  | Production
 |  |  |  |  |  |  |  |  | Closing stock
 |  |  |  |  |  |  |  |  | Fwd Cover
 |  |  |  |  |  | Ignore these two columns for the purpose of totalling the data
Spreadsheet: 810259d1671637458-which-formula-in-excel-can-you-use-to-copy-a-value-from-a-first-cell-to-a-second-cell-if-example
Sheet: Blad1

Loose words | Automatic with formula |  | Fixed Terms
Santa |  |  | Santa's house
[NAME] |  |  | [NAME]
[NAME] |  |  | Tree
Nice lights |  |  | Candle in a house
Police |  |  | Animals | (residual category)
Dolphin |  |  | Lights
Cat from [NAME] |  |  | Police of Liverpool
Candle
Spreadsheet: 858657d1707263554-trying-to-calculate-tat-witha-formula-found-here-but-error-tat-test
Sheet: Sheet1

Topic | Received from [NAME] | Replied by 1st Level | Categories | Year | Month | Who worked the request | TAT | TAT/working h | [NAME] | End date1 | Startdate2 | End date2
 | 2024-02-06 04:36:03 | 2024-02-06 08:57:00 | no data | no data | no data | no data |  |  | 09:00:00 | 13:00:00 | 14:00:00 | 18:00:00
 | 2024-02-05 18:17:38 | 2024-02-06 09:04:00 | no data | no data | no data | no data
 | 2024-02-05 07:05:26 | 2024-02-05 12:14:00 | no data | no data | no data | no data
 | 2024-02-01 12:06:38 | 2024-02-05 12:21:00 | no data | no data | no data | no data
 | 2024-02-02 21:14:45 | 2024-02-02 22:10:00 | no data | no data | no data | no data
 | 2024-02-02 16:17:29 | 2024-02-05 13:48:00 | no data | no data | no data | no data
 | 2024-02-02 16:01:05 | 2024-02-02 16:21:00 | no data | no data | no data | no data
 | 2023-12-08 11:45:31 | 2024-02-02 18:09:00 | no data | no data | no data | no data
 | 2024-02-02 12:07:59 | 2024-02-05 14:26:00 | no data | no data | no data | no data
 | 2024-02-02 00:25:27 | 2024-02-02 11:00:00 | no data | no data | no data | no data
 | 2024-02-01 16:59:35 | 2024-02-05 15:51:00 | no data | no data | no data | no data
 | 2024-01-31 17:38:11 | 2024-02-01 16:56:00 | no data | no data | no data | no data
 | 2024-02-01 15:15:00 | 2024-02-01 15:15:00 | no data | no data | no data | no data
 | 2024-01-10 20:37:58 | 2024-02-02 16:11:00 | no data | no data | no data | no data
 | 2024-02-01 07:14:59 | 2024-02-02 13:40:00 | no data | no data | no data | no data
 | 2024-02-01 12:38:16 | 2024-02-01 13:19:24 | no data | no data | no data | no data
 | 2024-02-01 12:08:10 | 2024-02-01 15:44:26 | no data | no data | no data | no data
 | 2023-12-19 17:13:55 | 2024-02-05 16:55:00 | no data | no data | no data | no data
 | 2024-01-30 03:08:00 | 2024-02-01 17:03:00 | no data | no data | no data | no data
 | 2024-02-01 06:23:48 | 2024-02-01 13:11:00 | no data | no data | no data | no data
 | 2024-02-01 06:05:28 | 2024-02-01 13:03:00 | no data | no data | no data | no data
 | 2023-12-05 14:02:00 | 2024-01-31 18:04:24 | no data | no data | no data | no data
 | 2024-01-30 16:14:00 | 2024-02-02 14:48:00 | no data | no data | no data | no data
 | 2024-01-31 12:14:49 | 2024-02-01 10:37:00 | no data | no data | no data | no data
 | 2024-01-31 11:35:27 | 2024-02-02 12:47:05 | no data | no data | no data | no data
 | 2024-01-31 10:33:20 | 2024-01-31 11:11:00 | no data | no data | no data | no data
 | 2024-01-17 12:53:29 | 2024-01-31 17:34:00 | no data | no data | no data | no data
 | 2024-01-30 17:12:55 | 2024-01-30 18:33:58 | no data | no data | no data | no data
Spreadsheet: 76185d1276718606-excel-2007-data-validation-temp
Sheet: BOM

 |  |  |  |  |  |  |  |  | LINE SPEC | CAB
Item # | Qty | UOM | SIZE |  |  | ITEM | Material Description |  |  | Item Code
 |  |  | 3 |  |  | CAP
Spreadsheet: tracy_geaccone__40494__OM Schedule - IT 2
Sheet: Variance to C.E.

DIRECT O&M VARIANCE
2001 SECOND C.E. vs. 2002 PLAN
 |  |  | 2001 SECOND CURRENT ESTIMATE | 2001 C.E. IF ADJUSTED FOR 2002 BUDGET CHANGES (1)
2001 2nd C.E. -  NET |  |  | 28.6 | 28.5
Variances:
SAN Monthly Fee |  |  |  | 0
O&E Support - Transfer of Funds |  |  | 0.7 | 0.3
EPSC |  |  | 0.9 | 0.9
New License Fees |  |  | 0.5 | 0.5
Software Maintenance Fees* |  |  | 0.1 | 0.1
2002  PLAN - NET
*  Offset in Operations
(1)  2001 Adjusted for $.4 O&E Support  (Offset Should be Reflected in Operations 2002 Plan) and
for a Full Year of SAN ($2.8MM).
Spreadsheet: 865444d1712520162-identify-dates-that-are-close-to-each-other-for-each-player-example
Sheet: Sheet1

Name | Game 1 start date | Game 1 end date | Game 2 start date | Game 2 end date | Do I need to check?
[NAME] | 2023-03-06 00:00:00 | 2023-03-15 00:00:00 | 2023-03-07 00:00:00 | 2023-03-16 00:00:00 | Yes
[NAME] | 2023-04-27 00:00:00 | 2023-04-28 00:00:00 | 2023-05-05 00:00:00 | 2023-05-10 00:00:00 | Yes
[NAME] | 2023-03-06 00:00:00 | 2023-03-15 00:00:00 | 2023-04-28 00:00:00 | 2023-08-31 00:00:00
[NAME] | 2023-03-07 00:00:00 | 2023-03-17 00:00:00 | 2024-02-04 00:00:00 | 2024-02-06 00:00:00
[NAME] | 2023-09-06 00:00:00 | 2023-11-01 00:00:00 | 2024-02-18 00:00:00 | 2024-03-25 00:00:00 | No
Spreadsheet: 218405d1362445206-vlookup-or-match-if-enragedpigeon
Sheet: Sheet1

Company | Y/N | Amt
a | Yes | 100
b | No | 200
c | Yes | 300
x | No | 400
y | No | 1000
z | Yes | 204
Spreadsheet: 125536d1319085852-excel-2007-common-finder-ex7
Sheet: Sheet1

POSSIBILITIES |  | 48 |  |  | 60 |  |  |  |  | 48 |  | 60
 |  |  |  |  |  |  |  |  |  | 20 | 28 | 29 | 31
0 |  | 1 | 47 |  | 1 | 59 |  |  |  | 21 | 27 | 28 | 32
0 |  |  |  |  |  |  |  |  |  | 21 | 27 | 29 | 31
0 |  |  |  |  |  |  |  |  |  | 22 | 26 | 27 | 33
0 |  |  |  |  |  |  |  |  |  | 22 | 26 | 28 | 32
0 |  |  |  |  |  |  |  |  |  | 22 | 26 | 29 | 31
0 |  |  |  |  |  |  |  |  |  |  |  | 26 | 34
0 |  |  |  |  |  |  |  |  |  | 23 | 25 | 27 | 33
0 |  |  |  |  |  |  |  |  |  | 23 | 25 | 28 | 32
0 |  |  |  |  |  |  |  |  |  | 23 | 25 | 29 | 31
0
0
0 |  |  |  |  |  |  |  |  |  | 19 | 29 | 29 | 31
0
0
0
0
0
0
0
1
2
Spreadsheet: 751702d1634262810-looking-for-formula-to-cumulatively-count-number-of-unique-customers-over-time-example-data-set
Sheet: Sheet1

 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
Customer 1 | 1 |  | 1 |  |  |  |  |  | 1
Customer 2 |  | 1 |  |  | 1
Customer 3 |  |  |  | 1 |  |  |  |  | 1
Customer 4
Customer 5 |  | 1 |  |  |  |  |  |  |  |  | 1
Total customers to date | 1 | 3 | 3
Spreadsheet: 783847d1655202699-cash-flow-projection-calculator-cash-flow-projection-calculator
Sheet: Cash Flow

PROJECT
CLIENT
Cash Flow
INDICATIVE CASH FLOW
PAYMENT |  | GROSS VALUE
No. | Month | Monthly | Cumulative
1 | 2022-08-01 00:00:00 | 260000 | 260000
2 | 2022-09-01 00:00:00 | 549000 | 809000
3 | 2022-10-01 00:00:00 | 821000 | 1630000
4 | 2022-11-01 00:00:00 | 1076000 | 2706000
5 | 2022-12-01 00:00:00 | 1314000 | 4020000
6 | 2023-01-01 00:00:00 | 1535000 | 5555000
7 | 2023-02-01 00:00:00 | 1738000 | 7293000
8 | 2023-03-01 00:00:00 | 1924000 | 9217000
9 | 2023-04-01 00:00:00 | 2094000 | 11311000
10 | 2023-05-01 00:00:00 | 2245000 | 13556000
11 | 2023-06-01 00:00:00 | 2379000 | 15935000
12 | 2023-07-01 00:00:00 | 2497000 | 18432000
13 | 2023-08-01 00:00:00 | 2598000 | 21030000
14 | 2023-09-01 00:00:00 | 2680000 | 23710000
15 | 2023-10-01 00:00:00 | 2746000 | 26456000
16 | 2023-11-01 00:00:00 | 2795000 | 29251000
17 | 2023-12-01 00:00:00 | 2826000 | 32077000
18 | 2024-01-01 00:00:00 | 2840000 | 34917000
19 | 2024-02-01 00:00:00 | 2837000 | 37754000
20 | 2024-03-01 00:00:00 | 2818000 | 40572000
21 | 2024-04-01 00:00:00 | 2779000 | 43351000
22 | 2024-05-01 00:00:00 | 2726000 | 46077000
23 | 2024-06-01 00:00:00 | 2653000 | 48730000
24 | 2024-07-01 00:00:00 | 2565000 | 51295000
25 | 2024-08-01 00:00:00 | 2458000 | 53753000
26 | 2024-09-01 00:00:00 | 2335000 | 56088000
27 | 2024-10-01 00:00:00 | 2195000 | 58283000
28 | 2024-11-01 00:00:00 | 2036000 | 60319000
29 | 2024-12-01 00:00:00 | 1862000 | 62181000
30 | 2025-01-01 00:00:00 | 1670000 | 63851000
31 | 2025-02-01 00:00:00 | 1460000 | 65311000
32 | 2025-03-01 00:00:00 | 1234000 | 66545000
33 | 2025-04-01 00:00:00 | 990000 | 67535000
34 | 2025-05-01 00:00:00 | 729000 | 68264000
35 | 2025-06-01 00:00:00 | 450000 | 68714000
36 | 2025-07-01 00:00:00 | 1221000 | 69935000
37 | 2025-08-01 00:00:00 | 0 | 69935000
38 | 2025-09-01 00:00:00 | 0 | 69935000
39 | 2025-10-01 00:00:00 | 0 | 69935000
40 | 2025-11-01 00:00:00 | 0 | 69935000
39 | 2025-10-01 00:00:00 | 0 | 69935000
40 | 2025-11-01 00:00:00 | 0 | 69935000
41 | 2025-12-01 00:00:00 | 0 | 69935000
42 | 2026-01-01 00:00:00 | 0 | 69935000
43 | 2026-02-01 00:00:00 | 0 | 69935000
44 | 2026-03-01 00:00:00 | 0 | 69935000
45 | 2026-04-01 00:00:00 | 0 | 69935000 |  |  | Estimated Total | 71000000 |  | Contract start on site: | 2022-06-20 00:00:00
46 | 2026-05-01 00:00:00 | 0 | 69935000 |  |  | Status: | End of Day |  | Construction Period: | 36
47 | 2026-06-01 00:00:00 | 0 | 69935000 |  |  | Retention: | 3 |  | Defects Liability Period: | 12
48 | 2026-07-01 00:00:00 | 1065000 | 71000000
Spreadsheet: 555699d1515700189-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018-3-
Sheet: Tournament 1

 |  |  | Tournament 1 |  |  |  |  |  |  | 0 | 2
 |  |  |  |  |  |  |  |  | # of Members Played | Did not Play | # of Players with Low Score | # of Players with MAX Score
 |  |  |  | Tournament |  | After Adjustments
 |  |  | Player | Score | Sub - Points | Actual Score | Actual Points |  | Tournament low score [NAME] (s)
 |  |  |  |  |  |  |  |  | Player | Points | Low Score
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  | Enter Data into the Tournament Score column only
 |  |  |  |  |  |  |  |  | Enter DNP against the Members who DID NOT PLAY
 |  | x | x | x
Spreadsheet: 46154d1245059210-pivot-unique-count-solution-pivot-unique-count-pivot-unique-count
Sheet: Sheet1

 | Customer | Product |  |  | Count of Product
 | [NAME] | Donut |  |  | Customer | Total |  | Don't forget to press Ctrl+Shift+Enter after entering formula
 | [NAME] | [NAME] |  |  | [NAME] | 1 | 1
 | [NAME] | Donut |  |  | [NAME] | 3 | 2
 | [NAME] | Cupcake |  |  | [NAME] | 2 | 2
 | [NAME] | Donut |  |  | [NAME] | 1 | 1
 | [NAME] | [NAME] |  |  | Grand Total | 7
 | [NAME] | Donut
Spreadsheet: 728144d1618334899-formula-to-select-match-column-sample-data
Sheet: Data

 | Bonus Periods, Mgr's & Payments by Store
# | Store | 2021-13 |  | 2021-12 |  | 2021-11 |  | 2021-10 |  | 2021-09 |  | 2021-08 |  | 2021-07 |  | 2021-06 |  | 2021-05 |  | 2021-04 |  | 2021-03 |  | 2021-02 |  | 2021-01 |  |  | 2020-13 |  | 2020-12 |  | 2020-11 |  | 2020-10 |  | 2020-09 |  | 2020-08 |  | 2020-07 |  | 2020-06 |  | 2020-05 |  | 2020-04 |  | 2020-03 |  | 2020-02 |  | 2020-01
204 | Old Town |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204,Wyatt - GM | 1265 | 204,Wyatt - GM | 890 | 204,Wyatt - GM | 462 |  | 204,Wyatt - GM | 125 | 204,Wyatt - GM | 782 | 204,Wyatt - GM | 5734 | 204,Wyatt - GM | 465 | 726 | 654 | 204,Wyatt - GM | 345 |  |  |  |  |  |  |  |  |  |  |  | 132 | 204,Homer - GM | 82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204,Sally | 558 | 204,Sally | 207 | 204,Sally | 231 |  | 204,Sally | 458 | 204,Sally | 73 | 204,Sally | 455 | 204,Sally | 354 | 204,Sally | 352 | 204,Sally | 422 |  |  |  |  |  |  |  |  |  |  | 204,Sally | 413 | 204,Sally | 458
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204,Judy | 558 | 204,Judy | 207 | 204,Judy | 231 |  | 204,Judy | 874 | 204,Judy | 5 | 204,Judy | 78 | 204,Judy | 25 | 204,Judy | 85 | 204,Judy | 23 |  |  |  |  |  |  |  |  |  |  | 204,Lenny | 4 | 204,Billy | 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204,Bob | 223 | 204,Bob | 83 | 204,Bob | 92 |  | 204,Bob | 875 | 204,Bob | 4 | 204,Bob | 78 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204,Judy | 85 | 204,Lenny | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
206 | New Town |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206,Lou | 1596 | 206,Lou | 1253 | 206,Lou | 1256
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206,Agnes | 658 | 206,Agnes | 376 | 206,Agnes | 378
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206,Lucy | 0 | 206,Lucy | 151 | 206,Lucy | 151
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | deliver manager payment by time period
 | Active Managers
 | 204,Wyatt - GM
 | 204,Homer - GM
 | 204,Sally
 | 204,Judy
 | 204,Lenny
 | 204,Billy
 | 204,Bob
 | 206,Lou
 | 206,Agnes
 | 206,Lucy
 | 208,Olivia
 | 208,Harry
 | 208,Hermione
 | 210,Jerry - GM
Spreadsheet: 40395d1238697852-pivot-table-question-general_query_q-1
Sheet: Sheet1

QuestionID | 9
 |  | Description
AgeGroup | Data | Other | a | b | c | d | e | Grand Total
25 - 34 | Count of QuestionID | 1 | 2 | 2 | 1 | 1 |  | 7
 | Average of respn | 900 | 900 | 900 | 900 | 900 |  | 900
 | Sum of Field1 | 0.001111111111111111 | 0.0005555555555555556 | 0.0005555555555555556 | 0.001111111111111111 | 0.001111111111111111 | #N/A | 0.0001587301587301587
35 - 44 | Count of QuestionID |  |  |  |  | 1 | 1 | 2
 | Average of respn |  |  |  |  | 900 | 900 | 900
 | Sum of Field1 | #N/A | #N/A | #N/A | #N/A | 0.001111111111111111 | 0.001111111111111111 | 0.0005555555555555556
Total Count of QuestionID |  | 1 | 2 | 2 | 1 | 2 | 1 | 9
Total Average of respn |  | 900 | 900 | 900 | 900 | 900 | 900 | 900
Total Sum of Field1 |  | 0.001111111111111111 | 0.0005555555555555556 | 0.0005555555555555556 | 0.001111111111111111 | 0.0005555555555555556 | 0.001111111111111111 | 0.0001234567901234568
 |  |  |  | should be this
 |  |  |  | 0.002222222222222222 |  | this one is correct
 |  |  |  | ie 2/900
 |  |  |  | were 900 is the amount of responders
Spreadsheet: rick_buy__32820__DOUG
Sheet: 0801

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF AUGUST 31, 2001
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 3995609.14 |  | 4246004.18 |  | 1480001.13 |  | 0 |  | 18408675.15 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  | 0 |  | 0 |  |  |  |  | 0
PUERTO QUETZAL | A/R |  | 0 |  | 0 |  | 0 |  | 0 |  | 361082.48 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 2179404.27
HAINAN MEINAN | A/R |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
DABHOL POWER CO | A/R |  | 222042.77 |  | 222042.41 |  | 222042.83 |  | 220242.35 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 0
EMPRESA ENERGETICA | A/R |  | 0 |  | 1395232.05 |  | 8876.53 |  | 0 |  | 74964.58 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 1285097.06
EGEMINSA | A/R |  | 3114212.1 |  | 6798657.07 |  | 800728.78 |  | 453522.66 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
TOTALS | A/R
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL RECEIPTS