tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 377816d1424176622-sumproduct-more-than-one-condition-sample-1-
Sheet: In-Services 

In-Services 2015 |  |  |  |  |  |  |  |  |  | Total In-Services Attended | Percentage
In-Services Type |  |  |  |  | Planned | Planned | Unplanned | Unplanned | Planned
Staff Name |  | ID | Position | Saudi Commission ID | AB | BC | CD | ED | AD
1 | A |  |  |  | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00
2 | B |  |  |  | 2015-03-03 00:00:00 | 2015-03-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00
3 | A |  |  |  | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-02-04 00:00:00 | 2015-02-04 00:00:00 | 2015-02-04 00:00:00
4 | B |  |  |  | 2015-04-30 00:00:00 | 2015-04-30 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00
5 | A |  |  |  | 2015-05-29 00:00:00 | 2015-05-29 00:00:00 | 2015-02-02 00:00:00 | 2015-02-02 00:00:00 | 2015-03-03 00:00:00
6 | B |  |  |  | 2015-06-27 00:00:00 | 2015-06-27 00:00:00 | 2015-03-03 00:00:00 | 2015-03-03 00:00:00 | 2015-04-01 00:00:00
7 | A |  |  |  | 2015-07-26 00:00:00 | 2015-02-02 00:00:00 | 2015-04-01 00:00:00 | 2015-04-01 00:00:00 | 2015-04-30 00:00:00
8 | B |  |  |  | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-04-30 00:00:00 | 2015-04-30 00:00:00 | 2015-05-29 00:00:00
9 | A |  |  |  | 2015-02-04 00:00:00 | 2015-02-04 00:00:00 | 2015-05-29 00:00:00 | 2015-05-29 00:00:00 | 2015-06-27 00:00:00
10 | B |  |  |  | 2015-02-02 00:00:00 |  | 2015-06-27 00:00:00 | 2015-06-27 00:00:00 | 2015-02-02 00:00:00
11 | A |  |  |  | 2015-02-03 00:00:00 | 2015-02-05 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00 | 2015-02-03 00:00:00
12 | B |  |  |  | 2015-02-04 00:00:00 | 2015-02-04 00:00:00 | 2015-02-04 00:00:00 |  | 2015-02-04 00:00:00
Total Staff |  | Total Staff Attended |  |  |  |  |  |  |  | Total # of session
 |  | Total In-Services Sessions |  |  |  |  |  |  |  | Planned
 |  | Percentage Staff Attended |  |  |  |  |  |  |  | unplanned
 |  |  | 2015-01-01 00:00:00 | Planned
 |  |  | 2015-02-01 00:00:00 | Unplanned
 |  |  | 2015-03-01 00:00:00
 |  |  | 2015-04-01 00:00:00
 |  |  | 2015-05-01 00:00:00
 |  |  | 2015-06-01 00:00:00
 |  |  | 2015-07-01 00:00:00
 |  |  | 2015-08-01 00:00:00
 |  |  | 2015-09-01 00:00:00
 |  |  | 2015-10-01 00:00:00
 |  |  | 2015-11-01 00:00:00
 |  |  | 2015-12-01 00:00:00
 |  |  | 2015-12-31 00:00:00
 |  |  |  |  |  |  |  |  |  | Total in-service per month
 | Unit's CI |  | Lecture
 | Unit's Staff |  | Skills Lab/Skills Review
 | NED Staff |  | Bedside Teaching
 | KFMC Staff |  | Poster Board
 | OutSide KFMC Staff |  | Self Study Module
 |  |  | Equipment Demonstration
 | HN |  | Simulation
 | CN |  | Case Study
 | SN1 |  | Video
 | SN2 |  | Group Discussion
 | SN3 |  | Mind Map/ Decision Tree
 | Planned |  | Role Play
 | Unplanned |  | Hands on
Spreadsheet: 126688d1319824254-excel-2007-grouping-cells-with-similar-values-test
Sheet: Sheet2

18 | 100 | M
18 | 300 | L
18 | 400 | L
18 | 500 | L | Problem
18 | 550 | M
18 | 600 | L
18 | 700 | L
21 | 100 | M
21 | 200 | L
21 | 300 | L | Problem
21 | 400 | L
21 | 500 | L
21 | 600 | L
27 | 100 | M
27 | 200 | L | Problem
27 | 300 | L
27 | 400 | L
20 | 100 | M
20 | 200 | L
20 | 300 | L
20 | 400 | L
20 | 500 | L
20 | 600 | L
24 | 100 | M
24 | 300 | L
24 | 400 | L
24 | 500 | L
24 | 550 | M
24 | 600 | L
24 | 700 | L
25 | 100 | M
25 | 200 | L
25 | 300 | L
25 | 400 | L
26 | 100 | M
26 | 300 | L
26 | 400 | L
26 | 500 | L
26 | 550 | M
26 | 600 | L
26 | 700 | L
Spreadsheet: 467059d1466544259-conditional-format-calendar-5-5-2-2
Sheet: Jan

 |  |  |  |  |  |  |  |  | Select Year: | 2016
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  |  | Notes:
Spreadsheet: 152735d1335497666-select-cell-based-upon-hlookup-result-test-7-
Sheet: Sheet1

 | 2011-01-01 00:00:00 |  | 2011-02-01 00:00:00 |  | 2011-03-01 00:00:00 |  | 2011-04-01 00:00:00 |  | 2011-05-01 00:00:00 |  | 2011-06-01 00:00:00 |  |  | 2011-05-01 00:00:00
 | 1 | 9 | 1 | 9 | 1 | 9 | 1 | 9 | 34 | 87 | 1 | 9
 | 2 | 8 | 2 | 8 | 2 | 8 | 2 | 8 | 56 | 12 | 2 | 8 |  |  | This HLOOKUP returns cell J11. (Shaded yellow)
 | 3 | 7 | 3 | 7 | 3 | 7 | 3 | 7 | 76 | 76 | 3 | 7 |  |  | I want it to return cell K11. (Shaded green)
 | 4 | 6 | 4 | 6 | 4 | 6 | 4 | 6 | 83 | 34 | 4 | 6 |  |  | I understand that the merged header cell is the problem.
 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 45 | 49 | 5 | 5
 | 6 | 4 | 6 | 4 | 6 | 4 | 6 | 4 | 12 | 62 | 6 | 4
 | 7 | 3 | 7 | 3 | 7 | 3 | 7 | 3 | 34 | 32 | 7 | 3
 | 8 | 2 | 8 | 2 | 8 | 2 | 8 | 2 | 65 | 71 | 8 | 2
 | 9 | 1 | 9 | 1 | 9 | 1 | 9 | 1 | 23 | 27 | 9 | 1
Spreadsheet: 54427d1254404735-conditional-formatting-with-standard-deviations-sample-sheet
Sheet: Sheet1

Company Standard | 0.47
 |  | Standard - STD | Standard + STD
Standard Deviation 1 | 0.8 | -0.3300000000000001 | 1.27
Standard Deviation 2 | 0.5 | -0.03000000000000003 | 0.97
Range |  |  |  |  |  |  |  |  |  |  |  |  |  | BLUE
1.4 | 1.3 | 1.2 | 1.1 | 1 | 0.9 | 0.8 | 0.7 | 0.6 | 0.5 | 0.4 | 0.3 | 0.2 | 0.1 | 0 | -0.1 | -0.2 | -0.3 | -0.4 | -0.5 | -0.6
Spreadsheet: darrell_schoolcraft__7819__imbalsumm0109
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 510378 | 512919
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 393940 | 491123 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 300608 | 363457
500293 | 207674 | 306247
500302 |  | 5709
500303 | 112693 | 167116
500305 | 529399 | 659343
500307 | 25385 | 28583
500313 |  | 1359
500314
500655 | 335735
500657 | 77927 | 46000
INDEX
2001-08-31 00:00:00 |  |  | -6642.45
2001-09-15 00:00:00
CBS Volume
 |  |  | -37836
Spreadsheet: 123253d1317432569-calculating-percent-of-one-field-over-the-sum-of-another-coloraggres
Sheet: aggregated

school | year | gender | StudentCount | Color | ColorCount |  | % of Students Selecting each Color
ABC | 2008 | Female | 7 | Green | 7 |  |  | These are the percents I'd like to calculate in the pivot table.
ABC | 2008 | Female | 7 | Blue | 5
ABC | 2008 | Female | 7 | Red | 2
ABC | 2008 | Male | 8 | Green | 8
ABC | 2008 | Male | 8 | Blue | 5
ABC | 2008 | Male | 8 | Red | 3
XYZ | 2008 | Female | 1 | Green | 1
XYZ | 2008 | Female | 1 | Blue | 1
XYZ | 2008 | Male | 1 | Red | 1
XYZ | 2008 | Male | 1 | Blue | 1
How to read StudentCount: |  |  |  |  |  |  | school | gender | Color | Data | Total
- there are 7 females in ABC in year 2008 |  |  |  |  |  |  | ABC | Female | Green | Sum of ColorCount | 7 |  | How to calculate Sum of ColorCount / Sum of StudentCount?
- there are 8 males in ABC in year 2008 |  |  |  |  |  |  |  |  |  | Sum of StudentCount | 7
- etc. |  |  |  |  |  |  |  |  | Blue | Sum of ColorCount | 5
 |  |  |  |  |  |  |  |  |  | Sum of StudentCount | 7
How to read ColorCount: |  |  |  |  |  |  |  |  | Red | Sum of ColorCount | 2
- 7 out of the 7 females in ABC in 2008 selected Green |  |  |  |  |  |  |  |  |  | Sum of StudentCount | 7
- 5 out of the 7 females in ABC in 2008 selected Blue |  |  |  |  |  |  |  | Male | Green | Sum of ColorCount | 8
- etc. |  |  |  |  |  |  |  |  |  | Sum of StudentCount | 8
 |  |  |  |  |  |  |  |  | Blue | Sum of ColorCount | 5
 |  |  |  |  |  |  |  |  |  | Sum of StudentCount | 8
 |  |  |  |  |  |  |  |  | Red | Sum of ColorCount | 3
 |  |  |  |  |  |  |  |  |  | Sum of StudentCount | 8
 |  |  |  |  |  |  | XYZ | Female | Green | Sum of ColorCount | 1
 |  |  |  |  |  |  |  |  |  | Sum of StudentCount | 1
 |  |  |  |  |  |  |  |  | Blue | Sum of ColorCount | 1
 |  |  |  |  |  |  |  |  |  | Sum of StudentCount | 1
 |  |  |  |  |  |  |  | Male | Blue | Sum of ColorCount | 1
 |  |  |  |  |  |  |  |  |  | Sum of StudentCount | 1
 |  |  |  |  |  |  |  |  | Red | Sum of ColorCount | 1
 |  |  |  |  |  |  |  |  |  | Sum of StudentCount | 1
Spreadsheet: 215169d1361294419-finding-exact-number-match-in-column-if-no-match-remove-one-number-and-check-next-column-v0idern
Sheet: Sheet1

1 | 1 | 1 | 1 | 1 | 1 | 1 | 65126548
12 | 123 | 1232 | 65126 | 123456 | 1234567 | 65126548
67 | 333 | 6512 | 14567 | 567890 | 2345678 | 12356789
53 | 653 | 2222 | 55555 | 456432 | 6512654 | 76543276
41 | 651 | 3333 | 55555 | 651265 | 7654329 | 19875643
65
Spreadsheet: 219167d1362676360-mulitple-currency-calculation-quotelog
Sheet: Diptronic

Exchange rate | USD | 1.47
Exchange rate | EUR | 1.13
Exchange rate | GBP | 1
Customer | Contact | Rep | Date | Month | Part | Manufacturer | Quantity | Currency sale | Sale price | Currency Cost | Cost | Sales value | Profit £
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | USD | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | USD | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | EUR | 2 | GBP | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | USD | 2 | GBP | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
[NAME] | [NAME] | BB | 2013-03-07 00:00:00 | [NAME] | ACB123 | ABC | 100 | GBP | 2 | EUR | 1
Spreadsheet: 63511d1264435240-creating-a-minidatabase-of-companies-more-than-one-attribute-sample
Sheet: Sheet1

Company Name | Research methods | Sector Covered
Blue Heron | Primary | All
Clear Forest | Primary | Healthcare
 | Secondary
 | Net Expert
Connotate Technologies | Net Expert | Technology
 |  | Healthcare
 |  | Automotives
 |  | Electronics
Domonios | Secondary | Automotives
 | Net Expert
Spreadsheet: 789856d1659410739-displaying-wrong-result-while-using-let-function-let-function
Sheet: Result

 | [NAME] used
Lookup range | < data to pulled> |  |  |  | Expected Result |  | Lookup range
856964 |  | New Yrk |  |  | RAM | Denmark | 856964
652364 | AB | Austria |  |  | [NAME] | UK | 652364
8965412 | DK | Canada |  |  | AB | Austria | 8965412
364564 | RAM | Denmark |  |  | DK | Switzerland | 364564
Spreadsheet: 181fd2d5-b923-45f2-ba3d-dbbd79badfa3
Sheet: 2008-09

Table Q
Full Time Affiliate Student numbers
Department | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Anthropology | 2 | 9 |  | 0 | 0
Institute of Archaeology | 0 | 2 |  | 1 | 2
Bartlett School of Architecture | 0 | 3 |  | 1 | 0
Bartlett School of Planning | 2 | 4 |  | 5 | 0
Biochemical Engineering | 3 | 4 |  | 0 | 0
Division of Biosciences | 0 | 18 |  | 0 | 0
Centre for Intercultural Studies | 0 | 0 |  | 2 | 0
Chemical Engineering | 10 | 7 |  | 2 | 0
Chemistry | 2 | 5 |  | 0 | 0
Institute of Child Health | 0 | 4 |  | 2 | 1
Civil, Environmental and Geomatic Eng. | 3 | 6 |  | 2 | 0
Computer Science | 5 | 4 |  | 2 | 1
[NAME] and Literature | 6 | 0 |  | 2 | 0
Earth Sciences | 1 | 1 |  | 0 | 0
Eastman Dental Institute | 0 | 0 |  | 8 | 5
Economics | 0 | 65 |  | 4 | 0
Electronic and Electrical Engineering | 2 | 3 |  | 0 | 1
English Language and Literature | 1 | 27 |  | 0 | 0
European Social and Political Studies | 7 | 2 |  | 0 | 0
Slade School of Fine Art | 4 | 7 |  | 0 | 1
French | 28 | 6 |  | 0 | 0
[NAME] Unit | 0 | 0 |  | 0 | 1
Geography | 7 | 4 |  | 1 | 0
German | 14 | 2 |  | 1 | 0
Greek and Latin | 4 | 3 |  | 1 | 0
History | 12 | 24 |  | 6 | 1
History of Art | 3 | 9 |  | 0 | 0
Division of Infection and Immunity | 0 | 1 |  | 0 | 0
Italian | 26 | 0 |  | 1 | 0
Language Centre (Affiliates) | 3 | 188 |  | 0 | 0
Laws | 52 | 7 |  | 24 | 3
Management Science and Innovation | 1 | 0 |  | 0 | 0
Pre-Clinical Studies | 1 | 0 |  | 0 | 0
Mathematics | 2 | 5 |  | 0 | 0
Mechanical Engineering | 0 | 5 |  | 0 | 1
Division of Medicine | 0 | 0 |  | 1 | 1
Philosophy | 1 | 12 |  | 0 | 0
Physics and Astronomy | 2 | 4 |  | 0 | 0
Political Science | 0 | 25 |  | 1 | 1
Division of Psychology and Language Sciences | 6 | 41 |  | 2 | 0
Scandinavian Studies | 8 | 0 |  | 0 | 0
School of Slavonic and E. European Stds | 17 | 4 |  | 3 | 0
Science and Technology Studies | 0 | 2 |  | 0 | 0
Space and Climate Physics | 0 | 0 |  | 0 | 1
Spanish and Latin American Studies | 10 | 3 |  | 0 | 0
Statistical Science | 4 | 0 |  | 0 | 1
Total
Faculty | Undergraduate |  |  | Graduate |  |  | Total
 | Home | Overseas | Total | Home | Overseas | Total
Arts and Humanities | 112 | 250 |  | 7 | 1
Biomedical Sciences |  | 5 |  | 11 | 7
Built Environment | 2 | 7 |  | 6 | 0
Engineering Sciences | 24 | 29 |  | 6 | 3
Laws | 52 | 7 |  | 24 | 3
Life Sciences | 7 | 59 |  | 2 | 1
Mathematical and Physical Sciences | 11 | 17 |  | 0 | 2
Social and Historical Sciences | 41 | 142 |  | 16 | 4
Total
As figures relate to the official HEFCE census date, 1 December, affiliate students who start in January are not included.
Spreadsheet: 754366d1636126438-30-day-moving-total-starting-with-today-sums-based-on-dates-and-weeknumbers-barksato-
Sheet: summary

2021-10-26 00:00:00 | Example report run on 10/26/2021, a Tuesday |  |  |  |  |  |  |  |  |  | 30 Day Moving Total Starting with Today (excelforum.com)
 | Tracking 2 points of data. If person was at work (yes=1). If person submitted report (yes=1)
 | This Week |  | Last Week |  | This Month |  | 30day Moving average |  | This Quarter |  | Last Quarter |  | This Year |  | Last Year |  | 2 Years Ago |  | Project Total
 | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | % | # Reports | %
Spreadsheet: 877062d1723732182-calculated-item-in-pivot-table-returning-unexpected-rows-calculated_item_example-foxsmolder-
Sheet: data

 | State | Program | Element | Actual | Budget | State Program
 | Ohio | Little Leaguers | Revenue | 15777 | 15000
 | Ohio | Little Leaguers | Cost | 4955 | 5000
 | Ohio | Hotdoggers | Revenue | 16509 | 15000
 | Ohio | Hotdoggers | Cost | 4875 | 5000
 | Indiana | [NAME] | Revenue | 13565 | 15000
 | Indiana | [NAME] | Cost | 4588 | 5000
 | Indiana | Underhanders | Revenue | 9100 | 15000
 | Indiana | Underhanders | Cost | 3600 | 5000
Spreadsheet: 681158d1591372097-pulling-entries-depending-on-criteria-to-create-a-summary-meeting-minutes
Sheet: Minutes

Management Review Meeting Minutes
Item |  |  | Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
Note |  |  | topic 1
Decision |  |  | Topic 2
Note |  |  | Topic 3
<Item>
<Item>
Item |  |  | Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
Note |  |  | topic 1
Note |  |  | Topic 2
Note |  |  | Topic 3
<Item>
<Item>
<Item>
Item |  |  | Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
Note |  |  | topic 1
Note |  |  | Topic 2
Decision |  |  | Topic 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
<Item>
<Item>
<Item>
Item |  |  | Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
Note |  |  | topic 1
Task |  |  | Topic 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Task |  |  | Topic 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ted
<Item>
<Item>
<Item>
Item |  |  | Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
Note |  |  | topic 1
Task |  |  | Topic 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Note |  |  | Topic 3
<Item>
<Item>
<Item>
Item |  |  | Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
<Item>
<Item>
<Item>
<Item>
<Item>
<Item>
<Item>
Item |  |  | Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
<Item>
<Item>
<Item>
<Item>
<Item>
<Item>
Item |  |  | Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
<Item>
<Item>
<Item>
<Item>
<Item>
<Item>
Item |  |  | Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
Note |  |  | topic 1
Decision |  |  | Topic 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Task |  |  | Topic 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
<Item>
<Item>
<Item>
Item |  |  | Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
<Item>
<Item>
<Item>
<Item>
<Item>
<Item>
Parking Lot / Tangents
Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Action
Summary
Decisions
Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
Tasks/Action Items
Topic |  |  |  |  | Details |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Who |  | Due Date
Spreadsheet: 45328d1244090909-nesting-vlookup-in-if-vice-versa-and-pivot-table-copy-of-sample-model-cat1-cat2-ytd
Sheet: Feb Summary

Model | Year-to-Date: Cat1 | Year-to-Date: Cat2 | Total YTD
500 | 824.71 |  | 824.71
750 | -2467.829620000004 |  | -2467.829620000004
900 | -2669.357555600005 |  | -2669.357555600005
AB | -1443.1102088 |  | -1443.1102088
AD | -53.8898 |  | -53.8898
AG | -63.58996399999999 |  | -63.58996399999999
AL | -1523.33 |  | -1523.33
AN | -1797.5294 |  | -1797.5294
BX | -8842.635900000001 |  | -8842.635900000001
BZ | -7039.132799999999 |  | -7039.132799999999
CA | -4014.1539 |  | -4014.1539
CB | -877.04125 |  | -877.04125
DE | -1471.4364 |  | -1471.4364
DF | 0 |  | 0
DS | 0 |  | 0
DV | -4460.2879 |  | -4460.2879
DX | -3484.0798 |  | -3484.0798
FA | 0 |  | 0
GL | -2868.781915198807 |  | -2868.781915198807
GM | -221.0269653693443 |  | -221.0269653693443
MF | -1646.582489341475 |  | -1646.582489341475
MR | -20226.46215053684 |  | -20226.46215053684
OA | -715.5376707607675 |  | -715.5376707607675
OB | -268.7207781562057 |  | -268.7207781562057
OR | -337.5699915762351 |  | -337.5699915762351
RA | -565.1764208362113 |  | -565.1764208362113
RF | -10622.17550350159 |  | -10622.17550350159
TM | -61.21638142096588 |  | -61.21638142096588
ZP | -591.955380684333 |  | -591.955380684333
Grand Total | -77507.90014578278 | 0 | -77507.90014578278
Spreadsheet: 832544d1686414117-value-error-in-my-if-and-formula-test-book
Sheet: Data Entry

Date | Day Of Week | Symbol | Index | Market Condition | Time In | Time Out | Total Time In Trade | Shares | Type | Timeframe | [NAME] | Sub Trigger | Entry Price | Cost Of Trade | Stop Price | Stop Size | If Stop Loss | Exit Price | Hold To Target | Slippage | P&L | R Realized | R Unrealized | EOD Close Price | EOD P&L | 1R P&L | 2R P&L | 3R P&L | 4R P&L | 5R P&L | 6R P&L | 7R P&l | 8R P&L | 9R P&L | 10R P&L | Notes | Link
2023-06-09 00:00:00 | Friday | CRM | NYSE | Bearish | 07:49:00 | 07:50:00 |  | 40 | Short | 1 Minute | [NAME] | 50% Retrace | 216.2 |  | 216.46 |  |  | 215.88 | No |  |  | 1 | 4 | Stopped |  |  |  |  |  |  |  |  |  |  |  |  | Trade screenshots\2023-06-09\CRM 2023-06-09 Win.pdf
2023-06-09 00:00:00 | Friday | CVNA | NYSE | Bearish | 08:13:00 | 08:21:00 |  | 15 | Short | 2 Minute | [NAME] | Secondary Price Resistance | 22.39 |  | 23.06 |  |  | 22.26 | No |  |  | 0 | 5 | 19.17 |  |  |  |  |  |  |  |  |  |  |  |  | Trade screenshots\2023-06-09\CVNA 2023-06-09 Win.pdf
2023-06-09 00:00:00 | Friday | AMD | NASDAQ | Bullish | 10:04:00 | 10:10:00 |  | 47 | Long | 1 Minute | Buy Setup | Return To 21MA Support | 124.44 |  | 124.21 |  |  | 124.87 | Yes |  |  | 2 | 5 | 124.87 |  |  |  |  |  |  |  |  |  |  |  |  | Trade screenshots\2023-06-09\AMD 2023-06-09 Win.pdf
 |  |  |  |  |  |  |  | 10 | Long |  |  |  | 100 |  | 99.5 |  |  | 99.49 |  |  |  |  |  | Stopped
 |  |  |  |  |  |  |  | 10 | Short |  |  |  | 100 |  | 100.34 |  |  | 99.14 |  |  |  |  |  | 97.22
Spreadsheet: 840779d1692978065-problem-with-using-and-manipulating-times-demo-time-aligw
Sheet: Worksheet

Drive | # of Plays | Time SOD | T EOD | Total time |  | # of Plays |  | Should be C | Should be D | Should be E
1 |  |  |  |  |  |  |  | 15:00:00 | 13:35:00
 |  |  |  |  |  |  |  | 09:18:00 | 05:24:00
 |  |  |  |  |  |  |  | 03:05:00 | 02:23:00
 |  |  |  |  |  |  |  | 14:08:00 | 13:11:00
 |  |  |  |  |  |  |  | 10:15:00 | 09:08:00
 |  |  |  |  |  |  |  | 05:03:00 | 04:36:00
 |  |  |  |  |  |  |  | 02:55:00 | 01:55:00
 |  |  |  |  |  |  |  | 10:49:00 | 10:25:00
 |  |  |  |  |  |  |  | 08:04:00 | 06:31:00
 |  |  |  |  |  |  |  | 01:27:00 | 00:12:00
 |  |  |  |  |  |  |  | 10:01:00 | 08:44:00
 |  |  |  |  |  |  |  | 07:36:00 | 06:51:00
 |  |  |  |  |  |  |  | 05:48:00 | 03:32:00
 |  |  |  |  |  |  |  | 01:42:00 | 00:16:00
Spreadsheet: 755936d1637186566-non-vba-textjoin-alternative-for-ms-2016-sample-data
Sheet: Sheet2

 | Consolidated Account # | sub
 | 7400-0000 | 755000-730, 712000-730, 731000-730
 | 7400-0100 | 732000-730
 | 7400-0200 | 706000-730
 | 7400-0400 | 703000-730, 705000-730
 | 7400-0700 | 702000-730
 | 7400-1100 | 713000-730, 750000-730, 751000-730, 752000-730, 753000-730, 754000-730, 762000-730, 765000-730, 766000-730, 767000-730, 768000-730, 768100-730, 769000-730
 | 7400-1120 | 609000-730
 | 7400-3000 | 800000, 880000
 | (blank) | 723000-730, 700000-730, 701700-730, 710000-730, 710600-730, 711500-730, 711000-730, 730000-730, 782000-730, 780000-730, 781000-730, 783000-730, 784000-730, 701600-730, 760000-730
Spreadsheet: tracy_geaccone__40248__C0366-111726
Sheet: Dept_100158

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
RECORDS/INFO MGMT - Dept. 100158
January, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Requisitioner Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111726
2001-01-24 00:00:00 | PHN2001/01-0366/111726 |  | Work Place | Work Place Count | 4 | 3.75 | /MO | 15
 |  |  |  |  |  |  | Ticket Total |  | 15
 |  |  |  |  |  |  | Total for R/C: 111726 |  | 15
 |  |  |  |  |  |  | Total for Dept_100158 |  | 15