tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707633d1607383970-ranking-score-based-on-sequence-date-rank-problem
Sheet: Sheet1

 |  |  |  |  |  |  | my target (desired result)
 |  |  |  | name | score | date | rank
 |  |  |  | jhon | 90 | 2020-10-10 00:00:00
 |  |  |  | [NAME] | 100 | 2020-01-31 00:00:00 | rank-1 | cause score 100 and earliest date
 |  |  |  | [NAME] | 80 | 2020-07-26 00:00:00
 |  |  |  | ish | 100 | 2020-12-12 00:00:00 | rank-2 | cause score 100 and earliest date
 |  |  |  | stec | 100 | 2021-03-17 00:00:00 | rank-3 | cause score 100 and earliest date
Spreadsheet: 13ee6744-af56-422f-bbab-90073b9d76b8
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
 | 5368.0 International Trade in Goods and Services, Australia
 | TABLE 2. GOODS AND SERVICES, Summary: Original, Current prices
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Balance on goods and services ; |  |  | Original | A2717903C | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Credits, Total goods and services ; |  |  | Original | A2717883F | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Credits, Total goods ; |  |  | Original | A2717881A | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Credits, Rural goods ; |  |  | Original | A2717884J | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Credits, Non-rural goods ; |  |  | Original | A2717931L | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Credits, Net exports of goods under merchanting ; |  |  | Original | A2718034F | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Credits, Non-monetary gold ; |  |  | Original | A2718037L | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Credits, Total services ; |  |  | Original | A2718332C | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Debits, Total goods and services ; |  |  | Original | A2717891F | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Debits, Total goods ; |  |  | Original | A2718054R | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Debits, Consumption goods ; |  |  | Original | A2718056V | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Debits, Capital goods ; |  |  | Original | A2718126R | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Debits, Intermediate and other merchandise goods ; |  |  | Original | A2718182J | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Debits, Non-monetary gold ; |  |  | Original | A2718320V | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
Debits, Total services ; |  |  | Original | A2718454A | 1971-07-01 00:00:00 | 2010-04-01 00:00:00 | 466 | $ Millions | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 59369d1259857338-real-estate-commission-schedule-real-estate-commissions
Sheet: Sheet1

LISTING% | COMP A% | COMP B% | COMP C% | EARNINGS
0.5 | 0.5 | 0.55 | 0.5 | 0 | 8137
0.54 | 0.56 | 0.55 | 0.5 | 8138 | 16153
0.57 | 0.63 | 0.55 | 0.5 | 16154 | 22905
0.62 | 0.68 | 0.6 | 0.55 | 22906 | 29655
0.67 | 0.73 | 0.63 | 0.58 | 29656 | 36165
0.72 | 0.78 | 0.65 | 0.6 | 36166 | 50000
CUST NAME | ADDRESS | SALE PRICE | BROKER'S COMM. | LISTING% | COMP A% | COMP B% | COMP C%
TEST 1 | 123 MAIN | 215000 | 7525.000000000001 |  | x
TEST 2 | 124 MAIN | 139900 | 4896.500000000001 |  |  | x
TEST 3 | 125 MAIN | 289900 | 10146.5 |  | x
TEST 4 | 126 MAIN | 180000 | 6300.000000000001 | x
TEST 5 | 127 MAIN | 301000 | 10535 |  |  |  | x
TEST 6 | 128 MAIN | 139900 | 4896.500000000001 |  | x
TEST 7 | 129 MAIN | 195000 | 6825.000000000001 |  | x
TEST 8 | 130 MAIN | 209900 | 7346.500000000001 | x
TEST 9 | 131 MAIN | 240000 | 8400 |  |  | x
TEST 10 | 132 MAIN | 199000 | 6965.000000000001 | x
 |  |  |  | 0 | 0 | 0 | 0 | 0 | <--Total Personal Commission Earned
Spreadsheet: 275257d1383421675-how-can-i-sum-up-values-corresponding-to-a-specific-serial-number-inksured-2nd-attempt
Sheet: Pricing Details

Paper | Colour/B&W | Rate
Regular | Colour | 5
Regular | B&W | 2
Bond | Colour | 6
Bond | B&W | 3
Glossy A4 | Colour | 35
Glossy A4 | B&W | 20
[NAME] | Colour | 45
[NAME] | B&W | 30
Spreadsheet: 92732d1292288851-formula-help-averages-find-last-three-numbers
Sheet: Sheet1

Helper Column | Numbers to find |  | [NAME] |  | Results
2 | 23 |  | 34
0 | X |  | 12
4 | 34 |  | 17
5 | 29
6 | 17
0 | X
0 | X
9 | 12
10 | 34
Spreadsheet: 153786d1336054060-droplist-to-change-table-0t
Sheet: Blad1

 | pricestructure | 5 |  |  |  |  |  | pricestructure | 1 | 2 | 3 | 4 | 5
 | a | 0.2 |  |  |  |  |  | a | 0.2 | 1 | 0.2 | 1 | 0.2
 | b | 0.3 |  |  |  |  |  | b | 0.3 | 0.75 | 0.3 | 0.75 | 0.3
 | c | 0.4 |  |  |  |  |  | c | 0.4 | 0.6 | 0.4 | 0.6 | 0.4
 | d | 0.6 |  |  |  |  |  | d | 0.6 | 12 | 0.6 | 12 | 0.6
 | e | 0.15 |  |  |  |  |  | e | 0.15 | 13 | 0.15 | 13 | 0.15
Spreadsheet: 851905d1702034090-trying-to-copy-filtered-cell-aadt_2018
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Filtering Options |  | A column | Year | 2018
 |  |  |  |  |  |  |  |  |  |  |  | C column | Road | 10B
 |  |  |  |  |  |  |  |  |  |  |  | between I & J | CH | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Y Value
 |  |  |  |  |  |  |  |  |  | Specific Outputs |  | WITH GAZETTAL
 |  |  |  |  |  |  |  |  |  |  |  | BOTH DIRECTIONS |  |  |  |  | 11109
 |  |  |  |  |  |  |  |  |  |  |  | AGAINST GAZETTAL |  |  |  |  | 5421
 |  |  |  |  |  |  |  |  |  | When all criteria is met Y value for that Row is placed in Light Blue boxes
Spreadsheet: 748109d1631891686-copy-information-from-multiple-tables-to-a-sheet-bwp-invoices
Sheet: Table 7

 |  |  |  |  |  |  |  |  |  |  |  | Date |  |  |  |  | Invoice #
 |  |  |  |  |  |  |  |  |  |  |  | 2021-09-03 00:00:00 |  |  |  |  | 78056
 | [NAME] |  |  |  |  |  |  |  |  | Ship To
P.O. Number |  |  | Terms |  | Rep |  | Ship |  |  |  |  |  | Project
PN31698 |  |  | 2%10NET45 |  | HOUSE |  | 2021-09-03 00:00:00
Quantity |  | Item Code |  | Description |  |  |  |  |  |  | Price Each |  |  |  | Amount
1 1 |  | 450858 Delivery Charges |  | KEY, LWR PULL ROLL, SY, 16 Crate Surcharge |  |  |  |  |  |  | 82.00 22.50 |  |  |  | 82.00 22.50
 |  |  |  |  |  |  |  |  |  |  | Total                              $104.50
Payments/Credits                 $0.00 |  |  |  |  |  |  |  |  | Balance Due |  |  |  |  | 104.5
Spreadsheet: 877181d1723863519-filter-function-to-extract-selected-columns-by-header-match-column-filter-1-
Sheet: Sheet1

Data | County | Region | Support Coordinator | Supervisor |  | Derised outcome | County | Supervisor
 | Walker | Region 1 | Diane Parsons | [NAME] |  |  |  | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 | Fulton | Region 3 | [NAME] | [NAME] |  |  | Fulton | [NAME]
 | Newton | Region 3 | [NAME] | [NAME] |  |  | Newton | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 | [NAME] | Region 3 | [NAME] | [NAME] |  |  | [NAME] | [NAME]
 |  |  |  |  |  | [NAME] Table, untick "My table has headers", then hide [NAME]
 |  |  |  |  |  | H2: =CHOOSECOLS(Data,[NAME]))
Spreadsheet: 126178d1319556859-populate-cells-in-different-worksheet-test
Sheet: Sheet1

CONTROL FORM |  |  | 11-99-01
DATE
AGENT REF | EXP |  |  | MODE | Sea
CONTAINER NO’S | 711760790 GATU0053648, TCLU2474706, BSIU2050543
COUNTRY OF ORIGIN |  | Argentina
Plant | Supplier | PO | PO LINE | KG | ID | Tariff
1 | ABC | 123456 | 10 | 150 | 9876
1 | ABC | 123457 | 10 | 100 | 9875
1 | ABC | 123458 | 10 | 20 | 9874
1 | ABC | 123459 | 10 | 50 | 9873
Spreadsheet: 141453d1329276117-excel-2007-multiple-indentical-lookups-required-from-table-array-dynamic-name-version
Sheet: Carton Analysis

Estimate# | Container ID | Mfg | Inven | Re-Order |  |  |  | Order #1 | Order #2
68916801 | *** 148 U (20KG.MSM) (VMI) | CAL |  | None
C6039601 | 103 G BODY (ROASTER) (VMI) | REG | 3020 | 2,000
C6039602 | 103 G LID (ROASTER) (VMI) | REG | 1750 | 2,000
69517201 | 10K | CAL | 960 | None
69598301 | 116A GROUND TURKEY (ECT 40) | CAL | 5250 | None
69572301 | 117 A | CAL | 6975 | 0
69773001 | 118 A | CAL | 1450 | None
A2999701 | 133 I (BODY) (BROILER) (VMI) | CAL | 3561 | 3,000
[NAME] | 133 I ([NAME]) | CAL | 3662 | 3,000
A2999901 | 134 H (BODY HEN)(VMI) | CAL | 6250 | 5,000
A2999902 | 134 H (LID HEN) (VMI) | CAL | 8688 | 5,000
[NAME] | 135 G (BODY HEN/TOM (VMI) | CAL | 10250 | 9,000
A3000302 | 135 G (LID HEN/TOM) (VMI) | CAL | 21180 | 9,000
A1668402 | 153 F (BODY 8-2P FASTPAK) (VMI) | REG | 9990 | 7,000
A1668401 | 153 F (LID 8-2P FASTPAK) (VMI) | REG | 9562 | 7,000
A4428301 | 158 E (VMI) | CAL | 16965 | 6,000
A3632701 | 161 L (SOUTH) (VMI) | CAL | 12600 | 9,000
A1925001 | 164 P (FOOD SERVICE/OPEN) (NO LOGO)(VMI) | CAL | 10060 | 12,000
A4372401 | 169 A (VMI) | CAL | 7560 | 18,000
A2625101 | 172 E (VMI) | CAL | 15070 | 10,500
68469901 | 173 E (VMI) | CAL | 13902 | 14,000
69464601 | 174A | CAL | 3100 | None
69426301 | 175 SUB | CAL | 6750 | None
68306801 | 177 C (PLAIN 12 x 908g MASTER/ECT23)CMI | CAL | 4460 | 0
67985701 | 239 A/BODY 4 BLOCK TRAY/VMI/X-VENT | CAL | 1710 | 15,000
67985801 | 239 A/LID 4 BLOCK TRAY/VMI/X-VENT | CAL | 3705 | 15,000
A2746901 | 502 C (SANDWICH OPEN) (PLAIN) (VMI) | CAL | 9094 | 8,000
80109101 | 504 A (PALLET SHEET)VMI | CAL | 1820 | 2,880
A3366701 | 542 D(BULK PEPPERONI-PLAIN-SOUTH) (VMI) | CAL | 400 | 6,400
69628401 | 6 X 1KG CMI | CAL | 7000 | None
68187201 | <<>>*** 235 A (ALTA/BC 2 PCE DW-SM) | CAL | 70 | None
69242401 | BACON MASTER BODY (ALT) (2 COLOR) | CAL | 1300 | None
69241101 | BACON MASTER LID (ALT) | CAL | 660 | None
Spreadsheet: 712777d1610396243-sumif-formula-pulling-0-test-
Sheet: Budget

2020 Q4 Budget
2021 Total Allocated Amounts | January | February | March | April | May | June | July | August | September | October | November | December | Total
Total Monthly CSPE Event Spend
 | January | February | March | April | May | June | July | August | September | October | November | December | Total
CSPE
2021 CSPE Event Budget
Remaining 2021 CSPE Event Budget
Total Monthly Program Costs Spend
 | January | February | March | April | May | June | July | August | September | October | November | December | Total
Team Meeting
[NAME]
Clothing
Tablet
Shipping
Training
Compliancy
Other (not accounted for)
Total
2021 BA Program Costs Budget
Remaining 2021 Program Costs Budget
2021 Program Hours | 8892
 | Hours | Used | Remaining
Calgary | 1712
Edmonton | 1600 |  |  |  | To Do:
Fraser Valley | 1700 |  |  |  | - travel tracker
Kelowna | 950
Vancouver | 1700 |  |  |  | - start to populate business unit buckets to keep requests away from CSPE budget
Victoria | 1230 |  |  |  | - tabluate and distribute hours to RMM team
Total
Spreadsheet: 801093d1666081624-auto-populating-a-reporting-form-test-form
Sheet: Sheet2

 | Description | code | price | Unit
 | Product 1 | 100001 | 5 | Each
 | Product 2 | 100002 | 10 | Each
 | Product 3 | 100003 | 15 | Each
 | Product 4 | 100004 | 20 | Each
 | Product 5 | 100005 | 25 | Each
Spreadsheet: 675598d1588361969-sumifs-multiple-conditions-with-numbers-stored-as-text-example
Sheet: Sheet

Example
 |  | Volume Bought per Shipment Period (SOYBEANS)
 |  | Branch\Shipment | 2020-01 | 2020-02 | 2020-03 | 2020-04 | 2020-05 | 2020-06 | 2020-07 | 2020-08 | 2020-09 | 2020-10 | 2020-11 | 2020-12
 |  | 501
 |  | 403
 |  | 402
 |  | 401
 |  | Volume Bought per Shipment Period (CORN)
 |  | Branch\Shipment | 2020-01 | 2020-02 | 2020-03 | 2020-04 | 2020-05 | 2020-06 | 2020-07 | 2020-08 | 2020-09 | 2020-10 | 2020-11 | 2020-12
 |  | 501
 |  | 403
 |  | 402
 |  | 401
Spreadsheet: 64ab430e-b06b-44a1-9a86-ec43427a24e6
Sheet: Sheet1

F/Y 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Justice of the Peace Authorized Bail Bond Agencies
Bail Bond Agencies | Address | Telephone  Number | Counties | Registered Agents | Authorized Agents to Pick Up Refunds
1st Choice Bail Bonds | 2800 Lancaster Avenue, Suite 4 | [PHONE] | All | [NAME] | [NAME]
 | [NAME], DE  19805
2nd Chance Bail Bonds | 25675 Covert Street |  | Kent | [NAME] | [NAME]
 | Seaford, DE  19973 | [PHONE] | Sussex
A Bail Bond by Resto & Co. | 1200 Northeast Boulevard, Unit B | [PHONE] | All | [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME]
 | [NAME], DE  19802
Above and Beyond Bail Bonds | 94A Quigley Boulevard
 | New Castle, DE  19720-4150 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | [NAME] | [NAME]
Absolute Bail Bonds | 104 [NAME] | [PHONE] | Kent | [NAME] | [NAME]
 | Milford, DE  19963 |  | Sussex
Ace Bail Bonds | 475 Bowers Beach Road | [PHONE] | Kent | [NAME] | [NAME]
 | Frederica, DE  19946
American Funding Services Corp. | 2062 New Castle Ave, Suite A |  |  | [NAME], [NAME], [NAME], [NAME] | [NAME]
CASH ONLY | New Castle, DE  19720 | [PHONE] | All |  | [NAME]
Axe Bail Bonds | 977 Lochmeath Way
 | Dover, DE  19901 | [PHONE] | All | [NAME] | [NAME]
 |  |  |  | Trinity Goldsborough | Trinity Goldsborough
Bail Bond Agency, Inc. | 102 Larch Avenue, Suite 302 | [PHONE] | All | [NAME] | [NAME]
 | Newport, DE  19804 |  |  | Khyon Church
Bovell Bail Bond, Inc. | 1900 W. 4th Street | [PHONE] | All | [NAME] | [NAME]
 | [NAME], DE  19805 |  |  | [NAME]
Bruny's Bail Bonds | 1927 W. 4th Street | [PHONE] | All | Brunilda Mercado | Brunilda Mercado
 | [NAME], DE  19805
Cutting Edge Bail Bonds, LLC | 315 South State Street
 | Dover, DE  19901 | [PHONE] | All* | [NAME] | [NAME]
 |  |  | *Cannot post in JP 7
Dale's Bail Bonds LLC | 11 E. Market Street, Suite 1 | [PHONE] | Kent | R. [NAME] | R. [NAME]
 | Georgetown, DE  19947 | [PHONE] | Sussex | [NAME] | [NAME]
[NAME], Jr. Bail Bonds | 411 S. Queen Street | [PHONE] | Kent | [NAME], Jr. | [NAME], Jr.
 | Apt. 213
 | Dover, DE  19904
Fast Bail Bonds LLC | 1224 [NAME] | [PHONE] | All* | [NAME] | [NAME]
 | [NAME], DE  19801 |  | *Cannot post in JP 7
Lorenzo's Bail Bonds, Inc. | 5 E. Market Street | [PHONE] | Kent | [NAME] | [NAME]
 | Georgetown, DE  19947 |  | Sussex | [NAME]
No Bars Bail Bonds LLC | 1224 [NAME]
 | [NAME], DE  19801 | [PHONE] | All | [NAME] | [NAME]
Paragon Associates of Delaware | 583 N. Commerce Street | [PHONE] | Kent
 | Townsend, DE  19734 |  | Sussex | [NAME] | [NAME]
T&H Bail Bond, Inc. | 625 [NAME] | [PHONE] | All | [NAME], [NAME], [NAME], [NAME] | [NAME], [NAME], [NAME], [NAME]
 | [NAME], DE  19801
[NAME]'s Bail Bonds, LLC | 424 S. State Street | [PHONE] | Kent | [NAME] | [NAME]
 | Dover, DE  19901
Spreadsheet: 876949d1723656023-vlookup-with-multiple-columns-vlookup-schedule-help
Sheet: Sheet1

Employee | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
Employee A |  |  | 10:00 AM - 08:00 PM | 10:00 AM - 08:00 PM | 09:00 AM - 08:00 PM | 09:00 AM - 08:00 PM | 09:00 AM - 08:00 P
Employee B |  | 03:00 PM - 12:00 AM | 03:00 PM - 12:00 AM | 11:00 AM - 08:00 PM | 03:00 PM - 12:00 AM | 03:00 PM - 12:00 AM
Employee C |  |  | 08:00 PM - 05:00 AM | 08:00 PM - 05:00 AM | 08:00 PM - 05:00 AM | 08:00 PM - 05:00 AM | 08:00 PM - 05:00 A
Employee D |  | 09:00 AM - 06:00 PM | 09:00 AM - 06:00 PM | 09:00 AM - 06:00 PM | 09:00 AM - 06:00 PM | 09:00 AM - 06:00 PM | 09:00 AM - 06:00 P
Employee E |  |  | 08:00 AM - 05:00 PM | 08:00 AM - 05:00 PM | 08:00 AM - 05:00 PM | 08:00 AM - 05:00 PM | 08:00 AM - 05:00 P
Tuesday | Region 1 | Lunch |  |  | 1st question |  | Sunday
10:00 AM - 08:00 PM | Employee A |  |  |  | 2nd question |  | Employee A
03:00 PM - 12:00 AM | Employee B |  |  |  | 3rd Question |  | Employee C
08:00 PM - 05:00 AM | Employee C |  |  |  |  |  | Employee D
09:00 AM - 06:00 PM | Employee D |  |  |  |  |  | Employee E
08:00 AM - 05:00 PM | Employee E
#N/A
#N/A
#N/A
Steps:
Under Region 1, pull the employee's name from the drop down menu.
Once chosen, the formula will look at A9 for the day of the week.
In the cell just left of the employee (A*), their schedule for the day will appear.
Also, once the day of the week is chosen in A9, it also copies to H9.
When day of the week appears under H9, all the employees working that day appear in a list below.
Spreadsheet: 852999d1702969699-getting-an-overall-status-based-on-two-columns-excelhelp2
Sheet: Sheet1

Project Number | Overall Status |  | Milestone Status
Migra000001-00 |  |  | Completed
Migra000001-01 |  |  | Ongoing
Migra000001-02 |  |  | Not Started
Migra000001-03 |  |  | Ongoing
Migra000002-00 |  |  | Not Started
Migra000002-01 |  |  | Ongoing
Resol000002-00 |  |  | Not Started
Resol000002-01 |  |  | Not Started
Spreadsheet: 716790d1612364374-sumif-across-multiple-sheets-test
Sheet: 2021-MOC-WL

Qty | Product | Type |  | Amount
1 | BlackCap [NAME] | Case
1 | [NAME] | Case
1 | [NAME] | Case
1 | BlackCap Seedless Sugarless Spread | Case
 |  | Subtotal
 |  | [NAME] 15%
 |  | tax |  | n/a
 |  | Total
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward
 | Measured | Scheduled | Measured | Scheduled
1 | -87770 | -89330
2 | -88047 | -88502
3 | -87233 | -80452
4 | -85416 | -89090
5 | -79179 | -79090
6 | -79663 | -79090
7 | -110402 | -111234 | -10778 | -10000
8 | -84430 | -82502 | -10987 | -10000
9 | -116235 | -118726 | -16703 | -16908
10 | -88622 | -89290 | -8183 | -10000
11 | -99079 | -99924
12 | -99644 | -99924
13 | -96896 | -99924
14 | -60119 | -59502 | -1
15 | -100957 | -100332
16 | -52592 | -50761
17 | -75444 | -74973
18 | -37841 | -37403
19
20
21
22
23
24
25
26
27
28
29
30
31
index
2001-07-31 00:00:00 |  |  |  |  | 469765.91
2001-08-18 00:00:00
CBS Volume
 |  |  | 29027
Spreadsheet: 732049d1620752173-count-of-historical-ticket-by-month-based-upon-an-open-and-closed-date-ticket-dummy-data
Sheet: Monthly Totals

Month | Tickets Opened in that month | Tickets Closed in that month | Balance | Existing
2018-01-01 00:00:00
2018-02-01 00:00:00
2018-03-01 00:00:00
2018-04-01 00:00:00
2018-05-01 00:00:00
2018-06-01 00:00:00
2018-07-01 00:00:00
2018-08-01 00:00:00
2018-09-01 00:00:00
2018-10-01 00:00:00
2018-11-01 00:00:00
2018-12-01 00:00:00
2019-01-01 00:00:00
2019-02-01 00:00:00
2019-03-01 00:00:00
2019-04-01 00:00:00
2019-05-01 00:00:00
2019-06-01 00:00:00
2019-07-01 00:00:00
2019-08-01 00:00:00
2019-09-01 00:00:00
2019-10-01 00:00:00
2019-11-01 00:00:00
2019-12-01 00:00:00
2020-01-01 00:00:00
2020-02-01 00:00:00
2020-03-01 00:00:00
2020-04-01 00:00:00
2020-05-01 00:00:00
2020-06-01 00:00:00
2020-07-01 00:00:00
2020-08-01 00:00:00
2020-09-01 00:00:00
2020-10-01 00:00:00
2020-11-01 00:00:00
2020-12-01 00:00:00
2021-01-01 00:00:00
2021-02-01 00:00:00
2021-03-01 00:00:00
2021-04-01 00:00:00
2021-05-01 00:00:00
Spreadsheet: 151825d1335141616-how-to-generate-a-unique-id-ncartest
Sheet: Totals

 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
 | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost
Main Categories
Manufacturing
Installation
Supplier
[NAME]
Transportation
Misc
Sales
Detailing
TOTALS
 | Jan |  | Feb |  | Mar |  | Apr |  | May |  | Jun |  | Jul |  | Aug |  | Sep |  | Oct |  | Nov |  | Dec |  | Total
 | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost | No of Issues | Net Cost
Sub Categories
D & E
[NAME]
Plumbing
Electrical
Flooring
Welding
Cladding
Doors & Windows
Cabinets
Detailing
Packing
Footings
Finishing
G James
Stratco
ApexFab
Lewis Steel
Huidon Group
Transteel
Lewdon
Chivers Welding
S & M Cabinets
Management
Supervision
Sales & Contracts
[NAME]
Websters
Carpets
Television
Fridge
Microwave
Building Leak
HWS
Sliding Door
Urinals
Lockers
Insufficient "as sold" info
Build not "as sold" client spec
Internal Cladding
External Cladding
Doors
Windows
Floors
Toilets
Sinks
Showers
TOTALS
Spreadsheet: 56f2b126-5e0b-49d8-b5e7-0ffb5ac0d51b
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-10-18 09:38:33.480000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.625 | 102.125 | 102 | 101.875 | 101.5
4.5 | 102.031 | 101.906 | 101.781 | 101.406 |  | Note: | Refer To Price [NAME]
4.375 | 101.241 | 101.116 | 100.991 | 100.616 |  |  | For all Price Adjs
4.25 | 100.723 | 100.598 | 100.473 | 99.848
4.125 | 99.955 | 99.83 | 99.705 | 99.08
4 | 98.996 | 98.871 | 98.746 | 98.121
 |  |  |  |  |  | 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
3.875 | 102.125 | 102 | 101.875 | 101.5
3.75 | 102.125 | 102 | 101.875 | 101.5
3.625 | 102.008 | 101.883 | 101.758 | 101.383
3.5 | 101.494 | 101.369 | 101.244 | 100.869
3.375 | 100.741 | 100.616 | 100.491 | 99.866
3.25 | 100.017 | 99.892 | 99.767 | 99.142
3.125 | 99.206 | 99.081 | 98.956 | 98.331 |  | 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-11-01 09:38:33.480000
30 DAY | 2013-11-16 09:38:33.480000
45 DAY | 2013-12-01 09:38:33.480000
60 DAY | 2013-12-16 09:38:33.480000
90 DAY | 2014-01-15 09:38:33.480000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 833200d1686834952-numbering-duplicate-occurrences-of-unique-concatenations-sampleworkbook
Sheet: Sheet1

Current |  |  |  |  | Desired
 | AL | 2023 | SVN |  | AL2023SVN001 | AL | 2023 | SVN
 | AL | 2023 | WVR |  | AL2023WVR001 | AL | 2023 | WVR
 | AL | 2022 | WVR |  | AL2022WVR001 | AL | 2022 | WVR
 | OH | 2023 | WVR |  | OH2023WVR001 | OH | 2023 | WVR
 | AL | 2023 | SVN |  | AL2023SVN002 | AL | 2023 | SVN
 | WI | 2015 | SLI |  | WI2015SLI001 | WI | 2015 | SLI
 | MI | 2015 | SLI |  | MI2015SLI001 | MI | 2015 | SLI
 | KY | 2023 | SVN |  | KY2023SVN001 | KY | 2023 | SVN
 | AL | 2023 | SVN |  | AL2023SVN003 | AL | 2023 | SVN
 | OH | 2023 | WVR |  | OH2023WVR002 | OH | 2023 | WVR
Highlighted values are duplicates. Note the numbering I added in the Desired column to differentiate between each instance of a duplicate.