tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861778d1709623737-formula-for-different-data-format-in-mmddyyyy-covert-date-format
Sheet: Sheet2

Date with General [NAME] (DDMMYYYY) | Remove "/" | Add leading zeros | MM/DD/YYYY (Final) | [NAME] | [NAME]/dd/yyy
2099-01-01 00:00:00
1900-01-01 00:00:00
2024-06-07 00:00:00
2030-01-08 00:00:00
2024-04-09 00:00:00
2023-08-08 00:00:00
2024-07-09 00:00:00
2029-01-09 00:00:00
2025-06-01 00:00:00
2025-04-02 00:00:00
2025-08-01 00:00:00
2031-01-01 00:00:00
2030-04-01 00:00:00
2026-04-30 00:00:00
2025-08-31 00:00:00
2024-06-14 00:00:00
2024-06-30 00:00:00
2020-06-30 00:00:00
2025-01-10 00:00:00
2025-06-30 00:00:00
2012-08-31 00:00:00
2022-06-15 00:00:00
2022-07-12 00:00:00
2032-01-13 00:00:00
2027-03-23 00:00:00
2026-10-04 00:00:00
2023-01-31 00:00:00
2027-04-13 00:00:00
2026-07-14 00:00:00
2033-01-11 00:00:00
2029-04-10 00:00:00
2016-09-30 00:00:00
2020-04-30 00:00:00
2021-09-30 00:00:00
2024-07-29 00:00:00
2015-09-30 00:00:00
2023-09-30 00:00:00
2022-06-30 00:00:00
2020-07-14 00:00:00
2024-07-31 00:00:00
2018-09-20 00:00:00
2021-07-31 00:00:00
2023-04-11 00:00:00
2018-04-10 00:00:00
2016-04-12 00:00:00
2022-03-31 00:00:00
2015-01-31 00:00:00
2019-07-31 00:00:00
2027-01-12 00:00:00
2029-05-31 00:00:00
2019-01-31 00:00:00
2024-03-31 00:00:00
2030-06-30 00:00:00
2023-02-28 00:00:00
2021-01-29 00:00:00
2026-04-16 00:00:00
2025-01-14 00:00:00
2026-06-30 00:00:00
2026-02-28 00:00:00
2027-08-31 00:00:00
2025-02-28 00:00:00
2027-02-28 00:00:00
2026-07-15 00:00:00
2025-11-30 00:00:00
2022-12-20 00:00:00
2027-12-31 00:00:00
2024-12-31 00:00:00
2025-10-14 00:00:00
2022-11-10 00:00:00
2023-11-30 00:00:00
2021-10-12 00:00:00
2026-11-30 00:00:00
2022-12-31 00:00:00
2024-10-31 00:00:00
2027-10-12 00:00:00
2021-12-12 00:00:00
2023-12-31 00:00:00
2024-12-18 00:00:00
2030-12-31 00:00:00
2023-10-10 00:00:00
2020-11-30 00:00:00
2020-12-31 00:00:00
2025-12-31 00:00:00
2023-10-31 00:00:00
2025-10-31 00:00:00
Spreadsheet: 696483d1600850336-the-aggregate-function-with-the-sum-option-does-not-work-for-me-aggregate
Sheet: גיליון13

site | month | [NAME] | year | type1 | val |  | Criteria
site1 | October |  | 2015 | [NAME] | 0 |  | site | site1
site2 | November |  | 2015 | type1 | 0 |  | year | 2016
site1 | December |  | 2015 | type1 | 9000 |  | type | type1
site1 | January |  | 2016 | type1 | 11000 |  | [NAME] | 3
site1 | February |  | 2016 | type1 | 11500
site1 | March |  | 2016 | type1 | 12000
site2 | April |  | 2016 | type1 | 7000
site2 | May |  | 2016 | [NAME] | 8000
 |  |  |  |  |  |  | Calculated value
 |  |  |  |  |  |  | [NAME] | sum
 |  |  |  |  |  |  | Expected value
 |  |  |  |  |  |  | [NAME] | sum
 |  |  |  |  |  |  | 12000 | 34500
Spreadsheet: 39717d1238003420-finding-the-modal-value-of-a-word-in-a-set-of-filtered-data-sample
Sheet: Calculations

 | Grower | Lot | Product | Variety | Amount Received | Amount Rejected | Reason | Percentage
 | GROWER1 | 1231453 | Product A | MIXED | 24000
 | GROWER2 | 2342342 | Product B | MIXED | 33655 | 2019.3 | OPEN BUDS | 6
 | GROWER2 | 23476623 | Product A | PINK FANCY | 22800 | 1140 | YELLOWING | 5
 | GROWER2 | 234623 | Product C | TASSMAN FA | 4000 | 120 |  | 3
 | GROWER2 | 23627 | Product D | GIOELLE FA | 6400 | 64 |  | 1
 | GROWER2 | 12336 | Product A | PINK FANCY | 11960 | 1674.4 | OPEN BUDS | 14
 | GROWER2 | 23462345 | Product E | SPRAY PINK | 6200 | 62 |  | 1
 | GROWER2 | 6234 | Product F | ROSITAVEND | 2112 | 21.12 |  | 1
 | GROWER2 | 234156 | Product G | OCEANSONG | 1728 | 172.8 | BRUISING | 10
 | GROWER2 | 2356 | Product A | PINK FANCY | 14400 | 1152 | BRUISING | 8
 | GROWER2 | 236214 | Product N | PRADO | 1600 | 16 |  | 1
 | GROWER2 | 236243 | Product M | [NAME] | 1600 | 16 |  | 1
 | GROWER2 | 13625 | Product Z | VENDELA | 9024 | 902.4 | BRUISING | 10
 |  |  |  |  |  | Main Rejection Reason | YELLOWING | <--------
Spreadsheet: 881134d1729067956-generating-number-sequence-based-on-column-sequence
Sheet: Sheet1

 | A | B | C | D | E |  | SEQUENCE
 | 2 |  | 1 |  |  |  | 1,2,8 | notice the number 8 this is the value in column C
 | 1 |  |  |  |  |  | 3
 |  |  | 1 |  |  |  | 9
 | 4 |  |  |  |  |  | 4,5,6,7
 |  |  |  | 3 | 2 |  | 10,11,12,13,14
 |  |  |  |  | 3 |  | 15,16,17
Spreadsheet: 109750d1306514712-advanced-paycheck-calculator-if-statments-paycheck-calculator
Sheet: Sheet1

 | [NAME] |  | 12
 |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday |  | Hours Worked
 | 7am - 3pm
 | 3pm - 11pm | 8 | 8 | 8 | 8 | 8 | 8 | 4
 | 11pm - 7am
 |  |  |  |  |  |  |  |  |  |  |  |  | base
 |  |  |  |  |  |  |  |  |  |  |  |  | eve
 |  |  |  |  |  |  |  |  |  |  |  |  | night
 |  |  |  |  |  |  |  |  |  |  |  |  | wknd night
Spreadsheet: gerald_nemec__11496__ELIZABETHTOWN Soil Results
Sheet: Sheet1

DRAFT
TABLE 2
SOIL SAMPLING RESULTS
COGENTRIX - ELIZABETHTOWN, NORTH CAROLINA
Parameter | Units | Concentration
 |  | Background Soil Levels | EOWS-1-1 (6.0') | EOWS-2-1 (6.0') | EOWS-4-1 (6.0') | EAS-1-1 (1.5') | EAS-1-2 (4.5') | EAS-2-1 (1.5') | EAS-2-2 (4.5') | EAS-3-1 (1.5') | EAS-3-2 (4.5') | EAS-4-1 (1.5') | EAS-4-2 (4.5') | EAS-5 (ash)
Arsenic | mg/kg | 1- 18 | NA | NA | NA | 12 | 5.7 | 3.6 | 8 | 48 | 46 | 6.9 | 8.5 | 21
Cadmium | mg/kg | ND - 4 | NA | NA | NA | <.1 | <0.13 | <.1 | <.11 | <.12 | <.14 | <.11 | <.12 | <.12
Chromium | mg/kg | 7 - 300 | NA | NA | NA | 46 | 24 | 53 | 27 | 170 | 42 | 66 | 33 | 15
Copper | mg/kg | 3 - 100 | NA | NA | NA | 9.7 | 4.8 | 7.9 | 6.8 | 32 | 6 | 13 | 6 | 59
Iron | mg/kg | 100 - 100,000 | NA | NA | NA | 22000 | 7200 | 11000 | 6100 | 62000 | 11000 | 16000 | 13000 | 9800
Lead | mg/kg | ND - 50 | NA | NA | NA | 18 | 8.8 | 15 | 14 | 22 | 15 | 13 | 15 | 23
Nickel | mg/kg | ND- 150 | NA | NA | NA | <.52 | <.65 | 0.75 | 0.78 | <.62 | <.69 | 0.73 | 1.1 | 18
Selenium | mg/kg | 0.1 - 0.8 | NA | NA | NA | 0.7 | 1.7 | 1 | <.57 | <.62 | 1 | 2.6 | <.58 | 4.8
Zinc | mg/kg | 25 - 124 | NA | NA | NA | 5.1 | 3.4 | 5.9 | 6.7 | 5.8 | 5.5 | 6.4 | 16 | 190
Mercury | mg/kg | 0.03 - 0.52 | NA | NA | NA | <0.0049 | 0.0052 | 0.026 | 0.032 | 0.026 | 0.0085 | 0.059 | <0.0045 | 0.096
PCB-1016 | ug/kg | na | <360 | <36 | <38 | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1221 | ug/kg | na | <360 | <36 | <38 | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1232 | ug/kg | na | <360 | <36 | <38 | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1242 | ug/kg | na | <360 | <36 | <38 | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1248 | ug/kg | na | <360 | <36 | <38 | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1254 | ug/kg | na | <360 | <36 | <38 | NA | NA | NA | NA | NA | NA | NA | NA | NA
PCB-1260 | ug/kg | na | <360 | <36 | <38 | NA | NA | NA | NA | NA | NA | NA | NA | NA
TPH-Diesel | mg/kg | na | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA | NA
Oil & Grease | mg/kg | na | 272 | <165 | <165 | NA | NA | NA | NA | NA | NA | NA | NA | NA
Oil & Grease (silica gel) | mg/kg | na | 202 | <165 | <165 | NA | NA | NA | NA | NA | NA | NA | NA | NA
Background Soil Levels from "Elements in North American Soils" (Dragun, 1991), ranges for North Carolina and Eastern USA.
na - Not Applicable |  |  |  |  | TPH = Total Petroleum Hydrocarbons
NA = Not Analyzed |  |  |  |  | PCB = Polychlorinated biphenyls
ND = Not Detected |  |  |  |  | EOWS = Elizabethtown Oil/Water Separator
mg/kg = milligrams per kilogram |  |  |  |  | EAS = Elizabethtown Ash Silo
Spreadsheet: 78571d1278950841-excel-2007-multiple-if-vlookup-filling-data-on-multiple-criterias-staffonduty
Sheet: DailyPlan

 |  | Product A |  | Product B |  | Product C |  | 0 | DAY OFF
 |  | 85 |  | 50 |  | 50 |  | 1 | HALF DAY
 |  |  |  |  |  |  |  | 2 | FULL DAY
 |  |  |  |  |  |  |  | WORKER ON DUTY |  |  |  | Result to be>
 | DATE | Prod A | QTY (A) | Prod B | QTY (B) | Prod C | QTY (C) | A | B | C
 | 2010-06-01 00:00:00 | 0 |  | 3 |  | 1 |  | 0 | 0 | 0 |  | Suppose to be returned in blank ("")
 | 2010-06-02 00:00:00 | 1 |  | 2 |  | 0 |  | 0 | 1 | 0 |  | This is tested okay
 | 2010-06-03 00:00:00 | 0 |  | 2 |  | 0 |  | 1 | 0 | 1 |  | This is tested okay
 | 2010-06-04 00:00:00 | 0 |  | 2 |  | 0 |  | 0 | 0 | 1 |  | This is tested okay
 | 2010-06-05 00:00:00 | 1 |  | 1 |  | 0 |  | 2 | 1 | 0 |  | Additional assumption failed.
 | Workday
Spreadsheet: 791087d1660147815-how-to-seperate-cell-value-from-the-right-of-a-dash-book1
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14
D-1234 |  |  |  |  |  |  |  |  |  | =TRIM(RIGHT(SUBSTITUTE($A3,"-",REPT(" ",LEN($A3))),COLUMN(A:A)-1)*LEN($A3)+1,LEN($A3)))
D-4321 |  |  |  |  |  |  |  |  |  | 4321
D-ZZ4322 |  |  |  |  |  |  |  |  |  | ZZ4322
Spreadsheet: 374115d1422658776-pulling-multiple-data-from-a-spreadsheet-to-a-certain-criteria-highlights
Sheet: Sheet2

date | Quote | Part No | Customer | indusrty | class | Value
2015-01-01 00:00:00 | Q11764 | E000893 | [NAME] | food | a | 10000
2015-01-02 00:00:00 | Q11765 | E015601 | cadbury | food | a | 12000
2015-01-03 00:00:00 | [NAME] | E015596 | leekes | goods | a | 15000
2015-01-04 00:00:00 | Q11767 | E015597 | ford audi | cars | a | 20000
2015-01-05 00:00:00 | Q11768 | E013801 | [NAME] | food | a | 30000
2015-01-06 00:00:00 | Q11769 | E015603 | cadbury | food | b | 500
2015-01-07 00:00:00 | Q11770 | E015593 | leekes | goods | b | 1500
2015-01-08 00:00:00 | Q11771 | E015605 | ford audi | cars | b | 8000
2015-01-09 00:00:00 | Q11771 | E015606 | [NAME] | food | b | 2500
2015-01-10 00:00:00 | Q11771 | E015607 | cadbury | food | b | 15000
2015-01-11 00:00:00 | Q11772 | E006159 | leekes | goods | c | 35000
2015-01-12 00:00:00 | Q11773 | E015604 | ford audi | cars | c | 90000
2015-01-13 00:00:00 | Q11774 | E006158 | [NAME] | food | c | 8000
2015-01-14 00:00:00 | Q11775 | E015572 | cadbury | food | app | 2500
2015-01-15 00:00:00 | [NAME] | E014139 | leekes | goods | app | 15000
2015-01-16 00:00:00 | Q11777 | E013856 | ford audi | cars | a | 35000
2015-01-17 00:00:00 | Q11778 | E014142 | [NAME] | food | b | 100000
2015-01-18 00:00:00 | Q11779 | E015608 | cadbury | food | c | 80000
2015-01-19 00:00:00 | Q11742 | E002781 | leekes | goods | app | 6000
2015-01-20 00:00:00 | [NAME] | E003176 | ford audi | cars | b | 5000
2015-01-21 00:00:00 | Q11744 | E003177 | [NAME] | food | c | 4000
2015-01-22 00:00:00 | Q11745 | E003162 | cadbury | food | c | 3000
2015-01-23 00:00:00 | Q11746 | E002780 | leekes | goods | c | 15000
2015-01-24 00:00:00 | Q11747 | [NAME] | ford audi | cars | app | 60000
2015-01-25 00:00:00 | Q11748 | E002776 | [NAME] | food | app | 75000
2015-01-26 00:00:00 | Q11749 | E015479 | cadbury | food | a | 100
2015-01-27 00:00:00 | Q11750 | E015477 | leekes | goods | b | 2563
2015-01-28 00:00:00 | Q11751 | E015478 | ford audi | cars | c | 458711
2015-01-29 00:00:00 | [NAME] | E015598 | [NAME] | food | app | 3205
2015-01-30 00:00:00 | Q11753 | E015599 | cadbury | food | b | 100
2015-01-31 00:00:00 | Q11754 | E013588 | leekes | goods | c | 100
Spreadsheet: 101981d1300051771-excel-2007-nested-offset-array-within-sum-or-sumproduct-portfoliodurationcalcwithnewinvestments
Sheet: Sheet1

 |  | Table values are invested balances (going down over time in rows - new investments are in columns)
 |  | Each |  |  |  |  |  |  |  |  |  |  | Calculated |  | Using
 |  | Investment's |  |  |  |  |  |  |  |  |  |  | Portfolio |  | Countif
 |  | Assumed Duration |  |  |  |  |  |  |  |  |  |  | Duration |  | To calculate
 |  | Profile | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | Over Time |  | # of Months
 | 1 | 6.1 | 100
 | 2 | 5.9 | 95 | 100
 | 3 | 5.8 | 90 | 95 | 100
 | 4 | 5.7 | 85 | 90 | 95 | 100
 | 5 | 5.5 | 80 | 85 | 90 | 95 | 100
 | 6 | 5.4 | 75 | 80 | 85 | 90 | 95 | 100
 | 7 | 5.3 | 70 | 75 | 80 | 85 | 90 | 95 | 100
 | 8 | 5.2 | 65 | 70 | 75 | 80 | 85 | 90 | 95 | 100
 | 9 | 5.1 | 60 | 65 | 70 | 75 | 80 | 85 | 90 | 95 | 100
Spreadsheet: 801687d1666300114-struggling-with-a-sum-if-formula-sum-if-difficulty-update
Sheet: Sheet1

JOB | Number from Team A | Number from Team B | 44927 | 44928 | 44929 |  |  | Column1 | Team A | Team B
1 | 2 | 2 | 1.5 | 1.5 | 1.5 |  |  | 44927
2 | 2 | 2 | 1.5 | 1.5 | 1.5 |  |  | 44928
3 | 1 |  |  |  |  |  |  | 44929
4 | 1
5 | 1
6 | 1
7 | 1 |  |  |  | 2
8 | 1
9 | 1
10 | 1
11 | 1 | 2
12 | 1 | 2
13 | 2 | 2 |  | 3 | 3
14 |  | 2
15 |  | 1
16 |  | 1
17 | 2
18 | 2
19
20
Spreadsheet: 92896d1292422241-find-a-date-and-average-corresponding-data-test
Sheet: Sheet1

2010-01-01 00:00:00 | #N/A
2010-01-08 00:00:00 | 105
2010-01-15 00:00:00 | 116
2010-01-22 00:00:00 | 117
2010-01-29 00:00:00 | 109
2010-02-05 00:00:00 | 121
2010-02-12 00:00:00 | 107.5
2010-02-19 00:00:00 | 117
2010-02-26 00:00:00 | 119
2010-03-05 00:00:00 | 123
2010-03-12 00:00:00 | 125
2010-03-19 00:00:00 | 137
2010-03-26 00:00:00 | 129
2010-04-02 00:00:00 | 129
2010-04-09 00:00:00 | 127
2010-04-16 00:00:00 | 125
2010-04-23 00:00:00 | 127
2010-04-30 00:00:00 | 123
2010-05-07 00:00:00 | 131
2010-05-14 00:00:00 | 122
2010-05-21 00:00:00 | 123
2010-05-28 00:00:00 | 117
2010-06-04 00:00:00 | #N/A
2010-06-11 00:00:00 | 115
2010-06-18 00:00:00 | 131
2010-06-25 00:00:00 | 130
2010-07-02 00:00:00 | #N/A
2010-07-09 00:00:00 | 131
2010-07-16 00:00:00 | 127
2010-07-23 00:00:00 | 135
2010-07-30 00:00:00 | 135
2010-08-06 00:00:00 | #N/A
2010-08-13 00:00:00 | 147.5
2010-08-20 00:00:00 | 135
2010-08-27 00:00:00 | 127
2010-09-03 00:00:00 | 123
2010-09-10 00:00:00 | 135
2010-09-17 00:00:00 | 123
2010-09-24 00:00:00 | 131
2010-10-01 00:00:00 | #N/A
2010-10-08 00:00:00 | #N/A
2010-10-15 00:00:00 | #N/A
2010-10-22 00:00:00 | 117.5
2010-10-29 00:00:00 | 121
2010-11-05 00:00:00 | 130
2010-11-12 00:00:00 | 132.5
2010-11-19 00:00:00 | 133
2010-11-26 00:00:00 | #N/A
2010-12-03 00:00:00 | 150
2010-12-10 00:00:00 | 140
2010-12-17 00:00:00 | #N/A
2010-12-24 00:00:00 | #N/A
2010-12-31 00:00:00 | #N/A
Spreadsheet: 690724d1597253221-last-man-standing-adding-additional-users-and-checking-formulas-preacher79-last-man-standing-template-3-1
Sheet: Pick

 | Name | Game 1 | Win, [NAME], Draw | Game 2 | Win, [NAME], Draw | Game 3 | Win, [NAME], Draw | Game 4 | Win, [NAME], Draw | Game 5 | Win, [NAME], Draw | Game 6 | Win, [NAME], Draw | Game 7 | Win, [NAME], Draw | Game 8 | Win, [NAME], Draw | Game 9 | Win, [NAME], Draw | Game 10 | Win, [NAME], Draw | Game 11 | Win, [NAME], Draw | Game 12 | Win, [NAME], Draw | Game 13 | Win, [NAME], Draw | Game 14 | Win, [NAME], Draw | Game 15 | Win, [NAME], Draw | Game 16 | Win, [NAME], Draw | Game 17 | Win, [NAME], Draw | Game 18 | Win, [NAME], Draw | Game 19 | Win, [NAME], Draw | Game 20 | Win, [NAME], Draw
 |  | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
 |  |  |  |  | 1
 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
1 | 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
Spreadsheet: 537644d1505214153-watts-to-pace-formula-split-to-watts
Sheet: Sheet1

Date | Season | Term | Name | Date | Split | Min | SS | Sec Total | Pace | Watts
2017-09-06 00:00:00 | 2017-2018 | 1.1 | [NAME] | 2017-01-28 00:00:00 | 00:01:34
Spreadsheet: 151711d1335077039-gathering-information-across-multiple-sheets-and-displaying-in-a-master-sheet-products-1-
Sheet: Master

 | I would like the totals for each item from all the sheets displayed here.
 | No | Name | Total | 1 | 2 | 3 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
 | 20073
 | 20074
 | 20075
 | 20077
 | 20084
 | 20076
 | 20078
 | 20082
Input No= | 20074 | I would like to be able to enter a product number and the information for that number from each sheet be displayed below.
Date | No | Name | Total | 1 | 2 | 3 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
4042012
11042012
Spreadsheet: kam_keiser__17867__E&Y Form A
Sheet: Form A

All suggested threshold levels on the following forms are for placeholder purposes only.  Final buckets to be determined following more in-depth analysis.
Enron and Affiliates
[NAME] as of: Nov 30, 2001
 |  |  |  |  |  | Total MTM | 729074042
Commodity: Natural Gas | Date of Preparation: 1/17/2002 |  |  |  |  | Schedule C | -152885891
Legal Entity:___________
Statistic | Financial | Physical | Total |  |  | Total US DPR | 571739986
 | Net | Net |  |  |  | [NAME]
Estimated MTM 1 ($)
# of Counterparties | 442 | 732
Counterparty Distribution by MTM 2 (#)
>=$0mm, <$1mm | 97 | 357
>=$1mm, <$5mm | 39 | 27
>=$5mm, <$10mm | 19 | 8
>=$10mm | 45 | 18
# of Transactions
Transaction Distribution by MTM (#)
<$0mm | 42256 | 2444
>=$0mm, <$1mm | 68583 | 4799
>=$1mm, <$5mm | 7892 | 124
>=$5mm, <$10mm | 423 | 27
>=$10mm | 292 | 38
Tenor Distribution by Transactions (#)
< 1 year | 117225 | 6675
>=1 year, <3 years | 1544 | 268
>=3 years, <5 years | 398 | 188
>=5year, <10 years | 222 | 218
>= 10 years | 57 | 83
Tenor Distribution by MTM ($)
< 1 year
>=1 year, <3 years | -11001907.74999969 | 33162492.44000001
>=3 years, <5 years | -14266434.10999995 | 143033736.46
>=5year, <10 years | -64228232.27999994 | 2997293.680000018
>= 10 years | 906608.5800000026 | 112060264.09
Trade Type Distribution by Transactions (#)
Annuity | 96 | 58
Swap
EFP | 0 | 61
Flex Price | 0 | 101
Forward | 90
Future | 14803 | 0
Gas Daily Swap | 8214 | 6
Trade Type Distribution by MTM ($)
Swap
EFP | 0 | 27061236.81
Flex Price | 0 | 4870381
Forward | 764671.53 | 494175177.87
Future | 199191200 | 0
Gas Daily Swap | 6210577.98 | 0
Notes
* Additional forms for each commodity should be labeled as [NAME], Form A2, etc.
1 MTM ([NAME]-to-Market Value) reflects no adjustment for Collateral or Accounts Payable/Receivable
2  < indicates less than, >= indicates greater than/equal to
3 To be expanded depending on the underlying commodity
Spreadsheet: 876152d1722846252-need-formula-for-tier-incentive-calculation-calculation-doing-formula
Sheet: Dr. Abdullah Al Dakheel

 |  |  | Achieved
 |  | Total Revenue | 0
 |  | OR Fee | 6600
 |  | Vaser Machine (Rented) | 0
 |  | [NAME] (Rented) | 2000
 |  | [NAME] (4.5/271) | 1355
 |  | [NAME] (3.0/277) | 1385
 |  | [NAME] (1.5/312) | 1560
 |  | Net Payment
 |  |  |  |  |  |  | Dr [NAME]
 |  |  |  |  |  |  | # | Day/Date | Time | Patient Name and file number |  | [NAME] | Dr Name | Anesthesia | Machines used | Amount
 |  |  |  |  |  |  | 1 | Wednesday 25-12-2019 | At 9:00 am he tooks                     1 hr & 8 min | [NAME] |  | Dental Rehab | Dr [NAME] | GA
 |  |  |  |  |  |  | 2 | Wednesday 25-12-2019 | At 10:40 am he tooks                     58 mins | Algwharha [NAME] 10055987 |  | Dental Rehab | Dr [NAME] | GA |  | 2000
 |  |  |  |  |  |  | 3 | Monday 30-12-2019 | At 10:27 pm he tooks                     48 mins | [NAME] 10055937 |  | Full Dental Treatment | Dr [NAME] | GA |  | 2000
Spreadsheet: 678683d1590005953-validation-for-non-blank-entry-and-upper-case-values-x-x-free-counseling
Sheet: Sheet1

Lname, Fname
AIC Free Counseling
Date of Visit | Start Time | End Time | Client | Individual or Family? | Telecon? | Free? | Minutes | Fee Due | P. note 365 | P. Note | Claimed | Approved | Original SDED 1 | SDED 1 | Original SDED 2 | SDED 2 | Paid
2020-04-16 00:00:00 | 18:30:00 | 19:30:00 | [NAME] |  | T | Y
2020-04-18 00:00:00 | 11:00:00 | 12:30:00 | [NAME] |  | T
2020-04-24 00:00:00 | 17:30:00 | 18:30:00 | [NAME] |  | T
2020-05-05 00:00:00 | 17:30:00 | 18:30:00 | [NAME] |  | T
2020-05-14 00:00:00 | 17:30:00 | 18:30:00 | [NAME]
2020-05-15 00:00:00 | 14:00:00 | 15:00:00 | [NAME] |  | T
 |  |  | TOTALS
Notes:
 |  |  |  | I
 |  |  |  | F
Spreadsheet: 19314dc5-a4fc-43d8-8e04-e7138ff9bec4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 41. OPERATING LEASE FINANCE COMMITMENTS, By Industry: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2413817T | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2413818V | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2413819W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2413820F | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2413821J | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2413823L | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2413824R | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2413825T | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2413826V | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2413827W | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2413828X | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2413829A | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413830K | 1985-01-01 00:00:00 | 2012-10-01 00:00:00 | 334 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012