tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 72c048e7-292a-4b35-b230-91a1ae921036
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
8008 | 30485 | [NAME] | [NAME] | LUX | 15 | 00:00:00 | 00:00:00 | [NAME] | 00:01:10 | 00:16:03 | 1 | 00:30:04
8008 | 47012 | [NAME] | [NAME] | NOR | 16 | 00:00:00 | 00:00:00 | [NAME] | 00:01:33 | 00:16:56 | 2 | 00:30:33
8008 | 47849 | [NAME] | Pap | HUN | 14 | 00:00:00 | 00:00:00 | 00:13:09 | 00:01:15 | 00:16:22 | 3 | 00:30:49
8008 | 29879 | [NAME] | [NAME] | DEN | 17 | 00:00:00 | 00:00:00 | 00:13:09 | 00:01:30 | 00:16:50 | 4 | 00:31:31
Spreadsheet: 856591d1705783535-count-instances-based-on-multiple-criteria-avoiding-date-duplicates-onsite-count-etaf-2
Sheet: Sheet1

Project ID | Staff Name | Subtype | Duration | Date | Count
46418 | [NAME] | Onsite | 105 | 2024-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | Staff Name | Date | Project ID | Sum of Count
46418 | [NAME] | Onsite | 15 | 2024-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | [NAME] | 2024-02-01 00:00:00 | 63520 | 1
63520 | [NAME] | Project Management | 60 | 2024-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2024-03-01 00:00:00 | 17606 | 1
63520 | [NAME] | Project Management | 45 | 2024-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 63520 | 2
63520 | [NAME] | Project Management | 30 | 2024-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2024-04-01 00:00:00 | 50185 | 1
63520 | [NAME] | Project Management | 30 | 2024-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 60961 | 1
17606 | [NAME] | Administration | 30 | 2024-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | [NAME] | 2024-02-01 00:00:00 | 63520 | 1
63520 | [NAME] | Onsite | 30 | 2024-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2024-03-01 00:00:00 | 63520 | 1
63520 | [NAME] | Project Management | 15 | 2024-03-01 00:00:00 |  |  |  |  |  |  |  |  |  | [NAME] | 2024-02-01 00:00:00 | 17606 | 1
63520 | [NAME] | Onsite | 45 | 2024-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 46418 | 1
17606 | [NAME] | Administration | 75 | 2024-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2024-04-01 00:00:00 | 50185 | 1
50185 | [NAME] | Onsite | 60 | 2024-04-01 00:00:00
50185 | [NAME] | Onsite | 30 | 2024-04-01 00:00:00
60961 | [NAME] | Project Management | 90 | 2024-04-01 00:00:00
Spreadsheet: 846962d1698087877-create-dropdown-list-when-an-option-is-selected-in-b2-b44-dropdown-list_sample-3-
Sheet: Here

S/N | W4 Type | W-4 (2020 or [NAME] (before 2020)?
1 | W-4 (before 2020) | Exempt
2 | W-4 (before 2020)
3 | W-4 (before 2020)
4 | W-4 (2020 or later)
5 | W-4 (2020 or later)
6 | W-4 (2020 or later)
7 | W-4 (2020 or later)
8 | W-4 (2020 or later)
9 | W-4 (2020 or later)
10 | W-4 (2020 or later)
11 | W-4 (2020 or later)
12 | W-4 (2020 or later)
13 | W-4 (2020 or later)
14 | W-4 (2020 or later)
15 | W-4 (2020 or later)
16 | W-4 (2020 or later)
17 | W-4 (2020 or later)
18 | W-4 (2020 or later)
19 | W-4 (2020 or later)
20 | W-4 (2020 or later)
21 | W-4 (2020 or later)
22 | W-4 (2020 or later)
23 | W-4 (2020 or later)
24 | W-4 (2020 or later)
25 | W-4 (2020 or later)
26 | W-4 (2020 or later)
27 | W-4 (2020 or later)
28 | W-4 (2020 or later)
29 | W-4 (2020 or later)
30 | W-4 (2020 or later)
31 | W-4 (2020 or later)
32 | W-4 (2020 or later)
33 | W-4 (2020 or later)
34 | W-4 (2020 or later)
35 | W-4 (2020 or later)
36 | W-4 (2020 or later)
37 | W-4 (2020 or later)
38 | W-4 (2020 or later)
39 | W-4 (2020 or later)
40 | W-4 (2020 or later)
41 | W-4 (2020 or later)
42 | W-4 (2020 or later)
43 | W-4 (2020 or later)
Spreadsheet: 78f71c79-6f59-40b2-b788-75d86c8cc357
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Schönheide - Variante 2
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 15 | 517 | 509 | 460 | 398
15 - 65 | 2938 | 2667 | 2282 | 2036
65 und mehr | 1463 | 1460 | 1562 | 1540
Insgesamt | 4918 | 4636 | 4304 | 3974
%
unter 15 | 10.51240341602277 | 10.9792924935289 | 10.68773234200743 | 10.01509813789633
15 - 65 | 59.73973159821065 | 57.52804141501294 | 53.02044609665428 | 51.23301459486663
65 und mehr | 29.74786498576657 | 31.49266609145815 | 36.29182156133829 | 38.75188726723704
Insgesamt | 100 | 100 | 100 | 100
Abhängigkeitsquotient
Jugendquotient | 17.59700476514636 | 19.08511436070491 | 20.15775635407537 | 19.54813359528487
Altenquotient | 49.79577944179714 | 54.74315710536183 | 68.44872918492551 | 75.6385068762279
Gesamtquotient | 67.3927842069435 | 73.82827146606674 | 88.60648553900089 | 95.18664047151277
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 487440d1478088026-vba-to-keep-a-running-total-per-person-book1-37-
Sheet: Transactions

Person | Type of transaction | Value
person1 | opening balance | 100
person1 | Prize | 10
person1 | Sale | -50
person2 | opening balance | 10
person2 | Prize | 40
person2 | sale | -50
Spreadsheet: 699055d1602358421-read-a-cell-value-from-the-cluster-of-small-tables-score
Sheet: Men

Sys. BP |  | Non-smoker |  |  |  |  |  | Smoker |  |  |  |  |  | Age
180 |  | 14 | 16 | 19 | 22 | 26 |  | 26 | 30 | 35 | 41 | 47 |  | 65
160 |  | 9 | 11 | 13 | 15 | 16 |  | 18 | 21 | 25 | 29 | 34
140 |  | 6 | 8 | 9 | 11 | 13 |  | 13 | 15 | 17 | 20 | 24
120 |  | 4 | 5 | 6 | 7 | 9 |  | 9 | 10 | 12 | 14 | 17
180 |  | 9 | 11 | 13 | 15 | 18 |  | 18 | 21 | 24 | 28 | 33 |  | 60
160 |  | 6 | 7 | 9 | 10 | 12 |  | 12 | 14 | 17 | 20 | 24
140 |  | 4 | 5 | 6 | 7 | 9 |  | 8 | 10 | 12 | 14 | 17
120 |  | 3 | 3 | 4 | 5 | 6 |  | 6 | 7 | 8 | 10 | 12
180 |  | 6 | 7 | 8 | 10 | 12 |  | 12 | 13 | 16 | 19 | 22 |  | 55
160 |  | 4 | 5 | 6 | 7 | 8 |  | 8 | 9 | 11 | 13 | 16
140 |  | 3 | 3 | 4 | 5 | 6 |  | 5 | 6 | 8 | 9 | 11
120 |  | 2 | 2 | 3 | 3 | 4 |  | 4 | 4 | 5 | 6 | 8
180 |  | 4 | 4 | 5 | 6 | 7 |  | 7 | 8 | 10 | 12 | 14 |  | 50
160 |  | 2 | 3 | 3 | 4 | 5 |  | 5 | 6 | 7 | 8 | 10
140 |  | 2 | 2 | 2 | 3 | 3 |  | 3 | 4 | 5 | 6 | 7
120 |  | 1 | 1 | 2 | 2 | 2 |  | 2 | 3 | 3 | 4 | 5
180 |  | 1 | 1 | 1 | 2 | 2 |  | 2 | 2 | 3 | 3 | 4 |  | 40
160 |  | 1 | 1 | 1 | 1 | 1 |  | 1 | 2 | 2 | 2 | 3
140 |  | 0 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 2 | 2
120 |  | 0 | 0 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1
 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
Spreadsheet: 146067d1331888268-maintenance-schdule-check-sheet-maintenance_planing
Sheet: Planing

Select the Week
Select the Year
 |  |  | 2007-12-31 00:00:00
 |  |  | MON |  |  | TUE |  |  | WED |  |  | THU |  |  | FRI |  |  | SAT |  | SUN
 |  |  | MON1 | MON2 | MON3 | TUE1 | TUE2 | TUE3 | WED1 | [NAME] | WED3 | THU1 | THU2 | THU3 | FRI1 | FRI2 | FRI3 | SAT1 | SAT2 | SUN1 | SUN2
 | Select the Schedule | Select the Shift
 | Every Shift | Morning | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Daily | Morning | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Daily | Morning | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Every Shift | Morning
Daily | Afternoon
Weekly | Night
2 Weeks
Monthly
3 months
6 months
Yearly
Spreadsheet: 768168d1644861935-dynamic-spill-list-spill-list-example
Sheet: Sheet1

No | Range | Result | Dynamic Range List
1 | Current | -1
2 | Current | 9
3 | Current | -8
4 | Current | 5
5 | Current | 9
6 | Current | 9
7 | Current | -8
8 | New | -10
9 | Current | 9
10 | Current | 1
11 | Current | -3
12 | Current | 2
13 | Current | -2
14 | Current | -1
15 | New | 10
Spreadsheet: 35069d1232573369-table-searching-problems-book1a
Sheet: Sheet2

B. Standard Making -Bagged machine sewn, machine triple and double, pinch pleat heading
 |  | (2w) | (4w) | (6w) | (8w)
Lined |  | 1 | 2 | 3 | 4
upto 125cm |  | 32.13 | 56.81 | 78.75 | 98.65
126cm to 200cm |  | 36.96 | 65.31 | 90.56 | 113.45
201cm to 400cm |  | 42.21 | 75.98 | 102.48 | 130.57
 |  | (2w) | (4w) | (6w) | (8w)
Interlined |  | 1 | 2 | 3 | 4
upto 125cm |  | 38.54 | 68.2 | 94.5 | 118.38
126cm to 200cm |  | 44.36 | 78.38 | 108.68 | 136.13
201cm to 400cm |  | 50.66 | 91.19 | 122.96 | 156.66
Spreadsheet: 764025d1642533602-numerical-value-of-letters-in-words-book1
Sheet: Sheet1

Character | Value
A | 1 |  |  | Target Cell
B | 2 |  |  | Hello:
C | 3 |  |  | Target Cell split into separate cells for calculation
D | 4 |  |  | H | E | L | L | O | :
E | 5
F | 6
G | 7 |  |  | Value
H | 8
I | 9
J | 10
K | 11
L | 12
M | 13
N | 14
O | 15
P | 16
Q | 17
R | 18
S | 19
T | 20
U | 21
V | 22
W | 23
X | 24
Y | 25
Z | 26
, | 1
. | 2
: | 3
; | 3
Spreadsheet: john_griffith__15733__10_15_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 235 | 26.5 | 28 | 81.5 | 86.2 | 12.39 | 2001-10-15 14:41:00
 | NG Z1 | 265 | 50.5 | 51 | 70.1 | 70.7 | 11.73 | 2001-10-15 14:41:00
 | NG F2 | 285 | 69.5 | 70 | 69.6 | 70.1 | 12.52 | 2001-10-15 14:41:00
 | NG G2 | 285 | 78 | 78.5 | 65 | 65.4 | 11.68 | 2001-10-15 14:41:00
 | NG H2 | 280 | 77 | 78 | 58.2 | 59 | 10.32 | 2001-10-15 14:41:00
 | NG J2 | 275 | 70 | 74 | 49.1 | 51.9 | 8.73 | 2001-10-15 14:41:00
 | NG K2 | 275 | 73 | 75 | 47.1 | 48.4 | 8.26 | 2001-10-15 14:41:00
 | NG M2 | 280 | 78.5 | 80 | 46.2 | 47.1 | 8.21 | 2001-10-15 14:41:00
 | NG N2 | 285 | 82 | 86 | 44.8 | 47 | 8.22 | 2001-10-15 14:41:00
 | NG Q2 | 290 | 90 | 91.5 | 45.9 | 46.7 | 8.44 | 2001-10-15 14:41:00
 | NG U2 | 290 | 95 | 97 | 46.2 | 47.2 | 8.51 | 2001-10-15 14:41:00
 | NG V2 | 290 | 99.5 | 100.5 | 46.5 | 47 | 8.52 | 2001-10-15 14:41:00
 | [NAME] | 335 | 122 | 123 | 46 | 46.3 | 9.72 | 2001-10-15 14:41:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 814763d1674579524-eomonth-function-statement-on-compensation-on-rainha-dna-leonor-2022-23-response
Sheet: Pivot Table

Totals | Column Labels
Row Labels | Compensation | Energy | INTERNET/TV | Water | Grand Total
2022
Qtr4
Oct | 2100 | 80.02 |  |  | 2180.02
Nov | 700 | 104.01 | 81.8 | 24.96 | 910.77
Dec | 700 | 91.53 | 81.8 | 18.53 | 891.8599999999999
Qtr4 Total | 3500 | 275.56 | 163.6 | 43.49 | 3982.65
2022 Total | 3500 | 275.56 | 163.6 | 43.49 | 3982.65
2023 | 700 |  | 40.9 | 18.72 | 759.62
Grand Total | 4200 | 275.56 | 204.5 | 62.21 | 4742.27
Spreadsheet: 730406d1619692097-combine-data-from-two-columns-combine-data-from-two-columns-
Sheet: Sheet1

1) Data from the previous month |  |  | 3) Data from previous month and raw data are combined here |  |  | 2) Raw data from the insurance provider is pasted here
Customers | Comments |  | Customers | Comments |  | Insured
Lazy | Get up |  |  | Get up |  | Lazy
New | Call |  | New | Call |  | New
Old | Boss |  | Old | Boss |  | Old
Cheezy | Good |  | Cheezy | Good |  | Cheezy
Burger | Later |  | Burger | Later |  | Burger
Chocolate | Smooth |  | Chocolate | Smooth |  | Chocolate
Stick |  |  | Stick |  |  | Stick
Chewy |  |  | Chewy |  |  | Chewy
Puppy |  |  | Puppy |  |  | Puppy
Cat | Get out |  | Cat | Get out
Duck | Fly |  | Duck | Fly
Dog | Eat a snack |  | Dog | Eat a snack
Spreadsheet: 824333d1680510576-calculating-an-amount-to-withhold-from-paycheck-deduction-calculator-ans2-1-
Sheet: Sheet1

The rates of Shortages applicable are as follows:
RATES OF NORMAL SHORTAGES FOR INDIVIDUALS
Exceeds | Does not exceed
Shortages |  | Fixed Deduction | Rate on Excess | Rates
0 | 200 | 200 | 0 | E200 + 0% of the excess of 0
201 | 250 |  | 0.09 | E200 + 0% of the excess of 200
251 | 300 |  | 0.08 | E200 + 0% of the excess of 250
301 | 350 |  | 0.07 | E200 + 0% of the excess of 300
351 | 400 |  | 0.06 | E200 + 0% of the excess of 350
401 | 450 |  | 0.05 | E200 + 0% of the excess of 400
451 | 500 |  | 0.04 | E200 + 0% of the excess of 450
501 | 550 |  | 0.03 | E200 + 0% of the excess of 500
551 |  |  | 0.02 | E200 + 0% of the excess of 550
Examples
Shortage | Deduction Calculator
 | Fixed Deduction per Table | Excess | Rate on excess |  | Expected Deduction |  | Your Formula | Difference
200 |  |  | 0 |  | 200
250 | 210 |  | 0.09
350 | 230 |  | 0.07
450 | 250 |  | 0.05
550 | 270 |  | 0.03
780 | 280 |  | 0.02
Spreadsheet: 875503d1722068731-2-criteria-to-determine-what-data-set-to-use-during-vlookup-xdarkdeadpool-test-for-s-and-d-matrix-1-with-cse-wk9128
Sheet: TEST SHEET

Name | Subject 1
Quarter | Q2
 | OPT1 | OPT2 | OPT3 | OPT4
 | OPT1 | OPT2 | OPT3 | OPT4 |  | Q1 | Subject # | Quarter # | Option #
Subject 1 |  |  |  |  | Q1 | Q2 | Subject 1 | Q1 | OPT1
Subject 2 |  |  |  |  | Q1 | Q3 | Subject 1 | Q1 | OPT1
Subject 3 |  |  |  |  | Q1 | Q4 | Subject 1 | Q2 | OPT1
Subject 4 |  |  |  |  | Q1 |  | Subject 3 | Q3 | OPT3
Subject 1 |  |  |  |  | Q2 |  | Subject 1 | Q2 | OPT2
Subject 2 |  |  |  |  | Q2 |  | Subject 2 | Q4 | OPT4
Subject 3 |  |  |  |  | Q2 |  | Subject 4 | Q3 | OPT3
Subject 4 |  |  |  |  | Q2 |  | Subject 3 | Q2 | OPT1
Subject 1 |  |  |  |  | Q3 |  | Subject 3 | Q4 | OPT1
Subject 2 |  |  |  |  | Q3 |  | Subject 1 | Q2 | OPT2
Subject 3 |  |  |  |  | Q3 |  | Subject 2 | Q1 | OPT3
Subject 4 |  |  |  |  | Q3 |  | Subject 3 | Q2 | OPT4
Subject 1 |  |  |  |  | Q4 |  | Subject 2 | Q2 | OPT2
Subject 2 |  |  |  |  | Q4 |  | Subject 1 | Q3 | OPT3
Subject 3 |  |  |  |  | Q4 |  | Subject 4 | Q3 | OPT1
Subject 4 |  |  |  |  | Q4 |  | Subject 4 | Q1 | OPT4
 | 1 | '=OR(COUNTIFS($B$2,"Subject 1",$B$4,"Q1"),COUNTIFS($B$2,"Subject 1",$B$4,"Q2"))
 | 2 | '=vlookup(B2,A18:F33,3,FALSE),AND(VLOOKUP(B4,A18:F33,3,TRUE))
 | 3 | '=COUNTIFS(A18:F33,A18:A33=B2,F18:F33=B4,D18:D33=>1)
 | 4 | "=COUNTIFS(H18:J33,B2=AND(OR(H18,H19,H20,H21,H22,H23,H24,H25,H26,H27,H28,H29,H30,H31,H32,H33)),B4=AND(OR(I18,I19,I20,I21,I22,I23,I24,I25,I26,I27,I28,I29,I30,I31,I32,I33)),AND(OR(J18,J19,J20,J21,J22,J23,J24,J25,J26,J27,J28,J29,J30,J31,J32,J33))="OPT")
 | 5 | =COUNTIFS(A:A,"*"&B1&"*",A:A,"*"&C1&"*")
 | 6 | =[NAME]))
Spreadsheet: 728700d1618581614-if-with-time-range-example-file
Sheet: Sheet1

 |  |  |  |  |  |  | IN | IN
 |  |  |  |  |  |  | 1 | 2
 |  |  |  |  |  |  | 02:00:00 | 18:00:00
 |  |  |  |  |  |  | 10:00:00 | 02:00:00
 | Time
 | 00:00:00
 | 00:30:00
 | 01:00:00
 | 01:30:00
 | 02:00:00
 | 02:30:00
 | 03:00:00
 | 03:30:00
 | 04:00:00
 | 04:30:00
 | 05:00:00
 | 05:30:00
 | 06:00:00
 | 06:30:00
 | 07:00:00
 | 07:30:00
 | 08:00:00
 | 08:30:00
 | 09:00:00
 | 09:30:00
 | 10:00:00
 | 10:30:00
 | 11:00:00
 | 11:30:00
 | 12:00:00
 | 12:30:00
 | 13:00:00
 | 13:30:00
 | 14:00:00
 | 14:30:00
 | 15:00:00
 | 15:30:00
 | 16:00:00
 | 16:30:00
 | 17:00:00
 | 17:30:00
 | 18:00:00
 | 18:30:00
 | 19:00:00
 | 19:30:00
 | 20:00:00
 | 20:30:00
 | 21:00:00
 | 21:30:00
 | 22:00:00
 | 22:30:00
 | 23:00:00
 | 23:30:00
Spreadsheet: 85f8aa77-0e40-4303-bc8c-4cac08c02d25
Sheet: Sheet3

Married |  |  | 3900
0 |  |  | 0
8300 |  | 0 | 0.1
26150 |  | 1785 | 0.15
80800 |  | 9982.5 | 0.25
154700 |  | 28457.5 | 0.28
231350 |  | 49919.5 | 0.33
406650 |  | 107768.5 | 0.35
458300 |  | 125846 | 0.396
Spreadsheet: 806160d1669135574-if-formula-impacted-by-previously-entered-data-data-sample
Sheet: PIVOT

 |  | Column Labels
 |  | AUG 2022 |  | JUL 2022 |  | NOV 2022 |  | OCT 2022 |  | SEP 2022 |  | Total Sum of Charged | Total Sum of Net RPH (T&M/Charged Hours)
 | Row Labels | Sum of Charged | Sum of Net RPH (T&M/Charged Hours) | Sum of Charged | Sum of Net RPH (T&M/Charged Hours) | Sum of Charged | Sum of Net RPH (T&M/Charged Hours) | Sum of Charged | Sum of Net RPH (T&M/Charged Hours) | Sum of Charged | Sum of Net RPH (T&M/Charged Hours)
 | [PHONE] | 216 | 222.8338888888889 | 193 | 167.9089119170984 | 20 | 799.26 | 26.2 | 793.3843511450381 | 47 | -447.995744680851 | 502.2 | 191.665890083632
 | [PHONE] | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 | 0 | 0 |  | 0 |  | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | [PHONE] | 118 | 214.6749152542373 | 132 | 256.9621212121212 | 0 | 0 | 24 | 166.1066666666667 | 177.5 | 186.3259718309859 | 451.5 | 213.3113178294574
 | [PHONE] | 27 | 583.2692592592592 | 369 | 335.9434959349593 | 24 | 507.0625 | 59 | 540.6452542372881 | 35 | 507.0628571428572 | 514 | 392.074299610895
 | [PHONE] | 8 | 301.1525000000001 | 272 | 343.7510661764705 |  | 0 |  | 0 | 0 | 0 | 280 | 342.5339642857143
 | [PHONE] | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 | 0 | 0
 | [PHONE] |  | 0 | 180.5 | 663.2099168975069 |  | 0 |  | 0 |  | 0 | 180.5 | 663.2099168975069
 | [PHONE] |  | 0 | 24 | 467.1866666666667 |  | 0 |  | 0 |  | 0 | 24 | 467.1866666666667
 | [PHONE] |  | 0 | 101 | 135.09 |  | 0 |  | 0 |  | 0 | 101 | 135.09
 | [PHONE] | 954 | 202.9666142557652 |  | 0 | 0 | 0 | 0 | 0 | 829.5 | 175.2840867992767 | 1783.5 | 190.091561536305
 | [PHONE] |  | 0 |  | 0 | 373 | 396.0413941018767 | 326 | 363.7370858895706 | 709 | 362.6458392101551 | 1408 | 371.7454758522727
 | [PHONE] |  | 0 |  | 0 | 56 | 22.45982142857143 |  | 0 |  | 0 | 56 | 22.45982142857143
 | [PHONE] |  | 0 |  | 0 | 20 | 606.337 |  | 0 |  | 0 | 20 | 606.337
 | Grand Total | 1323 | 215.6095767195767 | 1271.5 | 336.8893590247739 | 493 | 345.2851724137931 | 435.2 | 402.6874770220588 | 1798 | 201.5542491657397 | 5320.7 | 267.1595861446802
Spreadsheet: 839706d1692175650-textsplit-function-is-it-possible-to-spill-an-empty-cell-with-zero-txtsplit-hd-2-1-4-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Mockup |  |  |  |  | GK
 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed |  |  | E1 | E2 | LP | Speed |  | E1 | E2 | LP | Speed
 | 1 Smoke Wagon |  |  | 85/ 73* | 67 |  |  |  |  |  |  |  | 0 | 85 | 73 | 67 |  |  | 85 | 73 | 67
 | 2 Global Hysteria |  | No Starts Available |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 3 I Strong |  | 86 |  | 71* |  |  |  |  |  |  |  | 86 | 0 | 0 | 71 |  | 86 | 0 | 0 | 71
 | 4 Maluma |  | No Starts Available |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 5 Warrior's Cause |  |  |  | 66 |  |  |  |  |  |  |  | 0 | 0 | 0 | 66 |  | 0 | 0 | 0 | 66
 | 6 Exclusive Entry |  | No Starts Available |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 7 Bundaburg |  | No Starts Available |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | 8 Imposter Syndrome |  | 85 | 87/ 75 | 72 |  |  |  | 75 |  |  |  | 85 | 87 | 75 | 72 |  | 85 | 87 | 75 | 72
Spreadsheet: 288645d1389266646-formula-correction-sales-2013-2014-kym-edit
Sheet: February 2014

 | Invoice Date | Clients Name | Code | Invoice No | Net | VAT | Gross | Date Paid | Total Paid | MOP |  | Total Net |  |  | Company Totals (Net)
 |  |  |  |  |  |  |  |  |  |  |  | Total VAT
 |  |  |  |  |  |  |  |  |  |  |  | Total Gross
 |  |  |  |  |  |  |  |  |  |  |  | Total Paid
 |  |  |  |  |  |  |  |  |  |  |  | Total Bad Debt
Spreadsheet: 847244d1698260576-please-help-modify-my-if-countif-formula-example
Sheet: Sheet1

Column A | Column B | Desired Output
JAZZ
JAZZ
JAZZ
JAZZ | Yes | Good
JAZZ |  | Good
JAZZ |  | Good
JAZZ |  | Good
IND
IND | Yes | Good
IND |  | Good
IND |  | Good
IND |  | Good
IND |  | Good
IND |  | Good
PENN
PENN
PENN
PENN
PENN
PENN
PENN
SHOE
SHOE
SHOE
SHOE
SHOE
SHOE | Yes | Good
SHOE |  | Good
Spreadsheet: mary_fischer__25609__32C-2001
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032C |  | (Please print)  PREPARED BY: | [NAME]
COMPANY NAME   Enron Building Services Inc. Hldg Co.
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | N/A
E-2 * | 195 | Other Current Assets | N/A
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | N/A
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | N/A
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | N/A
E-31 | TOT_SHARE_EQU | Reconciliation of Stockholders' Equity and Investment in Sub | Completed
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 160257d1339017776-highlight-second-highest-values-problem-with-ties-condital-formatting-2nd-plan
Sheet: Blad1

 |  | [NAME] | Rus-Tsj | Ned-Den | Dui-Por | Spa-Ita | [NAME] | Fra-Eng | Oek-Zwe | Gri-Tsj | [NAME] | Den-Por | [NAME] | Ita-Kro | Spa-Ier | Oek-Fra | [NAME] | Gri-Rus | Tsj-Pol | [NAME] | Den-Dui | Kro-Spa | Ita-Ier | [NAME] | Eng-Oek
 | Correcte uitslag | 1-2 | 1-0 | 0-0 | 4-4
Deelnemer | Totaal punten
[NAME] | 0 | 1-1 | 1-2 | 2-1 | 1-2
Lars | 1 | 1-2 | 4-2 | 2-4 | 0-1
[NAME] | 1 | 2-3 | 1-0 | 1-1 | 3-2
Pieter | 2 | 1-2 | 1-2 | 0-0 | 1-5
Guillaume | 2 | 1-2 | 1-0 | 0-3 | 2-3
[NAME] | 3 | 0-0 | 1-0 | 0-0 | 4-4
[NAME]
Sven
Roel
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
 |  | highlights in the field when an estimated score is correct (see row 4 for correct score)
 |  | highlights in col B all the second highest number of correct estimated scores, dealing with tie-problem
 |  | highlights in col B all the highest number of correct estimated scores, dealing with tie-problem
 | Column B (nrs) | sums up all correct estimations
Spreadsheet: 57554d1257775350-division-formula-not-consistent-template-extt
Sheet: Sheet1

PriceRangeSegment | QtrStarts | QtrClosings | AnnStarts | AnnClosings | FVMos | HousMos | VDLMos | Models (Mod) | FinVacant (FV) | UnderConst (UC) | HousInv | VDLInv (VDL) | Percent [NAME]
$0 - $99,999 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$100,000 - $149,999 | 12 | 14 | 51 | 55 | 1 | 5 | 26 | 2 | 6 | 14 | 22 | 113
$150,000 - $199,999 | 101 | 67 | 249 | 287 | 2 | 7 | 35 | 15 | 59 | 89 | 164 | 721
$200,000 - $249,999 | 78 | 76 | 234 | 319 | 3 | 6 | 60 | 18 | 72 | 72 | 161 | 1173
$250,000 - $299,999 | 26 | 37 | 105 | 162 | 3 | 6 | 62 | 7 | 37 | 32 | 77 | 540
$300,000 - $399,999 | 10 | 23 | 52 | 88 | 3 | 6 | 78 | 2 | 20 | 20 | 42 | 336
$400,000 - $499,999 | 4 | 8 | 12 | 32 | 5 | 9 | 117 | 1 | 13 | 10 | 24 | 114
$500,000 And Over | 1 | 2 | 4 | 20 | 6 | 9 | 273 | 0 | 11 | 4 | 15 | 80
Spreadsheet: 800371d1665630497-how-to-link-2-rows-of-open-and-closed-options-position-in-excel-data-from-bank-sample-data-mohitart-
Sheet: Sheet1

Exec Time | Date | Time | Year | Month | Day | Spread | Side | Qty | Pos Effect | Symbol | Exp | Strike | Type | Price | Net Price | Order Type
2022-09-29 11:43:54 |  |  |  |  |  | SINGLE | BUY | 2 | TO CLOSE | ZM | 2022-09-30 00:00:00 | 65 | PUT | 0.01 | 0.01 | LMT
2022-09-28 14:18:37 |  |  |  |  |  | SINGLE | BUY | 2 | TO CLOSE | ZM | 2022-09-30 00:00:00 | 60 | PUT | 0.01 | 0.01 | LMT
2022-09-13 14:17:09 |  |  |  |  |  | SINGLE | SELL | -2 | TO OPEN | ZM | 2022-09-30 00:00:00 | 65 | PUT | 0.35 | 0.35 | LMT
2022-09-13 13:59:29 |  |  |  |  |  | SINGLE | SELL | -2 | TO OPEN | ZM | 2022-09-30 00:00:00 | 60 | PUT | 0.13 | 0.13 | LMT