tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 71620d1272380964-looking-up-a-value-copy-of-xls-problem
Sheet: List with ap

AREA 1 | AREA 2 | AREA 3 | AREA 4 |  | airport code | area
ATL | ABJ | AKL | [NAME] |  | ATL | [NAME]
YYC | ACC | BKK | AUH |  | YYC | [NAME]
ORD | ALA | HKG | BEY |  | ORD | [NAME]
GDL | GYD | ICN | DAM |  | GDL | [NAME]
HSV | BCN | KMQ | DMM |  | HSV | [NAME]
IAH | BUD | KUL | DOH |  | IAH | [NAME]
IND | BZV | [NAME] | DXB |  | IND | [NAME]
LAX | IST | PEK | JNB |  | LAX | [NAME]
MEX | FIH | PVG | KHI |  | MEX | [NAME]
MIA | LBV | SGN | KWI |  | MIA | [NAME]
[NAME] | LOS | SIN | LUN |  | [NAME] | [NAME]
SEA | MXP | TPE | NBO |  | SEA | [NAME]
ANC | MSE | XMN |  |  | ANC | [NAME]
BOG | MST |  |  |  | BOG | [NAME]
CUR | NDJ |  |  |  | CUR | [NAME]
CWB | PIK |  |  |  | CWB | [NAME]
PNZ | TBS |  |  |  | PNZ | [NAME]
PTY | STN |  |  |  | PTY | [NAME]
UIO |  |  |  |  | UIO | [NAME]
LTX |  |  |  |  | LTX | [NAME]
SCL |  |  |  |  | SCL | [NAME]
VCP |  |  |  |  | VCP | [NAME]
 |  |  |  |  | ABJ | AREA2
 |  |  |  |  | ACC | AREA2
 |  |  |  |  | ALA | AREA2
 |  |  |  |  | GYD | AREA2
 |  |  |  |  | BCN | AREA2
 |  |  |  |  | BUD | AREA2
 |  |  |  |  | BZV | AREA2
 |  |  |  |  | IST | AREA2
 |  |  |  |  | FIH | AREA2
 |  |  |  |  | LBV | AREA2
 |  |  |  |  | LOS | AREA2
 |  |  |  |  | MXP | AREA2
 |  |  |  |  | MSE | AREA2
 |  |  |  |  | MST | AREA2
 |  |  |  |  | NDJ | AREA2
 |  |  |  |  | PIK | AREA2
 |  |  |  |  | TBS | AREA2
 |  |  |  |  | STN | AREA2
 |  |  |  |  | AKL | AREA3
 |  |  |  |  | BKK | AREA3
 |  |  |  |  | HKG | AREA3
 |  |  |  |  | ICN | AREA3
 |  |  |  |  | KMQ | AREA3
 |  |  |  |  | KUL | AREA3
 |  |  |  |  | [NAME] | AREA3
 |  |  |  |  | PEK | AREA3
 |  |  |  |  | PVG | AREA3
 |  |  |  |  | SGN | AREA3
 |  |  |  |  | SIN | AREA3
 |  |  |  |  | TPE | AREA3
 |  |  |  |  | XMN | AREA4
 |  |  |  |  | [NAME] | AREA4
 |  |  |  |  | AUH | AREA4
 |  |  |  |  | BEY | AREA4
 |  |  |  |  | DAM | AREA4
 |  |  |  |  | DMM | AREA4
 |  |  |  |  | DOH | AREA4
 |  |  |  |  | DXB | AREA4
 |  |  |  |  | JNB | AREA4
 |  |  |  |  | KHI | AREA4
 |  |  |  |  | KWI | AREA4
 |  |  |  |  | LUN | AREA4
 |  |  |  |  | NBO | AREA4
Spreadsheet: 868234d1714981536-tier-incentive-will-be-automatically-calculated-based-on-tier-doctors-calculation-april-2024-allan-sampling-of-doing-formula-copy-1-aligw
Sheet: Maryam Al-Anazi

Contract Terms (*)
 |  | Consultation | 0.5
 |  | Dental Procedure (After Deducting direct and indirect expenses +OR Cost + Lab Fee) | 0.45
 |  | OHE To Be Deducted From Total Revenue | 0.05
Doctor Calculation
 |  | Gross Revenue | 4265
 |  | Doctor Consultation Revenue | 330
 |  | Clinic Fees 5%
 |  | Net Revenue
 |  | Amount to be paid
 |  | Doctor Revenue Dental Procedure | 3935.2
 |  | Clinic Fees 5%
 |  | Dental Lab | 0
 |  | Net Revenue
 |  | Amount to be Paid
 |  | Doctor Revenue Implant Procedure | 0
 |  | Clinic Fees 5%
 |  | Consumables | 0
 |  | Net Revenue
 |  | Amount to be Paid | 0
 |  | * Implant Cost : 650 SAR
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO | .......................
Spreadsheet: 38536d1236695789-i-keep-getting-na-s-not-sure-where-im-going-wrong-itassignworkinprogress
Sheet: Prices

All products are sold in boxes and the prices below refer to the price per box
Wobbles |  |  |  |  |  | Breaks | Wobbles | Donkies | Roggles
Quantity Ordered | Price per Box |  | Unit Cost |  |  | 1 | 6.1 | 5.2 | 7.4
1 to 49 boxes | 6.1 |  | 4 |  |  | 10 | 6.1 | 5.1 | 7.4
50 to 99 boxes | 6 |  |  |  |  | 20 | 6.1 | 5 | 7.2
100 or more boxes | 5.9 |  |  |  |  | 30 | 6.1 | 4.9 | 7.2
 |  |  |  |  |  | 40 | 6.1 | 4.9 | 7
 |  |  |  |  |  | 50 | 6 | 4.9 | 7
 |  |  |  |  |  | 100 | 5.9 | 4.9 | 7
Donkies
Quantity Ordered | Price per Box |  | Unit Cost
1 to 9 boxes | 5.2 |  | 3.1
10 to 19 boxes | 5.1
20 to 29 boxes | 5
30 or more boxes | 4.9
Roggles
Quantity Ordered | Price per Box |  | Unit Cost
1 to 19 boxes | 7.4 |  | 5.1
20 to 39 boxes | 7.2
40 or more boxes | 7
Spreadsheet: 23708d1213358059-how-to-combine-several-vertical-cells-in-one-cell-question
Sheet: Sheet6

DATE | SOURCE | ACCOUNT CODE | [NAME] | DR | CR
2008-05-01 00:00:00 | STANDARD | 724005 | XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX | 4362 | 4362
 |  |  | YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY
 |  |  | ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ
 |  |  | KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKK
 |  |  | LLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLLL
 |  |  | MMMMMMMMMMMMMMMMMMMMMM
 |  |  | [NAME]
2008-04-01 00:00:00 | STANDARD | 723008 | AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA | 1200
 |  |  | BBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB
2008-04-01 00:00:00 | STANDARD | 725002 | [NAME] | 2920
 |  |  | PPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP
 |  |  | UUUUUUUUUUUUUUUUUUUUUUUUUUU
 |  |  | OOOOOOOOOOOOOOOOOOOOOOOOOOO
2008-04-01 00:00:00 | STANDARD | 727009 | FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF | 9833.4
 |  |  | SSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS
 |  |  | IIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIIII
2008-04-01 00:00:00 | STANDARD | 729002 | RRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR | 11150
 |  |  | TTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTTT
2008-04-01 00:00:00 | STANDARD | 735001 | Invoice: 0302 - DOC SEQ: 20080-9641 | 1625
 |  |  | DESC: PENS WITH LOGOS FOR QMDI-
 |  |  | hibitions.Special Event Expenses.QM Fi
2008-04-01 00:00:00 | STANDARD | 777420 | Invoice: 0071/08 - DOC SEQ: | 1200 | 1200
 |  |  | 200809638 - DESC: LANYARDS FORQMDI
 |  |  | hibitions.Gifts.QM First International
2008-04-01 00:00:00 | STANDARD | 735001 | Invoice: 0302 - DOC SEQ: 20080-9641 | 1625 | 1625
 |  |  | DESC: PENS WITH LOGOS FOR QMDI-
 |  |  | Vendor: DUNES INTERNATIONAL TRADING
2008-04-01 00:00:00 | STANDARD | 735500 | Invoice: 0302 - DOC SEQ: 20080-9641 | 100 | 100
 |  |  | DESC: PENS WITH LOGOS FOR QMDI-
 |  |  | Vendor: DUNES INTERNATIONAL TRADING
Spreadsheet: 676035d1588616034-how-to-get-average-cost-of-remaining-unsold-stock-excel-forum
Sheet: Sheet1

Avg. Rate | Total Qty. | Buying Average |  | R Stock | Selling Average |  | Total Qty. | Avg. Rate
 | 160 | Stock A |  | 130 | Stock A |  | 30
 |  |  |  | [NAME].
[NAME] | Quantity | Rate | Date | Sr. No. | Date | Rate | Quantity | [NAME]
2182.68 | 30 |  | 2016.08.01 | 1 | 2017.07.05 |  | 30 | 2457
2586 | 30 |  | 2017.03.17 | 2
2004.64 | 20 |  | 2018.01.05 | 3
932.29 | 10 |  | 2018.01.18 | 4
1683.95 | 20 |  | 2018.02.07 | 5
1090.11 | 50 |  | 2020.04.21 | 6
Spreadsheet: 711855d1609946473-cumulative-average-for-current-year-formula-ups2021
Sheet: Sep2021

UPS Shipping
 | STANDARD |  | OVERNIGHT
Date: | # [NAME] | $Cost$ | # [NAME] | $Cost$
2021-09-01 00:00:00
2021-09-02 00:00:00
2021-09-03 00:00:00
2021-09-04 00:00:00
2021-09-05 00:00:00
2021-09-06 00:00:00
2021-09-07 00:00:00
2021-09-08 00:00:00
2021-09-09 00:00:00
2021-09-10 00:00:00
2021-09-11 00:00:00
2021-09-12 00:00:00
2021-09-13 00:00:00
2021-09-14 00:00:00
2021-09-15 00:00:00
2021-09-16 00:00:00
2021-09-17 00:00:00
2021-09-18 00:00:00
2021-09-19 00:00:00
2021-09-20 00:00:00
2021-09-21 00:00:00
2021-09-22 00:00:00
2021-09-23 00:00:00
2021-09-24 00:00:00
2021-09-25 00:00:00
2021-09-26 00:00:00
2021-09-27 00:00:00
2021-09-28 00:00:00
2021-09-29 00:00:00
2021-09-30 00:00:00
Totals:
Spreadsheet: 161403d1339512960-2-dimension-lookup-servicesandcosts
Sheet: Results

 | Anna | [NAME] | [NAME] | Fred
Service 1 |  |  |  |  | <---- FORMULA 1
Service 2
Service 3
Service 4
Service 5
Service 6
Service 7
Service 8
 | Anna | [NAME] | [NAME] | Fred
Service 1 |  |  |  |  | <------ FORMULA 2
Service 2
Service 3
Service 4
Service 5
Service 6
Service 7
Service 8
Spreadsheet: 9cf90a94-29e5-443d-b5a8-01c0aacfd744
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
80786 | Test | 80786 | [NAME] (EBV) RNA Detection by In Situ Hybridization | [NAME], In Situ Hybrid | In Situ Hybridization Testing | Formalin-fixed, paraffin-embedded tissue: FFPET OR [NAME]: GS OR |  |  |  | Varies | [NAME]: Formalin-fixed, paraffin-embedded tissue block; or 4 glass "positively charged" slides with formalin-fixed, paraffin-embedded tissue Container/Tube: Surgical Pathology Packaging Kit (Supply T554) Collection Instructions: Attach the green pathology address label included in the kit to the outside of the transport container. Additional Information: 1. A pathology/diagnostic report and a brief history are required. 2. One slide will be stained with hematoxylin-and-eosin and retained. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | This test, when not accompanied by a pathology consultation request, will be answered as either positive or negative. If additional interpretation/analysis is needed, request 5439 Surgical Pathology Consultation along with this test. | Monday through Friday | 1 day | 4 days | 1 | 88365 |  |  |  |  | Rochester
80786 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
80786 | Result | 18857 | Accession Number | Accession Number
80786 | Result | 18858 | Referring Pathologist/Physician | Referring Pathologist/Physician |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46608-6
80786 | Result | 18859 | Ref Path/Phys Address | Ref Path/Phys Address |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
80786 | Result | 18860 | Material: | Material: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
80786 | Result | 18961 | Tissue: | Tissue: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
80786 | Result | 18861 | Interpretation: | Interpretation: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
80786 | Result | 18962 | Comment: | Comment: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48767-8
80786 | Result | 18862 | SP Signing Pathologist: | SP Signing Pathologist:
80786 | Result | 18863 | *Previous Report Follows* | *Previous Report Follows*
80786 | Result | 18864 | [NAME]: | [NAME]: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35265-8
80786 | Result | 19214 | [NAME] Comment: | [NAME] Comment: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22638-1
80786 | Result | 18865 | [NAME] Pathologist: | [NAME] Pathologist: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19139-5
Spreadsheet: 3d2f4801-f2a9-4c36-aff3-122c1625bd78
Sheet: Sheet1

Accession number | FANTOM clone | Observed localization | 5' UTR_length | ORF_length | CRITICA CDS | SignalP | TMHMM
AK002541 | 0610011H04 | ER,golgi,secretory pathway | 299 | 28aa | 299-385 rc=2 | yes | yes
AK005178 | 1500009C09 | ER,golgi,secretory pathway | 280 | 68aa | 280-486 rc=1 | yes | yes
AK082625 | C230071E12 | ER,golgi,secretory pathway | 3 | 88aa | 3-269 rc=1 | yes | yes
AK053214 | E030042M04 | ER,golgi,secretory pathway | 145 | 118aa | 145-501 rc=1 | yes | yes
AK017317 | 5430416O09 | surface, ER, golgi | 500 | 75aa | 500-727 rc=1 | yes | yes
AK039869 | A430023G14 | surface, ER, golgi | 692 | [NAME] | 692-1018 rc=2 | yes | yes
AK004381 | 1110065P19 | surface, ER, golgi | 77 | 76aa | 77-307; ri | yes | yes
AK017296 | 5430411J08 | GFP-like ubiquitous | 126 | 60aa | 126-308 rc=2 | yes | no
AK042333 | A630083C19 | GFP-like ubiquitous | 720 | 65aa | 720-917 rc=5 | yes | no
AK084489 | D330006H24 | GFP-like ubiquitous | 1394 | 172aa | 1394-1912; ri | yes | no
AK052751 | D630042J06 | GFP-like ubiquitous | 3055 | 75aa | 3055-3282 rc=5 | yes | no
AK089341 | F730009G16 | GFP-like ubiquitous | 75 | 76aa | 75-302 rc=3 | yes | no
AK007000 | 1700084P19 | GFP-like ubiquitous | 294 | 66aa | 294-494 rc=4 | yes | yes
AK051182 | [NAME] | GFP-like ubiquitous | 1 | 60aa | 1-183 rc=3 | yes | yes
AK016933 | 4933426I16 | undetected | 1158 | 29aa | 1158-1247 rc=5 | yes | no
AK083075 | C530044G15 | undetected | 862 | 80aa | 862-1104 rc=3 | yes | no
AK085769 | D830006B12 | undetected | 176 | 236aa | 176-886 rc=5 | yes | no
AK088489 | E430018N18 | undetected | 144 | 67aa | 144-347 rc=5 | yes | no
AK088845 | E430028D01 | undetected | 118 | 74aa | 118-342 rc=5 | yes | no
AK006900 | 1700066B19 | undetected | 410 | 99aa | 410-709 rc=1 | yes | yes
AK030334 | 5031439P11 | undetected | 518 | 75aa | 518-745; ri | yes | yes
AK032119 | 6330597M22 | undetected | 770 | 53aa | 770-931 rc=1 | yes | yes
AK078768 | 8030463G20 | undetected | 1214 | 39aa | 1214-1333 rc=5 | yes | yes
AK045860 | B230315E21 | undetected | 196 | 116aa | 196-546 rc=1 | yes | yes
AK086481 | D930031H03 | undetected | 267 | 100aa | 267-569 rc=2 | yes | yes
Spreadsheet: 45648d1244463967-formula-to-count-occurences-value-in-range-formulahelp
Sheet: Sheet1

Task Title | Status | Number of occurences of Task | Total number of times task title is not shown as the status "Finished" | Calculation
Item 1 | Ongoing | 5 | Example Item One should be 2
Item 1 | Finished | 5
Item 1 | Ongoing | 5
Item 1 | Finished | 5
Item 1 | Finished | 5
Item 2 | Ongoing | 3 | Example Item Two should be 3
Item 2 | Ongoing | 3
Item 2 | Ongoing | 3
Item 3 | Finished | 1 | Example Item 3 should be 0
Item 4 | Finished | 1 | Example Item 4 should be 0
Item 5 | Ongoing | 1 | Example Item 5 should be 1
Spreadsheet: 96843d1296120473-vlookup-help-needed-order-book
Sheet: New Job 2

PAYMENT BREAKDOWN |  |  |  | JOB DURATION
WEEK # | WEEK ENDING | AMOUNT |  | START | # OF WEEKS | END
 |  |  |  | TOTAL JOB VALUE
 |  |  |  | DATA INTEGRITY
 |  |  |  | Job End
 |  |  |  | Payments
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: Fin Ops

 | Financial Operations
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Reporting, GL, Trading & Transaction Support |  |  |  |  | Cash Operations
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % of |  |  | Per HC | New HC | Adj Comp |  |  | Per HC | New HC | Adj Comp |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | Total Exp |  |  |  |  |  |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  | 0 |  |  |  | Compensation | 0 |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 1.2
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  |  | Total |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] |  | 0 |  |  | [NAME] |  | 1
ENARENT | Rent |  |  |  |  |  |  |  | Admins |  | 4 |  |  | Admins |  | 1
ENATECH | Technology |  |  |  |  |  |  |  | Staff | 49200 | 2 |  |  | Staff | 49200 | 1
ENATRANS | Transportation |  |  |  |  |  |  |  | Analysts | 57600 | 2 |  |  | Analysts | 57600 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Specialist | 62400 | 7 |  |  | Specialist | 62400 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Sr Specialist | 74400 | 11 |  |  | Sr Specialist | 74400 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Managers | 90000 | 9 |  |  | Managers | 90000 | 2
 |  |  |  |  |  |  |  |  | Directors | 120000 | 4 |  |  | Directors | 120000 | 1
 | Headcount |  |  | 99 |  |  |  |  | Sr Director | 174000 | 1 |  |  | Sr Director | 174000 | 1
 |  |  |  |  |  |  |  |  | Vice President | 216000 | 4 |  |  | Vice President | 216000
 | A&A Headcount |  |  | 4 | 2 |  |  |  | [NAME] | 312000 | 1 |  |  | [NAME] | 312000
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2 |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development |  |  |  |  |  |  |  | Other Expense Calculation
ENACORIT | Controllable Infrastructure |  |  |  |  |  |  |  | Reporting, GL, Trading & Transaction Support
ENACORRN | Corporate Rent |  |  |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
ENAOTHAL | Other Allocated Direct  Expenses |  |  |  |  |  |  |  |  |  |  |  | 46 |  | This was adjusted up 600,000
ENADEPR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  |  | for Audit fees during the year.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | It was also adjusted 704,684
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | to get to a total of 7,000,000
 |  |  |  |  |  |  |  |  | Cash Operations |  |  |  |  |  | for the BA&R group.
 |  |  |  |  |  |  |  |  | Total Misc Exp |  | Old HC | Exp/Old HC | New HC | Exp/New HC
 |  |  |  |  |  |  |  |  |  |  | 103 |  | 7 |  | This was adjusted up 360,000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | for consulting fees during the year.
Spreadsheet: 875229d1721812380-aggregate-function-with-criteria-but-avoiding-duplicates-example
Sheet: Normal_flows

1 | 2 | 3 | 4 | 5 | 6
ID | Prod no. | Prod name adapted | Payer | Payer [NAME] | Product (adapted)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Duplicate which should not appear!
20000-25000-HRCL | 20000 | MED | 25000 | MAR | HRCL
20000-27500-HRCL_PI | 20000 | MED | 27500 | DES | HRCL_PI
300000-40000-BL_CL | 300000 | FN | 40000 | BEL | BL_CL
300000-40000-CRCL_FH | 300000 | FN | 40000 | BEL | CRCL_FH
300000-60000-HRCL_PI | 300000 | FN | 60000 | BRE | HRCL_PI
300000-20000-HRCL | 300000 | FN | 20000 | STC | HRCL
300000-20000-CRCL_FH | 300000 | FN | 20000 | STC | CRCL_FH
300000-40000-CRCL_FH | 300000 | FN | 40000 | BEL | CRCL_FH | Duplicate
300000-150000-HRCL_PI | 300000 | FN | 150000 | EHS | HRCL_PI
40000-30000-ELCL_ZP | 40000 | BE | 30000 | LOR | ELCL_ZP
60000-25000-HRCL | 60000 | BRE | 25000 | MAR | HRCL
60000-600000-CRCL | 60000 | BRE | 600000 | GEN | CRCL
600000-25000-CRCL_FH | 600000 | GEN | 25000 | MAR | CRCL_FH
600000-60000-HRCL_PI | 600000 | GEN | 60000 | BRE | HRCL_PI
600000-600000-CRCL | 600000 | GEN | 600000 | MON | CRCL
150000-150000-CRCL_FH | 150000 | EH | 150000 | STC | CRCL_FH
2000-25000-HRCL | 2000 | SES | 25000 | MAR | HRCL
2000-600000-HRCL | 2000 | SES | 600000 | GEN | HRCL
2000-45000-HRCL | 2000 | SES | 45000 | POL | HRCL
2000-60000-HRCL | 2000 | SES | 60000 | BRE | HRCL
2000-3000-HRCL | 2000 | SES | 3000 | ESP | HRCL
Spreadsheet: 694961d1599922157-table-lookup-with-multiple-values-and-range-2020-09-12-oeldere-abdiegojr
Sheet: RESULTS

EEiD | Employee Name | Hours Date | Project ID | Account ID | Pay Type | Hours | Pay Rate
M13816 | Employee, Name (0000) | 2020-07-31 00:00:00 | Sample.FF.FMLA | XX-297 | [NAME] | 8
M13816 | Employee, Name (0000) | 2020-08-06 00:00:00 | Sample.FF.FMLA | XX-297 | [NAME] | 8
M13816 | Employee, Name (0000) | 2020-08-21 00:00:00 | Sample.FF.FMLA | XX-297 | [NAME] | 8
M13816 | Employee, Name (0000) | 2020-08-27 00:00:00 | Sample.FF.FMLA | XX-297 | [NAME] | 8
M13816 | Employee, Name (0000) | 2020-08-28 00:00:00 | Sample.FF.FMLA | XX-297 | [NAME] | 8
M13816 | Employee, Name (0000) | 2020-09-03 00:00:00 | Sample.FF.FMLA | XX-297 | [NAME] | 8
M13816 | Employee, Name (0000) | 2020-09-04 00:00:00 | Sample.FF.FMLA | XX-297 | [NAME] | 8
M14361 | Employee, Name (0001) | 2020-06-29 00:00:00 | Sample.FF.PSP1 | XX-296 | xFF1 | 8
[NAME] | Employee, Name (0002) | 2020-04-07 00:00:00 | Sample.FF.PSP1 | XX-296 | xFF1 | 8
M14496 | Employee, Name (0003) | 2020-07-06 00:00:00 | Sample.FF.PSP1 | XX-296 | xFF1 | 2
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 | 115 | 240
2 | 58 | 240
3 | 44 | 240
4 | 2 | 240
5 | 35 | 240
6 | 41 | 240
7 | 245 | 240
8 | 171 | 240
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 173809
2001-12-08 00:00:00
CBS Volume
 |  |  | 76218
Spreadsheet: 766242d1643815336-populating-cells-based-on-a-dependent-drop-down-list-book4
Sheet: Template

 |  | Store Code |  |  |  | Account Name |  |  |  | Location
 |  | 103
 |  |  |  |  | Provider | Netflix
 |  | Product Name | Monthly Costs |  | Feature | Plan | Monthly Cost
 |  |  |  |  | Watch on mobile
 |  | No ads | 45
 |  | Family plan | 60
Spreadsheet: 04c03ccd-7b3a-4c3a-93fd-0970d0010723
Sheet: Tax Rates

MDE, Program Finance Division |  |  |  |  |  |  |  |  |  |  | 2012-02-17 00:00:00
 |  |  |  |  |  |  | [NAME] ADJUSTMENTS FOR NET TAX CAPACITY CHANGES IN TAX BILL
 |  |  |  |  |  |  | Effective for FY 2013, taxes payable in 2012
 |  |  |  |  |  |  | (Under First Special Session Laws 2011, Chapter 11, Article 1, Section 34
 |  |  |  | and Chapter 7, Article 6, sections 2, 3, 5, 6 and 27)
2010 Tax Rate and Equalizing Factor Adjustment Ratio
 |  | 2010 NTC |  | Ratio
Prior to Legislation |  | 6019613216 | = | 1.049605626
After Legislation |  | 5735119047
Tax Rate Adjustment
 | Previous Tax Rate times [NAME]
Equalizing Factor Adjustment
 | Previous Equalizing Factor divided by [NAME]
Adjustment to Equalizing Factors |  |  |  |  |  |  | Adjustment to Tax Rates
 |  | Old (Statutory) |  | Adjusted | New |  |  |  | Old (Statutory) | Adjusted | New
 | Program | Equal Factor |  | Eq Factor | Eq Factor |  |  | Program | Tax Rate | Tax Tate | Tax Rate
 | = | = |  | = | = |  |  | = | = | = | =
 | Operating Capital | 10700 |  |  |  |  |  | Standard Community Ed | 0.009
 | Alt Comp (Q Comp) | 5913
 |  |  |  |  |  |  |  | Tier 1 Debt Limit | 0.15
 |  |  |  |  |  |  |  | Tier 2 Debt Limit | 0.1
 | Health & Safety | 2935
 | Alternative Fac (Fund 1) | 2935 |  |  |  |  |  | [NAME] (old) | 0.28
 | Deferred Maintenance | 5900 |  |  |  |  |  | [NAME] (new)
 |  |  |  |  |  |  |  | (Dist 38 & Dist 707) | 0.32
 | School Age Care | 2433
 |  |  |  |  |  |  |  | Capital Loan threshold | 6.07
 |  |  |  |  |  |  |  | Capital Loan eligibility | 0.4
 | Debt Equalization
 | Tier I | 3200 |  |  |  |  |  | Mpls (only) Health Ins | 0.001 |  | 0.001
 | Tier II | 8000 |  |  |  |  |  | [NAME] (only) Severence | 0.0034 |  | 0.0036
Referendum Equalization, Equity and Transtion
 | (excluded from conversion since based on Referendum Market Value)
Spreadsheet: 167790d1342104749-cut-and-paste-calculation-example-excel-file
Sheet: Compound

compoundID | formulaName | strength | quantityToPrepare | notes
1 | compound A | 0.1 | 250gm
2 | compound B | 0.05 | 100gm
3 | compound C | 0.25 | 500gm
Spreadsheet: 700542d1603223948-iterating-sum-if-or-other-export-example
Sheet: Live

Plant | Release Day | Week | Helis | Orders
DN26 | Mon | 43
DN26 | Tue | 43
DN26 | Wed | 43
DN26 | Thu | 43
DN26 | Fri | 43
DN26 | Sat | 43
DN26 | Sun | 43
[NAME] | Mon | 43
[NAME] | Tue | 43
[NAME] | Wed | 43
[NAME] | Thu | 43
[NAME] | Fri | 43
[NAME] | Sat | 43
[NAME] | Sun | 43
DN22 | Mon | 43
DN22 | Tue | 43
DN22 | Wed | 43
DN22 | Thu | 43
DN22 | Fri | 43
DN22 | Sat | 43
DN22 | Sun | 43
DN14 | Mon | 43
DN14 | Tue | 43
DN14 | Wed | 43
DN14 | Thu | 43
DN14 | Fri | 43
DN14 | Sat | 43
DN14 | Sun | 43
DN45 | Mon | 43
DN45 | Tue | 43
DN45 | Wed | 43
DN45 | Thu | 43
DN45 | Fri | 43
DN45 | Sat | 43
DN45 | Sun | 43
DN25 | Mon | 43
DN25 | Tue | 43
DN25 | Wed | 43
DN25 | Thu | 43
DN25 | Fri | 43
DN25 | Sat | 43
DN25 | Sun | 43
[NAME] | Mon | 43
[NAME] | Tue | 43
[NAME] | Wed | 43
[NAME] | Thu | 43
[NAME] | Fri | 43
[NAME] | Sat | 43
[NAME] | Sun | 43