tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 94331d1294174015-transposing-columnwise-data-to-rowwise-data-transposing-data
Sheet: Sheet1

Sr.No. | Company Name | Date1 | Amt1 | Date2 | Amt2 | Date3 | Amt3 | [NAME] | Amt4 | Date5 | Amt5 |  | DO's CODE | Date | Amt
1 | ABC | 2008-12-14 00:00:00 | 100 |  |  | 2008-12-02 00:00:00 | 1000 | 2008-12-10 00:00:00 | 256 |  |  |  | ABC | 2008-12-14 00:00:00 | 100
2 | LMN |  |  | 2009-06-15 00:00:00 | 10000 |  |  |  |  | 2009-06-24 00:00:00 | 25000 |  |  | 1900-01-01 00:00:00 | 0
3 | PQR | 2010-04-07 00:00:00 | 649 |  |  | 2010-11-22 00:00:00 | 957 |  |  | 2010-12-12 00:00:00 | 6067 |  |  | 2008-12-02 00:00:00 | 1000
4 | XYZ | 2010-01-01 00:00:00 | 2145 | 2010-03-24 00:00:00 | 916 | 2010-06-12 00:00:00 | 451 | 2010-09-12 00:00:00 | 995 |  |  |  | LMN | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-15 00:00:00 | 10000
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | PQR | 2010-04-07 00:00:00 | 649
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-11-22 00:00:00 | 957
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-01-01 00:00:00 | 2145
Spreadsheet: 115944d1311381850-organize-data-with-new-headings-automatically-autofillcolumns
Sheet: Sheet1

Oranges | Plums | Cherries | Grapefruit | Apples |  |  |  | New Order > |  | Apples | Grapefruit | Oranges | Cherries | Plums
2 | 1 | 55 | 666 | 656
2 | 1 | 55 | 676 | 656
3 | 1 | 5 | 565 | 566
2 | 1 | 5 | 565 | 565
4 | 1 | 55 | 5665 | 566
2 | 1 | 5 | 755 | 565
32 | 1 | 5 | 544 | 555
32 | 1 | 5 | 445 | 555
4 | 1 | 55 | 343 | 555
2 | 11 | 5 | 344 | 556
 | 10
Spreadsheet: 747516d1631547885-maximum-number-od-conditional-rules-excel-sample
Sheet: Training 1-51

Name of Report: | 2021 EPIC SHIP VT SCHEDULE REPORT |  | M | Priority 1: Mandatory Trainings Overdue, to be completed immediately at the earliest
Company: | Epic Ship Management |  | M | Priority 2: Mandatory training, need to be completed at next most suitable opportunity after completing all Priority 1
Vessels included: |  |  | 2020-07-24 00:00:00 | Training Completed: Date of completion of the subject training
 |  |  | - | Training Not applicable to that specific rank
TrainingCode | Title
1 | Title 001
2 | Title 002
3 | Title 003
4 | Title 004
5 | Title 005
6 | Title 006
7 | Title 007
8 | Title 008
9 | Title 009
10 | Title 010
11 | Title 011
12 | Title 012
13 | Title 013
14 | Title 014
15 | Title 015
16 | Title 016
17 | Title 017
18 | Title 018
19 | Title 019
20 | Title 020
21 | Title 021
22 | Title 022
23 | Title 023
24 | Title 024
25 | Title 025
26 | Title 026
27 | Title 027
28 | Title 028
29 | Title 029
30 | Title 030
31 | Title 031
32 | Title 032
33 | Title 033
34 | Title 034
35 | Title 035
36 | Title 036
37 | Title 037
38 | Title 038
39 | Title 039
40 | Title 040
41 | Title 041
42 | Title 042
43 | Title 043
44 | Title 044
45 | Title 045
46 | Title 046
47 | Title 047
48 | Title 048
49 | Title 049
50 | Title 050
51 | Title 051
 | Total Trainings
 | Not Completed
 | Completed
 | % Completed
Spreadsheet: 115654d1311194476-merging-multiple-workbooks-to-one-file-test
Sheet: 2009

 | Team | DYAR | Rk | YAR | Rk | DVOA | Rk | VOA | Passes | Yards | EYds | TD
B.Favre | MIN | 1808 | 5 | 1867 | 3 | 0.39 | 4 | 0.406 | 571 | 4108 | 5359 | 33
Spreadsheet: 810230d1671628353-how-to-delete-cells-with-text-and-keep-cell-that-has-numbers-test-8-
Sheet: Sheet1

Main - 16
16-02 | 16-08 | 16-11 | 16-12 | 16-14
XYZ | XYZ | XYZ | XYZ | XYZ
A311, xxxxxx, | A311, xxxxxx, | A311, xxxxxx, | A311, xxxxxx, | A311, xxxxxx,
xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx
xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxx - 297
7207263403 | 92461 64011 / 65546450 | 98490 35111 / 65580029 | 92966 51780 /  24560775 | 93470 55211 / 66611680
 |  |  |  |  |  | 99669 94499 / 66731204
16-51 | 16-53 | 16-55 | 16-59 | 16-66 |  | 93910 22163 / 66566542
XYZ | XYZ | XYZ | XYZ | XYZ |  | 92461 64011 / 65546450
A311, xxxxxx, | xxxxx xxxxx xxxxxx | A311, xxxxxx, | A311, xxxxxx, | xxxxx xxxxx xxxxxx |  | 92461 80493 / 66901575
xxxxx xxxxx xxxxxx | xxxxx xxxx - 297 | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxx - 297 |  | 93475 22673 / 66566542
xxxxx xxxx - 297 | 92461 80493 / 66901575 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | 93910 12959 / 66566542 |  | 98490 35111 / 65580029
99669 94499 / 66731204 |  | 98495 55159 / 24577243 | 99665 51066 / 65537578 / 9 |  |  | 98495 55159 / 24577243
 |  |  |  |  |  | 9246119600
 |  |  |  |  |  | 92966 51780 /  24560775
16-67 | 16-68 | 16-69 | 16-71 | 16-74 |  | 99665 51066 / 65537578 / 9
XYZ | XYZ | XYZ | XYZ | XYZ |  | 93911 43879 / 66365645
xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | A311, xxxxxx, | A311, xxxxxx, | xxxxx xxxxx xxxxxx |  | 93470 55211 / 66611680
xxxxx xxxx - 297 | xxxxx xxxx - 297 | xxxxx xxxxx xxxxxx | xxxxx xxxxx xxxxxx | xxxxx xxxx - 297 |  | 93910 12959 / 66566542
93910 22163 / 66566542 | 93475 22673 / 66566542 | xxxxx xxxx - 297 | xxxxx xxxx - 297 | 93903 63349 / 66144727 |  | 93903 63349 / 66144727
 |  | 9246119600 | 93911 43879 / 66365645
Spreadsheet: 741978d1627468405-if-formula-searching-for-text-dinner-bookings
Sheet: JohnTopley

Name | Class | Main | Absent | Home Sandwiches | Main 1 | Vegetarian | Jacket Potato | Choice |  |  |  |  | jacket
Fred | 1 | Home Sandwiches |  |  |  |  |  |  |  |  |  |  | home sandwiches
[NAME] | 1 | Sausage & Mash |  |  |  |  |  |  |  |  |  |  | bean burger
[NAME] | 1 | Sausage & Mash |  |  |  |  |  |  |  |  |  |  | butternut
[NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  | cauliflower
Annabelle | 1 | Sausage & Mash |  |  |  |  |  |  |  |  |  |  | cheese & onion
Sky | 1 | Home Sandwiches |  |  |  |  |  |  |  |  |  |  | cheese & tomato
[NAME] | 1 | Sausage & Mash |  |  |  |  |  |  |  |  |  |  | cheesy
Sophie | 1 | Home Sandwiches |  |  |  |  |  |  |  |  |  |  | chickpea
[NAME] | 1 | Home Sandwiches |  |  |  |  |  |  |  |  |  |  | free
[NAME] | 1 | Sausage & Mash |  |  |  |  |  |  |  |  |  |  | [NAME]
Isabelle | 1 | Home Sandwiches |  |  |  |  |  |  |  |  |  |  | quorn
May | 1 | Sausage & Mash |  |  |  |  |  |  |  |  |  |  | ratatouille
Ella | 1 | Sausage & Mash |  |  |  |  |  |  |  |  |  |  | Vegetable
[NAME] | 1 | Home Sandwiches |  |  |  |  |  |  |  |  |  |  | Vegetarian
[NAME] | 1 |  |  |  |  |  |  |  |  |  |  |  | veggie
Lloyd | 1 | Sausage & Mash |  |  |  |  |  |  |  |  |  |  | wormy
George | 1
Spreadsheet: 240397d1370312874-print-sheet-calculator-papercalc-v3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Size | L | W
 | Paper Product | Length | [NAME] |  | Quantity |  |  |  | Custom
 | Custom |  |  |  | 11 | Input Quantity |  |  | DL | 99 | 210
 |  | 120 | 120 |  |  |  |  |  | DLE | 110 | 220
Set | Bleed | 3 |  |  |  |  |  |  | F4 | 210 | 330
 | New dimensions |  |  |  |  |  |  |  | RA0 | 841 | 189
 | Gutter? |  |  |  |  |  |  |  | RA1 | 610 | 860
 | Total required Area |  |  |  |  |  |  |  | RA2 | 430 | 610
 |  |  |  |  |  |  |  |  | RA3 | 305 | 430
 |  |  |  |  |  |  |  |  | RA4 | 215 | 305
 | Paper Source | Length | [NAME] |  | Required |  |  |  | SRA0 | 900 | 280
 | SRA3 |  |  |  |  | Answer |  |  | SRA1 | 640 | 900
Set | [NAME] | 5 |  |  |  |  |  |  | SRA2 | 450 | 640
 | Effective edge |  |  |  |  |  |  |  | SRA3 | 320 | 450
 | Total usable area |  |  |  |  |  |  |  | SRA4 | 225 | 320
 |  |  | pieces per Sheet |  |  |  |  |  | A3+ | 329 | 483
 |  |  |  |  |  |  |  |  | Paper Source | L | W
 |  |  |  |  |  |  |  |  | SRA3 | 320 | 450
 |  |  |  |  |  |  |  |  | A3 | 297 | 420
 |  |  |  |  |  |  |  |  | A4 | 210 | 297
Spreadsheet: 841222d1693427214-scrollable-candlestick-not-showing-full-data-mktcandle
Sheet: DATA2

Date | POINTS
2023-02-01 00:00:00 | 17779
2023-02-02 00:00:00 | 17824
2023-02-03 00:00:00 | 17855
2023-02-06 00:00:00 | 17814
2023-02-07 00:00:00 | 17820
2023-02-08 00:00:00 | 17807
2023-02-09 00:00:00 | 17825
2023-02-10 00:00:00 | 17855
2023-02-13 00:00:00 | 17805
2023-02-14 00:00:00 | 17817
2023-02-15 00:00:00 | 17817
2023-02-16 00:00:00 | 17843
2023-02-17 00:00:00 | 17837
2023-02-20 00:00:00 | 17824
2023-02-21 00:00:00 | 17799
2023-02-22 00:00:00 | 17818
2023-02-23 00:00:00 | 17842
2023-02-24 00:00:00 | 17806
2023-02-27 00:00:00 | 17808
2023-02-28 00:00:00 | 17800
2023-03-01 00:00:00 | 17806
2023-03-02 00:00:00 | 17841
2023-03-03 00:00:00 | 17830
2023-03-06 00:00:00 | 17823
2023-03-08 00:00:00 | 17814
2023-03-09 00:00:00 | 17850
2023-03-10 00:00:00 | 17860
2023-03-13 00:00:00 | 17855
2023-03-14 00:00:00 | 17834
2023-03-15 00:00:00 | 17814
2023-03-16 00:00:00 | 17848
2023-03-17 00:00:00 | 17862
2023-03-20 00:00:00 | 17811
2023-03-21 00:00:00 | 17842
2023-03-22 00:00:00 | 17851
2023-03-23 00:00:00 | 17824
2023-03-24 00:00:00 | 17869
2023-03-27 00:00:00 | 17840
2023-03-28 00:00:00 | 17828
2023-03-29 00:00:00 | 17825
2023-03-31 00:00:00 | 17821
2023-04-03 00:00:00 | 17838
2023-04-05 00:00:00 | 17868
2023-04-06 00:00:00 | 17855
2023-04-10 00:00:00 | 17860
2023-04-11 00:00:00 | 17831
2023-04-12 00:00:00 | 17827
2023-04-13 00:00:00 | 17815
2023-04-17 00:00:00 | 17816
2023-04-18 00:00:00 | 17833
2023-04-19 00:00:00 | 17859
2023-04-20 00:00:00 | 17836
2023-04-21 00:00:00 | 17858
2023-04-24 00:00:00 | 17816
2023-04-25 00:00:00 | 17839
2023-04-26 00:00:00 | 17857
2023-04-27 00:00:00 | 17862
2023-04-28 00:00:00 | 17833
2023-05-02 00:00:00 | 17829
2023-05-03 00:00:00 | 17849
2023-05-04 00:00:00 | 17810
2023-05-05 00:00:00 | 17865
2023-05-08 00:00:00 | 17860
2023-05-09 00:00:00 | 17829
2023-05-10 00:00:00 | 17803
2023-05-11 00:00:00 | 17820
2023-05-12 00:00:00 | 17867
2023-05-15 00:00:00 | 17809
2023-05-16 00:00:00 | 17825
2023-05-17 00:00:00 | 17839
2023-05-18 00:00:00 | 17862
2023-05-19 00:00:00 | 17815
2023-05-22 00:00:00 | 17847
2023-05-23 00:00:00 | 17856
2023-05-24 00:00:00 | 17853
2023-05-25 00:00:00 | 17815
2023-05-26 00:00:00 | 17844
2023-05-29 00:00:00 | 17858
2023-05-30 00:00:00 | 17803
2023-05-31 00:00:00 | 17827
2023-06-01 00:00:00 | 17868
2023-06-02 00:00:00 | 17805
2023-06-05 00:00:00 | 17841
2023-06-06 00:00:00 | 17843
2023-06-07 00:00:00 | 17804
2023-06-08 00:00:00 | 17811
2023-06-09 00:00:00 | 17832
2023-06-12 00:00:00 | 17846
2023-06-13 00:00:00 | 17868
2023-06-14 00:00:00 | 17817
Spreadsheet: 0fda912a-6dbb-487d-8837-aca41cd5ef49
Sheet: 14c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared
Index Tranche | - | 37 | - | 29
Index | 3536 | 1969 | 2958 | 821
OTHER* | 23 | 198 | 15 | 84
TOTAL | 3559 | 2204 | 2973 | 934
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 169910d1343107021-conditional-formatting-based-on-distance-from-median-value-excel-2010-conditional-format-final-2003
Sheet: My Soltuion  (2)

DIRECT | 2012-07-16 00:00:00 | 2012-07-17 00:00:00 | 2012-07-18 00:00:00 | 2012-07-19 00:00:00 | 2012-07-20 00:00:00 | 2012-07-21 00:00:00 | 2012-07-22 00:00:00 | Weekly Total
 | 0.6956 | 0.8811 | 0.865 | 0.9637 | 0.8594 | 1 | 0.9863 | 0.8568
 | 0.4619 | 0.8321 | 0.6803 | 0.9386 | 0.6488 | 0.9105 | 0.8755 | 0.7134
 | 1 | 1 | 1 | 1 | 1 |  | 0.5 | 0.7778
 | 0.8 | 0.57 | 0.75 | 0.75 | 1 | 1 | 0.5 | 0.72
 | 0.6739 | 0.8205 | 0.8587 | 0.9302 | 0.8906 | 0.963 | 1 | 0.8443
 | 0.4575 | 0.8015 | 0.7332 | 0.9461 | 0.6862 | 0.965 | 0.928 | 0.7459
 | 0.65 | 0.9 | 0.8148 | 1 | 0.7647 | 1 | 1 | 0.84
 | 0.4236 |  | 0.6076 | 0.9286 | 0.6529 | 1 | 0.9524 | 0.6866
 |  | 0.8002 | 0.6155 | 0.25 | 0.6514 | 0.985 | 0.9648 | 0.6974
 | 0.7048 | 0.5 | 0.7986 | 0.9744 | 0.8819 | 0.9737 | 0.9048 | 0.83
 | 0.4369 | 0.8365 | 0.6612 | 0.9228 | 0.4801 | 0.8434 | 0.8986 | 0.6777
 | 0.4565 | 0.7895 | 0.675 | 0.9737 | 0.6279 | 1 | 1 | 0.7112
 | 0.45 | 1 | 1 | 1 | 0.8889 | 1 |  | 0.8173
Median | 0.5559499999999999 | 0.8263 | 0.75 | 0.9461 | 0.7647 | 0.9924999999999999 | 0.9402
> | 0.70595 | 0.9763000000000001 | 0.9 | 1.0961 | 0.9147000000000001 | 1.1425 | 1.0902
< | 0.4059499999999999 | 0.6763 | 0.6 | 0.7961 | 0.6147 | 0.8424999999999999 | 0.7902
Spreadsheet: darrell_schoolcraft__7314__imball0202
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1 | -72039 | -57926
2 | -56841 | -58000
3 | -38014 | -45943
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 21548
2002-02-03 00:00:00
CBS Volume
 |  |  | 13942
Spreadsheet: 765844d1643636446-add-extra-filter-to-aggregate-report-example
Sheet: REPORT

ICL OVERZICHT CBS
 |  |  | January
Maand |  | Januari | <<< Want to show only records within this month
Intracommunautair |  | Yes | <<< Currently only looking for "Yes" in orderdisplay
Records
Record nr. | Date | Client
 |  |  | <<< After selecting the month it should hide this record number
Spreadsheet: 885998d1735934985-sum-cell-in-a-range-bob_miller
Sheet: Sheet1

Reason | Time | Reason | Time | Reason | Time | Reason | Time | Reason | Time | Reason | Time | Reason | Time
Maint | 5 | Maint | 5 | Maint | 5 | Maint | 5 | Maint | 5 | Maint | 5 | Maint | 5
[NAME] | 6 | [NAME] | 6 | [NAME] | 6 | [NAME] | 6 | [NAME] | 6 | [NAME] | 6 | [NAME] | 6
Parts | 7 | Parts | 7 | Parts | 7 | Parts | 7 | Parts | 7 | Parts | 7 | Parts | 7
M Power | 8 | M Power | 8 | M Power | 8 | M Power | 8 | M Power | 8 | M Power | 8 | M Power | 8
Ch Over | 9 | Ch Over | 9 | Ch Over | 9 | Ch Over | 9 | Ch Over | 9 | Ch Over | 9 | Ch Over | 9
Total Time |  | Maint |  | [NAME] |  | Parts |  | M Power |  | Ch Over
Spreadsheet: 855635d1705145427-dispaying-names-based-on-ranking-scores-from-another-sheet-champ-scoring
Sheet: Mens Final

CFBEGA CLUB CHAMPIONSHIP DAY 2 FINAL
 | CATEGORY | [NAME] |  |  |  | CATEGORY | [NAME]
 | MEN'S GROSS | ARBUTUS | GROSS |  |  | MEN'S NET | ARBUTUS | NET
RANK | LAST | FIRST | SCORE |  | RANK | LAST | FIRST | SCORE
1
2
3
4
5
6
7
8
9
10
11
12
12
14
15
16
17
18
19
20
21
22
23
24
24
26
27
28
29
Spreadsheet: 769101d1645295683-calculate-total-engine-time-cell-r2-when-the-engine-mode-is-on-logbookdraft_enginetime
Sheet: Logbook

 | Date: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Engine Time:
 | Boat: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effort Time:
 | Crew: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Photo Time:
 | S/S: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Photo ID:
 | C/C: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Animals:
 | [NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Known Animals:
 | TIME | SPECIES |  |  |  |  | OBSERVATIONS | WAYPOINT |  | EFFORT MODE | ENGINE MODE | PHOTO MODE | PHOTO DATA | ANIMAL ID | BIOPSY MODE | BIOPSY DATA | BIOPSY OBSERVATIONS
 | 08:00:00 |  |  |  |  |  |  |  |  |  | ON
 | 09:00:00 |  |  |  |  |  |  |  |  |  | OFF
 | 09:30:00
 | 10:00:00 |  |  |  |  |  |  |  |  |  | ON
 | 10:05:00
 | 10:30:00 |  |  |  |  |  |  |  |  |  | OFF
Spreadsheet: 266651d1379688648-double-if-or-if-and-formula-not-sure-how-to-make-the-formula-test4
Sheet: Sheet1

 |  |  |  |  |  |  |  | price discounts | 1st item | 2nd item | next item
 |  |  |  |  |  |  |  | plan 1 | 100 | 100 | 100
 |  |  |  |  |  |  |  | plan 2 | 0.45 | 100 | 100
 |  |  |  |  |  |  |  | plan 3 | 0.45 | 100 | 100
 |  |  |  |  |  |  |  |  | full price | plan 1 | plan 2 | plan 3
 |  |  |  |  |  |  |  | 1st Item | 182
 |  |  |  |  |  |  |  | 2nd Item | 75
 |  |  |  |  |  |  |  | next item | 573
Spreadsheet: 762815d1641832698-formula-to-count-low-med-or-high-in-4-columns-of-data-split-by-fiscal-quarter-book2
Sheet: Sheet1

What I have |  |  |  |  |  | What I need to populate
Quarter | [NAME] | Emotional | Family | Social |  |  |  | [NAME] | Emotional | Family | Social
 | Low | Med | Med |  |  | Quarter 1 | Low
 |  | Med | Med |  |  |  | Medium
 | Low | Low |  |  |  |  | High
 |  | Low |  |  |  | Quarter 2 | Low
 | Med | High |  | Med |  |  | Medium
 |  | Med |  |  |  |  | High
 |  | Med |  | Med |  | Quarter 3 | Low
 | Med | High |  | Med |  |  | Medium
 | Med | Med | Med | Med |  |  | High
 |  |  |  |  |  | Quarter 4 | Low
 |  |  |  |  |  |  | Medium
 |  |  |  |  |  |  | High
Spreadsheet: 794801d1662317319-help-with-formula-and-function-absence-tracker-hslt-absence-tracker
Sheet: Calendar View

 | EMPLOYEE ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select an Employee: |  |  |  |  |  |  |  |  | Employee 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select a Year: |  |  |  |  |  |  |  |  | 2022
 |  |  |  |  |  |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
 |  | KEY STATISTICS
 |  |  |  |  |  |  |  |  | Unpaid Dep Care |  |  |  |  |  | # Days Sick |  |  |  |  |  | # Paid Dependant Care |  |  |  |  |  |  |  | # [NAME] |  |  |  |  |  |  | # Paid LOA |  |  |  |  |  |  | # UNPAID LOA
Spreadsheet: 771589d1646747769-formula-upper-case-caps-name-and-surname-name
Sheet: Sheet1

Original List | New List
BRINCAU John | [NAME]
GREEN George | [NAME]
BANASIA Maria Polina | [NAME]
CASSIA Olga | [NAME]
GATT Gilbert [NAME] | [NAME]
HERNANDEZ Pedro [NAME] | [NAME]
CORDOBA SOLAN Maria | [NAME]
HUGO FONSECA Julia | Julia Hugo Fonseca
Spreadsheet: 716493d1612237147-return-a-sign-if-there-is-any-values-inside-the-month-if-not-a-sign-forum-excel-1-f-v-2021
Sheet: Archive

 | Revenus et dépenses mensuelles par Mois / Année / Catégorie |  |  |  |  |  |  | Revenu individuel par [NAME] |  |  |  | Dépense individuelle par [NAME]
 | Choisissez une option d’affichage |  | Choisissez une année de départ |  | [NAME] affichée:
 | Année financière |  | 2020
 |  |  |  |  |  |  |  | Aimerais-tu voir les revenus globaux? |  |  |  | Aimerais-tu voir les dépenses globales?
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Moy. Mois
 | Soldes des comptes par mois, année et compte |  |  |  |  |  |  | Solde comptes individuel
 | Choisissez une option d’affichage |  | Choisissez une année de départ |  | [NAME] affichée: |  |  |  |  | Argent métal |  | FTQ (REER)
 | Année financière |  | 2020 |  |  |  |  |  |  | [NAME] (CÉLI) |  | Urgence
Spreadsheet: 696792d1600974216-transpose-rows-of-data-to-column-with-1st-cell-in-row-repeated-test-workbook
Sheet: Sheet1

Stock Number | REF1 | REF2 | [NAME] | REF4 | REF5 | REF6 | REF7 | REF8 | REF9 | REF10
SKU01 | Red | Blue | Green | Black | Purple | [NAME] | Orange | Yellow | Navy | Pink |  |  |  |  |  | SKU01 | Red
SKU02 | Small | Medium | Large | X-Small | X-Large |  |  |  |  |  |  |  |  |  |  | SKU01 | Blue
SKU03 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  |  |  | SKU01 | Green
SKU04 | Excel | Word | Powerpoint | Outlook |  |  |  |  |  |  |  |  |  |  |  | SKU01 | Black
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU01 | Purple
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU01 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU01 | Orange
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU01 | Yellow
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU01 | Navy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU01 | Pink
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU02 | Small
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU02 | Medium
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU02 | Large
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU02 | X-Small
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU02 | X-Large
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU03 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU03 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU03 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU03 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU03 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU03 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU03 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU03 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU03 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU03 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU04 | Excel
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU04 | Word
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU04 | Powerpoint
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SKU04 | Outlook
Spreadsheet: 151811d1335132067-pulling-data-from-one-workbook-based-on-data-in-another-workbook-sampledata
Sheet: Sheet1

[NAME] | Sequence | RO | Date | Make | Part 1 | Part 2 | Desc | CWI | Qty | Cost | Sale
10933-5024 | 4965 | 1525954 | 2011-03-01 00:00:00 |  | ZLDRI-WASH | DRI-WASH | CLEANER | I | 1 | 4.5 | 6.5
10932-5024 | 4966 | 1525955 | 2011-03-01 00:00:00 |  | ZLDRI-WASH | DRI-WASH | CLEANER | I | 1 | 4.5 | 6.5
10907-5024 | 4967 | 1525957 | 2011-03-01 00:00:00 |  | HO19210285 | 19210285 | FILTER | C | 1 | 4.41 | 7.95
10908-5024 | 4968 | 1525957 | 2011-03-01 00:00:00 |  | MI68026605-AA | 68026605-AA | OIL 10W30 | C | 5 | 2.31 | 2.4
10926-5024 | 4969 | 1525958 | 2011-03-01 00:00:00 |  | HO19210283 | 19210283 | FILTER | C | 1 | 3.93 | 7.99
10927-5024 | 4970 | 1525958 | 2011-03-01 00:00:00 |  | MI68026605-AA | 68026605-AA | OIL 10W30 | C | 6 | 2.31 | 2.4
10914-5024 | 4971 | 1525959 | 2011-03-01 00:00:00 |  | [NAME] | CBHZL080-AA | FAN COOLING | W | 1 | 7.45 | 10.43
Spreadsheet: benjamin_rogers__1039__Consolidated 6 Peaker-051800
Sheet: Gleason

INCOME STATEMENT - GLEASON
('000 $)
Revenue
Fixed Price Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Demand Payment
Energy Payment
Block Payment
Amortization of Contract
Market Price & Price Extension Period:
Demand Payment | 0 | 0 | 0
Variable Revenue | 0 | 0 | 0
Energy Margin | 0 | 0 | 0
Interest Income
Total Revenue
Expense
Fixed O&M
Variable O&M
Major Maintenance & Ongoing Capex
O&M Management Fee
Owner's Expense
Property Taxes Liability | 174.46 | 348.92 | 436.15 | 436.15 | 436.15 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 523.38 | 872.3 | 872.3 | 1308.45 | 743.9310449999999 | 758.8096658999999 | 773.985859218 | 789.4655764023599 | 805.2548879304072
Franchise Tax
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
EBT
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
After Tax Book Income
CASH FLOW - GLEASON
('000 $) | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
EBITDA less Contract Amortization
Plus Property Tax Liability
Less Property Tax Expense | -92.2251014
Debt Service
Pre Tax Cash Flow
State Cash Taxes Benefit (Expense)
Federal Cash Taxes Benefit (Expense)
After Tax Cash Flow
STATE TAX & FRANCHISE TAX - GLEASON
 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22
('000 $) | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
FRANCHISE TAX
Book Value of Assets
Paid-In-Capital
[NAME]
Outstanding Debt
Total Capitalization
Greater of Book Value and Capitalization
State Franchise Tax Rate
State Franchise Tax Liability | 604.8509301179399 | 586.1442003204779 | 567.4374705230159 | 548.7307407255538 | 530.0240109280918 | 511.3172811306298 | 492.6105513331677 | 473.9038215357057 | 455.1970917382437 | 436.4903619407817 | 417.7836321433197 | 399.0769023458576 | 380.3701725483956 | 361.6634427509335 | 342.9567129534715 | 324.2499831560094 | 305.5432533585474 | 286.8365235610853 | 268.1297937636232 | 249.4230639661612
STATE TAXES
Pretax Book Income less Contract Amortization
Plus Book Depreciation & Amortization
Less Tax Depreciation
State Taxable Income
State Income Tax Rate
Current State Income Tax Expense (Benefit)
Beginning NOL's | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
New NOL's
Expired NOL's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
NOL Utilization
Ending NOL's
Total State Taxes Utilizing NOLs