tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b6111812-4c23-4725-b92e-cbf0bb043c64
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
MA24 | Test | MA24 | Microalbuminuria, 24 Hour, [NAME] | Microalbuminuria, 24 Hr, U | Immunoturbidity | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. No preservative. 3. Mix well before taking 5-mL aliquot. Additional Information: 1. 24-Hour volume is required. 2. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	Preferred Refrigerated	Yes Frozen	Yes 6N HCl	No 50% Acetic Acid	No Na2CO3	No Toluene	Yes 6N HNO3	No Boric Acid	Yes Thymol	Yes | 1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 24-Hour excretion: <30 mg/24 hours Excretion rate: <20 mcg/min | Monday through Sunday; Continuously | 1 day | Same day/1 day | 1 | 82043 |  |  |  |  | Rochester
MA24 | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
MA24 | Order Question | TM43 | Collection Duration |  | Plain Text
MA24 | Order Question | VL41 | [NAME] |  | Plain Text
MA24 | Result | MI24H | Microalbuminuria, 24 Hr, U | Microalbuminuria, 24 Hr, U | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14956-7 | Albumin:MRat:24H:[NAME]:Qn:Detection limit = 20 mg/L
MA24 | Result | 24HEX | 24 Hour Excretion | 24 Hour Excretion | Numeric |  |  |  |  | mg/24 h |  |  |  |  |  |  |  |  |  | 14956-7 | Albumin:MRat:24H:[NAME]:Qn:Detection limit = 20 mg/L
MA24 | Result | VL41 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 19153-6 | [NAME] volume:Vol:XXX:[NAME]:Qn:
MA24 | Result | TM43 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9 | Collection duration:Time:*:Urine:Qn:
MA24 | Result | [NAME] | [NAME] | [NAME] | Numeric |  |  |  |  | mcg/min |  |  |  |  |  |  |  |  |  | 14956-7 | Albumin:MRat:24H:[NAME]:Qn:Detection limit = 20 mg/L
MA24 | Result | CONC3 | Concentration | Concentration | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 30003-8 | Albumin:MCnc:24H:[NAME]:Qn:Detection limit <= 20 mg/L
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: ONA

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
ON AE BLUE LEM 12/12Z CN | 09213
ON AE GRAPE 12/12Z CN | 09214
ON AE MANGO PI 12/12Z CN | 09215
ON AE ORANGE 12/12Z CN | 09503
ON AE PEACH BE 12/12Z CN | 09237
ON AE STRAWBER 12/12Z CN | 09216
ON AE WATERMEL 12/12Z CN | 09217
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
ON AE BLUE LEM 12/12Z CN | 09213
ON AE GRAPE 12/12Z CN | 09214
ON AE MANGO PI 12/12Z CN | 09215
ON AE ORANGE 12/12Z CN | 09503
ON AE PEACH BE 12/12Z CN | 09237
ON AE STRAWBER 12/12Z CN | 09216
ON AE WATERMEL 12/12Z CN | 09217
Spreadsheet: 154996d1336645710-lookup-find-value-with-multiple-criteria-from-multiple-named-ranges-tables-example
Sheet: Eg

 | Example 1 |  |  |  |  |  |  | Example 2
 | Item | Apple | (selects which table) |  |  |  |  | Item | Orange
 | Type | a | (selects row) |  |  |  |  | Type | b
 | U/L/V | Lower | (sub selects row) |  |  |  |  | U/L/V | upper
 | Quantity | 450 | (selects column) |  |  |  |  | Quantity | 642
 | Apple
Quantities | Item | Upper/Lower | 0-49 | 50-99 | 100-149 | 150-199 | 200-299 | 300-399 | 400-1000
 | Apple | a Value | 96.45 | 63.6 | 46.82 | 39.12 | 31.75 | 28.11 | 23.5
 | Apple | a Lower | 140.21 | 87.03 | 57.34 | 49.28 | 37.24 | 33.82 | 27.11
 | Apple | a Upper | 155.61 | 101.09 | 76.64 | 62.21 | 54.03 | 46.01 | 40
 | Apple | b Value | 110.25 | 77.1 | 60.17 | 52.47 | 45.1 | 40.96 | 36.78
 | Apple | b Lower | 137 | 102.9 | 73 | 64.51 | 54.8 | 50.38 | 42
 | Apple | b Upper | 164.38 | 112.9 | 88.77 | 74.3 | 66.09 | 58.23 | 55.3
 | Orange
Quantities | Item | Upper/Lower | 0-49 | 50-99 | 100-149 | 150-199 | 200-249 | 250-299 | 300-399 | 400-499 | 500-599 | 600-799 | 800-1000
 | Orange | a Lower | 150 | 107 | 75 | 60 | 53 | 48 | 43 | 39 | 37 | 35 | 30
 | Orange | a Upper | 197.08 | 149 | 111 | 95 | 74 | 64 | 59 | 54 | 49 | 45 | 38.63
 | Orange | b Lower | 158 | 118.3 | 86.9 | 71.5 | 65 | 60.1 | 54.66 | 51.05 | 48.7 | 46.51 | 42.27
 | Orange | b Upper | 185 | 168.5 | 120.5 | 99.52 | 87.73 | 80.19 | 73.26 | 66.85 | 63.55 | 59.85 | 57
Spreadsheet: 791997d1660687389-help-with-formulas-for-a-filtered-table-example-spreadsheet-count-distinct
Sheet: AugIntvws

 |  |  | Activity Totals |  | Color Totals |  | Blue
 | # [NAME] |  |  | Blue |  |  | Red
 | # of Candidates |  |  | Red |  |  | Yellow
 |  |  |  | Yellow
Interviewer | Candidate | Color Code
[NAME] | [NAME] | Blue
[NAME] | [NAME] | Blue
[NAME] | [NAME] | Blue
[NAME] | [NAME] | Blue
[NAME] | Riddhi A. | Blue
[NAME] | Vaish V. | Blue
[NAME] | [NAME] | Red
[NAME] | [NAME] | Red
[NAME] | [NAME] | Red
[NAME] | [NAME] | Red
[NAME] | [NAME] | Red
[NAME] | [NAME] | Red
[NAME] | Shub M. | Red
[NAME] | Shub M. | Red
[NAME] | Bharath D. | Yellow
[NAME] | [NAME] | Yellow
[NAME] | [NAME] | Yellow
Spreadsheet: 834227d1687534757-index-match-formula-not-working-properly-keeps-returning-0-book1
Sheet: report

Question | Yes | No
Question 1
Question 2
Question 3
Question 4
Question 5
Question 6
Question 7
Question 8
Question 9
Question 10
Question 11
Question 12
Question 13
Question 14
Question 15
Question 16
Question 17
Question 18
Question 19
Question 20
Spreadsheet: 584482d1533213813-summing-ageing-of-transactions-into-buckets-bsheet-phased
Sheet: Transactions

General [NAME]
 |  |  |  |  |  | Audit ID | INPUT
Fiscal year/period | Posting date | Doc. No. (GL View) | SAP G/L Account |  | Cost Object |  | SAP Local Currency
JUL 2018 | 2018-07-02 00:00:00 | 107172953 | 302000 | Accruals - Purchase Invoice/Goods Received | # | Not assigned | 10124
JUL 2018 | 2018-08-02 00:00:00 | 107173179 | 302000 | Accruals - Purchase Invoice/Goods Received | # | Not assigned | 22076
JUL 2018 | 2018-08-02 00:00:00 | 107173620 | 302000 | Accruals - Purchase Invoice/Goods Received | # | Not assigned | 65879
JUL 2018 | 2018-05-02 00:00:00 | 107173644 | 302000 | Accruals - Purchase Invoice/Goods Received | # | Not assigned | 6171
JUL 2018 | 2018-05-02 00:00:00 | 107173645 | 302000 | Accruals - Purchase Invoice/Goods Received | # | Not assigned | 5816
JUL 2018 | 2018-04-02 00:00:00 | 107173646 | 302000 | Accruals - Purchase Invoice/Goods Received | # | Not assigned | 21406
JUL 2018 | 2018-03-02 00:00:00 | 107173647 | 302000 | Accruals - Purchase Invoice/Goods Received | # | Not assigned | 76656
JUL 2018 | Result
Overall Result
Spreadsheet: 870481d1716987973-if-statement-with-variable-length-range-help
Sheet: Sheet3

Structure Level | CAD file | Version | State (CAD) | Context | CAD Chack | Option and lower level CAD
0 | 11111111.ASM | x | x | x | -
1 | CAD Not Found | x | x | x | Non CAD item |  | =[NAME]:B6,"CAD Not Found"),"Some CAD Missing","All [NAME]:B6,"CAD Not Found"),"Some CAD Missing","All Part level CAD available but option is missing"))
2 | CAD Not Found | x | x | x | -
2 | CAD Not Found | x | x | x | -
1 | 222222.ASM | x | x | x | Has CAD
2 | 333333333.PRT | x | x | x | -
2 | 44444444.PRT | x | x | x | -
2 | 5555555.ASM | x | x | x | -
1 | CAD Not Found | x | x | x | Blank
2 | 777777777.PRT | x | x | x | -
2 | 888888888.PRT | x | x | x | -
2 | 999999.PRT | x | x | x | -
2 | 1011111.PRT | x | x | x | -
2 | 102222222.PRT | x | x | x | -
Spreadsheet: 717236d1612536637-how-to-calculate-based-on-number-of-months-is-less-than-12-annual-raise-example
Sheet: 2021

Hire Date | End Date | Months between | June | October | Febuary | Yearly Total | Final Rating (average) | Raise  4.5% | Current Rate of Pay | April 1, 2021 Raise | April 1, 2021 Rate of Pay
07/19/2006_x000D_ | 2021-04-01 00:00:00 |  | 1.05 | 1.2 | 1.25 |  |  |  | 125000.2
11/28/2011_x000D_ | 2021-04-01 00:00:00 |  | 1 | 1.1 | 0.92 |  |  |  | 84908.2
03/04/2019_x000D_ | 2021-04-01 00:00:00 |  | 1.1 | 1.2 | 1.11 |  |  |  | 167200.02
06/14/2010_x000D_ | 2021-04-01 00:00:00 |  | 1.05 | 1.05 | 1.21 |  |  |  | 53386.84
10/04/2018_x000D_ | 2021-04-01 00:00:00 |  | 1.25 | 1.1 | 0.99 |  |  |  | 57750.16
11/27/2017_x000D_ | 2021-04-01 00:00:00 |  | 1 | 1 | 1.14 |  |  |  | 51750.14
06/03/2019_x000D_ | 2021-04-01 00:00:00 |  | 0.95 | 1.1 | 1 |  |  |  | 21.38
01/17/2011_x000D_ | 2021-04-01 00:00:00 |  | 0 | 1.2 | 1.15 |  |  |  | 55734.9
09/05/2019_x000D_ | 2021-04-01 00:00:00 |  | 1.25 | 1.25 | 1.25 |  |  |  | 62500.1
11/09/2020_x000D_ | 2021-04-01 00:00:00 |  |  |  | 1.26 |  |  |  | 49000.9
06/22/2020_x000D_ | 2021-04-01 00:00:00 |  | 1 | 1 | 1 |  |  |  | 52000
05/22/2019_x000D_ | 2021-04-01 00:00:00 |  | 1.1 | 1.15 | 0.92 |  |  |  | 60000.2
10/19/2020_x000D_ | 2021-04-01 00:00:00 |  |  |  | 1.15 |  |  |  | 28.85
03/30/2020_x000D_ | 2021-04-01 00:00:00 |  | 1 | 1.15 | 1.25 |  |  |  | 60000.2
07/27/2020_x000D_ | 2021-04-01 00:00:00 |  |  |  | 1.17 |  |  |  | 50000.08
01/19/2015_x000D_ | 2021-04-01 00:00:00 |  | 1 | 1 | 1.23 |  |  |  | 43189.9
05/03/2010_x000D_ | 2021-04-01 00:00:00 |  | 1.3 | 1.3 | 1.35 |  |  |  | 133000.14
01/04/2010_x000D_ | 2021-04-01 00:00:00 |  | 1.3 | 1.25 | 1.27 |  |  |  | 136899.1
Spreadsheet: 790183d1659582718-filter-xmatch-formulas-with-wildcard-text-revenuelist-copy
Sheet: Sheet1

 |  |  |  |  |  | *Need wildcard to locate any ClientLedger names with text containing the ClientInvoiceName string |  | Possible Matches:
ClientLedger | CustomerNumber | RevenueCategory | LastUsed |  | ClientInvoiceName | *Client* |  | ClientLedger | CustomerNumber | RevenueCategory | LastUsed
Wendys America | 1 | 2880 | 2019-01-17 00:00:00 |  | Wendys
Eastern McDonalds | 2 | 2680 | 2022-05-14 00:00:00 |  | McDonalds
California Arbys | 3 | 2480 | 2022-04-22 00:00:00 |  | Arbys
West Sonic | 4 | 2280 | 2022-03-06 00:00:00 |  | Sonic
Banana Avenue | 5 | 2080 | 2021-05-17 00:00:00 |  | Kentucky
[NAME] | 6 | 1880 | 2021-04-17 00:00:00
Orange Place | 7 | 1680 | 2021-03-11 00:00:00
Sonic of NA | 8 | 1480 | 2021-02-17 00:00:00
Corporate KFC (Kentucky Fried Chicken) | 9 | 1280 | 2021-01-17 00:00:00 |  | Objective- | I am working a backlog of establishing new revenue categories by client, but we have hundreds whose names aren't consistent with what we have on our systems or haven't been set up yet. I need a method to review potential matches.
[NAME] | 10 | 1080 | 2021-12-17 00:00:00
Wendys Incorporated | 11 | 880 | 2022-07-25 00:00:00
McDonalds Inc | 12 | 680 | 2022-07-24 00:00:00
Spreadsheet: 833192d1686832633-formula-to-calculate-capital-gain-loss-share-holdings-by-value-sample
Sheet: Summary

Share Holdings by Value
Share Code | Platform | Country | Type | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Allocation | Date | Qty | Price | Total Holding | Average Price | Capital Gain/Loss 2022-2023 Tax Year | Capital Gain/Loss 2023-2024 Tax Year
BRN | CMC | Australia | Equity | Purchase | 2022-01-25 00:00:00 | 1500 | 1.4 | Sale | 2023-05-29 00:00:00 | -1500 | 0.46 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1410
EYPT | Interactive | USA | Equity | Purchase | 2023-04-28 00:00:00 | 27 | 6.25 | Purchase | 2023-04-28 00:00:00 | 80 | 6.1 | Sale | 2023-05-12 00:00:00 | -107 | 6.28 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15.21
TNYA | Interactive | USA | Equity | Purchase | 2023-04-28 00:00:00 | 150 | 5.04 | Sale | 2023-05-24 00:00:00 | -100 | 6.9 | Sale | 2023-06-01 00:00:00 | -50 | 6.95 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 281.5
BYND | Tradestation | USA | Equity | Purchase | 2021-09-20 00:00:00 | 10 | 110 | Sale | 2023-05-11 00:00:00 | -10 | 11.16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -988.4
CIFR | Interactive | USA | Equity | Purchase | 2023-05-23 00:00:00 | 200 | 2.48 | Sale | 2023-06-06 00:00:00 | -200 | 2.17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -62
APLD | Interactive | USA | Equity | Purchase | 2023-05-23 00:00:00 | 50 | 8.26 | Purchase | 2023-06-01 00:00:00 | 50 | 8.2 | Purchase | 2023-06-03 00:00:00 | 50 | 0.3478260869565217 | Sale | 2023-06-05 00:00:00 | 80 | 4.3
AI | Interactive | USA | Equity | Purchase | 2023-05-30 00:00:00 | 20 | 38.5
Spreadsheet: 455913d1460561696-matching-specific-characters-in-a-row-using-index-match-matching-specific-characters
Sheet: Sheet1

 | X | X | O | 2 | 2 | O
 | X | X | X | X | X | X
 | 2 | 2 | O | O | X | X
Spreadsheet: 72475d1273158628-chosing-the-highest-and-lowest-statements-with-assigned-to-them-value-test
Sheet: Tabelle1

Statement | Category | Category 2 | Value
A | x | n | 1 | 1
B | x | c | 2 | 2
C | x | c | 3 | 3
D | y | c | 4
E | y | n | 5
F | y | n | 6
G | y | n | 7
H | x | r | 8
I | x | r | 9
J | x | r | 1
K | x | r | 2
L | x | c | 3
M | x | c | 4
N | y | n | 5
O | y | n | 6
P | y | n | 7
Q | y | i | 8
R | y | i | 9
S | y | i | 1
T | y | i | 10
U | x | i | 3
V | x | i | 10
Spreadsheet: 834162d1687499156-count-if-function-in-one-row-book4
Sheet: Sheet1

SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL | SL
Spreadsheet: 1a8acdcf-500d-4f9d-a8c4-3a0dac00d84e
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
LORAZ | Test | LORAZ | Lorazepam (Ativan), Serum | Lorazepam (Ativan) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  |  |  | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top sodium heparin tube(s). ([NAME] tube is not acceptable.)  [NAME] down and send 2 mL of plasma refrigerated. Note:		1. Indicate plasma on request form. 		2. Label specimen appropriately (plasma).      		3. Trough levels are most reproducible.   Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.)  [NAME] down and send 2 mL of serum refrigerated. Note:		1. Indicate serum on request form. 		2. Label specimen appropriately (serum). 	3. Trough levels are most reproducible. | 0.3 mL Note: Submission of the m | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Reference Range: 50.0-240.0 ng/mL   Test Performed By: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 80154 |  |  |  |  | Medtox Laboratories, Inc
LORAZ | Result | Z1123 | Lorazepam (Ativan) | Lorazepam (Ativan) | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 471874d1469224837-incremental-formula-add-every-four-cell-of-same-row-adjacently-copy-of-sum-blocks-of-4-ndm-2-
Sheet: Sheet1

1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4 | 5 | 5 | 5 | 5
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 11 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 850102d1700495767-drop-down-list-to-select-rows-must-also-include-all-sample
Sheet: Sheet1

Name | Score | Teacher |  |  |  | Teacher | Jones
[NAME] | 1 | Jones
[NAME] | 2 | Smith
[NAME] | 3 | Jones |  |  |  |  | 1 | Jones
 |  |  |  |  |  | [NAME] | 3 | Jones
Spreadsheet: 112976d1308933464-excel-2007-help-in-converting-to-numbers-and-filterring-book1
Sheet: Sheet1

ab12 | € 59.50
ab13 | € 63.75
ab15 | € 528.75
ab17 | € 184.50
ab18 | € 60.75
ab20 | € 92.25
ab21 | € 67.50
ab28 | € 2.25
ab30 | € 9.00
ab31 | € 54.00
ab33 | € 129.75
[NAME] | € 4.50
Spreadsheet: joe_quenet__15067__PJM
Sheet: DJ PJM Electricity Index

 | DATE |  |  |  | Firm On Peak |  | MW |  | [NAME]
 | 2001-05-23 00:00:00 |  |  |  | 32.96 |  | 4300 |  | 68800
 | 2001-05-22 00:00:00 |  |  |  | 33.68 |  | 3300 |  | 52800
 | 2001-05-21 00:00:00 |  |  |  | 36.66 |  | 6150 |  | 98400
 | 2001-05-20 00:00:00
 | 2001-05-19 00:00:00
 | 2001-05-18 00:00:00 |  |  |  | 38.94 |  | 4750 |  | 76000
 | 2001-05-17 00:00:00 |  |  |  | 39.24 |  | 4600 |  | 73600
 | 2001-05-16 00:00:00 |  |  |  | 38.05 |  | 3950 |  | 63200
 | 2001-05-15 00:00:00 |  |  |  | 36.13 |  | 3450 |  | 55200
 | 2001-05-14 00:00:00 |  |  |  | 40.5 |  | 4200 |  | 67200
 | 2001-05-13 00:00:00
 | 2001-05-12 00:00:00
 | 2001-05-11 00:00:00 |  |  |  | 55.26 |  | 5750 |  | 92000
 | 2001-05-10 00:00:00 |  |  |  | 47.55 |  | 1600 |  | 25600
 | 2001-05-09 00:00:00 |  |  |  | 39.14 |  | 2100 |  | 33600
 | 2001-05-08 00:00:00 |  |  |  | 34.21 |  | 3350 |  | 53600
 | 2001-05-07 00:00:00 |  |  |  | 41.5 |  | 1900 |  | 30400
 | 2001-05-06 00:00:00
 | 2001-05-05 00:00:00
 | 2001-05-04 00:00:00 |  |  |  | 60.09 |  | 3050 |  | 48800
 | 2001-05-03 00:00:00 |  |  |  | 67.64 |  | 5050 |  | 80800
 | 2001-05-02 00:00:00 |  |  |  | 63.77 |  | 2550 |  | 40800
 | 2001-05-01 00:00:00 |  |  |  | 54.8 |  | 2900 |  | 46800
 | 2001-04-30 00:00:00 |  |  |  | 61.41 |  | 5250 |  | 84000
 | 2001-04-29 00:00:00
 | 2001-04-28 00:00:00
 | 2001-04-27 00:00:00 |  |  |  | 39.61 |  | 3300 |  | 52800
 | 2001-04-26 00:00:00 |  |  |  | 39.61 |  | 3650 |  | 58400
 | 2001-04-25 00:00:00 |  |  |  | 42.84 |  | 4800 |  | 76800
 | 2001-04-24 00:00:00 |  |  |  | 53.28 |  | 5600 |  | 89600
 | 2001-04-23 00:00:00 |  |  |  | 54.52 |  | 1750 |  | 28000
Spreadsheet: 140161d1328638314-excel-2007-showing-the-contents-of-a-cell-from-a-different-sheet-that-changes-position-str
Sheet: Week 4

Pearson Stone Co. |  |  |  |  |  |  |  | 12:29 PM
Sales Tax Liability |  |  |  |  |  |  |  | 2012-02-06 00:00:00
January 22 - 28, 2012 |  |  |  |  |  |  |  | Cash Basis
 |  |  |  |  |  |  |  | Sales Tax Payable
 |  |  | Total Sales | Non-Taxable Sales | Taxable Sales | Tax Rate | Tax Collected | As of Jan 28, 12
 | Texas Comptroller Sales Tax
 |  | MTA | 0 | 0 | 0 | 0.01 | 0 | 8.87
 |  | Rowlett | 0 | 0 | 0 | 0.01 | 0 | 8.87
 |  | State | 13764.59 | 13504.11 | 260.48 | 0.0625 | 16.28 | 165.11
 | Total Texas Comptroller Sales Tax
TOTAL
Spreadsheet: 491029d1480271215-adding-cumulative-weekly-totals-avk-excel-forum-question1
Sheet: 11-3-16

 | DAILY HEARING ROSTER
 | MEETINGS TODAY: | Labor Day (HOLIDAY)
Rank | Employee | Notes | Time In | Time Out | Time In | Time Out | Subtotal | Total Hours | NewRank | Cumulative | Cum_rank | Judge | Employee Name | Board No.
1 |  |  | 09:00:00 | 12:00:00 |  |  |  |  |  |  |  |  | Pretend Employee
2 |  |  | 10:00:00 | 12:00:00
3 |  |  |  |  |  |  |  |  |  |  |  |  | Pretend Employee
4
5
6
 | Travel
 |  |  |  | TOTAL TIME (Today): |  |  |  |  |  |  |  | TOTAL HEARINGS (Today):
 |  |  |  | TIME (Week End Total): |  |  |  |  |  |  |  | HEARING (Week End Total):
Spreadsheet: larry_campbell__21028__PTE Calcs
Sheet: Fug

EPN: FUG-1                              AREA FUGITIVE EMISSIONS
 |  | EMISSION |  | PERCENT |  | EMISSIONS
COMPONENT | COUNT | FACTOR *1 | HOURS | VOC *1 | ANNUAL | ANNUAL | DAILY
 |  | (lb/hr/comp) |  |  | (lb/yr) | (tn/yr) | (lb/day)
[NAME]:
GAS/VAPOR | 28 | 0.00992 | 8760 | 0.1
LIGHT LIQUID | 1 | 0.0055 | 8760 | 1
HEAVY LIQUID | 0 | 1.85e-05 | 8760 | 1
FLANGES:
GAS/VAPOR | 62 | 0.00086 | 8760
LIGHT LIQUID | 2 | 0.000243 | 8760 | 1
HEAVY LIQUID | 0 | 8.6e-07 | 8760 | 1
COMPRESSORS:
 | 1 | 0.0194
 | 1 | 0.0194
OPEN ENDED LINES | 0 | 0.00441 | 8760
PUMPS | 2 | 0.02866 | 8760 | 1
RELIEF VALVES/Other: | 6 | 0.0194 | 8760
SAMPLE CONNECTIONS:
 |  |  |  | TOTAL VOC (59999):
1. Percent VOC for liquid stream conservatively estimated.
2. Percent VOC for gas streams from gas analysis.
Spreadsheet: 674634d1587968578-formula-to-calculate-a-stepped-pay-incentive-bonus-pay-estimation-new-pay-scale
Sheet: TEMPLATE

Pay Estimation
Day | Date | Shift | minutes | Class time | Standby time |  | Total at 13 USD
Sunday |  |  | 120 | 60
Monday
Tuesday
Wednesday
Thursday
Friday | 2020-05-01 00:00:00 | 6:00-9:10
Saturday | 2020-05-02 00:00:00 | 6:00-9:10
Sunday | 2020-05-02 00:00:00 | 6:00-9:10
Monday | 2020-05-03 00:00:00 | 6:00-9:10
Tuesday | 2020-05-04 00:00:00 | 6:00-9:10
Wednesday | 2020-05-05 00:00:00 | 6:00-9:10
Thursday | 2020-05-06 00:00:00 | 6:00-9:10
Friday | 2020-05-07 00:00:00 | 6:00-9:10
Saturday | 2020-05-08 00:00:00 | 6:00-9:10
Sunday | 2020-05-09 00:00:00 | 6:00-9:10
Monday | 2020-05-10 00:00:00 | 6:00-9:10
Tuesday | 2020-05-11 00:00:00 | 6:00-9:10
Wednesday | 2020-05-12 00:00:00 | 6:00-9:10
Thursday | 2020-05-13 00:00:00 | 6:00-9:10
Friday | 2020-05-14 00:00:00 | 6:00-9:10
Saturday | 2020-05-15 00:00:00 | 6:00-9:10
Sunday | 2020-05-16 00:00:00 | 6:00-9:10
Monday | 2020-05-17 00:00:00 | 6:00-9:10
Tuesday | 2020-05-18 00:00:00 | 6:00-9:10
Wednesday | 2020-05-19 00:00:00 | 6:00-9:10
Thursday | 2020-05-20 00:00:00 | 6:00-9:10
Friday | 2020-05-21 00:00:00 | 6:00-9:10
Saturday | 2020-05-22 00:00:00 | 6:00-9:10
Sunday | 2020-05-23 00:00:00 | 6:00-9:10
Monday | 2020-05-24 00:00:00 | 6:00-9:10
Tuesday | 2020-05-25 00:00:00 | 6:00-9:10
Wednesday | 2020-05-26 00:00:00 | 6:00-9:10
Thursday | 2020-05-27 00:00:00 | 6:00-9:10
Friday | 2020-05-28 00:00:00 | 6:00-9:10
Saturday | 2020-05-29 00:00:00 | 6:00-9:10
Sunday | 2020-05-30 00:00:00 | 6:00-9:10
Monday | 2020-05-31 00:00:00 | 6:00-9:10
Tuesday
Wednesday
Thursday
Friday
Saturday
 |  | Total Mins
 |  | Total hrs
 |  |  |  |  | Sub Total | USD
 |  |  |  |  | Bonus Total | USD
 |  |  |  |  | TOTAL: | USD
 |  |  |  |  |  | CAD
Step Bonus Calculation
 |  | Bonus Pay
Level 1 (h 1-15 @ $1)
Level 2 (h 16-40 @ $3)
Level 3 (h 41-50 @ $4)
Level 4 (h 51-60 @ $5)
Level 5 (h 61-80 @ $6)
Level 6 (h 81+ @ $7)
 |  |  | Total  Bonus
Spreadsheet: 879722d1727273530-changing-data-in-a-calculated-cell-deletes-formula-1460-abc-eba
Sheet: Billing Invoice

 | WORK ORDER | 1460
 | 2024-09-20 00:00:00
 | ABC Testing |  | Car Radio Conversions
 | 50 Dust Street |  | 1234 Oakwood Dr.
 | Anywhere, USA 12345 |  | Anywhere, NY 13120
 | ph (222) 731-1234 |  |  | [PHONE]
 | QUANTITY | DETAILS | UNIT PRICE | TOTAL
 | Parts:
 | 1 | tran | 6
 | 2 | cap | 2
 | 3 |  | 5
 | 3 |  | 6.77
 | 4 |  | 7.99
 | 5 |  | 8.25
 | 6 |  | 3.44
 | 7 |  | 5.66
 | 8 |  | 6.77
 | 9 |  | 8.42
 | 3 |  | 6.33
 | 8 |  | 5.12
 | 2 |  | 3.44
 | 2 |  | 5.44
 | 5 |  | 4.44
 |  |  | Parts Total
 | Labor
 | 4 | Hours of Labor | 50
 | Parts + Labor
 | Shipping |  |  | 45
 |  |  | Subtotal
 | Payment Mode | Cash | Credit Card 3.6%
 | Total
 |  | www.carradioconversions.com