tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 166694d1341739118-sum-unique-values-according-to-criteria-sumif-unique-values-book1
Sheet: Sheet1

Product | GlobalSum |  | Helper |  | Unique | Totals
PT1 | 2 |  | 1 |  | PT1 | 5
PT2 | 4 |  | 1 |  | PT2 | 9
PT1 | 2 |  | 2 |  | PT3 | 7
PT2 | 4 |  | 2
PT3 | 4 |  | 1
PT1 | 3 |  | 1
PT2 | 5 |  | 1
PT3 | 3 |  | 1
PT1 | 3 |  | 2
PT2 | 5 |  | 2
PT1 | 3 |  | 3
PT2 | 5 |  | 3
Spreadsheet: 20db7227-fb63-40d1-bf3d-2b123f3bdc17
Sheet: Hispanic

DistrictCountyNumber | DistrictNumber | DistrictType | DistrictName | DemographicGroup | DemographicCategory | DemographicDescription | FourYearCount_2011 | FourYearPercent_2011 | FourYearCount_2012 | FourYearPercent_2012 | Percent_Increase
27 | 0280 | 01 | RICHFIELD PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 18 | 20.22 | 33 | 40.24 | 20.02
50 | 0492 | 01 | AUSTIN PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 32 | 47.76 | 41 | 65.08 | 17.32
62 | 0622 | 01 | NORTH ST PAUL-MAPLEWOOD SCHOOL DIST | Ethnicity | D | Hispanic | 26 | 53.06 | 46 | 67.65 | 14.59
02 | 0013 | 01 | COLUMBIA HEIGHTS PUBLIC SCHOOL DIST | Ethnicity | D | Hispanic | 29 | 70.73 | 42 | 80.77 | 10.04
19 | 0197 | 01 | WEST ST. PAUL-MENDOTA HTS.-EAGAN | Ethnicity | D | Hispanic | 37 | 71.15 | 42 | 80.77 | 9.62
53 | 0518 | 01 | WORTHINGTON PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 33 | 52.38 | 38 | 60.32 | 7.94
66 | 0656 | 01 | FARIBAULT PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 16 | 39.02 | 18 | 42.86 | 3.84
19 | 0196 | 01 | ROSEMOUNT-APPLE VALLEY-EAGAN | Ethnicity | D | Hispanic | 56 | 58.33 | 64 | 62.14 | 3.81
02 | 0011 | 01 | ANOKA-HENNEPIN PUBLIC SCHOOL DIST. | Ethnicity | D | Hispanic | 54 | 51.92 | 54 | 55.1 | 3.18
27 | 0271 | 01 | BLOOMINGTON PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 34 | 59.65 | 43 | 62.32 | 2.67
27 | 4017 | 07 | MINNESOTA TRANSITIONS CHARTER SCH | Ethnicity | D | Hispanic | 10 | 12.05 | 15 | 14.56 | 2.51
19 | 0191 | 01 | BURNSVILLE PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 22 | 32.35 | 31 | 34.83 | 2.48
27 | 0001 | 03 | MINNEAPOLIS PUBLIC SCHOOL DIST. | Ethnicity | D | Hispanic | 129 | 34.4 | 141 | 36.81 | 2.41
62 | 0625 | 01 | ST. PAUL PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 200 | 57.14 | 196 | 58.51 | 1.37
82 | 0833 | 01 | SOUTH WASHINGTON COUNTY SCHOOL DIST | Ethnicity | D | Hispanic | 61 | 84.72 | 62 | 84.93 | 0.21
27 | 0287 | 06 | INTERMEDIATE SCHOOL DISTRICT 287 | Ethnicity | D | Hispanic | 6 | 5.71 | 5 | 5.43 | -0.28
34 | 0347 | 01 | WILLMAR PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 33 | 34.02 | 27 | 33.33 | -0.69
27 | 0279 | 01 | OSSEO PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 46 | 57.5 | 39 | 56.52 | -0.98
55 | 0535 | 01 | ROCHESTER PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 33 | 52.38 | 30 | 48.39 | -3.99
27 | 0281 | 01 | ROBBINSDALE PUBLIC SCHOOL DISTRICT | Ethnicity | D | Hispanic | 33 | 55.93 | 35 | 49.3 | -6.63
Spreadsheet: 763029d1641950655-how-do-i-create-an-autofill-template-excel-template-associane-numb
Sheet: Sheet1

Name | Associate Number | Performance % |  |  | Name: | Associate Number
 | 523095 | 29.3 |  |  | [NAME] | 408123
 | 827943 | 40.5 |  |  | [NAME] | 120421
 | 987234 | 49.5 |  |  | [NAME] | 523095
 | 120421 | 63.4 |  |  | Jeremiah | 827943
 | 408123 | 76.7 |  |  | [NAME] | 987234
 | 879634 | 96.6 |  |  | Jasmine | 918347
 | 918347 | 99.5 |  |  | [NAME] | 879634
 |  | Goal: 70%
Spreadsheet: 800300d1665586407-date-formula-to-show-on-time-and-late-with-exceptions-help2
Sheet: Sheet1

TAFQAR Date | Mfg | Mfg docs to QA | TAFQAR STATUS MFG
2022-10-03 00:00:00 | 2022-09-16 00:00:00 | 2022-10-03 00:00:00 |  |  |  | The date in in cell [NAME] has to be 5 days before the date in A2 to be considered "On Time", but if there are no dates in the B column then the D column should show "On Time".
2022-10-03 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00
2022-10-03 00:00:00
2022-10-03 00:00:00
2022-10-03 00:00:00
2022-10-04 00:00:00
2022-10-11 00:00:00 | 2022-09-25 00:00:00
2022-10-21 00:00:00 | 2022-09-25 00:00:00
 |  |  |  |  |  | F2 = Late ( C2 is not 5 days before A2) F3 = On Time ([NAME] is at least 5 days before A3) F4 = On Time (B4 is blank meaning no documents required so it cant be late)  If C column is empty and still 5 days before the TAQFAR date then F column should still be on time as well.
Spreadsheet: 835516d1688640055-text-split-then-create-spilling-table-textsplit
Sheet: Feuil1

 |  |  |  |  |  |  | EXPECTED RESULT (SPILLING ARRAY)
values |  |  | values |  |  |  | value1 | value2 | value3 | value4
value1:554,value2:36,value3:abc |  |  |  |  |  |  | 554 | 36 | abc
value1:54,value2:def,value4:52 |  |  | value1:54,value2:def,value4:52 |  |  |  | 54 | def |  | 52
value3:594,value2:6 |  |  | value3:594,value2:6 |  |  |  |  | 6 | 594
Spreadsheet: 73813d1274378520-formulas-in-chart-titles-and-axis-titles-chart
Sheet: Sheet1

Month | Sales |  | Test | [NAME] | <Referenced by Chart Tile and [NAME]
1 | 10000
2 | 15000
3 | 20000
4 | 18000
5 | 10000
6 | 15000
7 | 10000
8 | 15000
9 | 20000
10 | 10000
11 | 8000
12 | 8000
Spreadsheet: 763597d1642263792-look-for-last-instance-of-a-phrase-and-return-column-header-dashboard-setup
Sheet: Site3

RELEASE | EPICS | VERSION | 1-BRD | 2-TSD | 3-Developement | 4-QA | 5-UAT | 6-Launch Acceptance
GLOBAL | Environment Setup |  | Done | Done | In Progress | Not Started | Not Started | Not Started
GLOBAL | Set up AWS Integration Infrastructure |  | Done | In Progress | Not Started | Not Started | Not Started | Not Started
GLOBAL | DAX Integration |  | Done | Done | In Progress | Not Started | Not Started | Not Started
GLOBAL | B2C Customer Group |  | Done | Done | In Progress | Not Started | Not Started | Not Started
GLOBAL | B2B Customer Group |  | Done | Done | In Progress | In Progress | Not Started | Not Started
GLOBAL | Initial Data Loads |  | In Progress | Not Started | Not Started | n/a | n/a | Not Started
GLOBAL | Global Elements
GLOBAL | Home Page
GLOBAL | Global Cart
SHOPPING | Product [NAME]
SHOPPING | Product Listing Page & Search Results
SHOPPING | Category Gateway Page
SHOPPING | Login/Registration
SHOPPING | Facets
SHOPPING | Site Search
SHOPPING | Inventory messaging
SHOPPING | Product Kits (BOM)
SHOPPING | Serialized Products & Core Charges
SHOPPING | Product groups (Collections)
SHOPPING | Product image zoom
SHOPPING | Video in alt images
SHOPPING | PowerReviews (Q&A / Customer reviews)
SHOPPING | Pricing
SHOPPING | Recently Viewed Products
SHOPPING | Backorder Messaging
SHOPPING | Kibo Personalization
SHOPPING | Product Comparison NEW
CHECKOUT | Cart |  | APPROVED
CHECKOUT | Checkout |  | APPROVED
CHECKOUT | Shipping Calculation
CHECKOUT | PayPal
CHECKOUT | Authorize.net
CHECKOUT | Avalara Tax / Tax Exempt / Address validation
CHECKOUT | Transactional emails
CHECKOUT | Coupons
CHECKOUT | Guest Checkout
CHECKOUT | Kount
CHECKOUT | Shipping Restrictions to HI and AK NEW
MY ACCOUNT | Customer Service
MY ACCOUNT | GDPR + CCPA Compliance
MY ACCOUNT | My Account: Settings
MY ACCOUNT | My Account: Order History
MY ACCOUNT | Address book
MY ACCOUNT | My Account: Order Details
MY ACCOUNT | My Account: Order History shipping tracking
MY ACCOUNT | My Account: Favorite Parts (Wishlist) Management
MY ACCOUNT | My Account: Payment Methods
MY ACCOUNT | My Account: Returns
MY ACCOUNT | Google Analytics & GTM
MY ACCOUNT | DataLayer Support
MY ACCOUNT | Static Content Pages
MY ACCOUNT | 301 Redirects
MY ACCOUNT | Google Shopping
MY ACCOUNT | Formstack
MY ACCOUNT | ZenDesk Chat NEW
MY ACCOUNT | Klaviyo NEW
MY ACCOUNT | My Account: Re-order NEW
MY ACCOUNT | Blog NEW
Spreadsheet: 800294d1665583832-formula-to-count-if-one-or-more-criteria-are-met-test-fop
Sheet: SAMPLE (2)

 |  |  |  |  | Test Date: |  | 2019-03-28 00:00:00
 | Contractor: |  |  |  | Operator Name:
 | Instrument Mfg. |  |  |  | CEI:
 | Model: | 3640 |  |  | CEI Name:
 | Serial # | 188778QEDV |  |  | Station: |  | 237406 |  |  | Direction: |  |  | NB
 | Calibration Date: | 2018-10-31 00:00:00 |  |  | Device: |  | CCTV
 | Test Conditions
 |  |  |  |  |  |  |  |  |  | 68
 |  | Soil Condition: |  |  | Moist |  | Dry |  | Temperature |  | F
 |  |  |  |  | Clay |  | Limestone |  | Sand & Gravel
 |  | Soil Type: |  |  | Granite |  | Shale |  | Sandstone
 |  | (choose one) |  |  | [NAME] |  | Slate |  | Other | SOD/Dirt
 |  |  |  |  | Single Rod |  | [NAME] | 20
 |  | Grounding System: |  |  | [NAME] (Grid)
 |  |  |  |  | Longest Diagonal Distance |  |  | 40
 | Z Electrode
 | Minimum Distance: |  | 320
 | Y Electrode Distance |  | Measured Resistance | Percentage Difference
 | % | Feet | Ohms
 | 10 |  | 0
 | 20
 | 30
 | 40
 | 52 |  | 5.8
 | 62 |  | 6.8
 | 72 |  | 7.8
 | 80
 | 90 |  | 15
 |  |  |  |  | Effective Grounding Electrode Resistance: |  |  | Ohms
Spreadsheet: 275440d1383514571-excel-puts-ranked-column-of-cells-in-wrong-order-used-match-large-d-d-row-d-d-false-book2
Sheet: Sheet1

 | 10 | -11
 | 3 | 3
 | 6 | 7
 | 9 | 0
 | 4 | -10
Spreadsheet: 220534dd-e8ef-4483-9bbe-0c038687242e
Sheet: Daftar-Diklat

KODE | JENJANG | NAMA PROGRAM DIKLAT ONLINE
B.01.001 | SD | Panca Indera
B.01.002 | SD | Sistem Reproduksi Manusia
B.02.001 | SMP | Sistem Syaraf Pada Manusia
B.02.002 | SMP | Pewarisan Sifat
B.03.001 | SMA | Sel Molekuler
F.01.001 | SD | Konsep [NAME]
F.01.002 | SD | Konsep Tata Surya
F.02.001 | SMP | Konsep Energi Listrik
F.02.002 | SMP | “Aplikasi Konsep  [NAME] (EKG)  [NAME] Pendengaran
F.03.001 | SMA | [NAME]
K.02.001 | SMP | [NAME]
K.03.001 | SMA | [NAME]
K.03.002 | SMA | Kesetimbangan Dalam Larutan
U.01.001 | UMUM | [NAME] dengan [NAME]
U.01.002 | KUR | Tematik SD
U.01.003 | KUR | IPA Terpadu
Spreadsheet: 846935d1698071686-remaining-shares-per-lot-formulam-excel-share_per_lot_remaining
Sheet: Sheet1

Index | Coin | Buy/Sell | Date | Shares | What I want |  | What I have
1 | ABC | Buy | 2021-02-21 00:00:00 | 50 | 0
2 | ABC | Buy | 2021-02-27 00:00:00 | 10 | 0
3 | ABC | Buy | 2021-06-30 00:00:00 | 10 | 5
4 | ABC | Buy | 2021-09-03 00:00:00 | 10 | 10
5 | ABC | Sell | 2021-10-29 00:00:00 | 65 | 0
6 | ABC | Buy | 2021-12-04 00:00:00 | 10 | 10
7 | ABC | Buy | 2023-07-23 00:00:00 | 5 | 5
1 | DEF | Buy | 2021-05-17 00:00:00 | 10 | 0
2 | DEF | Buy | 2021-08-19 00:00:00 | 10 | 5
3 | DEF | Sell | 2021-08-28 00:00:00 | 15 | 0
Spreadsheet: 773956d1648131690-using-vlookup-with-an-if-and-function-forum_example
Sheet: Sheet1

Product | Shop 1 | Shop 2 |  | Child | Drop Off | Pick Up | Cost | Days | Total | Paid | Owed
08:00:00 | 15:30:00 | 21 |  | 1 | 08:00:00 | 16:00:00 |  | 1 |  | 0
08:00:00 | 16:00:00 | 23.5 |  | 2 | 09:00:00 | 15:30:00 |  | 2 |  | 0
08:00:00 | 16:30:00 | 26 |  | 3 | 08:30:00 | 17:00:00 |  | 3 |  | 0
08:00:00 | 17:00:00 | 26 |  | 4 | 09:00:00 | 16:00:00 |  | 4 |  | 0
08:00:00 | 17:30:00 | 27 |  | 5 | 08:00:00 | 16:00:00 |  | 5 |  | 0
08:00:00 | 18:00:00 | 28 |  | 6
08:30:00 | 15:30:00 | 18.5
08:30:00 | 16:00:00 | 21
08:30:00 | 16:30:00 | 23.5
08:30:00 | 17:00:00 | 26
08:30:00 | 17:30:00 | 27
08:30:00 | 18:00:00 | 28
09:00:00 | 15:30:00 | 16
09:00:00 | 16:00:00 | 18.5
09:00:00 | 16:30:00 | 21
09:00:00 | 17:00:00 | 23.5
09:00:00 | 17:30:00 | 26
09:00:00 | 18:00:00 | 28
Spreadsheet: 880338d1727968902-how-to-make-sum-function-if-red-marked-text-manualvalidationanmacro
Sheet: List1

1 |  |  |  |  |  | 105.5 | 13.57 | 20.22 | 204.1 | 90 | 12.13 | 211.02 | 28.02 | 11.09 | 0.01
2 |  |  |  |  |  | 14.5 | 3.8 | 163.03 | 5.58 | 525.1 | 168.44 | 18.14 | 0.01 | 79.28 | 55.55
3 |  |  |  |  |  | 33.05 | 26.47 | 35 | 21.98 | 0.01 |  | 106.92 | 210.4 | 23.5 | 3.8
4 |  |  |  |  |  | 0.01 | 0.01 | 0.01 | 0.01 | 17 | 0.01 | 17.99 | 90.58 | 3.8
5 |  |  |  |  |  | 3.8 | 13.84 | 3.8 | 32.33 | 29.37 | 36.99 | 13.23 | 3.8 | 0.01
6 |  |  |  |  |  |  |  |  | 3.8 | 57.89 | 25.99 | 53.05
7 |  |  |  |  |  |  |  |  |  | 3.8 | 126.48 | 11.01
8 |  |  |  |  |  |  |  |  |  | 46.01 | 11.09 | 3.8
9 |  |  |  |  |  |  |  |  |  |  | 3.8 | 0.01
10
11
12
13
14
15
16
 |  |  |  | Macro
 |  |  |  | Manual validation |  | 105.5 | 57.69 | 59.02999999999999 | 262.22 | 664.92 | 353.13 | 435.1700000000001 | 332.81 | 94.18 | 3.81 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 78091d1278521705-list-formatting-names01
Sheet: Sheet1

Seq | OWNER_NAME
1 | ABBOTT LORENA
2 | [NAME]
3 | ACOSTA-DIAZ EDUARDO
4 | [NAME]
5 | ADAMS KELLY
6 | ADAMS SANDRA L
7 | [NAME]
8 | ADY LESTER SR TRUST
9 | AGUILAR MIGUEL
10 | AIRLINER MOTEL M & Y INC
11 | ALBEE PRAVIN L
12 | [NAME]
13 | ALBERTSON TIMOTHY W
14 | ALEXANDER LOREN R
15 | ALFANO GREGORY P
16 | ALLAN GARY L
17 | ALLEN CURTIS W
18 | ALT KEVIN F
19 | [NAME]
20 | [NAME]
21 | [NAME] PEGGY ANN
22 | [NAME]
23 | [NAME] T
24 | ANSCHUTZ WADE
25 | ANSON STEVEN L
26 | APPLEGARTH BRAD
27 | ARMBRUST [NAME]
28 | ARTZER STEVEN P
29 | ASHTON BETTY J
30 | ATCHISON DIXIE L (TE)
31 | ATWOOD SHANNON D
32 | AUBERT JOHN A
33 | AUEN VERNON L
34 | AVILA RUBEN
35 | BABBITT RANDY
36 | BACK JESSIE K
37 | BAHM RONALD D
38 | BAILEY S GRAHAM
39 | [NAME] C
40 | BALDWIN WILLIAM
41 | BAME JAMES
42 | BANKERS TRUST COMPANY TRUST
43 | [NAME] A
44 | BARNES DARYL
45 | BATES ALICE L TRUST
Spreadsheet: richard_shapiro__32169__beckyandmelinda
Sheet: Upload

SAP PROFIT CENTER:
PROFIT CENTER OWNER:
SAP COST CATEGORY:
SAP COST | SAP COST |  |  |  |  |  |  |  |  |  |  |  |  | Annual
CENTER | ELEMENT | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | Expense
 | 52000500
 | 52001000
 | 59003000
 | 52003000
 | 52004000
 | 52503500
 | 52004500
 | 52002000
 | 52002500
 | 54005000
 | 52508000
 | 52507500
 | 52504000
 | 52508500
 | 53600000
 | 52508100
 | 53600000
 | 52500500
 | 52003500
 | 52504100
 | 53801000
 | 53800000
 | 52504500
 | 54000000
 | 52502000
 | 52502500
 | 54005000
 | 57200000
 | 57000000
 | 59099900
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: benjamin_rogers__1109__contact numbers
Sheet: Caledonia

 | [NAME]
 | 2278 Caldwell Road, Caledonia, MS 39740
 | General Phone Numbers |  |  | Plant Personnel
 | Control Room 1 | [PHONE] |  | Name | Title | Office | Cellular | Pager | Home | [NAME]
 | Control Room 2 | [PHONE] |  | [NAME] | Plant Manager | [PHONE] | [PHONE]
 | Control Room 3 | [PHONE] |  | [NAME] | Plant Supervisor | [PHONE] | [PHONE] |  | [PHONE]
 | Control Room Fax | [PHONE] |  |  | Maintenace Manager
 | Cordless Phone | [PHONE] |  | [NAME] | Title I&E Engineer | [PHONE] | [PHONE] |  | [PHONE] |  |  | TVA Control Room | [PHONE]
 | On Call Pager 1 | [PHONE] |  | [NAME] | Tech II | [PHONE] |  |  | [PHONE]
 | On Call Pager 2 | [PHONE] |  | [NAME] | Tech II | [PHONE] |  |  | [PHONE]
 |  |  |  | [NAME] | Tech II | [PHONE] | [PHONE] | [PHONE] [PHONE] | [PHONE]
 | Neighboring Control Areas |  |  | [NAME] | Tech II | [PHONE] | N/A |  | [PHONE]
 | TVA Security Coordinator | [PHONE] |  | [NAME] | Manager of EHS | [PHONE] | [PHONE]
 | TVA Transmission | [PHONE] |  |  | Supervisor's Office | ext 104
 | TVA Control Room | [PHONE] |  |  | Library | ext 105
 | FAX | [PHONE] |  |  | Control Room | ext 106
 | TVA Marketing | [PHONE]
 | FAX | [PHONE]
 | Tennessee Pipeline
 | Gas Control | [PHONE]
 | [NAME] | [PHONE]
Spreadsheet: 155423d1336825909-random-table-of-data-need-to-find-every-cell-that-contains-specific-data-random-tables-3-1-
Sheet: Variables

Pitch | Init | % | Prob
[NAME] | RB | 0.25
Fast Ball | FA | 0.23
Change Up | CU | 0.18
[NAME] | DB | 0.1
[NAME] | DC | 0.08
Curve | CB | 0.07
[NAME] | SB | 0.06
Pitch Out | PO | 0.03
Open | O1 | 0
Open | O2 | 0
Open | O3 | 0
Open | O4 | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =
Spreadsheet: 105824d1303125002-array-problem-with-empty-cells-book1_skwiskwis
Sheet: Sheet1

Your formula > |  | Helper Column
[NAME] .
zbor (no helper column)
zbor (no helper column)
 | a
 | b
 | a
 | a
 | b
 | c
 | d
 | b
 | c
 | d
 | b
 | c
 | d
Spreadsheet: 773762d1648038267-compare-2-lists-to-identify-matches-existing-values-test1v2
Sheet: Sheet1

ID | Sheet2 Column H = ABC | Expected | Sheet2 Column H = ABC AND Sheet2 Column J = XYZ | Expected
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: Structuring_Fund

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 95000
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 15
 | Analyst & Associate Headcount |  |  | 14
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Computer Servers | 109134.67
 | Project Costs | 891257
Spreadsheet: 771974d1646936694-sort-function-id-like-as-data-changes-in-table-the-sort-automatically-updates-golf-workings
Sheet: Leaderboard

Column1 | Player | Score | Points |  | Player | Score | Points |  | Helper | player | Score | Position | Score today
 |  |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 |  |  |  |  | Campbell
 |  |  |  |  | Pearce
Spreadsheet: 7237fed4-f6ab-422e-9631-71b46e57ae67
Sheet: Sheet1

EXCEL [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24
 |  |  |  | Network Name:
 |  |  |  | Group #: (Nafe use) |  |  |  |  |  |  | Please fill in number of orders
 |  |  |  |  |  |  |  |  |  | Total orders:
 |  |  |  |  |  |  | Membership Director/Order Contact Name: |  |  | $/order: | 34
 |  |  |  |  |  |  | Phone: |  |  | Total enclosed: | 0
 |  |  |  |  |  |  | E-mail:
 |  |  |  |  |  |  | Mailing Address:
 | Membership # | Membership Start Date | New/  [NAME] | Term | Network code | Account # | Name (first and last) | Title | Company name | Address 2 | Street | City | State | Zip code | Country | Paid amount | Credit card # | Credit card expire date | Credit card type | [NAME] amount | E-mail address | Fax | Telephone | Promo source
1 |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  | blank if US
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 106021d1303254038-simple-pivot-table-question-pivot-example-c-
Sheet: pivot

 |  |  | Project | Group | Owner | Cost | Comments |  |  | Row Labels | Sum of Cost
 |  |  | Project 1 | Red | [NAME] | 10 | Comment 1 |  |  | Blue | 155
 |  |  | Project 2 | Red | Sue | 34 | Comment 2 |  |  | [NAME] | 78
 |  |  | Project 3 | Red | [NAME] | 54 | Comment 3 |  |  | Project 4 | 78
 |  |  | Project 4 | Blue | [NAME] | 78 | Comment 4 |  |  | Comment 4 | 78
 |  |  | Project 5 | Blue | Sue | 12 | Comment 5 |  |  | [NAME] | 65
 |  |  | Project 6 | Blue | [NAME] | 65 | Comment 6 |  |  | Project 6 | 65
 |  |  | Project 7 | Green | [NAME] | 367 | Comment 7 |  |  | Comment 6 | 65
 |  |  | Project 8 | Green | Sue | 432 | Comment 8 |  |  | Sue | 12
 |  |  | Project 9 | Green | [NAME] | 7 | Comment 9 |  |  | Project 5 | 12
 |  |  | Project 10 | Green | [NAME] | 89 | Comment 10 |  |  | Comment 5 | 12
 |  |  |  |  |  |  |  |  |  | Green | 895
 |  |  |  |  |  |  |  |  |  | [NAME] | 456
 |  |  |  |  |  |  |  |  |  | Project 10 | 89
 |  |  |  |  |  |  |  |  |  | Comment 10 | 89
 |  |  |  |  |  |  |  |  |  | Project 7 | 367
 |  |  |  |  |  |  |  |  |  | Comment 7 | 367
 |  |  |  |  |  |  |  |  |  | [NAME] | 7
 |  |  |  |  |  |  |  |  |  | Project 9 | 7
 |  |  |  |  |  |  |  |  |  | Comment 9 | 7
 |  |  |  |  |  |  |  |  |  | Sue | 432
 |  |  |  |  |  |  |  |  |  | Project 8 | 432
 |  |  |  |  |  |  |  |  |  | Comment 8 | 432
 |  |  |  |  |  |  |  |  |  | Red | 98
 |  |  |  |  |  |  |  |  |  | [NAME] | 10
 |  |  |  |  |  |  |  |  |  | Project 1 | 10
 |  |  |  |  |  |  |  |  |  | Comment 1 | 10
 |  |  |  |  |  |  |  |  |  | [NAME] | 54
 |  |  |  |  |  |  |  |  |  | Project 3 | 54
 |  |  |  |  |  |  |  |  |  | Comment 3 | 54
 |  |  |  |  |  |  |  |  |  | Sue | 34
 |  |  |  |  |  |  |  |  |  | Project 2 | 34
 |  |  |  |  |  |  |  |  |  | Comment 2 | 34
 |  |  |  |  |  |  |  |  |  | Grand Total | 1148
Spreadsheet: 859769d1708017289-calculating-ot-in-excel-time-card-1-
Sheet: Sheet1

Date | Job duties | Time In | Time Out |  | Lunch/Break | Daily Total | Weekly Total | OT | Training Center | Route Hours | Vacation | Sick | Holiday
 | Week One
2024-02-12 00:00:00 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  |  |  |  | 0 |  |  |  |  |  | 8
 |  | 06:00:00 | 16:00:00 |  | 0.5
 | Week One Totals
 | Week Two
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 |  | 06:00:00 | 16:00:00 |  | 0.5
 | Week Two Totals
 | Pay Period Total Hours
Spreadsheet: 883511d1732121242-calculating-percentage-returns-over-different-intervals-stock-returns-updated
Sheet: Monthly Returns

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | January | February | March | April | May | June | July | August | September | October | November | December | Average Return | SD Return
AMD |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =MATCH(1,('Historical Data'!$W:$W=VALUE(LEFT('Monthly Returns'!$B$2,FIND("/",'Monthly Returns'!$B$2)-1)))*('Historical Data'!$V:$V=VALUE(RIGHT('Monthly Returns'!$B$2,4))),0)
AVGO
NVDA
BRO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =index('Historical Data'!$B:$U,MATCH(1,('Historical Data'!$W:$W=VALUE(LEFT(,FIND("/",'Holdings'!$B$2)-1)))*('Historical Data'!$V:$V=VALUE(RIGHT('Holdings'!$B$2,4))),0),
MMC
CMG
AAPL
MSFT
MA
V
MCO
BAC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =MIN(IF(('Historical Data'!$V:$V=YEAR('Historical Data'!$B$2)*('Historical Data'!$W:$W=B$1,ROW('Historical Data'!$V:$V),"")
JPM
COST
LULU
TSMC
TSLA
WKHS
SPY
VOO