tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: drew_fossum__8694__Scott exp 01-11-01
Sheet: Travel Form

Employee Expense Report
Travel Expense Summary |  |  |  |  |  |  |  |  |  |  |  | Page
LAST NAME |  |  |  | FIRST NAME, INITIAL |  |  | TITLE |  |  | EMPLOYEE NUMBER
TRAVEL EXPENSE - Enter all transportation and lodging expenses by receipt total (airline tickets, rental car receipts, taxis, hotel, tips, personal mileage, etc.).  Exclude meals and entertainment.
Designate type of transportation used: B = Bus,  C = Cab, P = Plane,  PC = Personal Car,  CC = Company Car, RC = Rental Car, T = Train.
Assign a reference symbol for each accounting classification to be used.  Charges to be allocated do not require a reference symbol.
REF | Date |  |  | Location and Business Purpose |  |  |  |  |  |  | Type | Cost/Miles | Rate | $ [NAME]
1 | 1/8/01-1/9/01 | Airfare:  Round trip Houston to Washington, DC for FERC meeting |  |  |  |  |  |  |  |  | P | 1507.61
1 | 2001-01-08 00:00:00 | Hotel:  [NAME], Washington, DC for FERC meeting |  |  |  |  |  |  |  |  |  | 354.95
1 | 1/8/01-1/9/01 | Parking:  Parking at IAH re: above |  |  |  |  |  |  |  |  | PC | 20
1 | 1/8/01-1/9/01 | Mileage:  to/from IAH re: above (2001 rate is 34.5 cents/mile) |  |  |  |  |  |  |  |  | PC | 60 | 0.345
1 | 10/3-10/4/00 | Mileage:  to/from IAH re: FERC meeting on 10/4/00 (2000 rate was 32.5 cents/mile) |  |  |  |  |  |  |  |  | PC | 60 | 0.325
1 | 10/30-10/31/00 | Mileage:  to/from IAH re: PG&E meeting on 10/31/00 (2000 rate was 32.5 cents/mile) |  |  |  |  |  |  |  |  | PC | 60 | 0.325
 |  |  |  |  | Expense allocation |  |  |  | Allocated amount: |  |  | TOTAL
 |  |  |  |  | Enter an allocation factor next to each account receiving allocated |  |  |  |  | Total travel expense must be shown on Page 1,
 |  |  |  |  | charges.  Lines not assigned an allocation factor will not |  |  |  |  | Employee Expense Report Short Form.
 |  |  |  |  | receive an allocation; lines without a REF code will be allocated.
 |  |  |  |  | The total of all allocation factors must equal 1.
ACCOUNT [NAME]
Show the total amount for each accounting classification referenced above.
REF | GL Acct      Asset | GL Co Trd Ptr |  | Cost Center                  WBS Element |  |  | Order                                      Network |  | Material       Activity | Plant                      Func Area | ALLOC FACTOR |  |  | Amount
1 | 52004500 | 0366 | 111679
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 127388d1320331823-function-contains-an-error-i-cannot-see-simplified-workbook
Sheet: Sheet1

 |  | WHERE THE FUNCTION IS  TO BE ENTERED
 |  | THE CELLS UPON WHICH THE FUNCTION IS DEPENDANT
 | TARIFF TYPE | STANDARD |  |  |  |  |  | BLOCK1 THRESHOLD | TARIFF LIMITATION
 |  |  |  |  |  |  |  |  | LOWER | UPPER
 | Billing Period | Days in Period | MIC | 15 |  |  | GP
 | BIMONTHLY I |  | Day Units | Night Units | Total Units |  | gp(1)
 | Jan/Feb | 59 | 10 | 10 | 20 |  | gp(2)
 | Mar/Apr | 61 | 10 | 10 | 20 |  | gp(3)
 | May/Jun | 61 | 10 | 10 | 20 |  | gp(4)
 | Jul/Aug | 62 | 10 | 10 | 20
 | Sep/Oct | 61 | 10 | 10 | 20
 | Nov/Dec | 61 | 10 | 10 | 20
 | TOTAL | 365 | 60 | 60 | 120
 | STANDING CHARGE | MIC | DAY UNITS | DAY UNITS (2) | NIGHT UNITS | STD CHRG | PSO LEVEY | DAY UNITS | DAY UNITS (2) | NIGHT UNITS | TOTAL
GP | 0.451 | 10 | 10 | 10 |  | 164.615 |  |  |  |  | 164.615
gp(1) | 10 | 10 | 10 | 10 |  |  |  |  |  |  | 0
gp(2) | 10 | 10 | 10 | 10 |  |  |  |  |  |  | 0
gp(3) | 10 | 10 | 10 | 10 |  |  |  |  |  |  | 0
gp(4) | 10 | 10 | 10 | 10 |  |  |  |  |  |  | 0
 |  | BIMONTHLY I
 |  | BIMONTHLY II
 |  | Jan/Feb | 59
 |  | Mar/Apr | 61
 |  | May/Jun | 61
 |  | Jul/Aug | 62
 |  | Sep/Oct | 61
 |  | Nov/Dec | 61
 |  | Dec/Jan | 62
 |  | Feb/Mar | 59
 |  | Apr/May | 61
 |  | Jun/Jul | 61
 |  | Aug/Sept | 61
 |  | Oct/Nov | 61
 |  | STANDARD
 |  | NIGHTSAVER
Spreadsheet: 0a68e6f1-ec05-4244-bddd-ee5ddba52258
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
 | 6202.0 Labour Force, Australia
 | Table 11. Labour force status by Sex - Australian Capital Territory - Trend and Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Employed - full-time ;  [NAME] ; |  |  | Trend | A184182L | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Employed - full-time ;  Females ; |  |  | Trend | A184199J | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Employed - full-time ;  Persons ; |  |  | Trend | A184216X | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Employed - total ;  [NAME] ; |  |  | Trend | A184184T | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Employed - total ;  Females ; |  |  | Trend | A184201J | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Employed - total ;  Persons ; |  |  | Trend | A184218C | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Unemployed - total ;  [NAME] ; |  |  | Trend | A184187X | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Unemployed - total ;  Females ; |  |  | Trend | A184204R | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Unemployed - total ;  Persons ; |  |  | Trend | A184221T | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Unemployment rate ;  [NAME] ; |  |  | Trend | A184194W | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | Percent | PERCENT | Month | 1
Unemployment rate ;  Females ; |  |  | Trend | A184211L | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | Percent | PERCENT | Month | 1
Unemployment rate ;  Persons ; |  |  | Trend | A184228J | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | Percent | PERCENT | Month | 1
Participation rate ;  [NAME] ; |  |  | Trend | A184193V | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | Percent | PERCENT | Month | 1
Participation rate ;  Females ; |  |  | Trend | A184210K | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | Percent | PERCENT | Month | 1
Participation rate ;  Persons ; |  |  | Trend | A184227F | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | Percent | PERCENT | Month | 1
Civilian population ;  [NAME] ; |  |  | Original | A163537W | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Civilian population ;  Females ; |  |  | Original | A163554X | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
Civilian population ;  Persons ; |  |  | Original | A163571A | 1978-02-01 00:00:00 | 2009-10-01 00:00:00 | 381 | 000 | STOCK | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 0a39ef43-c72c-4cea-b2b8-b617c529d15a
Sheet: Misc

 | [NAME]
UOM | [NAME] | PART NUMBER | PRICE
EA | Coupler Fitting LD5 | CF5EI | 1.27
EA | Right Angle Fitting LD5 | RAF5EI | 1.27
EA | Inside Corner Fitting LD5 | ICF5EI | 1.27
EA | Outside Corner Fitting LD5 | OCF5EI | 1.27
EA | End Cap Fitting LD5 | ECF5EI | 1.27
EA | Drop Ceiling/Entrance Fitting LD5 | DCF5EI | 1.79
EA | [NAME] LD10 to LD5 | RF5EI | 1.27
EA | Tee Fitting LD5 | TF5EI | 1.27
EA | LD5 Surface Raceway 6ft (per stick) | LD5EI6-A | 12.12
EA | LD5 Surface Raceway 8ft (per stick) | LD5EI8-A | 16.17
EA | Surface Mount Box | 1-558251-1 | 6
EA | Shallow Surface Mount Box | JB1EI-A | 4.06
EA | Coupler Fitting LD5 | CF5EI | 1.27
EA | Right Angle Fitting LD5 | RAF5EI | 1.27
EA | Inside Corner Fitting LD5 | ICF5EI | 1.27
EA | Outside Corner Fitting LD5 | OCF5EI | 1.27
EA | End Cap Fitting LD5 | ECF5EI | 1.27
EA | Drop Ceiling/Entrance Fitting LD5 | DCF5EI | 1.27
EA | [NAME] LD10 to LD5 | RAF5EI | 1.27
EA | Tee Fitting LD5 | TF5EI | 1.27
EA | LD5 Surface Raceway 6ft (per stick) | LD5EI6-A | 12.12
EA | LD5 Surface Raceway 8ft (per stick) | LD5EI8-A | 16.17
EA | Surface Mount Box (deep) | [NAME] | 6.36
EA | Shallow Surface Mount Box | 558251-3 | 6
EA | Coupler Fitting LD10 | CF10EI | 1.31
EA | Right Angle Fitting LD10 | RAF10EI | 1.31
EA | Inside Corner Fitting LD10 | ICF10EI | 1.31
EA | Outside Corner Fitting LD10 | OCF10EI | 1.31
EA | End [NAME] LD10 | ECF10EI | 1.31
EA | Drop Ceiling/Entrance Fitting LD10 | DCF10EI | 1.79
EA | Tee Fitting LD10 | TF10EI | 2.57
EA | LD10 Surface Raceway 6ft (per stick) | LD10EI6 | 16.68
EA | Surface Mount Box | 1-558251-1 | 6
EA | Coupler Fitting LD10 | CF10IW | 1.31
EA | Right Angle Fitting LD10 | RAF10IW | 1.31
EA | Inside Corner Fitting LD10 | ICF10IW | 1.31
EA | Outside Corner Fitting LD10 | OCF10IW | 1.31
EA | End [NAME] LD10 | ECF10IW | 1.31
EA | Drop Ceiling/Entrance Fitting LD10 | DCF10IW | 1.69
EA | LD10 Surface Raceway 6ft (per stick) | LD10IW6 | 16.68
EA | Surface Mount Box | 558251-3 | 6
Spreadsheet: john_forney__15527__september11annuity
Sheet: Sheet1

 |  |  | September 11th P&L Calc
 |  |  |  |  |  | [NAME]
 |  |  | [NAME].Sale |  | Ercot MCP | revenue | TXU RT sale | TXU Price | TXU RT sale 2 | TXU Price | Constell. Sale | Price | Stec | Price | Stec | Price
 | HE 7 |  | 210 |  | -243.81
 | HE 8 |  | 210 |  | 7.28
 | HE 9 |  | 210 |  | 7.25
 | HE 10 |  | 110 |  | 10.35 |  | 100 | 20
 | HE 11 |  | 60 |  | 9.75 |  | 100 | 20 |  |  | 50 | 19
 | HE 12 |  | 45 |  | 13.45 |  | 100 | 20 |  |  | 50 | 19 | 15 | 17
 | HE 13 |  | 45 |  | 13.72 |  | 100 | 20 |  |  | 50 | 19 | 15 | 17
 | HE 14 |  | 5 |  | 19.2 |  | 100 | 20 | 30 | 20 | 50 | 19 |  |  | 30 | 19
 | HE 15 |  | 5 |  | 13.52 |  | 100 | 20 | 30 | 20 | 50 | 19 |  |  | 30 | 19
 | HE 16 |  | 5 |  | 21.37 |  | 100 | 20 | 30 | 20 | 50 | 19 |  |  | 30 | 19
 | HE 17 |  | 5 |  | 18.51 |  | 100 | 20 | 30 | 20 | 50 | 19 |  |  | 30 | 19
 | HE 18 |  | 5 |  | 14.13 |  | 100 | 20 | 30 | 20 | 50 | 19 |  |  | 30 | 19
 | HE 19 |  | 5 |  | 13.5 |  | 100 | 20 | 30 | 20 | 50 | 19 |  |  | 30 | 19
 | HE 20 |  | 5 |  | 17.93 |  | 100 | 20 | 30 | 20 | 50 | 19 |  |  | 30 | 19
 | HE 21 |  | 5 |  | 14.8 |  | 100 | 20 | 30 | 20 | 50 | 19 |  |  | 30 | 19
 | HE 22 |  | 5 |  | 14.3 |  | 100 | 20 | 30 | 20 | 50 | 19 |  |  | 30 | 19
 |  |  |  |  |  |  |  |  |  |  |  | Desk Loss Calc
 |  |  |  |  |  |  |  |  |  |  |  | Net Revenue for trading activities
 |  |  |  |  |  |  |  |  |  |  |  | Assumed Power expense
 | Hours ending 14-22 originally booked to ST Ercot.   Changed to [NAME] (need to w/hold $736.20 from annuity)
 | Dailies remained marked at $21.50
 | Annuity #774083 dated 9/12,   grants ST  Ercot $67530.15 from [NAME] book |  |  |  |  |  |  |  |  |  |  | Revenue if full Imbalance
 |  |  |  |  |  |  |  |  |  |  |  | Assumed Power expense
Spreadsheet: 32046d1228167949-compilation-work-sheet-excel-forum-leger-balance
Sheet: ABC Supply

Date | Qty | Description | Cost | Amount | Credits | Balance
2008-01-05 00:00:00 | 2 | Flashlight Batteries | 1 | 2 |  | 2
2008-01-09 00:00:00 | 6 | Eggs (Dozen) | 1.69 | 10.14 |  | 12.14
2008-01-12 00:00:00 | 1 | Staples (cs) | 6 | 6 |  | 18.14
2008-01-14 00:00:00 |  |  |  |  | 12 | 6.140000000000001
Spreadsheet: 34106d1231237756-complicated-ques-cross-referencing-data-in-sheets-copy-of-test
Sheet: DETAILS

 | Date | Prod Code | Part Number | Barcodes | Result
 | 2009-01-01 00:00:00 | LIONXX | 11111 | LIONXX12345 | P
 | 2009-01-01 00:00:00 | LIONXX | 11111 | LIONXX23456 | P
 | 2009-01-01 00:00:00 | LIONXX | 11111 | LIONXX34567 | P
 | 2009-01-01 00:00:00 | LIONXX | 11111 | LIONXX45678 | F
 | 2009-01-01 00:00:00 | LIONXX | 11111 | LIONXX56789 | P
 | 2009-01-02 00:00:00 | TIGERYY | 22222 | TIGERYY78990 | F
 | 2009-01-02 00:00:00 | TIGERYY | 22222 | TIGERYY89012 | F
 | 2009-01-02 00:00:00 | TIGERYY | 22222 | TIGERYY45632 | P
 | 2009-01-02 00:00:00 | TIGERYY | 22222 | TIGERYY15461 | P
 | 2009-01-02 00:00:00 | TIGERYY | 22222 | TIGERYY56564 | P
 | 2009-01-02 00:00:00 | TIGERYY | 22222 | TIGERYY67894 | P
 | 2009-01-02 00:00:00 | TIGERYY | 22222 | TIGERYY45612 | P
 | 2009-01-03 00:00:00 | PANTHERZZ | 33333 | PANTHERZZ12346 | P
 | 2009-01-03 00:00:00 | PANTHERZZ | 33333 | PANTHERZZ56784 | P
Spreadsheet: 188066d1350668242-get-data-from-another-workbook-to-a-summary-workbook-copy-of-data-for-intercompany-workings-tiernan
Sheet: Ark1

Cash pool Intr  CN
CN
 |  | I nov | I des
7695000000 | SEB | 242309 | 474
 | DNB
 | Mot CNR
 | Mot CSS
 | Totalt interne renter i november
 | Rapportert pr oktober | 3320862.71
 | [NAME] pr November
6695000000 | SEB | 2.17
 | DNB
 | Mot CNR
 | Mot CSS
 | Totalt interne renter i november
 | Rapportert pr oktober | 2762537.46
 | [NAME] pr November
912008 | CP renteinntekter
 | Bokf før omkl | 4578046
 | Omkl til  912200
940008 | CP Rentekostnader
 | Bokf før omkl | 3969824
 | Omkl til  940400
Spreadsheet: 678580d1589968104-matching-with-variable-identifier-kind-of-test-book-copy
Sheet: Sheet2

First name | surname | Postcode | Postcode identifier | Region code
[NAME] | Simpson | BH243FD | (wanting to find this out from postcode (Col C), see region codes for indentifiers) | If we can find the indentifier, then we can use VLOOKUP to find the region code
[NAME] | Bloggs | [NAME]
[NAME] | [NAME] | SP61JM
[NAME] | Thomspon | SP62IK
[NAME] | Wilks | SP63WQ
[NAME] | [NAME] | BH255WE
[NAME] | Bloggs | BH256DF
[NAME] | Test | BH257SM
[NAME] | Simpson | BL00YN
[NAME] | Bloggs | BL09QD
[NAME] | [NAME] | BL11YX
[NAME] | Thomspon | BL12EF
[NAME] | Wilks | BL13AK
[NAME] | [NAME] | NP444YS
[NAME] | Bloggs | NP445SB
[NAME] | Test | NP446WF
[NAME] | Simpson | NP447AI
[NAME] | Bloggs | NP448QR
[NAME] | [NAME] | NR11AX
[NAME] | Thomspon | NR12AO
[NAME] | Wilks | NR13AT
[NAME] | [NAME] | NR14RZ
[NAME] | Bloggs | NR21HA
Spreadsheet: 772610d1647396590-how-to-calculate-time-spend-on-a-task-wavingdatetime_update-fmessier-
Sheet: Work day & Break time

 | Work Day |  | Break |  | Dinner |  | Break
Team | Start | End | Start | End | Start | End | Start | End
1 | 07:00:00 | 15:00:00 | 09:00:00 | 09:15:00 | 11:00:00 | 11:30:00 | 13:00:00 | 13:15:00
2 | 07:00:00 | 15:00:00 | 09:15:00 | 09:30:00 | 11:30:00 | 12:00:00 | 13:15:00 | 13:30:00
2 | 07:00:00 | 15:00:00 | 09:30:00 | 09:45:00 | 12:00:00 | 12:30:00 | 13:30:00 | 13:45:00
3 | 07:00:00 | 15:00:00 | 09:45:00 | 10:00:00 | 12:30:00 | 13:00:00 | 13:45:00 | 14:00:00
Spreadsheet: 675741d1588448995-excel-formula-for-finding-text-result-in-the-row-working
Sheet: slot

 |  |  | 1
Spreadsheet: darrell_schoolcraft__7321__imball0202
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 | -52788 | -23691
9238 | -12171 | -12000 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
56422 | -1150137 | -968201
58710 | -4942 | -31229
60921 | -901467 | -1050599
78026 |  | 6600
500084 | -28214 | -36000
500085 | -3589
500097 | -45877 | -50961
INDEX
2002-01-31 00:00:00 |  |  | 835344.24
2002-02-12 00:00:00
CBS Volume
 |  |  | 340221
Spreadsheet: 871969d1718347636-need-help-on-formula-book22-2-aligw
Sheet: Result

Date | Jun | July | Aug | Sep | Nov |  |  | dd
1 |  |  |  |  |  |  |  | 1,4,5,7,10,11 July 9,12,16,23 Aug
2 |  |  |  |  |  |  |  | 1,6,8,9,10,11,15,16,18,20,22,23,24,25,28 Aug
3 |  |  |  |  |  |  |  | 10,15 Aug
4 |  |  |  |  |  |  |  | 12,14,15,20,23 Aug
5 |  |  |  |  |  |  |  | [NAME] 7,14,21,28 July 7,8,11,18,22,23,24,25 Aug 17 Sep
6 |  |  |  |  |  |  |  | 14,15,16 July 4,5,8,7,9,14,15,18,20,23,25 Aug
7 |  |  |  |  |  |  |  | 14,15,16,20,21,22, 23, [NAME] 1,11 July
8 |  |  |  |  |  |  |  | 14,15,16,21,26 July 1,2,5,6,7,8,9,11,14,15,16,18,21,22,23,25,28 Aug
9 |  |  |  |  |  |  |  | 14,18,20,22,23,27,29,30 Jun 1 July 28 Aug
10 |  |  |  |  |  |  |  | 15,23 Aug
11 |  |  |  |  |  |  |  | 2,3,7,8,9,10,11,15,17,18,19,22,23,25,27 Aug
12 |  |  |  |  |  |  |  | 2,9,10,11,15,17,18,19,22,23,24 Aug
13 |  |  |  |  |  |  |  | 20,21,25,26,29 Aug
14 |  |  |  |  |  |  |  | 20,23,24,25,26,27,28,30 Jun 1,2,11,21,28 July 8,9,10,11,13,17,19,22,23,25,26,28,29,30 Aug
15 |  |  |  |  |  |  |  | 22 Jun 11,18,22,23,24,25,26,28 Aug 8,10,17 Nov
16 |  |  |  |  |  |  |  | 23 jun
17 |  |  |  |  |  |  |  | 25 Jun 11,21 July 7,11,13,23,26 Aug
18 |  |  |  |  |  |  |  | 3,4,5,7,8,11,12,14,15,16,17,18,19,22,23,24,28,29 Aug
19 |  |  |  |  |  |  |  | 3,9 July 9,10,11,13,15,18,19,22,23 Aug
20 |  |  |  |  |  |  |  | 4,5,10,14,22 Aug
21 |  |  |  |  |  |  |  | 4,5,6,15,16,17,18,19,20,21,22,24,25,26,27,28,29 Aug
22 |  |  |  |  |  |  |  | 4,7,11,13,16,18,23 July 5,7,8,12,16,18,22,23,24,28 Aug
23 |  |  |  |  |  |  |  | 7,8,9,10,11,12,13,14,15,16,17,19,20,21,22,23,24,26,27,28 Aug 3,4,5 Sep
24
25
26
27
28
29
30
Spreadsheet: a28c885a-35c2-44b9-b762-82795b20bc0b
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
[NAME] | Test | [NAME] | [NAME], Known Mutation | [NAME], [NAME] | Polymerase Chain Reaction (PCR)/DNA Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA OR Yellow-Top (ACD) Tube: ACD OR |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL	 Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:	 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Wednesday; 10 a.m. | 10 days | 16 days | 1 | 81403 |  |  |  |  | Rochester
[NAME] | [NAME] | VARIES | Varies |  |  |  | Ambient
[NAME] | Result | 23432 | [NAME] | [NAME] | Alphanumeric
[NAME] | Result | 23433 | [NAME] | [NAME] | Alphanumeric
[NAME] | Result | 23434 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
[NAME] | Result | 23435 | Order Date | Order Date | Alphanumeric
[NAME] | Result | 23436 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
[NAME] | Result | 23437 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
[NAME] | Result | 23438 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | 23439 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
[NAME] | Result | 23440 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | 23441 | Reviewed By: | Reviewed By: | Alphanumeric
[NAME] | Result | 23442 | Release Date | Release Date | Alphanumeric
Spreadsheet: 86659d1286583779-excel-2008-color-of-the-selecting-box-copy-of-test-pages
Sheet: tax rates

 |  | Income | 100000
 |  |  |  | Income | Tax | Medicare | Total tax | Tax | Nett
Tax Year | 2006 | to | 2007 | 100000 | 27848.6 | 1500 | 29348.6 | 29348.6 | 70651.4 | method one; vlookup
 |  |  |  | 100000 | 27848.6 | 1500 | 29348.6 | 29348.6 | 70651.4 | method two; If
 | 0 | To | 6000 | 0 | Plus | 0 | Over | 0
 | 6001 | To | 25000 | 0 | Plus | 0.15 | Over | 6001
 | 25001 | To | 75000 | 2850 | Plus | 0.3 | Over | 25001
 | 75001 | To | 150000 | 17849 | Plus | 0.4 | Over | 75001
 | 150001 | And | Over | 47848 | Plus | 0.45 | Over | 150001
 |  | 0.4 | find top percentage rate to suit income
 |  |  | w
 |  |  | 3
 |  |  | w | w
 |  |  | s | f
 |  |  | f | r
 |  |  | g | a
 |  |  | w
Spreadsheet: 679050d1590164004-comparing-two-vlookup-results-new-microsoft-excel-worksheet
Sheet: Sheet1

 |  |  | [NAME] | 350 |  |  | Carol | 7500
 |  |  | [NAME] | 1350 |  |  | [NAME] | 900
 |  |  | [NAME] | 850 |  |  | [NAME] | 1350
 |  |  | Carol | 7000 |  |  | [NAME] | 350
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Carol
 |  |  | [NAME]
Spreadsheet: 62559d1263481654-auto-insert-a-row-with-info-populated-from-the-row-above-book1
Sheet: Sheet1

Stock | QTY |  | Sold To | QTY Sold
Pens | 10000 |  | Customer 1 | 1000 |  | Need button or something to insert a row below pens but above pencils
Pencils | 10000 |  | not sold
e.g
Stock | QTY |  | Sold To | QTY Sold
Pens | 10000 |  | Customer 1 | 1000
pens | 9000
Pencils | 10000 |  | not sold | 0
Spreadsheet: 680978d1591283692-functions-to-link-data-over-multiple-sheets-excel-forum-example-kanga-azz-
Sheet: February

 |  |  |  |  |  |  |  |  |  |  | Item Used |  | Amount
 |  |  |  |  |  |  |  |  |  |  | Data 1 |  | 1 |  |  |  | Data 1
 |  |  |  |  |  |  |  |  |  |  | Data 2 |  | 6 |  |  |  | Data 2
 |  |  |  |  |  |  |  |  |  |  | Data 5 |  | 7 |  |  |  | Data 3
 |  |  |  |  |  |  |  |  |  |  | Data 9 |  | 9 |  |  |  | Data 4
 |  |  |  |  |  |  |  |  |  |  | Data 7 |  | 5 |  |  |  | Data 5
 |  |  |  |  |  |  |  |  |  |  | Data 8 |  | 2 |  |  |  | Data 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 10
Spreadsheet: 727503d1617913266-calculating-elapsed-time-between-two-dates-and-times-date-and-time-calculations
Sheet: Zanker Alarm Log

Date Occured | Time Occurred | Date Detected | Time Detected | Duration
2021-03-15 00:00:00 | 00:28:00 | 2021-03-15 00:00:00 | 07:00:00
2021-03-15 00:00:00 | 22:33:00 | 2021-03-16 00:00:00 | 07:00:00
2021-03-19 00:00:00 | 00:27:00 | 2021-03-22 00:00:00 | 07:00:00
2021-04-01 00:00:00 | 15:01:00 | 2021-04-05 00:00:00 | 07:00:00
Spreadsheet: 756138d1637302958-can-i-dynamically-reference-the-same-cell-across-multiple-worksheets-in-if-and-textjoin-therapists-availability2-copy
Sheet: Master

JobA | [NAME] | JobC | JobD |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
Person1 | Person11 | Person31 | Person41 |  | 07:30:00
Person2 | Person12 | Person32 |  |  | 08:15:00
Person3 | [NAME] | Person33 |  |  | 09:00:00
Person4 | Person14 | Person34 |  |  | 09:45:00
Person5 |  | Person35 |  |  | 10:30:00
Person6 |  | Person36 |  |  | 11:15:00
Person7 |  | Person37 |  |  | 12:00:00
Person8 |  |  |  |  | 01:00:00
Person9 |  |  |  |  | 01:45:00
Person10 |  |  |  |  | 02:30:00
 |  |  |  |  | 03:15:00
 |  |  |  |  | 04:00:00
 |  |  |  |  | 04:45:00
 |  |  |  |  | 05:30:00
Spreadsheet: 705560d1606196826-formul-to-compute-average-and-no-of-years-up-to-last-item-in-col-compute-average-and-count-up-to-last-item
Sheet: Sheet1

Date | Bank Interest rate
2018-09-01 00:00:00 | 5.75 |  |  | Average Interest
 | 5.75 |  |  | No of years
 | 5.75
 | 5.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6
 | 6
 | 6
 | 6
 | 6.25
 | 6.25
 | 6.75
 | 6.75
 | 6.75
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 7
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.75
 | 6.5
 | 6.5
 | 6.5
 | 6.5
 | 6.5
 | 6.5
 | 6.5
 | 0.065
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675
 | 0.0675