tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 105524d1302840185-combining-multiple-cells-into-one-not-your-regular-concatenate-copy-of-example-1-pivot
Sheet: Sheet1

[NAME] of master report spreadsheet
Customer | Invoice Number | Date | Total
Client A | 1 | 1970-05-13 00:00:00 | 16
Client A | 2 | 1970-05-14 00:00:00 | 10
Client A | 3 | 1970-05-15 00:00:00 | 13
Client A | 4 | 1970-05-16 00:00:00 | 28
Client A | 5 | 1970-05-17 00:00:00 | 30
Client A | 6 | 1970-05-18 00:00:00 | 50
Client A | 7 | 1970-05-19 00:00:00 | 64
Client B | 8 | 1970-05-20 00:00:00 | 70
Client B | 9 | 1970-05-21 00:00:00 | 85
Client B | 10 | 1970-05-22 00:00:00 | 90
Client B | 11 | 1970-05-23 00:00:00 | 108
Client C | 12 | 1970-05-24 00:00:00 | 110
Client C | 13 | 1970-05-25 00:00:00 | 130
Client C | 14 | 1970-05-26 00:00:00 | 133
Client C | 15 | 1970-05-27 00:00:00 | 150
Client C | 16 | 1970-05-28 00:00:00 | 160
Client C | 17 | 1970-05-29 00:00:00 | 170
Client C | 18 | 1970-05-30 00:00:00 | 189
Client C | 19 | 1970-05-31 00:00:00 | 190
Client C | 20 | 1970-06-01 00:00:00 | 210
Client D | 21 | 1970-06-02 00:00:00 | 220
Client D | 22 | 1970-06-03 00:00:00 | 230
Client D | 23 | 1970-06-04 00:00:00 | 253
Client D | 24 | 1970-06-05 00:00:00 | 288
Client D | 25 | 1970-06-06 00:00:00 | 325
Client D | 26 | 1970-06-07 00:00:00 | 364
Now - To avoid formatting issues when sending details of the outstanding invoices in the mail merge through word, I must now consolidate the above information into a single row per customer:
**Statement spreadsheet for merge **
Client A | 0001 0002 0003 0004 0005 0006 0007 | 16.00          10.00          13.00          28.00          30.00          50.00          64.00 | To include date of each invoice
Client B | 0008 0009 0010 0011 | 70.00          85.00          90.00       108.00 | To include date of each invoice
Client C | 0013 0014 0015 0016 0017 0018 0019 0020 | 110.00       130.00       133.00       150.00       160.00       170.00       189.00       190.00       210.00 | To include date of each invoice
Client D | 0021 0022 0023 0024 0025 0026 | 220.00       230.00       253.00       288.00       325.00       364.00 | To include date of each invoice
This enables me to send out the statement and keep the formatting, i.e. invoice number sits on the same line as corresponding amount and corresponding invoice date.
As you can imagine I have around 450 customers to contact each month and this can take all day.
Ideally I would like to enter a formula in the summary spreadsheet that will pick up the data from the master report and put it all into the summary sheet in the format above.
is this possible?
Spreadsheet: 688583d1595859373-need-to-calculate-max-in-range-with-2-criteria-and-return-the-result-of-a-different-column-2020-07-27-oeldere-gamenano-688579d1595858193-need-to-calculate-max-in-range-with-2-criteria-
Sheet: Data

Date | Mileage | Description | Cost | Code | Reg | criteria
2020-01-01 00:00:00 | 55000 | 42.3 | 45.684 | FUE | AB12CDE
2020-01-02 00:00:00 | 55015 | Parts ABC | 33.5 | PAR | AB12CDE
2020-01-03 00:00:00 | 55217 | Parts DEF | 168.7 | PAR | AB12CDE |  | Needed a formula base on the following criteria
2020-01-04 00:00:00 | 24380 | 22.3 | 24.084 | FUE | XY98XYZ |  | and return the description of the highest mileage FUE code within range
2020-01-05 00:00:00 | 55220 | Parts DEF | 55 | PAR | AB12CDE
2020-01-06 00:00:00 | 55224 | 18.8 | 20.304 | FUE | AB12CDE |  | Reg: | AB12CDE | <- User input
2020-01-07 00:00:00 | 24390 | 40 | 43.2 | FUE | XY98XYZ |  | from: | 2020-01-10 00:00:00 | <- User input
2020-01-08 00:00:00 | 54280 | 55.3 | 59.724 | FUE | AB12CDE |  | to: | 2020-01-16 00:00:00 | <- User input
2020-01-09 00:00:00 | 24387 | Parts DEF | 18 | PAR | XY98XYZ
2020-01-10 00:00:00 | 24400 | 42 | 45.36 | FUE | XY98XYZ |  | Result should be
2020-01-11 00:00:00 | 24400 | Parts DEF | 27.5 | PAR | XY98XYZ
2020-01-12 00:00:00 | 24429 | 21.2 | 22.896 | FUE | XY98XYZ
2020-01-13 00:00:00 | 54320 | Parts DEF | 158.2 | PAR | AB12CDE
2020-01-14 00:00:00 | 54320 | Parts DEF | 155.89 | PAR | AB12CDE
2020-01-15 00:00:00 | 54380 | 30.1 | 32.508 | FUE | AB12CDE
2020-01-16 00:00:00 | 24720 | 28.5 | 30.78 | FUE | XY98XYZ
2020-01-17 00:00:00 | 24720 | Parts DEF | 85.34 | PAR | XY98XYZ
2020-01-18 00:00:00 | 54490 | 18.9 | 20.412 | FUE | AB12CDE
2020-01-19 00:00:00 | 54520 | 42.5 | 45.90000000000001 | FUE | AB12CDE
2020-01-20 00:00:00 | 54660 | 52.1 | 56.26800000000001 | FUE | AB12CDE
2020-01-21 00:00:00 | 24800 | Parts DEF | 84.2 | PAR | XY98XYZ
2020-01-22 00:00:00 | 24925 | 12.4 | 13.392 | FUE | XY98XYZ
2020-01-23 00:00:00 | 54700 | 17.8 | 19.224 | FUE | AB12CDE
2020-01-24 00:00:00 | 54900 | 19.2 | 20.736 | FUE | AB12CDE
2020-01-25 00:00:00 | 24980 | Parts DEF | 125 | PAR | XY98XYZ
2020-01-26 00:00:00 | 54980 | 22.3 | 24.084 | FUE | AB12CDE
2020-01-27 00:00:00 | 54985 | Parts DEF | 22.2 | PAR | AB12CDE
I am working on a vehicle cost spreadsheet and wanted to find the last fuel purchase within a certain date range and return column C which shows how many liter purchased.
I | am | able | to | find | the | highest | mileage | but | not | sure | how | to | show | column | C | instead | of | the | mileage | column. | I | attached | sample | data. | Many | thanks | for | your | help.
Spreadsheet: 605625d1547187107-match-item-with-invoice-and-replace-any-missing-item-auto-masterfile18-19-11
Sheet: Sheet1

Invoice DATA |  |  |  |  | Main DATA
Item + Invoice | Item | Inv# | Qty |  | Item + Invoice | Item | Inv# | Qty
0010055MD-500DM27 | MD-500DM27 | 0010055 | 1 |  | 0010055MD-500DM27 | 0010055 | MD-500DM2700 | 1
0010055MD-505DA18 | MD-505DA18 | 0010055 | 1 |  | 0010055MD-505DA18 | 0010055 | MD-505DA1800 | 1
0010055MD-505DA22 | MD-505DA22 | 0010055 | 1 |  | 0010055MD-505DA22 | 0010055 | MD-505DA2200 | 1
0010055MD-ENSP27518 | MD-ENSP27518 | 0010055 | 1 |  | 0010055MD-ENSP27518 | 0010055 | MD-ENSP27518 | 1
0010055MD-ONYX25015 | MD-ONYX25015 | 0010055 | 1 |  | 0010055MD-IHP055150 | 0010055 | MD-IHP055150 | 1
0010055MD-ONYX25026 | MD-ONYX25026 | 0010055 | 1 |  | 0010055MD-ONYX25015 | 0010055 | MD-ONYX25015 | 1
0010055MD-ONYX27518 | MD-ONYX27518 | 0010055 | 1 |  | 0010055MD-ONYX25026 | 0010055 | MD-ONYX25026 | 1
0010055MD-ONYX30012 | MD-ONYX30012 | 0010055 | 1 |  | 0010055MD-ONYX27518 | 0010055 | MD-ONYX27518 | 1
0010055MD-ONYX30022 | MD-ONYX30022 | 0010055 | 1 |  | 0010055MD-ONYX30012 | 0010055 | MD-ONYX30012 | 1
0010055MD-ONYX30026 | MD-ONYX30026 | 0010055 | 1 |  | 0010055MD-ONYX30022 | 0010055 | MD-ONYX30022 | 1
0010055MD-ONYX30030 | MD-ONYX30030 | 0010055 | 1 |  | 0010055MD-ONYX30026 | 0010055 | MD-ONYX30026 | 1
0010055MD-ONYX35026 | MD-ONYX35026 | 0010055 | 1 |  | 0010055MD-ONYX30030 | 0010055 | MD-ONYX30030 | 1
0010055MD-ONYX35030 | MD-ONYX35030 | 0010055 | 1 |  | 0010055MD-ONYX35026 | 0010055 | MD-ONYX35026 | 1
0010055MD-ONYX35038 | MD-ONYX35038 | 0010055 | 1 |  | 0010055MD-ONYX35030 | 0010055 | MD-ONYX35030 | 1
0010055MD-RINT30030 | MD-RINT30030 | 0010055 | 1 |  | 0010055MD-ONYX35038 | 0010055 | MD-ONYX35038 | 1
0010055MD-RINT30038 | MD-RINT30038 | 0010055 | 1 |  | 0010055MD-RINT30030 | 0010055 | MD-RINT30030 | 1
0010055MD-SESRO1 | MD-SESRO1 | 0010055 | 1 |  | 0010055MD-RINT30038 | 0010055 | MD-RINT30038 | 1
0010055MD-SPL15015X | MD-SPL15015X | 0010055 | 1 |  | 0010055MD-SPL15015X | 0010055 | MD-SPL15015X | 1
0010055MD-SPL20020X | MD-SPL20020X | 0010055 | 1 |  | 0010055MD-SPL20020X | 0010055 | MD-SPL20020X | 1
Spreadsheet: 779742d1652080816-index-match-with-multiple-criteria-blanks-and-drop-down-lists-index-match-multiple-criteria
Sheet: Sheet2

Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total | Total
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 7 & Column 8 | Column 7 & Column 9 | Column 7 & Column 10 | Column 7 & Column 11 | Column 7 & Column 12 | Column 7 & Column 13 | Column 7 & Column 14 | Column 8 | Column 8 & Column 9 | Column 8 & Column 10 | Column 8 & Column 11 | Column 8 & Column 12 | Column 8 & Column 13 | Column 8 & Column 14 | Column 9 | Column 9 & Column 10 | Column 9 & Column 11 | Column 9 & Column 12 | Column 9 & Column 13 | Column 9 & Column 14 | Column 10 | Column 10 & Column 11 | Column 10 & Column 12 | Column 10 & Column 13 | Column 10 & Column 14 | Column 11 | Column 11 & Column 12 | Column 11 & Column 13 | Column 11 & Column 14 | Column 12 | Column 12 & Column 13 | Column 12 & Column 14 | Column 13 | Column 13 & Column 14 | Column 14
Spreadsheet: 542881d1508155799-auto-populate-the-nth-large-value-testdata-set
Sheet: Control

Department |  | Company
PRO |  | FCE2
IT |  | [NAME]
FB |  | LIN
LIN |  | FCE1
FIN |  | FOO
OPE |  | All
CEN
MAN
HUM
FOO
SUP
REG
ENG
HEA
QUA
LEG
ALL
Spreadsheet: 65469d1266188555-pivot-percentage-of-subtotal-and-total-budget
Sheet: REPORT

Sum of AMOUNT |  |  |  |  | Sum of AMOUNT |  |  |  |  | Sum of AMOUNT
[NAME] | DATE | Total | % of Total |  | [NAME] | DATE | Total |  |  | [NAME] | DATE | Total
INCOMEA | 2010-01-05 00:00:00 | 1500 | % of subtotal |  | CABLE | 2010-01-20 00:00:00 | 33 |  |  | CLEANERS | 2010-01-26 00:00:00 | 23
 | 2010-01-10 00:00:00 | 1400 | % of subtotal |  | CABLE Total |  | 33 |  |  |  | 2010-02-20 00:00:00 | 25
 | 2010-02-05 00:00:00 | 1400 | % of subtotal |  | ELECTRIC | 2010-01-14 00:00:00 | 114 |  |  | CLEANERS Total |  | 48
INCOMEA Total |  | 4300 | % of Total |  |  | 2010-02-13 00:00:00 | 115 |  |  | FASTFOOD | 2010-01-05 00:00:00 | 7
INCOMEB | 2010-01-17 00:00:00 | 800 | % of subtotal |  | ELECTRIC Total |  | 229 |  |  |  | 2010-01-07 00:00:00 | 15
 | 2010-02-11 00:00:00 | 1500 | % of subtotal |  | GAS | 2010-02-16 00:00:00 | 57 |  |  | FASTFOOD Total |  | 22
 | 2010-02-15 00:00:00 | 700 | % of subtotal |  |  | 2010-02-21 00:00:00 | 30 |  |  | FUEL | 2010-02-14 00:00:00 | 8
INCOMEB Total |  | 3000 | % of Total |  | GAS Total |  | 87 |  |  |  | 2010-02-17 00:00:00 | 20
INCOMEC | 2010-01-25 00:00:00 | 450 | % of subtotal |  | WATER | 2010-01-15 00:00:00 | 50 |  |  | FUEL Total |  | 28
 | 2010-02-22 00:00:00 | 350 | % of subtotal |  |  | 2010-01-17 00:00:00 | 58 |  |  | GROCERY | 2010-01-02 00:00:00 | 100
INCOMEC Total |  | 800 | % of Total |  |  | 2010-02-14 00:00:00 | 60 |  |  |  | 2010-02-13 00:00:00 | 115
Grand Total |  | 8100 |  |  | WATER Total |  | 168 |  |  | GROCERY Total |  | 215
 |  |  |  |  | Grand Total |  | 517 |  |  | Grand Total |  | 313
 |  |  | Please list steps for showing % of subtotal and % of Total
Spreadsheet: 784344d1655654654-calculate-returns-with-varied-p-l-and-irregular-deposits-withdraws-calculate-returns-with-varied-pl-and-irregular-deposits-and-withdraws
Sheet: Sheet1

Example #1
Date | Beginning  Balance | Deposits/ Withdraws | P/L |  | Ending  Balance |  |  | January |  |  | February |  |  | March |  |  | Entire Year
2022-01-01 00:00:00 | 100000 |  | 500 |  |  |  |  | P/L |  |  | P/L |  |  | P/L |  |  | P/L
2022-01-05 00:00:00 |  |  | 475 |  |  |  |  | Return |  |  | Return |  |  | Return |  |  | Return
2022-01-12 00:00:00 |  |  | 618
2022-01-15 00:00:00 |  |  | -240
2022-01-18 00:00:00 |  |  | 340
2022-01-20 00:00:00 |  |  | 745
2022-01-24 00:00:00 |  |  | -445
2022-01-30 00:00:00 |  |  | 687
2022-02-04 00:00:00 |  |  | 522
2022-02-08 00:00:00 |  |  | 487
2022-02-10 00:00:00 |  |  | 896
2022-02-13 00:00:00 |  |  | -403
2022-02-20 00:00:00 |  |  | 551
2022-02-22 00:00:00 |  |  | 478
2022-02-27 00:00:00 |  |  | 654
2022-03-02 00:00:00 |  |  | 612
2022-03-06 00:00:00 |  |  | -358
2022-03-09 00:00:00 |  |  | 458
2022-03-12 00:00:00 |  |  | 745
2022-03-17 00:00:00 |  |  | 564
2022-03-20 00:00:00 |  |  | -658
2022-03-25 00:00:00 |  |  | 857
2022-03-26 00:00:00 |  |  | 748
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: BU53 KNV

 |  |  |  |  | BU53 [NAME]
Registration number : | BU53 [NAME] |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | VOLVO |  | 2003-11-10 00:00:00 | 12 Months + 3 Weeks | 2004-12-01 00:00:00 | 717
Specification : | 6 x 2 RCT (2 Axle) |  | 2004-11-30 00:00:00 | 12 Months | 2005-12-01 00:00:00 | 650
Type : | FM9 |  | 2005-11-30 00:00:00 | 12 Months | 2006-12-01 00:00:00 | 650
1st Registered : | 10.11.03 |  | 2006-11-30 00:00:00 | 12 Months | 2007-12-01 00:00:00 | 650
Engine : | [NAME] |  | 2007-11-30 00:00:00 | 12 Months | 2008-12-01 00:00:00 | 650
[NAME] : | 26,000kg |  | 2008-11-30 00:00:00 | 12 Months | 2009-12-01 00:00:00 | 650
 |  |  | 2009-11-30 00:00:00 | 12 Months | 2010-12-01 00:00:00 | 650
 |  |  | 2010-11-30 00:00:00 | 12 Months | 2011-12-01 00:00:00 | 650
 |  |  | 2011-11-30 00:00:00 | 12 Months | 2012-12-01 00:00:00 | 650
Back To Index
Spreadsheet: 4257e2d1-a5d6-4d43-9351-56dc556a9d5b
Sheet: Sheet1

MONTH END FINANCIAL REPORTING DATES | Unnamed: 1 | Unnamed: 2
FOR FISCAL YEAR 2014
The dates below indicate when month end financial reporting is expected to be available based on the
established closing schedule.  If problems occur that result in a delay in closing, the [NAME] forum group
will be notified by e-mail.
 |  | Reports are available after the 4th business day of the following month.
Fiscal month | Calendar month | Date the month end financial reports are expected to be available
01 | July 2013 | 2013-08-07 00:00:00
02 | Aug. 2013 | 2013-09-09 00:00:00
03 | Sept. 2013 | 2013-10-07 00:00:00
04 | Oct. 2013 | 2013-11-07 00:00:00
05 | Nov. 2013 | 2013-12-06 00:00:00
06 | Dec. 2013 | 2014-01-08 00:00:00
07 | Jan. 2014 | 2014-02-07 00:00:00
08 | Feb. 2014 | 2014-03-07 00:00:00
09 | March 2014 | 2014-04-07 00:00:00
10 | April 2014 | 2014-05-07 00:00:00
11 | May 2014 | 2014-06-06 00:00:00
12 | June 2014 | to be announced
To obtain month end reports, sign into [NAME], click on the "My Action Items" tab and then
"Finance Reports."
To obtain month end reporting for June 2007 and prior months, click on the link below to access
monthly Financial Records System (FRS) reports.
http://financial-info.kent.edu/
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 21 Feb 2012

Daily Morning Staff |  |  |  |  | Tuesday
 | 07:30-14:30 |  | 2012-02-21 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | Annual | Annual | EFS | Annual
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 4440 | Attendant | 08:00:00 | 14:00:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 874131d1720699940-creating-a-table-of-information-from-a-data-set-based-on-certain-criteria-excel-help
Sheet: Weekly 

 | Outstanding Paperwork
 | Week Commencing |  |  | 2523
 | Week No | Registration | Inspection required | Update / Notes?
 | 2024-01-01 00:00:00 | 123 | PMI - Paperwork Outstanding
 | 2024-01-01 00:00:00 | 456 | MOT - Paperwork Outstanding
 | 2024-01-01 00:00:00 | 987 | Tacho Calibration - Paperwork Outstanding
 | 2024-01-15 00:00:00 | 123 | MOT - Paperwork Outstanding
 | 2024-01-29 00:00:00 | DEF | [NAME]
 | 2024-02-05 00:00:00 | HIJ | Tacho Calibration - Paperwork Outstanding
Spreadsheet: eric_saibi__9870__101901R
Sheet: Ormond Beach 02

Owner Name | Reliant Energy Ormond Beach LLC
Station Name | Ormond Beach Power
Unit Name | Unit 02
NERC Region | WSCC
State | CA
Fuel Type | Natural Gas
Capacity | 806 MW
Start Date | 2001-10-05 00:00:00
End Date | 2001-10-18 00:00:00
Prv. Start Date | 2001-10-05 00:00:00
Prv. End Date | 2001-10-21 00:00:00
Comments | Unit is back on line and ramping up but is still derated
SIC | 4931
Plant ID | 1013123
Unit ID | 1006709
Outage ID | 18629
Spreadsheet: darrell_schoolcraft__7302__imball0201
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -80749 | -80287 |  |  |  |  |  |  |  | San Juan
2 | -84767 | -80299 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -84088 | -90299 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 |  |  |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 |  |  |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 |  |  |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 |  |  |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 |  |  |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10
11
12
13
14 |  |  |  |  |  | 9/1 - 9/25
15
16
17
18
19 |  |  |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 181805
2002-01-03 00:00:00
CBS Volume
 |  |  | 174403
Spreadsheet: 152657d1335463317-which-formula-would-work-new-weatherdata-automated-sheet-do-not-alter
Sheet: Upwind

 |  |  |  |  |  |  |  |  |  | START | END
 |  |  |  |  | Upwind Receptor |  |  |  |  | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 |  | Temp | Temp | Out | Wind | Wind | Wind | Wind dir |  |  | Rain
Date | Time | Out | Out | Hum | Speed | Dir | Dir | Blows | Bar | Pressure | Rate | N Component | E Component
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 780341d1652395400-converting-time-duration-to-epochs-converting-time-duration-to-epochs
Sheet: Sheet1

This year | is ↓ |  |  |  | Years | Epochs
28 |  |  |  |  |  | -16
74 |  |  |  |  |  | -15
22 |  |  |  |  |  | -14
88 |  |  |  |  |  | -13
56 |  |  |  |  |  | -12
-54 |  |  |  |  |  | -11
-89 |  |  |  |  |  | -10
-20 |  |  |  |  |  | -9
14 |  |  |  |  |  | -8
38 |  |  |  |  |  | -7
-83 |  |  |  |  |  | -6
78 |  |  |  |  |  | -5
-81 |  |  |  |  |  | -4
-66 |  |  |  |  |  | -3
36 |  |  |  |  |  | -2
46 |  |  |  |  |  | -1
84 |  |  |  |  |  | 0
-36 |  |  |  |  |  | 1
69 |  |  |  |  |  | 2
73 |  |  |  |  |  | 3
15 |  |  |  |  |  | 4
-54 |  |  |  |  |  | 5
60 |  |  |  |  |  | 6
-63 |  |  |  |  |  | 7
-61 |  |  |  |  |  | 8
-59 |  |  |  |  |  | 9
-41 |  |  |  |  |  | 10
46 |  |  |  |  |  | 11
88 |  |  |  |  |  | 12
75 |  |  |  |  |  | 13
-7 |  |  |  |  |  | 14
-22 |  |  |  |  |  | 15
-35 |  |  |  |  |  | 16
-63
31
55
-11
-25
85
32
32
67
-49
27
-59
-77
52
86
44
0
-28
91
81
-44
16
92
-46
40
40
-2
2
40
62
-89
-26
2
-13
64
36
47
61
-49
45
-44
-29
-81
71
-62
-25
-44
36
-40
10
30
-17
-34
2
-12
62
25
31
-5
-49
-64
-56
-30
58
-28
87
9
Spreadsheet: 065e8c94-3b65-4ec6-aa58-5e68778e6033
Sheet: Sheet1

Unnamed: 0 | SSMP Participating Lenders | phone | email | contact person
1 | Acceptance Capital (mg) | [PHONE] | [EMAIL] | Madlyn Gaspard
2 | Acceptance Capital (cj) | [PHONE] | [EMAIL] | [NAME]
3 | Ace Mortgage | [PHONE] | [EMAIL] | [NAME]
4 | America's Mortgage Resource | [PHONE] | [EMAIL] | [NAME]
5 | Assurance Financial Group | [PHONE] | [EMAIL] | [NAME]
6 | Bayou Equity | [PHONE] | [EMAIL] | [NAME]
7 | Bourgeois Mortgage | [PHONE] | [EMAIL] | Wardell Bourgeois
8 | Capital One Bank | [PHONE] | [EMAIL] | [NAME]
9 | Chase Bank | [PHONE] | [EMAIL] | [NAME]
10 | Eustis Mortgage | [PHONE] | [EMAIL] | [NAME]
11 | Fidelity Homestead | [PHONE] | [EMAIL] | [NAME]
12 | Fifth District Savings Bank | [PHONE] | [EMAIL] | [NAME]
13 | First NBC | [PHONE] | [EMAIL] | [NAME]
14 | Georgetown Mortgage | [PHONE] | [EMAIL] | [NAME]
15 | Gulf Coast Bank | [PHONE] | [EMAIL] | [NAME]
16 | Habitat for Humanity | [PHONE] x248 | [EMAIL] | [NAME]
17 | Hibernia Bank | [PHONE] | [EMAIL] | [NAME]
18 | Home 1st Lending | [PHONE] | [EMAIL] | [NAME], Jr.
19 | Hope Credit Union | [PHONE] | [EMAIL] | [NAME]
20 | Iberia Bank | [PHONE] | [EMAIL] | [NAME]
21 | Liberty Bank | [PHONE] | [EMAIL] | [NAME]
22 | Service First Mortgage Loans | [PHONE] | [EMAIL] | [NAME]
23 | Southern Mutual Financial Services | [PHONE] | [EMAIL] | [NAME]
24 | Southwest Funding | [PHONE] | [EMAIL] | [NAME]
25 | Sunwest Mortgage | [PHONE] | [EMAIL] | [NAME]
26 | Wells Fargo | [PHONE] | [EMAIL] | [NAME]
27 | Whitney Bank | [PHONE] | [EMAIL] | [NAME]
28 | Crosscountry Mortgage | [PHONE] | [EMAIL] | [NAME]
 | Premier Lending, LLC | [PHONE] | [EMAIL] | [NAME]
 | Peeples Lending Services | [PHONE] | [EMAIL] | [NAME]
 | Affluent Home Loan | [PHONE] | [EMAIL] | [NAME]
Spreadsheet: a1e3a25e-32a9-4bf4-aa72-952d7477a2db
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
APR | Test | APR | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday, 9 a.m.-8 p.m., Saturday 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
APR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
APR | Result | APR | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7091-2
Spreadsheet: 129624d1321752606-sum-number-on-specific-date-gj
Sheet: Total Vendas - Stock Produtos

Sales
Date | Product |  |  | Stock Produtos
2011-11-03 00:00:00 | 4.2 |  |  | Data | [NAME] |  |  | In F6 I wish to subtract the value F4 to B:B from the date in E4 (Equal or higher date)
2011-11-06 00:00:00 | 3.9 |  |  | 2011-11-14 00:00:00 | 28.65 |  |  | All my clients has a different sheet. Stock products is part of a overview sheet.
2011-10-02 00:00:00 |  |  |  | Unidade | 7.004889975550122 |  |  | I am aware of linking possibilities. Im only interested in the actual formula.
2011-10-05 00:00:00 |  |  |  | Current Stock
2011-10-09 00:00:00 | 7.5
2011-10-14 00:00:00
2011-10-20 00:00:00
2011-10-22 00:00:00
2011-10-26 00:00:00 | 4.166
2011-10-30 00:00:00
2011-11-10 00:00:00 | 4.058
2011-11-14 00:00:00 | 4.142
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R38

Ime artikla
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: BIOL

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | A.S. Degree Biology | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | BIOL 100 | 1 | X | 1 | X | 1 | X | 1
5 | BIOL 119 | 1
5 | BIOL 123 | 1 | X | 1
5 | BIOL 130 | 1 | X | 1
5 | BIOL 131 | 1 | X | 1
5 | BIOL 246AB | 1
5 | BIOL 247AB | 1
5 | BIOL 248AB | 1
 | TOTAL
 | PERCENTAGE