tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0588faff-73e7-4e4f-85c6-57d638a089a3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 46. OPERATING LEASE FINANCE COMMITMENTS: By Purpose: State (WA), Original (Number, $000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
1. . . [NAME] ; |  |  | Original | A2413759F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413760R | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413761T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413762V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413763W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles ; |  |  | Original | A2413764X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
2. . . Other Transport Equipment ; |  |  | Original | A2413765A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
3. . . Agricultural, Construction & Manufacturing equipment ; |  |  | Original | A2413766C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
4. . . Office Equipment  ; |  |  | Original | A2413767F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
5. . . Other ; |  |  | Original | A2413768J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 95461d1295033241-excel-2007-transposing-data-from-column-cells-into-row-cells-dummybook1
Sheet: Sheet1

 |  | A
 |  | B
 |  | C
 |  | D
 |  | E
 |  |  |  |  | A | B | C | D | E
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  |  |  |  | 1 | 2 | 3 | 4 | 5
Spreadsheet: 25dd81cc-e94d-4d6a-bb81-66961ea06263
Sheet: T44

الجدول 44: النسبة المئوية للإعالة لمجموع السكان خلال سنوات التعداد
Table 44: Dependency ratio during the census years
Country | Round 2000           دورة 2000 |  | Round 2010           دورة 2010 |  | البلد
 | census year سنة التعداد | dependency % نسبة الإعالة | census year سنة التعداد | dependency % نسبة الإعالة
Bahrain | 2001 | 43.66178522849724 | 2010 | 28.50289466178984 | البحرين
Egypt | 1996 | 69.68700438847395 | 2006 | 69.73021738864531 | مصر
Iraq | 1997 | 93.36027156090952 | … | … | العراق
Jordan | 2004 | 68.22721888338114 | … | … | الاردن
Kuwait | 2005 | 36.27159012128486 | 2011 | 32.48007840300545 | الكويت
Lebanon | … | … | … | … | لبنان
Libya |  |  | 2006 | 54.09190546922709 | ليبيا
Morocco | 2004 | 57.51689189189189 |  |  | [NAME]
Oman | 2003 | 57.30783659101635 | 2010 | 43.8654050748277 | عمان
Palestine | 1997 | 102.0566503515685 | 2007 | 89.17227501910958 | فلسطين
Qatar | 2004 | 31.13693405338334 | 2010 | 16.95768990952724 | قطر
Saudi Arabia | 2004 | 59.04145633668879 | … | … | المملكة العربية السعودية
Sudan | … | … | 2008 | 85.16454014327775 | السودان
Syrian Arab Republic | 2004 | 74.375 | … | … | الجمهورية العربية السورية
Tunisia | 2004 | 50.61957556980025 |  |  | تونس
United Arab Emirates | 1995 | 37.67811701928392 | 2005 | 25.51631794760098 | [NAME] المتحدة
Yemen | 2004 | 94.06888081621177 | … | … | اليمن
Spreadsheet: 147995d1333068436-if-text-in-cell-equals-text-in-another-cell-highlight-both-same-color-example-roster-comparison-1-
Sheet: Sheet1

EMPLOYEE ROSTER |  |  |  |  | Company Training
Full Name | Last Name | First Name |  |  | Last Name | First Name
[NAME], [NAME] |  |  |  |  | [NAME] | [NAME]
[NAME], [NAME] |  |  |  |  | [NAME] | [NAME]
Jones, Amanda |  |  |  |  | Jones | Amanda
Sanders, [NAME] |  |  |  |  | Saunders | [NAME]
Smith, [NAME] |  |  |  |  | Smith | Fred
[NAME], [NAME] |  |  |  |  | Smith | Zach
Spreadsheet: 684294d1593273412-help-with-average-formula-please-as-i-need-up-to-date-average-formula-book1
Sheet: Sheet1

DATE | [NAME] | 24hr usage | cycle usage |  | [NAME] | 24hr usage | day total | cycle usage | Total KWh | Time
StartReading | 15517 |  |  |  | 26668
2020-06-19 00:00:00 | 15521 |  |  |  | 26675 |  |  |  |  | 7:35am
2020-06-20 00:00:00 | 15528 |  |  |  | 26684 |  |  |  |  | 7am
2020-06-21 00:00:00 | 15535 |  |  |  | 26692 |  |  |  |  | 8:10am
2020-06-22 00:00:00 | 15541 |  |  |  | 26701 |  |  |  |  | 7:15am
2020-06-23 00:00:00 | 15551 |  |  |  | 26709 |  |  |  |  | 12pm
2020-06-24 00:00:00 | 15555 |  |  |  | 26715 |  |  |  |  | 6:40am
2020-06-25 00:00:00 | 15563 |  |  |  | 26723 |  |  |  |  | 7am
2020-06-26 00:00:00 | 15569 |  |  |  | 26732 |  |  |  |  | 6:30am
2020-06-27 00:00:00 | 15575 |  |  |  | 26741 |  |  |  |  | 8:15am
2020-06-28 00:00:00
2020-06-29 00:00:00
2020-06-30 00:00:00
2020-07-01 00:00:00
2020-07-02 00:00:00
2020-07-03 00:00:00
2020-07-04 00:00:00
2020-07-05 00:00:00
2020-07-06 00:00:00
2020-07-07 00:00:00
2020-07-08 00:00:00
2020-07-09 00:00:00
2020-07-10 00:00:00
2020-07-11 00:00:00
2020-07-12 00:00:00
2020-07-13 00:00:00
2020-07-14 00:00:00
2020-07-15 00:00:00
2020-07-16 00:00:00
2020-07-17 00:00:00
2020-07-18 00:00:00
2020-07-19 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME] avg | [NAME] avg | Day Avg |  | [NAME]
2020-07-20 00:00:00
2020-07-21 00:00:00
2020-07-22 00:00:00
2020-07-23 00:00:00
2020-07-24 00:00:00
2020-07-25 00:00:00
2020-07-26 00:00:00
2020-07-27 00:00:00
2020-07-28 00:00:00
2020-07-29 00:00:00
2020-07-30 00:00:00
2020-07-31 00:00:00
2020-08-01 00:00:00
2020-08-02 00:00:00
2020-08-03 00:00:00
2020-08-04 00:00:00
2020-08-05 00:00:00
2020-08-06 00:00:00
2020-08-07 00:00:00
2020-08-08 00:00:00
2020-08-09 00:00:00
2020-08-10 00:00:00
2020-08-11 00:00:00
2020-08-12 00:00:00
2020-08-13 00:00:00
2020-08-14 00:00:00
2020-08-15 00:00:00
2020-08-16 00:00:00
2020-08-17 00:00:00
2020-08-18 00:00:00
2020-08-19 00:00:00
2020-08-20 00:00:00
Spreadsheet: 65a136ce-d876-4e6b-b300-5b56f5672300
Sheet: Sheet1

Newly Reported Cases of Past or Present Hepatitis C Virus (HCV) Infection*,  by Age, Maine 2011 and By Year 2002-2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | All |  | Male |  | Female
 |  | Number | Rate† | Number | Rate† | Number | Rate†
Maine Total |  | 1184 | 89.14400672193997 | 747 | 114.9119393043443 | 437 | 64.44239631336406
Age Group (yrs)
 | 0-4 | 1 | 1.47725761895617 | 1 | 2.880848121687024 | 0 | 0
 | 5-14 | 4 | 2.643352299386081 | 2 | 2.573936320815423 | 2 | 2.716616182882602
 | 15-24 | 150 | 90.28041095643067 | 69 | 81.11539546694253 | 81 | 99.89517173336621
 | 25-44 | 491 | 157.319859149063 | 294 | 190.9053719732732 | 197 | 124.6046805819102
 | 45-64 | 491 | 118.3982715299179 | 362 | 178.3128257164531 | 129 | 60.93874003250066
 | 65+ | 47 | 21.7373206671045 | 19 | 19.8811317595848 | 28 | 23.20762536261914
Year
 | 2002§ | 1227 | 94.78834080232498 | 845 | 133.7795819111007 | 381 | 57.35153328797394
 | 2003 | 1028 | 78.75547955804998 | 704 | 110.5692589189656 | 324 | 48.45939506521827
 | 2004 | 1223 | 93.00309503349784 | 754 | 117.2367576106713 | 469 | 69.80548233504548
 | 2005§ | 1382 | 104.7388652430669 | 911 | 141.2604588561469 | 471 | 69.89385334755943
 | 2006 | 1211 | 91.56712868621963 | 773 | 119.5804011899255 | 437 | 64.63540896317113
 | 2007 | 1453 | 110.0207472021565 | 904 | 140.6349418714093 | 549 | 80.9900554833513
 | 2008 | 1374 | 103.9439701149738 | 860 | 133.8794368968615 | 514 | 75.64418974623877
 | 2009§ | 1262 | 95.44539419250323 | 802 | 123.2049257390759 | 459 | 67.63507121575145
 | 2010§ | 1142 | 86.0045969532382 | 733 | 112.8061964920813 | 408 | 60.19652394582313
 | 2011 | 1184 | 89.14400672193997 | 747 | 114.9119393043443 | 437 | 64.44239631336406
* A hepatitis C positive report is defined as the presence of any positive serologic marker for hepatitis C infection. Markers include anti-HCV (EIA), anti-HCV (RIBA), hepatitis C antigen (RT-PCR) or reports of hepatitis C genotype. It should be noted that not all anti-HCV (EIA) reports are verified by supplemental assay. Also, neither EIA nor RIBA tests alone can distinguish between past and current infection.
† Rate = number of cases per 100,000 population using the corresponding year census estimate as the denominator.
§ 1 case unknown gender
Note: Missing variables such as race/ethnicity and county are unavailable due to lack of resources to fully investigate each report.
Spreadsheet: 782785d1654268994-goal-seek-conditional-sum-product-is-this-possible-sump_mod4
Sheet: Sheet2

 |  |  |  |  |  | Target | Achieved |  | Diff
 |  |  |  |  |  | 670
 |  |  |  |  | Fixed ratio | Can be integer only |  | Found ratio
 |  |  |  | 4 | 0.032 | 4
 |  |  |  | 8 | 0.064 | 4
 |  |  |  | 12 | 0.096 | 3
 |  |  |  | 24 | 0.096 | 5
 |  |  |  | 48 | 0.288 | 3
 |  |  |  | 108 | 0.432 | 3
 |  |  |  | Solver setup using Evolutionary engine and origanal row 11 deleted
 |  |  |  | Constraint range G7:G12 <= 10
 |  |  |  | Constraint rangeG7:G12 =>1
 |  |  |  | Constraint range G7:G12 set to Integer
 |  |  |  | No constraint set on Found ratio
 |  |  |  | This shows a better found ratio as compaired to the original but it took a nuber of runs before the set of values were found.
Spreadsheet: 36334d1234220812-simpler-way-to-record-the-outcomes-of-matches-league-table2
Sheet: Sheet1

 | Team 1 |  | Team 2 |  | Team 3 |  | Team 4 |  | Team 5 |  | Team 6 |  | Team 7 |  | Team 8 |  | Team 9 |  | Team 10 |  |  |  | Points
Team 1 |  |  | 5 | 1 | 2 | 7 | 1 | 3 | 8 | 5 | 7 | 9 | 3 | 5 | 7 | 1 | 6 | 4 | 5 | 7 |  | Team 1
Team 2 | 6 | 4 |  |  | 5 | 7 | 4 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  | Team 2
Team 3 | 6 | 4 | 5 | 1 |  |  | 4 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  | Team 3
Team 4 | 6 | 4 | 5 | 1 | 5 | 7 |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  | Team 4
Team 5 | 6 | 4 | 5 | 1 | 5 | 7 | 4 | 8 |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  | Team 5
Team 6 | 6 | 4 | 5 | 1 | 5 | 7 | 4 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  | Team 6
Team 7 | 6 | 4 | 5 | 1 | 5 | 7 | 4 | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 | 8 | 8 |  | Team 7
Team 8 | 6 | 4 | 5 | 1 | 5 | 7 | 4 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 | 8 | 8 |  | Team 8
Team 9 | 6 | 4 | 5 | 1 | 5 | 7 | 4 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  |  | 8 | 8 |  | Team 9
Team 10 | 6 | 4 | 5 | 1 | 5 | 7 | 4 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 |  |  |  | Team 10
Spreadsheet: 78673d1279023201-formula-required-to-calculate-betting-odds-returns-betting
Sheet: Sheet1

Player | Prediction | Amount |  | Game | Home Win Odds | Draw Odds | [NAME] Odds | Result
Player 1 | 2h | 500 |  | 1 | 1.5 | 8 | 16 | d
Player 1 | 4a | 200 |  | 2 | 0.2 | 2 | 10 | a
Player 2 | 1d | 100 |  | 3 | 3 | 2 | 0.1 | h
Player 2 | 3h | 200 |  | 4 | 0.5 | 1.5 | 7 | d
Spreadsheet: 867773d1714567657-generate-numbers-demo
Sheet: Sheet1

Customer Reference | Customer Name | Type | Quote Ref |  |  |  |  | INT | A
TG001 | Mr [NAME] | VSS |  |  |  |  |  | FIRE | F
pulled from list on another tab | Pulled from col a via index match |  |  |  |  |  |  | VSS | C
 |  |  |  |  |  |  |  | ACCESS | D
 |  | VSS |  |  |  |  |  | AUTO | G
Spreadsheet: 374bbd9c-77e0-433b-b0ae-2a8f9a7c44e1
Sheet: 4

 | November 29 | December 6 | December 13 | December 20 | December 27
Total Interest Rate* | 23716 | 39681 | 42724 | 47081 | 11190
SDs and MSPs** | 8866 | 15376 | 18870 | 21347 | 4699
Other | 14850 | 24305 | 23854 | 25734 | 6491
Total Cross-Currency | 446 | 1278 | 1922 | 1286 | 230
SDs and MSPs | 299 | 860 | 1363 | 834 | 129
Other | 147 | 418 | 559 | 452 | 101
Total Credit | 9458 | 16206 | 9670 | 12243 | 1880
SDs and MSPs | 5527 | 8364 | 5763 | 6956 | 871
Other | 3931 | 7842 | 3907 | 5287 | 1009
Total FX | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
SDs and MSPs | N/A | N/A | N/A | N/A | N/A
Other | N/A | N/A | N/A | N/A | N/A
TOTAL | 33620 | 57165 | 54316 | 60610 | 13300
Weekly total, swap ticket volumes by asset class and participant type (number of new trades), all products and tenors, cleared and uncleared. For cleared swaps, the creation of each of the two resulting swaps is attributed only to the counterparty facing the clearing organization (i.e., the clearing organization’s participation is not displayed). For uncleared swaps, each trade is attributed to both swap counterparties. All price-forming trade events, including new trades, terminations, amendments, and novations, are included in ticket volumes. Because this table shows transactions by participant, the totals on this table are twice those displayed on the "Transaction Ticket Volume by Cleared Status" table.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 739196d1625576237-vba-locking-cells-based-on-checkbox-radio-button-selection-locking-cells-checkbox-dropdown
Sheet: Input

 | PRODUCTS | Solar
 |  | Battery |  | Overnight Charging
 | AREA | Postcode | Irradiance Zone
 |  | RG
 | BILL | ELECTRICITY NOTE: If solar only installation, use standard rate only.
 |  | Annual Consumption (kWh) |  |  | 4000
 |  | Standard Rate (pence per kWh) |  |  | 0.17
 |  | Off-Peak Rate (pence per kWh - if applicable) |  |  | 0.1
 |  | Number of Off-Peak Hours |  |  | 4
 |  | Average Unit Rate
 |  | Export Tariff |  |  | 0.055
 | SOLAR | Number of Arrays |  |  | Array 1 | [NAME] | Array 3 | [NAME] | Array 5
 |  | Number of Modules |  |  | 5 | 10
 |  | Module Power (Wp) |  |  | 370
 |  | Total Installed Cap (kWp)
 |  | Orientation (° from south) |  |  | 50 | 70
 |  | Inclination (° from horizontal) |  |  | 30 | 35
 |  | Irradiance (kk)
 |  | Shading Factor (e.g. 0.94) |  |  | 0.96 | 1
 |  | Annual Output
 |  | Total Annual Output
 | USE | Solar Self-Consumption
 |  | Battery Self-Consumption |  |  | 0.2
 |  | Export
 | OVERNIGHT CHARGING | Battery Make and Model |  |  | Puredrive PureStorage II DC - 5kWh
 |  | Battery Size
 |  | Depth of Depletion
 |  | Round Trip Efficiency
 |  | Cannibalism (kWh per year)
 |  | Available Charge Daily
 |  | Annual Benefit (kWh)
 |  | Pre Install Consumption
 |  | Current Customer Rate
 |  | New Standard Rate (pence per kWh) |  |  | 0.15
 |  | New Off-Peak Rate (pence per kWh) |  |  | 0.09
 |  | Annual Benefit (£)
Spreadsheet: 779732d1652064446-populate-calendars-based-on-office-location-office-scheduling-draft
Sheet: WFH

Month: | May
Year: | 2022
Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2 | 3 | 4 | 5 | 6 | 7
Spreadsheet: 12df13b4-07a4-4e1a-8438-e0b48a8a3e47
Sheet: Sheet1

Unnamed: 0 | EXECUTIVE COUNCIL - DISTRICT 1 | Unnamed: 2
2002-09-10 00:00:00 | REPUBLICAN
 | Burton, r | [NAME]
Albany | 69
[NAME] | 166
Alton | 778 | 1
Ashland | 236 | 1
Atkinson & Gilmanton Academy Grant | 0
[NAME] | 473 | 1
Bath | 115
Bean's Grant | 0
Bean's Purchase | 0
Belmont | 669 | 3
[NAME] | 55
[NAME] | 212
[NAME] | 230
[NAME] 3 | 310 | 1
[NAME] 4 | 127
Bethlehem | 274
Bridgewater | 171
Bristol | 460
Cambridge | 0
Campton | 310
Canaan | 255 | 1
Carroll | 110
Center Harbor | 234
[NAME]'s Purchase | 0
Charlestown | 296
Chatham | 38
Claremont Ward 1 | 165 | 3
Claremont Ward 2 | 444 | 1
Claremont Ward 3 | 303
[NAME] | 38
Colebrook | 306
Columbia | 73
Conway | 1005 | 8
Cornish | 173 | 1
Crawford's Purchase | 0
Croydon | 89
Cutt's Grant | 0
[NAME] | 114
Dix's Grant | 0
Dixville | 19
Dorchester | 38
Dummer | 51 | 1
Easton | 45
Eaton | 61 | 2
[NAME] | 156
Ellsworth | 9
Enfield | 356
Errol | 49
Erving's Location | 0
Franconia | 168 | 3
Freedom | 287
Gilford | 1211 | 4
[NAME] | 275
[NAME] | 130 | 5
Grantham | 395 | 1
Green's Grant | 0
Hadley's Purchase | 0
[NAME] | 71
Hale's Location | 46
Hanover | 582
Hart's Location | 12
Haverhill | 603
Hebron | 146
Holderness | 323 | 1
[NAME] | 240
[NAME] | 171
Kilkenny | 0
[NAME] | 523
[NAME] | 304 | 2
[NAME] 3 | 337
[NAME] | 279 | 1
[NAME] | 198 | 2
[NAME] 6 | 329 | 1
Lancaster | 450 | 3
Landaff | 58
Lebanon Ward 1 | 333
Lebanon Ward 2 | 260
Lebanon Ward 3 | 307
Lincoln | 206 | 2
Lisbon | 177
Littleton | 886 | 2
Livermore | 0
Low & Burbank's Grant | 0
[NAME] | 68
Lyme | 173
[NAME] | 332
Martin's Location | 0
Meredith | 1002 | 1
Milan | 184
[NAME] | 8
Monroe | 155
Moultonborough | 1033 | 2
New Hampton | 270
Newport | 500
Northumberland | 147
[NAME] | 0
Orange | 31
Orford | 122 | 1
Ossipee | 598
Piermont | 103 | 2
[NAME]'s Grant | 0
Pittsburg | 133
Plainfield | 210 | 1
Plymouth | 512 | 3
Randolph | 68
Rumney | 262 | 5
Sanbornton | 379 | 5
Sandwich | 236
Sargent's Purchase | 0
Second College Grant | 0
Shelburne | 63
Springfield | 135
[NAME] | 58
Stewartstown | 84
[NAME] | 37
Success | 0
[NAME] | 96
Sunapee | 587 | 2
Tamworth | 390
Thompson & Meserve's Purchase | 0
[NAME] | 249 | 4
[NAME] | 339 | 3
Tuftonboro | 556
Wakefield | 566
[NAME] | 169 | 2
Waterville Valley | 41 | 1
Wentworth | 108
Wentworth's Location | 2
[NAME] | 257 | 1
Wolfeboro | 1344
Woodstock | 138
Totals | 30134 | 84
Spreadsheet: 825401d1681302643-formula-to-find-specific-data-using-multiple-drop-down-lists-book1-ans2
Sheet: Sheet3

Date | Opportunity Owner | Forecast Category | . | Qty | Qtr | Q1 | Q2 | Q3 | Q4 | Account | FY | All |  | Concatenate1 | Concatenate2 | Concatenate3 | Concatenate4
2023-03-01 00:00:00 | [NAME] | Won |  | 1 | Q3 | 0 | 0 | 9751171.58 | 0 | b | FY23 | All
2023-03-01 00:00:00 | [NAME] | Won |  | 1 | Q3 | 0 | 0 | 1480790.42 | 0 | b | FY23 | All
2023-03-01 00:00:00 | [NAME] | In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 71947.21 | a | FY23 | All
2023-03-01 00:00:00 | [NAME] | In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 259800.99 | a | FY23 | All
2023-03-01 00:00:00 | [NAME] | Not In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 1.3 | b | FY23 | All
2023-03-01 00:00:00 | [NAME] | Not In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 259800.99 | a | FY23 | All
2023-03-01 00:00:00 | [NAME] | Not In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 324751.24 | a | FY23 | All
2023-03-01 00:00:00 | [NAME] | In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 584552.23 | c | FY23 | All
2023-03-01 00:00:00 | [NAME] | Not In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 306565.17 | a | FY23 | All
2023-03-01 00:00:00 | [NAME] | Not In Forecast |  | 1 | Q1 | 64950.25 | 0 | 0 | 0 | b | FY24 | All
2023-03-01 00:00:00 | [NAME] | In Forecast |  | 1 | Q2 | 0 | 109852.86 | 0 | 0 | b | FY24 | All
2023-03-01 00:00:00 | [NAME] | In Forecast |  | 1 | Q2 | 0 | 658359.3 | 0 | 0 | c | FY24 | All
2023-03-02 00:00:00 | [NAME] | Won |  | 1 | Q3 | 0 | 0 | 9751171.58 | 0 | b | FY23 | All
2023-03-02 00:00:00 | [NAME] | In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 324751.24 | b | FY23 | All
2023-03-02 00:00:00 | [NAME] | In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 259800.99 | b | FY23 | All
2023-03-02 00:00:00 | [NAME] | Not In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 1.3 | b | FY23 | All
2023-03-02 00:00:00 | [NAME] | In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 584552.23 | c | FY23 | All
2023-03-02 00:00:00 | [NAME] | Not In Forecast |  | 1 | Q4 | 0 | 0 | 0 | 1.3 | a | FY23 | All
2023-03-02 00:00:00 | [NAME] | Not In Forecast |  | 1 | Q1 | 64950.25 | 0 | 0 | 0 | b | FY24 | All
2023-03-02 00:00:00 | [NAME] | Not In Forecast |  | 1 | Q1 | 220830.84 | 0 | 0 | 0 | b | FY24 | All
2023-03-02 00:00:00 | [NAME] | In Forecast |  | 1 | Q2 | 0 | 109852.86 | 0 | 0 | a | FY24 | All
2023-03-02 00:00:00 | [NAME] | In Forecast |  | 1 | Q2 | 0 | 13281.48 | 0 | 0 | b | FY24 | All
2023-03-02 00:00:00 | [NAME] | In Forecast |  | 1 | Q2 | 0 | 251519.4 | 0 | 0 | b | FY24 | All
Spreadsheet: 215569d1361411659-locked-some-cell-and-make-if-function-book1
Sheet: Sheet1

! | Sample Delivery | Rit | Material Description | #MO/Lot | Analysis - Longest | Days of Analysis | Release
 | 2013-02-21 00:00:00 | 1 | A | 681 | CB
 | 2013-02-22 00:00:00 | 2 | A | 681 | CB
 | 2013-02-23 00:00:00 | 1 | A | 681 | CB
! | 2013-02-24 00:00:00 | 1 | B | 682 | EB
 | 2013-02-25 00:00:00 | 2 | B | 682 | EB
 | 2013-02-26 00:00:00 | 1 | B | 683 | EB
! | Sample Delivery | Rit | Material Description | LOT | Analysis - Longest | Days of Analysis | Release |  | If the number of LOT is same, the release will be follow the newest date. But if there is any symbol "!", the release will be back to normal rule.
 | 2013-02-21 00:00:00 | 1 | A | 681 | CB |  | 2013-02-26 00:00:00
 | 2013-02-22 00:00:00 | 2 | A | 681 | CB |  | 2013-02-26 00:00:00 |  | The normal rule of release :
 | 2013-02-23 00:00:00 | 1 | A | 681 | CB |  | 2013-02-26 00:00:00 |  | If release falls in weekend, it will release on Monday
! | 2013-02-24 00:00:00 | 1 | B | 682 | EB |  | 2013-02-26 00:00:00
 | 2013-02-25 00:00:00 | 2 | B | 682 | EB |  | 2013-02-28 00:00:00
 | 2013-02-26 00:00:00 | 1 | B | 683 | EB |  | 2013-02-28 00:00:00
Material
A | ABC |  | I want to make the blocked cell is locked , so when I filter the material to B , the blocked cell will not lose apart.
A | DEF
A | GHI
A | JKL
A | MNO
B | PQR
B | STU
B | VWX
B | YZ
C
C
C
A
A
C
C
C
B
B
B
Spreadsheet: 722974d1615468402-trying-and-failing-to-calculate-average-time-in-hours-by-name-by-priority-sampla-etaf
Sheet: Sheet1

Date and Time Raised | Date and Time Attended | Date and Time Completed | Time to Attend | Time to [NAME] | Client Support | Priority Status |  | Time to Attend (Average Hours)
2021-02-09 15:54:00 | 2021-03-02 14:36:39 | 2021-03-02 14:36:39 |  |  | [NAME] | P2 |  |  | [NAME] | [NAME] | [NAME]
2021-02-09 11:56:00 | 2021-02-12 11:31:39 | 2021-02-12 11:31:39 |  |  | [NAME] | P1 |  | P1 | 251 | 214 | 85
2021-02-11 09:39:00 | 2021-03-02 14:37:52 | 2021-03-02 14:37:52 |  |  | [NAME] | Quote |  | P2 |  |  | 2
2021-02-11 09:01:00 | 2021-02-12 10:27:00 | 2021-02-12 10:27:50 |  |  | [NAME] | P4 |  | P3 |  | 151
2021-02-18 12:28:00 | 2021-02-18 14:38:52 | 2021-02-19 07:35:04 |  |  | [NAME] | P2 |  | P4 | 109
2021-02-14 08:19:00 | 2021-02-26 16:34:27 | 2021-02-26 16:34:27 |  |  | [NAME] | P3 |  | Quote | 5 | 460 | 2
2021-02-15 08:13:00 | 2021-02-15 13:58:07 | 2021-02-15 13:58:07 |  |  | [NAME] | Quote
2021-02-19 10:42:00 | 2021-02-23 13:58:09 | 2021-02-23 13:58:09 |  |  | [NAME] | P1 |  | Time to Complete (Average Hours)
2021-02-18 08:48:00 | 2021-02-18 14:55:29 | 2021-02-18 14:55:29 |  |  | [NAME] | P3 |  |  | [NAME] | [NAME] | [NAME]
2021-02-18 09:13:00 | 2021-02-26 09:47:41 | 2021-02-26 09:47:41 |  |  | [NAME] | P4 |  | P1
2021-02-15 09:31:00 | 2021-02-15 12:18:00 | 2021-02-15 12:31:21 |  |  | [NAME] | Quote |  | P2
2021-02-17 16:07:00 | 2021-02-26 14:22:06 | 2021-02-26 14:22:17 |  |  | [NAME] | P1 |  | P3
2021-03-03 08:28:00 | 2021-03-05 10:06:24 | 2021-03-05 10:06:24 |  |  | [NAME] | P3 |  | P4
2021-03-01 08:12:00 | 2021-03-01 08:14:00 | 2021-03-01 08:15:00 |  |  | [NAME] | Quote |  | Quote
2021-03-01 08:17:00 | 2021-03-01 08:19:00 | 2021-03-01 08:20:00 |  |  | [NAME] | P2
 |  |  |  |  |  |  |  |  |  | 2 | 251
 |  |  |  |  |  |  |  |  |  | 4 | 109
 |  |  |  |  |  |  |  |  |  | q | 5
 |  |  |  |  |  |  |  |  |  | 1 214
 |  |  |  |  |  |  |  |  |  | 3 | 151
 |  |  |  |  |  |  |  |  |  | q | 460
 |  |  |  |  |  |  |  |  | 1 85
 |  |  |  |  |  |  |  |  | 2 2
 |  |  |  |  |  |  |  |  | Q2