tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 683810d1592958552-conditional-remove-duplicates-based-on-another-column-in-power-query-related-to-power-bi-example-of-cleaned-data
Sheet: Sheet1

ID | JobPositionCode | AwardCode | AwardLevelCode | JobPositionCategoryCode | JobPositionActiveFlag | Surname | Preferred | FTE | CurrentJobPositionFlag | FutureJobPositionFlag | JobStartDate
5000 | PRINCIPAL | TEACHING | LEADERSHIP | TEACHER | True | Wilson | Rebel | 1 | True | False | 2018-11-28 00:00:00
6111 | TEACHER | TEACHING | COACH | TEACHER | True | Blanchett | Cate | 0.63 | True | False | 2016-03-31 00:00:00
6111 | ES | LEARNING DIVERSITY |  | LEARNING ENHANCEMENT | True | Blanchett | Cate | 0.17 | True | False | 2016-03-31 00:00:00
25000 | TEACHER | TEACHING | HEAD OF HOUSE | TEACHER | True | Jackman | Hugh | 1 | True | False | 2020-01-13 00:00:00
6000 | ES | FINANCE |  | PAYROLL OFFICER | True | Weaver | [NAME] | 1 | True | False | 2010-01-01 00:00:00
6000 | ES | FINANCE | LSL | PAYROLL OFFICER | True | Weaver | [NAME] | 0 | True | False | 2010-01-01 00:00:00
What the Table should look Like
ID | JobPositionCode | AwardCode | AwardLevelCode | JobPositionCategoryCode | JobPositionActiveFlag | Surname | Preferred | FTE | CurrentJobPositionFlag | FutureJobPositionFlag | JobStartDate
5000 | PRINCIPAL | TEACHING | LEADERSHIP | TEACHER | True | Wilson | Rebel | 1 | True | False | 2018-11-28 00:00:00
6111 | TEACHER | TEACHING | COACH | TEACHER | True | Blanchett | Cate | 0.8 | True | False | 2016-03-31 00:00:00
25000 | TEACHER | TEACHING | HEAD OF HOUSE | TEACHER | True | Jackman | Hugh | 1 | True | False | 2020-01-13 00:00:00
6000 | ES | FINANCE |  | PAYROLL OFFICER | True | Weaver | [NAME] | 1 | True | False | 2010-01-01 00:00:00
Spreadsheet: 48cb9b0d-4788-4231-8e05-9dda3753b8cf
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 50. PERSONAL FINANCE COMMITMENTS, Summary: Australia ($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
Fixed loans ; |  |  | Original | A2414192W | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Original | A2414193X | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414194A | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Seasonally Adjusted | A2414189J | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Seasonally Adjusted | A2414190T | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Seasonally Adjusted | A2414191V | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Trend | A2414186A | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Trend | A2414187C | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Trend | A2414188F | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 179191d1347052478-converting-tally-marks-to-numerical-value-and-totaling-the-results-2012-bills-sticker-sheet
Sheet: vs Chino Mustangs

Players Name | Super Star | Bills Logo | Football | Offense | Defense
Acosta, Armando |  |  |  |  | I
Anaya, David "Hootie"
Barlund, Tristan |  |  | II |  | III
Camerena, [NAME]
Casteneda, Julian
[NAME], [NAME] |  |  | II |  | II
[NAME], [NAME] |  |  |  |  | I
[NAME], [NAME] |  |  | II
[NAME], Elijah
[NAME], Moses |  |  | II
Hernandez, Roman
Holguin, Andres "TNT" |  |  | II |  | I
Holguin, Dominic |  |  |  |  | I
Kohls, [NAME] |  |  | I
Lambey, [NAME] |  |  |  |  | I
Lezama, Dominic |  |  | II
Manley, [NAME] |  |  |  |  | I
[NAME], [NAME] |  |  | II
Rebodello, Gio
[NAME], Gavin |  |  |  |  | I
Romero, Clarence "PJ" |  |  | II | I
Saucedo, George
Southern, Grant |  |  |  |  | I
Villalobos, [NAME]
Walsh, Riley |  |  |  |  | I
Whiteface, Magnuss |  |  | I
[NAME], [NAME] |  |  | II | I
Young, [NAME] |  |  | II | II
Spreadsheet: darrell_schoolcraft__7801__imbalsumm0108
Sheet: SoCal

 | 10487 |  | 56697
Day | Measured | Scheduled | Measured | Scheduled
1 | -783122 | -801047 | -40000 | -40000
2 | -765413 | -746994 | -39998 | -40000
3 | -751586 | -748805 | -39999 | -40000
4 | -739284 | -742991 | -101
5 | -714787 | -734668
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
2001-07-31 00:00:00 |  |  |  |  | 145309
2001-08-05 00:00:00
CBS Dollars
 |  |  | 448987
Spreadsheet: 866182d1713162120-average-total-cost-on-a-tiered-pricing-table-cost-ans
Sheet: Sheet1

Quantity | 13000
Tier | Quantity Range |  | Cost per Unit |  | Total Cost
Tier 1 | 1 | 5999 | 10.5 |  |  |  |  | G.total
[NAME] | 6000 | 7999 | 10 |  |  |  |  | Average
Tier 3 | 8000 | 9999 | 9.5
[NAME] | 10000 | 12499 | 9
Tier 5 | 12500 | 14999 | 8.5
Tier 6 | 15000 | 19999 | 8
Tier 7 | 20000 |  | 7.5
 |  |  |  | G. total
 |  |  |  | Average cost
Spreadsheet: 751107d1633885836-finding-numbers-in-text-string-finding-numbers-in-text-string
Sheet: Sheet1

This line has been disconnected due to terminations after the customer accepted a new offer , STS 1662508
This line has been disconnected due to terminations after the customer accepted a new offer , STS 1661987
This line has been disconnected due to terminations after the customer accepted a new offer , STS  1660174
This line has been disconnected due to terminations after the customer accepted a new offer , STS 1662621
This line has been disconnected due to terminations after the customer accepted a new offer , STS 1663104
This line has been disconnected due to terminations after the customer accepted a new offer 1661986
This line has been disconnected due to terminations after the customer accepted a new offer 1661986
This line has been disconnected due to terminations after the customer accepted a new offer 1662022
This line has been disconnected due to issues with bill. The complaint’s number is 1808975  Contact ID: 528874
This line has been disconnected due to terminations after the customer accepted a new offer  Contact ID: 528873
This line has been disconnected due to terminations after the customer accepted a new offer  Contact ID: 528840
This line has been disconnected due to terminations after the customer accepted a new offer  Contact ID: 528847
This line has been disconnected due to terminations after the customer accepted a new offer  Contact ID: 528850
This line has been disconnected due to terminations after the customer accepted a new offer  Contact ID: 528848
Spreadsheet: 162538d1339953465-sum-of-multiple-match-formula-requirement-suhabthan-oeldere-
Sheet: Sheet1

Type | Code | Amount
A | Z001 | 100 |  | Requirement: Sum of Column "C" where Column "B" equals a particular code and Column "A" cells contain values in any one of the cells in Range "K4:K6".
B | Z001 | 125 |  |  |  |  |  |  |  |  | 365
C | Z001 | 110
D | Z001 | 135 |  |  |  |  |  |  | Match
E | Z001 | 150 |  | e.g. | Result |  |  |  | B
F | Z001 | 105 |  | Z001 | 365 |  |  |  | D
G | Z001 | 100 |  |  |  |  |  |  | F
A | Z002 | 102
B | Z002 | 109 |  | - How to get this result via a single formula ??? Important point is: "Sumproduct" & "Sumifs" formulas should not be used as this will consume lot of time in large databases.
C | Z002 | 111
D | Z002 | 145
E | Z002 | 137
F | Z002 | 100
G | Z002 | 125
A | Z003 | 110 |  |  | Som [NAME] | Kolomlabels
B | Z003 | 135 |  |  | Rijlabels | B | D | F | Eindtotaal
C | Z003 | 150 |  |  | Z001 | 125 | 135 | 105 | 365
D | Z003 | 105 |  |  | Z002 | 109 | 145 | 100 | 354
E | Z003 | 100 |  |  | Z003 | 135 | 105 | 102 | 342
F | Z003 | 102 |  |  | Z004 | 145 | 100 | 110 | 355
G | Z003 | 109 |  |  | Z005 | 105 | 102 | 111 | 318
A | Z004 | 111 |  |  | Eindtotaal | 619 | 587 | 528 | 1734
B | Z004 | 145
C | Z004 | 137
D | Z004 | 100
E | Z004 | 125
F | Z004 | 110
G | Z004 | 135
A | Z005 | 150
B | Z005 | 105
C | Z005 | 100
D | Z005 | 102
E | Z005 | 109
F | Z005 | 111
G | Z005 | 145
Spreadsheet: 813128d1673566762-iferror-vlookup-help-when-lookup-is-not-found-or-column-sorted-different-vehicle-sheet-for-excelforum
Sheet: September2022

Biosecurity Operations Branch Vehicle Fleet August 2022
[NAME] | Make | Lease | Location | Region | Cost Code | Responsible Area / Driver | Service Interval Mnths/Kms | Expected KM | vlookup lease | Current Kilometres | Current KM Decimal | Expected KM + 5000 | Expected KM - 5000 | Utilisation + or - 5 | Utilisation | Under / Over Agreement | Comments
G00DA | Toyota Rav4 | 36 mnths/60,000K | [NAME] | NW | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
G04CL | [NAME] Dual Cab 4x4 Ute | 36 mnths/60,000K | Mt Pleasant | N | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000
G06CW | Toyota Corolla Hatchback | 36 mnths/60,000K | [NAME] | NW | BG2401302442 | Biosecurity Operations - Pool | 12 / 15,000
G25CO | Toyota Camry | 36 mnths/60,000K | Mt Pleasant | N | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
G28CR | Toyota Camry | 36 mnths/60,000K | New Town | S | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000
[NAME] | Test Camry | 36 mnths/60,000K | New Town | S | BB8200402442 | Biosecurity Operations - Pool | 12 / 15,000
G29CO | Toyota Rav4 | 36 mnths/60,000K | Mt Pleasant | N | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000
G35CV | [NAME] Dual Cab 4x4 Ute | 36 mnths/60,000K | New Town | S | BB8100112442 | Biosecurity Operations - Pool | 12 / 15,000 |  |  |  |  |  |  |  |  |  | REPLACED G06CS JULY ATTENTION
Spreadsheet: 703691d1605115013-extract-data-from-a-table-and-plot-graph-excel-help-2
Sheet: Sheet1

Test Readings
Category | Date | Time | Type | Reading | Notes
Fasting | 2020-11-08 00:00:00 | 06:45:00 | FBS | 139 |  |  | 220
PP1 | 2020-11-08 00:00:00 | 11:45:00 | PPBS | 239 |  |  | 200 |  |  |  |  | PP3
PP2 | 2020-11-08 00:00:00 | 15:30:00 | PPBS | 103 |  |  | 180 |  |  |  |  | PP2
PP3 | 2020-11-08 00:00:00 | 22:15:00 | PPBS | 231 |  |  | 160 |  |  |  |  | PP1
Fasting | 2020-11-09 00:00:00 | 05:30:00 | FBS | 129 |  |  | 140 |  |  |  |  | Fasting
PP1 | 2020-11-09 00:00:00 | 10:45:00 | PPBS | 203 |  |  | 120
PP2 | 2020-11-09 00:00:00 | 15:45:00 | PPBS | 146 |  |  | 100
PP3 | 2020-11-09 00:00:00 | 22:30:00 | PPBS | 224
Fasting | 2020-11-10 00:00:00 | 05:30:00 | FBS | 133
PP1 | 2020-11-10 00:00:00 | 11:10:00 | PPBS | 157 |  |  |  | 2020-11-08 00:00:00 | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | 2020-11-11 00:00:00
PP2 | 2020-11-10 00:00:00 | 15:30:00 | PPBS | 178
PP3 | 2020-11-10 00:00:00 | 22:20:00 | PPBS | 193 |  |  | The above is only represntative and is NOT calibrated as per data.
Fasting | 2020-11-11 00:00:00 | 06:45:00 | FBS | 164 |  |  | I need a graph that shows Fasting, PP1, PP2 and PP3 as separate lines as shown above.
PP1 | 2020-11-11 00:00:00 | 11:30:00 | PPBS | 174
PP2 | 2020-11-11 00:00:00 | 15:45:00 | PPBS | 167
PP3 | 2020-11-10 00:00:00 | 22:20:00 | PPBS | 185
Spreadsheet: 144490d1330993445-excel-2007-how-to-move-multiple-rows-to-columns-excel-test
Sheet: Sheet1

[NAME] |  | Hot Sta |  | Last Name |  |  |  |  |  |  | First Name |  | Department
123456 |  | 1234567 |  | Doe |  |  |  |  |  |  | [NAME] |  | Staff
Access Group 1 |  |  |  | Access Group 2 |  |  |  | Access Group 3
Generic |  |  |  | Level 1 |  |  |  | NO ACCESS
Position |  |  | Expiration Date
Employee |  |  | 2013-07-01 00:00:00
[NAME] |  | Hot Sta |  | Last Name |  |  |  |  |  |  | First Name |  | Department
987654 |  | 9876543 |  | Smith |  |  |  |  |  |  | Jon |  | Staff
Access Group 1 |  |  |  | Access Group 2 |  |  |  | Access Group 3
Level 2 |  |  |  | Level 3 |  |  |  | NO ACCESS
Position |  |  | Expiration Date
Contractor |  |  | 2013-07-01 00:00:00
[NAME] |  | Hot Sta |  | Last Name |  |  |  |  |  |  | First Name |  | Department
654321 |  | 6543210 |  | Doe |  |  |  |  |  |  | [NAME] |  | Staff
Access Group 1 |  |  |  | Access Group 2 |  |  |  | Access Group 3
Level 1 |  |  |  | NO ACCESS |  |  |  | NO ACCESS
Position |  |  | Expiration Date
Employee |  |  | 2012-06-29 00:00:00
Spreadsheet: 599645d1543235314-looking-for-dashboard-dashboard-dashboard_cd-ans
Sheet: Dashboard

Employee in WD | Name | Exists in WD? | Exists in AD? | Status
Spreadsheet: 60731d1261259847-work-schedule-timesheet-copy-of-schedule-timesheet2
Sheet: Fred

[NAME]: Fred |  |  |  |  |  | Fred
PHONE:
EMPLOYEE#
POSITION: |  |  |  | Floor, Dishes | Cook, Mid/Drive | Start | End | Totals
 | Sun | 05:00-12:35 |  |  |  | 05:00 | 12:35 | 7.583333333333333
 | Mon | 01:51-04:30 |  |  |  | 01:51 | 04:30 | 2.65
 | Tue | No Work |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
 | Wed | No Work |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
 | Thu | 17:00-22:00 |  |  |  | 17:00 | 22:00 | 4.999999999999998
 | Fri | No Work |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
 | Sat | No Work |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 0
Est: | 15.23333333333333 | Hours: |  |  |  |  |  | 15.23333333333333
Date: 12/20-12/26
Uniform:
Meals:
Other:
Spreadsheet: 705188d1605909587-sum-consecutive-dates-consecutive-occurrences
Sheet: Sheet1

User | Date | Quantity | Total Option 1
[NAME] | 2020-02-01 00:00:00 | 1 | 1
[NAME] | 2020-02-02 00:00:00 | 0.5 | 1.5
[NAME] | 2020-02-08 00:00:00 | 1 | 1
[NAME] | 2020-02-09 00:00:00 | 1 | 2
[NAME] | 2020-02-10 00:00:00 | 1 | 3
[NAME] | 2020-02-11 00:00:00 | 1 | 4
[NAME] | 2020-02-12 00:00:00 | 1 | 5
[NAME] | 2020-02-13 00:00:00 | 1 | 6
[NAME] | 2020-02-14 00:00:00 | 1 | 7
[NAME] | 2020-02-15 00:00:00 | 1 | 8
[NAME] | 2020-02-16 00:00:00 | 1 | 9
[NAME] | 2020-02-17 00:00:00 | 1 | 10
[NAME] | 2020-02-18 00:00:00 | 1 | 1
[NAME] | 2020-04-01 00:00:00 | 0.5 | 0.5
[NAME] | 2020-04-02 00:00:00 | 1 | 1.5
[NAME] | 2020-04-03 00:00:00 | 1 | 2.5
[NAME] | 2020-04-17 00:00:00 | 0.5 | 0.5
[NAME] | 2020-04-18 00:00:00 | 0.5 | 1
[NAME] | 2020-04-18 00:00:00 | 1 | 1
Spreadsheet: 137859d1327412923-excel-2007-last-date-of-month-excel-activity
Sheet: Sheet1

 | Date |  | Populate via formulae |  |  | Check
 | 2010-06-30 00:00:00 | 2010-06 | 2010-06 | 2010-06 | 2010-06 | 1
 | 2010-06-07 00:00:00 | 2010-06 | 2010-06 | 2010-06 | 2010-06 | 1
 | 2011-06-15 00:00:00 | 2011-06 | 2011-06 | 2011-06 | 2011-06 | 1
 | 2010-06-17 00:00:00 | 2010-06 | 2010-06 | 2010-06 | 2010-06 | 1
 | 2010-03-23 00:00:00 | 2010-03 | 2010-03 | 2010-03 | 2010-03 | 1
 | 2010-02-04 00:00:00 | 2010-02 | 2010-02 | 2010-02 | 2010-02 | 1
 | 2011-01-27 00:00:00 | 2011-01 | 2011-01 | 2011-01 | 2011-01 | 1
 | 2010-02-08 00:00:00 | 2010-02 | 2010-02 | 2010-02 | 2010-02 | 1
 | 2010-10-11 00:00:00 | 2010-10 | 2010-10 | 2010-10 | 2010-10 | 1
 | 2009-11-02 00:00:00 | 2009-11 | 2009-11 | 2009-11 | 2009-11 | 1
 | 2010-12-24 00:00:00 | 2010-12 | 2010-12 | 2010-12 | 2010-12 | 1
 | 2010-02-25 00:00:00 | 2010-02 | 2010-02 | 2010-02 | 2010-02 | 1
 | 2010-02-03 00:00:00 | 2010-02 | 2010-02 | 2010-02 | 2010-02 | 1
 | 2012-01-10 00:00:00 | 2012-01 | 2012-01 | 2012-01 | 2012-01 | 1
Spreadsheet: 115651d1311192123-need-help-with-populating-a-field-with-values-from-a-different-sheet-learning-excel
Sheet: My Final Table

 | Sum of January | Sum of February | Sum of March | Count of April | Count of May | Count of June | Sum of Total
[NAME]
Accounting | 1 | 2 | 1 | 1 | 1 | 1 | 44
Data entry | 3 | 2 | 2 | 1 | 1 | 1 | 48
General [NAME] | 34 | 2 | 2 | 1 | 1 | 1 | 79
Jupiter Project | 37 | 5 | 38 | 2 | 1 | 2 | 164
Lunch breaks | 23 | 58 | 54 | 2 | 2 | 2 | 269
SAS update | 3 | 5 | 12 | 2 | 2 | 2 | 72
[NAME] | 101 | 74 | 109 | 9 | 8 | 9 | 676
[NAME]
Accounting | 5 | 9 | 80 | 2 | 2 | 2 | 199
Data entry | 8 | 11 | 7 | 2 | 2 | 2 | 49
General [NAME] | 7 | 48 | 10 | 1 | 2 | 2 | 84
Jupiter Project | 22 | 7 | 80 | 2 | 2 | 2 | 173
Lunch breaks | 19 | 9 | 7 | 2 | 2 | 2 | 172
SAS update | 2 | 2 | 3 | 1 | 1 | 1 | 18
Cindy Total | 63 | 86 | 187 | 10 | 11 | 11 | 695
[NAME]
Accounting | 1 | 2 | 32 | 1 | 1 | 1 | 48
Data entry | 2 | 3 | 1 | 1 | 1 | 1 | 18
General [NAME] | 3 | 54 | 3 | 1 | 1 | 1 | 99
Jupiter Project | 4 | 4 | 5 | 1 |  | 1 | 19
SAS update | 11 | 5 | 5 | 2 | 2 | 1 | 117
Darren Total | 21 | 68 | 46 | 6 | 5 | 5 | 301
[NAME]
Accounting | 7 | 4 | 5 | 1 | 1 | 1 | 69
Data entry | 2 | 5 | 2 | 1 | 1 | 1 | 22
General [NAME] | 3 | 7 | 3 | 1 | 1 | 1 | 24
SAS update | 4 | 4 | 6 | 1 | 1 | 1 | 25
[NAME] | 16 | 20 | 16 | 4 | 4 | 4 | 140
Grand Total | 201 | 248 | 358 | 29 | 28 | 29 | 1812
Spreadsheet: 706001d1606404333-subtract-if-text-match-andsalex-example
Sheet: Sheet1

 | MAY
ROOM TYPE | 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
PANORAMIC DOUBLE SEA VIEW | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 13 | PANORAMIC DOUBLE SEA VIEW
HONEYMOON SUITE SEA VIEW PRIVATE POOL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 4 | SUPERIOR SEA VIEW
PREMIUM MAISONNETTE SEA VIEW/3 BEDROOMS & PRIVATE POOL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 3 | COCOON ROOM SEA VIEW WITH POOL
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 5 | DELUXE SEA VIEW SHARING POOL
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 15 | DELUXE SEA VIEW CHILL OUT POOL
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 8 | JUNIOR SUITE SEA VIEW
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2 | HONEYMOON SUITE SEA VIEW PRIVATE POOL
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 3 | PRESTIGE SUITE SEA VIEW
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 6 | PRESTIGE SUITE SEA VIEW PRIVATE POOL
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 | PREMIUM MAISONNETTE SEA VIEW/2 BEDROOMS & PRIVATE POOL
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 1 | PREMIUM MAISONNETTE SEA VIEW/3 BEDROOMS & PRIVATE POOL
TOTAL | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
AVAILABLE ROOMS
PANORAMIC DOUBLE SEA VIEW
HONEYMOON SUITE SEA VIEW PRIVATE POOL
PREMIUM MAISONNETTE SEA VIEW/3 BEDROOMS & PRIVATE POOL
Spreadsheet: 162475d1339917024-sumif-by-date-and-one-additional-criteria-example_sumif
Sheet: Sheet1

Date Submitted | Proposal Value | Status
2333-12-23 00:00:00 | 3 | Upcoming
5655-01-25 00:00:00 | 4 | In Progress
2333-12-31 00:00:00 | 5 | Proposed
2333-03-12 00:00:00 | 1 | Won |  | Input Month | 3 | (as in March)
5655-01-25 00:00:00 | 2 | Lost |  | Monthly Summary | TOTAL
2333-12-15 00:00:00 | 6 | On Hold |  | Won |  |  | The sum of B values where C = "Won" and the month of "Date Submitted" = F6
5655-01-20 00:00:00 | 1 | Won |  | Lost
5655-05-01 00:00:00 | 3 | Upcoming |  | Total Pending |  |  | total pending not found in column C
5655-01-01 00:00:00 | 1 | Won |  | Upcoming
5655-01-30 00:00:00 | 1 | Won
2333-08-12 00:00:00 | 2 | Lost
2012-03-12 00:00:00 | 2 | Lost
2012-01-12 00:00:00 | 5 | Proposed
2012-03-02 00:00:00 | 1 | Won
2012-03-22 00:00:00 | 5 | Proposed
Spreadsheet: 852270d1702358880-percentage-and-vlookup-percentage-value_vlookup
Sheet: Sheet1

Rate
0.9 | 0.5 |  |  |  |  |  | target | 90
0.91 | 0.55 |  |  |  |  |  | actual | 100
0.92 | 0.6 |  |  |  |  |  | %achieve |  |  | if calucualte % achieve and to match in table and show rate in column B how to user function to return value same in table [NAME]?
0.93 | 0.65
0.94 | 0.7
0.95 | 0.75
0.96 | 0.8
0.97 | 0.85
0.98 | 0.9
0.99 | 0.95
1 | 1
1.01 | 1.02
1.02 | 1.04
1.03 | 1.06
1.04 | 1.08
1.05 | 1.1
1.06 | 1.12
1.07 | 1.14
1.08 | 1.16
1.09 | 1.18
1.1 | 1.2
1.11 | 1.22
1.12 | 1.24
1.13 | 1.26
1.14 | 1.28
1.15 | 1.3
1.16 | 1.32
1.17 | 1.34
1.18 | 1.36
1.19 | 1.38
1.2 | 1.4
1.21 | 1.42
1.22 | 1.44
1.23 | 1.46
1.24 | 1.48
1.25 | 1.5
1.26 | 1.52
1.27 | 1.54
1.28 | 1.56
1.29 | 1.58
1.3 | 1.6
1.31 | 1.62
1.32 | 1.64
1.33 | 1.66
1.34 | 1.68
1.35 | 1.7
1.36 | 1.72
1.37 | 1.74
1.38 | 1.76
1.39 | 1.78
1.4 | 1.8
1.41 | 1.82
1.42 | 1.84
1.43 | 1.86
1.44 | 1.88
1.45 | 1.9
1.46 | 1.92
1.47 | 1.94
1.48 | 1.96
1.49 | 1.98
1.5 | 2
1.51 | 2.02
1.52 | 2.04
1.53 | 2.06
1.54 | 2.08
1.55 | 2.1
1.56 | 2.12
1.57 | 2.14
1.58 | 2.16
1.59 | 2.18
1.6 | 2.2
1.61 | 2.22
1.62 | 2.24
1.63 | 2.26
1.64 | 2.28
1.65 | 2.3
1.66 | 2.32
1.67 | 2.34
1.68 | 2.36
1.69 | 2.38
1.7 | 2.4
1.71 | 2.42
1.72 | 2.44
1.73 | 2.46
1.74 | 2.48
1.75 | 2.5
1.76 | 2.52
1.77 | 2.54
1.78 | 2.56
1.79 | 2.58
1.8 | 2.6
1.81 | 2.62
1.82 | 2.64
1.83 | 2.66
1.84 | 2.68
1.85 | 2.7
1.86 | 2.72
1.87 | 2.74
1.88 | 2.76
1.89 | 2.78
1.9 | 2.8
1.91 | 2.82
1.92 | 2.84
1.93 | 2.86
1.94 | 2.88
1.95 | 2.9
1.96 | 2.92
1.97 | 2.94
1.98 | 2.96
1.99 | 2.98
2 | 3
Spreadsheet: 493665d1481819614-conditional-formatting-with-a-index-match-array-formula-copy_v1
Sheet: OnOrder

Model# | Tier | Serial# | Location | DynamicPool | UsableCapacity(TB) | UsedCapacity(TB) | AvailableCapacity(TB) | CurrenState
HDS | T1 |  | SITE1 |  | 50 | 5 | 10
HDS | T2 |  | SITE1 |  | 50 | 5 | 45
HDS | T1 |  | SITE3 |  | 50 | 5 | 45
HP | T1 |  | SITE2 |  | 100 | 0 | 100
HDS | T2 |  | SITE2 |  | 100 | 0 | 100
Spreadsheet: 03cb1940-04d1-4afd-806b-ce03ed96a837
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 | Unnamed: 12
Bilateral and regional support 2004-2008 (SEK million)
 | Mitigation |  |  |  |  |  | Adaptation |  |  |  | Other | Total
 | Energy | Transport | Forestry | Agriculture | Waste | Industry | Water | Forestry | Agriculture | Other adapt.
2004 | 160 | 0.09 | 71 | 43 | 103 | 0.3 | 146 | 89 | 202 | 112 | 74 | 998
2005 | 153 | 59 | 86 | 92 | 321 | 23 | 252 | 108 | 344 | 429 | 232 | 2100
2006 | 286 | 45 | 137 | 102 | 127 | 26 | 351 | 135 | 292 | 392 | 224 | 2116
2007 | 233 | 49 | 90 | 77 | 124 | 22 | 313 | 118 | 342 | 239 | 170 | 1777
2008 | 427 | 84 | 83 | 121 | 147 | 27 | 400 | 97 | 322 | 327 | 147 | 2182
Total | 1259 | 238 | 467 | 435 | 822 | 97 | 1462 | 547 | 1502 | 1497 | 848 | 9170
 | Total emission reduction: approx. 3300 |  |  |  |  |  | Total adaptation: approx. 5000 |  |  |  | Tot: approx. 850
Spreadsheet: 473783d1470396895-need-help-completing-a-calculator-freight-calculator
Sheet: Ark1

Freight Calculator
Pieces and Dimensions |  |  |  |  |  |  |  | Volume Charge |  | Weight Charge
Pieces | Length | [NAME] | Height | Weight pr pcs | Total Weight | Volume
1 | 72 | 80 | 80 | 44
 |  |  |  |  |  |  |  | Rates |  | Charges
 |  |  |  |  |  |  |  | M | 800 | AWA |  |  | AWB & Label fee
 |  |  |  |  |  |  |  | N | 83.1 | MAA |  |  | Terminal & Airport fee
 |  |  |  |  |  |  |  | 100 | 34.1 | XBC | 320 |  | Screening fee
 |  |  |  |  |  |  |  | 300 | 31.9 | SCC |  | 1.7 | Security fee - Ask Airline
 |  |  |  |  |  |  |  | 500 | 30.4 | MYC |  | 7.55 | Fuel fee - Ask Airline
 |  |  |  |  |  |  |  | 1000 |  | CHA |  | 800 | 800,- Clearance fee - If value is greater than 5000,-
 |  |  |  |  |  |  |  |  |  | RAC |  | 1080 | DGR fee - 950,- + 130,- pr extra UN
 |  |  |  |  |  |  |  | Total Rates |  | Total Charges
 |  |  |  |  |  |  |  | Grand Total