tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 69831d1270504199-lookup-to-return-multiple-rows-example
Sheet: Sheet1

 | ALK |  |  |  | AAI | ALK | AMR | CAL | DAL | [NAME] | LCC | LUV | UAUA | GOL | TAM | GLS | AYR | CPA
 |  |  |  |  | ALGT US | AAI US | AAI US | AAI US | AAI US | LUV US | AAI US | AMR US | AAI US | AAI US | AMR US | AER US | AER US | AAI US
 |  |  |  |  | ALK US | ALGT US | ALGT US | ALGT US | ALGT US | AMR US | AER US | [NAME] | ALGT US | AMR US | CPA US | AYR US | LCC US | ALGT US
 |  |  |  |  | AMR US | AMR US | ALK US | ALK US | ALK US | UAUA US | ALGT US | CAL US | ALK US | CAL US |  | FLY US | FLY US | ALK US
 |  |  |  |  | CAL US | CAL US | CAL US | AMR US | AMR US | DAL US | ALK US | DAL US | AMR US | CPA US |  | CAL US |  | AMR US
 |  |  |  |  | CPA US | CPA US | CPA US | CPA US | CAL US | AAI US | AMR US | UAUA US | CAL US | DAL US |  | LCC US |  | CAL US
 |  |  |  |  | DAL US | DAL US | DAL US | DAL US | [NAME] | CAL US | CAL US | LCC US | CPA US |  |  | UAUA US |  | DAL US
 |  |  |  |  | HA US | HA US | HA US | HA US | LCC US | LCC US | DAL US | AAI US | DAL US |  |  | AAI US |  | [NAME]
 |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | LUV US | ALK US | HA US | ALK US | FDX US |  |  | [NAME] |  | LCC US
 |  |  |  |  | LCC US | LCC US | LCC US | LCC US | PNCL US | RJET US | [NAME] | RJET US | HA US |  |  | DAL US |  | LUV US
 |  |  |  |  | LUV US | LUV US | LUV US | LUV US | RJET US | ALGT US | LUV US | SKYW US | [NAME] |  |  | ALK US |  | PNCL US
 |  |  |  |  | PNCL US | RJET US | PNCL US | RJET US | SKYW US | SKYW US | RJET US | XJT US | LCC US |  |  | LUV US |  | RJET US
 |  |  |  |  | RJET US | SKYW US | RJET US | SKYW US | UAUA US | HA US | SKYW US | ALGT US | LUV US |  |  | CPA US |  | SKYW US
 |  |  |  |  | SKYW US | UAUA US | SKYW US | UAUA US | XJT US | XJT US | UAUA US | CPA US | RJET US |  |  | CRDN US |  | UAUA US
 |  |  |  |  | UAUA US |  | UAUA US | XJT US |  | PNCL US | XJT US | FDX US | SKYW US
 |  |  |  |  | XJT US |  | UPS US |  |  | CPA US |  | PNCL US | UPS US
 |  |  |  |  |  |  | XJT US |  |  |  |  | UPS US | XJT US
Spreadsheet: john_zufferli__16821__Can Gas Stack & Website for New Version 121901
Sheet: Can Gas - Website

WEBSITE ACCESS |  |  |  | Read
CAN GAS |  |  |  | Execute
 |  |  |  | None
Name | Position | Book Name Website Log In  OR READ ONLY WEBSITE | Tenor  (1-120 Months) | CAN Gas Fin BasSwap (1062) | CAN Gas Fin BasSwap East (1280) | CAN Gas Fin Option (1992) | CAN Gas Fin Swap (1063) | CAN Gas Fin Swap (Internal Only) (1984) | CAN Gas Fin Swap East (1278) | CAN Gas Straddle Option (2021) | CAN Gas Phy Basis East Spd <or= 1Mo (2131) | CAN Gas Phy Basis East Spd >1Mo<1Yr (2132) | CAN Gas Phy Basis Firm East <or= 1Mo (1184) | CAN Gas Phy Basis Firm East >1Mo<1Yr (1185) | CAN Gas Phy Basis Firm West <or= 1Mo (2128) | CAN Gas Phy Basis Firm West >1Mo<1Yr (2129) | CAN Gas Phy Fwd Firm East <or= 1Mo (1179) | CAN Gas Phy Fwd Firm East Spd <or= 1Mo (2193) | CAN Gas Phy Fwd Firm West <or= 1Mo (1182) | CAN Gas Phy Fwd Firm West >1Mo<1Yr (1183) | CAN Gas Phy Index Firm East <or= 1Mo (2114) | CAN Gas Phy Index Firm East >1Mo<1Yr (2115) | CAN Gas Phy Index Firm West <or= 1Mo (1186) | CAN Gas Phy Index Firm West >1Mo<1Yr (1187)
[NAME] | AECO Cash Trader |  | 1 | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
[NAME] | AECO Cash Trader |  | 36 | Execute | Execute | Read | Execute | Execute | Execute | Read | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute
[NAME] | AECO Term Trader |  | 36 | Execute | Execute | Read | Execute | Execute | Execute | Read | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute
Stephane Brodeur | BC Cash Trader |  | 1 | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
[NAME] | BC Cash Trader |  | 36 | Execute | Execute | Read | Execute | Execute | Execute | Read | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute
[NAME] | BC Term Trader |  | 36 | Execute | Execute | Read | Execute | Execute | Execute | Read | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Execute
Lon Draper | Options Trader |  | 36 | Execute | Read | Execute | Execute | Execute | Read | Execute | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
Cooper Richey | Power Trader |  | 24 | Execute | Read | Read | Execute | Execute | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
[NAME] | VP-Canada Trading |  | [NAME] | Execute | Execute | Execute | Execute | Execute | Execute | Execute | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read | Read
Spreadsheet: daren_farmer__5353__hpl0708
Sheet: Sheet1

HPLN0708.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective July 8, 2000
 |  |  |  |  |  | ** Sat / Sun | ** Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 7/8-9/2000 | 2000-07-10 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 60  0900hrs | 0 to 0  0900hrs | 0 to 60  0900hrs | *
 |  |  |  |  | 60  to 0 2100hrs | 0  to 0 00hrs | 60  to 0 2100hrs | *
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | ENA | 8 | 8 | 8
Enron (S) |  | Texoma |  | ENA | 10 | 40 | 40
Enron (S) |  | Oasis Sealy |  | ENA | 40 | 40 | 40
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 3.6 | 3.6 | 3.6
Empire (Enron) |  | Sterling Plant |  | Empire | 5 | 5 | 5
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 146297d1332065608-excel-2007-shift-data-up-if-there-is-any-empty-cell-book1
Sheet: after  Sheet2 

 | twelfth was delete from after sheet1
 | first
 | second
 | third
 | fourth
 | fifth
 | sixth
 | seventh
 | eighth
 | ninth
 | tenth |  |  |  | the empty cell becoum this cell because the data was shifted
Spreadsheet: 170752d1343395019-losing-leading-zeros-vlookup-forum
Sheet: Sheet1

Download From |  |  |  |  | Download From
Data Warehouse |  |  |  |  | Client | My | Pete_UK | JosephP
 |  |  |  |  |  | Vlookup
Isbn
[PHONE] | 715338366 | [PHONE] | 100 |  | 9780715338360 | #N/A | #N/A | #N/A
[PHONE] | 276443918 | [PHONE] | 100
[PHONE] | 276444043 | [PHONE] | 100
[PHONE] | 276444213 | [PHONE] | 100
[PHONE] | 276445031 | [PHONE] | 100
[PHONE] | 027644504 | 027644504X | 100
[PHONE] | 670869805 | [PHONE] | 100
[PHONE] | 715300008 | [PHONE] | 100
[PHONE] | 715300016 | [PHONE] | 100
[PHONE] | 715300032 | [PHONE] | 100
[PHONE] | 715300040 | [PHONE] | 100
Spreadsheet: 787888d1658138191-sum-of-ytd-on-base-of-cell-value-book1-2-
Sheet: Sheet1

WH Name | Month DD Saving | YTD DD Saving | Month TT Saving | YTD TT Saving | Total Saving MTD | Total Saving YTD | 2022-03-01 00:00:00
D.G.Khan wh | 14300 | 14800 | 5225 | 17875
Taunsa WH | 0 | 1020 | 0 | 0
[NAME] | 3300 | 56650 | 3025 | 5637.5
WH Name | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
D.G.Khan wh | 0 | 0 | 14300 | 500
Taunsa WH | 720 | 40 | 0 | 300
[NAME] | 42900 | 10450 | 3300
Spreadsheet: ddb7192b-7ec4-4eb4-8984-582efded002b
Sheet: Sheet1

Agency | Name | Phone Number | E-mail address | Name.1 | Phone Number.1 | E-mail address.1 | Name.2 | Phone Number.2 | E-mail address.2
Aging | [NAME] | 783-5166 | [EMAIL] | [NAME] | 783-8613 | [EMAIL]
Agriculture | [NAME] Smyser | 787-1065 | [EMAIL] | [NAME] | 787-1065 | [EMAIL] | Ericka Warner | 787-1065 | [EMAIL]
Banking & Securities | [NAME] | 783-3611 | [EMAIL]
Civil Service Commission | [NAME] | 783-2691 | [EMAIL]
Community and Economic Development | [NAME] | 346-7788 | [EMAIL] | [NAME] | 346-7784 | [EMAIL]
Conservation and Natural Resources | [NAME] | 346-3962 | [EMAIL] | [NAME] | 705-3741 | [EMAIL]
Corrections | [NAME] | 728-5355 | [EMAIL] | [NAME] | 728-5351 | [EMAIL]
Drug & Alcohol Programs | [NAME] | 783-5446 | [EMAIL]
Education | [NAME] | 783-9343 | [EMAIL]
Environmental Protection | Renata E. Moseley | 787-8476 | [EMAIL]
Executive Offices | [NAME] | 783-5446 | [EMAIL]
Fish And Boat Commission | [NAME] | 705-7825 | [EMAIL]
Game Commission | [NAME] | 787-7836 | [EMAIL]
General Services | [NAME] | 783-0828 | [EMAIL]
Governor's Office | [NAME] | 787-5330 | [EMAIL]
Health | [NAME] | 547-3197 | [EMAIL]
Historical & Museum Commission | [NAME] | 783-5446 | [EMAIL]
Insurance | [NAME] | 787-8027 | [EMAIL]
Labor & Industry | [NAME] | 787-2453 | [EMAIL]
Lieutenant Governor's Office | [NAME] | 783-5446 | [EMAIL]
Liquor Control Board | [NAME] | 783-9853 | [EMAIL]
Military and Veterans Affairs | [NAME] | 861-6500 | [NAME] | [NAME] | 861-8850 | [EMAIL]
Milk Marketing Board | [NAME] | 783-5446 | [EMAIL]
Municipal Retirement Board | [NAME] | 787-2065 | [EMAIL]
PA Emergency Management Agency | [NAME] | 651-2018 | [EMAIL]
PA Human Relations Commission | [NAME] | 783-5446 | [EMAIL]
Pennvest | [NAME] | 783-5446 | [EMAIL]
Probation And Parole Board | [NAME] | 787-5699 x 216 | [EMAIL]
Psers | [NAME] | 720-4738 | [EMAIL] | [NAME] | 720-4739 | [EMAIL]
Public Utility Commission | [NAME] | 787-8714 | [EMAIL]
Public Welfare | [NAME] | 525-5477 | [EMAIL] | [NAME] | 783-9310 | [EMAIL]
Revenue | [NAME] | 787-2709 | [EMAIL] | [NAME] | 787-2709 | [EMAIL]
State | [NAME] | 783-9274 | [EMAIL] | [NAME] | 787-6604 | [EMAIL]
State Emp Retirement Board | [NAME] | 237-0242 | [EMAIL] | [NAME] | 237-0265 | [EMAIL]
State Police | [NAME] | 705-6801 | [EMAIL] | [NAME] | 783-5547 | [EMAIL]
State Tax Equalization Board | [NAME] | 787-5950 | [EMAIL]
Transportation | [NAME] | 783-0331 | [EMAIL] | [NAME] | 265-7662 | [EMAIL]
Revised 9/25/13
Spreadsheet: 47484d1246512101-count-unique-values-based-on-another-column-pivot-1
Sheet: Data

Task | Name | Updated
1 | User1 | Yes
2 | User2 | Yes
3 | User3 | Yes
4 | User4 | No
5 | User1 | Yes
6 | User2 | Yes
7 | User3 | Yes
8 | User4 | No
Spreadsheet: 150283d1334380254-multiple-count-and-sum-values-multiple-count-and-sum
Sheet: Sheet1

 |  |  | how many | value
2012-04-01 00:00:00 | apple | 2.5
2012-04-01 00:00:00 | orange | 6.8
2012-04-01 00:00:00 | orange | 3.5
2012-04-02 00:00:00 | apple | 5.7
2012-04-02 00:00:00 | apple | 7.8
Spreadsheet: 1b1dff68-4be2-4f4e-95fa-a53294cb9398
Sheet: Sheet1

UNIVERSITY OF HAWAI‘I | Unnamed: 1 | Unnamed: 2
CONTINUING EDUCATION ENROLLMENT
FALL 2013
TABLE OF CONTENTS
Table 1 |  | Continuing Education Enrollment, By [NAME]
 |  | Fall 2013
Table 2 |  | Continuing Education Enrollment, By [NAME]
 |  | Fall 2003 to Fall 2013
Table 3 |  | Continuing Education Enrollment, UH Mānoa
 |  | Fall 2013
Table 4 |  | Continuing Education Enrollment, UH Hilo
 |  | Fall 2013
Table 5 |  | Continuing Education Enrollment, Community Colleges
 |  | Fall 2013
Spreadsheet: 137229d1327006400-fix-formulas-so-there-are-no-duplicates-copy_dummy-file-formulas-made-duplicates
Sheet: Formula Sheet

Name |  | Company | Purpose | Start Date | End Date
Date | Payee | Type of Expense | Purpose | Individuals/Companies | Amount
I CERTIFY THAT THE ABOVE EXPENSES HAVE BEEN INCURRED BY ME ONLY ON BEHALF OF THE COMPANY AND HAVE NOT BEEN PREVIOUSLY PAID OR REIMBURSED BY THE COMPANY. |  |  |  | Balance Due Employee:
Signature of Employee |  |  |  | Date
Approval by Immediate Supervisor |  |  |  | Date
Spreadsheet: 89266d1289012111-how-to-grab-last-updated-data-test
Sheet: Sheet1

Num | [NAME] |  | Num | [NAME]
1 | 1.1 |  | 1 | 1.3
1 | 1.2 |  | 2 | 1.2
1 | 1.3 |  | 3 | 1.4
2 | 1.3 |  | 4 | 1.3
2 | 1.2 |  | 5 | 1.6
3 | 1.1 |  | 6 | 1.4
3 | 1.4
4 | 1.2
4 | 1.5
4 | 1.3
5 | 1.9
5 | 1.6
5 | 1.7
6 | 1.5
6 | 1.4
Spreadsheet: 733562d1621622557-need-help-with-a-formula-to-give-pass-fail-results-for-items-with-different-limits-test-sheet
Sheet: Sheet1

 |  |  |  |  |  |  | limits
 | Sample | results | Pass/Fail |  |  |  | A61 | A33 | A29 | A58
 | A61 | 0.14 | Pass |  |  |  | 13% - 15% | 3%-5% | 4%-6% | 9%-11% | Pass
 | A58 | 0.1 | Pass
 | A33 | 0.025 | Fail
 | A61 | 0.11 | Fail
 | A61 | 0.155 | Fail
 | A29 | 0.045 | Pass
 | A58 | 0.105 | Pass
Spreadsheet: 28140d1222097994-pivot-table-counting-blank-cells-in-data-table-exapmle
Sheet: Sheet1

 | Primary Category | Severns | Fens | Cullum
 | Recruitment
 | Recruitment
 | Uncategorised | AMBROSE
 | Uncategorised
 | Recruitment
 | Recruitment
 | Recruitment
 | Recruitment | BACK UP STAFF
 | Uncategorised
 | Recruitment | BEST CON
 | Recruitment
 | Recruitment
 | Distribution fleet & warehousing
 | Recruitment
 | Site services
 | Site services
 | Recruitment
 | Recruitment | AMION
 | Uncategorised | AMION
 | Site services
 | Recruitment
 | Recruitment
 | Recruitment
 | Distribution fleet & warehousing | CRS
 | Recruitment
 | Recruitment
 | Recruitment
Spreadsheet: 454168d1459693770-vlookup-help-with-making-automatic-system-book3-1-
Sheet: Staff

STAFF |  | ANIMALS
Job | Salary | Number | Total
Veterinary Surgeon
Veterinary Nurse
Animal Attendant
Trainer
- | - |  | -
 |  | Total salary cost
Budget used
Budget Remaining
Spreadsheet: 453481d1459342269-trouble-with-returning-min-value-based-on-an-index-match-approach-return-price
Sheet: Initial Population

LoanNumber | Final Price | Target Price | RATE
12345 | 99 | 101 | 1
12345 | 101 | 101 | 2
12345 | 101.25 | 101 | 3
67890 | 103.25 | 103 | 1
67890 | 103.5 | 103 | 2
67890 | 103.75 | 103 | 3
54321 | 99 | 100.5 | 1
54321 | 100.75 | 100.5 | 2
54321 | 101 | 100.5 | 3
Spreadsheet: 0a3ce3be-dd49-4a7d-a86e-59239ba01879
Sheet: Sheet1

11/12 Base Budget per Finance calculations | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Budget Developer: | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
Reduction to Base requested, if applicable |  |  |  | Provide detailed rationale
 | Adjusted 11/12 Base Budget |  | 0
2.5% Target per Finance calculations |  |  | 0
1.5% Target per Finance calculations |  |  | 0 |  | Faculty/Unit:
Summary of Prioritized Proposals
Priority No. | Provide Brief Description or Cost Center | Cost Reduction |  |  |  |  |  | Revenue Enhancement |  | Indicate Budget Year |  | Reference: Supporting Documentation Including Implications
 |  | Non-Salary |  | Salaries |  | Benefits
 |  | One Time | Ongoing | One Time | Ongoing | One Time | Ongoing | One Time | Ongoing | 12/13 | 13/14
 | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total One Time | 0 |  | Total Ongoing | 0
 | Total Amount of Target Submission | 0
Spreadsheet: 80808d1280991337-problem-with-chart-when-time-spans-midnight-bok2
Sheet: Blad1

Example
 | A | B | C | D | E | F | G | H
2010-07-22 15:00:00 | 0 | -0.00173611112404615 | -0.0115740746259689 | 9.27430534362793 | 2.70833349227905 | 2.70833349227905 | 2.78356504440308 | 2.78356504440308
2010-07-22 15:00:01 | 0 | -0.00173611112404615 | -0.0115740746259689 | 9.27430534362793 | 2.70254635810852 | 2.70254635810852 | 2.77777791023254 | 2.77777791023254
2010-07-22 15:00:02 | 0 | -0.00173611112404615 | -0.00578703731298447 | 9.27430534362793 | 2.71412038803101 | 2.71412038803101 | 2.78356504440308 | 2.78356504440308
2010-07-22 15:00:03 | 0 | -0.00173611112404615 | -0.0115740746259689 | 9.27430534362793 | 2.70833349227905 | 2.70833349227905 | 2.78356504440308 | 2.78356504440308
2010-07-22 15:00:04 | 0 | -0.00173611112404615 | -0.00578703731298447 | 9.27430534362793 | 2.70254635810852 | 2.70833349227905 | 2.77777791023254 | 2.78356504440308
2010-07-22 15:00:05 | 0 | -0.00173611112404615 | -0.0115740746259689 | 9.27430534362793 | 2.70833349227905 | 2.71412038803101 | 2.78356504440308 | 2.78356504440308
2010-07-22 15:00:06 | 0 | -0.000868055562023073 | -0.0115740746259689 | 9.27430534362793 | 2.70254635810852 | 2.70833349227905 | 2.78356504440308 | 2.77777791023254
2010-07-22 15:00:07 | 0 | -0.00173611112404615 | -0.00578703731298447 | 9.27430534362793 | 2.70833349227905 | 2.70833349227905 | 2.78356504440308 | 2.78356504440308
2010-07-22 15:00:08 | 0 | -0.00173611112404615 | -0.0115740746259689 | 9.27430534362793 | 2.70833349227905 | 2.70833349227905 | 2.78356504440308 | 2.78356504440308
2010-07-22 15:00:09 | -0.00578703731298447 | -0.00173611112404615 | -0.0115740746259689 | 9.27430534362793 | 2.70254635810852 | 2.70833349227905 | 2.77777791023254 | 2.77777791023254
2010-07-22 15:00:10 | 0 | -0.00173611112404615 | -0.0115740746259689 | 9.27430534362793 | 2.70833349227905 | 2.70833349227905 | 2.78356504440308 | 2.78356504440308
2010-07-22 15:00:11 | 0 | -0.00173611112404615 | -0.0115740746259689 | 9.27430534362793 | 2.70833349227905 | 2.71412038803101 | 2.78356504440308 | 2.78356504440308
Spreadsheet: 116091d1311597349-excel-claim-sorting-claims-sorting-tracker-cst-
Sheet: Claims Sorted

2011-08-01 00:00:00 | 2007-07-31 00:00:00
Serial | Date | Paid | Oustanding | Total | Title
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0 |  |  | 2011-08-01 00:00:00 |  |  |  |  | Do not delete
0 |  | 0 | 0 | 0 | 0 |  |  | 2011-08-01 00:00:00 | To | 2012-07-31 00:00:00 |  |  | 0 | 12
0 |  | 0 | 0 | 0 | 0 |  |  | 2010-08-01 00:00:00 | To | 2011-07-31 00:00:00 |  |  | -12 | 0
0 |  | 0 | 0 | 0 | 0 |  |  | 2009-08-01 00:00:00 | To | 2010-07-31 00:00:00 |  |  | -24 | -12
0 |  | 0 | 0 | 0 | 0 |  |  | 2008-08-01 00:00:00 | To | 2009-07-31 00:00:00 |  |  | -36 | -24
0 |  | 0 | 0 | 0 | 0 |  |  | 2007-08-01 00:00:00 | To | 2008-07-31 00:00:00 |  |  | -48 | -36
0 |  | 0 | 0 | 0 | 0 |  |  | 2006-08-01 00:00:00 | To | 2007-07-31 00:00:00 |  |  | -60 | -48
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0 |  |  | Note: | Select the date from Cell A1
0 |  | 0 | 0 | 0 | 0 |  |  |  | Copy paste the formula in A3:F3 below
0 |  | 0 | 0 | 0 | 0 |  |  |  | Hide column M:O
0 |  | 0 | 0 | 0 | 0 |  |  |  | there is similar formula in A3&C3:F3
0 |  | 0 | 0 | 0 | 0 |  |  |  | There is separate formula in B3
0 |  | 0 | 0 | 0 | 0 |  |  |  | These are array formulas and should be confirmed throgh Ctrl+Shift+Enter
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
#N/A |  | #N/A | #N/A | #N/A | #N/A
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
0 |  | 0 | 0 | 0 | 0
Spreadsheet: 888434d1738930254-filter-tocol-dynamic-formula-filterattempt2
Sheet: Desired result

APPLE | BELGIUM | FRANCE | GERMANY | ITALY | SPAIN | SWITZERLAND
APPLE | 99 | 78 | 71 | 63 | 84 | 46
APPLE1 | 75 | 40 | 92 |  | 95
APPLE2 | 10 | 76 | 37 |  | 65
Spreadsheet: 677d79ba-5924-4b99-a7db-edb9cd8e2e19
Sheet: dsRNA primers

Primers used for dsRNA synthesis.
Gene ID | Primer Name | Sequence (5’ to 3’)
AAEL007768 | dsMyD88 F | TAATACGACTCACTATAGGGGGCGATTGGTGGTTGTTATT
AAEL007768 | [NAME] R | TAATACGACTCACTATAGGGTTGAGCGCATTGCTAACATC
AAEL010083 | dsIMD F | TAATACGACTCACTATAGGGACCGAAGAAGACCGCACAAGGC
AAEL010083 | dsIMD R | TAATACGACTCACTATAGGGTGCCGAGCGTTGGTTCGTCG
AAEL012471 | dsDomeF | TAATACGACTCACTATAGGGCCATCTCCACCACGAAACTT
AAEL012471 | dsDome R | TAATACGACTCACTATAGGGCCGGTGGTTGCCATATAATC
AAEL006794 | dsDcr2 F | TAATACGACTCACTATAGGGGCATTGACGACGAAATCATCGTCCGATG
AAEL006794 | dsDcr2 R | TAATACGACTCACTATAGGGACCATGGCATCCGCCGGTGTCTTGTCC
AAEL011414 | dsHMGB F | TAATACGACTCACTATAGGGCGCCAAGCGAGGTGGTGAGC
AAEL011414 | dsHMGB R | TAATACGACTCACTATAGGGGTCCTTGCCGCCGCCATTTC
AAEL010429 | dsAller F | TAATACGACTCACTATAGGGAGACCAGCCCCGAGTTCAAGG
AAEL010429 | dsAller R | TAATACGACTCACTATAGGGCCCCAGCCGAAGAAACCGGC
AAEL012819 | [NAME] | TAATACGACTCACTATAGGGAAGGCCGCCGAAAAGGTCGG
AAEL012819 | [NAME] | TAATACGACTCACTATAGGGGTGAGAGCTGAGGGCCCGGT
AAEL002579 | dsHP2579 F | TAATACGACTCACTATAGGGAACGCTGAACCAACATGTGC
AAEL002579 | dsHP2579 R | TAATACGACTCACTATAGGGAATTCTGCTGTGTCCCTCCG
AAEL002430 | dsN-Gluc F | TAATACGACTCACTATAGGGTTACGCATGGGGTCACTTCC
AAEL002430 | dsN-Gluc R | TAATACGACTCACTATAGGGTCGCGATGATGGAACGGTAG
AAEL010599 | [NAME] | TAATACGACTCACTATAGGGATGGATTTCAGCTTCCCGCA
AAEL010599 | [NAME] | TAATACGACTCACTATAGGGGGCAGAGGAGCTTTTCCAGT
AAEL012092 | dsLRRprot F | TAATACGACTCACTATAGGGCCTGCCTCGGTTGGCACTGG
AAEL012092 | dsLRRprot R | TAATACGACTCACTATAGGGGACCAGCTTGCCGGACGTGA
AAEL015458 | dsTsf F | TAATACGACTCACTATAGGGTAGGAGGCGCCCCAGCCAAA
AAEL015458 | dsTsf R | TAATACGACTCACTATAGGGAGGCCGGACGGACATCACGA
AAEL002833 | dsCatL F | TAATACGACTCACTATAGGGACTGCGGCTCGTGTTGGTCG
AAEL002833 | dsCatL R | TAATACGACTCACTATAGGGGCGCTTCCTCGTCACCCTGG
AAEL004758 | dsPcut F | TAATACGACTCACTATAGGGTTGGCGACCCTTCTGGCTGC
AAEL004758 | dsPcut R | TAATACGACTCACTATAGGGACCTCATCTCCGTGGCGGGT
NA | dsGFP F | TAATACGACTCACTATAGGATGGTGAGCAAGGGCGAGGAGCTGT
NA | dsGFP R | TAATACGACTCACTATAGGTTACTTGTACAGCTCGTCCATGCCG
Spreadsheet: 796455d1663283359-need-to-calculate-the-mileage-mileage-rounded-down-for-7-and-under-and-up-for-8-minutes-invoice-wkending-9-11-2022-copy
Sheet: Invoice

[Company Name] |  |  |  |  |  | INVOICE
Ny Name |  |  |  |  |  |  |  |  | INVOICE TEMPLATES BY VERTEX42.COM
My Address |  |  |  |  |  |  |  |  | https://www.vertex42.com/ExcelTemplates/invoice-templates.html
Address continued |  |  |  |  | INVOICE # |  | DATE
Phone: (000) 000-0000 |  |  |  |  | 1001 |  | 2022-09-07 00:00:00
BILL TO |  |  |  |  | CUSTOMER ID |  | TERMS |  | [NAME] can change TERMS to DUE DATE and enter a date (usually 30 days after the invoice date)
My Client Name |  |  |  |  |  |  | 7 days
Clients Address | Clients
Clients Address Continued
State and Zip Code |  |  |  |  |  |  |  |  | HOW TO SEND AN INVOICE TO A CLIENT
[Phone] | [PHONE] |  |  |  |  |  |  |  | 1) Save or Print the worksheet as a PDF
[NAME] |  |  |  |  |  |  |  |  | 2) Save a copy of the invoice for your records
 |  |  |  |  |  |  |  |  | 3) Email the PDF to the client
[NAME] |  |  |  |  | QTY | UNIT PRICE | AMOUNT
Service Fee |  |  |  |  | 1 | 30
Mileage |  |  |  |  |  | 7.5
Total |  |  |  |  |  |  |  |  | ← The QTY is assumed to be 1 if it is left blank
Thank you for your business! |  |  |  |  | SUBTOTAL
 |  |  |  |  | TAX RATE |  | 0.0425 |  | [NAME] the appropriate tax rate
 |  |  |  |  | TAX
 |  |  |  |  | TOTAL |  |  |  | [NAME] the currency by editing the cell format
 |  |  |  |  |  |  |  |  | [NAME] a note such as "Paid in full. Thank you!" if this is a receipt
If you have any questions about this invoice, please contact
[Name, Phone, [EMAIL]] |  |  |  |  |  |  |  |  | [NAME] to update this information, or delete these two rows.
Spreadsheet: 43773d1242386570-cell-formatting-research
Sheet: main requirement

Projects | Resources | Jan | Feb | [NAME] | June | July | Aug
Requirement by projects |  | Jan | Feb | Mar | Apr | May | June | July
M | X | 1 | 2 | 2 |  |  | 1 | 5
A | Y |  | 1 | 3 | 1 | 1 | 4 | 9
A | Z | 1 | 2 |  |  |  |  | 7
M | X |  |  | 2 |  | 1 | 4 | 7
B | Y | 1 | 2 | 4 |  | 4 |  | 3
H | X | 5 |  |  |  |  |  | 8
B | Z |  | 3 | 3 | 3 | 1 | 1 | 7
M | y | 2 |  |  |  |  |  | 2
M | Z | 1 |  | 4 |  |  | 4 | 7
C | X | 1 | 1 | 1 | 1 | 1 |  | 8
C | Y |  | 1 | 4 |  |  |  | 8
D | Z |  | 4 |  |  | 2 | 2 | 8
D | X | 2 | 5 |  | 1 | 4 |  | 8
D | Y | 1 | 2 | 6 |  |  |  | 8
D | Z | 1 | 1 |  | 2 |  |  | 8