tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2e3832bf-c996-4dee-b7c7-1b3dd671ed10
Sheet: Sheet8

Reason Codes |  |  |  |  |  |  |  |  | Child Person ID |  | Days in home
1 | Travel between the foster home and school, to the extent that school transportation is not provided.
2 | Travel to physical or behavioral health appointments.
3 | Travel for administrative case or judicial review, team meetings, foster parent training or visitations.
4 | Travel for Headstart, summer school, pre-school, summer camp or driver's education class.
5 | Travel for youth sixteen (16) year and older to and from employment or searching for job.
6 | Other: Must be authorized by Department and must have prior Local Office Director approval before
 | the trip, please attach authorization.
Month of Travel
Date | Starting Address (number and street, city, state and ZIP code): |  |  |  | Destination Address (number and street, city, state and ZIP code): |  |  |  |  | Reason Code | [NAME]
Pursuant to the provision and penalties of Indiana Code 5-11-10-1, I hereby certify that the foregoing invoice is just and correct, that the amount claimed is legally due, after allowing all just credits, and that no part of the same has been paid. |  |  |  |  |  |  |  |  | Total Miles Driven Sheet 8
I hereby swear and affirm under the penalties of perjury the attached bill contains the actual travel costs provided for the individual(s) listed on such bill.  The dates, destinations, reasons and mileage for travel are true and accurate.  I understand that in submitting this that I am under oath stating and affirming that this travel was provided and fully understand that this may be independently audited and that any discrepancy may be referred to a local prosecutor for criminal prosecution.
[NAME] |  |  |  |  | Foster Family Address (number and street, city, state and ZIP code)
Foster Family Email Address |  |  |  |  | [NAME] Number |  |  |  | [NAME] Number
[NAME] |  |  |  |  | Foster Family Telephone Number |  |  |  | Date of Signature (month, day, year)
Spreadsheet: 696189d1600695794-collating-multiple-tab-info-into-one-rj-projections_chrispq
Sheet: Supplier 3

Supplier 3 |  |  |  |  |  |  | Payment Dates
Forecast Month | [NAME] (Product) | [NAME] (Number) | Container Number | Time to arrive (M) | Order Date | Container Cost (£) | Jan-20 | Feb-20 | Mar-20 | Apr-20 | May-20 | Jun-20 | [NAME] | Aug-20 | Sep-20 | Oct-20 | Nov-20 | Dec-20 | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
2021-02-01 00:00:00 | Product C | 2000 | 1 | -3 | 2020-11-01 00:00:00 | 10000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2500 | 0 | 7500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-02-01 00:00:00 | Product C | 2000 | 1 | -3 | 2020-11-01 00:00:00 | 20000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000 | 0 | 15000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-05-01 00:00:00 | Product C | 2000 | 1 | -3 | 2021-02-01 00:00:00 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12500 | 0 | 37500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2021-06-01 00:00:00 | Product C | 2000 | 1 | -3 | 2021-03-01 00:00:00 | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10000 | 0 | 30000 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: chris_germany__1961__ENA-Reliant Prepay
Sheet: Apr 2002

ENA Purchases from Reliant - April 2002
For deliveries on FGT Zone 2 & 3
[NAME] |  | [NAME][PHONE]     [EMAIL]
Backup ENA Trader |  | [NAME]  [PHONE]  [EMAIL]
[NAME] |  | [NAME]  [EMAIL]
City of Tallahassee |  | Pam McCullers [PHONE]
[NAME] |  | [NAME][PHONE]  [EMAIL]
[NAME] |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  | [NAME]  [PHONE]  [EMAIL]
Reliant Contracts |  | [NAME]  [PHONE]  [EMAIL]
Reliant Settlements |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
 | Date | Volume | Price [NAME] | GD Post | Price | Total |  | Prepayments | Balance
 |  |  |  |  |  |  |  | Balance from March 2002
Mon | 2002-04-01 00:00:00 | 2000 | Fixed Price Zone 3 | N/A | 3.32 |  |  | 0
Tue |  | 2000 | [NAME] | 3.445 |  |  |  | 0
Wed |  | 2000 | [NAME] | 3.75 |  |  |  | 0
Thu |  | 2000 | [NAME] | 3.7 |  |  |  | 37000
Fri |  | 2000 | [NAME] | 3.6 |  |  |  | 0
Sat |  | 0 |  | 3.32 |  |  |  | 0
Sun |  | 0 |  | 3.32 |  |  |  | 0
Mon |  | 2000 | [NAME] | 3.32 |  |  |  | 0
Tue |  | 0 | [NAME] | 3.37 |  |  |  | 0
Wed |  | 2000 | [NAME] | 3.26 |  |  |  | 0
Thu |  | 2000 | [NAME] | 3.27 |  |  |  | 0
Fri |  | 0 | [NAME]* |  |  |  |  | 22000
Sat |  |  | [NAME]* |  |  |  |  | 0
Sun |  |  | [NAME]* |  |  |  |  | 0
Mon |  |  | [NAME]* |  |  |  |  | 0
Tue |  |  | [NAME]* |  |  |  |  | 0
Wed |  |  | [NAME]* |  |  |  |  | 0
Thu |  |  | [NAME]* |  |  |  |  | 0
Fri |  |  | [NAME]* |  |  |  |  | 0
Sat |  |  | [NAME]* |  |  |  |  | 0
Sun |  |  | [NAME]* |  |  |  |  | 0
Mon |  |  | [NAME]* |  |  |  |  | 0
Tue |  |  | [NAME]* |  |  |  |  | 0
Wed |  |  | [NAME]* |  |  |  |  | 0
Thu |  |  | [NAME]* |  |  |  |  | 0
Fri |  |  | [NAME]* |  |  |  |  | 0
Sat |  |  | [NAME]* |  |  |  |  | 0
Sun |  |  | [NAME]* |  |  |  |  | 0
Mon |  |  | [NAME]* |  |  |  |  | 0
Tue |  |  | [NAME]* |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  | Sitara deal #1203186
 | **  Estimated Gas Daily Midpoint used for flow date indicated.
Spreadsheet: 848047d1698854911-how-can-i-pick-up-unique-values-in-sumif-test_order_date
Sheet: Sheet1

 |  |  |  |  | Calculated report |  |  |  | How I want it
Order Month | Order No | [NAME] | Delivered |  | Month | Ordered | Delivered |  | Month | Ordered | Delivered
Jan | 1 | 10 | 7 |  | Jan |  |  |  | Jan | 30 | 27
Jan | 2 | 20 | 20 |  | Feb |  |  |  | Feb |  | 3
Feb | 1 | 10 | 3
 | NB The order number appears twice in column B
 | I only want to count the relevant ordsref qty once in col G
Spreadsheet: 21621d1209386046-delete-spaces-test-2
Sheet: Cut List

 |  |  |  |  | 0001 | 0001 |  |  | These are the codes i have in column F
 |  |  |  |  |  | 0140
 |  |  |  |  |  | 0140 |  | F2 | IF(E2="1";K2;IF(E2="2";K2;IF(E2="3";K2;IF(E2="4";K2;IF(E2="5";K2;"")))))
 |  |  |  |  |  | 0140
 |  |  |  |  |  | 0140 |  | F3 | IF(E2="2";K2;IF(E2="3";K2;IF(E2="4";K2;IF(E2="5";K2;""))))
 |  |  |  |  | 0140 | 0140
 |  |  |  |  | 0140 | 0025 |  | F4 | IF(E2="3";K2;IF(E2="4";K2;IF(E2="5";K2;"")))
 |  |  |  |  | 0140 | 0100
 |  |  |  |  | 0140 | 0100 |  | F5 | IF(E2="4";K2;IF(E2="5";K2;""))
 |  |  |  |  | 0140 | 0145
 |  |  |  |  | 0025 | 0145 |  | F6 | IF(E2="5";K2;"")
 |  |  |  |  |  | 0145
 |  |  |  |  |  | 0406
 |  |  |  |  |  | 0411
 |  |  |  |  |  | 0411 |  | As you can see that when it returns the last value in the F column it then returns #
 |  |  |  |  | 0100 | 0411 |  | Num underneath this value in the G Column
 |  |  |  |  | 0100 | 0411
 |  |  |  |  |  | 0715
 |  |  |  |  |  | 0430
 |  |  |  |  |  | 0430
 |  |  |  |  | 0145 | 0165
 |  |  |  |  | 0145
 |  |  |  |  | 0145
 |  |  |  |  | 0406
 |  |  |  |  | 0411
 |  |  |  |  | 0411
 |  |  |  |  | 0411
 |  |  |  |  | 0411
 |  |  |  |  | 0715
 |  |  |  |  | 0430
 |  |  |  |  | 0430
 |  |  |  |  | 0165
Spreadsheet: 730571d1619773354-formula-to-alamgamate-and-edit-payment-project
Sheet: Sheet1

Incorrect Entry:
Date | Code | Status | Paid | Breakdown
2021-04-30 00:00:00 | 12345 | Paid | 100 | Allocated to invoices
 |  |  |  | 86642,86643,86644,
 |  |  |  | on 30/04/21
A formula to create the following:
Date | Code | Status | Paid | Breakdown
2021-04-30 00:00:00 | 12345 | Paid | 100 | Allocated to invoices 86642, 86643, 86644, on 30/04/21
It's to amalgamate all three rows into the first row in column E and to add a space inbetween the 866 numbers.
Spreadsheet: 847442d1698364006-if-sheets-have-cell-with-certain-word-then-copy-those-rows-to-another-sheet-test-kinderheim511-
Sheet: sheet 1

Anything Column A | Anything Column B | Anything Column C | Placehold
Anything A1 | Anything B1 | Anything C1 | PAP99951
Anything A2 | Anything B2 | Anything C2 | PAP5624
Anything A3 | Anything B3 | Anything C3 | PAP5624
Anything A4 | Anything B4 | Anything C4 | PAP47751
Anything A5 | Anything B5 | Anything C5 | PAP47751
Anything A6 | Anything B6 | Anything C6 | TEST | -> row to be copied to sheet AltF4
Anything A7 | Anything B7 | Anything C7 | PAP23658
Anything A8 | Anything B8 | Anything C8 | PAP8845
Anything A9 | Anything B9 | Anything C9 | PAP6654
Anything A10 | Anything B10 | Anything C10 | PAP6654
Anything A11 | Anything B11 | Anything C11 | PAP25226
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Tax

 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  |  |  | Per HC |  | New HC |  | Adjusted Amts | 2002
 |  | YTD Actual |  | Forecast | Plan |  |  |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation |  | 0 |  | 4
 | Analysts & Associates | 0 |  |  | 0 |  |  |  | Other |  |  |  | 4
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 30000
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | Admins | 40000
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 41000
ENATECH | Technology |  |  |  |  |  |  |  | Analysts | 48000
ENATRANS | Transportation |  |  |  |  |  |  |  | Specialist | 52000
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Sr Specialst | 62000
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Managers | 75000
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | 1 | Directors
 |  |  |  |  |  |  |  | 3 | Sr Director
 | Headcount |  |  | 27 | 5 |  |  |  | Vice President | 180000 |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | [NAME] | 260000
 | Analysts & Associate Headcount |  |  | 0
 | Total Headcount |  |  |  |  |  |  |  | Benefits & Taxes |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  | Other Expense Calculation
ENADEPR | Depreciation & Amortization
 | Outside Services | 195340 |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC |  | Exp/New HC
 |  |  |  |  |  |  |  | Also adjusted up to reach a total of $800k.
Spreadsheet: 35285d1232851814-calculating-and-transferring-result-to-other-sheet-excelforumautoupdate
Sheet: Summary Sheet

PromoID | Promo Code | Promo Name | Promo Description | Promo Details | Total Receipts | Total Costs | Total Profit/(Loss)
1
2
3
4
5
6
Spreadsheet: 703521d1605029126-aggregating-values-for-id-with-conditions-sampi
Sheet: Sheet1

ID | VALUE: | BAL: | AGG BAL: | COUNT:
111 | Grass | 100 | 250 | 3
111 | Weed | 50 | 250 | 3
222 | WeedGrass | 25 | 25 | 1
222 |  | 0 | 25 | 1
111 | Grass | 100 | 250 | 3
333 | Grass | 100 | 100 | 1
444 | Weed | 50 | 0 | 0
555 |  | 0 | 0 | 0
Spreadsheet: 300d5a98-f080-474b-b268-34d94a9a183c
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
 | 8731.0 Building Approvals, Australia
 | TABLE 79. Value of Building Approved, Chain Volume Measures, Original - Western Australia
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
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total houses ;  New ; |  |  | Original | A590517J | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total other residential building ;  New ; |  |  | Original | A590518K | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total residential building ;  New ; |  |  | Original | A590519L | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590520W | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590521X | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590522A | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Western Australia ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590523C | 1985-09-01 00:00:00 | 2010-12-01 00:00:00 | 102 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2011
Spreadsheet: 216677d1361845618-commission-calculator-schedules-1
Sheet: Sheet1

Bonus Potential | 62000 | Base %
80% MTM
20% Quarterly
Mth | $ Target | $ Actual | MTD % | YTD Budget | YTD Actuals | YTD % | Base rate | Monthly Payment | Cummulative payment
Jan | 18900 | 14000
Feb | 40400
Mar | 47100
Apr | 64400
May | 58100
Jun | 53100
Jul | 55600
Aug | 51100
Sep | 58987.75510204081
Oct | 56100
Nov | 45651
Dec | 32600
QTR | $ Target | $ Actual | TOTAL $ % Actual | 100% Rate | QTR Payment |  |  | To Go?
QTR 1 |  |  |  | 3100
QTR 2 |  |  |  | 3100
QTR 3 |  |  |  | 3100
QTR 4 |  |  |  | 3100
Totals
a. $62,000 is 100% bonus potential (Assumption based on 10% rates in 2012 vs. 2013 budgets)
b. 80% of Commission is based on YTD result paid out monthly ($49600 into total bonus potential creates commision rate of 8.08%)
c. 20% of Commission is based on QTD result paid out quarterly ($12400)
d. Less than 70% of budget YTD = no commission payable - this can be caught up with YTD model and back paid at standard or accelerated rates
e. Paid at % of full rate if above 70% EG: 81% = 81% of full commission rate
f. Accelerators are built in at above 100%
g. Based on total sales not line item units ($) = each $ sold is worth exactly the same
h. Out of region (state / country) sales will be paid a fixed rate of 10% - are not included in YTD calculations
i. Quarterly bonuses are paid at 100% or better.
j. Any quartely bonuses missed through 2013 will be back paid on completion of 100% of budget or better
YTD % | % of base rate payable?
Less than 70%? | 0
70% to 79% | 0.7
80% to 89% | 0.8
90% to 99% | 0.9
100% to 109% | 1
110% to 119% | 1.1
120% to129% | 1.2
130%+ | 1.3
Spreadsheet: 852586d1702569684-weighted-average-rent-per-square-foot-for-plaza-if-lease-started-after-a-certain-date-working-rent-roll-2
Sheet: Multi-Family OS

 |  |  | Categorization |  | [NAME]
 |  |  |  |  | Income:
 |  |  |  |  | Apartment Income:
 |  |  |  |  | Leased Rental Revenue
 |  |  |  |  | Vacant Rental Revenue | NAP
 |  |  |  |  | Residential Parking
 |  |  |  |  | Other Income (Residential)
 |  |  |  |  | Potential Gross Income
 |  |  |  |  | Vacancy Rate | NAP
 |  |  |  |  | Less Vacancy Loss (Residential)
 |  |  |  |  | Effective Gross Income - Apartments
 |  |  |  |  | Commercial Income:
 |  |  |  |  | Rents in Place
 |  |  |  |  | Stabilized Rent Adjustments | NAP
 |  |  |  |  | Vacant Space at Market Rent | NAP
 |  |  |  |  | Reimbursements
 |  |  |  |  | Commercial Parking
 |  |  |  |  | Other Income (Commercial)
 |  |  |  |  | Potential Gross Income
 |  |  |  |  | Vacancy Factor | NAP
 |  |  |  |  | Less Vacancy Loss (Commercial)
 |  |  |  |  | Effective Gross Income - Commercial
 |  |  |  |  | Total Effective Gross Income
 |  |  |  |  | Expenses
 |  |  |  |  | Real Estate Taxes
 |  |  |  |  | Property Insurance
 |  |  |  |  | Utilities
 |  |  |  |  | Repairs and Maintenance
 |  |  |  |  | [NAME]
 |  |  |  |  | Management Fees
 |  |  |  |  | Payroll & Benefits
 |  |  |  |  | Advertising & Marketing
 |  |  |  |  | Professional Fees
 |  |  |  |  | General and Administrative
 |  |  |  |  | Other Expenses 1
 |  |  |  |  | Other Expenses 2
 |  |  |  |  | Ground Rent
 |  |  |  |  | Reserves
 |  |  |  |  | Total Operating Expenses
 |  |  |  |  | Net Operating Income
 |  |  |  |  | Excluded Income
 |  |  |  |  | Excluded Expense
 |  |  |  |  | Source
 |  |  |  |  | [NAME]
 | Source | 0 | Source
 | [NAME]
Spreadsheet: 103854d1301523230-if-formula-and-vlookup-formula-example
Sheet: Input

 |  |  | 0.75 | Minimum Spacing
 |  |  |  |  |  | [NAME] | 12 | Die Repeat | 16 | 12 x 16 min. sheet size.
size Across | 3 | 0.375 | <--- Gap Across |  |  | Sheet Length | 16 | Number up | 2 | Adjust gap accordingly.
size Around | 7.5 | 8.5 | <--- Gap Around |  |  | # Across | 2 |  |  | See E4 for spacing
Size across | 3.375 |  |  |  |  | # Around | 1 |  |  | requirements.
Repeat | 16 |  | Sheet  Size | 16
No. Across | 2 |  | # Around | 1 |  | Repeat Spacing for D5 on [NAME] |  |  |  | [NAME] | 7.5
No. Around | 2 |  | Excess Scrap | 7.75 |  | [NAME] | # Around | Excess Scrap |  | Min. Gap | 0.75
[NAME] | 12 |  |  |  |  | 16 | 1 | 7.75
Actual Web Width | 7.4375 |  |  |  |  | 16 | 1 | 0
 |  |  |  |  |  | 16.5 | 2 | 0
 |  |  |  |  |  | 24.75 | 3 | 0
* minimum sheet size of 16" |  |  |  |  |  | 33 | 4 | 0
* minimum gap between images .75" but gap around (cell in green adjusts by best fit)
* maximum sheet size 20" |  |  |  |  |  | Excess Scrap | # Around | [NAME]
* cell in purple changes from item by item |  |  |  |  |  | 7.75 | 1 | 16
* cells in orange were taken from a similar model to figure the correct # around with least amount of excess scrap |  |  |  |  |  | 0 | 1 | 16
* cells in red summarize the best option from orange cells |  |  |  |  |  | 0 | 2 | 16.5
 |  |  |  |  |  | 0 | 3 | 16.5
EXAMPLES |  |  |  |  |  | 0 | 4 | 16.5
item with length of 4" + .75" gap would best fit on 19" overall sheet having 4 images on sheet
(4"+.75)*4 = 19
item with length of 7" would best fit on 16" sheet with adjusting gap to 1" having 2 images per sheet
(7"+1")*2 = 16"
item with length of 7.5" would best fit on 16.5" sheet with gap of .75" having 2 images per sheet
(7.5"+.75")*2 = 16.5"
item with length of 11" would best fit on 16" sheet with adjusting gap to 5" having 1 image per sheet
(11"+5") = 16"
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 9-110

 |  |  |  |  |  |  |  | 9-110
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 0f15d42a-8d2b-41c7-8bf7-bf7531773cce
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Retained Surgical Items
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Deep Vein Thrombosis
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sterilization
1. FACILITY CONTACT INFORMATION
 |  |  | Facility Name:
 |  |  | Contact Name*: |  |  |  | Title:
 |  |  | Address 1*:
 |  |  | Address 2*:
 |  |  | City*: |  |  |  | State*: |  | Zip Code*:
 |  |  | E-Mail: |  |  |  | Phone:
 |  |  | Facility External IP Address for eSubscription Access:
 |  |  | *will also be used for mailing of CDs
2. MEMBERSHIP SELECTION
 | Package Type: |  | [     ]    New Membership Package
 |  |  | [     ]    Renewal of Membership Package
 | Package Pricing: |  | 100 + Nurses = $98/nurse
 |  |  | 75 - 99 Nurses = $104/nurse
 |  |  | 50 - 74 nurses = $109/nurse
 |  |  | 20 - 49 Nurses = $114/nurse
 | Number of Nurses in Package:
 | Total Payment ($):
 | Payment Method: |  | [     ]    Check | [     ]    Credit Card
 |  |  | To pay by credit card, please complete the following information:
 |  |  | Credit Card Type:
 |  |  | Expiration Date:
 |  |  | Card Number:
 |  |  | Name on Card:
 | Please send (1) full payment, along with your completed Membership Application Form and Facility Roster (with changes, additions, deletions) to:
 |  | AORN Customer Service
 |  | 2170 South Parker Road, [NAME] 400 |  |  | Questions?
 |  | Denver, CO 80231 |  |  | Call (800) 755-2676, or (303) 755-6300
 |  | Fax: (303) 750-3212 |  |  | extension 218
 |  | or
 |  | Email: [EMAIL]
3. MEMBERSHIP ROSTER
 |  |  | (Please provide your facility membership roster.  Existing facility members may make changes, additions, and deletions to their roster at any time)
 |  |  |  | *Members will be able to select Specialty Assemblies after receiving member card
No. | Delete | Chapter Membership Included (Mark with "N" if otping out  and reduce price by $20/member opting out of chapter affiliation) | First Name | Last Name | [NAME] | Title | Credentials | Home Address | City | State | Zip
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
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
Spreadsheet: 108530d1305587055-how-to-refer-to-the-formula-not-the-result-of-the-formula-typed-in-another-cell-data-and-summaryexample
Sheet: SUMMARY

 |  | don't want: |  |  |  | I want this:
 |  |  |  |  |  |  | …. Etc.
Spreadsheet: 50133d1249524414-sorting-data-into-columns-book1a
Sheet: Sheet1

EO |  | NAME | Time | AR | BB | BJ | EG | PK | PS | FS
 | 1 | [NAME] |  | Ar | Bj | Bb | Eg | PK
 | 2 | [NAME] |  | Ar | Bj | Pk
 | 3 | Mark |  | BJ |  | Pk
 | 4 | [NAME] |  | BJ | Bb | Pk
 | 5 | [NAME] |  | Ar | Bj | Bb | Eg |  |  | Fs
 | 6 | Sue |  | [NAME] | NBb
 | 7
 | 8
 | 9
 | 10
Spreadsheet: 86390d1286381606-trendlines-in-two-separate-intervals-dummy
Sheet: Sheet1

 |  | temp | elong
 |  | 33
 |  | 34
 |  | 35
 |  | 36
 |  | 37
 |  | 38
 |  | 39
 |  | 40
 |  | 41
 |  | 42
 |  | 43
Spreadsheet: af13d06f-34cc-422c-8942-7055fb05eb24
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Curb Records | 715187921726 | [NAME] | Your Great Name | 2011-03-01 | Distributed CD Trax | Ac | 9.99 | N | To Be Retired
Curb Records | 715187333222 | [NAME] | Our Hope Endures | 2008-02-12 | Distributed CD Trax | Ac | 9.99 | N | To Be Retired
Curb Records | 715187333123 | [NAME] | In Better Hands | 2008-02-12 | Distributed CD Trax | Ac | 9.99 | N | To Be Retired
Spreadsheet: 853264d1703153679-tiered-pricing-formula-book2
Sheet: Sheet1

 | From | To | Rate
0-100k | 0 | 100000 | 0.04 | original | 500000
100-500k | 100000 | 500000 | 0.03 | add-on | 100000
500-750k | 500000 | 750000 | 0.02
750-1m | 750000 | 1000000 | 0.01