tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 883688d1732320077-filtering-a-list-down-to-display-only-items-with-annual-due-dates-matching-current-month-sampleannual
Sheet: Items

 | [NAME]
 | Item | ItemType | Due Date | Column1 | Column2 | Column3 | Balance
 | [NAME] | Expense1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | All Fixed Expenses | Due Date | Type of Expense
 | item2 | AnnualExpense | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense1
 | item3 | AnnualExpense | 1 |  |  |  |  |  | Expense1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense2
 | item4 | Expense2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense3
 | [NAME] | Expense1 | 3 |  |  |  |  |  | Expense2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense4
 | item6 | Expense2 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense5
 | [NAME] | Expense4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense6
 | item8 | Expense1 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AnnualExpense
 | item9 | Expense1 | 6 |  |  |  |  |  | Expense4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense8
 | item10 | Expense2 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expense9
 | item11 | Expense2 | 6 |  |  |  |  |  | Expense5
 | item12 | Expense2 | 7
 | item13 | Expense2 | 7 |  |  |  |  |  | Expense6
 | item14 | Expense8 | 7
 | item15 | AnnualExpense | 8 |  |  |  |  |  | Expense7
 | item16 | Expense1 | 10
 | item17 | Expense1 | 10 |  |  |  |  |  | Expense8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense1 | Due Date
 | item18 | Expense8 | 11
 | item19 | Expense4 | 11
 | item20 | Expense4 | 11
 | item21 | AnnualExpense | 11
 | item22 | AnnualExpense | 12
 | item23 | Expense1 | 12
 | item24 | Expense2 | 14
 | item25 | AnnualExpense | 15
 | item26 | Expense2 | 16
 | item27 | Expense1 | 18
 | item28 | Expense8 | 18
 | item29 | Expense8 | 19
 | item30 | Expense2 | 20
 | item31 | AnnualExpense | 21
 | item32 | Expense2 | 24
 | item33 | AnnualExpense | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense2 | Due Date
 | [NAME] | Expense2 | 26
 | item35 | AnnualExpense | 26
 | item36 | AnnualExpense | 28
 | item37 | Expense4 | 29
 | item38 | Expense9 | Paycheck
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense4 | Due Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | AnnualExpense | Due Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expenses124 | Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense6 | Due Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense7 | Due Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Expense8 | Due Date
Spreadsheet: 813868d1674036921-stack-columns-stack_columns
Sheet: HAVE

NAME | OPERATOR | SAMPLE 1 | OPERATOR | SAMPLE 2
X | = | 1 | < | 3
Y | = | 2 | = | 1
Z | < | 1 | = | 4
Spreadsheet: 756194d1637330922-help-please-on-time-sheet-current-time-sheet-19022021
Sheet: Rate of Pay

 |  | Sunday
 |  | Monday | 30.2526
 |  | Tuesday | 30.2526
 |  | Wednesday | 30.2526
 |  | Thursday | 30.2526
 |  | Friday | 30.2526
 |  | Saturday
 |  | VOT ( Sat- Sun & P. Holiday)
 |  | VOT ( Mon - Fri )
 |  | DOC
 |  | Penalty rates
 |  | Public Holiday
 |  | PM Shift plus 15% | 4.5378
Spreadsheet: 471034d1468848424-creating-pivottable-from-summarised-data-pe
Sheet: Summary

Sum of Value | Column Labels
Row Labels | Jan | Feb | Mar | Apr | May | Jun | Grand Total
Expense | 15 | 16 | 18 | 10 | 9 | 7 | 75
Gross | 10 | 12 | 14 | 15 | 11 | 5 | 67
Profit | 31 | 60 | 33 | 5 | 38 | 30 | 197
Sales | 56 | 88 | 65 | 30 | 58 | 42 | 339
(blank)
Grand Total | 112 | 176 | 130 | 60 | 116 | 84 | 678
Spreadsheet: 786541d1657256807-problem-with-ifs-or-multiple-if-excel-forum-aligw
Sheet: Sheet1

 | XX_Account | YY_Account | ZZ_Account |  |  |  | No. | Code |  | SubCode | Result | Problem | When the criteria met is separated, the result comes out right
 | XX001 | YY001 | ZZ001 |  |  |  | 1 | IO | SubCode1 | XX001 |  | -
 | XX002 | YY002 | [NAME] |  |  |  |  |  | SubCode2 | [NAME]
 | [NAME] | [NAME] | ZZ003
 | XX004 | YY004 | ZZ004 |  |  |  | 2 | BT | SubCode1 | [NAME] |  | The condition meets criteria no. 3, but the result = Error.
 | XX005 | YY005 | ZZ005 |  |  |  |  |  | SubCode2 | ZZ005
 |  |  |  |  |  |  | 3 | JP | SubCode1 | XX004 |  | The condition meets criteria no. 4, but the result = Error.
 |  |  |  |  |  |  |  |  | SubCode2 | ZZ004
 | Criteria:
 | - IF Code = "", the result = ""
 | - IF Code = IO and SubCode1's match value > 0, the result = "Clear"
 | - IF Code = BT and SubCode1's match value > 0, the result = "Clear"
 | - IF Code = JP, SubCode1's match value > 0, SubCode2's match value > 0, the result = "Clear"
 | - IF there is no any criteria met, the result = "Error"
Spreadsheet: 168950d1342637683-spreadsheet-with-unknown-columns-cash-report-july-2012-v1
Sheet: Monthly Payables

Vendor | Day Pmt to be made |  | Amount | Balance | G/L Coding
ACS - Student Loan | 2012-07-15 00:00:00 | 15 | 477.17
American Professional Agency | 2012-09-01 00:00:00 | 1 | 697
AT&T Advertising | 2012-07-13 00:00:00 | 13 | 365.28
AT&T Mobile | 2012-02-27 00:00:00 | 26 | 791.69
Bancfirst | 2012-06-28 00:00:00 | 28 | 2068
BOA card #6843 | 2012-02-27 00:00:00 | 30 | 350
BOA card #8643 | 2012-02-24 00:00:00 | 26 | 350
[NAME] | 2012-02-22 00:00:00 | 18 | 500
Chase | 2012-07-17 00:00:00 | 17 | 150
Citicorp | 2012-07-06 00:00:00 | 6 | 823.46
Columbia Ins Group | 06-19-12 | 19 | 127.75 |  | PAID QUARTERLY - BUSINESS OWNERS INS.
Cox | 2012-03-19 00:00:00 | 13 | 328.82
Discover Card #4232 | 2012-07-05 00:00:00 | 5 | 275
Discover Card #8026 | 2012-07-05 00:00:00 | 5 | 275
GM Card - HSBC | 2012-06-29 00:00:00 | 2 | 350
Halliburton L5.1 | 2012-03-07 00:00:00 | 7 | 403.91 |  | Impala#1
Halliburton L5.4 | 2012-03-12 00:00:00 | 11 | 212.64 |  | Impala#2
Health Connex/My Client | 2012-02-23 00:00:00 | 23 | 93.4 |  | My Client
IRS FED W/H | 2012-02-08 00:00:00 | 8 | 6279.31
IRS FED W/H | 2012-02-22 00:00:00 | 22 | 5940.3
IRS Payment Plan | 2012-03-15 00:00:00 | 15 | 3000
OG&E | 2012-03-10 00:00:00 | 8 | 480.9
Oklahoma State Board Of Psychologist | 2012-12-31 00:00:00 | 20 | 400
Old Glory Insurance | 2012-03-08 00:00:00 | 8 | 261
ONG | 2012-03-16 00:00:00 | 16 | 250
Paypal - credit card | 2012-03-15 00:00:00 | 17 | 75
Paypal - HUB | 2012-03-20 00:00:00 | 13 | 149
Payroll Estimate | 2012-02-29 00:00:00 | semi-weeklky | 21000
Pikepass |  | 6 | 160
[NAME] | 2012-02-25 00:00:00 | 13 | 25
[NAME] Power | 2012-07-16 00:00:00 | 16 | 290.11
Progressive Insurance #08422890 | 2012-03-05 00:00:00 | 1 | 280.47 |  | Commercial Policy
Progressive Insurance #40991451-8 | 2012-02-29 00:00:00 | 29 | 322.13 |  | Personal Policy
River Oaks Properties | 2012-03-07 00:00:00 | 8 | 3678.5 |  | Rent on Office
[NAME] | 2012-03-14 00:00:00 | 13 | 280.66 |  | Rent at Integris
Smart Image Systems | 2012-06-27 00:00:00 | 27 | 391.22
State of Oklahoma - Oct withholding | 2012-02-20 00:00:00 | 20 | 2074
USA Vision | 2012-03-12 00:00:00 | 10 | 66.4 |  | Vision Insurance
Yellow Book West | 2012-04-02 00:00:00 | 2 | 1254.59
Spreadsheet: 70487d1271212403-applying-condition-if-to-a-range-of-cells-test
Sheet: Sheet1

CODE |  | Does it Match
RPI-MEX |  | yes
IPADE-MEX |  | yes
IPADE-MEX1 |  | yes
UPADE-MEX |  | yes
CL |  | yes
RPI-MEX-1 |  | yes
RPI-SUBS |  | yes
SLO |  | no
SLO-1 |  | no
SLO-CA |  | no
MARK-PALM |  | no
HI-12 |  | no
SBN-CA |  | no
FOUR-CA |  | no
SBN01 |  | no
SBN02 |  | no
SBN03 |  | no
SBN04 |  | no
SBN05 |  | no
SBN06 |  | no
SBN07 |  | no
SBN08 |  | no
SBN01-1 |  | no
SBN02-1 |  | no
SBN03-1 |  | no
SBN04-1 |  | no
SBN05-1 |  | no
SBN06-1 |  | no
SBN07-1 |  | no
SBN08-1 |  | no
UR-CA |  | no
DB-CA |  | no
BHHB-CA |  | no
DSP-CA |  | no
SDUT1-CA |  | no
DCR-SAN |  | no
RCC-SD |  | no
HSDR-CA |  | no
HLTP-CA |  | no
HSDG-CA |  | no
HDM-CA |  | no
RSF-CA |  | no
GGSDSU |  | no
SDEC |  | no
SDFB |  | no
SDKM |  | no
SDMG |  | no
SDMM |  | no
SDPC |  | no
SDRA |  | no
SDRB |  | no
SDRS |  | no
SDSB |  | no
SDSM |  | no
SDEC-1 |  | no
SDFB-1 |  | no
SDKM-1 |  | no
SDMG-1 |  | no
SDMM-1 |  | no
SDPC-1 |  | no
SDRA-1 |  | no
SDRB-1 |  | no
SDRS-1 |  | no
SDSB-1 |  | no
SDSM-1 |  | no
LAT5750 |  | no
LAT5751 |  | no
LAT5752 |  | no
SRMB-CA |  | no
RCC-SNA |  | no
DHSA-CA |  | no
DHI-CA |  | no
GI-007 |  | no
GGPEP3 |  | no
GGUI |  | no
JA/F |  | no
U2G |  | no
U2H |  | no
U2W |  | no
MADE-LA |  | no
CNUS-LOS |  | no
IMD-22 |  | no
MOS-BA |  | no
RBW-CA |  | no
RCC-LAX |  | no
U839-LAX |  | no
U891-LAX |  | no
U934-LOSA |  | no
UARC-LAX |  | no
UCLA2-CA |  | no
UCLA3-CA |  | no
CPC-LAX |  | no
DCR-LAX |  | no
FOU-CA |  | no
MILAIR-BUR |  | no
BMI-UT |  | no
HLA-CA |  | no
BHB-CA |  | no
HLAX-CA |  | no
DHC-CA |  | no
FMH-CA |  | no
MBH-LA |  | no
HSG-CA |  | no
HWH-CA |  | no
MBH1 |  | no
AALOS |  | no
SKYTA |  | no
AA-LAX4 |  | no
GGUSCM |  | no
GGGGU3 |  | no
GGPEP1 |  | no
GGPEP2 |  | no
GGPEP4 |  | no
GGPEP5 |  | no
DEL-283 |  | no
DEL-017 |  | no
LAT |  | no
LAT-1 |  | no
LAT-2 |  | no
LAT-3 |  | no
LAT5860 |  | no
LAT5887 |  | no
[NAME] |  | no
LAT5753 |  | no
HL-CA |  | no
CSULB-CA |  | no
LVRJ-NV |  | no
DCH-NV |  | no
CNUS-NV |  | no
LAWH2 |  | no
ADVE-LON-2 |  | no
Spreadsheet: 8ea71651-a9d7-47ae-9ab1-7582acd6346f
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
MLH12 | Test | MLH12 | MLH1/MSH2 Mutation Screen | MLH1/MSH2 Mutation Screen | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis and Gene Dosage Analysis by [NAME] (MLPA) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA Yellow-Top (ACD) Tube: ACD |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   [NAME] blood 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. [NAME] (Supply T519) 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. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Friday; 10 a.m. | 14 days | 20 days |  | Profile |  |  |  |  | Rochester
MLH12 | [NAME] | VARIES | Varies |  |  |  | Ambient
MLH12 | Result | 22804 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1
MLH12 | Result | 22806 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32630-6
MLH12 | Result | 22807 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
MLH12 | Result | 22805 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MLH12 | Result | 22808 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MLH12 | Result | 22800 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2
MLH12 | Result | 22802 | Source | Source | Alphanumeric
MLH12 | Result | 22809 | Reviewed By: | Reviewed By: | Alphanumeric
MLH12 | Result | 22810 | Release Date | Release Date | Alphanumeric
MLH12 | Billing Component | MLH12 |  | MSH2 GENE DUP/DELETE VARIANT |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81297
MLH12 | Billing Component | MLH12 |  | MLH1 GENE DUP/DELETE VARIANT |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81294
MLH12 | Billing Component | MLH12 |  | MSH2 GENE FULL SEQ |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81295
MLH12 | Billing Component | MLH12 |  | MLH1 GENE FULL SEQ |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81292
Spreadsheet: 680140d1590801933-excel-menu-using-1st-column-as-refernce-formatting-text-and-links-workbook-menu-idea
Sheet: Settings

 |  |  | Settings
 | Overview!A1
 | ESales!A1 |  |  | Menu Names
 | BCSales!A1 |  |  | Overview
 |  |  |  | E Sales
 | INV!A1 |  |  | BC Sales
 | MINV!A1 |  |  | Inventory
 | BULKINV!A1 |  |  | MINV
 |  |  |  | Bulk INV
 | Expenses!A1 |  |  | Expenses
 | Refunds!A1 |  |  | Refunds
 | 'Cost of good'!A1 |  |  | Cost of Goods
 |  |  |  | Mileage
 | Mileage!A1 |  |  | Settings
 | Settings!A1
Spreadsheet: 678780d1590059783-matching-and-replacing-cells-example
Sheet: Sheet1

Cat 1 | Cat 2 | Cat 3 | Changed too |  | Matches
1 | 2 | yes | Yep |  | one | 1
2 | 3 |  | three |  | two | too | 2
maybe |  | test | no |  | three | tree | tre | 3
 |  |  |  |  | yep | yes | no | maybe
Spreadsheet: 687665d1595341125-formula-help-if-countif-vlookup-excel-example
Sheet: Data

 | Sept | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Total
Positive
Neutral
Negative
Advertising
Sports
Mention
Spreadsheet: 24496d1214925455-highlight-minimum-values-test0
Sheet: Sheet1

B | M | K | B | M | K
949.13 | 1114.68 | 1083.81 | 1 | 0 | 0
1004.01 | 1179.13 | 1146.47 | 1 | 0 | 0
773.71 | 871.57 | 883.5 | 1 | 0 | 0
737.45 | 682.98 | 842.09 | 0 | 1 | 0
281.75 | 317.38 | 321.73 | 1 | 0 | 0
800.01 | 799.07 | 922.66 | 0 | 1 | 0
86.69 | 183.45 | 185.97 | 1 | 0 | 0
208.28 | 275.43 | 279.2 | 1 | 0 | 0
290.57 | 285.53 | 289.45 | 0 | 1 | 0
225.89 | 254.47 | 257.95 | 1 | 0 | 0
269.99 | 304.14 | 308.3 | 1 | 0 | 0
143.08 | 161.17 | 163.39 | 1 | 0 | 0
183.26 | 204.23 | 182.55 | 0 | 0 | 1
742.35 | 836.25 | 847.69 | 1 | 0 | 0
656.6 | 739.65 | 749.77 | 1 | 0 | 0
302.333 | 297.09 | 301.16 | 0 | 1 | 0
882 | 866.72 | 878.58 | 0 | 1 | 0
933.94 | 1052.07 | 1053.9 | 1 | 0 | 0
267.54 | 262.91 | 266.51 | 0 | 1 | 0
973.63 | 1096.78 | 1111.78 | 1 | 0 | 0
241.57 | 272.13 | 275.85 | 1 | 0 | 0
2055.55 | 2315.55 | 2347.21 | 1 | 0 | 0
296.45 | 272.94 | 338.52 | 0 | 1 | 0
251.37 | 247.01 | 250.4 | 0 | 1 | 0
215.11 | 245.16 | 251.63 | 1 | 0 | 0
202.37 | 227.97 | 231.09 | 1 | 0 | 0
135.73 | 155.61 | 135.21 | 0 | 0 | 1
303.8 | 342.23 | 346.91 | 1 | 0 | 0
438.06 | 414.33 | 500.22 | 0 | 1 | 0
296.45 | 272.94 | 338.52 | 0 | 1 | 0
360.15 | 332.13 | 411.26 | 0 | 1 | 0
438.06 | 414.34 | 500.22 | 0 | 1 | 0
143.57 | 141.08 | 143.02 | 0 | 1 | 0
168.56 | 165.64 | 177 | 0 | 1 | 0
201.39 | 197.91 | 200.61 | 0 | 1 | 0
243.53 | 274.33 | 274.81 | 1 | 0 | 0
155.82 | 153.12 | 155.22 | 0 | 1 | 0
165.62 | 162.76 | 164.98 | 0 | 1 | 0
186.2 | 209.76 | 212.62 | 1 | 0 | 0
172.97 | 169.98 | 172.3 | 0 | 1 | 0
194.53 | 191.16 | 193.78 | 0 | 1 | 0
274.4 | 309.1 | 313.34 | 1 | 0 | 0
963.83 | 919.08 | 1100.59 | 0 | 1 | 0
218.54 | 246.18 | 246.61 | 1 | 0 | 0
393.47 | 443.23 | 449.3 | 1 | 0 | 0
186.2 | 209.76 | 212.62 | 1 | 0 | 0
244.02 | 274.88 | 278.65 | 1 | 0 | 0
232.26 | 228.23 | 231.36 | 0 | 1 | 0
357.7 | 402.94 | 408.46 | 1 | 0 | 0
390.53 | 401.19 | 445.95 | 1 | 0 | 0
290.57 | 285.53 | 289.45 | 0 | 1 | 0
351.33 | 345.24 | 349.97 | 0 | 1 | 0
165.13 | 162.27 | 164.49 | 0 | 1 | 0
194.04 | 190.67 | 193.29 | 0 | 1 | 0
Spreadsheet: 772357d1647239772-formula-not-summing-up-correctly-linkline-workbook
Sheet: Duty Database

DATE | DAY | START TIME | FINISH TIME | TIME ON DUTY | 13/15 DAY | 9/10 DRIVE | 24 HR REST | REST | VEHICLE 1 | VEHICLE 2 | VEHICLE 3 | SKL/TRL 1 | SKL/TRL 2 | SKL/TRL3 | CONTAINER 1 | CONTAINER 2 | CONTAINER 3 | ID | 1 |  | START DATE: | END DATE: |  | From Prep | To Prep |  | DATE | DAY | START TIME | FINISH TIME | TIME ON DUTY | 13/15 DAY | 9/10 DRIVE | 24 HR REST | REST | VEHICLE 1 | VEHICLE 2 | VEHICLE 3 | SKL/TRL 1 | SKL/TRL 2 | SKL/TRL3 | CONTAINER 1 | CONTAINER 2 | CONTAINER 3 | ID
2022-03-10 00:00:00 |  | 06:00:00 | 18:00:00 |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-03-10 00:00:00 | 2022-03-14 00:00:00 |  |  |  |  |  | Thursday | 06:00:00 | 18:00:00 | 12:00:00 | 13:00:00 | 9 | 11 | 14.00000000005821 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
2022-03-11 00:00:00 |  | 08:00:00 | 18:00:00 |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-03-11 00:00:00 | 2022-03-14 00:00:00 |  | 2022-03-11 00:00:00 | Friday | 08:00:00 | 18:00:00 | 10:00:00 | 13:00:00 | 9 | 11 | 59.00000000005821 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2
2022-03-14 00:00:00 |  | 05:00:00 | 19:00:00 |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-03-14 00:00:00 |  |  | 2022-03-14 00:00:00 | Monday | 05:00:00 | 19:00:00 | 14:00:00 | 15:00:00 | 10 | 9 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00
Spreadsheet: 112570d1308673841-help-with-multiple-sheets-new-hub-workstream-log
Sheet: A

Southern Hub Workstream Log |  | A | April - June
Work Priority |  |  | 1 - High | 2 - Medium | 3 - Low
Type | Project Description | Priority | Request Origin | Request Date | Estimated Deadline | Status
QRP-Related Task | TEST | 1 | Operations | 2011-06-10 00:00:00 | 2011-06-15 00:00:00 | Initiated
Presentation | a test | 3 | AB | 2011-05-09 00:00:00 | 2011-05-06 00:00:00 | Not Started
Spreadsheet: 51972d1251612377-how-to-create-a-dropdown-list-that-returns-values-that-depends-on-another-cell-697484_surfol
Sheet: Cust Data

Cust Name | Address | Address Line2 | City | Phone
[NAME] | 789 10th Street | Next to Indiana University | [NAME] | [PHONE]
[NAME] | 123 [NAME] | Opposite Station | Cupertino | [PHONE]
[NAME] | 100 First St. | Near McDonald's | Daly City | [PHONE]
Vincent | 100 2nd St.
Spreadsheet: 842776d1694766874-excel-auto-pairing-comparison-and-border-colors-data
Sheet: Sheet1

 | 64 | 40 | 41 | 31 | 29
Number |  |  |  |  |  | Total
1 | 33 | 42 | 71 | 68 | 27
2 | 31 | 32 | 4 | 84 | 28
3 | 69 | 2 | 72 | 78 | 41
4 | 61 | 36 | 4 | 74 | 39
5 | 27 | 79 | 51 | 33 | 18
6 | 62 | 9 | 27 | 46 | 30
7 | 67 | 53 | 20 | 3 | 74
8 | 52 | 48 | 27 | 86 | 73
9 | 37 | 34 | 74 | 69 | 9
10 | 70 | 88 | 5 | 67 | 28
11 | 66 | 27 | 6 | 16 | 85
12 | 29 | 52 | 37 | 41 | 6
13 | 62 | 87 | 38 | 10 | 17
Spreadsheet: 762133d1641404029-countif-help-for-totaling-multiple-criteria-recruiting-stats-2022
Sheet: Dashboard

 |  |  |  |  | Monthly Recruiting Data |  |  |  |  |  |  |  |  |  | Started with Pending BG |  |  |  |  | Ready to Start/ Pipeline Data
 |  |  |  |  | Month | Applications Received | Scheduled Interviews | Actual Interviews | Job Offers Made | Job Offers Accepted
 |  |  |  |  | January |  |  |  |  |  |  |  |  |  | Status |  |  | Total |  | [NAME] |  | PRODUCTION
 |  |  |  |  | February |  |  |  |  |  |  |  |  |  | Started with Pending BG |  |  |  |  | 1-A |  | 1-A
 |  |  |  |  | March |  |  |  |  |  |  |  |  |  | Cleared BG |  |  |  |  | 1-B |  | 1-B
 |  |  |  |  | April |  |  |  |  |  |  |  |  |  | Flagged BG pending LMV approval |  |  |  |  | 1-C |  | 1-C
 |  |  |  |  | May |  |  |  |  |  |  |  |  |  | BG approved by LMV |  |  |  |  | 1-D |  | 1-D
 |  |  |  |  | June |  |  |  |  |  |  |  |  |  | BG denied by LMV |  |  |  |  | 2-A |  | 2-A
 |  |  |  |  | July |  |  |  |  |  |  |  |  |  | Adverse Action Process |  |  |  |  | 2-B |  | 2-B
 |  |  |  |  | August |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2-C |  | 2-C
 |  |  |  |  | September |  |  |  |  |  |  |  |  |  | Pre-Hires Background Data |  |  |  |  | 2-D |  | 2-D
 |  |  |  |  | October |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3-A |  | 3-A
 |  |  |  |  | November |  |  |  |  |  |  |  |  |  | PENDING LMV APPROVAL |  |  |  |  | 3-B |  | 3-B
 |  |  |  |  | December |  |  |  |  |  |  |  |  |  | PENDING VALIDITY |  |  |  |  | 3-C |  | 3-C
 |  |  |  |  | TOTALS |  |  |  |  |  |  |  |  |  | CLEARED |  |  |  |  | 3-D |  | 3-D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DENIED BY LMV
 |  | Declination Reasons (Monthly/ Yearly)
 |  | Pay | Hours | Location | Too much overtime | Start date too far out | Onboarding Requirements | Transportation | Currently Employed | Already worked at LMV | No reason given
 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | TOTALS
Spreadsheet: 0bbff19d-7640-4484-88cf-f2c9b8ac6ff2
Sheet: 3 YEARS

Form PR-B ORSP BUDGET WORKSHEET    Must be completed and initialed by ORSP Staff
 | MUID |  |  |  | ACCT
Prepared by
Last Modified on
PI |  |  |  |  | DEPT
Project Title
Sponsor
 | Budget Period
 | Increase Annually By | 1.03
 |  |  |  |  |  | PERIOD 1 |  |  | PERIOD 2 |  |  | PERIOD 3 |  |  | TOTAL
 | BUDGET ITEM | Name or Comment |  |  |  | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL | GRANT | Cost Share | TOTAL
A. | PERSONNEL
6000 | PI Acad. Year
6000 | Co-I Acad Year
6000 | Co-I Acad Year
6000 | Other Professional
6000 | Total Professional
6007 | PI Summer
6007 | Co-I Summer
6007 | Co-I Summer
6007 | Total Sumr Salaries
6008 | Post Doc/Fellow Full-Time
6012 | Clinical/Lab Staff Full-Time
6013 | Clinical/Lab Staff Part-Time
6020 | Full-Time Hourly Staff
6035 | Part-Time Hourly Staff
6050 | Undergraduate Students
6024 | GRA-Academic Year | #: |  | Biweekly $:
6024 | GRA-Summer | #: |  | Biweekly $:
6024 | Total GRA
6195 | Fringe FT |  |  |  | 0.285
6195 | [NAME] |  |  |  | 0.16
6195 | Fringe PT & Summer Students |  |  |  | 0.08
6195 | Total Fringes
 | TOTAL PERSONNEL
B. | NONPERSONNEL
6200 | Office Expenses
6235 | Lab Supplies
6247 | Equipment > $5000
6265 | Computer Software
6505 | Consulting Fees
6602 | Student Stipends
6900 | Domestic Travel
6900 | Domestic Travel
6900 | Total Domestic Travel
6930 | Foreign Travel
7010 | Publications
7225 | Tuition
 | TOTAL NONPERSONNEL
 | TOTAL DIRECT COSTS
 | MTDC BASE
7520 | F&A Costs |  |  |  | 0.51
 | TOTAL PROJ COSTS
Spreadsheet: 828629d1683645248-while-using-xlookup-the-first-2-lines-work-than-it-stops-testboox
Sheet: electricityOut

2022-01-01 01:00:00 | 0
2022-01-01 02:00:00 | 0
2022-01-01 03:00:00 | 0
2022-01-01 04:00:00 | 0
2022-01-01 05:00:00 | 0
2022-01-01 06:00:00 | 0
2022-01-01 07:00:00 | 0
2022-01-01 08:00:00 | 0
2022-01-01 09:00:00 | 0
2022-01-01 10:00:00 | 0
2022-01-01 11:00:00 | 0
2022-01-01 12:00:00 | 0
2022-01-01 13:00:00 | 0
2022-01-01 14:00:00 | 0
2022-01-01 15:00:00 | 0
2022-01-01 16:00:00 | 0
2022-01-01 17:00:00 | 0
2022-01-01 18:00:00 | 0
2022-01-01 19:00:00 | 0
2022-01-01 20:00:00 | 0
2022-01-01 21:00:00 | 0
2022-01-01 22:00:00 | 0
2022-01-01 23:00:00 | 0
2022-01-02 00:00:00 | 0
2022-01-02 01:00:00 | 0
2022-01-02 02:00:00 | 0
2022-01-02 03:00:00 | 0
2022-01-02 04:00:00 | 0
2022-01-02 05:00:00 | 0
2022-01-02 06:00:00 | 0
Spreadsheet: 768911d1645197536-adjusting-cell-heights-in-a-table-survey-frequency-table
Sheet: Sheet1

 |  | Zone 1 | Zone 2 | Zone 3
2022 | Winter
 | Spring
 | Summer
 | Autumn
2023 | Winter
 | Spring
 | Summer
 | Autumn
2024 | Winter
 | Spring
 | Summer
 | Autumn
2025 | Winter
 | Spring
 | Summer
 | Autumn
2026 | Winter
 | Spring
 | Summer
 | Autumn
2027 | Winter
 | Spring
 | Summer
 | Autumn
2028 | Winter
 | Spring
 | Summer
 | Autumn
2029 | Winter
 | Spring
 | Summer
 | Autumn
2030 | Winter
 | Spring
 | Summer
 | Autumn
2031 | Winter
 | Spring
 | Summer
 | Autumn
2032 | Winter
 | Spring
 | Summer
 | Autumn
Spreadsheet: 676188d1588694067-calculating-time-value-returns-hash-copy-of-bd
Sheet: Sheet2

 |  | HOUR | MIN | SEC | TIME | Plant Status | Plant Status | Breakdown
 |  | 1 | 30 | 30 |  | 0
 |  | 2 | 30 | 30 |  | 1
 |  | 12 | 30 | 30 |  | 0
 |  | 2 | 30 | 30 |  | 1
 |  |  |  |  | 00:30:00
 |  |  |  |  | 12:30:00
 |  |  |  |  | 02:30:00
 |  |  |  |  | 14:30:00