tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 815917d1675265191-making-one-table-conditional-of-another-table-new-rule-reducer_weights
Sheet: Sheet1

 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 42 | 44 | 46 | 48 | 50 | 52 | 54 | 56 | 58 | 60 | 62 | 64 | 66 | 68 | 70 | 72
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
22
24
26
28
30
32
34
36
38
40
42
44
46
48
50
52
54
56
58
60
 | [NAME]. | Air
 | 3 | 7.069 |  |  | Wt Per Ft
 | 4 | 12.566 |  |  | 1.156
 | 5 | 19.635 |  |  | 1.406
 | 6 | 28.274 |  |  | 1.656
 | 7 | 38.485 |  |  | 2.156
 | 8 | 50.266 |  |  | 2.656
 | 9 | 63.617 |  |  | 3.281
 | 10 | 78.54 |  |  | 4.531
 | 12 | 113.098 |  |  | 5.781
 | 14 | 153.938
 | 15 | 176.715
 | 16 | 201.062
 | 17 | 226.981
 | 18 | 254.47
 | 20 | 314.16
 | 22 | 380.134
 | 24 | 452.39
 | 26 | 530.93
 | 28 | 615.751
 | 30 | 706.86
 | 32 | 804.25
 | 34 | 907.922
 | 36 | 1017.878
 | 38 | 1134.118
 | 40 | 1256.64
 | 42 | 1385.446
 | 44 | 1520.534
 | 46 | 1661.906
 | 48 | 1809.562
 | 50 | 1963.5
 | 52 | 2123.722
 | 54 | 2290.226
 | 56 | 2463.014
 | 58 | 2642.086
 | 60 | 2827.44
Spreadsheet: 37623d1235663344-summarizing-sales-data-example
Sheet: Sheet1

DATE | MONTH | SALES |  |  | SALES
2009-01-01 00:00:00 | 1 | 549 |  | 1 | 3147
2009-01-02 00:00:00 | 1 | 863 |  | 2 | 1370
2009-01-05 00:00:00 | 1 | 913 |  | 3 | 978
2009-02-01 00:00:00 | 2 | 694 |  | 4 | 1018
2009-02-02 00:00:00 | 2 | 676 |  | 5 | 760
2009-04-05 00:00:00 | 4 | 509 |  | 6 | 1337
2009-04-01 00:00:00 | 4 | 509 |  | 7 | 1603
2009-03-02 00:00:00 | 3 | 978 |  | 8 | 2121
2009-05-05 00:00:00 | 5 | 760 |  | 9 | 652
2009-07-01 00:00:00 | 7 | 728 |  | 10 | 0
2009-07-02 00:00:00 | 7 | 875 |  | 11 | 709
2009-08-05 00:00:00 | 8 | 594 |  | 12 | 1571
2009-06-01 00:00:00 | 6 | 810
2009-12-02 00:00:00 | 12 | 675
2009-01-05 00:00:00 | 1 | 822
2009-08-01 00:00:00 | 8 | 830
2009-11-02 00:00:00 | 11 | 709
2009-09-05 00:00:00 | 9 | 652
2009-06-01 00:00:00 | 6 | 527
2009-12-02 00:00:00 | 12 | 896
2009-08-05 00:00:00 | 8 | 697
Spreadsheet: 767873d1644685652-having-trouble-coming-up-with-combination-lookup-value-based-on-rank-result-2021-auto-update-test
Sheet: STANDINGS

2021 SEASON STANDINGS
 | ANGLER | FISH CT. | WGTS. LBs |  | BIG BASS | WGT. LBs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 09ae7a7e-fc8e-4eba-b5c4-1e2036a9c697
Sheet: 7 - Collision Benefits

ATTACHMENT 7:  Collision Benefits
Average Annual Collision Benefits
Source: Abbreviated Injury Scale (AIS) Calculation for Monetizing Accident Reduction, TIGER BCA Resource Guide
 | 2008-2012 |  | Fatal Accidents |  |  | # Non-fatal Accidents
 |  |  | # Fatalities at Crash Site |  |  | Unknown if injured
 |  |  | 0.4 | $ [NAME] | Pr(AISx) | 4.8 | $ [NAME]
 | Accident Counts |  |  | Fatalities * VSL |  |  | [Pr(AISx)*Value(AISx)]
 | AIS | 0 | 0 | 0 | 0.43676 |  | 0
 |  | 1 | 0 | 0 | 0.41739
 |  | 2 | 0 | 0 | 0.08872
 |  | 3 | 0 | 0 | 0.04817
 |  | 4 | 0 | 0 | 0.00617
 |  | 5 | 0 | 0 | 0.00279
 |  | Fatality |  | 9100000 | 0 |  | 0
 | SUBTOTALS
 | TOTAL VALUE OF FATALITIES & INJURIES
Spreadsheet: 763162d1642013286-index-match-formula-to-exclude-blank-cells-test-excel-sheet
Sheet: Distribution

Team | Recipient
Spreadsheet: 4041b8bb-356e-4ef9-875e-5e9732c5f6c2
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: |  |  | 2013-12-13 09:37:43.180000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.875 | 102.44 | 102.315 | 102.19 | 101.815
4.75 | 101.947 | 101.822 | 101.697 | 101.322 |  | Note: | Refer To Price [NAME]
4.625 | 101.225 | 101.1 | 100.975 | 100.6 |  |  | For all Price Adjs
4.5 | 100.318 | 100.193 | 100.068 | 99.443
4.375 | 99.357 | 99.232 | 99.107 | 98.482
4.25 | 98.475 | 98.35 | 98.225 | 97.6
4.125 | 97.66 | 97.535 | 97.41 | 96.785
4 | 96.654 | 96.529 | 96.404 | 95.779 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.625 | 102.5 | 102.375 | 102
3.875 | 101.949 | 101.824 | 101.699 | 101.324
3.75 | 101.226 | 101.101 | 100.976 | 100.601
3.625 | 100.695 | 100.57 | 100.445 | 100.07
3.5 | 100.167 | 100.042 | 99.917 | 99.292
3.375 | 99.413 | 99.288 | 99.163 | 98.538
3.25 | 98.684 | 98.559 | 98.434 | 97.809 |  | 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 | 2013-12-27 09:37:43.180000
30 DAY | 2014-01-11 09:37:43.180000
45 DAY | 2014-01-26 09:37:43.180000
60 DAY | 2014-02-10 09:37:43.180000
90 DAY | 2014-03-12 09:37:43.180000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 133786d1324612721-doesnt-seem-right-from-previous-year-p-and-l2010help
Sheet: Feb

Profit and Loss Statement |  | Tax Year: |  | February
 |  | Monthly Summary | Total Income
 |  |  | Total Expense
Gross margin  [L/J]
Return on sales  [T/J] |  |  | Profit / (Loss)
Net Profit % Change from Prior Period
 | Prior Period | Current Period | Current Period as    % of Sales | % Change from Prior Period
Sales Revenue
Health Insurance
Medicare Advantage
Medicare Supplement
Life Insurance |  | 2700
Investment (Annuity)
Other
Total Sales Revenue  [J]
Cost of Sales
Specify
Total Cost of Sales  [K]
Gross Profit  [L=J-K]
Operating Expenses
Sales and Marketing
Advertising (Radio, TV, Print Media, etc) |  | 250
Printing
Direct marketing
Seminar
Meals and Entertainment
Total Sales and Marketing Expenses  [M]
Research & Development
Licenses
Education
Total Research & Development Expenses  [N]
General and Adminstrative
Rent
Payroll
Utilities
Telephone
Health Insurance
E&O Insurance
Software
Web Hosting and domains
Postage
Office Supplies
Equipment
Repairs and maintenance
Other expenses (specify)
Auto (Tires, Fuel, Oil, Tolls, [NAME], etc)
Auto Mileage (IRS standard deduction; averaged) |  | 234
Total General & Adminstrative Expenses  [O]
Total Operating Expenses  [P=M+N+O]
Income from Operations  [Q=L-P]
Other Income (Bonuses) [R]
Taxes
Payroll Taxes
Property Taxes
Total Taxes  [S]
Net Profit  [T=Q+R-S]
Spreadsheet: mark_taylor__25000__FLag Football  Roster
Sheet: Roster (2)

 |  | ENRON 111
 | 7 | RAFAEL AVILA
 | 17 | DARREN BINNS
 | 23 | HUY DINH
 | 15 | [NAME]
 | 33 | LONG HA
 | 3 | KEVIN MURRAY
 | 25 | [NAME]
 | 12 | MIEN PHAM
 | 1 | RAHMAN POUNDS
 | 22 | RICHARD ORELLANA
 | 34 | EDDIE SERA
 | 4 | SCOTT TACKETT
 | 6 | MICAH HATTEN
 | 44 | BAO VINH
 | 21 | [NAME]
 | 16 | MIKE NGUYEN
 | 2 | [NAME]
 | 5 | PAUL HAUN
 | 7 | WILLIAM WESTBROOK
 | 8 | Extra
 | 9 | Extra
 | 10 | Extra
 | 11 | Extra
 | 12 | Extra
 | 13 | Extra
Spreadsheet: 120911d1315628842-saving-a-workbook-in-formula-view-formulaviewtest
Sheet: Sheet1

Date | Purchase | Amount | Category
2010 | Greater Jamaica Dev Corp |  | rent
2010 | Ipark |  | garage
2010 | JDS Industries | 4013 | supplier |  |  | Row Labels | Sum of Amount
2010-01-04 00:00:00 | F & H Ribbons | 35.21 | supplier |  |  | Finacial | 14.95
2010-01-06 00:00:00 | Restaurant | 46.25 | meals |  |  | garage | 1248
2010-01-08 00:00:00 | 4over | 55 | Printing |  |  | meals | 46.25
2010-01-07 00:00:00 | Staples | 13.43 | Office Supplies |  |  | Office Supplies | 47.44
2010-01-11 00:00:00 | Equifax | 14.95 | Finacial |  |  | Printing | 55
2010-01-11 00:00:00 | Staples | 21.73 | Office Supplies |  |  | rent | 6000
2010-01-12 00:00:00 | MTA | 10 | Transportation |  |  | supplier | 4048.21
2010-01-12 00:00:00 | Staples | 8.48 | Office Supplies |  |  | Transportation | 10
2010-01-12 00:00:00 | Staples | 3.8 | Office Supplies |  |  | Grand Total | 11469.85
Spreadsheet: robert_badeer__33090__8_24
Sheet: Sheet1

WEST | TRADE DATE | Counterparty | Buy/Sell from EPMI View | Buy/Sell from EES View | Trader | Location | Type (PFI) | Term | Peak, Off-peak, Super Peak, [NAME] or Flat | Volume | Price | Broker,EOL, Internal or Notes | EPMI TRADER Providing Sleeve | EPMI Deal # | EES DEAL Tracker # | EES Traders
1 | 2000-08-24 00:00:00 | EES | BUY | SELL | NB | COB | P | Q4 00 | PEAK | 25 | 124 | TFS | MATCHED UP WITH MS |  | 5464 | JW = [NAME]
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB= [NAME]
3 |  | EES | BUY | SELL | JW | NP | P | Q4 2000 | PEAK | 25 | 107.5 | EOL |  |  | 5468
4
5 |  | EES | BUY | SELL | JW | NP | P | Q4 2000 | PEAK | 25 | 105 | EOL |  |  | 5469
6
7 |  | EES | BUY | SELL | JW | NP | P | Q4 2000 | PEAK | 25 | 103 | EOL |  |  | 5470
8
9 |  | EES | SELL | BUY | JW | SP | P | Q4 2000 | PEAK | 25 | 90.5 | EOL |  |  | 5471
10
11 |  | SEMPRA | SELL | SLEEVE | MB | SP | P | Q4 2000 | PEAK | -25 | -105 | PREBON | BB |  | 5472
12 |  | EES | BUY | SELL | JW | SP | P | Q4 2000 | PEAK | 25 | 104.95
13
14 |  | EES | SELL | BUY | JW | SP | P | Q4 2000 | PEAK | 25 | 92 | EOL |  |  | 5474
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
Spreadsheet: 819287d1677385492-need-a-formula-to-return-balance-of-last-day-of-previous-month-sample12
Sheet: Sheet1

 |  |  | Date | Balance
Today's Date |  |  | 2023-01-23 00:00:00 | 265
End of Month Previous Balance |  |  | 2023-01-25 00:00:00 | 270
 |  |  | 2023-01-18 00:00:00 | 280.3
 |  |  | 2023-01-29 00:00:00 | 295.23
 |  |  | 2023-01-30 00:00:00 | 301.24
 |  |  | 2023-01-31 00:00:00 | 285.65
 |  |  | 2023-02-08 00:00:00 | 297.22
 |  |  | 2023-02-15 00:00:00 | 298.31
 |  |  | 2023-02-16 00:00:00 | 301.23
 |  |  | 2023-02-18 00:00:00 | 303.25
 |  |  | 2023-02-22 00:00:00 | 305.41
 |  |  | 2023-02-28 00:00:00 | 308.41
 |  |  | 2023-03-06 00:00:00 | 357.11
 |  |  | 2023-03-08 00:00:00 | 380.96
 |  |  | 2023-03-11 00:00:00 | 405.33
 |  |  | 2023-03-20 00:00:00 | 408.89
 |  |  | 2023-03-21 00:00:00 | 440.85
 |  |  | 2023-03-25 00:00:00 | 460.18
 |  |  | 2023-03-31 00:00:00 | 508.85
Spreadsheet: 0103b402-b0ca-4f36-87f5-a26eb05b8469
Sheet: Sheet1

Comprehensive Plan Actions Summary -  July 2013
 |  |  | Adopted |  | 2009-03-01 00:00:00 |  | 2010-04-01 00:00:00 | 2010-09-01 00:00:00 | 2011-03-01 00:00:00 | 2011-10-11 00:00:00 | 2012-04-12 00:00:00 | 2012-12-12 00:00:00 | 2013-07-01 00:00:00
Total Number of Actions |  |  | 88
Total Number of Actions Completed |  |  |  |  | 28 |  | 1 | 3 | 1 | 2 | 1 | 0 | 0
Number of Actions Remaining |  |  |  |  |  |  |  | 56 | 55 | 53 | 52 | 52 | 52
Number of Short Range Actions: |  |  | 19
 | Completed |  |  |  | 9 |  | 0 | 0 | 0 | 0 | 1 | 0 | 0
 | In Progress |  |  |  | 10 |  | 10 | 10 | 10 | 10 | 9 | 9 | 9
 | Pending/No Action |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 10 | 10 | 10 | 9 | 9 | 9
Number of Medium Range Actions: |  |  | 26
 | Completed |  |  |  | 12 |  | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | In Progress |  |  |  | 13 |  | 13 | 13 | 13 | 13 | 13 | 13 | 13
 | Pending/No Action |  |  |  | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 14 | 13 | 13 | 13 | 13 | 13
Number of Long Range Actions: |  |  | 22
 | Completed |  |  |  | 6 |  | 0 | 1 | 1 | 2 | 0 | 0 | 0
 | In Progress |  |  |  | 16 |  | 15 | 14 | 13 | 12 | 12 | 12 | 12
 | Pending/No Action |  |  |  | 0 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  | 16 | 15 | 15 | 15 | 15 | 15
Number of On Going Actions: |  |  | 20
 | Completed |  |  |  | 1 |  | 0 | 2 | 0 | 0 | 0 | 0 | 0
 | In Progress |  |  |  | 19 |  | 19 | 17 | 17 | 17 | 17 | 17 | 17
 | Pending/No Action |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | 17 | 17 | 17 | 17 | 17 | 17
 |  |  | 88 |  |  |  |  | 3 | 1 | 2 | 1 | 0 | 0
 |  |  |  |  | Total Actions Completed |  |  |  | 36
Spreadsheet: 841001d1693246715-create-a-sum-in-a-cell-based-off-of-the-contents-of-another-workbooks-cells-project-workbook
Sheet: Pivot Data

Capital |  |  |  | Expense |  |  |  | Prof. Services Tek Sys |  |  |  | Prof. Services [NAME]
Select Period | Sum of Amount | Sum of Quantity |  | Select Period | Sum of Amount | Sum of Quantity |  | Row Labels | Sum of Amount | Sum of Hrs Wrk |  | Row Labels | Sum of Amount | Sum of Hrs Wrk
(blank) |  |  |  | (blank) |  |  |  | (blank) |  |  |  | (blank)
(blank) |  |  |  | (blank) |  |  |  | (blank) |  |  |  | (blank)
(blank) |  |  |  | Grand Total |  |  |  | Grand Total |  |  |  | Grand Total
(blank)
Grand Total
Spreadsheet: 47187d1246088709-excel-2007-need-help-to-create-a-summary-table-summary
Sheet: Divisional Totals

 | SUMMARY
 | 2007 | 2008 | 2009
Employees
Machines
Division Name | 2007 | 2008 | 2009
Employees | 23 | 30 | 32
Machines | 5 | 9 | 6
Division Name | 2007 | 2008 | 2009
Employees | 15 | 23 | 23
Machines | 3 | 3 | 4
Division Name | 2007 | 2008 | 2009
Employees | 4 | 5 | 6
Machines | 3 | 5 | 5
Division Name | 2007 | 2008 | 2009
Employees | 5 | 6 | 7
Machines | 2 | 3 | 6
Division Name | 2007 | 2008 | 2009
Employees | 2 | 2 | 9
Machines | 9 | 8 | 7
Division Name | 2007 | 2008 | 2009
Employees | 201 | 250 | 200
Machines | 3 | 4 | 6
Division Name | 2007 | 2008 | 2009
Employees | 60 | 70 | 72
Machines | 56 | 57 | 57
Division Name | 2007 | 2008 | 2009
Employees
Machines
Division Name | 2007 | 2008 | 2009
Employees
Machines
Spreadsheet: 719991d1613958340-how-to-use-vlookup-true-to-extract-values-test-4-
Sheet: Sheet1

ID | Expected Result | [NAME] result |  |  |  | Target ID | Value
55B_1_3000 |  |  |  |  |  | 55B_1_0 | A
 |  |  |  |  |  | 55B_1_2000 | B
 |  |  |  |  |  | 55B_1_3200 | C
232_3_4000 |  |  |  |  |  | 55B_1_4000 | D
 |  |  |  |  |  | 55B_1_5100 | E
 |  |  |  |  |  | 232_2_0 | F
 |  |  |  |  |  | 232_3_2000 | G
 |  |  |  |  |  | 232_3_4200 | H
Spreadsheet: 119353d1314348304-help-with-function-to-interleave-2-columns-to-1-row-with-blank-cells-example
Sheet: Sheet1

 | 18 | 17 | 16 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1
 | LIST
1 |  |  |  |  |  |  |  |  | aaaa | 31I | 40A_40B | bbbb | 45A_45B | 46A_46D | 610_640 | 700_702 | cccc | 710_730
2 |  |  |  |  |  |  |  |  |  | aaaa | 620_07 | 700_21 | 701_09 | 702_00 | bbbb | 710_01 | 711_22 | 720_03
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
Spreadsheet: 122290d1316712068-excel-2007-look-up-dates-and-return-value-test
Sheet: Sheet1

 | TABLE 1 -Historic Stock Prices
 | Effective Date | Stock Price
 | 2005-01-01 00:00:00 | 18
 | 2006-01-01 00:00:00 | 21
 | 2007-01-01 00:00:00 | 22
 | 2008-01-01 00:00:00 | 23
 | 2009-01-01 00:00:00 | 24
 | 2010-01-01 00:00:00 | 25
 | 2011-01-01 00:00:00 | 26
 | Table 2 - I need a lookup formula to pull the stock price from table 1
 | Grant Date | Stock Price
 | 2005-01-10 00:00:00
 | 2005-12-28 00:00:00
 | 2006-02-28 00:00:00
 | 2007-05-19 00:00:00
 | 2008-06-20 00:00:00
 | 2009-07-01 00:00:00
 | 2010-01-01 00:00:00
 | 2011-07-31 00:00:00
Spreadsheet: jeff_dasovich__14195__MERTON_5
Sheet: Merton 5

Merton Truck Company -- Problem 5
 | M 101 | M 102
Contribution | 3000 | 5000 |  |  | [NAME]. =
Quantity | 0 | 0 |  |  | Total Profit =
 |  |  |  | Total |  | Total
 | Machine-hours per Truck |  |  | Consumed |  | Available
 |  |  |  | Machine |  | Machine
 | M 101 | M 102 |  | Hrs. per Mo. |  | Hrs. per Mo.
Eng. Assem. | 1 | 2 |  |  | <= | 4000
[NAME]. | 2 | 2 |  |  | <= | 6000
M 101 Assem. | 2 | 0 |  |  | <= | 5000
M 102 Assem. | 0 | 3 |  |  | <= | 4500
 |  |  |  | Constraint's |  | Constraint's
 | M 101 | M 102 |  | LHS |  | RHS
President's
Constraint | 1 | -3 |  |  | >= | 0
Spreadsheet: 216681d1361848038-imbedded-index-vlookup-atch-formula-ckg-operating-costs1
Sheet: Insurance

Insurance Estimate Calculator
Region | Base Cost | Deduction for Excellent Driver | Addition for Poor Driver | Addition for City Residence | Deduction for Rural Residence
1 | 2200 | 350 | 550 | 375 | 400
2 | 1670 | 325 | 475 | 375 | 220
3 | 1390 | 300 | 450 | 375 | 200
4 | 1170 | 300 | 450 | 375 | 100
5 | 2250 | 350 | 625 | 375 | 500
Spreadsheet: 840410d1692715031-cant-get-xlookup-to-work-example-151-aligw
Sheet: Taul1

 |  |  | [NAME]? | Scania Manuaali
18FEF721 |  |  | Kyllä
18FEF521 |  |  | Kyllä
18FE4F0B |  |  | Kyllä
18FEC017 |  |  | Kyllä
18FE7003 |  |  | Kyllä
18FDE22F |  |  | Kyllä
18FEEF21 |  |  | Kyllä
18FE582F |  |  | Kyllä
18FE700B |  |  | Kyllä
18FF4072 |  |  | Kyllä
 |  |  |  |  |  |  | X
Spreadsheet: 849109d1699638487-combine-3-sheets-data-into-1-final-sheet-book1-2-
Sheet: Sheet4

 | Score 1 | Score 2 | Score 3 | Total | Class
a | 10 |  | 4 | 14 | qq
b | 5 |  |  | 5 | ww
c | 5 | 3 |  | 8 | ee
D |  | 5 |  | 5
E |  |  | 6 | 6
L |  | 3 | 3 | 6
Spreadsheet: 113123d1309091139-expanding-ifcount-formula-to-include-other-variable-qualification-matrix-v3-
Sheet: Sheet1

 |  | Primary Qualification Enrolled Into |  |  |  | Related Qualification
 |  |  |  | Step 3 - Enrol
 |  | Code | Description | C/RPL/CT |  | Related Qualification | Related Required Units | Relationship | C/RPL/CT
Step 1 | [NAME] | PSP41504
 | Required Unit set out in Qualification Descriptor
 |  |  |  |  |  |  | Other Required Uits | Relationship | C/RPL/CT | Total REQ
 |  |  |  | Step 4 - Enrol
Step 2 | Select Electives | Required Number of Electives | Code and Description | C/RPL/CT
 | Must be  at same or higher qualification level
 |  |  |  |  |  |  | Related Elective Units | Relationship | C/RPL/CT
 |  |  |  |  |  |  |  |  |  | Total ELEC
 |  |  | Qualifications Achieved as part of selected program
 |  |  |  |  |  | Related Qualification | Related Required Units | Relationship | C/RPL/CT
 |  | Qualification
 |  | Qualification
 |  | Qualification
 |  | Instructions for completing this form |  |  |  |  | Other Required Uits | Relationship | C/RPL/CT
 |  | This form is designed so that if an individual or agency desires to do additional units outside of the required number of electives, they can make an informed decisions as to what qualifications can be achieved by selecting certain units of competencies
 | Step 1 | Select the Qualification Code from the drop down list
 | Step 2 | Select the desired number of electrives from the drop down list
 |  | The right hand area displays what the additional qualifications the required units and selected electives go towards
 |  | The Related Qualification area is automatically updated from the dispayed/selected units in the Primary Qualification area
 |  | The relevant qualifications that are achieved as a result of the selected program are displayed above
 |  |  |  |  |  |  |  |  |  | Total REQ
 |  |  |  |  |  |  | Related Elective Units | Relationship | C/RPL/CT
 |  |  |  |  |  |  |  |  |  | Total ELEC
Spreadsheet: 78310d1278686380-group-data-book1
Sheet: Sheet1

Table 1 |  |  |  |  |  |  |  |  | Table 2
Furnisher | Date | products ordered | cost per unit | Units orderd | TAX | Total Cost |  |  | Consumers | Date | products sold | cost per unit | Units sold | TAX | Total Cost
Furnisher 1 | 2010-01-02 00:00:00 | Computer | 250 | 8 | 0.1 | 200 |  |  | Consumer 1 | 2010-01-02 00:00:00 | Computer | 300 | 5 | 0.1 | 150
Furnisher 2 | 2010-02-06 00:00:00 | [NAME] | 40 | 15 | 0.1 | 60 |  |  | Consumer 2 | 2010-02-06 00:00:00 | [NAME] | 50 | 6 | 0.1 | 30
Furnisher 3 | 2010-03-02 00:00:00 | Printer | 50 | 13 | 0.1 | 65 |  |  | Consumer 3 | 2010-03-02 00:00:00 | Printer | 60 | 7 | 0.1 | 42
Furnisher 4 | 2010-04-02 00:00:00 | calculator | 3.5 | 130 | 0.1 | 45.5 |  |  | Consumer 4 | 2010-04-02 00:00:00 | calculator | 5 | 100 | 0.1 | 50
Furnisher 1 | 2010-05-02 00:00:00 | Computer | 250 | 8 | 0.1 | 200 |  |  | Consumer 5 | 2010-05-02 00:00:00 | Computer | 300 | 5 | 0.1 | 150
Furnisher 2 | 2010-06-02 00:00:00 | Computer | 250 | 10 | 0.1 | 250 |  |  | Consumer 6 | 2010-06-02 00:00:00 | [NAME] | 50 | 6 | 0.1 | 30
Furnisher 3 | 2010-07-02 00:00:00 | Printer | 50 | 10 | 0.1 | 50 |  |  | Consumer 7 | 2010-07-02 00:00:00 | Printer | 60 | 7 | 0.1 | 42
Furnisher 4 | 2010-08-02 00:00:00 | calculator | 3.5 | 130 | 0.1 | 45.5 |  |  | Consumer 8 | 2010-08-02 00:00:00 | calculator | 5 | 100 | 0.1 | 50
Furnisher 1 | 2010-09-02 00:00:00 | Computer | 250 | 8 | 0.1 | 200 |  |  | Consumer 9 | 2010-09-02 00:00:00 | Computer | 300 | 5 | 0.1 | 150
Furnisher 2 | 2010-10-02 00:00:00 | [NAME] | 40 | 9 | 0.1 | 36 |  |  | Consumer 10 | 2010-10-02 00:00:00 | [NAME] | 50 | 6 | 0.1 | 30
Furnisher 3 | 2010-11-02 00:00:00 | Printer | 50 | 10 | 0.1 | 50 |  |  | Consumer 11 | 2010-11-02 00:00:00 | Printer | 60 | 7 | 0.1 | 42
Furnisher 4 | 2010-01-03 00:00:00 | calculator | 3.5 | 130 | 0.1 | 45.5 |  |  | Consumer 5 | 2010-01-03 00:00:00 | calculator | 5 | 100 | 0.1 | 50
Furnisher 1 | 2010-02-03 00:00:00 | Computer | 250 | 8 | 0.1 | 200 |  |  | Consumer 6 | 2010-02-03 00:00:00 | Computer | 300 | 5 | 0.1 | 150
Furnisher 2 | 2010-03-03 00:00:00 | [NAME] | 40 | 9 | 0.1 | 36 |  |  | Consumer 7 | 2010-03-03 00:00:00 | [NAME] | 50 | 6 | 0.1 | 30
Furnisher 3 | 2010-04-03 00:00:00 | Printer | 50 | 10 | 0.1 | 50 |  |  | Consumer 8 | 2010-04-03 00:00:00 | Printer | 60 | 7 | 0.1 | 42
 |  |  |  |  |  |  |  |  | Consumer 6 | 2010-04-04 00:00:00 | Computer | 300 | 5 | 0.1 | 150
 |  |  |  |  |  |  |  |  | Consumer 7 | 2010-04-05 00:00:00 | Computer | 300 | 5 | 0.1 | 150
 |  |  |  | 508 |  | 1533.5 |  |  |  |  |  |  | 382 |  | 1338
 | Like this:
 | Table 3: |  |  | Units remained
 |  |  | Computer | 2
 |  |  | [NAME] | 19
 |  |  | Printer | 15
 |  |  | Calator | 90