tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41250d1239739584-updating-dates-on-separate-tabs-based-on-date-in-first-tab-form-booking-sheets-all-1
Sheet: T20

Boeing Tour - AM |  |  |  |  | 2009-05-27 00:00:00
 | Driver: |  |  |  | Vehicle: |  |  |  |  |  | Prepaid
P/U Time | Booked by |  | Hotel |  | Party | A | C | CT | MF | Amt | CC | Ck | Collect | [NAME]
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
Daily Total:
Pricing
Retail: | Adult | 55 | Child | 45 | Reseller: | Adult |  | 44 | Child |  | 36
Resellers: Alcatraz Media, [NAME], Look Tours, Sightseeing World, TourCorp
Driver Pickup Summary
Spreadsheet: 2521fef0-37fb-4c28-9c19-f855a04749cf
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 31. LEASE FINANCE COMMITMENTS, By Purpose: State (NSW), 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 | A2413975X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413976A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413977C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413978F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413979J | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413980T | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413981V | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413982W | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413983X | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413984A | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413985C | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413986F | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413987J | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413988K | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413989L | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413990W | 1985-01-01 00:00:00 | 2012-12-01 00:00:00 | 336 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: mary_fischer__25817__RETAIL4 1CE 2CE variance analysis
Sheet: WHSEES4

EES - WHSEES4
Analysis of 1st CE to 2nd CE Variances
For the tax year 2001
(in millions)
DR/(CR)
(Income)/Loss
 | 1CE | 2CE | [NAME] |  | Reasons for variance
Net Income Before Tax | 830 | 762 |  |  | Estimation of losses adjusted by accounting
Permanent Differences
Dividends | 0 | 0
Equity Earnings | 0 | 0
Foreign Operations | 0 | 0
Foreign Taxes | 0 | 0
Gain/Loss On Sale of Stock/Assets | 0 | 0
Other - Expense related to IC purchase | 0 | -20 |  |  | See Note 1
Other - Reverse additional June revenue | 0 | 5 |  |  | See Note 1
Total Permanent Differences
Temporary Differences
Depreciation, Depletion, & Amort. | 0 | -1 |  |  | Adjusted estimate based on book numbers
Partnership Equity | 0 | 0
Gain/Loss On Sale of Stock/Assets | 0 | 0
Price Risk Management | -249 | 165 |  |  | See Note 2
Regulatory Contingencies | 0 | 0
Other - Rev of Purchase Price Write-off | 0 | -8 |  |  | Revaluation of purchase price for Enron Marketing Corp
Other - Rev Management Overview | 0 | 4 |  |  | Overview not reported separately in 1 CE
Total Temporary Differences
Total State Taxable Income
Current State Tax Exp/(Bene) | 0 | 0
Total Federal Taxable (Income)/Loss
Current Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal | 91 | 91
Other State | 0 | 0
Other Foreign | 0 | 0
Total Current Tax Expense (Benefit)
Deferred Tax Expense (Benefit)
Federal
State | 0 | 0
Foreign | 0 | 0
Federal Tax Credits | 0 | 0
Other Federal | -91 | -91
Other State | 0 | 0
Other Foreign | 0 | 0
Total Deferred Tax Expense (Benefit)
Total Tax Expense (Benefit)
Net (Income) / Loss
Effective Rate
Additional Notes regarding changes from 1CE to 2CE:  [NAME] (DR/(CR)
Note 1:  Enron Marketing Corp was purchased on June 29,2000. Accounting
discovered in Q2 that income and expense activity from the month of June
prior to the date of acquisition had been included in 1CE numbers and the
amounts were reversed.
Note 2: The following changes were made to PRM activity for WHSEES4:
Avista [NAME] transferred to WHSEES4 from RETAIL4 |  | 137
Changes to MTM estimates |  | 277
Spreadsheet: 109275d1306183160-excel-2007-indirect-stops-at-first-number-example
Sheet: Q3

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jumpy | Slappy | Bilbo
 |  |  |  |  |  | 2011-04-01 00:00:00 |  |  |  |  |  |  |  |  |  | 4.3 | 4.3
 |  |  |  |  |  | 2011-04-01 00:00:00 |  |  |  |  |  |  |  |  |  | 3 | 3
 |  |  |  |  |  | 2011-04-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0.3 | 0.3
 |  |  |  |  |  | 2011-04-05 00:00:00 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  | 2011-04-05 00:00:00 |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  | 2011-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  | 2011-04-05 00:00:00 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  | 2011-04-05 00:00:00 |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  | 2011-04-06 00:00:00 |  |  |  |  |  |  |  |  | 0.3
 |  |  |  |  |  | 2011-04-06 00:00:00 |  |  |  |  |  |  |  |  |  | 0.3 | 0.3
Spreadsheet: 85f71c26-133b-40c7-ba53-008abba87ab2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7822 | 58922 | [NAME] | De Ruijter | NED | 53 | [NAME] | [NAME] | 00:37:07 | 00:01:04 | 00:22:44 | 1 | 01:21:10
7822 | 46870 | Britt | [NAME] | NED | 58 | 00:15:24 | [NAME] | 00:40:03 | 00:01:18 | 00:23:48 | 2 | 01:21:59
7822 | 60574 | Anne | Reintjes | NED | 57 | 00:18:28 | 00:01:46 | 00:43:45 | 00:01:18 | [NAME] | 3 | 01:32:04
7822 | 40550 | Lucie | Materova | CZE | 54 | 00:23:25 | 00:01:40 | 00:45:58 | 00:01:23 | 00:25:38 | 4 | 01:38:03
7822 | 40364 | Sandra | [NAME] | EST | 55 | 00:21:55 | 00:01:39 | 00:52:59 | 00:01:27 | 00:25:37 | 5 | 01:43:34
7822 | 57249 | [NAME] | [NAME] | NED | 56 | 00:21:55 | 00:01:31 | 00:43:59 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 37b8a64d-6e5d-412c-b130-6c3882947009
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FENTU | Test | FENTU | [NAME], [NAME] | [NAME] and Metabolite, U | FENTU: Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) ADULT: Spectrophotometry (SP) |  |  |  | 3 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 3 mL Collection Instructions:  1. Collect a random urine specimen. 2. No preservative.  Additional Information: 1. No specimen substitutions.  2. No STATS are accepted for this procedure.  3. For situations where chain of custody is required, a Chain-of-Custody Kit (Supply T282) is available. For chain-of-custody information, see COCH / Chain-of-Custody Processing. | 2.1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Negative | Monday through Thursday | 3 days | 6 days | 1 | 80299 |  |  |  |  | Rochester
FENTU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
FENTU | Result | 45531 | Norfentanyl | Norfentanyl | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 11075-9 | Norfentanyl:MCnc:Pt:[NAME]:Qn:
FENTU | Result | 45530 | [NAME] | [NAME] | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3637-6 | [NAME]:MCnc:Pt:[NAME]:Qn:
FENTU | Result | 45532 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69050-3
FENTU | Result | 45533 | Chain of Custody | Chain of Custody | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FENTU | [NAME] | ADULT | Adulterants Survey, [NAME] | Adulterants Survey, U |  |  |  |  |  |  | This test is only orderable as a reflex. |  |  |  | Monday through Sunday | Same day/1 day | 2 days |  |  |  |  | Yes | No
ADULT | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 14 days
ADULT | Result | 20606 | Creatinine, U | Creatinine, U | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
ADULT | Result | 22312 | Specific Gravity | Specific Gravity | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5811-5 | Specific gravity:Rden:Pt:[NAME]:Qn:Test strip
ADULT | Result | 23509 | pH | pH | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2756-5 | pH:LsCnc:Pt:[NAME]:Qn:
ADULT | Result | 23511 | Oxidants | Oxidants | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
ADULT | Result | 23510 | Nitrites | Nitrites | Alphanumeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 32710-6 | Nitrite:ACnc:Pt:[NAME]:[NAME]:
ADULT | Result | 30914 | Comment | Comment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8 | Annotation comment:Imp:Pt:{system}:Nar:
Spreadsheet: 92061d1291736105-how-do-i-copy-a-value-to-from-one-sheet-to-another-by-looking-up-values-in-3-columns-registration-workbook
Sheet: CCR

For all new rows, copy the formulas from the row above.  To hide blanks, choose the Registration_Num filter, and de-select Blanks. |  | For all new rows, copy the formulas from the row above. |  |  |  |  | Enter Date in Format MM/DD/YYYY | Choose Yes or No from Drop-Down List | Enter File Name, then Right-click and [NAME] | Enter Date in Format MM/DD/YYYY
 |  | Registrant Type
Registration_Num | Registrant_Name | Collection | Consol | Recycl | R2_RIOS | Estewards | [NAME] | Cetification_Signed | E-document_Link | Date_of_Last_Update | Notes
Spreadsheet: 860482d1708567618-rearranging-data-based-on-delimiter-rearranging-data-based-on-delimiter-excelforum
Sheet: Sheet1

 |  | Area 1 | Area 2 | Area 3 | Area 4
 | 2023-01-01 00:00:00 | [NAME] | Apples | Banana Mango | [NAME]
 | 2023-02-01 00:00:00 | Banana Mango | Mango | Apples | Banana Mango
 |  | Area 1 | Area 2 | Area 3 | Area 4 |  |  |  | Area 1 | Area 2 | Area 3 | Area 4
 | 2023-01-01 00:00:00 | Apples | Apples | [NAME] | [NAME] |  |  | 2023-01-01 00:00:00 | Apples | Apples | [NAME] | [NAME]
 | 2023-01-01 00:00:00 | [NAME] |  | Mango |  |  |  | 2023-01-01 00:00:00 | [NAME] |  | Mango
 | 2023-02-01 00:00:00 | [NAME] | Mango | Apples | [NAME] |  |  | 2023-02-01 00:00:00 | [NAME] | Mango | Apples | [NAME]
 | 2023-02-01 00:00:00 | Mango |  |  | Mango |  |  | 2023-02-01 00:00:00 | Mango |  |  | Mango
Spreadsheet: 798809d1664749449-strings-are-deduplicated-and-sorted-from-small-to-large-forumhelp
Sheet: Sheet2

505 |  | 0 | 5
8247 |  | 2 | 4 | 7 | 8
7237 |  | 2 | 3 | 7
2368 |  | 2 | 3 | 6 | 8
0249 |  | 0 | 2 | 4 | 9
106 |  | 0 | 1 | 6
122 |  | 1 | 2
Spreadsheet: 108923d1305840725-excel-2007-determine-prior-months-planned-v-actual-data
Sheet: Plan Data

Project
P1 | 14 | 100 | 95 | 55 | 88 | 63 | 34 | 52 | 55 | 21 | 46 | 44
P2 | 87 | 3 | 10 | 25 | 15 | 9 | 42 | 46 | 30 | 73 | 14 | 25
P3 | 97 | 87 | 79 | 74 | 34 | 21 | 17 | 50 | 93 | 98 | 63 | 38
P4 | 79 | 11 | 34 | 75 | 27 | 48 | 59 | 87 | 77 | 61 | 83 | 54
P5 | 38 | 34 | 74 | 98 | 56 | 61 | 50 | 49 | 69 | 91 | 84 | 43
P6 | 91 | 61 | 67 | 90 | 20 | 1 | 4 | 81 | 63 | 4 | 56 | 9
P7 | 36 | 60 | 14 | 84 | 60 | 12 | 12 | 54 | 12 | 25 | 24 | 37
P8 | 31 | 98 | 66 | 8 | 17 | 52 | 73 | 43 | 72 | 88 | 85 | 63
P9 | 20 | 91 | 13 | 65 | 62 | 93 | 47 | 17 | 60 | 32 | 76 | 49
P10 | 23 | 4 | 43 | 38 | 41 | 89 | 61 | 55 | 35 | 3 | 85 | 5
Spreadsheet: 755086d1636652783-index-match-excel-with-negative-and-positive-numbers-samiitr
Sheet: Sheet1

 | B | C
 | 2.5 | 93.77
 | 3 | 28.3
 | 3.5 | 10.83
 | 4 | 4.8
 | 4.5 | 2.25
 | 5 | 0.94
 | 5.5 | 0.096
 | 6 | -0.65
 | 6.5 | -1.25
 | 7 | -2.63
Spreadsheet: 873561d1720061604-lookup-criteria-on-one-sheet-return-applicable-rows-from-another-spreadsheet-nschepp-contractwip
Sheet: Sheet2

First Name | Last Name | Employee ID | Position | Relocation From? | [NAME] | Post Contract Relocation To? | Contract Start Date | Contract Length (Months) | Contract End Date (Auto) | Days until End Date | On Bonus | Off Bonus | Salary | Allowance Type
Spreadsheet: 736884d1623933959-need-an-alternate-to-vlookup-book6
Sheet: Sheet1

Option1 Name | Option1 Value | SML
size | 4
size | 4
size | 3
size | 2
size | 4
size | 3
size | 1
size | 3
size | 3
size | 2
size | 2
size | 3
size | 2
size | 2
size | 3
size | 4
size | 1
size | 2
size | 1
size | 3
size | 2
size | 3
size | 3
size | 1
size | 2
size | 3
size | 2
size | 3
size | 1
size | 3
size | 2
size | 3
size | 1
size | 1
size | IT 40
size | IT 42
size | IT 42
size | IT 40
size | IT 46
size | IT 42
size | IT 44
size | IT 42
size | IT 44
size | IT 40
size | IT 42
size | IT 42
size | IT 46
size | IT 40
size | IT 37
size | IT 44
size | IT 42
size | IT 40
size | IT 44
size | IT 46
size | IT 36
size | IT 37
size | IT 36
size | FR 36
size | FR 38
size | M
size | FR 38
size | FR 38
size | FR 36
size | FR 36
size | FR 38
size | FR 42
size | FR 42
size | FR 38
size | FR 38
size | FR 36
size | FR 36
size | FR 38
size | FR 42
size | FR 36
size | FR 36
size | FR 36
size | FR 42
size | IT 38
size | FR 38
size | FR 36
size | FR 40
size | L
size | S
size | M
size | FR 42
size | FR 36
size | FR 36
size | FR 40
size | FR 42
size | FR 42
size | FR 36
size | FR 38
size | FR 42
size | FR 44
size | FR 46
size | FR 44
size | FR 40
size | FR 38
size | FR 42
size | FR 44
size | FR 40
size | FR 38
size | FR 42
size | FR 46
size | FR 40
size | FR 44
size | FR 40
size | FR 44
size | FR 42
size | FR 42
size | FR 38
size | FR 40
size | FR 42
size | FR 42
size | FR 38
size | FR 38
size | FR 40
size | FR 38
size | FR 44
size | FR 40
size | FR 42
size | FR 42
size | FR 38
size | FR 40
size | FR 44
size | FR 40
size | FR 40
size | FR 46
size | L
size | XS
size | L
size | IT 44
size | IT 40
size | IT 44
size | IT 46
size | IT 40
size | IT 42
size | IT 46
size | IT 48
size | IT 42
size | IT 42
size | IT 42
size | IT 44
size | IT 46
size | IT 48
size | IT 42
size | IT 44
size | IT 42
size | IT 46
size | IT 48
size | IT 44
size | IT 48
size | IT 42
size | IT 46
size | IT 44
size | IT 42
size | IT 40
size | IT 44
size | IT 46
size | IT 48
size | IT 42
size | IT 44
size | IT 42
size | IT 40
size | IT 42
size | FR 38
size | FR 38
Spreadsheet: mark_taylor__24980__Thursday Week 1
Sheet: Sheet1

 | Player | Priority | Wk 1 | Spread
1 | [NAME] | 5 |  | 20
 |  | 4 | Washington State | 8.5
 |  | 3 | Northern Illinois | 18 |  |  |  | Thursday 8/30
 |  | 2 |  |  |  |  |  | TEMPLE | 17 | Navy
 |  | 1 |  |  |  |  |  | Rutgers | 15 | BUFFALO
2 | [NAME] | 5 | Northern Illinois | 18 |  |  |  | NORTHERN ILLinois | 18 | South Florida
 |  | 4 | Washington State | 8.5 |  |  |  | ARKANSAS | 5.5 | Nevada-Las Vegas
 |  | 3 | Arkansas | 5.5 |  |  |  | VANDERBILT | 7.5 | Middle Tenn. State
 |  | 2 |  |  |  |  |  | Washington State | 8.5 | IDAHO
 |  | 1 |  |  |  |  |  | SAN DIEGO STATE | 1.5 | Arizona
3 | [NAME] | 5 | Oregon State | 3.5 |  |  |  | TOLEDO | 5 | Minnesota
 |  | 4 |  |  |  |  |  | Ohio | 6.5 | AKRON
 |  | 3 | Arkansas | 5.5
 |  | 2
 |  | 1 | Washington State | 8.5
4 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
5 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
6 | [NAME] | 5 | Washington State | 8.5
 |  | 4
 |  | 3 | Northern Illinois | 18
 |  | 2
 |  | 1
7 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
8 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
9 | [NAME] | 5
 |  | 4 | none
 |  | 3 | none
 |  | 2 | none
 |  | 1 | none
10 | [NAME] | 5
 |  | 4
 |  | 3 | Arkansas | 5.5
 |  | 2
 |  | 1
11 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
12 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
13 | [NAME] | 5
 |  | 4
 |  | 3 | Washington State | 8.5
 |  | 2
 |  | 1
14 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
15 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
16 | [NAME] | 5
 |  | 4 | SAN DIEGO STATE | 1.5
 |  | 3
 |  | 2
 |  | 1
17 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
18 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
19 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1 | Arkansas | 5.5
20 | [NAME] | 5
 |  | 4
 |  | 3 | Arkansas | 5.5
 |  | 2
 |  | 1
21 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
22 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
23 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
24 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
25 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
26 | [NAME] | 5
 |  | 4
 |  | 3
 |  | 2
 |  | 1
Spreadsheet: 857435d1706455712-how-to-take-the-net-present-value-of-column-of-numbers-npv-etaf
Sheet: Sheet1

 |  | NPV
 |  | 68 | -2979.65
 | 1 | 69 | -3426.597499999999
 | 2 | 70 | -3940.587124999999
 | 3 | 71 | -4531.675193749998
 | 4 | 72 | -5211.426472812498
 | 5 | 73 | -5993.140443734373
 | 6 | 74 | -6892.111510294528
 | 7 | 75 | -7925.928236838707
 | 8 | 76 | -8074.851499999999
 | 9 | 77 | -8074.851499999999
 | 10 | 78 | -8074.851499999999
 | 11 | 79 | -8074.851499999999
 | 12 | 80 | -8074.851499999999
 | 13 | 81 | -8074.851499999999
 | 14 | 82 | -8074.851499999999
 | 15 | 83 | -8074.851499999999
 | 16 | 84 | -8074.851499999999
 | 17 | 85 | -8074.851499999999
 | 18 | 86 | -8074.851499999999
 | 19 | 87 | 264753.6258698964
 | 20 | 88 | 277991.3071633913
 | 21 | 89 | 291890.8725215608
 | 22 | 90 | 306485.4161476389
 | 23 | 91 | 321809.6869550208
 | 24 | 92 | 337900.1713027718
 | 25 | 93 | 354795.1798679105
Spreadsheet: 219885d1363004027-extending-and-matching-two-columns-example
Sheet: Sheet1

Data | Manually Done | the countif function results
18 | 18
16 | 18
25 | 18
38 | 18
120 | 18
 | 16
 | 16
 | 16
 | 16
 | 16
 | 25
 | 25
 | 25
 | 25
 | 25
 | 38
 | 38
 | 38
 | 38
 | 38
 | 120
 | 120
 | 120
 | 120
 | 120
Spreadsheet: 773357d1647811386-add-and-delete-rows-from-tables-mock-up-invoice_database_sheet
Sheet: Invoices_Database

Agent | Portfolio Code | Date of Invoice | Invoice Number | Gross Amount | Ex Comm | GST | Inc Com | Net | Date Receipted | Daily Cleared | Bnk_Email | Batch_Report | Diary_Report | Internal/External | Suspense ID | Statement Path | System
Wayne Enterprise | WEAI | 2022-01-31 00:00:00 | TX7282 | 5000 |  |  | 123.8 |  |  |  |  |  |  |  |  | C:\Users\103319\Documents\Mock-Statement.xls | System 1
Wayne Enterprise | WEAI | 2022-03-17 00:00:00 | TX3662 | 2500 |  |  | 124.8 |  | 2022-03-20 00:00:00 |  |  |  |  |  |  | C:\Users\103319\Documents\Mock-Statement.xls | System 1
Wayne Enterprise | WEAI | 2022-01-18 00:00:00 | TX6188 | 14977.78 |  |  | 125.8 |  |  |  |  |  |  |  |  | C:\Users\103319\Documents\Mock-Statement.xls | System 1
The Bug Man Inc. | WEAI | 2022-01-31 00:00:00 | TX7282 | 776.2 |  |  | 126.8 |  |  |  |  |  |  |  |  |  | System 2
Wayne Enterprise | WEAI | 2022-03-17 00:00:00 | TX3662 | 19205.98 |  |  | 127.8 |  | 2022-03-15 00:00:00 |  |  | 2022-03-16 00:00:00 |  |  |  |  | System 3
The Bug Man Inc. | WEAI | 2022-01-18 00:00:00 | TX6188 | 14977.78 |  |  | 128.8 |  |  |  |  |  |  |  |  |  | System 4
Wayne Enterprise | WEAI | 2022-03-17 00:00:00 | TX3662 | 50000 |  |  | 129.8 |  |  |  |  |  |  |  |  |  | System 1
ST Nick times | WEAI | 2022-03-17 00:00:00 | TX3662 | 2500 |  |  | 130.8 |  | 2022-03-01 00:00:00 |  |  |  |  |  |  |  | System 2
Wayne Enterprise | WEAI | 2022-11-24 00:00:00 | TX7389 | 14663.13 | 5056.25 | 505.63 | 5561.88 | 14663.13 |  |  |  |  |  |  |  | https://d.docs.live.net/727e2a7f36d906d7/Documents/Docs/VBA Project/Mock-Statement.xls | Evolve
Wayne Enterprise | WEAI | 2022-04-13 00:00:00 | TX7473 | 17254.28 | 5949.75 | 594.98 | 6544.73 | 17254.28 |  |  |  |  |  |  |  | https://d.docs.live.net/727e2a7f36d906d7/Documents/Docs/VBA Project/Mock-Statement.xls | Evolve
Wayne Enterprise | WEAI | 2022-01-02 00:00:00 | TX6002 | 13448.03 | 4637.25 | 463.73 | 5100.98 | 13448.03 |  |  |  |  |  |  |  | https://d.docs.live.net/727e2a7f36d906d7/Documents/Docs/VBA Project/Mock-Statement.xls | Evolve
Wayne Enterprise | WEAI | 2022-03-08 00:00:00 | TX1923 | 17318.8 | 5972 | 597.2 | 6569.2 | 17318.8 |  |  |  |  |  |  |  | https://d.docs.live.net/727e2a7f36d906d7/Documents/Docs/VBA Project/Mock-Statement.xls | Evolve
Spreadsheet: 768905d1645196352-how-to-reduce-operator-available-hours-based-on-time-required-for-process-step-to-complete-hourly-production-schedule
Sheet: Hourly Production Schedule

 |  |  |  |  | Date
 |  |  |  |  | February |  |  |  |  |  |  |  | March
 | Part | Sub-Assemblys | Target | Time Required (hrs) | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st
 |  | [NAME] |  | 7.75 | [NAME]
 |  | Assembly |  | 7.75
 |  | Tipping |  | 1.5
 |  | Silicone Tip |  | 3.6
 |  | Assembly |  | 7.75
 |  | Assembly |  | 7.75
 |  | Open Clips |  | 7.75
 |  | Assembly |  | 7.75
 |  | Cup Clips |  | 1.55
 |  | Assembly |  | 7.75
 |  | Chamfer |  | 1.4
 |  | Cup Clips |  | 1.1
 | Operators | Hours Available p/d
 | [NAME] | 7.75
 | [NAME] | 7.75
 | [NAME] | 7.75
 | [NAME] | 7.75
 | [NAME] | 7.75
 | Gavin | 7.75
 | Andjelika | 7.75
 | Jeanette | 7.75
 | [NAME] | 7.75
 | Sepp | 7.75
 | [NAME] | 7.75