tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 736292d1623476795-sumif-based-on-date-range-giving-error-euro-pool-2020-master-sheet
Sheet: Payment List

 | [NAME] | [NAME] | [NAME] | Krishna | Manreet | Ganesh | Balan | [NAME] | [NAME] | [NAME] | TOTAL
Paid |  | 110 | 110 |  | 110 | 110 |  |  |  | 110
Expected Payment | 100 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110 | 110
Spreadsheet: 94839d1294607432-retreiving-multiple-matches-values-in-same-row-if-x-is-true-1test
Sheet: Hours

Hours
 |  | Line A |  |  |  |  | Line B |  |  |  |  | Line C |  |  |  |  | Line D
 |  | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5
Saturday | 2011-01-01 00:00:00 | 8 | 8 | 8 | 8 | 8 | 7.75 | 7.75 | 7.75 | 7.75 | 7.75 | 8 | 8 | 8 | 8 | 8 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5
Sunday | 2011-01-02 00:00:00 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 8 | 8 | 8 | 8 | 8 | 7.5 | 7.5 | 7.5 | 7.5 | 7.5 | 8 | 8 | 8 | 8 | 8
Monday | 2011-01-03 00:00:00 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
Tuesday | 2011-01-04 00:00:00 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
Wednesday | 2011-01-05 00:00:00 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
Thursday | 2011-01-06 00:00:00 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
Friday | 2011-01-07 00:00:00 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
Saturday | 2011-01-08 00:00:00
Sunday | 2011-01-09 00:00:00
Monday | 2011-01-10 00:00:00
Tuesday | 2011-01-11 00:00:00
Wednesday | 2011-01-12 00:00:00
Thursday | 2011-01-13 00:00:00
Friday | 2011-01-14 00:00:00
Saturday | 2011-01-15 00:00:00
Sunday | 2011-01-16 00:00:00
Monday | 2011-01-17 00:00:00
Tuesday | 2011-01-18 00:00:00
Wednesday | 2011-01-19 00:00:00
Thursday | 2011-01-20 00:00:00
Friday | 2011-01-21 00:00:00
Saturday | 2011-01-22 00:00:00
Sunday | 2011-01-23 00:00:00
Monday | 2011-01-24 00:00:00
Tuesday | 2011-01-25 00:00:00
Wednesday | 2011-01-26 00:00:00
Thursday | 2011-01-27 00:00:00
Friday | 2011-01-28 00:00:00
Saturday | 2011-01-29 00:00:00
Sunday | 2011-01-30 00:00:00
Monday | 2011-01-31 00:00:00
Spreadsheet: 148263d1333309813-reducing-file-size-book1
Sheet: Sheet8

x | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 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 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111
V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | V | AAA | 2.851022 |  | 19960131 | 20120328 | 12 | 26 | 9 | M |  | START_DATE_OVERRIDE | [NAME] | TECH_STUDIES_PARAM1_OVERRIDE | TECH_STUDIES_PARAM2_OVERRIDE | TECH_STUDIES_PARAM3_OVERRIDE | [NAME]
1
2
4
5
6
Spreadsheet: 795595d1662791041-calculate-average-but-exclude-weekend-and-public-holiday-book1-hd
Sheet: Cal

 | May | Day | Total
 | 2022-05-01 00:00:00 |  | 5 |  |  | Date | Day
 |  |  | 4 |  |  | 2022-01-01 00:00:00 | Saturday
 |  |  | 5 |  |  | 2022-02-01 00:00:00 | Tuesday
 |  |  | 4 |  |  | 2022-02-02 00:00:00 | Wednesday
 |  |  | 5 |  |  | 2022-04-15 00:00:00 | Friday
 |  |  | 6 |  |  | 2022-05-01 00:00:00 | Sunday
 |  |  | 7 |  |  | 2022-05-03 00:00:00 | Tuesday
 |  |  | 8 |  |  | 2022-05-15 00:00:00 | Sunday
 |  |  | 3 |  |  | 2022-07-10 00:00:00 | Sunday
 |  |  | 5 |  |  | 2022-10-24 00:00:00 | Monday
 |  |  | 6 |  |  | 2022-12-25 00:00:00 | Sunday
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 3
 |  |  | 6
 |  |  | 8
 |  |  | 3
 |  |  | 6
 |  |  | 9
 |  |  | 5
 |  |  | 1
 |  |  | 4
 |  |  | 6
 |  |  | 7
 |  |  | 4
 |  |  | 3
 |  |  | 2
 |  |  | 5
 |  |  | 7
 |  |  | 8 |  | HD
 | Ave/mth
 |  |  |  |  |  |  | \
Spreadsheet: phillip_m_love__30655__9901_OA
Sheet: WE-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 19766941 | 37756664
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 14254931 | 26063190
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 34021872 | 63819854
 | Purchases:
6 |  | 3rd Party / Inter Enron | -17073962 | -30540863
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -17161515 | -32130997
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 282518 | 486431
 | Total Purchases: |  | -33952959 | -62185429
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 1557 | 2708
14 |  | Cash Out | -21287 | -34838.01899006216
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | -19730 | -32130.01899006216
 | Storage:
17 |  | Injection (Sales to Stg) | 40309 | 63698
18 |  | W/D (Purchase from Stg) | -89492 | -155668
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -89492 | -155668
 | Total Storage: |  | -49183 | -91970
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | 0 | 0
23 | Fuel: |  | -282518 | -486431
 | Transport Expense:
24 |  | Commodity | 0 | -289291
25 |  | Demand | 0 | -2835684
 | Total Transport Expense: |  | 0 | -3124975
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 757450.83
31 |  | Prior Month Book Balance | 0 | -2616399
 |  | Total MTM Income | 0 | -1858948.17
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 2590143.24
34 |  | Originations | 0 | 4105
35 |  | Broker Fees | 0 | -11114
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 1621506
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -110
 |  | TOTAL
Spreadsheet: 585638d1533880625-help-with-solver-inputs-wall-design-2
Sheet: 2. Wind Loading

Wind Loading
VR | 57 | m/s
Md Post | 0.95
[NAME] | 1
Mz,cat | 0.83
Ms | 1
Mt | 1
Vsit,β Post |  | m/s
Vsit,β Girt |  | m/s
p air | 1.2
kp | 1
b
c
h
b/c
c/h
Cpn Θ=0
b/c | c/h | [NAME] | e
>5 | 0.2 to 1 |  | 0
[NAME] Θ=45
b/c | c/h | [NAME] | x1 | x2
>5 | >0.7 | 2.4 | 0
>5 | >0.7 | 1.2
>5 | >0.7 | 0.6
Cpn Θ=90
b/c | c/h | - Cpn | + Cpn | x1 | x2
All | >0.7 | -1 | 1 | 0
All | >0.7 | -0.25 | 0.25
All | >0.7 | -0.25 | 0.25
x1 | x2 | [NAME] | Cdyn | Pressure Post (Pa) | Pressure Girt (Pa)
0 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
 |  |  | 1
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 7

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
1 3 |  |  | 16:17    22:32 | 12:07    21:27 | 14:31    23:31 | 14:00    23:00 | 14:00    22:00
 | 13:55    23:49 |  | 15:11     6:53 | 21:55     6:47
 | 6:00     14:00 | 6:22     13:44 |  |  | 22:17     8:34 | 23:01     8:11
 | 14:30     0:29 | 14:50     0:01 | 15:40    22:47 | 14:00    22:00
 |  | 19:12     7:34 |  |  | 6:12     16:38 | 14:25    23:44 | 19:17     6:32
 | 22:17     6:34 |  | 14:00    23:00 | 14:00    22:24
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
1 4 |  |  |  | 14:00    22:24 | 13:07    22:27 | 23:17     7:34 | 22:17     6:34
 |  | 16:17    22:32 | 13:25    23:32 | 14:17    23:39
 | 7:55     16:51 | 7:12     15:39 | 5:55     14:17 |  |  | 7:01     14:11 | 13:10    21:29
 | 14:31    23:31 | 14:17    23:39 | 14:31    23:31 | 13:22    22:22
 |  | 13:30    21:27 | 14:50     0:01 |  |  | 8:01     14:54 | 9:17     18:47
 | 7:00     16:00 | 14:00    23:00 | 12:07    21:27 | 13:25    20:54
Spreadsheet: 837100d1689850671-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-132-aligw
Sheet: MAPPING

DATABASE: |  |  | <- 1- This is the path that you chose in Cost Analysis, it changes the Database to analyze.
Last Raw
Size
 |  | Where | Key | Price
 |  |  |  |  |  | <- The formula that doesn't work is in red, And in green what it supposed to show
Spreadsheet: 780151d1652309990-pull-all-data-from-a-tab-into-a-summary-tab-using-a-specific-person-and-a-specific-date-ytd-survey-results-sales
Sheet: Summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rep | Sheet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wilma | January
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | February
March |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | March
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | April
AGENT NAME | Numbers | Data Time | Data | CALL TYPE | CallSurvey.QuestionOne | CallSurvey.QuestionTwo | CallSurvey.QuestionThree | CallSurvey.QuestionFour | CallSurvey.Reason_For_Score
Spreadsheet: 804688d1668217582-mmulti-function-help-popcorn
Sheet: Sheet3

 |  | s | 4 | 5 | 6 | 8 | 9 | 10 | Win | Lose
 | s | 0 | 0.0833333 | 0.111111 | 0.138889 | 0.138889 | 0.1111111 | 0.083333 | 0.2222222 | 0.111111111
 | 4 | 0 | 0.416666 | 0 | 0 | 0 | 0 | 0 | 0.416666 | 0.16667
 | 5 | 0 | 0 | 0.416666 | 0 | 0 | 0 | 0 | 0.416666 | 0.16667
 | 6 | 0 | 0 | 0 | 0.416666 | 0 | 0 | 0 | 0.416666 | 0.16667
 | 8 | 0 | 0 | 0 | 0 | 0.416666 | 0 | 0 | 0.416666 | 0.16667
 | 9 | 0 | 0 | 0 | 0 | 0 | 0.416666 | 0 | 0.416666 | 0.16667
 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0.416666 | 0.416666 | 0.16667
 | Win | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 | Lose | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
 |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: darrell_schoolcraft__7825__imbalsumm0109
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 58538 | 63848
2 | 58642 | 55697
3 | 58406 | 59792
4 | 59692 | 63944
5 | 46721 | 47218
6 | 54155 | 54685
7 | 64066 | 62444
8 | 58452 | 62839
9 | 59525 | 62898
10 | 58572 | 62898
11 | 64462 | 63297
12 | 54763 | 53475
13 | 63725 | 61376
14 | 64469 | 63350
15 | 65261 | 64520
16 | 65102 | 64520
17 | 65688 | 64520
18 | 61645 | 61928
19 | 61219 | 59779
20 | 63542 | 62190
21 | 62220 | 62257
22 | 63398 | 62633
23
24
25
26
27
28
29
30
31
2001-08-31 00:00:00 |  |  | 14916.9
2001-09-22 00:00:00
CBS Volume
 |  |  | 5234
Spreadsheet: 157715d1337853921-copy-and-pasting-calculations-and-graphs-example-1
Sheet: Ind Services

 | Statement 70
 |  |  | Stongly Agree | Agree | Neutral | Disagree | Strongly Disagree | Total |  |  |  | Stongly Agree | Agree | Neutral | Disagree | Strongly Disagree
 | Survey Result | 0.85
 | V01 |  |  |  |  |  |  |  |  |  | V01
 | V02 |  |  |  |  |  |  |  |  |  | V02
 | V03 |  |  |  |  |  |  |  |  |  | V03
 | V04 |  |  |  |  |  |  |  |  |  | V04
 | V05 |  |  |  |  |  |  |  |  |  | V05
 | V06 |  |  |  |  |  |  |  |  |  | V06
 | V07 |  |  |  |  |  |  |  |  |  | V07
 | V08 |  |  |  |  |  |  |  |  |  | V08
 | V09 |  |  |  |  |  |  |  |  |  | V09
 | V10 |  |  |  |  |  |  |  |  |  | V10
 | V01 |  |  | V02 |  |  | V03 |  |  | V04 |  |  | V05 |  |  | V06 |  |  | V07 |  |  | V08 |  |  | V09 |  |  | V10
 | Stongly Agree |  |  | Stongly Agree |  |  | Stongly Agree |  |  | Stongly Agree |  |  | Stongly Agree |  |  | Stongly Agree | 0 |  | Stongly Agree | 0 |  | Stongly Agree | 0 |  | Stongly Agree | 0 |  | Stongly Agree | 0
 | Agree |  |  | Agree |  |  | Agree |  |  | Agree |  |  | Agree |  |  | Agree | 0 |  | Agree | 0 |  | Agree | 0 |  | Agree | 0 |  | Agree | 0
 | Neutral |  |  | Neutral |  |  | Neutral |  |  | Neutral |  |  | Neutral |  |  | Neutral | 0 |  | Neutral | 0 |  | Neutral | 0 |  | Neutral | 0 |  | Neutral | 0
 | Disagree |  |  | Disagree |  |  | Disagree |  |  | Disagree |  |  | Disagree |  |  | Disagree | 0 |  | Disagree | 0 |  | Disagree | 0 |  | Disagree | 0 |  | Disagree | 0
 | Strongly Disagree |  |  | Strongly Disagree |  |  | Strongly Disagree |  |  | Strongly Disagree |  |  | Strongly Disagree |  |  | Strongly Disagree | 0 |  | Strongly Disagree | 0 |  | Strongly Disagree | 0 |  | Strongly Disagree | 0 |  | Strongly Disagree | 0
 | Total |  |  | Total |  |  | Total |  |  | Total |  |  | Total |  |  | Total |  |  | Total |  |  | Total |  |  | Total |  |  | Total
 |  | Overall Agmt |  |  | Overall Agmt |  |  | Overall Agmt |  |  | Overall Agmt |  |  | Overall Agmt |  |  | Overall Agmt |  |  | Overall Agmt |  |  | Overall Agmt |  |  | Overall Agmt |  |  | Overall Agmt
Spreadsheet: richard_shapiro__32187__midatlantic-headcount
Sheet: Sheet1

Enron Government Affairs - The Americas Cost Center 100087 - Montovano
2001-2003 OPERATING & STRATEGIC PLAN
Headcount Summary
 |  |  |  |  |  | Estimated |  | Year End Plan
 |  |  |  |  |  | 12/31/00 |  | 2001 |  | 2002 |  | 2003
Domestic Employees
 | Full Time |  |  |  |  | 12 |  | 12 |  | 12 |  | 12
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees
 | 3rd Party Contract |  |  |  |  | 1 |  | 1 |  | 1 |  | 1
 | Total
International Employees
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees
 | 3rd Party Contract
 | Total
Total Domestic & International
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | Open Positions
 |  | Total Employees (1)
 | 3rd Party Contract (2)
 | Total  *
Location of Total Employees (1)
 | Domestic
 |  | 1400 Smith |  |  |  | 3 |  | 3 |  | 3 |  | 3
 |  | [NAME]
 |  | Omaha
 |  | Other |  |  |  | 9 |  | 9 |  | 9 |  | 9
 | Expatriates
 | International
 | Total
Location of 3rd Party Contractors (2)
 | Domestic
 |  | 1400 Smith
 |  | [NAME]
 |  | Omaha
 |  | Other |  |  |  | 1 |  | 1 |  | 1 |  | 1
 | Expatriates
 | International
 | Total
Total Employees by Location *
 | * Totals should tie.
Spreadsheet: 692101d1598084976-is-there-a-formula-or-function-that-does-the-same-as-an-advanced-filter-but-automatically-2020-08-22-oeldere-cormac95-692050d1598029660-is-there-a-formula-or-function-that-does-the-s
Sheet: JOBS

Date | Customer | Machine | Model | Serial Number | Hours Worked | KM Travelled | Code | Order Number | Expenses | Details of work carried out | Engineer | Report Number
2020-01-01 00:00:00 | BBB | CCC | DDD | EEE | 10 | 20 | INS | 1601 | 120 | KKK | LLL | 501
2020-01-02 00:00:00 | BBB | CCC | DDD | EEE | 20 | 40 | INS | 1602 | 140 | KKK | LLL | 502
2020-01-03 00:00:00 | BBB | CCC | DDD | EEE | 30 | 60 | INS | 1603 | 160 | KKK | LLL | 503
2020-01-04 00:00:00 | BBB | CCC | DDD | EEE | 40 | 80 | CS | 1604 | 180 | KKK | LLL | 504
2020-01-05 00:00:00 | BBB | CCC | DDD | EEE | 50 | 100 | CS | 1605 | 200 | KKK | LLL | 505
2020-01-06 00:00:00 | BBB | CCC | DDD | EEE | 60 | 120 | CS | 1606 | 220 | KKK | LLL | 506
2020-01-07 00:00:00 | BBB | CCC | DDD | EEE | 70 | 140 | SCK | 1607 | 240 | KKK | LLL | 507
2020-01-08 00:00:00 | BBB | CCC | DDD | EEE | 80 | 160 | SCK | 1608 | 260 | KKK | LLL | 508
2020-01-09 00:00:00 | BBB | CCC | DDD | EEE | 90 | 180 | SCK | 1609 | 280 | KKK | LLL | 509
2020-01-10 00:00:00 | BBB | CCC | DDD | EEE | 100 | 200 | INS | 1610 | 300 | KKK | LLL | 510
2020-01-11 00:00:00 | BBB | CCC | DDD | EEE | 110 | 220 | INS | 1611 | 320 | KKK | LLL | 511
2020-01-12 00:00:00 | BBB | CCC | DDD | EEE | 120 | 240 | INS | 1612 | 340 | KKK | LLL | 512
2020-01-13 00:00:00 | BBB | CCC | DDD | EEE | 130 | 260 | INS | 1613 | 360 | KKK | LLL | 513
Spreadsheet: 70687d1271403320-multiple-drop-down-box-using-the-same-values-when-tick-box-selected-book1
Sheet: Sheet1

 | Input 1 |  |  |  |  |  |  |  | Input 2
 |  | timber, load |  | 90 | ° to the grain, |  |  |  |  | timber, load |  | 90 | ° to the grain,
 | 3 | [NAME] flitch plate, grade |  |  |  | dowel |  |  | 3 | [NAME] flitch plate, grade |  |  |  | dowel
1 | Strength Class cell link, load capacity Vs timber thickness
2 | Strength Class cell link, load capacity Vs dowel diameter
1 | [NAME] cell link load capacity Vs timber thickness
2 | [NAME] cell link load capacity Vs dowel diameter
False | [NAME] cell link
[NAME]
 | Strength Class | Characteristic Density (kg/m³) |  |  |  | [NAME] | Ultimate Tensile Strength (N/mm²)
1 | C16 | 310 |  |  | 1 | 4.6 | 400
2 | C18 | 320 |  |  | 2 | 4.8 | 400
3 | C20 | 330 |  |  | 3 | 5.6 | 500
4 | C22 | 340 |  |  | 4 | 6.8 | 600
5 | C24 | 350 |  |  | 5 | 8.8 | 800
6 | C27 | 370 |  |  | 6 | 9.8 | 900
7 | C30 | 380 |  |  | 7 | 10.9 | 1000
8 | C35 | 400 |  |  | 8 | 12.9 | 1200
9 | C40 | 420
10 | GL24h | 380
11 | GL32h | 430
Spreadsheet: 726524d1617284253-need-help-with-vlookup-based-on-if-and-and-vlookup-with-if-and
Sheet: Product B

 | Customer name | Product B
 | VSOP
 | MANU
 | MANC
 | LIVP
 | ARSE
 | TOTH
 | QPRA
 | NOTF
 | CHFC
 | LCFC
 | [NAME]
 | ASAP
 | PLSE
 | ADEV
 | ALKP
Spreadsheet: joe_parks__14938__bridgeline 4-22
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
S | NGK2 | 3577 | 14 | 08:10:26 | 905 | 97563 | 4C | 3255 | amk | EO-3255 | 1440 | 0 | N
S | NGK2 | 3590 | 24 | 08:49:58 | 905 | 97563 | 4C | 3421 | amk | EO-3421 | 1580 | 0 | N
S | NGK2 | 3600 | 14 | 07:57:25 | 905 | 97563 | 4C | 3171 | [NAME] | EO-3171 | 1372 | 0 | N
Spreadsheet: 686761d1594807454-min-max-calc-for-financial-projection-fm-mhc-model-excelforum-
Sheet: CapEx

Capital Expenditures | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | MONTHLY CapEx |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 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 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120
 |  |  |  |  |  |  |  |  |  |  |  |  | Unit $
Motif
Street Signage |  |  |  |  |  |  |  |  |  |  |  |  |  | 15000
Entrance Signage (3) |  |  |  |  |  |  |  |  |  |  |  |  |  | 30000
Grounds
Driveways |  |  |  |  |  |  |  |  |  |  |  |  |  | 200000
Sidewalks
Streets |  |  |  |  |  |  |  |  |  |  |  |  |  | 500000
Landscaping
Entrances |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000
High Impact Areas |  |  |  |  |  |  |  |  |  |  |  |  |  | 25000
Services
Development
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 50000
Piers |  |  |  |  |  |  |  |  |  |  |  |  | 3200
TOTAL
Spreadsheet: 855704d1705218675-extract-text-based-on-multiple-conditions-example-file
Sheet: SET

Before | After applying formula it should look like | REMARKS
12.00-20 MRK X N20 |  | If cell is Not having text "LT" anywhere, then delete text after first space.
LT195/80D15 [NAME] |  | If cell text starts with "LT", then delete text "LT" from the beginning and also delete text after first space.
LT 145/80R12 INS TUBE |  | If cell text starts with "LT ", then delete text "LT " from the beginning and also delete text after next space.
8.25R16LT S1T4 129/127L R16 |  | If cell text Not starts with "LT" and having "LT" in between text (but after any number), then delete text onward from "LT".
7.00-12 MLT N12 |  | If cell text Not starts with "LT" and having "LT" in between text (but after any alphabet), then delete text after first space.
215/75R16LT113/111SM170TT
8.25-20SL50PLUSN16
Spreadsheet: 162515d1339942666-tryin-to-get-a-red-amber-green-colour-scheme-to-appear-within-a-certain-range-of-a-numbr-rhrp-planner_reply
Sheet: Saturday

Department Daily Schedule
Sat | 0600 | 0615 | 0630 | 0645 | 0700 | 0715 | 0730 | 0745 | 0800 | 0815 | 0830 | 0845 | 0900 | 0915 | 0930 | 0945 | 1000 | 1015 | 1030 | 1045 | 1100 | 1115 | 1130 | 1145 | 1200 | 1215 | 1230 | 1245 | 1300 | 1315 | 1330 | 1345 | 1400 | 1415 | 1430 | 1445 | 1500 | 1515 | 1530 | 1545 | 1600 | 1615 | 1630 | 1645 | 1700 | 1715 | 1730 | 1745 | 1800 | 1815 | 1830 | 1845 | 1900 | 1915 | 1930 | 1945 | 2000 | 2015 | 2030 | 2045 | 2100 | 2115 | 2130 | 2145 | 2200 | 2215 | 2230 | 2245 | 2300 | 2315 | 2330 | 2345 | Total
Vac 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Vac 2 |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Vac 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Vac 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Vac 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Total
Allowed Hours |  |  |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
Variance +/-
Tills Open
Spreadsheet: 732018d1620743716-i-need-to-add-a-specific-calculated-field-within-a-pivot-table-cartons-used-analysis
Sheet: Pivots

 |  | Column Labels
 | Row Labels | January | February | March | April | May | June | July | August | September | October | November | December | Grand Total
 | [NAME]
 | Sum of Cash value
 | 2020 | 18195.59 | 5669.6 | 9467.98 | 887.61 | 707.33 | 6556.18 | 14631.38 | 6528.83 | 6886.42 | 7211.77 | 14607.98 | 33350.58 | 124701.25
 | 2021 | 52109.89 | 55682.18 | 45665 |  |  |  |  |  |  |  |  |  | 153457.07
 | Sum of Count of cartons
 | 2020 | 4396 | 1264 | 2102 | 341 | 403 | 1899 | 2963 | 1303 | 1284 | 1186 | 4362 | 6220 | 27723
 | 2021 | 13113 | 18207 | 18467 |  |  |  |  |  |  |  |  |  | 49787
 | [NAME] of Cash value | 70305.48 | 61351.78 | 55132.98 | 887.61 | 707.33 | 6556.18 | 14631.38 | 6528.83 | 6886.42 | 7211.77 | 14607.98 | 33350.58 | 278158.32
 | [NAME] of Count of cartons | 17509 | 19471 | 20569 | 341 | 403 | 1899 | 2963 | 1303 | 1284 | 1186 | 4362 | 6220 | 77510
 | [NAME]
 | Sum of Cash value
 | 2020 | 97.75 | 71 | 88.5 | 50.29 | 57.65 | 56.5 | 41.7 | 9.15 | 0.2 | 207.58 | 290.02 | 199.08 | 1169.42
 | 2021 | 10325 | 12956 | 16054 |  |  |  |  |  |  |  |  |  | 39335
 | Sum of Count of cartons
 | 2020 | 16 | 16 | 12 | 8 | 16 | 11 | 27 | 24 | 44 | 49 | 46 | 34 | 303
 | 2021 | 7124 | 8775 | 9623 |  |  |  |  |  |  |  |  |  | 25522
 | [NAME] of Cash value | 10422.75 | 13027 | 16142.5 | 50.29 | 57.65 | 56.5 | 41.7 | 9.15 | 0.2 | 207.58 | 290.02 | 199.08 | 40504.42
 | [NAME] of Count of cartons | 7140 | 8791 | 9635 | 8 | 16 | 11 | 27 | 24 | 44 | 49 | 46 | 34 | 25825
 | Total Sum of Cash value | 80728.23 | 74378.78 | 71275.48 | 937.9 | 764.98 | 6612.68 | 14673.08 | 6537.98 | 6886.62 | 7419.35 | 14898 | 33549.66 | 318662.74
 | Total Sum of Count of cartons | 24649 | 28262 | 30204 | 349 | 419 | 1910 | 2990 | 1327 | 1328 | 1235 | 4408 | 6254 | 103335
 | What I want the data to look like
 | [NAME] | January | February | March | April | May | June | July | August | September | October | November | December
 | Sum of Cash
 | 2020 | 18195.59 | 5669.6 | 9467.98 | 887.61 | 707.33 | 6556.18 | 14631.38 | 6528.83 | 6886.42 | 7211.77 | 14607.98 | 33350.58
 | 2021 | 52109.89 | 55682 | 45665
 | Sum of cartons
 | 2020 | 4396 | 1264 | 2102 | 341 | 403 | 1899 | 2963 | 1303 | 1284 | 1186 | 4362 | 6220
 | 2021 | 13113 | 18207 | 18467
 | This year vs Last Year Cash
 | This year vs Last year cartons