tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 880960d1728843608-aspect-of-data-valuation-ive-no-idea-how-to-execute-im-not-a-vba-user-dynamic-data-valuation__3
Sheet: Sheet1

 |  |  |  |  | New | Yes
 | New Member |  |  |  | Member | No
 | Initiation Fee |  | Payments
 |  |  |  |  | Initiation Fee | 1 | N/A
 |  |  |  |  |  | 3
 | in above:  At $C$3 the drop down list selection is "Yes"
 | When $C$3 selection is "Yes , Then I want the drop down for $C$4 to be as shown at $[NAME]
 | When the "$C$3" drop down list selection is "No"
 | I'm sure I'm not saying the following in the best eXcel the best descriptive terms…
 | I want the drop down for $C$4 to effectively be void/disappear…
 | and the spreadsheet response to $C$3 equal to "No" at $C$4 to always be "N/A"
 | If $C$3 is a "Yes", then $C$4 drop down is in effect (as shown in rows 2 thru 10
 | If $C$3 is a "No", then I want $C$4 to have the fixed/singular response = "N/A"
 | Thank You in advance…
 |  |  |  |  | New | Yes
 | New Member | No |  |  | Member | No
 | Initiation Fee | N/A | Payments
Spreadsheet: 125389d1319009328-excel-2007-common-finder-ex3-bc2
Sheet: Round 2

 | Common A | Common B
 | 48 | 60
Answer
#[NAME] | Counter | Common A | Common B | Check | Counter |  |  | Possible Solutions |  |  |  | Checks
0 |  |  |  |  |  |  |  | Lower | Mid | Upper |  | Check 1 | Check 2
 | 1
Spreadsheet: 864457d1711626777-conditional-formatting-number-of-days-remaining-trm
Sheet: Training Matrix

 |  |  |  |  |  |  |  |  |  |  |  |  |  | E - Learning (Training Hub)
Name | Role | Start Date |  |  |  | Induction | Model | Face to face Safeguarding training | First Aid (Face to Face) | [NAME] | Reporting & Recording (Face to Face) | Team Teach level 2 | [NAME] (Children's Homes) | Child Sexual Exploitation (Children's Homes) | COSHH (Children's Homes) | Emergency First Aid (Children's Homes) | Equality, Diversity & Cultural Competence (Children's Homes) | Female Genitle Mutilation (Children's Homes) | Fire Safety (Children's Homes) | First Aid Pediatric (Children's Homes) | Food Safety & Hygiene Foundation (Children's Homes) | Food Safety Advanced (Children's Homes) | GDPR (Children's Homes) | General Data Protection Regulations (GDPR) Office Based Employee | General Data Protection Regulation's (Children's Homes) | Health & Nutrition (Children's Homes) | Health & Safety (Childrens Homes) | Health & Safety Advanced (Children's Homes) | Infection Control (Children's Homes) | Internet Safety (Children's Homes) | [NAME] (Children's Homes) | Medication Foundation (Children's Homes) | Medication Advanced (Children's Homes) | Psychological First Aid Supporting Children and Young People (Children's Homes) | Radicalisation and Extremism (Children's Homes) | Reporting & Recording (Children's Homes) | Reporting & Recording Advanced (Children's Homes) | Risk Management & Safer Caring (Children's Homes) | Safeguarding Adult's Level 1 (Children's Homes) | Safeguarding Adult's Level 2 (Children's Homes) | Safeguarding Children Level 1 (Children's Homes) | Safeguarding Children Level 2 (Children's Homes) | Safeguarding Children with Learning Disabilities (Children's Homes) | Self Harming Behaviours (Children's Homes) | PREVENT.GOV
 |  |  |  |  |  |  | 2023-02-27 00:00:00
Spreadsheet: 725081d1616520300-formula-needed-for-several-scenerios-summary-report
Sheet: Aug-20

 | Month: | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | New Credits
 | SC | SC Name | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | Total |  |  | Pre-Invoice Amounts | ECR Applied | Invoice Amts
Prior/Current | 1234 | Example Name | 0 | 0 | 9893.05 | 2015.04 | 11294.35 | 2364.01 | 1271.04 | 340.55 | 173.86 | 1001.09 | 1265.51 | 182.52 |  |  |  |  | 2376.92
Prior/Current | 2345 | Example Name | 0 | 0 | 0 |  | 2954.9 | 2002.86 | 65.53 | 62.55 | 124.65 | 77.4 | 34.86 | 33.56 |  |  |  |  | 1161.21
Prior/Current | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 87983.13 | 15395.92 | 639.64 | 158.82 |  |  |  |  | 7933.19
Prior/Current | 4567 | Example Name | 0 | 0 | 0 | 0 | 1619.58 | 868.01 | 325.14 | 221.6 | 305.99 | 30.8 | 482.43 | 180.97 |  |  |  |  | 817.18
Prior/Current | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1386.76 |  |  |  |  | 16435.99
Prior/Current | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 623.02 |  |  |  |  | 8093.64
Prior/Current | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 16325 | 463.06 | 373.47 | 651.22 |  |  |  |  | 2213.59
Prior/Current | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 683.71 |  |  |  |  | 4216.44
Prior/Current | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 82618.52 | 76.31 | 67.07 | 48.32 |  |  |  |  | 1224.82
Prior/Current | 9013 | Example Name | 0 | 0 | 0 | 0 |  | 262.17 | 2214.81 | 245.23 | 262.39 | 563.85 | 2676.81 | 560.99 |  |  |  |  | 2516.74
Used | 1234 | Example Name | 0 | 0 | -2376.92 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 2345 | Example Name | 0 | 0 | 0 | 0 | -1161.21 | 0 | 0 | 0 | 0 | 0 | 0
Used | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7933.19 | 0 | 0
Used | 4567 | Example Name | 0 | 0 | 0 | 0 | 817.18 | 0 | 0 | 0 | 0 | 0 | 0
Used | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2213.59 | 0 | 0
Used | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1224.82 | 0 | 0
Used | 9013 | Example Name | 0 | 0 | 0 | 0 | -262.17 | -2214.81 | -39.76 | 0 | 0 | 0 | 0
Remaining/Carried Forward | 1234 | Example Name | 0 | 0
Remaining/Carried Forward | 2345 | Example Name | 0 | 0
Remaining/Carried Forward | 3456 | Example Name | 0 | 0
Remaining/Carried Forward | 4567 | Example Name | 0 | 0
Remaining/Carried Forward | 5678 | Example Name | 0 | 0
Remaining/Carried Forward | 6789 | Example Name | 0 | 0
Remaining/Carried Forward | 7890 | Example Name | 0 | 0
Remaining/Carried Forward | 8901 | Example Name | 0 | 0
Remaining/Carried Forward | 9012 | Example Name | 0 | 0
Remaining/Carried Forward | 9013 | Example Name | 0 | 0
Spreadsheet: 700271d1603107405-sorting-mixed-list-into-two-separate-lists-index-small-if-example-2
Sheet: Source Data

 | Employee 1 | Casual
 | Employee 2 | Regular
 | Employee 3 | Casual
 | Employee 4 | Regular
 | Employee 5 | Casual
 | Employee 6 | Regular
 | Employee 7 | Casual
 | Employee 8 | Regular
 | Employee 9 | Casual
 | Employee 10 | Regular
 | Employee 11 | Casual
 | Employee 12 | Regular
 | Employee 13 | Casual
 | Employee 14 | Regular
 | Employee 15 | Casual
 | Employee 16 | Regular
 | Employee 17 | Casual
 | Employee 18 | Regular
 | Employee 19 | Casual
 | Employee 20 | Regular
 | Employee 21 | Casual
 | Employee 22 | Regular
 | Employee 23 | Casual
 | Employee 24 | Regular
 | Employee 25 | Casual
 | Employee 26 | Regular
 | Employee 27 | Casual
 | Employee 28 | Regular
 | Employee 29 | Casual
 | Employee 30 | Regular
 | Employee 31 | Casual
 | Employee 32 | Regular
 | Employee 33 | Casual
 | Employee 34 | Regular
 | Employee 35 | Casual
 | Employee 36 | Regular
 | Employee 37 | Casual
 | Employee 38 | Regular
 | Employee 39 | Casual
 | Employee 40 | Regular
 | Employee 41 | Casual
 | Employee 42 | Regular
 | Employee 43 | Casual
 | Employee 44 | Regular
 | Employee 45 | Casual
 | Employee 46 | Regular
 | Employee 47 | Casual
 | Employee 48 | Regular
 | Employee 49 | Casual
 | Employee 50 | Regular
Spreadsheet: 2213e943-5395-4408-99dc-e77123679601
Sheet: Sheet1

Phlebotomist | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Certificate
Name |  |  | Student ID Number |  |  |  | Date Entered:
Address |  |  | Phone: |  |  |  | Proposed Graduation Date:
 |  |  | [NAME]:
 |  |  | Student Signature: |  |  |  |  | Date:
 |  |  | Advisor Signature: |  |  |  |  | Date:
 |  |  | Authorizing Signature: |  |  |  |  | Date:
Course |  |  |  | Credits | Semester Taken
100 PHB Phlebotomy |  |  |  | 6
155 PHB Phlebotomy Clinical |  |  |  | 3
Total hours for Certificate |  |  |  | 9
Spreadsheet: 722917d1615458241-obtain-a-flowing-average-from-blocks-of-data-example
Sheet: Sheet1

Period ID | Date | Total for Period | Average Per Day | "Flowing" Average
1 | 2021-01-01 00:00:00 | 8 |  | ? | Sum of these "Flowing" Averages must still equal 8
1 | 2021-01-02 00:00:00 | 8 |  | ?
1 | 2021-01-03 00:00:00 | 8 |  | ?
1 | 2021-01-04 00:00:00 | 8 |  | ?
1 | 2021-01-05 00:00:00 | 8 |  | ?
2 | 2021-01-06 00:00:00 | 6 |  | ? | Sum of these "Flowing" Averages must still equal 6
2 | 2021-01-07 00:00:00 | 6 |  | ?
2 | 2021-01-08 00:00:00 | 6 |  | ?
2 | 2021-01-09 00:00:00 | 6 |  | ?
2 | 2021-01-10 00:00:00 | 6 |  | ?
3 | 2021-01-11 00:00:00 | 12 |  | ? | Sum of these "Flowing" Averages must still equal 12
3 | 2021-01-12 00:00:00 | 12 |  | ?
3 | 2021-01-13 00:00:00 | 12 |  | ?
3 | 2021-01-14 00:00:00 | 12 |  | ?
3 | 2021-01-15 00:00:00 | 12 |  | ?
3 | 2021-01-16 00:00:00 | 12 |  | ?
4 | 2021-01-17 00:00:00 | 9 |  | ? | Sum of these "Flowing" Averages must still equal 9
4 | 2021-01-18 00:00:00 | 9 |  | ?
4 | 2021-01-19 00:00:00 | 9 |  | ?
4 | 2021-01-20 00:00:00 | 9 |  | ?
4 | 2021-01-21 00:00:00 | 9 |  | ?
5 | 2021-01-22 00:00:00 | 5 |  | ? | Sum of these "Flowing" Averages must still equal 5
5 | 2021-01-23 00:00:00 | 5 |  | ?
5 | 2021-01-24 00:00:00 | 5 |  | ?
5 | 2021-01-25 00:00:00 | 5 |  | ?
6 | 2021-01-26 00:00:00 | 10.5 |  | ? | Sum of these "Flowing" Averages must still equal 10.5
6 | 2021-01-27 00:00:00 | 10.5 |  | ?
6 | 2021-01-28 00:00:00 | 10.5 |  | ?
6 | 2021-01-29 00:00:00 | 10.5 |  | ?
6 | 2021-01-30 00:00:00 | 10.5 |  | ?
6 | 2021-01-31 00:00:00 | 10.5 |  | ?
Spreadsheet: 883570d1732192295-filter-table-to-bring-back-all-occasions-name-shows-if-they-are-a-duplicate-jaysanctuary-test-213-spill-365-aligw
Sheet: Sheet1

 | Current Q | Q4
 |  |  | Date | Quarter | Name | Count | Current Q & Duplicate?
 |  |  | 2024-02-01 00:00:00 | Q1 | [NAME]
 |  |  | 2024-02-01 00:00:00 | Q1 | [NAME]
 |  |  | 2024-02-01 00:00:00 | Q1 | [NAME]
 |  |  | 2024-02-01 00:00:00 | Q1 | [NAME]
 |  |  | 2024-04-01 00:00:00 | Q2 | [NAME]
 |  |  | 2024-04-01 00:00:00 | Q2 | [NAME]
 |  |  | 2024-04-01 00:00:00 | Q2 | [NAME]
 |  |  | 2024-04-01 00:00:00 | Q2 | [NAME]
 |  |  | 2024-07-01 00:00:00 | Q3 | [NAME]
 |  |  | 2024-07-01 00:00:00 | Q3 | Haley
 |  |  | 2024-07-01 00:00:00 | Q3 | Mark
 |  |  | 2024-10-01 00:00:00 | Q4 | [NAME]
 |  |  | 2024-10-01 00:00:00 | Q4 | [NAME]
 |  |  | 2024-10-01 00:00:00 | Q4 | [NAME]
 |  |  | 2024-10-01 00:00:00 | Q4 | [NAME]
 |  |  | Current output |  |  |  |  | Ideal Output
 |  |  | Date | Quarter | Name |  |  | Date | Quarter | Name
 |  |  |  |  |  |  |  | 2024-02-01 00:00:00 | Q1 | [NAME]
 |  |  | 2024-02-01 00:00:00 | Q1 | [NAME] |  |  | 2024-02-01 00:00:00 | Q1 | [NAME]
 |  |  | 2024-02-01 00:00:00 | Q1 | [NAME] |  |  | 2024-04-01 00:00:00 | Q2 | [NAME]
 |  |  | 2024-04-01 00:00:00 | Q2 | [NAME] |  |  | 2024-10-01 00:00:00 | Q4 | [NAME]
 |  |  | 2024-04-01 00:00:00 | Q2 | [NAME] |  |  | 2024-10-01 00:00:00 | Q4 | [NAME]
 |  |  | 2024-10-01 00:00:00 | Q4 | [NAME]
 |  |  | 2024-10-01 00:00:00 | Q4 | [NAME] |  |  |  | Q1 | [NAME]
 |  |  |  |  |  |  |  | 2024-02-01 00:00:00 | Q1 | [NAME]
 |  |  |  |  |  |  |  | 2024-04-01 00:00:00 | Q2 | [NAME]
 |  |  |  |  |  |  |  | 2024-10-01 00:00:00 | Q4 | [NAME]
 |  |  |  |  |  |  |  | 2024-10-01 00:00:00 | Q4 | [NAME]
Spreadsheet: 72652d1273341216-search-multiple-worksheets-acme-schedules
Sheet: SUPERVISORS

WORK CATEGORY CODES: |  |  |  |  | DIVISION/ [NAME]:
W – WORK           SA – SPECIAL ASSIGNMENT    SL – SICK LEAVE
DO – DAY OFF        HW – HOLIDAY WORKED        AV – ADVANCE |  |  |  |  | STORE 1811
AL – ANNUAL LEAVE   WT – WORK/TRAVEL
 |  | PERIOD COVERED |  |  | SHIFT:
 |  |  |  |  | SUPERVISORS
 | NAME | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THRUSDAY | FRIDAY | SATURDAY
1 | D. PILLO |  |  |  |  |  |  |  | D. PILLO | D. PILLO | D. PILLO | D. PILLO | D. PILLO | D. PILLO | D. PILLO
2 | E. YERRP |  |  |  |  |  |  |  | E. YERRP | E. YERRP | E. YERRP | E. YERRP | E. YERRP | E. YERRP | E. YERRP
3 | D. TEN |  |  |  |  |  |  |  | D. TEN | D. TEN | D. TEN | D. TEN | D. TEN | D. TEN | D. TEN
4 | J. MINKSI |  |  |  |  |  |  |  | J. MINKSI | J. MINKSI | J. MINKSI | J. MINKSI | J. MINKSI | J. MINKSI | J. MINKSI
5 | J. DONUGH |  |  |  |  |  |  |  | J. DONUGH | J. DONUGH | J. DONUGH | J. DONUGH | J. DONUGH | J. DONUGH | J. DONUGH
6 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
7 | E. KELLTON |  |  |  |  |  |  |  | E. KELLTON | E. KELLTON | E. KELLTON | E. KELLTON | E. KELLTON | E. KELLTON | E. KELLTON
8 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
9 | A. STURW |  |  |  |  |  |  |  | A. STURW | A. STURW | A. STURW | A. STURW | A. STURW | A. STURW | A. STURW
10 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
11 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
12 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
13 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
14 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
15 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL SOT:
 | CITIES
 | SHIFT:
 | TEMPS:
PREPARED BY |  |  |  |  | SIGNATURE
BRAD PITT |  |  |  |  | [NAME]
Spreadsheet: 78848d1279141132-automatically-shift-cells-in-relation-to-one-another-cal-example
Sheet: Sheet1

 | 2010-08-01 00:00:00 | 2010-08-02 00:00:00 | 2010-08-03 00:00:00 | 2010-08-04 00:00:00 | 2010-08-05 00:00:00 | 2010-08-06 00:00:00 | 2010-08-07 00:00:00 | 2010-08-08 00:00:00 | 2010-08-09 00:00:00 | 2010-08-10 00:00:00 | 2010-08-11 00:00:00 | 2010-08-12 00:00:00 | 2010-08-13 00:00:00 | 2010-08-14 00:00:00 | 2010-08-15 00:00:00 | 2010-08-16 00:00:00 | 2010-08-17 00:00:00 | 2010-08-18 00:00:00
1st Draft Complete
Project Participant Reviews
Revise for 2nd [NAME]
Spreadsheet: 246644d1372465580-if-bx-is-empty-and-ax-az-fill-bx-with-contents-of-bz-demo-spreadsheet
Sheet: Sheet1

Handle | Product Name | Attribute Name
D8KV | Chevy | Impala
D8KV |  | Tahoe
D8KV |  | Suburban
D8KV |  | Silverado
V9IK | Ford | Focus
V9IK |  | Fusion
[NAME] | Dodge | Durango
[NAME] |  | Challenger
[NAME] |  | Charger
[NAME] |  | Avenger
[NAME] |  | Journey
[NAME] |  | [NAME]
K5JI | Jeep | Liberty
K5JI |  | [NAME]
K5JI |  | Grand Gherokee
Spreadsheet: 0186d0fd-18ed-4eaa-abf2-5b42e24146fb
Sheet: Sheet1

GOBERNACION DEL VALLE DEL CAUCA | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
SECRETARIA DEPARTAMENTAL DE SALUD
Mortalidad Fetal Según municipio de residencia. [NAME]. [NAME] 2002 - 2006
Municipio | 2002 | 2003 | 2004 | 2005 | 2006
ALCALA | 21 | 24 | 23 |  | 19
ANDALUCIA | 7 | 2 | 1 |  | 6
ANSERMANUEVO | 4 | 0 | 9 |  | 24
ARGELIA | 0 | 1 | 2 |  | 3
BOLIVAR | 2 | 7 | 5 |  | 4
BUENAVENTURA | 78 | 81 | 24 |  | 108
BUGA | 16 | 26 | 36 |  | 33
BUGALAGRANDE | 0 | 4 | 1 |  | 3
CAICEDONIA | 7 | 2 | 3 |  | 2
CALI | 591 | 604 | 608 |  | 537
CANDELARIA | 22 | 18 | 15 |  | 27
CARTAGO | 68 | 113 | 139 |  | 288
DAGUA | 9 | 7 | 10 |  | 9
DARIEN | 5 | 1 | 1 |  | 4
EL AGUILA | 4 | 0 | 3 |  | 6
EL CAIRO | 1 | 0 | 2 |  | 5
EL CERRITO | 6 | 13 | 4 |  | 5
EL DOVIO | 3 | 0 | 5 |  | 3
FLORIDA | 13 | 16 | 10 |  | 19
GINEBRA | 2 | 8 | 1 |  | 2
GUACARI | 6 | 2 | 5 |  | 6
JAMUNDI | 21 | 20 | 21 |  | 27
LA CUMBRE | 2 | 6 | 6
LA UNION | 11 | 8 | 5 |  | 7
LA VICTORIA | 1 | 4 | 5 |  | 1
OBANDO | 3 | 1 | 3 |  | 10
PALMIRA | 50 | 82 | 86 |  | 381
PRADERA | 16 | 20 | 15 |  | 10
RESTREPO | 2 | 2 | 1 |  | 4
RIOFRIO | 3 | 6 | 5
ROLDANILLO | 11 | 7 | 11 |  | 7
SAN PEDRO | 2 | 6 | 2 |  | 4
SEVILLA | 14 | 11 | 6 |  | 6
TORO | 5 | 6 | 3 |  | 1
TRUJILLO | 5 | 4 | 3
TULUA | 35 | 38 | 33 |  | 35
ULLOA | 1 | 2 | 1 |  | 8
VERSALLES | 1 | 1 | 3 |  | 1
VIJES | 0 | 1 | 0 |  | 3
YOTOCO | 1 | 2 | 7
YUMBO | 19 | 17 | 21 |  | 24
ZARZAL | 14 | 14 | 13 |  | 20
Total Valle | 1082 | 1187 | 1157 | 0 | 1662
Fuente: Registro Individual de Defunción, DANE
Salud Pública
Spreadsheet: 116673d1311975613-selective-columns-abbey-hill
Sheet: Dr

Davey. R |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3 |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hole | par | stroke index | strokes | points | penalty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: andy_zipper__244__DYNEGY-ICE VOL Jun4
Sheet: ICE-EPM

Enron Power Marketing
Activity on ICE
UOM | Deals | Volume
MWhs
 |  |  |  |  |  |  | START | END
Enron Power Marketing, Inc.
Commodity Type:   All
Instruments:   All
Trade Dates:   Jun-4-01 thru Jun-4-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Jun-04-01 | 188969679 |  | Bought | Firm-LD Peak | Ent | Next Day | Jun-05-01 | Jun-05-01 |  |  |  | American Electric Power Service Corp. | 31 | USD / MWh | 50 | Hourly | 800 | MWhs | Carson, M
Jun-04-01 | 126456264 |  | Sold | Firm-LD Peak | Cin | Next Day | Jun-05-01 | Jun-05-01 |  |  |  | American Electric Power Service Corp. | 21.25 | USD / MWh | 50 | Hourly | 800 | MWhs | Dorland, C
Jun-04-01 | 871936309 |  | Bought | Firm-LD Peak | Ent | Next Day | Jun-05-01 | Jun-05-01 |  |  |  | American Electric Power Service Corp. | 31 | USD / MWh | 50 | Hourly | 800 | MWhs | Carson, M
Jun-04-01 | 397939959 |  | Sold | Firm-LD Peak | TVA | Next Day | Jun-05-01 | Jun-05-01 |  |  |  | American Electric Power Service Corp. | 24 | USD / MWh | 50 | Hourly | 800 | MWhs | Carson, M
Jun-04-01 | 182705738 |  | Sold | Firm-LD Peak | Ent | Next Day | Jun-05-01 | Jun-05-01 |  |  |  | American Electric Power Service Corp. | 31 | USD / MWh | 50 | Hourly | 800 | MWhs | Carson, M
Jun-04-01 | 457602302 |  | Sold | Firm-LD Peak | TVA | Next Day | Jun-05-01 | Jun-05-01 |  |  |  | American Electric Power Service Corp. | 23.75 | USD / MWh | 50 | Hourly | 800 | MWhs | Carson, M
Jun-04-01 | 217596927 |  | Bought | Firm-LD Peak | Comed | Next Day | Jun-05-01 | Jun-05-01 |  |  |  | American Electric Power Service Corp. | 22.5 | USD / MWh | 50 | Hourly | 800 | MWhs | Dorland, C
Jun-04-01 | 119502021 |  | Sold | Firm-LD Peak | Cin | Next Day | Jun-05-01 | Jun-05-01 |  |  |  | Northern Indiana Public Service Company | 22 | USD / MWh | 50 | Hourly | 800 | MWhs | Dorland, C
Jun-04-01 | 817668026 |  | Bought | Firm-LD Peak | TVA | 2001-09-01 00:00:00 | Sep-01-01 | Sep-30-01 |  |  |  | Aquila Energy Marketing Corp | 39.25 | USD / MWh | 50 | Hourly | 15200 | MWhs | Carson, M
Jun-04-01 | 316432740 |  | Bought | Firm-LD Off-Peak | SP-15 Off-Peak | [NAME] | Jun-06-01 | Jun-30-01 |  |  |  | Reliant Energy Services, Inc. | 70 | USD / MWh | 25 | Hourly | 6200 | MWhs | Fischer, M
Jun-04-01 | 554612751 |  | Bought | Firm-LD Peak | Ercot UBU | Bal Month | Jun-06-01 | Jun-29-01 |  |  |  | Mirant Americas Energy Marketing, LP | 44.5 | USD / MWh | 50 | Hourly | 14400 | MWhs | Stalford, R
Jun-04-01 | 200845768 |  | Sold | Firm-LD Peak | Cin | Next Week | Jun-11-01 | Jun-15-01 |  |  |  | Aquila Energy Marketing Corp | 34.75 | USD / MWh | 50 | Hourly | 4000 | MWhs | Dorland, C
Jun-04-01 | 914524272 |  | Sold | Firm-LD Peak | Cin | Next Week | Jun-11-01 | Jun-15-01 |  |  |  | American Electric Power Service Corp. | 34 | USD / MWh | 50 | Hourly | 4000 | MWhs | Dorland, C
Jun-04-01   Deals
Spreadsheet: 833192d1686832633-formula-to-calculate-capital-gain-loss-share-holdings-by-value-sample
Sheet: Capital Gain_Loss 22_23

Realised Capital Gains - Period July 2022 to June 203
Share Code | Date | Currency | Purchase Price | Qty | Date | Sale Price | Qty | Gain/Loss | Comm
AI | 2023-05-30 00:00:00 | USD | 38.5 | 20 | 2023-05-30 00:00:00 | 36.82 | 20 |  | 2
PEN | 2022-04-22 00:00:00 | AUD | 0.24 | 3500 | 2023-06-01 00:00:00 | 0.16 | 3500 |  | 20
IONQ | 2023-05-31 00:00:00 | USD | 10.59 | 60 | 2023-06-03 00:00:00 | 9.18 | 60 |  | 2
ORG | 2018-10-24 00:00:00 | AUD | 7.37 | 250 | 2023-06-06 00:00:00 | 8.36 | 250 |  | 20
CIFR | 2023-05-23 00:00:00 | USD | 2.48 | 200 | 2023-06-06 00:00:00 | 2.17 | 200 |  | 2
GEHC | 2023-06-05 00:00:00 | USD | 79.8 | 20 | 2023-06-08 00:00:00 | 77.35 | 20 |  | 10
Nett Capital Gain/(Loss)
Nett Capital Gain/(Loss) after charges
Spreadsheet: 550938d1512621556-extract-unique-values-from-duplicates-with-criteria-test
Sheet: Sheet 1

Name | Lag Time Behind Last Group | Lag Time >=
 |  | 00:12:00
[NAME] | 00:09:00 | [NAME]
[NAME] | 00:11:00 | [NAME]
[NAME] | 00:11:00 | Ian
[NAME] | 00:11:00 | etc
[NAME] | 00:13:00
[NAME] | 00:18:00
Doug | 00:09:00
Doug | 00:10:00
Doug | 00:10:00
[NAME] | 00:09:00
[NAME] | 00:13:00
[NAME] | 00:19:00
Ian | 00:09:00
Ian | 00:09:00
Ian | 00:12:00
Trevor | 00:10:00
Trevor | 00:10:00
Trevor | 00:12:00
Trevor | 01:16:00
Spreadsheet: 227727d1365797037-matching-and-renumbering-massive-amount-of-data-airlinehelp
Sheet: Sheet1

Airline | Unique Number |  | Combined |  | Airline |  | Departure |  | Number |  | Arrivial |  | Number |  | Combined
AAA | 1 |  | US AAA AAX |  |  |  |  |  |  |  |  |  |  |  |  | <--I believe this is the result you want
AAC | 2 |  | US AAA AAG
AAE | 3 |  | US AAE AAA
AAF | 4 |  | US AAM AAL
AAG | 5 |  | US AAM AAM
AAL | 6 |  | US AAM AAL
AAM | 7 |  | US AAM AAL
AAX | 8
Spreadsheet: 133786d1324612721-doesnt-seem-right-from-previous-year-p-and-l2010help
Sheet: 2010

Profit and Loss Statement |  | Tax Year: |  | Yearly Summary
 |  | Tax Return (Line 12; 1040 Form) |  | 62378
 |  | Total Income
Gross margin  [L/J] |  | Total Expense
Return on sales  [T/J] |  |  | Profit / (Loss)
Net Profit % Change from Prior Year
 | Prior Year | Current Period | Current Period as        % of Sales | % Change from      Prior Period
Sales Revenue
Health Insurance
Medicare Advantage
Medicare Supplement
Life Insurance
Investment (Annuity)
Other
Total Sales Revenue  [J]
Cost of Sales
Specify
Total Cost of Sales  [K]
Gross Profit  [L=J-K]
Operating Expenses
Sales and Marketing
Advertising (Radio, TV, Print Media, etc)
Printing
Direct marketing
Seminar
Meals and Entertainment
Total Sales and Marketing Expenses  [M]
Research & Development
Licenses
Education
Total Research & Development Expenses  [N]
General and Adminstrative
Rent
Payroll
Utilities
Telephone
Health Insurance
E&O Insurance
Software
Web Hosting and domains
Postage
Office Supplies
Equipment
Repairs and maintenance
Other expenses (specify)
Auto (Tires, Fuel, Oil, Tolls, [NAME], etc)
Auto Mileage (IRS standard deduction; averaged)
Total General & Adminstrative Expenses  [O]
Total Operating Expenses  [P=M+N+O]
Income from Operations  [Q=L-P]
Other Income (Bonuses) [R]
Taxes
Payroll Taxes
Property Taxes
Total Taxes  [S]
Net Profit  [T=Q+R-S]
Spreadsheet: 874683d1721225701-if-function-to-compare-multiple-tabs-rswlaw67-bills-by-pay-cycle
Sheet: Pay Cycle Dates

Pay Cycle | Starting Date | End Date
1 | 2024-07-01 00:00:00 | 2024-07-04 00:00:00
2 | 2024-07-05 00:00:00 | 2024-07-18 00:00:00
3 | 2024-07-19 00:00:00 | 2024-08-01 00:00:00
4 | 2024-08-02 00:00:00 | 2024-08-15 00:00:00
5 | 2024-08-16 00:00:00 | 2024-08-29 00:00:00
6 | 2024-08-30 00:00:00 | 2024-09-12 00:00:00
7 | 2024-09-13 00:00:00 | 2024-09-26 00:00:00
8 | 2024-09-27 00:00:00 | 2024-10-10 00:00:00
9 | 2024-10-11 00:00:00 | 2024-10-24 00:00:00
10 | 2024-10-25 00:00:00 | 2024-11-07 00:00:00
11 | 2024-11-08 00:00:00 | 2024-11-21 00:00:00
12 | 2024-11-22 00:00:00 | 2024-12-05 00:00:00
13 | 2024-12-06 00:00:00 | 2024-12-19 00:00:00
14 | 2024-12-20 00:00:00 | 2024-12-31 00:00:00