tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: darrell_schoolcraft__7776__imbalsumm0106
Sheet: by type

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
TRANSWESTERN  PIPELINE -   SUMMARY OF OBA BALANCES
Positive = due [NAME]
Negative = due operator |  |  |  |  |  |  |  |  |  |  |  |  |  | index
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SJ
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | AVG
NNG |  |  |  | Dollar Valued | [NAME] |  |  |  |  |  |  |  |  | NTXPH
[NAME] |  |  |  | Dollar Valued | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
EOG |  |  |  | Dollar Valued | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
CIG |  |  |  | Dollar Valued | [NAME] | being reconciled with CIG
PG&E TX/EPFS |  |  |  | Dollar Valued | [NAME]
Citizens-Griffith |  |  |  | Dollar Valued | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
El Paso Field Services |  |  |  | Dollar Valued | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | ending 5/31/01 bal of $295,327 invoiced
Continental |  |  |  | Dollar Valued | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
Duke/GPM |  |  |  | Dollar Valued | [NAME] | Crawford, Pecos Diamond, [NAME], Linam Ranch, Artesia
North Star Steel |  |  |  | Dollar Valued | [NAME]
Calpine |  |  |  | Dollar Valued | [NAME]
Citizens Communications |  |  |  | Dollar Valued | [NAME]
$ valued totals
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Northwest |  |  |  | Volumetric | [NAME]
Panhandle Eastern |  |  |  | Volumetric | [NAME] | Blanco and Window Rock
SoCal |  |  |  | Volumetric | [NAME]
PG&E Topock |  |  |  | Volumetric | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Lonestar |  |  |  | Volumetric | [NAME]
NGPL |  |  |  | Volumetric | [NAME]
El Paso |  |  |  | Volumetric | [NAME]
[NAME] |  |  |  | Volumetric | [NAME]
volumetric totals
Net $ valued/volumetric
Note -  This report does not represent the total population of imbalances on Transwestern.
Spreadsheet: 866998d1713902435-populate-sheet-with-specific-data-from-a-different-sheet-test-report
Sheet: Data

Sprint | Issue Number | Summary | Points
Sprint 1 | 1 | Work Summary 1 | 1
Sprint 1 | 2 | Work Summary 2 | 1
Sprint 1 | 3 | Work Summary 3 | 2
Sprint 2 | 4 | Work Summary 4 | 2
Sprint 2 | 5 | Work Summary 5 | 3
Sprint 3 | 6 | Work Summary 6 | 1
Sprint 3 | 7 | Work Summary 7 | 3
Sprint 3 | 8 | Work Summary 8 | 2
Sprint 4 | 9 | Work Summary 9 | 1
Sprint 4 | 10 | Work Summary 10 | 2
Spreadsheet: 871687d1718109218-unique-sum-with-multiple-criteria-tests
Sheet: Result

 |  |  |  |  |  |  |  |  |  |  | Column Labels
 |  | Ref New |  | [NAME] |  | Whatsapp Note |  |  |  |  | [NAME] |  | Ref New |  | Whatsapp Note
 |  | Quantity | Value | Quantity | Value | Value |  |  |  | Row Labels | Sum of Quantity | Sum of Value | Sum of Quantity | Sum of Value | Sum of Quantity | Sum of Value
 |  |  |  |  |  |  |  |  |  | Desten & Biber | 88.3 | 38852
 | [NAME] |  |  |  |  |  |  |  |  | Freight |  |  | 7380.15 | 36900.75
 | Scented Adhesive Powder |  |  |  |  |  |  |  |  | [NAME] |  | 4049.5
 | Scented & Adhesive Clay |  |  |  |  |  |  |  |  | [NAME] |  |  | 1320 | 264000
 | [NAME] |  |  |  |  |  |  |  |  | [NAME] |  |  | 8231.35 | 1970774.85
 | Freight |  |  |  |  |  |  |  |  | [NAME] | 30 | 3300
 | [NAME] |  |  |  |  |  |  |  |  | Scented & Adhesive Clay |  |  | 238.3 | 94128.5
 | Desten & Biber |  |  |  |  |  |  |  |  | Scented Adhesive Powder |  |  | 1015.05 | 456717 |  | 12788.76
 | [NAME] |  |  |  |  |  |  |  |  | Scented Polythene Clay |  |  | 619.66 | 189705
 | Grand Total |  |  |  |  |  |  |  |  | Grand Total | 118.3 | 46201.5 | 18804.51 | 3012226.1 |  | 12788.76
Spreadsheet: 153225d1335808721-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: dec 19

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-12-19 00:00:00 | 2011-12-20 00:00:00 | 2011-12-21 00:00:00 | 2011-12-22 00:00:00 | 2011-12-23 00:00:00 | 2011-12-24 00:00:00
[NAME] | off | Christmas | 8:00-5:30 | 8:30-5:30 | 8:30-5:30 | 9:00-3:00
 |  |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | n/l
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-5:00 | Christmas | 8:00-5:00 | off
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 |  | 12:00-1:00
Mark | 8:00-5:00 | 9:00-5:30 | Christmas | 8:00-5:00 | off | 9:00-3:00
 | 1:00-2:00 | 1:00-2:00 |  | 1:00-2:00 |  | n/l
[NAME] | 8:30-5:30 | 8:00-5:00 | off | 7:00-4:00-HOMER | 8:00-5:00 | 9:00-3:00
ctr 12-2 | 11:00-12:00 | 11:00-12:00 |  | 1ub | 11:00-12:00 | n/l
Kat |  |  | 8:00-5:00 |  |  | 9:00-3:00
 |  |  | 12:00-1:00 |  |  | n/l
 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours
Spreadsheet: 33634d1230101512-combine-number-in-one-row-stringconcat
Sheet: Sheet2

File | Screen
US1 | INV1 | US1 | INV1, [NAME], A2, R3, AC
US2 | INV1 | US2 | INV1, D1, R1, R2, A5
US3 | LU1 | US3 | [NAME], LU2, [NAME], A4
US3 | LU2
US1 | A1
US1 | A2
US3 | A3
US2 | D1
US2 | R1
US2 | R2
US1 | R3
US3 | A4 | simply: | INV1,INV1,LU1,LU2,A1,A2,A3,D1,R1,R2,R3,A4,A5,AC
US2 | A5
US1 | AC
Spreadsheet: 31720d1227652978-sumif-date-average-help-sample-data-xx-
Sheet: Sheet1

IMATION CORP R Data
Date | Price
2008-06-02 00:00:00 | 26.03
2008-06-03 00:00:00 | 26.26
2008-06-04 00:00:00 | 26.56
2008-06-05 00:00:00 | 27.12
2008-06-06 00:00:00 | 26.05
2008-06-09 00:00:00 | 25.69
2008-06-10 00:00:00 | 25.82
2008-06-11 00:00:00 | 25.39
2008-06-12 00:00:00 | 25.39
2008-06-13 00:00:00 | 25.61
2008-06-16 00:00:00 | 26.12
2008-06-17 00:00:00 | 25.94
2008-06-18 00:00:00 | 25.83
2008-06-19 00:00:00 | 26.42
2008-06-20 00:00:00 | 26
2008-06-23 00:00:00 | 25.76
2008-06-24 00:00:00 | 25.3
2008-06-25 00:00:00 | 25.58
2008-06-26 00:00:00 | 24.75
2008-06-27 00:00:00 | 24.06
2008-06-30 00:00:00 | 22.92
2008-07-01 00:00:00 | 22.89
2008-07-02 00:00:00 | 22.41
2008-07-03 00:00:00 | 21.06
2008-07-07 00:00:00 | 20.96
2008-07-08 00:00:00 | 21.63
2008-07-09 00:00:00 | 20.36
2008-07-10 00:00:00 | 20.29
2008-07-11 00:00:00 | 20.34
2008-07-14 00:00:00 | 20.12
2008-07-15 00:00:00 | 20.24
2008-07-16 00:00:00 | 21.08
2008-07-17 00:00:00 | 21.53
2008-07-18 00:00:00 | 21.52
2008-07-21 00:00:00 | 22.18
2008-07-22 00:00:00 | 21
2008-07-23 00:00:00 | 19.84
2008-07-24 00:00:00 | 19.32
2008-07-25 00:00:00 | 19.25
2008-07-28 00:00:00 | 18.86
2008-07-29 00:00:00 | 19
2008-07-30 00:00:00 | 19.42
2008-07-31 00:00:00 | 19.06
2008-08-01 00:00:00 | 18.67
2008-08-04 00:00:00 | 18.76
2008-08-05 00:00:00 | 19.32
2008-08-06 00:00:00 | 19.78
2008-08-07 00:00:00 | 19.76
2008-08-08 00:00:00 | 20.47
2008-08-11 00:00:00 | 20.68
2008-08-12 00:00:00 | 20.91
2008-08-13 00:00:00 | 21.28
2008-08-14 00:00:00 | 21.66
2008-08-15 00:00:00 | 21.93
2008-08-18 00:00:00 | 20.55
2008-08-19 00:00:00 | 20.81
2008-08-20 00:00:00 | 20.39
2008-08-21 00:00:00 | 19.98
2008-08-22 00:00:00 | 20.54
2008-08-25 00:00:00 | 20.84
2008-08-26 00:00:00 | 21.18
2008-08-27 00:00:00 | 21.53
2008-08-28 00:00:00 | 21.46
2008-08-29 00:00:00 | 21.24
2008-09-02 00:00:00 | 21.19
2008-09-03 00:00:00 | 21.53
2008-09-04 00:00:00 | 21.49
2008-09-05 00:00:00 | 21.29
2008-09-08 00:00:00 | 22.35
2008-09-09 00:00:00 | 22.1
2008-09-10 00:00:00 | 22.5
2008-09-11 00:00:00 | 21.82
2008-09-12 00:00:00 | 22.02
2008-09-15 00:00:00 | 21.11
2008-09-16 00:00:00 | 22.34
2008-09-17 00:00:00 | 21.51
2008-09-18 00:00:00 | 22.75
2008-09-19 00:00:00 | 23.82
2008-09-22 00:00:00 | 22.94
2008-09-23 00:00:00 | 22.36
2008-09-24 00:00:00 | 22.44
2008-09-25 00:00:00 | 22.87
2008-09-26 00:00:00 | 23.25
2008-09-29 00:00:00 | 21.97
2008-09-30 00:00:00 | 22.59
2008-10-01 00:00:00 | 22.63
2008-10-02 00:00:00 | 22.04
2008-10-03 00:00:00 | 20.75
2008-10-06 00:00:00 | 19.75
2008-10-07 00:00:00 | 18.96
2008-10-08 00:00:00 | 17.73
2008-10-09 00:00:00 | 16.71
2008-10-10 00:00:00 | 12.36
2008-10-13 00:00:00 | 15.32
2008-10-14 00:00:00 | 14.06
2008-10-15 00:00:00 | 13.05
2008-10-16 00:00:00 | 13.67
2008-10-17 00:00:00 | 13.54
2008-10-20 00:00:00 | 13.51
2008-10-21 00:00:00 | 12.66
2008-10-22 00:00:00 | 11.73
2008-10-23 00:00:00 | 11.68
2008-10-24 00:00:00 | 11.66
2008-10-27 00:00:00 | 11.35
2008-10-28 00:00:00 | 12.25
2008-10-29 00:00:00 | 11.85
2008-10-30 00:00:00 | 12.13
2008-10-31 00:00:00 | 12.32
Spreadsheet: andy_zipper__744__10_29_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] |  |  |  | 47.8 | 87.8 | 2.56 | 2001-10-25 14:56:00
 | [NAME] | 58 | 550 | 630 | 42.3 | 48.4 | 1.65 | 2001-10-29 14:33:00
 | HU F2 | 59 | 840 | 925 | 45.1 | 49.7 | 1.76 | 2001-10-29 14:33:00
 | HU G2 | 60 | 1040 | 1125 | 44 | 47.6 | 1.73 | 2001-10-29 14:33:00
 | [NAME] | 62 | 1150 | 1250 | 41.3 | 44.9 | 1.68 | 2001-10-29 14:33:00
 | [NAME] | 68 | 1330 | 1460 | 39.3 | 43.2 | 1.76 | 2001-10-29 14:33:00
 | [NAME] | 68 | 1450 | 1575 | 39.1 | 42.5 | 1.74 | 2001-10-29 14:33:00
 | [NAME] | 68 | 1525 | 1650 | 38 | 41.1 | 1.69 | 2001-10-29 14:33:00
 | HU N2 | 68 | 1540 | 1680 | 36.2 | 39.5 | 1.62 | 2001-10-29 14:33:00
 | [NAME] | 67 | 1600 | 1750 | 36 | 39.4 | 1.59 | 2001-10-29 14:33:00
 | HU U2 |  |  |  | 32.2 | 36.6 | 1.43 | 2001-10-22 14:23:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 67875d1268394592-help-in-counting-records-in-using-lookup-sample2
Sheet: Sample lookup

 |  | Number of Academics |  |  |  |  | Number of Universities |  |  |  | Number of Departments
 | Name | No. of Records |  |  | No. of Departments verified | No. of Subjects taught | Name | with Address | with Telephone Number | with Website Address | with [NAME] | with Address | with Telephone
 |  | with [NAME] | with Title | with email address
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Total |  | 0 | 0 | 113 | 6387 | 8 | 45 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 266680d1379696096-formula-to-alphabetize-names-when-ties-occur-rankalpabetontie
Sheet: Sheet1

First Name | Last Name | Invoice # | PO # | County | Price
[NAME] | Ford | 1 | 101 | [NAME] | 132
[NAME] | Lincoln | 2 | 102 | Lake | 25
[NAME] | Stern | 3 | 103 | [NAME] | 27
[NAME] | Beam | 4 | 104 | Geneva | 78
Rosetta | Stone | 5 | 105 | Marion | 89
Data | Price
Rosetta
Geneva
1
103
Ford
Spreadsheet: e2e94d71-544a-4297-ab9c-eebf94b2b1a1
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
ELLINGSEN TRANSPORT OG UTLEIE |  | 4515 | Mandal
[NAME] |  | 4519 | Holum
HOLUM TRANSPORT AS |  | 4519 | Holum
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 803239d1667323928-colour-coding-based-on-grade-and-importance-excel-issue-1-
Sheet: Sheet1

 |  |  |  |  |  | Importance | GRADE | Total
 |  |  |  |  |  | 1 | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 | Name |  |  |  |  |  | 4
 | Grade | Importance | Supplier Assessment |  |  |  | 5
Criteria
Due Diligence |  |  |  |  |  | Importance | GRADE | Total |  |  | Importance | Grade
Test | 3 | 1 |  |  |  | 2 | 1 |  |  |  | 1 | 1
Test | 2 | 2 |  |  |  |  | 2 |  |  |  | 2 | 2
Test | 4 | 1 |  |  |  |  | 3 |  |  |  | 3 | 3
Test | 4 | 4 |  |  |  |  | 4 |  |  |  | 4 | 4
Test | 3 | 3 |  |  |  |  | 5 |  |  |  |  | 5
Test | 4 | 2 |  |  |  | `
Test | 5 | 1
 |  |  |  |  |  | Importance | GRADE | Total
 |  |  |  |  |  | 3 | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
 |  |  |  |  |  | Importance | GRADE | Total
 |  |  |  |  |  | 4 | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
 |  |  |  |  |  |  | 5
Spreadsheet: 52169d1251879588-rearrange-data-supplied-by-others-customer2
Sheet: instructions

The raw data I have been supplied is on sheet titled raw data
I require the VBA to provide a "output "tab with the titles as shown, to match my table layout.
What I need to do is, rearrange the data to fit the titles I have already for the output table. As indicated by the arrows below
The raw data "address" field needs to be split in to address 1, address 2, ect, will it be possible to put the post code within the raw data address column into the postcode column on the output tab.
 | raw data table
branchname | branchemail | groups | division | region | address | tel | fax | prefix | loyalty
 | output table
Customer Business Name | Address 1 | Address 2 | Address 3 | Address 4 | County | Post Code | [NAME]. | Fax No. | [NAME]
I have transferred the data manually for the 1st line from raw data to output, to show the lay out I require
Thanks for your time spent on this for me.
Spreadsheet: 50824d1250314843-keeping-track-of-payments-test
Sheet: Labour

Price's
Plot/Type | [NAME] | Removal of | Joists 1st | Roof | Low Level | 1st Fix | External | 2nd Fix | Final
 |  | Joists | floor |  | Levels |  | doors
 |  | 130 | 470 | 200 | 340 |  | 130 | 830
 | 170 |  | 360 | 200 | 80 | 920 | 130 | 870 | 200
 |  | 130 |  | 1220 | 570 | 740 | 130 | 700 | 150
 |  |  |  | 7
Spreadsheet: 85722d1285771777-excel-2007-excel-2007-problem-with-cell-formulas-cash20102011
Sheet: Reconciliations

Nat West |  |  | Sept |  |  | Oct |  |  | Nov |  |  | Dec |  |  | Jan |  |  | Feb |  |  | March |  |  | Apr |  |  | May |  |  | Jun |  |  | July |  |  | Aug
Balance b/f |  |  | -344.84
Income
Exps
Balance per cash book
O/s Cheqs
O/s credits
Balnce per Bank
Bank Balances | 2010-09-01 00:00:00 | Sept | Oct | Nov | Dec | Jan | Feb | March | Apr | May | June | July | Aug
Nat West
CFB | 50188.23
TMCP | 74208.3
Reserves
Society | 29778.85
Legacy | 48820.46
Earmarked | 25840.96
Family Worker | 18501.42
Special Appeals | 1000
Benevolent | 100
Special Collections | 10
Spreadsheet: 50578d1250050090-worksheet-function-to-extract-numbers-example-dataset
Sheet: Sheet1

 |  | Original format |  |  |  |  |  |  |  | New format
 |  | 9 | 8 | 7 | 10 | 17 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  | 1 | 2 | 3 | 11 | 18
 |  | 6 | 5 | 4 | 12 | 19
 |  | 16 | 15 | 14 | 13 | 20
Spreadsheet: 773695d1648013139-lookup-value-for-similar-cells-sample-sheet
Sheet: Sheet1

Names+Strength+Code | Names | Strength | Code | Value |  | Names+Strength+Code | Value | Comments
ABC12250ZA | ABC | 12250 | ZA | 10729 |  | ABC13000ZB
ABC13000ZA | ABC | 13000 | ZA | 10134 |  | [NAME]
ABC14500ZB | ABC | 14500 | ZB | 13040 |  | BAC555ZA |  | Should pick up the nearest Strength's Value | BAC550ZA
ABC13000ZB | ABC | 13000 | ZB | 14641 |  | BAC625ZB
[NAME] | ABC | 12250 | ZB | 14237 |  | BAC625ZA
ABC13750ZA | ABC | 13750 | ZA | 14892 |  | CAB60ZB |  | Should pick up the nearest Strength's Value | CAB58ZB
BAC550ZB | BAC | 550 | ZB | 568 |  | ACB725ZA |  | Should pick up the nearest Strength's Value | ACB750ZA
BAC550ZA | BAC | 550 | ZA | 770 |  | BCA700ZA
BAC575ZB | BAC | 575 | ZB | 768 |  | BCA613ZB
BAC575ZA | BAC | 575 | ZA | 609 |  | BCA620ZA |  | Should pick up the nearest Strength's Value | BCA625ZA
BAC625ZB | BAC | 625 | ZB | 773
BAC625ZA | BAC | 625 | ZA | 537
BAC750ZB | BAC | 750 | ZB | 781
BAC750ZA | BAC | 750 | ZA | 571
CAB55ZA | CAB | 55 | ZA | 55
CAB58ZB | CAB | 58 | ZB | 75
CAB60ZA | CAB | 60 | ZA | 50
CAB58ZA | CAB | 58 | ZA | 61
ACB750ZA | ACB | 750 | ZA | 728
ACB750ZB | ACB | 750 | ZB | 661
BCA625ZA | BCA | 625 | ZA | 656
BCA625ZB | BCA | 625 | ZB | 704
BCA700ZA | BCA | 700 | ZA | 755
BCA700ZB | BCA | 700 | ZB | 733
BCA766ZB | BCA | 766 | ZB | 732
BCA766ZA | BCA | 766 | ZA | 664
BCA613ZB | BCA | 613 | ZB | 739
BCA613ZA | BCA | 613 | ZA | 742
BCA741ZB | BCA | 741 | ZB | 774
BCA741ZA | BCA | 741 | ZA | 633
Spreadsheet: 146323d1332098673-vlookup-with-multiple-qty-discount-breaks-price-file
Sheet: Sheet3

QTY | 0
Part# | 1
[NAME]
Price
Part# | Description | 0 | 26 | 100 | 200 | 500
1 | Sony TV | 500 | 500 | 480 | 460 | 460
2 | Samsung TV | 600 | 600 | 580 | 560 | 560
3 | LG TV | 700 | 700 | 680 | 660 | 660
4 | [NAME] | 80 | 70 | 60 | 60 | 50
5 | [NAME] | 90 | 80 | 70 | 70 | 60
6 | [NAME] | 100 | 90 | 80 | 80 | 70
Spreadsheet: 769132d1645338939-index-match-solution-required-for-multiple-criteria-with-merged-cell-index-match-for-merged-cell-aligw
Sheet: Summary

Device | Working Ratio | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 | 2022-02-05 00:00:00
Water Meter | [NAME] | 100 | 100 | 100 | 100 | 100
Water Meter | Consumption Ratio | 96 | 0 | 0 | 90 | 80.4
 |  |  |  |  |  |  |  |  |  | Required Result
 |  |  |  |  |  |  |  |  |  | 2022-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  | Consumption Ratio
 |  |  |  |  |  |  |  |  | Water Meter
Spreadsheet: 702193d1604152477-nested-if-has-currently-45-sub-components-want-to-streamline-the-formula-process-long-nested-if-with-2-and-criteria
Sheet: AlternativeSolution

2 | Hull Type | 1 | 2 | 3 | 4 | 5 | 6 |  | 2 | DB | 1 | 2 | 3 | 4 | 5 | 6
 | CVN |  |  |  |  |  |  |  |  | SRB
 | CG |  |  |  |  |  |  |  |  | DV
 | DDG |  |  |  |  |  |  |  |  | DUI
[NAME] |  | 1 | 2 | 3 | 4 | 5 | 6 |  | DBs |  | 1 | 2 | 3 | 4 | 5 | 6
1 | CVN | 10000 | 10300 | 10600 | 10900 | 11200 | 11500 |  | 1 | SRB | 121 | 138 | 132 | 186 | 199 | 195
2 | CG | 20000 | 20300 | 20600 | 20900 | 21200 | 21500 |  | 2 | DV | 105 | 183 | 135 | 192 | 149 | 118
3 | DDG | 30000 | 30300 | 30600 | 30900 | 31200 | 31500 |  | 3 | DUI | 125 | 167 | 141 | 147 | 129 | 137
1 | CVN | 10100 | 10400 | 10700 | 11000 | 11300 | 11600 |  | 1 | SRB | 228 | 218 | 222 | 240 | 292 | 238
2 | CG | 20100 | 20400 | 20700 | 21000 | 21300 | 21600 |  | 2 | DV | 269 | 262 | 280 | 222 | 222 | 224
3 | DDG | 30100 | 30400 | 30700 | 31000 | 31300 | 31600 |  | 3 | DUI | 288 | 286 | 297 | 244 | 216 | 286
1 | CVN | 10200 | 10500 | 10800 | 11100 | 11400 | 11700 |  | 1 | SRB | 318 | 388 | 364 | 368 | 399 | 347
2 | CG | 20200 | 20500 | 20800 | 21100 | 21400 | 21700 |  | 2 | DV | 373 | 323 | 364 | 302 | 387 | 371
3 | DDG | 30200 | 30500 | 30800 | 31100 | 31400 | 31700 |  | 3 | DUI | 305 | 308 | 376 | 331 | 303 | 319
Spreadsheet: 41250d1239739584-updating-dates-on-separate-tabs-based-on-date-in-first-tab-form-booking-sheets-all-1
Sheet: T30

Boeing Tour - AM |  |  |  |  | 2009-06-06 00:00:00
 | Driver: |  |  |  | Vehicle: |  |  |  |  |  | Prepaid
P/U Time | Booked by |  | Hotel |  | Party | A | C | CT | MF | Amt | CC | Ck | Collect | [NAME]
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
Daily Total:
Pricing
Retail: | Adult | 55 | Child | 45 | Reseller: | Adult |  | 44 | Child |  | 36
Resellers: Alcatraz Media, [NAME], Look Tours, Sightseeing World, TourCorp
Driver Pickup Summary
Spreadsheet: 869470d1716030903-vllook-up-or-a-similar-function-to-look-up-a-date-range-sample-3-1-
Sheet: Sheet1

 |  |  |  |  |  | 2024-05-20 00:00:00
 |  | Billing Amount | Start date | Billing Interval | Payment due after billing
 | A | 15000 | 2024-04-22 00:00:00 | 28 | 7
 | B | 75000 | 2024-04-30 00:00:00 | 28 | 35
 | C | 12500 | 2024-04-22 00:00:00 | 28 | 35
 | D | 7000 | 2024-04-22 00:00:00 | 28 | 35
 | E | 75000 | 2024-04-22 00:00:00 | 28 | 21
 | F | 12500 | 2024-04-22 00:00:00 | 28 | 21
 | G | 7000 | 2024-04-22 00:00:00 | 28 | 21
 | H | 12000 | 2024-04-22 00:00:00 | 28 | 21
 | I | 12500 | 2024-04-22 00:00:00 | 28 | 35
 | J | 13000 | 2024-05-10 00:00:00 | 28 | 14
 |  | Check row J
 |  | Check Row F
Spreadsheet: 851367d1701590566-filter-function-with-dynamically-changing-data-column-based-on-value-in-another-field-filter-calling-dynamic-data-column-aligw
Sheet: Data Validation

Nationality |  | Events
Australia |  | Event 1
Austria |  | Event 2
Belgium |  | Event 3
Brazil |  | Event 4
Chile
China
Colombia
Costa Rica
France
Germany
India
Indonesia
Ireland
Italy
Mexico
Netherlands
New Zealand
Nigeria
Pakistan
Peru
Philippines
Russian Federation
South Africa
South Korea
Sweden
Turkey
Ukraine
United Kingdom
United States
Vietnam
Spreadsheet: 136060d1326390116-avergeif-statement-satisfaction-surveys-q1-2012
Sheet: Inman Summary Central

CENTRAL DIVISION
INMAN | [NAME]
Pharmacy | Survey #'s | Average
Denman
Home Pharm Services
[NAME]
Interlock Columbia
Interlock Florissant
Managed Healthcare
Medicate Farmington
NCS Herin
[NAME]
OCR Minnesota
OCR Nebraska
OCR Pharmacy Midwest
[NAME]
OCR Urbandale
Pharm Care Assoc
[NAME]
[NAME]
REGION TOTAL
 | Denman | Home Pharm Services | [NAME] | Interlock Columbia | Interlock Florissant | Managed Healthcare | Medicate Farmington | NCS Herin | [NAME] | OCR Minnesota | OCR Nebraska | OCR Pharmacy Midwest | [NAME] | OCR Urbandale | Pharm Care Assoc | [NAME] | [NAME] | REGION AVE.
Pharmacy Average
Ease of ordering (e.g. fax, phone) process
Medication accuracy (i.e. Right Drug/Right Patient)
Routine scheduled deliveries are on time
Stats are delivered within an appropriate timeframe
Medical Records are accurate
Medical Records are received by the agreed upon date
Pharmacy billing statements are accurate
Overall rating of the pharmacy's ability to meet your needs
Expertise of infusion (IV) services personnel
Expertise of consultant pharmacist
Expertise of other pharmacy services (ie: nursing, QA tech, customer service)
Staff education
Drug information provided by Pharmacists is useful
Assistance in resolving facility or patient concerns
Timely response to facility or patient concerns
Understanding of facility or patient concerns
Courtesy of pharmacy staff
Clear explanation and timely communication about medications that are not available for your order
Overall rating of the pharmacy's ability to meet your expectations
Recommendation "Yes"
Recommendation  "No"
Recommendation "na"
Total