tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862777d1710404784-like-vlookup-but-with-concatenate-results-sample-of-excel-aligw
Sheet: Sheet1

 |  |  |  |  | Account Description | Note
All amounts in NOK 1000 | Note | 2023-03-01 00:00:00 |  |  | Sales revenues | 2.1
Sales revenues |  | 238001.45254 |  |  | Other operating income | 2.2
Other operating income |  | 50446.37224 |  |  | Other revenues | 2.2
Other revenues |  | 51020.1236 |  |  | Revenues | 1.5
Revenues |  | 239467.94838 |  |  | Cost of sales | 2.3
Cost of sales |  | 181987.24508 |  |  | Gross profit | 1.5
Gross profit |  | 107480.7033 |  |  | [NAME] and personnel expenses | 2.4
[NAME] and personnel expenses |  | 126332.75118 |  |  | Other operating expenses | 2.5
Other operating expenses |  | 135409.27006 |  |  | Impairment losses | 2.6
Impairment losses |  | 50027.2359 |  |  | Operating expenses | 1.5
Operating expenses |  | 211769.25714 |  |  | EBITDA | 1.5
EBITDA |  | -54288.55383999999 |  |  | Depreciation and amortisation | 3.2
Depreciation and amortisation |  | 83488.31904 |  |  | EBIT | 1.5
EBIT |  | -87776.87288000001 |  |  | Financial income | 2.7
Financial income |  | 53341.85239 |  |  | Financial expense | 2.7
Financial expense |  | 51942.5634 |  |  | Taxes | 2.8
Net Financial items |  | 51399.28899 |  |  | Depreciation and amortisation | 3.3 | Changed 'z' to 's'.
Profit before tax |  | -86377.58389000001 |  |  | Depreciation and amortisation | 3.4
Taxes |  | 49426.1191
Net result |  | -85803.70298999999
Spreadsheet: 159540d1338737338-time-calculations-when-going-over-the-midnight-heads
Sheet: Sheet1

 | STAFF AVAILABILITY
 | HEADS | FROM | TO |  | 07:00:00 | 07:10:00 | 07:20:00 | 07:30:00 | 07:40:00 | 07:50:00 | 08:00:00 | 08:10:00 | 08:20:00 | 08:30:00 | 08:40:00 | 08:50:00 | 09:00:00 | 09:10:00 | 09:20:00 | 09:30:00 | 09:40:00 | 09:50:00 | 10:00:00 | 10:10:00 | 10:20:00 | 10:30:00 | 10:40:00 | 10:50:00 | 11:00:00 | 11:10:00 | 11:20:00 | 11:30:00 | 11:40:00 | 11:50:00 | 12:00:00 | 12:10:00 | 12:20:00 | 12:30:00 | 12:40:00 | 12:50:00 | 13:00:00 | 13:10:00 | 13:20:00 | 13:30:00 | 13:40:00 | 13:50:00 | 14:00:00 | 14:10:00 | 14:20:00 | 14:30:00 | 14:40:00 | 14:50:00 | 15:00:00 | 15:10:00 | 15:20:00 | 15:30:00 | 15:40:00 | 15:50:00 | 16:00:00 | 16:10:00 | 16:20:00 | 16:30:00 | 16:40:00 | 16:50:00 | 17:00:00 | 17:10:00 | 17:20:00 | 17:30:00 | 17:40:00 | 17:50:00 | 18:00:00 | 18:10:00 | 18:20:00 | 18:30:00 | 18:40:00 | 18:50:00 | 19:00:00 | 19:10:00 | 19:20:00 | 19:30:00 | 19:40:00 | 19:50:00 | 20:00:00 | 20:10:00 | 20:20:00 | 20:30:00 | 20:40:00 | 20:50:00 | 21:00:00 | 21:10:00 | 21:20:00 | 21:30:00 | 21:40:00 | 21:50:00 | 22:00:00 | 22:10:00 | 22:20:00 | 22:30:00 | 22:40:00 | 22:50:00 | 23:00:00 | 23:10:00 | 23:20:00 | 23:30:00 | 23:40:00 | 23:50:00 | 1900-01-01 00:00:00 | 1900-01-01 00:10:00 | 1900-01-01 00:20:00 | 1900-01-01 00:30:00 | 1900-01-01 00:40:00 | 1900-01-01 00:50:00 | 1900-01-01 01:00:00 | 1900-01-01 01:10:00 | 1900-01-01 01:20:00 | 1900-01-01 01:30:00 | 1900-01-01 01:40:00 | 1900-01-01 01:50:00 | 1900-01-01 02:00:00 | 1900-01-01 02:10:00 | 1900-01-01 02:20:00 | 1900-01-01 02:30:00 | 1900-01-01 02:40:00 | 1900-01-01 02:50:00 | 1900-01-01 03:00:00 | 1900-01-01 03:10:00 | 1900-01-01 03:20:00 | 1900-01-01 03:30:00 | 1900-01-01 03:40:00 | 1900-01-01 03:50:00 | 1900-01-01 04:00:00 | 1900-01-01 04:10:00 | 1900-01-01 04:20:00 | 1900-01-01 04:30:00 | 1900-01-01 04:40:00 | 1900-01-01 04:50:00 | 1900-01-01 05:00:00 | 1900-01-01 05:10:00 | 1900-01-01 05:20:00 | 1900-01-01 05:30:00 | 1900-01-01 05:40:00 | 1900-01-01 05:50:00 | 1900-01-01 06:00:00 | 1900-01-01 06:10:00 | 1900-01-01 06:20:00 | 1900-01-01 06:30:00 | 1900-01-01 06:40:00 | 1900-01-01 06:50:00 | 1900-01-01 07:00:00
 | 15 | 07:00:00 | 19:00:00
 | 10 | 19:00:00 | 07:00:00
 | 12 | 07:00:00 | 15:00:00
 | 8 | 15:00:00 | 23:00:00
 | 15 | 23:00:00 | 07:00:00
 | 6 | 09:00:00 | 15:00:00
 |  |  |  | TOTAL
Spreadsheet: 709067d1608144183-report-values-between-2-sheets-cerca-vert-partic
Sheet: Sheet1

 |  |  |  |  | MS | CENTRO
 |  |  |  |  | ABC1 | ITALIA
 |  |  |  |  | ABC1 | FRANCIA
 |  |  |  |  | ABC1 | GERMANIA
 |  |  |  |  | [NAME] | ITALIA
 |  |  |  |  | [NAME] | FRANCIA
 |  |  |  |  | [NAME] | SPAGNA
 |  |  |  |  | [NAME] | SPAGNA
 |  |  |  |  | [NAME] | SPAGNA
 |  |  |  |  | ABC5 | FRANCIA
 |  |  |  |  | DSC1 | SPAGNA
 |  |  |  |  | DSC1 | FRANCIA
 |  |  |  |  | DSC1 | FRANCIA
 |  |  |  |  | DSC1 | SPAGNA
 |  |  |  |  | DSC2 | SPAGNA
 |  |  |  |  | DSC2 | SPAGNA
 |  |  |  |  | EFG1 | SPAGNA
 |  |  |  |  | EFG1 | SPAGNA
 |  |  |  |  | EFG2 | ITALIA
 |  |  |  |  | EFG2 | FRANCIA
 |  |  |  |  | EFG3 | FRANCIA
Spreadsheet: 183897ba-4cbd-41c1-8e33-b0769752c2d9
Sheet: Sheet1

Unnamed: 0 | 2000 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | 2010 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15
 | Total Housing Units, 2000 | Occupied Housing Units |  | Vacant Housing Units (Rent or Sale) |  | Vacant Housing Units (Seasonal/Migrant/Other) |  |  | Total Housing Units, 2010 | Occupied Housing Units |  | Vacant Housing Units (Rent or Sale) |  | Vacant Housing Units (Seasonal/Migrant/Other)
County |  | Occupied Housing Units, 2000 | Percent of Total | Vacant (Rent or Sale), 2000 | Percent of Total | Vacant (Seasonal/ Migrant/Other), 2000 | Percent of Total |  |  | Occupied Housing Units, 2010 | Percent of Total | Vacant (Rent or Sale), 2010 | Percent of Total | Vacant (Seasonal/ Migrant/Other), 2010 | Percent of Total
Cook County | 2096121 | 1974181 | 0.941825877418336 | 76295 | 0.03639818502844063 | 45645 | 0.02177593755322331 |  | 2180359 | 1966356 | 0.9018496495301921 | 134038 | 0.06147519743308327 | 79965 | 0.03667515303672469
DuPage County | 335621 | 325601 | 0.9701448955816233 | 7146 | 0.02129187386963271 | 2874 | 0.00856323054874397 |  | 356179 | 337132 | 0.9465240791849042 | 13817 | 0.03879229263937515 | 5230 | 0.01468362817572063
Kane County | 138998 | 133901 | 0.9633304076317645 | 3622 | 0.02605792889106318 | 1475 | 0.01061166347717233 |  | 182047 | 170479 | 0.9364559701615517 | 7948 | 0.04365905507918285 | 3620 | 0.01988497475926546
Kendall County | 19519 | 18798 | 0.9630616322557508 | 532 | 0.02725549464624212 | 189 | 0.00968287309800707 |  | 40321 | 38022 | 0.9429825649165448 | 1569 | 0.03891272537883485 | 730 | 0.01810470970462042
Lake County | 225919 | 216297 | 0.9574095140293645 | 5451 | 0.02412811671439764 | 4171 | 0.01846236925623786 |  | 260310 | 241712 | 0.928554415888748 | 10655 | 0.0409319657331643 | 7943 | 0.03051361837808766
McHenry County | 92908 | 89403 | 0.9622745081155551 | 2001 | 0.02153743488181857 | 1504 | 0.01618805700262626 |  | 116040 | 109199 | 0.9410461909686315 | 4017 | 0.03461737331954499 | 2824 | 0.02433643571182351
Will County | 175524 | 167542 | 0.9545247373578541 | 5611 | 0.03196713839702833 | 2371 | 0.01350812424511748 |  | 237501 | 225256 | 0.9484423223481164 | 7412 | 0.03120828964930674 | 4833 | 0.02034938800257683
7-County Region Total | 3084610 | 2925723 | 0.9484904088361251 | 100658 | 0.0326323262908439 | 58229 | 0.01887726487303095 |  | 3372757 | 3088156 | 0.9156176979248727 | 179456 | 0.05320750946480876 | 105145 | 0.0311747926103185
Spreadsheet: 700135d1602992003-formula-to-extract-numbers-from-within-a-cell-book1-1-
Sheet: Sheet2

Column1.1 | Column1.2 | Column1.3
21 | 3 | 1
12 | 18 | 2
5 | 16 | 0
20 | 3 | 1
22 | 6 | 0
9 | 17 | 0
Spreadsheet: 201476d1356006105-validation-of-table-form-data-with-single-input-validate-tabulated-data
Sheet: Sheet1

 | Validate data tabulated below in B3- after selection pertiular die I want to get all direct materials data tabulated below in sample table 1, 2 &3. please help me to do so
 | Die 1235
 | Table 1
 | Die 1235 | Direct materials
 | Sr. No | item code | Description | bill of material per assembly | rate | cunsumption per month | pending po quantity
 | 1 | item 1 | aa | 2 | 20 | 25 | 50
 | 2 | item 2 | bb | 0.8 | 15 | 30 | 10
 | 3 | item 3 | cc | 5 | 10 | 120 | 90
 | 4 | item 4 | dd | 16 | 65 | 90 | 40
 | Table 2
 | Die 6789
 | Sr. No | item code | Description | bill of material per assembly | rate | cunsumption per month | pending po quantity
 | 1 | item 9 | ee | 0.5 | 20 | 25 | 200
 | 2 | item 13 | ff | 0.1 | 150.5 | 30 | 60
 | 3 | item 1 | aa | 6 | 20 | 120 | 50
 | 4 | item 2 | cc | 3 | 10 | 90 | 90
 | Table 3
 | Die 9812
 | Sr. No | item code | Description | bill of material per assembly | rate | cunsumption per month | pending po quantity
 | 1 | item 12 | gg | 0.5 | 600 | 300 | 600
 | 2 | item 13 | ff | 0.1 | 150.5 | 540 | 60
 | 3 | item 7 | hh | 6 | 60 | 120 | 50
 | 4 | item 5 | ii | 3 | 0.45 | 90 | 90
 | Die 1235
 | Die 6789
 | Die 9812
Spreadsheet: 1d250c4a-3eb1-4813-ba20-e5174062c998
Sheet: Family

Common Family/Relative Categories - Poland
 |  | Visa for dependant of  EU or EFTA country citizen | "Other purposes" visa | Residence permit for family members
Criteria | Applicability? | Dependants of EU or EFTA country citizen. | Family members of Employee's coming to work in Poland. | Family members  of Employees intending to stay in Poland after expiry of their visa.
 | Quota or [NAME]? | No | No | No
 | Government Processing Time?* | Typically up to 15 days | Typically up to 15 days | 4 - 8 weeks
 | Maximum Initial Period of Stay? | 1 year | 1 year | 3 years
 | Registration Requirements on [NAME]? | Registration of temporary stay within 4 days from arrival | Registration of temporary stay within 4 days from arrival | Registration of temporary stay within 4 days from arrival
 | [NAME]? | The dependant must demonstrate that they have the means necessary to support their stay in Poland. | The dependant must demonstrate that they have the means necessary to support their stay in Poland. | Yes, the dependant must demonstrate that they have secured an acommodation.
 | Academic Qualifications Required? | No | No | No
 | [NAME]? | No | No | No
 | Previous Employment Requirements? | No | No | No
 | Does it lead to Settlement/Permanent Residence/Citizenship? | Yes - period of stay on the basis of a visa counts towards the period of legal stay required to apply for permanent residence, and later on for citizenship. | Yes - period of stay on the basis of a visa counts towards the period of legal stay required to apply for permanent residence, and later on for citizenship. | Yes - period of stay on the basis of this residence permit counts towards the period of legal stay required to apply for permanent residence, and later on for citizenship.
 | Are There Grounds That Render Applicants Ineligible? | Yes, the grounds of ineligibility for visas and residence permits involve inter alia criminal record in Poland for intentionally committed crimes, as well as grounds subject to broad discretion of authorities, e.g. posing a therat to the national security or public order.
 | Are Waivers for Ineligibility Possible? | Yes, the consul has the discretion to disapply certain ineligibility conditions when deciding on the visa. As regards residence permits - no.
 | Timing for [NAME]? | N/A
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: AE

 | Janurary |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges
 |  |  |  |  |  |  |  |  |  | Total
 | American Express |  |  |  |  |  |  |  |  | Prior Year
 | Month | Day | Transaction | Category | Description | Subcategory | Amount | Paid
Spreadsheet: 106005d1303240070-productivity-percentage-formula-april-2011-1
Sheet: Sheet1

Weekly Productivity: 4/4/2011 - 4/8/2011
Dates: | Monday | Tuesday | Wednesday | Thursday | Friday | Totals
Billable Hours | 5.75 | 5.75 | 4.15 | 4.75 | 0 | 20.4
Regular Hours Worked | 9 | 9 | 7 | 5 | 4 | 34
% | 0.6388888888888888 | 0.6388888888888888 | 0.5928571428571429 | 0.95 | 0 | 0.6
Billable Hours Scheduled |  |  |  |  |  | 0
Training Hours |  |  |  |  |  | 0
Out of Office (including travel) |  |  |  |  |  | 0
No Shows |  |  |  |  |  | 0
Cancellations |  |  |  |  |  | 0
Number of closures completed |  |  |  |  |  | 0
Weekly Productivity: 4/11/2011 - 4/15/2011
Dates: | Monday | Tuesday | Wednesday | Thursday | Friday | Totals
Billable Hours | 3 | 5 | 3.15 | 1 | 1.25 | 13.4
Regular Hours Worked | 5 | 9 | 7 | 1 | 5 | 27
% | 0.6 | 0.5555555555555556 | 0.45 | 1 | 0.25 | 0.4962962962962963
Billable Hours Scheduled |  |  |  |  |  | 0
Training Hours |  |  |  |  |  | 0
Out of Office (including travel) |  |  |  |  |  | 0
No Shows |  |  |  |  |  | 0
Cancellations |  |  |  |  |  | 0
Number of closures completed |  |  |  |  |  | 0
Weekly Productivity:
Dates: | Monday | Tuesday | Wednesday | Thursday | Friday | Totals
Billable Hours |  |  |  |  |  | 0
Regular Hours Worked |  |  |  |  |  | 0
% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Billable Hours Scheduled |  |  |  |  |  | 0
Training Hours |  |  |  |  |  | 0
Out of Office (including travel) |  |  |  |  |  | 0
No Shows |  |  |  |  |  | 0
Number of closures completed |  |  |  |  |  | 0
Weekly Productivity:
Dates: | Monday | Tuesday | Wednesday | Thursday | Friday | Totals
Billable Hours |  |  |  |  |  | 0
Regular Hours Worked |  |  |  |  |  | 0
% | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Billable Hours Scheduled |  |  |  |  |  | 0
Training Hours |  |  |  |  |  | 0
Out of Office (including travel) |  |  |  |  |  | 0
No Shows |  |  |  |  |  | 0
Cancellations |  |  |  |  |  | 0
Number of closures completed |  |  |  |  |  | 0
Spreadsheet: 76867d1277350328-convert-text-to-numbers-test-balance-sheet
Sheet: Sheet1

Reporting period | Comparison period | Absolute | Rel | Sumtn
(01.2010-06.2010) | (01.2009-06.2009) | difference | dif | level
30,802.07 | 30,537.00 | 265.07 | 0.9
37,000.00 | 0.00 | 37,000.00
67,802.07 | 30,537.00 | 37,265.07 | 122.0 | *5*
3,102,269.11 | 3,065,572.80 | 36,696.31 | 1.2
3,102,269.11 | 3,065,572.80 | 36,696.31 | 1.2 | *5*
3,170,071.18 | 3,096,109.80 | 73,961.38 | 2.4 | *4*
4,166.67 | 224,459.85 | 220,293.18- | 98.1-
77.59 | 11,053.44 | 10,975.85- | 99.3-
4,244.26 | 235,513.29 | 231,269.03- | 98.2- | *5*
21,016.62 | 91,259.73 | 70,243.11- | 77.0-
21,016.62 | 91,259.73 | 70,243.11- | 77.0- | *5*
25,260.88 | 326,773.02 | 301,512.14- | 92.3- | *4*
[NAME] | 2,920.20 | 1,939.80 | 66.4
[NAME] | 2,920.20 | 1,939.80 | 66.4 | *5*
[NAME] | 2,920.20 | 1,939.80 | 66.4 | *4*
155,261.07 | 213,240.80 | 57,979.73- | 27.2-
155,261.07 | 213,240.80 | 57,979.73- | 27.2- | *4*
3,355,453.13 | 3,639,043.82 | 283,590.69- | 7.8- | *3*
1,628,951.25 | 1,779,575.24 | 150,623.99- | 8.5-
[NAME] | 0.00 | 629,872.00
4,000,000.00 | 4,000,000.00 | 0.00
6,258,823.25 | 5,779,575.24 | 479,248.01 | 8.3 | *4*
4,514,354.55 | 4,514,354.55 | 0.00
805,785.55- | 662,540.55- | 143,245.00- | 21.6-
3,708,569.00 | 3,851,814.00 | 143,245.00- | 3.7- | *5*
70,122.00 | 71,016.53 | 894.53- | 1.3-
7,649.00- | 5,939.53- | 1,709.47- | 28.8-
62,473.00 | 65,077.00 | 2,604.00- | 4.0- | *5*
456,564.76 | 456,564.76 | 0.00
455,453.76- | 454,999.76- | 454.00- | 0.1-
1,111.00 | 1,565.00 | 454.00- | 29.0- | *5*
3,772,153.00 | 3,918,456.00 | 146,303.00- | 3.7- | *4*
10,030,976.25 | 9,698,031.24 | 332,945.01 | 3.4 | *3*
13,386,429.38 | 13,337,075.06 | 49,354.32 | 0.4 | *2*
571.23 | 283.75 | 287.48 | 101.3
741.66 | 0.00 | 741.66
37,265.95- | 85,899.40- | 48,633.45 | 56.6
8,149.11 | 13,359.40 | 5,210.29- | 39.0-
2,650.54- | 6,762.00- | 4,111.46 | 60.8
24,300.00- | 8,100.00- | 16,200.00- | 200.0-
0.00 | 20,156.85- | 20,156.85 | 100.0
0.00 | 10,616.07- | 10,616.07 | 100.0
344.85 | 344.85 | 0.00
54,409.64- | 117,546.32- | 63,136.68 | 53.7 | *5*
22.00- | 22.00- | 0.00
668,531.79- | 648,006.24- | 20,525.55- | 3.2-
668,553.79- | 648,028.24- | 20,525.55- | 3.2- | *5*
722,963.43- | 765,574.56- | 42,611.13 | 5.6 | *4*
722,963.43- | 765,574.56- | 42,611.13 | 5.6 | *3*
722,963.43- | 765,574.56- | 42,611.13 | 5.6 | *2*
12,663,465.95 | 12,571,500.50 | 91,965.45 | 0.7 | *1*
Spreadsheet: 863701d1711102476-info-from-one-sheet-to-another-it-services-stock-control-aligw
Sheet: Building Assets Demo

Asset Log
Floor | Classroom No. | P2222H | P2227H | Epson Projector | Casio Projector | Dell Dock | Surface Dock | VIA Connect Pro | VIA Go 2 | Dell OptiPlex 3090
 | Inventory IDs: | ITS001 | ITS002 | ITS005 | ITS018 | ITS029 | ITS030 | ITS068 | ITS069 | ITS103
G | A17 | 10
1 | A102
1 | A112
2 | A208 |  | 5 | 5
2 | A209
3 | A306 |  |  |  | 5
4 | A401
4 | A106
5 | A501
 | Total |  |  | 5
Spreadsheet: 31124d1226904746-conditional-formulas-haxmania4
Sheet: Sheet1

DATE | INVOICE NO. | PRODUCT |  | QTY. | RATE (1% VAT) | EXT | 0.01 | RATE (4% VAT) | EXT | 0.04 | RATE (0% VAT) | EXT | TOTAL
2008-11-01 00:00:00 | 1 | KG |  | 2 |  | 0 | 0 | 399 | 798 | 31.92 |  | 0 | 829.92
 | 2 | KG |  | 1 |  | 0 | 0 |  | 0 | 0 | 2950 | 2950 | 2950
 | 3 | LK |  | 3 |  | 0 | 0 | 3269 | 9807 | 392.28 |  | 0 | 10199.28
 | 4 | RK1 |  | 1 |  | 0 | 0 | 1106 | 1106 | 44.24 |  | 0 | 1150.24
 | 5 | RK2 |  | 1 |  | 0 | 0 | 2019 | 2019 | 80.76 |  | 0 | 2099.76
 | 6 | RK3 |  | 1 |  | 0 | 0 | 3462 | 3462 | 138.48 |  | 0 | 3600.48
 | 7 |  |  |  |  | 0 | 0 |  | 0 | 0 |  | 0 | 0
Spreadsheet: 855687d1705190602-updating-a-calendar-from-dates-test-calendar-v1-taflorida-
Sheet: February

 |  |  | FEBRUARY
 |  |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
2
0
2
Spreadsheet: 78730d1279054034-date-and-time-question-timeshift
Sheet: Sheet1

12:56:14 | Shift 1
03:25:45 | Shift 1
19:54:09 | Shift 2
13:35:24 | Shift 2
22:22:07 | Shift 3
14:09:52 | Shift 2
03:32:44 | Shift 1
15:59:46 | Shift 2
02:20:39 | Shift 1
17:20:49 | Shift 2
Spreadsheet: 150583d1334608456-combining-several-worksheets-into-one-invoices
Sheet: HI BAR

 |  |  |  |  |  | XXXXX Latin America
 |  |  |  |  |  | 355 Alhambra Circle
 |  |  |  |  |  | Suite 1400
April 6, 2012 |  |  |  |  |  | Coral Gables, FL  33134
Ref. No.: | 060412- | H
Freight Forwarder: |  |  |  |  | Ship To:
TROPICAL SHIPPING |  |  |  |  | HANSCHELL INNISS
9505 N.W. 108TH AVENUE |  |  |  |  | [NAME] ROAD
MEDLEY, FL  33178 |  |  |  |  | ST. MICHELLE
 |  |  |  |  | BARBADOS
ATTN: HANSCHELL INNISS - BARBADOS |  |  |  |  | WEST INDIES
TELE: (305) 805-7472
 |  |  |  |  | ATTN:  MR. NIGEL BLACKETT
 |  |  |  |  | TELE: (246) 230-2398
Boxes | SKU | Description |  |  |  | Value | TOTAL US$
10 | 97215 | [NAME] (5/carton) |  |  |  | 3.5
 | TOTAL |  |  |  |  | TOTAL
 | [NAME]
Spreadsheet: 114054d1309922651-formula-to-create-a-random-date-essay-practice-schedule
Sheet: Sheet1

Exam / Year / Question | Question | Date
July 2001 / 1 |  | 2011-07-11 00:00:00
July 2001 / 2 |  | 2011-07-11 00:00:00
July 2001 / 3 |  | 2011-07-11 00:00:00
July 2001 / 4 |  | 2012-07-12 00:00:00
July 2001 / 5 |  | 2012-07-12 00:00:00
July 2001 / 6 |  | 2012-07-12 00:00:00
Feb 2002 / 1 |  | 2011-07-13 00:00:00
Feb 2002 / 2 |  | 2011-07-13 00:00:00
Feb 2002 / 3 |  | 2011-07-13 00:00:00
Feb 2002 / 4 |  | 2011-07-14 00:00:00
Feb 2002 / 5 |  | 2011-07-14 00:00:00
Feb 2002 / 6 |  | 2011-07-14 00:00:00
July 2002 / 1 |  | 2011-07-15 00:00:00
July 2002 / 2 |  | 2011-07-15 00:00:00
July 2002 / 3 |  | 2011-07-15 00:00:00
July 2002 / 4 |  | 2011-07-16 00:00:00
July 2002 / 5 |  | 2011-07-16 00:00:00
July 2002 / 6 |  | 2011-07-16 00:00:00
July 2003 / 1 |  | 2011-07-17 00:00:00
July 2003 / 2 |  | 2011-07-17 00:00:00
July 2003 / 3 |  | 2011-07-17 00:00:00
July 2003 / 4 |  | 2011-07-18 00:00:00
July 2003 / 5 |  | 2011-07-18 00:00:00
July 2003 / 6 |  | 2011-07-18 00:00:00
Feb 2004 / 1 |  | 2011-07-19 00:00:00
Feb 2004 / 2 |  | 2011-07-19 00:00:00
Feb 2004 / 3 |  | 2011-07-19 00:00:00
Feb 2004 / 4 |  | 2011-07-20 00:00:00
Feb 2004 / 5 |  | 2011-07-20 00:00:00
Feb 2004 / 6 |  | 2011-07-20 00:00:00
July 2004 / 1 |  | 2011-07-21 00:00:00
July 2004 / 2 |  | 2011-07-21 00:00:00
July 2004 / 3 |  | 2011-07-21 00:00:00
July 2004 / 4 |  | 2011-07-22 00:00:00
July 2004 / 5 |  | 2011-07-22 00:00:00
July 2004 / 6 |  | 2011-07-22 00:00:00
Feb 2005 / 1 |  | 2011-07-23 00:00:00
Feb 2005 / 2 |  | 2011-07-23 00:00:00
Feb 2005 / 3 |  | 2011-07-23 00:00:00
Feb 2005 / 4 |  | 2011-07-24 00:00:00
Feb 2005 / 5 |  | 2011-07-24 00:00:00
Feb 2005 / 6 |  | 2011-07-24 00:00:00
July 2006 / 1 |  | 2011-07-25 00:00:00
July 2006 / 2 |  | 2011-07-25 00:00:00
July 2006 / 3 |  | 2011-07-25 00:00:00
July 2006 / 4
July 2006 / 5
July 2006 / 6
Feb 2007 / 1
Feb 2007 / 2
Feb 2007 / 3
Feb 2007 / 4
Feb 2007 / 5
Feb 2007 / 6
July 2007 / 1
July 2007 / 2
July 2007 / 3
July 2007 / 4
July 2007 / 5
July 2007 / 6
Feb 2008 / 1
Feb 2008 / 2
Feb 2008 / 3
Feb 2008 / 4
Feb 2008 / 5
Feb 2008 / 6
July 2008 / 1
July 2008 / 2
July 2008 / 3
July 2008 / 4
July 2008 / 5
July 2008 / 6
Feb 2009 / 1
Feb 2009 / 2
Feb 2009 / 3
Feb 2009 / 4
Feb 2009 / 5
Feb 2009 / 6
July 2009 / 1
July 2009 / 2
July 2009 / 3
July 2009 / 4
July 2009 / 5
July 2009 / 6
Feb 2010 / 1
Feb 2010 / 2
Feb 2010 / 3
Feb 2010 / 4
Feb 2010 / 5
Feb 2010 / 6
July 2010 / 1
July 2010 / 2
July 2010 / 3
July 2010 / 4
July 2010 / 5
July 2010 / 6
Feb 2011 / 1
Feb 2011 / 2
Feb 2011 / 3
Feb 2011 / 4
Feb 2011 / 5
Feb 2011 / 6
Spreadsheet: 84234d1284241547-sumif-for-monthly-a-p-payable-schedule
Sheet: Sheet1

 |  |  | 30/10/2010
 |  | 2010 |  |  |  | 2011
 |  | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | January | February | March | April | May | June | July | August | September
 |  | 2010 |  |  |  | 2011
 |  | September | October | November | December | January | February | March | April | May | June | July | August | September | Total
 |  | 1500 | 1500 | 1500 |  | 1500 | 1500 | 1500 | 1500 | 1500 |  | 1500 | 1500 | 1500
 | A/P Schedule
 | Item | Amount | starting date | Number of payments | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd | 23rd | 24th | 25th | 26th | 27th | 28th | 29th | 30th | 31st | 32nd | 33rd | 34th | 35th | 36th
 | easyjet | 96 | 2010-09-08 00:00:00 | 3
 | a | 150 | 2010-10-09 00:00:00 | 8
 | b | 133 | 2011-05-08 00:00:00 | 35
 | clothes | 1500 | 2011-01-11 00:00:00 | 10
 | etc | 800 | 2010-12-12 00:00:00 | 12
Spreadsheet: 327998d1403760633-find-the-last-occurrence-of-a-value-in-multiple-columns-or-a-matrix-lastoccurrence
Sheet: Sheet2

 |  |  |  | Hymn # | Title | [NAME] (date) | # of Times Sung
 |  |  |  | 19
 |  |  |  | 21
 |  |  |  | 92
 |  |  |  | 93
 |  |  |  | 94
 |  |  |  | 96
 |  |  |  | 107
 |  |  |  | 140
 |  |  |  | 141
 |  |  |  | 144
 |  |  |  | 146
 |  |  |  | 169
 |  |  |  | 170
 |  |  |  | 190
 |  |  |  | 191
 |  |  |  | 192
 |  |  |  | 193
 |  |  |  | 194
 |  |  |  | 195
 |  |  |  | 197
 |  |  |  | 202
 |  |  |  | 205
 |  |  |  | 207
 |  |  |  | 208
 |  |  |  | 209
 |  |  |  | 210
 |  |  |  | 211
 |  |  |  | 212
 |  |  |  | 213
 |  |  |  | 229
 |  |  |  | 231
 |  |  |  | 237
Spreadsheet: 870437d1716953521-help-with-a-lookup-and-sequencing-issue-copy-of-2024_05_20_so_s_test-2-
Sheet: Sheet 2

FO | MAX PART-NUMBER | MAX JOB-QTY | IM-MOLD | MAX OPERATION | AVE J0.WIPHL.Opendays | Scan-DATE | MAX Today
80304710 | 5678 | 5050 | ALPJ-A | 100 |  | 2024-05-20 00:00:00 | 2024-05-21 00:00:00
80304711 | 5678 | 5050 | ALPJ-A | 100 |  | 2024-05-20 00:00:00 | 2024-05-21 00:00:00
80304961 | 5678 | 5050 | ALPJ-A | 200 |  | 2024-04-28 00:00:00 | 2024-05-21 00:00:00
80305238 | 5678 | 5050 | ALPJ-A | 200 |  | 2024-04-29 00:00:00 | 2024-05-21 00:00:00
80305240 | 5678 | 5200 | ALPJ-A | 200 |  | 2024-04-30 00:00:00 | 2024-05-21 00:00:00
80305241 | 5678 | 5200 | ALPJ-A | 200 |  | 2024-05-01 00:00:00 | 2024-05-21 00:00:00
80306901 | 12345 | 155 | AJMM-A | 400 |  | 2024-05-16 00:00:00 | 2024-05-21 00:00:00
80307037 | 12345 | 2000 | AJMM-A | 100 |  | 2024-05-17 00:00:00 | 2024-05-21 00:00:00
80307038 | 12345 | 950 | AJMM-A | 100 |  | 2024-05-17 00:00:00 | 2024-05-21 00:00:00