tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 691779d1597864533-timeclock-report-analysis-timecard-report-captures-clock-in-clock-out-clock-in-again-time-sheet-automation-sample
Sheet: Sample Template

Data Entry Date: | 2020-03-02 00:00:00
Data entered by:
First name | Last name | Event timestamp | Hours worked Total (30 minute lunch subtracted, rounded to nearest 15 minute interval)
ELITE A-02 |  | 2020-03-01 17:10:00
ELITE A-02* |  | 2020-03-01 06:25:42
ELITE A-07* |  | 2020-03-01 06:33:30
ELITE A-07* |  | 2020-03-01 17:10:28
ELITE A-15* |  | 2020-03-01 06:32:52
ELITE A-15* |  | 2020-03-01 17:10:04
ELITE A-17* (TRESPASS) |  | 2020-03-01 06:34:18
ELITE A-17* (TRESPASS) |  | 2020-03-01 17:10:11
ELITE A-18* |  | 2020-03-01 17:10:26
ELITE A-18* |  | 2020-03-01 06:30:46
ELITE B-04* |  | 2020-03-01 06:31:02
ELITE B-04* |  | 2020-03-01 17:10:50
ELITE B-21* |  | 2020-03-01 06:43:04
ELITE B-21* |  | 2020-03-01 17:10:17
ELITE B-29* |  | 2020-03-01 06:31:59
ELITE B-29* |  | 2020-03-01 17:10:06
ELITE B-49* |  | 2020-03-01 17:09:54
ELITE B-49* |  | 2020-03-01 06:26:41
ELITE C-18* |  | 2020-03-01 06:13:20
ELITE C-18* |  | 2020-03-01 17:10:44
ELITE C-26* |  | 2020-03-01 06:33:02
ELITE C-26* |  | 2020-03-01 17:10:30
ELITE C-50* |  | 2020-03-01 17:10:47
ELITE C-50* |  | 2020-03-01 06:13:26
ELITE D-02* |  | 2020-03-01 17:09:57
ELITE D-02* |  | 2020-03-01 06:43:22
ELITE G-09* |  | 2020-03-01 17:10:23
ELITE G-09* |  | 2020-03-01 06:43:54
ELITE G-14* |  | 2020-03-01 06:27:47
ELITE G-14* |  | 2020-03-01 17:10:42
ELITE I-38* |  | 2020-03-01 17:10:20
ELITE I-38* |  | 2020-03-01 06:18:29
ELITE J-14* |  | 2020-03-01 17:10:46
ELITE J-14* |  | 2020-03-01 06:34:36
ELITE L-02* |  | 2020-03-01 06:29:50
ELITE L-02* |  | 2020-03-01 17:09:56
ELITE L-36* |  | 2020-03-01 06:31:47
ELITE L-36* |  | 2020-03-01 17:10:52
ELITE M-09* |  | 2020-03-01 06:25:19
ELITE M-09* |  | 2020-03-01 17:09:46
ELITE O-18* |  | 2020-03-01 06:34:06
ELITE O-18* |  | 2020-03-01 17:10:35
ELITE O-38* |  | 2020-03-01 06:27:33
ELITE O-38* |  | 2020-03-01 17:10:08
ELITE O-43* |  | 2020-03-01 17:10:57
ELITE O-43* |  | 2020-03-01 06:29:26
ELITE Q-42* |  | 2020-03-01 06:27:02
ELITE Q-42* |  | 2020-03-01 17:09:50
ELITE Y-08* |  | 2020-03-01 06:31:23
ELITE Y-08* |  | 2020-03-01 17:10:13
ELITE zz C-98* |  | 2020-03-01 06:30:10
ELITE zz C-98* |  | 2020-03-01 17:10:15
ELITE zz E-81* |  | 2020-03-01 06:33:20
ELITE zz E-81* |  | 2020-03-01 17:09:52
ELITE zz H-58* (NO Longer Elite) |  | 2020-03-01 17:10:25
ELITE zz H-58* (NO Longer Elite) |  | 2020-03-01 06:33:54
ELITE zz H-65* |  | 2020-03-01 06:32:32
ELITE zz H-65* |  | 2020-03-01 17:10:37
ELITE zz H-68* |  | 2020-03-01 06:32:15
ELITE zz H-68* |  | 2020-03-01 17:11:03
ELITE zz H-82* |  | 2020-03-01 17:10:02
ELITE zz H-82* |  | 2020-03-01 06:43:42
Spreadsheet: 43922-count-on-three-criteria-but-using-no-arrays-or-pivot-tables-book2-1-
Sheet: Sheet1

Entry Number | Date Submitted | Source | Type |  | Source | Type | Date
Entry001 | 2009-05-01 00:00:00 | Purchasing | Complaint |  | Purchasing | Complaint | 2009-04-01 00:00:00 | 2
Entry002 | 2009-05-02 00:00:00 | Accounting | Compliment
Entry003 | 2009-05-03 00:00:00 | Purchasing | Complaint
Entry004 | 2008-06-04 00:00:00 | Shipping | Complaint
Entry005 | 2009-05-02 00:00:00 | Shipping | Compliment
Entry006 | 2008-03-02 00:00:00 | Purchasing | Complaint
Entry007 | 2009-05-02 00:00:00 | Shipping | Complaint
Spreadsheet: 689192d1596181978-how-to-count-sum-average-first-x-active-cells-in-y-columns-excel-expert-query
Sheet: Sheet1

 | SD | Avg | Jan | Feb | Mar | Apr | May | Jun | July | Aug | Sep | Oct | Nov | Dec
Jon Rahm | 92 |  | 32 |  | 26 |  | 11 |  |  | 23 | 14 | 45 | 21 | 16
[NAME] | 77 |  |  | 27 | 11 | 3 |  |  |  |  |  | 36 | 11 | 65
 | Cells in Column B must equal the sum of the first four columns with a value across the months
 | Cells in Column C must equal the average of the first four month columns with a value
Spreadsheet: 828428d1683483368-deduction-and-refund-formula-deduction-calculator-magalela-
Sheet: Sheet1

SHORTAGES
Exceeds | Does not exceed | Fixed Deduction | Rate on Excess | Rates
-500.00099 |  | -220 | 0.02 | -220  +       2%  of excess of  500
-450.00099 | -500 | -210 | 0.03 | -210  +       3%  of excess of  500
-400.00099 | -450 | -200 | 0.04 | -200  +       4%  of excess of  450
-350.00099 | -400 | -190 | 0.05 | -190  +       5%  of excess of  400
-300.00099 | -350 | -180 | 0.06 | -180  +       6%  of excess of  350
-250.00099 | -300 | -170 | 0.07 | -170  +       7%  of excess of  300
-200.00099 | -250 | -160 | 0.08 | -160  +       8%  of excess of  250
-150.00099 | -200 | -150 | 0.09 | -150  +       9%  of excess of  200
0 | -150 | 0 | 1 | -0   +  100%  of excess of  150
0 | 150 | 0 | 1
 | 200 | 150 | 0.09
 | 250 |  | 0.08
 | 300 |  | 0.07
 | 350 |  | 0.06
 | 400 |  | 0.05
 | 450 |  | 0.04
 | 500 |  | 0.03
 |  |  | 0.02
Shortage | Deduction Calculator
 | Fixed Deduction per Table | Excess | Rate on excess |  | Expected Deduction | [NAME]
40 |  |  |  |  |  |  | Deduction Examples
780
-100 |  |  |  |  |  | ? | REFUNDS Examples
-250 |  |  |  |  |  | ?
-500 |  |  |  |  |  | ?
Spreadsheet: 732395d1620926580-formula-to-transfer-data-to-another-sheet-without-blanks-copy-of-test-register-2021
Sheet: Master

Source | Surname | Arrive | [NAME] | LOS | Overstay
RIE | MILNE | 2021-05-08 00:00:00 | 2021-05-11 00:00:00
RIE | GARDNER | 2021-05-08 00:00:00
RIE | [NAME] | 2021-05-08 00:00:00
RIE | DODDS | 2021-05-09 00:00:00
RIE | [NAME] | 2021-05-09 00:00:00
RIE | HUTCHISON | 2021-05-09 00:00:00
RIE | MURRAY | 2021-05-09 00:00:00 | 2021-05-11 00:00:00
RIE | CUMMINGS | 2021-05-10 00:00:00
RIE | SMITH | 2021-05-10 00:00:00
RIE | REID | 2021-05-10 00:00:00
RIE | MANCINI | 2021-05-10 00:00:00
RIE | IMRIE | 2021-05-10 00:00:00
RIE | CLARK | 2021-05-10 00:00:00
RIE | KAY | 2021-05-10 00:00:00
RIE | MANO | 2021-04-20 00:00:00
RIE | KIERNAN | 2021-04-21 00:00:00
RIE | [NAME] | 2021-04-28 00:00:00
RIE | MEACHAN | 2021-04-28 00:00:00 | 2021-04-28 00:00:00
RIE | SAUNDERS | 2021-05-04 00:00:00
RIE | SMITH | 2021-05-05 00:00:00
RIE | SULLIVAN | 2021-05-06 00:00:00
BGH | SCOTT | 2021-05-03 00:00:00
RIE | BRAKE | 2021-05-06 00:00:00 | 2021-05-07 00:00:00
RIE | LOWE | 2021-05-06 00:00:00
RIE | NAYSMITH | 2021-05-07 00:00:00
RIE | ELLIOT | 2021-05-07 00:00:00
RIE | MCLEARY | 2021-05-07 00:00:00
BGH | WILDER | 2021-05-05 00:00:00
Spreadsheet: 852210d1702309309-if-column-is-negative-then-sumif-sumif-negative
Sheet: Sheet1

ID | Sales | Comm |  |  |  | Result I want
M1112 | 200 | 10 |  |  | M1112
M1112 | -10 | 0.5 |  |  | M1113
M1113 | 80 | 4 |  |  | M1114
M1113 | 80 | 4
M1113 | -20 | 1
M1114 | -90 | 4.5
 |  |  |  |  | *without using helper column,
 |  |  |  |  | - If Sales is negative, Comm is Negative
Spreadsheet: 023ebeb6-d6a8-4a49-855d-8d2797ed350b
Sheet: Sheet1

Cert # | Parameter Code | Lab Name | Lab Contact | Lab Address1 | Lab City | State | Zip | Lab Phone # | Ext. | Lab Fax # | E-mail Address
94 | E Coli 24 | Environmental Chemists, Inc. (Envirochem) | [NAME] | 6602 Windmill Way | [NAME] | NC | 28405- | [PHONE] |  | [PHONE] | [EMAIL]
192 | E Coli 18 | CMU - Environmental Laboratory Services | [NAME] | 4222 Westmont Drive | Charlotte | NC | 28217- | [PHONE] |  | [PHONE] | [NAME]
235 | E Coli 9223B | Cherokee WWTP Laboratory | [NAME] | P.O. Box 547 | Cherokee | NC | 28719- | [PHONE] |  | [PHONE] | [EMAIL]
329 | E Coli 18 | Shealy Environmental Services, Inc. | [NAME] | 106 Vantage Point Dr. | West Columbia | SC | 29172- | [PHONE] | 105 | [PHONE] | [EMAIL]
633 | E Coli 9223B | Pace Analytical Services, Inc. - Eden | [NAME] | 205 East Meadow Road - Suite A | Eden | NC | 27288- | [PHONE] |  | [PHONE] | [EMAIL]
678 | E Coli 18 | Microbac Laboratories TN Operations | Troy Taubert | 505 E. Broadway Avenue | Maryville | TN | 37804- | [PHONE] | 1200 | [PHONE] | [EMAIL]
Spreadsheet: 772340d1647225075-conditional-formatting-problem-example
Sheet: Sheet2

# When I give an input of actual value, any cell in the same row that
# abs(its_value - actual_value) < 2
# will be automatically formatted in some way
# like this↓
(before)
 | Normal |  | Amplified |  |  | ↓input
 | not crit | crit | not crit | crit |  | Actual
skill1 | 10.001 | 15.001 | 20.002 | 30.002
skill2 | 20 | 35 | 40 | 70
(after)
 | Normal |  | Amplified |  |  | ↓input
 | not crit | crit | not crit | crit |  | Actual
skill1 | 10.001 | 15.001 | 20.002 | 30.002 |  | 15
skill2 | 20 | 35 | 40 | 70 |  | 41
Spreadsheet: 111f20d1-ad76-4775-b23c-4f85681c982e
Sheet: Sheet1

MEN | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
1 | WEBSTER | Mark | AUS
2 | IONAN | [NAME] | AUT
3 | KIEFER | Severin | AUT
4 | REYNOLDS | [NAME] | CAN
5 | GLUHAK | Josip | CRO
6 | VERNER | Tomáš | CZE
7 | KASKA | Pavel | CZE
8 | STRID | Justus | DEN
9 | RICHARDSON | [NAME] | GBR
10 | [NAME] | [NAME] | GBR
 | [NAME] | [NAME] | GBR | s
11 | ZANDRON | [NAME] | ITA
12 | MACHIDA | Tatsuki | JPN
13 | MURAKAMI | Daisuke | JPN
14 | RAKIMGALIYEV | Abzal | KAZ
15 | EGUIA | Maverick | PHI
16 | BIALAS | Kamil | POL
17 | IWASAKI | [NAME] | POL
18 | KELEMEN | Zoltan | ROM
19 | DMITRIEV | Artur | RUS
20 | MENSHKOV | Konstantin | RUS
 | BARIEV | [NAME] | RUS | s
 | GORSHKOV | Georgy | RUS | s
21 | WALKER | Stéphane | SUI
22 | DEMIRBOGA | [NAME] | TUR
23 | ARTAN | [NAME] | TUR
24 | IGNATENKO | Dmitriy | UKR
 | GODOROZHA | Yakov | UKR | s
25 | GE | Misha | UZB
Spreadsheet: 736311d1623493487-combined-if-formula-book1
Sheet: My Sheet

Card | Name | 24 | 25 | 26 | 27 | 28 | 29
5021 |  | Short Leave |  |  |  |  |  | 08:16:00 | 08:30:00
5022 |  | Show Blank |  |  |  |  |  | 08:16:00 | 08:30:00
5023 |  | Short Leave |  |  |  |  |  | 08:16:00 | 08:30:00
5024 |  | Show Blank |  |  |  |  |  | 08:16:00 | 08:30:00
5025 |  | Late |  |  |  |  |  | 08:16:00 | 08:30:00
 |  | I need formula that if the card number 5021 greater than TIME 8:15 or Less Than 8:30 than Show me the person is late, if time is greater than 8:30 than show me Shortleave.
 |  | Time sheet working is in another sheet so I would vlookup first the card number.
Spreadsheet: 110967d1307508203-counting-dates-in-a-sheet-task-example
Sheet: Sheet1

 | Mowing | Sweeping | Trim | Blower | Hedge
CHRISTINA |  |  | 2011-06-10 00:00:00
[NAME] | 2011-01-02 00:00:00
STEPHANIE
VICTORIA |  |  |  | 2011-04-05 00:00:00
EMA |  | 2011-03-19 00:00:00
TANIA |  |  |  |  | 2011-03-30 00:00:00
NADIA | 2011-02-28 00:00:00
Month | Jan | Feb | March | April | May | etc...
Completed
Spreadsheet: 707080d1607021267-summing-wildcard-matches-while-subtracting-wildcard-matches-of-the-previous-rows-example-a
Sheet: Sheet1

a,b | 3 |  | a
a,d | 15 |  | b
c,d,b | 2 |  | c
a,b,c | 8 |  | d
c,a | 6
d | 9
b | 11
a | 4
a | 2
c,a,b | 1
a,d | 7
b,c | 4
c,d | 6
Spreadsheet: 288030d1389071333-find-a-specific-accounts-value-from-a-range-of-text-strings-upload-a-spreadsheet-to-excelforum-010614_alkey
Sheet: Sheet1

 |  |  |  | Find a specific account's value from a range of text strings.
 | The Data below was copied and then special pasted intact as a form.
 | The actual info or values were changed or x'd out, but the values shown retain their original character including some nonbreaking space characters.
 | Each account in row B is manipulated by 3 formulas to net the value of an account in the table at Column I.
 | What I would like to do is find a numeric value for each account in the table using a single formula for each.
 |  |  |  |  | Acct No. |  |  | Results
 |  |  |  |  | & Value |  |  | Column
 | Accounts |  |  |  | formulas |  | (entry) | (formula)
 | xxxxxxx |  |  |  |  |  | Account | Value
 |  |  |  |  |  |  |  |  | value not found because formula in Col. F removed the XZ terms.
 | Account Balance
 | Account number:[PHONE] XZ
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Values
 | Account value as of 12/31/2013:$12,345.56
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Summary
 | Account number:101112134
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Values
 | Account value as of 12/31/2013:$24,691.12
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Summary
 | Account number:202224268
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Values
 | Account value as of 12/31/2013:$16,543.05
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Summary
 | Account number:404448536
 | xxxxxxx
 | xxxxxxx
 | xxxxxxx
 | Account Values
 | Account value as of 12/31/2013:$33,086.10
 | xxxxxxx
Spreadsheet: 703673d1605110225-use-formulas-to-show-visibility-of-employees-shift-visibility-test
Sheet: Shift

2020-11-11 00:00:00
Employee | Shift
[NAME] | 09:00-17:00
Sophie | 12:00-20:00
Janice | 09:00-17:00
[NAME] | 12:00-20:00
[NAME]
[NAME]
[NAME] | 09:00-17:00
Spreadsheet: 849208d1699731792-formulas-are-turning-to-text-if-i-try-to-edit-them-in-any-way-ch-calc_v3
Sheet: Tools

 | tool diameter (in) | Tool | OD (mm) | Radius (in) | Radius ([NAME]) | πr2 (m) | displ/m (l) | Tool Constant
 | 1.6875 | Sondex [NAME] |  | 0.84375 |  |  |  | 50
 | 2.25 | MSS or CXD |  | 1.125 |  |  |  | 73
 | 2.75 | SBT |  | 1.375 |  |  |  | 44
 | 3.375 | CBT or HBC |  | 1.6875 |  |  |  | 28
 | 4.5 | SBT-W/RIB |  | 2.25 |  |  |  | 28
Spreadsheet: 105627d1302921472-excel-2007-how-to-select-the-row-with-the-highest-number-bandmax
Sheet: Sheet1

Start | End | Band | Diff
[PHONE] | 128336473 | 608 | 127
[PHONE] | 128834764 | 608 | 255
[PHONE] | 128343244 | 621 | 511 |  | Row Labels | [NAME] of Diff
[PHONE] | 128344831 | 621 | 127 |  | 608 | 255
[PHONE] | 128345177 | 621 | 127 |  | 621 | 511
[PHONE] | 129045763 | 623 | 7 |  | 623 | 255
[PHONE] | 129165619 | 623 | 255 |  | 624 | 15
[PHONE] | 128558339 | 624 | 7 |  | 625 | 127
[PHONE] | 128558358 | 624 | 15 |  | Grand Total | 511
[PHONE] | 128558775 | 624 | 7
[PHONE] | 128559037 | 624 | 7
[PHONE] | 128325081 | 625 | 127
Spreadsheet: 286021d1388009966-conditional-formatting-demo-1
Sheet: sheet

S.NO | Fleet No. | Reg.No. | Name | Make | Model | Eng.No. | Chassis.No. | Reg. Exp. Date | Winch Model | [NAME].No. | Winch Exp. | RAS Exp. | Lifting Exp.loose equip | crane and forklift insp
1 | AS-100 | 2689 ML | Winch Truck | MAN | 2011 | 51528561282858 | WMA34WZZ6BM570945 | 2014-01-01 00:00:00 | HS50P-20B | 7157019 | 2013-12-11 00:00:00 | 2014-09-09 00:00:00 | 2013-09-09 00:00:00
2 | AS-100T | 685 ML | Trailer | ATLAS | 2011 |  | ZTAA8200003 | 2014-01-01 00:00:00 |  |  |  | 2014-09-09 00:00:00
3 | AS-101 | 2386 ML | Winch Truck | MAN | 2011 | 51528560892858 | WMA34WZZ5BM570922 | 2013-08-20 00:00:00 | MS50P-20B | 765986 | 2013-12-11 00:00:00 | 25/09/2014 | 2013-09-09 00:00:00
4 | AS-101T | 812 ML | Trailer | ATLAS | 2011 |  | ZTAA8200001 | 2014-08-20 00:00:00 |  |  |  | 25/09/2014
5 | AS-102 | 2178 ML | Winch Truck | MAN | 2011 | 51528561132858 | WMA34WZZ6BM570928 | 2014-08-20 00:00:00 | MS50P-20B | 664212 | 2013-12-11 00:00:00 | 17/09/2014 | 2013-09-09 00:00:00
6 | AS-102T | 754 ML | Trailer | ATLAS | 2011 |  | ZTAA8200002 | 2013-12-20 00:00:00 |  |  |  | 17/09/2014
Spreadsheet: 274574d1383152321-need-formula-to-this-logic-a-column-number-b-column-blank-then-c-column-desired-name-cug-not-given
Sheet: Sheet2

CUG NUMBERS | GIVEN CUG | STATUS
[PHONE] AD [PHONE] | /919859858
[PHONE] [PHONE] AD [PHONE]
[PHONE] AD [PHONE] | /919859858
[PHONE] AD [PHONE] | /9999183
[PHONE] [PHONE]
[PHONE] [PHONE] [PHONE] | /919859999
CUG NOT REQUIRED
[PHONE] [PHONE] [PHONE] [PHONE] | /999900260
[PHONE] [PHONE] [PHONE] [PHONE] AD [PHONE]
[PHONE] [PHONE] [PHONE] | /919859999
[PHONE] AD [PHONE] | /919834647
[PHONE] [PHONE] AD [PHONE] | /9999186
[PHONE] [PHONE] [PHONE] ad [PHONE]
[PHONE] INTERLOCK CODE 919863280 | /919863280
[PHONE] [PHONE] | /9999155
[PHONE] [PHONE] AD [PHONE] | /999950914
CUG NOT REQUIRED
[PHONE] [PHONE] AD [PHONE] | /9999182
CUG NOT REQUIRED
[PHONE] [PHONE] | /9999232
[PHONE] [PHONE] AD [PHONE] | /919848075
[PHONE] [PHONE] AD [PHONE]
[PHONE] [PHONE] AD [PHONE] | /9999236
[PHONE] [PHONE] | /9999178
[PHONE] [PHONE] AD [PHONE] INTERLOCK CODE 919847359 | /919847359
[PHONE] AD [PHONE]
CUG ( [PHONE] / [PHONE] / [PHONE] / [PHONE] / [PHONE] / ADD [PHONE] )
[PHONE] [PHONE]
CUG ( [PHONE] / [PHONE] / [PHONE] / [PHONE] / [PHONE] / ADD [PHONE] )
[PHONE] [PHONE]
[PHONE] [PHONE] [PHONE] [PHONE]
[PHONE] [PHONE]
CUG ( [PHONE] / [PHONE] / [PHONE] / [PHONE] / [PHONE] / ADD [PHONE] )
[PHONE] [PHONE]
CUG ( [PHONE] / [PHONE] / [PHONE] / [PHONE] / [PHONE] / ADD [PHONE] )
[PHONE] [PHONE]
[PHONE] [PHONE] AD [PHONE]
[PHONE] [PHONE]
CUG ( [PHONE] / [PHONE] / [PHONE] / [PHONE] / [PHONE] / ADD [PHONE] )
[PHONE] [PHONE]
CUG ( [PHONE] / [PHONE] / [PHONE] / [PHONE] / [PHONE] / ADD [PHONE] )
Spreadsheet: stacey_white__38797__BP Energy Co - East
Sheet: Sheet4

Deal ID | Leg ID | Enron Entity | Portfolio | Counterparty | Nature | Deal End Date | Deal Status | Comments
888788.1 | 1 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D | deal comment = 'original deal #611655'; however 611655 is attached to #884232
889260.1 | 1 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D | changed to epmi-east-bank
889261.1 | 1 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
889262.1 | 1 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
889263.1 | 1 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
889264.1 | 1 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
889266.1 | 1 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
597202.6 | 6 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
606548.6 | 6 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
611655.6 | 6 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
611685.6 | 6 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
611682.6 | 6 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
613442.6 | 6 | EPMI-ERCOT-MGMT | EAST | BP | P | 2001-12-31 00:00:00 | D
Spreadsheet: 836983d1689772450-custome-week-numbers-example-week-number-help-aligw
Sheet: Sheet1

 |  |  |  |  | Date | Week Number | Day
 |  |  |  |  | 2022-06-01 00:00:00
 |  |  |  |  | 2022-06-02 00:00:00
 |  |  |  |  | 2022-06-03 00:00:00
 |  |  |  |  | 2022-06-04 00:00:00
 |  |  |  |  | 2022-06-05 00:00:00
 |  |  |  |  | 2022-06-06 00:00:00
 |  |  |  |  | 2022-06-07 00:00:00
 |  |  |  |  | 2022-06-08 00:00:00
 |  |  |  |  | 2022-06-09 00:00:00
 |  |  |  |  | 2022-06-10 00:00:00
 |  |  |  |  | 2022-06-11 00:00:00 |  |  | Up to this row is formula for week number
 |  |  |  |  | 2023-06-01 00:00:00
 |  |  |  |  | 2023-06-02 00:00:00
 |  |  |  |  | 2023-06-03 00:00:00
 |  |  |  |  | 2023-06-04 00:00:00
 |  |  |  |  | 2024-06-01 00:00:00
 |  |  |  |  | 2024-06-02 00:00:00
 |  |  |  |  | 2024-06-03 00:00:00
 |  |  |  |  | 2024-06-04 00:00:00
 |  |  |  |  | 2024-06-05 00:00:00
 |  |  |  |  | 2024-06-06 00:00:00
 |  |  |  |  | 2024-06-07 00:00:00
 |  |  |  |  | 2024-06-08 00:00:00
Spreadsheet: 0bd2e712-d513-4013-b438-bbca59c96acf
Sheet: Detailed Cash Report

GIRL SCOUTS OF MICHIGAN SHORE TO SHORE |  |  |  |  |  | TROOP  # |  |  |  |  |  |  |  | PREPARED BY:
 |  |  |  |  |  | FOR THE YEAR |  |  | -
 |  |  |  | INCOME |  |  |  |  |  | EXPENSES
 | Date | Activity / Description |  | Dues | Fall Product / Cookie Sales | Other Funds / Sponsorship |  | TOTAL          INCOME |  | Program Events | Badges & Pin Awards | Supplies | Service Projects | Trips & Fees | Copies / Postage |  | TOTAL          EXPENSES |  | Running Balance
 |  | Beginning Balance
1
2
3
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
32
33
34
35
36
37
38
39
40
 |  | TOTALS
 |  | YEAR ENDING
 |  | INCOME
 |  | TOTAL
 |  | EXPENSES
 |  | TOTAL
 |  | N E T
 |  | ADD:   Beginning Balance
 |  | ENDING BALANCE
Spreadsheet: 05a736a3-7b5a-4238-a833-54cfdb7dca6c
Sheet: Exhibit XVII, Sheet 4, pg 4

Owners Forms
[NAME]
Pennsylvania
Claims, Losses, & Expense Summary
 |  | Claims Closed Without Payment
 |  | (incl [NAME])
Accident Year | as of | 15 Months | 27 Months | 39 Months | 51 Months
2001-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2002-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2003-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2004-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2005-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2006-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2007-06-30 00:00:00 |  | 1 | 1 | 1 | 1
2008-06-30 00:00:00 |  | 4 | 4 | 4 | 4
2009-06-30 00:00:00 |  | 12 | 12 | 12 | 13
2010-06-30 00:00:00 |  | 33 | 39 | 39
2011-06-30 00:00:00 |  | 10 | 15
2012-06-30 00:00:00 |  | 44
 |  | Claims Closed Without Payment
 |  | (excl [NAME])
Accident Year | as of | 15 Months | 27 Months | 39 Months | 51 Months
2001-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2002-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2003-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2004-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2005-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2006-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2007-06-30 00:00:00 |  | 1 | 1 | 1 | 1
2008-06-30 00:00:00 |  | 4 | 4 | 4 | 4
2009-06-30 00:00:00 |  | 9 | 9 | 9 | 10
2010-06-30 00:00:00 |  | 17 | 21 | 21
2011-06-30 00:00:00 |  | 8 | 12
2012-06-30 00:00:00 |  | 21
Spreadsheet: 213879d1360681314-how-do-i-insert-checkboxes-how-do-i-link-them-to-data-validation-and-vlookup-example3
Sheet: Sheet1

 |  |  |  |  |  |  | Order Form
How many computers do you need service for? |  |  |  |  |  |  | Product Description | Product Price | Your Order Totals
50
 |  |  |  |  |  |  | Service Package | 23000 | 23000
 |  |  |  |  | X |  | Spyware Installation Package | 12000 | 12000
 |  |  |  |  |  |  | Deluxe Spyware Installation Package | 15000 | 0
 |  |  |  |  |  |  | Network Diagnostic | 25000 | 0
 |  |  |  |  |  |  |  | Total: | 35000
Data Validation |  | VLookUp
Computers |  | Service Package Question
25 |  | 25 | 12000
50 |  | 50 | 23000
100 |  | 100 | 42000
150 |  | 150 | 60000
250 |  | 250 | 85000
 |  | Spyware Installation Package
 |  | 25 | 7000
 |  | 50 | 12000
 |  | 100 | 16000
 |  | 150 | 24000
 |  | 250 | 24000
 |  | Deluxe Spyware Installation Package
 |  | 25 | 9500
 |  | 50 | 15000
 |  | 100 | 19000
 |  | 150 | 26000
 |  | 250 | 26000
 |  | Network Diagnostic
 |  | 25 | 15000
 |  | 50 | 25000
 |  | 100 | 45000
 |  | 150 | 60000
 |  | 250 | 78000
Spreadsheet: 145461d1331592113-interdependent-drop-down-lists-state-address-drop-down
Sheet: Sheet1

EXAMPLE
If State | Then List of States | If spefic state then list of addresses for that state
State | Florida | 456 S Sunny Street
State | Texas | 789 W Bull Street |  |  |  |  | State | Florida |  |  | Florida |  |  | Texas
 |  |  |  |  |  |  | Country | Texas |  |  | 123 E Coast Street |  |  | 789 W Bull Street
 |  |  |  |  |  |  |  |  |  |  | 456 S Sunny Street |  |  | 101 N Oil Ave