tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 681295d1591455286-extract-peak-value-with-date-and-timestamp-tou-pivot-tables-reduced-kfbeal-
Sheet: TOU-Pivot-Tables

[NAME] | 5012 |  | [NAME] | 5013 |  | [NAME] | 5014 |  | [NAME] | 5015 |  | [NAME] | 5012 |  | [NAME] | 5013 |  | [NAME] | 5014 |  | [NAME] | 5015
Type | KW |  | Type | KW |  | Type | KW |  | Type | KW |  | Type | KW |  | Type | KW |  | Type | KW |  | Type | KW
 |  |  |  |  |  |  |  |  |  |  |  | Date | 28-Apr |  | Date | 28-Apr |  | Date | 28-Apr |  | Date | 28-Apr
Peak Date | Peak KW |  | Peak Date | Peak KW |  | Peak Date | Peak KW |  | Peak Date | Peak KW
2020-04-29 01:45:00 | 16.66 |  | 2020-05-02 00:00:00 | 0.09 |  | 2020-05-02 11:00:00 | 1.84 |  | 2020-05-06 15:15:00 | 1.49 |  | Max of Value |  |  | Peak KW |  |  | Peak KW |  |  | Peak KW
 |  |  |  |  |  |  |  |  |  |  |  | 15.38 |  |  | 0.08 |  |  | 1.6 |  |  | 1.27
[NAME] | 5012 |  | [NAME] | 5013 |  | [NAME] | 5014 |  | [NAME] | 5015
Type | KWH |  | Type | KWH |  | Type | KWH |  | Type | KWH
Date | 27-Apr |  | Date | 27-Apr |  | Date | 27-Apr |  | Date | 27-Apr
Previous KWH |  |  | Previous KWH |  |  | Previous KWH |  |  | Previous KWH
94014.92 |  |  | 349.67 |  |  | 2581.04 |  |  | 3822.95
[NAME] | 5012 |  | [NAME] | 5013 |  | [NAME] | 5014 |  | [NAME] | 5015
Type | KWH |  | Type | KWH |  | Type | KWH |  | Type | KWH
Date | 10-May |  | Date | 10-May |  | Date | 10-May |  | Date | 10-May
Present KWH |  |  | Present KWH |  |  | Present KWH |  |  | Present KWH
97572.14 |  |  | 394.44 |  |  | 2807.05 |  |  | 4162
Total KWH |  |  | Total KWH |  |  | Total KWH |  |  | Total KWH
 |  |  |  | Name |  | Value | Date
 |  |  |  | Total 12-NCP KW
 |  |  |  | Total KWH
 |  |  |  | Total 4-CP KW
Spreadsheet: 862035d1709828354-help-with-formula-to-create-running-total-in-percentage-inspections-excel-forum
Sheet: Sheet1

Unit | Description | Form Type | Inspection Month | Unit Status | Completed by: | Date of Inspection | Location of inspection completed: | Current Odometer kms (Red if overdue for oil change) | Next Oil Change Due (KMs)
21001 |  | INSP | 2024-01-01 00:00:00 | Active | Colby | 2024-01-08 00:00:00 | [NAME] | 455935 | 461647
21001 |  | INSP | 2024-02-01 00:00:00 | Active | [NAME] | 2024-02-01 00:00:00 | [NAME] | 456648 | 461647
21001 |  | INSP | 2024-03-01 00:00:00 | Active | Wayne | 2024-03-02 00:00:00 | [NAME] | 460279 | 461647
21001 |  | EMR
21001 |  |  | 2024-04-01 00:00:00
21001 |  |  | 2024-05-01 00:00:00
21001 |  |  | 2024-06-01 00:00:00
21001 |  |  | 2024-07-01 00:00:00
21001 |  |  | 2024-08-01 00:00:00
21001 |  |  | 2024-09-01 00:00:00
21001 |  |  | 2024-10-01 00:00:00
21001 |  |  | 2024-11-01 00:00:00
21001 |  |  | 2024-12-01 00:00:00
 |  |  | 21001 INSP TOTAL |  | YTD % Complete
Spreadsheet: 735601d1623090722-overlapping-dates-date
Sheet: Foglio2

 |  |  |  |  | Dal | Al
 |  |  | room 101 |  | 2021-06-04 00:00:00 | 2021-06-06 00:00:00
 |  |  | room 101 |  | 2021-06-07 00:00:00 | 2021-06-12 00:00:00
 |  |  | room 102 |  | 2021-06-02 00:00:00 | 2021-06-09 00:00:00
 |  |  | room 102 |  | 2021-06-08 00:00:00 | 2021-06-10 00:00:00
 |  |  | room 102 |  | 2021-06-09 00:00:00 | 2021-06-15 00:00:00
 |  |  | room 101 |  | 2021-06-04 00:00:00 | 2021-06-06 00:00:00
 |  |  | room 101 |  | 2021-06-07 00:00:00 | 2021-06-12 00:00:00
 |  |  | room 102 |  | 2021-06-02 00:00:00 | 2021-06-09 00:00:00
 |  |  | room 102 |  | 2021-06-02 00:00:00 | 2021-06-15 00:00:00
 |  |  | room 102 |  | 2021-06-04 00:00:00 | 2021-06-08 00:00:00
 |  |  | room 102 |  | 2021-06-08 00:00:00 | 2021-06-10 00:00:00
 |  |  | room 102 |  | 2021-06-09 00:00:00 | 2021-06-15 00:00:00
 |  |  | room 102 |  | 2021-06-10 00:00:00 | 2021-06-12 00:00:00
Spreadsheet: 91614d1291301504-help-vlookup-on-creating-report-report-vlook-up
Sheet: Sheet2

store number | UPC | Item Description | Item Number | sales
100 | 1234560 | product 0 | 0 | 7
101 | 1234561 | product 1 | 1 | 3
102 | 1234562 | product 2 | 2 | 5
103 | 1234563 | product 3 | 3 | 8
104 | 1234564 | product 4 | 4 | 5
105 | 1234565 | product 5 | 5 | 32
106 | 1234566 | product 6 | 6 | 1
107 | 1234567 | product 7 | 7 | 45
108 | 1234568 | product 8 | 8 | 7
109 | 1234569 | product 9 | 9 | 8
102 | 132456 | product 10 | 9 | 8
Spreadsheet: 550099d1512104898-auto-sum-data-by-employee-number-from-5-other-sheets-copy-of-december-2017-att-contest
Sheet: UPGRADES -3

WA ID | QUANTITY | POINTS | PERFECT BONUS | TOTAL POINTS
105499
110895
110944
110985
110991
111066
111173
111181
111400
111746
111780
112264
113576
114344
114354
114674
Spreadsheet: 124621d1318513641-help-with-sumif-sumproduct-formulas-sample-bc
Sheet: Mar

Acct | Consolidated | Location 1 | Location 2 | Location 3
supplies |  | 8 | 9 | 2
insurance |  | 3 | 6 | 10
office |  | 5 | 6 | 1
Spreadsheet: 719504d1613688788-stdev-last-5-in-a-column-stdev-last-5-in-a-column
Sheet: Sheet1

Project Numbers
1
2
3
4
5
6
7
8
9
Quarterly Numbers
4
3
6
2
9
8
7
6
1
6
7
Spreadsheet: jay_reitmeyer__13744__CitizensLGSReconciliationCUC
Sheet: Summary

Enron North America
Citizens Utilities Company Reconciliation
Colorado Gas Division
2001-10-03 00:00:00
Term | 10/2000 - 9/2001
Location | CIG/South of DJ Basin/991008000
 |  | Settlement |  |  |  |  | Fuel | CIG
 |  |  |  |  |  | CIG | Adj. | TF-1 | Deliverd | Capacity | Refund
Month/Year |  | Volume | CIG,RM | Premium | Total | Fuel Rate | Price | Var. Charge | Price | Release | Price | Amount
2000-10-01 00:00:00 |  | 4805 | 4.19 | 0.01 |  | 0.0259 |  | 0.0684 |  | 0.06
2000-11-01 00:00:00 |  | 5014 | 4.31 | 0.01 |  | 0.0259 |  | 0.0684 |  | 0.06
2000-12-01 00:00:00 |  | 4240 | 5.95 | 0.01 |  | 0.0259 |  | 0.0684 |  | 0.06
2001-01-01 00:00:00 |  | 5983 | 8.63 | 0.01 |  | 0.0259 |  | 0.0682 |  | 0.06
2001-02-01 00:00:00 |  | 5404 | 6.31 | 0.01 |  | 0.0259 |  | 0.0682 |  | 0.06
2001-03-01 00:00:00 |  | 4371 | 4.72 | 0.01 |  | 0.0259 |  | 0.0682 |  | 0.06
2001-04-01 00:00:00 |  | 3720 | 4.49 | 0.01 |  | 0.0259 |  | 0.0682 |  | 0.06
2001-05-01 00:00:00 |  | 4805 | 3.91 | 0.01 |  | 0.0259 |  | 0.0682 |  | 0.06
2001-06-01 00:00:00 |  | 4640 | 2.43 | 0.01 |  | 0.0259 |  | 0.0682 |  | 0.06
2001-07-01 00:00:00 |  | 4805 | 1.75 | 0.01 |  | 0.0259 |  | 0.0682 |  | 0.06
Total
 |  |  |  |  |  |  |  |  |  | Total Due Citizens
Spreadsheet: 0ffbbe35-4245-4c40-9b05-2110d9203b84
Sheet: SPRING INFLOW (UPDATED PRICING)

SPRING 2012 INFLOW
[NAME]
No. | Name | Category  (In-House, Out of House, etc.) | Basic Dues  (includes dinner) ($) | Full-time Parking | [NAME] ($) | Lunch Days per Week | [NAME] ($) | Total Dues Owed | Amount Paid ($) | Date of Last Payment | Housing Contract Submitted (Date) | Security Deposit Submitted (Date) | Dues Contract Submitted (Date) | Payment Plan Notes
 | [NAME] | OUT |  | DAY |  |  |  |  |  |  | N/A | N/A
 | [NAME] | PRESIDENT |  | IN
 | [NAME] | OUT |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | IN |  | IN
 | [NAME] | OUT |  | DAY |  |  |  |  |  |  | N/A | N/A
 | [NAME] | OUT |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | IN |  | -
 | [NAME] | SA |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | PRESIDENT |  | IN
 | Cliff [NAME] | OUT |  | OUT |  |  |  |  |  |  | N/A | N/A
 | [NAME] | OUT |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | PRESIDENT |  | IN
 | [NAME] | OUT |  | DAY |  |  |  |  |  |  | N/A | N/A
 | [NAME] | OUT |  | OUT |  |  |  |  |  |  | N/A | N/A
 | [NAME] | IN |  | IN
 | [NAME] | OUT |  | - |  |  |  |  |  |  | N/A | N/A
 | JJ Won | IN |  | IN
 | [NAME] | IN |  | IN
 | [NAME] | OUT |  | OUT |  |  |  |  |  |  | N/A | N/A
 | [NAME] | OUT |  | DAY |  |  |  |  |  |  | N/A | N/A
 | [NAME] | OUT |  | - |  |  |  |  |  |  | N/A | N/A
 | Laurent Pilon | IN |  | IN
 | [NAME] | OUT |  | DAY |  |  |  |  |  |  | N/A | N/A
 | [NAME] | OUT |  | OUT |  |  |  |  |  |  | N/A | N/A
 | [NAME] | IN |  | IN
 | [NAME] | IN |  | IN
 | [NAME] | OUT |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | OUT |  | OUT |  |  |  |  |  |  | N/A | N/A
 | [NAME] | OUT |  | OUT |  |  |  |  |  |  | N/A | N/A
 | [NAME] | NEW |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | NEW |  | OUT |  |  |  |  |  |  | N/A | N/A
 | [NAME] | NEW |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | NEW |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | NEW |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | NEW |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | SA |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | NEW |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | NEW |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | NEW |  | - |  |  |  |  |  |  | N/A | N/A
 | [NAME] | NEW |  | - |  |  |  |  |  |  | N/A | N/A
 | Zach Gilreath | NEW |  | - |  |  |  |  |  |  | N/A | N/A
NON-BROTHER PARKING INCOME
 | Name | [NAME] ($) | Date Paid
1 |  | 550
2
3
 | SPRING SEMESTER OVERVIEW
 | Accounts Recievable
 | Account Collected
Spreadsheet: 814351d1674305405-returning-a-random-value-from-a-specific-list-without-immediate-duplicates-test-19-
Sheet: Sheet1

 | A1 | A2 | B1 | B2 | C1 | C2 | D1 | D2 | E1 | E2 |  | Person | Option 1 | Option 2 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
1 |  |  | P |  |  |  | X | X | X | X |  |  |  |  |  |  | A1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B
2 |  |  |  |  |  |  | X | X | P |  |  |  |  |  |  |  | A2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C
3 |  |  |  |  | P |  | X | X | X | X |  |  |  |  |  |  | B1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D
4 |  |  | P |  |  |  | X | X | X | X |  |  |  |  |  |  | B2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E
5 |  |  |  |  |  |  | P |  | X | X |  |  |  |  |  |  | C1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
6 |  |  |  |  |  |  | X | X |  | P |  |  |  |  |  |  | C2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G
7 |  |  |  |  |  | P | X | X | X | X |  |  |  |  |  |  | D1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H
8 |  |  |  |  |  |  | X | X | P |  |  |  |  |  |  |  | D2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I
9 | P |  |  |  | X | X | X | X | X | X |  |  |  |  |  |  | E1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | J
10 |  | P |  |  |  |  | X | X | X | X |  |  |  |  |  |  | E2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K
11 |  |  |  |  |  | P | X | X | X | X
12 |  |  |  | P |  |  | X | X | X | X
13 | P |  |  |  |  |  | X | X | X | X
14 |  | P |  |  | X | X | X | X | X | X |  |  |  |  |  |  |  |  | A1 | A2 | B1 | B2 | C1 | C2 | D1 | D2 | E1 | E2
15 |  |  |  | P | X | X | X | X | X | X |  |  |  |  |  |  |  | A1
16 |  |  |  |  |  |  | P |  | X | X |  |  |  |  |  |  |  | A2
17 | P |  |  |  | X | X | X | X | X | X |  |  |  |  |  |  |  | B1
18 |  |  |  |  |  |  | X | X |  | P |  |  |  |  |  |  |  | B2
19 |  |  | P |  |  |  | X | X | X | X |  |  |  |  |  |  |  | C1
20 |  |  |  |  | P |  | X | X | X | X |  |  |  |  |  |  |  | C2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | D2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E2
Spreadsheet: 850948d1701249855-vlookup-only-returning-first-value-and-sumif-returning-the-sum-twice-book29
Sheet: Sheet1

 |  |  | Sheet 1 |  |  |  |  | Sheet 2
 |  |  | IDs | Amount | sumif |  |  | IDs | Amount | Sumif
 |  |  | 96162 |  |  |  |  | 96162 | 100
 |  |  | 81180 |  |  |  |  | 81180 | 50
 |  |  | B3FLWH9 |  |  |  |  | B3FLWH9 | 10
 |  |  | 182704 |  |  |  |  | 182704 | 20
 |  |  | 182704 |  |  |  |  | 182704 | 25
 |  |  |  | 1) | I would like F8 to return 45 and for F9 to be zero or for [NAME] and F9=25
 |  |  |  | 2) | cell E9 to return 25
Spreadsheet: daren_farmer__5382__Monthly Capacity Matrix
Sheet: Jan 00 (2)

Locations | Transport Receipts | Buy | Transport Usage | Net Supply | Transport Deliveries | Sell | Transport Usage | Net Market | Net Throughput
HPL 1 - Thompsonville |  | 172764 |  |  | 1430 | 10125 | 162639
HPL 14 - South TX |  | 4582 | 9617 |  | 125 | 14199 | 0
HPL 18 - Three Rivers |  | 9278 |  |  |  | 4617 | 0
HPL 21 - Big Cowboy | 550 | 632 |  |  |  | 0
HPL 22 - Nueces |  | 0 | 5000 |  | 3465 | 5000 | 0
HPL 2 - Robstown | 16071 | 150906 |  |  |  | 617 | 150289
HPL 19 - King Ranch | 23600 | 0 |  |  | 22880 | 1500
HPL 3 - A/S South |  | 159017 | 0 |  |  | 25301 | 163716
HPL 4 - A/S Central |  | 23030 | 154825 |  |  | 177855
HPL 5 - Edna |  | 168002 |  |  |  | 68249 | 99753
HPL 6 - Texas City | 1555 | 7671 | 141018 |  | 26098 | 148689
HPL 10 - Ship Channel |  | 48816 | 413633 |  |  | 469074 | 400
HPL 15 - Katy |  | 126558 | 0 |  |  | 59472 | 67086
HPL 16 - West Loop |  | 100525 | 12236 |  |  | 4001 | 108760
HPL 17 - East Loop |  | 5000 | 92260 |  | 5000 | 97260
HPL 13 - Mid Texas |  |  | 0 |  |  | 0 | 0
HPL 23 - Bammel |  | 20934 | 17207 |  | 7095 | 35085 | 12236
HPL 7 - A/S East |  | 115 | 0 |  | 15000 | 48 | 67
HPL 8 - East Texas |  | 266961 | 9000 |  |  | 145120 | 130841
HPL 9 - Freeport |  | 5713 | 9638 |  | 20708 | 15351
HPL 11 - Corpus | 1121 | 1118 | 38945 |  |  | 40063 | 0
HPL 12 - Valley |  | 15105 | 0 |  |  | 11294 | 3811
HPL 20 - Hardin |  | 1 | 1500 |  | 2249 | 1501 | 0
HPL 24 - Gas Loss |  | 1 |  |  |  | 2303
HPL OffSystem | 2024 |  |  |  |  | 11833
 | Need to find out for Dynegy - guessed all at zone 8 (Texoma)
 | Amoco - add
Spreadsheet: ea6d2f1f-e399-4257-854e-832270d913d5
Sheet: Sheet1

Global X MLP ETF | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  |  | Fund Holdings Data as of 7/21/2014
% of Net Assets | Name | Identifier | Market Price($) | Shares Held | Market Value($)
5.89 | MAGELLAN MIDSTREAM | 559080106 | 85.11 | 78290 | 6663261.9
5.41 | MARKWEST ENERGY-PART UTS | 570759100 | 74.39 | 82373 | 6127727.47
5.4 | ENTERPRISE PRODUCTS PRTNR | 293792107 | 77.58 | 78715 | 6106709.7
5.39 | KINDER MORGAN ENERGY PRTN | 494550106 | 83.53 | 73037 | 6100780.61
5.37 | [NAME] PARTNERS | 118230101 | 82.35 | 73842 | 6080888.7
5.36 | SPECTRA ENERGY PARTNERS | 84756N109 | 54.34 | 111645 | 6066789.3
5.32 | ACCESS MIDSTREAM PARTNERS | 00434L109 | 62.87 | 95782 | 6021814.34
5.27 | PLAINS ALL AMERN PIP | 726503105 | 59.52 | 100122 | 5959261.44
5.05 | ENERGY TRANSFER PARTNERSP | 29273R109 | 57.32 | 99626 | 5710562.32
5.03 | [NAME] PARTNERS LP | 96950F104 | 53.27 | 106883 | 5693657.41
4.92 | ONEOK PARTNERS LP | 68268N103 | 58.53 | 95082 | 5565149.46
4.42 | ENBRIDGE ENERGY PARTNERS | 29250R106 | 35.25 | 141954 | 5003878.5
4.16 | TARGA RESOURCES PARTNERS | 87611X105 | 69.62 | 67655 | 4710141.1
3.82 | SUNOCO LOGISTICS PRTS | 86764L108 | 45.28 | 95529 | 4325553.12
3.28 | REGENCY ENERGY PARTNERS | 75885Y107 | 31.88 | 116547 | 3715518.36
3.11 | WESTERN GAS PARTNERS L.P. | 958254104 | 77.49 | 45464 | 3523005.36
2.94 | NUSTAR ENERGY LP | 67058H102 | 64.71 | 51396 | 3325835.16
2.86 | DCP MIDSTREAM PARTNER LLP | 23311P100 | 56.85 | 57016 | 3241359.6
2.75 | EL PASO PIPELINE PART LP | 283702108 | 35.82 | 86998 | 3116268.36
2.21 | AMERIGAS PARTNERS-LP | 030975106 | 45.9 | 54531 | 2502972.9
2.21 | GENESIS ENERGY L.P. | 371927104 | 54.76 | 45634 | 2498917.84
2.07 | CRESTWOOD MIDSTREAM PART | 226378107 | 23.43 | 100101 | 2345366.43
1.74 | ENLINK MIDSTREAM PARTNERS | 29336U107 | 31.57 | 62459 | 1971830.63
1.6 | SUBURBAN PROPANE PARTNERS | 864482104 | 45.21 | 39938 | 1805596.98
1.54 | ATLAS PIPELINE PARTNERS | 049392103 | 35.93 | 48464 | 1741311.52
1.51 | TESORO LOGISTICS LP | 88160T107 | 70.83 | 24064 | 1704453.12
1.45 | [NAME] | 87233Q108 | 53.12 | 30932 | 1643107.84
1.4 | NGL ENERGY PARTNERS LP | 62913M107 | 42.42 | 37253 | 1580272.26
1.18 | ALLIANCE RESOURCE PTNRLP | 01877R108 | 47.01 | 28420 | 1336024.2
1.1 | [NAME]. PART. | 096627104 | 19.25 | 64388 | 1239469
1.01 | EV ENERGY PARTNERS L.P. | 26926V107 | 38 | 30054 | 1142052
1 | CRESTWOOD EQUITY PARTNERS | 226344109 | 15.3 | 74164 | 1134709.2
0.86 | NORTHERN TIER ENERGY LP | 665826103 | 25.19 | 38727 | 975533.13
0.65 | NATURAL RESOURCE PART. LP | 63900P103 | 16.2 | 45299 | 733843.8
0.64 | CHENIERE ENERGY PARTNERS | 16411Q101 | 32.61 | 22316 | 727724.76
-0.02 | CASH | CASH | 1 | -26861.8 | -26861.8
Spreadsheet: 678886d1590099033-timesheet-with-rules-team-weekly-times-ww21-rev
Sheet: Sheet1

WW21 | Friday |  |  | Saturday | Sunday | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Weekly Hours
Name | In | Out | Hours |  |  | In | Out | Hours | In | Out | Hours | In | Out | Hours | In | Out | Hours
[NAME] | 07:27:00 | 14:59:00 |  |  |  | 07:27:00 | 17:57:00 |  | 07:32:00 | 18:53:00 |  | 07:30:00 | 17:20:00 |  | 07:34:00 | 18:30:00
[NAME] | 08:00:00 | 17:00:00 |  |  |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:14:00 |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:00:00
[NAME] | 08:00:00 | 17:30:00 |  |  |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:00:00 |  | 08:00:00 | 17:00:00 |  | 13:00:00 | 17:00:00
[NAME] | 07:50:00 | 17:15:00 |  |  |  | 07:50:00 | 17:15:00 |  | 07:50:00 | 17:15:00 |  | 07:50:00 | 17:15:00 |  | 07:50:00 | 18:30:00
[NAME] | 07:00:00 | 16:22:00 |  |  |  | 08:13:00 | 21:15:00 |  | 08:07:00 | 17:56:00 |  | 08:01:00 | 17:11:00 |  | 08:05:00
Ricardo Cardoso | 07:54:00 | 17:39:00 |  |  |  | 07:58:00 | 18:09:00 |  | 08:04:00 | 17:54:00 |  | 08:00:00 | 18:17:00 |  | 07:56:00
Hours worked = total time - 30 mins [NAME] break (should be built in)
If In OR Out times not entered then hours  = 0
If In AND Out times not entered then hours  = 0
If hours worked exceed 8.5 hours, then hours = 8.5
Spreadsheet: 837867d1690470151-increasing-hours-to-accommodate-number-of-times-an-instructors-name-appears-academy-hours-aligw-saheer123-
Sheet: Instructors by day (July)

Date | Intermediate | Families 1 | Families 2 | Raniyan | Diwa | Beginners | Families 3 | Folkstarz | Ladies | Joshiley
2023-07-06 00:00:00 | Taran Stuti
2023-07-08 00:00:00 |  |  |  | Megha
2023-07-09 00:00:00 |  |  |  |  |  | Taran Stuti | [NAME] | Chiraag Sunny | Chiraag Sunny | [NAME]
2023-07-11 00:00:00 | Taran Stuti
2023-07-12 00:00:00 |  | Asis Taran
2023-07-13 00:00:00 |  |  | Asis Chiraag
2023-07-15 00:00:00 |  |  |  | Stuti Asis
2023-07-16 00:00:00 |  |  |  |  | Taran | Taran | Taran | Taran Asis | Asis Chiraag | [NAME]
2023-07-18 00:00:00 | Taran Stuti
2023-07-19 00:00:00 |  | Asis Chiraag
2023-07-20 00:00:00 |  |  | Asis Chiraag
2023-07-22 00:00:00 |  |  |  | Stuti
2023-07-23 00:00:00 |  |  |  |  |  | Taran Stuti | [NAME] | Asis Chiraag | Asis Chiraag(half) | Amal
2023-07-25 00:00:00
Spreadsheet: 713948d1611025751-latesbalance-sum-categories-forum-excel-table
Sheet: Épargnes Inv.

1) | [NAME] for latest balance | Thanks again for taking the time:) !! I appreciate it!
2) | [NAME] to sum up same category
 | Solde actuel des comptes: | RED
 |  | BLUE
 |  | YELLOW
 |  | GREEN
Date | Description | ACCOUNT | AMOUNT | BALANCE
2020-03-01 00:00:00 | Deposit | RED | 200
2020-03-01 00:00:00 | Deposit | BLUE | 300 |  |  | Expected result: 340$
2020-03-01 00:00:00 | Deposit | YELLOW | 60
2020-03-01 00:00:00 | Deposit | GREEN | 80
2020-06-15 00:00:00 | Withdrawal | RED | -50
2020-06-15 00:00:00 | Withdrawal | BLUE | -60 |  |  | Expected result: 240$
2020-06-15 00:00:00 | Withdrawal | YELLOW | -40 |  |  | ([NAME] SUM all transactions of
2020-06-15 00:00:00 | Withdrawal | GREEN | -70 |  |  | "BLUE" account until June 15th 2020
2021-01-01 00:00:00 | Deposit | RED | 120 |  |  | and so on…)
2021-01-01 00:00:00 | Deposit | BLUE | 100 |  |  | Expected result: 300$
2021-01-01 00:00:00 | Deposit | YELLOW | 90 |  |  | ([NAME] SUM all transactions of
2021-01-01 00:00:00 | Deposit | GREEN | 80 |  |  | "BLUE" account until March 1st 2020)
 |  |  |  |  |  | Example for formula 2) "BLUE ACCOUNT": |  | AMOUNT | BALANCE
 |  |  |  |  |  | January 1 2021 | Deposit of 100.00$ | 100
 |  |  |  |  |  | June 15 2020 | Withdrawal of 60.00$ | -60
 |  |  |  |  |  | March 1 2020 | Deposit of 300.00$ | 300 | 300
Spreadsheet: 125527d1319074490-formula-for-transmutation-of-numbers-grades-sampler
Sheet: Transmutation table

 |  |  |  |  |  |  |  |  |  |  | given transmutation
I've created |  |  |  |  |  |  |  |  |  |  | TABLE OF PERCENTAGE EQUIVALENT
Transmutation Table
TEMP |  |  |  |  |  |  |  |  |  |  | ITEMIZED
GRADE | TRANSMUTED GRADE |  |  | LOWEST POSSIBLE TRANSMUTTED GRADE is   69
45 | 69 |  |  |  |  |  |  |  |  |  |  | RAW ( TG ) |  |  |  | TRANSMUTED
50.46 | 70 |  |  | HIGHEST POSSIBLE TRANSMUTTED GRADE is 96 |  |  |  |  |  |  |  | 45 | - | 50.45 | = | 69
51.46 | 71 |  |  |  |  |  |  |  |  |  |  | 50.46 | - | 51.45 | = | 70
52.46 | 72 |  |  |  |  |  |  |  |  |  |  | 51.46 | - | 52.45 | = | 71
54.46 | 73 |  |  |  |  |  |  |  |  |  |  | 52.46 | - | 54.45 | = | 72
56.46 | 74 |  |  |  |  |  |  |  |  |  |  | 54.46 | - | 56.45 | = | 73
58.46 | 75 |  |  |  |  |  |  |  |  |  |  | 56.46 | - | 58.45 | = | 74
60.46 | 76 |  |  |  |  |  | how did they get this table |  |  |  |  | 58.46 | - | 60.45 | = | 75
64.46 | 77 |  |  |  |  |  | can you also help me for the computation |  |  |  |  | 60.46 | - | 64.45 | = | 76
66.46 | 78 |  |  |  |  |  |  |  |  |  |  | 64.46 | - | 66.45 | = | 77
68.46 | 79 |  |  |  |  |  |  |  |  |  |  | 66.46 | - | 68.45 | = | 78
70.46 | 80 |  |  |  |  |  |  |  |  |  |  | 68.46 | - | 70.45 | = | 79
72.46 | 81 |  |  |  |  |  |  |  |  |  |  | 70.46 | - | 72.45 | = | 80
74.46 | 82 |  |  |  |  |  |  |  |  |  |  | 72.46 | - | 74.45 | = | 81
76.46 | 83 |  |  |  |  |  |  |  |  |  |  | 74.46 | - | 76.45 | = | 82
78.46 | 84 |  |  |  |  |  |  |  |  |  |  | 76.46 | - | 78.45 | = | 83
80.46 | 85 |  |  |  |  |  |  |  |  |  |  | 78.46 | - | 80.45 | = | 84
82.46 | 86 |  |  |  |  |  |  |  |  |  |  | 80.46 | - | 82.45 | = | 85
84.46 | 87 |  |  |  |  |  |  |  |  |  |  | 82.46 | - | 84.45 | = | 86
86.46 | 88 |  |  |  |  |  |  |  |  |  |  | 84.46 | - | 86.45 | = | 87
88.46 | 89 |  |  |  |  |  |  |  |  |  |  | 86.46 | - | 88.45 | = | 88
90.46 | 90 |  |  |  |  |  |  |  |  |  |  | 88.46 | - | 90.45 | = | 89
92.46 | 91 |  |  |  |  |  |  |  |  |  |  | 90.46 | - | 92.45 | = | 90
94.46 | 92 |  |  |  |  |  |  |  |  |  |  | 92.46 | - | 94.45 | = | 91
96.46 | 93 |  |  |  |  |  |  |  |  |  |  | 94.46 | - | 96.45 | = | 92
97.46 | 94 |  |  |  |  |  |  |  |  |  |  | 96.46 | - | 97.45 | = | 93
98.46 | 95 |  |  |  |  |  |  |  |  |  |  | 97.46 | - | 98.45 | = | 94
99.46 | 96 |  |  |  |  |  |  |  |  |  |  | 98.46 | - | 99.45 | = | 95
 |  |  |  |  |  |  |  |  |  |  |  | 99.46 | - | --- | = | 96
Spreadsheet: 42065d1240597571-combinations-straights-test-straights
Sheet: Sheet1

#1:  Actual Cards |  |  |  |  |  |  |  |  |  | #2: Assigned Values |  |  | #3: TRANSLATED VALUES |  |  |  |  |  |  |  |  |  | #4:  Do I have a Straight?
 | Pocket Cards |  |  | COMMUNITY CARDS |  |  |  |  |  | Assigned Values |  |  |  | Pocket Cards |  |  | COMMUNITY CARDS |  |  |  |  |  |  | YES | NO | RANK
Hand #1 | A | K |  | T | J | 8 | 2 | 9 |  | Card | Value
Hand #2 | T | 4 |  | 4 | 8 | 7 | 6 | Q |  | A | 14
Hand #3 | 3 | 2 |  | A | T | 9 | 8 | 8 |  | K | 13
Hand #4 | 8 | 6 |  | 8 | 4 | 4 | 3 | T |  | Q | 12
Hand #5 | 4 | 5 |  | T | J | Q | 3 | 2 |  | J | 11
Hand #6 | A | T |  | 9 | 9 | 2 | 4 | 8 |  | T | 10
Hand #7 | T | 9 |  | 7 | 6 | 4 | J | 8 |  | 9 | 9
Hand #8 | 6 | 6 |  | 6 | 8 | 7 | 5 | 2 |  | 8 | 8
Hand #9 | 8 | 4 |  | 5 | 6 | 7 | 2 | 9 |  | 7 | 7
Hand #10 | T | 2 |  | J | A | J | 2 | A |  | 6 | 6
Hand #11 | J | T |  | A | Q | 9 | 8 | 2 |  | 5 | 5
Hand #12 | 7 | 2 |  | A | K | K | 7 | 6 |  | 4 | 4
Hand #13 | 9 | 4 |  | T | 9 | 4 | 3 | 8 |  | 3 | 3
Hand #14 | 8 | 8 |  | 7 | 6 | A | J | Q |  | 2 | 2
Hand #15 | Q | Q |  | A | Q | 2 | 6 | 7
RANK REFERENCE |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NOTES
RANK | Cards that make Straight |  |  |  |  |  | RANK | Assigned Values of Straights |  |  |  |  |  |  | * ACTUAL CARDS:  Cards dealt at the table
1 | T | J | Q | K | A |  | 1 |  |  |  |  |  |  |  | * ASSIGNED VALUES:  Numerical values given to A, K, Q, J and T
2 | 9 | T | J | Q | K |  | 2 |  |  |  |  |  |  |  | * TRANSLATED VALUES:  Hole and community cards with numerical identification
3 | 8 | 9 | T | J | Q |  | 3 |  |  |  |  |  |  |  | * STRAIGHT?  I need a formula that identifies Straight and Rank
4 | 7 | 8 | 9 | T | J |  | 4 |  |  |  |  |  |  |  | * RANK:  there are 10 different Straight possibilities, ranked from #1 to #10
5 | 6 | 7 | 8 | 9 | T |  | 5
6 | 5 | 6 | 7 | 8 | 9 |  | 6 |  |  |  |  |  |  |  | * To complete a Straight, I need to use two Pocket Cards and three Community Cards
7 | 4 | 5 | 6 | 7 | 8 |  | 7
8 | 3 | 4 | 5 | 6 | 7 |  | 8
9 | 2 | 3 | 4 | 5 | 6 |  | 9
10 | A | 2 | 3 | 4 | 5 |  | 10