tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 5f7e1fd2-115e-46e0-b99f-1bdfdc8593bc
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259961 | 25148 | [NAME] | Mosquera | USA | 3 | 00:15:56 | 00:04:04 | [NAME] | 00:02:30 | 00:20:36 | 1 | 01:29:12
259961 | 30439 | Joleen | Hakker B1 | NED | 4 | 00:20:12 | 00:04:18 | 00:38:46 | 00:02:47 | 00:24:29 | 2 | 01:30:31
259961 | 65445 | Marleide | [NAME] B1 | BRA | 1 | 00:19:14 | 00:05:13 | 01:11:29 | [NAME] | 00:27:22 | 3 | 02:06:36
259961 | 51375 | [NAME] | Walsh B1 | USA | 2 | 00:16:22 | 00:03:21 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 886460d1736482295-create-a-formula-ppe-register
Sheet: FIND

 |  | Enter employee number below
 | Emp No | 9
 | Name
 | PPE | History
 |  | Shoe | Helmet | Jacket | Overall | Goggle | Spectacle
 | Issue Dates
Spreadsheet: 39105d1237305551-dimensional-weight-formula-dim-weight-calculator-practice
Sheet: Dim Calculator

Length | [NAME] | Heigth | Actual Weight | [NAME] | Billable Weight | Zone | Rate
30 | 50 | 16 | 10 | 60 | 60 | 4 | 8.7604
19 | 12 | 19 | 5 | 11 | 11 | 8 | 5.2128
24 | 24 | 24 | 10 | 35 | 35 | 7 | 10.6656
20 | 20 | 20 | 25 | 20 | 25 | 8 | 9.534800000000002
5 | 62 | 5 | 5 | 4 | 5 | 5 | 4.07
19 | 18 | 17 | 5 | 15 | 15 | 4 | 4.07
12 | 12 | 19 | 8 | 7 | 8 | 6 | 4.07
19 | 12 | 19 | 5 | 5 | 5 | 8 | 4.1817
24 | 24 | 24 | 10 | 35 | 35 | 7 | 10.6656
20 | 20 | 20 | 25 | 20 | 25 | 8 | 9.534800000000002
5 | 62 | 5 | 5 | 5 | 5 | 5 | 4.07
19 | 18 | 17 | 5 | 15 | 15 | 4 | 4.07
12 | 12 | 19 | 8 | 8 | 8 | 6 | 4.07
over 60 one side is 7.50
second longest side is over 30 7.50
any package actual weight over 70 lbs 7.50
length plus girth combined exceeds 130 inches is 45 dollars
2x the height plus 2x width equals girth
Spreadsheet: 770106d1645810275-tracing-and-summing-from-numerous-sheet-sumifs-qs2-v2
Sheet: Reference - Channel

Channel Category | Channel | Sub-Channel
A1 | B5 | C15
A10 | B8 | C16
A11 | B43 | C26
A12 | [NAME] | C2
A13 | B4 | C25
A14 | B42 | C27
A15 | B36 | C18
A16 | B42 | C28
A17 | [NAME] | C24
A18 | B8 | C19
A19 | B33 | C17
A2 | B7 | C16
A20 | B32 | C20
A21 | B38 | C25
A22 | B30 | C21
A23 | B43 | C10
Spreadsheet: 268490d1380654817-need-formula-to-match-three-characteristics-to-return-approved-inactive-blank-results-approved-check
Sheet: Master

Search Term | BSE Material | BSE Category | MFG | Material Description | Market Cost per 1 | UM | Customer Material | Type | Generic | Total Savings Potential | CMIR2 | Savings per CMIR | Actual QTY | Potential QTY | Actual [NAME] | Potential [NAME] | Savings | Notes | Approved
'006990023 |  |  |  |  |  |  |  |  |  |  | '006990023
 |  | Tools - Pulling Tape and Grips | NEPTCO | WP2500P/5000 POLY MULETAPE |  |  | '006990023 | Base |  |  | '006990023 |  |  |  |  |  |  |  | Approved |  | Approved because 6990023, WP2500P/5000, and Neptco matches all from one row in the list tab.
 |  | Tools - Pulling Tape and Grips | DURALINE ARNCO | BLWP25 6000FT 2500# [NAME] |  |  | '006990023 ALT3 | Alternate |  |  | '006990023 |  |  |  |  |  |  |  | Approved
 |  | Tools - Pulling Tape and Grips | NEPTCO | WP2500P 6000FT 2500# MUL REPL BY 2488244 |  |  | '006990023 ALT2 | Alternate |  |  | '006990023 |  |  |  |  |  |  |  | Approved
 |  | Tools - Pulling Tape and Grips | DURALINE ARNCO | BLWP25 5000FT 2500# [NAME] |  |  | '006990023 ALT1 | Alternate |  |  | '006990023 |  |  |  |  |  |  |  | Approved
 |  | Tools - Pulling Tape and Grips | DURALINE ARNCO | DLWP25S 5000FT 2500# [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Inactive |  | Inactive because 690023, DLWP25S and ARNCO has a tag inactive in column 5.
'005722003 |  |  |  |  |  |  |  |  |  |  | '005722003
 |  | Electric MRO and Wiring Materials | THOMAS & BETTS | TY5232MX LOCKING CABLE TIE 8.00IN |  |  | '005722003 | Base |  |  | '005722003 |  |  |  |  |  |  |  | Approved
 |  | Electric MRO and Wiring Materials | PANDUIT | PLT2S-C0 CABLE TIE  7.4L (188MM |  |  | '005722003 ALT1 | Alternate |  |  | '005722003 |  |  |  |  |  |  |  | Approved
 |  | Electric MRO and Wiring Materials | GB-GARDNER BENDER | 46-108UVB 8-IN 18LB UVB CBL TIE |  |  | '005722003 NEEDS APPROVAL 5 | Needs Approval |  |  | '005722003
 |  | Electric MRO and Wiring Materials | TYTON CORPORATION | T18L0C2 CABL TIE 8IN BLACK 100/PK |  |  | '005722003 NEEDS APPROVAL 6 | Needs Approval |  |  | '005722003
 |  | Electric MRO and Wiring Materials | NSI INDUSTRIES | 8180 8IN BLACK CABLE TIE |  |  | '005722003 NEEDS APPROVAL 7 | Needs Approval |  |  | '005722003
 |  | Electric MRO and Wiring Materials | PANDUIT | PLT2M-C0 CABLE TIE  8.0L (203MM |  |  | '005722003 NEEDS APPROVAL 8 | Needs Approval |  |  | '005722003
 |  | Electric MRO and Wiring Materials | IDEAL INDUSTRIES | IT2M-C0 CBL TIE, 8" 18LB, UVB |  |  | '005722003 NEEDS APPROVAL 2 | Needs Approval |  |  | '005722003
 |  | Electric MRO and Wiring Materials | THOMAS & BETTS | TY232MX LOCKING CABLE TIE-BULK 8.00IN |  |  | '005722003 NEEDS APPROVAL 4 | Needs Approval |  |  | '005722003
 |  | Electric MRO and Wiring Materials | THOMAS & BETTS | L-8-18-0-C CABLE TIE |  |  | '005722003 NEEDS APPROVAL 1 | Needs Approval |  |  | '005722003
 |  | Electric MRO and Wiring Materials | BURNDY | CT18200C0 18LB UV NYLON CBL TIE |  |  | '005722003 NEEDS APPROVAL 3 | Needs Approval |  |  | '005722003
Spreadsheet: afb9b6e8-1c8c-4606-9068-dfea4765d957
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
FZ004 | Test | FZ004 | [NAME] | [NAME] | Only orderable as part as a profile. For further information see #91309 "Lyme Disease Ab for CNS Infection" |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Focus Diagnositics, Inc.
FZ004 | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
FZ004 | Result | Z0359 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FZ004 | Result | Z0360 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 819563d1677582122-sum-fields-based-on-month-data-to-analysis
Sheet: 2010 Accidents

BREAKDOWN
2010
SEP
CUT | 1 | Finger caught between Lymington Billets
CUT | 1 | Hit nose on forklift after grabbing safety arm instead of handle
BACK | 1 | Lifting boxes of paper in a narrow aisle
BACK | 1 | Block fell off pallet and tipped up forklift
OCT
CUT | 1 | Pulled yard gate onto heel
NOV
HEAD | 1 | Hit head on beam when picking up a bundle from export rack
DEC
SLIP (snow) | 1 | Clearing Path in Car Park
BODY | 1 | Hit in lower body by Air Line which blew off vice
Spreadsheet: 186624d1350124053-generating-a-column-table-from-a-single-in-put-cell-car-uploaded
Sheet: Sheet1

 | Input here | value  1,2,3...................
 |  | expencse
 | Misc | 840
 | Oil | 1400
 | Dent | 3500
 | Reg | 1322
 | Eng | 1150
 | Doors | 490
 | Tools | 390
 | [NAME] | 1020
 | Oil s.plug | 2400
 | Puncture | 170
 |  | value1
 |  | value 2
 |  | value 3
 |  | .
 |  | .
 |  | .
 |  | .
Spreadsheet: 106792d1303981162-hide-rows-if-value-0-need-help-please-nails
Sheet: Sheet1

Building Materials
Unit | Nail Type | Length | Total Length
5 | A1 | 0.7 | 3.5
0 | B1 | 0.9 | 0
2 | C1 | 1.1 | 2.2
2 | D1 | 1.3 | 2.6
1 | E1 | 1.5 | 1.5
0 | F1 | 1.7 | 0
Spreadsheet: 8bb5d531-5552-4923-ac53-07e980b5b2c6
Sheet: Sheet1

Teenust osutanud isiklike abistajate arv , 2006-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Aasta | Aruandeaasta jooksul teenust osutanud [NAME] | [NAME] aruandeaasta [NAME] | neist alla 25 | 25-49 | 50-59 | üle 60
2006 ¹ | 128 | 114 | 11 | 60 | 17 | 26
2007 | 315 | 308 | 33 | 161 | 53 | 61
2008 | 357 | 344 | 29 | 194 | 55 | 66
2009 | 345 | 344 | 17 | 194 | 63 | 70
2010 | 354 | 341 | 16 | 171 | 77 | 77
¹ - andmed Tallinnata
Koostanud sotsiaalpoliitika [NAME]
Spreadsheet: 168021d1342191400-sumifs-formula-one-range-with-two-criteria-spare_data_presentation
Sheet: SUMMARY

Select Branch |  |  | NAGPUR
Select Type |  |  | SALES
Select Segment |  |  | SPARE
 |  | MONTH | MONTH & YEAR | KEY | AOP |  | ACHIVEMENT |  | MONTH | MONTH & YEAR | AOP |  | ACHIVEMENT
 |  | 2011-04-01 00:00:00 |  |  |  |  |  |  | 2012-04-01 00:00:00 | 42012
 |  | 2011-05-01 00:00:00 |  |  |  |  |  |  | 2012-05-01 00:00:00 | 52012
 |  | 2011-06-01 00:00:00 |  |  |  |  |  |  | 2012-06-01 00:00:00 | 62012
 |  | 2011-07-01 00:00:00 |  |  |  |  |  |  | 2012-07-01 00:00:00 | 72012
 |  | 2011-08-01 00:00:00 |  |  |  |  |  |  | 2012-08-01 00:00:00 | 82012
 |  | 2011-09-01 00:00:00 |  |  |  |  |  |  | 2012-09-01 00:00:00 | 92012
 |  | 2011-10-01 00:00:00 |  |  |  |  |  |  | 2012-10-01 00:00:00 | 102012
 |  | 2011-11-01 00:00:00 |  |  |  |  |  |  | 2012-11-01 00:00:00 | 112012
 |  | 2011-12-01 00:00:00 |  |  |  |  |  |  | 2012-12-01 00:00:00 | 122012
 |  | 2012-01-01 00:00:00 |  |  |  |  |  |  | 2013-01-01 00:00:00 | 12013
 |  | 2012-02-01 00:00:00 |  |  |  |  |  |  | 2013-02-01 00:00:00 | 22013
 |  | 2012-03-01 00:00:00 |  |  |  |  |  |  | 2013-03-01 00:00:00 | 32013
 |  | 11-12 | 11-12 |  |  |  |  |  | 12-13 | 12-13
Spreadsheet: 6259bfc0-92ee-4fb2-a88b-8b665922ad1c
Sheet: Sheet1

Continuing Progress Report | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Summary of Reportable Events (not previously reported to CHW IRB as Promptly Reportable)
Protocol Title:
IRB#
IRBnet#
Date Range:
Adverse Event Short Description (for use if there is no central data collection site outside CHW/MCW) | Date | Resolution/Outcome? | Severity of event | Frequency of event | Expected?" | Related to study? | Additional Details if needed
Internal Serious Adverse Event Description (not Promptly reportable) | Date | Resolution/Outcome? | Severity of event | Frequency of event | Expected?" | Related to study? | Additional Details if needed
External Serious Adverse Event Description (not Promptly reportable) | Date | Resolution/Outcome? | Severity of event | Frequency of event | Expected?" | Related to study? | Additional Details if needed
Minor protocol Deviation (not Promptly reportable) | Date | Resolution/Outcome? | Were there any negative effects to the subject as a result? | Additional Details if needed
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 24089 | 23986
2 |  |  | 25747 | 24000
3 |  |  | 25670 | 24000
4 |  |  | 25643 | 24000
5 |  |  | 25830 | 24000
6 |  |  | 24358 | 24000
7 |  |  | 24348 | 24000
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -178485 | -74794
2001-09-30 00:00:00 | Balance | -1023166.39 |  | -454550
2001-10-07 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | -58339.66 | Zia |  |  | 22864 | -24566
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 | 44144.84 | [NAME] |  |  | 26357 | 26521
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -933276.39 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -42250
 |  |  |  | Duke
Spreadsheet: 203901d1357295045-matching-data-sets-based-on-similar-entries-simplified-data
Sheet: Sheet1

 | Known Locations and Networks |  |  |  |  | Unknown Location Networks
 | [NAME] | UNIQUE NETWORK IDENTIFIER | [NAME]?
 |  |  |  |  |  | [NAME] | UNIQUE NETWORK IDENTIFIER
 | 1050 | NETWORK1 |  | How can I automatically |  | ??? | NETWORK2
 | 1050 | NETWORK2 |  | cross reference the networks |  | ??? | NETWORK3
 | 1050 | NETWORK3 |  | at the unknown location and |  | ??? | NETWORK4
 | 1050 | NETWORK4 |  | known location? |  | ???? | [NAME]
 | 1060 | NETWORK2
 | 1060 | NETWORK3
 | 1060 | NETWORK4
 | 1060 | [NAME]
 | 1070 | NETWORK3
 | 1070 | NETWORK4
 | 1070 | [NAME]
 | 1070 | NETWORK6
 |  |  | KNOWN LOCATIONS | # OF MATCHING NETWORKS
 |  |  | 1050
 |  |  | 1060 |  | <--- Most likely to be the right location
 |  |  | 1070
Spreadsheet: 835002d1688223130-i-want-to-automatically-copy-chart-from-sheets-sample
Sheet: Sheet1

deliveryLocations | PRICE
State(s) - KARNATAKA, TAMIL NADU, JAMMU & KASHMIR, DELHI, MAHARASHTRA, GUJARAT, ANDHRA PRADESH, UTTAR PRADESH, DADRA & NAGAR HAVELI, KERALA, WEST BENGAL, HARYANA, CHANDIGARH, PUNJAB, GOA, HIMACHAL PRADESH, BIHAR, MADHYA PRADESH, ASSAM, ARUNACHAL PRADESH, SIKKIM, ODISHA, RAJASTHAN, CHHATTISGARH, UTTARAKHAND, [NAME], MEGHALAYA, LAKSHADWEEP, DAMAN & DIU, MANIPUR, MIZORAM, TRIPURA, TELANGANA, PUDUCHERRY | Rs.4,320.00
State(s) - KARNATAKA, TAMIL NADU, JAMMU & KASHMIR, DELHI, MAHARASHTRA, GUJARAT, ANDHRA PRADESH, UTTAR PRADESH, KERALA, WEST BENGAL, HARYANA, CHANDIGARH, PUNJAB, GOA, HIMACHAL PRADESH, BIHAR, MADHYA PRADESH, SIKKIM, ODISHA, RAJASTHAN, CHHATTISGARH, UTTARAKHAND, [NAME] | Rs.1,514.00
All India | Rs.1,574.63
All India | Rs.1,693.36
All India | Rs.1,510.83
All India | Rs.3,999.01
State(s) - JAMMU & KASHMIR, DELHI, HARYANA, CHANDIGARH, PUNJAB, HIMACHAL PRADESH, RAJASTHAN | Rs.1,476.00
State(s) - KARNATAKA, TAMIL NADU, JAMMU & KASHMIR, DELHI, MAHARASHTRA, GUJARAT, ANDHRA PRADESH, UTTAR PRADESH, DADRA & NAGAR HAVELI, KERALA, WEST BENGAL, HARYANA, ANDAMAN & NICOBAR, CHANDIGARH, PUNJAB, GOA, HIMACHAL PRADESH, BIHAR, MADHYA PRADESH, SIKKIM, ODISHA, RAJASTHAN, CHHATTISGARH, UTTARAKHAND, [NAME], LAKSHADWEEP, DAMAN & DIU, TELANGANA, PUDUCHERRY | Rs.1,475.59
All India | Rs.4,320.00
Spreadsheet: 757033d1637947725-conditional-formatting-based-on-cell-color-sample
Sheet: Summary

 | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Avg |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Avg
Week 1 | 1 | 2 | 3 | 3 | 2 | 1 | 4 |  |  |  |  |  | Week 1 | 1 | 2 | 3 | 3 | 2 | 1 | 4
Week 2 |  |  |  |  |  |  |  |  |  |  |  |  | Week 2
Week 3 |  |  |  |  |  |  |  |  |  |  |  |  | Week 3
Week 4 |  |  |  |  |  |  |  |  |  |  |  |  | Week 4
Week 5 |  |  |  |  |  |  |  |  |  |  |  |  | Week 5
Week 6 |  |  |  |  |  |  |  |  |  |  |  |  | Week 6
Week 7 |  |  |  |  |  |  |  |  |  |  |  |  | Week 7
Week 8 |  |  |  |  |  |  |  |  |  |  |  |  | Week 8
Spreadsheet: 464937d1465380536-database-entry-with-more-than-1-row-school-sen-register-example-_-for-crumble72-_-as
Sheet: Sheet1

Name | Cohort | DOB | SEN | [NAME] need | Sec need | PP/LAC
[NAME] | 10 | 2010-06-02 00:00:00 | SEN | Specific LD | ASD | PP
[NAME] | 9 | 2009-06-02 00:00:00 | VP | Sp & Lang… | ASD | LAC
[NAME] | 8 | 2008-12-17 00:00:00 | VP | Profound… | LD | PP
Xerdan B | 9 | 2010-04-19 00:00:00 | SEN | Visual I | Hearing I | PP
Spreadsheet: 110979d1307513564-multiple-matching-criteria-before-summing-formula-problems-copy-of-multiple-matching-criteria-before-summing-formula-problems
Sheet: Combo Data

Data Validation | Short Code |  | Combo Link |  | Sub Category
Acquisition Panels | Panels |  | 13 |  | [NAME]
Auxillary [NAME] | Aux_DH |  |  |  | PG
Calibration & Testing Equipment | Cal_Test |  | Combo Link |  | RM
Hostile Tools | Hostile |  | 1
Logging Unit & Vehicles | Units
Other Unit Systems | Unit_Other
Perforating - CCL's - FPI Tools | Perf_CCL_Sinker
PLT [NAME] | PLT
RA Sources and [NAME] | Sources
Rig Up & Transportation Equipment | [NAME]
Sampling & Coring Tools | Sample_Core
Seismic Equipment | Seismic
Standard Downhole Tools | Std DH
Spreadsheet: dfa42b49-23a1-45b5-9e8a-8c932e71be0f
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42850398 | 2014-08-23 21:22:17 | ALLIES | 0 | 2 | 6 | 923434 | [NAME] | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
42850637 | 2014-08-23 21:32:59 | AXIS | 0 | 2 | 6 | 923434 | [NAME] | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
42850951 | 2014-08-23 22:03:00 | AXIS | 1 | 6 | 1 | 1254858 | Hougoumont | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
42851204 | 2014-08-23 22:25:48 | ALLIES | 0 | 1 | 6 | 1254858 | Hougoumont | 7596 | eastern | 1941-12-07 | 1941-12-08 | Breakout at Klin | Évasion à Klin
42851647 | 2014-08-23 22:49:30 | AXIS | 0 | 4 | 7 | 701256 | player701256 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42851872 | 2014-08-23 23:03:08 | ALLIES | 0 | 3 | 7 | 701256 | player701256 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42852090 | 2014-08-23 23:21:07 | ALLIES | 1 | 6 | 5 | 55639 | Gigimat | 7667 | pacific | 1945-05-13 | 1945-05-19 | Sugar Loaf and Half Moon | Pain de sucre et demi-lune
42852426 | 2014-08-23 23:46:24 | AXIS | 1 | 4 | 3 | 1623774 | tkurivial | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42852643 | 2014-08-24 00:02:07 | ALLIES | 1 | 4 | 2 | 1623774 | tkurivial | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42852866 | 2014-08-24 00:19:57 | AXIS | 0 | 2 | 5 | 1228328 | Woodrow Call | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42853036 | 2014-08-24 00:34:10 | ALLIES | 1 | 5 | 2 | 1228328 | Woodrow Call | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
42853202 | 2014-08-24 00:55:28 | AXIS | 1 | 6 | 4 | 1228328 | Woodrow Call | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
42853430 | 2014-08-24 01:08:15 | ALLIES | 1 | 6 | 3 | 1228328 | Woodrow Call | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
42853617 | 2014-08-24 01:42:11 | ALLIES | 0 | 5 | 6 | 1290011 | wazowski | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
42853857 | 2014-08-24 02:03:10 | AXIS | 0 | 5 | 6 | 1290011 | wazowski | 12497 | pacific | 1942-09-12 | 1942-09-14 | Bloody Ridge | [NAME]
42854103 | 2014-08-24 02:29:50 | AXIS | 0 | 3 | 5 | 1007284 | Temple58 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
42854272 | 2014-08-24 02:47:17 | ALLIES | 1 | 5 | 3 | 1007284 | Temple58 | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
42854885 | 2014-08-24 04:03:48 | AXIS | 1 | 6 | 5 | 603439 | MickeyScott01 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42855053 | 2014-08-24 04:28:31 | ALLIES | 1 | 6 | 5 | 603439 | MickeyScott01 | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
Spreadsheet: 781737d1653505383-sumifs-not-working-2022-05-25-oeldere-vani-2004-sumifs
Sheet: Sheet1

Lookup Acct | [NAME] |  | Acct # | Currency
520100 |  |  | 520100 | 500
520010 |  |  | 534821 | 300 |  |  | Rijlabels | Som van Currency
 |  |  | 520010 | 250 |  |  | 500100 | 100
 |  |  | 500100 | 100 |  |  | 520010 | 300
 |  |  | 520100 | 100 |  |  | 520100 | 600
 |  |  | 520010 | 50 |  |  | 534821 | 300
 |  |  |  |  |  |  | Eindtotaal | 1300
Spreadsheet: 183710d1348981168-using-one-cell-amount-to-call-up-a-value-in-adjoining-cell-test
Sheet: Sheet1

 |  |  |  |  | hours | tenths | tenths | tenths | tenths
hours | labor dollars |  |  |  |  | 0 | 0.1 | 0.2 | 0.3
1 | 120 |  |  |  | 1 | 120 | 129 | 130 | 148
4.2 | 470 |  |  |  | 2 | 240 | 255 | 278 | 290
2.3 | 290 |  |  |  | 3 | 344 | 360 | 389 | 396
3 | 350 |  |  |  | 4 | 410 | 429 | 436 | 455
Spreadsheet: 848938d1699538181-formula-to-calculate-an-agreements-remaining-value-with-an-escalator-lease_jt
Sheet: All Locations

 |  |  |  |  |  | Date Used In Duration Calculation |  |  | 2023-11-08 00:00:00
Lease ID | Current Term Start Date | Current Term End Date | Commencement Date | Final Lease End Date | Total Lease Length (Months) | Days from lease start to today | Duration Into Lease |  | Days Remaining In lease | Duration Remaining of Lease |  | Current Rent Amount (Annual) | Current Rent Amount (Monthly) | Increase Type | Increase Percent | Increase Interval | Next Increase Date
1 | 2021-01-24 00:00:00 | 2026-01-23 00:00:00 | 2011-01-24 00:00:00 | 2036-01-23 00:00:00 | 300 | 4671 | 12 years | 9 months | 4459 | 12 years | 2 months | 750 | 62.5
2 | 2022-01-01 00:00:00 | 2026-12-31 00:00:00 | 2000-02-28 00:00:00 | 2041-12-31 00:00:00 | 503 | 8654 | 23 years | 8 months | 6628 | 18 years | 1 months | 1025 | 85.41666666666667 | Fixed % | 0.04 | 1 Year | 2024-02-28 00:00:00
3 | 2019-11-22 00:00:00 | 2024-11-21 00:00:00 | 2004-11-22 00:00:00 | 2029-11-21 00:00:00 | 300 | 6925 | 18 years | 11 months | 2205 | 6 years | 0 months | 750 | 62.5 | Fixed % | 0.15 | 5 Years | 2024-11-22 00:00:00
4 | 2020-08-01 00:00:00 | 2025-07-31 00:00:00 | 2000-07-01 00:00:00 | 2040-07-31 00:00:00 | 481 | 8530 | 23 years | 4 months | 6110 | 16 years | 8 months | 480 | 40
5 | 2013-07-01 00:00:00 | 2025-07-31 00:00:00 | 2008-07-01 00:00:00 | 2030-07-31 00:00:00 | 265 | 5608 | 15 years | 4 months | 2457 | 6 years | 8 months | 1150 | 95.83333333333333 | Fixed % | 0.03 | 1 Year | 2024-07-01 00:00:00
6 | 2022-07-16 00:00:00 | 2027-07-15 00:00:00 | 2007-07-16 00:00:00 | 2037-07-15 00:00:00 | 360 | 5959 | 16 years | 3 months | 4998 | 13 years | 8 months | 830 | 69.16666666666667 | Fixed % | 0.12 | 5 Years | 2027-07-16 00:00:00
12 | 2020-09-01 00:00:00 | 2025-08-31 00:00:00 | 2005-09-01 00:00:00 | 2035-08-31 00:00:00 | 360 | 6642 | 18 years | 2 months | 4314 | 11 years | 9 months | 1350 | 112.5 | Fixed % | 0.05 | 5 Years | 2025-09-01 00:00:00
13 | 2022-01-01 00:00:00 | 2026-12-31 00:00:00 | 2022-01-01 00:00:00 | 2041-12-31 00:00:00 | 240 | 676 | 1 years | 10 months | 6628 | 18 years | 1 months | 1000 | 83.33333333333333 | Fixed % | 0.03 | 1 Year | 2024-01-01 00:00:00
14 | 2019-12-04 00:00:00 | 2029-12-03 00:00:00 | 2019-12-04 00:00:00 | 2049-12-03 00:00:00 | 360 | 1435 | 3 years | 11 months | 9522 | 26 years | 0 months | 900 | 75 | Fixed % | 0.0225 | 1 Year | 2023-12-04 00:00:00
15 | 2021-02-03 00:00:00 | 2031-02-02 00:00:00 | 2021-02-03 00:00:00 | 2026-02-02 00:00:00 | 240 | 1008 | 2 years | 9 months | 6296 | 2 | 2 | 1200 | 100 | Fixed % | 0.03 | 1 Year | 2024-02-03 00:00:00
Spreadsheet: 880504d1728307749-return-result-based-on-two-dates-holidays
Sheet: Sheet1

 | Name | Department | Start Date | End Date |  | New Holiday |  |  | Name | Department | Start Date | End Date |  | Result | Name | Department | Start Date | End Date |  | Name | Department | Start Date | End Date |  | Name | Department | Start Date | End Date
 | A | 1 | 2024-10-07 00:00:00 | 2024-10-18 00:00:00 |  | 1 |  |  | A | 1 | 2024-01-01 00:00:00 | 2024-01-03 00:00:00 |  |  | C | 1 | 2024-10-11 00:00:00 | 2024-10-20 00:00:00 |  | F | 1 | 2024-10-09 00:00:00 | 2024-10-10 00:00:00
 | A | 1 | 2024-01-01 00:00:00 | 2024-01-03 00:00:00 |  |  |  |  | B | 2 | 2024-03-05 00:00:00 | 2024-07-02 00:00:00
 | B | 2 | 2024-03-05 00:00:00 | 2024-07-02 00:00:00 |  |  |  |  | C | 1 | 2024-10-11 00:00:00 | 2024-10-20 00:00:00
 | C | 1 | 2024-10-11 00:00:00 | 2024-10-20 00:00:00 |  |  |  |  | D | 4 | 2024-07-18 00:00:00 | 2024-07-20 00:00:00
 | D | 4 | 2024-07-18 00:00:00 | 2024-07-20 00:00:00 |  |  |  |  | E | 3 | 2024-10-06 00:00:00 | 2024-10-10 00:00:00
 | E | 3 | 2024-10-06 00:00:00 | 2024-10-10 00:00:00 |  |  |  |  | F | 1 | 2024-10-09 00:00:00 | 2024-10-10 00:00:00
 | F | 1 | 2024-10-09 00:00:00 | 2024-10-10 00:00:00
Spreadsheet: 147605d1332878531-indexing-issues-book1
Sheet: Guestroom Takeoff

DRAWING | UNIT | ITEM | [NAME] | KITCHEN - BATH DRAWING | NOTES | QTY | CDI Cost | # Cabinets | FREIGHT EACH
A5-1 |  | [NAME] |  |  | Does not include countertops, appliances, plumbing or electrical.  Installation by others.
A5-1 |  | Vanity Cabinets |  |  | Does not include countertops, appliances, plumbing or electrical.  Installation by others.
A5-1 |  | [NAME] |  |  | Does not include countertops, appliances, plumbing or electrical.  Installation by others.
A5-1 |  | Vanity Cabinets |  |  | Does not include countertops, appliances, plumbing or electrical.  Installation by others.
 |  | `
 |  | S2-H vanites qty should be 24 and the S1-H vanity [NAME] should be  6/A-421. I copy the CDI Cost fron the Kitchette sheet, so the Column H value contaions the row I need for the other items I copy. In other words [NAME] 54 has all the data in need to move for [NAME] for S1-H Vanity, but how do I referred to this row in a function?