tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 734983d1622636501-summary-data-from-other-worksheet-test_column
Sheet: Summary

 | Type | Type | Type | Type | Type
Shop | Paper | Pen | Pencil | Ruler | eraser
ShopA
[NAME]
ShopC
 | * how to use formula to get result in above yellow area ?
Spreadsheet: 685009d1593666167-formula-to-copy-certain-criteria-to-another-worksheet-rr_06_26_20-1-2-
Sheet: Data

Update Schedule Rotation |  |  | 526
 | 25 |  | API | CFSIS | CMOD | CSE | CSS | DB | CFSICI | RE | SP | CMIS | Collab | DAEJ | ICI/ ICC | LDAP | FDM/CEBI | FSM
2 | [NAME] | 8-5 |  | X | X | X | X |  | X
3 | [NAME] | 730-430 |  |  |  |  | X
4 | XXXXX | XXXXX |  |  |  | X | X
5 | [NAME] | 830-530 |  | X | X |  | X |  |  |  |  |  |  |  | X
6 | [NAME] | M T TH 9-6                     W F 8-5 |  |  |  |  | X |  | X
7 | Greg | 8-5 | X |  |  | X | X |  |  | X | X | X | X |  |  |  |  | X
8 | Rama | 7-4 |  |  |  |  |  |  |  |  |  |  |  | X
9 | [NAME] | 8-5 |  |  |  | X | X |  |  | X |  |  |  |  |  | X |  | X
10 | [NAME] | 6-3 |  |  | X |  | X
11 | Louis | 6-3          N/A [NAME], Wed. and [NAME].
12 | XXXXX | XXXXX
13 | Fred | 6:00-3:00 |  |  |  | X | X |  |  | X |  |  |  |  |  |  | X
14 | [NAME] | 6-3 | X
15 | Larrel | 8-5 |  |  |  | X | X |  |  |  | X |  |  |  |  | X
16 | Ruben | 5:30-2:30 | X | X |  |  | X | X |  |  |  |  |  |  | X
17 | Kawing | 8:30-5:30 |  |  |  |  |  |  |  |  |  |  |  | X | X
18 | [NAME] | 8-5 |  |  |  | X | X
19 | XXXXX | XXXXX
20 | [NAME] | 7-4 | X |  |  |  | X |  |  |  |  | X | X
21 | Pak | 6-3 | X |  |  |  | X | X |  |  |  | X | X
22 | [NAME] | 830-530 |  |  | X |  | X |  | X
23 | XXXXX | XXXXX | X | X |  | X | X
24 | [NAME] | 530-230 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
25 | Sharlya | 730-430 |  |  |  |  |  |  |  |  |  |  | X
1 | Radu | 830-530 |  |  | X | X | X | X | X
26 | [NAME] | 8-5 |  | X |  |  |  |  |  |  |  | X |  | X |  |  |  | X
Spreadsheet: 1dc470a7-2494-4f42-afb7-a788612154eb
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-10-05 09:34:36.220000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.375 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.25 | 101.341 | 101.216 | 101.091 | 100.716
4.125 | 100.977 | 100.852 | 100.727 | 100.352 |  | Note: | Refer To Price [NAME]
4 | 100.539 | 100.414 | 100.289 | 99.914 |  |  | For all Price Adjs
3.875 | 100.022 | 99.897 | 99.772 | 99.147
3.75 | 99.053 | 98.928 | 98.803 | 98.178
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.808 | 101.683 | 101.558 | 101.183
3.75 | 101.331 | 101.206 | 101.081 | 100.706
3.625 | 100.968 | 100.843 | 100.718 | 100.343
3.5 | 100.614 | 100.489 | 100.364 | 99.989
3.375 | 100.214 | 100.089 | 99.964 | 99.339
3.25 | 99.678 | 99.553 | 99.428 | 98.803
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-19 09:34:36.220000
30 DAY | 2011-11-03 09:34:36.220000
45 DAY | 2011-11-18 09:34:36.220000
60 DAY | 2011-12-03 09:34:36.220000
90 DAY | 2012-01-02 09:34:36.220000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 871765d1718188509-march-fishing-xls-hpe-needed-sac-league
Sheet: 5

Name | lbs | oz | Oz (total) | Points
 | 62 | 13
 | 95 | 5
 | 74 | 0
 | 43 | 0
 | 65 | 1
 | 84 | 6
 | 65 | 15
 | 35 | 7
 | 44 | 10
 | 0 | 0
 | 79 | 13
 | 56 | 1
 | 96 | 3
 | 70 | 8
 | 123 | 0
 | 0 | 0
Spreadsheet: 236847d1369040667-need-help-with-a-formula-for-conditional-formatting-test-file-2-
Sheet: list2

Country | Continent
Argentina | South America
Australia | South Asia
Brazil | South America
Canada | North America
Chile | South America
China | Asia
Congo | Africa
France | Europe
Germany | Europe
Holland | Europe
India | Asia
Iran | Asia
Iraq | Asia
Japan | Asia
Mexico | North America
Namibia | Africa
Newzealand | South Asia
Pakistan | Asia
Portugal | Europe
Russia | Europe
South Africa | Africa
UAE | Asia
United Kingdom | Europe
USA | North America
Zambia | Africa
Spreadsheet: 168070d1342204959-pivot-table-calculating-percentage-on-grand-total-pivot-test-sri023-oeldere2-
Sheet: Ark1

Order | Amount | Type |  |  | Sum of Amount | Type
101 | -1212 | Revenue |  |  | Order | Revenue | Cost | Grand Total |  | %
101 | -3434 | Revenue |  |  | 105 | -1456709 | 988756 | -467953 |  | 0.7050744847391791
102 | -5678 | Revenue |  |  | 108 | -164456 | 97666 | -66790 |  | 0.1006338774101881
101 | 3678 | Cost |  |  | 103 | -91346 | 56098 | -35248 |  | 0.0531088922137193
102 | -123 | Revenue |  |  | 104 | -112436 | 81221 | -31215 |  | 0.04703228751847616
102 | 2348 | Cost |  |  | 111 | -86481 | 56346 | -30135 |  | 0.04540502913244527
103 | -1001 | Revenue |  |  | 110 | -112233 | 99999 | -12234 |  | 0.01843322138398326
103 | -90345 | Revenue |  |  | 109 | -34556 | 23345 | -11211 |  | 0.01689184607943733
103 | 56098 | Cost |  |  | 106 | -5564 | 1198 | -4366 |  | 0.006578342697602656
104 | -112436 | Revenue |  |  | 102 | -5801 | 2348 | -3453 |  | 0.005202706673115431
104 | 74545 | Cost |  |  | 101 | -4646 | 3678 | -968 |  | 0.001458505664516576
104 | 6676 | Cost |  |  | 107 | -453 | 333 | -120 |  | 0.0001808064873367656
105 | 988756 | Cost |  |  | Grand Total | -2074681 | 1410988 | -663693 |  | 0.9999999999999999
105 | -1456709 | Revenue
106 | 654 | Cost
106 | 544 | Cost
106 | -5564 | Revenue
108 | -164456 | Revenue
108 | 97666 | Cost
109 | -34556 | Revenue
107 | -453 | Revenue
107 | 333 | Cost
109 | 23345 | Cost
110 | -112233 | Revenue
110 | 99999 | Cost
111 | -86481 | Revenue
111 | 56346 | Cost
Spreadsheet: 135883d1326292537-changing-col_index_num-using-vlookup-dummy-file
Sheet: ECU HW Main Sheet

Technical Skill's
Skill  &  Level |  | Years Experience | Windows |  | MS PROJECT |  | ORCAD CIS |  | DFM |  | ALLEGRO PCB EDITOR |  | LP CALCULATOR (IPC-7351A) |  | TRACE WIDTH CALCULATOR |  | DFE |  | VIA CALCULATOR |  | PAD DESIGNER |  | EMI / EMC SIMULATION |  | POWER INTEGRITY |  | PSPICE |  | THERMAL SIMULATION |  | SIGNAL INTEGRITY |  | ALLEGRO |  | [NAME] |  | [NAME] |  | KVASER CAN CARD |  | VECTOR CAN CARD |  | OSCILLOSCOPE |  | Electronics Work Bench |  | Function Generator |  | Hardware Testing
 |  | 0~2 | 3 |  | 2 |  | 3 |  | 2 |  | 3 |  | 5 |  | 4 |  | 3 |  | 4 |  | 5 |  | 3 |  | 3 |  | 1 |  | 3 |  | 3 |  | 1 |  | 1 |  | 0 |  | 0 |  | 0 |  | 3 |  |  |  | 2 |  | 2
 |  | 2~4 | 4 |  | 3 |  | 4 |  | 3 |  | 4 |  | 5 |  | 4 |  | 5 |  | 4 |  | 5 |  | 4 |  | 4 |  | 3 |  | 4 |  | 4 |  | 2 |  | 1 |  |  |  |  |  |  |  | 4 |  |  |  | 3 |  | 3
 |  | 4~6 | 5 |  | 4 |  | 5 |  | 4 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 4 |  | 5 |  | 4 |  | 5 |  | 5 |  | 3 |  | 3 |  |  |  |  |  |  |  | 4 |  |  |  | 4 |  | 4
 |  | 6~8 | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 5 |  | 4 |  |  |  |  |  |  |  | 5 |  |  |  | 5 |  | 5
Evaluation |  |  | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL | Self | TL/PL
MSI Resources | a
 | b
 | c
 | d
 | e
 | f
Spreadsheet: 457039d1461172784-formula-ending-when-cell-is-blank-formula-test-file
Sheet: Sheet1

 |  |  |  |  |  | Current formula result |  | How I would like the result to be
[NAME] | [NAME] | [NAME] |  |  |  |  |  | [NAME]
[NAME] | Sara | [NAME] | Scott |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  |  | [NAME]
[NAME] | [NAME] | [NAME] | [NAME] | [NAME] |  |  |  | [NAME]
Spreadsheet: 871073d1717513569-combine-with-ampersand-concatenate-example-tms_3
Sheet: Sheet1

A100 | +1 | -1 | +2 | -2 |  |  | Maybe: A1: A100, B1: +1, C1: -1, D1: +2, E1: -2
 |  |  |  |  |  |  | Output: B2: A101, C2: A99, D2: A102, E2: A98
 |  |  | 43 |  | -5
 |  |  | 22 |  | -1
 |  |  | 55 |  | 0 |  | =  sum    d20    d19 d21 d15 d25 (offset +1 +5 -1 -5 around D20)
 |  |  | 3 |  | +1
 |  |  | -9 |  | +5
Spreadsheet: 102261d1300222861-offset-volatility-reduced
Sheet: Sheet1

 |  |  |  |  | A | B | C | D | E | F | G | H | I | J | # USED
 |  |  |  |  | 1 | 0 | 2 | 0 | 0.5 | 1 | 0 | 1 | 0 | 0 | 5
 |  |  |  |  | 6 |  | 8 |  | 10 | 11 |  | 13
offset col. | item count | column | description | qty
1 | 1 | 1 | A | 1
3 | 2 | 2 | C | 2
5 | 3 | 2 | E | 0.5
6 | 4 | 1 | F | 1
8 | 5 | 2 | H | 1
 | NO
 | NO
 | NO
 |  |  |  | description | quantity
 |  |  |  | A | 1
 |  |  |  | C | 2
 |  |  |  | E | 0.5
 |  |  |  | F | 1
 |  |  |  | H | 1
Spreadsheet: 646b35df-48e0-4b70-859e-77e5230df143
Sheet: CDS-G

G. ANNUAL EXPENSES
G0 | Please provide the URL of your institution’s net price calculator:
 | Provide 2012-2013 academic year costs of attendance for the following categories that are applicable to your institution.
 | Check here if your institution's 2012-2013 academic year costs of attendance are not available at this time and provide an approximate date (i.e., month/day) when your institution's final 2012-2013 academic year costs of attendance will be available:
[NAME] | Undergraduate full-time tuition, required fees, room and board [NAME] the typical tuition, required fees, and room and board for a full-time undergraduate student for the FULL 2012-2013 academic year (30 semester or 45 quarter hours for institutions that derive annual tuition by multiplying credit hour cost by number of credits). A full academic year refers to the period of time generally extending from September to June; usually equated to two semesters, two trimesters, three quarters, or the period covered by a four-one-four plan. Room and board is defined as double occupancy and 19 meals per week or the maximum meal plan. Required fees include only charges that all full-time students must pay that are not included in tuition (e.g., registration, health, or activity fees.) Do not include optional fees (e.g., parking, laboratory use).
[NAME] |  | First-Year | Undergraduates
[NAME] | PRIVATE INSTITUTIONS Tuition:
[NAME] | PUBLIC INSTITUTIONS Tuition:     In-district | 2540 | 2540
[NAME] | PUBLIC INSTITUTIONS      In-state (out-of-district): | 2540 | 2540
[NAME] | PUBLIC INSTITUTIONS     Out-of-state: | 10423 | 10423
[NAME] | NONRESIDENT ALIENS Tuition:
[NAME] | REQUIRED FEES: | 223 | 223
[NAME] | ROOM AND BOARD: (on-campus)
[NAME] | ROOM ONLY: (on-campus)
[NAME] | BOARD ONLY: (on-campus meal plan)
[NAME] | Comprehensive tuition and room and board fee (if your college cannot provide separate tuition and room and board fees):
[NAME] | Other:
G2 |  |  | Minimum | Maximum
G2 | Number of credits per term a student can take for the stated full-time tuition |  | 12 | 12
G3 |  |  | Yes | No
G3 | Do tuition and fees vary by year of study (e.g., sophomore, junior, senior)? |  |  | x
G4 |  |  | Yes | No
G4 | Do tuition and fees vary by undergraduate instructional program? |  | X
G4 |  |  | %
G4 | If yes, what percentage of full-time undergraduates pay more than the tuition and fees reported in G1? |  | 0.047
G5 | Provide the estimated expenses for a typical full-time undergraduate student:
G5 |  | Residents | Commuters (living at home) | Commuters (not living at home)
G5 | Books and supplies |  |  | 1749
G5 | Room only
G5 | Board only
G5 | Room and board total  (if your college cannot provide separate room and board figures for commuters not living at home): |  |  | 8712
G5 | Transportation
G5 | Other expenses |  |  | 4815
G6 | Undergraduate per-credit-hour charges (tuition only)
G6 | PRIVATE INSTITUTIONS:
G6 | PUBLIC INSTITUTIONS      In-district: | 106
G6 | PUBLIC INSTITUTIONS      In-state (out-of-district): | 106
G6 | PUBLIC INSTITUTIONS      Out-of-state: | 434
G6 | NONRESIDENT ALIENS:
Spreadsheet: 194470d1353184186-lost-the-view-of-12-excel-cells-as-well-as-their-corresponding-vertical-axis-labels-problems
Sheet: Sheet1

[NAME]
 | Orders | £ per Parcel | [NAME] | Variance/ Parcel | Additonal £ P/M | Avg Daily Order Per Day | Working Days | Total Days Worked | 12M Orders Fit | 12M £ per Parcel | Additonal 12M £ P/A
January | 363 | 6.3 | £4.41 | 1.89 | 686.17 | 17.28571428571428 | 21 | 21 | 2584 | 10.62 | -16048.56 |  |  |  |  | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False | False
February | 438 | 5.22 | £4.41 | 0.8099999999999996 | 355.42 | 23.05263157894737 | 21 | 19 | 3022 | 9.08 | -14116.98
March | 461 | 4.96 | £4.41 | 0.5499999999999998 | -253.99 | 20.95454545454545 | 22 | 22 | 3483 | 7.88 | -12083.97
April | 434 | 5.27 | £4.41 | 0.8599999999999994 | -373.06 | 27.125 | 19 | 16 | 3917 | 7.01 | -10170.03
May | 390 | 5.86 | £4.41 | 1.45 | -567.1 | 25.16129032258064 | 22 | 15.5 | 4307 | 6.37 | -8450.13
June | 439 | 5.21 | £4.41 | 0.7999999999999998 | -351.01 | 23.72972972972973 | 19 | 18.5 | 4746 | 5.78 | -6514.14
July | 500 | 4.57 | £4.41 | 0.1600000000000001 | -82 | 22.72727272727273 | 22 | 22 | 5246 | 5.23 | -4309.14
August | 511 | 4.48 | £4.41 | 0.07000000000000028 | -33.49 | 24.33333333333333 | 22 | 21 | 5757 | 5.06 | -3506.52
September | 512 | 4.47 | £4.41 | 0.05999999999999961 | -29.08 | 28.44444444444444 | 20 | 18 | 6269 | 5.05 | -3458.01
October
November
December
Complaints
 | No. | Month Orders | % Complaints to Orders | Target | Against Target | 12 Mnths Comp | 12Mnths Orders | % Complaints to Orders | 0.30% Target
January | 2 | 509 | 0.003929273084479371 | 0.30% | -0.000929273084479371 | 17 | 3559 | 0.004776622646810902 | -0.001776622646810902
February | 0 | 571 | 0 | 0.30% | 0.003 | 17 | 4130 | 0.004116222760290557 | -0.001116222760290557
March | 5 | 585 | 0.008547008547008548 | 0.30% | -0.005547008547008548 | 22 | 4715 | 0.004665959703075291 | -0.001665959703075291
April | 2 | 582 | 0.003436426116838488 | 0.30% | -0.0004364261168384878 | 24 | 5297 | 0.004530866528223523 | -0.001530866528223523
May | 2 | 626 | 0.003194888178913738 | 0.30% | -0.0001948881789137378 | 26 | 5923 | 0.0043896673982779 | -0.0013896673982779
June | 1 | 503 | 0.001988071570576541 | 0.30% | 0.00101192842942346 | 27 | 6426 | 0.004201680672268907 | -0.001201680672268907
July | 0 | 545 | 0 | 0.30% | 0.003 | 27 | 6971 | 0.003873188925548702 | -0.0008731889255487019
August | 3 | 565 | 0.005309734513274336 | 0.30% | -0.002309734513274336 | 30 | 7536 | 0.003980891719745223 | -0.0009808917197452229
September | 5 | 626 | 0.007987220447284345 | 0.30% | -0.004987220447284345 | 35 | 8162 | 0.004288164665523156 | -0.001288164665523156
October
November
December
Spreadsheet: 874983d1721528218-conditional-formatting-only-applies-to-source-cells-when-copying-jockuly-usv-lists-copy-dei
Sheet: Redesign

Session |  |  |  | Interaction |  |  |  |  | Character |  |  |  |  | Validation |  |  |  | [NAME].
Date | Trainer | Type | Order | ID | 0 | Plus | Time | Level | [NAME] | Duration | Bandwidth | Intensity | [NAME] | WAV # | Observed Signals | Recorded  30+? | Channel Confirmed | Comments
 |  |  |  |  | 2 |  |  |  | Minimum  Maximum |  |  |  | Modulated |  | 0 | False | False
Spreadsheet: 851021d1701286445-conditional-formatting-question-if-this-then-that-ecxel-proposal-copy
Sheet: Sheet1

Company | sample | sample | sample
location | 47 | 5 | 6
location | 16 | 2 | 1 |  | LEVER ESCALATION
location | 5 | 0 | 1
location | 8 | 3 | 0
EDs: | sample | sample | sample |  | LEVER ESCALATION
location | 47 | 5 | 6 |  | I would like this text to appear when D10 is between 6-10
location | 16 | 2 | 1
location | 5 | 0 | 1 |  | I would like this text to appear when D10 is between 11-15
location | 8 | 3 | 0
Spreadsheet: 875660d1722271842-using-formula-to-calculate-weighted-average-by-getting-numbers-from-multiple-sheets-weighted-average-sample
Sheet: Consolidated

 |  | Month |  | 2024-06-01 00:00:00 | 30 | days |  |  |  |  | Month |  | 2024-06-01 00:00:00 | 30 | 30 | 30 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  | DIV A | DIV B | DIV C | Consolidated
 |  | Clients (Funded) |  |  |  |  |  |  |  |  | Clients (Funded) |  |  | 24 | 27 | 28
 |  | Weekly Avg Fees Achieved (Funded) |  |  |  | Weighted Average |  |  |  |  | Weekly Avg Fees Achieved (Funded) |  |  | 450 | 375 | 550
 |  | Clients non Funded |  |  |  |  |  |  |  |  | Clients non Funded |  |  | 17 | 15 | 22
 |  | Weekly Avg Fees Achieved (Private) |  |  |  | Weighted Average |  |  |  |  | Weekly Avg Fees Achieved (Private) |  |  | 900 | 850 | 750
 |  | Total Clients |  |  |  |  |  |  |  |  | Total Clients |  |  | 41
 |  | Fee Billed - Funded |  |  |  |  |  |  |  |  | Fee Billed - Funded
 |  | Fee Billed - non Funded |  |  |  |  |  |  |  |  | Fee Billed - non Funded
 |  |  |  |  |  |  |  |  |  |  | Check
 |  |  |  |  |  |  |  |  |  |  | Fee Billed - Funded
 |  |  |  |  |  |  |  |  |  |  | Fee Billed - non Funded
Spreadsheet: 804157d1667919829-auto-sorting-a-various-columns-based-on-one-column-book1
Sheet: Main (3)

 | DEPT | TASK | START | DEADLINE | COMM | OP
 | management | test1 |  | EARLY NOV
2 | housekeeping | test2 |  | EARLY NOV
3 | housekeeping | test3 |  | 2022-10-31 00:00:00
4 | housekeeping | test4 |  | 2022-10-31 00:00:00
5 | housekeeping | test5 |  | 2022-10-31 00:00:00
6 | housekeeping | test6 |  | 2022-10-31 00:00:00
7 | maintenance | [NAME] |  | 2022-10-31 00:00:00
8 | maintenance | test8 |  | EARLY NOV
9 | maintenance | test9 |  | EARLY NOV
10 | maintenance | test10 |  | EARLY NOV
11 | service | test11 |  | EARLY NOV
12 | service | test12 |  | ASAP
13 | service | test13 |  | EARLY NOV
14 | service | test14 |  | 2022-10-25 00:00:00
15 | service | test15 |  | ASAP
16 | everyone | test16 |  | ASAP
17 | everyone | test17 |  | ASAP
18 | everyone | test18 |  | ASAP
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
Spreadsheet: 682474d1592128738-help-with-drivers-hours-calculations-2020-06-14-oeldere-motzil-682470d1592124157-help-with-drivers-hours-calculations-weekly-runni
Sheet: Sheet1

Date | Day | [NAME] | Start Location | End Millage | End Location | Total Miles | Start Time | Finish Time | Total Hrs Worked | Daily Rest | Driving hours
2020-06-07 00:00:00 | Sun
2020-06-08 00:00:00 | Mon | 421537 | Halfway | 421969 | Oakham |  | 00:45:00 | 15:45:00 |  | 09:30:00
2020-06-09 00:00:00 | [NAME] | 421969 | Oakham | 422376 | Ashford |  | 01:14:00 | 16:13:00 |  | 11:02:00
2020-06-10 00:00:00 | Weds | 422376 | Ashford | 422777 | Basildon |  | 03:45:00 | 18:42:00 |  | 10:53:00
2020-06-11 00:00:00 | Thurs | 422777 | Basildon | 423008 | [NAME] |  | 04:15:00 | 18:56:00 |  | 11:27:00
2020-06-12 00:00:00 | Fri | 423008 | [NAME] | 423348 | [NAME] |  | 05:23:00 | 18:03:00 |  | 11:12:00
2020-06-13 00:00:00 | Sat | 423348 | [NAME] | 423538 | Halfway |  | 05:15:00 | 11:00:00
 |  |  |  |  | Total
Spreadsheet: daren_farmer__6618__January Survey
Sheet: Hours

 | 0758
 | Staff
RC | Position | Activity Name | Hours
0758 | Staff | Cash Forecasting, Calls, & Collections
0758 | Staff | Customer Service
0758 | Staff | G/L Interface/Downloads
0758 | Staff | Participate in Training
0758 | Staff | Preparing Payments-3rd Party
0758 | Staff | Process Bank Deposits
0758 | Staff | Process Innercompany Transactions
0758 | Staff | Process/Apply Cash Receipts
0758 | Staff | Reconciling
Spreadsheet: 813864d1674035525-drag-cells-and-go-every-2-cells-1-test
Sheet: Tabelle1

 | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-10-01 00:00:00
 | IST | OBLIGO | IST | OBLIGO | IST | OBLIGO | IST | OBLIGO
321-01
321-02
321-03
 | xxx | Date | zzz | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00
name1 |  | 2023-01-30 00:00:00 | 1 | PZM321-01 | PZM321-02 | PZM321-03 | PZM321-03
[NAME] |  | 2022-03-12 00:00:00 | 1 | PZM321-02 |  | PZM321-03
name3 |  | 2021-06-23 00:00:00 | 1 |  | PZM321-01 | PZM321-01 | PZM321-01
name4 |  | 2023-06-23 00:00:00 | 1 | PZM321-01 | PZM321-03 |  | PZM321-02
name5 |  | 2021-03-12 00:00:00 | 1 | PZM321-02 | PZM321-01 | PZM321-03 | PZM321-03
name6 |  | 2020-06-30 00:00:00 | 1 | PZM321-03 | PZM321-02 | PZM321-01
name7 |  | 2023-01-30 00:00:00 | 1 |  |  | PZM321-02 | PZM321-02
name8 |  | 2022-03-12 00:00:00 | 1 | PZM321-02 | PZM321-01 |  | PZM321-01
name9 |  | 2021-06-23 00:00:00 | 1 | PZM321-03 | PZM321-02 | PZM321-02 | PZM321-02
Spreadsheet: 191666d1352175844-combine-iferror-and-vlookup-am-in-barking-up-the-wrong-tree-here-example-1
Sheet: Sheet1

2013 Adjusted Modulus Calculator
Mainsails
P (m) = | 9.8 | Minimum Required AM for C-Cut Dacron = |  | 82.27000842566582
E (m) = | 3.5 | Minimum Required AM for 3D, Radian & Laminates = |  | 60.45675339687991
Headsails
Using I, J & LP% |  |  | Using Sail Type, LL & LP
I  (m) = | 10.3 |  | [NAME] = | Non Overlapping
J (m) = | 3.4 |  | [NAME] (m) = | 10.2
LP% | 1 |  | LP (m) = | 3.4
[NAME] | 25 |  | [NAME] | 25
Calculated LL = | 10.68395859454725
Marathon 600 (100% Aramid)
 |  | DPI (recommended)
Minimum Required AM = | 78.39576634235476 |  | Minimum Required AM = | 71.45433155992379
Spreadsheet: 723836d1615911916-take-multiple-data-points-from-a-row-by-searching-on-the-first-column-row_array_issuesumproduct-and-sumifsindex
Sheet: Sheet1

 | Selected Date | 2021-03-10 00:00:00
 |  | Fred | [NAME] | Rebecca | [NAME] | An Ni | Juan | Olive | Vince
 | 2021-03-08 00:00:00 | 0 | 121 | 0 | 0 | 0 | 0 | 0 | 8
 | 2021-03-09 00:00:00 | 0 | 63 | 0 | 0 | 0 | 0 | 58 | 91
 | 2021-03-10 00:00:00 | 0 | 27 | 0 | 0 | 0 | 26 | 22 | 26
 | 2021-03-11 00:00:00 | 0 | 59 | 0 | 0 | 0 | 64 | 27 | 40
 | 2021-03-12 00:00:00 | 0 | 43 | 0 | 0 | 41 | 11 | 12 | 48
 | Ideal Outcome | Fred
 |  | [NAME]
 |  | Rebecca
 |  | [NAME]
 |  | An Ni
 |  | Juan
 |  | Olive
 |  | Vince
Spreadsheet: 805065d1668518510-date-auto-filling-from-day-1-to-the-last-day-of-the-month-date-count-excel
Sheet: MngntShift

 |  | Month | 2020-02-01 00:00:00