tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mary_fischer__25613__32H
Sheet: E16.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032H
COMPANY NAME    Williard, Inc.
ANALYSIS OF (GAIN) LOSS ON SALES OF ASSETS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME]
EXT: [PHONE]
**LIST ALL PROPERTY SALES INCLUDING SALES OF REGULATORY ASSETS
**REGULATED COMPANIES DO NOT SHOW (GAIN)/LOSS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  | (A) | + | (B) | + | (C) |  |  | + | (D) | + | (E) | + | (F) | + | (G) |  |  | =
 |  |  |  | GROSS SALE PROCEEDS |  |  |  | NET BOOK VALUE |  |  |  |  |  |  |  |  |  | OTHER (EXPLAIN) |  |  |  | (GAIN) LOSS
 |  | DATE |  |  |  | N/R OR OTHER |  | ASSET |  |  |  |  |  | ACCUM |  | EXP ASSOC |  | AMOUNT |  | HYPERION |  | DR / (CR)
[NAME] OF ASSET |  | OF SALE |  | CASH | + | (EXPLAIN BELOW) | + | AMOUNT |  | HYPERION ACCT | + | PP&E | + | [NAME] | + | WITH SALE | + | DR (CR) |  | ACCT | = | ENDING BAL |  | COMMENTS
PROCEEDS OR BOOK VALUE OF ASSETS
OF $1,000,000 OR MORE:
SALES OF PP&E
SALES OF OTHER ASSETS
 |  |  |  |  |  | (B)
OTHER (LESS THAN $1,000,000) :
Shear & Press Brake |  | May-01 |  | -7500 |  |  |  |  |  |  |  | 73547 |  | -73547
Auto |  | [NAME] |  | -760 |  |  |  |  |  |  |  | 19000 |  | -19000
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ACCT 1676
 |  | EXPLAIN: |  |  |  |  |  |  |  |  |  |  |  |  | Hyperion Income Accts :  DR/(CR)
 |  | Notes Receivable |  |  |  |  |  |  |  |  |  |  |  |  |  | Signs are reversed from Hyperion
 |  | (list amounts and terms):
 |  | Other:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-16
 |  |  |  |  |  | (B)
Spreadsheet: 108295d1305306726-text-to-columns-fixed-width-and-delimited-test
Sheet: Sheet1

First Name | Last Name | [NAME] | Age | Gender | Address | Apt/Dorm # | City | State | Zip Code | Opt-In
[NAME] |  | [EMAIL] | 30-39 | F | 100 [NAME] |  | Enterprise | AL | 36330 | Yes
[NAME] | [NAME] | [EMAIL] | 20-29 | F | 1937 dooley town rd. |  | statham | GA | 30666 | Yes
fightress | aron | [EMAIL] | 20-29 | F | 2201 vaughn lakes blvd | 2433 | MONTGOMERY | AL | 36117 | Yes
jo | abed | [EMAIL] | 60+ | F | 2701 birkdale lane |  | richmond | VA | 23236 | Yes
MARK | LOFF | [EMAIL] | 50-59 | M | 510 LAUREL STREET |  | READING | PA | 19602 | Yes
[NAME] | ABRAMSON | [EMAIL] | 60+ | F | 10 GENATARY LANE |  | WILLINGBORO | NJ | 08046 | Yes
orlena | aire | [EMAIL] | 20-29 | F | 110 brandon lee rd |  | whitesburg | KY | 41858 | Yes
Eva | Ackley | [EMAIL] | 50-59 | F | 602 Centre Street |  | [NAME] | NJ | 08244 | Yes
Crystal | [NAME] | [EMAIL] | 20-29 | F | 625 Linden St. |  | [NAME] | LA | 70003 | Yes
Spreadsheet: 879343d1726827082-average-formula-in-conflict-with-vlookup-example-new
Sheet: Results

[NAME] | Data | Results
Cotton | Production Plan PCS
Cotton | Actual production PCS
Cotton | OTIF %
Cotton | Backlog pcs
Apple | Production Plan PCS
Apple | Actual production PCS
Apple | OTIF %
Apple | Backlog pcs
Orange | Production Plan PCS
Orange | Actual production PCS
Orange | OTIF %
Orange | Backlog pcs
 |  | Results here
Spreadsheet: 845697d1697100600-group-and-increment-avoiding-duplications-seq1-1-2-
Sheet: Sheet1

VARIATION 1
 | Cust1 | Cust2 | Cust3 | Cust4 | Cust5 | SEQUENCE
Grp1 | X |  | X |  |  |  | 1
[NAME] |  | X |  |  |  |  | 1
Grp3 | X |  |  | X |  |  | 2
Grp4 |  |  |  | X |  |  | 3
Grp5 |  |  |  |  | X |  | 1
Grp6 |  |  | X |  | X |  | 2
Grp7 | X |  |  | X | X |  | 4 |  | Why is this 4, not 3?
Grp8 | X |  |  |  |  |  | 5 |  | Why is this 5, not 4?
Grp9 |  | X | X |  |  |  | 3
[NAME] | X |  | X | X |  |  | 6 |  | Why is this 6 not 5?
 | Cust1 | Cust2 | Cust3 | Cust4 | Cust5 | SEQUENCE
Grp1
[NAME]
Grp3
Grp4
Grp5
Grp6
Grp7
Grp8
Grp9
[NAME]
Spreadsheet: bb479064-092d-4f15-98f7-e7fb9bc49160
Sheet: Sheet1

LUTHERAN THEOLOGICAL SEMINARY | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
MONTHLY - HOURLY TIME SHEET
Name: |  |  |  |  |  |  | [NAME]:
 |  |  |  |  |  |  |  | (office use)
Position: |  |  |  |  |  |  | Total Hours: | 0
Pay Period: |  |  |  |  |  |  | Gross Total: | 0
Dept | Date | Time In | Time Out | Total     Hours * | Dept | Date | Time In | Time Out | Total     Hours *
Sub-Total (First Column) |  |  |  | 0 | Sub-Total (Second Column) |  |  |  | 0
 |  |  |  |  | Grand-Total |  |  |  | 0
 | *Hours are paid in 1/4 hour increments.
 | I hereby certify that the above is a true statement of the hours which I worked.
 | Signature of Employee: |  |  |  |  | Date:
 | Signature of Supervisor: |  |  |  |  | Date:
 | Dept Head Signature |  |  |  |  | Date:
 | Dept Head Signature |  |  |  |  | Date:
 | Dept Head Signature |  |  |  |  | Date:
Spreadsheet: 762482d1641573698-need-a-countif-formula-that-works-with-subtotal-sample-book-1
Sheet: Sheet1

 | False | New | Option
 | 2022
 | 2023
Type | State
#N/A | AZ
#N/A | AZ
2022- Option | AZ
#N/A | CA
2022- New | CA
#N/A | CA
2023- New | CA
Spreadsheet: 715751d1611851217-sum-on-a-pivot-table-column-with-multiple-criteria-match-person-between-two-dates-summing-values-by-month-using-pt-or-formula-jcyr55-
Sheet: Dashboard

Implementation Resource Planning
Team Member | Start Date | End Date | Allocation % |  |  | Employee
[NAME] | 2021-01-25 00:00:00 | Feb | 0.35 |  |  | [NAME]
 |  | May | 1.04 |  |  | [NAME]
 |  | Jun | 0.54 |  |  | [NAME]
 |  | Jul | 0.04 |  |  | [NAME]
[NAME] | 2021-01-25 00:00:00 | May | 1 |  |  | [NAME]
[NAME] | 2021-01-25 00:00:00 | Feb | 0.04 |  |  | [NAME]
 |  | May | 0.34 |  |  | [NAME]
 |  | Jun | 0.54 |  |  | Troy
 |  | Jul | 0.04 |  |  | Unassigned
 | 2021-01-29 00:00:00 | Jun | 0.35 |  |  | Ellen
 | 2021-02-01 00:00:00 | Feb | 0.74
[NAME] | 2021-01-25 00:00:00 | May | 0.35
 |  | Jul | 0.35
 |  | Dec | 0.35
 | 2021-01-29 00:00:00 | Jun | 0.04
 | 2021-02-01 00:00:00 | Feb | 0.04
[NAME] | 2021-01-25 00:00:00 | Jun | 1
[NAME] | 2021-01-25 00:00:00 | May | 1
 |  | Jun | 0.08
Troy | 2021-01-25 00:00:00 | Mar | 0.35
 |  | May | 1
 |  | Jun | 0.1
 |  | Oct | 0.35
Unassigned | 2021-01-25 00:00:00 | Jun | 0.04
 |  | Jul | 0.04
 |  | Dec | 0.04
Ellen | 2021-01-25 00:00:00 | Feb | 0.35
 |  | May | 0.27
 |  | Jun | 0.62
 |  | Jul | 0.37
 |  | Dec | 0.27
 | 2021-01-29 00:00:00 | Jun | 0.1
 | 2021-02-01 00:00:00 | Feb | 0.1
[NAME] | 2021-01-25 00:00:00 | Jun | 0.04
 |  | Jul | 0.35
 | 2021-02-01 00:00:00 | Feb | 0.08
[NAME] | 2021-01-25 00:00:00 | Feb | 0.04
 |  | May | 0.04
 |  | Jun | 0.4299999999999999
 |  | Oct | 0.35
 |  | Dec | 0.04
 | 2021-02-01 00:00:00 | Feb | 0.35
[NAME] | 2021-01-25 00:00:00 | Jun | 0.35
 |  | Jul | 0.04
 |  | Oct | 0.1
 | 2021-01-29 00:00:00 | Jun | 0.35
 | 2021-02-01 00:00:00 | Feb | 0.35
[NAME] | 2021-01-25 00:00:00 | May | 0.5
 |  | Jun | 1
[NAME] | 2021-01-25 00:00:00 | May | 0.1
 |  | Jun | 1
[NAME] | 2021-01-25 00:00:00 | Feb | 0.39
 |  | Jun | 0.35
 |  | Jul | 0.35
[NAME] | 2021-01-25 00:00:00 | Feb | 0.35
 |  | May | 0.35
 |  | Jun | 0.35
 |  | Jul | 0.35
 |  | Dec | 0.35
 | 2021-01-29 00:00:00 | Jun | 0.04
 | 2021-02-01 00:00:00 | Feb | 0.04
Spreadsheet: 582758d1532027155-concanating-cell-contents-based-on-criteria-concat-cell-contents
Sheet: Sheet1

 | Input
 |  |  | Overdue | Name | Due |  |  | Output
 |  | High | Yes | Name 6
 |  | Medium | Yes | Name 1 |  |  |  |  |  | Overdue |  | Near Term
 |  | Medium | Yes | Name 2 |  |  |  | Very High |  | 0 |  | 0
 |  | High | Yes | Name 7
 |  | High | Yes | Name 8
 |  | Medium | Yes | Name 3 |  |  |  | High |  | 3 |  | Aug
 |  | Medium | Yes | Name 4 |  |  |  |  |  | Name 6 Name 7 Name 8 |  | Sept
 |  | Medium | Yes | Name 5
 |  | Medium | No | Name A | 2018-08-01 00:00:00 |  |  | Medium |  | 5 |  | Aug | 2 | Name A Name B
 |  | Medium | No | Name B | 2018-08-05 00:00:00 |  |  |  |  | Name 1 Name 2 Name 3 Name 4 Name 5 |  | Sept | 1 | Name D
 |  | Low | No | Name C | 2018-08-01 00:00:00
 |  | High | No | Name D | 2018-09-10 00:00:00 |  |  | Low |  | 0 |  | Aug | 1 | Name C
 |  |  |  |  |  |  |  |  |  |  |  | Sept
Spreadsheet: 685285d1593879942-fill-blanks-from-other-tabs-holiday-chart
Sheet: May

Name | Site |  |  | 2021-05-01 00:00:00 | 2021-05-02 00:00:00 | 2021-05-03 00:00:00 | 2021-05-04 00:00:00 | 2021-05-05 00:00:00 | 2021-05-06 00:00:00 | 2021-05-07 00:00:00 | 2021-05-08 00:00:00 | 2021-05-09 00:00:00 | 2021-05-10 00:00:00 | 2021-05-11 00:00:00 | 2021-05-12 00:00:00 | 2021-05-13 00:00:00 | 2021-05-14 00:00:00 | 2021-05-15 00:00:00 | 2021-05-16 00:00:00 | 2021-05-17 00:00:00 | 2021-05-18 00:00:00 | 2021-05-19 00:00:00 | 2021-05-20 00:00:00 | 2021-05-21 00:00:00 | 2021-05-22 00:00:00 | 2021-05-23 00:00:00 | 2021-05-24 00:00:00 | 2021-05-25 00:00:00 | 2021-05-26 00:00:00 | 2021-05-27 00:00:00 | 2021-05-28 00:00:00 | 2021-05-29 00:00:00 | 2021-05-30 00:00:00 | 2021-05-31 00:00:00 | Total holidays | Total sick days | Total training days | Total days in lieu | Total weekend working
A Sample | [NAME]
B
C
D
E
F
G
H
I
Spreadsheet: 164789d1340891953-sum-columns-based-on-column-headings-offset-sum
Sheet: Sheet1

 | <1100>1 | <1100R>1 | <1018>1 | <1018R>1 | <1019>1 | <1019R>1 | <2005>1 | <2005R>1 | <1100>2 | <1100R>2 | <2005>2 | <2005R>2 |  |  |  | Total
 | <1100> | <1100R> | <1018> | <1018R> | <1019> | <1019R> | <2005> | <2005R> | <1100> | <1100R> | <2005> | <2005R> |  |  | <1018> | 68
 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 |  |  | <1019> | 28
 | 5 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 |  |  | <1100> | 72
 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 |  |  | <1100> | 60
 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 | 1 | 7 |  |  | <2005> | 32
 | 5 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 |  |  | <2005> | 40
 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9
 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 | 1 | 8
 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9
 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 | 1 | 2
 | 5 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6
 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 | 1 | 2
 | 5 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6
Spreadsheet: 711996d1610013378-how-to-reference-or-find-a-whole-month-in-order-to-find-corresponding-data-example
Sheet: Sheet1

 | date | amount | category | description |  |  |  |  | 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-01-19 00:00:00 | 793.2157424689843 | manufacuturing | raw materials |  |  | office supplies | printer
 | 2020-01-20 00:00:00 | 465.4523385206585 | office supplies | printer paper |  |  | office supplies | chairs
 | 2020-03-19 00:00:00 | 113.7474512908302 | packaging | repairs |  |  | packaging | maintenance
 | 2020-03-27 00:00:00 | 503.7659816134972 | office supplies | printer paper |  |  | packaging | supplies
 | 2020-04-04 00:00:00 | 950.0314409277963 | manufacuturing | maintenance |  |  | manufacuturing | raw
 | 2020-04-12 00:00:00 | 840.6975914146053 | manufacuturing | maintenance |  |  | manufacuturing | maintenance
 | 2020-05-11 00:00:00 | 355.2266935587126 | packaging | supplies
 | 2020-05-14 00:00:00 | 718.5633560767365 | manufacuturing | raw materials
 | 2020-05-17 00:00:00 | 321.1895086592373 | manufacuturing | maintenance
 | 2020-05-24 00:00:00 | 201.2859636629194 | packaging | materials
 | 2020-05-30 00:00:00 | 611.2702777770525 | manufacuturing | raw materials
 | 2020-06-03 00:00:00 | 788.1315365219751 | manufacuturing | discardation
 | 2020-06-25 00:00:00 | 668.9830376400133 | packaging | installation
 | 2020-07-23 00:00:00 | 554.6038568253077 | packaging | new machine
 | 2020-08-01 00:00:00 | 411.2082630423009 | manufacuturing | raw materials
 | 2020-08-04 00:00:00 | 590.952710697995 | office supplies | printer
 | 2020-08-11 00:00:00 | 502.9410172845846 | manufacuturing | raw materials
 | 2020-09-04 00:00:00 | 685.275482254 | packaging | supplies
 | 2020-09-11 00:00:00 | 884.664530573648 | office supplies | chairs
 | 2020-09-16 00:00:00 | 367.7512849655972 | packaging | repairs
 | 2020-10-04 00:00:00 | 544.4386059323381 | manufacuturing | discardation
 | 2020-10-11 00:00:00 | 573.9819104535738 | office supplies | paperclips
 | 2020-12-07 00:00:00 | 668.4393341495951 | office supplies | tacks
 | 2020-12-15 00:00:00 | 159.2853240589621 | manufacuturing | raw materials
 | 2020-12-17 00:00:00 | 387.9078428187544 | manufacuturing | machine maintenance
 | 2020-12-21 00:00:00 | 776.0952514018581 | manufacuturing | maintenance
Spreadsheet: 84590d1284638250-index-based-on-2-criteria-index-based-on-date-
Sheet: Sheet2

part | date | cost |  | A | B | C | D | E
A | 5 | 4 |  | 5 | 0 | 0 | 0 | 0
B | 1 | 1 |  | 0 | 1 | 0 | 0 | 0
B | 2 | 2 |  | 0 | 2 | 0 | 0 | 0
B | 12 | 8 |  | 0 | 12 | 0 | 0 | 0
C | 3 | 3 |  | 0 | 0 | 3 | 0 | 0
C | 8 | 7 |  | 0 | 0 | 8 | 0 | 0
C | 2 | 9 |  | 0 | 0 | 2 | 0 | 0
D | 1 | 5 |  | 0 | 0 | 0 | 1 | 0
E | 10 | 6 |  | 0 | 0 | 0 | 0 | 10
 |  |  | [NAME] | 5 | 12 | 8 | 1 | 10
Cost of Highest Date |  |  |  |  |  | Cost of Product
A | B | C | D | E |  | A | B | C | D | E
4 |  |  |  |  |  | 4 | 8 | 7 | 5 | 6
 | 8
 |  | 7
 |  |  | 5
 |  |  |  | 6
Spreadsheet: 707375d1607226403-getting-discount-depend-on-last-pay-date-paid-off-date-problem-discount
Sheet: Sheet1

 |  |  |  |  |  |  |  | my expected result
 |  |  | name | date payment | payment |  | name | discount
 |  |  | jhon | 2020-12-04 00:00:00 | 50 |  | jhon | 100 | cause he have paid off before 31/01/2021)
 |  |  | [NAME] | 2020-12-05 00:00:00 | 150 |  | sisca | ?
 |  |  | sisca | 2020-12-05 00:00:00 | 50 |  | [NAME] | ?
 |  |  | sisca | 2020-12-07 00:00:00 | 50
 |  |  | sisca | 2021-04-01 00:00:00 | 100 | paid off - last pay (50+50+100)
 |  |  | jhon | 2020-12-30 00:00:00 | 75
 |  |  | jhon | 2021-01-31 00:00:00 | 75 | paid off - last pay (50+75+75)
 |  |  | [NAME] | 2021-02-01 00:00:00 | 50 | paid off - last pay(150+50)
 |  |  |  | note
 |  |  | 1 | total value of payment for each people accumulative must paid off 200
 |  |  | 2 | if people pay (paid off) before <=31/01/2021 , get discount 100
 |  |  | 3 | if people pay (paid off)  in 01/02/2012 till 31/03/2021 , get discount 50
 |  |  | 4 | if people pay (paid off) after 31/03/2021, ge discount 0
Spreadsheet: 135432d1326054440-excel-2007-formula-to-calculate-hrs-worked-less-break-if-working-more-than-5-hrs-for-all-shift-calc-hrs-worked
Sheet: Sheet1

Empl name | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 | 2011-12-25 00:00:00
 | in | Out | in | Out | in | Out | in | Out | in | Out | in | Out | in | Out
 | 08:00:00 | 1900-01-01 00:00:00 | 08:00:00 | 23:00:00 | 07:00:00 | 15:30:00 | 07:00:00 | 15:30:00 |  |  |  |  | 23:30:00 | 08:00:00
Time less 30 min
Total Time
The above 2 lines show the individual calculations for each "in-out" entry.  The 2 rows, and the box, can be deleted once you have looked at them
Spreadsheet: 105062d1302540643-calculate-repeating-date-range-mob-tracking
Sheet: MOB Tracking

MOB/DEMOB + Return  Tracking
First Name | Last Name | Start Date | Position | Days Off | MOB Cycle | DEMOB | MOB IN | Comments
[NAME] | Fehr | 2011-03-21 00:00:00 | TK | 4 | 24 | 2011-04-14 00:00:00 | 2011-04-18 00:00:00
[NAME] | Vaags | 2011-04-06 00:00:00 | SAF/BL | 4 | 24 | 2011-04-30 00:00:00 | 2011-05-04 00:00:00
[NAME] | Coghill | 2011-03-27 00:00:00 | GF | 4 | 24 | 2011-04-20 00:00:00 | 2011-04-24 00:00:00
[NAME] | Holzbauer | 2011-03-25 00:00:00 | BLF | 4 | 10 | 2011-04-04 00:00:00 | 2011-04-08 00:00:00
 |  | 2011-04-06 00:00:00 |  |  |  | 2011-04-06 00:00:00
 |  | 2011-03-21 00:00:00 |  | 4 | 24 | 2011-07-10 00:00:00 | 2011-07-14 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-04-06 00:00:00 |  |  |  | 2011-04-06 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-04-06 00:00:00 |  |  |  | 2011-04-06 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-04-06 00:00:00 |  |  |  | 2011-04-06 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-04-06 00:00:00 |  |  |  | 2011-04-06 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-04-06 00:00:00 |  |  |  | 2011-04-06 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-04-06 00:00:00 |  |  |  | 2011-04-06 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-04-06 00:00:00 |  |  |  | 2011-04-06 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
 |  | 2011-04-06 00:00:00 |  |  |  | 2011-04-06 00:00:00
 |  | 2011-03-21 00:00:00 |  |  |  | 2011-03-21 00:00:00
Spreadsheet: 774247d1648327904-calculate-ownership-in-companies-using-a-table-and-formulas-automatically-shareholding-ownership-structure
Sheet: OwnershipB

 |  |  |  |  |  |  |  |  |  |  |  |  | preferred
 | Cliente | My client |  |  |  |  |  |  |  |  | option A |  | option B
Company / Individual | [NAME] | Level | Empresa abaixo | % (level before) |  |  | Unique | Unique Individual | Level
Company | DEF LLC | 1 | My client | 1
Company | GHI | 2 | DEF LLC | 0.15 |  |  |  | [NAME] | 2
Company | JKL | 2 | DEF LLC | 0.35 |  |  | GHI | [NAME] | 3
Company | MNO | 2 | DEF LLC | 0.5 |  |  | JKL |  | 4
Individual | [NAME] | 3 | GHI | 1 |  |  | MNO |  | 0
Individual | [NAME] | 3 | JKL | 0.2 |  |  | [NAME]
Individual | [NAME] | 3 | JKL | 0.8 |  |  | [NAME]
Individual | [NAME] | 4 | MNO | 0.7 |  |  | [NAME]
Individual | [NAME] | 4 | MNO | 0.3 |  |  | 0
 |  |  |  | https://stackoverflow.com/questions/71608514/excel-for-the-web-script-to-open-path-folder-in-windows-file-explorer
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: BAR

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
BARCODE LEMON 12/16.9Z BTL | 11032 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ** Friday 7/21
BARCODE MALIBU 12/16.9Z BTL | 11036
BARCODE WTRMLN 12/16.9Z BTL | 11034
BARCODE BLK CH 12/16.9Z BTL | 11035
BARCODE GRAPE 12/16.9Z BTL | 11033
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
BARCODE LEMON 12/16.9Z BTL | 11032
BARCODE MALIBU 12/16.9Z BTL | 11036
BARCODE WTRMLN 12/16.9Z BTL | 11034
BARCODE BLK CH 12/16.9Z BTL | 11035
BARCODE GRAPE 12/16.9Z BTL | 11033
Spreadsheet: 172909fb-bf08-42ea-9c8a-c275f0289967
Sheet: Headcount - Spring

Return to Contents
Headcount Enrollment - Spring Historical
 |  |  |  | UH | UH COMMUNITY COLLEGES
 |  | UH | UH | WEST
 | TOTAL | MĀNOA | HILO | O‘AHU | SUBTOTAL | Hawaii | Honolulu | Kapi‘olani | Kaua‘i | Leeward | Maui | [NAME]
1981 | 42017 | 19499 | 3327 | 303 | 18888 |  | 4861 | 4472 | 1093 | 5331 | 1819 | 1312
1982 | 44095 | 19818 | 3384 | 346 | 20547 |  | 5340 | 4737 | 1188 | 5797 | 2091 | 1394
1983 | 45653 | 20126 | 3588 | 405 | 21534 |  | 5703 | 4955 | 1145 | 5962 | 2302 | 1467
1984 | 43357 | 19777 | 3326 | 404 | 19850 |  | 4770 | 4708 | 1160 | 5704 | 2169 | 1339
1985 | 41911 | 19031 | 3107 | 437 | 19336 |  | 4436 | 4973 | 1112 | 5417 | 2048 | 1350
1986 | 40726 | 18575 | 1474 | 435 | 20242 | 1746 | 4162 | 4757 | 1065 | 5146 | 1958 | 1408
1987 | 40272 | 17731 | 1636 | 494 | 20411 | 1562 | 4173 | 4758 | 1157 | 5414 | 1884 | 1463
1988 | 40638 | 17491 | 1696 | 494 | 20957 | 1692 | 4206 | 4898 | 1139 | 5655 | 1943 | 1424
1989 | 40890 | 17530 | 1778 | 539 | 21043 | 1823 | 4066 | 5375 | 1226 | 5099 | 1977 | 1477
1990 | 40859 | 17589 | 1929 | 601 | 20740 | 1957 | 3730 | 5399 | 1170 | 4955 | 2053 | 1476
1991 | 44029 | 18086 | 2510 | 625 | 22808 | 1710 | 4136 | 6305 | 1337 | 5570 | 2281 | 1469
1992 | 45483 | 18613 | 2678 | 690 | 23502 | 1776 | 4292 | 6450 | 1466 | 5451 | 2489 | 1578
1993 | 47707 | 18993 | 2789 | 695 | 25230 | 2182 | 4451 | 6944 | 1423 | 6079 | 2470 | 1681
1994 | 49153 | 19206 | 3184 | 689 | 26074 | 2349 | 4557 | 7241 | 1428 | 6198 | 2629 | 1672
1995 | 48721 | 19099 | 2700 | 722 | 26200 | 2597 | 4562 | 7075 | 1428 | 6267 | 2627 | 1644
Note: Data may not match [NAME] reports due to changes in enrollment counting methodology.
Spreadsheet: 769451d1645544802-sort-data-range-in-stepped-using-formula-sortsample
Sheet: Expected

Route ID | Types | Vehicle # | Driver Last | Driver First | Monitor Last | Monitor First | Parkout [NAME] | CoOrd PO | Monitor Address | [NAME] | 1st AM Pick Up | Lat/Lon 1st AM Pick Up | Last AM Drop OFF | Lat/Lon Last AM Drop OFF | 1st PM Pick Up | Lat/Lon 1st PM Pick Up | Last PM Drop OFF | Lat/Lon Last PM Drop OFF
123457 | AM,PM | 2222 | Last Name 02 | First Name 02 | Last Name 01 | First Name 01 | 124 Address | 43.642760, -79.387067 | 360 Manor Rd, [NAME], ON N5R 6H2 | 42.7762672, -81.1564021 | 124 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067 | 124 Address | 43.642760, -79.387067
123458 | AM,PM | 3333 | Last Name 03 | First Name 03 | Last Name 02 | First Name 02 | 125 Address | 43.642760, -79.387067 | 292287 [NAME], Brownsville, ON N0L 1C0 | 42.8639142, -80.8404292 | 125 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067 | 125 Address | 43.642760, -79.387067
123461 | NOON | 6666 | Last Name 06 | First Name 06 | Last Name 03 | First Name 03 | 128 Address | 43.642760, -79.387067 | 113 Chandler Terrace, Woodstock, ON N4S | 43.1609717, -80.7508204 | 128 Address | 43.642760, -79.387067 | 128 Address | 43.642760, -79.387067
123462 | NOON | 7777 | Last Name 07 | First Name 07 | Last Name 04 | First Name 04 | 129 Address | 43.642760, -79.387067 | 167 Linwood St, London, ON N5Y 1W7 | 43.0099661, -81.2271203 | 129 Address | 43.642760, -79.387067 | 129 Address | 43.642760, -79.387067
123456 | AM,PM | 1111 | Last Name 01 | First Name 01 |  |  | 123 Address | 43.642760, -79.387067 |  |  | 123 Address | 43.642760, -79.387067 | 123 Address | 43.642760, -79.387067 | 123 Address | 43.642760, -79.387067 | 123 Address | 43.642760, -79.387067
123459 | AM,PM | 4444 | Last Name 04 | First Name 04 |  |  | 126 Address | 43.642760, -79.387067 |  |  | 126 Address | 43.642760, -79.387067 | 126 Address | 43.642760, -79.387067 | 126 Address | 43.642760, -79.387067 | 126 Address | 43.642760, -79.387067
123460 | NOON | 5555 | Last Name 05 | First Name 05 |  |  | 127 Address | 43.642760, -79.387067 |  |  | 127 Address | 43.642760, -79.387067 | 127 Address | 43.642760, -79.387067
123463 | NOON | 8888 | Last Name 08 | First Name 08 |  |  | 130 Address | 43.642760, -79.387067 |  |  | 130 Address | 43.642760, -79.387067 | 130 Address | 43.642760, -79.387067
123464 | NOON | 9999 | Last Name 09 | First Name 09 |  |  | 131 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 127 Address | 43.642760, -79.387067 | 127 Address | 43.642760, -79.387067
123465 | NOON | 11110 | Last Name 10 | First Name 10 |  |  | 132 Address | 43.642760, -79.387067 |  |  |  |  |  |  | 128 Address | 43.642760, -79.387067 | 128 Address | 43.642760, -79.387067