tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 05eddf32-94cf-44e7-88a5-ba7ad1ded21a
Sheet: Attachment G - Rental Proforma

RENTAL DEVELOPMENT PROFORMA: 15 Year Cashflow
 | Yr 1 | Yr 2 | Yr 3 | Yr 4 | Yr 5 | Yr 6 | Yr 7 | Yr 8 | Yr 9 | Yr 10 | Yr 11 | Yr 12 | Yr 13 | Yr 14 | Yr 15
REVENUES
Gross Residential Rent
+Other income
=GROSS INCOME
-Residential Vacancy
=EFFECTIVE GROSS RENT
OPERATING EXPENSES
Administration
-Advertising
-Management Fee
-Legal
-Asset Manageemnt Fee
-Off-site Mgmt Payroll
- Other Administrative Expenses (specify)
Maintenance
-Rubbish Removal
-Grounds Maintenance/Repair Services
- Other Maintenance Expenses (specify)
Utilities
Property Costs
- Real Estate Taxes and Specials Assessments
-Insurance
- Other Property Expenses (specify)
Reserves
- Reserve Deposits (specify)
- Reserve Deposits (specify)
Total Operating Expenses
=NET OPERATING INCOME
- DEBT SERVICE
=CASH FLOW
Spreadsheet: sally_beck__33888__Log as of 29 dec 00
Sheet: Sum Nov 8 to 14

 | Week summary (Nov 9-14)
Cat. | Description | Total |  | Breakdown of Cat 1
1 | Human Errors | 3 |  | Process in place but not followed | 1
2 | IT Hardware problems | 1 |  | Spreadsheet had illegal character | 2
3 | IT Software Problems | 6 |  | Book not officialized | 0
4 | Miscellaneous | 0 |  | No process in place | 0
5 | Uncontrollable | 0 |  | Total
 | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 1
 |  |  |  | Other | 0
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs | 1
 |  |  |  | Slow feeds | 2
 |  |  |  | Books shown as officialized in ERMS, but not RiskTrac | 1
 |  |  |  | Other | 2
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: 482842d1475263821-per-diem-calculation-per-diem-calculator
Sheet: Sheet1

Meals Per Diem Calculator |  |  |  | Yellow cell are data entry areas. |  |  |  |  | Leave |  | Arrive
Per Diem Eligibility |  | 50 |  |  |  |  |  | 05:00:00 | 50 |  | 05:00:00 | 0
Meals Per Diem Rate |  |  |  |  |  |  |  | 11:00:00 | 35 |  | 11:00:00 | 20
Total | Breakfast | Lunch | Dinner |  |  |  |  | 14:00:00 | 20 |  | 14:00:00 | 35
 |  |  |  |  |  |  |  | 22:00:00 | 0 |  | 22:00:00 | 50
First Day of Travel |  | Last Day of Travel |  | Meals Per Diem
Date | Departure Time | Date | [NAME] |  |  |  |  | Leave Day | Arrive Day | All Other Days
2016-09-30 00:00:00 | 10:00:00 | 2016-10-15 00:00:00 | 15:00:00
Spreadsheet: 112763d1308769459-pulling-value-from-table-based-on-two-variables-table-on-two-variables2
Sheet: Sheet1

Pupil |  | Subject |  |  | [NAME] |  | Subject Cell Ref
D_Smith |  | History |  |  | 1 | Pupil | 3 | Subject |  | Scores | Maths | English | Science | History
 |  |  |  |  |  | A_Smith |  | Maths |  | A_Smith | 0.66 | 0.89 | 0.56 | 0.12
 |  |  |  |  |  | B_Smith |  | English |  | B_Smith | 0.07 | 0.87 | 0.89 | 0.03
 |  |  |  |  |  | C_Smith |  | Science |  | C_Smith | 0.85 | 0.23 | 0.04 | 0.14
Score |  |  |  |  |  | D_Smith |  | History |  | D_Smith | 0.07 | 0.21 | 0 | 0
 |  |  |  |  |  | E_Smith |  |  |  | E_Smith | 0.78 | 0.47 | 0.01 | 0.31
 |  |  |  |  |  | [NAME] |  |  |  | [NAME] | 0.23 | 0.56 | 0.47 | 0.84
Spreadsheet: 880656d1728489299-formula-only-once-date-triggers-excel-help
Sheet: Sheet1

Year Start | 2025-01-01 00:00:00
Schedule | Ramp Up |  | Product | [NAME] | Initial Production Date
Month 1 | 0.25 |  | Blue | 100 | 2025-01-01 00:00:00
Month 2 | 0.5 |  | Red | 150 | 2025-02-01 00:00:00 |  | 0
Month 3 | 0.75 |  | Green | 200 | 2025-06-01 00:00:00 |  | 0 | 0 | 0 | 0 | 0
Month 4+ | 1
Spreadsheet: michelle_lokay__26617__imbalsumm0102
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 23742 | 28000 | 28926 | 29000
2 | 25772 | 24000 | 29350 | 28000
3 | 28925 | 29000 | 31218 | 33000
4 | 29195 | 29000 | 31373 | 33000
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
2001-01-31 00:00:00 |  | 2193759.63 |  | -1991340.89
2001-02-04 00:00:00
Spreadsheet: 165791d1341340053-vlookup-wanting-2nd-3rd-occurrence-etc-occurrences
Sheet: Occurrence Sheet

 |  |  |  |  | Password | 92DY89
 | Occurrences Sheet |  |  |  | Date
 | Agent Name |  |  |  | Last Occurrence
 |  |  |  |  | Days Since
 | Carryover (from Old Tracking System |  |  |  | Total Occurrences
 | .25 Occurrences
 | Date | Value
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
 | .50 Occurrences
 | Date
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
 | 1.00 Occurrences
 | Date
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
 | 2.00 Occurrences
 | Date
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: 37338d1235325188-average-if-statement-based-on-matching-condition-and-date-ranges-simjambra
Sheet: Sheet1

Average of Total | Years | Date
 | 2009 |  | Grand Total
Trainer | Jan | Feb
[NAME] | 0.8680555555555556 |  | 0.8680555555555556
Test | 1 |  | 1
Test2 |  | 0.6666666666666666 | 0.6666666666666666
Grand Total | 0.9120370370370371 | 0.6666666666666666 | 0.8506944444444444
Spreadsheet: 149363d1333880120-carry-rows-over-to-new-sheet-under-only-specific-circumstances-pointsheets
Sheet: Lookups

 | Cabinets | Electrical | Plumbing | Points
1207 | 99 | 31 | 31 | 38
1217 | 99 | 34 | 34 | 38
1227 | 99 | 31 | 31 | 38
1242 | 99 | 31 | 31 | 38
1250 | 99 | 31 | 31 | 38
1251 | 99 | 34 | 34 | 38
1261 | 99 | 34 | 34 | 38
1266 | 99 | 31 | 31 | 38
1271 | 99 | 34 | 34 | 38
1284 | 99 | 31 | 31 | 38
4105 | 79 | 32 | 32 | 36
4108 | 79 | 32 | 32 | 36
4118 | 79 | 32 | 32 | 36
4122 | 79 | 32 | 32 | 36
4127 | 79 | 32 | 32 | 36
4140 | 79 | 32 | 32 | 36
4162 | 79 | 32 | 32 | 36
6172 | 99 | 31 | 31 | 38
6176 | 99 | 31 | 31 | 38
6178 | 99 | 31 | 31 | 38
6956 | 79 | 32 | 32 | 36
8456 | 99 | 34 | 34 | 38
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Dec23-Dec29p

Pavilion
 | 2012-12-23 00:00:00 |  |  | Thru | 2012-12-29 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-12-23 00:00:00 | 2012-12-24 00:00:00 | 2012-12-25 00:00:00 | 2012-12-26 00:00:00 | 2012-12-27 00:00:00 | 2012-12-28 00:00:00 | 2012-12-29 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 41127d1239650130-search-column-and-list-all-occurances-of-value-offset-from-string-extract
Sheet: Sheet1

title1 | title 3 | bits 1 | room
1a |  | 1a | 123
Room | 123
xxxxx,
1b |  | 1b | 456
Room | 456
xxxxx,
xxxxx,
1c |  | 1c | 678
Room | 678
xxxxx,
xxxxx,
xxxxx,
xxxxx,
1f |  | 1f | 345
room | 345
xxxxxx
xxxxx
xxxxx
xxxxxx
2d |  | 2d | 654
room | 654
xxxx
Spreadsheet: 889771d1740682482-conditional-formatting-help-production-gantt-1
Sheet: Deneme Takip

Production date |  | 2025-01-01 00:00:00 |  | Week |  | 1
Order No | Product Code | Product Description | Color | piece | Customer | Planned date | Date of occurrence | Delay Day
1 | 10019911 | PLC9911/B, 28/415 Turtle Wax Embossed 28/415 [NAME], Carbon Free Black, 35% PCR |  |  |  | 2025-01-13 00:00:00 | 2025-03-15 00:00:00
2 | 565PK | 53/400 101ml PET Kavanoz, 17gr, [NAME] |  |  |  | 2025-01-29 00:00:00 | 2025-02-06 00:00:00
3 | 20034271 | 500ML PE ŞİŞE EST, 30 GRS |  |  |  | 2025-02-03 00:00:00 | 2025-02-09 00:00:00
4 | 20034271 | 500ML PE ŞİŞE EST, 30 GRS |  |  |  | 2025-02-08 00:00:00 | 2025-02-19 00:00:00
5 | 10014601 | [NAME] değil |  |  |  | 2025-02-01 00:00:00 | 2025-02-04 00:00:00
6 | 20014601 | Ø28 250ML, TEMİZLEYİCİ PP ŞİŞE, NATUREL, 23 GRS |  |  |  | 2025-02-02 00:00:00 | 2025-02-19 00:00:00
7 | 20014601 | Ø28 250ML, TEMİZLEYİCİ PP ŞİŞE, NATUREL, 23 GRS |  |  |  | 2025-02-04 00:00:00 | 2025-02-10 00:00:00
8 | 569PK | 53/400 168ml PET Kavanoz, 17gr, [NAME] |  |  |  | 2025-02-05 00:00:00 | 2025-02-15 00:00:00
9 | 571PK | 53/400 220ml PET Kavanoz, 17gr, [NAME] |  |  |  | 2025-02-03 00:00:00 | 2025-02-16 00:00:00
10 | 565PK | 53/400 101ml PET Kavanoz, 17gr, [NAME] |  |  |  | 2025-02-10 00:00:00 | 2025-02-17 00:00:00
12 | 20014601 | Ø28 250ML, TEMİZLEYİCİ PP ŞİŞE, NATUREL, 23 GRS |  |  |  | 2025-02-10 00:00:00 | 2025-02-18 00:00:00
13 | 20014601 | Ø28 250ML, TEMİZLEYİCİ PP ŞİŞE, NATUREL, 23 GRS |  |  |  | 2025-02-14 00:00:00 | 2025-02-22 00:00:00
14 | 153P | 24/410 150ml PET [NAME] Şişe, 19gr, [NAME] |  |  |  | 2025-02-14 00:00:00 | 2025-02-22 00:00:00
15 | 153P | 24/410 150ml PET [NAME] Şişe, 19gr, [NAME] |  |  |  | 2025-02-17 00:00:00 | 2025-02-25 00:00:00
16 | 2082P | 28/410, 460 ml, Burgulu Pet şişe, 48gr |  |  |  | 2025-02-23 00:00:00 | 2025-02-24 00:00:00
18 | 2690P | 28/410 400ml Desenli Hobby PET Sabun Şişesi, 27gr, Natürel |  |  |  | 2025-02-10 00:00:00 | 2025-02-17 00:00:00
19 | 10019911 | PLC9911/B, 28/415 Turtle Wax Embossed 28/415 [NAME], Carbon Free Black, 35% PCR |  |  |  | 2025-02-14 00:00:00 | 2025-02-15 00:00:00
20 | 2690P | 28/410 400ml Desenli Hobby PET Sabun Şişesi, 27gr, Natürel |  |  |  | 2025-02-14 00:00:00 | 2025-02-24 00:00:00
21 | 6310P | Ø28 Snap On 400ml PET Fax Şampuan Şişe, Sarı, 29gr |  |  |  | 2025-02-17 00:00:00 | 2025-02-25 00:00:00
22 | 5591P | 28/410 500ml PET KPS ŞİŞE, [NAME], 29gr |  |  |  | 2025-02-23 00:00:00 | 2025-02-24 00:00:00
24 | 10013520 | 28/410 Asda Bottle [NAME], Natural |  |  |  | 2025-01-29 00:00:00 | 2025-01-30 00:00:00
25 | 20031901 | 28/410 350ML Single Stripe HDPE Bottle, 27grs |  |  |  | 2025-01-30 00:00:00 | 2025-01-31 00:00:00
26 | 5725PG | [NAME] değil |  |  |  | 2025-01-31 00:00:00 | 2025-02-11 00:00:00
27 | 200350495 | 33Ø 1000ml HDPE Şişe, 55gr, Beyaz |  |  |  | 2025-02-01 00:00:00 | 2025-03-02 00:00:00
28 | 5725PG | [NAME] değil |  |  |  | 2025-02-02 00:00:00 | 2025-03-03 00:00:00
Spreadsheet: 143702d1330530050-assistance-wth-a-macro-log-for-excel-forum
Sheet: Quotes

Log
RECORD ENTRY DETAILS AND [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | PRODUCT / Other Details
Quote Reference | Eng. | Date in | Close Date | Date out | Rev. | Revision Date Out | VALUE | Validaty |  | Customer | Customer Country | [NAME]. | End user | End Country | End User Ref | Project |  | Content | [NAME] | Part Numbers
 |  |  |  |  |  |  | $
Spreadsheet: 698712d1602142161-formula-required-test
Sheet: Orders

Company | Sales Agent | %
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
ABC
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
DEF
GHI
GHI
GHI
GHI
GHI
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
JKL
Spreadsheet: f3703712-1433-4375-b038-db805f51a3dd
Sheet: 12b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending August 9, by product type and supermajor currency (value of all trades in millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency 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: 4b867adc-c8e3-4f0c-b2f5-e6d836218bf2
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 50. PERSONAL FINANCE COMMITMENTS, Summary: Australia ($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
Fixed loans ; |  |  | Original | A2414192W | 1975-10-01 00:00:00 | 2012-10-01 00:00:00 | 445 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Original | A2414193X | 1975-10-01 00:00:00 | 2012-10-01 00:00:00 | 445 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414194A | 1975-10-01 00:00:00 | 2012-10-01 00:00:00 | 445 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Seasonally Adjusted | A2414189J | 1975-10-01 00:00:00 | 2012-10-01 00:00:00 | 445 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Seasonally Adjusted | A2414190T | 1975-10-01 00:00:00 | 2012-10-01 00:00:00 | 445 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Seasonally Adjusted | A2414191V | 1975-10-01 00:00:00 | 2012-10-01 00:00:00 | 445 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Trend | A2414186A | 1975-10-01 00:00:00 | 2012-10-01 00:00:00 | 445 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Trend | A2414187C | 1975-10-01 00:00:00 | 2012-10-01 00:00:00 | 445 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Trend | A2414188F | 1975-10-01 00:00:00 | 2012-10-01 00:00:00 | 445 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 782965d1654480821-formula-macro-help-needed-please-testing-umbrella-sorted-for-publication-johnboy45-
Sheet: Umbrella scores

 | 4 | 5 | 9 | 5 | 5 | 6 | 12 | 8 | 18 |  | 12 |  |  | 18 | 18
 | 5 | 10 | 12 | 5 | 6 | 8 | 17 | 13 | 17 | 17 | 12 |  |  | 13 | 17
 | 7 | 12 | 12 | 5 | 8 | 9 | 15 |  | 13 | 13 | 15 |  |  | 13 | 21
 | 7 | 21 | 15 | 6 | 8 | 10 | 9 | 9 | 18 | 9 | 18
 | 8 |  |  | 8 | 9 | 11 |  |  | 11 | 21 | 11 | 17 | 11 | 21 | 17
 | 8 |  |  | 8 | 9 | 11 | 16 |  | 14 |  | 10 |  |  |  | 14
 | 9 |  |  | 9 | 9 | 11 | 9 |  | 20 |  | 16 | 16 | 5 | 16 | 9
 | 9 |  |  | 9 | 9 | 12 | 18 | 18 | 11 | 18
 | 9 |  |  | 9 | 10 | 12 | 18 | 8 | 18 |  | 8 | 12 |  |  | 18
 | 10 |  |  | 10 | 10 | 13 | 13 |  | 16 | 10 | 13 |  |  | 10 | 11
 | 10 |  |  | 10 | 11 | 14 | 9 | 4 |  |  | 17 | 17 | 12 | 12 | 4
 | 10 |  |  | 11 | 11 | 14 | 18 | 18 | 18 | 13 | 13 |  |  | 6 | 13
 | 12 |  |  | 11 | 11 | 17 | 16 | 16 | 11 | 9 | 16 | 13 | 13 | 11 | 13
 | 12 |  |  | 12 | 12 | 18 | 16 | 13 | 12 | 13 | 12 | 9 | 16 | 13 | 9
 | 13 |  |  | 12 | 12 | 19 | 13 |  | 12 |  | 20 |  |  | 12 | 13
 | 13 |  |  | 12 | 12 | 19 | 14 |  | 19 | 10 | 10 | 19 | 14
 | 14 |  |  | 13 | 13 | 20 | 20 | 11 | 11 | 10 | 20 |  |  | 13 | 20
 | 16 |  |  | 13 | 13 | 20 |  |  | 15 | 18 | 9 | 7 | 9 | 7 | 15
 | 17 |  |  | 13 | 13 | 21 | 15 | 13 |  |  | 8 |  |  | 15 | 8
 | 17 |  |  | 14 | 14 |  | 23 | 23 | 15 | 18 | 10 | 15 | 18 | 10 | 23
 | 18 |  |  | 15 | 14
 | 18 |  |  | 18 | 14 |  | 21 |  | 21 | 21 | 10 |  |  | 9 | 10
 | 19 |  |  | 22 | 15 |  | 26 |  | 14 | 26 | 12 |  |  | 9 | 14
 |  |  |  | 26 | 15 |  |  |  | 14 | 14 | 7 | 22 | 14 | 7 | 22
 |  |  |  |  | 16 |  | 15 |  | 14 | 14 | 5
 |  |  |  |  | 17 |  |  |  | 7 | 7 | 19 | 17 | 5 | 17 | 17
 |  |  |  |  | 18 |  | 13 |  | 24 | 24 | 8 |  |  | 8 | 6
 |  |  |  |  | 19 |  |  |  | 18 | 14 |  | 11 | 14
 |  |  |  |  | 21 |  |  |  | 18 | 16 |  | 16 | 16 | 18 | 18
 |  |  |  |  |  |  | 10 |  | 10 | 10 | 10 | 10 | 11 | 8 | 8
 |  |  |  |  |  |  | 16 | 16 | 11 | 10 | 10 | 21 | 10 | 21 | 21
12 highest  ranked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 highest  ranked
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12th value
Spreadsheet: 825274d1681220970-vlookup-n-a-error-wth
Sheet: Score Sheet

Name |  |  | MRN | Gender
Date of Testing:
Date of Birth:
Test Age:
Examiner:
Trails | Raw Score Time in Seconds | T Score | Percentile Rank | Descriptive Term
Trail 1
Trail 2
Trail 3
Trail 4
Trail 5
Composite | Sum of T Scores | Composite Index | Percentile Rank | Descriptive Term
Inhibitory Control Index (ICI)
Set-Shifting Index (SSI)
Total Composite Index (TCI)
Spreadsheet: 674310d1587750901-sum-total-past-due-invoices-from-a-list-of-clients-sum-client-total-invoices
Sheet: Sheet1

 | The goal is to write a formula in column P that separately sums the total Past Due invoice amounts in column M for each individual client
 |  |  |  |  |  |  |  |  |  |  |  |  | Wrong | Wrong
Cust # | Name | Invoice # | Inv date | Due date | Order # | Inv amt | Paid | Cr/Adj | Balance | Age Balance as of Today | Days Past Due | Past Due | Client | Total
16625 | XYZ Corp | 81624 | 2020-02-10 00:00:00 | 2020-03-11 00:00:00 | 48752 | 600 | 0 | 55312.4 | -55312.4
 |  | 81668 | 2020-02-28 00:00:00 | 2020-03-29 00:00:00 | 48112 | 375849 | 0 | 0 | 375849
Customer total |  | Ph |  |  | Fax |  |  |  | 320536.6
16704 | ABC Corp | 81560 | 2020-01-20 00:00:00 | 2020-02-19 00:00:00 | 48516 | 12266.2 | 0 | 0 | 12266.2 |  |  |  |  | 12266.2
 |  | 81599 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48711 | 0 | 0 | 1340 | -1340
 |  | 81600 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48713 | 0 | -1742.98 | 3317.76 | -1574.78
 |  | 81604 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48717 | 0 | 0 | 9097.02 | -9097.02
 |  | 81605 | 2020-01-31 00:00:00 | 2020-03-01 00:00:00 | 48718 | 0 | 0 | 254.4 | -254.4
 |  | 81681 | 2020-03-04 00:00:00 | 2020-04-03 00:00:00 | 47924 | 576175.56 | 0 | 0 | 576175.56
 |  | 81739 | 2020-03-27 00:00:00 | 2020-04-26 00:00:00 | 48854 | 1950 | 0 | 0 | 1950
 |  | 81746 | 2020-03-31 00:00:00 | 2020-04-30 00:00:00 | 48846 | 1447.55 | 0 | 0 | 1447.55
Customer total |  | PH |  |  | Fax |  |  |  | 3305.56 |  |  |  |  | 0
14300 | DFG Corp | 81641 | 2020-02-19 00:00:00 | 2020-02-19 00:00:00 | 48647 | 4141.18 | 0 | 0 | 4141.18 |  |  |  |  | 4141.18
 |  | 81720 | 2020-03-18 00:00:00 | 2020-03-18 00:00:00 | 48154 | 111438.26 | 0 | 0 | 111438.26
Customer total |  | PH |  |  | Fax |  |  |  | 115579.44
Spreadsheet: 83535d1283502443-how-can-i-extact-multiple-response-data-sample
Sheet: Sheet1

SN | Name | Gender | Age | Education | Occupation |  |  |  | Occupation
1 | a | M | 25 | 5 | 1 |  |  | 1 | Agriculture
2 | b | M | 45 | 5 | 2 |  |  | 2 | Civil Service
3 | c | F | 25 | 6 | 3 |  |  | 3 | Business
4 | d | M | 35 | 4 | 123
5 | e | F | 20 | 5 | 123 |  |  | 123 means, a single person is doing all three of those occupation: agriculture, civil service and business
6 | f | F | 36 | 6 | 23
7 | g | F | 42 | 2 | 13
 |  |  |  |  |  | From the above table, I want to draw following table. What is the easiest method for that?
 |  | Gender | M | F
 | 1 | Agriculture | 2 | 2
 | 2 | Civil Service | 2 | 2
 | 3 | Business | 1 | 4
 |  | Total | 5 | 8
Spreadsheet: 879238d1726680863-create-a-separate-workbook-that-holds-a-live-copy-of-one-sheet-shooting-team-record-dummy
Sheet: Individual Records

 |  |  |  |  |  |  |  |  | Doe, [NAME]
 |  | Date | Shoot | [NAME] | Score | % | Comment |  | Details
 |  |  | Competition Shoot | 25 | 10 | 0.4 |  |  | Year
 |  | 2024-09-18 00:00:00 | Competition Shoot | 25 | 10 | 0.4 | 0 |  | Year
 |  |  |  |  |  |  |  |  | Current Team
 |  |  |  |  |  |  |  |  | R/L Handed
 |  |  |  |  |  |  |  |  | Statistics
 |  |  |  |  |  |  |  |  | Number of Shoots
 |  |  |  |  |  |  |  |  | Best
 |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  | Competition Shoots
Spreadsheet: daren_farmer__5327__hpl0624
Sheet: Sheet1

HPLN0624.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 24 thru 26, 2000
 |  |  |  |  |  | ** Sat./Sun. | ** Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 6/24-6/25 | 2000-06-26 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 60  0900hrs | 0 | 0 to 60  0900hrs | *
 |  |  |  |  | 60  to 0 2100hrs |  | 60  to 0 2100hrs
 |  | Firm Summary
ENRON (S) |  | Oasis Turbine |  | ENA | 6 | 0 | 0 | *
ENRON (ES,S) |  | Oasis Sealy |  | ENA | 0 | 8 | 40 | *
ENRON (ES) |  | Texoma |  | ENA | 20 | 0 | 0 | *
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65 | 0.65
Empire (Enron) |  | Oasis Turbine |  | Empire | 7.95 | 7.95 | 7.95
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 698714d1602144546-vlookup-to-be-variable-by-month-example
Sheet: Feb-21

date | 2021-02-01 00:00:00 |  |  |  |  | 2021-02-02 00:00:00 |  |  |  |  | 2021-02-03 00:00:00 |  |  |  |  | 2021-02-04 00:00:00 |  |  |  |  | 2021-02-05 00:00:00
item | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 4 | 5
person 1 | 5 | 6 | 5 | 2 | 2 | 3 | 3 | 2 | 2 | 1 | 7 | 8 | 7 | 8 | 7 | 6 | 7 | 6 | 7 | 6 | 4 | 5 | 5 | 6 | 5
person 2 | 1 | 2 | 1 | 1 | 5 | 1 | 7 | 6 | 5 | 2 | 3 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 3 | 2 | 8 | 7 | 3 | 3 | 2
person 3 | 2 | 5 | 4 | 7 | 1 | 3 | 3 | 5 | 6 | 5 | 2 | 3 | 2 | 3 | 2 | 6 | 7 | 6 | 7 | 6 | 4 | 3 | 1 | 7 | 6
person 4 | 3 | 4 | 3 | 7 | 8 | 1 | 2 | 1 | 2 | 1 | 0 | 1 | 0 | 1 | 0 | 2 | 3 | 2 | 3 | 2 | 3 | 2 | 2 | 1 | 3
person 5 | 2 | 3 | 2 | 8 | 7 | 3 | 4 | 3 | 4 | 3 | 2 | 3 | 2 | 3 | 2 | 0 | 1 | 0 | 1 | 0 | 2 | 1 | 6 | 7 | 6
person 6 | 5 | 6 | 5 | 4 | 3 | 2 | 3 | 2 | 3 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 3 | 2 | 3 | 2 | 2 | 1 | 6 | 5 | 6
person 7 | 1 | 2 | 1 | 3 | 2 | 5 | 6 | 5 | 6 | 5 | 3 | 4 | 2 | 1 | 2 | 1 | 2 | 1 | 2 | 1 | 7 | 1 | 2 | 1 | 2
person 8 | 4 | 5 | 4 | 1 | 0 | 1 | 2 | 1 | 2 | 1 | 2 | 3 | 5 | 2 | 8 | 7 | 8 | 7 | 8 | 7 | 1 | 2 | 1 | 4 | 5
person 9 | 3 | 3 | 2 | 2 | 1 | 4 | 5 | 4 | 5 | 4 | 5 | 6 | 6 | 5 | 3 | 3 | 4 | 3 | 4 | 3 | 4 | 5 | 4 | 2 | 1
person 10 | 1 | 7 | 6 | 5 | 2 | 2 | 3 | 2 | 3 | 2 | 1 | 2 | 2 | 1 | 2 | 2 | 3 | 2 | 3 | 2 | 3 | 3 | 2 | 5 | 4
person 11 | 3 | 3 | 5 | 6 | 5 | 6 | 7 | 6 | 7 | 6 | 4 | 5 | 5 | 6 | 5 | 0 | 1 | 0 | 1 | 0 | 1 | 7 | 6 | 4 | 3
person 12 | 2 | 6 | 1 | 2 | 1 | 2 | 3 | 2 | 3 | 2 | 1 | 5 | 7 | 1 | 2 | 2 | 3 | 2 | 3 | 2 | 2 | 1 | 3 | 3 | 2
person 13 | 1 | 5 | 6 | 5 | 6 | 0 | 1 | 0 | 1 | 0 | 7 | 1 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 8 | 7 | 6 | 6 | 5
person 14 | 7 | 1 | 2 | 1 | 2 | 2 | 3 | 2 | 3 | 2 | 7 | 8 | 4 | 5 | 4 | 7 | 8 | 7 | 1 | 2 | 3 | 5 | 9 | 2 | 1
person 15 | 2 | 2 | 3 | 2 | 5 | 1 | 2 | 1 | 2 | 1 | 8 | 7 | 3 | 3 | 2 | 4 | 7 | 8 | 7 | 8 | 2 | 0 | 3 | 4 | 3