tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 16d7ea86-1554-4dc6-b6f9-c7fff64d1df7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 45. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (SA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413770V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413771W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413772X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413773A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413774C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413775F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413776J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413778L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413779R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413780X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 33749d1230493965-date-range-and-countifs-formulahelprequest
Sheet: Quarterly Summary

Select Date - | 2009-01-02 00:00:00
Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8
yes | yes | yes | yes | yes | yes | yes | yes
no | no | no | no | no | no | no | no
no | no | no | no | no | no | no | no
yes | yes | yes | yes | yes | yes | yes | yes
yes | yes | yes | yes | yes | yes | yes | yes
yes | yes | yes | yes | yes | yes | yes | yes
 | Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | Item 6 | Item 7 | Item 8
2009-01-02 00:00:00
2009-01-09 00:00:00
2009-01-16 00:00:00
2009-01-23 00:00:00
2009-01-30 00:00:00
2009-02-06 00:00:00
2009-02-13 00:00:00
2009-02-20 00:00:00
Spreadsheet: 746598d1630883634-index-and-match-automatically-populate-matches-match-two-data-fields-richardcranford-
Sheet: Match 

[NAME] | [NAME] number | [NAME] | [NAME] Number | Product Description | Amount Availabe | Match
Spreadsheet: 85261d1285285196-how-to-extract-names-that-are-flagged-by-red-dots-book2-vlookup
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | column results after vlookup
 |  |  |  | Aug 30th | Aug 31st | Sept 1st | Sept 2nd | Sept 3rd | Sept 4th | Sept  5th | Sept 7th | Sept 10th | Sept 13th | Sept 17th | Sept 19th | Sept 20th | Sept 21st | Sept 22nd | Sept 23rd | Sept 24th | Sept 25th | Sept 28th | Sept 29th | Sept 30th | Oct 1st | Oct 2nd | Oct 5th | Oct 6th
# | e number | NAME |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | results I would like to see for Sept 25th | results for Sep 28th | results for Sep 29th
1 | 6710 | A |  |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X |  |  |  | B | C | D
2 | 6720 | B |  | X |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X |  |  | H | I | J
3 | 6721 | C |  |  | X |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X
4 | 6730 | D |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X
706 | 6731 | E |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X
404 | 6740 | F |  |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X
323 | 6741 | G |  | X |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X
 | 6750 | H |  |  | X |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X
 | 6751 | I |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X
 | 6760 | J |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X
 | 6761 | K |  |  |  |  |  | X |  |  |  |  | X |  |  |  |  |  | X |  |  |  |  | X
Spreadsheet: 686523d1594666407-lookup-with-2-criterias-hlookup-or-indec-match-book1
Sheet: Sheet2

 | 56 |  |  | FORMULA | BP | UPS
2020 | Apr |  |  |  | 0 | 0
2020 | May |  |  |  | 0 | 0
2020 | Jun |  |  |  | 0 | 0
2020 | Jul |  |  |  | 0 | 0
2020 | Aug |  |  |  | 0 | 0
2020 | Sep |  |  |  | 0
2020 | Oct
2020 | Nov
2020 | Dec
2021 | Jan
2021 | Feb
2021 | Mar
2021 | Apr
2021 | May
2021 | Jun
2021 | Jul
2021 | Aug
2021 | Sep
2021 | Oct
2021 | Nov
2021 | Dec
2022 | Jan
2022 | Feb
2022 | Mar
2022 | Apr
2022 | May
2022 | Jun
2022 | Jul
2022 | Aug
2022 | Sep
2022 | Oct
2022 | Nov
2022 | Dec
2023 | Jan
2023 | Feb
2023 | Mar
2023 | Apr
2023 | May
2023 | Jun
2023 | Jul
Spreadsheet: robert_badeer__33092__8_25
Sheet: Sheet1

WEST | TRADE DATE | Counterparty | Buy/Sell from EPMI View | Buy/Sell from EES View | Trader | Location | Type (PFI) | Term | Peak, Off-peak, Super Peak, [NAME] or Flat | Volume | Price | Broker,EOL, Internal or Notes | EPMI TRADER Providing Sleeve | EPMI Deal # | EES DEAL Tracker # | EES Traders
1 | 2000-08-25 00:00:00 | SEMPRA | BUY | SLEEVE | MB | NP | P | Q4 00 | PEAK | 25 | 121.5 | TFS | MS |  | 5480 | JW = [NAME]
2 |  | EES | SELL | BUY | JW | NP | P | Q4 00 | PEAK | -25 | -121.55 |  |  |  |  | NB= [NAME]
3
4 |  | PUGET | BUY | SLEEVE |  | NP | P | Q4 00 | PEAK | 25 | 123 | AMEREX | MS |  | 5479
5 |  | EES | SELL | BUY | JW | NP | P | Q4 00 | PEAK | -25 | -123.05
6
7 |  | CITIZENS | SELL | SLEEVE | [NAME] | NP | P | Q4 00 | PEAK | -25 | -117.25 | APB | JR |  | 5481
8 |  | EES | BUY | SELL | JW | NP | P | Q4 00 | PEAK | 25 | 117.2
9
10 |  | DUKE | BUY | SLEEVE | DH | SP | P | Q4 00 | PEAK | 25 | 98.25 | APB | JR |  | 5486
11 |  | EES | SELL | BUY | JW | SP | P | Q4 00 | PEAK | -25 | -98.2
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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
Spreadsheet: 680421d1591013306-find-and-replace-with-differing-outputs-example
Sheet: Summary

 |  | 2021 | 2022 | 2023 | 2024 | 2025 |  | <<<Target
 | Algeria
 | Algeria
 | Argentina
 | Argentina
 | Bahrain
 | Bahrain
 | Bolivia
 | Bolivia
 | Brazil
 | Brazil
 | etc etc
 |  | 2021 | 2022 | 2023 | 2024 | 2025 |  | <<<Current
 | Algeria |  |  |  |  |  |  | Have all linked to Algeria but would like to do a find and replace so that the lines against Argentina link to Argentina worksheet, the lines against Bahrain link to Bahrain worksheet, etc
 | Algeria
 | Argentina
 | Argentina
 | Bahrain
 | Bahrain
 | Bolivia
 | Bolivia
 | Brazil
 | Brazil
 | etc etc
Spreadsheet: 687054d1594928941-heavy-file-for-calculation-and-save-dates
Sheet: K Test

Sr.
 | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date | File Name | Ext | Date
 | 09-01) 30-09-2018 | pdf |  | 02-01) 23-02-2019 | pdf |  | 02-01) 21-02-2019 | pdf |  | 03-01) 05-03-2019 | pdf |  | 10-01) 31-10-2019 | pdf
 | 10-01) 28-10-2018 | pdf |  | 05-01) 12-05-2019 | pdf |  | 03-01) 21-03-2019 | pdf |  | 10-01) 23-10-2019 | pdf |  | 02-01) 16-02-2020 | pdf
 | 11-01) 29-11-2018 | pdf |  | 05-02) 27-05-2019 | pdf |  | 05-01) 09-05-2019 | pdf |  | 03-01) 15-03-2020 | pdf
 | 12-01) 30-12-2018 | pdf |  | 08-01) 07-08-2019 | pdf |  | 09-01) 11-09-2019 | pdf
 | 01-01) 31-01-2019 | pdf |  | 08-02) 18-08-2019 | pdf |  | 11-01) 25-11-2019 | pdf
 | 02-01) 24-02-2019 | pdf |  | 10-01) 30-10-2019 | pdf |  | 01-01) 27-01-2020 | pdf
 | 03-01) 27-03-2019 | pdf |  | 02-01) 15-02-2020 | pdf |  | 02-01) 27-02-2020 | pdf
 | 04-01) 24-04-2019 | pdf |  | 06-01) 08-06-2020 | pdf |  | 05-01) 21-05-2020 | pdf
 | 05-01) 13-05-2019 | pdf
 | 06-01) 27-06-2019 | pdf
 | 08-01) 22-08-2019 | pdf
 | 09-01) 29-09-2019 | pdf
 | 10-01) 31-10-2019 | pdf
 | 11-01) 28-11-2019 | pdf
 | 12-01) 26-12-2019 | pdf
 | 01-01) 30-01-2020 | pdf
 | 02-01) 16-02-2020 | pdf
 | 03-01) 19-03-2020 | pdf
 | 05-01) 17-05-2020 | pdf
 | 06-01) 11-06-2020 | pdf
Spreadsheet: mary_fischer__25633__31P
Sheet: E31.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY #  31P
COMPANY NAME  Limbach Holdings, Inc
RECONCILIATION OF STOCKHOLDERS' EQUITY AND INVESTMENT IN SUBS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
 |  |  |  | 12-31-00 Balance |  |  |  | EQUITY IN |  | DIVIDENDS DECLARED |  |  |  | OTHER ACTIVITY
 |  |  |  | DR  (CR) |  | RECLASS 00 NI |  | EARNINGS |  |  |  |  |  |  |  |  |  | DR  (CR)
 |  | Hyp line |  | BEG BALANCE |  | TO BEG RE |  | /LOSSES |  | COMMON |  | PREFERRED |  | DR (CR) |  | (Describe) |  | END BALANCE
Shareholders Equity by Parent |  | Reverse signs from Hyperion
Common Stock |  | 0901 |  | -10000
Paid in Capital |  | 0910
Contribution Received from Parent |  | 0915 |  | -65447558
RE - Beg Bal |  | 0920 |  | -14516694 |  | -346622 |  |  |  |  |  |  |  |  |  | C&E Entries
RE - Net Income |  | 0930 |  | -346622 |  |  |  | 294734
RE - Net Income (Fair Value Adjustment) |  | 0931
Dividends Decl - Preferred Stock |  | 0935
Dividends Decl - Common Stock |  | 0941
Invest in Subs Plug Account |  | 0942 |  |  |  |  |  | 1
Total Shareholders' Equity |  | TOT_SHARE_EQU
Net Income |  | NET_INCOME
PARENT'S CO #
Investment in Consol Sub (on Parent Books) |  |  |  | Same signs as Hyperion
Investment in CS |  | 0215
Investment in PIC (contrib by parent) |  | 0216
Investment in Equity earnings of sub |  | 0217
Total Investment in Consol Sub
Equity in Consol Sub |  | 1505
Difference between SE (on sub) and Invest (on parent)
Reasons for Differences
A schedule will need to be prepared for each subsidiary.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-31
Spreadsheet: 453722d1459426408-formula-for-calculation-of-fifo-testing-fifo
Sheet: Sheet1

Bought |  |  | Consumed |  |  | Closing Stock
Litres | Price | Value | Litres | Price | Value | Litres | Price | Value
4000 | 1.21
4200 | 1.19
8000 | 1.31
4662 | 1.31
Total
Consumed
Spreadsheet: 11692376-6e36-4910-84d3-6ef49d616802
Sheet: Sheet1

 | 2013-14 Washington Youth Soccer State Cups- Association Tournament Reps (ATRs) List
 | This list of people should be your first point of contact.
 | Member Association | First | Last | Your Primary Contact Email | Phone | Ref Assignor |  | [NAME] | Phone #
 | Auburn Youth Soccer Association | Sara | Birt | [EMAIL] | 2536784630 | [NAME] | [NAME] | [EMAIL] | 2533509215
 | Eastside Youth Soccer Association | [NAME] | Leo | [EMAIL] | 2063103722 | Iraj | Jalali | [EMAIL] | [PHONE]
 | Federal Way Soccer Association | Novella | [NAME] | [EMAIL] | [PHONE] | [NAME] | Simone | [EMAIL] | [PHONE]
 | Greater Renton Junior Soccer Association | Rich | Turner | [EMAIL] | 2069486936 | [NAME] | Moore | [EMAIL] | 2536531342
 | Grays Harbor Youth Soccer Association | Travis | [NAME] | [EMAIL] | [PHONE] | Travis | [NAME] | [EMAIL] | [PHONE]
 | Greater Spokane Youth Soccer Association | [NAME] | Windham | [EMAIL] | [PHONE] | Saeed | [NAME] | [EMAIL] | [PHONE]
 | Highline Soccer Association | Staci | Braun | [EMAIL] | [PHONE] | Adrian | [NAME] | [EMAIL] | [PHONE]
 | Kent Youth Soccer Association | [NAME] | Wolfe | [EMAIL] | [PHONE] | [NAME] | [NAME] | [EMAIL] | [PHONE]
 | Lake Washington Youth Soccer Association | Connie | [NAME] | [EMAIL] | [PHONE] | [NAME] | Hulen | [EMAIL] | [PHONE]
 | North County Youth Soccer Association | Naomi | [NAME] | [EMAIL] | [PHONE] | Various | Assignors | [EMAIL] | [PHONE]
 | Northshore Youth Soccer Association | M'ily | Reiter | [EMAIL] | [PHONE] | [NAME] | [NAME] | [EMAIL] | [PHONE]
 | Northwest Sound Youth Soccer Association | [NAME] | Bjornemo | [EMAIL] | [PHONE] | [NAME] | Sommers | [EMAIL] | [PHONE]
 | Olympic Youth Soccer Association | [NAME] | [NAME] | [EMAIL] | [PHONE] | [NAME] | [NAME] | [EMAIL] | [PHONE]
 | Seattle Youth Soccer Association | Jessica | Beckton | [EMAIL] | [PHONE] | Cathy | Echert | [EMAIL] | [PHONE]
 | Snohomish Youth Soccer Association | [NAME] | Bies-Johnson | [EMAIL] | [PHONE] | [NAME] | [NAME] | [EMAIL] | [PHONE]
 | South Snohomish County Youth Soccer Association | Dina | [NAME] | [EMAIL] | [PHONE] | [NAME] | Fadden | [EMAIL] | [PHONE]
 | Southwest Washington Youth Soccer Association | [NAME] | Hunting | [EMAIL] | [PHONE] | [NAME] | Brooks | [EMAIL] | [PHONE]
 | Tacoma Pierce County Junior Soccer Association | Ray | Moffatte | [EMAIL] | [PHONE] | [NAME] | Moore | [EMAIL] | 2536531342
 | Tri-Cities Youth Soccer Association | Thompson | Krissy | [EMAIL] | 5095440276 | [NAME] | Braun | [EMAIL] | [PHONE]
 | Whatcom County Youth Soccer Association | [NAME] | Mueller | [EMAIL] | [PHONE] | [NAME] | Kulm | [EMAIL] | [PHONE]
 | Whidbey Island Youth Soccer Association | [NAME] | McCleary | [EMAIL] | [PHONE] | [NAME] | [NAME] | [EMAIL] | [PHONE]
 | See Directory, for list of clubs & corresponding Associations
 | http://www.washingtonyouthsoccer.org/club_directory/
Spreadsheet: 585427d1533759518-assets-booking-sheet-tracking-most-recent-booking-item-tracking
Sheet: Booking Sheet

Item | User | Out | Returned | last
Red | Person 1 | 2018-02-01 00:00:00 | 2018-03-02 00:00:00
Blue | Person 2 | 2018-02-02 00:00:00 | 2018-04-02 00:00:00
Green | Person 3 | 2018-02-03 00:00:00 | 2018-05-03 00:00:00
Yellow | Person 4 | 2018-02-04 00:00:00 | 2018-04-04 00:00:00
Red | Person 2 | 2018-03-05 00:00:00 | 2018-04-05 00:00:00
Blue | Person 4 | 2018-05-05 00:00:00 | 2018-07-07 00:00:00
Spreadsheet: 32459d1228638341-how-to-reference-cells-in-different-rows-example-of-weekly-account-sheets
Sheet: Week 1

1 | SALES | 1
1 | SALES | 1 |  |  |  |  |  | 100 |  | Each color represents an account and all the information within the account is laid out identical each week.
1 | SALES | 1
1 | SALES | 1 |  |  |  | 310
1 | SALES | 1
1 | SALES | 1 |  |  |  |  | BLUE
1 | SALES | 1
1 | SALES | 1
1 | SALES | 1 |  | 200
1 | SALES | 1
1 | SALES | 2
1 | SALES | 2 |  |  |  |  |  | 101
1 | SALES | 2
1 | SALES | 2 |  |  |  | 311
1 | SALES | 2
1 | SALES | 2 |  |  |  |  | RED
1 | SALES | 2
1 | SALES | 2
1 | SALES | 2 |  | 201
1 | SALES | 2
1 | SALES | 3
1 | SALES | 3 |  |  |  |  |  | 102
1 | SALES | 3
1 | SALES | 3 |  |  |  | 312
1 | SALES | 3
1 | SALES | 3 |  |  |  |  | GREEN
1 | SALES | 3
1 | SALES | 3
1 | SALES | 3 |  | 202
1 | SALES | 3
1 | SALES | 4
1 | SALES | 4 |  |  |  |  |  | 103
1 | SALES | 4
1 | SALES | 4 |  |  |  | 313
1 | SALES | 4
1 | SALES | 4 |  |  |  |  | WHITE
1 | SALES | 4
1 | SALES | 4
1 | SALES | 4 |  | 203
1 | SALES | 4
Spreadsheet: 874932d1721448334-how-to-sum-hours-worked-how-to-sum-hours-worked
Sheet: Sheet1

 |  |  |  |  |  |  | Alternative formula using MOD function:
 | Start Time |  | End Time |  | SUM |  | Start | End | SUM | Combined Formula |  | [NAME]
1 | 5 | AM | 10 | AM
 | 10 | AM | 12 | AM
 | 12 | AM | 12 | AM
 | 12 | AM | 1 | AM
 | 2 | AM | 2 | AM
 | 8 | AM | 2 | AM
2 | 5 | PM | 10 | PM
 | 10 | PM | 12 | PM
 | 12 | PM | 12 | PM
 | 12 | PM | 1 | PM |  |  |  |  |  |  |  | How to sum hours worked
 | 2 | PM | 2 | PM |  |  |  |  |  |  |  | https://www.excelforum.com/excel-general/1426439-how-to-sum-hours-worked.html
 | 8 | PM | 2 | PM
3 | 5 | AM | 10 | PM
 | 10 | AM | 12 | PM
 | 12 | AM | 12 | PM
 | 12 | AM | 1 | PM
 | 2 | AM | 2 | PM
 | 8 | AM | 2 | PM
4 | 5 | PM | 10 | AM
 | 10 | PM | 12 | AM
 | 12 | PM | 12 | AM
 | 12 | PM | 1 | AM
 | 2 | PM | 2 | AM
 | 8 | PM | 2 | AM
Spreadsheet: 135294d1325907350-if-then-formula-help-for-an-unknown-number-budget-1-solution
Sheet: Sheet1

EXPECTED INCOME |  |  |  |  | actual monthly income |  |  |  |  |  |  | projected monthly savings
 |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN
jessicas |  |  | 1800 |  |  |  |  |  |  |  |  | actual monthly savings
[NAME]'s |  |  | 3900 |  | 2356.51 |  |  |  |  |  |  |  |  | JAN
 |  |  |  |  |  |  |  |  |  |  |  |  |  | FEB
total  income |  |  |  |  |  |  |  |  |  |  |  |  |  | MAR
 |  |  |  |  |  |  |  |  |  |  |  |  |  | APR
expenses |  |  |  |  | actual montly spendings |  |  |  |  |  |  |  |  | MAY
 |  |  |  |  | JAN | FEB | MAR | APR | MAY | JUN |  |  |  | JUN
house |  |  | 675.65 |  | 675.65
cable |  |  | 162 |  | 161.66
phone |  |  | 210
car |  |  | 283 |  | 283.5 |  |  |  |  |  |  | savings starting JAN 1st 2012 |  |  | 6216
personal loan |  |  | 160 |  | 158.14 |  |  |  |  |  |  | goal savings by [NAME] |  |  | 21810
car insurance |  |  | 95
electric |  |  | 160 |  |  |  |  |  |  |  |  | projected saving by june
water |  |  | 45
ADT |  |  | 41.99
trash |  |  | 20.66 |  | 20.66 | 20.66 | 20.66 | 20.66 | 20.66 | 20.66 |  | actual savings thus far
food |  |  | 600 |  | 174.44
gas |  |  | 350
MISC |  |  | 300 |  | 121.25
personal [NAME] |  |  | 160 |  | 0
net flix |  |  | 8
total
Spreadsheet: 109432d1306285481-conditional-formatting-example-of-weekly-plan-only
Sheet: Weekly Training-Study Overview

Weekly Training/Study Schedule
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
7.00 - 7.30 |  |  |  |  |  |  | Total Training Hrs
7.30 - 8.00
8.00 - 8.30
8.30 - 9.00
9.00 - 9.30
9.30 - 10.00
10.00 - 10.30
10.30 - 11.00
11.00 - 11.30
11.30 - 12.00
12.00 - 12.30
12.30 - 13.00
13.00 - 13.30
13.30 - 14.00
14.00 - 14.30
14.30 - 15.00
15.00 - 15.30
15.30 - 16.00
16.00 - 16.30
16.30 - 17.00
17.00 - 17.30
17.30 - 18.00
18.00 - 18.30
18.30 - 19.00
19.00 - 19.30
19.30 - 20.00
20.00 - 20.30
20.30 - 21.00
21.00 - 21.30
21.30 - 22.00
Total hrs
 |  | England Performance Training |  |  | Own Training |  | Study
 |  | [NAME] |  |  | S&C/Physical
EPT
PC
Spreadsheet: 121148d1315867662-if-match-formula-example-match
Sheet: Sheet1

Dept Roll Up | Supervisor Roll Up |  | Department | Supervisor?
AHC CT SCAN | [NAME] |  | COV HSD MRI
AUB HSD MRI | [NAME] |  | GSH MOTHER/BABY UNIT
COV HSD MRI | [NAME] |  | TG MRI
COV HSD MRI | [NAME] |  | AHC CT SCAN
COV HSD NUCLEAR MEDICINE | [NAME] |  | COV HSD NUCLEAR MEDICINE
GSH MOTHER/BABY UNIT | [NAME] |  | AUB HSD MRI
TG BIRTH CENTER | [NAME] |  | COV HSD MRI
TG MRI | [NAME] |  | TG MRI
TG MRI | [NAME] |  | TG MRI
Spreadsheet: 113392d1309307096-conditional-formatting-contact-calander
Sheet: Sheet1

2011-06-28 00:00:00 | QUOTE | ORDER | Contact Tracker |  |  |  |  |  |  |  |  | DAYS |  | DAYS |  | DAYS | BDAY | DAYS
Date |  |  | Last Name | First Name | Address | City | Postal | [NAME] | Phone | Cell | Quote Card |  | [NAME] |  | 6 Mth |  | 12 Mth
2011-06-22 00:00:00 | Y |  |  |  |  |  |  |  |  |  | 2011-06-29 00:00:00 | 1 |  |  | 2011-12-19 00:00:00 | 174
Spreadsheet: 0264969a-a5ab-4584-adb1-9d0d2c229817
Sheet: NewCourses

New Courses
C &I Meeting Date | New Course Title | Date Approved by AA | Date of BOT Approval | Date submitted to CO | CCC Inventory Number | UC TCA Date Submitted | CSU Sta submitted
2013-03-13 00:00:00 | ENGL 222 | 2013-04-03 00:00:00 | 2013-04-15 00:00:00 | 2013-05-01 00:00:00
2013-03-13 00:00:00 | ENGL 222 "Prerequisite: Eligibility for ENGL 101. Recommended Preparation: [NAME] 112 or equivalent." | 2013-04-03 00:00:00 | 2013-04-15 00:00:00 | 2013-05-02 00:00:00
2013-03-13 00:00:00 | ENGL 193 | 2013-04-03 00:00:00 | 2013-04-15 00:00:00 | 2013-05-03 00:00:00
2013-03-13 00:00:00 | ENGL 193 "Prerequisite: ENGL 190 (English 190 may be taken concurrently). Corequisite: English 199." | 2013-04-03 00:00:00 | 2013-04-15 00:00:00 | 2013-05-04 00:00:00
2013-03-13 00:00:00 | ENGL 199 | 2013-04-03 00:00:00 | 2013-04-15 00:00:00 | 2013-05-05 00:00:00
2013-03-13 00:00:00 | ENGL 199 "Prerequisite: Placement is based on a composite of test scores and academic background or satisfactory completion of ENGL 189.  Concurrent enrollment in or compltion of ENLG 190 is required." | 2013-04-03 00:00:00 | 2013-04-15 00:00:00 | 2013-05-06 00:00:00
2013-03-13 00:00:00 | ADMJ 203 | 2013-04-03 00:00:00 | 2013-04-15 00:00:00 | 2013-05-07 00:00:00
2013-03-13 00:00:00 | Recommended Prep | 2013-04-03 00:00:00 | 2013-05-20 00:00:00 | 2013-05-08 00:00:00
2013-04-10 00:00:00 | ENGR 152 | 2013-04-03 00:00:00 | 2013-05-20 00:00:00 | 2013-05-09 00:00:00
2013-04-10 00:00:00 | ENGR 152 Prerequisite: MATH 104 | 2013-04-03 00:00:00 | 2013-05-20 00:00:00 | 2013-05-10 00:00:00
2013-04-10 00:00:00 | [NAME] 130 | 2013-04-03 00:00:00 | 2013-05-20 00:00:00 | 2013-05-11 00:00:00
2013-04-10 00:00:00 | CS /IS157 | 2013-04-03 00:00:00 | 2013-05-20 00:00:00 | 2013-05-12 00:00:00
2013-05-08 00:00:00 | AD ST 154 | 2013-06-05 00:00:00 | 2013-06-24 00:00:00 | Aug. 14. 2013 |  |  | 2013-06-24 00:00:00
2013-05-08 00:00:00 | LIB 190 | 2013-06-05 00:00:00 | 2013-06-24 00:00:00 | 6/19/2013 demo. needs to be submitted
2013-05-08 00:00:00 | ITECH 157 | 2013-06-05 00:00:00 | 2013-06-24 00:00:00 | 2013-05-13 00:00:00
2013-05-08 00:00:00 | ITECH 158 | 2013-06-05 00:00:00 | 2013-06-24 00:00:00 | 2013-05-13 00:00:00
2013-05-08 00:00:00 | [NAME] 131 | 2013-06-05 00:00:00 | 2013-06-24 00:00:00
2013-06-12 00:00:00 | HIT 182 | 2013-10-04 00:00:00 | 2013-10-21 00:00:00 | 2013-10-21 00:00:00
2013-06-12 00:00:00 | HIT 186 | 2013-10-04 00:00:00 | 2013-10-21 00:00:00 | 2013-10-21 00:00:00
2013-06-12 00:00:00 | HIT 193 | 2013-10-04 00:00:00 | 2013-10-21 00:00:00 | 2013-10-21 00:00:00
2013-06-12 00:00:00 | HIT 194 | 2013-10-04 00:00:00 | 2013-10-21 00:00:00 | 2013-10-21 00:00:00
Spreadsheet: 79904d1280163125-scatter-chart-templates-dont-work-scatter-chart-template-test
Sheet: Scatter

29 | 34 |  | This chart is the one I manually formatted and then saved as a template:
36 | 35
37 | 34
38 | 44
48 | 55
50 | 65
59 | 41
62 | 64
64 | 77
89 | 78
140 | 111
154 | 211
169 | 188
193 | 157
287 | 277
407 | 444
430 | 366
476 | 444
455 | 654
356 | 666
123 | 544
432 | 322
 |  |  | This is the result of selecting A1:B22 above, and inserting a chart based on the newly create template:
Spreadsheet: 882352d1730726690-conditional-format-with-and-or-book1-bhenlee
Sheet: Sheet1

1
1 | total
1 |  | total
1 | total | total
0
0 | total
0 |  | total
0 | total | total
Spreadsheet: 685446d1594017517-calculating-tax-percentage-calc-v5-temp
Sheet: 102 Auto

[NAME] | cost | c | d | o | 1st | c |  | mr | ma | q | b | Sku | %
1000 | 79.8 |  |  |  | 0 |  |  | 65 |  |  |  | 1000 | 8
1001 | 69.75 |  |  |  | 5.2 |  |  | 1.35 |  |  |  | 1001 | 9
1002 | 100 |  |  |  | 5.2 |  |  | 1.35 |  |  |  | 1002 | 6
 |  |  |  |  |  |  |  |  |  |  |  | 1003 | 9
 |  |  |  |  |  |  |  |  |  |  |  | 1004 | 10